Search Results add_detail

Overview

APPS.PAY_NO_SSB_CODES is a Norway-localized Oracle EBS Payroll package body that supports statutory year-end reporting to Norwegian authorities (the "SSB" — Statistisk sentralbyrå / Statistics Norway). Its central responsibility is to transform processed payroll run results into a normalized reporting structure, deriving the SSB reporting code and associated detail classification for each element processed against an assignment action. The package resolves the distinction between element-level data and aggregated year-end reporting codes, and it maintains an in-memory cache of code rows so that repeated lookups during a single run do not re-query the base tables.

The object is of particular interest when searching on "add_detail" because that token is an alias exposed directly in the driving cursor of POPULATE_TABLE, where it labels the column that carries the reporting classification accompanying each SSB code row.

Key Procedures and Functions

The package exposes seven documented program units:

• POPULATE_TABLE — The principal entry point. It accepts an assignment action identifier and an effective date, invokes the internal cursor to gather processed elements and their SSB codes, and loads the results into the package-level cached table. It is the function implicated by the "add_detail" search.
• SET_NEXT_CACHED_CODE — Advances the cache cursor to the next stored code row.
• CLEAR_CACHED_VALUE — Removes a single stored value from the cached structure.
• GET_TOTAL_RESULT_VALUE — Returns the accumulated monetary result value for the reporting codes currently in scope.
• GET_NEXT_CACHED_CODE — Retrieves the next code row from the cache and advances the internal position.
• GET_CURRENT_CACHED_CODE — Returns the code row at the current cache position without advancing it.
• CLEAR_CACHED_TABLE — Empties the package-level cache table, resetting state between invocations.

No parameter lists are documented in the ETRM metadata; the signatures above are described by purpose only and should be confirmed against the deployed source.

Tables Accessed

The cache population cursor in POPULATE_TABLE joins PAY_ASSIGNMENT_ACTIONS, PAY_RUN_RESULTS, PAY_ELEMENT_TYPES_F and PAY_ELEMENT_TYPE_EXTRA_INFO. The extra-info table supplies both the reporting code and the add-detail value via its descriptive flexfield segments (EEI_INFORMATION1 through EEI_INFORMATION4), across two categories: NO_SSB_CODES and NO_EOY_REPORTING_CODE_MAPPING. Additional documented dependencies include FND_SESSIONS for session context, PAY_INPUT_VALUES_F, PAY_RUN_RESULT_VALUES, PAY_USER_TABLES, PAY_USER_ROWS_F and the PLITBLM PL/SQL table type utility, which support value resolution and the in-memory cache.

Usage Notes

The package is classified as OTHER, indicating it is not a published public API. It is invoked from the Norwegian year-end reporting flow, typically driven by a concurrent program or by the localized payroll report/form that assembles SSB submissions. Callers pass the assignment action being reported and the reporting effective date; the package populates its cache once, then iterates via the SET/GET cache calls, resetting with CLEAR_CACHED_TABLE before reuse. Because it reads date-effective element definitions, correctness depends on supplying an effective date that falls within the element type's validity window and within the year range defined in the reporting-code mapping flexfield.

Custom code should treat this package as internal: it is referenced by only one other package, and its cache is package-global and session-scoped, so it must not be assumed safe for concurrent use across logical transactions within one session without explicit clearing.