Search Results jmf_gta_trx_util




Overview
Explore in AI Chat

Overview

JMF_GTA_TRX_UTIL is a utility package owned by the APPS schema and classified in Oracle E-Business Tax (ETRM) as a UTIL object. It is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking session rather than the definer. The package header, sourced from JMFUGTAS.pls (header version 120.10.12010000.2, last shipped 2008/11/17) and created by Jim Zheng in April 2005, aggregates helper procedures and functions used across the E-Business Tax globalization (GTA) tax transaction flows. Its scope is deliberately generic: it supplies reusable mechanics for constructing and querying tax detail records, retrieving monetary and tax amounts from upstream invoice and line data, formatting dates and monetary values, resolving organizational and customer context, and producing debug or concurrent-program output. Because it is a UTIL rather than a TRANSACTION API, it does not own the tax determination or tax line creation business rules; it supports the modules that do. The package dates from the 11i-era GTA work and continues to ship, unchanged in substantive form, through EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The header declares the following documented members. Notably, Get_Bank_Info — the member matching the search term get_bank_info — is a procedure used to retrieve bank account information relevant to tax transactions.

  • Output_Conc — emits output to the concurrent program log/output file.
  • Create_Trxs and Create_Trx — bulk and single-record creation of tax transaction rows.
  • Get_Gtainvoice_Amount, Get_Gtainvoice_Original_Amount, Get_Gtainvoice_Tax_Amount — return header-level invoice and tax amounts from GTA tax invoice data.
  • Delete_Header_Line_Cascade — cascading deletion of header and line records.
  • Check_Taxcount_Of_Arline and Check_Taxcount_Of_Artrx — count checks against receivable lines and transactions.
  • Get_Arinvoice_Amount and Get_Arinvoice_Tax_Amount — retrieve receivable invoice and tax amounts.
  • Format_Date — date formatting helper.
  • Get_Primary_Phone_Number — resolves a party's primary phone number.
  • Get_Operatingunit — resolves the operating unit identifier.
  • Get_Customer_Name — resolves customer name for reporting.
  • Get_Arline_Amount, Get_Arline_Vattax_Amount, Get_Arline_Vattax_Rate — line-level amount and VAT tax amount/rate retrieval.
  • Get_Bank_Info — obtains bank information.
  • Verify_Tax_Line — validation routine for tax lines.
  • Get_Info_From_Ebtax — queries E-Business Tax for tax line identifiers, filtered to entity_code = 'TRANSACTONS' per the October 2005 revision.
  • Get_Tp_Tax_Registration_Number and Get_Arline_Tp_Taxreg_Number — tax registration number retrieval for third parties and receivable lines.
  • Debug_Output — diagnostic logging helper.
  • Get_AR_Batch_Source_Name — resolves the AR batch source name.
  • To_Xsd_Date_String — formats dates as XSD strings.
  • Format_Monetary_Amount — monetary value formatting helper.
  • Get_Invoice_Type — resolves the invoice type classification.

Tables Accessed

The documented ETRM metadata records no explicitly referenced base tables for this package in 12.2.2, and it is referenced by zero other packages. Functionally, the members above target GTA tax invoice and tax line tables, Oracle Receivables invoice, line, and batch source entities, and E-Business Tax registration data reached through Get_Info_From_Ebtax. These accesses are performed via APPS synonyms under the caller's privileges.

Usage Notes

JMF_GTA_TRX_UTIL is invoked as a supporting library rather than as an entry-point API. It is typically called from tax transaction processing code, concurrent programs that produce tax reports or debug output (via Output_Conc and Debug_Output), and custom extensions that must construct or interrogate GTA tax records. Because no shipped package references it, its consumers are found in the tax globalization programs and customer customizations that predate the 12.x E-Business Tax architecture.