APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_SL_LOANS

Line 119: ln_loan_id igf_sl_loans.loan_id%TYPE;

115:
116: IMPORT_ERROR EXCEPTION;
117: g_igf_sl_message_table igf_sl_message_table;
118: ln_origination_id NUMBER;
119: ln_loan_id igf_sl_loans.loan_id%TYPE;
120: ln_lor_resp_num NUMBER;
121: ln_dbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
122: lv_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
123: g_award_year VARCHAR2(3);

Line 1677: igf_sl_loans_pkg.insert_row (

1673: ln_rowid ROWID;
1674: BEGIN
1675: ln_rowid := NULL;
1676:
1677: igf_sl_loans_pkg.insert_row (
1678: x_mode => 'R',
1679: x_rowid => ln_rowid,
1680: x_loan_id => ln_loan_id,
1681: x_award_id => p_award_id,

Line 1933: FROM igf_sl_loans loans,

1929: lor.s_default_status,
1930: lor.p_default_status,
1931: lor.p_person_id,
1932: fabase.person_id student_id
1933: FROM igf_sl_loans loans,
1934: igf_sl_lor lor,
1935: igf_aw_award awd,
1936: igf_ap_fa_base_rec fabase
1937: WHERE fabase.base_id = awd.base_id

Line 2370: FROM igf_sl_loans loans,

2366: lor.s_default_status,
2367: lor.p_default_status,
2368: lor.p_person_id,
2369: fabase.person_id student_id
2370: FROM igf_sl_loans loans,
2371: igf_sl_lor lor,
2372: igf_aw_award awd,
2373: igf_ap_fa_base_rec fabase
2374: WHERE fabase.base_id = awd.base_id

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 2983: igf_sl_loans_pkg.delete_row(X_ROWID => p_rowid);

2979:
2980: END LOOP;
2981: IF p_rowid IS NOT NULL THEN
2982:
2983: igf_sl_loans_pkg.delete_row(X_ROWID => p_rowid);
2984:
2985: END IF;
2986: EXCEPTION
2987:

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: