APPS.WF_ROLE_HIERARCHY dependencies on WF_LOCAL_ROLES

Line 518: FROM WF_LOCAL_ROLES

514:
515: if (l_partitionID = 1) then
516: SELECT START_DATE, EXPIRATION_DATE
517: INTO l_UserStartDate, l_UserEndDate
518: FROM WF_LOCAL_ROLES
519: WHERE NAME = l_UserName
520: AND PARTITION_ID = l_partitionID
521: and rownum<2;
522: else

Line 525: FROM WF_LOCAL_ROLES

521: and rownum<2;
522: else
523: SELECT START_DATE, EXPIRATION_DATE
524: INTO l_UserStartDate, l_UserEndDate
525: FROM WF_LOCAL_ROLES
526: WHERE NAME = l_UserName
527: AND ORIG_SYSTEM= l_UserOrigSystem
528: AND ORIG_SYSTEM_ID = l_UserOrigSystemID
529: AND PARTITION_ID = l_partitionID

Line 539: FROM WF_LOCAL_ROLES

535: p_partitionName=>l_partitionName);
536: if (l_partitionID= 1) then
537: SELECT START_DATE, EXPIRATION_DATE
538: INTO l_RoleStartDate, l_RoleEndDate
539: FROM WF_LOCAL_ROLES
540: WHERE NAME = l_RoleName
541: AND PARTITION_ID = l_partitionID
542: AND rownum<2;
543: else

Line 546: FROM WF_LOCAL_ROLES

542: AND rownum<2;
543: else
544: SELECT START_DATE, EXPIRATION_DATE
545: INTO l_RoleStartDate, l_RoleEndDate
546: FROM WF_LOCAL_ROLES
547: WHERE NAME = l_RoleName
548: AND ORIG_SYSTEM= l_RoleOrigSystem
549: AND ORIG_SYSTEM_ID = l_RoleOrigSystemID
550: AND PARTITION_ID = l_partitionID

Line 792: FROM WF_LOCAL_ROLES

788: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID,
789: START_DATE, EXPIRATION_DATE, PARTITION_ID
790: INTO l_roleOrigSystem,l_roleOrigSystemID,
791: l_SupStartDate, l_SupEndDate, l_partitionID
792: FROM WF_LOCAL_ROLES
793: WHERE NAME=l_superiors(l_count).SUPER_NAME
794: AND rownum<2;
795:
796: --Calculate the effective_dates for each of these assignments

Line 1264: from WF_LOCAL_ROLES

1260: START_DATE, EXPIRATION_DATE
1261: into l_rorigSysTAB(roleIND), l_rorigSysIDTAB(roleIND),
1262: l_rpartIDTAB(roleIND), l_rStartDateTAB(roleIND),
1263: l_rEndDateTAB(roleIND)
1264: from WF_LOCAL_ROLES
1265: where NAME = l_roleTAB(roleIND);
1266: end loop Superiors_Info;
1267:
1268: --Retrieve any direct or inherited assignments to the subordinate

Line 2605: FROM WF_LOCAL_ROLES

2601: begin
2602: begin
2603: SELECT ORIG_SYSTEM, PARTITION_ID
2604: INTO l_sub_origSys, l_partitionID
2605: FROM WF_LOCAL_ROLES
2606: WHERE NAME = p_sub_name;
2607: exception
2608: when NO_DATA_FOUND then
2609: WF_CORE.Token('NAME', p_sub_name);

Line 2616: FROM WF_LOCAL_ROLES

2612:
2613: begin
2614: SELECT ORIG_SYSTEM, PARTITION_ID
2615: INTO l_super_origSys, l_superPartitionID
2616: FROM WF_LOCAL_ROLES
2617: WHERE NAME = p_super_name;
2618: exception
2619: when NO_DATA_FOUND then
2620: WF_CORE.Token('NAME', p_super_name);