Results for “pay_sg_cpfline”

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

Overview

APPS.PAY_SG_CPFLINE is a Singapore-specific Oracle Payroll package body that supports the processing of the Central Provident Fund (CPF) contribution file. In the Oracle E-Business Suite localization model, country-specific payroll logic is delivered through dedicated packages whose names carry the country code (here SG, for Singapore). The package body PAY_SG_CPFLINE implements the file and reporting line generation required for statutory CPF submission, extending the standard payroll action framework so that a payroll run can produce the mandated CPF output for the reporting period.

The package is classified as OTHER in the ETRM repository, indicating it is not an exposed public API but an internal processing module invoked through the payroll action architecture. Its header (pysgcpfl.pkb 120.0) confirms it is a shipped localization component maintained by Oracle, with the standard noship check-in flag. The body declares a record type t_pact that captures payroll action context — report type, report qualifier, report category, business group, effective date, month date, legal entity, and start/end dates — populated during initialization. This contextual record drives the subsequent range and assignment processing.

Key Procedures and Functions

Six documented procedures and functions make up the package interface, following the standard payroll action hooks used across Oracle Payroll localization packages:

• INITIALIZATION_CODE — Performs one-time setup for the payroll action, populating the g_pact record with report metadata, business group, legal entity, and period dates. It also caches defined balance identifiers and names used later when evaluating balance values.
• RANGE_CODE — Defines the range of assignments or records processed by the action, supporting the payroll action's iteration model over the population selected for CPF file processing.
• ASSIGNMENT_ACTION_CODE — Executes per-assignment logic, computing or retrieving the values required for each employee's CPF line. This is the core processing hook invoked for every assignment in the action's range.
• ARCHIVE_CODE — Gathers and preserves the data produced by the action into payroll action information for archival and audit purposes, using the rec_action_info record based on PAY_ACTION_INFORMATION%ROWTYPE.
• DEINIT_CODE — Performs cleanup at the conclusion of the payroll action, releasing package-level state and finalizing processing.
• CHECK_CPF_NUMBER — Validates the CPF number associated with the assignment or person, returning a status used to determine whether a valid CPF line can be produced. The function get_def_bal_id is an internal helper that resolves a defined balance name to its identifier from the cached arrays.

Tables Accessed

The package reads and writes against standard HRMS and Payroll tables through APPS synonyms. PAY_PAYROLL_ACTIONS and its _S counterpart supply the action context used by initialization. PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S provide the per-assignment action records processed by ASSIGNMENT_ACTION_CODE. PAY_ACTION_INFORMATION and PAY_ACTION_INFORMATION_S store the archived results produced by ARCHIVE_CODE.

Balance resolution relies on PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES, and PAY_BALANCE_DIMENSIONS, which together map balance names to identifiers and dimensions used in the CPF computation. Employee and assignment data are drawn from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, and PER_ASSIGNMENT_EXTRA_INFO. Organization context, including legal entity information, comes from HR_ORGANIZATION_INFORMATION. DUAL supports scalar lookups, and PLITBLM is used for temporary/table-based list processing during the run.

Usage Notes

PAY_SG_CPFLINE is not called directly by end users or forms; it is driven by the Oracle Payroll action framework when a Singapore CPF-related payroll action is initiated. The action framework invokes INITIALIZATION_CODE, then iterates RANGE_CODE and ASSIGNMENT_ACTION_CODE across the selected assignment population, followed by ARCHIVE_CODE and DEINIT_CODE. CHECK_CPF_NUMBER is used during processing to validate employee CPF identifiers before a line is written.

Because the package is classified as OTHER and is referenced by one other package, customizations should avoid direct invocation and instead rely on the standard payroll action and concurrent program configuration. In 12.1.1 and 12.2.2 the package remains an internal localization component; any extension should be implemented through supported payroll action hooks or custom reporting against the archived PAY_ACTION_INFORMATION data rather than by modifying the shipped package body.