Search Results g_assignment_set_id

Overview

APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT is a Norwegian (NO) legislative package body delivered as part of the Oracle Human Resources and Payroll localization for Oracle E-Business Suite 12.1.1 and 12.2.2. Its name — "NO ARC" (Norwegian archive) "Holiday Entitlement" — indicates that it supports the archiving and reconstruction of holiday entitlement and absence-related balances for Norwegian payroll assignments. The package is classified as a utility routine in ETRM rather than as a public API, and its header signature (pynohlea.pkb 120.0.12000000.1) confirms it is a standard localization module rather than a customer extension.

The package operates on legislative parameters of a payroll action, extracting token/value pairs that describe which assignments, balance dimensions, and effective dates are in scope for an archival run. It maintains a small set of package-level globals that buffer the request context for the duration of a session — business group, legal employer, effective date, employee, assignment set, archive identifier, and error state. This design is typical of the Norwegian payroll archiving infrastructure, where a single legislative run may touch many assignments and must resolve holiday entitlement consistently across them.

Key Procedures and Functions

• GET_PARAMETER — Parses a single named token out of the legislative parameter string passed on the payroll action. It supports two delimiters (space and pipe) and can return a specific colon-delimited segment of a multi-valued token. This is the primitive used by all other parameter-dependent logic in the package.
• GET_ALL_PARAMETERS — Drives the full parse of the legislative parameter string in one pass, populating the package-level globals such as g_business_group_id, g_legal_employer_id, g_effective_date, g_employee_id, g_assignment_set_id, and g_archive.
• RANGE_CODE — Determines the range or scope of the archival action (for example which assignments or people fall within the run), returning a code consumed by downstream processing.
• ASSIGNMENT_ACTION_CODE — Returns the code indicating what the archival run should do to each qualifying assignment action.
• INITIALIZATION_CODE — Performs the initial setup work for the run, establishing the locking structure and any archive-side identifiers before row-by-row processing begins.
• ARCHIVE_CODE — Returns the code that identifies the archive or archival variant (feedback from g_archive) and governs how entitlement rows are written to the archive target.

The package also declares a lock_rec record and lock_table associative array keyed on binary integer, used to hold archive assignment action identifiers, and a g_debug flag bound to hr_utility.debug_enabled that enables location tracing through hr_utility.set_location.

Tables Accessed

The documented table references fall into three groups. Payroll action and setup tables — PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS and its _S shadow, PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, and PAY_BALANCE_DIMENSIONS — supply the legislative parameter string, the assignment-level actions, and the balance definitions that holiday entitlement depends on.

HR and PER tables — PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_ASSIGNMENT_STATUS_TYPES, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX — resolve the assignment, person, legal employer, and any Norwegian organizational attributes required to qualify assignments for archival. DUAL is used for code-style lookups. Accesses are via APPS synonyms, so the package must be run with the APPS schema and the standard HR security context in effect.

Usage Notes

PAY_NO_ARC_HOLIDAY_ENTITLEMENT is not intended for direct customer invocation. It is referenced by one other APPS package (the Norwegian payroll archive orchestrator) and is normally reached only through a Norwegian payroll archival concurrent process or the payroll action framework that supplies the legislative parameter string. Because it relies on package globals, it is not re-entrant and must be called within a single logical run per session.

The user search term "g_assignment_set_id" corresponds to the package global populated by GET_ALL_PARAMETERS from the legislative parameter string; it identifies the assignment set that scopes which assignments are considered for holiday entitlement archival, and is subsequently used by RANGE_CODE and ARCHIVE_CODE to filter and target the run. Diagnosing issues with this global therefore begins with inspecting the legislative parameters supplied on the PAY_PAYROLL_ACTIONS row, or enabling hr_utility.debug_enabled to trace GET_PARAMETER token resolution.