APPS.IGS_EN_DROP_UNITS_API dependencies on IGS_PS_UNIT_OFR_OPT

Line 52: (SELECT ''X'' FROM igs_ps_unit_ofr_opt uoo

48: WHERE sua.uoo_id =:1
49: AND sua.person_id =:2
50: AND sua.course_cd =:3
51: AND EXISTS
52: (SELECT ''X'' FROM igs_ps_unit_ofr_opt uoo
53: WHERE uoo.sup_uoo_id IN (' ||p_drop_alluoo_ids||')
54: AND uoo.relation_type = ''SUBORDINATE''
55: AND uoo.uoo_id = sua.uoo_id)' USING p_uoo_id,p_person_id,p_course_cd;
56:

Line 144: FROM igs_ps_unit_ofr_opt

140:
141: -- cursor to get unit details
142: CURSOR get_unit_dtls (p_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
143: SELECT unit_cd||'/'||unit_class unit_det
144: FROM igs_ps_unit_ofr_opt
145: WHERE uoo_id = p_uoo_id ;
146:
147: l_unit_rec get_unit_dtls%ROWTYPE;
148: l_message_icon VARCHAR2(10);

Line 947: FROM igs_ps_unit_ofr_opt

943:
944: -- cursor to get unit details
945: CURSOR get_unit_dtls (p_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
946: SELECT unit_cd||'/'||unit_class unit_det
947: FROM igs_ps_unit_ofr_opt
948: WHERE uoo_id = p_uoo_id ;
949:
950: TYPE c_ref_cursor IS REF CURSOR;
951: c_chk_sub c_ref_cursor;

Line 956: l_sub_uooid igs_ps_unit_ofr_opt.uoo_id%TYPE;

952:
953: l_unit_section get_unit_dtls%ROWTYPE;
954: l_grep_uoo_ids VARCHAR2(2000);
955: l_selected_uoo_ids VARCHAR2(3000);
956: l_sub_uooid igs_ps_unit_ofr_opt.uoo_id%TYPE;
957: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
958: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
959: l_sup_uooid igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;
960:

Line 957: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

953: l_unit_section get_unit_dtls%ROWTYPE;
954: l_grep_uoo_ids VARCHAR2(2000);
955: l_selected_uoo_ids VARCHAR2(3000);
956: l_sub_uooid igs_ps_unit_ofr_opt.uoo_id%TYPE;
957: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
958: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
959: l_sup_uooid igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;
960:
961: BEGIN

Line 958: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;

954: l_grep_uoo_ids VARCHAR2(2000);
955: l_selected_uoo_ids VARCHAR2(3000);
956: l_sub_uooid igs_ps_unit_ofr_opt.uoo_id%TYPE;
957: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
958: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
959: l_sup_uooid igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;
960:
961: BEGIN
962:

Line 959: l_sup_uooid igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;

955: l_selected_uoo_ids VARCHAR2(3000);
956: l_sub_uooid igs_ps_unit_ofr_opt.uoo_id%TYPE;
957: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
958: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
959: l_sup_uooid igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;
960:
961: BEGIN
962:
963: --modified sql query for bug 5037726,sqlid:14792730

Line 966: FROM igs_ps_unit_ofr_opt uoo

962:
963: --modified sql query for bug 5037726,sqlid:14792730
964: OPEN c_chk_sub FOR
965: 'SELECT uoo.uoo_id sub_uoo_id, uoo.unit_cd, uoo.unit_class, uoo.sup_uoo_id
966: FROM igs_ps_unit_ofr_opt uoo
967: WHERE uoo.sup_uoo_id IN ('||p_selected_uoo_ids||')
968: AND uoo.RELATION_TYPE = ''SUBORDINATE''
969: AND uoo.uoo_id IN
970: ( SELECT uoo_id FROM igs_en_su_attempt