Please tell me what is wrong in the below query:
(Very Urgent)
=================================================
function BeforePForm return boolean is
begin
if :from_invoice_date is null OR :to_invoice_date is
null then
aiv.PERIOD_NMAE:=:gl_period
elsif :gl_period is null then
aiv.INVOICE_DATE between :from_invoice_date
and :to_invoice_date
end if;
return (TRUE);
end;
Answer Posted / hari
else if body is not correct.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is oracle forms?
how report can be generated if we have the database designed in oracle 10g?
a text item is there what r the different types of triggers associated with it
What is a matrix report and how many minimum groups are required to prepare the same?
List out the oracle forms configuration files?
how do u place it in required folder
Is it possible to have multiple layouts in a report?
hiding item in report how like that properly,thats manually but at runtime i want to do
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
if u want to delete all these detail block etc what will happen in form
Can we invoke one form from another in a multi-forms application?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
List the different types of columns in oracle reports.
What do you understand by oracle forms?