APPS.WF_DIRECTORY dependencies on WF_USERS

Line 921: from wf_users

917: into dummy
918: from SYS.DUAL
919: where exists
920: (select null
921: from wf_users
922: where name = username
923: and PARTITION_ID <> 9
924: and status = 'ACTIVE');
925: else

Line 931: from wf_users

927: into dummy
928: from SYS.DUAL
929: where exists
930: (select null
931: from wf_users
932: where orig_system = substr(username, 1, colon-1)
933: and orig_system_id = substr(username, colon+1)
934: and name = username
935: and status = 'ACTIVE');

Line 966: from wf_users

962: cursor c_user is
963: select name,
964: substrb(display_name,1,360)
965: p_display_name
966: from wf_users
967: where orig_system = p_orig_system
968: and orig_system_id = p_orig_system_id
969: order by status, start_date;
970:

Line 1577: -- Check if user name and display name exists in wf_users

1573: d1 pls_integer;
1574:
1575: begin
1576: --
1577: -- Check if user name and display name exists in wf_users
1578: --
1579: if (name is not null and display_name is not null) then
1580:
1581: /* GK: The display name does not have to be unique

Line 1584: from wf_users u

1580:
1581: /* GK: The display name does not have to be unique
1582:
1583: select count(1) into d1
1584: from wf_users u
1585: where u.name = CreateAdHocUser.name
1586: or u.display_name = CreateAdHocUser.display_name;
1587: if (d1 > 0) then
1588: wf_core.token('USERNAME', CreateAdHocUser.name);

Line 3033: -- wf_users.

3029: -- Validation
3030: -- 1379875: (Performance) added support for orig_system, orig_system_id
3031: -- composite name.
3032: -- Changed Validation and duplicate checking to limit selects against
3033: -- wf_users.
3034: -- Used a sub-block to use exception handling instead of single count
3035: -- into.
3036:
3037:

Line 3046: FROM WF_USERS

3042: --To eliminate error: Exact fetch returning more than
3043: --requested number of rows.
3044: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID
3045: INTO l_orig_system, l_orig_system_id
3046: FROM WF_USERS
3047: WHERE NAME = role_users(userIND)
3048: AND partition_id <> 9
3049: AND rownum < 2;
3050: else

Line 3054: FROM WF_USERS

3050: else
3051: -- Bug 2465881
3052: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID
3053: INTO l_orig_system, l_orig_system_id
3054: FROM WF_USERS
3055: WHERE ORIG_SYSTEM = substr(role_users(userIND), 1, colon-1)
3056: AND ORIG_SYSTEM_ID = substr(role_users(userIND), colon+1)
3057: AND rownum < 2;
3058: end if;