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;
- 2 Answers
- 5067 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / hari
else if body is not correct.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
can you convert or reverse engineer a fmx back to a fmb file?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
Why oracle forms required?
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
How to create Drill down report?
Can we invoke one form from another in a multi-forms application?
What is a matrix report and how many minimum groups are required to prepare the same?
What is an oracle report? List its various types.
did u received a single file or multiple files
how report can be generated if we have the database designed in oracle 10g?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
In what sequence do triggers get fired by oracle forms?
Explain master-detail relationship with some examples.
