DBA Data[Home] [Help]

APPS.PA_PURGE_PJR_TXNS dependencies on PA_SCHEDULES_AR

Line 1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;

1339: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
1340:
1341: IF p_archive_flag='Y' THEN
1342:
1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;
1344: x_err_stage := 'Inserting Records into pa_schedules_AR table for schedule id '||to_char(l_schedule_id) ;
1345:
1346: INSERT INTO PA_SCHEDULES_AR
1347: (PURGE_BATCH_ID,

Line 1344: x_err_stage := 'Inserting Records into pa_schedules_AR table for schedule id '||to_char(l_schedule_id) ;

1340:
1341: IF p_archive_flag='Y' THEN
1342:
1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;
1344: x_err_stage := 'Inserting Records into pa_schedules_AR table for schedule id '||to_char(l_schedule_id) ;
1345:
1346: INSERT INTO PA_SCHEDULES_AR
1347: (PURGE_BATCH_ID,
1348: PURGE_RELEASE,

Line 1346: INSERT INTO PA_SCHEDULES_AR

1342:
1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;
1344: x_err_stage := 'Inserting Records into pa_schedules_AR table for schedule id '||to_char(l_schedule_id) ;
1345:
1346: INSERT INTO PA_SCHEDULES_AR
1347: (PURGE_BATCH_ID,
1348: PURGE_RELEASE,
1349: PURGE_PROJECT_ID,
1350: SCHEDULE_ID,