APPS.IGS_EN_GEN_015 dependencies on IGS_EN_ELGB_OVR_STEP

Line 200: FROM igs_en_elgb_ovr_step eos,

196: cp_cal_seq_number IN NUMBER
197: ) IS
198: SELECT step_override_limit,
199: step_override_type
200: FROM igs_en_elgb_ovr_step eos,
201: igs_en_elgb_ovr eoa
202: WHERE eoa.elgb_override_id = eos.elgb_override_id
203: AND eoa.cal_type = cp_cal_type
204: AND eoa.ci_sequence_number = cp_cal_seq_number

Line 218: FROM igs_en_elgb_ovr_step eos,

214: cp_uoo_id IN NUMBER
215: ) IS
216: SELECT eou.step_override_limit,
217: step_override_type
218: FROM igs_en_elgb_ovr_step eos,
219: igs_en_elgb_ovr eoa ,
220: igs_en_elgb_ovr_uoo eou
221: WHERE eoa.elgb_override_id = eos.elgb_override_id
222: AND eoa.cal_type = cp_cal_type

Line 240: FROM igs_en_elgb_ovr_step eos,

236: cp_version_number IN NUMBER
237: ) IS
238: SELECT eou.step_override_limit,
239: step_override_type
240: FROM igs_en_elgb_ovr_step eos,
241: igs_en_elgb_ovr eoa ,
242: igs_en_elgb_ovr_uoo eou
243: WHERE eoa.elgb_override_id = eos.elgb_override_id
244: AND eoa.cal_type = cp_cal_type

Line 262: FROM igs_en_elgb_ovr_step eos,

258: cp_cal_seq_number IN NUMBER
259: ) IS
260: SELECT step_override_limit,
261: step_override_type
262: FROM igs_en_elgb_ovr_step eos,
263: igs_en_elgb_ovr eoa
264: WHERE eoa.elgb_override_id = eos.elgb_override_id
265: AND eoa.cal_type = cp_cal_type
266: AND eoa.ci_sequence_number = cp_cal_seq_number

Line 835: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

831: AND uoo.uoo_id = cp_uoo_id
832: AND uop.delete_flag ='N';
833:
834:
835: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
836: l_wlst_max_ovr BOOLEAN;
837: l_closed_section_ovr BOOLEAN;
838: l_waitlist_allowed igs_ps_unit_ofr_pat.waitlist_allowed%TYPE ;
839: l_waitlist_max igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE;

Line 1514: FROM igs_en_elgb_ovr_step eos,

1510: -- cursor to get the Approved credit points defined at Unit Section level for the given Calendar.
1511: --
1512: CURSOR cur_uoo_appr_cp (cp_cal_type VARCHAR2, cp_sequence_number NUMBER) IS
1513: SELECT eou.step_override_limit
1514: FROM igs_en_elgb_ovr_step eos,
1515: igs_en_elgb_ovr eo ,
1516: igs_en_elgb_ovr_uoo eou
1517: WHERE eos.step_override_type = 'VAR_CREDIT_APPROVAL' AND
1518: eos.elgb_override_id = eo.elgb_override_id AND

Line 1530: FROM igs_en_elgb_ovr_step eos,

1526: -- cursor to get the Approved credit points defined at Unit level.
1527: --
1528: CURSOR cur_unit_appr_cp(cp_unit_cd VARCHAR2, cp_version_number NUMBER, cp_cal_type VARCHAR2, cp_sequence_number NUMBER , cp_uoo_id NUMBER) IS
1529: SELECT eou.step_override_limit
1530: FROM igs_en_elgb_ovr_step eos,
1531: igs_en_elgb_ovr eo ,
1532: igs_en_elgb_ovr_uoo eou
1533: WHERE eos.step_override_type = 'VAR_CREDIT_APPROVAL' AND
1534: eos.ELGB_OVERRIDE_ID = eo.ELGB_OVERRIDE_ID AND

Line 1544: l_appr_cp igs_en_elgb_ovr_step.step_override_limit%TYPE := NULL;

1540: eo.CAL_TYPE = cp_cal_type AND
1541: eo.CI_SEQUENCE_NUMBER = cp_sequence_number ;
1542:
1543: l_unit_dtl cur_unit_dtl%ROWTYPE;
1544: l_appr_cp igs_en_elgb_ovr_step.step_override_limit%TYPE := NULL;
1545: l_load_dtl_of_uoo_id cur_load_dtl_of_uoo_id%ROWTYPE;
1546:
1547: BEGIN
1548:

Line 2371: v_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

2367: v_ap_required igs_ps_unit_ofr_opt.AUDIT_PERMISSION_IND%TYPE;
2368: v_staff_step_def_rec c_staff_step_def%ROWTYPE;
2369: v_stud_step_def_rec c_stud_step_def%ROWTYPE;
2370: v_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE;
2371: v_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2372: v_audit_perm_rec c_audit_perm_exists%ROWTYPE;
2373: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
2374:
2375: BEGIN