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_EN_VAL_SCHO dependencies on IGS_ST_CITIZENSHP_CD

Line 1057: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;

1053: RETURN BOOLEAN AS
1054: BEGIN
1055: DECLARE
1056: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
1057: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;
1058: v_govt_perm_resident_cd
1059: IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE DEFAULT NULL;
1060: v_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE;
1061: v_exit BOOLEAN DEFAULT FALSE;

Line 1073: IGS_ST_CITIZENSHP_CD CIT,

1069: PS.end_dt,
1070: CIT.govt_citizenship_cd,
1071: PRCD.govt_perm_resident_cd
1072: FROM IGS_PE_STATISTICS PS,
1073: IGS_ST_CITIZENSHP_CD CIT,
1074: IGS_PE_PERM_RES_CD PRCD
1075: WHERE PS.person_id = p_person_id AND
1076: PS.citizenship_cd = CIT.citizenship_cd AND
1077: PS.perm_resident_cd = PRCD.perm_resident_cd (+)

Line 1082: FROM IGS_ST_CITIZENSHP_CD

1078: ORDER BY PS.start_dt,
1079: PS.end_dt;
1080: CURSOR c_gccd IS
1081: SELECT govt_citizenship_cd
1082: FROM IGS_ST_CITIZENSHP_CD
1083: WHERE citizenship_cd = p_citizenship_cd;
1084: CURSOR c_gprcd IS
1085: SELECT govt_perm_resident_cd
1086: FROM IGS_PE_PERM_RES_CD

Line 1135: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,

1131: END enrpl_chk_whether_to_validate;
1132: FUNCTION enrpl_do_validations (
1133: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,
1134: p_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE,
1135: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,
1136: p_govt_perm_resident_cd IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE)
1137: RETURN BOOLEAN AS
1138: BEGIN
1139: DECLARE

Line 1144: -- then the govt. value for the IGS_ST_CITIZENSHP_CD must be

1140: v_other_detail VARCHAR2(255);
1141: BEGIN
1142: -- this module performs the validation that is
1143: -- required, in that if the IGS_FI_GOV_HEC_PA_OP = 12
1144: -- then the govt. value for the IGS_ST_CITIZENSHP_CD must be
1145: -- 3 and the govt. value for the IGS_PE_PERM_RES_CD must
1146: -- be 2
1147: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 12
1148: IF p_govt_hecs_payment_option = cst_hecs_upfront AND

Line 1173: -- IGS_ST_CITIZENSHP_CD and the IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD.

1169: END enrpl_do_validations;
1170: BEGIN
1171: -- This is the main module which validates the student_course_hecs_
1172: -- option_v.IGS_FI_HECS_PAY_OPTN against the IGS_PE_STATISTICS.
1173: -- IGS_ST_CITIZENSHP_CD and the IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD.
1174: p_message_name := null;
1175: -- validating the input parameters
1176: IF p_person_id IS NULL THEN
1177: RETURN TRUE;

Line 1198: -- IGS_ST_CITIZENSHP_CD and the IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD,

1194: CLOSE c_ghpo;
1195: -- set the below variable to the input parameter
1196: v_outside_aus_res_ind := p_outside_aus_res_ind;
1197: -- retrieving the govt. value for the IGS_PE_STATISTICS.
1198: -- IGS_ST_CITIZENSHP_CD and the IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD,
1199: -- in which more than one may be found
1200: FOR v_citz_record IN c_gcitiz LOOP
1201: -- execute the rountine which checks whether
1202: -- further validation is required.

Line 1228: -- IGS_ST_CITIZENSHP_CD

1224: IF p_ps_start_dt IS NULL THEN
1225: RETURN TRUE;
1226: END IF;
1227: -- retrieving the govt. value for the IGS_PE_STATISTICS.
1228: -- IGS_ST_CITIZENSHP_CD
1229: OPEN c_gccd;
1230: FETCH c_gccd INTO v_govt_citizenship_cd;
1231: -- exit successfully if a record isn't found
1232: -- therefore, no validation is required

Line 1304: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE

1300: p_return_type OUT NOCOPY VARCHAR2 )
1301: RETURN BOOLEAN AS
1302: BEGIN
1303: DECLARE
1304: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE
1305: DEFAULT NULL;
1306: v_govt_perm_resident_cd IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE
1307: DEFAULT NULL;
1308: v_return_false BOOLEAN DEFAULT FALSE;

Line 1319: IGS_ST_CITIZENSHP_CD cic,

