DBA Data[Home] [Help]

APPS.HZ_ORG_CUST_BO_PUB SQL Statements

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

Line: 15

  PROCEDURE do_update_org_cust_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_org_cust_obj        IN OUT NOCOPY HZ_ORG_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_organization_id     OUT NOCOPY    NUMBER
  );
Line: 103

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

        SELECT HZ_BUS_OBJ_TRACKING_S.nextval
        INTO l_oc_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_organization_id,
        p_parent_os              => l_organization_os,
        p_parent_osr             => l_organization_osr,
        p_parent_obj_type        => 'ORG'
      );
Line: 173

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

        p_create_or_update => 'C',
        p_obj_source       => p_obj_source,
        p_event_id         => l_oc_event_id
      );
Line: 366

  PROCEDURE do_update_org_cust_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_org_cust_obj        IN OUT NOCOPY HZ_ORG_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_organization_id     OUT NOCOPY    NUMBER
  ) IS
    l_organization_os     VARCHAR2(30);
Line: 386

    SAVEPOINT do_update_org_cust_bo_pub;
Line: 398

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

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

    l_org_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
                           p_party_id          => x_organization_id,
                           p_bo_code           => 'ORG'
                         );
Line: 436

    l_oc_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
                          p_party_id          => x_organization_id,
                          p_bo_code           => 'ORG_CUST'
                        );
Line: 443

      SELECT HZ_BUS_OBJ_TRACKING_S.nextval
      INTO l_org_event_id
      FROM DUAL;
Line: 450

      SELECT HZ_BUS_OBJ_TRACKING_S.nextval
      INTO l_oc_event_id
      FROM DUAL;
Line: 456

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

    HZ_ORGANIZATION_BO_PUB.do_update_organization_bo(
      p_init_msg_list          => fnd_api.g_false,
      p_organization_obj       => p_org_cust_obj.organization_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_organization_id        => x_organization_id,
      x_organization_os        => l_organization_os,
      x_organization_osr       => l_organization_osr
    );
Line: 482

        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_organization_id,
        p_parent_os              => l_organization_os,
        p_parent_osr             => l_organization_osr,
        p_parent_obj_type        => 'ORG'
      );
Line: 505

        p_create_or_update => 'U',
        p_obj_source       => p_obj_source,
        p_event_id         => l_org_event_id
      );
Line: 516

        p_create_or_update => 'U',
        p_obj_source       => p_obj_source,
        p_event_id         => l_oc_event_id
      );
Line: 525

    HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 535

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

      ROLLBACK TO do_update_org_cust_bo_pub;
Line: 547

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 567

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

      ROLLBACK TO do_update_org_cust_bo_pub;
Line: 578

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 598

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

      ROLLBACK TO do_update_org_cust_bo_pub;
Line: 609

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 633

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

  END do_update_org_cust_bo;
Line: 639

  PROCEDURE update_org_cust_bo(
    p_init_msg_list        IN            VARCHAR2 := fnd_api.g_false,
    p_org_cust_obj         IN            HZ_ORG_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_organization_id      OUT NOCOPY    NUMBER
  ) IS
    l_oc_obj              HZ_ORG_CUST_BO;
Line: 651

    do_update_org_cust_bo(
      p_init_msg_list       => p_init_msg_list,
      p_org_cust_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_organization_id     => x_organization_id
    );
Line: 661

  END update_org_cust_bo;
Line: 663

  PROCEDURE update_org_cust_bo(
    p_org_cust_obj        IN            HZ_ORG_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_ORG_CUST_BO,
    x_organization_id     OUT NOCOPY    NUMBER
  ) IS
    l_msg_count           NUMBER;
Line: 678

    do_update_org_cust_bo(
      p_init_msg_list       => fnd_api.g_true,
      p_org_cust_obj        => l_oc_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_organization_id     => x_organization_id
    );
Line: 695

  END update_org_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_organization_id,
                              p_entity_os      => l_organization_os,
                              p_entity_osr     => l_organization_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_org_cust_bo(
        p_init_msg_list       => fnd_api.g_false,
        p_validate_bo_flag    => p_validate_bo_flag,
        p_org_cust_obj        => p_org_cust_obj,
        p_created_by_module   => p_created_by_module,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        x_organization_id     => x_organization_id
      );
Line: 767

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_org_cust_bo(
        p_init_msg_list       => fnd_api.g_false,
        p_org_cust_obj        => p_org_cust_obj,
        p_created_by_module   => p_created_by_module,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        x_organization_id     => x_organization_id
      );
