APPS.IGF_SL_DL_CHG_ACK dependencies on IGF_SL_LOR

Line 24: -- igf_sl_lor_loc_all table.

20: -- The DUNS_BORW_LENDER_ID,
21: -- DUNS_GUARNT_ID,
22: -- DUNS_LENDER_ID,
23: -- DUNS_RECIP_ID columns are osboleted from the
24: -- igf_sl_lor_loc_all table.
25: ---------------------------------------------------------------------------
26: gmuralid 03-07-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
27: Added legacy record flag as parameter to
28: igf_sl_loans_pkg

Line 34: g_lor_loc_rec igf_sl_lor_loc%ROWTYPE;

30: vvutukur 21-Feb-2003 Enh#2758823.FA117 Build. Modified procedure dl_load_data.
31: ***************************************************************/
32:
33:
34: g_lor_loc_rec igf_sl_lor_loc%ROWTYPE;
35: g_dl_version igf_lookups_view.lookup_code%TYPE;
36:
37: FILE_NOT_LOADED exception;
38: FILE_ALREADY_LOADED exception;

Line 52: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,

48: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
49: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
50: p_rec_present OUT NOCOPY VARCHAR2);
51:
52: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,
53: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE);
54:
55:
56:

Line 774: -- Update the IGF_SL_LOR_LOC record for the New Loan Change Status, for the passed Loan-Number

770: END upd_loan_record;
771:
772:
773:
774: -- Update the IGF_SL_LOR_LOC record for the New Loan Change Status, for the passed Loan-Number
775: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,
776: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE)
777: AS
778: /*************************************************************

Line 775: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,

771:
772:
773:
774: -- Update the IGF_SL_LOR_LOC record for the New Loan Change Status, for the passed Loan-Number
775: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,
776: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE)
777: AS
778: /*************************************************************
779: Created By : venagara

Line 787: -- in igf_sl_lor_loc_pkg.update_row()

783: Change History
784: Who When What
785: -------------------------------------------------------------------------
786: -- bvisvana 10-Apr-2006 Build FA 161. TBH Impact change
787: -- in igf_sl_lor_loc_pkg.update_row()
788: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
789: -- The DUNS_BORW_LENDER_ID,
790: -- DUNS_GUARNT_ID,
791: -- DUNS_LENDER_ID,

Line 793: -- igf_sl_lor_loc_all table.

789: -- The DUNS_BORW_LENDER_ID,
790: -- DUNS_GUARNT_ID,
791: -- DUNS_LENDER_ID,
792: -- DUNS_RECIP_ID columns are osboleted from the
793: -- igf_sl_lor_loc_all table.
794: ---------------------------------------------------------------------------
795: (reverse chronological order - newest change first)
796: ***************************************************************/
797: CURSOR c_tbh_cur IS

Line 798: SELECT igf_sl_lor_loc.* FROM igf_sl_lor_loc

794: ---------------------------------------------------------------------------
795: (reverse chronological order - newest change first)
796: ***************************************************************/
797: CURSOR c_tbh_cur IS
798: SELECT igf_sl_lor_loc.* FROM igf_sl_lor_loc
799: WHERE loan_id = p_loan_id;
800: BEGIN
801:
802: FOR tbh_rec in c_tbh_cur LOOP

Line 807: igf_sl_lor_loc_pkg.update_row (

803:
804: tbh_rec.loan_chg_status := p_loan_chg_status;
805: tbh_rec.loan_chg_status_date := TRUNC(SYSDATE);
806:
807: igf_sl_lor_loc_pkg.update_row (
808: X_Mode => 'R',
809: x_rowid => tbh_rec.row_id,
810: x_loan_id => tbh_rec.loan_id,
811: x_origination_id => tbh_rec.origination_id,