Search Results create_xml_string

Overview

PAY_MX_ISR_FORMAT37_INFO is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It supports Mexican statutory payroll reporting by generating the XML payload required for the ISR (Impuesto Sobre la Renta) Format 37 declaration, an annual income tax withholding report filed with Mexican tax authorities. The package is declared with AUTHID CURRENT_USER and carries the header paymxformat37dt.pkh 120.1.12000000.1, indicating it was delivered as part of the Mexican localizations for Oracle Payroll. Its central responsibility is to assemble a CLOB-based XML document containing header information, transfer-level assignment action data, and footer totals for a specified person, legal employer, and tax year. The package is classified in the ETRM repository as an OTHER API and is not referenced by any other package, meaning it functions as a terminal reporting component invoked directly by the format 37 generation flow rather than as a reusable utility called by peers.

Key Procedures and Functions

• create_xml_string — The primary public function. It accepts identifiers for the archived payroll action, the archived person, the legal employer, the reporting year, and the PAI effective date, and returns the completed XML document as a CLOB. This is the entry point referenced when searching for the string "create_xml_string".
• get_headers — Populates the XML header section, including the version descriptor sourced from the main_block cursor (Version_Number=X, Version 1.1).
• get_footers — Populates the XML footer section, typically aggregating totals and closing elements for the generated document.
• fetch_format37_xml — Drives the retrieval of the format 37 data set and assembles the XML body content that sits between the header and footer sections.

These four documented program units correspond exactly to the ETRM metadata; no additional overloads or private helpers are documented beyond the internal cursors main_block, Transfer_Block, and c_get_asg_action.

Tables Accessed

• PAY_ASSIGNMENT_ACTIONS — Supplies the assignment action identifier used to build the TRANSFER_ACT_ID entry in the transfer block.
• PAY_PAYROLL_ACTIONS — Provides payroll action context for the selected archived action.
• PAY_ACTION_INFORMATION — Holds the parameter values consumed through pay_magtape_generic.get_parameter_value, such as TRANSFER_PAYROLL_ACTION_ID and TRANSFER_ACT_ID.
• DUAL — Used by the main_block and c_get_asg_action cursors to emit constant version and transfer identifiers.
• DBMS_LOB and DBMS_XMLQUERY — Referenced as standard PL/SQL packages for CLOB manipulation and XML generation.

Usage Notes

PAY_MX_ISR_FORMAT37_INFO is typically invoked from the Mexican payroll year-end reporting flow, either through a concurrent program that writes the ISR Format 37 XML output or from custom PL/SQL code that calls create_xml_string directly and consumes the returned CLOB. Because the package reads archived payroll action and assignment action data, it should be executed only after the relevant payroll runs have been archived and the format 37 parameters (notably TRANSFER_PAYROLL_ACTION_ID) have been populated in PAY_ACTION_INFORMATION. The AUTHID CURRENT_USER declaration means execution privileges follow the calling schema, so grants on the referenced PAY tables must be in place for the invoking user. The hard-coded version marker Version 1.1 should be considered when validating output against current SAT schema expectations in 12.1.1 or 12.2.2.