APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_SL_LOR_LOC_ALL

Line 83: -- igf_sl_lor_loc_all table.

79: -- c) The DUNS_BORW_LENDER_ID
80: -- DUNS_GUARNT_ID
81: -- DUNS_LENDER_ID
82: -- DUNS_RECIP_ID columns are osboleted from the
83: -- igf_sl_lor_loc_all table.
84: ---------------------------------------------------------------------------------
85: -- veramach 23-SEP-2003 Bug 3104228:
86: -- Obsoleted lend_apprv_denied_code,lend_apprv_denied_date
87: -- ,cl_rec_status_last_update,cl_rec_status,mpn_confirm_code

Line 3338: FROM igf_sl_lor_loc_all

3334:
3335: CURSOR c_lor_loc(cp_orig_id NUMBER)
3336: IS
3337: SELECT rowid
3338: FROM igf_sl_lor_loc_all
3339: WHERE origination_id = cp_orig_id;
3340:
3341: l_lor_loc c_lor_loc%ROWTYPE;
3342:

Line 3563: -- igf_sl_lor_loc_all table.

3559: -- c) The DUNS_BORW_LENDER_ID
3560: -- DUNS_GUARNT_ID
3561: -- DUNS_LENDER_ID
3562: -- DUNS_RECIP_ID columns are osboleted from the
3563: -- igf_sl_lor_loc_all table.
3564: -- veramach 23-SEP-2003 Bug 3104228:
3565: -- 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
3566: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
3567: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,

Line 3706: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

3702: lv_cl_loan_type VARCHAR2(2);
3703: lv_s_citizenship_status VARCHAR2(30);
3704:
3705:
3706: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3707: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
3708: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
3709: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;

Line 3708: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

3704:
3705:
3706: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3707: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
3708: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
3709: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
3712: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;

Line 3709: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

3705:
3706: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3707: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
3708: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
3709: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
3712: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
3713: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

Line 4084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into IGF_SL_LOR_LOC_ALL');

4080: END IF;
4081:
4082:
4083: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into IGF_SL_LOR_LOC_ALL');
4085: END IF;
4086:
4087: loc_rowid := NULL;
4088:

Line 4291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','After insert into IGF_SL_LOR_LOC_ALL');

4287: x_esign_src_typ_cd => p_interface.esign_src_typ_cd
4288: );
4289:
4290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','After insert into IGF_SL_LOR_LOC_ALL');
4292: END IF;
4293:
4294: IF ( p_fed_fund in ('ALT','FLP','GPLUSFL') ) AND (NVL(p_interface.b_stu_indicator_flag,'X') <> 'Y') THEN
4295: l_b_last_name := parent_dtl_rec.p_last_name;