APPS.IGS_EN_GEN_008 dependencies on IGS_EN_UNIT_SET

Line 613: -- This routine will get the IGS_EN_UNIT_SET title from either the

609: p_sequence_number IN NUMBER ,
610: p_person_id IN NUMBER )
611: RETURN VARCHAR2 AS
612: BEGIN -- enrp_get_us_title
613: -- This routine will get the IGS_EN_UNIT_SET title from either the
614: -- IGS_AS_SU_SETATMPT, IGS_PS_OFR_UNIT_SET or IGS_EN_UNIT_SET table,
615: -- taking the lowest level which is set.
616: DECLARE
617: v_override_title igs_as_su_setatmpt.override_title%TYPE;

Line 614: -- IGS_AS_SU_SETATMPT, IGS_PS_OFR_UNIT_SET or IGS_EN_UNIT_SET table,

610: p_person_id IN NUMBER )
611: RETURN VARCHAR2 AS
612: BEGIN -- enrp_get_us_title
613: -- This routine will get the IGS_EN_UNIT_SET title from either the
614: -- IGS_AS_SU_SETATMPT, IGS_PS_OFR_UNIT_SET or IGS_EN_UNIT_SET table,
615: -- taking the lowest level which is set.
616: DECLARE
617: v_override_title igs_as_su_setatmpt.override_title%TYPE;
618: v_cous_override_title igs_ps_ofr_unit_set.override_title%TYPE;

Line 619: v_us_title igs_en_unit_set.title%TYPE;

615: -- taking the lowest level which is set.
616: DECLARE
617: v_override_title igs_as_su_setatmpt.override_title%TYPE;
618: v_cous_override_title igs_ps_ofr_unit_set.override_title%TYPE;
619: v_us_title igs_en_unit_set.title%TYPE;
620: CURSOR c_susa IS
621: SELECT susa.override_title
622: FROM igs_as_su_setatmpt susa
623: WHERE susa.person_id = p_person_id AND

Line 630: FROM igs_en_unit_set us,

626: susa.sequence_number = p_sequence_number;
627: CURSOR c_us_cous IS
628: SELECT cous.override_title,
629: us.title
630: FROM igs_en_unit_set us,
631: igs_ps_ofr_unit_set cous
632: WHERE us.unit_set_cd = p_unit_set_cd AND
633: us.version_number = p_us_version_number AND
634: cous.unit_set_cd(+) = us.unit_set_cd AND

Line 2756: FROM igs_as_su_setatmpt susa , igs_en_unit_set us , igs_en_unit_set_cat usc

2752:
2753: -- get the currently active unit set for the person course attempt
2754: CURSOR c_active_us IS
2755: SELECT susa.selection_dt
2756: FROM igs_as_su_setatmpt susa , igs_en_unit_set us , igs_en_unit_set_cat usc
2757: WHERE susa.person_id = p_person_id AND
2758: susa.course_cd = p_course_cd AND
2759: susa.selection_dt IS NOT NULL AND
2760: susa.end_dt IS NULL AND

Line 2770: FROM igs_as_su_setatmpt susa , igs_en_unit_set us , igs_en_unit_set_cat usc

2766:
2767: -- find the last active unit set for the person program
2768: CURSOR c_last_us IS
2769: SELECT susa.selection_dt
2770: FROM igs_as_su_setatmpt susa , igs_en_unit_set us , igs_en_unit_set_cat usc
2771: WHERE susa.person_id = p_person_id AND
2772: susa.course_cd = p_course_cd AND
2773: susa.rqrmnts_complete_dt IS NOT NULL AND
2774: susa.unit_set_cd = us.unit_set_cd AND