250: lv_complete BOOLEAN := TRUE;
251: lv_msg_name fnd_new_messages.message_name%TYPE;
252: lv_lookup_code igf_lookups_view.LOOKUP_CODE%TYPE;
253: lv_warning BOOLEAN := FALSE;
254: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
255: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
256: p_status_1 igf_sl_loans.loan_status%TYPE;
257: p_status_2 igf_sl_loans.loan_status%TYPE;
258: p_status_3 igf_sl_loans.loan_status%TYPE;
251: lv_msg_name fnd_new_messages.message_name%TYPE;
252: lv_lookup_code igf_lookups_view.LOOKUP_CODE%TYPE;
253: lv_warning BOOLEAN := FALSE;
254: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
255: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
256: p_status_1 igf_sl_loans.loan_status%TYPE;
257: p_status_2 igf_sl_loans.loan_status%TYPE;
258: p_status_3 igf_sl_loans.loan_status%TYPE;
259: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
269: -- ELSE, if "FORM", then we need to validate for "Ready to Send", "Not Ready", "Rejected"
270:
271:
272: CURSOR cur_lor_details_recs(
273: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
274: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
275: p_status_1 igf_sl_loans.loan_status%TYPE,
276: p_status_2 igf_sl_loans.loan_status%TYPE,
277: p_status_3 igf_sl_loans.loan_status%TYPE,
270:
271:
272: CURSOR cur_lor_details_recs(
273: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
274: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
275: p_status_1 igf_sl_loans.loan_status%TYPE,
276: p_status_2 igf_sl_loans.loan_status%TYPE,
277: p_status_3 igf_sl_loans.loan_status%TYPE,
278: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
332: FROM igf_sl_loans loans,
333: igf_sl_lor lor,
334: igf_aw_award awd,
335: igf_aw_fund_mast fmast,
336: igf_aw_fund_cat fcat,
337: igf_ap_fa_base_rec fabase,
338: igf_sl_cl_recipient recip
339: WHERE fabase.ci_cal_type = p_cal_type
340: AND fabase.ci_sequence_number = p_seq_number
593: END cl_alt_borr_cosig_validation;
594:
595: PROCEDURE loan_limit_validation (
596: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
597: p_fund_type IN igf_aw_fund_cat.fed_fund_code%TYPE,
598: p_award_id IN igf_aw_award_all.award_id%TYPE,
599: p_msg_name OUT NOCOPY fnd_new_messages.message_name%TYPE
600: )
601: IS