Search Results cp_period_start_date

Overview

APPS.PAY_PYNZ345_XMLP_PKG is the generated PL/SQL package body that backs the Oracle EBS New Zealand payroll report known internally as PYNZ345 (source file PYNZ345B.pls). It is an XML Publisher (BI Publisher) report package, produced automatically by the XML Publisher report definition generator, and is classified in ETRM as API classification OTHER — meaning it is not a public, supported integration API but rather an internal implementation artifact. The package exists to supply the report's parameters, computed fields, and formatting logic at runtime. In Oracle EBS 12.1.1 and 12.2.2, such packages execute within the APPS schema and are invoked by the concurrent manager when the associated concurrent program is submitted.

The central runtime hook is the BeforeReport function, which resolves several derived values before the report data model executes. Among these is cp_currency_code, the value the user searched for. It is populated by querying FND_CURRENCIES for the currency code whose issuing territory matches the organization information (org_information9) of the registered employer's business group, then wrapping that code in parentheses for display.

Key Procedures and Functions

• BEFOREREPORT — Executes prior to report execution. It resolves the currency code cursor and assigns cp_currency_code and cp_currency_format (via FND_CURRENCY.GET_FORMAT_MASK), then derives the half-month period start and end dates using PAY_NZ_TAX.HALF_MONTH_START and PAY_NZ_TAX.HALF_MONTH_END.
• AFTERREPORT — Post-report cleanup placeholder; currently returns TRUE without additional logic.
• CF_TOTAL_DEDUCTIONSFORMULA — Computes total deductions by summing PAYE, child support, student loan, and SSCWT deductions, applying NVL to each to tolerate nulls.
• CF_BUSINESS_GROUPFORMULA — Returns the business group name by invoking HR_REPORTS.GET_BUSINESS_GROUP.
• CF_REGISTERED_EMPLOYERFORMULA — Returns the registered employer name from HR_NZ_TAX_UNIT_V, filtered by business group and tax unit identifiers.
• CP_CURRENCY_FORMAT_P — Computed parameter returning the currency format mask.
• CP_CURRENCY_CODE_P — Computed parameter exposing cp_currency_code to the report layout.
• CP_PERIOD_START_DATE_P — Computed parameter for the half-month period start.
• CP_PERIOD_END_DATE_P — Computed parameter for the half-month period end.

Tables Accessed

• FND_CURRENCIES — Read in BeforeReport to obtain the currency code and format mask associated with the employer's issuing territory.
• HR_ORGANIZATION_INFORMATION — Read to extract org_information9 for the business group, which supplies the issuing territory used to qualify the currency lookup.
• Additional views referenced in code include HR_NZ_TAX_UNIT_V (registered employer name).

Usage Notes

This package is not called directly by customers. It is invoked by the concurrent manager as the program logic for the PYNZ345 XML Publisher concurrent program, and the report output relies on the computed parameters (notably cp_currency_code) being resolved during BeforeReport. Because the report requires a registered employer and business group, correct setup of HR_ORGANIZATION_INFORMATION is essential for the currency code and format mask to resolve. The package is reference-only in ETRM (0 other packages reference it), so modifications should be considered customization and re-generated if the underlying XML Publisher data model changes.