DBA Data[Home] [Help]

APPS.HZ_PERSON_CUST_BO_PUB SQL Statements

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

Line: 15

  PROCEDURE do_update_person_cust_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_person_cust_obj     IN OUT NOCOPY HZ_PERSON_CUST_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
  );
Line: 103

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

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

        p_create_update_flag     => 'C',
        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              => l_person_os,
        p_parent_osr             => l_person_osr,
        p_parent_obj_type        => 'PERSON'
      );
Line: 173

        p_create_or_update => 'C',
        p_obj_source       => p_obj_source,
        p_event_id         => l_per_event_id
      );
Line: 182

        p_create_or_update => 'C',
        p_obj_source       => p_obj_source,
        p_event_id         => l_pc_event_id
      );
Line: 367

  PROCEDURE do_update_person_cust_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_person_cust_obj     IN OUT NOCOPY HZ_PERSON_CUST_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
  ) IS
    l_person_os           VARCHAR2(30);
Line: 387

    SAVEPOINT do_update_person_cust_pub;
Line: 399

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

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

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

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

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

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

    HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';
Line: 460

    HZ_PERSON_BO_PUB.do_update_person_bo(
      p_init_msg_list          => fnd_api.g_false,
      p_person_obj             => p_person_cust_obj.person_obj,
      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_person_id              => x_person_id,
      x_person_os              => l_person_os,
      x_person_osr             => l_person_osr
    );
Line: 483

        p_create_update_flag     => 'U',
        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              => l_person_os,
        p_parent_osr             => l_person_osr,
        p_parent_obj_type        => 'PERSON'
      );
Line: 506

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

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

    HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 536

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

      ROLLBACK TO do_update_person_cust_pub;
Line: 547

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 567

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

      ROLLBACK TO do_update_person_cust_pub;
Line: 578

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 598

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

      ROLLBACK TO do_update_person_cust_pub;
Line: 609

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 633

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

  END do_update_person_cust_bo;
Line: 639

  PROCEDURE update_person_cust_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_person_cust_obj     IN            HZ_PERSON_CUST_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
  ) IS
    l_pc_obj    HZ_PERSON_CUST_BO;
Line: 651

    do_update_person_cust_bo(
      p_init_msg_list       => p_init_msg_list,
      p_person_cust_obj     => l_pc_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
    );
Line: 661

  END update_person_cust_bo;
Line: 663

  PROCEDURE update_person_cust_bo(
    p_person_cust_obj     IN            HZ_PERSON_CUST_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_CUST_BO,
    x_person_id           OUT NOCOPY    NUMBER
  ) IS
    l_msg_data            VARCHAR2(2000);
Line: 678

    do_update_person_cust_bo(
      p_init_msg_list       => fnd_api.g_true,
      p_person_cust_obj     => l_pc_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
    );
Line: 695

  END update_person_cust_bo;
Line: 716

    l_create_update_flag       VARCHAR2(1);
Line: 739

    l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
                              p_entity_id      => l_person_id,
                              p_entity_os      => l_person_os,
                              p_entity_osr     => l_person_osr,
                              p_entity_type    => 'HZ_PARTIES',
                              p_parent_id      => NULL,
                              p_parent_obj_type=> NULL );
Line: 747

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

    IF(l_create_update_flag = 'C') THEN
      do_create_person_cust_bo(
        p_init_msg_list       => fnd_api.g_false,
        p_validate_bo_flag    => p_validate_bo_flag,
        p_person_cust_obj     => p_person_cust_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
      );
Line: 768

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_person_cust_bo(
        p_init_msg_list       => fnd_api.g_false,
        p_person_cust_obj     => p_person_cust_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
      );
Line: 1009

    	-- extraction validation logic is same as update

    	l_person_id := p_person_id;
Line: 1395

