1 PACKAGE csi_Item_Instance_Vld_pvt AS
2 /* $Header: csiviivs.pls 120.12.12010000.1 2008/07/25 08:16:01 appldev ship $ */
3
4 /*----------------------------------------------------*/
5 /* Procedure name: Check_Reqd_Param_num */
6 /* Description : To Check if the reqd parameter */
7 /*----------------------------------------------------*/
8
9 PROCEDURE Check_Reqd_Param_num
10 (
11 p_number IN NUMBER,
12 p_param_name IN VARCHAR2,
13 p_api_name IN VARCHAR2
14 );
15
16 /*----------------------------------------------------*/
17 /* Procedure name: Check_Reqd_Param_Char */
18 /* Description : To Check if the reqd parameter */
19 /*----------------------------------------------------*/
20
21 PROCEDURE Check_Reqd_Param_char
22 (
23 p_variable IN VARCHAR2,
24 p_param_name IN VARCHAR2,
25 p_api_name IN VARCHAR2
26 );
27
28 /*----------------------------------------------------*/
29 /* Procedure name: Check_Reqd_Param_Date */
30 /* Description : To Check if the reqd parameter */
31 /*----------------------------------------------------*/
32
33 PROCEDURE Check_Reqd_Param_date
34 (
35 p_date IN DATE,
36 p_param_name IN VARCHAR2,
37 p_api_name IN VARCHAR2
38 );
39
40 /*----------------------------------------------------*/
41 /* Validates the item instance ID */
42 /*----------------------------------------------------*/
43
44 FUNCTION InstanceExists
45 (
46 p_item_instance_id IN NUMBER,
47 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
48 )
49 RETURN BOOLEAN;
50
51 /*-----------------------------------------------------*/
52 /* Validates the termination status */
53 /*-----------------------------------------------------*/
54
55 FUNCTION termination_status
56 ( p_instance_status_id IN NUMBER
57 )
58 RETURN BOOLEAN;
59
60 /*----------------------------------------------------*/
61 /* Validates the item instance Number */
62 /*----------------------------------------------------*/
63
64
65 FUNCTION Is_InstanceNum_Valid
66 ( p_item_instance_id IN NUMBER,
67 p_instance_number IN VARCHAR2,
68 p_mode IN VARCHAR2,
69 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
70 ) RETURN BOOLEAN;
71
72 /*----------------------------------------------------*/
73 /* This function verifies that the item is a valid */
74 /* inventory item and is marked as 'Trackable' */
75 /*----------------------------------------------------*/
76
77 FUNCTION Is_Trackable
78 (
79 p_inv_item_id IN NUMBER,
80 p_org_id IN NUMBER,
81 p_trackable_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
82 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
83 )
84 RETURN BOOLEAN;
85
86 /*----------------------------------------------------*/
87 /* This Procedure verifies validity of serial number */
88 /* ,lot number and revision when vld_organization_id */
89 /* is changing. */
90 /*----------------------------------------------------*/
91
92 PROCEDURE Validate_org_dependent_params
93 (
94 p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
95 p_txn_rec IN csi_datastructures_pub.transaction_rec,
96 l_return_value IN OUT NOCOPY BOOLEAN
97 );
98
99 /*----------------------------------------------------*/
100 /* This Procedure verifies that the item revision is */
101 /* valid by looking into the mtl revision table */
102 /*----------------------------------------------------*/
103
104 PROCEDURE Validate_Revision
105 (
106 p_inv_item_id IN NUMBER,
107 p_inv_org_id IN NUMBER,
108 p_revision IN VARCHAR2,
109 p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
110 l_return_value IN OUT NOCOPY BOOLEAN,
111 p_rev_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM
112 );
113
114 PROCEDURE Update_Revision
115 (
116 p_inv_item_id IN NUMBER,
117 p_inv_org_id IN NUMBER,
118 p_revision IN VARCHAR2,
119 l_return_value IN OUT NOCOPY BOOLEAN,
120 p_rev_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM
121 );
122
123 /*------------------------------------------------------*/
124 /* This Procedure is called when creating a serial #s */
125 /* in mtl_serial_numbers for manually created CPs */
126 /*------------------------------------------------------*/
127 --
128 PROCEDURE Create_Serial
129 (
130 p_inv_org_id IN NUMBER,
131 p_inv_item_id IN NUMBER,
132 p_serial_number IN VARCHAR2,
133 p_mfg_srl_num_flag IN OUT NOCOPY VARCHAR2,
134 p_location_type_code IN VARCHAR2,
135 p_ins_flag OUT NOCOPY VARCHAR2,
136 p_lot_number IN VARCHAR2,
137 p_gen_object_id OUT NOCOPY NUMBER,
138 l_return_value IN OUT NOCOPY BOOLEAN
139 );
140 --
141 /*----------------------------------------------------*/
142 /* This function verifies that the item */
143 /* is under serial control or not */
144 /*----------------------------------------------------*/
145
146 FUNCTION Is_treated_serialized
147 ( p_serial_control_code IN NUMBER ,
148 p_location_type_code IN VARCHAR2,
149 p_transaction_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150 )
151 RETURN BOOLEAN;
152
153 /*----------------------------------------------------*/
154 /* This function verifies that the item serial number*/
155 /* is valid by looking into the mtl serial #s table */
156 /*----------------------------------------------------*/
157
158 PROCEDURE Validate_Serial_Number
159 (
160 p_inv_org_id IN NUMBER,
161 p_inv_item_id IN NUMBER,
162 p_serial_number IN VARCHAR2,
163 P_mfg_serial_number_flag IN VARCHAR2,
164 p_txn_rec IN csi_datastructures_pub.transaction_rec,
165 p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
166 p_location_type_code IN VARCHAR2, -- Added by sk on 09/13/01
167 p_srl_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,
168 p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
169 p_instance_usage_code IN VARCHAR2,
170 l_return_value IN OUT NOCOPY BOOLEAN
171 );
172
173 /*----------------------------------------------------*/
174 /* This procedure verifies that the serial number */
175 /* uniqueness */
176 /*----------------------------------------------------*/
177
178 PROCEDURE Validate_ser_uniqueness
179 (
180 p_inv_org_id IN NUMBER,
181 p_inv_item_id IN NUMBER,
182 p_serial_number IN VARCHAR2,
183 p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184 l_return_value IN OUT NOCOPY BOOLEAN
185 ) ;
186
187 /*---------------------------------------------------*/
188 /* Validates the lot uniqueness and creates lot */
189 /* numbers in MLNs for manually created Instances */
190 /* Bug# 4011408 */
191 /*---------------------------------------------------*/
192
193 PROCEDURE Create_Lot
194 (
195 p_inv_org_id IN NUMBER,
196 p_inv_item_id IN NUMBER,
197 p_lot_number IN VARCHAR2,
198 p_shelf_life_code IN NUMBER,
199 p_instance_id IN NUMBER,
200 l_return_value IN OUT NOCOPY BOOLEAN
201 );
202
203 /*----------------------------------------------------*/
204 /* This procedure verifies that the item lot number */
205 /* is valid by looking into the mtl lot #s table */
206 /*----------------------------------------------------*/
207
208 PROCEDURE Validate_Lot_Number
209 (
210 p_inv_org_id IN NUMBER,
211 p_inv_item_id IN NUMBER,
212 p_lot_number IN VARCHAR2,
213 p_mfg_serial_number_flag IN VARCHAR2,
214 p_txn_rec IN csi_datastructures_pub.transaction_rec,
215 p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
216 p_lot_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,
217 l_return_value IN OUT NOCOPY BOOLEAN
218 );
219
220 /*----------------------------------------------------*/
221 /* This function verifies that the quantity is not<0 */
222 /* and also checks for serialized items */
223 /*----------------------------------------------------*/
224
225 FUNCTION Is_Quantity_Valid
226 ( p_instance_id IN NUMBER ,
227 p_inv_organization_id IN NUMBER ,
228 p_quantity IN NUMBER ,
229 p_serial_control_code IN NUMBER ,
230 p_location_type_code IN VARCHAR2,
231 p_flag IN VARCHAR2,
232 p_csi_txn_type_id IN NUMBER DEFAULT -999,
233 p_current_qty IN NUMBER DEFAULT 0,
234 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
235 )
236 RETURN BOOLEAN;
237
238 /*------------------------------------------------------------*/
239 /* This function validates the uniqueness of config key */
240 /*------------------------------------------------------------*/
241
242 FUNCTION Is_unique_config_key
243 ( p_config_inst_hdr_id IN NUMBER ,
244 p_config_inst_item_id IN NUMBER ,
245 p_instance_id IN NUMBER ,
246 p_validation_mode IN VARCHAR2
247 )
248 RETURN BOOLEAN;
249
250 /*----------------------------------------------------*/
251 /* This function verifies that the UOM code is */
252 /* valid by looking into the mtl units of measure */
253 /* Also converts the entered uom into base uom */
254 /*----------------------------------------------------*/
255
256 Procedure Is_Valid_Uom
257 (
258 p_inv_org_id IN NUMBER,
259 p_inv_item_id IN NUMBER,
260 p_uom_code IN OUT NOCOPY VARCHAR2,
261 p_quantity IN OUT NOCOPY NUMBER,
262 p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
263 l_return_value IN OUT NOCOPY BOOLEAN);
264
265 /*----------------------------------------------------*/
266 /* This function validates the item condition by */
267 /* looking through the MTL Material Statuses */
268 /*----------------------------------------------------*/
269
270 PROCEDURE Is_Valid_Condition
271 (
272 p_instance_condition_id IN NUMBER,
273 p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
274 l_return_value IN OUT NOCOPY BOOLEAN
275 );
276 /*----------------------------------------------------*/
277 /* This function validates the item status by */
278 /* looking into the IB status tables */
279 /*----------------------------------------------------*/
280
281 PROCEDURE Is_Valid_Status
282 (
283 p_instance_status_id IN NUMBER,
284 p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
285 l_return_value IN OUT NOCOPY BOOLEAN
286 );
287
288 /*----------------------------------------------------*/
289 /* This function validates the system id bu looking */
290 /* into the CSI systems lookup table */
291 /*----------------------------------------------------*/
292
293 FUNCTION Is_Valid_System_id
294 (
295 p_system_id IN NUMBER,
296 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
297 )
298 RETURN BOOLEAN;
299
300 /*----------------------------------------------------*/
301 /* This function checks for the instance type code */
302 /* by looking through the CSI lookups */
303 /*----------------------------------------------------*/
304
305 FUNCTION Is_Valid_Instance_Type
306 (
307 p_instance_type_code IN VARCHAR2,
308 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
309 )
310 RETURN BOOLEAN;
311
312 /*-----------------------------------------------------*/
313 /* This function checks for the instance usage code */
314 /* by looking through the CSI lookups */
315 /*-----------------------------------------------------*/
316
317 FUNCTION Valid_Inst_Usage_Code
318 (
319 p_inst_usage_code IN VARCHAR2,
320 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
321 )
322 RETURN BOOLEAN;
323
324 /*----------------------------------------------------*/
325 /* This function checks for the active start date */
326 /* by looking through the CSI Instances table */
327 /*----------------------------------------------------*/
328
329 FUNCTION Is_StartDate_Valid
330 ( p_start_date IN DATE,
331 p_end_date IN DATE,
332 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
333 ) RETURN BOOLEAN;
334
335 /*----------------------------------------------------*/
336 /* This function checks for the active start date */
337 /* by looking through the CSI Instances table */
338 /*----------------------------------------------------*/
339
340 FUNCTION Is_EndDate_Valid
341 (
342 p_start_date IN DATE,
343 p_end_date IN DATE,
344 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
345 ) RETURN BOOLEAN;
346
347 /*----------------------------------------------------*/
348 /* This function checks for the location type code */
349 /* by looking through the CSI lookups */
350 /*----------------------------------------------------*/
351
352 FUNCTION Is_Valid_Location_Source
353 (
354 p_loc_source_table IN VARCHAR2,
355 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
356 )
357 RETURN BOOLEAN;
358
359 /*-----------------------------------------------------*/
360 /* This procedure is used to validate the values */
361 /* passed to the update_item_instance */
362 /*-----------------------------------------------------*/
363
364 PROCEDURE get_merge_rec
365 (
366 p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
367 l_curr_instance_rec IN csi_datastructures_pub.instance_rec,
368 l_get_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
369 );
370
371 /*----------------------------------------------------*/
372 /* Function Name : Get_instance_id */
373 /* */
374 /* Description : This function generates */
375 /* instance_ids using a sequence */
376 /*----------------------------------------------------*/
377
378 FUNCTION Get_instance_id
379 ( p_stack_err_msg IN BOOLEAN DEFAULT TRUE
380 )
381 RETURN NUMBER;
382
383 /*----------------------------------------------------*/
384 /* Function Name : get_cis_item_instance_h_id */
385 /* */
386 /* Description : This function generates */
387 /* cis_item_instance_h_id using a seq.*/
388 /*----------------------------------------------------*/
389
390 FUNCTION get_csi_item_instance_h_id
391 ( p_stack_err_msg IN BOOLEAN DEFAULT TRUE
392 )
393 RETURN NUMBER;
394
395 /*----------------------------------------------------*/
396 /* Procedure name: Is_Instance_creation_complete */
397 /* Description : Check if the instance creation is */
398 /* complete */
399 /*----------------------------------------------------*/
400
401 FUNCTION Is_Inst_creation_complete
402 ( p_instance_id IN NUMBER,
403 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
404 ) RETURN BOOLEAN;
405
406 /*----------------------------------------------------*/
407 /* Procedure name: Is_Instance_parent */
408 /* Description : Check for the parent in csi rel's */
409 /* */
410 /*----------------------------------------------------*/
411
412 FUNCTION Instance_has_Parent
413 ( p_instance_id IN NUMBER,
414 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
415 ) RETURN BOOLEAN;
416
417 /*----------------------------------------------------*/
418 /* This function verifies that the item serial number */
419 /* is valid by looking into the mtl serial #s table */
420 /*----------------------------------------------------*/
421
422 PROCEDURE Validate_srl_num_for_Inst_Upd
423 (
424 p_inv_org_id IN NUMBER,
425 p_inv_item_id IN NUMBER,
426 p_serial_number IN VARCHAR2,
427 P_mfg_serial_number_flag IN VARCHAR2,
428 p_txn_rec IN csi_datastructures_pub.transaction_rec,
429 p_location_type_code IN VARCHAR2, -- Added by sk on 09/13/01
430 p_srl_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431 p_instance_usage_code IN VARCHAR2,
432 p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
433 l_return_value IN OUT NOCOPY BOOLEAN
434 );
435
436 /*----------------------------------------------------*/
437 /* This function verifies that the quantity is not<0 */
438 /* and also checks for serialized items */
439 /*----------------------------------------------------*/
440 /*
441 FUNCTION Update_Quantity
442 (
443 p_instance_id IN NUMBER ,
444 p_inv_organization_id IN NUMBER ,
445 p_quantity IN NUMBER ,
449 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
446 --p_serial_number IN VARCHAR2,
447 p_serial_control_code IN NUMBER ,
448 p_location_type_code IN VARCHAR2,
450 )
451 RETURN BOOLEAN;
452 */
453 /*----------------------------------------------------*/
454 /* This Procedure validates the accounting class code*/
455 /* */
456 /*----------------------------------------------------*/
457
458 PROCEDURE get_valid_acct_class
459 ( p_instance_id IN NUMBER
460 ,p_curr_acct_class_code IN VARCHAR2
461 ,p_loc_type_code IN VARCHAR2
462 ,x_acct_class_code OUT NOCOPY VARCHAR2
463 );
464
465 /*----------------------------------------------------*/
466 /* Validates the item instance ID */
467 /*----------------------------------------------------*/
468
469 FUNCTION Is_InstanceID_Valid
470 (
471 p_instance_id IN NUMBER,
472 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
473 ) RETURN BOOLEAN;
474
475 /*----------------------------------------------------*/
476 /* This function checks for the active end date */
477 /* by looking through the CSI Instances table */
478 /*----------------------------------------------------*/
479
480 FUNCTION EndDate_Valid
481 (
482 p_start_date IN DATE,
483 p_end_date IN DATE,
484 p_instance_id IN NUMBER,
485 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
486 ) RETURN BOOLEAN;
487
488 /*----------------------------------------------------*/
489 /* This function checks for the uniqueness of */
490 /* the party owner */
491 /*----------------------------------------------------*/
492
493 FUNCTION validate_uniqueness
494 ( p_instance_rec csi_datastructures_pub.instance_rec,
495 p_party_rec csi_datastructures_pub.party_rec,
496 p_srl_control_code NUMBER DEFAULT FND_API.G_MISS_NUM,
497 p_csi_txn_type_id NUMBER DEFAULT FND_API.G_MISS_NUM
498 )
499 RETURN BOOLEAN;
500
501 /*----------------------------------------------------*/
502 /* Validates the item instance ID */
503 /* Used exclusively by copy item instance */
504 /*----------------------------------------------------*/
505
506 FUNCTION Val_and_get_inst_rec
507 (
508 p_item_instance_id IN NUMBER,
509 p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
510 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
511 )
512 RETURN BOOLEAN;
513
514 /*----------------------------------------------------*/
515 /* Function : To get extended attrib level */
516 /* Used exclusively by copy item instance */
517 /*----------------------------------------------------*/
518
519
520 FUNCTION get_ext_attrib_level
521 ( p_ATTRIBUTE_ID IN NUMBER,
522 p_ATTRIBUTE_LEVEL OUT NOCOPY VARCHAR2,
523 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
524 ) RETURN BOOLEAN;
525
526 /*----------------------------------------------------*/
527 /* Function : val_bom_org */
528 /* Function : To validate item and org */
529 /*----------------------------------------------------*/
530
531 FUNCTION val_item_org
532 ( p_INVENTORY_ITEM_ID IN NUMBER,
533 p_ORGANIZATION_ID IN VARCHAR2,
534 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
535 ) RETURN BOOLEAN;
536
537 /*-----------------------------------------------------*/
538 /* Function : val_bom_org */
539 /* To validate bom and org */
540 /*-----------------------------------------------------*/
541
542 FUNCTION val_bom_org
543 ( p_INVENTORY_ITEM_ID IN NUMBER,
544 p_ORGANIZATION_ID IN VARCHAR2,
545 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
546 ) RETURN BOOLEAN;
547
548
549 /*-----------------------------------------------------*/
550 /* Function : val_inst_ter_flag */
551 /* To validate instances with statuses */
552 /* having termination_flag set to 'Y' */
553 /* has a end_date */
554 /*-----------------------------------------------------*/
555
556 FUNCTION val_inst_ter_flag
557 ( p_status_id IN NUMBER,
558 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
559 ) RETURN BOOLEAN;
560
561 /*-----------------------------------------------------*/
562 /* Function : Is_config_exploded */
563 /* To check if the configuration for */
564 /* the item has been exploded ever */
565 /* before in Istalled Base */
566 /*-----------------------------------------------------*/
567
568 FUNCTION Is_config_exploded
569 ( p_instance_id IN NUMBER,
570 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
571 ) RETURN BOOLEAN;
572
573
574 /*-----------------------------------------------------------*/
575 /* Procedure name: Is_EndDate_Valid */
579
576 /* Description : Check if version labels active end date */
577 /* is valid */
578 /*-----------------------------------------------------------*/
580 FUNCTION Is_Ver_EndDate_Valid
581 (
582 p_start_date IN DATE,
583 p_end_date IN DATE,
584 p_instance_id IN NUMBER,
585 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
586 ) RETURN BOOLEAN;
587 --
588 /*-----------------------------------------------------------*/
589 /* Function name: Is_Valid_Location_ID */
590 /* Description : Check if the Location_ID and Location_Type */
591 /* are valid */
592 /*-----------------------------------------------------------*/
593 FUNCTION Is_Valid_Location_ID
594 (
595 p_location_source_table IN VARCHAR2,
596 p_location_id IN NUMBER
597 ) RETURN BOOLEAN;
598 --
599 /*-----------------------------------------------------------*/
600 /* Function name: Validate_Related_Loc_Params */
601 /* Description : Check the Related Location Parameters for */
602 /* the give Location Type code and Location ID */
603 /*-----------------------------------------------------------*/
604 FUNCTION Validate_Related_Loc_Params
605 (
606 p_location_source_table IN VARCHAR2,
607 p_location_id IN NUMBER,
608 p_organization_id IN NUMBER,
609 p_subinventory IN VARCHAR2,
610 p_locator_id IN NUMBER,
611 p_project_id IN NUMBER,
612 p_task_id IN NUMBER,
613 p_sales_ord_line_id IN NUMBER,
614 p_wip_job_id IN NUMBER,
615 p_po_line_id IN NUMBER,
616 p_inst_usage_code IN VARCHAR2
617 ) RETURN BOOLEAN;
618
619 -- Added by sguthiva for att enhancements
620
621 /*-----------------------------------------------------------*/
622 /* Procedure name: get_link_locations */
623 /* Description : Retreive the Location Parameters from */
624 /* associated instances of an instance of */
625 /* instance item class link */
626 /*-----------------------------------------------------------*/
627 PROCEDURE get_link_locations
628 (p_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl,
629 x_return_status OUT NOCOPY VARCHAR2
630 );
631
632 /*-----------------------------------------------------------*/
633 /* Procedure name: Call_batch_validate */
634 /* Description : Call the batch validate */
635 /*-----------------------------------------------------------*/
636 PROCEDURE Call_batch_validate
637 ( p_instance_rec IN csi_datastructures_pub.instance_rec
638 ,p_config_hdr_id IN NUMBER
639 ,p_config_rev_nbr IN NUMBER
640 ,x_config_hdr_id OUT NOCOPY NUMBER
641 ,x_config_rev_nbr OUT NOCOPY NUMBER
642 ,x_return_status OUT NOCOPY VARCHAR2);
643
644 /*-----------------------------------------------------------*/
645 /* Procedure name: Create_hdr_xml */
646 /* Description : Build xml message to pass it to cz api */
647 /*-----------------------------------------------------------*/
648
649 PROCEDURE Create_hdr_xml
650 ( p_config_hdr_id IN NUMBER
651 , p_config_rev_nbr IN NUMBER
652 , p_config_inst_hdr_id IN NUMBER
653 , x_xml_hdr OUT NOCOPY VARCHAR2 -- this needs to be passed to Send_input_xml
654 , x_return_status OUT NOCOPY VARCHAR2 );
655
656 /*-----------------------------------------------------------*/
657 /* Procedure name: Send_input_xml */
658 /* Description : Make the actual call to cz api */
659 /*-----------------------------------------------------------*/
660 PROCEDURE Send_input_xml
661 ( p_xml_hdr IN VARCHAR2 -- Value passed from Create_hdr_xml
662 , x_out_xml_msg OUT NOCOPY LONG
663 , x_return_status OUT NOCOPY VARCHAR2);
664
665 PROCEDURE Parse_output_xml
666 ( p_xml IN LONG
667 ,x_config_hdr_id OUT NOCOPY NUMBER
668 ,x_config_rev_nbr OUT NOCOPY NUMBER
669 ,x_return_status OUT NOCOPY VARCHAR2 );
670 -- End addition by sguthiva for att enhancements
671
672 /*-----------------------------------------------------------*/
673 /* Procedure name: Is_Ver_StartDate_Valid */
674 /* Description : Check if Version Label's active start */
675 /* date is valid */
676 /*-----------------------------------------------------------*/
677
678 FUNCTION Is_Ver_StartDate_Valid
679 ( p_start_date IN DATE,
680 p_end_date IN DATE,
681 p_instance_id IN NUMBER,
682 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
683 ) RETURN BOOLEAN;
684 --
685 /*-----------------------------------------------------------*/
686 /* Procedure name: Check_Prior_Txn */
687 /* Description : Check if there is any transactions pending */
688 /* this Item Instance prior to the current Txn */
692 ( p_instance_rec IN csi_datastructures_pub.instance_rec
689 /*-----------------------------------------------------------*/
690
691 PROCEDURE Check_Prior_Txn
693 ,p_txn_rec IN csi_datastructures_pub.transaction_rec
694 ,p_prior_txn_id OUT NOCOPY NUMBER
695 ,p_mode IN VARCHAR2
696 ,x_return_status OUT NOCOPY VARCHAR2
697 );
698 --
699 /*-----------------------------------------------------------*/
700 /* Procedure name: Is_Forward_Synch */
701 /* Description : Check if for the instance, forward synch is */
702 /* not done after error correction. */
703 /*-----------------------------------------------------------*/
704
705 FUNCTION Is_Forward_Synch
706 ( p_instance_id IN NUMBER,
707 p_stop_all_txn IN VARCHAR2,
708 p_mtl_txn_id IN NUMBER )
709 RETURN BOOLEAN;
710 --
711 /*-----------------------------------------------------------*/
712 /* Function name: Is_Valid_Master_Org */
713 /* Description : Check validity of the Master Organization */
714 /*-----------------------------------------------------------*/
715
716 FUNCTION Is_Valid_Master_Org
717 ( p_master_org_id IN NUMBER )
718 RETURN BOOLEAN;
719 --
720
721 /*-----------------------------------------------------------*/
722 /* Function name: Check_for_eam_item */
723 /* Description : Check for eam item */
724 /*-----------------------------------------------------------*/
725 FUNCTION Check_for_eam_item
726 (p_inventory_item_id IN NUMBER,
727 p_organization_id IN NUMBER,
728 p_eam_item_type IN NUMBER DEFAULT FND_API.G_MISS_NUM
729 )
730 RETURN BOOLEAN;
731
732 PROCEDURE validate_serial_for_upd(
733 p_instance_rec IN csi_datastructures_pub.instance_rec,
734 p_txn_rec IN csi_datastructures_pub.transaction_rec,
735 p_old_serial_number IN varchar2,
736 x_return_status OUT nocopy varchar2);
737
738 /*---------------------------------------------------------*/
739 /* This function checks for the operational status code */
740 /* by looking through the CSI lookups */
741 /*---------------------------------------------------------*/
742
743 FUNCTION Valid_operational_status
744 (
745 p_operational_status IN VARCHAR2
746 )
747 RETURN BOOLEAN;
748
749 /*---------------------------------------------------------*/
750 /* This function checks for the currency code */
751 /* by looking through the fnd_currencies */
752 /*---------------------------------------------------------*/
753 FUNCTION Valid_currency_code
754 (
755 p_currency_code IN VARCHAR2
756 )
757 RETURN BOOLEAN;
758
759 /*---------------------------------------------------------*/
760 /* This function checks if status is updateable */
761 /* by looking through the csi_instance_statuses */
762 /*---------------------------------------------------------*/
763 FUNCTION is_status_updateable
764 (
765 p_instance_status IN NUMBER,
766 p_current_status IN NUMBER
767 )
768 RETURN BOOLEAN;
769 --
770 /*-----------------------------------------------------------*/
771 /* This function gets the version label of an item instance */
772 /* based on the time stamp passed. */
773 /*---------------------------------------------------------*/
774 FUNCTION Get_Version_label
775 (
776 p_instance_id IN NUMBER,
777 p_time_stamp IN DATE
778 )
779 RETURN VARCHAR2;
780 --
781
782 PROCEDURE get_mtl_txn_for_srl
783 (
784 p_inventory_item_id IN number,
785 p_serial_number IN varchar2,
786 x_mtl_txn_tbl OUT nocopy csi_datastructures_pub.mtl_txn_tbl
787 );
788
789
790 END csi_Item_Instance_Vld_pvt;