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

Line 41: -- containing igf_sl_lor_dtls_v with simple

37: -- sjadhav 14-Oct-2003 Bug 3104228 Removed ref to obsolete columns
38: ---------------------------------------------------------------------------------------
39: -- bkkumar 07-oct-2003 Bug 3104228 FA 122 Loan Enhancemtns
40: -- a) Changed the cursor c_lor
41: -- containing igf_sl_lor_dtls_v with simple
42: -- joins and got the details of student and parent
43: -- from igf_sl_gen.get_person_details.
44: -- Added the debugging log messages.
45: -- b) The DUNS_BORW_LENDER_ID,

Line 49: -- igf_sl_lor_loc_all table.

45: -- b) The DUNS_BORW_LENDER_ID,
46: -- DUNS_GUARNT_ID,
47: -- DUNS_LENDER_ID,
48: -- DUNS_RECIP_ID columns are osboleted from the
49: -- igf_sl_lor_loc_all table.
50: ---------------------------------------------------------------------------------------
51: -- sjadhav 26-Mar-2003 Bug 2863960
52: -- lcur_award.disb_gross_amt replaced with
53: -- lcur_award.disb_accepted_amt as accepted amount is the

Line 83: TBH Impact change in igf_sl_lor_loc_pkg.update_row()

79: Know limitations, enhancements or remarks
80: Change History:
81: Who When What
82: bvisvana 10-Apr-2006 Build FA 161.
83: TBH Impact change in igf_sl_lor_loc_pkg.update_row()
84: Bug No:2332668 Desc:LOAN ORIGINATION PROCESS NOT RUNNING SUCCESSFULLY.
85: Who When What
86: mesriniv 23-APR-2002 Added code to display the Parameters Passed
87:

Line 107: lv_begin_date igf_sl_lor_loc.acad_yr_begin_date %TYPE; -- ## Variable to have the academic begin date ##

103: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
104: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
105: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
106: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
107: lv_begin_date igf_sl_lor_loc.acad_yr_begin_date %TYPE; -- ## Variable to have the academic begin date ##
108: lv_end_date igf_sl_lor_loc.acad_yr_end_date%TYPE; -- ## Variable to have the academic end date ##
109:
110: --Bug No:2332668
111: l_i NUMBER(1);

Line 108: lv_end_date igf_sl_lor_loc.acad_yr_end_date%TYPE; -- ## Variable to have the academic end date ##

104: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
105: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
106: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
107: lv_begin_date igf_sl_lor_loc.acad_yr_begin_date %TYPE; -- ## Variable to have the academic begin date ##
108: lv_end_date igf_sl_lor_loc.acad_yr_end_date%TYPE; -- ## Variable to have the academic end date ##
109:
110: --Bug No:2332668
111: l_i NUMBER(1);
112: l_alternate_code igs_ca_inst.alternate_code%TYPE;

Line 152: -- ## Cursor to Retrieve the active direct loan records with change status as Send from the igf_sl_lor table

