Search Results jtf_user_hooks_s

Overview

APPS.JTF_HOOK_DATA_PUB is a public PL/SQL package body in the Oracle E-Business Suite Applications schema that supports the CRM Foundation (JTF) user hook framework. Its role is to persist and manage the data associated with application-defined hooks — the extensibility mechanism that allows business events to trigger custom logic without modifying Oracle-supplied code. The package is a dependent component layered on top of the JTF_HOOKS_DATA and JTF_USER_HOOKS_S objects, providing a controlled, API-based path for inserting hook records rather than permitting direct DML against the underlying tables. In Oracle EBS 12.1.1 and 12.2.2 the package carries a status of VALID and is classified as a public (PUB) API, indicating it is intended for invocation from other application code and from customer extensions.

Key Procedures and Functions

The ETRM metadata documents a single public procedure for this package:

• JTF_HOOK_DATA_PUB_INSERT — The documented entry point for creating a new hook data record. It encapsulates the insert logic against the hook data structures, applying the package's internal validation and message-handling conventions (via FND_MSG_PUB) so that callers receive standardized error reporting. Parameter lists are not enumerated in the available metadata and should be confirmed against the installed package specification in the target environment.

The package body references FND_API and FND_GLOBAL, which indicates that the procedure follows Oracle's standard API design conventions: a returned status value, message-stack integration, and use of FND_GLOBAL for session context such as user and responsibility identifiers. These dependencies are documented but the internal private routines are not exposed as public interfaces.

Tables Accessed

Two application tables are documented as being referenced through APPS synonyms:

• JTF_HOOKS_DATA — The principal data store for hook definitions and associated attributes. The insert procedure writes to this object.
• JTF_USER_HOOKS_S — A sequence used to supply primary key values for newly created hook data records. The "_S" suffix identifies it as a sequence, and its presence confirms that the insert path generates surrogate keys internally.

The dependency list also shows a self-reference to JTF_HOOK_DATA_PUB and the standard SYS objects DUAL and STANDARD, which is typical of a compiled, validated package body.

Usage Notes

JTF_HOOK_DATA_PUB is a server-side API. It is not exposed directly through a form or concurrent program in the documented metadata, and the ETRM report records that it is not referenced by any other database object. This has two practical implications. First, the package functions as a leaf dependency: Oracle-supplied code does not call it, so invocation originates from customer-written extensions, wrappers, or integration scripts rather than from the standard EBS product flows. Second, because it is a PUB API, customers may call it from their own PL/SQL packages during hook registration or setup. The search term "jtf_user_hooks_s" points to the sequence that the package consumes; administrators investigating the sequence will find this package as its primary consumer. As with any Oracle public API, direct DML against JTF_HOOKS_DATA and JTF_USER_HOOKS_S should be avoided in favour of this package so that validation and key generation remain consistent.