1: PACKAGE GMD_RECIPE_DETAIL_PVT AUTHID CURRENT_USER AS
2: /* $Header: GMDVRCDS.pls 120.2 2009/03/23 17:43:54 rnalla ship $ */
3:
4: --Added as part of Default Status bug 3408799
5: pkg_recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE;
4: --Added as part of Default Status bug 3408799
5: pkg_recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE;
6:
7: PROCEDURE CREATE_RECIPE_PROCESS_LOSS
8: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
9: x_return_status OUT NOCOPY VARCHAR2
10: );
11:
12: PROCEDURE CREATE_RECIPE_CUSTOMERS
9: x_return_status OUT NOCOPY VARCHAR2
10: );
11:
12: PROCEDURE CREATE_RECIPE_CUSTOMERS
13: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
14: x_return_status OUT NOCOPY VARCHAR2
15: );
16:
17: PROCEDURE CREATE_RECIPE_VR
14: x_return_status OUT NOCOPY VARCHAR2
15: );
16:
17: PROCEDURE CREATE_RECIPE_VR
18: ( p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,
19: p_recipe_vr_flex_rec IN GMD_RECIPE_DETAIL.flex ,
20: x_return_status OUT NOCOPY VARCHAR2
21: );
22:
15: );
16:
17: PROCEDURE CREATE_RECIPE_VR
18: ( p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,
19: p_recipe_vr_flex_rec IN GMD_RECIPE_DETAIL.flex ,
20: x_return_status OUT NOCOPY VARCHAR2
21: );
22:
23: PROCEDURE CREATE_RECIPE_MTL
20: x_return_status OUT NOCOPY VARCHAR2
21: );
22:
23: PROCEDURE CREATE_RECIPE_MTL
24: ( p_recipe_mtl_rec IN GMD_RECIPE_DETAIL.recipe_material,
25: p_recipe_mtl_flex_rec IN GMD_RECIPE_DETAIL.flex ,
26: x_return_status OUT NOCOPY VARCHAR2
27: );
28:
21: );
22:
23: PROCEDURE CREATE_RECIPE_MTL
24: ( p_recipe_mtl_rec IN GMD_RECIPE_DETAIL.recipe_material,
25: p_recipe_mtl_flex_rec IN GMD_RECIPE_DETAIL.flex ,
26: x_return_status OUT NOCOPY VARCHAR2
27: );
28:
29: PROCEDURE UPDATE_RECIPE_PROCESS_LOSS
26: x_return_status OUT NOCOPY VARCHAR2
27: );
28:
29: PROCEDURE UPDATE_RECIPE_PROCESS_LOSS
30: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
31: x_return_status OUT NOCOPY VARCHAR2
32: );
33:
34: PROCEDURE UPDATE_RECIPE_CUSTOMERS
31: x_return_status OUT NOCOPY VARCHAR2
32: );
33:
34: PROCEDURE UPDATE_RECIPE_CUSTOMERS
35: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
36: x_return_status OUT NOCOPY VARCHAR2
37: );
38:
39: PROCEDURE UPDATE_RECIPE_VR
36: x_return_status OUT NOCOPY VARCHAR2
37: );
38:
39: PROCEDURE UPDATE_RECIPE_VR
40: ( p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,
41: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
42: x_return_status OUT NOCOPY VARCHAR2
43: );
44:
37: );
38:
39: PROCEDURE UPDATE_RECIPE_VR
40: ( p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,
41: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
42: x_return_status OUT NOCOPY VARCHAR2
43: );
44:
45: PROCEDURE RECIPE_ROUTING_STEPS
42: x_return_status OUT NOCOPY VARCHAR2
43: );
44:
45: PROCEDURE RECIPE_ROUTING_STEPS
46: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
47: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
48: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
49: x_return_status OUT NOCOPY VARCHAR2
50: );
43: );
44:
45: PROCEDURE RECIPE_ROUTING_STEPS
46: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
47: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
48: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
49: x_return_status OUT NOCOPY VARCHAR2
50: );
51:
44:
45: PROCEDURE RECIPE_ROUTING_STEPS
46: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
47: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
48: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
49: x_return_status OUT NOCOPY VARCHAR2
50: );
51:
52: PROCEDURE RECIPE_ORGN_OPERATIONS
49: x_return_status OUT NOCOPY VARCHAR2
50: );
51:
52: PROCEDURE RECIPE_ORGN_OPERATIONS
53: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
54: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
55: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
56: x_return_status OUT NOCOPY VARCHAR2
57: );
50: );
51:
52: PROCEDURE RECIPE_ORGN_OPERATIONS
53: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
54: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
55: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
56: x_return_status OUT NOCOPY VARCHAR2
57: );
58:
51:
52: PROCEDURE RECIPE_ORGN_OPERATIONS
53: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
54: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
55: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
56: x_return_status OUT NOCOPY VARCHAR2
57: );
58:
59: PROCEDURE RECIPE_ORGN_RESOURCES
56: x_return_status OUT NOCOPY VARCHAR2
57: );
58:
59: PROCEDURE RECIPE_ORGN_RESOURCES
60: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
61: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
62: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
63: x_return_status OUT NOCOPY VARCHAR2
64: );
57: );
58:
59: PROCEDURE RECIPE_ORGN_RESOURCES
60: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
61: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
62: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
63: x_return_status OUT NOCOPY VARCHAR2
64: );
65:
58:
59: PROCEDURE RECIPE_ORGN_RESOURCES
60: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
61: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
62: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
63: x_return_status OUT NOCOPY VARCHAR2
64: );
65:
66: END GMD_RECIPE_DETAIL_PVT; /* Package end */
62: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
63: x_return_status OUT NOCOPY VARCHAR2
64: );
65:
66: END GMD_RECIPE_DETAIL_PVT; /* Package end */