Search Results pa_fp_view_plans_txn_pub




Overview
Explore in AI Chat

Overview

PA_FP_VIEW_PLANS_TXN_PUB is a public PL/SQL package in the APPS schema that supports the Oracle EBS Project Financial Planning (FP) module, specifically the view-only presentation and initialization logic used by the Financial Plan viewing pages. In Release 12.1.1 and 12.2.2, this package supplies the runtime helper logic that Forms-based and OAF-based Financial Plan pages invoke when a user opens a plan, a version, or a transaction-level inquiry against a project or task. Its central role is to resolve the correct financial plan type, budget versions (cost and revenue), resource lists, and multicurrency behavior for the plan being viewed, then initialize the non-grid (NONHGRID) page structures that render the plan data.

The package belongs to the PUB classification, meaning it is a documented, supported public API surface that Oracle permits other modules and carefully written customizations to call. It is referenced by at least one other object, the view PA_FP_VP_TXNCURRENCY_V, confirming its use as a data source for currency-aware view logic in the Financial Plan transaction display.

Key Procedures and Functions

The package exposes 23 documented procedures and functions. The major groupings are:

Tables Accessed

The package reads from core Project Financial Planning and Shared Project tables through APPS synonyms, including PA_BUDGET_LINES, PA_BUDGET_VERSIONS, PA_FIN_PLAN_TYPES_B and PA_FIN_PLAN_TYPES_TL, PA_PROJECTS_ALL, PA_PROJ_FP_OPTIONS, PA_RESOURCES, PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_LIST_MEMBERS, PA_TASKS, PA_AGREEMENTS_ALL, PA_RESOURCE_LISTS_ALL_BG, and PA_FP_TXN_CURRENCIES. These provide plan definitions, version metadata, resource and task context, and entered currencies. PA_FP_TXN_LINES_TMP and DUAL are also referenced, the former as a temporary working area for transaction lines and the latter for scalar expression evaluation.

Usage Notes

PA_FP_VIEW_PLANS_TXN_PUB is invoked primarily by the Financial Plan view pages within the Projects suite, and it backs the PA_FP_VP_TXNCURRENCY_V view. Custom code should call only the PUB-documented procedures and functions, relying on their documented return semantics rather than internal package body logic, since implementation details may change across 12.1.1 and 12.2.2 patch levels. Because the package manipulates temporary and initialization structures, it should be called within the standard page initialization sequence rather than independently, and any custom invocation must respect the expected runtime context established by the Financial Plan setup options in PA_PROJ_FP_OPTIONS.