489:
490: l_rowid := NULL;
491:
492: l_last_update_date := SYSDATE;
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 (
490: l_rowid := NULL;
491:
492: l_last_update_date := SYSDATE;
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,
9247:
9248: --jchakrab - added for 4006205 - replace TBH insert_row() with direct DML call
9249: --set values for WHO columns for all fields
9250: l_last_update_date := SYSDATE;
9251: l_last_updated_by := NVL(fnd_global.user_id,-1);
9252: l_last_update_login := NVL(fnd_global.login_id,-1);
9253:
9254: -- Populate each field for the Student / Combined / Module record
9255: WHILE l_index IS NOT NULL
9248: --jchakrab - added for 4006205 - replace TBH insert_row() with direct DML call
9249: --set values for WHO columns for all fields
9250: l_last_update_date := SYSDATE;
9251: l_last_updated_by := NVL(fnd_global.user_id,-1);
9252: l_last_update_login := NVL(fnd_global.login_id,-1);
9253:
9254: -- Populate each field for the Student / Combined / Module record
9255: WHILE l_index IS NOT NULL
9256: LOOP