Search Results init_update_resource_list

Overview

APPS.PA_PLAN_RES_LIST_PUB is a public PL/SQL API package in Oracle Projects (product code PA) that exposes the resource list functionality used during project planning. A planning resource list groups the resources — people, organizations, and resource classes — that may be assigned to planning elements such as tasks and budgets within a project. The package allows external and internal callers to create, maintain, and query planning resource lists, their associated resource formats, and their individual planning resource members programmatically rather than through the Oracle Projects forms.

Anchored on the business entity PA_PROJ_PLANNING_RESOURCE, the package is classified as PUB (public) and carries a compatibility rating of S (supported) with an active lifecycle. It is documented in the Oracle Projects API's, Client Extensions, and Open Interfaces Reference (120pjapi.pdf), and its source header indicates sustained maintenance through version 120.4. As part of the AMG (Application Module Group) design pattern, the package supports two invocation styles: a direct, record-based call to the create and update APIs, and a multi-step sequence in which initialization, loading, execution, and fetch operations are performed separately. The latter style accommodates third-party or integration software that cannot pass complex PL/SQL record structures in a single call.

Key Procedures and Functions

• CREATE_RESOURCE_LIST — Creates a planning resource list directly from PL/SQL records and tables, returning the generated resource list identifier, format identifier, and member identifiers.
• UPDATE_RESOURCE_LIST — Modifies an existing planning resource list using the same direct, record-based interface.
• DELETE_RESOURCE_LIST — Removes a planning resource list.
• DELETE_PLAN_RL_FORMAT — Deletes a resource format associated with a planning resource list.
• DELETE_PLANNING_RESOURCE — Removes an individual planning resource member from a resource list.
• INIT_CREATE_RESOURCE_LIST — Required first step of the sequential create process; initializes the internal data structures for a new resource list.
• INIT_UPDATE_RESOURCE_LIST — Required first step of the sequential update process; initializes structures for modifying an existing resource list.
• LOAD_RESOURCE_LIST — Loads resource list header attributes; required during creation and optional during update.
• LOAD_RESOURCE_FORMAT — Loads resource format information; optional in both the create and update sequences.
• LOAD_PLANNING_RESOURCE — Loads individual planning resource members into the resource list; optional in both sequences.
• EXEC_CREATE_RESOURCE_LIST — Required final step that commits the accumulated data as a new resource list.
• EXEC_UPDATE_RESOURCE_LIST — Required final step that applies accumulated changes to an existing resource list.
• FETCH_RESOURCE_LIST — Retrieves resource list header information after execution.
• FETCH_PLAN_FORMAT — Retrieves resource format details for the processed list.
• FETCH_RESOURCE_LIST_MEMBER — Retrieves individual member records belonging to the resource list.

Tables Accessed

The package reads and writes the principal Projects planning tables through APPS synonyms. PA_RESOURCE_LISTS_ALL_BG holds the resource list header records, while PA_RESOURCE_LIST_MEMBERS stores the individual resource members belonging to each list. PA_PLAN_RL_FORMATS and PA_RES_FORMATS_B define the display and grouping formats applied to planning resources. PA_RESOURCE_CLASSES_B and PA_RES_TYPES_B supply resource class and resource type validation data, and PA_PROJECTS_ALL provides project context for the lists. PA_IMPLEMENTATIONS enforces the standard multi-organization and installation controls applied by Oracle Projects public APIs. DUAL is used for single-row lookups and PLITBLM serves as the PL/SQL table type used to pass and return sets of identifiers between caller and API.

Usage Notes

PA_PLAN_RES_LIST_PUB is invoked when planning resource lists must be created or maintained without using the Project Workplan or Project Resource List forms. Typical callers include custom concurrent programs, project template setup utilities, and third-party scheduling or resource management tools integrating with Oracle Projects. Callers choosing the sequential interface must always invoke the appropriate INIT procedure before any LOAD procedure and must conclude with EXEC_CREATE_RESOURCE_LIST or EXEC_UPDATE_RESOURCE_LIST for the changes to take effect; the FETCH procedures are optional and used only to read back identifiers and members. The package is referenced by zero other packages, so it is not a dependency of standard Projects processing and is intended for direct invocation. As with all PA public APIs, it should be called within a properly initialized Oracle Applications session with the correct organization and implementation context established.