APPS.WF_DIRECTORY dependencies on WF_USERS

Line 1013: from wf_users

1009: into dummy
1010: from SYS.DUAL
1011: where exists
1012: (select null
1013: from wf_users
1014: where name = username
1015: and PARTITION_ID <> 9
1016: and status = 'ACTIVE');
1017: else

Line 1023: from wf_users

1019: into dummy
1020: from SYS.DUAL
1021: where exists
1022: (select null
1023: from wf_users
1024: where orig_system = substr(username, 1, colon-1)
1025: and orig_system_id = substr(username, colon+1)
1026: and name = username
1027: and status = 'ACTIVE');

Line 1108: from wf_users

1104: cursor c_user is
1105: select name,
1106: substrb(display_name,1,360)
1107: p_display_name
1108: from wf_users
1109: where orig_system = p_orig_system
1110: and orig_system_id = p_orig_system_id
1111: order by status, start_date;
1112:

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

1715: d1 pls_integer;
1716:
1717: begin
1718: --
1719: -- Check if user name and display name exists in wf_users
1720: --
1721: if (name is not null and display_name is not null) then
1722:
1723: /* GK: The display name does not have to be unique

Line 1726: from wf_users u

1722:
1723: /* GK: The display name does not have to be unique
1724:
1725: select count(1) into d1
1726: from wf_users u
1727: where u.name = CreateAdHocUser.name
1728: or u.display_name = CreateAdHocUser.display_name;
1729: if (d1 > 0) then
1730: wf_core.token('USERNAME', CreateAdHocUser.name);

Line 3181: -- wf_users.

3177: -- Validation
3178: -- 1379875: (Performance) added support for orig_system, orig_system_id
3179: -- composite name.
3180: -- Changed Validation and duplicate checking to limit selects against
3181: -- wf_users.
3182: -- Used a sub-block to use exception handling instead of single count
3183: -- into.
3184:
3185:

Line 3194: FROM WF_USERS

3190: --To eliminate error: Exact fetch returning more than
3191: --requested number of rows.
3192: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID
3193: INTO l_orig_system, l_orig_system_id
3194: FROM WF_USERS
3195: WHERE NAME = role_users(userIND)
3196: AND partition_id <> 9
3197: AND rownum < 2;
3198: else

Line 3202: FROM WF_USERS

3198: else
3199: -- Bug 2465881
3200: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID
3201: INTO l_orig_system, l_orig_system_id
3202: FROM WF_USERS
3203: WHERE ORIG_SYSTEM = substr(role_users(userIND), 1, colon-1)
3204: AND ORIG_SYSTEM_ID = substr(role_users(userIND), colon+1)
3205: AND rownum < 2;
3206: end if;