Search Results add_resource_list_member

Overview

PA_RESOURCE_PUB is a public PL/SQL API in the Oracle E-Business Suite Projects (PA) module that manages resource lists and their members. Resource lists group people, organizations, and other resource types so that they can be reused consistently across project planning, staffing, and reporting. The package exposes a set of documented public procedures and functions that allow callers to create, update, delete, fetch, and load resource lists and their associated members programmatically, rather than through the standard forms interface. The body carries a header referencing PAPMREPB.pls at version 120.2.12020000.2, dated 2012/07/18, indicating it has been maintained across the 12.1.1 and 12.2.2 release lines and that the interfaces are considered stable public API (classified as PUB in the ETRM metadata). The package is referenced by three other packages, confirming it is a shared building block for resource-list functionality elsewhere in the application.

Key Procedures and Functions

The API is organized around two functional groupings: resource-list operations and resource-member operations. The documented entry points include the following.

• CREATE_RESOURCE_LIST, INIT_CREATE_RESOURCE_LIST, EXEC_CREATE_RESOURCE_LIST, CLEAR_CREATE_RESOURCE_LIST — the create lifecycle. INIT initializes the in-memory structures, EXEC performs the actual insert, and CLEAR releases them.
• PROCESS_MEMBERS, LOAD_RESOURCE_LIST, LOAD_MEMBERS, FETCH_RESOURCE_LIST, FETCH_MEMBERS — the bulk load and retrieval routines used to populate or read a complete resource list and its members.
• UPDATE_RESOURCE_LIST, INIT_UPDATE_MEMBERS, EXEC_UPDATE_RESOURCE_LIST, CLEAR_UPDATE_MEMBERS — the update lifecycle for an existing list and its members.
• DELETE_RESOURCE_LIST — removes an existing resource list.
• ADD_RESOURCE_LIST_MEMBER, UPDATE_RESOURCE_LIST_MEMBER, DELETE_RESOURCE_LIST_MEMBER, SORT_RESOURCE_LIST_MEMBERS — member-level maintenance and ordering.
• CONVERT_LIST_NAME_TO_ID — resolves a resource-list name to its internal identifier.
• CONVERT_ALIAS_TO_ID — the routine most relevant to the user's search. It maps a resource or resource-group alias (a short, user-facing code) to the internal primary key, allowing custom code to translate an alias captured on an interface or import file into the numeric ID expected by downstream APIs.

Tables Accessed

The body references several base and interface tables through APPS synonyms. PA_RESOURCES holds the master resource definitions that CONVERT_ALIAS_TO_ID and the member routines resolve against. PA_RESOURCE_LISTS_ALL_BG stores the resource-list header records managed by CREATE_RESOURCE_LIST and UPDATE_RESOURCE_LIST. PA_RESOURCE_LIST_MEMBERS holds the individual members that make up each list and is the target of the member procedures. PA_RESOURCE_TYPES supplies the valid resource type codes used to validate the type parameters passed into the load and member routines. DBMS_SQL is used for dynamic SQL where the query shape varies by resource type, and PLITBLM provides PL/SQL index-by table helpers for the bulk member collections.

Usage Notes

PA_RESOURCE_PUB is normally invoked from custom PL/SQL, concurrent programs, or interface/import routines that need to build or maintain resource lists without a form session. The INIT/EXEC/CLEAR pattern used for create and update indicates callers should initialize the structures, execute the operation, then clear them within the same session. CONVERT_ALIAS_TO_ID is commonly called at the start of an import to translate an alias value into the ID required by ADD_RESOURCE_LIST_MEMBER and related procedures. Because these are public APIs, they can be called by name in custom code; callers should honor the NOCOPY OUT parameters and the PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR sentinel used for optional parameters, and should check the returned status and error code on every call.