APPS.HZ_ORG_CONTACT_BO_PUB SQL Statements

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

Line: 31

    p_create_or_update           IN            VARCHAR2 := 'C',
    px_person_rec                IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE
  );

Line: 67

    p_create_or_update           IN            VARCHAR2 := 'C',
    px_org_contact_rec           IN OUT NOCOPY HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE
  );

Line: 98

    p_create_or_update           IN            VARCHAR2 := 'C',
    px_person_rec                IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE
  ) IS
  BEGIN
    px_person_rec.person_pre_name_adjunct := p_person_obj.person_pre_name_adjunct;

Line: 143

    IF(p_create_or_update = 'C') THEN
      px_person_rec.party_rec.orig_system:= p_person_os;

Line: 214

    p_create_or_update           IN            VARCHAR2 := 'C',
    px_org_contact_rec           IN OUT NOCOPY HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE
  ) IS
  BEGIN
    px_org_contact_rec.org_contact_id        := p_oc_id;

Line: 259

    IF(p_create_or_update = 'C') THEN
      px_org_contact_rec.orig_system           := p_oc_os;

Line: 276

    IF(p_create_or_update = 'C') THEN
      px_org_contact_rec.party_rel_rec.created_by_module   := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

Line: 325

    SELECT per.party_id
    FROM HZ_PARTIES per, HZ_ORIG_SYS_REFERENCES ref
    WHERE ref.owner_table_id = per.party_id
    AND ref.owner_table_name = 'HZ_PARTIES'
    AND ref.orig_system = l_os
    AND ref.orig_system_reference = l_osr
    AND ref.status = 'A'
    AND rownum = 1;

Line: 335

    SELECT 'X'
    FROM HZ_PARTIES
    WHERE party_id = l_per_id
    AND party_type = 'PERSON'
    AND status in ('A','I');

Line: 407

      p_create_or_update => 'C',
      x_return_status    => x_return_status,
      x_msg_count        => x_msg_count,
      x_msg_data         => x_msg_data);

Line: 481

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

        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          => l_party_id,
        p_parent_os          => l_party_os,
        p_parent_osr         => l_party_osr,
        p_parent_obj_type    => 'ORG_CONTACT'
      );

Line: 589

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

  PROCEDURE update_org_contact_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_org_contact_obj     IN            HZ_ORG_CONTACT_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_org_contact_id      OUT NOCOPY    NUMBER,
    x_org_contact_os      OUT NOCOPY    VARCHAR2,
    x_org_contact_osr     OUT NOCOPY    VARCHAR2
  )IS
    l_oc_obj              HZ_ORG_CONTACT_BO;

Line: 835

    do_update_org_contact_bo(
      p_init_msg_list       => p_init_msg_list,
      p_org_contact_obj     => l_oc_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_org_contact_id      => x_org_contact_id,
      x_org_contact_os      => x_org_contact_os,
      x_org_contact_osr     => x_org_contact_osr,
      p_parent_os           => NULL
    );

Line: 848

  END update_org_contact_bo;

Line: 850

  PROCEDURE update_org_contact_bo(
    p_org_contact_obj     IN            HZ_ORG_CONTACT_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_ORG_CONTACT_BO,
    x_org_contact_id      OUT NOCOPY    NUMBER,
    x_org_contact_os      OUT NOCOPY    VARCHAR2,
    x_org_contact_osr     OUT NOCOPY    VARCHAR2
  )IS
    l_msg_data            VARCHAR2(2000);

Line: 867

    do_update_org_contact_bo(
      p_init_msg_list       => fnd_api.g_true,
      p_org_contact_obj     => l_oc_obj,
      p_created_by_module   => p_created_by_module,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data,
      x_org_contact_id      => x_org_contact_id,
      x_org_contact_os      => x_org_contact_os,
      x_org_contact_osr     => x_org_contact_osr,
      p_parent_os           => NULL
    );

Line: 886

  END update_org_contact_bo;

Line: 892

  PROCEDURE do_update_org_contact_bo(
    p_init_msg_list       IN         VARCHAR2 := fnd_api.g_false,
    p_org_contact_obj     IN OUT NOCOPY HZ_ORG_CONTACT_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_org_contact_id      OUT NOCOPY NUMBER,
    x_org_contact_os      OUT NOCOPY VARCHAR2,
    x_org_contact_osr     OUT NOCOPY VARCHAR2,
    p_parent_os           IN         VARCHAR2
  )IS
    l_debug_prefix             VARCHAR2(30);

