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