Search Results process_modified_lines




Overview
Explore in AI Chat

Overview

PA_FP_EDIT_LINE_PKG is a PL/SQL package body in the Oracle EBS Projects (PA) module that supports the editing and processing of financial plan budget lines. It belongs to the Financial Planning (FP) feature set and carries an API classification of OTHER, indicating that it is an internal, non-public package rather than a formally published open interface. Its primary responsibility is to manage the manipulation, derivation, and rollup of budget line data associated with time-phased financial plans, including validation and population of periods, amounts, and dates used throughout the financial plan edit workflow. The package header comment references header revision 120.2 and several historical bug fixes (for example, Bug 4569365 removed Multi-Reporting Currency code, and Bug 2672548 added date derivation logic), confirming that the package has matured over multiple release cycles. Because the user query targeted populate_rollup_tmp, the sections below emphasize the procedures that manipulate the temporary rollup table.

Key Procedures and Functions

  • POPULATE_ROLLUP_TMP — Populates a temporary staging structure (paired with PA_FP_CPY_PERIODS_TMP) that holds rolled-up financial plan line values for subsequent processing. This is the most relevant procedure for the reported search term.
  • DERIVE_PD_SD_START_END_DATES — Derives preceding and succeeding period start and end dates when those values are not already present on the budget lines, as introduced by Bug 2672548.
  • PROCESS_MODIFIED_LINES — Processes budget lines that have been changed during an edit session.
  • GET_ELEMENT_AMOUNT_INFO — Retrieves amount information for a given planning element.
  • CALL_CLIENT_EXTENSIONS — Invokes client extension hooks so customers can customize edit-line processing behavior.
  • POPULATE_ELIGIBLE_PERIODS — Determines and populates the periods eligible for inclusion in the financial plan.
  • GET_PRECEDING_SUCCEEDING_AMT — Returns amounts for the preceding and succeeding periods relative to a given line.
  • GET_IS_FN_SECURITY_AVAILABLE — Reports whether financial security is available for the current user/project context.
  • FIND_DUP_ROWS_IN_ROLLUP_TMP — Detects duplicate rows within the rollup temporary table, typically as a pre-cleanup validation before committing rolled-up data.
  • GET_PD_SD_AMT_IN_PC_PFC — Retrieves preceding/succeeding amounts in the project currency versus project functional currency context.
  • PROCESS_BDGTLINES_FOR_VERSION — Drives budget-line processing for a specific budget version.
  • POPULATE_LOCAL_VARIABLES — Loads session-level context variables (period profile dates, time-phased code, financial plan version and level codes, project start/end dates) used by the other procedures.

Tables Accessed

The package reads and writes core financial plan tables through APPS synonyms. PA_BUDGET_LINES and its shadow PA_BUDGET_LINES_S hold the budget line detail being edited; PA_BUDGET_VERSIONS and PA_PROJ_FP_OPTIONS supply version and option context; PA_PROJ_PERIOD_PROFILES and PA_PROJ_PERIODS_DENORM provide period definitions. PA_FIN_PLAN_AMOUNT_SETS, PA_RESOURCES, PA_RESOURCE_ASSIGNMENTS, and PA_RESOURCE_LIST_MEMBERS support resource and amount-set lookups, while PA_TASKS and PA_PROJECTS_ALL provide task and project attributes. GL_PERIOD_STATUSES is consulted for accounting period open/close status, FND_NEW_MESSAGES supplies messages, and PA_FP_CPY_PERIODS_TMP serves as the temporary rollup staging table used by POPULATE_ROLLUP_TMP and FIND_DUP_ROWS_IN_ROLLUP_TMP.

Usage Notes

PA_FP_EDIT_LINE_PKG is invoked from the Financial Plan edit-line user interface and related concurrent processing rather than as a published open API. It is referenced by at least one other package, confirming it operates as a supporting utility layer. Customizations should avoid direct calls to its procedures; instead, the documented CALL_CLIENT_EXTENSIONS hook is the supported extension point. Debug output is governed by the PA_DEBUG_MODE profile option via FND_PROFILE.value.