1315: ps.end_dt,
1316: cic.govt_citizenship_cd,
1317: prcd.govt_perm_resident_cd
1318: FROM IGS_PE_STATISTICS ps,
1319: IGS_ST_CITIZENSHP_CD cic,
1320: IGS_PE_PERM_RES_CD prcd
1321: WHERE ps.person_id = p_person_id AND
1322: ps.citizenship_cd = cic.citizenship_cd AND
1323: ps.perm_resident_cd = prcd.perm_resident_cd (+)

Line 1328: FROM IGS_ST_CITIZENSHP_CD cic

1324: ORDER BY ps.start_dt,
1325: ps.end_dt;
1326: CURSOR c_cic IS
1327: SELECT cic.govt_citizenship_cd
1328: FROM IGS_ST_CITIZENSHP_CD cic
1329: WHERE cic.citizenship_cd = p_citizenship_cd;
1330: CURSOR c_schov IS
1331: SELECT schov.start_dt,
1332: schov.end_dt,

Line 1378: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,

1374: p_nz_citizen_less2yr_ind
1375: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_less2yr_ind%TYPE,
1376: p_nz_citizen_not_res_ind
1377: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_not_res_ind%TYPE,
1378: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,
1379: p_govt_perm_resident_cd IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE)
1380: RETURN BOOLEAN AS
1381: BEGIN
1382: DECLARE

Line 1385: -- checking that if the govt. value for the IGS_ST_CITIZENSHP_CD

1381: BEGIN
1382: DECLARE
1383: v_other_detail VARCHAR2(255);
1384: BEGIN
1385: -- checking that if the govt. value for the IGS_ST_CITIZENSHP_CD
1386: -- is 1, 4, or 5, or it is 3 and the govt. value for the
1387: -- IGS_PE_PERM_RES_CD is 1 or 3, then the visa indicators
1388: -- must not be set
1389: -- checking the IGS_PE_GOVCITIZEN_CD and IGS_PE_GOV_PER_RESCD

Line 1420: -- IGS_ST_CITIZENSHP_CD.

1416: END enrpl_do_validations;
1417: BEGIN
1418: -- This is the main module which validates the student_course_hecs_
1419: -- option_v.IGS_FI_HECS_PAY_OPTN against the IGS_PE_STATISTICS.
1420: -- IGS_ST_CITIZENSHP_CD.
1421: p_message_name := null;
1422: -- validating the input parameters
1423: IF p_person_id IS NULL THEN
1424: RETURN TRUE;

Line 1432: -- IGS_ST_CITIZENSHP_CD, and the government value for the

1428: IF p_scho_start_dt IS NULL THEN
1429: RETURN TRUE;
1430: END IF;
1431: -- retrieving the govt. value for the IGS_PE_STATISTICS.
1432: -- IGS_ST_CITIZENSHP_CD, and the government value for the
1433: -- IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD, in which more
1434: -- than one may be found
1435: FOR v_ps_rec IN c_ps LOOP
1436: -- execute the rountine which checks whether

Line 1466: -- IGS_ST_CITIZENSHP_CD

1462: IF p_ps_start_dt IS NULL THEN
1463: RETURN TRUE;
1464: END IF;
1465: -- retrieving the govt. value for the IGS_PE_STATISTICS.
1466: -- IGS_ST_CITIZENSHP_CD
1467: OPEN c_cic;
1468: FETCH c_cic INTO v_govt_citizenship_cd;
1469: -- exit successfully if a record isn't found
1470: -- therefore, no validation is required

Line 1824: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;

1820: RETURN BOOLEAN AS
1821: BEGIN
1822: DECLARE
1823: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
1824: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;
1825: v_return_false BOOLEAN DEFAULT FALSE;
1826: CURSOR c_hpo IS
1827: SELECT hpo.govt_hecs_payment_option
1828: FROM IGS_FI_HECS_PAY_OPTN hpo

Line 1837: IGS_ST_CITIZENSHP_CD cic

1833: ps.end_dt,
1834: cic.govt_citizenship_cd,
1835: ps.yr_arrival
1836: FROM IGS_PE_STATISTICS ps,
1837: IGS_ST_CITIZENSHP_CD cic
1838: WHERE ps.person_id = p_person_id AND
1839: ps.citizenship_cd = cic.citizenship_cd(+)
1840: ORDER BY ps.start_dt,
1841: ps.end_dt;

Line 1844: FROM IGS_ST_CITIZENSHP_CD gcc

1840: ORDER BY ps.start_dt,
1841: ps.end_dt;
1842: CURSOR c_gcc IS
1843: SELECT gcc.govt_citizenship_cd
1844: FROM IGS_ST_CITIZENSHP_CD gcc
1845: WHERE gcc.citizenship_cd = p_citizenship_cd;
1846: CURSOR c_scho_hpo IS
1847: SELECT scho.start_dt,
1848: scho.end_dt,

