Search Results find_parties_2




Overview
Explore in AI Chat

Overview

APPS.HZ_PARTY_SEARCH_W is a public wrapper package in the Oracle E-Business Suite Trading Community Architecture (TCA) that exposes the party search engine implemented in HZ_PARTY_SEARCH. Its documented purpose is to provide a stable, cross-schema entry point for the Rosetta-style bulk data conversion routines and the higher-level party, person, and contact search functions used by the Oracle Forms-based customer and contact search user interfaces. The package is declared AUTHID CURRENT_USER, which means that at runtime it executes with the privileges of the calling schema (typically APPS or a custom schema granted the necessary TCA privileges), rather than as definer. This design allows the wrapper to be called from forms sessions, concurrent programs, and custom PL/SQL without granting direct access to the underlying HZ_PARTY_SEARCH package. The package header carries the CVS revision marker ARHDQJSS.pls 120.5 dated 30-Oct-2005, indicating that the wrapper interface has been stable across the 11i, 12.1.1, and 12.2.2 releases.

Key Procedures and Functions

The package exposes 28 documented procedures, organized into two families.

  • Rosetta table copy routines — ROSETTA_TABLE_COPY_IN_P5 through P10 and P12, together with their ROSETTA_TABLE_COPY_OUT_P5 through P12 counterparts. These are generated conversion routines that move data between the nested table type HZ_PARTY_SEARCH.SCORELIST and the flat JTF_NUMBER_TABLE collections. The "IN" variants accept a large number of JTF_NUMBER_TABLE parameters (the P5 variant, for example, declares a0 through a49) and populate the SCORELIST; the "OUT" variants perform the reverse conversion. They exist because Oracle Forms cannot pass nested tables directly over the PL/SQL-to-Forms boundary, so a flat collection representation is required.
  • Business search functions — FIND_PARTIES_1, FIND_PARTIES_2, FIND_PERSONS_3, GET_MATCHING_PARTY_SITES_4, GET_MATCHING_PARTY_SITES_5, and GET_MATCHING_CONTACTS_6. These are the externally callable search entry points: FIND_PARTIES_1 and FIND_PARTIES_2 perform organization and general party searches; FIND_PERSONS_3 searches for person parties; GET_MATCHING_PARTY_SITES_4 and _5 return matching party site records for a party; GET_MATCHING_CONTACTS_6 returns matching contact records.

The consistent numeric suffixes reflect incremental functional revisions, with the highest-numbered procedure in each family being the current entry point. No procedure parameter list should be assumed from the name alone; the authoritative signatures are in the package specification.

Tables Accessed

The documented table reference is PLITBLM, the Oracle Text / interMedia index table accessed through an APPS synonym. PLITBLM (the "plural table" used by the extensible index engine) is read during fuzzy, soundex, and keyword-based party name searches to evaluate index tokens. The bulk of the actual TCA data (HZ_PARTIES, HZ_PERSON_PROFILES, HZ_PARTY_SITES, HZ_ORG_CONTACTS) is accessed indirectly through HZ_PARTY_SEARCH; the wrapper itself does not issue direct DML. The package is not referenced by any other documented package, confirming its role as a leaf-level API called from the client tier.

Usage Notes

HZ_PARTY_SEARCH_W is normally invoked from the Oracle Forms customer search and contact search screens, where the Rosetta copy routines marshal the SCORELIST results into JTF_NUMBER_TABLE arrays for display in the forms block. It is also available on the package whitelist for registered custom code and for concurrent programs that need programmatic access to the party search engine. Customizations should call the wrapper rather than HZ_PARTY_SEARCH directly, because the wrapper encapsulates the nested-table conversion and shields callers from internal signature changes between releases. Because the package is AUTHID CURRENT_USER, the invoking schema must be granted EXECUTE on HZ_PARTY_SEARCH_W and on the underlying HZ_PARTY_SEARCH package, and must be able to resolve the PLITBLM synonym.