[Home] [Help]
1068: SELECT PS.start_dt,
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
1168: END;
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
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;
1193: END IF;
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
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.
1223: -- checking the input parameters
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
1234: CLOSE c_gccd;
1235: RETURN TRUE;
1236: END IF;
1237: CLOSE c_gccd;
1238: -- retrieving the govt. value for the IGS_PE_STATISTICS.
1239: -- IGS_PE_PERM_RES_CD
1240: OPEN c_gprcd;
1241: FETCH c_gprcd INTO v_govt_perm_resident_cd;
1242: CLOSE c_gprcd;
1314: SELECT ps.start_dt,
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
1415: END;
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
1427: IF p_course_cd IS NOT NULL THEN
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
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
1437: -- further validation is required.
1461: ELSE -- p_course_cd IS NULL
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
1472: CLOSE c_cic;
1473: RETURN TRUE;
1474: END IF;
1475: CLOSE c_cic;
1476: -- retrieving the govt. value for the IGS_PE_STATISTICS.
1477: -- IGS_PE_PERM_RES_CD
1478: OPEN c_prc;
1479: FETCH c_prc INTO v_govt_perm_resident_cd;
1480: CLOSE c_prc;
1832: SELECT ps.start_dt,
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,
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
1907: DECLARE
1968: App_Exception.Raise_Exception;
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
1991: CLOSE c_hpo;
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
2023: -- checking the input parameters
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;
2130: SELECT PS.start_dt,
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
2248: END;
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
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
2272: CLOSE c_ghpo;
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
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;
2305: -- checking the input parameters
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
2316: CLOSE c_gccd;
2317: RETURN TRUE;
2318: END IF;
2319: CLOSE c_gccd;
2320: -- retrieving the govt. value for the IGS_PE_STATISTICS.
2321: -- IGS_PE_PERM_RES_CD
2322: OPEN c_gprcd;
2323: FETCH c_gprcd INTO v_govt_perm_resident_cd;
2324: CLOSE c_gprcd;
2397: p_return_type OUT NOCOPY VARCHAR2 )
2398: RETURN BOOLEAN AS
2399: BEGIN
2400: -- validate the IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN against
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;
2421: CURSOR c_ps IS
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
2807: END enrpl_val_hpo_cit_cd;
2808: BEGIN
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,
2808: BEGIN
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,
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 );
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;
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 );
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;
2836: CURSOR c_ps IS
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
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
2866: -- input parameter that will be set when called from either place. The
2867: -- other input parameters will be set depending on where the module is
2868: -- called from. If course code is set, we can assume the module have been
2869: -- called when validating a IGS_EN_STDNT_PS_HECS_OPTION_V record, otherwise
2867: -- other input parameters will be set depending on where the module is
2868: -- called from. If course code is set, we can assume the module have been
2869: -- called when validating a IGS_EN_STDNT_PS_HECS_OPTION_V record, otherwise
2870: -- if it is not set, we can assume the module has been called when validating
2871: -- a IGS_PE_STATISTICS record. Because both records are effective dated,
2872: -- validation from both places will need to include looping logic to match
2873: -- on all records that overlap with the one being validated. When validating
2874: -- a IGS_PE_STATISTICS record, logic is required to loop through all of the
2875: -- IGS_EN_STDNT_PS_HECS_OPTION_V records that may exist for the person.
2870: -- if it is not set, we can assume the module has been called when validating
2871: -- a IGS_PE_STATISTICS record. Because both records are effective dated,
2872: -- validation from both places will need to include looping logic to match
2873: -- on all records that overlap with the one being validated. When validating
2874: -- a IGS_PE_STATISTICS record, logic is required to loop through all of the
2875: -- IGS_EN_STDNT_PS_HECS_OPTION_V records that may exist for the person.
2876: -- Looping is required for the different course codes that may exist.
2877: -- Therefor, this module validates the IGS_EN_STDNT_PS_HECS_OPTION_V.
2878: -- IGS_FI_HECS_PAY_OPTN against the IGS_PE_STATISTICS.citizenship_cd.
2874: -- a IGS_PE_STATISTICS record, logic is required to loop through all of the
2875: -- IGS_EN_STDNT_PS_HECS_OPTION_V records that may exist for the person.
2876: -- Looping is required for the different course codes that may exist.
2877: -- Therefor, this module validates the IGS_EN_STDNT_PS_HECS_OPTION_V.
2878: -- IGS_FI_HECS_PAY_OPTN against the IGS_PE_STATISTICS.citizenship_cd.
2879: -- Validations are :
2880: -- 1. If the government value for the IGS_PE_STATISTICS.citizenship_cd is
2881: -- 1, 2 or 3, then the government value for the
2882: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option must be
2876: -- Looping is required for the different course codes that may exist.
2877: -- Therefor, this module validates the IGS_EN_STDNT_PS_HECS_OPTION_V.
2878: -- IGS_FI_HECS_PAY_OPTN against the IGS_PE_STATISTICS.citizenship_cd.
2879: -- Validations are :
2880: -- 1. If the government value for the IGS_PE_STATISTICS.citizenship_cd is
2881: -- 1, 2 or 3, then the government value for the
2882: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option must be
2883: -- 10, 11, 12, 19, 20, 25, 26, 27, 31, 32, 33, 40, 70 or 99
2884: -- (DEETYA validation1666).
2881: -- 1, 2 or 3, then the government value for the
2882: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option must be
2883: -- 10, 11, 12, 19, 20, 25, 26, 27, 31, 32, 33, 40, 70 or 99
2884: -- (DEETYA validation1666).
2885: -- 2. If the government value for the IGS_PE_STATISTICS.citizenship_cd is 4 or
2886: --5, then the government value for the
2887: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option must be 22, 23,
2888: -- 24, 26, 27, 30, 70 or 99 (DEETYA validation 1574).
2889: -- 3. If the local INSTITUTION is not 3037 (Open Learning Agency of Australia)
2886: --5, then the government value for the
2887: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option must be 22, 23,
2888: -- 24, 26, 27, 30, 70 or 99 (DEETYA validation 1574).
2889: -- 3. If the local INSTITUTION is not 3037 (Open Learning Agency of Australia)
2890: -- and the government value for the IGS_PE_STATISTICS.citizenship_cd is 1,
2891: -- then the government value for the IGS_EN_STDNT_PS_HECS_OPTION_V.
2892: -- IGS_FI_HECS_PAY_OPTN must be 10, 11, 19, 20, 25, 26, 27, 31, 32, 33, 40,
2893: -- 70
2894: -- or 99 (DEETYA validation 1675).
2906: END IF;
2907: END LOOP;
2908: --- If the course code is set, then we assume this module has been called to
2909: --- validate a IGS_EN_STDNT_PS_HECS_OPTION_V record. Otherwise we assume we are
2910: --- validating a IGS_PE_STATISTICS record.
2911: IF p_course_cd IS NOT NULL THEN
2912: IF p_scho_start_dt IS NULL THEN
2913: RETURN TRUE;
2914: END IF;
2920: CLOSE c_govt_hpo;
2921: RETURN TRUE;
2922: END IF;
2923: CLOSE c_govt_hpo;
2924: --- Retrieve the government value for the IGS_PE_STATISTICS.citizenship_cd.
2925: --- Many records may be retrieved.
2926: --- For each record that is retrieved determine if it should be validated.
2927: --- Validation is required if the database effective date(s) overlap or match
2928: --- the parameter date(s). Looping logic is required here.
2944: ELSE -- p_course_cd IS NULL
2945: IF p_ps_start_dt IS NULL THEN
2946: RETURN TRUE;
2947: END IF;
2948: --- Retrieve the government value for the IGS_PE_STATISTICS.citizenship_cd
2949: OPEN c_gov_details;
2950: FETCH c_gov_details INTO v_govt_citizenship_cd;
2951: IF c_gov_details%NOTFOUND THEN
2952: CLOSE c_gov_details;
3045: p_return_type OUT NOCOPY VARCHAR2 )
3046: RETURN BOOLEAN AS
3047: BEGIN -- ernp_val_hpo_cic_ps
3048: -- validate the IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option
3049: -- against the IGS_PE_STATISTICS.citizenship_cd and other IGS_PE_STATISTICS
3050: -- values, including IGS_PE_STATISTICS.yr_arrival and
3051: -- IGS_PE_STATISTICS.term_location_[country|postcode]
3052: -- The IGS_EN_STDNT_PS_ATT.commencement_dt is also used in validations.
3053: DECLARE
3046: RETURN BOOLEAN AS
3047: BEGIN -- ernp_val_hpo_cic_ps
3048: -- validate the IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option
3049: -- against the IGS_PE_STATISTICS.citizenship_cd and other IGS_PE_STATISTICS
3050: -- values, including IGS_PE_STATISTICS.yr_arrival and
3051: -- IGS_PE_STATISTICS.term_location_[country|postcode]
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;
3047: BEGIN -- ernp_val_hpo_cic_ps
3048: -- validate the IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option
3049: -- against the IGS_PE_STATISTICS.citizenship_cd and other IGS_PE_STATISTICS
3050: -- values, including IGS_PE_STATISTICS.yr_arrival and
3051: -- IGS_PE_STATISTICS.term_location_[country|postcode]
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;
3070: ps.yr_arrival,
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
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
3137: AS
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
3137: AS
3138: lv_other_detail VARCHAR2(255);
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
3137: AS
3138: lv_other_detail VARCHAR2(255);
3139: BEGIN