APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_ROUTING_STEPS

Line 1172: FROM gmd_recipe_routing_steps

1168: /* Null values should not passed as a paramter */
1169: /* This cursor decides whether to insert or update. */
1170: CURSOR recipe_rout_cur(vRecipe_id NUMBER, vRoutingStep_id NUMBER) IS
1171: SELECT recipe_id, routingstep_id
1172: FROM gmd_recipe_routing_steps
1173: where recipe_id = NVL(vRecipe_id,-1) AND
1174: RoutingStep_id = NVL(vRoutingStep_id,-1);
1175: BEGIN
1176: /* Updating recipe routing step for first time is in fact inserting a new record */

Line 1196: INSERT INTO GMD_RECIPE_ROUTING_STEPS (

1192:
1193: /* ++++++++++++++++INSERTs+++++++++++++++++++++++++ */
1194: IF (l_dml_type = 'I') THEN
1195: /* Assign flex fields */
1196: INSERT INTO GMD_RECIPE_ROUTING_STEPS (
1197: RECIPE_ID ,
1198: ROUTINGSTEP_ID ,
1199: STEP_QTY ,
1200: TEXT_CODE ,

Line 1291: UPDATE GMD_RECIPE_ROUTING_STEPS

1287: END IF; /* end of dml type */
1288:
1289: /* +++++++++++++++UPDATE+++++++++++++++++++++++++++ */
1290: IF (l_dml_type = 'U') THEN
1291: UPDATE GMD_RECIPE_ROUTING_STEPS
1292: SET
1293: STEP_QTY = p_recipe_detail_rec.step_qty,
1294: MASS_QTY = p_recipe_detail_rec.mass_qty,
1295: MASS_STD_UOM = p_recipe_detail_rec.mass_std_uom,