APPS.WSH_DELIVERIES_PUB SQL Statements

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

Line: 624

    x_pvt_rec.LAST_UPDATE_DATE      := p_pub_rec.LAST_UPDATE_DATE;

Line: 625

    x_pvt_rec.LAST_UPDATED_BY     := p_pub_rec.LAST_UPDATED_BY;

Line: 626

    x_pvt_rec.LAST_UPDATE_LOGIN     := p_pub_rec.LAST_UPDATE_LOGIN;

Line: 629

    x_pvt_rec.PROGRAM_UPDATE_DATE   := p_pub_rec.PROGRAM_UPDATE_DATE;

Line: 711

  PROCEDURE Create_Update_Delivery(
    p_api_version_number     IN   NUMBER,
    p_init_msg_list          IN   VARCHAR2,
    x_return_status          OUT NOCOPY   VARCHAR2,
    x_msg_count              OUT NOCOPY   NUMBER,
    x_msg_data               OUT NOCOPY   VARCHAR2,
    p_action_code            IN   VARCHAR2,
    p_delivery_info           IN OUT NOCOPY  Delivery_Pub_Rec_Type,
    p_delivery_name          IN   VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
    x_delivery_id            OUT NOCOPY   NUMBER,
    x_name                   OUT NOCOPY   VARCHAR2)

  IS

  l_api_version_number CONSTANT NUMBER := 1.0;

Line: 726

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

Line: 742

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

Line: 774

    IF (p_action_code = 'UPDATE') THEN
      IF (p_delivery_name IS NOT NULL) OR (p_delivery_name <> FND_API.G_MISS_CHAR) THEN
        p_delivery_info.name := p_delivery_name;

Line: 799

    IF (p_action_code = 'UPDATE') THEN
      --
      wsh_util_validate.validate_delivery_name(
        p_delivery_id   => l_rec_attr_tab(1).delivery_id,
        p_delivery_name => l_rec_attr_tab(1).name,
        x_return_status => l_return_status);

Line: 891

    wsh_interface_grp.create_update_delivery(
      p_api_version_number =>  p_api_version_number,
      p_init_msg_list      =>  p_init_msg_list,
      p_commit             =>  l_commit,
      p_in_rec             =>  l_delivery_in_rec,
      p_rec_attr_tab       =>  l_rec_attr_tab,
      x_del_out_rec_tab    =>  l_del_out_rec_tab,
      x_return_status      =>  l_return_status,
      x_msg_count          =>  x_msg_count,
      x_msg_data           =>  x_msg_data);

Line: 903

      wsh_debug_sv.log(l_module_name,'Return Status After Calling create_update_delivery',l_return_status);

Line: 983

  END Create_Update_Delivery;