APPS.WSH_DELIVERY_DETAILS_PUB SQL Statements

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

Line: 314

select organization_id,inventory_item_id,source_line_id,
       lot_number,requested_quantity_uom,requested_quantity_uom2,
        requested_quantity,requested_quantity2,released_status
  from wsh_delivery_details
 where delivery_detail_id = P_FROM_DETAIL_ID;

Line: 688

PROCEDURE Update_Shipping_Attributes (
  -- Standard parameters
  p_api_version_number     IN     NUMBER
, p_init_msg_list          IN     VARCHAR2
, p_commit                 IN     VARCHAR2
, x_return_status             OUT NOCOPY  VARCHAR2
, x_msg_count                 OUT NOCOPY  NUMBER
, x_msg_data                  OUT NOCOPY  VARCHAR2

  -- Procedure specific parameters
, p_changed_attributes    IN     WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType
, p_source_code            IN     VARCHAR2
, p_container_flag         IN     VARCHAR2
)
IS

l_valid_index_tab      WSH_UTIL_CORE.Id_Tab_Type;

Line: 712

l_api_name            VARCHAR2(30) := 'Update_Shipping_Attributes';

Line: 731

 SELECT lookup_code
 FROM   wsh_lookups
 WHERE  lookup_code  = c_source_code
 AND    lookup_type  = 'SOURCE_SYSTEM'
 AND    lookup_code not in ('OKE','PO')
 AND    enabled_flag = 'Y';

Line: 743

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

Line: 754

        SAVEPOINT UPDATE_SHIPPING_ATTR_PUB;

Line: 803

       l_in_rec.action_code := 'UPDATE';

Line: 863

                 WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 865

       wsh_interface_grp.create_update_delivery_detail(
       p_api_version_number  => p_api_version_number,
       p_init_msg_list           => FND_API.G_FALSE,
       p_commit                  => FND_API.G_FALSE,
       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: 909

                ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line: 925

                ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line: 942

              ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line: 965

                 ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line: 968

               WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
          ;

Line: 983

END Update_Shipping_Attributes;

Line: 1007

PROCEDURE Update_Shipping_Attributes (
  -- Standard parameters
  p_api_version_number     IN     NUMBER
, p_init_msg_list          IN     VARCHAR2
, p_commit                 IN     VARCHAR2
, x_return_status             OUT NOCOPY  VARCHAR2
, x_msg_count                 OUT NOCOPY  NUMBER
, x_msg_data                  OUT NOCOPY  VARCHAR2

  -- Procedure specific parameters
, p_changed_attributes    IN     WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType
, p_source_code            IN     VARCHAR2
, p_container_flag         IN     VARCHAR2
, p_serial_range_tab       IN     WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
)
IS

l_valid_index_tab      WSH_UTIL_CORE.Id_Tab_Type;

Line: 1032

l_api_name            VARCHAR2(30) := 'Update_Shipping_Attributes2';

Line: 1053

 SELECT lookup_code
 FROM   wsh_lookups
 WHERE  lookup_code  = c_source_code
 AND    lookup_type  = 'SOURCE_SYSTEM'
 AND    lookup_code not in ('OKE','PO')
 AND    enabled_flag = 'Y';

Line: 1065

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

Line: 1076

        SAVEPOINT UPDATE_SHIPPING_ATTR_PUB2;

Line: 1139

       l_in_rec.action_code := 'UPDATE';

Line: 1199

                 WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 1202

       wsh_delivery_details_grp.create_update_delivery_detail(
       p_api_version_number  => p_api_version_number,
       p_init_msg_list           => FND_API.G_FALSE,
       p_commit                  => FND_API.G_FALSE,
       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,
       p_serial_range_tab        => l_serial_range_tab
       );

Line: 1247

                ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line: 1263

                ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line: 1280

              ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line: 1304

                 ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line: 1307

               WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
          ;

Line: 1321

END Update_Shipping_Attributes;

Line: 1331

SELECT delivery_id, parent_delivery_detail_id
FROM wsh_delivery_assignments_v
WHERE delivery_detail_id = p_delivery_detail_id;

Line: 1337

SELECT status_code
FROM wsh_new_deliveries
WHERE delivery_id = c_del_id;

Line: 2127

     wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');