[Home] [Help]
PACKAGE: APPS.OKS_BILL_REC_PUB
Source
1 Package OKS_BILL_REC_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPBRCS.pls 120.8 2011/02/15 10:57:56 skuchima ship $*/
3 --------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
8 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
9 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
10 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
11 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
12 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
15 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
16 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
18 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
19 ---------------------------------------------------------------------------
20 -- GLOBAL EXCEPTIONS
21 ---------------------------------------------------------------------------
22 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
23 G_EXCEPTION_ROLLBACK EXCEPTION;
24 ---------------------------------------------------------------------------
25 -- GLOBAL VARIABLES
26 ---------------------------------------------------------------------------
27 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BILL_REC';
28 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
29
30 G_NUM_DAYS_WEEK CONSTANT NUMBER := 7;
31 G_QUATERLY CONSTANT NUMBER := 3;
32 G_HALFYEARLY CONSTANT NUMBER := 6;
33 G_YEARLY CONSTANT NUMBER := 12;
34 G_SERVICE_LINE_STYLE CONSTANT NUMBER := 1;
35 G_COVERAGE_LEVEL_STYLE CONSTANT NUMBER := 2;
36 G_USAGE_LINE_STYLE CONSTANT NUMBER := 3;
37 G_INSTALLED_ITEM_STYLE CONSTANT NUMBER := 4;
38 G_REGULAR CONSTANT NUMBER := 1;
39 G_NONREGULAR CONSTANT NUMBER := 2;
40 G_STAT_REG_INV_TO_AR CONSTANT NUMBER := 1;
41 G_STAT_TER_CR_INV_TO_AR CONSTANT NUMBER :=2;
42 G_BILLACTION_TR CONSTANT VARCHAR2(9) := 'TR';
43 G_BILLACTION_RI CONSTANT VARCHAR2(9) := 'RI';
44 ---------------------------------------------------------------------------
45 -- Procedures and Functions
46 ---------------------------------------------------------------------------
47 TYPE Covered_rec IS RECORD(
48 id NUMBER,
49 cle_id NUMBER,
50 start_reading NUMBER,
51 end_reading NUMBER,
52 base_reading NUMBER,
53 ccr_id NUMBER,
54 cgr_id NUMBER,
55 bcl_id NUMBER,
56 date_billed_from DATE,
57 date_billed_to DATE,
58 amount NUMBER,
59 average NUMBER,
60 unit_of_measure VARCHAR2(30),
61 fixed NUMBER,
62 actual NUMBER,
63 default_default NUMBER,
64 amcv_yn VARCHAR2(3),
65 adjustment_level NUMBER,
66 adjustment_minimum NUMBER,
67 result NUMBER,
68 bsl_id_averaged NUMBER,
69 bsd_id NUMBER,
70 bsd_id_applied NUMBER,
71 bcl_amount NUMBER,
72 date_to_interface DATE,
73 flag VARCHAR2(20),
74 x_stat VARCHAR2(20),
75 sign NUMBER,
76 estimated_quantity NUMBER
77 );
78
79 Type COVERED_TBL is TABLE of Covered_rec index by binary_integer;
80
81 Type TERMINATE_REC is RECORD
82 (
83 p_id NUMBER,
84 p_termination_date DATE,
85 p_termination_amount NUMBER ,-- user input for termination
86 p_con_termination_amount NUMBER ,-- actual value to be terminated
87 --p_existing_credit NUMBER ,
88 p_reason_code VARCHAR2(50) ,
89 p_flag NUMBER ,
90 p_termination_flag NUMBER,
91 p_suppress_credit Varchar2(2) ,
92 p_full_credit Varchar2(2),
93 P_Term_Date_flag Varchar2(2),
94 P_Term_Cancel_source Varchar2(50)
95 );
96
97 Type TERMINATE_TBL is TABLE of TERMINATE_REC index by binary_integer;
98
99 TYPE L_CCR_REC_TYPE IS RECORD
100 (
101 chr_id NUMBER,
102 cle_id NUMBER,
103 rule_information1 VARCHAR2(450),
104 rule_information2 VARCHAR2(450),
105 rule_information3 VARCHAR2(450),
106 rule_information4 VARCHAR2(450),
107 operation_flag VARCHAR2(2)
108 );
109
110 l_ccr_rec l_ccr_rec_type;
111
112 Type l_calc_rec_type is Record
113 (
114 l_calc_sdate Date,
115 l_calc_edate Date,
116 l_bill_stdt date,
117 l_bill_eddt Date,
118 l_bcl_id Number,
119 l_stat Varchar2(3)
120 );
121
122 l_calc_rec l_calc_rec_type;
123
124 Type line_report_rec_type IS RECORD (
125 Dnz_chr_id OKC_K_HEADERS_B.ID%Type
126 ,Contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%Type
127 ,Contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%Type
128 ,Currency_code OKC_K_HEADERS_B.CURRENCY_CODE%Type
129 ,Organization_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%Type
130 ,Line_id OKC_K_LINES_B.ID%Type
131 ,Line_Number OKC_K_LINES_B.LINE_NUMBER%Type
132 ,Cle_id OKC_K_LINES_B.CLE_ID%Type
133 ,Lse_Id OKC_K_LINES_B.LSE_ID%Type
134 ,Sub_line_id OKC_K_LINES_B.ID%Type
135 ,Sub_Line_Number OKC_K_LINES_B.LINE_NUMBER%Type
136 ,Pty_object1_id1 OKX_PARTIES_V.ID1%Type
137 ,Pty_object1_id2 OKX_PARTIES_V.ID2%Type
138 ,Bill_Amount Number(15,3)
139 ,Billed_YN Varchar2(1)
140 ,Error_Message Varchar2(2000)
141 ,record_type Varchar2(10)
142 ,Line_Type Varchar2(30)
143 ,Summary_bill_YN Varchar2(1)
144 ) ;
145
146 Type line_report_tbl_type IS TABLE OF line_report_rec_type INDEX BY BINARY_INTEGER ;
147
148 --Start mchoudha Bug#3537100 17-APR-04
149 --For Billing Report
150
151 Type Bill_report_rec_type IS RECORD (
152 Currency_code OKC_K_HEADERS_B.CURRENCY_CODE%Type
153 ,Successful_Lines NUMBER
154 ,Rejected_Lines NUMBER
155 ,Successful_SubLines NUMBER
156 ,Rejected_SubLines NUMBER
157 ,Successful_Lines_Value NUMBER
158 ,Rejected_Lines_Value NUMBER
159 ,Successful_SubLines_Value NUMBER
160 ,Rejected_SubLines_Value NUMBER
161 ) ;
162
163 Type bill_report_tbl_type IS TABLE OF Bill_report_rec_type INDEX BY BINARY_INTEGER ;
164
165 Type Error_report_rec_type IS RECORD (
166 Top_Line_id OKC_K_LINES_B.ID%Type
167 ,Lse_Id OKC_K_LINES_B.LSE_ID%Type
168 ,Sub_line_id OKC_K_LINES_B.ID%Type
169 ,Error_Message Varchar2(2000)
170 ) ;
171
172 Type billrep_error_tbl_type IS TABLE OF Error_report_rec_type INDEX BY BINARY_INTEGER ;
173
174
175
176 --End mchoudha Bug#3537100
177
178
179 Type l_true_val_rec is record (
180 p_termination_level varchar2(10),
181 p_cp_line_id number ,
182 p_top_line_id number ,
183 p_hdr_id number ,
184 p_termination_date date ,
185 p_terminate_reason varchar2(100) ,
186 p_override_amount number ,
187 p_con_terminate_amount number ,
188 p_termination_amount number ,
189 p_suppress_credit varchar2(2) ,
190 p_full_credit varchar2(2),
191 P_Term_Date_flag Varchar2(2),
192 P_Term_Cancel_source Varchar2(50));
193
194 Type l_true_val_tbl is table of l_true_val_rec index by BINARY_INTEGER ;
195
196 Procedure True_Value
197 ( p_true_value_tbl IN L_TRUE_VAL_TBL ,
198 x_return_status OUT NOCOPY VARCHAR2 ) ;
199
200 FUNCTION get_seq_id RETURN NUMBER;
201
202 PROCEDURE get_message (
203 l_msg_cnt IN NUMBER,
204 l_msg_data IN OUT NOCOPY VARCHAR);
205
206 /*
207 PROCEDURE cre_upd_ccr_rule(
208 P_CALLEDFROM IN NUMBER DEFAULT NULL,
209 p_ccr_rec IN L_CCR_REC_TYPE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 x_rule_id OUT NOCOPY NUMBER
214 );
215 */
216
217
218 PROCEDURE Set_top_line(
219 P_PROCESSED_LINES_TBL IN OUT NOCOPY LINE_REPORT_TBL_TYPE,
220 P_PROCESSED_SUB_LINES_TBL IN OUT NOCOPY LINE_REPORT_TBL_TYPE,
221 P_ERROR_MESSAGE IN VARCHAR2,
222 P_TOP_LINE IN NUMBER) ;
223
224 PROCEDURE Set_sub_line(
225 P_PROCESSED_LINES_TBL IN OUT NOCOPY LINE_REPORT_TBL_TYPE,
226 P_PROCESSED_SUB_LINES_TBL IN OUT NOCOPY LINE_REPORT_TBL_TYPE,
227 P_ERROR_MESSAGE IN VARCHAR2,
228 P_TOP_LINE IN NUMBER) ;
229
230
231 Procedure Counter_Values
232 (
233 P_calledfrom IN NUMBER DEFAULT NULL,
234 P_start_date IN DATE,
235 P_end_date IN DATE,
236 P_cle_id IN NUMBER,
237 P_Usage_type IN VARCHAR2,
238 X_Value OUT NOCOPY NUMBER,
239 X_Counter_Value OUT NOCOPY NUMBER,
240 X_Counter_Date OUT NOCOPY DATE,
241 X_Uom_Code OUT NOCOPY VARCHAR2,
242 X_end_reading OUT NOCOPY NUMBER,
243 X_start_reading OUT NOCOPY NUMBER,
244 X_base_reading OUT NOCOPY NUMBER,
245 X_counter_value_id OUT NOCOPY NUMBER,
246 X_counter_group_id OUT NOCOPY NUMBER,
247 X_counter_id OUT NOCOPY NUMBER,
248 X_return_status OUT NOCOPY VARCHAR2
249 );
250
251
252
253 PROCEDURE pre_terminate
254 (P_CALLEDFROM IN NUMBER DEFAULT Null,
255 x_return_status OUT NOCOPY VARCHAR2,
256 p_terminate_tbl IN TERMINATE_TBL
257 );
258
259 PROCEDURE pre_terminate
260 (P_CALLEDFROM IN NUMBER DEFAULT Null,
261 x_return_status OUT NOCOPY VARCHAR2,
262 p_id IN NUMBER,
263 p_termination_date IN DATE,
264 p_termination_amount IN NUMBER DEFAULT NULL, -- user input for termination
265 p_con_termination_amount IN NUMBER DEFAULT NULL,-- actual value to be terminated
266 --p_existing_credit IN NUMBER DEFAULT NULL,
267 p_reason_code IN VARCHAR2 DEFAULT NULL,
268 p_flag IN NUMBER DEFAULT NULL,
269 p_termination_flag IN NUMBER DEFAULT 1,
270 p_suppress_credit IN VARCHAR2 DEFAULT 'N',
271 p_full_credit IN varchar2, --(Y/N -for full credit)
272 P_Term_Date_flag IN VARCHAR2 DEFAULT 'N',
273 P_Term_Cancel_source IN VARCHAR2 DEFAULT NULL
274 );
275
276 PROCEDURE terminate_subscribtion_line
277 (
278 P_CALLEDFROM IN NUMBER DEFAULT NULL,
279 p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 p_line_id IN NUMBER,
285 p_termination_date IN DATE,
286 p_termination_amount IN NUMBER DEFAULT NULL,
287 p_con_termination_amount IN NUMBER DEFAULT NULL,
288 p_billed_amount IN NUMBER,
289 p_shipped_amount IN NUMBER,
290 p_next_ship_date IN DATE,
291 --p_existing_credit IN NUMBER ,
292 p_suppress_credit IN VARCHAR2 DEFAULT 'N' ,
293 p_tang IN BOOLEAN,
294 p_full_credit IN varchar2
295 );
296
297
298 PROCEDURE pre_terminate_service
299 (
300 P_CALLEDFROM IN NUMBER DEFAULT NULL,
301 p_api_version IN NUMBER,
302 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 p_k_line_id IN NUMBER,
307 p_termination_date IN DATE,
308 p_termination_amount IN NUMBER DEFAULT NULL,
309 p_con_termination_amount IN NUMBER DEFAULT NULL,
310 --p_existing_credit IN NUMBER DEFAULT NULL,
311 p_termination_flag IN NUMBER DEFAULT NULL, -- 1 - regular, 2- simulation
312 p_suppress_credit IN VARCHAR2 DEFAULT 'N',
313 p_full_credit IN varchar2 ,
314 x_amount OUT NOCOPY NUMBER
315 );
316
317
318 procedure get_bill_amount_period (
319 P_CALLEDFROM IN NUMBER,
320 p_con_start_date IN DATE,
321 p_con_end_date IN DATE,
322 p_bill_calc_period IN VARCHAR2,
323 p_con_amount IN NUMBER,
324 p_bill_start_date IN DATE,
325 p_bill_end_date IN DATE,
326 p_stat IN NUMBER,
327 x_amount OUT NOCOPY NUMBER
328 );
329
330
331 /****
332 Procedure create_bank_Account(
333 p_dnz_chr_id IN NUMBER,
334 p_bill_start_date IN DATE,
335 p_currency_code IN VARCHAR2,
336 x_status OUT NOCOPY VARCHAR2,
337 l_msg_count IN OUT NOCOPY NUMBER,
338 l_msg_data IN OUT NOCOPY VARCHAR2);
339 ****/
340
341
342
343
344 PROCEDURE insert_bcl
345 (
346 P_CALLEDFROM IN NUMBER,
347 X_RETURN_STAT OUT NOCOPY VARCHAR2,
348 p_CLE_ID IN NUMBER,
349 p_DATE_BILLED_FROM IN DATE,
350 P_DATE_BILLED_TO IN DATE,
351 P_DATE_NEXT_INVOICE IN DATE,
352 P_BILL_ACTION IN VARCHAR2,
353 P_OKL_FLAG IN NUMBER,
354 P_PRV IN NUMBER,
355 P_MSG_COUNT IN OUT NOCOPY NUMBER,
356 P_MSG_DATA IN OUT NOCOPY VARCHAR2,
357 X_BCL_ID IN OUT NOCOPY NUMBER
358 );
359
360 PROCEDURE get_bcl_id
361 (
362 P_CALLEDFROM IN NUMBER,
363 x_return_stat OUT NOCOPY VARCHAR2,
364 p_CLE_ID IN NUMBER,
365 p_DATE_BILLED_FROM IN DATE,
366 P_DATE_BILLED_TO IN DATE,
367 P_BILL_ACTION IN VARCHAR2,
368 x_bcl_id OUT NOCOPY NUMBER,
369 x_bcl_amount OUT NOCOPY NUMBER,
370 p_prv IN NUMBER
371 );
372
373 PROCEDURE insert_all_subline
374 (
375 P_CALLEDFROM IN NUMBER,
376 X_RETURN_STAT OUT NOCOPY VARCHAR2,
377 P_COVERED_TBL IN OUT NOCOPY COVERED_TBL,
378 P_CURRENCY_CODE IN VARCHAR2,
379 P_DNZ_CHR_ID IN NUMBER,
380 P_PRV IN NUMBER,
381 P_MSG_COUNT IN OUT NOCOPY NUMBER,
382 P_MSG_DATA IN OUT NOCOPY VARCHAR2
383 );
384
385 PROCEDURE update_bsl
386 (
387 x_ret_stat OUT NOCOPY VARCHAR2,
388 p_dnz_chr_id IN NUMBER,
389 p_bsl_id IN NUMBER,
390 p_bcl_id IN NUMBER,
391 P_AMOUNT IN NUMBER,
392 P_CURRENCY_CODE IN VARCHAR2,
393 P_PRV IN NUMBER
394 );
395
396 PROCEDURE update_bcl
397 (
398 P_CALLEDFROM IN NUMBER,
399 x_ret_stat OUT NOCOPY VARCHAR2,
400 p_bcl_id IN NUMBER,
401 P_SENT_YN IN VARCHAR2,
402 P_BILL_ACTION IN VARCHAR2,
403 P_AMOUNT IN NUMBER,
404 P_CURRENCY_CODE IN VARCHAR2,
405 P_PRV IN NUMBER
406 );
407
408
409 PROCEDURE Get_Bill_profile
410 (
411 p_dnz_chr_id IN NUMBER,
412 x_bill_profile OUT NOCOPY VARCHAR2
413 );
414
415
416 PROCEDURE Adjust_Negotiated_Price
417 (
418 p_calledfrom IN NUMBER,
419 p_contract_id IN NUMBER,
420 x_msg_count OUT NOCOPY NUMBER,
421 x_msg_data OUT NOCOPY VARCHAR2,
422 x_return_status OUT NOCOPY VARCHAR2
423 );
424
425 PROCEDURE pre_terminate_amount
426 (
427 P_CALLEDFROM IN NUMBER DEFAULT Null,
428 p_id IN NUMBER,
429 p_terminate_date IN DATE,
430 p_flag IN NUMBER,
431 X_Amount OUT NOCOPY NUMBER,
432 --X_manual_credit OUT NOCOPY NUMBER,
433 X_return_status OUT NOCOPY VARCHAR2);
434
435
436 PROCEDURE get_subscr_terminate_amount
437 (
438 P_CALLEDFROM IN NUMBER DEFAULT Null,
439 p_line_id IN NUMBER,
440 p_terminate_date IN DATE,
441 p_billed_amount IN NUMBER,
442 p_shipped_amount IN NUMBER,
443 p_max_bill_date IN DATE,
444 p_max_ship_date IN DATE,
445 X_amount OUT NOCOPY NUMBER,
446 X_return_status OUT NOCOPY VARCHAR2
447 );
448
449 -------------------------------------------------------------------------
450 -- Begin partial period computation logic
451 -- Developer Mani Choudhary
452 -- Date 11-JUN-2005
453 -- Added additional period_type,period_start parameter
454 -------------------------------------------------------------------------
455 PROCEDURE get_terminate_amount
456 (
457 P_CALLEDFROM IN NUMBER DEFAULT Null,
458 p_line_id IN NUMBER,
459 p_cov_line IN VARCHAR2,
460 p_terminate_date IN DATE,
461 p_period_start IN VARCHAR2 DEFAULT NULL,
462 p_period_type IN VARCHAR2 DEFAULT NULL,
463 X_amount OUT NOCOPY NUMBER,
464 X_return_status OUT NOCOPY VARCHAR2
465 );
466
467
468 PROCEDURE pre_terminate_cp
469 (
470 P_CALLEDFROM IN NUMBER DEFAULT Null,
471 --p_chr_id IN NUMBER,
472 p_cle_id IN NUMBER,
473 p_termination_date IN DATE,
474 p_terminate_reason IN VARCHAR2,
475 p_override_amount IN NUMBER,
476 p_con_terminate_amount IN NUMBER,
477 --p_existing_credit IN NUMBER,
478 p_termination_amount IN NUMBER,
479 p_suppress_credit IN VARCHAR2,
480 p_full_credit IN VARCHAR2,
481 P_Term_Date_flag IN VARCHAR2 DEFAULT 'N',
482 P_Term_Cancel_source IN VARCHAR2 DEFAULT NULL,
483 X_return_status OUT NOCOPY VARCHAR2
484 );
485
486 PROCEDURE Terminate_cp
487 (
488 P_CALLEDFROM IN NUMBER DEFAULT NUll,
489 p_top_line_id IN NUMBER,
490 p_cp_line_id IN NUMBER,
491 p_termination_date IN DATE,
492 p_terminate_reason IN VARCHAR2,
493 p_override_amount IN NUMBER,
494 p_con_terminate_amount IN NUMBER,
495 --p_existing_credit IN NUMBER,
496 p_termination_amount IN NUMBER,
497 p_suppress_credit IN VARCHAR2,
498 p_full_credit IN VARCHAR2,
499 p_term_method IN VARCHAR2,
500 p_usage_type IN VARCHAR2,
501 p_usage_period IN VARCHAR2,
502 P_Term_Cancel_source IN VARCHAR2,
503 X_return_status OUT NOCOPY VARCHAR2
504 );
505
506
507 -------------------------------------------------------------------------
508 -- Begin partial period computation logic
509 -- Developer Mani Choudhary
510 -- Date 11-JUN-2005
511 -- Added additional period_type parameter
512 -------------------------------------------------------------------------
513 PROCEDURE Usage_qty_to_bill
514 (
515 P_calledfrom IN NUMBER DEFAULT NULL,
516 P_cle_id IN NUMBER,
517 P_Usage_type IN VARCHAR2,
518 P_estimation_flag IN VARCHAR2,
519 P_estimation_method IN VARCHAR2,
520 p_default_qty IN NUMBER,
521 P_cov_start_date IN DATE,
522 P_cov_end_date IN DATE,
523 P_cov_prd_start_date IN DATE,
524 P_cov_prd_end_date IN DATE,
525 p_usage_period IN VARCHAR2,
526 p_time_uom_code IN VARCHAR2,
527 p_settle_interval IN VARCHAR2,
528 p_minimum_quantity IN NUMBER,
529 p_usg_est_start_date IN DATE,
530 p_period_type IN VARCHAR2, -- period type
531 p_period_start IN VARCHAR2, -- period start
532 X_qty OUT NOCOPY NUMBER,
533 X_Uom_Code OUT NOCOPY VARCHAR2,
534 X_flag OUT NOCOPY VARCHAR2,
535 X_end_reading OUT NOCOPY NUMBER,
536 X_start_reading OUT NOCOPY NUMBER,
537 X_base_reading OUT NOCOPY NUMBER,
538 X_estimated_qty OUT NOCOPY NUMBER,
539 X_actual_qty OUT NOCOPY NUMBER,
540 X_counter_value_id OUT NOCOPY NUMBER,
541 X_counter_group_id OUT NOCOPY NUMBER,
542 X_return_status OUT NOCOPY VARCHAR2
543 );
544
545
546 -------------------------------------------------------------------------
547 -- Begin partial period computation logic
548 -- Developer Mani Choudhary
549 -- Date 11-JUN-2005
550 -- Added period start and period type parameters
551 -------------------------------------------------------------------------
552 PROCEDURE Create_trx_records(
553 p_called_from IN NUMBER DEFAULT Null ,
554 p_top_line_id IN NUMBER,
555 p_cov_line_id IN NUMBER,
556 p_date_from IN DATE,
557 p_date_to IN DATE,
558 p_amount IN NUMBER,
559 p_override_amount IN NUMBER,
560 p_suppress_credit IN VARCHAR2,
561 p_con_terminate_amount IN NUMBER,
562 --p_existing_credit IN NUMBER,
563 p_bill_action IN VARCHAR2,
564 p_period_start IN VARCHAR2 DEFAULT NULL,
565 p_period_type IN VARCHAR2 DEFAULT NULL,
566 x_return_status OUT NOCOPY VARCHAR2,
567 p_termination_Date IN DATE DEFAULT NULL ----skuchima bug#11691332
568 );
569
570 Procedure get_termination_details ( p_level IN VARCHAR2 ,
571 p_id IN NUMBER ,
572 x_unbilled OUT NOCOPY NUMBER ,
573 x_credited OUT NOCOPY NUMBER ,
574 x_suppressed OUT NOCOPY NUMBER ,
575 x_overridden OUT NOCOPY NUMBER ,
576 x_billed OUT NOCOPY NUMBER ,
577 x_return_status OUT NOCOPY VARCHAR2 );
578
579 Procedure prorate_price_breaks (P_BSL_ID IN NUMBER,
580 P_BREAK_AMOUNT IN NUMBER,
581 P_TOT_AMOUNT IN NUMBER,
582 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ) ;
583
584
585 ------------------------------------------------------------------------
586 -- Begin partial period computation logic
587 -- Developer Mani Choudhary
588 -- Date 27-MAY-2005
589 -- DESCRIPTION:
590 -- This function will be called for Usage Line Types of Fixed and to
591 -- compute Minimum and Default for Actual per Period and Actual by Quantity.
592 ---------------------------------------------------------------------------
593 Function Get_Prorated_Usage_Qty
594 (
595 p_start_date IN DATE,
596 p_end_date IN DATE,
597 p_qty IN NUMBER,
598 p_usage_uom IN VARCHAR2,
599 p_billing_uom IN VARCHAR2,
600 p_period_type IN VARCHAR2
601 )
602 RETURN NUMBER;
603
604 END OKS_BILL_REC_PUB;
605