Line 1902: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,

1898: p_nz_citizen_not_res_ind
1899: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_not_res_ind%TYPE,
1900: p_govt_hecs_payment_option
1901: IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE,
1902: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,
1903: p_yr_arrival IGS_PE_STATISTICS.yr_arrival%TYPE)
1904: RETURN BOOLEAN
1905: AS
1906: BEGIN

Line 1973: -- IGS_ST_CITIZENSHP_CD.

1969: END enrpl_do_validations;
1970: BEGIN
1971: -- This is the main module which validates the student_course_hecs_
1972: -- option_v.IGS_FI_HECS_PAY_OPTN against the IGS_PE_STATISTICS.
1973: -- IGS_ST_CITIZENSHP_CD.
1974: p_message_name := null;
1975: -- validating the input parameters
1976: IF p_person_id IS NULL THEN
1977: RETURN TRUE;

Line 1996: -- IGS_ST_CITIZENSHP_CD, in which more than one may be found

1992: RETURN TRUE;
1993: END IF;
1994: CLOSE c_hpo;
1995: -- retrieving the govt. value for the IGS_PE_STATISTICS.
1996: -- IGS_ST_CITIZENSHP_CD, in which more than one may be found
1997: FOR v_ps_cic_rec IN c_ps_cic LOOP
1998: -- execute the rountine which checks whether
1999: -- further validation is required
2000: -- if it returns true, perform the validation

Line 2028: -- IGS_ST_CITIZENSHP_CD

2024: IF p_ps_start_dt IS NULL THEN
2025: RETURN TRUE;
2026: END IF;
2027: -- retrieving the govt. value for the IGS_PE_STATISTICS.
2028: -- IGS_ST_CITIZENSHP_CD
2029: IF p_citizenship_cd IS NOT NULL THEN
2030: OPEN c_gcc;
2031: FETCH c_gcc INTO v_govt_citizenship_cd;
2032: -- exit successfully if a record isn't found

Line 2117: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;

2113: RETURN BOOLEAN AS
2114: BEGIN
2115: DECLARE
2116: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
2117: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;
2118: v_govt_perm_resident_cd
2119: IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE DEFAULT NULL;
2120: v_rec_found BOOLEAN DEFAULT FALSE;
2121: v_no_validation_req BOOLEAN DEFAULT FALSE;

Line 2135: IGS_ST_CITIZENSHP_CD CIT,

2131: PS.end_dt,
2132: CIT.govt_citizenship_cd,
2133: PRCD.govt_perm_resident_cd
2134: FROM IGS_PE_STATISTICS PS,
2135: IGS_ST_CITIZENSHP_CD CIT,
2136: IGS_PE_PERM_RES_CD PRCD
2137: WHERE PS.person_id = p_person_id AND
2138: PS.citizenship_cd = CIT.citizenship_cd AND
2139: PS.perm_resident_cd = PRCD.perm_resident_cd (+)

Line 2144: FROM IGS_ST_CITIZENSHP_CD

2140: ORDER BY PS.start_dt,
2141: PS.end_dt;
2142: CURSOR c_gccd IS
2143: SELECT govt_citizenship_cd
2144: FROM IGS_ST_CITIZENSHP_CD
2145: WHERE citizenship_cd = p_citizenship_cd;
2146: CURSOR c_gprcd IS
2147: SELECT govt_perm_resident_cd
2148: FROM IGS_PE_PERM_RES_CD

Line 2195: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,

2191: END;
2192: END enrpl_chk_whether_to_validate;
2193: FUNCTION enrpl_do_validations (
2194: p_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE,
2195: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,
2196: p_govt_perm_resident_cd IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE,
2197: p_message_name OUT NOCOPY VARCHAR2,
2198: p_return_type OUT NOCOPY VARCHAR)
2199: RETURN BOOLEAN AS

Line 2207: -- the govt. value for the IGS_ST_CITIZENSHP_CD must be

2203: BEGIN
2204: -- this module performs the validation that is
2205: -- required, in that if the govt. value for
2206: -- the IGS_FI_HECS_PAY_OPTN = 10 or 11, then
2207: -- the govt. value for the IGS_ST_CITIZENSHP_CD must be
2208: -- 1 OR the govt. value for the IGS_PE_PERM_RES_CD must
2209: -- be 1
2210: -- OR
2211: -- if the govt value for the IGS_FI_HECS_PAY_OPTN is 10,

