Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

what is oracle forms?

1096


how report can be generated if we have the database designed in oracle 10g?

1865


a text item is there what r the different types of triggers associated with it

1992


What is a matrix report and how many minimum groups are required to prepare the same?

1114


List out the oracle forms configuration files?

1054


how do u place it in required folder

1910


Is it possible to have multiple layouts in a report?

1011


hiding item in report how like that properly,thats manually but at runtime i want to do

3213


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

1662


if u want to delete all these detail block etc what will happen in form

1967


Can we invoke one form from another in a multi-forms application?

1111


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

1439


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.

2209


List the different types of columns in oracle reports.

979


What do you understand by oracle forms?

1017