select count(name) into l_attr_cnt
from wf_item_attribute_values where item_key = itemkey
and name like to_char('xx attr name')
and item_type = 'GLBATCH';
if l_attr_cnt = 0 then
apps.WF_ENGINE.AddItemAttr( itemtype => itemtype,
itemkey => itemkey,
aname => to_char('xx attr name'),
text_value=> 'Guru', -- If want to create attribute Text Type
number_value=> null, -- If want to create attribute Number Type
date_value=> null); -- If want to create attribute Date Type
end if;
apps.wf_engine.setitemattrtext (itemtype => itemtype,
itemkey => itemkey,
aname => to_char('xx attr name'),
avalue => 'Guru' )
from wf_item_attribute_values where item_key = itemkey
and name like to_char('xx attr name')
and item_type = 'GLBATCH';
if l_attr_cnt = 0 then
apps.WF_ENGINE.AddItemAttr( itemtype => itemtype,
itemkey => itemkey,
aname => to_char('xx attr name'),
text_value=> 'Guru', -- If want to create attribute Text Type
number_value=> null, -- If want to create attribute Number Type
date_value=> null); -- If want to create attribute Date Type
end if;
apps.wf_engine.setitemattrtext (itemtype => itemtype,
itemkey => itemkey,
aname => to_char('xx attr name'),
avalue => 'Guru' )
No comments:
Post a Comment