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_CRFCODE_INTS

Line 1188: igs_uc_crfcode_ints with record status N and code_type = DC

1184: /******************************************************************
1185: Created By : smaddali
1186: Date Created By : 11-Jun-03
1187: Purpose : loads each record in the hercules view cvrefdis into the interface table
1188: igs_uc_crfcode_ints with record status N and code_type = DC
1189: Known limitations,enhancements,remarks:
1190: Change History
1191: Who When What
1192: ***************************************************************** */

Line 1223: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'DC' ;

1219: -- if there is a difference in the timestamps then load all records from hercules view
1220: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1221:
1222: -- Obsolete all records in interface table with status N
1223: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'DC' ;
1224:
1225: -- create interface records for each record in the hercules view
1226: FOR c_cvdis_rec IN c_cvdis LOOP
1227: -- set x_sync_read to true if the loop is entered even once

Line 1231: INSERT INTO igs_uc_crfcode_ints ( code_type,

1227: -- set x_sync_read to true if the loop is entered even once
1228: g_sync_reqd := TRUE;
1229:
1230: -- copy hercules record into interface table with record status N
1231: INSERT INTO igs_uc_crfcode_ints ( code_type,
1232: code,
1233: code_text,
1234: record_status,
1235: error_code )

Line 1274: igs_uc_crfcode_ints with record status N and code_type = EC

1270: /******************************************************************
1271: Created By : smaddali
1272: Date Created By : 11-Jun-03
1273: Purpose : loads each record in the hercules view cvreferror into the interface table
1274: igs_uc_crfcode_ints with record status N and code_type = EC
1275: Known limitations,enhancements,remarks:
1276: Change History
1277: Who When What
1278: ***************************************************************** */

Line 1309: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'EC' ;

1305: -- if there is a difference in the timestamps then load all records from hercules view
1306: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1307:
1308: -- Obsolete all records in interface table with status N
1309: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'EC' ;
1310:
1311: -- create interface records for each record in the hercules view
1312: FOR c_cverr_rec IN c_cverr LOOP
1313: -- set x_sync_read to true if the loop is entered even once

Line 1317: INSERT INTO igs_uc_crfcode_ints ( code_type,

1313: -- set x_sync_read to true if the loop is entered even once
1314: g_sync_reqd := TRUE;
1315:
1316: -- copy hercules record into interface table with record status N
1317: INSERT INTO igs_uc_crfcode_ints ( code_type,
1318: code,
1319: code_text,
1320: record_status,
1321: error_code )

Line 1361: igs_uc_crfcode_ints with record status N and code_type = EG

1357: /******************************************************************
1358: Created By : smaddali
1359: Date Created By : 11-Jun-03
1360: Purpose : loads each record in the hercules view cvrefestgroup into the interface table
1361: igs_uc_crfcode_ints with record status N and code_type = EG
1362: Known limitations,enhancements,remarks:
1363: Change History
1364: Who When What
1365: ***************************************************************** */

Line 1397: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'EG' ;

1393: -- if there is a difference in the timestamps then load all records from hercules view
1394: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1395:
1396: -- Obsolete all records in interface table with status N
1397: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'EG' ;
1398:
1399: -- create interface records for each record in the hercules view
1400: FOR c_cvest_rec IN c_cvest LOOP
1401: -- set x_sync_read to true if the loop is entered even once

Line 1405: INSERT INTO igs_uc_crfcode_ints ( code_type,

1401: -- set x_sync_read to true if the loop is entered even once
1402: g_sync_reqd := TRUE;
1403:
1404: -- copy hercules record into interface table with record status N
1405: INSERT INTO igs_uc_crfcode_ints ( code_type,
1406: code,
1407: code_text,
1408: record_status,
1409: error_code )

Line 1449: igs_uc_crfcode_ints with record status N and code_type = ET

1445: /******************************************************************
1446: Created By : smaddali
1447: Date Created By : 11-Jun-03
1448: Purpose : loads each record in the hercules view cvrefethnic into the interface table
1449: igs_uc_crfcode_ints with record status N and code_type = ET
1450: Known limitations,enhancements,remarks:
1451: Change History
1452: Who When What
1453: ***************************************************************** */

Line 1484: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'ET' ;

1480: -- if there is a difference in the timestamps then load all records from hercules view
1481: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1482:
1483: -- Obsolete all records in interface table with status N
1484: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'ET' ;
1485:
1486: -- create interface records for each record in the hercules view
1487: FOR c_cveth_rec IN c_cveth LOOP
1488: -- set x_sync_read to true if the loop is entered even once

Line 1492: INSERT INTO igs_uc_crfcode_ints ( code_type,

1488: -- set x_sync_read to true if the loop is entered even once
1489: g_sync_reqd := TRUE;
1490:
1491: -- copy hercules record into interface table with record status N
1492: INSERT INTO igs_uc_crfcode_ints ( code_type,
1493: code,
1494: code_text,
1495: record_status,
1496: error_code )

Line 1535: igs_uc_crfcode_ints with record status N and code_type = EL

1531: /******************************************************************
1532: Created By : smaddali
1533: Date Created By : 11-Jun-03
1534: Purpose : loads each record in the hercules view cvrefexam into the interface table
1535: igs_uc_crfcode_ints with record status N and code_type = EL
1536: Known limitations,enhancements,remarks:
1537: Change History
1538: Who When What
1539: ***************************************************************** */

Line 1570: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'EL' ;

1566: -- if there is a difference in the timestamps then load all records from hercules view
1567: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1568:
1569: -- Obsolete all records in interface table with status N
1570: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'EL' ;
1571:
1572: -- create interface records for each record in the hercules view
1573: FOR c_cvexam_rec IN c_cvexam LOOP
1574: -- set x_sync_read to true if the loop is entered even once

Line 1578: INSERT INTO igs_uc_crfcode_ints ( code_type,

1574: -- set x_sync_read to true if the loop is entered even once
1575: g_sync_reqd := TRUE;
1576:
1577: -- copy hercules record into interface table with record status N
1578: INSERT INTO igs_uc_crfcode_ints ( code_type,
1579: code,
1580: code_text,
1581: record_status,
1582: error_code )

Line 1621: igs_uc_crfcode_ints with record status N and code_type = FC

1617: /******************************************************************
1618: Created By : smaddali
1619: Date Created By : 11-Jun-03
1620: Purpose : loads each record in the hercules view cvreffee into the interface table
1621: igs_uc_crfcode_ints with record status N and code_type = FC
1622: Known limitations,enhancements,remarks:
1623: Change History
1624: Who When What
1625: ***************************************************************** */

Line 1656: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'FC' ;

1652: -- if there is a difference in the timestamps then load all records from hercules view
1653: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1654:
1655: -- Obsolete all records in interface table with status N
1656: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'FC' ;
1657:
1658: -- create interface records for each record in the hercules view
1659: FOR c_cvfee_rec IN c_cvfee LOOP
1660: -- set x_sync_read to true if the loop is entered even once

Line 1664: INSERT INTO igs_uc_crfcode_ints ( code_type,

1660: -- set x_sync_read to true if the loop is entered even once
1661: g_sync_reqd := TRUE;
1662:
1663: -- copy hercules record into interface table with record status N
1664: INSERT INTO igs_uc_crfcode_ints ( code_type,
1665: code,
1666: code_text,
1667: record_status,
1668: error_code )

Line 1788: igs_uc_crfcode_ints with record status N and code_type = OC

1784: /******************************************************************
1785: Created By : smaddali
1786: Date Created By : 11-Jun-03
1787: Purpose : loads each record in the hercules view cvrefoeq into the interface table
1788: igs_uc_crfcode_ints with record status N and code_type = OC
1789: Known limitations,enhancements,remarks:
1790: Change History
1791: Who When What
1792: ***************************************************************** */

Line 1823: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'OC' ;

1819: -- if there is a difference in the timestamps then load all records from hercules view
1820: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
1821:
1822: -- Obsolete all records in interface table with status N
1823: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'OC' ;
1824:
1825: -- create interface records for each record in the hercules view
1826: FOR c_cvoeq_rec IN c_cvoeq LOOP
1827: -- set x_sync_read to true if the loop is entered even once

Line 1831: INSERT INTO igs_uc_crfcode_ints ( code_type,

1827: -- set x_sync_read to true if the loop is entered even once
1828: g_sync_reqd := TRUE;
1829:
1830: -- copy hercules record into interface table with record status N
1831: INSERT INTO igs_uc_crfcode_ints ( code_type,
1832: code,
1833: code_text,
1834: record_status,
1835: error_code )

Line 1977: igs_uc_crfcode_ints with record status N and code_type = SB

1973: /******************************************************************
1974: Created By : smaddali
1975: Date Created By : 11-Jun-03
1976: Purpose : loads each record in the hercules view cvrefoffersubj into the interface table
1977: igs_uc_crfcode_ints with record status N and code_type = SB
1978: Known limitations,enhancements,remarks:
1979: Change History
1980: Who When What
1981: ***************************************************************** */

Line 2012: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'SB' ;

2008: -- if there is a difference in the timestamps then load all records from hercules view
2009: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
2010:
2011: -- Obsolete all records in interface table with status N
2012: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'SB' ;
2013:
2014: -- create interface records for each record in the hercules view
2015: FOR c_cvoffsbj_rec IN c_cvoffsbj LOOP
2016: -- set x_sync_read to true if the loop is entered even once

Line 2020: INSERT INTO igs_uc_crfcode_ints ( code_type,

2016: -- set x_sync_read to true if the loop is entered even once
2017: g_sync_reqd := TRUE;
2018:
2019: -- copy hercules record into interface table with record status N
2020: INSERT INTO igs_uc_crfcode_ints ( code_type,
2021: code,
2022: code_text,
2023: record_status,
2024: error_code )

Line 2171: igs_uc_crfcode_ints with record status N and code_type = RC

2167: /******************************************************************
2168: Created By : smaddali
2169: Date Created By : 11-Jun-03
2170: Purpose : loads each record in the hercules view cvrefrescat into the interface table
2171: igs_uc_crfcode_ints with record status N and code_type = RC
2172: Known limitations,enhancements,remarks:
2173: Change History
2174: Who When What
2175: ***************************************************************** */

Line 2206: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'RC' ;

2202: -- if there is a difference in the timestamps then load all records from hercules view
2203: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
2204:
2205: -- Obsolete all records in interface table with status N
2206: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'RC' ;
2207:
2208: -- create interface records for each record in the hercules view
2209: FOR c_cvrescat_rec IN c_cvrescat LOOP
2210: -- set x_sync_read to true if the loop is entered even once

Line 2214: INSERT INTO igs_uc_crfcode_ints ( code_type,

2210: -- set x_sync_read to true if the loop is entered even once
2211: g_sync_reqd := TRUE;
2212:
2213: -- copy hercules record into interface table with record status N
2214: INSERT INTO igs_uc_crfcode_ints ( code_type,
2215: code,
2216: code_text,
2217: record_status,
2218: error_code )

Line 2257: igs_uc_crfcode_ints with record status N and code_type = ST

2253: /******************************************************************
2254: Created By : smaddali
2255: Date Created By : 11-Jun-03
2256: Purpose : loads each record in the hercules view cvrefschooltype into the interface table
2257: igs_uc_crfcode_ints with record status N and code_type = ST
2258: Known limitations,enhancements,remarks:
2259: Change History
2260: Who When What
2261: ***************************************************************** */

Line 2292: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'ST' ;

2288: -- if there is a difference in the timestamps then load all records from hercules view
2289: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
2290:
2291: -- Obsolete all records in interface table with status N
2292: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'ST' ;
2293:
2294: -- create interface records for each record in the hercules view
2295: FOR c_cvschtyp_rec IN c_cvschtyp LOOP
2296: -- set x_sync_read to true if the loop is entered even once

Line 2300: INSERT INTO igs_uc_crfcode_ints ( code_type,

2296: -- set x_sync_read to true if the loop is entered even once
2297: g_sync_reqd := TRUE;
2298:
2299: -- copy hercules record into interface table with record status N
2300: INSERT INTO igs_uc_crfcode_ints ( code_type,
2301: code,
2302: code_text,
2303: record_status,
2304: error_code )

Line 2343: igs_uc_crfcode_ints with record status N and code_type = SC

2339: /******************************************************************
2340: Created By : smaddali
2341: Date Created By : 11-Jun-03
2342: Purpose : loads each record in the hercules view cvrefstatus into the interface table
2343: igs_uc_crfcode_ints with record status N and code_type = SC
2344: Known limitations,enhancements,remarks:
2345: Change History
2346: Who When What
2347: ***************************************************************** */

Line 2378: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'SC' ;

2374: -- if there is a difference in the timestamps then load all records from hercules view
2375: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
2376:
2377: -- Obsolete all records in interface table with status N
2378: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'SC' ;
2379:
2380: -- create interface records for each record in the hercules view
2381: FOR c_cvstatus_rec IN c_cvstatus LOOP
2382: -- set x_sync_read to true if the loop is entered even once

Line 2386: INSERT INTO igs_uc_crfcode_ints ( code_type,

2382: -- set x_sync_read to true if the loop is entered even once
2383: g_sync_reqd := TRUE;
2384:
2385: -- copy hercules record into interface table with record status N
2386: INSERT INTO igs_uc_crfcode_ints ( code_type,
2387: code,
2388: code_text,
2389: record_status,
2390: error_code )

Line 2516: igs_uc_crfcode_ints with record status N and code_type = GN

2512: /******************************************************************
2513: Created By : smaddali
2514: Date Created By : 11-Jun-03
2515: Purpose : loads each record in the hercules view cvrefucasgroup into the interface table
2516: igs_uc_crfcode_ints with record status N and code_type = GN
2517: Known limitations,enhancements,remarks:
2518: Change History
2519: Who When What
2520: ***************************************************************** */

Line 2551: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'GN' ;

2547: -- if there is a difference in the timestamps then load all records from hercules view
2548: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
2549:
2550: -- Obsolete all records in interface table with status N
2551: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'GN' ;
2552:
2553: -- create interface records for each record in the hercules view
2554: FOR c_cvugroup_rec IN c_cvugroup LOOP
2555: -- set x_sync_read to true if the loop is entered even once

Line 2559: INSERT INTO igs_uc_crfcode_ints ( code_type,

2555: -- set x_sync_read to true if the loop is entered even once
2556: g_sync_reqd := TRUE;
2557:
2558: -- copy hercules record into interface table with record status N
2559: INSERT INTO igs_uc_crfcode_ints ( code_type,
2560: code,
2561: code_text,
2562: record_status,
2563: error_code )

Line 4040: igs_uc_crfcode_ints with record status N and code_type = PC

4036: /******************************************************************
4037: Created By : smaddali
4038: Date Created By : 11-Jun-03
4039: Purpose : loads each record in the hercules view cvrefsocialclass into the interface table
4040: igs_uc_crfcode_ints with record status N and code_type = PC
4041: Known limitations,enhancements,remarks:
4042: Change History
4043: Who When What
4044: ***************************************************************** */

Line 4063: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type = 'PC';

4059: -- log message that this view is being loaded
4060: log_start('CVREFSOCIALCLASS ON ') ;
4061:
4062: -- Obsolete records in interface table with status N
4063: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type = 'PC';
4064:
4065: -- create interface records for each record in the hercules view
4066: FOR c_cvsocclas_rec IN c_cvsocclas LOOP
4067: -- set x_sync_read to true if the loop is entered even once

Line 4071: INSERT INTO igs_uc_crfcode_ints( code_type,

4067: -- set x_sync_read to true if the loop is entered even once
4068: g_sync_reqd := TRUE;
4069:
4070: -- copy hercules record into interface table with record status N
4071: INSERT INTO igs_uc_crfcode_ints( code_type,
4072: code,
4073: code_text,
4074: record_status,
4075: error_code

Line 4111: igs_uc_crfcode_ints with record status N and code_type = PE

4107: /******************************************************************
4108: Created By : smaddali
4109: Date Created By : 11-Jun-03
4110: Purpose : loads each record in the hercules view cvrefsocioeconomic into the interface table
4111: igs_uc_crfcode_ints with record status N and code_type = PE
4112: Known limitations,enhancements,remarks:
4113: Change History
4114: Who When What
4115: ***************************************************************** */

Line 4134: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type = 'PE';

4130: -- log message that this view is being loaded
4131: log_start('CVREFSOCIOECONOMIC ON ') ;
4132:
4133: -- Obsolete records in interface table with status N
4134: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type = 'PE';
4135:
4136: -- create interface records for each record in the hercules view
4137: FOR c_cvsocioecon_rec IN c_cvsocioecon LOOP
4138: -- set x_sync_read to true if the loop is entered even once

Line 4142: INSERT INTO igs_uc_crfcode_ints( code_type,

4138: -- set x_sync_read to true if the loop is entered even once
4139: g_sync_reqd := TRUE;
4140:
4141: -- copy hercules record into interface table with record status N
4142: INSERT INTO igs_uc_crfcode_ints( code_type,
4143: code,
4144: code_text,
4145: record_status,
4146: error_code

Line 4347: igs_uc_crfcode_ints with record status N and code_type = NC

4343: /******************************************************************
4344: Created By : jbaber
4345: Date Created By : 11-Jul-06
4346: Purpose : loads each record in the hercules view cvrefnationality into the interface table
4347: igs_uc_crfcode_ints with record status N and code_type = NC
4348: Known limitations,enhancements,remarks:
4349: Change History
4350: Who When What
4351: ***************************************************************** */

Line 4382: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'NC' ;

4378: -- if there is a difference in the timestamps then load all records from hercules view
4379: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
4380:
4381: -- Obsolete all records in interface table with status N
4382: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'NC' ;
4383:
4384: -- create interface records for each record in the hercules view
4385: FOR c_cvrefnationality_rec IN c_cvrefnationality LOOP
4386: -- set x_sync_read to true if the loop is entered even once

Line 4390: INSERT INTO igs_uc_crfcode_ints ( code_type,

4386: -- set x_sync_read to true if the loop is entered even once
4387: g_sync_reqd := TRUE;
4388:
4389: -- copy hercules record into interface table with record status N
4390: INSERT INTO igs_uc_crfcode_ints ( code_type,
4391: code,
4392: code_text,
4393: record_status,
4394: error_code )

Line 4434: igs_uc_crfcode_ints with record status N and code_type = DS

4430: /******************************************************************
4431: Created By : jbaber
4432: Date Created By : 02-Oct-05
4433: Purpose : loads each record in the hercules view cvgrefdegreesubject into the interface table
4434: igs_uc_crfcode_ints with record status N and code_type = DS
4435: Known limitations,enhancements,remarks:
4436: Change History
4437: Who When What
4438: ***************************************************************** */

Line 4470: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'DS' ;

4466: -- if there is a difference in the timestamps then load all records from hercules view
4467: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
4468:
4469: -- Obsolete all records in interface table with status N
4470: UPDATE igs_uc_crfcode_ints SET record_status = 'O' WHERE record_status = 'N' AND code_type= 'DS' ;
4471:
4472: -- create interface records for each record in the hercules view
4473: FOR c_cvgrefdegsubj_rec IN c_cvgrefdegsubj LOOP
4474: -- set x_sync_read to true if the loop is entered even once

Line 4478: INSERT INTO igs_uc_crfcode_ints ( code_type,

4474: -- set x_sync_read to true if the loop is entered even once
4475: g_sync_reqd := TRUE;
4476:
4477: -- copy hercules record into interface table with record status N
4478: INSERT INTO igs_uc_crfcode_ints ( code_type,
4479: code,
4480: code_text,
4481: record_status,
4482: error_code )