1 PACKAGE CS_CONTRACT_BILLING AUTHID CURRENT_USER as
2 /* $Header: csctbils.pls 115.0 99/07/16 08:48:58 porting ship $ */
3
4 PROCEDURE generate_billing_lines(
5 ERRBUF OUT VARCHAR2,
6 RETCODE OUT NUMBER,
7 P_DEFAULT_DATE IN DATE,
8 P_WINDOW IN NUMBER,
9 P_CONTRACT_NUMBER IN NUMBER
10 );
11
12 FUNCTION get_billing_lines(
13 P_DATE_RANGE IN DATE,
14 P_CONTRACT_NUMBER IN NUMBER
15 ) RETURN NUMBER;
16
17 PROCEDURE Process_And_Insert_Records
18 (
19 P_BILLED_UNTIL_DATE IN OUT DATE,
20 P_NEXT_BILL_DATE IN OUT DATE,
21 P_BILL_ON IN OUT NUMBER,
22 P_FIRST_BILL_DATE IN DATE,
23 P_START_DATE_ACTIVE IN DATE,
24 P_END_DATE_ACTIVE IN DATE,
25 P_CONTRACT_ID IN NUMBER,
26 P_CP_SERVICE_ID IN NUMBER,
27 P_INVOICE_AMOUNT IN NUMBER,
28 P_EXTENDED_PRICE IN NUMBER,
29 P_DURATION_QUANTITY IN NUMBER,
30 P_SERVICE_INVENTORY_ITEM_ID IN NUMBER,
31 P_UNIT_OF_MEASURE_CODE IN VARCHAR2,
32 P_BILLING_FREQUENCY_PERIOD IN VARCHAR2
33 ) ;
34
35 FUNCTION Process_Billing_records
36 (
37 P_BILLING_AMOUNT OUT NUMBER,
38 P_BILLED_FROM_DATE OUT DATE ,
39 P_BILLED_UNTIL_DATE IN OUT DATE ,
40 P_NEXT_BILL_DATE IN OUT DATE ,
41 P_BILL_ON IN OUT NUMBER ,
42 P_FIRST_BILL_DATE IN DATE ,
43 P_START_DATE_ACTIVE IN DATE ,
44 P_END_DATE_ACTIVE IN DATE ,
45 P_INVOICE_AMOUNT IN NUMBER ,
46 P_EXTENDED_PRICE IN NUMBER ,
47 P_DURATION_QUANTITY IN NUMBER ,
48 P_SERVICE_INVENTORY_ITEM_ID IN NUMBER ,
49 P_UNIT_OF_MEASURE_CODE IN VARCHAR2 ,
50 P_BILLING_FREQUENCY_PERIOD IN VARCHAR2
51 )RETURN NUMBER;
52
53 FUNCTION Process_First_Bill_Date
54 (
55 P_BILLING_AMOUNT OUT NUMBER,
56 P_BILLED_FROM_DATE OUT DATE ,
57 P_BILLED_UNTIL_DATE IN OUT DATE ,
58 P_NEXT_BILL_DATE IN OUT DATE ,
59 P_BILL_ON IN OUT NUMBER ,
60 P_FIRST_BILL_DATE IN DATE ,
61 P_START_DATE_ACTIVE IN DATE ,
62 P_END_DATE_ACTIVE IN DATE ,
63 P_EXTENDED_PRICE IN NUMBER ,
64 P_DURATION_QUANTITY IN NUMBER ,
65 P_SERVICE_INVENTORY_ITEM_ID IN NUMBER ,
66 P_UNIT_OF_MEASURE_CODE IN VARCHAR2 ,
67 P_BILLING_FREQUENCY_PERIOD IN VARCHAR2
68 )RETURN NUMBER;
69
70 FUNCTION Process_Next_Bill_Date
71 (
72 P_BILLING_AMOUNT OUT NUMBER,
73 P_BILLED_FROM_DATE OUT DATE ,
74 P_BILLED_UNTIL_DATE IN OUT DATE ,
75 P_NEXT_BILL_DATE IN OUT DATE ,
76 P_BILL_ON IN OUT NUMBER ,
77 P_FIRST_BILL_DATE IN DATE ,
78 P_START_DATE_ACTIVE IN DATE ,
79 P_END_DATE_ACTIVE IN DATE ,
80 P_INVOICE_AMOUNT IN NUMBER ,
81 P_EXTENDED_PRICE IN NUMBER ,
82 P_DURATION_QUANTITY IN NUMBER ,
83 P_SERVICE_INVENTORY_ITEM_ID IN NUMBER ,
84 P_UNIT_OF_MEASURE_CODE IN VARCHAR2 ,
85 P_BILLING_FREQUENCY_PERIOD IN VARCHAR2
86 )RETURN NUMBER;
87
88 FUNCTION get_invoiced_amount(
89 P_INVOICED_SERVICE_AMOUNT OUT NUMBER,
90 P_BILLED_UNTIL_DATE OUT DATE,
91 P_CONTRACT_ID IN NUMBER,
92 P_CP_SERVICE_ID IN NUMBER
93 ) return NUMBER;
94
95 PROCEDURE Print_Error;
96
97 FUNCTION Insert_cs_cont_bill_iface
98 (
99 P_BILLING_AMOUNT IN NUMBER,
100 P_billed_from_date IN DATE,
101 P_billed_until_date IN DATE,
102 P_transaction_date IN DATE,
103 P1_CONTRACT_ID IN NUMBER,
104 P1_CP_SERVICE_ID IN NUMBER,
105 P_quantity IN NUMBER
106 ) RETURN NUMBER;
107
108 FUNCTION Update_CS_CP_Services
109 (
110 P_CONTRACT_ID IN NUMBER,
111 P_CP_SERVICE_ID IN NUMBER,
112 P_NEXT_BILL_DATE IN DATE
113 ) RETURN NUMBER;
114
115
116
117 PROCEDURE Calc_Actual_Next_Bill_date(
118 P_NEXT_BILL_DATE IN OUT DATE,
119 P_BILL_ON IN OUT NUMBER
120 );
121
122 FUNCTION Calculate_Next_Bill_date(
123 P_LAST_TXN_DATE IN DATE,
124 P_END_DATE_ACTIVE IN DATE,
125 P_BILL_ON IN OUT NUMBER,
126 P_INVENTORY_ITEM_ID IN NUMBER,
127 P_FROM_UNIT IN VARCHAR2
128 )RETURN DATE;
129
130 FUNCTION Get_Final_Adjustment(
131 P_CONC_PROGRAM IN VARCHAR2,
132 P_TXN_START_DATE IN DATE,
133 P_TXN_END_DATE IN DATE,
134 P_SERVICE_AMOUNT IN NUMBER,
135 P_SERVICE_DURATION IN NUMBER,
136 P_INVENTORY_ITEM_ID IN NUMBER,
137 P_SERVICE_PERIOD IN VARCHAR2,
138 P_BILL_FREQUENCY IN VARCHAR2
139 )RETURN NUMBER;
140
141 FUNCTION Calculate_Txn_Amount(
142 P_CONC_PROGRAM IN VARCHAR2,
143 P_TXN_START_DATE IN DATE,
144 P_TXN_END_DATE IN DATE,
145 P_SERVICE_AMOUNT IN NUMBER,
146 P_SERVICE_DURATION IN NUMBER,
147 P_INVENTORY_ITEM_ID IN NUMBER,
148 P_SERVICE_PERIOD IN VARCHAR2,
149 P_BILL_FREQUENCY IN VARCHAR2
150 )RETURN NUMBER;
151
152 FUNCTION Calculate_Average_Amount(
153 P_CONC_PROGRAM IN VARCHAR2,
154 P_SERVICE_AMOUNT IN NUMBER,
155 P_SERVICE_DURATION IN NUMBER,
156 P_INVENTORY_ITEM_ID IN NUMBER,
157 P_FROM_UNIT IN VARCHAR2,
158 P_TO_UNIT IN VARCHAR2
159 ) RETURN NUMBER;
160 FUNCTION Convert_Duration(
161 P_CONC_PROGRAM IN VARCHAR2,
162 P_SERVICE_DURATION IN NUMBER,
163 P_INVENTORY_ITEM_ID IN NUMBER,
164 P_FROM_UNIT IN VARCHAR2,
165 P_TO_UNIT IN VARCHAR2
166 )RETURN NUMBER;
167
168
169 END CS_CONTRACT_BILLING;