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,
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,
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,