CREATE LOOKUP FOR PERSONALIZATION THERES I AM ENABLE AND DISABLE PERSONALIZATION

CREATE LOOKUP FOR PERSONALIZATION THERES I AM ENABLE AND DISABLE PERSONALIZATION

Untitled.jpg

 

THIS IS THE FUNCTION THEY GIVE THE CONDITION :—–à

 

CREATE OR REPLACE function xxc11_personalization_enabled(p_personalization_code VARCHAR2)

return varchar2

is

l_return varchar2(1);

begin

 

select decode(count(1),0,’N’,’Y’)

into l_return

from fnd_lookup_values

where lookup_type=’XXC11_PERSONALIZATION_LIST’

and lookup_code = p_personalization_code

and nvl(enabled_flag,’N’)=’Y’;

return l_return;

end;

IN THE PERSONALIZATION CONDITION IS :———–à

xxc11_personalization_enabled(‘XXC11_PUR001′)=’Y’

Advertisements