148: student_dtl_rec igf_sl_gen.person_dtl_rec;
149: parent_dtl_rec igf_sl_gen.person_dtl_rec;
150:
151:
152: -- ## Cursor to Retrieve the active direct loan records with change status as Send from the igf_sl_lor table
153: -- ## for the particular award Year
154: -- FA 122 Loans Enhancemnts changed the cursor to remove the obsolete view igf_sl_lor_dtls_v
155: CURSOR c_lor(
156: p_cal_type igs_ca_inst.cal_type%TYPE,

Line 154: -- FA 122 Loans Enhancemnts changed the cursor to remove the obsolete view igf_sl_lor_dtls_v

150:
151:
152: -- ## Cursor to Retrieve the active direct loan records with change status as Send from the igf_sl_lor table
153: -- ## for the particular award Year
154: -- FA 122 Loans Enhancemnts changed the cursor to remove the obsolete view igf_sl_lor_dtls_v
155: CURSOR c_lor(
156: p_cal_type igs_ca_inst.cal_type%TYPE,
157: p_seq_num igs_ca_inst.sequence_number%TYPE,
158: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,

Line 189: igf_sl_lor lor,

185: fabase.person_id student_id,
186: awd.accepted_amt
187: FROM
188: igf_sl_loans loans,
189: igf_sl_lor lor,
190: igf_aw_award awd,
191: igf_aw_fund_mast fmast,
192: igf_aw_fund_cat fcat,
193: igf_ap_fa_base_rec fabase

Line 214: -- ## Cursor to Retrieve the Originated record to compare with the igf_sl_lor table to see if any

210: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL ;
211: lv_acad_seq_num igs_ca_inst.sequence_number%TYPE := NULL ;
212: lv_message VARCHAR2(100) := NULL ;
213:
214: -- ## Cursor to Retrieve the Originated record to compare with the igf_sl_lor table to see if any
215: -- ## change records exist.
216:
217: CURSOR c_lor_loc(p_loan_id igf_sl_lor_loc.loan_id%TYPE) IS
218: SELECT igf_sl_lor_loc.*

Line 217: CURSOR c_lor_loc(p_loan_id igf_sl_lor_loc.loan_id%TYPE) IS

213:
214: -- ## Cursor to Retrieve the Originated record to compare with the igf_sl_lor table to see if any
215: -- ## change records exist.
216:
217: CURSOR c_lor_loc(p_loan_id igf_sl_lor_loc.loan_id%TYPE) IS
218: SELECT igf_sl_lor_loc.*
219: FROM igf_sl_lor_loc
220: WHERE loan_id = p_loan_id;
221:

Line 218: SELECT igf_sl_lor_loc.*

214: -- ## Cursor to Retrieve the Originated record to compare with the igf_sl_lor table to see if any
215: -- ## change records exist.
216:
217: CURSOR c_lor_loc(p_loan_id igf_sl_lor_loc.loan_id%TYPE) IS
218: SELECT igf_sl_lor_loc.*
219: FROM igf_sl_lor_loc
220: WHERE loan_id = p_loan_id;
221:
222: -- ## Cursor to retrieve the license number,license state,citizenship status,alien reg number and

Line 219: FROM igf_sl_lor_loc

215: -- ## change records exist.
216:
217: CURSOR c_lor_loc(p_loan_id igf_sl_lor_loc.loan_id%TYPE) IS
218: SELECT igf_sl_lor_loc.*
219: FROM igf_sl_lor_loc
220: WHERE loan_id = p_loan_id;
221:
222: -- ## Cursor to retrieve the license number,license state,citizenship status,alien reg number and
223: -- ## dependency status of the Student to be compared with that in IGF_SL_LOR_LOC to see if

Line 223: -- ## dependency status of the Student to be compared with that in IGF_SL_LOR_LOC to see if

219: FROM igf_sl_lor_loc
220: WHERE loan_id = p_loan_id;
221:
222: -- ## Cursor to retrieve the license number,license state,citizenship status,alien reg number and
223: -- ## dependency status of the Student to be compared with that in IGF_SL_LOR_LOC to see if
224: -- ## any changes exists.
225:
226: CURSOR cur_isir_depend_status(l_base_id igf_ap_fa_base_rec.base_id%TYPE)
227: IS

Line 296: Purpose : Procedure to compare the values in igf_sl_lor_loc and igf_sl_lor_dtls_v also for disbursements

292: AS
293: /*************************************************************
294: Created By : prchandr
295: Date Created On : 2000/12/07
296: Purpose : Procedure to compare the values in igf_sl_lor_loc and igf_sl_lor_dtls_v also for disbursements
297: Know limitations, enhancements or remarks
298: Change History:
299: Bug 2438434.Incorrect Format in Output File.
300: Who When What

Line 469: -- ## Comparisons of Old records and the new records in c_lor cursor and igf_sl_lor_loc

465: l_fed_fund_1 := 'DLP';
466: l_fed_fund_2 := 'DLP';
467: END IF;
468:
469: -- ## Comparisons of Old records and the new records in c_lor cursor and igf_sl_lor_loc
470: -- ## Outer Loop get the various Loan ID for the Particular award year whereas the inner loop
471: -- ## gets the originated records for the particular loan ID and passes it to a procedure
472: -- ## called comp_lor_loc to check if any changes are there between 2 tables. If changes exists
473: -- ## returns a flag with status as Y

Line 706: -- ## exists then the flag is set to Y and depending on that the igf_sl_lor_loc table is updated with

702: lc_header_flag := 'Y';
703: END IF;
704:
705: -- ## The lc_chg_flag is the out NOCOPY parameter from the comp_lor_loc procedure, even if one changed column
706: -- ## exists then the flag is set to Y and depending on that the igf_sl_lor_loc table is updated with
707: -- ## the new value(changed value). In case of disbursement records if any changes exists then the
708: -- ## igf_sl_awd_disb_loc table is deleted for the particular award Id and the new value from the
709: -- ## igf_aw_awd_disb is inserted into this table.
710:

Line 713: -- Update the igf_sl_lor_loc table with the New Values(Changes values)

709: -- ## igf_aw_awd_disb is inserted into this table.
710:
711: IF lc_chg_flag ='Y' THEN
712:
713: -- Update the igf_sl_lor_loc table with the New Values(Changes values)
714: igf_sl_lor_loc_pkg.update_row (
715: X_Mode => 'R',
716: x_rowid => lc_lor_loc.row_id,
717: x_loan_id => lc_lor_loc.loan_id,

Line 714: igf_sl_lor_loc_pkg.update_row (

710:
711: IF lc_chg_flag ='Y' THEN
712:
713: -- Update the igf_sl_lor_loc table with the New Values(Changes values)
714: igf_sl_lor_loc_pkg.update_row (
715: X_Mode => 'R',
716: x_rowid => lc_lor_loc.row_id,
717: x_loan_id => lc_lor_loc.loan_id,
718: x_origination_id => lc_lor_loc.origination_id,