Forms Personalization - Reference Global Variable in FORMS DDL
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
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
0