Search Results c_payroll_period_p

Overview

APPS.PER_PAYRPEMV_XMLP_PKG is a generated PL/SQL package artifact that supports the Oracle EBS Payroll report commonly identified as the Payroll Employee Movement or payroll event movement report (PAYRPEMV). It is a report logic package produced by Oracle Reports/XML Publisher integration, where the report's user parameters, formula columns, and summary computations are exposed as PL/SQL package globals, functions, and procedures in the APPS schema. The package header ($Header: PAYRPEMVS.pls 120.1) confirms it is a seeded Oracle-supplied object, with a file version dating to 2007 and an owner designation of noship. Functionally, the package supplies the runtime state and derived calculations needed to render a payroll-based report that compares employee movements — new hires, terminations, and transfers in/out — between two reporting dates or payroll periods, filtered by business group, organization structure, parent organization, payroll, and worker type. It serves no standalone business API role; API classification is OTHER, and it is referenced by zero other packages.

Key Procedures and Functions

The documented interface includes 26 procedures and functions. The user query term, c_net_changeformula, is among the documented functions and represents the report's net change formula column: it derives the net movement (new hires plus transfers in, less terminations and transfers out) used in the report output.

• BEFOREREPORT — the report-level initialization function that executes prior to report execution, resolving parameters and populating global state.
• C_NET_CHANGEFORMULA — computes the net change value for the report's summary/change column.
• C_SQL_TRACEFORMULA and TRACEFORMULA — formula columns used to emit diagnostic/trace information when the trace parameter is enabled.
• CF_CONTROL_TOTAL_NEWHIREFORMULA — control-total formula accumulating new hire counts.
• CF_CONTROL_TOTAL_TERMFORMULA — control-total formula accumulating termination counts.
• CF_CONTROL_TOTAL_TRANSINFORMULA — control-total formula accumulating transfer-in counts.
• CF_CONTROL_TOTAL_TRANSOUTFORMULA — control-total formula accumulating transfer-out counts.
• AFTERREPORT — post-report procedure for cleanup or final summary processing.
• Placeholder/value accessors — C_BUSINESS_GROUP_NAME_P, C_REPORT_SUBTITLE_P, C_ORG_STRUCTURE_NAME_P, C_VERSION_NUMBER_P, C_PARENT_ORGANIZATION_NAME_P, C_PAYROLL_NAME_P, C_PAYROLL_PERIOD_P, C_EMP_DET_PARAM_DISP_P, CP_WORKER_TYPE_DESC_P, CP_TOTAL_EMP_NEWHIRE_P, CP_TOTAL_CWK_NEWHIRE_P, and their related variants supply the report header labels and running totals.

Tables Accessed

The ETRM metadata records no tables referenced via APPS synonyms for this package. This is consistent with its role: the report's data extraction is performed by the report's own SQL queries (including lexically substituted date, organization, and payroll clauses), while the package is responsible for parameter storage, formula evaluation, and summary totals rather than direct table DML. No inserts, updates, or deletes are performed by the package itself.

Usage Notes

This package is not intended for direct invocation by custom code. It is executed implicitly by the Oracle Reports runtime when the PER_PAYRPEMV report is run, whether from the Payroll responsibility, a concurrent request submission, or an XML Publisher-based execution path. Developers may encounter it while diagnosing report runtime errors, formula column failures, or parameter binding issues; the numerous P_ globals function as report parameter placeholders, and modifying them in custom code is unsupported. Because the package is seeded and referenced by zero other packages, it should be treated as read-only Oracle-owned source and patched only through standard EBS patching, not through manual customization.