1: PACKAGE GMD_RECIPE_HEADER_PVT AUTHID CURRENT_USER AS
2: /* $Header: GMDVRCHS.pls 120.2 2009/03/23 17:47:41 rnalla ship $ */
3:
4: PROCEDURE CREATE_RECIPE_HEADER
5: ( p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
1: PACKAGE GMD_RECIPE_HEADER_PVT AUTHID CURRENT_USER AS
2: /* $Header: GMDVRCHS.pls 120.2 2009/03/23 17:47:41 rnalla ship $ */
3:
4: PROCEDURE CREATE_RECIPE_HEADER
5: ( p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
6: p_recipe_hdr_flex_rec IN GMD_RECIPE_HEADER.flex ,
7: x_return_status OUT NOCOPY VARCHAR2
8: );
9:
2: /* $Header: GMDVRCHS.pls 120.2 2009/03/23 17:47:41 rnalla ship $ */
3:
4: PROCEDURE CREATE_RECIPE_HEADER
5: ( p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
6: p_recipe_hdr_flex_rec IN GMD_RECIPE_HEADER.flex ,
7: x_return_status OUT NOCOPY VARCHAR2
8: );
9:
10: PROCEDURE UPDATE_RECIPE_HEADER
7: x_return_status OUT NOCOPY VARCHAR2
8: );
9:
10: PROCEDURE UPDATE_RECIPE_HEADER
11: ( p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
12: p_flex_header_rec IN GMD_RECIPE_HEADER.update_flex ,
13: x_return_status OUT NOCOPY VARCHAR2
14: );
15:
8: );
9:
10: PROCEDURE UPDATE_RECIPE_HEADER
11: ( p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
12: p_flex_header_rec IN GMD_RECIPE_HEADER.update_flex ,
13: x_return_status OUT NOCOPY VARCHAR2
14: );
15:
16: PROCEDURE DELETE_RECIPE_HEADER
13: x_return_status OUT NOCOPY VARCHAR2
14: );
15:
16: PROCEDURE DELETE_RECIPE_HEADER
17: ( p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
18: p_flex_header_rec IN GMD_RECIPE_HEADER.update_flex ,
19: x_return_status OUT NOCOPY VARCHAR2
20: );
21:
14: );
15:
16: PROCEDURE DELETE_RECIPE_HEADER
17: ( p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
18: p_flex_header_rec IN GMD_RECIPE_HEADER.update_flex ,
19: x_return_status OUT NOCOPY VARCHAR2
20: );
21:
22: PROCEDURE COPY_RECIPE_HEADER
20: );
21:
22: PROCEDURE COPY_RECIPE_HEADER
23: ( p_old_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE ,
24: p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
25: p_recipe_hdr_flex_rec IN GMD_RECIPE_HEADER.flex ,
26: x_return_status OUT NOCOPY VARCHAR2
27: );
28:
21:
22: PROCEDURE COPY_RECIPE_HEADER
23: ( p_old_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE ,
24: p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
25: p_recipe_hdr_flex_rec IN GMD_RECIPE_HEADER.flex ,
26: x_return_status OUT NOCOPY VARCHAR2
27: );
28:
29: PROCEDURE VALIDATE_FORMULA
35: x_formula_id OUT NOCOPY NUMBER
36: );
37:
38:
39: END GMD_RECIPE_HEADER_PVT;