DBA Data[Home] [Help]

APPS.HZ_PERSON_BO_PUB SQL Statements

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

Line: 33

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

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

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

    px_citizenship_rec.birth_or_selected := p_citizenship_obj.birth_or_selected;
Line: 747

        SELECT HZ_BUS_OBJ_TRACKING_S.nextval
        INTO l_event_id
        FROM DUAL;
Line: 765

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

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

        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_person_id,
        p_parent_os          => x_person_os,
        p_parent_osr         => x_person_osr,
        p_parent_obj_type    => 'PERSON'
      );
Line: 969

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

        p_create_or_update => 'C',
        p_obj_source       => p_obj_source,
        p_event_id         => l_event_id
      );
Line: 1235

  PROCEDURE do_update_person_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_person_obj          IN OUT NOCOPY HZ_PERSON_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_person_id           OUT NOCOPY    NUMBER,
    x_person_os           OUT NOCOPY    VARCHAR2,
    x_person_osr          OUT NOCOPY    VARCHAR2
  )IS
    l_debug_prefix             VARCHAR2(30);
Line: 1249

    l_create_update_flag       VARCHAR2(1);
Line: 1265

    SELECT p.object_version_number, p.party_number
    FROM HZ_PARTIES p
    WHERE p.party_id = l_party_id
    AND p.party_type = 'PERSON'
    AND p.status in ('A','I');
Line: 1273

    SAVEPOINT do_update_person_bo_pub;
Line: 1293

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

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

    IF(HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO IS NOT NULL) THEN
      l_per_raise_event := FALSE;
Line: 1328

      l_per_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
                             p_party_id          => x_person_id,
                             p_bo_code           => 'PERSON'
                           );
Line: 1333

      l_pc_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
                            p_party_id          => x_person_id,
                            p_bo_code           => 'PERSON_CUST'
                          );
Line: 1340

        SELECT HZ_BUS_OBJ_TRACKING_S.nextval
        INTO l_per_event_id
        FROM DUAL;
Line: 1347

        SELECT HZ_BUS_OBJ_TRACKING_S.nextval
        INTO l_pc_event_id
        FROM DUAL;
Line: 1366

      p_create_or_update => 'U',
      px_person_rec      => l_person_rec
    );
Line: 1370

    HZ_PARTY_V2PUB.update_person(
      p_person_rec                => l_person_rec,
      p_party_object_version_number  => l_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: 1395

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

        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_person_id,
        p_parent_os          => x_person_os,
        p_parent_osr         => x_person_osr,
        p_parent_obj_type    => 'PERSON'
      );
Line: 1553

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

        p_create_or_update => 'U',
        p_obj_source       => p_obj_source,
        p_event_id         => l_per_event_id
      );
Line: 1636

        p_create_or_update => 'U',
        p_obj_source       => p_obj_source,
        p_event_id         => l_pc_event_id
      );
Line: 1654

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

      ROLLBACK TO do_update_person_bo_pub;
Line: 1684

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

      ROLLBACK TO do_update_person_bo_pub;
Line: 1715

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

      ROLLBACK TO do_update_person_bo_pub;
Line: 1748

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

  END do_update_person_bo;
Line: 1754

  PROCEDURE update_person_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_person_obj          IN            HZ_PERSON_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_person_id           OUT NOCOPY    NUMBER,
    x_person_os           OUT NOCOPY    VARCHAR2,
    x_person_osr          OUT NOCOPY    VARCHAR2
  ) IS
    l_per_obj             HZ_PERSON_BO;
Line: 1768

    do_update_person_bo(
      p_init_msg_list      => p_init_msg_list,
      p_person_obj         => l_per_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_person_id          => x_person_id,
      x_person_os          => x_person_os,
      x_person_osr         => x_person_osr
    );
Line: 1780

  END update_person_bo;
Line: 1782

  PROCEDURE update_person_bo(
    p_person_obj          IN            HZ_PERSON_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_PERSON_BO,
    x_person_id           OUT NOCOPY    NUMBER,
    x_person_os           OUT NOCOPY    VARCHAR2,
    x_person_osr          OUT NOCOPY    VARCHAR2
  )IS
    l_msg_count       NUMBER;
Line: 1799

    do_update_person_bo(
      p_init_msg_list      => FND_API.G_TRUE,
      p_person_obj         => l_per_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_person_id          => x_person_id,
      x_person_os          => x_person_os,
      x_person_osr         => x_person_osr
    );
Line: 1818

  END update_person_bo;
Line: 1840

    l_create_update_flag       VARCHAR2(1);
Line: 1864

    l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
                              p_entity_id      => x_person_id,
                              p_entity_os      => x_person_os,
                              p_entity_osr     => x_person_osr,
                              p_entity_type    => 'HZ_PARTIES',
                              p_parent_id      => NULL,
                              p_parent_obj_type=> NULL);
