Results for “get_bank_info”

12 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JMF_GTA_TRX_UTIL is a utility package body in the APPS schema that supports the Oracle E-Business Tax (EBTax) / Global Tax Accounting (GTA) functionality used by Oracle Process Manufacturing (OPM) and related financial modules. Its header comment identifies it as a collection of utility procedures and functions, authored by Jim Zheng and first created on 20-APR-2005, with the most recent source revision dated 2008/11/17. The package exists to centralize common tax-transaction helper logic — manipulating transaction records, retrieving invoice and tax amounts, resolving customer, bank, and operating-unit attributes, and formatting dates and monetary values. It is classified in the ETRM metadata as a UTIL package, meaning it is not a public API but an internal helper library invoked by other tax-related programs and forms.

Key Procedures and Functions

The documented procedure and function list reflects the package's role as a shared tax-processing toolkit:

  • Output_Conc — writes output to the concurrent program log/output, used for diagnostics during tax runs.
  • Create_Trxs / Create_Trx — create tax transaction records, both in bulk (plural) and singular variants.
  • Get_Gtainvoice_Amount / Get_Gtainvoice_Original_Amount / Get_Gtainvoice_Tax_Amount — return invoice amounts, original (unadjusted) amounts, and tax amounts for GTA invoices.
  • Delete_Header_Line_Cascade — removes header and associated lines in a cascading delete.
  • Check_Taxcount_Of_Arline / Check_Taxcount_Of_Artrx — validate the count of tax lines at the AR line and AR transaction level.
  • Get_Arinvoice_Amount / Get_Arinvoice_Tax_Amount — retrieve AR invoice amounts and their tax components.
  • Format_Date / To_Xsd_Date_String / Format_Monetary_Amount — standardize date and monetary value formatting, including XSD date strings for XML output.
  • Get_Primary_Phone_Number / Get_Operatingunit / Get_Customer_Name — resolve party, organization, and operating-unit attributes for tax documents.
  • Get_Arline_Amount / Get_Arline_Vattax_Amount / Get_Arline_Vattax_Rate / Get_Arline_Tp_Taxreg_Number — return AR line amounts, VAT tax amounts and rates, and Third Party tax registration numbers.
  • Get_Bank_Info / Verify_Tax_Line / Get_Info_From_Ebtax / Get_Tp_Tax_Registration_Number — gather bank details, validate tax lines, and pull registration data from EBTax tables.
  • Debug_Output — emit debug messages for troubleshooting.
  • Get_AR_Batch_Source_Name — return the AR batch source name associated with a transaction.
  • Get_Invoice_Type — added for R12.1, returns the invoice type classification.

No parameter lists are documented in the supplied metadata; each routine should be treated as an internal helper whose exact signature is confirmed by inspecting the deployed source in the target instance.

Tables Accessed

The ETRM metadata does not enumerate the base tables referenced by this package body, and no APPS-synonym table list was captured. Function names strongly imply access to AR transaction and line tables, EBTax tax-line and tax-registration tables, and GTA invoice tables. Because the documented table list is empty, the precise schema objects should be identified from the package source or by querying the data dictionary on the target environment.

Usage Notes

JMF_GTA_TRX_UTIL is not itself an exposed API and is not referenced by any other documented packages in the ETRM metadata. It is invoked indirectly by EBTax/OPM tax-processing programs and forms that require the shared helpers described above. Typical invocation points include concurrent tax calculation and accounting programs, AR-related tax validation routines, and custom extensions that reuse the formatting and retrieval utilities. Developers extending tax functionality should call the individual functions rather than reimplementing their logic, and should verify signatures against the installed version because the source history indicates ongoing modifications through at least 2008. The package is common to both EBS 12.1.1 and 12.2.2, with the R12.1-specific Get_Invoice_Type addition reflecting the multi-release support.