DBA Data[Home] [Help]

APPS.HZ_ORGANIZATION_BO_PUB SQL Statements

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

Line: 32

    p_create_or_update                 IN            VARCHAR2 := 'C',
    px_organization_rec                IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
  );
Line: 190

    p_create_or_update                 IN            VARCHAR2 := 'C',
    px_organization_rec                IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
  ) IS
  BEGIN
    px_organization_rec.organization_name:=  p_organization_obj.organization_name;
Line: 333

    IF(p_create_or_update = 'C') THEN
      px_organization_rec.party_rec.orig_system:= p_organization_os;
Line: 505

    px_credit_rating_rec.spcl_event_update_date:=  p_credit_rating_obj.spcl_event_update_date;
Line: 893

        HZ_PARTY_INFO_V2PUB.update_credit_rating(
          p_credit_rating_rec         => l_credit_rating_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: 1266

        HZ_ORGANIZATION_INFO_V2PUB.update_financial_report(
          p_financial_report_rec      => l_fin_report_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: 1337

            HZ_ORGANIZATION_INFO_V2PUB.update_financial_number(
              p_financial_number_rec      => l_fin_number_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: 1520

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

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

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

        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_org_id      => x_organization_id,
        p_parent_org_os      => x_organization_os,
        p_parent_org_osr     => x_organization_osr
      );
Line: 1704

        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_organization_id,
        p_parent_os          => x_organization_os,
        p_parent_osr         => x_organization_osr,
        p_parent_obj_type    => 'ORG'
      );
Line: 1743

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

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

  PROCEDURE do_update_organization_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_organization_obj    IN OUT NOCOPY HZ_ORGANIZATION_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,
    x_organization_os     OUT NOCOPY    VARCHAR2,
    x_organization_osr    OUT NOCOPY    VARCHAR2
  )IS
    l_debug_prefix             VARCHAR2(30);
Line: 2059

    l_create_update_flag       VARCHAR2(1);
Line: 2073

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

    SAVEPOINT do_update_organization_bo_pub;
Line: 2101

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

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

    IF(HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO IS NOT NULL) THEN
      l_org_raise_event := FALSE;
Line: 2136

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

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

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

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

      p_create_or_update  => 'U',
      px_organization_rec => l_organization_rec
    );
Line: 2178

    HZ_PARTY_V2PUB.update_organization(
      p_organization_rec          => l_organization_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: 2203

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

        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_org_id      => x_organization_id,
        p_parent_org_os      => x_organization_os,
        p_parent_org_osr     => x_organization_osr
      );
Line: 2322

        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_organization_id,
        p_parent_os          => x_organization_os,
        p_parent_osr         => x_organization_osr,
        p_parent_obj_type    => 'ORG'
      );
Line: 2361

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

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

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

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

      ROLLBACK TO do_update_organization_bo_pub;
Line: 2530

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

      ROLLBACK TO do_update_organization_bo_pub;
Line: 2561

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

      ROLLBACK TO do_update_organization_bo_pub;
Line: 2594

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

  END do_update_organization_bo;
Line: 2600

  PROCEDURE update_organization_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_organization_obj    IN            HZ_ORGANIZATION_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,
    x_organization_os     OUT NOCOPY    VARCHAR2,
    x_organization_osr    OUT NOCOPY    VARCHAR2
  ) IS
    l_org_obj             HZ_ORGANIZATION_BO;
Line: 2614

    do_update_organization_bo(
      p_init_msg_list       => p_init_msg_list,
      p_organization_obj    => l_org_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,
      x_organization_os     => x_organization_os,
      x_organization_osr    => x_organization_osr
    );
Line: 2626

  END update_organization_bo;
Line: 2628

  PROCEDURE update_organization_bo(
    p_organization_obj    IN            HZ_ORGANIZATION_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_ORGANIZATION_BO,
    x_organization_id     OUT NOCOPY    NUMBER,
    x_organization_os     OUT NOCOPY    VARCHAR2,
    x_organization_osr    OUT NOCOPY    VARCHAR2
  )IS
    l_msg_data            VARCHAR2(2000);
