APPS.HZ_PARTY_SITE_BO_PVT SQL Statements

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

Line: 337

        HZ_PARTY_SITE_V2PUB.update_party_site_use(
          p_party_site_use_rec        => l_psu_rec,
          p_object_version_number     => l_ovn,
          x_return_status             => x_return_status,
          x_msg_count                 => x_msg_count,
          x_msg_data                  => x_msg_data
        );

Line: 483

    p_create_update_flag         IN         VARCHAR2,
    p_obj_source                 IN         VARCHAR2 := null,
    x_return_status              OUT NOCOPY VARCHAR2,
    x_msg_count                  OUT NOCOPY NUMBER,
    x_msg_data                   OUT NOCOPY VARCHAR2,
    p_parent_id                  IN         NUMBER,
    p_parent_os                  IN         VARCHAR2,
    p_parent_osr                 IN         VARCHAR2,
    p_parent_obj_type            IN         VARCHAR2
  ) IS
    l_debug_prefix        VARCHAR2(30);

Line: 520

    IF(p_create_update_flag = 'C') THEN
      ----------------------------
      -- Create logical party site
      ----------------------------
      FOR i IN 1..p_ps_objs.COUNT LOOP
        HZ_PARTY_SITE_BO_PUB.do_create_party_site_bo(
          p_init_msg_list      => fnd_api.g_false,
          p_validate_bo_flag   => FND_API.G_FALSE,
          p_party_site_obj     => p_ps_objs(i),
          p_created_by_module  => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
          p_obj_source         => p_obj_source,
          x_return_status      => x_return_status,
          x_msg_count          => x_msg_count,
          x_msg_data           => x_msg_data,
          x_party_site_id      => l_party_site_id,
          x_party_site_os      => l_party_site_os,
          x_party_site_osr     => l_party_site_osr,
          px_parent_id         => l_parent_id,
          px_parent_os         => l_parent_os,
          px_parent_osr        => l_parent_osr,
          px_parent_obj_type   => l_parent_obj_type
        );