Results for “p_file_control”
20 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.JL_JLBRPICR_XMLP_PKG package is a PL/SQL wrapper package generated by Oracle XML Publisher (BI Publisher) to support the concurrent program associated with the Brazilian Localization (JL) module in Oracle E-Business Suite. The naming convention follows the standard XML Publisher package pattern, where the _XMLP_PKG suffix denotes a report-level PL/SQL package that encapsulates the data model logic, before-report and after-report triggers, and parameter handling for an XML Publisher-based concurrent report. This package is classified as OTHER in the ETRM 12.2.2 documentation, indicating it is not part of the public APIs but rather an internal report-supporting object.
The report is associated with the Brazilian AP (Accounts Payable) interest collection functionality, as evidenced by its reference to the JL_BR_AP_INT_COLLECTION_TMP temporary table. The package exists in the APPS schema with a status of VALID across both Oracle EBS 12.1.1 and 12.2.2 releases, and depends only on the SYS.STANDARD package, reflecting its lightweight, report-specific nature.
Key Procedures and Functions
The package exposes four documented procedures and functions:
- BEFOREREPORT — A standard XML Publisher before-report trigger that executes prior to the report's data extraction phase. It is typically used to initialize session-level contexts, set date or organizational parameters, and prepare any package-level variables required by the data model query.
- AFTERREPORT — A standard XML Publisher after-report trigger invoked once the report output has been generated. Its role is to perform cleanup operations, release temporary resources, or reset package state after the report completes.
- C_COMPANY_NAME_HEADER_P — A function that returns the company name header value used in the report layout. The
C_prefix indicates a "constant" or "column" function that supplies a runtime value to the XML output, ensuring the correct legal entity or organization name appears on the printed report header. - CURRENCY_CODE_P — A function that returns the currency code applicable to the report run. This supports multi-currency environments where Brazilian AP interest collection reports must display amounts in the appropriate functional or transaction currency.
No parameter signatures are documented, and per ETRM metadata, only these four program units are exposed within the package.
Tables Accessed
The documented table accessed by this package is JL_BR_AP_INT_COLLECTION_TMP, referenced via an APPS synonym. This is a temporary staging table that holds data for the Brazilian AP interest collection process. The report package reads from this table to produce the XML output consumed by the XML Publisher template. The table typically contains intermediate rows generated by the interest collection concurrent process, including invoice references, interest amounts, currency values, and company identifiers needed by the C_COMPANY_NAME_HEADER_P and CURRENCY_CODE_P functions.
Usage Notes
This package is not intended for direct invocation by developers or end users. It is registered automatically by XML Publisher when the associated concurrent program definition is created or migrated. The package is invoked indirectly through the concurrent manager when the Brazilian AP interest collection report is submitted from the Submit Requests form or through the standard concurrent program interface. Because it belongs to the JL (Brazilian Localization) product family, its availability is contingent on the Brazilian Localization patch set being applied. Custom code should never call these procedures directly, as they are regenerated whenever the report definition is re-imported or the XML Publisher data model is modified. The package is referenced by no other packages in the EBS data dictionary, confirming its role as a leaf-level report artifact.