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.12 2010/10/29 14:11:10 rborpatl 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.12 2010/10/29 14:11:10 rborpatl 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 590: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,

586: /* Procedure : */
587: /* End of comments */
588:
589: PROCEDURE UPDATE_RECIPE_PROCESS_LOSS
590: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
591: x_return_status OUT NOCOPY VARCHAR2
592: ) IS
593: /* Defining all local variables */
594: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_PROCESS_LOSS';

Line 674: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,

670: /* Procedure : */
671: /* End of comments */
672:
673: PROCEDURE UPDATE_RECIPE_CUSTOMERS
674: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl,
675: x_return_status OUT NOCOPY VARCHAR2
676: ) IS
677: /* Defining all local variables */
678: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_CUSTOMERS';

Line 729: (p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,

725: /* Type : Private */
726: /* Procedure : */
727: /* End of comments */
728: PROCEDURE UPDATE_RECIPE_VR
729: (p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,
730: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
731: x_return_status OUT NOCOPY VARCHAR2
732: ) IS
733:

Line 730: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,

726: /* Procedure : */
727: /* End of comments */
728: PROCEDURE UPDATE_RECIPE_VR
729: (p_recipe_vr_rec IN GMD_RECIPE_DETAIL.recipe_vr ,
730: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
731: x_return_status OUT NOCOPY VARCHAR2
732: ) IS
733:
734: /* Define all variables specific to this procedure */

Line 1166: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,

1162: /* Procedure : */
1163: /* End of comments */
1164:
1165: PROCEDURE RECIPE_ROUTING_STEPS
1166: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1167: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1168: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1169: x_return_status OUT NOCOPY VARCHAR2
1170: ) IS

Line 1167: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,

1163: /* End of comments */
1164:
1165: PROCEDURE RECIPE_ROUTING_STEPS
1166: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1167: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1168: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1169: x_return_status OUT NOCOPY VARCHAR2
1170: ) IS
1171: /* Define all variables specific to this procedure */

Line 1168: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,

1164:
1165: PROCEDURE RECIPE_ROUTING_STEPS
1166: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1167: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1168: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1169: x_return_status OUT NOCOPY VARCHAR2
1170: ) IS
1171: /* Define all variables specific to this procedure */
1172: l_dml_type VARCHAR2(1) := 'I';

Line 1370: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,

1366: /* Procedure : */
1367: /* End of comments */
1368:
1369: PROCEDURE RECIPE_ORGN_OPERATIONS
1370: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1371: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1372: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1373: x_return_status OUT NOCOPY VARCHAR2
1374: ) IS

Line 1371: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,

1367: /* End of comments */
1368:
1369: PROCEDURE RECIPE_ORGN_OPERATIONS
1370: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1371: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1372: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1373: x_return_status OUT NOCOPY VARCHAR2
1374: ) IS
1375:

Line 1372: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,

1368:
1369: PROCEDURE RECIPE_ORGN_OPERATIONS
1370: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1371: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1372: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1373: x_return_status OUT NOCOPY VARCHAR2
1374: ) IS
1375:
1376: /* Define all variables specific to this procedure */

Line 1569: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,

1565: /* Procedure : */
1566: /* End of comments */
1567:
1568: PROCEDURE RECIPE_ORGN_RESOURCES
1569: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1570: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1571: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1572: x_return_status OUT NOCOPY VARCHAR2
1573: ) IS

Line 1570: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,

1566: /* End of comments */
1567:
1568: PROCEDURE RECIPE_ORGN_RESOURCES
1569: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1570: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1571: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1572: x_return_status OUT NOCOPY VARCHAR2
1573: ) IS
1574:

Line 1571: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,

1567:
1568: PROCEDURE RECIPE_ORGN_RESOURCES
1569: ( p_recipe_detail_rec IN GMD_RECIPE_DETAIL.recipe_dtl ,
1570: p_flex_insert_rec IN GMD_RECIPE_DETAIL.flex ,
1571: p_flex_update_rec IN GMD_RECIPE_DETAIL.update_flex ,
1572: x_return_status OUT NOCOPY VARCHAR2
1573: ) IS
1574:
1575: /* Define all variables specific to this procedure */

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

1787: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: END RECIPE_ORGN_RESOURCES;
1790:
1791: END GMD_RECIPE_DETAIL_PVT; /* Package end */