[Home] [Help]
PACKAGE: APPS.CS_CHARGE_DETAILS_PUB
Source
1 PACKAGE CS_Charge_Details_PUB AUTHID CURRENT_USER AS
2 /* $Header: csxpests.pls 120.17.12020000.3 2013/01/30 08:57:37 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 /* Credit Card 9358401 */
227 instrument_payment_use_id NUMBER := FND_API.G_MISS_NUM,
228 -- Charges Logistics Project
229 shipping_method VARCHAR2(240) := FND_API.G_MISS_CHAR,
230 arrival_date_time DATE := FND_API.G_MISS_DATE,
231 return_type VARCHAR2(240) := FND_API.G_MISS_CHAR,
232 parent_instance_id NUMBER := FND_API.G_MISS_NUM,
233 -- Charges MED
234 distance NUMBER := FND_API.G_MISS_NUM,
235 need_by_date DATE := FND_API.G_MISS_DATE,
236 --12.2.2 Service Projects Integration
237 project_id NUMBER := FND_API.G_MISS_NUM,
238 project_task_id NUMBER := FND_API.G_MISS_NUM,
239 expenditure_org_id NUMBER := FND_API.G_MISS_NUM
240 ) ;
241
242
243 G_MISS_CHRG_REC Charges_Rec_Type ;
244
245
246 -- Start of comments
247 -- API name : Create_Charge_Details
248 -- Type : Public
249 -- Function :
250 -- Pre-reqs : None.
251 -- Parameters :
252 --
253 -- IN : p_api_version: Standard Version of API Required
254 -- p_init_msg_list: Optional
255 -- p_commit: Indicates whether API should commit Optional
256 -- p_validation_level: Optional
257 -- p_resp_appl_id:
258 -- p_resp_id:
259 -- p_user_id:
263 -- p_create_cost_detail - Indicates if Costing API needs to be called
260 -- p_login_id:
261 -- p_transaction_control:
262 -- p_Charges_Rec: Charges_Rec_Type
264 --
265 -- Following passed using RECORD Charges_Rec_Type are reuired
266 -- or conditionally required
267 -- incident_id: Required
268 -- business_process_id: Required
269 -- line_category_code: Required if the charge line is RETURN
270 -- line_type_id: Required
271 -- txn_billing_type_id:
272 -- coverage_bill_rate_id:
273 --
274 -- OUT : x_return_status:
275 -- x_msg_count:
276 -- x_object_version_number:
277 -- x_msg_data:
278 -- x_estimate_detail_id:
279 -- x_line_number:
280 -- x_cost_id
281 --
282 -- Version : Current version 11.5
283 -- Notes : This API is a public API to Create Charge Details.
284 --
285 -- End of comments
286
287 /*#
288 * Create a charge line associated with a service request. This procedure creates one charge line
289 * at a time.For details on the parameters, please refer to the document on Metalink from the URL provided above.
290 *
291 * @rep:scope public
292 * @rep:lifecycle active
293 * @rep:compatibility S
294 * @rep:displayname Create Service Request Charge Line
295 * @rep:primaryinstance
296 * @rep:metalink 390503.1 Oracle Teleservice Implementation Guide Release 12.0
297 */
298
299 /**** Above text has been added to enable the integration repository to extract the data from
300 the source code file and populate the integration repository schema so that
301 Create_Charge_Details API appears in the integration repository.
302 ****/
303
304 PROCEDURE Create_Charge_Details(
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307 p_commit IN VARCHAR2 := FND_API.G_FALSE,
308 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_object_version_number OUT NOCOPY NUMBER,
312 x_msg_data OUT NOCOPY VARCHAR2,
313 x_estimate_detail_id OUT NOCOPY NUMBER,
314 x_line_number OUT NOCOPY NUMBER,
315 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
316 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
317 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
318 p_login_id IN NUMBER := NULL,
319 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
320 p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC
321 ) ;
322
323
324 PROCEDURE Create_Charge_Details(
325 p_api_version IN NUMBER,
326 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
327 p_commit IN VARCHAR2 := FND_API.G_FALSE,
328 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
329 x_return_status OUT NOCOPY VARCHAR2,
330 x_msg_count OUT NOCOPY NUMBER,
331 x_object_version_number OUT NOCOPY NUMBER,
332 x_msg_data OUT NOCOPY VARCHAR2,
333 x_estimate_detail_id OUT NOCOPY NUMBER,
334 x_line_number OUT NOCOPY NUMBER,
335 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
336 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
337 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
338 p_login_id IN NUMBER := NULL,
339 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
340 p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC,
341 p_create_cost_detail IN VARCHAR2 , --added by bkanimoz for service costing
342 x_cost_id OUT NOCOPY NUMBER --added by bkanimoz for service costing
343 ) ;
344
345
346
347 -- Start of comments
348 -- API name : Update_Charge_Details
349 -- Type : Public
350 -- Function :
351 -- Pre-reqs : None.
352 -- Parameters :
353 --
354 -- IN : p_api_version: Standard Version of API Required
355 -- p_init_msg_list: Optional
356 -- p_commit: Indicates whether API should commit Optional
357 -- p_validation_level: Optional
358 -- p_resp_appl_id:
359 -- p_resp_id:
360 -- p_user_id:
361 -- p_login_id:
362 -- p_transaction_control:
363 -- p_Charges_Rec: Charges_Rec_Type
364 -- p_update_cost_detail : Indicates if Costing API needs to be called
365 --
366 -- Following passed using RECORD Charges_Rec_Type are reuired
367 -- or conditionally required
368 -- incident_id: Required
369 -- business_process_id: Required
370 -- line_category_code: Required if the charge line is RETURN
374 --
371 -- line_type_id: Required
372 -- txn_billing_type_id:
373 -- coverage_bill_rate_id:
375 -- OUT : x_return_status:
376 -- x_msg_count:
377 -- x_object_version_number:
378 -- x_msg_data:
379 --
380 -- Version : Current version 11.5
381 -- Notes : This API is a public API to Update Charge Details.
382 --
383 -- End of comments
384
385 /*#
386 * Updates a service request charge line. This procedure updates one charge line at a time.
387 * For details on the parameters, please refer to the document on Metalink from the URL provided above.
388 *
389 * @rep:scope public
390 * @rep:lifecycle active
391 * @rep:compatibility S
392 * @rep:displayname Update Service Request Charge Line
393 * @rep:primaryinstance
394 * @rep:metalink 390503.1 Oracle Teleservice Implementation Guide Release 12.0
395 */
396
397 /**** Above text has been added to enable the integration repository to extract the data
398 from the source code file and populate the integration repository schema so that
399 Update_Charge_Details API appears in the integration repository.
400 ****/
401 PROCEDURE Update_Charge_Details(
402 p_api_version IN NUMBER,
403 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
404 p_commit IN VARCHAR2 := FND_API.G_FALSE,
405 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406 x_return_status OUT NOCOPY VARCHAR2,
407 x_msg_count OUT NOCOPY NUMBER,
408 x_object_version_number OUT NOCOPY NUMBER,
409 x_msg_data OUT NOCOPY VARCHAR2,
410 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
411 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
412 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
413 p_login_id IN NUMBER := NULL,
414 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
415 p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC
416 ) ;
417
418 PROCEDURE Update_Charge_Details(
419 p_api_version IN NUMBER,
420 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421 p_commit IN VARCHAR2 := FND_API.G_FALSE,
422 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423 x_return_status OUT NOCOPY VARCHAR2,
424 x_msg_count OUT NOCOPY NUMBER,
425 x_object_version_number OUT NOCOPY NUMBER,
426 x_msg_data OUT NOCOPY VARCHAR2,
427 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
428 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
429 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
430 p_login_id IN NUMBER := NULL,
431 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
432 p_Charges_Rec IN Charges_Rec_Type := G_MISS_CHRG_REC ,
433 p_update_cost_detail IN VARCHAR2--added by bkanimoz for service costing
434 ) ;
435
436
437 -- Start of comments
438 -- API name : Delete_Charge_Details
439 -- Type : Public
440 -- Function :
441 -- Pre-reqs : None.
442 -- Parameters :
443 --
444 -- IN : p_api_version: Standard Version of API Required
445 -- p_init_msg_list: Optional
446 -- p_commit: Indicates whether API should commit Optional
447 -- p_validation_level: Optional
448 -- p_transaction_control:
449 -- p_estimate_detail_id:
450 -- p_delete_cost_detail : Indicates if Costing API needs to be called
451 --
452 -- OUT : x_return_status:
453 -- x_msg_count:
454 -- x_msg_data:
455 --
456 -- Version : Current version 11.5
457 -- Notes : This API is a public API to Delete Charge Details.
458 --
459 -- End of comments
460
461 /*#
462 * Deletes a service request charge line. This procedure deletes one charge line at a time.
463 * For details on the parameters, please refer to the document on Metalink from the URL provided above.
464 *
465 * @rep:scope public
466 * @rep:lifecycle active
467 * @rep:compatibility S
468 * @rep:displayname Delete Service Request Charge Line
469 * @rep:primaryinstance
470 * @rep:metalink 390503.1 Oracle Teleservice Implementation Guide Release 12.0
471 */
472
473 /**** Above text has been added to enable the integration repository to extract the data
474 from the source code file and populate the integration repository schema so that
475 Delete_Charge_Details API appears in the integration repository.
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,
488
485 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
486 p_estimate_detail_id IN NUMBER := NULL
487 ) ;
489
490
491 Procedure Delete_Charge_Details(
492 p_api_version IN NUMBER,
493 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494 p_commit IN VARCHAR2 := FND_API.G_FALSE,
495 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
496 x_return_status OUT NOCOPY VARCHAR2,
497 x_msg_count OUT NOCOPY NUMBER,
498 x_msg_data OUT NOCOPY VARCHAR2,
499 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
500 p_estimate_detail_id IN NUMBER := NULL,
501 p_delete_cost_detail IN VARCHAR2) ;--added by bkanimoz for service costing
502
503
504 -- Start of comments
505 -- API name : Copy_Estimate
506 -- Type : Public
507 -- Function :
508 -- Pre-reqs : None.
509 -- Parameters :
510 --
511 -- IN : p_api_version: Standard Version of API Required
512 -- p_init_msg_list: Optional
513 -- p_commit: Indicates whether API should commit Optional
514 -- p_estimate_detail_id: Required
515 --
516 -- OUT : x_return_status:
517 -- x_msg_count:
518 -- x_msg_data:
519 --
520 -- Version : Current version 11.5
521 -- Notes : This API is a public API to Copy Estimates To Actuals.
522 --
523 -- End of comments
524
525 /*#
526 * Converts an estimate to a charge line ready for submission to Oracle Order Management. This
527 * procedure copies one charge line of type Estimate and creates a new line of type Actual.
528 * For details on the parameters, please refer to the document on Metalink from the URL provided above.
529 *
530 * @rep:scope public
531 * @rep:lifecycle active
532 * @rep:compatibility S
533 * @rep:displayname Process Service Request Charge Line Estimate
534 * @rep:primaryinstance
535 * @rep:metalink 390503.1 Oracle Teleservice Implementation Guide Release 12.0
536 */
537
538 /**** Above text has been added to enable the integration repository to extract the data
539 from the source code file and populate the integration repository schema so that
540 Copy_Estimate API appears in the integration repository.
541 ****/
542
543
544 Procedure Copy_Estimate(
545 p_api_version IN NUMBER,
546 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
547 p_commit IN VARCHAR2 := FND_API.G_FALSE,
548 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
549 p_estimate_detail_id IN NUMBER := NULL,
550 x_estimate_detail_id OUT NOCOPY NUMBER,
551 x_return_status OUT NOCOPY VARCHAR2,
552 x_msg_count OUT NOCOPY NUMBER,
553 x_msg_data OUT NOCOPY VARCHAR2) ;
554
555 /**************************************************
556 Procedure Body Log_Charges_Rec_Parameters
557 This Procedure is used for Logging the charges record paramters.
558 This Procedure will only be called from
559 CS_Charge_Details_PUB and CS_Charge_Details_PVT Packages only.
560 **************************************************/
561
562 PROCEDURE Log_Charges_Rec_Parameters
563 ( p_Charges_Rec IN Charges_Rec_Type
564 );
565
566 END CS_Charge_Details_PUB ;