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

Line 28: igf_sl_loans_pkg

24: -- igf_sl_lor_loc_all table.
25: ---------------------------------------------------------------------------
26: gmuralid 03-07-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
27: Added legacy record flag as parameter to
28: igf_sl_loans_pkg
29:
30: vvutukur 21-Feb-2003 Enh#2758823.FA117 Build. Modified procedure dl_load_data.
31: ***************************************************************/
32:

Line 44: p_loan_number igf_sl_loans.loan_number%TYPE,

40:
41:
42: /* FORWARD DECLARATION OF PRIVATE PROCEDURES */
43: PROCEDURE upd_dl_chg_resp(p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
44: p_loan_number igf_sl_loans.loan_number%TYPE,
45: p_status igf_sl_dl_chg_resp.status%TYPE);
46:
47: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
48: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,

Line 47: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,

43: PROCEDURE upd_dl_chg_resp(p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
44: p_loan_number igf_sl_loans.loan_number%TYPE,
45: p_status igf_sl_dl_chg_resp.status%TYPE);
46:
47: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
48: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
49: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
50: p_rec_present OUT NOCOPY VARCHAR2);
51:

Line 48: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,

44: p_loan_number igf_sl_loans.loan_number%TYPE,
45: p_status igf_sl_dl_chg_resp.status%TYPE);
46:
47: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
48: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
49: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
50: p_rec_present OUT NOCOPY VARCHAR2);
51:
52: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,

Line 49: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,

45: p_status igf_sl_dl_chg_resp.status%TYPE);
46:
47: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
48: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
49: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
50: p_rec_present OUT NOCOPY VARCHAR2);
51:
52: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,
53: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE);

Line 53: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE);

49: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
50: p_rec_present OUT NOCOPY VARCHAR2);
51:
52: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,
53: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE);
54:
55:
56:
57:

Line 366: CURSOR cur_get_fed_fund(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

362: AND status = 'N'
363: GROUP BY loan_number;
364:
365: -- Get the fed fund code for the loan number
366: CURSOR cur_get_fed_fund(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
367: SELECT fcat.fed_fund_code
368: FROM igf_sl_loans_all loan,
369: igf_aw_award_all awd,
370: igf_aw_fund_mast_all fmast,

Line 368: FROM igf_sl_loans_all loan,

364:
365: -- Get the fed fund code for the loan number
366: CURSOR cur_get_fed_fund(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
367: SELECT fcat.fed_fund_code
368: FROM igf_sl_loans_all loan,
369: igf_aw_award_all awd,
370: igf_aw_fund_mast_all fmast,
371: igf_aw_fund_cat_all fcat
372: WHERE

Line 381: CURSOR cur_get_loan_accp_amt(p_loan_number igf_sl_loans_all.loan_number%TYPE,

377:
378: --Added code as part of Bug :- 2383350 Loan Cancellation
379: --Check if the received file has the change code as LOAN_AMT_ACCEPTED
380: --for the particular Loan Number
381: CURSOR cur_get_loan_accp_amt(p_loan_number igf_sl_loans_all.loan_number%TYPE,
382: p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
383: p_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE
384: ) IS
385: SELECT resp.new_value

Line 397: l_loan_status igf_sl_loans_all.loan_status%TYPE;

393: AND chgfld.loan_catg =p_loan_catg;
394:
395:
396: l_loan_accp_amt igf_aw_award_all.accepted_amt%TYPE;
397: l_loan_status igf_sl_loans_all.loan_status%TYPE;
398: l_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE;
399: l_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
400:
401: BEGIN

Line 455: -- Update the IGF_SL_LOANS record with the Loan Change Status

451:
452: END IF;
453:
454:
455: -- Update the IGF_SL_LOANS record with the Loan Change Status
456: upd_loan_record(resp_rec.loan_number,l_loan_status,l_loan_chg_status, l_rec_present);
457:
458: -- If the Loan# being uploaded is not a Valid Loan#
459: IF l_rec_present = 'N' THEN

Line 489: l_loan_number igf_sl_loans.loan_number%TYPE) IS

485: DECLARE
486:
487: -- Loan Error for the ENTIRE line are retrieved here.
488: CURSOR cur_loan_err_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
489: l_loan_number igf_sl_loans.loan_number%TYPE) IS
490: SELECT DISTINCT rchg.loan_ident_err_code
491: FROM igf_sl_dl_chg_resp rchg
492: WHERE rchg.dbth_id = l_dbth_id
493: AND rchg.loan_number = l_loan_number

Line 499: l_loan_number igf_sl_loans.loan_number%TYPE) IS

495: AND rchg.status = 'N';
496:
497: -- Reject Codes for Individual Field Changes are retrieved here.
498: CURSOR cur_chg_rej_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
499: l_loan_number igf_sl_loans.loan_number%TYPE) IS
500: SELECT fld_name, cchgv.description fld_desc, rchg.reject_code, rchg.new_value
501: FROM igf_sl_dl_chg_resp rchg,
502: igf_sl_dl_chg_fld_v cchgv
503: WHERE rchg.dbth_id = l_dbth_id