Line: 1012

    	-- extraction validation logic is same as update

    	l_organization_id := p_organization_id;
Line: 1401

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

        	hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1448

	HZ_EXTRACT_ORG_CUST_BO_PVT.get_org_custs_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
    		x_org_cust_objs  => x_org_cust_objs,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 1472

        	hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1495

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1514

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1537

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1544

 PROCEDURE get_org_custs_updated(
    p_event_id            IN            NUMBER,
    x_org_cust_objs         OUT NOCOPY    HZ_ORG_CUST_BO_TBL,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_data            VARCHAR2(2000);
Line: 1553

    get_org_custs_updated(
      p_init_msg_list       => fnd_api.g_true,
      p_event_id            => p_event_id,
      x_org_cust_objs       => x_org_cust_objs,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data
    );
Line: 1565

  END get_org_custs_updated;
Line: 1569

 PROCEDURE get_org_cust_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    p_org_cust_id           IN           NUMBER,
    x_org_cust_obj         OUT NOCOPY    HZ_ORG_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: 1592

        	hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1607

	HZ_EXTRACT_ORG_CUST_BO_PVT.get_org_cust_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
		p_org_cust_id  => p_org_cust_id,
    		x_org_cust_obj  => x_org_cust_obj,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 1632

        	hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1655

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1674

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1697

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 1704

 PROCEDURE get_org_cust_updated(
    p_event_id            IN            NUMBER,
    p_org_cust_id           IN           NUMBER,
    x_org_cust_obj         OUT NOCOPY    HZ_ORG_CUST_BO,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_data            VARCHAR2(2000);
Line: 1714

    get_org_cust_updated(
      p_init_msg_list       => fnd_api.g_false,
      p_event_id            => p_event_id,
      p_org_cust_id         => p_org_cust_id,
      x_org_cust_obj        => x_org_cust_obj,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data
    );
Line: 1727

  END get_org_cust_updated;
Line: 1865

PROCEDURE get_ids_org_custs_updated (
	p_init_msg_list		IN	VARCHAR2 := fnd_api.g_false,
	p_event_id		IN	NUMBER,
	x_org_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: 1887

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

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

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

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

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

        SELECT HZ_BUS_OBJ_TRACKING_S.nextval
        INTO l_org_event_id
        FROM DUAL;
Line: 2069

        SELECT HZ_BUS_OBJ_TRACKING_S.nextval
        INTO l_oc_event_id
        FROM DUAL;
Line: 2111

        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_organization_id,
        p_parent_os              => l_organization_os,
        p_parent_osr             => l_organization_osr,
        p_parent_obj_type        => 'ORG'
      );
Line: 2134

        p_create_or_update => 'C',
        p_obj_source       => p_obj_source,
        p_event_id         => l_org_event_id
      );
Line: 2143

        p_create_or_update => 'C',
        p_obj_source       => p_obj_source,
        p_event_id         => l_oc_event_id
      );
Line: 2302

  PROCEDURE do_update_org_cust_v2_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_org_cust_v2_obj        IN OUT NOCOPY HZ_org_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_organization_id     OUT NOCOPY    NUMBER
  ) IS
    l_organization_os     VARCHAR2(30);
Line: 2322

    SAVEPOINT do_update_org_cust_v2_bo_pub;
Line: 2334

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

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

    l_org_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
                           p_party_id          => x_organization_id,
                           p_bo_code           => 'ORG'
                         );
Line: 2372

    l_oc_raise_event := HZ_PARTY_BO_PVT.is_raising_update_event(
                          p_party_id          => x_organization_id,
                          p_bo_code           => 'ORG_CUST'
                        );
Line: 2379

      SELECT HZ_BUS_OBJ_TRACKING_S.nextval
      INTO l_org_event_id
      FROM DUAL;
Line: 2386

      SELECT HZ_BUS_OBJ_TRACKING_S.nextval
      INTO l_oc_event_id
      FROM DUAL;
Line: 2392

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

    HZ_ORGANIZATION_BO_PUB.do_update_organization_bo(
      p_init_msg_list          => fnd_api.g_false,
      p_organization_obj       => p_org_cust_v2_obj.organization_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_organization_id        => x_organization_id,
      x_organization_os        => l_organization_os,
      x_organization_osr       => l_organization_osr
    );
