Search Results submit_record




Overview
Explore in AI Chat

Overview

PAY_NO_ALTINN_TFR_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Norwegian statutory payroll localization delivered with Oracle Payroll and supports the electronic transfer of payroll reporting data to the Altinn government reporting portal. Altinn is the Norwegian public reporting infrastructure through which employers submit mandatory payroll and end-of-year reporting to tax authorities. The package acts as the integration layer between Oracle Payroll concurrent processing and the Altinn transfer records persisted in the PAY_NO_ALTINN_TRANSFERS table.

The package is classified as an OTHER API rather than a public or private API. It is therefore not published as a stable, customer-facing interface; it is intended for internal use by the Norwegian payroll localization and should be called only by Oracle-provided components unless the calling code is fully controlled by the implementation team. The header comment indicates the package specification was last versioned at 120.0.12020000.1 in January 2013, which corresponds to the R12.2 code line. The package exposes four documented entry points.

Key Procedures and Functions

  • GET_PARAMETER_VALUE — A function that resolves a named parameter value for a given payroll action. It takes a payroll action identifier and a token name and returns the corresponding value. This is used to read configuration or setup values (for example Altinn-specific tokens) associated with the payroll action being processed.
  • SAVE_FOR_LATER — A procedure that records a transfer in the Altinn transfers table without an immediate government receipt, so the record can be submitted at a later time. It carries identifiers for the transfer, concurrent request, payroll action, report name, run effective date, shipment reference, organization and business group, and manages the object version number and a returned save status.
  • SUBMIT_RECORD — The procedure most relevant to the search term "submit_record". It records the submission outcome for a previously staged Altinn transfer, including receipt and receipt-status information returned by the Altinn interface. It accepts the transfer identifier, concurrent request, payroll action, report details, organization and business group, the receipt identifier, receipt status, receipt text, and object version number, and returns a status text.
  • DELETE_TRANSFER_RECORD — A procedure that removes a transfer record identified by its transfer identifier and object version number and returns a status string.

Tables Accessed

The package reads and writes the APPS synonym PAY_NO_ALTINN_TRANSFERS, which is the core repository for Altinn transfer records. Each row represents an outbound submission or a staged transfer and carries the receipt and status values that SAVE_FOR_LATER and SUBMIT_RECORD populate. The package also references PAY_PAYROLL_ACTIONS, the standard Oracle Payroll action table, to resolve payroll action context, including the parameter values returned by GET_PARAMETER_VALUE. No other tables are documented for this package.

Usage Notes

The package is normally invoked from the Norwegian payroll localization, including concurrent programs that generate and transmit Altinn reporting, and from any supporting forms or custom code that manage transfer records. Because the API classification is OTHER, Oracle does not guarantee backward compatibility of the signature across patches. Implementations that call SUBMIT_RECORD or the other routines directly should treat the interface as internal, validate object version numbers on update and delete operations to respect row-level locking conventions, and re-test custom calls after applying payroll localization patches.