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 dependencies on GMD_RECIPES

Line 51: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

47: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_PROCESS_LOSS';
48: l_api_version CONSTANT NUMBER := 1.0;
49:
50: l_user_id fnd_user.user_id%TYPE := 0;
51: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
52:
53: /* Variables used for defining status */
54: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
55: l_return_code NUMBER := 0;

Line 265: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

261: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_CUSTOMERS';
262: l_api_version CONSTANT NUMBER := 1.0;
263:
264: l_user_id fnd_user.user_id%TYPE := 0;
265: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
266: l_customer_id NUMBER := 0;
267: l_site_id NUMBER := 0;
268: l_org_id NUMBER := 0;
269:

Line 533: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

529: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_VR';
530: l_api_version CONSTANT NUMBER := 1.0;
531:
532: l_user_id fnd_user.user_id%TYPE := 0;
533: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
534:
535: /* Variables used for defining status */
536: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
537: l_return_code NUMBER := 0;

Line 559: FROM fm_matl_dtl f, gmd_recipes_b r

555: /* Get the matl dtl for the main product */
556: Cursor get_certain_VR_defaults(vRecipe_id NUMBER) IS
557: -- NPD Conv.
558: SELECT inventory_item_id, qty, detail_uom
559: FROM fm_matl_dtl f, gmd_recipes_b r
560: WHERE f.formula_id = r.formula_id
561: AND r.recipe_id = vRecipe_id
562: AND f.line_type = 1
563: AND f.line_no = 1;

Line 568: FROM fm_matl_dtl f, gmd_recipes_b r

564:
565: /* get the matl details for the item passed in */
566: Cursor get_specific_VR_details(vRecipe_id NUMBER, vItem_id NUMBER) IS
567: SELECT qty, detail_uom
568: FROM fm_matl_dtl f, gmd_recipes_b r
569: WHERE f.formula_id = r.formula_id
570: AND r.recipe_id = vRecipe_id
571: AND f.line_type IN (1,2)
572: AND f.inventory_item_id = vItem_id

Line 586: FROM gmd_routings_b rt, gmd_recipes_b rc

582: /* Chcek VR dates against Routing dates */
583: CURSOR Get_Routing_Details(vRecipe_id NUMBER) IS
584: SELECT rt.Effective_Start_Date,
585: rt.Effective_End_Date
586: FROM gmd_routings_b rt, gmd_recipes_b rc
587: WHERE rc.routing_id = rt.routing_id AND
588: rc.recipe_id = vRecipe_id AND
589: rt.delete_mark = 0;
590:

Line 595: From fm_form_mst h, gmd_recipes_b r

591: CURSOR check_fmhdr_fixed_scale(vRecipe_id NUMBER) IS
592: SELECT 1
593: FROM sys.dual
594: WHERE EXISTS (Select h.formula_id
595: From fm_form_mst h, gmd_recipes_b r
596: WHERE r.formula_id = h.formula_id AND
597: r.recipe_id = vRecipe_id AND
598: h.scale_type = 0);
599:

Line 821: --Add this code after the call to gmd_recipes_mls.insert_row.

817: SAVEPOINT default_status_sp;
818: gmd_api_grp.get_status_details (V_entity_type => 'VALIDITY',
819: V_orgn_id => p_recipe_vr_rec.organization_id, --w.r.t. bug 4004501 INVCONV kkillams.
820: X_entity_status => l_entity_status);
821: --Add this code after the call to gmd_recipes_mls.insert_row.
822: IF (l_entity_status.entity_status <> 100) THEN
823: Gmd_status_pub.modify_status ( p_api_version => 1
824: , p_init_msg_list => TRUE
825: , p_entity_name => 'VALIDITY'

Line 934: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

930: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_MTL';
931: l_api_version CONSTANT NUMBER := 1.0;
932:
933: l_user_id fnd_user.user_id%TYPE := 0;
934: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
935:
936: /* Variables used for defining status */
937: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
938: l_return_code NUMBER := 0;

Line 1217: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

1213: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_PROCESS_LOSS';
1214: l_api_version CONSTANT NUMBER := 1.0;
1215:
1216: l_user_id fnd_user.user_id%TYPE := 0;
1217: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1218:
1219: /* Variables used for defining status */
1220: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1221: l_return_code NUMBER := 0;

Line 1439: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

1435: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_CUSTOMERS';
1436: l_api_version CONSTANT NUMBER := 1.0;
1437:
1438: l_user_id fnd_user.user_id%TYPE := 0;
1439: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1440: l_customer_id NUMBER := 0;
1441: l_site_id NUMBER := 0;
1442: l_org_id NUMBER := 0;
1443:

Line 1659: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

1655: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_VR';
1656: l_api_version CONSTANT NUMBER := 2.0;
1657:
1658: l_user_id fnd_user.user_id%TYPE;
1659: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1660:
1661: /* Variables used for defining status */
1662: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1663: l_return_code NUMBER := 0;

Line 2148: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

2144: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ROUTING_STEPS';
2145: l_api_version CONSTANT NUMBER := 2.0;
2146:
2147: l_user_id fnd_user.user_id%TYPE := 0;
2148: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2149:
2150: /* Variables used for defining status */
2151: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2152: l_return_code NUMBER := 0;

Line 2612: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

2608: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ORGN_OPERATIONS';
2609: l_api_version CONSTANT NUMBER := 2.0;
2610: l_rowid VARCHAR2(32);
2611: l_user_id fnd_user.user_id%TYPE := 0;
2612: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2613:
2614: /* Variables used for defining status */
2615: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2616: l_return_code NUMBER := 0;

Line 3058: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;

3054: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ORGN_RESOURCES';
3055: l_api_version CONSTANT NUMBER := 2.0;
3056:
3057: l_user_id fnd_user.user_id%TYPE := 0;
3058: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
3059:
3060: /* Variables used for defining status */
3061: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
3062: l_return_code NUMBER := 0;