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_RU_VAL_UNIT_RULE dependencies on IGS_PS_USEC_RU

Line 12: CURSOR cur_usec_rule (cp_uoo_id igs_ps_usec_ru.uoo_id%TYPE ,

8: -- added new for enrollment processes dld bug#1832130
9: -- all thebelow declerations and cursors
10:
11: -- selects the rule number defined for a given unit section
12: CURSOR cur_usec_rule (cp_uoo_id igs_ps_usec_ru.uoo_id%TYPE ,
13: cp_rul_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE ) IS
14: SELECT s_rule_call_cd , rul_sequence_number
15: FROM igs_ps_usec_ru
16: WHERE uoo_id = cp_uoo_id

Line 13: cp_rul_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE ) IS

9: -- all thebelow declerations and cursors
10:
11: -- selects the rule number defined for a given unit section
12: CURSOR cur_usec_rule (cp_uoo_id igs_ps_usec_ru.uoo_id%TYPE ,
13: cp_rul_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE ) IS
14: SELECT s_rule_call_cd , rul_sequence_number
15: FROM igs_ps_usec_ru
16: WHERE uoo_id = cp_uoo_id
17: AND s_rule_call_cd = cp_rul_call_cd;

Line 15: FROM igs_ps_usec_ru

11: -- selects the rule number defined for a given unit section
12: CURSOR cur_usec_rule (cp_uoo_id igs_ps_usec_ru.uoo_id%TYPE ,
13: cp_rul_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE ) IS
14: SELECT s_rule_call_cd , rul_sequence_number
15: FROM igs_ps_usec_ru
16: WHERE uoo_id = cp_uoo_id
17: AND s_rule_call_cd = cp_rul_call_cd;
18:
19: --selects the rule number defined for the unit version

Line 88: l_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE DEFAULT NULL;

84: l_term_seq_number igs_ca_inst.sequence_number%TYPE;
85: v_return_val VARCHAR2(30);
86: l_step_override_limit IGS_EN_ELGB_OVR_UOO.step_override_limit%TYPE ;
87: --l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE ;
88: l_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE DEFAULT NULL;
89: l_rul_seq_number igs_ps_usec_ru.rul_sequence_number%TYPE DEFAULT NULL;
90:
91: BEGIN
92: --cursor to fetch the term calendar from the unit section teach calendar

Line 89: l_rul_seq_number igs_ps_usec_ru.rul_sequence_number%TYPE DEFAULT NULL;

85: v_return_val VARCHAR2(30);
86: l_step_override_limit IGS_EN_ELGB_OVR_UOO.step_override_limit%TYPE ;
87: --l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE ;
88: l_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE DEFAULT NULL;
89: l_rul_seq_number igs_ps_usec_ru.rul_sequence_number%TYPE DEFAULT NULL;
90:
91: BEGIN
92: --cursor to fetch the term calendar from the unit section teach calendar
93: --this cursor is ordered by the load cal start date to fetch the

Line 190: l_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE DEFAULT NULL;

186: l_term_seq_number igs_ca_inst.sequence_number%TYPE;
187: v_return_val VARCHAR2(30);
188: l_step_override_limit IGS_EN_ELGB_OVR_UOO.step_override_limit%TYPE ;
189: --l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE ;
190: l_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE DEFAULT NULL;
191: l_rul_seq_number igs_ps_usec_ru.rul_sequence_number%TYPE DEFAULT NULL;
192:
193: BEGIN
194:

Line 191: l_rul_seq_number igs_ps_usec_ru.rul_sequence_number%TYPE DEFAULT NULL;

187: v_return_val VARCHAR2(30);
188: l_step_override_limit IGS_EN_ELGB_OVR_UOO.step_override_limit%TYPE ;
189: --l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE ;
190: l_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE DEFAULT NULL;
191: l_rul_seq_number igs_ps_usec_ru.rul_sequence_number%TYPE DEFAULT NULL;
192:
193: BEGIN
194:
195: --cursor to fetch the term calendar from the unit section teach calendar

Line 288: l_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE DEFAULT NULL;

284: l_term_seq_number igs_ca_inst.sequence_number%TYPE;
285:
286: v_return_val VARCHAR2(30);
287: l_step_override_limit IGS_EN_ELGB_OVR_UOO.step_override_limit%TYPE ;
288: l_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE DEFAULT NULL;
289: l_rul_seq_number igs_ps_usec_ru.rul_sequence_number%TYPE DEFAULT NULL;
290:
291: BEGIN
292:

Line 289: l_rul_seq_number igs_ps_usec_ru.rul_sequence_number%TYPE DEFAULT NULL;

285:
286: v_return_val VARCHAR2(30);
287: l_step_override_limit IGS_EN_ELGB_OVR_UOO.step_override_limit%TYPE ;
288: l_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE DEFAULT NULL;
289: l_rul_seq_number igs_ps_usec_ru.rul_sequence_number%TYPE DEFAULT NULL;
290:
291: BEGIN
292:
293: --cursor to fetch the term calendar from the unit section teach calendar