Search Results jtm_hook_util_pkg




Overview
Explore in AI Chat

Overview

APPS.JTM_HOOK_UTIL_PKG is a utility package body in the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 environments. It belongs to the Oracle TeleSales / Sales for Handhelds (JTM) product family, which manages mobile sales and field service synchronization for handheld devices. The package provides the shared plumbing that the JTM hook framework relies on: resolving the current application user, reading profile option values, retrieving the resource record associated with a user, and maintaining the mobile account download tables.

The object is documented in the ETRM with an API classification of OTHER, indicating it is an internal, non-public utility package rather than a published integration API. Its status is VALID. It is referenced by 61 other database objects, reflecting its role as a low-level service package used throughout the JTM hook and synchronization code paths.

Key Procedures and Functions

Twelve procedures and functions are documented for this package. The named members include:

  • GET_DEBUG_LEVEL — Returns the current debugging verbosity applicable to the JTM hook layer, allowing callers to conditionally emit diagnostic messages through the message log package.
  • THAT — A short internal helper member included in the documented interface.
  • GET_RESOURCE_ID — Resolves and returns the resource identifier associated with the current user, bridging FND_USER records to the JTF resource model.
  • UPDATE_ACC — Updates account-related download records, typically used when account data must be refreshed or re-flagged for synchronization to the handheld.
  • DELETE_ACC — Removes account download records, used to purge or de-scope accounts from the mobile download set.

Additional documented members follow the same conventions: user and resource resolution, profile option lookups, and account download maintenance. No parameter lists are reproduced here; the ETRM documents only names and purpose.

Tables Accessed

The package operates against the following objects, referenced through APPS synonyms and dependencies: ASG_USER and ASG_USER_PUB_RESPS, which hold the assignment of users to resources and public responsibilities; FND_USER for application user records; FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES for profile option lookups; and JTF_RS_RESOURCE_EXTNS for the extended resource attributes used to derive the current resource identifier. The account update and delete routines operate on the mobile account download tables exposed by the JTM synchronization layer.

Supporting dependencies include FND_GLOBAL for session context, JTM_MESSAGE_LOG_PKG for logging, DBMS_SQL for dynamic SQL execution, and PLITBLM for index-by-table constructs. These dependencies confirm the package performs runtime profile lookups and dynamic statement execution rather than pure static SQL.

Usage Notes

JTM_HOOK_UTIL_PKG is invoked indirectly. Because the ETRM shows it is referenced by 61 other packages but references no external caller itself, it is a service layer consumed by the JTM hook packages, concurrent programs that publish account and resource data to handheld devices, and customizations extending the Sales for Handhelds synchronization flow. It is not normally called directly from forms or from customer-written code.

Custom implementations that require the current mobile resource, the effective debug level, or controlled manipulation of the account download set may call these members, but they should be treated as internal. Oracle does not guarantee their signatures across patches. Any extension should therefore be wrapped in a defensive wrapper and validated against each target release, particularly when moving from 12.1.1 to 12.2.2.