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;
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;
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
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);
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';