[Home] [Help]
3:
4: PROCEDURE dl_originate(errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_award_year VARCHAR2,
7: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
8: p_loan_number igf_sl_loans_all.loan_number%TYPE,
9: p_org_id IN NUMBER,
10: school_type IN VARCHAR2,
11: p_school_code IN VARCHAR2)
123: -----------------------------------------------------------------------------------
124: --
125: lv_cal_type igs_ca_inst.cal_type%TYPE;
126: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE;
127: lv_dl_version igf_lookups_view.lookup_code%TYPE;
128: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
129: lv_batch_id igf_sl_dl_batch.batch_id%TYPE;
130: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
131:
220: fmast.ci_cal_type = lv_cal_type AND
221: fmast.ci_sequence_number = lv_cal_seq_num AND
222: loan.loan_number LIKE DECODE(p_loan_number, NULL, '%', p_loan_number) AND
223: fcat.fed_fund_code in
224: (SELECT lookup_code FROM igf_lookups_view
225: WHERE lookup_type = decode(p_dl_loan_catg,
226: 'DL_STAFFORD', 'IGF_SL_DL_STAFFORD',
227: 'DL_PLUS', 'IGF_SL_DL_PLUS') AND
228: enabled_flag = 'Y') AND
234: --have the same cost
235: --Bug 2332668
236:
237: CURSOR cur_get_parameters IS
238: SELECT meaning FROM igf_lookups_view
239: WHERE lookup_type='IGF_SL_DL_LOAN_CATG' AND lookup_code=p_dl_loan_catg AND enabled_flag = 'Y'
240:
241: UNION ALL
242:
239: WHERE lookup_type='IGF_SL_DL_LOAN_CATG' AND lookup_code=p_dl_loan_catg AND enabled_flag = 'Y'
240:
241: UNION ALL
242:
243: SELECT meaning FROM igf_lookups_view
244: WHERE lookup_type='IGF_GE_PARAMETERS' AND lookup_code IN ('AWARD_YEAR','LOAN_CATG','LOAN_ID','PARAMETER_PASS') AND enabled_flag = 'Y';
245:
246: --Cursor to get the alternate code for the calendar instance
247: --Bug 2332668