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_ELGBL_UNIT dependencies on IGS_PS_UNIT_OFR_OPT

Line 123: igs_ps_unit_ofr_opt uoo

119: CURSOR c_usec_audit_lim IS
120: SELECT NVL (usec.max_auditors_allowed, NVL(uv.max_auditors_allowed,999999) )
121: FROM igs_ps_usec_lim_wlst usec,
122: igs_ps_unit_ver uv,
123: igs_ps_unit_ofr_opt uoo
124: WHERE uoo.unit_cd = uv.unit_cd
125: AND uoo.version_number = uv.version_number
126: AND uoo.uoo_id = usec.uoo_id (+)
127: AND uoo.uoo_id = p_uoo_id;

Line 157: l_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;

153: cur_step_def_var_rec step_rec;
154:
155: l_system_type igs_pe_person_types.system_type%TYPE;
156: l_message VARCHAR2(30);
157: l_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
158: l_waitlist_ind VARCHAR2(1);
159: l_step_def_query VARCHAR2(2000);
160: l_repeat_tag VARCHAR2(1);
161: l_assessment_ind VARCHAR2(1);

Line 165: CURSOR c_cross_list(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

161: l_assessment_ind VARCHAR2(1);
162: l_usec_audit_lim NUMBER;
163: l_audit_sua NUMBER;
164: -- Cursor to check whether the unit section belongs to any cross-listed group or not.
165: CURSOR c_cross_list(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
166: SELECT 'x'
167: FROM igs_ps_usec_x_grpmem
168: WHERE uoo_id = l_uoo_id;
169:

Line 171: CURSOR c_class_meet (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

167: FROM igs_ps_usec_x_grpmem
168: WHERE uoo_id = l_uoo_id;
169:
170: -- Cursor to check whether the unit section belongs to any Meet with class group.
171: CURSOR c_class_meet (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
172: SELECT 'x'
173: FROM igs_ps_uso_clas_meet
174: WHERE uoo_id = l_uoo_id;
175:

Line 1031: FROM igs_ps_unit_ofr_opt

1027: WHERE person_type_code = p_person_type_code;
1028: --
1029: CURSOR cur_ss_enrol_ind(p_uoo_id NUMBER) IS
1030: SELECT ss_enrol_ind,unit_class,unit_cd
1031: FROM igs_ps_unit_ofr_opt
1032: WHERE uoo_id = p_uoo_id;
1033: --
1034: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
1035: l_system_type igs_pe_person_types.system_type%TYPE ;

Line 1147: FROM igs_ps_unit_ofr_opt

1143: --Who When What
1144: -------------------------------------------------------------------------------------
1145: CURSOR cur_uoo_dtl(p_uoo_id NUMBER) IS
1146: SELECT unit_cd,version_number, unit_class
1147: FROM igs_ps_unit_ofr_opt
1148: WHERE uoo_id = p_uoo_id;
1149: --
1150: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
1151: l_uoo_dtl_rec cur_uoo_dtl%ROWTYPE;

Line 1287: igs_ps_unit_ofr_opt uoo

1283: --
1284: CURSOR cur_chk_floc(p_coo_id NUMBER, p_uoo_id NUMBER) IS
1285: SELECT uoo.location_cd
1286: FROM igs_ps_ofr_opt coo,
1287: igs_ps_unit_ofr_opt uoo
1288: WHERE coo.coo_id = p_coo_id AND
1289: uoo.uoo_id = p_uoo_id AND
1290: uoo.location_cd = coo.location_cd;
1291:

Line 1302: FROM igs_ps_unit_ofr_opt

1298:
1299: -- Cursor to get the unit location code
1300: CURSOR c_location IS
1301: SELECT location_cd, unit_cd, unit_class
1302: FROM igs_ps_unit_ofr_opt
1303: WHERE uoo_id = p_uoo_id;
1304: l_location_rec c_location%ROWTYPE;
1305:
1306: l_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;

Line 1309: l_chk_floc igs_ps_unit_ofr_opt.location_cd%TYPE ;

1305:
1306: l_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;
1307: v_message_name fnd_new_messages.message_name%TYPE;
1308: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
1309: l_chk_floc igs_ps_unit_ofr_opt.location_cd%TYPE ;
1310: l_message VARCHAR2(30);
1311: l_message_icon VARCHAR2(1);
1312: l_message_token VARCHAR2(100);
1313:

Line 1440: FROM igs_ps_unit_ofr_opt

1436: -- with a terms api function call. Term Records Build. Bug 2829263
1437: -------------------------------------------------------------------------------------
1438: CURSOR cur_unit_class(p_uoo_id NUMBER) IS
1439: SELECT unit_class,unit_cd
1440: FROM igs_ps_unit_ofr_opt
1441: WHERE uoo_id = p_uoo_id;
1442:
1443: CURSOR cur_get_fatt(p_coo_id NUMBER) IS
1444: SELECT attendance_mode

Line 1608: FROM igs_ps_unit_ofr_opt

1604: unit_class,
1605: version_number,
1606: cal_type,
1607: ci_sequence_number
1608: FROM igs_ps_unit_ofr_opt
1609: WHERE uoo_id = p_uoo_id;
1610: --
1611: -- Cursor to check if the Organization Unit has "Include Advanced Standing Units" set to Yes.
1612: -- and also get the max repeats allowed

Line 1698: FROM igs_ps_unit_ofr_opt usec,

1694: -- Organization Unit Code defined at Unit level is taken if it is not defined at Unit Section level.
1695: --
1696: CURSOR cur_organization_unit IS
1697: SELECT NVL (usec.owner_org_unit_cd, uv.owner_org_unit_cd) owner_org_unit_cd
1698: FROM igs_ps_unit_ofr_opt usec,
1699: igs_ps_unit_ver uv
1700: WHERE usec.uoo_id = p_uoo_id
1701: AND usec.unit_cd = uv.unit_cd
1702: AND usec.version_number = uv.version_number

Line 2014: FROM igs_ps_unit_ofr_opt

2010: unit_class,
2011: version_number,
2012: cal_type,
2013: ci_sequence_number
2014: FROM igs_ps_unit_ofr_opt
2015: WHERE uoo_id = p_uoo_id;
2016:
2017: -- smaddali modified this cursor to add advance standing units also, bug#4262571
2018: -- Cursor to select all the reenrolled Unit Attempts of the Student.

Line 2064: FROM igs_ps_unit_ofr_opt

2060: -- Cursor to get the same Teaching Period indicator at Unit Section level.
2061: --
2062: CURSOR cur_reenroll_in_same_tp_usec IS
2063: SELECT not_multiple_section_flag
2064: FROM igs_ps_unit_ofr_opt
2065: WHERE uoo_id = p_uoo_id;
2066:
2067: --
2068: -- Cursor to get the reenroll allowed indicator and the reenrollment limits

Line 2083: l_reenroll_in_same_tp igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE;

2079: rec_cur_unit_details cur_unit_details%ROWTYPE;
2080: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2081: l_no_of_reenrollments NUMBER := 0 ;
2082: l_total_reenroll_credit_points NUMBER := 0 ;
2083: l_reenroll_in_same_tp igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE;
2084: l_reenroll_allowed igs_ps_unit_ver.repeatable_ind%TYPE ;
2085: l_max_reenrollments_for_credit NUMBER ;
2086: l_max_renroll_credit_points NUMBER ;
2087: l_count NUMBER := 0;

Line 2499: igs_ps_unit_ofr_opt uoo,

2495: uoo.unit_class,
2496: NVL (uocr.start_date, NVL (uoo.unit_section_start_date, ci.start_dt)) start_date,
2497: NVL (uocr.end_date, NVL (uoo.unit_section_end_date, ci.end_dt)) end_date
2498: FROM igs_ps_usec_occurs uocr,
2499: igs_ps_unit_ofr_opt uoo,
2500: igs_ca_inst ci
2501: WHERE uoo.uoo_id = cp_uoo_id
2502: AND uoo.uoo_id = uocr.uoo_id
2503: AND uoo.cal_type = ci.cal_type

Line 2526: igs_ps_unit_ofr_opt_all uoo

2522: NVL (uocur.end_date, NVL (uoo.unit_section_end_date, lt.end_dt)) end_date
2523: FROM igs_ps_usec_occurs uocur,
2524: igs_en_su_attempt_all ua,
2525: igs_ca_inst lt,
2526: igs_ps_unit_ofr_opt_all uoo
2527: WHERE uocur.uoo_id = ua.uoo_id
2528: AND uoo.uoo_id = ua.uoo_id
2529: AND ua.uoo_id <> p_uoo_id
2530: AND ua.cal_type = lt.cal_type

Line 2760: igs_ps_unit_ofr_opt uoo

2756:
2757: CURSOR cur_unit_prereq(p_uoo_id NUMBER) IS
2758: SELECT rul_sequence_number
2759: FROM igs_ps_unit_ver_ru uvr,
2760: igs_ps_unit_ofr_opt uoo
2761: WHERE uvr.unit_cd = uoo.unit_cd AND
2762: uvr.version_number = uoo.version_number AND
2763: uoo_id = p_uoo_id AND
2764: uvr.s_rule_call_cd = 'PREREQ';

Line 2768: FROM igs_ps_unit_ofr_opt

2764: uvr.s_rule_call_cd = 'PREREQ';
2765:
2766: CURSOR cur_usec_dtl(p_uoo_id NUMBER) IS
2767: SELECT unit_cd,unit_class,version_number,cal_type,ci_sequence_number
2768: FROM igs_ps_unit_ofr_opt
2769: WHERE uoo_id = p_uoo_id;
2770:
2771: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2772: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;

Line 2774: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;

2770:
2771: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2772: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;
2773: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
2774: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
2775: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2776: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2777: l_message VARCHAR2(30);
2778: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;

Line 2775: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;

2771: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2772: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;
2773: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
2774: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
2775: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2776: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2777: l_message VARCHAR2(30);
2778: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;
2779: l_message_icon VARCHAR2(1);

Line 2776: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;

2772: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;
2773: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
2774: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
2775: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2776: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2777: l_message VARCHAR2(30);
2778: l_rule_text igs_ps_unit_ver_ru_v.rule_text%TYPE;
2779: l_message_icon VARCHAR2(1);
2780:

Line 2932: igs_ps_unit_ofr_opt uoo

2928:
2929: CURSOR cur_unit_coreq(p_uoo_id NUMBER) IS
2930: SELECT rul_sequence_number
2931: FROM igs_ps_unit_ver_ru uvr,
2932: igs_ps_unit_ofr_opt uoo
2933: WHERE uvr.unit_cd = uoo.unit_cd AND
2934: uvr.version_number = uoo.version_number AND
2935: uoo_id = p_uoo_id AND
2936: uvr.s_rule_call_cd = 'COREQ';

Line 2940: FROM igs_ps_unit_ofr_opt

2936: uvr.s_rule_call_cd = 'COREQ';
2937:
2938: CURSOR cur_usec_dtl(p_uoo_id NUMBER) IS
2939: SELECT unit_cd,unit_class,version_number,cal_type,ci_sequence_number
2940: FROM igs_ps_unit_ofr_opt
2941: WHERE uoo_id = p_uoo_id;
2942:
2943: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2944: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;

Line 3103: igs_ps_unit_ofr_opt uoo

3099:
3100: CURSOR cur_unit_incomp(p_uoo_id NUMBER) IS
3101: SELECT rul_sequence_number
3102: FROM igs_ps_unit_ver_ru uvr,
3103: igs_ps_unit_ofr_opt uoo
3104: WHERE uvr.unit_cd = uoo.unit_cd AND
3105: uvr.version_number = uoo.version_number AND
3106: uoo_id = p_uoo_id AND
3107: uvr.s_rule_call_cd = 'INCOMP';

Line 3111: FROM igs_ps_unit_ofr_opt

3107: uvr.s_rule_call_cd = 'INCOMP';
3108:
3109: CURSOR cur_usec_dtl(p_uoo_id NUMBER) IS
3110: SELECT unit_cd,unit_class,version_number,cal_type,ci_sequence_number
3111: FROM igs_ps_unit_ofr_opt
3112: WHERE uoo_id = p_uoo_id;
3113:
3114: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
3115: l_rul_sequence_number igs_ps_unit_ver_ru.rul_sequence_number%TYPE;

Line 3242: FROM igs_ps_unit_ofr_opt

3238: --Who When What
3239: -------------------------------------------------------------------------------------
3240: CURSOR cur_chk_sp_allowed(p_uoo_id NUMBER) IS
3241: SELECT special_permission_ind
3242: FROM igs_ps_unit_ofr_opt
3243: WHERE uoo_id = p_uoo_id;
3244:
3245: CURSOR cur_sp_approve(p_person_id NUMBER,p_uoo_id NUMBER) IS
3246: SELECT approval_status

Line 3255: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;

3251: approval_status = 'A';
3252:
3253: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
3254: l_sp_approve igs_en_spl_perm.approval_status%TYPE ;
3255: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;
3256:
3257: --
3258: -- begin of the function eval_spl_permission
3259: --

Line 3344: FROM igs_ps_unit_ofr_opt

3340:
3341: -- cursor to select the Unit section details
3342: CURSOR cur_usec_dtl(p_uoo_id NUMBER) IS
3343: SELECT unit_cd,unit_class,version_number,cal_type,ci_sequence_number,owner_org_unit_cd , reserved_seating_allowed
3344: FROM igs_ps_unit_ofr_opt
3345: WHERE uoo_id = p_uoo_id;
3346:
3347: -- cursor to fetch priorities defined at unit section level
3348: CURSOR cur_rsv_uoo_pri(p_uoo_id NUMBER) IS

Line 3425: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

3421: WHERE pgm.person_id = p_person_id AND
3422: pgm.group_id = p_group_id ;
3423:
3424:
3425: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
3426: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3427: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
3428: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3429: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;

Line 3426: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;

3422: pgm.group_id = p_group_id ;
3423:
3424:
3425: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
3426: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3427: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
3428: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3429: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3430: l_owner_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;

Line 3427: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;

3423:
3424:
3425: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
3426: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3427: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
3428: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3429: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3430: l_owner_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;
3431:

Line 3428: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;

3424:
3425: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
3426: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3427: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
3428: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3429: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3430: l_owner_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;
3431:
3432: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

Line 3429: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;

3425: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
3426: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3427: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
3428: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3429: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3430: l_owner_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;
3431:
3432: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
3433: l_rsv_allowed igs_ps_unit_ofr_opt.reserved_seating_allowed%TYPE;

Line 3430: l_owner_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;

3426: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3427: l_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
3428: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3429: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3430: l_owner_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;
3431:
3432: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
3433: l_rsv_allowed igs_ps_unit_ofr_opt.reserved_seating_allowed%TYPE;
3434: l_pri_satisfied VARCHAR2(1);

Line 3433: l_rsv_allowed igs_ps_unit_ofr_opt.reserved_seating_allowed%TYPE;

3429: l_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3430: l_owner_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;
3431:
3432: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
3433: l_rsv_allowed igs_ps_unit_ofr_opt.reserved_seating_allowed%TYPE;
3434: l_pri_satisfied VARCHAR2(1);
3435: l_unreserved_seats NUMBER;
3436:
3437: -- flag variable which stores in which level reserved seat setup found in the hierarchy

Line 3475: igs_ps_unit_ofr_opt uoo

3471: -- cursor to get the enrollment maximum defined at unit level
3472: CURSOR cur_unit_enr_max IS
3473: SELECT enrollment_maximum
3474: FROM igs_ps_unit_ver uv,
3475: igs_ps_unit_ofr_opt uoo
3476: WHERE uoo.uoo_id = p_uoo_id AND -- p_uoo_id is parameter of container function
3477: uv.unit_cd = uoo.unit_cd AND
3478: uv.version_number = uoo.version_number;
3479: --

Line 3501: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

3497: l_rsv_ext_id NUMBER;
3498: l_rsv_temp_id NUMBER;
3499:
3500: CURSOR c_igs_en_su_attempt (cp_person_id igs_pe_person.person_id%TYPE,
3501: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
3502: cp_course_cd igs_en_su_attempt.course_cd%TYPE
3503: ) IS
3504: SELECT *
3505: FROM igs_en_su_attempt

Line 4356: FROM igs_ps_unit_ofr_opt

4352: CURSOR cur_cal_type_seq_num (
4353: cp_uoo_id IN NUMBER
4354: ) IS
4355: SELECT cal_type, ci_sequence_number, unit_cd, unit_class
4356: FROM igs_ps_unit_ofr_opt
4357: WHERE uoo_id = cp_uoo_id;
4358: --
4359: -- Cursor to find Intermission Type and Start Date for a given Person and Program.
4360: --

Line 4545: FROM igs_ps_unit_ofr_opt

4541: cp_uoo_id IN NUMBER
4542: ) IS
4543: SELECT cal_type,
4544: ci_sequence_number,unit_cd,unit_class
4545: FROM igs_ps_unit_ofr_opt
4546: WHERE uoo_id = cp_uoo_id;
4547: --
4548: -- Cursor to find Visa Type and Visa Number.
4549: --

Line 4696: FROM igs_ps_unit_ofr_opt

4692: AND approval_status = 'A';
4693:
4694: CURSOR cur_chk_au_allowed IS
4695: SELECT NVL(auditable_ind, 'N')
4696: FROM igs_ps_unit_ofr_opt
4697: WHERE uoo_id = p_uoo_id;
4698:
4699: CURSOR cur_chk_au_perm_req IS
4700: SELECT NVL(audit_permission_ind, 'N')

Line 4701: FROM igs_ps_unit_ofr_opt

4697: WHERE uoo_id = p_uoo_id;
4698:
4699: CURSOR cur_chk_au_perm_req IS
4700: SELECT NVL(audit_permission_ind, 'N')
4701: FROM igs_ps_unit_ofr_opt
4702: WHERE uoo_id = p_uoo_id;
4703:
4704: -- Local variables
4705: l_dummy VARCHAR2(1);

Line 4830: FROM igs_ps_unit_ofr_opt

4826: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
4827:
4828: CURSOR cur_usec_dtls IS
4829: SELECT unit_cd,unit_class
4830: FROM igs_ps_unit_ofr_opt
4831: WHERE uoo_id = p_uoo_id;
4832:
4833: l_usec_dtls cur_usec_dtls%ROWTYPE;
4834: l_message VARCHAR2(30);

Line 4961: FROM igs_ps_unit_ver uv, igs_ps_unit_ofr_opt uoo

4957:
4958:
4959: CURSOR c_unit_award IS
4960: SELECT NVL(AWARD_COURSE_ONLY_IND,'N')
4961: FROM igs_ps_unit_ver uv, igs_ps_unit_ofr_opt uoo
4962: where uv.unit_cd = uoo.unit_cd
4963: and uv.version_number = uoo.version_number
4964: and uoo.uoo_id = p_uoo_id;
4965: