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_VAL_BULKRULE dependencies on IGS_EN_CAL_CONF

Line 217: cst_s_control_num CONSTANT IGS_EN_CAL_CONF.s_control_num%TYPE := 1;

213: -------------------------------------------------------------------------------------------
214: AS
215: BEGIN
216: DECLARE
217: cst_s_control_num CONSTANT IGS_EN_CAL_CONF.s_control_num%TYPE := 1;
218: e_no_records_found EXCEPTION;
219: v_enrolled_rule_cutoff_dt IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE;
220: v_invalid_rule_cutoff_dt IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE;
221: v_message_name varchar2(30);

Line 219: v_enrolled_rule_cutoff_dt IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE;

215: BEGIN
216: DECLARE
217: cst_s_control_num CONSTANT IGS_EN_CAL_CONF.s_control_num%TYPE := 1;
218: e_no_records_found EXCEPTION;
219: v_enrolled_rule_cutoff_dt IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE;
220: v_invalid_rule_cutoff_dt IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE;
221: v_message_name varchar2(30);
222: CURSOR c_secc IS
223: SELECT secc.enrolled_rule_cutoff_dt_alias,

Line 220: v_invalid_rule_cutoff_dt IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE;

216: DECLARE
217: cst_s_control_num CONSTANT IGS_EN_CAL_CONF.s_control_num%TYPE := 1;
218: e_no_records_found EXCEPTION;
219: v_enrolled_rule_cutoff_dt IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE;
220: v_invalid_rule_cutoff_dt IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE;
221: v_message_name varchar2(30);
222: CURSOR c_secc IS
223: SELECT secc.enrolled_rule_cutoff_dt_alias,
224: secc.invalid_rule_cutoff_dt_alias

Line 225: FROM IGS_EN_CAL_CONF secc

221: v_message_name varchar2(30);
222: CURSOR c_secc IS
223: SELECT secc.enrolled_rule_cutoff_dt_alias,
224: secc.invalid_rule_cutoff_dt_alias
225: FROM IGS_EN_CAL_CONF secc
226: WHERE secc.s_control_num = cst_s_control_num;
227:
228: /* smaddali modified this procedure to add 4 new parameters and their use in code
229: --stutta 08-SEP-2004 Modified c_sua as part of performance tuning bug #3869677*/

Line 238: p_invalid_rule_cutoff_dt IN IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE,

234: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
235: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
236: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
237: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
238: p_invalid_rule_cutoff_dt IN IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE,
239: --added for enrollment processes dld by smaddali bug#1832130
240: p_cal_type IN IGS_CA_INST.cal_type%TYPE,
241: p_ci_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
242: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE ,

Line 755: p_enrolled_rule_cutoff_dt IN IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE,

751: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
752: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
753: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
754: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
755: p_enrolled_rule_cutoff_dt IN IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE,
756: --added for enrollment processes dld by smaddali bug#1832130
757: p_cal_type IN IGS_CA_INST.cal_type%TYPE ,
758: p_ci_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
759: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE )