APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_CA_INST

Line 8: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

4: --Added the last 6 parameters as per the FACCR001 DLD Disbursement Build Jul 2002
5: --Bug No:2145941 Disbursement Build Jul 2002
6:
7: PROCEDURE get_details (p_person_id IN igs_ad_appl_all.person_id%TYPE,
8: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
9: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
10: lv_oss_dtl_rec IN OUT NOCOPY oss_dtl_cur
11: )
12: --

Line 9: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

5: --Bug No:2145941 Disbursement Build Jul 2002
6:
7: PROCEDURE get_details (p_person_id IN igs_ad_appl_all.person_id%TYPE,
8: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
9: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
10: lv_oss_dtl_rec IN OUT NOCOPY oss_dtl_cur
11: )
12: --
13: -- this procedure which will be called from other packages / plds

Line 179: igs_ca_inst ci,

175: ci.cal_type enrl_load_cal_type,
176: ci.sequence_number enrl_load_seq_num ,
177: ci.alternate_code enrolled_term
178: FROM
179: igs_ca_inst ci,
180: igs_ca_type cty
181: WHERE cty.s_cal_cat = 'LOAD'
182: AND cty.cal_type = ci.cal_type
183: AND (ci.cal_type, ci.sequence_number)

Line 188: FROM igs_ca_inst_rel

184: IN
185: (
186: SELECT sup_cal_type,
187: sup_ci_sequence_number
188: FROM igs_ca_inst_rel
189: WHERE sub_cal_type = p_acad_cal_type
190: AND sub_ci_sequence_number = p_acad_seq_num
191: UNION
192: SELECT sub_cal_type,

Line 194: FROM igs_ca_inst_rel

190: AND sub_ci_sequence_number = p_acad_seq_num
191: UNION
192: SELECT sub_cal_type,
193: sub_ci_sequence_number
194: FROM igs_ca_inst_rel
195: WHERE sup_cal_type = p_acad_cal_type
196: AND sup_ci_sequence_number = p_acad_seq_num
197: )
198: AND

Line 206: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

202: enrl_dtl_rec enrl_dtl_cur%ROWTYPE;
203: lv_message VARCHAR2(1000);
204:
205: -- Variables to store acad cal details
206: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
207: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
208:
209: --
210: -- Cursor to get enrlloment details

Line 207: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

203: lv_message VARCHAR2(1000);
204:
205: -- Variables to store acad cal details
206: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
207: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
208:
209: --
210: -- Cursor to get enrlloment details
211: --

Line 319: FROM igs_ca_inst_rel,

315: CURSOR cur_fa_load_awd (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
316: IS
317: SELECT sub_cal_type,
318: sub_ci_sequence_number
319: FROM igs_ca_inst_rel,
320: igf_ap_fa_base_rec_all base
321: WHERE sup_cal_type = base.ci_cal_type
322: AND sup_ci_sequence_number = base.ci_sequence_number
323: AND base.base_id = p_base_id;

Line 326: CURSOR c_att_type(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS

322: AND sup_ci_sequence_number = base.ci_sequence_number
323: AND base.base_id = p_base_id;
324:
325: -- Cursor to get the attendance type for the maximum enrollment load
326: CURSOR c_att_type(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS
327: SELECT attendance_type FROM igs_en_atd_type_load
328: WHERE cal_type = l_cal_type
329: AND lower_enr_load_range = (SELECT MAX(lower_enr_load_range)
330: FROM igs_en_atd_type_load