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_ISTARN_INTS

Line 8147: igs_uc_istarn_ints with record status N

8143: /******************************************************************
8144: Created By : smaddali
8145: Date Created By : 11-Jun-03
8146: Purpose : loads each record in the hercules view ivstarn into the interface table
8147: igs_uc_istarn_ints with record status N
8148: Known limitations,enhancements,remarks:
8149: Change History
8150: Who When What
8151: ***************************************************************** */

Line 8178: l_appno igs_uc_istarn_ints.appno%TYPE;

8174: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8175: l_new_max_timestamp igs_uc_ivstarn_2003_v.timestamp%TYPE ;
8176: l_count NUMBER ;
8177:
8178: l_appno igs_uc_istarn_ints.appno%TYPE;
8179: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8180:
8181: BEGIN
8182: -- set syncronization required to false

Line 8179: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;

8175: l_new_max_timestamp igs_uc_ivstarn_2003_v.timestamp%TYPE ;
8176: l_count NUMBER ;
8177:
8178: l_appno igs_uc_istarn_ints.appno%TYPE;
8179: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8180:
8181: BEGIN
8182: -- set syncronization required to false
8183: g_sync_reqd := FALSE;

Line 8203: UPDATE igs_uc_istarn_ints SET record_status = 'O'

8199: -- Determine actual appno and checkdigit
8200: get_appno(c_ivstarn_rec.appno, c_ivstarn_rec.checkdigit, l_appno, l_checkdigit);
8201:
8202: -- Obsolete matching records in interface table with status N / I
8203: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8204: WHERE record_status = 'N' AND appno = l_appno ;
8205:
8206: -- copy hercules record into interface table with record status N
8207: INSERT INTO igs_uc_istarn_ints ( appno,

Line 8207: INSERT INTO igs_uc_istarn_ints ( appno,

8203: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8204: WHERE record_status = 'N' AND appno = l_appno ;
8205:
8206: -- copy hercules record into interface table with record status N
8207: INSERT INTO igs_uc_istarn_ints ( appno,
8208: checkdigit,
8209: namechangedate,
8210: title,
8211: forenames,

Line 8275: igs_uc_istarn_ints with record status N

8271: /******************************************************************
8272: Created By : jbaber
8273: Date Created By : 11-Jul-06
8274: Purpose : loads each record in the hercules view ivstarn into the interface table
8275: igs_uc_istarn_ints with record status N
8276: Known limitations,enhancements,remarks:
8277: Change History
8278: Who When What
8279: ***************************************************************** */

Line 8307: l_appno igs_uc_istarn_ints.appno%TYPE;

8303: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8304: l_new_max_timestamp igs_uc_ivstarn_2007_v.timestamp%TYPE ;
8305: l_count NUMBER ;
8306:
8307: l_appno igs_uc_istarn_ints.appno%TYPE;
8308: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8309:
8310: BEGIN
8311: -- set syncronization required to false

Line 8308: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;

8304: l_new_max_timestamp igs_uc_ivstarn_2007_v.timestamp%TYPE ;
8305: l_count NUMBER ;
8306:
8307: l_appno igs_uc_istarn_ints.appno%TYPE;
8308: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8309:
8310: BEGIN
8311: -- set syncronization required to false
8312: g_sync_reqd := FALSE;

Line 8332: UPDATE igs_uc_istarn_ints SET record_status = 'O'

8328: -- Determine actual appno and checkdigit
8329: get_appno(c_ivstarn_rec.appno, c_ivstarn_rec.checkdigit, l_appno, l_checkdigit);
8330:
8331: -- Obsolete matching records in interface table with status N / I
8332: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8333: WHERE record_status = 'N' AND appno = l_appno ;
8334:
8335: -- copy hercules record into interface table with record status N
8336: INSERT INTO igs_uc_istarn_ints ( appno,

Line 8336: INSERT INTO igs_uc_istarn_ints ( appno,

8332: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8333: WHERE record_status = 'N' AND appno = l_appno ;
8334:
8335: -- copy hercules record into interface table with record status N
8336: INSERT INTO igs_uc_istarn_ints ( appno,
8337: checkdigit,
8338: personalid,
8339: namechangedate,
8340: title,

Line 8406: igs_uc_istarn_ints with record status N

8402: /******************************************************************
8403: Created By : jbaber
8404: Date Created By : 16-Aug-05
8405: Purpose : loads each record in the hercules view ivgstarn into the interface table
8406: igs_uc_istarn_ints with record status N
8407: Known limitations,enhancements,remarks:
8408: Change History
8409: Who When What
8410: ***************************************************************** */

Line 8435: l_appno igs_uc_istarn_ints.appno%TYPE;

8431: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8432: l_new_max_timestamp igs_uc_ivgstarn_2006_v.timestamp%TYPE ;
8433: l_count NUMBER ;
8434:
8435: l_appno igs_uc_istarn_ints.appno%TYPE;
8436: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8437:
8438: BEGIN
8439: -- set syncronization required to false

Line 8436: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;

8432: l_new_max_timestamp igs_uc_ivgstarn_2006_v.timestamp%TYPE ;
8433: l_count NUMBER ;
8434:
8435: l_appno igs_uc_istarn_ints.appno%TYPE;
8436: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8437:
8438: BEGIN
8439: -- set syncronization required to false
8440: g_sync_reqd := FALSE;

Line 8460: UPDATE igs_uc_istarn_ints SET record_status = 'O'

8456: -- Determine actual appno and checkdigit
8457: get_appno(c_ivgstarn_rec.appno, NULL, l_appno, l_checkdigit);
8458:
8459: -- Obsolete matching records in interface table with status N / I
8460: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8461: WHERE record_status = 'N' AND appno = l_appno ;
8462:
8463: -- copy hercules record into interface table with record status N
8464: INSERT INTO igs_uc_istarn_ints ( appno,

Line 8464: INSERT INTO igs_uc_istarn_ints ( appno,

8460: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8461: WHERE record_status = 'N' AND appno = l_appno ;
8462:
8463: -- copy hercules record into interface table with record status N
8464: INSERT INTO igs_uc_istarn_ints ( appno,
8465: checkdigit,
8466: title,
8467: forenames,
8468: surname,

Line 8529: igs_uc_istarn_ints with record status N

8525: /******************************************************************
8526: Created By : jbaber
8527: Date Created By : 11-Jul-06
8528: Purpose : loads each record in the hercules view ivgstarn into the interface table
8529: igs_uc_istarn_ints with record status N
8530: Known limitations,enhancements,remarks:
8531: Change History
8532: Who When What
8533: ***************************************************************** */

Line 8559: l_appno igs_uc_istarn_ints.appno%TYPE;

8555: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8556: l_new_max_timestamp igs_uc_ivgstarn_2007_v.timestamp%TYPE ;
8557: l_count NUMBER ;
8558:
8559: l_appno igs_uc_istarn_ints.appno%TYPE;
8560: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8561:
8562: BEGIN
8563: -- set syncronization required to false

Line 8560: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;

8556: l_new_max_timestamp igs_uc_ivgstarn_2007_v.timestamp%TYPE ;
8557: l_count NUMBER ;
8558:
8559: l_appno igs_uc_istarn_ints.appno%TYPE;
8560: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8561:
8562: BEGIN
8563: -- set syncronization required to false
8564: g_sync_reqd := FALSE;

Line 8584: UPDATE igs_uc_istarn_ints SET record_status = 'O'

8580: -- Determine actual appno and checkdigit
8581: get_appno(c_ivgstarn_rec.appno, NULL, l_appno, l_checkdigit);
8582:
8583: -- Obsolete matching records in interface table with status N / I
8584: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8585: WHERE record_status = 'N' AND appno = l_appno ;
8586:
8587: -- copy hercules record into interface table with record status N
8588: INSERT INTO igs_uc_istarn_ints ( appno,

Line 8588: INSERT INTO igs_uc_istarn_ints ( appno,

8584: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8585: WHERE record_status = 'N' AND appno = l_appno ;
8586:
8587: -- copy hercules record into interface table with record status N
8588: INSERT INTO igs_uc_istarn_ints ( appno,
8589: checkdigit,
8590: personalid,
8591: title,
8592: forenames,

Line 8656: igs_uc_istarn_ints with record status N

8652: /******************************************************************
8653: Created By : jbaber
8654: Date Created By : 16-Aug-05
8655: Purpose : loads each record in the hercules view ivnstarn into the interface table
8656: igs_uc_istarn_ints with record status N
8657: Known limitations,enhancements,remarks:
8658: Change History
8659: Who When What
8660: ***************************************************************** */

Line 8685: l_appno igs_uc_istarn_ints.appno%TYPE;

8681: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8682: l_new_max_timestamp igs_uc_ivnstarn_2006_v.timestamp%TYPE ;
8683: l_count NUMBER ;
8684:
8685: l_appno igs_uc_istarn_ints.appno%TYPE;
8686: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8687:
8688: BEGIN
8689: -- set syncronization required to false

Line 8686: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;

8682: l_new_max_timestamp igs_uc_ivnstarn_2006_v.timestamp%TYPE ;
8683: l_count NUMBER ;
8684:
8685: l_appno igs_uc_istarn_ints.appno%TYPE;
8686: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8687:
8688: BEGIN
8689: -- set syncronization required to false
8690: g_sync_reqd := FALSE;

Line 8710: UPDATE igs_uc_istarn_ints SET record_status = 'O'

8706: -- Determine actual appno and checkdigit
8707: get_appno(c_ivnstarn_rec.appno, NULL, l_appno, l_checkdigit);
8708:
8709: -- Obsolete matching records in interface table with status N / I
8710: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8711: WHERE record_status = 'N' AND appno = l_appno ;
8712:
8713: -- copy hercules record into interface table with record status N
8714: INSERT INTO igs_uc_istarn_ints ( appno,

Line 8714: INSERT INTO igs_uc_istarn_ints ( appno,

8710: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8711: WHERE record_status = 'N' AND appno = l_appno ;
8712:
8713: -- copy hercules record into interface table with record status N
8714: INSERT INTO igs_uc_istarn_ints ( appno,
8715: checkdigit,
8716: title,
8717: forenames,
8718: surname,

Line 8779: igs_uc_istarn_ints with record status N

8775: /******************************************************************
8776: Created By : jbaber
8777: Date Created By : 11-Jul-06
8778: Purpose : loads each record in the hercules view ivnstarn into the interface table
8779: igs_uc_istarn_ints with record status N
8780: Known limitations,enhancements,remarks:
8781: Change History
8782: Who When What
8783: ***************************************************************** */

Line 8809: l_appno igs_uc_istarn_ints.appno%TYPE;

8805: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8806: l_new_max_timestamp igs_uc_ivnstarn_2007_v.timestamp%TYPE ;
8807: l_count NUMBER ;
8808:
8809: l_appno igs_uc_istarn_ints.appno%TYPE;
8810: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8811:
8812: BEGIN
8813: -- set syncronization required to false

Line 8810: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;

8806: l_new_max_timestamp igs_uc_ivnstarn_2007_v.timestamp%TYPE ;
8807: l_count NUMBER ;
8808:
8809: l_appno igs_uc_istarn_ints.appno%TYPE;
8810: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;
8811:
8812: BEGIN
8813: -- set syncronization required to false
8814: g_sync_reqd := FALSE;

Line 8834: UPDATE igs_uc_istarn_ints SET record_status = 'O'

8830: -- Determine actual appno and checkdigit
8831: get_appno(c_ivnstarn_rec.appno, NULL, l_appno, l_checkdigit);
8832:
8833: -- Obsolete matching records in interface table with status N / I
8834: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8835: WHERE record_status = 'N' AND appno = l_appno ;
8836:
8837: -- copy hercules record into interface table with record status N
8838: INSERT INTO igs_uc_istarn_ints ( appno,

Line 8838: INSERT INTO igs_uc_istarn_ints ( appno,

8834: UPDATE igs_uc_istarn_ints SET record_status = 'O'
8835: WHERE record_status = 'N' AND appno = l_appno ;
8836:
8837: -- copy hercules record into interface table with record status N
8838: INSERT INTO igs_uc_istarn_ints ( appno,
8839: checkdigit,
8840: personalid,
8841: title,
8842: forenames,