[Home] [Help]
PACKAGE: APPS.AHL_FMP_COMMON_PVT
Source
1 PACKAGE AHL_FMP_COMMON_PVT AS
2 /* $Header: AHLVFCMS.pls 120.0 2005/05/25 23:46:24 appldev noship $ */
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 x_return_status OUT NOCOPY VARCHAR2,
472 x_msg_count OUT NOCOPY NUMBER,
473 x_msg_data OUT NOCOPY VARCHAR2
474 );
475
476 -- Start of Comments
477 -- Procedure name : Mr_Title_Version_To_Id
478 -- Type : Private
479 -- Pre-reqs :
480 -- Function :
481 -- Parameters :
482 --
483 -- Standard IN Parameters :
484 -- None
485 --
486 -- Standard OUT Parameters :
487 -- x_return_status VARCHAR2 Required
488 --
489 -- mr_title_version_to_id IN parameters:
490 -- p_mr_title IN VARCHAR2 Required
491 -- p_mr_version_number IN NUMBER Required
492 --
493 -- mr_title_version_to_id IN OUT parameters:
497 -- x_mr_header_id OUT NOCOPY NUMBER
494 -- None.
495 --
496 -- mr_title_version_to_id OUT parameters:
498 --
499 -- Version :
500 -- Current version 1.0
501 --
502 -- End of Comments
503
504 PROCEDURE Mr_Title_Version_To_Id
505 (
506 p_mr_title IN VARCHAR2,
507 p_mr_version_number IN NUMBER,
508 x_mr_header_id OUT NOCOPY NUMBER,
509 x_return_status OUT NOCOPY VARCHAR2
510 );
511
512 -- Start of Comments
513 -- Procedure name : Mr_Effectivity_Name_To_Id
514 -- Type : Private
515 -- Pre-reqs :
516 -- Function :
517 -- Parameters :
518 --
519 -- Standard IN Parameters :
520 -- None
521 --
522 -- Standard OUT Parameters :
523 -- x_return_status VARCHAR2 Required
524 --
525 -- mr_title_version_to_id IN parameters:
526 -- p_mr_header_id NUMBER Required
527 -- p_mr_effectivity_name VARCHAR2 Required
528 --
529 -- mr_title_version_to_id IN OUT parameters:
530 -- None.
531 --
532 -- mr_title_version_to_id OUT parameters:
533 -- x_mr_effectivity_id NUMBER Required
534
535 --
536 -- Version :
537 -- Current version 1.0
538 --
539 -- End of Comments
540
541 PROCEDURE Mr_Effectivity_Name_To_Id
542 (
543 p_mr_header_id IN NUMBER,
544 p_mr_effectivity_name IN VARCHAR2,
545 x_mr_effectivity_id OUT NOCOPY NUMBER,
546 x_return_status OUT NOCOPY VARCHAR2
547 );
548
549
550 -- Start of Comments
551 -- Procedure name :
552 -- Type : Private
553 -- Pre-reqs :
554 -- Function : check_mr_type
555 -- Parameters :
556 --
557 -- Standard IN Parameters :
558 -- None
559 --
560 --
561 -- check_mr_type IN parameters:
562 -- p_mr_header_id NUMBER Required
563 --
564 --
565 -- Version :
566 -- Current version 1.0
567 --
568 -- End of Comments
569
570
571 function check_mr_type( p_mr_header_id IN NUMBER ) return varchar2;
572
573
574 -- Start of Comments
575 -- Procedure name :
576 -- Type : Private
577 -- Pre-reqs :
578 -- Function : check_mr_status
579 -- Parameters :
580 --
581 -- Standard IN Parameters :
582 -- None
583 --
584 --
585 -- check_mr_type IN parameters:
586 -- p_mr_header_id NUMBER Required
587 --
588 --
589 -- Version :
590 -- Current version 1.0
591 --
592 -- End of Comments
593
594
595 function check_mr_status( p_mr_header_id IN NUMBER ) return varchar2;
596
597 -- Start of Comments
598 -- Procedure name : validate_mr_type_program
599 -- Type : Private
600 -- Pre-reqs :
601 -- Function :
602 -- Parameters :
603 --
604 -- Standard IN Parameters :
605 -- None
606 --
607 -- Standard OUT Parameters :
608 -- x_return_status VARCHAR2 Required
609 -- x_msg_data VARCHAR2 Required
610 --
611 -- validate_mr_status IN parameters:
612 -- p_effectivity_id NUMBER Required
613 -- p_eff_obj_version NUMBER Required
614 -- p_mr_header_id NUMBER Required
615 -- validate_mr_status IN OUT parameters:
616 -- None.
617 --
618 -- validate_mr_status OUT parameters:
619 -- None.
620 --
621 --
622 -- Version :
623 -- Current version 1.0
624 --
625 -- End of Comments
626
627
628 PROCEDURE validate_mr_type_program
629 (
630 x_return_status OUT NOCOPY VARCHAR2,
631 x_msg_data OUT NOCOPY VARCHAR2,
632 p_mr_header_id IN NUMBER,
633 p_effectivity_id IN NUMBER,
634 p_eff_obj_version IN NUMBER
635 );
636
637 -- Start of Comments
638 -- Procedure name : validate_mr_type_activity
639 -- Type : Private
640 -- Pre-reqs :
641 -- Function :
642 -- Parameters :
643 --
644 -- Standard IN Parameters :
645 -- None
646 --
647 -- Standard OUT Parameters :
648 -- x_return_status VARCHAR2 Required
649 -- x_msg_data VARCHAR2 Required
650 --
651 -- validate_mr_status IN parameters:
652 -- p_effectivity_id NUMBER Required
653 -- p_eff_obj_version NUMBER Required
654 -- validate_mr_status IN OUT parameters:
655 -- None.
656 --
657 -- validate_mr_status OUT parameters:
658 -- None.
659 --
660 --
661 -- Version :
662 -- Current version 1.0
663 --
664 -- End of Comments
665
666 PROCEDURE validate_mr_type_activity
667 (
668 x_return_status OUT NOCOPY VARCHAR2,
669 x_msg_data OUT NOCOPY VARCHAR2,
670 p_effectivity_id IN NUMBER,
671 p_eff_obj_version IN NUMBER
672 );
673
674 -- Start of Comments
678 -- Function :
675 -- Procedure name : validate_mr_pm_status
676 -- Type : Private
677 -- Pre-reqs :
679 -- Parameters :
680 --
681 -- Standard IN Parameters :
682 -- None
683 --
684 -- Standard OUT Parameters :
685 -- x_return_status VARCHAR2 Required
686 -- x_msg_data VARCHAR2 Required
687 --
688 -- validate_mr_status IN parameters:
689 -- p_mr_header_id NUMBER Required
690 --
691 -- validate_mr_status IN OUT parameters:
692 -- None.
693 --
694 -- validate_mr_status OUT parameters:
695 -- None.
696 --
697 --
698 -- Version :
699 -- Current version 1.0
700 --
701 -- End of Comments
702
703 PROCEDURE validate_mr_pm_status
704 (
705 x_return_status OUT NOCOPY VARCHAR2,
706 x_msg_data OUT NOCOPY VARCHAR2,
707 p_mr_header_id IN NUMBER
708 );
709
710 END AHL_FMP_COMMON_PVT;