[Home] [Help]
132: WHERE disb.document_id_txt = p_document_id_txt;
133:
134: CURSOR cur_sys_loans (p_loan_id NUMBER)
135: IS
136: SELECT loan.* FROM igf_sl_loans loan
137: WHERE loan.loan_id = p_loan_id;
138:
139: CURSOR cur_sys_disb (p_award_id NUMBER,p_disb_num NUMBER, p_disb_seq NUMBER)
140: IS
158: ELSIF sys_rec.loan_status = 'G' THEN
159: sys_rec.loan_status := 'S';
160: sys_rec.loan_status_date := TRUNC(SYSDATE);
161: END IF;
162: igf_sl_loans_pkg.update_row(x_rowid => sys_rec.row_id,
163: x_loan_id => sys_rec.loan_id,
164: x_award_id => sys_rec.award_id,
165: x_seq_num => sys_rec.seq_num,
166: x_loan_number => sys_rec.loan_number,
1135: FUNCTION get_loan_number(p_loan_id IN NUMBER)
1136: RETURN VARCHAR2 IS
1137: CURSOR cur_get_loan_number (p_loan_id NUMBER)
1138: IS
1139: SELECT loan_number FROM igf_sl_loans_all
1140: WHERE loan_id = p_loan_id;
1141:
1142: get_loan_number_rec cur_get_loan_number%ROWTYPE;
1143:
1232:
1233: CURSOR cur_get_loan_number (p_loan_id NUMBER)
1234: IS
1235: SELECT loan_number
1236: FROM igf_sl_loans_all
1237: WHERE loan_id = p_loan_id;
1238:
1239: get_loan_number_rec cur_get_loan_number%ROWTYPE;
1240:
1374: SELECT
1375: lor.loan_id
1376: FROM
1377: igf_sl_lor_all lor,
1378: igf_sl_loans_all loan,
1379: igf_aw_award_all awd,
1380: igf_aw_fund_mast_all fmast
1381: WHERE
1382: loan.award_id = awd.award_id AND
1397: SELECT
1398: lor.loan_id
1399: FROM
1400: igf_sl_lor_all lor,
1401: igf_sl_loans_all loan,
1402: igf_aw_award_all awd,
1403: igf_aw_fund_mast_all fmast
1404: WHERE
1405: loan.award_id = awd.award_id AND
1416: CURSOR cur_chk_loan (p_base_id NUMBER)
1417: IS
1418: SELECT loan.loan_id
1419: FROM
1420: igf_sl_loans_all loan,
1421: igf_aw_award_all awd
1422: WHERE
1423: awd.award_id = loan.award_id AND
1424: awd.base_id = p_base_id AND