Results for “pa_fp_set_periods_nav”

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

Overview

PA_FIN_PLAN_VIEW_GLOBAL is a global PL/SQL package body in the Oracle E-Business Suite Projects (PA) module that supports the Financial Plan view layer. Its responsibility is to resolve and cache session-level context for financial plan versions, including the active financial plan version identifier, the operating unit, plan periods, and adjustment reason codes. The package acts as a supporting library for the Financial Plan entry and inquiry forms, where the user selects a plan version and the form must subsequently display the correct budget status, periods, currency attributes, and cost adjustment lines.

The $Header revision marker (PARFPSVB.pls 120.4, dated 2006/03/09) indicates the file has been stable since the 11i/12.0 era and is carried forward unchanged into 12.1.1 and 12.2.2. The package holds several package-level globals, including G_FP_VIEW_VERSION_ID and G_FP_ORG_ID, which persist the currently viewed financial plan version and its owning organization for the duration of the form session. This design avoids repeated lookups as the user navigates between periods or adjustment rows.

Key Procedures and Functions

• PA_FP_GET_BUDGET_STATUS_CODE — Retrieves the status code of a budget version by its identifier.
• PA_FP_SET_ORGFCST_VERSION_ID — Initializes the package globals by resolving the plan version, project, operating unit, plan start and end dates, and period type for the selected financial plan version.
• PA_FP_SET_ADJ_REASON_CODE — Sets the adjustment reason code used when cost adjustments are applied to a financial plan.
• PA_FP_VIEWBY_SET_GLOBALS — Populates the "View By" level globals that govern how plan amounts are aggregated and displayed.
• PA_FP_SET_PERIODS and PA_FP_SET_PERIODS_NAV — Establish the period set and navigation range for the plan.
• PA_FP_UPDATE_TABLES — Performs DML against the financial plan tables when changes are committed.
• GET_VERSION_ID, GET_ORG_ID, GET_PLAN_TYPE_ID, GET_RESOURCE_ASSIGNMENT_ID, GET_AMOUNT_TYPE_CODE, GET_ADJ_REASON_CODE, GET_CURRENCY_CODE, GET_CURRENCY_TYPE — Accessor functions returning the cached global values.
• GET_PERIOD_START_DATE1 through GET_PERIOD_START_DATE5 — Return period start dates for up to five concurrent period slots displayed in the plan view.

Tables Accessed

• PA_BUDGET_VERSIONS — Source of budget status code and the parent project identifier.
• PA_BUDGET_LINES — Financial plan amount lines displayed and updated through the view.
• PA_PROJECTS_ALL — Resolves the operating unit (org_id) for the plan.
• PA_PROJ_FP_OPTIONS — Provides plan start and end dates.
• PA_PROJ_PERIOD_PROFILES and PA_PROJ_PERIODS_DENORM — Supply period type and denormalized period rows for navigation.
• PA_FIN_PLAN_ADJ_LINES and PA_FP_ADJ_ELEMENTS — Cost adjustment lines and adjustment elements.
• PA_RESOURCE_ASSIGNMENTS — Links plan amounts to resources.
• DBMS_SQL and NLS_SESSION_PARAMETERS — Used for dynamic SQL and session locale handling.

Usage Notes

This package is not intended for direct customer invocation. It is referenced by fourteen other packaged procedures and is invoked primarily from the Financial Plan entry forms and supporting concurrent processes. In the context of "cost_adjustments", the adjustment-related procedures (PA_FP_SET_ADJ_REASON_CODE and GET_ADJ_REASON_CODE) and the PA_FIN_PLAN_ADJ_LINES and PA_FP_ADJ_ELEMENTS tables are the relevant touchpoints; they allow the form to apply and display adjustment reasons for plan cost lines. Custom code should call the FND_API-compliant wrappers rather than this view-global package directly, since the globals are session-scoped and not thread-safe for concurrent use within a single database session.