[Home] [Help]
PACKAGE: APPS.CSD_PROCESS_UTIL
Source
1 PACKAGE CSD_PROCESS_UTIL AUTHID CURRENT_USER as
2 /* $Header: csdvutls.pls 120.11 2011/04/12 17:45:30 subhat 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 p_create_thirdpty_line IN VARCHAR2 := fnd_api.g_false,
190 p_return_reason_code IN VARCHAR2 := NULL,
191 p_invoice_to_org_id IN NUMBER := NULL,
192 p_ship_to_org_id IN NUMBER := NULL,
193 x_prod_txn_tbl OUT NOCOPY csd_process_pvt.product_txn_tbl,
194 x_return_status OUT NOCOPY VARCHAR2
195 );
196
197 PROCEDURE build_prodtxn_tbl_int
198 ( p_repair_line_id IN NUMBER,
199 p_quantity IN NUMBER,
200 p_Serial_number IN VARCHAR2,
201 p_instance_id IN NUMBER,
202 p_create_thirdpty_line IN VARCHAR2 := fnd_api.g_false,
203 p_return_reason_code IN VARCHAR2 := NULL,
204 p_invoice_to_org_id IN NUMBER := NULL,
205 p_ship_to_org_id IN NUMBER := NULL,
206 x_prod_txn_tbl OUT NOCOPY csd_process_pvt.product_txn_tbl,
207 x_return_status OUT NOCOPY VARCHAR2
208 ) ;
209
210
211 FUNCTION Validate_rep_line_id
212 (
213 p_repair_line_id IN NUMBER
214 ) RETURN BOOLEAN;
215
216 FUNCTION Validate_action_type
217 ( p_action_type IN VARCHAR2
218 ) RETURN BOOLEAN;
219
220 FUNCTION Validate_action_code
221 ( p_action_code IN VARCHAR2
222 ) RETURN BOOLEAN;
223
224 FUNCTION get_org_id
225 (
226 --sangita shirkol changes p_repair_line_id IN NUMBER
227 p_incident_id IN NUMBER
228 ) RETURN NUMBER;
229
230 --sangita Shirkol chnages
231
232 FUNCTION get_inv_org_id
233 RETURN NUMBER;
234
235 FUNCTION get_bus_process
236 (
237 p_repair_line_id IN NUMBER
238 ) RETURN NUMBER;
239
240 PROCEDURE Convert_to_Chg_rec
241 (
242 p_prod_txn_rec IN CSD_PROCESS_PVT.PRODUCT_TXN_REC,
243 x_charges_rec OUT NOCOPY Cs_Charge_Details_Pub.CHARGES_REC_TYPE,
244 x_return_status OUT NOCOPY VARCHAR2
245 );
246
247
248 PROCEDURE get_line_type
249 (
250 p_txn_billing_type_id IN NUMBER,
251 p_org_id IN NUMBER,
252 x_line_type_id OUT NOCOPY NUMBER,
253 x_line_category_code OUT NOCOPY VARCHAR2,
254 x_return_status OUT NOCOPY VARCHAR2
255 );
256
257 FUNCTION Get_group_rejected_quantity
258 (
259 p_repair_group_id IN NUMBER
260 ) RETURN NUMBER;
261
262 FUNCTION Validate_prod_txn_id
263 (
264 p_prod_txn_id IN NUMBER
265 ) RETURN BOOLEAN;
266
267 FUNCTION Validate_estimate_id
268 (
269 p_estimate_id IN NUMBER
270 ) RETURN BOOLEAN;
271
272 FUNCTION Validate_estimate_line_id
273 (
274 p_estimate_line_id IN NUMBER
275 ) RETURN BOOLEAN;
276
277 FUNCTION Validate_wip_entity_id
278 (
279 p_wip_entity_id IN NUMBER
280 ) RETURN BOOLEAN;
281
282 PROCEDURE Validate_wip_task
283 (
284 p_prod_txn_id IN NUMBER,
285 x_return_status OUT NOCOPY VARCHAR2
286 );
287
288 PROCEDURE Validate_quantity
289 (
290 p_action_type IN VARCHAR2,
291 p_repair_line_id IN VARCHAR2,
292 p_prod_txn_qty IN NUMBER,
293 x_return_status OUT NOCOPY VARCHAR2
294 );
295
296 FUNCTION Is_item_serialized
297 (
298 p_inv_item_id IN NUMBER
299 ) RETURN BOOLEAN;
300
301 FUNCTION get_estimate( p_repair_line_id number,p_code varchar2 ) RETURN number;
302 FUNCTION g_miss_num RETURN number;
303 FUNCTION g_miss_char RETURN varchar2;
304 FUNCTION g_miss_date RETURN date;
305 FUNCTION g_valid_level(p_level varchar2) RETURN number;
306 FUNCTION g_boolean(p_FLAG varchar2) RETURN varchar2;
307 FUNCTION get_error_constant(err_msg varchar2) RETURN varchar2;
308 FUNCTION ui_prod_txn_rec RETURN csd_process_pvt.product_txn_rec;
309 FUNCTION sr_rec RETURN csd_process_pvt.service_request_rec;
310 FUNCTION repair_order_rec RETURN csd_repairs_pub.repln_rec_type;
311 FUNCTION ui_estimate_rec RETURN csd_repair_estimate_pvt.repair_estimate_rec;
312 FUNCTION ui_job_parameter_rec RETURN csd_group_job_pvt.job_parameter_rec;
313 FUNCTION ui_estimate_line_rec RETURN csd_repair_estimate_pvt.repair_estimate_line_rec;
314 FUNCTION ui_actual_lines_rec RETURN CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_REC_TYPE;
315 FUNCTION ui_charge_lines_rec RETURN Cs_Charge_Details_Pub.CHARGES_REC_TYPE;
316 FUNCTION ui_actuals_rec RETURN CSD_REPAIR_ACTUALS_PVT.CSD_REPAIR_ACTUALS_REC_TYPE;
317 FUNCTION ui_pricing_attr_rec RETURN csd_process_util.pricing_attr_rec;
318
319 FUNCTION ui_instance_rec RETURN csi_datastructures_pub.instance_rec;
320 FUNCTION ui_party_tbl RETURN csi_datastructures_pub.party_tbl;
321 FUNCTION ui_party_account_tbl RETURN csi_datastructures_pub.party_account_tbl;
322 FUNCTION ui_organization_units_tbl RETURN csi_datastructures_pub.organization_units_tbl;
323 FUNCTION ui_extend_attrib_values_tbl RETURN csi_datastructures_pub.extend_attrib_values_tbl;
324 FUNCTION ui_pricing_attribs_tbl RETURN csi_datastructures_pub.pricing_attribs_tbl;
325 FUNCTION ui_instance_asset_tbl RETURN csi_datastructures_pub.instance_asset_tbl;
326 FUNCTION ui_transaction_rec RETURN csi_datastructures_pub.transaction_rec;
327
328
329 PROCEDURE GET_CHARGE_SELLING_PRICE
330 (p_inventory_item_id in NUMBER,
331 p_price_list_header_id in NUMBER,
332 p_unit_of_measure_code in VARCHAR2,
333 p_currency_code in VARCHAR2,
334 p_quantity_required in NUMBER,
335 p_account_id in NUMBER DEFAULT null, /* bug#3875036 */
336 p_org_id in NUMBER, -- Added for R12
337 p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,
338 x_selling_price out NOCOPY NUMBER,
339 x_return_status out NOCOPY VARCHAR2,
340 x_msg_count OUT NOCOPY NUMBER,
341 x_msg_data OUT NOCOPY VARCHAR2
342 ) ;
343
344 /* bug#3875036 */
345 PROCEDURE PRICE_REQUEST
346 (p_inventory_item_id in NUMBER,
347 p_price_list_header_id in NUMBER,
348 p_unit_of_measure_code in VARCHAR2,
349 p_currency_code in VARCHAR2,
350 p_quantity_required in NUMBER,
351 p_account_id in NUMBER DEFAULT null,
352 p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,
353 x_selling_price out NOCOPY NUMBER,
354 x_return_status out NOCOPY VARCHAR2,
355 x_msg_count OUT NOCOPY NUMBER,
356 x_msg_data OUT NOCOPY VARCHAR2
357 ) ;
358
359
360 --gilam: bug 3082902 - ADD DEFAULT PRICE LIST TO RO FOR CONSISTENCY WITH RO CURRENCY
361 PROCEDURE GET_RO_DEFAULT_CURR_PL
362 (
363 p_api_version IN NUMBER,
364 p_init_msg_list IN VARCHAR2,
365 p_incident_id IN NUMBER,
366 p_repair_type_id IN NUMBER,
367 p_ro_contract_line_id IN NUMBER,
368 x_contract_pl_id OUT NOCOPY NUMBER,
369 x_profile_pl_id OUT NOCOPY NUMBER,
370 x_currency_code OUT NOCOPY VARCHAR2,
371 x_return_status OUT NOCOPY VARCHAR2,
372 x_msg_count OUT NOCOPY NUMBER,
373 x_msg_data OUT NOCOPY VARCHAR2
374 );
375 --
376
377 -- travi changes
378 -- *******************************************************
379 -- Start of Comments
380 -- *******************************************************
381 -- API Name : COMMIT_ROLLBACK
382 -- Type : Private Procedure
383 -- Pre-Req : None
384 -- Function : Does a commit or a rollback on the server side.
385 --
386 -- PARAMETERS
387 -- IN
388 -- COM_ROLL IN VARCHAR2 Optional Default := 'ROLL'
389 --
390 -- End of Comments
391 --
392
393 PROCEDURE COMMIT_ROLLBACK(
394 COM_ROLL IN VARCHAR2 := 'ROLL') ;
395
396 -- *******************************************************
397 -- Start of Comments
398 -- *******************************************************
399 -- API Name : G_RET_STS_SUCCESS
400 -- Type : Private Function
401 -- Pre-Req : None
402 -- Function : Returns the Value of the Constant FND_API.G_RET_STS_SUCCESS
403 -- Return Type : Date
404 --
405 -- End of Comments
406 --
407 FUNCTION G_RET_STS_SUCCESS RETURN VARCHAR2 ;
408
409 -- *******************************************************
410 -- Start of Comments
411 -- *******************************************************
412 -- API Name : G_RET_STS_ERROR
413 -- Type : Private Function
414 -- Pre-Req : None
415 -- Function : Returns the Value of the Constant FND_API.G_RET_STS_ERROR
416 -- Return Type : Date
417 --
418 -- End of Comments
419 --
420 FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 ;
421
422 -- *******************************************************
423 -- Start of Comments
424 -- *******************************************************
425 -- API Name : G_RET_STS_UNEXP_ERROR
426 -- Type : Private Function
427 -- Pre-Req : None
428 -- Function : Returns the Value of the Constant FND_API.G_RET_STS_UNEXP_ERROR
429 -- Return Type : Date
430 --
431 -- End of Comments
432 --
433 FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 ;
434
435 -- *******************************************************
436 -- Start of Comments
437 -- *******************************************************
438 -- API Name : G_VALID_LEVEL_NONE
439 -- Type : Private Function
440 -- Pre-Req : None
441 -- Function : Returns the Value of the Constant
442 -- FND_API.G_VALID_LEVEL_NONE
443 -- Return Type : Number
444 --
445 -- End of Comments
446 --
447 FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER;
448
449 -- *******************************************************
450 -- Start of Comments
451 -- *******************************************************
452 -- API Name : G_VALID_LEVEL_FULL
453 -- Type : Private Function
454 -- Pre-Req : None
455 -- Function : Returns the Value of the Constant
456 -- FND_API.G_VALID_LEVEL_FULL
457 -- Return Type : Number
458 --
459 -- End of Comments
460 --
461 FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER;
462
463 -- *******************************************************
464 -- Start of Comments
465 -- *******************************************************
466 -- API Name : G_VALID_LEVEL_INT
467 -- Type : Private Function
468 -- Pre-Req : None
469 -- Function : Returns the Value of the Constant
470 -- CS_INTERACTION_PVT.G_VALID_LEVEL_INT
471 -- Return Type : Number
472 --
473 -- End of Comments
474 --
475 FUNCTION G_VALID_LEVEL_INT RETURN NUMBER;
476
477 -- *******************************************************
478 -- Start of Comments
479 -- *******************************************************
480 -- API Name : G_TRUE
481 -- Type : Private Function
482 -- Pre-Req : None
483 -- Function : Returns the Value of the Constant
484 -- FND_API.G_TRUE
485 -- Return Type : Varchar2
486 --
487 -- End of Comments
488 --
489 FUNCTION G_TRUE RETURN Varchar2;
490
491 -- *******************************************************
492 -- Start of Comments
493 -- *******************************************************
494 -- API Name : G_FALSE
495 -- Type : Private Function
496 -- Pre-Req : None
497 -- Function : Returns the Value of the Constant
498 -- FND_API.G_FALSE
499 -- Return Type : Varchar2
500 --
501 -- End of Comments
502 --
503 FUNCTION G_FALSE RETURN Varchar2;
504
505 FUNCTION get_res_name (p_object_type_code IN VARCHAR2,
506 p_object_id IN NUMBER)
507 RETURN VARCHAR2;
508
509
510 -- *******************************************************
511 -- Start of Comments
512 -- *******************************************************
513 -- API Name : Is_MultiOrg_Enabled
514 -- Type : Private Function
515 -- Pre-Req : None
516 -- Function : Returns TRUE if multiorg is enabled
517 -- else returns FALSE
518 -- Return Type : Boolean
519 --
520 -- End of Comments
521 --
522 FUNCTION Is_MultiOrg_Enabled RETURN BOOLEAN;
523
524
525 -- *******************************************************
526 -- Start of Comments
527 -- *******************************************************
528 -- API Name : Get_GLCurrencyCode
529 -- Type : Private Function
530 -- Pre-Req : None
531 -- Function : Returns CURRENCY CODE for the org id passed. If no currency
532 -- code exists for the org, returns null.
533 -- Return Type : Varchar2
534 --
535 -- End of Comments
536 --
537
538
539 FUNCTION Get_GLCurrencyCode (p_org_id IN NUMBER )
540 RETURN VARCHAR2;
541
542
543 -- bug fix for 4108369, Begin
544 FUNCTION Get_Sr_add_to_order (
545 p_repair_line_Id IN NUMBER,
546 p_action_type IN VARCHAR2
547 ) RETURN NUMBER;
548
549
550
551 -- ***************************************************************************************
552 -- Fixed for bug#5190905
553 --
554 -- Procedure name: csd_get_txn_billing_type
555 -- description : Ideally, the RT setup should capture SACs 'RMA'/'Ship' only (not SAC-BT) and select
556 -- billing type based on the item attribute at the time of default prod txn creation.
557 -- This API return the correct txn_billing_type_id based on Item billing type and service
558 -- activity (Transaction_type_id).
559 -- If transaction_type_id is not passed to this API then it derive the transaction_type_id
560 -- using parameter p_txn_billing_type_id and then it derive the correct txn_billing_type_id
561 -- for transaction.
562 -- Called from : WVI trigger of rcv_ship.TRANSACTION_TYPE and CSD_PROCESS_UTIL.build_prodtxn_tbl_int
563 -- Input Parm : p_api_version NUMBER Api Version number
564 -- p_init_msg_list VARCHAR2 Initializes message stack if fnd_api.g_true,
565 -- default value is fnd_api.g_false
566 -- p_incident_id NUMBER incident id of service request
567 -- p_inventory_item_id NUMBER
568 -- p_transaction_type_id NUMBER
569 -- p_txn_billing_type_id NUMBER txn_billing_type_id (Service activity billing type SAC-BT)
570 -- selected by user in RO type setup form. This can be pre/post
571 -- repair RMA service activity or pre/post SHIP repair Service activity
572 -- Output Parm :
573 -- x_txn_billing_type_id NUMBER New Txn_billing_type_Id based on transaction
574 -- type and billing type of Item
575 -- x_return_status VARCHAR2 Return status after the call. The status can be
576 -- fnd_api.g_ret_sts_success (success)
577 -- fnd_api.g_ret_sts_error (error)
578 -- fnd_api.g_ret_sts_unexp_error (unexpected)
579 -- x_msg_count NUMBER Number of messages in the message stack
580 -- x_msg_data VARCHAR2 Message text if x_msg_count >= 1
581 -- **************************************************************************************
582 Procedure csd_get_txn_billing_type (
583 p_api_version IN NUMBER,
584 p_init_msg_list IN VARCHAR2,
585 p_incident_id IN NUMBER,
586 p_inventory_item_id IN NUMBER,
587 P_transaction_type_id IN NUMBER,
588 p_txn_billing_type_id IN NUMBER,
589 x_txn_billing_type_id OUT NOCOPY NUMBER,
590 x_return_status OUT NOCOPY VARCHAR2,
591 x_msg_count OUT NOCOPY NUMBER,
592 x_msg_data OUT NOCOPY VARCHAR2
593 );
594
595 /* bug#3875036 */
596 FUNCTION GET_PL_CURRENCY_CODE(p_price_list_id IN NUMBER)
597 RETURN VARCHAR2;
598
599
600 --begin bug#7355526, nnadig
601 -- Description: validates the subinventory on the ship line.
602 -- The function will see if negative inventory is allowed, if yes, then
603 -- it will check for the availability of item/serial number in the inventory.
604 -- parameters
605 -- @p_org_id IN Organization id
606 -- @p_sub_inv IN Sub Inventory Code
607 -- @p_inventory_item_id IN Inventory Item id of item
608 -- @p_serial_number IN serial number of the item.
609
610 FUNCTION validate_subinventory_ship
611 (
612 p_org_id IN NUMBER,
613 p_sub_inv IN VARCHAR2,
614 p_inventory_item_id IN NUMBER,
615 p_serial_number IN VARCHAR2 )
616 RETURN BOOLEAN;
617
618 -- new function to validate the order, order line for OM holds.
619 -- Parameters.
620 -- @p_action_type in Type of line (RMA OR SHIP)
621 -- @p_order_header_id in order header id for the line.
622 -- @p_order_line_id in order line id for the line default is null.
623 -- @x_entity_on_hold out Tells entity on hold H = header L = line.
624 FUNCTION validate_order_for_holds
625 (
626 p_action_type IN VARCHAR2,
627 p_order_header_id IN NUMBER,
628 p_order_line_id IN NUMBER DEFAULT NULL)
629 RETURN BOOLEAN;
630
631 -- end bug#7355526, nnadig
632
633 End CSD_PROCESS_UTIL ;
634