Results for “pa_fp_elements_pub”

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

Overview

PA_FP_ELEMENTS_PUB is a public PL/SQL package in the APPS schema that supports the financial planning (FP) element framework within Oracle Projects. Financial plan elements are the line-level entries within a project's financial plan, representing resources, tasks, amounts, and quantities that are planned, budgeted, or forecast against a project or task structure. The package provides the API layer through which financial plan elements are created, refreshed, copied, deleted, and maintained in a manner consistent with Oracle Projects' data model and business rules.

Its primary role is to keep the FP_ELEMENTS repository synchronized with upstream changes in project structure, resource assignments, and resource lists, while also supporting the population of default and bulk element records. Because it enforces referential and structural integrity across the various PA tables involved in planning, it is a foundational utility invoked by higher-level financial plan APIs and user-facing processes rather than a standalone entry point.

Key Procedures and Functions

The package exposes a broad set of documented program units that cluster into several functional areas:

• Refresh and synchronization: REFRESH_FP_ELEMENTS and REFRESH_RES_LIST_CHANGES update existing financial plan elements when underlying resource lists or assignments change, ensuring planned elements reflect current data.
• Creation: COPY_ELEMENTS, CREATE_ELEMENTS_FROM_VERSION, and INSERT_DEFAULT generate elements by duplicating existing ones, deriving them from a budget or plan version, or seeding default rows. INSERT_BULK_ROWS and INSERT_BULK_ROWS_RES provide set-based insertion of element records.
• Resource enablement: CREATE_ENTERABLE_RESOURCES and ADD_RESOURCES_AUTOMATICALLY establish which resources may be planned, while CREATE_CI_RESOURCE_ASSIGNMENTS and CREATE_ASSGMT_FROM_ROLLUPTMP build resource assignments, including from rollup temporary data.
• Deletion: DELETE_ELEMENTS and DELETE_ELEMENT remove one or many elements, and DELETE_TASK_ELEMENTS removes elements associated with tasks.
• Attribute queries: GET_ELEMENT_ID, GET_ELEMENT_PLANNABLE_FLAG, GET_PLAN_AMOUNT_EXISTS_FLAG, and GET_RESOURCE_PLANNING_LEVEL return identifiers and status flags used by callers to drive conditional logic.
• Task planability: MAINTAIN_PLANNABLE_TASKS and MAKE_NEW_TASKS_PLANNABLE ensure that tasks in the project structure are eligible for planning.

Tables Accessed

The package reads and writes across a range of PA tables via APPS synonyms. PA_FP_ELEMENTS is the central table holding plan element records, with PA_FP_ELEMENTS_S as its sequence source and PA_FP_EXCLUDED_ELEMENTS tracking elements withheld from plans. PA_PROJECTS_ALL, PA_PROJECTS, PA_TASKS, and PA_BUDGET_VERSIONS provide project, task, and version context. Resource-related logic draws on PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_LISTS_ALL_BG, PA_RESOURCE_LIST_MEMBERS, PA_FIN_PLAN_TYPES_B, and PA_PROJ_FP_OPTIONS. Rollup and change-impact processing uses PA_FP_ROLLUP_TMP, PA_PROJ_ELEMENT_VERSIONS, and PA_CI_IMPACTS.

Usage Notes

PA_FP_ELEMENTS_PUB is not intended for direct end-user invocation. It is called by higher-level financial planning packages, notably PA_FIN_PLAN_PUB, PA_FIN_PLAN_PVT, PA_FIN_PLAN_UTILS, PA_FP_REFRESH_ELEMENTS_PUB, PA_PROJ_TASK_STRUC_PUB, and PA_TASK_PUB1, which together drive Financial Plan and Budgeting forms and concurrent processes. Customizations that extend financial plan behavior should call the PUB procedures rather than manipulating PA_FP_ELEMENTS directly, preserving the integrity checks built into the API. The package is valid in both Oracle EBS 12.1.1 and 12.2.2.