APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_SL_LOANS_ALL

Line 2820: PROCEDURE delete_context_records(p_loan_id igf_sl_loans_all.loan_id%TYPE,

2816: RAISE IMPORT_ERROR;
2817:
2818: END dl_batch_insert_row;
2819:
2820: PROCEDURE delete_context_records(p_loan_id igf_sl_loans_all.loan_id%TYPE,
2821: p_loan_num igf_sl_loans_all.loan_number%TYPE,
2822: p_rowid ROWID)
2823:
2824: AS

Line 2821: p_loan_num igf_sl_loans_all.loan_number%TYPE,

2817:
2818: END dl_batch_insert_row;
2819:
2820: PROCEDURE delete_context_records(p_loan_id igf_sl_loans_all.loan_id%TYPE,
2821: p_loan_num igf_sl_loans_all.loan_number%TYPE,
2822: p_rowid ROWID)
2823:
2824: AS
2825: /*

Line 3003: l_loan_num igf_sl_loans_all.loan_number%TYPE)

2999:
3000: PROCEDURE insert_context_records(l_interface c_interface%ROWTYPE,
3001: l_award_id igf_aw_award_all.award_id%TYPE,
3002: l_base_id NUMBER,
3003: l_loan_num igf_sl_loans_all.loan_number%TYPE)
3004: AS
3005: /*
3006: || Created By : rasahoo
3007: || Created On : 03-June-2003

Line 3141: lv_loan_id igf_sl_loans_all.loan_id%TYPE;

3137: l_chg_interface c_chg_interface%ROWTYPE;
3138: p_d_status BOOLEAN;
3139: p_d_status2 BOOLEAN;
3140: l_loan_disb VARCHAR2(80);
3141: lv_loan_id igf_sl_loans_all.loan_id%TYPE;
3142: lv_loan_num igf_sl_loans_all.loan_number%TYPE;
3143: lv_rowid ROWID;
3144: l_legacy_flag VARCHAR2(1);
3145: l_success_record_cnt NUMBER := 0;

Line 3142: lv_loan_num igf_sl_loans_all.loan_number%TYPE;

3138: p_d_status BOOLEAN;
3139: p_d_status2 BOOLEAN;
3140: l_loan_disb VARCHAR2(80);
3141: lv_loan_id igf_sl_loans_all.loan_id%TYPE;
3142: lv_loan_num igf_sl_loans_all.loan_number%TYPE;
3143: lv_rowid ROWID;
3144: l_legacy_flag VARCHAR2(1);
3145: l_success_record_cnt NUMBER := 0;
3146: l_total_record_cnt NUMBER := 0;

Line 3256: FROM igf_sl_loans_all

3252: rowid,
3253: loan_id ,
3254: loan_number,
3255: legacy_record_flag
3256: FROM igf_sl_loans_all
3257: WHERE award_id = cp_award_id;
3258:
3259: l_chk_loan_exist c_chk_loan_exist%ROWTYPE;
3260:

Line 3266: FROM igf_sl_loans_all

3262: IS
3263: SELECT
3264: rowid,
3265: award_id
3266: FROM igf_sl_loans_all
3267: WHERE loan_number = cp_loan_num ;
3268:
3269: l_chk_loan c_chk_loan%ROWTYPE;
3270: