Search Results create_references_pre




Overview
Explore in AI Chat

Overview

JTF_TASK_REFERENCES_IUHK is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Task Manager (JTF) module, specifically the maintenance of task references. Its role is to provide the pre-event and post-event handler logic that surrounds the Create, Update, and Delete operations performed against task reference records by the public API. The package is declared AUTHID CURRENT_USER, meaning that its procedures execute with the privileges of the invoking user rather than as the definer. This is a characteristic design pattern of the "IUHK" (Insert/Update/Delete Handler Kit) family of packages in EBS, which exist to allow customers and integrators to inject custom business logic at defined points in the transaction lifecycle without modifying seeded Oracle code.

Key Procedures and Functions

The package exposes six documented procedures, organized as three pairs of pre- and post-operation hooks. Each accepts the references record structure (jtf_task_references_pub.references_rec) and returns a status indicator, allowing the hook to signal success or failure back to the calling API.

  • CREATE_REFERENCES_PRE — Executes before a task reference is created. Intended for validation or setup logic that must complete prior to the insert.
  • CREATE_REFERENCES_POST — Executes after a task reference has been created. The procedure most frequently referenced by the search term "create_references_post," it is the standard extension point for custom post-insert processing.
  • UPDATE_REFERENCES_PRE — Executes before an existing task reference is modified, allowing pre-update validation.
  • UPDATE_REFERENCES_POST — Executes after the update has been applied.
  • DELETE_REFERENCES_PRE — Executes before a task reference is deleted, permitting dependency checks or archival logic.
  • DELETE_REFERENCES_POST — Executes after the delete is committed at the API layer.

Tables Accessed

The documented metadata exposes no direct table references through APPS synonyms; the package is designed to receive its data through the record parameter rather than by querying base tables itself. The underlying persistent structure is the task reference entity managed by the JTF_TASK_REFERENCES public API and its associated publication package, jtf_task_references_pub. Because the procedures are handlers, the primary table manipulation is performed by the public API and its underlying table handlers, not by this package. Custom implementations that extend the seeded handler body typically reference JTF task tables directly, but such references are not part of the delivered metadata.

Usage Notes

This package is not invoked directly by end users. It is called by the JTF Task Manager public API layer as part of the standard Create, Update, and Delete flow for task references. In a default installation the handler bodies are effectively empty stubs; the package exists as a formally exposed extension point. Developers customizing or extending Oracle EBS typically replace the stub bodies — most commonly CREATE_REFERENCES_POST — with their own PL/SQL to trigger notifications, write audit records, or synchronize external systems when a task reference is inserted. The AUTHID CURRENT_USER declaration means that any custom code placed inside these procedures runs under the calling user's privilege set, so appropriate grants on any additionally referenced objects must be in place. The package is documented under ETRM 12.2.2 and remains applicable across the 12.1.1 and 12.2.2 releases, and the referenced-by count of zero confirms that no other seeded package depends on it, making customization of its handler bodies comparatively low-risk.