The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
)
IS
/* procedure to initialize and run Workflow */
l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMDRPLAP';
l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_recipe_id)||'-'||to_char(p_last_update_date,'dd-MON-yyyy HH24:mi:ss');
SELECT USER_NAME , DESCRIPTION
INTO l_performer_name ,l_performer_display_name
FROM FND_USER
WHERE USER_ID = p_Requester;
SELECT A.RECIPE_DESCRIPTION, A.OWNER_ID, A.CREATION_ORGANIZATION_ID, C.FORMULA_NO, C.FORMULA_VERS, B.ROUTING_NO, B.ROUTING_VERS
INTO l_recipe_description, l_owner_id, l_creation_orgn_id, l_formula_no, l_formula_vers, l_routing_no, l_routing_vers
FROM GMD_RECIPES A, GMD_ROUTINGS B, FM_FORM_MST C
WHERE A.RECIPE_ID = P_RECIPE_ID
AND A.ROUTING_ID = B.ROUTING_ID (+)
AND A.FORMULA_ID = C.FORMULA_ID;
SELECT USER_NAME , DESCRIPTION
INTO l_performer_name ,l_performer_display_name
FROM FND_USER
WHERE USER_ID = l_owner_id;
UPDATE GMD_RECIPES_B
SET RECIPE_STATUS = l_target_status
WHERE RECIPE_ID = l_recipe_id;
SELECT r.owner_organization_id, r.formula_id, r.recipe_no, r.recipe_version, f.formula_status
FROM gmd_recipes_b r, fm_form_mst_b f
WHERE r.recipe_id = l_recipe_id
AND r.formula_id = f.formula_id;
SELECT recipe_use_prod, recipe_use_plan, recipe_use_cost, recipe_use_reg, recipe_use_tech, managing_validity_rules
FROM gmd_recipe_generation
WHERE (organization_id = l_orgn_id OR
organization_id IS NULL)
ORDER BY orgn_code;
UPDATE GMD_RECIPES_B
SET RECIPE_STATUS = l_target_status
WHERE RECIPE_ID = l_recipe_id;
SELECT rework_status into l_rework_status
FROM GMD_STATUS_NEXT
WHERE current_status = l_start_status
AND target_status = l_target_status
AND pending_status IS NOT NULL;
UPDATE GMD_RECIPES_B
SET RECIPE_STATUS = l_rework_status
WHERE RECIPE_ID = l_recipe_id;
UPDATE GMD_RECIPES_B
SET RECIPE_STATUS = l_start_status
WHERE RECIPE_ID = l_recipe_id;