APPS.IGF_SL_DL_CHG_ACK dependencies on IGF_SL_LOANS_ALL

Line 48: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,

44: p_loan_number igf_sl_loans.loan_number%TYPE,
45: p_status igf_sl_dl_chg_resp.status%TYPE);
46:
47: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
48: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
49: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
50: p_rec_present OUT NOCOPY VARCHAR2);
51:
52: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,

Line 366: CURSOR cur_get_fed_fund(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

362: AND status = 'N'
363: GROUP BY loan_number;
364:
365: -- Get the fed fund code for the loan number
366: CURSOR cur_get_fed_fund(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
367: SELECT fcat.fed_fund_code
368: FROM igf_sl_loans_all loan,
369: igf_aw_award_all awd,
370: igf_aw_fund_mast_all fmast,

Line 368: FROM igf_sl_loans_all loan,

364:
365: -- Get the fed fund code for the loan number
366: CURSOR cur_get_fed_fund(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
367: SELECT fcat.fed_fund_code
368: FROM igf_sl_loans_all loan,
369: igf_aw_award_all awd,
370: igf_aw_fund_mast_all fmast,
371: igf_aw_fund_cat_all fcat
372: WHERE

Line 381: CURSOR cur_get_loan_accp_amt(p_loan_number igf_sl_loans_all.loan_number%TYPE,

377:
378: --Added code as part of Bug :- 2383350 Loan Cancellation
379: --Check if the received file has the change code as LOAN_AMT_ACCEPTED
380: --for the particular Loan Number
381: CURSOR cur_get_loan_accp_amt(p_loan_number igf_sl_loans_all.loan_number%TYPE,
382: p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
383: p_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE
384: ) IS
385: SELECT resp.new_value

Line 397: l_loan_status igf_sl_loans_all.loan_status%TYPE;

393: AND chgfld.loan_catg =p_loan_catg;
394:
395:
396: l_loan_accp_amt igf_aw_award_all.accepted_amt%TYPE;
397: l_loan_status igf_sl_loans_all.loan_status%TYPE;
398: l_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE;
399: l_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
400:
401: BEGIN

Line 689: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,

685:
686: -- Update the IGF_SL_LOANS record, for the Loan-Number, for the New Change Status
687: -- If the Loan_number is not present in OFA, then return p_rec_present as 'N'
688: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
689: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
690: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
691: p_rec_present OUT NOCOPY VARCHAR2)
692: AS
693: /*************************************************************