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_U_CVREFAMENDMENTS_2003

Line 37: FROM igs_uc_u_cvrefamendments_2003 a;

33: keyworddate, oeqdate, offerabbrevdate, offersubjdate, poccdate,
34: rescatdate, awardbodydate, statusdate, ucasgroupdate, estabgroup,
35: schooltype, tariffdate, jointadmissions,
36: sysdate AS COUNTRY, sysdate AS NATIONALITY
37: FROM igs_uc_u_cvrefamendments_2003 a;
38:
39: CURSOR c_refamend_timestamp_2007 IS
40: SELECT aprdate, disdate, errordate, ethnicdate, examdate, feedate,
41: keyworddate, oeqdate, offerabbrevdate, offersubjdate, poccdate,

Line 918: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.jointadmissions%TYPE ;

914: FROM igs_uc_u_cvjntadmissions_2003 ;
915:
916: -- Variables
917: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
918: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.jointadmissions%TYPE ;
919: l_count NUMBER ;
920:
921: BEGIN
922: -- set syncronization required to false

Line 1015: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.aprdate%TYPE ;

1011:
1012:
1013: -- Variables
1014: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1015: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.aprdate%TYPE ;
1016: l_count NUMBER ;
1017:
1018:
1019: BEGIN

Line 1112: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.awardbodydate%TYPE ;

1108: FROM igs_uc_u_cvrefawardbody_2003 ;
1109:
1110: -- Variables
1111: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1112: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.awardbodydate%TYPE ;
1113: l_count NUMBER ;
1114:
1115: BEGIN
1116: -- set syncronization required to false

Line 1203: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.disdate%TYPE ;

1199: FROM igs_uc_u_cvrefdis_2003 ;
1200:
1201: -- Variables
1202: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1203: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.disdate%TYPE ;
1204: l_count NUMBER ;
1205:
1206: BEGIN
1207: -- set syncronization required to false

Line 1289: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.errordate%TYPE ;

1285: FROM igs_uc_u_cvreferror_2003 ;
1286:
1287: -- Variables
1288: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1289: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.errordate%TYPE ;
1290: l_count NUMBER ;
1291:
1292: BEGIN
1293: -- set syncronization required to false

Line 1376: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.estabgroup%TYPE ;

1372: FROM igs_uc_u_cvrefestgroup_2003 ;
1373:
1374: -- Variables
1375: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1376: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.estabgroup%TYPE ;
1377: l_count NUMBER ;
1378:
1379:
1380: BEGIN

Line 1464: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.ethnicdate%TYPE ;

1460: FROM igs_uc_u_cvrefethnic_2003 ;
1461:
1462: -- Variables
1463: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1464: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.ethnicdate%TYPE ;
1465: l_count NUMBER ;
1466:
1467: BEGIN
1468: -- set syncronization required to false

Line 1550: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.examdate%TYPE ;

1546: FROM igs_uc_u_cvrefexam_2003 ;
1547:
1548: -- Variables
1549: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1550: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.examdate%TYPE ;
1551: l_count NUMBER ;
1552:
1553: BEGIN
1554: -- set syncronization required to false

Line 1636: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.feedate%TYPE ;

1632: FROM igs_uc_u_cvreffee_2003 ;
1633:
1634: -- Variables
1635: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1636: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.feedate%TYPE ;
1637: l_count NUMBER ;
1638:
1639: BEGIN
1640: -- set syncronization required to false

Line 1721: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.keyworddate%TYPE ;

1717: FROM igs_uc_u_cvrefkeyword_2003 ;
1718:
1719: -- Variables
1720: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1721: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.keyworddate%TYPE ;
1722: l_count NUMBER ;
1723:
1724: BEGIN
1725: -- set syncronization required to false

Line 1803: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.oeqdate%TYPE ;

1799: FROM igs_uc_u_cvrefoeq_2003 ;
1800:
1801: -- Variables
1802: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1803: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.oeqdate%TYPE ;
1804: l_count NUMBER ;
1805:
1806: BEGIN
1807: -- set syncronization required to false

Line 1895: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.offerabbrevdate%TYPE ;

1891: FROM igs_uc_u_cvrefofferabbrev_2003 ;
1892:
1893: -- Variables
1894: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1895: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.offerabbrevdate%TYPE ;
1896: l_count NUMBER ;
1897:
1898: BEGIN
1899: -- set syncronization required to false

Line 1992: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.offersubjdate%TYPE ;

1988: FROM igs_uc_u_cvrefoffersubj_2003 ;
1989:
1990: -- Variables
1991: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1992: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.offersubjdate%TYPE ;
1993: l_count NUMBER ;
1994:
1995: BEGIN
1996: -- set syncronization required to false

Line 2083: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.poccdate%TYPE ;

2079: FROM igs_uc_u_cvrefpocc_2003 ;
2080:
2081: -- Variables
2082: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2083: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.poccdate%TYPE ;
2084: l_count NUMBER ;
2085:
2086: BEGIN
2087: -- set syncronization required to false

Line 2186: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.rescatdate%TYPE ;

2182: FROM igs_uc_u_cvrefrescat_2003 ;
2183:
2184: -- Variables
2185: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2186: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.rescatdate%TYPE ;
2187: l_count NUMBER ;
2188:
2189: BEGIN
2190: -- set syncronization required to false

Line 2272: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.schooltype%TYPE ;

2268: FROM igs_uc_u_cvrefschooltype_2003 ;
2269:
2270: -- Variables
2271: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2272: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.schooltype%TYPE ;
2273: l_count NUMBER ;
2274:
2275: BEGIN
2276: -- set syncronization required to false

Line 2358: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.statusdate%TYPE ;

2354: FROM igs_uc_u_cvrefstatus_2003 ;
2355:
2356: -- Variables
2357: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2358: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.statusdate%TYPE ;
2359: l_count NUMBER ;
2360:
2361: BEGIN
2362: -- set syncronization required to false

Line 2445: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.tariffdate%TYPE ;

2441: FROM igs_uc_u_cvreftariff_2003 ;
2442:
2443: -- Variables
2444: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2445: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.tariffdate%TYPE ;
2446: l_count NUMBER ;
2447:
2448: BEGIN
2449: -- set syncronization required to false

Line 2531: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.ucasgroupdate%TYPE ;

2527: FROM igs_uc_u_cvrefucasgroup_2003 ;
2528:
2529: -- Variables
2530: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2531: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.ucasgroupdate%TYPE ;
2532: l_count NUMBER ;
2533:
2534: BEGIN
2535: -- set syncronization required to false