1 PACKAGE igf_ap_fa_base_rec_pkg AS
2 /* $Header: IGFAI03S.pls 120.0 2005/06/01 12:53:05 appldev noship $ */
3 /*
4 || Created By : skoppula
5 || Created On : 07-DEC-2000
6 || Purpose : Table handler package for igf_ap_fa_base_rec
7 || Known limitations, enhancements or remarks :
8 || Change History :
9 || Who When What
10 || (reverse chronological order - newest change first)
11 */
12
13 PROCEDURE insert_row (
14 x_rowid IN OUT NOCOPY VARCHAR2,
15 x_base_id IN OUT NOCOPY NUMBER,
16 x_ci_cal_type IN VARCHAR2,
17 x_person_id IN NUMBER,
18 x_ci_sequence_number IN NUMBER,
19 x_org_id IN NUMBER,
20 x_coa_pending IN VARCHAR2,
21 x_verification_process_run IN VARCHAR2,
22 x_inst_verif_status_date IN DATE,
23 x_manual_verif_flag IN VARCHAR2,
24 x_fed_verif_status IN VARCHAR2,
25 x_fed_verif_status_date IN DATE,
26 x_inst_verif_status IN VARCHAR2,
27 x_nslds_eligible IN VARCHAR2,
28 x_ede_correction_batch_id IN VARCHAR2, -- Modified by rbezawad on 22-Jun-2001 w.r.t. Bug ID: 1821811
29 x_fa_process_status_date IN DATE,
30 x_isir_corr_status IN VARCHAR2,
31 x_isir_corr_status_date IN DATE,
32 x_isir_status IN VARCHAR2,
33 x_isir_status_date IN DATE,
34 x_coa_code_f IN VARCHAR2,
35 x_coa_code_i IN VARCHAR2,
36 x_coa_f IN NUMBER,
37 x_coa_i IN NUMBER,
38 x_disbursement_hold IN VARCHAR2,
39 x_fa_process_status IN VARCHAR2,
40 x_notification_status IN VARCHAR2,
41 x_notification_status_date IN DATE,
42 x_packaging_hold IN VARCHAR2 DEFAULT NULL , -- As part of FA 101 SAP Obsoletion
43 x_packaging_status IN VARCHAR2,
44 x_packaging_status_date IN DATE,
45 x_total_package_accepted IN NUMBER,
46 x_total_package_offered IN NUMBER,
47 x_admstruct_id IN VARCHAR2,
48 x_admsegment_1 IN VARCHAR2,
49 x_admsegment_2 IN VARCHAR2,
50 x_admsegment_3 IN VARCHAR2,
51 x_admsegment_4 IN VARCHAR2,
52 x_admsegment_5 IN VARCHAR2,
53 x_admsegment_6 IN VARCHAR2,
54 x_admsegment_7 IN VARCHAR2,
55 x_admsegment_8 IN VARCHAR2,
56 x_admsegment_9 IN VARCHAR2,
57 x_admsegment_10 IN VARCHAR2,
58 x_admsegment_11 IN VARCHAR2,
59 x_admsegment_12 IN VARCHAR2,
60 x_admsegment_13 IN VARCHAR2,
61 x_admsegment_14 IN VARCHAR2,
62 x_admsegment_15 IN VARCHAR2,
63 x_admsegment_16 IN VARCHAR2,
64 x_admsegment_17 IN VARCHAR2,
65 x_admsegment_18 IN VARCHAR2,
66 x_admsegment_19 IN VARCHAR2,
67 x_admsegment_20 IN VARCHAR2,
68 x_packstruct_id IN VARCHAR2,
69 x_packsegment_1 IN VARCHAR2,
70 x_packsegment_2 IN VARCHAR2,
71 x_packsegment_3 IN VARCHAR2,
72 x_packsegment_4 IN VARCHAR2,
73 x_packsegment_5 IN VARCHAR2,
74 x_packsegment_6 IN VARCHAR2,
75 x_packsegment_7 IN VARCHAR2,
76 x_packsegment_8 IN VARCHAR2,
77 x_packsegment_9 IN VARCHAR2,
78 x_packsegment_10 IN VARCHAR2,
79 x_packsegment_11 IN VARCHAR2,
80 x_packsegment_12 IN VARCHAR2,
81 x_packsegment_13 IN VARCHAR2,
82 x_packsegment_14 IN VARCHAR2,
83 x_packsegment_15 IN VARCHAR2,
84 x_packsegment_16 IN VARCHAR2,
85 x_packsegment_17 IN VARCHAR2,
86 x_packsegment_18 IN VARCHAR2,
87 x_packsegment_19 IN VARCHAR2,
88 x_packsegment_20 IN VARCHAR2,
89 x_miscstruct_id IN VARCHAR2,
90 x_miscsegment_1 IN VARCHAR2,
91 x_miscsegment_2 IN VARCHAR2,
92 x_miscsegment_3 IN VARCHAR2,
93 x_miscsegment_4 IN VARCHAR2,
94 x_miscsegment_5 IN VARCHAR2,
95 x_miscsegment_6 IN VARCHAR2,
96 x_miscsegment_7 IN VARCHAR2,
97 x_miscsegment_8 IN VARCHAR2,
98 x_miscsegment_9 IN VARCHAR2,
99 x_miscsegment_10 IN VARCHAR2,
100 x_miscsegment_11 IN VARCHAR2,
101 x_miscsegment_12 IN VARCHAR2,
102 x_miscsegment_13 IN VARCHAR2,
103 x_miscsegment_14 IN VARCHAR2,
104 x_miscsegment_15 IN VARCHAR2,
105 x_miscsegment_16 IN VARCHAR2,
106 x_miscsegment_17 IN VARCHAR2,
107 x_miscsegment_18 IN VARCHAR2,
108 x_miscsegment_19 IN VARCHAR2,
109 x_miscsegment_20 IN VARCHAR2,
110 x_prof_judgement_flg IN VARCHAR2,
111 x_nslds_data_override_flg IN VARCHAR2,
112 x_target_group IN VARCHAR2,
113 x_coa_fixed IN NUMBER,
114 x_coa_pell IN NUMBER,
115 x_mode IN VARCHAR2 DEFAULT 'R' ,
116 x_profile_status IN VARCHAR2 DEFAULT NULL,
117 x_profile_status_date IN DATE DEFAULT NULL,
118 x_profile_fc IN NUMBER DEFAULT NULL,
119 x_tolerance_amount IN NUMBER DEFAULT NULL, --Modified by kkillams on 28- June-2001 w.r.t. bug 1794114
120 x_manual_disb_hold IN VARCHAR2 DEFAULT NULL,
121 x_pell_alt_expense IN NUMBER DEFAULT NULL,
122 x_assoc_org_num IN NUMBER DEFAULT NULL, --Modified by ugummall on 25-SEP-2003 w.r.t FA 126 Multiple FA Offices
123 x_award_fmly_contribution_type IN VARCHAR2 DEFAULT NULL, --Modified by rasahoo on 17-NOV-2003 w.r.t FA 128 ISIR update 20004-05
124 x_isir_locked_by IN VARCHAR2 DEFAULT NULL,
125 x_adnl_unsub_loan_elig_flag IN VARCHAR2 DEFAULT NULL, -- Modified by svuppala on 13-OCT-2004 wr.t. FA 134 CL4 Change origination
126 x_lock_awd_flag IN VARCHAR2 DEFAULT NULL,
127 x_lock_coa_flag IN VARCHAR2 DEFAULT NULL
128
129 );
130
131 PROCEDURE lock_row (
132 x_rowid IN VARCHAR2,
133 x_base_id IN NUMBER,
134 x_ci_cal_type IN VARCHAR2,
135 x_person_id IN NUMBER,
136 x_ci_sequence_number IN NUMBER,
137 x_org_id IN NUMBER,
138 x_coa_pending IN VARCHAR2,
139 x_verification_process_run IN VARCHAR2,
140 x_inst_verif_status_date IN DATE,
141 x_manual_verif_flag IN VARCHAR2,
142 x_fed_verif_status IN VARCHAR2,
143 x_fed_verif_status_date IN DATE,
144 x_inst_verif_status IN VARCHAR2,
145 x_nslds_eligible IN VARCHAR2,
146 x_ede_correction_batch_id IN VARCHAR2, -- Modified by rbezawad on 22-Jun-2001 w.r.t. Bug ID: 1821811
147 x_fa_process_status_date IN DATE,
148 x_isir_corr_status IN VARCHAR2,
149 x_isir_corr_status_date IN DATE,
150 x_isir_status IN VARCHAR2,
151 x_isir_status_date IN DATE,
152 x_coa_code_f IN VARCHAR2,
153 x_coa_code_i IN VARCHAR2,
154 x_coa_f IN NUMBER,
155 x_coa_i IN NUMBER,
156 x_disbursement_hold IN VARCHAR2,
157 x_fa_process_status IN VARCHAR2,
158 x_notification_status IN VARCHAR2,
159 x_notification_status_date IN DATE,
160 x_packaging_hold IN VARCHAR2 DEFAULT NULL , -- As part of FA 101 SAP Obsoletion
161 x_packaging_status IN VARCHAR2,
162 x_packaging_status_date IN DATE,
163 x_total_package_accepted IN NUMBER,
164 x_total_package_offered IN NUMBER,
165 x_admstruct_id IN VARCHAR2,
166 x_admsegment_1 IN VARCHAR2,
167 x_admsegment_2 IN VARCHAR2,
168 x_admsegment_3 IN VARCHAR2,
169 x_admsegment_4 IN VARCHAR2,
170 x_admsegment_5 IN VARCHAR2,
171 x_admsegment_6 IN VARCHAR2,
172 x_admsegment_7 IN VARCHAR2,
173 x_admsegment_8 IN VARCHAR2,
174 x_admsegment_9 IN VARCHAR2,
175 x_admsegment_10 IN VARCHAR2,
176 x_admsegment_11 IN VARCHAR2,
177 x_admsegment_12 IN VARCHAR2,
178 x_admsegment_13 IN VARCHAR2,
179 x_admsegment_14 IN VARCHAR2,
180 x_admsegment_15 IN VARCHAR2,
181 x_admsegment_16 IN VARCHAR2,
182 x_admsegment_17 IN VARCHAR2,
183 x_admsegment_18 IN VARCHAR2,
184 x_admsegment_19 IN VARCHAR2,
185 x_admsegment_20 IN VARCHAR2,
186 x_packstruct_id IN VARCHAR2,
187 x_packsegment_1 IN VARCHAR2,
188 x_packsegment_2 IN VARCHAR2,
189 x_packsegment_3 IN VARCHAR2,
190 x_packsegment_4 IN VARCHAR2,
191 x_packsegment_5 IN VARCHAR2,
192 x_packsegment_6 IN VARCHAR2,
193 x_packsegment_7 IN VARCHAR2,
194 x_packsegment_8 IN VARCHAR2,
195 x_packsegment_9 IN VARCHAR2,
196 x_packsegment_10 IN VARCHAR2,
197 x_packsegment_11 IN VARCHAR2,
198 x_packsegment_12 IN VARCHAR2,
199 x_packsegment_13 IN VARCHAR2,
200 x_packsegment_14 IN VARCHAR2,
201 x_packsegment_15 IN VARCHAR2,
202 x_packsegment_16 IN VARCHAR2,
203 x_packsegment_17 IN VARCHAR2,
204 x_packsegment_18 IN VARCHAR2,
205 x_packsegment_19 IN VARCHAR2,
206 x_packsegment_20 IN VARCHAR2,
207 x_miscstruct_id IN VARCHAR2,
208 x_miscsegment_1 IN VARCHAR2,
209 x_miscsegment_2 IN VARCHAR2,
210 x_miscsegment_3 IN VARCHAR2,
211 x_miscsegment_4 IN VARCHAR2,
212 x_miscsegment_5 IN VARCHAR2,
213 x_miscsegment_6 IN VARCHAR2,
214 x_miscsegment_7 IN VARCHAR2,
215 x_miscsegment_8 IN VARCHAR2,
216 x_miscsegment_9 IN VARCHAR2,
217 x_miscsegment_10 IN VARCHAR2,
218 x_miscsegment_11 IN VARCHAR2,
219 x_miscsegment_12 IN VARCHAR2,
220 x_miscsegment_13 IN VARCHAR2,
221 x_miscsegment_14 IN VARCHAR2,
222 x_miscsegment_15 IN VARCHAR2,
223 x_miscsegment_16 IN VARCHAR2,
224 x_miscsegment_17 IN VARCHAR2,
225 x_miscsegment_18 IN VARCHAR2,
226 x_miscsegment_19 IN VARCHAR2,
227 x_miscsegment_20 IN VARCHAR2,
228 x_prof_judgement_flg IN VARCHAR2,
229 x_nslds_data_override_flg IN VARCHAR2,
230 x_target_group IN VARCHAR2,
231 x_coa_fixed IN NUMBER,
232 x_coa_pell IN NUMBER,
233 x_profile_status IN VARCHAR2 DEFAULT NULL,
234 x_profile_status_date IN DATE DEFAULT NULL,
235 x_profile_fc IN NUMBER DEFAULT NULL,
236 x_tolerance_amount IN NUMBER DEFAULT NULL, --Modified by kkillams on 28- June-2001 w.r.t. bug 1794114
237 x_manual_disb_hold IN VARCHAR2 DEFAULT NULL,
238 x_pell_alt_expense IN NUMBER DEFAULT NULL,
239 x_assoc_org_num IN NUMBER DEFAULT NULL, --Modified by ugummall on 25-SEP-2003 w.r.t FA 126 Multiple FA Offices
240 x_award_fmly_contribution_type IN VARCHAR2 DEFAULT NULL, --Modified by rasahoo on 17-NOV-2003 w.r.t FA 128 ISIR update 20004-05
241 x_isir_locked_by IN VARCHAR2 DEFAULT NULL,
242 x_adnl_unsub_loan_elig_flag IN VARCHAR2 DEFAULT NULL, -- Modified by svuppala on 13-OCT-2004 wr.t. FA 134 CL4 Change origination
243 x_lock_awd_flag IN VARCHAR2 DEFAULT NULL,
244 x_lock_coa_flag IN VARCHAR2 DEFAULT NULL
245
246 );
247
248 PROCEDURE update_row (
249 x_rowid IN VARCHAR2,
250 x_base_id IN NUMBER,
251 x_ci_cal_type IN VARCHAR2,
252 x_person_id IN NUMBER,
253 x_ci_sequence_number IN NUMBER,
254 x_org_id IN NUMBER,
255 x_coa_pending IN VARCHAR2,
256 x_verification_process_run IN VARCHAR2,
257 x_inst_verif_status_date IN DATE,
258 x_manual_verif_flag IN VARCHAR2,
259 x_fed_verif_status IN VARCHAR2,
260 x_fed_verif_status_date IN DATE,
261 x_inst_verif_status IN VARCHAR2,
262 x_nslds_eligible IN VARCHAR2,
263 x_ede_correction_batch_id IN VARCHAR2, -- Modified by rbezawad on 22-Jun-2001 w.r.t. Bug ID: 1821811
264 x_fa_process_status_date IN DATE,
265 x_isir_corr_status IN VARCHAR2,
266 x_isir_corr_status_date IN DATE,
267 x_isir_status IN VARCHAR2,
268 x_isir_status_date IN DATE,
269 x_coa_code_f IN VARCHAR2,
270 x_coa_code_i IN VARCHAR2,
271 x_coa_f IN NUMBER,
272 x_coa_i IN NUMBER,
273 x_disbursement_hold IN VARCHAR2,
274 x_fa_process_status IN VARCHAR2,
275 x_notification_status IN VARCHAR2,
276 x_notification_status_date IN DATE,
277 x_packaging_hold IN VARCHAR2 DEFAULT NULL , -- As part of FA 101 SAP Obsoletion
278 x_packaging_status IN VARCHAR2,
279 x_packaging_status_date IN DATE,
280 x_total_package_accepted IN NUMBER,
281 x_total_package_offered IN NUMBER,
282 x_admstruct_id IN VARCHAR2,
286 x_admsegment_4 IN VARCHAR2,
283 x_admsegment_1 IN VARCHAR2,
284 x_admsegment_2 IN VARCHAR2,
285 x_admsegment_3 IN VARCHAR2,
287 x_admsegment_5 IN VARCHAR2,
288 x_admsegment_6 IN VARCHAR2,
289 x_admsegment_7 IN VARCHAR2,
290 x_admsegment_8 IN VARCHAR2,
291 x_admsegment_9 IN VARCHAR2,
292 x_admsegment_10 IN VARCHAR2,
293 x_admsegment_11 IN VARCHAR2,
294 x_admsegment_12 IN VARCHAR2,
295 x_admsegment_13 IN VARCHAR2,
296 x_admsegment_14 IN VARCHAR2,
297 x_admsegment_15 IN VARCHAR2,
298 x_admsegment_16 IN VARCHAR2,
299 x_admsegment_17 IN VARCHAR2,
300 x_admsegment_18 IN VARCHAR2,
301 x_admsegment_19 IN VARCHAR2,
302 x_admsegment_20 IN VARCHAR2,
303 x_packstruct_id IN VARCHAR2,
304 x_packsegment_1 IN VARCHAR2,
305 x_packsegment_2 IN VARCHAR2,
306 x_packsegment_3 IN VARCHAR2,
307 x_packsegment_4 IN VARCHAR2,
308 x_packsegment_5 IN VARCHAR2,
309 x_packsegment_6 IN VARCHAR2,
310 x_packsegment_7 IN VARCHAR2,
311 x_packsegment_8 IN VARCHAR2,
312 x_packsegment_9 IN VARCHAR2,
313 x_packsegment_10 IN VARCHAR2,
314 x_packsegment_11 IN VARCHAR2,
315 x_packsegment_12 IN VARCHAR2,
316 x_packsegment_13 IN VARCHAR2,
317 x_packsegment_14 IN VARCHAR2,
318 x_packsegment_15 IN VARCHAR2,
319 x_packsegment_16 IN VARCHAR2,
320 x_packsegment_17 IN VARCHAR2,
321 x_packsegment_18 IN VARCHAR2,
322 x_packsegment_19 IN VARCHAR2,
323 x_packsegment_20 IN VARCHAR2,
324 x_miscstruct_id IN VARCHAR2,
325 x_miscsegment_1 IN VARCHAR2,
326 x_miscsegment_2 IN VARCHAR2,
327 x_miscsegment_3 IN VARCHAR2,
328 x_miscsegment_4 IN VARCHAR2,
329 x_miscsegment_5 IN VARCHAR2,
330 x_miscsegment_6 IN VARCHAR2,
331 x_miscsegment_7 IN VARCHAR2,
332 x_miscsegment_8 IN VARCHAR2,
333 x_miscsegment_9 IN VARCHAR2,
334 x_miscsegment_10 IN VARCHAR2,
335 x_miscsegment_11 IN VARCHAR2,
336 x_miscsegment_12 IN VARCHAR2,
337 x_miscsegment_13 IN VARCHAR2,
338 x_miscsegment_14 IN VARCHAR2,
339 x_miscsegment_15 IN VARCHAR2,
340 x_miscsegment_16 IN VARCHAR2,
341 x_miscsegment_17 IN VARCHAR2,
342 x_miscsegment_18 IN VARCHAR2,
343 x_miscsegment_19 IN VARCHAR2,
344 x_miscsegment_20 IN VARCHAR2,
345 x_prof_judgement_flg IN VARCHAR2,
346 x_nslds_data_override_flg IN VARCHAR2,
347 x_target_group IN VARCHAR2,
348 x_coa_fixed IN NUMBER,
349 x_coa_pell IN NUMBER,
350 x_mode IN VARCHAR2 DEFAULT 'R' ,
351 x_profile_status IN VARCHAR2 DEFAULT NULL,
352 x_profile_status_date IN DATE DEFAULT NULL,
353 x_profile_fc IN NUMBER DEFAULT NULL,
354 x_tolerance_amount IN NUMBER DEFAULT NULL, --Modified by kkillams on 28- June-2001 w.r.t. bug 1794114
355 x_manual_disb_hold IN VARCHAR2 DEFAULT NULL,
356 x_pell_alt_expense IN NUMBER DEFAULT NULL,
357 x_assoc_org_num IN NUMBER DEFAULT NULL, --Modified by ugummall on 25-SEP-2003 w.r.t FA 126 Multiple FA Offices
358 x_award_fmly_contribution_type IN VARCHAR2 DEFAULT NULL, --Modified by rasahoo on 17-NOV-2003 w.r.t FA 128 ISIR update 20004-05
359 x_isir_locked_by IN VARCHAR2 DEFAULT NULL,
360 x_adnl_unsub_loan_elig_flag IN VARCHAR2 DEFAULT NULL, -- Modified by svuppala on 13-OCT-2004 wr.t. FA 134 CL4 Change origination
361 x_lock_awd_flag IN VARCHAR2 DEFAULT NULL,
362 x_lock_coa_flag IN VARCHAR2 DEFAULT NULL
363
364
365 );
366
367 PROCEDURE add_row (
368 x_rowid IN OUT NOCOPY VARCHAR2,
369 x_base_id IN OUT NOCOPY NUMBER,
370 x_ci_cal_type IN VARCHAR2,
371 x_person_id IN NUMBER,
372 x_ci_sequence_number IN NUMBER,
373 x_org_id IN NUMBER,
374 x_coa_pending IN VARCHAR2,
378 x_fed_verif_status IN VARCHAR2,
375 x_verification_process_run IN VARCHAR2,
376 x_inst_verif_status_date IN DATE,
377 x_manual_verif_flag IN VARCHAR2,
379 x_fed_verif_status_date IN DATE,
380 x_inst_verif_status IN VARCHAR2,
381 x_nslds_eligible IN VARCHAR2,
382 x_ede_correction_batch_id IN VARCHAR2, -- Modified by rbezawad on 22-Jun-2001 w.r.t. Bug ID: 1821811
383 x_fa_process_status_date IN DATE,
384 x_isir_corr_status IN VARCHAR2,
385 x_isir_corr_status_date IN DATE,
386 x_isir_status IN VARCHAR2,
387 x_isir_status_date IN DATE,
388 x_coa_code_f IN VARCHAR2,
389 x_coa_code_i IN VARCHAR2,
390 x_coa_f IN NUMBER,
391 x_coa_i IN NUMBER,
392 x_disbursement_hold IN VARCHAR2,
393 x_fa_process_status IN VARCHAR2,
394 x_notification_status IN VARCHAR2,
395 x_notification_status_date IN DATE,
396 x_packaging_hold IN VARCHAR2 DEFAULT NULL ,-- As part of FA 101 SAP Obsoletion
397 x_packaging_status IN VARCHAR2,
398 x_packaging_status_date IN DATE,
399 x_total_package_accepted IN NUMBER,
400 x_total_package_offered IN NUMBER,
401 x_admstruct_id IN VARCHAR2,
402 x_admsegment_1 IN VARCHAR2,
403 x_admsegment_2 IN VARCHAR2,
404 x_admsegment_3 IN VARCHAR2,
405 x_admsegment_4 IN VARCHAR2,
406 x_admsegment_5 IN VARCHAR2,
407 x_admsegment_6 IN VARCHAR2,
408 x_admsegment_7 IN VARCHAR2,
409 x_admsegment_8 IN VARCHAR2,
410 x_admsegment_9 IN VARCHAR2,
411 x_admsegment_10 IN VARCHAR2,
412 x_admsegment_11 IN VARCHAR2,
413 x_admsegment_12 IN VARCHAR2,
414 x_admsegment_13 IN VARCHAR2,
415 x_admsegment_14 IN VARCHAR2,
416 x_admsegment_15 IN VARCHAR2,
417 x_admsegment_16 IN VARCHAR2,
418 x_admsegment_17 IN VARCHAR2,
419 x_admsegment_18 IN VARCHAR2,
420 x_admsegment_19 IN VARCHAR2,
421 x_admsegment_20 IN VARCHAR2,
422 x_packstruct_id IN VARCHAR2,
423 x_packsegment_1 IN VARCHAR2,
424 x_packsegment_2 IN VARCHAR2,
425 x_packsegment_3 IN VARCHAR2,
426 x_packsegment_4 IN VARCHAR2,
427 x_packsegment_5 IN VARCHAR2,
428 x_packsegment_6 IN VARCHAR2,
429 x_packsegment_7 IN VARCHAR2,
430 x_packsegment_8 IN VARCHAR2,
431 x_packsegment_9 IN VARCHAR2,
432 x_packsegment_10 IN VARCHAR2,
433 x_packsegment_11 IN VARCHAR2,
434 x_packsegment_12 IN VARCHAR2,
435 x_packsegment_13 IN VARCHAR2,
436 x_packsegment_14 IN VARCHAR2,
437 x_packsegment_15 IN VARCHAR2,
438 x_packsegment_16 IN VARCHAR2,
439 x_packsegment_17 IN VARCHAR2,
440 x_packsegment_18 IN VARCHAR2,
441 x_packsegment_19 IN VARCHAR2,
442 x_packsegment_20 IN VARCHAR2,
443 x_miscstruct_id IN VARCHAR2,
444 x_miscsegment_1 IN VARCHAR2,
445 x_miscsegment_2 IN VARCHAR2,
446 x_miscsegment_3 IN VARCHAR2,
447 x_miscsegment_4 IN VARCHAR2,
448 x_miscsegment_5 IN VARCHAR2,
449 x_miscsegment_6 IN VARCHAR2,
450 x_miscsegment_7 IN VARCHAR2,
451 x_miscsegment_8 IN VARCHAR2,
452 x_miscsegment_9 IN VARCHAR2,
453 x_miscsegment_10 IN VARCHAR2,
454 x_miscsegment_11 IN VARCHAR2,
455 x_miscsegment_12 IN VARCHAR2,
456 x_miscsegment_13 IN VARCHAR2,
457 x_miscsegment_14 IN VARCHAR2,
458 x_miscsegment_15 IN VARCHAR2,
459 x_miscsegment_16 IN VARCHAR2,
460 x_miscsegment_17 IN VARCHAR2,
461 x_miscsegment_18 IN VARCHAR2,
462 x_miscsegment_19 IN VARCHAR2,
463 x_miscsegment_20 IN VARCHAR2,
464 x_prof_judgement_flg IN VARCHAR2,
465 x_nslds_data_override_flg IN VARCHAR2,
466 x_target_group IN VARCHAR2,
467 x_coa_fixed IN NUMBER,
468 x_coa_pell IN NUMBER,
472 x_profile_fc IN NUMBER DEFAULT NULL,
469 x_mode IN VARCHAR2 DEFAULT 'R' ,
470 x_profile_status IN VARCHAR2 DEFAULT NULL,
471 x_profile_status_date IN DATE DEFAULT NULL,
473 x_tolerance_amount IN NUMBER DEFAULT NULL, --Modified by kkillams on 28- June-2001 w.r.t. bug 1794114
474 x_manual_disb_hold IN VARCHAR2 DEFAULT NULL,
475 x_pell_alt_expense IN NUMBER DEFAULT NULL,
476 x_assoc_org_num IN NUMBER DEFAULT NULL, --Modified by ugummall on 25-SEP-2003 w.r.t FA 126 Multiple FA Offices
477 x_award_fmly_contribution_type IN VARCHAR2 DEFAULT NULL, --Modified by rasahoo on 17-NOV-2003 w.r.t FA 128 ISIR update 20004-05
478 x_isir_locked_by IN VARCHAR2 DEFAULT NULL,
479 x_adnl_unsub_loan_elig_flag IN VARCHAR2 DEFAULT NULL, -- Modified by svuppala on 13-OCT-2004 wr.t. FA 134 CL4 Change origination
480 x_lock_awd_flag IN VARCHAR2 DEFAULT NULL,
481 x_lock_coa_flag IN VARCHAR2 DEFAULT NULL
482
483 );
484
485 PROCEDURE delete_row (
486 x_rowid IN VARCHAR2
487 );
488
489 FUNCTION get_pk_for_validation (
490 x_base_id IN NUMBER
491 ) RETURN BOOLEAN;
492
493 FUNCTION get_uk_for_validation (
494 x_ci_cal_type IN VARCHAR2,
495 x_person_id IN NUMBER,
496 x_ci_sequence_number IN NUMBER
497 ) RETURN BOOLEAN;
498
499 PROCEDURE get_fk_igs_ca_inst (
500 x_cal_type IN VARCHAR2,
501 x_sequence_number IN NUMBER
502 );
503
504 PROCEDURE before_dml (
505 p_action IN VARCHAR2,
506 x_rowid IN VARCHAR2 DEFAULT NULL,
507 x_base_id IN NUMBER DEFAULT NULL,
508 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
509 x_person_id IN NUMBER DEFAULT NULL,
510 x_ci_sequence_number IN NUMBER DEFAULT NULL,
511 x_org_id IN NUMBER DEFAULT NULL,
512 x_coa_pending IN VARCHAR2 DEFAULT NULL,
513 x_verification_process_run IN VARCHAR2 DEFAULT NULL,
514 x_inst_verif_status_date IN DATE DEFAULT NULL,
515 x_manual_verif_flag IN VARCHAR2 DEFAULT NULL,
516 x_fed_verif_status IN VARCHAR2 DEFAULT NULL,
517 x_fed_verif_status_date IN DATE DEFAULT NULL,
518 x_inst_verif_status IN VARCHAR2 DEFAULT NULL,
519 x_nslds_eligible IN VARCHAR2 DEFAULT NULL,
520 x_ede_correction_batch_id IN VARCHAR2 DEFAULT NULL, -- Modified by rbezawad on 22-Jun-2001 w.r.t. Bug ID: 1821811
521 x_fa_process_status_date IN DATE DEFAULT NULL,
522 x_isir_corr_status IN VARCHAR2 DEFAULT NULL,
523 x_isir_corr_status_date IN DATE DEFAULT NULL,
524 x_isir_status IN VARCHAR2 DEFAULT NULL,
525 x_isir_status_date IN DATE DEFAULT NULL,
526 x_coa_code_f IN VARCHAR2 DEFAULT NULL,
527 x_coa_code_i IN VARCHAR2 DEFAULT NULL,
528 x_coa_f IN NUMBER DEFAULT NULL,
529 x_coa_i IN NUMBER DEFAULT NULL,
530 x_disbursement_hold IN VARCHAR2 DEFAULT NULL,
531 x_fa_process_status IN VARCHAR2 DEFAULT NULL,
532 x_notification_status IN VARCHAR2 DEFAULT NULL,
533 x_notification_status_date IN DATE DEFAULT NULL,
534 x_packaging_hold IN VARCHAR2 DEFAULT NULL,
535 x_packaging_status IN VARCHAR2 DEFAULT NULL,
536 x_packaging_status_date IN DATE DEFAULT NULL,
537 x_total_package_accepted IN NUMBER DEFAULT NULL,
538 x_total_package_offered IN NUMBER DEFAULT NULL,
539 x_admstruct_id IN VARCHAR2 DEFAULT NULL,
540 x_admsegment_1 IN VARCHAR2 DEFAULT NULL,
541 x_admsegment_2 IN VARCHAR2 DEFAULT NULL,
542 x_admsegment_3 IN VARCHAR2 DEFAULT NULL,
543 x_admsegment_4 IN VARCHAR2 DEFAULT NULL,
544 x_admsegment_5 IN VARCHAR2 DEFAULT NULL,
545 x_admsegment_6 IN VARCHAR2 DEFAULT NULL,
546 x_admsegment_7 IN VARCHAR2 DEFAULT NULL,
547 x_admsegment_8 IN VARCHAR2 DEFAULT NULL,
548 x_admsegment_9 IN VARCHAR2 DEFAULT NULL,
549 x_admsegment_10 IN VARCHAR2 DEFAULT NULL,
550 x_admsegment_11 IN VARCHAR2 DEFAULT NULL,
551 x_admsegment_12 IN VARCHAR2 DEFAULT NULL,
552 x_admsegment_13 IN VARCHAR2 DEFAULT NULL,
556 x_admsegment_17 IN VARCHAR2 DEFAULT NULL,
553 x_admsegment_14 IN VARCHAR2 DEFAULT NULL,
554 x_admsegment_15 IN VARCHAR2 DEFAULT NULL,
555 x_admsegment_16 IN VARCHAR2 DEFAULT NULL,
557 x_admsegment_18 IN VARCHAR2 DEFAULT NULL,
558 x_admsegment_19 IN VARCHAR2 DEFAULT NULL,
559 x_admsegment_20 IN VARCHAR2 DEFAULT NULL,
560 x_packstruct_id IN VARCHAR2 DEFAULT NULL,
561 x_packsegment_1 IN VARCHAR2 DEFAULT NULL,
562 x_packsegment_2 IN VARCHAR2 DEFAULT NULL,
563 x_packsegment_3 IN VARCHAR2 DEFAULT NULL,
564 x_packsegment_4 IN VARCHAR2 DEFAULT NULL,
565 x_packsegment_5 IN VARCHAR2 DEFAULT NULL,
566 x_packsegment_6 IN VARCHAR2 DEFAULT NULL,
567 x_packsegment_7 IN VARCHAR2 DEFAULT NULL,
568 x_packsegment_8 IN VARCHAR2 DEFAULT NULL,
569 x_packsegment_9 IN VARCHAR2 DEFAULT NULL,
570 x_packsegment_10 IN VARCHAR2 DEFAULT NULL,
571 x_packsegment_11 IN VARCHAR2 DEFAULT NULL,
572 x_packsegment_12 IN VARCHAR2 DEFAULT NULL,
573 x_packsegment_13 IN VARCHAR2 DEFAULT NULL,
574 x_packsegment_14 IN VARCHAR2 DEFAULT NULL,
575 x_packsegment_15 IN VARCHAR2 DEFAULT NULL,
576 x_packsegment_16 IN VARCHAR2 DEFAULT NULL,
577 x_packsegment_17 IN VARCHAR2 DEFAULT NULL,
578 x_packsegment_18 IN VARCHAR2 DEFAULT NULL,
579 x_packsegment_19 IN VARCHAR2 DEFAULT NULL,
580 x_packsegment_20 IN VARCHAR2 DEFAULT NULL,
581 x_miscstruct_id IN VARCHAR2 DEFAULT NULL,
582 x_miscsegment_1 IN VARCHAR2 DEFAULT NULL,
583 x_miscsegment_2 IN VARCHAR2 DEFAULT NULL,
584 x_miscsegment_3 IN VARCHAR2 DEFAULT NULL,
585 x_miscsegment_4 IN VARCHAR2 DEFAULT NULL,
586 x_miscsegment_5 IN VARCHAR2 DEFAULT NULL,
587 x_miscsegment_6 IN VARCHAR2 DEFAULT NULL,
588 x_miscsegment_7 IN VARCHAR2 DEFAULT NULL,
589 x_miscsegment_8 IN VARCHAR2 DEFAULT NULL,
590 x_miscsegment_9 IN VARCHAR2 DEFAULT NULL,
591 x_miscsegment_10 IN VARCHAR2 DEFAULT NULL,
592 x_miscsegment_11 IN VARCHAR2 DEFAULT NULL,
593 x_miscsegment_12 IN VARCHAR2 DEFAULT NULL,
594 x_miscsegment_13 IN VARCHAR2 DEFAULT NULL,
595 x_miscsegment_14 IN VARCHAR2 DEFAULT NULL,
596 x_miscsegment_15 IN VARCHAR2 DEFAULT NULL,
597 x_miscsegment_16 IN VARCHAR2 DEFAULT NULL,
598 x_miscsegment_17 IN VARCHAR2 DEFAULT NULL,
599 x_miscsegment_18 IN VARCHAR2 DEFAULT NULL,
600 x_miscsegment_19 IN VARCHAR2 DEFAULT NULL,
601 x_miscsegment_20 IN VARCHAR2 DEFAULT NULL,
602 x_prof_judgement_flg IN VARCHAR2 DEFAULT NULL,
603 x_nslds_data_override_flg IN VARCHAR2 DEFAULT NULL,
604 x_target_group IN VARCHAR2 DEFAULT NULL,
605 x_coa_fixed IN NUMBER DEFAULT NULL,
606 x_coa_pell IN NUMBER DEFAULT NULL,
607 x_profile_status IN VARCHAR2 DEFAULT NULL,
608 x_profile_status_date IN DATE DEFAULT NULL,
612 x_created_by IN NUMBER DEFAULT NULL,
609 x_profile_fc IN NUMBER DEFAULT NULL,
610 x_tolerance_amount IN NUMBER DEFAULT NULL, --Modified by kkillams on 28- June-2001 w.r.t. bug 1794114
611 x_creation_date IN DATE DEFAULT NULL,
613 x_last_update_date IN DATE DEFAULT NULL,
614 x_last_updated_by IN NUMBER DEFAULT NULL,
615 x_last_update_login IN NUMBER DEFAULT NULL,
616 x_manual_disb_hold IN VARCHAR2 DEFAULT NULL,
617 x_pell_alt_expense IN NUMBER DEFAULT NULL,
618 x_assoc_org_num IN NUMBER DEFAULT NULL, --Modified by ugummall on 25-SEP-2003 w.r.t FA 126 Multiple FA Offices
619 x_award_fmly_contribution_type IN VARCHAR2 DEFAULT NULL, --Modified by rasahoo on 17-NOV-2003 w.r.t FA 128 ISIR update 20004-05
620 x_isir_locked_by IN VARCHAR2 DEFAULT NULL,
621 x_adnl_unsub_loan_elig_flag IN VARCHAR2 DEFAULT NULL, -- Modified by svuppala on 13-OCT-2004 wr.t. FA 134 CL4 Change origination
622 x_lock_awd_flag IN VARCHAR2 DEFAULT NULL,
623 x_lock_coa_flag IN VARCHAR2 DEFAULT NULL
624
625 );
626
627 END igf_ap_fa_base_rec_pkg;