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 769: FROM WF_LOCAL_ROLES

765: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID,
766: START_DATE, EXPIRATION_DATE
767: INTO l_roleOrigSystem,l_roleOrigSystemID,
768: l_SupStartDate, l_SupEndDate
769: FROM WF_LOCAL_ROLES
770: WHERE NAME=l_superiors(l_count).SUPER_NAME
771: AND rownum<2;
772:
773: --Calculate the effective_dates for each of these assignments

Line 1236: from WF_LOCAL_ROLES

1232: START_DATE, EXPIRATION_DATE
1233: into l_rorigSysTAB(roleIND), l_rorigSysIDTAB(roleIND),
1234: l_rpartIDTAB(roleIND), l_rStartDateTAB(roleIND),
1235: l_rEndDateTAB(roleIND)
1236: from WF_LOCAL_ROLES
1237: where NAME = l_roleTAB(roleIND);
1238: end loop Superiors_Info;
1239:
1240: --Retrieve any direct or inherited assignments to the subordinate

Line 2646: FROM WF_LOCAL_ROLES

2642: begin
2643: begin
2644: SELECT ORIG_SYSTEM, PARTITION_ID
2645: INTO l_sub_origSys, l_partitionID
2646: FROM WF_LOCAL_ROLES
2647: WHERE NAME = p_sub_name;
2648: exception
2649: when NO_DATA_FOUND then
2650: WF_CORE.Token('NAME', p_sub_name);

Line 2657: FROM WF_LOCAL_ROLES

2653:
2654: begin
2655: SELECT ORIG_SYSTEM, PARTITION_ID
2656: INTO l_super_origSys, l_superPartitionID
2657: FROM WF_LOCAL_ROLES
2658: WHERE NAME = p_super_name;
2659: exception
2660: when NO_DATA_FOUND then
2661: WF_CORE.Token('NAME', p_super_name);