Search Results get_balance_name

Overview

PAY_SE_TAX_DECL is a PL/SQL package owned by APPS in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It is the payroll action declaration package that supports the Swedish statutory tax declaration process (SUT — Skattedeklaration för arbetsgivaravgifter och avdragen skatt, the employer's monthly tax and social contribution return). Although the object is catalogued generically under ETRM as API classification OTHER, its structure is that of a declarative payroll action: it supplies the parameter definitions, range selection logic, initialization, assignment action, and archival routines consumed by the Oracle Payroll action framework when the tax declaration concurrent request is processed.

The package enables the payroll engine to select a defined population of employees, compute or retrieve the aggregated balances relevant to the declaration (tax withheld and employer contributions), and then archive the results into the action information structures that feed the external declaration file transmitted to the Swedish tax authority.

Key Procedures and Functions

• GET_PARAMETER — Returns a single value from the payroll action parameter string, resolved by token and optional segment number. It allows downstream code to interpret configuration supplied at submission time.
• GET_ALL_PARAMETERS — Populates the full set of declaration parameters for a payroll action, including business group, effective date, archive flag, legal employer, declaration month and year, administrative code, free information text, and declaration due date.
• GET_DEFINED_BALANCE_ID — Resolves a defined balance identifier from a balance name and a database item suffix, used to bind declaration columns to the correct payroll balance.
• GET_BALANCE_NAME — Returns the balance name associated with an input value identifier, supporting reporting and reconciliation of the declared figures.
• RANGE_CODE — Generates the SQL selection string that determines which assignments fall into the declaration run, controlled by the payroll action identifier.
• INITIALIZATION_CODE — Performs setup actions at the start of the payroll action, before assignment processing begins.
• ASSIGNMENT_ACTION_CODE — Executes per-assignment processing within the specified person range and chunk, computing the amounts that will be archived for the declaration.
• ARCHIVE_CODE — Writes the calculated declaration results for an assignment action at the given effective date, making them available to the declaration output and subsequent reporting.

Tables Accessed

• PAY_PAYROLL_ACTIONS — the driving record for the declaration run; supplies parameters and action type.
• PAY_ACTION_INFORMATION — stores the declaration parameter values assembled by GET_ALL_PARAMETERS.
• PAY_ASSIGNMENT_ACTIONS — the processed assignment results archived by ARCHIVE_CODE.
• PAY_DEFINED_BALANCES and PAY_BALANCE_TYPES — resolve defined balance identifiers and names for the declared tax and contribution balances.
• PAY_BALANCE_DIMENSIONS — provides the dimensional context in which balances are held and retrieved.
• HR_ORGANIZATION_INFORMATION — supplies the legal employer and organizational attributes used to identify the declaring entity.

Usage Notes

PAY_SE_TAX_DECL is not intended for ad hoc SQL invocation. It is called by the Oracle Payroll action framework when the corresponding Swedish tax declaration concurrent program is submitted, and it is also referenced by one other archived package. Customisations should avoid modifying the package body directly; extension points are more safely implemented by wrapping the documented functions or by supplying additional payroll action parameters. Because the declaration feeds a statutory authority submission, any changes must be validated against the standard Swedish legislative patch level for the EBS release in use.