Search Results get_derive_margin_from_code

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:

• Plan and version resolution: GET_PLAN_TYPE_ID, GET_COST_VERSION_ID, GET_REV_VERSION_ID, and GET_SINGLE_VERSION_ID return the identifiers required to locate the correct plan type and cost, revenue, or single budget version for the plan being viewed.
• Resource list resolution: GET_COST_RESOURCE_LIST_ID and GET_REVENUE_RESOURCE_LIST_ID return the resource list used for the cost and revenue sides of the plan, determining which resources participate.
• Multicurrency and currency handling: GET_MULTICURRENCY_FLAG indicates whether the plan involves multiple currencies, while ALL_TXN_CURRENCIES_ENTERED supports retrieval of the full set of transaction currencies entered against the plan.
• Display and configuration attributes: GET_REPORT_LABOR_HRS_FROM_CODE, GET_REV_VERSION_GROUPING, GET_DERIVE_MARGIN_FROM_CODE, GET_DISPLAY_FROM, and GET_COST_VERSION_GROUPING return display-control and grouping flags that govern how the plan page renders labor hours, revenue groupings, margins, and display ordering.
• Descriptive lookups: GET_TASK_NAME, GET_TASK_NUMBER, GET_RESOURCE_NAME, GET_COST_RV_NUM, and GET_REV_RV_NUM return human-readable labels and reference numbers for tasks, resources, and cost/revenue versions.
• Page initialization: NONHGRID_VIEW_INITIALIZE and NONHGRID_EDIT_INITIALIZE prepare the non-grid view and edit page regions by populating the temporary working structures the page requires before display or editing.

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.