Results for “pa_fp_refresh_elements_pub”

50+ results




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

Overview

PA_FP_REFRESH_ELEMENTS_PUB is a public PL/SQL package in the APPS schema that supports Oracle Project Management's financial planning and forecasting (FP) functionality. Its principal business purpose is to refresh planning elements — the resource, task, and budget line structures used within a project forecast or financial plan — so that the working plan reflects the most current project, task, and budget configuration. When project structures, forecast options, or budget versions change, the stored planning elements can become stale; this package realigns them by reading the defining source data and rewriting the plan element set accordingly. Because the object is classified as a PUB (public) API and is documented as VALID in ETRM, it is treated as a supported programmatic interface rather than internal, private code.

Key Procedures and Functions

  • GET_REFRESH_PLAN_ELE_DTLS — Retrieves the details of the plan elements eligible for refresh, providing the working data set used by the refresh operation.
  • SET_PROCESS_FLAG_OPT — Sets the processing flag associated with the FP options record, governing refresh behavior at the option level.
  • SET_PROCESS_FLAG_PROJ — Sets the processing flag at the project level, controlling refresh processing for a given project.
  • REFRESH_PLANNING_ELEMENTS — The core routine; performs the actual refresh of planning elements against the current project and budget definition.
  • UPDATE_PROCESS_STATUS — Updates the recorded process status, typically invoked explicitly to reflect the outcome of a refresh run.
  • UPDATE_PROCESS_STATUS_AUTO — Performs the same status update automatically, generally during internal processing.
  • FP_WRITE_LOG_SS_OR_CONC — Writes logging output, distinguishing between self-service (SS) invocations and concurrent program runs.

Tables Accessed

  • PA_PROJECTS_ALL — Provides project-level context and validation for the refresh.
  • PA_BUDGET_VERSIONS — Supplies budget version data driving the plan element structure.
  • PA_PROJ_FP_OPTIONS — Holds the financial planning options and processing flags that govern refresh behavior.
  • PA_TASKS — Provides task structure used when rebuilding task-aligned planning elements.
  • PLITBLM — A standard Oracle character-to-table conversion utility, used to pass multi-value list parameters.

Usage Notes

The package is invoked both by Oracle's own project modules and by custom code. Per ETRM, it references PA_PROJECTS_ALL, PA_BUDGET_VERSIONS, PA_PROJ_FP_OPTIONS, PA_PLSQL_DATATYPES, and PLITBLM, and is referenced by PA_PROJECT_PUB, PA_PROJECT_PVT, PA_PROJ_TASK_STRUC_PUB, and PA_TASK_PUB1 — indicating it is called when project, task, or budget structure changes require plan elements to be regenerated. The FP_WRITE_LOG_SS_OR_CONC routine confirms it is executed in two modes: interactively through self-service (OAF) pages in Oracle Project Management, and in batch through concurrent programs. Custom integrations should call the public entry points such as REFRESH_PLANNING_ELEMENTS rather than underlying private code, and should respect the option-level and project-level process flags to avoid concurrent refresh of the same plan.