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_ISTARX_INTS

Line 9325: igs_uc_istarx_ints with record status N

9321: /******************************************************************
9322: Created By : smaddali
9323: Date Created By : 11-Jun-03
9324: Purpose : loads each record in the hercules view ivstarx into the interface table
9325: igs_uc_istarx_ints with record status N
9326: Known limitations,enhancements,remarks:
9327: Change History
9328: Who When What
9329: ***************************************************************** */

Line 9356: l_appno igs_uc_istarx_ints.appno%TYPE;

9352: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9353: l_new_max_timestamp igs_uc_ivstarx_2003_v.timestamp%TYPE ;
9354: l_count NUMBER ;
9355:
9356: l_appno igs_uc_istarx_ints.appno%TYPE;
9357: l_checkdigit NUMBER;
9358:
9359: BEGIN
9360: -- set syncronization required to false

Line 9383: UPDATE igs_uc_istarx_ints SET record_status = 'O'

9379: -- Determine actual appno
9380: get_appno(c_ivstarx_rec.appno, NULL, l_appno, l_checkdigit);
9381:
9382: -- Obsolete matching records in interface table with status N
9383: UPDATE igs_uc_istarx_ints SET record_status = 'O'
9384: WHERE record_status = 'N' AND appno = l_appno ;
9385:
9386: -- copy hercules record into interface table with record status N
9387: INSERT INTO igs_uc_istarx_ints ( appno,

Line 9387: INSERT INTO igs_uc_istarx_ints ( appno,

9383: UPDATE igs_uc_istarx_ints SET record_status = 'O'
9384: WHERE record_status = 'N' AND appno = l_appno ;
9385:
9386: -- copy hercules record into interface table with record status N
9387: INSERT INTO igs_uc_istarx_ints ( appno,
9388: ethnic,
9389: pocceduchangedate,
9390: socialclass,
9391: pocc,

Line 9455: igs_uc_istarx_ints with record status N

9451: /******************************************************************
9452: Created By : jbaber
9453: Date Created By : 16-Aug-05
9454: Purpose : loads each record in the hercules view ivgstarx into the interface table
9455: igs_uc_istarx_ints with record status N
9456: Known limitations,enhancements,remarks:
9457: Change History
9458: Who When What
9459: ***************************************************************** */

Line 9480: l_appno igs_uc_istarx_ints.appno%TYPE;

9476: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9477: l_new_max_timestamp igs_uc_ivgstarx_2006_v.timestamp%TYPE ;
9478: l_count NUMBER ;
9479:
9480: l_appno igs_uc_istarx_ints.appno%TYPE;
9481: l_checkdigit NUMBER;
9482:
9483: BEGIN
9484: -- set syncronization required to false

Line 9507: UPDATE igs_uc_istarx_ints SET record_status = 'O'

9503: -- Determine actual appno
9504: get_appno(c_ivgstarx_rec.appno, NULL, l_appno, l_checkdigit);
9505:
9506: -- Obsolete matching records in interface table with status N
9507: UPDATE igs_uc_istarx_ints SET record_status = 'O'
9508: WHERE record_status = 'N' AND appno = l_appno ;
9509:
9510: -- copy hercules record into interface table with record status N
9511: INSERT INTO igs_uc_istarx_ints ( appno,

Line 9511: INSERT INTO igs_uc_istarx_ints ( appno,

9507: UPDATE igs_uc_istarx_ints SET record_status = 'O'
9508: WHERE record_status = 'N' AND appno = l_appno ;
9509:
9510: -- copy hercules record into interface table with record status N
9511: INSERT INTO igs_uc_istarx_ints ( appno,
9512: ethnic,
9513: record_status,
9514: error_code
9515: )

Line 9561: igs_uc_istarx_ints with record status N

9557: /******************************************************************
9558: Created By : jbaber
9559: Date Created By : 16-Aug-05
9560: Purpose : loads each record in the hercules view ivnstarx into the interface table
9561: igs_uc_istarx_ints with record status N
9562: Known limitations,enhancements,remarks:
9563: Change History
9564: Who When What
9565: ***************************************************************** */

Line 9588: l_appno igs_uc_istarx_ints.appno%TYPE;

9584: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9585: l_new_max_timestamp igs_uc_ivnstarx_2006_v.timestamp%TYPE ;
9586: l_count NUMBER ;
9587:
9588: l_appno igs_uc_istarx_ints.appno%TYPE;
9589: l_checkdigit NUMBER;
9590:
9591: BEGIN
9592: -- set syncronization required to false

Line 9615: UPDATE igs_uc_istarx_ints SET record_status = 'O'

9611: -- Determine actual appno
9612: get_appno(c_ivnstarx_rec.appno, NULL, l_appno, l_checkdigit);
9613:
9614: -- Obsolete matching records in interface table with status N
9615: UPDATE igs_uc_istarx_ints SET record_status = 'O'
9616: WHERE record_status = 'N' AND appno = l_appno ;
9617:
9618: -- copy hercules record into interface table with record status N
9619: INSERT INTO igs_uc_istarx_ints ( appno,

Line 9619: INSERT INTO igs_uc_istarx_ints ( appno,

9615: UPDATE igs_uc_istarx_ints SET record_status = 'O'
9616: WHERE record_status = 'N' AND appno = l_appno ;
9617:
9618: -- copy hercules record into interface table with record status N
9619: INSERT INTO igs_uc_istarx_ints ( appno,
9620: ethnic,
9621: dependants,
9622: married,
9623: record_status,