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_PS_VER

Line 1559: IGS_PS_VER crv,

1555: WHERE hpo.hecs_payment_option = p_hecs_payment_option;
1556: CURSOR c_gct IS
1557: SELECT cty.govt_course_type
1558: FROM IGS_EN_STDNT_PS_ATT sca,
1559: IGS_PS_VER crv,
1560: IGS_PS_TYPE cty
1561: WHERE sca.person_id = p_person_id AND
1562: sca.course_cd = p_course_cd AND
1563: crv.course_cd = sca.course_cd AND

Line 1568: -- option_v.IGS_FI_HECS_PAY_OPTN against the IGS_PS_VER.

1564: crv.version_number = sca.version_number AND
1565: crv.course_type = cty.course_type;
1566: BEGIN
1567: -- This module validates the student_course_hecs_
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,

Line 1573: -- then the government value for the IGS_PS_VER.IGS_PS_TYPE for the

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
1577: -- the IGS_EN_STDNT_PS_HECS_OPTION_V.IGS_FI_HECS_PAY_OPTN then must be 22,

Line 1575: -- 3.If the government value for the IGS_PS_VER.IGS_PS_TYPE for the

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).
1579: -- set the default message number

Line 1592: -- retrieving the govt. value for the IGS_PS_VER.

1588: CLOSE c_ghpo;
1589: RETURN TRUE;
1590: END IF;
1591: CLOSE c_ghpo;
1592: -- retrieving the govt. value for the IGS_PS_VER.
1593: -- IGS_PS_GOVT_SPL_TYPE
1594: OPEN c_gct;
1595: FETCH c_gct INTO v_govt_course_type;
1596: -- exit successfully if a record isn't found

Line 1708: v_govt_special_course_type IGS_PS_VER.govt_special_course_type%TYPE;

1704: RETURN BOOLEAN AS
1705: BEGIN
1706: DECLARE
1707: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
1708: v_govt_special_course_type IGS_PS_VER.govt_special_course_type%TYPE;
1709: v_institution_2239 BOOLEAN DEFAULT FALSE;
1710: v_dummy VARCHAR2(1);
1711: CURSOR c_hpo IS
1712: SELECT hpo.govt_hecs_payment_option

Line 1718: IGS_PS_VER crv

1714: WHERE hpo.hecs_payment_option = p_hecs_payment_option;
1715: CURSOR c_crv IS
1716: SELECT crv.govt_special_course_type
1717: FROM IGS_EN_STDNT_PS_ATT sca,
1718: IGS_PS_VER crv
1719: WHERE sca.person_id = p_person_id AND
1720: sca.course_cd = p_course_cd AND
1721: crv.course_cd = sca.course_cd AND
1722: crv.version_number = sca.version_number;

Line 1733: -- option_v.hecs_payment_option against the IGS_PS_VER.

1729: ist.institution_status = ins.institution_status AND
1730: ist.s_institution_status = 'ACTIVE';
1731: BEGIN
1732: -- This module validates the student_course_hecs_
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

Line 1738: -- is 70, then the IGS_PS_VER.govt_special_course_type for the

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).
1742: -- set the default message number

Line 1755: -- retrieving the govt. value for the IGS_PS_VER.

1751: CLOSE c_hpo;
1752: RETURN TRUE;
1753: END IF;
1754: CLOSE c_hpo;
1755: -- retrieving the govt. value for the IGS_PS_VER.
1756: -- IGS_PS_GOVT_SPL_TYPE
1757: OPEN c_crv;
1758: FETCH c_crv INTO v_govt_special_course_type;
1759: -- exit successfully if a record isn't found

Line 2401: -- the IGS_PS_VER.IGS_PS_TYPE and the IGS_PE_STATISTICS.citizenship_cd

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;

Line 2414: IGS_PS_VER cv,

2410: WHERE hpo.hecs_payment_option = p_hecs_payment_option;
2411: CURSOR c_ct IS
2412: SELECT ct.govt_course_type
2413: FROM IGS_EN_STDNT_PS_ATT sca,
2414: IGS_PS_VER cv,
2415: IGS_PS_TYPE ct
2416: WHERE sca.person_id = p_person_id AND
2417: sca.course_cd = p_course_cd AND
2418: cv.course_cd = sca.course_cd AND

Line 2440: IGS_PS_VER cv,

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
2442: WHERE scho.person_id = p_person_id AND
2443: scho.hecs_payment_option = hpo.hecs_payment_option AND
2444: sca.person_id = scho.person_id AND