DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_BO_PUB SQL Statements

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

Line: 37

    p_create_or_update           IN            VARCHAR2 := 'C',
    px_party_site_rec            IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
  );
Line: 74

    p_create_or_update           IN            VARCHAR2 := 'C',
    px_party_site_rec            IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
  ) IS
  BEGIN
    px_party_site_rec.party_site_id := p_ps_id;
Line: 113

    IF(p_create_or_update = 'C') THEN
      px_party_site_rec.orig_system := p_ps_os;
Line: 223

      p_create_or_update => 'C',
      x_return_status    => x_return_status,
      x_msg_count        => x_msg_count,
      x_msg_data         => x_msg_data);
Line: 275

        p_create_or_update          => 'C',
        x_return_status             => x_return_status,
        x_errorcode                 => l_errorcode,
        x_msg_count                 => x_msg_count,
        x_msg_data                  => x_msg_data
      );
Line: 324

        p_create_or_update          => 'C',
        x_return_status             => x_return_status,
        x_errorcode                 => l_errorcode,
        x_msg_count                 => x_msg_count,
        x_msg_data                  => x_msg_data
      );
Line: 375

        p_create_update_flag => 'C',
        p_obj_source         => p_obj_source,
        x_return_status      => x_return_status,
        x_msg_count          => x_msg_count,
        x_msg_data           => x_msg_data
      );
Line: 638

  PROCEDURE update_party_site_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_party_site_obj      IN            HZ_PARTY_SITE_BO,
    p_created_by_module   IN            VARCHAR2,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_msg_count           OUT NOCOPY    NUMBER,
    x_msg_data            OUT NOCOPY    VARCHAR2,
    x_party_site_id       OUT NOCOPY    NUMBER,
    x_party_site_os       OUT NOCOPY    VARCHAR2,
    x_party_site_osr      OUT NOCOPY    VARCHAR2
  )IS
    l_ps_obj              HZ_PARTY_SITE_BO;
Line: 652

    do_update_party_site_bo(
      p_init_msg_list       => p_init_msg_list,
      p_party_site_obj      => l_ps_obj,
      p_created_by_module   => p_created_by_module,
      p_obj_source          => null,
      x_return_status       => x_return_status,
      x_msg_count           => x_msg_count,
      x_msg_data            => x_msg_data,
      x_party_site_id       => x_party_site_id,
      x_party_site_os       => x_party_site_os,
      x_party_site_osr      => x_party_site_osr,
      p_parent_os           => NULL );
Line: 664

  END update_party_site_bo;
Line: 666

  PROCEDURE update_party_site_bo(
    p_party_site_obj      IN            HZ_PARTY_SITE_BO,
    p_created_by_module   IN            VARCHAR2,
    p_obj_source          IN            VARCHAR2 := null,
    p_return_obj_flag         IN            VARCHAR2 := fnd_api.g_true,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL,
    x_return_obj          OUT NOCOPY    HZ_PARTY_SITE_BO,
    x_party_site_id       OUT NOCOPY    NUMBER,
    x_party_site_os       OUT NOCOPY    VARCHAR2,
    x_party_site_osr      OUT NOCOPY    VARCHAR2
  )IS
    l_msg_count           NUMBER;
Line: 683

    do_update_party_site_bo(
      p_init_msg_list       => fnd_api.g_true,
      p_party_site_obj      => l_ps_obj,
      p_created_by_module   => p_created_by_module,
      p_obj_source          => p_obj_source,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data,
      x_party_site_id       => x_party_site_id,
      x_party_site_os       => x_party_site_os,
      x_party_site_osr      => x_party_site_osr,
      p_parent_os           => NULL
    );
Line: 703

  END update_party_site_bo;
Line: 709

  PROCEDURE do_update_party_site_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_party_site_obj      IN OUT NOCOPY HZ_PARTY_SITE_BO,
    p_created_by_module   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,
    x_party_site_id       OUT NOCOPY    NUMBER,
    x_party_site_os       OUT NOCOPY    VARCHAR2,
    x_party_site_osr      OUT NOCOPY    VARCHAR2,
    p_parent_os           IN            VARCHAR2
  )IS
    l_debug_prefix             VARCHAR2(30);
