DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_BO_PUB SQL Statements

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

Line: 32

    p_create_or_update        IN            VARCHAR2 := 'C',
    px_cust_acct_rec          IN OUT NOCOPY HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE
  );
Line: 64

    p_create_or_update        IN            VARCHAR2 := 'C',
    px_cust_acct_rec          IN OUT NOCOPY HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE
  ) IS
  BEGIN
    px_cust_acct_rec.cust_account_id        := p_cust_acct_id;
Line: 134

    px_cust_acct_rec.status_update_date := p_cust_acct_obj.status_update_date;
Line: 143

    IF(p_create_or_update = 'C') THEN
      px_cust_acct_rec.orig_system            := p_cust_acct_os;
Line: 229

    SELECT cust_account_profile_id
    FROM HZ_CUSTOMER_PROFILES
    WHERE cust_account_id = p_cust_acct_id;
Line: 298

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

        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,
        p_parent_id          => x_cust_acct_id,
        p_parent_os          => x_cust_acct_os,
        p_parent_osr         => x_cust_acct_osr,
        p_parent_obj_type    => 'CUST_ACCT'
      );
Line: 453

        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,
        p_parent_acct_id     => x_cust_acct_id,
        p_parent_acct_os     => x_cust_acct_os,
        p_parent_acct_osr    => x_cust_acct_osr
      );
Line: 707

  PROCEDURE update_cust_acct_bo(
    p_init_msg_list           IN            VARCHAR2 := fnd_api.g_false,
    p_cust_acct_obj           IN            HZ_CUST_ACCT_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_cust_acct_id            OUT NOCOPY    NUMBER,
    x_cust_acct_os            OUT NOCOPY    VARCHAR2,
    x_cust_acct_osr           OUT NOCOPY    VARCHAR2
  )IS
    l_ca_obj                  HZ_CUST_ACCT_BO;
Line: 721

    do_update_cust_acct_bo(
      p_init_msg_list           => p_init_msg_list,
      p_cust_acct_obj           => l_ca_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_cust_acct_id            => x_cust_acct_id,
      x_cust_acct_os            => x_cust_acct_os,
      x_cust_acct_osr           => x_cust_acct_osr,
      p_parent_os               => NULL
    );
Line: 734

  END update_cust_acct_bo;
Line: 736

  PROCEDURE update_cust_acct_bo(
    p_cust_acct_obj           IN            HZ_CUST_ACCT_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_CUST_ACCT_BO,
    x_cust_acct_id            OUT NOCOPY    NUMBER,
    x_cust_acct_os            OUT NOCOPY    VARCHAR2,
    x_cust_acct_osr           OUT NOCOPY    VARCHAR2
  )IS
    l_msg_data                VARCHAR2(2000);
Line: 753

    do_update_cust_acct_bo(
      p_init_msg_list           => fnd_api.g_true,
      p_cust_acct_obj           => l_ca_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_cust_acct_id            => x_cust_acct_id,
      x_cust_acct_os            => x_cust_acct_os,
      x_cust_acct_osr           => x_cust_acct_osr,
      p_parent_os               => NULL
    );
Line: 773

  END update_cust_acct_bo;
Line: 779

  PROCEDURE do_update_cust_acct_bo(
    p_init_msg_list           IN            VARCHAR2 := fnd_api.g_false,
    p_validate_bo_flag        IN            VARCHAR2 := fnd_api.g_true,
    p_cust_acct_obj           IN OUT NOCOPY HZ_CUST_ACCT_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_cust_acct_id            OUT NOCOPY    NUMBER,
    x_cust_acct_os            OUT NOCOPY    VARCHAR2,
    x_cust_acct_osr           OUT NOCOPY    VARCHAR2,
    p_parent_os               IN            VARCHAR2
  )IS
    l_debug_prefix             VARCHAR2(30) := '';
Line: 795

    l_create_update_flag       VARCHAR2(1);
Line: 803

    SELECT a.object_version_number, a.party_id
    FROM HZ_CUST_ACCOUNTS a
    WHERE a.cust_account_id = l_ca_id;
Line: 808

    SAVEPOINT do_update_cust_acct_bo_pub;
Line: 828

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

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

      p_create_or_update       => 'U',
      px_cust_acct_rec         => l_cust_acct_rec
    );
