APPS.IGF_SL_GEN dependencies on IGF_AP_FA_BASE_REC_ALL

Line 119: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

115: -- override for any particular Organization Unit.
116: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
117: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
118: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
119: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
120: RETURN VARCHAR2;
121:
122: FUNCTION get_dl_file_type(p_dl_version igf_sl_dl_file_type.dl_version%TYPE,
123: p_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,

Line 157: PROCEDURE get_associated_org( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

153: p_end_date IN DATE,
154: p_message OUT NOCOPY VARCHAR2);
155:
156: /* Procedure for obtaining responsible org unit code associated with the student */
157: PROCEDURE get_associated_org( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
158: x_org_unit_cd OUT NOCOPY hz_parties.party_number%TYPE,
159: x_org_party_id OUT NOCOPY hz_parties.party_id%TYPE,
160: x_module OUT NOCOPY VARCHAR2,
161: x_return_status OUT NOCOPY VARCHAR2,

Line 165: PROCEDURE get_stu_fao_code( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_data OUT NOCOPY VARCHAR2);
163:
164: /* Procedure for obtaining school code configured at Org Unit of the Student's key program */
165: PROCEDURE get_stu_fao_code( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
166: p_office_type IN igs_lookups_view.lookup_code%TYPE,
167: x_office_cd OUT NOCOPY igs_or_org_alt_ids.org_alternate_id_type%TYPE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_data OUT NOCOPY VARCHAR2);

Line 190: (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

186:
187: PROCEDURE update_cl_chg_status(p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE);
188:
189: PROCEDURE get_stu_ant_fao_code
190: (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
191: p_office_type IN igs_lookups_view.lookup_code%TYPE,
192: x_office_cd OUT NOCOPY igs_or_org_alt_ids.org_alternate_id_type%TYPE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_data OUT NOCOPY VARCHAR2);