Search Results pay_run_result_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_RUN_RESULT_PKG is a server-side PL/SQL package within the Oracle E-Business Suite Payroll (PAY) module. Its principal business function is to create, maintain, and retrieve payroll run results — the persistent records that capture the outcome of processing an element entry through a payroll run for a given assignment within an assignment action, payroll, and time period. During a payroll run, the payroll engine evaluates element entries and produces run results and their associated run result values. This package encapsulates the logic by which those result rows and their value rows are inserted, updated, and read, ensuring that direct results, indirect results, and their dependent values remain consistent with the underlying element entries and input values.

The package is classified as OWNER APPS, status VALID, with an API classification of OTHER. It is referenced by four other packages, making it a shared, low-level utility used across payroll result processing rather than a standalone business flow.

Key Procedures and Functions

The documented interface exposes five procedures and functions:

  • CREATE_RUN_RESULT — Creates the primary payroll run result record for an element entry processed within a run context.
  • CREATE_RUN_RESULT_DIRECT — Creates a run result classified as a direct result, originating from the element entry itself.
  • CREATE_INDIRECT_RR — Creates an indirect run result, i.e., a result generated as a consequence of processing rather than from a direct element entry.
  • MAINTAIN_RR_VALUE — Maintains (inserts or updates) run result value rows associated with a run result.
  • GET_RESULT_VALUE — Retrieves the stored value for a given run result, supporting downstream consumers that read payroll outcomes.

All five are documented as belonging to the package; parameter signatures are not enumerated in the supplied metadata and are intentionally not reproduced here.

Tables Accessed

The package references the following tables via APPS synonyms:

  • PAY_RUN_RESULTS and PAY_RUN_RESULTS_S — the run result base table and its corresponding date-tracked (shadow) table, used when creating and querying run results.
  • PAY_RUN_RESULT_VALUES — stores the individual values associated with each run result; maintained by MAINTAIN_RR_VALUE and read by GET_RESULT_VALUE.
  • PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F — the element entry and entry value date-tracked tables that define the input being processed.
  • PAY_ELEMENT_TYPES_F — element type definitions, providing classification of elements and their result behaviors.
  • PAY_INPUT_VALUES_F — input value definitions governing the element's inputs.
  • PER_TIME_PERIODS — period definitions used to anchor run results to a valid time period.
  • DUAL — standard single-row utility source.

Reads are used to validate and resolve element, entry, input, and period context; writes populate run result and run result value rows.

Usage Notes

PAY_RUN_RESULT_PKG is invoked internally by the payroll run engine and consumed by other payroll packages. Documented dependents include HRASSACT, PAY_BAL_ADJUST, PAY_RETRO_PKG, and the PAY_RUN_RESULTS_V3 view, indicating reuse in assignment action processing, balance adjustment, retroactive pay recalculation, and reporting. Custom code and extensions should prefer calling the documented procedures rather than inserting directly into PAY_RUN_RESULTS, so that date-tracked shadow rows and dependent run result values remain synchronized. The package operates against APPS synonyms and therefore executes within the APPS schema or a schema granted equivalent privileges; the STANDARD package is its only external dependency.