Search Results get_valid_date

Overview

BEN_CWB_PL_DSGN_PKG is an Oracle EBS Advanced Benefits (OLTP) package that supports the Compensation Workbench (CWB) design and configuration layer. Specifically, it maintains the design-time definition of plan designs that underpin the Compensation Workbench enrollment and worksheet processes. The package belongs to the Benefits module (product prefix BEN) and is owned by APPS. ETRM classifies it as an OTHER API object, indicating it is an internal implementation package rather than a public, supported interface for external extensions.

The source header indicates a build level of bencwbpl.pkb 120.3.12010000.2, dated 2010, consistent with the 12.1.1 release line and carried forward into 12.2.2. The body employs standard EBS technical constructs: a private global package name constant (g_package), a debug flag derived from hr_utility.debug_enabled, and hr_utility.set_location instrumentation at defined step values for trace diagnosis. These conventions confirm the package is intended for controlled, internal invocation within the Benefits engine rather than direct end-user or third-party consumption.

Key Procedures and Functions

The documented interface exposes four procedures and functions:

• GET_ACTUAL_FLAG — Retrieves the actual (versus estimated or planned) indicator associated with compensation data processed during the plan design logic. This flag governs whether the engine treats underlying amounts as committed actuals or as projections.
• GET_EXCHG_RATE — Returns the currency exchange rate required to normalize monetary amounts into a consistent reporting currency, drawing on standard Oracle currency definitions.
• REFRESH_PL_DSGN — The principal maintenance routine. It rebuilds or re-evaluates plan design data, including the ordering of options within a group plan. The internal helper get_opt_ordr_in_grp, visible in the source excerpt, supports this by resolving the order number of an option within its parent group using the cached collection g_grp_opt.
• DELETE_PL_DSGN — Removes plan design records that are no longer required, supporting housekeeping and reconfiguration of Compensation Workbench plan structures.

Tables Accessed

The package touches a focused set of Benefits configuration and transaction tables via APPS synonyms:

• BEN_CWB_PL_DSGN and BEN_PL_EXTRA_INFO — The primary plan design repository and its supplementary attribute store.
• BEN_PL_F, BEN_OIPL_F, BEN_OPT_F — Plan, plan-in-organization, and option definitions that define the design hierarchy.
• BEN_ACTY_BASE_RT_F — Activity base rates used in compensation calculations.
• BEN_CWB_PERSON_INFO — Person-level Compensation Workbench data.
• BEN_ENRT_PERD, BEN_WTHN_YR_PERD, BEN_YR_PERD, BEN_POPL_ENRT_TYP_CYCL_F — Enrollment period, within-year period, year period, and enrollment-type cycle definitions that bound the validity of design records.
• FND_CURRENCIES and DUAL — Currency definitions supporting exchange-rate retrieval.
• PLITBLM — The standard EBS PL/SQL table-handling structure.

Usage Notes

BEN_CWB_PL_DSGN_PKG is invoked internally by the Compensation Workbench plan design workflow, typically triggered from Benefits configuration forms or from concurrent processes that compile and maintain plan design definitions. ETRM records five other packages referencing it, confirming it sits beneath a higher-level orchestration layer rather than acting as a top-level entry point. It is not a documented public API; custom code should not call it directly. A search for "get_valid_date" does not correspond to any documented routine in this package — validity dates are implied through the period tables (BEN_ENRT_PERD, BEN_YR_PERD, BEN_WTHN_YR_PERD) that the package reads. Any need for a valid-date calculation should be met through supported date-effective APIs rather than this internal body.