APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_EXT_RUN_EXCP

Line 7: g_he_ext_run_except igs_he_ext_run_excp%ROWTYPE;

3:
4: -- Variables that will be accessed by any or all the procedures
5: -- Extract related records
6: g_he_ext_run_dtls igs_he_ext_run_dtls%ROWTYPE;
7: g_he_ext_run_except igs_he_ext_run_excp%ROWTYPE;
8: g_he_submsn_return igs_he_submsn_return%ROWTYPE;
9: g_he_submsn_header igs_he_submsn_header%ROWTYPE;
10:
11: -- Student / Module related records.

Line 57: (p_he_ext_run_exceptions IN OUT NOCOPY igs_he_ext_run_excp%ROWTYPE)

53: contain the message text not the
54: message code.
55: ----------------------------------------------------------------------*/
56: PROCEDURE log_error
57: (p_he_ext_run_exceptions IN OUT NOCOPY igs_he_ext_run_excp%ROWTYPE)
58: IS
59: PRAGMA AUTONOMOUS_TRANSACTION;
60:
61: l_rowid VARCHAR2(30) := NULL;

Line 65: Igs_He_Ext_Run_Excp_Pkg.Insert_Row

61: l_rowid VARCHAR2(30) := NULL;
62:
63: BEGIN
64:
65: Igs_He_Ext_Run_Excp_Pkg.Insert_Row
66: (X_Rowid => l_rowid,
67: X_Ext_Exception_Id => p_he_ext_run_exceptions.ext_exception_id,
68: X_Extract_Run_Id => p_he_ext_run_exceptions.Extract_Run_Id,
69: X_Person_Id => p_he_ext_run_exceptions.Person_Id,

Line 986: ERROR - Igs_He_Ext_Run_Excp

982: p_table_name IN Table Name
983: Values : INTERIM - Igs_He_Ext_Run_Interim
984: LINE - Igs_He_Ex_Rn_Dat_Ln
985: FIELD - Igs_He_Ex_Rn_Dat_Fd
986: ERROR - Igs_He_Ext_Run_Excp
987: WHO: AYEDUBAT
988: WHAT: Removed the 'PROCEDURE delete_rows' as all the call to this procedure are placed
989: with direct DMLS for bug,3179585
990: ----------------------------------------------------------------------*/

Line 2498: DELETE FROM igs_he_ext_run_excp excp

2494: -- marked as requiring recalculation
2495: get_marked_rows (p_extract_run_id);
2496:
2497: -- Delete marked rows exceptions for bug 3166186
2498: DELETE FROM igs_he_ext_run_excp excp
2499: WHERE excp.extract_run_id = p_extract_run_id
2500: AND excp.line_number IN
2501: (SELECT line_number
2502: FROM igs_he_ext_run_interim

Line 2537: -- Delete from igs_he_ext_run_excp

2533:
2534: -- Delete from igs_he_ex_rn_dat_ln
2535: DELETE FROM igs_he_ex_rn_dat_ln WHERE extract_run_id = p_extract_run_id;
2536:
2537: -- Delete from igs_he_ext_run_excp
2538: DELETE FROM igs_he_ext_run_excp WHERE extract_run_id = p_extract_run_id;
2539:
2540: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2541: fnd_message.set_token('PROCEDURE', 'END_DELETE_ROWS');

Line 2538: DELETE FROM igs_he_ext_run_excp WHERE extract_run_id = p_extract_run_id;

2534: -- Delete from igs_he_ex_rn_dat_ln
2535: DELETE FROM igs_he_ex_rn_dat_ln WHERE extract_run_id = p_extract_run_id;
2536:
2537: -- Delete from igs_he_ext_run_excp
2538: DELETE FROM igs_he_ext_run_excp WHERE extract_run_id = p_extract_run_id;
2539:
2540: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2541: fnd_message.set_token('PROCEDURE', 'END_DELETE_ROWS');
2542: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));