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_TYPE

Line 1551: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;

1547: RETURN BOOLEAN AS
1548: BEGIN
1549: DECLARE
1550: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
1551: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
1552: CURSOR c_ghpo IS
1553: SELECT hpo.govt_hecs_payment_option
1554: FROM IGS_FI_HECS_PAY_OPTN hpo
1555: WHERE hpo.hecs_payment_option = p_hecs_payment_option;

Line 1560: IGS_PS_TYPE cty

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
1564: crv.version_number = sca.version_number AND

Line 1569: -- IGS_PS_TYPE.

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,
1573: -- then the government value for the IGS_PS_VER.IGS_PS_TYPE for the

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 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 2404: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;

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;
2406: v_validation_failed BOOLEAN DEFAULT FALSE;
2407: CURSOR c_hpo IS
2408: SELECT hpo.govt_hecs_payment_option

Line 2415: IGS_PS_TYPE ct

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
2419: cv.version_number = sca.version_number AND

Line 2441: IGS_PS_TYPE ct

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
2445: sca.course_cd = scho.course_cd AND

Line 2465: -- Get the govt value for IGS_PS_TYPE

2461: CLOSE c_hpo;
2462: RETURN FALSE;
2463: END IF;
2464: CLOSE c_hpo;
2465: -- Get the govt value for IGS_PS_TYPE
2466: OPEN c_ct;
2467: FETCH c_ct INTO v_govt_course_type;
2468: IF c_ct%NOTFOUND THEN
2469: CLOSE c_ct;

Line 2504: p_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE,

2500: END;
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

Line 2637: -- get govt values for student hecs paymnt option, IGS_PS_TYPE

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