APPS.IGS_HE_EXTRACT2_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 479: (p_he_ext_run_exceptions IN OUT NOCOPY igs_he_ext_run_excp%ROWTYPE)

475: jchakrab 05-FEB-2005 Modified for 4006205 - Removed Autonomous Transaction.
476: Replaced TBH call to insert_row() with direct DML.
477: ----------------------------------------------------------------------*/
478: PROCEDURE log_error
479: (p_he_ext_run_exceptions IN OUT NOCOPY igs_he_ext_run_excp%ROWTYPE)
480: IS
481:
482: l_rowid VARCHAR2(30) ;
483: l_last_update_date DATE;

Line 497: INSERT INTO igs_he_ext_run_excp (

493: l_last_updated_by := NVL(fnd_global.user_id, -1);
494: l_last_update_login := NVL(fnd_global.login_id, -1);
495:
496: --jchakrab - 4006205 - replace TBH with direct DML call
497: INSERT INTO igs_he_ext_run_excp (
498: ext_exception_id,
499: extract_run_id,
500: person_id,
501: person_number,

Line 515: igs_he_ext_run_excp_s.NEXTVAL,

511: last_update_date,
512: last_updated_by,
513: last_update_login
514: ) VALUES (
515: igs_he_ext_run_excp_s.NEXTVAL,
516: p_he_ext_run_exceptions.Extract_Run_Id,
517: p_he_ext_run_exceptions.Person_Id,
518: p_he_ext_run_exceptions.Person_Number,
519: p_he_ext_run_exceptions.Course_Cd,