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

Line 40: cst_active CONSTANT IGS_CA_INST.cal_status%TYPE := 'ACTIVE';

36: WHERE su.person_id=ps.person_id
37: AND su.course_cd =ps.course_cd )
38: ORDER BY course_cd desc;
39:
40: cst_active CONSTANT IGS_CA_INST.cal_status%TYPE := 'ACTIVE';
41: CURSOR cur_load(cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
42: cp_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
43: SELECT cv.load_cal_type ,
44: cv.load_ci_sequence_number

Line 41: CURSOR cur_load(cp_teach_cal_type igs_ca_inst.cal_type%TYPE,

37: AND su.course_cd =ps.course_cd )
38: ORDER BY course_cd desc;
39:
40: cst_active CONSTANT IGS_CA_INST.cal_status%TYPE := 'ACTIVE';
41: CURSOR cur_load(cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
42: cp_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
43: SELECT cv.load_cal_type ,
44: cv.load_ci_sequence_number
45: FROM igs_ca_teach_to_load_v cv,

Line 42: cp_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

38: ORDER BY course_cd desc;
39:
40: cst_active CONSTANT IGS_CA_INST.cal_status%TYPE := 'ACTIVE';
41: CURSOR cur_load(cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
42: cp_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
43: SELECT cv.load_cal_type ,
44: cv.load_ci_sequence_number
45: FROM igs_ca_teach_to_load_v cv,
46: IGS_CA_INST ci,

Line 46: IGS_CA_INST ci,

42: cp_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
43: SELECT cv.load_cal_type ,
44: cv.load_ci_sequence_number
45: FROM igs_ca_teach_to_load_v cv,
46: IGS_CA_INST ci,
47: IGS_CA_STAT cs
48: WHERE cv.teach_cal_type = cp_teach_cal_type
49: AND cv.teach_ci_sequence_number = cp_teach_ci_sequence_number
50: AND ci.cal_type = cv.load_cal_type

Line 83: l_term_cal igs_ca_inst.cal_type%TYPE;

79: p_rule_failed OUT NOCOPY VARCHAR2)
80: RETURN boolean IS
81:
82:
83: l_term_cal igs_ca_inst.cal_type%TYPE;
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 ;

Line 84: l_term_seq_number igs_ca_inst.sequence_number%TYPE;

80: RETURN boolean IS
81:
82:
83: l_term_cal igs_ca_inst.cal_type%TYPE;
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;

Line 185: l_term_cal igs_ca_inst.cal_type%TYPE;

181: p_uoo_id IN NUMBER DEFAULT NULL,
182: p_rule_failed OUT NOCOPY VARCHAR2)
183: RETURN boolean IS
184:
185: l_term_cal igs_ca_inst.cal_type%TYPE;
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 ;

Line 186: l_term_seq_number igs_ca_inst.sequence_number%TYPE;

182: p_rule_failed OUT NOCOPY VARCHAR2)
183: RETURN boolean IS
184:
185: l_term_cal igs_ca_inst.cal_type%TYPE;
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;

Line 283: l_term_cal igs_ca_inst.cal_type%TYPE;

279: p_uoo_id IN NUMBER DEFAULT NULL,
280: p_rule_failed OUT NOCOPY VARCHAR2)
281: RETURN boolean IS
282:
283: l_term_cal igs_ca_inst.cal_type%TYPE;
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 ;

Line 284: l_term_seq_number igs_ca_inst.sequence_number%TYPE;

280: p_rule_failed OUT NOCOPY VARCHAR2)
281: RETURN boolean IS
282:
283: l_term_cal igs_ca_inst.cal_type%TYPE;
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;