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_SCA dependencies on IGS_EN_SU_ATTEMPT

Line 397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
395: v_acad_ci_sequence_number
396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
398: v_research_eftsu NUMBER;
399: v_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;
401: CURSOR c_sca IS

Line 416: FROM IGS_EN_SU_ATTEMPT sua,

412: CURSOR c_cir_ci_cat_sua_uv IS
413: SELECT cir.sup_cal_type,
414: cir.sup_ci_sequence_number,
415: sua.cal_type
416: FROM IGS_EN_SU_ATTEMPT sua,
417: IGS_CA_INST_REL cir,
418: IGS_CA_INST ci,
419: IGS_CA_TYPE cat,
420: IGS_PS_UNIT_VER uv

Line 438: cp_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE) IS

434: CURSOR c_cir (
435: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
436: cp_acad_ci_sequence_number
437: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE,
438: cp_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE) IS
439: SELECT dla.cal_type,
440: dla.ci_sequence_number
441: FROM IGS_CA_INST_REL cir,
442: IGS_ST_DFT_LOAD_APPO dla

Line 886: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';

882: -- This module validates that the IGS_EN_STDNT_PS_ATT enrolled units satisfy
883: -- unit rules. This routine is to be called when all changes have been posted.
884: DECLARE
885: cst_enrolled CONSTANT
886: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
887: v_message_text VARCHAR2(2000);
888: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE;
889: CURSOR c_sua IS
890: SELECT sua.unit_cd,

Line 888: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE;

884: DECLARE
885: cst_enrolled CONSTANT
886: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
887: v_message_text VARCHAR2(2000);
888: l_failed_rule igs_en_su_attempt_all.failed_unit_rule%TYPE;
889: CURSOR c_sua IS
890: SELECT sua.unit_cd,
891: sua.version_number,
892: sua.cal_type,

Line 896: FROM IGS_EN_SU_ATTEMPT sua

892: sua.cal_type,
893: sua.ci_sequence_number,
894: sua.rule_waived_dt,
895: sua.uoo_id
896: FROM IGS_EN_SU_ATTEMPT sua
897: WHERE sua.person_id = p_person_id AND
898: sua.course_cd = p_course_cd AND
899: sua.unit_attempt_status = cst_enrolled;
900: BEGIN

Line 973: FROM IGS_EN_SU_ATTEMPT sua

