Search Results ahl_rm_asso_docaso_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_RM_ASSO_DOCASO_PVT is a private PL/SQL package within the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, belonging to the AHL schema family associated with Oracle Complex Maintenance, Repair, and Overhaul (CMRO) and Enterprise Asset Management documentation features. The package name resolves to "AHL Routing Management Association Document Association," indicating its role in managing the relationships between routing or asset objects and the documents associated with them. The AUTHID CURRENT_USER declaration confirms that the package executes with the privileges of the invoking user, and the source header (AHLVRODS.pls, version 120.0, dated 2005) indicates the object originated in an early release and has been carried forward through successive EBS versions with the API classification of "PVT" — a private or internal package not intended for direct customer invocation.

The package centers on a record structure, doc_association_rec, and a corresponding PL/SQL table type, doc_association_tbl, which together define the payload used to represent document-to-object associations. Fields such as DOC_TITLE_ASSO_ID, DOCUMENT_ID, DOC_REVISION_ID, USE_LATEST_REV_FLAG, OBJECT_TYPE_CODE, and OBJECT_ID describe a document association in full, including revision control, object type categorization, chapter/section/subject/page references, and a DML_OPERATION flag that signals whether the record is to be inserted, updated, or deleted. The inclusion of fifteen descriptive flexfield attribute columns confirms the package participates in the standard EBS extensibility model.

Key Procedures and Functions

The documented metadata lists a single procedure:

  • PROCESS_ASSOCIATION — Annotated in the source as "Private," this procedure is the core processing routine of the package. It accepts the standard EBS API parameter conventions: p_api_version, p_init_msg_list, p_commit, p_validation_level, p_default, and p_module_type, and returns the standard x_return_status and x_msg_count outputs. It processes the association records supplied through the doc_association_tbl collection, applying the indicated DML operation and performing validation according to the requested validation level.

Tables Accessed

According to the documented metadata, the package references the following tables through APPS synonyms:

  • AHL_OPERATIONS_B — The base table for operations defined within AHL routing structures; used to validate or resolve object references for document associations tied to operations.
  • AHL_ROUTES_B — The base table for routing headers; accessed to support associations where the target object is a routing.
  • PLITBLM — A standard Oracle Applications error-stack/message table used to store and retrieve API message context.

The metadata records no other table dependencies, reflecting the package's narrow, private scope.

Usage Notes

Because this package is classified as PVT, it is not part of the public Oracle EBS API surface and should not be invoked directly from custom code. It is referenced by three other packages, indicating that it functions as a subordinate worker routine called by higher-level document association APIs or by the CMRO forms layer when users create, modify, or remove document links against routings and operations. Typical invocation occurs during form save processing or when a private API flow needs a reusable, validation-aware routine for persisting document associations. Any custom development requiring similar functionality should call the documented public AHL document association APIs rather than AHL_RM_ASSO_DOCASO_PVT, and any analysis of failures in this area should treat this object as an internal dependency of the routing management documentation feature.