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;
- 2 Answers
- 6201 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
What does TKPROF stand for?
what are bind variables?
if some data is not transfered where it will get stored
What are the default extensions of the files careated by forms modules?
What are User Exits and what are different types of User Exits in Oracle Apps ?
What are the types of visual attribute settings?
in compatibility in report registration?
Is it possible to set a filter condition in a cross product group in matrix reports?
Can you attach an alert to a field?
what is the source file of po report?
What is bind reference and how can it carate?
What do you understand by lov?
Oracle General 
