[Home] [Help]
PACKAGE: APPS.CSD_PROCESS_UTIL
Source
1 PACKAGE CSD_PROCESS_UTIL as
2 /* $Header: csdvutls.pls 120.8 2008/05/14 05:00:57 swai ship $ */
3
4 TYPE PRICING_ATTR_REC IS RECORD
5 (
6 pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
7 pricing_attribute1 VARCHAR2(150):= FND_API.G_MISS_CHAR,
8 pricing_attribute2 VARCHAR2(150):= FND_API.G_MISS_CHAR,
9 pricing_attribute3 VARCHAR2(150):= FND_API.G_MISS_CHAR,
10 pricing_attribute4 VARCHAR2(150):= FND_API.G_MISS_CHAR,
11 pricing_attribute5 VARCHAR2(150):= FND_API.G_MISS_CHAR,
12 pricing_attribute6 VARCHAR2(150):= FND_API.G_MISS_CHAR,
13 pricing_attribute7 VARCHAR2(150):= FND_API.G_MISS_CHAR,
14 pricing_attribute8 VARCHAR2(150):= FND_API.G_MISS_CHAR,
15 pricing_attribute9 VARCHAR2(150):= FND_API.G_MISS_CHAR,
16 pricing_attribute10 VARCHAR2(150):= FND_API.G_MISS_CHAR,
17 pricing_attribute11 VARCHAR2(150):= FND_API.G_MISS_CHAR,
18 pricing_attribute12 VARCHAR2(150):= FND_API.G_MISS_CHAR,
19 pricing_attribute13 VARCHAR2(150):= FND_API.G_MISS_CHAR,
20 pricing_attribute14 VARCHAR2(150):= FND_API.G_MISS_CHAR,
21 pricing_attribute15 VARCHAR2(150):= FND_API.G_MISS_CHAR,
22 pricing_attribute16 VARCHAR2(150):= FND_API.G_MISS_CHAR,
23 pricing_attribute17 VARCHAR2(150):= FND_API.G_MISS_CHAR,
24 pricing_attribute18 VARCHAR2(150):= FND_API.G_MISS_CHAR,
25 pricing_attribute19 VARCHAR2(150):= FND_API.G_MISS_CHAR,
26 pricing_attribute20 VARCHAR2(150):= FND_API.G_MISS_CHAR,
27 pricing_attribute21 VARCHAR2(150):= FND_API.G_MISS_CHAR,
28 pricing_attribute22 VARCHAR2(150):= FND_API.G_MISS_CHAR,
29 pricing_attribute23 VARCHAR2(150):= FND_API.G_MISS_CHAR,
30 pricing_attribute24 VARCHAR2(150):= FND_API.G_MISS_CHAR,
31 pricing_attribute25 VARCHAR2(150):= FND_API.G_MISS_CHAR,
32 pricing_attribute26 VARCHAR2(150):= FND_API.G_MISS_CHAR,
33 pricing_attribute27 VARCHAR2(150):= FND_API.G_MISS_CHAR,
34 pricing_attribute28 VARCHAR2(150):= FND_API.G_MISS_CHAR,
35 pricing_attribute29 VARCHAR2(150):= FND_API.G_MISS_CHAR,
36 pricing_attribute30 VARCHAR2(150):= FND_API.G_MISS_CHAR,
37 pricing_attribute31 VARCHAR2(150):= FND_API.G_MISS_CHAR,
38 pricing_attribute32 VARCHAR2(150):= FND_API.G_MISS_CHAR,
39 pricing_attribute33 VARCHAR2(150):= FND_API.G_MISS_CHAR,
40 pricing_attribute34 VARCHAR2(150):= FND_API.G_MISS_CHAR,
41 pricing_attribute35 VARCHAR2(150):= FND_API.G_MISS_CHAR,
42 pricing_attribute36 VARCHAR2(150):= FND_API.G_MISS_CHAR,
43 pricing_attribute37 VARCHAR2(150):= FND_API.G_MISS_CHAR,
44 pricing_attribute38 VARCHAR2(150):= FND_API.G_MISS_CHAR,
45 pricing_attribute39 VARCHAR2(150):= FND_API.G_MISS_CHAR,
46 pricing_attribute40 VARCHAR2(150):= FND_API.G_MISS_CHAR,
47 pricing_attribute41 VARCHAR2(150):= FND_API.G_MISS_CHAR,
48 pricing_attribute42 VARCHAR2(150):= FND_API.G_MISS_CHAR,
49 pricing_attribute43 VARCHAR2(150):= FND_API.G_MISS_CHAR,
50 pricing_attribute44 VARCHAR2(150):= FND_API.G_MISS_CHAR,
51 pricing_attribute45 VARCHAR2(150):= FND_API.G_MISS_CHAR,
52 pricing_attribute46 VARCHAR2(150):= FND_API.G_MISS_CHAR,
53 pricing_attribute47 VARCHAR2(150):= FND_API.G_MISS_CHAR,
54 pricing_attribute48 VARCHAR2(150):= FND_API.G_MISS_CHAR,
55 pricing_attribute49 VARCHAR2(150):= FND_API.G_MISS_CHAR,
56 pricing_attribute50 VARCHAR2(150):= FND_API.G_MISS_CHAR,
57 pricing_attribute51 VARCHAR2(150):= FND_API.G_MISS_CHAR,
58 pricing_attribute52 VARCHAR2(150):= FND_API.G_MISS_CHAR,
59 pricing_attribute53 VARCHAR2(150):= FND_API.G_MISS_CHAR,
60 pricing_attribute54 VARCHAR2(150):= FND_API.G_MISS_CHAR,
61 pricing_attribute55 VARCHAR2(150):= FND_API.G_MISS_CHAR,
62 pricing_attribute56 VARCHAR2(150):= FND_API.G_MISS_CHAR,
63 pricing_attribute57 VARCHAR2(150):= FND_API.G_MISS_CHAR,
64 pricing_attribute58 VARCHAR2(150):= FND_API.G_MISS_CHAR,
65 pricing_attribute59 VARCHAR2(150):= FND_API.G_MISS_CHAR,
66 pricing_attribute60 VARCHAR2(150):= FND_API.G_MISS_CHAR,
67 pricing_attribute61 VARCHAR2(150):= FND_API.G_MISS_CHAR,
68 pricing_attribute62 VARCHAR2(150):= FND_API.G_MISS_CHAR,
69 pricing_attribute63 VARCHAR2(150):= FND_API.G_MISS_CHAR,
70 pricing_attribute64 VARCHAR2(150):= FND_API.G_MISS_CHAR,
71 pricing_attribute65 VARCHAR2(150):= FND_API.G_MISS_CHAR,
72 pricing_attribute66 VARCHAR2(150):= FND_API.G_MISS_CHAR,
73 pricing_attribute67 VARCHAR2(150):= FND_API.G_MISS_CHAR,
74 pricing_attribute68 VARCHAR2(150):= FND_API.G_MISS_CHAR,
75 pricing_attribute69 VARCHAR2(150):= FND_API.G_MISS_CHAR,
76 pricing_attribute70 VARCHAR2(150):= FND_API.G_MISS_CHAR,
77 pricing_attribute71 VARCHAR2(150):= FND_API.G_MISS_CHAR,
78 pricing_attribute72 VARCHAR2(150):= FND_API.G_MISS_CHAR,
79 pricing_attribute73 VARCHAR2(150):= FND_API.G_MISS_CHAR,
80 pricing_attribute74 VARCHAR2(150):= FND_API.G_MISS_CHAR,
81 pricing_attribute75 VARCHAR2(150):= FND_API.G_MISS_CHAR,
82 pricing_attribute76 VARCHAR2(150):= FND_API.G_MISS_CHAR,
83 pricing_attribute77 VARCHAR2(150):= FND_API.G_MISS_CHAR,
84 pricing_attribute78 VARCHAR2(150):= FND_API.G_MISS_CHAR,
85 pricing_attribute79 VARCHAR2(150):= FND_API.G_MISS_CHAR,
86 pricing_attribute80 VARCHAR2(150):= FND_API.G_MISS_CHAR,
87 pricing_attribute81 VARCHAR2(150):= FND_API.G_MISS_CHAR,
88 pricing_attribute82 VARCHAR2(150):= FND_API.G_MISS_CHAR,
89 pricing_attribute83 VARCHAR2(150):= FND_API.G_MISS_CHAR,
90 pricing_attribute84 VARCHAR2(150):= FND_API.G_MISS_CHAR,
91 pricing_attribute85 VARCHAR2(150):= FND_API.G_MISS_CHAR,
92 pricing_attribute86 VARCHAR2(150):= FND_API.G_MISS_CHAR,
93 pricing_attribute87 VARCHAR2(150):= FND_API.G_MISS_CHAR,
94 pricing_attribute88 VARCHAR2(150):= FND_API.G_MISS_CHAR,
95 pricing_attribute89 VARCHAR2(150):= FND_API.G_MISS_CHAR,
96 pricing_attribute90 VARCHAR2(150):= FND_API.G_MISS_CHAR,
97 pricing_attribute91 VARCHAR2(150):= FND_API.G_MISS_CHAR,
98 pricing_attribute92 VARCHAR2(150):= FND_API.G_MISS_CHAR,
99 pricing_attribute93 VARCHAR2(150):= FND_API.G_MISS_CHAR,
100 pricing_attribute94 VARCHAR2(150):= FND_API.G_MISS_CHAR,
101 pricing_attribute95 VARCHAR2(150):= FND_API.G_MISS_CHAR,
102 pricing_attribute96 VARCHAR2(150):= FND_API.G_MISS_CHAR,
103 pricing_attribute97 VARCHAR2(150):= FND_API.G_MISS_CHAR,
104 pricing_attribute98 VARCHAR2(150):= FND_API.G_MISS_CHAR,
105 pricing_attribute99 VARCHAR2(150):= FND_API.G_MISS_CHAR,
106 pricing_attribute100 VARCHAR2(150):= FND_API.G_MISS_CHAR
107 ) ;
108
109
110 PROCEDURE Check_Reqd_Param
111 (
112 p_param_value IN NUMBER,
113 p_param_name IN VARCHAR2,
114 p_api_name IN VARCHAR2
115 );
116
117 PROCEDURE Check_Reqd_Param
118 (
119 p_param_value IN VARCHAR2,
120 p_param_name IN VARCHAR2,
121 p_api_name IN VARCHAR2
122 );
123
124 PROCEDURE Check_Reqd_Param
125 (
126 p_param_value IN DATE,
127 p_param_name IN VARCHAR2,
128 p_api_name IN VARCHAR2
129 );
130
131 FUNCTION Get_No_Chg_Flag
132 ( p_txn_billing_type_id IN NUMBER
133 ) RETURN VARCHAR2;
134
135
136 FUNCTION Validate_action
137 (
138 p_action IN VARCHAR2,
139 p_api_name IN VARCHAR2
140 ) RETURN BOOLEAN;
141
142 FUNCTION Validate_incident_id
143 (
144 p_incident_id IN NUMBER
145 ) RETURN BOOLEAN;
146
147 FUNCTION Validate_repair_type_id
148 (
149 p_repair_type_id IN NUMBER
150 ) RETURN BOOLEAN;
151
152 FUNCTION Validate_inventory_item_id
153 (
154 p_inventory_item_id IN NUMBER
155 ) RETURN BOOLEAN;
156
157 FUNCTION Validate_unit_of_measure
158 (
159 p_unit_of_measure IN VARCHAR2
160 ) RETURN BOOLEAN;
161
162 FUNCTION Validate_repair_group_id
163 (
164 p_repair_group_id IN NUMBER
165 ) RETURN BOOLEAN;
166
167 FUNCTION Validate_ro_job_date
168 (
169 p_date IN DATE
170 ) RETURN BOOLEAN;
171
172 PROCEDURE Convert_Est_to_Chg_rec
173 (
174 p_estimate_line_rec IN CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,
175 x_charges_rec OUT NOCOPY CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE,
176 x_return_status OUT NOCOPY VARCHAR2
177 );
178
179 PROCEDURE get_incident_id
180 (
181 p_repair_line_id IN NUMBER,
182 x_incident_id OUT NOCOPY NUMBER,
183 x_return_status OUT NOCOPY VARCHAR2
184 );
185
186 PROCEDURE build_prod_txn_tbl
187 (
188 p_repair_line_id IN NUMBER,
189 x_prod_txn_tbl OUT NOCOPY csd_process_pvt.product_txn_tbl,
190 x_return_status OUT NOCOPY VARCHAR2
191 );
192
193 PROCEDURE build_prodtxn_tbl_int
194 ( p_repair_line_id IN NUMBER,
195 p_quantity IN NUMBER,
196 p_Serial_number IN VARCHAR2,
197 p_instance_id IN NUMBER,
198 x_prod_txn_tbl OUT NOCOPY csd_process_pvt.product_txn_tbl,
199 x_return_status OUT NOCOPY VARCHAR2
200 ) ;
201
202
203 FUNCTION Validate_rep_line_id
204 (
205 p_repair_line_id IN NUMBER
206 ) RETURN BOOLEAN;
207
208 FUNCTION Validate_action_type
209 ( p_action_type IN VARCHAR2
210 ) RETURN BOOLEAN;
211
212 FUNCTION Validate_action_code
213 ( p_action_code IN VARCHAR2
214 ) RETURN BOOLEAN;
215
216 FUNCTION get_org_id
217 (
218 --sangita shirkol changes p_repair_line_id IN NUMBER
219 p_incident_id IN NUMBER
220 ) RETURN NUMBER;
221
222 --sangita Shirkol chnages
223
224 FUNCTION get_inv_org_id
225 RETURN NUMBER;
226
227 FUNCTION get_bus_process
228 (
229 p_repair_line_id IN NUMBER
230 ) RETURN NUMBER;
231
232 PROCEDURE Convert_to_Chg_rec
233 (
234 p_prod_txn_rec IN CSD_PROCESS_PVT.PRODUCT_TXN_REC,
235 x_charges_rec OUT NOCOPY Cs_Charge_Details_Pub.CHARGES_REC_TYPE,
236 x_return_status OUT NOCOPY VARCHAR2
237 );
238
239
240 PROCEDURE get_line_type
241 (
242 p_txn_billing_type_id IN NUMBER,
243 p_org_id IN NUMBER,
244 x_line_type_id OUT NOCOPY NUMBER,
245 x_line_category_code OUT NOCOPY VARCHAR2,
246 x_return_status OUT NOCOPY VARCHAR2
247 );
248
249 FUNCTION Get_group_rejected_quantity
250 (
251 p_repair_group_id IN NUMBER
252 ) RETURN NUMBER;
253
254 FUNCTION Validate_prod_txn_id
255 (
256 p_prod_txn_id IN NUMBER
257 ) RETURN BOOLEAN;
258
259 FUNCTION Validate_estimate_id
260 (
261 p_estimate_id IN NUMBER
262 ) RETURN BOOLEAN;
263
264 FUNCTION Validate_estimate_line_id
265 (
266 p_estimate_line_id IN NUMBER
267 ) RETURN BOOLEAN;
268
269 FUNCTION Validate_wip_entity_id
270 (
271 p_wip_entity_id IN NUMBER
272 ) RETURN BOOLEAN;
273
274 PROCEDURE Validate_wip_task
275 (
276 p_prod_txn_id IN NUMBER,
277 x_return_status OUT NOCOPY VARCHAR2
278 );
279
280 PROCEDURE Validate_quantity
281 (
282 p_action_type IN VARCHAR2,
283 p_repair_line_id IN VARCHAR2,
284 p_prod_txn_qty IN NUMBER,
285 x_return_status OUT NOCOPY VARCHAR2
286 );
287
288 FUNCTION Is_item_serialized
289 (
290 p_inv_item_id IN NUMBER
291 ) RETURN BOOLEAN;
292
293 FUNCTION get_estimate( p_repair_line_id number,p_code varchar2 ) RETURN number;
294 FUNCTION g_miss_num RETURN number;
295 FUNCTION g_miss_char RETURN varchar2;
296 FUNCTION g_miss_date RETURN date;
297 FUNCTION g_valid_level(p_level varchar2) RETURN number;
298 FUNCTION g_boolean(p_FLAG varchar2) RETURN varchar2;
299 FUNCTION get_error_constant(err_msg varchar2) RETURN varchar2;
300 FUNCTION ui_prod_txn_rec RETURN csd_process_pvt.product_txn_rec;
301 FUNCTION sr_rec RETURN csd_process_pvt.service_request_rec;
302 FUNCTION repair_order_rec RETURN csd_repairs_pub.repln_rec_type;
303 FUNCTION ui_estimate_rec RETURN csd_repair_estimate_pvt.repair_estimate_rec;
304 FUNCTION ui_job_parameter_rec RETURN csd_group_job_pvt.job_parameter_rec;
305 FUNCTION ui_estimate_line_rec RETURN csd_repair_estimate_pvt.repair_estimate_line_rec;
306 FUNCTION ui_actual_lines_rec RETURN CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_REC_TYPE;
307 FUNCTION ui_charge_lines_rec RETURN Cs_Charge_Details_Pub.CHARGES_REC_TYPE;
308 FUNCTION ui_actuals_rec RETURN CSD_REPAIR_ACTUALS_PVT.CSD_REPAIR_ACTUALS_REC_TYPE;
309 FUNCTION ui_pricing_attr_rec RETURN csd_process_util.pricing_attr_rec;
310
311 FUNCTION ui_instance_rec RETURN csi_datastructures_pub.instance_rec;
312 FUNCTION ui_party_tbl RETURN csi_datastructures_pub.party_tbl;
313 FUNCTION ui_party_account_tbl RETURN csi_datastructures_pub.party_account_tbl;
314 FUNCTION ui_organization_units_tbl RETURN csi_datastructures_pub.organization_units_tbl;
315 FUNCTION ui_extend_attrib_values_tbl RETURN csi_datastructures_pub.extend_attrib_values_tbl;
316 FUNCTION ui_pricing_attribs_tbl RETURN csi_datastructures_pub.pricing_attribs_tbl;
317 FUNCTION ui_instance_asset_tbl RETURN csi_datastructures_pub.instance_asset_tbl;
318 FUNCTION ui_transaction_rec RETURN csi_datastructures_pub.transaction_rec;
319
320
321 PROCEDURE GET_CHARGE_SELLING_PRICE
322 (p_inventory_item_id in NUMBER,
323 p_price_list_header_id in NUMBER,
324 p_unit_of_measure_code in VARCHAR2,
325 p_currency_code in VARCHAR2,
326 p_quantity_required in NUMBER,
327 p_account_id in NUMBER DEFAULT null, /* bug#3875036 */
328 p_org_id in NUMBER, -- Added for R12
329 p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,
330 x_selling_price out NOCOPY NUMBER,
331 x_return_status out NOCOPY VARCHAR2,
332 x_msg_count OUT NOCOPY NUMBER,
333 x_msg_data OUT NOCOPY VARCHAR2
334 ) ;
335
336 /* bug#3875036 */
337 PROCEDURE PRICE_REQUEST
338 (p_inventory_item_id in NUMBER,
339 p_price_list_header_id in NUMBER,
340 p_unit_of_measure_code in VARCHAR2,
341 p_currency_code in VARCHAR2,
342 p_quantity_required in NUMBER,
343 p_account_id in NUMBER DEFAULT null,
344 p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,
345 x_selling_price out NOCOPY NUMBER,
346 x_return_status out NOCOPY VARCHAR2,
347 x_msg_count OUT NOCOPY NUMBER,
348 x_msg_data OUT NOCOPY VARCHAR2
349 ) ;
350
351
352 --gilam: bug 3082902 - ADD DEFAULT PRICE LIST TO RO FOR CONSISTENCY WITH RO CURRENCY
353 PROCEDURE GET_RO_DEFAULT_CURR_PL
354 (
355 p_api_version IN NUMBER,
356 p_init_msg_list IN VARCHAR2,
357 p_incident_id IN NUMBER,
358 p_repair_type_id IN NUMBER,
359 p_ro_contract_line_id IN NUMBER,
360 x_contract_pl_id OUT NOCOPY NUMBER,
361 x_profile_pl_id OUT NOCOPY NUMBER,
362 x_currency_code OUT NOCOPY VARCHAR2,
363 x_return_status OUT NOCOPY VARCHAR2,
364 x_msg_count OUT NOCOPY NUMBER,
365 x_msg_data OUT NOCOPY VARCHAR2
366 );
367 --
368
369 -- travi changes
370 -- *******************************************************
371 -- Start of Comments
372 -- *******************************************************
373 -- API Name : COMMIT_ROLLBACK
374 -- Type : Private Procedure
375 -- Pre-Req : None
376 -- Function : Does a commit or a rollback on the server side.
377 --
378 -- PARAMETERS
379 -- IN
380 -- COM_ROLL IN VARCHAR2 Optional Default := 'ROLL'
381 --
382 -- End of Comments
383 --
384
385 PROCEDURE COMMIT_ROLLBACK(
386 COM_ROLL IN VARCHAR2 := 'ROLL') ;
387
388 -- *******************************************************
389 -- Start of Comments
390 -- *******************************************************
391 -- API Name : G_RET_STS_SUCCESS
392 -- Type : Private Function
393 -- Pre-Req : None
394 -- Function : Returns the Value of the Constant FND_API.G_RET_STS_SUCCESS
395 -- Return Type : Date
396 --
397 -- End of Comments
398 --
399 FUNCTION G_RET_STS_SUCCESS RETURN VARCHAR2 ;
400
401 -- *******************************************************
402 -- Start of Comments
403 -- *******************************************************
404 -- API Name : G_RET_STS_ERROR
405 -- Type : Private Function
406 -- Pre-Req : None
407 -- Function : Returns the Value of the Constant FND_API.G_RET_STS_ERROR
408 -- Return Type : Date
409 --
410 -- End of Comments
411 --
412 FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 ;
413
414 -- *******************************************************
415 -- Start of Comments
416 -- *******************************************************
417 -- API Name : G_RET_STS_UNEXP_ERROR
418 -- Type : Private Function
419 -- Pre-Req : None
420 -- Function : Returns the Value of the Constant FND_API.G_RET_STS_UNEXP_ERROR
421 -- Return Type : Date
422 --
423 -- End of Comments
424 --
425 FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 ;
426
427 -- *******************************************************
428 -- Start of Comments
429 -- *******************************************************
430 -- API Name : G_VALID_LEVEL_NONE
431 -- Type : Private Function
432 -- Pre-Req : None
433 -- Function : Returns the Value of the Constant
434 -- FND_API.G_VALID_LEVEL_NONE
435 -- Return Type : Number
436 --
437 -- End of Comments
438 --
439 FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER;
440
441 -- *******************************************************
442 -- Start of Comments
443 -- *******************************************************
444 -- API Name : G_VALID_LEVEL_FULL
445 -- Type : Private Function
446 -- Pre-Req : None
447 -- Function : Returns the Value of the Constant
448 -- FND_API.G_VALID_LEVEL_FULL
449 -- Return Type : Number
450 --
451 -- End of Comments
452 --
453 FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER;
454
455 -- *******************************************************
456 -- Start of Comments
457 -- *******************************************************
458 -- API Name : G_VALID_LEVEL_INT
459 -- Type : Private Function
460 -- Pre-Req : None
461 -- Function : Returns the Value of the Constant
462 -- CS_INTERACTION_PVT.G_VALID_LEVEL_INT
463 -- Return Type : Number
464 --
465 -- End of Comments
466 --
467 FUNCTION G_VALID_LEVEL_INT RETURN NUMBER;
468
469 -- *******************************************************
470 -- Start of Comments
471 -- *******************************************************
472 -- API Name : G_TRUE
473 -- Type : Private Function
474 -- Pre-Req : None
475 -- Function : Returns the Value of the Constant
476 -- FND_API.G_TRUE
477 -- Return Type : Varchar2
478 --
479 -- End of Comments
480 --
481 FUNCTION G_TRUE RETURN Varchar2;
482
483 -- *******************************************************
484 -- Start of Comments
485 -- *******************************************************
486 -- API Name : G_FALSE
487 -- Type : Private Function
488 -- Pre-Req : None
489 -- Function : Returns the Value of the Constant
490 -- FND_API.G_FALSE
491 -- Return Type : Varchar2
492 --
493 -- End of Comments
494 --
495 FUNCTION G_FALSE RETURN Varchar2;
496
497 FUNCTION get_res_name (p_object_type_code IN VARCHAR2,
498 p_object_id IN NUMBER)
499 RETURN VARCHAR2;
500
501
502 -- *******************************************************
503 -- Start of Comments
504 -- *******************************************************
505 -- API Name : Is_MultiOrg_Enabled
506 -- Type : Private Function
507 -- Pre-Req : None
508 -- Function : Returns TRUE if multiorg is enabled
509 -- else returns FALSE
510 -- Return Type : Boolean
511 --
512 -- End of Comments
513 --
514 FUNCTION Is_MultiOrg_Enabled RETURN BOOLEAN;
515
516
517 -- *******************************************************
518 -- Start of Comments
519 -- *******************************************************
520 -- API Name : Get_GLCurrencyCode
521 -- Type : Private Function
522 -- Pre-Req : None
523 -- Function : Returns CURRENCY CODE for the org id passed. If no currency
524 -- code exists for the org, returns null.
525 -- Return Type : Varchar2
526 --
527 -- End of Comments
528 --
529
530
531 FUNCTION Get_GLCurrencyCode (p_org_id IN NUMBER )
532 RETURN VARCHAR2;
533
534
535 -- bug fix for 4108369, Begin
536 FUNCTION Get_Sr_add_to_order (
537 p_repair_line_Id IN NUMBER,
538 p_action_type IN VARCHAR2
539 ) RETURN NUMBER;
540
541
542
543 -- ***************************************************************************************
544 -- Fixed for bug#5190905
545 --
546 -- Procedure name: csd_get_txn_billing_type
547 -- description : Ideally, the RT setup should capture SACs 'RMA'/'Ship' only (not SAC-BT) and select
548 -- billing type based on the item attribute at the time of default prod txn creation.
549 -- This API return the correct txn_billing_type_id based on Item billing type and service
550 -- activity (Transaction_type_id).
551 -- If transaction_type_id is not passed to this API then it derive the transaction_type_id
552 -- using parameter p_txn_billing_type_id and then it derive the correct txn_billing_type_id
553 -- for transaction.
554 -- Called from : WVI trigger of rcv_ship.TRANSACTION_TYPE and CSD_PROCESS_UTIL.build_prodtxn_tbl_int
555 -- Input Parm : p_api_version NUMBER Api Version number
556 -- p_init_msg_list VARCHAR2 Initializes message stack if fnd_api.g_true,
557 -- default value is fnd_api.g_false
558 -- p_incident_id NUMBER incident id of service request
559 -- p_inventory_item_id NUMBER
560 -- p_transaction_type_id NUMBER
561 -- p_txn_billing_type_id NUMBER txn_billing_type_id (Service activity billing type SAC-BT)
562 -- selected by user in RO type setup form. This can be pre/post
563 -- repair RMA service activity or pre/post SHIP repair Service activity
564 -- Output Parm :
565 -- x_txn_billing_type_id NUMBER New Txn_billing_type_Id based on transaction
566 -- type and billing type of Item
567 -- x_return_status VARCHAR2 Return status after the call. The status can be
568 -- fnd_api.g_ret_sts_success (success)
569 -- fnd_api.g_ret_sts_error (error)
570 -- fnd_api.g_ret_sts_unexp_error (unexpected)
571 -- x_msg_count NUMBER Number of messages in the message stack
572 -- x_msg_data VARCHAR2 Message text if x_msg_count >= 1
573 -- **************************************************************************************
574 Procedure csd_get_txn_billing_type (
575 p_api_version IN NUMBER,
576 p_init_msg_list IN VARCHAR2,
577 p_incident_id IN NUMBER,
578 p_inventory_item_id IN NUMBER,
579 P_transaction_type_id IN NUMBER,
580 p_txn_billing_type_id IN NUMBER,
581 x_txn_billing_type_id OUT NOCOPY NUMBER,
582 x_return_status OUT NOCOPY VARCHAR2,
583 x_msg_count OUT NOCOPY NUMBER,
584 x_msg_data OUT NOCOPY VARCHAR2
585 );
586
587 /* bug#3875036 */
588 FUNCTION GET_PL_CURRENCY_CODE(p_price_list_id IN NUMBER)
589 RETURN VARCHAR2;
590
591
592 End CSD_PROCESS_UTIL ;