Search Results get_app_enable_flag




Overview
Explore in AI Chat

Overview

JTM_PROFILE_UTL_PKG is a utility package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the JTM (TeleSales / Field Service-related) product family and provides a centralized mechanism for querying profile option values that govern whether a given application or responsibility is "enabled" for a particular functional area. Rather than requiring callers to resolve application short names, responsibility identifiers, or responsibility keys and then query profile tables directly, the package exposes a small family of overloaded functions that abstract this logic.

The package is classified as an "OTHER" API, indicating it is an internal utility rather than a public, supported interface. Consistent with that classification, the source header carries the "noship" designation and contains an explicitly commented-out function, Get_app_level_profile_value, which was disabled to prevent accidental invocation by users. The package is referenced by fourteen other packages within the EBS codebase, confirming its role as a shared, low-level dependency for profile and enable-flag resolution.

Key Procedures and Functions

The documented metadata lists six callable units, all functions:

  • Get_app_level_profile_value — Intended to return the value of a profile option at the application level, given a profile name and an application short name. This function is commented out in the shipped source and is not callable.
  • Get_app_enable_flag (p_app_short_name) — Returns the enable flag for the application identified by its short name.
  • Get_app_enable_flag (p_resp_id, p_app_id) — Returns the enable flag for the application in the context of a specific responsibility, resolved by responsibility ID and application ID.
  • Get_enable_flag_at_resp (p_resp_id, p_app_short_name) — Returns the enable flag at responsibility level, identified by responsibility ID and application short name.
  • Get_enable_flag_at_resp (p_resp_key, p_app_short_name) — Returns the enable flag at responsibility level, identified by responsibility key and application short name.
  • Get_enable_flag_at_resp (p_app_short_name) — Returns the enable flag at responsibility level for the current session context, given only the application short name.

The overloads allow callers to supply whichever identifier they hold (short name, ID, or key) without additional lookups.

Tables Accessed

Through APPS synonyms, the package references two Oracle EBS foundation tables:

  • FND_APPLICATION — Used to resolve application short names to application IDs and related attributes when evaluating the application-level enable flag.
  • FND_RESPONSIBILITY — Used to resolve responsibility identifiers and responsibility keys, and to determine the application context under which a responsibility operates.

These reads supply the keys required to locate the relevant profile option values governing enablement.

Usage Notes

JTM_PROFILE_UTL_PKG is an internal utility invoked programmatically rather than by end users directly. It is typically called from within other PL/SQL packages — the fourteen dependent packages — and from forms or concurrent programs that must determine whether an application or responsibility is enabled before presenting or processing functionality. Callers should treat these functions as read-only lookups. Because the package is marked "OTHER" and ships as noship, customizations should avoid depending on it where a supported public API exists, and any direct use should be validated against the specific EBS release (12.1.1 or 12.2.2) in use.