APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_CA_INST_ALL

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 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 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