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;
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,