[Home] [Help]
PACKAGE BODY: APPS.IGF_SL_LOR_LOC_PKG
Source
1 PACKAGE BODY igf_sl_lor_loc_pkg AS
2 /* $Header: IGFLI11B.pls 120.1 2006/04/19 08:23:35 bvisvana noship $ */
3
4 l_rowid VARCHAR2(25);
5 old_references igf_sl_lor_loc_all%ROWTYPE;
6 new_references igf_sl_lor_loc_all%ROWTYPE;
7
8 PROCEDURE set_column_values (
9 p_action IN VARCHAR2,
10 x_rowid IN VARCHAR2 DEFAULT NULL,
11 x_loan_id IN NUMBER DEFAULT NULL,
12 x_origination_id IN NUMBER DEFAULT NULL,
13 x_loan_number IN VARCHAR2 DEFAULT NULL,
14 x_loan_type IN VARCHAR2 DEFAULT NULL,
15 x_loan_amt_offered IN NUMBER DEFAULT NULL,
16 x_loan_amt_accepted IN NUMBER DEFAULT NULL,
17 x_loan_per_begin_date IN DATE DEFAULT NULL,
18 x_loan_per_end_date IN DATE DEFAULT NULL,
19 x_acad_yr_begin_date IN DATE DEFAULT NULL,
20 x_acad_yr_end_date IN DATE DEFAULT NULL,
21 x_loan_status IN VARCHAR2 DEFAULT NULL,
22 x_loan_status_date IN DATE DEFAULT NULL,
23 x_loan_chg_status IN VARCHAR2 DEFAULT NULL,
24 x_loan_chg_status_date IN DATE DEFAULT NULL,
25 x_req_serial_loan_code IN VARCHAR2 DEFAULT NULL,
26 x_act_serial_loan_code IN VARCHAR2 DEFAULT NULL,
27 x_active IN VARCHAR2 DEFAULT NULL,
28 x_active_date IN DATE DEFAULT NULL,
29 x_sch_cert_date IN DATE DEFAULT NULL,
30 x_orig_status_flag IN VARCHAR2 DEFAULT NULL,
31 x_orig_batch_id IN VARCHAR2 DEFAULT NULL,
32 x_orig_batch_date IN DATE DEFAULT NULL,
33 x_chg_batch_id IN VARCHAR2 DEFAULT NULL,
34 x_orig_ack_date IN DATE DEFAULT NULL,
35 x_credit_override IN VARCHAR2 DEFAULT NULL,
36 x_credit_decision_date IN DATE DEFAULT NULL,
37 x_pnote_delivery_code IN VARCHAR2 DEFAULT NULL,
38 x_pnote_status IN VARCHAR2 DEFAULT NULL,
39 x_pnote_status_date IN DATE DEFAULT NULL,
40 x_pnote_id IN VARCHAR2 DEFAULT NULL,
41 x_pnote_print_ind IN VARCHAR2 DEFAULT NULL,
42 x_pnote_accept_amt IN NUMBER DEFAULT NULL,
43 x_pnote_accept_date IN DATE DEFAULT NULL,
44 x_p_signature_code IN VARCHAR2 DEFAULT NULL,
45 x_p_signature_date IN DATE DEFAULT NULL,
46 x_s_signature_code IN VARCHAR2 DEFAULT NULL,
47 x_unsub_elig_for_heal IN VARCHAR2 DEFAULT NULL,
48 x_disclosure_print_ind IN VARCHAR2 DEFAULT NULL,
49 x_orig_fee_perct IN NUMBER DEFAULT NULL,
50 x_borw_confirm_ind IN VARCHAR2 DEFAULT NULL,
51 x_borw_interest_ind IN VARCHAR2 DEFAULT NULL,
52 x_unsub_elig_for_depnt IN VARCHAR2 DEFAULT NULL,
53 x_guarantee_amt IN NUMBER DEFAULT NULL,
54 x_guarantee_date IN DATE DEFAULT NULL,
55 x_guarnt_adj_ind IN VARCHAR2 DEFAULT NULL,
56 x_guarnt_amt_redn_code IN VARCHAR2 DEFAULT NULL,
57 x_guarnt_status_code IN VARCHAR2 DEFAULT NULL,
58 x_guarnt_status_date IN DATE DEFAULT NULL,
59 x_lend_apprv_denied_code IN VARCHAR2 DEFAULT NULL,
60 x_lend_apprv_denied_date IN DATE DEFAULT NULL,
61 x_lend_status_code IN VARCHAR2 DEFAULT NULL,
62 x_lend_status_date IN DATE DEFAULT NULL,
63 x_grade_level_code IN VARCHAR2 DEFAULT NULL,
64 x_enrollment_code IN VARCHAR2 DEFAULT NULL,
65 x_anticip_compl_date IN DATE DEFAULT NULL,
66 x_borw_lender_id IN VARCHAR2 DEFAULT NULL,
67 x_duns_borw_lender_id IN VARCHAR2 DEFAULT NULL,
68 x_guarantor_id IN VARCHAR2 DEFAULT NULL,
69 x_duns_guarnt_id IN VARCHAR2 DEFAULT NULL,
70 x_prc_type_code IN VARCHAR2 DEFAULT NULL,
71 x_rec_type_ind IN VARCHAR2 DEFAULT NULL,
72 x_cl_loan_type IN VARCHAR2 DEFAULT NULL,
73 x_cl_seq_number IN NUMBER DEFAULT NULL,
74 x_last_resort_lender IN VARCHAR2 DEFAULT NULL,
75 x_lender_id IN VARCHAR2 DEFAULT NULL,
76 x_duns_lender_id IN VARCHAR2 DEFAULT NULL,
77 x_lend_non_ed_brc_id IN VARCHAR2 DEFAULT NULL,
78 x_recipient_id IN VARCHAR2 DEFAULT NULL,
79 x_recipient_type IN VARCHAR2 DEFAULT NULL,
80 x_duns_recip_id IN VARCHAR2 DEFAULT NULL,
81 x_recip_non_ed_brc_id IN VARCHAR2 DEFAULT NULL,
82 x_cl_rec_status IN VARCHAR2 DEFAULT NULL,
83 x_cl_rec_status_last_update IN DATE DEFAULT NULL,
84 x_alt_prog_type_code IN VARCHAR2 DEFAULT NULL,
85 x_alt_appl_ver_code IN NUMBER DEFAULT NULL,
86 x_borw_outstd_loan_code IN VARCHAR2 DEFAULT NULL,
87 x_mpn_confirm_code IN VARCHAR2 DEFAULT NULL,
88 x_resp_to_orig_code IN VARCHAR2 DEFAULT NULL,
89 x_appl_loan_phase_code IN VARCHAR2 DEFAULT NULL,
90 x_appl_loan_phase_code_chg IN DATE DEFAULT NULL,
91 x_tot_outstd_stafford IN NUMBER DEFAULT NULL,
92 x_tot_outstd_plus IN NUMBER DEFAULT NULL,
93 x_alt_borw_tot_debt IN NUMBER DEFAULT NULL,
94 x_act_interest_rate IN NUMBER DEFAULT NULL,
95 x_service_type_code IN VARCHAR2 DEFAULT NULL,
96 x_rev_notice_of_guarnt IN VARCHAR2 DEFAULT NULL,
97 x_sch_refund_amt IN NUMBER DEFAULT NULL,
98 x_sch_refund_date IN DATE DEFAULT NULL,
99 x_uniq_layout_vend_code IN VARCHAR2 DEFAULT NULL,
100 x_uniq_layout_ident_code IN VARCHAR2 DEFAULT NULL,
101 x_p_person_id IN NUMBER DEFAULT NULL,
102 x_p_ssn IN VARCHAR2 DEFAULT NULL,
103 x_p_ssn_chg_date IN DATE DEFAULT NULL,
104 x_p_last_name IN VARCHAR2 DEFAULT NULL,
105 x_p_first_name IN VARCHAR2 DEFAULT NULL,
106 x_p_middle_name IN VARCHAR2 DEFAULT NULL,
107 x_p_permt_addr1 IN VARCHAR2 DEFAULT NULL,
108 x_p_permt_addr2 IN VARCHAR2 DEFAULT NULL,
109 x_p_permt_city IN VARCHAR2 DEFAULT NULL,
110 x_p_permt_state IN VARCHAR2 DEFAULT NULL,
111 x_p_permt_zip IN VARCHAR2 DEFAULT NULL,
112 x_p_permt_addr_chg_date IN DATE DEFAULT NULL,
113 x_p_permt_phone IN VARCHAR2 DEFAULT NULL,
114 x_p_email_addr IN VARCHAR2 DEFAULT NULL,
115 x_p_date_of_birth IN DATE DEFAULT NULL,
116 x_p_dob_chg_date IN DATE DEFAULT NULL,
117 x_p_license_num IN VARCHAR2 DEFAULT NULL,
118 x_p_license_state IN VARCHAR2 DEFAULT NULL,
119 x_p_citizenship_status IN VARCHAR2 DEFAULT NULL,
120 x_p_alien_reg_num IN VARCHAR2 DEFAULT NULL,
121 x_p_default_status IN VARCHAR2 DEFAULT NULL,
122 x_p_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
123 x_p_state_of_legal_res IN VARCHAR2 DEFAULT NULL,
124 x_p_legal_res_date IN DATE DEFAULT NULL,
125 x_s_ssn IN VARCHAR2 DEFAULT NULL,
126 x_s_ssn_chg_date IN DATE DEFAULT NULL,
127 x_s_last_name IN VARCHAR2 DEFAULT NULL,
128 x_s_first_name IN VARCHAR2 DEFAULT NULL,
129 x_s_middle_name IN VARCHAR2 DEFAULT NULL,
130 x_s_permt_addr1 IN VARCHAR2 DEFAULT NULL,
131 x_s_permt_addr2 IN VARCHAR2 DEFAULT NULL,
132 x_s_permt_city IN VARCHAR2 DEFAULT NULL,
133 x_s_permt_state IN VARCHAR2 DEFAULT NULL,
134 x_s_permt_zip IN VARCHAR2 DEFAULT NULL,
135 x_s_permt_addr_chg_date IN DATE DEFAULT NULL,
136 x_s_permt_phone IN VARCHAR2 DEFAULT NULL,
137 x_s_local_addr1 IN VARCHAR2 DEFAULT NULL,
138 x_s_local_addr2 IN VARCHAR2 DEFAULT NULL,
139 x_s_local_city IN VARCHAR2 DEFAULT NULL,
140 x_s_local_state IN VARCHAR2 DEFAULT NULL,
141 x_s_local_zip IN VARCHAR2 DEFAULT NULL,
142 x_s_local_addr_chg_date IN DATE DEFAULT NULL,
143 x_s_email_addr IN VARCHAR2 DEFAULT NULL,
144 x_s_date_of_birth IN DATE DEFAULT NULL,
145 x_s_dob_chg_date IN DATE DEFAULT NULL,
146 x_s_license_num IN VARCHAR2 DEFAULT NULL,
147 x_s_license_state IN VARCHAR2 DEFAULT NULL,
148 x_s_depncy_status IN VARCHAR2 DEFAULT NULL,
149 x_s_default_status IN VARCHAR2 DEFAULT NULL,
150 x_s_citizenship_status IN VARCHAR2 DEFAULT NULL,
151 x_s_alien_reg_num IN VARCHAR2 DEFAULT NULL,
152 x_s_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
153 x_creation_date IN DATE DEFAULT NULL,
154 x_created_by IN NUMBER DEFAULT NULL,
155 x_last_update_date IN DATE DEFAULT NULL,
156 x_last_updated_by IN NUMBER DEFAULT NULL,
157 x_last_update_login IN NUMBER DEFAULT NULL,
158 x_pnote_batch_id IN VARCHAR2 DEFAULT NULL,
159 x_pnote_ack_date IN DATE DEFAULT NULL,
160 x_pnote_mpn_ind IN VARCHAR2 DEFAULT NULL,
161 x_award_id IN NUMBER DEFAULT NULL,
162 x_base_id IN NUMBER DEFAULT NULL,
163 x_document_id_txt IN VARCHAR2 DEFAULT NULL,
164 x_loan_key_num IN NUMBER DEFAULT NULL,
165 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
166 x_fin_award_year IN VARCHAR2 DEFAULT NULL,
167 x_cps_trans_num IN NUMBER DEFAULT NULL,
168 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
169 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
170 x_source_entity_id_txt IN VARCHAR2 DEFAULT NULL,
171 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
172 x_pymt_servicer_date IN DATE DEFAULT NULL,
173 x_book_loan_amt IN NUMBER DEFAULT NULL,
174 x_book_loan_amt_date IN DATE DEFAULT NULL,
175 x_s_chg_birth_date IN DATE DEFAULT NULL,
176 x_s_chg_ssn IN VARCHAR2 DEFAULT NULL,
177 x_s_chg_last_name IN VARCHAR2 DEFAULT NULL,
178 x_b_chg_birth_date IN DATE DEFAULT NULL,
179 x_b_chg_ssn IN VARCHAR2 DEFAULT NULL,
180 x_b_chg_last_name IN VARCHAR2 DEFAULT NULL,
181 x_note_message IN VARCHAR2 DEFAULT NULL,
182 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
183 x_s_permt_county IN VARCHAR2 DEFAULT NULL,
184 x_b_permt_county IN VARCHAR2 DEFAULT NULL,
185 x_s_permt_country IN VARCHAR2 DEFAULT NULL,
186 x_b_permt_country IN VARCHAR2 DEFAULT NULL,
187 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
188 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
189 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
190 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
191 x_requested_loan_amt IN NUMBER DEFAULT NULL,
192 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
193 x_reinstatement_amt IN NUMBER DEFAULT NULL,
194 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
195 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
196 x_fls_approved_amt IN NUMBER DEFAULT NULL,
197 x_flu_approved_amt IN NUMBER DEFAULT NULL,
198 x_flp_approved_amt IN NUMBER DEFAULT NULL,
199 x_alt_approved_amt IN NUMBER DEFAULT NULL,
200 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
201 x_alt_borrower_ind_flag IN VARCHAR2 DEFAULT NULL,
202 x_school_id_txt IN VARCHAR2 DEFAULT NULL,
203 x_cost_of_attendance_amt IN NUMBER DEFAULT NULL,
204 x_established_fin_aid_amount IN NUMBER DEFAULT NULL,
205 x_student_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
206 x_mpn_type_flag IN VARCHAR2 DEFAULT NULL,
207 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
208 x_expect_family_contribute_amt IN NUMBER DEFAULT NULL,
209 x_borower_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
210 x_borower_credit_authoriz_flag IN VARCHAR2 DEFAULT NULL,
211 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL
212 ) AS
213 /*
214 || Created By : venagara
215 || Created On : 22-JAN-2001
216 || Purpose : Initialises the Old and New references for the columns of the table.
217 || Known limitations, enhancements or remarks :
218 || Change History :
219 || Who When What
220 || (reverse chronological order - newest change first)
221 */
222
223 CURSOR cur_old_ref_values IS
224 SELECT *
225 FROM IGF_SL_LOR_LOC_ALL
226 WHERE rowid = x_rowid;
227
228 BEGIN
229
230 l_rowid := x_rowid;
231
232 -- Code for setting the Old and New Reference Values.
233 -- Populate Old Values.
234 OPEN cur_old_ref_values;
235 FETCH cur_old_ref_values INTO old_references;
236 IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
237 CLOSE cur_old_ref_values;
238 fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
239 igs_ge_msg_stack.add;
240 app_exception.raise_exception;
241 RETURN;
242 END IF;
243 CLOSE cur_old_ref_values;
244
245 -- Populate New Values.
246 new_references.loan_id := x_loan_id;
247 new_references.origination_id := x_origination_id;
248 new_references.loan_number := x_loan_number;
249 new_references.loan_type := x_loan_type;
253 new_references.loan_per_end_date := x_loan_per_end_date;
250 new_references.loan_amt_offered := x_loan_amt_offered;
251 new_references.loan_amt_accepted := x_loan_amt_accepted;
252 new_references.loan_per_begin_date := x_loan_per_begin_date;
254 new_references.acad_yr_begin_date := x_acad_yr_begin_date;
255 new_references.acad_yr_end_date := x_acad_yr_end_date;
256 new_references.loan_status := x_loan_status;
257 new_references.loan_status_date := x_loan_status_date;
258 new_references.loan_chg_status := x_loan_chg_status;
259 new_references.loan_chg_status_date := x_loan_chg_status_date;
260 new_references.req_serial_loan_code := x_req_serial_loan_code;
261 new_references.act_serial_loan_code := x_act_serial_loan_code;
262 new_references.active := x_active;
263 new_references.active_date := x_active_date;
264 new_references.sch_cert_date := x_sch_cert_date;
265 new_references.orig_status_flag := x_orig_status_flag;
266 new_references.orig_batch_id := x_orig_batch_id;
267 new_references.orig_batch_date := x_orig_batch_date;
268 new_references.chg_batch_id := x_chg_batch_id;
269 new_references.orig_ack_date := x_orig_ack_date;
270 new_references.credit_override := x_credit_override;
271 new_references.credit_decision_date := x_credit_decision_date;
272 new_references.pnote_delivery_code := x_pnote_delivery_code;
273 new_references.pnote_status := x_pnote_status;
274 new_references.pnote_status_date := x_pnote_status_date;
275 new_references.pnote_id := x_pnote_id;
276 new_references.pnote_print_ind := x_pnote_print_ind;
277 new_references.pnote_accept_amt := x_pnote_accept_amt;
278 new_references.pnote_accept_date := x_pnote_accept_date;
279 new_references.p_signature_code := x_p_signature_code;
280 new_references.p_signature_date := x_p_signature_date;
281 new_references.s_signature_code := x_s_signature_code;
282 new_references.unsub_elig_for_heal := x_unsub_elig_for_heal;
283 new_references.disclosure_print_ind := x_disclosure_print_ind;
284 new_references.orig_fee_perct := x_orig_fee_perct;
285 new_references.borw_confirm_ind := x_borw_confirm_ind;
286 new_references.borw_interest_ind := x_borw_interest_ind;
287 new_references.unsub_elig_for_depnt := x_unsub_elig_for_depnt;
288 new_references.guarantee_amt := x_guarantee_amt;
289 new_references.guarantee_date := x_guarantee_date;
290 new_references.guarnt_adj_ind := x_guarnt_adj_ind;
291 new_references.guarnt_amt_redn_code := x_guarnt_amt_redn_code;
292 new_references.guarnt_status_code := x_guarnt_status_code;
293 new_references.guarnt_status_date := x_guarnt_status_date;
294 new_references.lend_apprv_denied_code := x_lend_apprv_denied_code;
295 new_references.lend_apprv_denied_date := x_lend_apprv_denied_date;
296 new_references.lend_status_code := x_lend_status_code;
297 new_references.lend_status_date := x_lend_status_date;
298 new_references.grade_level_code := x_grade_level_code;
299 new_references.enrollment_code := x_enrollment_code;
300 new_references.anticip_compl_date := x_anticip_compl_date;
301 new_references.borw_lender_id := x_borw_lender_id;
302 new_references.guarantor_id := x_guarantor_id;
303 new_references.prc_type_code := x_prc_type_code;
304 new_references.rec_type_ind := x_rec_type_ind;
305 new_references.cl_loan_type := x_cl_loan_type;
306 new_references.cl_seq_number := x_cl_seq_number;
307 new_references.last_resort_lender := x_last_resort_lender;
308 new_references.lender_id := x_lender_id;
309 new_references.lend_non_ed_brc_id := x_lend_non_ed_brc_id;
310 new_references.recipient_id := x_recipient_id;
311 new_references.recipient_type := x_recipient_type;
312 new_references.recip_non_ed_brc_id := x_recip_non_ed_brc_id;
313 new_references.cl_rec_status := x_cl_rec_status;
314 new_references.cl_rec_status_last_update := x_cl_rec_status_last_update;
315 new_references.alt_prog_type_code := x_alt_prog_type_code;
316 new_references.alt_appl_ver_code := x_alt_appl_ver_code;
317 new_references.borw_outstd_loan_code := x_borw_outstd_loan_code;
318 new_references.mpn_confirm_code := x_mpn_confirm_code;
319 new_references.resp_to_orig_code := x_resp_to_orig_code;
320 new_references.appl_loan_phase_code := x_appl_loan_phase_code;
321 new_references.appl_loan_phase_code_chg := x_appl_loan_phase_code_chg;
322 new_references.tot_outstd_stafford := x_tot_outstd_stafford;
323 new_references.tot_outstd_plus := x_tot_outstd_plus;
324 new_references.alt_borw_tot_debt := x_alt_borw_tot_debt;
325 new_references.act_interest_rate := x_act_interest_rate;
329 new_references.sch_refund_date := x_sch_refund_date;
326 new_references.service_type_code := x_service_type_code;
327 new_references.rev_notice_of_guarnt := x_rev_notice_of_guarnt;
328 new_references.sch_refund_amt := x_sch_refund_amt;
330 new_references.uniq_layout_vend_code := x_uniq_layout_vend_code;
331 new_references.uniq_layout_ident_code := x_uniq_layout_ident_code;
332 new_references.p_person_id := x_p_person_id;
333 new_references.p_ssn := x_p_ssn;
334 new_references.p_ssn_chg_date := x_p_ssn_chg_date;
335 new_references.p_last_name := x_p_last_name;
336 new_references.p_first_name := x_p_first_name;
337 new_references.p_middle_name := x_p_middle_name;
338 new_references.p_permt_addr1 := x_p_permt_addr1;
339 new_references.p_permt_addr2 := x_p_permt_addr2;
340 new_references.p_permt_city := x_p_permt_city;
341 new_references.p_permt_state := x_p_permt_state;
342 new_references.p_permt_zip := x_p_permt_zip;
343 new_references.p_permt_addr_chg_date := x_p_permt_addr_chg_date;
344 new_references.p_permt_phone := x_p_permt_phone;
345 new_references.p_email_addr := x_p_email_addr;
346 new_references.p_date_of_birth := x_p_date_of_birth;
347 new_references.p_dob_chg_date := x_p_dob_chg_date;
348 new_references.p_license_num := x_p_license_num;
349 new_references.p_license_state := x_p_license_state;
350 new_references.p_citizenship_status := x_p_citizenship_status;
351 new_references.p_alien_reg_num := x_p_alien_reg_num;
352 new_references.p_default_status := x_p_default_status;
353 new_references.p_foreign_postal_code := x_p_foreign_postal_code;
354 new_references.p_state_of_legal_res := x_p_state_of_legal_res;
355 new_references.p_legal_res_date := x_p_legal_res_date;
356 new_references.s_ssn := x_s_ssn;
357 new_references.s_ssn_chg_date := x_s_ssn_chg_date;
358 new_references.s_last_name := x_s_last_name;
359 new_references.s_first_name := x_s_first_name;
360 new_references.s_middle_name := x_s_middle_name;
361 new_references.s_permt_addr1 := x_s_permt_addr1;
362 new_references.s_permt_addr2 := x_s_permt_addr2;
363 new_references.s_permt_city := x_s_permt_city;
364 new_references.s_permt_state := x_s_permt_state;
365 new_references.s_permt_zip := x_s_permt_zip;
366 new_references.s_permt_addr_chg_date := x_s_permt_addr_chg_date;
367 new_references.s_permt_phone := x_s_permt_phone;
368 new_references.s_local_addr1 := x_s_local_addr1;
369 new_references.s_local_addr2 := x_s_local_addr2;
370 new_references.s_local_city := x_s_local_city;
371 new_references.s_local_state := x_s_local_state;
372 new_references.s_local_zip := x_s_local_zip;
373 new_references.s_local_addr_chg_date := x_s_local_addr_chg_date;
374 new_references.s_email_addr := x_s_email_addr;
375 new_references.s_date_of_birth := x_s_date_of_birth;
376 new_references.s_dob_chg_date := x_s_dob_chg_date;
377 new_references.s_license_num := x_s_license_num;
378 new_references.s_license_state := x_s_license_state;
379 new_references.s_depncy_status := x_s_depncy_status;
380 new_references.s_default_status := x_s_default_status;
381 new_references.s_citizenship_status := x_s_citizenship_status;
382 new_references.s_alien_reg_num := x_s_alien_reg_num;
383 new_references.s_foreign_postal_code := x_s_foreign_postal_code;
384
385 IF (p_action = 'UPDATE') THEN
386 new_references.creation_date := old_references.creation_date;
387 new_references.created_by := old_references.created_by;
388 ELSE
389 new_references.creation_date := x_creation_date;
390 new_references.created_by := x_created_by;
391 END IF;
392
393 new_references.last_update_date := x_last_update_date;
394 new_references.last_updated_by := x_last_updated_by;
395 new_references.last_update_login := x_last_update_login;
396
397 new_references.pnote_batch_id := x_pnote_batch_id;
398 new_references.pnote_ack_date := x_pnote_ack_date;
399 new_references.pnote_mpn_ind := x_pnote_mpn_ind;
400 new_references.award_id := x_award_id;
401 new_references.base_id := x_base_id;
402 new_references.document_id_txt := x_document_id_txt;
403 new_references.loan_key_num := x_loan_key_num;
404 new_references.interest_rebate_percent_num := x_interest_rebate_percent_num;
405 new_references.fin_award_year := x_fin_award_year;
406 new_references.cps_trans_num := x_cps_trans_num;
407 new_references.atd_entity_id_txt := x_atd_entity_id_txt;
411 new_references.pymt_servicer_date := x_pymt_servicer_date;
408 new_references.rep_entity_id_txt := x_rep_entity_id_txt;
409 new_references.source_entity_id_txt := x_source_entity_id_txt;
410 new_references.pymt_servicer_amt := x_pymt_servicer_amt;
412 new_references.book_loan_amt := x_book_loan_amt;
413 new_references.book_loan_amt_date := x_book_loan_amt_date;
414 new_references.s_chg_birth_date := x_s_chg_birth_date;
415 new_references.s_chg_ssn := x_s_chg_ssn;
416 new_references.s_chg_last_name := x_s_chg_last_name;
417 new_references.b_chg_birth_date := x_b_chg_birth_date;
418 new_references.b_chg_ssn := x_b_chg_ssn;
419 new_references.b_chg_last_name := x_b_chg_last_name;
420 new_references.note_message := x_note_message;
421 new_references.full_resp_code := x_full_resp_code;
422 new_references.s_permt_county := x_s_permt_county;
423 new_references.b_permt_county := x_b_permt_county;
424 new_references.s_permt_country := x_s_permt_country;
425 new_references.b_permt_country := x_b_permt_country;
426 new_references.crdt_decision_status := x_crdt_decision_status;
427 new_references.external_loan_id_txt := x_external_loan_id_txt ;
428 new_references.deferment_request_code := x_deferment_request_code ;
429 new_references.eft_authorization_code := x_eft_authorization_code ;
430 new_references.requested_loan_amt := x_requested_loan_amt ;
431 new_references.actual_record_type_code := x_actual_record_type_code ;
432 new_references.reinstatement_amt := x_reinstatement_amt ;
433 new_references.lender_use_txt := x_lender_use_txt ;
434 new_references.guarantor_use_txt := x_guarantor_use_txt ;
435 new_references.fls_approved_amt := x_fls_approved_amt ;
436 new_references.flu_approved_amt := x_flu_approved_amt ;
437 new_references.flp_approved_amt := x_flp_approved_amt ;
438 new_references.alt_approved_amt := x_alt_approved_amt ;
439 new_references.loan_app_form_code := x_loan_app_form_code ;
440 new_references.alt_borrower_ind_flag := x_alt_borrower_ind_flag ;
441 new_references.school_id_txt := x_school_id_txt ;
442 new_references.cost_of_attendance_amt := x_cost_of_attendance_amt ;
443 new_references.established_fin_aid_amount := x_established_fin_aid_amount ;
444 new_references.student_electronic_sign_flag := x_student_electronic_sign_flag ;
445 new_references.mpn_type_flag := x_mpn_type_flag ;
446 new_references.school_use_txt := x_school_use_txt ;
447 new_references.expect_family_contribute_amt := x_expect_family_contribute_amt ;
448 new_references.borower_electronic_sign_flag := x_borower_electronic_sign_flag ;
449 new_references.borower_credit_authoriz_flag := x_borower_credit_authoriz_flag ;
450 new_references.esign_src_typ_cd := x_esign_src_typ_cd ;
451
452 END set_column_values;
453
454
455 PROCEDURE check_uniqueness AS
456 /*
457 || Created By : venagara
458 || Created On : 22-JAN-2001
459 || Purpose : Handles the Unique Constraint logic defined for the columns.
460 || Known limitations, enhancements or remarks :
461 || Change History :
462 || Who When What
463 || (reverse chronological order - newest change first)
464 */
465 BEGIN
466
467 IF ( get_uk_for_validation (
468 new_references.origination_id
469 )
470 ) THEN
471 fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
472 igs_ge_msg_stack.add;
473 app_exception.raise_exception;
474 END IF;
475
476 END check_uniqueness;
477
478
479 PROCEDURE check_parent_existance AS
480 /*
481 || Created By : venagara
482 || Created On : 22-JAN-2001
483 || Purpose : Checks for the existance of Parent records.
484 || Known limitations, enhancements or remarks :
485 || Change History :
486 || Who When What
487 || (reverse chronological order - newest change first)
488 */
489 BEGIN
490
491 IF (((old_references.origination_id = new_references.origination_id)) OR
492 ((new_references.origination_id IS NULL))) THEN
493 NULL;
494 ELSIF NOT igf_sl_lor_pkg.get_pk_for_validation (
495 new_references.origination_id
496 ) THEN
497 fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
498 igs_ge_msg_stack.add;
499 app_exception.raise_exception;
500 END IF;
501
502 IF (((old_references.award_id = new_references.award_id)) OR
503 ((new_references.award_id IS NULL))) THEN
504 NULL;
505 ELSIF NOT igf_aw_award_pkg.get_pk_for_validation (
506 new_references.award_id
507 ) THEN
508 fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
509 igs_ge_msg_stack.add;
510 app_exception.raise_exception;
511 END IF;
515 NULL;
512
513 IF (((old_references.base_id = new_references.base_id)) OR
514 ((new_references.base_id IS NULL))) THEN
516 ELSIF NOT igf_ap_fa_base_rec_pkg.get_pk_for_validation (
517 new_references.base_id
518 ) THEN
519 fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
520 igs_ge_msg_stack.add;
521 app_exception.raise_exception;
522 END IF;
523
524 END check_parent_existance;
525
526
527 FUNCTION get_pk_for_validation (
528 x_loan_id IN NUMBER
529 ) RETURN BOOLEAN AS
530 /*
531 || Created By : venagara
532 || Created On : 22-JAN-2001
533 || Purpose : Validates the Primary Key of the table.
534 || Known limitations, enhancements or remarks :
535 || Change History :
536 || Who When What
537 || (reverse chronological order - newest change first)
538 */
539 CURSOR cur_rowid IS
540 SELECT rowid
541 FROM igf_sl_lor_loc_all
542 WHERE loan_id = x_loan_id
543 FOR UPDATE NOWAIT;
544
545 lv_rowid cur_rowid%RowType;
546
547 BEGIN
548
549 OPEN cur_rowid;
550 FETCH cur_rowid INTO lv_rowid;
551 IF (cur_rowid%FOUND) THEN
552 CLOSE cur_rowid;
553 RETURN(TRUE);
554 ELSE
555 CLOSE cur_rowid;
556 RETURN(FALSE);
557 END IF;
558
559 END get_pk_for_validation;
560
561
562 FUNCTION get_uk_for_validation (
563 x_origination_id IN NUMBER
564 ) RETURN BOOLEAN AS
565 /*
566 || Created By : venagara
567 || Created On : 22-JAN-2001
568 || Purpose : Validates the Unique Keys of the table.
569 || Known limitations, enhancements or remarks :
570 || Change History :
571 || Who When What
572 || (reverse chronological order - newest change first)
573 */
574 CURSOR cur_rowid IS
575 SELECT rowid
576 FROM igf_sl_lor_loc_all
577 WHERE origination_id = x_origination_id
578 AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
579
580 lv_rowid cur_rowid%RowType;
581
582 BEGIN
583
584 OPEN cur_rowid;
585 FETCH cur_rowid INTO lv_rowid;
586 IF (cur_rowid%FOUND) THEN
587 CLOSE cur_rowid;
588 RETURN (true);
589 ELSE
590 CLOSE cur_rowid;
591 RETURN(FALSE);
592 END IF;
593
594 END get_uk_for_validation ;
595
596
597 PROCEDURE get_fk_igf_sl_lor (
598 x_origination_id IN NUMBER
599 ) AS
600 /*
601 || Created By : venagara
602 || Created On : 22-JAN-2001
603 || Purpose : Validates the Foreign Keys for the table.
604 || Known limitations, enhancements or remarks :
605 || Change History :
606 || Who When What
607 || (reverse chronological order - newest change first)
608 */
609 CURSOR cur_rowid IS
610 SELECT rowid
611 FROM igf_sl_lor_loc_all
612 WHERE ((origination_id = x_origination_id));
613
614 lv_rowid cur_rowid%RowType;
615
616 BEGIN
617
618 OPEN cur_rowid;
619 FETCH cur_rowid INTO lv_rowid;
620 IF (cur_rowid%FOUND) THEN
621 CLOSE cur_rowid;
622 fnd_message.set_name ('IGF', 'IGF_SL_LORL_LOR_FK');
623 igs_ge_msg_stack.add;
624 app_exception.raise_exception;
625 RETURN;
626 END IF;
627 CLOSE cur_rowid;
628
629 END get_fk_igf_sl_lor;
630
631 PROCEDURE get_fk_igf_aw_award (
632 x_award_id IN NUMBER
633 ) AS
634
635 CURSOR cur_rowid IS
636 SELECT rowid
637 FROM igf_sl_lor_loc_all
638 WHERE ((award_id = x_award_id));
639
640 lv_rowid cur_rowid%RowType;
641
642 BEGIN
643
644 OPEN cur_rowid;
645 FETCH cur_rowid INTO lv_rowid;
646 IF (cur_rowid%FOUND) THEN
647 CLOSE cur_rowid;
648 fnd_message.set_name ('IGF', 'IGF_AW_AWD_LORLOC_FK');
649 igs_ge_msg_stack.add;
650 app_exception.raise_exception;
651 RETURN;
652 END IF;
653 CLOSE cur_rowid;
654
655 END get_fk_igf_aw_award;
656
657 PROCEDURE get_fk_igf_ap_fa_base_rec (
658 x_base_id IN NUMBER
659 ) AS
660
661 CURSOR cur_rowid IS
662 SELECT rowid
663 FROM igf_sl_lor_loc_all
664 WHERE ((base_id = x_base_id));
665
666 lv_rowid cur_rowid%RowType;
667
668 BEGIN
669
670 OPEN cur_rowid;
671 FETCH cur_rowid INTO lv_rowid;
672 IF (cur_rowid%FOUND) THEN
673 CLOSE cur_rowid;
674 fnd_message.set_name ('IGF', 'IGF_AP_FABASE_LORLOC_FK');
675 igs_ge_msg_stack.add;
676 app_exception.raise_exception;
677 RETURN;
678 END IF;
679 CLOSE cur_rowid;
680
681 END get_fk_igf_ap_fa_base_rec;
682
683
684 PROCEDURE before_dml (
685 p_action IN VARCHAR2,
686 x_rowid IN VARCHAR2 DEFAULT NULL,
690 x_loan_type IN VARCHAR2 DEFAULT NULL,
687 x_loan_id IN NUMBER DEFAULT NULL,
688 x_origination_id IN NUMBER DEFAULT NULL,
689 x_loan_number IN VARCHAR2 DEFAULT NULL,
691 x_loan_amt_offered IN NUMBER DEFAULT NULL,
692 x_loan_amt_accepted IN NUMBER DEFAULT NULL,
693 x_loan_per_begin_date IN DATE DEFAULT NULL,
694 x_loan_per_end_date IN DATE DEFAULT NULL,
695 x_acad_yr_begin_date IN DATE DEFAULT NULL,
696 x_acad_yr_end_date IN DATE DEFAULT NULL,
697 x_loan_status IN VARCHAR2 DEFAULT NULL,
698 x_loan_status_date IN DATE DEFAULT NULL,
699 x_loan_chg_status IN VARCHAR2 DEFAULT NULL,
700 x_loan_chg_status_date IN DATE DEFAULT NULL,
701 x_req_serial_loan_code IN VARCHAR2 DEFAULT NULL,
702 x_act_serial_loan_code IN VARCHAR2 DEFAULT NULL,
703 x_active IN VARCHAR2 DEFAULT NULL,
704 x_active_date IN DATE DEFAULT NULL,
705 x_sch_cert_date IN DATE DEFAULT NULL,
706 x_orig_status_flag IN VARCHAR2 DEFAULT NULL,
707 x_orig_batch_id IN VARCHAR2 DEFAULT NULL,
708 x_orig_batch_date IN DATE DEFAULT NULL,
709 x_chg_batch_id IN VARCHAR2 DEFAULT NULL,
710 x_orig_ack_date IN DATE DEFAULT NULL,
711 x_credit_override IN VARCHAR2 DEFAULT NULL,
712 x_credit_decision_date IN DATE DEFAULT NULL,
713 x_pnote_delivery_code IN VARCHAR2 DEFAULT NULL,
714 x_pnote_status IN VARCHAR2 DEFAULT NULL,
715 x_pnote_status_date IN DATE DEFAULT NULL,
716 x_pnote_id IN VARCHAR2 DEFAULT NULL,
717 x_pnote_print_ind IN VARCHAR2 DEFAULT NULL,
718 x_pnote_accept_amt IN NUMBER DEFAULT NULL,
719 x_pnote_accept_date IN DATE DEFAULT NULL,
720 x_p_signature_code IN VARCHAR2 DEFAULT NULL,
721 x_p_signature_date IN DATE DEFAULT NULL,
722 x_s_signature_code IN VARCHAR2 DEFAULT NULL,
723 x_unsub_elig_for_heal IN VARCHAR2 DEFAULT NULL,
724 x_disclosure_print_ind IN VARCHAR2 DEFAULT NULL,
725 x_orig_fee_perct IN NUMBER DEFAULT NULL,
726 x_borw_confirm_ind IN VARCHAR2 DEFAULT NULL,
727 x_borw_interest_ind IN VARCHAR2 DEFAULT NULL,
728 x_unsub_elig_for_depnt IN VARCHAR2 DEFAULT NULL,
729 x_guarantee_amt IN NUMBER DEFAULT NULL,
730 x_guarantee_date IN DATE DEFAULT NULL,
731 x_guarnt_adj_ind IN VARCHAR2 DEFAULT NULL,
732 x_guarnt_amt_redn_code IN VARCHAR2 DEFAULT NULL,
733 x_guarnt_status_code IN VARCHAR2 DEFAULT NULL,
734 x_guarnt_status_date IN DATE DEFAULT NULL,
735 x_lend_apprv_denied_code IN VARCHAR2 DEFAULT NULL,
736 x_lend_apprv_denied_date IN DATE DEFAULT NULL,
737 x_lend_status_code IN VARCHAR2 DEFAULT NULL,
738 x_lend_status_date IN DATE DEFAULT NULL,
739 x_grade_level_code IN VARCHAR2 DEFAULT NULL,
740 x_enrollment_code IN VARCHAR2 DEFAULT NULL,
741 x_anticip_compl_date IN DATE DEFAULT NULL,
742 x_borw_lender_id IN VARCHAR2 DEFAULT NULL,
743 x_duns_borw_lender_id IN VARCHAR2 DEFAULT NULL,
744 x_guarantor_id IN VARCHAR2 DEFAULT NULL,
745 x_duns_guarnt_id IN VARCHAR2 DEFAULT NULL,
746 x_prc_type_code IN VARCHAR2 DEFAULT NULL,
747 x_rec_type_ind IN VARCHAR2 DEFAULT NULL,
748 x_cl_loan_type IN VARCHAR2 DEFAULT NULL,
749 x_cl_seq_number IN NUMBER DEFAULT NULL,
750 x_last_resort_lender IN VARCHAR2 DEFAULT NULL,
751 x_lender_id IN VARCHAR2 DEFAULT NULL,
752 x_duns_lender_id IN VARCHAR2 DEFAULT NULL,
753 x_lend_non_ed_brc_id IN VARCHAR2 DEFAULT NULL,
754 x_recipient_id IN VARCHAR2 DEFAULT NULL,
755 x_recipient_type IN VARCHAR2 DEFAULT NULL,
756 x_duns_recip_id IN VARCHAR2 DEFAULT NULL,
757 x_recip_non_ed_brc_id IN VARCHAR2 DEFAULT NULL,
758 x_cl_rec_status IN VARCHAR2 DEFAULT NULL,
759 x_cl_rec_status_last_update IN DATE DEFAULT NULL,
760 x_alt_prog_type_code IN VARCHAR2 DEFAULT NULL,
761 x_alt_appl_ver_code IN NUMBER DEFAULT NULL,
762 x_borw_outstd_loan_code IN VARCHAR2 DEFAULT NULL,
763 x_mpn_confirm_code IN VARCHAR2 DEFAULT NULL,
767 x_tot_outstd_stafford IN NUMBER DEFAULT NULL,
764 x_resp_to_orig_code IN VARCHAR2 DEFAULT NULL,
765 x_appl_loan_phase_code IN VARCHAR2 DEFAULT NULL,
766 x_appl_loan_phase_code_chg IN DATE DEFAULT NULL,
768 x_tot_outstd_plus IN NUMBER DEFAULT NULL,
769 x_alt_borw_tot_debt IN NUMBER DEFAULT NULL,
770 x_act_interest_rate IN NUMBER DEFAULT NULL,
771 x_service_type_code IN VARCHAR2 DEFAULT NULL,
772 x_rev_notice_of_guarnt IN VARCHAR2 DEFAULT NULL,
773 x_sch_refund_amt IN NUMBER DEFAULT NULL,
774 x_sch_refund_date IN DATE DEFAULT NULL,
775 x_uniq_layout_vend_code IN VARCHAR2 DEFAULT NULL,
776 x_uniq_layout_ident_code IN VARCHAR2 DEFAULT NULL,
777 x_p_person_id IN NUMBER DEFAULT NULL,
778 x_p_ssn IN VARCHAR2 DEFAULT NULL,
779 x_p_ssn_chg_date IN DATE DEFAULT NULL,
780 x_p_last_name IN VARCHAR2 DEFAULT NULL,
781 x_p_first_name IN VARCHAR2 DEFAULT NULL,
782 x_p_middle_name IN VARCHAR2 DEFAULT NULL,
783 x_p_permt_addr1 IN VARCHAR2 DEFAULT NULL,
784 x_p_permt_addr2 IN VARCHAR2 DEFAULT NULL,
785 x_p_permt_city IN VARCHAR2 DEFAULT NULL,
786 x_p_permt_state IN VARCHAR2 DEFAULT NULL,
787 x_p_permt_zip IN VARCHAR2 DEFAULT NULL,
788 x_p_permt_addr_chg_date IN DATE DEFAULT NULL,
789 x_p_permt_phone IN VARCHAR2 DEFAULT NULL,
790 x_p_email_addr IN VARCHAR2 DEFAULT NULL,
791 x_p_date_of_birth IN DATE DEFAULT NULL,
792 x_p_dob_chg_date IN DATE DEFAULT NULL,
793 x_p_license_num IN VARCHAR2 DEFAULT NULL,
794 x_p_license_state IN VARCHAR2 DEFAULT NULL,
795 x_p_citizenship_status IN VARCHAR2 DEFAULT NULL,
796 x_p_alien_reg_num IN VARCHAR2 DEFAULT NULL,
797 x_p_default_status IN VARCHAR2 DEFAULT NULL,
798 x_p_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
799 x_p_state_of_legal_res IN VARCHAR2 DEFAULT NULL,
800 x_p_legal_res_date IN DATE DEFAULT NULL,
801 x_s_ssn IN VARCHAR2 DEFAULT NULL,
802 x_s_ssn_chg_date IN DATE DEFAULT NULL,
803 x_s_last_name IN VARCHAR2 DEFAULT NULL,
804 x_s_first_name IN VARCHAR2 DEFAULT NULL,
805 x_s_middle_name IN VARCHAR2 DEFAULT NULL,
806 x_s_permt_addr1 IN VARCHAR2 DEFAULT NULL,
807 x_s_permt_addr2 IN VARCHAR2 DEFAULT NULL,
808 x_s_permt_city IN VARCHAR2 DEFAULT NULL,
809 x_s_permt_state IN VARCHAR2 DEFAULT NULL,
810 x_s_permt_zip IN VARCHAR2 DEFAULT NULL,
811 x_s_permt_addr_chg_date IN DATE DEFAULT NULL,
812 x_s_permt_phone IN VARCHAR2 DEFAULT NULL,
813 x_s_local_addr1 IN VARCHAR2 DEFAULT NULL,
814 x_s_local_addr2 IN VARCHAR2 DEFAULT NULL,
815 x_s_local_city IN VARCHAR2 DEFAULT NULL,
816 x_s_local_state IN VARCHAR2 DEFAULT NULL,
817 x_s_local_zip IN VARCHAR2 DEFAULT NULL,
818 x_s_local_addr_chg_date IN DATE DEFAULT NULL,
819 x_s_email_addr IN VARCHAR2 DEFAULT NULL,
820 x_s_date_of_birth IN DATE DEFAULT NULL,
821 x_s_dob_chg_date IN DATE DEFAULT NULL,
822 x_s_license_num IN VARCHAR2 DEFAULT NULL,
823 x_s_license_state IN VARCHAR2 DEFAULT NULL,
824 x_s_depncy_status IN VARCHAR2 DEFAULT NULL,
825 x_s_default_status IN VARCHAR2 DEFAULT NULL,
826 x_s_citizenship_status IN VARCHAR2 DEFAULT NULL,
827 x_s_alien_reg_num IN VARCHAR2 DEFAULT NULL,
828 x_s_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
829 x_creation_date IN DATE DEFAULT NULL,
830 x_created_by IN NUMBER DEFAULT NULL,
831 x_last_update_date IN DATE DEFAULT NULL,
832 x_last_updated_by IN NUMBER DEFAULT NULL,
833 x_last_update_login IN NUMBER DEFAULT NULL,
834 x_pnote_batch_id IN VARCHAR2 DEFAULT NULL,
835 x_pnote_ack_date IN DATE DEFAULT NULL,
836 x_pnote_mpn_ind IN VARCHAR2 DEFAULT NULL,
837 x_award_id IN NUMBER DEFAULT NULL,
838 x_base_id IN NUMBER DEFAULT NULL,
839 x_document_id_txt IN VARCHAR2 DEFAULT NULL,
840 x_loan_key_num IN NUMBER DEFAULT NULL,
844 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
841 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
842 x_fin_award_year IN VARCHAR2 DEFAULT NULL,
843 x_cps_trans_num IN NUMBER DEFAULT NULL,
845 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
846 x_source_entity_id_txt IN VARCHAR2 DEFAULT NULL,
847 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
848 x_pymt_servicer_date IN DATE DEFAULT NULL,
849 x_book_loan_amt IN NUMBER DEFAULT NULL,
850 x_book_loan_amt_date IN DATE DEFAULT NULL,
851 x_s_chg_birth_date IN DATE DEFAULT NULL,
852 x_s_chg_ssn IN VARCHAR2 DEFAULT NULL,
853 x_s_chg_last_name IN VARCHAR2 DEFAULT NULL,
854 x_b_chg_birth_date IN DATE DEFAULT NULL,
855 x_b_chg_ssn IN VARCHAR2 DEFAULT NULL,
856 x_b_chg_last_name IN VARCHAR2 DEFAULT NULL,
857 x_note_message IN VARCHAR2 DEFAULT NULL,
858 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
859 x_s_permt_county IN VARCHAR2 DEFAULT NULL,
860 x_b_permt_county IN VARCHAR2 DEFAULT NULL,
861 x_s_permt_country IN VARCHAR2 DEFAULT NULL,
862 x_b_permt_country IN VARCHAR2 DEFAULT NULL,
863 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
864 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
865 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
866 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
867 x_requested_loan_amt IN NUMBER DEFAULT NULL,
868 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
869 x_reinstatement_amt IN NUMBER DEFAULT NULL,
870 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
871 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
872 x_fls_approved_amt IN NUMBER DEFAULT NULL,
873 x_flu_approved_amt IN NUMBER DEFAULT NULL,
874 x_flp_approved_amt IN NUMBER DEFAULT NULL,
875 x_alt_approved_amt IN NUMBER DEFAULT NULL,
876 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
877 x_alt_borrower_ind_flag IN VARCHAR2 DEFAULT NULL,
878 x_school_id_txt IN VARCHAR2 DEFAULT NULL,
879 x_cost_of_attendance_amt IN NUMBER DEFAULT NULL,
880 x_established_fin_aid_amount IN NUMBER DEFAULT NULL,
881 x_student_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
882 x_mpn_type_flag IN VARCHAR2 DEFAULT NULL,
883 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
884 x_expect_family_contribute_amt IN NUMBER DEFAULT NULL,
885 x_borower_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
886 x_borower_credit_authoriz_flag IN VARCHAR2 DEFAULT NULL,
887 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL
888
889 ) AS
890 /*
891 || Created By : venagara
892 || Created On : 22-JAN-2001
893 || Purpose : Initialises the columns, Checks Constraints, Calls the
894 || Trigger Handlers for the table, before any DML operation.
895 || Known limitations, enhancements or remarks :
896 || Change History :
897 || Who When What
898 || (reverse chronological order - newest change first)
899 */
900 BEGIN
901
902 set_column_values (
903 p_action,
904 x_rowid,
905 x_loan_id,
906 x_origination_id,
907 x_loan_number,
908 x_loan_type,
909 x_loan_amt_offered,
910 x_loan_amt_accepted,
911 x_loan_per_begin_date,
912 x_loan_per_end_date,
913 x_acad_yr_begin_date,
914 x_acad_yr_end_date,
915 x_loan_status,
916 x_loan_status_date,
917 x_loan_chg_status,
918 x_loan_chg_status_date,
919 x_req_serial_loan_code,
920 x_act_serial_loan_code,
921 x_active,
922 x_active_date,
923 x_sch_cert_date,
924 x_orig_status_flag,
925 x_orig_batch_id,
926 x_orig_batch_date,
927 x_chg_batch_id,
928 x_orig_ack_date,
929 x_credit_override,
930 x_credit_decision_date,
931 x_pnote_delivery_code,
932 x_pnote_status,
933 x_pnote_status_date,
934 x_pnote_id,
935 x_pnote_print_ind,
936 x_pnote_accept_amt,
937 x_pnote_accept_date,
938 x_p_signature_code,
939 x_p_signature_date,
940 x_s_signature_code,
941 x_unsub_elig_for_heal,
942 x_disclosure_print_ind,
943 x_orig_fee_perct,
944 x_borw_confirm_ind,
945 x_borw_interest_ind,
946 x_unsub_elig_for_depnt,
947 x_guarantee_amt,
948 x_guarantee_date,
949 x_guarnt_adj_ind,
950 x_guarnt_amt_redn_code,
951 x_guarnt_status_code,
952 x_guarnt_status_date,
953 x_lend_apprv_denied_code,
954 x_lend_apprv_denied_date,
955 x_lend_status_code,
956 x_lend_status_date,
957 x_grade_level_code,
958 x_enrollment_code,
959 x_anticip_compl_date,
960 x_borw_lender_id,
964 x_prc_type_code,
961 x_duns_borw_lender_id,
962 x_guarantor_id,
963 x_duns_guarnt_id,
965 x_rec_type_ind,
966 x_cl_loan_type,
967 x_cl_seq_number,
968 x_last_resort_lender,
969 x_lender_id,
970 x_duns_lender_id,
971 x_lend_non_ed_brc_id,
972 x_recipient_id,
973 x_recipient_type,
974 x_duns_recip_id,
975 x_recip_non_ed_brc_id,
976 x_cl_rec_status,
977 x_cl_rec_status_last_update,
978 x_alt_prog_type_code,
979 x_alt_appl_ver_code,
980 x_borw_outstd_loan_code,
981 x_mpn_confirm_code,
982 x_resp_to_orig_code,
983 x_appl_loan_phase_code,
984 x_appl_loan_phase_code_chg,
985 x_tot_outstd_stafford,
986 x_tot_outstd_plus,
987 x_alt_borw_tot_debt,
988 x_act_interest_rate,
989 x_service_type_code,
990 x_rev_notice_of_guarnt,
991 x_sch_refund_amt,
992 x_sch_refund_date,
993 x_uniq_layout_vend_code,
994 x_uniq_layout_ident_code,
995 x_p_person_id,
996 x_p_ssn,
997 x_p_ssn_chg_date,
998 x_p_last_name,
999 x_p_first_name,
1000 x_p_middle_name,
1001 x_p_permt_addr1,
1002 x_p_permt_addr2,
1003 x_p_permt_city,
1004 x_p_permt_state,
1005 x_p_permt_zip,
1006 x_p_permt_addr_chg_date,
1007 x_p_permt_phone,
1008 x_p_email_addr,
1009 x_p_date_of_birth,
1010 x_p_dob_chg_date,
1011 x_p_license_num,
1012 x_p_license_state,
1013 x_p_citizenship_status,
1014 x_p_alien_reg_num,
1015 x_p_default_status,
1016 x_p_foreign_postal_code,
1017 x_p_state_of_legal_res,
1018 x_p_legal_res_date,
1019 x_s_ssn,
1020 x_s_ssn_chg_date,
1021 x_s_last_name,
1022 x_s_first_name,
1023 x_s_middle_name,
1024 x_s_permt_addr1,
1025 x_s_permt_addr2,
1026 x_s_permt_city,
1027 x_s_permt_state,
1028 x_s_permt_zip,
1029 x_s_permt_addr_chg_date,
1030 x_s_permt_phone,
1031 x_s_local_addr1,
1032 x_s_local_addr2,
1033 x_s_local_city,
1034 x_s_local_state,
1035 x_s_local_zip,
1036 x_s_local_addr_chg_date,
1037 x_s_email_addr,
1038 x_s_date_of_birth,
1039 x_s_dob_chg_date,
1040 x_s_license_num,
1041 x_s_license_state,
1042 x_s_depncy_status,
1043 x_s_default_status,
1044 x_s_citizenship_status,
1045 x_s_alien_reg_num,
1046 x_s_foreign_postal_code,
1047 x_creation_date,
1048 x_created_by,
1049 x_last_update_date,
1050 x_last_updated_by,
1051 x_last_update_login,
1052 x_pnote_batch_id,
1053 x_pnote_ack_date,
1054 x_pnote_mpn_ind,
1055 x_award_id,
1056 x_base_id,
1057 x_document_id_txt,
1058 x_loan_key_num,
1059 x_interest_rebate_percent_num,
1060 x_fin_award_year,
1061 x_cps_trans_num,
1062 x_atd_entity_id_txt,
1063 x_rep_entity_id_txt,
1064 x_source_entity_id_txt,
1065 x_pymt_servicer_amt,
1066 x_pymt_servicer_date,
1067 x_book_loan_amt,
1068 x_book_loan_amt_date,
1069 x_s_chg_birth_date,
1070 x_s_chg_ssn,
1071 x_s_chg_last_name,
1072 x_b_chg_birth_date,
1073 x_b_chg_ssn,
1074 x_b_chg_last_name,
1075 x_note_message,
1076 x_full_resp_code,
1077 x_s_permt_county,
1078 x_b_permt_county,
1079 x_s_permt_country,
1080 x_b_permt_country,
1081 x_crdt_decision_status,
1082 x_external_loan_id_txt ,
1083 x_deferment_request_code ,
1084 x_eft_authorization_code ,
1085 x_requested_loan_amt ,
1086 x_actual_record_type_code ,
1087 x_reinstatement_amt ,
1088 x_lender_use_txt ,
1089 x_guarantor_use_txt ,
1090 x_fls_approved_amt ,
1091 x_flu_approved_amt ,
1092 x_flp_approved_amt ,
1093 x_alt_approved_amt ,
1094 x_loan_app_form_code ,
1095 x_alt_borrower_ind_flag ,
1096 x_school_id_txt ,
1097 x_cost_of_attendance_amt ,
1098 x_established_fin_aid_amount ,
1099 x_student_electronic_sign_flag,
1100 x_mpn_type_flag ,
1101 x_school_use_txt ,
1102 x_expect_family_contribute_amt,
1103 x_borower_electronic_sign_flag,
1104 x_borower_credit_authoriz_flag,
1105 x_esign_src_typ_cd
1106 );
1107
1108 IF (p_action = 'INSERT') THEN
1109 -- Call all the procedures related to Before Insert.
1110 IF ( get_pk_for_validation(
1111 new_references.loan_id
1112 )
1113 ) THEN
1114 fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1115 igs_ge_msg_stack.add;
1116 app_exception.raise_exception;
1117 END IF;
1118 check_uniqueness;
1119 check_parent_existance;
1120 ELSIF (p_action = 'UPDATE') THEN
1121 -- Call all the procedures related to Before Update.
1122 check_uniqueness;
1123 check_parent_existance;
1124 ELSIF (p_action = 'VALIDATE_INSERT') THEN
1125 -- Call all the procedures related to Before Insert.
1126 IF ( get_pk_for_validation (
1130 fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1127 new_references.loan_id
1128 )
1129 ) THEN
1131 igs_ge_msg_stack.add;
1132 app_exception.raise_exception;
1133 END IF;
1134 check_uniqueness;
1135 ELSIF (p_action = 'VALIDATE_UPDATE') THEN
1136 check_uniqueness;
1137 END IF;
1138
1139 END before_dml;
1140
1141
1142 PROCEDURE insert_row (
1143 x_rowid IN OUT NOCOPY VARCHAR2,
1144 x_loan_id IN NUMBER,
1145 x_origination_id IN NUMBER,
1146 x_loan_number IN VARCHAR2,
1147 x_loan_type IN VARCHAR2,
1148 x_loan_amt_offered IN NUMBER,
1149 x_loan_amt_accepted IN NUMBER,
1150 x_loan_per_begin_date IN DATE,
1151 x_loan_per_end_date IN DATE,
1152 x_acad_yr_begin_date IN DATE,
1153 x_acad_yr_end_date IN DATE,
1154 x_loan_status IN VARCHAR2,
1155 x_loan_status_date IN DATE,
1156 x_loan_chg_status IN VARCHAR2,
1157 x_loan_chg_status_date IN DATE,
1158 x_req_serial_loan_code IN VARCHAR2,
1159 x_act_serial_loan_code IN VARCHAR2,
1160 x_active IN VARCHAR2,
1161 x_active_date IN DATE,
1162 x_sch_cert_date IN DATE,
1163 x_orig_status_flag IN VARCHAR2,
1164 x_orig_batch_id IN VARCHAR2,
1165 x_orig_batch_date IN DATE,
1166 x_chg_batch_id IN VARCHAR2,
1167 x_orig_ack_date IN DATE,
1168 x_credit_override IN VARCHAR2,
1169 x_credit_decision_date IN DATE,
1170 x_pnote_delivery_code IN VARCHAR2,
1171 x_pnote_status IN VARCHAR2,
1172 x_pnote_status_date IN DATE,
1173 x_pnote_id IN VARCHAR2,
1174 x_pnote_print_ind IN VARCHAR2,
1175 x_pnote_accept_amt IN NUMBER,
1176 x_pnote_accept_date IN DATE,
1177 x_p_signature_code IN VARCHAR2,
1178 x_p_signature_date IN DATE,
1179 x_s_signature_code IN VARCHAR2,
1180 x_unsub_elig_for_heal IN VARCHAR2,
1181 x_disclosure_print_ind IN VARCHAR2,
1182 x_orig_fee_perct IN NUMBER,
1183 x_borw_confirm_ind IN VARCHAR2,
1184 x_borw_interest_ind IN VARCHAR2,
1185 x_unsub_elig_for_depnt IN VARCHAR2,
1186 x_guarantee_amt IN NUMBER,
1187 x_guarantee_date IN DATE,
1188 x_guarnt_adj_ind IN VARCHAR2,
1189 x_guarnt_amt_redn_code IN VARCHAR2,
1190 x_guarnt_status_code IN VARCHAR2,
1191 x_guarnt_status_date IN DATE,
1192 x_lend_apprv_denied_code IN VARCHAR2,
1193 x_lend_apprv_denied_date IN DATE,
1194 x_lend_status_code IN VARCHAR2,
1195 x_lend_status_date IN DATE,
1196 x_grade_level_code IN VARCHAR2,
1197 x_enrollment_code IN VARCHAR2,
1198 x_anticip_compl_date IN DATE,
1199 x_borw_lender_id IN VARCHAR2,
1200 x_duns_borw_lender_id IN VARCHAR2,
1201 x_guarantor_id IN VARCHAR2,
1202 x_duns_guarnt_id IN VARCHAR2,
1203 x_prc_type_code IN VARCHAR2,
1204 x_rec_type_ind IN VARCHAR2,
1205 x_cl_loan_type IN VARCHAR2,
1206 x_cl_seq_number IN NUMBER,
1207 x_last_resort_lender IN VARCHAR2,
1208 x_lender_id IN VARCHAR2,
1209 x_duns_lender_id IN VARCHAR2,
1210 x_lend_non_ed_brc_id IN VARCHAR2,
1211 x_recipient_id IN VARCHAR2,
1212 x_recipient_type IN VARCHAR2,
1213 x_duns_recip_id IN VARCHAR2,
1214 x_recip_non_ed_brc_id IN VARCHAR2,
1215 x_cl_rec_status IN VARCHAR2,
1216 x_cl_rec_status_last_update IN DATE,
1217 x_alt_prog_type_code IN VARCHAR2,
1218 x_alt_appl_ver_code IN NUMBER,
1219 x_borw_outstd_loan_code IN VARCHAR2,
1220 x_mpn_confirm_code IN VARCHAR2,
1221 x_resp_to_orig_code IN VARCHAR2,
1222 x_appl_loan_phase_code IN VARCHAR2,
1223 x_appl_loan_phase_code_chg IN DATE,
1224 x_tot_outstd_stafford IN NUMBER,
1225 x_tot_outstd_plus IN NUMBER,
1226 x_alt_borw_tot_debt IN NUMBER,
1227 x_act_interest_rate IN NUMBER,
1228 x_service_type_code IN VARCHAR2,
1229 x_rev_notice_of_guarnt IN VARCHAR2,
1230 x_sch_refund_amt IN NUMBER,
1234 x_p_person_id IN NUMBER,
1231 x_sch_refund_date IN DATE,
1232 x_uniq_layout_vend_code IN VARCHAR2,
1233 x_uniq_layout_ident_code IN VARCHAR2,
1235 x_p_ssn IN VARCHAR2,
1236 x_p_ssn_chg_date IN DATE,
1237 x_p_last_name IN VARCHAR2,
1238 x_p_first_name IN VARCHAR2,
1239 x_p_middle_name IN VARCHAR2,
1240 x_p_permt_addr1 IN VARCHAR2,
1241 x_p_permt_addr2 IN VARCHAR2,
1242 x_p_permt_city IN VARCHAR2,
1243 x_p_permt_state IN VARCHAR2,
1244 x_p_permt_zip IN VARCHAR2,
1245 x_p_permt_addr_chg_date IN DATE,
1246 x_p_permt_phone IN VARCHAR2,
1247 x_p_email_addr IN VARCHAR2,
1248 x_p_date_of_birth IN DATE,
1249 x_p_dob_chg_date IN DATE,
1250 x_p_license_num IN VARCHAR2,
1251 x_p_license_state IN VARCHAR2,
1252 x_p_citizenship_status IN VARCHAR2,
1253 x_p_alien_reg_num IN VARCHAR2,
1254 x_p_default_status IN VARCHAR2,
1255 x_p_foreign_postal_code IN VARCHAR2,
1256 x_p_state_of_legal_res IN VARCHAR2,
1257 x_p_legal_res_date IN DATE,
1258 x_s_ssn IN VARCHAR2,
1259 x_s_ssn_chg_date IN DATE,
1260 x_s_last_name IN VARCHAR2,
1261 x_s_first_name IN VARCHAR2,
1262 x_s_middle_name IN VARCHAR2,
1263 x_s_permt_addr1 IN VARCHAR2,
1264 x_s_permt_addr2 IN VARCHAR2,
1265 x_s_permt_city IN VARCHAR2,
1266 x_s_permt_state IN VARCHAR2,
1267 x_s_permt_zip IN VARCHAR2,
1268 x_s_permt_addr_chg_date IN DATE,
1269 x_s_permt_phone IN VARCHAR2,
1270 x_s_local_addr1 IN VARCHAR2,
1271 x_s_local_addr2 IN VARCHAR2,
1272 x_s_local_city IN VARCHAR2,
1273 x_s_local_state IN VARCHAR2,
1274 x_s_local_zip IN VARCHAR2,
1275 x_s_local_addr_chg_date IN DATE,
1276 x_s_email_addr IN VARCHAR2,
1277 x_s_date_of_birth IN DATE,
1278 x_s_dob_chg_date IN DATE,
1279 x_s_license_num IN VARCHAR2,
1280 x_s_license_state IN VARCHAR2,
1281 x_s_depncy_status IN VARCHAR2,
1282 x_s_default_status IN VARCHAR2,
1283 x_s_citizenship_status IN VARCHAR2,
1284 x_s_alien_reg_num IN VARCHAR2,
1285 x_s_foreign_postal_code IN VARCHAR2,
1286 x_mode IN VARCHAR2 DEFAULT 'R',
1287 x_pnote_batch_id IN VARCHAR2,
1288 x_pnote_ack_date IN DATE,
1289 x_pnote_mpn_ind IN VARCHAR2,
1290 x_award_id IN NUMBER,
1291 x_base_id IN NUMBER,
1292 x_document_id_txt IN VARCHAR2,
1293 x_loan_key_num IN NUMBER,
1294 x_interest_rebate_percent_num IN NUMBER,
1295 x_fin_award_year IN VARCHAR2,
1296 x_cps_trans_num IN NUMBER,
1297 x_atd_entity_id_txt IN VARCHAR2,
1298 x_rep_entity_id_txt IN VARCHAR2,
1299 x_source_entity_id_txt IN VARCHAR2,
1300 x_pymt_servicer_amt IN NUMBER,
1301 x_pymt_servicer_date IN DATE,
1302 x_book_loan_amt IN NUMBER,
1303 x_book_loan_amt_date IN DATE,
1304 x_s_chg_birth_date IN DATE,
1305 x_s_chg_ssn IN VARCHAR2,
1306 x_s_chg_last_name IN VARCHAR2,
1307 x_b_chg_birth_date IN DATE,
1308 x_b_chg_ssn IN VARCHAR2,
1309 x_b_chg_last_name IN VARCHAR2,
1310 x_note_message IN VARCHAR2,
1311 x_full_resp_code IN VARCHAR2,
1312 x_s_permt_county IN VARCHAR2,
1313 x_b_permt_county IN VARCHAR2,
1314 x_s_permt_country IN VARCHAR2,
1315 x_b_permt_country IN VARCHAR2,
1316 x_crdt_decision_status IN VARCHAR2,
1317 x_external_loan_id_txt IN VARCHAR2,
1318 x_deferment_request_code IN VARCHAR2,
1319 x_eft_authorization_code IN VARCHAR2,
1320 x_requested_loan_amt IN NUMBER ,
1321 x_actual_record_type_code IN VARCHAR2,
1322 x_reinstatement_amt IN NUMBER ,
1323 x_lender_use_txt IN VARCHAR2,
1324 x_guarantor_use_txt IN VARCHAR2,
1328 x_alt_approved_amt IN NUMBER ,
1325 x_fls_approved_amt IN NUMBER ,
1326 x_flu_approved_amt IN NUMBER ,
1327 x_flp_approved_amt IN NUMBER ,
1329 x_loan_app_form_code IN VARCHAR2,
1330 x_alt_borrower_ind_flag IN VARCHAR2,
1331 x_school_id_txt IN VARCHAR2,
1332 x_cost_of_attendance_amt IN NUMBER ,
1333 x_established_fin_aid_amount IN NUMBER ,
1334 x_student_electronic_sign_flag IN VARCHAR2,
1335 x_mpn_type_flag IN VARCHAR2,
1336 x_school_use_txt IN VARCHAR2,
1337 x_expect_family_contribute_amt IN NUMBER ,
1338 x_borower_electronic_sign_flag IN VARCHAR2,
1339 x_borower_credit_authoriz_flag IN VARCHAR2,
1340 x_esign_src_typ_cd IN VARCHAR2
1341 ) AS
1342 /*
1343 || Created By : venagara
1344 || Created On : 22-JAN-2001
1345 || Purpose : Handles the INSERT DML logic for the table.
1346 || Known limitations, enhancements or remarks :
1347 || Change History :
1348 || Who When What
1349 || (reverse chronological order - newest change first)
1350 */
1351 CURSOR c IS
1352 SELECT rowid
1353 FROM igf_sl_lor_loc_all
1354 WHERE loan_id = x_loan_id;
1355
1356 x_last_update_date DATE;
1357 x_last_updated_by NUMBER;
1358 x_last_update_login NUMBER;
1359 x_request_id NUMBER;
1360 x_program_id NUMBER;
1361 x_program_application_id NUMBER;
1362 x_program_update_date DATE;
1363 l_org_id igf_sl_lor_loc_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
1364
1365 BEGIN
1366
1367 x_last_update_date := SYSDATE;
1368 IF (x_mode = 'I') THEN
1369 x_last_updated_by := 1;
1370 x_last_update_login := 0;
1371 ELSIF (x_mode = 'R') THEN
1372 x_last_updated_by := fnd_global.user_id;
1373 IF (x_last_updated_by IS NULL) THEN
1374 x_last_updated_by := -1;
1375 END IF;
1376 x_last_update_login := fnd_global.login_id;
1377 IF (x_last_update_login IS NULL) THEN
1378 x_last_update_login := -1;
1379 END IF;
1380 x_request_id := fnd_global.conc_request_id;
1381 x_program_id := fnd_global.conc_program_id;
1382 x_program_application_id := fnd_global.prog_appl_id;
1383
1384 IF (x_request_id = -1) THEN
1385 x_request_id := NULL;
1386 x_program_id := NULL;
1387 x_program_application_id := NULL;
1388 x_program_update_date := NULL;
1389 ELSE
1390 x_program_update_date := SYSDATE;
1391 END IF;
1392 ELSE
1393 fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1394 igs_ge_msg_stack.add;
1395 app_exception.raise_exception;
1396 END IF;
1397
1398 before_dml(
1399 p_action => 'INSERT',
1400 x_rowid => x_rowid,
1401 x_loan_id => x_loan_id,
1402 x_origination_id => x_origination_id,
1403 x_loan_number => x_loan_number,
1404 x_loan_type => x_loan_type,
1405 x_loan_amt_offered => x_loan_amt_offered,
1406 x_loan_amt_accepted => x_loan_amt_accepted,
1407 x_loan_per_begin_date => x_loan_per_begin_date,
1408 x_loan_per_end_date => x_loan_per_end_date,
1409 x_acad_yr_begin_date => x_acad_yr_begin_date,
1410 x_acad_yr_end_date => x_acad_yr_end_date,
1411 x_loan_status => x_loan_status,
1412 x_loan_status_date => x_loan_status_date,
1413 x_loan_chg_status => x_loan_chg_status,
1414 x_loan_chg_status_date => x_loan_chg_status_date,
1415 x_req_serial_loan_code => x_req_serial_loan_code,
1416 x_act_serial_loan_code => x_act_serial_loan_code,
1417 x_active => x_active,
1418 x_active_date => x_active_date,
1419 x_sch_cert_date => x_sch_cert_date,
1420 x_orig_status_flag => x_orig_status_flag,
1421 x_orig_batch_id => x_orig_batch_id,
1422 x_orig_batch_date => x_orig_batch_date,
1423 x_chg_batch_id => x_chg_batch_id,
1424 x_orig_ack_date => x_orig_ack_date,
1425 x_credit_override => x_credit_override,
1426 x_credit_decision_date => x_credit_decision_date,
1427 x_pnote_delivery_code => x_pnote_delivery_code,
1428 x_pnote_status => x_pnote_status,
1429 x_pnote_status_date => x_pnote_status_date,
1430 x_pnote_id => x_pnote_id,
1431 x_pnote_print_ind => x_pnote_print_ind,
1432 x_pnote_accept_amt => x_pnote_accept_amt,
1433 x_pnote_accept_date => x_pnote_accept_date,
1434 x_p_signature_code => x_p_signature_code,
1435 x_p_signature_date => x_p_signature_date,
1436 x_s_signature_code => x_s_signature_code,
1440 x_borw_confirm_ind => x_borw_confirm_ind,
1437 x_unsub_elig_for_heal => x_unsub_elig_for_heal,
1438 x_disclosure_print_ind => x_disclosure_print_ind,
1439 x_orig_fee_perct => x_orig_fee_perct,
1441 x_borw_interest_ind => x_borw_interest_ind,
1442 x_unsub_elig_for_depnt => x_unsub_elig_for_depnt,
1443 x_guarantee_amt => x_guarantee_amt,
1444 x_guarantee_date => x_guarantee_date,
1445 x_guarnt_adj_ind => x_guarnt_adj_ind,
1446 x_guarnt_amt_redn_code => x_guarnt_amt_redn_code,
1447 x_guarnt_status_code => x_guarnt_status_code,
1448 x_guarnt_status_date => x_guarnt_status_date,
1449 x_lend_apprv_denied_code => x_lend_apprv_denied_code,
1450 x_lend_apprv_denied_date => x_lend_apprv_denied_date,
1451 x_lend_status_code => x_lend_status_code,
1452 x_lend_status_date => x_lend_status_date,
1453 x_grade_level_code => x_grade_level_code,
1454 x_enrollment_code => x_enrollment_code,
1455 x_anticip_compl_date => x_anticip_compl_date,
1456 x_borw_lender_id => x_borw_lender_id,
1457 x_duns_borw_lender_id => x_duns_borw_lender_id,
1458 x_guarantor_id => x_guarantor_id,
1459 x_duns_guarnt_id => x_duns_guarnt_id,
1460 x_prc_type_code => x_prc_type_code,
1461 x_rec_type_ind => x_rec_type_ind,
1462 x_cl_loan_type => x_cl_loan_type,
1463 x_cl_seq_number => x_cl_seq_number,
1464 x_last_resort_lender => x_last_resort_lender,
1465 x_lender_id => x_lender_id,
1466 x_duns_lender_id => x_duns_lender_id,
1467 x_lend_non_ed_brc_id => x_lend_non_ed_brc_id,
1468 x_recipient_id => x_recipient_id,
1469 x_recipient_type => x_recipient_type,
1470 x_duns_recip_id => x_duns_recip_id,
1471 x_recip_non_ed_brc_id => x_recip_non_ed_brc_id,
1472 x_cl_rec_status => x_cl_rec_status,
1473 x_cl_rec_status_last_update => x_cl_rec_status_last_update,
1474 x_alt_prog_type_code => x_alt_prog_type_code,
1475 x_alt_appl_ver_code => x_alt_appl_ver_code,
1476 x_borw_outstd_loan_code => x_borw_outstd_loan_code,
1477 x_mpn_confirm_code => x_mpn_confirm_code,
1478 x_resp_to_orig_code => x_resp_to_orig_code,
1479 x_appl_loan_phase_code => x_appl_loan_phase_code,
1480 x_appl_loan_phase_code_chg => x_appl_loan_phase_code_chg,
1481 x_tot_outstd_stafford => x_tot_outstd_stafford,
1482 x_tot_outstd_plus => x_tot_outstd_plus,
1483 x_alt_borw_tot_debt => x_alt_borw_tot_debt,
1484 x_act_interest_rate => x_act_interest_rate,
1485 x_service_type_code => x_service_type_code,
1486 x_rev_notice_of_guarnt => x_rev_notice_of_guarnt,
1487 x_sch_refund_amt => x_sch_refund_amt,
1488 x_sch_refund_date => x_sch_refund_date,
1489 x_uniq_layout_vend_code => x_uniq_layout_vend_code,
1490 x_uniq_layout_ident_code => x_uniq_layout_ident_code,
1491 x_p_person_id => x_p_person_id,
1492 x_p_ssn => x_p_ssn,
1493 x_p_ssn_chg_date => x_p_ssn_chg_date,
1494 x_p_last_name => x_p_last_name,
1495 x_p_first_name => x_p_first_name,
1496 x_p_middle_name => x_p_middle_name,
1497 x_p_permt_addr1 => x_p_permt_addr1,
1498 x_p_permt_addr2 => x_p_permt_addr2,
1499 x_p_permt_city => x_p_permt_city,
1500 x_p_permt_state => x_p_permt_state,
1501 x_p_permt_zip => x_p_permt_zip,
1502 x_p_permt_addr_chg_date => x_p_permt_addr_chg_date,
1503 x_p_permt_phone => x_p_permt_phone,
1504 x_p_email_addr => x_p_email_addr,
1505 x_p_date_of_birth => x_p_date_of_birth,
1506 x_p_dob_chg_date => x_p_dob_chg_date,
1507 x_p_license_num => x_p_license_num,
1508 x_p_license_state => x_p_license_state,
1509 x_p_citizenship_status => x_p_citizenship_status,
1510 x_p_alien_reg_num => x_p_alien_reg_num,
1511 x_p_default_status => x_p_default_status,
1512 x_p_foreign_postal_code => x_p_foreign_postal_code,
1513 x_p_state_of_legal_res => x_p_state_of_legal_res,
1514 x_p_legal_res_date => x_p_legal_res_date,
1515 x_s_ssn => x_s_ssn,
1516 x_s_ssn_chg_date => x_s_ssn_chg_date,
1517 x_s_last_name => x_s_last_name,
1518 x_s_first_name => x_s_first_name,
1519 x_s_middle_name => x_s_middle_name,
1523 x_s_permt_state => x_s_permt_state,
1520 x_s_permt_addr1 => x_s_permt_addr1,
1521 x_s_permt_addr2 => x_s_permt_addr2,
1522 x_s_permt_city => x_s_permt_city,
1524 x_s_permt_zip => x_s_permt_zip,
1525 x_s_permt_addr_chg_date => x_s_permt_addr_chg_date,
1526 x_s_permt_phone => x_s_permt_phone,
1527 x_s_local_addr1 => x_s_local_addr1,
1528 x_s_local_addr2 => x_s_local_addr2,
1529 x_s_local_city => x_s_local_city,
1530 x_s_local_state => x_s_local_state,
1531 x_s_local_zip => x_s_local_zip,
1532 x_s_local_addr_chg_date => x_s_local_addr_chg_date,
1533 x_s_email_addr => x_s_email_addr,
1534 x_s_date_of_birth => x_s_date_of_birth,
1535 x_s_dob_chg_date => x_s_dob_chg_date,
1536 x_s_license_num => x_s_license_num,
1537 x_s_license_state => x_s_license_state,
1538 x_s_depncy_status => x_s_depncy_status,
1539 x_s_default_status => x_s_default_status,
1540 x_s_citizenship_status => x_s_citizenship_status,
1541 x_s_alien_reg_num => x_s_alien_reg_num,
1542 x_s_foreign_postal_code => x_s_foreign_postal_code,
1543 x_creation_date => x_last_update_date,
1544 x_created_by => x_last_updated_by,
1545 x_last_update_date => x_last_update_date,
1546 x_last_updated_by => x_last_updated_by,
1547 x_last_update_login => x_last_update_login,
1548 x_pnote_batch_id => x_pnote_batch_id,
1549 x_pnote_ack_date => x_pnote_ack_date,
1550 x_pnote_mpn_ind => x_pnote_mpn_ind,
1551 x_award_id => x_award_id,
1552 x_base_id => x_base_id,
1553 x_document_id_txt => x_document_id_txt,
1554 x_loan_key_num => x_loan_key_num,
1555 x_interest_rebate_percent_num => x_interest_rebate_percent_num,
1556 x_fin_award_year => x_fin_award_year,
1557 x_cps_trans_num => x_cps_trans_num,
1558 x_atd_entity_id_txt => x_atd_entity_id_txt,
1559 x_rep_entity_id_txt => x_rep_entity_id_txt,
1560 x_source_entity_id_txt => x_source_entity_id_txt,
1561 x_pymt_servicer_amt => x_pymt_servicer_amt,
1562 x_pymt_servicer_date => x_pymt_servicer_date,
1563 x_book_loan_amt => x_book_loan_amt,
1564 x_book_loan_amt_date => x_book_loan_amt_date,
1565 x_s_chg_birth_date => x_s_chg_birth_date,
1566 x_s_chg_ssn => x_s_chg_ssn,
1567 x_s_chg_last_name => x_s_chg_last_name,
1568 x_b_chg_birth_date => x_b_chg_birth_date,
1569 x_b_chg_ssn => x_b_chg_ssn,
1570 x_b_chg_last_name => x_b_chg_last_name,
1571 x_note_message => x_note_message,
1572 x_full_resp_code => x_full_resp_code,
1573 x_s_permt_county => x_s_permt_county,
1574 x_b_permt_county => x_b_permt_county,
1575 x_s_permt_country => x_s_permt_country,
1576 x_b_permt_country => x_b_permt_country,
1577 x_crdt_decision_status => x_crdt_decision_status,
1578 x_external_loan_id_txt => x_external_loan_id_txt ,
1579 x_deferment_request_code => x_deferment_request_code ,
1580 x_eft_authorization_code => x_eft_authorization_code ,
1581 x_requested_loan_amt => x_requested_loan_amt ,
1582 x_actual_record_type_code => x_actual_record_type_code ,
1583 x_reinstatement_amt => x_reinstatement_amt ,
1584 x_lender_use_txt => x_lender_use_txt ,
1585 x_guarantor_use_txt => x_guarantor_use_txt ,
1586 x_fls_approved_amt => x_fls_approved_amt ,
1587 x_flu_approved_amt => x_flu_approved_amt ,
1588 x_flp_approved_amt => x_flp_approved_amt ,
1589 x_alt_approved_amt => x_alt_approved_amt ,
1590 x_loan_app_form_code => x_loan_app_form_code ,
1591 x_alt_borrower_ind_flag => x_alt_borrower_ind_flag ,
1592 x_school_id_txt => x_school_id_txt ,
1593 x_cost_of_attendance_amt => x_cost_of_attendance_amt ,
1594 x_established_fin_aid_amount => x_established_fin_aid_amount ,
1595 x_student_electronic_sign_flag => x_student_electronic_sign_flag ,
1596 x_mpn_type_flag => x_mpn_type_flag ,
1597 x_school_use_txt => x_school_use_txt ,
1598 x_expect_family_contribute_amt => x_expect_family_contribute_amt ,
1599 x_borower_electronic_sign_flag => x_borower_electronic_sign_flag ,
1603
1600 x_borower_credit_authoriz_flag => x_borower_credit_authoriz_flag ,
1601 x_esign_src_typ_cd => x_esign_src_typ_cd
1602 );
1604 INSERT INTO igf_sl_lor_loc_all(
1605 loan_id,
1606 origination_id,
1607 loan_number,
1608 loan_type,
1609 loan_amt_offered,
1610 loan_amt_accepted,
1611 loan_per_begin_date,
1612 loan_per_end_date,
1613 acad_yr_begin_date,
1614 acad_yr_end_date,
1615 loan_status,
1616 loan_status_date,
1617 loan_chg_status,
1618 loan_chg_status_date,
1619 req_serial_loan_code,
1620 act_serial_loan_code,
1621 active,
1622 active_date,
1623 sch_cert_date,
1624 orig_status_flag,
1625 orig_batch_id,
1626 orig_batch_date,
1627 chg_batch_id,
1628 orig_ack_date,
1629 credit_override,
1630 credit_decision_date,
1631 pnote_delivery_code,
1632 pnote_status,
1633 pnote_status_date,
1634 pnote_id,
1635 pnote_print_ind,
1636 pnote_accept_amt,
1637 pnote_accept_date,
1638 p_signature_code,
1639 p_signature_date,
1640 s_signature_code,
1641 unsub_elig_for_heal,
1642 disclosure_print_ind,
1643 orig_fee_perct,
1644 borw_confirm_ind,
1645 borw_interest_ind,
1646 unsub_elig_for_depnt,
1647 guarantee_amt,
1648 guarantee_date,
1649 guarnt_adj_ind,
1650 guarnt_amt_redn_code,
1651 guarnt_status_code,
1652 guarnt_status_date,
1653 lend_apprv_denied_code,
1654 lend_apprv_denied_date,
1655 lend_status_code,
1656 lend_status_date,
1657 grade_level_code,
1658 enrollment_code,
1659 anticip_compl_date,
1660 borw_lender_id,
1661 guarantor_id,
1662 prc_type_code,
1663 rec_type_ind,
1664 cl_loan_type,
1665 cl_seq_number,
1666 last_resort_lender,
1667 lender_id,
1668 lend_non_ed_brc_id,
1669 recipient_id,
1670 recipient_type,
1671 recip_non_ed_brc_id,
1672 cl_rec_status,
1673 cl_rec_status_last_update,
1674 alt_prog_type_code,
1675 alt_appl_ver_code,
1676 borw_outstd_loan_code,
1677 mpn_confirm_code,
1678 resp_to_orig_code,
1679 appl_loan_phase_code,
1680 appl_loan_phase_code_chg,
1681 tot_outstd_stafford,
1682 tot_outstd_plus,
1683 alt_borw_tot_debt,
1684 act_interest_rate,
1685 service_type_code,
1686 rev_notice_of_guarnt,
1687 sch_refund_amt,
1688 sch_refund_date,
1689 uniq_layout_vend_code,
1690 uniq_layout_ident_code,
1691 p_person_id,
1692 p_ssn,
1693 p_ssn_chg_date,
1694 p_last_name,
1695 p_first_name,
1696 p_middle_name,
1697 p_permt_addr1,
1698 p_permt_addr2,
1699 p_permt_city,
1700 p_permt_state,
1701 p_permt_zip,
1702 p_permt_addr_chg_date,
1703 p_permt_phone,
1704 p_email_addr,
1705 p_date_of_birth,
1706 p_dob_chg_date,
1707 p_license_num,
1708 p_license_state,
1709 p_citizenship_status,
1710 p_alien_reg_num,
1711 p_default_status,
1712 p_foreign_postal_code,
1713 p_state_of_legal_res,
1714 p_legal_res_date,
1715 s_ssn,
1716 s_ssn_chg_date,
1717 s_last_name,
1718 s_first_name,
1719 s_middle_name,
1720 s_permt_addr1,
1721 s_permt_addr2,
1722 s_permt_city,
1723 s_permt_state,
1724 s_permt_zip,
1725 s_permt_addr_chg_date,
1726 s_permt_phone,
1727 s_local_addr1,
1728 s_local_addr2,
1729 s_local_city,
1730 s_local_state,
1731 s_local_zip,
1732 s_local_addr_chg_date,
1733 s_email_addr,
1734 s_date_of_birth,
1735 s_dob_chg_date,
1736 s_license_num,
1737 s_license_state,
1738 s_depncy_status,
1739 s_default_status,
1740 s_citizenship_status,
1741 s_alien_reg_num,
1742 s_foreign_postal_code,
1743 creation_date,
1744 created_by,
1745 last_update_date,
1746 last_updated_by,
1747 last_update_login,
1748 request_id,
1749 program_id,
1750 program_application_id,
1751 program_update_date,
1752 org_id,
1753 pnote_batch_id,
1754 pnote_ack_date,
1755 pnote_mpn_ind,
1756 award_id,
1757 base_id,
1758 document_id_txt,
1759 loan_key_num,
1760 interest_rebate_percent_num,
1761 fin_award_year,
1762 cps_trans_num,
1763 atd_entity_id_txt,
1764 rep_entity_id_txt,
1765 source_entity_id_txt,
1766 pymt_servicer_amt,
1767 pymt_servicer_date,
1768 book_loan_amt,
1769 book_loan_amt_date,
1770 s_chg_birth_date,
1771 s_chg_ssn,
1772 s_chg_last_name,
1773 b_chg_birth_date,
1774 b_chg_ssn,
1775 b_chg_last_name,
1776 note_message,
1780 s_permt_country,
1777 full_resp_code,
1778 s_permt_county,
1779 b_permt_county,
1781 b_permt_country,
1782 crdt_decision_status,
1783 external_loan_id_txt ,
1784 deferment_request_code ,
1785 eft_authorization_code ,
1786 requested_loan_amt ,
1787 actual_record_type_code ,
1788 reinstatement_amt ,
1789 lender_use_txt ,
1790 guarantor_use_txt ,
1791 fls_approved_amt ,
1792 flu_approved_amt ,
1793 flp_approved_amt ,
1794 alt_approved_amt ,
1795 loan_app_form_code ,
1796 alt_borrower_ind_flag ,
1797 school_id_txt ,
1798 cost_of_attendance_amt ,
1799 established_fin_aid_amount ,
1800 student_electronic_sign_flag,
1801 mpn_type_flag ,
1802 school_use_txt ,
1803 expect_family_contribute_amt,
1804 borower_electronic_sign_flag,
1805 borower_credit_authoriz_flag,
1806 esign_src_typ_cd
1807
1808 ) VALUES (
1809 new_references.loan_id,
1810 new_references.origination_id,
1811 new_references.loan_number,
1812 new_references.loan_type,
1813 new_references.loan_amt_offered,
1814 new_references.loan_amt_accepted,
1815 new_references.loan_per_begin_date,
1816 new_references.loan_per_end_date,
1817 new_references.acad_yr_begin_date,
1818 new_references.acad_yr_end_date,
1819 new_references.loan_status,
1820 new_references.loan_status_date,
1821 new_references.loan_chg_status,
1822 new_references.loan_chg_status_date,
1823 new_references.req_serial_loan_code,
1824 new_references.act_serial_loan_code,
1825 new_references.active,
1826 new_references.active_date,
1827 new_references.sch_cert_date,
1828 new_references.orig_status_flag,
1829 new_references.orig_batch_id,
1830 new_references.orig_batch_date,
1831 new_references.chg_batch_id,
1832 new_references.orig_ack_date,
1833 new_references.credit_override,
1834 new_references.credit_decision_date,
1835 new_references.pnote_delivery_code,
1836 new_references.pnote_status,
1837 new_references.pnote_status_date,
1838 new_references.pnote_id,
1839 new_references.pnote_print_ind,
1840 new_references.pnote_accept_amt,
1841 new_references.pnote_accept_date,
1842 new_references.p_signature_code,
1843 new_references.p_signature_date,
1844 new_references.s_signature_code,
1845 new_references.unsub_elig_for_heal,
1846 new_references.disclosure_print_ind,
1847 new_references.orig_fee_perct,
1848 new_references.borw_confirm_ind,
1849 new_references.borw_interest_ind,
1850 new_references.unsub_elig_for_depnt,
1851 new_references.guarantee_amt,
1852 new_references.guarantee_date,
1853 new_references.guarnt_adj_ind,
1854 new_references.guarnt_amt_redn_code,
1855 new_references.guarnt_status_code,
1856 new_references.guarnt_status_date,
1857 new_references.lend_apprv_denied_code,
1858 new_references.lend_apprv_denied_date,
1859 new_references.lend_status_code,
1860 new_references.lend_status_date,
1861 new_references.grade_level_code,
1862 new_references.enrollment_code,
1863 new_references.anticip_compl_date,
1864 new_references.borw_lender_id,
1865 new_references.guarantor_id,
1866 new_references.prc_type_code,
1867 new_references.rec_type_ind,
1868 new_references.cl_loan_type,
1869 new_references.cl_seq_number,
1870 new_references.last_resort_lender,
1871 new_references.lender_id,
1872 new_references.lend_non_ed_brc_id,
1873 new_references.recipient_id,
1874 new_references.recipient_type,
1875 new_references.recip_non_ed_brc_id,
1876 new_references.cl_rec_status,
1877 new_references.cl_rec_status_last_update,
1878 new_references.alt_prog_type_code,
1879 new_references.alt_appl_ver_code,
1880 new_references.borw_outstd_loan_code,
1881 new_references.mpn_confirm_code,
1882 new_references.resp_to_orig_code,
1883 new_references.appl_loan_phase_code,
1884 new_references.appl_loan_phase_code_chg,
1885 new_references.tot_outstd_stafford,
1886 new_references.tot_outstd_plus,
1887 new_references.alt_borw_tot_debt,
1888 new_references.act_interest_rate,
1889 new_references.service_type_code,
1890 new_references.rev_notice_of_guarnt,
1891 new_references.sch_refund_amt,
1892 new_references.sch_refund_date,
1893 new_references.uniq_layout_vend_code,
1894 new_references.uniq_layout_ident_code,
1895 new_references.p_person_id,
1896 new_references.p_ssn,
1897 new_references.p_ssn_chg_date,
1898 new_references.p_last_name,
1899 new_references.p_first_name,
1900 new_references.p_middle_name,
1901 new_references.p_permt_addr1,
1902 new_references.p_permt_addr2,
1903 new_references.p_permt_city,
1904 new_references.p_permt_state,
1905 new_references.p_permt_zip,
1906 new_references.p_permt_addr_chg_date,
1907 new_references.p_permt_phone,
1908 new_references.p_email_addr,
1909 new_references.p_date_of_birth,
1913 new_references.p_citizenship_status,
1910 new_references.p_dob_chg_date,
1911 new_references.p_license_num,
1912 new_references.p_license_state,
1914 new_references.p_alien_reg_num,
1915 new_references.p_default_status,
1916 new_references.p_foreign_postal_code,
1917 new_references.p_state_of_legal_res,
1918 new_references.p_legal_res_date,
1919 new_references.s_ssn,
1920 new_references.s_ssn_chg_date,
1921 new_references.s_last_name,
1922 new_references.s_first_name,
1923 new_references.s_middle_name,
1924 new_references.s_permt_addr1,
1925 new_references.s_permt_addr2,
1926 new_references.s_permt_city,
1927 new_references.s_permt_state,
1928 new_references.s_permt_zip,
1929 new_references.s_permt_addr_chg_date,
1930 new_references.s_permt_phone,
1931 new_references.s_local_addr1,
1932 new_references.s_local_addr2,
1933 new_references.s_local_city,
1934 new_references.s_local_state,
1935 new_references.s_local_zip,
1936 new_references.s_local_addr_chg_date,
1937 new_references.s_email_addr,
1938 new_references.s_date_of_birth,
1939 new_references.s_dob_chg_date,
1940 new_references.s_license_num,
1941 new_references.s_license_state,
1942 new_references.s_depncy_status,
1943 new_references.s_default_status,
1944 new_references.s_citizenship_status,
1945 new_references.s_alien_reg_num,
1946 new_references.s_foreign_postal_code,
1947 x_last_update_date,
1948 x_last_updated_by,
1949 x_last_update_date,
1950 x_last_updated_by,
1951 x_last_update_login ,
1952 x_request_id,
1953 x_program_id,
1954 x_program_application_id,
1955 x_program_update_date,
1956 l_org_id,
1957 new_references.pnote_batch_id,
1958 new_references.pnote_ack_date,
1959 new_references.pnote_mpn_ind,
1960 new_references.award_id,
1961 new_references.base_id,
1962 new_references.document_id_txt,
1963 new_references.loan_key_num,
1964 new_references.interest_rebate_percent_num,
1965 new_references.fin_award_year,
1966 new_references.cps_trans_num,
1967 new_references.atd_entity_id_txt,
1968 new_references.rep_entity_id_txt,
1969 new_references.source_entity_id_txt,
1970 new_references.pymt_servicer_amt,
1971 new_references.pymt_servicer_date,
1972 new_references.book_loan_amt,
1973 new_references.book_loan_amt_date,
1974 new_references.s_chg_birth_date,
1975 new_references.s_chg_ssn,
1976 new_references.s_chg_last_name,
1977 new_references.b_chg_birth_date,
1978 new_references.b_chg_ssn,
1979 new_references.b_chg_last_name,
1980 new_references.note_message,
1981 new_references.full_resp_code,
1982 new_references.s_permt_county,
1983 new_references.b_permt_county,
1984 new_references.s_permt_country,
1985 new_references.b_permt_country,
1986 new_references.crdt_decision_status,
1987 new_references.external_loan_id_txt ,
1988 new_references.deferment_request_code ,
1989 new_references.eft_authorization_code ,
1990 new_references.requested_loan_amt ,
1991 new_references.actual_record_type_code ,
1992 new_references.reinstatement_amt ,
1993 new_references.lender_use_txt ,
1994 new_references.guarantor_use_txt ,
1995 new_references.fls_approved_amt ,
1996 new_references.flu_approved_amt ,
1997 new_references.flp_approved_amt ,
1998 new_references.alt_approved_amt ,
1999 new_references.loan_app_form_code ,
2000 new_references.alt_borrower_ind_flag ,
2001 new_references.school_id_txt ,
2002 new_references.cost_of_attendance_amt ,
2003 new_references.established_fin_aid_amount ,
2004 new_references.student_electronic_sign_flag,
2005 new_references.mpn_type_flag ,
2006 new_references.school_use_txt ,
2007 new_references.expect_family_contribute_amt,
2008 new_references.borower_electronic_sign_flag,
2009 new_references.borower_credit_authoriz_flag,
2010 new_references.esign_src_typ_cd
2011 );
2012
2013 OPEN c;
2014 FETCH c INTO x_rowid;
2015 IF (c%NOTFOUND) THEN
2016 CLOSE c;
2017 RAISE NO_DATA_FOUND;
2018 END IF;
2019 CLOSE c;
2020
2021 after_dml (p_action => 'INSERT');
2022 END insert_row;
2023
2024
2025 PROCEDURE lock_row (
2026 x_rowid IN VARCHAR2,
2027 x_loan_id IN NUMBER,
2028 x_origination_id IN NUMBER,
2029 x_loan_number IN VARCHAR2,
2030 x_loan_type IN VARCHAR2,
2031 x_loan_amt_offered IN NUMBER,
2032 x_loan_amt_accepted IN NUMBER,
2033 x_loan_per_begin_date IN DATE,
2034 x_loan_per_end_date IN DATE,
2035 x_acad_yr_begin_date IN DATE,
2036 x_acad_yr_end_date IN DATE,
2037 x_loan_status IN VARCHAR2,
2041 x_req_serial_loan_code IN VARCHAR2,
2038 x_loan_status_date IN DATE,
2039 x_loan_chg_status IN VARCHAR2,
2040 x_loan_chg_status_date IN DATE,
2042 x_act_serial_loan_code IN VARCHAR2,
2043 x_active IN VARCHAR2,
2044 x_active_date IN DATE,
2045 x_sch_cert_date IN DATE,
2046 x_orig_status_flag IN VARCHAR2,
2047 x_orig_batch_id IN VARCHAR2,
2048 x_orig_batch_date IN DATE,
2049 x_chg_batch_id IN VARCHAR2,
2050 x_orig_ack_date IN DATE,
2051 x_credit_override IN VARCHAR2,
2052 x_credit_decision_date IN DATE,
2053 x_pnote_delivery_code IN VARCHAR2,
2054 x_pnote_status IN VARCHAR2,
2055 x_pnote_status_date IN DATE,
2056 x_pnote_id IN VARCHAR2,
2057 x_pnote_print_ind IN VARCHAR2,
2058 x_pnote_accept_amt IN NUMBER,
2059 x_pnote_accept_date IN DATE,
2060 x_p_signature_code IN VARCHAR2,
2061 x_p_signature_date IN DATE,
2062 x_s_signature_code IN VARCHAR2,
2063 x_unsub_elig_for_heal IN VARCHAR2,
2064 x_disclosure_print_ind IN VARCHAR2,
2065 x_orig_fee_perct IN NUMBER,
2066 x_borw_confirm_ind IN VARCHAR2,
2067 x_borw_interest_ind IN VARCHAR2,
2068 x_unsub_elig_for_depnt IN VARCHAR2,
2069 x_guarantee_amt IN NUMBER,
2070 x_guarantee_date IN DATE,
2071 x_guarnt_adj_ind IN VARCHAR2,
2072 x_guarnt_amt_redn_code IN VARCHAR2,
2073 x_guarnt_status_code IN VARCHAR2,
2074 x_guarnt_status_date IN DATE,
2075 x_lend_apprv_denied_code IN VARCHAR2,
2076 x_lend_apprv_denied_date IN DATE,
2077 x_lend_status_code IN VARCHAR2,
2078 x_lend_status_date IN DATE,
2079 x_grade_level_code IN VARCHAR2,
2080 x_enrollment_code IN VARCHAR2,
2081 x_anticip_compl_date IN DATE,
2082 x_borw_lender_id IN VARCHAR2,
2083 x_duns_borw_lender_id IN VARCHAR2,
2084 x_guarantor_id IN VARCHAR2,
2085 x_duns_guarnt_id IN VARCHAR2,
2086 x_prc_type_code IN VARCHAR2,
2087 x_rec_type_ind IN VARCHAR2,
2088 x_cl_loan_type IN VARCHAR2,
2089 x_cl_seq_number IN NUMBER,
2090 x_last_resort_lender IN VARCHAR2,
2091 x_lender_id IN VARCHAR2,
2092 x_duns_lender_id IN VARCHAR2,
2093 x_lend_non_ed_brc_id IN VARCHAR2,
2094 x_recipient_id IN VARCHAR2,
2095 x_recipient_type IN VARCHAR2,
2096 x_duns_recip_id IN VARCHAR2,
2097 x_recip_non_ed_brc_id IN VARCHAR2,
2098 x_cl_rec_status IN VARCHAR2,
2099 x_cl_rec_status_last_update IN DATE,
2100 x_alt_prog_type_code IN VARCHAR2,
2101 x_alt_appl_ver_code IN NUMBER,
2102 x_borw_outstd_loan_code IN VARCHAR2,
2103 x_mpn_confirm_code IN VARCHAR2,
2104 x_resp_to_orig_code IN VARCHAR2,
2105 x_appl_loan_phase_code IN VARCHAR2,
2106 x_appl_loan_phase_code_chg IN DATE,
2107 x_tot_outstd_stafford IN NUMBER,
2108 x_tot_outstd_plus IN NUMBER,
2109 x_alt_borw_tot_debt IN NUMBER,
2110 x_act_interest_rate IN NUMBER,
2111 x_service_type_code IN VARCHAR2,
2112 x_rev_notice_of_guarnt IN VARCHAR2,
2113 x_sch_refund_amt IN NUMBER,
2114 x_sch_refund_date IN DATE,
2115 x_uniq_layout_vend_code IN VARCHAR2,
2116 x_uniq_layout_ident_code IN VARCHAR2,
2117 x_p_person_id IN NUMBER,
2118 x_p_ssn IN VARCHAR2,
2119 x_p_ssn_chg_date IN DATE,
2120 x_p_last_name IN VARCHAR2,
2121 x_p_first_name IN VARCHAR2,
2122 x_p_middle_name IN VARCHAR2,
2123 x_p_permt_addr1 IN VARCHAR2,
2124 x_p_permt_addr2 IN VARCHAR2,
2125 x_p_permt_city IN VARCHAR2,
2126 x_p_permt_state IN VARCHAR2,
2127 x_p_permt_zip IN VARCHAR2,
2128 x_p_permt_addr_chg_date IN DATE,
2129 x_p_permt_phone IN VARCHAR2,
2130 x_p_email_addr IN VARCHAR2,
2131 x_p_date_of_birth IN DATE,
2132 x_p_dob_chg_date IN DATE,
2133 x_p_license_num IN VARCHAR2,
2137 x_p_default_status IN VARCHAR2,
2134 x_p_license_state IN VARCHAR2,
2135 x_p_citizenship_status IN VARCHAR2,
2136 x_p_alien_reg_num IN VARCHAR2,
2138 x_p_foreign_postal_code IN VARCHAR2,
2139 x_p_state_of_legal_res IN VARCHAR2,
2140 x_p_legal_res_date IN DATE,
2141 x_s_ssn IN VARCHAR2,
2142 x_s_ssn_chg_date IN DATE,
2143 x_s_last_name IN VARCHAR2,
2144 x_s_first_name IN VARCHAR2,
2145 x_s_middle_name IN VARCHAR2,
2146 x_s_permt_addr1 IN VARCHAR2,
2147 x_s_permt_addr2 IN VARCHAR2,
2148 x_s_permt_city IN VARCHAR2,
2149 x_s_permt_state IN VARCHAR2,
2150 x_s_permt_zip IN VARCHAR2,
2151 x_s_permt_addr_chg_date IN DATE,
2152 x_s_permt_phone IN VARCHAR2,
2153 x_s_local_addr1 IN VARCHAR2,
2154 x_s_local_addr2 IN VARCHAR2,
2155 x_s_local_city IN VARCHAR2,
2156 x_s_local_state IN VARCHAR2,
2157 x_s_local_zip IN VARCHAR2,
2158 x_s_local_addr_chg_date IN DATE,
2159 x_s_email_addr IN VARCHAR2,
2160 x_s_date_of_birth IN DATE,
2161 x_s_dob_chg_date IN DATE,
2162 x_s_license_num IN VARCHAR2,
2163 x_s_license_state IN VARCHAR2,
2164 x_s_depncy_status IN VARCHAR2,
2165 x_s_default_status IN VARCHAR2,
2166 x_s_citizenship_status IN VARCHAR2,
2167 x_s_alien_reg_num IN VARCHAR2,
2168 x_s_foreign_postal_code IN VARCHAR2,
2169 x_pnote_batch_id IN VARCHAR2,
2170 x_pnote_ack_date IN DATE,
2171 x_pnote_mpn_ind IN VARCHAR2,
2172 x_award_id IN NUMBER,
2173 x_base_id IN NUMBER,
2174 x_document_id_txt IN VARCHAR2,
2175 x_loan_key_num IN NUMBER,
2176 x_interest_rebate_percent_num IN NUMBER,
2177 x_fin_award_year IN VARCHAR2,
2178 x_cps_trans_num IN NUMBER,
2179 x_atd_entity_id_txt IN VARCHAR2,
2180 x_rep_entity_id_txt IN VARCHAR2,
2181 x_source_entity_id_txt IN VARCHAR2,
2182 x_pymt_servicer_amt IN NUMBER,
2183 x_pymt_servicer_date IN DATE,
2184 x_book_loan_amt IN NUMBER,
2185 x_book_loan_amt_date IN DATE,
2186 x_s_chg_birth_date IN DATE,
2187 x_s_chg_ssn IN VARCHAR2,
2188 x_s_chg_last_name IN VARCHAR2,
2189 x_b_chg_birth_date IN DATE,
2190 x_b_chg_ssn IN VARCHAR2,
2191 x_b_chg_last_name IN VARCHAR2,
2192 x_note_message IN VARCHAR2,
2193 x_full_resp_code IN VARCHAR2,
2194 x_s_permt_county IN VARCHAR2,
2195 x_b_permt_county IN VARCHAR2,
2196 x_s_permt_country IN VARCHAR2,
2197 x_b_permt_country IN VARCHAR2,
2198 x_crdt_decision_status IN VARCHAR2,
2199 x_external_loan_id_txt IN VARCHAR2,
2200 x_deferment_request_code IN VARCHAR2,
2201 x_eft_authorization_code IN VARCHAR2,
2202 x_requested_loan_amt IN NUMBER ,
2203 x_actual_record_type_code IN VARCHAR2,
2204 x_reinstatement_amt IN NUMBER ,
2205 x_lender_use_txt IN VARCHAR2,
2206 x_guarantor_use_txt IN VARCHAR2,
2207 x_fls_approved_amt IN NUMBER ,
2208 x_flu_approved_amt IN NUMBER ,
2209 x_flp_approved_amt IN NUMBER ,
2210 x_alt_approved_amt IN NUMBER ,
2211 x_loan_app_form_code IN VARCHAR2,
2212 x_alt_borrower_ind_flag IN VARCHAR2,
2213 x_school_id_txt IN VARCHAR2,
2214 x_cost_of_attendance_amt IN NUMBER ,
2215 x_established_fin_aid_amount IN NUMBER ,
2216 x_student_electronic_sign_flag IN VARCHAR2,
2217 x_mpn_type_flag IN VARCHAR2,
2218 x_school_use_txt IN VARCHAR2,
2219 x_expect_family_contribute_amt IN NUMBER ,
2220 x_borower_electronic_sign_flag IN VARCHAR2,
2221 x_borower_credit_authoriz_flag IN VARCHAR2,
2222 x_esign_src_typ_cd IN VARCHAR2
2223
2224 ) AS
2225 /*
2226 || Created By : venagara
2227 || Created On : 22-JAN-2001
2228 || Purpose : Handles the LOCK mechanism for the table.
2232 || veramach 23-SEP-2003 Bug 3104228: Removed checks for lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
2229 || Known limitations, enhancements or remarks :
2230 || Change History :
2231 || Who When What
2233 || cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
2234 || p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
2235 || chg_batch_id from lock_row
2236 || (reverse chronological order - newest change first)
2237 */
2238 CURSOR c1 IS
2239 SELECT
2240 origination_id,
2241 loan_number,
2242 loan_type,
2243 loan_amt_offered,
2244 loan_amt_accepted,
2245 loan_per_begin_date,
2246 loan_per_end_date,
2247 acad_yr_begin_date,
2248 acad_yr_end_date,
2249 loan_status,
2250 loan_status_date,
2251 loan_chg_status,
2252 loan_chg_status_date,
2253 req_serial_loan_code,
2254 act_serial_loan_code,
2255 active,
2256 active_date,
2257 sch_cert_date,
2258 orig_status_flag,
2259 orig_batch_id,
2260 orig_batch_date,
2261 chg_batch_id,
2262 orig_ack_date,
2263 credit_override,
2264 credit_decision_date,
2265 pnote_delivery_code,
2266 pnote_status,
2267 pnote_status_date,
2268 pnote_id,
2269 pnote_print_ind,
2270 pnote_accept_amt,
2271 pnote_accept_date,
2272 p_signature_code,
2273 p_signature_date,
2274 s_signature_code,
2275 unsub_elig_for_heal,
2276 disclosure_print_ind,
2277 orig_fee_perct,
2278 borw_confirm_ind,
2279 borw_interest_ind,
2280 unsub_elig_for_depnt,
2281 guarantee_amt,
2282 guarantee_date,
2283 guarnt_adj_ind,
2284 guarnt_amt_redn_code,
2285 guarnt_status_code,
2286 guarnt_status_date,
2287 lend_apprv_denied_code,
2288 lend_apprv_denied_date,
2289 lend_status_code,
2290 lend_status_date,
2291 grade_level_code,
2292 enrollment_code,
2293 anticip_compl_date,
2294 borw_lender_id,
2295 guarantor_id,
2296 prc_type_code,
2297 rec_type_ind,
2298 cl_loan_type,
2299 cl_seq_number,
2300 last_resort_lender,
2301 lender_id,
2302 lend_non_ed_brc_id,
2303 recipient_id,
2304 recipient_type,
2305 recip_non_ed_brc_id,
2306 cl_rec_status,
2307 cl_rec_status_last_update,
2308 alt_prog_type_code,
2309 alt_appl_ver_code,
2310 borw_outstd_loan_code,
2311 mpn_confirm_code,
2312 resp_to_orig_code,
2313 appl_loan_phase_code,
2314 appl_loan_phase_code_chg,
2315 tot_outstd_stafford,
2316 tot_outstd_plus,
2317 alt_borw_tot_debt,
2318 act_interest_rate,
2319 service_type_code,
2320 rev_notice_of_guarnt,
2321 sch_refund_amt,
2322 sch_refund_date,
2323 uniq_layout_vend_code,
2324 uniq_layout_ident_code,
2325 p_person_id,
2326 p_ssn,
2327 p_ssn_chg_date,
2328 p_last_name,
2329 p_first_name,
2330 p_middle_name,
2331 p_permt_addr1,
2332 p_permt_addr2,
2333 p_permt_city,
2334 p_permt_state,
2335 p_permt_zip,
2336 p_permt_addr_chg_date,
2337 p_permt_phone,
2338 p_email_addr,
2339 p_date_of_birth,
2340 p_dob_chg_date,
2341 p_license_num,
2342 p_license_state,
2343 p_citizenship_status,
2344 p_alien_reg_num,
2345 p_default_status,
2346 p_foreign_postal_code,
2347 p_state_of_legal_res,
2348 p_legal_res_date,
2349 s_ssn,
2350 s_ssn_chg_date,
2351 s_last_name,
2352 s_first_name,
2353 s_middle_name,
2354 s_permt_addr1,
2355 s_permt_addr2,
2356 s_permt_city,
2357 s_permt_state,
2358 s_permt_zip,
2359 s_permt_addr_chg_date,
2360 s_permt_phone,
2361 s_local_addr1,
2362 s_local_addr2,
2363 s_local_city,
2364 s_local_state,
2365 s_local_zip,
2366 s_local_addr_chg_date,
2367 s_email_addr,
2368 s_date_of_birth,
2369 s_dob_chg_date,
2370 s_license_num,
2371 s_license_state,
2372 s_depncy_status,
2373 s_default_status,
2374 s_citizenship_status,
2375 s_alien_reg_num,
2376 s_foreign_postal_code,
2377 org_id,
2378 pnote_batch_id,
2379 pnote_ack_date,
2380 pnote_mpn_ind,
2381 award_id,
2382 base_id,
2383 document_id_txt,
2384 loan_key_num,
2385 interest_rebate_percent_num,
2386 fin_award_year,
2387 cps_trans_num,
2388 atd_entity_id_txt,
2389 rep_entity_id_txt,
2390 source_entity_id_txt,
2394 book_loan_amt_date,
2391 pymt_servicer_amt,
2392 pymt_servicer_date,
2393 book_loan_amt,
2395 s_chg_birth_date,
2396 s_chg_ssn,
2397 s_chg_last_name,
2398 b_chg_birth_date,
2399 b_chg_ssn,
2400 b_chg_last_name,
2401 note_message,
2402 full_resp_code,
2403 s_permt_county,
2404 b_permt_county,
2405 s_permt_country,
2406 b_permt_country,
2407 crdt_decision_status,
2408 external_loan_id_txt ,
2409 deferment_request_code ,
2410 eft_authorization_code ,
2411 requested_loan_amt ,
2412 actual_record_type_code ,
2413 reinstatement_amt ,
2414 lender_use_txt ,
2415 guarantor_use_txt ,
2416 fls_approved_amt ,
2417 flu_approved_amt ,
2418 flp_approved_amt ,
2419 alt_approved_amt ,
2420 loan_app_form_code ,
2421 alt_borrower_ind_flag ,
2422 school_id_txt ,
2423 cost_of_attendance_amt ,
2424 established_fin_aid_amount ,
2425 student_electronic_sign_flag,
2426 mpn_type_flag ,
2427 school_use_txt ,
2428 expect_family_contribute_amt,
2429 borower_electronic_sign_flag,
2430 borower_credit_authoriz_flag,
2431 esign_src_typ_cd
2432
2433 FROM igf_sl_lor_loc_all
2434 WHERE rowid = x_rowid
2435 FOR UPDATE NOWAIT;
2436
2437 tlinfo c1%ROWTYPE;
2438
2439 BEGIN
2440
2441 OPEN c1;
2442 FETCH c1 INTO tlinfo;
2443 IF (c1%notfound) THEN
2444 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2445 igs_ge_msg_stack.add;
2446 CLOSE c1;
2447 app_exception.raise_exception;
2448 RETURN;
2449 END IF;
2450 CLOSE c1;
2451
2452 IF (
2453 (tlinfo.origination_id = x_origination_id)
2454 AND (tlinfo.loan_number = x_loan_number)
2455 AND (tlinfo.loan_type = x_loan_type)
2456 AND ((tlinfo.loan_amt_offered = x_loan_amt_offered) OR ((tlinfo.loan_amt_offered IS NULL) AND (X_loan_amt_offered IS NULL)))
2457 AND ((tlinfo.loan_amt_accepted = x_loan_amt_accepted) OR ((tlinfo.loan_amt_accepted IS NULL) AND (X_loan_amt_accepted IS NULL)))
2458 AND ((tlinfo.loan_per_begin_date = x_loan_per_begin_date) OR ((tlinfo.loan_per_begin_date IS NULL) AND (X_loan_per_begin_date IS NULL)))
2459 AND ((tlinfo.loan_per_end_date = x_loan_per_end_date) OR ((tlinfo.loan_per_end_date IS NULL) AND (X_loan_per_end_date IS NULL)))
2460 AND ((tlinfo.acad_yr_begin_date = x_acad_yr_begin_date) OR ((tlinfo.acad_yr_begin_date IS NULL) AND (X_acad_yr_begin_date IS NULL)))
2461 AND ((tlinfo.acad_yr_end_date = x_acad_yr_end_date) OR ((tlinfo.acad_yr_end_date IS NULL) AND (X_acad_yr_end_date IS NULL)))
2462 AND ((tlinfo.loan_status = x_loan_status) OR ((tlinfo.loan_status IS NULL) AND (X_loan_status IS NULL)))
2463 AND ((tlinfo.loan_status_date = x_loan_status_date) OR ((tlinfo.loan_status_date IS NULL) AND (X_loan_status_date IS NULL)))
2464 AND ((tlinfo.loan_chg_status = x_loan_chg_status) OR ((tlinfo.loan_chg_status IS NULL) AND (X_loan_chg_status IS NULL)))
2465 AND ((tlinfo.loan_chg_status_date = x_loan_chg_status_date) OR ((tlinfo.loan_chg_status_date IS NULL) AND (X_loan_chg_status_date IS NULL)))
2466 AND ((tlinfo.req_serial_loan_code = x_req_serial_loan_code) OR ((tlinfo.req_serial_loan_code IS NULL) AND (X_req_serial_loan_code IS NULL)))
2467 AND ((tlinfo.act_serial_loan_code = x_act_serial_loan_code) OR ((tlinfo.act_serial_loan_code IS NULL) AND (X_act_serial_loan_code IS NULL)))
2468 AND ((tlinfo.active = x_active) OR ((tlinfo.active IS NULL) AND (X_active IS NULL)))
2469 AND ((tlinfo.active_date = x_active_date) OR ((tlinfo.active_date IS NULL) AND (X_active_date IS NULL)))
2470 AND ((tlinfo.sch_cert_date = x_sch_cert_date) OR ((tlinfo.sch_cert_date IS NULL) AND (X_sch_cert_date IS NULL)))
2471 AND ((tlinfo.orig_status_flag = x_orig_status_flag) OR ((tlinfo.orig_status_flag IS NULL) AND (X_orig_status_flag IS NULL)))
2472 AND ((tlinfo.orig_batch_id = x_orig_batch_id) OR ((tlinfo.orig_batch_id IS NULL) AND (X_orig_batch_id IS NULL)))
2473 AND ((tlinfo.orig_batch_date = x_orig_batch_date) OR ((tlinfo.orig_batch_date IS NULL) AND (X_orig_batch_date IS NULL)))
2474 AND ((tlinfo.orig_ack_date = x_orig_ack_date) OR ((tlinfo.orig_ack_date IS NULL) AND (X_orig_ack_date IS NULL)))
2475 AND ((tlinfo.credit_override = x_credit_override) OR ((tlinfo.credit_override IS NULL) AND (X_credit_override IS NULL)))
2476 AND ((tlinfo.credit_decision_date = x_credit_decision_date) OR ((tlinfo.credit_decision_date IS NULL) AND (X_credit_decision_date IS NULL)))
2477 AND ((tlinfo.pnote_delivery_code = x_pnote_delivery_code) OR ((tlinfo.pnote_delivery_code IS NULL) AND (X_pnote_delivery_code IS NULL)))
2478 AND ((tlinfo.pnote_status = x_pnote_status) OR ((tlinfo.pnote_status IS NULL) AND (X_pnote_status IS NULL)))
2479 AND ((tlinfo.pnote_status_date = x_pnote_status_date) OR ((tlinfo.pnote_status_date IS NULL) AND (X_pnote_status_date IS NULL)))
2480 AND ((tlinfo.pnote_id = x_pnote_id) OR ((tlinfo.pnote_id IS NULL) AND (X_pnote_id IS NULL)))
2481 AND ((tlinfo.pnote_print_ind = x_pnote_print_ind) OR ((tlinfo.pnote_print_ind IS NULL) AND (X_pnote_print_ind IS NULL)))
2482 AND ((tlinfo.pnote_accept_amt = x_pnote_accept_amt) OR ((tlinfo.pnote_accept_amt IS NULL) AND (X_pnote_accept_amt IS NULL)))
2483 AND ((tlinfo.pnote_accept_date = x_pnote_accept_date) OR ((tlinfo.pnote_accept_date IS NULL) AND (X_pnote_accept_date IS NULL)))
2487 AND ((tlinfo.unsub_elig_for_heal = x_unsub_elig_for_heal) OR ((tlinfo.unsub_elig_for_heal IS NULL) AND (X_unsub_elig_for_heal IS NULL)))
2484 AND ((tlinfo.p_signature_code = x_p_signature_code) OR ((tlinfo.p_signature_code IS NULL) AND (X_p_signature_code IS NULL)))
2485 AND ((tlinfo.p_signature_date = x_p_signature_date) OR ((tlinfo.p_signature_date IS NULL) AND (X_p_signature_date IS NULL)))
2486 AND ((tlinfo.s_signature_code = x_s_signature_code) OR ((tlinfo.s_signature_code IS NULL) AND (X_s_signature_code IS NULL)))
2488 AND ((tlinfo.disclosure_print_ind = x_disclosure_print_ind) OR ((tlinfo.disclosure_print_ind IS NULL) AND (X_disclosure_print_ind IS NULL)))
2489 AND ((tlinfo.orig_fee_perct = x_orig_fee_perct) OR ((tlinfo.orig_fee_perct IS NULL) AND (X_orig_fee_perct IS NULL)))
2490 AND ((tlinfo.borw_confirm_ind = x_borw_confirm_ind) OR ((tlinfo.borw_confirm_ind IS NULL) AND (X_borw_confirm_ind IS NULL)))
2491 AND ((tlinfo.borw_interest_ind = x_borw_interest_ind) OR ((tlinfo.borw_interest_ind IS NULL) AND (X_borw_interest_ind IS NULL)))
2492 AND ((tlinfo.unsub_elig_for_depnt = x_unsub_elig_for_depnt) OR ((tlinfo.unsub_elig_for_depnt IS NULL) AND (X_unsub_elig_for_depnt IS NULL)))
2493 AND ((tlinfo.guarantee_amt = x_guarantee_amt) OR ((tlinfo.guarantee_amt IS NULL) AND (X_guarantee_amt IS NULL)))
2494 AND ((tlinfo.guarantee_date = x_guarantee_date) OR ((tlinfo.guarantee_date IS NULL) AND (X_guarantee_date IS NULL)))
2495 AND ((tlinfo.guarnt_adj_ind = x_guarnt_adj_ind) OR ((tlinfo.guarnt_adj_ind IS NULL) AND (X_guarnt_adj_ind IS NULL)))
2496 AND ((tlinfo.guarnt_amt_redn_code = x_guarnt_amt_redn_code) OR ((tlinfo.guarnt_amt_redn_code IS NULL) AND (X_guarnt_amt_redn_code IS NULL)))
2497 AND ((tlinfo.guarnt_status_code = x_guarnt_status_code) OR ((tlinfo.guarnt_status_code IS NULL) AND (X_guarnt_status_code IS NULL)))
2498 AND ((tlinfo.guarnt_status_date = x_guarnt_status_date) OR ((tlinfo.guarnt_status_date IS NULL) AND (X_guarnt_status_date IS NULL)))
2499 AND ((tlinfo.lend_status_code = x_lend_status_code) OR ((tlinfo.lend_status_code IS NULL) AND (X_lend_status_code IS NULL)))
2500 AND ((tlinfo.lend_status_date = x_lend_status_date) OR ((tlinfo.lend_status_date IS NULL) AND (X_lend_status_date IS NULL)))
2501 AND ((tlinfo.grade_level_code = x_grade_level_code) OR ((tlinfo.grade_level_code IS NULL) AND (X_grade_level_code IS NULL)))
2502 AND ((tlinfo.enrollment_code = x_enrollment_code) OR ((tlinfo.enrollment_code IS NULL) AND (X_enrollment_code IS NULL)))
2503 AND ((tlinfo.anticip_compl_date = x_anticip_compl_date) OR ((tlinfo.anticip_compl_date IS NULL) AND (X_anticip_compl_date IS NULL)))
2504 AND ((tlinfo.borw_lender_id = x_borw_lender_id) OR ((tlinfo.borw_lender_id IS NULL) AND (X_borw_lender_id IS NULL)))
2505 AND ((tlinfo.guarantor_id = x_guarantor_id) OR ((tlinfo.guarantor_id IS NULL) AND (X_guarantor_id IS NULL)))
2506 AND ((tlinfo.prc_type_code = x_prc_type_code) OR ((tlinfo.prc_type_code IS NULL) AND (X_prc_type_code IS NULL)))
2507 AND ((tlinfo.rec_type_ind = x_rec_type_ind) OR ((tlinfo.rec_type_ind IS NULL) AND (X_rec_type_ind IS NULL)))
2508 AND ((tlinfo.cl_loan_type = x_cl_loan_type) OR ((tlinfo.cl_loan_type IS NULL) AND (X_cl_loan_type IS NULL)))
2509 AND ((tlinfo.cl_seq_number = x_cl_seq_number) OR ((tlinfo.cl_seq_number IS NULL) AND (X_cl_seq_number IS NULL)))
2510 AND ((tlinfo.last_resort_lender = x_last_resort_lender) OR ((tlinfo.last_resort_lender IS NULL) AND (X_last_resort_lender IS NULL)))
2511 AND ((tlinfo.lender_id = x_lender_id) OR ((tlinfo.lender_id IS NULL) AND (X_lender_id IS NULL)))
2512 AND ((tlinfo.lend_non_ed_brc_id = x_lend_non_ed_brc_id) OR ((tlinfo.lend_non_ed_brc_id IS NULL) AND (X_lend_non_ed_brc_id IS NULL)))
2513 AND ((tlinfo.recipient_id = x_recipient_id) OR ((tlinfo.recipient_id IS NULL) AND (X_recipient_id IS NULL)))
2514 AND ((tlinfo.recipient_type = x_recipient_type) OR ((tlinfo.recipient_type IS NULL) AND (X_recipient_type IS NULL)))
2515 AND ((tlinfo.recip_non_ed_brc_id = x_recip_non_ed_brc_id) OR ((tlinfo.recip_non_ed_brc_id IS NULL) AND (X_recip_non_ed_brc_id IS NULL)))
2516 AND ((tlinfo.alt_prog_type_code = x_alt_prog_type_code) OR ((tlinfo.alt_prog_type_code IS NULL) AND (X_alt_prog_type_code IS NULL)))
2517 AND ((tlinfo.alt_appl_ver_code = x_alt_appl_ver_code) OR ((tlinfo.alt_appl_ver_code IS NULL) AND (X_alt_appl_ver_code IS NULL)))
2518 AND ((tlinfo.borw_outstd_loan_code = x_borw_outstd_loan_code) OR ((tlinfo.borw_outstd_loan_code IS NULL) AND (X_borw_outstd_loan_code IS NULL)))
2519 AND ((tlinfo.resp_to_orig_code = x_resp_to_orig_code) OR ((tlinfo.resp_to_orig_code IS NULL) AND (X_resp_to_orig_code IS NULL)))
2520 AND ((tlinfo.tot_outstd_stafford = x_tot_outstd_stafford) OR ((tlinfo.tot_outstd_stafford IS NULL) AND (X_tot_outstd_stafford IS NULL)))
2521 AND ((tlinfo.tot_outstd_plus = x_tot_outstd_plus) OR ((tlinfo.tot_outstd_plus IS NULL) AND (X_tot_outstd_plus IS NULL)))
2522 AND ((tlinfo.alt_borw_tot_debt = x_alt_borw_tot_debt) OR ((tlinfo.alt_borw_tot_debt IS NULL) AND (X_alt_borw_tot_debt IS NULL)))
2523 AND ((tlinfo.act_interest_rate = x_act_interest_rate) OR ((tlinfo.act_interest_rate IS NULL) AND (X_act_interest_rate IS NULL)))
2524 AND ((tlinfo.service_type_code = x_service_type_code) OR ((tlinfo.service_type_code IS NULL) AND (X_service_type_code IS NULL)))
2525 AND ((tlinfo.rev_notice_of_guarnt = x_rev_notice_of_guarnt) OR ((tlinfo.rev_notice_of_guarnt IS NULL) AND (X_rev_notice_of_guarnt IS NULL)))
2526 AND ((tlinfo.sch_refund_amt = x_sch_refund_amt) OR ((tlinfo.sch_refund_amt IS NULL) AND (X_sch_refund_amt IS NULL)))
2527 AND ((tlinfo.sch_refund_date = x_sch_refund_date) OR ((tlinfo.sch_refund_date IS NULL) AND (X_sch_refund_date IS NULL)))
2528 AND ((tlinfo.uniq_layout_vend_code = x_uniq_layout_vend_code) OR ((tlinfo.uniq_layout_vend_code IS NULL) AND (X_uniq_layout_vend_code IS NULL)))
2532 AND ((tlinfo.p_last_name = x_p_last_name) OR ((tlinfo.p_last_name IS NULL) AND (X_p_last_name IS NULL)))
2529 AND ((tlinfo.uniq_layout_ident_code = x_uniq_layout_ident_code) OR ((tlinfo.uniq_layout_ident_code IS NULL) AND (X_uniq_layout_ident_code IS NULL)))
2530 AND ((tlinfo.p_person_id = x_p_person_id) OR ((tlinfo.p_person_id IS NULL) AND (X_p_person_id IS NULL)))
2531 AND ((tlinfo.p_ssn = x_p_ssn) OR ((tlinfo.p_ssn IS NULL) AND (X_p_ssn IS NULL)))
2533 AND ((tlinfo.p_first_name = x_p_first_name) OR ((tlinfo.p_first_name IS NULL) AND (X_p_first_name IS NULL)))
2534 AND ((tlinfo.p_middle_name = x_p_middle_name) OR ((tlinfo.p_middle_name IS NULL) AND (X_p_middle_name IS NULL)))
2535 AND ((tlinfo.p_permt_addr1 = x_p_permt_addr1) OR ((tlinfo.p_permt_addr1 IS NULL) AND (X_p_permt_addr1 IS NULL)))
2536 AND ((tlinfo.p_permt_addr2 = x_p_permt_addr2) OR ((tlinfo.p_permt_addr2 IS NULL) AND (X_p_permt_addr2 IS NULL)))
2537 AND ((tlinfo.p_permt_city = x_p_permt_city) OR ((tlinfo.p_permt_city IS NULL) AND (X_p_permt_city IS NULL)))
2538 AND ((tlinfo.p_permt_state = x_p_permt_state) OR ((tlinfo.p_permt_state IS NULL) AND (X_p_permt_state IS NULL)))
2539 AND ((tlinfo.p_permt_zip = x_p_permt_zip) OR ((tlinfo.p_permt_zip IS NULL) AND (X_p_permt_zip IS NULL)))
2540 AND ((tlinfo.p_permt_addr_chg_date = x_p_permt_addr_chg_date) OR ((tlinfo.p_permt_addr_chg_date IS NULL) AND (X_p_permt_addr_chg_date IS NULL)))
2541 AND ((tlinfo.p_permt_phone = x_p_permt_phone) OR ((tlinfo.p_permt_phone IS NULL) AND (X_p_permt_phone IS NULL)))
2542 AND ((tlinfo.p_email_addr = x_p_email_addr) OR ((tlinfo.p_email_addr IS NULL) AND (X_p_email_addr IS NULL)))
2543 AND ((tlinfo.p_date_of_birth = x_p_date_of_birth) OR ((tlinfo.p_date_of_birth IS NULL) AND (X_p_date_of_birth IS NULL)))
2544 AND ((tlinfo.p_license_num = x_p_license_num) OR ((tlinfo.p_license_num IS NULL) AND (X_p_license_num IS NULL)))
2545 AND ((tlinfo.p_license_state = x_p_license_state) OR ((tlinfo.p_license_state IS NULL) AND (X_p_license_state IS NULL)))
2546 AND ((tlinfo.p_citizenship_status = x_p_citizenship_status) OR ((tlinfo.p_citizenship_status IS NULL) AND (X_p_citizenship_status IS NULL)))
2547 AND ((tlinfo.p_alien_reg_num = x_p_alien_reg_num) OR ((tlinfo.p_alien_reg_num IS NULL) AND (X_p_alien_reg_num IS NULL)))
2548 AND ((tlinfo.p_default_status = x_p_default_status) OR ((tlinfo.p_default_status IS NULL) AND (X_p_default_status IS NULL)))
2549 AND ((tlinfo.p_foreign_postal_code = x_p_foreign_postal_code) OR ((tlinfo.p_foreign_postal_code IS NULL) AND (X_p_foreign_postal_code IS NULL)))
2550 AND ((tlinfo.p_state_of_legal_res = x_p_state_of_legal_res) OR ((tlinfo.p_state_of_legal_res IS NULL) AND (X_p_state_of_legal_res IS NULL)))
2551 AND ((tlinfo.p_legal_res_date = x_p_legal_res_date) OR ((tlinfo.p_legal_res_date IS NULL) AND (X_p_legal_res_date IS NULL)))
2552 AND ((tlinfo.s_ssn = x_s_ssn) OR ((tlinfo.s_ssn IS NULL) AND (X_s_ssn IS NULL)))
2553 AND ((tlinfo.s_last_name = x_s_last_name) OR ((tlinfo.s_last_name IS NULL) AND (X_s_last_name IS NULL)))
2554 AND ((tlinfo.s_first_name = x_s_first_name) OR ((tlinfo.s_first_name IS NULL) AND (X_s_first_name IS NULL)))
2555 AND ((tlinfo.s_middle_name = x_s_middle_name) OR ((tlinfo.s_middle_name IS NULL) AND (X_s_middle_name IS NULL)))
2556 AND ((tlinfo.s_permt_addr1 = x_s_permt_addr1) OR ((tlinfo.s_permt_addr1 IS NULL) AND (X_s_permt_addr1 IS NULL)))
2557 AND ((tlinfo.s_permt_addr2 = x_s_permt_addr2) OR ((tlinfo.s_permt_addr2 IS NULL) AND (X_s_permt_addr2 IS NULL)))
2558 AND ((tlinfo.s_permt_city = x_s_permt_city) OR ((tlinfo.s_permt_city IS NULL) AND (X_s_permt_city IS NULL)))
2559 AND ((tlinfo.s_permt_state = x_s_permt_state) OR ((tlinfo.s_permt_state IS NULL) AND (X_s_permt_state IS NULL)))
2560 AND ((tlinfo.s_permt_zip = x_s_permt_zip) OR ((tlinfo.s_permt_zip IS NULL) AND (X_s_permt_zip IS NULL)))
2561 AND ((tlinfo.s_permt_addr_chg_date = x_s_permt_addr_chg_date) OR ((tlinfo.s_permt_addr_chg_date IS NULL) AND (X_s_permt_addr_chg_date IS NULL)))
2562 AND ((tlinfo.s_permt_phone = x_s_permt_phone) OR ((tlinfo.s_permt_phone IS NULL) AND (X_s_permt_phone IS NULL)))
2563 AND ((tlinfo.s_local_addr1 = x_s_local_addr1) OR ((tlinfo.s_local_addr1 IS NULL) AND (X_s_local_addr1 IS NULL)))
2564 AND ((tlinfo.s_local_addr2 = x_s_local_addr2) OR ((tlinfo.s_local_addr2 IS NULL) AND (X_s_local_addr2 IS NULL)))
2565 AND ((tlinfo.s_local_city = x_s_local_city) OR ((tlinfo.s_local_city IS NULL) AND (X_s_local_city IS NULL)))
2566 AND ((tlinfo.s_local_state = x_s_local_state) OR ((tlinfo.s_local_state IS NULL) AND (X_s_local_state IS NULL)))
2567 AND ((tlinfo.s_local_zip = x_s_local_zip) OR ((tlinfo.s_local_zip IS NULL) AND (X_s_local_zip IS NULL)))
2568 AND ((tlinfo.s_email_addr = x_s_email_addr) OR ((tlinfo.s_email_addr IS NULL) AND (X_s_email_addr IS NULL)))
2569 AND ((tlinfo.s_date_of_birth = x_s_date_of_birth) OR ((tlinfo.s_date_of_birth IS NULL) AND (X_s_date_of_birth IS NULL)))
2570 AND ((tlinfo.s_license_num = x_s_license_num) OR ((tlinfo.s_license_num IS NULL) AND (X_s_license_num IS NULL)))
2571 AND ((tlinfo.s_license_state = x_s_license_state) OR ((tlinfo.s_license_state IS NULL) AND (X_s_license_state IS NULL)))
2572 AND ((tlinfo.s_depncy_status = x_s_depncy_status) OR ((tlinfo.s_depncy_status IS NULL) AND (X_s_depncy_status IS NULL)))
2573 AND ((tlinfo.s_default_status = x_s_default_status) OR ((tlinfo.s_default_status IS NULL) AND (X_s_default_status IS NULL)))
2574 AND ((tlinfo.s_citizenship_status = x_s_citizenship_status) OR ((tlinfo.s_citizenship_status IS NULL) AND (X_s_citizenship_status IS NULL)))
2575 AND ((tlinfo.s_alien_reg_num = x_s_alien_reg_num) OR ((tlinfo.s_alien_reg_num IS NULL) AND (X_s_alien_reg_num IS NULL)))
2576 AND ((tlinfo.s_foreign_postal_code = x_s_foreign_postal_code) OR ((tlinfo.s_foreign_postal_code IS NULL) AND (X_s_foreign_postal_code IS NULL)))
2580 AND ((tlinfo.award_id = x_award_id) OR ((tlinfo.award_id IS NULL) AND (X_award_id IS NULL)))
2577 AND ((tlinfo.pnote_batch_id = x_pnote_batch_id) OR ((tlinfo.pnote_batch_id IS NULL) AND (X_pnote_batch_id IS NULL)))
2578 AND ((tlinfo.pnote_ack_date = x_pnote_ack_date) OR ((tlinfo.pnote_ack_date IS NULL) AND (X_pnote_ack_date IS NULL)))
2579 AND ((tlinfo.pnote_mpn_ind = x_pnote_mpn_ind) OR ((tlinfo.pnote_mpn_ind IS NULL) AND (X_pnote_mpn_ind IS NULL)))
2581 AND ((tlinfo.base_id = x_base_id) OR ((tlinfo.base_id IS NULL) AND (X_base_id IS NULL)))
2582 AND ((tlinfo.document_id_txt = x_document_id_txt) OR ((tlinfo.document_id_txt IS NULL) AND (X_document_id_txt IS NULL)))
2583 AND ((tlinfo.loan_key_num = x_loan_key_num) OR ((tlinfo.loan_key_num IS NULL) AND (X_loan_key_num IS NULL)))
2584 AND ((tlinfo.interest_rebate_percent_num = x_interest_rebate_percent_num) OR ((tlinfo.interest_rebate_percent_num IS NULL) AND (X_interest_rebate_percent_num IS NULL)))
2585 AND ((tlinfo.fin_award_year = x_fin_award_year) OR ((tlinfo.fin_award_year IS NULL) AND (X_fin_award_year IS NULL)))
2586 AND ((tlinfo.cps_trans_num = x_cps_trans_num) OR ((tlinfo.cps_trans_num IS NULL) AND (X_cps_trans_num IS NULL)))
2587 AND ((tlinfo.atd_entity_id_txt = x_atd_entity_id_txt) OR ((tlinfo.atd_entity_id_txt IS NULL) AND (X_atd_entity_id_txt IS NULL)))
2588 AND ((tlinfo.rep_entity_id_txt = x_rep_entity_id_txt) OR ((tlinfo.rep_entity_id_txt IS NULL) AND (X_rep_entity_id_txt IS NULL)))
2589 AND ((tlinfo.source_entity_id_txt = x_source_entity_id_txt) OR ((tlinfo.source_entity_id_txt IS NULL) AND (X_source_entity_id_txt IS NULL)))
2590 AND ((tlinfo.pymt_servicer_amt = x_pymt_servicer_amt) OR ((tlinfo.pymt_servicer_amt IS NULL) AND (X_pymt_servicer_amt IS NULL)))
2591 AND ((tlinfo.pymt_servicer_date = x_pymt_servicer_date) OR ((tlinfo.pymt_servicer_date IS NULL) AND (X_pymt_servicer_date IS NULL)))
2592 AND ((tlinfo.book_loan_amt = x_book_loan_amt) OR ((tlinfo.book_loan_amt IS NULL) AND (X_book_loan_amt IS NULL)))
2593 AND ((tlinfo.book_loan_amt_date = x_book_loan_amt_date) OR ((tlinfo.book_loan_amt_date IS NULL) AND (X_book_loan_amt_date IS NULL)))
2594 AND ((tlinfo.s_chg_birth_date = x_s_chg_birth_date) OR ((tlinfo.s_chg_birth_date IS NULL) AND (X_s_chg_birth_date IS NULL)))
2595 AND ((tlinfo.s_chg_ssn = x_s_chg_ssn) OR ((tlinfo.s_chg_ssn IS NULL) AND (X_s_chg_ssn IS NULL)))
2596 AND ((tlinfo.s_chg_last_name = x_s_chg_last_name) OR ((tlinfo.s_chg_last_name IS NULL) AND (X_s_chg_last_name IS NULL)))
2597 AND ((tlinfo.b_chg_birth_date = x_b_chg_birth_date) OR ((tlinfo.b_chg_birth_date IS NULL) AND (X_b_chg_birth_date IS NULL)))
2598 AND ((tlinfo.b_chg_ssn = x_b_chg_ssn) OR ((tlinfo.b_chg_ssn IS NULL) AND (X_b_chg_ssn IS NULL)))
2599 AND ((tlinfo.b_chg_last_name = x_b_chg_last_name) OR ((tlinfo.b_chg_last_name IS NULL) AND (X_b_chg_last_name IS NULL)))
2600 AND ((tlinfo.note_message = x_note_message) OR ((tlinfo.note_message IS NULL) AND (X_note_message IS NULL)))
2601 AND ((tlinfo.full_resp_code = x_full_resp_code) OR ((tlinfo.full_resp_code IS NULL) AND (X_full_resp_code IS NULL)))
2602 AND ((tlinfo.s_permt_county = x_s_permt_county) OR ((tlinfo.s_permt_county IS NULL) AND (X_s_permt_county IS NULL)))
2603 AND ((tlinfo.b_permt_county = x_b_permt_county) OR ((tlinfo.b_permt_county IS NULL) AND (X_b_permt_county IS NULL)))
2604 AND ((tlinfo.s_permt_country = x_s_permt_country) OR ((tlinfo.s_permt_country IS NULL) AND (X_s_permt_country IS NULL)))
2605 AND ((tlinfo.b_permt_country = x_b_permt_country) OR ((tlinfo.b_permt_country IS NULL) AND (X_b_permt_country IS NULL)))
2606 AND ((tlinfo.crdt_decision_status = x_crdt_decision_status) OR ((tlinfo.crdt_decision_status IS NULL) AND (X_crdt_decision_status IS NULL)))
2607 AND ((tlinfo.external_loan_id_txt = x_external_loan_id_txt) OR ((tlinfo.external_loan_id_txt IS NULL) AND (X_external_loan_id_txt IS NULL)))
2608 AND ((tlinfo.deferment_request_code = x_deferment_request_code) OR ((tlinfo.deferment_request_code IS NULL) AND (X_deferment_request_code IS NULL)))
2609 AND ((tlinfo.eft_authorization_code = x_eft_authorization_code) OR ((tlinfo.eft_authorization_code IS NULL) AND (X_eft_authorization_code IS NULL)))
2610 AND ((tlinfo.requested_loan_amt = x_requested_loan_amt) OR ((tlinfo.requested_loan_amt IS NULL) AND (X_requested_loan_amt IS NULL)))
2611 AND ((tlinfo.actual_record_type_code = x_actual_record_type_code) OR ((tlinfo.actual_record_type_code IS NULL) AND (X_actual_record_type_code IS NULL)))
2612 AND ((tlinfo.reinstatement_amt = x_reinstatement_amt) OR ((tlinfo.reinstatement_amt IS NULL) AND (X_reinstatement_amt IS NULL)))
2613 AND ((tlinfo.lender_use_txt = x_lender_use_txt) OR ((tlinfo.lender_use_txt IS NULL) AND (X_lender_use_txt IS NULL)))
2614 AND ((tlinfo.guarantor_use_txt = x_guarantor_use_txt) OR ((tlinfo.guarantor_use_txt IS NULL) AND (X_guarantor_use_txt IS NULL)))
2615 AND ((tlinfo.fls_approved_amt = x_fls_approved_amt) OR ((tlinfo.fls_approved_amt IS NULL) AND (X_fls_approved_amt IS NULL)))
2616 AND ((tlinfo.flu_approved_amt = x_flu_approved_amt) OR ((tlinfo.flu_approved_amt IS NULL) AND (X_flu_approved_amt IS NULL)))
2617 AND ((tlinfo.flp_approved_amt = x_flp_approved_amt) OR ((tlinfo.flp_approved_amt IS NULL) AND (X_flp_approved_amt IS NULL)))
2618 AND ((tlinfo.alt_approved_amt = x_alt_approved_amt) OR ((tlinfo.alt_approved_amt IS NULL) AND (X_alt_approved_amt IS NULL)))
2619 AND ((tlinfo.alt_borrower_ind_flag = x_alt_borrower_ind_flag) OR ((tlinfo.alt_borrower_ind_flag IS NULL) AND (X_alt_borrower_ind_flag IS NULL)))
2620 AND ((tlinfo.loan_app_form_code = x_loan_app_form_code) OR ((tlinfo.loan_app_form_code IS NULL) AND (X_loan_app_form_code IS NULL)))
2621 AND ((tlinfo.school_id_txt = x_school_id_txt) OR ((tlinfo.school_id_txt IS NULL) AND (X_school_id_txt IS NULL)))
2622 AND ((tlinfo.cost_of_attendance_amt = x_cost_of_attendance_amt) OR ((tlinfo.cost_of_attendance_amt IS NULL) AND (X_cost_of_attendance_amt IS NULL)))
2626 AND ((tlinfo.school_use_txt = x_school_use_txt) OR ((tlinfo.school_use_txt IS NULL) AND (X_school_use_txt IS NULL)))
2623 AND ((tlinfo.established_fin_aid_amount = x_established_fin_aid_amount) OR ((tlinfo.established_fin_aid_amount IS NULL) AND (X_established_fin_aid_amount IS NULL)))
2624 AND ((tlinfo.student_electronic_sign_flag = x_student_electronic_sign_flag) OR ((tlinfo.student_electronic_sign_flag IS NULL) AND (X_student_electronic_sign_flag IS NULL)))
2625 AND ((tlinfo.mpn_type_flag = x_mpn_type_flag) OR ((tlinfo.mpn_type_flag IS NULL) AND (X_mpn_type_flag IS NULL)))
2627 AND ((tlinfo.expect_family_contribute_amt = x_expect_family_contribute_amt) OR ((tlinfo.expect_family_contribute_amt IS NULL) AND (X_expect_family_contribute_amt IS NULL)))
2628 AND ((tlinfo.borower_electronic_sign_flag = x_borower_electronic_sign_flag) OR ((tlinfo.borower_electronic_sign_flag IS NULL) AND (X_borower_electronic_sign_flag IS NULL)))
2629 AND ((tlinfo.borower_credit_authoriz_flag = x_borower_credit_authoriz_flag) OR ((tlinfo.borower_credit_authoriz_flag IS NULL) AND (X_borower_credit_authoriz_flag IS NULL)))
2630 AND ((tlinfo.esign_src_typ_cd = x_esign_src_typ_cd) OR ((tlinfo.esign_src_typ_cd IS NULL) AND (X_esign_src_typ_cd IS NULL)))
2631 ) THEN
2632 NULL;
2633 ELSE
2634 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2635 igs_ge_msg_stack.add;
2636 app_exception.raise_exception;
2637 END IF;
2638
2639 RETURN;
2640
2641 END lock_row;
2642
2643
2644 PROCEDURE update_row (
2645 x_rowid IN VARCHAR2,
2646 x_loan_id IN NUMBER,
2647 x_origination_id IN NUMBER,
2648 x_loan_number IN VARCHAR2,
2649 x_loan_type IN VARCHAR2,
2650 x_loan_amt_offered IN NUMBER,
2651 x_loan_amt_accepted IN NUMBER,
2652 x_loan_per_begin_date IN DATE,
2653 x_loan_per_end_date IN DATE,
2654 x_acad_yr_begin_date IN DATE,
2655 x_acad_yr_end_date IN DATE,
2656 x_loan_status IN VARCHAR2,
2657 x_loan_status_date IN DATE,
2658 x_loan_chg_status IN VARCHAR2,
2659 x_loan_chg_status_date IN DATE,
2660 x_req_serial_loan_code IN VARCHAR2,
2661 x_act_serial_loan_code IN VARCHAR2,
2662 x_active IN VARCHAR2,
2663 x_active_date IN DATE,
2664 x_sch_cert_date IN DATE,
2665 x_orig_status_flag IN VARCHAR2,
2666 x_orig_batch_id IN VARCHAR2,
2667 x_orig_batch_date IN DATE,
2668 x_chg_batch_id IN VARCHAR2,
2669 x_orig_ack_date IN DATE,
2670 x_credit_override IN VARCHAR2,
2671 x_credit_decision_date IN DATE,
2672 x_pnote_delivery_code IN VARCHAR2,
2673 x_pnote_status IN VARCHAR2,
2674 x_pnote_status_date IN DATE,
2675 x_pnote_id IN VARCHAR2,
2676 x_pnote_print_ind IN VARCHAR2,
2677 x_pnote_accept_amt IN NUMBER,
2678 x_pnote_accept_date IN DATE,
2679 x_p_signature_code IN VARCHAR2,
2680 x_p_signature_date IN DATE,
2681 x_s_signature_code IN VARCHAR2,
2682 x_unsub_elig_for_heal IN VARCHAR2,
2683 x_disclosure_print_ind IN VARCHAR2,
2684 x_orig_fee_perct IN NUMBER,
2685 x_borw_confirm_ind IN VARCHAR2,
2686 x_borw_interest_ind IN VARCHAR2,
2687 x_unsub_elig_for_depnt IN VARCHAR2,
2688 x_guarantee_amt IN NUMBER,
2689 x_guarantee_date IN DATE,
2690 x_guarnt_adj_ind IN VARCHAR2,
2691 x_guarnt_amt_redn_code IN VARCHAR2,
2692 x_guarnt_status_code IN VARCHAR2,
2693 x_guarnt_status_date IN DATE,
2694 x_lend_apprv_denied_code IN VARCHAR2,
2695 x_lend_apprv_denied_date IN DATE,
2696 x_lend_status_code IN VARCHAR2,
2697 x_lend_status_date IN DATE,
2698 x_grade_level_code IN VARCHAR2,
2699 x_enrollment_code IN VARCHAR2,
2700 x_anticip_compl_date IN DATE,
2701 x_borw_lender_id IN VARCHAR2,
2702 x_duns_borw_lender_id IN VARCHAR2,
2703 x_guarantor_id IN VARCHAR2,
2704 x_duns_guarnt_id IN VARCHAR2,
2705 x_prc_type_code IN VARCHAR2,
2706 x_rec_type_ind IN VARCHAR2,
2707 x_cl_loan_type IN VARCHAR2,
2708 x_cl_seq_number IN NUMBER,
2709 x_last_resort_lender IN VARCHAR2,
2710 x_lender_id IN VARCHAR2,
2711 x_duns_lender_id IN VARCHAR2,
2712 x_lend_non_ed_brc_id IN VARCHAR2,
2713 x_recipient_id IN VARCHAR2,
2714 x_recipient_type IN VARCHAR2,
2715 x_duns_recip_id IN VARCHAR2,
2719 x_alt_prog_type_code IN VARCHAR2,
2716 x_recip_non_ed_brc_id IN VARCHAR2,
2717 x_cl_rec_status IN VARCHAR2,
2718 x_cl_rec_status_last_update IN DATE,
2720 x_alt_appl_ver_code IN NUMBER,
2721 x_borw_outstd_loan_code IN VARCHAR2,
2722 x_mpn_confirm_code IN VARCHAR2,
2723 x_resp_to_orig_code IN VARCHAR2,
2724 x_appl_loan_phase_code IN VARCHAR2,
2725 x_appl_loan_phase_code_chg IN DATE,
2726 x_tot_outstd_stafford IN NUMBER,
2727 x_tot_outstd_plus IN NUMBER,
2728 x_alt_borw_tot_debt IN NUMBER,
2729 x_act_interest_rate IN NUMBER,
2730 x_service_type_code IN VARCHAR2,
2731 x_rev_notice_of_guarnt IN VARCHAR2,
2732 x_sch_refund_amt IN NUMBER,
2733 x_sch_refund_date IN DATE,
2734 x_uniq_layout_vend_code IN VARCHAR2,
2735 x_uniq_layout_ident_code IN VARCHAR2,
2736 x_p_person_id IN NUMBER,
2737 x_p_ssn IN VARCHAR2,
2738 x_p_ssn_chg_date IN DATE,
2739 x_p_last_name IN VARCHAR2,
2740 x_p_first_name IN VARCHAR2,
2741 x_p_middle_name IN VARCHAR2,
2742 x_p_permt_addr1 IN VARCHAR2,
2743 x_p_permt_addr2 IN VARCHAR2,
2744 x_p_permt_city IN VARCHAR2,
2745 x_p_permt_state IN VARCHAR2,
2746 x_p_permt_zip IN VARCHAR2,
2747 x_p_permt_addr_chg_date IN DATE,
2748 x_p_permt_phone IN VARCHAR2,
2749 x_p_email_addr IN VARCHAR2,
2750 x_p_date_of_birth IN DATE,
2751 x_p_dob_chg_date IN DATE,
2752 x_p_license_num IN VARCHAR2,
2753 x_p_license_state IN VARCHAR2,
2754 x_p_citizenship_status IN VARCHAR2,
2755 x_p_alien_reg_num IN VARCHAR2,
2756 x_p_default_status IN VARCHAR2,
2757 x_p_foreign_postal_code IN VARCHAR2,
2758 x_p_state_of_legal_res IN VARCHAR2,
2759 x_p_legal_res_date IN DATE,
2760 x_s_ssn IN VARCHAR2,
2761 x_s_ssn_chg_date IN DATE,
2762 x_s_last_name IN VARCHAR2,
2763 x_s_first_name IN VARCHAR2,
2764 x_s_middle_name IN VARCHAR2,
2765 x_s_permt_addr1 IN VARCHAR2,
2766 x_s_permt_addr2 IN VARCHAR2,
2767 x_s_permt_city IN VARCHAR2,
2768 x_s_permt_state IN VARCHAR2,
2769 x_s_permt_zip IN VARCHAR2,
2770 x_s_permt_addr_chg_date IN DATE,
2771 x_s_permt_phone IN VARCHAR2,
2772 x_s_local_addr1 IN VARCHAR2,
2773 x_s_local_addr2 IN VARCHAR2,
2774 x_s_local_city IN VARCHAR2,
2775 x_s_local_state IN VARCHAR2,
2776 x_s_local_zip IN VARCHAR2,
2777 x_s_local_addr_chg_date IN DATE,
2778 x_s_email_addr IN VARCHAR2,
2779 x_s_date_of_birth IN DATE,
2780 x_s_dob_chg_date IN DATE,
2781 x_s_license_num IN VARCHAR2,
2782 x_s_license_state IN VARCHAR2,
2783 x_s_depncy_status IN VARCHAR2,
2784 x_s_default_status IN VARCHAR2,
2785 x_s_citizenship_status IN VARCHAR2,
2786 x_s_alien_reg_num IN VARCHAR2,
2787 x_s_foreign_postal_code IN VARCHAR2,
2788 x_mode IN VARCHAR2 DEFAULT 'R',
2789 x_pnote_batch_id IN VARCHAR2,
2790 x_pnote_ack_date IN DATE,
2791 x_pnote_mpn_ind IN VARCHAR2,
2792 x_award_id IN NUMBER,
2793 x_base_id IN NUMBER,
2794 x_document_id_txt IN VARCHAR2,
2795 x_loan_key_num IN NUMBER,
2796 x_interest_rebate_percent_num IN NUMBER,
2797 x_fin_award_year IN VARCHAR2,
2798 x_cps_trans_num IN NUMBER,
2799 x_atd_entity_id_txt IN VARCHAR2,
2800 x_rep_entity_id_txt IN VARCHAR2,
2801 x_source_entity_id_txt IN VARCHAR2,
2802 x_pymt_servicer_amt IN NUMBER,
2803 x_pymt_servicer_date IN DATE,
2804 x_book_loan_amt IN NUMBER,
2805 x_book_loan_amt_date IN DATE,
2806 x_s_chg_birth_date IN DATE,
2807 x_s_chg_ssn IN VARCHAR2,
2808 x_s_chg_last_name IN VARCHAR2,
2809 x_b_chg_birth_date IN DATE,
2810 x_b_chg_ssn IN VARCHAR2,
2811 x_b_chg_last_name IN VARCHAR2,
2815 x_b_permt_county IN VARCHAR2,
2812 x_note_message IN VARCHAR2,
2813 x_full_resp_code IN VARCHAR2,
2814 x_s_permt_county IN VARCHAR2,
2816 x_s_permt_country IN VARCHAR2,
2817 x_b_permt_country IN VARCHAR2,
2818 x_crdt_decision_status IN VARCHAR2,
2819 x_external_loan_id_txt IN VARCHAR2,
2820 x_deferment_request_code IN VARCHAR2,
2821 x_eft_authorization_code IN VARCHAR2,
2822 x_requested_loan_amt IN NUMBER ,
2823 x_actual_record_type_code IN VARCHAR2,
2824 x_reinstatement_amt IN NUMBER ,
2825 x_lender_use_txt IN VARCHAR2,
2826 x_guarantor_use_txt IN VARCHAR2,
2827 x_fls_approved_amt IN NUMBER ,
2828 x_flu_approved_amt IN NUMBER ,
2829 x_flp_approved_amt IN NUMBER ,
2830 x_alt_approved_amt IN NUMBER ,
2831 x_loan_app_form_code IN VARCHAR2,
2832 x_alt_borrower_ind_flag IN VARCHAR2,
2833 x_school_id_txt IN VARCHAR2,
2834 x_cost_of_attendance_amt IN NUMBER ,
2835 x_established_fin_aid_amount IN NUMBER ,
2836 x_student_electronic_sign_flag IN VARCHAR2,
2837 x_mpn_type_flag IN VARCHAR2,
2838 x_school_use_txt IN VARCHAR2,
2839 x_expect_family_contribute_amt IN NUMBER ,
2840 x_borower_electronic_sign_flag IN VARCHAR2,
2841 x_borower_credit_authoriz_flag IN VARCHAR2,
2842 x_esign_src_typ_cd IN VARCHAR2
2843 ) AS
2844 /*
2845 || Created By : venagara
2846 || Created On : 22-JAN-2001
2847 || Purpose : Handles the UPDATE DML logic for the table.
2848 || Known limitations, enhancements or remarks :
2849 || Change History :
2850 || Who When What
2851 || (reverse chronological order - newest change first)
2852 */
2853 x_last_update_date DATE ;
2854 x_last_updated_by NUMBER;
2855 x_last_update_login NUMBER;
2856 x_request_id NUMBER;
2857 x_program_id NUMBER;
2858 x_program_application_id NUMBER;
2859 x_program_update_date DATE;
2860
2861 BEGIN
2862
2863 x_last_update_date := SYSDATE;
2864 IF (X_MODE = 'I') THEN
2865 x_last_updated_by := 1;
2866 x_last_update_login := 0;
2867 ELSIF (x_mode = 'R') THEN
2868 x_last_updated_by := fnd_global.user_id;
2869 IF x_last_updated_by IS NULL THEN
2870 x_last_updated_by := -1;
2871 END IF;
2872 x_last_update_login := fnd_global.login_id;
2873 IF (x_last_update_login IS NULL) THEN
2874 x_last_update_login := -1;
2875 END IF;
2876 ELSE
2877 fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
2878 igs_ge_msg_stack.add;
2879 app_exception.raise_exception;
2880 END IF;
2881
2882 before_dml(
2883 p_action => 'UPDATE',
2884 x_rowid => x_rowid,
2885 x_loan_id => x_loan_id,
2886 x_origination_id => x_origination_id,
2887 x_loan_number => x_loan_number,
2888 x_loan_type => x_loan_type,
2889 x_loan_amt_offered => x_loan_amt_offered,
2890 x_loan_amt_accepted => x_loan_amt_accepted,
2891 x_loan_per_begin_date => x_loan_per_begin_date,
2892 x_loan_per_end_date => x_loan_per_end_date,
2893 x_acad_yr_begin_date => x_acad_yr_begin_date,
2894 x_acad_yr_end_date => x_acad_yr_end_date,
2895 x_loan_status => x_loan_status,
2896 x_loan_status_date => x_loan_status_date,
2897 x_loan_chg_status => x_loan_chg_status,
2898 x_loan_chg_status_date => x_loan_chg_status_date,
2899 x_req_serial_loan_code => x_req_serial_loan_code,
2900 x_act_serial_loan_code => x_act_serial_loan_code,
2901 x_active => x_active,
2902 x_active_date => x_active_date,
2903 x_sch_cert_date => x_sch_cert_date,
2904 x_orig_status_flag => x_orig_status_flag,
2905 x_orig_batch_id => x_orig_batch_id,
2906 x_orig_batch_date => x_orig_batch_date,
2907 x_chg_batch_id => x_chg_batch_id,
2908 x_orig_ack_date => x_orig_ack_date,
2909 x_credit_override => x_credit_override,
2910 x_credit_decision_date => x_credit_decision_date,
2911 x_pnote_delivery_code => x_pnote_delivery_code,
2912 x_pnote_status => x_pnote_status,
2913 x_pnote_status_date => x_pnote_status_date,
2914 x_pnote_id => x_pnote_id,
2915 x_pnote_print_ind => x_pnote_print_ind,
2916 x_pnote_accept_amt => x_pnote_accept_amt,
2917 x_pnote_accept_date => x_pnote_accept_date,
2918 x_p_signature_code => x_p_signature_code,
2919 x_p_signature_date => x_p_signature_date,
2920 x_s_signature_code => x_s_signature_code,
2921 x_unsub_elig_for_heal => x_unsub_elig_for_heal,
2922 x_disclosure_print_ind => x_disclosure_print_ind,
2923 x_orig_fee_perct => x_orig_fee_perct,
2924 x_borw_confirm_ind => x_borw_confirm_ind,
2925 x_borw_interest_ind => x_borw_interest_ind,
2926 x_unsub_elig_for_depnt => x_unsub_elig_for_depnt,
2927 x_guarantee_amt => x_guarantee_amt,
2928 x_guarantee_date => x_guarantee_date,
2929 x_guarnt_adj_ind => x_guarnt_adj_ind,
2930 x_guarnt_amt_redn_code => x_guarnt_amt_redn_code,
2931 x_guarnt_status_code => x_guarnt_status_code,
2932 x_guarnt_status_date => x_guarnt_status_date,
2936 x_lend_status_date => x_lend_status_date,
2933 x_lend_apprv_denied_code => x_lend_apprv_denied_code,
2934 x_lend_apprv_denied_date => x_lend_apprv_denied_date,
2935 x_lend_status_code => x_lend_status_code,
2937 x_grade_level_code => x_grade_level_code,
2938 x_enrollment_code => x_enrollment_code,
2939 x_anticip_compl_date => x_anticip_compl_date,
2940 x_borw_lender_id => x_borw_lender_id,
2941 x_duns_borw_lender_id => x_duns_borw_lender_id,
2942 x_guarantor_id => x_guarantor_id,
2943 x_duns_guarnt_id => x_duns_guarnt_id,
2944 x_prc_type_code => x_prc_type_code,
2945 x_rec_type_ind => x_rec_type_ind,
2946 x_cl_loan_type => x_cl_loan_type,
2947 x_cl_seq_number => x_cl_seq_number,
2948 x_last_resort_lender => x_last_resort_lender,
2949 x_lender_id => x_lender_id,
2950 x_duns_lender_id => x_duns_lender_id,
2951 x_lend_non_ed_brc_id => x_lend_non_ed_brc_id,
2952 x_recipient_id => x_recipient_id,
2953 x_recipient_type => x_recipient_type,
2954 x_duns_recip_id => x_duns_recip_id,
2955 x_recip_non_ed_brc_id => x_recip_non_ed_brc_id,
2956 x_cl_rec_status => x_cl_rec_status,
2957 x_cl_rec_status_last_update => x_cl_rec_status_last_update,
2958 x_alt_prog_type_code => x_alt_prog_type_code,
2959 x_alt_appl_ver_code => x_alt_appl_ver_code,
2960 x_borw_outstd_loan_code => x_borw_outstd_loan_code,
2961 x_mpn_confirm_code => x_mpn_confirm_code,
2962 x_resp_to_orig_code => x_resp_to_orig_code,
2963 x_appl_loan_phase_code => x_appl_loan_phase_code,
2964 x_appl_loan_phase_code_chg => x_appl_loan_phase_code_chg,
2965 x_tot_outstd_stafford => x_tot_outstd_stafford,
2966 x_tot_outstd_plus => x_tot_outstd_plus,
2967 x_alt_borw_tot_debt => x_alt_borw_tot_debt,
2968 x_act_interest_rate => x_act_interest_rate,
2969 x_service_type_code => x_service_type_code,
2970 x_rev_notice_of_guarnt => x_rev_notice_of_guarnt,
2971 x_sch_refund_amt => x_sch_refund_amt,
2972 x_sch_refund_date => x_sch_refund_date,
2973 x_uniq_layout_vend_code => x_uniq_layout_vend_code,
2974 x_uniq_layout_ident_code => x_uniq_layout_ident_code,
2975 x_p_person_id => x_p_person_id,
2976 x_p_ssn => x_p_ssn,
2977 x_p_ssn_chg_date => x_p_ssn_chg_date,
2978 x_p_last_name => x_p_last_name,
2979 x_p_first_name => x_p_first_name,
2980 x_p_middle_name => x_p_middle_name,
2981 x_p_permt_addr1 => x_p_permt_addr1,
2982 x_p_permt_addr2 => x_p_permt_addr2,
2983 x_p_permt_city => x_p_permt_city,
2984 x_p_permt_state => x_p_permt_state,
2985 x_p_permt_zip => x_p_permt_zip,
2986 x_p_permt_addr_chg_date => x_p_permt_addr_chg_date,
2987 x_p_permt_phone => x_p_permt_phone,
2988 x_p_email_addr => x_p_email_addr,
2989 x_p_date_of_birth => x_p_date_of_birth,
2990 x_p_dob_chg_date => x_p_dob_chg_date,
2991 x_p_license_num => x_p_license_num,
2992 x_p_license_state => x_p_license_state,
2993 x_p_citizenship_status => x_p_citizenship_status,
2994 x_p_alien_reg_num => x_p_alien_reg_num,
2995 x_p_default_status => x_p_default_status,
2996 x_p_foreign_postal_code => x_p_foreign_postal_code,
2997 x_p_state_of_legal_res => x_p_state_of_legal_res,
2998 x_p_legal_res_date => x_p_legal_res_date,
2999 x_s_ssn => x_s_ssn,
3000 x_s_ssn_chg_date => x_s_ssn_chg_date,
3001 x_s_last_name => x_s_last_name,
3002 x_s_first_name => x_s_first_name,
3003 x_s_middle_name => x_s_middle_name,
3004 x_s_permt_addr1 => x_s_permt_addr1,
3005 x_s_permt_addr2 => x_s_permt_addr2,
3006 x_s_permt_city => x_s_permt_city,
3007 x_s_permt_state => x_s_permt_state,
3008 x_s_permt_zip => x_s_permt_zip,
3009 x_s_permt_addr_chg_date => x_s_permt_addr_chg_date,
3010 x_s_permt_phone => x_s_permt_phone,
3011 x_s_local_addr1 => x_s_local_addr1,
3012 x_s_local_addr2 => x_s_local_addr2,
3013 x_s_local_city => x_s_local_city,
3014 x_s_local_state => x_s_local_state,
3015 x_s_local_zip => x_s_local_zip,
3016 x_s_local_addr_chg_date => x_s_local_addr_chg_date,
3017 x_s_email_addr => x_s_email_addr,
3018 x_s_date_of_birth => x_s_date_of_birth,
3019 x_s_dob_chg_date => x_s_dob_chg_date,
3020 x_s_license_num => x_s_license_num,
3021 x_s_license_state => x_s_license_state,
3022 x_s_depncy_status => x_s_depncy_status,
3023 x_s_default_status => x_s_default_status,
3027 x_creation_date => x_last_update_date,
3024 x_s_citizenship_status => x_s_citizenship_status,
3025 x_s_alien_reg_num => x_s_alien_reg_num,
3026 x_s_foreign_postal_code => x_s_foreign_postal_code,
3028 x_created_by => x_last_updated_by,
3029 x_last_update_date => x_last_update_date,
3030 x_last_updated_by => x_last_updated_by,
3031 x_last_update_login => x_last_update_login,
3032 x_pnote_batch_id => x_pnote_batch_id,
3033 x_pnote_ack_date => x_pnote_ack_date,
3034 x_pnote_mpn_ind => x_pnote_mpn_ind,
3035 x_award_id => x_award_id,
3036 x_base_id => x_base_id,
3037 x_document_id_txt => x_document_id_txt,
3038 x_loan_key_num => x_loan_key_num,
3039 x_interest_rebate_percent_num => x_interest_rebate_percent_num,
3040 x_fin_award_year => x_fin_award_year,
3041 x_cps_trans_num => x_cps_trans_num,
3042 x_atd_entity_id_txt => x_atd_entity_id_txt,
3043 x_rep_entity_id_txt => x_rep_entity_id_txt,
3044 x_source_entity_id_txt => x_source_entity_id_txt,
3045 x_pymt_servicer_amt => x_pymt_servicer_amt,
3046 x_pymt_servicer_date => x_pymt_servicer_date,
3047 x_book_loan_amt => x_book_loan_amt,
3048 x_book_loan_amt_date => x_book_loan_amt_date,
3049 x_s_chg_birth_date => x_s_chg_birth_date,
3050 x_s_chg_ssn => x_s_chg_ssn,
3051 x_s_chg_last_name => x_s_chg_last_name,
3052 x_b_chg_birth_date => x_b_chg_birth_date,
3053 x_b_chg_ssn => x_b_chg_ssn,
3054 x_b_chg_last_name => x_b_chg_last_name,
3055 x_note_message => x_note_message,
3056 x_full_resp_code => x_full_resp_code,
3057 x_s_permt_county => x_s_permt_county,
3058 x_b_permt_county => x_b_permt_county,
3059 x_s_permt_country => x_s_permt_country,
3060 x_b_permt_country => x_b_permt_country,
3061 x_crdt_decision_status => x_crdt_decision_status,
3062 x_external_loan_id_txt => x_external_loan_id_txt ,
3063 x_deferment_request_code => x_deferment_request_code ,
3064 x_eft_authorization_code => x_eft_authorization_code ,
3065 x_requested_loan_amt => x_requested_loan_amt ,
3066 x_actual_record_type_code => x_actual_record_type_code ,
3067 x_reinstatement_amt => x_reinstatement_amt ,
3068 x_lender_use_txt => x_lender_use_txt ,
3069 x_guarantor_use_txt => x_guarantor_use_txt ,
3070 x_fls_approved_amt => x_fls_approved_amt ,
3071 x_flu_approved_amt => x_flu_approved_amt ,
3072 x_flp_approved_amt => x_flp_approved_amt ,
3073 x_alt_approved_amt => x_alt_approved_amt ,
3074 x_loan_app_form_code => x_loan_app_form_code ,
3075 x_alt_borrower_ind_flag => x_alt_borrower_ind_flag ,
3076 x_school_id_txt => x_school_id_txt ,
3077 x_cost_of_attendance_amt => x_cost_of_attendance_amt ,
3078 x_established_fin_aid_amount => x_established_fin_aid_amount ,
3079 x_student_electronic_sign_flag => x_student_electronic_sign_flag ,
3080 x_mpn_type_flag => x_mpn_type_flag ,
3081 x_school_use_txt => x_school_use_txt ,
3082 x_expect_family_contribute_amt => x_expect_family_contribute_amt ,
3083 x_borower_electronic_sign_flag => x_borower_electronic_sign_flag ,
3084 x_borower_credit_authoriz_flag => x_borower_credit_authoriz_flag ,
3085 x_esign_src_typ_cd => x_esign_src_typ_cd
3086 );
3087
3088 IF (x_mode = 'R') THEN
3089 x_request_id := fnd_global.conc_request_id;
3090 x_program_id := fnd_global.conc_program_id;
3091 x_program_application_id := fnd_global.prog_appl_id;
3092 IF (x_request_id = -1) THEN
3093 x_request_id := old_references.request_id;
3094 x_program_id := old_references.program_id;
3095 x_program_application_id := old_references.program_application_id;
3096 x_program_update_date := old_references.program_update_date;
3097 ELSE
3098 x_program_update_date := SYSDATE;
3099 END IF;
3100 END IF;
3101
3102 UPDATE igf_sl_lor_loc_all
3103 SET
3104 origination_id = new_references.origination_id,
3105 loan_number = new_references.loan_number,
3106 loan_type = new_references.loan_type,
3107 loan_amt_offered = new_references.loan_amt_offered,
3108 loan_amt_accepted = new_references.loan_amt_accepted,
3109 loan_per_begin_date = new_references.loan_per_begin_date,
3110 loan_per_end_date = new_references.loan_per_end_date,
3111 acad_yr_begin_date = new_references.acad_yr_begin_date,
3115 loan_chg_status = new_references.loan_chg_status,
3112 acad_yr_end_date = new_references.acad_yr_end_date,
3113 loan_status = new_references.loan_status,
3114 loan_status_date = new_references.loan_status_date,
3116 loan_chg_status_date = new_references.loan_chg_status_date,
3117 req_serial_loan_code = new_references.req_serial_loan_code,
3118 act_serial_loan_code = new_references.act_serial_loan_code,
3119 active = new_references.active,
3120 active_date = new_references.active_date,
3121 sch_cert_date = new_references.sch_cert_date,
3122 orig_status_flag = new_references.orig_status_flag,
3123 orig_batch_id = new_references.orig_batch_id,
3124 orig_batch_date = new_references.orig_batch_date,
3125 chg_batch_id = new_references.chg_batch_id,
3126 orig_ack_date = new_references.orig_ack_date,
3127 credit_override = new_references.credit_override,
3128 credit_decision_date = new_references.credit_decision_date,
3129 pnote_delivery_code = new_references.pnote_delivery_code,
3130 pnote_status = new_references.pnote_status,
3131 pnote_status_date = new_references.pnote_status_date,
3132 pnote_id = new_references.pnote_id,
3133 pnote_print_ind = new_references.pnote_print_ind,
3134 pnote_accept_amt = new_references.pnote_accept_amt,
3135 pnote_accept_date = new_references.pnote_accept_date,
3136 p_signature_code = new_references.p_signature_code,
3137 p_signature_date = new_references.p_signature_date,
3138 s_signature_code = new_references.s_signature_code,
3139 unsub_elig_for_heal = new_references.unsub_elig_for_heal,
3140 disclosure_print_ind = new_references.disclosure_print_ind,
3141 orig_fee_perct = new_references.orig_fee_perct,
3142 borw_confirm_ind = new_references.borw_confirm_ind,
3143 borw_interest_ind = new_references.borw_interest_ind,
3144 unsub_elig_for_depnt = new_references.unsub_elig_for_depnt,
3145 guarantee_amt = new_references.guarantee_amt,
3146 guarantee_date = new_references.guarantee_date,
3147 guarnt_adj_ind = new_references.guarnt_adj_ind,
3148 guarnt_amt_redn_code = new_references.guarnt_amt_redn_code,
3149 guarnt_status_code = new_references.guarnt_status_code,
3150 guarnt_status_date = new_references.guarnt_status_date,
3151 lend_apprv_denied_code = new_references.lend_apprv_denied_code,
3152 lend_apprv_denied_date = new_references.lend_apprv_denied_date,
3153 lend_status_code = new_references.lend_status_code,
3154 lend_status_date = new_references.lend_status_date,
3155 grade_level_code = new_references.grade_level_code,
3156 enrollment_code = new_references.enrollment_code,
3157 anticip_compl_date = new_references.anticip_compl_date,
3158 borw_lender_id = new_references.borw_lender_id,
3159 guarantor_id = new_references.guarantor_id,
3160 prc_type_code = new_references.prc_type_code,
3161 rec_type_ind = new_references.rec_type_ind,
3162 cl_loan_type = new_references.cl_loan_type,
3163 cl_seq_number = new_references.cl_seq_number,
3164 last_resort_lender = new_references.last_resort_lender,
3165 lender_id = new_references.lender_id,
3166 lend_non_ed_brc_id = new_references.lend_non_ed_brc_id,
3167 recipient_id = new_references.recipient_id,
3168 recipient_type = new_references.recipient_type,
3169 recip_non_ed_brc_id = new_references.recip_non_ed_brc_id,
3170 cl_rec_status = new_references.cl_rec_status,
3171 cl_rec_status_last_update = new_references.cl_rec_status_last_update,
3172 alt_prog_type_code = new_references.alt_prog_type_code,
3173 alt_appl_ver_code = new_references.alt_appl_ver_code,
3174 borw_outstd_loan_code = new_references.borw_outstd_loan_code,
3175 mpn_confirm_code = new_references.mpn_confirm_code,
3176 resp_to_orig_code = new_references.resp_to_orig_code,
3177 appl_loan_phase_code = new_references.appl_loan_phase_code,
3178 appl_loan_phase_code_chg = new_references.appl_loan_phase_code_chg,
3179 tot_outstd_stafford = new_references.tot_outstd_stafford,
3180 tot_outstd_plus = new_references.tot_outstd_plus,
3181 alt_borw_tot_debt = new_references.alt_borw_tot_debt,
3182 act_interest_rate = new_references.act_interest_rate,
3183 service_type_code = new_references.service_type_code,
3184 rev_notice_of_guarnt = new_references.rev_notice_of_guarnt,
3185 sch_refund_amt = new_references.sch_refund_amt,
3186 sch_refund_date = new_references.sch_refund_date,
3187 uniq_layout_vend_code = new_references.uniq_layout_vend_code,
3188 uniq_layout_ident_code = new_references.uniq_layout_ident_code,
3189 p_person_id = new_references.p_person_id,
3193 p_first_name = new_references.p_first_name,
3190 p_ssn = new_references.p_ssn,
3191 p_ssn_chg_date = new_references.p_ssn_chg_date,
3192 p_last_name = new_references.p_last_name,
3194 p_middle_name = new_references.p_middle_name,
3195 p_permt_addr1 = new_references.p_permt_addr1,
3196 p_permt_addr2 = new_references.p_permt_addr2,
3197 p_permt_city = new_references.p_permt_city,
3198 p_permt_state = new_references.p_permt_state,
3199 p_permt_zip = new_references.p_permt_zip,
3200 p_permt_addr_chg_date = new_references.p_permt_addr_chg_date,
3201 p_permt_phone = new_references.p_permt_phone,
3202 p_email_addr = new_references.p_email_addr,
3203 p_date_of_birth = new_references.p_date_of_birth,
3204 p_dob_chg_date = new_references.p_dob_chg_date,
3205 p_license_num = new_references.p_license_num,
3206 p_license_state = new_references.p_license_state,
3207 p_citizenship_status = new_references.p_citizenship_status,
3208 p_alien_reg_num = new_references.p_alien_reg_num,
3209 p_default_status = new_references.p_default_status,
3210 p_foreign_postal_code = new_references.p_foreign_postal_code,
3211 p_state_of_legal_res = new_references.p_state_of_legal_res,
3212 p_legal_res_date = new_references.p_legal_res_date,
3213 s_ssn = new_references.s_ssn,
3214 s_ssn_chg_date = new_references.s_ssn_chg_date,
3215 s_last_name = new_references.s_last_name,
3216 s_first_name = new_references.s_first_name,
3217 s_middle_name = new_references.s_middle_name,
3218 s_permt_addr1 = new_references.s_permt_addr1,
3219 s_permt_addr2 = new_references.s_permt_addr2,
3220 s_permt_city = new_references.s_permt_city,
3221 s_permt_state = new_references.s_permt_state,
3222 s_permt_zip = new_references.s_permt_zip,
3223 s_permt_addr_chg_date = new_references.s_permt_addr_chg_date,
3224 s_permt_phone = new_references.s_permt_phone,
3225 s_local_addr1 = new_references.s_local_addr1,
3226 s_local_addr2 = new_references.s_local_addr2,
3227 s_local_city = new_references.s_local_city,
3228 s_local_state = new_references.s_local_state,
3229 s_local_zip = new_references.s_local_zip,
3230 s_local_addr_chg_date = new_references.s_local_addr_chg_date,
3231 s_email_addr = new_references.s_email_addr,
3232 s_date_of_birth = new_references.s_date_of_birth,
3233 s_dob_chg_date = new_references.s_dob_chg_date,
3234 s_license_num = new_references.s_license_num,
3235 s_license_state = new_references.s_license_state,
3236 s_depncy_status = new_references.s_depncy_status,
3237 s_default_status = new_references.s_default_status,
3238 s_citizenship_status = new_references.s_citizenship_status,
3239 s_alien_reg_num = new_references.s_alien_reg_num,
3240 s_foreign_postal_code = new_references.s_foreign_postal_code,
3241 last_update_date = x_last_update_date,
3242 last_updated_by = x_last_updated_by,
3243 last_update_login = x_last_update_login ,
3244 request_id = x_request_id,
3245 program_id = x_program_id,
3246 program_application_id = x_program_application_id,
3247 program_update_date = x_program_update_date,
3248 pnote_batch_id = x_pnote_batch_id,
3249 pnote_ack_date = x_pnote_ack_date,
3250 pnote_mpn_ind = x_pnote_mpn_ind,
3251 award_id = new_references.award_id,
3252 base_id = new_references.base_id,
3253 document_id_txt = new_references.document_id_txt,
3254 loan_key_num = new_references.loan_key_num,
3255 interest_rebate_percent_num = new_references.interest_rebate_percent_num,
3256 fin_award_year = new_references.fin_award_year,
3257 cps_trans_num = new_references.cps_trans_num,
3258 atd_entity_id_txt = new_references.atd_entity_id_txt,
3259 rep_entity_id_txt = new_references.rep_entity_id_txt,
3260 source_entity_id_txt = new_references.source_entity_id_txt,
3261 pymt_servicer_amt = new_references.pymt_servicer_amt,
3262 pymt_servicer_date = new_references.pymt_servicer_date,
3263 book_loan_amt = new_references.book_loan_amt,
3264 book_loan_amt_date = new_references.book_loan_amt_date,
3265 s_chg_birth_date = new_references.s_chg_birth_date,
3266 s_chg_ssn = new_references.s_chg_ssn,
3267 s_chg_last_name = new_references.s_chg_last_name,
3268 b_chg_birth_date = new_references.b_chg_birth_date,
3269 b_chg_ssn = new_references.b_chg_ssn,
3270 b_chg_last_name = new_references.b_chg_last_name,
3274 b_permt_county = new_references.b_permt_county,
3271 note_message = new_references.note_message,
3272 full_resp_code = new_references.full_resp_code,
3273 s_permt_county = new_references.s_permt_county,
3275 s_permt_country = new_references.s_permt_country,
3276 b_permt_country = new_references.b_permt_country,
3277 crdt_decision_status = new_references.crdt_decision_status,
3278 external_loan_id_txt = new_references.external_loan_id_txt ,
3279 deferment_request_code = new_references.deferment_request_code ,
3280 eft_authorization_code = new_references.eft_authorization_code ,
3281 requested_loan_amt = new_references.requested_loan_amt ,
3282 actual_record_type_code = new_references.actual_record_type_code ,
3283 reinstatement_amt = new_references.reinstatement_amt ,
3284 lender_use_txt = new_references.lender_use_txt ,
3285 guarantor_use_txt = new_references.guarantor_use_txt ,
3286 fls_approved_amt = new_references.fls_approved_amt ,
3287 flu_approved_amt = new_references.flu_approved_amt ,
3288 flp_approved_amt = new_references.flp_approved_amt ,
3289 alt_approved_amt = new_references.alt_approved_amt ,
3290 loan_app_form_code = new_references.loan_app_form_code ,
3291 alt_borrower_ind_flag = new_references.alt_borrower_ind_flag ,
3292 school_id_txt = new_references.school_id_txt ,
3293 cost_of_attendance_amt = new_references.cost_of_attendance_amt ,
3294 established_fin_aid_amount = new_references.established_fin_aid_amount ,
3295 student_electronic_sign_flag = new_references.student_electronic_sign_flag,
3296 mpn_type_flag = new_references.mpn_type_flag ,
3297 school_use_txt = new_references.school_use_txt ,
3298 expect_family_contribute_amt = new_references.expect_family_contribute_amt,
3299 borower_electronic_sign_flag = new_references.borower_electronic_sign_flag,
3300 borower_credit_authoriz_flag = new_references.borower_credit_authoriz_flag,
3301 esign_src_typ_cd = new_references.esign_src_typ_cd
3302
3303 WHERE rowid = x_rowid;
3304
3305 IF (SQL%NOTFOUND) THEN
3306 RAISE NO_DATA_FOUND;
3307 END IF;
3308 after_dml (p_action => 'UPDATE');
3309
3310 END update_row;
3311
3312
3313 PROCEDURE add_row (
3314 x_rowid IN OUT NOCOPY VARCHAR2,
3315 x_loan_id IN NUMBER,
3316 x_origination_id IN NUMBER,
3317 x_loan_number IN VARCHAR2,
3318 x_loan_type IN VARCHAR2,
3319 x_loan_amt_offered IN NUMBER,
3320 x_loan_amt_accepted IN NUMBER,
3321 x_loan_per_begin_date IN DATE,
3322 x_loan_per_end_date IN DATE,
3323 x_acad_yr_begin_date IN DATE,
3324 x_acad_yr_end_date IN DATE,
3325 x_loan_status IN VARCHAR2,
3326 x_loan_status_date IN DATE,
3327 x_loan_chg_status IN VARCHAR2,
3328 x_loan_chg_status_date IN DATE,
3329 x_req_serial_loan_code IN VARCHAR2,
3330 x_act_serial_loan_code IN VARCHAR2,
3331 x_active IN VARCHAR2,
3332 x_active_date IN DATE,
3333 x_sch_cert_date IN DATE,
3334 x_orig_status_flag IN VARCHAR2,
3335 x_orig_batch_id IN VARCHAR2,
3336 x_orig_batch_date IN DATE,
3337 x_chg_batch_id IN VARCHAR2,
3338 x_orig_ack_date IN DATE,
3339 x_credit_override IN VARCHAR2,
3340 x_credit_decision_date IN DATE,
3341 x_pnote_delivery_code IN VARCHAR2,
3342 x_pnote_status IN VARCHAR2,
3343 x_pnote_status_date IN DATE,
3344 x_pnote_id IN VARCHAR2,
3345 x_pnote_print_ind IN VARCHAR2,
3346 x_pnote_accept_amt IN NUMBER,
3347 x_pnote_accept_date IN DATE,
3348 x_p_signature_code IN VARCHAR2,
3349 x_p_signature_date IN DATE,
3350 x_s_signature_code IN VARCHAR2,
3351 x_unsub_elig_for_heal IN VARCHAR2,
3352 x_disclosure_print_ind IN VARCHAR2,
3353 x_orig_fee_perct IN NUMBER,
3354 x_borw_confirm_ind IN VARCHAR2,
3355 x_borw_interest_ind IN VARCHAR2,
3356 x_unsub_elig_for_depnt IN VARCHAR2,
3357 x_guarantee_amt IN NUMBER,
3358 x_guarantee_date IN DATE,
3359 x_guarnt_adj_ind IN VARCHAR2,
3360 x_guarnt_amt_redn_code IN VARCHAR2,
3361 x_guarnt_status_code IN VARCHAR2,
3362 x_guarnt_status_date IN DATE,
3363 x_lend_apprv_denied_code IN VARCHAR2,
3364 x_lend_apprv_denied_date IN DATE,
3365 x_lend_status_code IN VARCHAR2,
3366 x_lend_status_date IN DATE,
3370 x_borw_lender_id IN VARCHAR2,
3367 x_grade_level_code IN VARCHAR2,
3368 x_enrollment_code IN VARCHAR2,
3369 x_anticip_compl_date IN DATE,
3371 x_duns_borw_lender_id IN VARCHAR2,
3372 x_guarantor_id IN VARCHAR2,
3373 x_duns_guarnt_id IN VARCHAR2,
3374 x_prc_type_code IN VARCHAR2,
3375 x_rec_type_ind IN VARCHAR2,
3376 x_cl_loan_type IN VARCHAR2,
3377 x_cl_seq_number IN NUMBER,
3378 x_last_resort_lender IN VARCHAR2,
3379 x_lender_id IN VARCHAR2,
3380 x_duns_lender_id IN VARCHAR2,
3381 x_lend_non_ed_brc_id IN VARCHAR2,
3382 x_recipient_id IN VARCHAR2,
3383 x_recipient_type IN VARCHAR2,
3384 x_duns_recip_id IN VARCHAR2,
3385 x_recip_non_ed_brc_id IN VARCHAR2,
3386 x_cl_rec_status IN VARCHAR2,
3387 x_cl_rec_status_last_update IN DATE,
3388 x_alt_prog_type_code IN VARCHAR2,
3389 x_alt_appl_ver_code IN NUMBER,
3390 x_borw_outstd_loan_code IN VARCHAR2,
3391 x_mpn_confirm_code IN VARCHAR2,
3392 x_resp_to_orig_code IN VARCHAR2,
3393 x_appl_loan_phase_code IN VARCHAR2,
3394 x_appl_loan_phase_code_chg IN DATE,
3395 x_tot_outstd_stafford IN NUMBER,
3396 x_tot_outstd_plus IN NUMBER,
3397 x_alt_borw_tot_debt IN NUMBER,
3398 x_act_interest_rate IN NUMBER,
3399 x_service_type_code IN VARCHAR2,
3400 x_rev_notice_of_guarnt IN VARCHAR2,
3401 x_sch_refund_amt IN NUMBER,
3402 x_sch_refund_date IN DATE,
3403 x_uniq_layout_vend_code IN VARCHAR2,
3404 x_uniq_layout_ident_code IN VARCHAR2,
3405 x_p_person_id IN NUMBER,
3406 x_p_ssn IN VARCHAR2,
3407 x_p_ssn_chg_date IN DATE,
3408 x_p_last_name IN VARCHAR2,
3409 x_p_first_name IN VARCHAR2,
3410 x_p_middle_name IN VARCHAR2,
3411 x_p_permt_addr1 IN VARCHAR2,
3412 x_p_permt_addr2 IN VARCHAR2,
3413 x_p_permt_city IN VARCHAR2,
3414 x_p_permt_state IN VARCHAR2,
3415 x_p_permt_zip IN VARCHAR2,
3416 x_p_permt_addr_chg_date IN DATE,
3417 x_p_permt_phone IN VARCHAR2,
3418 x_p_email_addr IN VARCHAR2,
3419 x_p_date_of_birth IN DATE,
3420 x_p_dob_chg_date IN DATE,
3421 x_p_license_num IN VARCHAR2,
3422 x_p_license_state IN VARCHAR2,
3423 x_p_citizenship_status IN VARCHAR2,
3424 x_p_alien_reg_num IN VARCHAR2,
3425 x_p_default_status IN VARCHAR2,
3426 x_p_foreign_postal_code IN VARCHAR2,
3427 x_p_state_of_legal_res IN VARCHAR2,
3428 x_p_legal_res_date IN DATE,
3429 x_s_ssn IN VARCHAR2,
3430 x_s_ssn_chg_date IN DATE,
3431 x_s_last_name IN VARCHAR2,
3432 x_s_first_name IN VARCHAR2,
3433 x_s_middle_name IN VARCHAR2,
3434 x_s_permt_addr1 IN VARCHAR2,
3435 x_s_permt_addr2 IN VARCHAR2,
3436 x_s_permt_city IN VARCHAR2,
3437 x_s_permt_state IN VARCHAR2,
3438 x_s_permt_zip IN VARCHAR2,
3439 x_s_permt_addr_chg_date IN DATE,
3440 x_s_permt_phone IN VARCHAR2,
3441 x_s_local_addr1 IN VARCHAR2,
3442 x_s_local_addr2 IN VARCHAR2,
3443 x_s_local_city IN VARCHAR2,
3444 x_s_local_state IN VARCHAR2,
3445 x_s_local_zip IN VARCHAR2,
3446 x_s_local_addr_chg_date IN DATE,
3447 x_s_email_addr IN VARCHAR2,
3448 x_s_date_of_birth IN DATE,
3449 x_s_dob_chg_date IN DATE,
3450 x_s_license_num IN VARCHAR2,
3451 x_s_license_state IN VARCHAR2,
3452 x_s_depncy_status IN VARCHAR2,
3453 x_s_default_status IN VARCHAR2,
3454 x_s_citizenship_status IN VARCHAR2,
3455 x_s_alien_reg_num IN VARCHAR2,
3456 x_s_foreign_postal_code IN VARCHAR2,
3457 x_mode IN VARCHAR2 DEFAULT 'R',
3458 x_pnote_batch_id IN VARCHAR2,
3459 x_pnote_ack_date IN DATE,
3460 x_pnote_mpn_ind IN VARCHAR2,
3461 x_award_id IN NUMBER,
3462 x_base_id IN NUMBER,
3463 x_document_id_txt IN VARCHAR2,
3464 x_loan_key_num IN NUMBER,
3465 x_interest_rebate_percent_num IN NUMBER,
3466 x_fin_award_year IN VARCHAR2,
3467 x_cps_trans_num IN NUMBER,
3471 x_pymt_servicer_amt IN NUMBER,
3468 x_atd_entity_id_txt IN VARCHAR2,
3469 x_rep_entity_id_txt IN VARCHAR2,
3470 x_source_entity_id_txt IN VARCHAR2,
3472 x_pymt_servicer_date IN DATE,
3473 x_book_loan_amt IN NUMBER,
3474 x_book_loan_amt_date IN DATE,
3475 x_s_chg_birth_date IN DATE,
3476 x_s_chg_ssn IN VARCHAR2,
3477 x_s_chg_last_name IN VARCHAR2,
3478 x_b_chg_birth_date IN DATE,
3479 x_b_chg_ssn IN VARCHAR2,
3480 x_b_chg_last_name IN VARCHAR2,
3481 x_note_message IN VARCHAR2,
3482 x_full_resp_code IN VARCHAR2,
3483 x_s_permt_county IN VARCHAR2,
3484 x_b_permt_county IN VARCHAR2,
3485 x_s_permt_country IN VARCHAR2,
3486 x_b_permt_country IN VARCHAR2,
3487 x_crdt_decision_status IN VARCHAR2,
3488 x_external_loan_id_txt IN VARCHAR2,
3489 x_deferment_request_code IN VARCHAR2,
3490 x_eft_authorization_code IN VARCHAR2,
3491 x_requested_loan_amt IN NUMBER ,
3492 x_actual_record_type_code IN VARCHAR2,
3493 x_reinstatement_amt IN NUMBER ,
3494 x_lender_use_txt IN VARCHAR2,
3495 x_guarantor_use_txt IN VARCHAR2,
3496 x_fls_approved_amt IN NUMBER ,
3497 x_flu_approved_amt IN NUMBER ,
3498 x_flp_approved_amt IN NUMBER ,
3499 x_alt_approved_amt IN NUMBER ,
3500 x_loan_app_form_code IN VARCHAR2,
3501 x_alt_borrower_ind_flag IN VARCHAR2,
3502 x_school_id_txt IN VARCHAR2,
3503 x_cost_of_attendance_amt IN NUMBER ,
3504 x_established_fin_aid_amount IN NUMBER ,
3505 x_student_electronic_sign_flag IN VARCHAR2,
3506 x_mpn_type_flag IN VARCHAR2,
3507 x_school_use_txt IN VARCHAR2,
3508 x_expect_family_contribute_amt IN NUMBER ,
3509 x_borower_electronic_sign_flag IN VARCHAR2,
3510 x_borower_credit_authoriz_flag IN VARCHAR2,
3511 x_esign_src_typ_cd IN VARCHAR2
3512 ) AS
3513 /*
3514 || Created By : venagara
3515 || Created On : 22-JAN-2001
3516 || Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
3517 || Known limitations, enhancements or remarks :
3518 || Change History :
3519 || Who When What
3520 || (reverse chronological order - newest change first)
3521 */
3522 CURSOR c1 IS
3523 SELECT rowid
3524 FROM igf_sl_lor_loc_all
3525 WHERE loan_id = x_loan_id;
3526
3527 BEGIN
3528
3529 OPEN c1;
3530 FETCH c1 INTO x_rowid;
3531 IF (c1%NOTFOUND) THEN
3532 CLOSE c1;
3533
3534 insert_row (
3535 x_rowid,
3536 x_loan_id,
3537 x_origination_id,
3538 x_loan_number,
3539 x_loan_type,
3540 x_loan_amt_offered,
3541 x_loan_amt_accepted,
3542 x_loan_per_begin_date,
3543 x_loan_per_end_date,
3544 x_acad_yr_begin_date,
3545 x_acad_yr_end_date,
3546 x_loan_status,
3547 x_loan_status_date,
3548 x_loan_chg_status,
3549 x_loan_chg_status_date,
3550 x_req_serial_loan_code,
3551 x_act_serial_loan_code,
3552 x_active,
3553 x_active_date,
3554 x_sch_cert_date,
3555 x_orig_status_flag,
3556 x_orig_batch_id,
3557 x_orig_batch_date,
3558 x_chg_batch_id,
3559 x_orig_ack_date,
3560 x_credit_override,
3561 x_credit_decision_date,
3562 x_pnote_delivery_code,
3563 x_pnote_status,
3564 x_pnote_status_date,
3565 x_pnote_id,
3566 x_pnote_print_ind,
3567 x_pnote_accept_amt,
3568 x_pnote_accept_date,
3569 x_p_signature_code,
3570 x_p_signature_date,
3571 x_s_signature_code,
3572 x_unsub_elig_for_heal,
3573 x_disclosure_print_ind,
3574 x_orig_fee_perct,
3575 x_borw_confirm_ind,
3576 x_borw_interest_ind,
3577 x_unsub_elig_for_depnt,
3578 x_guarantee_amt,
3579 x_guarantee_date,
3580 x_guarnt_adj_ind,
3581 x_guarnt_amt_redn_code,
3582 x_guarnt_status_code,
3583 x_guarnt_status_date,
3584 x_lend_apprv_denied_code,
3585 x_lend_apprv_denied_date,
3586 x_lend_status_code,
3587 x_lend_status_date,
3588 x_grade_level_code,
3589 x_enrollment_code,
3590 x_anticip_compl_date,
3591 x_borw_lender_id,
3592 x_duns_borw_lender_id,
3593 x_guarantor_id,
3594 x_duns_guarnt_id,
3595 x_prc_type_code,
3596 x_rec_type_ind,
3597 x_cl_loan_type,
3598 x_cl_seq_number,
3599 x_last_resort_lender,
3600 x_lender_id,
3601 x_duns_lender_id,
3602 x_lend_non_ed_brc_id,
3603 x_recipient_id,
3604 x_recipient_type,
3608 x_cl_rec_status_last_update,
3605 x_duns_recip_id,
3606 x_recip_non_ed_brc_id,
3607 x_cl_rec_status,
3609 x_alt_prog_type_code,
3610 x_alt_appl_ver_code,
3611 x_borw_outstd_loan_code,
3612 x_mpn_confirm_code,
3613 x_resp_to_orig_code,
3614 x_appl_loan_phase_code,
3615 x_appl_loan_phase_code_chg,
3616 x_tot_outstd_stafford,
3617 x_tot_outstd_plus,
3618 x_alt_borw_tot_debt,
3619 x_act_interest_rate,
3620 x_service_type_code,
3621 x_rev_notice_of_guarnt,
3622 x_sch_refund_amt,
3623 x_sch_refund_date,
3624 x_uniq_layout_vend_code,
3625 x_uniq_layout_ident_code,
3626 x_p_person_id,
3627 x_p_ssn,
3628 x_p_ssn_chg_date,
3629 x_p_last_name,
3630 x_p_first_name,
3631 x_p_middle_name,
3632 x_p_permt_addr1,
3633 x_p_permt_addr2,
3634 x_p_permt_city,
3635 x_p_permt_state,
3636 x_p_permt_zip,
3637 x_p_permt_addr_chg_date,
3638 x_p_permt_phone,
3639 x_p_email_addr,
3640 x_p_date_of_birth,
3641 x_p_dob_chg_date,
3642 x_p_license_num,
3643 x_p_license_state,
3644 x_p_citizenship_status,
3645 x_p_alien_reg_num,
3646 x_p_default_status,
3647 x_p_foreign_postal_code,
3648 x_p_state_of_legal_res,
3649 x_p_legal_res_date,
3650 x_s_ssn,
3651 x_s_ssn_chg_date,
3652 x_s_last_name,
3653 x_s_first_name,
3654 x_s_middle_name,
3655 x_s_permt_addr1,
3656 x_s_permt_addr2,
3657 x_s_permt_city,
3658 x_s_permt_state,
3659 x_s_permt_zip,
3660 x_s_permt_addr_chg_date,
3661 x_s_permt_phone,
3662 x_s_local_addr1,
3663 x_s_local_addr2,
3664 x_s_local_city,
3665 x_s_local_state,
3666 x_s_local_zip,
3667 x_s_local_addr_chg_date,
3668 x_s_email_addr,
3669 x_s_date_of_birth,
3670 x_s_dob_chg_date,
3671 x_s_license_num,
3672 x_s_license_state,
3673 x_s_depncy_status,
3674 x_s_default_status,
3675 x_s_citizenship_status,
3676 x_s_alien_reg_num,
3677 x_s_foreign_postal_code,
3678 x_mode,
3679 x_pnote_batch_id,
3680 x_pnote_ack_date,
3681 x_pnote_mpn_ind,
3682 x_award_id,
3683 x_base_id,
3684 x_document_id_txt,
3685 x_loan_key_num,
3686 x_interest_rebate_percent_num,
3687 x_fin_award_year,
3688 x_cps_trans_num,
3689 x_atd_entity_id_txt,
3690 x_rep_entity_id_txt,
3691 x_source_entity_id_txt,
3692 x_pymt_servicer_amt,
3693 x_pymt_servicer_date,
3694 x_book_loan_amt,
3695 x_book_loan_amt_date,
3696 x_s_chg_birth_date,
3697 x_s_chg_ssn,
3698 x_s_chg_last_name,
3699 x_b_chg_birth_date,
3700 x_b_chg_ssn,
3701 x_b_chg_last_name,
3702 x_note_message,
3703 x_full_resp_code,
3704 x_s_permt_county,
3705 x_b_permt_county,
3706 x_s_permt_country,
3707 x_b_permt_country,
3708 x_crdt_decision_status,
3709 x_external_loan_id_txt ,
3710 x_deferment_request_code ,
3711 x_eft_authorization_code ,
3712 x_requested_loan_amt ,
3713 x_actual_record_type_code ,
3714 x_reinstatement_amt ,
3715 x_lender_use_txt ,
3716 x_guarantor_use_txt ,
3717 x_fls_approved_amt ,
3718 x_flu_approved_amt ,
3719 x_flp_approved_amt ,
3720 x_alt_approved_amt ,
3721 x_loan_app_form_code ,
3722 x_alt_borrower_ind_flag ,
3723 x_school_id_txt ,
3724 x_cost_of_attendance_amt ,
3725 x_established_fin_aid_amount ,
3726 x_student_electronic_sign_flag ,
3727 x_mpn_type_flag ,
3728 x_school_use_txt ,
3729 x_expect_family_contribute_amt ,
3730 x_borower_electronic_sign_flag ,
3731 x_borower_credit_authoriz_flag ,
3732 x_esign_src_typ_cd
3733 );
3734 RETURN;
3735 END IF;
3736 CLOSE c1;
3737
3738 update_row (
3739 x_rowid,
3740 x_loan_id,
3741 x_origination_id,
3742 x_loan_number,
3743 x_loan_type,
3744 x_loan_amt_offered,
3745 x_loan_amt_accepted,
3746 x_loan_per_begin_date,
3747 x_loan_per_end_date,
3748 x_acad_yr_begin_date,
3749 x_acad_yr_end_date,
3750 x_loan_status,
3751 x_loan_status_date,
3752 x_loan_chg_status,
3753 x_loan_chg_status_date,
3754 x_req_serial_loan_code,
3755 x_act_serial_loan_code,
3756 x_active,
3757 x_active_date,
3758 x_sch_cert_date,
3759 x_orig_status_flag,
3760 x_orig_batch_id,
3761 x_orig_batch_date,
3762 x_chg_batch_id,
3763 x_orig_ack_date,
3764 x_credit_override,
3765 x_credit_decision_date,
3766 x_pnote_delivery_code,
3767 x_pnote_status,
3768 x_pnote_status_date,
3769 x_pnote_id,
3770 x_pnote_print_ind,
3774 x_p_signature_date,
3771 x_pnote_accept_amt,
3772 x_pnote_accept_date,
3773 x_p_signature_code,
3775 x_s_signature_code,
3776 x_unsub_elig_for_heal,
3777 x_disclosure_print_ind,
3778 x_orig_fee_perct,
3779 x_borw_confirm_ind,
3780 x_borw_interest_ind,
3781 x_unsub_elig_for_depnt,
3782 x_guarantee_amt,
3783 x_guarantee_date,
3784 x_guarnt_adj_ind,
3785 x_guarnt_amt_redn_code,
3786 x_guarnt_status_code,
3787 x_guarnt_status_date,
3788 x_lend_apprv_denied_code,
3789 x_lend_apprv_denied_date,
3790 x_lend_status_code,
3791 x_lend_status_date,
3792 x_grade_level_code,
3793 x_enrollment_code,
3794 x_anticip_compl_date,
3795 x_borw_lender_id,
3796 x_duns_borw_lender_id,
3797 x_guarantor_id,
3798 x_duns_guarnt_id,
3799 x_prc_type_code,
3800 x_rec_type_ind,
3801 x_cl_loan_type,
3802 x_cl_seq_number,
3803 x_last_resort_lender,
3804 x_lender_id,
3805 x_duns_lender_id,
3806 x_lend_non_ed_brc_id,
3807 x_recipient_id,
3808 x_recipient_type,
3809 x_duns_recip_id,
3810 x_recip_non_ed_brc_id,
3811 x_cl_rec_status,
3812 x_cl_rec_status_last_update,
3813 x_alt_prog_type_code,
3814 x_alt_appl_ver_code,
3815 x_borw_outstd_loan_code,
3816 x_mpn_confirm_code,
3817 x_resp_to_orig_code,
3818 x_appl_loan_phase_code,
3819 x_appl_loan_phase_code_chg,
3820 x_tot_outstd_stafford,
3821 x_tot_outstd_plus,
3822 x_alt_borw_tot_debt,
3823 x_act_interest_rate,
3824 x_service_type_code,
3825 x_rev_notice_of_guarnt,
3826 x_sch_refund_amt,
3827 x_sch_refund_date,
3828 x_uniq_layout_vend_code,
3829 x_uniq_layout_ident_code,
3830 x_p_person_id,
3831 x_p_ssn,
3832 x_p_ssn_chg_date,
3833 x_p_last_name,
3834 x_p_first_name,
3835 x_p_middle_name,
3836 x_p_permt_addr1,
3837 x_p_permt_addr2,
3838 x_p_permt_city,
3839 x_p_permt_state,
3840 x_p_permt_zip,
3841 x_p_permt_addr_chg_date,
3842 x_p_permt_phone,
3843 x_p_email_addr,
3844 x_p_date_of_birth,
3845 x_p_dob_chg_date,
3846 x_p_license_num,
3847 x_p_license_state,
3848 x_p_citizenship_status,
3849 x_p_alien_reg_num,
3850 x_p_default_status,
3851 x_p_foreign_postal_code,
3852 x_p_state_of_legal_res,
3853 x_p_legal_res_date,
3854 x_s_ssn,
3855 x_s_ssn_chg_date,
3856 x_s_last_name,
3857 x_s_first_name,
3858 x_s_middle_name,
3859 x_s_permt_addr1,
3860 x_s_permt_addr2,
3861 x_s_permt_city,
3862 x_s_permt_state,
3863 x_s_permt_zip,
3864 x_s_permt_addr_chg_date,
3865 x_s_permt_phone,
3866 x_s_local_addr1,
3867 x_s_local_addr2,
3868 x_s_local_city,
3869 x_s_local_state,
3870 x_s_local_zip,
3871 x_s_local_addr_chg_date,
3872 x_s_email_addr,
3873 x_s_date_of_birth,
3874 x_s_dob_chg_date,
3875 x_s_license_num,
3876 x_s_license_state,
3877 x_s_depncy_status,
3878 x_s_default_status,
3879 x_s_citizenship_status,
3880 x_s_alien_reg_num,
3881 x_s_foreign_postal_code,
3882 x_mode,
3883 x_pnote_batch_id,
3884 x_pnote_ack_date,
3885 x_pnote_mpn_ind,
3886 x_award_id,
3887 x_base_id,
3888 x_document_id_txt,
3889 x_loan_key_num,
3890 x_interest_rebate_percent_num,
3891 x_fin_award_year,
3892 x_cps_trans_num,
3893 x_atd_entity_id_txt,
3894 x_rep_entity_id_txt,
3895 x_source_entity_id_txt,
3896 x_pymt_servicer_amt,
3897 x_pymt_servicer_date,
3898 x_book_loan_amt,
3899 x_book_loan_amt_date,
3900 x_s_chg_birth_date,
3901 x_s_chg_ssn,
3902 x_s_chg_last_name,
3903 x_b_chg_birth_date,
3904 x_b_chg_ssn,
3905 x_b_chg_last_name,
3906 x_note_message,
3907 x_full_resp_code,
3908 x_s_permt_county,
3909 x_b_permt_county,
3910 x_s_permt_country,
3911 x_b_permt_country,
3912 x_crdt_decision_status,
3913 x_external_loan_id_txt ,
3914 x_deferment_request_code ,
3915 x_eft_authorization_code ,
3916 x_requested_loan_amt ,
3917 x_actual_record_type_code ,
3918 x_reinstatement_amt ,
3919 x_lender_use_txt ,
3920 x_guarantor_use_txt ,
3921 x_fls_approved_amt ,
3922 x_flu_approved_amt ,
3923 x_flp_approved_amt ,
3924 x_alt_approved_amt ,
3925 x_loan_app_form_code ,
3926 x_alt_borrower_ind_flag ,
3927 x_school_id_txt ,
3928 x_cost_of_attendance_amt ,
3929 x_established_fin_aid_amount ,
3930 x_student_electronic_sign_flag ,
3931 x_mpn_type_flag ,
3932 x_school_use_txt ,
3933 x_expect_family_contribute_amt ,
3934 x_borower_electronic_sign_flag ,
3935 x_borower_credit_authoriz_flag ,
3936 x_esign_src_typ_cd
3937 );
3938
3939 END add_row;
3940
3941
3942 PROCEDURE delete_row (
3943 x_rowid IN VARCHAR2
3944 ) AS
3945 /*
3946 || Created By : venagara
3950 || Change History :
3947 || Created On : 22-JAN-2001
3948 || Purpose : Handles the DELETE DML logic for the table.
3949 || Known limitations, enhancements or remarks :
3951 || Who When What
3952 || (reverse chronological order - newest change first)
3953 */
3954 BEGIN
3955
3956 before_dml (
3957 p_action => 'DELETE',
3958 x_rowid => x_rowid
3959 );
3960
3961 DELETE FROM igf_sl_lor_loc_all
3962 WHERE rowid = x_rowid;
3963
3964 IF (SQL%NOTFOUND) THEN
3965 RAISE NO_DATA_FOUND;
3966 END IF;
3967
3968 END delete_row;
3969
3970 PROCEDURE after_dml(p_action IN VARCHAR2)
3971 AS
3972 /*
3973 || Created By : pssahni
3974 || Created On : 11/4/2004
3975 || Purpose : To insert in the history table also whenever
3976 || Known limitations, enhancements or remarks :
3977 || Change History :
3978 || Who When What
3979 || (reverse chronological order - newest change first)
3980 || bvisvana 28-Feb-2006 Build FA161. TBH Impact change.
3981 */
3982 l_rowid ROWID;
3983 l_source VARCHAR2(30);
3984 l_seq NUMBER;
3985 l_org_id igf_sl_lor_loc_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
3986
3987 BEGIN
3988
3989 IF p_action = 'INSERT' THEN
3990 l_source := 'SYSTEM';
3991 ELSIF p_action='UPDATE' THEN
3992 IF NVL(new_references.loan_status,'*') = 'S'
3993 OR NVL(new_references.loan_chg_status,'*') = 'S' THEN
3994 l_source := 'SYSTEM';
3995 ELSE
3996 l_source := 'RESPONSE';
3997 END IF;
3998 END IF;
3999
4000 igf_sl_lor_loc_history_pkg.insert_row(
4001 x_rowid => l_rowid,
4002 x_loan_id => new_references.loan_id,
4003 x_origination_id => new_references.origination_id,
4004 x_loan_number => new_references.loan_number,
4005 x_loan_type => new_references.loan_type,
4006 x_loan_amt_offered => new_references.loan_amt_offered,
4007 x_loan_amt_accepted => new_references.loan_amt_accepted,
4008 x_loan_per_begin_date => new_references.loan_per_begin_date,
4009 x_loan_per_end_date => new_references.loan_per_end_date,
4010 x_acad_yr_begin_date => new_references.acad_yr_begin_date,
4011 x_acad_yr_end_date => new_references.acad_yr_end_date,
4012 x_loan_status => new_references.loan_status,
4013 x_loan_status_date => new_references.loan_status_date,
4014 x_loan_chg_status => new_references.loan_chg_status,
4015 x_loan_chg_status_date => new_references.loan_chg_status_date,
4016 x_req_serial_loan_code => new_references.req_serial_loan_code,
4017 x_act_serial_loan_code => new_references.act_serial_loan_code,
4018 x_active => new_references.active,
4019 x_active_date => new_references.active_date,
4020 x_sch_cert_date => new_references.sch_cert_date,
4021 x_orig_status_flag => new_references.orig_status_flag,
4022 x_orig_batch_id => new_references.orig_batch_id,
4023 x_orig_batch_date => new_references.orig_batch_date,
4024 x_orig_ack_date => new_references.orig_ack_date,
4025 x_credit_override => new_references.credit_override,
4026 x_credit_decision_date => new_references.credit_decision_date,
4027 x_pnote_delivery_code => new_references.pnote_delivery_code,
4028 x_pnote_status => new_references.pnote_status,
4029 x_pnote_status_date => new_references.pnote_status_date,
4030 x_pnote_id => new_references.pnote_id,
4031 x_pnote_print_ind => new_references.pnote_print_ind,
4032 x_pnote_accept_amt => new_references.pnote_accept_amt,
4033 x_pnote_accept_date => new_references.pnote_accept_date,
4034 x_p_signature_code => new_references.p_signature_code,
4035 x_p_signature_date => new_references.p_signature_date,
4036 x_s_signature_code => new_references.s_signature_code,
4037 x_unsub_elig_for_heal => new_references.unsub_elig_for_heal,
4038 x_disclosure_print_ind => new_references.disclosure_print_ind,
4039 x_orig_fee_perct => new_references.orig_fee_perct,
4040 x_borw_confirm_ind => new_references.borw_confirm_ind,
4041 x_borw_interest_ind => new_references.borw_interest_ind,
4042 x_unsub_elig_for_depnt => new_references.unsub_elig_for_depnt,
4043 x_guarantee_amt => new_references.guarantee_amt,
4044 x_guarantee_date => new_references.guarantee_date,
4045 x_guarnt_adj_ind => new_references.guarnt_adj_ind,
4046 x_guarnt_amt_redn_code => new_references.guarnt_amt_redn_code,
4047 x_guarnt_status_code => new_references.guarnt_status_code,
4048 x_guarnt_status_date => new_references.guarnt_status_date,
4049 x_lend_apprv_denied_code => new_references.lend_apprv_denied_code,
4050 x_lend_apprv_denied_date => new_references.lend_apprv_denied_date,
4051 x_lend_status_code => new_references.lend_status_code,
4052 x_lend_status_date => new_references.lend_status_date,
4053 x_grade_level_code => new_references.grade_level_code,
4057 x_guarantor_id => new_references.guarantor_id,
4054 x_enrollment_code => new_references.enrollment_code,
4055 x_anticip_compl_date => new_references.anticip_compl_date,
4056 x_borw_lender_id => new_references.borw_lender_id,
4058 x_prc_type_code => new_references.prc_type_code,
4059 x_rec_type_ind => new_references.rec_type_ind,
4060 x_cl_loan_type => new_references.cl_loan_type,
4061 x_cl_seq_number => new_references.cl_seq_number,
4062 x_last_resort_lender => new_references.last_resort_lender,
4063 x_lender_id => new_references.lender_id,
4064 x_lend_non_ed_brc_id => new_references.lend_non_ed_brc_id,
4065 x_recipient_id => new_references.recipient_id,
4066 x_recipient_type => new_references.recipient_type,
4067 x_recip_non_ed_brc_id => new_references.recip_non_ed_brc_id,
4068 x_cl_rec_status => new_references.cl_rec_status,
4069 x_cl_rec_status_last_update => new_references.cl_rec_status_last_update,
4070 x_alt_prog_type_code => new_references.alt_prog_type_code,
4071 x_alt_appl_ver_code => new_references.alt_appl_ver_code,
4072 x_borw_outstd_loan_code => new_references.borw_outstd_loan_code,
4073 x_mpn_confirm_code => new_references.mpn_confirm_code,
4074 x_resp_to_orig_code => new_references.resp_to_orig_code,
4075 x_appl_loan_phase_code => new_references.appl_loan_phase_code,
4076 x_appl_loan_phase_code_chg => new_references.appl_loan_phase_code_chg,
4077 x_tot_outstd_stafford => new_references.tot_outstd_stafford,
4078 x_tot_outstd_plus => new_references.tot_outstd_plus,
4079 x_alt_borw_tot_debt => new_references.alt_borw_tot_debt,
4080 x_act_interest_rate => new_references.act_interest_rate,
4081 x_service_type_code => new_references.service_type_code,
4082 x_rev_notice_of_guarnt => new_references.rev_notice_of_guarnt,
4083 x_sch_refund_amt => new_references.sch_refund_amt,
4084 x_sch_refund_date => new_references.sch_refund_date,
4085 x_uniq_layout_vend_code => new_references.uniq_layout_vend_code,
4086 x_uniq_layout_ident_code => new_references.uniq_layout_ident_code,
4087 x_p_person_id => new_references.p_person_id,
4088 x_p_ssn => new_references.p_ssn,
4089 x_p_last_name => new_references.p_last_name,
4090 x_p_first_name => new_references.p_first_name,
4091 x_p_middle_name => new_references.p_middle_name,
4092 x_p_permt_addr1 => new_references.p_permt_addr1,
4093 x_p_permt_addr2 => new_references.p_permt_addr2,
4094 x_p_permt_city => new_references.p_permt_city,
4095 x_p_permt_state => new_references.p_permt_state,
4096 x_p_permt_zip => new_references.p_permt_zip,
4097 x_p_permt_addr_chg_date => new_references.p_permt_addr_chg_date,
4098 x_p_permt_phone => new_references.p_permt_phone,
4099 x_p_email_addr => new_references.p_email_addr,
4100 x_p_date_of_birth => new_references.p_date_of_birth,
4101 x_p_license_num => new_references.p_license_num,
4102 x_p_license_state => new_references.p_license_state,
4103 x_p_citizenship_status => new_references.p_citizenship_status,
4104 x_p_alien_reg_num => new_references.p_alien_reg_num,
4105 x_p_default_status => new_references.p_default_status,
4106 x_p_foreign_postal_code => new_references.p_foreign_postal_code,
4107 x_p_state_of_legal_res => new_references.p_state_of_legal_res,
4108 x_p_legal_res_date => new_references.p_legal_res_date,
4109 x_s_ssn => new_references.s_ssn,
4110 x_s_last_name => new_references.s_last_name,
4111 x_s_first_name => new_references.s_first_name,
4112 x_s_middle_name => new_references.s_middle_name,
4113 x_s_permt_addr1 => new_references.s_permt_addr1,
4114 x_s_permt_addr2 => new_references.s_permt_addr2,
4115 x_s_permt_city => new_references.s_permt_city,
4116 x_s_permt_state => new_references.s_permt_state,
4117 x_s_permt_zip => new_references.s_permt_zip,
4118 x_s_permt_addr_chg_date => new_references.s_permt_addr_chg_date,
4119 x_s_permt_phone => new_references.s_permt_phone,
4120 x_s_local_addr1 => new_references.s_local_addr1,
4121 x_s_local_addr2 => new_references.s_local_addr2,
4122 x_s_local_city => new_references.s_local_city,
4123 x_s_local_state => new_references.s_local_state,
4124 x_s_local_zip => new_references.s_local_zip,
4125 x_s_email_addr => new_references.s_email_addr,
4126 x_s_date_of_birth => new_references.s_date_of_birth,
4127 x_s_license_num => new_references.s_license_num,
4128 x_s_license_state => new_references.s_license_state,
4129 x_s_depncy_status => new_references.s_depncy_status,
4130 x_s_default_status => new_references.s_default_status,
4131 x_s_citizenship_status => new_references.s_citizenship_status,
4132 x_s_alien_reg_num => new_references.s_alien_reg_num,
4133 x_s_foreign_postal_code => new_references.s_foreign_postal_code,
4134 x_pnote_batch_id => new_references.pnote_batch_id,
4135 x_pnote_ack_date => new_references.pnote_ack_date,
4136 x_pnote_mpn_ind => new_references.pnote_mpn_ind,
4137 x_award_id => new_references.award_id,
4138 x_base_id => new_references.base_id,
4139 x_loan_key_num => new_references.loan_key_num,
4140 x_fin_award_year => new_references.fin_award_year,
4141 x_cps_trans_num => new_references.cps_trans_num,
4142 x_pymt_servicer_amt => new_references.pymt_servicer_amt,
4143 x_pymt_servicer_date => new_references.pymt_servicer_date,
4144 x_book_loan_amt => new_references.book_loan_amt,
4145 x_book_loan_amt_date => new_references.book_loan_amt_date,
4146 x_s_chg_ssn => new_references.s_chg_ssn,
4147 x_s_chg_last_name => new_references.s_chg_last_name,
4148 x_b_chg_ssn => new_references.b_chg_ssn,
4149 x_b_chg_last_name => new_references.b_chg_last_name,
4150 x_note_message => new_references.note_message,
4151 x_full_resp_code => new_references.full_resp_code,
4152 x_s_permt_county => new_references.s_permt_county,
4153 x_b_permt_county => new_references.b_permt_county,
4154 x_s_permt_country => new_references.s_permt_country,
4155 x_b_permt_country => new_references.b_permt_country,
4156 x_crdt_decision_status => new_references.crdt_decision_status,
4157 x_b_chg_birth_date => new_references.b_chg_birth_date,
4158 x_s_chg_birth_date => new_references.s_chg_birth_date,
4159 x_external_loan_id_txt => new_references.external_loan_id_txt ,
4160 x_deferment_request_code => new_references.deferment_request_code ,
4161 x_eft_authorization_code => new_references.eft_authorization_code ,
4162 x_requested_loan_amt => new_references.requested_loan_amt ,
4163 x_actual_record_type_code => new_references.actual_record_type_code ,
4164 x_reinstatement_amt => new_references.reinstatement_amt ,
4165 x_lender_use_txt => new_references.lender_use_txt ,
4166 x_guarantor_use_txt => new_references.guarantor_use_txt ,
4167 x_fls_approved_amt => new_references.fls_approved_amt ,
4168 x_flu_approved_amt => new_references.flu_approved_amt ,
4169 x_flp_approved_amt => new_references.flp_approved_amt ,
4170 x_alt_approved_amt => new_references.alt_approved_amt ,
4171 x_loan_app_form_code => new_references.loan_app_form_code ,
4172 x_alt_borrower_ind_flag => new_references.alt_borrower_ind_flag ,
4173 x_school_id_txt => new_references.school_id_txt ,
4174 x_cost_of_attendance_amt => new_references.cost_of_attendance_amt ,
4175 x_EXPECT_FAMILY_CONTRIBUTE_AMT => new_references.expect_family_contribute_amt,
4176 x_established_fin_aid_amount => new_references.established_fin_aid_amount ,
4177 x_BOROWER_ELECTRONIC_SIGN_FLAG => new_references.borower_electronic_sign_flag,
4178 x_student_electronic_sign_flag => new_references.student_electronic_sign_flag,
4179 x_BOROWER_CREDIT_AUTHORIZ_FLAG => new_references.borower_credit_authoriz_flag,
4180 x_mpn_type_flag => new_references.mpn_type_flag,
4181 x_school_use_txt => new_references.school_use_txt,
4182 x_document_id_txt => new_references.document_id_txt,
4183 x_atd_entity_id_txt => new_references.atd_entity_id_txt,
4184 x_rep_entity_id_txt => new_references.rep_entity_id_txt,
4185 x_source_entity_id_txt => new_references.source_entity_id_txt,
4186 x_interest_rebate_percent_num => new_references.interest_rebate_percent_num,
4187 x_esign_src_typ_cd => new_references.esign_src_typ_cd,
4188 x_loansh_id => l_seq,
4189 x_source_txt => l_source,
4190 x_mode => 'R'
4191 );
4192
4193 END;
4194
4195
4196 END igf_sl_lor_loc_pkg;