[Home] [Help]
PACKAGE: APPS.AHL_FMP_COMMON_PVT
Source
1 PACKAGE AHL_FMP_COMMON_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVFCMS.pls 120.3.12020000.2 2012/12/14 08:54:53 shnatu ship $ */
3
4 -- Start of Comments
5 -- Procedure name : validate_lookup
6 -- Type : Private
7 -- Pre-reqs :
8 -- Function :
9 -- Parameters :
10 --
11 -- Standard IN Parameters :
12 -- None
13 --
14 -- Standard OUT Parameters :
15 -- x_return_status VARCHAR2 Required
16 -- x_msg_data VARCHAR2 Required
17 --
18 -- validate_lookup IN parameters:
19 -- p_lookup_type VARCHAR2 Required
20 -- p_lookup_meaning VARCHAR2 Default NULL
21 --
22 -- validate_lookup IN OUT parameters:
23 -- p_x_lookup_code VARCHAR2
24 --
25 -- validate_lookup OUT parameters:
26 -- None.
27 --
28 --
29 -- Version :
30 -- Current version 1.0
31 --
32 -- End of Comments
33
34 PROCEDURE validate_lookup
35 (
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
39 p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
40 p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
41 );
42
43 -- Start of Comments
44 -- Procedure name : validate_item
45 -- Type : Private
46 -- Pre-reqs :
47 -- Function :
48 -- Parameters :
49 --
50 -- Standard IN Parameters :
51 -- None
52 --
53 -- Standard OUT Parameters :
54 -- x_return_status VARCHAR2 Required
55 -- x_msg_data VARCHAR2 Required
56 --
57 -- validate_item IN parameters:
58 -- p_item_number VARCHAR2 Default NULL
59 --
60 -- validate_item IN OUT parameters:
61 -- p_x_inventory_item_id NUMBER
62 --
63 -- validate_item OUT parameters:
64 -- None.
65 --
66 --
67 -- Version :
68 -- Current version 1.0
69 --
70 -- End of Comments
71
72 PROCEDURE validate_item
73 (
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
77 p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
78 );
79
80 -- Start of Comments
81 -- Procedure name : validate_pc_node
82 -- Type : Private
83 -- Pre-reqs :
84 -- Function :
85 -- Parameters :
86 --
87 -- Standard IN Parameters :
88 -- None
89 --
90 -- Standard OUT Parameters :
91 -- x_return_status VARCHAR2 Required
92 -- x_msg_data VARCHAR2 Required
93 --
94 -- validate_pc_node IN parameters:
95 -- p_pc_node_name VARCHAR2 Default NULL
96 --
97 -- validate_pc_node IN OUT parameters:
98 -- p_x_pc_node_id NUMBER
99 --
100 -- validate_pc_node OUT parameters:
101 -- None.
102 --
103 --
104 -- Version :
105 -- Current version 1.0
106 --
107 -- End of Comments
108
109 PROCEDURE validate_pc_node
110 (
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_pc_node_name IN VARCHAR2 := NULL,
114 p_x_pc_node_id IN OUT NOCOPY NUMBER
115 );
116
117 -- Start of Comments
118 -- Procedure name : validate_position
119 -- Type : Private
120 -- Pre-reqs :
121 -- Function :
122 -- Parameters :
123 --
124 -- Standard IN Parameters :
125 -- None
126 --
127 -- Standard OUT Parameters :
128 -- x_return_status VARCHAR2 Required
129 -- x_msg_data VARCHAR2 Required
130 --
131 -- validate_position IN parameters:
132 -- p_position_ref_meaning VARCHAR2 Default NULL
133 --
134 -- validate_position IN OUT parameters:
135 -- p_x_relationship_id NUMBER
136 --
137 -- validate_position OUT parameters:
138 -- None.
139 --
140 --
141 -- Version :
142 -- Current version 1.0
143 --
144 -- End of Comments
145
146 PROCEDURE validate_position
147 (
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_position_ref_meaning IN VARCHAR2 := NULL,
151 p_x_relationship_id IN OUT NOCOPY NUMBER
152 );
153
154 -- Start of Comments
155 -- Procedure name : validate_position_item
156 -- Type : Private
157 -- Pre-reqs :
158 -- Function :
159 -- Parameters :
160 --
161 -- Standard IN Parameters :
162 -- None
163 --
164 -- Standard OUT Parameters :
165 -- x_return_status VARCHAR2 Required
166 -- x_msg_data VARCHAR2 Required
167 --
168 -- validate_position_item IN parameters:
169 -- p_relationship_id NUMBER Required
170 -- p_inventory_item_id NUMBER Required
171 --
172 -- validate_position_item IN OUT parameters:
173 -- None.
174 --
175 -- validate_position OUT parameters:
176 -- None.
177 --
178 --
179 -- Version :
180 -- Current version 1.0
181 --
182 -- End of Comments
183
184 PROCEDURE validate_position_item
185 (
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_inventory_item_id IN NUMBER,
189 p_relationship_id IN NUMBER
190 );
191
192 -- Start of Comments
193 -- Procedure name : validate_counter_template
194 -- Type : Private
195 -- Pre-reqs :
196 -- Function :
197 -- Parameters :
198 --
199 -- Standard IN Parameters :
200 -- None
201 --
202 -- Standard OUT Parameters :
203 -- x_return_status VARCHAR2 Required
204 -- x_msg_data VARCHAR2 Required
205 --
206 -- validate_counter_template IN parameters:
207 -- p_inventory_item_id NUMBER Default NULL
208 -- p_relationship_id NUMBER Default NULL
209 -- p_counter_name VARCHAR2 Default NULL
210 --
211 -- validate_counter_template IN OUT parameters:
212 -- p_x_counter_id NUMBER
213 --
214 -- validate_counter_template OUT parameters:
215 -- None.
216 --
217 --
218 -- Version :
219 -- Current version 1.0
220 --
221 -- End of Comments
222
223 PROCEDURE validate_counter_template
224 (
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_inventory_item_id IN NUMBER := NULL,
228 p_relationship_id IN NUMBER := NULL,
229 p_counter_name IN VARCHAR2 := NULL,
230 p_x_counter_id IN OUT NOCOPY NUMBER
231 );
232
233 -- Start of Comments
234 -- Procedure name : validate_country
235 -- Type : Private
236 -- Pre-reqs :
237 -- Function :
238 -- Parameters :
239 --
240 -- Standard IN Parameters :
241 -- None
242 --
243 -- Standard OUT Parameters :
244 -- x_return_status VARCHAR2 Required
245 -- x_msg_data VARCHAR2 Required
246 --
247 -- validate_country IN parameters:
248 -- p_country_name VARCHAR2 Default NULL
249 --
250 -- validate_country IN OUT parameters:
251 -- p_x_country_code VARCHAR2
252 --
253 -- validate_country OUT parameters:
254 -- None.
255 --
256 --
257 -- Version :
258 -- Current version 1.0
259 --
260 -- End of Comments
261
262 PROCEDURE validate_country
263 (
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_data OUT NOCOPY VARCHAR2,
266 p_country_name IN VARCHAR2 := NULL,
267 p_x_country_code IN OUT NOCOPY VARCHAR2
268 );
269
270 -- Start of Comments
271 -- Procedure name : validate_manufacturer
272 -- Type : Private
273 -- Pre-reqs :
274 -- Function :
275 -- Parameters :
276 --
277 -- Standard IN Parameters :
278 -- None
279 --
280 -- Standard OUT Parameters :
281 -- x_return_status VARCHAR2 Required
282 -- x_msg_data VARCHAR2 Required
283 --
284 -- validate_manufacturer IN parameters:
285 -- p_inventory_item_id NUMBER Default NULL
286 -- p_relationship_id NUMBER Default NULL
287 -- p_manufacturer_name VARCHAR2 Default NULL
288 --
289 -- validate_manufacturer IN OUT parameters:
290 -- p_x_manufacturer_id NUMBER
291 --
292 -- validate_manufacturer OUT parameters:
293 -- None.
294 --
295 --
296 -- Version :
297 -- Current version 1.0
298 --
299 -- End of Comments
300
301 PROCEDURE validate_manufacturer
302 (
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_data OUT NOCOPY VARCHAR2,
305 p_inventory_item_id IN NUMBER := NULL,
306 p_relationship_id IN NUMBER := NULL,
307 p_manufacturer_name IN VARCHAR2 := NULL,
308 p_x_manufacturer_id IN OUT NOCOPY NUMBER
309 );
310
311 -- Start of Comments
312 -- Procedure name : validate_serial_numbers_range
313 -- Type : Private
314 -- Pre-reqs :
315 -- Function :
316 -- Parameters :
317 --
318 -- Standard IN Parameters :
319 -- None
320 --
321 -- Standard OUT Parameters :
322 -- x_return_status VARCHAR2 Required
323 -- x_msg_data VARCHAR2 Required
324 --
325 -- validate_manufacturer IN parameters:
326 -- p_serial_number_from VARCHAR2 Required
327 -- p_serial_number_to VARCHAR2 Required
328 --
329 -- validate_serial_numbers_range IN OUT parameters:
330 -- None.
331 --
332 -- validate_serial_numbers_range OUT parameters:
333 -- None.
334 --
335 --
336 -- Version :
337 -- Current version 1.0
338 --
339 -- End of Comments
340
341 PROCEDURE validate_serial_numbers_range
342 (
343 x_return_status OUT NOCOPY VARCHAR2,
344 x_msg_data OUT NOCOPY VARCHAR2,
345 p_serial_number_from IN VARCHAR2,
346 p_serial_number_to IN VARCHAR2
347 );
348
349 -- Start of Comments
350 -- Procedure name : validate_mr_status
351 -- Type : Private
352 -- Pre-reqs :
353 -- Function :
354 -- Parameters :
355 --
356 -- Standard IN Parameters :
357 -- None
358 --
359 -- Standard OUT Parameters :
360 -- x_return_status VARCHAR2 Required
361 -- x_msg_data VARCHAR2 Required
362 --
363 -- validate_mr_status IN parameters:
364 -- p_mr_header_id NUMBER Required
365 --
366 -- validate_mr_status IN OUT parameters:
367 -- None.
368 --
369 -- validate_mr_status OUT parameters:
370 -- None.
371 --
372 --
373 -- Version :
374 -- Current version 1.0
375 --
376 -- End of Comments
377
378 PROCEDURE validate_mr_status
379 (
380 x_return_status OUT NOCOPY VARCHAR2,
381 x_msg_data OUT NOCOPY VARCHAR2,
382 p_mr_header_id IN NUMBER
383 );
384
385 -- Start of Comments
386 -- Procedure name : validate_mr_effectivity
387 -- Type : Private
388 -- Pre-reqs :
389 -- Function :
390 -- Parameters :
391 --
392 -- Standard IN Parameters :
393 -- None
394 --
395 -- Standard OUT Parameters :
396 -- x_return_status VARCHAR2 Required
397 -- x_msg_data VARCHAR2 Required
398 --
399 -- validate_mr_effectivity IN parameters:
400 -- p_mr_effectivity_id NUMBER Required
401 -- p_object_version_number NUMBER Default NULL
402 --
403 -- validate_mr_effectivity IN OUT parameters:
404 -- None.
405 --
406 -- validate_mr_effectivity OUT parameters:
407 -- None.
408 --
409 --
410 -- Version :
411 -- Current version 1.0
412 --
413 -- End of Comments
414
415 PROCEDURE validate_mr_effectivity
416 (
417 x_return_status OUT NOCOPY VARCHAR2,
418 x_msg_data OUT NOCOPY VARCHAR2,
419 p_mr_effectivity_id IN NUMBER,
420 p_object_version_number IN NUMBER := NULL
421 );
422
423 -- Start of Comments
424 -- Procedure name : validate_mr_threshold
425 -- Type : Private
426 -- Pre-reqs :
427 -- Function :
428 -- Parameters :
429 --
430 -- Standard IN Parameters :
431 -- None
432 --
433 -- Standard OUT Parameters :
434 -- x_return_status VARCHAR2 Required
435 -- x_msg_data VARCHAR2 Required
436 --
437 -- validate_mr_threshold IN parameters:
438 -- p_mr_header_id NUMBER Required
439 -- p_repetitive_flag VARCHAR2 Required
440 --
441 -- validate_mr_threshold IN OUT parameters:
442 -- None.
443 --
444 -- validate_mr_threshold OUT parameters:
445 -- None.
446 --
447 --
448 -- Version :
449 -- Current version 1.0
450 --
451 -- End of Comments
452
453 PROCEDURE validate_mr_interval_threshold
454 (
455 x_return_status OUT NOCOPY VARCHAR2,
456 x_msg_data OUT NOCOPY VARCHAR2,
457 p_mr_header_id IN NUMBER,
458 p_repetitive_flag IN VARCHAR2
459 );
460
461
462 ----------------------------------------------------------
463 -- Procedure to populate the AHL_APPLICABLE_MRS temporary --
464 -- table with the results of AHL_FMP_PUB.GET_APPLICABLE_MRS--
465 -- API.
466 -----------------------------------------------------------
467 PROCEDURE Populate_Appl_MRs
468 (
469 p_csi_ii_id IN NUMBER,
470 p_include_doNotImplmt IN VARCHAR2 := 'Y',
471 p_show_dependent_components IN VARCHAR2 := 'Y', -- BUG 9169406
472 -- JKJain, NR Analysis and Forecasting
473 p_consider_fleet_flag IN VARCHAR2 := 'N',
474 p_flt_range_calc_date IN DATE := sysdate ,
475 x_return_status OUT NOCOPY VARCHAR2,
476 x_msg_count OUT NOCOPY NUMBER,
477 x_msg_data OUT NOCOPY VARCHAR2
478 );
479
480 -- Start of Comments
481 -- Procedure name : Mr_Title_Version_To_Id
482 -- Type : Private
483 -- Pre-reqs :
484 -- Function :
485 -- Parameters :
486 --
487 -- Standard IN Parameters :
488 -- None
489 --
490 -- Standard OUT Parameters :
491 -- x_return_status VARCHAR2 Required
492 --
493 -- mr_title_version_to_id IN parameters:
494 -- p_mr_title IN VARCHAR2 Required
495 -- p_mr_version_number IN NUMBER Required
496 --
497 -- mr_title_version_to_id IN OUT parameters:
498 -- None.
499 --
500 -- mr_title_version_to_id OUT parameters:
501 -- x_mr_header_id OUT NOCOPY NUMBER
502 --
503 -- Version :
504 -- Current version 1.0
505 --
506 -- End of Comments
507
508 PROCEDURE Mr_Title_Version_To_Id
509 (
510 p_mr_title IN VARCHAR2,
511 p_mr_version_number IN NUMBER,
512 x_mr_header_id OUT NOCOPY NUMBER,
513 x_return_status OUT NOCOPY VARCHAR2
514 );
515
516 -- Start of Comments
517 -- Procedure name : Mr_Effectivity_Name_To_Id
518 -- Type : Private
519 -- Pre-reqs :
520 -- Function :
521 -- Parameters :
522 --
523 -- Standard IN Parameters :
524 -- None
525 --
526 -- Standard OUT Parameters :
527 -- x_return_status VARCHAR2 Required
528 --
529 -- mr_title_version_to_id IN parameters:
530 -- p_mr_header_id NUMBER Required
531 -- p_mr_effectivity_name VARCHAR2 Required
532 --
533 -- mr_title_version_to_id IN OUT parameters:
534 -- None.
535 --
536 -- mr_title_version_to_id OUT parameters:
537 -- x_mr_effectivity_id NUMBER Required
538
539 --
540 -- Version :
541 -- Current version 1.0
542 --
543 -- End of Comments
544
545 PROCEDURE Mr_Effectivity_Name_To_Id
546 (
547 p_mr_header_id IN NUMBER,
548 p_mr_effectivity_name IN VARCHAR2,
549 x_mr_effectivity_id OUT NOCOPY NUMBER,
550 x_return_status OUT NOCOPY VARCHAR2
551 );
552
553
554 -- Start of Comments
555 -- Procedure name :
556 -- Type : Private
557 -- Pre-reqs :
558 -- Function : check_mr_type
559 -- Parameters :
560 --
561 -- Standard IN Parameters :
562 -- None
563 --
564 --
565 -- check_mr_type IN parameters:
566 -- p_mr_header_id NUMBER Required
567 --
568 --
569 -- Version :
570 -- Current version 1.0
571 --
572 -- End of Comments
573
574
575 function check_mr_type( p_mr_header_id IN NUMBER ) return varchar2;
576
577
578 -- Start of Comments
579 -- Procedure name :
580 -- Type : Private
581 -- Pre-reqs :
582 -- Function : check_mr_status
583 -- Parameters :
584 --
585 -- Standard IN Parameters :
586 -- None
587 --
588 --
589 -- check_mr_type IN parameters:
590 -- p_mr_header_id NUMBER Required
591 --
592 --
593 -- Version :
594 -- Current version 1.0
595 --
596 -- End of Comments
597
598
599 function check_mr_status( p_mr_header_id IN NUMBER ) return varchar2;
600
601 -- Start of Comments
602 -- Procedure name : validate_mr_type_program
603 -- Type : Private
604 -- Pre-reqs :
605 -- Function :
606 -- Parameters :
607 --
608 -- Standard IN Parameters :
609 -- None
610 --
611 -- Standard OUT Parameters :
612 -- x_return_status VARCHAR2 Required
613 -- x_msg_data VARCHAR2 Required
614 --
615 -- validate_mr_status IN parameters:
616 -- p_effectivity_id NUMBER Required
617 -- p_eff_obj_version NUMBER Required
618 -- p_mr_header_id NUMBER Required
619 -- validate_mr_status IN OUT parameters:
620 -- None.
621 --
622 -- validate_mr_status OUT parameters:
623 -- None.
624 --
625 --
626 -- Version :
627 -- Current version 1.0
628 --
629 -- End of Comments
630
631
632 PROCEDURE validate_mr_type_program
633 (
634 x_return_status OUT NOCOPY VARCHAR2,
635 x_msg_data OUT NOCOPY VARCHAR2,
636 p_mr_header_id IN NUMBER,
637 p_effectivity_id IN NUMBER,
638 p_eff_obj_version IN NUMBER
639 );
640
641 -- Start of Comments
642 -- Procedure name : validate_mr_type_activity
643 -- Type : Private
644 -- Pre-reqs :
645 -- Function :
646 -- Parameters :
647 --
648 -- Standard IN Parameters :
649 -- None
650 --
651 -- Standard OUT Parameters :
652 -- x_return_status VARCHAR2 Required
653 -- x_msg_data VARCHAR2 Required
654 --
655 -- validate_mr_status IN parameters:
656 -- p_effectivity_id NUMBER Required
657 -- p_eff_obj_version NUMBER Required
658 -- validate_mr_status IN OUT parameters:
659 -- None.
660 --
661 -- validate_mr_status OUT parameters:
662 -- None.
663 --
664 --
665 -- Version :
666 -- Current version 1.0
667 --
668 -- End of Comments
669
670 PROCEDURE validate_mr_type_activity
671 (
672 x_return_status OUT NOCOPY VARCHAR2,
673 x_msg_data OUT NOCOPY VARCHAR2,
674 p_effectivity_id IN NUMBER,
675 p_eff_obj_version IN NUMBER
676 );
677
678 -- Start of Comments
679 -- Procedure name : validate_mr_pm_status
680 -- Type : Private
681 -- Pre-reqs :
682 -- Function :
683 -- Parameters :
684 --
685 -- Standard IN Parameters :
686 -- None
687 --
688 -- Standard OUT Parameters :
689 -- x_return_status VARCHAR2 Required
690 -- x_msg_data VARCHAR2 Required
691 --
692 -- validate_mr_status IN parameters:
693 -- p_mr_header_id NUMBER Required
694 --
695 -- validate_mr_status IN OUT parameters:
696 -- None.
697 --
698 -- validate_mr_status OUT parameters:
699 -- None.
700 --
701 --
702 -- Version :
703 -- Current version 1.0
704 --
705 -- End of Comments
706
707 PROCEDURE validate_mr_pm_status
708 (
709 x_return_status OUT NOCOPY VARCHAR2,
710 x_msg_data OUT NOCOPY VARCHAR2,
711 p_mr_header_id IN NUMBER
712 );
713
714 -- Start of Comments
715 -- Procedure name : validate_owner
716 -- Type : Private
717 -- Pre-reqs :
718 -- Function :
719 -- Parameters :
720 --
721 -- Standard IN Parameters :
722 -- None
723 --
724 -- Standard OUT Parameters :
725 -- x_return_status VARCHAR2 Required
726 -- x_msg_data VARCHAR2 Required
727 --
728 -- validate_owner IN parameters:
729 -- p_inventory_item_id NUMBER Default NULL
730 -- p_relationship_id NUMBER Default NULL
731 -- p_owner VARCHAR2 Default NULL
732 --
733 -- validate_manufacturer IN OUT parameters:
734 -- p_x_owner_id NUMBER
735 --
736 -- validate_manufacturer OUT parameters:
737 -- None.
738 --
739 --
740 -- Version :
741 -- Current version 1.0
742 --
743 -- End of Comments
744
745 PROCEDURE validate_owner
746 (
747 x_return_status OUT NOCOPY VARCHAR2,
748 x_msg_data OUT NOCOPY VARCHAR2,
749 p_owner IN VARCHAR2 := NULL,
750 p_x_owner_id IN OUT NOCOPY NUMBER
751 );
752
753 -- Start of Comments
754 -- Procedure name : validate_location
755 -- Type : Private
756 -- Pre-reqs :
757 -- Function :
758 -- Parameters :
759 --
760 -- Standard IN Parameters :
761 -- None
762 --
763 -- Standard OUT Parameters :
764 -- x_return_status VARCHAR2 Required
765 -- x_msg_data VARCHAR2 Required
766 --
767 -- validate_country IN parameters:
768 -- p_location VARCHAR2 Default NULL
769 --
770 -- validate_location IN OUT parameters:
771 -- p_x_location_type_code VARCHAR2
772 --
773 -- validate_country OUT parameters:
774 -- None.
775 --
776 --
777 -- Version :
778 -- Current version 1.0
779 --
780 -- End of Comments
781
782 PROCEDURE validate_location
783 (
784 x_return_status OUT NOCOPY VARCHAR2,
785 x_msg_data OUT NOCOPY VARCHAR2,
786 p_location IN VARCHAR2 := NULL,
787 p_x_location_type_code IN OUT NOCOPY VARCHAR2
788 );
789
790 -- Start of Comments
791 -- Procedure name : validate_csi_ext_attribute
792 -- Type : Private
793 -- Pre-reqs :
794 -- Function :
795 -- Parameters :
796 --
797 -- Standard IN Parameters :
798 -- None
799 --
800 -- Standard OUT Parameters :
801 -- x_return_status VARCHAR2 Required
802 -- x_msg_data VARCHAR2 Required
803 --
804 -- validate_country IN parameters:
805 -- p_csi_attribute_name VARCHAR2 Default NULL
806 --
807 -- validate_country IN OUT parameters:
808 -- p_x_csi_attribute_code VARCHAR2
809 --
810 -- validate_csi_ext_attribute OUT parameters:
811 -- None.
812 --
813 --
814 -- Version :
815 -- Current version 1.0
816 --
817 -- End of Comments
818
819 PROCEDURE validate_csi_ext_attribute
820 (
821 x_return_status OUT NOCOPY VARCHAR2,
822 x_msg_data OUT NOCOPY VARCHAR2,
823 p_csi_attribute_name IN VARCHAR2 := NULL,
824 p_x_csi_attribute_code IN OUT NOCOPY VARCHAR2
825 );
826
827
828 -- Start of Comments
829 -- Procedure name : validate_fleet_node
830 -- Type : Private
831 -- Pre-reqs :
832 -- Function :
833 -- Parameters :
834 --
835 -- Standard IN Parameters :
836 -- None
837 --
838 -- Standard OUT Parameters :
839 -- x_return_status VARCHAR2 Required
840 -- x_msg_data VARCHAR2 Required
841 --
842 -- validate_pc_node IN parameters:
843 -- p_fleet_name VARCHAR2 Default NULL
844 --
845 -- validate_pc_node IN OUT parameters:
846 -- p_x_fleet_header_id NUMBER
847 --
848 -- validate_pc_node OUT parameters:
849 -- None.
850 --
851 --
852 -- Version :
853 -- Current version 1.0
854 --
855 -- End of Comments
856
857 PROCEDURE validate_fleet_node
858 (
859 x_return_status OUT NOCOPY VARCHAR2,
860 x_msg_data OUT NOCOPY VARCHAR2,
861 p_fleet_name IN VARCHAR2 := NULL,
862 p_x_fleet_header_id IN OUT NOCOPY NUMBER
863 );
864
865
866 END ahl_fmp_common_pvt;