APPS.IGS_EN_GEN_006 dependencies on IGS_EN_CAL_CONF

Line 258: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;

254: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
255: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
256: v_daiv_rec_found BOOLEAN;
257: v_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE;
258: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
259: v_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE;
260: v_period_load IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
261: v_period_credit_points NUMBER;
262: v_current_load_cal_type IGS_CA_INST.cal_type%TYPE;

Line 275: FROM IGS_EN_CAL_CONF SECC

271: WHERE SCA.person_id = cp_person_id AND
272: SCA.course_cd = cp_course_cd;
273: CURSOR c_s_enr_cal_conf IS
274: SELECT SECC.load_effect_dt_alias
275: FROM IGS_EN_CAL_CONF SECC
276: WHERE SECC.s_control_num = 1;
277: CURSOR c_cal_instance(
278: cp_cal_type IGS_CA_INST.cal_type%TYPE,
279: cp_effective_dt IGS_CA_INST.start_dt%TYPE)IS

Line 314: cp_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE) IS

310: ORDER BY CI.start_dt asc;
311: CURSOR c_dai_v(
312: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
313: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
314: cp_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE) IS
315: SELECT DAIV.alias_val
316: FROM IGS_CA_DA_INST_V DAIV
317: WHERE DAIV.cal_type = cp_cal_type AND
318: DAIV.ci_sequence_number = cp_ci_sequence_number AND

Line 435: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;

431: p_effective_date IN DATE )
432: RETURN boolean AS
433: BEGIN
434: DECLARE
435: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;
436: v_cal_type IGS_CA_INST.cal_type%TYPE;
437: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
438: v_sua_ci_rec_found BOOLEAN;
439: v_dai_rec_found BOOLEAN;

Line 442: FROM IGS_EN_CAL_CONF

438: v_sua_ci_rec_found BOOLEAN;
439: v_dai_rec_found BOOLEAN;
440: CURSOR c_s_enr_cal_conf IS
441: SELECT commence_cutoff_dt_alias
442: FROM IGS_EN_CAL_CONF
443: WHERE s_control_num = 1;
444: CURSOR c_sua_ci(
445: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
446: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS

Line 558: || pradhakr 29-Jan-2003 Added a message IGS_EN_CAL_CONF_NOT_SET.

554: || Who When What
555: || pkpatel 09-SEP-2001 Bug no.1960126 :For Academic Record Maintenance
556: || Modified the defination of Cursor 'c_sci' to include
557: || the logic for INtermission Type Approval
558: || pradhakr 29-Jan-2003 Added a message IGS_EN_CAL_CONF_NOT_SET.
559: || Changes wrt bug# 2675905
560: || (reverse chronological order - newest change first)
561: */
562: gv_other_detail VARCHAR2(255);

Line 787: p_message_name := 'IGS_EN_CAL_CONF_NOT_SET';

783:
784: IF c_ci%NOTFOUND THEN
785: CLOSE c_ci;
786: gv_extra_detail := ' -no IGS_CA_INST record was found';
787: p_message_name := 'IGS_EN_CAL_CONF_NOT_SET';
788: RETURN FALSE;
789: END IF;
790: CLOSE c_ci;
791:

Line 799: p_message_name := 'IGS_EN_CAL_CONF_NOT_SET';

795: FETCH c_s_gen_cal_conf INTO v_census_dt_alias;
796: IF c_s_gen_cal_conf%NOTFOUND THEN
797: CLOSE c_s_gen_cal_conf;
798: gv_extra_detail := ' -no IGS_GE_S_GEN_CAL_CON record was found';
799: p_message_name := 'IGS_EN_CAL_CONF_NOT_SET';
800: RETURN FALSE;
801: END IF;
802: CLOSE c_s_gen_cal_conf;
803:

Line 1282: FROM IGS_EN_CAL_CONF secc,

1278: SELECT 'x'
1279: FROM sys.dual
1280: WHERE EXISTS (
1281: SELECT 'x'
1282: FROM IGS_EN_CAL_CONF secc,
1283: IGS_CA_DA_INST_V daiv
1284: WHERE secc.s_control_num = 1 AND
1285: secc.enr_form_due_dt_alias IS NOT NULL AND
1286: daiv.cal_type = cp_cal_type AND