DBA Data[Home] [Help]

APPS.ZPB_WF_NTF dependencies on WF_ROLES

Line 184: from wf_roles

180: end if;
181:
182: select count(name)
183: into lcount
184: from wf_roles
185: where name = rolename;
186:
187: if lcount > 0 then
188: dbms_lock.sleep(1);

Line 500: -- sets wf_local_roles, wf_local_user_roles for views wf_users, wf_roles

496: avalue => l_deadDate);
497: end if;
498:
499: -- Create AdHoc Roles when needed and set user lists for WF Directory
500: -- sets wf_local_roles, wf_local_user_roles for views wf_users, wf_roles
501: -- and wf_user_roles.
502:
503: if UserToNotifyP = 'Y' then
504:

Line 1355: p_userID is any user ID which corresponds to a valid wf_roles.name

1351: /*
1352:
1353: This procedure assumes application context is set!
1354:
1355: p_userID is any user ID which corresponds to a valid wf_roles.name
1356: which may be a vaild fnd_user.user_name.
1357: p_subject - the notification subject up to 150 chars
1358: p_message - the notification message up to 2000 chars
1359: