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_ISTARW_INTS

Line 9206: igs_uc_istarw_ints with record status N

9202: /******************************************************************
9203: Created By : smaddali
9204: Date Created By : 11-Jun-03
9205: Purpose : loads each record in the hercules view ivstarw into the interface table
9206: igs_uc_istarw_ints with record status N
9207: Known limitations,enhancements,remarks:
9208: Change History
9209: Who When What
9210: ***************************************************************** */

Line 9252: UPDATE igs_uc_istarw_ints SET record_status = 'O'

9248: -- set x_sync_read to true if the loop is entered even once
9249: g_sync_reqd := TRUE;
9250:
9251: -- Obsolete matching records in interface table with status N
9252: UPDATE igs_uc_istarw_ints SET record_status = 'O'
9253: WHERE record_status = 'N' AND appno = c_ivstarw_rec.appno ;
9254:
9255: -- copy hercules record into interface table with record status N
9256: INSERT INTO igs_uc_istarw_ints ( appno,

Line 9256: INSERT INTO igs_uc_istarw_ints ( appno,

9252: UPDATE igs_uc_istarw_ints SET record_status = 'O'
9253: WHERE record_status = 'N' AND appno = c_ivstarw_rec.appno ;
9254:
9255: -- copy hercules record into interface table with record status N
9256: INSERT INTO igs_uc_istarw_ints ( appno,
9257: miscoded,
9258: cancelled,
9259: jointadmission,
9260: choice1lost,

Line 10666: igs_uc_istarw_ints with record status N

10662: /******************************************************************
10663: Created By : smaddali
10664: Date Created By : 11-Jun-03
10665: Purpose : loads each record in the hercules view ivstarw into the interface table
10666: igs_uc_istarw_ints with record status N
10667: Known limitations,enhancements,remarks:
10668: Change History
10669: Who When What
10670: ***************************************************************** */

Line 10703: l_appno igs_uc_istarw_ints.appno%TYPE;

10699: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10700: l_new_max_timestamp igs_uc_ivstarw_2004_v.timestamp%TYPE ;
10701: l_count NUMBER ;
10702:
10703: l_appno igs_uc_istarw_ints.appno%TYPE;
10704: l_checkdigit NUMBER;
10705:
10706: BEGIN
10707: -- set syncronization required to false

Line 10728: UPDATE igs_uc_istarw_ints SET record_status = 'O'

10724: -- Determine actual appno
10725: get_appno(c_ivstarw_rec.appno, NULL, l_appno, l_checkdigit);
10726:
10727: -- Obsolete matching records in interface table with status N
10728: UPDATE igs_uc_istarw_ints SET record_status = 'O'
10729: WHERE record_status = 'N' AND appno = l_appno ;
10730:
10731: -- copy hercules record into interface table with record status N
10732: INSERT INTO igs_uc_istarw_ints ( appno,

Line 10732: INSERT INTO igs_uc_istarw_ints ( appno,

10728: UPDATE igs_uc_istarw_ints SET record_status = 'O'
10729: WHERE record_status = 'N' AND appno = l_appno ;
10730:
10731: -- copy hercules record into interface table with record status N
10732: INSERT INTO igs_uc_istarw_ints ( appno,
10733: miscoded,
10734: cancelled,
10735: jointadmission,
10736: choice1lost,

Line 10804: igs_uc_istarw_ints with record status N

10800: /******************************************************************
10801: Created By : jbaber
10802: Date Created By : 16-Aug-05
10803: Purpose : loads each record in the hercules view ivgstarw into the interface table
10804: igs_uc_istarw_ints with record status N
10805: Known limitations,enhancements,remarks:
10806: Change History
10807: Who When What
10808: ***************************************************************** */

Line 10832: l_appno igs_uc_istarw_ints.appno%TYPE;

10828: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10829: l_new_max_timestamp igs_uc_ivgstarw_2006_v.timestamp%TYPE ;
10830: l_count NUMBER ;
10831:
10832: l_appno igs_uc_istarw_ints.appno%TYPE;
10833: l_checkdigit NUMBER;
10834:
10835: BEGIN
10836: -- set syncronization required to false

Line 10857: UPDATE igs_uc_istarw_ints SET record_status = 'O'

10853: -- Determine actual appno
10854: get_appno(c_ivgstarw_rec.appno, NULL, l_appno, l_checkdigit);
10855:
10856: -- Obsolete matching records in interface table with status N
10857: UPDATE igs_uc_istarw_ints SET record_status = 'O'
10858: WHERE record_status = 'N' AND appno = l_appno ;
10859:
10860: -- copy hercules record into interface table with record status N
10861: INSERT INTO igs_uc_istarw_ints ( appno,

Line 10861: INSERT INTO igs_uc_istarw_ints ( appno,

10857: UPDATE igs_uc_istarw_ints SET record_status = 'O'
10858: WHERE record_status = 'N' AND appno = l_appno ;
10859:
10860: -- copy hercules record into interface table with record status N
10861: INSERT INTO igs_uc_istarw_ints ( appno,
10862: miscoded,
10863: cancelled,
10864: canceldate,
10865: record_status,

Line 10915: igs_uc_istarw_ints with record status N

10911: /******************************************************************
10912: Created By : jbaber
10913: Date Created By : 11-Jul-06
10914: Purpose : loads each record in the hercules view ivgstarw into the interface table
10915: igs_uc_istarw_ints with record status N
10916: Known limitations,enhancements,remarks:
10917: Change History
10918: Who When What
10919: ***************************************************************** */

Line 10944: l_appno igs_uc_istarw_ints.appno%TYPE;

10940: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10941: l_new_max_timestamp igs_uc_ivgstarw_2007_v.timestamp%TYPE ;
10942: l_count NUMBER ;
10943:
10944: l_appno igs_uc_istarw_ints.appno%TYPE;
10945: l_checkdigit NUMBER;
10946:
10947: BEGIN
10948: -- set syncronization required to false

Line 10969: UPDATE igs_uc_istarw_ints SET record_status = 'O'

10965: -- Determine actual appno
10966: get_appno(c_ivgstarw_rec.appno, NULL, l_appno, l_checkdigit);
10967:
10968: -- Obsolete matching records in interface table with status N
10969: UPDATE igs_uc_istarw_ints SET record_status = 'O'
10970: WHERE record_status = 'N' AND appno = l_appno ;
10971:
10972: -- copy hercules record into interface table with record status N
10973: INSERT INTO igs_uc_istarw_ints ( appno,

Line 10973: INSERT INTO igs_uc_istarw_ints ( appno,

10969: UPDATE igs_uc_istarw_ints SET record_status = 'O'
10970: WHERE record_status = 'N' AND appno = l_appno ;
10971:
10972: -- copy hercules record into interface table with record status N
10973: INSERT INTO igs_uc_istarw_ints ( appno,
10974: miscoded,
10975: cancelled,
10976: canceldate,
10977: remark,

Line 11029: igs_uc_istarw_ints with record status N

11025: /******************************************************************
11026: Created By : jbaber
11027: Date Created By : 16-Aug-05
11028: Purpose : loads each record in the hercules view ivnstarw into the interface table
11029: igs_uc_istarw_ints with record status N
11030: Known limitations,enhancements,remarks:
11031: Change History
11032: Who When What
11033: ***************************************************************** */

Line 11057: l_appno igs_uc_istarw_ints.appno%TYPE;

11053: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11054: l_new_max_timestamp igs_uc_ivnstarw_2006_v.timestamp%TYPE ;
11055: l_count NUMBER ;
11056:
11057: l_appno igs_uc_istarw_ints.appno%TYPE;
11058: l_checkdigit NUMBER;
11059:
11060: BEGIN
11061: -- set syncronization required to false

Line 11082: UPDATE igs_uc_istarw_ints SET record_status = 'O'

11078: -- Determine actual appno
11079: get_appno(c_ivnstarw_rec.appno, NULL, l_appno, l_checkdigit);
11080:
11081: -- Obsolete matching records in interface table with status N
11082: UPDATE igs_uc_istarw_ints SET record_status = 'O'
11083: WHERE record_status = 'N' AND appno = l_appno ;
11084:
11085: -- copy hercules record into interface table with record status N
11086: INSERT INTO igs_uc_istarw_ints ( appno,

Line 11086: INSERT INTO igs_uc_istarw_ints ( appno,

11082: UPDATE igs_uc_istarw_ints SET record_status = 'O'
11083: WHERE record_status = 'N' AND appno = l_appno ;
11084:
11085: -- copy hercules record into interface table with record status N
11086: INSERT INTO igs_uc_istarw_ints ( appno,
11087: miscoded,
11088: cancelled,
11089: canceldate,
11090: record_status,

Line 11140: igs_uc_istarw_ints with record status N

11136: /******************************************************************
11137: Created By : jbaber
11138: Date Created By : 11-Jul-06
11139: Purpose : loads each record in the hercules view ivnstarw into the interface table
11140: igs_uc_istarw_ints with record status N
11141: Known limitations,enhancements,remarks:
11142: Change History
11143: Who When What
11144: ***************************************************************** */

Line 11169: l_appno igs_uc_istarw_ints.appno%TYPE;

11165: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11166: l_new_max_timestamp igs_uc_ivnstarw_2007_v.timestamp%TYPE ;
11167: l_count NUMBER ;
11168:
11169: l_appno igs_uc_istarw_ints.appno%TYPE;
11170: l_checkdigit NUMBER;
11171:
11172: BEGIN
11173: -- set syncronization required to false

Line 11194: UPDATE igs_uc_istarw_ints SET record_status = 'O'

11190: -- Determine actual appno
11191: get_appno(c_ivnstarw_rec.appno, NULL, l_appno, l_checkdigit);
11192:
11193: -- Obsolete matching records in interface table with status N
11194: UPDATE igs_uc_istarw_ints SET record_status = 'O'
11195: WHERE record_status = 'N' AND appno = l_appno ;
11196:
11197: -- copy hercules record into interface table with record status N
11198: INSERT INTO igs_uc_istarw_ints ( appno,

Line 11198: INSERT INTO igs_uc_istarw_ints ( appno,

11194: UPDATE igs_uc_istarw_ints SET record_status = 'O'
11195: WHERE record_status = 'N' AND appno = l_appno ;
11196:
11197: -- copy hercules record into interface table with record status N
11198: INSERT INTO igs_uc_istarw_ints ( appno,
11199: miscoded,
11200: cancelled,
11201: canceldate,
11202: remark,