APPS.IGF_SL_CL_ORIG dependencies on IGF_SL_LOANS_PKG

Line 78: -- igf_sl_loans_pkg

74: ------------------------------------------------------------------------------------------------------------------------------
75: ---------------------------------------------------------------------------------
76: -- gmuralid 03-07-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
77: -- Added legacy record flag as parameter to
78: -- igf_sl_loans_pkg
79: ---------------------------------------------------------------------------------
80: -- sjadhav 30-Apr-2003 Bug 2922549.
81: -- Corrected condition to put Student SSN
82: -- Added code to strip zip code of special

Line 1243: agairola 15-Mar-2002 Modified the Update Row call of the IGF_SL_LOANS_PKG

1239: 2. Removed the cursors cur_ope_id and cur_school_id as we can use
1240: p_school_id passed in parameter and also sch_non_ed_branch.
1241: 3. Added new cursor cur_get_school_name to get the school name.
1242:
1243: agairola 15-Mar-2002 Modified the Update Row call of the IGF_SL_LOANS_PKG
1244: to include the Borrower Determination as part of Refunds
1245: DLD - 2144600
1246: mesriniv 05-APR-2001 Changed the occurrences of field fao_id
1247: to ope_id

Line 2863: -- Modified the Update Row call of the IGF_SL_LOANS_PKG, as part of Refunds DLD 2144600 for Borrower

2859: WHERE loan_id = loan_rec.loan_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;
2860: BEGIN
2861: FOR tbh_rec in c_tbh_cur LOOP
2862:
2863: -- Modified the Update Row call of the IGF_SL_LOANS_PKG, as part of Refunds DLD 2144600 for Borrower
2864: -- determination
2865:
2866: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2867: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_loans_pkg.update_row');

Line 2867: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_loans_pkg.update_row');

2863: -- Modified the Update Row call of the IGF_SL_LOANS_PKG, as part of Refunds DLD 2144600 for Borrower
2864: -- determination
2865:
2866: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2867: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_loans_pkg.update_row');
2868: END IF;
2869:
2870: igf_sl_loans_pkg.update_row (
2871: x_Mode => 'R',

Line 2870: igf_sl_loans_pkg.update_row (

2866: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2867: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Calling igf_sl_loans_pkg.update_row');
2868: END IF;
2869:
2870: igf_sl_loans_pkg.update_row (
2871: x_Mode => 'R',
2872: x_rowid => tbh_rec.row_id,
2873: x_loan_id => tbh_rec.loan_id,
2874: x_award_id => tbh_rec.award_id,

Line 2890: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'igf_sl_loans_pkg.update_row succeeded');

2886: x_legacy_record_flag => NULL,
2887: x_external_loan_id_txt => tbh_rec.external_loan_id_txt
2888: );
2889: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2890: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'igf_sl_loans_pkg.update_row succeeded');
2891: END IF;
2892:
2893: END LOOP;
2894: END;