1 PACKAGE GMD_RECIPE_FETCH_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPRCFS.pls 120.5.12020000.2 2012/07/17 10:04:51 mtou 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 ,
171 activity_factor gmd_operation_activities.activity_factor%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 ,
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
252 max_calc_capacity cr_rsrc_mst.max_capacity%type ,/*Added in bug 13440294 ,this column take the tolerance into conern,fix the bug 4671464's error*/
253 min_calc_capacity cr_rsrc_mst.min_capacity%type ,/*Added in bug 13440294 ,this column take the tolerance into conern,fix the bug 4671464's error*/
254
255 capacity_constraint cr_rsrc_mst.capacity_constraint%type ,
256 capacity_tolerance cr_rsrc_dtl.capacity_tolerance%type ,
257 capacity_uom cr_rsrc_dtl.capacity_um%type,
258
259 process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
260 process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
261 process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
262 process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
263 process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
264
265 recipe_override NUMBER(5) ,
266 text_code gmd_operation_resources.text_code%type ,
267 created_by gmd_operation_resources.created_by%type ,
271 last_update_login gmd_operation_resources.last_update_login%type ,
268 last_updated_by gmd_operation_resources.last_updated_by%type ,
269 last_update_date gmd_operation_resources.last_update_date%type ,
270 creation_date gmd_operation_resources.creation_date%type ,
272 attribute_category gmd_operation_resources.attribute_category%type ,
273 attribute1 gmd_operation_resources.attribute1%type ,
274 attribute2 gmd_operation_resources.attribute2%type ,
275 attribute3 gmd_operation_resources.attribute3%type ,
276 attribute4 gmd_operation_resources.attribute4%type ,
277 attribute5 gmd_operation_resources.attribute5%type ,
278 attribute6 gmd_operation_resources.attribute6%type ,
279 attribute7 gmd_operation_resources.attribute7%type ,
280 attribute8 gmd_operation_resources.attribute8%type ,
281 attribute9 gmd_operation_resources.attribute9%type ,
282 attribute10 gmd_operation_resources.attribute10%type ,
283 attribute11 gmd_operation_resources.attribute11%type ,
284 attribute12 gmd_operation_resources.attribute12%type ,
285 attribute13 gmd_operation_resources.attribute13%type ,
286 attribute14 gmd_operation_resources.attribute14%type ,
287 attribute15 gmd_operation_resources.attribute15%type ,
288 attribute16 gmd_operation_resources.attribute16%type ,
289 attribute17 gmd_operation_resources.attribute17%type ,
290 attribute18 gmd_operation_resources.attribute18%type ,
291 attribute19 gmd_operation_resources.attribute19%type ,
292 attribute20 gmd_operation_resources.attribute20%type ,
293 attribute21 gmd_operation_resources.attribute21%type ,
294 attribute22 gmd_operation_resources.attribute22%type ,
295 attribute23 gmd_operation_resources.attribute23%type ,
296 attribute24 gmd_operation_resources.attribute24%type ,
297 attribute25 gmd_operation_resources.attribute25%type ,
298 attribute26 gmd_operation_resources.attribute26%type ,
299 attribute27 gmd_operation_resources.attribute27%type ,
300 attribute28 gmd_operation_resources.attribute28%type ,
301 attribute29 gmd_operation_resources.attribute29%type ,
302 attribute30 gmd_operation_resources.attribute30%type
303
304 );
305 TYPE oprn_resc_tbl IS TABLE OF oprn_resc_rec
306 INDEX BY BINARY_INTEGER;
307
308
309 TYPE recp_resc_proc_param_rec IS RECORD
310 (
311 recipe_id gmd_recipes.recipe_id%type ,
312 routingstep_id fm_rout_dtl.routingstep_id%type ,
313 routingstep_no fm_rout_dtl.routingstep_no%type ,
314 oprn_line_id gmd_operation_resources.oprn_line_id%type ,
315 resources gmd_operation_resources.resources%type ,
316 parameter_id gmp_process_parameters.parameter_id%type ,
317 parameter_name gmp_process_parameters.parameter_name%type ,
318 parameter_description gmp_process_parameters.parameter_description%type ,
319 units gmp_process_parameters.units%type ,
320 target_value gmd_recipe_process_parameters.target_value%type ,
321 minimum_value NUMBER ,
322 maximum_value NUMBER ,
323 parameter_type gmp_process_parameters.parameter_type%type ,
324 sequence_no gmp_resource_parameters.sequence_no%type ,
325 created_by gmd_recipe_process_parameters.created_by%type ,
326 last_updated_by gmd_recipe_process_parameters.last_updated_by%type ,
327 last_update_date gmd_recipe_process_parameters.last_update_date%type ,
328 creation_date gmd_recipe_process_parameters.creation_date%type ,
329 last_update_login gmd_recipe_process_parameters.last_update_login%type ,
330 recipe_override NUMBER(5)
331 );
332
333 TYPE recp_resc_proc_param_tbl IS TABLE OF recp_resc_proc_param_rec
334 INDEX BY BINARY_INTEGER;
335
336
337 -- Start of commments
338 -- API name : get_validity_rules
339 -- Type : Public
340 -- Function :
341 -- Paramaters :
342 -- IN : p_api_version IN NUMBER Required
343 -- p_init_msg_list IN Varchar2 Optional
344 --
345 -- p_recipe_no IN Varchar2
346 -- p_recipe_version IN Number
347 -- p_item_no IN Varchar2
348 -- p_orgn_code IN Varchar2
349 -- p_recipe_qty IN Number
350 -- P_recipe_id IN Number
351 -- x_return_status OUT NOCOPY varchar2(1)
352 -- x_msg_count OUT NOCOPY Number
353 -- x_msg_data OUT NOCOPY varchar2(2000)
354 -- x_return_code OUT NOCOPY NUMBER
355 -- x_recipe_validity_tbl OUT NOCOPY recipe_validity_tbl
356 -- Version : Current Version 1.0
357 --
358 -- Notes :
359 -- End of comments
360
361 /*
362 PROCEDURE get_validity_rules
363 ( p_api_version IN NUMBER ,
364 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
365 p_recipe_id IN NUMBER ,
366 p_item_id IN NUMBER ,
367 p_orgn_code IN Varchar2 ,
368 p_product_qty IN NUMBER ,
369 p_recipe_use IN VARCHAR2 ,
370 x_return_status OUT NOCOPY VARCHAR2 ,
371 x_msg_count OUT NOCOPY NUMBER ,
372 x_msg_data OUT NOCOPY VARCHAR2 ,
373 x_return_code OUT NOCOPY NUMBER ,
374 X_recipe_validity_tbl OUT NOCOPY recipe_validity_tbl
375 ); */
376
377
381 -- Function :
378 -- Start of commments
379 -- API name : get_recipe_id
380 -- Type : Private
382 -- Paramaters :
383 -- IN : p_api_version IN NUMBER Required
384 -- p_init_msg_list IN Varchar2 Optional
385 --
386 -- p_recipe_validity_rule_id IN NUMBER
387 -- p_delete_mark IN NUMBER Required
388 --
389 -- x_return_status OUT NOCOPY varchar2(1)
390 -- x_msg_count OUT NOCOPY Number
391 -- x_msg_data OUT NOCOPY varchar2(2000)
392 -- x_recipe_id OUT NOCOPY NUMBER
393 -- Version : Current Version 1.0
394 --
395 -- Notes :
396 --
397 -- End of comments
398
399 /*#
400 * Fetches the recipe id
401 * This is a PL/SQL procedure to fetch recipe_id from gmd_recipe_validity_rules
402 * based on the validity_rule_id passed
403 * @param p_api_version API version field
404 * @param p_init_msg_list Flag to check if message list intialized
405 * @param p_recipe_validity_rule_id Vailidity Rule ID
406 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
407 * @param x_msg_count Number of msg's on message stack
408 * @param x_msg_data Actual message data on message stack
409 * @param x_return_code SQLCODE returned
410 * @param x_recipe_id Recipe ID for the corresponding Validity Rule ID passed
411 * @rep:scope public
412 * @rep:lifecycle active
413 * @rep:displayname Fetch Recipe ID procedure
414 * @rep:compatibility S
415 */
416 PROCEDURE get_recipe_id
417 ( p_api_version IN NUMBER ,
418 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
419 p_recipe_validity_rule_id IN NUMBER ,
420 x_return_status OUT NOCOPY VARCHAR2 ,
421 x_msg_count OUT NOCOPY NUMBER ,
422 x_msg_data OUT NOCOPY VARCHAR2 ,
423 x_return_code OUT NOCOPY NUMBER ,
424 x_recipe_id OUT NOCOPY NUMBER
425 );
426
427
428 -- Start of commments
429 -- API name : get_routing_id
430 -- Type : Private
431 -- Function :
432 -- Paramaters :
433 -- IN : p_api_version IN NUMBER Required
434 -- p_init_msg_list IN Varchar2 Optional
435 --
436 -- p_recipe_no IN Varchar2
437 -- p_recipe_version IN Varchar2
438 -- p_recipe_id IN NUMBER
439 -- p_delete_mark IN NUMBER Required
440 --
441 -- x_return_status OUT NOCOPY varchar2(1)
442 -- x_msg_count OUT NOCOPY Number
443 -- x_msg_data OUT NOCOPY varchar2(2000)
444 -- x_routing_id OUT NOCOPY NUMBER
445 -- Version : Current Version 1.0
446 --
447 -- Notes :
448 --
449 -- End of comments
450
451 /*#
452 * Fetches the routing id
453 * This is a PL/SQL procedure to return the routing_id attached to the recipe_id
454 * @param p_api_version API version field
455 * @param p_init_msg_list Flag to check if message list intialized
456 * @param p_recipe_no Recipe Number field
457 * @param p_recipe_version Version of the Recipe
458 * @param p_recipe_id ID of the Recipe
459 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
460 * @param x_msg_count Number of msg's on message stack
464 * @rep:scope public
461 * @param x_msg_data Actual message data on message stack
462 * @param x_return_code SQLCODE returned
463 * @param x_routing_id Routing ID corresponding to the Recipe ID passed
465 * @rep:lifecycle active
466 * @rep:displayname Fetch Routing ID procedure
467 * @rep:compatibility S
468 */
469 PROCEDURE get_routing_id
470 ( p_api_version IN NUMBER ,
471 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
472 p_recipe_no IN Varchar2 ,
473 p_recipe_version IN NUMBER ,
474 p_recipe_id IN NUMBER ,
475 x_return_status OUT NOCOPY VARCHAR2 ,
476 x_msg_count OUT NOCOPY NUMBER ,
477 x_msg_data OUT NOCOPY VARCHAR2 ,
478 x_return_code OUT NOCOPY NUMBER ,
479 x_routing_id OUT NOCOPY NUMBER
480 );
481 -- Start of commments
482 -- API name : get_rout_hdr
483 -- Type : Private
484 -- Function :
485 -- Paramaters :
486 -- IN : p_api_version IN NUMBER Required
487 -- p_init_msg_list IN Varchar2 Optional
488 --
489 -- p_recipe_id IN NUMBER
490 -- x_return_status OUT NOCOPY varchar2(1)
491 -- x_msg_count OUT NOCOPY Number
492 -- x_msg_data OUT NOCOPY varchar2(2000)
493 -- x_return_code OUT NOCOPY number
494 -- x_rout_out OUT NOCOPY NUMBER
495 -- Version : Current Version 1.0
496 --
497 -- Notes :
498 --
499 -- End of comments
500
501 /*#
502 * Fetches the routing header information
503 * This is a PL/SQL procedure to fetch the total routing header
504 * information based on the recipe_id passed to it
505 * @param p_api_version API version field
506 * @param p_init_msg_list Flag to check if message list intialized
507 * @param p_recipe_id ID of the Recipe
508 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
509 * @param x_msg_count Number of msg's on message stack
510 * @param x_msg_data Actual message data on message stack
511 * @param x_return_code SQLCODE returned
512 * @param x_rout_out Table structure of Recipe header to return header information
513 * @rep:scope public
514 * @rep:lifecycle active
515 * @rep:displayname Fetch Routing Header procedure
516 * @rep:compatibility S
517 */
518 PROCEDURE get_rout_hdr
519 ( p_api_version IN NUMBER ,
520 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
521 p_recipe_id IN NUMBER ,
522 x_return_status OUT NOCOPY VARCHAR2 ,
523 x_msg_count OUT NOCOPY NUMBER ,
524 x_msg_data OUT NOCOPY VARCHAR2 ,
525 x_return_code OUT NOCOPY NUMBER ,
526 x_rout_out OUT NOCOPY recipe_rout_tbl
527 );
528
529 -- Start of commments
530 -- API name : get_formula_id
531 -- Type : Private
532 -- Function :
533 -- Paramaters :
534 -- IN : p_api_version IN NUMBER Required
535 -- p_init_msg_list IN Varchar2 Optional
536 --
537 -- p_recipe_no IN Varchar2
538 -- p_recipe_version IN Varchar2
539 -- p_recipe_id IN NUMBER
540 -- p_delete_mark IN NUMBER Required
541 --
542 -- x_return_status OUT NOCOPY varchar2(1)
543 -- x_msg_count OUT NOCOPY Number
544 -- x_msg_data OUT NOCOPY varchar2(2000)
545 -- x_formula_id OUT NOCOPY NUMBER
546 -- Version : Current Version 1.0
547 --
548 -- Notes :
549 --
550 -- End of comments
551 /* Bug 2411810 - Thomas Daniel */
552 /* Added the default values which was present in the body to the spec */
553
554 /*#
555 * Fetches the formula id
556 * This is a PL/SQL procedure to return the formula_id based on the
557 * recipe_id passed to it
558 * @param p_api_version API version field
559 * @param p_init_msg_list Flag to check if message list intialized
560 * @param p_recipe_no Recipe Number field
561 * @param p_recipe_version Version of the Recipe
562 * @param p_recipe_id ID of the Recipe
563 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
564 * @param x_msg_count Number of msg's on message stack
565 * @param x_msg_data Actual message data on message stack
566 * @param x_return_code SQLCODE returned
567 * @param x_formula_id Formula ID corresponding the Recipe ID passed
568 * @rep:scope public
569 * @rep:lifecycle active
570 * @rep:displayname Fetch Formula ID procedure
571 * @rep:compatibility S
572 */
573 PROCEDURE get_formula_id
574 ( p_api_version IN NUMBER ,
575 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
576 p_recipe_no IN Varchar2 := NULL ,
577 p_recipe_version IN NUMBER := NULL ,
578 p_recipe_id IN NUMBER ,
579 x_return_status OUT NOCOPY VARCHAR2 ,
583 x_formula_id OUT NOCOPY NUMBER
580 x_msg_count OUT NOCOPY NUMBER ,
581 x_msg_data OUT NOCOPY VARCHAR2 ,
582 x_return_code OUT NOCOPY NUMBER ,
584 );
585
586 -- Start of commments
587 -- API name : get_rout_material
588 -- Type : Public
589 -- Function :
590 -- Paramaters :
591 -- IN : p_api_version IN NUMBER Required
592 -- p_init_msg_list IN Varchar2 Optional
593 --
594 -- p_recipe_no IN Varchar2
595 -- p_recipe_version IN NUMBER
596 -- p_recipe_id IN number
597 --
598 --
599 --
600 -- x_return_status OUT NOCOPY varchar2(1)
601 -- x_msg_count OUT NOCOPY Number
602 -- x_msg_data OUT NOCOPY varchar2(2000)
603 -- x_recipe_rout_matl_tbl OUT NOCOPY recipe_rout_matl_tbl
604 -- Version : Current Version 1.0
605 --
606 -- Notes :
607 -- End of comments
608
609 /*#
610 * Fetches the material - step information
611 * This is a PL/SQL procedure to return the material - step information
612 * based on the Recipe ID passed to it
613 * @param p_api_version API version field
614 * @param p_init_msg_list Flag to check if message list intialized
615 * @param p_recipe_id ID of the Recipe
616 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
617 * @param x_msg_count Number of msg's on message stack
618 * @param x_msg_data Actual message data on message stack
619 * @param x_return_code SQLCODE returned
620 * @param x_recipe_rout_matl_tbl Table structure of routing material table
621 * @rep:scope public
622 * @rep:lifecycle active
623 * @rep:displayname Fetch Routing material-step procedure
624 * @rep:compatibility S
625 */
626 PROCEDURE get_rout_material
627 ( p_api_version IN NUMBER ,
628 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
629 p_recipe_id IN NUMBER ,
630 x_return_status OUT NOCOPY VARCHAR2 ,
631 x_msg_count OUT NOCOPY NUMBER ,
632 x_msg_data OUT NOCOPY VARCHAR2 ,
633 x_return_code OUT NOCOPY NUMBER ,
634 x_recipe_rout_matl_tbl OUT NOCOPY recipe_rout_matl_tbl
635 );
636
637
638 -- Start of commments
639 -- API name : get_process_loss
640 -- Type : Private
641 -- Function :
642 -- Paramaters :
643 -- IN : p_api_version IN NUMBER Required
644 -- p_init_msg_list IN Varchar2 Optional
645 --
646 -- p_recipe_no IN Varchar2
647 -- p_recipe_version IN NUMBER
648 -- p_recipe_id IN NUMBER
649 -- p_orgn_code IN Varchar2 Optional
650 --
651 -- x_return_status OUT NOCOPY varchar2(1)
652 -- x_msg_count OUT NOCOPY Number
653 -- x_msg_data OUT NOCOPY varchar2(2000)
654 -- x_process_loss OUT NOCOPY NUMBER
655 -- Version : Current Version 1.0
656 --
657 -- Notes :
658 --
659 -- End of comments
660
661 /* Bug 2411810 - Thomas Daniel */
662 /* Added the default values which was present in the body to the spec */
663
664 /*#
665 * Fetches the Process Loss for a Recipe
666 * This is a PL/SQL procedure to return the process loss for a
667 * particular recipe if a routing is attached to a given recipe
668 * @param p_api_version API version field
669 * @param p_init_msg_list Flag to check if message list intialized
670 * @param p_recipe_no Recipe Number field
671 * @param p_recipe_version Version of the Recipe
672 * @param p_recipe_id ID of the Recipe
673 * @param p_organization_id Organiation ID of the Recipe
674 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
675 * @param x_msg_count Number of msg's on message stack
676 * @param x_msg_data Actual message data on message stack
677 * @param x_return_code SQLCODE returned
678 * @param x_process_loss Process Loss for the Recipe
679 * @rep:scope public
680 * @rep:lifecycle active
681 * @rep:displayname Fetch Process Loss procedure
682 * @rep:compatibility S
683 */
684 PROCEDURE get_process_loss
685 ( p_api_version IN NUMBER ,
686 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
687 p_recipe_no IN VARCHAR2 := NULL ,
688 p_recipe_version IN NUMBER := NULL ,
689 p_recipe_id IN NUMBER ,
690 p_organization_id IN NUMBER ,
691 x_return_status OUT NOCOPY VARCHAR2 ,
692 x_msg_count OUT NOCOPY NUMBER ,
693 x_msg_data OUT NOCOPY VARCHAR2 ,
694 x_return_code OUT NOCOPY NUMBER ,
695 x_process_loss OUT NOCOPY NUMBER
696 );
697
698
699 -- Start of commments
700 -- API name : get_routing_step_details
701 -- Type : Public
702 -- Function :
703 -- Paramaters :
707 -- p_recipe_no IN Varchar2
704 -- IN : p_api_version IN NUMBER Required
705 -- p_init_msg_list IN Varchar2 Optional
706 --
708 -- p_recipe_version IN Varchar2
709 -- p_recipe_id IN Number
710 --
711 --
712 -- x_return_status OUT NOCOPY varchar2(1)
713 -- x_msg_count OUT NOCOPY Number
714 -- x_msg_data OUT NOCOPY varchar2(2000)
715 -- X_recipe_rout_step_tbl OUT NOCOPY recipe_rout_step_out
716 -- Version : Current Version 1.0
717 --
718 -- Notes :
719 -- End of comments
720
721 /*#
722 * Fetches the Routing Step information
723 * This is a PL/SQL procedure to return the routing step information based on the routing_id
724 * passed to it. This information is for populating the data before the recipe_id is created
725 * @param p_api_version API version field
726 * @param p_init_msg_list Flag to check if message list intialized
727 * @param p_routing_id ID of the Routing
728 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
729 * @param x_msg_count Number of msg's on message stack
730 * @param x_msg_data Actual message data on message stack
731 * @param x_return_code SQLCODE returned
732 * @param x_routing_step_out Table structure of Routing Step table to return Routing Step details
733 * @rep:scope public
734 * @rep:lifecycle active
735 * @rep:displayname Fetch Routing Step details procedure
736 * @rep:compatibility S
737 */
738 PROCEDURE get_routing_step_details
739 ( p_api_version IN NUMBER ,
740 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
741 p_routing_id IN NUMBER ,
742 x_return_status OUT NOCOPY VARCHAR2 ,
743 x_msg_count OUT NOCOPY NUMBER ,
744 x_msg_data OUT NOCOPY VARCHAR2 ,
745 x_return_code OUT NOCOPY NUMBER ,
746 x_routing_step_out OUT NOCOPY routing_step_tbl
747 );
748 -- Start of commments
749 -- API name : get_recipe_step_details
750 -- Type : Public
751 -- Function :
752 -- Paramaters :
753 -- IN : p_api_version IN NUMBER Required
754 -- p_init_msg_list IN Varchar2 Optional
755 --
756 -- p_recipe_no IN Varchar2
757 -- p_recipe_version IN Varchar2
758 -- p_recipe_id IN Number
759 --
760 --
761 -- x_return_status OUT NOCOPY varchar2(1)
762 -- x_msg_count OUT NOCOPY Number
763 -- x_msg_data OUT NOCOPY varchar2(2000)
764 -- X_recipe_rout_step_tbl OUT NOCOPY recipe_rout_step_out
765 -- Version : Current Version 1.0
766 --
767 -- Notes :
768 -- End of comments
769
770 /*#
771 * Fetches the Recipe Step details
772 * This is a PL/SQL procedure to return the recipe step details based on the recipe_id
773 * passed to it. This information is for populating the data after the recipe_id is created
774 * @param p_api_version API version field
775 * @param p_init_msg_list Flag to check if message list intialized
776 * @param p_recipe_id ID of the Recipe
777 * @param P_organization_id Orgnanization ID of the Recipe
778 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
779 * @param x_msg_count Number of msg's on message stack
780 * @param x_msg_data Actual message data on message stack
781 * @param x_return_code SQLCODE returned
782 * @param x_recipe_step_out Table structure of Recipe Step table to return Recipe Step details
783 * @param p_val_scale_factor Scaling factor
784 * @param p_process_loss Process loss
785 * @rep:scope public
786 * @rep:lifecycle active
787 * @rep:displayname Fetch Recipe Step details procedure
788 * @rep:compatibility S
789 */
790 PROCEDURE get_recipe_step_details
791 ( p_api_version IN NUMBER ,
792 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
793 p_recipe_id IN NUMBER ,
794 p_organization_id IN NUMBER DEFAULT NULL ,
795 x_return_status OUT NOCOPY VARCHAR2 ,
796 x_msg_count OUT NOCOPY NUMBER ,
797 x_msg_data OUT NOCOPY VARCHAR2 ,
798 x_return_code OUT NOCOPY NUMBER ,
799 x_recipe_step_out OUT NOCOPY recipe_step_tbl ,
800 p_val_scale_factor IN NUMBER DEFAULT 1 ,
801 p_process_loss IN NUMBER DEFAULT 0,
802 p_routing_id IN NUMBER DEFAULT NULL
803 );
804
805 -- Start of commments
806 -- API name : get_step_depd_details
807 -- Type : Public
808 -- Function :
809 -- Paramaters :
810 -- IN : p_api_version IN NUMBER Required
811 -- p_init_msg_list IN Varchar2 Optional
812 --
813 -- p_recipe_no IN Varchar2
814 -- p_recipe_version IN Varchar2
815 -- p_recipe_id IN Number
816 --
817 -- x_return_status OUT NOCOPY varchar2(1)
818 -- x_msg_count OUT NOCOPY Number
819 -- x_msg_data OUT NOCOPY varchar2(2000)
823 -- Notes :
820 -- x_routing_depd_out OUT NOCOPY routing_depd_tbl
821 -- Version : Current Version 1.0
822 --
824 -- End of comments
825
826 /*#
827 * Fetches the Recipe Step Dependency details
828 * This is a PL/SQL procedure to return the step dependency information based on the
829 * recipe_id passed to it
830 * @param p_api_version API version field
831 * @param p_init_msg_list Flag to check if message list intialized
832 * @param p_recipe_id ID of the Recipe
833 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
834 * @param x_msg_count Number of msg's on message stack
835 * @param x_msg_data Actual message data on message stack
836 * @param x_return_code SQLCODE returned
837 * @param x_routing_depd_tbl Table structure to return Recipe Step dependency details
838 * @rep:scope public
839 * @rep:lifecycle active
840 * @rep:displayname Fetch Recipe Step Dependency details procedure
841 * @rep:compatibility S
842 */
843 PROCEDURE get_step_depd_details
844 ( p_api_version IN NUMBER ,
845 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
846 p_recipe_id IN NUMBER ,
847 x_return_status OUT NOCOPY VARCHAR2 ,
848 x_msg_count OUT NOCOPY NUMBER ,
849 x_msg_data OUT NOCOPY VARCHAR2 ,
850 x_return_code OUT NOCOPY NUMBER ,
851 x_routing_depd_tbl OUT NOCOPY routing_depd_tbl
852 );
853
854
855
856 -- Start of commments
857 -- API name : get_oprn_act_detl
858 -- Type : Public
859 -- Function :
860 -- Paramaters :
861 -- IN : p_api_version IN NUMBER Required
862 -- p_init_msg_list IN Varchar2 Optional
863 --
864 -- p_recipe_id IN Number
865 -- p_organization_id IN Number
866 -- x_return_status OUT NOCOPY varchar2(1)
867 -- x_msg_count OUT NOCOPY Number
868 -- x_msg_data OUT NOCOPY varchar2(2000)
869 -- X_oprn_act_tbl OUT NOCOPY oprn_act_out
870 -- Version : Current Version 1.0
871 --
872 -- Notes :
873 -- End of comments
874
875 /*#
876 * Fetches the Operation activity details
877 * This is a PL/SQL procedure to return the step, operation and activities details
878 * for a given recipe based on the recipe_id passed to it
879 * @param p_api_version API version field
880 * @param p_init_msg_list Flag to check if message list intialized
881 * @param p_recipe_id ID of the Recipe
882 * @param P_organization_id Orgnanization ID of the Recipe
883 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
884 * @param x_msg_count Number of msg's on message stack
885 * @param x_msg_data Actual message data on message stack
886 * @param x_return_code SQLCODE returned
887 * @param x_oprn_act_out Table structure to return Operation activities details
888 * @rep:scope public
889 * @rep:lifecycle active
890 * @rep:displayname Fetch Operation activity details procedure
891 * @rep:compatibility S
892 */
893 PROCEDURE get_oprn_act_detl
894 ( p_api_version IN NUMBER ,
895 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
896 p_recipe_id IN NUMBER ,
897 p_organization_id IN NUMBER DEFAULT NULL ,
898 x_return_status OUT NOCOPY VARCHAR2 ,
899 x_msg_count OUT NOCOPY NUMBER ,
900 x_msg_data OUT NOCOPY VARCHAR2 ,
901 x_return_code OUT NOCOPY NUMBER ,
902 x_oprn_act_out OUT NOCOPY oprn_act_tbl
903 );
904
905
906 -- Start of commments
907 -- API name : get_oprn_resc_detl
908 -- Type : Public
909 -- Function :
910 -- Paramaters :
911 -- IN : p_api_version IN NUMBER Required
912 -- p_init_msg_list IN Varchar2 Optional
913 --
914 -- p_recipe_no IN Varchar2
915 -- p_recipe_version IN NUMBER
916 -- p_recipe_id IN Number
917 -- x_return_status OUT NOCOPY varchar2(1)
918 -- x_msg_count OUT NOCOPY Number
919 -- x_msg_data OUT NOCOPY varchar2(2000)
920 -- x_oprn_resc_tbl OUT NOCOPY oprn_resc_out
921 -- Version : Current Version 1.0
922 --
923 -- Notes :
924 -- End of comments
925
926 /*#
927 * Fetches the Operation resource details
928 * This is a PL/SQL procedure to return the step, operation and activities,
929 * resources details for a given recipe based on the recipe_id passed to it
930 * @param p_api_version API version field
931 * @param p_init_msg_list Flag to check if message list intialized
932 * @param p_recipe_id ID of the Recipe
933 * @param P_organization_id Orgnanization ID of the Recipe
934 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
935 * @param x_msg_count Number of msg's on message stack
936 * @param x_msg_data Actual message data on message stack
937 * @param x_return_code SQLCODE returned
938 * @param X_oprn_resc_rec Table structure to return Operation resource details
939 * @rep:scope public
940 * @rep:lifecycle active
941 * @rep:displayname Fetch Operation resource details procedure
942 * @rep:compatibility S
943 */
947 p_recipe_id IN NUMBER ,
944 PROCEDURE get_oprn_resc_detl
945 ( p_api_version IN NUMBER ,
946 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
948 p_organization_id IN NUMBER DEFAULT NULL ,
949 x_return_status OUT NOCOPY VARCHAR2 ,
950 x_msg_count OUT NOCOPY NUMBER ,
951 x_msg_data OUT NOCOPY VARCHAR2 ,
952 x_return_code OUT NOCOPY NUMBER ,
953 X_oprn_resc_rec OUT NOCOPY oprn_resc_tbl
954 );
955
956
957 -- Start of commments
958 -- API name : get_recipe_process_param_detl
959 -- Type : Public
960 -- Function :
961 -- Paramaters :
962 -- IN : p_api_version IN NUMBER Required
963 -- p_init_msg_list IN Varchar2 Optional
964 --
965 -- p_recipe_id IN Number
966 -- p_orgn_code IN VARCHAR2
967 -- x_return_status OUT NOCOPY varchar2(1)
968 -- x_msg_count OUT NOCOPY Number
969 -- x_msg_data OUT NOCOPY varchar2(2000)
970 -- x_recp_resc_proc_param_tbl OUT NOCOPY recp_resc_proc_param_tbl
971 -- Version : Current Version 1.0
972 --
973 -- Notes :
974 -- End of comments
975
976 /*#
977 * Fetches the Recipe Process Parameters details
978 * This is a PL/SQL procedure to the process parameters for a recipe
979 * @param p_api_version API version field
980 * @param p_init_msg_list Flag to check if message list intialized
981 * @param p_recipe_id ID of the Recipe
982 * @param P_organization_id Orgnanization ID of the Recipe
983 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
984 * @param x_msg_count Number of msg's on message stack
985 * @param x_msg_data Actual message data on message stack
986 * @param X_recp_resc_proc_param_tbl Table structure to return Process parameter details
987 * @rep:scope public
988 * @rep:lifecycle active
989 * @rep:displayname Fetch Process parameters procedure
990 * @rep:compatibility S
991 */
992 PROCEDURE get_recipe_process_param_detl
993 ( p_api_version IN NUMBER ,
994 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
995 p_recipe_id IN NUMBER ,
996 p_organization_id IN NUMBER DEFAULT NULL ,
997 x_return_status OUT NOCOPY VARCHAR2 ,
998 x_msg_count OUT NOCOPY NUMBER ,
999 x_msg_data OUT NOCOPY VARCHAR2 ,
1000 X_recp_resc_proc_param_tbl OUT NOCOPY recp_resc_proc_param_tbl
1001 );
1002
1003 /*#
1004 * Fetches the Process Parameter description
1005 * This is a PL/SQL procedure is responsible for getting the
1006 * description for a given process parameter.
1007 * @param p_parameter_id ID of the process parameter
1008 * @param x_parameter_desc Description of the process parameter is returned
1009 * @rep:scope public
1010 * @rep:lifecycle active
1011 * @rep:displayname Fetch Process parameter Description procedure
1012 * @rep:compatibility S
1013 */
1014 PROCEDURE get_proc_param_desc(p_parameter_id IN NUMBER, x_parameter_desc OUT NOCOPY VARCHAR2);
1015
1016 /*#
1017 * Fetches the Process Parameter Units
1018 * This PL/SQL procedure is responsible for getting the
1019 * units for a given process parameter
1020 * @param p_parameter_id ID of the process parameter
1021 * @param x_units Units for the process parameter is returned
1022 * @rep:scope public
1023 * @rep:lifecycle active
1024 * @rep:displayname Fetch Process parameter Units procedure
1025 * @rep:compatibility S
1026 */
1027 PROCEDURE get_proc_param_units(p_parameter_id IN NUMBER, x_units OUT NOCOPY VARCHAR2);
1028
1029 /*#
1030 * Fetches the Contiguous Indicator Value
1031 * This PL/SQL procedure is responsible for getting the contiguous indicator
1032 * value set at Recipe - Orgn level or at the Recipe level in order
1033 * for the given input parameters
1034 * @param p_recipe_id Recipe ID for which cont ind setting is requested
1035 * @param p_orgn_id Organization ID for which cont ind setting is requested
1036 * @param p_recipe_validity_rule_id Validity Rule ID for which cont ind setting is requested
1037 * @param x_contiguous_ind Contiguous Ind value out parameter
1038 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
1039 * @rep:scope public
1040 * @rep:lifecycle active
1041 * @rep:displayname Fetch Contiguous Indicator Value procedure
1042 * @rep:compatibility S
1043 */
1044 PROCEDURE fetch_contiguous_ind( p_recipe_id IN NUMBER
1045 , p_orgn_id IN NUMBER
1046 , p_recipe_validity_rule_id IN NUMBER
1047 , x_contiguous_ind OUT NOCOPY NUMBER
1048 , x_return_status OUT NOCOPY VARCHAR2);
1049
1050 /*#
1051 * Fetches the Enhanced PI Indicator value at recipe header level
1052 * This PL/SQL procedure is responsible for getting the PI indicator
1053 * value set at Recipe header level
1054 * @param p_recipe_id Recipe ID for which Enhanced PI ind value is requested
1055 * @param p_recipe_validity_rule_id Validity Rule ID
1056 * @param x_enhanced_pi_ind Enhanced PI Ind value out parameter
1057 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
1058 * @rep:scope public
1059 * @rep:lifecycle active
1060 * @rep:displayname Fetch Enhanced PI Indicator Value procedure
1061 * @rep:compatibility S
1062 */
1063 PROCEDURE FETCH_ENHANCED_PI_IND (
1064 p_recipe_id IN NUMBER
1065 ,p_recipe_validity_rule_id IN NUMBER
1066 ,x_enhanced_pi_ind OUT NOCOPY VARCHAR2
1067 ,x_return_status OUT NOCOPY VARCHAR2);
1068
1069 END GMD_RECIPE_FETCH_PUB;
[Home] [Help]