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_EN_STDNT_PS_HECS_OPTION_V

Line 942: -- IGS_EN_STDNT_PS_HECS_OPTION_V record, in which

938: WHERE person_id = p_person_id AND
939: course_cd = p_course_cd;
940: BEGIN
941: -- This module validates the insertion of a
942: -- IGS_EN_STDNT_PS_HECS_OPTION_V record, in which
943: -- it can't be inserted if it has a status of
944: -- completed or deleted.
945: p_message_name := null;
946: OPEN c_attempt_status;

Line 983: -- This module validates whether a IGS_EN_STDNT_PS_HECS_OPTION_V

979: DECLARE
980:
981: v_diff NUMBER;
982: BEGIN
983: -- This module validates whether a IGS_EN_STDNT_PS_HECS_OPTION_V
984: -- record may be updated. It may only be updated if
985: -- the IGS_EN_STDNTPSHECSOP.start_dt is equal or greater
986: -- than the current date.
987: v_diff := MONTHS_BETWEEN(SYSDATE, p_start_dt);

Line 1016: -- This module validates whether a IGS_EN_STDNT_PS_HECS_OPTION_V

1012: DECLARE
1013:
1014: v_diff NUMBER;
1015: BEGIN
1016: -- This module validates whether a IGS_EN_STDNT_PS_HECS_OPTION_V
1017: -- record may be deleted. It may only be deleted if
1018: -- the IGS_EN_STDNTPSHECSOP.start_dt is equal or greater
1019: -- than the current date.
1020: v_diff := MONTHS_BETWEEN(SYSDATE, p_start_dt);

Line 1060: v_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE;

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
1064: FROM IGS_FI_HECS_PAY_OPTN

Line 1093: FROM IGS_EN_STDNT_PS_HECS_OPTION_V SCHOV,

1089: SELECT SCHOV.start_dt,
1090: SCHOV.end_dt,
1091: SCHOV.outside_aus_res_ind,
1092: HPO.govt_hecs_payment_option
1093: FROM IGS_EN_STDNT_PS_HECS_OPTION_V SCHOV,
1094: IGS_FI_HECS_PAY_OPTN HPO
1095: WHERE SCHOV.person_id = p_person_id AND
1096: SCHOV.hecs_payment_option =
1097: HPO.hecs_payment_option AND

Line 1133: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,

1129: App_Exception.Raise_Exception;
1130: END;
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

Line 1245: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN

1241: FETCH c_gprcd INTO v_govt_perm_resident_cd;
1242: CLOSE c_gprcd;
1243: -- retrieving the visa indicators for the student_course_
1244: -- hecs_option_v and the govt. value for the
1245: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN
1246: -- in which more than one record may be found
1247: FOR v_scho_record IN c_hpo LOOP
1248: -- execute the rountine which checks whether
1249: -- furhter validation is required.

Line 1337: FROM IGS_EN_STDNT_PS_HECS_OPTION_V schov

1333: schov.outside_aus_res_ind,
1334: schov.nz_citizen_ind,
1335: schov.nz_citizen_less2yr_ind,
1336: schov.nz_citizen_not_res_ind
1337: FROM IGS_EN_STDNT_PS_HECS_OPTION_V schov
1338: WHERE schov.person_id = p_person_id
1339: ORDER BY
1340: schov.start_dt,
1341: schov.end_dt;

Line 1372: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,

