Search Results oke_k_fifo_logs_s

Overview

OKE_K_ORGANIZER_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Knowledge Exchange (OKE) module, which supplies the contract terms and project-delivery functionality used by Oracle Projects and the broader Contracts family. The package acts as a supporting utility layer for the Contract Organizer, the hierarchical user interface component that presents contract and deliverable structures to end users. Its documented status is VALID, and it is classified under the ETRM (E-Business Suite Technical Reference Manual) as an API of type OTHER, indicating that it is not a formally published public API but rather an internal helper used by Oracle-developed forms and concurrent logic.

The principal business responsibility of the package is to supply the runtime services required to render and operate the Organizer tree: building the query nodes that drive the tree's data retrieval, recording FIFO-related processing events for audit and traceability, and resolving party names for display. Because it is not referenced by any other database object, it functions as a leaf-level dependency within the OKE call stack and is invoked exclusively by the associated Oracle Forms and internal callers rather than by external customer code.

Key Procedures and Functions

The package exposes three documented program units:

• POPULATE_QUERY_NODE — Constructs and populates the query node definitions used by the Contract Organizer tree. This routine assembles the dynamic SQL fragments or node metadata that the Organizer uses to retrieve and display contract structure data, which is consistent with the package's dependency on DBMS_SQL.
• FIFO_LOG — Writes entries to the OKE_K_FIFO_LOGS table. FIFO logging supports the first-in-first-out processing semantics used within the OKE knowledge/contract entity flows, providing an audit trail of sequenced operations performed through the Organizer.
• GET_PARTY_NAME — Resolves and returns the displayable name of a party associated with a contract or object, drawing on the contract party role data rather than requiring the calling form to perform the lookup itself.

Parameter lists are not documented in the ETRM extract and are therefore not reproduced here.

Tables Accessed

The package references the following objects through APPS synonyms:

• OKE_K_FIFO_LOGS — The base table storing FIFO log records written by FIFO_LOG.
• OKE_K_FIFO_LOGS_S — The sequence associated with the FIFO log table, used to generate unique log identifiers. This is the object most directly associated with the user's search term, and it confirms that the sequence is consumed by this package rather than by an external caller.
• OKC_K_PARTY_ROLES_B — The contract party roles base table, consulted by GET_PARTY_NAME to resolve party identity.
• JTF_OBJECTS_B — The common object registry base table, used to relate Organizer nodes to their underlying JTF objects.
• DUAL — Standard single-row utility table used in scalar expressions.
• DBMS_SQL — The dynamic SQL package, indicating that POPULATE_QUERY_NODE builds queries at runtime.

Additional dependencies include FND_APPTREE, FND_MESSAGE, and FND_PROFILE, which supply tree rendering, message lookup, and profile option resolution respectively.

Usage Notes

OKE_K_ORGANIZER_PKG is an internal, Oracle-owned package. It is not referenced by any other database object, so its callers are forms-level or server-side code embedded in the OKE application rather than other PL/SQL APIs. It is typically invoked in the context of the Contract Organizer form, where POPULATE_QUERY_NODE prepares the tree query, GET_PARTY_NAME supplies display labels, and FIFO_LOG records processing events. Because the package is classified as OTHER, it is not covered by Oracle's public API compatibility guarantees, and customizations should not call it directly. Any diagnostic work involving OKE_K_FIFO_LOGS_S should recognize that sequence consumption occurs through FIFO_LOG within this package.