eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WF_ROLE_HIERARCHY dependencies on WF_DIRECTORY

Line 109: WF_DIRECTORY.AssignPartition(p_origSystem, l_partitionID,

105: g_modulePkg||'.HierarchyEnabled',
106: 'Begin HierarchyEnabled('||p_origSystem||')');
107: end if;
108:
109: WF_DIRECTORY.AssignPartition(p_origSystem, l_partitionID,
110: l_partitionName);
111:
112: --First Check:If the partition is registered and the view names are
113: --set to 'NOBS' or if the partition is not registered, we return true.

Line 117: FROM WF_DIRECTORY_PARTITIONS

113: --set to 'NOBS' or if the partition is not registered, we return true.
114: begin
115: SELECT ROLE_VIEW
116: INTO l_viewName
117: FROM WF_DIRECTORY_PARTITIONS
118: WHERE ORIG_SYSTEM = UPPER(p_origSystem)
119: AND PARTITION_ID <> 0 --
120: AND (ROLE_VIEW is NULL
121: or ROLE_VIEW <> 'NOBS');

Line 511: WF_DIRECTORY.AssignPartition(p_orig_system=>l_UserOrigSystem,

507:
508: -- Since this is a direct assignment we need to retrieve the
509: -- user and role start/end dates
510:
511: WF_DIRECTORY.AssignPartition(p_orig_system=>l_UserOrigSystem,
512: p_partitionID=>l_partitionID,
513: p_partitionName=>l_partitionName);
514:
515: if (l_partitionID = 1) then

Line 533: WF_DIRECTORY.AssignPartition(p_orig_system=>l_RoleOrigSystem,

529: AND PARTITION_ID = l_partitionID
530: AND rownum<2;
531: end if;
532:
533: WF_DIRECTORY.AssignPartition(p_orig_system=>l_RoleOrigSystem,
534: p_partitionID=>l_partitionID,
535: p_partitionName=>l_partitionName);
536: if (l_partitionID= 1) then
537: SELECT START_DATE, EXPIRATION_DATE

Line 647: WF_DIRECTORY.AssignPartition(p_orig_system=>l_RoleOrigSystem,

643: -- We made it here so that means there are no assignments.
644: -- First, we must create the assignment record for the direct assignment.
645:
646: --
647: WF_DIRECTORY.AssignPartition(p_orig_system=>l_RoleOrigSystem,
648: p_partitionID=>l_partitionID,
649: p_partitionName=>l_partitionName);
650: --calculate the effective dates for the direct assignment
651:

Line 761: --WF_DIRECTORY.GetRoleOrigSysInfo(l_superiors(l_count).SUPER_NAME,

757: g_modulePkg||'.Cascade_RF',
758: 'Beginning user/role inheritance for '||l_UserName||
759: ' to '||l_superiors(l_count).SUPER_NAME);
760: end if;
761: --WF_DIRECTORY.GetRoleOrigSysInfo(l_superiors(l_count).SUPER_NAME,
762: -- l_roleOrigSystem, l_roleOrigSystemID);
763:
764: --Get the Role Start and End Dates for the superior roles
765: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID,

Line 909: WF_DIRECTORY.CreateUserRole(user_name=>l_UserName,

905:
906: begin
907: --We will create/update the actual user/role record's timestamp only
908: --The effectivity dates will be set by the assignments.
909: WF_DIRECTORY.CreateUserRole(user_name=>l_UserName,
910: role_name=>l_superiors(l_count).SUPER_NAME,
911: start_date=>l_startDate,
912: end_date=>l_endDate,
913: user_orig_system=>l_userOrigSystem,

Line 932: WF_DIRECTORY.SetUserRoleAttr(user_name=>l_UserName,

928: --Updating the existing user/role with an assignment_type of 'X'.
929: --The recursive call to cascade_RF() will validate the
930: --assignment_type and set it to the proper value.
931: WF_CORE.Clear;
932: WF_DIRECTORY.SetUserRoleAttr(user_name=>l_UserName,
933: role_name=>l_superiors(l_count).SUPER_NAME,
934: start_date=>l_startDate,
935: end_date=>l_endDate,
936: user_orig_system=>l_userOrigSystem,

Line 1060: l_userTAB WF_DIRECTORY.UserTable;

1056: TYPE flagTAB is TABLE of VARCHAR2(1) index by binary_integer;
1057:
1058: --Local Variables.
1059: l_relIDTAB numberTAB;
1060: l_userTAB WF_DIRECTORY.UserTable;
1061: l_roleTAB WF_DIRECTORY.RoleTable;
1062: l_assignTAB WF_DIRECTORY.RoleTable;
1063: l_ownerTAB WF_DIRECTORY.RoleTable;
1064: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;

Line 1061: l_roleTAB WF_DIRECTORY.RoleTable;

1057:
1058: --Local Variables.
1059: l_relIDTAB numberTAB;
1060: l_userTAB WF_DIRECTORY.UserTable;
1061: l_roleTAB WF_DIRECTORY.RoleTable;
1062: l_assignTAB WF_DIRECTORY.RoleTable;
1063: l_ownerTAB WF_DIRECTORY.RoleTable;
1064: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1065: l_uorigSysIDTAB numberTAB;

Line 1062: l_assignTAB WF_DIRECTORY.RoleTable;

1058: --Local Variables.
1059: l_relIDTAB numberTAB;
1060: l_userTAB WF_DIRECTORY.UserTable;
1061: l_roleTAB WF_DIRECTORY.RoleTable;
1062: l_assignTAB WF_DIRECTORY.RoleTable;
1063: l_ownerTAB WF_DIRECTORY.RoleTable;
1064: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1065: l_uorigSysIDTAB numberTAB;
1066: l_rorigSysTAB WF_DIRECTORY.RoleTable;

Line 1063: l_ownerTAB WF_DIRECTORY.RoleTable;

1059: l_relIDTAB numberTAB;
1060: l_userTAB WF_DIRECTORY.UserTable;
1061: l_roleTAB WF_DIRECTORY.RoleTable;
1062: l_assignTAB WF_DIRECTORY.RoleTable;
1063: l_ownerTAB WF_DIRECTORY.RoleTable;
1064: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1065: l_uorigSysIDTAB numberTAB;
1066: l_rorigSysTAB WF_DIRECTORY.RoleTable;
1067: l_rorigSysIDTAB numberTAB;

Line 1064: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;

1060: l_userTAB WF_DIRECTORY.UserTable;
1061: l_roleTAB WF_DIRECTORY.RoleTable;
1062: l_assignTAB WF_DIRECTORY.RoleTable;
1063: l_ownerTAB WF_DIRECTORY.RoleTable;
1064: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1065: l_uorigSysIDTAB numberTAB;
1066: l_rorigSysTAB WF_DIRECTORY.RoleTable;
1067: l_rorigSysIDTAB numberTAB;
1068: l_rpartIDTAB numberTAB;

Line 1066: l_rorigSysTAB WF_DIRECTORY.RoleTable;

1062: l_assignTAB WF_DIRECTORY.RoleTable;
1063: l_ownerTAB WF_DIRECTORY.RoleTable;
1064: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1065: l_uorigSysIDTAB numberTAB;
1066: l_rorigSysTAB WF_DIRECTORY.RoleTable;
1067: l_rorigSysIDTAB numberTAB;
1068: l_rpartIDTAB numberTAB;
1069: l_apartIDTAB numberTAB;
1070: l_startDateTAB dateTAB;

Line 1580: l_roleTAB WF_DIRECTORY.roleTable;

1576:
1577: TYPE dateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1578: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1579: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1580: l_roleTAB WF_DIRECTORY.roleTable;
1581: l_userTAB WF_DIRECTORY.userTable;
1582: l_assigningRoleTAB WF_DIRECTORY.roleTable;
1583: l_asgStartTAB dateTab;
1584: l_asgEndTAB dateTab;

Line 1581: l_userTAB WF_DIRECTORY.userTable;

1577: TYPE dateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1578: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1579: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1580: l_roleTAB WF_DIRECTORY.roleTable;
1581: l_userTAB WF_DIRECTORY.userTable;
1582: l_assigningRoleTAB WF_DIRECTORY.roleTable;
1583: l_asgStartTAB dateTab;
1584: l_asgEndTAB dateTab;
1585: l_rowIDTAB idTab;

Line 1582: l_assigningRoleTAB WF_DIRECTORY.roleTable;

1578: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1579: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1580: l_roleTAB WF_DIRECTORY.roleTable;
1581: l_userTAB WF_DIRECTORY.userTable;
1582: l_assigningRoleTAB WF_DIRECTORY.roleTable;
1583: l_asgStartTAB dateTab;
1584: l_asgEndTAB dateTab;
1585: l_rowIDTAB idTab;
1586: l_userStartTAB dateTab;

Line 1866: l_roleSrcTAB WF_DIRECTORY.roleTable;

1862: TYPE dateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1863: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1864: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1865:
1866: l_roleSrcTAB WF_DIRECTORY.roleTable;
1867: l_userSrcTAB WF_DIRECTORY.userTable;
1868: l_roleDestTAB WF_DIRECTORY.roleTable;
1869: l_userDestTAB WF_DIRECTORY.userTable;
1870:

Line 1867: l_userSrcTAB WF_DIRECTORY.userTable;

1863: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1864: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1865:
1866: l_roleSrcTAB WF_DIRECTORY.roleTable;
1867: l_userSrcTAB WF_DIRECTORY.userTable;
1868: l_roleDestTAB WF_DIRECTORY.roleTable;
1869: l_userDestTAB WF_DIRECTORY.userTable;
1870:
1871: l_rowIDTAB idTab;

Line 1868: l_roleDestTAB WF_DIRECTORY.roleTable;

1864: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1865:
1866: l_roleSrcTAB WF_DIRECTORY.roleTable;
1867: l_userSrcTAB WF_DIRECTORY.userTable;
1868: l_roleDestTAB WF_DIRECTORY.roleTable;
1869: l_userDestTAB WF_DIRECTORY.userTable;
1870:
1871: l_rowIDTAB idTab;
1872: l_userStartSrcTAB dateTab;

Line 1869: l_userDestTAB WF_DIRECTORY.userTable;

1865:
1866: l_roleSrcTAB WF_DIRECTORY.roleTable;
1867: l_userSrcTAB WF_DIRECTORY.userTable;
1868: l_roleDestTAB WF_DIRECTORY.roleTable;
1869: l_userDestTAB WF_DIRECTORY.userTable;
1870:
1871: l_rowIDTAB idTab;
1872: l_userStartSrcTAB dateTab;
1873: l_roleStartSrcTAB dateTab;