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 2833: from dual ;

2829: END IF;
2830:
2831: Select Pa_Expend_Item_Adj_Act_s.nextval
2832: into l_request_id
2833: from dual ;
2834:
2835: FORALL exp_ind IN l_exp_item_id_tab.FIRST .. l_exp_item_id_tab.LAST
2836: insert into Pa_Expend_item_Adj_Activities
2837: ( expenditure_item_id,

Line 2987: from dual ;

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

Line 3602: from dual ;

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