APPS.GMDRTGAP_WF_PKG SQL Statements

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

Line: 9

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

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

Line: 16

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

Line: 87

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

Line: 97

      SELECT ROUTING_DESC, OWNER_ID, ROUTING_CLASS, ROUTING_QTY, ROUTING_UOM, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
      INTO   l_routing_desc, l_owner_id, l_routing_class, l_routing_qty, l_item_um, l_effective_start_date, l_effective_end_date
      FROM GMD_ROUTINGS
      WHERE ROUTING_ID  = P_ROUTING_ID;

Line: 102

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

Line: 213

          UPDATE GMD_ROUTINGS_B
          SET ROUTING_STATUS  = l_target_status
          WHERE ROUTING_ID    = l_Routing_id;

Line: 264

          UPDATE GMD_ROUTINGS_B
          SET ROUTING_STATUS  = l_target_status
          WHERE ROUTING_ID    = l_Routing_id;

Line: 285

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

          UPDATE GMD_ROUTINGS_B
          SET ROUTING_STATUS  = l_rework_status
          WHERE ROUTING_ID    = l_Routing_id;

Line: 307

          UPDATE GMD_ROUTINGS_B
          SET ROUTING_STATUS  = l_start_status
          WHERE ROUTING_ID    = l_Routing_id;