Results for “set_form_pg_prompt2012”

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

Overview

APPS.PAY_JP_ISDF_SS_PKG is a Japanese localization payroll package that supports the Income and Social Declaration Form (ISDF) and the associated Social Insurance (SS) declaration processing within Oracle E-Business Suite 12.1.1 and 12.2.2. The package body encapsulates the business rules required to calculate, validate, and report the insurance premium and dependent/spouse income information that Japanese employers must declare to tax and social insurance authorities. It relies on the Japanese element architecture, resolving element types such as YEA_INS_PREM_EXM_DECLARE_INFO and YEA_INS_PREM_SPOUSE_SP_EXM_INFO and their associated input values (for example general life insurance premium, individual pension premium, long-term and short-term non-life insurance premium, earthquake insurance premium, national pension and spouse income) through the HR_JP_ID_PKG lookup utilities.

The package header version reference (pyjpisfs.pkb 120.12.12020000.4) confirms maintenance aligned with the 2012 tax reform input values (the *_2012 variants), reflecting the legislative changes to deductible insurance categories. The user search term "calc_dct" refers to the calculation and declaration context handled by the DO_CALCULATE and DO_APPLY routines within this package.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions organized around a declarative lifecycle:

• DO_NEW, DO_APPLY, DO_CALCULATE, DO_FINALIZE – Core lifecycle routines that create, apply, calculate, and finalize an ISDF/SS declaration record. DO_CALCULATE performs the premium and income computations that populate the declaration, while DO_FINALIZE locks the record prior to submission.
• DO_APPROVE, DO_REJECT, DO_RETURN, DO_TRANSFER, DO_EXPIRE – Workflow-state transitions that move a declaration through approval, rejection, return for correction, transfer, or expiry, supporting the standard EBS action-processing model.
• GET_SPOUSE_TYPE, GET_WIDOW_TYPE – Classifier functions that derive the applicable dependent or widow category used in the declaration.
• SET_FORM_PG_PROMPT, SET_FORM_PG_PROMPT2012 – Form-level utilities that set page/field prompts, with the 2012 variant reflecting the revised deductible-premium captions.

The package does not expose a "calc_dct" procedure directly; that functionality is realized through DO_CALCULATE and its supporting helpers.

Tables Accessed

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

• Payroll and assignment data: PAY_ASSIGNMENT_ACTIONS, PAY_ACTION_INFORMATION and _S, PAY_PAYROLL_ACTIONS, PAY_ALL_PAYROLLS_F, PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F – used to locate the assignment and action context for which the declaration is processed.
• Element entry and user-defined columns: PAY_ELEMENT_ENTRY_VALUES_F, PAY_USER_COLUMNS, PAY_USER_COLUMN_INSTANCES_F, PAY_USER_ROWS_F, PAY_USER_TABLES – used to store and retrieve the declaration figures through the flexible user-defined table/column framework.
• Organization and session context: HR_ORGANIZATION_INFORMATION, FND_SESSIONS, FND_NEW_MESSAGES – used for legal-employer attributes, session handling, and message resolution.

Usage Notes

PAY_JP_ISDF_SS_PKG is invoked primarily from the Japanese ISDF/SS entry forms and from payroll action processing during the declaration run. It is not referenced by any other documented package, so it functions as a top-level entry point rather than a shared library. Customizations should call the DO_* routines in sequence (NEW → APPLY → CALCULATE → FINALIZE → APPROVE/REJECT) to preserve state consistency, and should use the SET_FORM_PG_PROMPT2012 variant for post-2012 configurations.