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

Line 8: p_loan_number igf_sl_loans_all.loan_number%TYPE,

4: PROCEDURE dl_originate(errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_award_year VARCHAR2,
7: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
8: p_loan_number igf_sl_loans_all.loan_number%TYPE,
9: p_org_id IN NUMBER,
10: school_type IN VARCHAR2,
11: p_school_code IN VARCHAR2)
12: AS

Line 95: -- igf_sl_loans_pkg

91: -- chg_batch_id from igf_sl_lor_loc
92: --------------------------------------------------------------------------------------------------
93: -- gmuralid 03-07-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
94: -- Added legacy record flag as parameter to
95: -- igf_sl_loans_pkg
96: -----------------------------------------------------------------------------------
97: -- sjadhav 26-Mar-2003 Bug 2863960
98: -- Modified routine to populate disb gross
99: -- amount in the igf_sl_awd_disb_loc table with

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

111: -- mesriniv 23-APR-2002 Bug No:2332668 Desc:LOAN ORIGINATION PROCESS NOT
112: -- RUNNING SUCCESSFULLY.
113: -- Added code to display the Parameters Passed
114: -----------------------------------------------------------------------------------
115: -- agairola 15-Mar-2002 Modified the Update Row call of the IGF_SL_LOANS_PKG
116: -- to include Borrower Determination as part of
117: -- Refunds 2144600
118: -----------------------------------------------------------------------------------
119: -- adhawan 19th feb 2002 Bug:2216956

Line 136: lv_orig_loan_id igf_sl_loans.loan_id%TYPE;

132: lv_data_record VARCHAR2(4000);
133: lv_data_header_record VARCHAR2(4000);
134:
135: lv_orig_award_id igf_aw_award.award_id%TYPE;
136: lv_orig_loan_id igf_sl_loans.loan_id%TYPE;
137: lv_orig_loan_num igf_sl_loans.loan_number%TYPE;
138: lv_num_of_rec NUMBER := 0;
139: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE := NULL;
140: lv_acad_end_dt igs_ca_inst.end_dt%TYPE := NULL;

Line 137: lv_orig_loan_num igf_sl_loans.loan_number%TYPE;

133: lv_data_header_record VARCHAR2(4000);
134:
135: lv_orig_award_id igf_aw_award.award_id%TYPE;
136: lv_orig_loan_id igf_sl_loans.loan_id%TYPE;
137: lv_orig_loan_num igf_sl_loans.loan_number%TYPE;
138: lv_num_of_rec NUMBER := 0;
139: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE := NULL;
140: lv_acad_end_dt igs_ca_inst.end_dt%TYPE := NULL;
141: l_i NUMBER(1);

Line 160: lv_loan_id igf_sl_loans.loan_id%TYPE;

156: Orig_Rec igf_sl_dl_record.DLOrigType;
157: Trailer_Rec igf_sl_dl_record.DLTrailerType;
158:
159:
160: lv_loan_id igf_sl_loans.loan_id%TYPE;
161: lv_bool BOOLEAN;
162: no_loan_data EXCEPTION;
163: yr_full_participant EXCEPTION;
164:

Line 170: cp_loan_status igf_sl_loans.loan_status%TYPE,

166: cp_cal_type igs_ca_inst.cal_type%TYPE,
167: cp_seq_number igs_ca_inst.sequence_number%TYPE,
168: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
169: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
170: cp_loan_status igf_sl_loans.loan_status%TYPE,
171: cp_active igf_sl_loans.active%TYPE,
172: cp_dl_loan_number igf_sl_loans.loan_number%TYPE
173: )
174: IS

Line 171: cp_active igf_sl_loans.active%TYPE,

167: cp_seq_number igs_ca_inst.sequence_number%TYPE,
168: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
169: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
170: cp_loan_status igf_sl_loans.loan_status%TYPE,
171: cp_active igf_sl_loans.active%TYPE,
172: cp_dl_loan_number igf_sl_loans.loan_number%TYPE
173: )
174: IS
175: SELECT

Line 172: cp_dl_loan_number igf_sl_loans.loan_number%TYPE

168: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
169: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
170: cp_loan_status igf_sl_loans.loan_status%TYPE,
171: cp_active igf_sl_loans.active%TYPE,
172: cp_dl_loan_number igf_sl_loans.loan_number%TYPE
173: )
174: IS
175: SELECT
176: loans.loan_number,

Line 179: igf_sl_loans loans,

175: SELECT
176: loans.loan_number,
177: fabase.base_id
178: FROM
179: igf_sl_loans loans,
180: igf_sl_lor lor,
181: igf_aw_award awd,
182: igf_aw_fund_mast fmast,
183: igf_aw_fund_cat fcat,

Line 212: FROM igf_sl_loans_all loan,

208:
209:
210: CURSOR c_loans IS
211: SELECT loan.loan_id
212: FROM igf_sl_loans_all loan,
213: igf_aw_award_all awd,
214: igf_aw_fund_mast_all fmast,
215: igf_aw_fund_cat_all fcat
216: WHERE

Line 585: FROM igf_sl_loans_all loans,

581: lor.b_alien_reg_num_txt,
582: lor.esign_src_typ_cd,
583: lor.acad_begin_date,
584: lor.acad_end_date
585: FROM igf_sl_loans_all loans,
586: igf_sl_lor_all lor,
587: igf_aw_award_all awd,
588: igf_ap_fa_base_rec_all fabase,
589: igf_aw_fund_mast_all fmast

Line 915: SELECT igf_sl_loans.* FROM igf_sl_loans

911: -- Update LOAN_STATUS, LOAN_STATUS_DATE to SENT, Current Date
912: DECLARE
913: lv_row_id VARCHAR2(25);
914: CURSOR c_tbh_cur IS
915: SELECT igf_sl_loans.* FROM igf_sl_loans
916: WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;
917: BEGIN
918: FOR tbh_rec in c_tbh_cur LOOP
919:

Line 916: WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;

912: DECLARE
913: lv_row_id VARCHAR2(25);
914: CURSOR c_tbh_cur IS
915: SELECT igf_sl_loans.* FROM igf_sl_loans
916: WHERE loan_id = lv_orig_loan_id FOR UPDATE OF igf_sl_loans.loan_status NOWAIT;
917: BEGIN
918: FOR tbh_rec in c_tbh_cur LOOP
919:
920: -- Modified the update row call to include the Borrower Determination as part of

Line 922: igf_sl_loans_pkg.update_row (

918: FOR tbh_rec in c_tbh_cur LOOP
919:
920: -- Modified the update row call to include the Borrower Determination as part of
921: -- Refunds DLD 2144600
922: igf_sl_loans_pkg.update_row (
923: X_Mode => 'R',
924: x_rowid => tbh_rec.row_id,
925: x_loan_id => tbh_rec.loan_id,
926: x_award_id => tbh_rec.award_id,