EBS Customizations (MOSC)

MOSC Banner

Forms Personalization - Reference Global Variable in FORMS DDL

edited May 30, 2012 5:41AM in EBS Customizations (MOSC) Question
I'm clearing a profile option when a forms open, after saving the current value in a global variable.
I want to set the profile value back when I am done, the DDL is

DECLARE
   a   BOOLEAN;
BEGIN
   a := fnd_profile.SAVE ('PER_SECURITY_PROFILE_ID'
                        , GLOBAL.FLINV_PROFILE_VALUE
                        , ''USER''
                        , ''1110''
                        , NULL
                        , NULL
                         );

END;

Is there a way to embed that second parameter to reference my global variable? I've tried a number of combinations of quotes, colons, etc.

Joe

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center