APPS.GMDOPGAP_WF_PKG SQL Statements

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

Line: 9

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

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

Line: 16

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

Line: 84

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

Line: 94

      SELECT OPRN_DESC, OPRN_CLASS, PROCESS_QTY_UOM, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
      INTO l_oprn_desc, l_oprn_class, l_item_um, l_effective_start_date, l_effective_end_date
      FROM GMD_OPERATIONS
      WHERE OPRN_ID = P_OPERATION_ID;

Line: 198

          UPDATE GMD_OPERATIONS_B
          SET OPERATION_STATUS  = l_target_status
          WHERE OPRN_ID    = l_operation_id;

Line: 247

          UPDATE GMD_OPERATIONS_B
          SET OPERATION_STATUS  = l_target_status
          WHERE OPRN_ID    = l_operation_id;

Line: 268

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

          UPDATE GMD_OPERATIONS_B
          SET OPERATION_STATUS  = l_rework_status
          WHERE OPRN_ID    = l_operation_id;

Line: 290

          UPDATE GMD_OPERATIONS_B
          SET OPERATION_STATUS  = l_start_status
          WHERE OPRN_ID    = l_operation_id;