13: p_orig_system out nocopy varchar2,
14: p_orig_system_id out nocopy number) is
15: --local variables
16: c_proc constant varchar2(30) := 'getRoleOrigSysInfo';
17: lv_disp_name wf_users.display_name%type;
18: lt_userRoles wf_directory.wf_local_roles_tbl_type;
19: begin
20: g_debug := hr_utility.debug_enabled;
21:
296: l_txnItemKey VARCHAR2(240);
297: l_dummyProcess VARCHAR2(200);
298: l_username VARCHAR2(320);
299: l_transactionId NUMBER(15);
300: l_orig_system wf_users.orig_system%type;
301: l_orig_system_id wf_users.orig_system_id%type;
302: BEGIN
303: /* l_username :=
304: wf_engine.GetItemAttrText(
297: l_dummyProcess VARCHAR2(200);
298: l_username VARCHAR2(320);
299: l_transactionId NUMBER(15);
300: l_orig_system wf_users.orig_system%type;
301: l_orig_system_id wf_users.orig_system_id%type;
302: BEGIN
303: /* l_username :=
304: wf_engine.GetItemAttrText(
305: itemtype => p_itemType,
348: result OUT NOCOPY VARCHAR2 ) IS
349: --
350: l_username VARCHAR2(320);
351: l_transactionId NUMBER(15);
352: l_orig_system wf_users.orig_system%type;
353: l_orig_system_id wf_users.orig_system_id%type;
354: --
355: BEGIN
356: if ( funmode = 'RUN' ) THEN
349: --
350: l_username VARCHAR2(320);
351: l_transactionId NUMBER(15);
352: l_orig_system wf_users.orig_system%type;
353: l_orig_system_id wf_users.orig_system_id%type;
354: --
355: BEGIN
356: if ( funmode = 'RUN' ) THEN
357: /* l_username :=