Search Results pa_pargcalg_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PA_PARGCALG_XMLP_PKG is the generated PL/SQL package body that supports the Oracle Projects concurrent report used to create Project Accounting calendar schedules in Oracle E-Business Suite 12.1.1 and 12.2.2. The package follows the standard Oracle Reports XML Publisher (XMLP) integration pattern, in which a report definition is bound to a package that exposes report-level trigger functions and placeholder accessor functions. The underlying report, commonly referenced as the "PRC: Create Calendar Schedules" or a related calendar generation program, invokes the package to drive calendar creation logic and to supply formatting values and messages back to the report layout.

The package header comment carries a version stamp of 120.1 dated 2008/01/03, indicating the file has been stable across multiple EBS releases. The package is classified as OTHER in ETRM and is not itself a public API; it is an internal supporting object that should not be called directly by customer code.

Key Procedures and Functions

Five documented functions are exposed, all of which conform to the Oracle Reports/XMLP package interface conventions:

  • BEFOREREPORT — The report-level BeforeReport trigger. It reads the report parameter p_run_mode and conditionally invokes PA_SCHEDULE_PUB.create_new_cal_schedules to generate calendar schedules. When the run mode is "R" (range), it passes both the start and end calendar names; when the mode is "S" (single), it passes the start calendar name for both arguments. The function returns TRUE on success and re-raises any exception to the caller.
  • AFTERREPORT — The report-level AfterReport trigger. In the delivered source it is effectively a no-op that returns TRUE, with the historical SRW user-exit calls commented out as part of the XML Publisher migration.
  • CF_COMPANY_NAME_FORMULA — A formula column that retrieves the ledger name from GL_SETS_OF_BOOKS joined to PA_IMPLEMENTATIONS and returns it as the report company name, storing the result in the CP_company_name placeholder.
  • CP_COMPANY_NAME_P — Placeholder accessor function returning the current value of CP_company_name to the report layout.
  • CP_NODATAFOUND_P — Placeholder accessor function returning the CP_NODATAFOUND flag, which the report uses to display the "no data found" condition.

Tables Accessed

The documented table reference is PA_IMPLEMENTATIONS, accessed in CF_COMPANY_NAME_FORMULA through its APPS synonym. It is joined to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID to resolve the set of books (ledger) name for the Oracle Projects implementation. No direct DML against tables is performed in this package; calendar schedule creation is delegated to PA_SCHEDULE_PUB.

Usage Notes

This package is invoked indirectly whenever the associated Oracle Projects concurrent program or report is run. It is not referenced by any other documented package, and it is not intended for direct invocation from forms, concurrent programs, or custom code. In particular, the "print_error" search term that led to this article corresponds to the PRINT_ERROR parameter historically used by the FND GETPROFILE user exit; in the delivered source those SRW user-exit calls are commented out, so PRINT_ERROR is no longer functionally active within this package. Customers should treat PA_PARGCALG_XMLP_PKG as read-only and target supported APIs such as PA_SCHEDULE_PUB for any customization.