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.

APPS.IGF_SL_CL_ORIG dependencies on IGF_SL_LOANS

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 208: p_loan_number igf_sl_loans.loan_number%TYPE,

204: CURSOR cur_loan_dtls(p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
205: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
206: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
208: p_loan_number igf_sl_loans.loan_number%TYPE,
209: p_loan_status igf_sl_loans.loan_status%TYPE,
210: p_active igf_sl_loans.active%TYPE,
211: p_relationship_cd igf_sl_lor_all.relationship_cd%TYPE,
212: p_base_id VARCHAR2,

Line 209: p_loan_status igf_sl_loans.loan_status%TYPE,

205: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
206: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
208: p_loan_number igf_sl_loans.loan_number%TYPE,
209: p_loan_status igf_sl_loans.loan_status%TYPE,
210: p_active igf_sl_loans.active%TYPE,
211: p_relationship_cd igf_sl_lor_all.relationship_cd%TYPE,
212: p_base_id VARCHAR2,
213: p_school_id VARCHAR2

Line 210: p_active igf_sl_loans.active%TYPE,

206: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
208: p_loan_number igf_sl_loans.loan_number%TYPE,
209: p_loan_status igf_sl_loans.loan_status%TYPE,
210: p_active igf_sl_loans.active%TYPE,
211: p_relationship_cd igf_sl_lor_all.relationship_cd%TYPE,
212: p_base_id VARCHAR2,
213: p_school_id VARCHAR2
214: ) IS

Line 338: FROM igf_sl_loans_all loans,

334: lor.override_grade_level_code,
335: recip.relationship_cd,
336: lor.b_alien_reg_num_txt, -- fa 161 - bug # 5006583
337: lor.esign_src_typ_cd
338: FROM igf_sl_loans_all loans,
339: igf_sl_lor_all lor,
340: igf_aw_award_all awd,
341: igf_aw_fund_mast_all fmast,
342: igf_aw_fund_cat_all fcat,

Line 372: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,

368: retcode OUT NOCOPY NUMBER,
369: p_award_year IN VARCHAR2,
370: p_base_id IN VARCHAR2,
371: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
372: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
373: p_org_id IN NUMBER,
374: p_media_type IN VARCHAR2,
375: p_recipient_id IN VARCHAR2,
376: p_school_id IN VARCHAR2,

Line 417: p_loan_status igf_sl_loans.loan_status%TYPE,

413:
414: -- To fetch the Distinct Combinations of Recipient Details
415:
416: CURSOR cur_recip_dts(
417: p_loan_status igf_sl_loans.loan_status%TYPE,
418: p_active igf_sl_loans.active%TYPE,
419: p_lookup_type igf_lookups_view.lookup_type%TYPE,
420: p_enabled_flag igf_lookups_view.enabled_flag%TYPE,
421: p_recipient_id VARCHAR2

Line 418: p_active igf_sl_loans.active%TYPE,

414: -- To fetch the Distinct Combinations of Recipient Details
415:
416: CURSOR cur_recip_dts(
417: p_loan_status igf_sl_loans.loan_status%TYPE,
418: p_active igf_sl_loans.active%TYPE,
419: p_lookup_type igf_lookups_view.lookup_type%TYPE,
420: p_enabled_flag igf_lookups_view.enabled_flag%TYPE,
421: p_recipient_id VARCHAR2
422: ) IS

Line 425: igf_sl_loans lar,

421: p_recipient_id VARCHAR2
422: ) IS
423: SELECT DISTINCT lor.relationship_cd
424: FROM igf_ap_fa_base_rec fabase,
425: igf_sl_loans lar,
426: igf_sl_lor lor,
427: igf_aw_award awd,
428: igf_aw_fund_mast fund,
429: igf_aw_fund_cat fcat,

Line 1003: CURSOR c_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

999: SELECT igf_sl_lor.*
1000: FROM igf_sl_lor
1001: WHERE origination_id = p_origination_id FOR UPDATE OF sch_cert_date NOWAIT;
1002:
1003: CURSOR c_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
1004: SELECT external_loan_id_txt
1005: FROM igf_sl_loans_all
1006: WHERE loan_id = cp_n_loan_id;
1007:

Line 1005: FROM igf_sl_loans_all

1001: WHERE origination_id = p_origination_id FOR UPDATE OF sch_cert_date NOWAIT;
1002:
1003: CURSOR c_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
1004: SELECT external_loan_id_txt
1005: FROM igf_sl_loans_all
1006: WHERE loan_id = cp_n_loan_id;
1007:
1008: l_v_ext_loan_id_txt igf_sl_loans_all.external_loan_id_txt%TYPE;
1009:

Line 1008: l_v_ext_loan_id_txt igf_sl_loans_all.external_loan_id_txt%TYPE;

1004: SELECT external_loan_id_txt
1005: FROM igf_sl_loans_all
1006: WHERE loan_id = cp_n_loan_id;
1007:
1008: l_v_ext_loan_id_txt igf_sl_loans_all.external_loan_id_txt%TYPE;
1009:
1010: BEGIN
1011:
1012: FOR tbh_rec in c_tbh_cur LOOP

Line 1202: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,

1198: PROCEDURE sub_cl_originate( errbuf OUT NOCOPY VARCHAR2,
1199: retcode OUT NOCOPY NUMBER,
1200: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
1201: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1202: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
1203: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
1204: p_org_id IN NUMBER,
1205: p_relationship_cd IN VARCHAR2,
1206: p_media_type IN VARCHAR2,

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 1405: igf_sl_loans_v loanv

1401: SELECT LPAD(SUM(NVL(fed_stafford_loan_debt,0) + NVL(fed_sls_debt,0) +
1402: NVL(heal_debt,0) + NVL(perkins_debt,0) +
1403: NVL(other_debt,0)),7,0) alt_loan_debt
1404: FROM igf_sl_alt_borw,
1405: igf_sl_loans_v loanv
1406: WHERE igf_sl_alt_borw.loan_id = loanv.loan_id
1407: AND loanv.student_id = loan_rec.student_id
1408: AND loanv.ci_cal_type <> loan_rec.ci_cal_type
1409: AND loanv.ci_sequence_number <> loan_rec.ci_sequence_number;

Line 1429: CURSOR c_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

1425: FROM igf_aw_awd_disb
1426: WHERE award_id = p_award_id;
1427:
1428:
1429: CURSOR c_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
1430: SELECT lor.*
1431: FROM igf_sl_lor_all lor
1432: WHERE loan_id = cp_n_loan_id;
1433:

Line 2857: SELECT igf_sl_loans.*

2853: -- Update the Loan Status to Sent and Loan Status Date to SYSDATE
2854: DECLARE
2855: lv_row_id ROWID;
2856: CURSOR c_tbh_cur IS
2857: SELECT igf_sl_loans.*
2858: FROM igf_sl_loans
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

Line 2858: FROM igf_sl_loans

2854: DECLARE
2855: lv_row_id ROWID;
2856: CURSOR c_tbh_cur IS
2857: SELECT igf_sl_loans.*
2858: FROM igf_sl_loans
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:

Line 2859: WHERE loan_id = loan_rec.loan_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;

2855: lv_row_id ROWID;
2856: CURSOR c_tbh_cur IS
2857: SELECT igf_sl_loans.*
2858: FROM igf_sl_loans
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

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;