Line: 2418

        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_organization_id,
        p_parent_os              => l_organization_os,
        p_parent_osr             => l_organization_osr,
        p_parent_obj_type        => 'ORG'
      );
Line: 2441

        p_create_or_update => 'U',
        p_obj_source       => p_obj_source,
        p_event_id         => l_org_event_id
      );
Line: 2452

        p_create_or_update => 'U',
        p_obj_source       => p_obj_source,
        p_event_id         => l_oc_event_id
      );
Line: 2461

    HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 2471

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

      ROLLBACK TO do_update_org_cust_v2_bo_pub;
Line: 2483

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 2503

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

      ROLLBACK TO do_update_org_cust_v2_bo_pub;
Line: 2514

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 2534

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

      ROLLBACK TO do_update_org_cust_v2_bo_pub;
Line: 2545

      HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
Line: 2569

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

  END do_update_org_cust_v2_bo;
Line: 2576

  PROCEDURE update_org_cust_v2_bo(
    p_org_cust_v2_obj        IN            HZ_org_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_org_cust_v2_bo,
    x_organization_id     OUT NOCOPY    NUMBER
  ) IS
    l_msg_count           NUMBER;
Line: 2591

    do_update_org_cust_v2_bo(
      p_init_msg_list       => fnd_api.g_true,
      p_org_cust_v2_obj        => l_oc_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_organization_id     => x_organization_id
    );
Line: 2608

  END update_org_cust_v2_bo;
Line: 2629

    l_create_update_flag       VARCHAR2(1);
Line: 2652

    l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
                              p_entity_id      => l_organization_id,
                              p_entity_os      => l_organization_os,
                              p_entity_osr     => l_organization_osr,
                              p_entity_type    => 'HZ_PARTIES',
                              p_parent_id      => NULL,
                              p_parent_obj_type=> NULL );
Line: 2660

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

    IF(l_create_update_flag = 'C') THEN
      do_create_org_cust_v2_bo(
        p_init_msg_list       => fnd_api.g_false,
        p_validate_bo_flag    => p_validate_bo_flag,
        p_org_cust_v2_obj        => p_org_cust_v2_obj,
        p_created_by_module   => p_created_by_module,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        x_organization_id     => x_organization_id
      );
Line: 2680

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_org_cust_v2_bo(
        p_init_msg_list       => fnd_api.g_false,
        p_org_cust_v2_obj        => p_org_cust_v2_obj,
        p_created_by_module   => p_created_by_module,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        x_organization_id     => x_organization_id
      );
Line: 2900

    	-- extraction validation logic is same as update

    	l_organization_id := p_organization_id;
Line: 3283

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

        	hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3330

	HZ_EXTRACT_ORG_CUST_BO_PVT.get_v2_org_custs_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
    		x_org_cust_v2_objs  => x_org_cust_v2_objs,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 3354

        	hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3377

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3396

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3419

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3426

 PROCEDURE get_v2_org_custs_updated(
    p_event_id            IN            NUMBER,
    x_org_cust_v2_objs         OUT NOCOPY    HZ_ORG_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: 3435

    get_v2_org_custs_updated(
      p_init_msg_list       => fnd_api.g_true,
      p_event_id            => p_event_id,
      x_org_cust_v2_objs       => x_org_cust_v2_objs,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data
    );
Line: 3447

  END get_v2_org_custs_updated;
Line: 3450

 PROCEDURE get_v2_org_cust_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    p_org_cust_id           IN           NUMBER,
    x_org_cust_v2_obj         OUT NOCOPY    HZ_ORG_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: 3473

        	hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3488

	HZ_EXTRACT_ORG_CUST_BO_PVT.get_v2_org_cust_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
		p_org_cust_id  => p_org_cust_id,
    		x_org_cust_v2_obj  => x_org_cust_v2_obj,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 3513

        	hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3536

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3555

        hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3578

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

 PROCEDURE get_v2_org_cust_updated(
    p_event_id            IN            NUMBER,
    p_org_cust_id           IN           NUMBER,
    x_org_cust_v2_obj         OUT NOCOPY    HZ_ORG_CUST_V2_BO,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_data            VARCHAR2(2000);
Line: 3595

    get_v2_org_cust_updated(
      p_init_msg_list       => fnd_api.g_false,
      p_event_id            => p_event_id,
      p_org_cust_id         => p_org_cust_id,
      x_org_cust_v2_obj        => x_org_cust_v2_obj,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data
    );
Line: 3608

  END get_v2_org_cust_updated;