[Home] [Help]
PACKAGE: APPS.GMD_ERES_UTILS
Source
1 package GMD_ERES_UTILS as
2 /* $Header: GMDERESS.pls 120.7.12000000.2 2007/02/13 12:16:25 kmotupal ship $ */
3
4 PROCEDURE get_operation_no(P_oprn_id IN NUMBER, P_oprn_no OUT NOCOPY VARCHAR2);
5
6 PROCEDURE get_operation_vers(P_oprn_id IN NUMBER,P_oprn_vers OUT NOCOPY NUMBER);
7
8 PROCEDURE get_formula_no(P_formula_id IN NUMBER, P_formula_no OUT NOCOPY VARCHAR2);
9
10 PROCEDURE get_formula_vers(P_formula_id IN NUMBER,P_formula_vers OUT NOCOPY NUMBER);
11
12 PROCEDURE get_formula_desc(P_formula_id IN NUMBER, P_formula_desc OUT NOCOPY VARCHAR2);
13
14 PROCEDURE get_recipe_no(P_recipe_id IN NUMBER, P_recipe_no OUT NOCOPY VARCHAR2);
15
16 PROCEDURE get_recipe_version(P_recipe_id IN NUMBER,P_recipe_version OUT NOCOPY NUMBER);
17
18 PROCEDURE get_routing_no(P_routing_id IN NUMBER, P_routing_no OUT NOCOPY VARCHAR2);
19
20 PROCEDURE get_routing_vers(P_routing_id IN NUMBER,P_routing_vers OUT NOCOPY NUMBER);
21
22 PROCEDURE get_line_type_desc (P_formulaline_id IN NUMBER, P_line_type_desc OUT NOCOPY VARCHAR2);
23
24 PROCEDURE get_status_meaning(P_status_code IN NUMBER, P_meaning OUT NOCOPY VARCHAR2);
25
26 PROCEDURE get_process_qty_um(P_oprn_id IN NUMBER,P_prc_qty_um OUT NOCOPY VARCHAR2);
27
28 PROCEDURE get_activity_desc(p_activity IN VARCHAR2, p_activity_desc OUT NOCOPY VARCHAR2);
29
30 PROCEDURE get_resource_desc(p_resource IN VARCHAR2, p_resource_desc OUT NOCOPY VARCHAR2);
31
32 PROCEDURE get_proc_param_desc(p_parameter_id IN NUMBER, x_parameter_desc OUT NOCOPY VARCHAR2);
33
34 PROCEDURE get_proc_param_units(p_parameter_id IN NUMBER, x_units OUT NOCOPY VARCHAR2);
35
36 PROCEDURE set_formula_status(p_formula_id IN NUMBER,
37 p_from_status IN VARCHAR2,
38 p_to_status IN VARCHAR2,
39 p_signature_status IN VARCHAR2 DEFAULT NULL);
40
41 PROCEDURE set_operation_status(p_oprn_id IN NUMBER,
42 p_from_status IN VARCHAR2,
43 p_to_status IN VARCHAR2,
44 p_signature_status IN VARCHAR2 DEFAULT NULL);
45
46 PROCEDURE set_routing_status(p_routing_id IN NUMBER,
47 p_from_status IN VARCHAR2,
48 p_to_status IN VARCHAR2,
49 p_signature_status IN VARCHAR2 DEFAULT NULL);
50
51 PROCEDURE set_recipe_status(p_recipe_id IN NUMBER,
52 p_from_status IN VARCHAR2,
53 p_to_status IN VARCHAR2,
54 p_signature_status IN VARCHAR2 DEFAULT NULL,
55 p_create_validity IN NUMBER DEFAULT 0);
56
57 PROCEDURE set_validity_status(p_validity_rule_id IN NUMBER,
58 p_from_status IN VARCHAR2,
59 p_to_status IN VARCHAR2,
60 p_signature_status IN VARCHAR2 DEFAULT NULL);
61
62 PROCEDURE set_auto_recipe_status(p_formula_id IN NUMBER,
63 p_orgn_id IN NUMBER,
64 p_from_status IN VARCHAR2,
65 p_to_status IN VARCHAR2,
66 p_signature_status IN VARCHAR2 DEFAULT NULL);
67
68 -- Bug number 4479101
69 PROCEDURE set_substitution_status (p_substitution_id IN NUMBER
70 ,p_from_status IN VARCHAR2
71 ,p_to_status IN VARCHAR2
72 ,p_signature_status IN VARCHAR2 DEFAULT NULL);
73
74 PROCEDURE set_formulation_spec_status(p_formulation_spec_id IN NUMBER,
75 p_from_status IN VARCHAR2,
76 p_to_status IN VARCHAR2,
77 p_signature_status IN VARCHAR2);
78
79
80 FUNCTION check_recipe_validity_eres (p_recipe_id IN NUMBER,
81 p_to_status IN VARCHAR2)
82 RETURN BOOLEAN;
83
84 FUNCTION esig_required (p_event IN VARCHAR2,
85 p_event_key IN VARCHAR2,
86 p_to_status IN VARCHAR2)
87 RETURN BOOLEAN;
88
89 PROCEDURE update_formula_status ( p_formula_id IN VARCHAR2,
90 p_from_status IN VARCHAR2,
91 p_to_status IN VARCHAR2,
92 p_pending_status IN VARCHAR2,
93 p_rework_status IN VARCHAR2,
94 p_object_name IN VARCHAR2,
95 p_object_version IN NUMBER,
96 p_called_from_form IN VARCHAR2 DEFAULT 'F',
97 x_return_status OUT NOCOPY VARCHAR2);
98
99 PROCEDURE update_operation_status( p_oprn_id IN VARCHAR2,
100 p_from_status IN VARCHAR2,
101 p_to_status IN VARCHAR2,
102 p_pending_status IN VARCHAR2,
103 p_rework_status IN VARCHAR2,
104 p_object_name IN VARCHAR2,
105 p_object_version IN NUMBER,
106 p_called_from_form IN VARCHAR2 DEFAULT 'F',
107 x_return_status OUT NOCOPY VARCHAR2);
108
109 PROCEDURE update_routing_status ( p_routing_id IN VARCHAR2,
110 p_from_status IN VARCHAR2,
111 p_to_status IN VARCHAR2,
112 p_pending_status IN VARCHAR2,
113 p_rework_status IN VARCHAR2,
114 p_object_name IN VARCHAR2,
115 p_object_version IN NUMBER,
116 p_called_from_form IN VARCHAR2 DEFAULT 'F',
117 x_return_status OUT NOCOPY VARCHAR2);
118
119 PROCEDURE update_recipe_status ( p_recipe_id IN VARCHAR2,
120 p_from_status IN VARCHAR2,
121 p_to_status IN VARCHAR2,
122 p_pending_status IN VARCHAR2,
123 p_rework_status IN VARCHAR2,
124 p_object_name IN VARCHAR2,
125 p_object_version IN NUMBER,
126 p_called_from_form IN VARCHAR2 DEFAULT 'F',
127 x_return_status OUT NOCOPY VARCHAR2);
128
129 PROCEDURE update_validity_rule_status ( p_validity_rule_id IN VARCHAR2,
130 p_from_status IN VARCHAR2,
131 p_to_status IN VARCHAR2,
132 p_pending_status IN VARCHAR2,
133 p_rework_status IN VARCHAR2,
134 p_called_from_form IN VARCHAR2 DEFAULT 'F',
135 x_return_status OUT NOCOPY VARCHAR2);
136 -- Bug 5394532
137 PROCEDURE update_substitution_status (p_substitution_id IN NUMBER,
138 p_from_status IN VARCHAR2,
139 p_to_status IN VARCHAR2,
140 p_pending_status IN VARCHAR2,
141 p_rework_status IN VARCHAR2,
142 p_called_from_form IN VARCHAR2 DEFAULT 'F',
143 x_return_status OUT NOCOPY VARCHAR2);
144
145 /*Thomas Daniel - The raise event procedure has been moved to GMD_EDR_STANDARD */
146 /*PROCEDURE raise_event (p_event_name in varchar2,
147 p_event_key in varchar2,
148 p_parameter_name1 in varchar2 default NULL,
149 p_parameter_value1 in varchar2 default NULL,
150 p_parameter_name2 in varchar2 default NULL,
151 p_parameter_value2 in varchar2 default NULL,
152 p_parameter_name3 in varchar2 default NULL,
153 p_parameter_value3 in varchar2 default NULL,
154 p_parameter_name4 in varchar2 default NULL,
155 p_parameter_value4 in varchar2 default NULL,
156 p_parameter_name5 in varchar2 default NULL,
157 p_parameter_value5 in varchar2 default NULL,
158 p_parameter_name6 in varchar2 default NULL,
159 p_parameter_value6 in varchar2 default NULL,
160 p_parameter_name7 in varchar2 default NULL,
161 p_parameter_value7 in varchar2 default NULL,
162 p_parameter_name8 in varchar2 default NULL,
163 p_parameter_value8 in varchar2 default NULL,
164 p_parameter_name9 in varchar2 default NULL,
165 p_parameter_value9 in varchar2 default NULL,
166 p_parameter_name10 in varchar2 default NULL,
167 p_parameter_value10 in varchar2 default NULL);*/
168
169 PROCEDURE get_recipe_details (
170 P_formula_id IN NUMBER,
171 P_recipe_no OUT NOCOPY VARCHAR2,
172 P_recipe_vers OUT NOCOPY NUMBER,
173 P_recipe_desc OUT NOCOPY VARCHAR2,
174 P_recipe_status OUT NOCOPY VARCHAR2,
175 P_recipe_type OUT NOCOPY NUMBER );
176
177 PROCEDURE get_validity_details (
178 P_formula_id IN NUMBER,
179 p_orgn_id OUT NOCOPY NUMBER, -- Krishna NPD Conv
180 P_item_id OUT NOCOPY NUMBER,
181 --p_revision OUT NOCOPY NUMBER, -- Krishna NPD Conv --commented for bug #5218333
182 p_revision OUT NOCOPY VARCHAR2,
183 P_item_um OUT NOCOPY VARCHAR2,
184 P_min_qty OUT NOCOPY NUMBER,
185 P_max_qty OUT NOCOPY NUMBER,
186 P_std_qty OUT NOCOPY NUMBER,
187 P_inv_min_qty OUT NOCOPY NUMBER,
188 P_inv_max_qty OUT NOCOPY NUMBER,
189 P_min_eff_date OUT NOCOPY DATE,
190 P_max_eff_date OUT NOCOPY DATE,
191 P_recipe_use OUT NOCOPY VARCHAR2,
192 P_preference OUT NOCOPY NUMBER,
193 P_validity_rule_status OUT NOCOPY VARCHAR2 );
194
195 --Krishna 10-Feb-2005 NPD Convergence,
196 --Created procedures GET_ORGANIZATION_CODE,GET_ITEM_NO_DESC and GET_LOOKUP_VALUE for to migrate GMI procedure calls to GMD_ERES_UTILS package.
197 PROCEDURE get_organization_code
198 ( p_orgn_id IN NUMBER,
199 p_orgn_code OUT NOCOPY VARCHAR2);
200
201 PROCEDURE get_item_no_desc
202 ( pitem_id IN NUMBER,
203 porgn_id IN NUMBER,
204 pitem_no OUT NOCOPY VARCHAR2,
205 pitem_desc OUT NOCOPY VARCHAR2 );
206
207 PROCEDURE get_lookup_value (
208 plookup_type IN VARCHAR2,
209 plookup_code IN VARCHAR2,
210 pmeaning OUT NOCOPY VARCHAR2);
211
212 PROCEDURE get_tech_parm_name(P_tech_parm_id IN NUMBER, P_tech_parm_name OUT NOCOPY VARCHAR2,
213 P_unit_code OUT NOCOPY VARCHAR2);
214
215 PROCEDURE get_category_name(P_category_id IN NUMBER, P_category_name OUT NOCOPY VARCHAR2);
216
217 PROCEDURE get_category_set_name(P_category_set_id IN NUMBER, P_category_set_name OUT NOCOPY VARCHAR2);
218
219 PROCEDURE get_formula_line_no(P_formulaline_id IN NUMBER,P_formulaline_no OUT NOCOPY NUMBER);
220
221 -- Kapil LCF-GMO ME Bug# 5456888
222 -- To get Routing details
223 PROCEDURE get_routing_details_eres (
224 P_doc_id IN VARCHAR2,
225 P_routing_no OUT NOCOPY VARCHAR2,
226 P_routing_vers OUT NOCOPY NUMBER,
227 P_routing_desc OUT NOCOPY VARCHAR2,
228 P_routing_status OUT NOCOPY VARCHAR2,
229 P_enhancd_PI_ind OUT NOCOPY VARCHAR2 );
230
231 -- Kapil ME Auto-Prod : Bug# 5716318
232 PROCEDURE get_yes_no_value (
233 plookup_code IN VARCHAR2,
234 pmeaning OUT NOCOPY VARCHAR2);
235 end GMD_ERES_UTILS;