Search Results pay_jp_wic_pkg




Overview
Explore in AI Chat

Overview

PAY_JP_WIC_PKG is an Oracle Applications (APPS) PL/SQL package within the Oracle E-Business Suite Payroll module, specifically scoped to Japanese localization requirements. The acronym "WIC" refers to the withholding income tax certificate functionality used in Japanese payroll processing, where employers must generate annual withholding tax statements (gensen choshu-hyo) and related statutory documentation for employees. This package encapsulates the validation, calculation, and data retrieval logic required to support those statutory reporting obligations. It operates against the standard Oracle HRMS and Payroll tables, providing reusable program units that other payroll packages and concurrent program report templates call to derive employee tax-relevant attributes, certificate information, and valid taxable amounts for a given term. The package is classified as an OTHER API in ETRM, indicating it is not an open public interface but an internal utility package intended for use by Oracle-delivered payroll processes rather than external integrations. Its status is VALID, and it depends on standard APPS synonyms plus the SYS.STANDARD package.

Key Procedures and Functions

The package exposes seventeen documented program units. The principal ones include:

  • GET_EE_DESCRIPTION — retrieves a descriptive attribute for an employee, typically the formatted name or description used on withholding certificates.
  • GET_DESCRIPTIONS — returns multiple employee descriptions in a single call, supporting bulk certificate generation.
  • GET_CERTIFICATE_INFO — assembles the certificate-level data required for the Japanese withholding tax statement.
  • SET_VALID_TERM_TAXABLE_AMT — establishes or computes the valid taxable amount for a specific payroll term, a core input to the tax calculation.
  • SPR_TERM_VALID — determines whether a given term is valid for withholding tax processing.
  • GET_PREV_JOBS — returns an employee's prior job assignments, relevant when apportioning income or tax across employment changes in the tax year.
  • ASS_SET_VALIDATION — performs assignment-level validation against the configured withholding tax rules.

The remaining units are internal helpers supporting these operations. Parameter lists are not reproduced here; callers reference the package specification.

Tables Accessed

The package reads and writes against standard Oracle HRMS and Payroll tables via APPS synonyms, including PER_ALL_PEOPLE_F (employee records for descriptions), HR_ORGANIZATION_INFORMATION, PAY_ALL_PAYROLLS_F (payroll definitions), PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F (element entry results), PAY_ELEMENT_LINKS_F, PAY_INPUT_VALUES_F and PAY_LINK_INPUT_VALUES_F (element configuration), PER_CONTACT_RELATIONSHIPS, and PER_PREVIOUS_EMPLOYERS (prior employment history used in tax certificate reporting). DUAL and PLITBLM are also referenced for utility operations.

Usage Notes

PAY_JP_WIC_PKG is not intended for direct external invocation. ETRM documents five dependent objects that reference it: PAY_JP_ITAX_ARCHIVE_PKG, the view PAY_JP_TAX_SWOT_V, PAY_PAYJPITT_XMLP_PKG, PAY_PAYJPWTM_XMLP_PKG, and itself. This pattern shows the package is consumed primarily by Japanese payroll concurrent program report templates (the _XMLP_PKG wrappers behind BI Publisher reports) and by tax archive and view logic. Customizations should avoid modifying the package and instead consume its outputs through supported report or archive interfaces. Any invocation during upgrades or patching must respect patch-level changes, since withholding tax regulations in Japan are revised periodically and the package logic tracks those statutory changes.