APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_EXT_RUN_INTERIM

Line 10611: FROM igs_he_ext_run_interim

10607: unit_cd,
10608: uv_version_number,
10609: student_inst_number,
10610: line_number
10611: FROM igs_he_ext_run_interim
10612: WHERE extract_run_id = p_extract_run_id;
10613:
10614: l_line_number igs_he_ex_rn_dat_ln.line_number%TYPE;
10615: l_he_ex_rn_dat_ln igs_he_ex_rn_dat_ln%ROWTYPE;

Line 10852: DELETE FROM igs_he_ext_run_interim WHERE ext_interim_id = l_rec_list(l_rec_cnt);

10848: write_to_log(SQLERRM);
10849: ROLLBACK;
10850: -- Delete the records processed before raising the exception
10851: FOR l_rec IN 0 .. l_rec_cnt -1 LOOP
10852: DELETE FROM igs_he_ext_run_interim WHERE ext_interim_id = l_rec_list(l_rec_cnt);
10853: END LOOP;
10854: -- Commit the Delete Records as they are already processed successfully
10855: COMMIT;
10856: -- Raise The exception

Line 10860: -- Delete the records from igs_he_ext_run_interim of the current Run ID, p_extract_run_id

10856: -- Raise The exception
10857: App_Exception.Raise_Exception;
10858: END;
10859:
10860: -- Delete the records from igs_he_ext_run_interim of the current Run ID, p_extract_run_id
10861: -- The direct Delete Statement is used against the standards because of performance improvement only.
10862: -- Same issue was fixed in IGSHE9AB.pls for bug,3179585
10863: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;
10864:

Line 10863: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;

10859:
10860: -- Delete the records from igs_he_ext_run_interim of the current Run ID, p_extract_run_id
10861: -- The direct Delete Statement is used against the standards because of performance improvement only.
10862: -- Same issue was fixed in IGSHE9AB.pls for bug,3179585
10863: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;
10864:
10865: END IF;
10866:
10867: EXCEPTION