Search Results pa_paxacrpt_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.PA_PAXACRPT_XMLP_PKG package is the database-side PL/SQL library that supports the Oracle Projects report "PAXACRPT" (Project Billing and Capitalization Exception Report). It provides the report execution logic required by Oracle Reports and the Oracle E-Business Suite concurrent manager, exposing the runtime binding variables, global cursors, and helper functions that Oracle Reports implicitly calls at report generation time. The package is defined with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling user rather than the owner, which is standard for Oracle Reports integration packages in the EBS 11i/12.x architecture.

The _XMLP_PKG suffix indicates this is the XML Publisher (BI Publisher) variant of the report package, used when the report is registered as an XML-based concurrent program. The package header, as documented in the ETRM metadata for 12.2.2 (revision 120.0, dated 2008/01/02), defines the package specification only; the body contains the actual procedural logic performed at report run time.

Key Procedures and Functions

The package exposes 16 documented procedures and functions, corresponding to the standard Oracle Reports integration entry points and report-level column formulas:

  • GET_COVER_PAGE_VALUES — Populates the report cover page global variables, such as company name and run parameters, prior to report rendering.
  • BEFOREREPORT — The Oracle Reports BeforeReport trigger handler; invoked before the report's main query executes to initialize globals and validate parameters.
  • GET_COMPANY_NAME — Retrieves the operating company (legal entity) name used in the report header.
  • AFTERREPORT — The Oracle Reports AfterReport trigger handler; performs post-report processing and cleanup.
  • FMT — A numeric formatting helper that renders numbers according to the report's format mask.
  • CF_CORBFORMULA — Column formula returning the classification/description of the project type (e.g., Billable, Capital).
  • C_FMT_MASKFORMULA — Column formula supplying the format mask applied to numeric report output.
  • CF_EXCEPTION_MSGFORMULA — Column formula translating an exception code into its display message.
  • CF_REJECTION_REASONFORMULA — Column formula translating a rejection code into its display reason.
  • CP_ROUND_CURRENCY_1_P, CP_ROUND_CURRENCY_2_P, CP_ROUND_CURRENCY_P — Accessors returning the currency rounding factors used in the report's monetary calculations.
  • C_COMPANY_NAME_HEADER_P — Accessor returning the company name header string.
  • C_NO_DATA_FOUND_P — Accessor returning the "no data found" indicator string.
  • C_DUMMY_DATA_P — Accessor returning the dummy data indicator value.
  • C_RETCODE_P — Returns the C_RETCODE package global, the return code used to signal report success or failure back to the concurrent manager. This is the object the user searched for as c_retcode_p.

Tables Accessed

The package references two tables via APPS synonyms:

  • PA_IMPLEMENTATIONS — The Oracle Projects implementation/operating unit table, read by GET_COMPANY_NAME and cover-page logic to resolve the operating company and implementation-specific attributes.
  • DUAL — Used for singleton function calls and global variable initialization.

Usage Notes

This package is invoked automatically by Oracle Reports when the PAXACRPT report runs as a concurrent program. It is not intended for direct invocation by custom code. The C_RETCODE_P function is the standard mechanism by which Oracle Reports returns its completion status to the concurrent manager; a non-zero value indicates report failure. Because the package is documented as being referenced by zero other packages, it is a leaf-level report integration package with no downstream PL/SQL dependencies.