969: CURSOR c_sua IS
970: SELECT sua.cal_type,
971: sua.ci_sequence_number,
972: sua.unit_attempt_status
973: FROM IGS_EN_SU_ATTEMPT sua
974: WHERE sua.person_id = p_person_id AND
975: sua.course_cd = p_course_cd AND
976: sua.unit_attempt_status IN (
977: cst_invalid,

Line 1260: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

1256: v_attendance_types VARCHAR2(100);
1257: CURSOR c_sua (
1258: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1259: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1260: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1261: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
1262: SELECT sua.location_cd,
1263: sua.unit_class
1264: FROM IGS_EN_SU_ATTEMPT sua

Line 1261: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS

1257: CURSOR c_sua (
1258: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1259: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1260: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1261: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
1262: SELECT sua.location_cd,
1263: sua.unit_class
1264: FROM IGS_EN_SU_ATTEMPT sua
1265: WHERE sua.person_id = cp_person_id AND

Line 1264: FROM IGS_EN_SU_ATTEMPT sua

1260: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1261: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
1262: SELECT sua.location_cd,
1263: sua.unit_class
1264: FROM IGS_EN_SU_ATTEMPT sua
1265: WHERE sua.person_id = cp_person_id AND
1266: sua.course_cd = cp_course_cd AND
1267: sua.unit_attempt_status = 'ENROLLED' AND
1268: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

Line 1372: FROM IGS_EN_SU_ATTEMPT

1368: v_adm_offer_resp_status VARCHAR2(10);
1369: v_s_adm_offer_resp_status VARCHAR2(10);
1370: CURSOR c_sua IS
1371: SELECT 'x'
1372: FROM IGS_EN_SU_ATTEMPT
1373: WHERE person_id = p_person_id AND
1374: course_cd = p_course_cd AND
1375: unit_attempt_status <> cst_unconfirm;
1376: BEGIN

Line 1917: FROM IGS_EN_SU_ATTEMPT sua

1913: cs.s_course_status <> cst_active;
1914: v_cv_exists VARCHAR2(1);
1915: CURSOR c_sua_enr IS
1916: SELECT 'x'
1917: FROM IGS_EN_SU_ATTEMPT sua
1918: WHERE sua.person_id = p_person_id AND
1919: sua.course_cd = p_course_cd AND
1920: sua.unit_attempt_status = cst_enrolled;
1921: v_sua_enr_exists VARCHAR2(1);

Line 1925: IGS_EN_SU_ATTEMPT sua

1921: v_sua_enr_exists VARCHAR2(1);
1922: CURSOR c_sua_comp IS
1923: SELECT 'x'
1924: FROM IGS_AS_SU_STMPTOUT suao,
1925: IGS_EN_SU_ATTEMPT sua
1926: WHERE sua.person_id = p_person_id AND
1927: sua.course_cd = p_course_cd AND
1928: sua.unit_attempt_status = cst_completed AND
1929: suao.person_id = sua.person_id AND

Line 2043: -- Validate that discontinued is not prior to COMPLETED IGS_EN_SU_ATTEMPTs

2039: -- p_message_name := v_message_name;
2040: -- RETURN FALSE;
2041: --END IF;
2042: ELSE -- p_discontinued_dt IS NOT NULL
2043: -- Validate that discontinued is not prior to COMPLETED IGS_EN_SU_ATTEMPTs
2044: OPEN c_sua_comp;
2045: FETCH c_sua_comp INTO v_sua_comp_exists;
2046: IF c_sua_comp%FOUND THEN
2047: CLOSE c_sua_comp;

Line 2209: FROM IGS_EN_SU_ATTEMPT sua,

2205: aa.admission_appl_number = cp_adm_admission_appl_number;
2206: v_aa_rec c_aa%ROWTYPE;
2207: CURSOR c_sua_ci IS
2208: SELECT 'x'
2209: FROM IGS_EN_SU_ATTEMPT sua,
2210: IGS_CA_INST ci
2211: WHERE sua.person_id = p_person_id AND
2212: sua.course_cd = p_course_cd AND
2213: sua.unit_attempt_status IN(

Line 2737: igs_en_su_attempt sua

2733: CURSOR c_sua_term (cp_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
2734: cp_course_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS
2735: SELECT tlv.LOAD_END_DT
2736: From igs_ca_teach_to_load_V tlv,
2737: igs_en_su_attempt sua
2738: Where sua.person_id = cp_person_id
2739: AND sua.course_cd = cp_course_cd
2740: AND sua.unit_attempt_status NOT IN ('DROPPED','UNCONFIRM')
2741: AND teach_cal_type = sua.cal_type

Line 2775: FROM IGS_EN_SU_ATTEMPT sua

2771: RETURN BOOLEAN
2772: AS
2773: CURSOR c_sua IS
2774: SELECT uoo_id
2775: FROM IGS_EN_SU_ATTEMPT sua
2776: WHERE sua.person_id = p_person_id
2777: AND sua.course_cd = p_course_cd
2778: AND sua.unit_attempt_status = 'UNCONFIRM' ;
2779: returnFlag BOOLEAN := TRUE;

Line 2808: from IGS_EN_SU_ATTEMPT_ALL sua

2804: --exist for a program attempt
2805: Cursor cur_sua(cp_person_id NUMBER,
2806: cp_course_cd VARCHAR2) IS
2807: Select 'x'
2808: from IGS_EN_SU_ATTEMPT_ALL sua
2809: where sua.person_id=cp_person_id
2810: and sua.course_cd=cp_course_cd
2811: and sua.unit_attempt_status <> 'UNCONFIRM';
2812:

Line 2825: from IGS_EN_SU_ATTEMPT_ALL sua

2821: --cursor to check unconfirm unit attempts exist
2822: Cursor cur_sua_unconfirm(cp_person_id NUMBER,
2823: cp_course_cd VARCHAR2) IS
2824: Select 'x'
2825: from IGS_EN_SU_ATTEMPT_ALL sua
2826: where sua.person_id=cp_person_id
2827: and sua.course_cd=cp_course_cd
2828: and sua.unit_attempt_status = 'UNCONFIRM';
2829: