[Home] [Help]
PACKAGE: APPS.OKL_MAINTAIN_FEE_PVT
Source
1 PACKAGE OKL_MAINTAIN_FEE_PVT AS
2 /* $Header: OKLRFEES.pls 120.13 2006/03/02 23:45:45 smereddy noship $ */
3
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_MAINTAIN_FEE_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
9 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
10 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
11
12 G_FT_FINANCED CONSTANT VARCHAR2(200) := 'FINANCED';
13 G_FT_ABSORBED CONSTANT VARCHAR2(200) := 'ABSORBED';
14 G_FT_PASSTHROUGH CONSTANT VARCHAR2(200) := 'PASSTHROUGH';
15 G_FT_CAPITALIZED CONSTANT VARCHAR2(200) := 'CAPITALIZED';
16 G_FT_INCOME CONSTANT VARCHAR2(200) := 'INCOME';
17 G_FT_EXPENSE CONSTANT VARCHAR2(200) := 'EXPENSE';
18 G_FT_MISCELLANEOUS CONSTANT VARCHAR2(200) := 'MISCELLANEOUS';
19 G_FT_SECDEPOSIT CONSTANT VARCHAR2(200) := 'SECDEPOSIT';
20 G_FT_GENERAL CONSTANT VARCHAR2(200) := 'GENERAL';
21 G_FT_ROLLOVER CONSTANT VARCHAR2(200) := 'ROLLOVER';
22
23 G_OKL_FEE_PURPOSE_CODE CONSTANT VARCHAR2(200) := 'SALESTAX';
24 --G_OKL_FEE_PURPOSE_CODE CONSTANT VARCHAR2(200) := 'RVI';
25 G_OKL_FEE_PURPOSE_LOOKUP_TYPE CONSTANT VARCHAR2(200) := 'OKL_FEE_PURPOSE';
26
27 ---------------------------------------------------------------------------
28
29 TYPE fee_types_rec_type is record
30 (
31 line_id okc_k_lines_b.id%type,
32 dnz_chr_id okc_k_lines_b.dnz_chr_id%type,
33 fee_type varchar2(250),
34 item_id okc_k_lines_b.id%type,
35 item_name OKL_STRMTYP_SOURCE_V.NAME%type,
36 item_id1 OKC_K_ITEMS_V.object1_ID1%type,
37 item_id2 OKC_K_ITEMS_V.object1_ID2%type,
38 party_id OKC_K_PARTY_ROLES_V.ID%type,
39 party_name OKX_PARTIES_V.NAME%type,
40 party_id1 OKC_K_PARTY_ROLES_V.object1_id1%type,
41 party_id2 OKC_K_PARTY_ROLES_V.object1_id2%type,
42 effective_from okc_k_lines_b.start_date%type,
43 effective_to okc_k_lines_b.end_date%type,
44 amount okl_k_lines.amount%type,
45 initial_direct_cost okl_k_lines.initial_direct_cost%type,
46 roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type,
47 qte_id okl_k_lines.qte_id%type,
48 FUNDING_DATE okl_k_lines.FUNDING_DATE%type,
49 FEE_PURPOSE_CODE okl_k_lines.FEE_PURPOSE_CODE%type,
50 --Bug# 4558486
51 attribute_category okl_k_lines.attribute_category%type,
52 attribute1 okl_k_lines.attribute1%type,
53 attribute2 okl_k_lines.attribute2%type,
54 attribute3 okl_k_lines.attribute3%type,
55 attribute4 okl_k_lines.attribute4%type,
56 attribute5 okl_k_lines.attribute5%type,
57 attribute6 okl_k_lines.attribute6%type,
58 attribute7 okl_k_lines.attribute7%type,
59 attribute8 okl_k_lines.attribute8%type,
60 attribute9 okl_k_lines.attribute9%type,
61 attribute10 okl_k_lines.attribute10%type,
62 attribute11 okl_k_lines.attribute11%type,
63 attribute12 okl_k_lines.attribute12%type,
64 attribute13 okl_k_lines.attribute13%type,
65 attribute14 okl_k_lines.attribute14%type,
66 attribute15 okl_k_lines.attribute15%type,
67 validate_dff_yn VARCHAR2(3)
68 );
69 TYPE fee_types_tbl_type is table of fee_types_rec_type INDEX BY BINARY_INTEGER;
70
71 --Murthy Passthru changes Begin.
72 TYPE passthru_dtl_rec_type IS RECORD (
73 b_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
74 ,b_cle_id NUMBER := OKC_API.G_MISS_NUM
75 ,b_ppl_id NUMBER := OKC_API.G_MISS_NUM
76 ,b_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
77 ,b_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
78 ,b_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
79 ,b_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
80 ,b_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
81 ,b_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
82 ,b_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
83 ,b_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
84 ,b_cpl_id NUMBER := OKL_API.G_MISS_NUM
85 ,b_vendor_id NUMBER := OKL_API.G_MISS_NUM
86 ,b_pay_site_id NUMBER := OKL_API.G_MISS_NUM
87 ,b_payment_term_id NUMBER := OKL_API.G_MISS_NUM
88 ,b_payment_method_code OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
89 ,b_pay_group_code OKL_PARTY_PAYMENT_DTLS_V.PAY_GROUP_CODE%TYPE := OKL_API.G_MISS_CHAR
90 ,b_payment_hdr_id OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_HDR_ID%TYPE := OKL_API.G_MISS_NUM
91 ,b_payment_basis OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
92 ,b_payment_start_date OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_START_DATE%TYPE := OKL_API.G_MISS_DATE
93 ,b_payment_frequency OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR
94 ,b_remit_days OKL_PARTY_PAYMENT_DTLS_V.REMIT_DAYS%TYPE := OKL_API.G_MISS_NUM
95 ,b_disbursement_basis OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
96 ,b_disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
97 ,b_disbursement_percent OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_PERCENT%TYPE := OKL_API.G_MISS_NUM
98 ,b_processing_fee_basis OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_BASIS%TYPE := OKL_API.G_MISS_CHAR
99 ,b_processing_fee_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
100 ,b_processing_fee_percent OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_PERCENT%TYPE := OKL_API.G_MISS_NUM
101 --,b_processing_fee_formula OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
102 ,e_dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
103 ,e_cle_id NUMBER := OKC_API.G_MISS_NUM
104 ,e_ppl_id NUMBER := OKC_API.G_MISS_NUM
105 ,e_passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
106 ,e_passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
107 ,e_passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
108 ,e_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
109 ,e_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
110 ,e_effective_from OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_FROM%TYPE := OKC_API.G_MISS_DATE
111 ,e_effective_to OKL_PARTY_PAYMENT_HDR_V.EFFECTIVE_TO%TYPE := OKC_API.G_MISS_DATE
112 ,e_payment_dtls_id NUMBER := OKL_API.G_MISS_NUM
113 ,e_cpl_id NUMBER := OKL_API.G_MISS_NUM
114 ,e_vendor_id NUMBER := OKL_API.G_MISS_NUM
115 ,e_pay_site_id NUMBER := OKL_API.G_MISS_NUM
116 ,e_payment_term_id NUMBER := OKL_API.G_MISS_NUM
117 ,e_payment_method_code OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
118 ,e_pay_group_code OKL_PARTY_PAYMENT_DTLS_V.PAY_GROUP_CODE%TYPE := OKL_API.G_MISS_CHAR
119 ,e_payment_hdr_id OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_HDR_ID%TYPE := OKL_API.G_MISS_NUM
120 ,e_payment_basis OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
121 ,e_payment_start_date OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_START_DATE%TYPE := OKL_API.G_MISS_DATE
122 ,e_payment_frequency OKL_PARTY_PAYMENT_DTLS_V.PAYMENT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR
123 ,e_remit_days OKL_PARTY_PAYMENT_DTLS_V.REMIT_DAYS%TYPE := OKL_API.G_MISS_NUM
124 ,e_disbursement_basis OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_BASIS%TYPE := OKL_API.G_MISS_CHAR
125 ,e_disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
126 ,e_disbursement_percent OKL_PARTY_PAYMENT_DTLS_V.DISBURSEMENT_PERCENT%TYPE := OKL_API.G_MISS_NUM
127 ,e_processing_fee_basis OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_BASIS%TYPE := OKL_API.G_MISS_CHAR
128 ,e_processing_fee_fixed_amount OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FIXED_AMOUNT%TYPE := OKL_API.G_MISS_NUM
129 ,e_processing_fee_percent OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_PERCENT%TYPE := OKL_API.G_MISS_NUM
130 --,e_processing_fee_formula OKL_PARTY_PAYMENT_DTLS_V.PROCESSING_FEE_FORMULA%TYPE := OKL_API.G_MISS_CHAR
131 );
132 TYPE passthru_dtl_tbl_type IS TABLE OF passthru_dtl_rec_type INDEX BY BINARY_INTEGER;
133
134 TYPE passthru_rec_type IS RECORD (
135 base_id NUMBER := OKC_API.G_MISS_NUM
136 ,evergreen_id NUMBER := OKC_API.G_MISS_NUM
137 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
138 ,cle_id NUMBER := OKC_API.G_MISS_NUM
139 ,passthru_start_date OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_START_DATE%TYPE := OKC_API.G_MISS_DATE
140 ,payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
141 ,evergreen_eligible_yn VARCHAR2(1) := OKC_API.G_MISS_CHAR
142 ,evergreen_payout_basis OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS%TYPE := OKC_API.G_MISS_CHAR
143 ,evergreen_payout_basis_formula OKL_PARTY_PAYMENT_HDR_V.PAYOUT_BASIS_FORMULA%TYPE := OKC_API.G_MISS_CHAR
144 ,passthru_term OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_TERM%TYPE := OKC_API.G_MISS_CHAR
145 ,base_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
146 ,evg_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
147 --,passthru_stream_type_id OKL_PARTY_PAYMENT_HDR_V.PASSTHRU_STREAM_TYPE_ID%TYPE := OKC_API.G_MISS_NUM
148 );
149 TYPE passthru_tbl_type IS TABLE OF passthru_rec_type INDEX BY BINARY_INTEGER;
150
151 TYPE party_rec_type is record (
152 id NUMBER := OKL_API.G_MISS_NUM
153 ,attribute_category OKL_K_PARTY_ROLES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
154 ,attribute1 OKL_K_PARTY_ROLES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
155 ,attribute2 OKL_K_PARTY_ROLES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
156 ,attribute3 OKL_K_PARTY_ROLES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
157 ,attribute4 OKL_K_PARTY_ROLES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
158 ,attribute5 OKL_K_PARTY_ROLES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
159 ,attribute6 OKL_K_PARTY_ROLES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
160 ,attribute7 OKL_K_PARTY_ROLES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
161 ,attribute8 OKL_K_PARTY_ROLES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
162 ,attribute9 OKL_K_PARTY_ROLES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
163 ,attribute10 OKL_K_PARTY_ROLES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
164 ,attribute11 OKL_K_PARTY_ROLES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
165 ,attribute12 OKL_K_PARTY_ROLES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
166 ,attribute13 OKL_K_PARTY_ROLES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
167 ,attribute14 OKL_K_PARTY_ROLES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
168 ,attribute15 OKL_K_PARTY_ROLES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
169 ,object1_id1 OKC_K_PARTY_ROLES_B.object1_id1%type := OKL_API.G_MISS_CHAR
170 ,object1_id2 OKC_K_PARTY_ROLES_B.object1_id2%type := OKL_API.G_MISS_CHAR
171 ,jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%type := OKL_API.G_MISS_CHAR
172 ,rle_code OKC_K_PARTY_ROLES_B.rle_code%type := OKL_API.G_MISS_CHAR
173 ,chr_id OKC_K_PARTY_ROLES_B.chr_id%type := OKL_API.G_MISS_NUM
174 ,dnz_chr_id OKC_K_PARTY_ROLES_B.dnz_chr_id%type := OKL_API.G_MISS_NUM
175 ,cle_id OKC_K_PARTY_ROLES_B.cle_id%type := OKL_API.G_MISS_NUM
176 );
177
178 TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;
179
180
181 PROCEDURE create_payment_dtls(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_passthru_dtl_rec IN passthru_dtl_rec_type,
188 x_passthru_dtl_rec OUT NOCOPY passthru_dtl_rec_type);
189
190 PROCEDURE create_payment_hdrs(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_passthru_rec IN passthru_rec_type,
197 x_passthru_rec OUT NOCOPY passthru_rec_type);
198
199 PROCEDURE delete_payment_hdrs(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_passthru_rec IN passthru_rec_type);
206 --Murthy Passthru changes end.
207
208 PROCEDURE create_fee_type(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_fee_types_rec IN fee_types_rec_type,
215 x_fee_types_rec OUT NOCOPY fee_types_rec_type
216 );
217
218 PROCEDURE validate_fee_type(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_fee_types_rec IN fee_types_rec_type,
225 x_fee_types_rec OUT NOCOPY fee_types_rec_type
226 );
227
228 PROCEDURE update_fee_type(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_fee_types_rec IN fee_types_rec_type,
235 x_fee_types_rec OUT NOCOPY fee_types_rec_type
236 );
237
238 PROCEDURE delete_fee_type(
239 p_api_version IN NUMBER,
240 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 p_fee_types_rec IN fee_types_rec_type
245 );
246
247 PROCEDURE create_strmtp_rul(
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 p_chr_id IN NUMBER,
254 p_cle_id IN NUMBER
255 );
256
257 PROCEDURE update_strmtp_rul(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_chr_id IN NUMBER,
264 p_cle_id IN NUMBER,
265 p_rgp_id IN NUMBER,
266 p_rul_id IN NUMBER
267 );
268
269 PROCEDURE process_strmtp_rul(
270 p_api_version IN NUMBER,
271 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_chr_id IN NUMBER,
276 p_cle_id IN NUMBER,
277 p_object1_id1 IN VARCHAR2
278 );
279
280 -------------------------------------------------
281 -- Create By Manu 19-Aug-2004
282 -- This api will be called by activate_contract
283 -- to validate the rollover termination quotes on
284 -- the contact before activating the contract
285 -- Also called by Re-book Contract API.
286 --------------------------------------------------
287 PROCEDURE validate_rollover_feeLine(
288 p_api_version IN NUMBER,
289 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
290 x_return_status OUT NOCOPY VARCHAR2,
291 x_msg_count OUT NOCOPY NUMBER,
292 x_msg_data OUT NOCOPY VARCHAR2,
293 p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
294 p_qte_id IN OKL_K_LINES.QTE_ID%TYPE,
295 p_for_qa_check IN BOOLEAN DEFAULT FALSE);
296
297 -------------------------------------------------
298 -- Create By smereddy 30-Aug-2004
299 -- This api will be called by activate_contract
300 -- to update the creditline limit against the rollover amount
301 -- this gets called before activating the contract
302 -- Also called by Re-book Contract API.
303 --------------------------------------------------
304 PROCEDURE rollover_fee(
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2,
310 p_chr_id IN NUMBER,
311 p_cl_id IN NUMBER,
312 x_rem_amt OUT NOCOPY NUMBER
313 );
314
315
316 -------------------------------------------------
317 -- Create By smereddy 30-Aug-2004
318 -- API called to throw warning message if the rollove amount
319 -- exceeds the total available/remaining credit limit amount
320 -- Also called by Re-book Contract API.
321 --------------------------------------------------
322 PROCEDURE rollover_fee(
323 p_api_version IN NUMBER,
324 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
325 x_return_status OUT NOCOPY VARCHAR2,
326 x_msg_count OUT NOCOPY NUMBER,
327 x_msg_data OUT NOCOPY VARCHAR2,
328 p_chr_id IN NUMBER,
329 x_rem_amt OUT NOCOPY NUMBER);
330
331 PROCEDURE allocate_amount(p_api_version IN NUMBER,
332 p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
333 p_transaction_control IN VARCHAR2 DEFAULT G_TRUE,
334 p_cle_id IN NUMBER,
335 p_chr_id IN NUMBER,
336 p_capitalize_yn IN VARCHAR2,
337 x_cle_id OUT NOCOPY NUMBER,
338 x_chr_id OUT NOCOPY NUMBER,
339 x_return_status OUT NOCOPY VARCHAR2,
340 x_msg_count OUT NOCOPY NUMBER,
341 x_msg_data OUT NOCOPY VARCHAR2);
342
343 -- Guru Added this for RVI
344
345 PROCEDURE process_rvi_stream(
346 p_api_version IN NUMBER,
347 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
348 x_return_status OUT NOCOPY VARCHAR2,
349 x_msg_count OUT NOCOPY NUMBER,
350 x_msg_data OUT NOCOPY VARCHAR2,
351 p_check_box_value IN VARCHAR2,
352 p_fee_types_rec IN fee_types_rec_type,
353 x_fee_types_rec OUT NOCOPY fee_types_rec_type);
354
355 PROCEDURE delete_passthru_party(
356 p_api_version IN NUMBER,
357 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
358 x_return_status OUT NOCOPY VARCHAR2,
359 x_msg_count OUT NOCOPY NUMBER,
360 x_msg_data OUT NOCOPY VARCHAR2,
361 p_cpl_id IN NUMBER
362 );
363
364 PROCEDURE create_party(
365 p_api_version IN NUMBER,
366 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
367 x_return_status OUT NOCOPY VARCHAR2,
368 x_msg_count OUT NOCOPY NUMBER,
369 x_msg_data OUT NOCOPY VARCHAR2,
370 p_kpl_rec IN party_rec_type,
371 x_kpl_rec OUT NOCOPY party_rec_type
372 );
373
374 PROCEDURE update_party(
375 p_api_version IN NUMBER,
376 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
377 x_return_status OUT NOCOPY VARCHAR2,
378 x_msg_count OUT NOCOPY NUMBER,
379 x_msg_data OUT NOCOPY VARCHAR2,
380 p_kpl_rec IN party_rec_type,
381 x_kpl_rec OUT NOCOPY party_rec_type
382 );
383
384 END OKL_MAINTAIN_FEE_PVT;