1 PACKAGE igf_aw_awd_disb_pkg AS
2 /* $Header: IGFWI24S.pls 120.1 2006/08/07 08:10:53 veramach noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_award_id IN NUMBER,
7 x_disb_num IN NUMBER,
8 x_tp_cal_type IN VARCHAR2,
9 x_tp_sequence_number IN NUMBER,
10 x_disb_gross_amt IN NUMBER,
11 x_fee_1 IN NUMBER,
12 x_fee_2 IN NUMBER,
13 x_disb_net_amt IN NUMBER,
14 x_disb_date IN DATE,
15 x_trans_type IN VARCHAR2,
16 x_elig_status IN VARCHAR2,
17 x_elig_status_date IN DATE,
18 x_affirm_flag IN VARCHAR2,
19 x_hold_rel_ind IN VARCHAR2,
20 x_manual_hold_ind IN VARCHAR2,
21 x_disb_status IN VARCHAR2,
22 x_disb_status_date IN DATE,
23 x_late_disb_ind IN VARCHAR2,
24 x_fund_dist_mthd IN VARCHAR2,
25 x_prev_reported_ind IN VARCHAR2,
26 x_fund_release_date IN DATE,
27 x_fund_status IN VARCHAR2,
28 x_fund_status_date IN DATE,
29 x_fee_paid_1 IN NUMBER,
30 x_fee_paid_2 IN NUMBER,
31 x_cheque_number IN VARCHAR2,
32 x_ld_cal_type IN VARCHAR2,
33 x_ld_sequence_number IN NUMBER,
34 x_disb_accepted_amt IN NUMBER,
35 x_disb_paid_amt IN NUMBER,
36 x_rvsn_id IN NUMBER,
37 x_int_rebate_amt IN NUMBER,
38 x_force_disb IN VARCHAR2,
39 x_min_credit_pts IN NUMBER,
40 x_disb_exp_dt IN DATE,
41 x_verf_enfr_dt IN DATE,
42 x_fee_class IN VARCHAR2,
43 x_show_on_bill IN VARCHAR2,
44 x_mode IN VARCHAR2 DEFAULT 'R',
45 x_attendance_type_code IN VARCHAR2 DEFAULT NULL,
46 x_base_attendance_type_code IN VARCHAR2 DEFAULT NULL,
47 x_payment_prd_st_date IN DATE DEFAULT NULL,
48 x_change_type_code IN VARCHAR2 DEFAULT NULL,
49 x_fund_return_mthd_code IN VARCHAR2 DEFAULT NULL,
50 x_called_from IN VARCHAR2 DEFAULT NULL,
51 x_direct_to_borr_flag IN VARCHAR2 DEFAULT NULL
52
53 );
54
55 PROCEDURE lock_row (
56 x_rowid IN VARCHAR2,
57 x_award_id IN NUMBER,
58 x_disb_num IN NUMBER,
59 x_tp_cal_type IN VARCHAR2,
60 x_tp_sequence_number IN NUMBER,
61 x_disb_gross_amt IN NUMBER,
62 x_fee_1 IN NUMBER,
63 x_fee_2 IN NUMBER,
64 x_disb_net_amt IN NUMBER,
65 x_disb_date IN DATE,
66 x_trans_type IN VARCHAR2,
67 x_elig_status IN VARCHAR2,
68 x_elig_status_date IN DATE,
69 x_affirm_flag IN VARCHAR2,
70 x_hold_rel_ind IN VARCHAR2,
71 x_manual_hold_ind IN VARCHAR2,
72 x_disb_status IN VARCHAR2,
73 x_disb_status_date IN DATE,
74 x_late_disb_ind IN VARCHAR2,
75 x_fund_dist_mthd IN VARCHAR2,
76 x_prev_reported_ind IN VARCHAR2,
77 x_fund_release_date IN DATE,
78 x_fund_status IN VARCHAR2,
79 x_fund_status_date IN DATE,
80 x_fee_paid_1 IN NUMBER,
81 x_fee_paid_2 IN NUMBER,
82 x_cheque_number IN VARCHAR2,
83 x_ld_cal_type IN VARCHAR2,
84 x_ld_sequence_number IN NUMBER,
85 x_disb_accepted_amt IN NUMBER,
86 x_disb_paid_amt IN NUMBER,
87 x_rvsn_id IN NUMBER,
88 x_int_rebate_amt IN NUMBER,
89 x_force_disb IN VARCHAR2,
90 x_min_credit_pts IN NUMBER,
91 x_disb_exp_dt IN DATE,
92 x_verf_enfr_dt IN DATE,
93 x_fee_class IN VARCHAR2,
94 x_show_on_bill IN VARCHAR2,
95 x_attendance_type_code IN VARCHAR2 DEFAULT NULL,
96 x_base_attendance_type_code IN VARCHAR2 DEFAULT NULL,
97 x_payment_prd_st_date IN DATE DEFAULT NULL,
98 x_change_type_code IN VARCHAR2 DEFAULT NULL,
99 x_fund_return_mthd_code IN VARCHAR2 DEFAULT NULL,
100 x_direct_to_borr_flag IN VARCHAR2 DEFAULT NULL
101
102 );
103
104 PROCEDURE update_row (
105 x_rowid IN VARCHAR2,
106 x_award_id IN NUMBER,
107 x_disb_num IN NUMBER,
108 x_tp_cal_type IN VARCHAR2,
109 x_tp_sequence_number IN NUMBER,
110 x_disb_gross_amt IN NUMBER,
111 x_fee_1 IN NUMBER,
112 x_fee_2 IN NUMBER,
113 x_disb_net_amt IN NUMBER,
114 x_disb_date IN DATE,
115 x_trans_type IN VARCHAR2,
116 x_elig_status IN VARCHAR2,
117 x_elig_status_date IN DATE,
118 x_affirm_flag IN VARCHAR2,
119 x_hold_rel_ind IN VARCHAR2,
120 x_manual_hold_ind IN VARCHAR2,
121 x_disb_status IN VARCHAR2,
122 x_disb_status_date IN DATE,
123 x_late_disb_ind IN VARCHAR2,
124 x_fund_dist_mthd IN VARCHAR2,
125 x_prev_reported_ind IN VARCHAR2,
126 x_fund_release_date IN DATE,
127 x_fund_status IN VARCHAR2,
128 x_fund_status_date IN DATE,
129 x_fee_paid_1 IN NUMBER,
130 x_fee_paid_2 IN NUMBER,
131 x_cheque_number IN VARCHAR2,
132 x_ld_cal_type IN VARCHAR2,
133 x_ld_sequence_number IN NUMBER,
134 x_disb_accepted_amt IN NUMBER,
135 x_disb_paid_amt IN NUMBER,
136 x_rvsn_id IN NUMBER,
137 x_int_rebate_amt IN NUMBER,
138 x_force_disb IN VARCHAR2,
139 x_min_credit_pts IN NUMBER,
140 x_disb_exp_dt IN DATE,
141 x_verf_enfr_dt IN DATE,
142 x_fee_class IN VARCHAR2,
143 x_show_on_bill IN VARCHAR2,
144 x_mode IN VARCHAR2 DEFAULT 'R',
145 x_attendance_type_code IN VARCHAR2 DEFAULT NULL,
146 x_base_attendance_type_code IN VARCHAR2 DEFAULT NULL,
147 x_payment_prd_st_date IN DATE DEFAULT NULL,
148 x_change_type_code IN VARCHAR2 DEFAULT NULL,
149 x_fund_return_mthd_code IN VARCHAR2 DEFAULT NULL,
150 x_called_from IN VARCHAR2 DEFAULT NULL,
151 x_direct_to_borr_flag IN VARCHAR2 DEFAULT NULL
152
153 );
154
155 PROCEDURE add_row (
156 x_rowid IN OUT NOCOPY VARCHAR2,
157 x_award_id IN NUMBER,
158 x_disb_num IN NUMBER,
159 x_tp_cal_type IN VARCHAR2,
160 x_tp_sequence_number IN NUMBER,
161 x_disb_gross_amt IN NUMBER,
162 x_fee_1 IN NUMBER,
163 x_fee_2 IN NUMBER,
164 x_disb_net_amt IN NUMBER,
165 x_disb_date IN DATE,
166 x_trans_type IN VARCHAR2,
167 x_elig_status IN VARCHAR2,
168 x_elig_status_date IN DATE,
169 x_affirm_flag IN VARCHAR2,
170 x_hold_rel_ind IN VARCHAR2,
171 x_manual_hold_ind IN VARCHAR2,
172 x_disb_status IN VARCHAR2,
173 x_disb_status_date IN DATE,
174 x_late_disb_ind IN VARCHAR2,
175 x_fund_dist_mthd IN VARCHAR2,
176 x_prev_reported_ind IN VARCHAR2,
177 x_fund_release_date IN DATE,
178 x_fund_status IN VARCHAR2,
179 x_fund_status_date IN DATE,
180 x_fee_paid_1 IN NUMBER,
181 x_fee_paid_2 IN NUMBER,
182 x_cheque_number IN VARCHAR2,
183 x_ld_cal_type IN VARCHAR2,
184 x_ld_sequence_number IN NUMBER,
185 x_disb_accepted_amt IN NUMBER,
186 x_disb_paid_amt IN NUMBER,
187 x_rvsn_id IN NUMBER,
188 x_int_rebate_amt IN NUMBER,
189 x_force_disb IN VARCHAR2,
190 x_min_credit_pts IN NUMBER,
191 x_disb_exp_dt IN DATE,
192 x_verf_enfr_dt IN DATE,
193 x_fee_class IN VARCHAR2,
194 x_show_on_bill IN VARCHAR2,
195 x_mode IN VARCHAR2 DEFAULT 'R',
196 x_attendance_type_code IN VARCHAR2 DEFAULT NULL,
197 x_base_attendance_type_code IN VARCHAR2 DEFAULT NULL,
198 x_payment_prd_st_date IN DATE DEFAULT NULL,
199 x_change_type_code IN VARCHAR2 DEFAULT NULL,
200 x_fund_return_mthd_code IN VARCHAR2 DEFAULT NULL,
201 x_direct_to_borr_flag IN VARCHAR2 DEFAULT NULL
202
203 );
204
205 PROCEDURE delete_row (
206 x_rowid IN VARCHAR2,
207 x_called_from IN VARCHAR2 DEFAULT NULL
208 );
209
210 FUNCTION get_pk_for_validation (
211 x_award_id IN NUMBER,
212 x_disb_num IN NUMBER
213 ) RETURN BOOLEAN;
214
215 PROCEDURE get_fk_igf_aw_award (
216 x_award_id IN NUMBER
217 );
218
219 PROCEDURE get_fk_igf_aw_awd_rvsn_rsn (
220 x_rvsn_id IN NUMBER
221 );
222
223 PROCEDURE get_fk_igs_ca_inst (
224 x_cal_type IN VARCHAR2,
225 x_sequence_number IN NUMBER
226 );
227
228 PROCEDURE get_fk_igs_lookups_view (
229 x_fee_class IN VARCHAR2
230 );
231
232 PROCEDURE before_dml (
233 p_action IN VARCHAR2,
234 x_rowid IN VARCHAR2 DEFAULT NULL,
235 x_award_id IN NUMBER DEFAULT NULL,
236 x_disb_num IN NUMBER DEFAULT NULL,
237 x_tp_cal_type IN VARCHAR2 DEFAULT NULL,
238 x_tp_sequence_number IN NUMBER DEFAULT NULL,
239 x_disb_gross_amt IN NUMBER DEFAULT NULL,
240 x_fee_1 IN NUMBER DEFAULT NULL,
241 x_fee_2 IN NUMBER DEFAULT NULL,
242 x_disb_net_amt IN NUMBER DEFAULT NULL,
243 x_disb_date IN DATE DEFAULT NULL,
244 x_trans_type IN VARCHAR2 DEFAULT NULL,
245 x_elig_status IN VARCHAR2 DEFAULT NULL,
246 x_elig_status_date IN DATE DEFAULT NULL,
247 x_affirm_flag IN VARCHAR2 DEFAULT NULL,
248 x_hold_rel_ind IN VARCHAR2 DEFAULT NULL,
249 x_manual_hold_ind IN VARCHAR2 DEFAULT NULL,
250 x_disb_status IN VARCHAR2 DEFAULT NULL,
251 x_disb_status_date IN DATE DEFAULT NULL,
252 x_late_disb_ind IN VARCHAR2 DEFAULT NULL,
253 x_fund_dist_mthd IN VARCHAR2 DEFAULT NULL,
254 x_prev_reported_ind IN VARCHAR2 DEFAULT NULL,
255 x_fund_release_date IN DATE DEFAULT NULL,
256 x_fund_status IN VARCHAR2 DEFAULT NULL,
257 x_fund_status_date IN DATE DEFAULT NULL,
258 x_fee_paid_1 IN NUMBER DEFAULT NULL,
259 x_fee_paid_2 IN NUMBER DEFAULT NULL,
260 x_cheque_number IN VARCHAR2 DEFAULT NULL,
261 x_ld_cal_type IN VARCHAR2 DEFAULT NULL,
262 x_ld_sequence_number IN NUMBER DEFAULT NULL,
263 x_disb_accepted_amt IN NUMBER DEFAULT NULL,
264 x_disb_paid_amt IN NUMBER DEFAULT NULL,
265 x_rvsn_id IN NUMBER DEFAULT NULL,
266 x_int_rebate_amt IN NUMBER DEFAULT NULL,
267 x_force_disb IN VARCHAR2 DEFAULT NULL,
268 x_min_credit_pts IN NUMBER DEFAULT NULL,
269 x_disb_exp_dt IN DATE DEFAULT NULL,
270 x_verf_enfr_dt IN DATE DEFAULT NULL,
271 x_fee_class IN VARCHAR2 DEFAULT NULL,
272 x_show_on_bill IN VARCHAR2 DEFAULT NULL,
273 x_attendance_type_code IN VARCHAR2 DEFAULT NULL,
274 x_base_attendance_type_code IN VARCHAR2 DEFAULT NULL,
275 x_creation_date IN DATE DEFAULT NULL,
276 x_created_by IN NUMBER DEFAULT NULL,
277 x_last_update_date IN DATE DEFAULT NULL,
278 x_last_updated_by IN NUMBER DEFAULT NULL,
279 x_last_update_login IN NUMBER DEFAULT NULL,
280 x_payment_prd_st_date IN DATE DEFAULT NULL,
281 x_change_type_code IN VARCHAR2 DEFAULT NULL,
282 x_fund_return_mthd_code IN VARCHAR2 DEFAULT NULL,
283 x_direct_to_borr_flag IN VARCHAR2 DEFAULT NULL
284
285 );
286
287 END igf_aw_awd_disb_pkg;