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.

APPS.WF_ROLE_HIERARCHY dependencies on WF_LOCAL_USER_ROLES

Line 494: UPDATE WF_LOCAL_USER_ROLES

490: l_assignmentType := AssignmentType(p_UserName=>l_UserName,
491: p_RoleName=>l_RoleName);
492:
493: --Validate the assignment type status
494: UPDATE WF_LOCAL_USER_ROLES
495: SET ASSIGNMENT_TYPE = l_assignmentType
496: WHERE ROWID = l_rowid;
497:
498: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

Line 1192: -- remove it from WF_LOCAL_USER_ROLES knowing that only

1188: if (l_effStartDate is null) then
1189: -- implies there are no more active inherited assignments
1190: -- to this user/role. So we can expire it. Since this was
1191: -- only an inherited assignment therefore we can safely
1192: -- remove it from WF_LOCAL_USER_ROLES knowing that only
1193: -- direct assignments are shipped.
1194:
1195: delete from
1196: WF_LOCAL_USER_ROLES

Line 1196: WF_LOCAL_USER_ROLES

1192: -- remove it from WF_LOCAL_USER_ROLES knowing that only
1193: -- direct assignments are shipped.
1194:
1195: delete from
1196: WF_LOCAL_USER_ROLES
1197: where USER_NAME = l_userTAB(userIND)
1198: and ROLE_NAME = l_roleTAB(userIND);
1199:
1200: else

Line 1205: update WF_LOCAL_USER_ROLES

1201: -- implies the assignment is still active through
1202: -- some other branch.So we just update the effective
1203: -- dates and assignment type.
1204:
1205: update WF_LOCAL_USER_ROLES
1206: set ASSIGNMENT_TYPE = l_assignmentType,
1207: EFFECTIVE_START_DATE= l_effStartDate,
1208: EFFECTIVE_END_DATE = l_effEndDate,
1209: LAST_UPDATED_BY = WFA_SEC.user_id,

Line 1255: --create the actual records in WF_LOCAL_USER_ROLES, the WF_USER_ROLES

1251:
1252: --We will propagate the newly inherited assignments before the
1253: --associated user/role relationships because of the functionality of the
1254: --WF_USER_ROLES view. By propagating the assignments first, when we
1255: --create the actual records in WF_LOCAL_USER_ROLES, the WF_USER_ROLES
1256: --view will immediately pickup not only the user/role, but according
1257: --to the effective date-range. If we did this the other way around,
1258: --there may possibly be a way that a user/role relationship that is
1259: --not supposed to be visable, would appear in the view.

Line 1368: from WF_LOCAL_USER_ROLES

1364: EXPIRATION_DATE
1365: bulk collect into l_userTAB, l_uorigSysTAB, l_uorigSysIDTAB,
1366: l_ownerTAB, l_uStartDateTAB, l_uEndDateTAB,
1367: l_startDateTAB, l_endDateTAB
1368: from WF_LOCAL_USER_ROLES
1369: where ROLE_NAME = l_subName;
1370:
1371: --We will now create the user_role records in WF_LOCAL_USER_ROLES.
1372: --Outer loop to select an effected user (IE: A user that is assigned

Line 1371: --We will now create the user_role records in WF_LOCAL_USER_ROLES.

1367: l_startDateTAB, l_endDateTAB
1368: from WF_LOCAL_USER_ROLES
1369: where ROLE_NAME = l_subName;
1370:
1371: --We will now create the user_role records in WF_LOCAL_USER_ROLES.
1372: --Outer loop to select an effected user (IE: A user that is assigned
1373: --either directly or indirectly to the subordinate role of this
1374: --relationship.
1375: if (l_userTAB.COUNT > 0) then

Line 1395: insert into WF_LOCAL_USER_ROLES (USER_NAME,

1391: from wf_user_role_Assignments
1392: where user_name=l_userTAB(userIND)
1393: and role_name = l_roleTAB(roleIND);
1394:
1395: insert into WF_LOCAL_USER_ROLES (USER_NAME,
1396: ROLE_NAME,
1397: USER_ORIG_SYSTEM,
1398: USER_ORIG_SYSTEM_ID,
1399: ROLE_ORIG_SYSTEM,

Line 1460: update WF_LOCAL_USER_ROLES

1456: AND ROLE_NAME = l_roleTAB(roleIND);
1457:
1458: end if;
1459:
1460: update WF_LOCAL_USER_ROLES
1461: set START_DATE = trunc(l_startDateTAB(userIND)),
1462: EXPIRATION_DATE = trunc(l_endDateTAB(userIND)),
1463: USER_START_DATE = trunc(l_uStartDateTAB(userIND)),
1464: USER_END_DATE = trunc(l_uEndDateTAB(userIND)),

Line 1832: -- Rule Function to update WF_LOCAL_USER_ROLES as

1828:
1829:
1830:
1831: -- Aggregate_User_Roles_RF(PRIVATE)
1832: -- Rule Function to update WF_LOCAL_USER_ROLES as
1833: -- summary table of WF_USER_ROLE_ASSIGNMENTS
1834: -- IN
1835: -- p_sub_guid (RAW)
1836: -- p_event ([WF_EVENT_T])

Line 2007: UPDATE WF_LOCAL_USER_ROLES

2003: l_assignmentType := AssignmentType(p_UserName=>l_userName,
2004: p_RoleName=>l_roleName);
2005:
2006: --Validate the assignment type status
2007: UPDATE WF_LOCAL_USER_ROLES
2008: SET ASSIGNMENT_TYPE = l_assignmentType
2009: WHERE ROWID = l_rowid;
2010: end if;
2011:

Line 2087: UPDATE WF_LOCAL_USER_ROLES wur

2083: if (OverWrite) then
2084: --allow update of created_by and creation_date
2085: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
2086:
2087: UPDATE WF_LOCAL_USER_ROLES wur
2088: SET
2089: ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
2090: ROLE_END_DATE = l_roleEndDestTAB(destTabIndex),
2091: USER_START_DATE = l_userStartDestTAB(destTabIndex),

Line 2107: UPDATE WF_LOCAL_USER_ROLES wur

2103: WHERE ROLE_NAME = l_roleDestTAB(destTabIndex)
2104: AND USER_NAME = l_userDestTAB(destTabIndex);
2105: else
2106: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
2107: UPDATE WF_LOCAL_USER_ROLES wur
2108: SET
2109: ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
2110: ROLE_END_DATE = l_roleEndDestTAB(destTabIndex),
2111: USER_START_DATE = l_userStartDestTAB(destTabIndex),

Line 2249: UPDATE WF_LOCAL_USER_ROLES wur

2245: if (OverWrite) then
2246: --allow update of created_by and creation_date
2247: forall tabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
2248:
2249: UPDATE WF_LOCAL_USER_ROLES wur
2250: SET
2251: ROLE_START_DATE = l_roleStartDestTAB(tabIndex),
2252: ROLE_END_DATE = l_roleEndDestTAB(tabIndex),
2253: USER_START_DATE = l_userStartDestTAB(tabIndex),

Line 2270: UPDATE WF_LOCAL_USER_ROLES wur

2266: AND USER_NAME = l_userDestTAB(tabIndex);
2267: else
2268: forall tabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
2269:
2270: UPDATE WF_LOCAL_USER_ROLES wur
2271: SET
2272: ROLE_START_DATE = l_roleStartDestTAB(tabIndex),
2273: ROLE_END_DATE = l_roleEndDestTAB(tabIndex),
2274: USER_START_DATE = l_userStartDestTAB(tabIndex),