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