APPS.HZ_ORG_CONTACT_BO_PVT SQL Statements

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

Line: 329

          HZ_PARTY_CONTACT_V2PUB.update_org_contact_role(
            p_org_contact_role_rec      => l_ocr_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: 472

    p_create_update_flag  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,
    p_parent_org_id       IN OUT NOCOPY NUMBER,
    p_parent_org_os       IN OUT NOCOPY VARCHAR2,
    p_parent_org_osr      IN OUT NOCOPY VARCHAR2
  ) IS
    l_debug_prefix        VARCHAR2(30);

Line: 506

    IF(p_create_update_flag = 'C') THEN
      -----------------------------
      -- Create logical org contact
      -----------------------------
      FOR i IN 1..p_oc_objs.COUNT LOOP
        HZ_ORG_CONTACT_BO_PUB.do_create_org_contact_bo(
          p_init_msg_list      => fnd_api.g_false,
          p_validate_bo_flag   => fnd_api.g_false,
          p_org_contact_obj    => p_oc_objs(i),
          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_org_contact_id     => l_oc_id,
          x_org_contact_os     => l_oc_os,
          x_org_contact_osr    => l_oc_osr,
          px_parent_org_id     => l_parent_org_id,
          px_parent_org_os     => l_parent_org_os,
          px_parent_org_osr    => l_parent_org_osr
        );