Results for “c_report_type”
41 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FF_ARCHIVE_API is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite (documented against 12.1.1 and 12.2.2). It provides the archive management API for the Oracle Payroll "Flexfield" (FF) infrastructure, specifically the mechanism that stores and retrieves archived flexfield context values associated with assignment actions and payroll actions. In Payroll processing, context values captured at the time an assignment action or payroll action runs may need to be preserved even after the underlying configuration changes. FF_ARCHIVE_API encapsulates the business logic that validates inbound archive parameters and then writes those values into the archive items and archive item context tables through the appropriate row handlers. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user, and it exposes a global PL/SQL table type, context_tab_type, used to pass collections of context names into its procedures.
Key Procedures and Functions
The ETRM documentation records two public procedures for this package: CREATE_ARCHIVE_ITEM and UPDATE_ARCHIVE_ITEM.
CREATE_ARCHIVE_ITEM— Inserts values into FF_ARCHIVE_ITEMS and FF_ARCHIVE_ITEM_CONTEXTS after validating the inbound parameters. It accepts a validation control flag, generates the archive item primary key from a sequence, and requires a user entity identifier (foreign key to FF_USER_ENTITIES), the archive value, the action identifier (assignment or payroll action), and a legislation code. It also accepts an optional archive type that defaults to an assignment action identifier, and up to four context name/value pairs. Legislative context names supplied by the caller are translated to their core equivalents; core context names may also be passed directly. The object version number is maintained by the row handler logic.UPDATE_ARCHIVE_ITEM— Applies the same validation and row handler discipline to modify an existing archive item and its associated context rows.
Because the parameter lists are not reproduced here, callers should consult the package specification header directly for exact argument ordering; the excerpt documents only the semantics of the create operation.
Tables Accessed
The package reads and writes a defined set of Payroll and Flexfield tables through APPS synonyms. FF_ARCHIVE_ITEMS and FF_CONTEXTS hold the archived values and their context definitions. PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS are the parent action records that archive items reference. PAY_ACTION_INTERLOCKS provides the linking mechanism between actions. PAY_LEGISLATION_CONTEXTS supports translation of legislative context names into core context names. FF_ARCHIVE_ITEM_CONTEXTS stores the resolved context name/value pairs, and PAY_REPORT_FORMAT_ITEMS_F and PAY_REPORT_FORMAT_MAPPINGS_F supply report format metadata used during validation. DUAL is used for sequence lookups and simple validations.
Usage Notes
FF_ARCHIVE_API is an internal infrastructure API rather than an end-user entry point. It is invoked indirectly by Payroll forms, concurrent processes, and other Payroll packages whenever assignment or payroll action context values must be persisted for later retrieval. The ETRM metadata indicates that 19 other packages reference it, confirming its role as a shared dependency across the Payroll flexfield layer. Custom code should call the procedures only within the same transaction as the action being archived, and should not attempt to populate the underlying archive tables directly. Because the package relies on row handlers for object version numbering and validation, bypassing the API risks inconsistent archive state.