[Home] [Help]
PACKAGE: APPS.CS_SERVICETRAN_PVT
Source
1 Package CS_SERVICETRAN_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctstrs.pls 115.0 99/07/16 08:54:38 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ServiceTran_Rec_Type IS RECORD (
7 cp_service_transaction_id NUMBER := NULL,
8 last_update_date CS_CP_SERVICE_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := NULL,
9 last_updated_by NUMBER := NULL,
10 creation_date CS_CP_SERVICE_TRANSACTIONS.CREATION_DATE%TYPE := NULL,
11 created_by NUMBER := NULL,
12 last_update_login NUMBER := NULL,
13 cp_service_id NUMBER := NULL,
14 transaction_type_code CS_CP_SERVICE_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE := NULL,
15 resulting_status_code CS_CP_SERVICE_TRANSACTIONS.RESULTING_STATUS_CODE%TYPE := NULL,
16 effective_start_date CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_START_DATE%TYPE := NULL,
17 effective_end_date CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_END_DATE%TYPE := NULL,
18 current_end_date CS_CP_SERVICE_TRANSACTIONS.CURRENT_END_DATE%TYPE := NULL,
19 terminated_transaction_id NUMBER := NULL,
20 reason_code CS_CP_SERVICE_TRANSACTIONS.REASON_CODE%TYPE := NULL,
21 reason_comments CS_CP_SERVICE_TRANSACTIONS.REASON_COMMENTS%TYPE := NULL,
22 service_selling_price NUMBER := NULL,
23 currency_code CS_CP_SERVICE_TRANSACTIONS.CURRENCY_CODE%TYPE := NULL,
24 conversion_type CS_CP_SERVICE_TRANSACTIONS.CONVERSION_TYPE%TYPE := NULL,
25 conversion_rate NUMBER := NULL,
26 conversion_date CS_CP_SERVICE_TRANSACTIONS.CONVERSION_DATE%TYPE := NULL,
27 invoicing_rule_id NUMBER := NULL,
28 accounting_rule_id NUMBER := NULL,
29 payment_terms_id NUMBER := NULL,
30 service_order_line_id NUMBER := NULL,
31 service_order_number NUMBER := NULL,
32 service_order_date CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := NULL,
33 service_order_type CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := NULL,
34 invoice_flag CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := NULL,
35 coverage_schedule_id NUMBER := NULL,
36 duration_quantity NUMBER := NULL,
37 unit_of_measure_code CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
38 starting_delay NUMBER := NULL,
39 bill_to_site_use_id NUMBER := NULL,
40 bill_to_contact_id NUMBER := NULL,
41 prorate_flag CS_CP_SERVICE_TRANSACTIONS.PRORATE_FLAG%TYPE := NULL,
42 ra_interface_status CS_CP_SERVICE_TRANSACTIONS.RA_INTERFACE_STATUS%TYPE := NULL,
43 invoice_count NUMBER := NULL,
44 price_list_id NUMBER := NULL,
45 attribute1 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE1%TYPE := NULL,
46 attribute2 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE2%TYPE := NULL,
47 attribute3 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE3%TYPE := NULL,
48 attribute4 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE4%TYPE := NULL,
49 attribute5 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE5%TYPE := NULL,
50 attribute6 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE6%TYPE := NULL,
51 attribute7 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE7%TYPE := NULL,
52 attribute8 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE8%TYPE := NULL,
53 attribute9 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE9%TYPE := NULL,
54 attribute10 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE10%TYPE := NULL,
55 attribute11 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE11%TYPE := NULL,
56 attribute12 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE12%TYPE := NULL,
57 attribute13 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE13%TYPE := NULL,
58 attribute14 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE14%TYPE := NULL,
59 attribute15 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE15%TYPE := NULL,
60 context CS_CP_SERVICE_TRANSACTIONS.CONTEXT%TYPE := NULL,
61 pricing_attribute1 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE1%TYPE := NULL,
62 pricing_attribute2 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE2%TYPE := NULL,
63 pricing_attribute3 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE3%TYPE := NULL,
64 pricing_attribute4 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE4%TYPE := NULL,
65 pricing_attribute5 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE5%TYPE := NULL,
66 pricing_attribute6 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE6%TYPE := NULL,
67 pricing_attribute7 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE7%TYPE := NULL,
68 pricing_attribute8 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE8%TYPE := NULL,
69 pricing_attribute9 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE9%TYPE := NULL,
70 pricing_attribute10 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE10%TYPE := NULL,
71 pricing_attribute11 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE11%TYPE := NULL,
72 pricing_attribute12 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE12%TYPE := NULL,
73 pricing_attribute13 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE13%TYPE := NULL,
74 pricing_attribute14 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE14%TYPE := NULL,
75 pricing_attribute15 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE15%TYPE := NULL,
76 pricing_context CS_CP_SERVICE_TRANSACTIONS.PRICING_CONTEXT%TYPE := NULL,
77 credit_amount NUMBER := NULL,
78 purchase_order_num CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := NULL);
79 G_MISS_servicetran_rec ServiceTran_Rec_Type;
80 TYPE ServiceTran_Val_Rec_Type IS RECORD (
81 cp_service_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
82 last_update_date CS_CP_SERVICE_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
83 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
84 creation_date CS_CP_SERVICE_TRANSACTIONS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
85 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
86 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
87 cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
88 transaction_type_code CS_CP_SERVICE_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
89 resulting_status_code CS_CP_SERVICE_TRANSACTIONS.RESULTING_STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
90 effective_start_date CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
91 effective_end_date CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
92 current_end_date CS_CP_SERVICE_TRANSACTIONS.CURRENT_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
93 terminated_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
94 reason_code CS_CP_SERVICE_TRANSACTIONS.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
95 reason_comments CS_CP_SERVICE_TRANSACTIONS.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
96 service_selling_price NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
97 currency_code CS_CP_SERVICE_TRANSACTIONS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
98 conversion_type CS_CP_SERVICE_TRANSACTIONS.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
99 conversion_rate NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
100 conversion_date CS_CP_SERVICE_TRANSACTIONS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
101 invoicing_rule_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
102 accounting_rule_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
103 payment_terms_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
104 service_order_line_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
105 service_order_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
106 service_order_date CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
107 service_order_type CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
108 invoice_flag CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
109 coverage_schedule_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
110 duration_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
111 unit_of_measure_code CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
112 starting_delay NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
113 bill_to_site_use_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
114 bill_to_contact_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
115 prorate_flag CS_CP_SERVICE_TRANSACTIONS.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
116 ra_interface_status CS_CP_SERVICE_TRANSACTIONS.RA_INTERFACE_STATUS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
120 attribute2 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
117 invoice_count NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
118 price_list_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
119 attribute1 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
121 attribute3 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
122 attribute4 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
123 attribute5 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
124 attribute6 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
125 attribute7 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
126 attribute8 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
127 attribute9 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
128 attribute10 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
129 attribute11 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
130 attribute12 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
131 attribute13 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
132 attribute14 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
133 attribute15 CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
134 context CS_CP_SERVICE_TRANSACTIONS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
135 pricing_attribute1 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
136 pricing_attribute2 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
137 pricing_attribute3 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
138 pricing_attribute4 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
139 pricing_attribute5 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
140 pricing_attribute6 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141 pricing_attribute7 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
142 pricing_attribute8 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
143 pricing_attribute9 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
144 pricing_attribute10 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
145 pricing_attribute11 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146 pricing_attribute12 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147 pricing_attribute13 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
148 pricing_attribute14 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
149 pricing_attribute15 CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
153 G_MISS_servicetran_val_rec ServiceTran_Val_Rec_Type;
150 pricing_context CS_CP_SERVICE_TRANSACTIONS.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
151 credit_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
152 purchase_order_num CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR);
154 ---------------------------------------------------------------------------
155 -- GLOBAL MESSAGE CONSTANTS
156 ---------------------------------------------------------------------------
157 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
158 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
159 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
160 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
161 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
162 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
163 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
164 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
165 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
166 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
167 ---------------------------------------------------------------------------
168 -- GLOBAL VARIABLES
169 ---------------------------------------------------------------------------
170 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_SERVICETRAN_PVT';
171 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
172 ---------------------------------------------------------------------------
173 -- Procedures and Functions
174 ---------------------------------------------------------------------------
175
176 PROCEDURE insert_row
177 (
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
180 p_validation_level IN NUMBER,
181 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
182 x_return_status OUT VARCHAR2,
183 x_msg_count OUT NUMBER,
184 x_msg_data OUT VARCHAR2,
185 p_servicetran_rec IN ServiceTran_Rec_Type := G_MISS_SERVICETRAN_REC,
186 x_cp_service_transaction_id OUT NUMBER);
187 PROCEDURE insert_row
188 (
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
191 p_validation_level IN NUMBER,
192 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
193 x_return_status OUT VARCHAR2,
197 p_last_updated_by IN NUMBER := NULL,
194 x_msg_count OUT NUMBER,
195 x_msg_data OUT VARCHAR2,
196 p_last_update_date IN CS_CP_SERVICE_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := NULL,
198 p_creation_date IN CS_CP_SERVICE_TRANSACTIONS.CREATION_DATE%TYPE := NULL,
199 p_created_by IN NUMBER := NULL,
200 p_last_update_login IN NUMBER := NULL,
201 p_cp_service_id IN NUMBER := NULL,
202 p_transaction_type_code IN CS_CP_SERVICE_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE := NULL,
203 p_resulting_status_code IN CS_CP_SERVICE_TRANSACTIONS.RESULTING_STATUS_CODE%TYPE := NULL,
204 p_effective_start_date IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_START_DATE%TYPE := NULL,
205 p_effective_end_date IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_END_DATE%TYPE := NULL,
206 p_current_end_date IN CS_CP_SERVICE_TRANSACTIONS.CURRENT_END_DATE%TYPE := NULL,
207 p_terminated_transaction_id IN NUMBER := NULL,
208 p_reason_code IN CS_CP_SERVICE_TRANSACTIONS.REASON_CODE%TYPE := NULL,
209 p_reason_comments IN CS_CP_SERVICE_TRANSACTIONS.REASON_COMMENTS%TYPE := NULL,
210 p_service_selling_price IN NUMBER := NULL,
211 p_currency_code IN CS_CP_SERVICE_TRANSACTIONS.CURRENCY_CODE%TYPE := NULL,
212 p_conversion_type IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_TYPE%TYPE := NULL,
213 p_conversion_rate IN NUMBER := NULL,
214 p_conversion_date IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_DATE%TYPE := NULL,
215 p_invoicing_rule_id IN NUMBER := NULL,
216 p_accounting_rule_id IN NUMBER := NULL,
217 p_payment_terms_id IN NUMBER := NULL,
218 p_service_order_line_id IN NUMBER := NULL,
219 p_service_order_number IN NUMBER := NULL,
220 p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := NULL,
221 p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := NULL,
222 p_invoice_flag IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := NULL,
223 p_coverage_schedule_id IN NUMBER := NULL,
224 p_duration_quantity IN NUMBER := NULL,
225 p_unit_of_measure_code IN CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
226 p_starting_delay IN NUMBER := NULL,
227 p_bill_to_site_use_id IN NUMBER := NULL,
228 p_bill_to_contact_id IN NUMBER := NULL,
229 p_prorate_flag IN CS_CP_SERVICE_TRANSACTIONS.PRORATE_FLAG%TYPE := NULL,
230 p_ra_interface_status IN CS_CP_SERVICE_TRANSACTIONS.RA_INTERFACE_STATUS%TYPE := NULL,
231 p_invoice_count IN NUMBER := NULL,
232 p_price_list_id IN NUMBER := NULL,
233 p_attribute1 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE1%TYPE := NULL,
234 p_attribute2 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE2%TYPE := NULL,
235 p_attribute3 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE3%TYPE := NULL,
236 p_attribute4 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE4%TYPE := NULL,
237 p_attribute5 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE5%TYPE := NULL,
238 p_attribute6 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE6%TYPE := NULL,
239 p_attribute7 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE7%TYPE := NULL,
240 p_attribute8 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE8%TYPE := NULL,
241 p_attribute9 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE9%TYPE := NULL,
242 p_attribute10 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE10%TYPE := NULL,
243 p_attribute11 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE11%TYPE := NULL,
244 p_attribute12 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE12%TYPE := NULL,
245 p_attribute13 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE13%TYPE := NULL,
246 p_attribute14 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE14%TYPE := NULL,
247 p_attribute15 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE15%TYPE := NULL,
248 p_context IN CS_CP_SERVICE_TRANSACTIONS.CONTEXT%TYPE := NULL,
249 p_pricing_attribute1 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE1%TYPE := NULL,
250 p_pricing_attribute2 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE2%TYPE := NULL,
251 p_pricing_attribute3 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE3%TYPE := NULL,
252 p_pricing_attribute4 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE4%TYPE := NULL,
253 p_pricing_attribute5 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE5%TYPE := NULL,
254 p_pricing_attribute6 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE6%TYPE := NULL,
255 p_pricing_attribute7 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE7%TYPE := NULL,
256 p_pricing_attribute8 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE8%TYPE := NULL,
257 p_pricing_attribute9 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE9%TYPE := NULL,
258 p_pricing_attribute10 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE10%TYPE := NULL,
259 p_pricing_attribute11 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE11%TYPE := NULL,
260 p_pricing_attribute12 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE12%TYPE := NULL,
261 p_pricing_attribute13 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE13%TYPE := NULL,
265 p_credit_amount IN NUMBER := NULL,
262 p_pricing_attribute14 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE14%TYPE := NULL,
263 p_pricing_attribute15 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE15%TYPE := NULL,
264 p_pricing_context IN CS_CP_SERVICE_TRANSACTIONS.PRICING_CONTEXT%TYPE := NULL,
266 p_purchase_order_num IN CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := NULL,
267 x_cp_service_transaction_id OUT NUMBER);
268 Procedure lock_row
269 (
270 p_api_version IN NUMBER,
271 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
272 p_validation_level IN NUMBER,
273 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
274 x_return_status OUT VARCHAR2,
275 x_msg_count OUT NUMBER,
276 x_msg_data OUT VARCHAR2,
277 p_cp_service_transaction_id IN NUMBER,
278 p_last_update_date IN DATE,
279 p_last_updated_by IN NUMBER,
280 p_creation_date IN DATE,
281 p_created_by IN NUMBER,
282 p_last_update_login IN NUMBER,
283 p_cp_service_id IN NUMBER,
284 p_transaction_type_code IN VARCHAR2,
285 p_resulting_status_code IN VARCHAR2,
286 p_effective_start_date IN DATE,
287 p_effective_end_date IN DATE,
288 p_current_end_date IN DATE,
289 p_terminated_transaction_id IN NUMBER,
290 p_reason_code IN VARCHAR2,
291 p_reason_comments IN VARCHAR2,
292 p_service_selling_price IN NUMBER,
293 p_currency_code IN VARCHAR2,
294 p_conversion_type IN VARCHAR2,
295 p_conversion_rate IN NUMBER,
296 p_conversion_date IN DATE,
297 p_invoicing_rule_id IN NUMBER,
298 p_accounting_rule_id IN NUMBER,
299 p_payment_terms_id IN NUMBER,
300 p_service_order_line_id IN NUMBER,
301 p_service_order_number IN NUMBER,
302 p_service_order_date IN DATE,
303 p_service_order_type IN VARCHAR2,
304 p_invoice_flag IN VARCHAR2,
305 p_coverage_schedule_id IN NUMBER,
306 p_duration_quantity IN NUMBER,
307 p_unit_of_measure_code IN VARCHAR2,
308 p_starting_delay IN NUMBER,
309 p_bill_to_site_use_id IN NUMBER,
310 p_bill_to_contact_id IN NUMBER,
311 p_prorate_flag IN VARCHAR2,
312 p_ra_interface_status IN VARCHAR2,
313 p_invoice_count IN NUMBER,
314 p_price_list_id IN NUMBER,
315 p_attribute1 IN VARCHAR2,
316 p_attribute2 IN VARCHAR2,
317 p_attribute3 IN VARCHAR2,
318 p_attribute4 IN VARCHAR2,
319 p_attribute5 IN VARCHAR2,
320 p_attribute6 IN VARCHAR2,
321 p_attribute7 IN VARCHAR2,
322 p_attribute8 IN VARCHAR2,
323 p_attribute9 IN VARCHAR2,
324 p_attribute10 IN VARCHAR2,
325 p_attribute11 IN VARCHAR2,
326 p_attribute12 IN VARCHAR2,
327 p_attribute13 IN VARCHAR2,
328 p_attribute14 IN VARCHAR2,
329 p_attribute15 IN VARCHAR2,
330 p_context IN VARCHAR2,
331 p_pricing_attribute1 IN VARCHAR2,
332 p_pricing_attribute2 IN VARCHAR2,
333 p_pricing_attribute3 IN VARCHAR2,
334 p_pricing_attribute4 IN VARCHAR2,
335 p_pricing_attribute5 IN VARCHAR2,
336 p_pricing_attribute6 IN VARCHAR2,
337 p_pricing_attribute7 IN VARCHAR2,
338 p_pricing_attribute8 IN VARCHAR2,
339 p_pricing_attribute9 IN VARCHAR2,
340 p_pricing_attribute10 IN VARCHAR2,
341 p_pricing_attribute11 IN VARCHAR2,
342 p_pricing_attribute12 IN VARCHAR2,
343 p_pricing_attribute13 IN VARCHAR2,
344 p_pricing_attribute14 IN VARCHAR2,
345 p_pricing_attribute15 IN VARCHAR2,
346 p_pricing_context IN VARCHAR2,
347 p_credit_amount IN NUMBER,
348 p_purchase_order_num IN VARCHAR2);
349 Procedure update_row
350 (
351 p_api_version IN NUMBER,
352 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
353 p_validation_level IN NUMBER,
354 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
355 x_return_status OUT VARCHAR2,
356 x_msg_count OUT NUMBER,
357 x_msg_data OUT VARCHAR2,
358 p_servicetran_val_rec IN ServiceTran_Val_Rec_Type := G_MISS_SERVICETRAN_VAL_REC);
359 Procedure update_row
360 (
361 p_api_version IN NUMBER,
362 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
363 p_validation_level IN NUMBER,
364 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
365 x_return_status OUT VARCHAR2,
366 x_msg_count OUT NUMBER,
367 x_msg_data OUT VARCHAR2,
368 p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
369 p_last_update_date IN CS_CP_SERVICE_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
370 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
371 p_creation_date IN CS_CP_SERVICE_TRANSACTIONS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
375 p_transaction_type_code IN CS_CP_SERVICE_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
372 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
373 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
374 p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
376 p_resulting_status_code IN CS_CP_SERVICE_TRANSACTIONS.RESULTING_STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
377 p_effective_start_date IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
378 p_effective_end_date IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
379 p_current_end_date IN CS_CP_SERVICE_TRANSACTIONS.CURRENT_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
380 p_terminated_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
381 p_reason_code IN CS_CP_SERVICE_TRANSACTIONS.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
382 p_reason_comments IN CS_CP_SERVICE_TRANSACTIONS.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
383 p_service_selling_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
384 p_currency_code IN CS_CP_SERVICE_TRANSACTIONS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
385 p_conversion_type IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
386 p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
387 p_conversion_date IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
388 p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
389 p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
390 p_payment_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
391 p_service_order_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
392 p_service_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
393 p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
394 p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
395 p_invoice_flag IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
396 p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
397 p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
398 p_unit_of_measure_code IN CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
399 p_starting_delay IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
400 p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
401 p_bill_to_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
402 p_prorate_flag IN CS_CP_SERVICE_TRANSACTIONS.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
403 p_ra_interface_status IN CS_CP_SERVICE_TRANSACTIONS.RA_INTERFACE_STATUS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
404 p_invoice_count IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
405 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
406 p_attribute1 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
407 p_attribute2 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
408 p_attribute3 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
409 p_attribute4 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
410 p_attribute5 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
411 p_attribute6 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
412 p_attribute7 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
413 p_attribute8 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
414 p_attribute9 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
415 p_attribute10 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
416 p_attribute11 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
417 p_attribute12 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
418 p_attribute13 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
419 p_attribute14 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
420 p_attribute15 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
421 p_context IN CS_CP_SERVICE_TRANSACTIONS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
422 p_pricing_attribute1 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
423 p_pricing_attribute2 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
424 p_pricing_attribute3 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
425 p_pricing_attribute4 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
426 p_pricing_attribute5 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
427 p_pricing_attribute6 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
428 p_pricing_attribute7 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
429 p_pricing_attribute8 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
430 p_pricing_attribute9 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
431 p_pricing_attribute10 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
432 p_pricing_attribute11 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
433 p_pricing_attribute12 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
437 p_pricing_context IN CS_CP_SERVICE_TRANSACTIONS.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
434 p_pricing_attribute13 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
435 p_pricing_attribute14 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
436 p_pricing_attribute15 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
438 p_credit_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
439 p_purchase_order_num IN CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR);
440 Procedure delete_row
441 (
442 p_api_version IN NUMBER,
443 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
444 p_validation_level IN NUMBER,
445 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
446 x_return_status OUT VARCHAR2,
447 x_msg_count OUT NUMBER,
448 x_msg_data OUT VARCHAR2,
449 p_cp_service_transaction_id IN NUMBER);
450 PROCEDURE validate_row
451 (
452 p_api_version IN NUMBER,
453 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
454 p_validation_level IN NUMBER,
455 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
456 x_return_status OUT VARCHAR2,
457 x_msg_count OUT NUMBER,
458 x_msg_data OUT VARCHAR2,
459 p_servicetran_val_rec IN ServiceTran_Val_Rec_Type := G_MISS_SERVICETRAN_VAL_REC);
460 PROCEDURE validate_row
461 (
462 p_api_version IN NUMBER,
463 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
464 p_validation_level IN NUMBER,
465 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
466 x_return_status OUT VARCHAR2,
467 x_msg_count OUT NUMBER,
468 x_msg_data OUT VARCHAR2,
469 p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
470 p_last_update_date IN CS_CP_SERVICE_TRANSACTIONS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
471 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
472 p_creation_date IN CS_CP_SERVICE_TRANSACTIONS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
473 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
474 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
475 p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
476 p_transaction_type_code IN CS_CP_SERVICE_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
477 p_resulting_status_code IN CS_CP_SERVICE_TRANSACTIONS.RESULTING_STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
478 p_effective_start_date IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
479 p_effective_end_date IN CS_CP_SERVICE_TRANSACTIONS.EFFECTIVE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
480 p_current_end_date IN CS_CP_SERVICE_TRANSACTIONS.CURRENT_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
481 p_terminated_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
482 p_reason_code IN CS_CP_SERVICE_TRANSACTIONS.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
483 p_reason_comments IN CS_CP_SERVICE_TRANSACTIONS.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
484 p_service_selling_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
485 p_currency_code IN CS_CP_SERVICE_TRANSACTIONS.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
486 p_conversion_type IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
487 p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
488 p_conversion_date IN CS_CP_SERVICE_TRANSACTIONS.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
489 p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
490 p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
491 p_payment_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
492 p_service_order_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
493 p_service_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
494 p_service_order_date IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
495 p_service_order_type IN CS_CP_SERVICE_TRANSACTIONS.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
496 p_invoice_flag IN CS_CP_SERVICE_TRANSACTIONS.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
497 p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
498 p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
499 p_unit_of_measure_code IN CS_CP_SERVICE_TRANSACTIONS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
500 p_starting_delay IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
501 p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
502 p_bill_to_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
503 p_prorate_flag IN CS_CP_SERVICE_TRANSACTIONS.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
504 p_ra_interface_status IN CS_CP_SERVICE_TRANSACTIONS.RA_INTERFACE_STATUS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
505 p_invoice_count IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
506 p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
507 p_attribute1 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
508 p_attribute2 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
509 p_attribute3 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
510 p_attribute4 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
514 p_attribute8 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
511 p_attribute5 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
512 p_attribute6 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
513 p_attribute7 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
515 p_attribute9 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
516 p_attribute10 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
517 p_attribute11 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
518 p_attribute12 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
519 p_attribute13 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
520 p_attribute14 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
521 p_attribute15 IN CS_CP_SERVICE_TRANSACTIONS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
522 p_context IN CS_CP_SERVICE_TRANSACTIONS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
523 p_pricing_attribute1 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
524 p_pricing_attribute2 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
525 p_pricing_attribute3 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
526 p_pricing_attribute4 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
527 p_pricing_attribute5 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
528 p_pricing_attribute6 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
529 p_pricing_attribute7 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
530 p_pricing_attribute8 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
531 p_pricing_attribute9 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
532 p_pricing_attribute10 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
533 p_pricing_attribute11 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
534 p_pricing_attribute12 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
535 p_pricing_attribute13 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
536 p_pricing_attribute14 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
537 p_pricing_attribute15 IN CS_CP_SERVICE_TRANSACTIONS.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
538 p_pricing_context IN CS_CP_SERVICE_TRANSACTIONS.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
539 p_credit_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
540 p_purchase_order_num IN CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR);
541 END CS_SERVICETRAN_PVT;