Results for “do_expire”

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

Overview

PAY_JP_ISDF_SS_PKG is a Japanese localization package in the Oracle E-Business Suite Payroll module (APPS schema). Its name and internal constants indicate that it supports the Japan-specific Insurance Premium Deduction Statement (ISDF) and the associated social insurance / tax adjustment processing. The package is heavily driven by a set of user-defined tables (UDTs) whose names are declared as constants at the top of the specification, including T_YEA_LIFE_INS_EXM (life insurance exemption), T_YEA_INDIVIDUAL_PENSION_INS_EXM (individual pension insurance), T_YEA_LONG_NONLIFE_INS_EXM and T_YEA_SHORT_NONLIFE_INS_EXM (long- and short-term non-life insurance), and T_YEA_MAX_AMT. These UDTs hold the rate, maximum-amount and deduction columns used during the year-end adjustment (YEA) calculation of insurance premium deductions. The package exposes a set of form-driven actions (DO_NEW, DO_APPLY, DO_CALCULATE, DO_FINALIZE, DO_REJECT, DO_RETURN, DO_APPROVE, DO_TRANSFER, DO_EXPIRE) that mirror the lifecycle of a Japanese year-end adjustment declaration, together with helper routines for spouse and widow classification and for setting form page prompts.

Key Procedures and Functions

Seventeen documented procedures/functions are exposed (name and purpose only; parameter signatures are not enumerated in the metadata):

• GET_SPOUSE_TYPE — determines the spouse classification used when applying the spouse exemption and spouse income deduction rules.
• GET_WIDOW_TYPE — determines the widow classification for the applicable deduction.
• SET_FORM_PG_PROMPT — sets the form page prompt text displayed to the user.
• SET_FORM_PG_PROMPT2012 — a 2012-variant of the page prompt setting, reflecting a legislative change in the Japanese tax/social insurance rules.
• DO_NEW — initializes a new declaration record.
• DO_APPLY — applies the entered values to the declaration.
• DO_CALCULATE — performs the insurance premium deduction and year-end adjustment calculation using the UDT rates and maximums.
• DO_FINALIZE — finalizes the declaration.
• DO_REJECT — rejects the declaration.
• DO_RETURN — returns the declaration to the previous state for correction.
• DO_APPROVE — approves the declaration.
• DO_TRANSFER — transfers the declaration, presumably to the payroll action for processing.
• DO_EXPIRE — expires the declaration.

Tables Accessed

The package reads and writes the following documented tables (via APPS synonyms):

• PAY_USER_TABLES, PAY_USER_COLUMNS, PAY_USER_ROWS_F, PAY_USER_COLUMN_INSTANCES_F — store the UDT definitions and instance values (rates, maximum amounts, exemption values) that drive the calculation.
• PAY_ELEMENT_ENTRY_VALUES_F — element entry values written/read for the insurance premium deduction element.
• PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_ACTION_INFORMATION, PAY_ACTION_INFORMATION_S — the payroll action framework through which the year-end adjustment is submitted and tracked.
• PAY_ALL_PAYROLLS_F — payroll definition lookup.
• PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F — assignment and person details used to identify the declarant, spouse and dependents.
• HR_ORGANIZATION_INFORMATION — organization (legal entity / business group) information.
• FND_SESSIONS, FND_NEW_MESSAGES — session context and messages (including error/validation messages for the form).

Usage Notes

The DO_* action routines indicate that this package is invoked primarily from the Japanese ISDF form and related year-end adjustment forms, where button actions (New, Apply, Calculate, Finalize, Reject, Return, Approve, Transfer, Expire) trigger the corresponding procedure. It is not referenced by any other documented package (Referenced by 0 other packages), confirming it is a top-level localization entry point rather than a shared utility. Constants such as c_nonlife_long_year := 10, c_sp_calc_unit := 10000, and c_sp_earned_inc_exp := 650000 reflect the Japanese statutory thresholds and units (spouse deduction unit of 10,000 yen, spouse earned income threshold of 650,000 yen). Because the metadata is limited, parameter lists and exact call signatures should be confirmed from the packaged specification and body in the ETRM / database before extending the package. The user search term "life_gen" corresponds to the life insurance general exemption UDT column (c_life_gen_calc_udt), which is central to the DO_CALCULATE logic.