DBA Data[Home] [Help]

PACKAGE: APPS.CS_CONTRACTBILLING_PVT

Source


1 Package CS_CONTRACTBILLING_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctcbps.pls 115.0 99/07/16 08:49:18 porting ship  $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   TYPE ContractBilling_Rec_Type IS RECORD (
7     contract_billing_id            NUMBER := NULL,
8     header_id                      NUMBER := NULL,
9     order_number                   NUMBER := NULL,
10     line_id                        NUMBER := NULL,
11     cp_service_id                  NUMBER := NULL,
12     contract_id                    NUMBER := NULL,
13     cust_trx_type_id               NUMBER := NULL,
14     trx_date                       CS_CONTRACTS_BILLING.TRX_DATE%TYPE := NULL,
15     trx_number                     NUMBER := NULL,
16     trx_amount                     NUMBER := NULL,
17     trx_class                      CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := NULL,
18     billed_until_date              CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,
19     currency_code                  CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := NULL,
20     last_update_date               CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := NULL,
21     last_updated_by                NUMBER := NULL,
22     creation_date                  CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := NULL,
23     created_by                     NUMBER := NULL,
24     last_update_login              NUMBER := NULL,
25     trx_pre_tax_amount             NUMBER := NULL,
26     attribute1                     CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,
27     attribute2                     CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,
28     attribute3                     CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
29     attribute4                     CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
30     attribute5                     CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
31     attribute6                     CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
32     attribute7                     CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
33     attribute8                     CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
34     attribute9                     CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
35     attribute10                    CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
36     attribute11                    CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
37     attribute12                    CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
38     attribute13                    CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
39     attribute14                    CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,
40     attribute15                    CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,
41     context                        CS_CONTRACTS_BILLING.CONTEXT%TYPE := NULL,
42     object_version_number          NUMBER := NULL);
43   G_MISS_contractbilling_rec              ContractBilling_Rec_Type;
44   TYPE ContractBilling_Val_Rec_Type IS RECORD (
45     contract_billing_id            NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
46     header_id                      NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
47     order_number                   NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
48     line_id                        NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
49     cp_service_id                  NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
50     contract_id                    NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
51     cust_trx_type_id               NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
52     trx_date                       CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
53     trx_number                     NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
54     trx_amount                     NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
55     trx_class                      CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
56     billed_until_date              CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
57     currency_code                  CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
58     last_update_date               CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
59     last_updated_by                NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
60     creation_date                  CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
61     created_by                     NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
62     last_update_login              NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
63     trx_pre_tax_amount             NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
64     attribute1                     CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
65     attribute2                     CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
66     attribute3                     CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
67     attribute4                     CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
68     attribute5                     CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
69     attribute6                     CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
70     attribute7                     CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
71     attribute8                     CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
72     attribute9                     CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
73     attribute10                    CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
74     attribute11                    CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
75     attribute12                    CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
76     attribute13                    CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
77     attribute14                    CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
78     attribute15                    CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
79     context                        CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
80     object_version_number          NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
81   G_MISS_contractbilling_val_rec          ContractBilling_Val_Rec_Type;
82   ---------------------------------------------------------------------------
83   -- GLOBAL MESSAGE CONSTANTS
84   ---------------------------------------------------------------------------
85   G_FND_APP			CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
86   G_FORM_UNABLE_TO_RESERVE_REC	CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
87   G_FORM_RECORD_DELETED		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
88   G_FORM_RECORD_CHANGED		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
89   G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
90   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
91   G_INVALID_VALUE			CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
92   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
93   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
94   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
95   ---------------------------------------------------------------------------
96   -- GLOBAL VARIABLES
97   ---------------------------------------------------------------------------
98   G_PKG_NAME			CONSTANT	VARCHAR2(200) := 'CS_CONTRACTBILLING_PVT';
99   G_APP_NAME			CONSTANT 	VARCHAR2(3) :=  TAPI_DEV_KIT.G_APP_NAME;
100   ---------------------------------------------------------------------------
101   -- Procedures and Functions
102   ---------------------------------------------------------------------------
103 
104   PROCEDURE insert_row
105   (
106     p_api_version                  IN NUMBER,
107     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
108     p_validation_level             IN NUMBER,
109     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
110     x_return_status                OUT VARCHAR2,
111     x_msg_count                    OUT NUMBER,
112     x_msg_data                     OUT VARCHAR2,
113     p_contractbilling_rec          IN ContractBilling_Rec_Type := G_MISS_CONTRACTBILLING_REC,
114     x_contract_billing_id          OUT NUMBER,
115     x_object_version_number        OUT NUMBER);
116   PROCEDURE insert_row
117   (
118     p_api_version                  IN NUMBER,
119     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
120     p_validation_level             IN NUMBER,
121     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
122     x_return_status                OUT VARCHAR2,
123     x_msg_count                    OUT NUMBER,
124     x_msg_data                     OUT VARCHAR2,
125     p_header_id                    IN NUMBER := NULL,
126     p_order_number                 IN NUMBER := NULL,
127     p_line_id                      IN NUMBER := NULL,
128     p_cp_service_id                IN NUMBER := NULL,
129     p_contract_id                  IN NUMBER := NULL,
130     p_cust_trx_type_id             IN NUMBER := NULL,
131     p_trx_date                     IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := NULL,
132     p_trx_number                   IN NUMBER := NULL,
133     p_trx_amount                   IN NUMBER := NULL,
134     p_trx_class                    IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := NULL,
135     p_billed_until_date            IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,
136     p_currency_code                IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := NULL,
137     p_last_update_date             IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := NULL,
138     p_last_updated_by              IN NUMBER := NULL,
139     p_creation_date                IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := NULL,
140     p_created_by                   IN NUMBER := NULL,
141     p_last_update_login            IN NUMBER := NULL,
142     p_trx_pre_tax_amount           IN NUMBER := NULL,
143     p_attribute1                   IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,
144     p_attribute2                   IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,
145     p_attribute3                   IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
146     p_attribute4                   IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
147     p_attribute5                   IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
148     p_attribute6                   IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
149     p_attribute7                   IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
150     p_attribute8                   IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
151     p_attribute9                   IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
152     p_attribute10                  IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
153     p_attribute11                  IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
154     p_attribute12                  IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
155     p_attribute13                  IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
156     p_attribute14                  IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,
157     p_attribute15                  IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,
158     p_context                      IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := NULL,
159     p_object_version_number        IN NUMBER := NULL,
160     x_contract_billing_id          OUT NUMBER,
161     x_object_version_number        OUT NUMBER);
162   Procedure lock_row
163   (
164     p_api_version                  IN NUMBER,
165     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
166     p_validation_level             IN NUMBER,
167     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
168     x_return_status                OUT VARCHAR2,
169     x_msg_count                    OUT NUMBER,
170     x_msg_data                     OUT VARCHAR2,
171     p_contract_billing_id          IN NUMBER,
172     p_object_version_number        IN NUMBER);
173   Procedure update_row
174   (
175     p_api_version                  IN NUMBER,
176     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
177     p_validation_level             IN NUMBER,
178     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
179     x_return_status                OUT VARCHAR2,
180     x_msg_count                    OUT NUMBER,
181     x_msg_data                     OUT VARCHAR2,
182     p_contractbilling_val_rec      IN ContractBilling_Val_Rec_Type := G_MISS_CONTRACTBILLING_VAL_REC,
183     x_object_version_number        OUT NUMBER);
184   Procedure update_row
185   (
189     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
186     p_api_version                  IN NUMBER,
187     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
188     p_validation_level             IN NUMBER,
190     x_return_status                OUT VARCHAR2,
191     x_msg_count                    OUT NUMBER,
192     x_msg_data                     OUT VARCHAR2,
193     p_contract_billing_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
194     p_header_id                    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195     p_order_number                 IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196     p_line_id                      IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197     p_cp_service_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
198     p_contract_id                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
199     p_cust_trx_type_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
200     p_trx_date                     IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
201     p_trx_number                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
202     p_trx_amount                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
203     p_trx_class                    IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
204     p_billed_until_date            IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
205     p_currency_code                IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
206     p_last_update_date             IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
207     p_last_updated_by              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
208     p_creation_date                IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
209     p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
210     p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
211     p_trx_pre_tax_amount           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
212     p_attribute1                   IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
213     p_attribute2                   IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
214     p_attribute3                   IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
215     p_attribute4                   IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
216     p_attribute5                   IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
217     p_attribute6                   IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
218     p_attribute7                   IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
219     p_attribute8                   IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
220     p_attribute9                   IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
221     p_attribute10                  IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
222     p_attribute11                  IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
223     p_attribute12                  IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
224     p_attribute13                  IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
225     p_attribute14                  IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
226     p_attribute15                  IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
227     p_context                      IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
228     p_object_version_number        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
229     x_object_version_number        OUT NUMBER);
230   Procedure delete_row
231   (
232     p_api_version                  IN NUMBER,
233     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
234     p_validation_level             IN NUMBER,
235     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
236     x_return_status                OUT VARCHAR2,
237     x_msg_count                    OUT NUMBER,
238     x_msg_data                     OUT VARCHAR2,
239     p_contract_billing_id          IN NUMBER);
240   PROCEDURE validate_row
241   (
242     p_api_version                  IN NUMBER,
243     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
244     p_validation_level             IN NUMBER,
245     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
246     x_return_status                OUT VARCHAR2,
247     x_msg_count                    OUT NUMBER,
248     x_msg_data                     OUT VARCHAR2,
249     p_contractbilling_val_rec      IN ContractBilling_Val_Rec_Type := G_MISS_CONTRACTBILLING_VAL_REC);
250   PROCEDURE validate_row
251   (
252     p_api_version                  IN NUMBER,
253     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
254     p_validation_level             IN NUMBER,
255     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
256     x_return_status                OUT VARCHAR2,
257     x_msg_count                    OUT NUMBER,
258     x_msg_data                     OUT VARCHAR2,
259     p_contract_billing_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
260     p_header_id                    IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
261     p_order_number                 IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
262     p_line_id                      IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
263     p_cp_service_id                IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
264     p_contract_id                  IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
265     p_cust_trx_type_id             IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
266     p_trx_date                     IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
267     p_trx_number                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
268     p_trx_amount                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
269     p_trx_class                    IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
273     p_last_updated_by              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
270     p_billed_until_date            IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
271     p_currency_code                IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
272     p_last_update_date             IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
274     p_creation_date                IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
275     p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
276     p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
277     p_trx_pre_tax_amount           IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
278     p_attribute1                   IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
279     p_attribute2                   IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
280     p_attribute3                   IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
281     p_attribute4                   IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
282     p_attribute5                   IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
283     p_attribute6                   IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
284     p_attribute7                   IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
285     p_attribute8                   IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
286     p_attribute9                   IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
287     p_attribute10                  IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
288     p_attribute11                  IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
289     p_attribute12                  IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
290     p_attribute13                  IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
291     p_attribute14                  IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
292     p_attribute15                  IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
293     p_context                      IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
294     p_object_version_number        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
295 END CS_CONTRACTBILLING_PVT;