Search Results ego_varchar_tbl_type




Overview
Explore in AI Chat

Overview

APPS.EGO_ITEM_ASSOCIATIONS_UTIL is a utility PL/SQL package in Oracle E-Business Suite that supports supplier and supplier site association logic used within the item management and product information management (PIM) flows. The package is classified as a UTIL API in ETRM, indicating it is an internal helper rather than a public, versioned business API. In the 12.1.1 and 12.2.2 releases, this package underpins the search and validation routines invoked by the item associations application module, allowing users to locate suppliers and supplier sites against a master inventory organization. The header comment $Header: EGOVIAUS.pls 120.1 2007/03/26 identifies the source file and confirms the package is shipped as an noship (not customer-modifiable) component delivered under the EGO product family. Its role is to construct and execute dynamic search queries over supplier, site, and party data so that downstream item–supplier associations can be created and maintained with accurate reference data.

Key Procedures and Functions

The package exposes two documented procedures:

  • SEARCH_SUPPLIER_AND_SITE — A private helper that searches for suppliers and supplier sites matching caller-supplied criteria. It accepts a search-column list and a parallel search-criteria list, both typed as EGO_VARCHAR_TBL_TYPE, together with a master organization identifier and optional flags such as whether to search sites only, whether to filter rows, and whether to restrict results to existing sites. The documented pre-requisites require that the search columns and criteria contain equal numbers of values, that at least one criterion be supplied, and that the organization identifier correspond to the master organization, since no validation is performed and an incorrect value returns no rows. This is the object most relevant to the search term ego_varchar_tbl_type, which is the PL/SQL collection type used to pass column names and their corresponding values.
  • IS_SUPPLIER_CONTACT — A validation routine that determines whether a given party or supplier is classified as a supplier contact. It is used to qualify supplier records before they are associated with items, ensuring that only legitimate contact relationships are surfaced or accepted by the association logic.

Tables Accessed

The package reads from and references the following documented tables and objects through APPS synonyms:

  • AP_SUPPLIER_CONTACTS — Provides supplier contact records used by IS_SUPPLIER_CONTACT to validate whether a supplier has associated contact information.
  • HZ_PARTIES — Supplies the underlying party (supplier and organization) data that forms the master reference for supplier search results.
  • FND_USER — Supports user context, typically for responsibility or security filtering applied during search execution.
  • EGO_MASSUPDATE_S — Stores mass-update set information, consistent with the broader EGO item association and mass-maintenance framework.
  • DBMS_SQL, DUAL, PLITBLM — Utility references supporting dynamic SQL construction (DBMS_SQL), single-row expression evaluation (DUAL), and PL/SQL table/index-by structures (PLITBLM) used to build and iterate the EGO_VARCHAR_TBL_TYPE search lists.

Usage Notes

Because the package is classified as UTIL and its primary procedure is documented as private, it is not intended for direct invocation by customer extensions. Instead, it is called internally by the item associations application module and by one other dependent package within the EGO schema. It is typically triggered from the Oracle Applications Framework (OAF) pages used to manage item–supplier associations, where the search region builds column/value pairs and passes them as EGO_VARCHAR_TBL_TYPE collections. The returned supplier and site rows populate selection lists for downstream association creation. Custom code should not call SEARCH_SUPPLIER_AND_SITE directly; where supplier search functionality is required, developers should use the supported public APIs in the EGO and Oracle Procurement families. The noship source designation further reinforces that this package is subject to change without notice across releases.