Search Results elin_to_decimal

Overview

PO_EXHIBITS_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Purchasing (PO) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It implements the internal application programming interface that supports Exhibit Line Numbers (ELINs) and exhibit management for purchasing documents. The package header carries the identifier $Header: PO_EXHIBITS_PVT.pls 120.2.12020000.4 2013/03/05 11:59:16 mabaig noship $, indicating it was delivered as part of the Contract Lifecycle Management (CLM) Phase 4 — "Elins project" rollout, and is a non-shippable internal module not intended for direct customer invocation.

The package's principal business responsibility is to convert, assign, and manage ELINs — the structured line numbering scheme applied to exhibits attached to purchasing documents and contract deliverables. It also provides the draft-to-transaction synchronization logic that allows exhibit content to be staged in draft tables before being merged into the base exhibit tables. Because it is classified as PVT, the package is intended to be called only by other Oracle-delivered packages rather than by external customizations. The metadata records that it is referenced by two other packages, confirming its role as a supporting utility layer.

The package declares the exception ELIN_NUMBERS_EXHAUSTED, raised when the available ELIN space for a given exhibit has been fully consumed.

Key Procedures and Functions

A total of 17 documented procedures and functions are exposed by the package. The first group performs ELIN arithmetic and allocation:

• ELIN_TO_DECIMAL — Converts a VARCHAR2 ELIN representation into its numeric decimal equivalent, allowing the character-based exhibit line number to be sorted, compared, and incremented arithmetically. Documented as internal to the Elins project.
• DECIMAL_TO_ELIN — Performs the inverse conversion, translating a numeric decimal value back into a valid formatted ELIN string.
• NEXT_ELIN_NUM — Returns the next eligible ELIN for a given exhibit of a document, taking a set of already-assigned line numbers, a document header identifier, and an exhibit name as inputs.
• GET_NEXT_EXHIBIT — Retrieves the next exhibit context for continued ELIN processing.

A second group manages draft and transaction record consistency:

• LOCK_DRAFT_RECORD and LOCK_TRANSACTION_RECORD — Acquire row-level locks on draft and committed exhibit records respectively, preventing concurrent modification during an update cycle.
• SYNC_DRAFT_FROM_TXN — Refreshes draft records from the underlying transaction records.
• DRAFT_CHANGES_EXIST — Determines whether pending draft changes are present.
• MERGE_CHANGES and APPLY_CHANGES — Apply accumulated draft modifications to the base exhibit data.
• DELETE_ROWS, INSERT_EXHIBITS, and DELETE_EXHIBITS — Maintain exhibit rows in bulk.
• COPY_CDRL_EXHIBIT and DELETE_CDRLS_FOR_EXHIBIT — Copy and remove Contract Data Requirements List content associated with an exhibit.

Tables Accessed

The package reads and writes the following objects, accessed through APPS synonyms:

• PO_EXHIBIT_DETAILS, PO_EXHIBIT_DETAILS_S, and PO_EXHIBIT_DETAILS_DRAFT — the base, sequence, and draft exhibit detail tables that hold ELIN rows and staged changes.
• PO_DRAFTS — the draft container that groups pending modifications before merge.
• PO_SESSION_GT — a global temporary table used to hold session-scoped working data.
• FND_LOOKUP_VALUES — supplies lookup-driven validation and display values.
• DUAL, DBMS_SQL, and PLITBLM — utility constructs supporting scalar expressions, dynamic SQL, and PL/SQL table manipulation.

Usage Notes

PO_EXHIBITS_PVT is invoked indirectly by Oracle Purchasing forms and concurrent programs that create, edit, or copy exhibits and their ELINs; the metadata confirms it is referenced by two other packages. Because it is a PVT API, direct calls from custom code are unsupported, and any integration should use the corresponding public (PUB) interfaces. The ELIN_TO_DECIMAL and DECIMAL_TO_ELIN pair is of particular interest when querying exhibit data, since ELINs are stored as character strings and must be converted for numeric ordering. All behavior described applies to Oracle EBS 12.1.1 and 12.2.2.