1 PACKAGE igf_aw_fund_mast_pkg AS
2 /* $Header: IGFWI11S.pls 120.3 2005/07/15 09:59:42 appldev ship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_fund_id IN OUT NOCOPY NUMBER,
7 x_fund_code IN VARCHAR2,
8 x_ci_cal_type IN VARCHAR2,
9 x_ci_sequence_number IN NUMBER,
10 x_description IN VARCHAR2,
11 x_discontinue_fund IN VARCHAR2,
12 x_entitlement IN VARCHAR2,
13 x_auto_pkg IN VARCHAR2,
14 x_self_help IN VARCHAR2,
15 x_allow_man_pkg IN VARCHAR2,
16 x_update_need IN VARCHAR2,
17 x_disburse_fund IN VARCHAR2,
18 x_available_amt IN NUMBER,
19 x_offered_amt IN NUMBER,
20 x_pending_amt IN NUMBER,
21 x_accepted_amt IN NUMBER,
22 x_declined_amt IN NUMBER,
23 x_cancelled_amt IN NUMBER,
24 x_remaining_amt IN NUMBER,
25 x_enrollment_status IN VARCHAR2,
26 x_prn_award_letter IN VARCHAR2,
27 x_over_award_amt IN NUMBER,
28 x_over_award_perct IN NUMBER,
29 x_min_award_amt IN NUMBER,
30 x_max_award_amt IN NUMBER,
31 x_max_yearly_amt IN NUMBER,
32 x_max_life_amt IN NUMBER,
33 x_max_life_term IN NUMBER,
34 x_fm_fc_methd IN VARCHAR2,
35 x_roundoff_fact IN VARCHAR2,
36 x_replace_fc IN VARCHAR2,
37 x_allow_overaward IN VARCHAR2,
38 x_pckg_awd_stat IN VARCHAR2,
39 x_org_record_req IN VARCHAR2,
40 x_disb_record_req IN VARCHAR2,
41 x_prom_note_req IN VARCHAR2,
42 x_min_num_disb IN NUMBER,
43 x_max_num_disb IN NUMBER,
44 x_fee_type IN VARCHAR2,
45 x_total_offered IN NUMBER,
46 x_total_accepted IN NUMBER,
47 x_total_declined IN NUMBER,
48 x_total_revoked IN NUMBER,
49 x_total_cancelled IN NUMBER,
50 x_total_disbursed IN NUMBER,
51 x_total_committed IN NUMBER,
52 x_committed_amt IN NUMBER,
53 x_disbursed_amt IN NUMBER,
54 x_awd_notice_txt IN VARCHAR2,
55 x_attribute_category IN VARCHAR2,
56 x_attribute1 IN VARCHAR2,
57 x_attribute2 IN VARCHAR2,
58 x_attribute3 IN VARCHAR2,
59 x_attribute4 IN VARCHAR2,
60 x_attribute5 IN VARCHAR2,
61 x_attribute6 IN VARCHAR2,
62 x_attribute7 IN VARCHAR2,
63 x_attribute8 IN VARCHAR2,
64 x_attribute9 IN VARCHAR2,
65 x_attribute10 IN VARCHAR2,
66 x_attribute11 IN VARCHAR2,
67 x_attribute12 IN VARCHAR2,
68 x_attribute13 IN VARCHAR2,
69 x_attribute14 IN VARCHAR2,
70 x_attribute15 IN VARCHAR2,
71 x_attribute16 IN VARCHAR2,
72 x_attribute17 IN VARCHAR2,
73 x_attribute18 IN VARCHAR2,
74 x_attribute19 IN VARCHAR2,
75 x_attribute20 IN VARCHAR2,
76 x_disb_verf_da IN VARCHAR2 DEFAULT NULL,
77 x_fund_exp_da IN VARCHAR2 DEFAULT NULL,
78 x_nslds_disb_da IN VARCHAR2 DEFAULT NULL,
79 x_disb_exp_da IN VARCHAR2 DEFAULT NULL,
80 x_fund_recv_reqd IN VARCHAR2 DEFAULT NULL,
81 x_show_on_bill IN VARCHAR2 DEFAULT NULL,
82 x_bill_desc IN VARCHAR2 DEFAULT NULL,
83 x_credit_type_id IN NUMBER DEFAULT NULL,
84 x_spnsr_ref_num IN VARCHAR2 DEFAULT NULL,
85 x_party_id IN VARCHAR2 DEFAULT NULL,
86 x_spnsr_fee_type IN VARCHAR2 DEFAULT NULL,
87 x_min_credit_points IN NUMBER DEFAULT NULL,
88 x_group_id IN NUMBER DEFAULT NULL,
89 x_spnsr_attribute_category IN VARCHAR2 DEFAULT NULL,
90 x_spnsr_attribute1 IN VARCHAR2 DEFAULT NULL,
91 x_spnsr_attribute2 IN VARCHAR2 DEFAULT NULL,
92 x_spnsr_attribute3 IN VARCHAR2 DEFAULT NULL,
93 x_spnsr_attribute4 IN VARCHAR2 DEFAULT NULL,
94 x_spnsr_attribute5 IN VARCHAR2 DEFAULT NULL,
95 x_spnsr_attribute6 IN VARCHAR2 DEFAULT NULL,
96 x_spnsr_attribute7 IN VARCHAR2 DEFAULT NULL,
97 x_spnsr_attribute8 IN VARCHAR2 DEFAULT NULL,
98 x_spnsr_attribute9 IN VARCHAR2 DEFAULT NULL,
99 x_spnsr_attribute10 IN VARCHAR2 DEFAULT NULL,
100 x_spnsr_attribute11 IN VARCHAR2 DEFAULT NULL,
101 x_spnsr_attribute12 IN VARCHAR2 DEFAULT NULL,
102 x_spnsr_attribute13 IN VARCHAR2 DEFAULT NULL,
103 x_spnsr_attribute14 IN VARCHAR2 DEFAULT NULL,
104 x_spnsr_attribute15 IN VARCHAR2 DEFAULT NULL,
105 x_spnsr_attribute16 IN VARCHAR2 DEFAULT NULL,
106 x_spnsr_attribute17 IN VARCHAR2 DEFAULT NULL,
107 x_spnsr_attribute18 IN VARCHAR2 DEFAULT NULL,
108 x_spnsr_attribute19 IN VARCHAR2 DEFAULT NULL,
109 x_spnsr_attribute20 IN VARCHAR2 DEFAULT NULL,
110 x_threshold_perct IN NUMBER DEFAULT NULL,
111 x_threshold_value IN NUMBER DEFAULT NULL,
112 x_ver_app_stat_override IN VARCHAR2 DEFAULT NULL,
113 x_gift_aid IN VARCHAR2 DEFAULT NULL,
114 x_send_without_doc IN VARCHAR2 DEFAULT NULL, -- Added as part of Bug # 2758812
115 x_mode IN VARCHAR2 DEFAULT 'R',
116 x_re_pkg_verif_flag IN VARCHAR2 DEFAULT NULL,
117 x_donot_repkg_if_code IN VARCHAR2 DEFAULT NULL,
118 x_lock_award_flag IN VARCHAR2 DEFAULT NULL,
119 x_disb_rounding_code IN VARCHAR2 DEFAULT NULL,
120 x_view_only_flag IN VARCHAR2 DEFAULT NULL,
121 x_accept_less_amt_flag IN VARCHAR2 DEFAULT NULL,
122 x_allow_inc_post_accept_flag IN VARCHAR2 DEFAULT NULL,
123 x_min_increase_amt IN NUMBER DEFAULT NULL,
124 x_allow_dec_post_accept_flag IN VARCHAR2 DEFAULT NULL,
125 x_min_decrease_amt IN NUMBER DEFAULT NULL,
126 x_allow_decln_post_accept_flag IN VARCHAR2 DEFAULT NULL,
127 x_status_after_decline IN VARCHAR2 DEFAULT NULL,
128 x_fund_information_txt IN VARCHAR2 DEFAULT NULL
129 );
130
131 PROCEDURE lock_row (
132 x_rowid IN VARCHAR2,
133 x_fund_id IN NUMBER,
134 x_fund_code IN VARCHAR2,
135 x_ci_cal_type IN VARCHAR2,
136 x_ci_sequence_number IN NUMBER,
137 x_description IN VARCHAR2,
138 x_discontinue_fund IN VARCHAR2,
139 x_entitlement IN VARCHAR2,
140 x_auto_pkg IN VARCHAR2,
141 x_self_help IN VARCHAR2,
142 x_allow_man_pkg IN VARCHAR2,
143 x_update_need IN VARCHAR2,
144 x_disburse_fund IN VARCHAR2,
145 x_available_amt IN NUMBER,
146 x_offered_amt IN NUMBER,
147 x_pending_amt IN NUMBER,
148 x_accepted_amt IN NUMBER,
149 x_declined_amt IN NUMBER,
150 x_cancelled_amt IN NUMBER,
151 x_remaining_amt IN NUMBER,
152 x_enrollment_status IN VARCHAR2,
153 x_prn_award_letter IN VARCHAR2,
154 x_over_award_amt IN NUMBER,
155 x_over_award_perct IN NUMBER,
156 x_min_award_amt IN NUMBER,
157 x_max_award_amt IN NUMBER,
158 x_max_yearly_amt IN NUMBER,
159 x_max_life_amt IN NUMBER,
160 x_max_life_term IN NUMBER,
161 x_fm_fc_methd IN VARCHAR2,
162 x_roundoff_fact IN VARCHAR2,
163 x_replace_fc IN VARCHAR2,
164 x_allow_overaward IN VARCHAR2,
165 x_pckg_awd_stat IN VARCHAR2,
166 x_org_record_req IN VARCHAR2,
167 x_disb_record_req IN VARCHAR2,
168 x_prom_note_req IN VARCHAR2,
169 x_min_num_disb IN NUMBER,
170 x_max_num_disb IN NUMBER,
171 x_fee_type IN VARCHAR2,
172 x_total_offered IN NUMBER,
173 x_total_accepted IN NUMBER,
174 x_total_declined IN NUMBER,
175 x_total_revoked IN NUMBER,
176 x_total_cancelled IN NUMBER,
177 x_total_disbursed IN NUMBER,
178 x_total_committed IN NUMBER,
179 x_committed_amt IN NUMBER,
180 x_disbursed_amt IN NUMBER,
181 x_awd_notice_txt IN VARCHAR2,
182 x_attribute_category IN VARCHAR2,
183 x_attribute1 IN VARCHAR2,
184 x_attribute2 IN VARCHAR2,
185 x_attribute3 IN VARCHAR2,
186 x_attribute4 IN VARCHAR2,
187 x_attribute5 IN VARCHAR2,
188 x_attribute6 IN VARCHAR2,
189 x_attribute7 IN VARCHAR2,
190 x_attribute8 IN VARCHAR2,
191 x_attribute9 IN VARCHAR2,
192 x_attribute10 IN VARCHAR2,
193 x_attribute11 IN VARCHAR2,
194 x_attribute12 IN VARCHAR2,
195 x_attribute13 IN VARCHAR2,
196 x_attribute14 IN VARCHAR2,
197 x_attribute15 IN VARCHAR2,
198 x_attribute16 IN VARCHAR2,
199 x_attribute17 IN VARCHAR2,
200 x_attribute18 IN VARCHAR2,
201 x_attribute19 IN VARCHAR2,
202 x_attribute20 IN VARCHAR2,
203 x_disb_verf_da IN VARCHAR2 DEFAULT NULL,
204 x_fund_exp_da IN VARCHAR2 DEFAULT NULL,
205 x_nslds_disb_da IN VARCHAR2 DEFAULT NULL,
206 x_disb_exp_da IN VARCHAR2 DEFAULT NULL,
207 x_fund_recv_reqd IN VARCHAR2 DEFAULT NULL,
208 x_show_on_bill IN VARCHAR2 DEFAULT NULL,
209 x_bill_desc IN VARCHAR2 DEFAULT NULL,
210 x_credit_type_id IN NUMBER DEFAULT NULL,
211 x_spnsr_ref_num IN VARCHAR2 DEFAULT NULL,
212 x_party_id IN VARCHAR2 DEFAULT NULL,
213 x_spnsr_fee_type IN VARCHAR2 DEFAULT NULL,
214 x_min_credit_points IN NUMBER DEFAULT NULL,
215 x_group_id IN NUMBER DEFAULT NULL,
216 x_spnsr_attribute_category IN VARCHAR2 DEFAULT NULL,
217 x_spnsr_attribute1 IN VARCHAR2 DEFAULT NULL,
218 x_spnsr_attribute2 IN VARCHAR2 DEFAULT NULL,
219 x_spnsr_attribute3 IN VARCHAR2 DEFAULT NULL,
220 x_spnsr_attribute4 IN VARCHAR2 DEFAULT NULL,
221 x_spnsr_attribute5 IN VARCHAR2 DEFAULT NULL,
222 x_spnsr_attribute6 IN VARCHAR2 DEFAULT NULL,
223 x_spnsr_attribute7 IN VARCHAR2 DEFAULT NULL,
224 x_spnsr_attribute8 IN VARCHAR2 DEFAULT NULL,
225 x_spnsr_attribute9 IN VARCHAR2 DEFAULT NULL,
226 x_spnsr_attribute10 IN VARCHAR2 DEFAULT NULL,
227 x_spnsr_attribute11 IN VARCHAR2 DEFAULT NULL,
228 x_spnsr_attribute12 IN VARCHAR2 DEFAULT NULL,
229 x_spnsr_attribute13 IN VARCHAR2 DEFAULT NULL,
230 x_spnsr_attribute14 IN VARCHAR2 DEFAULT NULL,
231 x_spnsr_attribute15 IN VARCHAR2 DEFAULT NULL,
232 x_spnsr_attribute16 IN VARCHAR2 DEFAULT NULL,
233 x_spnsr_attribute17 IN VARCHAR2 DEFAULT NULL,
234 x_spnsr_attribute18 IN VARCHAR2 DEFAULT NULL,
235 x_spnsr_attribute19 IN VARCHAR2 DEFAULT NULL,
236 x_spnsr_attribute20 IN VARCHAR2 DEFAULT NULL,
237 x_threshold_perct IN NUMBER DEFAULT NULL,
238 x_threshold_value IN NUMBER DEFAULT NULL,
239 x_ver_app_stat_override IN VARCHAR2 DEFAULT NULL ,
240 x_gift_aid IN VARCHAR2 DEFAULT NULL,
241 x_send_without_doc IN VARCHAR2 DEFAULT NULL, -- Added as part of Bug # 2758812
242 x_re_pkg_verif_flag IN VARCHAR2 DEFAULT NULL,
243 x_donot_repkg_if_code IN VARCHAR2 DEFAULT NULL,
244 x_lock_award_flag IN VARCHAR2 DEFAULT NULL,
245 x_disb_rounding_code IN VARCHAR2 DEFAULT NULL,
246 x_view_only_flag IN VARCHAR2 DEFAULT NULL,
247 x_accept_less_amt_flag IN VARCHAR2 DEFAULT NULL,
248 x_allow_inc_post_accept_flag IN VARCHAR2 DEFAULT NULL,
249 x_min_increase_amt IN NUMBER DEFAULT NULL,
250 x_allow_dec_post_accept_flag IN VARCHAR2 DEFAULT NULL,
251 x_min_decrease_amt IN NUMBER DEFAULT NULL,
252 x_allow_decln_post_accept_flag IN VARCHAR2 DEFAULT NULL,
253 x_status_after_decline IN VARCHAR2 DEFAULT NULL,
254 x_fund_information_txt IN VARCHAR2 DEFAULT NULL
255 );
256
257 PROCEDURE update_row (
258 x_rowid IN VARCHAR2,
259 x_fund_id IN NUMBER,
260 x_fund_code IN VARCHAR2,
261 x_ci_cal_type IN VARCHAR2,
262 x_ci_sequence_number IN NUMBER,
263 x_description IN VARCHAR2,
264 x_discontinue_fund IN VARCHAR2,
265 x_entitlement IN VARCHAR2,
266 x_auto_pkg IN VARCHAR2,
267 x_self_help IN VARCHAR2,
268 x_allow_man_pkg IN VARCHAR2,
269 x_update_need IN VARCHAR2,
270 x_disburse_fund IN VARCHAR2,
271 x_available_amt IN NUMBER,
272 x_offered_amt IN NUMBER,
273 x_pending_amt IN NUMBER,
274 x_accepted_amt IN NUMBER,
278 x_enrollment_status IN VARCHAR2,
275 x_declined_amt IN NUMBER,
276 x_cancelled_amt IN NUMBER,
277 x_remaining_amt IN NUMBER,
279 x_prn_award_letter IN VARCHAR2,
280 x_over_award_amt IN NUMBER,
281 x_over_award_perct IN NUMBER,
282 x_min_award_amt IN NUMBER,
283 x_max_award_amt IN NUMBER,
284 x_max_yearly_amt IN NUMBER,
285 x_max_life_amt IN NUMBER,
286 x_max_life_term IN NUMBER,
287 x_fm_fc_methd IN VARCHAR2,
288 x_roundoff_fact IN VARCHAR2,
289 x_replace_fc IN VARCHAR2,
290 x_allow_overaward IN VARCHAR2,
291 x_pckg_awd_stat IN VARCHAR2,
292 x_org_record_req IN VARCHAR2,
293 x_disb_record_req IN VARCHAR2,
294 x_prom_note_req IN VARCHAR2,
295 x_min_num_disb IN NUMBER,
296 x_max_num_disb IN NUMBER,
297 x_fee_type IN VARCHAR2,
298 x_total_offered IN NUMBER,
299 x_total_accepted IN NUMBER,
300 x_total_declined IN NUMBER,
301 x_total_revoked IN NUMBER,
302 x_total_cancelled IN NUMBER,
303 x_total_disbursed IN NUMBER,
304 x_total_committed IN NUMBER,
305 x_committed_amt IN NUMBER,
306 x_disbursed_amt IN NUMBER,
307 x_awd_notice_txt IN VARCHAR2,
308 x_attribute_category IN VARCHAR2,
309 x_attribute1 IN VARCHAR2,
310 x_attribute2 IN VARCHAR2,
311 x_attribute3 IN VARCHAR2,
312 x_attribute4 IN VARCHAR2,
313 x_attribute5 IN VARCHAR2,
314 x_attribute6 IN VARCHAR2,
315 x_attribute7 IN VARCHAR2,
316 x_attribute8 IN VARCHAR2,
317 x_attribute9 IN VARCHAR2,
318 x_attribute10 IN VARCHAR2,
319 x_attribute11 IN VARCHAR2,
320 x_attribute12 IN VARCHAR2,
321 x_attribute13 IN VARCHAR2,
322 x_attribute14 IN VARCHAR2,
323 x_attribute15 IN VARCHAR2,
324 x_attribute16 IN VARCHAR2,
325 x_attribute17 IN VARCHAR2,
326 x_attribute18 IN VARCHAR2,
327 x_attribute19 IN VARCHAR2,
328 x_attribute20 IN VARCHAR2,
329 x_disb_verf_da IN VARCHAR2 DEFAULT NULL,
330 x_fund_exp_da IN VARCHAR2 DEFAULT NULL,
331 x_nslds_disb_da IN VARCHAR2 DEFAULT NULL,
332 x_disb_exp_da IN VARCHAR2 DEFAULT NULL,
333 x_fund_recv_reqd IN VARCHAR2 DEFAULT NULL,
334 x_show_on_bill IN VARCHAR2 DEFAULT NULL,
335 x_bill_desc IN VARCHAR2 DEFAULT NULL,
336 x_credit_type_id IN NUMBER DEFAULT NULL,
337 x_spnsr_ref_num IN VARCHAR2 DEFAULT NULL,
338 x_party_id IN VARCHAR2 DEFAULT NULL,
339 x_spnsr_fee_type IN VARCHAR2 DEFAULT NULL,
340 x_min_credit_points IN NUMBER DEFAULT NULL,
341 x_group_id IN NUMBER DEFAULT NULL,
342 x_spnsr_attribute_category IN VARCHAR2 DEFAULT NULL,
343 x_spnsr_attribute1 IN VARCHAR2 DEFAULT NULL,
344 x_spnsr_attribute2 IN VARCHAR2 DEFAULT NULL,
345 x_spnsr_attribute3 IN VARCHAR2 DEFAULT NULL,
346 x_spnsr_attribute4 IN VARCHAR2 DEFAULT NULL,
347 x_spnsr_attribute5 IN VARCHAR2 DEFAULT NULL,
348 x_spnsr_attribute6 IN VARCHAR2 DEFAULT NULL,
349 x_spnsr_attribute7 IN VARCHAR2 DEFAULT NULL,
350 x_spnsr_attribute8 IN VARCHAR2 DEFAULT NULL,
351 x_spnsr_attribute9 IN VARCHAR2 DEFAULT NULL,
352 x_spnsr_attribute10 IN VARCHAR2 DEFAULT NULL,
353 x_spnsr_attribute11 IN VARCHAR2 DEFAULT NULL,
354 x_spnsr_attribute12 IN VARCHAR2 DEFAULT NULL,
355 x_spnsr_attribute13 IN VARCHAR2 DEFAULT NULL,
356 x_spnsr_attribute14 IN VARCHAR2 DEFAULT NULL,
357 x_spnsr_attribute15 IN VARCHAR2 DEFAULT NULL,
358 x_spnsr_attribute16 IN VARCHAR2 DEFAULT NULL,
359 x_spnsr_attribute17 IN VARCHAR2 DEFAULT NULL,
360 x_spnsr_attribute18 IN VARCHAR2 DEFAULT NULL,
361 x_spnsr_attribute19 IN VARCHAR2 DEFAULT NULL,
362 x_spnsr_attribute20 IN VARCHAR2 DEFAULT NULL ,
363 x_threshold_perct IN NUMBER DEFAULT NULL,
367 x_send_without_doc IN VARCHAR2 DEFAULT NULL, -- Added as part of Bug # 2758812
364 x_threshold_value IN NUMBER DEFAULT NULL,
365 x_ver_app_stat_override IN VARCHAR2 DEFAULT NULL,
366 x_gift_aid IN VARCHAR2 DEFAULT NULL,
368 x_mode IN VARCHAR2 DEFAULT 'R',
369 x_re_pkg_verif_flag IN VARCHAR2 DEFAULT NULL,
370 x_donot_repkg_if_code IN VARCHAR2 DEFAULT NULL,
371 x_lock_award_flag IN VARCHAR2 DEFAULT NULL,
372 x_disb_rounding_code IN VARCHAR2 DEFAULT NULL,
373 x_view_only_flag IN VARCHAR2 DEFAULT NULL,
374 x_accept_less_amt_flag IN VARCHAR2 DEFAULT NULL,
375 x_allow_inc_post_accept_flag IN VARCHAR2 DEFAULT NULL,
376 x_min_increase_amt IN NUMBER DEFAULT NULL,
377 x_allow_dec_post_accept_flag IN VARCHAR2 DEFAULT NULL,
378 x_min_decrease_amt IN NUMBER DEFAULT NULL,
379 x_allow_decln_post_accept_flag IN VARCHAR2 DEFAULT NULL,
380 x_status_after_decline IN VARCHAR2 DEFAULT NULL,
381 x_fund_information_txt IN VARCHAR2 DEFAULT NULL
382 );
383
384 PROCEDURE add_row (
385 x_rowid IN OUT NOCOPY VARCHAR2,
386 x_fund_id IN OUT NOCOPY NUMBER,
387 x_fund_code IN VARCHAR2,
388 x_ci_cal_type IN VARCHAR2,
389 x_ci_sequence_number IN NUMBER,
390 x_description IN VARCHAR2,
391 x_discontinue_fund IN VARCHAR2,
392 x_entitlement IN VARCHAR2,
393 x_auto_pkg IN VARCHAR2,
394 x_self_help IN VARCHAR2,
395 x_allow_man_pkg IN VARCHAR2,
396 x_update_need IN VARCHAR2,
397 x_disburse_fund IN VARCHAR2,
398 x_available_amt IN NUMBER,
399 x_offered_amt IN NUMBER,
400 x_pending_amt IN NUMBER,
401 x_accepted_amt IN NUMBER,
402 x_declined_amt IN NUMBER,
403 x_cancelled_amt IN NUMBER,
404 x_remaining_amt IN NUMBER,
405 x_enrollment_status IN VARCHAR2,
406 x_prn_award_letter IN VARCHAR2,
407 x_over_award_amt IN NUMBER,
408 x_over_award_perct IN NUMBER,
409 x_min_award_amt IN NUMBER,
410 x_max_award_amt IN NUMBER,
411 x_max_yearly_amt IN NUMBER,
412 x_max_life_amt IN NUMBER,
413 x_max_life_term IN NUMBER,
414 x_fm_fc_methd IN VARCHAR2,
415 x_roundoff_fact IN VARCHAR2,
416 x_replace_fc IN VARCHAR2,
417 x_allow_overaward IN VARCHAR2,
418 x_pckg_awd_stat IN VARCHAR2,
419 x_org_record_req IN VARCHAR2,
420 x_disb_record_req IN VARCHAR2,
421 x_prom_note_req IN VARCHAR2,
422 x_min_num_disb IN NUMBER,
423 x_max_num_disb IN NUMBER,
424 x_fee_type IN VARCHAR2,
425 x_total_offered IN NUMBER,
426 x_total_accepted IN NUMBER,
427 x_total_declined IN NUMBER,
428 x_total_revoked IN NUMBER,
429 x_total_cancelled IN NUMBER,
430 x_total_disbursed IN NUMBER,
431 x_total_committed IN NUMBER,
432 x_committed_amt IN NUMBER,
433 x_disbursed_amt IN NUMBER,
434 x_awd_notice_txt IN VARCHAR2,
435 x_attribute_category IN VARCHAR2,
436 x_attribute1 IN VARCHAR2,
437 x_attribute2 IN VARCHAR2,
438 x_attribute3 IN VARCHAR2,
439 x_attribute4 IN VARCHAR2,
440 x_attribute5 IN VARCHAR2,
441 x_attribute6 IN VARCHAR2,
442 x_attribute7 IN VARCHAR2,
443 x_attribute8 IN VARCHAR2,
444 x_attribute9 IN VARCHAR2,
445 x_attribute10 IN VARCHAR2,
446 x_attribute11 IN VARCHAR2,
447 x_attribute12 IN VARCHAR2,
448 x_attribute13 IN VARCHAR2,
449 x_attribute14 IN VARCHAR2,
450 x_attribute15 IN VARCHAR2,
451 x_attribute16 IN VARCHAR2,
452 x_attribute17 IN VARCHAR2,
453 x_attribute18 IN VARCHAR2,
454 x_attribute19 IN VARCHAR2,
455 x_attribute20 IN VARCHAR2,
456 x_disb_verf_da IN VARCHAR2 DEFAULT NULL,
457 x_fund_exp_da IN VARCHAR2 DEFAULT NULL,
461 x_show_on_bill IN VARCHAR2 DEFAULT NULL,
458 x_nslds_disb_da IN VARCHAR2 DEFAULT NULL,
459 x_disb_exp_da IN VARCHAR2 DEFAULT NULL,
460 x_fund_recv_reqd IN VARCHAR2 DEFAULT NULL,
462 x_bill_desc IN VARCHAR2 DEFAULT NULL,
463 x_credit_type_id IN NUMBER DEFAULT NULL,
464 x_spnsr_ref_num IN VARCHAR2 DEFAULT NULL,
465 x_party_id IN VARCHAR2 DEFAULT NULL,
466 x_spnsr_fee_type IN VARCHAR2 DEFAULT NULL,
467 x_min_credit_points IN NUMBER DEFAULT NULL,
468 x_group_id IN NUMBER DEFAULT NULL,
469 x_spnsr_attribute_category IN VARCHAR2 DEFAULT NULL,
470 x_spnsr_attribute1 IN VARCHAR2 DEFAULT NULL,
471 x_spnsr_attribute2 IN VARCHAR2 DEFAULT NULL,
472 x_spnsr_attribute3 IN VARCHAR2 DEFAULT NULL,
473 x_spnsr_attribute4 IN VARCHAR2 DEFAULT NULL,
474 x_spnsr_attribute5 IN VARCHAR2 DEFAULT NULL,
475 x_spnsr_attribute6 IN VARCHAR2 DEFAULT NULL,
476 x_spnsr_attribute7 IN VARCHAR2 DEFAULT NULL,
477 x_spnsr_attribute8 IN VARCHAR2 DEFAULT NULL,
478 x_spnsr_attribute9 IN VARCHAR2 DEFAULT NULL,
479 x_spnsr_attribute10 IN VARCHAR2 DEFAULT NULL,
480 x_spnsr_attribute11 IN VARCHAR2 DEFAULT NULL,
481 x_spnsr_attribute12 IN VARCHAR2 DEFAULT NULL,
482 x_spnsr_attribute13 IN VARCHAR2 DEFAULT NULL,
483 x_spnsr_attribute14 IN VARCHAR2 DEFAULT NULL,
484 x_spnsr_attribute15 IN VARCHAR2 DEFAULT NULL,
485 x_spnsr_attribute16 IN VARCHAR2 DEFAULT NULL,
486 x_spnsr_attribute17 IN VARCHAR2 DEFAULT NULL,
487 x_spnsr_attribute18 IN VARCHAR2 DEFAULT NULL,
488 x_spnsr_attribute19 IN VARCHAR2 DEFAULT NULL,
489 x_spnsr_attribute20 IN VARCHAR2 DEFAULT NULL,
490 x_threshold_perct IN NUMBER DEFAULT NULL,
491 x_threshold_value IN NUMBER DEFAULT NULL,
492 x_ver_app_stat_override IN VARCHAR2 DEFAULT NULL,
493 x_gift_aid IN VARCHAR2 DEFAULT NULL,
494 x_send_without_doc IN VARCHAR2 DEFAULT NULL, -- Added as part of Bug # 2758812
495 x_mode IN VARCHAR2 DEFAULT 'R',
496 x_re_pkg_verif_flag IN VARCHAR2 DEFAULT NULL,
497 x_donot_repkg_if_code IN VARCHAR2 DEFAULT NULL,
498 x_lock_award_flag IN VARCHAR2 DEFAULT NULL,
499 x_disb_rounding_code IN VARCHAR2 DEFAULT NULL,
500 x_view_only_flag IN VARCHAR2 DEFAULT NULL,
501 x_accept_less_amt_flag IN VARCHAR2 DEFAULT NULL,
502 x_allow_inc_post_accept_flag IN VARCHAR2 DEFAULT NULL,
503 x_min_increase_amt IN NUMBER DEFAULT NULL,
504 x_allow_dec_post_accept_flag IN VARCHAR2 DEFAULT NULL,
505 x_min_decrease_amt IN NUMBER DEFAULT NULL,
506 x_allow_decln_post_accept_flag IN VARCHAR2 DEFAULT NULL,
507 x_status_after_decline IN VARCHAR2 DEFAULT NULL,
508 x_fund_information_txt IN VARCHAR2 DEFAULT NULL
509 );
510
511 PROCEDURE delete_row (
512 x_rowid IN VARCHAR2
513 );
514
515 FUNCTION get_pk_for_validation (
516 x_fund_id IN NUMBER
517 ) RETURN BOOLEAN;
518
519 PROCEDURE get_ufk_igf_aw_fund_cat (
520 x_fund_code IN VARCHAR2,
521 x_org_id IN NUMBER
522 );
523
524 PROCEDURE get_fk_igs_ca_inst (
525 x_ci_cal_type IN VARCHAR2,
526 x_ci_sequence_number IN NUMBER
527 );
528
529 PROCEDURE get_fk_igs_fi_cr_types (
530 x_credit_type_id IN NUMBER
531 );
532
533 PROCEDURE before_dml (
534 p_action IN VARCHAR2,
535 x_rowid IN VARCHAR2 DEFAULT NULL,
536 x_fund_id IN NUMBER DEFAULT NULL,
537 x_fund_code IN VARCHAR2 DEFAULT NULL,
538 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
539 x_ci_sequence_number IN NUMBER DEFAULT NULL,
540 x_description IN VARCHAR2 DEFAULT NULL,
541 x_discontinue_fund IN VARCHAR2 DEFAULT NULL,
542 x_entitlement IN VARCHAR2 DEFAULT NULL,
543 x_auto_pkg IN VARCHAR2 DEFAULT NULL,
544 x_self_help IN VARCHAR2 DEFAULT NULL,
545 x_allow_man_pkg IN VARCHAR2 DEFAULT NULL,
546 x_update_need IN VARCHAR2 DEFAULT NULL,
547 x_disburse_fund IN VARCHAR2 DEFAULT NULL,
548 x_available_amt IN NUMBER DEFAULT NULL,
549 x_offered_amt IN NUMBER DEFAULT NULL,
550 x_pending_amt IN NUMBER DEFAULT NULL,
551 x_accepted_amt IN NUMBER DEFAULT NULL,
552 x_declined_amt IN NUMBER DEFAULT NULL,
553 x_cancelled_amt IN NUMBER DEFAULT NULL,
554 x_remaining_amt IN NUMBER DEFAULT NULL,
555 x_enrollment_status IN VARCHAR2 DEFAULT NULL,
556 x_prn_award_letter IN VARCHAR2 DEFAULT NULL,
557 x_over_award_amt IN NUMBER DEFAULT NULL,
558 x_over_award_perct IN NUMBER DEFAULT NULL,
559 x_min_award_amt IN NUMBER DEFAULT NULL,
560 x_max_award_amt IN NUMBER DEFAULT NULL,
561 x_max_yearly_amt IN NUMBER DEFAULT NULL,
562 x_max_life_amt IN NUMBER DEFAULT NULL,
563 x_max_life_term IN NUMBER DEFAULT NULL,
564 x_fm_fc_methd IN VARCHAR2 DEFAULT NULL,
565 x_roundoff_fact IN VARCHAR2 DEFAULT NULL,
566 x_replace_fc IN VARCHAR2 DEFAULT NULL,
567 x_allow_overaward IN VARCHAR2 DEFAULT NULL,
568 x_pckg_awd_stat IN VARCHAR2 DEFAULT NULL,
569 x_org_record_req IN VARCHAR2 DEFAULT NULL,
570 x_disb_record_req IN VARCHAR2 DEFAULT NULL,
571 x_prom_note_req IN VARCHAR2 DEFAULT NULL,
572 x_min_num_disb IN NUMBER DEFAULT NULL,
573 x_max_num_disb IN NUMBER DEFAULT NULL,
574 x_fee_type IN VARCHAR2 DEFAULT NULL,
575 x_total_offered IN NUMBER DEFAULT NULL,
576 x_total_accepted IN NUMBER DEFAULT NULL,
577 x_total_declined IN NUMBER DEFAULT NULL,
578 x_total_revoked IN NUMBER DEFAULT NULL,
579 x_total_cancelled IN NUMBER DEFAULT NULL,
580 x_total_disbursed IN NUMBER DEFAULT NULL,
581 x_total_committed IN NUMBER DEFAULT NULL,
582 x_committed_amt IN NUMBER DEFAULT NULL,
583 x_disbursed_amt IN NUMBER DEFAULT NULL,
584 x_awd_notice_txt IN VARCHAR2 DEFAULT NULL,
585 x_attribute_category IN VARCHAR2 DEFAULT NULL,
586 x_attribute1 IN VARCHAR2 DEFAULT NULL,
587 x_attribute2 IN VARCHAR2 DEFAULT NULL,
588 x_attribute3 IN VARCHAR2 DEFAULT NULL,
589 x_attribute4 IN VARCHAR2 DEFAULT NULL,
590 x_attribute5 IN VARCHAR2 DEFAULT NULL,
591 x_attribute6 IN VARCHAR2 DEFAULT NULL,
592 x_attribute7 IN VARCHAR2 DEFAULT NULL,
593 x_attribute8 IN VARCHAR2 DEFAULT NULL,
594 x_attribute9 IN VARCHAR2 DEFAULT NULL,
595 x_attribute10 IN VARCHAR2 DEFAULT NULL,
596 x_attribute11 IN VARCHAR2 DEFAULT NULL,
597 x_attribute12 IN VARCHAR2 DEFAULT NULL,
598 x_attribute13 IN VARCHAR2 DEFAULT NULL,
599 x_attribute14 IN VARCHAR2 DEFAULT NULL,
600 x_attribute15 IN VARCHAR2 DEFAULT NULL,
601 x_attribute16 IN VARCHAR2 DEFAULT NULL,
602 x_attribute17 IN VARCHAR2 DEFAULT NULL,
603 x_attribute18 IN VARCHAR2 DEFAULT NULL,
604 x_attribute19 IN VARCHAR2 DEFAULT NULL,
605 x_attribute20 IN VARCHAR2 DEFAULT NULL,
606 x_creation_date IN DATE DEFAULT NULL,
607 x_created_by IN NUMBER DEFAULT NULL,
608 x_last_update_date IN DATE DEFAULT NULL,
609 x_last_updated_by IN NUMBER DEFAULT NULL,
610 x_last_update_login IN NUMBER DEFAULT NULL,
611 x_disb_verf_da IN VARCHAR2 DEFAULT NULL,
612 x_fund_exp_da IN VARCHAR2 DEFAULT NULL,
613 x_nslds_disb_da IN VARCHAR2 DEFAULT NULL,
614 x_disb_exp_da IN VARCHAR2 DEFAULT NULL,
615 x_fund_recv_reqd IN VARCHAR2 DEFAULT NULL,
616 x_show_on_bill IN VARCHAR2 DEFAULT NULL,
617 x_bill_desc IN VARCHAR2 DEFAULT NULL,
618 x_credit_type_id IN NUMBER DEFAULT NULL,
619 x_spnsr_ref_num IN VARCHAR2 DEFAULT NULL,
620 x_party_id IN VARCHAR2 DEFAULT NULL,
621 x_spnsr_fee_type IN VARCHAR2 DEFAULT NULL,
622 x_min_credit_points IN NUMBER DEFAULT NULL,
623 x_group_id IN NUMBER DEFAULT NULL,
624 x_spnsr_attribute_category IN VARCHAR2 DEFAULT NULL,
625 x_spnsr_attribute1 IN VARCHAR2 DEFAULT NULL,
626 x_spnsr_attribute2 IN VARCHAR2 DEFAULT NULL,
627 x_spnsr_attribute3 IN VARCHAR2 DEFAULT NULL,
628 x_spnsr_attribute4 IN VARCHAR2 DEFAULT NULL,
629 x_spnsr_attribute5 IN VARCHAR2 DEFAULT NULL,
630 x_spnsr_attribute6 IN VARCHAR2 DEFAULT NULL,
631 x_spnsr_attribute7 IN VARCHAR2 DEFAULT NULL,
632 x_spnsr_attribute8 IN VARCHAR2 DEFAULT NULL,
633 x_spnsr_attribute9 IN VARCHAR2 DEFAULT NULL,
634 x_spnsr_attribute10 IN VARCHAR2 DEFAULT NULL,
635 x_spnsr_attribute11 IN VARCHAR2 DEFAULT NULL,
636 x_spnsr_attribute12 IN VARCHAR2 DEFAULT NULL,
637 x_spnsr_attribute13 IN VARCHAR2 DEFAULT NULL,
638 x_spnsr_attribute14 IN VARCHAR2 DEFAULT NULL,
639 x_spnsr_attribute15 IN VARCHAR2 DEFAULT NULL,
640 x_spnsr_attribute16 IN VARCHAR2 DEFAULT NULL,
641 x_spnsr_attribute17 IN VARCHAR2 DEFAULT NULL,
642 x_spnsr_attribute18 IN VARCHAR2 DEFAULT NULL,
643 x_spnsr_attribute19 IN VARCHAR2 DEFAULT NULL,
644 x_spnsr_attribute20 IN VARCHAR2 DEFAULT NULL,
645 x_threshold_perct IN NUMBER DEFAULT NULL,
646 x_threshold_value IN NUMBER DEFAULT NULL,
647 x_ver_app_stat_override IN VARCHAR2 DEFAULT NULL,
648 x_gift_aid IN VARCHAR2 DEFAULT NULL,
649 x_send_without_doc IN VARCHAR2 DEFAULT NULL, -- Added as part of Bug # 2758812
650 x_re_pkg_verif_flag IN VARCHAR2 DEFAULT NULL,
651 x_donot_repkg_if_code IN VARCHAR2 DEFAULT NULL,
652 x_lock_award_flag IN VARCHAR2 DEFAULT NULL,
653 x_disb_rounding_code IN VARCHAR2 DEFAULT NULL,
654 x_view_only_flag IN VARCHAR2 DEFAULT NULL,
655 x_accept_less_amt_flag IN VARCHAR2 DEFAULT NULL,
656 x_allow_inc_post_accept_flag IN VARCHAR2 DEFAULT NULL,
657 x_min_increase_amt IN NUMBER DEFAULT NULL,
658 x_allow_dec_post_accept_flag IN VARCHAR2 DEFAULT NULL,
659 x_min_decrease_amt IN NUMBER DEFAULT NULL,
660 x_allow_decln_post_accept_flag IN VARCHAR2 DEFAULT NULL,
661 x_status_after_decline IN VARCHAR2 DEFAULT NULL,
662 x_fund_information_txt IN VARCHAR2 DEFAULT NULL
663 );
664
665 FUNCTION get_uk_for_validation (
666 x_fund_code IN VARCHAR2,
667 x_ci_cal_type IN VARCHAR2,
668 x_ci_sequence_number IN NUMBER
669 ) RETURN BOOLEAN ;
670
671
672 END igf_aw_fund_mast_pkg;