13: is
14: l_itemtype varchar2(30) := 'GMWITACT';
15: l_itemkey varchar2(30) := to_char(p_item_id);
16: l_WorkflowProcess varchar2(30) := 'ITEM_ACTIVATION_PROC';
17: l_name wf_users.name%type;
18: l_display_name wf_users.display_name%type;
19: l_errname varchar2(30);
20: l_errmsg varchar2(2000);
21: l_status varchar2(2000);
14: l_itemtype varchar2(30) := 'GMWITACT';
15: l_itemkey varchar2(30) := to_char(p_item_id);
16: l_WorkflowProcess varchar2(30) := 'ITEM_ACTIVATION_PROC';
17: l_name wf_users.name%type;
18: l_display_name wf_users.display_name%type;
19: l_errname varchar2(30);
20: l_errmsg varchar2(2000);
21: l_status varchar2(2000);
22: l_errstack varchar2(32000);
86: display_name
87: into
88: l_display_name
89: from
90: wf_users
91: where
92: name = l_name
93: and
94: rownum =1;