1 PACKAGE GMD_ERES_POST_OPERATION AS
2 /* $Header: GMDPSOPS.pls 120.2 2005/10/07 02:43:07 srsriran noship $ */
3
4
5 PROCEDURE set_formula_status(p_formula_id IN NUMBER,
6 p_from_status IN VARCHAR2,
7 p_to_status IN VARCHAR2);
8
9 PROCEDURE set_formulation_spec_status(p_formulation_spec_id IN NUMBER,
10 p_from_status IN VARCHAR2,
11 p_to_status IN VARCHAR2);
12
13 PROCEDURE set_operation_status(p_oprn_id IN NUMBER,
14 p_from_status IN VARCHAR2,
15 p_to_status IN VARCHAR2);
16
17 PROCEDURE set_routing_status(p_routing_id IN NUMBER,
18 p_from_status IN VARCHAR2,
19 p_to_status IN VARCHAR2);
20
21 PROCEDURE set_recipe_status(p_recipe_id IN NUMBER,
22 p_from_status IN VARCHAR2,
23 p_to_status IN VARCHAR2,
24 p_create_validity IN NUMBER DEFAULT 0);
25
26 PROCEDURE set_validity_status(p_validity_rule_id IN NUMBER,
27 p_from_status IN VARCHAR2,
28 p_to_status IN VARCHAR2);
29
30 PROCEDURE set_auto_recipe_status(p_formula_id IN NUMBER,
31 p_orgn_id IN NUMBER,
32 p_from_status IN VARCHAR2,
33 p_to_status IN VARCHAR2);
34 -- Bug number 4479101
35 PROCEDURE set_substitution_status(p_substitution_id IN NUMBER,
36 p_from_status IN VARCHAR2,
37 p_to_status IN VARCHAR2);
38
39 END GMD_ERES_POST_OPERATION;