Search Results get_resource_list_name




Overview
Explore in AI Chat

Overview

APPS.PA_PAUPGRRL_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite concurrent program report PAUPGRRL, a Projects (PA) utility used to upgrade resource lists into plan resource lists. The package is part of the standard report registration kit, where Oracle Reports produces XML output that is published through the Oracle Reports XML Publisher integration. The package body supplies the report triggers and the lookup values required by the report layout, and it drives the core upgrade call to PA_RES_LIST_UPGRADE_PKG.RES_LIST_TO_PLAN_RES_LIST. Its responsibilities are therefore narrow and mechanical: seed concurrent request context, resolve profile options, validate lookup data, execute the resource list conversion, and return status to the report engine.

Key Procedures and Functions

  • GET_COVER_PAGE_VALUES — Returns a BOOLEAN used by the report to populate cover page fields. It always returns TRUE, with an exception handler returning FALSE.
  • BEFOREREPORT — The principal initialization routine. It assigns P_CONC_REQUEST_ID from FND_GLOBAL.CONC_REQUEST_ID, resolves the PA_DEBUG_MODE and PA_RULE_BASED_OPTIMIZER profile options into package variables, validates the resource list (via GET_RESOURCE_LIST_NAME), loads the NO_DATA_FOUND message text from PA_LOOKUPS into C_NO_DATA_FOUND, and invokes PA_RES_LIST_UPGRADE_PKG.RES_LIST_TO_PLAN_RES_LIST with the P_RESOURCE_LIST parameter. Debug messages are emitted when PA_DEBUG_MODE is 'Y'.
  • AFTERREPORT — The closing report trigger, used to release report-level resources and finalize processing after the report body has been rendered.
  • GET_RESOURCE_LIST_NAME — The function referenced by the search term "get_resource_list_name." It validates and resolves the resource list name supplied to the report, returning a BOOLEAN success indicator. When it does not return TRUE, BEFOREREPORT raises INIT_FAILURE and aborts the run, making this function the primary input-validation gate for the concurrent program.
  • C_NO_DATA_FOUND_P — Accessor for the C_NO_DATA_FOUND package variable, exposing the message text retrieved from PA_LOOKUPS for use in the report layout.
  • C_DUMMY_DATA_P — Accessor for a dummy data package variable, typically used by the generated report kit to satisfy the report's expected bind/column contract.
  • C_RESOURCE_LIST_P — Accessor for the C_RESOURCE_LIST package variable holding the resolved resource list identifier.
  • C_RETCODE_P — Accessor for the C_RETCODE status variable, indicating whether the upgrade call completed successfully.

Tables Accessed

The package body contains an explicit query against PA_LOOKUPS, selecting the MEANING column where LOOKUP_CODE equals 'NO_DATA_FOUND' and LOOKUP_TYPE equals 'MESSAGE'. This read supplies the C_NO_DATA_FOUND value used by the report for empty-result handling. All other data access is delegated to PA_RES_LIST_UPGRADE_PKG, which performs the actual reads and writes against resource list and plan resource list tables; the report package itself does not manipulate those base tables directly.

Usage Notes

PA_PAUPGRRL_XMLP_PKG is invoked indirectly by the PAUPGRRL concurrent program through the Oracle Reports runtime; it is not a general-purpose API and is not called by other packages (ETRM records zero referencing packages). Because it is generated report code, its interface is stable but not intended for direct custom invocation. Administrators run the resource list upgrade concurrent program, and the package handles request context, profile resolution, lookup validation, and upgrade execution. Any troubleshooting of the "get_resource_list_name" behavior should focus on the AOL concurrent program parameters and on the PA_RES_LIST_UPGRADE_PKG conversion results, since the validation function simply gates execution before that package is called.