APPS.WMS_WCS_DEVICE_GRP SQL Statements

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

Line: 14

   * Call WMS_Task_Dispatch_Device. PROCEDURE insert_device
   * And make the x_return_status of the Open API "S"
   */
   PROCEDURE call_workflow
      (
             p_device_id        IN NUMBER,
             p_response_record  IN MSG_COMPONENT_LOOKUP_TYPE
       );

Line: 103

         (p_device_id,   'Device is not signed on. Calling WMS_Task_Dispatch_Device.insert_device.');

Line: 106

      WMS_Task_Dispatch_Device.insert_device
      (p_Employee_Id     =>  p_employee_id,
      p_device_id        =>  p_device_id,
      p_org_id           =>  p_organization_id,
      x_return_status    =>  x_return_status);

Line: 114

       (p_device_id,   'Done inserting into temp table. p_employee_id='
        || p_employee_id
        || ', p_device_id='
        || p_device_id
        || ', p_organization_id='
        || p_organization_id
        || ', x_return_status='
        || x_return_status);

Line: 447

         INSERT INTO wms_device_requests
                     (relation_id,
                      task_id,
                      task_summary,
                      business_event_id,
                      organization_id,
                      device_status,
                      xfer_lpn_id,
                      last_update_date,
                      last_updated_by,
                      last_update_login
                     )
              VALUES (p_param_values_record.relation_id,
                      p_param_values_record.task_id,
                      p_param_values_record.task_summary,
                      p_param_values_record.business_event,
                      p_param_values_record.organization_id,
                      p_param_values_record.device_status,
                      p_param_values_record.transfer_lpn_id,
                      SYSDATE,
                      fnd_global.user_id,
                      fnd_global.login_id );

Line: 506

     SELECT 1
       INTO l_wf
       FROM mtl_transaction_reasons
      WHERE reason_id = p_response_record.reason_id
        AND workflow_name IS NOT NULL
        AND workflow_name <> ' '
        AND workflow_process IS NOT NULL
        AND workflow_process <> ' ';

Line: 583

      INSERT INTO wms_carousel_log
                  (CAROUSEL_LOG_ID
                   ,text
                   ,device_id
                   ,LAST_UPDATE_DATE
                   ,LAST_UPDATED_BY
                   ,CREATION_DATE
                   ,CREATED_BY
                   ,LAST_UPDATE_LOGIN
                  )
           VALUES (wms_carousel_log_s.NEXTVAL
                   ,p_data
                   ,p_device_id
                   ,SYSDATE
                   ,fnd_global.user_id
                   ,SYSDATE
                   ,fnd_global.user_id
                   ,fnd_global.login_id
                  );