Line 2213: -- the IGS_ST_CITIZENSHP_CD must be 1, 2, or 3, and if it is

2209: -- be 1
2210: -- OR
2211: -- if the govt value for the IGS_FI_HECS_PAY_OPTN is 10,
2212: -- 11, 19, 20, 25, 26, 27, 32, or 40, then the govt. value for
2213: -- the IGS_ST_CITIZENSHP_CD must be 1, 2, or 3, and if it is
2214: -- 3, then the govt. value for the IGS_PE_PERM_RES_CD must
2215: -- be 1 or 3
2216: -- checking whether the IGS_FI_GOV_HEC_PA_OP = 10 or 11
2217: -- DETYA validation 1772. Allow for values being NULL

Line 2253: -- IGS_ST_CITIZENSHP_CD and the IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD.

2249: END enrpl_do_validations;
2250: BEGIN
2251: -- This is the main module which validates the student_course_hecs_
2252: -- option_v.IGS_FI_HECS_PAY_OPTN against the IGS_PE_STATISTICS.
2253: -- IGS_ST_CITIZENSHP_CD and the IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD.
2254: p_message_name := null;
2255: p_return_type := NULL;
2256: -- validating the input parameters
2257: IF p_person_id IS NULL THEN

Line 2277: -- IGS_ST_CITIZENSHP_CD and the IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD,

2273: RETURN TRUE;
2274: END IF;
2275: CLOSE c_ghpo;
2276: -- retrieving the govt. value for the IGS_PE_STATISTICS.
2277: -- IGS_ST_CITIZENSHP_CD and the IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD,
2278: -- in which more than one may be found
2279: FOR v_citz IN c_gcitiz_rec LOOP
2280: -- set that a record was found
2281: v_rec_found := TRUE;

Line 2310: -- IGS_ST_CITIZENSHP_CD

2306: IF p_ps_start_dt IS NULL THEN
2307: RETURN TRUE;
2308: END IF;
2309: -- retrieving the govt. value for the IGS_PE_STATISTICS.
2310: -- IGS_ST_CITIZENSHP_CD
2311: OPEN c_gccd;
2312: FETCH c_gccd INTO v_govt_citizenship_cd;
2313: -- exit successfully if a record isn't found
2314: -- therefore, no validation is required

Line 2405: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;

2401: -- the IGS_PS_VER.IGS_PS_TYPE and the IGS_PE_STATISTICS.citizenship_cd
2402: DECLARE
2403: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
2404: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
2405: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;
2406: v_validation_failed BOOLEAN DEFAULT FALSE;
2407: CURSOR c_hpo IS
2408: SELECT hpo.govt_hecs_payment_option
2409: FROM IGS_FI_HECS_PAY_OPTN hpo

Line 2426: IGS_ST_CITIZENSHP_CD cc

2422: SELECT ps.start_dt,
2423: ps.end_dt,
2424: cc.govt_citizenship_cd
2425: FROM IGS_PE_STATISTICS ps,
2426: IGS_ST_CITIZENSHP_CD cc
2427: WHERE ps.person_id = p_person_id AND
2428: ps.citizenship_cd = cc.citizenship_cd
2429: ORDER BY
2430: start_dt,

Line 2451: FROM IGS_ST_CITIZENSHP_CD cic

2447: cv.version_number = sca.version_number AND
2448: cv.course_type = ct.course_type;
2449: CURSOR c_cic IS
2450: SELECT cic.govt_citizenship_cd
2451: FROM IGS_ST_CITIZENSHP_CD cic
2452: WHERE cic.citizenship_cd = p_citizenship_cd;
2453: FUNCTION enrpl_get_govt_values
2454: RETURN BOOLEAN
2455: AS

Line 2505: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,

2501: END enrpl_chk_dates_overlap;
2502: FUNCTION enrpl_perform_validation (
2503: p_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE,
2504: p_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE,
2505: p_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,
2506: p_message_name OUT NOCOPY VARCHAR2,
2507: p_return_type OUT NOCOPY VARCHAR2)
2508: RETURN BOOLEAN
2509: AS

Line 2641: -- Get the govt value for the IGS_ST_CITIZENSHP_CD

