[Home] [Help]
PACKAGE: APPS.CS_CHARGE_DETAILS_PUB
Source
1 PACKAGE CS_Charge_Details_PUB AS
2 /* $Header: csxpests.pls 120.13 2008/01/11 09:15:11 bkanimoz ship $ */
3 /*#
4 * This public interface for the charges functionality in Oracle Service, provides functions
5 * that enables user to create, update, delete, and copy charges data.
6 *
7 * @rep:scope public
8 * @rep:product CS
9 * @rep:displayname Service Request Charge Processing
10 * @rep:lifecycle active
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY CS_SERVICE_CHARGE
13 * @rep:metalink 390503.1 Oracle Teleservice Implementation Guide Release 12.0
14 */
15
16 /**** Above text has been added to enable the integration repository to extract the data from
17 the source code file and populate the integration repository schema so that the
18 interfaces defined in this package appears in the integration repository.
19 ****/
20
21
22
23 TYPE Charges_Rec_Type IS RECORD
24 (
25 estimate_detail_id NUMBER := FND_API.G_MISS_NUM,
26 incident_id NUMBER := FND_API.G_MISS_NUM,
27 charge_line_type VARCHAR(30) := FND_API.G_MISS_CHAR,
28 line_number NUMBER := FND_API.G_MISS_NUM,
29 business_process_id NUMBER := FND_API.G_MISS_NUM,
30 transaction_type_id NUMBER := FND_API.G_MISS_NUM,
31 inventory_item_id_in NUMBER := FND_API.G_MISS_NUM,
32 item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
33 billing_flag VARCHAR2(30) := FND_API.G_MISS_CHAR,
34 txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
35 unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
36 quantity_required NUMBER := FND_API.G_MISS_NUM,
37 return_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
38 customer_product_id NUMBER := FND_API.G_MISS_NUM,
39 serial_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
40 installed_cp_return_by_date DATE := FND_API.G_MISS_DATE,
41 new_cp_return_by_date DATE := FND_API.G_MISS_DATE,
42 sold_to_party_id NUMBER := FND_API.G_MISS_NUM,
43 bill_to_party_id NUMBER := FND_API.G_MISS_NUM,
44 bill_to_account_id NUMBER := FND_API.G_MISS_NUM,
45 bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
46 invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
47 ship_to_party_id NUMBER := FND_API.G_MISS_NUM,
48 ship_to_account_id NUMBER := FND_API.G_MISS_NUM,
49 ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
50 ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
51 contract_line_id NUMBER := FND_API.G_MISS_NUM,
52 rate_type_code VARCHAR2(40) := FND_API.G_MISS_CHAR,
53 contract_id NUMBER := FND_API.G_MISS_NUM,
54 coverage_id NUMBER := FND_API.G_MISS_NUM,
55 coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
56 coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
57 coverage_billing_type_id NUMBER := FND_API.G_MISS_NUM,
58 price_list_id NUMBER := FND_API.G_MISS_NUM,
59 currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
60 purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
61 list_price NUMBER := FND_API.G_MISS_NUM,
62 con_pct_over_list_price NUMBER := FND_API.G_MISS_NUM,
63 selling_price NUMBER := FND_API.G_MISS_NUM,
64 contract_discount_amount NUMBER := FND_API.G_MISS_NUM,
65 apply_contract_discount VARCHAR2(1) := FND_API.G_MISS_CHAR,
66 after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
67 transaction_inventory_org NUMBER := FND_API.G_MISS_NUM,
68 transaction_sub_inventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
69 rollup_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
70 add_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71 order_header_id NUMBER := FND_API.G_MISS_NUM,
72 interface_to_oe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73 no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74 line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
75 line_type_id NUMBER := FND_API.G_MISS_NUM,
76 order_line_id NUMBER := FND_API.G_MISS_NUM,
77 conversion_rate NUMBER := FND_API.G_MISS_NUM,
78 conversion_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
79 conversion_rate_date DATE := FND_API.G_MISS_DATE,
80 original_source_id NUMBER := FND_API.G_MISS_NUM,
81 original_source_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
82 source_id NUMBER := FND_API.G_MISS_NUM,
83 source_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
84 org_id NUMBER := FND_API.G_MISS_NUM,
85
86 --Error Handling
87 submit_restriction_message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
88 submit_error_message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
89
90 --Auto Submission Process
91 submit_from_system VARCHAR2(30) := FND_API.G_MISS_CHAR,
92 line_submitted_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
93
94
95 --Billing Engine
96 activity_start_time DATE := FND_API.G_MISS_DATE,
97 activity_end_time DATE := FND_API.G_MISS_DATE,
98 generated_by_bca_engine VARCHAR2(1) := FND_API.G_MISS_CHAR,
99
100 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
109 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
116 pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
117 pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118 pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119 pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120 pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121 pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122 pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123 pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124 pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125 pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126 pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127 pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128 pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129 pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130 pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131 pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132 pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133 pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134 pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135 pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136 pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137 pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138 pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139 pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140 pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141 pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142 pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143 pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144 pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145 pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146 pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147 pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148 pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149 pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150 pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151 pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152 pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153 pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154 pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155 pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156 pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157 pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158 pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159 pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160 pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161 pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162 pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163 pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164 pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165 pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166 pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167 pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168 pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169 pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170 pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171 pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172 pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173 pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174 pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175 pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176 pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177 pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178 pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179 pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180 pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181 pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182 pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183 pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
184 pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
185 pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
186 pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
187 pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
188 pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
189 pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190 pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191 pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192 pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
193 pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194 pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195 pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196 pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197 pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198 pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199 pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200 pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201 pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202 pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203 pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204 pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205 pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206 pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207 pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208 pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209 pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210 pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211 pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212 pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213 pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214 pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215 pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216 pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217
218 --obsoleted columns/columns not used/Columns left for backward compatibility
219 original_source_number VARCHAR2(200) := FND_API.G_MISS_CHAR,
220 source_number VARCHAR2(200) := FND_API.G_MISS_CHAR,
221 reference_number NUMBER := FND_API.G_MISS_NUM,
222 original_system_reference VARCHAR2(50) := FND_API.G_MISS_CHAR,
223 inventory_item_id_out NUMBER := FND_API.G_MISS_NUM,
224 serial_number_out VARCHAR2(50) := FND_API.G_MISS_CHAR,
225 exception_coverage_used VARCHAR2(1) := FND_API.G_MISS_CHAR
226 ) ;
227
228
229 G_MISS_CHRG_REC Charges_Rec_Type ;
230
231
232 -- Start of comments
233 -- API name : Create_Charge_Details
234 -- Type : Public
235 -- Function :
236 -- Pre-reqs : None.
237 -- Parameters :
238 --
239 -- IN : p_api_version: Standard Version of API Required
240 -- p_init_msg_list: Optional
241 -- p_commit: Indicates whether API should commit Optional
242 -- p_validation_level: Optional
243 -- p_resp_appl_id:
244 -- p_resp_id:
245 -- p_user_id:
246 -- p_login_id:
247 -- p_transaction_control:
251 -- Following passed using RECORD Charges_Rec_Type are reuired
248 -- p_Charges_Rec: Charges_Rec_Type
249 -- p_create_cost_detail - Indicates if Costing API needs to be called
250 --
252 -- or conditionally required
253 -- incident_id: Required
254 -- business_process_id: Required
255 -- line_category_code: Required if the charge line is RETURN
256 -- line_type_id: Required
257 -- txn_billing_type_id:
258 -- coverage_bill_rate_id:
259 --
260 -- OUT : x_return_status:
261 -- x_msg_count:
262 -- x_object_version_number:
263 -- x_msg_data:
264 -- x_estimate_detail_id:
265 -- x_line_number:
266 -- x_cost_id
267 --
268 -- Version : Current version 11.5
269 -- Notes : This API is a public API to Create Charge Details.
270 --
271 -- End of comments
272
273 /*#
274 * Create a charge line associated with a service request. This procedure creates one charge line
275 * at a time.For details on the parameters, please refer to the document on Metalink from the URL provided above.
276 *
277 * @rep:scope public
278 * @rep:lifecycle active
279 * @rep:compatibility S
280 * @rep:displayname Create Service Request Charge Line
281 * @rep:primaryinstance
282 * @rep:metalink 390503.1 Oracle Teleservice Implementation Guide Release 12.0
283 */
284
285 /**** Above text has been added to enable the integration repository to extract the data from
286 the source code file and populate the integration repository schema so that
287 Create_Charge_Details API appears in the integration repository.
288 ****/
289
290 PROCEDURE Create_Charge_Details(
291 p_api_version IN NUMBER,
292 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293 p_commit IN VARCHAR2 := FND_API.G_FALSE,
294 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_object_version_number OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 x_estimate_detail_id OUT NOCOPY NUMBER,
300 x_line_number OUT NOCOPY NUMBER,
301 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
302 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
303 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
304 p_login_id IN NUMBER := NULL,
305 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
306 p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC
307 ) ;
308
309
310 PROCEDURE Create_Charge_Details(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313 p_commit IN VARCHAR2 := FND_API.G_FALSE,
314 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_object_version_number OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2,
319 x_estimate_detail_id OUT NOCOPY NUMBER,
320 x_line_number OUT NOCOPY NUMBER,
321 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
322 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
323 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
324 p_login_id IN NUMBER := NULL,
325 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
326 p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC,
327 p_create_cost_detail IN VARCHAR2 , --added by bkanimoz for service costing
328 x_cost_id OUT NOCOPY NUMBER --added by bkanimoz for service costing
329 ) ;
330
331
332
333 -- Start of comments
334 -- API name : Update_Charge_Details
335 -- Type : Public
336 -- Function :
337 -- Pre-reqs : None.
338 -- Parameters :
339 --
340 -- IN : p_api_version: Standard Version of API Required
341 -- p_init_msg_list: Optional
342 -- p_commit: Indicates whether API should commit Optional
343 -- p_validation_level: Optional
344 -- p_resp_appl_id:
345 -- p_resp_id:
346 -- p_user_id:
347 -- p_login_id:
348 -- p_transaction_control:
349 -- p_Charges_Rec: Charges_Rec_Type
350 -- p_update_cost_detail : Indicates if Costing API needs to be called
351 --
352 -- Following passed using RECORD Charges_Rec_Type are reuired
353 -- or conditionally required
357 -- line_type_id: Required
354 -- incident_id: Required
355 -- business_process_id: Required
356 -- line_category_code: Required if the charge line is RETURN
358 -- txn_billing_type_id:
359 -- coverage_bill_rate_id:
360 --
361 -- OUT : x_return_status:
362 -- x_msg_count:
363 -- x_object_version_number:
364 -- x_msg_data:
365 --
366 -- Version : Current version 11.5
367 -- Notes : This API is a public API to Update Charge Details.
368 --
369 -- End of comments
370
371 /*#
372 * Updates a service request charge line. This procedure updates one charge line at a time.
373 * For details on the parameters, please refer to the document on Metalink from the URL provided above.
374 *
375 * @rep:scope public
376 * @rep:lifecycle active
377 * @rep:compatibility S
378 * @rep:displayname Update Service Request Charge Line
379 * @rep:primaryinstance
380 * @rep:metalink 390503.1 Oracle Teleservice Implementation Guide Release 12.0
381 */
382
383 /**** Above text has been added to enable the integration repository to extract the data
384 from the source code file and populate the integration repository schema so that
385 Update_Charge_Details API appears in the integration repository.
386 ****/
387 PROCEDURE Update_Charge_Details(
388 p_api_version IN NUMBER,
389 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
390 p_commit IN VARCHAR2 := FND_API.G_FALSE,
391 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
392 x_return_status OUT NOCOPY VARCHAR2,
393 x_msg_count OUT NOCOPY NUMBER,
394 x_object_version_number OUT NOCOPY NUMBER,
395 x_msg_data OUT NOCOPY VARCHAR2,
396 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
397 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
398 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
399 p_login_id IN NUMBER := NULL,
400 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
401 p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC
402 ) ;
403
404 PROCEDURE Update_Charge_Details(
405 p_api_version IN NUMBER,
406 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407 p_commit IN VARCHAR2 := FND_API.G_FALSE,
408 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
409 x_return_status OUT NOCOPY VARCHAR2,
410 x_msg_count OUT NOCOPY NUMBER,
411 x_object_version_number OUT NOCOPY NUMBER,
412 x_msg_data OUT NOCOPY VARCHAR2,
413 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
414 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
415 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
416 p_login_id IN NUMBER := NULL,
417 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
418 p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC ,
419 p_update_cost_detail IN VARCHAR2--added by bkanimoz for service costing
420 ) ;
421
422
423 -- Start of comments
424 -- API name : Delete_Charge_Details
425 -- Type : Public
426 -- Function :
427 -- Pre-reqs : None.
428 -- Parameters :
429 --
430 -- IN : p_api_version: Standard Version of API Required
431 -- p_init_msg_list: Optional
432 -- p_commit: Indicates whether API should commit Optional
433 -- p_validation_level: Optional
434 -- p_transaction_control:
435 -- p_estimate_detail_id:
436 -- p_delete_cost_detail : Indicates if Costing API needs to be called
437 --
438 -- OUT : x_return_status:
439 -- x_msg_count:
440 -- x_msg_data:
441 --
442 -- Version : Current version 11.5
443 -- Notes : This API is a public API to Delete Charge Details.
444 --
445 -- End of comments
446
447 /*#
448 * Deletes a service request charge line. This procedure deletes one charge line at a time.
449 * For details on the parameters, please refer to the document on Metalink from the URL provided above.
450 *
451 * @rep:scope public
452 * @rep:lifecycle active
453 * @rep:compatibility S
454 * @rep:displayname Delete Service Request Charge Line
455 * @rep:primaryinstance
456 * @rep:metalink 390503.1 Oracle Teleservice Implementation Guide Release 12.0
457 */
458
459 /**** Above text has been added to enable the integration repository to extract the data
460 from the source code file and populate the integration repository schema so that
461 Delete_Charge_Details API appears in the integration repository.
462 ****/
466 p_commit IN VARCHAR2 := FND_API.G_FALSE,
463 Procedure Delete_Charge_Details(
464 p_api_version IN NUMBER,
465 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
467 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
468 x_return_status OUT NOCOPY VARCHAR2,
469 x_msg_count OUT NOCOPY NUMBER,
470 x_msg_data OUT NOCOPY VARCHAR2,
471 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
472 p_estimate_detail_id IN NUMBER := NULL
473 ) ;
474
475
476
477 Procedure Delete_Charge_Details(
478 p_api_version IN NUMBER,
479 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
480 p_commit IN VARCHAR2 := FND_API.G_FALSE,
481 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482 x_return_status OUT NOCOPY VARCHAR2,
483 x_msg_count OUT NOCOPY NUMBER,
484 x_msg_data OUT NOCOPY VARCHAR2,
485 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
486 p_estimate_detail_id IN NUMBER := NULL,
487 p_delete_cost_detail IN VARCHAR2) ;--added by bkanimoz for service costing
488
489
490 -- Start of comments
491 -- API name : Copy_Estimate
492 -- Type : Public
493 -- Function :
494 -- Pre-reqs : None.
495 -- Parameters :
496 --
497 -- IN : p_api_version: Standard Version of API Required
498 -- p_init_msg_list: Optional
499 -- p_commit: Indicates whether API should commit Optional
500 -- p_estimate_detail_id: Required
501 --
502 -- OUT : x_return_status:
503 -- x_msg_count:
504 -- x_msg_data:
505 --
506 -- Version : Current version 11.5
507 -- Notes : This API is a public API to Copy Estimates To Actuals.
508 --
509 -- End of comments
510
511 /*#
512 * Converts an estimate to a charge line ready for submission to Oracle Order Management. This
513 * procedure copies one charge line of type Estimate and creates a new line of type Actual.
514 * For details on the parameters, please refer to the document on Metalink from the URL provided above.
515 *
516 * @rep:scope public
517 * @rep:lifecycle active
518 * @rep:compatibility S
519 * @rep:displayname Process Service Request Charge Line Estimate
520 * @rep:primaryinstance
521 * @rep:metalink 390503.1 Oracle Teleservice Implementation Guide Release 12.0
522 */
523
524 /**** Above text has been added to enable the integration repository to extract the data
525 from the source code file and populate the integration repository schema so that
526 Copy_Estimate API appears in the integration repository.
527 ****/
528
529
530 Procedure Copy_Estimate(
531 p_api_version IN NUMBER,
532 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
533 p_commit IN VARCHAR2 := FND_API.G_FALSE,
534 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
535 p_estimate_detail_id IN NUMBER := NULL,
536 x_estimate_detail_id OUT NOCOPY NUMBER,
537 x_return_status OUT NOCOPY VARCHAR2,
538 x_msg_count OUT NOCOPY NUMBER,
539 x_msg_data OUT NOCOPY VARCHAR2) ;
540
541 /**************************************************
542 Procedure Body Log_Charges_Rec_Parameters
543 This Procedure is used for Logging the charges record paramters.
544 This Procedure will only be called from
545 CS_Charge_Details_PUB and CS_Charge_Details_PVT Packages only.
546 **************************************************/
547
548 PROCEDURE Log_Charges_Rec_Parameters
549 ( p_Charges_Rec IN Charges_Rec_Type
550 );
551
552 END CS_Charge_Details_PUB ;