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

Line 23: g_loan_id igf_sl_Loans_all.loan_id%TYPE;

19: --
20: -------------------------------------------------------------------------
21:
22: p_dl_version igf_lookups_view.lookup_code%TYPE;
23: g_loan_id igf_sl_Loans_all.loan_id%TYPE;
24: student_dtl_rec igf_sl_gen.person_dtl_rec;
25: parent_dtl_rec igf_sl_gen.person_dtl_rec;
26:
27: CURSOR cur_disb(c_award_id igf_aw_awd_disb.award_id%TYPE) IS

Line 62: CURSOR cur_loan_at_cod ( cp_loan_number igf_sl_loans_all.loan_number%TYPE) IS

58: WHERE base_id = p_base_id
59: AND payment_isir = 'Y'
60: AND system_record_type = 'ORIGINAL';
61:
62: CURSOR cur_loan_at_cod ( cp_loan_number igf_sl_loans_all.loan_number%TYPE) IS
63: SELECT 'x'
64: FROM igf_sl_lor_loc_history
65: WHERE loan_number = cp_loan_number;
66:

Line 70: FUNCTION check_for_reqd(p_loan_number igf_sl_loans.loan_number%TYPE,

66:
67: isir_info_rec cur_isir_info%ROWTYPE;
68:
69:
70: FUNCTION check_for_reqd(p_loan_number igf_sl_loans.loan_number%TYPE,
71: p_loan_catg igf_sl_reqd_fields.loan_type%TYPE,
72: p_field_name igf_sl_reqd_fields.field_name%TYPE,
73: p_field_value VARCHAR2
74: ) RETURN BOOLEAN

Line 301: p_loan_number igf_sl_loans_all.loan_number%TYPE,

297: /* MAIN PROCEDURE */
298: FUNCTION dl_lar_validate(p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
299: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
300: p_loan_catg fnd_lookups.lookup_code%TYPE,
301: p_loan_number igf_sl_loans_all.loan_number%TYPE,
302: p_call_mode VARCHAR2,
303: p_school_code VARCHAR2 )
304: RETURN BOOLEAN
305: AS

Line 325: igf_sl_loans_pkg

321: Added the debugging log messages.
322:
323: gmuralid 3-July-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
324: Added legacy record flag as parameter to
325: igf_sl_loans_pkg
326:
327: masehgal # 2593215 removed begin/end dates fetching functions
328: used procedure get_acad_cal_dtls instead
329: added another validation to report acad cal not found

Line 330: agairola 15-Mar-2002 Modified the IGF_SL_LOANS_PKG.UPDATE_ROW call

326:
327: masehgal # 2593215 removed begin/end dates fetching functions
328: used procedure get_acad_cal_dtls instead
329: added another validation to report acad cal not found
330: agairola 15-Mar-2002 Modified the IGF_SL_LOANS_PKG.UPDATE_ROW call
331: to include borrower determination as part of
332: Refunds DLD 2144600
333:
334: (reverse chronological order - newest change first)

Line 338: lv_loan_status igf_sl_loans_all.loan_status%TYPE;

334: (reverse chronological order - newest change first)
335: ***************************************************************/
336:
337: lv_loan_catg igf_sl_reqd_fields.loan_type%TYPE;
338: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
339: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;

Line 345: l_status_1 igf_sl_loans_all.loan_status%TYPE;

341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;
348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;
349: l_fed_fund_2 igf_aw_fund_cat_all.fed_fund_code%TYPE;

Line 346: l_status_2 igf_sl_loans_all.loan_status%TYPE;

342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;
348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;
349: l_fed_fund_2 igf_aw_fund_cat_all.fed_fund_code%TYPE;
350: student_dtl_cur igf_sl_gen.person_dtl_cur;

Line 347: l_status_3 igf_sl_loans_all.loan_status%TYPE;

343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;
348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;
349: l_fed_fund_2 igf_aw_fund_cat_all.fed_fund_code%TYPE;
350: student_dtl_cur igf_sl_gen.person_dtl_cur;
351: parent_dtl_cur igf_sl_gen.person_dtl_cur;

Line 384: cp_status_1 igf_sl_loans.loan_status%TYPE,

380: cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
381: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
382: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
383: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
384: cp_status_1 igf_sl_loans.loan_status%TYPE,
385: cp_status_2 igf_sl_loans.loan_status%TYPE,
386: cp_status_3 igf_sl_loans.loan_status%TYPE,
387: cp_loan_number igf_sl_loans.loan_number%TYPE,
388: cp_active igf_sl_loans.active%TYPE,

Line 385: cp_status_2 igf_sl_loans.loan_status%TYPE,

381: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
382: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
383: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
384: cp_status_1 igf_sl_loans.loan_status%TYPE,
385: cp_status_2 igf_sl_loans.loan_status%TYPE,
386: cp_status_3 igf_sl_loans.loan_status%TYPE,
387: cp_loan_number igf_sl_loans.loan_number%TYPE,
388: cp_active igf_sl_loans.active%TYPE,
389: cp_school_code VARCHAR2

Line 386: cp_status_3 igf_sl_loans.loan_status%TYPE,

382: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
383: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
384: cp_status_1 igf_sl_loans.loan_status%TYPE,
385: cp_status_2 igf_sl_loans.loan_status%TYPE,
386: cp_status_3 igf_sl_loans.loan_status%TYPE,
387: cp_loan_number igf_sl_loans.loan_number%TYPE,
388: cp_active igf_sl_loans.active%TYPE,
389: cp_school_code VARCHAR2
390: )

