APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_SL_LOANS

Line 94: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,

90:
91: PROCEDURE update_resp_edit(p_dlpnr_id igf_sl_dl_pnote_resp_all.dlpnr_id%TYPE,
92: p_status igf_sl_dl_pnote_resp_all.status%TYPE);
93:
94: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
95: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE);
96:
97:
98: PROCEDURE log_message(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

Line 98: PROCEDURE log_message(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

94: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
95: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE);
96:
97:
98: PROCEDURE log_message(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
99: BEGIN
100:
101: IF g_log_start_flag = FALSE THEN
102: fnd_file.put_line(fnd_file.log, '');

Line 494: FROM igf_sl_loans_v loans

490: -- To Check whether the Loan Exists in Financial Aid i.e exists in
491:
492: CURSOR cur_loans(p_loan_number igf_sl_dl_pnote_resp_all.loan_number%TYPE) IS
493: SELECT fed_fund_code, count(*) countcol
494: FROM igf_sl_loans_v loans
495: WHERE loan_number=p_loan_number
496: GROUP BY fed_fund_code;
497:
498: -- TO get loan_id from the particular loan_number

Line 500: CURSOR cur_loanid(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

496: GROUP BY fed_fund_code;
497:
498: -- TO get loan_id from the particular loan_number
499:
500: CURSOR cur_loanid(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
501: SELECT loan_id FROM
502: igf_sl_loans
503: WHERE trim(loan_number)=trim(p_loan_number);
504:

Line 502: igf_sl_loans

498: -- TO get loan_id from the particular loan_number
499:
500: CURSOR cur_loanid(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
501: SELECT loan_id FROM
502: igf_sl_loans
503: WHERE trim(loan_number)=trim(p_loan_number);
504:
505: -- To get the next sequence number
506: CURSOR c_seq_num IS

Line 635: WHERE loan_id = (SELECT loan_id FROM igf_sl_loans lar

631:
632: DECLARE
633: CURSOR c_tbh_cur IS
634: SELECT igf_sl_lor.* FROM igf_sl_lor
635: WHERE loan_id = (SELECT loan_id FROM igf_sl_loans lar
636: WHERE loan_number = resp_rec.loan_number)
637: FOR UPDATE NOWAIT ;
638: BEGIN
639:

Line 804: igf_sl_loans_v WHERE

800:
801: DECLARE
802: CURSOR cur_award(p_loan_number igf_sl_dl_pnote_resp_all.loan_number%TYPE) IS
803: SELECT NVL(loan_amt_offered,loan_amt_accepted) loan_amt FROM
804: igf_sl_loans_v WHERE
805: loan_number = TRIM(p_loan_number);
806:
807: lcur_award cur_award%ROWTYPE;
808: BEGIN

Line 919: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,

915: END LOOP;
916:
917: END update_resp_edit;
918:
919: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
920: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE)
921: AS
922: /***************************************************************
923: Created By : prchandr

Line 943: WHERE award_id = (SELECT award_id FROM igf_sl_loans

939: --Count the No.of Disbursements for the award id in Awards Disbursements Table
940: CURSOR cur_count_old_disb
941: IS
942: SELECT award_id, NVL(COUNT(disb_num),0) FROM igf_aw_awd_disb
943: WHERE award_id = (SELECT award_id FROM igf_sl_loans
944: WHERE loan_number = p_loan_number)
945: GROUP BY award_id;
946:
947: --Count the No.of Disbursements for the award id in Response8 Disbursements Table