Line: 869

    HZ_CUST_ACCOUNT_V2PUB.update_cust_account(
      p_cust_account_rec            => l_cust_acct_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: 887

      HZ_CUST_ACCT_BO_PVT.update_cust_profile(
        p_cp_obj                      => p_cust_acct_obj.cust_profile_obj,
        p_ca_id                       => x_cust_acct_id,
        p_casu_id                     => NULL,
        x_cp_id                       => l_cust_acct_profile_id,
        x_return_status               => x_return_status,
        x_msg_count                   => x_msg_count,
        x_msg_data                    => x_msg_data
      );
Line: 933

        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,
        p_parent_id           => x_cust_acct_id,
        p_parent_os           => x_cust_acct_os,
        p_parent_osr          => x_cust_acct_osr,
        p_parent_obj_type     => 'CUST_ACCT'
      );
Line: 978

        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,
        p_parent_acct_id     => x_cust_acct_id,
        p_parent_acct_os     => x_cust_acct_os,
        p_parent_acct_osr    => x_cust_acct_osr
      );
Line: 1045

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

      ROLLBACK TO do_update_cust_acct_bo_pub;
Line: 1075

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

      ROLLBACK TO do_update_cust_acct_bo_pub;
Line: 1105

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

      ROLLBACK TO do_update_cust_acct_bo_pub;
Line: 1139

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

  END do_update_cust_acct_bo;
Line: 1169

    l_create_update_flag       VARCHAR2(1);
Line: 1193

    l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
                              p_entity_id      => x_cust_acct_id,
                              p_entity_os      => x_cust_acct_os,
                              p_entity_osr     => x_cust_acct_osr,
                              p_entity_type    => 'HZ_CUST_ACCOUNTS',
                              p_parent_id      => px_parent_id,
                              p_parent_obj_type => px_parent_obj_type
                            );
Line: 1202

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

    IF(l_create_update_flag = 'C') THEN
      do_create_cust_acct_bo(
        p_validate_bo_flag    => p_validate_bo_flag,
        p_cust_acct_obj       => p_cust_acct_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_cust_acct_id        => x_cust_acct_id,
        x_cust_acct_os        => x_cust_acct_os,
        x_cust_acct_osr       => x_cust_acct_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: 1226

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_cust_acct_bo(
        p_cust_acct_obj       => p_cust_acct_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_cust_acct_id        => x_cust_acct_id,
        x_cust_acct_os        => x_cust_acct_os,
        x_cust_acct_osr       => x_cust_acct_osr,
        p_parent_os           => px_parent_os
      );
Line: 1500

    	-- extraction validation logic is same as update

    	l_cust_acct_id := p_cust_acct_id;
Line: 1673

    p_create_or_update        IN            VARCHAR2 := 'C',
    px_cust_acct_rec          IN OUT NOCOPY HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE
  );
Line: 1705

    p_create_or_update        IN            VARCHAR2 := 'C',
    px_cust_acct_rec          IN OUT NOCOPY HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE
  ) IS
  BEGIN
    px_cust_acct_rec.cust_account_id        := p_cust_acct_id;
Line: 1775

    px_cust_acct_rec.status_update_date := p_cust_acct_v2_obj.status_update_date;
Line: 1784

    IF(p_create_or_update = 'C') THEN
      px_cust_acct_rec.orig_system            := p_cust_acct_os;
Line: 1871

    SELECT cust_account_profile_id
    FROM HZ_CUSTOMER_PROFILES
    WHERE cust_account_id = p_cust_acct_id;
Line: 1940

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

        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,
        p_parent_id          => x_cust_acct_id,
        p_parent_os          => x_cust_acct_os,
        p_parent_osr         => x_cust_acct_osr,
        p_parent_obj_type    => 'CUST_ACCT'
      );
Line: 2095

        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,
        p_parent_acct_id     => x_cust_acct_id,
        p_parent_acct_os     => x_cust_acct_os,
        p_parent_acct_osr    => x_cust_acct_osr
      );
Line: 2312

 PROCEDURE update_cust_acct_v2_bo(
    p_cust_acct_v2_obj           IN            HZ_CUST_ACCT_V2_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_CUST_ACCT_V2_BO,
    x_cust_acct_id            OUT NOCOPY    NUMBER,
    x_cust_acct_os            OUT NOCOPY    VARCHAR2,
    x_cust_acct_osr           OUT NOCOPY    VARCHAR2
  )IS
    l_msg_data                VARCHAR2(2000);