Line: 911

    l_create_update_flag       VARCHAR2(1);

Line: 929

    SELECT oc.object_version_number, rel.object_version_number, p.object_version_number,
           p.party_id, rel.object_id, rel.subject_id
    FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS rel, HZ_PARTIES p
    WHERE oc.org_contact_id = l_oc_id
    AND oc.party_relationship_id = rel.relationship_id
    AND rel.party_id = p.party_id
    AND rel.subject_type = 'PERSON'
    AND rel.object_type = 'ORGANIZATION'
    AND rel.status in ('A','I')
    AND p.status in ('A','I');

Line: 941

    SELECT object_version_number
    FROM HZ_PARTIES
    WHERE party_id = l_per_id
    AND status in ('A','I');

Line: 948

    SAVEPOINT do_update_org_contact_bo_pub;

Line: 968

        hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 984

      p_create_or_update => 'U',
      x_return_status    => x_return_status,
      x_msg_count        => x_msg_count,
      x_msg_data         => x_msg_data);

Line: 1013

          p_create_or_update => 'U',
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data);

Line: 1028

          p_create_or_update   => 'U',
          px_person_rec        => l_person_rec
        );

Line: 1036

        HZ_PARTY_V2PUB.update_person(
          p_person_rec                => l_person_rec,
          p_party_object_version_number  => l_per_ovn,
          x_profile_id                => l_profile_id,
          x_return_status             => x_return_status,
          x_msg_count                 => x_msg_count,
          x_msg_data                  => x_msg_data
        );

Line: 1058

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

      p_create_or_update  => 'U',
      px_org_contact_rec  => l_org_contact_rec
    );

Line: 1087

    HZ_PARTY_CONTACT_V2PUB.update_org_contact(
      p_org_contact_rec             => l_org_contact_rec,
      p_cont_object_version_number  => l_oc_ovn,
      p_rel_object_version_number   => l_rel_ovn,
      p_party_object_version_number => l_pty_ovn,
      x_return_status               => x_return_status,
      x_msg_count                   => x_msg_count,
      x_msg_data                    => x_msg_data
    );

Line: 1130

        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          => l_oc_party_id,
        p_parent_os          => NULL,
        p_parent_osr         => NULL,
        p_parent_obj_type    => 'ORG_CONTACT'
      );

Line: 1171

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

        hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1222

      ROLLBACK TO do_update_org_contact_bo_pub;

Line: 1246

        hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1252

      ROLLBACK TO do_update_org_contact_bo_pub;

Line: 1276

        hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1282

      ROLLBACK TO do_update_org_contact_bo_pub;

Line: 1310

        hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 1314

  END do_update_org_contact_bo;

Line: 1339

    l_create_update_flag       VARCHAR2(1);

Line: 1363

    l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
                              p_entity_id      => x_org_contact_id,
                              p_entity_os      => x_org_contact_os,
                              p_entity_osr     => x_org_contact_osr,
                              p_entity_type    => 'HZ_ORG_CONTACTS',
                              p_parent_id      => px_parent_org_id,
                              p_parent_obj_type => 'ORG'
                            );

Line: 1372

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

Line: 1379

    IF(l_create_update_flag = 'C') THEN
      do_create_org_contact_bo(
        p_init_msg_list      => fnd_api.g_false,
        p_validate_bo_flag   => p_validate_bo_flag,
        p_org_contact_obj    => p_org_contact_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_org_contact_id     => x_org_contact_id,
        x_org_contact_os     => x_org_contact_os,
        x_org_contact_osr    => x_org_contact_osr,
        px_parent_org_id     => px_parent_org_id,
        px_parent_org_os     => px_parent_org_os,
        px_parent_org_osr    => px_parent_org_osr
      );

Line: 1396

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_org_contact_bo(
        p_init_msg_list      => fnd_api.g_false,
        p_org_contact_obj    => p_org_contact_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_org_contact_id     => x_org_contact_id,
        x_org_contact_os     => x_org_contact_os,
        x_org_contact_osr    => x_org_contact_osr,
        p_parent_os          => px_parent_org_os );

Line: 1641

    	-- extraction validation logic is same as update

    	l_org_contact_id := p_org_contact_id;