1 PACKAGE GMD_RECIPE_DETAIL AS
2 /* $Header: GMDPRCDS.pls 120.5.12010000.2 2008/11/12 18:25:14 rnalla ship $ */
3 /*#
4 * This interface is used to create and update Recipe Details like Process Loss, Customers,
5 * Validity Rules and Routing Steps.
6 * This package defines and implements the procedures and datatypes required to
7 * create and update recipe details.
8 * @rep:scope public
9 * @rep:product GMD
10 * @rep:lifecycle active
11 * @rep:displayname Recipe Details API
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY GMD_RECIPE
14 */
15
16 /* Define all record types */
17 TYPE FLEX IS RECORD (
18 ATTRIBUTE_CATEGORY VARCHAR2(30),
19 ATTRIBUTE1 VARCHAR2(240) DEFAULT NULL,
20 ATTRIBUTE2 VARCHAR2(240),
21 ATTRIBUTE3 VARCHAR2(240),
22 ATTRIBUTE4 VARCHAR2(240),
23 ATTRIBUTE5 VARCHAR2(240),
24 ATTRIBUTE6 VARCHAR2(240),
25 ATTRIBUTE7 VARCHAR2(240),
26 ATTRIBUTE8 VARCHAR2(240),
27 ATTRIBUTE9 VARCHAR2(240),
28 ATTRIBUTE10 VARCHAR2(240),
29 ATTRIBUTE11 VARCHAR2(240),
30 ATTRIBUTE12 VARCHAR2(240),
31 ATTRIBUTE13 VARCHAR2(240),
32 ATTRIBUTE14 VARCHAR2(240),
33 ATTRIBUTE15 VARCHAR2(240),
34 ATTRIBUTE16 VARCHAR2(240),
35 ATTRIBUTE17 VARCHAR2(240),
36 ATTRIBUTE18 VARCHAR2(240),
37 ATTRIBUTE19 VARCHAR2(240),
38 ATTRIBUTE20 VARCHAR2(240),
39 ATTRIBUTE21 VARCHAR2(240),
40 ATTRIBUTE22 VARCHAR2(240),
41 ATTRIBUTE23 VARCHAR2(240),
42 ATTRIBUTE24 VARCHAR2(240),
43 ATTRIBUTE25 VARCHAR2(240),
44 ATTRIBUTE26 VARCHAR2(240),
45 ATTRIBUTE27 VARCHAR2(240),
46 ATTRIBUTE28 VARCHAR2(240),
47 ATTRIBUTE29 VARCHAR2(240),
48 ATTRIBUTE30 VARCHAR2(240)
49 );
50
51 TYPE UPDATE_FLEX IS RECORD (
52 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
53 ATTRIBUTE1 VARCHAR2(240) ,
54 ATTRIBUTE2 VARCHAR2(240) ,
55 ATTRIBUTE3 VARCHAR2(240) ,
56 ATTRIBUTE4 VARCHAR2(240) ,
57 ATTRIBUTE5 VARCHAR2(240) ,
58 ATTRIBUTE6 VARCHAR2(240) ,
59 ATTRIBUTE7 VARCHAR2(240) ,
60 ATTRIBUTE8 VARCHAR2(240) ,
61 ATTRIBUTE9 VARCHAR2(240) ,
62 ATTRIBUTE10 VARCHAR2(240) ,
63 ATTRIBUTE11 VARCHAR2(240) ,
64 ATTRIBUTE12 VARCHAR2(240) ,
65 ATTRIBUTE13 VARCHAR2(240) ,
66 ATTRIBUTE14 VARCHAR2(240) ,
67 ATTRIBUTE15 VARCHAR2(240) ,
68 ATTRIBUTE16 VARCHAR2(240) ,
69 ATTRIBUTE17 VARCHAR2(240) ,
70 ATTRIBUTE18 VARCHAR2(240) ,
71 ATTRIBUTE19 VARCHAR2(240) ,
72 ATTRIBUTE20 VARCHAR2(240) ,
73 ATTRIBUTE21 VARCHAR2(240) ,
74 ATTRIBUTE22 VARCHAR2(240) ,
75 ATTRIBUTE23 VARCHAR2(240) ,
76 ATTRIBUTE24 VARCHAR2(240) ,
77 ATTRIBUTE25 VARCHAR2(240) ,
78 ATTRIBUTE26 VARCHAR2(240) ,
79 ATTRIBUTE27 VARCHAR2(240) ,
80 ATTRIBUTE28 VARCHAR2(240) ,
81 ATTRIBUTE29 VARCHAR2(240) ,
82 ATTRIBUTE30 VARCHAR2(240)
83 );
84
85 TYPE RECIPE_DTL IS RECORD (
86 RECIPE_ID NUMBER ,
87 RECIPE_NO VARCHAR2(32) ,
88 RECIPE_VERSION NUMBER ,
89 USER_ID FND_USER.USER_ID%TYPE ,
90 USER_NAME FND_USER.USER_NAME%TYPE ,
91 ORGN_CODE VARCHAR2(4) ,
92 ORGANIZATION_ID NUMBER,
93 SITE_ID NUMBER,
94 ORG_ID NUMBER,
95 RECIPE_PROCESS_LOSS_ID NUMBER , /* for recipe process loss updates */
96 PROCESS_LOSS NUMBER , /* for routing steps */
97 ACTIVITY_FACTOR NUMBER , /* for recipe orgn activities */
98 MAX_CAPACITY NUMBER , /* for recipe orgn resources */
99 MIN_CAPACITY NUMBER , /* for recipe orgn resources */
100 PROCESS_PARAMETER_1 VARCHAR2(16) , /* for recipe orgn resources */
101 PROCESS_PARAMETER_2 VARCHAR2(16) , /* for recipe orgn resources */
102 PROCESS_PARAMETER_3 VARCHAR2(16) , /* for recipe orgn resources */
103 PROCESS_PARAMETER_4 VARCHAR2(16) , /* for recipe orgn resources */
104 PROCESS_PARAMETER_5 VARCHAR2(16) , /* for recipe orgn resources */
105 CUSTOMER_ID NUMBER ,
106 CUSTOMER_NO VARCHAR2(32) ,
107 ROUTINGSTEP_ID NUMBER ,
108 OPRN_LINE_ID NUMBER , /* for recipe orgn act */
109 RESOURCES VARCHAR2(16) , /* for recipe orgn resources */
110 PROCESS_UM VARCHAR2(25) ,
111 USAGE_UOM gmd_recipe_orgn_resources.USAGE_UOM%TYPE ,
112 RESOURCE_USAGE gmd_recipe_orgn_resources.RESOURCE_USAGE%TYPE,
113 PROCESS_QTY gmd_recipe_orgn_resources.PROCESS_QTY%TYPE ,
114 STEP_QTY gmd_recipe_routing_steps.STEP_QTY%TYPE,
115 MASS_QTY gmd_recipe_routing_steps.MASS_QTY%TYPE,
116 MASS_REF_UOM gmd_recipe_routing_steps.MASS_REF_UOM%TYPE,
117 VOLUME_QTY gmd_recipe_routing_steps.VOLUME_QTY%TYPE,
118 VOLUME_REF_UOM gmd_recipe_routing_steps.VOLUME_REF_UOM%TYPE,
119 MASS_STD_UOM gmd_recipe_routing_steps.MASS_STD_UOM%TYPE,
120 VOLUME_STD_UOM gmd_recipe_routing_steps.VOLUME_STD_UOM%TYPE,
121 TEXT_CODE NUMBER ,
122 DELETE_MARK NUMBER ,
123 CONTIGUOUS_IND NUMBER ,
124 CREATION_DATE DATE ,
125 CREATED_BY NUMBER ,
126 LAST_UPDATED_BY NUMBER ,
127 LAST_UPDATE_DATE DATE ,
128 LAST_UPDATE_LOGIN NUMBER ,
129 ITEM_ID NUMBER ,
130 OWNER_ID NUMBER,
131 FIXED_PROCESS_LOSS NUMBER, /* B6811759*/
132 FIXED_PROCESS_LOSS_UOM VARCHAR2(3) /* B6811759*/
133 );
134
135 TYPE RECIPE_VR IS RECORD (
136 RECIPE_VALIDITY_RULE_ID NUMBER
137 ,RECIPE_ID NUMBER
138 ,RECIPE_NO VARCHAR2(32)
139 ,RECIPE_VERSION NUMBER
140 ,USER_ID FND_USER.USER_ID%TYPE
141 ,USER_NAME FND_USER.USER_NAME%TYPE
142 ,ORGN_CODE VARCHAR2(4)
143 -- NPD Conv. Modified item_id to inventory_item_id and added Revision column.
144 ,INVENTORY_ITEM_ID NUMBER
145 ,REVISION VARCHAR2(3)
146 ,ITEM_NO VARCHAR2(40)
147 ,RECIPE_USE VARCHAR2(30)
148 ,PREFERENCE NUMBER
149 ,START_DATE DATE
150 ,END_DATE DATE
151 ,MIN_QTY NUMBER
152 ,MAX_QTY NUMBER
153 ,STD_QTY NUMBER
154 -- NPD Conv. Modified item_um to detail_uom
155 ,DETAIL_UOM VARCHAR2(25)
156 ,INV_MIN_QTY NUMBER
157 ,INV_MAX_QTY NUMBER
158 ,TEXT_CODE NUMBER
159 ,CREATED_BY NUMBER
160 ,CREATION_DATE DATE
161 ,LAST_UPDATED_BY NUMBER
162 ,LAST_UPDATE_DATE DATE
163 ,LAST_UPDATE_LOGIN NUMBER
164 ,DELETE_MARK NUMBER := 0
165 ,PLANNED_PROCESS_LOSS NUMBER
166 ,VALIDITY_RULE_STATUS VARCHAR2(30)
167 ,ORGANIZATION_ID NUMBER --w.r.t. bug 4004501 INVCONV kkillams
168 , FIXED_PROCESS_LOSS NUMBER /* B6811759*/
169 , FIXED_PROCESS_LOSS_UOM VARCHAR2(3) /* B6811759*/
170 );
171
172 TYPE RECIPE_MATERIAL IS RECORD (
173 RECIPE_ID NUMBER ,
174 RECIPE_NO VARCHAR2(32) ,
175 RECIPE_VERSION NUMBER ,
176 USER_ID FND_USER.USER_ID%TYPE ,
177 USER_NAME FND_USER.USER_NAME%TYPE ,
178 FORMULALINE_ID NUMBER ,
179 TEXT_CODE NUMBER ,
180 CREATION_DATE DATE ,
181 CREATED_BY NUMBER ,
182 LAST_UPDATED_BY NUMBER ,
183 LAST_UPDATE_DATE DATE ,
184 LAST_UPDATE_LOGIN NUMBER ,
185 ROUTINGSTEP_ID NUMBER
186 );
187
188 /* Define all table types based on the record types above */
189
190 TYPE recipe_detail_tbl IS TABLE OF RECIPE_DTL
191 INDEX BY BINARY_INTEGER;
192
193 TYPE recipe_flex IS TABLE OF FLEX
194 INDEX BY BINARY_INTEGER;
195
196 TYPE recipe_update_flex IS TABLE OF UPDATE_FLEX
197 INDEX BY BINARY_INTEGER;
198
199 TYPE recipe_vr_tbl IS TABLE OF RECIPE_VR
200 INDEX BY BINARY_INTEGER;
201
202 TYPE recipe_mtl_tbl IS TABLE OF RECIPE_MATERIAL
203 INDEX BY BINARY_INTEGER;
204
205
206 /*#
207 * Creates Recipe Process loss
208 * This PL/SQL procedure is responsible creating Recipe Process Loss
209 * Call is made to CREATE_RECIPE_PROCESS_LOSS of GMD_RECIPE_DETAIL_PVT package
210 * @param p_api_version API version field
211 * @param p_init_msg_list Flag to check if message list intialized
212 * @param p_commit Flag to check for commit
213 * @param p_called_from_forms Flag to check if API is called from a form
214 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
215 * @param x_msg_count Number of msg's on message stack
216 * @param x_msg_data Actual meesage data on message stack
217 * @param p_recipe_detail_tbl Table structure of recipe details
218 * @rep:scope public
219 * @rep:lifecycle active
220 * @rep:displayname Create Recipe Process Loss procedure
221 * @rep:compatibility S
222 */
223 PROCEDURE CREATE_RECIPE_PROCESS_LOSS
224 ( p_api_version IN NUMBER ,
225 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
226 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
227 p_called_from_forms IN VARCHAR2 := 'NO' ,
228 x_return_status OUT NOCOPY VARCHAR2 ,
229 x_msg_count OUT NOCOPY NUMBER ,
230 x_msg_data OUT NOCOPY VARCHAR2 ,
231 p_recipe_detail_tbl IN recipe_detail_tbl
232 );
233
234 /*#
235 * Creates Recipe Customers
236 * This PL/SQL procedure is responsible for creating Recipe Customers
237 * Call is made to CREATE_RECIPE_CUSTOMERS of GMD_RECIPE_DETAIL_PVT package
238 * @param p_api_version API version field
239 * @param p_init_msg_list Flag to check if message list intialized
240 * @param p_commit Flag to check for commit
241 * @param p_called_from_forms Flag to check if API is called from a form
242 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
243 * @param x_msg_count Number of msg's on message stack
244 * @param x_msg_data Actual meesage data on message stack
245 * @param p_recipe_detail_tbl Table structure of recipe details
246 * @rep:scope public
247 * @rep:lifecycle active
248 * @rep:displayname Create Recipe Customers procedure
249 * @rep:compatibility S
250 */
251 PROCEDURE CREATE_RECIPE_CUSTOMERS
252 ( p_api_version IN NUMBER ,
253 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
254 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
255 p_called_from_forms IN VARCHAR2 := 'NO' ,
256 x_return_status OUT NOCOPY VARCHAR2 ,
257 x_msg_count OUT NOCOPY NUMBER ,
258 x_msg_data OUT NOCOPY VARCHAR2 ,
259 p_recipe_detail_tbl IN recipe_detail_tbl
260 );
261
262 /*#
263 * Creates Recipe Validity Rules
264 * This PL/SQL procedure is responsible for creating Recipe Validity Rules
265 * Call is made to CREATE_RECIPE_VR of GMD_RECIPE_DETAIL_PVT package
266 * @param p_api_version API version field
267 * @param p_init_msg_list Flag to check if message list intialized
268 * @param p_commit Flag to check for commit
269 * @param p_called_from_forms Flag to check if API is called from a form
270 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
271 * @param x_msg_count Number of msg's on message stack
272 * @param x_msg_data Actual meesage data on message stack
273 * @param p_recipe_vr_tbl Table structure of validity rule details
274 * @param p_recipe_vr_flex Table structure of validity rule flex fields
275 * @rep:scope public
276 * @rep:lifecycle active
277 * @rep:displayname Create Recipe Validity Rule procedure
278 * @rep:compatibility S
279 */
280 PROCEDURE CREATE_RECIPE_VR
281 ( p_api_version IN NUMBER ,
282 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
283 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
284 p_called_from_forms IN VARCHAR2 := 'NO' ,
285 x_return_status OUT NOCOPY VARCHAR2 ,
286 x_msg_count OUT NOCOPY NUMBER ,
287 x_msg_data OUT NOCOPY VARCHAR2 ,
288 p_recipe_vr_tbl IN recipe_vr_tbl ,
289 p_recipe_vr_flex IN recipe_flex
290 );
291
292 /*#
293 * Creates an entry in Recipe Material Table
294 * This PL/SQL procedure creates an entry in Recipe Material Table
295 * Call is made to CREATE_RECIPE_MTL of GMD_RECIPE_DETAIL_PVT package
296 * @param p_api_version API version field
297 * @param p_init_msg_list Flag to check if message list intialized
298 * @param p_commit Flag to check for commit
299 * @param p_called_from_forms Flag to check if API is called from a form
300 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
301 * @param x_msg_count Number of msg's on message stack
302 * @param x_msg_data Actual meesage data on message stack
303 * @param p_recipe_mtl_tbl Table structure of recipe material table
304 * @rep:scope public
305 * @rep:lifecycle active
306 * @rep:displayname Create Recipe Material procedure
307 * @rep:compatibility S
308 */
309 PROCEDURE CREATE_RECIPE_MTL
310 ( p_api_version IN NUMBER ,
311 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
315 x_msg_count OUT NOCOPY NUMBER ,
312 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
313 p_called_from_forms IN VARCHAR2 := 'NO' ,
314 x_return_status OUT NOCOPY VARCHAR2 ,
316 x_msg_data OUT NOCOPY VARCHAR2 ,
317 p_recipe_mtl_tbl IN recipe_mtl_tbl ,
318 p_recipe_mtl_flex IN recipe_flex
319 );
320
321 /*#
322 * Updates Recipe Process Loss
323 * This PL/SQL procedure is responsible for updating Recipe Process Loss
324 * Call is made to of UPDATE_RECIPE_PROCESS_LOSS of GMD_RECIPE_DETAIL_PVT package
325 * @param p_api_version API version field
326 * @param p_init_msg_list Flag to check if message list intialized
327 * @param p_commit Flag to check for commit
328 * @param p_called_from_forms Flag to check if API is called from a form
329 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
330 * @param x_msg_count Number of msg's on message stack
331 * @param x_msg_data Actual meesage data on message stack
332 * @param p_recipe_detail_tbl Table structure of recipe detailsl table
333 * @rep:scope public
334 * @rep:lifecycle active
335 * @rep:displayname Update Recipe Process Loss procedure
336 * @rep:compatibility S
337 */
338 PROCEDURE UPDATE_RECIPE_PROCESS_LOSS
339 ( p_api_version IN NUMBER ,
340 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
341 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
342 p_called_from_forms IN VARCHAR2 := 'NO' ,
343 x_return_status OUT NOCOPY VARCHAR2 ,
344 x_msg_count OUT NOCOPY NUMBER ,
345 x_msg_data OUT NOCOPY VARCHAR2 ,
346 p_recipe_detail_tbl IN recipe_detail_tbl
347 );
348
349 /*#
350 * Updates Recipe Customers
351 * This PL/SQL procedure is responsible for updating Recipe Customers
352 * Call is made to UPDATE_RECIPE_CUSTOMERS of GMD_RECIPE_DETAIL_PVT package
353 * @param p_api_version API version field
354 * @param p_init_msg_list Flag to check if message list intialized
355 * @param p_commit Flag to check for commit
356 * @param p_called_from_forms Flag to check if API is called from a form
357 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
358 * @param x_msg_count Number of msg's on message stack
359 * @param x_msg_data Actual meesage data on message stack
360 * @param p_recipe_detail_tbl Table structure of recipe details
361 * @rep:scope public
362 * @rep:lifecycle active
363 * @rep:displayname Update Recipe Customers procedure
364 * @rep:compatibility S
365 */
366 PROCEDURE UPDATE_RECIPE_CUSTOMERS
367 ( p_api_version IN NUMBER ,
368 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
369 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
370 p_called_from_forms IN VARCHAR2 := 'NO' ,
371 x_return_status OUT NOCOPY VARCHAR2 ,
372 x_msg_count OUT NOCOPY NUMBER ,
373 x_msg_data OUT NOCOPY VARCHAR2 ,
374 p_recipe_detail_tbl IN recipe_detail_tbl
375 );
376
377 /*#
378 * Inserts/Updates Recipe Routing Steps
379 * This PL/SQL procedure is responsible for inserting/updating Recipe Routing Steps
380 * Call is made to RECIPE_ROUTING_STEPS of GMD_RECIPE_DETAIL_PVT package
381 * @param p_api_version API version field
382 * @param p_init_msg_list Flag to check if message list intialized
383 * @param p_commit Flag to check for commit
384 * @param p_called_from_forms Flag to check if API is called from a form
385 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
386 * @param x_msg_count Number of msg's on message stack
387 * @param x_msg_data Actual meesage data on message stack
388 * @param p_recipe_detail_tbl Table structure of recipe details
389 * @param p_recipe_insert_flex Table structure for insert of recipe flex fields
390 * @param p_recipe_update_flex Table structure for update of recipe flex fields
391 * @rep:scope public
392 * @rep:lifecycle active
393 * @rep:displayname Recipe Routing Steps procedure
394 * @rep:compatibility S
395 */
396 PROCEDURE RECIPE_ROUTING_STEPS
397 ( p_api_version IN NUMBER ,
398 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
399 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
400 p_called_from_forms IN VARCHAR2 := 'NO' ,
401 x_return_status OUT NOCOPY VARCHAR2 ,
402 x_msg_count OUT NOCOPY NUMBER ,
403 x_msg_data OUT NOCOPY VARCHAR2 ,
404 p_recipe_detail_tbl IN recipe_detail_tbl ,
405 p_recipe_insert_flex IN recipe_flex ,
406 p_recipe_update_flex IN recipe_update_flex
407 );
408
409 /*#
410 * Updates Recipe Validity Rules Table
411 * This PL/SQL procedure is responsible for updating Recipe Validity Rules
415 * @param p_commit Flag to check for commit
412 * Call is made to UPDATE_RECIPE_VR of GMD_RECIPE_DETAIL_PVT package
413 * @param p_api_version API version field
414 * @param p_init_msg_list Flag to check if message list intialized
416 * @param p_called_from_forms Flag to check if API is called from a form
417 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
418 * @param x_msg_count Number of msg's on message stack
419 * @param x_msg_data Actual meesage data on message stack
420 * @param p_recipe_vr_tbl Table structure of validity rule details
421 * @param p_recipe_update_flex Table structure for update of validity rule flex fields
422 * @rep:scope public
423 * @rep:lifecycle active
424 * @rep:displayname Update Recipe Validity Rule procedure
425 * @rep:compatibility S
426 */
427 PROCEDURE UPDATE_RECIPE_VR
428 ( p_api_version IN NUMBER ,
429 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
430 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
431 p_called_from_forms IN VARCHAR2 := 'NO' ,
432 x_return_status OUT NOCOPY VARCHAR2 ,
433 x_msg_count OUT NOCOPY NUMBER ,
434 x_msg_data OUT NOCOPY VARCHAR2 ,
435 p_recipe_vr_tbl IN recipe_vr_tbl ,
436 p_recipe_update_flex IN recipe_update_flex
437 );
438
439 /*#
440 * Inserts/Updates Recipe Organization Operations
441 * This PL/SQL procedure is responsible for inserting/ updating recipe orgn. activities
442 * Call is made to RECIPE_ORGN_OPERATIONS of GMD_RECIPE_DETAIL_PVT package
443 * @param p_api_version API version field
444 * @param p_init_msg_list Flag to check if message list intialized
445 * @param p_commit Flag to check for commit
446 * @param p_called_from_forms Flag to check if API is called from a form
447 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
448 * @param x_msg_count Number of msg's on message stack
449 * @param x_msg_data Actual meesage data on message stack
450 * @param p_recipe_detail_tbl Table structure of recipe details
451 * @param p_recipe_insert_flex Table structure for insert of recipe flex fields
452 * @param p_recipe_update_flex Table structure for update of recipe flex fields
453 * @rep:scope public
454 * @rep:lifecycle active
455 * @rep:displayname Recipe Organization Operations procedure
456 * @rep:compatibility S
457 */
458 PROCEDURE RECIPE_ORGN_OPERATIONS
459 ( p_api_version IN NUMBER ,
460 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
461 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
462 p_called_from_forms IN VARCHAR2 := 'NO' ,
463 x_return_status OUT NOCOPY VARCHAR2 ,
464 x_msg_count OUT NOCOPY NUMBER ,
465 x_msg_data OUT NOCOPY VARCHAR2 ,
466 p_recipe_detail_tbl IN recipe_detail_tbl ,
467 p_recipe_insert_flex IN recipe_flex ,
468 p_recipe_update_flex IN recipe_update_flex
469 );
470
471 /*#
472 * Inserts/Updates Recipe Organization Resources
473 * This PL/SQL procedure is responsible for inserting/ updating recipe orgn. resources
474 * Call is made to RECIPE_ORGN_RESOURCES of GMD_RECIPE_DETAIL_PVT package
475 * @param p_api_version API version field
476 * @param p_init_msg_list Flag to check if message list intialized
477 * @param p_commit Flag to check for commit
478 * @param p_called_from_forms Flag to check if API is called from a form
479 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
480 * @param x_msg_count Number of msg's on message stack
481 * @param x_msg_data Actual meesage data on message stack
482 * @param p_recipe_detail_tbl Table structure of recipe details
483 * @param p_recipe_insert_flex Table structure for insert of recipe flex fields
484 * @param p_recipe_update_flex Table structure for update of recipe flex fields
485 * @rep:scope public
486 * @rep:lifecycle active
487 * @rep:displayname Recipe Organization Resources procedure
488 * @rep:compatibility S
489 */
490 PROCEDURE RECIPE_ORGN_RESOURCES
491 ( p_api_version IN NUMBER ,
492 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
493 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
494 p_called_from_forms IN VARCHAR2 := 'NO' ,
495 x_return_status OUT NOCOPY VARCHAR2 ,
496 x_msg_count OUT NOCOPY NUMBER ,
497 x_msg_data OUT NOCOPY VARCHAR2 ,
498 p_recipe_detail_tbl IN recipe_detail_tbl ,
499 p_recipe_insert_flex IN recipe_flex ,
500 p_recipe_update_flex IN recipe_update_flex
501 );
502
503 END;