1 PACKAGE igf_sl_lor_pkg AS
2 /* $Header: IGFLI10S.pls 120.1 2006/04/19 08:17:02 bvisvana noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_origination_id IN OUT NOCOPY NUMBER,
7 x_loan_id IN NUMBER,
8 x_sch_cert_date IN DATE,
9 x_orig_status_flag IN VARCHAR2,
10 x_orig_batch_id IN VARCHAR2,
11 x_orig_batch_date IN DATE,
12 x_chg_batch_id IN VARCHAR2,
13 x_orig_ack_date IN DATE,
14 x_credit_override IN VARCHAR2,
15 x_credit_decision_date IN DATE,
16 x_req_serial_loan_code IN VARCHAR2,
17 x_act_serial_loan_code IN VARCHAR2,
18 x_pnote_delivery_code IN VARCHAR2,
19 x_pnote_status IN VARCHAR2,
20 x_pnote_status_date IN DATE,
21 x_pnote_id IN VARCHAR2,
22 x_pnote_print_ind IN VARCHAR2,
23 x_pnote_accept_amt IN NUMBER,
24 x_pnote_accept_date IN DATE,
25 x_unsub_elig_for_heal IN VARCHAR2,
26 x_disclosure_print_ind IN VARCHAR2,
27 x_orig_fee_perct IN NUMBER,
28 x_borw_confirm_ind IN VARCHAR2,
29 x_borw_interest_ind IN VARCHAR2,
30 x_borw_outstd_loan_code IN VARCHAR2,
31 x_unsub_elig_for_depnt IN VARCHAR2,
32 x_guarantee_amt IN NUMBER,
33 x_guarantee_date IN DATE,
34 x_guarnt_amt_redn_code IN VARCHAR2,
35 x_guarnt_status_code IN VARCHAR2,
36 x_guarnt_status_date IN DATE,
37 x_lend_apprv_denied_code IN VARCHAR2,
38 x_lend_apprv_denied_date IN DATE,
39 x_lend_status_code IN VARCHAR2,
40 x_lend_status_date IN DATE,
41 x_guarnt_adj_ind IN VARCHAR2,
42 x_grade_level_code IN VARCHAR2,
43 x_enrollment_code IN VARCHAR2,
44 x_anticip_compl_date IN DATE,
45 x_borw_lender_id IN VARCHAR2,
46 x_duns_borw_lender_id IN VARCHAR2,
47 x_guarantor_id IN VARCHAR2,
48 x_duns_guarnt_id IN VARCHAR2,
49 x_prc_type_code IN VARCHAR2,
50 x_cl_seq_number IN NUMBER,
51 x_last_resort_lender IN VARCHAR2,
52 x_lender_id IN VARCHAR2,
53 x_duns_lender_id IN VARCHAR2,
54 x_lend_non_ed_brc_id IN VARCHAR2,
55 x_recipient_id IN VARCHAR2,
56 x_recipient_type IN VARCHAR2,
57 x_duns_recip_id IN VARCHAR2,
58 x_recip_non_ed_brc_id IN VARCHAR2,
59 x_rec_type_ind IN VARCHAR2,
60 x_cl_loan_type IN VARCHAR2,
61 x_cl_rec_status IN VARCHAR2,
62 x_cl_rec_status_last_update IN DATE,
63 x_alt_prog_type_code IN VARCHAR2,
64 x_alt_appl_ver_code IN NUMBER,
65 x_mpn_confirm_code IN VARCHAR2,
66 x_resp_to_orig_code IN VARCHAR2,
67 x_appl_loan_phase_code IN VARCHAR2,
68 x_appl_loan_phase_code_chg IN DATE,
69 x_appl_send_error_codes IN VARCHAR2,
70 x_tot_outstd_stafford IN NUMBER,
71 x_tot_outstd_plus IN NUMBER,
72 x_alt_borw_tot_debt IN NUMBER,
73 x_act_interest_rate IN NUMBER,
74 x_service_type_code IN VARCHAR2,
75 x_rev_notice_of_guarnt IN VARCHAR2,
76 x_sch_refund_amt IN NUMBER,
77 x_sch_refund_date IN DATE,
78 x_uniq_layout_vend_code IN VARCHAR2,
79 x_uniq_layout_ident_code IN VARCHAR2,
80 x_p_person_id IN NUMBER,
81 x_p_ssn_chg_date IN DATE,
82 x_p_dob_chg_date IN DATE,
83 x_p_permt_addr_chg_date IN DATE,
84 x_p_default_status IN VARCHAR2,
85 x_p_signature_code IN VARCHAR2,
86 x_p_signature_date IN DATE,
87 x_s_ssn_chg_date IN DATE,
88 x_s_dob_chg_date IN DATE,
89 x_s_permt_addr_chg_date IN DATE,
90 x_s_local_addr_chg_date IN DATE,
91 x_s_default_status IN VARCHAR2,
92 x_s_signature_code IN VARCHAR2,
93 x_mode IN VARCHAR2 DEFAULT 'R',
94 x_pnote_batch_id IN VARCHAR2,
95 x_pnote_ack_date IN DATE,
96 x_pnote_mpn_ind IN VARCHAR2,
97 x_elec_mpn_ind IN VARCHAR2,
98 x_borr_sign_ind IN VARCHAR2,
99 x_stud_sign_ind IN VARCHAR2,
100 x_borr_credit_auth_code IN VARCHAR2,
101 x_relationship_cd IN VARCHAR2 DEFAULT NULL,
102 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
103 x_cps_trans_num IN NUMBER DEFAULT NULL,
104 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
105 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
106 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
107 x_note_message IN VARCHAR2 DEFAULT NULL,
108 x_book_loan_amt IN NUMBER DEFAULT NULL,
109 x_book_loan_amt_date IN DATE DEFAULT NULL,
110 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
111 x_pymt_servicer_date IN DATE DEFAULT NULL,
112 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
113 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
114 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
115 x_requested_loan_amt IN NUMBER DEFAULT NULL,
116 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
117 x_reinstatement_amt IN NUMBER DEFAULT NULL,
118 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
119 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
120 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
121 x_fls_approved_amt IN NUMBER DEFAULT NULL,
122 x_flu_approved_amt IN NUMBER DEFAULT NULL,
123 x_flp_approved_amt IN NUMBER DEFAULT NULL,
124 x_alt_approved_amt IN NUMBER DEFAULT NULL,
125 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
126 x_override_grade_level_code IN VARCHAR2 DEFAULT NULL,
127 x_b_alien_reg_num_txt IN VARCHAR2 DEFAULT NULL,
128 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL,
129 x_acad_begin_date IN DATE DEFAULT NULL,
130 x_acad_end_date IN DATE DEFAULT NULL
131
132
133 );
134
135 PROCEDURE lock_row (
136 x_rowid IN VARCHAR2,
137 x_origination_id IN NUMBER,
138 x_loan_id IN NUMBER,
139 x_sch_cert_date IN DATE,
140 x_orig_status_flag IN VARCHAR2,
141 x_orig_batch_id IN VARCHAR2,
142 x_orig_batch_date IN DATE,
143 x_chg_batch_id IN VARCHAR2,
144 x_orig_ack_date IN DATE,
145 x_credit_override IN VARCHAR2,
146 x_credit_decision_date IN DATE,
147 x_req_serial_loan_code IN VARCHAR2,
148 x_act_serial_loan_code IN VARCHAR2,
149 x_pnote_delivery_code IN VARCHAR2,
150 x_pnote_status IN VARCHAR2,
151 x_pnote_status_date IN DATE,
152 x_pnote_id IN VARCHAR2,
153 x_pnote_print_ind IN VARCHAR2,
154 x_pnote_accept_amt IN NUMBER,
155 x_pnote_accept_date IN DATE,
156 x_unsub_elig_for_heal IN VARCHAR2,
157 x_disclosure_print_ind IN VARCHAR2,
158 x_orig_fee_perct IN NUMBER,
159 x_borw_confirm_ind IN VARCHAR2,
160 x_borw_interest_ind IN VARCHAR2,
161 x_borw_outstd_loan_code IN VARCHAR2,
162 x_unsub_elig_for_depnt IN VARCHAR2,
163 x_guarantee_amt IN NUMBER,
164 x_guarantee_date IN DATE,
165 x_guarnt_amt_redn_code IN VARCHAR2,
166 x_guarnt_status_code IN VARCHAR2,
167 x_guarnt_status_date IN DATE,
168 x_lend_apprv_denied_code IN VARCHAR2,
169 x_lend_apprv_denied_date IN DATE,
170 x_lend_status_code IN VARCHAR2,
171 x_lend_status_date IN DATE,
172 x_guarnt_adj_ind IN VARCHAR2,
173 x_grade_level_code IN VARCHAR2,
174 x_enrollment_code IN VARCHAR2,
175 x_anticip_compl_date IN DATE,
176 x_borw_lender_id IN VARCHAR2,
177 x_duns_borw_lender_id IN VARCHAR2,
178 x_guarantor_id IN VARCHAR2,
179 x_duns_guarnt_id IN VARCHAR2,
180 x_prc_type_code IN VARCHAR2,
181 x_cl_seq_number IN NUMBER,
182 x_last_resort_lender IN VARCHAR2,
183 x_lender_id IN VARCHAR2,
184 x_duns_lender_id IN VARCHAR2,
185 x_lend_non_ed_brc_id IN VARCHAR2,
186 x_recipient_id IN VARCHAR2,
187 x_recipient_type IN VARCHAR2,
188 x_duns_recip_id IN VARCHAR2,
189 x_recip_non_ed_brc_id IN VARCHAR2,
190 x_rec_type_ind IN VARCHAR2,
191 x_cl_loan_type IN VARCHAR2,
192 x_cl_rec_status IN VARCHAR2,
193 x_cl_rec_status_last_update IN DATE,
194 x_alt_prog_type_code IN VARCHAR2,
195 x_alt_appl_ver_code IN NUMBER,
196 x_mpn_confirm_code IN VARCHAR2,
197 x_resp_to_orig_code IN VARCHAR2,
198 x_appl_loan_phase_code IN VARCHAR2,
199 x_appl_loan_phase_code_chg IN DATE,
200 x_appl_send_error_codes IN VARCHAR2,
201 x_tot_outstd_stafford IN NUMBER,
202 x_tot_outstd_plus IN NUMBER,
203 x_alt_borw_tot_debt IN NUMBER,
204 x_act_interest_rate IN NUMBER,
205 x_service_type_code IN VARCHAR2,
206 x_rev_notice_of_guarnt IN VARCHAR2,
207 x_sch_refund_amt IN NUMBER,
208 x_sch_refund_date IN DATE,
209 x_uniq_layout_vend_code IN VARCHAR2,
210 x_uniq_layout_ident_code IN VARCHAR2,
211 x_p_person_id IN NUMBER,
212 x_p_ssn_chg_date IN DATE,
213 x_p_dob_chg_date IN DATE,
214 x_p_permt_addr_chg_date IN DATE,
215 x_p_default_status IN VARCHAR2,
216 x_p_signature_code IN VARCHAR2,
217 x_p_signature_date IN DATE,
218 x_s_ssn_chg_date IN DATE,
219 x_s_dob_chg_date IN DATE,
220 x_s_permt_addr_chg_date IN DATE,
221 x_s_local_addr_chg_date IN DATE,
222 x_s_default_status IN VARCHAR2,
223 x_s_signature_code IN VARCHAR2,
224 x_pnote_batch_id IN VARCHAR2,
225 x_pnote_ack_date IN DATE,
226 x_pnote_mpn_ind IN VARCHAR2,
227 x_elec_mpn_ind IN VARCHAR2,
228 x_borr_sign_ind IN VARCHAR2,
229 x_stud_sign_ind IN VARCHAR2,
230 x_borr_credit_auth_code IN VARCHAR2,
231 x_relationship_cd IN VARCHAR2 DEFAULT NULL,
232 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
233 x_cps_trans_num IN NUMBER DEFAULT NULL,
234 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
235 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
236 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
237 x_note_message IN VARCHAR2 DEFAULT NULL,
238 x_book_loan_amt IN NUMBER DEFAULT NULL,
239 x_book_loan_amt_date IN DATE DEFAULT NULL,
240 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
241 x_pymt_servicer_date IN DATE DEFAULT NULL,
242 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
243 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
244 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
245 x_requested_loan_amt IN NUMBER DEFAULT NULL,
249 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
246 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
247 x_reinstatement_amt IN NUMBER DEFAULT NULL,
248 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
250 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
251 x_fls_approved_amt IN NUMBER DEFAULT NULL,
252 x_flu_approved_amt IN NUMBER DEFAULT NULL,
253 x_flp_approved_amt IN NUMBER DEFAULT NULL,
254 x_alt_approved_amt IN NUMBER DEFAULT NULL,
255 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
256 x_override_grade_level_code IN VARCHAR2 DEFAULT NULL ,
257 x_b_alien_reg_num_txt IN VARCHAR2 DEFAULT NULL,
258 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL,
259 x_acad_begin_date IN DATE DEFAULT NULL,
260 x_acad_end_date IN DATE DEFAULT NULL
261
262 );
263
264 PROCEDURE update_row (
265 x_rowid IN VARCHAR2,
266 x_origination_id IN NUMBER,
267 x_loan_id IN NUMBER,
268 x_sch_cert_date IN DATE,
269 x_orig_status_flag IN VARCHAR2,
270 x_orig_batch_id IN VARCHAR2,
271 x_orig_batch_date IN DATE,
272 x_chg_batch_id IN VARCHAR2,
273 x_orig_ack_date IN DATE,
274 x_credit_override IN VARCHAR2,
275 x_credit_decision_date IN DATE,
276 x_req_serial_loan_code IN VARCHAR2,
277 x_act_serial_loan_code IN VARCHAR2,
278 x_pnote_delivery_code IN VARCHAR2,
279 x_pnote_status IN VARCHAR2,
280 x_pnote_status_date IN DATE,
281 x_pnote_id IN VARCHAR2,
282 x_pnote_print_ind IN VARCHAR2,
283 x_pnote_accept_amt IN NUMBER,
284 x_pnote_accept_date IN DATE,
285 x_unsub_elig_for_heal IN VARCHAR2,
286 x_disclosure_print_ind IN VARCHAR2,
287 x_orig_fee_perct IN NUMBER,
288 x_borw_confirm_ind IN VARCHAR2,
289 x_borw_interest_ind IN VARCHAR2,
290 x_borw_outstd_loan_code IN VARCHAR2,
291 x_unsub_elig_for_depnt IN VARCHAR2,
292 x_guarantee_amt IN NUMBER,
293 x_guarantee_date IN DATE,
294 x_guarnt_amt_redn_code IN VARCHAR2,
295 x_guarnt_status_code IN VARCHAR2,
296 x_guarnt_status_date IN DATE,
297 x_lend_apprv_denied_code IN VARCHAR2,
298 x_lend_apprv_denied_date IN DATE,
299 x_lend_status_code IN VARCHAR2,
300 x_lend_status_date IN DATE,
301 x_guarnt_adj_ind IN VARCHAR2,
302 x_grade_level_code IN VARCHAR2,
303 x_enrollment_code IN VARCHAR2,
304 x_anticip_compl_date IN DATE,
305 x_borw_lender_id IN VARCHAR2,
306 x_duns_borw_lender_id IN VARCHAR2,
307 x_guarantor_id IN VARCHAR2,
308 x_duns_guarnt_id IN VARCHAR2,
309 x_prc_type_code IN VARCHAR2,
310 x_cl_seq_number IN NUMBER,
311 x_last_resort_lender IN VARCHAR2,
312 x_lender_id IN VARCHAR2,
313 x_duns_lender_id IN VARCHAR2,
314 x_lend_non_ed_brc_id IN VARCHAR2,
315 x_recipient_id IN VARCHAR2,
316 x_recipient_type IN VARCHAR2,
317 x_duns_recip_id IN VARCHAR2,
318 x_recip_non_ed_brc_id IN VARCHAR2,
319 x_rec_type_ind IN VARCHAR2,
320 x_cl_loan_type IN VARCHAR2,
321 x_cl_rec_status IN VARCHAR2,
322 x_cl_rec_status_last_update IN DATE,
323 x_alt_prog_type_code IN VARCHAR2,
324 x_alt_appl_ver_code IN NUMBER,
325 x_mpn_confirm_code IN VARCHAR2,
326 x_resp_to_orig_code IN VARCHAR2,
327 x_appl_loan_phase_code IN VARCHAR2,
328 x_appl_loan_phase_code_chg IN DATE,
329 x_appl_send_error_codes IN VARCHAR2,
330 x_tot_outstd_stafford IN NUMBER,
331 x_tot_outstd_plus IN NUMBER,
332 x_alt_borw_tot_debt IN NUMBER,
333 x_act_interest_rate IN NUMBER,
334 x_service_type_code IN VARCHAR2,
335 x_rev_notice_of_guarnt IN VARCHAR2,
336 x_sch_refund_amt IN NUMBER,
337 x_sch_refund_date IN DATE,
338 x_uniq_layout_vend_code IN VARCHAR2,
339 x_uniq_layout_ident_code IN VARCHAR2,
340 x_p_person_id IN NUMBER,
341 x_p_ssn_chg_date IN DATE,
345 x_p_signature_code IN VARCHAR2,
342 x_p_dob_chg_date IN DATE,
343 x_p_permt_addr_chg_date IN DATE,
344 x_p_default_status IN VARCHAR2,
346 x_p_signature_date IN DATE,
347 x_s_ssn_chg_date IN DATE,
348 x_s_dob_chg_date IN DATE,
349 x_s_permt_addr_chg_date IN DATE,
350 x_s_local_addr_chg_date IN DATE,
351 x_s_default_status IN VARCHAR2,
352 x_s_signature_code IN VARCHAR2,
353 x_mode IN VARCHAR2 DEFAULT 'R',
354 x_pnote_batch_id IN VARCHAR2,
355 x_pnote_ack_date IN DATE,
356 x_pnote_mpn_ind IN VARCHAR2,
357 x_elec_mpn_ind IN VARCHAR2,
358 x_borr_sign_ind IN VARCHAR2,
359 x_stud_sign_ind IN VARCHAR2,
360 x_borr_credit_auth_code IN VARCHAR2,
361 x_relationship_cd IN VARCHAR2 DEFAULT NULL,
362 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
363 x_cps_trans_num IN NUMBER DEFAULT NULL,
364 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
365 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
366 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
367 x_note_message IN VARCHAR2 DEFAULT NULL,
368 x_book_loan_amt IN NUMBER DEFAULT NULL,
369 x_book_loan_amt_date IN DATE DEFAULT NULL,
370 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
371 x_pymt_servicer_date IN DATE DEFAULT NULL,
372 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
373 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
374 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
375 x_requested_loan_amt IN NUMBER DEFAULT NULL,
376 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
377 x_reinstatement_amt IN NUMBER DEFAULT NULL,
378 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
379 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
380 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
381 x_fls_approved_amt IN NUMBER DEFAULT NULL,
382 x_flu_approved_amt IN NUMBER DEFAULT NULL,
383 x_flp_approved_amt IN NUMBER DEFAULT NULL,
384 x_alt_approved_amt IN NUMBER DEFAULT NULL,
385 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
386 x_override_grade_level_code IN VARCHAR2 DEFAULT NULL,
387 x_called_from IN VARCHAR2 DEFAULT NULL,
388 x_b_alien_reg_num_txt IN VARCHAR2 DEFAULT NULL,
389 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL,
390 x_acad_begin_date IN DATE DEFAULT NULL,
391 x_acad_end_date IN DATE DEFAULT NULL
392
393
394 );
395
396 PROCEDURE add_row (
397 x_rowid IN OUT NOCOPY VARCHAR2,
398 x_origination_id IN OUT NOCOPY NUMBER,
399 x_loan_id IN NUMBER,
400 x_sch_cert_date IN DATE,
401 x_orig_status_flag IN VARCHAR2,
402 x_orig_batch_id IN VARCHAR2,
403 x_orig_batch_date IN DATE,
404 x_chg_batch_id IN VARCHAR2,
405 x_orig_ack_date IN DATE,
406 x_credit_override IN VARCHAR2,
407 x_credit_decision_date IN DATE,
408 x_req_serial_loan_code IN VARCHAR2,
409 x_act_serial_loan_code IN VARCHAR2,
410 x_pnote_delivery_code IN VARCHAR2,
411 x_pnote_status IN VARCHAR2,
412 x_pnote_status_date IN DATE,
413 x_pnote_id IN VARCHAR2,
414 x_pnote_print_ind IN VARCHAR2,
415 x_pnote_accept_amt IN NUMBER,
416 x_pnote_accept_date IN DATE,
417 x_unsub_elig_for_heal IN VARCHAR2,
418 x_disclosure_print_ind IN VARCHAR2,
419 x_orig_fee_perct IN NUMBER,
420 x_borw_confirm_ind IN VARCHAR2,
421 x_borw_interest_ind IN VARCHAR2,
422 x_borw_outstd_loan_code IN VARCHAR2,
423 x_unsub_elig_for_depnt IN VARCHAR2,
424 x_guarantee_amt IN NUMBER,
425 x_guarantee_date IN DATE,
426 x_guarnt_amt_redn_code IN VARCHAR2,
427 x_guarnt_status_code IN VARCHAR2,
428 x_guarnt_status_date IN DATE,
429 x_lend_apprv_denied_code IN VARCHAR2,
430 x_lend_apprv_denied_date IN DATE,
431 x_lend_status_code IN VARCHAR2,
432 x_lend_status_date IN DATE,
433 x_guarnt_adj_ind IN VARCHAR2,
434 x_grade_level_code IN VARCHAR2,
438 x_duns_borw_lender_id IN VARCHAR2,
435 x_enrollment_code IN VARCHAR2,
436 x_anticip_compl_date IN DATE,
437 x_borw_lender_id IN VARCHAR2,
439 x_guarantor_id IN VARCHAR2,
440 x_duns_guarnt_id IN VARCHAR2,
441 x_prc_type_code IN VARCHAR2,
442 x_cl_seq_number IN NUMBER,
443 x_last_resort_lender IN VARCHAR2,
444 x_lender_id IN VARCHAR2,
445 x_duns_lender_id IN VARCHAR2,
446 x_lend_non_ed_brc_id IN VARCHAR2,
447 x_recipient_id IN VARCHAR2,
448 x_recipient_type IN VARCHAR2,
449 x_duns_recip_id IN VARCHAR2,
450 x_recip_non_ed_brc_id IN VARCHAR2,
451 x_rec_type_ind IN VARCHAR2,
452 x_cl_loan_type IN VARCHAR2,
453 x_cl_rec_status IN VARCHAR2,
454 x_cl_rec_status_last_update IN DATE,
455 x_alt_prog_type_code IN VARCHAR2,
456 x_alt_appl_ver_code IN NUMBER,
457 x_mpn_confirm_code IN VARCHAR2,
458 x_resp_to_orig_code IN VARCHAR2,
459 x_appl_loan_phase_code IN VARCHAR2,
460 x_appl_loan_phase_code_chg IN DATE,
461 x_appl_send_error_codes IN VARCHAR2,
462 x_tot_outstd_stafford IN NUMBER,
463 x_tot_outstd_plus IN NUMBER,
464 x_alt_borw_tot_debt IN NUMBER,
465 x_act_interest_rate IN NUMBER,
466 x_service_type_code IN VARCHAR2,
467 x_rev_notice_of_guarnt IN VARCHAR2,
468 x_sch_refund_amt IN NUMBER,
469 x_sch_refund_date IN DATE,
470 x_uniq_layout_vend_code IN VARCHAR2,
471 x_uniq_layout_ident_code IN VARCHAR2,
472 x_p_person_id IN NUMBER,
473 x_p_ssn_chg_date IN DATE,
474 x_p_dob_chg_date IN DATE,
475 x_p_permt_addr_chg_date IN DATE,
476 x_p_default_status IN VARCHAR2,
477 x_p_signature_code IN VARCHAR2,
478 x_p_signature_date IN DATE,
479 x_s_ssn_chg_date IN DATE,
480 x_s_dob_chg_date IN DATE,
481 x_s_permt_addr_chg_date IN DATE,
482 x_s_local_addr_chg_date IN DATE,
483 x_s_default_status IN VARCHAR2,
484 x_s_signature_code IN VARCHAR2,
485 x_mode IN VARCHAR2 DEFAULT 'R' ,
486 x_pnote_batch_id IN VARCHAR2,
487 x_pnote_ack_date IN DATE,
488 x_pnote_mpn_ind IN VARCHAR2,
489 x_elec_mpn_ind IN VARCHAR2,
490 x_borr_sign_ind IN VARCHAR2,
491 x_stud_sign_ind IN VARCHAR2,
492 x_borr_credit_auth_code IN VARCHAR2,
493 x_relationship_cd IN VARCHAR2 DEFAULT NULL,
494 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
495 x_cps_trans_num IN NUMBER DEFAULT NULL,
496 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
497 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
498 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
499 x_note_message IN VARCHAR2 DEFAULT NULL,
500 x_book_loan_amt IN NUMBER DEFAULT NULL,
501 x_book_loan_amt_date IN DATE DEFAULT NULL,
502 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
503 x_pymt_servicer_date IN DATE DEFAULT NULL,
504 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
505 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
506 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
507 x_requested_loan_amt IN NUMBER DEFAULT NULL,
508 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
509 x_reinstatement_amt IN NUMBER DEFAULT NULL,
510 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
511 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
512 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
513 x_fls_approved_amt IN NUMBER DEFAULT NULL,
514 x_flu_approved_amt IN NUMBER DEFAULT NULL,
515 x_flp_approved_amt IN NUMBER DEFAULT NULL,
516 x_alt_approved_amt IN NUMBER DEFAULT NULL,
517 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
518 x_override_grade_level_code IN VARCHAR2 DEFAULT NULL ,
519 x_b_alien_reg_num_txt IN VARCHAR2 DEFAULT NULL,
520 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL,
521 x_acad_begin_date IN DATE DEFAULT NULL,
522 x_acad_end_date IN DATE DEFAULT NULL
523
524
525 );
526
527 PROCEDURE delete_row (
528 x_rowid IN VARCHAR2
529 );
530
531 FUNCTION get_pk_for_validation (
532 x_origination_id IN NUMBER
533 ) RETURN BOOLEAN;
534
535 FUNCTION get_uk_for_validation (
536 x_loan_id IN NUMBER
537 ) RETURN BOOLEAN;
538
539 PROCEDURE get_fk_hz_parties (
540 x_party_id IN NUMBER
541 );
542
543 PROCEDURE get_fk_igf_sl_loans (
544 x_loan_id IN NUMBER
545 );
546
547 PROCEDURE get_fk_igf_sl_cl_recipient (
548 x_relationship_cd IN VARCHAR2
549 );
550
551 PROCEDURE before_dml (
552 p_action IN VARCHAR2,
553 x_rowid IN VARCHAR2 DEFAULT NULL,
554 x_origination_id IN NUMBER DEFAULT NULL,
555 x_loan_id IN NUMBER DEFAULT NULL,
556 x_sch_cert_date IN DATE DEFAULT NULL,
557 x_orig_status_flag IN VARCHAR2 DEFAULT NULL,
558 x_orig_batch_id IN VARCHAR2 DEFAULT NULL,
559 x_orig_batch_date IN DATE DEFAULT NULL,
560 x_chg_batch_id IN VARCHAR2 DEFAULT NULL,
561 x_orig_ack_date IN DATE DEFAULT NULL,
562 x_credit_override IN VARCHAR2 DEFAULT NULL,
563 x_credit_decision_date IN DATE DEFAULT NULL,
564 x_req_serial_loan_code IN VARCHAR2 DEFAULT NULL,
565 x_act_serial_loan_code IN VARCHAR2 DEFAULT NULL,
566 x_pnote_delivery_code IN VARCHAR2 DEFAULT NULL,
567 x_pnote_status IN VARCHAR2 DEFAULT NULL,
568 x_pnote_status_date IN DATE DEFAULT NULL,
569 x_pnote_id IN VARCHAR2 DEFAULT NULL,
570 x_pnote_print_ind IN VARCHAR2 DEFAULT NULL,
571 x_pnote_accept_amt IN NUMBER DEFAULT NULL,
572 x_pnote_accept_date IN DATE DEFAULT NULL,
573 x_unsub_elig_for_heal IN VARCHAR2 DEFAULT NULL,
574 x_disclosure_print_ind IN VARCHAR2 DEFAULT NULL,
575 x_orig_fee_perct IN NUMBER DEFAULT NULL,
576 x_borw_confirm_ind IN VARCHAR2 DEFAULT NULL,
577 x_borw_interest_ind IN VARCHAR2 DEFAULT NULL,
578 x_borw_outstd_loan_code IN VARCHAR2 DEFAULT NULL,
579 x_unsub_elig_for_depnt IN VARCHAR2 DEFAULT NULL,
580 x_guarantee_amt IN NUMBER DEFAULT NULL,
581 x_guarantee_date IN DATE DEFAULT NULL,
582 x_guarnt_amt_redn_code IN VARCHAR2 DEFAULT NULL,
583 x_guarnt_status_code IN VARCHAR2 DEFAULT NULL,
584 x_guarnt_status_date IN DATE DEFAULT NULL,
585 x_lend_apprv_denied_code IN VARCHAR2 DEFAULT NULL,
586 x_lend_apprv_denied_date IN DATE DEFAULT NULL,
587 x_lend_status_code IN VARCHAR2 DEFAULT NULL,
588 x_lend_status_date IN DATE DEFAULT NULL,
589 x_guarnt_adj_ind IN VARCHAR2 DEFAULT NULL,
590 x_grade_level_code IN VARCHAR2 DEFAULT NULL,
591 x_enrollment_code IN VARCHAR2 DEFAULT NULL,
592 x_anticip_compl_date IN DATE DEFAULT NULL,
593 x_borw_lender_id IN VARCHAR2 DEFAULT NULL,
594 x_duns_borw_lender_id IN VARCHAR2 DEFAULT NULL,
595 x_guarantor_id IN VARCHAR2 DEFAULT NULL,
596 x_duns_guarnt_id IN VARCHAR2 DEFAULT NULL,
597 x_prc_type_code IN VARCHAR2 DEFAULT NULL,
598 x_cl_seq_number IN NUMBER DEFAULT NULL,
599 x_last_resort_lender IN VARCHAR2 DEFAULT NULL,
600 x_lender_id IN VARCHAR2 DEFAULT NULL,
601 x_duns_lender_id IN VARCHAR2 DEFAULT NULL,
602 x_lend_non_ed_brc_id IN VARCHAR2 DEFAULT NULL,
603 x_recipient_id IN VARCHAR2 DEFAULT NULL,
604 x_recipient_type IN VARCHAR2 DEFAULT NULL,
605 x_duns_recip_id IN VARCHAR2 DEFAULT NULL,
606 x_recip_non_ed_brc_id IN VARCHAR2 DEFAULT NULL,
607 x_rec_type_ind IN VARCHAR2 DEFAULT NULL,
608 x_cl_loan_type IN VARCHAR2 DEFAULT NULL,
609 x_cl_rec_status IN VARCHAR2 DEFAULT NULL,
610 x_cl_rec_status_last_update IN DATE DEFAULT NULL,
611 x_alt_prog_type_code IN VARCHAR2 DEFAULT NULL,
612 x_alt_appl_ver_code IN NUMBER DEFAULT NULL,
613 x_mpn_confirm_code IN VARCHAR2 DEFAULT NULL,
614 x_resp_to_orig_code IN VARCHAR2 DEFAULT NULL,
615 x_appl_loan_phase_code IN VARCHAR2 DEFAULT NULL,
616 x_appl_loan_phase_code_chg IN DATE DEFAULT NULL,
617 x_appl_send_error_codes IN VARCHAR2 DEFAULT NULL,
618 x_tot_outstd_stafford IN NUMBER DEFAULT NULL,
619 x_tot_outstd_plus IN NUMBER DEFAULT NULL,
620 x_alt_borw_tot_debt IN NUMBER DEFAULT NULL,
621 x_act_interest_rate IN NUMBER DEFAULT NULL,
622 x_service_type_code IN VARCHAR2 DEFAULT NULL,
623 x_rev_notice_of_guarnt IN VARCHAR2 DEFAULT NULL,
624 x_sch_refund_amt IN NUMBER DEFAULT NULL,
625 x_sch_refund_date IN DATE DEFAULT NULL,
626 x_uniq_layout_vend_code IN VARCHAR2 DEFAULT NULL,
627 x_uniq_layout_ident_code IN VARCHAR2 DEFAULT NULL,
628 x_p_person_id IN NUMBER DEFAULT NULL,
629 x_p_ssn_chg_date IN DATE DEFAULT NULL,
630 x_p_dob_chg_date IN DATE DEFAULT NULL,
631 x_p_permt_addr_chg_date IN DATE DEFAULT NULL,
632 x_p_default_status IN VARCHAR2 DEFAULT NULL,
633 x_p_signature_code IN VARCHAR2 DEFAULT NULL,
634 x_p_signature_date IN DATE DEFAULT NULL,
635 x_s_ssn_chg_date IN DATE DEFAULT NULL,
636 x_s_dob_chg_date IN DATE DEFAULT NULL,
637 x_s_permt_addr_chg_date IN DATE DEFAULT NULL,
638 x_s_local_addr_chg_date IN DATE DEFAULT NULL,
639 x_s_default_status IN VARCHAR2 DEFAULT NULL,
640 x_s_signature_code IN VARCHAR2 DEFAULT NULL,
641 x_creation_date IN DATE DEFAULT NULL,
642 x_created_by IN NUMBER DEFAULT NULL,
643 x_last_update_date IN DATE DEFAULT NULL,
644 x_last_updated_by IN NUMBER DEFAULT NULL,
645 x_last_update_login IN NUMBER DEFAULT NULL,
646 x_pnote_batch_id IN VARCHAR2 DEFAULT NULL,
647 x_pnote_ack_date IN DATE DEFAULT NULL,
648 x_pnote_mpn_ind IN VARCHAR2 DEFAULT NULL,
649 x_elec_mpn_ind IN VARCHAR2 DEFAULT NULL,
650 x_borr_sign_ind IN VARCHAR2 DEFAULT NULL,
651 x_stud_sign_ind IN VARCHAR2 DEFAULT NULL,
652 x_borr_credit_auth_code IN VARCHAR2 DEFAULT NULL,
653 x_relationship_cd IN VARCHAR2 DEFAULT NULL,
654 x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
655 x_cps_trans_num IN NUMBER DEFAULT NULL,
656 x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
657 x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
658 x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
659 x_note_message IN VARCHAR2 DEFAULT NULL,
660 x_book_loan_amt IN NUMBER DEFAULT NULL,
661 x_book_loan_amt_date IN DATE DEFAULT NULL,
662 x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
663 x_pymt_servicer_date IN DATE DEFAULT NULL,
664 x_external_loan_id_txt IN VARCHAR2 DEFAULT NULL,
665 x_deferment_request_code IN VARCHAR2 DEFAULT NULL,
666 x_eft_authorization_code IN VARCHAR2 DEFAULT NULL,
667 x_requested_loan_amt IN NUMBER DEFAULT NULL,
668 x_actual_record_type_code IN VARCHAR2 DEFAULT NULL,
669 x_reinstatement_amt IN NUMBER DEFAULT NULL,
670 x_school_use_txt IN VARCHAR2 DEFAULT NULL,
671 x_lender_use_txt IN VARCHAR2 DEFAULT NULL,
672 x_guarantor_use_txt IN VARCHAR2 DEFAULT NULL,
673 x_fls_approved_amt IN NUMBER DEFAULT NULL,
674 x_flu_approved_amt IN NUMBER DEFAULT NULL,
675 x_flp_approved_amt IN NUMBER DEFAULT NULL,
676 x_alt_approved_amt IN NUMBER DEFAULT NULL,
677 x_loan_app_form_code IN VARCHAR2 DEFAULT NULL,
678 x_override_grade_level_code IN VARCHAR2 DEFAULT NULL,
679 x_b_alien_reg_num_txt IN VARCHAR2 DEFAULT NULL,
680 x_esign_src_typ_cd IN VARCHAR2 DEFAULT NULL,
681 x_acad_begin_date IN DATE DEFAULT NULL,
682 x_acad_end_date IN DATE DEFAULT NULL
683 );
684
685 END igf_sl_lor_pkg;