DBA Data[Home] [Help]

APPS.PSP_ER_WF_CUSTOM dependencies on WF_ROLES

Line 8: l_wf_role wf_roles.name%type;

4: itemkey IN varchar2,
5: actid IN number,
6: funcmode IN varchar2,
7: result OUT nocopy varchar2) is
8: l_wf_role wf_roles.name%type;
9: begin
10: --- Set the WF admin to the WF Role u need
11: --- sample code below. This custom Role will override the seeded
12: -- behavior. The product is shipped with WF Administrator set to

Line 41: l_new_display_name wf_roles.display_name%TYPE; -- Bug 6641216

37: actid IN number,
38: funcmode IN varchar2,
39: result OUT nocopy varchar2) is
40:
41: l_new_display_name wf_roles.display_name%TYPE; -- Bug 6641216
42: l_new_user_name fnd_user.user_name%TYPE; -- Bug 6641216
43:
44:
45: begin

Line 73: from wf_roles where name = l_new_user_name;

69: itemkey => itemkey,
70: aname => 'WF_ADMINISTRATOR');
71:
72: select display_name into l_new_display_name
73: from wf_roles where name = l_new_user_name;
74:
75: wf_engine.SetItemAttrText(itemtype => itemtype,
76: itemkey => itemkey,
77: aname => 'APPROVER_ROLE_NAME',