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.

[Home] [Help]

APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_EN_ELGB_OVR_STEP

Line 1034: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

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 ;
1036: l_ss_enrol_rec cur_ss_enrol_ind%ROWTYPE ;
1037:
1038: l_message VARCHAR2(30);

Line 1150: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

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;
1152: l_message VARCHAR2(30);
1153: l_message_icon VARCHAR2(1);
1154: l_rule_text VARCHAR2(1000);

Line 1308: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

1304: l_location_rec c_location%ROWTYPE;
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);

Line 1450: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

1446: WHERE coo_id = p_coo_id;
1447:
1448:
1449: --
1450: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
1451: l_unit_class_rec cur_unit_class%ROWTYPE ;
1452: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;
1453: l_forced_att_mode igs_ps_ofr_opt.attendance_mode%TYPE;
1454: l_message VARCHAR2(30);

Line 1712: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

1708: AND uv.version_number = p_unit_version
1709: AND p_uoo_id IS NULL;
1710:
1711: rec_cur_unit_details cur_unit_details%ROWTYPE;
1712: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
1713: l_number_of_repeats NUMBER := 0 ;
1714: l_include_in_advanced_standing igs_en_rep_process.include_adv_standing_units%TYPE := 'N';
1715: l_repeat_allowed igs_ps_unit_ver.repeatable_ind%TYPE ;
1716: l_max_repeats NUMBER;

Line 2080: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

2076: AND version_number = cp_version_number;
2077:
2078: --
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 ;

Line 2556: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

2552: );
2553:
2554: --
2555: rec_cur_usec_occurs_new cur_usec_occurs_new%ROWTYPE;
2556: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2557: d_new_start_time DATE;
2558: d_new_end_time DATE;
2559: d_existing_start_time DATE;
2560: d_existing_end_time DATE;

Line 2771: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

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;
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;

Line 2943: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

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;
2945: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
2946: l_message VARCHAR2(30);
2947: l_message_icon VARCHAR2(1);

Line 3114: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

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;
3116: l_unit_dtls_rec cur_usec_dtl%ROWTYPE;
3117: l_message VARCHAR2(30);
3118: l_message_icon VARCHAR2(1);

Line 3253: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

3249: uoo_id =p_uoo_id AND
3250: request_type = 'SPL_PERM' AND
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: --

Line 3432: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%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);
3435: l_unreserved_seats NUMBER;
3436:

Line 4257: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

4253: -- p_load_cal_type and p_load_sequence_number . The corresponding named rule has also been
4254: -- modified . Bug # 2338013.
4255: -------------------------------------------------------------------------------------
4256:
4257: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
4258: l_message VARCHAR2(30);
4259: --
4260: -- begin of the function eval_coreq
4261: --

Line 4386: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

4382:
4383: --
4384: l_cal_type_rec cur_cal_type_seq_num%ROWTYPE;
4385: rec_cur_intermission_details cur_intermission_details%ROWTYPE;
4386: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
4387: l_message VARCHAR2(30);
4388: l_return_value VARCHAR2(30) := 'true';
4389: l_rule_text VARCHAR2(1000);
4390: l_message_icon VARCHAR2(1);

Line 4560: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

4556: WHERE person_id = cp_person_id;
4557: --
4558: l_cal_type_rec cur_cal_type_seq_num%ROWTYPE;
4559: rec_cur_visa_details cur_visa_details%ROWTYPE;
4560: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
4561: l_message VARCHAR2(30);
4562: l_rule_text VARCHAR2(1000);
4563: l_message_icon VARCHAR2(1);
4564: --

Line 4708: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

4704: -- Local variables
4705: l_dummy VARCHAR2(1);
4706: l_audit_allowed VARCHAR2(1);
4707: l_au_perm_req VARCHAR2(1);
4708: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
4709: BEGIN
4710:
4711: -- Check whether the Audit is allowed in the given unit section
4712: -- If audit is not allowed return error message.

Line 4826: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

4822: load_ci_sequence_number = p_load_sequence_number);
4823:
4824: -- Local variables
4825: l_audit_count NUMBER;
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