APPS.IGS_EN_PLAN_UTILS dependencies on IGS_PS_UNIT_OFR_OPT

Line 36: CURSOR c_get_unitSection(cp_uooid IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS

32: p_return_status OUT NOCOPY VARCHAR2,
33: p_message_name OUT NOCOPY VARCHAR2,
34: p_ss_session_id IN NUMBER) AS
35:
36: CURSOR c_get_unitSection(cp_uooid IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
37: SELECT unit_cd || '/' || unit_class
38: FROM IGS_PS_UNIT_OFR_OPT
39: WHERE uoo_id = cp_uooid;
40:

Line 38: FROM IGS_PS_UNIT_OFR_OPT

34: p_ss_session_id IN NUMBER) AS
35:
36: CURSOR c_get_unitSection(cp_uooid IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
37: SELECT unit_cd || '/' || unit_class
38: FROM IGS_PS_UNIT_OFR_OPT
39: WHERE uoo_id = cp_uooid;
40:
41: l_strtpoint NUMBER;
42: l_endpoint NUMBER;

Line 518: FROM IGS_PS_UNIT_OFR_OPT UOO

514: AND pl.course_cd = p_course_cd
515: AND pl.cart_error_flag = P_CARTFLAG
516: AND (pl.uoo_id = P_UOOID
517: OR ( EXISTS ( SELECT 'X'
518: FROM IGS_PS_UNIT_OFR_OPT UOO
519: WHERE UOO.SUP_UOO_ID = P_UOOID
520: AND UOO.RELATION_TYPE = 'SUBORDINATE'
521: AND UOO.UOO_ID = pl.UOO_ID)
522: )

Line 530: FROM igs_ps_unit_ofr_opt_all

526: cur_plan_unit_rec cur_plan_unit%ROWTYPE;
527:
528: CURSOR c_usec_dtls(cp_n_uoo_id IN NUMBER) IS
529: SELECT unit_cd || '/' || unit_class UnitSection
530: FROM igs_ps_unit_ofr_opt_all
531: WHERE uoo_id = cp_n_uoo_id;
532:
533: CURSOR cur_permission_unit(cp_uoo_id IN NUMBER) IS
534: SELECT spl.spl_perm_request_id

Line 817: l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

813: --vijrajag 28-Oct-2005 Should create a Deny warning only if the DROP_CORE step fails
814: -------------------------------------------------------------------
815: IS
816: l_uoo_ids varchar2(2000);
817: l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
818: l_found varchar2(1);
819: l_pos number;
820: l_row_id ROWID;
821: l_warning_id igs_en_std_warnings.warning_id%TYPE;

Line 824: SELECT 'X' FROM igs_en_su_attempt_all sua, igs_ps_unit_ofr_opt_all uoo

820: l_row_id ROWID;
821: l_warning_id igs_en_std_warnings.warning_id%TYPE;
822: l_deny_warn VARCHAR2(20);
823: CURSOR c_unit_sec_rep(cp_uoo_id IN NUMBER) IS
824: SELECT 'X' FROM igs_en_su_attempt_all sua, igs_ps_unit_ofr_opt_all uoo
825: WHERE uoo.uoo_id = cp_uoo_id
826: AND sua.person_id = p_n_person_id
827: AND sua.course_cd = p_c_program_code
828: AND sua.core_indicator_code = 'CORE'

Line 947: l_cur_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE; -- current uoo_id

943: c_ref_cur_coreq_prereq c_ref_cursor;
944: l_c_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE;
945: l_uoo_ids varchar2(32000);
946: pos number;
947: l_cur_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE; -- current uoo_id
948: l_start_index NUMBER;
949: l_end_index NUMBER;
950: -- l_sub VARCHAR2(1); -- indicate whether the current unit section is subordinate or not.
951:

Line 1454: igs_ps_unit_ofr_opt_all uoo

1450: SELECT sua.unit_cd || '/' || sua.unit_class AS UNIT_SECTION,
1451: sua.uoo_id,
1452: sua.core_indicator_code AS CORE
1453: FROM igs_en_su_attempt_all sua,
1454: igs_ps_unit_ofr_opt_all uoo
1455: WHERE sua.person_id = cp_person_id
1456: AND sua.course_cd = cp_course_cd
1457: AND sua.uoo_id = uoo.uoo_id
1458: AND uoo.sup_uoo_id = cp_uoo_id;

Line 1712: FROM igs_ps_unit_ofr_opt

1708: -- cursor for getting the Unit_cd and Version Number for the Uoo_id passed
1709: CURSOR cur_ps_unit_ofr
1710: IS
1711: SELECT unit_cd, version_number,cal_type,ci_sequence_number
1712: FROM igs_ps_unit_ofr_opt
1713: WHERE uoo_id = p_uoo_id;
1714:
1715: -- Check if the unit is set up for variable cp
1716: CURSOR cur_chk_cp_chg_val (p_unit_cd igs_ps_unit_ver_v.unit_cd%TYPE,p_unit_ver_num igs_ps_unit_ver_v.version_number%TYPE)