APPS.WFA_HTML dependencies on WF_ROLES

Line 3032: -- problem with this query against wf_roles.

3028: --
3029: -- User_LOV
3030: -- Create the data for the User List of Values
3031: -- NOTE: This is not used by APPS. Otherwise, we will have performance
3032: -- problem with this query against wf_roles.
3033: --
3034: procedure User_LOV (p_titles_only IN VARCHAR2,
3035: p_find_criteria IN VARCHAR2)
3036:

Line 3048: FROM wf_roles

3044: CURSOR c_user_lov (c_find_criteria IN VARCHAR2) IS
3045: SELECT
3046: name,
3047: display_name
3048: FROM wf_roles
3049: WHERE upper(name) like upper(c_find_criteria)
3050: AND upper(name) not like '~WF_ADHOC-%'
3051: AND status <> 'INACTIVE'
3052: ORDER BY name;

Line 3063: FROM wf_roles

3059: IF (p_titles_only = 'N') THEN
3060:
3061: SELECT COUNT(*)
3062: INTO l_row_count
3063: FROM wf_roles
3064: WHERE upper(name) like upper(p_find_criteria)||'%'
3065: AND upper(name) not like '~WF_ADHOC-%'
3066: AND status <> 'INACTIVE';
3067:

Line 3898: -- from wf_roles

3894: -- roles display
3895:
3896: -- CURSOR c_user_display_value (c_name IN VARCHAR2) IS
3897: -- select name, display_name
3898: -- from wf_roles
3899: -- where name = c_name;
3900:
3901: ii NUMBER := 0;
3902: nn NUMBER := 0;

Line 4006: from WF_ROLES

4002: colon := instr(p_display_value,':');
4003: if (colon = 0) then
4004: select count(*)
4005: into ii
4006: from WF_ROLES
4007: where NAME = p_display_value
4008: and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
4009: 'HZ_GROUP','CUST_CONT');
4010: else

Line 4013: from WF_ROLES

4009: 'HZ_GROUP','CUST_CONT');
4010: else
4011: select count(*)
4012: into ii
4013: from WF_ROLES
4014: where NAME = p_display_value
4015: and ORIG_SYSTEM = substr(p_display_value, 1, colon-1)
4016: and ORIG_SYSTEM_ID = substr(p_display_value, colon+1);
4017: end if;

Line 4175: from WF_ROLES

4171:
4172: if (l_colon = 0) then
4173: select count(1)
4174: into l_names_count
4175: from WF_ROLES
4176: where NAME = p_user_name
4177: and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
4178: 'HZ_GROUP','CUST_CONT')
4179: and DISPLAY_NAME = p_display_name;

Line 4195: from WF_ROLES

4191: raise;
4192: end;
4193: select count(1)
4194: into l_names_count
4195: from WF_ROLES
4196: where NAME = p_user_name
4197: and ORIG_SYSTEM = substr(p_user_name, 1, l_colon-1)
4198: and ORIG_SYSTEM_ID = l_orig_system_id
4199: and DISPLAY_NAME = p_display_name;