APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_CA_INST

Line 26: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

22:
23: FUNCTION set_deny_warn (
24: p_person_id IN igs_en_su_attempt.person_id%TYPE,
25: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
26: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
27: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE
28: )
29: RETURN VARCHAR2 AS
30: -------------------------------------------------------------------------------------------

Line 27: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE

23: FUNCTION set_deny_warn (
24: p_person_id IN igs_en_su_attempt.person_id%TYPE,
25: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
26: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
27: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE
28: )
29: RETURN VARCHAR2 AS
30: -------------------------------------------------------------------------------------------
31: --Created by : Basanth Kumar D, Oracle IDC

Line 2761: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca

2757: -- cursor to get the unit details
2758: CURSOR c_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
2759: SELECT ofr.unit_cd, ofr.version_number, ofr.cal_type, ofr.ci_sequence_number,
2760: ofr.location_cd, ofr.unit_class, ca.start_dt, ca.end_dt
2761: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca
2762: WHERE ofr.uoo_id = cp_uoo_id
2763: AND ofr.cal_type = ca.cal_type
2764: AND ofr.ci_sequence_number = ca.sequence_number;
2765:

Line 3304: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca

3300: -- cursor to fetch the unit details
3301: CURSOR c_get_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3302: SELECT ofr.unit_cd, ofr.version_number, ofr.cal_type, ofr.ci_sequence_number,
3303: ofr.location_cd, ofr.unit_class, ca.start_dt, ca.end_dt
3304: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca
3305: WHERE ofr.uoo_id = cp_uoo_id
3306: AND ofr.cal_type = ca.cal_type
3307: AND ofr.ci_sequence_number = ca.sequence_number;
3308:

Line 3381: IGS_CA_INST ci,

3377: SELECT daiv.alias_val,
3378: ci.start_dt,
3379: ci.end_dt
3380: FROM IGS_CA_DA_INST_V daiv,
3381: IGS_CA_INST ci,
3382: IGS_GE_S_GEN_CAL_CON sgcc
3383: WHERE daiv.cal_type = p_cal_type AND
3384: daiv.ci_sequence_number = p_ci_sequence_number AND
3385: daiv.dt_alias = sgcc.census_dt_alias AND

Line 5188: l_alternate_code igs_ca_inst.alternate_code%TYPE;

5184:
5185: -------------------------------------------------------------------------------------------
5186:
5187: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
5188: l_alternate_code igs_ca_inst.alternate_code%TYPE;
5189: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
5190: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
5191: l_acad_start_dt DATE;
5192: l_acad_end_dt DATE;

Line 5189: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

5185: -------------------------------------------------------------------------------------------
5186:
5187: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
5188: l_alternate_code igs_ca_inst.alternate_code%TYPE;
5189: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
5190: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
5191: l_acad_start_dt DATE;
5192: l_acad_end_dt DATE;
5193: l_enr_cat igs_ps_type.enrolment_cat%TYPE;

Line 5190: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

5186:
5187: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
5188: l_alternate_code igs_ca_inst.alternate_code%TYPE;
5189: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
5190: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
5191: l_acad_start_dt DATE;
5192: l_acad_end_dt DATE;
5193: l_enr_cat igs_ps_type.enrolment_cat%TYPE;
5194: l_enr_cal_type igs_ca_inst.cal_type%TYPE;

Line 5194: l_enr_cal_type igs_ca_inst.cal_type%TYPE;

5190: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
5191: l_acad_start_dt DATE;
5192: l_acad_end_dt DATE;
5193: l_enr_cat igs_ps_type.enrolment_cat%TYPE;
5194: l_enr_cal_type igs_ca_inst.cal_type%TYPE;
5195: l_enr_ci_seq igs_ca_inst.sequence_number%TYPE;
5196: l_enr_categories VARCHAR2(255);
5197: l_enr_comm VARCHAR2(1000);
5198: l_enc_message_name VARCHAR2(2000);

Line 5195: l_enr_ci_seq igs_ca_inst.sequence_number%TYPE;

5191: l_acad_start_dt DATE;
5192: l_acad_end_dt DATE;
5193: l_enr_cat igs_ps_type.enrolment_cat%TYPE;
5194: l_enr_cal_type igs_ca_inst.cal_type%TYPE;
5195: l_enr_ci_seq igs_ca_inst.sequence_number%TYPE;
5196: l_enr_categories VARCHAR2(255);
5197: l_enr_comm VARCHAR2(1000);
5198: l_enc_message_name VARCHAR2(2000);
5199: l_app_short_name VARCHAR2(100);