Search Results pay_no_ssb_codes




Overview
Explore in AI Chat

Overview

PAY_NO_SSB_CODES is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an OTHER API within the Oracle Payroll module (PAY). Its name and structure indicate that it supports the Norwegian statutory reporting requirement commonly referenced as "SSB" (Statistics Norway) codes. The package provides an in-memory caching and lookup mechanism for mapping payroll run results and input values to external statutory reporting codes and their associated detail values.

The package is significant in the context of the search term "cobsmart payer id" because Norwegian statutory reporting and payer identification handling in Oracle Payroll frequently involves integration with external reporting agencies such as COBSMART. The SSB code cache maintained by this package supplies the reporting code context (element type, input value, and run result associations) that downstream statutory reporting processes — including payer identification and remittance data submissions — rely upon. The package header is dated 2007 and is flagged "noship" in its version string, indicating it is retained for backward compatibility with the Norwegian localization rather than actively shipped as a new deliverable in 12.1.1 or 12.2.2.

Functionally, the package builds and manages a session-level cache of SSB codes for a given assignment action and effective date, allowing repeated lookups and total value computations without repeatedly querying the base payroll tables.

Key Procedures and Functions

  • POPULATE_TABLE — Populates the internal cache table with element name, element type identifier, and SSB code. Only elements processed for the specified assignment action are selected, and both direct and indirect elements linked with a non-null SSB code are included. Returns 'Y' on success and 'N' on failure.
  • SET_NEXT_CACHED_CODE — Sets the next cached SSB code value for subsequent retrieval within the cache sequence.
  • CLEAR_CACHED_VALUE — Clears the cached table record associated with a given SSB code. Returns 'Y' on success and 'N' on failure.
  • GET_TOTAL_RESULT_VALUE — Returns the total result value accumulated for a specified SSB code, based on the assignment action and code supplied.
  • GET_NEXT_CACHED_CODE — Returns the next cached SSB code from the internal cache.
  • GET_CURRENT_CACHED_CODE — Returns the currently active cached SSB code.
  • CLEAR_CACHED_TABLE — Clears the entire cache table, typically invoked after processing completes.

Internally, the package defines an ssb_codes_rec record type capturing element type ID, input value ID, run result ID, SSB code, and additional detail, along with a globally indexed cache table and global variables tracking next and current codes and the cache index.

Tables Accessed

The package reads and writes payroll data through APPS synonyms. PAY_ASSIGNMENT_ACTIONS supplies the assignment action context used by POPULATE_TABLE. PAY_ELEMENT_TYPES_F and PAY_ELEMENT_TYPE_EXTRA_INFO provide element type definitions and the extended attributes from which SSB codes are derived. PAY_INPUT_VALUES_F supplies input value definitions, while PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES provide the calculated payroll results used to compute totals via GET_TOTAL_RESULT_VALUE. PAY_USER_ROWS_F and PAY_USER_TABLES hold user-defined row and table definitions linked to element entries. FND_SESSIONS is referenced for session context, and PLITBLM is the standard Oracle Forms PL/SQL table utility used to maintain indexed PL/SQL tables.

Usage Notes

PAY_NO_SSB_CODES is invoked from the Oracle Payroll Norwegian localization processing flows, typically during payroll run result evaluation and statutory reporting generation. Because it relies on session context (FND_SESSIONS) and PL/SQL table caching (PLITBLM), it is designed for use within a single logical processing session — the cache is populated with POPULATE_TABLE, traversed using GET_NEXT_CACHED_CODE and GET_CURRENT_CACHED_CODE, queried for totals with GET_TOTAL_RESULT_VALUE, and finally released with CLEAR_CACHED_VALUE or CLEAR_CACHED_TABLE.

The package is referenced by one other package, indicating it acts as a supporting utility rather than a top-level entry point. Customizations and statutory reporting extensions, including those interfacing with external payer identification schemes, should call the documented functions rather than querying the underlying payroll tables directly, to remain consistent with the cached SSB code semantics and to avoid invalidating reporting totals.