APPS.IGS_EN_VAL_SCA dependencies on IGS_CA_TYPE

Line 227: cst_teaching CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'TEACHING';

223: -- * Warn if the Prpsd_commencement_dt is prior to passed census dates for
224: -- the admission academic period.
225: DECLARE
226: cst_ca CONSTANT VARCHAR2(10):='CA';
227: cst_teaching CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'TEACHING';
228: v_course_start_dt IGS_AD_PS_APPL_INST.prpsd_commencement_dt%TYPE;
229: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;
230: v_adm_ci_sequence_number IGS_AD_PS_APPL_INST_APLINST_V.adm_ci_sequence_number%TYPE;
231: CURSOR c_acaiv IS

Line 247: IGS_CA_TYPE cat,

243: SELECT daiv.alias_val,
244: daiv.cal_type,
245: daiv.ci_sequence_number
246: FROM IGS_CA_INST_REL cir,
247: IGS_CA_TYPE cat,
248: IGS_CA_DA_INST_V daiv,
249: IGS_RE_S_RES_CAL_CON srcc
250: WHERE cir.sub_cal_type = v_adm_cal_type AND
251: cir.sub_ci_sequence_number = v_adm_ci_sequence_number AND

Line 263: IGS_CA_TYPE cat,

259: v_ccds_exists VARCHAR2(1);
260: CURSOR c_cir_cat_daiv_sgcc IS
261: SELECT 'x'
262: FROM IGS_CA_INST_REL cir,
263: IGS_CA_TYPE cat,
264: IGS_CA_DA_INST_V daiv,
265: IGS_GE_S_GEN_CAL_CON sgcc
266: WHERE cir.sub_cal_type = v_adm_cal_type AND
267: cir.sub_ci_sequence_number = v_adm_ci_sequence_number AND

Line 419: IGS_CA_TYPE cat,

415: sua.cal_type
416: FROM IGS_EN_SU_ATTEMPT sua,
417: IGS_CA_INST_REL cir,
418: IGS_CA_INST ci,
419: IGS_CA_TYPE cat,
420: IGS_PS_UNIT_VER uv
421: WHERE sua.person_id = p_person_id AND
422: sua.course_cd = p_course_cd AND
423: sua.unit_cd = uv.unit_cd AND

Line 1497: IGS_CA_TYPE CT,

1493: CI.sequence_number,
1494: CI.start_dt
1495: FROM IGS_CA_INST_REL CIR,
1496: IGS_CA_INST CI,
1497: IGS_CA_TYPE CT,
1498: IGS_CA_STAT CS
1499: WHERE CT.closed_ind = 'N' AND
1500: CT.s_cal_cat = cst_load AND
1501: CS.s_cal_status = cst_active AND

Line 1513: igs_ca_type ct

1509: CURSOR c_is_cal_load_or_teach(cp_cal_type IGS_CA_INST.cal_type%TYPE,
1510: cp_seq_number IGS_CA_INST.sequence_number%TYPE) IS
1511: SELECT ct.s_cal_cat
1512: FROM igs_ca_inst ci,
1513: igs_ca_type ct
1514: WHERE ci.cal_type = ct.cal_type
1515: AND ct.closed_ind = 'N'
1516: AND ci.cal_type = cp_cal_type
1517: AND ci.sequence_number = cp_seq_number;

Line 1527: l_cal_category IGS_CA_TYPE.s_cal_cat%TYPE;

1523: WHERE teach_cal_type = cp_cal_type
1524: AND teach_ci_sequence_number = cp_seq_number
1525: ORDER BY load_start_dt;
1526:
1527: l_cal_category IGS_CA_TYPE.s_cal_cat%TYPE;
1528: l_load_cal_type IGS_CA_INST.cal_type%TYPE;
1529: l_load_seq_number IGS_CA_INST.sequence_number%TYPE;
1530:
1531: BEGIN