APPS.PA_PURGE_COSTING dependencies on PA_EXP_COMMENTS_AR

Line 955: x_err_stack := x_err_stack || ' ->Before insert into PA_EXP_COMMENTS_AR' ;

951:
952: begin
953:
954: l_old_err_stack := x_err_stack;
955: x_err_stack := x_err_stack || ' ->Before insert into PA_EXP_COMMENTS_AR' ;
956:
957: if p_archive_flag = 'Y' then
958: l_commit_size := p_commit_size/2 ;
959: else

Line 996: x_err_stage := 'PA_ExpenditureComments: Before inserting records into PA_EXP_COMMENTS_AR';

992: -- before being purged. The where condition is such that
993: -- only the it inserts half the no. of records specified
994: -- in the commit size.
995:
996: x_err_stage := 'PA_ExpenditureComments: Before inserting records into PA_EXP_COMMENTS_AR';
997:
998: FORALL exp_ind IN l_exp_comm_rowid_tab.FIRST .. l_exp_comm_rowid_tab.LAST
999: insert into PA_EXP_COMMENTS_AR
1000: (

Line 999: insert into PA_EXP_COMMENTS_AR

995:
996: x_err_stage := 'PA_ExpenditureComments: Before inserting records into PA_EXP_COMMENTS_AR';
997:
998: FORALL exp_ind IN l_exp_comm_rowid_tab.FIRST .. l_exp_comm_rowid_tab.LAST
999: insert into PA_EXP_COMMENTS_AR
1000: (
1001: expenditure_item_id,
1002: line_number,
1003: last_update_date,

Line 1054: from PA_EXP_COMMENTS_AR ecar

1050: x_err_stage := 'PA_ExpenditureComments: Before deleting records from pa_expenditure_comments';
1051: delete from pa_expenditure_comments ec
1052: where ( ec.expenditure_item_id, ec.line_number )
1053: in ( select ecar.expenditure_item_id, ecar.line_number
1054: from PA_EXP_COMMENTS_AR ecar
1055: where ecar.purge_project_id = p_project_id
1056: ) ;
1057:
1058: l_NoOfRecordsDel := SQL%ROWCOUNT ;

Line 1236: -- x_err_stack := x_err_stack || ' ->Before insert into PA_EXP_COMMENTS_AR' ;

1232:
1233:
1234: -- Commented for bug 4227589 and moved outside LOOP
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