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_PE_PERM_RES_CD

Line 1059: IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE DEFAULT NULL;

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;
1062: CURSOR c_ghpo IS
1063: SELECT govt_hecs_payment_option

Line 1074: IGS_PE_PERM_RES_CD PRCD

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 (+)
1078: ORDER BY PS.start_dt,

Line 1086: FROM IGS_PE_PERM_RES_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
1087: WHERE perm_resident_cd = p_perm_resident_cd;
1088: CURSOR c_hpo IS
1089: SELECT SCHOV.start_dt,
1090: SCHOV.end_dt,

Line 1136: p_govt_perm_resident_cd IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE)

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
1140: v_other_detail VARCHAR2(255);

Line 1145: -- 3 and the govt. value for the IGS_PE_PERM_RES_CD must

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
1149: -- checking if the indicator is set

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 1239: -- IGS_PE_PERM_RES_CD

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;
1243: -- retrieving the visa indicators for the student_course_

Line 1306: v_govt_perm_resident_cd IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE

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;
1309: CURSOR c_prc IS
1310: SELECT prc.govt_perm_resident_cd

Line 1311: FROM IGS_PE_PERM_RES_CD prc

1307: DEFAULT NULL;
1308: v_return_false BOOLEAN DEFAULT FALSE;
1309: CURSOR c_prc IS
1310: SELECT prc.govt_perm_resident_cd
1311: FROM IGS_PE_PERM_RES_CD prc
1312: WHERE prc.perm_resident_cd = p_perm_resident_cd;
1313: CURSOR c_ps IS
1314: SELECT ps.start_dt,
1315: ps.end_dt,

Line 1320: IGS_PE_PERM_RES_CD prcd

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 (+)
1324: ORDER BY ps.start_dt,

Line 1379: p_govt_perm_resident_cd IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE)

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
1383: v_other_detail VARCHAR2(255);

Line 1387: -- IGS_PE_PERM_RES_CD is 1 or 3, then the visa indicators

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
1390: IF p_govt_citizenship_cd IN (
1391: cst_citizen_aust,

Line 1433: -- IGS_PE_STATISTICS.IGS_PE_PERM_RES_CD, in which more

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.

Line 1477: -- IGS_PE_PERM_RES_CD

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;
1481: -- retrieving the visa indicators for the student_course_

Line 2119: IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE DEFAULT NULL;

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;
2122: v_scho_rec_found BOOLEAN DEFAULT FALSE;
2123: v_false_val BOOLEAN DEFAULT FALSE;

Line 2136: IGS_PE_PERM_RES_CD PRCD

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 (+)
2140: ORDER BY PS.start_dt,

Line 2148: FROM IGS_PE_PERM_RES_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
2149: WHERE perm_resident_cd = p_perm_resident_cd;
2150: CURSOR c_hpo_rec IS
2151: SELECT SCHOV.start_dt,
2152: SCHOV.end_dt,

Line 2196: p_govt_perm_resident_cd IGS_PE_PERM_RES_CD.govt_perm_resident_cd%TYPE,

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
2200: BEGIN

Line 2208: -- 1 OR the govt. value for the IGS_PE_PERM_RES_CD must

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,
2212: -- 11, 19, 20, 25, 26, 27, 32, or 40, then the govt. value for

Line 2214: -- 3, then the govt. value for the IGS_PE_PERM_RES_CD must

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
2218: IF p_govt_perm_resident_cd IN (

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 2321: -- IGS_PE_PERM_RES_CD

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;
2325: -- retrieving govt. value for the