Search Results jtf_prefab_policy_pub




Overview
Explore in AI Chat

Overview

APPS.JTF_PREFAB_POLICY_PUB is a public PL/SQL API package that belongs to the Oracle E-Business Suite CRM Foundation (JTF) module, specifically the "Preference Fabric" (PREFAB) functional area. The package encapsulates the business logic used to create, maintain, and delete user preference policies and system administrator policies that govern how Oracle EBS applications resolve and apply user-entered preferences. In EBS 12.1.1 and 12.2.2, the dependency metadata confirms the package is VALID and its API is classified as type PUB, meaning it is intended for use by external callers such as forms, concurrent programs, and custom extensions rather than being reserved for internal component use. The package follows the standard EBS API pattern, delegating error handling to FND_API, and works against the JTF_PREFAB_* tables and their APPS synonyms to persist policy definitions and workspace-specific policy variations.

Key Procedures and Functions

The documented API surface exposes thirteen procedures and functions grouped by the type of policy they manage, each corresponding to a defined transactions workflow within the preference framework:

  • Core policy operations — INSERT_POLICY, UPDATE_POLICY, and DELETE_POLICY create, modify, and remove entries in the base policy tables. These are the entry points used when defining or retiring a preference policy definition.
  • User-role policy operations — INSERT_UR_POLICY and DELETE_UR_POLICY manage policy assignments that are scoped to a specific user-role combination, allowing different preference behavior for different audiences.
  • System policy configuration — CONFIGURE_SYS_POLICY sets up system-level policy behavior, capturing the seed configuration that controls default preference resolution across the suite.
  • Workforce Scheduler (WSH) policy operations — INSERT_WSH_POLICY, UPDATE_WSH_POLICY, and DELETE_WSH_POLICY manage policies tied to specific WSH process definitions stored in the POEs (_B/_TL) tables.
  • WSH policy association operations — INSERT_WSHP_POLICY and DELETE_WSHP_POLICY link a WSH policy to the appropriate workspace or user context represented by JTF_PREFAB_WSHP_POLICIES.

No parameter lists are published in the metadata; callers should obtain signatures from the deployed package source or the API documentation shipped with the JTF module.

Tables Accessed

The package reads and writes a defined set of preference tables via APPS synonyms:

  • JTF_PREFAB_POLICIES_B and JTF_PREFAB_POLICIES_TL — the base and translation tables holding policy headers and their language-dependent names/descriptions.
  • JTF_PREFAB_SYS_POLICIES — stores system-level policy configuration produced by CONFIGURE_SYS_POLICY.
  • JTF_PREFAB_UR_POLICIES — stores user/role-scoped policy assignments.
  • JTF_PREFAB_WSH_POES_B and JTF_PREFAB_WSH_POES_TL — store the Workforce Scheduler policy entities in base/translated form.
  • JTF_PREFAB_WSHP_POLICIES — links WSH policies to workspace contexts.
  • The corresponding _S sequence-backed synonyms provide the primary-key values used during insert operations, while DUAL is referenced for standard PL/SQL selector queries.

Usage Notes

JTF_PREFAB_POLICY_PUB is typically invoked from preference administration forms within the JTF Setup responsibility, from concurrent programs that bulk-load or refresh policy definitions during implementation, and from custom PL/SQL extensions that need to seed or migrate preference policy data. The metadata shows it is referenced by no other packages, confirming it is a top-level public API rather than a shared internal helper. Because it depends directly on FND_API, callers should treat it as an error-handled EBS API: check the returned status before committing, and avoid issuing DML against the underlying JTF_PREFAB_* tables directly, as the package maintains the proper base/translation and policy-type consistency across the seven tables listed above.