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_ATT

Line 26: FROM IGS_EN_STDNT_PS_ATT sca

22: DECLARE
23: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
24: CURSOR c_sca IS
25: SELECT sca.course_attempt_status
26: FROM IGS_EN_STDNT_PS_ATT sca
27: WHERE sca.person_id = p_person_id AND
28: sca.course_cd = p_course_cd;
29: v_sca_rec c_sca%ROWTYPE;
30: v_message_name varchar2(30) ;

Line 934: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

930: RETURN BOOLEAN AS
931: BEGIN
932: DECLARE
933: v_other_detail VARCHAR2(255);
934: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
935: CURSOR c_attempt_status IS
936: SELECT course_attempt_status
937: FROM IGS_EN_STDNT_PS_ATT
938: WHERE person_id = p_person_id AND

Line 937: FROM IGS_EN_STDNT_PS_ATT

933: v_other_detail VARCHAR2(255);
934: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
935: CURSOR c_attempt_status IS
936: SELECT course_attempt_status
937: FROM IGS_EN_STDNT_PS_ATT
938: WHERE person_id = p_person_id AND
939: course_cd = p_course_cd;
940: BEGIN
941: -- This module validates the insertion of a

Line 1558: FROM IGS_EN_STDNT_PS_ATT sca,

1554: FROM IGS_FI_HECS_PAY_OPTN hpo
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

Line 1717: FROM IGS_EN_STDNT_PS_ATT sca,

1713: FROM IGS_FI_HECS_PAY_OPTN hpo
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

Line 2413: FROM IGS_EN_STDNT_PS_ATT sca,

2409: FROM IGS_FI_HECS_PAY_OPTN hpo
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

Line 2439: IGS_EN_STDNT_PS_ATT sca,

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

Line 3052: -- The IGS_EN_STDNT_PS_ATT.commencement_dt is also used in validations.

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;
3056: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;

Line 3055: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

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;
3056: v_govt_citizenship_cd IGS_ST_CITIZENSHP_CD.govt_citizenship_cd%TYPE;
3057: v_validation_failed BOOLEAN DEFAULT FALSE;
3058: CURSOR c_hpo IS
3059: SELECT hpo.govt_hecs_payment_option

Line 3064: FROM IGS_EN_STDNT_PS_ATT sca

3060: FROM IGS_FI_HECS_PAY_OPTN hpo
3061: WHERE hpo.hecs_payment_option = p_hecs_payment_option;
3062: CURSOR c_sca IS
3063: SELECT sca.commencement_dt
3064: FROM IGS_EN_STDNT_PS_ATT sca
3065: WHERE sca.person_id = p_person_id AND
3066: sca.course_cd = p_course_cd;
3067: CURSOR c_ps IS
3068: SELECT ps.start_dt,

Line 3092: IGS_EN_STDNT_PS_ATT sca

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
3095: sca.person_id = scho.person_id AND
3096: sca.course_cd = scho.course_cd

Line 3131: lp_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE,

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,
3135: lp_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE)