DBA Data[Home] [Help]

APPS.IGF_SL_LOANS_PKG dependencies on IGF_SL_CLCHSN_DTLS_PKG

Line 176: || igf_sl_clchsn_dtls_pkg.get_ufk_igf_sl_loans.

172: || Change History :
173: || Who When What
174: || (reverse chronological order - newest change first)
175: || smadathi 14-OCT-2004 Enh. Bug 3416936. Added call to
176: || igf_sl_clchsn_dtls_pkg.get_ufk_igf_sl_loans.
177: || agairola 15-Mar-2002 Added the code for the new column
178: || for the Borrower Determination
179: */
180: BEGIN

Line 192: igf_sl_clchsn_dtls_pkg.get_ufk_igf_sl_loans(x_loan_number => old_references.loan_number);

188: igf_sl_dl_pnote_s_p_pkg.get_fk_igf_sl_loans ( old_references.loan_id );
189:
190: igf_sl_lor_pkg.get_fk_igf_sl_loans ( old_references.loan_id );
191:
192: igf_sl_clchsn_dtls_pkg.get_ufk_igf_sl_loans(x_loan_number => old_references.loan_number);
193:
194: END check_child_existance;
195:
196:

Line 461: igf_sl_clchsn_dtls_pkg.update_row (

457: -- If either loan status or loan change status CHANGED to "Ready to Send"
458: -- then update all change change records in "Sent" status to "Ready to Send".Change records apply only for FFELP
459: IF (l_v_fed_fund_code IN ('FLS','FLU','FLP','ALT','GPLUSFL') AND g_v_called_from IN ('IGFSL005','UPDATE_MODE')) THEN
460: FOR rec_c_igf_sl_clchsn_dtls IN cur_loan_chg_records(new_references.award_id) LOOP
461: igf_sl_clchsn_dtls_pkg.update_row (
462: x_rowid => rec_c_igf_sl_clchsn_dtls.ROWID ,
463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,
465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,