Search Results add_new_resource_assignments

Overview

PA_PLANNING_ELEMENT_UTILS is an Oracle EBS Applications (APPS) PL/SQL package that provides shared utility services for project planning elements within the Oracle Projects (PA) module. Its purpose is to centralize lookup, validation, and helper logic used across the planning, financial planning, resource assignment, and reporting components of Oracle Projects. Rather than duplicating queries against budgeting, resource, and role tables in each calling program, the package consolidates that access behind a stable API surface.

The package operates at the intersection of workplan management, financial plan versioning, task and resource assignment, and presentation-layer name resolution. It supports both the classic forms-based planning flows and the newer WebADI and reporting integrations that require the same lookup semantics. In EBS 12.1.1 and 12.2.2 the object is registered in the APPS schema with a status of VALID and is classified as an OTHER API, meaning it is intended primarily for internal Oracle Projects use rather than as a published extension point.

Key Procedures and Functions

The package exposes 24 documented procedures and functions grouped by functional area:

• Plan version resolution: GET_WORKPLAN_BVIDS, GET_FINPLAN_BVIDS, GET_COMMON_BUDGET_VERSION_INFO, GET_COMMON_BV_INFO_FCST, and GET_BV_NAME_FROM_ID retrieve budget version identifiers and descriptive names for workplan and financial plan versions, including forecast contexts.
• Name and attribute lookups: GET_TASK_NAME_AND_NUMBER, GET_PROJECT_TASK_LEVEL, GET_WBS_ELEMENT_NAME_FROM_ID, GET_RES_CLASS_NAME, GET_RES_TYPE_NAME, GET_PROJECT_ROLE_NAME, GET_SCHEDULE_ROLE_NAME, GET_SUPPLIER_NAME, GET_SPREAD_CURVE_NAME, and GET_MFC_COST_TYPE_NAME resolve surrogate identifiers to display names for tasks, WBS elements, resource classes, resource types, roles, suppliers, spread curves, and cost types.
• Structure and assignment helpers: GET_INITIAL_BUDGET_LINE_INFO, GET_FIN_STRUCT_ID, GET_PROJECT_UNCAT_RLMID, ADD_NEW_RESOURCE_ASSIGNMENTS, and GET_FND_MISS_CONSTANTS support plan line initialization, financial structure identification, uncategorized resource list member resolution, resource assignment creation, and common FND constants.

None of these subprograms publish a formal parameter list in the metadata; callers should inspect the package specification in the deployed instance before use.

Tables Accessed

The package reads and writes a defined set of APPS synonym-backed tables. Budgeting data is drawn from PA_BUDGET_LINES and PA_BUDGET_VERSIONS. Project context comes from PA_PROJECTS_ALL, PA_PROJECT_ASSIGNMENTS, and PA_PROJ_ELEMENT_VERSIONS. Planning options are read from PA_PROJ_FP_OPTIONS and PA_FIN_PLAN_TYPES_B. Resource and role definitions are sourced from PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_CLASSES_B, PA_RES_TYPES_B, PA_RBS_ELEMENTS, PA_PROJECT_ROLE_TYPES_B, and PA_PROJECT_ROLE_TYPES_TL. Spread curve definitions come from PA_SPREAD_CURVES_B, supplier data from PO_VENDORS, and structural relationships from PA_OBJECT_RELATIONSHIPS.

Usage Notes

PA_PLANNING_ELEMENT_UTILS is referenced by ten other database objects, notably PA_FIN_PLAN_UTILS, PA_TASK_ASSIGNMENT_UTILS, PA_TASK_ASSIGNMENTS_PUB, PA_RP_UTIL, PJI_REP_UTIL, and the task-assignment views PA_TASK_ASSIGNMENTS_AMG_V, PA_TASK_ASSIGNMENTS_V, PA_FP_WEBADI_NON_PERIODIC_V, and PA_FP_WEBADI_NP_CUSTOM_V. These dependencies indicate invocation from financial plan maintenance, task assignment processing, WebADI upload templates, and project reporting utilities. Because the package is not a formally published API, customizations should avoid direct modification and instead call the documented subprograms only as Oracle patches permit. The dependency on SYS.STANDARD and SYSTEM collection types such as PA_NUM_TBL_TYPE, PA_VARCHAR2_15_TBL_TYPE, and PA_VARCHAR2_1_TBL_TYPE further indicates that several routines accept or return bulk collections, so callers should account for set-based handling in custom integrations.