eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_SL_LOR

Line 1716: in igf_sl_lor_all table and obsoleting

1712: || Who When What
1713: -----------------------------------------------------------------------------------
1714: bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
1715: a) Impact of adding the relationship_cd
1716: in igf_sl_lor_all table and obsoleting
1717: BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
1718: GUARANTOR_ID, DUNS_GUARNT_ID,
1719: LENDER_ID, DUNS_LENDER_ID
1720: LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 1728: || chg_batch_id,appl_send_error_codes from igf_sl_lor

1724: || veramach 23-SEP-2003 Bug 3104228:
1725: || 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
1726: || cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
1727: || p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
1728: || chg_batch_id,appl_send_error_codes from igf_sl_lor
1729: || (reverse chronological order - newest change first)
1730: */
1731: ln_rowid ROWID;
1732: l_orig_status VARCHAR2(1);

Line 1740: igf_sl_lor_pkg.insert_row (

1736: l_orig_status := 'B';
1737: END IF;
1738:
1739: ln_rowid := NULL;
1740: igf_sl_lor_pkg.insert_row (
1741: x_mode => 'R',
1742: x_rowid => ln_rowid,
1743: X_origination_id => ln_origination_id,
1744: X_loan_id => ln_loan_id,

Line 1904: igf_sl_lor_loc_all table.

1900: The DUNS_BORW_LENDER_ID
1901: DUNS_GUARNT_ID
1902: DUNS_LENDER_ID
1903: DUNS_RECIP_ID columns are osboleted from the
1904: igf_sl_lor_loc_all table.
1905: -----------------------------------------------------------------------------------
1906: || veramach 23-SEP-2003 Bug 3104228:
1907: || 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
1908: || cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,

Line 1910: || chg_batch_id from igf_sl_lor _loc

1906: || veramach 23-SEP-2003 Bug 3104228:
1907: || 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
1908: || cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
1909: || p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
1910: || chg_batch_id from igf_sl_lor _loc
1911: || veramach 16-SEP-2003 FA 122 loan enhancements
1912: || 1. c_loan_dtls does not select borrower information from igf_sl_lor_dtls_v
1913: || 2. igf_sl_gen.get_person_details is now used to get borrower information
1914: || (reverse chronological order - newest change first)

Line 1912: || 1. c_loan_dtls does not select borrower information from igf_sl_lor_dtls_v

1908: || cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
1909: || p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
1910: || chg_batch_id from igf_sl_lor _loc
1911: || veramach 16-SEP-2003 FA 122 loan enhancements
1912: || 1. c_loan_dtls does not select borrower information from igf_sl_lor_dtls_v
1913: || 2. igf_sl_gen.get_person_details is now used to get borrower information
1914: || (reverse chronological order - newest change first)
1915: */
1916:

Line 1934: igf_sl_lor lor,

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
1938: AND loans.award_id = awd.award_id

Line 1963: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

1959:
1960: l_student_license cur_isir_depend_status%ROWTYPE;
1961:
1962: ln_row_id ROWID;
1963: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1964: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1965: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
1967: lv_s_citizenship_status VARCHAR2(30);

Line 1964: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

1960: l_student_license cur_isir_depend_status%ROWTYPE;
1961:
1962: ln_row_id ROWID;
1963: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1964: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1965: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
1967: lv_s_citizenship_status VARCHAR2(30);
1968: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;

Line 2008: igf_sl_lor_loc_pkg.insert_row (

2004: lv_s_legal_res_date := student_dtl_rec.p_legal_res_date;
2005: lv_s_legal_res_state := student_dtl_rec.p_state_of_legal_res;
2006: --Code added for bug 3603289 end
2007:
2008: igf_sl_lor_loc_pkg.insert_row (
2009: x_mode => 'R',
2010: x_rowid => ln_row_id,
2011: x_loan_id => ln_loan_id,
2012: x_origination_id => ln_origination_id,

Line 2350: || 1. c_loan_dtls does not select borrower information from igf_sl_lor_dtls_v

2346: || Purpose : Inserts legacy data into igf_sl_dl_pnote_p_p_all Table .
2347: || Change History :
2348: || Who When What
2349: || veramach 16-SEP-2003 FA 122 loan enhancements
2350: || 1. c_loan_dtls does not select borrower information from igf_sl_lor_dtls_v
2351: || 2. igf_sl_gen.get_person_details is now used to get borrower information
2352: || (reverse chronological order - newest change first)
2353: */
2354: CURSOR c_award_amt IS

Line 2371: igf_sl_lor lor,

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
2375: AND loans.award_id = awd.award_id

Line 2400: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

2396: l_student_license cur_isir_depend_status%ROWTYPE;
2397:
2398: ln_rowid ROWID;
2399: ln_pnpp_id NUMBER;
2400: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2401: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2402: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
2403: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
2404: lv_s_citizenship_status VARCHAR2(30);

Line 2401: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

2397:
2398: ln_rowid ROWID;
2399: ln_pnpp_id NUMBER;
2400: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2401: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2402: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
2403: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
2404: lv_s_citizenship_status VARCHAR2(30);
2405: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;

Line 2836: FROM igf_sl_lor_all

2832: */
2833: CURSOR c_lor(cp_loan_id NUMBER)
2834: IS
2835: SELECT rowid, origination_id
2836: FROM igf_sl_lor_all
2837: WHERE loan_id = cp_loan_id;
2838:
2839: l_lor c_lor%ROWTYPE;
2840:

Line 2860: FROM igf_sl_lor_loc_all

2856:
2857: CURSOR c_lor_loc(cp_orig_id NUMBER)
2858: IS
2859: SELECT rowid
2860: FROM igf_sl_lor_loc_all
2861: WHERE origination_id = cp_orig_id;
2862:
2863: l_lor_loc c_lor_loc%ROWTYPE;
2864:

Line 2932: igf_sl_lor_loc_pkg.delete_row(X_ROWID => l_lor_loc.rowid);

2928: END LOOP;
2929:
2930: FOR l_lor IN c_lor(p_loan_id) LOOP
2931: FOR l_lor_loc IN c_lor_loc(l_lor.origination_id) LOOP
2932: igf_sl_lor_loc_pkg.delete_row(X_ROWID => l_lor_loc.rowid);
2933: END LOOP;
2934: igf_sl_lor_pkg.delete_row(X_ROWID => l_lor.rowid);
2935: END LOOP;
2936:

Line 2934: igf_sl_lor_pkg.delete_row(X_ROWID => l_lor.rowid);

2930: FOR l_lor IN c_lor(p_loan_id) LOOP
2931: FOR l_lor_loc IN c_lor_loc(l_lor.origination_id) LOOP
2932: igf_sl_lor_loc_pkg.delete_row(X_ROWID => l_lor_loc.rowid);
2933: END LOOP;
2934: igf_sl_lor_pkg.delete_row(X_ROWID => l_lor.rowid);
2935: END LOOP;
2936:
2937: -- Delete all disbursements corresponding to this award_id.
2938: FOR l_disb_resp IN c_disb_resp(p_loan_id) LOOP