Search Results g_party_type_supplier




Overview
Explore in AI Chat

Overview

OKC_REP_CONTRACT_TEXT_IDX_PVT is a private PL/SQL package body owned by APPS in the Oracle E-Business Suite Contracts (OKC) module. It belongs to the repository contract text indexing and metadata generation layer of the ETRM (Enterprise Contracts) product family. The package's declared purpose is to assemble searchable metadata for repository contracts, extracting contract descriptors such as organization names, contract numbers, contract names, descriptions, keywords, comments, party names, and contact names into a metadata large object (CLOB). This metadata is subsequently consumed by the Repository contract text index, which drives keyword and full-text search capabilities over contracts stored in the ETRM repository. The package is classified as PVT, indicating it is intended for internal use by other OKC components rather than as a public API surface, and it is referenced by zero other packages per the documented dependency data, meaning it functions as a leaf-level utility invoked directly by repository indexing logic.

Key Procedures and Functions

  • OKC_REP_CON_MD — A private procedure that collects metadata for a repository contract. It accepts a ROWID identifying the source contract row and an IN OUT NOCOPY CLOB into which the generated metadata is written. The procedure opens a weakly typed REF CURSOR, builds a dynamic SQL statement, and populates several PL/SQL collection types (organization names, contract numbers, names, descriptions, keywords, comments, party names, and contact names) that are serialized into the metadata CLOB. This procedure is the core payload generator for contract text indexing.
  • OKC_REP_VER_MD — A private procedure documented as collecting metadata for repository contract versioning. It operates in the same metadata assembly domain, supporting the version-aware dimension of repository contract indexing so that historical or versioned contract text remains discoverable.

Tables Accessed

The documented table references list only DBMS_LOB and PLITBLM. DBMS_LOB is the Oracle-supplied supplied package used for large object manipulation, and the package relies on it to write, append, and manage the metadata CLOB assembled by OKC_REP_CON_MD. PLITBLM is the Oracle supplied package that provides PL/SQL table (index-by table) support routines; the package's use of associative array collection types for organization names, contract numbers, contract names, descriptions, keywords, comments, party names, and contact names aligns with this dependency. No application tables are enumerated in the documented metadata; the underlying contract, party, and repository tables are accessed indirectly through the dynamic SQL statement constructed at runtime inside OKC_REP_CON_MD rather than through static declarations.

Usage Notes

Because the package is classified PVT and is referenced by zero other packages, it is not intended for direct invocation by external customizations. It is typically called by the repository contract text indexing framework within ETRM when a contract must be registered or refreshed in the search index, such as during contract creation, update, or reindexing operations. The global constants G_PARTY_TYPE_INTERNAL, G_PARTY_TYPE_CUSTOMER, G_PARTY_TYPE_SUPPLIER, and G_PARTY_TYPE_PARTNER define the accepted party type discriminators used when resolving party-related metadata, and G_PKG_NAME, G_MODULE, G_UNEXPECTED_ERROR, G_SQLERRM_TOKEN, and G_SQLCODE_TOKEN support the package's error handling and message token substitution. The header comment indicates a last revision of version 120.1 dated 2005/08/22, marking it as a long-standing, stable component of the ETRM repository indexing stack in both 12.1.1 and 12.2.2. The user search term "g_party_type_internal" corresponds directly to the internal organization party type constant declared at line 7 of the package body, which is used to classify internal organization parties during metadata extraction.