Search Results inv_group_name




Overview
Explore in AI Chat

Overview

PA_PAXRWDIF_XMLP_PKG is the Oracle Reports 6i XML Publisher (XMLP) wrapper package for the Oracle Projects invoice review and distribution report associated with the PAXRWDIF report definition. Its role is administrative and declarative rather than transactional: it establishes the runtime environment for a concurrent report that presents project invoice data along with company, invoice format, and invoice grouping descriptive information. The package does not perform any insert, update, or delete operations; it resolves lookup identifiers into descriptive names and exposes those names to the report layout through placeholder functions.

The package header/body pair was created under the standard XMLP naming convention, in which the "_XMLP_PKG" suffix indicates a generated report integration package. The body carries a revision marker dating to 2008 (PAXRWDIFB.pls 120.0) and contains commented-out calls to the FND SRWINIT and FND SRWEXIT user exits, reflecting Oracle's migration from the older Oracle Reports user-exit model to the XML Publisher architecture in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

  • GET_COMPANY_NAME — Declares a local variable typed against GL_SETS_OF_BOOKS.NAME and assigns it to the package-level variable C_COMPANY_NAME_HEADER. Returns TRUE on success and FALSE on any exception, making it a defensive accessor that cannot propagate an error into the report run.
  • BEFOREREPORT — The principal initialization routine. It declares a local exception and two typed variables (INV_FORMAT_NAME from PA_INVOICE_FORMATS.NAME and INV_GROUP_NAME from PA_INVOICE_GROUPS.NAME). When the report parameters P_FORMAT and P_GROUP are populated, it queries the corresponding descriptive names and assigns them to the package globals C_FORMAT_NAME and C_GROUPING_NAME. It returns TRUE unconditionally.
  • AFTERREPORT — The companion cleanup routine. It contains a commented-out SRWEXIT call and returns TRUE; no procedural logic remains after the XMLP conversion.
  • C_COMPANY_NAME_HEADER_P — Placeholder function returning the varchar2 value of C_COMPANY_NAME_HEADER to the report.
  • C_FORMAT_NAME_P — Placeholder function returning the resolved invoice format name.
  • C_GROUPING_NAME_P — Placeholder function returning the resolved invoice grouping name, which is the value surfaced when a user searches on "inv_group_name".

Tables Accessed

  • PA_INVOICE_FORMATS — Read-only lookup on INVOICE_FORMAT_ID when the parameter P_FORMAT is supplied; the NAME column is retrieved to populate C_FORMAT_NAME.
  • PA_INVOICE_GROUPS — Read-only lookup on INVOICE_GROUP_ID when the parameter P_GROUP is supplied; the NAME column is retrieved to populate C_GROUPING_NAME and to expose INV_GROUP_NAME to the report output.
  • GL_SETS_OF_BOOKS — Referenced indirectly through the %TYPE anchored declaration of l_name in GET_COMPANY_NAME; the routine as documented does not execute a query against it.

Usage Notes

The package is invoked exclusively by the Oracle Reports runtime when the PAXRWDIF concurrent program executes. BEFOREREPORT fires once after parameter entry, BEFORE the query is executed, and is therefore the correct place for these single-row lookups. Because both lookups are guarded by IS NOT NULL checks, omitting P_FORMAT or P_GROUP leaves the corresponding global NULL rather than raising NO_DATA_FOUND, so users may run the report without a format or grouping restriction.

No other package in the APPS schema references PA_PAXRWDIF_XMLP_PKG, confirming its status as a leaf-level report wrapper. Customizations should avoid modifying the package body directly, since Oracle regenerates XMLP report packages; format or grouping security should instead be enforced through the underlying PA_INVOICE_FORMATS and PA_INVOICE_GROUPS configuration. The absence of SRWINIT/SRWEXIT calls is expected and should not be "restored" during an upgrade to 12.2.2.