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
- 5384 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
What do you understand by oracle forms and why are they required?
Is it possible to execute a dynamic sql from forms?
all steps of bitmap report?
What is an oracle report? List its various types.
Why oracle forms required?
In what sequence do triggers get fired by oracle forms?
did u p prepared complex report
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
what is difference between group above and group left report
Is it possible to have multiple layouts in a report?
what exactly u write in when_new_form_instance
What is a canvas in oracle forms?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
