APPS.PA_PURGE_COSTING dependencies on PA_EXPEND_ITEM_ADJ_ACT_S

Line 2831: Select Pa_Expend_Item_Adj_Act_s.nextval

2827: x_MRC_NoOfRecordsIns);
2828: END IF;
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

Line 2985: Select Pa_Expend_Item_Adj_Act_s.nextval

2981: end if ;
2982:
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';

Line 2988: -- l_request_id := Pa_Expend_Item_Adj_Act_s.nextval ;

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
2992: ( expenditure_item_id,

Line 3600: Select Pa_Expend_Item_Adj_Act_s.nextval

3596: END IF;
3597: END IF;
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 ' ;

Line 3603: -- l_request_id := Pa_Expend_Item_Adj_Act_s.nextval ;

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
3607: insert into Pa_Expend_item_Adj_Activities