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_GEN_015 dependencies on IGS_EN_ELGB_OVR

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 201: igs_en_elgb_ovr eoa

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
205: AND eoa.person_id = p_person_id

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 219: igs_en_elgb_ovr eoa ,

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
223: AND eoa.ci_sequence_number = cp_cal_seq_number

Line 220: igs_en_elgb_ovr_uoo eou

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
223: AND eoa.ci_sequence_number = cp_cal_seq_number
224: AND eoa.person_id = p_person_id

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 241: igs_en_elgb_ovr eoa ,

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
245: AND eoa.ci_sequence_number = cp_cal_seq_number

Line 242: igs_en_elgb_ovr_uoo eou

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
245: AND eoa.ci_sequence_number = cp_cal_seq_number
246: AND eoa.person_id = p_person_id

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 263: igs_en_elgb_ovr eoa

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
267: AND eoa.person_id = p_person_id

Line 270: FROM igs_en_elgb_ovr_uoo eou

266: AND eoa.ci_sequence_number = cp_cal_seq_number
267: AND eoa.person_id = p_person_id
268: AND eos.step_override_type = p_eligibility_step_type
269: AND NOT EXISTS ( SELECT 'X'
270: FROM igs_en_elgb_ovr_uoo eou
271: WHERE eos.elgb_ovr_step_id = eou.elgb_ovr_step_id );
272: --
273: -- Cursor to finds the Teaching Calendar for a Unit Section.
274: --

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 1515: igs_en_elgb_ovr eo ,

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
1519: eo.person_id = p_person_id AND

Line 1516: igs_en_elgb_ovr_uoo eou

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
1519: eo.person_id = p_person_id AND
1520: eo.cal_type = cp_cal_type 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 1531: igs_en_elgb_ovr eo ,

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
1535: eo.person_id = p_person_id AND

Line 1532: igs_en_elgb_ovr_uoo eou

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
1535: eo.person_id = p_person_id AND
1536: eou.unit_cd = cp_unit_cd 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 1994: -- to refer to igs_en_elgb_ovr_uoo as part of deny/warn behaviour build #2829272

1990: --Nishikant 01NOV2002 SEVIS Build. Enh Bug#2641905. notification flag was
1991: -- being fetched from cursor, now modified to get it by
1992: -- calling the function igs_ss_enr_details.get_notification.
1993: --svanukur 04-jun-03 changed the declaration of the variable l_step_override_limit
1994: -- to refer to igs_en_elgb_ovr_uoo as part of deny/warn behaviour build #2829272
1995: -- smaddali 8-mar-06 Modified for bug#5091847
1996: -------------------------------------------------------------------------------------
1997: CURSOR cur_chk_sp_allowed( p_uoo_id NUMBER) IS
1998: SELECT special_permission_ind, cal_type, ci_sequence_number

Line 2029: l_step_override_limit igs_en_elgb_ovr_uoo.step_override_limit%TYPE;

2025: cur_step_def_var_rec step_rec;
2026: l_step_def_query VARCHAR2(2000);
2027:
2028:
2029: l_step_override_limit igs_en_elgb_ovr_uoo.step_override_limit%TYPE;
2030: l_spl_perm_rec cur_sp_exists%ROWTYPE;
2031: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;
2032: l_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2033: l_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;

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