1368: App_Exception.Raise_Exception;
1369: END;
1370: END enrpl_chk_whether_to_validate;
1371: FUNCTION enrpl_do_validations (
1372: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,
1373: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%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

Line 1373: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%TYPE,

1369: END;
1370: END enrpl_chk_whether_to_validate;
1371: FUNCTION enrpl_do_validations (
1372: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,
1373: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%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,

Line 1375: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_less2yr_ind%TYPE,

1371: FUNCTION enrpl_do_validations (
1372: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,
1373: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%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)

Line 1377: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_not_res_ind%TYPE,

1373: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%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

Line 1483: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN

1479: FETCH c_prc INTO v_govt_perm_resident_cd;
1480: CLOSE c_prc;
1481: -- retrieving the visa indicators for the student_course_
1482: -- hecs_option_v and the govt. value for the
1483: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN
1484: -- in which more than one record may be found
1485: FOR v_schov_rec IN c_schov LOOP
1486: -- execute the rountine which checks whether
1487: -- further validation is required.

Line 1572: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN is 26,

1568: -- option_v.IGS_FI_HECS_PAY_OPTN against the IGS_PS_VER.
1569: -- IGS_PS_TYPE.
1570: -- Validations are :
1571: -- 2.If the government vaue for the
1572: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN is 26,
1573: -- then the government value for the IGS_PS_VER.IGS_PS_TYPE for the
1574: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd must be 50 (DEETYA validation 1294).
1575: -- 3.If the government value for the IGS_PS_VER.IGS_PS_TYPE for the
1576: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd is 50, then the government value for

Line 1574: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd must be 50 (DEETYA validation 1294).

1570: -- Validations are :
1571: -- 2.If the government vaue for the
1572: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN is 26,
1573: -- then the government value for the IGS_PS_VER.IGS_PS_TYPE for the
1574: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd must be 50 (DEETYA validation 1294).
1575: -- 3.If the government value for the IGS_PS_VER.IGS_PS_TYPE for the
1576: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd is 50, then the government value for
1577: -- the IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN then must be 22,
1578: -- 23, 24, 26, 27, 30, 33, 70or 99 (DEETYA validation 1655).

Line 1576: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd is 50, then the government value for

1572: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN is 26,
1573: -- then the government value for the IGS_PS_VER.IGS_PS_TYPE for the
1574: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd must be 50 (DEETYA validation 1294).
1575: -- 3.If the government value for the IGS_PS_VER.IGS_PS_TYPE for the
1576: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd is 50, then the government value for
1577: -- the IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN then must be 22,
1578: -- 23, 24, 26, 27, 30, 33, 70or 99 (DEETYA validation 1655).
1579: -- set the default message number
1580: p_message_name := null;

Line 1577: -- the IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN then must be 22,

1573: -- then the government value for the IGS_PS_VER.IGS_PS_TYPE for the
1574: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd must be 50 (DEETYA validation 1294).
1575: -- 3.If the government value for the IGS_PS_VER.IGS_PS_TYPE for the
1576: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd is 50, then the government value for
1577: -- the IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN then must be 22,
1578: -- 23, 24, 26, 27, 30, 33, 70or 99 (DEETYA validation 1655).
1579: -- set the default message number
1580: p_message_name := null;
1581: -- retrieving the govt. value for the student_course_

Line 1737: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option

1733: -- option_v.hecs_payment_option against the IGS_PS_VER.
1734: -- IGS_PS_GOVT_SPL_TYPE.
1735: -- Validations are :
1736: -- 1. If the government value for the
1737: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option
1738: -- is 70, then the IGS_PS_VER.govt_special_course_type for the
1739: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd must be 15, and vice-versa, and the
1740: -- IGS_OR_INSTITUTION code must be 2239 (Australian Maritime College)
1741: -- (DEETYA validation 1670, 1671).

Line 1739: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd must be 15, and vice-versa, and the

1735: -- Validations are :
1736: -- 1. If the government value for the
1737: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option
1738: -- is 70, then the IGS_PS_VER.govt_special_course_type for the
1739: -- IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd must be 15, and vice-versa, and the
1740: -- IGS_OR_INSTITUTION code must be 2239 (Australian Maritime College)
1741: -- (DEETYA validation 1670, 1671).
1742: -- set the default message number
1743: p_message_name := null;

Line 1776: -- type for the IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd

1772: CLOSE c_ins;
1773: -- checking that if the student_course_hecs
1774: -- option_v.hecs_payment_option is set to 70,
1775: -- then the course_version_govt_special_course
1776: -- type for the IGS_EN_STDNT_PS_HECS_OPTION_V.course_cd
1777: -- must be 15, and vice-versa.
1778: IF (v_govt_hecs_payment_option IN (
1779: cst_hecs_non_os_spec_crs,
1780: cst_hecs_os_spec_crs) AND

Line 1854: FROM IGS_EN_STDNT_PS_HECS_OPTION_V scho,

1850: scho.nz_citizen_ind,
1851: scho.nz_citizen_less2yr_ind,
1852: scho.nz_citizen_not_res_ind,
1853: hpo.govt_hecs_payment_option
1854: FROM IGS_EN_STDNT_PS_HECS_OPTION_V scho,
1855: IGS_FI_HECS_PAY_OPTN hpo
1856: WHERE scho.person_id = p_person_id AND
1857: scho.hecs_payment_option = hpo.hecs_payment_option AND
1858: hpo.govt_hecs_payment_option IS NOT NULL

Line 1894: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,

1890: IGS_GE_MSG_STACK.ADD;
1891: App_Exception.Raise_Exception;
1892: END enrpl_chk_whether_to_validate;
1893: FUNCTION enrpl_do_validations (
1894: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,
1895: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%TYPE,
1896: p_nz_citizen_less2yr_ind
1897: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_less2yr_ind%TYPE,
1898: p_nz_citizen_not_res_ind

Line 1895: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%TYPE,

1891: App_Exception.Raise_Exception;
1892: END enrpl_chk_whether_to_validate;
1893: FUNCTION enrpl_do_validations (
1894: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,
1895: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%TYPE,
1896: p_nz_citizen_less2yr_ind
1897: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_less2yr_ind%TYPE,
1898: p_nz_citizen_not_res_ind
1899: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_not_res_ind%TYPE,

Line 1897: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_less2yr_ind%TYPE,

1893: FUNCTION enrpl_do_validations (
1894: p_outside_aus_res_ind IGS_EN_STDNT_PS_HECS_OPTION_V.outside_aus_res_ind%TYPE,
1895: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%TYPE,
1896: p_nz_citizen_less2yr_ind
1897: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_less2yr_ind%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,

Line 1899: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_not_res_ind%TYPE,

1895: p_nz_citizen_ind IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_ind%TYPE,
1896: p_nz_citizen_less2yr_ind
1897: IGS_EN_STDNT_PS_HECS_OPTION_V.nz_citizen_less2yr_ind%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)

Line 2044: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN

2040: v_govt_citizenship_cd := NULL;
2041: END IF;
2042: -- retrieving the visa indicators for the student_course_
2043: -- hecs_option_v and the govt. value for the
2044: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN
2045: -- in which more than one record may be found
2046: FOR v_scho_rec IN c_scho_hpo LOOP
2047: -- execute the rountine which checks whether
2048: -- furhter validation is required

Line 2154: FROM IGS_EN_STDNT_PS_HECS_OPTION_V SCHOV,

2150: CURSOR c_hpo_rec IS
2151: SELECT SCHOV.start_dt,
2152: SCHOV.end_dt,
2153: HPO.govt_hecs_payment_option
2154: FROM IGS_EN_STDNT_PS_HECS_OPTION_V SCHOV,
2155: IGS_FI_HECS_PAY_OPTN HPO
2156: WHERE SCHOV.person_id = p_person_id AND
2157: SCHOV.hecs_payment_option = HPO.hecs_payment_option AND
2158: HPO.govt_hecs_payment_option IS NOT NULL

Line 2326: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN

2322: OPEN c_gprcd;
2323: FETCH c_gprcd INTO v_govt_perm_resident_cd;
2324: CLOSE c_gprcd;
2325: -- retrieving govt. value for the
2326: -- IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN
2327: -- in which more than one record may be found
2328: FOR v_scho IN c_hpo_rec LOOP
2329: -- set that a record was found
2330: v_scho_rec_found := TRUE;

Line 2400: -- validate the IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN against

2396: p_message_name OUT NOCOPY VARCHAR2,
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;

Line 2437: FROM IGS_EN_STDNT_PS_HECS_OPTION_V scho,

2433: SELECT scho.start_dt,
2434: scho.end_dt,
2435: hpo.govt_hecs_payment_option,
2436: ct.govt_course_type
2437: FROM IGS_EN_STDNT_PS_HECS_OPTION_V scho,
2438: IGS_FI_HECS_PAY_OPTN hpo,
2439: IGS_EN_STDNT_PS_ATT sca,
2440: IGS_PS_VER cv,
2441: IGS_PS_TYPE ct

Line 2633: -- a IGS_EN_STDNT_PS_HECS_OPTION_V record

2629: RETURN TRUE;
2630: END IF;
2631: IF p_course_cd IS NOT NULL THEN
2632: -- This module has been called when validating
2633: -- a IGS_EN_STDNT_PS_HECS_OPTION_V record
2634: IF p_scho_start_dt IS NULL THEN
2635: RETURN TRUE;
2636: END IF;
2637: -- get govt values for student hecs paymnt option, IGS_PS_TYPE

Line 2724: IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option%TYPE,

2720: RETURN BOOLEAN AS
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 )

Line 2851: FROM IGS_EN_STDNT_PS_HECS_OPTION_V schov,

2847: CURSOR c_schov IS
2848: SELECT schov.start_dt,
2849: schov.end_dt,
2850: hpo.govt_hecs_payment_option
2851: FROM IGS_EN_STDNT_PS_HECS_OPTION_V schov,
2852: IGS_FI_HECS_PAY_OPTN hpo
2853: WHERE schov.person_id = p_person_id AND
2854: schov.hecs_payment_option = hpo.hecs_payment_option AND
2855: hpo.govt_hecs_payment_option IS NOT NULL

Line 2864: -- This module may be called when validating a IGS_EN_STDNT_PS_HECS_OPTION_V

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
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

Line 2869: -- called when validating a IGS_EN_STDNT_PS_HECS_OPTION_V record, otherwise

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
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

Line 2875: -- IGS_EN_STDNT_PS_HECS_OPTION_V records that may exist for the person.

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.
2879: -- Validations are :

Line 2877: -- Therefor, this module validates the IGS_EN_STDNT_PS_HECS_OPTION_V.

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.
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

Line 2882: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option must be

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).
2885: -- 2. If the government value for the IGS_PE_STATISTICS.citizenship_cd is 4 or
2886: --5, then the government value for the

Line 2887: -- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option must be 22, 23,

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)
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.

Line 2891: -- then the government value for the IGS_EN_STDNT_PS_HECS_OPTION_V.

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).
2895: --- Set the default message number

Line 2909: --- validate a IGS_EN_STDNT_PS_HECS_OPTION_V record. Otherwise we assume we are

2905: EXIT;
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;

Line 2916: --- the IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option.

2912: IF p_scho_start_dt IS NULL THEN
2913: RETURN TRUE;
2914: END IF;
2915: --- Retrieve the government value for
2916: --- the IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option.
2917: OPEN c_govt_hpo;
2918: FETCH c_govt_hpo INTO v_govt_hecs_payment_option;
2919: IF c_govt_hpo%NOTFOUND THEN
2920: CLOSE c_govt_hpo;

Line 2957: --- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option.

2953: RETURN TRUE;
2954: END IF;
2955: CLOSE c_gov_details;
2956: --- Retrieve the government value for the
2957: --- IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option.
2958: --- Many records may be retrieved.
2959: --- For each record that is retrieved determine IF it should be validated.
2960: --- Validation is required IF the database effective date(s) overlap or
2961: --- match the parameter date(s).

Line 3048: -- validate the IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option

3044: p_message_name OUT NOCOPY VARCHAR2,
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.

Line 3090: FROM IGS_EN_STDNT_PS_HECS_OPTION_V scho,

3086: SELECT scho.start_dt,
3087: scho.end_dt,
3088: hpo.govt_hecs_payment_option,
3089: sca.commencement_dt
3090: FROM IGS_EN_STDNT_PS_HECS_OPTION_V scho,
3091: IGS_FI_HECS_PAY_OPTN hpo,
3092: IGS_EN_STDNT_PS_ATT sca
3093: WHERE scho.person_id = p_person_id AND
3094: scho.hecs_payment_option = hpo.hecs_payment_option AND

Line 3130: IGS_EN_STDNT_PS_HECS_OPTION_V.hecs_payment_option%TYPE,

3126: END;
3127: END enrpl_chk_dates_overlap;
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,

Line 3319: -- a IGS_EN_STDNT_PS_HECS_OPTION_V record

3315: RETURN TRUE;
3316: END IF;
3317: IF p_course_cd IS NOT NULL THEN
3318: -- This module has been called when validating
3319: -- a IGS_EN_STDNT_PS_HECS_OPTION_V record
3320: IF p_scho_start_dt IS NULL THEN
3321: RETURN TRUE;
3322: END IF;
3323: OPEN c_hpo;