Line 636: p_loan_number igf_sl_loans.loan_number%TYPE,

632:
633:
634:
635: PROCEDURE upd_dl_chg_resp(p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
636: p_loan_number igf_sl_loans.loan_number%TYPE,
637: p_status igf_sl_dl_chg_resp.status%TYPE)
638: IS
639: /*************************************************************
640: Created By : venagara

Line 686: -- Update the IGF_SL_LOANS record, for the Loan-Number, for the New Change Status

682: END upd_dl_chg_resp;
683:
684:
685:
686: -- Update the IGF_SL_LOANS record, for the Loan-Number, for the New Change Status
687: -- If the Loan_number is not present in OFA, then return p_rec_present as 'N'
688: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
689: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
690: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,

Line 688: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,

684:
685:
686: -- Update the IGF_SL_LOANS record, for the Loan-Number, for the New Change Status
687: -- If the Loan_number is not present in OFA, then return p_rec_present as 'N'
688: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
689: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
690: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
691: p_rec_present OUT NOCOPY VARCHAR2)
692: AS

Line 689: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,

685:
686: -- Update the IGF_SL_LOANS record, for the Loan-Number, for the New Change Status
687: -- If the Loan_number is not present in OFA, then return p_rec_present as 'N'
688: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
689: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
690: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
691: p_rec_present OUT NOCOPY VARCHAR2)
692: AS
693: /*************************************************************

Line 690: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,

686: -- Update the IGF_SL_LOANS record, for the Loan-Number, for the New Change Status
687: -- If the Loan_number is not present in OFA, then return p_rec_present as 'N'
688: PROCEDURE upd_loan_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
689: p_loan_status IN igf_sl_loans_all.loan_status%TYPE,
690: p_loan_chg_status IN igf_sl_loans.loan_chg_status%TYPE,
691: p_rec_present OUT NOCOPY VARCHAR2)
692: AS
693: /*************************************************************
694: Created By : venagara

Line 701: of the IGF_SL_LOANS_PKG to include the

697: Know limitations, enhancements or remarks
698: Change History
699: Who When What
700: agairola 15-Mar-2002 Modified the Update Row call
701: of the IGF_SL_LOANS_PKG to include the
702: Borrower Determination as part of Refunds DLD 2144600
703: (reverse chronological order - newest change first)
704: ***************************************************************/
705:

Line 708: SELECT igf_sl_loans.* FROM igf_sl_loans

704: ***************************************************************/
705:
706: l_row_id VARCHAR2(25);
707: CURSOR c_tbh_cur IS
708: SELECT igf_sl_loans.* FROM igf_sl_loans
709: WHERE loan_number = p_loan_number
710: FOR UPDATE OF loan_id NOWAIT;
711:
712: BEGIN

Line 738: igf_sl_loans_pkg.update_row (

734:
735:
736: -- Modified the Update Row call for the Borrower Determination
737: -- as part of the Refunds DLD 2144600
738: igf_sl_loans_pkg.update_row (
739: X_Mode => 'R',
740: x_rowid => tbh_rec.row_id,
741: x_loan_id => tbh_rec.loan_id,
742: x_award_id => tbh_rec.award_id,

Line 776: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE)

772:
773:
774: -- Update the IGF_SL_LOR_LOC record for the New Loan Change Status, for the passed Loan-Number
775: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE,
776: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE)
777: AS
778: /*************************************************************
779: Created By : venagara
780: Date Created On : 2000/11/22