Search Results get_mode

Overview

FFSTUP is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM taxonomy as OTHER. Its documented purpose is to handle forms behaviour and validation across the various operating modes of an Oracle Forms session — principally startup mode and normal mode. The package header carries a copyright attributed to Oracle Corporation (UK) Ltd, reflecting its origin in the Oracle HRMS / Oracle Payroll localization and legislation framework, where startup logic must adapt to the business group and legislative context of the user's installation.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the defining owner. This choice is significant: FFSTUP is intended to be called from within Forms sessions where the effective user context differs from APPS, and the invoker's rights model ensures that the caller's security profile and business group visibility govern any data access performed. The package exposes two functions, CHECK_CHANGE and GET_MODE, both of which concern themselves with interpreting the business group and legislation combination that applies to the current session.

Key Procedures and Functions

CHECK_CHANGE — Evaluates the startup mode, business group, and legislation codes supplied by the caller and determines whether a change to the current operating context is permitted. It returns a Boolean value: TRUE when the change is allowed, FALSE otherwise. This function is the gatekeeper that prevents a user from switching between incompatible business groups or legislative regimes during a Forms session, preserving data integrity where payroll and statutory calculations are involved.

GET_MODE — Returns the current mode as a VARCHAR2 value, derived from the business group and legislation supplied as inputs. This is the function most closely associated with the user's search term "get_mode." It allows a calling form to determine which mode it should present, without duplicating the business group and legislation resolution logic in every form. Together, CHECK_CHANGE and GET_MODE form a complementary pair: GET_MODE reports the intended mode and CHECK_CHANGE validates whether a transition into that mode is legal.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. The documented functions operate entirely on their scalar input parameters — a business group identifier and a legislation code — rather than querying application tables directly. Any dependent data, such as business group or legislation definitions, would be resolved by the calling form or by the packages that invoke FFSTUP. The absence of direct table references supports the invoker's rights declaration: the package is a logic and validation layer rather than a data access layer.

Usage Notes

FFSTUP is designed to be invoked from Oracle Forms, typically from the startup and normal mode processing paths of HRMS and Payroll forms, and from other PL/SQL packages that need to determine or validate the current mode. The ETRM metadata indicates that the package is referenced by four other packages, confirming it is a shared utility rather than a form-private library. Because the functions return Boolean and VARCHAR2 values based on supplied business group and legislation, custom code may call GET_MODE to obtain the active mode string and CHECK_CHANGE to test whether a mode switch should be allowed under the current business group and legislation. The package is equally valid in Oracle EBS 12.1.1 and 12.2.2; its signature and behaviour are unchanged between these releases.