DBA Data[Home] [Help]

APPS.HR_TRANSACTION_SS dependencies on WF_USERS

Line 22: contextUser wf_users.name%type;

18: procedure setRespondedUserCtx(p_item_type in varchar2,
19: p_item_key in varchar2) is
20:
21: c_proc constant varchar2(60) := 'setRespondedUserCtx';
22: contextUser wf_users.name%type;
23: contextProxyUser wf_users.name%type;
24:
25: userId fnd_user.user_id%type;
26: c_user_name wf_users.name%type;

Line 23: contextProxyUser wf_users.name%type;

19: p_item_key in varchar2) is
20:
21: c_proc constant varchar2(60) := 'setRespondedUserCtx';
22: contextUser wf_users.name%type;
23: contextProxyUser wf_users.name%type;
24:
25: userId fnd_user.user_id%type;
26: c_user_name wf_users.name%type;
27: l_user_role_count number default 0;

Line 26: c_user_name wf_users.name%type;

22: contextUser wf_users.name%type;
23: contextProxyUser wf_users.name%type;
24:
25: userId fnd_user.user_id%type;
26: c_user_name wf_users.name%type;
27: l_user_role_count number default 0;
28: cursor username is
29: select user_id from fnd_user where user_name=contextUser;
30: cursor user_role_name is

Line 199: c_creator_user wf_users.name%Type;

195: c_all_approvers ame_util.approversTable;
196: c_proc varchar2(30) default 'reset_ame_approval_status';
197:
198: --ns begin
199: c_creator_user wf_users.name%Type;
200: c_return_user wf_users.name%Type;
201: c_return_person number;
202: c_match_found varchar2(1) := 'N';
203: c_rfc_initiator varchar2(1);

Line 200: c_return_user wf_users.name%Type;

196: c_proc varchar2(30) default 'reset_ame_approval_status';
197:
198: --ns begin
199: c_creator_user wf_users.name%Type;
200: c_return_user wf_users.name%Type;
201: c_return_person number;
202: c_match_found varchar2(1) := 'N';
203: c_rfc_initiator varchar2(1);
204: l_proc constant varchar2(100) := g_package || ' reset_ame_approval_status';