The Get Person Customers Updated procedure is a service to retrieve all of the Person Customer business objects whose updates
have been captured by the logical business event. Each Person Customers Updated business event signifies that one or more Person
Customer business objects have been updated.
The caller provides an identifier for the Person Customers Update business event and the procedure returns database objects of
the type HZ_PERSON_CUST_BO for all of the Person Customer 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_person_custs_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    x_person_cust_objs         OUT NOCOPY    HZ_PERSON_CUST_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: 1427

        	hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1442

	HZ_EXTRACT_PERSON_CUST_BO_PVT.get_person_custs_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
    		x_person_cust_objs  => x_person_cust_objs,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 1466

        	hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1489

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1508

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1531

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1538

  PROCEDURE get_person_custs_updated(
    p_event_id            IN            NUMBER,
    x_person_cust_objs         OUT NOCOPY    HZ_PERSON_CUST_BO_TBL,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  )IS
    l_msg_data            VARCHAR2(2000);
Line: 1547

    get_person_custs_updated(
      p_init_msg_list      => fnd_api.g_true,
      p_event_id           => p_event_id,
      x_person_cust_objs   => x_person_cust_objs,
      x_return_status      => x_return_status,
      x_msg_count          => l_msg_count,
      x_msg_data           => l_msg_data
    );
Line: 1559

  END get_person_custs_updated;
Line: 1593

 PROCEDURE get_person_cust_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    p_person_cust_id           IN           NUMBER,
    x_person_cust_obj         OUT NOCOPY    HZ_PERSON_CUST_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: 1616

        	hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1631

	HZ_EXTRACT_PERSON_CUST_BO_PVT.get_person_cust_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
		p_person_cust_id  => p_person_cust_id,
    		x_person_cust_obj  => x_person_cust_obj,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 1656

        	hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1679

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1698

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1721

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1728

  PROCEDURE get_person_cust_updated(
    p_event_id            IN            NUMBER,
    p_person_cust_id           IN           NUMBER,
    x_person_cust_obj         OUT NOCOPY    HZ_PERSON_CUST_BO,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_data            VARCHAR2(2000);
Line: 1738

    get_person_cust_updated(
      p_init_msg_list       => fnd_api.g_true,
      p_event_id            => p_event_id,
      p_person_cust_id      => p_person_cust_id,
      x_person_cust_obj     => x_person_cust_obj,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data
    );
Line: 1751

  END get_person_cust_updated;
Line: 1889

PROCEDURE get_ids_person_custs_updated (
	p_init_msg_list		IN	VARCHAR2 := fnd_api.g_false,
	p_event_id		IN	NUMBER,
	x_person_cust_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: 1911

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

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

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

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

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

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

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

        p_create_update_flag     => 'C',
        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              => l_person_os,
        p_parent_osr             => l_person_osr,
        p_parent_obj_type        => 'PERSON'
      );
Line: 2156

        p_create_or_update => 'C',
        p_obj_source       => p_obj_source,
        p_event_id         => l_per_event_id
      );
Line: 2165

        p_create_or_update => 'C',
        p_obj_source       => p_obj_source,
        p_event_id         => l_pc_event_id
      );
Line: 2325

  PROCEDURE do_update_person_cust_v2_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_person_cust_v2_obj     IN OUT NOCOPY HZ_PERSON_CUST_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_person_id           OUT NOCOPY    NUMBER
  ) IS
    l_person_os           VARCHAR2(30);
Line: 2345

    SAVEPOINT do_update_person_cust_v2_pub;
Line: 2357

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

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

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

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

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

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

    HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';
Line: 2418

    HZ_PERSON_BO_PUB.do_update_person_bo(
      p_init_msg_list          => fnd_api.g_false,
      p_person_obj             => p_person_cust_v2_obj.person_obj,
      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_person_id              => x_person_id,
      x_person_os              => l_person_os,
      x_person_osr             => l_person_osr
    );
Line: 2441

        p_create_update_flag     => 'U',
        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              => l_person_os,
        p_parent_osr             => l_person_osr,
        p_parent_obj_type        => 'PERSON'
      );
Line: 2464

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

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

    HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 2494

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

      ROLLBACK TO do_update_person_cust_v2_pub;
Line: 2505

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 2525

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

      ROLLBACK TO do_update_person_cust_v2_pub;
Line: 2536

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 2556

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

      ROLLBACK TO do_update_person_cust_v2_pub;
Line: 2567

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 2591

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

  END do_update_person_cust_v2_bo;
