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