Results for “insert_bulk_rows_res”

20 results




Overview
Explore in AI Chat

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

Overview

APPS.PA_FP_ROLLUP_PKG is a financial planning rollup engine within Oracle Projects (PA). It is responsible for aggregating and denormalizing planned cost, burdened cost, revenue, and quantity amounts across the resource assignment hierarchy that underlies a project's financial plan. Financial plans in Oracle EBS are structured as a tree of resource assignments and tasks; child-level detail entered by planners must be periodically consolidated upward to parent assignments and to the top-level task so that reporting and budgeting views reflect accurate totals. PA_FP_ROLLUP_PKG performs this consolidation, maintains the parent assignment identifiers that define the rollup path, and refreshes the denormalized period tables used by planning inquiries and reports.

The package declares a substantial set of PL/SQL index-by table types (for example, resource assignment IDs, parent assignment IDs, task IDs, top task IDs, and various stored total cost and revenue columns on PA_RESOURCE_ASSIGNMENTS). These collections are used to bulk-fetch assignment rows, manipulate them in memory, and write results back efficiently — an important design consideration for plans with thousands of assignments. The package body header (PAFPRLPS.pls 120.1) dates to 2005, indicating a long-stable component of the financial planning infrastructure that has been carried forward through the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes twelve documented procedures. Their responsibilities group as follows:

  • POPULATE_LOCAL_VARS — Initializes the package-level PL/SQL table variables used throughout a rollup run, loading the assignment, task, and amount collections that the other procedures operate over.
  • ROLLUP_BUDGET_VERSION — Drives the rollup for a budget version, coordinating the refresh and aggregation steps against the planning version's assignments.
  • REFRESH_RESOURCE_ASSIGNMENTS — Re-reads and reconciles resource assignment data so subsequent processing works from current rows.
  • UPDATE_RES_PARENT_ASSIGN_ID — Establishes or corrects PARENT_ASSIGNMENT_ID values for resource assignments, defining the rollup hierarchy.
  • UPDATE_DENORM_PARENT_ASSIGN_ID — Propagates corrected parent assignment identifiers into the denormalized period tables.
  • INSERT_MISSING_RES_PARENTS — Creates parent assignment rows that are required for a complete rollup tree but do not yet exist.
  • INSERT_MISSING_PARENT_DENORM — Inserts the corresponding missing parent entries in the denormalized period structures.
  • INSERT_BULK_ROWS_RES — Performs bulk insertion of resource assignment rows, using the package's collection types for set-based processing.
  • REFRESH_PERIOD_DENORM — Rebuilds or refreshes PA_PROJ_PERIOD_DENORM so period-level amounts reflect the current plan.
  • ROLLUP_RES_ASSIGNMENT_AMOUNTS — Aggregates raw cost, burdened cost, revenue, and quantity from child assignments into their parents.
  • ROLLUP_DENORM_AMOUNTS — The procedure most often searched for; it rolls aggregated amounts into the denormalized period tables so planning inquiries and reports present consolidated figures.
  • DELETE_ELEMENT — Removes a specified element (assignment or denormalized row) from the rollup structures, typically during recalculation or cleanup.

Tables Accessed

The package reads and writes PA_RESOURCE_ASSIGNMENTS and PA_RESOURCE_ASSIGNMENTS_S, the primary stores of planning assignment detail and their stored total columns. PA_TASKS supplies the task hierarchy and top-task relationships. PA_PROJ_PERIOD_DENORM is the denormalized period table maintained by ROLLUP_DENORM_AMOUNTS and REFRESH_PERIOD_DENORM. PA_BUDGET_VERSIONS, PA_BUDGET_LINES, and PA_PROJ_FP_OPTIONS provide version context and planning options such as the financial plan level. PA_PROJECTS, PA_PROJECTS_ALL, and PA_PROJECT_TYPES_ALL provide project and project-type context; PA_RESOURCE_LIST_MEMBERS identifies assignment membership; and the temporary structures PA_FP_RA_MAP_TMP and PA_FP_ROLLUP_TMP stage intermediate rollup results. DUAL and PLITBLM support utility operations.

Usage Notes

PA_FP_ROLLUP_PKG is an internal engine rather than a public API; it is classified as OTHER and is not intended for direct customer invocation. It is referenced by twelve other packages, which call it when financial plan data changes — for example, when assignments are created, updated, or deleted, or when a plan version is submitted for aggregation. In practice it executes in the background of Oracle Projects financial planning forms and related concurrent processes, keeping the denormalized period table synchronized with the underlying assignment hierarchy. Customizations should avoid calling ROLLUP_DENORM_AMOUNTS or its companion procedures directly, because the package depends on populated package-level collections established by POPULATE_LOCAL_VARS; direct calls outside the supported flow risk inconsistent rollup results.