APPS.PA_PURGE_COSTING dependencies on PA_EXP_ITEM_ADJ_ACT_AR

Line 1239: x_err_stage := 'PA_ExpendItemAdjActivities: Before inserting records into PA_EXP_ITEM_ADJ_ACT_AR';

1235: -- l_old_err_stack := x_err_stack;
1236: -- x_err_stack := x_err_stack || ' ->Before insert into PA_EXP_COMMENTS_AR' ;
1237: If l_exp_adj_rowid_tab.last is not null Then
1238: if p_archive_flag = 'Y' then
1239: x_err_stage := 'PA_ExpendItemAdjActivities: Before inserting records into PA_EXP_ITEM_ADJ_ACT_AR';
1240: FORALL exp_ind IN l_exp_adj_rowid_tab.FIRST .. l_exp_adj_rowid_tab.LAST
1241: insert into PA_EXP_ITEM_ADJ_ACT_AR
1242: (
1243: expenditure_item_id,

Line 1241: insert into PA_EXP_ITEM_ADJ_ACT_AR

1237: If l_exp_adj_rowid_tab.last is not null Then
1238: if p_archive_flag = 'Y' then
1239: x_err_stage := 'PA_ExpendItemAdjActivities: Before inserting records into PA_EXP_ITEM_ADJ_ACT_AR';
1240: FORALL exp_ind IN l_exp_adj_rowid_tab.FIRST .. l_exp_adj_rowid_tab.LAST
1241: insert into PA_EXP_ITEM_ADJ_ACT_AR
1242: (
1243: expenditure_item_id,
1244: activity_date,
1245: last_update_date,

Line 1302: insert into PA_EXP_ITEM_ADJ_ACT_AR

1298: and rownum < p_commit_size
1299: ) ;
1300:
1301: else
1302: insert into PA_EXP_ITEM_ADJ_ACT_AR
1303: (
1304: expenditure_item_id,
1305: activity_date,
1306: last_update_date,

Line 1362: from PA_EXP_ITEM_ADJ_ACT_AR eiar

1358: x_err_stage := 'PA_ExpendItemAdjActivities: Before deleting records from pa_expend_item_adj_activities';
1359: delete from pa_expend_item_adj_activities eia
1360: where (eia.expenditure_item_id, eia.activity_date ) in
1361: ( select eiar.expenditure_item_id, eiar.activity_date
1362: from PA_EXP_ITEM_ADJ_ACT_AR eiar
1363: where eiar.purge_project_id = p_project_id
1364: ) ;
1365:
1366: l_NoOfRecordsDel := SQL%ROWCOUNT ;