[Home] [Help]
PACKAGE BODY: APPS.IGF_SL_ALT_BORW_PKG
Source
1 PACKAGE BODY igf_sl_alt_borw_pkg AS
2 /* $Header: IGFLI32B.pls 120.1 2005/06/08 00:48:35 appldev $ */
3
4 l_rowid VARCHAR2(25);
5 old_references igf_sl_alt_borw_all%ROWTYPE;
6 new_references igf_sl_alt_borw_all%ROWTYPE;
7
8 PROCEDURE set_column_values (
9 p_action IN VARCHAR2 ,
10 x_rowid IN VARCHAR2 ,
11 x_albw_id IN NUMBER ,
12 x_loan_id IN NUMBER ,
13 x_fed_stafford_loan_debt IN NUMBER ,
14 x_fed_sls_debt IN NUMBER ,
15 x_heal_debt IN NUMBER ,
16 x_perkins_debt IN NUMBER ,
17 x_other_debt IN NUMBER ,
18 x_crdt_undr_difft_name IN VARCHAR2 ,
19 x_borw_gross_annual_sal IN NUMBER ,
20 x_borw_other_income IN NUMBER ,
21 x_student_major IN VARCHAR2 ,
22 x_int_rate_opt IN VARCHAR2 ,
23 x_repayment_opt_code IN VARCHAR2 ,
24 x_stud_mth_housing_pymt IN NUMBER ,
25 x_stud_mth_crdtcard_pymt IN NUMBER ,
26 x_stud_mth_auto_pymt IN NUMBER ,
27 x_stud_mth_ed_loan_pymt IN NUMBER ,
28 x_stud_mth_other_pymt IN NUMBER ,
29 x_creation_date IN DATE ,
30 x_created_by IN NUMBER ,
31 x_last_update_date IN DATE ,
32 x_last_updated_by IN NUMBER ,
33 x_last_update_login IN NUMBER ,
34 x_other_loan_amt IN NUMBER,
35 x_cs1_lname IN VARCHAR2,
36 x_cs1_fname IN VARCHAR2,
37 x_cs1_mi_txt IN VARCHAR2,
38 x_cs1_ssn_txt IN VARCHAR2,
39 x_cs1_citizenship_status IN VARCHAR2,
40 x_cs1_address_line_1_txt IN VARCHAR2,
41 x_cs1_address_line_2_txt IN VARCHAR2,
42 x_cs1_city_txt IN VARCHAR2,
43 x_cs1_state_txt IN VARCHAR2,
44 x_cs1_zip_txt IN VARCHAR2,
45 x_cs1_zip_suffix_txt IN VARCHAR2,
46 x_cs1_telephone_number_txt IN VARCHAR2,
47 x_cs1_signature_code_txt IN VARCHAR2,
48 x_cs2_lname IN VARCHAR2,
49 x_cs2_fname IN VARCHAR2,
50 x_cs2_mi_txt IN VARCHAR2,
51 x_cs2_ssn_txt IN VARCHAR2,
52 x_cs2_citizenship_status IN VARCHAR2,
53 x_cs2_address_line_1_txt IN VARCHAR2,
54 x_cs2_address_line_2_txt IN VARCHAR2,
55 x_cs2_city_txt IN VARCHAR2,
56 x_cs2_state_txt IN VARCHAR2,
57 x_cs2_zip_txt IN VARCHAR2,
58 x_cs2_zip_suffix_txt IN VARCHAR2,
59 x_cs2_telephone_number_txt IN VARCHAR2,
60 x_cs2_signature_code_txt IN VARCHAR2,
61 x_cs1_credit_auth_code_txt IN VARCHAR2,
62 x_cs1_birth_date IN Date ,
63 x_cs1_drv_license_num_txt IN VARCHAR2,
64 x_cs1_drv_license_state_txt IN VARCHAR2,
65 x_cs1_elect_sig_ind_code_txt IN VARCHAR2,
66 x_cs1_frgn_postal_code_txt IN VARCHAR2,
67 x_cs1_frgn_tel_num_prefix_txt IN VARCHAR2,
68 x_cs1_gross_annual_sal_num IN NUMBER ,
69 x_cs1_mthl_auto_pay_txt IN VARCHAR2,
70 x_cs1_mthl_cc_pay_txt IN VARCHAR2,
71 x_cs1_mthl_edu_loan_pay_txt IN VARCHAR2,
72 x_cs1_mthl_housing_pay_txt IN VARCHAR2,
73 x_cs1_mthl_other_pay_txt IN VARCHAR2,
74 x_cs1_other_income_amt IN NUMBER ,
75 x_cs1_rel_to_student_flag IN VARCHAR2,
76 x_cs1_suffix_txt IN VARCHAR2,
77 x_cs1_years_at_address_txt IN NUMBER ,
78 x_cs2_credit_auth_code_txt IN VARCHAR2,
79 x_cs2_birth_date IN Date ,
80 x_cs2_drv_license_num_txt IN VARCHAR2,
81 x_cs2_drv_license_state_txt IN VARCHAR2,
82 x_cs2_elect_sig_ind_code_txt IN VARCHAR2,
83 x_cs2_frgn_postal_code_txt IN VARCHAR2,
84 x_cs2_frgn_tel_num_prefix_txt IN VARCHAR2,
85 x_cs2_gross_annual_sal_num IN NUMBER ,
86 x_cs2_mthl_auto_pay_txt IN VARCHAR2,
87 x_cs2_mthl_cc_pay_txt IN VARCHAR2,
88 x_cs2_mthl_edu_loan_pay_txt IN VARCHAR2,
89 x_cs2_mthl_housing_pay_txt IN VARCHAR2,
90 x_cs2_mthl_other_pay_txt IN VARCHAR2,
91 x_cs2_other_income_amt IN NUMBER ,
92 x_cs2_rel_to_student_flag IN VARCHAR2,
93 x_cs2_suffix_txt IN VARCHAR2,
94 x_cs2_years_at_address_txt IN NUMBER
95 ) AS
96 /*
97 || Created By : viramali
98 || Created On : 10-MAY-2001
99 || Purpose : Initialises the Old and New references for the columns of the table.
100 || Known limitations, enhancements or remarks :
101 || Change History :
102 || Who When What
103 || (reverse chronological order - newest change first)
104 */
105
106 CURSOR cur_old_ref_values IS
107 SELECT *
108 FROM igf_sl_alt_borw_all
109 WHERE rowid = x_rowid;
110
111 BEGIN
112
113 l_rowid := x_rowid;
114
115 -- Code for setting the Old and New Reference Values.
116 -- Populate Old Values.
117 OPEN cur_old_ref_values;
118 FETCH cur_old_ref_values INTO old_references;
119 IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
120 CLOSE cur_old_ref_values;
121 FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
122 IGS_GE_MSG_STACK.ADD;
123 APP_EXCEPTION.RAISE_EXCEPTION;
124 RETURN;
125 END IF;
126 CLOSE cur_old_ref_values;
127
128 -- Populate New Values.
129 new_references.albw_id := x_albw_id;
130 new_references.loan_id := x_loan_id;
131 new_references.fed_stafford_loan_debt := x_fed_stafford_loan_debt;
132 new_references.fed_sls_debt := x_fed_sls_debt;
133 new_references.heal_debt := x_heal_debt;
134 new_references.perkins_debt := x_perkins_debt;
135 new_references.other_debt := x_other_debt;
136 new_references.crdt_undr_difft_name := x_crdt_undr_difft_name;
137 new_references.borw_gross_annual_sal := x_borw_gross_annual_sal;
138 new_references.borw_other_income := x_borw_other_income;
139 new_references.student_major := x_student_major;
140 new_references.int_rate_opt := x_int_rate_opt;
141 new_references.repayment_opt_code := x_repayment_opt_code;
142 new_references.stud_mth_housing_pymt := x_stud_mth_housing_pymt;
143 new_references.stud_mth_crdtcard_pymt := x_stud_mth_crdtcard_pymt;
144 new_references.stud_mth_auto_pymt := x_stud_mth_auto_pymt;
145 new_references.stud_mth_ed_loan_pymt := x_stud_mth_ed_loan_pymt;
146 new_references.stud_mth_other_pymt := x_stud_mth_other_pymt;
147
148 IF (p_action = 'UPDATE') THEN
149 new_references.creation_date := old_references.creation_date;
150 new_references.created_by := old_references.created_by;
151 ELSE
152 new_references.creation_date := x_creation_date;
153 new_references.created_by := x_created_by;
154 END IF;
155
156 new_references.last_update_date := x_last_update_date;
157 new_references.last_updated_by := x_last_updated_by;
158 new_references.last_update_login := x_last_update_login;
159 new_references.other_loan_amt := x_other_loan_amt;
160
161 new_references.cs1_lname := x_cs1_lname;
162 new_references.cs1_fname := x_cs1_fname;
163 new_references.cs1_mi_txt := x_cs1_mi_txt;
164 new_references.cs1_ssn_txt := x_cs1_ssn_txt;
165 new_references.cs1_citizenship_status := x_cs1_citizenship_status;
166 new_references.cs1_address_line_1_txt := x_cs1_address_line_1_txt;
167 new_references.cs1_address_line_2_txt := x_cs1_address_line_2_txt;
168 new_references.cs1_city_txt := x_cs1_city_txt;
169 new_references.cs1_state_txt := x_cs1_state_txt;
170 new_references.cs1_zip_txt := x_cs1_zip_txt;
171 new_references.cs1_zip_suffix_txt := x_cs1_zip_suffix_txt;
172 new_references.cs1_telephone_number_txt := x_cs1_telephone_number_txt;
173 new_references.cs1_signature_code_txt := x_cs1_signature_code_txt;
174 new_references.cs2_lname := x_cs2_lname;
175 new_references.cs2_fname := x_cs2_fname;
176 new_references.cs2_mi_txt := x_cs2_mi_txt;
177 new_references.cs2_ssn_txt := x_cs2_ssn_txt;
178 new_references.cs2_citizenship_status := x_cs2_citizenship_status;
179 new_references.cs2_address_line_1_txt := x_cs2_address_line_1_txt;
180 new_references.cs2_address_line_2_txt := x_cs2_address_line_2_txt;
181 new_references.cs2_city_txt := x_cs2_city_txt;
182 new_references.cs2_state_txt := x_cs2_state_txt;
183 new_references.cs2_zip_txt := x_cs2_zip_txt;
184 new_references.cs2_zip_suffix_txt := x_cs2_zip_suffix_txt;
185 new_references.cs2_telephone_number_txt := x_cs2_telephone_number_txt;
186 new_references.cs2_signature_code_txt := x_cs2_signature_code_txt;
187 new_references.cs1_credit_auth_code_txt := x_cs1_credit_auth_code_txt;
188 new_references.cs1_birth_date := x_cs1_birth_date;
189 new_references.cs1_drv_license_num_txt := x_cs1_drv_license_num_txt;
190 new_references.cs1_drv_license_state_txt := x_cs1_drv_license_state_txt;
191 new_references.cs1_elect_sig_ind_code_txt := x_cs1_elect_sig_ind_code_txt;
192 new_references.cs1_frgn_postal_code_txt := x_cs1_frgn_postal_code_txt;
193 new_references.cs1_frgn_tel_num_prefix_txt := x_cs1_frgn_tel_num_prefix_txt;
194 new_references.cs1_gross_annual_sal_num := x_cs1_gross_annual_sal_num;
195 new_references.cs1_mthl_auto_pay_txt := x_cs1_mthl_auto_pay_txt;
196 new_references.cs1_mthl_cc_pay_txt := x_cs1_mthl_cc_pay_txt;
197 new_references.cs1_mthl_edu_loan_pay_txt := x_cs1_mthl_edu_loan_pay_txt;
198 new_references.cs1_mthl_housing_pay_txt := x_cs1_mthl_housing_pay_txt;
199 new_references.cs1_mthl_other_pay_txt := x_cs1_mthl_other_pay_txt;
200 new_references.cs1_other_income_amt := x_cs1_other_income_amt;
201 new_references.cs1_rel_to_student_flag := x_cs1_rel_to_student_flag;
202 new_references.cs1_suffix_txt := x_cs1_suffix_txt;
203 new_references.cs1_years_at_address_txt := x_cs1_years_at_address_txt;
204 new_references.cs2_credit_auth_code_txt := x_cs2_credit_auth_code_txt;
205 new_references.cs2_birth_date := x_cs2_birth_date;
206 new_references.cs2_drv_license_num_txt := x_cs2_drv_license_num_txt;
207 new_references.cs2_drv_license_state_txt := x_cs2_drv_license_state_txt;
208 new_references.cs2_elect_sig_ind_code_txt := x_cs2_elect_sig_ind_code_txt;
209 new_references.cs2_frgn_postal_code_txt := x_cs2_frgn_postal_code_txt;
210 new_references.cs2_frgn_tel_num_prefix_txt := x_cs2_frgn_tel_num_prefix_txt;
211 new_references.cs2_gross_annual_sal_num := x_cs2_gross_annual_sal_num;
212 new_references.cs2_mthl_auto_pay_txt := x_cs2_mthl_auto_pay_txt;
213 new_references.cs2_mthl_cc_pay_txt := x_cs2_mthl_cc_pay_txt;
214 new_references.cs2_mthl_edu_loan_pay_txt := x_cs2_mthl_edu_loan_pay_txt;
215 new_references.cs2_mthl_housing_pay_txt := x_cs2_mthl_housing_pay_txt;
216 new_references.cs2_mthl_other_pay_txt := x_cs2_mthl_other_pay_txt;
217 new_references.cs2_other_income_amt := x_cs2_other_income_amt;
218 new_references.cs2_rel_to_student_flag := x_cs2_rel_to_student_flag;
219 new_references.cs2_suffix_txt := x_cs2_suffix_txt;
220 new_references.cs2_years_at_address_txt := x_cs2_years_at_address_txt;
221
222 END set_column_values;
223
224
225 PROCEDURE check_parent_existance AS
226 /*
227 || Created By : viramali
228 || Created On : 10-MAY-2001
229 || Purpose : Checks for the existance of Parent records.
230 || Known limitations, enhancements or remarks :
231 || Change History :
232 || Who When What
233 || (reverse chronological order - newest change first)
234 */
235 BEGIN
236
237 IF (((old_references.loan_id = new_references.loan_id)) OR
238 ((new_references.loan_id IS NULL))) THEN
239 NULL;
240 ELSIF NOT igf_sl_loans_pkg.get_pk_for_validation ( new_references.loan_id ) THEN
241 FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
242 IGS_GE_MSG_STACK.ADD;
243 APP_EXCEPTION.RAISE_EXCEPTION;
244 END IF;
245
246 END check_parent_existance;
247
248
249 FUNCTION get_pk_for_validation (
250 x_albw_id IN NUMBER
251 ) RETURN BOOLEAN AS
252 /*
253 || Created By : viramali
254 || Created On : 10-MAY-2001
255 || Purpose : Validates the Primary Key of the table.
256 || Known limitations, enhancements or remarks :
257 || Change History :
258 || Who When What
259 || (reverse chronological order - newest change first)
260 */
261 CURSOR cur_rowid IS
262 SELECT rowid
263 FROM igf_sl_alt_borw_all
264 WHERE albw_id = x_albw_id
265 FOR UPDATE NOWAIT;
266
267 lv_rowid cur_rowid%ROWTYPE;
268
269 BEGIN
270
271 OPEN cur_rowid;
272 FETCH cur_rowid INTO lv_rowid;
273 IF (cur_rowid%FOUND) THEN
274 CLOSE cur_rowid;
275 RETURN(TRUE);
276 ELSE
277 CLOSE cur_rowid;
278 RETURN(FALSE);
279 END IF;
280
281 END get_pk_for_validation;
282
283
284 PROCEDURE get_fk_igf_sl_loans ( x_loan_id IN NUMBER ) AS
285 /*
286 || Created By : viramali
287 || Created On : 10-MAY-2001
288 || Purpose : Validates the Foreign Keys for the table.
289 || Known limitations, enhancements or remarks :
290 || Change History :
291 || Who When What
292 || (reverse chronological order - newest change first)
293 */
294 CURSOR cur_rowid IS
295 SELECT rowid
296 FROM igf_sl_alt_borw_all
297 WHERE ((loan_id = x_loan_id));
298
299 lv_rowid cur_rowid%ROWTYPE;
300
301 BEGIN
302
303 OPEN cur_rowid;
304 FETCH cur_rowid INTO lv_rowid;
305 IF (cur_rowid%FOUND) THEN
306 CLOSE cur_rowid;
307 FND_MESSAGE.SET_NAME ('IGF', 'IGF_SL_ALBW_LAR_FK');
308 IGS_GE_MSG_STACK.ADD;
309 APP_EXCEPTION.RAISE_EXCEPTION;
310 RETURN;
311 END IF;
312 CLOSE cur_rowid;
313
314 END get_fk_igf_sl_loans;
315
316
317 PROCEDURE before_dml (
318 p_action IN VARCHAR2 ,
319 x_rowid IN VARCHAR2 ,
320 x_albw_id IN NUMBER ,
321 x_loan_id IN NUMBER ,
322 x_fed_stafford_loan_debt IN NUMBER ,
323 x_fed_sls_debt IN NUMBER ,
324 x_heal_debt IN NUMBER ,
325 x_perkins_debt IN NUMBER ,
326 x_other_debt IN NUMBER ,
327 x_crdt_undr_difft_name IN VARCHAR2 ,
328 x_borw_gross_annual_sal IN NUMBER ,
329 x_borw_other_income IN NUMBER ,
330 x_student_major IN VARCHAR2 ,
331 x_int_rate_opt IN VARCHAR2 ,
332 x_repayment_opt_code IN VARCHAR2 ,
333 x_stud_mth_housing_pymt IN NUMBER ,
334 x_stud_mth_crdtcard_pymt IN NUMBER ,
335 x_stud_mth_auto_pymt IN NUMBER ,
336 x_stud_mth_ed_loan_pymt IN NUMBER ,
337 x_stud_mth_other_pymt IN NUMBER ,
338 x_creation_date IN DATE ,
339 x_created_by IN NUMBER ,
340 x_last_update_date IN DATE ,
341 x_last_updated_by IN NUMBER ,
342 x_last_update_login IN NUMBER ,
343 x_other_loan_amt IN NUMBER,
344 x_cs1_lname IN VARCHAR2,
345 x_cs1_fname IN VARCHAR2,
346 x_cs1_mi_txt IN VARCHAR2,
347 x_cs1_ssn_txt IN VARCHAR2,
348 x_cs1_citizenship_status IN VARCHAR2,
349 x_cs1_address_line_1_txt IN VARCHAR2,
350 x_cs1_address_line_2_txt IN VARCHAR2,
351 x_cs1_city_txt IN VARCHAR2,
352 x_cs1_state_txt IN VARCHAR2,
353 x_cs1_zip_txt IN VARCHAR2,
354 x_cs1_zip_suffix_txt IN VARCHAR2,
355 x_cs1_telephone_number_txt IN VARCHAR2,
356 x_cs1_signature_code_txt IN VARCHAR2,
357 x_cs2_lname IN VARCHAR2,
358 x_cs2_fname IN VARCHAR2,
359 x_cs2_mi_txt IN VARCHAR2,
360 x_cs2_ssn_txt IN VARCHAR2,
361 x_cs2_citizenship_status IN VARCHAR2,
362 x_cs2_address_line_1_txt IN VARCHAR2,
363 x_cs2_address_line_2_txt IN VARCHAR2,
364 x_cs2_city_txt IN VARCHAR2,
365 x_cs2_state_txt IN VARCHAR2,
366 x_cs2_zip_txt IN VARCHAR2,
367 x_cs2_zip_suffix_txt IN VARCHAR2,
368 x_cs2_telephone_number_txt IN VARCHAR2,
369 x_cs2_signature_code_txt IN VARCHAR2,
370 x_cs1_credit_auth_code_txt IN VARCHAR2,
371 x_cs1_birth_date IN Date ,
372 x_cs1_drv_license_num_txt IN VARCHAR2,
373 x_cs1_drv_license_state_txt IN VARCHAR2,
374 x_cs1_elect_sig_ind_code_txt IN VARCHAR2,
375 x_cs1_frgn_postal_code_txt IN VARCHAR2,
376 x_cs1_frgn_tel_num_prefix_txt IN VARCHAR2,
377 x_cs1_gross_annual_sal_num IN NUMBER ,
378 x_cs1_mthl_auto_pay_txt IN VARCHAR2,
379 x_cs1_mthl_cc_pay_txt IN VARCHAR2,
380 x_cs1_mthl_edu_loan_pay_txt IN VARCHAR2,
381 x_cs1_mthl_housing_pay_txt IN VARCHAR2,
382 x_cs1_mthl_other_pay_txt IN VARCHAR2,
383 x_cs1_other_income_amt IN NUMBER ,
384 x_cs1_rel_to_student_flag IN VARCHAR2,
385 x_cs1_suffix_txt IN VARCHAR2,
386 x_cs1_years_at_address_txt IN NUMBER ,
387 x_cs2_credit_auth_code_txt IN VARCHAR2,
388 x_cs2_birth_date IN Date ,
389 x_cs2_drv_license_num_txt IN VARCHAR2,
390 x_cs2_drv_license_state_txt IN VARCHAR2,
391 x_cs2_elect_sig_ind_code_txt IN VARCHAR2,
392 x_cs2_frgn_postal_code_txt IN VARCHAR2,
393 x_cs2_frgn_tel_num_prefix_txt IN VARCHAR2,
394 x_cs2_gross_annual_sal_num IN NUMBER ,
395 x_cs2_mthl_auto_pay_txt IN VARCHAR2,
396 x_cs2_mthl_cc_pay_txt IN VARCHAR2,
397 x_cs2_mthl_edu_loan_pay_txt IN VARCHAR2,
398 x_cs2_mthl_housing_pay_txt IN VARCHAR2,
399 x_cs2_mthl_other_pay_txt IN VARCHAR2,
400 x_cs2_other_income_amt IN NUMBER ,
401 x_cs2_rel_to_student_flag IN VARCHAR2,
402 x_cs2_suffix_txt IN VARCHAR2,
403 x_cs2_years_at_address_txt IN NUMBER
404 ) AS
405 /*
406 || Created By : viramali
407 || Created On : 10-MAY-2001
408 || Purpose : Initialises the columns, Checks Constraints, Calls the
409 || Trigger Handlers for the table, before any DML operation.
410 || Known limitations, enhancements or remarks :
411 || Change History :
412 || Who When What
413 || (reverse chronological order - newest change first)
414 */
415 BEGIN
416
417 set_column_values (
418 p_action,
419 x_rowid,
420 x_albw_id,
421 x_loan_id,
422 x_fed_stafford_loan_debt,
423 x_fed_sls_debt,
424 x_heal_debt,
425 x_perkins_debt,
426 x_other_debt,
427 x_crdt_undr_difft_name,
428 x_borw_gross_annual_sal,
429 x_borw_other_income,
430 x_student_major,
431 x_int_rate_opt,
432 x_repayment_opt_code,
433 x_stud_mth_housing_pymt,
434 x_stud_mth_crdtcard_pymt,
435 x_stud_mth_auto_pymt,
436 x_stud_mth_ed_loan_pymt,
437 x_stud_mth_other_pymt,
438 x_creation_date,
439 x_created_by,
440 x_last_update_date,
441 x_last_updated_by,
442 x_last_update_login,
443 x_other_loan_amt,
444 x_cs1_lname,
445 x_cs1_fname,
446 x_cs1_mi_txt,
447 x_cs1_ssn_txt,
448 x_cs1_citizenship_status,
449 x_cs1_address_line_1_txt,
450 x_cs1_address_line_2_txt,
451 x_cs1_city_txt,
452 x_cs1_state_txt,
453 x_cs1_zip_txt,
454 x_cs1_zip_suffix_txt,
455 x_cs1_telephone_number_txt,
456 x_cs1_signature_code_txt,
457 x_cs2_lname,
458 x_cs2_fname,
459 x_cs2_mi_txt,
460 x_cs2_ssn_txt,
461 x_cs2_citizenship_status,
462 x_cs2_address_line_1_txt,
463 x_cs2_address_line_2_txt,
464 x_cs2_city_txt,
465 x_cs2_state_txt,
466 x_cs2_zip_txt,
467 x_cs2_zip_suffix_txt,
468 x_cs2_telephone_number_txt,
469 x_cs2_signature_code_txt,
470 x_cs1_credit_auth_code_txt,
471 x_cs1_birth_date,
472 x_cs1_drv_license_num_txt,
473 x_cs1_drv_license_state_txt,
474 x_cs1_elect_sig_ind_code_txt,
475 x_cs1_frgn_postal_code_txt,
476 x_cs1_frgn_tel_num_prefix_txt,
477 x_cs1_gross_annual_sal_num,
478 x_cs1_mthl_auto_pay_txt,
479 x_cs1_mthl_cc_pay_txt,
480 x_cs1_mthl_edu_loan_pay_txt,
481 x_cs1_mthl_housing_pay_txt,
482 x_cs1_mthl_other_pay_txt,
483 x_cs1_other_income_amt,
484 x_cs1_rel_to_student_flag,
485 x_cs1_suffix_txt,
486 x_cs1_years_at_address_txt,
487 x_cs2_credit_auth_code_txt,
488 x_cs2_birth_date,
489 x_cs2_drv_license_num_txt,
490 x_cs2_drv_license_state_txt,
491 x_cs2_elect_sig_ind_code_txt,
492 x_cs2_frgn_postal_code_txt,
493 x_cs2_frgn_tel_num_prefix_txt,
494 x_cs2_gross_annual_sal_num,
495 x_cs2_mthl_auto_pay_txt,
496 x_cs2_mthl_cc_pay_txt,
497 x_cs2_mthl_edu_loan_pay_txt,
498 x_cs2_mthl_housing_pay_txt,
499 x_cs2_mthl_other_pay_txt,
500 x_cs2_other_income_amt,
501 x_cs2_rel_to_student_flag,
502 x_cs2_suffix_txt,
503 x_cs2_years_at_address_txt
504 );
505
506 IF (p_action = 'INSERT') THEN
507 -- Call all the procedures related to Before Insert.
508 IF ( get_pk_for_validation( new_references.albw_id ) ) THEN
509 FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
510 IGS_GE_MSG_STACK.ADD;
511 APP_EXCEPTION.RAISE_EXCEPTION;
512 END IF;
513 check_parent_existance;
514 ELSIF (p_action = 'UPDATE') THEN
515 -- Call all the procedures related to Before Update.
516 check_parent_existance;
517 ELSIF (p_action = 'VALIDATE_INSERT') THEN
518 -- Call all the procedures related to Before Insert.
519 IF ( get_pk_for_validation ( new_references.albw_id ) ) THEN
520 FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
521 IGS_GE_MSG_STACK.ADD;
522 APP_EXCEPTION.RAISE_EXCEPTION;
523 END IF;
524 END IF;
525
526 END before_dml;
527
528
529 PROCEDURE insert_row (
530 x_rowid IN OUT NOCOPY VARCHAR2,
531 x_albw_id IN OUT NOCOPY NUMBER,
532 x_loan_id IN NUMBER,
533 x_fed_stafford_loan_debt IN NUMBER,
534 x_fed_sls_debt IN NUMBER,
535 x_heal_debt IN NUMBER,
536 x_perkins_debt IN NUMBER,
537 x_other_debt IN NUMBER,
538 x_crdt_undr_difft_name IN VARCHAR2,
539 x_borw_gross_annual_sal IN NUMBER,
540 x_borw_other_income IN NUMBER,
541 x_student_major IN VARCHAR2,
542 x_int_rate_opt IN VARCHAR2,
543 x_repayment_opt_code IN VARCHAR2,
544 x_stud_mth_housing_pymt IN NUMBER,
545 x_stud_mth_crdtcard_pymt IN NUMBER,
546 x_stud_mth_auto_pymt IN NUMBER,
547 x_stud_mth_ed_loan_pymt IN NUMBER,
548 x_stud_mth_other_pymt IN NUMBER,
549 x_mode IN VARCHAR2,
550 x_other_loan_amt IN NUMBER,
551 x_cs1_lname IN VARCHAR2,
552 x_cs1_fname IN VARCHAR2,
553 x_cs1_mi_txt IN VARCHAR2,
554 x_cs1_ssn_txt IN VARCHAR2,
555 x_cs1_citizenship_status IN VARCHAR2,
556 x_cs1_address_line_1_txt IN VARCHAR2,
557 x_cs1_address_line_2_txt IN VARCHAR2,
558 x_cs1_city_txt IN VARCHAR2,
559 x_cs1_state_txt IN VARCHAR2,
560 x_cs1_zip_txt IN VARCHAR2,
561 x_cs1_zip_suffix_txt IN VARCHAR2,
562 x_cs1_telephone_number_txt IN VARCHAR2,
563 x_cs1_signature_code_txt IN VARCHAR2,
564 x_cs2_lname IN VARCHAR2,
565 x_cs2_fname IN VARCHAR2,
566 x_cs2_mi_txt IN VARCHAR2,
567 x_cs2_ssn_txt IN VARCHAR2,
568 x_cs2_citizenship_status IN VARCHAR2,
569 x_cs2_address_line_1_txt IN VARCHAR2,
570 x_cs2_address_line_2_txt IN VARCHAR2,
571 x_cs2_city_txt IN VARCHAR2,
572 x_cs2_state_txt IN VARCHAR2,
573 x_cs2_zip_txt IN VARCHAR2,
574 x_cs2_zip_suffix_txt IN VARCHAR2,
575 x_cs2_telephone_number_txt IN VARCHAR2,
576 x_cs2_signature_code_txt IN VARCHAR2,
577 x_cs1_credit_auth_code_txt IN VARCHAR2,
578 x_cs1_birth_date IN Date ,
579 x_cs1_drv_license_num_txt IN VARCHAR2,
580 x_cs1_drv_license_state_txt IN VARCHAR2,
581 x_cs1_elect_sig_ind_code_txt IN VARCHAR2,
582 x_cs1_frgn_postal_code_txt IN VARCHAR2,
583 x_cs1_frgn_tel_num_prefix_txt IN VARCHAR2,
584 x_cs1_gross_annual_sal_num IN NUMBER ,
585 x_cs1_mthl_auto_pay_txt IN VARCHAR2,
586 x_cs1_mthl_cc_pay_txt IN VARCHAR2,
587 x_cs1_mthl_edu_loan_pay_txt IN VARCHAR2,
588 x_cs1_mthl_housing_pay_txt IN VARCHAR2,
589 x_cs1_mthl_other_pay_txt IN VARCHAR2,
590 x_cs1_other_income_amt IN NUMBER ,
591 x_cs1_rel_to_student_flag IN VARCHAR2,
592 x_cs1_suffix_txt IN VARCHAR2,
593 x_cs1_years_at_address_txt IN NUMBER ,
594 x_cs2_credit_auth_code_txt IN VARCHAR2,
595 x_cs2_birth_date IN Date ,
596 x_cs2_drv_license_num_txt IN VARCHAR2,
597 x_cs2_drv_license_state_txt IN VARCHAR2,
598 x_cs2_elect_sig_ind_code_txt IN VARCHAR2,
599 x_cs2_frgn_postal_code_txt IN VARCHAR2,
600 x_cs2_frgn_tel_num_prefix_txt IN VARCHAR2,
601 x_cs2_gross_annual_sal_num IN NUMBER ,
602 x_cs2_mthl_auto_pay_txt IN VARCHAR2,
603 x_cs2_mthl_cc_pay_txt IN VARCHAR2,
604 x_cs2_mthl_edu_loan_pay_txt IN VARCHAR2,
605 x_cs2_mthl_housing_pay_txt IN VARCHAR2,
606 x_cs2_mthl_other_pay_txt IN VARCHAR2,
607 x_cs2_other_income_amt IN NUMBER ,
608 x_cs2_rel_to_student_flag IN VARCHAR2,
609 x_cs2_suffix_txt IN VARCHAR2,
610 x_cs2_years_at_address_txt IN NUMBER
611 ) AS
612 /*
613 || Created By : viramali
614 || Created On : 10-MAY-2001
615 || Purpose : Handles the INSERT DML logic for the table.
616 || Known limitations, enhancements or remarks :
617 || Change History :
618 || Who When What
619 || (reverse chronological order - newest change first)
620 */
621 CURSOR c IS
622 SELECT rowid
623 FROM igf_sl_alt_borw_all
624 WHERE albw_id = x_albw_id;
625
626 x_last_update_date DATE;
627 x_last_updated_by NUMBER;
628 x_last_update_login NUMBER;
629 x_request_id NUMBER;
630 x_program_id NUMBER;
631 x_program_application_id NUMBER;
632 x_program_update_date DATE;
633
634 BEGIN
635
636 x_last_update_date := SYSDATE;
637 IF (x_mode = 'I') THEN
638 x_last_updated_by := 1;
639 x_last_update_login := 0;
640 ELSIF (x_mode = 'R') THEN
641 x_last_updated_by := fnd_global.user_id;
642 IF (x_last_updated_by IS NULL) THEN
643 x_last_updated_by := -1;
644 END IF;
645 x_last_update_login := fnd_global.login_id;
646 IF (x_last_update_login IS NULL) THEN
647 x_last_update_login := -1;
648 END IF;
649 x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
650 x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
651 x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
652
653 IF (x_request_id = -1) THEN
654 x_request_id := NULL;
655 x_program_id := NULL;
656 x_program_application_id := NULL;
657 x_program_update_date := NULL;
658 ELSE
659 x_program_update_date := SYSDATE;
660 END IF;
661 ELSE
662 FND_MESSAGE.SET_NAME ('FND', 'SYSTEM-INVALID ARGS');
663 IGS_GE_MSG_STACK.ADD;
664 APP_EXCEPTION.RAISE_EXCEPTION;
665 END IF;
666
667 SELECT igf_sl_alt_borw_all_s.NEXTVAL
668 INTO x_albw_id
669 FROM dual;
670
671 new_references.org_id := igs_ge_gen_003.get_org_id;
672
673 before_dml(
674 p_action => 'INSERT',
675 x_rowid => x_rowid,
676 x_albw_id => x_albw_id,
677 x_loan_id => x_loan_id,
678 x_fed_stafford_loan_debt => x_fed_stafford_loan_debt,
679 x_fed_sls_debt => x_fed_sls_debt,
680 x_heal_debt => x_heal_debt,
681 x_perkins_debt => x_perkins_debt,
682 x_other_debt => x_other_debt,
683 x_crdt_undr_difft_name => x_crdt_undr_difft_name,
684 x_borw_gross_annual_sal => x_borw_gross_annual_sal,
685 x_borw_other_income => x_borw_other_income,
686 x_student_major => x_student_major,
687 x_int_rate_opt => x_int_rate_opt,
688 x_repayment_opt_code => x_repayment_opt_code,
689 x_stud_mth_housing_pymt => x_stud_mth_housing_pymt,
690 x_stud_mth_crdtcard_pymt => x_stud_mth_crdtcard_pymt,
691 x_stud_mth_auto_pymt => x_stud_mth_auto_pymt,
692 x_stud_mth_ed_loan_pymt => x_stud_mth_ed_loan_pymt,
693 x_stud_mth_other_pymt => x_stud_mth_other_pymt,
694 x_creation_date => x_last_update_date,
695 x_created_by => x_last_updated_by,
696 x_last_update_date => x_last_update_date,
697 x_last_updated_by => x_last_updated_by,
698 x_last_update_login => x_last_update_login,
699 x_other_loan_amt => x_other_loan_amt,
700 x_cs1_lname => x_cs1_lname ,
701 x_cs1_fname => x_cs1_fname ,
702 x_cs1_mi_txt => x_cs1_mi_txt ,
703 x_cs1_ssn_txt => x_cs1_ssn_txt ,
704 x_cs1_citizenship_status => x_cs1_citizenship_status ,
705 x_cs1_address_line_1_txt => x_cs1_address_line_1_txt ,
706 x_cs1_address_line_2_txt => x_cs1_address_line_2_txt ,
707 x_cs1_city_txt => x_cs1_city_txt ,
708 x_cs1_state_txt => x_cs1_state_txt ,
709 x_cs1_zip_txt => x_cs1_zip_txt ,
710 x_cs1_zip_suffix_txt => x_cs1_zip_suffix_txt ,
711 x_cs1_telephone_number_txt => x_cs1_telephone_number_txt ,
712 x_cs1_signature_code_txt => x_cs1_signature_code_txt ,
713 x_cs2_lname => x_cs2_lname ,
714 x_cs2_fname => x_cs2_fname ,
715 x_cs2_mi_txt => x_cs2_mi_txt ,
716 x_cs2_ssn_txt => x_cs2_ssn_txt ,
717 x_cs2_citizenship_status => x_cs2_citizenship_status ,
718 x_cs2_address_line_1_txt => x_cs2_address_line_1_txt ,
719 x_cs2_address_line_2_txt => x_cs2_address_line_2_txt ,
720 x_cs2_city_txt => x_cs2_city_txt ,
721 x_cs2_state_txt => x_cs2_state_txt ,
722 x_cs2_zip_txt => x_cs2_zip_txt ,
723 x_cs2_zip_suffix_txt => x_cs2_zip_suffix_txt ,
724 x_cs2_telephone_number_txt => x_cs2_telephone_number_txt ,
725 x_cs2_signature_code_txt => x_cs2_signature_code_txt ,
726 x_cs1_credit_auth_code_txt => x_cs1_credit_auth_code_txt ,
727 x_cs1_birth_date => x_cs1_birth_date ,
728 x_cs1_drv_license_num_txt => x_cs1_drv_license_num_txt ,
729 x_cs1_drv_license_state_txt => x_cs1_drv_license_state_txt ,
730 x_cs1_elect_sig_ind_code_txt => x_cs1_elect_sig_ind_code_txt ,
731 x_cs1_frgn_postal_code_txt => x_cs1_frgn_postal_code_txt ,
732 x_cs1_frgn_tel_num_prefix_txt => x_cs1_frgn_tel_num_prefix_txt ,
733 x_cs1_gross_annual_sal_num => x_cs1_gross_annual_sal_num ,
734 x_cs1_mthl_auto_pay_txt => x_cs1_mthl_auto_pay_txt ,
735 x_cs1_mthl_cc_pay_txt => x_cs1_mthl_cc_pay_txt ,
736 x_cs1_mthl_edu_loan_pay_txt => x_cs1_mthl_edu_loan_pay_txt ,
737 x_cs1_mthl_housing_pay_txt => x_cs1_mthl_housing_pay_txt ,
738 x_cs1_mthl_other_pay_txt => x_cs1_mthl_other_pay_txt ,
739 x_cs1_other_income_amt => x_cs1_other_income_amt ,
740 x_cs1_rel_to_student_flag => x_cs1_rel_to_student_flag ,
741 x_cs1_suffix_txt => x_cs1_suffix_txt ,
742 x_cs1_years_at_address_txt => x_cs1_years_at_address_txt ,
743 x_cs2_credit_auth_code_txt => x_cs2_credit_auth_code_txt ,
744 x_cs2_birth_date => x_cs2_birth_date ,
745 x_cs2_drv_license_num_txt => x_cs2_drv_license_num_txt ,
746 x_cs2_drv_license_state_txt => x_cs2_drv_license_state_txt ,
747 x_cs2_elect_sig_ind_code_txt => x_cs2_elect_sig_ind_code_txt ,
748 x_cs2_frgn_postal_code_txt => x_cs2_frgn_postal_code_txt ,
749 x_cs2_frgn_tel_num_prefix_txt => x_cs2_frgn_tel_num_prefix_txt ,
750 x_cs2_gross_annual_sal_num => x_cs2_gross_annual_sal_num ,
751 x_cs2_mthl_auto_pay_txt => x_cs2_mthl_auto_pay_txt ,
752 x_cs2_mthl_cc_pay_txt => x_cs2_mthl_cc_pay_txt ,
753 x_cs2_mthl_edu_loan_pay_txt => x_cs2_mthl_edu_loan_pay_txt ,
754 x_cs2_mthl_housing_pay_txt => x_cs2_mthl_housing_pay_txt ,
755 x_cs2_mthl_other_pay_txt => x_cs2_mthl_other_pay_txt ,
756 x_cs2_other_income_amt => x_cs2_other_income_amt ,
757 x_cs2_rel_to_student_flag => x_cs2_rel_to_student_flag ,
758 x_cs2_suffix_txt => x_cs2_suffix_txt ,
759 x_cs2_years_at_address_txt => x_cs2_years_at_address_txt
760 );
761
762 INSERT INTO igf_sl_alt_borw_all (
763 albw_id,
764 loan_id,
765 fed_stafford_loan_debt,
766 fed_sls_debt,
767 heal_debt,
768 perkins_debt,
769 other_debt,
770 crdt_undr_difft_name,
771 borw_gross_annual_sal,
772 borw_other_income,
773 student_major,
774 int_rate_opt,
775 repayment_opt_code,
776 stud_mth_housing_pymt,
777 stud_mth_crdtcard_pymt,
778 stud_mth_auto_pymt,
779 stud_mth_ed_loan_pymt,
780 stud_mth_other_pymt,
781 org_id,
782 creation_date,
783 created_by,
784 last_update_date,
785 last_updated_by,
786 last_update_login,
787 request_id,
788 program_id,
789 program_application_id,
790 program_update_date,
791 other_loan_amt,
792 cs1_lname,
793 cs1_fname,
794 cs1_mi_txt,
795 cs1_ssn_txt,
796 cs1_citizenship_status,
797 cs1_address_line_1_txt,
798 cs1_address_line_2_txt,
799 cs1_city_txt,
800 cs1_state_txt,
801 cs1_zip_txt,
802 cs1_zip_suffix_txt,
803 cs1_telephone_number_txt,
804 cs1_signature_code_txt,
805 cs2_lname,
806 cs2_fname,
807 cs2_mi_txt,
808 cs2_ssn_txt,
809 cs2_citizenship_status,
810 cs2_address_line_1_txt,
811 cs2_address_line_2_txt,
812 cs2_city_txt,
813 cs2_state_txt,
814 cs2_zip_txt,
815 cs2_zip_suffix_txt,
816 cs2_telephone_number_txt,
817 cs2_signature_code_txt,
818 cs1_credit_auth_code_txt,
819 cs1_birth_date,
820 cs1_drv_license_num_txt,
821 cs1_drv_license_state_txt,
822 cs1_elect_sig_ind_code_txt,
823 cs1_frgn_postal_code_txt,
824 cs1_frgn_tel_num_prefix_txt,
825 cs1_gross_annual_sal_num,
826 cs1_mthl_auto_pay_txt,
827 cs1_mthl_cc_pay_txt,
828 cs1_mthl_edu_loan_pay_txt,
829 cs1_mthl_housing_pay_txt,
830 cs1_mthl_other_pay_txt,
831 cs1_other_income_amt,
832 cs1_rel_to_student_flag,
833 cs1_suffix_txt,
834 cs1_years_at_address_txt,
835 cs2_credit_auth_code_txt,
836 cs2_birth_date,
837 cs2_drv_license_num_txt,
838 cs2_drv_license_state_txt,
839 cs2_elect_sig_ind_code_txt,
840 cs2_frgn_postal_code_txt,
841 cs2_frgn_tel_num_prefix_txt,
842 cs2_gross_annual_sal_num,
843 cs2_mthl_auto_pay_txt,
844 cs2_mthl_cc_pay_txt,
845 cs2_mthl_edu_loan_pay_txt,
846 cs2_mthl_housing_pay_txt,
847 cs2_mthl_other_pay_txt,
848 cs2_other_income_amt,
849 cs2_rel_to_student_flag,
850 cs2_suffix_txt,
851 cs2_years_at_address_txt
852 ) VALUES (
853 new_references.albw_id,
854 new_references.loan_id,
855 new_references.fed_stafford_loan_debt,
856 new_references.fed_sls_debt,
857 new_references.heal_debt,
858 new_references.perkins_debt,
859 new_references.other_debt,
860 new_references.crdt_undr_difft_name,
861 new_references.borw_gross_annual_sal,
862 new_references.borw_other_income,
863 new_references.student_major,
864 new_references.int_rate_opt,
865 new_references.repayment_opt_code,
866 new_references.stud_mth_housing_pymt,
867 new_references.stud_mth_crdtcard_pymt,
868 new_references.stud_mth_auto_pymt,
869 new_references.stud_mth_ed_loan_pymt,
870 new_references.stud_mth_other_pymt,
871 new_references.org_id,
872 x_last_update_date,
873 x_last_updated_by,
874 x_last_update_date,
875 x_last_updated_by,
876 x_last_update_login ,
877 x_request_id,
878 x_program_id,
879 x_program_application_id,
880 x_program_update_date,
881 new_references.other_loan_amt,
882 new_references.cs1_lname,
883 new_references.cs1_fname,
884 new_references.cs1_mi_txt,
885 new_references.cs1_ssn_txt,
886 new_references.cs1_citizenship_status,
887 new_references.cs1_address_line_1_txt,
888 new_references.cs1_address_line_2_txt,
889 new_references.cs1_city_txt,
890 new_references.cs1_state_txt,
891 new_references.cs1_zip_txt,
892 new_references.cs1_zip_suffix_txt,
893 new_references.cs1_telephone_number_txt,
894 new_references.cs1_signature_code_txt,
895 new_references.cs2_lname,
896 new_references.cs2_fname,
897 new_references.cs2_mi_txt,
898 new_references.cs2_ssn_txt,
899 new_references.cs2_citizenship_status,
900 new_references.cs2_address_line_1_txt,
901 new_references.cs2_address_line_2_txt,
902 new_references.cs2_city_txt,
903 new_references.cs2_state_txt,
904 new_references.cs2_zip_txt,
905 new_references.cs2_zip_suffix_txt,
906 new_references.cs2_telephone_number_txt,
907 new_references.cs2_signature_code_txt,
908 new_references.cs1_credit_auth_code_txt,
909 new_references.cs1_birth_date,
910 new_references.cs1_drv_license_num_txt,
911 new_references.cs1_drv_license_state_txt,
912 new_references.cs1_elect_sig_ind_code_txt,
913 new_references.cs1_frgn_postal_code_txt,
914 new_references.cs1_frgn_tel_num_prefix_txt,
915 new_references.cs1_gross_annual_sal_num,
916 new_references.cs1_mthl_auto_pay_txt,
917 new_references.cs1_mthl_cc_pay_txt,
918 new_references.cs1_mthl_edu_loan_pay_txt,
919 new_references.cs1_mthl_housing_pay_txt,
920 new_references.cs1_mthl_other_pay_txt,
921 new_references.cs1_other_income_amt,
922 new_references.cs1_rel_to_student_flag,
923 new_references.cs1_suffix_txt,
924 new_references.cs1_years_at_address_txt,
925 new_references.cs2_credit_auth_code_txt,
926 new_references.cs2_birth_date,
927 new_references.cs2_drv_license_num_txt,
928 new_references.cs2_drv_license_state_txt,
929 new_references.cs2_elect_sig_ind_code_txt,
930 new_references.cs2_frgn_postal_code_txt,
931 new_references.cs2_frgn_tel_num_prefix_txt,
932 new_references.cs2_gross_annual_sal_num,
933 new_references.cs2_mthl_auto_pay_txt,
934 new_references.cs2_mthl_cc_pay_txt,
935 new_references.cs2_mthl_edu_loan_pay_txt,
936 new_references.cs2_mthl_housing_pay_txt,
937 new_references.cs2_mthl_other_pay_txt,
938 new_references.cs2_other_income_amt,
939 new_references.cs2_rel_to_student_flag,
940 new_references.cs2_suffix_txt,
941 new_references.cs2_years_at_address_txt
942 );
943
944 OPEN c;
945 FETCH c INTO x_rowid;
946 IF (c%NOTFOUND) THEN
947 CLOSE c;
948 RAISE NO_DATA_FOUND;
949 END IF;
950 CLOSE c;
951
952 END insert_row;
953
954
955 PROCEDURE lock_row (
956 x_rowid IN VARCHAR2,
957 x_albw_id IN NUMBER,
958 x_loan_id IN NUMBER,
959 x_fed_stafford_loan_debt IN NUMBER,
960 x_fed_sls_debt IN NUMBER,
961 x_heal_debt IN NUMBER,
962 x_perkins_debt IN NUMBER,
963 x_other_debt IN NUMBER,
964 x_crdt_undr_difft_name IN VARCHAR2,
965 x_borw_gross_annual_sal IN NUMBER,
966 x_borw_other_income IN NUMBER,
967 x_student_major IN VARCHAR2,
968 x_int_rate_opt IN VARCHAR2,
969 x_repayment_opt_code IN VARCHAR2,
970 x_stud_mth_housing_pymt IN NUMBER,
971 x_stud_mth_crdtcard_pymt IN NUMBER,
972 x_stud_mth_auto_pymt IN NUMBER,
973 x_stud_mth_ed_loan_pymt IN NUMBER,
974 x_stud_mth_other_pymt IN NUMBER,
975 x_other_loan_amt IN NUMBER,
976 x_cs1_lname IN VARCHAR2,
977 x_cs1_fname IN VARCHAR2,
978 x_cs1_mi_txt IN VARCHAR2,
979 x_cs1_ssn_txt IN VARCHAR2,
980 x_cs1_citizenship_status IN VARCHAR2,
981 x_cs1_address_line_1_txt IN VARCHAR2,
982 x_cs1_address_line_2_txt IN VARCHAR2,
983 x_cs1_city_txt IN VARCHAR2,
984 x_cs1_state_txt IN VARCHAR2,
985 x_cs1_zip_txt IN VARCHAR2,
986 x_cs1_zip_suffix_txt IN VARCHAR2,
987 x_cs1_telephone_number_txt IN VARCHAR2,
988 x_cs1_signature_code_txt IN VARCHAR2,
989 x_cs2_lname IN VARCHAR2,
990 x_cs2_fname IN VARCHAR2,
991 x_cs2_mi_txt IN VARCHAR2,
992 x_cs2_ssn_txt IN VARCHAR2,
993 x_cs2_citizenship_status IN VARCHAR2,
994 x_cs2_address_line_1_txt IN VARCHAR2,
995 x_cs2_address_line_2_txt IN VARCHAR2,
996 x_cs2_city_txt IN VARCHAR2,
997 x_cs2_state_txt IN VARCHAR2,
998 x_cs2_zip_txt IN VARCHAR2,
999 x_cs2_zip_suffix_txt IN VARCHAR2,
1000 x_cs2_telephone_number_txt IN VARCHAR2,
1001 x_cs2_signature_code_txt IN VARCHAR2,
1002 x_cs1_credit_auth_code_txt IN VARCHAR2,
1003 x_cs1_birth_date IN Date ,
1004 x_cs1_drv_license_num_txt IN VARCHAR2,
1005 x_cs1_drv_license_state_txt IN VARCHAR2,
1006 x_cs1_elect_sig_ind_code_txt IN VARCHAR2,
1007 x_cs1_frgn_postal_code_txt IN VARCHAR2,
1008 x_cs1_frgn_tel_num_prefix_txt IN VARCHAR2,
1009 x_cs1_gross_annual_sal_num IN NUMBER ,
1010 x_cs1_mthl_auto_pay_txt IN VARCHAR2,
1011 x_cs1_mthl_cc_pay_txt IN VARCHAR2,
1012 x_cs1_mthl_edu_loan_pay_txt IN VARCHAR2,
1013 x_cs1_mthl_housing_pay_txt IN VARCHAR2,
1014 x_cs1_mthl_other_pay_txt IN VARCHAR2,
1015 x_cs1_other_income_amt IN NUMBER ,
1016 x_cs1_rel_to_student_flag IN VARCHAR2,
1017 x_cs1_suffix_txt IN VARCHAR2,
1018 x_cs1_years_at_address_txt IN NUMBER ,
1019 x_cs2_credit_auth_code_txt IN VARCHAR2,
1020 x_cs2_birth_date IN Date ,
1021 x_cs2_drv_license_num_txt IN VARCHAR2,
1022 x_cs2_drv_license_state_txt IN VARCHAR2,
1023 x_cs2_elect_sig_ind_code_txt IN VARCHAR2,
1024 x_cs2_frgn_postal_code_txt IN VARCHAR2,
1025 x_cs2_frgn_tel_num_prefix_txt IN VARCHAR2,
1026 x_cs2_gross_annual_sal_num IN NUMBER ,
1027 x_cs2_mthl_auto_pay_txt IN VARCHAR2,
1028 x_cs2_mthl_cc_pay_txt IN VARCHAR2,
1029 x_cs2_mthl_edu_loan_pay_txt IN VARCHAR2,
1030 x_cs2_mthl_housing_pay_txt IN VARCHAR2,
1031 x_cs2_mthl_other_pay_txt IN VARCHAR2,
1032 x_cs2_other_income_amt IN NUMBER ,
1033 x_cs2_rel_to_student_flag IN VARCHAR2,
1034 x_cs2_suffix_txt IN VARCHAR2,
1035 x_cs2_years_at_address_txt IN NUMBER
1036 ) AS
1037 /*
1038 || Created By : viramali
1039 || Created On : 10-MAY-2001
1040 || Purpose : Handles the LOCK mechanism for the table.
1041 || Known limitations, enhancements or remarks :
1042 || Change History :
1043 || Who When What
1044 || (reverse chronological order - newest change first)
1045 */
1046 CURSOR c1 IS
1047 SELECT
1048 loan_id,
1049 fed_stafford_loan_debt,
1050 fed_sls_debt,
1051 heal_debt,
1052 perkins_debt,
1053 other_debt,
1054 crdt_undr_difft_name,
1055 borw_gross_annual_sal,
1056 borw_other_income,
1057 student_major,
1058 int_rate_opt,
1059 repayment_opt_code,
1060 stud_mth_housing_pymt,
1061 stud_mth_crdtcard_pymt,
1062 stud_mth_auto_pymt,
1063 stud_mth_ed_loan_pymt,
1064 stud_mth_other_pymt,
1065 other_loan_amt,
1066 cs1_lname,
1067 cs1_fname,
1068 cs1_mi_txt,
1069 cs1_ssn_txt,
1070 cs1_citizenship_status,
1071 cs1_address_line_1_txt,
1072 cs1_address_line_2_txt,
1073 cs1_city_txt,
1074 cs1_state_txt,
1075 cs1_zip_txt,
1076 cs1_zip_suffix_txt,
1077 cs1_telephone_number_txt,
1078 cs1_signature_code_txt,
1079 cs2_lname,
1080 cs2_fname,
1081 cs2_mi_txt,
1082 cs2_ssn_txt,
1083 cs2_citizenship_status,
1084 cs2_address_line_1_txt,
1085 cs2_address_line_2_txt,
1086 cs2_city_txt,
1087 cs2_state_txt,
1088 cs2_zip_txt,
1089 cs2_zip_suffix_txt,
1090 cs2_telephone_number_txt,
1091 cs2_signature_code_txt,
1092 cs1_credit_auth_code_txt,
1093 cs1_birth_date,
1094 cs1_drv_license_num_txt,
1095 cs1_drv_license_state_txt,
1096 cs1_elect_sig_ind_code_txt,
1097 cs1_frgn_postal_code_txt,
1098 cs1_frgn_tel_num_prefix_txt,
1099 cs1_gross_annual_sal_num,
1100 cs1_mthl_auto_pay_txt,
1101 cs1_mthl_cc_pay_txt,
1102 cs1_mthl_edu_loan_pay_txt,
1103 cs1_mthl_housing_pay_txt,
1104 cs1_mthl_other_pay_txt,
1105 cs1_other_income_amt,
1106 cs1_rel_to_student_flag,
1107 cs1_suffix_txt,
1108 cs1_years_at_address_txt,
1109 cs2_credit_auth_code_txt,
1110 cs2_birth_date,
1111 cs2_drv_license_num_txt,
1112 cs2_drv_license_state_txt,
1113 cs2_elect_sig_ind_code_txt,
1114 cs2_frgn_postal_code_txt,
1115 cs2_frgn_tel_num_prefix_txt,
1116 cs2_gross_annual_sal_num,
1117 cs2_mthl_auto_pay_txt,
1118 cs2_mthl_cc_pay_txt,
1119 cs2_mthl_edu_loan_pay_txt,
1120 cs2_mthl_housing_pay_txt,
1121 cs2_mthl_other_pay_txt,
1122 cs2_other_income_amt,
1123 cs2_rel_to_student_flag,
1124 cs2_suffix_txt,
1125 cs2_years_at_address_txt
1126 FROM igf_sl_alt_borw_all
1127 WHERE rowid = x_rowid
1128 FOR UPDATE NOWAIT;
1129
1130 tlinfo c1%ROWTYPE;
1131
1132 BEGIN
1133
1134 OPEN c1;
1135 FETCH c1 INTO tlinfo;
1136 IF (c1%notfound) THEN
1137 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1138 IGS_GE_MSG_STACK.ADD;
1139 CLOSE c1;
1140 APP_EXCEPTION.RAISE_EXCEPTION;
1141 RETURN;
1142 END IF;
1143 CLOSE c1;
1144
1145 IF (
1146 (tlinfo.loan_id = x_loan_id)
1147 AND ((tlinfo.fed_stafford_loan_debt = x_fed_stafford_loan_debt) OR ((tlinfo.fed_stafford_loan_debt IS NULL) AND (X_fed_stafford_loan_debt IS NULL)))
1148 AND ((tlinfo.fed_sls_debt = x_fed_sls_debt) OR ((tlinfo.fed_sls_debt IS NULL) AND (X_fed_sls_debt IS NULL)))
1149 AND ((tlinfo.heal_debt = x_heal_debt) OR ((tlinfo.heal_debt IS NULL) AND (X_heal_debt IS NULL)))
1150 AND ((tlinfo.perkins_debt = x_perkins_debt) OR ((tlinfo.perkins_debt IS NULL) AND (X_perkins_debt IS NULL)))
1151 AND ((tlinfo.other_debt = x_other_debt) OR ((tlinfo.other_debt IS NULL) AND (X_other_debt IS NULL)))
1152 AND ((tlinfo.crdt_undr_difft_name = x_crdt_undr_difft_name) OR ((tlinfo.crdt_undr_difft_name IS NULL) AND (X_crdt_undr_difft_name IS NULL)))
1153 AND ((tlinfo.borw_gross_annual_sal = x_borw_gross_annual_sal) OR ((tlinfo.borw_gross_annual_sal IS NULL) AND (X_borw_gross_annual_sal IS NULL)))
1154 AND ((tlinfo.borw_other_income = x_borw_other_income) OR ((tlinfo.borw_other_income IS NULL) AND (X_borw_other_income IS NULL)))
1155 AND ((tlinfo.student_major = x_student_major) OR ((tlinfo.student_major IS NULL) AND (X_student_major IS NULL)))
1156 AND ((tlinfo.int_rate_opt = x_int_rate_opt) OR ((tlinfo.int_rate_opt IS NULL) AND (X_int_rate_opt IS NULL)))
1157 AND ((tlinfo.repayment_opt_code = x_repayment_opt_code) OR ((tlinfo.repayment_opt_code IS NULL) AND (X_repayment_opt_code IS NULL)))
1158 AND ((tlinfo.stud_mth_housing_pymt = x_stud_mth_housing_pymt) OR ((tlinfo.stud_mth_housing_pymt IS NULL) AND (X_stud_mth_housing_pymt IS NULL)))
1159 AND ((tlinfo.stud_mth_crdtcard_pymt = x_stud_mth_crdtcard_pymt) OR ((tlinfo.stud_mth_crdtcard_pymt IS NULL) AND (X_stud_mth_crdtcard_pymt IS NULL)))
1160 AND ((tlinfo.stud_mth_auto_pymt = x_stud_mth_auto_pymt) OR ((tlinfo.stud_mth_auto_pymt IS NULL) AND (X_stud_mth_auto_pymt IS NULL)))
1161 AND ((tlinfo.stud_mth_ed_loan_pymt = x_stud_mth_ed_loan_pymt) OR ((tlinfo.stud_mth_ed_loan_pymt IS NULL) AND (X_stud_mth_ed_loan_pymt IS NULL)))
1162 AND ((tlinfo.stud_mth_other_pymt = x_stud_mth_other_pymt) OR ((tlinfo.stud_mth_other_pymt IS NULL) AND (X_stud_mth_other_pymt IS NULL)))
1163 AND ((tlinfo.other_loan_amt = x_other_loan_amt) OR ((tlinfo.other_loan_amt IS NULL) AND (x_other_loan_amt IS NULL)))
1164 AND ((tlinfo.cs1_lname = x_cs1_lname) OR ((tlinfo.cs1_lname IS NULL) AND (x_cs1_lname IS NULL)))
1165 AND ((tlinfo.cs1_fname = x_cs1_fname) OR ((tlinfo.cs1_fname IS NULL) AND (x_cs1_fname IS NULL)))
1166 AND ((tlinfo.cs1_mi_txt = x_cs1_mi_txt) OR ((tlinfo.cs1_mi_txt IS NULL) AND (x_cs1_mi_txt IS NULL)))
1167 AND ((tlinfo.cs1_ssn_txt = x_cs1_ssn_txt) OR ((tlinfo.cs1_ssn_txt IS NULL) AND (x_cs1_ssn_txt IS NULL)))
1168 AND ((tlinfo.cs1_citizenship_status = x_cs1_citizenship_status) OR ((tlinfo.cs1_citizenship_status IS NULL) AND (x_cs1_citizenship_status IS NULL)))
1169 AND ((tlinfo.cs1_address_line_1_txt = x_cs1_address_line_1_txt) OR ((tlinfo.cs1_address_line_1_txt IS NULL) AND (x_cs1_address_line_1_txt IS NULL)))
1170 AND ((tlinfo.cs1_address_line_2_txt = x_cs1_address_line_2_txt) OR ((tlinfo.cs1_address_line_2_txt IS NULL) AND (x_cs1_address_line_2_txt IS NULL)))
1171 AND ((tlinfo.cs1_city_txt = x_cs1_city_txt) OR ((tlinfo.cs1_city_txt IS NULL) AND (x_cs1_city_txt IS NULL)))
1172 AND ((tlinfo.cs1_state_txt = x_cs1_state_txt) OR ((tlinfo.cs1_state_txt IS NULL) AND (x_cs1_state_txt IS NULL)))
1173 AND ((tlinfo.cs1_zip_txt = x_cs1_zip_txt) OR ((tlinfo.cs1_zip_txt IS NULL) AND (x_cs1_zip_txt IS NULL)))
1174 AND ((tlinfo.cs1_zip_suffix_txt = x_cs1_zip_suffix_txt) OR ((tlinfo.cs1_zip_suffix_txt IS NULL) AND (x_cs1_zip_suffix_txt IS NULL)))
1175 AND ((tlinfo.cs1_telephone_number_txt = x_cs1_telephone_number_txt) OR ((tlinfo.cs1_telephone_number_txt IS NULL) AND (x_cs1_telephone_number_txt IS NULL)))
1176 AND ((tlinfo.cs1_signature_code_txt = x_cs1_signature_code_txt) OR ((tlinfo.cs1_signature_code_txt IS NULL) AND (x_cs1_signature_code_txt IS NULL)))
1177 AND ((tlinfo.cs2_lname = x_cs2_lname) OR ((tlinfo.cs2_lname IS NULL) AND (x_cs2_lname IS NULL)))
1178 AND ((tlinfo.cs2_fname = x_cs2_fname) OR ((tlinfo.cs2_fname IS NULL) AND (x_cs2_fname IS NULL)))
1179 AND ((tlinfo.cs2_mi_txt = x_cs2_mi_txt) OR ((tlinfo.cs2_mi_txt IS NULL) AND (x_cs2_mi_txt IS NULL)))
1180 AND ((tlinfo.cs2_ssn_txt = x_cs2_ssn_txt) OR ((tlinfo.cs2_ssn_txt IS NULL) AND (x_cs2_ssn_txt IS NULL)))
1181 AND ((tlinfo.cs2_citizenship_status = x_cs2_citizenship_status) OR ((tlinfo.cs2_citizenship_status IS NULL) AND (x_cs2_citizenship_status IS NULL)))
1182 AND ((tlinfo.cs2_address_line_1_txt = x_cs2_address_line_1_txt) OR ((tlinfo.cs2_address_line_1_txt IS NULL) AND (x_cs2_address_line_1_txt IS NULL)))
1183 AND ((tlinfo.cs2_address_line_2_txt = x_cs2_address_line_2_txt) OR ((tlinfo.cs2_address_line_2_txt IS NULL) AND (x_cs2_address_line_2_txt IS NULL)))
1184 AND ((tlinfo.cs2_city_txt = x_cs2_city_txt) OR ((tlinfo.cs2_city_txt IS NULL) AND (x_cs2_city_txt IS NULL)))
1185 AND ((tlinfo.cs2_state_txt = x_cs2_state_txt) OR ((tlinfo.cs2_state_txt IS NULL) AND (x_cs2_state_txt IS NULL)))
1186 AND ((tlinfo.cs2_zip_txt = x_cs2_zip_txt) OR ((tlinfo.cs2_zip_txt IS NULL) AND (x_cs2_zip_txt IS NULL)))
1187 AND ((tlinfo.cs2_zip_suffix_txt = x_cs2_zip_suffix_txt) OR ((tlinfo.cs2_zip_suffix_txt IS NULL) AND (x_cs2_zip_suffix_txt IS NULL)))
1188 AND ((tlinfo.cs2_telephone_number_txt = x_cs2_telephone_number_txt) OR ((tlinfo.cs2_telephone_number_txt IS NULL) AND (x_cs2_telephone_number_txt IS NULL)))
1189 AND ((tlinfo.cs2_signature_code_txt = x_cs2_signature_code_txt) OR ((tlinfo.cs2_signature_code_txt IS NULL) AND (x_cs2_signature_code_txt IS NULL)))
1190 AND ((tlinfo.cs1_credit_auth_code_txt = x_cs1_credit_auth_code_txt) OR ((tlinfo.cs1_credit_auth_code_txt IS NULL) AND (x_cs1_credit_auth_code_txt IS NULL)))
1191 AND ((tlinfo.cs1_birth_date = x_cs1_birth_date) OR ((tlinfo.cs1_birth_date IS NULL) AND (x_cs1_birth_date IS NULL)))
1192 AND ((tlinfo.cs1_drv_license_num_txt = x_cs1_drv_license_num_txt) OR ((tlinfo.cs1_drv_license_num_txt IS NULL) AND (x_cs1_drv_license_num_txt IS NULL)))
1193 AND ((tlinfo.cs1_drv_license_state_txt = x_cs1_drv_license_state_txt) OR ((tlinfo.cs1_drv_license_state_txt IS NULL) AND (x_cs1_drv_license_state_txt IS NULL)))
1194 AND ((tlinfo.cs1_elect_sig_ind_code_txt = x_cs1_elect_sig_ind_code_txt) OR ((tlinfo.cs1_elect_sig_ind_code_txt IS NULL) AND (x_cs1_elect_sig_ind_code_txt IS NULL)))
1195 AND ((tlinfo.cs1_frgn_postal_code_txt = x_cs1_frgn_postal_code_txt) OR ((tlinfo.cs1_frgn_postal_code_txt IS NULL) AND (x_cs1_frgn_postal_code_txt IS NULL)))
1196 AND ((tlinfo.cs1_frgn_tel_num_prefix_txt = x_cs1_frgn_tel_num_prefix_txt) OR ((tlinfo.cs1_frgn_tel_num_prefix_txt IS NULL) AND (x_cs1_frgn_tel_num_prefix_txt IS NULL)))
1197 AND ((tlinfo.cs1_gross_annual_sal_num = x_cs1_gross_annual_sal_num) OR ((tlinfo.cs1_gross_annual_sal_num IS NULL) AND (x_cs1_gross_annual_sal_num IS NULL)))
1198 AND ((tlinfo.cs1_mthl_auto_pay_txt = x_cs1_mthl_auto_pay_txt) OR ((tlinfo.cs1_mthl_auto_pay_txt IS NULL) AND (x_cs1_mthl_auto_pay_txt IS NULL)))
1199 AND ((tlinfo.cs1_mthl_cc_pay_txt = x_cs1_mthl_cc_pay_txt) OR ((tlinfo.cs1_mthl_cc_pay_txt IS NULL) AND (x_cs1_mthl_cc_pay_txt IS NULL)))
1200 AND ((tlinfo.cs1_mthl_edu_loan_pay_txt = x_cs1_mthl_edu_loan_pay_txt) OR ((tlinfo.cs1_mthl_edu_loan_pay_txt IS NULL) AND (x_cs1_mthl_edu_loan_pay_txt IS NULL)))
1201 AND ((tlinfo.cs1_mthl_housing_pay_txt = x_cs1_mthl_housing_pay_txt) OR ((tlinfo.cs1_mthl_housing_pay_txt IS NULL) AND (x_cs1_mthl_housing_pay_txt IS NULL)))
1202 AND ((tlinfo.cs1_mthl_other_pay_txt = x_cs1_mthl_other_pay_txt) OR ((tlinfo.cs1_mthl_other_pay_txt IS NULL) AND (x_cs1_mthl_other_pay_txt IS NULL)))
1203 AND ((tlinfo.cs1_other_income_amt = x_cs1_other_income_amt) OR ((tlinfo.cs1_other_income_amt IS NULL) AND (x_cs1_other_income_amt IS NULL)))
1204 AND ((tlinfo.cs1_rel_to_student_flag = x_cs1_rel_to_student_flag) OR ((tlinfo.cs1_rel_to_student_flag IS NULL) AND (x_cs1_rel_to_student_flag IS NULL)))
1205 AND ((tlinfo.cs1_suffix_txt = x_cs1_suffix_txt) OR ((tlinfo.cs1_suffix_txt IS NULL) AND (x_cs1_suffix_txt IS NULL)))
1206 AND ((tlinfo.cs1_years_at_address_txt = x_cs1_years_at_address_txt) OR ((tlinfo.cs1_years_at_address_txt IS NULL) AND (x_cs1_years_at_address_txt IS NULL)))
1207 AND ((tlinfo.cs2_credit_auth_code_txt = x_cs2_credit_auth_code_txt) OR ((tlinfo.cs2_credit_auth_code_txt IS NULL) AND (x_cs2_credit_auth_code_txt IS NULL)))
1208 AND ((tlinfo.cs2_birth_date = x_cs2_birth_date) OR ((tlinfo.cs2_birth_date IS NULL) AND (x_cs2_birth_date IS NULL)))
1209 AND ((tlinfo.cs2_drv_license_num_txt = x_cs2_drv_license_num_txt) OR ((tlinfo.cs2_drv_license_num_txt IS NULL) AND (x_cs2_drv_license_num_txt IS NULL)))
1210 AND ((tlinfo.cs2_drv_license_state_txt = x_cs2_drv_license_state_txt) OR ((tlinfo.cs2_drv_license_state_txt IS NULL) AND (x_cs2_drv_license_state_txt IS NULL)))
1211 AND ((tlinfo.cs2_elect_sig_ind_code_txt = x_cs2_elect_sig_ind_code_txt) OR ((tlinfo.cs2_elect_sig_ind_code_txt IS NULL) AND (x_cs2_elect_sig_ind_code_txt IS NULL)))
1212 AND ((tlinfo.cs2_frgn_postal_code_txt = x_cs2_frgn_postal_code_txt) OR ((tlinfo.cs2_frgn_postal_code_txt IS NULL) AND (x_cs2_frgn_postal_code_txt IS NULL)))
1213 AND ((tlinfo.cs2_frgn_tel_num_prefix_txt = x_cs2_frgn_tel_num_prefix_txt) OR ((tlinfo.cs2_frgn_tel_num_prefix_txt IS NULL) AND (x_cs2_frgn_tel_num_prefix_txt IS NULL)))
1214 AND ((tlinfo.cs2_gross_annual_sal_num = x_cs2_gross_annual_sal_num) OR ((tlinfo.cs2_gross_annual_sal_num IS NULL) AND (x_cs2_gross_annual_sal_num IS NULL)))
1215 AND ((tlinfo.cs2_mthl_auto_pay_txt = x_cs2_mthl_auto_pay_txt) OR ((tlinfo.cs2_mthl_auto_pay_txt IS NULL) AND (x_cs2_mthl_auto_pay_txt IS NULL)))
1216 AND ((tlinfo.cs2_mthl_cc_pay_txt = x_cs2_mthl_cc_pay_txt) OR ((tlinfo.cs2_mthl_cc_pay_txt IS NULL) AND (x_cs2_mthl_cc_pay_txt IS NULL)))
1217 AND ((tlinfo.cs2_mthl_edu_loan_pay_txt = x_cs2_mthl_edu_loan_pay_txt) OR ((tlinfo.cs2_mthl_edu_loan_pay_txt IS NULL) AND (x_cs2_mthl_edu_loan_pay_txt IS NULL)))
1218 AND ((tlinfo.cs2_mthl_housing_pay_txt = x_cs2_mthl_housing_pay_txt) OR ((tlinfo.cs2_mthl_housing_pay_txt IS NULL) AND (x_cs2_mthl_housing_pay_txt IS NULL)))
1219 AND ((tlinfo.cs2_mthl_other_pay_txt = x_cs2_mthl_other_pay_txt) OR ((tlinfo.cs2_mthl_other_pay_txt IS NULL) AND (x_cs2_mthl_other_pay_txt IS NULL)))
1220 AND ((tlinfo.cs2_other_income_amt = x_cs2_other_income_amt) OR ((tlinfo.cs2_other_income_amt IS NULL) AND (x_cs2_other_income_amt IS NULL)))
1221 AND ((tlinfo.cs2_rel_to_student_flag = x_cs2_rel_to_student_flag) OR ((tlinfo.cs2_rel_to_student_flag IS NULL) AND (x_cs2_rel_to_student_flag IS NULL)))
1222 AND ((tlinfo.cs2_suffix_txt = x_cs2_suffix_txt) OR ((tlinfo.cs2_suffix_txt IS NULL) AND (x_cs2_suffix_txt IS NULL)))
1223 AND ((tlinfo.cs2_years_at_address_txt = x_cs2_years_at_address_txt) OR ((tlinfo.cs2_years_at_address_txt IS NULL) AND (x_cs2_years_at_address_txt IS NULL)))
1224 ) THEN
1225 NULL;
1226 ELSE
1227 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1228 IGS_GE_MSG_STACK.ADD;
1229 APP_EXCEPTION.RAISE_EXCEPTION;
1230 END IF;
1231
1232 RETURN;
1233
1234 END lock_row;
1235
1236
1237 PROCEDURE update_row (
1238 x_rowid IN VARCHAR2,
1239 x_albw_id IN NUMBER,
1240 x_loan_id IN NUMBER,
1241 x_fed_stafford_loan_debt IN NUMBER,
1242 x_fed_sls_debt IN NUMBER,
1243 x_heal_debt IN NUMBER,
1244 x_perkins_debt IN NUMBER,
1245 x_other_debt IN NUMBER,
1246 x_crdt_undr_difft_name IN VARCHAR2,
1247 x_borw_gross_annual_sal IN NUMBER,
1248 x_borw_other_income IN NUMBER,
1249 x_student_major IN VARCHAR2,
1250 x_int_rate_opt IN VARCHAR2,
1251 x_repayment_opt_code IN VARCHAR2,
1252 x_stud_mth_housing_pymt IN NUMBER,
1253 x_stud_mth_crdtcard_pymt IN NUMBER,
1254 x_stud_mth_auto_pymt IN NUMBER,
1255 x_stud_mth_ed_loan_pymt IN NUMBER,
1256 x_stud_mth_other_pymt IN NUMBER,
1257 x_mode IN VARCHAR2,
1258 x_other_loan_amt IN NUMBER,
1259 x_cs1_lname IN VARCHAR2,
1260 x_cs1_fname IN VARCHAR2,
1261 x_cs1_mi_txt IN VARCHAR2,
1262 x_cs1_ssn_txt IN VARCHAR2,
1263 x_cs1_citizenship_status IN VARCHAR2,
1264 x_cs1_address_line_1_txt IN VARCHAR2,
1265 x_cs1_address_line_2_txt IN VARCHAR2,
1266 x_cs1_city_txt IN VARCHAR2,
1267 x_cs1_state_txt IN VARCHAR2,
1268 x_cs1_zip_txt IN VARCHAR2,
1269 x_cs1_zip_suffix_txt IN VARCHAR2,
1270 x_cs1_telephone_number_txt IN VARCHAR2,
1271 x_cs1_signature_code_txt IN VARCHAR2,
1272 x_cs2_lname IN VARCHAR2,
1273 x_cs2_fname IN VARCHAR2,
1274 x_cs2_mi_txt IN VARCHAR2,
1275 x_cs2_ssn_txt IN VARCHAR2,
1276 x_cs2_citizenship_status IN VARCHAR2,
1277 x_cs2_address_line_1_txt IN VARCHAR2,
1278 x_cs2_address_line_2_txt IN VARCHAR2,
1279 x_cs2_city_txt IN VARCHAR2,
1280 x_cs2_state_txt IN VARCHAR2,
1281 x_cs2_zip_txt IN VARCHAR2,
1282 x_cs2_zip_suffix_txt IN VARCHAR2,
1283 x_cs2_telephone_number_txt IN VARCHAR2,
1284 x_cs2_signature_code_txt IN VARCHAR2,
1285 x_cs1_credit_auth_code_txt IN VARCHAR2,
1286 x_cs1_birth_date IN Date ,
1287 x_cs1_drv_license_num_txt IN VARCHAR2,
1288 x_cs1_drv_license_state_txt IN VARCHAR2,
1289 x_cs1_elect_sig_ind_code_txt IN VARCHAR2,
1290 x_cs1_frgn_postal_code_txt IN VARCHAR2,
1291 x_cs1_frgn_tel_num_prefix_txt IN VARCHAR2,
1292 x_cs1_gross_annual_sal_num IN NUMBER ,
1293 x_cs1_mthl_auto_pay_txt IN VARCHAR2,
1294 x_cs1_mthl_cc_pay_txt IN VARCHAR2,
1295 x_cs1_mthl_edu_loan_pay_txt IN VARCHAR2,
1296 x_cs1_mthl_housing_pay_txt IN VARCHAR2,
1297 x_cs1_mthl_other_pay_txt IN VARCHAR2,
1298 x_cs1_other_income_amt IN NUMBER ,
1299 x_cs1_rel_to_student_flag IN VARCHAR2,
1300 x_cs1_suffix_txt IN VARCHAR2,
1301 x_cs1_years_at_address_txt IN NUMBER ,
1302 x_cs2_credit_auth_code_txt IN VARCHAR2,
1303 x_cs2_birth_date IN Date ,
1304 x_cs2_drv_license_num_txt IN VARCHAR2,
1305 x_cs2_drv_license_state_txt IN VARCHAR2,
1306 x_cs2_elect_sig_ind_code_txt IN VARCHAR2,
1307 x_cs2_frgn_postal_code_txt IN VARCHAR2,
1308 x_cs2_frgn_tel_num_prefix_txt IN VARCHAR2,
1309 x_cs2_gross_annual_sal_num IN NUMBER ,
1310 x_cs2_mthl_auto_pay_txt IN VARCHAR2,
1311 x_cs2_mthl_cc_pay_txt IN VARCHAR2,
1312 x_cs2_mthl_edu_loan_pay_txt IN VARCHAR2,
1313 x_cs2_mthl_housing_pay_txt IN VARCHAR2,
1314 x_cs2_mthl_other_pay_txt IN VARCHAR2,
1315 x_cs2_other_income_amt IN NUMBER ,
1316 x_cs2_rel_to_student_flag IN VARCHAR2,
1317 x_cs2_suffix_txt IN VARCHAR2,
1318 x_cs2_years_at_address_txt IN NUMBER
1319 ) AS
1320 /*
1321 || Created By : viramali
1322 || Created On : 10-MAY-2001
1323 || Purpose : Handles the UPDATE DML logic for the table.
1324 || Known limitations, enhancements or remarks :
1325 || Change History :
1326 || Who When What
1327 || (reverse chronological order - newest change first)
1328 */
1329 x_last_update_date DATE ;
1330 x_last_updated_by NUMBER;
1331 x_last_update_login NUMBER;
1332 x_request_id NUMBER;
1333 x_program_id NUMBER;
1334 x_program_application_id NUMBER;
1335 x_program_update_date DATE;
1336
1337 BEGIN
1338
1339 x_last_update_date := SYSDATE;
1340 IF (X_MODE = 'I') THEN
1341 x_last_updated_by := 1;
1342 x_last_update_login := 0;
1343 ELSIF (x_mode = 'R') THEN
1344 x_last_updated_by := fnd_global.user_id;
1345 IF x_last_updated_by IS NULL THEN
1346 x_last_updated_by := -1;
1347 END IF;
1348 x_last_update_login := fnd_global.login_id;
1349 IF (x_last_update_login IS NULL) THEN
1350 x_last_update_login := -1;
1351 END IF;
1352 ELSE
1353 FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1354 IGS_GE_MSG_STACK.ADD;
1355 APP_EXCEPTION.RAISE_EXCEPTION;
1356 END IF;
1357
1358 before_dml(
1359 p_action => 'UPDATE',
1360 x_rowid => x_rowid,
1361 x_albw_id => x_albw_id,
1362 x_loan_id => x_loan_id,
1363 x_fed_stafford_loan_debt => x_fed_stafford_loan_debt,
1364 x_fed_sls_debt => x_fed_sls_debt,
1365 x_heal_debt => x_heal_debt,
1366 x_perkins_debt => x_perkins_debt,
1367 x_other_debt => x_other_debt,
1368 x_crdt_undr_difft_name => x_crdt_undr_difft_name,
1369 x_borw_gross_annual_sal => x_borw_gross_annual_sal,
1370 x_borw_other_income => x_borw_other_income,
1371 x_student_major => x_student_major,
1372 x_int_rate_opt => x_int_rate_opt,
1373 x_repayment_opt_code => x_repayment_opt_code,
1374 x_stud_mth_housing_pymt => x_stud_mth_housing_pymt,
1375 x_stud_mth_crdtcard_pymt => x_stud_mth_crdtcard_pymt,
1376 x_stud_mth_auto_pymt => x_stud_mth_auto_pymt,
1377 x_stud_mth_ed_loan_pymt => x_stud_mth_ed_loan_pymt,
1378 x_stud_mth_other_pymt => x_stud_mth_other_pymt,
1379 x_creation_date => x_last_update_date,
1380 x_created_by => x_last_updated_by,
1381 x_last_update_date => x_last_update_date,
1382 x_last_updated_by => x_last_updated_by,
1383 x_last_update_login => x_last_update_login,
1384 x_other_loan_amt => x_other_loan_amt,
1385 x_cs1_lname => x_cs1_lname ,
1386 x_cs1_fname => x_cs1_fname ,
1387 x_cs1_mi_txt => x_cs1_mi_txt ,
1388 x_cs1_ssn_txt => x_cs1_ssn_txt ,
1389 x_cs1_citizenship_status => x_cs1_citizenship_status ,
1390 x_cs1_address_line_1_txt => x_cs1_address_line_1_txt ,
1391 x_cs1_address_line_2_txt => x_cs1_address_line_2_txt ,
1392 x_cs1_city_txt => x_cs1_city_txt ,
1393 x_cs1_state_txt => x_cs1_state_txt ,
1394 x_cs1_zip_txt => x_cs1_zip_txt ,
1395 x_cs1_zip_suffix_txt => x_cs1_zip_suffix_txt ,
1396 x_cs1_telephone_number_txt => x_cs1_telephone_number_txt ,
1397 x_cs1_signature_code_txt => x_cs1_signature_code_txt ,
1398 x_cs2_lname => x_cs2_lname ,
1399 x_cs2_fname => x_cs2_fname ,
1400 x_cs2_mi_txt => x_cs2_mi_txt ,
1401 x_cs2_ssn_txt => x_cs2_ssn_txt ,
1402 x_cs2_citizenship_status => x_cs2_citizenship_status ,
1403 x_cs2_address_line_1_txt => x_cs2_address_line_1_txt ,
1404 x_cs2_address_line_2_txt => x_cs2_address_line_2_txt ,
1405 x_cs2_city_txt => x_cs2_city_txt ,
1406 x_cs2_state_txt => x_cs2_state_txt ,
1407 x_cs2_zip_txt => x_cs2_zip_txt ,
1408 x_cs2_zip_suffix_txt => x_cs2_zip_suffix_txt ,
1409 x_cs2_telephone_number_txt => x_cs2_telephone_number_txt ,
1410 x_cs2_signature_code_txt => x_cs2_signature_code_txt ,
1411 x_cs1_credit_auth_code_txt => x_cs1_credit_auth_code_txt ,
1412 x_cs1_birth_date => x_cs1_birth_date ,
1413 x_cs1_drv_license_num_txt => x_cs1_drv_license_num_txt ,
1414 x_cs1_drv_license_state_txt => x_cs1_drv_license_state_txt ,
1415 x_cs1_elect_sig_ind_code_txt => x_cs1_elect_sig_ind_code_txt ,
1416 x_cs1_frgn_postal_code_txt => x_cs1_frgn_postal_code_txt ,
1417 x_cs1_frgn_tel_num_prefix_txt => x_cs1_frgn_tel_num_prefix_txt ,
1418 x_cs1_gross_annual_sal_num => x_cs1_gross_annual_sal_num ,
1419 x_cs1_mthl_auto_pay_txt => x_cs1_mthl_auto_pay_txt ,
1420 x_cs1_mthl_cc_pay_txt => x_cs1_mthl_cc_pay_txt ,
1421 x_cs1_mthl_edu_loan_pay_txt => x_cs1_mthl_edu_loan_pay_txt ,
1422 x_cs1_mthl_housing_pay_txt => x_cs1_mthl_housing_pay_txt ,
1423 x_cs1_mthl_other_pay_txt => x_cs1_mthl_other_pay_txt ,
1424 x_cs1_other_income_amt => x_cs1_other_income_amt ,
1425 x_cs1_rel_to_student_flag => x_cs1_rel_to_student_flag ,
1426 x_cs1_suffix_txt => x_cs1_suffix_txt ,
1427 x_cs1_years_at_address_txt => x_cs1_years_at_address_txt ,
1428 x_cs2_credit_auth_code_txt => x_cs2_credit_auth_code_txt ,
1429 x_cs2_birth_date => x_cs2_birth_date ,
1430 x_cs2_drv_license_num_txt => x_cs2_drv_license_num_txt ,
1431 x_cs2_drv_license_state_txt => x_cs2_drv_license_state_txt ,
1432 x_cs2_elect_sig_ind_code_txt => x_cs2_elect_sig_ind_code_txt ,
1433 x_cs2_frgn_postal_code_txt => x_cs2_frgn_postal_code_txt ,
1434 x_cs2_frgn_tel_num_prefix_txt => x_cs2_frgn_tel_num_prefix_txt ,
1435 x_cs2_gross_annual_sal_num => x_cs2_gross_annual_sal_num ,
1436 x_cs2_mthl_auto_pay_txt => x_cs2_mthl_auto_pay_txt ,
1437 x_cs2_mthl_cc_pay_txt => x_cs2_mthl_cc_pay_txt ,
1438 x_cs2_mthl_edu_loan_pay_txt => x_cs2_mthl_edu_loan_pay_txt ,
1439 x_cs2_mthl_housing_pay_txt => x_cs2_mthl_housing_pay_txt ,
1440 x_cs2_mthl_other_pay_txt => x_cs2_mthl_other_pay_txt ,
1441 x_cs2_other_income_amt => x_cs2_other_income_amt ,
1442 x_cs2_rel_to_student_flag => x_cs2_rel_to_student_flag ,
1443 x_cs2_suffix_txt => x_cs2_suffix_txt ,
1444 x_cs2_years_at_address_txt => x_cs2_years_at_address_txt
1445 );
1446
1447 IF (x_mode = 'R') THEN
1448 x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1449 x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1450 x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1451 IF (x_request_id = -1) THEN
1452 x_request_id := old_references.request_id;
1453 x_program_id := old_references.program_id;
1454 x_program_application_id := old_references.program_application_id;
1455 x_program_update_date := old_references.program_update_date;
1456 ELSE
1457 x_program_update_date := SYSDATE;
1458 END IF;
1459 END IF;
1460
1461 UPDATE igf_sl_alt_borw_all
1462 SET
1463 loan_id = new_references.loan_id,
1464 fed_stafford_loan_debt = new_references.fed_stafford_loan_debt,
1465 fed_sls_debt = new_references.fed_sls_debt,
1466 heal_debt = new_references.heal_debt,
1467 perkins_debt = new_references.perkins_debt,
1468 other_debt = new_references.other_debt,
1469 crdt_undr_difft_name = new_references.crdt_undr_difft_name,
1470 borw_gross_annual_sal = new_references.borw_gross_annual_sal,
1471 borw_other_income = new_references.borw_other_income,
1472 student_major = new_references.student_major,
1473 int_rate_opt = new_references.int_rate_opt,
1474 repayment_opt_code = new_references.repayment_opt_code,
1475 stud_mth_housing_pymt = new_references.stud_mth_housing_pymt,
1476 stud_mth_crdtcard_pymt = new_references.stud_mth_crdtcard_pymt,
1477 stud_mth_auto_pymt = new_references.stud_mth_auto_pymt,
1478 stud_mth_ed_loan_pymt = new_references.stud_mth_ed_loan_pymt,
1479 stud_mth_other_pymt = new_references.stud_mth_other_pymt,
1480 last_update_date = x_last_update_date,
1481 last_updated_by = x_last_updated_by,
1482 last_update_login = x_last_update_login ,
1483 request_id = x_request_id,
1484 program_id = x_program_id,
1485 program_application_id = x_program_application_id,
1486 program_update_date = x_program_update_date,
1487 other_loan_amt = new_references.other_loan_amt, -- mnade 5/30/2005 - Correcting this to use the new valud instead of passed parameter x_other_loan_amt
1488 cs1_lname = new_references.cs1_lname ,
1489 cs1_fname = new_references.cs1_fname ,
1490 cs1_mi_txt = new_references.cs1_mi_txt ,
1491 cs1_ssn_txt = new_references.cs1_ssn_txt ,
1492 cs1_citizenship_status = new_references.cs1_citizenship_status ,
1493 cs1_address_line_1_txt = new_references.cs1_address_line_1_txt ,
1494 cs1_address_line_2_txt = new_references.cs1_address_line_2_txt ,
1495 cs1_city_txt = new_references.cs1_city_txt ,
1496 cs1_state_txt = new_references.cs1_state_txt ,
1497 cs1_zip_txt = new_references.cs1_zip_txt ,
1498 cs1_zip_suffix_txt = new_references.cs1_zip_suffix_txt ,
1499 cs1_telephone_number_txt = new_references.cs1_telephone_number_txt ,
1500 cs1_signature_code_txt = new_references.cs1_signature_code_txt ,
1501 cs2_lname = new_references.cs2_lname ,
1502 cs2_fname = new_references.cs2_fname ,
1503 cs2_mi_txt = new_references.cs2_mi_txt ,
1504 cs2_ssn_txt = new_references.cs2_ssn_txt ,
1505 cs2_citizenship_status = new_references.cs2_citizenship_status ,
1506 cs2_address_line_1_txt = new_references.cs2_address_line_1_txt ,
1507 cs2_address_line_2_txt = new_references.cs2_address_line_2_txt ,
1508 cs2_city_txt = new_references.cs2_city_txt ,
1509 cs2_state_txt = new_references.cs2_state_txt ,
1510 cs2_zip_txt = new_references.cs2_zip_txt ,
1511 cs2_zip_suffix_txt = new_references.cs2_zip_suffix_txt ,
1512 cs2_telephone_number_txt = new_references.cs2_telephone_number_txt ,
1513 cs2_signature_code_txt = new_references.cs2_signature_code_txt ,
1514 cs1_credit_auth_code_txt = new_references.cs1_credit_auth_code_txt ,
1515 cs1_birth_date = new_references.cs1_birth_date ,
1516 cs1_drv_license_num_txt = new_references.cs1_drv_license_num_txt ,
1517 cs1_drv_license_state_txt = new_references.cs1_drv_license_state_txt ,
1518 cs1_elect_sig_ind_code_txt = new_references.cs1_elect_sig_ind_code_txt ,
1519 cs1_frgn_postal_code_txt = new_references.cs1_frgn_postal_code_txt ,
1520 cs1_frgn_tel_num_prefix_txt = new_references.cs1_frgn_tel_num_prefix_txt ,
1521 cs1_gross_annual_sal_num = new_references.cs1_gross_annual_sal_num ,
1522 cs1_mthl_auto_pay_txt = new_references.cs1_mthl_auto_pay_txt ,
1523 cs1_mthl_cc_pay_txt = new_references.cs1_mthl_cc_pay_txt ,
1524 cs1_mthl_edu_loan_pay_txt = new_references.cs1_mthl_edu_loan_pay_txt ,
1525 cs1_mthl_housing_pay_txt = new_references.cs1_mthl_housing_pay_txt ,
1526 cs1_mthl_other_pay_txt = new_references.cs1_mthl_other_pay_txt ,
1527 cs1_other_income_amt = new_references.cs1_other_income_amt ,
1528 cs1_rel_to_student_flag = new_references.cs1_rel_to_student_flag ,
1529 cs1_suffix_txt = new_references.cs1_suffix_txt ,
1530 cs1_years_at_address_txt = new_references.cs1_years_at_address_txt ,
1531 cs2_credit_auth_code_txt = new_references.cs2_credit_auth_code_txt ,
1532 cs2_birth_date = new_references.cs2_birth_date ,
1533 cs2_drv_license_num_txt = new_references.cs2_drv_license_num_txt ,
1534 cs2_drv_license_state_txt = new_references.cs2_drv_license_state_txt ,
1535 cs2_elect_sig_ind_code_txt = new_references.cs2_elect_sig_ind_code_txt ,
1536 cs2_frgn_postal_code_txt = new_references.cs2_frgn_postal_code_txt ,
1537 cs2_frgn_tel_num_prefix_txt = new_references.cs2_frgn_tel_num_prefix_txt ,
1538 cs2_gross_annual_sal_num = new_references.cs2_gross_annual_sal_num ,
1539 cs2_mthl_auto_pay_txt = new_references.cs2_mthl_auto_pay_txt ,
1540 cs2_mthl_cc_pay_txt = new_references.cs2_mthl_cc_pay_txt ,
1541 cs2_mthl_edu_loan_pay_txt = new_references.cs2_mthl_edu_loan_pay_txt ,
1542 cs2_mthl_housing_pay_txt = new_references.cs2_mthl_housing_pay_txt ,
1543 cs2_mthl_other_pay_txt = new_references.cs2_mthl_other_pay_txt ,
1544 cs2_other_income_amt = new_references.cs2_other_income_amt ,
1545 cs2_rel_to_student_flag = new_references.cs2_rel_to_student_flag ,
1546 cs2_suffix_txt = new_references.cs2_suffix_txt ,
1547 cs2_years_at_address_txt = new_references.cs2_years_at_address_txt
1548 WHERE rowid = x_rowid;
1549
1550 IF (SQL%NOTFOUND) THEN
1551 RAISE NO_DATA_FOUND;
1552 END IF;
1553
1554 END update_row;
1555
1556
1557 PROCEDURE add_row (
1558 x_rowid IN OUT NOCOPY VARCHAR2,
1559 x_albw_id IN OUT NOCOPY NUMBER,
1560 x_loan_id IN NUMBER,
1561 x_fed_stafford_loan_debt IN NUMBER,
1562 x_fed_sls_debt IN NUMBER,
1563 x_heal_debt IN NUMBER,
1564 x_perkins_debt IN NUMBER,
1565 x_other_debt IN NUMBER,
1566 x_crdt_undr_difft_name IN VARCHAR2,
1567 x_borw_gross_annual_sal IN NUMBER,
1568 x_borw_other_income IN NUMBER,
1569 x_student_major IN VARCHAR2,
1570 x_int_rate_opt IN VARCHAR2,
1571 x_repayment_opt_code IN VARCHAR2,
1572 x_stud_mth_housing_pymt IN NUMBER,
1573 x_stud_mth_crdtcard_pymt IN NUMBER,
1574 x_stud_mth_auto_pymt IN NUMBER,
1575 x_stud_mth_ed_loan_pymt IN NUMBER,
1576 x_stud_mth_other_pymt IN NUMBER,
1577 x_mode IN VARCHAR2,
1578 x_other_loan_amt IN NUMBER,
1579 x_cs1_lname IN VARCHAR2,
1580 x_cs1_fname IN VARCHAR2,
1581 x_cs1_mi_txt IN VARCHAR2,
1582 x_cs1_ssn_txt IN VARCHAR2,
1583 x_cs1_citizenship_status IN VARCHAR2,
1584 x_cs1_address_line_1_txt IN VARCHAR2,
1585 x_cs1_address_line_2_txt IN VARCHAR2,
1586 x_cs1_city_txt IN VARCHAR2,
1587 x_cs1_state_txt IN VARCHAR2,
1588 x_cs1_zip_txt IN VARCHAR2,
1589 x_cs1_zip_suffix_txt IN VARCHAR2,
1590 x_cs1_telephone_number_txt IN VARCHAR2,
1591 x_cs1_signature_code_txt IN VARCHAR2,
1592 x_cs2_lname IN VARCHAR2,
1593 x_cs2_fname IN VARCHAR2,
1594 x_cs2_mi_txt IN VARCHAR2,
1595 x_cs2_ssn_txt IN VARCHAR2,
1596 x_cs2_citizenship_status IN VARCHAR2,
1597 x_cs2_address_line_1_txt IN VARCHAR2,
1598 x_cs2_address_line_2_txt IN VARCHAR2,
1599 x_cs2_city_txt IN VARCHAR2,
1600 x_cs2_state_txt IN VARCHAR2,
1601 x_cs2_zip_txt IN VARCHAR2,
1602 x_cs2_zip_suffix_txt IN VARCHAR2,
1603 x_cs2_telephone_number_txt IN VARCHAR2,
1604 x_cs2_signature_code_txt IN VARCHAR2,
1605 x_cs1_credit_auth_code_txt IN VARCHAR2,
1606 x_cs1_birth_date IN Date ,
1607 x_cs1_drv_license_num_txt IN VARCHAR2,
1608 x_cs1_drv_license_state_txt IN VARCHAR2,
1609 x_cs1_elect_sig_ind_code_txt IN VARCHAR2,
1610 x_cs1_frgn_postal_code_txt IN VARCHAR2,
1611 x_cs1_frgn_tel_num_prefix_txt IN VARCHAR2,
1612 x_cs1_gross_annual_sal_num IN NUMBER ,
1613 x_cs1_mthl_auto_pay_txt IN VARCHAR2,
1614 x_cs1_mthl_cc_pay_txt IN VARCHAR2,
1615 x_cs1_mthl_edu_loan_pay_txt IN VARCHAR2,
1616 x_cs1_mthl_housing_pay_txt IN VARCHAR2,
1617 x_cs1_mthl_other_pay_txt IN VARCHAR2,
1618 x_cs1_other_income_amt IN NUMBER ,
1619 x_cs1_rel_to_student_flag IN VARCHAR2,
1620 x_cs1_suffix_txt IN VARCHAR2,
1621 x_cs1_years_at_address_txt IN NUMBER ,
1622 x_cs2_credit_auth_code_txt IN VARCHAR2,
1623 x_cs2_birth_date IN Date ,
1624 x_cs2_drv_license_num_txt IN VARCHAR2,
1625 x_cs2_drv_license_state_txt IN VARCHAR2,
1626 x_cs2_elect_sig_ind_code_txt IN VARCHAR2,
1627 x_cs2_frgn_postal_code_txt IN VARCHAR2,
1628 x_cs2_frgn_tel_num_prefix_txt IN VARCHAR2,
1629 x_cs2_gross_annual_sal_num IN NUMBER ,
1630 x_cs2_mthl_auto_pay_txt IN VARCHAR2,
1631 x_cs2_mthl_cc_pay_txt IN VARCHAR2,
1632 x_cs2_mthl_edu_loan_pay_txt IN VARCHAR2,
1633 x_cs2_mthl_housing_pay_txt IN VARCHAR2,
1634 x_cs2_mthl_other_pay_txt IN VARCHAR2,
1635 x_cs2_other_income_amt IN NUMBER ,
1636 x_cs2_rel_to_student_flag IN VARCHAR2,
1637 x_cs2_suffix_txt IN VARCHAR2,
1638 x_cs2_years_at_address_txt IN NUMBER
1639 ) AS
1640 /*
1641 || Created By : viramali
1642 || Created On : 10-MAY-2001
1643 || Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
1644 || Known limitations, enhancements or remarks :
1645 || Change History :
1646 || Who When What
1647 || (reverse chronological order - newest change first)
1648 */
1649 CURSOR c1 IS
1650 SELECT rowid
1651 FROM igf_sl_alt_borw_all
1652 WHERE albw_id = x_albw_id;
1653
1654 BEGIN
1655
1656 OPEN c1;
1657 FETCH c1 INTO x_rowid;
1658 IF (c1%NOTFOUND) THEN
1659 CLOSE c1;
1660
1661 insert_row (
1662 x_rowid,
1663 x_albw_id,
1664 x_loan_id,
1665 x_fed_stafford_loan_debt,
1666 x_fed_sls_debt,
1667 x_heal_debt,
1668 x_perkins_debt,
1669 x_other_debt,
1670 x_crdt_undr_difft_name,
1671 x_borw_gross_annual_sal,
1672 x_borw_other_income,
1673 x_student_major,
1674 x_int_rate_opt,
1675 x_repayment_opt_code,
1676 x_stud_mth_housing_pymt,
1677 x_stud_mth_crdtcard_pymt,
1678 x_stud_mth_auto_pymt,
1679 x_stud_mth_ed_loan_pymt,
1680 x_stud_mth_other_pymt,
1681 x_mode,
1682 x_other_loan_amt,
1683 x_cs1_lname,
1684 x_cs1_fname,
1685 x_cs1_mi_txt,
1686 x_cs1_ssn_txt,
1687 x_cs1_citizenship_status,
1688 x_cs1_address_line_1_txt,
1689 x_cs1_address_line_2_txt,
1690 x_cs1_city_txt,
1691 x_cs1_state_txt,
1692 x_cs1_zip_txt,
1693 x_cs1_zip_suffix_txt,
1694 x_cs1_telephone_number_txt,
1695 x_cs1_signature_code_txt,
1696 x_cs2_lname,
1697 x_cs2_fname,
1698 x_cs2_mi_txt,
1699 x_cs2_ssn_txt,
1700 x_cs2_citizenship_status,
1701 x_cs2_address_line_1_txt,
1702 x_cs2_address_line_2_txt,
1703 x_cs2_city_txt,
1704 x_cs2_state_txt,
1705 x_cs2_zip_txt,
1706 x_cs2_zip_suffix_txt,
1707 x_cs2_telephone_number_txt,
1708 x_cs2_signature_code_txt,
1709 x_cs1_credit_auth_code_txt,
1710 x_cs1_birth_date,
1711 x_cs1_drv_license_num_txt,
1712 x_cs1_drv_license_state_txt,
1713 x_cs1_elect_sig_ind_code_txt,
1714 x_cs1_frgn_postal_code_txt,
1715 x_cs1_frgn_tel_num_prefix_txt,
1716 x_cs1_gross_annual_sal_num,
1717 x_cs1_mthl_auto_pay_txt,
1718 x_cs1_mthl_cc_pay_txt,
1719 x_cs1_mthl_edu_loan_pay_txt,
1720 x_cs1_mthl_housing_pay_txt,
1721 x_cs1_mthl_other_pay_txt,
1722 x_cs1_other_income_amt,
1723 x_cs1_rel_to_student_flag,
1724 x_cs1_suffix_txt,
1725 x_cs1_years_at_address_txt,
1726 x_cs2_credit_auth_code_txt,
1727 x_cs2_birth_date,
1728 x_cs2_drv_license_num_txt,
1729 x_cs2_drv_license_state_txt,
1730 x_cs2_elect_sig_ind_code_txt,
1731 x_cs2_frgn_postal_code_txt,
1732 x_cs2_frgn_tel_num_prefix_txt,
1733 x_cs2_gross_annual_sal_num,
1734 x_cs2_mthl_auto_pay_txt,
1735 x_cs2_mthl_cc_pay_txt,
1736 x_cs2_mthl_edu_loan_pay_txt,
1737 x_cs2_mthl_housing_pay_txt,
1738 x_cs2_mthl_other_pay_txt,
1739 x_cs2_other_income_amt,
1740 x_cs2_rel_to_student_flag,
1741 x_cs2_suffix_txt,
1742 x_cs2_years_at_address_txt
1743 );
1744 RETURN;
1745 END IF;
1746 CLOSE c1;
1747
1748 update_row (
1749 x_rowid,
1750 x_albw_id,
1751 x_loan_id,
1752 x_fed_stafford_loan_debt,
1753 x_fed_sls_debt,
1754 x_heal_debt,
1755 x_perkins_debt,
1756 x_other_debt,
1757 x_crdt_undr_difft_name,
1758 x_borw_gross_annual_sal,
1759 x_borw_other_income,
1760 x_student_major,
1761 x_int_rate_opt,
1762 x_repayment_opt_code,
1763 x_stud_mth_housing_pymt,
1764 x_stud_mth_crdtcard_pymt,
1765 x_stud_mth_auto_pymt,
1766 x_stud_mth_ed_loan_pymt,
1767 x_stud_mth_other_pymt,
1768 x_mode,
1769 x_other_loan_amt,
1770 x_cs1_lname,
1771 x_cs1_fname,
1772 x_cs1_mi_txt,
1773 x_cs1_ssn_txt,
1774 x_cs1_citizenship_status,
1775 x_cs1_address_line_1_txt,
1776 x_cs1_address_line_2_txt,
1777 x_cs1_city_txt,
1778 x_cs1_state_txt,
1779 x_cs1_zip_txt,
1780 x_cs1_zip_suffix_txt,
1781 x_cs1_telephone_number_txt,
1782 x_cs1_signature_code_txt,
1783 x_cs2_lname,
1784 x_cs2_fname,
1785 x_cs2_mi_txt,
1786 x_cs2_ssn_txt,
1787 x_cs2_citizenship_status,
1788 x_cs2_address_line_1_txt,
1789 x_cs2_address_line_2_txt,
1790 x_cs2_city_txt,
1791 x_cs2_state_txt,
1792 x_cs2_zip_txt,
1793 x_cs2_zip_suffix_txt,
1794 x_cs2_telephone_number_txt,
1795 x_cs2_signature_code_txt,
1796 x_cs1_credit_auth_code_txt,
1797 x_cs1_birth_date,
1798 x_cs1_drv_license_num_txt,
1799 x_cs1_drv_license_state_txt,
1800 x_cs1_elect_sig_ind_code_txt,
1801 x_cs1_frgn_postal_code_txt,
1802 x_cs1_frgn_tel_num_prefix_txt,
1803 x_cs1_gross_annual_sal_num,
1804 x_cs1_mthl_auto_pay_txt,
1805 x_cs1_mthl_cc_pay_txt,
1806 x_cs1_mthl_edu_loan_pay_txt,
1807 x_cs1_mthl_housing_pay_txt,
1808 x_cs1_mthl_other_pay_txt,
1809 x_cs1_other_income_amt,
1810 x_cs1_rel_to_student_flag,
1811 x_cs1_suffix_txt,
1812 x_cs1_years_at_address_txt,
1813 x_cs2_credit_auth_code_txt,
1814 x_cs2_birth_date,
1815 x_cs2_drv_license_num_txt,
1816 x_cs2_drv_license_state_txt,
1817 x_cs2_elect_sig_ind_code_txt,
1818 x_cs2_frgn_postal_code_txt,
1819 x_cs2_frgn_tel_num_prefix_txt,
1820 x_cs2_gross_annual_sal_num,
1821 x_cs2_mthl_auto_pay_txt,
1822 x_cs2_mthl_cc_pay_txt,
1823 x_cs2_mthl_edu_loan_pay_txt,
1824 x_cs2_mthl_housing_pay_txt,
1825 x_cs2_mthl_other_pay_txt,
1826 x_cs2_other_income_amt,
1827 x_cs2_rel_to_student_flag,
1828 x_cs2_suffix_txt,
1829 x_cs2_years_at_address_txt
1830 );
1831
1832 END add_row;
1833
1834
1835 PROCEDURE delete_row (
1836 x_rowid IN VARCHAR2
1837 ) AS
1838 /*
1839 || Created By : viramali
1840 || Created On : 10-MAY-2001
1841 || Purpose : Handles the DELETE DML logic for the table.
1842 || Known limitations, enhancements or remarks :
1843 || Change History :
1844 || Who When What
1845 || (reverse chronological order - newest change first)
1846 */
1847 BEGIN
1848
1849 before_dml ( p_action => 'DELETE', x_rowid => x_rowid );
1850
1851 DELETE FROM igf_sl_alt_borw_all
1852 WHERE rowid = x_rowid;
1853
1854 IF (SQL%NOTFOUND) THEN
1855 RAISE NO_DATA_FOUND;
1856 END IF;
1857
1858 END delete_row;
1859
1860
1861 END igf_sl_alt_borw_pkg;