Results for “pay_jp_result_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_JP_RESULT_PKG is a Japanese localization package within the Oracle E-Business Suite payroll module (PAY). Its principal business function is to retrieve and consolidate payroll run result data — specifically "Result Values" and "Balance Values" — for a given assignment action, and to expose them through callable APIs. The package therefore sits at the boundary between stored payroll processing data and the reporting or downstream logic that must interpret run outcomes.

The package header comment states that a single function returns the result ("Result Value" and "Balance Value") of a "Run", and enumerates the supported action types: B (Balance Adjustment), F (Advance Pay), I (Balance Initialization), Q (QuickPay Run), R (Run), V (Reversal), and Z (Purge). This confirms the package is designed to work across the full range of payroll action cycles rather than run processing alone.

Key Procedures and Functions

• RESULT_VALUES_INTERNAL — The core bulk retrieval routine. It accepts an assignment action ID and effective date, and populates an IN OUT NOCOPY result-values structure. Its cursor joins input values to determine data type from the unit of measure, then canonicalizes numeric results via FND_NUMBER. The source carries historical bug fixes (BUG1899306, BUG3038738, Bug#5464717) and deliberately avoids object types.
• BALANCE_VALUES_INTERNAL — The balance counterpart, gathering balance-level values for the supplied assignment action.
• RUN_INTERNAL — Internal driver that coordinates run-level result retrieval.
• RESULT_VALUE — Public wrapper exposing a single result value to callers.
• BALANCE_VALUE — Public wrapper exposing a single balance value.
• RUN — Public entry point returning run-level results.
• PREPAY — Handles values associated with Advance Pay processing.

The _INTERNAL suffix indicates implementation detail; the unprefixed procedures constitute the supported call surface. The user search term "result_value" maps directly to PAY_RUN_RESULT_VALUES.RESULT_VALUE, the column retrieved by the primary cursor.

Tables Accessed

• PAY_RUN_RESULT_VALUES — Primary source of result value rows; the RESULT_VALUE column is typed and fetched here.
• PAY_INPUT_VALUES_F — Supplies input value IDs and units of measure used to derive data type (Number, Text, or Date).
• PAY_RUN_RESULTS — Provides run result context for balance and run-level retrieval.
• DBMS_SQL and PLITBLM — Oracle-supplied packages used for dynamic SQL and PL/SQL table manipulation.

Usage Notes

The package is classified as OTHER and is referenced by zero other packages in the metadata, indicating it is not a shared dependency but rather invoked directly by Japanese payroll forms, concurrent programs, or custom extensions. It is typically called when a report or process must resolve the typed value of a payroll element result for an assignment action — for example, converting stored UOM-coded values into canonical numbers or dates. Because the source explicitly avoids object types due to historical Oracle bugs, callers should use the documented public procedures (RESULT_VALUE, BALANCE_VALUE, RUN, PREPAY) rather than relying on internal structures. The version header (120.3, dated 2006) is consistent across 12.1.1 and 12.2.2, so behavior is unchanged between those releases.