Search Results decimal_to_elin

Overview

PO_EXHIBITS_PVT is a private PL/SQL package in the Oracle E-Business Suite Purchasing (PO) module, owned by APPS and classified as a PVT (private) API. It is not intended for direct external invocation; instead, it supports the exhibit management framework introduced under the CLM (Contract Lifecycle Management) Phase 4 "Elins" project. Exhibits represent structured contractual attachments — such as CDRL (Contract Data Requirements List) items — tied to a purchasing document, and each exhibit line carries an Exhibit Line Item Number (ELIN). The package provides the internal machinery to generate, translate, and sequence ELIN identifiers, to maintain the draft versus transaction record model used by the Purchasing document authoring UI, and to copy or delete exhibits at the document level. The symbol the user searched for, decimal_to_elin, is the internal ELIN conversion routine documented in the package header. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer.

Key Procedures and Functions

The documented interface exposed by the package header (release 120.2.12020000.4) includes a small set of ELIN utilities and a broader set of internal exhibit maintenance routines. Per the metadata, 17 procedures and functions are documented in 12.2.2:

• ELIN_TO_DECIMAL — accepts a character ELIN string and returns the corresponding numeric value, converting the display form of an exhibit line number into a sortable decimal representation.
• DECIMAL_TO_ELIN — the inverse of the above; accepts a numeric value and returns the formatted character ELIN string used for display and storage.
• NEXT_ELIN_NUM — returns the next eligible ELIN for a given exhibit of a document, taking the document header identifier, exhibit name, and the set of already-assigned line numbers so that gaps and duplicates are avoided.
• GET_NEXT_EXHIBIT — retrieves the next exhibit record in sequence for the document.
• LOCK_DRAFT_RECORD and LOCK_TRANSACTION_RECORD — acquire row-level locks on the draft and transactional exhibit records respectively, enforcing concurrency control during editing.
• SYNC_DRAFT_FROM_TXN — populates the draft exhibit rows from the committed transaction rows, establishing the baseline for editing.
• MERGE_CHANGES — reconciles modifications made in the draft layer back against the transactional data.
• DRAFT_CHANGES_EXIST — boolean-style check reporting whether uncommitted draft modifications remain.
• APPLY_CHANGES — commits the accepted draft modifications into the transactional exhibit tables.
• DELETE_ROWS, INSERT_EXHIBITS, and DELETE_EXHIBITS — low-level row maintenance operations for exhibit detail records.
• COPY_CDRL_EXHIBIT and DELETE_CDRLS_FOR_EXHIBIT — specialized routines for cloning and removing CDRL-based exhibit content.

The package also declares the exception ELIN_NUMBERS_EXHAUSTED, raised when the ELIN generation logic cannot allocate a further line number.

Tables Accessed

The package reads and writes exhibit data through APPS synonyms, which include PO_EXHIBIT_DETAILS and its draft counterpart PO_EXHIBIT_DETAILS_DRAFT, plus the shadow table PO_EXHIBIT_DETAILS_S used for the draft/transaction synchronization pattern. PO_DRAFTS supports the draft record locking and change detection logic. FND_LOOKUP_VALUES supplies reference lookup data such as exhibit types and statuses. PO_SESSION_GT provides session-scoped temporary context for the current editing session. DBMS_SQL and PLITBLM are used for dynamic SQL execution and PL/SQL table (index-by table) management, while DUAL supports scalar expression evaluation.

Usage Notes

PO_EXHIBITS_PVT is a private package and is not a supported public API. It is invoked internally by the Purchasing exhibit and CLM exhibit authoring forms and by the owning packages that manipulate draft exhibit data. Because the metadata indicates it is referenced by two other packages, customizations should not call it directly; the supported entry points remain the public exhibit APIs. Direct dependency on this package risks breakage across patches and upgrades, particularly given that the ELIN conversion functions reflect internal formatting rules rather than a published interface contract.