Search Results po_tbl_varchar240




Overview
Explore in AI Chat

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:

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.