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_ISTMNT_INTS

Line 10048: igs_uc_istmnt_ints with record status N

10044: /******************************************************************
10045: Created By : smaddali
10046: Date Created By : 11-Jun-03
10047: Purpose : loads each record in the hercules view ivstatement into the interface table
10048: igs_uc_istmnt_ints with record status N
10049: Known limitations,enhancements,remarks:
10050: Change History
10051: Who When What
10052: ***************************************************************** */

Line 10085: UPDATE igs_uc_istmnt_ints SET record_status = 'O'

10081: -- set x_sync_read to true if the loop is entered even once
10082: g_sync_reqd := TRUE;
10083:
10084: -- Obsolete matching records in interface table with status N
10085: UPDATE igs_uc_istmnt_ints SET record_status = 'O'
10086: WHERE record_status = 'N' AND appno = c_stmt_appno_rec.appno;
10087:
10088: -- copy hercules record into interface table with record status N
10089: c_stmt_rec := NULL ;

Line 10093: INSERT INTO igs_uc_istmnt_ints ( appno,

10089: c_stmt_rec := NULL ;
10090: OPEN c_stmt( c_stmt_appno_rec.appno);
10091: FETCH c_stmt INTO c_stmt_rec ;
10092: CLOSE c_stmt ;
10093: INSERT INTO igs_uc_istmnt_ints ( appno,
10094: statement,
10095: record_status,
10096: error_code
10097: )

Line 10132: igs_uc_istmnt_ints with record status N

10128: /******************************************************************
10129: Created By : smaddali
10130: Date Created By : 18-Aug-03
10131: Purpose : loads each record in the hercules view ivstatement into the interface table
10132: igs_uc_istmnt_ints with record status N
10133: Known limitations,enhancements,remarks:
10134: Change History
10135: Who When What
10136: smaddali 18-aug-03 Modified to load based on the timestamp field in hercules vew for bug#3098810

Line 10156: l_appno igs_uc_istmnt_ints.appno%TYPE;

10152: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10153: l_new_max_timestamp igs_uc_ivstatement_2004_v.timestamp%TYPE ;
10154: l_count NUMBER ;
10155:
10156: l_appno igs_uc_istmnt_ints.appno%TYPE;
10157: l_checkdigit NUMBER;
10158:
10159: BEGIN
10160: -- set syncronization required to false

Line 10181: UPDATE igs_uc_istmnt_ints SET record_status = 'O'

10177: -- Determine actual appno
10178: get_appno(c_stmt_rec.appno, NULL, l_appno, l_checkdigit);
10179:
10180: -- Obsolete matching records in interface table with status N
10181: UPDATE igs_uc_istmnt_ints SET record_status = 'O'
10182: WHERE record_status = 'N' AND appno = l_appno;
10183:
10184:
10185: -- copy hercules record into interface table with record status N

Line 10186: INSERT INTO igs_uc_istmnt_ints ( appno,

10182: WHERE record_status = 'N' AND appno = l_appno;
10183:
10184:
10185: -- copy hercules record into interface table with record status N
10186: INSERT INTO igs_uc_istmnt_ints ( appno,
10187: statement,
10188: record_status,
10189: error_code
10190: )

Line 10236: igs_uc_istmnt_ints with record status N

10232: /******************************************************************
10233: Created By : jbaber
10234: Date Created By : 16-Aug-05
10235: Purpose : loads each record in the hercules view ivgstatement into the interface table
10236: igs_uc_istmnt_ints with record status N
10237: Known limitations,enhancements,remarks:
10238: Change History
10239: Who When What
10240: ***************************************************************** */

Line 10259: l_appno igs_uc_istmnt_ints.appno%TYPE;

10255: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10256: l_new_max_timestamp igs_uc_ivgstatement_2006_v.timestamp%TYPE ;
10257: l_count NUMBER ;
10258:
10259: l_appno igs_uc_istmnt_ints.appno%TYPE;
10260: l_checkdigit NUMBER;
10261:
10262: BEGIN
10263: -- set syncronization required to false

Line 10284: UPDATE igs_uc_istmnt_ints SET record_status = 'O'

10280: -- Determine actual appno
10281: get_appno(c_stmt_rec.appno, NULL, l_appno, l_checkdigit);
10282:
10283: -- Obsolete matching records in interface table with status N
10284: UPDATE igs_uc_istmnt_ints SET record_status = 'O'
10285: WHERE record_status = 'N' AND appno = l_appno;
10286:
10287:
10288: -- copy hercules record into interface table with record status N

Line 10289: INSERT INTO igs_uc_istmnt_ints ( appno,

10285: WHERE record_status = 'N' AND appno = l_appno;
10286:
10287:
10288: -- copy hercules record into interface table with record status N
10289: INSERT INTO igs_uc_istmnt_ints ( appno,
10290: statement,
10291: record_status,
10292: error_code
10293: )

Line 10339: igs_uc_istmnt_ints with record status N

10335: /******************************************************************
10336: Created By : jbaber
10337: Date Created By : 16-Aug-05
10338: Purpose : loads each record in the hercules view ivnstatement into the interface table
10339: igs_uc_istmnt_ints with record status N
10340: Known limitations,enhancements,remarks:
10341: Change History
10342: Who When What
10343: ***************************************************************** */

Line 10362: l_appno igs_uc_istmnt_ints.appno%TYPE;

10358: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10359: l_new_max_timestamp igs_uc_ivnstatement_2006_v.timestamp%TYPE ;
10360: l_count NUMBER ;
10361:
10362: l_appno igs_uc_istmnt_ints.appno%TYPE;
10363: l_checkdigit NUMBER;
10364:
10365: BEGIN
10366: -- set syncronization required to false

Line 10387: UPDATE igs_uc_istmnt_ints SET record_status = 'O'

10383: -- Determine actual appno
10384: get_appno(c_stmt_rec.appno, NULL, l_appno, l_checkdigit);
10385:
10386: -- Obsolete matching records in interface table with status N
10387: UPDATE igs_uc_istmnt_ints SET record_status = 'O'
10388: WHERE record_status = 'N' AND appno = l_appno;
10389:
10390:
10391: -- copy hercules record into interface table with record status N

Line 10392: INSERT INTO igs_uc_istmnt_ints ( appno,

10388: WHERE record_status = 'N' AND appno = l_appno;
10389:
10390:
10391: -- copy hercules record into interface table with record status N
10392: INSERT INTO igs_uc_istmnt_ints ( appno,
10393: statement,
10394: record_status,
10395: error_code
10396: )