Search Results pay_za_archive_dbitems_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG is a PL/SQL package that belongs to the Oracle Payroll localization layer for South Africa (the "ZA" prefix in the name designates the country-specific module). Its declared purpose is to archive and preserve the Oracle FastFormula database items (DBIs) and routing definitions that the South African payroll legislation requires for statutory reporting and historical payroll reconstruction. The package is declared with AUTHID CURRENT_USER, meaning that its SQL statements execute under the privileges of the invoking user rather than the package owner, which is typical for APPS-owned maintenance utilities that operate on shared FastFormula metadata. The header comment ($Header: pyzaadbi.pkh 120.3 2005/07/04) shows the package was last revised in the 11i era and carried forward unchanged into EBS 12.1.1 and 12.2.2, indicating a stable, low-change utility rather than an actively evolving API. It is classified in ETRM as an OTHER API and is not referenced by any other documented package, so it functions as a self-contained administrative routine.

Key Procedures and Functions

The package exposes exactly two public procedures, both with no documented return values:

  • CREATE_ARCHIVE_ROUTES — Creates the FastFormula route definitions used to drive the archival extraction of South African payroll database items. This is the entry point that establishes the routing framework before individual database items are archived; users searching for "create_archive_routes" are typically looking for the procedure that seeds or refreshes FF_ROUTES and its associated route-context, parameter, and parameter-value records.
  • CREATE_ARCHIVE_DBI — Takes a single database item name (documented as p_item_name varchar2) and creates the archived database item definition for that specific FastFormula item. It is invoked iteratively, once per DBI that requires archiving, and depends on the routes established by CREATE_ARCHIVE_ROUTES.

No parameter lists are invented here; aside from the documented p_item_name argument of CREATE_ARCHIVE_DBI, the metadata does not specify additional signatures.

Tables Accessed

The package operates primarily against the Oracle FastFormula metadata schema. The documented tables include:

Usage Notes

Because the package is referenced by no other documented object, it is not part of a call chain from standard payroll processing. It is an administrative or one-time migration utility, typically invoked manually — for example from SQL*Plus as APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG.CREATE_ARCHIVE_ROUTES — during South African payroll setup, upgrade, or archive configuration. The correct invocation order is CREATE_ARCHIVE_ROUTES first to establish the route framework, followed by CREATE_ARCHIVE_DBI for each database item to be preserved. It is not intended for ad-hoc custom development, and because it was frozen at version 120.3, any enhancement should be treated as a customization rather than a supported API extension.