APPS.GMDRPGAP_WF_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

      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 :=  'GMDRPGAP';

Line: 16

      l_itemkey                 WF_ITEMS.ITEM_KEY%TYPE  :=  to_char(p_recipe_id)||'-'||to_char(p_last_update_date,'dd-MON-yyyy   HH24:mi:ss');

Line: 90

      SELECT USER_NAME , DESCRIPTION
      INTO   l_performer_name ,l_performer_display_name
      FROM   FND_USER
      WHERE  USER_ID = p_Requester;

Line: 100

      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;

Line: 112

      SELECT USER_NAME , DESCRIPTION
      INTO   l_performer_name ,l_performer_display_name
      FROM   FND_USER
      WHERE  USER_ID = l_owner_id;

Line: 225

           UPDATE GMD_RECIPES_B
           SET RECIPE_STATUS  = l_target_status
           WHERE RECIPE_ID    = l_recipe_id;

Line: 286

     	SELECT r.owner_organization_id, r.formula_id, r.recipe_no, r.recipe_version
     	FROM   gmd_recipes_b r, fm_form_mst_b f
     	WHERE  r.recipe_id = l_recipe_id
	AND    r.formula_id = f.formula_id;

Line: 293

	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;

Line: 303

          UPDATE GMD_RECIPES_B
          SET RECIPE_STATUS  = l_target_status
          WHERE RECIPE_ID    = l_recipe_id;

Line: 350

          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;

Line: 355

          UPDATE GMD_RECIPES_B
          SET RECIPE_STATUS  = l_rework_status
          WHERE RECIPE_ID    = l_recipe_id;

Line: 373

          UPDATE GMD_RECIPES_B
          SET RECIPE_STATUS  = l_start_status
          WHERE RECIPE_ID    = l_recipe_id;