DBA Data[Home] [Help]

APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_ROUTING_STEPS

Line 622: FROM gmd_recipe_routing_steps

618: X_cust_tbl rcp_cust;
619:
620: CURSOR Cur_get_steps IS
621: SELECT *
622: FROM gmd_recipe_routing_steps
623: WHERE recipe_id = p_recipe_id;
624:
625: TYPE rcp_steps IS TABLE OF Cur_get_steps%ROWTYPE INDEX BY BINARY_INTEGER;
626: X_step_tbl rcp_steps;

Line 813: INSERT INTO gmd_recipe_routing_steps(recipe_id, routingstep_id, step_qty, created_by, creation_date,

809:
810: -- Bug 3037410 Mohit Kapoor Added the if statement
811: IF p_routing_id is NULL THEN
812: FOR i IN 1..X_step_tbl.count LOOP
813: INSERT INTO gmd_recipe_routing_steps(recipe_id, routingstep_id, step_qty, created_by, creation_date,
814: last_update_date, last_update_login, text_code, last_updated_by,
815: attribute1, attribute2, attribute3, attribute4, attribute5, attribute6,
816: attribute7, attribute8, attribute9, attribute10, attribute11, attribute12,
817: attribute13, attribute14, attribute15, attribute16, attribute17,