DBA Data[Home] [Help]

APPS.PA_PURGE_PJR_TXNS dependencies on PA_PROJECT_ASGMTS_AR

Line 2292: pa_debug.debug('Inserting Records into pa_project_asgmts_AR table ') ;

2288: FOR I in p_assignment_id_tab.FIRST .. p_assignment_id_tab.LAST LOOP
2289: l_assignment_id :=p_assignment_id_tab(I);
2290:
2291: IF p_archive_flag='Y' THEN
2292: pa_debug.debug('Inserting Records into pa_project_asgmts_AR table ') ;
2293: x_err_stage := 'Inserting Records into pa_project_asgmts_AR table for assignment id '||to_char(l_assignment_id) ;
2294:
2295: INSERT INTO PA_PROJECT_ASGMTS_AR
2296: ( PURGE_BATCH_ID,

Line 2293: x_err_stage := 'Inserting Records into pa_project_asgmts_AR table for assignment id '||to_char(l_assignment_id) ;

2289: l_assignment_id :=p_assignment_id_tab(I);
2290:
2291: IF p_archive_flag='Y' THEN
2292: pa_debug.debug('Inserting Records into pa_project_asgmts_AR table ') ;
2293: x_err_stage := 'Inserting Records into pa_project_asgmts_AR table for assignment id '||to_char(l_assignment_id) ;
2294:
2295: INSERT INTO PA_PROJECT_ASGMTS_AR
2296: ( PURGE_BATCH_ID,
2297: PURGE_RELEASE,

Line 2295: INSERT INTO PA_PROJECT_ASGMTS_AR

2291: IF p_archive_flag='Y' THEN
2292: pa_debug.debug('Inserting Records into pa_project_asgmts_AR table ') ;
2293: x_err_stage := 'Inserting Records into pa_project_asgmts_AR table for assignment id '||to_char(l_assignment_id) ;
2294:
2295: INSERT INTO PA_PROJECT_ASGMTS_AR
2296: ( PURGE_BATCH_ID,
2297: PURGE_RELEASE,
2298: PURGE_PROJECT_ID,
2299: ASSIGNMENT_ID,