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 are bind variables?
What do you understand by lov and how can it be used?
did u p prepared complex report
Can we invoke one form from another in a multi-forms application?
how report can be generated if we have the database designed in oracle 10g?
What is an SQL FORMS ?
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
Is it possible to have multiple layouts in a report?
what is tripstop report?
Is it possible to execute a dynamic sql from forms?
List the different types of columns in oracle reports.
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables