eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_UINST_INTS

Line 3627: igs_uc_uinst_ints with record status N

3623: /******************************************************************
3624: Created By : smaddali
3625: Date Created By : 11-Jun-03
3626: Purpose : loads each record in the hercules view uvinstitution into the interface table
3627: igs_uc_uinst_ints with record status N
3628: Known limitations,enhancements,remarks:
3629: Change History
3630: Who When What
3631: ***************************************************************** */

Line 3712: UPDATE igs_uc_uinst_ints SET record_status = 'O' WHERE record_status = 'N' ;

3708: -- set x_sync_read to true if the loop is entered even once
3709: g_sync_reqd := TRUE;
3710:
3711: -- Obsolete all records in interface table with status N
3712: UPDATE igs_uc_uinst_ints SET record_status = 'O' WHERE record_status = 'N' ;
3713:
3714: -- copy hercules record into interface table with record status N
3715: INSERT INTO igs_uc_uinst_ints ( updater,
3716: insttype,

Line 3715: INSERT INTO igs_uc_uinst_ints ( updater,

3711: -- Obsolete all records in interface table with status N
3712: UPDATE igs_uc_uinst_ints SET record_status = 'O' WHERE record_status = 'N' ;
3713:
3714: -- copy hercules record into interface table with record status N
3715: INSERT INTO igs_uc_uinst_ints ( updater,
3716: insttype,
3717: instshortname,
3718: instname,
3719: instfullname,

Line 10442: igs_uc_uinst_ints with record status N

10438: /******************************************************************
10439: Created By : smaddali
10440: Date Created By : 11-Jun-03
10441: Purpose : loads each record in the hercules view uvinstitution into the interface table
10442: igs_uc_uinst_ints with record status N
10443: Known limitations,enhancements,remarks:
10444: Change History
10445: Who When What
10446: ***************************************************************** */

Line 10528: UPDATE igs_uc_uinst_ints SET record_status = 'O' WHERE record_status = 'N' ;

10524: -- set x_sync_read to true if the loop is entered even once
10525: g_sync_reqd := TRUE;
10526:
10527: -- Obsolete all records in interface table with status N
10528: UPDATE igs_uc_uinst_ints SET record_status = 'O' WHERE record_status = 'N' ;
10529:
10530: -- copy hercules record into interface table with record status N
10531: INSERT INTO igs_uc_uinst_ints ( updater,
10532: insttype,

Line 10531: INSERT INTO igs_uc_uinst_ints ( updater,

10527: -- Obsolete all records in interface table with status N
10528: UPDATE igs_uc_uinst_ints SET record_status = 'O' WHERE record_status = 'N' ;
10529:
10530: -- copy hercules record into interface table with record status N
10531: INSERT INTO igs_uc_uinst_ints ( updater,
10532: insttype,
10533: instshortname,
10534: instname,
10535: instfullname,