APPS.IGS_EN_GEN_006 dependencies on IGS_GE_S_GEN_CAL_CON

Line 606: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;

602: v_instance_start_dt IGS_CA_INST.start_dt%TYPE;
603: v_instance_end_dt IGS_CA_INST.end_dt%TYPE;
604: v_intrmsn_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
605: v_intrmsn_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
606: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
607: v_course_status
608: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE DEFAULT NULL;
609: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
610:

Line 644: FROM IGS_GE_S_GEN_CAL_CON sgcc

640: ci.sequence_number = p_acad_ci_sequence_number;
641:
642: CURSOR c_s_gen_cal_conf IS
643: SELECT sgcc.census_dt_alias
644: FROM IGS_GE_S_GEN_CAL_CON sgcc
645: WHERE sgcc.s_control_num = 1;
646:
647: CURSOR c_ct_ci IS
648: SELECT ci.cal_type,

Line 798: gv_extra_detail := ' -no IGS_GE_S_GEN_CAL_CON record was found';

794: OPEN c_s_gen_cal_conf;
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;