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_REJ_WF dependencies on IGF_SL_LOR

Line 18: -- in igf_sl_lor_all table and obsoleting

14: --------------------------------------------------------------------------------------
15: -- svuppala 4-Nov-2004 #3416936 FA 134 TBH impacts for newly added columns
16: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
17: -- a) Impact of adding the relationship_cd
18: -- in igf_sl_lor_all table and obsoleting
19: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
20: -- GUARANTOR_ID, DUNS_GUARNT_ID,
21: -- LENDER_ID, DUNS_LENDER_ID
22: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 29: chg_batch_id,appl_send_error_codes from igf_sl_lor

25: --------------------------------------------------------------------------------------
26: veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
27: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
28: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
29: chg_batch_id,appl_send_error_codes from igf_sl_lor
30: (reverse chronological order - newest change first)
31: ***************************************************************/
32:
33: PROCEDURE send_notif(

Line 258: -- in igf_sl_lor_all table and obsoleting

254: Who When What
255: -------------------------------------------------------------------------------------
256: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
257: -- a) Impact of adding the relationship_cd
258: -- in igf_sl_lor_all table and obsoleting
259: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
260: -- GUARANTOR_ID, DUNS_GUARNT_ID,
261: -- LENDER_ID, DUNS_LENDER_ID
262: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 269: chg_batch_id,appl_send_error_codes from igf_sl_lor

265: --------------------------------------------------------------------------------------
266: veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
267: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
268: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
269: chg_batch_id,appl_send_error_codes from igf_sl_lor
270: (reverse chronological order - newest change first)
271: ***************************************************************/
272:
273: l_loanid igf_sl_loans_v.loan_id%TYPE;

Line 274: l_tbh_rec igf_sl_lor%ROWTYPE;

270: (reverse chronological order - newest change first)
271: ***************************************************************/
272:
273: l_loanid igf_sl_loans_v.loan_id%TYPE;
274: l_tbh_rec igf_sl_lor%ROWTYPE;
275:
276: CURSOR c_tbh_cur IS
277: SELECT * FROM igf_sl_lor
278: WHERE loan_id = l_loanid

Line 277: SELECT * FROM igf_sl_lor

273: l_loanid igf_sl_loans_v.loan_id%TYPE;
274: l_tbh_rec igf_sl_lor%ROWTYPE;
275:
276: CURSOR c_tbh_cur IS
277: SELECT * FROM igf_sl_lor
278: WHERE loan_id = l_loanid
279: AND pnote_status = 'R'
280: FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
281:

Line 280: FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;

276: CURSOR c_tbh_cur IS
277: SELECT * FROM igf_sl_lor
278: WHERE loan_id = l_loanid
279: AND pnote_status = 'R'
280: FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
281:
282:
283: BEGIN
284:

Line 301: igf_sl_lor_pkg.update_row( x_mode => 'R',

297: END IF;
298: CLOSE c_tbh_cur;
299:
300:
301: igf_sl_lor_pkg.update_row( x_mode => 'R',
302: x_rowid => l_tbh_rec.row_id,
303: x_origination_id => l_tbh_rec.origination_id,
304: x_loan_id => l_tbh_rec.loan_id,
305: x_sch_cert_date => l_tbh_rec.sch_cert_date,

Line 460: -- in igf_sl_lor_all table and obsoleting

456: Who When What
457: -------------------------------------------------------------------------------------
458: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
459: -- a) Impact of adding the relationship_cd
460: -- in igf_sl_lor_all table and obsoleting
461: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
462: -- GUARANTOR_ID, DUNS_GUARNT_ID,
463: -- LENDER_ID, DUNS_LENDER_ID
464: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 471: chg_batch_id,appl_send_error_codes from igf_sl_lor

467: --------------------------------------------------------------------------------------
468: veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
469: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
470: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
471: chg_batch_id,appl_send_error_codes from igf_sl_lor
472: (reverse chronological order - newest change first)
473: ***************************************************************/
474: l_loanid igf_sl_loans_v.loan_id%TYPE;
475: l_tbh_rec igf_sl_lor%ROWTYPE;

Line 475: l_tbh_rec igf_sl_lor%ROWTYPE;

471: chg_batch_id,appl_send_error_codes from igf_sl_lor
472: (reverse chronological order - newest change first)
473: ***************************************************************/
474: l_loanid igf_sl_loans_v.loan_id%TYPE;
475: l_tbh_rec igf_sl_lor%ROWTYPE;
476:
477: CURSOR c_tbh_cur IS
478: SELECT * FROM igf_sl_lor
479: WHERE loan_id = l_loanid

Line 478: SELECT * FROM igf_sl_lor

474: l_loanid igf_sl_loans_v.loan_id%TYPE;
475: l_tbh_rec igf_sl_lor%ROWTYPE;
476:
477: CURSOR c_tbh_cur IS
478: SELECT * FROM igf_sl_lor
479: WHERE loan_id = l_loanid
480: AND pnote_status = 'R'
481: FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
482:

Line 481: FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;

477: CURSOR c_tbh_cur IS
478: SELECT * FROM igf_sl_lor
479: WHERE loan_id = l_loanid
480: AND pnote_status = 'R'
481: FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
482:
483:
484: BEGIN
485:

Line 501: igf_sl_lor_pkg.update_row(

497: RAISE NO_DATA_FOUND;
498: END IF;
499: CLOSE c_tbh_cur;
500:
501: igf_sl_lor_pkg.update_row(
502: x_mode => 'R',
503: x_rowid => l_tbh_rec.row_id,
504: x_origination_id => l_tbh_rec.origination_id,
505: x_loan_id => l_tbh_rec.loan_id,