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.

APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_SL_LOR

Line 17: -- TBH Impact change done in igf_sl_lor_pkg.update_row().

13: -- Who When What
14: ---------------------------------------------------------------------------------------
15: ---------------------------------------------------------------------------------------
16: -- akomurav 17-Apr-2006 Build FA161 and 162.
17: -- TBH Impact change done in igf_sl_lor_pkg.update_row().
18: ----------------------------------------------------------------------------------------
19:
20: -- svuppala 4-Nov-2004 #3416936 FA 134 TBH impacts for newly added columns
21: ---------------------------------------------------------------------------------------

Line 30: -- in igf_sl_lor_all table and obsoleting

26: -- veramach 29-Jan-2004 bug 3408092 added 2004-2005 in p_dl_version checks
27: -----------------------------------------------------------------------------------
28: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
29: -- a) Impact of adding the relationship_cd
30: -- in igf_sl_lor_all table and obsoleting
31: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
32: -- GUARANTOR_ID, DUNS_GUARNT_ID,
33: -- LENDER_ID, DUNS_LENDER_ID
34: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 41: -- chg_batch_id,appl_send_error_codes from igf_sl_lor

37: -----------------------------------------------------------------------------------------------------------------------------
38: -- veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
39: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
40: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
41: -- chg_batch_id,appl_send_error_codes from igf_sl_lor
42: -- Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
43: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
44: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
45: -- chg_batch_id from igf_sl_lor_loc

Line 45: -- chg_batch_id from igf_sl_lor_loc

41: -- chg_batch_id,appl_send_error_codes from igf_sl_lor
42: -- Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
43: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
44: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
45: -- chg_batch_id from igf_sl_lor_loc
46: ------------------------------------------------------------------------------------------------------------------------------
47: ---------------------------------------------------------------------------------
48: -- sjadhav 27-Mar-2003 Bug 2863960
49: -- Changed Disb Gross Amt to Disb Accepted Amt

Line 57: -- igf_sl_lor_pkg.update_row

53: ---------------------------------------------------------------------------------
54: -- masehgal 17-Feb-2002 # 2216956 FACR007
55: -- Added Elec_mpn_ind,
56: -- Borrow_sign_ind in
57: -- igf_sl_lor_pkg.update_row
58: -- and
59: -- igf_sl_cl_resp_r1
60: ---------------------------------------------------------------------------------
61: -- npalanis 11/jan/2002 The process Common Line Origination

Line 83: g_lor_loc_rec igf_sl_lor_loc%ROWTYPE;

79: -- table igf_aw_awd_disb_all.
80: ---------------------------------------------------------------------------------
81: --
82:
83: g_lor_loc_rec igf_sl_lor_loc%ROWTYPE;
84: FILE_NOT_LOADED EXCEPTION;
85: p_disb_title VARCHAR2(1000);
86: p_disb_under_line VARCHAR2(1000);
87:

Line 452: in igf_sl_lor_all table and obsoleting

448: Who When What
449: ------------------------------------------------------------------------------
450: bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
451: Impact of adding the relationship_cd
452: in igf_sl_lor_all table and obsoleting
453: BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
454: GUARANTOR_ID, DUNS_GUARNT_ID,
455: LENDER_ID, DUNS_LENDER_ID
456: LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 634: SELECT igf_sl_lor.* FROM igf_sl_lor

630:
631:
632: DECLARE
633: CURSOR c_tbh_cur IS
634: SELECT igf_sl_lor.* FROM igf_sl_lor
635: WHERE loan_id = (SELECT loan_id FROM igf_sl_loans lar
636: WHERE loan_number = resp_rec.loan_number)
637: FOR UPDATE NOWAIT ;
638: BEGIN

Line 666: igf_sl_lor_pkg.update_row (

662: tbh_rec.pnote_accept_amt := resp_rec.pnote_accept_amt;
663: tbh_rec.pnote_accept_date := TRUNC(sysdate);
664: tbh_rec.elec_mpn_ind := resp_rec.elec_mpn_ind;
665:
666: igf_sl_lor_pkg.update_row (
667: X_Mode => 'R',
668: x_rowid => tbh_rec.row_id,
669: x_origination_id => tbh_rec.origination_id,
670: x_loan_id => tbh_rec.loan_id,