APPS.WF_DIRECTORY dependencies on WF_ROLES

Line 375: ** of the wf_roles view and attempts to get the information from there.

371:
372: /*
373: ** First try to get the role information from the new
374: ** wfa_sec.get_role_info function. This function looks at each component
375: ** of the wf_roles view and attempts to get the information from there.
376: ** If it does not find the role then use the old method of looking at the
377: ** view.
378: */
379:

Line 537: from WF_ROLES R

533: to_date(NULL),
534: to_number(NULL),
535: to_number(NULL)
536: into role_info_tbl(1)
537: from WF_ROLES R
538: where R.NAME = GetRoleInfo2.role
539: and R.PARTITION_ID not in (9,8,7,6,4)
540: and rownum = 1;
541: else

Line 573: from WF_ROLES R

569: to_date(NULL),
570: to_number(NULL),
571: to_number(NULL)
572: into role_info_tbl(1)
573: from WF_ROLES R
574: where R.ORIG_SYSTEM = l_origSystem
575: and R.ORIG_SYSTEM_ID = l_origSystemID
576: and R.NAME = GetRoleInfo2.role
577: and rownum = 1;

Line 1001: from wf_roles

997: cursor c_role is
998: select name,
999: substrb(display_name,1,360)
1000: p_display_name
1001: from wf_roles
1002: where orig_system = p_orig_system
1003: and orig_system_id = p_orig_system_id
1004: order by status, start_date;
1005: begin

Line 1035: from wf_roles

1031: colon pls_integer;
1032:
1033: cursor c_role (l_name in varchar2) is
1034: select substrb(display_name,1,360)
1035: from wf_roles
1036: where name = l_name
1037: and PARTITION_ID not in (9,8,7,6,4);
1038:
1039: cursor corig_role (l_name in varchar2, l_origSys in varchar2,

Line 1042: from wf_roles

1038:
1039: cursor corig_role (l_name in varchar2, l_origSys in varchar2,
1040: l_origSysID in number) is
1041: select substrb(display_name,1,360)
1042: from wf_roles
1043: where orig_system = l_origSys
1044: and orig_system_id = l_origSysID
1045: and name = l_name;
1046:

Line 1047: l_display_name wf_roles.display_name%TYPE;

1043: where orig_system = l_origSys
1044: and orig_system_id = l_origSysID
1045: and name = l_name;
1046:
1047: l_display_name wf_roles.display_name%TYPE;
1048: invalidNumConv EXCEPTION;
1049: pragma exception_init(invalidNumConv, -6502);
1050: begin
1051: begin

Line 2049: -- Check if role name exists in wf_roles

2045: d1 pls_integer;
2046:
2047: begin
2048: --
2049: -- Check if role name exists in wf_roles
2050: --
2051: if (role_name is not null and role_display_name is not null) then
2052: /* GK: The display name does not have to be unique
2053:

Line 2055: from wf_roles

2051: if (role_name is not null and role_display_name is not null) then
2052: /* GK: The display name does not have to be unique
2053:
2054: select count(1) into d1
2055: from wf_roles
2056: where name = CreateAdHocRole.role_name
2057: or display_name = CreateAdHocRole.role_display_name;
2058: if (d1 > 0) then
2059: wf_core.token('ROLENAME', CreateAdHocRole.role_name);

Line 4533: -- User attributes as in WF_ROLES view

4529: --
4530: -- IN
4531: -- email address
4532: -- OUT
4533: -- User attributes as in WF_ROLES view
4534: --
4535: -- This API queries wf_roles view for information of the user when
4536: -- the e-mail address is given.
4537: procedure GetInfoFromMail(mailid in varchar2,

Line 4535: -- This API queries wf_roles view for information of the user when

4531: -- email address
4532: -- OUT
4533: -- User attributes as in WF_ROLES view
4534: --
4535: -- This API queries wf_roles view for information of the user when
4536: -- the e-mail address is given.
4537: procedure GetInfoFromMail(mailid in varchar2,
4538: role out NOCOPY varchar2,
4539: display_name out NOCOPY varchar2,

Line 4589: from WF_ROLES R

4585: STATUS,
4586: EXPIRATION_DATE,
4587: ORIG_SYSTEM,
4588: ORIG_SYSTEM_ID
4589: from WF_ROLES R
4590: where UPPER(email_address) = UPPER(l_email)
4591: and STATUS = 'ACTIVE';
4592: exception
4593: when no_data_found then

Line 4617: from WF_ROLES R

4613: STATUS,
4614: EXPIRATION_DATE,
4615: ORIG_SYSTEM,
4616: ORIG_SYSTEM_ID
4617: from WF_ROLES R
4618: where UPPER(email_address) = UPPER(l_email);
4619: end;
4620: exception
4621: when others then

Line 4832: where exists (select null from wf_roles

4828: --check whether the role name is truly end dated
4829:
4830: select 1 into l_count
4831: from SYS.DUAL
4832: where exists (select null from wf_roles
4833: where name=p_name
4834: );
4835:
4836: --if we have reached here, it implies that the user or role