Search Results update_associations_concurrent

Overview

APPS.AHL_DI_DOC_REVISION_PVT is a private PL/SQL API package within the Oracle E-Business Suite Discrete Manufacturing / Enterprise Asset Management product family (AHL schema). It encapsulates the business logic governing document revisions in Oracle Product Information Management / Manufacturing Execution System (MES) contexts. In EBS 12.1.1 and 12.2.2, AHL tables support the documentation and revision control infrastructure used by shop-floor operators, quality engineers, and engineering change personnel to associate controlled documents — drawings, specifications, work instructions — with manufacturing entities such as work orders, routing operations, and production headers.

The package is designated as a PVT (private) API, meaning it is not intended for direct external invocation. It is consumed by public wrapper APIs and concurrent programs that handle the transactional lifecycle of a document revision: creation, modification, deletion, and association updates. Its AUTHID CURRENT_USER declaration ensures that privilege checking occurs against the calling schema, a standard Oracle Applications security practice.

Key Procedures and Functions

• CREATE_REVISION — Inserts a new revision record for a document. The package defines a revision_rec record type carrying revision number, revision type and status codes, approval and effective dates, obsolete and issue dates, media type, URL, volume/issue data, language attributes, and the standard 15 DFF attribute columns. It also declares a revision_tbl table type indexed by BINARY_INTEGER for bulk processing.
• MODIFY_REVISION — Updates an existing revision record, applying the same attribute set defined in revision_rec, including object version number for optimistic locking.
• DELETE_REVISION — Logically or physically removes a revision; DELETE_FLAG in the record type supports soft-delete semantics.
• UPDATE_ASSOCIATIONS_CONCURRENT — The procedure matching the user search term. It reconciles document-to-entity associations (titles, headers, relationships) in batch, and is designed to be invoked from a concurrent program rather than interactive forms, given the "_CONCURRENT" suffix.

Tables Accessed

The package references via APPS synonyms:

• AHL_DOCUMENTS_B — the document master, parent of revisions.
• AHL_DOC_REVISIONS_B / _B_S / _TL — base, secondary, and translation tables for revision records.
• AHL_DOC_TITLE_ASSOS_B — title-level associations that UPDATE_ASSOCIATIONS_CONCURRENT reconciles.
• AHL_MC_HEADERS_B, AHL_MC_RELATIONSHIPS, AHL_MR_HEADERS_B — manufacturing and maintenance header/relationship entities tied to documents.
• AHL_OPERATIONS_B, AHL_PC_HEADERS_B, AHL_PC_NODES_B, AHL_ROUTES_B — routing, operation, and process-construction structures that carry document references.
• DUAL and PLITBLM — standard utility objects (PLITBLM supports PL/SQL table manipulation).

Usage Notes

AHL_DI_DOC_REVISION_PVT is invoked indirectly. Public AHL APIs such as AHL_DI_DOCUMENT_PUB call into this private layer to enforce validation, DFF handling, and multi-table consistency. Update_associations_concurrent is typically scheduled as a concurrent request when documents are attached or detached en masse — during engineering change implementation, document migration, or revision rollout across many routings and work orders. Because three other packages reference this one, customizations should not call it directly; instead, invoke the corresponding public API to preserve upgrade safety across 12.1.1 and 12.2.2.