Search Results get_assignment_info

Overview

APPS.PAY_JP_BALANCE_VIEW_PKG is a Japanese localization package within the Oracle E-Business Suite Payroll (PAY) product family. Its principal business purpose is to resolve and cache the assignment-level context required to display payroll balance information in the Japanese balance inquiry and reporting functionality. The package encapsulates the joins between assignment records and the payroll time periods applicable to a given effective date, returning a single consolidated record that downstream logic uses to drive dimensional balance calculations.

The package body, identified internally by the header comment pyjpbalv.pkb 120.0, defines two package-level record types: t_assignment_rec, which holds assignment, effective date, business group, payroll, and time period identifiers, and t_defined_balance_rec, which holds defined balance metadata including dimension name, dimension level, period type, and start date code. Corresponding global variables (g_assignment_rec and g_defined_balance_rec) provide in-session caching to avoid repeated queries against the same assignment and effective date combination.

Key Procedures and Functions

• get_assignment_info — The procedure most directly associated with the user search term. It accepts an assignment identifier and an effective date, and returns an assignment record containing the business group, payroll, and payroll time period. Before querying, it compares the supplied assignment and effective date against the cached global record; when they match, no database access is performed. Otherwise it selects from PER_ALL_ASSIGNMENTS_F joined with PER_TIME_PERIODS on the payroll identifier and effective date range.
• get_value — The single procedure or function formally classified in the ETRM metadata for this package. It serves as the general-purpose accessor used by dependent packages to retrieve balance view values resolved through the cached assignment and defined balance context.
• Additional internal procedures (not individually named in the metadata) support the loading of defined balance metadata into the t_defined_balance_rec structure and the derivation of dimensional values from the balance dimension definitions.

Tables Accessed

• PER_ALL_ASSIGNMENTS_F — The primary source for assignment context; the package reads the business group and payroll for the assignment effective on the requested date.
• PER_TIME_PERIODS — Supplies the time period identifier associated with the assignment's payroll, joined with an outer join to tolerate assignments lacking a defined period.
• PAY_BALANCE_DIMENSIONS — Provides the dimension name, level, period type, and start date code used to resolve defined balance dimensions.
• PAY_DEFINED_BALANCES — Identifies the defined balances and their associated balance types and dimension mappings.
• PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS — Referenced to correlate assignment-level and payroll-level action processing with the balances being viewed.

Usage Notes

This package is typically invoked from Japanese localization forms and concurrent programs that present payroll balance information to end users, and it is referenced by three other packages within the APPS schema. The caching behavior of get_assignment_info means it is best suited to repeated calls within a single session where the assignment and effective date remain constant; callers changing either value should expect a fresh query. Because the package is a view-support package rather than a public API, customizations should call it only through the standard balance inquiry interfaces and should not rely on the internal record types remaining stable across patch levels. The noship designation in the source header indicates the object is not shipped as a standalone patchable entity, reinforcing that it is a supporting component of the Japanese payroll balance view feature.