Search Results pa_schedule_objects_pvt




Overview
Explore in AI Chat

Overview

PA_SCHEDULE_OBJECTS_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It resides within the Project Management family of modules and supports the scheduling infrastructure of Oracle Projects. Its classification as a private (PVT) package indicates that it is an internal implementation layer rather than a public application programming interface; it is designed to be consumed by other packages within the Projects schema rather than called directly by external integrations or end users.

The package provides the core engine for generating and deferring schedule-related processing against project scheduling objects. It encapsulates the logic required to trigger schedule generation, to queue that generation for later execution, and to report on the progress status of an ongoing or completed schedule operation. In practical terms, it forms part of the dependency chain that allows project managers to recalculate and roll up task and project dates and progress, and it logs its activity through the standard Oracle EBS logging framework.

Key Procedures and Functions

The ETRM metadata documents three callable units within this package:

  • GENERATE_SCHEDULE — The primary procedure responsible for performing schedule generation against project scheduling objects. It drives the calculation and refresh of schedule data, and its activity is logged to the FND logging tables so that administrators can trace execution and diagnose failures.
  • DEFER_GENERATE_SCHEDULE — A companion procedure that defers schedule generation rather than executing it immediately. This supports deferred or background processing scenarios, where schedule recalculation is queued or postponed until the appropriate processing window, using the bulk temporary tables to stage the work.
  • GET_PROGRESS_STATUS — A procedure or function that returns the progress status of a schedule generation request. It allows calling programs to determine whether a previously initiated schedule operation is pending, running, or complete.

Parameter lists for these units are intentionally omitted here; consumers should reference the package specification in the EBS database for exact signatures.

Tables Accessed

Through APPS synonyms, the package accesses several documented tables and views:

  • FND_LOG_MESSAGES and FND_LOG_MESSAGES_S — The Oracle EBS application logging tables. PA_SCHEDULE_OBJECTS_PVT writes diagnostic and trace messages here, which is consistent with an internal engine whose activity must be auditable.
  • PA_PROJ_ROLLUP_BULK_TEMP and PA_PROJ_ROLLUP_BULK_TEMP_S — Temporary staging tables used to hold project rollup data during bulk schedule processing. These support set-based, deferred processing of project and task rollups.
  • DUAL — The standard Oracle single-row utility table, used for scalar evaluations and function calls.
  • PLITBLM — A PL/SQL internal table type reference used by the package body for bulk collection handling.

Usage Notes

Because PA_SCHEDULE_OBJECTS_PVT is referenced by five other APPS packages, including PA_PROGRESS_PUB, PA_PROGRESS_PVT, PA_PROJECT_DATES_PUB, PA_STATUS_PUB, and PA_STRUCT_TASK_ROLLUP_PUB, it is typically invoked indirectly. Standard Oracle Projects functionality — such as progress entry, project date maintenance, status updates, and structure/task rollup processing — calls into this package as part of normal business flows. Users invoking these public-facing features or concurrent programs therefore trigger PA_SCHEDULE_OBJECTS_PVT without direct awareness of it.

Custom code should avoid calling this private package directly whenever a supported public API exists; the PA_*_PUB packages listed above represent the sanctioned entry points. Where direct invocation is unavoidable, developers must account for the fact that schedule generation may be deferred rather than immediate, and should use GET_PROGRESS_STATUS to monitor completion. In 12.1.1 and 12.2.2 both, the package is delivered VALID and requires no customer modification.