APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_AD_APPL

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 60: lv_ad_appl_row_id ROWID; -- Retains RowId for IGS_AD_APPL

56:
57:
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;

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

Line 241: FROM IGS_AD_APPL adm,

237: IS
238: SELECT adm.adm_cal_type, adm.adm_ci_sequence_number,adm.adm_appl_status, adm.appl_dt,adm.admission_cat, adm.
239: adm_fee_status,adm.spcl_grp_1, adm.spcl_grp_2, adm_st.s_adm_appl_status appl_status,
240: adm_ct.s_admission_process_type process_type, adm_ft.s_adm_fee_status fee_status
241: FROM IGS_AD_APPL adm,
242: IGS_AD_APPL_STAT adm_st,
243: IGS_AD_PRCS_CAT adm_ct,
244: IGS_AD_FEE_STAT adm_ft
245: WHERE adm.rowid = lv_ad_appl_row_id

Line 242: IGS_AD_APPL_STAT adm_st,

238: SELECT adm.adm_cal_type, adm.adm_ci_sequence_number,adm.adm_appl_status, adm.appl_dt,adm.admission_cat, adm.
239: adm_fee_status,adm.spcl_grp_1, adm.spcl_grp_2, adm_st.s_adm_appl_status appl_status,
240: adm_ct.s_admission_process_type process_type, adm_ft.s_adm_fee_status fee_status
241: FROM IGS_AD_APPL adm,
242: IGS_AD_APPL_STAT adm_st,
243: IGS_AD_PRCS_CAT adm_ct,
244: IGS_AD_FEE_STAT adm_ft
245: WHERE adm.rowid = lv_ad_appl_row_id
246: AND adm.adm_appl_status = adm_st.adm_appl_status

Line 384: -- the Selected Admission Application record [IGS_AD_APPL]

380:
381: --
382: -- Call igf_ap_oss_integr.gbefore call to IGFAP20B.pls admissions
383: -- set_adm_appl_details to retreive
384: -- the Selected Admission Application record [IGS_AD_APPL]
385: -- and the Selected Admission Program detail record [IGS_AD_PS_APPL_INST]
386: --
387:
388: BEGIN

Line 426: -- Get admission related fields (IGS_AD_APPL)

422: lv_atb := 'Y';
423: CLOSE check_atb_cur;
424: END IF;
425:
426: -- Get admission related fields (IGS_AD_APPL)
427:
428: OPEN adm_appl_cur(lv_ad_appl_row_id);
429: FETCH adm_appl_cur INTO adm_appl_rec;
430: CLOSE adm_appl_cur;