Search Results pay_mx_isr_format37_info




Overview
Explore in AI Chat

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

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.