APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_STEP_MATERIALS

Line 651: FROM gmd_recipe_step_materials

647: X_rsrc_tbl rcp_rsrc;
648:
649: CURSOR Cur_step_mtl IS
650: SELECT *
651: FROM gmd_recipe_step_materials
652: WHERE recipe_id = p_recipe_id;
653: TYPE step_mtl IS TABLE OF Cur_step_mtl%ROWTYPE INDEX BY BINARY_INTEGER;
654: X_stepmtl_tbl step_mtl;
655:

Line 947: INSERT INTO gmd_recipe_step_materials(recipe_id, formulaline_id, routingstep_id, text_code, creation_date,

943:
944: -- Bug 3037410 Mohit Kapoor Added the if statement
945: IF p_routing_id is NULL AND p_formula_id is NULL THEN
946: FOR i IN 1..X_stepmtl_tbl.count LOOP
947: INSERT INTO gmd_recipe_step_materials(recipe_id, formulaline_id, routingstep_id, text_code, creation_date,
948: created_by, last_updated_by, last_update_date, last_update_login)
949: VALUES (x_recipe_id, X_stepmtl_tbl(i).formulaline_id, X_stepmtl_tbl(i).routingstep_id,
950: X_stepmtl_tbl(i).text_code, SYSDATE, P_created_by, P_created_by, SYSDATE, P_login_id);
951: END LOOP;