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.

[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_ISTARK_INTS

Line 6874: igs_uc_istark_ints with record status N

6870: /******************************************************************
6871: Created By : smaddali
6872: Date Created By : 11-Jun-03
6873: Purpose : loads each record in the hercules view ivstark into the interface table
6874: igs_uc_istark_ints with record status N
6875: Known limitations,enhancements,remarks:
6876: Change History
6877: Who When What
6878: smaddali 7-aug-03 Modified value for field EAS for bug#3087852

Line 6954: l_appno igs_uc_istark_ints.appno%TYPE;

6950: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6951: l_new_max_timestamp igs_uc_ivstark_2003_v.timestamp%TYPE ;
6952: l_count NUMBER ;
6953:
6954: l_appno igs_uc_istark_ints.appno%TYPE;
6955: l_checkdigit NUMBER;
6956:
6957: BEGIN
6958: -- set syncronization required to false

Line 6988: UPDATE igs_uc_istark_ints SET record_status = 'O'

6984: -- Determine actual appno
6985: get_appno(c_ivstark_rec.appno, NULL, l_appno, l_checkdigit);
6986:
6987: -- Obsolete matching records in interface table with status N
6988: UPDATE igs_uc_istark_ints SET record_status = 'O'
6989: WHERE record_status = 'N' AND appno = l_appno ;
6990:
6991:
6992: -- copy hercules record into interface table with record status N

Line 6993: INSERT INTO igs_uc_istark_ints ( appno,

6989: WHERE record_status = 'N' AND appno = l_appno ;
6990:
6991:
6992: -- copy hercules record into interface table with record status N
6993: INSERT INTO igs_uc_istark_ints ( appno,
6994: applicationdate,
6995: sentdate,
6996: runsent,
6997: codedchangedate,

Line 7168: igs_uc_istark_ints with record status N

7164: /******************************************************************
7165: Created By : smaddali
7166: Date Created By : 11-Jul-06
7167: Purpose : loads each record in the hercules view ivstark into the interface table
7168: igs_uc_istark_ints with record status N
7169: Known limitations,enhancements,remarks:
7170: Change History
7171: Who When What
7172: smaddali 7-aug-03 Modified value for field EAS for bug#3087852

Line 7248: l_appno igs_uc_istark_ints.appno%TYPE;

7244: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
7245: l_new_max_timestamp igs_uc_ivstark_2007_v.timestamp%TYPE ;
7246: l_count NUMBER ;
7247:
7248: l_appno igs_uc_istark_ints.appno%TYPE;
7249: l_checkdigit NUMBER;
7250:
7251: BEGIN
7252: -- set syncronization required to false

Line 7282: UPDATE igs_uc_istark_ints SET record_status = 'O'

7278: -- Determine actual appno
7279: get_appno(c_ivstark_rec.appno, NULL, l_appno, l_checkdigit);
7280:
7281: -- Obsolete matching records in interface table with status N
7282: UPDATE igs_uc_istark_ints SET record_status = 'O'
7283: WHERE record_status = 'N' AND appno = l_appno ;
7284:
7285:
7286: -- copy hercules record into interface table with record status N

Line 7287: INSERT INTO igs_uc_istark_ints ( appno,

7283: WHERE record_status = 'N' AND appno = l_appno ;
7284:
7285:
7286: -- copy hercules record into interface table with record status N
7287: INSERT INTO igs_uc_istark_ints ( appno,
7288: applicationdate,
7289: sentdate,
7290: runsent,
7291: codedchangedate,

Line 7463: igs_uc_istark_ints with record status N

7459: /******************************************************************
7460: Created By : jbaber
7461: Date Created By : 15-Aug-05
7462: Purpose : loads each record in the hercules view ivgstark into the interface table
7463: igs_uc_istark_ints with record status N
7464: Known limitations,enhancements,remarks:
7465: Change History
7466: Who When What
7467: ***************************************************************** */

Line 7503: l_appno igs_uc_istark_ints.appno%TYPE;

7499: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
7500: l_new_max_timestamp igs_uc_ivgstark_2006_v.timestamp%TYPE ;
7501: l_count NUMBER ;
7502:
7503: l_appno igs_uc_istark_ints.appno%TYPE;
7504: l_checkdigit NUMBER;
7505:
7506: BEGIN
7507: -- set syncronization required to false

Line 7534: UPDATE igs_uc_istark_ints SET record_status = 'O'

7530: -- Determine actual appno
7531: get_appno(c_ivgstark_rec.appno, NULL, l_appno, l_checkdigit);
7532:
7533: -- Obsolete matching records in interface table with status N
7534: UPDATE igs_uc_istark_ints SET record_status = 'O'
7535: WHERE record_status = 'N' AND appno = l_appno ;
7536:
7537:
7538: -- copy hercules record into interface table with record status N

Line 7539: INSERT INTO igs_uc_istark_ints ( appno,

7535: WHERE record_status = 'N' AND appno = l_appno ;
7536:
7537:
7538: -- copy hercules record into interface table with record status N
7539: INSERT INTO igs_uc_istark_ints ( appno,
7540: applicationdate,
7541: rescat,
7542: feepayer,
7543: apr,

Line 7615: igs_uc_istark_ints with record status N

7611: /******************************************************************
7612: Created By : jbaber
7613: Date Created By : 11-Jul-06
7614: Purpose : loads each record in the hercules view ivgstark into the interface table
7615: igs_uc_istark_ints with record status N
7616: Known limitations,enhancements,remarks:
7617: Change History
7618: Who When What
7619: ***************************************************************** */

Line 7655: l_appno igs_uc_istark_ints.appno%TYPE;

7651: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
7652: l_new_max_timestamp igs_uc_ivgstark_2007_v.timestamp%TYPE ;
7653: l_count NUMBER ;
7654:
7655: l_appno igs_uc_istark_ints.appno%TYPE;
7656: l_checkdigit NUMBER;
7657:
7658: BEGIN
7659: -- set syncronization required to false

Line 7686: UPDATE igs_uc_istark_ints SET record_status = 'O'

7682: -- Determine actual appno
7683: get_appno(c_ivgstark_rec.appno, NULL, l_appno, l_checkdigit);
7684:
7685: -- Obsolete matching records in interface table with status N
7686: UPDATE igs_uc_istark_ints SET record_status = 'O'
7687: WHERE record_status = 'N' AND appno = l_appno ;
7688:
7689:
7690: -- copy hercules record into interface table with record status N

Line 7691: INSERT INTO igs_uc_istark_ints ( appno,

7687: WHERE record_status = 'N' AND appno = l_appno ;
7688:
7689:
7690: -- copy hercules record into interface table with record status N
7691: INSERT INTO igs_uc_istark_ints ( appno,
7692: applicationdate,
7693: rescat,
7694: feepayer,
7695: apr,

Line 7767: igs_uc_istark_ints with record status N

7763: /******************************************************************
7764: Created By : jbaber
7765: Date Created By : 15-Aug-05
7766: Purpose : loads each record in the hercules view ivnstark into the interface table
7767: igs_uc_istark_ints with record status N
7768: Known limitations,enhancements,remarks:
7769: Change History
7770: Who When What
7771: ***************************************************************** */

Line 7817: l_appno igs_uc_istark_ints.appno%TYPE;

7813: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
7814: l_new_max_timestamp igs_uc_ivnstark_2006_v.timestamp%TYPE ;
7815: l_count NUMBER ;
7816:
7817: l_appno igs_uc_istark_ints.appno%TYPE;
7818: l_checkdigit NUMBER;
7819:
7820: l_startdate DATE;
7821:

Line 7853: UPDATE igs_uc_istark_ints SET record_status = 'O'

7849: -- Implicility convert startdate to date to avoid compile errors when pointing to DUMMY
7850: l_startdate := c_ivnstark_rec.startdate;
7851:
7852: -- Obsolete matching records in interface table with status N
7853: UPDATE igs_uc_istark_ints SET record_status = 'O'
7854: WHERE record_status = 'N' AND appno = l_appno ;
7855:
7856:
7857: -- copy hercules record into interface table with record status N

Line 7858: INSERT INTO igs_uc_istark_ints ( appno,

7854: WHERE record_status = 'N' AND appno = l_appno ;
7855:
7856:
7857: -- copy hercules record into interface table with record status N
7858: INSERT INTO igs_uc_istark_ints ( appno,
7859: applicationdate,
7860: sentdate,
7861: runsent,
7862: codedchangedate,

Line 7957: igs_uc_istark_ints with record status N

7953: /******************************************************************
7954: Created By : jbaber
7955: Date Created By : 11-Jul-06
7956: Purpose : loads each record in the hercules view ivnstark into the interface table
7957: igs_uc_istark_ints with record status N
7958: Known limitations,enhancements,remarks:
7959: Change History
7960: Who When What
7961: ***************************************************************** */

Line 8007: l_appno igs_uc_istark_ints.appno%TYPE;

8003: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8004: l_new_max_timestamp igs_uc_ivnstark_2007_v.timestamp%TYPE ;
8005: l_count NUMBER ;
8006:
8007: l_appno igs_uc_istark_ints.appno%TYPE;
8008: l_checkdigit NUMBER;
8009:
8010: l_startdate DATE;
8011:

Line 8043: UPDATE igs_uc_istark_ints SET record_status = 'O'

8039: -- Implicility convert startdate to date to avoid compile errors when pointing to DUMMY
8040: l_startdate := c_ivnstark_rec.startdate;
8041:
8042: -- Obsolete matching records in interface table with status N
8043: UPDATE igs_uc_istark_ints SET record_status = 'O'
8044: WHERE record_status = 'N' AND appno = l_appno ;
8045:
8046:
8047: -- copy hercules record into interface table with record status N

Line 8048: INSERT INTO igs_uc_istark_ints ( appno,

8044: WHERE record_status = 'N' AND appno = l_appno ;
8045:
8046:
8047: -- copy hercules record into interface table with record status N
8048: INSERT INTO igs_uc_istark_ints ( appno,
8049: applicationdate,
8050: sentdate,
8051: runsent,
8052: codedchangedate,