DBA Data[Home] [Help]

APPS.PQH_SS_HISTORY dependencies on WF_USERS

Line 17: lv_disp_name wf_users.display_name%type;

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:

Line 300: l_orig_system wf_users.orig_system%type;

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(

Line 301: l_orig_system_id wf_users.orig_system_id%type;

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,

Line 352: l_orig_system wf_users.orig_system%type;

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

Line 353: l_orig_system_id wf_users.orig_system_id%type;

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 :=