Search Results pa_fcst_proj_get_default

Overview

PA_FCST_GLOBAL is an Oracle EBS APPS schema PL/SQL package classified as an "OTHER" API within the ETRM 12.2.2 repository. It provides the shared session-context and retrieval layer for the Project Forecasting (PA_FCST) module. Rather than performing forecasting arithmetic, the package stores and returns the global values that drive forecast inquiry screens — the currently selected project, the period set applied to the forecast, forecast start and end dates, cost/quantity display amounts, and organization context. Its name reflects this responsibility: it is the "global" state holder for the forecasting UI, populated once when a user enters the forecasting form and subsequently queried by the various PA_FCST_*PROJ*, PA_FCST_PERIODIC*, and PA_FCST_*_V views that render forecast data.

Key Procedures and Functions

The package exposes 39 documented procedures and functions. They fall into logical groups:

• Setter routines — SET_CROSSPROJECT_GLOBALVALUE, SET_PROJECT_GLOBALVALUE, SET_GLOBAL_PROJECT_ID, and SETPERIODSETNAME write the current forecasting selection into package globals. The distinction between project-scoped and cross-project settings supports forecasting across multiple projects in one session.
• Project identity getters — GETPROJECTID, GETPROJECTNUMBER, GETPROJECTNAME, GETPROJTYPE, GETPROJECTORGID, and GETPROJECTORGNAME return the identifiers and descriptive attributes of the active project or organization.
• Date and period getters — GETPROJFCSTSTARTDATE, GETPROJFCSTENDDATE, and GETPERIODTYPE return the forecast horizon and the period type (for example, GL or PA periods) governing the query.
• Amount and option getters — GETPROJFCSTSHOWAMOUNT returns the display amount indicator; GETPROBABILITYPERFLAG and GETPROBABILITYPER return the probability weighting flag and value used in weighting forecast lines.
• Defaults and utility — GETDEFAULTVALUE and PA_FCST_PROJ_GET_DEFAULT resolve profile-driven defaults (via FND_PROFILE), and GETPAGEFIRSTFLAG controls first-entry page initialization.
• Context access — GETPROJECT_INFO returns a consolidated record of the active project context.

Tables Accessed

The package reads (and in some cases references for lookup) the following objects through APPS synonyms: PA_PROJECTS_ALL for project identity and organization; PA_PROJECT_TYPES_ALL for project type classification; PA_PROJECT_ASSIGNMENTS and PA_PROJECT_PARTIES for role and party context; PA_IMPLEMENTATIONS and PA_IMPLEMENTATIONS_ALL for installation settings; PA_FORECASTING_OPTIONS for module-level forecasting configuration; PA_BUDGET_VERSIONS for budget version selection; PA_PERIODS_ALL, GL_PERIODS, GL_PERIOD_STATUSES, and GL_DATE_PERIOD_MAP for period and date mapping used by the date/period getters; HR_ALL_ORGANIZATION_UNITS_TL for organization name translation; FND_PROFILE_OPTIONS_TL for multilingual profile option defaults; and the temporary table PA_FCST_PERIODS_TMP, which stores the period breakdown generated for the current forecasting session.

Usage Notes

PA_FCST_GLOBAL is not intended for direct end-user invocation. It is called internally by the Project Forecasting forms and by the thirteen dependent objects listed in the ETRM repository, notably the PA_FCST_PERIODIC_DTL_V, PA_FCST_PROJECT_HDR_V, PA_FCST_PROJECT_SUM_V, PA_FCST_PROJ_HDR_V, PA_FCST_PROJ_ERR_V, and PA_FCST_PROJ_PERIODIC_V views. Forms initialize the globals on entry, and the views then read them to filter and format forecast results. Because state is held in package variables for the life of a database session, correct initialization order matters: the setters must execute before the corresponding getters are used, and custom extensions invoking this package must respect that sequence. Under 12.1.1 and 12.2.2 the object is VALID and unchanged in its documented interface, so existing customizations remain portable across both releases.