Search Results g_security_s

Overview

PA_FIN_PLAN_MAINT_VER_GLOBAL is a global PL/SQL package owned by APPS that exposes the application programming interfaces supporting the Maintain Versions page of the Org Forecast financial planning feature in Oracle Projects. The package acts as a session-level state holder and service layer for financial plan version maintenance, allowing Oracle Forms-based user interfaces and internal callers to establish, retrieve, and validate context values such as the current project, financial plan type, and login person before performing version-related operations.

The package is classified as OTHER in the ETRM repository, indicating it is not part of the public, externally supported API surface but is instead an internal utility used by Oracle Projects' own forms and logic. It maintains several package global variables, including G_PROJECT_ID, G_FIN_PLAN_TYPE_ID, and G_LOGIN_PERSON_ID, along with security flag globals G_SECURITY_S, G_SECURITY_R, and G_SECURITY_B added to support financial plan security enforcement. The header comments confirm its purpose as providing APIs for the Org Forecast Maintain Versions page and trace its lineage through the $Header revision string, with the last recorded revision dated 2007 and later enhancements delivered under bug fixes including 5737980 and 4440895.

Key Procedures and Functions

• GET_PROJECT_ID — Returns the project identifier currently held in the package global state.
• GET_FIN_PLAN_TYPE_ID — Returns the financial plan type identifier stored in package global state. This is the function most frequently associated with the search term "get_fin_plan_type_id" and is used by callers to obtain the plan type context set earlier via SET_GLOBAL_VALUES.
• GET_LOGIN_PERSON_ID — Returns the login person identifier held in package global state.
• GET_FIN_PLAN_SECURITY — Returns the financial plan security value for a supplied security type, introduced to support bug 5737980.
• MAINTAIN_VERSIONS_INIT — Initializes the Maintain Versions page, accepting the project, financial plan options, and plan type as inputs and returning initialization outputs such as the financial plan type name, the financial plan preference code, and the organization project flag.
• CREATE_WORKING_COPY — Creates a working copy of a financial plan version, enabling users to revise a plan without altering the baseline version.
• RESUBMIT_CONCURRENT_PROCESS — Resubmits a concurrent process associated with financial plan version maintenance.

Additional documented helpers include SET_GLOBAL_VALUES and SET_GLOBAL_FINPLAN_SECURITY, which populate the package globals that the getter functions subsequently expose.

Tables Accessed

• PA_PROJ_FP_OPTIONS — Stores financial plan options associated with a project; used to derive preference codes during initialization.
• PA_FIN_PLAN_TYPES_B and PA_FIN_PLAN_TYPES_TL — Base and translation tables for financial plan types, supplying the plan type identifier and translated name.
• PA_PROJECTS_ALL — Provides project-level context and validation.
• PA_PROJECT_TYPES_ALL — Supplies the organization project flag returned during initialization.
• PA_BUDGET_VERSIONS — Underpins version creation and working copy operations.

Usage Notes

PA_FIN_PLAN_MAINT_VER_GLOBAL is typically invoked from the Maintain Versions Oracle Forms module within Oracle Projects, where form logic calls SET_GLOBAL_VALUES to seed session state and then uses GET_PROJECT_ID, GET_FIN_PLAN_TYPE_ID, and GET_LOGIN_PERSON_ID to retrieve it. The package is referenced by six other packages in the ETRM repository, indicating that it serves as a foundational dependency for higher-level financial plan processing. Custom code should treat these APIs as internal, since the package is not a documented public interface; direct invocation carries upgrade risk across EBS 12.1.1 and 12.2.2, where the underlying tables and dependent packages may change.