Search Results get_lookup_time_phase

Overview

PA_FIN_PLAN_CREATE_VER_GLOBAL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an "OTHER" API rather than a standard public interface. Its stated purpose, per the embedded header comment (PAFPCVGS.pls), is to provide the API functions that support the Org Forecast: Create Versions page within Oracle Project Management / Project Billing. In practical terms, the package is a server-side helper library for the "Create Versions" user interface, where a project manager establishes a new financial plan (budget or forecast) version against an existing project. The package exposes getters and setters for the key context identifiers (project, financial plan type, budget version), lookup translation helpers, and — most relevant to the user's search term — functions that resolve the current GL and PA accounting period names for the page. It also provides the initialization and create-version entry points that drive the page's core action.

Key Procedures and Functions

• GET_PROJECT_ID / GET_FIN_PLAN_TYPE_ID / GET_BUDGET_VERSION_ID — return the package-level global identifiers (G_PROJECT_ID, G_FIN_PLAN_TYPE_ID, G_BUDGET_VERSION_ID) that were previously stored via the SET_* procedures.
• SET_PROJECT_ID / SET_FIN_PLAN_TYPE_ID / SET_BUDGET_VERSION_ID — populate those globals. These setters follow the ETRM error-handling convention, returning x_return_status, x_msg_count, and x_msg_data to report success or failure.
• SET_GLOBAL_VALUES — a convenience initializer that populates the global context in a single call.
• GET_LOOKUP_PLANNING_LEVEL / GET_LOOKUP_TIME_PHASE — translate stored codes from PA_PROJ_FP_OPTIONS (planning level code, cost time-phased code) into their display meanings for the page.
• GET_RESOURCE_LIST_NAME — resolves a resource list ID to its translated name for display.
• GET_GL_CURRENT_START_PERIOD / GET_GL_CURRENT_END_PERIOD / GET_PA_CURRENT_START_PERIOD / GET_PA_CURRENT_END_PERIOD — retrieve the current accounting period (start and end) as defined in General Ledger and in Project Accounting respectively, for a given project. These were added on 9/11/02 explicitly to supply GL/PA start and end period names to the Create Version page.
• GET_START_END_PERIOD — returns the effective start and end periods used when creating the version.
• CREATE_VERSIONS_INIT — the initialization routine invoked to begin creation of plan versions.

Tables Accessed

The package reads and writes against APPS synonyms covering the core financial-plan and period-profile model: PA_BUDGET_VERSIONS (the version being created or queried), PA_FIN_PLAN_TYPES_B (plan type definitions), PA_PROJECTS_ALL and PA_PROJECT_TYPES_ALL (project context), PA_PROJ_FP_OPTIONS (planning level and time-phasing options), PA_PROJ_PERIOD_PROFILES (project period profile used by the get_*_period functions), GL_PERIODS (GL calendar periods used to derive current GL start/end period names), PA_FORECASTING_OPTIONS_ALL, PA_IMPLEMENTATIONS_ALL, and PA_RESOURCE_LISTS_TL (translated resource list names).

Usage Notes

This package is not a general-purpose public API; it is tightly coupled to the Org Forecast "Create Versions" OAF/Forms page and is referenced by two other packages. Functional consultants and developers should invoke it indirectly through that page rather than calling its procedures directly. When custom code must resolve the current GL end period for a project, GET_GL_CURRENT_END_PERIOD is the documented entry point, accepting a project ID and returning the period name as VARCHAR2; it relies on the project's period profile and the GL period calendar and therefore returns a name, not a date. Available in both 12.1.1 and 12.2.2, the package's behavior is stable but undocumented outside this ETRM entry.