Line: 2597

  PROCEDURE update_person_cust_v2_bo(
    p_person_cust_v2_obj     IN            HZ_PERSON_CUST_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_PERSON_CUST_V2_BO,
    x_person_id           OUT NOCOPY    NUMBER
  ) IS
    l_msg_data            VARCHAR2(2000);
Line: 2612

    do_update_person_cust_v2_bo(
      p_init_msg_list       => fnd_api.g_true,
      p_person_cust_v2_obj     => l_pc_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
    );
Line: 2629

  END update_person_cust_v2_bo;
Line: 2650

    l_create_update_flag       VARCHAR2(1);
Line: 2673

    l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
                              p_entity_id      => l_person_id,
                              p_entity_os      => l_person_os,
                              p_entity_osr     => l_person_osr,
                              p_entity_type    => 'HZ_PARTIES',
                              p_parent_id      => NULL,
                              p_parent_obj_type=> NULL );
Line: 2681

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

    IF(l_create_update_flag = 'C') THEN
      do_create_person_cust_v2_bo(
        p_init_msg_list       => fnd_api.g_false,
        p_validate_bo_flag    => p_validate_bo_flag,
        p_person_cust_v2_obj     => p_person_cust_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_person_id           => x_person_id
      );
Line: 2702

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_person_cust_v2_bo(
        p_init_msg_list       => fnd_api.g_false,
        p_person_cust_v2_obj     => p_person_cust_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_person_id           => x_person_id
      );
Line: 2917

    	-- extraction validation logic is same as update

    	l_person_id := p_person_id;
Line: 3301

The Get Person Customers Updated procedure is a service to retrieve all of the Person Customer business objects whose updates
have been captured by the logical business event. Each Person Customers Updated business event signifies that one or more Person
Customer business objects have been updated.
The caller provides an identifier for the Person Customers Update business event and the procedure returns database objects of
the type HZ_PERSON_CUST_V2_BO for all of the Person Customer 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_v2_person_custs_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    x_person_cust_v2_objs         OUT NOCOPY    HZ_PERSON_CUST_V2_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: 3333

        	hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3348

	HZ_EXTRACT_PERSON_CUST_BO_PVT.get_v2_person_custs_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
    		x_person_cust_v2_objs  => x_person_cust_v2_objs,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 3372

        	hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3395

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3414

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3437

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3444

  PROCEDURE get_v2_person_custs_updated(
    p_event_id            IN            NUMBER,
    x_person_cust_v2_objs         OUT NOCOPY    HZ_PERSON_CUST_V2_BO_TBL,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  )IS
    l_msg_data            VARCHAR2(2000);
Line: 3453

    get_v2_person_custs_updated(
      p_init_msg_list      => fnd_api.g_true,
      p_event_id           => p_event_id,
      x_person_cust_v2_objs   => x_person_cust_v2_objs,
      x_return_status      => x_return_status,
      x_msg_count          => l_msg_count,
      x_msg_data           => l_msg_data
    );
Line: 3465

  END get_v2_person_custs_updated;
Line: 3499

 PROCEDURE get_v2_person_cust_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    p_person_cust_id           IN           NUMBER,
    x_person_cust_v2_obj         OUT NOCOPY    HZ_PERSON_CUST_V2_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: 3522

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

	HZ_EXTRACT_PERSON_CUST_BO_PVT.get_v2_person_cust_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
		p_person_cust_id  => p_person_cust_id,
    		x_person_cust_v2_obj  => x_person_cust_v2_obj,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 3562

        	hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3585

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3604

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3627

        hz_utility_v2pub.debug(p_message=>'hz_person_cust_bo_pub.get_v2_person_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3634

  PROCEDURE get_v2_person_cust_updated(
    p_event_id            IN            NUMBER,
    p_person_cust_id           IN           NUMBER,
    x_person_cust_v2_obj         OUT NOCOPY    HZ_PERSON_CUST_V2_BO,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_data            VARCHAR2(2000);
Line: 3644

    get_v2_person_cust_updated(
      p_init_msg_list       => fnd_api.g_true,
      p_event_id            => p_event_id,
      p_person_cust_id      => p_person_cust_id,
      x_person_cust_v2_obj     => x_person_cust_v2_obj,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data
    );
Line: 3657

  END get_v2_person_cust_updated;