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


Please Help Members By Posting Answers For Below Questions

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1482


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

843


What is a user exit program in oracle reports?

575


What do you understand by lov and how can it be used?

577


what are the new features introduced in oracle form services in 11g release 2?

582






what exactly u write in when_new_form_instance

2900


Why oracle forms required?

563


In what sequence do triggers get fired by oracle forms?

539


What is an SQL FORMS ?

2312


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

1598


HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1091


Explain the different levels at which oracle form services interact.

607


Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

1861


What is an oracle report?

606


What do you understand by oracle forms and why are they required?

555