Search Results cf_period_nameformula

Overview

PAY_PYKRSSEL_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under Oracle's ETRM metadata as an "OTHER" API. Its naming convention—the _XMLP_PKG suffix combined with the underlying PYKRSSELS.pls source—identifies it as the server-side implementation package generated for an Oracle XML Publisher (BI Publisher) concurrent program report in the Oracle Payroll module. The package declares the report's bind parameters, PL/SQL formula (group) functions, and report-level event handlers required by the Oracle Reports/XML Publisher run-time architecture.

The report is a payroll selection listing. Its parameter set—business group, concurrent request ID, selection criteria, selection date, summary/detail indicator, parameter name/value, period name, and payroll identifier—confirms that the report is driven by user-supplied selection criteria over payroll data within a chosen business group and time period. This matches the user's interest in cf_period_nameformula, which governs how the period name is derived and displayed on the report output.

Key Procedures and Functions

• BeforeReport — Standard report trigger that executes prior to data retrieval; used here for report initialization.
• AfterReport — Post-processing trigger executed after report completion.
• AfterPForm — Parameter form trigger; initializes package-level defaults after the concurrent program parameters are accepted.
• CF_business_groupFormula — Derives and returns the business group name for report display.
• CF_legislation_codeFormula — Returns the legislation code associated with the report run.
• cf_currency_format_maskformula — Returns the currency format mask for a given legislation code.
• set_currency_format_mask — Procedure that resolves and applies the currency format mask used across the report.
• cf_average_sep_payformula — Computes average separation pay from total pay and employee count.
• cf_average_working_periodformu — Computes average working period from work period totals and employee count.
• cf_end_of_reportformula — Returns an end-of-report indicator based on average salary.
• cf_average_payment_daysformula — Computes average payment days from payment days and headcount.
• CF_PERIOD_NAMEFormula — Returns the period name as a character value; this is the formula referenced by the search term cf_period_nameformula. It determines how the payroll period label is presented in the report output.
• CP_unit_p — Returns the unit value maintained in the package-level CP_unit variable.

Tables Accessed

• FND_CURRENCIES — Source of currency definitions used by the currency format mask logic.
• HR_ALL_ORGANIZATION_UNITS — Resolves business group and organization unit information.
• HR_ORGANIZATION_INFORMATION — Supplies organization-level attributes such as legislation code.
• PER_TIME_PERIODS — Provides payroll period definitions that underpin period name derivation and reporting.

Usage Notes

This package is not a callable business API; it is invoked exclusively by the XML Publisher/Reports engine when the associated payroll selection concurrent program is run. It is not referenced by any other package, confirming its role as a leaf-level report implementation. Developers typically encounter CF_PERIOD_NAMEFormula and its siblings only when diagnosing report output discrepancies, customizing the report definition, or migrating the report between EBS 12.1.1 and 12.2.2, where the package remains schema-resident in APPS with AUTHID CURRENT_USER semantics.