Answer Posted / bighnaraj dalai

Pre-Query is Used For Doing Proper Validation Before Any Query Related Operation .
Example:=

DECLARE
V_Where VARCHAR2(50);
V_OrderBy VARCHAR(100);
BEGIN
V_Where := 'Deptno = '||:CONTROLBLOCK.QUERYDEPT;
V_OrderBy := :CONTROLBLOCK.DATASORTGROUP||' '||:CONTROLBLOCK.SORTORDERGROUP;
SET_BLOCK_PROPERTY ('EMPBLOCK', DEFAULT_WHERE, V_Where);
SET_BLOCK_PROPERTY ('EMPBLOCK', ORDER_BY, V_OrderBy);
END;


Post-Query is Used For Doing The Tax After validation is complete


Example:=
INSERT INTO SCOTT.QueryAudit@ORCL
VALUES(1, USER, USERENV('TERMINAL'), TO_DATE(TO_CHAR(SYSDATE, 'DD-MON-YYYY'), 'DD-MON-YYYY'), TO_DATE(TO_CHAR(SYSDATE, 'HH:MI:SS'), 'HH:MI:SS'));

Pre-Insert is doing the tax before insert into the database


Example:=
MESSAGE('Pre Insert Trigger Fired...');
MESSAGE(' ');
SELECT EmpIncr.NEXTVAL
INTO :EMPBLOCK.Empno
FROM SYS.DUAL;
:GLOBAL.GENEmpno := :EMPBLOCK.Empno;
Post-Insert is Fired After The Data Insert Into The database
The Pre-insert And Post-Insert Helps For No Null Value Taken Even We Take Any Sequence In my Coading Because If There is no Proper validation Then The Raise Form_Trigger_Failure Trigger Terminate The Application


Hiiii friend if you Want To Take The .FMB File For This Program Or any Related Query Then Contact To Me
My Email_Id := bighnaraj.dalai@gmail.com

difference between global n context sensitive segments?

2630

---

what is tripstop report?

1761

---

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

2065

---

Name the different triggers supported by oracle reports and their firing order.

1022

---

did u received a single file or multiple files

1971

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1927

---

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1410

---

What is a matrix report and how many minimum groups are required to prepare the same?

1060

---

what are the new features introduced in oracle form services in 11g release 2?

980

---

List the different types of columns in oracle reports.

937

---

Explain the various types of oracle report?

1024

---

what exactly u write in when_new_form_instance

3378

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1089

---

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

2136

---

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

2858

---