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
- 6191 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
what is oracle forms?
all steps of bitmap report?
What is an oracle report?
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 i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
what is the difference between call_form, new_form and open_form?
Is it possible to have multiple layouts in a report?
What is a matrix report and how many minimum groups are required to prepare the same?
List out the oracle forms configuration files?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
did u received a single file or multiple files
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...
What is responsibility and how u attach How to create user and how u attach with responsibility.
