APPS.WSH_DELIVERY_DETAILS_PUB SQL Statements

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

Line: 630

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_msg_summary varchar2(2000)  := NULL;

Line: 652

l_api_name            VARCHAR2(30) := 'Update_Shipping_Attributes';

Line: 671

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

Line: 682

        SAVEPOINT UPDATE_SHIPPING_ATTR_PUB;

Line: 724

       l_in_rec.action_code := 'UPDATE';

Line: 730

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

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

                ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line: 792

                ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line: 809

              ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line: 828

                 ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line: 831

               WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
          ;

Line: 846

END Update_Shipping_Attributes;

Line: 870

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_msg_summary varchar2(2000)  := NULL;

Line: 893

l_api_name            VARCHAR2(30) := 'Update_Shipping_Attributes2';

Line: 914

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

Line: 925

        SAVEPOINT UPDATE_SHIPPING_ATTR_PUB2;

Line: 980

       l_in_rec.action_code := 'UPDATE';

Line: 986

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

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

                ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line: 1050

                ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line: 1067

              ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line: 1086

                 ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line: 1089

               WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
          ;

Line: 1103

END Update_Shipping_Attributes;

Line: 1113

SELECT delivery_id, parent_delivery_detail_id
FROM wsh_delivery_assignments_v
WHERE delivery_detail_id = p_delivery_detail_id;

Line: 1119

SELECT status_code
FROM wsh_new_deliveries
WHERE delivery_id = c_del_id;

Line: 1909

     wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');