Line: 1872

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

    IF(l_create_update_flag = 'C') THEN
      do_create_person_bo(
        p_init_msg_list      => fnd_api.g_false,
        p_validate_bo_flag   => p_validate_bo_flag,
        p_person_obj         => p_person_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_person_id          => x_person_id,
        x_person_os          => x_person_os,
        x_person_osr         => x_person_osr
      );
Line: 1895

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_person_bo(
        p_init_msg_list      => fnd_api.g_false,
        p_person_obj         => p_person_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_person_id          => x_person_id,
        x_person_os          => x_person_os,
        x_person_osr         => x_person_osr
      );
Line: 2536

        HZ_PERSON_INFO_V2PUB.update_person_language(
          p_person_language_rec       => l_person_lang_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: 2609

        HZ_PERSON_INFO_V2PUB.update_education(
          p_education_rec             => l_education_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: 2680

        HZ_PERSON_INFO_V2PUB.update_citizenship(
          p_citizenship_rec           => l_citizenship_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: 2753

        HZ_PERSON_INFO_V2PUB.update_employment_history(
          p_employment_history_rec    => l_employ_hist_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: 2822

            HZ_PERSON_INFO_V2PUB.update_work_class(
              p_work_class_rec            => l_work_class_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: 2898

        HZ_PERSON_INFO_V2PUB.update_person_interest(
          p_person_interest_rec       => l_interest_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: 3106

    	-- extraction validation logic is same as update

    	l_person_id := p_person_id;
Line: 3490

The Get Persons Updated procedure is a service to retrieve all of the Person business objects whose updates have been
captured by the logical business event. Each Persons Updated business event signifies that one or more Person business
objects have been updated.
The caller provides an identifier for the Persons Update business event and the procedure returns database objects of the
type HZ_PERSON_BO for all of the Person business objects from the business event.
Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure and
returns them to the caller.
*/

 PROCEDURE get_persons_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    x_person_objs         OUT NOCOPY    HZ_PERSON_BO_TBL,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_msg_count           OUT NOCOPY    NUMBER,
    x_msg_data            OUT NOCOPY    VARCHAR2
  ) is

l_debug_prefix              VARCHAR2(30) := '';
Line: 3522

        	hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3537

	HZ_EXTRACT_PERSON_BO_PVT.get_persons_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
    		x_person_objs  => x_person_objs,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 3561

        	hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3584

        hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3603

        hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3626

        hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_persons_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3633

  PROCEDURE get_persons_updated(
    p_event_id            IN            NUMBER,
    x_person_objs         OUT NOCOPY    HZ_PERSON_BO_TBL,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_count       NUMBER;
Line: 3642

    get_persons_updated(
      p_init_msg_list      => FND_API.G_TRUE,
      p_event_id           => p_event_id,
      x_person_objs        => x_person_objs,
      x_return_status      => x_return_status,
      x_msg_count          => l_msg_count,
      x_msg_data           => l_msg_data
    );
Line: 3654

  END get_persons_updated;
Line: 3693

PROCEDURE get_person_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    p_person_id           IN           NUMBER,
    x_person_obj          OUT NOCOPY    HZ_PERSON_BO,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_msg_count           OUT NOCOPY    NUMBER,
    x_msg_data            OUT NOCOPY    VARCHAR2
  ) is
l_debug_prefix              VARCHAR2(30) := '';
Line: 3716

        	hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3732

	HZ_EXTRACT_PERSON_BO_PVT.get_person_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
		p_person_id  => p_person_id,
    		x_person_obj  => x_person_obj,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 3757

        	hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3780

        hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3799

        hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3822

        hz_utility_v2pub.debug(p_message=>'hz_person_bo_pub.get_person_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3829

  PROCEDURE get_person_updated(
    p_event_id            IN            NUMBER,
    p_person_id           IN           NUMBER,
    x_person_obj          OUT NOCOPY    HZ_PERSON_BO,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_count           NUMBER;
Line: 3839

    get_person_updated(
      p_init_msg_list      => FND_API.G_TRUE,
      p_event_id           => p_event_id,
      p_person_id          => p_person_id,
      x_person_obj         => x_person_obj,
      x_return_status      => x_return_status,
      x_msg_count          => l_msg_count,
      x_msg_data           => l_msg_data
    );
Line: 3852

  END get_person_updated;
Line: 3991

PROCEDURE get_ids_persons_updated (
	p_init_msg_list		IN	VARCHAR2 := fnd_api.g_false,
	p_event_id		IN	NUMBER,
	x_person_ids		OUT NOCOPY	HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL,
	x_return_status       OUT NOCOPY    VARCHAR2,
	x_msg_count		OUT NOCOPY	NUMBER,
	x_msg_data		OUT NOCOPY	VARCHAR2
) is
l_debug_prefix              VARCHAR2(30) := '';
Line: 4013

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

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

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

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

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