[Home] [Help]
54: ERRBUF OUT NOCOPY VARCHAR2,
55: RETCODE OUT NOCOPY NUMBER,
56: p_award_year IN VARCHAR2,
57: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
58: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
59: p_loan_number IN igf_sl_loans_v.loan_number%TYPE,
60: p_org_id IN NUMBER
61: )AS
62: /***************************************************************
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE
104: ) IS
105: SELECT lor.loan_id
209:
210: SKIP_LOAN_RECORD EXCEPTION;
211:
212: --Internal Procedure to display LOG Message
213: PROCEDURE log_message(p_stud_id igf_ap_fa_base_rec_all.person_id%TYPE,p_ln_number igf_sl_loans_all.loan_number%TYPE) IS
214: /***************************************************************
215: Created By : mesriniv
216: Date Created By : 2002/06/25
217: Purpose :