APPS.IGF_SL_DL_PRINT_MANIFEST dependencies on IGF_SL_LOR

Line 14: -- in igf_sl_lor_all table and obsoleting

10: -- svuppala 4-Nov-2004 #3416936 FA 134 TBH impacts for newly added columns
11:
12: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
13: -- a) Impact of adding the relationship_cd
14: -- in igf_sl_lor_all table and obsoleting
15: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
16: -- GUARANTOR_ID, DUNS_GUARNT_ID,
17: -- LENDER_ID, DUNS_LENDER_ID
18: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 25: chg_batch_id,appl_send_error_codes from igf_sl_lor

21: --------------------------------------------------------------------------------------
22: veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
23: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
24: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
25: chg_batch_id,appl_send_error_codes from igf_sl_lor
26: Purpose : Bug :- 2426609 SSN Format Incorrect in Output File
27: Who When What
28: mesriniv 21-jun-2002 While inserting Student SSN/Parent SSN
29: formatting and substr of 9 chars is done.

Line 37: borr_credit_auth_code in the call to update row of igf_sl_lor tbh

33: adhawan 20-nov-2002 gscc fix removing the default
34: 2669341
35: adhawan 20-feb-2002 added elec_mpn_ind,
36: 2216956 borr_sign_ind,stud_sign_ind,
37: borr_credit_auth_code in the call to update row of igf_sl_lor tbh
38: changed the parameter in the process_manifest to receive base_id instead of student id and then
39: deriving the student id value
40: (reverse chronological order - newest change first)
41: *****************************************************************/

Line 61: TBH Impact change done in igf_sl_lor_pkg.update_row().

57: Know limitations, enhancements or remarks
58: Change History
59: Who When What
60: akomurav 28-Feb-2006 Build FA161 and FA162.
61: TBH Impact change done in igf_sl_lor_pkg.update_row().
62:
63: veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
64: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
65: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,

Line 66: chg_batch_id,appl_send_error_codes from igf_sl_lor

62:
63: veramach 23-SEP-2003 Bug 3104228: Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
64: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
65: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
66: chg_batch_id,appl_send_error_codes from igf_sl_lor
67: (reverse chronological order - newest change first)
68: *****************************************************************/
69:
70: /* Local Variable Declaration */

Line 104: FROM igf_sl_lor_v lor,

100: per.api_person_id,
101: per.given_names,
102: per.surname,
103: per.middle_name
104: FROM igf_sl_lor_v lor,
105: igf_ap_person_v per
106: WHERE lor.pnote_status = 'S' /* Check for pnote_status 'Signed' */
107: AND lor.fed_fund_code IN (SELECT DISTINCT lookup_code
108: FROM igf_lookups_view

Line 117: /* get all records from igf_sl_lor for the given loan_id */

113: AND lor.student_id = NVL(cp_person_id, lor.student_id)
114: AND lor.loan_number = NVL(p_loan_number, lor.loan_number)
115: AND per.person_id = DECODE(p_loan_catg,'DL_STAFFORD',lor.student_id,lor.p_person_id);
116:
117: /* get all records from igf_sl_lor for the given loan_id */
118: CURSOR c_lor_rec(lor_loan_id igf_sl_lor.loan_id%TYPE) IS
119: SELECT igf_sl_lor.*
120: FROM igf_sl_lor
121: WHERE loan_id = lor_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;

Line 118: CURSOR c_lor_rec(lor_loan_id igf_sl_lor.loan_id%TYPE) IS

114: AND lor.loan_number = NVL(p_loan_number, lor.loan_number)
115: AND per.person_id = DECODE(p_loan_catg,'DL_STAFFORD',lor.student_id,lor.p_person_id);
116:
117: /* get all records from igf_sl_lor for the given loan_id */
118: CURSOR c_lor_rec(lor_loan_id igf_sl_lor.loan_id%TYPE) IS
119: SELECT igf_sl_lor.*
120: FROM igf_sl_lor
121: WHERE loan_id = lor_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
122:

Line 119: SELECT igf_sl_lor.*

115: AND per.person_id = DECODE(p_loan_catg,'DL_STAFFORD',lor.student_id,lor.p_person_id);
116:
117: /* get all records from igf_sl_lor for the given loan_id */
118: CURSOR c_lor_rec(lor_loan_id igf_sl_lor.loan_id%TYPE) IS
119: SELECT igf_sl_lor.*
120: FROM igf_sl_lor
121: WHERE loan_id = lor_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
122:
123:

Line 120: FROM igf_sl_lor

116:
117: /* get all records from igf_sl_lor for the given loan_id */
118: CURSOR c_lor_rec(lor_loan_id igf_sl_lor.loan_id%TYPE) IS
119: SELECT igf_sl_lor.*
120: FROM igf_sl_lor
121: WHERE loan_id = lor_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
122:
123:
124:

Line 121: WHERE loan_id = lor_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;

117: /* get all records from igf_sl_lor for the given loan_id */
118: CURSOR c_lor_rec(lor_loan_id igf_sl_lor.loan_id%TYPE) IS
119: SELECT igf_sl_lor.*
120: FROM igf_sl_lor
121: WHERE loan_id = lor_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
122:
123:
124:
125: r_lor_signed c_lor_signed%ROWTYPE;

Line 228: /* Set the PNote Status for this loan ID as 'Printed' in igf_sl_lor table */

224: x_mode => 'R'
225: );
226:
227:
228: /* Set the PNote Status for this loan ID as 'Printed' in igf_sl_lor table */
229: FOR r_dl_lor_rec IN c_lor_rec( r_lor_signed.loan_id )
230:
231: LOOP
232: igf_sl_lor_pkg.update_row (

Line 232: igf_sl_lor_pkg.update_row (

228: /* Set the PNote Status for this loan ID as 'Printed' in igf_sl_lor table */
229: FOR r_dl_lor_rec IN c_lor_rec( r_lor_signed.loan_id )
230:
231: LOOP
232: igf_sl_lor_pkg.update_row (
233: X_mode => 'R',
234: x_rowid => r_dl_lor_rec.row_id,
235: x_origination_id => r_dl_lor_rec.origination_id,
236: x_loan_id => r_dl_lor_rec.loan_id,