Results for “pa_res_list_upgrade_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_RES_LIST_UPGRADE_PKG is a technical upgrade utility within the Oracle E-Business Suite Projects (PA) module. Its purpose is to migrate legacy resource list definitions into the planning resource list framework introduced in later releases of Oracle Projects. The package carries the header identifier PARTPLRS.pls, revision 120.0, and is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer. In the EBS 12.1.1 and 12.2.2 environments, the package is owned by the APPS schema and is classified as an OTHER API, distinguishing it from the formal public APIs that carry full validation and error-handling contracts. It functions as a one-time or controlled conversion routine rather than a general-purpose transactional interface, and its presence in the ETRM inventory reflects its role in the historical data migration path from the older resource list model to the plan resource list model used by project planning and resource assignment features.

Key Procedures and Functions

The package exposes a single documented procedure, RES_LIST_TO_PLAN_RES_LIST. This procedure performs the conversion of a single resource list, identified by its resource list identifier, into the corresponding plan resource list structures. It accepts an optional commit flag and an optional initialization flag for the message list, following the standard Oracle API convention of accepting p_commit and p_init_msg_list parameters. It returns the standard API outcome values: a return status, a message count, and a message data string, allowing callers to detect success or failure and to retrieve any associated error text. No other procedures or functions are documented for this package in the 12.2.2 metadata, and the specification consists solely of this single conversion entry point.

Tables Accessed

The procedure reads and writes a broad set of Projects foundation tables through APPS synonyms. Source data is drawn from PA_RESOURCE_LISTS_ALL_BG and PA_RESOURCE_LIST_MEMBERS and its secure counterpart PA_RESOURCE_LIST_MEMBERS_S. Supporting setup and validation data is obtained from PA_RESOURCE_CLASSES_B, PA_RESOURCE_CLASSES_TL, PA_RESOURCE_TYPES, PA_RES_TYPES_B, PA_EXPENDITURE_TYPES, and PA_RES_FORMATS_B. Mapping between legacy resource types and planning formats is resolved through PA_RESTYPE_MAP_TO_RESFORMAT. The converted output is written into the planning resource list tables PA_PLAN_RES_DEFAULTS and PA_PLAN_RL_FORMATS and its sequence-backed table PA_PLAN_RL_FORMATS_S. DUAL and the PL/SQL table type PLITBLM are referenced for scalar evaluation and in-memory collection handling respectively.

Usage Notes

PA_RES_LIST_UPGRADE_PKG is normally invoked during upgrade or controlled data conversion activities, not during routine application use. It is referenced by two other packages, indicating that it is called programmatically by higher-level migration drivers rather than directly by end users. Because it is classified as an OTHER API with a technical upgrade lineage, it should be treated as internal and unsupported for custom development. Customers and consultants invoking it should do so from a controlled script or a wrapping concurrent program, passing p_commit explicitly to manage transaction boundaries and inspecting the returned status and message values before proceeding to the next resource list. Testing on a cloned instance prior to production execution is strongly advised.