Search Results create_gtn_xml_data

Overview

PAY_PAYGTN_PKG is an Oracle E-Business Suite payroll package owned by the APPS schema and validated against release 12.1.1 and 12.2.2. Its name reflects the "GTN" (Generic Transmission / Generate Transmission) processing used by Oracle Payroll for external reporting and magnetic media style extracts. The package functions as an orchestration and utility layer that drives extraction, archival, and XML generation activities tied to payroll run results, assignment actions, and balance data. Within the ETRM registry the object is classified as OTHER rather than a public API, indicating that it is an internal implementation package invoked by higher-level payroll processing programs and by other packaged code rather than being documented as a supported extension point. It exposes nine documented procedures and functions and depends on the generic magnetic tape utility package PAY_MAGTAPE_GENERIC alongside STANDARD and DUAL.

Key Procedures and Functions

The documented routines fall into several functional groups:

• RANGE_CURSOR — a cursor-returning routine used to scope the set of payroll records selected for processing by range or grouping criteria.
• ACTION_CREATE_BRA — creates the assignment action record associated with a BRA (balance-related adjustment or action) outcome produced during transmission processing.
• ACTION_CREATION — the general routine that instantiates assignment action rows required to reflect the processing performed by the package.
• SORT_ACTION — applies ordering logic to the action set so downstream processing and reporting occur in a deterministic sequence.
• GET_PARAMETER — retrieves runtime parameters, typically from the concurrent program definition or input values, for consumption during execution.
• ARCHIVE_INIT — initializes the archival context, establishing the session state required before archive records are written.
• ARCHIVE_CODE — performs the archive write of the qualifying records or code values gathered during the run.
• ARCHIVE_DEINIT — tears down the archival context and releases resources once archiving is complete.
• CREATE_GTN_XML_DATA — assembles the extracted payroll data into XML form for transmission or downstream consumption.

Tables Accessed

The package reads and writes a defined set of payroll tables through APPS synonyms. PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S are used to create and maintain the action records that trace processing. PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, and PAY_INPUT_VALUES_F supply the calculated payroll results and input values that form the transmission payload. Balance-related tables — PAY_BALANCE_DIMENSIONS, PAY_BALANCE_TYPES, PAY_BALANCE_VALIDATION, and PAY_DEFINED_BALANCES — provide the balance definitions and validation rules applied to the extracted values. PAY_US_RPT_TOTALS holds summarized US reporting totals referenced during extraction. FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_REQUESTS, and FND_PRODUCT_INSTALLATIONS support concurrent program parameter retrieval and installation context. DUAL and STANDARD serve structural and utility purposes.

Usage Notes

PAY_PAYGTN_PKG is not intended for direct invocation by end users or custom extensions. It is called from within payroll concurrent program flows, principally the generic magnetic tape loading and related extract programs, and it is referenced by PAY_GTNLOD_PKG, PAY_US_XDO_REPORT, and PQP_TIAALOD_PKG. Because it is a dependent, internal package, customers should treat it as subject to change between patch levels and should not embed direct calls in bespoke code. Any modification must be performed through supported extension mechanisms rather than by altering the package body, as the object is shipped under Oracle proprietary and confidential terms.