Search Results get_iv

Overview

PAY_JP_BEE_UTILITY_PKG is a Japanese localization utility package within the Oracle EBS Payroll (PAY) application, owned by the APPS schema. It supports the payroll batch element entry (BEE) upload process for Japanese payroll operations, supplying shared helper routines consumed by several other Japanese localization packages. As an "OTHER" classified API, it is not exposed as an end-user interface but functions as an internal service layer used to validate upload data, resolve input values, build batch lines, and manage element entry value assignments before records are committed to the payroll element entry tables.

The package is registered as VALID in the EBS 12.1.1 and 12.2.2 environments and maintains dependencies against the HR_API wrapper and standard SQL objects.

Key Procedures and Functions

• ENTRY_VALUE_TBL — A package-level PL/SQL collection type used to carry element entry values between the utility routines and their callers during batch processing.
• CHK_UPLOAD_DATE — Validates the upload/batch date against permitted processing windows before records are accepted.
• CHK_DATE_EFFECTIVE_CHANGES — Confirms that date-effective changes to element entries do not conflict with existing effective-dated rows.
• GET_IV — Retrieves an input value (IV) definition or value for a given element, supporting the mapping of uploaded data to element input values.
• GET_EE — Retrieves element entry (EE) information required during batch construction.
• SET_EEV — Populates element entry value records, assigning the resolved input values to element entries.
• LOG — Writes diagnostic or processing messages to the logging facility, aiding troubleshooting of upload runs.
• OUT — Output helper routine used to emit messages or formatted results from the utility package.
• CREATE_BATCH_LINE — Constructs a batch line record for payroll batch element entry processing, associating uploaded data with the target batch.

Tables Accessed

• PAY_ELEMENT_ENTRIES_F — Stores the element entry header records created or validated by the package.
• PAY_ELEMENT_ENTRY_VALUES_F — Holds the individual entry values set by SET_EEV.
• PAY_ELEMENT_LINKS_F — Defines the link between element and input value eligibility.
• PAY_INPUT_VALUES_F / PAY_INPUT_VALUES_F_TL — Input value definitions and their translated names, used by GET_IV.
• PAY_LINK_INPUT_VALUES_F — Maps input values to element links.
• PAY_BATCH_LINES — Target table for CREATE_BATCH_LINE output.
• PAY_COST_ALLOCATION_KEYFLEX — Cost allocation key flexfield referenced during entry processing.
• PER_ALL_ASSIGNMENTS_F — Assignment records resolving the employee for each element entry.
• PER_TIME_PERIODS — Payroll period definitions used in date validation and batch dating.
• PLITBLM — Standard Oracle Forms/PL/SQL utility table referenced in package internals.

Usage Notes

PAY_JP_BEE_UTILITY_PKG is not invoked directly by end users. It is called by three dependent packages — PAY_JP_CREATE_CMA_PKG, PAY_JP_ITAX_DPNT_INTERFACE_PKG, and PAY_JP_LTAX_IMP_PKG (referenced twice) — which drive Japanese payroll batch element entry, income tax dependent interface, and local tax import processing respectively. The package itself depends on HR_API and the standard SYS.STANDARD package. Because it is a supporting utility, customizations or extensions to Japanese payroll upload functionality should call the documented procedures rather than duplicate their logic. Any change to this package should be regression-tested against all three referencing packages to ensure date-effectivity, input value resolution, and batch line creation continue to function correctly across both 12.1.1 and 12.2.2 releases.