2637: -- get govt values for student hecs paymnt option, IGS_PS_TYPE
2638: IF NOT enrpl_get_govt_values THEN
2639: RETURN TRUE;
2640: END IF;
2641: -- Get the govt value for the IGS_ST_CITIZENSHP_CD
2642: FOR v_rec IN c_ps LOOP
2643: -- For each record that is retrieved, only validate if the
2644: -- database effective date(s) overlap or match the parameter date(s)
2645: IF enrpl_chk_dates_overlap (

Line 2725: pl_govt_citizenship_cd IN IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,

2721: -- local function
2722: FUNCTION enrpl_val_hpo_cit_cd (
2723: pl_govt_hecs_payment_option IN
2724: IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option%TYPE,
2725: pl_govt_citizenship_cd IN IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,
2726: p1_v_inst_3037 IN BOOLEAN,
2727: pl_message_name OUT NOCOPY VARCHAR2,
2728: pl_return_type OUT NOCOPY VARCHAR2 )
2729: RETURN

Line 2813: IGS_PE_GOVCITIZEN_CD IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE );

2809: DECLARE
2810: TYPE t_govt_cit_cd_details IS RECORD (
2811: start_dt IGS_PE_STATISTICS.start_dt%TYPE,
2812: end_dt IGS_PE_STATISTICS.end_dt%TYPE,
2813: IGS_PE_GOVCITIZEN_CD IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE );
2814: TYPE t_hpo_details IS RECORD (
2815: start_dt IGS_PE_STATISTICS.start_dt%TYPE,
2816: end_dt IGS_PE_STATISTICS.end_dt%TYPE,
2817: govt_hpo IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE );

Line 2819: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;

2815: start_dt IGS_PE_STATISTICS.start_dt%TYPE,
2816: end_dt IGS_PE_STATISTICS.end_dt%TYPE,
2817: govt_hpo IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE );
2818: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
2819: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;
2820: v_cit_cd_details_rec t_govt_cit_cd_details;
2821: v_hpo_details_rec t_hpo_details;
2822: v_institution_3037 BOOLEAN DEFAULT FALSE;
2823: v_exit BOOLEAN DEFAULT FALSE;

Line 2841: IGS_ST_CITIZENSHP_CD cic

2837: SELECT ps.start_dt,
2838: ps.end_dt,
2839: cic.govt_citizenship_cd
2840: FROM IGS_PE_STATISTICS ps,
2841: IGS_ST_CITIZENSHP_CD cic
2842: WHERE ps.person_id = p_person_id AND
2843: cic.citizenship_cd = ps.citizenship_cd
2844: ORDER BY
2845: ps.start_dt,

Line 2861: FROM IGS_ST_CITIZENSHP_CD

2857: schov.start_dt,
2858: schov.end_dt;
2859: CURSOR c_gov_details IS
2860: SELECT govt_citizenship_cd
2861: FROM IGS_ST_CITIZENSHP_CD
2862: WHERE citizenship_cd = p_citizenship_cd;
2863: BEGIN
2864: -- This module may be called when validating a IGS_EN_STDNT_PS_HECS_OPTION_V
2865: -- record or a IGS_PE_STATISTICS record. person Id will be the only

Line 3056: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;

3052: -- The IGS_EN_STDNT_PS_ATT.commencement_dt is also used in validations.
3053: DECLARE
3054: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
3055: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
3056: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;
3057: v_validation_failed BOOLEAN DEFAULT FALSE;
3058: CURSOR c_hpo IS
3059: SELECT hpo.govt_hecs_payment_option
3060: FROM IGS_FI_HECS_PAY_OPTN hpo

Line 3075: IGS_ST_CITIZENSHP_CD cc

3071: ps.term_location_country,
3072: ps.term_location_postcode,
3073: cc.govt_citizenship_cd
3074: FROM IGS_PE_STATISTICS ps,
3075: IGS_ST_CITIZENSHP_CD cc
3076: WHERE ps.person_id = p_person_id AND
3077: ps.citizenship_cd = cc.citizenship_cd
3078: ORDER BY
3079: ps.start_dt,

Line 3083: FROM IGS_ST_CITIZENSHP_CD cic

3079: ps.start_dt,
3080: ps.end_dt;
3081: CURSOR c_cic IS
3082: SELECT cic.govt_citizenship_cd
3083: FROM IGS_ST_CITIZENSHP_CD cic
3084: WHERE cic.citizenship_cd = p_citizenship_cd;
3085: CURSOR c_scho IS
3086: SELECT scho.start_dt,
3087: scho.end_dt,

Line 3132: lp_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,

3128: FUNCTION enrpl_perform_validation (
3129: lp_govt_hecs_payment_option
3130: IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option%TYPE,
3131: lp_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE,
3132: lp_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE,
3133: lp_yr_arrival IGS_PE_STATISTICS.yr_arrival%TYPE,
3134: lp_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE,
3135: lp_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE)
3136: RETURN BOOLEAN