Search Results get_mr_status

Overview

APPS.AHL_DI_DOC_REVISION_PVT is a private PL/SQL package body within the Oracle EBS Product Lifecycle Management (PLM) / Asset Lifecycle Management (AHL) module, specifically belonging to the Discrete Information (DI) document revision subsystem. The package encapsulates the business logic responsible for creating, modifying, deleting, and associating revisions of controlled documents such as engineering drawings, specifications, and media-controlled collateral managed through AHL_DOCUMENTS_B and its supporting entities. Because it is classified as a private (PVT) package, it is not intended to be invoked directly by external applications; instead, it is consumed internally by the corresponding public API wrapper and by other AHL packages that administer document revision lifecycles.

The package provides the transactional core that validates revision metadata before persistence, enforces lookup-based domain integrity on revision type, revision status, and media type codes, and coordinates the cascade of associated child records such as title associations, media headers, route headers, operation headers, and production change nodes. The revision record itself is maintained across a base table plus a seed (surrogate key) table and a translation table to support multi-language document titles.

Key Procedures and Functions

• CREATE_REVISION — Inserts a new document revision, performing pre-insert validation of revision number, revision type code, revision status code, media type code, approval party, and date attributes (revision, approved, effective, obsolete, issue, and received dates) before writing to the revision tables. This is the procedure most commonly associated with the search term create_revision.
• MODIFY_REVISION — Applies updates to an existing document revision, re-executing the same validation rules to preserve data integrity across changes to status, approval, and date fields.
• DELETE_REVISION — Handles logical or physical removal of a revision record, respecting the delete-flag convention used throughout the AHL document schema.
• UPDATE_ASSOCIATIONS_CONCURRENT — A concurrent, set-based routine that propagates revision changes to dependent association tables, ensuring title associations and related structures remain synchronized with the parent revision.

A private validation helper, VALIDATE_REVISION, underpins the insert and modify paths. It relies on FND_LOOKUP_VALUES_VL cursors to confirm that revision type, revision status, and media type codes are valid and currently active in the AHL_REVISION_TYPE, AHL_REVISION_STATUS_TYPE, and media type lookup types, respectively.

Tables Accessed

• AHL_DOCUMENTS_B — Parent document master; revisions are always scoped to a document.
• AHL_DOC_REVISIONS_B, AHL_DOC_REVISIONS_B_S, AHL_DOC_REVISIONS_TL — Base revision record, surrogate/seed key generation, and translated title attributes.
• AHL_DOC_TITLE_ASSOS_B — Title-to-document associations updated during association synchronization.
• AHL_MC_HEADERS_B, AHL_MC_RELATIONSHIPS, AHL_MR_HEADERS_B — Media control headers and relationships tied to revisions.
• AHL_OPERATIONS_B, AHL_ROUTES_B, AHL_PC_HEADERS_B, AHL_PC_NODES_B — Routing, operation, and production change structures that reference or depend upon document revisions.
• DUAL and PLITBLM — Used for scalar lookups and PL/SQL index-by-table PLITBLM constructs.

Usage Notes

AHL_DI_DOC_REVISION_PVT is invoked indirectly through the public document revision API and AHL application forms, and it is referenced by three other AHL packages. It should not be called directly from custom code; developers requiring revision creation or modification should use the corresponding public package wrapper, which supplies validation, security, and audit context. Concurrent invocation of UPDATE_ASSOCIATIONS_CONCURRENT is typically performed by scheduled concurrent programs following bulk revision maintenance.