APPS.WSH_CONTAINER_GRP SQL Statements

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

Line: 293

      WSH_WMS_LPN_GRP.create_update_containers
        ( p_api_version            => p_api_version,
          p_init_msg_list          => p_init_msg_list,
          p_commit                 => p_commit,
          x_return_status          => l_return_status,
          x_msg_count              => l_msg_count,
          x_msg_data               => l_msg_data,
          p_detail_info_tab        => l_detail_info_tab,
          p_IN_rec                 => l_IN_rec,
          x_OUT_rec                => l_OUT_rec
        );

Line: 449

PROCEDURE Update_Container (
  -- Standard parameters
  p_api_version   IN  NUMBER,
  p_init_msg_list   IN  VARCHAR2  DEFAULT FND_API.G_FALSE,
  p_commit    IN  VARCHAR2  DEFAULT FND_API.G_FALSE,
  p_validation_level  IN  NUMBER    DEFAULT FND_API.G_VALID_LEVEL_FULL,
  x_return_status     OUT NOCOPY  VARCHAR2,
  x_msg_count     OUT NOCOPY  NUMBER,
  x_msg_data    OUT NOCOPY  VARCHAR2,

  -- program specific parameters
  p_container_rec   IN  WSH_CONTAINER_GRP.CHANGEDATTRIBUTETABTYPE

) IS

 -- Standard call to check for call compatibility
 l_api_version    CONSTANT  NUMBER  := 1.0;

Line: 466

 l_api_name   CONSTANT  VARCHAR2(30):= 'Update_Containers';

Line: 495

 WSH_INVALID_CONT_UPDATE    EXCEPTION;

Line: 496

 WSH_FAIL_CONT_UPDATE     EXCEPTION;

Line: 500

 SELECT container_flag, delivery_detail_id, lpn_id, released_status
 FROM WSH_DELIVERY_DETAILS
 WHERE delivery_detail_id = v_cont_id
 AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');

Line: 506

 SELECT delivery_detail_id, container_name
 FROM WSH_DELIVERY_DETAILS
 WHERE container_name = v_cont_name
 AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');

Line: 512

 SELECT lpn_id
 FROM wsh_delivery_details
 WHERE delivery_detail_id = l_delivery_detail_id;

Line: 520

  l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_CONTAINER';

Line: 545

  SAVEPOINT Update_Containers_SP_Grp;

Line: 576

    RAISE WSH_INVALID_CONT_UPDATE;

Line: 627

                        RAISE WSH_INVALID_CONT_UPDATE;

Line: 642

                        RAISE WSH_FAIL_CONT_UPDATE;

Line: 649

                        RAISE WSH_FAIL_CONT_UPDATE;

Line: 664

    l_IN_rec.action_code := 'UPDATE';

Line: 801

          l_IN_rec.action_code := 'UPDATE_NULL';

Line: 826

    l_detail_info_tab(1).last_update_date  := FND_API.G_MISS_DATE;

Line: 827

    l_detail_info_tab(1).last_update_login  := FND_API.G_MISS_NUM;

Line: 828

    l_detail_info_tab(1).last_updated_by  := FND_API.G_MISS_NUM;

Line: 831

    l_detail_info_tab(1).program_update_date  := FND_API.G_MISS_DATE;

Line: 874

    WSH_WMS_LPN_GRP.create_update_containers
      ( p_api_version            => p_api_version,
        p_init_msg_list          => p_init_msg_list,
        p_commit                 => p_commit,
        x_return_status          => l_return_status,
        x_msg_count              => l_msg_count,
        x_msg_data               => l_msg_data,
        p_detail_info_tab        => l_detail_info_tab,
        p_IN_rec                 => l_IN_rec,
        x_OUT_rec                => l_OUT_rec
      );

Line: 888

      RAISE WSH_FAIL_CONT_UPDATE;

Line: 917

  WHEN WSH_INVALID_CONT_UPDATE then
    x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line: 919

    rollback to Update_Containers_SP_Grp;

Line: 920

    fnd_message.set_name('WSH', 'WSH_CONT_INVALID_UPDATE');

Line: 940

    WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line: 941

    WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT_UPDATE');

Line: 946

    rollback to Update_Containers_SP_Grp;

Line: 970

  WHEN WSH_FAIL_CONT_UPDATE then
    x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line: 972

    rollback to Update_Containers_SP_Grp;

Line: 973

    fnd_message.set_name('WSH', 'WSH_CONT_UPDATE_ERROR');

Line: 993

    WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line: 994

    WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_UPDATE');

Line: 998

    wsh_util_core.default_handler('WSH_CONTAINER_GRP.Update_Container');

Line: 1000

    rollback to Update_Containers_SP_Grp;

Line: 1026

END Update_Container;

Line: 1085

 l_api_name   CONSTANT  VARCHAR2(30):= 'Update_Containers';

Line: 1123

 SELECT delivery_detail_id
      , container_flag
   FROM wsh_delivery_details
  WHERE delivery_detail_id = v_detail_id
    AND NVL(line_direction,'O') IN ('O','IO');   -- J-IB-NPARIKH;

Line: 1131

 SELECT delivery_id
      , name
      , status_code
   FROM wsh_new_deliveries
  WHERE delivery_id = v_del_id
    AND NVL(shipment_direction,'O') IN ('O','IO');   -- J-IB-NPARIKH;

Line: 1141

 SELECT wdd.delivery_detail_id
      , wdd.container_flag
      , wdacnt.delivery_id
   FROM wsh_delivery_details wdd
      , wsh_delivery_assignments wda
      , wsh_delivery_assignments wdacnt
  WHERE wda.delivery_id IS NULL
    AND wda.delivery_detail_id = v_delivery_detail_id
    AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
    AND wdacnt.parent_delivery_detail_id =  wda.parent_delivery_detail_id
    AND wdacnt.delivery_id IS NOT NULL
UNION
 SELECT wdd.delivery_detail_id
      , wdd.container_flag
      , wda.delivery_id
  FROM  wsh_delivery_details wdd
      , wsh_delivery_assignments wda
      , wsh_delivery_assignments wdacnt
  WHERE wda.delivery_detail_id = v_delivery_detail_id
    AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
    AND wda.delivery_id IS NOT NULL
    AND wdacnt.delivery_id IS NULL
    AND wdacnt.delivery_detail_id =  wdd.delivery_detail_id
    AND wdacnt.parent_delivery_detail_id IS NULL;

Line: 2028

 l_api_name   CONSTANT  VARCHAR2(30):= 'Update_Containers';

Line: 2077

 SELECT delivery_detail_id, container_flag
 FROM WSH_DELIVERY_DETAILS
 WHERE container_name = v_cont_name
 --LPN reuse project
 AND released_status = 'X'
 AND container_flag = 'Y';

Line: 2085

 SELECT wdd.delivery_detail_id, wdd.container_flag,wdd.released_status,
        wdd.organization_id ,wda.delivery_id
 FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda
 WHERE wdd.delivery_detail_id = v_detail_id
       AND wdd.delivery_detail_id = wda.delivery_detail_id
       AND nvl(wdd.line_direction,'O') in ('O','IO');   -- J-IB-NPARIKH

Line: 2093

 SELECT delivery_id, name, status_code
 FROM WSH_NEW_DELIVERIES
 WHERE delivery_id = v_del_id;

Line: 2098

 SELECT delivery_id, name, status_code
 FROM WSH_NEW_DELIVERIES
 WHERE  name = v_del_name;

Line: 2103

   SELECT status_code
   FROM wsh_new_deliveries
   WHERE delivery_id = l_delivery_id;