Please tell me what is wrong in the below query: (Very Urgent) ===============

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;

Question Posted / keerthana

2 Answers
6210 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Please tell me what is wrong in the below query: (Very Urgent) ===================================..

Answer / hari

else if body is not correct.

Is This Answer Correct ?

2 Yes

0 No

Please tell me what is wrong in the below query: (Very Urgent) ===================================..

Answer / sudipta santra

The function will be like that:-

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 or aiv.INVOICE_DATE between
:from_invoice_date and :to_invoice_date then
aiv.PERIOD_NMAE:=<insert value>
end if;

return (TRUE);
end;

Like that way it will be solved. In else part the assigned
value should be fixed how it would between two range of date?

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Forms Reports Interview Questions

Is it possible to have multiple layouts in a report?

0 Answers

Error_Code is a package proecdure ?

1 Answers

what is tripstop report?

0 Answers

Where is the external query executed at the client or the server?

2 Answers Wipro,

What is coordination Event?

1 Answers

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...

0 Answers IBM,

Can you have more than one content canvas view attached with a window?

2 Answers TCS,

What is the use of Validation triggers in Reports?

2 Answers GE,

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

0 Answers

What does an on-clear-block Trigger fire?

1 Answers

HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT QUERY OR MULTIPLE GROUP QUERY ?

1 Answers Jaguar, TCS,

if some data is not transfered where it will get stored

0 Answers

For more Oracle Forms Reports Interview Questions Click Here