Line: 2329

    do_update_cust_acct_v2_bo(
      p_init_msg_list           => fnd_api.g_true,
      p_cust_acct_v2_obj           => l_ca_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_cust_acct_id            => x_cust_acct_id,
      x_cust_acct_os            => x_cust_acct_os,
      x_cust_acct_osr           => x_cust_acct_osr,
      p_parent_os               => NULL
    );
Line: 2349

  END update_cust_acct_v2_bo;
Line: 2355

  PROCEDURE do_update_cust_acct_v2_bo(
    p_init_msg_list           IN            VARCHAR2 := fnd_api.g_false,
    p_validate_bo_flag        IN            VARCHAR2 := fnd_api.g_true,
    p_cust_acct_v2_obj           IN OUT NOCOPY HZ_CUST_ACCT_V2_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_cust_acct_id            OUT NOCOPY    NUMBER,
    x_cust_acct_os            OUT NOCOPY    VARCHAR2,
    x_cust_acct_osr           OUT NOCOPY    VARCHAR2,
    p_parent_os               IN            VARCHAR2
  )IS
    l_debug_prefix             VARCHAR2(30) := '';
Line: 2371

    l_create_update_flag       VARCHAR2(1);
Line: 2379

    SELECT a.object_version_number, a.party_id
    FROM HZ_CUST_ACCOUNTS a
    WHERE a.cust_account_id = l_ca_id;
Line: 2384

    SAVEPOINT do_update_cust_acct_v2_bo_pub;
Line: 2404

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

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

      p_create_or_update       => 'U',
      px_cust_acct_rec         => l_cust_acct_rec
    );
Line: 2445

    HZ_CUST_ACCOUNT_V2PUB.update_cust_account(
      p_cust_account_rec            => l_cust_acct_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: 2463

      HZ_CUST_ACCT_BO_PVT.update_cust_profile(
        p_cp_obj                      => p_cust_acct_v2_obj.cust_profile_obj,
        p_ca_id                       => x_cust_acct_id,
        p_casu_id                     => NULL,
        x_cp_id                       => l_cust_acct_profile_id,
        x_return_status               => x_return_status,
        x_msg_count                   => x_msg_count,
        x_msg_data                    => x_msg_data
      );
Line: 2509

        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,
        p_parent_id           => x_cust_acct_id,
        p_parent_os           => x_cust_acct_os,
        p_parent_osr          => x_cust_acct_osr,
        p_parent_obj_type     => 'CUST_ACCT'
      );
Line: 2554

        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,
        p_parent_acct_id     => x_cust_acct_id,
        p_parent_acct_os     => x_cust_acct_os,
        p_parent_acct_osr    => x_cust_acct_osr
      );
Line: 2622

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

      ROLLBACK TO do_update_cust_acct_v2_bo_pub;
Line: 2652

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

      ROLLBACK TO do_update_cust_acct_v2_bo_pub;
Line: 2682

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

      ROLLBACK TO do_update_cust_acct_v2_bo_pub;
Line: 2716

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

  END do_update_cust_acct_v2_bo;
Line: 2746

    l_create_update_flag       VARCHAR2(1);
Line: 2770

    l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
                              p_entity_id      => x_cust_acct_id,
                              p_entity_os      => x_cust_acct_os,
                              p_entity_osr     => x_cust_acct_osr,
                              p_entity_type    => 'HZ_CUST_ACCOUNTS',
                              p_parent_id      => px_parent_id,
                              p_parent_obj_type => px_parent_obj_type
                            );
Line: 2779

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

    IF(l_create_update_flag = 'C') THEN
      do_create_cust_acct_v2_bo(
        p_validate_bo_flag    => p_validate_bo_flag,
        p_cust_acct_v2_obj       => p_cust_acct_v2_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_cust_acct_id        => x_cust_acct_id,
        x_cust_acct_os        => x_cust_acct_os,
        x_cust_acct_osr       => x_cust_acct_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: 2803

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_cust_acct_v2_bo(
        p_cust_acct_v2_obj       => p_cust_acct_v2_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_cust_acct_id        => x_cust_acct_id,
        x_cust_acct_os        => x_cust_acct_os,
        x_cust_acct_osr       => x_cust_acct_osr,
        p_parent_os           => px_parent_os
      );
Line: 3040

    	-- extraction validation logic is same as update

    	l_cust_acct_id := p_cust_acct_id;