Search Results get_all_higher_tasks




Overview
Explore in AI Chat

Overview

The APPS.PA_PROCESS_ACCUM_COMMITMENTS package body is a PL/SQL program unit within Oracle E-Business Suite that supports the accumulation of commitment balances for projects and tasks. Commitments represent encumbered or obligated funds — such as purchase orders, requisitions, and other pre-expenditure commitments — that must be tracked alongside actual costs and budgets in Oracle Projects. This package operates as a processing engine that walks the project and task hierarchy, determining which accumulation records (headers) apply to a given commitment line, and then writes the corresponding commitment accumulation rows.

The package is classified as an OTHER API in ETRM for both Oracle EBS 12.1.1 and 12.2.2. It is intended for internal use by the Oracle Projects accumulation framework rather than as a public, customer-callable interface. Its primary role is to process commit-related task sets and resolve the higher-level task rollups required for commitment aggregation.

Key Procedures and Functions

The documented package exposes six procedures or functions:

  • PROCESS_IT_TASKS_CMT — Drives commitment accumulation processing for the applicable task set, coordinating header resolution and the insertion/update of commitment records.
  • PROCESS_IT_PP_TASKS_CMT — Processes commitment accumulation for project-to-project (PP) task combinations, applying the same accumulation logic to these cross-project relationships.
  • PROCESS_IT_YT_TASKS_CMT — Handles commitment accumulation for year-to-date (YT) task processing, ensuring period-cumulative figures are populated correctly.
  • PROCESS_IT_YT_PT_TASKS_CMT — Processes commitment accumulation for year-to-date combined with project-to-date (PT) task combinations, reconciling cumulative and period-specific results.
  • PROCESS_IT_YT_PP_TASKS_CMT — Processes commitment accumulation for year-to-date combined with project-to-project task combinations.
  • GET_ALL_HIGHER_TASKS_CMT — A helper function that returns the set of higher-level (parent) tasks above a given task, which is essential for rolling commitment amounts up the task hierarchy.

The procedures share a common pattern: they identify the relevant accumulation header, resolve task hierarchies via GET_ALL_HIGHER_TASKS_CMT, and then delegate lower-level work to supporting utilities.

Tables Accessed

  • PA_PROJECT_ACCUM_HEADERS and PA_PROJECT_ACCUM_HEADERS_S — The header table and its APPS synonym/sequence-supporting object. These store the definition of each accumulation (for example, the project, accumulation type, and period range) that commitment processing must honor. The header drives which rows are generated.
  • PA_PROJECT_ACCUM_COMMITMENTS — The core transaction table into which accumulated commitment amounts are inserted or updated. It stores the commitment balance per project, task, and period.
  • PA_TASKS — Read to resolve the task structure, validate task identifiers, and build the parent-child relationships needed for rollup through GET_ALL_HIGHER_TASKS_CMT.

Usage Notes

This package is an internal component of the Oracle Projects commitment accumulation process. It is typically invoked indirectly when commitment accumulations are generated, for example during budget or cost accumulation runs and via related maintenance packages such as PA_MAINT_PROJECT_ACCUMS. It also depends on PA_ACCUM_UTILS, PA_DEBUG, and PA_PROJ_ACCUM_MAIN, which provide logging, utility, and orchestration services. Because the package is not referenced by any other database object and is not a public API, custom code should not call its procedures directly; instead, developers should use supported Projects APIs or invoke the standard concurrent programs that trigger commitment accumulation. Any customization should preserve the documented dependency chain and avoid bypassing the accumulation framework.