APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_AD_APPL_ALL

Line 7: PROCEDURE get_details (p_person_id IN igs_ad_appl_all.person_id%TYPE,

3:
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: )

Line 62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;

58: -- These set of variables are returned from igf_ap_oss_integr.get_adm_appl_details()
59: -- [
60: lv_ad_appl_row_id ROWID; -- Retains RowId for IGS_AD_APPL
61: lv_ad_prog_row_id ROWID; -- Retains RowId for IGS_AD_PS_APPL_INST
62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;

Line 67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;

63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
68: lv_multiple VARCHAR2(10); -- Hold 'Y' / 'N'
69: -- ]
70:
71: -- These variables are needed to get enrol_credit_pt details