Line 387: cp_loan_number igf_sl_loans.loan_number%TYPE,

383: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
384: cp_status_1 igf_sl_loans.loan_status%TYPE,
385: cp_status_2 igf_sl_loans.loan_status%TYPE,
386: cp_status_3 igf_sl_loans.loan_status%TYPE,
387: cp_loan_number igf_sl_loans.loan_number%TYPE,
388: cp_active igf_sl_loans.active%TYPE,
389: cp_school_code VARCHAR2
390: )
391: IS

Line 388: cp_active igf_sl_loans.active%TYPE,

384: cp_status_1 igf_sl_loans.loan_status%TYPE,
385: cp_status_2 igf_sl_loans.loan_status%TYPE,
386: cp_status_3 igf_sl_loans.loan_status%TYPE,
387: cp_loan_number igf_sl_loans.loan_number%TYPE,
388: cp_active igf_sl_loans.active%TYPE,
389: cp_school_code VARCHAR2
390: )
391: IS
392: SELECT

Line 410: igf_sl_loans_all loans,

406: awd.accepted_amt,
407: lor.grade_level_code,
408: lor.override_grade_level_code
409: FROM
410: igf_sl_loans_all loans,
411: igf_sl_lor_all lor,
412: igf_aw_award_all awd,
413: igf_aw_fund_mast_all fmast,
414: igf_aw_fund_cat_all fcat,

Line 432: CURSOR cur_get_fed_fund_code(cp_loan_number igf_sl_loans.loan_number%TYPE)

428:
429: orec cur_loans%ROWTYPE;
430:
431: -- museshad (Bug 4116399)
432: CURSOR cur_get_fed_fund_code(cp_loan_number igf_sl_loans.loan_number%TYPE)
433: IS
434: SELECT fcat.fed_fund_code
435: FROM igf_sl_loans_all loans,
436: igf_aw_award_all awd,

Line 435: FROM igf_sl_loans_all loans,

431: -- museshad (Bug 4116399)
432: CURSOR cur_get_fed_fund_code(cp_loan_number igf_sl_loans.loan_number%TYPE)
433: IS
434: SELECT fcat.fed_fund_code
435: FROM igf_sl_loans_all loans,
436: igf_aw_award_all awd,
437: igf_aw_fund_mast_all fmast,
438: igf_aw_fund_cat_all fcat
439: WHERE

Line 783: SELECT igf_sl_loans.* FROM igf_sl_loans

779:
780: DECLARE
781: lv_row_id VARCHAR2(25);
782: CURSOR c_tbh_cur IS
783: SELECT igf_sl_loans.* FROM igf_sl_loans
784: WHERE rowid = orec.row_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;
785: BEGIN
786: FOR tbh_rec in c_tbh_cur LOOP
787:

Line 784: WHERE rowid = orec.row_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;

780: DECLARE
781: lv_row_id VARCHAR2(25);
782: CURSOR c_tbh_cur IS
783: SELECT igf_sl_loans.* FROM igf_sl_loans
784: WHERE rowid = orec.row_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;
785: BEGIN
786: FOR tbh_rec in c_tbh_cur LOOP
787:
788: -- Modified the call for IGF_SL_LOANS_PKG.UPDATE_ROW to include the Borrower Determination

Line 788: -- Modified the call for IGF_SL_LOANS_PKG.UPDATE_ROW to include the Borrower Determination

784: WHERE rowid = orec.row_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;
785: BEGIN
786: FOR tbh_rec in c_tbh_cur LOOP
787:
788: -- Modified the call for IGF_SL_LOANS_PKG.UPDATE_ROW to include the Borrower Determination
789: -- as part of Refunds DLD - 2144600
790: igf_sl_loans_pkg.update_row (
791: X_Mode => 'R',
792: x_rowid => tbh_rec.row_id,

Line 790: igf_sl_loans_pkg.update_row (

786: FOR tbh_rec in c_tbh_cur LOOP
787:
788: -- Modified the call for IGF_SL_LOANS_PKG.UPDATE_ROW to include the Borrower Determination
789: -- as part of Refunds DLD - 2144600
790: igf_sl_loans_pkg.update_row (
791: X_Mode => 'R',
792: x_rowid => tbh_rec.row_id,
793: x_loan_id => tbh_rec.loan_id,
794: x_award_id => tbh_rec.award_id,