1 PACKAGE igf_ap_nslds_data_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGFAI10S.pls 120.0 2005/06/01 13:09:15 appldev noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_nslds_id IN OUT NOCOPY NUMBER,
7 x_isir_id IN NUMBER,
8 x_base_id IN NUMBER,
9 x_nslds_transaction_num IN NUMBER,
10 x_nslds_database_results_f IN VARCHAR2,
11 x_nslds_f IN VARCHAR2,
12 x_nslds_pell_overpay_f IN VARCHAR2,
13 x_nslds_pell_overpay_contact IN VARCHAR2,
14 x_nslds_seog_overpay_f IN VARCHAR2,
15 x_nslds_seog_overpay_contact IN VARCHAR2,
16 x_nslds_perkins_overpay_f IN VARCHAR2,
17 x_nslds_perkins_overpay_cntct IN VARCHAR2,
18 x_nslds_defaulted_loan_f IN VARCHAR2,
19 x_nslds_dischged_loan_chng_f IN VARCHAR2,
20 x_nslds_satis_repay_f IN VARCHAR2,
21 x_nslds_act_bankruptcy_f IN VARCHAR2,
22 x_nslds_agg_subsz_out_prin_bal IN NUMBER,
23 x_nslds_agg_unsbz_out_prin_bal IN NUMBER,
24 x_nslds_agg_comb_out_prin_bal IN NUMBER,
25 x_nslds_agg_cons_out_prin_bal IN NUMBER,
26 x_nslds_agg_subsz_pend_dismt IN NUMBER,
27 x_nslds_agg_unsbz_pend_dismt IN NUMBER,
28 x_nslds_agg_comb_pend_dismt IN NUMBER,
29 x_nslds_agg_subsz_total IN NUMBER,
30 x_nslds_agg_unsbz_total IN NUMBER,
31 x_nslds_agg_comb_total IN NUMBER,
32 x_nslds_agg_consd_total IN NUMBER,
33 x_nslds_perkins_out_bal IN NUMBER,
34 x_nslds_perkins_cur_yr_dismnt IN NUMBER,
35 x_nslds_default_loan_chng_f IN VARCHAR2,
36 x_nslds_discharged_loan_f IN VARCHAR2,
37 x_nslds_satis_repay_chng_f IN VARCHAR2,
38 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
39 x_nslds_overpay_chng_f IN VARCHAR2,
40 x_nslds_agg_loan_chng_f IN VARCHAR2,
41 x_nslds_perkins_loan_chng_f IN VARCHAR2,
42 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
43 x_nslds_addtnl_pell_f IN VARCHAR2,
44 x_nslds_addtnl_loan_f IN VARCHAR2,
45 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
46 x_nslds_pell_seq_num_1 IN NUMBER,
47 x_nslds_pell_verify_f_1 IN VARCHAR2,
48 x_nslds_pell_efc_1 IN NUMBER,
49 x_nslds_pell_school_code_1 IN NUMBER,
50 x_nslds_pell_transcn_num_1 IN NUMBER,
51 x_nslds_pell_last_updt_dt_1 IN DATE,
52 x_nslds_pell_scheduled_amt_1 IN NUMBER,
53 x_nslds_pell_amt_paid_todt_1 IN NUMBER,
54 x_nslds_pell_remng_amt_1 IN NUMBER,
55 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER,
56 x_nslds_pell_award_amt_1 IN NUMBER,
57 x_nslds_pell_seq_num_2 IN NUMBER,
58 x_nslds_pell_verify_f_2 IN VARCHAR2,
59 x_nslds_pell_efc_2 IN NUMBER,
60 x_nslds_pell_school_code_2 IN NUMBER,
61 x_nslds_pell_transcn_num_2 IN NUMBER,
62 x_nslds_pell_last_updt_dt_2 IN DATE,
63 x_nslds_pell_scheduled_amt_2 IN NUMBER,
64 x_nslds_pell_amt_paid_todt_2 IN NUMBER,
65 x_nslds_pell_remng_amt_2 IN NUMBER,
66 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER,
67 x_nslds_pell_award_amt_2 IN NUMBER,
68 x_nslds_pell_seq_num_3 IN NUMBER,
69 x_nslds_pell_verify_f_3 IN VARCHAR2,
70 x_nslds_pell_efc_3 IN NUMBER,
71 x_nslds_pell_school_code_3 IN NUMBER,
72 x_nslds_pell_transcn_num_3 IN NUMBER,
73 x_nslds_pell_last_updt_dt_3 IN DATE,
74 x_nslds_pell_scheduled_amt_3 IN NUMBER,
75 x_nslds_pell_amt_paid_todt_3 IN NUMBER,
76 x_nslds_pell_remng_amt_3 IN NUMBER,
77 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER,
78 x_nslds_pell_award_amt_3 IN NUMBER,
79 x_nslds_loan_seq_num_1 IN NUMBER,
80 x_nslds_loan_type_code_1 IN VARCHAR2,
81 x_nslds_loan_chng_f_1 IN VARCHAR2,
82 x_nslds_loan_prog_code_1 IN VARCHAR2,
83 x_nslds_loan_net_amnt_1 IN NUMBER,
84 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
85 x_nslds_loan_cur_st_date_1 IN DATE,
86 x_nslds_loan_agg_pr_bal_1 IN NUMBER,
87 x_nslds_loan_out_pr_bal_dt_1 IN DATE,
88 x_nslds_loan_begin_dt_1 IN DATE,
89 x_nslds_loan_end_dt_1 IN DATE,
90 x_nslds_loan_ga_code_1 IN VARCHAR2,
91 x_nslds_loan_cont_type_1 IN VARCHAR2,
92 x_nslds_loan_schol_code_1 IN VARCHAR2,
93 x_nslds_loan_cont_code_1 IN VARCHAR2,
94 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
95 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
96 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
97 x_nslds_loan_seq_num_2 IN NUMBER,
98 x_nslds_loan_type_code_2 IN VARCHAR2,
99 x_nslds_loan_chng_f_2 IN VARCHAR2,
100 x_nslds_loan_prog_code_2 IN VARCHAR2,
101 x_nslds_loan_net_amnt_2 IN NUMBER,
102 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
103 x_nslds_loan_cur_st_date_2 IN DATE,
104 x_nslds_loan_agg_pr_bal_2 IN NUMBER,
105 x_nslds_loan_out_pr_bal_dt_2 IN DATE,
106 x_nslds_loan_begin_dt_2 IN DATE,
107 x_nslds_loan_end_dt_2 IN DATE,
108 x_nslds_loan_ga_code_2 IN VARCHAR2,
109 x_nslds_loan_cont_type_2 IN VARCHAR2,
110 x_nslds_loan_schol_code_2 IN VARCHAR2,
111 x_nslds_loan_cont_code_2 IN VARCHAR2,
112 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
113 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
114 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
115 x_nslds_loan_seq_num_3 IN NUMBER,
116 x_nslds_loan_type_code_3 IN VARCHAR2,
117 x_nslds_loan_chng_f_3 IN VARCHAR2,
118 x_nslds_loan_prog_code_3 IN VARCHAR2,
119 x_nslds_loan_net_amnt_3 IN NUMBER,
120 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
121 x_nslds_loan_cur_st_date_3 IN DATE,
122 x_nslds_loan_agg_pr_bal_3 IN NUMBER,
123 x_nslds_loan_out_pr_bal_dt_3 IN DATE,
124 x_nslds_loan_begin_dt_3 IN DATE,
125 x_nslds_loan_end_dt_3 IN DATE,
126 x_nslds_loan_ga_code_3 IN VARCHAR2,
127 x_nslds_loan_cont_type_3 IN VARCHAR2,
128 x_nslds_loan_schol_code_3 IN VARCHAR2,
129 x_nslds_loan_cont_code_3 IN VARCHAR2,
130 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
131 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
132 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
133 x_nslds_loan_seq_num_4 IN NUMBER,
134 x_nslds_loan_type_code_4 IN VARCHAR2,
135 x_nslds_loan_chng_f_4 IN VARCHAR2,
136 x_nslds_loan_prog_code_4 IN VARCHAR2,
137 x_nslds_loan_net_amnt_4 IN NUMBER,
138 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
139 x_nslds_loan_cur_st_date_4 IN DATE,
140 x_nslds_loan_agg_pr_bal_4 IN NUMBER,
141 x_nslds_loan_out_pr_bal_dt_4 IN DATE,
142 x_nslds_loan_begin_dt_4 IN DATE,
143 x_nslds_loan_end_dt_4 IN DATE,
144 x_nslds_loan_ga_code_4 IN VARCHAR2,
145 x_nslds_loan_cont_type_4 IN VARCHAR2,
146 x_nslds_loan_schol_code_4 IN VARCHAR2,
147 x_nslds_loan_cont_code_4 IN VARCHAR2,
148 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
149 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
150 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
151 x_nslds_loan_seq_num_5 IN NUMBER,
152 x_nslds_loan_type_code_5 IN VARCHAR2,
153 x_nslds_loan_chng_f_5 IN VARCHAR2,
154 x_nslds_loan_prog_code_5 IN VARCHAR2,
155 x_nslds_loan_net_amnt_5 IN NUMBER,
156 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
157 x_nslds_loan_cur_st_date_5 IN DATE,
158 x_nslds_loan_agg_pr_bal_5 IN NUMBER,
159 x_nslds_loan_out_pr_bal_dt_5 IN DATE,
160 x_nslds_loan_begin_dt_5 IN DATE,
161 x_nslds_loan_end_dt_5 IN DATE,
162 x_nslds_loan_ga_code_5 IN VARCHAR2,
163 x_nslds_loan_cont_type_5 IN VARCHAR2,
164 x_nslds_loan_schol_code_5 IN VARCHAR2,
165 x_nslds_loan_cont_code_5 IN VARCHAR2,
166 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
167 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
168 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
169 x_nslds_loan_seq_num_6 IN NUMBER,
170 x_nslds_loan_type_code_6 IN VARCHAR2,
171 x_nslds_loan_chng_f_6 IN VARCHAR2,
172 x_nslds_loan_prog_code_6 IN VARCHAR2,
173 x_nslds_loan_net_amnt_6 IN NUMBER,
174 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
175 x_nslds_loan_cur_st_date_6 IN DATE,
176 x_nslds_loan_agg_pr_bal_6 IN NUMBER,
177 x_nslds_loan_out_pr_bal_dt_6 IN DATE,
178 x_nslds_loan_begin_dt_6 IN DATE,
179 x_nslds_loan_end_dt_6 IN DATE,
180 x_nslds_loan_ga_code_6 IN VARCHAR2,
181 x_nslds_loan_cont_type_6 IN VARCHAR2,
182 x_nslds_loan_schol_code_6 IN VARCHAR2,
183 x_nslds_loan_cont_code_6 IN VARCHAR2,
184 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
185 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
186 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
187 x_nslds_loan_last_d_amt_1 IN NUMBER DEFAULT NULL,
188 x_nslds_loan_last_d_date_1 IN DATE DEFAULT NULL,
189 x_nslds_loan_last_d_amt_2 IN NUMBER DEFAULT NULL,
190 x_nslds_loan_last_d_date_2 IN DATE DEFAULT NULL,
191 x_nslds_loan_last_d_amt_3 IN NUMBER DEFAULT NULL,
192 x_nslds_loan_last_d_date_3 IN DATE DEFAULT NULL,
193 x_nslds_loan_last_d_amt_4 IN NUMBER DEFAULT NULL,
194 x_nslds_loan_last_d_date_4 IN DATE DEFAULT NULL,
195 x_nslds_loan_last_d_amt_5 IN NUMBER DEFAULT NULL,
196 x_nslds_loan_last_d_date_5 IN DATE DEFAULT NULL,
197 x_nslds_loan_last_d_amt_6 IN NUMBER DEFAULT NULL,
198 x_nslds_loan_last_d_date_6 IN DATE DEFAULT NULL,
199 x_dlp_master_prom_note_flag IN VARCHAR2 DEFAULT NULL,
200 x_mode IN VARCHAR2 DEFAULT 'R' ,
201 x_subsidized_loan_limit_type IN VARCHAR2 DEFAULT NULL,
202 x_combined_loan_limit_type IN VARCHAR2 DEFAULT NULL,
203 x_transaction_num_txt IN VARCHAR2 DEFAULT NULL
204 );
205
206 PROCEDURE lock_row (
207 x_rowid IN VARCHAR2,
208 x_nslds_id IN NUMBER,
209 x_isir_id IN NUMBER,
210 x_base_id IN NUMBER,
211 x_nslds_transaction_num IN NUMBER,
212 x_nslds_database_results_f IN VARCHAR2,
213 x_nslds_f IN VARCHAR2,
214 x_nslds_pell_overpay_f IN VARCHAR2,
215 x_nslds_pell_overpay_contact IN VARCHAR2,
216 x_nslds_seog_overpay_f IN VARCHAR2,
217 x_nslds_seog_overpay_contact IN VARCHAR2,
218 x_nslds_perkins_overpay_f IN VARCHAR2,
219 x_nslds_perkins_overpay_cntct IN VARCHAR2,
220 x_nslds_defaulted_loan_f IN VARCHAR2,
221 x_nslds_dischged_loan_chng_f IN VARCHAR2,
222 x_nslds_satis_repay_f IN VARCHAR2,
223 x_nslds_act_bankruptcy_f IN VARCHAR2,
224 x_nslds_agg_subsz_out_prin_bal IN NUMBER,
225 x_nslds_agg_unsbz_out_prin_bal IN NUMBER,
226 x_nslds_agg_comb_out_prin_bal IN NUMBER,
227 x_nslds_agg_cons_out_prin_bal IN NUMBER,
228 x_nslds_agg_subsz_pend_dismt IN NUMBER,
229 x_nslds_agg_unsbz_pend_dismt IN NUMBER,
230 x_nslds_agg_comb_pend_dismt IN NUMBER,
231 x_nslds_agg_subsz_total IN NUMBER,
232 x_nslds_agg_unsbz_total IN NUMBER,
233 x_nslds_agg_comb_total IN NUMBER,
234 x_nslds_agg_consd_total IN NUMBER,
235 x_nslds_perkins_out_bal IN NUMBER,
236 x_nslds_perkins_cur_yr_dismnt IN NUMBER,
237 x_nslds_default_loan_chng_f IN VARCHAR2,
238 x_nslds_discharged_loan_f IN VARCHAR2,
239 x_nslds_satis_repay_chng_f IN VARCHAR2,
240 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
241 x_nslds_overpay_chng_f IN VARCHAR2,
242 x_nslds_agg_loan_chng_f IN VARCHAR2,
243 x_nslds_perkins_loan_chng_f IN VARCHAR2,
244 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
245 x_nslds_addtnl_pell_f IN VARCHAR2,
246 x_nslds_addtnl_loan_f IN VARCHAR2,
247 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
248 x_nslds_pell_seq_num_1 IN NUMBER,
249 x_nslds_pell_verify_f_1 IN VARCHAR2,
250 x_nslds_pell_efc_1 IN NUMBER,
251 x_nslds_pell_school_code_1 IN NUMBER,
252 x_nslds_pell_transcn_num_1 IN NUMBER,
253 x_nslds_pell_last_updt_dt_1 IN DATE,
254 x_nslds_pell_scheduled_amt_1 IN NUMBER,
255 x_nslds_pell_amt_paid_todt_1 IN NUMBER,
256 x_nslds_pell_remng_amt_1 IN NUMBER,
257 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER,
258 x_nslds_pell_award_amt_1 IN NUMBER,
259 x_nslds_pell_seq_num_2 IN NUMBER,
260 x_nslds_pell_verify_f_2 IN VARCHAR2,
261 x_nslds_pell_efc_2 IN NUMBER,
262 x_nslds_pell_school_code_2 IN NUMBER,
263 x_nslds_pell_transcn_num_2 IN NUMBER,
264 x_nslds_pell_last_updt_dt_2 IN DATE,
265 x_nslds_pell_scheduled_amt_2 IN NUMBER,
266 x_nslds_pell_amt_paid_todt_2 IN NUMBER,
267 x_nslds_pell_remng_amt_2 IN NUMBER,
268 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER,
269 x_nslds_pell_award_amt_2 IN NUMBER,
270 x_nslds_pell_seq_num_3 IN NUMBER,
271 x_nslds_pell_verify_f_3 IN VARCHAR2,
272 x_nslds_pell_efc_3 IN NUMBER,
273 x_nslds_pell_school_code_3 IN NUMBER,
274 x_nslds_pell_transcn_num_3 IN NUMBER,
275 x_nslds_pell_last_updt_dt_3 IN DATE,
276 x_nslds_pell_scheduled_amt_3 IN NUMBER,
277 x_nslds_pell_amt_paid_todt_3 IN NUMBER,
278 x_nslds_pell_remng_amt_3 IN NUMBER,
279 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER,
280 x_nslds_pell_award_amt_3 IN NUMBER,
281 x_nslds_loan_seq_num_1 IN NUMBER,
282 x_nslds_loan_type_code_1 IN VARCHAR2,
283 x_nslds_loan_chng_f_1 IN VARCHAR2,
284 x_nslds_loan_prog_code_1 IN VARCHAR2,
285 x_nslds_loan_net_amnt_1 IN NUMBER,
286 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
287 x_nslds_loan_cur_st_date_1 IN DATE,
288 x_nslds_loan_agg_pr_bal_1 IN NUMBER,
289 x_nslds_loan_out_pr_bal_dt_1 IN DATE,
290 x_nslds_loan_begin_dt_1 IN DATE,
291 x_nslds_loan_end_dt_1 IN DATE,
295 x_nslds_loan_cont_code_1 IN VARCHAR2,
292 x_nslds_loan_ga_code_1 IN VARCHAR2,
293 x_nslds_loan_cont_type_1 IN VARCHAR2,
294 x_nslds_loan_schol_code_1 IN VARCHAR2,
296 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
297 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
298 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
299 x_nslds_loan_seq_num_2 IN NUMBER,
300 x_nslds_loan_type_code_2 IN VARCHAR2,
301 x_nslds_loan_chng_f_2 IN VARCHAR2,
302 x_nslds_loan_prog_code_2 IN VARCHAR2,
303 x_nslds_loan_net_amnt_2 IN NUMBER,
304 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
305 x_nslds_loan_cur_st_date_2 IN DATE,
306 x_nslds_loan_agg_pr_bal_2 IN NUMBER,
307 x_nslds_loan_out_pr_bal_dt_2 IN DATE,
308 x_nslds_loan_begin_dt_2 IN DATE,
309 x_nslds_loan_end_dt_2 IN DATE,
310 x_nslds_loan_ga_code_2 IN VARCHAR2,
311 x_nslds_loan_cont_type_2 IN VARCHAR2,
312 x_nslds_loan_schol_code_2 IN VARCHAR2,
313 x_nslds_loan_cont_code_2 IN VARCHAR2,
314 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
315 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
316 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
317 x_nslds_loan_seq_num_3 IN NUMBER,
318 x_nslds_loan_type_code_3 IN VARCHAR2,
319 x_nslds_loan_chng_f_3 IN VARCHAR2,
320 x_nslds_loan_prog_code_3 IN VARCHAR2,
321 x_nslds_loan_net_amnt_3 IN NUMBER,
322 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
323 x_nslds_loan_cur_st_date_3 IN DATE,
324 x_nslds_loan_agg_pr_bal_3 IN NUMBER,
325 x_nslds_loan_out_pr_bal_dt_3 IN DATE,
326 x_nslds_loan_begin_dt_3 IN DATE,
327 x_nslds_loan_end_dt_3 IN DATE,
328 x_nslds_loan_ga_code_3 IN VARCHAR2,
329 x_nslds_loan_cont_type_3 IN VARCHAR2,
330 x_nslds_loan_schol_code_3 IN VARCHAR2,
331 x_nslds_loan_cont_code_3 IN VARCHAR2,
332 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
333 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
334 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
335 x_nslds_loan_seq_num_4 IN NUMBER,
336 x_nslds_loan_type_code_4 IN VARCHAR2,
337 x_nslds_loan_chng_f_4 IN VARCHAR2,
338 x_nslds_loan_prog_code_4 IN VARCHAR2,
339 x_nslds_loan_net_amnt_4 IN NUMBER,
340 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
341 x_nslds_loan_cur_st_date_4 IN DATE,
342 x_nslds_loan_agg_pr_bal_4 IN NUMBER,
343 x_nslds_loan_out_pr_bal_dt_4 IN DATE,
344 x_nslds_loan_begin_dt_4 IN DATE,
345 x_nslds_loan_end_dt_4 IN DATE,
346 x_nslds_loan_ga_code_4 IN VARCHAR2,
347 x_nslds_loan_cont_type_4 IN VARCHAR2,
348 x_nslds_loan_schol_code_4 IN VARCHAR2,
349 x_nslds_loan_cont_code_4 IN VARCHAR2,
350 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
351 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
352 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
353 x_nslds_loan_seq_num_5 IN NUMBER,
354 x_nslds_loan_type_code_5 IN VARCHAR2,
355 x_nslds_loan_chng_f_5 IN VARCHAR2,
356 x_nslds_loan_prog_code_5 IN VARCHAR2,
357 x_nslds_loan_net_amnt_5 IN NUMBER,
358 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
359 x_nslds_loan_cur_st_date_5 IN DATE,
360 x_nslds_loan_agg_pr_bal_5 IN NUMBER,
361 x_nslds_loan_out_pr_bal_dt_5 IN DATE,
362 x_nslds_loan_begin_dt_5 IN DATE,
363 x_nslds_loan_end_dt_5 IN DATE,
364 x_nslds_loan_ga_code_5 IN VARCHAR2,
365 x_nslds_loan_cont_type_5 IN VARCHAR2,
366 x_nslds_loan_schol_code_5 IN VARCHAR2,
367 x_nslds_loan_cont_code_5 IN VARCHAR2,
368 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
369 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
370 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
371 x_nslds_loan_seq_num_6 IN NUMBER,
372 x_nslds_loan_type_code_6 IN VARCHAR2,
373 x_nslds_loan_chng_f_6 IN VARCHAR2,
374 x_nslds_loan_prog_code_6 IN VARCHAR2,
375 x_nslds_loan_net_amnt_6 IN NUMBER,
376 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
377 x_nslds_loan_cur_st_date_6 IN DATE,
378 x_nslds_loan_agg_pr_bal_6 IN NUMBER,
379 x_nslds_loan_out_pr_bal_dt_6 IN DATE,
380 x_nslds_loan_begin_dt_6 IN DATE,
381 x_nslds_loan_end_dt_6 IN DATE,
382 x_nslds_loan_ga_code_6 IN VARCHAR2,
383 x_nslds_loan_cont_type_6 IN VARCHAR2,
384 x_nslds_loan_schol_code_6 IN VARCHAR2,
385 x_nslds_loan_cont_code_6 IN VARCHAR2,
386 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
387 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
391 x_nslds_loan_last_d_amt_2 IN NUMBER DEFAULT NULL,
388 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
389 x_nslds_loan_last_d_amt_1 IN NUMBER DEFAULT NULL,
390 x_nslds_loan_last_d_date_1 IN DATE DEFAULT NULL,
392 x_nslds_loan_last_d_date_2 IN DATE DEFAULT NULL,
393 x_nslds_loan_last_d_amt_3 IN NUMBER DEFAULT NULL,
394 x_nslds_loan_last_d_date_3 IN DATE DEFAULT NULL,
395 x_nslds_loan_last_d_amt_4 IN NUMBER DEFAULT NULL,
396 x_nslds_loan_last_d_date_4 IN DATE DEFAULT NULL,
397 x_nslds_loan_last_d_amt_5 IN NUMBER DEFAULT NULL,
398 x_nslds_loan_last_d_date_5 IN DATE DEFAULT NULL,
399 x_nslds_loan_last_d_amt_6 IN NUMBER DEFAULT NULL,
400 x_nslds_loan_last_d_date_6 IN DATE DEFAULT NULL,
401 x_dlp_master_prom_note_flag IN VARCHAR2 DEFAULT NULL,
402 x_subsidized_loan_limit_type IN VARCHAR2 DEFAULT NULL,
403 x_combined_loan_limit_type IN VARCHAR2 DEFAULT NULL,
404 x_transaction_num_txt IN VARCHAR2 DEFAULT NULL
405 );
406
407 PROCEDURE update_row (
408 x_rowid IN VARCHAR2,
409 x_nslds_id IN NUMBER,
410 x_isir_id IN NUMBER,
411 x_base_id IN NUMBER,
412 x_nslds_transaction_num IN NUMBER,
413 x_nslds_database_results_f IN VARCHAR2,
414 x_nslds_f IN VARCHAR2,
415 x_nslds_pell_overpay_f IN VARCHAR2,
416 x_nslds_pell_overpay_contact IN VARCHAR2,
417 x_nslds_seog_overpay_f IN VARCHAR2,
418 x_nslds_seog_overpay_contact IN VARCHAR2,
419 x_nslds_perkins_overpay_f IN VARCHAR2,
420 x_nslds_perkins_overpay_cntct IN VARCHAR2,
421 x_nslds_defaulted_loan_f IN VARCHAR2,
422 x_nslds_dischged_loan_chng_f IN VARCHAR2,
423 x_nslds_satis_repay_f IN VARCHAR2,
424 x_nslds_act_bankruptcy_f IN VARCHAR2,
425 x_nslds_agg_subsz_out_prin_bal IN NUMBER,
426 x_nslds_agg_unsbz_out_prin_bal IN NUMBER,
427 x_nslds_agg_comb_out_prin_bal IN NUMBER,
428 x_nslds_agg_cons_out_prin_bal IN NUMBER,
429 x_nslds_agg_subsz_pend_dismt IN NUMBER,
430 x_nslds_agg_unsbz_pend_dismt IN NUMBER,
431 x_nslds_agg_comb_pend_dismt IN NUMBER,
432 x_nslds_agg_subsz_total IN NUMBER,
433 x_nslds_agg_unsbz_total IN NUMBER,
434 x_nslds_agg_comb_total IN NUMBER,
435 x_nslds_agg_consd_total IN NUMBER,
436 x_nslds_perkins_out_bal IN NUMBER,
437 x_nslds_perkins_cur_yr_dismnt IN NUMBER,
438 x_nslds_default_loan_chng_f IN VARCHAR2,
439 x_nslds_discharged_loan_f IN VARCHAR2,
440 x_nslds_satis_repay_chng_f IN VARCHAR2,
441 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
442 x_nslds_overpay_chng_f IN VARCHAR2,
443 x_nslds_agg_loan_chng_f IN VARCHAR2,
444 x_nslds_perkins_loan_chng_f IN VARCHAR2,
445 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
446 x_nslds_addtnl_pell_f IN VARCHAR2,
447 x_nslds_addtnl_loan_f IN VARCHAR2,
448 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
449 x_nslds_pell_seq_num_1 IN NUMBER,
450 x_nslds_pell_verify_f_1 IN VARCHAR2,
451 x_nslds_pell_efc_1 IN NUMBER,
452 x_nslds_pell_school_code_1 IN NUMBER,
453 x_nslds_pell_transcn_num_1 IN NUMBER,
454 x_nslds_pell_last_updt_dt_1 IN DATE,
455 x_nslds_pell_scheduled_amt_1 IN NUMBER,
456 x_nslds_pell_amt_paid_todt_1 IN NUMBER,
457 x_nslds_pell_remng_amt_1 IN NUMBER,
458 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER,
459 x_nslds_pell_award_amt_1 IN NUMBER,
460 x_nslds_pell_seq_num_2 IN NUMBER,
461 x_nslds_pell_verify_f_2 IN VARCHAR2,
462 x_nslds_pell_efc_2 IN NUMBER,
463 x_nslds_pell_school_code_2 IN NUMBER,
464 x_nslds_pell_transcn_num_2 IN NUMBER,
465 x_nslds_pell_last_updt_dt_2 IN DATE,
466 x_nslds_pell_scheduled_amt_2 IN NUMBER,
467 x_nslds_pell_amt_paid_todt_2 IN NUMBER,
468 x_nslds_pell_remng_amt_2 IN NUMBER,
469 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER,
470 x_nslds_pell_award_amt_2 IN NUMBER,
471 x_nslds_pell_seq_num_3 IN NUMBER,
472 x_nslds_pell_verify_f_3 IN VARCHAR2,
473 x_nslds_pell_efc_3 IN NUMBER,
474 x_nslds_pell_school_code_3 IN NUMBER,
475 x_nslds_pell_transcn_num_3 IN NUMBER,
476 x_nslds_pell_last_updt_dt_3 IN DATE,
477 x_nslds_pell_scheduled_amt_3 IN NUMBER,
478 x_nslds_pell_amt_paid_todt_3 IN NUMBER,
479 x_nslds_pell_remng_amt_3 IN NUMBER,
480 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER,
481 x_nslds_pell_award_amt_3 IN NUMBER,
482 x_nslds_loan_seq_num_1 IN NUMBER,
486 x_nslds_loan_net_amnt_1 IN NUMBER,
483 x_nslds_loan_type_code_1 IN VARCHAR2,
484 x_nslds_loan_chng_f_1 IN VARCHAR2,
485 x_nslds_loan_prog_code_1 IN VARCHAR2,
487 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
488 x_nslds_loan_cur_st_date_1 IN DATE,
489 x_nslds_loan_agg_pr_bal_1 IN NUMBER,
490 x_nslds_loan_out_pr_bal_dt_1 IN DATE,
491 x_nslds_loan_begin_dt_1 IN DATE,
492 x_nslds_loan_end_dt_1 IN DATE,
493 x_nslds_loan_ga_code_1 IN VARCHAR2,
494 x_nslds_loan_cont_type_1 IN VARCHAR2,
495 x_nslds_loan_schol_code_1 IN VARCHAR2,
496 x_nslds_loan_cont_code_1 IN VARCHAR2,
497 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
498 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
499 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
500 x_nslds_loan_seq_num_2 IN NUMBER,
501 x_nslds_loan_type_code_2 IN VARCHAR2,
502 x_nslds_loan_chng_f_2 IN VARCHAR2,
503 x_nslds_loan_prog_code_2 IN VARCHAR2,
504 x_nslds_loan_net_amnt_2 IN NUMBER,
505 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
506 x_nslds_loan_cur_st_date_2 IN DATE,
507 x_nslds_loan_agg_pr_bal_2 IN NUMBER,
508 x_nslds_loan_out_pr_bal_dt_2 IN DATE,
509 x_nslds_loan_begin_dt_2 IN DATE,
510 x_nslds_loan_end_dt_2 IN DATE,
511 x_nslds_loan_ga_code_2 IN VARCHAR2,
512 x_nslds_loan_cont_type_2 IN VARCHAR2,
513 x_nslds_loan_schol_code_2 IN VARCHAR2,
514 x_nslds_loan_cont_code_2 IN VARCHAR2,
515 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
516 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
517 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
518 x_nslds_loan_seq_num_3 IN NUMBER,
519 x_nslds_loan_type_code_3 IN VARCHAR2,
520 x_nslds_loan_chng_f_3 IN VARCHAR2,
521 x_nslds_loan_prog_code_3 IN VARCHAR2,
522 x_nslds_loan_net_amnt_3 IN NUMBER,
523 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
524 x_nslds_loan_cur_st_date_3 IN DATE,
525 x_nslds_loan_agg_pr_bal_3 IN NUMBER,
526 x_nslds_loan_out_pr_bal_dt_3 IN DATE,
527 x_nslds_loan_begin_dt_3 IN DATE,
528 x_nslds_loan_end_dt_3 IN DATE,
529 x_nslds_loan_ga_code_3 IN VARCHAR2,
530 x_nslds_loan_cont_type_3 IN VARCHAR2,
531 x_nslds_loan_schol_code_3 IN VARCHAR2,
532 x_nslds_loan_cont_code_3 IN VARCHAR2,
533 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
534 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
535 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
536 x_nslds_loan_seq_num_4 IN NUMBER,
537 x_nslds_loan_type_code_4 IN VARCHAR2,
538 x_nslds_loan_chng_f_4 IN VARCHAR2,
539 x_nslds_loan_prog_code_4 IN VARCHAR2,
540 x_nslds_loan_net_amnt_4 IN NUMBER,
541 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
542 x_nslds_loan_cur_st_date_4 IN DATE,
543 x_nslds_loan_agg_pr_bal_4 IN NUMBER,
544 x_nslds_loan_out_pr_bal_dt_4 IN DATE,
545 x_nslds_loan_begin_dt_4 IN DATE,
546 x_nslds_loan_end_dt_4 IN DATE,
547 x_nslds_loan_ga_code_4 IN VARCHAR2,
548 x_nslds_loan_cont_type_4 IN VARCHAR2,
549 x_nslds_loan_schol_code_4 IN VARCHAR2,
550 x_nslds_loan_cont_code_4 IN VARCHAR2,
551 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
552 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
553 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
554 x_nslds_loan_seq_num_5 IN NUMBER,
555 x_nslds_loan_type_code_5 IN VARCHAR2,
556 x_nslds_loan_chng_f_5 IN VARCHAR2,
557 x_nslds_loan_prog_code_5 IN VARCHAR2,
558 x_nslds_loan_net_amnt_5 IN NUMBER,
559 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
560 x_nslds_loan_cur_st_date_5 IN DATE,
561 x_nslds_loan_agg_pr_bal_5 IN NUMBER,
562 x_nslds_loan_out_pr_bal_dt_5 IN DATE,
563 x_nslds_loan_begin_dt_5 IN DATE,
564 x_nslds_loan_end_dt_5 IN DATE,
565 x_nslds_loan_ga_code_5 IN VARCHAR2,
566 x_nslds_loan_cont_type_5 IN VARCHAR2,
567 x_nslds_loan_schol_code_5 IN VARCHAR2,
568 x_nslds_loan_cont_code_5 IN VARCHAR2,
569 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
570 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
571 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
572 x_nslds_loan_seq_num_6 IN NUMBER,
573 x_nslds_loan_type_code_6 IN VARCHAR2,
574 x_nslds_loan_chng_f_6 IN VARCHAR2,
575 x_nslds_loan_prog_code_6 IN VARCHAR2,
576 x_nslds_loan_net_amnt_6 IN NUMBER,
577 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
578 x_nslds_loan_cur_st_date_6 IN DATE,
582 x_nslds_loan_end_dt_6 IN DATE,
579 x_nslds_loan_agg_pr_bal_6 IN NUMBER,
580 x_nslds_loan_out_pr_bal_dt_6 IN DATE,
581 x_nslds_loan_begin_dt_6 IN DATE,
583 x_nslds_loan_ga_code_6 IN VARCHAR2,
584 x_nslds_loan_cont_type_6 IN VARCHAR2,
585 x_nslds_loan_schol_code_6 IN VARCHAR2,
586 x_nslds_loan_cont_code_6 IN VARCHAR2,
587 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
588 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
589 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
590 x_nslds_loan_last_d_amt_1 IN NUMBER DEFAULT NULL,
591 x_nslds_loan_last_d_date_1 IN DATE DEFAULT NULL,
592 x_nslds_loan_last_d_amt_2 IN NUMBER DEFAULT NULL,
593 x_nslds_loan_last_d_date_2 IN DATE DEFAULT NULL,
594 x_nslds_loan_last_d_amt_3 IN NUMBER DEFAULT NULL,
595 x_nslds_loan_last_d_date_3 IN DATE DEFAULT NULL,
596 x_nslds_loan_last_d_amt_4 IN NUMBER DEFAULT NULL,
597 x_nslds_loan_last_d_date_4 IN DATE DEFAULT NULL,
598 x_nslds_loan_last_d_amt_5 IN NUMBER DEFAULT NULL,
599 x_nslds_loan_last_d_date_5 IN DATE DEFAULT NULL,
600 x_nslds_loan_last_d_amt_6 IN NUMBER DEFAULT NULL,
601 x_nslds_loan_last_d_date_6 IN DATE DEFAULT NULL,
602 x_dlp_master_prom_note_flag IN VARCHAR2 DEFAULT NULL,
603 x_mode IN VARCHAR2 DEFAULT 'R' ,
604 x_subsidized_loan_limit_type IN VARCHAR2 DEFAULT NULL,
605 x_combined_loan_limit_type IN VARCHAR2 DEFAULT NULL,
606 x_transaction_num_txt IN VARCHAR2 DEFAULT NULL
607 );
608
609 PROCEDURE add_row (
610 x_rowid IN OUT NOCOPY VARCHAR2,
611 x_nslds_id IN OUT NOCOPY NUMBER,
612 x_isir_id IN NUMBER,
613 x_base_id IN NUMBER,
614 x_nslds_transaction_num IN NUMBER,
615 x_nslds_database_results_f IN VARCHAR2,
616 x_nslds_f IN VARCHAR2,
617 x_nslds_pell_overpay_f IN VARCHAR2,
618 x_nslds_pell_overpay_contact IN VARCHAR2,
619 x_nslds_seog_overpay_f IN VARCHAR2,
620 x_nslds_seog_overpay_contact IN VARCHAR2,
621 x_nslds_perkins_overpay_f IN VARCHAR2,
622 x_nslds_perkins_overpay_cntct IN VARCHAR2,
623 x_nslds_defaulted_loan_f IN VARCHAR2,
624 x_nslds_dischged_loan_chng_f IN VARCHAR2,
625 x_nslds_satis_repay_f IN VARCHAR2,
626 x_nslds_act_bankruptcy_f IN VARCHAR2,
627 x_nslds_agg_subsz_out_prin_bal IN NUMBER,
628 x_nslds_agg_unsbz_out_prin_bal IN NUMBER,
629 x_nslds_agg_comb_out_prin_bal IN NUMBER,
630 x_nslds_agg_cons_out_prin_bal IN NUMBER,
631 x_nslds_agg_subsz_pend_dismt IN NUMBER,
632 x_nslds_agg_unsbz_pend_dismt IN NUMBER,
633 x_nslds_agg_comb_pend_dismt IN NUMBER,
634 x_nslds_agg_subsz_total IN NUMBER,
635 x_nslds_agg_unsbz_total IN NUMBER,
636 x_nslds_agg_comb_total IN NUMBER,
637 x_nslds_agg_consd_total IN NUMBER,
638 x_nslds_perkins_out_bal IN NUMBER,
639 x_nslds_perkins_cur_yr_dismnt IN NUMBER,
640 x_nslds_default_loan_chng_f IN VARCHAR2,
641 x_nslds_discharged_loan_f IN VARCHAR2,
642 x_nslds_satis_repay_chng_f IN VARCHAR2,
643 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
644 x_nslds_overpay_chng_f IN VARCHAR2,
645 x_nslds_agg_loan_chng_f IN VARCHAR2,
646 x_nslds_perkins_loan_chng_f IN VARCHAR2,
647 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
648 x_nslds_addtnl_pell_f IN VARCHAR2,
649 x_nslds_addtnl_loan_f IN VARCHAR2,
650 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
651 x_nslds_pell_seq_num_1 IN NUMBER,
652 x_nslds_pell_verify_f_1 IN VARCHAR2,
653 x_nslds_pell_efc_1 IN NUMBER,
654 x_nslds_pell_school_code_1 IN NUMBER,
655 x_nslds_pell_transcn_num_1 IN NUMBER,
656 x_nslds_pell_last_updt_dt_1 IN DATE,
657 x_nslds_pell_scheduled_amt_1 IN NUMBER,
658 x_nslds_pell_amt_paid_todt_1 IN NUMBER,
659 x_nslds_pell_remng_amt_1 IN NUMBER,
660 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER,
661 x_nslds_pell_award_amt_1 IN NUMBER,
662 x_nslds_pell_seq_num_2 IN NUMBER,
663 x_nslds_pell_verify_f_2 IN VARCHAR2,
664 x_nslds_pell_efc_2 IN NUMBER,
665 x_nslds_pell_school_code_2 IN NUMBER,
666 x_nslds_pell_transcn_num_2 IN NUMBER,
667 x_nslds_pell_last_updt_dt_2 IN DATE,
668 x_nslds_pell_scheduled_amt_2 IN NUMBER,
669 x_nslds_pell_amt_paid_todt_2 IN NUMBER,
670 x_nslds_pell_remng_amt_2 IN NUMBER,
671 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER,
672 x_nslds_pell_award_amt_2 IN NUMBER,
673 x_nslds_pell_seq_num_3 IN NUMBER,
677 x_nslds_pell_transcn_num_3 IN NUMBER,
674 x_nslds_pell_verify_f_3 IN VARCHAR2,
675 x_nslds_pell_efc_3 IN NUMBER,
676 x_nslds_pell_school_code_3 IN NUMBER,
678 x_nslds_pell_last_updt_dt_3 IN DATE,
679 x_nslds_pell_scheduled_amt_3 IN NUMBER,
680 x_nslds_pell_amt_paid_todt_3 IN NUMBER,
681 x_nslds_pell_remng_amt_3 IN NUMBER,
682 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER,
683 x_nslds_pell_award_amt_3 IN NUMBER,
684 x_nslds_loan_seq_num_1 IN NUMBER,
685 x_nslds_loan_type_code_1 IN VARCHAR2,
686 x_nslds_loan_chng_f_1 IN VARCHAR2,
687 x_nslds_loan_prog_code_1 IN VARCHAR2,
688 x_nslds_loan_net_amnt_1 IN NUMBER,
689 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
690 x_nslds_loan_cur_st_date_1 IN DATE,
691 x_nslds_loan_agg_pr_bal_1 IN NUMBER,
692 x_nslds_loan_out_pr_bal_dt_1 IN DATE,
693 x_nslds_loan_begin_dt_1 IN DATE,
694 x_nslds_loan_end_dt_1 IN DATE,
695 x_nslds_loan_ga_code_1 IN VARCHAR2,
696 x_nslds_loan_cont_type_1 IN VARCHAR2,
697 x_nslds_loan_schol_code_1 IN VARCHAR2,
698 x_nslds_loan_cont_code_1 IN VARCHAR2,
699 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
700 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
701 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
702 x_nslds_loan_seq_num_2 IN NUMBER,
703 x_nslds_loan_type_code_2 IN VARCHAR2,
704 x_nslds_loan_chng_f_2 IN VARCHAR2,
705 x_nslds_loan_prog_code_2 IN VARCHAR2,
706 x_nslds_loan_net_amnt_2 IN NUMBER,
707 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
708 x_nslds_loan_cur_st_date_2 IN DATE,
709 x_nslds_loan_agg_pr_bal_2 IN NUMBER,
710 x_nslds_loan_out_pr_bal_dt_2 IN DATE,
711 x_nslds_loan_begin_dt_2 IN DATE,
712 x_nslds_loan_end_dt_2 IN DATE,
713 x_nslds_loan_ga_code_2 IN VARCHAR2,
714 x_nslds_loan_cont_type_2 IN VARCHAR2,
715 x_nslds_loan_schol_code_2 IN VARCHAR2,
716 x_nslds_loan_cont_code_2 IN VARCHAR2,
717 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
718 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
719 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
720 x_nslds_loan_seq_num_3 IN NUMBER,
721 x_nslds_loan_type_code_3 IN VARCHAR2,
722 x_nslds_loan_chng_f_3 IN VARCHAR2,
723 x_nslds_loan_prog_code_3 IN VARCHAR2,
724 x_nslds_loan_net_amnt_3 IN NUMBER,
725 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
726 x_nslds_loan_cur_st_date_3 IN DATE,
727 x_nslds_loan_agg_pr_bal_3 IN NUMBER,
728 x_nslds_loan_out_pr_bal_dt_3 IN DATE,
729 x_nslds_loan_begin_dt_3 IN DATE,
730 x_nslds_loan_end_dt_3 IN DATE,
731 x_nslds_loan_ga_code_3 IN VARCHAR2,
732 x_nslds_loan_cont_type_3 IN VARCHAR2,
733 x_nslds_loan_schol_code_3 IN VARCHAR2,
734 x_nslds_loan_cont_code_3 IN VARCHAR2,
735 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
736 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
737 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
738 x_nslds_loan_seq_num_4 IN NUMBER,
739 x_nslds_loan_type_code_4 IN VARCHAR2,
740 x_nslds_loan_chng_f_4 IN VARCHAR2,
741 x_nslds_loan_prog_code_4 IN VARCHAR2,
742 x_nslds_loan_net_amnt_4 IN NUMBER,
743 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
744 x_nslds_loan_cur_st_date_4 IN DATE,
745 x_nslds_loan_agg_pr_bal_4 IN NUMBER,
746 x_nslds_loan_out_pr_bal_dt_4 IN DATE,
747 x_nslds_loan_begin_dt_4 IN DATE,
748 x_nslds_loan_end_dt_4 IN DATE,
749 x_nslds_loan_ga_code_4 IN VARCHAR2,
750 x_nslds_loan_cont_type_4 IN VARCHAR2,
751 x_nslds_loan_schol_code_4 IN VARCHAR2,
752 x_nslds_loan_cont_code_4 IN VARCHAR2,
753 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
754 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
755 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
756 x_nslds_loan_seq_num_5 IN NUMBER,
757 x_nslds_loan_type_code_5 IN VARCHAR2,
758 x_nslds_loan_chng_f_5 IN VARCHAR2,
759 x_nslds_loan_prog_code_5 IN VARCHAR2,
760 x_nslds_loan_net_amnt_5 IN NUMBER,
761 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
762 x_nslds_loan_cur_st_date_5 IN DATE,
763 x_nslds_loan_agg_pr_bal_5 IN NUMBER,
764 x_nslds_loan_out_pr_bal_dt_5 IN DATE,
765 x_nslds_loan_begin_dt_5 IN DATE,
766 x_nslds_loan_end_dt_5 IN DATE,
767 x_nslds_loan_ga_code_5 IN VARCHAR2,
768 x_nslds_loan_cont_type_5 IN VARCHAR2,
769 x_nslds_loan_schol_code_5 IN VARCHAR2,
770 x_nslds_loan_cont_code_5 IN VARCHAR2,
774 x_nslds_loan_seq_num_6 IN NUMBER,
771 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
772 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
773 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
775 x_nslds_loan_type_code_6 IN VARCHAR2,
776 x_nslds_loan_chng_f_6 IN VARCHAR2,
777 x_nslds_loan_prog_code_6 IN VARCHAR2,
778 x_nslds_loan_net_amnt_6 IN NUMBER,
779 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
780 x_nslds_loan_cur_st_date_6 IN DATE,
781 x_nslds_loan_agg_pr_bal_6 IN NUMBER,
782 x_nslds_loan_out_pr_bal_dt_6 IN DATE,
783 x_nslds_loan_begin_dt_6 IN DATE,
784 x_nslds_loan_end_dt_6 IN DATE,
785 x_nslds_loan_ga_code_6 IN VARCHAR2,
786 x_nslds_loan_cont_type_6 IN VARCHAR2,
787 x_nslds_loan_schol_code_6 IN VARCHAR2,
788 x_nslds_loan_cont_code_6 IN VARCHAR2,
789 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
790 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
791 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
792 x_nslds_loan_last_d_amt_1 IN NUMBER DEFAULT NULL,
793 x_nslds_loan_last_d_date_1 IN DATE DEFAULT NULL,
794 x_nslds_loan_last_d_amt_2 IN NUMBER DEFAULT NULL,
795 x_nslds_loan_last_d_date_2 IN DATE DEFAULT NULL,
796 x_nslds_loan_last_d_amt_3 IN NUMBER DEFAULT NULL,
797 x_nslds_loan_last_d_date_3 IN DATE DEFAULT NULL,
798 x_nslds_loan_last_d_amt_4 IN NUMBER DEFAULT NULL,
799 x_nslds_loan_last_d_date_4 IN DATE DEFAULT NULL,
800 x_nslds_loan_last_d_amt_5 IN NUMBER DEFAULT NULL,
801 x_nslds_loan_last_d_date_5 IN DATE DEFAULT NULL,
802 x_nslds_loan_last_d_amt_6 IN NUMBER DEFAULT NULL,
803 x_nslds_loan_last_d_date_6 IN DATE DEFAULT NULL,
804 x_dlp_master_prom_note_flag IN VARCHAR2 DEFAULT NULL,
805 x_mode IN VARCHAR2 DEFAULT 'R' ,
806 x_subsidized_loan_limit_type IN VARCHAR2 DEFAULT NULL,
807 x_combined_loan_limit_type IN VARCHAR2 DEFAULT NULL,
808 x_transaction_num_txt IN VARCHAR2 DEFAULT NULL
809 );
810
811 PROCEDURE delete_row (
812 x_rowid IN VARCHAR2
813 );
814
815 FUNCTION get_pk_for_validation (
816 x_nslds_id IN NUMBER
817 ) RETURN BOOLEAN;
818
819 PROCEDURE get_fk_igf_ap_isir_matched (
820 x_isir_id IN NUMBER
821 );
822
823 PROCEDURE before_dml (
824 p_action IN VARCHAR2,
825 x_rowid IN VARCHAR2 DEFAULT NULL,
826 x_nslds_id IN NUMBER DEFAULT NULL,
827 x_isir_id IN NUMBER DEFAULT NULL,
828 x_base_id IN NUMBER DEFAULT NULL,
829 x_nslds_transaction_num IN NUMBER DEFAULT NULL,
830 x_nslds_database_results_f IN VARCHAR2 DEFAULT NULL,
831 x_nslds_f IN VARCHAR2 DEFAULT NULL,
832 x_nslds_pell_overpay_f IN VARCHAR2 DEFAULT NULL,
833 x_nslds_pell_overpay_contact IN VARCHAR2 DEFAULT NULL,
834 x_nslds_seog_overpay_f IN VARCHAR2 DEFAULT NULL,
835 x_nslds_seog_overpay_contact IN VARCHAR2 DEFAULT NULL,
836 x_nslds_perkins_overpay_f IN VARCHAR2 DEFAULT NULL,
837 x_nslds_perkins_overpay_cntct IN VARCHAR2 DEFAULT NULL,
838 x_nslds_defaulted_loan_f IN VARCHAR2 DEFAULT NULL,
839 x_nslds_dischged_loan_chng_f IN VARCHAR2 DEFAULT NULL,
840 x_nslds_satis_repay_f IN VARCHAR2 DEFAULT NULL,
841 x_nslds_act_bankruptcy_f IN VARCHAR2 DEFAULT NULL,
842 x_nslds_agg_subsz_out_prin_bal IN NUMBER DEFAULT NULL,
843 x_nslds_agg_unsbz_out_prin_bal IN NUMBER DEFAULT NULL,
844 x_nslds_agg_comb_out_prin_bal IN NUMBER DEFAULT NULL,
845 x_nslds_agg_cons_out_prin_bal IN NUMBER DEFAULT NULL,
846 x_nslds_agg_subsz_pend_dismt IN NUMBER DEFAULT NULL,
847 x_nslds_agg_unsbz_pend_dismt IN NUMBER DEFAULT NULL,
848 x_nslds_agg_comb_pend_dismt IN NUMBER DEFAULT NULL,
849 x_nslds_agg_subsz_total IN NUMBER DEFAULT NULL,
850 x_nslds_agg_unsbz_total IN NUMBER DEFAULT NULL,
851 x_nslds_agg_comb_total IN NUMBER DEFAULT NULL,
852 x_nslds_agg_consd_total IN NUMBER DEFAULT NULL,
853 x_nslds_perkins_out_bal IN NUMBER DEFAULT NULL,
854 x_nslds_perkins_cur_yr_dismnt IN NUMBER DEFAULT NULL,
855 x_nslds_default_loan_chng_f IN VARCHAR2 DEFAULT NULL,
856 x_nslds_discharged_loan_f IN VARCHAR2 DEFAULT NULL,
857 x_nslds_satis_repay_chng_f IN VARCHAR2 DEFAULT NULL,
858 x_nslds_act_bnkrupt_chng_f IN VARCHAR2 DEFAULT NULL,
859 x_nslds_overpay_chng_f IN VARCHAR2 DEFAULT NULL,
860 x_nslds_agg_loan_chng_f IN VARCHAR2 DEFAULT NULL,
861 x_nslds_perkins_loan_chng_f IN VARCHAR2 DEFAULT NULL,
865 x_direct_loan_mas_prom_nt_f IN VARCHAR2 DEFAULT NULL,
862 x_nslds_pell_paymnt_chng_f IN VARCHAR2 DEFAULT NULL,
863 x_nslds_addtnl_pell_f IN VARCHAR2 DEFAULT NULL,
864 x_nslds_addtnl_loan_f IN VARCHAR2 DEFAULT NULL,
866 x_nslds_pell_seq_num_1 IN NUMBER DEFAULT NULL,
867 x_nslds_pell_verify_f_1 IN VARCHAR2 DEFAULT NULL,
868 x_nslds_pell_efc_1 IN NUMBER DEFAULT NULL,
869 x_nslds_pell_school_code_1 IN NUMBER DEFAULT NULL,
870 x_nslds_pell_transcn_num_1 IN NUMBER DEFAULT NULL,
871 x_nslds_pell_last_updt_dt_1 IN DATE DEFAULT NULL,
872 x_nslds_pell_scheduled_amt_1 IN NUMBER DEFAULT NULL,
873 x_nslds_pell_amt_paid_todt_1 IN NUMBER DEFAULT NULL,
874 x_nslds_pell_remng_amt_1 IN NUMBER DEFAULT NULL,
875 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER DEFAULT NULL,
876 x_nslds_pell_award_amt_1 IN NUMBER DEFAULT NULL,
877 x_nslds_pell_seq_num_2 IN NUMBER DEFAULT NULL,
878 x_nslds_pell_verify_f_2 IN VARCHAR2 DEFAULT NULL,
879 x_nslds_pell_efc_2 IN NUMBER DEFAULT NULL,
880 x_nslds_pell_school_code_2 IN NUMBER DEFAULT NULL,
881 x_nslds_pell_transcn_num_2 IN NUMBER DEFAULT NULL,
882 x_nslds_pell_last_updt_dt_2 IN DATE DEFAULT NULL,
883 x_nslds_pell_scheduled_amt_2 IN NUMBER DEFAULT NULL,
884 x_nslds_pell_amt_paid_todt_2 IN NUMBER DEFAULT NULL,
885 x_nslds_pell_remng_amt_2 IN NUMBER DEFAULT NULL,
886 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER DEFAULT NULL,
887 x_nslds_pell_award_amt_2 IN NUMBER DEFAULT NULL,
888 x_nslds_pell_seq_num_3 IN NUMBER DEFAULT NULL,
889 x_nslds_pell_verify_f_3 IN VARCHAR2 DEFAULT NULL,
890 x_nslds_pell_efc_3 IN NUMBER DEFAULT NULL,
891 x_nslds_pell_school_code_3 IN NUMBER DEFAULT NULL,
892 x_nslds_pell_transcn_num_3 IN NUMBER DEFAULT NULL,
893 x_nslds_pell_last_updt_dt_3 IN DATE DEFAULT NULL,
894 x_nslds_pell_scheduled_amt_3 IN NUMBER DEFAULT NULL,
895 x_nslds_pell_amt_paid_todt_3 IN NUMBER DEFAULT NULL,
896 x_nslds_pell_remng_amt_3 IN NUMBER DEFAULT NULL,
897 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER DEFAULT NULL,
898 x_nslds_pell_award_amt_3 IN NUMBER DEFAULT NULL,
899 x_nslds_loan_seq_num_1 IN NUMBER DEFAULT NULL,
900 x_nslds_loan_type_code_1 IN VARCHAR2 DEFAULT NULL,
901 x_nslds_loan_chng_f_1 IN VARCHAR2 DEFAULT NULL,
902 x_nslds_loan_prog_code_1 IN VARCHAR2 DEFAULT NULL,
903 x_nslds_loan_net_amnt_1 IN NUMBER DEFAULT NULL,
904 x_nslds_loan_cur_st_code_1 IN VARCHAR2 DEFAULT NULL,
905 x_nslds_loan_cur_st_date_1 IN DATE DEFAULT NULL,
906 x_nslds_loan_agg_pr_bal_1 IN NUMBER DEFAULT NULL,
907 x_nslds_loan_out_pr_bal_dt_1 IN DATE DEFAULT NULL,
908 x_nslds_loan_begin_dt_1 IN DATE DEFAULT NULL,
909 x_nslds_loan_end_dt_1 IN DATE DEFAULT NULL,
910 x_nslds_loan_ga_code_1 IN VARCHAR2 DEFAULT NULL,
911 x_nslds_loan_cont_type_1 IN VARCHAR2 DEFAULT NULL,
912 x_nslds_loan_schol_code_1 IN VARCHAR2 DEFAULT NULL,
913 x_nslds_loan_cont_code_1 IN VARCHAR2 DEFAULT NULL,
914 x_nslds_loan_grade_lvl_1 IN VARCHAR2 DEFAULT NULL,
915 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2 DEFAULT NULL,
916 x_nslds_loan_capital_int_f_1 IN VARCHAR2 DEFAULT NULL,
917 x_nslds_loan_seq_num_2 IN NUMBER DEFAULT NULL,
918 x_nslds_loan_type_code_2 IN VARCHAR2 DEFAULT NULL,
919 x_nslds_loan_chng_f_2 IN VARCHAR2 DEFAULT NULL,
920 x_nslds_loan_prog_code_2 IN VARCHAR2 DEFAULT NULL,
921 x_nslds_loan_net_amnt_2 IN NUMBER DEFAULT NULL,
922 x_nslds_loan_cur_st_code_2 IN VARCHAR2 DEFAULT NULL,
923 x_nslds_loan_cur_st_date_2 IN DATE DEFAULT NULL,
924 x_nslds_loan_agg_pr_bal_2 IN NUMBER DEFAULT NULL,
925 x_nslds_loan_out_pr_bal_dt_2 IN DATE DEFAULT NULL,
926 x_nslds_loan_begin_dt_2 IN DATE DEFAULT NULL,
927 x_nslds_loan_end_dt_2 IN DATE DEFAULT NULL,
928 x_nslds_loan_ga_code_2 IN VARCHAR2 DEFAULT NULL,
929 x_nslds_loan_cont_type_2 IN VARCHAR2 DEFAULT NULL,
930 x_nslds_loan_schol_code_2 IN VARCHAR2 DEFAULT NULL,
931 x_nslds_loan_cont_code_2 IN VARCHAR2 DEFAULT NULL,
932 x_nslds_loan_grade_lvl_2 IN VARCHAR2 DEFAULT NULL,
933 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2 DEFAULT NULL,
934 x_nslds_loan_capital_int_f_2 IN VARCHAR2 DEFAULT NULL,
935 x_nslds_loan_seq_num_3 IN NUMBER DEFAULT NULL,
936 x_nslds_loan_type_code_3 IN VARCHAR2 DEFAULT NULL,
937 x_nslds_loan_chng_f_3 IN VARCHAR2 DEFAULT NULL,
938 x_nslds_loan_prog_code_3 IN VARCHAR2 DEFAULT NULL,
939 x_nslds_loan_net_amnt_3 IN NUMBER DEFAULT NULL,
943 x_nslds_loan_out_pr_bal_dt_3 IN DATE DEFAULT NULL,
940 x_nslds_loan_cur_st_code_3 IN VARCHAR2 DEFAULT NULL,
941 x_nslds_loan_cur_st_date_3 IN DATE DEFAULT NULL,
942 x_nslds_loan_agg_pr_bal_3 IN NUMBER DEFAULT NULL,
944 x_nslds_loan_begin_dt_3 IN DATE DEFAULT NULL,
945 x_nslds_loan_end_dt_3 IN DATE DEFAULT NULL,
946 x_nslds_loan_ga_code_3 IN VARCHAR2 DEFAULT NULL,
947 x_nslds_loan_cont_type_3 IN VARCHAR2 DEFAULT NULL,
948 x_nslds_loan_schol_code_3 IN VARCHAR2 DEFAULT NULL,
949 x_nslds_loan_cont_code_3 IN VARCHAR2 DEFAULT NULL,
950 x_nslds_loan_grade_lvl_3 IN VARCHAR2 DEFAULT NULL,
951 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2 DEFAULT NULL,
952 x_nslds_loan_capital_int_f_3 IN VARCHAR2 DEFAULT NULL,
953 x_nslds_loan_seq_num_4 IN NUMBER DEFAULT NULL,
954 x_nslds_loan_type_code_4 IN VARCHAR2 DEFAULT NULL,
955 x_nslds_loan_chng_f_4 IN VARCHAR2 DEFAULT NULL,
956 x_nslds_loan_prog_code_4 IN VARCHAR2 DEFAULT NULL,
957 x_nslds_loan_net_amnt_4 IN NUMBER DEFAULT NULL,
958 x_nslds_loan_cur_st_code_4 IN VARCHAR2 DEFAULT NULL,
959 x_nslds_loan_cur_st_date_4 IN DATE DEFAULT NULL,
960 x_nslds_loan_agg_pr_bal_4 IN NUMBER DEFAULT NULL,
961 x_nslds_loan_out_pr_bal_dt_4 IN DATE DEFAULT NULL,
962 x_nslds_loan_begin_dt_4 IN DATE DEFAULT NULL,
963 x_nslds_loan_end_dt_4 IN DATE DEFAULT NULL,
964 x_nslds_loan_ga_code_4 IN VARCHAR2 DEFAULT NULL,
965 x_nslds_loan_cont_type_4 IN VARCHAR2 DEFAULT NULL,
966 x_nslds_loan_schol_code_4 IN VARCHAR2 DEFAULT NULL,
967 x_nslds_loan_cont_code_4 IN VARCHAR2 DEFAULT NULL,
968 x_nslds_loan_grade_lvl_4 IN VARCHAR2 DEFAULT NULL,
969 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2 DEFAULT NULL,
970 x_nslds_loan_capital_int_f_4 IN VARCHAR2 DEFAULT NULL,
971 x_nslds_loan_seq_num_5 IN NUMBER DEFAULT NULL,
972 x_nslds_loan_type_code_5 IN VARCHAR2 DEFAULT NULL,
973 x_nslds_loan_chng_f_5 IN VARCHAR2 DEFAULT NULL,
974 x_nslds_loan_prog_code_5 IN VARCHAR2 DEFAULT NULL,
975 x_nslds_loan_net_amnt_5 IN NUMBER DEFAULT NULL,
976 x_nslds_loan_cur_st_code_5 IN VARCHAR2 DEFAULT NULL,
977 x_nslds_loan_cur_st_date_5 IN DATE DEFAULT NULL,
978 x_nslds_loan_agg_pr_bal_5 IN NUMBER DEFAULT NULL,
979 x_nslds_loan_out_pr_bal_dt_5 IN DATE DEFAULT NULL,
980 x_nslds_loan_begin_dt_5 IN DATE DEFAULT NULL,
981 x_nslds_loan_end_dt_5 IN DATE DEFAULT NULL,
982 x_nslds_loan_ga_code_5 IN VARCHAR2 DEFAULT NULL,
983 x_nslds_loan_cont_type_5 IN VARCHAR2 DEFAULT NULL,
984 x_nslds_loan_schol_code_5 IN VARCHAR2 DEFAULT NULL,
985 x_nslds_loan_cont_code_5 IN VARCHAR2 DEFAULT NULL,
986 x_nslds_loan_grade_lvl_5 IN VARCHAR2 DEFAULT NULL,
987 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2 DEFAULT NULL,
988 x_nslds_loan_capital_int_f_5 IN VARCHAR2 DEFAULT NULL,
989 x_nslds_loan_seq_num_6 IN NUMBER DEFAULT NULL,
990 x_nslds_loan_type_code_6 IN VARCHAR2 DEFAULT NULL,
991 x_nslds_loan_chng_f_6 IN VARCHAR2 DEFAULT NULL,
992 x_nslds_loan_prog_code_6 IN VARCHAR2 DEFAULT NULL,
993 x_nslds_loan_net_amnt_6 IN NUMBER DEFAULT NULL,
994 x_nslds_loan_cur_st_code_6 IN VARCHAR2 DEFAULT NULL,
995 x_nslds_loan_cur_st_date_6 IN DATE DEFAULT NULL,
996 x_nslds_loan_agg_pr_bal_6 IN NUMBER DEFAULT NULL,
997 x_nslds_loan_out_pr_bal_dt_6 IN DATE DEFAULT NULL,
998 x_nslds_loan_begin_dt_6 IN DATE DEFAULT NULL,
999 x_nslds_loan_end_dt_6 IN DATE DEFAULT NULL,
1000 x_nslds_loan_ga_code_6 IN VARCHAR2 DEFAULT NULL,
1001 x_nslds_loan_cont_type_6 IN VARCHAR2 DEFAULT NULL,
1002 x_nslds_loan_schol_code_6 IN VARCHAR2 DEFAULT NULL,
1003 x_nslds_loan_cont_code_6 IN VARCHAR2 DEFAULT NULL,
1004 x_nslds_loan_grade_lvl_6 IN VARCHAR2 DEFAULT NULL,
1005 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2 DEFAULT NULL,
1006 x_nslds_loan_capital_int_f_6 IN VARCHAR2 DEFAULT NULL,
1007 x_nslds_loan_last_d_amt_1 IN NUMBER DEFAULT NULL,
1008 x_nslds_loan_last_d_date_1 IN DATE DEFAULT NULL,
1009 x_nslds_loan_last_d_amt_2 IN NUMBER DEFAULT NULL,
1010 x_nslds_loan_last_d_date_2 IN DATE DEFAULT NULL,
1011 x_nslds_loan_last_d_amt_3 IN NUMBER DEFAULT NULL,
1012 x_nslds_loan_last_d_date_3 IN DATE DEFAULT NULL,
1013 x_nslds_loan_last_d_amt_4 IN NUMBER DEFAULT NULL,
1014 x_nslds_loan_last_d_date_4 IN DATE DEFAULT NULL,
1015 x_nslds_loan_last_d_amt_5 IN NUMBER DEFAULT NULL,
1016 x_nslds_loan_last_d_date_5 IN DATE DEFAULT NULL,
1017 x_nslds_loan_last_d_amt_6 IN NUMBER DEFAULT NULL,
1018 x_nslds_loan_last_d_date_6 IN DATE DEFAULT NULL,
1019 x_creation_date IN DATE DEFAULT NULL,
1020 x_created_by IN NUMBER DEFAULT NULL,
1021 x_last_update_date IN DATE DEFAULT NULL,
1022 x_last_updated_by IN NUMBER DEFAULT NULL,
1023 x_last_update_login IN NUMBER DEFAULT NULL,
1024 x_dlp_master_prom_note_flag IN VARCHAR2 DEFAULT NULL,
1025 x_subsidized_loan_limit_type IN VARCHAR2 DEFAULT NULL,
1026 x_combined_loan_limit_type IN VARCHAR2 DEFAULT NULL,
1027 x_transaction_num_txt IN VARCHAR2 DEFAULT NULL
1028 );
1029
1030 END igf_ap_nslds_data_pkg;