APPS.GMDRVLAP_WF_PKG SQL Statements

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

Line: 8

      p_requester                       IN   GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
      p_last_update_date                IN   GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
                )
   IS
      /* procedure to initialize and run Workflow */

      l_itemtype                WF_ITEMS.ITEM_TYPE%TYPE :=  'GMDRVLAP';

Line: 16

                                                            to_char(p_last_update_date,'dd-MON-yyyy   HH24:mi:ss');

Line: 70

            SELECT RECIPE_NO,RECIPE_VERSION INTO l_recipe_no,l_recipe_vers
            FROM GMD_RECIPES_B
            WHERE RECIPE_ID = P_RECIPE_ID;

Line: 98

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

Line: 109

         SELECT A.ORGANIZATION_ID,
                DECODE(A.RECIPE_USE, 0, 'Production', 1, 'Planning', 2, 'Costing', 3, 'Regulatory', 4, 'Technical'),
                B.CONCATENATED_SEGMENTS,  A.PREFERENCE, A.STD_QTY || ' ' || A.DETAIL_UOM, A.MIN_QTY || ' ' || A.DETAIL_UOM, A.MAX_QTY || ' ' || A.DETAIL_UOM, A.START_DATE, A.END_DATE
         INTO   l_orgn_id, l_recipe_use, l_item_no, l_preference, l_std_qty, l_min_qty, l_max_qty, l_effective_start_date, l_effective_end_date
         FROM GMD_RECIPE_VALIDITY_RULES A,  MTL_SYSTEM_ITEMS_KFV B
         WHERE A.RECIPE_VALIDITY_RULE_ID = P_RECIPE_VALIDITY_RULE_ID
         AND   A.INVENTORY_ITEM_ID       = B.INVENTORY_ITEM_ID
	 AND   A.organization_id         = B.organization_id;

Line: 239

          UPDATE GMD_RECIPE_VALIDITY_RULES
          SET VALIDITY_RULE_STATUS  = l_target_status
          WHERE RECIPE_VALIDITY_RULE_ID    = l_recipe_validity_rule_id;

Line: 291

          UPDATE GMD_RECIPE_VALIDITY_RULES
          SET VALIDITY_RULE_STATUS  = l_target_status
          WHERE RECIPE_VALIDITY_RULE_ID    = l_recipe_validity_rule_id;

Line: 312

          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: 317

          UPDATE GMD_RECIPE_VALIDITY_RULES
          SET VALIDITY_RULE_STATUS = l_rework_status
          WHERE RECIPE_VALIDITY_RULE_ID    = l_recipe_validity_rule_id;

Line: 335

          UPDATE GMD_RECIPE_VALIDITY_RULES
          SET VALIDITY_RULE_STATUS  = l_start_status
          WHERE RECIPE_VALIDITY_RULE_ID    = l_recipe_validity_rule_id;