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_HRC_TIMSTMPS

Line 75: PROCEDURE herc_timestamp_exists ( p_view IN igs_uc_hrc_timstmps.view_name%TYPE ,

71:
72: END write_to_log;
73:
74:
75: PROCEDURE herc_timestamp_exists ( p_view IN igs_uc_hrc_timstmps.view_name%TYPE ,
76: p_herc_timestamp OUT NOCOPY igs_uc_hrc_timstmps.timestamp%TYPE ) IS
77: /******************************************************************
78: Created By : smaddali
79: Date Created By : 11-Jun-03

Line 76: p_herc_timestamp OUT NOCOPY igs_uc_hrc_timstmps.timestamp%TYPE ) IS

72: END write_to_log;
73:
74:
75: PROCEDURE herc_timestamp_exists ( p_view IN igs_uc_hrc_timstmps.view_name%TYPE ,
76: p_herc_timestamp OUT NOCOPY igs_uc_hrc_timstmps.timestamp%TYPE ) IS
77: /******************************************************************
78: Created By : smaddali
79: Date Created By : 11-Jun-03
80: Purpose : checks if the timestamp record for the passed view exists or not

Line 89: FROM igs_uc_hrc_timstmps hrc

85:
86: -- Get the timestamp value for the passed view for the passed ucas cycle
87: CURSOR c_timestamp IS
88: SELECT hrc.timestamp
89: FROM igs_uc_hrc_timstmps hrc
90: WHERE view_name = p_view
91: AND ucas_cycle = g_cyc_info_rec.configured_cycle ;
92: c_timestamp_rec c_timestamp%ROWTYPE ;
93:

Line 122: PROCEDURE ins_upd_timestamp( p_view IN igs_uc_hrc_timstmps.view_name%TYPE ,

118: app_exception.raise_exception ;
119: END herc_timestamp_exists;
120:
121:
122: PROCEDURE ins_upd_timestamp( p_view IN igs_uc_hrc_timstmps.view_name%TYPE ,
123: p_new_max_timestamp IN igs_uc_hrc_timstmps.timestamp%TYPE )
124: IS
125: /******************************************************************
126: Created By : smaddali

Line 123: p_new_max_timestamp IN igs_uc_hrc_timstmps.timestamp%TYPE )

119: END herc_timestamp_exists;
120:
121:
122: PROCEDURE ins_upd_timestamp( p_view IN igs_uc_hrc_timstmps.view_name%TYPE ,
123: p_new_max_timestamp IN igs_uc_hrc_timstmps.timestamp%TYPE )
124: IS
125: /******************************************************************
126: Created By : smaddali
127: Date Created By : 11-Jun-03

Line 143: igs_uc_hrc_timstmps_pkg.add_row(

139: l_rowid := NULL ;
140:
141: -- if timestamp record is not found for this view in passed cycle then insert new record with the passed timestamp
142: -- else update its timestamp value with the passed timestamp
143: igs_uc_hrc_timstmps_pkg.add_row(
144: x_rowid => l_rowid,
145: x_view_name => p_view ,
146: x_ucas_cycle => g_cyc_info_rec.configured_cycle ,
147: x_timestamp => p_new_max_timestamp,

Line 357: CURSOR c_cvcourse( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

353: ***************************************************************** */
354:
355: -- Get all the records from hercules view whose timestamp is > passed timestamp
356: -- or get all the records in hercules view if the timestamp passed is null
357: CURSOR c_cvcourse( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
358: SELECT DECODE(RTRIM(inst),NULL, RPAD('*',LENGTH(inst),'*'), RTRIM(inst)) inst
359: ,DECODE(RTRIM(course),NULL, RPAD('*',LENGTH(course),'*'), RTRIM(course)) course
360: ,NVL(DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)),'*') campus
361: ,timestamp

Line 378: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

374: SELECT MAX(timestamp)
375: FROM igs_uc_u_cvcourse_2003 ;
376:
377: -- Variables
378: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
379: l_new_max_timestamp igs_uc_u_cvcourse_2003.timestamp%TYPE ;
380: l_count NUMBER ;
381:
382: BEGIN

Line 476: CURSOR c_cvgcourse( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

472: ***************************************************************** */
473:
474: -- Get all the records from hercules view whose timestamp is > passed timestamp
475: -- or get all the records in hercules view if the timestamp passed is null
476: CURSOR c_cvgcourse( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
477: SELECT DECODE(RTRIM(inst),NULL, RPAD('*',LENGTH(inst),'*'), RTRIM(inst)) inst
478: ,DECODE(RTRIM(course),NULL, RPAD('*',LENGTH(course),'*'), RTRIM(course)) course
479: ,NVL(DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)),'*') campus
480: ,timestamp

Line 492: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

488: SELECT MAX(timestamp)
489: FROM igs_uc_g_cvgcourse_2007 ;
490:
491: -- Variables
492: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
493: l_new_max_timestamp igs_uc_g_cvgcourse_2007.timestamp%TYPE ;
494: l_count NUMBER ;
495:
496: BEGIN

Line 580: CURSOR c_cvncourse( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

576: ***************************************************************** */
577:
578: -- Get all the records from hercules view whose timestamp is > passed timestamp
579: -- or get all the records in hercules view if the timestamp passed is null
580: CURSOR c_cvncourse( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
581: SELECT DECODE(RTRIM(inst),NULL, RPAD('*',LENGTH(inst),'*'), RTRIM(inst)) inst
582: ,DECODE(RTRIM(course),NULL, RPAD('*',LENGTH(course),'*'), RTRIM(course)) course
583: ,NVL(DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)),'*') campus
584: ,timestamp

Line 596: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

592: SELECT MAX(timestamp)
593: FROM igs_uc_n_cvncourse_2007 ;
594:
595: -- Variables
596: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
597: l_new_max_timestamp igs_uc_n_cvncourse_2007.timestamp%TYPE ;
598: l_count NUMBER ;
599:
600: BEGIN

