1 PACKAGE GMD_RECIPE_FETCH_PUB AS
2 /* $Header: GMDPRCFS.pls 120.4.12010000.1 2008/07/24 09:56:53 appldev ship $ */
3 /*#
4 * This interface is used to fetch information related to recipes like
5 * recipe id, formula id, routing id, routing step details, step dependencies,
6 * operation activity and resource details, process parameters etc.
7 * This package defines and implements the procedures and datatypes
8 * required to fetch the above mentioned information.
9 * @rep:scope public
10 * @rep:product GMD
11 * @rep:lifecycle active
12 * @rep:displayname Recipe Fetch package
13 * @rep:compatibility S
14 * @rep:category BUSINESS_ENTITY GMD_RECIPE
15 */
16
17
18
19 TYPE recipe_validity_tbl IS TABLE OF gmd_recipe_validity_rules%rowtype
20 INDEX BY BINARY_INTEGER;
21
22 TYPE recipe_rout_matl_tbl IS TABLE OF gmd_recipe_step_materials%rowtype
23 INDEX BY BINARY_INTEGER;
24
25 TYPE recipe_form_matl_tbl IS TABLE OF fm_matl_dtl%rowtype
26 INDEX BY BINARY_INTEGER;
27
28 TYPE routing_depd_tbl IS TABLE OF fm_rout_dep%rowtype
29 INDEX BY BINARY_INTEGER;
30
31 TYPE recipe_rout_tbl IS TABLE OF fm_rout_hdr%rowtype
32 INDEX BY BINARY_INTEGER;
33
34
35 TYPE recipe_step_out IS RECORD
36
37 (recipe_id gmd_recipes.recipe_id%type ,
38 rowid varchar2(18) ,
39 routingstep_no fm_rout_dtl.routingstep_no%type ,
40 routingstep_id fm_rout_dtl.routingstep_id%type ,
41 step_qty fm_rout_dtl.step_qty%type ,
42 steprelease_type fm_rout_dtl.steprelease_type%type ,
43 minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type,
44 oprn_id gmd_operations_vl.oprn_id%type ,
45 oprn_no gmd_operations_vl.oprn_no%type ,
46 oprn_desc gmd_operations_vl.oprn_desc%type ,
47 oprn_vers gmd_operations_vl.oprn_vers%type ,
48 process_qty_uom gmd_operations_vl.process_qty_uom%type ,
49 max_capacity cr_rsrc_mst.max_capacity%type ,
50 capacity_uom cr_rsrc_dtl.capacity_um%type ,
51 /* Bug 1683702 Thomas Daniel */
52 /* Added the charges column to the table to be able to pass back */
53 /* the charges also in the recipe step detail fetch */
54 charge integer ,
55 text_code fm_rout_dtl.text_code%type ,
56 creation_date fm_rout_dtl.creation_date%type ,
57 created_by fm_rout_dtl.created_by%type ,
58 last_updated_by fm_rout_dtl.last_updated_by%type ,
59 last_update_date fm_rout_dtl.last_update_date%type ,
60 last_update_login fm_rout_dtl.last_update_login%type ,
61 attribute_category fm_rout_dtl.attribute_category%type ,
62 attribute1 fm_rout_dtl.attribute1%type ,
63 attribute2 fm_rout_dtl.attribute2%type ,
64 attribute3 fm_rout_dtl.attribute3%type ,
65 attribute4 fm_rout_dtl.attribute4%type ,
66 attribute5 fm_rout_dtl.attribute5%type ,
67 attribute6 fm_rout_dtl.attribute6%type ,
68 attribute7 fm_rout_dtl.attribute7%type ,
69 attribute8 fm_rout_dtl.attribute8%type ,
70 attribute9 fm_rout_dtl.attribute9%type ,
71 attribute10 fm_rout_dtl.attribute10%type ,
72 attribute11 fm_rout_dtl.attribute11%type ,
73 attribute12 fm_rout_dtl.attribute12%type ,
74 attribute13 fm_rout_dtl.attribute13%type ,
75 attribute14 fm_rout_dtl.attribute14%type ,
76 attribute15 fm_rout_dtl.attribute15%type ,
77 attribute16 fm_rout_dtl.attribute16%type ,
78 attribute17 fm_rout_dtl.attribute17%type ,
79 attribute18 fm_rout_dtl.attribute18%type ,
80 attribute19 fm_rout_dtl.attribute19%type ,
81 attribute20 fm_rout_dtl.attribute20%type ,
82 attribute21 fm_rout_dtl.attribute21%type ,
83 attribute22 fm_rout_dtl.attribute22%type ,
84 attribute23 fm_rout_dtl.attribute23%type ,
85 attribute24 fm_rout_dtl.attribute24%type ,
86 attribute25 fm_rout_dtl.attribute25%type ,
87 attribute26 fm_rout_dtl.attribute26%type ,
88 attribute27 fm_rout_dtl.attribute27%type ,
89 attribute28 fm_rout_dtl.attribute28%type ,
90 attribute29 fm_rout_dtl.attribute29%type ,
91 attribute30 fm_rout_dtl.attribute30%type ,
92 /* Bug 3612365 Thomas Daniel */
93 /* Added the Resources column to the table to be able to pass back */
94 /* the resource causing the charge to recipe step detail fetch */
95 resources gmd_operation_resources.resources%type
96 );
97 TYPE recipe_step_tbl IS TABLE OF recipe_step_out
98 INDEX BY BINARY_INTEGER;
99
100 /* Bug 2560037 S.Dulyk 20-SEP-2002 Added minimum_transfer_qty */
101 TYPE routing_step_out IS RECORD
102
103 (
104 routing_id fm_rout_dtl.routing_id%type ,
105 routingstep_no fm_rout_dtl.routingstep_no%type ,
106 routingstep_id fm_rout_dtl.routingstep_id%type ,
107 step_qty fm_rout_dtl.step_qty%type ,
108 steprelease_type fm_rout_dtl.steprelease_type%type ,
109 oprn_id fm_rout_dtl.oprn_id%type ,
110 oprn_no gmd_operations_vl.oprn_no%type ,
111 oprn_desc gmd_operations_vl.oprn_desc%type ,
112 oprn_vers gmd_operations_vl.oprn_vers%type ,
113 process_qty_uom gmd_operations_vl.process_qty_uom%type ,
114 minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type ,
115 max_capacity cr_rsrc_mst.max_capacity%type ,
116 capacity_uom cr_rsrc_dtl.capacity_um%type ,
117 text_code fm_rout_dtl.text_code%type ,
118 creation_date fm_rout_dtl.creation_date%type ,
119 created_by fm_rout_dtl.created_by%type ,
120 last_updated_by fm_rout_dtl.last_updated_by%type ,
121 last_update_date fm_rout_dtl.last_update_date%type ,
122 last_update_login fm_rout_dtl.last_update_login%type ,
123 attribute_category fm_rout_dtl.attribute_category%type ,
124 attribute1 fm_rout_dtl.attribute1%type ,
125 attribute2 fm_rout_dtl.attribute2%type ,
126 attribute3 fm_rout_dtl.attribute3%type ,
127 attribute4 fm_rout_dtl.attribute4%type ,
128 attribute5 fm_rout_dtl.attribute5%type ,
129 attribute6 fm_rout_dtl.attribute6%type ,
130 attribute7 fm_rout_dtl.attribute7%type ,
131 attribute8 fm_rout_dtl.attribute8%type ,
132 attribute9 fm_rout_dtl.attribute9%type ,
133 attribute10 fm_rout_dtl.attribute10%type ,
134 attribute11 fm_rout_dtl.attribute11%type ,
135 attribute12 fm_rout_dtl.attribute12%type ,
136 attribute13 fm_rout_dtl.attribute13%type ,
137 attribute14 fm_rout_dtl.attribute14%type ,
138 attribute15 fm_rout_dtl.attribute15%type ,
139 attribute16 fm_rout_dtl.attribute16%type ,
140 attribute17 fm_rout_dtl.attribute17%type ,
141 attribute18 fm_rout_dtl.attribute18%type ,
142 attribute19 fm_rout_dtl.attribute19%type ,
143 attribute20 fm_rout_dtl.attribute20%type ,
144 attribute21 fm_rout_dtl.attribute21%type ,
145 attribute22 fm_rout_dtl.attribute22%type ,
146 attribute23 fm_rout_dtl.attribute23%type ,
147 attribute24 fm_rout_dtl.attribute24%type ,
148 attribute25 fm_rout_dtl.attribute25%type ,
149 attribute26 fm_rout_dtl.attribute26%type ,
150 attribute27 fm_rout_dtl.attribute27%type ,
151 attribute28 fm_rout_dtl.attribute28%type ,
152 attribute29 fm_rout_dtl.attribute29%type ,
153 attribute30 fm_rout_dtl.attribute30%type
154 );
155
156 TYPE routing_step_tbl IS TABLE OF routing_step_out
157 INDEX BY BINARY_INTEGER;
158
159 TYPE oprn_act_out IS RECORD
160 ( recipe_id gmd_recipes.recipe_id%type ,
161 routingstep_id fm_rout_dtl.routingstep_id%type ,
162 routingstep_no fm_rout_dtl.routingstep_no%type ,
163 oprn_no gmd_operations_vl.oprn_no%type ,
164 oprn_vers gmd_operations_vl.oprn_vers%type ,
165 oprn_desc gmd_operations_vl.oprn_desc%type ,
166 oprn_id gmd_operations_vl.oprn_id%type ,
167 minimum_transfer_qty gmd_operations_b.minimum_transfer_qty%type ,
168 oprn_line_id gmd_operation_resources.oprn_line_id%type ,
169 activity gmd_operation_activities.activity%type ,
170 activity_desc fm_actv_mst.activity_desc%type ,
171 activity_factor gmd_operation_activities.activity_factor%type ,
172 sequence_dependent_ind gmd_operation_activities.sequence_dependent_ind%type ,
173 recipe_override NUMBER(5) ,
174 offset_interval gmd_operation_activities.offset_interval%type ,
175 break_ind gmd_operation_activities.break_ind%type,
176 max_break gmd_operation_activities.max_break%type DEFAULT NULL,
177 material_ind gmd_operation_activities.material_ind%type,
178 text_code gmd_operation_resources.text_code%type ,
179 created_by gmd_operation_resources.created_by%type ,
180 last_updated_by gmd_operation_resources.last_updated_by%type ,
181 last_update_date gmd_operation_resources.last_update_date%type ,
182 creation_date gmd_operation_resources.creation_date%type ,
183 last_update_login gmd_operation_resources.last_update_login%type ,
184 attribute_category gmd_operation_resources.attribute_category%type ,
185 attribute1 gmd_operation_resources.attribute1%type ,
186 attribute2 gmd_operation_resources.attribute2%type ,
187 attribute3 gmd_operation_resources.attribute3%type ,
188 attribute4 gmd_operation_resources.attribute4%type ,
189 attribute5 gmd_operation_resources.attribute5%type ,
190 attribute6 gmd_operation_resources.attribute6%type ,
191 attribute7 gmd_operation_resources.attribute7%type ,
192 attribute8 gmd_operation_resources.attribute8%type ,
193 attribute9 gmd_operation_resources.attribute9%type ,
194 attribute10 gmd_operation_resources.attribute10%type ,
195 attribute11 gmd_operation_resources.attribute11%type ,
196 attribute12 gmd_operation_resources.attribute12%type ,
197 attribute13 gmd_operation_resources.attribute13%type ,
198 attribute14 gmd_operation_resources.attribute14%type ,
199 attribute15 gmd_operation_resources.attribute15%type ,
200 attribute16 gmd_operation_resources.attribute16%type ,
201 attribute17 gmd_operation_resources.attribute17%type ,
202 attribute18 gmd_operation_resources.attribute18%type ,
203 attribute19 gmd_operation_resources.attribute19%type ,
204 attribute20 gmd_operation_resources.attribute20%type ,
205 attribute21 gmd_operation_resources.attribute21%type ,
206 attribute22 gmd_operation_resources.attribute22%type ,
207 attribute23 gmd_operation_resources.attribute23%type ,
208 attribute24 gmd_operation_resources.attribute24%type ,
209 attribute25 gmd_operation_resources.attribute25%type ,
210 attribute26 gmd_operation_resources.attribute26%type ,
211 attribute27 gmd_operation_resources.attribute27%type ,
212 attribute28 gmd_operation_resources.attribute28%type ,
213 attribute29 gmd_operation_resources.attribute29%type ,
214 attribute30 gmd_operation_resources.attribute30%type
215
216 );
217
218 TYPE oprn_act_tbl IS TABLE OF oprn_act_out
219 INDEX BY BINARY_INTEGER;
220
221
222
223
224
225 /* BUG#2621411 RajaSekhar Added capacity_tolerance field */
226
227 TYPE oprn_resc_rec IS RECORD
228 (
229 recipe_id gmd_recipes.recipe_id%type ,
230 routingstep_id fm_rout_dtl.routingstep_id%type ,
231 routingstep_no fm_rout_dtl.routingstep_no%type ,
232 oprn_id gmd_operations_vl.oprn_id%type ,
233 oprn_no gmd_operations_vl.oprn_no%type ,
234 oprn_vers gmd_operations_vl.oprn_vers%type ,
235 oprn_desc gmd_operations_vl.oprn_desc%type ,
236 activity gmd_operation_activities.activity%type ,
237 oprn_line_id gmd_operation_resources.oprn_line_id%type ,
238 resources gmd_operation_resources.resources%type ,
239 resource_usage gmd_operation_resources.resource_usage%type ,
240 resource_count gmd_operation_resources.resource_count%type ,
241 process_qty gmd_operation_resources.process_qty%type ,
242 process_uom gmd_operation_resources.resource_process_uom%type ,
243 prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
244 scale_type gmd_operation_resources.scale_type%type ,
245 cost_analysis_code gmd_operation_resources.cost_analysis_code%type ,
246 cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%type ,
247 usage_um gmd_operation_resources.resource_usage_uom%type ,
248 offset_interval gmd_operation_resources.offset_interval%type ,
249 max_capacity cr_rsrc_mst.max_capacity%type ,
250 min_capacity cr_rsrc_mst.min_capacity%type ,
251 capacity_constraint cr_rsrc_mst.capacity_constraint%type ,
252 capacity_tolerance cr_rsrc_dtl.capacity_tolerance%type ,
253 capacity_uom cr_rsrc_dtl.capacity_um%type,
254
255 process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
256 process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
257 process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
258 process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
259 process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
260
261 recipe_override NUMBER(5) ,
262 text_code gmd_operation_resources.text_code%type ,
263 created_by gmd_operation_resources.created_by%type ,
264 last_updated_by gmd_operation_resources.last_updated_by%type ,
265 last_update_date gmd_operation_resources.last_update_date%type ,
266 creation_date gmd_operation_resources.creation_date%type ,
267 last_update_login gmd_operation_resources.last_update_login%type ,
268 attribute_category gmd_operation_resources.attribute_category%type ,
269 attribute1 gmd_operation_resources.attribute1%type ,
270 attribute2 gmd_operation_resources.attribute2%type ,
271 attribute3 gmd_operation_resources.attribute3%type ,
272 attribute4 gmd_operation_resources.attribute4%type ,
273 attribute5 gmd_operation_resources.attribute5%type ,
274 attribute6 gmd_operation_resources.attribute6%type ,
275 attribute7 gmd_operation_resources.attribute7%type ,
276 attribute8 gmd_operation_resources.attribute8%type ,
277 attribute9 gmd_operation_resources.attribute9%type ,
278 attribute10 gmd_operation_resources.attribute10%type ,
279 attribute11 gmd_operation_resources.attribute11%type ,
280 attribute12 gmd_operation_resources.attribute12%type ,
281 attribute13 gmd_operation_resources.attribute13%type ,
282 attribute14 gmd_operation_resources.attribute14%type ,
283 attribute15 gmd_operation_resources.attribute15%type ,
284 attribute16 gmd_operation_resources.attribute16%type ,
285 attribute17 gmd_operation_resources.attribute17%type ,
286 attribute18 gmd_operation_resources.attribute18%type ,
287 attribute19 gmd_operation_resources.attribute19%type ,
288 attribute20 gmd_operation_resources.attribute20%type ,
289 attribute21 gmd_operation_resources.attribute21%type ,
290 attribute22 gmd_operation_resources.attribute22%type ,
291 attribute23 gmd_operation_resources.attribute23%type ,
292 attribute24 gmd_operation_resources.attribute24%type ,
293 attribute25 gmd_operation_resources.attribute25%type ,
294 attribute26 gmd_operation_resources.attribute26%type ,
295 attribute27 gmd_operation_resources.attribute27%type ,
296 attribute28 gmd_operation_resources.attribute28%type ,
297 attribute29 gmd_operation_resources.attribute29%type ,
298 attribute30 gmd_operation_resources.attribute30%type
299
300 );
301 TYPE oprn_resc_tbl IS TABLE OF oprn_resc_rec
302 INDEX BY BINARY_INTEGER;
303
304
305 TYPE recp_resc_proc_param_rec IS RECORD
306 (
307 recipe_id gmd_recipes.recipe_id%type ,
308 routingstep_id fm_rout_dtl.routingstep_id%type ,
309 routingstep_no fm_rout_dtl.routingstep_no%type ,
310 oprn_line_id gmd_operation_resources.oprn_line_id%type ,
311 resources gmd_operation_resources.resources%type ,
312 parameter_id gmp_process_parameters.parameter_id%type ,
313 parameter_name gmp_process_parameters.parameter_name%type ,
314 parameter_description gmp_process_parameters.parameter_description%type ,
315 units gmp_process_parameters.units%type ,
316 target_value gmd_recipe_process_parameters.target_value%type ,
317 minimum_value NUMBER ,
318 maximum_value NUMBER ,
319 parameter_type gmp_process_parameters.parameter_type%type ,
320 sequence_no gmp_resource_parameters.sequence_no%type ,
321 created_by gmd_recipe_process_parameters.created_by%type ,
322 last_updated_by gmd_recipe_process_parameters.last_updated_by%type ,
323 last_update_date gmd_recipe_process_parameters.last_update_date%type ,
324 creation_date gmd_recipe_process_parameters.creation_date%type ,
325 last_update_login gmd_recipe_process_parameters.last_update_login%type ,
326 recipe_override NUMBER(5)
327 );
328
329 TYPE recp_resc_proc_param_tbl IS TABLE OF recp_resc_proc_param_rec
330 INDEX BY BINARY_INTEGER;
331
332
333 -- Start of commments
334 -- API name : get_validity_rules
335 -- Type : Public
336 -- Function :
337 -- Paramaters :
338 -- IN : p_api_version IN NUMBER Required
339 -- p_init_msg_list IN Varchar2 Optional
340 --
341 -- p_recipe_no IN Varchar2
342 -- p_recipe_version IN Number
343 -- p_item_no IN Varchar2
344 -- p_orgn_code IN Varchar2
345 -- p_recipe_qty IN Number
346 -- P_recipe_id IN Number
347 -- x_return_status OUT NOCOPY varchar2(1)
348 -- x_msg_count OUT NOCOPY Number
349 -- x_msg_data OUT NOCOPY varchar2(2000)
350 -- x_return_code OUT NOCOPY NUMBER
351 -- x_recipe_validity_tbl OUT NOCOPY recipe_validity_tbl
352 -- Version : Current Version 1.0
353 --
354 -- Notes :
355 -- End of comments
356
357 /*
358 PROCEDURE get_validity_rules
359 ( p_api_version IN NUMBER ,
360 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
361 p_recipe_id IN NUMBER ,
362 p_item_id IN NUMBER ,
363 p_orgn_code IN Varchar2 ,
364 p_product_qty IN NUMBER ,
365 p_recipe_use IN VARCHAR2 ,
366 x_return_status OUT NOCOPY VARCHAR2 ,
367 x_msg_count OUT NOCOPY NUMBER ,
368 x_msg_data OUT NOCOPY VARCHAR2 ,
369 x_return_code OUT NOCOPY NUMBER ,
370 X_recipe_validity_tbl OUT NOCOPY recipe_validity_tbl
371 ); */
372
373
374 -- Start of commments
375 -- API name : get_recipe_id
376 -- Type : Private
377 -- Function :
378 -- Paramaters :
379 -- IN : p_api_version IN NUMBER Required
380 -- p_init_msg_list IN Varchar2 Optional
381 --
382 -- p_recipe_validity_rule_id IN NUMBER
383 -- p_delete_mark IN NUMBER Required
384 --
385 -- x_return_status OUT NOCOPY varchar2(1)
386 -- x_msg_count OUT NOCOPY Number
387 -- x_msg_data OUT NOCOPY varchar2(2000)
388 -- x_recipe_id OUT NOCOPY NUMBER
389 -- Version : Current Version 1.0
390 --
391 -- Notes :
392 --
396 * Fetches the recipe id
393 -- End of comments
394
395 /*#
397 * This is a PL/SQL procedure to fetch recipe_id from gmd_recipe_validity_rules
398 * based on the validity_rule_id passed
399 * @param p_api_version API version field
400 * @param p_init_msg_list Flag to check if message list intialized
401 * @param p_recipe_validity_rule_id Vailidity Rule ID
402 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
403 * @param x_msg_count Number of msg's on message stack
404 * @param x_msg_data Actual message data on message stack
405 * @param x_return_code SQLCODE returned
406 * @param x_recipe_id Recipe ID for the corresponding Validity Rule ID passed
407 * @rep:scope public
408 * @rep:lifecycle active
409 * @rep:displayname Fetch Recipe ID procedure
410 * @rep:compatibility S
411 */
412 PROCEDURE get_recipe_id
413 ( p_api_version IN NUMBER ,
414 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
415 p_recipe_validity_rule_id IN NUMBER ,
416 x_return_status OUT NOCOPY VARCHAR2 ,
417 x_msg_count OUT NOCOPY NUMBER ,
418 x_msg_data OUT NOCOPY VARCHAR2 ,
419 x_return_code OUT NOCOPY NUMBER ,
420 x_recipe_id OUT NOCOPY NUMBER
421 );
422
423
424 -- Start of commments
425 -- API name : get_routing_id
426 -- Type : Private
427 -- Function :
428 -- Paramaters :
429 -- IN : p_api_version IN NUMBER Required
430 -- p_init_msg_list IN Varchar2 Optional
431 --
432 -- p_recipe_no IN Varchar2
433 -- p_recipe_version IN Varchar2
434 -- p_recipe_id IN NUMBER
435 -- p_delete_mark IN NUMBER Required
436 --
437 -- x_return_status OUT NOCOPY varchar2(1)
438 -- x_msg_count OUT NOCOPY Number
439 -- x_msg_data OUT NOCOPY varchar2(2000)
440 -- x_routing_id OUT NOCOPY NUMBER
441 -- Version : Current Version 1.0
442 --
443 -- Notes :
444 --
445 -- End of comments
446
447 /*#
448 * Fetches the routing id
449 * This is a PL/SQL procedure to return the routing_id attached to the recipe_id
450 * @param p_api_version API version field
451 * @param p_init_msg_list Flag to check if message list intialized
452 * @param p_recipe_no Recipe Number field
453 * @param p_recipe_version Version of the Recipe
454 * @param p_recipe_id ID of the Recipe
455 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
456 * @param x_msg_count Number of msg's on message stack
457 * @param x_msg_data Actual message data on message stack
458 * @param x_return_code SQLCODE returned
459 * @param x_routing_id Routing ID corresponding to the Recipe ID passed
460 * @rep:scope public
461 * @rep:lifecycle active
462 * @rep:displayname Fetch Routing ID procedure
463 * @rep:compatibility S
464 */
465 PROCEDURE get_routing_id
466 ( p_api_version IN NUMBER ,
467 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
468 p_recipe_no IN Varchar2 ,
469 p_recipe_version IN NUMBER ,
470 p_recipe_id IN NUMBER ,
471 x_return_status OUT NOCOPY VARCHAR2 ,
472 x_msg_count OUT NOCOPY NUMBER ,
473 x_msg_data OUT NOCOPY VARCHAR2 ,
474 x_return_code OUT NOCOPY NUMBER ,
475 x_routing_id OUT NOCOPY NUMBER
476 );
477 -- Start of commments
478 -- API name : get_rout_hdr
479 -- Type : Private
480 -- Function :
481 -- Paramaters :
482 -- IN : p_api_version IN NUMBER Required
483 -- p_init_msg_list IN Varchar2 Optional
484 --
485 -- p_recipe_id IN NUMBER
486 -- x_return_status OUT NOCOPY varchar2(1)
487 -- x_msg_count OUT NOCOPY Number
488 -- x_msg_data OUT NOCOPY varchar2(2000)
489 -- x_return_code OUT NOCOPY number
490 -- x_rout_out OUT NOCOPY NUMBER
491 -- Version : Current Version 1.0
492 --
493 -- Notes :
494 --
495 -- End of comments
496
497 /*#
498 * Fetches the routing header information
499 * This is a PL/SQL procedure to fetch the total routing header
500 * information based on the recipe_id passed to it
501 * @param p_api_version API version field
502 * @param p_init_msg_list Flag to check if message list intialized
503 * @param p_recipe_id ID of the Recipe
504 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
505 * @param x_msg_count Number of msg's on message stack
506 * @param x_msg_data Actual message data on message stack
507 * @param x_return_code SQLCODE returned
508 * @param x_rout_out Table structure of Recipe header to return header information
512 * @rep:compatibility S
509 * @rep:scope public
510 * @rep:lifecycle active
511 * @rep:displayname Fetch Routing Header procedure
513 */
514 PROCEDURE get_rout_hdr
515 ( p_api_version IN NUMBER ,
516 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
517 p_recipe_id IN NUMBER ,
518 x_return_status OUT NOCOPY VARCHAR2 ,
519 x_msg_count OUT NOCOPY NUMBER ,
520 x_msg_data OUT NOCOPY VARCHAR2 ,
521 x_return_code OUT NOCOPY NUMBER ,
522 x_rout_out OUT NOCOPY recipe_rout_tbl
523 );
524
525 -- Start of commments
526 -- API name : get_formula_id
527 -- Type : Private
528 -- Function :
529 -- Paramaters :
530 -- IN : p_api_version IN NUMBER Required
531 -- p_init_msg_list IN Varchar2 Optional
532 --
533 -- p_recipe_no IN Varchar2
534 -- p_recipe_version IN Varchar2
535 -- p_recipe_id IN NUMBER
536 -- p_delete_mark IN NUMBER Required
537 --
538 -- x_return_status OUT NOCOPY varchar2(1)
539 -- x_msg_count OUT NOCOPY Number
540 -- x_msg_data OUT NOCOPY varchar2(2000)
541 -- x_formula_id OUT NOCOPY NUMBER
542 -- Version : Current Version 1.0
543 --
544 -- Notes :
545 --
546 -- End of comments
547 /* Bug 2411810 - Thomas Daniel */
548 /* Added the default values which was present in the body to the spec */
549
550 /*#
551 * Fetches the formula id
552 * This is a PL/SQL procedure to return the formula_id based on the
553 * recipe_id passed to it
554 * @param p_api_version API version field
555 * @param p_init_msg_list Flag to check if message list intialized
556 * @param p_recipe_no Recipe Number field
557 * @param p_recipe_version Version of the Recipe
558 * @param p_recipe_id ID of the Recipe
559 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
560 * @param x_msg_count Number of msg's on message stack
561 * @param x_msg_data Actual message data on message stack
562 * @param x_return_code SQLCODE returned
563 * @param x_formula_id Formula ID corresponding the Recipe ID passed
564 * @rep:scope public
565 * @rep:lifecycle active
566 * @rep:displayname Fetch Formula ID procedure
567 * @rep:compatibility S
568 */
569 PROCEDURE get_formula_id
570 ( p_api_version IN NUMBER ,
571 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
572 p_recipe_no IN Varchar2 := NULL ,
573 p_recipe_version IN NUMBER := NULL ,
574 p_recipe_id IN NUMBER ,
575 x_return_status OUT NOCOPY VARCHAR2 ,
576 x_msg_count OUT NOCOPY NUMBER ,
577 x_msg_data OUT NOCOPY VARCHAR2 ,
578 x_return_code OUT NOCOPY NUMBER ,
579 x_formula_id OUT NOCOPY NUMBER
580 );
581
582 -- Start of commments
583 -- API name : get_rout_material
584 -- Type : Public
585 -- Function :
586 -- Paramaters :
587 -- IN : p_api_version IN NUMBER Required
588 -- p_init_msg_list IN Varchar2 Optional
589 --
590 -- p_recipe_no IN Varchar2
591 -- p_recipe_version IN NUMBER
592 -- p_recipe_id IN number
593 --
594 --
595 --
596 -- x_return_status OUT NOCOPY varchar2(1)
597 -- x_msg_count OUT NOCOPY Number
598 -- x_msg_data OUT NOCOPY varchar2(2000)
599 -- x_recipe_rout_matl_tbl OUT NOCOPY recipe_rout_matl_tbl
600 -- Version : Current Version 1.0
601 --
602 -- Notes :
603 -- End of comments
604
605 /*#
606 * Fetches the material - step information
607 * This is a PL/SQL procedure to return the material - step information
608 * based on the Recipe ID passed to it
609 * @param p_api_version API version field
610 * @param p_init_msg_list Flag to check if message list intialized
611 * @param p_recipe_id ID of the Recipe
612 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
613 * @param x_msg_count Number of msg's on message stack
614 * @param x_msg_data Actual message data on message stack
615 * @param x_return_code SQLCODE returned
616 * @param x_recipe_rout_matl_tbl Table structure of routing material table
617 * @rep:scope public
618 * @rep:lifecycle active
619 * @rep:displayname Fetch Routing material-step procedure
620 * @rep:compatibility S
621 */
622 PROCEDURE get_rout_material
623 ( p_api_version IN NUMBER ,
624 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
625 p_recipe_id IN NUMBER ,
626 x_return_status OUT NOCOPY VARCHAR2 ,
630 x_recipe_rout_matl_tbl OUT NOCOPY recipe_rout_matl_tbl
627 x_msg_count OUT NOCOPY NUMBER ,
628 x_msg_data OUT NOCOPY VARCHAR2 ,
629 x_return_code OUT NOCOPY NUMBER ,
631 );
632
633
634 -- Start of commments
635 -- API name : get_process_loss
636 -- Type : Private
637 -- Function :
638 -- Paramaters :
639 -- IN : p_api_version IN NUMBER Required
640 -- p_init_msg_list IN Varchar2 Optional
641 --
642 -- p_recipe_no IN Varchar2
643 -- p_recipe_version IN NUMBER
644 -- p_recipe_id IN NUMBER
645 -- p_orgn_code IN Varchar2 Optional
646 --
647 -- x_return_status OUT NOCOPY varchar2(1)
648 -- x_msg_count OUT NOCOPY Number
649 -- x_msg_data OUT NOCOPY varchar2(2000)
650 -- x_process_loss OUT NOCOPY NUMBER
651 -- Version : Current Version 1.0
652 --
653 -- Notes :
654 --
655 -- End of comments
656
657 /* Bug 2411810 - Thomas Daniel */
658 /* Added the default values which was present in the body to the spec */
659
660 /*#
661 * Fetches the Process Loss for a Recipe
662 * This is a PL/SQL procedure to return the process loss for a
663 * particular recipe if a routing is attached to a given recipe
664 * @param p_api_version API version field
665 * @param p_init_msg_list Flag to check if message list intialized
666 * @param p_recipe_no Recipe Number field
667 * @param p_recipe_version Version of the Recipe
668 * @param p_recipe_id ID of the Recipe
669 * @param p_organization_id Organiation ID of the Recipe
670 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
671 * @param x_msg_count Number of msg's on message stack
672 * @param x_msg_data Actual message data on message stack
673 * @param x_return_code SQLCODE returned
674 * @param x_process_loss Process Loss for the Recipe
675 * @rep:scope public
676 * @rep:lifecycle active
677 * @rep:displayname Fetch Process Loss procedure
678 * @rep:compatibility S
679 */
680 PROCEDURE get_process_loss
681 ( p_api_version IN NUMBER ,
682 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
683 p_recipe_no IN VARCHAR2 := NULL ,
684 p_recipe_version IN NUMBER := NULL ,
685 p_recipe_id IN NUMBER ,
686 p_organization_id IN NUMBER ,
687 x_return_status OUT NOCOPY VARCHAR2 ,
688 x_msg_count OUT NOCOPY NUMBER ,
689 x_msg_data OUT NOCOPY VARCHAR2 ,
690 x_return_code OUT NOCOPY NUMBER ,
691 x_process_loss OUT NOCOPY NUMBER
692 );
693
694
695 -- Start of commments
696 -- API name : get_routing_step_details
697 -- Type : Public
698 -- Function :
699 -- Paramaters :
700 -- IN : p_api_version IN NUMBER Required
701 -- p_init_msg_list IN Varchar2 Optional
702 --
703 -- p_recipe_no IN Varchar2
704 -- p_recipe_version IN Varchar2
705 -- p_recipe_id IN Number
706 --
707 --
708 -- x_return_status OUT NOCOPY varchar2(1)
709 -- x_msg_count OUT NOCOPY Number
710 -- x_msg_data OUT NOCOPY varchar2(2000)
711 -- X_recipe_rout_step_tbl OUT NOCOPY recipe_rout_step_out
712 -- Version : Current Version 1.0
713 --
714 -- Notes :
715 -- End of comments
716
717 /*#
718 * Fetches the Routing Step information
719 * This is a PL/SQL procedure to return the routing step information based on the routing_id
720 * passed to it. This information is for populating the data before the recipe_id is created
721 * @param p_api_version API version field
722 * @param p_init_msg_list Flag to check if message list intialized
723 * @param p_routing_id ID of the Routing
724 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
725 * @param x_msg_count Number of msg's on message stack
726 * @param x_msg_data Actual message data on message stack
727 * @param x_return_code SQLCODE returned
728 * @param x_routing_step_out Table structure of Routing Step table to return Routing Step details
729 * @rep:scope public
730 * @rep:lifecycle active
731 * @rep:displayname Fetch Routing Step details procedure
732 * @rep:compatibility S
733 */
734 PROCEDURE get_routing_step_details
735 ( p_api_version IN NUMBER ,
736 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
737 p_routing_id IN NUMBER ,
738 x_return_status OUT NOCOPY VARCHAR2 ,
739 x_msg_count OUT NOCOPY NUMBER ,
740 x_msg_data OUT NOCOPY VARCHAR2 ,
741 x_return_code OUT NOCOPY NUMBER ,
745 -- API name : get_recipe_step_details
742 x_routing_step_out OUT NOCOPY routing_step_tbl
743 );
744 -- Start of commments
746 -- Type : Public
747 -- Function :
748 -- Paramaters :
749 -- IN : p_api_version IN NUMBER Required
750 -- p_init_msg_list IN Varchar2 Optional
751 --
752 -- p_recipe_no IN Varchar2
753 -- p_recipe_version IN Varchar2
754 -- p_recipe_id IN Number
755 --
756 --
757 -- x_return_status OUT NOCOPY varchar2(1)
758 -- x_msg_count OUT NOCOPY Number
759 -- x_msg_data OUT NOCOPY varchar2(2000)
760 -- X_recipe_rout_step_tbl OUT NOCOPY recipe_rout_step_out
761 -- Version : Current Version 1.0
762 --
763 -- Notes :
764 -- End of comments
765
766 /*#
767 * Fetches the Recipe Step details
768 * This is a PL/SQL procedure to return the recipe step details based on the recipe_id
769 * passed to it. This information is for populating the data after the recipe_id is created
770 * @param p_api_version API version field
771 * @param p_init_msg_list Flag to check if message list intialized
772 * @param p_recipe_id ID of the Recipe
773 * @param P_organization_id Orgnanization ID of the Recipe
774 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
775 * @param x_msg_count Number of msg's on message stack
776 * @param x_msg_data Actual message data on message stack
777 * @param x_return_code SQLCODE returned
778 * @param x_recipe_step_out Table structure of Recipe Step table to return Recipe Step details
779 * @param p_val_scale_factor Scaling factor
780 * @param p_process_loss Process loss
781 * @rep:scope public
782 * @rep:lifecycle active
783 * @rep:displayname Fetch Recipe Step details procedure
784 * @rep:compatibility S
785 */
786 PROCEDURE get_recipe_step_details
787 ( p_api_version IN NUMBER ,
788 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
789 p_recipe_id IN NUMBER ,
790 p_organization_id IN NUMBER DEFAULT NULL ,
791 x_return_status OUT NOCOPY VARCHAR2 ,
792 x_msg_count OUT NOCOPY NUMBER ,
793 x_msg_data OUT NOCOPY VARCHAR2 ,
794 x_return_code OUT NOCOPY NUMBER ,
795 x_recipe_step_out OUT NOCOPY recipe_step_tbl ,
796 p_val_scale_factor IN NUMBER DEFAULT 1 ,
797 p_process_loss IN NUMBER DEFAULT 0,
798 p_routing_id IN NUMBER DEFAULT NULL
799 );
800
801 -- Start of commments
802 -- API name : get_step_depd_details
803 -- Type : Public
804 -- Function :
805 -- Paramaters :
806 -- IN : p_api_version IN NUMBER Required
807 -- p_init_msg_list IN Varchar2 Optional
808 --
809 -- p_recipe_no IN Varchar2
810 -- p_recipe_version IN Varchar2
811 -- p_recipe_id IN Number
812 --
813 -- x_return_status OUT NOCOPY varchar2(1)
814 -- x_msg_count OUT NOCOPY Number
815 -- x_msg_data OUT NOCOPY varchar2(2000)
816 -- x_routing_depd_out OUT NOCOPY routing_depd_tbl
817 -- Version : Current Version 1.0
818 --
819 -- Notes :
820 -- End of comments
821
822 /*#
823 * Fetches the Recipe Step Dependency details
824 * This is a PL/SQL procedure to return the step dependency information based on the
825 * recipe_id passed to it
826 * @param p_api_version API version field
827 * @param p_init_msg_list Flag to check if message list intialized
828 * @param p_recipe_id ID of the Recipe
829 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
830 * @param x_msg_count Number of msg's on message stack
831 * @param x_msg_data Actual message data on message stack
832 * @param x_return_code SQLCODE returned
833 * @param x_routing_depd_tbl Table structure to return Recipe Step dependency details
834 * @rep:scope public
835 * @rep:lifecycle active
836 * @rep:displayname Fetch Recipe Step Dependency details procedure
837 * @rep:compatibility S
838 */
839 PROCEDURE get_step_depd_details
840 ( p_api_version IN NUMBER ,
841 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
842 p_recipe_id IN NUMBER ,
843 x_return_status OUT NOCOPY VARCHAR2 ,
844 x_msg_count OUT NOCOPY NUMBER ,
845 x_msg_data OUT NOCOPY VARCHAR2 ,
846 x_return_code OUT NOCOPY NUMBER ,
847 x_routing_depd_tbl OUT NOCOPY routing_depd_tbl
848 );
849
850
851
852 -- Start of commments
853 -- API name : get_oprn_act_detl
854 -- Type : Public
855 -- Function :
856 -- Paramaters :
857 -- IN : p_api_version IN NUMBER Required
858 -- p_init_msg_list IN Varchar2 Optional
859 --
863 -- x_msg_count OUT NOCOPY Number
860 -- p_recipe_id IN Number
861 -- p_organization_id IN Number
862 -- x_return_status OUT NOCOPY varchar2(1)
864 -- x_msg_data OUT NOCOPY varchar2(2000)
865 -- X_oprn_act_tbl OUT NOCOPY oprn_act_out
866 -- Version : Current Version 1.0
867 --
868 -- Notes :
869 -- End of comments
870
871 /*#
872 * Fetches the Operation activity details
873 * This is a PL/SQL procedure to return the step, operation and activities details
874 * for a given recipe based on the recipe_id passed to it
875 * @param p_api_version API version field
876 * @param p_init_msg_list Flag to check if message list intialized
877 * @param p_recipe_id ID of the Recipe
878 * @param P_organization_id Orgnanization ID of the Recipe
879 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
880 * @param x_msg_count Number of msg's on message stack
881 * @param x_msg_data Actual message data on message stack
882 * @param x_return_code SQLCODE returned
883 * @param x_oprn_act_out Table structure to return Operation activities details
884 * @rep:scope public
885 * @rep:lifecycle active
886 * @rep:displayname Fetch Operation activity details procedure
887 * @rep:compatibility S
888 */
889 PROCEDURE get_oprn_act_detl
890 ( p_api_version IN NUMBER ,
891 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
892 p_recipe_id IN NUMBER ,
893 p_organization_id IN NUMBER DEFAULT NULL ,
894 x_return_status OUT NOCOPY VARCHAR2 ,
895 x_msg_count OUT NOCOPY NUMBER ,
896 x_msg_data OUT NOCOPY VARCHAR2 ,
897 x_return_code OUT NOCOPY NUMBER ,
898 x_oprn_act_out OUT NOCOPY oprn_act_tbl
899 );
900
901
902 -- Start of commments
903 -- API name : get_oprn_resc_detl
904 -- Type : Public
905 -- Function :
906 -- Paramaters :
907 -- IN : p_api_version IN NUMBER Required
908 -- p_init_msg_list IN Varchar2 Optional
909 --
910 -- p_recipe_no IN Varchar2
911 -- p_recipe_version IN NUMBER
912 -- p_recipe_id IN Number
913 -- x_return_status OUT NOCOPY varchar2(1)
914 -- x_msg_count OUT NOCOPY Number
915 -- x_msg_data OUT NOCOPY varchar2(2000)
916 -- x_oprn_resc_tbl OUT NOCOPY oprn_resc_out
917 -- Version : Current Version 1.0
918 --
919 -- Notes :
920 -- End of comments
921
922 /*#
923 * Fetches the Operation resource details
924 * This is a PL/SQL procedure to return the step, operation and activities,
925 * resources details for a given recipe based on the recipe_id passed to it
926 * @param p_api_version API version field
927 * @param p_init_msg_list Flag to check if message list intialized
928 * @param p_recipe_id ID of the Recipe
929 * @param P_organization_id Orgnanization ID of the Recipe
930 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
931 * @param x_msg_count Number of msg's on message stack
932 * @param x_msg_data Actual message data on message stack
933 * @param x_return_code SQLCODE returned
934 * @param X_oprn_resc_rec Table structure to return Operation resource details
935 * @rep:scope public
936 * @rep:lifecycle active
937 * @rep:displayname Fetch Operation resource details procedure
938 * @rep:compatibility S
939 */
940 PROCEDURE get_oprn_resc_detl
941 ( p_api_version IN NUMBER ,
942 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
943 p_recipe_id IN NUMBER ,
944 p_organization_id IN NUMBER DEFAULT NULL ,
945 x_return_status OUT NOCOPY VARCHAR2 ,
946 x_msg_count OUT NOCOPY NUMBER ,
947 x_msg_data OUT NOCOPY VARCHAR2 ,
948 x_return_code OUT NOCOPY NUMBER ,
949 X_oprn_resc_rec OUT NOCOPY oprn_resc_tbl
950 );
951
952
953 -- Start of commments
954 -- API name : get_recipe_process_param_detl
955 -- Type : Public
956 -- Function :
957 -- Paramaters :
958 -- IN : p_api_version IN NUMBER Required
959 -- p_init_msg_list IN Varchar2 Optional
960 --
961 -- p_recipe_id IN Number
962 -- p_orgn_code IN VARCHAR2
963 -- x_return_status OUT NOCOPY varchar2(1)
964 -- x_msg_count OUT NOCOPY Number
965 -- x_msg_data OUT NOCOPY varchar2(2000)
966 -- x_recp_resc_proc_param_tbl OUT NOCOPY recp_resc_proc_param_tbl
967 -- Version : Current Version 1.0
968 --
969 -- Notes :
970 -- End of comments
971
972 /*#
973 * Fetches the Recipe Process Parameters details
974 * This is a PL/SQL procedure to the process parameters for a recipe
975 * @param p_api_version API version field
979 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
976 * @param p_init_msg_list Flag to check if message list intialized
977 * @param p_recipe_id ID of the Recipe
978 * @param P_organization_id Orgnanization ID of the Recipe
980 * @param x_msg_count Number of msg's on message stack
981 * @param x_msg_data Actual message data on message stack
982 * @param X_recp_resc_proc_param_tbl Table structure to return Process parameter details
983 * @rep:scope public
984 * @rep:lifecycle active
985 * @rep:displayname Fetch Process parameters procedure
986 * @rep:compatibility S
987 */
988 PROCEDURE get_recipe_process_param_detl
989 ( p_api_version IN NUMBER ,
990 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
991 p_recipe_id IN NUMBER ,
992 p_organization_id IN NUMBER DEFAULT NULL ,
993 x_return_status OUT NOCOPY VARCHAR2 ,
994 x_msg_count OUT NOCOPY NUMBER ,
995 x_msg_data OUT NOCOPY VARCHAR2 ,
996 X_recp_resc_proc_param_tbl OUT NOCOPY recp_resc_proc_param_tbl
997 );
998
999 /*#
1000 * Fetches the Process Parameter description
1001 * This is a PL/SQL procedure is responsible for getting the
1002 * description for a given process parameter.
1003 * @param p_parameter_id ID of the process parameter
1004 * @param x_parameter_desc Description of the process parameter is returned
1005 * @rep:scope public
1006 * @rep:lifecycle active
1007 * @rep:displayname Fetch Process parameter Description procedure
1008 * @rep:compatibility S
1009 */
1010 PROCEDURE get_proc_param_desc(p_parameter_id IN NUMBER, x_parameter_desc OUT NOCOPY VARCHAR2);
1011
1012 /*#
1013 * Fetches the Process Parameter Units
1014 * This PL/SQL procedure is responsible for getting the
1015 * units for a given process parameter
1016 * @param p_parameter_id ID of the process parameter
1017 * @param x_units Units for the process parameter is returned
1018 * @rep:scope public
1019 * @rep:lifecycle active
1020 * @rep:displayname Fetch Process parameter Units procedure
1021 * @rep:compatibility S
1022 */
1023 PROCEDURE get_proc_param_units(p_parameter_id IN NUMBER, x_units OUT NOCOPY VARCHAR2);
1024
1025 /*#
1026 * Fetches the Contiguous Indicator Value
1027 * This PL/SQL procedure is responsible for getting the contiguous indicator
1028 * value set at Recipe - Orgn level or at the Recipe level in order
1029 * for the given input parameters
1030 * @param p_recipe_id Recipe ID for which cont ind setting is requested
1031 * @param p_orgn_id Organization ID for which cont ind setting is requested
1032 * @param p_recipe_validity_rule_id Validity Rule ID for which cont ind setting is requested
1033 * @param x_contiguous_ind Contiguous Ind value out parameter
1034 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
1035 * @rep:scope public
1036 * @rep:lifecycle active
1037 * @rep:displayname Fetch Contiguous Indicator Value procedure
1038 * @rep:compatibility S
1039 */
1040 PROCEDURE fetch_contiguous_ind( p_recipe_id IN NUMBER
1041 , p_orgn_id IN NUMBER
1042 , p_recipe_validity_rule_id IN NUMBER
1043 , x_contiguous_ind OUT NOCOPY NUMBER
1044 , x_return_status OUT NOCOPY VARCHAR2);
1045
1046 /*#
1047 * Fetches the Enhanced PI Indicator value at recipe header level
1048 * This PL/SQL procedure is responsible for getting the PI indicator
1049 * value set at Recipe header level
1050 * @param p_recipe_id Recipe ID for which Enhanced PI ind value is requested
1051 * @param p_recipe_validity_rule_id Validity Rule ID
1052 * @param x_enhanced_pi_ind Enhanced PI Ind value out parameter
1053 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
1054 * @rep:scope public
1055 * @rep:lifecycle active
1056 * @rep:displayname Fetch Enhanced PI Indicator Value procedure
1057 * @rep:compatibility S
1058 */
1059 PROCEDURE FETCH_ENHANCED_PI_IND (
1060 p_recipe_id IN NUMBER
1061 ,p_recipe_validity_rule_id IN NUMBER
1062 ,x_enhanced_pi_ind OUT NOCOPY VARCHAR2
1063 ,x_return_status OUT NOCOPY VARCHAR2);
1064
1065 END GMD_RECIPE_FETCH_PUB;