DBA Data[Home] [Help]

APPS.PA_PURGE_PJR_TXNS dependencies on PA_CANDIDATES_AR

Line 1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;

1754: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
1755:
1756: IF p_archive_flag='Y' THEN
1757:
1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;
1759: x_err_stage := 'Inserting Records into pa_candidates_AR table for candidate id '||to_char(l_candidate_id) ;
1760:
1761: INSERT INTO PA_CANDIDATES_AR
1762: ( PURGE_BATCH_ID,

Line 1759: x_err_stage := 'Inserting Records into pa_candidates_AR table for candidate id '||to_char(l_candidate_id) ;

1755:
1756: IF p_archive_flag='Y' THEN
1757:
1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;
1759: x_err_stage := 'Inserting Records into pa_candidates_AR table for candidate id '||to_char(l_candidate_id) ;
1760:
1761: INSERT INTO PA_CANDIDATES_AR
1762: ( PURGE_BATCH_ID,
1763: PURGE_RELEASE,

Line 1761: INSERT INTO PA_CANDIDATES_AR

1757:
1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;
1759: x_err_stage := 'Inserting Records into pa_candidates_AR table for candidate id '||to_char(l_candidate_id) ;
1760:
1761: INSERT INTO PA_CANDIDATES_AR
1762: ( PURGE_BATCH_ID,
1763: PURGE_RELEASE,
1764: PURGE_PROJECT_ID,
1765: CANDIDATE_ID,