eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PURGE_COSTING dependencies on DUAL

Line 17: -- each of the individual tables.

13: -- Type : Public
14: -- Pre-reqs : None
15: -- Function : This procedure is the main purge procedure for costing
16: -- tables. This procedure calls a procedure that purges
17: -- each of the individual tables.
18: --
19: -- Parameters : p_batch_id IN NUMBER
20: -- The purge batch id for which rows have
21: -- to be purged/archived.

Line 2829: from dual ;

2825: END IF;
2826:
2827: Select Pa_Expend_Item_Adj_Act_s.nextval
2828: into l_request_id
2829: from dual ;
2830:
2831: FORALL exp_ind IN l_exp_item_id_tab.FIRST .. l_exp_item_id_tab.LAST
2832: insert into Pa_Expend_item_Adj_Activities
2833: ( expenditure_item_id,

Line 2983: from dual ;

2979:
2980: LOOP
2981: Select Pa_Expend_Item_Adj_Act_s.nextval
2982: into l_request_id
2983: from dual ;
2984: -- l_request_id := Pa_Expend_Item_Adj_Act_s.nextval ;
2985: x_err_stage := 'PA_ExpItemsSrcPurge: Before inserting audit records into Pa_Expend_item_Adj_Activities';
2986: if p_txn_to_date is NOT NULL then
2987: insert into Pa_Expend_item_Adj_Activities

Line 3598: from dual ;

3594:
3595: IF (nvl(l_exp_item_id_tab.LAST,0) > 0 ) THEN
3596: Select Pa_Expend_Item_Adj_Act_s.nextval
3597: into l_request_id
3598: from dual ;
3599: -- l_request_id := Pa_Expend_Item_Adj_Act_s.nextval ;
3600: x_err_stage := 'PA_ExpItemsDestPurge: Before inserting audit records ' ;
3601: /* if p_txn_to_date is NOT NULL then */
3602: FORALL l_exp_ind IN l_exp_item_id_tab.FIRST .. l_exp_item_id_tab.LAST