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
- 6146 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
how do u place it in required folder
What is the difference between BPA AND Contract What are documents and test cases u followed
what is the difference between call_form, new_form and open_form?
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
In what sequence do triggers get fired by oracle forms?
Explain how one can iterate through items and records in a specified block?
What is the difference between bind and lexical parameter?
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
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
what is a package n what r the packages availbla in report
what is difference between group above and group left report
Explain the different levels at which oracle form services interact.
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
if u want to delete all these detail block etc what will happen in form
