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

Line 754: CURSOR c_sua_rs (p_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,

750: WHERE uoo.uoo_id = ucls.uoo_id
751: AND ucls.class_meet_group_id = l_class_meet_group_id;
752:
753: --Cursor to get the reserve seat id at unit section attempt level
754: CURSOR c_sua_rs (p_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
755: p_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
756: p_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
757: SELECT rsv_seat_ext_id FROM igs_en_su_attempt
758: WHERE person_id = p_person_id

Line 755: p_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,

751: AND ucls.class_meet_group_id = l_class_meet_group_id;
752:
753: --Cursor to get the reserve seat id at unit section attempt level
754: CURSOR c_sua_rs (p_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
755: p_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
756: p_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
757: SELECT rsv_seat_ext_id FROM igs_en_su_attempt
758: WHERE person_id = p_person_id
759: AND course_cd = p_course_cd

Line 756: p_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS

752:
753: --Cursor to get the reserve seat id at unit section attempt level
754: CURSOR c_sua_rs (p_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
755: p_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
756: p_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
757: SELECT rsv_seat_ext_id FROM igs_en_su_attempt
758: WHERE person_id = p_person_id
759: AND course_cd = p_course_cd
760: AND p_uoo_id = p_uoo_id

Line 757: SELECT rsv_seat_ext_id FROM igs_en_su_attempt

753: --Cursor to get the reserve seat id at unit section attempt level
754: CURSOR c_sua_rs (p_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
755: p_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
756: p_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
757: SELECT rsv_seat_ext_id FROM igs_en_su_attempt
758: WHERE person_id = p_person_id
759: AND course_cd = p_course_cd
760: AND p_uoo_id = p_uoo_id
761: AND rsv_seat_ext_id IS NOT NULL;

Line 763: l_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE;

759: AND course_cd = p_course_cd
760: AND p_uoo_id = p_uoo_id
761: AND rsv_seat_ext_id IS NOT NULL;
762:
763: l_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE;
764: l_version_number igs_ps_ver.version_number%TYPE;
765: l_enrollment_maximum igs_ps_unit_ver.enrollment_maximum%TYPE;
766: l_override_enrollment_max igs_ps_unit_ver.override_enrollment_max%TYPE;
767: l_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE;

Line 1393: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1389: -- based on the rule status this function will return TRUE or FALSE
1390: --
1391: --
1392: FUNCTION enrp_val_ps_stage (
1393: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1394: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1395: p_version_number NUMBER,
1396: p_preference_code VARCHAR2
1397: ) RETURN BOOLEAN AS

Line 1394: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1390: --
1391: --
1392: FUNCTION enrp_val_ps_stage (
1393: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1394: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1395: p_version_number NUMBER,
1396: p_preference_code VARCHAR2
1397: ) RETURN BOOLEAN AS
1398: --

Line 1473: p_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,

1469: --
1470: --
1471: -- Added as part of ENCR013
1472: FUNCTION enrp_get_appr_cr_pt(
1473: p_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
1474: p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1475: ) RETURN NUMBER AS
1476: /******************************************************************
1477: Created By : knaraset

Line 1474: p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE

1470: --
1471: -- Added as part of ENCR013
1472: FUNCTION enrp_get_appr_cr_pt(
1473: p_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
1474: p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1475: ) RETURN NUMBER AS
1476: /******************************************************************
1477: Created By : knaraset
1478: Date Created By : 12-Nov-2001

Line 2555: CURSOR cur_get_core_ind(cp_person_id igs_en_su_attempt.person_id%TYPE,

2551:
2552: --
2553: -- Cursor to find the Core Indicator associated with a Unit Attempt
2554: --
2555: CURSOR cur_get_core_ind(cp_person_id igs_en_su_attempt.person_id%TYPE,
2556: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
2557: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
2558: IS
2559: SELECT core_indicator_code

Line 2556: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

2552: --
2553: -- Cursor to find the Core Indicator associated with a Unit Attempt
2554: --
2555: CURSOR cur_get_core_ind(cp_person_id igs_en_su_attempt.person_id%TYPE,
2556: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
2557: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
2558: IS
2559: SELECT core_indicator_code
2560: FROM igs_en_su_attempt

Line 2557: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)

2553: -- Cursor to find the Core Indicator associated with a Unit Attempt
2554: --
2555: CURSOR cur_get_core_ind(cp_person_id igs_en_su_attempt.person_id%TYPE,
2556: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
2557: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
2558: IS
2559: SELECT core_indicator_code
2560: FROM igs_en_su_attempt
2561: WHERE person_id = cp_person_id

Line 2560: FROM igs_en_su_attempt

2556: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
2557: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
2558: IS
2559: SELECT core_indicator_code
2560: FROM igs_en_su_attempt
2561: WHERE person_id = cp_person_id
2562: AND course_cd = cp_course_cd
2563: AND uoo_id = cp_uoo_id;
2564:

Line 2565: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;

2561: WHERE person_id = cp_person_id
2562: AND course_cd = cp_course_cd
2563: AND uoo_id = cp_uoo_id;
2564:
2565: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
2566: l_person_type igs_pe_person_types.person_type_code%TYPE;
2567: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
2568: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2569: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;