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 670: WF_DIRECTORY.AssignPartition(p_orig_system=>l_RoleOrigSystem,

666: -- We made it here so that means there are no assignments.
667: -- First, we must create the assignment record for the direct assignment.
668:
669: --
670: WF_DIRECTORY.AssignPartition(p_orig_system=>l_RoleOrigSystem,
671: p_partitionID=>l_partitionID,
672: p_partitionName=>l_partitionName);
673: --calculate the effective dates for the direct assignment
674:

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

780: g_modulePkg||'.Cascade_RF',
781: 'Beginning user/role inheritance for '||l_UserName||
782: ' to '||l_superiors(l_count).SUPER_NAME);
783: end if;
784: --WF_DIRECTORY.GetRoleOrigSysInfo(l_superiors(l_count).SUPER_NAME,
785: -- l_roleOrigSystem, l_roleOrigSystemID);
786:
787: -- Get superior roles' role orig system info, dates and partitionID
788: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID,

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

928:
929: begin
930: --We will create/update the actual user/role record's timestamp only
931: --The effectivity dates will be set by the assignments.
932: WF_DIRECTORY.CreateUserRole(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 955: WF_DIRECTORY.SetUserRoleAttr(user_name=>l_UserName,

951: --Updating the existing user/role with an assignment_type of 'X'.
952: --The recursive call to cascade_RF() will validate the
953: --assignment_type and set it to the proper value.
954: WF_CORE.Clear;
955: WF_DIRECTORY.SetUserRoleAttr(user_name=>l_UserName,
956: role_name=>l_superiors(l_count).SUPER_NAME,
957: start_date=>l_startDate,
958: end_date=>l_endDate,
959: user_orig_system=>l_userOrigSystem,

Line 1082: l_userTAB WF_DIRECTORY.UserTable;

1078: TYPE flagTAB is TABLE of VARCHAR2(1) index by binary_integer;
1079:
1080: --Local Variables.
1081: l_relIDTAB numberTAB;
1082: l_userTAB WF_DIRECTORY.UserTable;
1083: l_roleTAB WF_DIRECTORY.RoleTable;
1084: l_assignTAB WF_DIRECTORY.RoleTable;
1085: l_ownerTAB WF_DIRECTORY.RoleTable;
1086: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;

Line 1083: l_roleTAB WF_DIRECTORY.RoleTable;

1079:
1080: --Local Variables.
1081: l_relIDTAB numberTAB;
1082: l_userTAB WF_DIRECTORY.UserTable;
1083: l_roleTAB WF_DIRECTORY.RoleTable;
1084: l_assignTAB WF_DIRECTORY.RoleTable;
1085: l_ownerTAB WF_DIRECTORY.RoleTable;
1086: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1087: l_uorigSysIDTAB numberTAB;

Line 1084: l_assignTAB WF_DIRECTORY.RoleTable;

1080: --Local Variables.
1081: l_relIDTAB numberTAB;
1082: l_userTAB WF_DIRECTORY.UserTable;
1083: l_roleTAB WF_DIRECTORY.RoleTable;
1084: l_assignTAB WF_DIRECTORY.RoleTable;
1085: l_ownerTAB WF_DIRECTORY.RoleTable;
1086: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1087: l_uorigSysIDTAB numberTAB;
1088: l_rorigSysTAB WF_DIRECTORY.RoleTable;

Line 1085: l_ownerTAB WF_DIRECTORY.RoleTable;

1081: l_relIDTAB numberTAB;
1082: l_userTAB WF_DIRECTORY.UserTable;
1083: l_roleTAB WF_DIRECTORY.RoleTable;
1084: l_assignTAB WF_DIRECTORY.RoleTable;
1085: l_ownerTAB WF_DIRECTORY.RoleTable;
1086: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1087: l_uorigSysIDTAB numberTAB;
1088: l_rorigSysTAB WF_DIRECTORY.RoleTable;
1089: l_rorigSysIDTAB numberTAB;

Line 1086: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;

1082: l_userTAB WF_DIRECTORY.UserTable;
1083: l_roleTAB WF_DIRECTORY.RoleTable;
1084: l_assignTAB WF_DIRECTORY.RoleTable;
1085: l_ownerTAB WF_DIRECTORY.RoleTable;
1086: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1087: l_uorigSysIDTAB numberTAB;
1088: l_rorigSysTAB WF_DIRECTORY.RoleTable;
1089: l_rorigSysIDTAB numberTAB;
1090: l_rpartIDTAB numberTAB;

Line 1088: l_rorigSysTAB WF_DIRECTORY.RoleTable;

1084: l_assignTAB WF_DIRECTORY.RoleTable;
1085: l_ownerTAB WF_DIRECTORY.RoleTable;
1086: l_uorigSysTAB WF_DIRECTORY.OrigSysTable;
1087: l_uorigSysIDTAB numberTAB;
1088: l_rorigSysTAB WF_DIRECTORY.RoleTable;
1089: l_rorigSysIDTAB numberTAB;
1090: l_rpartIDTAB numberTAB;
1091: l_apartIDTAB numberTAB;
1092: l_startDateTAB dateTAB;

Line 1608: l_roleTAB WF_DIRECTORY.roleTable;

1604:
1605: TYPE dateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1606: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1607: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1608: l_roleTAB WF_DIRECTORY.roleTable;
1609: l_userTAB WF_DIRECTORY.userTable;
1610: l_assigningRoleTAB WF_DIRECTORY.roleTable;
1611: l_asgStartTAB dateTab;
1612: l_asgEndTAB dateTab;

Line 1609: l_userTAB WF_DIRECTORY.userTable;

1605: TYPE dateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1606: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1607: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1608: l_roleTAB WF_DIRECTORY.roleTable;
1609: l_userTAB WF_DIRECTORY.userTable;
1610: l_assigningRoleTAB WF_DIRECTORY.roleTable;
1611: l_asgStartTAB dateTab;
1612: l_asgEndTAB dateTab;
1613: l_rowIDTAB idTab;

Line 1610: l_assigningRoleTAB WF_DIRECTORY.roleTable;

1606: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1607: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1608: l_roleTAB WF_DIRECTORY.roleTable;
1609: l_userTAB WF_DIRECTORY.userTable;
1610: l_assigningRoleTAB WF_DIRECTORY.roleTable;
1611: l_asgStartTAB dateTab;
1612: l_asgEndTAB dateTab;
1613: l_rowIDTAB idTab;
1614: l_userStartTAB dateTab;

Line 1894: l_roleSrcTAB WF_DIRECTORY.roleTable;

1890: TYPE dateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1891: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1892: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1893:
1894: l_roleSrcTAB WF_DIRECTORY.roleTable;
1895: l_userSrcTAB WF_DIRECTORY.userTable;
1896: l_roleDestTAB WF_DIRECTORY.roleTable;
1897: l_userDestTAB WF_DIRECTORY.userTable;
1898:

Line 1895: l_userSrcTAB WF_DIRECTORY.userTable;

1891: TYPE numTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1892: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1893:
1894: l_roleSrcTAB WF_DIRECTORY.roleTable;
1895: l_userSrcTAB WF_DIRECTORY.userTable;
1896: l_roleDestTAB WF_DIRECTORY.roleTable;
1897: l_userDestTAB WF_DIRECTORY.userTable;
1898:
1899: l_rowIDTAB idTab;

Line 1896: l_roleDestTAB WF_DIRECTORY.roleTable;

1892: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1893:
1894: l_roleSrcTAB WF_DIRECTORY.roleTable;
1895: l_userSrcTAB WF_DIRECTORY.userTable;
1896: l_roleDestTAB WF_DIRECTORY.roleTable;
1897: l_userDestTAB WF_DIRECTORY.userTable;
1898:
1899: l_rowIDTAB idTab;
1900: l_userStartSrcTAB dateTab;

Line 1897: l_userDestTAB WF_DIRECTORY.userTable;

1893:
1894: l_roleSrcTAB WF_DIRECTORY.roleTable;
1895: l_userSrcTAB WF_DIRECTORY.userTable;
1896: l_roleDestTAB WF_DIRECTORY.roleTable;
1897: l_userDestTAB WF_DIRECTORY.userTable;
1898:
1899: l_rowIDTAB idTab;
1900: l_userStartSrcTAB dateTab;
1901: l_roleStartSrcTAB dateTab;