[Home] [Help]
PACKAGE: APPS.GMD_ROUTING_DESIGNER_PKG
Source
1 PACKAGE GMD_ROUTING_DESIGNER_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMDRSDDS.pls 120.4 2006/08/08 11:31:50 kmotupal noship $ */
3 /*====================================================================================
4 | Copyright (c) 2001 Oracle Corporation
5 | Redwood Shores, California, USA
6 | All rights reserved
7 =====================================================================================
8 | FILENAME
9 | GMDRSDDS.pls
10 |
11 | DESCRIPTION
12 | Package spec containing the procedures used by the Routing Designer
13 | to create/update/delete routing step dependencies.
14 |
15 |
16 | NOTES
17 |
18 | HISTORY
19 | 12-APR-2001 Eddie Oumerretane Created.
20 | 27-APR-2004 S.Sriram Bug# 3408799
21 | Added SET_DEFAULT_STATUS procedure for Default Status Build
22 | 23-SEP-2004 S.Sriram Routing Security build
23 | Added CHECK_ROUT_ORGN_ACCESS procedure for Rout. Security Build
24 | 29-Dec-2005 TDaniel Bug# 4603035
25 | Added code for contiguous_ind and enforce_step_dep.
26 =======================================================================================
27 */
28
29 G_CREATED_BY NUMBER := FND_PROFILE.VALUE('USER_ID');
30 G_LOGIN_ID NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
31 G_USER_ORG VARCHAR2(4);
32
33 /* Api start of comments
34 +============================================================================
35 | PROCEDURE NAME
36 | Delete_Step_Dependency
37 |
38 | DESCRIPTION
39 | Delete a specific step depdendency.
40 |
41 | INPUT PARAMETERS
42 | p_routing_id NUMBER
43 | p_dep_routingstep_no NUMBER
44 | p_routingstep_no NUMBER
45 | p_last_update_date DATE
46 |
47 | OUTPUT PARAMETERS
48 | x_return_code VARCHAR2(1)
49 | x_error_msg VARCHAR2(100)
50 |
51 | HISTORY
52 | 12-APR-2001 Eddie Oumerretane Created.
53 |
54 +=============================================================================
55 Api end of comments
56 */
57
58 PROCEDURE Delete_Step_Dependency ( p_routing_id IN NUMBER,
59 p_dep_routingstep_no IN NUMBER,
60 p_routingstep_no IN NUMBER,
61 p_last_update_date IN DATE,
62 x_return_code OUT NOCOPY VARCHAR2,
63 x_error_msg OUT NOCOPY VARCHAR2);
64
65 /* Api start of comments
66 +============================================================================
67 | PROCEDURE NAME
68 | Create_Step_Dependency
69 |
70 | DESCRIPTION
71 | Create an entry in FM_ROUT_DEP representing a dependency between two
72 | routing steps.
73 |
74 | INPUT PARAMETERS
75 | p_dep_routingstep_no NUMBER
76 | p_routing_id NUMBER
77 | p_dep_type NUMBER
78 | p_rework_code VARCHAR2
79 | p_standard_delay NUMBER
80 | p_minimum_delay NUMBER
81 | p_max_delay NUMBER
82 | p_transfer_qty NUMBER
83 | p_titem_um VARCHAR2
84 | p_user_id NUMBER
85 | p_transfer_pct NUMBER
86 |
87 | OUTPUT PARAMETERS
88 | x_return_code VARCHAR2(1)
89 | x_error_msg VARCHAR2(100)
90 |
91 | HISTORY
92 | 12-APR-2001 Eddie Oumerretane Created.
93 |
94 +=============================================================================
95 Api end of comments
96 */
97
98 PROCEDURE Create_Step_Dependency ( p_routingstep_no IN NUMBER,
99 p_dep_routingstep_no IN NUMBER,
100 p_routing_id IN NUMBER,
101 p_dep_type IN NUMBER,
102 p_rework_code IN VARCHAR2,
103 p_standard_delay IN NUMBER,
104 p_minimum_delay IN NUMBER,
105 p_max_delay IN NUMBER,
106 p_transfer_qty IN NUMBER,
107 p_item_um IN VARCHAR2,
108 p_user_id IN NUMBER,
109 p_transfer_pct IN NUMBER,
110 p_last_update_date IN DATE,
111 x_return_code OUT NOCOPY VARCHAR2,
112 x_error_msg OUT NOCOPY VARCHAR2);
113
114
115 /* Api start of comments
116 +============================================================================
117 | PROCEDURE NAME
118 | Update_Step_Dependency
119 |
120 | DESCRIPTION
121 | Update an entry in FM_ROUT_DEP representing a dependency between two
122 | routing steps.
123 |
124 | INPUT PARAMETERS
125 | p_routing_id NUMBER
126 |
127 | OUTPUT PARAMETERS
128 | x_return_code VARCHAR2(1)
129 | x_error_msg VARCHAR2(100)
130 |
131 | HISTORY
132 | 12-APR-2001 Eddie Oumerretane Created.
133 |
134 +=============================================================================
135 Api end of comments
136 */
137
138 PROCEDURE Update_Step_Dependency ( p_routingstep_no IN NUMBER,
139 p_dep_routingstep_no IN NUMBER,
140 p_routing_id IN NUMBER,
141 p_dep_type IN NUMBER,
142 p_rework_code IN VARCHAR2,
143 p_standard_delay IN NUMBER,
144 p_minimum_delay IN NUMBER,
145 p_max_delay IN NUMBER,
146 p_transfer_qty IN NUMBER,
147 p_user_id IN NUMBER,
148 p_transfer_pct IN NUMBER,
149 p_last_update_date IN DATE,
150 p_last_update_date_origin IN DATE,
151 x_return_code OUT NOCOPY VARCHAR2,
152 x_error_msg OUT NOCOPY VARCHAR2);
153
154
155 /* Api start of comments
156 +============================================================================
157 | PROCEDURE NAME
158 | Update_Operation_Step
159 |
160 | DESCRIPTION
161 | Update a particular operation step
162 |
163 | INPUT PARAMETERS
164 | p_routing_id NUMBER
165 | p_routingstep_id NUMBER
166 | p_coord_x NUMBER
167 | p_coord_y NUMBER
168 | p_user_id NUMBER
169 | p_last_update_date DATE
170 | p_last_update_date_origin DATE
171 |
172 | OUTPUT PARAMETERS
173 | x_return_code VARCHAR2(1)
174 | x_error_msg VARCHAR2(100)
175 |
176 | HISTORY
177 | 12-APR-2001 Eddie Oumerretane Created.
178 |
179 +=============================================================================
180 Api end of comments
181 */
182
183 /*
184 PROCEDURE Update_Operation_Step ( p_routing_id IN NUMBER,
185 p_routingstep_id IN NUMBER,
186 p_coord_x IN NUMBER,
187 p_coord_y IN NUMBER,
188 p_user_id IN NUMBER,
189 p_last_update_date IN DATE,
190 p_last_update_date_origin IN DATE,
191 x_return_code OUT NOCOPY VARCHAR2,
192 x_error_msg OUT NOCOPY VARCHAR2);
193
194 */
195
196 /* Api start of comments
197 +============================================================================
198 | PROCEDURE NAME
199 | Get_Routing_Mode
200 |
201 | DESCRIPTION
202 | Determine whether this routing is in update or query mode
203 |
204 | INPUT PARAMETERS
205 | p_routing_id NUMBER
206 |
207 | OUTPUT PARAMETERS
208 | x_routing_mode VARCHAR2
209 | x_return_code VARCHAR2
210 | x_error_msg VARCHAR2
211 |
212 | HISTORY
213 | 15-OCT-2001 Eddie Oumerretane Created.
214 |
215 +=============================================================================
216 Api end of comments
217 */
218
219 PROCEDURE Get_Routing_Mode ( p_routing_id IN NUMBER,
220 x_routing_mode OUT NOCOPY VARCHAR2,
221 x_return_code OUT NOCOPY VARCHAR2,
222 x_error_msg OUT NOCOPY VARCHAR2);
223
224
225 /* Api start of comments
226 +============================================================================
227 | PROCEDURE NAME
228 | Is_Routing_Used_In_Recipes
229 |
230 | DESCRIPTION
231 | Determine whether the routing is used in one or more recipes.
232 |
233 | INPUT PARAMETERS
234 | p_routing_id NUMBER
235 |
236 | OUTPUT PARAMETERS
237 | x_used_in_recipes VARCHAR2(1)
238 | x_return_code VARCHAR2(1)
239 | x_error_msg VARCHAR2(100)
240 |
241 | HISTORY
242 | 22-NOV-2001 Eddie Oumerretane Created.
243 |
244 +=============================================================================
245 Api end of comments
246 */
247 PROCEDURE Is_Routing_Used_In_Recipes ( p_routing_id IN NUMBER,
248 x_used_in_recipes OUT NOCOPY VARCHAR2,
249 x_return_code OUT NOCOPY VARCHAR2,
250 x_error_msg OUT NOCOPY VARCHAR2);
251
252 /* Api start of comments
253 +============================================================================
254 | PROCEDURE NAME
255 | Update_Routing_Header
256 |
257 | DESCRIPTION
258 | Update routing header
259 |
260 | INPUT PARAMETERS
261 | p_routing_id IN NUMBER
262 | p_routing_no IN VARCHAR2
263 | p_routing_vers IN NUMBER
264 | p_routing_desc IN VARCHAR2
265 | p_routing_class IN VARCHAR2
266 | p_effective_start_date IN DATE
267 | p_effective_end_date IN DATE
268 | p_routing_qty IN NUMBER
269 | p_routing_uom IN VARCHAR2
270 | p_process_loss IN NUMBER
271 | p_owner_id IN NUMBER
272 | p_owner_orgn_code IN VARCHAR2
273 | p_enforce_step_dep IN NUMBER
274 | p_last_update_date IN DATE
275 | p_user_id IN NUMBER
276 | p_update_release_type IN NUMBER
277 |
278 | OUTPUT PARAMETERS
279 | x_return_code VARCHAR2(1)
280 | x_error_msg VARCHAR2(100)
281 |
282 | HISTORY
283 | 13-JUN-2002 Eddie Oumerretane Created.
284 |
285 +=============================================================================
286 Api end of comments
287 */
288 PROCEDURE Update_Routing_Header ( p_routing_id IN NUMBER,
289 p_routing_no IN VARCHAR2,
290 p_routing_vers IN NUMBER,
291 p_routing_desc IN VARCHAR2,
292 p_routing_class IN VARCHAR2,
293 p_effective_start_date IN DATE,
294 p_effective_end_date IN DATE,
295 p_routing_qty IN NUMBER,
296 p_routing_uom IN VARCHAR2,
297 p_process_loss IN NUMBER,
298 p_owner_id IN NUMBER,
299 p_owner_orgn_id IN NUMBER,
300 p_enforce_step_dep IN NUMBER,
301 p_contiguous_ind IN NUMBER,
302 p_last_update_date IN DATE,
303 p_user_id IN NUMBER,
304 p_last_update_date_orig IN DATE,
305 p_update_release_type IN NUMBER,
306 x_return_code OUT NOCOPY VARCHAR2,
307 x_error_msg OUT NOCOPY VARCHAR2);
308
309
310 /* Api start of comments
311 +============================================================================
312 | PROCEDURE NAME
313 | Check_Version_Control
314 |
315 | DESCRIPTION
316 | Determine whether version control is enabled.
317 |
318 | INPUT PARAMETERS
319 | p_entity_type VARCHAR2
320 | p_entity_id NUMBER
321 |
322 | OUTPUT PARAMETERS
323 | x_version_control VARCHAR2(1)
324 | x_return_code VARCHAR2(1)
325 | x_error_msg VARCHAR2(100)
326 |
327 | HISTORY
328 | 24-JUN-2002 Eddie Oumerretane Created.
329 |
330 +=============================================================================
331 Api end of comments
332 */
333 PROCEDURE Check_Version_Control ( p_entity_type IN VARCHAR2,
334 p_entity_id IN NUMBER,
335 x_version_control OUT NOCOPY VARCHAR2,
336 x_return_code OUT NOCOPY VARCHAR2,
337 x_error_msg OUT NOCOPY VARCHAR2);
338
339 /* Api start of comments
340 +============================================================================
341 | PROCEDURE NAME
342 | Check_Function
343 |
344 | DESCRIPTION
345 | Determine whether user has access to the given function.
346 |
347 | INPUT PARAMETERS
348 | p_function_name VARCHAR2
349 |
350 | OUTPUT PARAMETERS
351 | x_access VARCHAR2(1)
352 |
353 | HISTORY
354 | 25-JUN-2002 Eddie Oumerretane Created.
355 |
356 +=============================================================================
357 Api end of comments
358 */
359 PROCEDURE Check_Function ( p_function_name IN VARCHAR2,
360 x_access OUT NOCOPY VARCHAR2);
361
362 /* Api start of comments
363 +============================================================================
364 | PROCEDURE NAME
365 | Create_Routing_Step
366 |
367 | DESCRIPTION
368 | Create routing step
369 |
370 | INPUT PARAMETERS
371 | p_routing_id IN NUMBER
372 | p_routingstep_no IN NUMBER
373 | p_routingstep_id IN NUMBER
374 | p_oprn_id IN NUMBER
375 | p_step_qty IN NUMBER
376 | p_release_type IN NUMBER
377 | p_text_code IN NUMBER
378 | p_coordx IN NUMBER
379 | p_coordy IN NUMBER
380 | p_last_update_date IN DATE
381 | p_user_id IN NUMBER
382 |
383 | OUTPUT PARAMETERS
384 | x_return_code VARCHAR2(1)
385 | x_error_msg VARCHAR2(100)
386 |
387 | HISTORY
388 | 02-JUL-2002 Eddie Oumerretane Created.
389 |
390 +=============================================================================
391 Api end of comments
392 */
393 PROCEDURE Insert_Routing_Step ( p_routing_id IN NUMBER,
394 p_routingstep_no IN NUMBER,
395 p_routingstep_id IN NUMBER,
396 p_oprn_id IN NUMBER,
397 p_step_qty IN NUMBER,
398 p_release_type IN NUMBER,
399 p_text_code IN NUMBER,
400 p_last_update_date IN DATE,
401 p_user_id IN NUMBER,
402 p_coordx IN NUMBER,
403 p_coordy IN NUMBER,
404 x_return_code OUT NOCOPY VARCHAR2,
405 x_error_msg OUT NOCOPY VARCHAR2);
406 /* Api start of comments
407 +============================================================================
408 | PROCEDURE NAME
409 | Update_Routing_Step
410 |
411 | DESCRIPTION
412 | Update routing step
413 |
414 | INPUT PARAMETERS
415 | p_routingstep_id IN NUMBER
416 | p_release_type IN NUMBER
417 | p_step_qty IN NUMBER
418 | p_text_code IN NUMBER
419 | p_last_update_date IN DATE
420 | p_user_id IN NUMBER
421 | p_last_update_date_orig IN DATE
422 |
423 | OUTPUT PARAMETERS
424 | x_return_code VARCHAR2(1)
425 | x_error_msg VARCHAR2(100)
426 |
427 | HISTORY
428 | 02-JUL-2002 Eddie Oumerretane Created.
429 |
430 +=============================================================================
431 Api end of comments
432 */
433 PROCEDURE Update_Routing_Step ( p_routingstep_id IN NUMBER,
434 p_release_type IN NUMBER,
435 p_step_qty IN NUMBER,
436 p_text_code IN NUMBER,
437 p_coordx IN NUMBER,
438 p_coordy IN NUMBER,
439 p_last_update_date IN DATE,
440 p_user_id IN NUMBER,
441 p_last_update_date_orig IN DATE,
442 x_return_code OUT NOCOPY VARCHAR2,
443 x_error_msg OUT NOCOPY VARCHAR2);
444
445
446 /* Api start of comments
447 +============================================================================
448 | PROCEDURE NAME
449 | Create_Routing_Header
450 |
451 | DESCRIPTION
452 | Create routing header
453 |
454 | INPUT PARAMETERS
455 | p_routing_no IN VARCHAR2
456 | p_routing_vers IN NUMBER,
457 | p_routing_desc IN VARCHAR2
458 | p_routing_class IN VARCHAR2
459 | p_effective_start_date IN DATE
460 | p_effective_end_date IN DATE
461 | p_routing_qty IN NUMBER
462 | p_routing_uom IN VARCHAR2
463 | p_process_loss IN NUMBER
464 | p_owner_id IN NUMBER
465 | p_owner_orgn_code IN VARCHAR2
466 | p_enforce_step_dep IN NUMBER
467 | p_last_update_date IN DATE
468 | p_user_id IN NUMBER
469 |
470 | OUTPUT PARAMETERS
471 | x_routing_id NUMBER
472 | x_return_code VARCHAR2(1)
473 | x_error_msg VARCHAR2(100)
474 |
475 | HISTORY
476 | 06-JUL-2002 Eddie Oumerretane Created.
477 |
478 +=============================================================================
479 Api end of comments
480 */
481 PROCEDURE Create_Routing_Header ( p_routing_no IN VARCHAR2,
482 p_routing_vers IN NUMBER,
483 p_routing_desc IN VARCHAR2,
484 p_routing_class IN VARCHAR2,
485 p_effective_start_date IN DATE,
486 p_effective_end_date IN DATE,
487 p_routing_qty IN NUMBER,
488 p_routing_uom IN VARCHAR2,
489 p_process_loss IN NUMBER,
490 p_owner_id IN NUMBER,
491 p_owner_orgn_id IN NUMBER,
492 p_enforce_step_dep IN NUMBER,
493 p_contiguous_ind IN NUMBER,
494 p_last_update_date IN DATE,
495 p_user_id IN NUMBER,
496 x_routing_id OUT NOCOPY NUMBER,
497 x_return_code OUT NOCOPY VARCHAR2,
498 x_error_msg OUT NOCOPY VARCHAR2);
499 /* Api start of comments
500 +============================================================================
501 | PROCEDURE NAME
502 | Generate_Step_Dependencies
503 |
504 | DESCRIPTION
505 | Generate sequential step dependencies
506 |
507 | INPUT PARAMETERS
508 | p_routing_id IN NUMBER
509 | p_dependency_type IN NUMBER
510 |
511 | OUTPUT PARAMETERS
512 | x_return_code VARCHAR2(1)
513 | x_error_msg VARCHAR2(100)
514 |
515 | HISTORY
516 | 09-JUL-2002 Eddie Oumerretane Created.
517 |
518 +=============================================================================
519 Api end of comments
520 */
521 PROCEDURE Generate_Step_Dependencies(p_routing_id IN NUMBER,
522 p_dependency_type IN NUMBER,
523 x_return_code OUT NOCOPY VARCHAR2,
524 x_error_msg OUT NOCOPY VARCHAR2);
525
526
527 /* Api start of comments
528 +============================================================================
529 | PROCEDURE NAME
530 | Delete_Routing_Step
531 |
532 | DESCRIPTION
533 | Delete a step
534 |
535 | INPUT PARAMETERS
536 | p_routing_id NUMBER
537 | p_routingstep_id NUMBER
538 | p_last_update_date DATE
539 |
540 | OUTPUT PARAMETERS
541 | x_return_code VARCHAR2(1)
542 | x_error_msg VARCHAR2(100)
543 |
544 | HISTORY
545 | 16-JUL-2002 Eddie Oumerretane Created.
546 |
547 +=============================================================================
548 Api end of comments
549 */
550
551 PROCEDURE Delete_Routing_Step ( p_routing_id IN NUMBER,
552 p_routingstep_id IN NUMBER,
553 p_last_update_date IN DATE,
554 x_return_code OUT NOCOPY VARCHAR2,
555 x_error_msg OUT NOCOPY VARCHAR2);
556
557
558 /* Api start of comments
559 +============================================================================
560 | PROCEDURE NAME
561 | Copy_Routing
562 |
563 | DESCRIPTION
564 | Copy the given routing
565 |
566 | INPUT PARAMETERS
567 | p_copy_from_routing_id NUMBER
568 | p_routing_no VARCHAR2
569 | p_routing_vers VARCHAR2
570 | p_routing_desc VARCHAR2
571 |
572 | OUTPUT PARAMETERS
573 | x_routing_id NUMBER
574 | x_return_code VARCHAR2(1)
575 | x_error_msg VARCHAR2(100)
576 |
577 | HISTORY
578 | 18-JUL-2002 Eddie Oumerretane Created.
579 | 08-AUG-2006 Removed orgn_id for bug# 5206623
580 +=============================================================================
581 Api end of comments
582 */
583 PROCEDURE Copy_Routing ( p_copy_from_routing_id IN NUMBER,
584 p_routing_no IN VARCHAR2,
585 p_routing_vers IN NUMBER,
586 p_routing_desc IN VARCHAR2,
587 x_routing_id OUT NOCOPY NUMBER,
588 x_return_code OUT NOCOPY VARCHAR2,
589 x_error_msg OUT NOCOPY VARCHAR2);
590
591 /* Api start of comments
592 +============================================================================
593 | PROCEDURE NAME
594 | Save_Profile_Value
595 |
596 | DESCRIPTION
597 | Save the given profile option
598 |
599 | INPUT PARAMETERS
600 | p_profile_name VARCHAR2
601 | p_profile_value VARCHAR2
602 |
603 | OUTPUT PARAMETERS
604 | x_return_code VARCHAR2(1)
605 | x_error_msg VARCHAR2(100)
606 |
607 | HISTORY
608 | 18-JUL-2002 Eddie Oumerretane Created.
609 |
610 +=============================================================================
611 Api end of comments
612 */
613 PROCEDURE Save_Profile_Value ( p_profile_name IN VARCHAR2,
614 p_profile_value IN VARCHAR2,
615 x_return_code OUT NOCOPY VARCHAR2,
616 x_error_msg OUT NOCOPY VARCHAR2);
617
618 /* Api start of comments
619 +============================================================================
620 | PROCEDURE NAME
621 | Get_Profile_Value
622 |
623 | DESCRIPTION
624 | Get the value of the given profile option
625 |
626 | INPUT PARAMETERS
627 | p_profile_name VARCHAR2
628 |
629 | OUTPUT PARAMETERS
630 | x_profile_value VARCHAR2
631 | x_return_code VARCHAR2(1)
632 | x_error_msg VARCHAR2(100)
633 |
634 | HISTORY
635 | 18-JUL-2002 Eddie Oumerretane Created.
636 |
637 +=============================================================================
638 Api end of comments
639 */
640 PROCEDURE Get_Profile_Value ( p_profile_name IN VARCHAR2,
641 x_profile_value OUT NOCOPY VARCHAR2,
642 x_return_code OUT NOCOPY VARCHAR2,
643 x_error_msg OUT NOCOPY VARCHAR2);
644
645 /* Api start of comments
646 +============================================================================
647 | PROCEDURE NAME
648 | Validate_Routing_Details
649 |
650 | DESCRIPTION
651 | Validate routing details
652 |
653 | INPUT PARAMETERS
654 | p_routing_id NUMBER
655 |
656 | OUTPUT PARAMETERS
657 | x_return_code VARCHAR2(1)
658 | x_error_msg VARCHAR2(100)
659 |
660 | HISTORY
661 | 24-JUL-2002 Eddie Oumerretane Created.
662 |
663 +=============================================================================
664 Api end of comments
665 */
666 PROCEDURE Validate_Routing_Details ( p_routing_id IN VARCHAR2,
667 x_return_code OUT NOCOPY VARCHAR2,
668 x_error_msg OUT NOCOPY VARCHAR2);
669
670 /* Api start of comments
671 +============================================================================
672 | PROCEDURE NAME
673 | Validate_Routing_VR_Dates
674 |
675 | DESCRIPTION
676 | Verify that the routing effective dates falls within all recipe validity
677 | rules that are using the routing.
678 |
679 | INPUT PARAMETERS
680 | p_routing_id NUMBER
681 |
682 | OUTPUT PARAMETERS
683 | x_update_vr VARCHAR2(1)
684 | x_return_code VARCHAR2(1)
685 | x_error_msg VARCHAR2(100)
686 |
687 | HISTORY
688 | 24-JUL-2002 Eddie Oumerretane Created.
689 |
690 +=============================================================================
691 Api end of comments
692 */
693 PROCEDURE Validate_Routing_VR_Dates ( p_routing_id IN VARCHAR2,
694 x_update_vr OUT NOCOPY VARCHAR2,
695 x_return_code OUT NOCOPY VARCHAR2,
696 x_error_msg OUT NOCOPY VARCHAR2);
697
698 /* Api start of comments
699 +============================================================================
700 | PROCEDURE NAME
701 | Update_VR_With_RT_Dates
702 |
703 | DESCRIPTION
704 | Update validity rules with routing from/to dates
705 |
706 | INPUT PARAMETERS
707 | p_routing_id NUMBER
708 |
709 | OUTPUT PARAMETERS
710 | x_return_code VARCHAR2(1)
711 | x_error_msg VARCHAR2(100)
712 |
713 | HISTORY
714 | 24-JUL-2002 Eddie Oumerretane Created.
715 |
716 +=============================================================================
717 Api end of comments
718 */
719 PROCEDURE Update_VR_With_RT_Dates ( p_routing_id IN VARCHAR2,
720 x_return_code OUT NOCOPY VARCHAR2,
721 x_error_msg OUT NOCOPY VARCHAR2);
722
723
724 /* Api start of comments
725 +============================================================================
726 | PROCEDURE NAME
727 | Get_Theoretical_Process_Loss
728 |
729 | DESCRIPTION
730 | Retrieve theoretical process loss
731 |
732 | INPUT PARAMETERS
733 | p_routing_qty NUMBER
734 | p_routing_um VARCHAR2
735 | p_routing_class VARCHAR2
736 |
737 | OUTPUT PARAMETERS
738 | x_theoretical_loss VARCHAR2(1)
739 | x_return_code VARCHAR2(1)
740 | x_error_msg VARCHAR2(100)
741 |
742 | HISTORY
743 | 02-AUG-2002 Eddie Oumerretane Created.
744 |
745 +=============================================================================
746 Api end of comments
747 */
748 PROCEDURE Get_Theoretical_Process_Loss (p_routing_qty IN NUMBER,
749 p_routing_um IN VARCHAR2,
750 p_routing_class IN VARCHAR2,
751 x_theoretical_loss OUT NOCOPY NUMBER,
752 x_return_code OUT NOCOPY VARCHAR2,
753 x_error_msg OUT NOCOPY VARCHAR2);
754
755 /* Api start of comments
756 +============================================================================
757 | PROCEDURE NAME
758 | Delete_Routing
759 |
760 | DESCRIPTION
761 | Delete routing header
762 |
763 | INPUT PARAMETERS
764 | p_routing_id IN NUMBER
765 | p_last_update_date_orig IN DATE
766 |
767 | OUTPUT PARAMETERS
768 | x_return_code VARCHAR2(1)
769 | x_error_msg VARCHAR2(100)
770 |
771 | HISTORY
772 | 14-AUG-2002 Eddie Oumerretane Created.
773 |
774 +=============================================================================
775 Api end of comments
776 */
777 PROCEDURE Delete_Routing ( p_routing_id IN NUMBER,
778 p_last_update_date_orig IN DATE,
779 x_return_code OUT NOCOPY VARCHAR2,
780 x_error_msg OUT NOCOPY VARCHAR2);
781
782 /*
783 +============================================================================
784 | PROCEDURE NAME
785 | Undelete_Routing
786 |
787 | DESCRIPTION
788 | Unelete routing header
789 |
790 | INPUT PARAMETERS
791 | p_routing_id IN NUMBER
792 | p_last_update_date_orig IN DATE
793 |
794 | OUTPUT PARAMETERS
795 | x_return_code VARCHAR2(1)
796 | x_error_msg VARCHAR2(100)
797 |
798 | HISTORY
799 | 14-AUG-2002 Eddie Oumerretane Created.
800 |
801 +=============================================================================
802 Api end of comments
803 */
804 PROCEDURE Undelete_Routing ( p_routing_id IN NUMBER,
805 p_last_update_date_orig IN DATE,
806 x_return_code OUT NOCOPY VARCHAR2,
807 x_error_msg OUT NOCOPY VARCHAR2);
808
809
810
811 /* Api start of comments
812 +============================================================================
813 | PROCEDURE NAME
814 | CHECK_ROUT_ORGN_ACCESS
815 |
816 | DESCRIPTION
817 | Procedure to chk if user has accesss to the Rout Orgn.
818 |
819 | INPUT PARAMETERS
820 | p_routing_id NUMBER
821 |
822 | OUTPUT PARAMETERS
823 | x_return_code VARCHAR2
824 |
825 | HISTORY
826 | 23-SEP-2004 S.Sriram Created for Routing Security Build (Bug# 3408799)
827 |
828 +=============================================================================
829 Api end of comments
830 */
831
832 PROCEDURE CHECK_ROUT_ORGN_ACCESS(p_routing_id IN NUMBER,
833 x_return_code OUT NOCOPY VARCHAR2);
834
835
836 PROCEDURE Get_label_name (p_message_name IN VARCHAR2
837 ,x_message_text OUT NOCOPY VARCHAR2);
838
839 END GMD_ROUTING_DESIGNER_PKG;