[Home] [Help]
PACKAGE BODY: APPS.IGF_AP_NSLDS_DATA_PKG
Source
1 PACKAGE BODY IGF_AP_NSLDS_DATA_PKG AS
2 /* $Header: IGFAI10B.pls 120.0 2005/06/02 15:55:35 appldev noship $ */
3
4 l_rowid VARCHAR2(25);
5 old_references igf_ap_nslds_data_all%ROWTYPE;
6 new_references igf_ap_nslds_data_all%ROWTYPE;
7
8 PROCEDURE set_column_values (
9 p_action IN VARCHAR2,
10 x_rowid IN VARCHAR2,
11 x_nslds_id IN NUMBER ,
12 x_isir_id IN NUMBER ,
13 x_base_id IN NUMBER ,
14 x_nslds_transaction_num IN NUMBER ,
15 x_nslds_database_results_f IN VARCHAR2,
16 x_nslds_f IN VARCHAR2,
17 x_nslds_pell_overpay_f IN VARCHAR2,
18 x_nslds_pell_overpay_contact IN VARCHAR2,
19 x_nslds_seog_overpay_f IN VARCHAR2,
20 x_nslds_seog_overpay_contact IN VARCHAR2,
21 x_nslds_perkins_overpay_f IN VARCHAR2,
22 x_nslds_perkins_overpay_cntct IN VARCHAR2,
23 x_nslds_defaulted_loan_f IN VARCHAR2,
24 x_nslds_dischged_loan_chng_f IN VARCHAR2,
25 x_nslds_satis_repay_f IN VARCHAR2,
26 x_nslds_act_bankruptcy_f IN VARCHAR2,
27 x_nslds_agg_subsz_out_prin_bal IN NUMBER ,
28 x_nslds_agg_unsbz_out_prin_bal IN NUMBER ,
29 x_nslds_agg_comb_out_prin_bal IN NUMBER ,
30 x_nslds_agg_cons_out_prin_bal IN NUMBER ,
31 x_nslds_agg_subsz_pend_dismt IN NUMBER ,
32 x_nslds_agg_unsbz_pend_dismt IN NUMBER ,
33 x_nslds_agg_comb_pend_dismt IN NUMBER ,
34 x_nslds_agg_subsz_total IN NUMBER ,
35 x_nslds_agg_unsbz_total IN NUMBER ,
36 x_nslds_agg_comb_total IN NUMBER ,
37 x_nslds_agg_consd_total IN NUMBER ,
38 x_nslds_perkins_out_bal IN NUMBER ,
39 x_nslds_perkins_cur_yr_dismnt IN NUMBER ,
40 x_nslds_default_loan_chng_f IN VARCHAR2,
41 x_nslds_discharged_loan_f IN VARCHAR2,
42 x_nslds_satis_repay_chng_f IN VARCHAR2,
43 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
44 x_nslds_overpay_chng_f IN VARCHAR2,
45 x_nslds_agg_loan_chng_f IN VARCHAR2,
46 x_nslds_perkins_loan_chng_f IN VARCHAR2,
47 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
48 x_nslds_addtnl_pell_f IN VARCHAR2,
49 x_nslds_addtnl_loan_f IN VARCHAR2,
50 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
51 x_nslds_pell_seq_num_1 IN NUMBER ,
52 x_nslds_pell_verify_f_1 IN VARCHAR2,
53 x_nslds_pell_efc_1 IN NUMBER ,
54 x_nslds_pell_school_code_1 IN NUMBER ,
55 x_nslds_pell_transcn_num_1 IN NUMBER ,
56 x_nslds_pell_last_updt_dt_1 IN DATE ,
57 x_nslds_pell_scheduled_amt_1 IN NUMBER ,
58 x_nslds_pell_amt_paid_todt_1 IN NUMBER ,
59 x_nslds_pell_remng_amt_1 IN NUMBER ,
60 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER ,
61 x_nslds_pell_award_amt_1 IN NUMBER ,
62 x_nslds_pell_seq_num_2 IN NUMBER ,
63 x_nslds_pell_verify_f_2 IN VARCHAR2,
64 x_nslds_pell_efc_2 IN NUMBER ,
65 x_nslds_pell_school_code_2 IN NUMBER ,
66 x_nslds_pell_transcn_num_2 IN NUMBER ,
67 x_nslds_pell_last_updt_dt_2 IN DATE ,
68 x_nslds_pell_scheduled_amt_2 IN NUMBER ,
69 x_nslds_pell_amt_paid_todt_2 IN NUMBER ,
70 x_nslds_pell_remng_amt_2 IN NUMBER ,
71 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER ,
72 x_nslds_pell_award_amt_2 IN NUMBER ,
73 x_nslds_pell_seq_num_3 IN NUMBER ,
74 x_nslds_pell_verify_f_3 IN VARCHAR2,
75 x_nslds_pell_efc_3 IN NUMBER ,
76 x_nslds_pell_school_code_3 IN NUMBER ,
77 x_nslds_pell_transcn_num_3 IN NUMBER ,
78 x_nslds_pell_last_updt_dt_3 IN DATE ,
79 x_nslds_pell_scheduled_amt_3 IN NUMBER ,
80 x_nslds_pell_amt_paid_todt_3 IN NUMBER ,
81 x_nslds_pell_remng_amt_3 IN NUMBER ,
82 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER ,
83 x_nslds_pell_award_amt_3 IN NUMBER ,
84 x_nslds_loan_seq_num_1 IN NUMBER ,
85 x_nslds_loan_type_code_1 IN VARCHAR2,
86 x_nslds_loan_chng_f_1 IN VARCHAR2,
87 x_nslds_loan_prog_code_1 IN VARCHAR2,
88 x_nslds_loan_net_amnt_1 IN NUMBER ,
89 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
90 x_nslds_loan_cur_st_date_1 IN DATE ,
91 x_nslds_loan_agg_pr_bal_1 IN NUMBER ,
92 x_nslds_loan_out_pr_bal_dt_1 IN DATE ,
93 x_nslds_loan_begin_dt_1 IN DATE ,
94 x_nslds_loan_end_dt_1 IN DATE ,
95 x_nslds_loan_ga_code_1 IN VARCHAR2,
96 x_nslds_loan_cont_type_1 IN VARCHAR2,
97 x_nslds_loan_schol_code_1 IN VARCHAR2,
98 x_nslds_loan_cont_code_1 IN VARCHAR2,
99 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
100 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
101 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
102 x_nslds_loan_seq_num_2 IN NUMBER ,
103 x_nslds_loan_type_code_2 IN VARCHAR2,
104 x_nslds_loan_chng_f_2 IN VARCHAR2,
105 x_nslds_loan_prog_code_2 IN VARCHAR2,
106 x_nslds_loan_net_amnt_2 IN NUMBER ,
107 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
108 x_nslds_loan_cur_st_date_2 IN DATE ,
109 x_nslds_loan_agg_pr_bal_2 IN NUMBER ,
110 x_nslds_loan_out_pr_bal_dt_2 IN DATE ,
111 x_nslds_loan_begin_dt_2 IN DATE ,
112 x_nslds_loan_end_dt_2 IN DATE ,
113 x_nslds_loan_ga_code_2 IN VARCHAR2,
114 x_nslds_loan_cont_type_2 IN VARCHAR2,
115 x_nslds_loan_schol_code_2 IN VARCHAR2,
116 x_nslds_loan_cont_code_2 IN VARCHAR2,
117 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
118 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
119 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
120 x_nslds_loan_seq_num_3 IN NUMBER ,
121 x_nslds_loan_type_code_3 IN VARCHAR2,
122 x_nslds_loan_chng_f_3 IN VARCHAR2,
123 x_nslds_loan_prog_code_3 IN VARCHAR2,
124 x_nslds_loan_net_amnt_3 IN NUMBER ,
125 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
126 x_nslds_loan_cur_st_date_3 IN DATE ,
127 x_nslds_loan_agg_pr_bal_3 IN NUMBER ,
128 x_nslds_loan_out_pr_bal_dt_3 IN DATE ,
129 x_nslds_loan_begin_dt_3 IN DATE ,
130 x_nslds_loan_end_dt_3 IN DATE ,
131 x_nslds_loan_ga_code_3 IN VARCHAR2,
132 x_nslds_loan_cont_type_3 IN VARCHAR2,
133 x_nslds_loan_schol_code_3 IN VARCHAR2,
134 x_nslds_loan_cont_code_3 IN VARCHAR2,
135 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
136 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
137 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
138 x_nslds_loan_seq_num_4 IN NUMBER ,
139 x_nslds_loan_type_code_4 IN VARCHAR2,
140 x_nslds_loan_chng_f_4 IN VARCHAR2,
141 x_nslds_loan_prog_code_4 IN VARCHAR2,
142 x_nslds_loan_net_amnt_4 IN NUMBER ,
143 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
144 x_nslds_loan_cur_st_date_4 IN DATE ,
145 x_nslds_loan_agg_pr_bal_4 IN NUMBER ,
146 x_nslds_loan_out_pr_bal_dt_4 IN DATE ,
147 x_nslds_loan_begin_dt_4 IN DATE ,
148 x_nslds_loan_end_dt_4 IN DATE ,
149 x_nslds_loan_ga_code_4 IN VARCHAR2,
150 x_nslds_loan_cont_type_4 IN VARCHAR2,
151 x_nslds_loan_schol_code_4 IN VARCHAR2,
152 x_nslds_loan_cont_code_4 IN VARCHAR2,
153 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
154 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
155 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
156 x_nslds_loan_seq_num_5 IN NUMBER ,
157 x_nslds_loan_type_code_5 IN VARCHAR2,
158 x_nslds_loan_chng_f_5 IN VARCHAR2,
159 x_nslds_loan_prog_code_5 IN VARCHAR2,
160 x_nslds_loan_net_amnt_5 IN NUMBER ,
161 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
162 x_nslds_loan_cur_st_date_5 IN DATE ,
163 x_nslds_loan_agg_pr_bal_5 IN NUMBER ,
164 x_nslds_loan_out_pr_bal_dt_5 IN DATE ,
165 x_nslds_loan_begin_dt_5 IN DATE ,
166 x_nslds_loan_end_dt_5 IN DATE ,
167 x_nslds_loan_ga_code_5 IN VARCHAR2,
168 x_nslds_loan_cont_type_5 IN VARCHAR2,
169 x_nslds_loan_schol_code_5 IN VARCHAR2,
170 x_nslds_loan_cont_code_5 IN VARCHAR2,
171 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
172 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
173 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
174 x_nslds_loan_seq_num_6 IN NUMBER ,
175 x_nslds_loan_type_code_6 IN VARCHAR2,
176 x_nslds_loan_chng_f_6 IN VARCHAR2,
177 x_nslds_loan_prog_code_6 IN VARCHAR2,
178 x_nslds_loan_net_amnt_6 IN NUMBER ,
179 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
180 x_nslds_loan_cur_st_date_6 IN DATE ,
181 x_nslds_loan_agg_pr_bal_6 IN NUMBER ,
182 x_nslds_loan_out_pr_bal_dt_6 IN DATE ,
183 x_nslds_loan_begin_dt_6 IN DATE ,
184 x_nslds_loan_end_dt_6 IN DATE ,
185 x_nslds_loan_ga_code_6 IN VARCHAR2,
186 x_nslds_loan_cont_type_6 IN VARCHAR2,
187 x_nslds_loan_schol_code_6 IN VARCHAR2,
188 x_nslds_loan_cont_code_6 IN VARCHAR2,
189 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
190 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
191 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
192 x_nslds_loan_last_d_amt_1 IN NUMBER ,
193 x_nslds_loan_last_d_date_1 IN DATE ,
194 x_nslds_loan_last_d_amt_2 IN NUMBER ,
195 x_nslds_loan_last_d_date_2 IN DATE ,
196 x_nslds_loan_last_d_amt_3 IN NUMBER ,
197 x_nslds_loan_last_d_date_3 IN DATE ,
198 x_nslds_loan_last_d_amt_4 IN NUMBER ,
199 x_nslds_loan_last_d_date_4 IN DATE ,
200 x_nslds_loan_last_d_amt_5 IN NUMBER ,
201 x_nslds_loan_last_d_date_5 IN DATE ,
202 x_nslds_loan_last_d_amt_6 IN NUMBER ,
203 x_nslds_loan_last_d_date_6 IN DATE ,
204 x_creation_date IN DATE ,
205 x_created_by IN NUMBER ,
206 x_last_update_date IN DATE ,
207 x_last_updated_by IN NUMBER ,
208 x_last_update_login IN NUMBER ,
209 x_dlp_master_prom_note_flag IN VARCHAR2,
210 x_subsidized_loan_limit_type IN VARCHAR2,
211 x_combined_loan_limit_type IN VARCHAR2,
212 x_transaction_num_txt IN VARCHAR2
213 ) AS
214 /*
215 || Created By : rasingh
216 || Created On : 06-DEC-2000
217 || Purpose : Initialises the Old and New references for the columns of the table.
218 || Known limitations, enhancements or remarks :
219 || Change History :
220 || Who When What
221 || (reverse chronological order - newest change first)
222 */
223
224 CURSOR cur_old_ref_values IS
225 SELECT *
226 FROM IGF_AP_NSLDS_DATA_ALL
227 WHERE rowid = x_rowid;
228
229 BEGIN
230
231 l_rowid := x_rowid;
232
233 -- Code for setting the Old and New Reference Values.
234 -- Populate Old Values.
235 OPEN cur_old_ref_values;
236 FETCH cur_old_ref_values INTO old_references;
237 IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
238 CLOSE cur_old_ref_values;
239 fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
240 igs_ge_msg_stack.add;
241 app_exception.raise_exception;
242 RETURN;
243 END IF;
244 CLOSE cur_old_ref_values;
245
246 -- Populate New Values.
247 new_references.nslds_id := x_nslds_id;
248 new_references.isir_id := x_isir_id;
249 new_references.base_id := x_base_id;
250 new_references.nslds_transaction_num := x_nslds_transaction_num;
251 new_references.nslds_database_results_f := x_nslds_database_results_f;
252 new_references.nslds_f := x_nslds_f;
253 new_references.nslds_pell_overpay_f := x_nslds_pell_overpay_f;
254 new_references.nslds_pell_overpay_contact := x_nslds_pell_overpay_contact;
255 new_references.nslds_seog_overpay_f := x_nslds_seog_overpay_f;
256 new_references.nslds_seog_overpay_contact := x_nslds_seog_overpay_contact;
257 new_references.nslds_perkins_overpay_f := x_nslds_perkins_overpay_f;
258 new_references.nslds_perkins_overpay_cntct := x_nslds_perkins_overpay_cntct;
259 new_references.nslds_defaulted_loan_f := x_nslds_defaulted_loan_f;
260 new_references.nslds_dischged_loan_chng_f := x_nslds_dischged_loan_chng_f;
261 new_references.nslds_satis_repay_f := x_nslds_satis_repay_f;
262 new_references.nslds_act_bankruptcy_f := x_nslds_act_bankruptcy_f;
263 new_references.nslds_agg_subsz_out_prin_bal := x_nslds_agg_subsz_out_prin_bal;
264 new_references.nslds_agg_unsbz_out_prin_bal := x_nslds_agg_unsbz_out_prin_bal;
265 new_references.nslds_agg_comb_out_prin_bal := x_nslds_agg_comb_out_prin_bal;
266 new_references.nslds_agg_cons_out_prin_bal := x_nslds_agg_cons_out_prin_bal;
267 new_references.nslds_agg_subsz_pend_dismt := x_nslds_agg_subsz_pend_dismt;
268 new_references.nslds_agg_unsbz_pend_dismt := x_nslds_agg_unsbz_pend_dismt;
269 new_references.nslds_agg_comb_pend_dismt := x_nslds_agg_comb_pend_dismt;
270 new_references.nslds_agg_subsz_total := x_nslds_agg_subsz_total;
271 new_references.nslds_agg_unsbz_total := x_nslds_agg_unsbz_total;
272 new_references.nslds_agg_comb_total := x_nslds_agg_comb_total;
273 new_references.nslds_agg_consd_total := x_nslds_agg_consd_total;
274 new_references.nslds_perkins_out_bal := x_nslds_perkins_out_bal;
275 new_references.nslds_perkins_cur_yr_dismnt := x_nslds_perkins_cur_yr_dismnt;
276 new_references.nslds_default_loan_chng_f := x_nslds_default_loan_chng_f;
277 new_references.nslds_discharged_loan_f := x_nslds_discharged_loan_f;
278 new_references.nslds_satis_repay_chng_f := x_nslds_satis_repay_chng_f;
279 new_references.nslds_act_bnkrupt_chng_f := x_nslds_act_bnkrupt_chng_f;
280 new_references.nslds_overpay_chng_f := x_nslds_overpay_chng_f;
281 new_references.nslds_agg_loan_chng_f := x_nslds_agg_loan_chng_f;
282 new_references.nslds_perkins_loan_chng_f := x_nslds_perkins_loan_chng_f;
283 new_references.nslds_pell_paymnt_chng_f := x_nslds_pell_paymnt_chng_f;
284 new_references.nslds_addtnl_pell_f := x_nslds_addtnl_pell_f;
285 new_references.nslds_addtnl_loan_f := x_nslds_addtnl_loan_f;
286 new_references.direct_loan_mas_prom_nt_f := x_direct_loan_mas_prom_nt_f;
287 new_references.nslds_pell_seq_num_1 := x_nslds_pell_seq_num_1;
288 new_references.nslds_pell_verify_f_1 := x_nslds_pell_verify_f_1;
289 new_references.nslds_pell_efc_1 := x_nslds_pell_efc_1;
290 new_references.nslds_pell_school_code_1 := x_nslds_pell_school_code_1;
291 new_references.nslds_pell_transcn_num_1 := x_nslds_pell_transcn_num_1;
292 new_references.nslds_pell_last_updt_dt_1 := x_nslds_pell_last_updt_dt_1;
293 new_references.nslds_pell_scheduled_amt_1 := x_nslds_pell_scheduled_amt_1;
294 new_references.nslds_pell_amt_paid_todt_1 := x_nslds_pell_amt_paid_todt_1;
295 new_references.nslds_pell_remng_amt_1 := x_nslds_pell_remng_amt_1;
296 new_references.nslds_pell_pc_schd_awd_us_1 := x_nslds_pell_pc_schd_awd_us_1;
297 new_references.nslds_pell_award_amt_1 := x_nslds_pell_award_amt_1;
298 new_references.nslds_pell_seq_num_2 := x_nslds_pell_seq_num_2;
299 new_references.nslds_pell_verify_f_2 := x_nslds_pell_verify_f_2;
300 new_references.nslds_pell_efc_2 := x_nslds_pell_efc_2;
301 new_references.nslds_pell_school_code_2 := x_nslds_pell_school_code_2;
302 new_references.nslds_pell_transcn_num_2 := x_nslds_pell_transcn_num_2;
303 new_references.nslds_pell_last_updt_dt_2 := x_nslds_pell_last_updt_dt_2;
304 new_references.nslds_pell_scheduled_amt_2 := x_nslds_pell_scheduled_amt_2;
305 new_references.nslds_pell_amt_paid_todt_2 := x_nslds_pell_amt_paid_todt_2;
306 new_references.nslds_pell_remng_amt_2 := x_nslds_pell_remng_amt_2;
307 new_references.nslds_pell_pc_schd_awd_us_2 := x_nslds_pell_pc_schd_awd_us_2;
308 new_references.nslds_pell_award_amt_2 := x_nslds_pell_award_amt_2;
309 new_references.nslds_pell_seq_num_3 := x_nslds_pell_seq_num_3;
310 new_references.nslds_pell_verify_f_3 := x_nslds_pell_verify_f_3;
311 new_references.nslds_pell_efc_3 := x_nslds_pell_efc_3;
312 new_references.nslds_pell_school_code_3 := x_nslds_pell_school_code_3;
313 new_references.nslds_pell_transcn_num_3 := x_nslds_pell_transcn_num_3;
314 new_references.nslds_pell_last_updt_dt_3 := x_nslds_pell_last_updt_dt_3;
315 new_references.nslds_pell_scheduled_amt_3 := x_nslds_pell_scheduled_amt_3;
316 new_references.nslds_pell_amt_paid_todt_3 := x_nslds_pell_amt_paid_todt_3;
317 new_references.nslds_pell_remng_amt_3 := x_nslds_pell_remng_amt_3;
318 new_references.nslds_pell_pc_schd_awd_us_3 := x_nslds_pell_pc_schd_awd_us_3;
319 new_references.nslds_pell_award_amt_3 := x_nslds_pell_award_amt_3;
320 new_references.nslds_loan_seq_num_1 := x_nslds_loan_seq_num_1;
321 new_references.nslds_loan_type_code_1 := x_nslds_loan_type_code_1;
322 new_references.nslds_loan_chng_f_1 := x_nslds_loan_chng_f_1;
323 new_references.nslds_loan_prog_code_1 := x_nslds_loan_prog_code_1;
324 new_references.nslds_loan_net_amnt_1 := x_nslds_loan_net_amnt_1;
325 new_references.nslds_loan_cur_st_code_1 := x_nslds_loan_cur_st_code_1;
326 new_references.nslds_loan_cur_st_date_1 := x_nslds_loan_cur_st_date_1;
327 new_references.nslds_loan_agg_pr_bal_1 := x_nslds_loan_agg_pr_bal_1;
328 new_references.nslds_loan_out_pr_bal_dt_1 := x_nslds_loan_out_pr_bal_dt_1;
329 new_references.nslds_loan_begin_dt_1 := x_nslds_loan_begin_dt_1;
330 new_references.nslds_loan_end_dt_1 := x_nslds_loan_end_dt_1;
331 new_references.nslds_loan_ga_code_1 := x_nslds_loan_ga_code_1;
332 new_references.nslds_loan_cont_type_1 := x_nslds_loan_cont_type_1;
333 new_references.nslds_loan_schol_code_1 := x_nslds_loan_schol_code_1;
334 new_references.nslds_loan_cont_code_1 := x_nslds_loan_cont_code_1;
335 new_references.nslds_loan_grade_lvl_1 := x_nslds_loan_grade_lvl_1;
336 new_references.nslds_loan_xtr_unsbz_ln_f_1 := x_nslds_loan_xtr_unsbz_ln_f_1;
337 new_references.nslds_loan_capital_int_f_1 := x_nslds_loan_capital_int_f_1;
338 new_references.nslds_loan_seq_num_2 := x_nslds_loan_seq_num_2;
339 new_references.nslds_loan_type_code_2 := x_nslds_loan_type_code_2;
340 new_references.nslds_loan_chng_f_2 := x_nslds_loan_chng_f_2;
341 new_references.nslds_loan_prog_code_2 := x_nslds_loan_prog_code_2;
342 new_references.nslds_loan_net_amnt_2 := x_nslds_loan_net_amnt_2;
343 new_references.nslds_loan_cur_st_code_2 := x_nslds_loan_cur_st_code_2;
344 new_references.nslds_loan_cur_st_date_2 := x_nslds_loan_cur_st_date_2;
345 new_references.nslds_loan_agg_pr_bal_2 := x_nslds_loan_agg_pr_bal_2;
346 new_references.nslds_loan_out_pr_bal_dt_2 := x_nslds_loan_out_pr_bal_dt_2;
347 new_references.nslds_loan_begin_dt_2 := x_nslds_loan_begin_dt_2;
348 new_references.nslds_loan_end_dt_2 := x_nslds_loan_end_dt_2;
349 new_references.nslds_loan_ga_code_2 := x_nslds_loan_ga_code_2;
350 new_references.nslds_loan_cont_type_2 := x_nslds_loan_cont_type_2;
351 new_references.nslds_loan_schol_code_2 := x_nslds_loan_schol_code_2;
352 new_references.nslds_loan_cont_code_2 := x_nslds_loan_cont_code_2;
353 new_references.nslds_loan_grade_lvl_2 := x_nslds_loan_grade_lvl_2;
354 new_references.nslds_loan_xtr_unsbz_ln_f_2 := x_nslds_loan_xtr_unsbz_ln_f_2;
355 new_references.nslds_loan_capital_int_f_2 := x_nslds_loan_capital_int_f_2;
356 new_references.nslds_loan_seq_num_3 := x_nslds_loan_seq_num_3;
357 new_references.nslds_loan_type_code_3 := x_nslds_loan_type_code_3;
358 new_references.nslds_loan_chng_f_3 := x_nslds_loan_chng_f_3;
359 new_references.nslds_loan_prog_code_3 := x_nslds_loan_prog_code_3;
360 new_references.nslds_loan_net_amnt_3 := x_nslds_loan_net_amnt_3;
361 new_references.nslds_loan_cur_st_code_3 := x_nslds_loan_cur_st_code_3;
362 new_references.nslds_loan_cur_st_date_3 := x_nslds_loan_cur_st_date_3;
363 new_references.nslds_loan_agg_pr_bal_3 := x_nslds_loan_agg_pr_bal_3;
364 new_references.nslds_loan_out_pr_bal_dt_3 := x_nslds_loan_out_pr_bal_dt_3;
365 new_references.nslds_loan_begin_dt_3 := x_nslds_loan_begin_dt_3;
366 new_references.nslds_loan_end_dt_3 := x_nslds_loan_end_dt_3;
367 new_references.nslds_loan_ga_code_3 := x_nslds_loan_ga_code_3;
368 new_references.nslds_loan_cont_type_3 := x_nslds_loan_cont_type_3;
369 new_references.nslds_loan_schol_code_3 := x_nslds_loan_schol_code_3;
370 new_references.nslds_loan_cont_code_3 := x_nslds_loan_cont_code_3;
371 new_references.nslds_loan_grade_lvl_3 := x_nslds_loan_grade_lvl_3;
372 new_references.nslds_loan_xtr_unsbz_ln_f_3 := x_nslds_loan_xtr_unsbz_ln_f_3;
373 new_references.nslds_loan_capital_int_f_3 := x_nslds_loan_capital_int_f_3;
374 new_references.nslds_loan_seq_num_4 := x_nslds_loan_seq_num_4;
375 new_references.nslds_loan_type_code_4 := x_nslds_loan_type_code_4;
376 new_references.nslds_loan_chng_f_4 := x_nslds_loan_chng_f_4;
377 new_references.nslds_loan_prog_code_4 := x_nslds_loan_prog_code_4;
378 new_references.nslds_loan_net_amnt_4 := x_nslds_loan_net_amnt_4;
379 new_references.nslds_loan_cur_st_code_4 := x_nslds_loan_cur_st_code_4;
380 new_references.nslds_loan_cur_st_date_4 := x_nslds_loan_cur_st_date_4;
381 new_references.nslds_loan_agg_pr_bal_4 := x_nslds_loan_agg_pr_bal_4;
382 new_references.nslds_loan_out_pr_bal_dt_4 := x_nslds_loan_out_pr_bal_dt_4;
383 new_references.nslds_loan_begin_dt_4 := x_nslds_loan_begin_dt_4;
384 new_references.nslds_loan_end_dt_4 := x_nslds_loan_end_dt_4;
385 new_references.nslds_loan_ga_code_4 := x_nslds_loan_ga_code_4;
386 new_references.nslds_loan_cont_type_4 := x_nslds_loan_cont_type_4;
387 new_references.nslds_loan_schol_code_4 := x_nslds_loan_schol_code_4;
388 new_references.nslds_loan_cont_code_4 := x_nslds_loan_cont_code_4;
389 new_references.nslds_loan_grade_lvl_4 := x_nslds_loan_grade_lvl_4;
390 new_references.nslds_loan_xtr_unsbz_ln_f_4 := x_nslds_loan_xtr_unsbz_ln_f_4;
391 new_references.nslds_loan_capital_int_f_4 := x_nslds_loan_capital_int_f_4;
392 new_references.nslds_loan_seq_num_5 := x_nslds_loan_seq_num_5;
393 new_references.nslds_loan_type_code_5 := x_nslds_loan_type_code_5;
394 new_references.nslds_loan_chng_f_5 := x_nslds_loan_chng_f_5;
395 new_references.nslds_loan_prog_code_5 := x_nslds_loan_prog_code_5;
396 new_references.nslds_loan_net_amnt_5 := x_nslds_loan_net_amnt_5;
397 new_references.nslds_loan_cur_st_code_5 := x_nslds_loan_cur_st_code_5;
398 new_references.nslds_loan_cur_st_date_5 := x_nslds_loan_cur_st_date_5;
399 new_references.nslds_loan_agg_pr_bal_5 := x_nslds_loan_agg_pr_bal_5;
400 new_references.nslds_loan_out_pr_bal_dt_5 := x_nslds_loan_out_pr_bal_dt_5;
401 new_references.nslds_loan_begin_dt_5 := x_nslds_loan_begin_dt_5;
402 new_references.nslds_loan_end_dt_5 := x_nslds_loan_end_dt_5;
403 new_references.nslds_loan_ga_code_5 := x_nslds_loan_ga_code_5;
404 new_references.nslds_loan_cont_type_5 := x_nslds_loan_cont_type_5;
405 new_references.nslds_loan_schol_code_5 := x_nslds_loan_schol_code_5;
406 new_references.nslds_loan_cont_code_5 := x_nslds_loan_cont_code_5;
407 new_references.nslds_loan_grade_lvl_5 := x_nslds_loan_grade_lvl_5;
408 new_references.nslds_loan_xtr_unsbz_ln_f_5 := x_nslds_loan_xtr_unsbz_ln_f_5;
409 new_references.nslds_loan_capital_int_f_5 := x_nslds_loan_capital_int_f_5;
410 new_references.nslds_loan_seq_num_6 := x_nslds_loan_seq_num_6;
411 new_references.nslds_loan_type_code_6 := x_nslds_loan_type_code_6;
412 new_references.nslds_loan_chng_f_6 := x_nslds_loan_chng_f_6;
413 new_references.nslds_loan_prog_code_6 := x_nslds_loan_prog_code_6;
414 new_references.nslds_loan_net_amnt_6 := x_nslds_loan_net_amnt_6;
415 new_references.nslds_loan_cur_st_code_6 := x_nslds_loan_cur_st_code_6;
416 new_references.nslds_loan_cur_st_date_6 := x_nslds_loan_cur_st_date_6;
417 new_references.nslds_loan_agg_pr_bal_6 := x_nslds_loan_agg_pr_bal_6;
418 new_references.nslds_loan_out_pr_bal_dt_6 := x_nslds_loan_out_pr_bal_dt_6;
419 new_references.nslds_loan_begin_dt_6 := x_nslds_loan_begin_dt_6;
420 new_references.nslds_loan_end_dt_6 := x_nslds_loan_end_dt_6;
421 new_references.nslds_loan_ga_code_6 := x_nslds_loan_ga_code_6;
422 new_references.nslds_loan_cont_type_6 := x_nslds_loan_cont_type_6;
423 new_references.nslds_loan_schol_code_6 := x_nslds_loan_schol_code_6;
424 new_references.nslds_loan_cont_code_6 := x_nslds_loan_cont_code_6;
425 new_references.nslds_loan_grade_lvl_6 := x_nslds_loan_grade_lvl_6;
426 new_references.nslds_loan_xtr_unsbz_ln_f_6 := x_nslds_loan_xtr_unsbz_ln_f_6;
427 new_references.nslds_loan_capital_int_f_6 := x_nslds_loan_capital_int_f_6;
428 new_references.nslds_loan_last_d_amt_1 := x_nslds_loan_last_d_amt_1;
429 new_references.nslds_loan_last_d_date_1 := x_nslds_loan_last_d_date_1;
430 new_references.nslds_loan_last_d_amt_2 := x_nslds_loan_last_d_amt_2;
431 new_references.nslds_loan_last_d_date_2 := x_nslds_loan_last_d_date_2;
432 new_references.nslds_loan_last_d_amt_3 := x_nslds_loan_last_d_amt_3;
433 new_references.nslds_loan_last_d_date_3 := x_nslds_loan_last_d_date_3;
434 new_references.nslds_loan_last_d_amt_4 := x_nslds_loan_last_d_amt_4;
435 new_references.nslds_loan_last_d_date_4 := x_nslds_loan_last_d_date_4;
436 new_references.nslds_loan_last_d_amt_5 := x_nslds_loan_last_d_amt_5;
437 new_references.nslds_loan_last_d_date_5 := x_nslds_loan_last_d_date_5;
438 new_references.nslds_loan_last_d_amt_6 := x_nslds_loan_last_d_amt_6;
439 new_references.nslds_loan_last_d_date_6 := x_nslds_loan_last_d_date_6;
440 new_references.dlp_master_prom_note_flag := x_dlp_master_prom_note_flag;
441 new_references.subsidized_loan_limit_type := x_subsidized_loan_limit_type;
442 new_references.combined_loan_limit_type := x_combined_loan_limit_type;
443 new_references.transaction_num_txt := x_transaction_num_txt;
444
445 IF (p_action = 'UPDATE') THEN
446 new_references.creation_date := old_references.creation_date;
447 new_references.created_by := old_references.created_by;
448 ELSE
449 new_references.creation_date := x_creation_date;
450 new_references.created_by := x_created_by;
451 END IF;
452
453 new_references.last_update_date := x_last_update_date;
454 new_references.last_updated_by := x_last_updated_by;
455 new_references.last_update_login := x_last_update_login;
456
457 END set_column_values;
458
459
460 PROCEDURE check_parent_existance AS
461 /*
462 || Created By : rasingh
463 || Created On : 06-DEC-2000
464 || Purpose : Checks for the existance of Parent records.
465 || Known limitations, enhancements or remarks :
466 || Change History :
467 || Who When What
468 || (reverse chronological order - newest change first)
469 */
470 BEGIN
471
472 IF (((old_references.isir_id = new_references.isir_id)) OR
473 ((new_references.isir_id IS NULL))) THEN
474 NULL;
475 ELSIF NOT igf_ap_isir_matched_pkg.get_pk_for_validation (
476 new_references.isir_id
477 ) THEN
478 fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
479 igs_ge_msg_stack.add;
480 app_exception.raise_exception;
481 END IF;
482
483 END check_parent_existance;
484
485
486 FUNCTION get_pk_for_validation (
487 x_nslds_id IN NUMBER
488 ) RETURN BOOLEAN AS
489 /*
490 || Created By : rasingh
491 || Created On : 06-DEC-2000
492 || Purpose : Validates the Primary Key of the table.
493 || Known limitations, enhancements or remarks :
494 || Change History :
495 || Who When What
496 || (reverse chronological order - newest change first)
497 */
498 CURSOR cur_rowid IS
499 SELECT rowid
500 FROM igf_ap_nslds_data_all
501 WHERE nslds_id = x_nslds_id
502 FOR UPDATE NOWAIT;
503
504 lv_rowid cur_rowid%RowType;
505
506 BEGIN
507
508 OPEN cur_rowid;
509 FETCH cur_rowid INTO lv_rowid;
510 IF (cur_rowid%FOUND) THEN
511 CLOSE cur_rowid;
512 RETURN(TRUE);
513 ELSE
514 CLOSE cur_rowid;
515 RETURN(FALSE);
516 END IF;
517
518 END get_pk_for_validation;
519
520
521 PROCEDURE get_fk_igf_ap_isir_matched (
522 x_isir_id IN NUMBER
523 ) AS
524 /*
525 || Created By : rasingh
526 || Created On : 06-DEC-2000
527 || Purpose : Validates the Foreign Keys for the table.
528 || Known limitations, enhancements or remarks :
529 || Change History :
530 || Who When What
531 || (reverse chronological order - newest change first)
532 */
533 CURSOR cur_rowid IS
534 SELECT rowid
535 FROM igf_ap_nslds_data_all
536 WHERE ((isir_id = x_isir_id));
537
538 lv_rowid cur_rowid%RowType;
539
540 BEGIN
541
542 OPEN cur_rowid;
543 FETCH cur_rowid INTO lv_rowid;
544 IF (cur_rowid%FOUND) THEN
545 CLOSE cur_rowid;
546 fnd_message.set_name ('IGS', 'IGF_AP_NSLDS_ISIR_FK');
547 igs_ge_msg_stack.add;
548 app_exception.raise_exception;
549 RETURN;
550 END IF;
551 CLOSE cur_rowid;
552
553 END get_fk_igf_ap_isir_matched;
554
555
556 PROCEDURE before_dml (
557 p_action IN VARCHAR2,
558 x_rowid IN VARCHAR2,
559 x_nslds_id IN NUMBER ,
560 x_isir_id IN NUMBER ,
561 x_base_id IN NUMBER ,
562 x_nslds_transaction_num IN NUMBER ,
563 x_nslds_database_results_f IN VARCHAR2,
564 x_nslds_f IN VARCHAR2,
565 x_nslds_pell_overpay_f IN VARCHAR2,
566 x_nslds_pell_overpay_contact IN VARCHAR2,
567 x_nslds_seog_overpay_f IN VARCHAR2,
568 x_nslds_seog_overpay_contact IN VARCHAR2,
569 x_nslds_perkins_overpay_f IN VARCHAR2,
570 x_nslds_perkins_overpay_cntct IN VARCHAR2,
571 x_nslds_defaulted_loan_f IN VARCHAR2,
572 x_nslds_dischged_loan_chng_f IN VARCHAR2,
573 x_nslds_satis_repay_f IN VARCHAR2,
574 x_nslds_act_bankruptcy_f IN VARCHAR2,
575 x_nslds_agg_subsz_out_prin_bal IN NUMBER ,
576 x_nslds_agg_unsbz_out_prin_bal IN NUMBER ,
577 x_nslds_agg_comb_out_prin_bal IN NUMBER ,
578 x_nslds_agg_cons_out_prin_bal IN NUMBER ,
579 x_nslds_agg_subsz_pend_dismt IN NUMBER ,
580 x_nslds_agg_unsbz_pend_dismt IN NUMBER ,
581 x_nslds_agg_comb_pend_dismt IN NUMBER ,
582 x_nslds_agg_subsz_total IN NUMBER ,
583 x_nslds_agg_unsbz_total IN NUMBER ,
584 x_nslds_agg_comb_total IN NUMBER ,
585 x_nslds_agg_consd_total IN NUMBER ,
586 x_nslds_perkins_out_bal IN NUMBER ,
587 x_nslds_perkins_cur_yr_dismnt IN NUMBER ,
588 x_nslds_default_loan_chng_f IN VARCHAR2,
589 x_nslds_discharged_loan_f IN VARCHAR2,
590 x_nslds_satis_repay_chng_f IN VARCHAR2,
591 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
592 x_nslds_overpay_chng_f IN VARCHAR2,
593 x_nslds_agg_loan_chng_f IN VARCHAR2,
594 x_nslds_perkins_loan_chng_f IN VARCHAR2,
595 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
596 x_nslds_addtnl_pell_f IN VARCHAR2,
597 x_nslds_addtnl_loan_f IN VARCHAR2,
598 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
599 x_nslds_pell_seq_num_1 IN NUMBER ,
600 x_nslds_pell_verify_f_1 IN VARCHAR2,
601 x_nslds_pell_efc_1 IN NUMBER ,
602 x_nslds_pell_school_code_1 IN NUMBER ,
603 x_nslds_pell_transcn_num_1 IN NUMBER ,
604 x_nslds_pell_last_updt_dt_1 IN DATE ,
605 x_nslds_pell_scheduled_amt_1 IN NUMBER ,
606 x_nslds_pell_amt_paid_todt_1 IN NUMBER ,
607 x_nslds_pell_remng_amt_1 IN NUMBER ,
608 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER ,
609 x_nslds_pell_award_amt_1 IN NUMBER ,
610 x_nslds_pell_seq_num_2 IN NUMBER ,
611 x_nslds_pell_verify_f_2 IN VARCHAR2,
612 x_nslds_pell_efc_2 IN NUMBER ,
613 x_nslds_pell_school_code_2 IN NUMBER ,
614 x_nslds_pell_transcn_num_2 IN NUMBER ,
615 x_nslds_pell_last_updt_dt_2 IN DATE ,
616 x_nslds_pell_scheduled_amt_2 IN NUMBER ,
617 x_nslds_pell_amt_paid_todt_2 IN NUMBER ,
618 x_nslds_pell_remng_amt_2 IN NUMBER ,
619 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER ,
620 x_nslds_pell_award_amt_2 IN NUMBER ,
621 x_nslds_pell_seq_num_3 IN NUMBER ,
622 x_nslds_pell_verify_f_3 IN VARCHAR2,
623 x_nslds_pell_efc_3 IN NUMBER ,
624 x_nslds_pell_school_code_3 IN NUMBER ,
625 x_nslds_pell_transcn_num_3 IN NUMBER ,
626 x_nslds_pell_last_updt_dt_3 IN DATE ,
627 x_nslds_pell_scheduled_amt_3 IN NUMBER ,
628 x_nslds_pell_amt_paid_todt_3 IN NUMBER ,
629 x_nslds_pell_remng_amt_3 IN NUMBER ,
630 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER ,
631 x_nslds_pell_award_amt_3 IN NUMBER ,
632 x_nslds_loan_seq_num_1 IN NUMBER ,
633 x_nslds_loan_type_code_1 IN VARCHAR2,
634 x_nslds_loan_chng_f_1 IN VARCHAR2,
635 x_nslds_loan_prog_code_1 IN VARCHAR2,
636 x_nslds_loan_net_amnt_1 IN NUMBER ,
637 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
638 x_nslds_loan_cur_st_date_1 IN DATE ,
639 x_nslds_loan_agg_pr_bal_1 IN NUMBER ,
640 x_nslds_loan_out_pr_bal_dt_1 IN DATE ,
641 x_nslds_loan_begin_dt_1 IN DATE ,
642 x_nslds_loan_end_dt_1 IN DATE ,
643 x_nslds_loan_ga_code_1 IN VARCHAR2,
644 x_nslds_loan_cont_type_1 IN VARCHAR2,
645 x_nslds_loan_schol_code_1 IN VARCHAR2,
646 x_nslds_loan_cont_code_1 IN VARCHAR2,
647 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
648 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
649 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
650 x_nslds_loan_seq_num_2 IN NUMBER ,
651 x_nslds_loan_type_code_2 IN VARCHAR2,
652 x_nslds_loan_chng_f_2 IN VARCHAR2,
653 x_nslds_loan_prog_code_2 IN VARCHAR2,
654 x_nslds_loan_net_amnt_2 IN NUMBER ,
655 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
656 x_nslds_loan_cur_st_date_2 IN DATE ,
657 x_nslds_loan_agg_pr_bal_2 IN NUMBER ,
658 x_nslds_loan_out_pr_bal_dt_2 IN DATE ,
659 x_nslds_loan_begin_dt_2 IN DATE ,
660 x_nslds_loan_end_dt_2 IN DATE ,
661 x_nslds_loan_ga_code_2 IN VARCHAR2,
662 x_nslds_loan_cont_type_2 IN VARCHAR2,
663 x_nslds_loan_schol_code_2 IN VARCHAR2,
664 x_nslds_loan_cont_code_2 IN VARCHAR2,
665 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
666 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
667 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
668 x_nslds_loan_seq_num_3 IN NUMBER ,
669 x_nslds_loan_type_code_3 IN VARCHAR2,
670 x_nslds_loan_chng_f_3 IN VARCHAR2,
671 x_nslds_loan_prog_code_3 IN VARCHAR2,
672 x_nslds_loan_net_amnt_3 IN NUMBER ,
673 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
674 x_nslds_loan_cur_st_date_3 IN DATE ,
675 x_nslds_loan_agg_pr_bal_3 IN NUMBER ,
676 x_nslds_loan_out_pr_bal_dt_3 IN DATE ,
677 x_nslds_loan_begin_dt_3 IN DATE ,
678 x_nslds_loan_end_dt_3 IN DATE ,
679 x_nslds_loan_ga_code_3 IN VARCHAR2,
680 x_nslds_loan_cont_type_3 IN VARCHAR2,
681 x_nslds_loan_schol_code_3 IN VARCHAR2,
682 x_nslds_loan_cont_code_3 IN VARCHAR2,
683 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
684 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
685 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
686 x_nslds_loan_seq_num_4 IN NUMBER ,
687 x_nslds_loan_type_code_4 IN VARCHAR2,
688 x_nslds_loan_chng_f_4 IN VARCHAR2,
689 x_nslds_loan_prog_code_4 IN VARCHAR2,
690 x_nslds_loan_net_amnt_4 IN NUMBER ,
691 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
692 x_nslds_loan_cur_st_date_4 IN DATE ,
693 x_nslds_loan_agg_pr_bal_4 IN NUMBER ,
694 x_nslds_loan_out_pr_bal_dt_4 IN DATE ,
695 x_nslds_loan_begin_dt_4 IN DATE ,
696 x_nslds_loan_end_dt_4 IN DATE ,
697 x_nslds_loan_ga_code_4 IN VARCHAR2,
698 x_nslds_loan_cont_type_4 IN VARCHAR2,
699 x_nslds_loan_schol_code_4 IN VARCHAR2,
700 x_nslds_loan_cont_code_4 IN VARCHAR2,
701 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
702 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
703 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
704 x_nslds_loan_seq_num_5 IN NUMBER ,
705 x_nslds_loan_type_code_5 IN VARCHAR2,
706 x_nslds_loan_chng_f_5 IN VARCHAR2,
707 x_nslds_loan_prog_code_5 IN VARCHAR2,
708 x_nslds_loan_net_amnt_5 IN NUMBER ,
709 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
710 x_nslds_loan_cur_st_date_5 IN DATE ,
711 x_nslds_loan_agg_pr_bal_5 IN NUMBER ,
712 x_nslds_loan_out_pr_bal_dt_5 IN DATE ,
713 x_nslds_loan_begin_dt_5 IN DATE ,
714 x_nslds_loan_end_dt_5 IN DATE ,
715 x_nslds_loan_ga_code_5 IN VARCHAR2,
716 x_nslds_loan_cont_type_5 IN VARCHAR2,
717 x_nslds_loan_schol_code_5 IN VARCHAR2,
718 x_nslds_loan_cont_code_5 IN VARCHAR2,
719 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
720 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
721 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
722 x_nslds_loan_seq_num_6 IN NUMBER ,
723 x_nslds_loan_type_code_6 IN VARCHAR2,
724 x_nslds_loan_chng_f_6 IN VARCHAR2,
725 x_nslds_loan_prog_code_6 IN VARCHAR2,
726 x_nslds_loan_net_amnt_6 IN NUMBER ,
727 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
728 x_nslds_loan_cur_st_date_6 IN DATE ,
729 x_nslds_loan_agg_pr_bal_6 IN NUMBER ,
730 x_nslds_loan_out_pr_bal_dt_6 IN DATE ,
731 x_nslds_loan_begin_dt_6 IN DATE ,
732 x_nslds_loan_end_dt_6 IN DATE ,
733 x_nslds_loan_ga_code_6 IN VARCHAR2,
734 x_nslds_loan_cont_type_6 IN VARCHAR2,
735 x_nslds_loan_schol_code_6 IN VARCHAR2,
736 x_nslds_loan_cont_code_6 IN VARCHAR2,
737 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
738 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
739 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
740 x_nslds_loan_last_d_amt_1 IN NUMBER ,
741 x_nslds_loan_last_d_date_1 IN DATE ,
742 x_nslds_loan_last_d_amt_2 IN NUMBER ,
743 x_nslds_loan_last_d_date_2 IN DATE ,
744 x_nslds_loan_last_d_amt_3 IN NUMBER ,
745 x_nslds_loan_last_d_date_3 IN DATE ,
746 x_nslds_loan_last_d_amt_4 IN NUMBER ,
747 x_nslds_loan_last_d_date_4 IN DATE ,
748 x_nslds_loan_last_d_amt_5 IN NUMBER ,
749 x_nslds_loan_last_d_date_5 IN DATE ,
750 x_nslds_loan_last_d_amt_6 IN NUMBER ,
751 x_nslds_loan_last_d_date_6 IN DATE ,
752 x_creation_date IN DATE ,
753 x_created_by IN NUMBER ,
754 x_last_update_date IN DATE ,
755 x_last_updated_by IN NUMBER ,
756 x_last_update_login IN NUMBER ,
757 x_dlp_master_prom_note_flag IN VARCHAR2,
758 x_subsidized_loan_limit_type IN VARCHAR2,
759 x_combined_loan_limit_type IN VARCHAR2,
760 x_transaction_num_txt IN VARCHAR2
761 ) AS
762 /*
763 || Created By : rasingh
764 || Created On : 06-DEC-2000
765 || Purpose : Initialises the columns, Checks Constraints, Calls the
766 || Trigger Handlers for the table, before any DML operation.
767 || Known limitations, enhancements or remarks :
768 || Change History :
769 || Who When What
770 || (reverse chronological order - newest change first)
771 */
772 BEGIN
773
774 set_column_values (
775 p_action,
776 x_rowid,
777 x_nslds_id,
778 x_isir_id,
779 x_base_id,
780 x_nslds_transaction_num,
781 x_nslds_database_results_f,
782 x_nslds_f,
783 x_nslds_pell_overpay_f,
784 x_nslds_pell_overpay_contact,
785 x_nslds_seog_overpay_f,
786 x_nslds_seog_overpay_contact,
787 x_nslds_perkins_overpay_f,
788 x_nslds_perkins_overpay_cntct,
789 x_nslds_defaulted_loan_f,
790 x_nslds_dischged_loan_chng_f,
791 x_nslds_satis_repay_f,
792 x_nslds_act_bankruptcy_f,
793 x_nslds_agg_subsz_out_prin_bal,
794 x_nslds_agg_unsbz_out_prin_bal,
795 x_nslds_agg_comb_out_prin_bal,
796 x_nslds_agg_cons_out_prin_bal,
797 x_nslds_agg_subsz_pend_dismt,
798 x_nslds_agg_unsbz_pend_dismt,
799 x_nslds_agg_comb_pend_dismt,
800 x_nslds_agg_subsz_total,
801 x_nslds_agg_unsbz_total,
802 x_nslds_agg_comb_total,
803 x_nslds_agg_consd_total,
804 x_nslds_perkins_out_bal,
805 x_nslds_perkins_cur_yr_dismnt,
806 x_nslds_default_loan_chng_f,
807 x_nslds_discharged_loan_f,
808 x_nslds_satis_repay_chng_f,
809 x_nslds_act_bnkrupt_chng_f,
810 x_nslds_overpay_chng_f,
811 x_nslds_agg_loan_chng_f,
812 x_nslds_perkins_loan_chng_f,
813 x_nslds_pell_paymnt_chng_f,
814 x_nslds_addtnl_pell_f,
815 x_nslds_addtnl_loan_f,
816 x_direct_loan_mas_prom_nt_f,
817 x_nslds_pell_seq_num_1,
818 x_nslds_pell_verify_f_1,
819 x_nslds_pell_efc_1,
820 x_nslds_pell_school_code_1,
821 x_nslds_pell_transcn_num_1,
822 x_nslds_pell_last_updt_dt_1,
823 x_nslds_pell_scheduled_amt_1,
824 x_nslds_pell_amt_paid_todt_1,
825 x_nslds_pell_remng_amt_1,
826 x_nslds_pell_pc_schd_awd_us_1,
827 x_nslds_pell_award_amt_1,
828 x_nslds_pell_seq_num_2,
829 x_nslds_pell_verify_f_2,
830 x_nslds_pell_efc_2,
831 x_nslds_pell_school_code_2,
832 x_nslds_pell_transcn_num_2,
833 x_nslds_pell_last_updt_dt_2,
834 x_nslds_pell_scheduled_amt_2,
835 x_nslds_pell_amt_paid_todt_2,
836 x_nslds_pell_remng_amt_2,
837 x_nslds_pell_pc_schd_awd_us_2,
838 x_nslds_pell_award_amt_2,
839 x_nslds_pell_seq_num_3,
840 x_nslds_pell_verify_f_3,
841 x_nslds_pell_efc_3,
842 x_nslds_pell_school_code_3,
843 x_nslds_pell_transcn_num_3,
844 x_nslds_pell_last_updt_dt_3,
845 x_nslds_pell_scheduled_amt_3,
846 x_nslds_pell_amt_paid_todt_3,
847 x_nslds_pell_remng_amt_3,
848 x_nslds_pell_pc_schd_awd_us_3,
849 x_nslds_pell_award_amt_3,
850 x_nslds_loan_seq_num_1,
851 x_nslds_loan_type_code_1,
852 x_nslds_loan_chng_f_1,
853 x_nslds_loan_prog_code_1,
854 x_nslds_loan_net_amnt_1,
855 x_nslds_loan_cur_st_code_1,
856 x_nslds_loan_cur_st_date_1,
857 x_nslds_loan_agg_pr_bal_1,
858 x_nslds_loan_out_pr_bal_dt_1,
859 x_nslds_loan_begin_dt_1,
860 x_nslds_loan_end_dt_1,
861 x_nslds_loan_ga_code_1,
862 x_nslds_loan_cont_type_1,
863 x_nslds_loan_schol_code_1,
864 x_nslds_loan_cont_code_1,
865 x_nslds_loan_grade_lvl_1,
866 x_nslds_loan_xtr_unsbz_ln_f_1,
867 x_nslds_loan_capital_int_f_1,
868 x_nslds_loan_seq_num_2,
869 x_nslds_loan_type_code_2,
870 x_nslds_loan_chng_f_2,
871 x_nslds_loan_prog_code_2,
872 x_nslds_loan_net_amnt_2,
873 x_nslds_loan_cur_st_code_2,
874 x_nslds_loan_cur_st_date_2,
875 x_nslds_loan_agg_pr_bal_2,
876 x_nslds_loan_out_pr_bal_dt_2,
877 x_nslds_loan_begin_dt_2,
878 x_nslds_loan_end_dt_2,
879 x_nslds_loan_ga_code_2,
880 x_nslds_loan_cont_type_2,
881 x_nslds_loan_schol_code_2,
882 x_nslds_loan_cont_code_2,
883 x_nslds_loan_grade_lvl_2,
884 x_nslds_loan_xtr_unsbz_ln_f_2,
885 x_nslds_loan_capital_int_f_2,
886 x_nslds_loan_seq_num_3,
887 x_nslds_loan_type_code_3,
888 x_nslds_loan_chng_f_3,
889 x_nslds_loan_prog_code_3,
890 x_nslds_loan_net_amnt_3,
891 x_nslds_loan_cur_st_code_3,
892 x_nslds_loan_cur_st_date_3,
893 x_nslds_loan_agg_pr_bal_3,
894 x_nslds_loan_out_pr_bal_dt_3,
895 x_nslds_loan_begin_dt_3,
896 x_nslds_loan_end_dt_3,
897 x_nslds_loan_ga_code_3,
898 x_nslds_loan_cont_type_3,
899 x_nslds_loan_schol_code_3,
900 x_nslds_loan_cont_code_3,
901 x_nslds_loan_grade_lvl_3,
902 x_nslds_loan_xtr_unsbz_ln_f_3,
903 x_nslds_loan_capital_int_f_3,
904 x_nslds_loan_seq_num_4,
905 x_nslds_loan_type_code_4,
906 x_nslds_loan_chng_f_4,
907 x_nslds_loan_prog_code_4,
908 x_nslds_loan_net_amnt_4,
909 x_nslds_loan_cur_st_code_4,
910 x_nslds_loan_cur_st_date_4,
911 x_nslds_loan_agg_pr_bal_4,
912 x_nslds_loan_out_pr_bal_dt_4,
913 x_nslds_loan_begin_dt_4,
914 x_nslds_loan_end_dt_4,
915 x_nslds_loan_ga_code_4,
916 x_nslds_loan_cont_type_4,
917 x_nslds_loan_schol_code_4,
918 x_nslds_loan_cont_code_4,
919 x_nslds_loan_grade_lvl_4,
920 x_nslds_loan_xtr_unsbz_ln_f_4,
921 x_nslds_loan_capital_int_f_4,
922 x_nslds_loan_seq_num_5,
923 x_nslds_loan_type_code_5,
924 x_nslds_loan_chng_f_5,
925 x_nslds_loan_prog_code_5,
926 x_nslds_loan_net_amnt_5,
927 x_nslds_loan_cur_st_code_5,
928 x_nslds_loan_cur_st_date_5,
929 x_nslds_loan_agg_pr_bal_5,
930 x_nslds_loan_out_pr_bal_dt_5,
931 x_nslds_loan_begin_dt_5,
932 x_nslds_loan_end_dt_5,
933 x_nslds_loan_ga_code_5,
934 x_nslds_loan_cont_type_5,
935 x_nslds_loan_schol_code_5,
936 x_nslds_loan_cont_code_5,
937 x_nslds_loan_grade_lvl_5,
938 x_nslds_loan_xtr_unsbz_ln_f_5,
939 x_nslds_loan_capital_int_f_5,
940 x_nslds_loan_seq_num_6,
941 x_nslds_loan_type_code_6,
942 x_nslds_loan_chng_f_6,
943 x_nslds_loan_prog_code_6,
944 x_nslds_loan_net_amnt_6,
945 x_nslds_loan_cur_st_code_6,
946 x_nslds_loan_cur_st_date_6,
947 x_nslds_loan_agg_pr_bal_6,
948 x_nslds_loan_out_pr_bal_dt_6,
949 x_nslds_loan_begin_dt_6,
950 x_nslds_loan_end_dt_6,
951 x_nslds_loan_ga_code_6,
952 x_nslds_loan_cont_type_6,
953 x_nslds_loan_schol_code_6,
954 x_nslds_loan_cont_code_6,
955 x_nslds_loan_grade_lvl_6,
956 x_nslds_loan_xtr_unsbz_ln_f_6,
957 x_nslds_loan_capital_int_f_6,
958 x_nslds_loan_last_d_amt_1,
959 x_nslds_loan_last_d_date_1,
960 x_nslds_loan_last_d_amt_2,
961 x_nslds_loan_last_d_date_2,
962 x_nslds_loan_last_d_amt_3,
963 x_nslds_loan_last_d_date_3,
964 x_nslds_loan_last_d_amt_4,
965 x_nslds_loan_last_d_date_4,
966 x_nslds_loan_last_d_amt_5,
967 x_nslds_loan_last_d_date_5,
968 x_nslds_loan_last_d_amt_6,
969 x_nslds_loan_last_d_date_6,
970 x_creation_date,
971 x_created_by,
972 x_last_update_date,
973 x_last_updated_by,
974 x_last_update_login,
975 x_dlp_master_prom_note_flag,
976 x_subsidized_loan_limit_type,
977 x_combined_loan_limit_type,
978 x_transaction_num_txt
979 );
980
981 IF (p_action = 'INSERT') THEN
982 -- Call all the procedures related to Before Insert.
983 IF ( get_pk_for_validation(
984 new_references.nslds_id
985 )
986 ) THEN
987 fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
988 igs_ge_msg_stack.add;
989 app_exception.raise_exception;
990 END IF;
991 check_parent_existance;
992 ELSIF (p_action = 'UPDATE') THEN
993 -- Call all the procedures related to Before Update.
994 check_parent_existance;
995 ELSIF (p_action = 'VALIDATE_INSERT') THEN
996 -- Call all the procedures related to Before Insert.
997 IF ( get_pk_for_validation (
998 new_references.nslds_id
999 )
1000 ) THEN
1001 fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1002 igs_ge_msg_stack.add;
1003 app_exception.raise_exception;
1004 END IF;
1005 END IF;
1006
1007 END before_dml;
1008
1009
1010 PROCEDURE insert_row (
1011 x_rowid IN OUT NOCOPY VARCHAR2,
1012 x_nslds_id IN OUT NOCOPY NUMBER,
1013 x_isir_id IN NUMBER,
1014 x_base_id IN NUMBER,
1015 x_nslds_transaction_num IN NUMBER,
1016 x_nslds_database_results_f IN VARCHAR2,
1017 x_nslds_f IN VARCHAR2,
1018 x_nslds_pell_overpay_f IN VARCHAR2,
1019 x_nslds_pell_overpay_contact IN VARCHAR2,
1020 x_nslds_seog_overpay_f IN VARCHAR2,
1021 x_nslds_seog_overpay_contact IN VARCHAR2,
1022 x_nslds_perkins_overpay_f IN VARCHAR2,
1023 x_nslds_perkins_overpay_cntct IN VARCHAR2,
1024 x_nslds_defaulted_loan_f IN VARCHAR2,
1025 x_nslds_dischged_loan_chng_f IN VARCHAR2,
1026 x_nslds_satis_repay_f IN VARCHAR2,
1027 x_nslds_act_bankruptcy_f IN VARCHAR2,
1028 x_nslds_agg_subsz_out_prin_bal IN NUMBER,
1029 x_nslds_agg_unsbz_out_prin_bal IN NUMBER,
1030 x_nslds_agg_comb_out_prin_bal IN NUMBER,
1031 x_nslds_agg_cons_out_prin_bal IN NUMBER,
1032 x_nslds_agg_subsz_pend_dismt IN NUMBER,
1033 x_nslds_agg_unsbz_pend_dismt IN NUMBER,
1034 x_nslds_agg_comb_pend_dismt IN NUMBER,
1035 x_nslds_agg_subsz_total IN NUMBER,
1036 x_nslds_agg_unsbz_total IN NUMBER,
1037 x_nslds_agg_comb_total IN NUMBER,
1038 x_nslds_agg_consd_total IN NUMBER,
1039 x_nslds_perkins_out_bal IN NUMBER,
1040 x_nslds_perkins_cur_yr_dismnt IN NUMBER,
1041 x_nslds_default_loan_chng_f IN VARCHAR2,
1042 x_nslds_discharged_loan_f IN VARCHAR2,
1043 x_nslds_satis_repay_chng_f IN VARCHAR2,
1044 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
1045 x_nslds_overpay_chng_f IN VARCHAR2,
1046 x_nslds_agg_loan_chng_f IN VARCHAR2,
1047 x_nslds_perkins_loan_chng_f IN VARCHAR2,
1048 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
1049 x_nslds_addtnl_pell_f IN VARCHAR2,
1050 x_nslds_addtnl_loan_f IN VARCHAR2,
1051 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
1052 x_nslds_pell_seq_num_1 IN NUMBER,
1053 x_nslds_pell_verify_f_1 IN VARCHAR2,
1054 x_nslds_pell_efc_1 IN NUMBER,
1055 x_nslds_pell_school_code_1 IN NUMBER,
1056 x_nslds_pell_transcn_num_1 IN NUMBER,
1057 x_nslds_pell_last_updt_dt_1 IN DATE,
1058 x_nslds_pell_scheduled_amt_1 IN NUMBER,
1059 x_nslds_pell_amt_paid_todt_1 IN NUMBER,
1060 x_nslds_pell_remng_amt_1 IN NUMBER,
1061 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER,
1062 x_nslds_pell_award_amt_1 IN NUMBER,
1063 x_nslds_pell_seq_num_2 IN NUMBER,
1064 x_nslds_pell_verify_f_2 IN VARCHAR2,
1065 x_nslds_pell_efc_2 IN NUMBER,
1066 x_nslds_pell_school_code_2 IN NUMBER,
1067 x_nslds_pell_transcn_num_2 IN NUMBER,
1068 x_nslds_pell_last_updt_dt_2 IN DATE,
1069 x_nslds_pell_scheduled_amt_2 IN NUMBER,
1070 x_nslds_pell_amt_paid_todt_2 IN NUMBER,
1071 x_nslds_pell_remng_amt_2 IN NUMBER,
1072 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER,
1073 x_nslds_pell_award_amt_2 IN NUMBER,
1074 x_nslds_pell_seq_num_3 IN NUMBER,
1075 x_nslds_pell_verify_f_3 IN VARCHAR2,
1076 x_nslds_pell_efc_3 IN NUMBER,
1077 x_nslds_pell_school_code_3 IN NUMBER,
1078 x_nslds_pell_transcn_num_3 IN NUMBER,
1079 x_nslds_pell_last_updt_dt_3 IN DATE,
1080 x_nslds_pell_scheduled_amt_3 IN NUMBER,
1081 x_nslds_pell_amt_paid_todt_3 IN NUMBER,
1082 x_nslds_pell_remng_amt_3 IN NUMBER,
1083 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER,
1084 x_nslds_pell_award_amt_3 IN NUMBER,
1085 x_nslds_loan_seq_num_1 IN NUMBER,
1086 x_nslds_loan_type_code_1 IN VARCHAR2,
1087 x_nslds_loan_chng_f_1 IN VARCHAR2,
1088 x_nslds_loan_prog_code_1 IN VARCHAR2,
1089 x_nslds_loan_net_amnt_1 IN NUMBER,
1090 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
1091 x_nslds_loan_cur_st_date_1 IN DATE,
1092 x_nslds_loan_agg_pr_bal_1 IN NUMBER,
1093 x_nslds_loan_out_pr_bal_dt_1 IN DATE,
1094 x_nslds_loan_begin_dt_1 IN DATE,
1095 x_nslds_loan_end_dt_1 IN DATE,
1096 x_nslds_loan_ga_code_1 IN VARCHAR2,
1097 x_nslds_loan_cont_type_1 IN VARCHAR2,
1098 x_nslds_loan_schol_code_1 IN VARCHAR2,
1099 x_nslds_loan_cont_code_1 IN VARCHAR2,
1100 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
1101 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
1102 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
1103 x_nslds_loan_seq_num_2 IN NUMBER,
1104 x_nslds_loan_type_code_2 IN VARCHAR2,
1105 x_nslds_loan_chng_f_2 IN VARCHAR2,
1106 x_nslds_loan_prog_code_2 IN VARCHAR2,
1107 x_nslds_loan_net_amnt_2 IN NUMBER,
1108 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
1109 x_nslds_loan_cur_st_date_2 IN DATE,
1110 x_nslds_loan_agg_pr_bal_2 IN NUMBER,
1111 x_nslds_loan_out_pr_bal_dt_2 IN DATE,
1112 x_nslds_loan_begin_dt_2 IN DATE,
1113 x_nslds_loan_end_dt_2 IN DATE,
1114 x_nslds_loan_ga_code_2 IN VARCHAR2,
1115 x_nslds_loan_cont_type_2 IN VARCHAR2,
1116 x_nslds_loan_schol_code_2 IN VARCHAR2,
1117 x_nslds_loan_cont_code_2 IN VARCHAR2,
1118 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
1119 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
1120 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
1121 x_nslds_loan_seq_num_3 IN NUMBER,
1122 x_nslds_loan_type_code_3 IN VARCHAR2,
1123 x_nslds_loan_chng_f_3 IN VARCHAR2,
1124 x_nslds_loan_prog_code_3 IN VARCHAR2,
1125 x_nslds_loan_net_amnt_3 IN NUMBER,
1126 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
1127 x_nslds_loan_cur_st_date_3 IN DATE,
1128 x_nslds_loan_agg_pr_bal_3 IN NUMBER,
1129 x_nslds_loan_out_pr_bal_dt_3 IN DATE,
1130 x_nslds_loan_begin_dt_3 IN DATE,
1131 x_nslds_loan_end_dt_3 IN DATE,
1132 x_nslds_loan_ga_code_3 IN VARCHAR2,
1133 x_nslds_loan_cont_type_3 IN VARCHAR2,
1134 x_nslds_loan_schol_code_3 IN VARCHAR2,
1135 x_nslds_loan_cont_code_3 IN VARCHAR2,
1136 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
1137 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
1138 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
1139 x_nslds_loan_seq_num_4 IN NUMBER,
1140 x_nslds_loan_type_code_4 IN VARCHAR2,
1141 x_nslds_loan_chng_f_4 IN VARCHAR2,
1142 x_nslds_loan_prog_code_4 IN VARCHAR2,
1143 x_nslds_loan_net_amnt_4 IN NUMBER,
1144 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
1145 x_nslds_loan_cur_st_date_4 IN DATE,
1146 x_nslds_loan_agg_pr_bal_4 IN NUMBER,
1147 x_nslds_loan_out_pr_bal_dt_4 IN DATE,
1148 x_nslds_loan_begin_dt_4 IN DATE,
1149 x_nslds_loan_end_dt_4 IN DATE,
1150 x_nslds_loan_ga_code_4 IN VARCHAR2,
1151 x_nslds_loan_cont_type_4 IN VARCHAR2,
1152 x_nslds_loan_schol_code_4 IN VARCHAR2,
1153 x_nslds_loan_cont_code_4 IN VARCHAR2,
1154 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
1155 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
1156 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
1157 x_nslds_loan_seq_num_5 IN NUMBER,
1158 x_nslds_loan_type_code_5 IN VARCHAR2,
1159 x_nslds_loan_chng_f_5 IN VARCHAR2,
1160 x_nslds_loan_prog_code_5 IN VARCHAR2,
1161 x_nslds_loan_net_amnt_5 IN NUMBER,
1162 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
1163 x_nslds_loan_cur_st_date_5 IN DATE,
1164 x_nslds_loan_agg_pr_bal_5 IN NUMBER,
1165 x_nslds_loan_out_pr_bal_dt_5 IN DATE,
1166 x_nslds_loan_begin_dt_5 IN DATE,
1167 x_nslds_loan_end_dt_5 IN DATE,
1168 x_nslds_loan_ga_code_5 IN VARCHAR2,
1169 x_nslds_loan_cont_type_5 IN VARCHAR2,
1170 x_nslds_loan_schol_code_5 IN VARCHAR2,
1171 x_nslds_loan_cont_code_5 IN VARCHAR2,
1172 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
1173 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
1174 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
1175 x_nslds_loan_seq_num_6 IN NUMBER,
1176 x_nslds_loan_type_code_6 IN VARCHAR2,
1177 x_nslds_loan_chng_f_6 IN VARCHAR2,
1178 x_nslds_loan_prog_code_6 IN VARCHAR2,
1179 x_nslds_loan_net_amnt_6 IN NUMBER,
1180 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
1181 x_nslds_loan_cur_st_date_6 IN DATE,
1182 x_nslds_loan_agg_pr_bal_6 IN NUMBER,
1183 x_nslds_loan_out_pr_bal_dt_6 IN DATE,
1184 x_nslds_loan_begin_dt_6 IN DATE,
1185 x_nslds_loan_end_dt_6 IN DATE,
1186 x_nslds_loan_ga_code_6 IN VARCHAR2,
1187 x_nslds_loan_cont_type_6 IN VARCHAR2,
1188 x_nslds_loan_schol_code_6 IN VARCHAR2,
1189 x_nslds_loan_cont_code_6 IN VARCHAR2,
1190 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
1191 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
1192 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
1193 x_nslds_loan_last_d_amt_1 IN NUMBER ,
1194 x_nslds_loan_last_d_date_1 IN DATE ,
1195 x_nslds_loan_last_d_amt_2 IN NUMBER ,
1196 x_nslds_loan_last_d_date_2 IN DATE ,
1197 x_nslds_loan_last_d_amt_3 IN NUMBER ,
1198 x_nslds_loan_last_d_date_3 IN DATE ,
1199 x_nslds_loan_last_d_amt_4 IN NUMBER ,
1200 x_nslds_loan_last_d_date_4 IN DATE ,
1201 x_nslds_loan_last_d_amt_5 IN NUMBER ,
1202 x_nslds_loan_last_d_date_5 IN DATE ,
1203 x_nslds_loan_last_d_amt_6 IN NUMBER ,
1204 x_nslds_loan_last_d_date_6 IN DATE ,
1205 x_dlp_master_prom_note_flag IN VARCHAR2,
1206 x_mode IN VARCHAR2,
1207 x_subsidized_loan_limit_type IN VARCHAR2,
1208 x_combined_loan_limit_type IN VARCHAR2,
1209 x_transaction_num_txt IN VARCHAR2
1210 ) AS
1211 /*
1212 || Created By : rasingh
1213 || Created On : 06-DEC-2000
1214 || Purpose : Handles the INSERT DML logic for the table.
1215 || Known limitations, enhancements or remarks :
1216 || Change History :
1217 || Who When What
1218 || (reverse chronological order - newest change first)
1219 */
1220 CURSOR c IS
1221 SELECT rowid
1222 FROM igf_ap_nslds_data_all
1223 WHERE nslds_id = x_nslds_id;
1224
1225 x_last_update_date DATE;
1226 x_last_updated_by NUMBER;
1227 x_last_update_login NUMBER;
1228 x_request_id NUMBER;
1229 x_program_id NUMBER;
1230 x_program_application_id NUMBER;
1231 x_program_update_date DATE;
1232 l_org_id igf_ap_nslds_data_all.org_id%TYPE := igf_aw_gen.get_org_id;
1233
1234 BEGIN
1235
1236 SELECT igf_ap_nslds_data_s.nextval INTO x_nslds_id
1237 FROM dual;
1238
1239
1240 x_last_update_date := SYSDATE;
1241 IF (x_mode = 'I') THEN
1242 x_last_updated_by := 1;
1243 x_last_update_login := 0;
1244 ELSIF (x_mode = 'R') THEN
1245 x_last_updated_by := fnd_global.user_id;
1246 IF (x_last_updated_by IS NULL) THEN
1247 x_last_updated_by := -1;
1248 END IF;
1249 x_last_update_login := fnd_global.login_id;
1250 IF (x_last_update_login IS NULL) THEN
1251 x_last_update_login := -1;
1252 END IF;
1253 x_request_id := fnd_global.conc_request_id;
1254 x_program_id := fnd_global.conc_program_id;
1255 x_program_application_id := fnd_global.prog_appl_id;
1256
1257 IF (x_request_id = -1) THEN
1258 x_request_id := NULL;
1259 x_program_id := NULL;
1260 x_program_application_id := NULL;
1261 x_program_update_date := NULL;
1262 ELSE
1263 x_program_update_date := SYSDATE;
1264 END IF;
1265 ELSE
1266 fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1267 igs_ge_msg_stack.add;
1268 app_exception.raise_exception;
1269 END IF;
1270
1271 before_dml(
1272 p_action => 'INSERT',
1273 x_rowid => x_rowid,
1274 x_nslds_id => x_nslds_id,
1275 x_isir_id => x_isir_id,
1276 x_base_id => x_base_id,
1277 x_nslds_transaction_num => x_nslds_transaction_num,
1278 x_nslds_database_results_f => x_nslds_database_results_f,
1279 x_nslds_f => x_nslds_f,
1280 x_nslds_pell_overpay_f => x_nslds_pell_overpay_f,
1281 x_nslds_pell_overpay_contact => x_nslds_pell_overpay_contact,
1282 x_nslds_seog_overpay_f => x_nslds_seog_overpay_f,
1283 x_nslds_seog_overpay_contact => x_nslds_seog_overpay_contact,
1284 x_nslds_perkins_overpay_f => x_nslds_perkins_overpay_f,
1285 x_nslds_perkins_overpay_cntct => x_nslds_perkins_overpay_cntct,
1286 x_nslds_defaulted_loan_f => x_nslds_defaulted_loan_f,
1287 x_nslds_dischged_loan_chng_f => x_nslds_dischged_loan_chng_f,
1288 x_nslds_satis_repay_f => x_nslds_satis_repay_f,
1289 x_nslds_act_bankruptcy_f => x_nslds_act_bankruptcy_f,
1290 x_nslds_agg_subsz_out_prin_bal => x_nslds_agg_subsz_out_prin_bal,
1291 x_nslds_agg_unsbz_out_prin_bal => x_nslds_agg_unsbz_out_prin_bal,
1292 x_nslds_agg_comb_out_prin_bal => x_nslds_agg_comb_out_prin_bal,
1293 x_nslds_agg_cons_out_prin_bal => x_nslds_agg_cons_out_prin_bal,
1294 x_nslds_agg_subsz_pend_dismt => x_nslds_agg_subsz_pend_dismt,
1295 x_nslds_agg_unsbz_pend_dismt => x_nslds_agg_unsbz_pend_dismt,
1296 x_nslds_agg_comb_pend_dismt => x_nslds_agg_comb_pend_dismt,
1297 x_nslds_agg_subsz_total => x_nslds_agg_subsz_total,
1298 x_nslds_agg_unsbz_total => x_nslds_agg_unsbz_total,
1299 x_nslds_agg_comb_total => x_nslds_agg_comb_total,
1300 x_nslds_agg_consd_total => x_nslds_agg_consd_total,
1301 x_nslds_perkins_out_bal => x_nslds_perkins_out_bal,
1302 x_nslds_perkins_cur_yr_dismnt => x_nslds_perkins_cur_yr_dismnt,
1303 x_nslds_default_loan_chng_f => x_nslds_default_loan_chng_f,
1304 x_nslds_discharged_loan_f => x_nslds_discharged_loan_f,
1305 x_nslds_satis_repay_chng_f => x_nslds_satis_repay_chng_f,
1306 x_nslds_act_bnkrupt_chng_f => x_nslds_act_bnkrupt_chng_f,
1307 x_nslds_overpay_chng_f => x_nslds_overpay_chng_f,
1308 x_nslds_agg_loan_chng_f => x_nslds_agg_loan_chng_f,
1309 x_nslds_perkins_loan_chng_f => x_nslds_perkins_loan_chng_f,
1310 x_nslds_pell_paymnt_chng_f => x_nslds_pell_paymnt_chng_f,
1311 x_nslds_addtnl_pell_f => x_nslds_addtnl_pell_f,
1312 x_nslds_addtnl_loan_f => x_nslds_addtnl_loan_f,
1313 x_direct_loan_mas_prom_nt_f => x_direct_loan_mas_prom_nt_f,
1314 x_nslds_pell_seq_num_1 => x_nslds_pell_seq_num_1,
1315 x_nslds_pell_verify_f_1 => x_nslds_pell_verify_f_1,
1316 x_nslds_pell_efc_1 => x_nslds_pell_efc_1,
1317 x_nslds_pell_school_code_1 => x_nslds_pell_school_code_1,
1318 x_nslds_pell_transcn_num_1 => x_nslds_pell_transcn_num_1,
1319 x_nslds_pell_last_updt_dt_1 => x_nslds_pell_last_updt_dt_1,
1320 x_nslds_pell_scheduled_amt_1 => x_nslds_pell_scheduled_amt_1,
1321 x_nslds_pell_amt_paid_todt_1 => x_nslds_pell_amt_paid_todt_1,
1322 x_nslds_pell_remng_amt_1 => x_nslds_pell_remng_amt_1,
1323 x_nslds_pell_pc_schd_awd_us_1 => x_nslds_pell_pc_schd_awd_us_1,
1324 x_nslds_pell_award_amt_1 => x_nslds_pell_award_amt_1,
1325 x_nslds_pell_seq_num_2 => x_nslds_pell_seq_num_2,
1326 x_nslds_pell_verify_f_2 => x_nslds_pell_verify_f_2,
1327 x_nslds_pell_efc_2 => x_nslds_pell_efc_2,
1328 x_nslds_pell_school_code_2 => x_nslds_pell_school_code_2,
1329 x_nslds_pell_transcn_num_2 => x_nslds_pell_transcn_num_2,
1330 x_nslds_pell_last_updt_dt_2 => x_nslds_pell_last_updt_dt_2,
1331 x_nslds_pell_scheduled_amt_2 => x_nslds_pell_scheduled_amt_2,
1332 x_nslds_pell_amt_paid_todt_2 => x_nslds_pell_amt_paid_todt_2,
1333 x_nslds_pell_remng_amt_2 => x_nslds_pell_remng_amt_2,
1334 x_nslds_pell_pc_schd_awd_us_2 => x_nslds_pell_pc_schd_awd_us_2,
1335 x_nslds_pell_award_amt_2 => x_nslds_pell_award_amt_2,
1336 x_nslds_pell_seq_num_3 => x_nslds_pell_seq_num_3,
1337 x_nslds_pell_verify_f_3 => x_nslds_pell_verify_f_3,
1338 x_nslds_pell_efc_3 => x_nslds_pell_efc_3,
1339 x_nslds_pell_school_code_3 => x_nslds_pell_school_code_3,
1340 x_nslds_pell_transcn_num_3 => x_nslds_pell_transcn_num_3,
1341 x_nslds_pell_last_updt_dt_3 => x_nslds_pell_last_updt_dt_3,
1342 x_nslds_pell_scheduled_amt_3 => x_nslds_pell_scheduled_amt_3,
1343 x_nslds_pell_amt_paid_todt_3 => x_nslds_pell_amt_paid_todt_3,
1344 x_nslds_pell_remng_amt_3 => x_nslds_pell_remng_amt_3,
1345 x_nslds_pell_pc_schd_awd_us_3 => x_nslds_pell_pc_schd_awd_us_3,
1346 x_nslds_pell_award_amt_3 => x_nslds_pell_award_amt_3,
1347 x_nslds_loan_seq_num_1 => x_nslds_loan_seq_num_1,
1348 x_nslds_loan_type_code_1 => x_nslds_loan_type_code_1,
1349 x_nslds_loan_chng_f_1 => x_nslds_loan_chng_f_1,
1350 x_nslds_loan_prog_code_1 => x_nslds_loan_prog_code_1,
1351 x_nslds_loan_net_amnt_1 => x_nslds_loan_net_amnt_1,
1352 x_nslds_loan_cur_st_code_1 => x_nslds_loan_cur_st_code_1,
1353 x_nslds_loan_cur_st_date_1 => x_nslds_loan_cur_st_date_1,
1354 x_nslds_loan_agg_pr_bal_1 => x_nslds_loan_agg_pr_bal_1,
1355 x_nslds_loan_out_pr_bal_dt_1 => x_nslds_loan_out_pr_bal_dt_1,
1356 x_nslds_loan_begin_dt_1 => x_nslds_loan_begin_dt_1,
1357 x_nslds_loan_end_dt_1 => x_nslds_loan_end_dt_1,
1358 x_nslds_loan_ga_code_1 => x_nslds_loan_ga_code_1,
1359 x_nslds_loan_cont_type_1 => x_nslds_loan_cont_type_1,
1360 x_nslds_loan_schol_code_1 => x_nslds_loan_schol_code_1,
1361 x_nslds_loan_cont_code_1 => x_nslds_loan_cont_code_1,
1362 x_nslds_loan_grade_lvl_1 => x_nslds_loan_grade_lvl_1,
1363 x_nslds_loan_xtr_unsbz_ln_f_1 => x_nslds_loan_xtr_unsbz_ln_f_1,
1364 x_nslds_loan_capital_int_f_1 => x_nslds_loan_capital_int_f_1,
1365 x_nslds_loan_seq_num_2 => x_nslds_loan_seq_num_2,
1366 x_nslds_loan_type_code_2 => x_nslds_loan_type_code_2,
1367 x_nslds_loan_chng_f_2 => x_nslds_loan_chng_f_2,
1368 x_nslds_loan_prog_code_2 => x_nslds_loan_prog_code_2,
1369 x_nslds_loan_net_amnt_2 => x_nslds_loan_net_amnt_2,
1370 x_nslds_loan_cur_st_code_2 => x_nslds_loan_cur_st_code_2,
1371 x_nslds_loan_cur_st_date_2 => x_nslds_loan_cur_st_date_2,
1372 x_nslds_loan_agg_pr_bal_2 => x_nslds_loan_agg_pr_bal_2,
1373 x_nslds_loan_out_pr_bal_dt_2 => x_nslds_loan_out_pr_bal_dt_2,
1374 x_nslds_loan_begin_dt_2 => x_nslds_loan_begin_dt_2,
1375 x_nslds_loan_end_dt_2 => x_nslds_loan_end_dt_2,
1376 x_nslds_loan_ga_code_2 => x_nslds_loan_ga_code_2,
1377 x_nslds_loan_cont_type_2 => x_nslds_loan_cont_type_2,
1378 x_nslds_loan_schol_code_2 => x_nslds_loan_schol_code_2,
1379 x_nslds_loan_cont_code_2 => x_nslds_loan_cont_code_2,
1380 x_nslds_loan_grade_lvl_2 => x_nslds_loan_grade_lvl_2,
1381 x_nslds_loan_xtr_unsbz_ln_f_2 => x_nslds_loan_xtr_unsbz_ln_f_2,
1382 x_nslds_loan_capital_int_f_2 => x_nslds_loan_capital_int_f_2,
1383 x_nslds_loan_seq_num_3 => x_nslds_loan_seq_num_3,
1384 x_nslds_loan_type_code_3 => x_nslds_loan_type_code_3,
1385 x_nslds_loan_chng_f_3 => x_nslds_loan_chng_f_3,
1386 x_nslds_loan_prog_code_3 => x_nslds_loan_prog_code_3,
1387 x_nslds_loan_net_amnt_3 => x_nslds_loan_net_amnt_3,
1388 x_nslds_loan_cur_st_code_3 => x_nslds_loan_cur_st_code_3,
1389 x_nslds_loan_cur_st_date_3 => x_nslds_loan_cur_st_date_3,
1390 x_nslds_loan_agg_pr_bal_3 => x_nslds_loan_agg_pr_bal_3,
1391 x_nslds_loan_out_pr_bal_dt_3 => x_nslds_loan_out_pr_bal_dt_3,
1392 x_nslds_loan_begin_dt_3 => x_nslds_loan_begin_dt_3,
1393 x_nslds_loan_end_dt_3 => x_nslds_loan_end_dt_3,
1394 x_nslds_loan_ga_code_3 => x_nslds_loan_ga_code_3,
1395 x_nslds_loan_cont_type_3 => x_nslds_loan_cont_type_3,
1396 x_nslds_loan_schol_code_3 => x_nslds_loan_schol_code_3,
1397 x_nslds_loan_cont_code_3 => x_nslds_loan_cont_code_3,
1398 x_nslds_loan_grade_lvl_3 => x_nslds_loan_grade_lvl_3,
1399 x_nslds_loan_xtr_unsbz_ln_f_3 => x_nslds_loan_xtr_unsbz_ln_f_3,
1400 x_nslds_loan_capital_int_f_3 => x_nslds_loan_capital_int_f_3,
1401 x_nslds_loan_seq_num_4 => x_nslds_loan_seq_num_4,
1402 x_nslds_loan_type_code_4 => x_nslds_loan_type_code_4,
1403 x_nslds_loan_chng_f_4 => x_nslds_loan_chng_f_4,
1404 x_nslds_loan_prog_code_4 => x_nslds_loan_prog_code_4,
1405 x_nslds_loan_net_amnt_4 => x_nslds_loan_net_amnt_4,
1406 x_nslds_loan_cur_st_code_4 => x_nslds_loan_cur_st_code_4,
1407 x_nslds_loan_cur_st_date_4 => x_nslds_loan_cur_st_date_4,
1408 x_nslds_loan_agg_pr_bal_4 => x_nslds_loan_agg_pr_bal_4,
1409 x_nslds_loan_out_pr_bal_dt_4 => x_nslds_loan_out_pr_bal_dt_4,
1410 x_nslds_loan_begin_dt_4 => x_nslds_loan_begin_dt_4,
1411 x_nslds_loan_end_dt_4 => x_nslds_loan_end_dt_4,
1412 x_nslds_loan_ga_code_4 => x_nslds_loan_ga_code_4,
1413 x_nslds_loan_cont_type_4 => x_nslds_loan_cont_type_4,
1414 x_nslds_loan_schol_code_4 => x_nslds_loan_schol_code_4,
1415 x_nslds_loan_cont_code_4 => x_nslds_loan_cont_code_4,
1416 x_nslds_loan_grade_lvl_4 => x_nslds_loan_grade_lvl_4,
1417 x_nslds_loan_xtr_unsbz_ln_f_4 => x_nslds_loan_xtr_unsbz_ln_f_4,
1418 x_nslds_loan_capital_int_f_4 => x_nslds_loan_capital_int_f_4,
1419 x_nslds_loan_seq_num_5 => x_nslds_loan_seq_num_5,
1420 x_nslds_loan_type_code_5 => x_nslds_loan_type_code_5,
1421 x_nslds_loan_chng_f_5 => x_nslds_loan_chng_f_5,
1422 x_nslds_loan_prog_code_5 => x_nslds_loan_prog_code_5,
1423 x_nslds_loan_net_amnt_5 => x_nslds_loan_net_amnt_5,
1424 x_nslds_loan_cur_st_code_5 => x_nslds_loan_cur_st_code_5,
1425 x_nslds_loan_cur_st_date_5 => x_nslds_loan_cur_st_date_5,
1426 x_nslds_loan_agg_pr_bal_5 => x_nslds_loan_agg_pr_bal_5,
1427 x_nslds_loan_out_pr_bal_dt_5 => x_nslds_loan_out_pr_bal_dt_5,
1428 x_nslds_loan_begin_dt_5 => x_nslds_loan_begin_dt_5,
1429 x_nslds_loan_end_dt_5 => x_nslds_loan_end_dt_5,
1430 x_nslds_loan_ga_code_5 => x_nslds_loan_ga_code_5,
1431 x_nslds_loan_cont_type_5 => x_nslds_loan_cont_type_5,
1432 x_nslds_loan_schol_code_5 => x_nslds_loan_schol_code_5,
1433 x_nslds_loan_cont_code_5 => x_nslds_loan_cont_code_5,
1434 x_nslds_loan_grade_lvl_5 => x_nslds_loan_grade_lvl_5,
1435 x_nslds_loan_xtr_unsbz_ln_f_5 => x_nslds_loan_xtr_unsbz_ln_f_5,
1436 x_nslds_loan_capital_int_f_5 => x_nslds_loan_capital_int_f_5,
1437 x_nslds_loan_seq_num_6 => x_nslds_loan_seq_num_6,
1438 x_nslds_loan_type_code_6 => x_nslds_loan_type_code_6,
1439 x_nslds_loan_chng_f_6 => x_nslds_loan_chng_f_6,
1440 x_nslds_loan_prog_code_6 => x_nslds_loan_prog_code_6,
1441 x_nslds_loan_net_amnt_6 => x_nslds_loan_net_amnt_6,
1442 x_nslds_loan_cur_st_code_6 => x_nslds_loan_cur_st_code_6,
1443 x_nslds_loan_cur_st_date_6 => x_nslds_loan_cur_st_date_6,
1444 x_nslds_loan_agg_pr_bal_6 => x_nslds_loan_agg_pr_bal_6,
1445 x_nslds_loan_out_pr_bal_dt_6 => x_nslds_loan_out_pr_bal_dt_6,
1446 x_nslds_loan_begin_dt_6 => x_nslds_loan_begin_dt_6,
1447 x_nslds_loan_end_dt_6 => x_nslds_loan_end_dt_6,
1448 x_nslds_loan_ga_code_6 => x_nslds_loan_ga_code_6,
1449 x_nslds_loan_cont_type_6 => x_nslds_loan_cont_type_6,
1450 x_nslds_loan_schol_code_6 => x_nslds_loan_schol_code_6,
1451 x_nslds_loan_cont_code_6 => x_nslds_loan_cont_code_6,
1452 x_nslds_loan_grade_lvl_6 => x_nslds_loan_grade_lvl_6,
1453 x_nslds_loan_xtr_unsbz_ln_f_6 => x_nslds_loan_xtr_unsbz_ln_f_6,
1454 x_nslds_loan_capital_int_f_6 => x_nslds_loan_capital_int_f_6,
1455 x_nslds_loan_last_d_amt_1 => x_nslds_loan_last_d_amt_1,
1456 x_nslds_loan_last_d_date_1 => x_nslds_loan_last_d_date_1,
1457 x_nslds_loan_last_d_amt_2 => x_nslds_loan_last_d_amt_2,
1458 x_nslds_loan_last_d_date_2 => x_nslds_loan_last_d_date_2,
1459 x_nslds_loan_last_d_amt_3 => x_nslds_loan_last_d_amt_3,
1460 x_nslds_loan_last_d_date_3 => x_nslds_loan_last_d_date_3,
1461 x_nslds_loan_last_d_amt_4 => x_nslds_loan_last_d_amt_4,
1462 x_nslds_loan_last_d_date_4 => x_nslds_loan_last_d_date_4,
1463 x_nslds_loan_last_d_amt_5 => x_nslds_loan_last_d_amt_5,
1464 x_nslds_loan_last_d_date_5 => x_nslds_loan_last_d_date_5,
1465 x_nslds_loan_last_d_amt_6 => x_nslds_loan_last_d_amt_6,
1466 x_nslds_loan_last_d_date_6 => x_nslds_loan_last_d_date_6,
1467 x_creation_date => x_last_update_date,
1468 x_created_by => x_last_updated_by,
1469 x_last_update_date => x_last_update_date,
1470 x_last_updated_by => x_last_updated_by,
1471 x_last_update_login => x_last_update_login ,
1472 x_dlp_master_prom_note_flag => x_dlp_master_prom_note_flag,
1473 x_subsidized_loan_limit_type => x_subsidized_loan_limit_type,
1474 x_combined_loan_limit_type => x_combined_loan_limit_type,
1475 x_transaction_num_txt => x_transaction_num_txt
1476 );
1477
1478 INSERT INTO igf_ap_nslds_data_all (
1479 nslds_id,
1480 isir_id,
1481 base_id,
1482 nslds_transaction_num,
1483 nslds_database_results_f,
1484 nslds_f,
1485 nslds_pell_overpay_f,
1486 nslds_pell_overpay_contact,
1487 nslds_seog_overpay_f,
1488 nslds_seog_overpay_contact,
1489 nslds_perkins_overpay_f,
1490 nslds_perkins_overpay_cntct,
1491 nslds_defaulted_loan_f,
1492 nslds_dischged_loan_chng_f,
1493 nslds_satis_repay_f,
1494 nslds_act_bankruptcy_f,
1495 nslds_agg_subsz_out_prin_bal,
1496 nslds_agg_unsbz_out_prin_bal,
1497 nslds_agg_comb_out_prin_bal,
1498 nslds_agg_cons_out_prin_bal,
1499 nslds_agg_subsz_pend_dismt,
1500 nslds_agg_unsbz_pend_dismt,
1501 nslds_agg_comb_pend_dismt,
1502 nslds_agg_subsz_total,
1503 nslds_agg_unsbz_total,
1504 nslds_agg_comb_total,
1505 nslds_agg_consd_total,
1506 nslds_perkins_out_bal,
1507 nslds_perkins_cur_yr_dismnt,
1508 nslds_default_loan_chng_f,
1509 nslds_discharged_loan_f,
1510 nslds_satis_repay_chng_f,
1511 nslds_act_bnkrupt_chng_f,
1512 nslds_overpay_chng_f,
1513 nslds_agg_loan_chng_f,
1514 nslds_perkins_loan_chng_f,
1515 nslds_pell_paymnt_chng_f,
1516 nslds_addtnl_pell_f,
1517 nslds_addtnl_loan_f,
1518 direct_loan_mas_prom_nt_f,
1519 nslds_pell_seq_num_1,
1520 nslds_pell_verify_f_1,
1521 nslds_pell_efc_1,
1522 nslds_pell_school_code_1,
1523 nslds_pell_transcn_num_1,
1524 nslds_pell_last_updt_dt_1,
1525 nslds_pell_scheduled_amt_1,
1526 nslds_pell_amt_paid_todt_1,
1527 nslds_pell_remng_amt_1,
1528 nslds_pell_pc_schd_awd_us_1,
1529 nslds_pell_award_amt_1,
1530 nslds_pell_seq_num_2,
1531 nslds_pell_verify_f_2,
1532 nslds_pell_efc_2,
1533 nslds_pell_school_code_2,
1534 nslds_pell_transcn_num_2,
1535 nslds_pell_last_updt_dt_2,
1536 nslds_pell_scheduled_amt_2,
1537 nslds_pell_amt_paid_todt_2,
1538 nslds_pell_remng_amt_2,
1539 nslds_pell_pc_schd_awd_us_2,
1540 nslds_pell_award_amt_2,
1541 nslds_pell_seq_num_3,
1542 nslds_pell_verify_f_3,
1543 nslds_pell_efc_3,
1544 nslds_pell_school_code_3,
1545 nslds_pell_transcn_num_3,
1546 nslds_pell_last_updt_dt_3,
1547 nslds_pell_scheduled_amt_3,
1548 nslds_pell_amt_paid_todt_3,
1549 nslds_pell_remng_amt_3,
1550 nslds_pell_pc_schd_awd_us_3,
1551 nslds_pell_award_amt_3,
1552 nslds_loan_seq_num_1,
1553 nslds_loan_type_code_1,
1554 nslds_loan_chng_f_1,
1555 nslds_loan_prog_code_1,
1556 nslds_loan_net_amnt_1,
1557 nslds_loan_cur_st_code_1,
1558 nslds_loan_cur_st_date_1,
1559 nslds_loan_agg_pr_bal_1,
1560 nslds_loan_out_pr_bal_dt_1,
1561 nslds_loan_begin_dt_1,
1562 nslds_loan_end_dt_1,
1563 nslds_loan_ga_code_1,
1564 nslds_loan_cont_type_1,
1565 nslds_loan_schol_code_1,
1566 nslds_loan_cont_code_1,
1567 nslds_loan_grade_lvl_1,
1568 nslds_loan_xtr_unsbz_ln_f_1,
1569 nslds_loan_capital_int_f_1,
1570 nslds_loan_seq_num_2,
1571 nslds_loan_type_code_2,
1572 nslds_loan_chng_f_2,
1573 nslds_loan_prog_code_2,
1574 nslds_loan_net_amnt_2,
1575 nslds_loan_cur_st_code_2,
1576 nslds_loan_cur_st_date_2,
1577 nslds_loan_agg_pr_bal_2,
1578 nslds_loan_out_pr_bal_dt_2,
1579 nslds_loan_begin_dt_2,
1580 nslds_loan_end_dt_2,
1581 nslds_loan_ga_code_2,
1582 nslds_loan_cont_type_2,
1583 nslds_loan_schol_code_2,
1584 nslds_loan_cont_code_2,
1585 nslds_loan_grade_lvl_2,
1586 nslds_loan_xtr_unsbz_ln_f_2,
1587 nslds_loan_capital_int_f_2,
1588 nslds_loan_seq_num_3,
1589 nslds_loan_type_code_3,
1590 nslds_loan_chng_f_3,
1591 nslds_loan_prog_code_3,
1592 nslds_loan_net_amnt_3,
1593 nslds_loan_cur_st_code_3,
1594 nslds_loan_cur_st_date_3,
1595 nslds_loan_agg_pr_bal_3,
1596 nslds_loan_out_pr_bal_dt_3,
1597 nslds_loan_begin_dt_3,
1598 nslds_loan_end_dt_3,
1599 nslds_loan_ga_code_3,
1600 nslds_loan_cont_type_3,
1601 nslds_loan_schol_code_3,
1602 nslds_loan_cont_code_3,
1603 nslds_loan_grade_lvl_3,
1604 nslds_loan_xtr_unsbz_ln_f_3,
1605 nslds_loan_capital_int_f_3,
1606 nslds_loan_seq_num_4,
1607 nslds_loan_type_code_4,
1608 nslds_loan_chng_f_4,
1609 nslds_loan_prog_code_4,
1610 nslds_loan_net_amnt_4,
1611 nslds_loan_cur_st_code_4,
1612 nslds_loan_cur_st_date_4,
1613 nslds_loan_agg_pr_bal_4,
1614 nslds_loan_out_pr_bal_dt_4,
1615 nslds_loan_begin_dt_4,
1616 nslds_loan_end_dt_4,
1617 nslds_loan_ga_code_4,
1618 nslds_loan_cont_type_4,
1619 nslds_loan_schol_code_4,
1620 nslds_loan_cont_code_4,
1621 nslds_loan_grade_lvl_4,
1622 nslds_loan_xtr_unsbz_ln_f_4,
1623 nslds_loan_capital_int_f_4,
1624 nslds_loan_seq_num_5,
1625 nslds_loan_type_code_5,
1626 nslds_loan_chng_f_5,
1627 nslds_loan_prog_code_5,
1628 nslds_loan_net_amnt_5,
1629 nslds_loan_cur_st_code_5,
1630 nslds_loan_cur_st_date_5,
1631 nslds_loan_agg_pr_bal_5,
1632 nslds_loan_out_pr_bal_dt_5,
1633 nslds_loan_begin_dt_5,
1634 nslds_loan_end_dt_5,
1635 nslds_loan_ga_code_5,
1636 nslds_loan_cont_type_5,
1637 nslds_loan_schol_code_5,
1638 nslds_loan_cont_code_5,
1639 nslds_loan_grade_lvl_5,
1640 nslds_loan_xtr_unsbz_ln_f_5,
1641 nslds_loan_capital_int_f_5,
1642 nslds_loan_seq_num_6,
1643 nslds_loan_type_code_6,
1644 nslds_loan_chng_f_6,
1645 nslds_loan_prog_code_6,
1646 nslds_loan_net_amnt_6,
1647 nslds_loan_cur_st_code_6,
1648 nslds_loan_cur_st_date_6,
1649 nslds_loan_agg_pr_bal_6,
1650 nslds_loan_out_pr_bal_dt_6,
1651 nslds_loan_begin_dt_6,
1652 nslds_loan_end_dt_6,
1653 nslds_loan_ga_code_6,
1654 nslds_loan_cont_type_6,
1655 nslds_loan_schol_code_6,
1656 nslds_loan_cont_code_6,
1657 nslds_loan_grade_lvl_6,
1658 nslds_loan_xtr_unsbz_ln_f_6,
1659 nslds_loan_capital_int_f_6,
1660 nslds_loan_last_d_amt_1,
1661 nslds_loan_last_d_date_1,
1662 nslds_loan_last_d_amt_2,
1663 nslds_loan_last_d_date_2,
1664 nslds_loan_last_d_amt_3,
1665 nslds_loan_last_d_date_3,
1666 nslds_loan_last_d_amt_4,
1667 nslds_loan_last_d_date_4,
1668 nslds_loan_last_d_amt_5,
1669 nslds_loan_last_d_date_5,
1670 nslds_loan_last_d_amt_6,
1671 nslds_loan_last_d_date_6,
1672 creation_date,
1673 created_by,
1674 last_update_date,
1675 last_updated_by,
1676 last_update_login,
1677 request_id,
1678 program_id,
1679 program_application_id,
1680 program_update_date ,
1681 org_id,
1682 dlp_master_prom_note_flag,
1683 subsidized_loan_limit_type,
1684 combined_loan_limit_type,
1685 transaction_num_txt
1686 ) VALUES (
1687 new_references.nslds_id,
1688 new_references.isir_id,
1689 new_references.base_id,
1690 new_references.nslds_transaction_num,
1691 new_references.nslds_database_results_f,
1692 new_references.nslds_f,
1693 new_references.nslds_pell_overpay_f,
1694 new_references.nslds_pell_overpay_contact,
1695 new_references.nslds_seog_overpay_f,
1696 new_references.nslds_seog_overpay_contact,
1697 new_references.nslds_perkins_overpay_f,
1698 new_references.nslds_perkins_overpay_cntct,
1699 new_references.nslds_defaulted_loan_f,
1700 new_references.nslds_dischged_loan_chng_f,
1701 new_references.nslds_satis_repay_f,
1702 new_references.nslds_act_bankruptcy_f,
1703 new_references.nslds_agg_subsz_out_prin_bal,
1704 new_references.nslds_agg_unsbz_out_prin_bal,
1705 new_references.nslds_agg_comb_out_prin_bal,
1706 new_references.nslds_agg_cons_out_prin_bal,
1707 new_references.nslds_agg_subsz_pend_dismt,
1708 new_references.nslds_agg_unsbz_pend_dismt,
1709 new_references.nslds_agg_comb_pend_dismt,
1710 new_references.nslds_agg_subsz_total,
1711 new_references.nslds_agg_unsbz_total,
1712 new_references.nslds_agg_comb_total,
1713 new_references.nslds_agg_consd_total,
1714 new_references.nslds_perkins_out_bal,
1715 new_references.nslds_perkins_cur_yr_dismnt,
1716 new_references.nslds_default_loan_chng_f,
1717 new_references.nslds_discharged_loan_f,
1718 new_references.nslds_satis_repay_chng_f,
1719 new_references.nslds_act_bnkrupt_chng_f,
1720 new_references.nslds_overpay_chng_f,
1721 new_references.nslds_agg_loan_chng_f,
1722 new_references.nslds_perkins_loan_chng_f,
1723 new_references.nslds_pell_paymnt_chng_f,
1724 new_references.nslds_addtnl_pell_f,
1725 new_references.nslds_addtnl_loan_f,
1726 new_references.direct_loan_mas_prom_nt_f,
1727 new_references.nslds_pell_seq_num_1,
1728 new_references.nslds_pell_verify_f_1,
1729 new_references.nslds_pell_efc_1,
1730 new_references.nslds_pell_school_code_1,
1731 new_references.nslds_pell_transcn_num_1,
1732 new_references.nslds_pell_last_updt_dt_1,
1733 new_references.nslds_pell_scheduled_amt_1,
1734 new_references.nslds_pell_amt_paid_todt_1,
1735 new_references.nslds_pell_remng_amt_1,
1736 new_references.nslds_pell_pc_schd_awd_us_1,
1737 new_references.nslds_pell_award_amt_1,
1738 new_references.nslds_pell_seq_num_2,
1739 new_references.nslds_pell_verify_f_2,
1740 new_references.nslds_pell_efc_2,
1741 new_references.nslds_pell_school_code_2,
1742 new_references.nslds_pell_transcn_num_2,
1743 new_references.nslds_pell_last_updt_dt_2,
1744 new_references.nslds_pell_scheduled_amt_2,
1745 new_references.nslds_pell_amt_paid_todt_2,
1746 new_references.nslds_pell_remng_amt_2,
1747 new_references.nslds_pell_pc_schd_awd_us_2,
1748 new_references.nslds_pell_award_amt_2,
1749 new_references.nslds_pell_seq_num_3,
1750 new_references.nslds_pell_verify_f_3,
1751 new_references.nslds_pell_efc_3,
1752 new_references.nslds_pell_school_code_3,
1753 new_references.nslds_pell_transcn_num_3,
1754 new_references.nslds_pell_last_updt_dt_3,
1755 new_references.nslds_pell_scheduled_amt_3,
1756 new_references.nslds_pell_amt_paid_todt_3,
1757 new_references.nslds_pell_remng_amt_3,
1758 new_references.nslds_pell_pc_schd_awd_us_3,
1759 new_references.nslds_pell_award_amt_3,
1760 new_references.nslds_loan_seq_num_1,
1761 new_references.nslds_loan_type_code_1,
1762 new_references.nslds_loan_chng_f_1,
1763 new_references.nslds_loan_prog_code_1,
1764 new_references.nslds_loan_net_amnt_1,
1765 new_references.nslds_loan_cur_st_code_1,
1766 new_references.nslds_loan_cur_st_date_1,
1767 new_references.nslds_loan_agg_pr_bal_1,
1768 new_references.nslds_loan_out_pr_bal_dt_1,
1769 new_references.nslds_loan_begin_dt_1,
1770 new_references.nslds_loan_end_dt_1,
1771 new_references.nslds_loan_ga_code_1,
1772 new_references.nslds_loan_cont_type_1,
1773 new_references.nslds_loan_schol_code_1,
1774 new_references.nslds_loan_cont_code_1,
1775 new_references.nslds_loan_grade_lvl_1,
1776 new_references.nslds_loan_xtr_unsbz_ln_f_1,
1777 new_references.nslds_loan_capital_int_f_1,
1778 new_references.nslds_loan_seq_num_2,
1779 new_references.nslds_loan_type_code_2,
1780 new_references.nslds_loan_chng_f_2,
1781 new_references.nslds_loan_prog_code_2,
1782 new_references.nslds_loan_net_amnt_2,
1783 new_references.nslds_loan_cur_st_code_2,
1784 new_references.nslds_loan_cur_st_date_2,
1785 new_references.nslds_loan_agg_pr_bal_2,
1786 new_references.nslds_loan_out_pr_bal_dt_2,
1787 new_references.nslds_loan_begin_dt_2,
1788 new_references.nslds_loan_end_dt_2,
1789 new_references.nslds_loan_ga_code_2,
1790 new_references.nslds_loan_cont_type_2,
1791 new_references.nslds_loan_schol_code_2,
1792 new_references.nslds_loan_cont_code_2,
1793 new_references.nslds_loan_grade_lvl_2,
1794 new_references.nslds_loan_xtr_unsbz_ln_f_2,
1795 new_references.nslds_loan_capital_int_f_2,
1796 new_references.nslds_loan_seq_num_3,
1797 new_references.nslds_loan_type_code_3,
1798 new_references.nslds_loan_chng_f_3,
1799 new_references.nslds_loan_prog_code_3,
1800 new_references.nslds_loan_net_amnt_3,
1801 new_references.nslds_loan_cur_st_code_3,
1802 new_references.nslds_loan_cur_st_date_3,
1803 new_references.nslds_loan_agg_pr_bal_3,
1804 new_references.nslds_loan_out_pr_bal_dt_3,
1805 new_references.nslds_loan_begin_dt_3,
1806 new_references.nslds_loan_end_dt_3,
1807 new_references.nslds_loan_ga_code_3,
1808 new_references.nslds_loan_cont_type_3,
1809 new_references.nslds_loan_schol_code_3,
1810 new_references.nslds_loan_cont_code_3,
1811 new_references.nslds_loan_grade_lvl_3,
1812 new_references.nslds_loan_xtr_unsbz_ln_f_3,
1813 new_references.nslds_loan_capital_int_f_3,
1814 new_references.nslds_loan_seq_num_4,
1815 new_references.nslds_loan_type_code_4,
1816 new_references.nslds_loan_chng_f_4,
1817 new_references.nslds_loan_prog_code_4,
1818 new_references.nslds_loan_net_amnt_4,
1819 new_references.nslds_loan_cur_st_code_4,
1820 new_references.nslds_loan_cur_st_date_4,
1821 new_references.nslds_loan_agg_pr_bal_4,
1822 new_references.nslds_loan_out_pr_bal_dt_4,
1823 new_references.nslds_loan_begin_dt_4,
1824 new_references.nslds_loan_end_dt_4,
1825 new_references.nslds_loan_ga_code_4,
1826 new_references.nslds_loan_cont_type_4,
1827 new_references.nslds_loan_schol_code_4,
1828 new_references.nslds_loan_cont_code_4,
1829 new_references.nslds_loan_grade_lvl_4,
1830 new_references.nslds_loan_xtr_unsbz_ln_f_4,
1831 new_references.nslds_loan_capital_int_f_4,
1832 new_references.nslds_loan_seq_num_5,
1833 new_references.nslds_loan_type_code_5,
1834 new_references.nslds_loan_chng_f_5,
1835 new_references.nslds_loan_prog_code_5,
1836 new_references.nslds_loan_net_amnt_5,
1837 new_references.nslds_loan_cur_st_code_5,
1838 new_references.nslds_loan_cur_st_date_5,
1839 new_references.nslds_loan_agg_pr_bal_5,
1840 new_references.nslds_loan_out_pr_bal_dt_5,
1841 new_references.nslds_loan_begin_dt_5,
1842 new_references.nslds_loan_end_dt_5,
1843 new_references.nslds_loan_ga_code_5,
1844 new_references.nslds_loan_cont_type_5,
1845 new_references.nslds_loan_schol_code_5,
1846 new_references.nslds_loan_cont_code_5,
1847 new_references.nslds_loan_grade_lvl_5,
1848 new_references.nslds_loan_xtr_unsbz_ln_f_5,
1849 new_references.nslds_loan_capital_int_f_5,
1850 new_references.nslds_loan_seq_num_6,
1851 new_references.nslds_loan_type_code_6,
1852 new_references.nslds_loan_chng_f_6,
1853 new_references.nslds_loan_prog_code_6,
1854 new_references.nslds_loan_net_amnt_6,
1855 new_references.nslds_loan_cur_st_code_6,
1856 new_references.nslds_loan_cur_st_date_6,
1857 new_references.nslds_loan_agg_pr_bal_6,
1858 new_references.nslds_loan_out_pr_bal_dt_6,
1859 new_references.nslds_loan_begin_dt_6,
1860 new_references.nslds_loan_end_dt_6,
1861 new_references.nslds_loan_ga_code_6,
1862 new_references.nslds_loan_cont_type_6,
1863 new_references.nslds_loan_schol_code_6,
1864 new_references.nslds_loan_cont_code_6,
1865 new_references.nslds_loan_grade_lvl_6,
1866 new_references.nslds_loan_xtr_unsbz_ln_f_6,
1867 new_references.nslds_loan_capital_int_f_6,
1868 new_references.nslds_loan_last_d_amt_1,
1869 new_references.nslds_loan_last_d_date_1,
1870 new_references.nslds_loan_last_d_amt_2,
1871 new_references.nslds_loan_last_d_date_2,
1872 new_references.nslds_loan_last_d_amt_3,
1873 new_references.nslds_loan_last_d_date_3,
1874 new_references.nslds_loan_last_d_amt_4,
1875 new_references.nslds_loan_last_d_date_4,
1876 new_references.nslds_loan_last_d_amt_5,
1877 new_references.nslds_loan_last_d_date_5,
1878 new_references.nslds_loan_last_d_amt_6,
1879 new_references.nslds_loan_last_d_date_6,
1880 x_last_update_date,
1881 x_last_updated_by,
1882 x_last_update_date,
1883 x_last_updated_by,
1884 x_last_update_login ,
1885 x_request_id,
1886 x_program_id,
1887 x_program_application_id,
1888 x_program_update_date ,
1889 l_org_id,
1890 new_references.dlp_master_prom_note_flag,
1891 new_references.subsidized_loan_limit_type,
1892 new_references.combined_loan_limit_type,
1893 new_references.transaction_num_txt
1894 );
1895
1896 OPEN c;
1897 FETCH c INTO x_rowid;
1898 IF (c%NOTFOUND) THEN
1899 CLOSE c;
1900 RAISE NO_DATA_FOUND;
1901 END IF;
1902 CLOSE c;
1903
1904 END insert_row;
1905
1906
1907 PROCEDURE lock_row (
1908 x_rowid IN VARCHAR2,
1909 x_nslds_id IN NUMBER,
1910 x_isir_id IN NUMBER,
1911 x_base_id IN NUMBER,
1912 x_nslds_transaction_num IN NUMBER,
1913 x_nslds_database_results_f IN VARCHAR2,
1914 x_nslds_f IN VARCHAR2,
1915 x_nslds_pell_overpay_f IN VARCHAR2,
1916 x_nslds_pell_overpay_contact IN VARCHAR2,
1917 x_nslds_seog_overpay_f IN VARCHAR2,
1918 x_nslds_seog_overpay_contact IN VARCHAR2,
1919 x_nslds_perkins_overpay_f IN VARCHAR2,
1920 x_nslds_perkins_overpay_cntct IN VARCHAR2,
1921 x_nslds_defaulted_loan_f IN VARCHAR2,
1922 x_nslds_dischged_loan_chng_f IN VARCHAR2,
1923 x_nslds_satis_repay_f IN VARCHAR2,
1924 x_nslds_act_bankruptcy_f IN VARCHAR2,
1925 x_nslds_agg_subsz_out_prin_bal IN NUMBER,
1926 x_nslds_agg_unsbz_out_prin_bal IN NUMBER,
1927 x_nslds_agg_comb_out_prin_bal IN NUMBER,
1928 x_nslds_agg_cons_out_prin_bal IN NUMBER,
1929 x_nslds_agg_subsz_pend_dismt IN NUMBER,
1930 x_nslds_agg_unsbz_pend_dismt IN NUMBER,
1931 x_nslds_agg_comb_pend_dismt IN NUMBER,
1932 x_nslds_agg_subsz_total IN NUMBER,
1933 x_nslds_agg_unsbz_total IN NUMBER,
1934 x_nslds_agg_comb_total IN NUMBER,
1935 x_nslds_agg_consd_total IN NUMBER,
1936 x_nslds_perkins_out_bal IN NUMBER,
1937 x_nslds_perkins_cur_yr_dismnt IN NUMBER,
1938 x_nslds_default_loan_chng_f IN VARCHAR2,
1939 x_nslds_discharged_loan_f IN VARCHAR2,
1940 x_nslds_satis_repay_chng_f IN VARCHAR2,
1941 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
1942 x_nslds_overpay_chng_f IN VARCHAR2,
1943 x_nslds_agg_loan_chng_f IN VARCHAR2,
1944 x_nslds_perkins_loan_chng_f IN VARCHAR2,
1945 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
1946 x_nslds_addtnl_pell_f IN VARCHAR2,
1947 x_nslds_addtnl_loan_f IN VARCHAR2,
1948 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
1949 x_nslds_pell_seq_num_1 IN NUMBER,
1950 x_nslds_pell_verify_f_1 IN VARCHAR2,
1951 x_nslds_pell_efc_1 IN NUMBER,
1952 x_nslds_pell_school_code_1 IN NUMBER,
1953 x_nslds_pell_transcn_num_1 IN NUMBER,
1954 x_nslds_pell_last_updt_dt_1 IN DATE,
1955 x_nslds_pell_scheduled_amt_1 IN NUMBER,
1956 x_nslds_pell_amt_paid_todt_1 IN NUMBER,
1957 x_nslds_pell_remng_amt_1 IN NUMBER,
1958 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER,
1959 x_nslds_pell_award_amt_1 IN NUMBER,
1960 x_nslds_pell_seq_num_2 IN NUMBER,
1961 x_nslds_pell_verify_f_2 IN VARCHAR2,
1962 x_nslds_pell_efc_2 IN NUMBER,
1963 x_nslds_pell_school_code_2 IN NUMBER,
1964 x_nslds_pell_transcn_num_2 IN NUMBER,
1965 x_nslds_pell_last_updt_dt_2 IN DATE,
1966 x_nslds_pell_scheduled_amt_2 IN NUMBER,
1967 x_nslds_pell_amt_paid_todt_2 IN NUMBER,
1968 x_nslds_pell_remng_amt_2 IN NUMBER,
1969 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER,
1970 x_nslds_pell_award_amt_2 IN NUMBER,
1971 x_nslds_pell_seq_num_3 IN NUMBER,
1972 x_nslds_pell_verify_f_3 IN VARCHAR2,
1973 x_nslds_pell_efc_3 IN NUMBER,
1974 x_nslds_pell_school_code_3 IN NUMBER,
1975 x_nslds_pell_transcn_num_3 IN NUMBER,
1976 x_nslds_pell_last_updt_dt_3 IN DATE,
1977 x_nslds_pell_scheduled_amt_3 IN NUMBER,
1978 x_nslds_pell_amt_paid_todt_3 IN NUMBER,
1979 x_nslds_pell_remng_amt_3 IN NUMBER,
1980 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER,
1981 x_nslds_pell_award_amt_3 IN NUMBER,
1982 x_nslds_loan_seq_num_1 IN NUMBER,
1983 x_nslds_loan_type_code_1 IN VARCHAR2,
1984 x_nslds_loan_chng_f_1 IN VARCHAR2,
1985 x_nslds_loan_prog_code_1 IN VARCHAR2,
1986 x_nslds_loan_net_amnt_1 IN NUMBER,
1987 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
1988 x_nslds_loan_cur_st_date_1 IN DATE,
1989 x_nslds_loan_agg_pr_bal_1 IN NUMBER,
1990 x_nslds_loan_out_pr_bal_dt_1 IN DATE,
1991 x_nslds_loan_begin_dt_1 IN DATE,
1992 x_nslds_loan_end_dt_1 IN DATE,
1993 x_nslds_loan_ga_code_1 IN VARCHAR2,
1994 x_nslds_loan_cont_type_1 IN VARCHAR2,
1995 x_nslds_loan_schol_code_1 IN VARCHAR2,
1996 x_nslds_loan_cont_code_1 IN VARCHAR2,
1997 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
1998 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
1999 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
2000 x_nslds_loan_seq_num_2 IN NUMBER,
2001 x_nslds_loan_type_code_2 IN VARCHAR2,
2002 x_nslds_loan_chng_f_2 IN VARCHAR2,
2003 x_nslds_loan_prog_code_2 IN VARCHAR2,
2004 x_nslds_loan_net_amnt_2 IN NUMBER,
2005 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
2006 x_nslds_loan_cur_st_date_2 IN DATE,
2007 x_nslds_loan_agg_pr_bal_2 IN NUMBER,
2008 x_nslds_loan_out_pr_bal_dt_2 IN DATE,
2009 x_nslds_loan_begin_dt_2 IN DATE,
2010 x_nslds_loan_end_dt_2 IN DATE,
2011 x_nslds_loan_ga_code_2 IN VARCHAR2,
2012 x_nslds_loan_cont_type_2 IN VARCHAR2,
2013 x_nslds_loan_schol_code_2 IN VARCHAR2,
2014 x_nslds_loan_cont_code_2 IN VARCHAR2,
2015 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
2016 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
2017 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
2018 x_nslds_loan_seq_num_3 IN NUMBER,
2019 x_nslds_loan_type_code_3 IN VARCHAR2,
2020 x_nslds_loan_chng_f_3 IN VARCHAR2,
2021 x_nslds_loan_prog_code_3 IN VARCHAR2,
2022 x_nslds_loan_net_amnt_3 IN NUMBER,
2023 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
2024 x_nslds_loan_cur_st_date_3 IN DATE,
2025 x_nslds_loan_agg_pr_bal_3 IN NUMBER,
2026 x_nslds_loan_out_pr_bal_dt_3 IN DATE,
2027 x_nslds_loan_begin_dt_3 IN DATE,
2028 x_nslds_loan_end_dt_3 IN DATE,
2029 x_nslds_loan_ga_code_3 IN VARCHAR2,
2030 x_nslds_loan_cont_type_3 IN VARCHAR2,
2031 x_nslds_loan_schol_code_3 IN VARCHAR2,
2032 x_nslds_loan_cont_code_3 IN VARCHAR2,
2033 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
2034 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
2035 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
2036 x_nslds_loan_seq_num_4 IN NUMBER,
2037 x_nslds_loan_type_code_4 IN VARCHAR2,
2038 x_nslds_loan_chng_f_4 IN VARCHAR2,
2039 x_nslds_loan_prog_code_4 IN VARCHAR2,
2040 x_nslds_loan_net_amnt_4 IN NUMBER,
2041 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
2042 x_nslds_loan_cur_st_date_4 IN DATE,
2043 x_nslds_loan_agg_pr_bal_4 IN NUMBER,
2044 x_nslds_loan_out_pr_bal_dt_4 IN DATE,
2045 x_nslds_loan_begin_dt_4 IN DATE,
2046 x_nslds_loan_end_dt_4 IN DATE,
2047 x_nslds_loan_ga_code_4 IN VARCHAR2,
2048 x_nslds_loan_cont_type_4 IN VARCHAR2,
2049 x_nslds_loan_schol_code_4 IN VARCHAR2,
2050 x_nslds_loan_cont_code_4 IN VARCHAR2,
2051 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
2052 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
2053 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
2054 x_nslds_loan_seq_num_5 IN NUMBER,
2055 x_nslds_loan_type_code_5 IN VARCHAR2,
2056 x_nslds_loan_chng_f_5 IN VARCHAR2,
2057 x_nslds_loan_prog_code_5 IN VARCHAR2,
2058 x_nslds_loan_net_amnt_5 IN NUMBER,
2059 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
2060 x_nslds_loan_cur_st_date_5 IN DATE,
2061 x_nslds_loan_agg_pr_bal_5 IN NUMBER,
2062 x_nslds_loan_out_pr_bal_dt_5 IN DATE,
2063 x_nslds_loan_begin_dt_5 IN DATE,
2064 x_nslds_loan_end_dt_5 IN DATE,
2065 x_nslds_loan_ga_code_5 IN VARCHAR2,
2066 x_nslds_loan_cont_type_5 IN VARCHAR2,
2067 x_nslds_loan_schol_code_5 IN VARCHAR2,
2068 x_nslds_loan_cont_code_5 IN VARCHAR2,
2069 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
2070 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
2071 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
2072 x_nslds_loan_seq_num_6 IN NUMBER,
2073 x_nslds_loan_type_code_6 IN VARCHAR2,
2074 x_nslds_loan_chng_f_6 IN VARCHAR2,
2075 x_nslds_loan_prog_code_6 IN VARCHAR2,
2076 x_nslds_loan_net_amnt_6 IN NUMBER,
2077 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
2078 x_nslds_loan_cur_st_date_6 IN DATE,
2079 x_nslds_loan_agg_pr_bal_6 IN NUMBER,
2080 x_nslds_loan_out_pr_bal_dt_6 IN DATE,
2081 x_nslds_loan_begin_dt_6 IN DATE,
2082 x_nslds_loan_end_dt_6 IN DATE,
2083 x_nslds_loan_ga_code_6 IN VARCHAR2,
2084 x_nslds_loan_cont_type_6 IN VARCHAR2,
2085 x_nslds_loan_schol_code_6 IN VARCHAR2,
2086 x_nslds_loan_cont_code_6 IN VARCHAR2,
2087 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
2088 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
2089 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
2090 x_nslds_loan_last_d_amt_1 IN NUMBER ,
2091 x_nslds_loan_last_d_date_1 IN DATE ,
2092 x_nslds_loan_last_d_amt_2 IN NUMBER ,
2093 x_nslds_loan_last_d_date_2 IN DATE ,
2094 x_nslds_loan_last_d_amt_3 IN NUMBER ,
2095 x_nslds_loan_last_d_date_3 IN DATE ,
2096 x_nslds_loan_last_d_amt_4 IN NUMBER ,
2097 x_nslds_loan_last_d_date_4 IN DATE ,
2098 x_nslds_loan_last_d_amt_5 IN NUMBER ,
2099 x_nslds_loan_last_d_date_5 IN DATE ,
2100 x_nslds_loan_last_d_amt_6 IN NUMBER ,
2101 x_nslds_loan_last_d_date_6 IN DATE ,
2102 x_dlp_master_prom_note_flag IN VARCHAR2,
2103 x_subsidized_loan_limit_type IN VARCHAR2,
2104 x_combined_loan_limit_type IN VARCHAR2,
2105 x_transaction_num_txt IN VARCHAR2
2106 ) AS
2107 /*
2108 || Created By : rasingh
2109 || Created On : 06-DEC-2000
2110 || Purpose : Handles the LOCK mechanism for the table.
2111 || Known limitations, enhancements or remarks :
2112 || Change History :
2113 || Who When What
2114 || (reverse chronological order - newest change first)
2115 */
2116 CURSOR c1 IS
2117 SELECT
2118 isir_id,
2119 base_id,
2120 nslds_transaction_num,
2121 nslds_database_results_f,
2122 nslds_f,
2123 nslds_pell_overpay_f,
2124 nslds_pell_overpay_contact,
2125 nslds_seog_overpay_f,
2126 nslds_seog_overpay_contact,
2127 nslds_perkins_overpay_f,
2128 nslds_perkins_overpay_cntct,
2129 nslds_defaulted_loan_f,
2130 nslds_dischged_loan_chng_f,
2131 nslds_satis_repay_f,
2132 nslds_act_bankruptcy_f,
2133 nslds_agg_subsz_out_prin_bal,
2134 nslds_agg_unsbz_out_prin_bal,
2135 nslds_agg_comb_out_prin_bal,
2136 nslds_agg_cons_out_prin_bal,
2137 nslds_agg_subsz_pend_dismt,
2138 nslds_agg_unsbz_pend_dismt,
2139 nslds_agg_comb_pend_dismt,
2140 nslds_agg_subsz_total,
2141 nslds_agg_unsbz_total,
2142 nslds_agg_comb_total,
2143 nslds_agg_consd_total,
2144 nslds_perkins_out_bal,
2145 nslds_perkins_cur_yr_dismnt,
2146 nslds_default_loan_chng_f,
2147 nslds_discharged_loan_f,
2148 nslds_satis_repay_chng_f,
2149 nslds_act_bnkrupt_chng_f,
2150 nslds_overpay_chng_f,
2151 nslds_agg_loan_chng_f,
2152 nslds_perkins_loan_chng_f,
2153 nslds_pell_paymnt_chng_f,
2154 nslds_addtnl_pell_f,
2155 nslds_addtnl_loan_f,
2156 direct_loan_mas_prom_nt_f,
2157 nslds_pell_seq_num_1,
2158 nslds_pell_verify_f_1,
2159 nslds_pell_efc_1,
2160 nslds_pell_school_code_1,
2161 nslds_pell_transcn_num_1,
2162 nslds_pell_last_updt_dt_1,
2163 nslds_pell_scheduled_amt_1,
2164 nslds_pell_amt_paid_todt_1,
2165 nslds_pell_remng_amt_1,
2166 nslds_pell_pc_schd_awd_us_1,
2167 nslds_pell_award_amt_1,
2168 nslds_pell_seq_num_2,
2169 nslds_pell_verify_f_2,
2170 nslds_pell_efc_2,
2171 nslds_pell_school_code_2,
2172 nslds_pell_transcn_num_2,
2173 nslds_pell_last_updt_dt_2,
2174 nslds_pell_scheduled_amt_2,
2175 nslds_pell_amt_paid_todt_2,
2176 nslds_pell_remng_amt_2,
2177 nslds_pell_pc_schd_awd_us_2,
2178 nslds_pell_award_amt_2,
2179 nslds_pell_seq_num_3,
2180 nslds_pell_verify_f_3,
2181 nslds_pell_efc_3,
2182 nslds_pell_school_code_3,
2183 nslds_pell_transcn_num_3,
2184 nslds_pell_last_updt_dt_3,
2185 nslds_pell_scheduled_amt_3,
2186 nslds_pell_amt_paid_todt_3,
2187 nslds_pell_remng_amt_3,
2188 nslds_pell_pc_schd_awd_us_3,
2189 nslds_pell_award_amt_3,
2190 nslds_loan_seq_num_1,
2191 nslds_loan_type_code_1,
2192 nslds_loan_chng_f_1,
2193 nslds_loan_prog_code_1,
2194 nslds_loan_net_amnt_1,
2195 nslds_loan_cur_st_code_1,
2196 nslds_loan_cur_st_date_1,
2197 nslds_loan_agg_pr_bal_1,
2198 nslds_loan_out_pr_bal_dt_1,
2199 nslds_loan_begin_dt_1,
2200 nslds_loan_end_dt_1,
2201 nslds_loan_ga_code_1,
2202 nslds_loan_cont_type_1,
2203 nslds_loan_schol_code_1,
2204 nslds_loan_cont_code_1,
2205 nslds_loan_grade_lvl_1,
2206 nslds_loan_xtr_unsbz_ln_f_1,
2207 nslds_loan_capital_int_f_1,
2208 nslds_loan_seq_num_2,
2209 nslds_loan_type_code_2,
2210 nslds_loan_chng_f_2,
2211 nslds_loan_prog_code_2,
2212 nslds_loan_net_amnt_2,
2213 nslds_loan_cur_st_code_2,
2214 nslds_loan_cur_st_date_2,
2215 nslds_loan_agg_pr_bal_2,
2216 nslds_loan_out_pr_bal_dt_2,
2217 nslds_loan_begin_dt_2,
2218 nslds_loan_end_dt_2,
2219 nslds_loan_ga_code_2,
2220 nslds_loan_cont_type_2,
2221 nslds_loan_schol_code_2,
2222 nslds_loan_cont_code_2,
2223 nslds_loan_grade_lvl_2,
2224 nslds_loan_xtr_unsbz_ln_f_2,
2225 nslds_loan_capital_int_f_2,
2226 nslds_loan_seq_num_3,
2227 nslds_loan_type_code_3,
2228 nslds_loan_chng_f_3,
2229 nslds_loan_prog_code_3,
2230 nslds_loan_net_amnt_3,
2231 nslds_loan_cur_st_code_3,
2232 nslds_loan_cur_st_date_3,
2233 nslds_loan_agg_pr_bal_3,
2234 nslds_loan_out_pr_bal_dt_3,
2235 nslds_loan_begin_dt_3,
2236 nslds_loan_end_dt_3,
2237 nslds_loan_ga_code_3,
2238 nslds_loan_cont_type_3,
2239 nslds_loan_schol_code_3,
2240 nslds_loan_cont_code_3,
2241 nslds_loan_grade_lvl_3,
2242 nslds_loan_xtr_unsbz_ln_f_3,
2243 nslds_loan_capital_int_f_3,
2244 nslds_loan_seq_num_4,
2245 nslds_loan_type_code_4,
2246 nslds_loan_chng_f_4,
2247 nslds_loan_prog_code_4,
2248 nslds_loan_net_amnt_4,
2249 nslds_loan_cur_st_code_4,
2250 nslds_loan_cur_st_date_4,
2251 nslds_loan_agg_pr_bal_4,
2252 nslds_loan_out_pr_bal_dt_4,
2253 nslds_loan_begin_dt_4,
2254 nslds_loan_end_dt_4,
2255 nslds_loan_ga_code_4,
2256 nslds_loan_cont_type_4,
2257 nslds_loan_schol_code_4,
2258 nslds_loan_cont_code_4,
2259 nslds_loan_grade_lvl_4,
2260 nslds_loan_xtr_unsbz_ln_f_4,
2261 nslds_loan_capital_int_f_4,
2262 nslds_loan_seq_num_5,
2263 nslds_loan_type_code_5,
2264 nslds_loan_chng_f_5,
2265 nslds_loan_prog_code_5,
2266 nslds_loan_net_amnt_5,
2267 nslds_loan_cur_st_code_5,
2268 nslds_loan_cur_st_date_5,
2269 nslds_loan_agg_pr_bal_5,
2270 nslds_loan_out_pr_bal_dt_5,
2271 nslds_loan_begin_dt_5,
2272 nslds_loan_end_dt_5,
2273 nslds_loan_ga_code_5,
2274 nslds_loan_cont_type_5,
2275 nslds_loan_schol_code_5,
2276 nslds_loan_cont_code_5,
2277 nslds_loan_grade_lvl_5,
2278 nslds_loan_xtr_unsbz_ln_f_5,
2279 nslds_loan_capital_int_f_5,
2280 nslds_loan_seq_num_6,
2281 nslds_loan_type_code_6,
2282 nslds_loan_chng_f_6,
2283 nslds_loan_prog_code_6,
2284 nslds_loan_net_amnt_6,
2285 nslds_loan_cur_st_code_6,
2286 nslds_loan_cur_st_date_6,
2287 nslds_loan_agg_pr_bal_6,
2288 nslds_loan_out_pr_bal_dt_6,
2289 nslds_loan_begin_dt_6,
2290 nslds_loan_end_dt_6,
2291 nslds_loan_ga_code_6,
2292 nslds_loan_cont_type_6,
2293 nslds_loan_schol_code_6,
2294 nslds_loan_cont_code_6,
2295 nslds_loan_grade_lvl_6,
2296 nslds_loan_xtr_unsbz_ln_f_6,
2297 nslds_loan_capital_int_f_6,
2298 nslds_loan_last_d_amt_1,
2299 nslds_loan_last_d_date_1,
2300 nslds_loan_last_d_amt_2,
2301 nslds_loan_last_d_date_2,
2302 nslds_loan_last_d_amt_3,
2303 nslds_loan_last_d_date_3,
2304 nslds_loan_last_d_amt_4,
2305 nslds_loan_last_d_date_4,
2306 nslds_loan_last_d_amt_5,
2307 nslds_loan_last_d_date_5,
2308 nslds_loan_last_d_amt_6,
2309 nslds_loan_last_d_date_6,
2310 org_id,
2311 dlp_master_prom_note_flag,
2312 subsidized_loan_limit_type,
2313 combined_loan_limit_type,
2314 transaction_num_txt
2315 FROM igf_ap_nslds_data_all
2316 WHERE rowid = x_rowid
2317 FOR UPDATE NOWAIT;
2318
2319 tlinfo c1%ROWTYPE;
2320 BEGIN
2321
2322 OPEN c1;
2323 FETCH c1 INTO tlinfo;
2324 IF (c1%notfound) THEN
2325 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2326 igs_ge_msg_stack.add;
2327 CLOSE c1;
2328 app_exception.raise_exception;
2329 RETURN;
2330 END IF;
2331 CLOSE c1;
2332
2333 IF (
2334 (tlinfo.isir_id = x_isir_id)
2335 AND ((tlinfo.base_id = x_base_id) OR ((tlinfo.base_id IS NULL) AND (X_base_id IS NULL)))
2336 AND ((tlinfo.nslds_transaction_num = x_nslds_transaction_num) OR ((tlinfo.nslds_transaction_num IS NULL) AND (X_nslds_transaction_num IS NULL)))
2337 AND ((tlinfo.nslds_database_results_f = x_nslds_database_results_f) OR ((tlinfo.nslds_database_results_f IS NULL) AND (X_nslds_database_results_f IS NULL)))
2338 AND ((tlinfo.nslds_f = x_nslds_f) OR ((tlinfo.nslds_f IS NULL) AND (X_nslds_f IS NULL)))
2339 AND ((tlinfo.nslds_pell_overpay_f = x_nslds_pell_overpay_f) OR ((tlinfo.nslds_pell_overpay_f IS NULL) AND (X_nslds_pell_overpay_f IS NULL)))
2340 AND ((tlinfo.nslds_pell_overpay_contact = x_nslds_pell_overpay_contact) OR ((tlinfo.nslds_pell_overpay_contact IS NULL) AND (X_nslds_pell_overpay_contact IS NULL)))
2341 AND ((tlinfo.nslds_seog_overpay_f = x_nslds_seog_overpay_f) OR ((tlinfo.nslds_seog_overpay_f IS NULL) AND (X_nslds_seog_overpay_f IS NULL)))
2342 AND ((tlinfo.nslds_seog_overpay_contact = x_nslds_seog_overpay_contact) OR ((tlinfo.nslds_seog_overpay_contact IS NULL) AND (X_nslds_seog_overpay_contact IS NULL)))
2343 AND ((tlinfo.nslds_perkins_overpay_f = x_nslds_perkins_overpay_f) OR ((tlinfo.nslds_perkins_overpay_f IS NULL) AND (X_nslds_perkins_overpay_f IS NULL)))
2344 AND ((tlinfo.nslds_perkins_overpay_cntct = x_nslds_perkins_overpay_cntct) OR ((tlinfo.nslds_perkins_overpay_cntct IS NULL) AND (X_nslds_perkins_overpay_cntct IS NULL)))
2345 AND ((tlinfo.nslds_defaulted_loan_f = x_nslds_defaulted_loan_f) OR ((tlinfo.nslds_defaulted_loan_f IS NULL) AND (X_nslds_defaulted_loan_f IS NULL)))
2346 AND ((tlinfo.nslds_dischged_loan_chng_f = x_nslds_dischged_loan_chng_f) OR ((tlinfo.nslds_dischged_loan_chng_f IS NULL) AND (X_nslds_dischged_loan_chng_f IS NULL)))
2347 AND ((tlinfo.nslds_satis_repay_f = x_nslds_satis_repay_f) OR ((tlinfo.nslds_satis_repay_f IS NULL) AND (X_nslds_satis_repay_f IS NULL)))
2348 AND ((tlinfo.nslds_act_bankruptcy_f = x_nslds_act_bankruptcy_f) OR ((tlinfo.nslds_act_bankruptcy_f IS NULL) AND (X_nslds_act_bankruptcy_f IS NULL)))
2349 AND ((tlinfo.nslds_agg_subsz_out_prin_bal = x_nslds_agg_subsz_out_prin_bal) OR ((tlinfo.nslds_agg_subsz_out_prin_bal IS NULL) AND (X_nslds_agg_subsz_out_prin_bal IS NULL)))
2350 AND ((tlinfo.nslds_agg_unsbz_out_prin_bal = x_nslds_agg_unsbz_out_prin_bal) OR ((tlinfo.nslds_agg_unsbz_out_prin_bal IS NULL) AND (X_nslds_agg_unsbz_out_prin_bal IS NULL)))
2351 AND ((tlinfo.nslds_agg_comb_out_prin_bal = x_nslds_agg_comb_out_prin_bal) OR ((tlinfo.nslds_agg_comb_out_prin_bal IS NULL) AND (X_nslds_agg_comb_out_prin_bal IS NULL)))
2352 AND ((tlinfo.nslds_agg_cons_out_prin_bal = x_nslds_agg_cons_out_prin_bal) OR ((tlinfo.nslds_agg_cons_out_prin_bal IS NULL) AND (X_nslds_agg_cons_out_prin_bal IS NULL)))
2353 AND ((tlinfo.nslds_agg_subsz_pend_dismt = x_nslds_agg_subsz_pend_dismt) OR ((tlinfo.nslds_agg_subsz_pend_dismt IS NULL) AND (X_nslds_agg_subsz_pend_dismt IS NULL)))
2354 AND ((tlinfo.nslds_agg_unsbz_pend_dismt = x_nslds_agg_unsbz_pend_dismt) OR ((tlinfo.nslds_agg_unsbz_pend_dismt IS NULL) AND (X_nslds_agg_unsbz_pend_dismt IS NULL)))
2355 AND ((tlinfo.nslds_agg_comb_pend_dismt = x_nslds_agg_comb_pend_dismt) OR ((tlinfo.nslds_agg_comb_pend_dismt IS NULL) AND (X_nslds_agg_comb_pend_dismt IS NULL)))
2356 AND ((tlinfo.nslds_agg_subsz_total = x_nslds_agg_subsz_total) OR ((tlinfo.nslds_agg_subsz_total IS NULL) AND (X_nslds_agg_subsz_total IS NULL)))
2357 AND ((tlinfo.nslds_agg_unsbz_total = x_nslds_agg_unsbz_total) OR ((tlinfo.nslds_agg_unsbz_total IS NULL) AND (X_nslds_agg_unsbz_total IS NULL)))
2358 AND ((tlinfo.nslds_agg_comb_total = x_nslds_agg_comb_total) OR ((tlinfo.nslds_agg_comb_total IS NULL) AND (X_nslds_agg_comb_total IS NULL)))
2359 AND ((tlinfo.nslds_agg_consd_total = x_nslds_agg_consd_total) OR ((tlinfo.nslds_agg_consd_total IS NULL) AND (X_nslds_agg_consd_total IS NULL)))
2360 AND ((tlinfo.nslds_perkins_out_bal = x_nslds_perkins_out_bal) OR ((tlinfo.nslds_perkins_out_bal IS NULL) AND (X_nslds_perkins_out_bal IS NULL)))
2361 AND ((tlinfo.nslds_perkins_cur_yr_dismnt = x_nslds_perkins_cur_yr_dismnt) OR ((tlinfo.nslds_perkins_cur_yr_dismnt IS NULL) AND (X_nslds_perkins_cur_yr_dismnt IS NULL)))
2362 AND ((tlinfo.nslds_default_loan_chng_f = x_nslds_default_loan_chng_f) OR ((tlinfo.nslds_default_loan_chng_f IS NULL) AND (X_nslds_default_loan_chng_f IS NULL)))
2363 AND ((tlinfo.nslds_discharged_loan_f = x_nslds_discharged_loan_f) OR ((tlinfo.nslds_discharged_loan_f IS NULL) AND (X_nslds_discharged_loan_f IS NULL)))
2364 AND ((tlinfo.nslds_satis_repay_chng_f = x_nslds_satis_repay_chng_f) OR ((tlinfo.nslds_satis_repay_chng_f IS NULL) AND (X_nslds_satis_repay_chng_f IS NULL)))
2365 AND ((tlinfo.nslds_act_bnkrupt_chng_f = x_nslds_act_bnkrupt_chng_f) OR ((tlinfo.nslds_act_bnkrupt_chng_f IS NULL) AND (X_nslds_act_bnkrupt_chng_f IS NULL)))
2366 AND ((tlinfo.nslds_overpay_chng_f = x_nslds_overpay_chng_f) OR ((tlinfo.nslds_overpay_chng_f IS NULL) AND (X_nslds_overpay_chng_f IS NULL)))
2367 AND ((tlinfo.nslds_agg_loan_chng_f = x_nslds_agg_loan_chng_f) OR ((tlinfo.nslds_agg_loan_chng_f IS NULL) AND (X_nslds_agg_loan_chng_f IS NULL)))
2368 AND ((tlinfo.nslds_perkins_loan_chng_f = x_nslds_perkins_loan_chng_f) OR ((tlinfo.nslds_perkins_loan_chng_f IS NULL) AND (X_nslds_perkins_loan_chng_f IS NULL)))
2369 AND ((tlinfo.nslds_pell_paymnt_chng_f = x_nslds_pell_paymnt_chng_f) OR ((tlinfo.nslds_pell_paymnt_chng_f IS NULL) AND (X_nslds_pell_paymnt_chng_f IS NULL)))
2370 AND ((tlinfo.nslds_addtnl_pell_f = x_nslds_addtnl_pell_f) OR ((tlinfo.nslds_addtnl_pell_f IS NULL) AND (X_nslds_addtnl_pell_f IS NULL)))
2371 AND ((tlinfo.nslds_addtnl_loan_f = x_nslds_addtnl_loan_f) OR ((tlinfo.nslds_addtnl_loan_f IS NULL) AND (X_nslds_addtnl_loan_f IS NULL)))
2372 AND ((tlinfo.direct_loan_mas_prom_nt_f = x_direct_loan_mas_prom_nt_f) OR ((tlinfo.direct_loan_mas_prom_nt_f IS NULL) AND (X_direct_loan_mas_prom_nt_f IS NULL)))
2373 AND ((tlinfo.nslds_pell_seq_num_1 = x_nslds_pell_seq_num_1) OR ((tlinfo.nslds_pell_seq_num_1 IS NULL) AND (X_nslds_pell_seq_num_1 IS NULL)))
2374 AND ((tlinfo.nslds_pell_verify_f_1 = x_nslds_pell_verify_f_1) OR ((tlinfo.nslds_pell_verify_f_1 IS NULL) AND (X_nslds_pell_verify_f_1 IS NULL)))
2375 AND ((tlinfo.nslds_pell_efc_1 = x_nslds_pell_efc_1) OR ((tlinfo.nslds_pell_efc_1 IS NULL) AND (X_nslds_pell_efc_1 IS NULL)))
2376 AND ((tlinfo.nslds_pell_school_code_1 = x_nslds_pell_school_code_1) OR ((tlinfo.nslds_pell_school_code_1 IS NULL) AND (X_nslds_pell_school_code_1 IS NULL)))
2377 AND ((tlinfo.nslds_pell_transcn_num_1 = x_nslds_pell_transcn_num_1) OR ((tlinfo.nslds_pell_transcn_num_1 IS NULL) AND (X_nslds_pell_transcn_num_1 IS NULL)))
2378 AND ((tlinfo.nslds_pell_last_updt_dt_1 = x_nslds_pell_last_updt_dt_1) OR ((tlinfo.nslds_pell_last_updt_dt_1 IS NULL) AND (X_nslds_pell_last_updt_dt_1 IS NULL)))
2379 AND ((tlinfo.nslds_pell_scheduled_amt_1 = x_nslds_pell_scheduled_amt_1) OR ((tlinfo.nslds_pell_scheduled_amt_1 IS NULL) AND (X_nslds_pell_scheduled_amt_1 IS NULL)))
2380 AND ((tlinfo.nslds_pell_amt_paid_todt_1 = x_nslds_pell_amt_paid_todt_1) OR ((tlinfo.nslds_pell_amt_paid_todt_1 IS NULL) AND (X_nslds_pell_amt_paid_todt_1 IS NULL)))
2381 AND ((tlinfo.nslds_pell_remng_amt_1 = x_nslds_pell_remng_amt_1) OR ((tlinfo.nslds_pell_remng_amt_1 IS NULL) AND (X_nslds_pell_remng_amt_1 IS NULL)))
2382 AND ((tlinfo.nslds_pell_pc_schd_awd_us_1 = x_nslds_pell_pc_schd_awd_us_1) OR ((tlinfo.nslds_pell_pc_schd_awd_us_1 IS NULL) AND (X_nslds_pell_pc_schd_awd_us_1 IS NULL)))
2383 AND ((tlinfo.nslds_pell_award_amt_1 = x_nslds_pell_award_amt_1) OR ((tlinfo.nslds_pell_award_amt_1 IS NULL) AND (X_nslds_pell_award_amt_1 IS NULL)))
2384 AND ((tlinfo.nslds_pell_seq_num_2 = x_nslds_pell_seq_num_2) OR ((tlinfo.nslds_pell_seq_num_2 IS NULL) AND (X_nslds_pell_seq_num_2 IS NULL)))
2385 AND ((tlinfo.nslds_pell_verify_f_2 = x_nslds_pell_verify_f_2) OR ((tlinfo.nslds_pell_verify_f_2 IS NULL) AND (X_nslds_pell_verify_f_2 IS NULL)))
2386 AND ((tlinfo.nslds_pell_efc_2 = x_nslds_pell_efc_2) OR ((tlinfo.nslds_pell_efc_2 IS NULL) AND (X_nslds_pell_efc_2 IS NULL)))
2387 AND ((tlinfo.nslds_pell_school_code_2 = x_nslds_pell_school_code_2) OR ((tlinfo.nslds_pell_school_code_2 IS NULL) AND (X_nslds_pell_school_code_2 IS NULL)))
2388 AND ((tlinfo.nslds_pell_transcn_num_2 = x_nslds_pell_transcn_num_2) OR ((tlinfo.nslds_pell_transcn_num_2 IS NULL) AND (X_nslds_pell_transcn_num_2 IS NULL)))
2389 AND ((tlinfo.nslds_pell_last_updt_dt_2 = x_nslds_pell_last_updt_dt_2) OR ((tlinfo.nslds_pell_last_updt_dt_2 IS NULL) AND (X_nslds_pell_last_updt_dt_2 IS NULL)))
2390 AND ((tlinfo.nslds_pell_scheduled_amt_2 = x_nslds_pell_scheduled_amt_2) OR ((tlinfo.nslds_pell_scheduled_amt_2 IS NULL) AND (X_nslds_pell_scheduled_amt_2 IS NULL)))
2391 AND ((tlinfo.nslds_pell_amt_paid_todt_2 = x_nslds_pell_amt_paid_todt_2) OR ((tlinfo.nslds_pell_amt_paid_todt_2 IS NULL) AND (X_nslds_pell_amt_paid_todt_2 IS NULL)))
2392 AND ((tlinfo.nslds_pell_remng_amt_2 = x_nslds_pell_remng_amt_2) OR ((tlinfo.nslds_pell_remng_amt_2 IS NULL) AND (X_nslds_pell_remng_amt_2 IS NULL)))
2393 AND ((tlinfo.nslds_pell_pc_schd_awd_us_2 = x_nslds_pell_pc_schd_awd_us_2) OR ((tlinfo.nslds_pell_pc_schd_awd_us_2 IS NULL) AND (X_nslds_pell_pc_schd_awd_us_2 IS NULL)))
2394 AND ((tlinfo.nslds_pell_award_amt_2 = x_nslds_pell_award_amt_2) OR ((tlinfo.nslds_pell_award_amt_2 IS NULL) AND (X_nslds_pell_award_amt_2 IS NULL)))
2395 AND ((tlinfo.nslds_pell_seq_num_3 = x_nslds_pell_seq_num_3) OR ((tlinfo.nslds_pell_seq_num_3 IS NULL) AND (X_nslds_pell_seq_num_3 IS NULL)))
2396 AND ((tlinfo.nslds_pell_verify_f_3 = x_nslds_pell_verify_f_3) OR ((tlinfo.nslds_pell_verify_f_3 IS NULL) AND (X_nslds_pell_verify_f_3 IS NULL)))
2397 AND ((tlinfo.nslds_pell_efc_3 = x_nslds_pell_efc_3) OR ((tlinfo.nslds_pell_efc_3 IS NULL) AND (X_nslds_pell_efc_3 IS NULL)))
2398 AND ((tlinfo.nslds_pell_school_code_3 = x_nslds_pell_school_code_3) OR ((tlinfo.nslds_pell_school_code_3 IS NULL) AND (X_nslds_pell_school_code_3 IS NULL)))
2399 AND ((tlinfo.nslds_pell_transcn_num_3 = x_nslds_pell_transcn_num_3) OR ((tlinfo.nslds_pell_transcn_num_3 IS NULL) AND (X_nslds_pell_transcn_num_3 IS NULL)))
2400 AND ((tlinfo.nslds_pell_last_updt_dt_3 = x_nslds_pell_last_updt_dt_3) OR ((tlinfo.nslds_pell_last_updt_dt_3 IS NULL) AND (X_nslds_pell_last_updt_dt_3 IS NULL)))
2401 AND ((tlinfo.nslds_pell_scheduled_amt_3 = x_nslds_pell_scheduled_amt_3) OR ((tlinfo.nslds_pell_scheduled_amt_3 IS NULL) AND (X_nslds_pell_scheduled_amt_3 IS NULL)))
2402 AND ((tlinfo.nslds_pell_amt_paid_todt_3 = x_nslds_pell_amt_paid_todt_3) OR ((tlinfo.nslds_pell_amt_paid_todt_3 IS NULL) AND (X_nslds_pell_amt_paid_todt_3 IS NULL)))
2403 AND ((tlinfo.nslds_pell_remng_amt_3 = x_nslds_pell_remng_amt_3) OR ((tlinfo.nslds_pell_remng_amt_3 IS NULL) AND (X_nslds_pell_remng_amt_3 IS NULL)))
2404 AND ((tlinfo.nslds_pell_pc_schd_awd_us_3 = x_nslds_pell_pc_schd_awd_us_3) OR ((tlinfo.nslds_pell_pc_schd_awd_us_3 IS NULL) AND (X_nslds_pell_pc_schd_awd_us_3 IS NULL)))
2405 AND ((tlinfo.nslds_pell_award_amt_3 = x_nslds_pell_award_amt_3) OR ((tlinfo.nslds_pell_award_amt_3 IS NULL) AND (X_nslds_pell_award_amt_3 IS NULL)))
2406 AND ((tlinfo.nslds_loan_seq_num_1 = x_nslds_loan_seq_num_1) OR ((tlinfo.nslds_loan_seq_num_1 IS NULL) AND (X_nslds_loan_seq_num_1 IS NULL)))
2407 AND ((tlinfo.nslds_loan_type_code_1 = x_nslds_loan_type_code_1) OR ((tlinfo.nslds_loan_type_code_1 IS NULL) AND (X_nslds_loan_type_code_1 IS NULL)))
2408 AND ((tlinfo.nslds_loan_chng_f_1 = x_nslds_loan_chng_f_1) OR ((tlinfo.nslds_loan_chng_f_1 IS NULL) AND (X_nslds_loan_chng_f_1 IS NULL)))
2409 AND ((tlinfo.nslds_loan_prog_code_1 = x_nslds_loan_prog_code_1) OR ((tlinfo.nslds_loan_prog_code_1 IS NULL) AND (X_nslds_loan_prog_code_1 IS NULL)))
2410 AND ((tlinfo.nslds_loan_net_amnt_1 = x_nslds_loan_net_amnt_1) OR ((tlinfo.nslds_loan_net_amnt_1 IS NULL) AND (X_nslds_loan_net_amnt_1 IS NULL)))
2411 AND ((tlinfo.nslds_loan_cur_st_code_1 = x_nslds_loan_cur_st_code_1) OR ((tlinfo.nslds_loan_cur_st_code_1 IS NULL) AND (X_nslds_loan_cur_st_code_1 IS NULL)))
2412 AND ((tlinfo.nslds_loan_cur_st_date_1 = x_nslds_loan_cur_st_date_1) OR ((tlinfo.nslds_loan_cur_st_date_1 IS NULL) AND (X_nslds_loan_cur_st_date_1 IS NULL)))
2413 AND ((tlinfo.nslds_loan_agg_pr_bal_1 = x_nslds_loan_agg_pr_bal_1) OR ((tlinfo.nslds_loan_agg_pr_bal_1 IS NULL) AND (X_nslds_loan_agg_pr_bal_1 IS NULL)))
2414 AND ((tlinfo.nslds_loan_out_pr_bal_dt_1 = x_nslds_loan_out_pr_bal_dt_1) OR ((tlinfo.nslds_loan_out_pr_bal_dt_1 IS NULL) AND (X_nslds_loan_out_pr_bal_dt_1 IS NULL)))
2415 AND ((tlinfo.nslds_loan_begin_dt_1 = x_nslds_loan_begin_dt_1) OR ((tlinfo.nslds_loan_begin_dt_1 IS NULL) AND (X_nslds_loan_begin_dt_1 IS NULL)))
2416 AND ((tlinfo.nslds_loan_end_dt_1 = x_nslds_loan_end_dt_1) OR ((tlinfo.nslds_loan_end_dt_1 IS NULL) AND (X_nslds_loan_end_dt_1 IS NULL)))
2417 AND ((tlinfo.nslds_loan_ga_code_1 = x_nslds_loan_ga_code_1) OR ((tlinfo.nslds_loan_ga_code_1 IS NULL) AND (X_nslds_loan_ga_code_1 IS NULL)))
2418 AND ((tlinfo.nslds_loan_cont_type_1 = x_nslds_loan_cont_type_1) OR ((tlinfo.nslds_loan_cont_type_1 IS NULL) AND (X_nslds_loan_cont_type_1 IS NULL)))
2419 AND ((tlinfo.nslds_loan_schol_code_1 = x_nslds_loan_schol_code_1) OR ((tlinfo.nslds_loan_schol_code_1 IS NULL) AND (X_nslds_loan_schol_code_1 IS NULL)))
2420 AND ((tlinfo.nslds_loan_cont_code_1 = x_nslds_loan_cont_code_1) OR ((tlinfo.nslds_loan_cont_code_1 IS NULL) AND (X_nslds_loan_cont_code_1 IS NULL)))
2421 AND ((tlinfo.nslds_loan_grade_lvl_1 = x_nslds_loan_grade_lvl_1) OR ((tlinfo.nslds_loan_grade_lvl_1 IS NULL) AND (X_nslds_loan_grade_lvl_1 IS NULL)))
2422 AND ((tlinfo.nslds_loan_xtr_unsbz_ln_f_1 = x_nslds_loan_xtr_unsbz_ln_f_1) OR ((tlinfo.nslds_loan_xtr_unsbz_ln_f_1 IS NULL) AND (X_nslds_loan_xtr_unsbz_ln_f_1 IS NULL)))
2423 AND ((tlinfo.nslds_loan_capital_int_f_1 = x_nslds_loan_capital_int_f_1) OR ((tlinfo.nslds_loan_capital_int_f_1 IS NULL) AND (X_nslds_loan_capital_int_f_1 IS NULL)))
2424 AND ((tlinfo.nslds_loan_seq_num_2 = x_nslds_loan_seq_num_2) OR ((tlinfo.nslds_loan_seq_num_2 IS NULL) AND (X_nslds_loan_seq_num_2 IS NULL)))
2425 AND ((tlinfo.nslds_loan_type_code_2 = x_nslds_loan_type_code_2) OR ((tlinfo.nslds_loan_type_code_2 IS NULL) AND (X_nslds_loan_type_code_2 IS NULL)))
2426 AND ((tlinfo.nslds_loan_chng_f_2 = x_nslds_loan_chng_f_2) OR ((tlinfo.nslds_loan_chng_f_2 IS NULL) AND (X_nslds_loan_chng_f_2 IS NULL)))
2427 AND ((tlinfo.nslds_loan_prog_code_2 = x_nslds_loan_prog_code_2) OR ((tlinfo.nslds_loan_prog_code_2 IS NULL) AND (X_nslds_loan_prog_code_2 IS NULL)))
2428 AND ((tlinfo.nslds_loan_net_amnt_2 = x_nslds_loan_net_amnt_2) OR ((tlinfo.nslds_loan_net_amnt_2 IS NULL) AND (X_nslds_loan_net_amnt_2 IS NULL)))
2429 AND ((tlinfo.nslds_loan_cur_st_code_2 = x_nslds_loan_cur_st_code_2) OR ((tlinfo.nslds_loan_cur_st_code_2 IS NULL) AND (X_nslds_loan_cur_st_code_2 IS NULL)))
2430 AND ((tlinfo.nslds_loan_cur_st_date_2 = x_nslds_loan_cur_st_date_2) OR ((tlinfo.nslds_loan_cur_st_date_2 IS NULL) AND (X_nslds_loan_cur_st_date_2 IS NULL)))
2431 AND ((tlinfo.nslds_loan_agg_pr_bal_2 = x_nslds_loan_agg_pr_bal_2) OR ((tlinfo.nslds_loan_agg_pr_bal_2 IS NULL) AND (X_nslds_loan_agg_pr_bal_2 IS NULL)))
2432 AND ((tlinfo.nslds_loan_out_pr_bal_dt_2 = x_nslds_loan_out_pr_bal_dt_2) OR ((tlinfo.nslds_loan_out_pr_bal_dt_2 IS NULL) AND (X_nslds_loan_out_pr_bal_dt_2 IS NULL)))
2433 AND ((tlinfo.nslds_loan_begin_dt_2 = x_nslds_loan_begin_dt_2) OR ((tlinfo.nslds_loan_begin_dt_2 IS NULL) AND (X_nslds_loan_begin_dt_2 IS NULL)))
2434 AND ((tlinfo.nslds_loan_end_dt_2 = x_nslds_loan_end_dt_2) OR ((tlinfo.nslds_loan_end_dt_2 IS NULL) AND (X_nslds_loan_end_dt_2 IS NULL)))
2435 AND ((tlinfo.nslds_loan_ga_code_2 = x_nslds_loan_ga_code_2) OR ((tlinfo.nslds_loan_ga_code_2 IS NULL) AND (X_nslds_loan_ga_code_2 IS NULL)))
2436 AND ((tlinfo.nslds_loan_cont_type_2 = x_nslds_loan_cont_type_2) OR ((tlinfo.nslds_loan_cont_type_2 IS NULL) AND (X_nslds_loan_cont_type_2 IS NULL)))
2437 AND ((tlinfo.nslds_loan_schol_code_2 = x_nslds_loan_schol_code_2) OR ((tlinfo.nslds_loan_schol_code_2 IS NULL) AND (X_nslds_loan_schol_code_2 IS NULL)))
2438 AND ((tlinfo.nslds_loan_cont_code_2 = x_nslds_loan_cont_code_2) OR ((tlinfo.nslds_loan_cont_code_2 IS NULL) AND (X_nslds_loan_cont_code_2 IS NULL)))
2439 AND ((tlinfo.nslds_loan_grade_lvl_2 = x_nslds_loan_grade_lvl_2) OR ((tlinfo.nslds_loan_grade_lvl_2 IS NULL) AND (X_nslds_loan_grade_lvl_2 IS NULL)))
2440 AND ((tlinfo.nslds_loan_xtr_unsbz_ln_f_2 = x_nslds_loan_xtr_unsbz_ln_f_2) OR ((tlinfo.nslds_loan_xtr_unsbz_ln_f_2 IS NULL) AND (X_nslds_loan_xtr_unsbz_ln_f_2 IS NULL)))
2441 AND ((tlinfo.nslds_loan_capital_int_f_2 = x_nslds_loan_capital_int_f_2) OR ((tlinfo.nslds_loan_capital_int_f_2 IS NULL) AND (X_nslds_loan_capital_int_f_2 IS NULL)))
2442 AND ((tlinfo.nslds_loan_seq_num_3 = x_nslds_loan_seq_num_3) OR ((tlinfo.nslds_loan_seq_num_3 IS NULL) AND (X_nslds_loan_seq_num_3 IS NULL)))
2443 AND ((tlinfo.nslds_loan_type_code_3 = x_nslds_loan_type_code_3) OR ((tlinfo.nslds_loan_type_code_3 IS NULL) AND (X_nslds_loan_type_code_3 IS NULL)))
2444 AND ((tlinfo.nslds_loan_chng_f_3 = x_nslds_loan_chng_f_3) OR ((tlinfo.nslds_loan_chng_f_3 IS NULL) AND (X_nslds_loan_chng_f_3 IS NULL)))
2445 AND ((tlinfo.nslds_loan_prog_code_3 = x_nslds_loan_prog_code_3) OR ((tlinfo.nslds_loan_prog_code_3 IS NULL) AND (X_nslds_loan_prog_code_3 IS NULL)))
2446 AND ((tlinfo.nslds_loan_net_amnt_3 = x_nslds_loan_net_amnt_3) OR ((tlinfo.nslds_loan_net_amnt_3 IS NULL) AND (X_nslds_loan_net_amnt_3 IS NULL)))
2447 AND ((tlinfo.nslds_loan_cur_st_code_3 = x_nslds_loan_cur_st_code_3) OR ((tlinfo.nslds_loan_cur_st_code_3 IS NULL) AND (X_nslds_loan_cur_st_code_3 IS NULL)))
2448 AND ((tlinfo.nslds_loan_cur_st_date_3 = x_nslds_loan_cur_st_date_3) OR ((tlinfo.nslds_loan_cur_st_date_3 IS NULL) AND (X_nslds_loan_cur_st_date_3 IS NULL)))
2449 AND ((tlinfo.nslds_loan_agg_pr_bal_3 = x_nslds_loan_agg_pr_bal_3) OR ((tlinfo.nslds_loan_agg_pr_bal_3 IS NULL) AND (X_nslds_loan_agg_pr_bal_3 IS NULL)))
2450 AND ((tlinfo.nslds_loan_out_pr_bal_dt_3 = x_nslds_loan_out_pr_bal_dt_3) OR ((tlinfo.nslds_loan_out_pr_bal_dt_3 IS NULL) AND (X_nslds_loan_out_pr_bal_dt_3 IS NULL)))
2451 AND ((tlinfo.nslds_loan_begin_dt_3 = x_nslds_loan_begin_dt_3) OR ((tlinfo.nslds_loan_begin_dt_3 IS NULL) AND (X_nslds_loan_begin_dt_3 IS NULL)))
2452 AND ((tlinfo.nslds_loan_end_dt_3 = x_nslds_loan_end_dt_3) OR ((tlinfo.nslds_loan_end_dt_3 IS NULL) AND (X_nslds_loan_end_dt_3 IS NULL)))
2453 AND ((tlinfo.nslds_loan_ga_code_3 = x_nslds_loan_ga_code_3) OR ((tlinfo.nslds_loan_ga_code_3 IS NULL) AND (X_nslds_loan_ga_code_3 IS NULL)))
2454 AND ((tlinfo.nslds_loan_cont_type_3 = x_nslds_loan_cont_type_3) OR ((tlinfo.nslds_loan_cont_type_3 IS NULL) AND (X_nslds_loan_cont_type_3 IS NULL)))
2455 AND ((tlinfo.nslds_loan_schol_code_3 = x_nslds_loan_schol_code_3) OR ((tlinfo.nslds_loan_schol_code_3 IS NULL) AND (X_nslds_loan_schol_code_3 IS NULL)))
2456 AND ((tlinfo.nslds_loan_cont_code_3 = x_nslds_loan_cont_code_3) OR ((tlinfo.nslds_loan_cont_code_3 IS NULL) AND (X_nslds_loan_cont_code_3 IS NULL)))
2457 AND ((tlinfo.nslds_loan_grade_lvl_3 = x_nslds_loan_grade_lvl_3) OR ((tlinfo.nslds_loan_grade_lvl_3 IS NULL) AND (X_nslds_loan_grade_lvl_3 IS NULL)))
2458 AND ((tlinfo.nslds_loan_xtr_unsbz_ln_f_3 = x_nslds_loan_xtr_unsbz_ln_f_3) OR ((tlinfo.nslds_loan_xtr_unsbz_ln_f_3 IS NULL) AND (X_nslds_loan_xtr_unsbz_ln_f_3 IS NULL)))
2459 AND ((tlinfo.nslds_loan_capital_int_f_3 = x_nslds_loan_capital_int_f_3) OR ((tlinfo.nslds_loan_capital_int_f_3 IS NULL) AND (X_nslds_loan_capital_int_f_3 IS NULL)))
2460 AND ((tlinfo.nslds_loan_seq_num_4 = x_nslds_loan_seq_num_4) OR ((tlinfo.nslds_loan_seq_num_4 IS NULL) AND (X_nslds_loan_seq_num_4 IS NULL)))
2461 AND ((tlinfo.nslds_loan_type_code_4 = x_nslds_loan_type_code_4) OR ((tlinfo.nslds_loan_type_code_4 IS NULL) AND (X_nslds_loan_type_code_4 IS NULL)))
2462 AND ((tlinfo.nslds_loan_chng_f_4 = x_nslds_loan_chng_f_4) OR ((tlinfo.nslds_loan_chng_f_4 IS NULL) AND (X_nslds_loan_chng_f_4 IS NULL)))
2463 AND ((tlinfo.nslds_loan_prog_code_4 = x_nslds_loan_prog_code_4) OR ((tlinfo.nslds_loan_prog_code_4 IS NULL) AND (X_nslds_loan_prog_code_4 IS NULL)))
2464 AND ((tlinfo.nslds_loan_net_amnt_4 = x_nslds_loan_net_amnt_4) OR ((tlinfo.nslds_loan_net_amnt_4 IS NULL) AND (X_nslds_loan_net_amnt_4 IS NULL)))
2465 AND ((tlinfo.nslds_loan_cur_st_code_4 = x_nslds_loan_cur_st_code_4) OR ((tlinfo.nslds_loan_cur_st_code_4 IS NULL) AND (X_nslds_loan_cur_st_code_4 IS NULL)))
2466 AND ((tlinfo.nslds_loan_cur_st_date_4 = x_nslds_loan_cur_st_date_4) OR ((tlinfo.nslds_loan_cur_st_date_4 IS NULL) AND (X_nslds_loan_cur_st_date_4 IS NULL)))
2467 AND ((tlinfo.nslds_loan_agg_pr_bal_4 = x_nslds_loan_agg_pr_bal_4) OR ((tlinfo.nslds_loan_agg_pr_bal_4 IS NULL) AND (X_nslds_loan_agg_pr_bal_4 IS NULL)))
2468 AND ((tlinfo.nslds_loan_out_pr_bal_dt_4 = x_nslds_loan_out_pr_bal_dt_4) OR ((tlinfo.nslds_loan_out_pr_bal_dt_4 IS NULL) AND (X_nslds_loan_out_pr_bal_dt_4 IS NULL)))
2469 AND ((tlinfo.nslds_loan_begin_dt_4 = x_nslds_loan_begin_dt_4) OR ((tlinfo.nslds_loan_begin_dt_4 IS NULL) AND (X_nslds_loan_begin_dt_4 IS NULL)))
2470 AND ((tlinfo.nslds_loan_end_dt_4 = x_nslds_loan_end_dt_4) OR ((tlinfo.nslds_loan_end_dt_4 IS NULL) AND (X_nslds_loan_end_dt_4 IS NULL)))
2471 AND ((tlinfo.nslds_loan_ga_code_4 = x_nslds_loan_ga_code_4) OR ((tlinfo.nslds_loan_ga_code_4 IS NULL) AND (X_nslds_loan_ga_code_4 IS NULL)))
2472 AND ((tlinfo.nslds_loan_cont_type_4 = x_nslds_loan_cont_type_4) OR ((tlinfo.nslds_loan_cont_type_4 IS NULL) AND (X_nslds_loan_cont_type_4 IS NULL)))
2473 AND ((tlinfo.nslds_loan_schol_code_4 = x_nslds_loan_schol_code_4) OR ((tlinfo.nslds_loan_schol_code_4 IS NULL) AND (X_nslds_loan_schol_code_4 IS NULL)))
2474 AND ((tlinfo.nslds_loan_cont_code_4 = x_nslds_loan_cont_code_4) OR ((tlinfo.nslds_loan_cont_code_4 IS NULL) AND (X_nslds_loan_cont_code_4 IS NULL)))
2475 AND ((tlinfo.nslds_loan_grade_lvl_4 = x_nslds_loan_grade_lvl_4) OR ((tlinfo.nslds_loan_grade_lvl_4 IS NULL) AND (X_nslds_loan_grade_lvl_4 IS NULL)))
2476 AND ((tlinfo.nslds_loan_xtr_unsbz_ln_f_4 = x_nslds_loan_xtr_unsbz_ln_f_4) OR ((tlinfo.nslds_loan_xtr_unsbz_ln_f_4 IS NULL) AND (X_nslds_loan_xtr_unsbz_ln_f_4 IS NULL)))
2477 AND ((tlinfo.nslds_loan_capital_int_f_4 = x_nslds_loan_capital_int_f_4) OR ((tlinfo.nslds_loan_capital_int_f_4 IS NULL) AND (X_nslds_loan_capital_int_f_4 IS NULL)))
2478 AND ((tlinfo.nslds_loan_seq_num_5 = x_nslds_loan_seq_num_5) OR ((tlinfo.nslds_loan_seq_num_5 IS NULL) AND (X_nslds_loan_seq_num_5 IS NULL)))
2479 AND ((tlinfo.nslds_loan_type_code_5 = x_nslds_loan_type_code_5) OR ((tlinfo.nslds_loan_type_code_5 IS NULL) AND (X_nslds_loan_type_code_5 IS NULL)))
2480 AND ((tlinfo.nslds_loan_chng_f_5 = x_nslds_loan_chng_f_5) OR ((tlinfo.nslds_loan_chng_f_5 IS NULL) AND (X_nslds_loan_chng_f_5 IS NULL)))
2481 AND ((tlinfo.nslds_loan_prog_code_5 = x_nslds_loan_prog_code_5) OR ((tlinfo.nslds_loan_prog_code_5 IS NULL) AND (X_nslds_loan_prog_code_5 IS NULL)))
2482 AND ((tlinfo.nslds_loan_net_amnt_5 = x_nslds_loan_net_amnt_5) OR ((tlinfo.nslds_loan_net_amnt_5 IS NULL) AND (X_nslds_loan_net_amnt_5 IS NULL)))
2483 AND ((tlinfo.nslds_loan_cur_st_code_5 = x_nslds_loan_cur_st_code_5) OR ((tlinfo.nslds_loan_cur_st_code_5 IS NULL) AND (X_nslds_loan_cur_st_code_5 IS NULL)))
2484 AND ((tlinfo.nslds_loan_cur_st_date_5 = x_nslds_loan_cur_st_date_5) OR ((tlinfo.nslds_loan_cur_st_date_5 IS NULL) AND (X_nslds_loan_cur_st_date_5 IS NULL)))
2485 AND ((tlinfo.nslds_loan_agg_pr_bal_5 = x_nslds_loan_agg_pr_bal_5) OR ((tlinfo.nslds_loan_agg_pr_bal_5 IS NULL) AND (X_nslds_loan_agg_pr_bal_5 IS NULL)))
2486 AND ((tlinfo.nslds_loan_out_pr_bal_dt_5 = x_nslds_loan_out_pr_bal_dt_5) OR ((tlinfo.nslds_loan_out_pr_bal_dt_5 IS NULL) AND (X_nslds_loan_out_pr_bal_dt_5 IS NULL)))
2487 AND ((tlinfo.nslds_loan_begin_dt_5 = x_nslds_loan_begin_dt_5) OR ((tlinfo.nslds_loan_begin_dt_5 IS NULL) AND (X_nslds_loan_begin_dt_5 IS NULL)))
2488 AND ((tlinfo.nslds_loan_end_dt_5 = x_nslds_loan_end_dt_5) OR ((tlinfo.nslds_loan_end_dt_5 IS NULL) AND (X_nslds_loan_end_dt_5 IS NULL)))
2489 AND ((tlinfo.nslds_loan_ga_code_5 = x_nslds_loan_ga_code_5) OR ((tlinfo.nslds_loan_ga_code_5 IS NULL) AND (X_nslds_loan_ga_code_5 IS NULL)))
2490 AND ((tlinfo.nslds_loan_cont_type_5 = x_nslds_loan_cont_type_5) OR ((tlinfo.nslds_loan_cont_type_5 IS NULL) AND (X_nslds_loan_cont_type_5 IS NULL)))
2491 AND ((tlinfo.nslds_loan_schol_code_5 = x_nslds_loan_schol_code_5) OR ((tlinfo.nslds_loan_schol_code_5 IS NULL) AND (X_nslds_loan_schol_code_5 IS NULL)))
2492 AND ((tlinfo.nslds_loan_cont_code_5 = x_nslds_loan_cont_code_5) OR ((tlinfo.nslds_loan_cont_code_5 IS NULL) AND (X_nslds_loan_cont_code_5 IS NULL)))
2493 AND ((tlinfo.nslds_loan_grade_lvl_5 = x_nslds_loan_grade_lvl_5) OR ((tlinfo.nslds_loan_grade_lvl_5 IS NULL) AND (X_nslds_loan_grade_lvl_5 IS NULL)))
2494 AND ((tlinfo.nslds_loan_xtr_unsbz_ln_f_5 = x_nslds_loan_xtr_unsbz_ln_f_5) OR ((tlinfo.nslds_loan_xtr_unsbz_ln_f_5 IS NULL) AND (X_nslds_loan_xtr_unsbz_ln_f_5 IS NULL)))
2495 AND ((tlinfo.nslds_loan_capital_int_f_5 = x_nslds_loan_capital_int_f_5) OR ((tlinfo.nslds_loan_capital_int_f_5 IS NULL) AND (X_nslds_loan_capital_int_f_5 IS NULL)))
2496 AND ((tlinfo.nslds_loan_seq_num_6 = x_nslds_loan_seq_num_6) OR ((tlinfo.nslds_loan_seq_num_6 IS NULL) AND (X_nslds_loan_seq_num_6 IS NULL)))
2497 AND ((tlinfo.nslds_loan_type_code_6 = x_nslds_loan_type_code_6) OR ((tlinfo.nslds_loan_type_code_6 IS NULL) AND (X_nslds_loan_type_code_6 IS NULL)))
2498 AND ((tlinfo.nslds_loan_chng_f_6 = x_nslds_loan_chng_f_6) OR ((tlinfo.nslds_loan_chng_f_6 IS NULL) AND (X_nslds_loan_chng_f_6 IS NULL)))
2499 AND ((tlinfo.nslds_loan_prog_code_6 = x_nslds_loan_prog_code_6) OR ((tlinfo.nslds_loan_prog_code_6 IS NULL) AND (X_nslds_loan_prog_code_6 IS NULL)))
2500 AND ((tlinfo.nslds_loan_net_amnt_6 = x_nslds_loan_net_amnt_6) OR ((tlinfo.nslds_loan_net_amnt_6 IS NULL) AND (X_nslds_loan_net_amnt_6 IS NULL)))
2501 AND ((tlinfo.nslds_loan_cur_st_code_6 = x_nslds_loan_cur_st_code_6) OR ((tlinfo.nslds_loan_cur_st_code_6 IS NULL) AND (X_nslds_loan_cur_st_code_6 IS NULL)))
2502 AND ((tlinfo.nslds_loan_cur_st_date_6 = x_nslds_loan_cur_st_date_6) OR ((tlinfo.nslds_loan_cur_st_date_6 IS NULL) AND (X_nslds_loan_cur_st_date_6 IS NULL)))
2503 AND ((tlinfo.nslds_loan_agg_pr_bal_6 = x_nslds_loan_agg_pr_bal_6) OR ((tlinfo.nslds_loan_agg_pr_bal_6 IS NULL) AND (X_nslds_loan_agg_pr_bal_6 IS NULL)))
2504 AND ((tlinfo.nslds_loan_out_pr_bal_dt_6 = x_nslds_loan_out_pr_bal_dt_6) OR ((tlinfo.nslds_loan_out_pr_bal_dt_6 IS NULL) AND (X_nslds_loan_out_pr_bal_dt_6 IS NULL)))
2505 AND ((tlinfo.nslds_loan_begin_dt_6 = x_nslds_loan_begin_dt_6) OR ((tlinfo.nslds_loan_begin_dt_6 IS NULL) AND (X_nslds_loan_begin_dt_6 IS NULL)))
2506 AND ((tlinfo.nslds_loan_end_dt_6 = x_nslds_loan_end_dt_6) OR ((tlinfo.nslds_loan_end_dt_6 IS NULL) AND (X_nslds_loan_end_dt_6 IS NULL)))
2507 AND ((tlinfo.nslds_loan_ga_code_6 = x_nslds_loan_ga_code_6) OR ((tlinfo.nslds_loan_ga_code_6 IS NULL) AND (X_nslds_loan_ga_code_6 IS NULL)))
2508 AND ((tlinfo.nslds_loan_cont_type_6 = x_nslds_loan_cont_type_6) OR ((tlinfo.nslds_loan_cont_type_6 IS NULL) AND (X_nslds_loan_cont_type_6 IS NULL)))
2509 AND ((tlinfo.nslds_loan_schol_code_6 = x_nslds_loan_schol_code_6) OR ((tlinfo.nslds_loan_schol_code_6 IS NULL) AND (X_nslds_loan_schol_code_6 IS NULL)))
2510 AND ((tlinfo.nslds_loan_cont_code_6 = x_nslds_loan_cont_code_6) OR ((tlinfo.nslds_loan_cont_code_6 IS NULL) AND (X_nslds_loan_cont_code_6 IS NULL)))
2511 AND ((tlinfo.nslds_loan_grade_lvl_6 = x_nslds_loan_grade_lvl_6) OR ((tlinfo.nslds_loan_grade_lvl_6 IS NULL) AND (X_nslds_loan_grade_lvl_6 IS NULL)))
2512 AND ((tlinfo.nslds_loan_xtr_unsbz_ln_f_6 = x_nslds_loan_xtr_unsbz_ln_f_6) OR ((tlinfo.nslds_loan_xtr_unsbz_ln_f_6 IS NULL) AND (X_nslds_loan_xtr_unsbz_ln_f_6 IS NULL)))
2513 AND ((tlinfo.nslds_loan_capital_int_f_6 = x_nslds_loan_capital_int_f_6) OR ((tlinfo.nslds_loan_capital_int_f_6 IS NULL) AND (X_nslds_loan_capital_int_f_6 IS NULL)))
2514 AND ((tlinfo.nslds_loan_last_d_amt_1 = x_nslds_loan_last_d_amt_1) OR ((tlinfo.nslds_loan_last_d_amt_1 IS NULL) AND (x_nslds_loan_last_d_amt_1 IS NULL)))
2515 AND ((tlinfo.nslds_loan_last_d_date_1 = x_nslds_loan_last_d_date_1) OR ((tlinfo.nslds_loan_last_d_date_1 IS NULL) AND (x_nslds_loan_last_d_date_1 IS NULL)))
2516 AND ((tlinfo.nslds_loan_last_d_amt_2 = x_nslds_loan_last_d_amt_2) OR ((tlinfo.nslds_loan_last_d_amt_2 IS NULL) AND (x_nslds_loan_last_d_amt_2 IS NULL)))
2517 AND ((tlinfo.nslds_loan_last_d_date_2 = x_nslds_loan_last_d_date_2) OR ((tlinfo.nslds_loan_last_d_date_2 IS NULL) AND (x_nslds_loan_last_d_date_2 IS NULL)))
2518 AND ((tlinfo.nslds_loan_last_d_amt_3 = x_nslds_loan_last_d_amt_3 ) OR ((tlinfo.nslds_loan_last_d_amt_3 IS NULL) AND (x_nslds_loan_last_d_amt_3 IS NULL)))
2519 AND ((tlinfo.nslds_loan_last_d_date_3 = x_nslds_loan_last_d_date_3) OR ((tlinfo.nslds_loan_last_d_date_3 IS NULL) AND (x_nslds_loan_last_d_date_3 IS NULL)))
2520 AND ((tlinfo.nslds_loan_last_d_amt_4 = x_nslds_loan_last_d_amt_4 ) OR ((tlinfo.nslds_loan_last_d_amt_4 IS NULL) AND (x_nslds_loan_last_d_amt_4 IS NULL)))
2521 AND ((tlinfo.nslds_loan_last_d_date_4 = x_nslds_loan_last_d_date_4) OR ((tlinfo.nslds_loan_last_d_date_4 IS NULL) AND (x_nslds_loan_last_d_date_4 IS NULL)))
2522 AND ((tlinfo.nslds_loan_last_d_amt_5 = x_nslds_loan_last_d_amt_5) OR ((tlinfo.nslds_loan_last_d_amt_5 IS NULL) AND (x_nslds_loan_last_d_amt_5 IS NULL)))
2523 AND ((tlinfo.nslds_loan_last_d_date_5 = x_nslds_loan_last_d_date_5 ) OR ((tlinfo.nslds_loan_last_d_date_5 IS NULL) AND (x_nslds_loan_last_d_date_5 IS NULL)))
2524 AND ((tlinfo.nslds_loan_last_d_amt_6 = x_nslds_loan_last_d_amt_6 ) OR ((tlinfo.nslds_loan_last_d_amt_6 IS NULL) AND (x_nslds_loan_last_d_amt_6 IS NULL)))
2525 AND ((tlinfo.nslds_loan_last_d_date_6 = x_nslds_loan_last_d_date_6 )OR ((tlinfo.nslds_loan_last_d_date_6 IS NULL) AND (x_nslds_loan_last_d_date_6 IS NULL)))
2526 AND ((tlinfo.dlp_master_prom_note_flag = x_dlp_master_prom_note_flag )OR ((tlinfo.dlp_master_prom_note_flag IS NULL) AND (x_dlp_master_prom_note_flag IS NULL)))
2527 AND ((tlinfo.subsidized_loan_limit_type = x_subsidized_loan_limit_type )OR ((tlinfo.subsidized_loan_limit_type IS NULL) AND (x_subsidized_loan_limit_type IS NULL)))
2528 AND ((tlinfo.combined_loan_limit_type = x_combined_loan_limit_type )OR ((tlinfo.combined_loan_limit_type IS NULL) AND (x_combined_loan_limit_type IS NULL)))
2529 AND ((tlinfo.transaction_num_txt = x_transaction_num_txt )OR ((tlinfo.transaction_num_txt IS NULL) AND (x_transaction_num_txt IS NULL)))
2530 ) THEN
2531 NULL;
2532 ELSE
2533 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2534 igs_ge_msg_stack.add;
2535 app_exception.raise_exception;
2536 END IF;
2537
2538 RETURN;
2539
2540 END lock_row;
2541
2542
2543 PROCEDURE update_row (
2544 x_rowid IN VARCHAR2,
2545 x_nslds_id IN NUMBER,
2546 x_isir_id IN NUMBER,
2547 x_base_id IN NUMBER,
2548 x_nslds_transaction_num IN NUMBER,
2549 x_nslds_database_results_f IN VARCHAR2,
2550 x_nslds_f IN VARCHAR2,
2551 x_nslds_pell_overpay_f IN VARCHAR2,
2552 x_nslds_pell_overpay_contact IN VARCHAR2,
2553 x_nslds_seog_overpay_f IN VARCHAR2,
2554 x_nslds_seog_overpay_contact IN VARCHAR2,
2555 x_nslds_perkins_overpay_f IN VARCHAR2,
2556 x_nslds_perkins_overpay_cntct IN VARCHAR2,
2557 x_nslds_defaulted_loan_f IN VARCHAR2,
2558 x_nslds_dischged_loan_chng_f IN VARCHAR2,
2559 x_nslds_satis_repay_f IN VARCHAR2,
2560 x_nslds_act_bankruptcy_f IN VARCHAR2,
2561 x_nslds_agg_subsz_out_prin_bal IN NUMBER,
2562 x_nslds_agg_unsbz_out_prin_bal IN NUMBER,
2563 x_nslds_agg_comb_out_prin_bal IN NUMBER,
2564 x_nslds_agg_cons_out_prin_bal IN NUMBER,
2565 x_nslds_agg_subsz_pend_dismt IN NUMBER,
2566 x_nslds_agg_unsbz_pend_dismt IN NUMBER,
2567 x_nslds_agg_comb_pend_dismt IN NUMBER,
2568 x_nslds_agg_subsz_total IN NUMBER,
2569 x_nslds_agg_unsbz_total IN NUMBER,
2570 x_nslds_agg_comb_total IN NUMBER,
2571 x_nslds_agg_consd_total IN NUMBER,
2572 x_nslds_perkins_out_bal IN NUMBER,
2573 x_nslds_perkins_cur_yr_dismnt IN NUMBER,
2574 x_nslds_default_loan_chng_f IN VARCHAR2,
2575 x_nslds_discharged_loan_f IN VARCHAR2,
2576 x_nslds_satis_repay_chng_f IN VARCHAR2,
2577 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
2578 x_nslds_overpay_chng_f IN VARCHAR2,
2579 x_nslds_agg_loan_chng_f IN VARCHAR2,
2580 x_nslds_perkins_loan_chng_f IN VARCHAR2,
2581 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
2582 x_nslds_addtnl_pell_f IN VARCHAR2,
2583 x_nslds_addtnl_loan_f IN VARCHAR2,
2584 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
2585 x_nslds_pell_seq_num_1 IN NUMBER,
2586 x_nslds_pell_verify_f_1 IN VARCHAR2,
2587 x_nslds_pell_efc_1 IN NUMBER,
2588 x_nslds_pell_school_code_1 IN NUMBER,
2589 x_nslds_pell_transcn_num_1 IN NUMBER,
2590 x_nslds_pell_last_updt_dt_1 IN DATE,
2591 x_nslds_pell_scheduled_amt_1 IN NUMBER,
2592 x_nslds_pell_amt_paid_todt_1 IN NUMBER,
2593 x_nslds_pell_remng_amt_1 IN NUMBER,
2594 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER,
2595 x_nslds_pell_award_amt_1 IN NUMBER,
2596 x_nslds_pell_seq_num_2 IN NUMBER,
2597 x_nslds_pell_verify_f_2 IN VARCHAR2,
2598 x_nslds_pell_efc_2 IN NUMBER,
2599 x_nslds_pell_school_code_2 IN NUMBER,
2600 x_nslds_pell_transcn_num_2 IN NUMBER,
2601 x_nslds_pell_last_updt_dt_2 IN DATE,
2602 x_nslds_pell_scheduled_amt_2 IN NUMBER,
2603 x_nslds_pell_amt_paid_todt_2 IN NUMBER,
2604 x_nslds_pell_remng_amt_2 IN NUMBER,
2605 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER,
2606 x_nslds_pell_award_amt_2 IN NUMBER,
2607 x_nslds_pell_seq_num_3 IN NUMBER,
2608 x_nslds_pell_verify_f_3 IN VARCHAR2,
2609 x_nslds_pell_efc_3 IN NUMBER,
2610 x_nslds_pell_school_code_3 IN NUMBER,
2611 x_nslds_pell_transcn_num_3 IN NUMBER,
2612 x_nslds_pell_last_updt_dt_3 IN DATE,
2613 x_nslds_pell_scheduled_amt_3 IN NUMBER,
2614 x_nslds_pell_amt_paid_todt_3 IN NUMBER,
2615 x_nslds_pell_remng_amt_3 IN NUMBER,
2616 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER,
2617 x_nslds_pell_award_amt_3 IN NUMBER,
2618 x_nslds_loan_seq_num_1 IN NUMBER,
2619 x_nslds_loan_type_code_1 IN VARCHAR2,
2620 x_nslds_loan_chng_f_1 IN VARCHAR2,
2621 x_nslds_loan_prog_code_1 IN VARCHAR2,
2622 x_nslds_loan_net_amnt_1 IN NUMBER,
2623 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
2624 x_nslds_loan_cur_st_date_1 IN DATE,
2625 x_nslds_loan_agg_pr_bal_1 IN NUMBER,
2626 x_nslds_loan_out_pr_bal_dt_1 IN DATE,
2627 x_nslds_loan_begin_dt_1 IN DATE,
2628 x_nslds_loan_end_dt_1 IN DATE,
2629 x_nslds_loan_ga_code_1 IN VARCHAR2,
2630 x_nslds_loan_cont_type_1 IN VARCHAR2,
2631 x_nslds_loan_schol_code_1 IN VARCHAR2,
2632 x_nslds_loan_cont_code_1 IN VARCHAR2,
2633 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
2634 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
2635 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
2636 x_nslds_loan_seq_num_2 IN NUMBER,
2637 x_nslds_loan_type_code_2 IN VARCHAR2,
2638 x_nslds_loan_chng_f_2 IN VARCHAR2,
2639 x_nslds_loan_prog_code_2 IN VARCHAR2,
2640 x_nslds_loan_net_amnt_2 IN NUMBER,
2641 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
2642 x_nslds_loan_cur_st_date_2 IN DATE,
2643 x_nslds_loan_agg_pr_bal_2 IN NUMBER,
2644 x_nslds_loan_out_pr_bal_dt_2 IN DATE,
2645 x_nslds_loan_begin_dt_2 IN DATE,
2646 x_nslds_loan_end_dt_2 IN DATE,
2647 x_nslds_loan_ga_code_2 IN VARCHAR2,
2648 x_nslds_loan_cont_type_2 IN VARCHAR2,
2649 x_nslds_loan_schol_code_2 IN VARCHAR2,
2650 x_nslds_loan_cont_code_2 IN VARCHAR2,
2651 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
2652 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
2653 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
2654 x_nslds_loan_seq_num_3 IN NUMBER,
2655 x_nslds_loan_type_code_3 IN VARCHAR2,
2656 x_nslds_loan_chng_f_3 IN VARCHAR2,
2657 x_nslds_loan_prog_code_3 IN VARCHAR2,
2658 x_nslds_loan_net_amnt_3 IN NUMBER,
2659 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
2660 x_nslds_loan_cur_st_date_3 IN DATE,
2661 x_nslds_loan_agg_pr_bal_3 IN NUMBER,
2662 x_nslds_loan_out_pr_bal_dt_3 IN DATE,
2663 x_nslds_loan_begin_dt_3 IN DATE,
2664 x_nslds_loan_end_dt_3 IN DATE,
2665 x_nslds_loan_ga_code_3 IN VARCHAR2,
2666 x_nslds_loan_cont_type_3 IN VARCHAR2,
2667 x_nslds_loan_schol_code_3 IN VARCHAR2,
2668 x_nslds_loan_cont_code_3 IN VARCHAR2,
2669 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
2670 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
2671 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
2672 x_nslds_loan_seq_num_4 IN NUMBER,
2673 x_nslds_loan_type_code_4 IN VARCHAR2,
2674 x_nslds_loan_chng_f_4 IN VARCHAR2,
2675 x_nslds_loan_prog_code_4 IN VARCHAR2,
2676 x_nslds_loan_net_amnt_4 IN NUMBER,
2677 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
2678 x_nslds_loan_cur_st_date_4 IN DATE,
2679 x_nslds_loan_agg_pr_bal_4 IN NUMBER,
2680 x_nslds_loan_out_pr_bal_dt_4 IN DATE,
2681 x_nslds_loan_begin_dt_4 IN DATE,
2682 x_nslds_loan_end_dt_4 IN DATE,
2683 x_nslds_loan_ga_code_4 IN VARCHAR2,
2684 x_nslds_loan_cont_type_4 IN VARCHAR2,
2685 x_nslds_loan_schol_code_4 IN VARCHAR2,
2686 x_nslds_loan_cont_code_4 IN VARCHAR2,
2687 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
2688 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
2689 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
2690 x_nslds_loan_seq_num_5 IN NUMBER,
2691 x_nslds_loan_type_code_5 IN VARCHAR2,
2692 x_nslds_loan_chng_f_5 IN VARCHAR2,
2693 x_nslds_loan_prog_code_5 IN VARCHAR2,
2694 x_nslds_loan_net_amnt_5 IN NUMBER,
2695 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
2696 x_nslds_loan_cur_st_date_5 IN DATE,
2697 x_nslds_loan_agg_pr_bal_5 IN NUMBER,
2698 x_nslds_loan_out_pr_bal_dt_5 IN DATE,
2699 x_nslds_loan_begin_dt_5 IN DATE,
2700 x_nslds_loan_end_dt_5 IN DATE,
2701 x_nslds_loan_ga_code_5 IN VARCHAR2,
2702 x_nslds_loan_cont_type_5 IN VARCHAR2,
2703 x_nslds_loan_schol_code_5 IN VARCHAR2,
2704 x_nslds_loan_cont_code_5 IN VARCHAR2,
2705 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
2706 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
2707 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
2708 x_nslds_loan_seq_num_6 IN NUMBER,
2709 x_nslds_loan_type_code_6 IN VARCHAR2,
2710 x_nslds_loan_chng_f_6 IN VARCHAR2,
2711 x_nslds_loan_prog_code_6 IN VARCHAR2,
2712 x_nslds_loan_net_amnt_6 IN NUMBER,
2713 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
2714 x_nslds_loan_cur_st_date_6 IN DATE,
2715 x_nslds_loan_agg_pr_bal_6 IN NUMBER,
2716 x_nslds_loan_out_pr_bal_dt_6 IN DATE,
2717 x_nslds_loan_begin_dt_6 IN DATE,
2718 x_nslds_loan_end_dt_6 IN DATE,
2719 x_nslds_loan_ga_code_6 IN VARCHAR2,
2720 x_nslds_loan_cont_type_6 IN VARCHAR2,
2721 x_nslds_loan_schol_code_6 IN VARCHAR2,
2722 x_nslds_loan_cont_code_6 IN VARCHAR2,
2723 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
2724 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
2725 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
2726 x_nslds_loan_last_d_amt_1 IN NUMBER ,
2727 x_nslds_loan_last_d_date_1 IN DATE ,
2728 x_nslds_loan_last_d_amt_2 IN NUMBER ,
2729 x_nslds_loan_last_d_date_2 IN DATE ,
2730 x_nslds_loan_last_d_amt_3 IN NUMBER ,
2731 x_nslds_loan_last_d_date_3 IN DATE ,
2732 x_nslds_loan_last_d_amt_4 IN NUMBER ,
2733 x_nslds_loan_last_d_date_4 IN DATE ,
2734 x_nslds_loan_last_d_amt_5 IN NUMBER ,
2735 x_nslds_loan_last_d_date_5 IN DATE ,
2736 x_nslds_loan_last_d_amt_6 IN NUMBER ,
2737 x_nslds_loan_last_d_date_6 IN DATE ,
2738 x_dlp_master_prom_note_flag IN VARCHAR2,
2739 x_mode IN VARCHAR2,
2740 x_subsidized_loan_limit_type IN VARCHAR2,
2741 x_combined_loan_limit_type IN VARCHAR2,
2742 x_transaction_num_txt IN VARCHAR2
2743 ) AS
2744 /*
2745 || Created By : rasingh
2746 || Created On : 06-DEC-2000
2747 || Purpose : Handles the UPDATE DML logic for the table.
2748 || Known limitations, enhancements or remarks :
2749 || Change History :
2750 || Who When What
2751 || (reverse chronological order - newest change first)
2752 */
2753 x_last_update_date DATE ;
2754 x_last_updated_by NUMBER;
2755 x_last_update_login NUMBER;
2756 x_request_id NUMBER;
2757 x_program_id NUMBER;
2758 x_program_application_id NUMBER;
2759 x_program_update_date DATE;
2760
2761 BEGIN
2762
2763 x_last_update_date := SYSDATE;
2764 IF (X_MODE = 'I') THEN
2765 x_last_updated_by := 1;
2766 x_last_update_login := 0;
2767 ELSIF (x_mode = 'R') THEN
2768 x_last_updated_by := fnd_global.user_id;
2769 IF x_last_updated_by IS NULL THEN
2770 x_last_updated_by := -1;
2771 END IF;
2772 x_last_update_login := fnd_global.login_id;
2773 IF (x_last_update_login IS NULL) THEN
2774 x_last_update_login := -1;
2775 END IF;
2776 ELSE
2777 fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
2778 igs_ge_msg_stack.add;
2779 app_exception.raise_exception;
2780 END IF;
2781
2782 before_dml(
2783 p_action => 'UPDATE',
2784 x_rowid => x_rowid,
2785 x_nslds_id => x_nslds_id,
2786 x_isir_id => x_isir_id,
2787 x_base_id => x_base_id,
2788 x_nslds_transaction_num => x_nslds_transaction_num,
2789 x_nslds_database_results_f => x_nslds_database_results_f,
2790 x_nslds_f => x_nslds_f,
2791 x_nslds_pell_overpay_f => x_nslds_pell_overpay_f,
2792 x_nslds_pell_overpay_contact => x_nslds_pell_overpay_contact,
2793 x_nslds_seog_overpay_f => x_nslds_seog_overpay_f,
2794 x_nslds_seog_overpay_contact => x_nslds_seog_overpay_contact,
2795 x_nslds_perkins_overpay_f => x_nslds_perkins_overpay_f,
2796 x_nslds_perkins_overpay_cntct => x_nslds_perkins_overpay_cntct,
2797 x_nslds_defaulted_loan_f => x_nslds_defaulted_loan_f,
2798 x_nslds_dischged_loan_chng_f => x_nslds_dischged_loan_chng_f,
2799 x_nslds_satis_repay_f => x_nslds_satis_repay_f,
2800 x_nslds_act_bankruptcy_f => x_nslds_act_bankruptcy_f,
2801 x_nslds_agg_subsz_out_prin_bal => x_nslds_agg_subsz_out_prin_bal,
2802 x_nslds_agg_unsbz_out_prin_bal => x_nslds_agg_unsbz_out_prin_bal,
2803 x_nslds_agg_comb_out_prin_bal => x_nslds_agg_comb_out_prin_bal,
2804 x_nslds_agg_cons_out_prin_bal => x_nslds_agg_cons_out_prin_bal,
2805 x_nslds_agg_subsz_pend_dismt => x_nslds_agg_subsz_pend_dismt,
2806 x_nslds_agg_unsbz_pend_dismt => x_nslds_agg_unsbz_pend_dismt,
2807 x_nslds_agg_comb_pend_dismt => x_nslds_agg_comb_pend_dismt,
2808 x_nslds_agg_subsz_total => x_nslds_agg_subsz_total,
2809 x_nslds_agg_unsbz_total => x_nslds_agg_unsbz_total,
2810 x_nslds_agg_comb_total => x_nslds_agg_comb_total,
2811 x_nslds_agg_consd_total => x_nslds_agg_consd_total,
2812 x_nslds_perkins_out_bal => x_nslds_perkins_out_bal,
2813 x_nslds_perkins_cur_yr_dismnt => x_nslds_perkins_cur_yr_dismnt,
2814 x_nslds_default_loan_chng_f => x_nslds_default_loan_chng_f,
2815 x_nslds_discharged_loan_f => x_nslds_discharged_loan_f,
2816 x_nslds_satis_repay_chng_f => x_nslds_satis_repay_chng_f,
2817 x_nslds_act_bnkrupt_chng_f => x_nslds_act_bnkrupt_chng_f,
2818 x_nslds_overpay_chng_f => x_nslds_overpay_chng_f,
2819 x_nslds_agg_loan_chng_f => x_nslds_agg_loan_chng_f,
2820 x_nslds_perkins_loan_chng_f => x_nslds_perkins_loan_chng_f,
2821 x_nslds_pell_paymnt_chng_f => x_nslds_pell_paymnt_chng_f,
2822 x_nslds_addtnl_pell_f => x_nslds_addtnl_pell_f,
2823 x_nslds_addtnl_loan_f => x_nslds_addtnl_loan_f,
2824 x_direct_loan_mas_prom_nt_f => x_direct_loan_mas_prom_nt_f,
2825 x_nslds_pell_seq_num_1 => x_nslds_pell_seq_num_1,
2826 x_nslds_pell_verify_f_1 => x_nslds_pell_verify_f_1,
2827 x_nslds_pell_efc_1 => x_nslds_pell_efc_1,
2828 x_nslds_pell_school_code_1 => x_nslds_pell_school_code_1,
2829 x_nslds_pell_transcn_num_1 => x_nslds_pell_transcn_num_1,
2830 x_nslds_pell_last_updt_dt_1 => x_nslds_pell_last_updt_dt_1,
2831 x_nslds_pell_scheduled_amt_1 => x_nslds_pell_scheduled_amt_1,
2832 x_nslds_pell_amt_paid_todt_1 => x_nslds_pell_amt_paid_todt_1,
2833 x_nslds_pell_remng_amt_1 => x_nslds_pell_remng_amt_1,
2834 x_nslds_pell_pc_schd_awd_us_1 => x_nslds_pell_pc_schd_awd_us_1,
2835 x_nslds_pell_award_amt_1 => x_nslds_pell_award_amt_1,
2836 x_nslds_pell_seq_num_2 => x_nslds_pell_seq_num_2,
2837 x_nslds_pell_verify_f_2 => x_nslds_pell_verify_f_2,
2838 x_nslds_pell_efc_2 => x_nslds_pell_efc_2,
2839 x_nslds_pell_school_code_2 => x_nslds_pell_school_code_2,
2840 x_nslds_pell_transcn_num_2 => x_nslds_pell_transcn_num_2,
2841 x_nslds_pell_last_updt_dt_2 => x_nslds_pell_last_updt_dt_2,
2842 x_nslds_pell_scheduled_amt_2 => x_nslds_pell_scheduled_amt_2,
2843 x_nslds_pell_amt_paid_todt_2 => x_nslds_pell_amt_paid_todt_2,
2844 x_nslds_pell_remng_amt_2 => x_nslds_pell_remng_amt_2,
2845 x_nslds_pell_pc_schd_awd_us_2 => x_nslds_pell_pc_schd_awd_us_2,
2846 x_nslds_pell_award_amt_2 => x_nslds_pell_award_amt_2,
2847 x_nslds_pell_seq_num_3 => x_nslds_pell_seq_num_3,
2848 x_nslds_pell_verify_f_3 => x_nslds_pell_verify_f_3,
2849 x_nslds_pell_efc_3 => x_nslds_pell_efc_3,
2850 x_nslds_pell_school_code_3 => x_nslds_pell_school_code_3,
2851 x_nslds_pell_transcn_num_3 => x_nslds_pell_transcn_num_3,
2852 x_nslds_pell_last_updt_dt_3 => x_nslds_pell_last_updt_dt_3,
2853 x_nslds_pell_scheduled_amt_3 => x_nslds_pell_scheduled_amt_3,
2854 x_nslds_pell_amt_paid_todt_3 => x_nslds_pell_amt_paid_todt_3,
2855 x_nslds_pell_remng_amt_3 => x_nslds_pell_remng_amt_3,
2856 x_nslds_pell_pc_schd_awd_us_3 => x_nslds_pell_pc_schd_awd_us_3,
2857 x_nslds_pell_award_amt_3 => x_nslds_pell_award_amt_3,
2858 x_nslds_loan_seq_num_1 => x_nslds_loan_seq_num_1,
2859 x_nslds_loan_type_code_1 => x_nslds_loan_type_code_1,
2860 x_nslds_loan_chng_f_1 => x_nslds_loan_chng_f_1,
2861 x_nslds_loan_prog_code_1 => x_nslds_loan_prog_code_1,
2862 x_nslds_loan_net_amnt_1 => x_nslds_loan_net_amnt_1,
2863 x_nslds_loan_cur_st_code_1 => x_nslds_loan_cur_st_code_1,
2864 x_nslds_loan_cur_st_date_1 => x_nslds_loan_cur_st_date_1,
2865 x_nslds_loan_agg_pr_bal_1 => x_nslds_loan_agg_pr_bal_1,
2866 x_nslds_loan_out_pr_bal_dt_1 => x_nslds_loan_out_pr_bal_dt_1,
2867 x_nslds_loan_begin_dt_1 => x_nslds_loan_begin_dt_1,
2868 x_nslds_loan_end_dt_1 => x_nslds_loan_end_dt_1,
2869 x_nslds_loan_ga_code_1 => x_nslds_loan_ga_code_1,
2870 x_nslds_loan_cont_type_1 => x_nslds_loan_cont_type_1,
2871 x_nslds_loan_schol_code_1 => x_nslds_loan_schol_code_1,
2872 x_nslds_loan_cont_code_1 => x_nslds_loan_cont_code_1,
2873 x_nslds_loan_grade_lvl_1 => x_nslds_loan_grade_lvl_1,
2874 x_nslds_loan_xtr_unsbz_ln_f_1 => x_nslds_loan_xtr_unsbz_ln_f_1,
2875 x_nslds_loan_capital_int_f_1 => x_nslds_loan_capital_int_f_1,
2876 x_nslds_loan_seq_num_2 => x_nslds_loan_seq_num_2,
2877 x_nslds_loan_type_code_2 => x_nslds_loan_type_code_2,
2878 x_nslds_loan_chng_f_2 => x_nslds_loan_chng_f_2,
2879 x_nslds_loan_prog_code_2 => x_nslds_loan_prog_code_2,
2880 x_nslds_loan_net_amnt_2 => x_nslds_loan_net_amnt_2,
2881 x_nslds_loan_cur_st_code_2 => x_nslds_loan_cur_st_code_2,
2882 x_nslds_loan_cur_st_date_2 => x_nslds_loan_cur_st_date_2,
2883 x_nslds_loan_agg_pr_bal_2 => x_nslds_loan_agg_pr_bal_2,
2884 x_nslds_loan_out_pr_bal_dt_2 => x_nslds_loan_out_pr_bal_dt_2,
2885 x_nslds_loan_begin_dt_2 => x_nslds_loan_begin_dt_2,
2886 x_nslds_loan_end_dt_2 => x_nslds_loan_end_dt_2,
2887 x_nslds_loan_ga_code_2 => x_nslds_loan_ga_code_2,
2888 x_nslds_loan_cont_type_2 => x_nslds_loan_cont_type_2,
2889 x_nslds_loan_schol_code_2 => x_nslds_loan_schol_code_2,
2890 x_nslds_loan_cont_code_2 => x_nslds_loan_cont_code_2,
2891 x_nslds_loan_grade_lvl_2 => x_nslds_loan_grade_lvl_2,
2892 x_nslds_loan_xtr_unsbz_ln_f_2 => x_nslds_loan_xtr_unsbz_ln_f_2,
2893 x_nslds_loan_capital_int_f_2 => x_nslds_loan_capital_int_f_2,
2894 x_nslds_loan_seq_num_3 => x_nslds_loan_seq_num_3,
2895 x_nslds_loan_type_code_3 => x_nslds_loan_type_code_3,
2896 x_nslds_loan_chng_f_3 => x_nslds_loan_chng_f_3,
2897 x_nslds_loan_prog_code_3 => x_nslds_loan_prog_code_3,
2898 x_nslds_loan_net_amnt_3 => x_nslds_loan_net_amnt_3,
2899 x_nslds_loan_cur_st_code_3 => x_nslds_loan_cur_st_code_3,
2900 x_nslds_loan_cur_st_date_3 => x_nslds_loan_cur_st_date_3,
2901 x_nslds_loan_agg_pr_bal_3 => x_nslds_loan_agg_pr_bal_3,
2902 x_nslds_loan_out_pr_bal_dt_3 => x_nslds_loan_out_pr_bal_dt_3,
2903 x_nslds_loan_begin_dt_3 => x_nslds_loan_begin_dt_3,
2904 x_nslds_loan_end_dt_3 => x_nslds_loan_end_dt_3,
2905 x_nslds_loan_ga_code_3 => x_nslds_loan_ga_code_3,
2906 x_nslds_loan_cont_type_3 => x_nslds_loan_cont_type_3,
2907 x_nslds_loan_schol_code_3 => x_nslds_loan_schol_code_3,
2908 x_nslds_loan_cont_code_3 => x_nslds_loan_cont_code_3,
2909 x_nslds_loan_grade_lvl_3 => x_nslds_loan_grade_lvl_3,
2910 x_nslds_loan_xtr_unsbz_ln_f_3 => x_nslds_loan_xtr_unsbz_ln_f_3,
2911 x_nslds_loan_capital_int_f_3 => x_nslds_loan_capital_int_f_3,
2912 x_nslds_loan_seq_num_4 => x_nslds_loan_seq_num_4,
2913 x_nslds_loan_type_code_4 => x_nslds_loan_type_code_4,
2914 x_nslds_loan_chng_f_4 => x_nslds_loan_chng_f_4,
2915 x_nslds_loan_prog_code_4 => x_nslds_loan_prog_code_4,
2916 x_nslds_loan_net_amnt_4 => x_nslds_loan_net_amnt_4,
2917 x_nslds_loan_cur_st_code_4 => x_nslds_loan_cur_st_code_4,
2918 x_nslds_loan_cur_st_date_4 => x_nslds_loan_cur_st_date_4,
2919 x_nslds_loan_agg_pr_bal_4 => x_nslds_loan_agg_pr_bal_4,
2920 x_nslds_loan_out_pr_bal_dt_4 => x_nslds_loan_out_pr_bal_dt_4,
2921 x_nslds_loan_begin_dt_4 => x_nslds_loan_begin_dt_4,
2922 x_nslds_loan_end_dt_4 => x_nslds_loan_end_dt_4,
2923 x_nslds_loan_ga_code_4 => x_nslds_loan_ga_code_4,
2924 x_nslds_loan_cont_type_4 => x_nslds_loan_cont_type_4,
2925 x_nslds_loan_schol_code_4 => x_nslds_loan_schol_code_4,
2926 x_nslds_loan_cont_code_4 => x_nslds_loan_cont_code_4,
2927 x_nslds_loan_grade_lvl_4 => x_nslds_loan_grade_lvl_4,
2928 x_nslds_loan_xtr_unsbz_ln_f_4 => x_nslds_loan_xtr_unsbz_ln_f_4,
2929 x_nslds_loan_capital_int_f_4 => x_nslds_loan_capital_int_f_4,
2930 x_nslds_loan_seq_num_5 => x_nslds_loan_seq_num_5,
2931 x_nslds_loan_type_code_5 => x_nslds_loan_type_code_5,
2932 x_nslds_loan_chng_f_5 => x_nslds_loan_chng_f_5,
2933 x_nslds_loan_prog_code_5 => x_nslds_loan_prog_code_5,
2934 x_nslds_loan_net_amnt_5 => x_nslds_loan_net_amnt_5,
2935 x_nslds_loan_cur_st_code_5 => x_nslds_loan_cur_st_code_5,
2936 x_nslds_loan_cur_st_date_5 => x_nslds_loan_cur_st_date_5,
2937 x_nslds_loan_agg_pr_bal_5 => x_nslds_loan_agg_pr_bal_5,
2938 x_nslds_loan_out_pr_bal_dt_5 => x_nslds_loan_out_pr_bal_dt_5,
2939 x_nslds_loan_begin_dt_5 => x_nslds_loan_begin_dt_5,
2940 x_nslds_loan_end_dt_5 => x_nslds_loan_end_dt_5,
2941 x_nslds_loan_ga_code_5 => x_nslds_loan_ga_code_5,
2942 x_nslds_loan_cont_type_5 => x_nslds_loan_cont_type_5,
2943 x_nslds_loan_schol_code_5 => x_nslds_loan_schol_code_5,
2944 x_nslds_loan_cont_code_5 => x_nslds_loan_cont_code_5,
2945 x_nslds_loan_grade_lvl_5 => x_nslds_loan_grade_lvl_5,
2946 x_nslds_loan_xtr_unsbz_ln_f_5 => x_nslds_loan_xtr_unsbz_ln_f_5,
2947 x_nslds_loan_capital_int_f_5 => x_nslds_loan_capital_int_f_5,
2948 x_nslds_loan_seq_num_6 => x_nslds_loan_seq_num_6,
2949 x_nslds_loan_type_code_6 => x_nslds_loan_type_code_6,
2950 x_nslds_loan_chng_f_6 => x_nslds_loan_chng_f_6,
2951 x_nslds_loan_prog_code_6 => x_nslds_loan_prog_code_6,
2952 x_nslds_loan_net_amnt_6 => x_nslds_loan_net_amnt_6,
2953 x_nslds_loan_cur_st_code_6 => x_nslds_loan_cur_st_code_6,
2954 x_nslds_loan_cur_st_date_6 => x_nslds_loan_cur_st_date_6,
2955 x_nslds_loan_agg_pr_bal_6 => x_nslds_loan_agg_pr_bal_6,
2956 x_nslds_loan_out_pr_bal_dt_6 => x_nslds_loan_out_pr_bal_dt_6,
2957 x_nslds_loan_begin_dt_6 => x_nslds_loan_begin_dt_6,
2958 x_nslds_loan_end_dt_6 => x_nslds_loan_end_dt_6,
2959 x_nslds_loan_ga_code_6 => x_nslds_loan_ga_code_6,
2960 x_nslds_loan_cont_type_6 => x_nslds_loan_cont_type_6,
2961 x_nslds_loan_schol_code_6 => x_nslds_loan_schol_code_6,
2962 x_nslds_loan_cont_code_6 => x_nslds_loan_cont_code_6,
2963 x_nslds_loan_grade_lvl_6 => x_nslds_loan_grade_lvl_6,
2964 x_nslds_loan_xtr_unsbz_ln_f_6 => x_nslds_loan_xtr_unsbz_ln_f_6,
2965 x_nslds_loan_capital_int_f_6 => x_nslds_loan_capital_int_f_6,
2966 x_nslds_loan_last_d_amt_1 => x_nslds_loan_last_d_amt_1,
2967 x_nslds_loan_last_d_date_1 => x_nslds_loan_last_d_date_1,
2968 x_nslds_loan_last_d_amt_2 => x_nslds_loan_last_d_amt_2,
2969 x_nslds_loan_last_d_date_2 => x_nslds_loan_last_d_date_2,
2970 x_nslds_loan_last_d_amt_3 => x_nslds_loan_last_d_amt_3,
2971 x_nslds_loan_last_d_date_3 => x_nslds_loan_last_d_date_3,
2972 x_nslds_loan_last_d_amt_4 => x_nslds_loan_last_d_amt_4,
2973 x_nslds_loan_last_d_date_4 => x_nslds_loan_last_d_date_4,
2974 x_nslds_loan_last_d_amt_5 => x_nslds_loan_last_d_amt_5,
2975 x_nslds_loan_last_d_date_5 => x_nslds_loan_last_d_date_5,
2976 x_nslds_loan_last_d_amt_6 => x_nslds_loan_last_d_amt_6,
2977 x_nslds_loan_last_d_date_6 => x_nslds_loan_last_d_date_6,
2978 x_creation_date => x_last_update_date,
2979 x_created_by => x_last_updated_by,
2980 x_last_update_date => x_last_update_date,
2981 x_last_updated_by => x_last_updated_by,
2982 x_last_update_login => x_last_update_login,
2983 x_dlp_master_prom_note_flag => x_dlp_master_prom_note_flag,
2984 x_subsidized_loan_limit_type => x_subsidized_loan_limit_type,
2985 x_combined_loan_limit_type => x_combined_loan_limit_type,
2986 x_transaction_num_txt => x_transaction_num_txt
2987 );
2988
2989 IF (x_mode = 'R') THEN
2990 x_request_id := fnd_global.conc_request_id;
2991 x_program_id := fnd_global.conc_program_id;
2992 x_program_application_id := fnd_global.prog_appl_id;
2993 IF (x_request_id = -1) THEN
2994 x_request_id := old_references.request_id;
2995 x_program_id := old_references.program_id;
2996 x_program_application_id := old_references.program_application_id;
2997 x_program_update_date := old_references.program_update_date;
2998 ELSE
2999 x_program_update_date := SYSDATE;
3000 END IF;
3001 END IF;
3002
3003 UPDATE igf_ap_nslds_data_all
3004 SET
3005 isir_id = new_references.isir_id,
3006 base_id = new_references.base_id,
3007 nslds_transaction_num = new_references.nslds_transaction_num,
3008 nslds_database_results_f = new_references.nslds_database_results_f,
3009 nslds_f = new_references.nslds_f,
3010 nslds_pell_overpay_f = new_references.nslds_pell_overpay_f,
3011 nslds_pell_overpay_contact = new_references.nslds_pell_overpay_contact,
3012 nslds_seog_overpay_f = new_references.nslds_seog_overpay_f,
3013 nslds_seog_overpay_contact = new_references.nslds_seog_overpay_contact,
3014 nslds_perkins_overpay_f = new_references.nslds_perkins_overpay_f,
3015 nslds_perkins_overpay_cntct = new_references.nslds_perkins_overpay_cntct,
3016 nslds_defaulted_loan_f = new_references.nslds_defaulted_loan_f,
3017 nslds_dischged_loan_chng_f = new_references.nslds_dischged_loan_chng_f,
3018 nslds_satis_repay_f = new_references.nslds_satis_repay_f,
3019 nslds_act_bankruptcy_f = new_references.nslds_act_bankruptcy_f,
3020 nslds_agg_subsz_out_prin_bal = new_references.nslds_agg_subsz_out_prin_bal,
3021 nslds_agg_unsbz_out_prin_bal = new_references.nslds_agg_unsbz_out_prin_bal,
3022 nslds_agg_comb_out_prin_bal = new_references.nslds_agg_comb_out_prin_bal,
3023 nslds_agg_cons_out_prin_bal = new_references.nslds_agg_cons_out_prin_bal,
3024 nslds_agg_subsz_pend_dismt = new_references.nslds_agg_subsz_pend_dismt,
3025 nslds_agg_unsbz_pend_dismt = new_references.nslds_agg_unsbz_pend_dismt,
3026 nslds_agg_comb_pend_dismt = new_references.nslds_agg_comb_pend_dismt,
3027 nslds_agg_subsz_total = new_references.nslds_agg_subsz_total,
3028 nslds_agg_unsbz_total = new_references.nslds_agg_unsbz_total,
3029 nslds_agg_comb_total = new_references.nslds_agg_comb_total,
3030 nslds_agg_consd_total = new_references.nslds_agg_consd_total,
3031 nslds_perkins_out_bal = new_references.nslds_perkins_out_bal,
3032 nslds_perkins_cur_yr_dismnt = new_references.nslds_perkins_cur_yr_dismnt,
3033 nslds_default_loan_chng_f = new_references.nslds_default_loan_chng_f,
3034 nslds_discharged_loan_f = new_references.nslds_discharged_loan_f,
3035 nslds_satis_repay_chng_f = new_references.nslds_satis_repay_chng_f,
3036 nslds_act_bnkrupt_chng_f = new_references.nslds_act_bnkrupt_chng_f,
3037 nslds_overpay_chng_f = new_references.nslds_overpay_chng_f,
3038 nslds_agg_loan_chng_f = new_references.nslds_agg_loan_chng_f,
3039 nslds_perkins_loan_chng_f = new_references.nslds_perkins_loan_chng_f,
3040 nslds_pell_paymnt_chng_f = new_references.nslds_pell_paymnt_chng_f,
3041 nslds_addtnl_pell_f = new_references.nslds_addtnl_pell_f,
3042 nslds_addtnl_loan_f = new_references.nslds_addtnl_loan_f,
3043 direct_loan_mas_prom_nt_f = new_references.direct_loan_mas_prom_nt_f,
3044 nslds_pell_seq_num_1 = new_references.nslds_pell_seq_num_1,
3045 nslds_pell_verify_f_1 = new_references.nslds_pell_verify_f_1,
3046 nslds_pell_efc_1 = new_references.nslds_pell_efc_1,
3047 nslds_pell_school_code_1 = new_references.nslds_pell_school_code_1,
3048 nslds_pell_transcn_num_1 = new_references.nslds_pell_transcn_num_1,
3049 nslds_pell_last_updt_dt_1 = new_references.nslds_pell_last_updt_dt_1,
3050 nslds_pell_scheduled_amt_1 = new_references.nslds_pell_scheduled_amt_1,
3051 nslds_pell_amt_paid_todt_1 = new_references.nslds_pell_amt_paid_todt_1,
3052 nslds_pell_remng_amt_1 = new_references.nslds_pell_remng_amt_1,
3053 nslds_pell_pc_schd_awd_us_1 = new_references.nslds_pell_pc_schd_awd_us_1,
3054 nslds_pell_award_amt_1 = new_references.nslds_pell_award_amt_1,
3055 nslds_pell_seq_num_2 = new_references.nslds_pell_seq_num_2,
3056 nslds_pell_verify_f_2 = new_references.nslds_pell_verify_f_2,
3057 nslds_pell_efc_2 = new_references.nslds_pell_efc_2,
3058 nslds_pell_school_code_2 = new_references.nslds_pell_school_code_2,
3059 nslds_pell_transcn_num_2 = new_references.nslds_pell_transcn_num_2,
3060 nslds_pell_last_updt_dt_2 = new_references.nslds_pell_last_updt_dt_2,
3061 nslds_pell_scheduled_amt_2 = new_references.nslds_pell_scheduled_amt_2,
3062 nslds_pell_amt_paid_todt_2 = new_references.nslds_pell_amt_paid_todt_2,
3063 nslds_pell_remng_amt_2 = new_references.nslds_pell_remng_amt_2,
3064 nslds_pell_pc_schd_awd_us_2 = new_references.nslds_pell_pc_schd_awd_us_2,
3065 nslds_pell_award_amt_2 = new_references.nslds_pell_award_amt_2,
3066 nslds_pell_seq_num_3 = new_references.nslds_pell_seq_num_3,
3067 nslds_pell_verify_f_3 = new_references.nslds_pell_verify_f_3,
3068 nslds_pell_efc_3 = new_references.nslds_pell_efc_3,
3069 nslds_pell_school_code_3 = new_references.nslds_pell_school_code_3,
3070 nslds_pell_transcn_num_3 = new_references.nslds_pell_transcn_num_3,
3071 nslds_pell_last_updt_dt_3 = new_references.nslds_pell_last_updt_dt_3,
3072 nslds_pell_scheduled_amt_3 = new_references.nslds_pell_scheduled_amt_3,
3073 nslds_pell_amt_paid_todt_3 = new_references.nslds_pell_amt_paid_todt_3,
3074 nslds_pell_remng_amt_3 = new_references.nslds_pell_remng_amt_3,
3075 nslds_pell_pc_schd_awd_us_3 = new_references.nslds_pell_pc_schd_awd_us_3,
3076 nslds_pell_award_amt_3 = new_references.nslds_pell_award_amt_3,
3077 nslds_loan_seq_num_1 = new_references.nslds_loan_seq_num_1,
3078 nslds_loan_type_code_1 = new_references.nslds_loan_type_code_1,
3079 nslds_loan_chng_f_1 = new_references.nslds_loan_chng_f_1,
3080 nslds_loan_prog_code_1 = new_references.nslds_loan_prog_code_1,
3081 nslds_loan_net_amnt_1 = new_references.nslds_loan_net_amnt_1,
3082 nslds_loan_cur_st_code_1 = new_references.nslds_loan_cur_st_code_1,
3083 nslds_loan_cur_st_date_1 = new_references.nslds_loan_cur_st_date_1,
3084 nslds_loan_agg_pr_bal_1 = new_references.nslds_loan_agg_pr_bal_1,
3085 nslds_loan_out_pr_bal_dt_1 = new_references.nslds_loan_out_pr_bal_dt_1,
3086 nslds_loan_begin_dt_1 = new_references.nslds_loan_begin_dt_1,
3087 nslds_loan_end_dt_1 = new_references.nslds_loan_end_dt_1,
3088 nslds_loan_ga_code_1 = new_references.nslds_loan_ga_code_1,
3089 nslds_loan_cont_type_1 = new_references.nslds_loan_cont_type_1,
3090 nslds_loan_schol_code_1 = new_references.nslds_loan_schol_code_1,
3091 nslds_loan_cont_code_1 = new_references.nslds_loan_cont_code_1,
3092 nslds_loan_grade_lvl_1 = new_references.nslds_loan_grade_lvl_1,
3093 nslds_loan_xtr_unsbz_ln_f_1 = new_references.nslds_loan_xtr_unsbz_ln_f_1,
3094 nslds_loan_capital_int_f_1 = new_references.nslds_loan_capital_int_f_1,
3095 nslds_loan_seq_num_2 = new_references.nslds_loan_seq_num_2,
3096 nslds_loan_type_code_2 = new_references.nslds_loan_type_code_2,
3097 nslds_loan_chng_f_2 = new_references.nslds_loan_chng_f_2,
3098 nslds_loan_prog_code_2 = new_references.nslds_loan_prog_code_2,
3099 nslds_loan_net_amnt_2 = new_references.nslds_loan_net_amnt_2,
3100 nslds_loan_cur_st_code_2 = new_references.nslds_loan_cur_st_code_2,
3101 nslds_loan_cur_st_date_2 = new_references.nslds_loan_cur_st_date_2,
3102 nslds_loan_agg_pr_bal_2 = new_references.nslds_loan_agg_pr_bal_2,
3103 nslds_loan_out_pr_bal_dt_2 = new_references.nslds_loan_out_pr_bal_dt_2,
3104 nslds_loan_begin_dt_2 = new_references.nslds_loan_begin_dt_2,
3105 nslds_loan_end_dt_2 = new_references.nslds_loan_end_dt_2,
3106 nslds_loan_ga_code_2 = new_references.nslds_loan_ga_code_2,
3107 nslds_loan_cont_type_2 = new_references.nslds_loan_cont_type_2,
3108 nslds_loan_schol_code_2 = new_references.nslds_loan_schol_code_2,
3109 nslds_loan_cont_code_2 = new_references.nslds_loan_cont_code_2,
3110 nslds_loan_grade_lvl_2 = new_references.nslds_loan_grade_lvl_2,
3111 nslds_loan_xtr_unsbz_ln_f_2 = new_references.nslds_loan_xtr_unsbz_ln_f_2,
3112 nslds_loan_capital_int_f_2 = new_references.nslds_loan_capital_int_f_2,
3113 nslds_loan_seq_num_3 = new_references.nslds_loan_seq_num_3,
3114 nslds_loan_type_code_3 = new_references.nslds_loan_type_code_3,
3115 nslds_loan_chng_f_3 = new_references.nslds_loan_chng_f_3,
3116 nslds_loan_prog_code_3 = new_references.nslds_loan_prog_code_3,
3117 nslds_loan_net_amnt_3 = new_references.nslds_loan_net_amnt_3,
3118 nslds_loan_cur_st_code_3 = new_references.nslds_loan_cur_st_code_3,
3119 nslds_loan_cur_st_date_3 = new_references.nslds_loan_cur_st_date_3,
3120 nslds_loan_agg_pr_bal_3 = new_references.nslds_loan_agg_pr_bal_3,
3121 nslds_loan_out_pr_bal_dt_3 = new_references.nslds_loan_out_pr_bal_dt_3,
3122 nslds_loan_begin_dt_3 = new_references.nslds_loan_begin_dt_3,
3123 nslds_loan_end_dt_3 = new_references.nslds_loan_end_dt_3,
3124 nslds_loan_ga_code_3 = new_references.nslds_loan_ga_code_3,
3125 nslds_loan_cont_type_3 = new_references.nslds_loan_cont_type_3,
3126 nslds_loan_schol_code_3 = new_references.nslds_loan_schol_code_3,
3127 nslds_loan_cont_code_3 = new_references.nslds_loan_cont_code_3,
3128 nslds_loan_grade_lvl_3 = new_references.nslds_loan_grade_lvl_3,
3129 nslds_loan_xtr_unsbz_ln_f_3 = new_references.nslds_loan_xtr_unsbz_ln_f_3,
3130 nslds_loan_capital_int_f_3 = new_references.nslds_loan_capital_int_f_3,
3131 nslds_loan_seq_num_4 = new_references.nslds_loan_seq_num_4,
3132 nslds_loan_type_code_4 = new_references.nslds_loan_type_code_4,
3133 nslds_loan_chng_f_4 = new_references.nslds_loan_chng_f_4,
3134 nslds_loan_prog_code_4 = new_references.nslds_loan_prog_code_4,
3135 nslds_loan_net_amnt_4 = new_references.nslds_loan_net_amnt_4,
3136 nslds_loan_cur_st_code_4 = new_references.nslds_loan_cur_st_code_4,
3137 nslds_loan_cur_st_date_4 = new_references.nslds_loan_cur_st_date_4,
3138 nslds_loan_agg_pr_bal_4 = new_references.nslds_loan_agg_pr_bal_4,
3139 nslds_loan_out_pr_bal_dt_4 = new_references.nslds_loan_out_pr_bal_dt_4,
3140 nslds_loan_begin_dt_4 = new_references.nslds_loan_begin_dt_4,
3141 nslds_loan_end_dt_4 = new_references.nslds_loan_end_dt_4,
3142 nslds_loan_ga_code_4 = new_references.nslds_loan_ga_code_4,
3143 nslds_loan_cont_type_4 = new_references.nslds_loan_cont_type_4,
3144 nslds_loan_schol_code_4 = new_references.nslds_loan_schol_code_4,
3145 nslds_loan_cont_code_4 = new_references.nslds_loan_cont_code_4,
3146 nslds_loan_grade_lvl_4 = new_references.nslds_loan_grade_lvl_4,
3147 nslds_loan_xtr_unsbz_ln_f_4 = new_references.nslds_loan_xtr_unsbz_ln_f_4,
3148 nslds_loan_capital_int_f_4 = new_references.nslds_loan_capital_int_f_4,
3149 nslds_loan_seq_num_5 = new_references.nslds_loan_seq_num_5,
3150 nslds_loan_type_code_5 = new_references.nslds_loan_type_code_5,
3151 nslds_loan_chng_f_5 = new_references.nslds_loan_chng_f_5,
3152 nslds_loan_prog_code_5 = new_references.nslds_loan_prog_code_5,
3153 nslds_loan_net_amnt_5 = new_references.nslds_loan_net_amnt_5,
3154 nslds_loan_cur_st_code_5 = new_references.nslds_loan_cur_st_code_5,
3155 nslds_loan_cur_st_date_5 = new_references.nslds_loan_cur_st_date_5,
3156 nslds_loan_agg_pr_bal_5 = new_references.nslds_loan_agg_pr_bal_5,
3157 nslds_loan_out_pr_bal_dt_5 = new_references.nslds_loan_out_pr_bal_dt_5,
3158 nslds_loan_begin_dt_5 = new_references.nslds_loan_begin_dt_5,
3159 nslds_loan_end_dt_5 = new_references.nslds_loan_end_dt_5,
3160 nslds_loan_ga_code_5 = new_references.nslds_loan_ga_code_5,
3161 nslds_loan_cont_type_5 = new_references.nslds_loan_cont_type_5,
3162 nslds_loan_schol_code_5 = new_references.nslds_loan_schol_code_5,
3163 nslds_loan_cont_code_5 = new_references.nslds_loan_cont_code_5,
3164 nslds_loan_grade_lvl_5 = new_references.nslds_loan_grade_lvl_5,
3165 nslds_loan_xtr_unsbz_ln_f_5 = new_references.nslds_loan_xtr_unsbz_ln_f_5,
3166 nslds_loan_capital_int_f_5 = new_references.nslds_loan_capital_int_f_5,
3167 nslds_loan_seq_num_6 = new_references.nslds_loan_seq_num_6,
3168 nslds_loan_type_code_6 = new_references.nslds_loan_type_code_6,
3169 nslds_loan_chng_f_6 = new_references.nslds_loan_chng_f_6,
3170 nslds_loan_prog_code_6 = new_references.nslds_loan_prog_code_6,
3171 nslds_loan_net_amnt_6 = new_references.nslds_loan_net_amnt_6,
3172 nslds_loan_cur_st_code_6 = new_references.nslds_loan_cur_st_code_6,
3173 nslds_loan_cur_st_date_6 = new_references.nslds_loan_cur_st_date_6,
3174 nslds_loan_agg_pr_bal_6 = new_references.nslds_loan_agg_pr_bal_6,
3175 nslds_loan_out_pr_bal_dt_6 = new_references.nslds_loan_out_pr_bal_dt_6,
3176 nslds_loan_begin_dt_6 = new_references.nslds_loan_begin_dt_6,
3177 nslds_loan_end_dt_6 = new_references.nslds_loan_end_dt_6,
3178 nslds_loan_ga_code_6 = new_references.nslds_loan_ga_code_6,
3179 nslds_loan_cont_type_6 = new_references.nslds_loan_cont_type_6,
3180 nslds_loan_schol_code_6 = new_references.nslds_loan_schol_code_6,
3181 nslds_loan_cont_code_6 = new_references.nslds_loan_cont_code_6,
3182 nslds_loan_grade_lvl_6 = new_references.nslds_loan_grade_lvl_6,
3183 nslds_loan_xtr_unsbz_ln_f_6 = new_references.nslds_loan_xtr_unsbz_ln_f_6,
3184 nslds_loan_capital_int_f_6 = new_references.nslds_loan_capital_int_f_6,
3185 nslds_loan_last_d_amt_1 = new_references.nslds_loan_last_d_amt_1,
3186 nslds_loan_last_d_date_1 = new_references.nslds_loan_last_d_date_1,
3187 nslds_loan_last_d_amt_2 = new_references.nslds_loan_last_d_amt_2,
3188 nslds_loan_last_d_date_2 = new_references.nslds_loan_last_d_date_2,
3189 nslds_loan_last_d_amt_3 = new_references.nslds_loan_last_d_amt_3,
3190 nslds_loan_last_d_date_3 = new_references.nslds_loan_last_d_date_3,
3191 nslds_loan_last_d_amt_4 = new_references.nslds_loan_last_d_amt_4,
3192 nslds_loan_last_d_date_4 = new_references.nslds_loan_last_d_date_4,
3193 nslds_loan_last_d_amt_5 = new_references.nslds_loan_last_d_amt_5,
3194 nslds_loan_last_d_date_5 = new_references.nslds_loan_last_d_date_5,
3195 nslds_loan_last_d_amt_6 = new_references.nslds_loan_last_d_amt_6,
3196 nslds_loan_last_d_date_6 = new_references.nslds_loan_last_d_date_6,
3197 dlp_master_prom_note_flag = new_references.dlp_master_prom_note_flag,
3198 last_update_date = x_last_update_date,
3199 last_updated_by = x_last_updated_by,
3200 last_update_login = x_last_update_login ,
3201 request_id = x_request_id,
3202 program_id = x_program_id,
3203 program_application_id = x_program_application_id,
3204 program_update_date = x_program_update_date,
3205 subsidized_loan_limit_type = x_subsidized_loan_limit_type,
3206 combined_loan_limit_type = x_combined_loan_limit_type,
3207 transaction_num_txt = x_transaction_num_txt
3208 WHERE rowid = x_rowid;
3209
3210 IF (SQL%NOTFOUND) THEN
3211 RAISE NO_DATA_FOUND;
3212 END IF;
3213
3214 END update_row;
3215
3216
3217 PROCEDURE add_row (
3218 x_rowid IN OUT NOCOPY VARCHAR2,
3219 x_nslds_id IN OUT NOCOPY NUMBER,
3220 x_isir_id IN NUMBER,
3221 x_base_id IN NUMBER,
3222 x_nslds_transaction_num IN NUMBER,
3223 x_nslds_database_results_f IN VARCHAR2,
3224 x_nslds_f IN VARCHAR2,
3225 x_nslds_pell_overpay_f IN VARCHAR2,
3226 x_nslds_pell_overpay_contact IN VARCHAR2,
3227 x_nslds_seog_overpay_f IN VARCHAR2,
3228 x_nslds_seog_overpay_contact IN VARCHAR2,
3229 x_nslds_perkins_overpay_f IN VARCHAR2,
3230 x_nslds_perkins_overpay_cntct IN VARCHAR2,
3231 x_nslds_defaulted_loan_f IN VARCHAR2,
3232 x_nslds_dischged_loan_chng_f IN VARCHAR2,
3233 x_nslds_satis_repay_f IN VARCHAR2,
3234 x_nslds_act_bankruptcy_f IN VARCHAR2,
3235 x_nslds_agg_subsz_out_prin_bal IN NUMBER,
3236 x_nslds_agg_unsbz_out_prin_bal IN NUMBER,
3237 x_nslds_agg_comb_out_prin_bal IN NUMBER,
3238 x_nslds_agg_cons_out_prin_bal IN NUMBER,
3239 x_nslds_agg_subsz_pend_dismt IN NUMBER,
3240 x_nslds_agg_unsbz_pend_dismt IN NUMBER,
3241 x_nslds_agg_comb_pend_dismt IN NUMBER,
3242 x_nslds_agg_subsz_total IN NUMBER,
3243 x_nslds_agg_unsbz_total IN NUMBER,
3244 x_nslds_agg_comb_total IN NUMBER,
3245 x_nslds_agg_consd_total IN NUMBER,
3246 x_nslds_perkins_out_bal IN NUMBER,
3247 x_nslds_perkins_cur_yr_dismnt IN NUMBER,
3248 x_nslds_default_loan_chng_f IN VARCHAR2,
3249 x_nslds_discharged_loan_f IN VARCHAR2,
3250 x_nslds_satis_repay_chng_f IN VARCHAR2,
3251 x_nslds_act_bnkrupt_chng_f IN VARCHAR2,
3252 x_nslds_overpay_chng_f IN VARCHAR2,
3253 x_nslds_agg_loan_chng_f IN VARCHAR2,
3254 x_nslds_perkins_loan_chng_f IN VARCHAR2,
3255 x_nslds_pell_paymnt_chng_f IN VARCHAR2,
3256 x_nslds_addtnl_pell_f IN VARCHAR2,
3257 x_nslds_addtnl_loan_f IN VARCHAR2,
3258 x_direct_loan_mas_prom_nt_f IN VARCHAR2,
3259 x_nslds_pell_seq_num_1 IN NUMBER,
3260 x_nslds_pell_verify_f_1 IN VARCHAR2,
3261 x_nslds_pell_efc_1 IN NUMBER,
3262 x_nslds_pell_school_code_1 IN NUMBER,
3263 x_nslds_pell_transcn_num_1 IN NUMBER,
3264 x_nslds_pell_last_updt_dt_1 IN DATE,
3265 x_nslds_pell_scheduled_amt_1 IN NUMBER,
3266 x_nslds_pell_amt_paid_todt_1 IN NUMBER,
3267 x_nslds_pell_remng_amt_1 IN NUMBER,
3268 x_nslds_pell_pc_schd_awd_us_1 IN NUMBER,
3269 x_nslds_pell_award_amt_1 IN NUMBER,
3270 x_nslds_pell_seq_num_2 IN NUMBER,
3271 x_nslds_pell_verify_f_2 IN VARCHAR2,
3272 x_nslds_pell_efc_2 IN NUMBER,
3273 x_nslds_pell_school_code_2 IN NUMBER,
3274 x_nslds_pell_transcn_num_2 IN NUMBER,
3275 x_nslds_pell_last_updt_dt_2 IN DATE,
3276 x_nslds_pell_scheduled_amt_2 IN NUMBER,
3277 x_nslds_pell_amt_paid_todt_2 IN NUMBER,
3278 x_nslds_pell_remng_amt_2 IN NUMBER,
3279 x_nslds_pell_pc_schd_awd_us_2 IN NUMBER,
3280 x_nslds_pell_award_amt_2 IN NUMBER,
3281 x_nslds_pell_seq_num_3 IN NUMBER,
3282 x_nslds_pell_verify_f_3 IN VARCHAR2,
3283 x_nslds_pell_efc_3 IN NUMBER,
3284 x_nslds_pell_school_code_3 IN NUMBER,
3285 x_nslds_pell_transcn_num_3 IN NUMBER,
3286 x_nslds_pell_last_updt_dt_3 IN DATE,
3287 x_nslds_pell_scheduled_amt_3 IN NUMBER,
3288 x_nslds_pell_amt_paid_todt_3 IN NUMBER,
3289 x_nslds_pell_remng_amt_3 IN NUMBER,
3290 x_nslds_pell_pc_schd_awd_us_3 IN NUMBER,
3291 x_nslds_pell_award_amt_3 IN NUMBER,
3292 x_nslds_loan_seq_num_1 IN NUMBER,
3293 x_nslds_loan_type_code_1 IN VARCHAR2,
3294 x_nslds_loan_chng_f_1 IN VARCHAR2,
3295 x_nslds_loan_prog_code_1 IN VARCHAR2,
3296 x_nslds_loan_net_amnt_1 IN NUMBER,
3297 x_nslds_loan_cur_st_code_1 IN VARCHAR2,
3298 x_nslds_loan_cur_st_date_1 IN DATE,
3299 x_nslds_loan_agg_pr_bal_1 IN NUMBER,
3300 x_nslds_loan_out_pr_bal_dt_1 IN DATE,
3301 x_nslds_loan_begin_dt_1 IN DATE,
3302 x_nslds_loan_end_dt_1 IN DATE,
3303 x_nslds_loan_ga_code_1 IN VARCHAR2,
3304 x_nslds_loan_cont_type_1 IN VARCHAR2,
3305 x_nslds_loan_schol_code_1 IN VARCHAR2,
3306 x_nslds_loan_cont_code_1 IN VARCHAR2,
3307 x_nslds_loan_grade_lvl_1 IN VARCHAR2,
3308 x_nslds_loan_xtr_unsbz_ln_f_1 IN VARCHAR2,
3309 x_nslds_loan_capital_int_f_1 IN VARCHAR2,
3310 x_nslds_loan_seq_num_2 IN NUMBER,
3311 x_nslds_loan_type_code_2 IN VARCHAR2,
3312 x_nslds_loan_chng_f_2 IN VARCHAR2,
3313 x_nslds_loan_prog_code_2 IN VARCHAR2,
3314 x_nslds_loan_net_amnt_2 IN NUMBER,
3315 x_nslds_loan_cur_st_code_2 IN VARCHAR2,
3316 x_nslds_loan_cur_st_date_2 IN DATE,
3317 x_nslds_loan_agg_pr_bal_2 IN NUMBER,
3318 x_nslds_loan_out_pr_bal_dt_2 IN DATE,
3319 x_nslds_loan_begin_dt_2 IN DATE,
3320 x_nslds_loan_end_dt_2 IN DATE,
3321 x_nslds_loan_ga_code_2 IN VARCHAR2,
3322 x_nslds_loan_cont_type_2 IN VARCHAR2,
3323 x_nslds_loan_schol_code_2 IN VARCHAR2,
3324 x_nslds_loan_cont_code_2 IN VARCHAR2,
3325 x_nslds_loan_grade_lvl_2 IN VARCHAR2,
3326 x_nslds_loan_xtr_unsbz_ln_f_2 IN VARCHAR2,
3327 x_nslds_loan_capital_int_f_2 IN VARCHAR2,
3328 x_nslds_loan_seq_num_3 IN NUMBER,
3329 x_nslds_loan_type_code_3 IN VARCHAR2,
3330 x_nslds_loan_chng_f_3 IN VARCHAR2,
3331 x_nslds_loan_prog_code_3 IN VARCHAR2,
3332 x_nslds_loan_net_amnt_3 IN NUMBER,
3333 x_nslds_loan_cur_st_code_3 IN VARCHAR2,
3334 x_nslds_loan_cur_st_date_3 IN DATE,
3335 x_nslds_loan_agg_pr_bal_3 IN NUMBER,
3336 x_nslds_loan_out_pr_bal_dt_3 IN DATE,
3337 x_nslds_loan_begin_dt_3 IN DATE,
3338 x_nslds_loan_end_dt_3 IN DATE,
3339 x_nslds_loan_ga_code_3 IN VARCHAR2,
3340 x_nslds_loan_cont_type_3 IN VARCHAR2,
3341 x_nslds_loan_schol_code_3 IN VARCHAR2,
3342 x_nslds_loan_cont_code_3 IN VARCHAR2,
3343 x_nslds_loan_grade_lvl_3 IN VARCHAR2,
3344 x_nslds_loan_xtr_unsbz_ln_f_3 IN VARCHAR2,
3345 x_nslds_loan_capital_int_f_3 IN VARCHAR2,
3346 x_nslds_loan_seq_num_4 IN NUMBER,
3347 x_nslds_loan_type_code_4 IN VARCHAR2,
3348 x_nslds_loan_chng_f_4 IN VARCHAR2,
3349 x_nslds_loan_prog_code_4 IN VARCHAR2,
3350 x_nslds_loan_net_amnt_4 IN NUMBER,
3351 x_nslds_loan_cur_st_code_4 IN VARCHAR2,
3352 x_nslds_loan_cur_st_date_4 IN DATE,
3353 x_nslds_loan_agg_pr_bal_4 IN NUMBER,
3354 x_nslds_loan_out_pr_bal_dt_4 IN DATE,
3355 x_nslds_loan_begin_dt_4 IN DATE,
3356 x_nslds_loan_end_dt_4 IN DATE,
3357 x_nslds_loan_ga_code_4 IN VARCHAR2,
3358 x_nslds_loan_cont_type_4 IN VARCHAR2,
3359 x_nslds_loan_schol_code_4 IN VARCHAR2,
3360 x_nslds_loan_cont_code_4 IN VARCHAR2,
3361 x_nslds_loan_grade_lvl_4 IN VARCHAR2,
3362 x_nslds_loan_xtr_unsbz_ln_f_4 IN VARCHAR2,
3363 x_nslds_loan_capital_int_f_4 IN VARCHAR2,
3364 x_nslds_loan_seq_num_5 IN NUMBER,
3365 x_nslds_loan_type_code_5 IN VARCHAR2,
3366 x_nslds_loan_chng_f_5 IN VARCHAR2,
3367 x_nslds_loan_prog_code_5 IN VARCHAR2,
3368 x_nslds_loan_net_amnt_5 IN NUMBER,
3369 x_nslds_loan_cur_st_code_5 IN VARCHAR2,
3370 x_nslds_loan_cur_st_date_5 IN DATE,
3371 x_nslds_loan_agg_pr_bal_5 IN NUMBER,
3372 x_nslds_loan_out_pr_bal_dt_5 IN DATE,
3373 x_nslds_loan_begin_dt_5 IN DATE,
3374 x_nslds_loan_end_dt_5 IN DATE,
3375 x_nslds_loan_ga_code_5 IN VARCHAR2,
3376 x_nslds_loan_cont_type_5 IN VARCHAR2,
3377 x_nslds_loan_schol_code_5 IN VARCHAR2,
3378 x_nslds_loan_cont_code_5 IN VARCHAR2,
3379 x_nslds_loan_grade_lvl_5 IN VARCHAR2,
3380 x_nslds_loan_xtr_unsbz_ln_f_5 IN VARCHAR2,
3381 x_nslds_loan_capital_int_f_5 IN VARCHAR2,
3382 x_nslds_loan_seq_num_6 IN NUMBER,
3383 x_nslds_loan_type_code_6 IN VARCHAR2,
3384 x_nslds_loan_chng_f_6 IN VARCHAR2,
3385 x_nslds_loan_prog_code_6 IN VARCHAR2,
3386 x_nslds_loan_net_amnt_6 IN NUMBER,
3387 x_nslds_loan_cur_st_code_6 IN VARCHAR2,
3388 x_nslds_loan_cur_st_date_6 IN DATE,
3389 x_nslds_loan_agg_pr_bal_6 IN NUMBER,
3390 x_nslds_loan_out_pr_bal_dt_6 IN DATE,
3391 x_nslds_loan_begin_dt_6 IN DATE,
3392 x_nslds_loan_end_dt_6 IN DATE,
3393 x_nslds_loan_ga_code_6 IN VARCHAR2,
3394 x_nslds_loan_cont_type_6 IN VARCHAR2,
3395 x_nslds_loan_schol_code_6 IN VARCHAR2,
3396 x_nslds_loan_cont_code_6 IN VARCHAR2,
3397 x_nslds_loan_grade_lvl_6 IN VARCHAR2,
3398 x_nslds_loan_xtr_unsbz_ln_f_6 IN VARCHAR2,
3399 x_nslds_loan_capital_int_f_6 IN VARCHAR2,
3400 x_nslds_loan_last_d_amt_1 IN NUMBER ,
3401 x_nslds_loan_last_d_date_1 IN DATE ,
3402 x_nslds_loan_last_d_amt_2 IN NUMBER ,
3403 x_nslds_loan_last_d_date_2 IN DATE ,
3404 x_nslds_loan_last_d_amt_3 IN NUMBER ,
3405 x_nslds_loan_last_d_date_3 IN DATE ,
3406 x_nslds_loan_last_d_amt_4 IN NUMBER ,
3407 x_nslds_loan_last_d_date_4 IN DATE ,
3408 x_nslds_loan_last_d_amt_5 IN NUMBER ,
3409 x_nslds_loan_last_d_date_5 IN DATE ,
3410 x_nslds_loan_last_d_amt_6 IN NUMBER ,
3411 x_nslds_loan_last_d_date_6 IN DATE ,
3412 x_dlp_master_prom_note_flag IN VARCHAR2,
3413 x_mode IN VARCHAR2,
3414 x_subsidized_loan_limit_type IN VARCHAR2,
3415 x_combined_loan_limit_type IN VARCHAR2,
3416 x_transaction_num_txt IN VARCHAR2
3417 ) AS
3418 /*
3419 || Created By : rasingh
3420 || Created On : 06-DEC-2000
3421 || Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
3422 || Known limitations, enhancements or remarks :
3423 || Change History :
3424 || Who When What
3425 || (reverse chronological order - newest change first)
3426 */
3427 CURSOR c1 IS
3428 SELECT rowid
3429 FROM igf_ap_nslds_data_all
3430 WHERE nslds_id = x_nslds_id;
3431
3432 BEGIN
3433
3434 OPEN c1;
3435 FETCH c1 INTO x_rowid;
3436 IF (c1%NOTFOUND) THEN
3437 CLOSE c1;
3438
3439 insert_row (
3440 x_rowid,
3441 x_nslds_id,
3442 x_isir_id,
3443 x_base_id,
3444 x_nslds_transaction_num,
3445 x_nslds_database_results_f,
3446 x_nslds_f,
3447 x_nslds_pell_overpay_f,
3448 x_nslds_pell_overpay_contact,
3449 x_nslds_seog_overpay_f,
3450 x_nslds_seog_overpay_contact,
3451 x_nslds_perkins_overpay_f,
3452 x_nslds_perkins_overpay_cntct,
3453 x_nslds_defaulted_loan_f,
3454 x_nslds_dischged_loan_chng_f,
3455 x_nslds_satis_repay_f,
3456 x_nslds_act_bankruptcy_f,
3457 x_nslds_agg_subsz_out_prin_bal,
3458 x_nslds_agg_unsbz_out_prin_bal,
3459 x_nslds_agg_comb_out_prin_bal,
3460 x_nslds_agg_cons_out_prin_bal,
3461 x_nslds_agg_subsz_pend_dismt,
3462 x_nslds_agg_unsbz_pend_dismt,
3463 x_nslds_agg_comb_pend_dismt,
3464 x_nslds_agg_subsz_total,
3465 x_nslds_agg_unsbz_total,
3466 x_nslds_agg_comb_total,
3467 x_nslds_agg_consd_total,
3468 x_nslds_perkins_out_bal,
3469 x_nslds_perkins_cur_yr_dismnt,
3470 x_nslds_default_loan_chng_f,
3471 x_nslds_discharged_loan_f,
3472 x_nslds_satis_repay_chng_f,
3473 x_nslds_act_bnkrupt_chng_f,
3474 x_nslds_overpay_chng_f,
3475 x_nslds_agg_loan_chng_f,
3476 x_nslds_perkins_loan_chng_f,
3477 x_nslds_pell_paymnt_chng_f,
3478 x_nslds_addtnl_pell_f,
3479 x_nslds_addtnl_loan_f,
3480 x_direct_loan_mas_prom_nt_f,
3481 x_nslds_pell_seq_num_1,
3482 x_nslds_pell_verify_f_1,
3483 x_nslds_pell_efc_1,
3484 x_nslds_pell_school_code_1,
3485 x_nslds_pell_transcn_num_1,
3486 x_nslds_pell_last_updt_dt_1,
3487 x_nslds_pell_scheduled_amt_1,
3488 x_nslds_pell_amt_paid_todt_1,
3489 x_nslds_pell_remng_amt_1,
3490 x_nslds_pell_pc_schd_awd_us_1,
3491 x_nslds_pell_award_amt_1,
3492 x_nslds_pell_seq_num_2,
3493 x_nslds_pell_verify_f_2,
3494 x_nslds_pell_efc_2,
3495 x_nslds_pell_school_code_2,
3496 x_nslds_pell_transcn_num_2,
3497 x_nslds_pell_last_updt_dt_2,
3498 x_nslds_pell_scheduled_amt_2,
3499 x_nslds_pell_amt_paid_todt_2,
3500 x_nslds_pell_remng_amt_2,
3501 x_nslds_pell_pc_schd_awd_us_2,
3502 x_nslds_pell_award_amt_2,
3503 x_nslds_pell_seq_num_3,
3504 x_nslds_pell_verify_f_3,
3505 x_nslds_pell_efc_3,
3506 x_nslds_pell_school_code_3,
3507 x_nslds_pell_transcn_num_3,
3508 x_nslds_pell_last_updt_dt_3,
3509 x_nslds_pell_scheduled_amt_3,
3510 x_nslds_pell_amt_paid_todt_3,
3511 x_nslds_pell_remng_amt_3,
3512 x_nslds_pell_pc_schd_awd_us_3,
3513 x_nslds_pell_award_amt_3,
3514 x_nslds_loan_seq_num_1,
3515 x_nslds_loan_type_code_1,
3516 x_nslds_loan_chng_f_1,
3517 x_nslds_loan_prog_code_1,
3518 x_nslds_loan_net_amnt_1,
3519 x_nslds_loan_cur_st_code_1,
3520 x_nslds_loan_cur_st_date_1,
3521 x_nslds_loan_agg_pr_bal_1,
3522 x_nslds_loan_out_pr_bal_dt_1,
3523 x_nslds_loan_begin_dt_1,
3524 x_nslds_loan_end_dt_1,
3525 x_nslds_loan_ga_code_1,
3526 x_nslds_loan_cont_type_1,
3527 x_nslds_loan_schol_code_1,
3528 x_nslds_loan_cont_code_1,
3529 x_nslds_loan_grade_lvl_1,
3530 x_nslds_loan_xtr_unsbz_ln_f_1,
3531 x_nslds_loan_capital_int_f_1,
3532 x_nslds_loan_seq_num_2,
3533 x_nslds_loan_type_code_2,
3534 x_nslds_loan_chng_f_2,
3535 x_nslds_loan_prog_code_2,
3536 x_nslds_loan_net_amnt_2,
3537 x_nslds_loan_cur_st_code_2,
3538 x_nslds_loan_cur_st_date_2,
3539 x_nslds_loan_agg_pr_bal_2,
3540 x_nslds_loan_out_pr_bal_dt_2,
3541 x_nslds_loan_begin_dt_2,
3542 x_nslds_loan_end_dt_2,
3543 x_nslds_loan_ga_code_2,
3544 x_nslds_loan_cont_type_2,
3545 x_nslds_loan_schol_code_2,
3546 x_nslds_loan_cont_code_2,
3547 x_nslds_loan_grade_lvl_2,
3548 x_nslds_loan_xtr_unsbz_ln_f_2,
3549 x_nslds_loan_capital_int_f_2,
3550 x_nslds_loan_seq_num_3,
3551 x_nslds_loan_type_code_3,
3552 x_nslds_loan_chng_f_3,
3553 x_nslds_loan_prog_code_3,
3554 x_nslds_loan_net_amnt_3,
3555 x_nslds_loan_cur_st_code_3,
3556 x_nslds_loan_cur_st_date_3,
3557 x_nslds_loan_agg_pr_bal_3,
3558 x_nslds_loan_out_pr_bal_dt_3,
3559 x_nslds_loan_begin_dt_3,
3560 x_nslds_loan_end_dt_3,
3561 x_nslds_loan_ga_code_3,
3562 x_nslds_loan_cont_type_3,
3563 x_nslds_loan_schol_code_3,
3564 x_nslds_loan_cont_code_3,
3565 x_nslds_loan_grade_lvl_3,
3566 x_nslds_loan_xtr_unsbz_ln_f_3,
3567 x_nslds_loan_capital_int_f_3,
3568 x_nslds_loan_seq_num_4,
3569 x_nslds_loan_type_code_4,
3570 x_nslds_loan_chng_f_4,
3571 x_nslds_loan_prog_code_4,
3572 x_nslds_loan_net_amnt_4,
3573 x_nslds_loan_cur_st_code_4,
3574 x_nslds_loan_cur_st_date_4,
3575 x_nslds_loan_agg_pr_bal_4,
3576 x_nslds_loan_out_pr_bal_dt_4,
3577 x_nslds_loan_begin_dt_4,
3578 x_nslds_loan_end_dt_4,
3579 x_nslds_loan_ga_code_4,
3580 x_nslds_loan_cont_type_4,
3581 x_nslds_loan_schol_code_4,
3582 x_nslds_loan_cont_code_4,
3583 x_nslds_loan_grade_lvl_4,
3584 x_nslds_loan_xtr_unsbz_ln_f_4,
3585 x_nslds_loan_capital_int_f_4,
3586 x_nslds_loan_seq_num_5,
3587 x_nslds_loan_type_code_5,
3588 x_nslds_loan_chng_f_5,
3589 x_nslds_loan_prog_code_5,
3590 x_nslds_loan_net_amnt_5,
3591 x_nslds_loan_cur_st_code_5,
3592 x_nslds_loan_cur_st_date_5,
3593 x_nslds_loan_agg_pr_bal_5,
3594 x_nslds_loan_out_pr_bal_dt_5,
3595 x_nslds_loan_begin_dt_5,
3596 x_nslds_loan_end_dt_5,
3597 x_nslds_loan_ga_code_5,
3598 x_nslds_loan_cont_type_5,
3599 x_nslds_loan_schol_code_5,
3600 x_nslds_loan_cont_code_5,
3601 x_nslds_loan_grade_lvl_5,
3602 x_nslds_loan_xtr_unsbz_ln_f_5,
3603 x_nslds_loan_capital_int_f_5,
3604 x_nslds_loan_seq_num_6,
3605 x_nslds_loan_type_code_6,
3606 x_nslds_loan_chng_f_6,
3607 x_nslds_loan_prog_code_6,
3608 x_nslds_loan_net_amnt_6,
3609 x_nslds_loan_cur_st_code_6,
3610 x_nslds_loan_cur_st_date_6,
3611 x_nslds_loan_agg_pr_bal_6,
3612 x_nslds_loan_out_pr_bal_dt_6,
3613 x_nslds_loan_begin_dt_6,
3614 x_nslds_loan_end_dt_6,
3615 x_nslds_loan_ga_code_6,
3616 x_nslds_loan_cont_type_6,
3617 x_nslds_loan_schol_code_6,
3618 x_nslds_loan_cont_code_6,
3619 x_nslds_loan_grade_lvl_6,
3620 x_nslds_loan_xtr_unsbz_ln_f_6,
3621 x_nslds_loan_capital_int_f_6,
3622 x_nslds_loan_last_d_amt_1,
3623 x_nslds_loan_last_d_date_1,
3624 x_nslds_loan_last_d_amt_2,
3625 x_nslds_loan_last_d_date_2,
3626 x_nslds_loan_last_d_amt_3,
3627 x_nslds_loan_last_d_date_3,
3628 x_nslds_loan_last_d_amt_4,
3629 x_nslds_loan_last_d_date_4,
3630 x_nslds_loan_last_d_amt_5,
3631 x_nslds_loan_last_d_date_5,
3632 x_nslds_loan_last_d_amt_6,
3633 x_nslds_loan_last_d_date_6,
3634 x_dlp_master_prom_note_flag,
3635 x_mode,
3636 x_subsidized_loan_limit_type,
3637 x_combined_loan_limit_type,
3638 x_transaction_num_txt
3639 );
3640 RETURN;
3641 END IF;
3642 CLOSE c1;
3643
3644 update_row (
3645 x_rowid,
3646 x_nslds_id,
3647 x_isir_id,
3648 x_base_id,
3649 x_nslds_transaction_num,
3650 x_nslds_database_results_f,
3651 x_nslds_f,
3652 x_nslds_pell_overpay_f,
3653 x_nslds_pell_overpay_contact,
3654 x_nslds_seog_overpay_f,
3655 x_nslds_seog_overpay_contact,
3656 x_nslds_perkins_overpay_f,
3657 x_nslds_perkins_overpay_cntct,
3658 x_nslds_defaulted_loan_f,
3659 x_nslds_dischged_loan_chng_f,
3660 x_nslds_satis_repay_f,
3661 x_nslds_act_bankruptcy_f,
3662 x_nslds_agg_subsz_out_prin_bal,
3663 x_nslds_agg_unsbz_out_prin_bal,
3664 x_nslds_agg_comb_out_prin_bal,
3665 x_nslds_agg_cons_out_prin_bal,
3666 x_nslds_agg_subsz_pend_dismt,
3667 x_nslds_agg_unsbz_pend_dismt,
3668 x_nslds_agg_comb_pend_dismt,
3669 x_nslds_agg_subsz_total,
3670 x_nslds_agg_unsbz_total,
3671 x_nslds_agg_comb_total,
3672 x_nslds_agg_consd_total,
3673 x_nslds_perkins_out_bal,
3674 x_nslds_perkins_cur_yr_dismnt,
3675 x_nslds_default_loan_chng_f,
3676 x_nslds_discharged_loan_f,
3677 x_nslds_satis_repay_chng_f,
3678 x_nslds_act_bnkrupt_chng_f,
3679 x_nslds_overpay_chng_f,
3680 x_nslds_agg_loan_chng_f,
3681 x_nslds_perkins_loan_chng_f,
3682 x_nslds_pell_paymnt_chng_f,
3683 x_nslds_addtnl_pell_f,
3684 x_nslds_addtnl_loan_f,
3685 x_direct_loan_mas_prom_nt_f,
3686 x_nslds_pell_seq_num_1,
3687 x_nslds_pell_verify_f_1,
3688 x_nslds_pell_efc_1,
3689 x_nslds_pell_school_code_1,
3690 x_nslds_pell_transcn_num_1,
3691 x_nslds_pell_last_updt_dt_1,
3692 x_nslds_pell_scheduled_amt_1,
3693 x_nslds_pell_amt_paid_todt_1,
3694 x_nslds_pell_remng_amt_1,
3695 x_nslds_pell_pc_schd_awd_us_1,
3696 x_nslds_pell_award_amt_1,
3697 x_nslds_pell_seq_num_2,
3698 x_nslds_pell_verify_f_2,
3699 x_nslds_pell_efc_2,
3700 x_nslds_pell_school_code_2,
3701 x_nslds_pell_transcn_num_2,
3702 x_nslds_pell_last_updt_dt_2,
3703 x_nslds_pell_scheduled_amt_2,
3704 x_nslds_pell_amt_paid_todt_2,
3705 x_nslds_pell_remng_amt_2,
3706 x_nslds_pell_pc_schd_awd_us_2,
3707 x_nslds_pell_award_amt_2,
3708 x_nslds_pell_seq_num_3,
3709 x_nslds_pell_verify_f_3,
3710 x_nslds_pell_efc_3,
3711 x_nslds_pell_school_code_3,
3712 x_nslds_pell_transcn_num_3,
3713 x_nslds_pell_last_updt_dt_3,
3714 x_nslds_pell_scheduled_amt_3,
3715 x_nslds_pell_amt_paid_todt_3,
3716 x_nslds_pell_remng_amt_3,
3717 x_nslds_pell_pc_schd_awd_us_3,
3718 x_nslds_pell_award_amt_3,
3719 x_nslds_loan_seq_num_1,
3720 x_nslds_loan_type_code_1,
3721 x_nslds_loan_chng_f_1,
3722 x_nslds_loan_prog_code_1,
3723 x_nslds_loan_net_amnt_1,
3724 x_nslds_loan_cur_st_code_1,
3725 x_nslds_loan_cur_st_date_1,
3726 x_nslds_loan_agg_pr_bal_1,
3727 x_nslds_loan_out_pr_bal_dt_1,
3728 x_nslds_loan_begin_dt_1,
3729 x_nslds_loan_end_dt_1,
3730 x_nslds_loan_ga_code_1,
3731 x_nslds_loan_cont_type_1,
3732 x_nslds_loan_schol_code_1,
3733 x_nslds_loan_cont_code_1,
3734 x_nslds_loan_grade_lvl_1,
3735 x_nslds_loan_xtr_unsbz_ln_f_1,
3736 x_nslds_loan_capital_int_f_1,
3737 x_nslds_loan_seq_num_2,
3738 x_nslds_loan_type_code_2,
3739 x_nslds_loan_chng_f_2,
3740 x_nslds_loan_prog_code_2,
3741 x_nslds_loan_net_amnt_2,
3742 x_nslds_loan_cur_st_code_2,
3743 x_nslds_loan_cur_st_date_2,
3744 x_nslds_loan_agg_pr_bal_2,
3745 x_nslds_loan_out_pr_bal_dt_2,
3746 x_nslds_loan_begin_dt_2,
3747 x_nslds_loan_end_dt_2,
3748 x_nslds_loan_ga_code_2,
3749 x_nslds_loan_cont_type_2,
3750 x_nslds_loan_schol_code_2,
3751 x_nslds_loan_cont_code_2,
3752 x_nslds_loan_grade_lvl_2,
3753 x_nslds_loan_xtr_unsbz_ln_f_2,
3754 x_nslds_loan_capital_int_f_2,
3755 x_nslds_loan_seq_num_3,
3756 x_nslds_loan_type_code_3,
3757 x_nslds_loan_chng_f_3,
3758 x_nslds_loan_prog_code_3,
3759 x_nslds_loan_net_amnt_3,
3760 x_nslds_loan_cur_st_code_3,
3761 x_nslds_loan_cur_st_date_3,
3762 x_nslds_loan_agg_pr_bal_3,
3763 x_nslds_loan_out_pr_bal_dt_3,
3764 x_nslds_loan_begin_dt_3,
3765 x_nslds_loan_end_dt_3,
3766 x_nslds_loan_ga_code_3,
3767 x_nslds_loan_cont_type_3,
3768 x_nslds_loan_schol_code_3,
3769 x_nslds_loan_cont_code_3,
3770 x_nslds_loan_grade_lvl_3,
3771 x_nslds_loan_xtr_unsbz_ln_f_3,
3772 x_nslds_loan_capital_int_f_3,
3773 x_nslds_loan_seq_num_4,
3774 x_nslds_loan_type_code_4,
3775 x_nslds_loan_chng_f_4,
3776 x_nslds_loan_prog_code_4,
3777 x_nslds_loan_net_amnt_4,
3778 x_nslds_loan_cur_st_code_4,
3779 x_nslds_loan_cur_st_date_4,
3780 x_nslds_loan_agg_pr_bal_4,
3781 x_nslds_loan_out_pr_bal_dt_4,
3782 x_nslds_loan_begin_dt_4,
3783 x_nslds_loan_end_dt_4,
3784 x_nslds_loan_ga_code_4,
3785 x_nslds_loan_cont_type_4,
3786 x_nslds_loan_schol_code_4,
3787 x_nslds_loan_cont_code_4,
3788 x_nslds_loan_grade_lvl_4,
3789 x_nslds_loan_xtr_unsbz_ln_f_4,
3790 x_nslds_loan_capital_int_f_4,
3791 x_nslds_loan_seq_num_5,
3792 x_nslds_loan_type_code_5,
3793 x_nslds_loan_chng_f_5,
3794 x_nslds_loan_prog_code_5,
3795 x_nslds_loan_net_amnt_5,
3796 x_nslds_loan_cur_st_code_5,
3797 x_nslds_loan_cur_st_date_5,
3798 x_nslds_loan_agg_pr_bal_5,
3799 x_nslds_loan_out_pr_bal_dt_5,
3800 x_nslds_loan_begin_dt_5,
3801 x_nslds_loan_end_dt_5,
3802 x_nslds_loan_ga_code_5,
3803 x_nslds_loan_cont_type_5,
3804 x_nslds_loan_schol_code_5,
3805 x_nslds_loan_cont_code_5,
3806 x_nslds_loan_grade_lvl_5,
3807 x_nslds_loan_xtr_unsbz_ln_f_5,
3808 x_nslds_loan_capital_int_f_5,
3809 x_nslds_loan_seq_num_6,
3810 x_nslds_loan_type_code_6,
3811 x_nslds_loan_chng_f_6,
3812 x_nslds_loan_prog_code_6,
3813 x_nslds_loan_net_amnt_6,
3814 x_nslds_loan_cur_st_code_6,
3815 x_nslds_loan_cur_st_date_6,
3816 x_nslds_loan_agg_pr_bal_6,
3817 x_nslds_loan_out_pr_bal_dt_6,
3818 x_nslds_loan_begin_dt_6,
3819 x_nslds_loan_end_dt_6,
3820 x_nslds_loan_ga_code_6,
3821 x_nslds_loan_cont_type_6,
3822 x_nslds_loan_schol_code_6,
3823 x_nslds_loan_cont_code_6,
3824 x_nslds_loan_grade_lvl_6,
3825 x_nslds_loan_xtr_unsbz_ln_f_6,
3826 x_nslds_loan_capital_int_f_6,
3827 x_nslds_loan_last_d_amt_1,
3828 x_nslds_loan_last_d_date_1,
3829 x_nslds_loan_last_d_amt_2,
3830 x_nslds_loan_last_d_date_2,
3831 x_nslds_loan_last_d_amt_3,
3832 x_nslds_loan_last_d_date_3,
3833 x_nslds_loan_last_d_amt_4,
3834 x_nslds_loan_last_d_date_4,
3835 x_nslds_loan_last_d_amt_5,
3836 x_nslds_loan_last_d_date_5,
3837 x_nslds_loan_last_d_amt_6,
3838 x_nslds_loan_last_d_date_6,
3839 x_dlp_master_prom_note_flag,
3840 x_mode,
3841 x_subsidized_loan_limit_type,
3842 x_combined_loan_limit_type,
3843 x_transaction_num_txt
3844 );
3845
3846 END add_row;
3847
3848
3849 PROCEDURE delete_row (
3850 x_rowid IN VARCHAR2
3851 ) AS
3852 /*
3853 || Created By : rasingh
3854 || Created On : 06-DEC-2000
3855 || Purpose : Handles the DELETE DML logic for the table.
3856 || Known limitations, enhancements or remarks :
3857 || Change History :
3858 || Who When What
3859 || (reverse chronological order - newest change first)
3860 */
3861 BEGIN
3862
3863 before_dml (
3864 p_action => 'DELETE',
3865 x_rowid => x_rowid
3866 );
3867
3868 DELETE FROM igf_ap_nslds_data_all
3869 WHERE rowid = x_rowid;
3870
3871 IF (SQL%NOTFOUND) THEN
3872 RAISE NO_DATA_FOUND;
3873 END IF;
3874
3875 END delete_row;
3876
3877
3878 END igf_ap_nslds_data_pkg;