APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_ROUTING_STEPS

Line 1182: FROM gmd_recipe_routing_steps

1178: /* Null values should not passed as a paramter */
1179: /* This cursor decides whether to insert or update. */
1180: CURSOR recipe_rout_cur(vRecipe_id NUMBER, vRoutingStep_id NUMBER) IS
1181: SELECT recipe_id, routingstep_id
1182: FROM gmd_recipe_routing_steps
1183: where recipe_id = NVL(vRecipe_id,-1) AND
1184: RoutingStep_id = NVL(vRoutingStep_id,-1);
1185: BEGIN
1186: /* Updating recipe routing step for first time is in fact inserting a new record */

Line 1206: INSERT INTO GMD_RECIPE_ROUTING_STEPS (

1202:
1203: /* ++++++++++++++++INSERTs+++++++++++++++++++++++++ */
1204: IF (l_dml_type = 'I') THEN
1205: /* Assign flex fields */
1206: INSERT INTO GMD_RECIPE_ROUTING_STEPS (
1207: RECIPE_ID ,
1208: ROUTINGSTEP_ID ,
1209: STEP_QTY ,
1210: TEXT_CODE ,

Line 1301: UPDATE GMD_RECIPE_ROUTING_STEPS

1297: END IF; /* end of dml type */
1298:
1299: /* +++++++++++++++UPDATE+++++++++++++++++++++++++++ */
1300: IF (l_dml_type = 'U') THEN
1301: UPDATE GMD_RECIPE_ROUTING_STEPS
1302: SET
1303: STEP_QTY = p_recipe_detail_rec.step_qty,
1304: MASS_QTY = p_recipe_detail_rec.mass_qty,
1305: MASS_STD_UOM = p_recipe_detail_rec.mass_std_uom,