Line: 731

    l_create_update_flag       VARCHAR2(1);
Line: 739

    SELECT ps.object_version_number, loc.object_version_number, ps.party_id, loc.location_id
    FROM HZ_PARTY_SITES ps, HZ_LOCATIONS loc
    WHERE ps.party_site_id = l_ps_id
    AND ps.location_id = loc.location_id
    AND ps.status in ('A','I');
Line: 747

    SAVEPOINT do_update_party_site_bo_pub;
Line: 767

        hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 783

      p_create_or_update => 'U',
      x_return_status    => x_return_status,
      x_msg_count        => x_msg_count,
      x_msg_data         => x_msg_data);
Line: 806

      p_create_or_update => 'U',
      px_party_site_rec => l_party_site_rec
    );
Line: 810

    HZ_PARTY_SITE_V2PUB.update_party_site(
      p_party_site_rec            => l_party_site_rec,
      p_object_version_number     => l_ps_ovn,
      x_return_status             => x_return_status,
      x_msg_count                 => x_msg_count,
      x_msg_data                  => x_msg_data
    );
Line: 834

        p_create_or_update          => 'U',
        x_return_status             => x_return_status,
        x_errorcode                 => l_errorcode,
        x_msg_count                 => x_msg_count,
        x_msg_data                  => x_msg_data
      );
Line: 856

        p_create_or_update => 'U',
        px_location_rec => l_location_rec
      );
Line: 862

      HZ_LOCATION_V2PUB.update_location(
        p_location_rec              => l_location_rec,
        p_object_version_number     => l_loc_ovn,
        x_return_status             => x_return_status,
        x_msg_count                 => x_msg_count,
        x_msg_data                  => x_msg_data
      );
Line: 888

          p_create_or_update          => 'U',
          x_return_status             => x_return_status,
          x_errorcode                 => l_errorcode,
          x_msg_count                 => x_msg_count,
          x_msg_data                  => x_msg_data
        );
Line: 940

        p_create_update_flag => 'U',
        p_obj_source         => p_obj_source,
        x_return_status      => x_return_status,
        x_msg_count          => x_msg_count,
        x_msg_data           => x_msg_data
      );
Line: 985

        hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 992

      ROLLBACK TO do_update_party_site_bo_pub;
Line: 1016

        hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1022

      ROLLBACK TO do_update_party_site_bo_pub;
Line: 1046

        hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1052

      ROLLBACK TO do_update_party_site_bo_pub;
Line: 1080

        hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1084

  END do_update_party_site_bo;
Line: 1110

    l_create_update_flag       VARCHAR2(1);
Line: 1134

    l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
                              p_entity_id      => x_party_site_id,
                              p_entity_os      => x_party_site_os,
                              p_entity_osr     => x_party_site_osr,
                              p_entity_type    => 'HZ_PARTY_SITES',
                              p_parent_id      => px_parent_id,
                              p_parent_obj_type=> px_parent_obj_type);
Line: 1142

    IF(l_create_update_flag = 'E') THEN
      FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
Line: 1149

    IF(l_create_update_flag = 'C') THEN
      do_create_party_site_bo(
        p_init_msg_list      => fnd_api.g_false,
        p_validate_bo_flag   => p_validate_bo_flag,
        p_party_site_obj     => p_party_site_obj,
        p_created_by_module  => p_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      => x_party_site_id,
        x_party_site_os      => x_party_site_os,
        x_party_site_osr     => x_party_site_osr,
        px_parent_id         => px_parent_id,
        px_parent_os         => px_parent_os,
        px_parent_osr        => px_parent_osr,
        px_parent_obj_type   => px_parent_obj_type
      );
Line: 1167

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_party_site_bo(
        p_init_msg_list      => fnd_api.g_false,
        p_party_site_obj     => p_party_site_obj,
        p_created_by_module  => p_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      => x_party_site_id,
        x_party_site_os      => x_party_site_os,
        x_party_site_osr     => x_party_site_osr,
        p_parent_os          => px_parent_os );
Line: 1445

    	-- extraction validation logic is same as update

    	l_party_site_id := p_party_site_id;