1 PACKAGE BODY GMD_ERES_POST_OPERATION AS
2 /* $Header: GMDPSOPB.pls 120.2 2005/10/07 02:43:41 srsriran noship $ */
3
4 /*======================================================================
5 -- PROCEDURE :
6 -- set_formula_status
7 --
8 -- DESCRIPTION:
9 -- This PL/SQL procedure is responsible for setting the formula status
10 -- to a given status based on the status of the signature.
11 -- (This is called as a POST-OP API from the approval workflow
12 -- REQUIREMENTS
13 --
14 -- SYNOPSIS:
15 -- set_formula_status (100, 400, 700);
16 --
17 --===================================================================== */
18 PROCEDURE set_formula_status(p_formula_id IN NUMBER,
19 p_from_status IN VARCHAR2,
20 p_to_status IN VARCHAR2) IS
21 l_signature_status VARCHAR2(40);
22 l_pending_status gmd_status.status_code%TYPE;
23 l_rework_status gmd_status.status_code%TYPE;
24 BEGIN
25 l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
26 GMD_ERES_UTILS.set_formula_status (p_formula_id => p_formula_id
27 ,p_from_status => p_from_status
28 ,p_to_status => p_to_status
29 ,p_signature_status => l_signature_status);
30 END set_formula_status;
31
32 /*======================================================================
33 -- PROCEDURE :
34 -- set_formulation_spec_status
35 --
36 -- DESCRIPTION:
37 -- This PL/SQL procedure is responsible for setting the formulation spec status
38 -- to a given status based on the status of the signature.
39 -- (This is called as a POST-OP API from the approval workflow
40 -- REQUIREMENTS
41 --
42 -- SYNOPSIS:
43 -- set_formulation_spec_status (100, 400, 700);
44 --
45 --===================================================================== */
46 PROCEDURE set_formulation_spec_status(p_formulation_spec_id IN NUMBER,
47 p_from_status IN VARCHAR2,
48 p_to_status IN VARCHAR2) IS
49 l_signature_status VARCHAR2(40);
50 l_pending_status gmd_status.status_code%TYPE;
51 l_rework_status gmd_status.status_code%TYPE;
52 BEGIN
53 l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
54 GMD_ERES_UTILS.set_formulation_spec_status (p_formulation_spec_id => p_formulation_spec_id
55 ,p_from_status => p_from_status
56 ,p_to_status => p_to_status
57 ,p_signature_status => l_signature_status);
58 END set_formulation_spec_status;
59
60 /*======================================================================
61 -- PROCEDURE :
62 -- set_operation_status
63 --
64 -- DESCRIPTION:
65 -- This PL/SQL procedure is responsible for setting the operation status
66 -- to a given status based on the status of the signature.
67 -- (This is called as a POST-OP API from the approval workflow
68 -- REQUIREMENTS
69 --
70 -- SYNOPSIS:
71 -- set_operation_status (100, 400, 700);
72 --
73 --===================================================================== */
74 PROCEDURE set_operation_status(p_oprn_id IN NUMBER,
75 p_from_status IN VARCHAR2,
76 p_to_status IN VARCHAR2) IS
77 l_signature_status VARCHAR2(40);
78 l_pending_status gmd_status.status_code%TYPE;
79 l_rework_status gmd_status.status_code%TYPE;
80 BEGIN
81 l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
82 GMD_ERES_UTILS.set_operation_status (p_oprn_id => p_oprn_id
83 ,p_from_status => p_from_status
84 ,p_to_status => p_to_status
85 ,p_signature_status => l_signature_status);
86 END set_operation_status;
87
88 /*======================================================================
89 -- PROCEDURE :
90 -- set_routing_status
91 --
92 -- DESCRIPTION:
93 -- This PL/SQL procedure is responsible for setting the routing status
94 -- to a given status based on the status of the signature.
95 -- (This is called as a POST-OP API from the approval workflow
96 -- REQUIREMENTS
97 --
98 -- SYNOPSIS:
99 -- set_routing_status (100, 400, 700);
100 --
101 --===================================================================== */
102 PROCEDURE set_routing_status(p_routing_id IN NUMBER,
103 p_from_status IN VARCHAR2,
104 p_to_status IN VARCHAR2) IS
105 l_signature_status VARCHAR2(40);
106 l_pending_status gmd_status.status_code%TYPE;
107 l_rework_status gmd_status.status_code%TYPE;
108 BEGIN
109 l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
110 GMD_ERES_UTILS.set_routing_status (p_routing_id => p_routing_id
111 ,p_from_status => p_from_status
112 ,p_to_status => p_to_status
113 ,p_signature_status => l_signature_status);
114 END set_routing_status;
115
116 /*======================================================================
117 -- PROCEDURE :
118 -- set_recipe_status
119 --
120 -- DESCRIPTION:
121 -- This PL/SQL procedure is responsible for setting the recipe status
122 -- to a given status based on the status of the signature.
123 -- (This is called as a POST-OP API from the approval workflow
124 -- REQUIREMENTS
125 --
126 -- SYNOPSIS:
127 -- set_recipe_status (100, 400, 700);
128 --
129 --===================================================================== */
130 PROCEDURE set_recipe_status(p_recipe_id IN NUMBER,
131 p_from_status IN VARCHAR2,
132 p_to_status IN VARCHAR2,
133 p_create_validity IN NUMBER) IS
134 l_signature_status VARCHAR2(40);
135 l_pending_status gmd_status.status_code%TYPE;
136 l_rework_status gmd_status.status_code%TYPE;
137 BEGIN
138 l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
139 GMD_ERES_UTILS.set_recipe_status (p_recipe_id => p_recipe_id
140 ,p_from_status => p_from_status
141 ,p_to_status => p_to_status
142 ,p_signature_status => l_signature_status
143 ,p_create_validity => p_create_validity);
144 END set_recipe_status;
145
146 /*======================================================================
147 -- PROCEDURE :
148 -- set_validity_status
149 --
150 -- DESCRIPTION:
151 -- This PL/SQL procedure is responsible for setting the validity status
152 -- to a given status based on the status of the signature.
153 -- (This is called as a POST-OP API from the approval workflow
154 -- REQUIREMENTS
155 --
156 -- SYNOPSIS:
157 -- set_validity_status (100, 400, 700);
158 --
159 --===================================================================== */
160 PROCEDURE set_validity_status(p_validity_rule_id IN NUMBER,
161 p_from_status IN VARCHAR2,
162 p_to_status IN VARCHAR2) IS
163 l_signature_status VARCHAR2(40);
164 l_pending_status gmd_status.status_code%TYPE;
165 l_rework_status gmd_status.status_code%TYPE;
166 BEGIN
167 l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
168 GMD_ERES_UTILS.set_validity_status (p_validity_rule_id => p_validity_rule_id
169 ,p_from_status => p_from_status
170 ,p_to_status => p_to_status
171 ,p_signature_status => l_signature_status);
172 END set_validity_status;
173
174 /*======================================================================
175 -- PROCEDURE :
176 -- set_auto_recipe_status
177 --
178 -- DESCRIPTION:
179 -- This PL/SQL procedure is responsible for setting the formula status
180 -- to a given status based on the status of the signature.
181 -- (This is called as a POST-OP API from the approval workflow
182 -- REQUIREMENTS
183 --
184 -- SYNOPSIS:
185 -- set_formula_status (100, 400, 700);
186 -- kkillams 01-DEC-2004 set_auto_recipe_status procedure signature is changed w.r.t. 4004501
187 --===================================================================== */
188 PROCEDURE set_auto_recipe_status(p_formula_id IN NUMBER,
189 p_orgn_id IN NUMBER,
190 p_from_status IN VARCHAR2,
191 p_to_status IN VARCHAR2) IS
192 l_signature_status VARCHAR2(40);
193 l_pending_status gmd_status.status_code%TYPE;
194 l_rework_status gmd_status.status_code%TYPE;
195 BEGIN
196 l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
197 GMD_ERES_UTILS.set_auto_recipe_status (p_formula_id => p_formula_id
198 ,p_orgn_id => p_orgn_id
199 ,p_from_status => p_from_status
200 ,p_to_status => p_to_status
201 ,p_signature_status => l_signature_status);
202 END set_auto_recipe_status;
203
204 -- Bug number 4479101
205 PROCEDURE set_substitution_status(p_substitution_id IN NUMBER,
206 p_from_status IN VARCHAR2,
207 p_to_status IN VARCHAR2)
208 IS
209 l_signature_status VARCHAR2(40);
210 BEGIN
211 l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
212 GMD_ERES_UTILS.set_substitution_status (P_substitution_id => P_substitution_id
213 ,p_from_status => p_from_status
214 ,p_to_status => p_to_status
215 ,p_signature_status => l_signature_status);
216 END set_substitution_status;
217
218 END GMD_ERES_POST_OPERATION;