Line: 2645

    do_update_organization_bo(
      p_init_msg_list       => fnd_api.g_true,
      p_organization_obj    => l_org_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,
      x_organization_os     => x_organization_os,
      x_organization_osr    => x_organization_osr
    );
Line: 2664

  END update_organization_bo;
Line: 2686

    l_create_update_flag       VARCHAR2(1);
Line: 2710

    l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
                              p_entity_id      => x_organization_id,
                              p_entity_os      => x_organization_os,
                              p_entity_osr     => x_organization_osr,
                              p_entity_type    => 'HZ_PARTIES',
                              p_parent_id      => NULL,
                              p_parent_obj_type=> NULL );
Line: 2718

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

    IF(l_create_update_flag = 'C') THEN
      do_create_organization_bo(
        p_init_msg_list      => fnd_api.g_false,
        p_validate_bo_flag   => p_validate_bo_flag,
        p_organization_obj   => p_organization_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_organization_id    => x_organization_id,
        x_organization_os    => x_organization_os,
        x_organization_osr   => x_organization_osr
      );
Line: 2741

    ELSIF(l_create_update_flag = 'U') THEN
      do_update_organization_bo(
        p_init_msg_list      => fnd_api.g_false,
        p_organization_obj   => p_organization_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_organization_id    => x_organization_id,
        x_organization_os    => x_organization_os,
        x_organization_osr   => x_organization_osr
      );
Line: 3014

    	-- extraction validation logic is same as update

    	l_organization_id := p_organization_id;
Line: 3398

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

        	hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3446

	HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organizations_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
    		x_organization_objs  => x_organization_objs,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 3470

        	hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3493

        hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3512

        hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3535

        hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3542

  PROCEDURE get_organizations_updated(
    p_event_id            IN            NUMBER,
    x_organization_objs   OUT NOCOPY    HZ_ORGANIZATION_BO_TBL,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_data            VARCHAR2(2000);
Line: 3551

    get_organizations_updated(
      p_init_msg_list       => fnd_api.g_true,
      p_event_id            => p_event_id,
      x_organization_objs   => x_organization_objs,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data);
Line: 3562

  END get_organizations_updated;
Line: 3597

PROCEDURE get_organization_updated(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_event_id            IN           	NUMBER,
    p_organization_id     IN           NUMBER,
    x_organization_obj    OUT NOCOPY   HZ_ORGANIZATION_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: 3620

        	hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(+)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3635

	HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_updated(
    		p_init_msg_list => fnd_api.g_false,
		p_event_id => p_event_id,
		p_organization_id  => p_organization_id,
    		x_organization_obj  => x_organization_obj,
		x_return_status => x_return_status,
		x_msg_count => x_msg_count,
		x_msg_data => x_msg_data);
Line: 3660

        	hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated (-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3683

        hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3702

        hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3725

        hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);
Line: 3732

  PROCEDURE get_organization_updated(
    p_event_id            IN            NUMBER,
    p_organization_id     IN           NUMBER,
    x_organization_obj    OUT NOCOPY   HZ_ORGANIZATION_BO,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_messages            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_data            VARCHAR2(2000);
Line: 3742

    get_organization_updated(
      p_init_msg_list       => fnd_api.g_true,
      p_event_id            => p_event_id,
      p_organization_id     => p_organization_id,
      x_organization_obj    => x_organization_obj,
      x_return_status       => x_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data);
Line: 3754

  END get_organization_updated;
Line: 3894

PROCEDURE get_ids_organizations_updated (
	p_init_msg_list		IN	VARCHAR2 := fnd_api.g_false,
	p_event_id		IN	NUMBER,
	x_organization_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: 3916

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

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

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

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

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