APPS.IGF_SL_DL_ORIG dependencies on IGF_SL_LOR_LOC

Line 33: -- TBH Impact change in igf_sl_lor_loc_pkg.insert_row()

29: -----------------------------------------------------------------------------------
30: -- Who When What
31: -----------------------------------------------------------------------------------
32: -- akomurav 17-Apr-2006 Build FA161 and 162
33: -- TBH Impact change in igf_sl_lor_loc_pkg.insert_row()
34: -- and igf_sl_lor_pkg.update_row().
35: -------------------------------------------------------------------------------------
36: -- museshad 20-Feb-2005 Bug 5045452 - SQL Repository Issue.
37: -- Modified the cursor c_loans for better performance

Line 75: -- igf_sl_lor_loc_all table.

71: -- b) Also the DUNS_BORW_LENDER_ID
72: -- DUNS_GUARNT_ID
73: -- DUNS_LENDER_ID
74: -- DUNS_RECIP_ID columns are osboleted from the
75: -- igf_sl_lor_loc_all table.
76: -----------------------------------------------------------------------------------
77: -- bkkumar 30-sep-2003 Bug 3104228 FA 122 Loans Enhancements
78: -- Changed the cursor c_tbh_cur
79: -- containing igf_sl_lor_dtls_v with simple

Line 91: -- chg_batch_id from igf_sl_lor_loc

87: -- chg_batch_id,appl_send_error_codes from igf_sl_lor
88: -- B) Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
89: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
90: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
91: -- chg_batch_id from igf_sl_lor_loc
92: --------------------------------------------------------------------------------------------------
93: -- gmuralid 03-07-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
94: -- Added legacy record flag as parameter to
95: -- igf_sl_loans_pkg

Line 434: -- Delete this loan record in IGF_SL_LOR_LOC

430: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
431:
432:
433:
434: -- Delete this loan record in IGF_SL_LOR_LOC
435: DECLARE
436: lv_row_id VARCHAR2(25);
437: CURSOR c_tbh_cur IS
438: SELECT row_id row_id FROM igf_sl_lor_loc

Line 438: SELECT row_id row_id FROM igf_sl_lor_loc

434: -- Delete this loan record in IGF_SL_LOR_LOC
435: DECLARE
436: lv_row_id VARCHAR2(25);
437: CURSOR c_tbh_cur IS
438: SELECT row_id row_id FROM igf_sl_lor_loc
439: WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_lor_loc.sch_cert_date NOWAIT;
440: BEGIN
441: FOR tbh_rec in c_tbh_cur LOOP
442: igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);

Line 439: WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_lor_loc.sch_cert_date NOWAIT;

435: DECLARE
436: lv_row_id VARCHAR2(25);
437: CURSOR c_tbh_cur IS
438: SELECT row_id row_id FROM igf_sl_lor_loc
439: WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_lor_loc.sch_cert_date NOWAIT;
440: BEGIN
441: FOR tbh_rec in c_tbh_cur LOOP
442: igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);
443: END LOOP;

Line 442: igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);

438: SELECT row_id row_id FROM igf_sl_lor_loc
439: WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_lor_loc.sch_cert_date NOWAIT;
440: BEGIN
441: FOR tbh_rec in c_tbh_cur LOOP
442: igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);
443: END LOOP;
444: END;
445:
446: -- Delete this loan record in IGF_SL_AWD_DISB_LOC.

Line 666: igf_sl_lor_loc_pkg.insert_row (

662: -- FA 122 Loan Enhancemnets inserted the obsolted fields with NULL
663: -- student details fetched from student_dtl_rec
664: -- parent details fetched from parent_dtl_rec
665:
666: igf_sl_lor_loc_pkg.insert_row (
667: X_Mode => 'R',
668: x_rowid => lv_row_id,
669: x_loan_id => tbh_rec.loan_id,
670: x_origination_id => tbh_rec.origination_id,