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 1218: -- remove it from WF_LOCAL_USER_ROLES knowing that only

1214: if (l_effStartDate is null) then
1215: -- implies there are no more active inherited assignments
1216: -- to this user/role. So we can expire it. Since this was
1217: -- only an inherited assignment therefore we can safely
1218: -- remove it from WF_LOCAL_USER_ROLES knowing that only
1219: -- direct assignments are shipped.
1220:
1221: delete from
1222: WF_LOCAL_USER_ROLES

Line 1222: WF_LOCAL_USER_ROLES

1218: -- remove it from WF_LOCAL_USER_ROLES knowing that only
1219: -- direct assignments are shipped.
1220:
1221: delete from
1222: WF_LOCAL_USER_ROLES
1223: where USER_NAME = l_userTAB(userIND)
1224: and ROLE_NAME = l_roleTAB(userIND);
1225:
1226: else

Line 1231: update WF_LOCAL_USER_ROLES

1227: -- implies the assignment is still active through
1228: -- some other branch.So we just update the effective
1229: -- dates and assignment type.
1230:
1231: update WF_LOCAL_USER_ROLES
1232: set ASSIGNMENT_TYPE = l_assignmentType,
1233: EFFECTIVE_START_DATE= l_effStartDate,
1234: EFFECTIVE_END_DATE = l_effEndDate,
1235: LAST_UPDATED_BY = WFA_SEC.user_id,

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

1279:
1280: --We will propagate the newly inherited assignments before the
1281: --associated user/role relationships because of the functionality of the
1282: --WF_USER_ROLES view. By propagating the assignments first, when we
1283: --create the actual records in WF_LOCAL_USER_ROLES, the WF_USER_ROLES
1284: --view will immediately pickup not only the user/role, but according
1285: --to the effective date-range. If we did this the other way around,
1286: --there may possibly be a way that a user/role relationship that is
1287: --not supposed to be visable, would appear in the view.

Line 1396: from WF_LOCAL_USER_ROLES

1392: EXPIRATION_DATE
1393: bulk collect into l_userTAB, l_uorigSysTAB, l_uorigSysIDTAB,
1394: l_ownerTAB, l_uStartDateTAB, l_uEndDateTAB,
1395: l_startDateTAB, l_endDateTAB
1396: from WF_LOCAL_USER_ROLES
1397: where ROLE_NAME = l_subName;
1398:
1399: --We will now create the user_role records in WF_LOCAL_USER_ROLES.
1400: --Outer loop to select an effected user (IE: A user that is assigned

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

1395: l_startDateTAB, l_endDateTAB
1396: from WF_LOCAL_USER_ROLES
1397: where ROLE_NAME = l_subName;
1398:
1399: --We will now create the user_role records in WF_LOCAL_USER_ROLES.
1400: --Outer loop to select an effected user (IE: A user that is assigned
1401: --either directly or indirectly to the subordinate role of this
1402: --relationship.
1403: if (l_userTAB.COUNT > 0) then

Line 1423: insert into WF_LOCAL_USER_ROLES (USER_NAME,

1419: from wf_user_role_Assignments
1420: where user_name=l_userTAB(userIND)
1421: and role_name = l_roleTAB(roleIND);
1422:
1423: insert into WF_LOCAL_USER_ROLES (USER_NAME,
1424: ROLE_NAME,
1425: USER_ORIG_SYSTEM,
1426: USER_ORIG_SYSTEM_ID,
1427: ROLE_ORIG_SYSTEM,

Line 1488: update WF_LOCAL_USER_ROLES

1484: AND ROLE_NAME = l_roleTAB(roleIND);
1485:
1486: end if;
1487:
1488: update WF_LOCAL_USER_ROLES
1489: set START_DATE = trunc(l_startDateTAB(userIND)),
1490: EXPIRATION_DATE = trunc(l_endDateTAB(userIND)),
1491: USER_START_DATE = trunc(l_uStartDateTAB(userIND)),
1492: USER_END_DATE = trunc(l_uEndDateTAB(userIND)),

Line 1860: -- Rule Function to update WF_LOCAL_USER_ROLES as

1856:
1857:
1858:
1859: -- Aggregate_User_Roles_RF(PRIVATE)
1860: -- Rule Function to update WF_LOCAL_USER_ROLES as
1861: -- summary table of WF_USER_ROLE_ASSIGNMENTS
1862: -- IN
1863: -- p_sub_guid (RAW)
1864: -- p_event ([WF_EVENT_T])

Line 2035: UPDATE WF_LOCAL_USER_ROLES

2031: l_assignmentType := AssignmentType(p_UserName=>l_userName,
2032: p_RoleName=>l_roleName);
2033:
2034: --Validate the assignment type status
2035: UPDATE WF_LOCAL_USER_ROLES
2036: SET ASSIGNMENT_TYPE = l_assignmentType
2037: WHERE ROWID = l_rowid;
2038: end if;
2039:

Line 2115: UPDATE WF_LOCAL_USER_ROLES wur

2111: if (OverWrite) then
2112: --allow update of created_by and creation_date
2113: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
2114:
2115: UPDATE WF_LOCAL_USER_ROLES wur
2116: SET
2117: ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
2118: ROLE_END_DATE = l_roleEndDestTAB(destTabIndex),
2119: USER_START_DATE = l_userStartDestTAB(destTabIndex),

Line 2135: UPDATE WF_LOCAL_USER_ROLES wur

2131: WHERE ROLE_NAME = l_roleDestTAB(destTabIndex)
2132: AND USER_NAME = l_userDestTAB(destTabIndex);
2133: else
2134: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
2135: UPDATE WF_LOCAL_USER_ROLES wur
2136: SET
2137: ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
2138: ROLE_END_DATE = l_roleEndDestTAB(destTabIndex),
2139: USER_START_DATE = l_userStartDestTAB(destTabIndex),

Line 2277: UPDATE WF_LOCAL_USER_ROLES wur

2273: if (OverWrite) then
2274: --allow update of created_by and creation_date
2275: forall tabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
2276:
2277: UPDATE WF_LOCAL_USER_ROLES wur
2278: SET
2279: ROLE_START_DATE = l_roleStartDestTAB(tabIndex),
2280: ROLE_END_DATE = l_roleEndDestTAB(tabIndex),
2281: USER_START_DATE = l_userStartDestTAB(tabIndex),

Line 2298: UPDATE WF_LOCAL_USER_ROLES wur

2294: AND USER_NAME = l_userDestTAB(tabIndex);
2295: else
2296: forall tabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
2297:
2298: UPDATE WF_LOCAL_USER_ROLES wur
2299: SET
2300: ROLE_START_DATE = l_roleStartDestTAB(tabIndex),
2301: ROLE_END_DATE = l_roleEndDestTAB(tabIndex),
2302: USER_START_DATE = l_userStartDestTAB(tabIndex),