Search Results p_from_employee

Overview

WIP_WIPSUEMP_XMLP_PKG is the PL/SQL package body behind the Oracle EBS Work in Process employee utilization or employee summary report, an XML Publisher (BI Publisher) concurrent program report. It belongs to the WIP module and is owned by APPS. The package serves as the report logic container: it supplies the runtime parameters, lookup values, dynamic SQL fragments, and report-level formatting formulas used by the associated XML Publisher data template and layout. Its role is to translate user-entered report parameters into query predicates and to populate report header values such as the concurrent request identifier and subtitle text.

The package is classified under ETRM as API classification OTHER, meaning it is not a public application programming interface but an internal helper unit supporting a concurrent program report. It references one registered table, FND_CURRENCIES, and is not referenced by any other package, which confirms its role as a top-level report driver rather than a shared library.

Key Procedures and Functions

• EMPLOYEE_TABLE — Returns the name of the employee view to be queried. When the current-only parameter is set, it returns the current employee view; otherwise it returns the general employees view. This allows the report to switch between current and historical employee records without changing the data template.
• LIMIT_EMPLOYEE — Builds a dynamic SQL predicate restricting results to a range of employee full names based on the from-employee and to-employee parameters. Values are quote-escaped before concatenation. The returned fragment is appended to the report query.
• LIMIT_DATES — Builds the dynamic SQL predicate that constrains the report by effective date. This is the function associated with the "limit_dates" search term. It compares the truncated effective date of the transaction table against the from-date and to-date parameters, converting each to a YYYYMMDD literal. Both dates produce a BETWEEN clause, a single from-date produces a greater-than-or-equal comparison, a single to-date produces a less-than-or-equal comparison, and no dates yields an empty fragment.
• BEFOREREPORT — Initialization function invoked before the report query executes. It captures the concurrent request identifier via FND_GLOBAL and performs initial setup for the report.
• AFTERREPORT — Cleanup function invoked after report generation completes.
• C_SUBTITLEFORMULA — Formula function that derives the subtitle text displayed on the report layout, typically reflecting the selected parameter ranges.
• AFTERPFORM — Post-formula function executed after the report parameter form is processed, used to finalize report-level values.

Tables Accessed

The only documented table referenced through APPS synonyms is FND_CURRENCIES, used to resolve currency information required by the report output. The dynamic SQL fragments returned by LIMIT_EMPLOYEE and LIMIT_DATES are applied against employee and work-in-process effective-date data, with the employee view name supplied by EMPLOYEE_TABLE. Because the report logic is XML Publisher based, the bulk of data retrieval occurs in the data template rather than in fixed package SQL.

Usage Notes

This package is invoked indirectly when the associated WIP XML Publisher concurrent program is submitted. Oracle EBS calls BEFOREREPORT before querying and AFTERREPORT afterward, while the formula functions are evaluated by the XML Publisher engine during layout. LIMIT_DATES and LIMIT_EMPLOYEE are called by the data template to inject parameter-driven predicates. The package is not intended for direct invocation from forms or custom code. Because it is classified as OTHER, it carries no supported API guarantee, and the header comment indicates it is marked noship, reflecting an internal, non-shipped helper object.