1 PACKAGE igf_sl_lor_loc_pkg AS
2 /* $Header: IGFLI11S.pls 120.1 2006/04/19 08:20:21 bvisvana noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_loan_id IN NUMBER,
7 x_origination_id IN NUMBER,
8 x_loan_number IN VARCHAR2,
9 x_loan_type IN VARCHAR2,
10 x_loan_amt_offered IN NUMBER,
11 x_loan_amt_accepted IN NUMBER,
12 x_loan_per_begin_date IN DATE,
13 x_loan_per_end_date IN DATE,
14 x_acad_yr_begin_date IN DATE,
15 x_acad_yr_end_date IN DATE,
16 x_loan_status IN VARCHAR2,
17 x_loan_status_date IN DATE,
18 x_loan_chg_status IN VARCHAR2,
19 x_loan_chg_status_date IN DATE,
20 x_req_serial_loan_code IN VARCHAR2,
21 x_act_serial_loan_code IN VARCHAR2,
22 x_active IN VARCHAR2,
23 x_active_date IN DATE,
24 x_sch_cert_date IN DATE,
25 x_orig_status_flag IN VARCHAR2,
26 x_orig_batch_id IN VARCHAR2,
27 x_orig_batch_date IN DATE,
28 x_chg_batch_id IN VARCHAR2,
29 x_orig_ack_date IN DATE,
30 x_credit_override IN VARCHAR2,
31 x_credit_decision_date IN DATE,
32 x_pnote_delivery_code IN VARCHAR2,
33 x_pnote_status IN VARCHAR2,
34 x_pnote_status_date IN DATE,
35 x_pnote_id IN VARCHAR2,
36 x_pnote_print_ind IN VARCHAR2,
37 x_pnote_accept_amt IN NUMBER,
38 x_pnote_accept_date IN DATE,
39 x_p_signature_code IN VARCHAR2,
40 x_p_signature_date IN DATE,
41 x_s_signature_code IN VARCHAR2,
42 x_unsub_elig_for_heal IN VARCHAR2,
43 x_disclosure_print_ind IN VARCHAR2,
44 x_orig_fee_perct IN NUMBER,
45 x_borw_confirm_ind IN VARCHAR2,
46 x_borw_interest_ind IN VARCHAR2,
47 x_unsub_elig_for_depnt IN VARCHAR2,
48 x_guarantee_amt IN NUMBER,
49 x_guarantee_date IN DATE,
50 x_guarnt_adj_ind IN VARCHAR2,
51 x_guarnt_amt_redn_code IN VARCHAR2,
52 x_guarnt_status_code IN VARCHAR2,
53 x_guarnt_status_date IN DATE,
54 x_lend_apprv_denied_code IN VARCHAR2,
55 x_lend_apprv_denied_date IN DATE,
56 x_lend_status_code IN VARCHAR2,
57 x_lend_status_date IN DATE,
58 x_grade_level_code IN VARCHAR2,
59 x_enrollment_code IN VARCHAR2,
60 x_anticip_compl_date IN DATE,
61 x_borw_lender_id IN VARCHAR2,
62 x_duns_borw_lender_id IN VARCHAR2,
63 x_guarantor_id IN VARCHAR2,
64 x_duns_guarnt_id IN VARCHAR2,
65 x_prc_type_code IN VARCHAR2,
66 x_rec_type_ind IN VARCHAR2,
67 x_cl_loan_type IN VARCHAR2,
68 x_cl_seq_number IN NUMBER,
69 x_last_resort_lender IN VARCHAR2,
70 x_lender_id IN VARCHAR2,
71 x_duns_lender_id IN VARCHAR2,
72 x_lend_non_ed_brc_id IN VARCHAR2,
73 x_recipient_id IN VARCHAR2,
74 x_recipient_type IN VARCHAR2,
75 x_duns_recip_id IN VARCHAR2,
76 x_recip_non_ed_brc_id IN VARCHAR2,
77 x_cl_rec_status IN VARCHAR2,
78 x_cl_rec_status_last_update IN DATE,
79 x_alt_prog_type_code IN VARCHAR2,
80 x_alt_appl_ver_code IN NUMBER,
81 x_borw_outstd_loan_code IN VARCHAR2,
82 x_mpn_confirm_code IN VARCHAR2,
83 x_resp_to_orig_code IN VARCHAR2,
84 x_appl_loan_phase_code IN VARCHAR2,
85 x_appl_loan_phase_code_chg IN DATE,
86 x_tot_outstd_stafford IN NUMBER,
87 x_tot_outstd_plus IN NUMBER,
88 x_alt_borw_tot_debt IN NUMBER,
89 x_act_interest_rate IN NUMBER,
90 x_service_type_code IN VARCHAR2,
91 x_rev_notice_of_guarnt IN VARCHAR2,
92 x_sch_refund_amt IN NUMBER,
93 x_sch_refund_date IN DATE,
94 x_uniq_layout_vend_code IN VARCHAR2,
95 x_uniq_layout_ident_code IN VARCHAR2,
96 x_p_person_id IN NUMBER,
97 x_p_ssn IN VARCHAR2,
98 x_p_ssn_chg_date IN DATE,
99 x_p_last_name IN VARCHAR2,
100 x_p_first_name IN VARCHAR2,
101 x_p_middle_name IN VARCHAR2,
102 x_p_permt_addr1 IN VARCHAR2,
103 x_p_permt_addr2 IN VARCHAR2,
104 x_p_permt_city IN VARCHAR2,
105 x_p_permt_state IN VARCHAR2,
106 x_p_permt_zip IN VARCHAR2,
107 x_p_permt_addr_chg_date IN DATE,
108 x_p_permt_phone IN VARCHAR2,
109 x_p_email_addr IN VARCHAR2,
110 x_p_date_of_birth IN DATE,
111 x_p_dob_chg_date IN DATE,
112 x_p_license_num IN VARCHAR2,
113 x_p_license_state IN VARCHAR2,
114 x_p_citizenship_status IN VARCHAR2,
115 x_p_alien_reg_num IN VARCHAR2,
116 x_p_default_status IN VARCHAR2,
117 x_p_foreign_postal_code IN VARCHAR2,
118 x_p_state_of_legal_res IN VARCHAR2,
119 x_p_legal_res_date IN DATE,
120 x_s_ssn IN VARCHAR2,
121 x_s_ssn_chg_date IN DATE,
122 x_s_last_name IN VARCHAR2,
123 x_s_first_name IN VARCHAR2,
124 x_s_middle_name IN VARCHAR2,
125 x_s_permt_addr1 IN VARCHAR2,
126 x_s_permt_addr2 IN VARCHAR2,
127 x_s_permt_city IN VARCHAR2,
128 x_s_permt_state IN VARCHAR2,
129 x_s_permt_zip IN VARCHAR2,
130 x_s_permt_addr_chg_date IN DATE,
131 x_s_permt_phone IN VARCHAR2,
132 x_s_local_addr1 IN VARCHAR2,
133 x_s_local_addr2 IN VARCHAR2,
134 x_s_local_city IN VARCHAR2,
135 x_s_local_state IN VARCHAR2,
136 x_s_local_zip IN VARCHAR2,
137 x_s_local_addr_chg_date IN DATE,
138 x_s_email_addr IN VARCHAR2,
139 x_s_date_of_birth IN DATE,
140 x_s_dob_chg_date IN DATE,
141 x_s_license_num IN VARCHAR2,
142 x_s_license_state IN VARCHAR2,
143 x_s_depncy_status IN VARCHAR2,
144 x_s_default_status IN VARCHAR2,
145 x_s_citizenship_status IN VARCHAR2,
146 x_s_alien_reg_num IN VARCHAR2,
147 x_s_foreign_postal_code IN VARCHAR2,
148 x_mode IN VARCHAR2 DEFAULT 'R',
149 x_pnote_batch_id IN VARCHAR2,
150 x_pnote_ack_date IN DATE,
151 x_pnote_mpn_ind IN VARCHAR2,
152 x_award_id IN NUMBER DEFAULT NULL,
153 x_base_id IN NUMBER DEFAULT NULL,
154 x_document_id_txt IN VARCHAR2 DEFAULT NULL,
155 x_loan_key_num IN NUMBER DEFAULT NULL,
156 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
157 x_fin_award_year IN VARCHAR2 DEFAULT NULL,
158 x_cps_trans_num IN NUMBER DEFAULT NULL,
159 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
160 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
161 x_source_entity_id_txt IN VARCHAR2 DEFAULT NULL,
162 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
163 x_pymt_servicer_date IN DATE DEFAULT NULL,
164 x_book_loan_amt IN NUMBER DEFAULT NULL,
165 x_book_loan_amt_date IN DATE DEFAULT NULL,
166 x_s_chg_birth_date IN DATE DEFAULT NULL,
167 x_s_chg_ssn IN VARCHAR2 DEFAULT NULL,
168 x_s_chg_last_name IN VARCHAR2 DEFAULT NULL,
169 x_b_chg_birth_date IN DATE DEFAULT NULL,
170 x_b_chg_ssn IN VARCHAR2 DEFAULT NULL,
171 x_b_chg_last_name IN VARCHAR2 DEFAULT NULL,
172 x_note_message IN VARCHAR2 DEFAULT NULL,
173 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
174 x_s_permt_county IN VARCHAR2 DEFAULT NULL,
175 x_b_permt_county IN VARCHAR2 DEFAULT NULL,
176 x_s_permt_country IN VARCHAR2 DEFAULT NULL,
177 x_b_permt_country IN VARCHAR2 DEFAULT NULL,
178 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
179 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
180 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
181 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
182 x_requested_loan_amt IN NUMBER DEFAULT NULL,
183 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
184 x_reinstatement_amt IN NUMBER DEFAULT NULL,
185 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
186 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
187 x_fls_approved_amt IN NUMBER DEFAULT NULL,
188 x_flu_approved_amt IN NUMBER DEFAULT NULL,
189 x_flp_approved_amt IN NUMBER DEFAULT NULL,
190 x_alt_approved_amt IN NUMBER DEFAULT NULL,
191 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
192 x_alt_borrower_ind_flag IN VARCHAR2 DEFAULT NULL,
193 x_school_id_txt IN VARCHAR2 DEFAULT NULL,
194 x_cost_of_attendance_amt IN NUMBER DEFAULT NULL,
195 x_established_fin_aid_amount IN NUMBER DEFAULT NULL,
196 x_student_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
197 x_mpn_type_flag IN VARCHAR2 DEFAULT NULL,
198 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
199 x_expect_family_contribute_amt IN NUMBER DEFAULT NULL,
200 x_borower_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
201 x_borower_credit_authoriz_flag IN VARCHAR2 DEFAULT NULL,
202 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL
203 );
204
205 PROCEDURE lock_row (
206 x_rowid IN VARCHAR2,
207 x_loan_id IN NUMBER,
208 x_origination_id IN NUMBER,
209 x_loan_number IN VARCHAR2,
210 x_loan_type IN VARCHAR2,
211 x_loan_amt_offered IN NUMBER,
212 x_loan_amt_accepted IN NUMBER,
213 x_loan_per_begin_date IN DATE,
214 x_loan_per_end_date IN DATE,
215 x_acad_yr_begin_date IN DATE,
216 x_acad_yr_end_date IN DATE,
217 x_loan_status IN VARCHAR2,
218 x_loan_status_date IN DATE,
219 x_loan_chg_status IN VARCHAR2,
220 x_loan_chg_status_date IN DATE,
221 x_req_serial_loan_code IN VARCHAR2,
222 x_act_serial_loan_code IN VARCHAR2,
223 x_active IN VARCHAR2,
224 x_active_date IN DATE,
225 x_sch_cert_date IN DATE,
226 x_orig_status_flag IN VARCHAR2,
227 x_orig_batch_id IN VARCHAR2,
228 x_orig_batch_date IN DATE,
229 x_chg_batch_id IN VARCHAR2,
230 x_orig_ack_date IN DATE,
231 x_credit_override IN VARCHAR2,
232 x_credit_decision_date IN DATE,
233 x_pnote_delivery_code IN VARCHAR2,
234 x_pnote_status IN VARCHAR2,
235 x_pnote_status_date IN DATE,
236 x_pnote_id IN VARCHAR2,
237 x_pnote_print_ind IN VARCHAR2,
238 x_pnote_accept_amt IN NUMBER,
239 x_pnote_accept_date IN DATE,
240 x_p_signature_code IN VARCHAR2,
241 x_p_signature_date IN DATE,
242 x_s_signature_code IN VARCHAR2,
243 x_unsub_elig_for_heal IN VARCHAR2,
244 x_disclosure_print_ind IN VARCHAR2,
245 x_orig_fee_perct IN NUMBER,
246 x_borw_confirm_ind IN VARCHAR2,
247 x_borw_interest_ind IN VARCHAR2,
248 x_unsub_elig_for_depnt IN VARCHAR2,
249 x_guarantee_amt IN NUMBER,
250 x_guarantee_date IN DATE,
251 x_guarnt_adj_ind IN VARCHAR2,
252 x_guarnt_amt_redn_code IN VARCHAR2,
253 x_guarnt_status_code IN VARCHAR2,
254 x_guarnt_status_date IN DATE,
255 x_lend_apprv_denied_code IN VARCHAR2,
256 x_lend_apprv_denied_date IN DATE,
257 x_lend_status_code IN VARCHAR2,
261 x_anticip_compl_date IN DATE,
258 x_lend_status_date IN DATE,
259 x_grade_level_code IN VARCHAR2,
260 x_enrollment_code IN VARCHAR2,
262 x_borw_lender_id IN VARCHAR2,
263 x_duns_borw_lender_id IN VARCHAR2,
264 x_guarantor_id IN VARCHAR2,
265 x_duns_guarnt_id IN VARCHAR2,
266 x_prc_type_code IN VARCHAR2,
267 x_rec_type_ind IN VARCHAR2,
268 x_cl_loan_type IN VARCHAR2,
269 x_cl_seq_number IN NUMBER,
270 x_last_resort_lender IN VARCHAR2,
271 x_lender_id IN VARCHAR2,
272 x_duns_lender_id IN VARCHAR2,
273 x_lend_non_ed_brc_id IN VARCHAR2,
274 x_recipient_id IN VARCHAR2,
275 x_recipient_type IN VARCHAR2,
276 x_duns_recip_id IN VARCHAR2,
277 x_recip_non_ed_brc_id IN VARCHAR2,
278 x_cl_rec_status IN VARCHAR2,
279 x_cl_rec_status_last_update IN DATE,
280 x_alt_prog_type_code IN VARCHAR2,
281 x_alt_appl_ver_code IN NUMBER,
282 x_borw_outstd_loan_code IN VARCHAR2,
283 x_mpn_confirm_code IN VARCHAR2,
284 x_resp_to_orig_code IN VARCHAR2,
285 x_appl_loan_phase_code IN VARCHAR2,
286 x_appl_loan_phase_code_chg IN DATE,
287 x_tot_outstd_stafford IN NUMBER,
288 x_tot_outstd_plus IN NUMBER,
289 x_alt_borw_tot_debt IN NUMBER,
290 x_act_interest_rate IN NUMBER,
291 x_service_type_code IN VARCHAR2,
292 x_rev_notice_of_guarnt IN VARCHAR2,
293 x_sch_refund_amt IN NUMBER,
294 x_sch_refund_date IN DATE,
295 x_uniq_layout_vend_code IN VARCHAR2,
296 x_uniq_layout_ident_code IN VARCHAR2,
297 x_p_person_id IN NUMBER,
298 x_p_ssn IN VARCHAR2,
299 x_p_ssn_chg_date IN DATE,
300 x_p_last_name IN VARCHAR2,
301 x_p_first_name IN VARCHAR2,
302 x_p_middle_name IN VARCHAR2,
303 x_p_permt_addr1 IN VARCHAR2,
304 x_p_permt_addr2 IN VARCHAR2,
305 x_p_permt_city IN VARCHAR2,
306 x_p_permt_state IN VARCHAR2,
307 x_p_permt_zip IN VARCHAR2,
308 x_p_permt_addr_chg_date IN DATE,
309 x_p_permt_phone IN VARCHAR2,
310 x_p_email_addr IN VARCHAR2,
311 x_p_date_of_birth IN DATE,
312 x_p_dob_chg_date IN DATE,
313 x_p_license_num IN VARCHAR2,
314 x_p_license_state IN VARCHAR2,
315 x_p_citizenship_status IN VARCHAR2,
316 x_p_alien_reg_num IN VARCHAR2,
317 x_p_default_status IN VARCHAR2,
318 x_p_foreign_postal_code IN VARCHAR2,
319 x_p_state_of_legal_res IN VARCHAR2,
320 x_p_legal_res_date IN DATE,
321 x_s_ssn IN VARCHAR2,
322 x_s_ssn_chg_date IN DATE,
323 x_s_last_name IN VARCHAR2,
324 x_s_first_name IN VARCHAR2,
325 x_s_middle_name IN VARCHAR2,
326 x_s_permt_addr1 IN VARCHAR2,
327 x_s_permt_addr2 IN VARCHAR2,
328 x_s_permt_city IN VARCHAR2,
329 x_s_permt_state IN VARCHAR2,
330 x_s_permt_zip IN VARCHAR2,
331 x_s_permt_addr_chg_date IN DATE,
332 x_s_permt_phone IN VARCHAR2,
333 x_s_local_addr1 IN VARCHAR2,
334 x_s_local_addr2 IN VARCHAR2,
335 x_s_local_city IN VARCHAR2,
336 x_s_local_state IN VARCHAR2,
337 x_s_local_zip IN VARCHAR2,
338 x_s_local_addr_chg_date IN DATE,
339 x_s_email_addr IN VARCHAR2,
340 x_s_date_of_birth IN DATE,
341 x_s_dob_chg_date IN DATE,
342 x_s_license_num IN VARCHAR2,
343 x_s_license_state IN VARCHAR2,
344 x_s_depncy_status IN VARCHAR2,
345 x_s_default_status IN VARCHAR2,
346 x_s_citizenship_status IN VARCHAR2,
347 x_s_alien_reg_num IN VARCHAR2,
348 x_s_foreign_postal_code IN VARCHAR2,
349 x_pnote_batch_id IN VARCHAR2,
350 x_pnote_ack_date IN DATE,
351 x_pnote_mpn_ind IN VARCHAR2,
352 x_award_id IN NUMBER DEFAULT NULL,
353 x_base_id IN NUMBER DEFAULT NULL,
357 x_fin_award_year IN VARCHAR2 DEFAULT NULL,
354 x_document_id_txt IN VARCHAR2 DEFAULT NULL,
355 x_loan_key_num IN NUMBER DEFAULT NULL,
356 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
358 x_cps_trans_num IN NUMBER DEFAULT NULL,
359 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
360 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
361 x_source_entity_id_txt IN VARCHAR2 DEFAULT NULL,
362 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
363 x_pymt_servicer_date IN DATE DEFAULT NULL,
364 x_book_loan_amt IN NUMBER DEFAULT NULL,
365 x_book_loan_amt_date IN DATE DEFAULT NULL,
366 x_s_chg_birth_date IN DATE DEFAULT NULL,
367 x_s_chg_ssn IN VARCHAR2 DEFAULT NULL,
368 x_s_chg_last_name IN VARCHAR2 DEFAULT NULL,
369 x_b_chg_birth_date IN DATE DEFAULT NULL,
370 x_b_chg_ssn IN VARCHAR2 DEFAULT NULL,
371 x_b_chg_last_name IN VARCHAR2 DEFAULT NULL,
372 x_note_message IN VARCHAR2 DEFAULT NULL,
373 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
374 x_s_permt_county IN VARCHAR2 DEFAULT NULL,
375 x_b_permt_county IN VARCHAR2 DEFAULT NULL,
376 x_s_permt_country IN VARCHAR2 DEFAULT NULL,
377 x_b_permt_country IN VARCHAR2 DEFAULT NULL,
378 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
379 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
380 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
381 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
382 x_requested_loan_amt IN NUMBER DEFAULT NULL,
383 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
384 x_reinstatement_amt IN NUMBER DEFAULT NULL,
385 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
386 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
387 x_fls_approved_amt IN NUMBER DEFAULT NULL,
388 x_flu_approved_amt IN NUMBER DEFAULT NULL,
389 x_flp_approved_amt IN NUMBER DEFAULT NULL,
390 x_alt_approved_amt IN NUMBER DEFAULT NULL,
391 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
392 x_alt_borrower_ind_flag IN VARCHAR2 DEFAULT NULL,
393 x_school_id_txt IN VARCHAR2 DEFAULT NULL,
394 x_cost_of_attendance_amt IN NUMBER DEFAULT NULL,
395 x_established_fin_aid_amount IN NUMBER DEFAULT NULL,
396 x_student_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
397 x_mpn_type_flag IN VARCHAR2 DEFAULT NULL,
398 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
399 x_expect_family_contribute_amt IN NUMBER DEFAULT NULL,
400 x_borower_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
401 x_borower_credit_authoriz_flag IN VARCHAR2 DEFAULT NULL,
402 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL
403 );
404
405 PROCEDURE update_row (
406 x_rowid IN VARCHAR2,
407 x_loan_id IN NUMBER,
408 x_origination_id IN NUMBER,
409 x_loan_number IN VARCHAR2,
410 x_loan_type IN VARCHAR2,
411 x_loan_amt_offered IN NUMBER,
412 x_loan_amt_accepted IN NUMBER,
413 x_loan_per_begin_date IN DATE,
414 x_loan_per_end_date IN DATE,
415 x_acad_yr_begin_date IN DATE,
416 x_acad_yr_end_date IN DATE,
417 x_loan_status IN VARCHAR2,
418 x_loan_status_date IN DATE,
419 x_loan_chg_status IN VARCHAR2,
420 x_loan_chg_status_date IN DATE,
421 x_req_serial_loan_code IN VARCHAR2,
422 x_act_serial_loan_code IN VARCHAR2,
423 x_active IN VARCHAR2,
424 x_active_date IN DATE,
425 x_sch_cert_date IN DATE,
426 x_orig_status_flag IN VARCHAR2,
427 x_orig_batch_id IN VARCHAR2,
428 x_orig_batch_date IN DATE,
429 x_chg_batch_id IN VARCHAR2,
430 x_orig_ack_date IN DATE,
431 x_credit_override IN VARCHAR2,
432 x_credit_decision_date IN DATE,
433 x_pnote_delivery_code IN VARCHAR2,
434 x_pnote_status IN VARCHAR2,
435 x_pnote_status_date IN DATE,
436 x_pnote_id IN VARCHAR2,
437 x_pnote_print_ind IN VARCHAR2,
438 x_pnote_accept_amt IN NUMBER,
439 x_pnote_accept_date IN DATE,
440 x_p_signature_code IN VARCHAR2,
444 x_disclosure_print_ind IN VARCHAR2,
441 x_p_signature_date IN DATE,
442 x_s_signature_code IN VARCHAR2,
443 x_unsub_elig_for_heal IN VARCHAR2,
445 x_orig_fee_perct IN NUMBER,
446 x_borw_confirm_ind IN VARCHAR2,
447 x_borw_interest_ind IN VARCHAR2,
448 x_unsub_elig_for_depnt IN VARCHAR2,
449 x_guarantee_amt IN NUMBER,
450 x_guarantee_date IN DATE,
451 x_guarnt_adj_ind IN VARCHAR2,
452 x_guarnt_amt_redn_code IN VARCHAR2,
453 x_guarnt_status_code IN VARCHAR2,
454 x_guarnt_status_date IN DATE,
455 x_lend_apprv_denied_code IN VARCHAR2,
456 x_lend_apprv_denied_date IN DATE,
457 x_lend_status_code IN VARCHAR2,
458 x_lend_status_date IN DATE,
459 x_grade_level_code IN VARCHAR2,
460 x_enrollment_code IN VARCHAR2,
461 x_anticip_compl_date IN DATE,
462 x_borw_lender_id IN VARCHAR2,
463 x_duns_borw_lender_id IN VARCHAR2,
464 x_guarantor_id IN VARCHAR2,
465 x_duns_guarnt_id IN VARCHAR2,
466 x_prc_type_code IN VARCHAR2,
467 x_rec_type_ind IN VARCHAR2,
468 x_cl_loan_type IN VARCHAR2,
469 x_cl_seq_number IN NUMBER,
470 x_last_resort_lender IN VARCHAR2,
471 x_lender_id IN VARCHAR2,
472 x_duns_lender_id IN VARCHAR2,
473 x_lend_non_ed_brc_id IN VARCHAR2,
474 x_recipient_id IN VARCHAR2,
475 x_recipient_type IN VARCHAR2,
476 x_duns_recip_id IN VARCHAR2,
477 x_recip_non_ed_brc_id IN VARCHAR2,
478 x_cl_rec_status IN VARCHAR2,
479 x_cl_rec_status_last_update IN DATE,
480 x_alt_prog_type_code IN VARCHAR2,
481 x_alt_appl_ver_code IN NUMBER,
482 x_borw_outstd_loan_code IN VARCHAR2,
483 x_mpn_confirm_code IN VARCHAR2,
484 x_resp_to_orig_code IN VARCHAR2,
485 x_appl_loan_phase_code IN VARCHAR2,
486 x_appl_loan_phase_code_chg IN DATE,
487 x_tot_outstd_stafford IN NUMBER,
488 x_tot_outstd_plus IN NUMBER,
489 x_alt_borw_tot_debt IN NUMBER,
490 x_act_interest_rate IN NUMBER,
491 x_service_type_code IN VARCHAR2,
492 x_rev_notice_of_guarnt IN VARCHAR2,
493 x_sch_refund_amt IN NUMBER,
494 x_sch_refund_date IN DATE,
495 x_uniq_layout_vend_code IN VARCHAR2,
496 x_uniq_layout_ident_code IN VARCHAR2,
497 x_p_person_id IN NUMBER,
498 x_p_ssn IN VARCHAR2,
499 x_p_ssn_chg_date IN DATE,
500 x_p_last_name IN VARCHAR2,
501 x_p_first_name IN VARCHAR2,
502 x_p_middle_name IN VARCHAR2,
503 x_p_permt_addr1 IN VARCHAR2,
504 x_p_permt_addr2 IN VARCHAR2,
505 x_p_permt_city IN VARCHAR2,
506 x_p_permt_state IN VARCHAR2,
507 x_p_permt_zip IN VARCHAR2,
508 x_p_permt_addr_chg_date IN DATE,
509 x_p_permt_phone IN VARCHAR2,
510 x_p_email_addr IN VARCHAR2,
511 x_p_date_of_birth IN DATE,
512 x_p_dob_chg_date IN DATE,
513 x_p_license_num IN VARCHAR2,
514 x_p_license_state IN VARCHAR2,
515 x_p_citizenship_status IN VARCHAR2,
516 x_p_alien_reg_num IN VARCHAR2,
517 x_p_default_status IN VARCHAR2,
518 x_p_foreign_postal_code IN VARCHAR2,
519 x_p_state_of_legal_res IN VARCHAR2,
520 x_p_legal_res_date IN DATE,
521 x_s_ssn IN VARCHAR2,
522 x_s_ssn_chg_date IN DATE,
523 x_s_last_name IN VARCHAR2,
524 x_s_first_name IN VARCHAR2,
525 x_s_middle_name IN VARCHAR2,
526 x_s_permt_addr1 IN VARCHAR2,
527 x_s_permt_addr2 IN VARCHAR2,
528 x_s_permt_city IN VARCHAR2,
529 x_s_permt_state IN VARCHAR2,
530 x_s_permt_zip IN VARCHAR2,
531 x_s_permt_addr_chg_date IN DATE,
532 x_s_permt_phone IN VARCHAR2,
533 x_s_local_addr1 IN VARCHAR2,
534 x_s_local_addr2 IN VARCHAR2,
535 x_s_local_city IN VARCHAR2,
536 x_s_local_state IN VARCHAR2,
540 x_s_date_of_birth IN DATE,
537 x_s_local_zip IN VARCHAR2,
538 x_s_local_addr_chg_date IN DATE,
539 x_s_email_addr IN VARCHAR2,
541 x_s_dob_chg_date IN DATE,
542 x_s_license_num IN VARCHAR2,
543 x_s_license_state IN VARCHAR2,
544 x_s_depncy_status IN VARCHAR2,
545 x_s_default_status IN VARCHAR2,
546 x_s_citizenship_status IN VARCHAR2,
547 x_s_alien_reg_num IN VARCHAR2,
548 x_s_foreign_postal_code IN VARCHAR2,
549 x_mode IN VARCHAR2 DEFAULT 'R',
550 x_pnote_batch_id IN VARCHAR2,
551 x_pnote_ack_date IN DATE,
552 x_pnote_mpn_ind IN VARCHAR2,
553 x_award_id IN NUMBER DEFAULT NULL,
554 x_base_id IN NUMBER DEFAULT NULL,
555 x_document_id_txt IN VARCHAR2 DEFAULT NULL,
556 x_loan_key_num IN NUMBER DEFAULT NULL,
557 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
558 x_fin_award_year IN VARCHAR2 DEFAULT NULL,
559 x_cps_trans_num IN NUMBER DEFAULT NULL,
560 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
561 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
562 x_source_entity_id_txt IN VARCHAR2 DEFAULT NULL,
563 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
564 x_pymt_servicer_date IN DATE DEFAULT NULL,
565 x_book_loan_amt IN NUMBER DEFAULT NULL,
566 x_book_loan_amt_date IN DATE DEFAULT NULL,
567 x_s_chg_birth_date IN DATE DEFAULT NULL,
568 x_s_chg_ssn IN VARCHAR2 DEFAULT NULL,
569 x_s_chg_last_name IN VARCHAR2 DEFAULT NULL,
570 x_b_chg_birth_date IN DATE DEFAULT NULL,
571 x_b_chg_ssn IN VARCHAR2 DEFAULT NULL,
572 x_b_chg_last_name IN VARCHAR2 DEFAULT NULL,
573 x_note_message IN VARCHAR2 DEFAULT NULL,
574 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
575 x_s_permt_county IN VARCHAR2 DEFAULT NULL,
576 x_b_permt_county IN VARCHAR2 DEFAULT NULL,
577 x_s_permt_country IN VARCHAR2 DEFAULT NULL,
578 x_b_permt_country IN VARCHAR2 DEFAULT NULL,
579 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
580 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
581 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
582 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
583 x_requested_loan_amt IN NUMBER DEFAULT NULL,
584 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
585 x_reinstatement_amt IN NUMBER DEFAULT NULL,
586 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
587 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
588 x_fls_approved_amt IN NUMBER DEFAULT NULL,
589 x_flu_approved_amt IN NUMBER DEFAULT NULL,
590 x_flp_approved_amt IN NUMBER DEFAULT NULL,
591 x_alt_approved_amt IN NUMBER DEFAULT NULL,
592 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
593 x_alt_borrower_ind_flag IN VARCHAR2 DEFAULT NULL,
594 x_school_id_txt IN VARCHAR2 DEFAULT NULL,
595 x_cost_of_attendance_amt IN NUMBER DEFAULT NULL,
596 x_established_fin_aid_amount IN NUMBER DEFAULT NULL,
597 x_student_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
598 x_mpn_type_flag IN VARCHAR2 DEFAULT NULL,
599 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
600 x_expect_family_contribute_amt IN NUMBER DEFAULT NULL,
601 x_borower_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
602 x_borower_credit_authoriz_flag IN VARCHAR2 DEFAULT NULL,
603 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL
604 );
605
606 PROCEDURE add_row (
607 x_rowid IN OUT NOCOPY VARCHAR2,
608 x_loan_id IN NUMBER,
609 x_origination_id IN NUMBER,
610 x_loan_number IN VARCHAR2,
611 x_loan_type IN VARCHAR2,
612 x_loan_amt_offered IN NUMBER,
613 x_loan_amt_accepted IN NUMBER,
614 x_loan_per_begin_date IN DATE,
615 x_loan_per_end_date IN DATE,
616 x_acad_yr_begin_date IN DATE,
617 x_acad_yr_end_date IN DATE,
618 x_loan_status IN VARCHAR2,
619 x_loan_status_date IN DATE,
620 x_loan_chg_status IN VARCHAR2,
621 x_loan_chg_status_date IN DATE,
622 x_req_serial_loan_code IN VARCHAR2,
626 x_sch_cert_date IN DATE,
623 x_act_serial_loan_code IN VARCHAR2,
624 x_active IN VARCHAR2,
625 x_active_date IN DATE,
627 x_orig_status_flag IN VARCHAR2,
628 x_orig_batch_id IN VARCHAR2,
629 x_orig_batch_date IN DATE,
630 x_chg_batch_id IN VARCHAR2,
631 x_orig_ack_date IN DATE,
632 x_credit_override IN VARCHAR2,
633 x_credit_decision_date IN DATE,
634 x_pnote_delivery_code IN VARCHAR2,
635 x_pnote_status IN VARCHAR2,
636 x_pnote_status_date IN DATE,
637 x_pnote_id IN VARCHAR2,
638 x_pnote_print_ind IN VARCHAR2,
639 x_pnote_accept_amt IN NUMBER,
640 x_pnote_accept_date IN DATE,
641 x_p_signature_code IN VARCHAR2,
642 x_p_signature_date IN DATE,
643 x_s_signature_code IN VARCHAR2,
644 x_unsub_elig_for_heal IN VARCHAR2,
645 x_disclosure_print_ind IN VARCHAR2,
646 x_orig_fee_perct IN NUMBER,
647 x_borw_confirm_ind IN VARCHAR2,
648 x_borw_interest_ind IN VARCHAR2,
649 x_unsub_elig_for_depnt IN VARCHAR2,
650 x_guarantee_amt IN NUMBER,
651 x_guarantee_date IN DATE,
652 x_guarnt_adj_ind IN VARCHAR2,
653 x_guarnt_amt_redn_code IN VARCHAR2,
654 x_guarnt_status_code IN VARCHAR2,
655 x_guarnt_status_date IN DATE,
656 x_lend_apprv_denied_code IN VARCHAR2,
657 x_lend_apprv_denied_date IN DATE,
658 x_lend_status_code IN VARCHAR2,
659 x_lend_status_date IN DATE,
660 x_grade_level_code IN VARCHAR2,
661 x_enrollment_code IN VARCHAR2,
662 x_anticip_compl_date IN DATE,
663 x_borw_lender_id IN VARCHAR2,
664 x_duns_borw_lender_id IN VARCHAR2,
665 x_guarantor_id IN VARCHAR2,
666 x_duns_guarnt_id IN VARCHAR2,
667 x_prc_type_code IN VARCHAR2,
668 x_rec_type_ind IN VARCHAR2,
669 x_cl_loan_type IN VARCHAR2,
670 x_cl_seq_number IN NUMBER,
671 x_last_resort_lender IN VARCHAR2,
672 x_lender_id IN VARCHAR2,
673 x_duns_lender_id IN VARCHAR2,
674 x_lend_non_ed_brc_id IN VARCHAR2,
675 x_recipient_id IN VARCHAR2,
676 x_recipient_type IN VARCHAR2,
677 x_duns_recip_id IN VARCHAR2,
678 x_recip_non_ed_brc_id IN VARCHAR2,
679 x_cl_rec_status IN VARCHAR2,
680 x_cl_rec_status_last_update IN DATE,
681 x_alt_prog_type_code IN VARCHAR2,
682 x_alt_appl_ver_code IN NUMBER,
683 x_borw_outstd_loan_code IN VARCHAR2,
684 x_mpn_confirm_code IN VARCHAR2,
685 x_resp_to_orig_code IN VARCHAR2,
686 x_appl_loan_phase_code IN VARCHAR2,
687 x_appl_loan_phase_code_chg IN DATE,
688 x_tot_outstd_stafford IN NUMBER,
689 x_tot_outstd_plus IN NUMBER,
690 x_alt_borw_tot_debt IN NUMBER,
691 x_act_interest_rate IN NUMBER,
692 x_service_type_code IN VARCHAR2,
693 x_rev_notice_of_guarnt IN VARCHAR2,
694 x_sch_refund_amt IN NUMBER,
695 x_sch_refund_date IN DATE,
696 x_uniq_layout_vend_code IN VARCHAR2,
697 x_uniq_layout_ident_code IN VARCHAR2,
698 x_p_person_id IN NUMBER,
699 x_p_ssn IN VARCHAR2,
700 x_p_ssn_chg_date IN DATE,
701 x_p_last_name IN VARCHAR2,
702 x_p_first_name IN VARCHAR2,
703 x_p_middle_name IN VARCHAR2,
704 x_p_permt_addr1 IN VARCHAR2,
705 x_p_permt_addr2 IN VARCHAR2,
706 x_p_permt_city IN VARCHAR2,
707 x_p_permt_state IN VARCHAR2,
708 x_p_permt_zip IN VARCHAR2,
709 x_p_permt_addr_chg_date IN DATE,
710 x_p_permt_phone IN VARCHAR2,
711 x_p_email_addr IN VARCHAR2,
712 x_p_date_of_birth IN DATE,
713 x_p_dob_chg_date IN DATE,
714 x_p_license_num IN VARCHAR2,
715 x_p_license_state IN VARCHAR2,
716 x_p_citizenship_status IN VARCHAR2,
717 x_p_alien_reg_num IN VARCHAR2,
718 x_p_default_status IN VARCHAR2,
719 x_p_foreign_postal_code IN VARCHAR2,
723 x_s_ssn_chg_date IN DATE,
720 x_p_state_of_legal_res IN VARCHAR2,
721 x_p_legal_res_date IN DATE,
722 x_s_ssn IN VARCHAR2,
724 x_s_last_name IN VARCHAR2,
725 x_s_first_name IN VARCHAR2,
726 x_s_middle_name IN VARCHAR2,
727 x_s_permt_addr1 IN VARCHAR2,
728 x_s_permt_addr2 IN VARCHAR2,
729 x_s_permt_city IN VARCHAR2,
730 x_s_permt_state IN VARCHAR2,
731 x_s_permt_zip IN VARCHAR2,
732 x_s_permt_addr_chg_date IN DATE,
733 x_s_permt_phone IN VARCHAR2,
734 x_s_local_addr1 IN VARCHAR2,
735 x_s_local_addr2 IN VARCHAR2,
736 x_s_local_city IN VARCHAR2,
737 x_s_local_state IN VARCHAR2,
738 x_s_local_zip IN VARCHAR2,
739 x_s_local_addr_chg_date IN DATE,
740 x_s_email_addr IN VARCHAR2,
741 x_s_date_of_birth IN DATE,
742 x_s_dob_chg_date IN DATE,
743 x_s_license_num IN VARCHAR2,
744 x_s_license_state IN VARCHAR2,
745 x_s_depncy_status IN VARCHAR2,
746 x_s_default_status IN VARCHAR2,
747 x_s_citizenship_status IN VARCHAR2,
748 x_s_alien_reg_num IN VARCHAR2,
749 x_s_foreign_postal_code IN VARCHAR2,
750 x_mode IN VARCHAR2 DEFAULT 'R',
751 x_pnote_batch_id IN VARCHAR2,
752 x_pnote_ack_date IN DATE,
753 x_pnote_mpn_ind IN VARCHAR2,
754 x_award_id IN NUMBER DEFAULT NULL,
755 x_base_id IN NUMBER DEFAULT NULL,
756 x_document_id_txt IN VARCHAR2 DEFAULT NULL,
757 x_loan_key_num IN NUMBER DEFAULT NULL,
758 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
759 x_fin_award_year IN VARCHAR2 DEFAULT NULL,
760 x_cps_trans_num IN NUMBER DEFAULT NULL,
761 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
762 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
763 x_source_entity_id_txt IN VARCHAR2 DEFAULT NULL,
764 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
765 x_pymt_servicer_date IN DATE DEFAULT NULL,
766 x_book_loan_amt IN NUMBER DEFAULT NULL,
767 x_book_loan_amt_date IN DATE DEFAULT NULL,
768 x_s_chg_birth_date IN DATE DEFAULT NULL,
769 x_s_chg_ssn IN VARCHAR2 DEFAULT NULL,
770 x_s_chg_last_name IN VARCHAR2 DEFAULT NULL,
771 x_b_chg_birth_date IN DATE DEFAULT NULL,
772 x_b_chg_ssn IN VARCHAR2 DEFAULT NULL,
773 x_b_chg_last_name IN VARCHAR2 DEFAULT NULL,
774 x_note_message IN VARCHAR2 DEFAULT NULL,
775 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
776 x_s_permt_county IN VARCHAR2 DEFAULT NULL,
777 x_b_permt_county IN VARCHAR2 DEFAULT NULL,
778 x_s_permt_country IN VARCHAR2 DEFAULT NULL,
779 x_b_permt_country IN VARCHAR2 DEFAULT NULL,
780 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
781 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
782 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
783 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
784 x_requested_loan_amt IN NUMBER DEFAULT NULL,
785 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
786 x_reinstatement_amt IN NUMBER DEFAULT NULL,
787 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
788 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
789 x_fls_approved_amt IN NUMBER DEFAULT NULL,
790 x_flu_approved_amt IN NUMBER DEFAULT NULL,
791 x_flp_approved_amt IN NUMBER DEFAULT NULL,
792 x_alt_approved_amt IN NUMBER DEFAULT NULL,
793 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
794 x_alt_borrower_ind_flag IN VARCHAR2 DEFAULT NULL,
795 x_school_id_txt IN VARCHAR2 DEFAULT NULL,
796 x_cost_of_attendance_amt IN NUMBER DEFAULT NULL,
797 x_established_fin_aid_amount IN NUMBER DEFAULT NULL,
798 x_student_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
799 x_mpn_type_flag IN VARCHAR2 DEFAULT NULL,
800 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
801 x_expect_family_contribute_amt IN NUMBER DEFAULT NULL,
802 x_borower_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
803 x_borower_credit_authoriz_flag IN VARCHAR2 DEFAULT NULL,
804 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL
805 );
806
807 PROCEDURE delete_row (
808 x_rowid IN VARCHAR2
809 );
810
811 FUNCTION get_pk_for_validation (
812 x_loan_id IN NUMBER
813 ) RETURN BOOLEAN;
814
815 FUNCTION get_uk_for_validation (
816 x_origination_id IN NUMBER
817 ) RETURN BOOLEAN;
818
819 PROCEDURE get_fk_igf_sl_lor (
820 x_origination_id IN NUMBER
821 );
822
823 PROCEDURE get_fk_igf_aw_award (
824 x_award_id IN NUMBER
825 );
826
827 PROCEDURE get_fk_igf_ap_fa_base_rec (
828 x_base_id IN NUMBER
829 );
830
831
832
833
834
835
836 PROCEDURE before_dml (
837 p_action IN VARCHAR2,
838 x_rowid IN VARCHAR2 DEFAULT NULL,
839 x_loan_id IN NUMBER DEFAULT NULL,
840 x_origination_id IN NUMBER DEFAULT NULL,
841 x_loan_number IN VARCHAR2 DEFAULT NULL,
842 x_loan_type IN VARCHAR2 DEFAULT NULL,
843 x_loan_amt_offered IN NUMBER DEFAULT NULL,
844 x_loan_amt_accepted IN NUMBER DEFAULT NULL,
845 x_loan_per_begin_date IN DATE DEFAULT NULL,
846 x_loan_per_end_date IN DATE DEFAULT NULL,
847 x_acad_yr_begin_date IN DATE DEFAULT NULL,
848 x_acad_yr_end_date IN DATE DEFAULT NULL,
849 x_loan_status IN VARCHAR2 DEFAULT NULL,
850 x_loan_status_date IN DATE DEFAULT NULL,
851 x_loan_chg_status IN VARCHAR2 DEFAULT NULL,
852 x_loan_chg_status_date IN DATE DEFAULT NULL,
853 x_req_serial_loan_code IN VARCHAR2 DEFAULT NULL,
854 x_act_serial_loan_code IN VARCHAR2 DEFAULT NULL,
855 x_active IN VARCHAR2 DEFAULT NULL,
856 x_active_date IN DATE DEFAULT NULL,
857 x_sch_cert_date IN DATE DEFAULT NULL,
858 x_orig_status_flag IN VARCHAR2 DEFAULT NULL,
859 x_orig_batch_id IN VARCHAR2 DEFAULT NULL,
860 x_orig_batch_date IN DATE DEFAULT NULL,
861 x_chg_batch_id IN VARCHAR2 DEFAULT NULL,
862 x_orig_ack_date IN DATE DEFAULT NULL,
863 x_credit_override IN VARCHAR2 DEFAULT NULL,
864 x_credit_decision_date IN DATE DEFAULT NULL,
865 x_pnote_delivery_code IN VARCHAR2 DEFAULT NULL,
866 x_pnote_status IN VARCHAR2 DEFAULT NULL,
867 x_pnote_status_date IN DATE DEFAULT NULL,
868 x_pnote_id IN VARCHAR2 DEFAULT NULL,
869 x_pnote_print_ind IN VARCHAR2 DEFAULT NULL,
870 x_pnote_accept_amt IN NUMBER DEFAULT NULL,
871 x_pnote_accept_date IN DATE DEFAULT NULL,
872 x_p_signature_code IN VARCHAR2 DEFAULT NULL,
873 x_p_signature_date IN DATE DEFAULT NULL,
874 x_s_signature_code IN VARCHAR2 DEFAULT NULL,
875 x_unsub_elig_for_heal IN VARCHAR2 DEFAULT NULL,
876 x_disclosure_print_ind IN VARCHAR2 DEFAULT NULL,
877 x_orig_fee_perct IN NUMBER DEFAULT NULL,
878 x_borw_confirm_ind IN VARCHAR2 DEFAULT NULL,
879 x_borw_interest_ind IN VARCHAR2 DEFAULT NULL,
880 x_unsub_elig_for_depnt IN VARCHAR2 DEFAULT NULL,
881 x_guarantee_amt IN NUMBER DEFAULT NULL,
882 x_guarantee_date IN DATE DEFAULT NULL,
883 x_guarnt_adj_ind IN VARCHAR2 DEFAULT NULL,
884 x_guarnt_amt_redn_code IN VARCHAR2 DEFAULT NULL,
885 x_guarnt_status_code IN VARCHAR2 DEFAULT NULL,
886 x_guarnt_status_date IN DATE DEFAULT NULL,
887 x_lend_apprv_denied_code IN VARCHAR2 DEFAULT NULL,
888 x_lend_apprv_denied_date IN DATE DEFAULT NULL,
889 x_lend_status_code IN VARCHAR2 DEFAULT NULL,
890 x_lend_status_date IN DATE DEFAULT NULL,
891 x_grade_level_code IN VARCHAR2 DEFAULT NULL,
892 x_enrollment_code IN VARCHAR2 DEFAULT NULL,
893 x_anticip_compl_date IN DATE DEFAULT NULL,
894 x_borw_lender_id IN VARCHAR2 DEFAULT NULL,
895 x_duns_borw_lender_id IN VARCHAR2 DEFAULT NULL,
896 x_guarantor_id IN VARCHAR2 DEFAULT NULL,
897 x_duns_guarnt_id IN VARCHAR2 DEFAULT NULL,
898 x_prc_type_code IN VARCHAR2 DEFAULT NULL,
899 x_rec_type_ind IN VARCHAR2 DEFAULT NULL,
900 x_cl_loan_type IN VARCHAR2 DEFAULT NULL,
901 x_cl_seq_number IN NUMBER DEFAULT NULL,
902 x_last_resort_lender IN VARCHAR2 DEFAULT NULL,
903 x_lender_id IN VARCHAR2 DEFAULT NULL,
904 x_duns_lender_id IN VARCHAR2 DEFAULT NULL,
908 x_duns_recip_id IN VARCHAR2 DEFAULT NULL,
905 x_lend_non_ed_brc_id IN VARCHAR2 DEFAULT NULL,
906 x_recipient_id IN VARCHAR2 DEFAULT NULL,
907 x_recipient_type IN VARCHAR2 DEFAULT NULL,
909 x_recip_non_ed_brc_id IN VARCHAR2 DEFAULT NULL,
910 x_cl_rec_status IN VARCHAR2 DEFAULT NULL,
911 x_cl_rec_status_last_update IN DATE DEFAULT NULL,
912 x_alt_prog_type_code IN VARCHAR2 DEFAULT NULL,
913 x_alt_appl_ver_code IN NUMBER DEFAULT NULL,
914 x_borw_outstd_loan_code IN VARCHAR2 DEFAULT NULL,
915 x_mpn_confirm_code IN VARCHAR2 DEFAULT NULL,
916 x_resp_to_orig_code IN VARCHAR2 DEFAULT NULL,
917 x_appl_loan_phase_code IN VARCHAR2 DEFAULT NULL,
918 x_appl_loan_phase_code_chg IN DATE DEFAULT NULL,
919 x_tot_outstd_stafford IN NUMBER DEFAULT NULL,
920 x_tot_outstd_plus IN NUMBER DEFAULT NULL,
921 x_alt_borw_tot_debt IN NUMBER DEFAULT NULL,
922 x_act_interest_rate IN NUMBER DEFAULT NULL,
923 x_service_type_code IN VARCHAR2 DEFAULT NULL,
924 x_rev_notice_of_guarnt IN VARCHAR2 DEFAULT NULL,
925 x_sch_refund_amt IN NUMBER DEFAULT NULL,
926 x_sch_refund_date IN DATE DEFAULT NULL,
927 x_uniq_layout_vend_code IN VARCHAR2 DEFAULT NULL,
928 x_uniq_layout_ident_code IN VARCHAR2 DEFAULT NULL,
929 x_p_person_id IN NUMBER DEFAULT NULL,
930 x_p_ssn IN VARCHAR2 DEFAULT NULL,
931 x_p_ssn_chg_date IN DATE DEFAULT NULL,
932 x_p_last_name IN VARCHAR2 DEFAULT NULL,
933 x_p_first_name IN VARCHAR2 DEFAULT NULL,
934 x_p_middle_name IN VARCHAR2 DEFAULT NULL,
935 x_p_permt_addr1 IN VARCHAR2 DEFAULT NULL,
936 x_p_permt_addr2 IN VARCHAR2 DEFAULT NULL,
937 x_p_permt_city IN VARCHAR2 DEFAULT NULL,
938 x_p_permt_state IN VARCHAR2 DEFAULT NULL,
939 x_p_permt_zip IN VARCHAR2 DEFAULT NULL,
940 x_p_permt_addr_chg_date IN DATE DEFAULT NULL,
941 x_p_permt_phone IN VARCHAR2 DEFAULT NULL,
942 x_p_email_addr IN VARCHAR2 DEFAULT NULL,
943 x_p_date_of_birth IN DATE DEFAULT NULL,
944 x_p_dob_chg_date IN DATE DEFAULT NULL,
945 x_p_license_num IN VARCHAR2 DEFAULT NULL,
946 x_p_license_state IN VARCHAR2 DEFAULT NULL,
947 x_p_citizenship_status IN VARCHAR2 DEFAULT NULL,
948 x_p_alien_reg_num IN VARCHAR2 DEFAULT NULL,
949 x_p_default_status IN VARCHAR2 DEFAULT NULL,
950 x_p_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
951 x_p_state_of_legal_res IN VARCHAR2 DEFAULT NULL,
952 x_p_legal_res_date IN DATE DEFAULT NULL,
953 x_s_ssn IN VARCHAR2 DEFAULT NULL,
954 x_s_ssn_chg_date IN DATE DEFAULT NULL,
955 x_s_last_name IN VARCHAR2 DEFAULT NULL,
956 x_s_first_name IN VARCHAR2 DEFAULT NULL,
957 x_s_middle_name IN VARCHAR2 DEFAULT NULL,
958 x_s_permt_addr1 IN VARCHAR2 DEFAULT NULL,
959 x_s_permt_addr2 IN VARCHAR2 DEFAULT NULL,
960 x_s_permt_city IN VARCHAR2 DEFAULT NULL,
961 x_s_permt_state IN VARCHAR2 DEFAULT NULL,
962 x_s_permt_zip IN VARCHAR2 DEFAULT NULL,
963 x_s_permt_addr_chg_date IN DATE DEFAULT NULL,
964 x_s_permt_phone IN VARCHAR2 DEFAULT NULL,
965 x_s_local_addr1 IN VARCHAR2 DEFAULT NULL,
966 x_s_local_addr2 IN VARCHAR2 DEFAULT NULL,
967 x_s_local_city IN VARCHAR2 DEFAULT NULL,
968 x_s_local_state IN VARCHAR2 DEFAULT NULL,
969 x_s_local_zip IN VARCHAR2 DEFAULT NULL,
970 x_s_local_addr_chg_date IN DATE DEFAULT NULL,
971 x_s_email_addr IN VARCHAR2 DEFAULT NULL,
972 x_s_date_of_birth IN DATE DEFAULT NULL,
973 x_s_dob_chg_date IN DATE DEFAULT NULL,
974 x_s_license_num IN VARCHAR2 DEFAULT NULL,
975 x_s_license_state IN VARCHAR2 DEFAULT NULL,
976 x_s_depncy_status IN VARCHAR2 DEFAULT NULL,
977 x_s_default_status IN VARCHAR2 DEFAULT NULL,
978 x_s_citizenship_status IN VARCHAR2 DEFAULT NULL,
979 x_s_alien_reg_num IN VARCHAR2 DEFAULT NULL,
980 x_s_foreign_postal_code IN VARCHAR2 DEFAULT NULL,
981 x_creation_date IN DATE DEFAULT NULL,
982 x_created_by IN NUMBER DEFAULT NULL,
983 x_last_update_date IN DATE DEFAULT NULL,
984 x_last_updated_by IN NUMBER DEFAULT NULL,
988 x_pnote_mpn_ind IN VARCHAR2 DEFAULT NULL,
985 x_last_update_login IN NUMBER DEFAULT NULL,
986 x_pnote_batch_id IN VARCHAR2 DEFAULT NULL,
987 x_pnote_ack_date IN DATE DEFAULT NULL,
989 x_award_id IN NUMBER DEFAULT NULL,
990 x_base_id IN NUMBER DEFAULT NULL,
991 x_document_id_txt IN VARCHAR2 DEFAULT NULL,
992 x_loan_key_num IN NUMBER DEFAULT NULL,
993 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
994 x_fin_award_year IN VARCHAR2 DEFAULT NULL,
995 x_cps_trans_num IN NUMBER DEFAULT NULL,
996 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
997 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
998 x_source_entity_id_txt IN VARCHAR2 DEFAULT NULL,
999 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
1000 x_pymt_servicer_date IN DATE DEFAULT NULL,
1001 x_book_loan_amt IN NUMBER DEFAULT NULL,
1002 x_book_loan_amt_date IN DATE DEFAULT NULL,
1003 x_s_chg_birth_date IN DATE DEFAULT NULL,
1004 x_s_chg_ssn IN VARCHAR2 DEFAULT NULL,
1005 x_s_chg_last_name IN VARCHAR2 DEFAULT NULL,
1006 x_b_chg_birth_date IN DATE DEFAULT NULL,
1007 x_b_chg_ssn IN VARCHAR2 DEFAULT NULL,
1008 x_b_chg_last_name IN VARCHAR2 DEFAULT NULL,
1009 x_note_message IN VARCHAR2 DEFAULT NULL,
1010 x_full_resp_code IN VARCHAR2 DEFAULT NULL,
1011 x_s_permt_county IN VARCHAR2 DEFAULT NULL,
1012 x_b_permt_county IN VARCHAR2 DEFAULT NULL,
1013 x_s_permt_country IN VARCHAR2 DEFAULT NULL,
1014 x_b_permt_country IN VARCHAR2 DEFAULT NULL,
1015 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
1016 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
1017 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
1018 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
1019 x_requested_loan_amt IN NUMBER DEFAULT NULL,
1020 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
1021 x_reinstatement_amt IN NUMBER DEFAULT NULL,
1022 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
1023 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
1024 x_fls_approved_amt IN NUMBER DEFAULT NULL,
1025 x_flu_approved_amt IN NUMBER DEFAULT NULL,
1026 x_flp_approved_amt IN NUMBER DEFAULT NULL,
1027 x_alt_approved_amt IN NUMBER DEFAULT NULL,
1028 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
1029 x_alt_borrower_ind_flag IN VARCHAR2 DEFAULT NULL,
1030 x_school_id_txt IN VARCHAR2 DEFAULT NULL,
1031 x_cost_of_attendance_amt IN NUMBER DEFAULT NULL,
1032 x_established_fin_aid_amount IN NUMBER DEFAULT NULL,
1033 x_student_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
1034 x_mpn_type_flag IN VARCHAR2 DEFAULT NULL,
1035 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
1036 x_expect_family_contribute_amt IN NUMBER DEFAULT NULL,
1037 x_borower_electronic_sign_flag IN VARCHAR2 DEFAULT NULL,
1038 x_borower_credit_authoriz_flag IN VARCHAR2 DEFAULT NULL,
1039 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL
1040 );
1041
1042 PROCEDURE after_dml(p_action IN VARCHAR2
1043 ) ;
1044
1045
1046
1047 END igf_sl_lor_loc_pkg;
[Home] [Help]