1 PACKAGE GMD_RECIPE_DETAIL AUTHID CURRENT_USER AS
2 /* $Header: GMDPRCDS.pls 120.9 2010/10/29 14:05:08 rborpatl 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 /*Bug no 10109808 -- Adding the below missing columns --Changes Start*/
187 MINIMUM_TRANSFER_QTY NUMBER ,
188 MINIMUM_DELAY NUMBER ,
189 MAXIMUM_DELAY NUMBER
190 /*Bug no 10109808 -- Adding the missing columns --Changes End */
191 );
192
193 /* Define all table types based on the record types above */
194
195 TYPE recipe_detail_tbl IS TABLE OF RECIPE_DTL
196 INDEX BY BINARY_INTEGER;
197
198 TYPE recipe_flex IS TABLE OF FLEX
199 INDEX BY BINARY_INTEGER;
200
201 TYPE recipe_update_flex IS TABLE OF UPDATE_FLEX
202 INDEX BY BINARY_INTEGER;
203
204 TYPE recipe_vr_tbl IS TABLE OF RECIPE_VR
205 INDEX BY BINARY_INTEGER;
206
207 TYPE recipe_mtl_tbl IS TABLE OF RECIPE_MATERIAL
208 INDEX BY BINARY_INTEGER;
209
210
211 /*#
212 * Creates Recipe Process loss
213 * This PL/SQL procedure is responsible creating Recipe Process Loss
214 * Call is made to CREATE_RECIPE_PROCESS_LOSS of GMD_RECIPE_DETAIL_PVT package
215 * @param p_api_version API version field
216 * @param p_init_msg_list Flag to check if message list intialized
217 * @param p_commit Flag to check for commit
218 * @param p_called_from_forms Flag to check if API is called from a form
219 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
220 * @param x_msg_count Number of msg's on message stack
221 * @param x_msg_data Actual meesage data on message stack
222 * @param p_recipe_detail_tbl Table structure of recipe details
223 * @rep:scope public
224 * @rep:lifecycle active
225 * @rep:displayname Create Recipe Process Loss procedure
226 * @rep:compatibility S
227 */
228 PROCEDURE CREATE_RECIPE_PROCESS_LOSS
229 ( p_api_version IN NUMBER ,
230 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
231 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
232 p_called_from_forms IN VARCHAR2 := 'NO' ,
233 x_return_status OUT NOCOPY VARCHAR2 ,
234 x_msg_count OUT NOCOPY NUMBER ,
235 x_msg_data OUT NOCOPY VARCHAR2 ,
236 p_recipe_detail_tbl IN recipe_detail_tbl
237 );
238
239 /*#
240 * Creates Recipe Customers
241 * This PL/SQL procedure is responsible for creating Recipe Customers
242 * Call is made to CREATE_RECIPE_CUSTOMERS of GMD_RECIPE_DETAIL_PVT package
243 * @param p_api_version API version field
244 * @param p_init_msg_list Flag to check if message list intialized
245 * @param p_commit Flag to check for commit
246 * @param p_called_from_forms Flag to check if API is called from a form
247 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
248 * @param x_msg_count Number of msg's on message stack
249 * @param x_msg_data Actual meesage data on message stack
250 * @param p_recipe_detail_tbl Table structure of recipe details
251 * @rep:scope public
252 * @rep:lifecycle active
253 * @rep:displayname Create Recipe Customers procedure
254 * @rep:compatibility S
255 */
256 PROCEDURE CREATE_RECIPE_CUSTOMERS
257 ( p_api_version IN NUMBER ,
258 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
259 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
260 p_called_from_forms IN VARCHAR2 := 'NO' ,
261 x_return_status OUT NOCOPY VARCHAR2 ,
262 x_msg_count OUT NOCOPY NUMBER ,
263 x_msg_data OUT NOCOPY VARCHAR2 ,
264 p_recipe_detail_tbl IN recipe_detail_tbl
265 );
266
267 /*#
268 * Creates Recipe Validity Rules
269 * This PL/SQL procedure is responsible for creating Recipe Validity Rules
270 * Call is made to CREATE_RECIPE_VR of GMD_RECIPE_DETAIL_PVT package
271 * @param p_api_version API version field
272 * @param p_init_msg_list Flag to check if message list intialized
273 * @param p_commit Flag to check for commit
274 * @param p_called_from_forms Flag to check if API is called from a form
275 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
276 * @param x_msg_count Number of msg's on message stack
277 * @param x_msg_data Actual meesage data on message stack
278 * @param p_recipe_vr_tbl Table structure of validity rule details
279 * @param p_recipe_vr_flex Table structure of validity rule flex fields
280 * @rep:scope public
281 * @rep:lifecycle active
282 * @rep:displayname Create Recipe Validity Rule procedure
283 * @rep:compatibility S
284 */
285 PROCEDURE CREATE_RECIPE_VR
286 ( p_api_version IN NUMBER ,
287 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
288 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
289 p_called_from_forms IN VARCHAR2 := 'NO' ,
290 x_return_status OUT NOCOPY VARCHAR2 ,
291 x_msg_count OUT NOCOPY NUMBER ,
292 x_msg_data OUT NOCOPY VARCHAR2 ,
293 p_recipe_vr_tbl IN recipe_vr_tbl ,
294 p_recipe_vr_flex IN recipe_flex
295 );
296
297 /*#
298 * Creates an entry in Recipe Material Table
299 * This PL/SQL procedure creates an entry in Recipe Material Table
300 * Call is made to CREATE_RECIPE_MTL of GMD_RECIPE_DETAIL_PVT package
301 * @param p_api_version API version field
302 * @param p_init_msg_list Flag to check if message list intialized
303 * @param p_commit Flag to check for commit
304 * @param p_called_from_forms Flag to check if API is called from a form
305 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
306 * @param x_msg_count Number of msg's on message stack
307 * @param x_msg_data Actual meesage data on message stack
308 * @param p_recipe_mtl_tbl Table structure of recipe material table
309 * @rep:scope public
310 * @rep:lifecycle active
311 * @rep:displayname Create Recipe Material procedure
312 * @rep:compatibility S
313 */
314 PROCEDURE CREATE_RECIPE_MTL
315 ( p_api_version IN NUMBER ,
316 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
317 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
318 p_called_from_forms IN VARCHAR2 := 'NO' ,
319 x_return_status OUT NOCOPY VARCHAR2 ,
323 p_recipe_mtl_flex IN recipe_flex
320 x_msg_count OUT NOCOPY NUMBER ,
321 x_msg_data OUT NOCOPY VARCHAR2 ,
322 p_recipe_mtl_tbl IN recipe_mtl_tbl ,
324 );
325
326 /*#
327 * Updates Recipe Process Loss
328 * This PL/SQL procedure is responsible for updating Recipe Process Loss
329 * Call is made to of UPDATE_RECIPE_PROCESS_LOSS of GMD_RECIPE_DETAIL_PVT package
330 * @param p_api_version API version field
331 * @param p_init_msg_list Flag to check if message list intialized
332 * @param p_commit Flag to check for commit
333 * @param p_called_from_forms Flag to check if API is called from a form
334 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
335 * @param x_msg_count Number of msg's on message stack
336 * @param x_msg_data Actual meesage data on message stack
337 * @param p_recipe_detail_tbl Table structure of recipe detailsl table
338 * @rep:scope public
339 * @rep:lifecycle active
340 * @rep:displayname Update Recipe Process Loss procedure
341 * @rep:compatibility S
342 */
343 PROCEDURE UPDATE_RECIPE_PROCESS_LOSS
344 ( p_api_version IN NUMBER ,
345 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
346 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
347 p_called_from_forms IN VARCHAR2 := 'NO' ,
348 x_return_status OUT NOCOPY VARCHAR2 ,
349 x_msg_count OUT NOCOPY NUMBER ,
350 x_msg_data OUT NOCOPY VARCHAR2 ,
351 p_recipe_detail_tbl IN recipe_detail_tbl
352 );
353
354 /*#
355 * Updates Recipe Customers
356 * This PL/SQL procedure is responsible for updating Recipe Customers
357 * Call is made to UPDATE_RECIPE_CUSTOMERS of GMD_RECIPE_DETAIL_PVT package
358 * @param p_api_version API version field
359 * @param p_init_msg_list Flag to check if message list intialized
360 * @param p_commit Flag to check for commit
361 * @param p_called_from_forms Flag to check if API is called from a form
362 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
363 * @param x_msg_count Number of msg's on message stack
364 * @param x_msg_data Actual meesage data on message stack
365 * @param p_recipe_detail_tbl Table structure of recipe details
366 * @rep:scope public
367 * @rep:lifecycle active
368 * @rep:displayname Update Recipe Customers procedure
369 * @rep:compatibility S
370 */
371 PROCEDURE UPDATE_RECIPE_CUSTOMERS
372 ( p_api_version IN NUMBER ,
373 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
374 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
375 p_called_from_forms IN VARCHAR2 := 'NO' ,
376 x_return_status OUT NOCOPY VARCHAR2 ,
377 x_msg_count OUT NOCOPY NUMBER ,
378 x_msg_data OUT NOCOPY VARCHAR2 ,
379 p_recipe_detail_tbl IN recipe_detail_tbl
380 );
381
382 /*#
383 * Inserts/Updates Recipe Routing Steps
384 * This PL/SQL procedure is responsible for inserting/updating Recipe Routing Steps
385 * Call is made to RECIPE_ROUTING_STEPS of GMD_RECIPE_DETAIL_PVT package
386 * @param p_api_version API version field
387 * @param p_init_msg_list Flag to check if message list intialized
388 * @param p_commit Flag to check for commit
389 * @param p_called_from_forms Flag to check if API is called from a form
390 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
391 * @param x_msg_count Number of msg's on message stack
392 * @param x_msg_data Actual meesage data on message stack
393 * @param p_recipe_detail_tbl Table structure of recipe details
394 * @param p_recipe_insert_flex Table structure for insert of recipe flex fields
395 * @param p_recipe_update_flex Table structure for update of recipe flex fields
396 * @rep:scope public
397 * @rep:lifecycle active
398 * @rep:displayname Recipe Routing Steps procedure
399 * @rep:compatibility S
400 */
401 PROCEDURE RECIPE_ROUTING_STEPS
402 ( p_api_version IN NUMBER ,
403 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
404 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
405 p_called_from_forms IN VARCHAR2 := 'NO' ,
406 x_return_status OUT NOCOPY VARCHAR2 ,
407 x_msg_count OUT NOCOPY NUMBER ,
408 x_msg_data OUT NOCOPY VARCHAR2 ,
409 p_recipe_detail_tbl IN recipe_detail_tbl ,
410 p_recipe_insert_flex IN recipe_flex ,
411 p_recipe_update_flex IN recipe_update_flex
412 );
413
414 /*#
415 * Updates Recipe Validity Rules Table
416 * This PL/SQL procedure is responsible for updating Recipe Validity Rules
417 * Call is made to UPDATE_RECIPE_VR of GMD_RECIPE_DETAIL_PVT package
418 * @param p_api_version API version field
419 * @param p_init_msg_list Flag to check if message list intialized
420 * @param p_commit Flag to check for commit
421 * @param p_called_from_forms Flag to check if API is called from a form
425 * @param p_recipe_vr_tbl Table structure of validity rule details
422 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
423 * @param x_msg_count Number of msg's on message stack
424 * @param x_msg_data Actual meesage data on message stack
426 * @param p_recipe_update_flex Table structure for update of validity rule flex fields
427 * @rep:scope public
428 * @rep:lifecycle active
429 * @rep:displayname Update Recipe Validity Rule procedure
430 * @rep:compatibility S
431 */
432 PROCEDURE UPDATE_RECIPE_VR
433 ( p_api_version IN NUMBER ,
434 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
435 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
436 p_called_from_forms IN VARCHAR2 := 'NO' ,
437 x_return_status OUT NOCOPY VARCHAR2 ,
438 x_msg_count OUT NOCOPY NUMBER ,
439 x_msg_data OUT NOCOPY VARCHAR2 ,
440 p_recipe_vr_tbl IN recipe_vr_tbl ,
441 p_recipe_update_flex IN recipe_update_flex
442 );
443
444 /*#
445 * Inserts/Updates Recipe Organization Operations
446 * This PL/SQL procedure is responsible for inserting/ updating recipe orgn. activities
447 * Call is made to RECIPE_ORGN_OPERATIONS of GMD_RECIPE_DETAIL_PVT package
448 * @param p_api_version API version field
449 * @param p_init_msg_list Flag to check if message list intialized
450 * @param p_commit Flag to check for commit
451 * @param p_called_from_forms Flag to check if API is called from a form
452 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
453 * @param x_msg_count Number of msg's on message stack
454 * @param x_msg_data Actual meesage data on message stack
455 * @param p_recipe_detail_tbl Table structure of recipe details
456 * @param p_recipe_insert_flex Table structure for insert of recipe flex fields
457 * @param p_recipe_update_flex Table structure for update of recipe flex fields
458 * @rep:scope public
459 * @rep:lifecycle active
460 * @rep:displayname Recipe Organization Operations procedure
461 * @rep:compatibility S
462 */
463 PROCEDURE RECIPE_ORGN_OPERATIONS
464 ( p_api_version IN NUMBER ,
465 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
466 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
467 p_called_from_forms IN VARCHAR2 := 'NO' ,
468 x_return_status OUT NOCOPY VARCHAR2 ,
469 x_msg_count OUT NOCOPY NUMBER ,
470 x_msg_data OUT NOCOPY VARCHAR2 ,
471 p_recipe_detail_tbl IN recipe_detail_tbl ,
472 p_recipe_insert_flex IN recipe_flex ,
473 p_recipe_update_flex IN recipe_update_flex
474 );
475
476 /*#
477 * Inserts/Updates Recipe Organization Resources
478 * This PL/SQL procedure is responsible for inserting/ updating recipe orgn. resources
479 * Call is made to RECIPE_ORGN_RESOURCES of GMD_RECIPE_DETAIL_PVT package
480 * @param p_api_version API version field
481 * @param p_init_msg_list Flag to check if message list intialized
482 * @param p_commit Flag to check for commit
483 * @param p_called_from_forms Flag to check if API is called from a form
484 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
485 * @param x_msg_count Number of msg's on message stack
486 * @param x_msg_data Actual meesage data on message stack
487 * @param p_recipe_detail_tbl Table structure of recipe details
488 * @param p_recipe_insert_flex Table structure for insert of recipe flex fields
489 * @param p_recipe_update_flex Table structure for update of recipe flex fields
490 * @rep:scope public
491 * @rep:lifecycle active
492 * @rep:displayname Recipe Organization Resources procedure
493 * @rep:compatibility S
494 */
495 PROCEDURE RECIPE_ORGN_RESOURCES
496 ( p_api_version IN NUMBER ,
497 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
498 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
499 p_called_from_forms IN VARCHAR2 := 'NO' ,
500 x_return_status OUT NOCOPY VARCHAR2 ,
501 x_msg_count OUT NOCOPY NUMBER ,
502 x_msg_data OUT NOCOPY VARCHAR2 ,
503 p_recipe_detail_tbl IN recipe_detail_tbl ,
504 p_recipe_insert_flex IN recipe_flex ,
505 p_recipe_update_flex IN recipe_update_flex
506 );
507
508 END;