Search Results po_entity_locks_s

Overview

APPS.PO_CLM_UPG_PVT is a private (PVT-classified) PL/SQL package body belonging to the Oracle Purchasing module. Its header identifies it as part of the PO_CLM — "Purchasing Contract Lifecycle Management" — upgrade path, introduced to support the Oracle E-Business Suite 12.2.2 contract terms and document styles functionality. The package provides utility routines that assist contract-related upgrade and concurrent processing logic, in particular the reconciliation of primary-key collections gathered from different sources during upgrade runs. Because it is classified as private, it is not a published integration API; it is invoked internally by other Purchasing packages rather than by customer code. The name references PO_TBL_VARCHAR240, a shared collection type used throughout the PO schema to carry 240-character identifier values such as ENTITY_PK1/2/3 keys.

Key Procedures and Functions

The body exposes a small set of helper programs plus one documented procedure:

• merge_tbl_varchar240 — Accepts two PO_TBL_VARCHAR240 collections and returns their UNION ALL, using BULK COLLECT into a locally instantiated collection. It is used to combine entity primary keys held in staging tables with keys from the live tables during upgrade reconciliation.
• merge_tbl_varchar30 — The same UNION ALL merge pattern applied to PO_TBL_VARCHAR30 collections, which carry shorter identifiers (entity names, style identifiers, and similar values).
• ENABLE_CONC_MOD — The single procedure listed in the documented procedure inventory. It is associated with the concurrent (concurrent-program) modification path for contract document styles; its role is to enable the concurrent modification handling so that contract style and terms changes can be processed through the concurrent manager rather than the online form.
• lock_attachments — Introduced by Bug 13938456 to create attachment-level locks, taking entity name, draft identifier, and PK1/PK2/PK3 collections as inputs so that draft and base attachments are serialized during upgrade.

Tables Accessed

The package touches the core Purchasing contract model, both the transactional and the draft (12.2.2) variants:

• PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL — the base purchasing document hierarchy, read to resolve and lock document structures during upgrade.
• PO_HEADERS_DRAFT_ALL, PO_LINES_DRAFT_ALL, PO_LINE_LOCATIONS_DRAFT_ALL, PO_DISTRIBUTIONS_DRAFT_ALL, PO_DRAFTS — the draft tables introduced for the 12.2.2 contracts and document-style feature; the package merges draft keys with base keys and applies concurrent modification logic here.
• EGO_FND_DSC_FLX_CTX_EXT and PO_DOC_STYLE_HEADERS — document-style definition and descriptive-flexfield context extension data that drive style-based contract processing.
• PO_ENTITY_LOCKS and PO_ENTITY_LOCKS_S — the entity lock table and sequence used by the locking routines to prevent concurrent edits of the same contract entity or attachment.
• FND_ATTACHED_DOCUMENTS — the attachment repository, locked and examined to keep contract attachments consistent during upgrade.

Usage Notes

PO_CLM_UPG_PVT is invoked internally, primarily from a single dependent Purchasing package and from the upgrade driver that migrates existing contracts into the 12.2.2 document-style and draft model. It is not intended for direct calls from forms or custom code, and no public API grant is expected. Upgrade administrators encounter it indirectly through the standard AD upgrade and patch cycles; lock-related errors raised by ENABLE_CONC_MOD or lock_attachments generally surface during contract-term upgrade runs. In 12.1.1 the draft-object logic is absent, so the package is only meaningful where the 12.2.2 contracts schema is installed. Any diagnostic work should first confirm the file version header ($Header: PO_CLM_UPG_PVT.plb 120.8.12020000.3) to ensure the correct 12.2.2 code level is deployed.