Line 687: CURSOR c_cvebl( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

683: ***************************************************************** */
684:
685: -- Get all the records from hercules view whose timestamp is > passed timestamp
686: -- or get all the records in hercules view if the timestamp passed is null
687: CURSOR c_cvebl( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
688: SELECT
689: subjectid
690: ,timestamp
691: ,year

Line 707: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

703: SELECT MAX(timestamp)
704: FROM igs_uc_u_cveblsubject_2003 ;
705:
706: -- Variables
707: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
708: l_new_max_timestamp igs_uc_u_cveblsubject_2003.timestamp%TYPE ;
709: l_count NUMBER ;
710:
711:

Line 799: CURSOR c_cvinst( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

795: ***************************************************************** */
796:
797: -- Get all the records from hercules view whose timestamp is > passed timestamp
798: -- or get all the records in hercules view if the timestamp passed is null
799: CURSOR c_cvinst( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
800: SELECT DECODE(RTRIM(inst),NULL, RPAD('*',LENGTH(inst),'*'), RTRIM(inst)) inst
801: ,timestamp
802: ,RTRIM(instcode) instcode
803: ,RTRIM(instname) instname

Line 817: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

813: SELECT MAX(timestamp)
814: FROM igs_uc_u_cvinstitution_2003 ;
815:
816: -- Variables
817: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
818: l_new_max_timestamp igs_uc_u_cvinstitution_2003.timestamp%TYPE ;
819: l_count NUMBER ;
820:
821: BEGIN

Line 917: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

913: ,RTRIM(parentinst5) parentinst5
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

Line 1014: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1010: FROM igs_uc_u_cvrefapr_2003 ;
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:

Line 1111: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1107: ,RTRIM(bodyabbrev) bodyabbrev
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

Line 1202: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1198: ,RTRIM(distext) distext
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

Line 1288: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1284: ,RTRIM(errordescription) errordescription
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

Line 1375: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1371: ,RTRIM(estabtext) estabtext
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:

Line 1463: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1459: ,RTRIM(ethnictext) ethnictext
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

Line 1549: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1545: ,RTRIM(examtext) examtext
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

Line 1635: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1631: ,RTRIM(feetext) feetext
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

Line 1720: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1716: SELECT DECODE(RTRIM(keyword),NULL, RPAD('*',LENGTH(keyword),'*'), RTRIM(keyword)) keyword
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

Line 1802: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1798: ,RTRIM(oeqtext) oeqtext
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

Line 1894: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1890: ,RTRIM(tariff) tariff
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

Line 1991: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

1987: ,RTRIM(subjtext) subjtext
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

Line 2082: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

2078: ,socioeconomic
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

Line 2185: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

2181: ,RTRIM(rescattext) rescattext
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

Line 2271: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

2267: ,RTRIM(schooltext) schooltext
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

Line 2357: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

2353: ,RTRIM(statustext) statustext
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

Line 2444: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

2440: ,DECODE(RTRIM(tariffscore),NULL, RPAD('*',LENGTH(tariffscore),'*'), RTRIM(tariffscore)) tariffscore
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

Line 2530: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

2526: ,RTRIM(groupname) groupname
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

Line 2612: CURSOR c_cvschool( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

2608: ***************************************************************** */
2609:
2610: -- Get all the records from hercules view whose timestamp is > passed timestamp
2611: -- or get all the records in hercules view if the timestamp passed is null
2612: CURSOR c_cvschool( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
2613: SELECT school
2614: ,DECODE(RTRIM(sitecode),NULL, RPAD('*',LENGTH(sitecode),'*'), RTRIM(sitecode)) sitecode
2615: ,timestamp
2616: ,RTRIM(schoolname) schoolname

Line 2650: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

2646: SELECT MAX(timestamp)
2647: FROM igs_uc_u_cvschool_2003 ;
2648:
2649: -- Variables
2650: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2651: l_new_max_timestamp igs_uc_u_cvschool_2003.timestamp%TYPE ;
2652: l_count NUMBER ;
2653:
2654: BEGIN

Line 2786: CURSOR c_cvschcnt( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

2782: ***************************************************************** */
2783:
2784: -- Get all the records from hercules view whose timestamp is > passed timestamp
2785: -- or get all the records in hercules view if the timestamp passed is null
2786: CURSOR c_cvschcnt( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
2787: SELECT school
2788: ,DECODE(RTRIM(sitecode),NULL, RPAD('*',LENGTH(sitecode),'*'), RTRIM(sitecode)) sitecode
2789: ,contactcode
2790: ,timestamp

Line 2812: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

2808: SELECT MAX(timestamp)
2809: FROM igs_uc_u_cvschoolcontact_2003 ;
2810:
2811: -- Variables
2812: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2813: l_new_max_timestamp igs_uc_u_cvschoolcontact_2003.timestamp%TYPE ;
2814: l_count NUMBER ;
2815:
2816: BEGIN

Line 2925: CURSOR c_uvcnt( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

2921: ***************************************************************** */
2922:
2923: -- Get all the records from hercules view whose timestamp is > passed timestamp
2924: -- or get all the records in hercules view if the timestamp passed is null
2925: CURSOR c_uvcnt( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
2926: SELECT DECODE(RTRIM(contactcode),NULL, RPAD('*',LENGTH(contactcode),'*'), RTRIM(contactcode)) contactcode
2927: ,timestamp
2928: ,RTRIM(updater) updater
2929: ,DECODE(RTRIM(name),NULL, RPAD('*',LENGTH(name),'*'), RTRIM(name)) name

Line 2947: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

2943: SELECT MAX(timestamp)
2944: FROM igs_uc_u_uvcontact_2003 ;
2945:
2946: -- Variables
2947: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2948: l_new_max_timestamp igs_uc_u_uvcontact_2003.timestamp%TYPE ;
2949: l_count NUMBER ;
2950:
2951: BEGIN

Line 3045: CURSOR c_uvcntgr( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

3041: ***************************************************************** */
3042:
3043: -- Get all the records from hercules view whose timestamp is > passed timestamp
3044: -- or get all the records in hercules view if the timestamp passed is null
3045: CURSOR c_uvcntgr( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
3046: SELECT DECODE(RTRIM(contactcode),NULL, RPAD('*',LENGTH(contactcode),'*'), RTRIM(contactcode)) contactcode
3047: ,ucasgroup
3048: ,RTRIM(updater) updater
3049: ,timestamp

Line 3059: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

3055: SELECT MAX(timestamp)
3056: FROM igs_uc_u_uvcontgrp_2003 ;
3057:
3058: -- Variables
3059: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3060: l_new_max_timestamp igs_uc_u_uvcontgrp_2003.timestamp%TYPE ;
3061: l_count NUMBER ;
3062:
3063: BEGIN

Line 3143: CURSOR c_uvcrse( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

3139: ***************************************************************** */
3140:
3141: -- Get all the records from hercules view whose timestamp is > passed timestamp
3142: -- or get all the records in hercules view if the timestamp passed is null
3143: CURSOR c_uvcrse( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
3144: SELECT DECODE(RTRIM(course),NULL, RPAD('*',LENGTH(course),'*'), RTRIM(course)) course
3145: ,NVL(DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)),'*') campus
3146: ,timestamp
3147: ,DECODE(RTRIM(updater),NULL, RPAD('*',LENGTH(updater),'*'), RTRIM(updater)) updater

Line 3172: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

3168: SELECT MAX(timestamp)
3169: FROM igs_uc_u_uvcourse_2003 ;
3170:
3171: -- Variables
3172: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3173: l_new_max_timestamp igs_uc_u_uvcourse_2003.timestamp%TYPE ;
3174: l_count NUMBER ;
3175:
3176: BEGIN

Line 3288: CURSOR c_uvcrsekyw( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

3284: ***************************************************************** */
3285:
3286: -- Get all the records from hercules view whose timestamp is > passed timestamp
3287: -- or get all the records in hercules view if the timestamp passed is null
3288: CURSOR c_uvcrsekyw( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
3289: SELECT DECODE(RTRIM(course),NULL, RPAD('*',LENGTH(course),'*'), RTRIM(course)) course
3290: ,DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)) campus
3291: ,DECODE(RTRIM(optioncode),NULL, RPAD('*',LENGTH(optioncode),'*'), RTRIM(optioncode)) optioncode
3292: ,NULL keyno

Line 3306: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

3302: SELECT MAX(timestamp)
3303: FROM igs_uc_u_uvcoursekeyword_2003 ;
3304:
3305: -- Variables
3306: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3307: l_new_max_timestamp igs_uc_u_uvcoursekeyword_2003.timestamp%TYPE ;
3308: l_count NUMBER ;
3309:
3310: BEGIN

Line 3409: CURSOR c_uvcrsevac( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

3405: ***************************************************************** */
3406:
3407: -- Get all the records from hercules view whose timestamp is > passed timestamp
3408: -- or get all the records in hercules view if the timestamp passed is null
3409: CURSOR c_uvcrsevac( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
3410: SELECT DECODE(RTRIM(course),NULL, RPAD('*',LENGTH(course),'*'), RTRIM(course)) course
3411: ,DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)) campus
3412: ,timestamp
3413: ,DECODE(RTRIM(updater),NULL, RPAD('*',LENGTH(updater),'*'), RTRIM(updater)) updater

Line 3430: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

3426: SELECT MAX(timestamp)
3427: FROM igs_uc_u_uvcoursevacs_2003 ;
3428:
3429: -- Variables
3430: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3431: l_new_max_timestamp IGS_UC_U_UVCOURSEVACS_2003.timestamp%TYPE ;
3432: l_count NUMBER ;
3433:
3434: BEGIN

Line 3526: CURSOR c_uvcrsevacop( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

3522: ***************************************************************** */
3523:
3524: -- Get all the records from hercules view whose timestamp is > passed timestamp
3525: -- or get all the records in hercules view if the timestamp passed is null
3526: CURSOR c_uvcrsevacop( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
3527: SELECT DECODE(RTRIM(course),NULL, RPAD('*',LENGTH(course),'*'), RTRIM(course)) course
3528: ,DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)) campus
3529: ,DECODE(RTRIM(optioncode),NULL, RPAD('*',LENGTH(optioncode),'*'), RTRIM(optioncode)) optioncode
3530: ,timestamp

Line 3544: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

3540: SELECT MAX(timestamp)
3541: FROM igs_uc_u_uvcoursevacops_2003 ;
3542:
3543: -- Variables
3544: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3545: l_new_max_timestamp IGS_UC_U_UVCOURSEVACOPS_2003.timestamp%TYPE ;
3546: l_count NUMBER ;
3547:
3548: BEGIN

Line 3635: CURSOR c_uinst ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

3631: ***************************************************************** */
3632:
3633: -- Get all the records from hercules view whose timestamp is > passed timestamp
3634: -- or get all the records in hercules view if the timestamp passed is null
3635: CURSOR c_uinst ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
3636: SELECT timestamp
3637: ,DECODE(RTRIM(updater),NULL, RPAD('*',LENGTH(updater),'*'), RTRIM(updater)) updater
3638: ,DECODE(RTRIM(insttype),NULL, RPAD('*',LENGTH(insttype),'*'), RTRIM(insttype)) insttype
3639: ,RTRIM(instshortname) instshortname

Line 3691: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

3687: SELECT MAX(timestamp)
3688: FROM igs_uc_u_uvinstitution_2003 ;
3689:
3690: -- Variables
3691: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3692: l_new_max_timestamp igs_uc_u_uvinstitution_2003.timestamp%TYPE ;
3693: l_count NUMBER ;
3694:
3695: BEGIN

Line 3857: CURSOR c_uvoffabrv( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

3853: ***************************************************************** */
3854:
3855: -- Get all the records from hercules view whose timestamp is > passed timestamp
3856: -- or get all the records in hercules view if the timestamp passed is null
3857: CURSOR c_uvoffabrv( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
3858: SELECT abbrevid
3859: ,timestamp
3860: ,RTRIM(updater) updater
3861: ,RTRIM(abbrevtext) abbrevtext

Line 3874: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

3870: SELECT MAX(timestamp)
3871: FROM igs_uc_u_uvofferabbrev_2003 ;
3872:
3873: -- Variables
3874: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3875: l_new_max_timestamp igs_uc_u_uvofferabbrev_2003.timestamp%TYPE ;
3876: l_count NUMBER ;
3877:
3878: BEGIN

Line 4274: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

4270: ,RTRIM(type) type
4271: FROM igs_uc_u_cvrefcountry_2007 ;
4272:
4273: -- Variables
4274: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4275: l_new_max_timestamp igs_uc_u_cvrefamendments_2007.country%TYPE ;
4276: l_count NUMBER ;
4277:
4278: BEGIN

Line 4361: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

4357: ,RTRIM(description) description
4358: FROM igs_uc_u_cvrefnationality_2007 ;
4359:
4360: -- Variables
4361: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4362: l_new_max_timestamp igs_uc_u_cvrefamendments_2007.nationality%TYPE ;
4363: l_count NUMBER ;
4364:
4365: BEGIN

Line 4448: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

4444: ,RTRIM(description) description
4445: FROM igs_uc_g_cvgrefdegreesubj_2006;
4446:
4447: -- Variables
4448: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4449: l_new_max_timestamp igs_uc_g_cvgrefamendments_2006.degreesubject%TYPE ;
4450: l_count NUMBER ;
4451:
4452: BEGIN

Line 4532: CURSOR c_ivoffer( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

4528: ***************************************************************** */
4529:
4530: -- Get all the records from hercules view whose timestamp is > passed timestamp
4531: -- or get all the records in hercules view if the timestamp passed is null
4532: CURSOR c_ivoffer( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
4533: SELECT appno
4534: ,choiceno
4535: ,timestamp
4536: ,DECODE(RTRIM(offercourse),NULL, RPAD('*',LENGTH(offercourse),'*'), RTRIM(offercourse)) offercourse

Line 4552: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

4548: SELECT MAX(timestamp)
4549: FROM igs_uc_ivoffer_2003_v ;
4550:
4551: -- Variables
4552: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4553: l_new_max_timestamp igs_uc_ivoffer_2003_v.timestamp%TYPE ;
4554: l_count NUMBER ;
4555:
4556: l_appno igs_uc_ioffer_ints.appno%TYPE;

Line 4660: CURSOR c_ivgoffer( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

4656: ***************************************************************** */
4657:
4658: -- Get all the records from odbc-link view whose timestamp is > passed timestamp
4659: -- or get all the records in odbc-link view if the timestamp passed is null
4660: CURSOR c_ivgoffer( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
4661: SELECT appno
4662: ,roundno
4663: ,timestamp
4664: ,RTRIM(offertext) offertext

Line 4674: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

4670: SELECT MAX(timestamp)
4671: FROM igs_uc_ivgoffer_2006_v ;
4672:
4673: -- Variables
4674: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4675: l_new_max_timestamp igs_uc_ivgoffer_2006_v.timestamp%TYPE ;
4676: l_appno igs_uc_ioffer_ints.appno%TYPE;
4677: l_checkdigit NUMBER;
4678: l_count NUMBER ;

Line 4769: CURSOR c_ivnoffer( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

4765: ***************************************************************** */
4766:
4767: -- Get all the records from odbc-link view whose timestamp is > passed timestamp
4768: -- or get all the records in odbc-link view if the timestamp passed is null
4769: CURSOR c_ivnoffer( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
4770: SELECT appno
4771: ,choiceno
4772: ,timestamp
4773: ,RTRIM(offertext) offertext

Line 4783: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

4779: SELECT MAX(timestamp)
4780: FROM igs_uc_ivnoffer_2006_v ;
4781:
4782: -- Variables
4783: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4784: l_new_max_timestamp igs_uc_ivnoffer_2006_v.timestamp%TYPE ;
4785: l_appno igs_uc_ioffer_ints.appno%TYPE;
4786: l_checkdigit NUMBER;
4787: l_count NUMBER ;

Line 4878: CURSOR c_ivqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

4874: ***************************************************************** */
4875:
4876: -- Get all the records from hercules view whose timestamp is > passed timestamp
4877: -- or get all the records in hercules view if the timestamp passed is null
4878: CURSOR c_ivqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
4879: SELECT appno
4880: ,timestamp
4881: ,RTRIM(matchprevious) matchprevious
4882: ,matchpreviousdate

Line 4899: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

4895: SELECT MAX(timestamp)
4896: FROM igs_uc_ivqualification_2003_v ;
4897:
4898: -- Variables
4899: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4900: l_new_max_timestamp igs_uc_ivqualification_2003_v.timestamp%TYPE ;
4901: l_count NUMBER ;
4902:
4903: l_appno igs_uc_iqual_ints.appno%TYPE;

Line 5005: CURSOR c_ivstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

5001: ***************************************************************** */
5002:
5003: -- Get all the records from hercules view whose timestamp is > passed timestamp
5004: -- or get all the records in hercules view if the timestamp passed is null
5005: CURSOR c_ivstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
5006: SELECT appno
5007: ,timestamp
5008: ,addressarea
5009: ,DECODE(RTRIM(address1),NULL, RPAD('*',LENGTH(address1),'*'), RTRIM(address1)) address1

Line 5035: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

5031: SELECT MAX(timestamp)
5032: FROM igs_uc_ivstara_2003_v ;
5033:
5034: -- Variables
5035: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5036: l_new_max_timestamp igs_uc_ivstara_2003_v.timestamp%TYPE ;
5037: l_count NUMBER ;
5038:
5039: BEGIN

Line 5149: CURSOR c_ivstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

5145: ***************************************************************** */
5146:
5147: -- Get all the records from hercules view whose timestamp is > passed timestamp
5148: -- or get all the records in hercules view if the timestamp passed is null
5149: CURSOR c_ivstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
5150: SELECT appno
5151: ,timestamp
5152: ,addressarea
5153: ,DECODE(RTRIM(address1),NULL, RPAD('*',LENGTH(address1),'*'), RTRIM(address1)) address1

Line 5175: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

5171: SELECT MAX(timestamp)
5172: FROM igs_uc_ivstara_2006_v ;
5173:
5174: -- Variables
5175: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5176: l_new_max_timestamp igs_uc_ivstara_2006_v.timestamp%TYPE ;
5177: l_count NUMBER ;
5178:
5179: l_appno igs_uc_istara_ints.appno%TYPE;

Line 5290: CURSOR c_ivstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

5286: ***************************************************************** */
5287:
5288: -- Get all the records from hercules view whose timestamp is > passed timestamp
5289: -- or get all the records in hercules view if the timestamp passed is null
5290: CURSOR c_ivstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
5291: SELECT appno
5292: ,timestamp
5293: ,addressarea
5294: ,DECODE(RTRIM(address1),NULL, RPAD('*',LENGTH(address1),'*'), RTRIM(address1)) address1

Line 5319: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

5315: SELECT MAX(timestamp)
5316: FROM igs_uc_ivstara_2007_v ;
5317:
5318: -- Variables
5319: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5320: l_new_max_timestamp igs_uc_ivstara_2007_v.timestamp%TYPE ;
5321: l_count NUMBER ;
5322:
5323: l_appno igs_uc_istara_ints.appno%TYPE;

Line 5441: CURSOR c_ivgstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

5437: ***************************************************************** */
5438:
5439: -- Get all the records from odbc-link view whose timestamp is > passed timestamp
5440: -- or get all the records in odbc-link view if the timestamp passed is null
5441: CURSOR c_ivgstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
5442: SELECT appno
5443: ,timestamp
5444: ,RTRIM(addressarea) addressarea
5445: ,DECODE(RTRIM(address1),NULL, RPAD('*',LENGTH(address1),'*'), RTRIM(address1)) address1

Line 5463: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

5459: SELECT MAX(timestamp)
5460: FROM igs_uc_ivgstara_2006_v ;
5461:
5462: -- Variables
5463: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5464: l_new_max_timestamp igs_uc_ivgstara_2006_v.timestamp%TYPE ;
5465: l_count NUMBER ;
5466:
5467: l_appno igs_uc_istara_ints.appno%TYPE;

Line 5571: CURSOR c_ivgstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

5567: ***************************************************************** */
5568:
5569: -- Get all the records from hercules view whose timestamp is > passed timestamp
5570: -- or get all the records in hercules view if the timestamp passed is null
5571: CURSOR c_ivgstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
5572: SELECT appno
5573: ,timestamp
5574: ,addressarea
5575: ,DECODE(RTRIM(address1),NULL, RPAD('*',LENGTH(address1),'*'), RTRIM(address1)) address1

Line 5600: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

5596: SELECT MAX(timestamp)
5597: FROM igs_uc_ivgstara_2007_v ;
5598:
5599: -- Variables
5600: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5601: l_new_max_timestamp igs_uc_ivgstara_2007_v.timestamp%TYPE ;
5602: l_count NUMBER ;
5603:
5604: l_appno igs_uc_istara_ints.appno%TYPE;

Line 5722: CURSOR c_ivnstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

5718: ***************************************************************** */
5719:
5720: -- Get all the records from odbc-link view whose timestamp is > passed timestamp
5721: -- or get all the records in odbc-link view if the timestamp passed is null
5722: CURSOR c_ivnstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
5723: SELECT appno
5724: ,timestamp
5725: ,RTRIM(addressarea) addressarea
5726: ,DECODE(RTRIM(address1),NULL, RPAD('*',LENGTH(address1),'*'), RTRIM(address1)) address1

Line 5744: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

5740: SELECT MAX(timestamp)
5741: FROM igs_uc_ivnstara_2006_v ;
5742:
5743: -- Variables
5744: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5745: l_new_max_timestamp igs_uc_ivnstara_2006_v.timestamp%TYPE ;
5746: l_count NUMBER ;
5747:
5748: l_appno igs_uc_istara_ints.appno%TYPE;

Line 5852: CURSOR c_ivnstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

5848: ***************************************************************** */
5849:
5850: -- Get all the records from hercules view whose timestamp is > passed timestamp
5851: -- or get all the records in hercules view if the timestamp passed is null
5852: CURSOR c_ivnstara ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
5853: SELECT appno
5854: ,timestamp
5855: ,addressarea
5856: ,DECODE(RTRIM(address1),NULL, RPAD('*',LENGTH(address1),'*'), RTRIM(address1)) address1

Line 5881: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

5877: SELECT MAX(timestamp)
5878: FROM igs_uc_ivnstara_2007_v ;
5879:
5880: -- Variables
5881: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5882: l_new_max_timestamp igs_uc_ivnstara_2007_v.timestamp%TYPE ;
5883: l_count NUMBER ;
5884:
5885: l_appno igs_uc_istara_ints.appno%TYPE;

Line 6007: CURSOR c_ivstarc ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

6003: ***************************************************************** */
6004:
6005: -- Get all the records from hercules view whose timestamp is > passed timestamp
6006: -- or get all the records in hercules view if the timestamp passed is null
6007: CURSOR c_ivstarc ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
6008: SELECT appno
6009: ,NVL(choiceno,9) choiceno -- 02-AUG-2006 anwest Bug #5440216 URGENT - UCAS CLEARING 2006 - PART 2 - CLEARING CHOICE NUMBER NULL
6010: ,timestamp
6011: ,NVL(lastchange,SYSDATE) lastchange

Line 6046: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

6042: SELECT MAX(timestamp)
6043: FROM igs_uc_ivstarc_2003_v ;
6044:
6045: -- Variables
6046: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6047: l_new_max_timestamp igs_uc_ivstarc_2003_v.timestamp%TYPE ;
6048: l_count NUMBER ;
6049:
6050: l_appno igs_uc_istarc_ints.appno%TYPE;

Line 6198: CURSOR c_ivnstarc ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

6194: ***************************************************************** */
6195:
6196: -- Get all the records from odbc-link view whose timestamp is > passed timestamp
6197: -- or get all the records in odbc-link view if the timestamp passed is null
6198: CURSOR c_ivnstarc ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
6199: SELECT appno
6200: ,NVL(choiceno,9) choiceno -- 02-AUG-2006 anwest Bug #5440216 URGENT - UCAS CLEARING 2006 - PART 2 - CLEARING CHOICE NUMBER NULL
6201: ,timestamp
6202: ,NVL(lastchange,SYSDATE) lastchange

Line 6229: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

6225: SELECT MAX(timestamp)
6226: FROM igs_uc_ivnstarc_2006_v ;
6227:
6228: -- Variables
6229: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6230: l_new_max_timestamp igs_uc_ivnstarc_2006_v.timestamp%TYPE ;
6231: l_count NUMBER ;
6232:
6233: l_appno igs_uc_istarc_ints.appno%TYPE;

Line 6363: CURSOR c_ivgstarg ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

6359: ***************************************************************** */
6360:
6361: -- Get all the records from odbc-link view whose timestamp is > passed timestamp
6362: -- or get all the records in odbc-link view if the timestamp passed is null
6363: CURSOR c_ivgstarg ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
6364: SELECT appno
6365: ,NVL(roundno,99) roundno -- 02-AUG-2006 anwest Bug #5440216 URGENT - UCAS CLEARING 2006 - PART 2 - CLEARING CHOICE NUMBER NULL
6366: ,timestamp
6367: ,NVL(lastchange,SYSDATE) lastchange

Line 6395: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

6391: SELECT MAX(timestamp)
6392: FROM igs_uc_ivgstarg_2006_v ;
6393:
6394: -- Variables
6395: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6396: l_new_max_timestamp igs_uc_ivgstarg_2006_v.timestamp%TYPE ;
6397: l_count NUMBER ;
6398:
6399: l_appno igs_uc_istarc_ints.appno%TYPE;

Line 6530: CURSOR c_ivstarh ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

6526: ***************************************************************** */
6527:
6528: -- Get all the records from hercules view whose timestamp is > passed timestamp
6529: -- or get all the records in hercules view if the timestamp passed is null
6530: CURSOR c_ivstarh ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
6531: SELECT appno
6532: ,timestamp
6533: ,ethnic
6534: ,RTRIM(socialclass) socialclass

Line 6551: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

6547: SELECT MAX(timestamp)
6548: FROM igs_uc_ivstarh_2003_v ;
6549:
6550: -- Variables
6551: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6552: l_new_max_timestamp igs_uc_ivstarh_2003_v.timestamp%TYPE ;
6553: l_count NUMBER ;
6554:
6555: l_appno igs_uc_istarh_ints.appno%TYPE;

Line 6664: CURSOR c_ivgstarh ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

6660: ***************************************************************** */
6661:
6662: -- Get all the records from hercules view whose timestamp is > passed timestamp
6663: -- or get all the records in hercules view if the timestamp passed is null
6664: CURSOR c_ivgstarh ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
6665: SELECT appno
6666: ,timestamp
6667: ,RTRIM(ethnic) ethnic
6668: FROM igs_uc_ivgstarh_2006_v

Line 6677: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

6673: SELECT MAX(timestamp)
6674: FROM igs_uc_ivgstarh_2006_v ;
6675:
6676: -- Variables
6677: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6678: l_new_max_timestamp igs_uc_ivgstarh_2006_v.timestamp%TYPE ;
6679: l_count NUMBER ;
6680:
6681: l_appno igs_uc_istarh_ints.appno%TYPE;

Line 6770: CURSOR c_ivnstarh ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

6766: ***************************************************************** */
6767:
6768: -- Get all the records from hercules view whose timestamp is > passed timestamp
6769: -- or get all the records in hercules view if the timestamp passed is null
6770: CURSOR c_ivnstarh ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
6771: SELECT appno
6772: ,timestamp
6773: ,RTRIM(ethnic) ethnic
6774: ,numberdependants

Line 6785: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

6781: SELECT MAX(timestamp)
6782: FROM igs_uc_ivnstarh_2006_v ;
6783:
6784: -- Variables
6785: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6786: l_new_max_timestamp igs_uc_ivnstarh_2006_v.timestamp%TYPE ;
6787: l_count NUMBER ;
6788:
6789: l_appno igs_uc_istarh_ints.appno%TYPE;

Line 6884: CURSOR c_ivstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

6880:
6881: -- Get all the records from hercules view whose timestamp is > passed timestamp
6882: -- or get all the records in hercules view if the timestamp passed is null
6883: -- converting EAS field ,for bug#3087852
6884: CURSOR c_ivstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
6885: SELECT appno
6886: ,timestamp
6887: ,applicationdate
6888: ,sentdate

Line 6950: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

6946: SELECT MAX(timestamp)
6947: FROM igs_uc_ivstark_2003_v ;
6948:
6949: -- Variables
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;

Line 7178: CURSOR c_ivstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

7174:
7175: -- Get all the records from hercules view whose timestamp is > passed timestamp
7176: -- or get all the records in hercules view if the timestamp passed is null
7177: -- converting EAS field ,for bug#3087852
7178: CURSOR c_ivstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
7179: SELECT appno
7180: ,timestamp
7181: ,applicationdate
7182: ,sentdate

Line 7244: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

7240: SELECT MAX(timestamp)
7241: FROM igs_uc_ivstark_2007_v ;
7242:
7243: -- Variables
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;

Line 7472: CURSOR c_ivgstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

7468:
7469: -- Get all the records from hercules view whose timestamp is > passed timestamp
7470: -- or get all the records in hercules view if the timestamp passed is null
7471: -- converting EAS field ,for bug#3087852
7472: CURSOR c_ivgstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
7473: SELECT appno
7474: ,timestamp
7475: ,applicationdate
7476: ,codedchangedate

Line 7499: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

7495: SELECT MAX(timestamp)
7496: FROM igs_uc_ivgstark_2006_v ;
7497:
7498: -- Variables
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;

Line 7624: CURSOR c_ivgstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

7620:
7621: -- Get all the records from hercules view whose timestamp is > passed timestamp
7622: -- or get all the records in hercules view if the timestamp passed is null
7623: -- converting EAS field ,for bug#3087852
7624: CURSOR c_ivgstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
7625: SELECT appno
7626: ,timestamp
7627: ,applicationdate
7628: ,codedchangedate

Line 7651: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

7647: SELECT MAX(timestamp)
7648: FROM igs_uc_ivgstark_2007_v ;
7649:
7650: -- Variables
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;

Line 7776: CURSOR c_ivnstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

7772:
7773: -- Get all the records from hercules view whose timestamp is > passed timestamp
7774: -- or get all the records in hercules view if the timestamp passed is null
7775: -- converting EAS field ,for bug#3087852
7776: CURSOR c_ivnstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
7777: SELECT appno
7778: ,timestamp
7779: ,applicationdate
7780: ,sentdate

Line 7813: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

7809: SELECT MAX(timestamp)
7810: FROM igs_uc_ivnstark_2006_v ;
7811:
7812: -- Variables
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;

Line 7966: CURSOR c_ivnstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

7962:
7963: -- Get all the records from hercules view whose timestamp is > passed timestamp
7964: -- or get all the records in hercules view if the timestamp passed is null
7965: -- converting EAS field ,for bug#3087852
7966: CURSOR c_ivnstark ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
7967: SELECT appno
7968: ,timestamp
7969: ,applicationdate
7970: ,sentdate

Line 8003: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

7999: SELECT MAX(timestamp)
8000: FROM igs_uc_ivnstark_2007_v ;
8001:
8002: -- Variables
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;

Line 8155: CURSOR c_ivstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

8151: ***************************************************************** */
8152:
8153: -- Get all the records from hercules view whose timestamp is > passed timestamp
8154: -- or get all the records in hercules view if the timestamp passed is null
8155: CURSOR c_ivstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
8156: SELECT appno
8157: ,timestamp
8158: ,checkdigit
8159: ,namechangedate

Line 8174: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

8170: SELECT MAX(timestamp)
8171: FROM igs_uc_ivstarn_2003_v ;
8172:
8173: -- Variables
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;

Line 8283: CURSOR c_ivstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

8279: ***************************************************************** */
8280:
8281: -- Get all the records from hercules view whose timestamp is > passed timestamp
8282: -- or get all the records in hercules view if the timestamp passed is null
8283: CURSOR c_ivstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
8284: SELECT appno
8285: ,RTRIM(personalid) personalid
8286: ,timestamp
8287: ,checkdigit

Line 8303: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

8299: SELECT MAX(timestamp)
8300: FROM igs_uc_ivstarn_2007_v ;
8301:
8302: -- Variables
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;

Line 8414: CURSOR c_ivgstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

8410: ***************************************************************** */
8411:
8412: -- Get all the records from hercules view whose timestamp is > passed timestamp
8413: -- or get all the records in hercules view if the timestamp passed is null
8414: CURSOR c_ivgstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
8415: SELECT appno
8416: ,timestamp
8417: ,UPPER(RTRIM(title)) title
8418: ,RTRIM(forenames) forenames

Line 8431: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

8427: SELECT MAX(timestamp)
8428: FROM igs_uc_ivgstarn_2006_v ;
8429:
8430: -- Variables
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;

Line 8537: CURSOR c_ivgstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

8533: ***************************************************************** */
8534:
8535: -- Get all the records from hercules view whose timestamp is > passed timestamp
8536: -- or get all the records in hercules view if the timestamp passed is null
8537: CURSOR c_ivgstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
8538: SELECT appno
8539: ,personalid
8540: ,timestamp
8541: ,UPPER(RTRIM(title)) title

Line 8555: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

8551: SELECT MAX(timestamp)
8552: FROM igs_uc_ivgstarn_2007_v ;
8553:
8554: -- Variables
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;

Line 8664: CURSOR c_ivnstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

8660: ***************************************************************** */
8661:
8662: -- Get all the records from hercules view whose timestamp is > passed timestamp
8663: -- or get all the records in hercules view if the timestamp passed is null
8664: CURSOR c_ivnstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
8665: SELECT appno
8666: ,timestamp
8667: ,UPPER(RTRIM(title)) title
8668: ,RTRIM(forenames) forenames

Line 8681: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

8677: SELECT MAX(timestamp)
8678: FROM igs_uc_ivnstarn_2006_v ;
8679:
8680: -- Variables
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;

Line 8787: CURSOR c_ivnstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

8783: ***************************************************************** */
8784:
8785: -- Get all the records from hercules view whose timestamp is > passed timestamp
8786: -- or get all the records in hercules view if the timestamp passed is null
8787: CURSOR c_ivnstarn ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
8788: SELECT appno
8789: ,personalid
8790: ,timestamp
8791: ,UPPER(RTRIM(title)) title

Line 8805: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

8801: SELECT MAX(timestamp)
8802: FROM igs_uc_ivnstarn_2007_v ;
8803:
8804: -- Variables
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;

Line 8916: CURSOR c_ivqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

8912: ***************************************************************** */
8913:
8914: -- Get all the records from hercules view whose timestamp is > passed timestamp
8915: -- or get all the records in hercules view if the timestamp passed is null
8916: CURSOR c_ivqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
8917: SELECT appno
8918: FROM igs_uc_ivqualification_2003_v
8919: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
8920:

Line 8934: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

8930: FROM igs_uc_ivstarpqr_2003_v
8931: WHERE appno = cp_appno ;
8932:
8933: -- Variables
8934: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8935: l_count NUMBER ;
8936:
8937: l_appno_qual igs_uc_ivqualification_2003_v.appno%TYPE;
8938: l_checkdigit_qual NUMBER;

Line 9068: CURSOR c_ivqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

9064: ***************************************************************** */
9065:
9066: -- Get all the records from hercules view whose timestamp is > passed timestamp
9067: -- or get all the records in hercules view if the timestamp passed is null
9068: CURSOR c_ivqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
9069: SELECT appno
9070: FROM igs_uc_ivqualification_2003_v
9071: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
9072:

Line 9084: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

9080: FROM igs_uc_ivstarpqr_2003_v
9081: WHERE appno = cp_appno ;
9082:
9083: -- Variables
9084: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9085: l_count NUMBER ;
9086:
9087: l_appno_qual igs_uc_ivqualification_2003_v.appno%TYPE;
9088: l_checkdigit_qual NUMBER;

Line 9214: CURSOR c_ivstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

9210: ***************************************************************** */
9211:
9212: -- Get all the records from hercules view whose timestamp is > passed timestamp
9213: -- or get all the records in hercules view if the timestamp passed is null
9214: CURSOR c_ivstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
9215: SELECT appno
9216: , timestamp
9217: , RTRIM(miscoded) miscoded
9218: , RTRIM(cancelled) cancelled

Line 9231: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

9227: SELECT MAX(timestamp)
9228: FROM igs_uc_ivstarw_2003_v ;
9229:
9230: -- Variables
9231: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9232: l_new_max_timestamp igs_uc_ivstarw_2003_v.timestamp%TYPE ;
9233: l_count NUMBER ;
9234:
9235: BEGIN

Line 9333: CURSOR c_ivstarx ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

9329: ***************************************************************** */
9330:
9331: -- Get all the records from hercules view whose timestamp is > passed timestamp
9332: -- or get all the records in hercules view if the timestamp passed is null
9333: CURSOR c_ivstarx ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
9334: SELECT appno
9335: ,timestamp
9336: ,ethnic
9337: ,pocceduchangedate

Line 9352: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

9348: SELECT MAX(timestamp)
9349: FROM igs_uc_ivstarx_2003_v ;
9350:
9351: -- Variables
9352: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9353: l_new_max_timestamp igs_uc_ivstarx_2003_v.timestamp%TYPE ;
9354: l_count NUMBER ;
9355:
9356: l_appno igs_uc_istarx_ints.appno%TYPE;

Line 9463: CURSOR c_ivgstarx ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

9459: ***************************************************************** */
9460:
9461: -- Get all the records from hercules view whose timestamp is > passed timestamp
9462: -- or get all the records in hercules view if the timestamp passed is null
9463: CURSOR c_ivgstarx ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
9464: SELECT appno
9465: ,timestamp
9466: ,ethnic
9467: FROM igs_uc_ivgstarx_2006_v

Line 9476: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

9472: SELECT MAX(timestamp)
9473: FROM igs_uc_ivgstarx_2006_v ;
9474:
9475: -- Variables
9476: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9477: l_new_max_timestamp igs_uc_ivgstarx_2006_v.timestamp%TYPE ;
9478: l_count NUMBER ;
9479:
9480: l_appno igs_uc_istarx_ints.appno%TYPE;

Line 9569: CURSOR c_ivnstarx ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

9565: ***************************************************************** */
9566:
9567: -- Get all the records from hercules view whose timestamp is > passed timestamp
9568: -- or get all the records in hercules view if the timestamp passed is null
9569: CURSOR c_ivnstarx ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
9570: SELECT appno
9571: ,timestamp
9572: ,ethnic
9573: ,numberdependants

Line 9584: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

9580: SELECT MAX(timestamp)
9581: FROM igs_uc_ivnstarx_2006_v ;
9582:
9583: -- Variables
9584: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9585: l_new_max_timestamp igs_uc_ivnstarx_2006_v.timestamp%TYPE ;
9586: l_count NUMBER ;
9587:
9588: l_appno igs_uc_istarx_ints.appno%TYPE;

Line 9684: CURSOR c_ivstarz1 ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

9680:
9681:
9682: -- Get all the records from hercules view whose timestamp is > passed timestamp
9683: -- or get all the records in hercules view if the timestamp passed is null
9684: CURSOR c_ivstarz1 ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
9685: SELECT appno
9686: ,timestamp
9687: ,datecefsent
9688: ,cefno

Line 9707: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

9703: SELECT MAX(timestamp)
9704: FROM igs_uc_ivstarz1_2003_v ;
9705:
9706: -- Variables
9707: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9708: l_new_max_timestamp igs_uc_ivstarz1_2003_v.timestamp%TYPE ;
9709: l_count NUMBER ;
9710:
9711: l_appno igs_uc_istarz1_ints.appno%TYPE;

Line 9820: CURSOR c_ivnstarz1 ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

9816:
9817:
9818: -- Get all the records from hercules view whose timestamp is > passed timestamp
9819: -- or get all the records in hercules view if the timestamp passed is null
9820: CURSOR c_ivnstarz1 ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
9821: SELECT appno
9822: ,timestamp
9823: ,cefno
9824: ,DECODE(RTRIM(inst),NULL, RPAD('*',LENGTH(inst),'*'), RTRIM(inst)) inst

Line 9839: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

9835: SELECT MAX(timestamp)
9836: FROM igs_uc_ivnstarz1_2006_v ;
9837:
9838: -- Variables
9839: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9840: l_new_max_timestamp igs_uc_ivnstarz1_2006_v.timestamp%TYPE ;
9841: l_count NUMBER ;
9842:
9843: l_appno igs_uc_istarz1_ints.appno%TYPE;

Line 9942: CURSOR c_ivstarz2 ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

9938: ***************************************************************** */
9939:
9940: -- Get all the records from hercules view whose timestamp is > passed timestamp
9941: -- or get all the records in hercules view if the timestamp passed is null
9942: CURSOR c_ivstarz2 ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
9943: SELECT appno
9944: , roundno
9945: , timestamp
9946: , DECODE(RTRIM(inst),NULL, RPAD('*',LENGTH(inst),'*'), RTRIM(inst)) inst

Line 9961: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

9957: SELECT MAX(timestamp)
9958: FROM igs_uc_ivstarz2_2003_v ;
9959:
9960: -- Variables
9961: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9962: l_new_max_timestamp igs_uc_ivstarz2_2003_v.timestamp%TYPE ;
9963: l_count NUMBER ;
9964:
9965: BEGIN

Line 10141: CURSOR c_stmt (p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

10137: ***************************************************************** */
10138:
10139: -- Get all the records from hercules view whose timestamp is > passed timestamp
10140: -- or get all the records in hercules view if the timestamp passed is null
10141: CURSOR c_stmt (p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
10142: SELECT appno,statement
10143: FROM igs_uc_ivstatement_2004_v
10144: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
10145:

Line 10152: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

10148: SELECT MAX(timestamp)
10149: FROM igs_uc_ivstatement_2004_v ;
10150:
10151: -- Variables
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;

Line 10244: CURSOR c_stmt (p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

10240: ***************************************************************** */
10241:
10242: -- Get all the records from hercules view whose timestamp is > passed timestamp
10243: -- or get all the records in hercules view if the timestamp passed is null
10244: CURSOR c_stmt (p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
10245: SELECT appno,statement
10246: FROM igs_uc_ivgstatement_2006_v
10247: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
10248:

Line 10255: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

10251: SELECT MAX(timestamp)
10252: FROM igs_uc_ivgstatement_2006_v ;
10253:
10254: -- Variables
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;

Line 10347: CURSOR c_stmt (p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

10343: ***************************************************************** */
10344:
10345: -- Get all the records from hercules view whose timestamp is > passed timestamp
10346: -- or get all the records in hercules view if the timestamp passed is null
10347: CURSOR c_stmt (p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
10348: SELECT appno,statement
10349: FROM igs_uc_ivnstatement_2006_v
10350: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
10351:

Line 10358: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

10354: SELECT MAX(timestamp)
10355: FROM igs_uc_ivnstatement_2006_v ;
10356:
10357: -- Variables
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;

Line 10450: CURSOR c_uinst ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

10446: ***************************************************************** */
10447:
10448: -- Get all the records from hercules view whose timestamp is > passed timestamp
10449: -- or get all the records in hercules view if the timestamp passed is null
10450: CURSOR c_uinst ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
10451: SELECT timestamp
10452: ,DECODE(RTRIM(updater),NULL, RPAD('*',LENGTH(updater),'*'), RTRIM(updater)) updater
10453: ,DECODE(RTRIM(insttype),NULL, RPAD('*',LENGTH(insttype),'*'), RTRIM(insttype)) insttype
10454: ,RTRIM(instshortname) instshortname

Line 10507: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

10503: SELECT MAX(timestamp)
10504: FROM igs_uc_u_uvinstitution_2004 ;
10505:
10506: -- Variables
10507: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10508: l_new_max_timestamp igs_uc_u_uvinstitution_2004.timestamp%TYPE ;
10509: l_count NUMBER ;
10510:
10511: BEGIN

Line 10675: CURSOR c_ivstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

10671:
10672:
10673: -- Get all the records from hercules view whose timestamp is > passed timestamp
10674: -- or get all the records in hercules view if the timestamp passed is null
10675: CURSOR c_ivstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
10676: SELECT appno
10677: , timestamp
10678: , RTRIM(miscoded) miscoded
10679: , RTRIM(cancelled) cancelled

Line 10699: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

10695: SELECT MAX(timestamp)
10696: FROM igs_uc_ivstarw_2004_v ;
10697:
10698: -- Variables
10699: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10700: l_new_max_timestamp igs_uc_ivstarw_2004_v.timestamp%TYPE ;
10701: l_count NUMBER ;
10702:
10703: l_appno igs_uc_istarw_ints.appno%TYPE;

Line 10813: CURSOR c_ivgstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

10809:
10810:
10811: -- Get all the records from hercules view whose timestamp is > passed timestamp
10812: -- or get all the records in hercules view if the timestamp passed is null
10813: CURSOR c_ivgstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
10814: SELECT appno
10815: , timestamp
10816: , RTRIM(miscoded) miscoded
10817: , RTRIM(cancelled) cancelled

Line 10828: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

10824: SELECT MAX(timestamp)
10825: FROM igs_uc_ivgstarw_2006_v ;
10826:
10827: -- Variables
10828: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10829: l_new_max_timestamp igs_uc_ivgstarw_2006_v.timestamp%TYPE ;
10830: l_count NUMBER ;
10831:
10832: l_appno igs_uc_istarw_ints.appno%TYPE;

Line 10924: CURSOR c_ivgstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

10920:
10921:
10922: -- Get all the records from hercules view whose timestamp is > passed timestamp
10923: -- or get all the records in hercules view if the timestamp passed is null
10924: CURSOR c_ivgstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
10925: SELECT appno
10926: , timestamp
10927: , RTRIM(miscoded) miscoded
10928: , RTRIM(cancelled) cancelled

Line 10940: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

10936: SELECT MAX(timestamp)
10937: FROM igs_uc_ivgstarw_2007_v ;
10938:
10939: -- Variables
10940: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10941: l_new_max_timestamp igs_uc_ivgstarw_2007_v.timestamp%TYPE ;
10942: l_count NUMBER ;
10943:
10944: l_appno igs_uc_istarw_ints.appno%TYPE;

Line 11038: CURSOR c_ivnstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

11034:
11035:
11036: -- Get all the records from hercules view whose timestamp is > passed timestamp
11037: -- or get all the records in hercules view if the timestamp passed is null
11038: CURSOR c_ivnstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
11039: SELECT appno
11040: , timestamp
11041: , RTRIM(miscoded) miscoded
11042: , RTRIM(cancelled) cancelled

Line 11053: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

11049: SELECT MAX(timestamp)
11050: FROM igs_uc_ivnstarw_2006_v ;
11051:
11052: -- Variables
11053: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11054: l_new_max_timestamp igs_uc_ivnstarw_2006_v.timestamp%TYPE ;
11055: l_count NUMBER ;
11056:
11057: l_appno igs_uc_istarw_ints.appno%TYPE;

Line 11149: CURSOR c_ivnstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

11145:
11146:
11147: -- Get all the records from hercules view whose timestamp is > passed timestamp
11148: -- or get all the records in hercules view if the timestamp passed is null
11149: CURSOR c_ivnstarw ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
11150: SELECT appno
11151: , timestamp
11152: , RTRIM(miscoded) miscoded
11153: , RTRIM(cancelled) cancelled

Line 11165: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

11161: SELECT MAX(timestamp)
11162: FROM igs_uc_ivnstarw_2007_v ;
11163:
11164: -- Variables
11165: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11166: l_new_max_timestamp igs_uc_ivnstarw_2007_v.timestamp%TYPE ;
11167: l_count NUMBER ;
11168:
11169: l_appno igs_uc_istarw_ints.appno%TYPE;

Line 11262: CURSOR c_ivformqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

11258: ***************************************************************** */
11259:
11260: -- Get all the records from hercules view whose timestamp is > passed timestamp
11261: -- or get all the records in hercules view if the timestamp passed is null
11262: CURSOR c_ivformqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
11263: SELECT appno
11264: ,timestamp
11265: ,qualid
11266: ,RTRIM(qualtype) qualtype

Line 11280: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

11276: SELECT MAX(timestamp)
11277: FROM igs_uc_ivformquals_2004_v ;
11278:
11279: -- Variables
11280: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11281: l_new_max_timestamp igs_uc_ivformquals_2004_v.timestamp%TYPE ;
11282: l_count NUMBER ;
11283:
11284: l_appno igs_uc_ifrmqul_ints.appno%TYPE;

Line 11384: CURSOR c_ivformqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

11380: ***************************************************************** */
11381:
11382: -- Get all the records from hercules view whose timestamp is > passed timestamp
11383: -- or get all the records in hercules view if the timestamp passed is null
11384: CURSOR c_ivformqual ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
11385: SELECT appno
11386: ,timestamp
11387: ,qualid
11388: ,RTRIM(SUBSTR(qualtype,1,30)) qualtype

Line 11403: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

11399: SELECT MAX(timestamp)
11400: FROM igs_uc_ivformquals_2006_v ;
11401:
11402: -- Variables
11403: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11404: l_new_max_timestamp igs_uc_ivformquals_2006_v.timestamp%TYPE ;
11405: l_count NUMBER ;
11406:
11407: l_qualdate igs_uc_ifrmqul_ints.qualdate%TYPE;

Line 11515: CURSOR c_ivreference ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

11511: ***************************************************************** */
11512:
11513: -- Get all the records from hercules view whose timestamp is > passed timestamp
11514: -- or get all the records in hercules view if the timestamp passed is null
11515: CURSOR c_ivreference ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
11516: SELECT appno
11517: ,timestamp
11518: ,DECODE(RTRIM(refereename),NULL, RPAD('*',LENGTH(refereename),'*'), RTRIM(refereename)) refereename
11519: ,RTRIM(refereepost) refereepost

Line 11538: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

11534: SELECT MAX(timestamp)
11535: FROM igs_uc_ivreference_2004_v ;
11536:
11537: -- Variables
11538: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11539: l_new_max_timestamp igs_uc_ivreference_2004_v.timestamp%TYPE ;
11540: l_count NUMBER ;
11541:
11542: BEGIN

Line 11640: CURSOR c_ivreference ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

11636: ***************************************************************** */
11637:
11638: -- Get all the records from hercules view whose timestamp is > passed timestamp
11639: -- or get all the records in hercules view if the timestamp passed is null
11640: CURSOR c_ivreference ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
11641: SELECT appno
11642: ,timestamp
11643: ,DECODE(RTRIM(refereename),NULL, RPAD('*',LENGTH(refereename),'*'), RTRIM(refereename)) refereename
11644: ,RTRIM(refereepost) refereepost

Line 11664: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

11660: SELECT MAX(timestamp)
11661: FROM igs_uc_ivreference_2006_v ;
11662:
11663: -- Variables
11664: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11665: l_new_max_timestamp igs_uc_ivreference_2006_v.timestamp%TYPE ;
11666: l_count NUMBER ;
11667:
11668: l_appno igs_uc_irefrnc_ints.appno%TYPE;

Line 11777: CURSOR c_ivgreference ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

11773: ***************************************************************** */
11774:
11775: -- Get all the records from hercules view whose timestamp is > passed timestamp
11776: -- or get all the records in hercules view if the timestamp passed is null
11777: CURSOR c_ivgreference ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
11778: SELECT appno
11779: ,timestamp
11780: ,DECODE(RTRIM(refereename),NULL, RPAD('*',LENGTH(refereename),'*'), RTRIM(refereename)) refereename
11781: ,RTRIM(refereepost) refereepost

Line 11800: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

11796: SELECT MAX(timestamp)
11797: FROM igs_uc_ivgreference_2006_v ;
11798:
11799: -- Variables
11800: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11801: l_new_max_timestamp igs_uc_ivgreference_2006_v.timestamp%TYPE ;
11802: l_count NUMBER ;
11803:
11804: l_appno igs_uc_irefrnc_ints.appno%TYPE;

Line 11911: CURSOR c_ivnreference ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS

11907: ***************************************************************** */
11908:
11909: -- Get all the records from hercules view whose timestamp is > passed timestamp
11910: -- or get all the records in hercules view if the timestamp passed is null
11911: CURSOR c_ivnreference ( p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
11912: SELECT appno
11913: ,timestamp
11914: ,DECODE(RTRIM(refereename),NULL, RPAD('*',LENGTH(refereename),'*'), RTRIM(refereename)) refereename
11915: ,RTRIM(refereepost) refereepost

Line 11934: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

11930: SELECT MAX(timestamp)
11931: FROM igs_uc_ivnreference_2006_v ;
11932:
11933: -- Variables
11934: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11935: l_new_max_timestamp igs_uc_ivnreference_2006_v.timestamp%TYPE ;
11936: l_count NUMBER ;
11937:
11938: l_appno igs_uc_irefrnc_ints.appno%TYPE;