eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_DETAIL

Line 1: PACKAGE BODY GMD_RECIPE_DETAIL_PVT AS

1: PACKAGE BODY GMD_RECIPE_DETAIL_PVT AS
2: /* $Header: GMDVRCDB.pls 120.9.12010000.2 2008/11/12 18:15:04 rnalla ship $ */
3:
4: /* Define any variable specific to this package */
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RECIPE_DETAIL_PVT' ;

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RECIPE_DETAIL_PVT' ;

1: PACKAGE BODY GMD_RECIPE_DETAIL_PVT AS
2: /* $Header: GMDVRCDB.pls 120.9.12010000.2 2008/11/12 18:15:04 rnalla ship $ */
3:
4: /* Define any variable specific to this package */
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RECIPE_DETAIL_PVT' ;
6:
7: /* ================================================== */
8: /* Procedure: */
9: /* Create_Recipe_Process_loss */

Line 24: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,

20: /* */
21: /* End of comments */
22:
23: PROCEDURE CREATE_RECIPE_PROCESS_LOSS
24: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
25: x_return_status OUT NOCOPY VARCHAR2
26: ) IS
27: /* Defining all local variables */
28: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_PROCESS_LOSS';

Line 137: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,

133: /* Procedure : */
134: /* End of comments */
135:
136: PROCEDURE CREATE_RECIPE_CUSTOMERS
137: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
138: x_return_status OUT NOCOPY VARCHAR2
139: ) IS
140:
141: /* Defining all local variables */

Line 227: ( p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr

223: /* Procedure : */
224: /* End of comments */
225:
226: PROCEDURE CREATE_RECIPE_VR
227: ( p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr
228: ,p_recipe_vr_flex_rec IN GMD_RECIPE_DETAIL.flex
229: ,x_return_status OUT NOCOPY VARCHAR2
230: ) IS
231:

Line 228: ,p_recipe_vr_flex_rec IN GMD_RECIPE_DETAIL.flex

224: /* End of comments */
225:
226: PROCEDURE CREATE_RECIPE_VR
227: ( p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr
228: ,p_recipe_vr_flex_rec IN GMD_RECIPE_DETAIL.flex
229: ,x_return_status OUT NOCOPY VARCHAR2
230: ) IS
231:
232: /* Define all variables specific to this procedure */

Line 315: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := l_recipe_vr_id;

311: INTO l_recipe_vr_id
312: FROM sys.dual;
313:
314: --Added as part of Default Status Build 3408799
315: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := l_recipe_vr_id;
316:
317: INSERT INTO GMD_RECIPE_VALIDITY_RULES(
318: RECIPE_VALIDITY_RULE_ID
319: ,RECIPE_ID

Line 462: ( p_recipe_mtl_rec IN GMD_RECIPE_DETAIL.recipe_material,

458: /* Procedure : */
459: /* End of comments */
460:
461: PROCEDURE CREATE_RECIPE_MTL
462: ( p_recipe_mtl_rec IN GMD_RECIPE_DETAIL.recipe_material,
463: p_recipe_mtl_flex_rec IN GMD_RECIPE_DETAIL.flex,
464: x_return_status OUT NOCOPY VARCHAR2
465: ) IS
466:

Line 463: p_recipe_mtl_flex_rec IN GMD_RECIPE_DETAIL.flex,

459: /* End of comments */
460:
461: PROCEDURE CREATE_RECIPE_MTL
462: ( p_recipe_mtl_rec IN GMD_RECIPE_DETAIL.recipe_material,
463: p_recipe_mtl_flex_rec IN GMD_RECIPE_DETAIL.flex,
464: x_return_status OUT NOCOPY VARCHAR2
465: ) IS
466:
467: /* Define all variables specific to this procedure */

Line 580: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,

576: /* Procedure : */
577: /* End of comments */
578:
579: PROCEDURE UPDATE_RECIPE_PROCESS_LOSS
580: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
581: x_return_status OUT NOCOPY VARCHAR2
582: ) IS
583: /* Defining all local variables */
584: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_PROCESS_LOSS';

Line 664: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,

660: /* Procedure : */
661: /* End of comments */
662:
663: PROCEDURE UPDATE_RECIPE_CUSTOMERS
664: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
665: x_return_status OUT NOCOPY VARCHAR2
666: ) IS
667: /* Defining all local variables */
668: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_CUSTOMERS';

Line 719: (p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,

715: /* Type : Private */
716: /* Procedure : */
717: /* End of comments */
718: PROCEDURE UPDATE_RECIPE_VR
719: (p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,
720: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
721: x_return_status OUT NOCOPY VARCHAR2
722: ) IS
723:

Line 720: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,

716: /* Procedure : */
717: /* End of comments */
718: PROCEDURE UPDATE_RECIPE_VR
719: (p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,
720: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
721: x_return_status OUT NOCOPY VARCHAR2
722: ) IS
723:
724: /* Define all variables specific to this procedure */

Line 1156: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,

1152: /* Procedure : */
1153: /* End of comments */
1154:
1155: PROCEDURE RECIPE_ROUTING_STEPS
1156: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1157: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1158: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1159: x_return_status OUT NOCOPY VARCHAR2
1160: ) IS

Line 1157: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,

1153: /* End of comments */
1154:
1155: PROCEDURE RECIPE_ROUTING_STEPS
1156: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1157: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1158: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1159: x_return_status OUT NOCOPY VARCHAR2
1160: ) IS
1161: /* Define all variables specific to this procedure */

Line 1158: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,

1154:
1155: PROCEDURE RECIPE_ROUTING_STEPS
1156: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1157: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1158: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1159: x_return_status OUT NOCOPY VARCHAR2
1160: ) IS
1161: /* Define all variables specific to this procedure */
1162: l_dml_type VARCHAR2(1) := 'I';

Line 1360: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,

1356: /* Procedure : */
1357: /* End of comments */
1358:
1359: PROCEDURE RECIPE_ORGN_OPERATIONS
1360: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1361: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1362: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1363: x_return_status OUT NOCOPY VARCHAR2
1364: ) IS

Line 1361: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,

1357: /* End of comments */
1358:
1359: PROCEDURE RECIPE_ORGN_OPERATIONS
1360: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1361: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1362: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1363: x_return_status OUT NOCOPY VARCHAR2
1364: ) IS
1365:

Line 1362: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,

1358:
1359: PROCEDURE RECIPE_ORGN_OPERATIONS
1360: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1361: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1362: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1363: x_return_status OUT NOCOPY VARCHAR2
1364: ) IS
1365:
1366: /* Define all variables specific to this procedure */

Line 1559: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,

1555: /* Procedure : */
1556: /* End of comments */
1557:
1558: PROCEDURE RECIPE_ORGN_RESOURCES
1559: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1560: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1561: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1562: x_return_status OUT NOCOPY VARCHAR2
1563: ) IS

Line 1560: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,

1556: /* End of comments */
1557:
1558: PROCEDURE RECIPE_ORGN_RESOURCES
1559: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1560: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1561: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1562: x_return_status OUT NOCOPY VARCHAR2
1563: ) IS
1564:

Line 1561: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,

1557:
1558: PROCEDURE RECIPE_ORGN_RESOURCES
1559: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1560: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1561: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1562: x_return_status OUT NOCOPY VARCHAR2
1563: ) IS
1564:
1565: /* Define all variables specific to this procedure */

Line 1781: END GMD_RECIPE_DETAIL_PVT; /* Package end */

1777: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1779: END RECIPE_ORGN_RESOURCES;
1780:
1781: END GMD_RECIPE_DETAIL_PVT; /* Package end */