Search Results get_parameter_filename




Overview
Explore in AI Chat

Overview

IGF_AP_LOADER_LAUNCH_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an OTHER API within the E-Business Tax (EBTax) / Internet Government Functions (IGF) product family. It functions as the launch wrapper that drives the Accounts Payable tax loader process. In global implementations, tax content such as tax regimes, taxes, rates, jurisdictions, and related configuration must be periodically loaded from external sources (supplier feeds, country-specific statutory files, or Oracle-provided content extracts) into the EBS tax repository. Running and monitoring such loads through the standard concurrent manager framework requires orchestration logic: resolving the loader executable, submitting it as a concurrent request, capturing the associated outcomes, and surfacing diagnostic messages to the caller.

IGF_AP_LOADER_LAUNCH_PKG provides precisely this orchestration layer. It abstracts the mechanics of concurrent program submission from the code or interface that needs to initiate a loader run, so that callers need not resolve program definitions, request identifiers, or message text themselves. The package is a valid object in the APPS schema in both 12.1.1 and 12.2.2, and it depends only on the SYS STANDARD package at the platform level, indicating a lightweight implementation focused on submission control rather than on heavy data transformation.

Key Procedures and Functions

The ETRM metadata documents three callable units within this package. Parameter lists are not published in the metadata and are therefore not reproduced here; only the documented purpose of each unit is described.

  • MAIN_PROCESS — The principal entry point of the package. It encapsulates the launch sequence for the AP tax loader, coordinating retrieval of the concurrent program definition, submission of the load request, and management of the overall process flow. Callers invoke this procedure to trigger a loader run end to end.
  • GET_PARAMETER_FILENAME — A retrieval function that returns the file name parameter associated with the loader invocation. It allows the launch logic (or its callers) to determine which input file is designated for processing, typically as part of building the concurrent program argument list.
  • GET_MESSAGE_CLASS — A retrieval function that returns the message class used for error, warning, and informational message lookup. This supports consistent, message-dictionary-driven feedback rather than hard-coded text when reporting the outcome of a loader run.

Tables Accessed

The package references the following tables through APPS synonyms, reflecting its role as a concurrent program launcher rather than a data loader:

  • FND_CONCURRENT_PROGRAMS — Queried to resolve the concurrent program definition for the AP tax loader, including its application, executable, and parameter metadata. This lookup is required before the program can be submitted.
  • FND_CONCURRENT_REQUESTS — Used to submit and track the loader request. The package obtains the request identifier generated at submission and can correlate subsequent status or completion information with the originating call.

Usage Notes

IGF_AP_LOADER_LAUNCH_PKG is an internal EBS package and is not typically exposed through a user-facing form. It is invoked programmatically—most commonly from tax configuration flows, concurrent program logic, or custom integration code—whenever the AP tax loader must be initiated under concurrent manager control. Because it is classified as OTHER rather than a public/private API, it should be treated as an ETRM-documented internal object: the safest approach is to call it only where Oracle-delivered code or documented configuration flows already rely on it, and to validate any direct dependency during upgrades from 12.1.1 to 12.2.2. Administrators reviewing loader execution should trace resulting requests through FND_CONCURRENT_REQUESTS and the concurrent manager output files. The package is referenced by no other documented packages, which underscores its role as a leaf-level launch utility rather than a shared library of tax business logic.