Search Results create_resource_post

Overview

APPS.AMS_ACTRESOURCE_VUHK is a PL/SQL package in the Oracle E-Business Suite (EBS) Applications schema, associated with the Oracle Marketing (AMS) product family. The suffix "VUHK" designates this package as a view-level or user-hook style companion to the public API package AMS_ACTRESOURCE_PUB, which governs the creation, maintenance, and lifecycle management of marketing resources (act resources) within the EBS data model. The package is valid in both Oracle EBS 12.1.1 and 12.2.2.

Functionally, AMS_ACTRESOURCE_VUHK encapsulates a set of pre- and post-processing hooks that surround the core business logic executed by AMS_ACTRESOURCE_PUB. Its principal role is to provide extensibility and validation checkpoints at each stage of the resource lifecycle, allowing standard behavior to be intercepted, augmented, or validated without modifying the public API itself. This pattern is characteristic of EBS "VUHK" (validation/user hook) packages, which serve as controlled extension points for customer-specific or product-specific logic.

The documented dependency analysis confirms a bidirectional relationship with AMS_ACTRESOURCE_PUB: AMS_ACTRESOURCE_VUHK references AMS_ACTRESOURCE_PUB, and AMS_ACTRESOURCE_VUHK is in turn referenced by AMS_ACTRESOURCE_PUB. This mutual dependency reflects the hook architecture, where the public API invokes the hook package at defined points, and the hook package may call back into the public API for convenience operations.

Key Procedures and Functions

The ETRM metadata documents ten procedures, organized as five pre/post pairs corresponding to the primary resource operations:

• CREATE_RESOURCE_PRE — Executes before a resource creation operation, providing a hook for pre-creation validation or defaulting.
• CREATE_RESOURCE_POST — Executes after resource creation, allowing supplementary processing once the resource record exists.
• UPDATE_RESOURCE_PRE — Runs prior to a resource update, supporting pre-update validation or preparation logic.
• UPDATE_RESOURCE_POST — Runs following a resource update, enabling post-update side effects or auditing.
• DELETE_RESOURCE_PRE — Invoked before resource deletion, used to validate deletion eligibility or capture pre-delete state.
• DELETE_RESOURCE_POST — Invoked after deletion, supporting cleanup or downstream synchronization.
• LOCK_RESOURCE_PRE — Executes before a resource lock operation, providing a validation checkpoint.
• LOCK_RESOURCE_POST — Executes after locking, allowing post-lock processing.
• VALIDATE_RESOURCE_PRE — Runs before resource validation, supporting pre-validation consistency checks.
• VALIDATE_RESOURCE_POST — Runs after validation, permitting post-validation handling.

No parameter lists are documented in the ETRM metadata; the procedures are identified by name and lifecycle position only.

Tables Accessed

The ETRM metadata for AMS_ACTRESOURCE_VUHK does not enumerate any directly referenced tables via APPS synonyms. The dependency information lists only the package AMS_ACTRESOURCE_PUB and the SYS.STANDARD package as referenced objects. Because the hook package operates in coordination with AMS_ACTRESOURCE_PUB, any persistent data access to marketing resource tables occurs indirectly through the public API rather than through direct DML in the hook package. This design keeps the hook layer decoupled from the underlying schema and consistent with EBS extension best practices.

Usage Notes

AMS_ACTRESOURCE_VUHK is not intended to be invoked directly by end users or custom code. Instead, it is called internally by AMS_ACTRESOURCE_PUB at the appropriate pre- and post-processing points during the resource lifecycle, whether those operations originate from Oracle Marketing forms, concurrent programs, or other programmatic callers of the public API. The reciprocal dependency between the two packages confirms this invocation model.

Because only one other package references this object (AMS_ACTRESOURCE_PUB), its scope is deliberately narrow and tightly coupled to the public resource API. Customers and integrators seeking to customize resource behavior should extend or replace the VUHK hook logic rather than modifying AMS_ACTRESOURCE_PUB directly, preserving supportability across EBS 12.1.1 and 12.2.2.