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_VALIDATION dependencies on IGF_SL_LOANS

Line 43: -- igf_sl_loans_pkg

39: -- This is derived from igf_sl_gen.get_person_details
40: ----------------------------------------------------------------------------------
41: -- gmuralid 03-07-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
42: -- Added legacy record flag as parameter to
43: -- igf_sl_loans_pkg
44: -----------------------------------------------------------------------------------
45: -- sjadhav 26-Mar-2003 Bug 2863960
46: -- Modified cursor cur_count_disb_amount to replace
47: -- disb gross amount with disb accepted amount

Line 82: g_loan_id igf_sl_Loans_all.loan_id%TYPE;

78: --
79: -----------------------------------------------------------------------------------
80: --
81: p_cl_version VARCHAR2(30);
82: g_loan_id igf_sl_Loans_all.loan_id%TYPE;
83: g_debug_runtime_level NUMBER;
84: g_update_mode_required BOOLEAN := FALSE;
85:
86: PROCEDURE log_to_fnd ( p_v_module IN VARCHAR2,

Line 104: p_loan_number igf_sl_loans.loan_number%TYPE,

100: END IF;
101: END log_to_fnd;
102:
103: FUNCTION check_for_reqd(
104: p_loan_number igf_sl_loans.loan_number%TYPE,
105: p_loan_catg igf_sl_reqd_fields.loan_type%TYPE,
106: p_field_name igf_sl_reqd_fields.field_name%TYPE,
107: p_field_value VARCHAR2,
108: p_prc_type_code igf_sl_reqd_fields.prc_type_code%TYPE

Line 177: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,

173:
174: FUNCTION cl_lar_validate(
175: p_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
176: p_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
177: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
178: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
179: p_call_mode IN VARCHAR2,
180: p_school_id IN VARCHAR2,
181: p_base_id IN VARCHAR2

Line 229: lv_loan_status igf_sl_loans_all.loan_status%TYPE;

225: mesriniv 05-APR-2001 Changed the occurrences of field fao_id
226: to ope_id
227: ***************************************************************/
228:
229: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
230: lv_s_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
231: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
232: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
233: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

Line 256: p_status_1 igf_sl_loans.loan_status%TYPE;

252: lv_lookup_code igf_lookups_view.LOOKUP_CODE%TYPE;
253: lv_warning BOOLEAN := FALSE;
254: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
255: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
256: p_status_1 igf_sl_loans.loan_status%TYPE;
257: p_status_2 igf_sl_loans.loan_status%TYPE;
258: p_status_3 igf_sl_loans.loan_status%TYPE;
259: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
260: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;

Line 257: p_status_2 igf_sl_loans.loan_status%TYPE;

253: lv_warning BOOLEAN := FALSE;
254: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
255: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
256: p_status_1 igf_sl_loans.loan_status%TYPE;
257: p_status_2 igf_sl_loans.loan_status%TYPE;
258: p_status_3 igf_sl_loans.loan_status%TYPE;
259: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
260: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;
261:

Line 258: p_status_3 igf_sl_loans.loan_status%TYPE;

254: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
255: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
256: p_status_1 igf_sl_loans.loan_status%TYPE;
257: p_status_2 igf_sl_loans.loan_status%TYPE;
258: p_status_3 igf_sl_loans.loan_status%TYPE;
259: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
260: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;
261:
262: -- Query optimized by using the table igf_sl_cl_recipient instead of the view igf_sl_cl_recipient_v (bug #3691137)

Line 275: p_status_1 igf_sl_loans.loan_status%TYPE,

271:
272: CURSOR cur_lor_details_recs(
273: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
274: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
275: p_status_1 igf_sl_loans.loan_status%TYPE,
276: p_status_2 igf_sl_loans.loan_status%TYPE,
277: p_status_3 igf_sl_loans.loan_status%TYPE,
278: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
279: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,

Line 276: p_status_2 igf_sl_loans.loan_status%TYPE,

272: CURSOR cur_lor_details_recs(
273: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
274: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
275: p_status_1 igf_sl_loans.loan_status%TYPE,
276: p_status_2 igf_sl_loans.loan_status%TYPE,
277: p_status_3 igf_sl_loans.loan_status%TYPE,
278: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
279: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
280: p_active igf_sl_loans.active%TYPE,

Line 277: p_status_3 igf_sl_loans.loan_status%TYPE,

273: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
274: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
275: p_status_1 igf_sl_loans.loan_status%TYPE,
276: p_status_2 igf_sl_loans.loan_status%TYPE,
277: p_status_3 igf_sl_loans.loan_status%TYPE,
278: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
279: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
280: p_active igf_sl_loans.active%TYPE,
281: p_school_id VARCHAR2,

Line 280: p_active igf_sl_loans.active%TYPE,

276: p_status_2 igf_sl_loans.loan_status%TYPE,
277: p_status_3 igf_sl_loans.loan_status%TYPE,
278: p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
279: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
280: p_active igf_sl_loans.active%TYPE,
281: p_school_id VARCHAR2,
282: p_base_id VARCHAR2
283: )IS
284: SELECT loans.row_id,

Line 332: FROM igf_sl_loans loans,

328: fcat.fed_fund_code,
329: fcat.alt_loan_code,
330: TRUNC(fabase.coa_f) coa_f,
331: loans.external_loan_id_txt
332: FROM igf_sl_loans loans,
333: igf_sl_lor lor,
334: igf_aw_award awd,
335: igf_aw_fund_mast fmast,
336: igf_aw_fund_cat fcat,

Line 435: agairola 15-Mar-2002 Modified the IGF_SL_LOANS_PKG update row call

431: Purpose : To Set the Completeness of Record
432: Known Limitations,Enhancements or Remarks
433: Change History :
434: Who When What
435: agairola 15-Mar-2002 Modified the IGF_SL_LOANS_PKG update row call
436: as part of Refunds DLD
437:
438: museshad 05-May-2005 Bug# 4346258
439: Added the parameter 'base_id' in the call to the

Line 541: PROCEDURE cl_alt_borr_cosig_validation (p_loan_number igf_sl_loans.loan_number%TYPE,

537:
538: RETURN p_unmet_need_f;
539: END unmetneed;
540:
541: PROCEDURE cl_alt_borr_cosig_validation (p_loan_number igf_sl_loans.loan_number%TYPE,
542: p_loan_catg VARCHAR2,
543: p_prc_type_code igf_sl_lor.prc_type_code%TYPE)
544: AS
545: /***************************************************************

Line 568: igf_sl_loans loans,

564: borw.student_major student_major,
565: lor.prc_type_code prc_type_code,
566: loans.loan_number loan_number
567: FROM
568: igf_sl_loans loans,
569: igf_sl_lor lor,
570: igf_sl_alt_borw borw
571: WHERE
572: loans.loan_number = p_loan_number AND

Line 1486: SELECT igf_sl_loans.* FROM igf_sl_loans

1482: END IF;
1483:
1484: DECLARE
1485: CURSOR c_tbh_cur IS
1486: SELECT igf_sl_loans.* FROM igf_sl_loans
1487: WHERE loan_id = lor_rec.loan_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;
1488: BEGIN
1489:
1490: FOR tbh_rec in c_tbh_cur LOOP

Line 1487: WHERE loan_id = lor_rec.loan_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;

1483:
1484: DECLARE
1485: CURSOR c_tbh_cur IS
1486: SELECT igf_sl_loans.* FROM igf_sl_loans
1487: WHERE loan_id = lor_rec.loan_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;
1488: BEGIN
1489:
1490: FOR tbh_rec in c_tbh_cur LOOP
1491:

Line 1497: igf_sl_loans_pkg.update_row (

1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_validation.cl_lar_validate.debug', 'Updating tbh_rec.loan_id:' || tbh_rec.loan_id);
1494: END IF;
1495:
1496: -- Modified the update row call for the Borrower Determination as part of Refunds DLD 2144600
1497: igf_sl_loans_pkg.update_row (
1498: X_Mode => 'R',
1499: x_rowid => tbh_rec.row_id,
1500: x_loan_id => tbh_rec.loan_id,
1501: x_award_id => tbh_rec.award_id,