[Home] [Help]
PACKAGE: APPS.GMD_RECIPE_DESIGNER_PKG
Source
1 PACKAGE GMD_RECIPE_DESIGNER_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMDRDMDS.pls 120.9 2009/03/23 17:21:08 rnalla ship $ */
3 /*============================================================================
4 | Copyright (c) 2001 Oracle Corporation
5 | Redwood Shores, California, USA
6 | All rights reserved
7 =============================================================================
8 | FILENAME
9 | GMDRDMDS.pls
10 |
11 | DESCRIPTION
12 | Package specification containing the procedures used by the Recipe Designer
13 |
14 |
15 | NOTES
16 |
17 | HISTORY
18 | 03-JUL-2001 Eddie Oumerretane Created.
19 | 27-APR-2004 S.Sriram Bug# 3408799
20 | Added SET_DEFAULT_STATUS procedure for Default Status Build
21 | 13-OCT-2004 Sriram.S Recipe Security Bug# 3948203
22 | Added a proc. to which checks if user has recipe orgn. access.
23 =============================================================================
24 */
25
26 TYPE RoutingStepIdType IS TABLE OF fm_rout_dtl.ROUTINGSTEP_ID%TYPE;
27 TYPE RoutingStepNoType IS TABLE OF fm_rout_dtl.ROUTINGSTEP_NO%TYPE;
28
29 G_ROUTINGSTEP_ID RoutingStepIdType;
30 G_ROUTINGSTEP_NO RoutingStepNoType;
31
32 /* Api start of comments
33 +============================================================================
34 | PROCEDURE NAME
35 | Create_Text_Row
36 |
37 | DESCRIPTION
38 | Create a row in FM_TEXT_TBL
39 |
40 | INPUT PARAMETERS
41 | p_text_code NUMBER
42 | p_lang_code VARCHAR2
43 | p_text VARCHAR2
44 | p_line_no NUMBER
45 | p_paragraph_code VARCHAR2
46 | p_sub_paracode NUMBER
47 | p_table_lnk VARCHAR2
48 | p_user_id NUMBER
49 |
50 | OUTPUT PARAMETERS
51 | x_return_code VARCHAR2(1)
52 | x_error_msg VARCHAR2(100)
53 |
54 | HISTORY
55 | 03-JUL-2001 Eddie Oumerretane Created.
56 |
57 +=============================================================================
58 Api end of comments
59 */
60
61 PROCEDURE Create_Text_Row ( p_text_code IN NUMBER,
62 p_lang_code IN VARCHAR2,
63 p_text IN VARCHAR2,
64 p_line_no IN NUMBER,
65 p_paragraph_code IN VARCHAR2,
66 p_sub_paracode IN NUMBER,
67 p_table_lnk IN VARCHAR2,
68 p_user_id IN NUMBER,
69 x_row_id OUT NOCOPY VARCHAR2,
70 x_return_code OUT NOCOPY VARCHAR2,
71 x_error_msg OUT NOCOPY VARCHAR2);
72
73
74
75 /* Api start of comments
76 +============================================================================
77 | PROCEDURE NAME
78 | Update_Text_Row
79 |
80 | DESCRIPTION
81 | Update a row in FM_TEXT_TBL
82 |
83 | INPUT PARAMETERS
84 | p_text_code NUMBER
85 | p_lang_code VARCHAR2
86 | p_text VARCHAR2
87 | p_line_no NUMBER
88 | p_paragraph_code VARCHAR2
89 | p_sub_paracode NUMBER
90 | p_table_lnk VARCHAR2
91 | p_user_id NUMBER
92 |
93 | OUTPUT PARAMETERS
94 | x_return_code VARCHAR2(1)
95 | x_error_msg VARCHAR2(100)
96 |
97 | HISTORY
98 | 13-JUL-2001 Eddie Oumerretane Created.
99 |
100 +=============================================================================
101 Api end of comments
102 */
103
104
105 PROCEDURE Update_Text_Row ( p_text_code IN NUMBER,
106 p_lang_code IN VARCHAR2,
107 p_text IN VARCHAR2,
108 p_line_no IN NUMBER,
109 p_paragraph_code IN VARCHAR2,
110 p_sub_paracode IN NUMBER,
111 p_user_id IN NUMBER,
112 p_row_id IN VARCHAR2,
113 x_return_code OUT NOCOPY VARCHAR2,
114 x_error_msg OUT NOCOPY VARCHAR2);
115
116
117 /* Api start of comments
118 +============================================================================
119 | PROCEDURE NAME
120 | Delete_Text_Row
121 |
122 | DESCRIPTION
123 | Delete a row in FM_TEXT_TBL
124 |
125 | INPUT PARAMETERS
126 | p_text_code NUMBER
127 | p_lang_code VARCHAR2
128 | p_paragraph_code VARCHAR2
129 | p_sub_paracode NUMBER
130 | p_line_no NUMBER
131 | p_row_id VARCHAR2
132 |
133 | OUTPUT PARAMETERS
134 | x_return_code VARCHAR2(1)
135 | x_error_msg VARCHAR2(100)
136 |
137 | HISTORY
138 | 13-JUL-2001 Eddie Oumerretane Created.
139 |
140 +=============================================================================
141 Api end of comments
142 */
143
144 PROCEDURE Delete_Text_Row ( p_text_code IN NUMBER,
145 p_lang_code IN VARCHAR2,
146 p_paragraph_code IN VARCHAR2,
147 p_sub_paracode IN NUMBER,
148 p_line_no IN NUMBER,
149 p_row_id IN VARCHAR2,
150 x_return_code OUT NOCOPY VARCHAR2,
151 x_error_msg OUT NOCOPY VARCHAR2);
152
153
154 /* Api start of comments
155 +============================================================================
156 | PROCEDURE NAME
157 | Update_Recipe_Routing_step_Row
158 |
159 | DESCRIPTION
160 | Update a row in GMD_RECIPE_ROUTING_STEPS
161 |
162 | INPUT PARAMETERS
163 | p_recipe_id NUMBER
164 | p_routingstep_id NUMBER
165 | p_text_code NUMBER
166 | p_last_update_date DATE
167 | p_last_update_date_origin DATE
168 | p_user_id NUMBER
169 | p_step_qty NUMBER
170 | p_mass_qty NUMBER
171 | p_vol_qty NUMBER
172 | p_mass_uom VARCHAR2
173 | p_vol_uom VARCHAR2
174 |
175 | OUTPUT PARAMETERS
176 | x_return_code VARCHAR2(1)
177 | x_error_msg VARCHAR2(100)
178 |
179 | HISTORY
180 | 03-JUL-2001 Eddie Oumerretane Created.
181 |
182 +=============================================================================
183 Api end of comments
184 */
185
186 PROCEDURE Update_Recipe_Routing_Step_Row ( p_recipe_id IN NUMBER,
187 p_routingstep_id IN NUMBER,
188 p_text_code IN NUMBER,
189 p_last_update_date IN DATE,
190 p_last_update_date_origin IN DATE,
191 p_user_id IN NUMBER,
192 p_step_qty IN NUMBER,
193 p_mass_qty IN NUMBER,
194 p_vol_qty IN NUMBER,
195 p_mass_uom IN VARCHAR2,
196 p_vol_uom IN VARCHAR2,
197 x_return_code OUT NOCOPY VARCHAR2,
198 x_error_msg OUT NOCOPY VARCHAR2);
199
200 /* Api start of comments
201 +============================================================================
202 | PROCEDURE NAME
203 | Create_Recipe_Routing_step_Row
204 |
205 | DESCRIPTION
206 | Create a row in GMD_RECIPE_ROUTING_STEPS
207 |
208 | INPUT PARAMETERS
209 | p_recipe_id NUMBER
210 | p_routingstep_id NUMBER
211 | p_text_code NUMBER
212 | p_last_update_date DATE
213 | p_user_id NUMBER
214 | p_step_qty NUMBER
215 | p_mass_qty NUMBER
216 | p_vol_qty NUMBER
217 | p_mass_uom VARCHAR2
218 | p_vol_uom VARCHAR2
219 |
220 | OUTPUT PARAMETERS
221 | x_return_code VARCHAR2(1)
222 | x_error_msg VARCHAR2(100)
223 |
224 | HISTORY
225 | 03-JUL-2001 Eddie Oumerretane Created.
226 |
227 +=============================================================================
228 Api end of comments
229 */
230
231 PROCEDURE Create_Recipe_Routing_Step_Row ( p_recipe_id IN NUMBER,
232 p_routingstep_id IN NUMBER,
233 p_text_code IN NUMBER,
234 p_last_update_date IN DATE,
235 p_user_id IN NUMBER,
236 p_step_qty IN NUMBER,
237 p_mass_qty IN NUMBER,
238 p_vol_qty IN NUMBER,
239 p_mass_uom IN VARCHAR2,
240 p_vol_uom IN VARCHAR2,
241 x_return_code OUT NOCOPY VARCHAR2,
242 x_error_msg OUT NOCOPY VARCHAR2);
243
244 /* Api start of comments
245 +============================================================================
246 | PROCEDURE NAME
247 | Create_Step_Material_Link
248 |
249 | DESCRIPTION
250 | Create a row in GMD_RECIPE_STEP_MATERIALS
251 |
252 | INPUT PARAMETERS
253 | p_recipe_id NUMBER
254 | p_formulaline_id NUMBER
255 | p_routingstep_id NUMBER
256 | p_text_code NUMBER
257 | p_user_id NUMBER
258 | p_last_update_date DATE
259 |
260 | OUTPUT PARAMETERS
261 | x_return_code VARCHAR2(1)
262 | x_error_msg VARCHAR2(100)
263 |
264 | HISTORY
265 | 04-JUL-2001 Eddie Oumerretane Created.
266 |
267 +=============================================================================
268 Api end of comments
269 */
270
271 PROCEDURE Create_Step_Material_Link ( p_recipe_id IN NUMBER,
272 p_formulaline_id IN NUMBER,
273 p_routingstep_id IN NUMBER,
274 p_text_code IN NUMBER,
275 p_user_id IN NUMBER,
276 p_last_update_date IN DATE,
277 x_return_code OUT NOCOPY VARCHAR2,
278 x_error_msg OUT NOCOPY VARCHAR2);
279
280 /* Api start of comments
281 +============================================================================
282 | PROCEDURE NAME
283 | Delete_Step_Material_Link
284 |
285 | DESCRIPTION
286 | Delete a row in GMD_RECIPE_STEP_MATERIALS
287 |
288 | INPUT PARAMETERS
289 | p_recipe_id NUMBER
290 | p_formulaline_id NUMBER
291 | p_routingstep_id NUMBER
292 | p_last_update_date_origin DATE
293 | p_user_id NUMBER
294 |
295 | OUTPUT PARAMETERS
296 | x_return_code VARCHAR2(1)
297 | x_error_msg VARCHAR2(100)
298 |
299 | HISTORY
300 | 04-JUL-2001 Eddie Oumerretane Created.
301 |
302 +=============================================================================
303 Api end of comments
304 */
305
306 PROCEDURE Delete_Step_Material_Link ( p_recipe_id IN NUMBER,
307 p_formulaline_id IN NUMBER,
308 p_routingstep_id IN NUMBER,
309 p_last_update_date_origin IN DATE,
310 p_user_id IN NUMBER,
311 x_return_code OUT NOCOPY VARCHAR2,
312 x_error_msg OUT NOCOPY VARCHAR2);
313
314 /* Api start of comments
315 +============================================================================
316 | PROCEDURE NAME
317 | Update_Step_Material_Link
318 |
319 | DESCRIPTION
320 | Update a row in GMD_RECIPE_STEP_MATERIALS
321 |
322 | INPUT PARAMETERS
323 | p_recipe_id NUMBER
324 | p_formulaline_id NUMBER
325 | p_routingstep_id NUMBER
326 | p_text_code NUMBER
327 | p_last_update_date DATE
328 | p_last_update_date_origin DATE
329 | p_user_id NUMBER
330 |
331 | OUTPUT PARAMETERS
332 | x_return_code VARCHAR2(1)
333 | x_error_msg VARCHAR2(100)
334 |
335 | HISTORY
336 | 04-JUL-2001 Eddie Oumerretane Created.
337 |
338 +=============================================================================
339 Api end of comments
340 */
341
342 PROCEDURE Update_Step_Material_Link ( p_recipe_id IN NUMBER,
343 p_formulaline_id IN NUMBER,
344 p_routingstep_id IN NUMBER,
345 p_text_code IN NUMBER,
346 p_last_update_date IN DATE,
350 x_error_msg OUT NOCOPY VARCHAR2);
347 p_last_update_date_origin IN DATE,
348 p_user_id IN NUMBER,
349 x_return_code OUT NOCOPY VARCHAR2,
351
352
353 /* Api start of comments
354 +============================================================================
355 | PROCEDURE NAME
356 | Calculate_Step_Quantities
357 |
358 | DESCRIPTION
359 | Calculate step quantities
360 |
361 | INPUT PARAMETERS
362 | p_recipe_id NUMBER
363 |
364 | OUTPUT PARAMETERS
365 | x_quantities VARCHAR2
366 | x_return_code VARCHAR2
367 | x_error_msg VARCHAR2
368 |
369 | HISTORY
370 | 09-JUL-2001 Eddie Oumerretane Created.
371 |
372 +=============================================================================
373 Api end of comments
374 */
375
376 PROCEDURE Calculate_Step_Quantities ( p_recipe_id IN NUMBER,
377 p_user_id IN NUMBER,
378 x_quantities OUT NOCOPY VARCHAR2,
379 x_return_code OUT NOCOPY VARCHAR2,
380 x_error_msg OUT NOCOPY VARCHAR2);
381
382
383 /* Api start of comments
384 +============================================================================
385 | PROCEDURE NAME
386 | Calculate_Step_Charges
387 |
388 | DESCRIPTION
389 | Calculate Charges for the given operation step
390 |
391 | INPUT PARAMETERS
392 | p_recipe_id NUMBER
393 | p_routiingstep_id NUMBER
394 | p_step_qty NUMBER
395 | p_step_um VARCHAR2
396 |
397 | OUTPUT PARAMETERS
398 | x_charges_info VARCHAR2
399 | x_return_code VARCHAR2
400 | x_error_msg VARCHAR2
401 |
402 | HISTORY
403 | 29-AUG-2001 Eddie Oumerretane Created.
404 |
405 +=============================================================================
406 Api end of comments
407 */
408
409 PROCEDURE Calculate_Step_Charges ( p_recipe_id IN NUMBER,
410 p_routingstep_id IN NUMBER,
411 p_step_qty IN NUMBER,
412 p_step_um IN VARCHAR2,
413 x_charges_info OUT NOCOPY VARCHAR2,
414 x_return_code OUT NOCOPY VARCHAR2,
415 x_error_msg OUT NOCOPY VARCHAR2);
416 /* Api start of comments
417 +============================================================================
418 | PROCEDURE NAME
419 | Calculate_Charges
420 |
421 | DESCRIPTION
422 | Calculate Charges
423 |
424 | INPUT PARAMETERS
425 | p_recipe_id NUMBER
426 |
427 | OUTPUT PARAMETERS
428 | x_charges_info VARCHAR2
429 | x_return_code VARCHAR2
430 | x_error_msg VARCHAR2
431 |
432 | HISTORY
433 | 28-AUG-2001 Eddie Oumerretane Created.
434 |
435 +=============================================================================
436 Api end of comments
437 */
438
439 PROCEDURE Calculate_Charges ( p_recipe_id IN NUMBER,
440 x_charges_info OUT NOCOPY VARCHAR2,
441 x_return_code OUT NOCOPY VARCHAR2,
442 x_error_msg OUT NOCOPY VARCHAR2);
443
444 /* Api start of comments
445 +============================================================================
446 | PROCEDURE NAME
447 | Get_Recipe_Mode
448 |
449 | DESCRIPTION
450 | Determine whether this recipe is in update or query mode
451 |
452 | INPUT PARAMETERS
453 | p_recipe_id NUMBER
454 |
455 | OUTPUT PARAMETERS
456 | x_recipe_mode VARCHAR2
457 | x_return_code VARCHAR2
458 | x_error_msg VARCHAR2
459 |
460 | HISTORY
461 | 15-OCT-2001 Eddie Oumerretane Created.
462 |
463 +=============================================================================
464 Api end of comments
465 */
466
467 PROCEDURE Get_Recipe_Mode ( p_recipe_id IN NUMBER,
468 x_recipe_mode OUT NOCOPY VARCHAR2,
469 x_return_code OUT NOCOPY VARCHAR2,
470 x_error_msg OUT NOCOPY VARCHAR2);
471
472 /* Api start of comments
473 +============================================================================
474 | PROCEDURE NAME
475 | Update_Step_Quantities
476 |
477 | DESCRIPTION
478 | Update step quantities s table
479 |
480 | INPUT PARAMETERS
481 | p_recipe_id NUMBER
482 | p_routing_id NUMBER
483 | p_user_id NUMBER
487 | OUTPUT PARAMETERS
484 | p_text_code NUMBER
485 | p_last_update_date DATE
486 |
488 | x_return_code VARCHAR2
489 | x_error_msg VARCHAR2
490 |
491 | HISTORY
492 | 10-JUL-2001 Eddie Oumerretane Created.
493 |
494 +=============================================================================
495 Api end of comments
496 */
497 /*
498 PROCEDURE Update_Step_Quantities ( p_recipe_id IN NUMBER,
499 p_routing_id IN NUMBER,
500 p_user_id IN NUMBER,
501 p_last_update_date IN DATE,
502 x_return_code OUT NOCOPY VARCHAR2,
503 x_error_msg OUT NOCOPY VARCHAR2);
504 */
505
506
507 /* Api start of comments
508 +============================================================================
509 | PROCEDURE NAME
510 | Delete_Recipe_Step_Quantities
511 |
512 | DESCRIPTION
513 | Delete all rows in GMD_RECIPE_ROUTING_STEPS
514 |
515 | INPUT PARAMETERS
516 | p_recipe_id NUMBER
517 |
518 | OUTPUT PARAMETERS
519 | x_return_code VARCHAR2(1)
520 | x_error_msg VARCHAR2(100)
521 |
522 | HISTORY
523 | 31-OCT-2001 Eddie Oumerretane Created.
524 |
525 +=============================================================================
526 Api end of comments
527 */
528
529 PROCEDURE Delete_Recipe_Step_Quantities ( p_recipe_id IN NUMBER,
530 x_return_code OUT NOCOPY VARCHAR2,
531 x_error_msg OUT NOCOPY VARCHAR2);
532
533
534 /* Api start of comments
535 +============================================================================
536 | PROCEDURE NAME
537 | Get_Routing_Step_Quantities
538 |
539 | DESCRIPTION
540 | Get step quantities from the routing of the given recipe
541 |
542 | INPUT PARAMETERS
543 | p_recipe_id NUMBER
544 |
545 | OUTPUT PARAMETERS
546 | x_quantities VARCHAR2
547 | x_return_code VARCHAR2
548 | x_error_msg VARCHAR2
549 |
550 | HISTORY
551 | 30-OCT-2001 Eddie Oumerretane Created.
552 |
553 +=============================================================================
554 Api end of comments
555 */
556
557 PROCEDURE Get_Routing_Step_Quantities ( p_recipe_id IN NUMBER,
558 x_quantities OUT NOCOPY VARCHAR2,
559 x_return_code OUT NOCOPY VARCHAR2,
560 x_error_msg OUT NOCOPY VARCHAR2);
561
562
563 /* Api start of comments
564 +============================================================================
565 | PROCEDURE NAME
566 | Is_Recipe_Used_In_Batches
567 |
568 | DESCRIPTION
569 | Determine whether the recipe is used in open batches.
570 |
571 | INPUT PARAMETERS
572 | p_recipe_id NUMBER
573 |
574 | OUTPUT PARAMETERS
575 | x_used_in_batches VARCHAR2(1)
576 | x_return_code VARCHAR2(1)
577 | x_error_msg VARCHAR2(100)
578 |
579 | HISTORY
580 | 05-NOV-2001 Eddie Oumerretane Created.
581 |
582 +=============================================================================
583 Api end of comments
584 */
585
586 PROCEDURE Is_Recipe_Used_In_Batches ( p_recipe_id IN NUMBER,
587 x_used_in_batches OUT NOCOPY VARCHAR2,
588 x_return_code OUT NOCOPY VARCHAR2,
589 x_error_msg OUT NOCOPY VARCHAR2);
590
591
592
593 /* Api start of comments
594 +============================================================================
595 | PROCEDURE NAME
596 | Update_Recipe_Header
597 |
598 | DESCRIPTION
599 | Update a row in GMD_RECIPES
600 |
601 | INPUT PARAMETERS
602 | p_recipe_id IN NUMBER
603 | p_recipe_description IN VARCHAR2
604 | p_recipe_no IN VARCHAR2
605 | p_recipe_version IN NUMBER
606 | p_recipe_status IN VARCHAR2
607 | p_delete_mark IN NUMBER
608 | p_formula_id IN NUMBER
609 | p_routing_id IN NUMBER
610 | p_planned_process_loss IN NUMBER
611 | p_text_code IN NUMBER
612 | p_owner_id IN NUMBER
613 | p_calculate_step_qty IN NUMBER
614 | p_user_id IN NUMBER
615 | p_last_update_date IN DATE
616 | p_last_update_date_origin IN DATE
617 | p_update_number_version IN VARCHAR2
618 |
619 | OUTPUT PARAMETERS
620 | x_return_code VARCHAR2(1)
621 | x_error_msg VARCHAR2(100)
622 |
623 | HISTORY
624 | 05-MAR-2002 Eddie Oumerretane Created.
625 | 19-SEP-2002 Eddie Oumerretane Modified interface and implemented call
626 | to the Update_Recipe_Header API.
627 +=============================================================================
628 Api end of comments
629 */
630 PROCEDURE Update_Recipe_Header ( p_recipe_id IN NUMBER,
631 p_recipe_description IN VARCHAR2,
632 p_recipe_no IN VARCHAR2,
633 p_recipe_version IN NUMBER,
634 p_owner_organization_id IN NUMBER,
635 p_creation_organization_id IN NUMBER,
636 p_recipe_status IN VARCHAR2,
637 p_delete_mark IN NUMBER,
638 p_formula_id IN NUMBER,
639 p_routing_id IN NUMBER,
640 p_planned_process_loss IN NUMBER,
641 p_text_code IN NUMBER,
642 p_owner_id IN NUMBER,
643 p_calculate_step_qty IN NUMBER,
644 p_user_id IN NUMBER,
645 p_last_update_date IN DATE,
646 p_last_update_date_origin IN DATE,
647 p_update_number_version IN VARCHAR2,
648 x_return_code OUT NOCOPY VARCHAR2,
649 x_error_msg OUT NOCOPY VARCHAR2,
650 p_enhanced_pi_ind IN VARCHAR2,
651 p_contiguous_ind IN NUMBER,
652 p_recipe_type IN NUMBER);
653
654
655 /* Api start of comments
656 +============================================================================
657 | PROCEDURE NAME
658 | Create_Recipe_Header
659 |
660 | DESCRIPTION
661 | Create recipe header
662 |
663 | INPUT PARAMETERS
664 |
665 | OUTPUT PARAMETERS
666 | x_recipe_id NUMBER
667 | x_return_code VARCHAR2(1)
668 | x_error_msg VARCHAR2(100)
669 |
670 | HISTORY
671 | 08-OCT-2002 Eddie Oumerretane Created.
672 |
673 +=============================================================================
674 Api end of comments
675 */
676 PROCEDURE Create_Recipe_Header ( p_orgn_id IN NUMBER,
677 x_recipe_id OUT NOCOPY NUMBER,
678 x_return_code OUT NOCOPY VARCHAR2,
679 x_error_msg OUT NOCOPY VARCHAR2);
680
681 /* Api start of comments
682 +============================================================================
683 | PROCEDURE NAME
684 | Add_Recipe_Customer
685 |
686 | DESCRIPTION
687 | Add a new customer to the recipe
688 |
689 | INPUT PARAMETERS
690 |
691 | OUTPUT PARAMETERS
692 | x_return_code VARCHAR2(1)
693 | x_error_msg VARCHAR2(100)
694 |
695 | HISTORY
699 Api end of comments
696 | 15-OCT-2002 Eddie Oumerretane Created.
697 |
698 +=============================================================================
700 */
701 PROCEDURE Add_Recipe_Customer (p_recipe_id IN NUMBER,
702 p_customer_id IN NUMBER,
703 p_text_code IN NUMBER,
704 p_org_id IN NUMBER, --Modified for Bug # 5454787
705 p_site_use_id IN NUMBER, --Modified for Bug # 5454787
706 p_last_update_date IN DATE,
707 x_return_code OUT NOCOPY VARCHAR2,
708 x_error_msg OUT NOCOPY VARCHAR2);
709
710 /* Api start of comments
711 +============================================================================
712 | PROCEDURE NAME
713 | Delete_Recipe_Customer
714 |
715 | DESCRIPTION
716 | Delete customer from the recipe
717 |
718 | INPUT PARAMETERS
719 | p_recipe_id NUMBER
720 | p_customer_id NUMBER
721 | p_last_update_date DATE
722 |
723 | OUTPUT PARAMETERS
724 | x_return_code VARCHAR2(1)
725 | x_error_msg VARCHAR2(100)
726 |
727 | HISTORY
728 | 15-OCT-2002 Eddie Oumerretane Created.
729 |
730 +=============================================================================
731 Api end of comments
732 */
733 PROCEDURE Delete_Recipe_Customer (p_recipe_id IN NUMBER,
734 p_customer_id IN NUMBER,
735 p_last_update_date IN DATE,
736 x_return_code OUT NOCOPY VARCHAR2,
737 x_error_msg OUT NOCOPY VARCHAR2);
738
739 /* Api start of comments
740 +============================================================================
741 | PROCEDURE NAME
742 | Add_Org_Process_Loss
743 |
744 | DESCRIPTION
745 | Add a new organization specific process loss to the recipe
746 |
747 | INPUT PARAMETERS
748 | p_recipe_id NUMBER
749 | p_orgn_code VARCHAR2
750 | p_process_loss NUMBER
751 | p_text_code NUMBER
752 | p_last_update_date DATE
753 |
754 | OUTPUT PARAMETERS
755 | x_loss_id NUMBER
756 | x_return_code VARCHAR2(1)
757 | x_error_msg VARCHAR2(100)
758 |
759 | HISTORY
760 | 15-OCT-2002 Eddie Oumerretane Created.
761 |
762 +=============================================================================
763 Api end of comments
764 */
765 PROCEDURE Add_Org_Process_Loss (p_recipe_id IN NUMBER,
766 p_orgn_id IN NUMBER,
767 p_process_loss IN NUMBER,
768 p_text_code IN NUMBER,
769 p_contiguous_ind IN NUMBER,
770 p_last_update_date IN DATE,
771 x_loss_id OUT NOCOPY NUMBER,
772 x_return_code OUT NOCOPY VARCHAR2,
773 x_error_msg OUT NOCOPY VARCHAR2);
774 /* Api start of comments
775 +============================================================================
776 | PROCEDURE NAME
777 | Create_Process_Loss
778 |
779 | DESCRIPTION
780 | Add a new organization specific process loss to the recipe
781 |
782 | INPUT PARAMETERS
783 | p_recipe_id NUMBER
784 | p_orgn_code VARCHAR2
785 | p_process_loss NUMBER
786 | p_text_code NUMBER
787 | p_last_update_date DATE
788 | p_loss_id NUMBER
789 |
790 | OUTPUT PARAMETERS
791 | x_loss_id NUMBER
792 | x_return_code VARCHAR2(1)
793 | x_error_msg VARCHAR2(100)
794 |
795 | HISTORY
796 | 10-DEC-2002 Eddie Oumerretane Created.
797 |
798 +=============================================================================
799 Api end of comments
800 */
801 PROCEDURE Create_Process_Loss (p_recipe_id IN NUMBER,
802 p_orgn_id IN NUMBER,
803 p_process_loss IN NUMBER,
804 p_text_code IN NUMBER,
805 p_contiguous_ind IN NUMBER,
806 p_last_update_date IN DATE,
807 p_loss_id IN NUMBER,
808 x_loss_id OUT NOCOPY NUMBER,
809 x_return_code OUT NOCOPY VARCHAR2,
810 x_error_msg OUT NOCOPY VARCHAR2);
811 /* Api start of comments
812 +============================================================================
813 | PROCEDURE NAME
814 | Delete_Org_Process_Loss
815 |
816 | DESCRIPTION
817 | Delete organization specific process loss from the recipe
818 |
819 | INPUT PARAMETERS
820 | p_loss_id NUMBER
821 | p_last_update_date DATE
822 |
823 | OUTPUT PARAMETERS
827 | HISTORY
824 | x_return_code VARCHAR2(1)
825 | x_error_msg VARCHAR2(100)
826 |
828 | 30-OCT-2002 Eddie Oumerretane Created.
829 |
830 +=============================================================================
831 Api end of comments
832 */
833 PROCEDURE Delete_Org_Process_Loss (p_loss_id IN NUMBER,
834 p_last_update_date IN DATE,
835 x_return_code OUT NOCOPY VARCHAR2,
836 x_error_msg OUT NOCOPY VARCHAR2);
837
838 /* Api start of comments
839 +============================================================================
840 | PROCEDURE NAME
841 | Update_Org_Process_Loss
842 |
843 | DESCRIPTION
844 | Update an organization specific process loss
845 |
846 | INPUT PARAMETERS
847 | p_recipe_id NUMBER
848 | p_recipe_loss_id NUMBER
849 | p_orgn_code VARCHAR2
850 | p_process_loss NUMBER
851 | p_text_code NUMBER
852 | p_last_update_date DATE
853 | p_last_update_date_orig DATE
854 |
855 | OUTPUT PARAMETERS
856 | x_return_code VARCHAR2(1)
857 | x_error_msg VARCHAR2(100)
858 |
859 | HISTORY
860 | 09-OCT-2002 Eddie Oumerretane Created.
861 |
862 +=============================================================================
863 Api end of comments
864 */
865 PROCEDURE Update_Org_Process_Loss (p_recipe_id IN NUMBER,
866 p_recipe_loss_id IN NUMBER,
867 p_orgn_id IN NUMBER,
868 p_process_loss IN NUMBER,
869 p_text_code IN NUMBER,
870 p_contiguous_ind IN NUMBER,
871 p_last_update_date IN DATE,
872 p_last_update_date_orig IN DATE,
873 x_return_code OUT NOCOPY VARCHAR2,
874 x_error_msg OUT NOCOPY VARCHAR2);
875
876
877 /* Api start of comments
878 +============================================================================
879 | PROCEDURE NAME
880 | Delete_Recipe
881 |
882 | DESCRIPTION
883 | Mark for purge the given recipe
884 |
885 | INPUT PARAMETERS
886 | p_recipe_id NUMBER
887 | p_last_update_date_orig DATE
888 |
889 | OUTPUT PARAMETERS
890 | x_return_code VARCHAR2(1)
891 | x_error_msg VARCHAR2(100)
892 |
893 | HISTORY
894 | 13-NOV-2002 Eddie Oumerretane Created.
895 |
896 +=============================================================================
897 Api end of comments
898 */
899 PROCEDURE Delete_Recipe (p_recipe_id IN NUMBER,
900 p_last_update_date_orig IN DATE,
901 x_return_code OUT NOCOPY VARCHAR2,
902 x_error_msg OUT NOCOPY VARCHAR2);
903
904
905 /* Api start of comments
906 +============================================================================
907 | PROCEDURE NAME
908 | Undele_Recipe
909 |
910 | DESCRIPTION
911 | Undelete the the given recipe
912 |
913 | INPUT PARAMETERS
914 | p_recipe_id NUMBER
915 | p_last_update_date_orig DATE
916 |
917 | OUTPUT PARAMETERS
918 | x_return_code VARCHAR2(1)
919 | x_error_msg VARCHAR2(100)
920 |
921 | HISTORY
922 | 13-NOV-2002 Eddie Oumerretane Created.
923 |
924 +=============================================================================
925 Api end of comments
926 */
927 PROCEDURE Undelete_Recipe (p_recipe_id IN NUMBER,
928 p_last_update_date_orig IN DATE,
929 x_return_code OUT NOCOPY VARCHAR2,
930 x_error_msg OUT NOCOPY VARCHAR2);
931
932
933 /* Api start of comments
934 +============================================================================
935 | PROCEDURE NAME
936 | Get_Theoretical_Process_Loss
937 |
938 | DESCRIPTION
939 | Retrieve theoretical process loss
940 |
941 | INPUT PARAMETERS
942 | p_routing_id NUMBER
943 | p_formula_id NUMBER
944 |
945 | OUTPUT PARAMETERS
946 | x_theoretical_loss VARCHAR2(1)
947 | x_return_code VARCHAR2(1)
948 | x_error_msg VARCHAR2(100)
949 |
950 | HISTORY
951 | 21-NOV-2002 Eddie Oumerretane Created.
952 |
953 +=============================================================================
954 Api end of comments
955 */
956 PROCEDURE Get_Theoretical_Process_Loss (p_routing_id IN NUMBER,
957 p_formula_id IN NUMBER,
958 x_theoretical_loss OUT NOCOPY NUMBER,
959 x_return_code OUT NOCOPY VARCHAR2,
960 x_error_msg OUT NOCOPY VARCHAR2);
961
962
963 /* Api start of comments
967 |
964 +============================================================================
965 | PROCEDURE NAME
966 | Check_Step_Quantity_Calculatable
968 | DESCRIPTION
969 | Check whether step quantities can be calculated.
970 |
971 | INPUT PARAMETERS
972 | p_recipe_id NUMBER
973 |
974 | OUTPUT PARAMETERS
975 | x_return_code VARCHAR2(1)
976 | x_error_msg VARCHAR2(100)
977 |
978 | HISTORY
979 | 03-DEC-2002 Eddie Oumerretane Created.
980 |
981 +=============================================================================
982 Api end of comments
983 */
984 PROCEDURE Check_Step_Qty_Calculatable (p_recipe_id IN NUMBER,
985 x_return_code OUT NOCOPY VARCHAR2,
986 x_error_msg OUT NOCOPY VARCHAR2);
987
988 /* Api start of comments
989 +============================================================================
990 | PROCEDURE NAME
991 | Copy_Recipe
992 |
993 | DESCRIPTION
994 | Copy the given recipe, formula and routing
995 |
996 | INPUT PARAMETERS
997 | p_copy_from_recipe_id NUMBER
998 | p_recipe_no VARCHAR2
999 | p_recipe_vers NUMBER
1000 | p_recipe_desc VARCHAR2
1001 | p_copy_from_formula_id NUMBER
1002 | p_formula_no VARCHAR2
1003 | p_formula_vers NUMBER
1004 | p_formula_desc VARCHAR2
1005 | p_copy_from_routing_id NUMBER
1006 | p_routing_no VARCHAR2
1007 | p_routing_vers NUMBER
1008 | p_routing_desc VARCHAR2
1009 | p_commit VARCHAR2
1010 |
1011 | OUTPUT PARAMETERS
1012 | x_recipe_id NUMBER
1013 | x_formula_id NUMBER
1014 | x_routing_id NUMBER
1015 | x_return_code VARCHAR2(1)
1016 | x_error_msg VARCHAR2(100)
1017 |
1018 | HISTORY
1019 | 10-DEC-2002 Eddie Oumerretane Created.
1020 |
1021 +=============================================================================
1022 Api end of comments
1023 */
1024 PROCEDURE Copy_Recipe ( p_copy_from_recipe_id IN NUMBER,
1025 p_recipe_no IN VARCHAR2,
1026 p_recipe_vers IN NUMBER,
1027 p_recipe_desc IN VARCHAR2,
1028 p_copy_from_formula_id IN NUMBER,
1029 p_formula_no IN VARCHAR2,
1030 p_formula_vers IN NUMBER,
1031 p_formula_desc IN VARCHAR2,
1032 p_copy_from_routing_id IN NUMBER,
1033 p_routing_no IN VARCHAR2,
1034 p_routing_vers IN NUMBER,
1035 p_routing_desc IN VARCHAR2,
1036 p_commit IN VARCHAR2,
1037 x_recipe_id OUT NOCOPY NUMBER,
1038 x_formula_id OUT NOCOPY NUMBER,
1039 x_routing_id OUT NOCOPY NUMBER,
1040 x_return_code OUT NOCOPY VARCHAR2,
1041 x_error_msg OUT NOCOPY VARCHAR2);
1042
1043 /* Api start of comments
1044 +============================================================================
1045 | PROCEDURE NAME
1046 | SET_DEFAULT_STATUS
1047 |
1048 | DESCRIPTION
1049 | Procedure to set the Default Status for a new Recipe
1050 |
1051 | INPUT PARAMETERS
1052 | Recipe_id NUMBER
1053 |
1054 | OUTPUT PARAMETERS
1055 | x_return_code VARCHAR2
1056 | x_msg_count NUMBER
1057 | x_msg_data VARCHAR2
1058 |
1059 | HISTORY
1060 | 27-APR-2004 S.Sriram Created for Default Status Build (Bug# 3408799)
1061 |
1062 +=============================================================================
1063 Api end of comments
1064 */
1065 PROCEDURE set_default_status (pEntity_name IN VARCHAR2
1066 ,pEntity_id IN NUMBER
1067 ,x_return_status OUT NOCOPY VARCHAR2
1068 ,x_msg_count OUT NOCOPY NUMBER
1069 ,x_msg_data OUT NOCOPY VARCHAR2 );
1070
1071
1072 /* Api start of comments
1073 +============================================================================
1074 | PROCEDURE NAME
1075 | CHECK_RECP_ORGN_ACCESS
1076 |
1077 | DESCRIPTION
1078 | Procedure to chk if user has accesss to the Recp Orgn.
1079 |
1080 | INPUT PARAMETERS
1081 | p_recipe_id NUMBER
1082 | p_user_id NUMBER
1083 |
1084 | OUTPUT PARAMETERS
1085 | x_return_code VARCHAR2
1086 |
1087 | HISTORY
1088 | 13-OCT-2004 S.Sriram Created for Recipe Security (Bug# 3948203)
1089 |
1090 +=============================================================================
1091 Api end of comments
1092 */
1093
1094 PROCEDURE CHECK_RECP_ORGN_ACCESS(p_recipe_id IN NUMBER,
1095 p_user_id IN NUMBER,
1096 x_return_code OUT NOCOPY VARCHAR2);
1097
1098
1099
1103
1100 PROCEDURE Check_Recipe_Formula (p_recipe_id IN NUMBER,
1101 p_organization_id IN NUMBER,
1102 x_return_code OUT NOCOPY VARCHAR2);
1104
1105
1106 END GMD_RECIPE_DESIGNER_PKG;