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_USER_ROLE_ASSIGNMENTS

Line 190: -- Calculates the effective start and end dates in WF_USER_ROLE_ASSIGNMENTS

186: -- p_effStartDate DATE
187: -- p_effEndDate DATE
188: --
189: -- NOTES
190: -- Calculates the effective start and end dates in WF_USER_ROLE_ASSIGNMENTS
191: -- from the user/role and asigning_Role start and end dates respectively
192:
193: procedure Calculate_Effective_Dates(
194: p_startDate in DATE,

Line 305: FROM WF_USER_ROLE_ASSIGNMENTS

301: end if;
302: --Determine assignment type
303: SELECT RELATIONSHIP_ID
304: BULK COLLECT INTO l_relIDTAB
305: FROM WF_USER_ROLE_ASSIGNMENTS
306: WHERE ROLE_NAME = p_RoleName
307: AND USER_NAME = p_UserName
308: AND trunc(sysdate) BETWEEN
309: trunc(EFFECTIVE_START_DATE)

Line 564: FROM WF_USER_ROLE_ASSIGNMENTS

560: SELECT ROWID, ROLE_START_DATE, ROLE_END_DATE,EFFECTIVE_START_DATE,
561: EFFECTIVE_END_DATE
562: BULK COLLECT INTO l_RowIDTAB, l_roleStartTAB,l_roleEndTAB,
563: l_effStartTAB,l_effEndTAB
564: FROM WF_USER_ROLE_ASSIGNMENTS
565: WHERE USER_NAME = l_UserName
566: AND ASSIGNING_ROLE = l_RoleName;
567:
568: if (l_rowIDTAB.COUNT > 0) then

Line 570: UPDATE WF_USER_ROLE_ASSIGNMENTS

566: AND ASSIGNING_ROLE = l_RoleName;
567:
568: if (l_rowIDTAB.COUNT > 0) then
569: -- Update Assignment Reason for direct assignment
570: UPDATE WF_USER_ROLE_ASSIGNMENTS
571: SET ASSIGNMENT_REASON = l_assignmentReason
572: WHERE USER_NAME = l_UserName
573: AND ASSIGNING_ROLE = l_RoleName
574: AND RELATIONSHIP_ID = -1;

Line 591: update WF_USER_ROLE_ASSIGNMENTS

587: end loop;
588: if OverWrite and UpdateWho then
589: --allow update of creation_date and created_by
590: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
591: update WF_USER_ROLE_ASSIGNMENTS
592: set START_DATE = l_StartDate,
593: END_DATE = l_EndDate,
594: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),
595: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),

Line 604: update WF_USER_ROLE_ASSIGNMENTS

600: EFFECTIVE_END_DATE = l_effEndTAB(tabIndex)
601: where rowid = l_rowIDTAB(tabIndex);
602: elsif UpdateWho then
603: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
604: update WF_USER_ROLE_ASSIGNMENTS
605: set START_DATE = l_StartDate,
606: END_DATE = l_EndDate,
607: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),
608: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),

Line 615: update WF_USER_ROLE_ASSIGNMENTS

611: EFFECTIVE_END_DATE = l_effEndTAB(tabIndex)
612: where rowid = l_rowIDTAB(tabIndex);
613: else -- Donot update WHO columns
614: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
615: update WF_USER_ROLE_ASSIGNMENTS
616: set START_DATE = l_StartDate,
617: END_DATE = l_EndDate,
618: EFFECTIVE_START_DATE = l_effStartTAB(tabIndex),
619: EFFECTIVE_END_DATE = l_effEndTAB(tabIndex)

Line 643: update WF_USER_ROLE_ASSIGNMENTS

639: if (l_UserName = l_RoleName) then
640: WF_ROLE_HIERARCHY.Calculate_Effective_Dates
641: (l_StartDate, l_EndDate, l_StartDate, l_EndDate, l_StartDate, l_EndDate,
642: null, null, l_effStartDate, l_effEndDate);
643: update WF_USER_ROLE_ASSIGNMENTS
644: set USER_START_DATE = l_StartDate,
645: ROLE_START_DATE = l_StartDate,
646: START_DATE = l_StartDate,
647: ASSIGNING_ROLE_START_DATE = l_StartDate,

Line 688: INSERT INTO WF_USER_ROLE_ASSIGNMENTS

684: l_EffEndDate);
685:
686: --
687:
688: INSERT INTO WF_USER_ROLE_ASSIGNMENTS
689: ( USER_NAME,
690: ROLE_NAME,
691: RELATIONSHIP_ID,
692: ASSIGNING_ROLE,

Line 811: INSERT INTO WF_USER_ROLE_ASSIGNMENTS

807: l_EffEndDate);
808:
809: --Creating the assignment record for each user/role assignment.
810: begin
811: INSERT INTO WF_USER_ROLE_ASSIGNMENTS
812: ( USER_NAME,
813: ROLE_NAME,
814: RELATIONSHIP_ID,
815: ASSIGNING_ROLE,

Line 868: UPDATE WF_USER_ROLE_ASSIGNMENTS

864: exception
865: when DUP_VAL_ON_INDEX then
866: if (OverWrite and UpdateWho) then
867: --allow update of creation_date and created_by
868: UPDATE WF_USER_ROLE_ASSIGNMENTS
869: SET END_DATE = l_EndDate,
870: START_DATE = l_StartDate,
871: USER_START_DATE = l_UserStartDate,
872: USER_END_DATE = l_UserEndDate,

Line 889: UPDATE WF_USER_ROLE_ASSIGNMENTS

885: AND USER_NAME = l_UserName
886: AND ROLE_NAME = l_superiors(l_count).SUPER_NAME
887: AND ASSIGNING_ROLE = l_RoleName;
888: elsif UpdateWho then
889: UPDATE WF_USER_ROLE_ASSIGNMENTS
890: SET END_DATE = l_EndDate,
891: START_DATE = l_StartDate,
892: USER_START_DATE = l_UserStartDate,
893: USER_END_DATE = l_UserEndDate,

Line 908: UPDATE WF_USER_ROLE_ASSIGNMENTS

904: AND USER_NAME = l_UserName
905: AND ROLE_NAME = l_superiors(l_count).SUPER_NAME
906: AND ASSIGNING_ROLE = l_RoleName;
907: else
908: UPDATE WF_USER_ROLE_ASSIGNMENTS
909: SET END_DATE = l_EndDate,
910: START_DATE = l_StartDate,
911: USER_START_DATE = l_UserStartDate,
912: USER_END_DATE = l_UserEndDate,

Line 1196: delete from WF_USER_ROLE_ASSIGNMENTS

1192: --parallel branches).
1193: if (l_relIDTAB.COUNT > 0) then
1194: <>
1195: forall hitIND in l_relIDTAB.FIRST..l_relIDTAB.LAST
1196: delete from WF_USER_ROLE_ASSIGNMENTS
1197: where RELATIONSHIP_ID = l_relIDTAB(hitIND)
1198: and ASSIGNING_ROLE = l_assignTAB(subIND)
1199: returning USER_NAME, ROLE_NAME
1200: bulk collect into l_userTAB, l_roleTAB;

Line 1209: from wf_user_role_assignments

1205: l_roleTAB(userIND));
1206:
1207: select min(effective_start_Date),max(effective_end_date)
1208: into l_effStartDate, l_effEndDate
1209: from wf_user_role_assignments
1210: where user_name= l_userTAB(userIND)
1211: and role_name = l_roleTAB(userIND);
1212:
1213:

Line 1277: from WF_USER_ROLE_ASSIGNMENTS

1273: PARTITION_ID, USER_ORIG_SYSTEM, USER_ORIG_SYSTEM_ID
1274: bulk collect into l_userTAB, l_assignTAB, l_startDateTAB, l_endDateTAB,
1275: l_uStartDateTAB, l_uEndDateTAB, l_aStartDateTAB,
1276: l_aEndDateTAB, l_apartIDTAB, l_uorigSysTAB, l_uorigSysIDTAB
1277: from WF_USER_ROLE_ASSIGNMENTS
1278: where ROLE_NAME = l_subName;
1279:
1280: --We will propagate the newly inherited assignments before the
1281: --associated user/role relationships because of the functionality of the

Line 1312: insert into WF_USER_ROLE_ASSIGNMENTS (USER_NAME,

1308: l_aEndDateTAB(userIND),
1309: l_effStartDate,
1310: l_effEndDate);
1311:
1312: insert into WF_USER_ROLE_ASSIGNMENTS (USER_NAME,
1313: ROLE_NAME,
1314: RELATIONSHIP_ID,
1315: ASSIGNING_ROLE,
1316: START_DATE,

Line 1365: update WF_USER_ROLE_ASSIGNMENTS

1361: exception
1362: when DUP_VAL_ON_INDEX then
1363: --This can happen if there is a parallel branch.
1364: --We will just update the timestamp.
1365: update WF_USER_ROLE_ASSIGNMENTS
1366: set START_DATE = trunc(l_startDateTAB(userIND)),
1367: END_DATE = trunc(l_endDateTAB(userIND)),
1368: USER_START_DATE = trunc(l_uStartDateTAB(userIND)),
1369: USER_END_DATE = trunc(l_uEndDateTAB(userIND)),

Line 1419: from wf_user_role_Assignments

1415:
1416: select min(effective_start_date),
1417: max(effective_end_date)
1418: into l_effStartDate, l_effEndDate
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,

Line 1476: FROM WF_USER_ROLE_ASSIGNMENTS_V

1472: --timestamp
1473: if (l_assignmentType = 'I') then
1474: SELECT min(start_date)
1475: INTO l_startDateTAB(userIND)
1476: FROM WF_USER_ROLE_ASSIGNMENTS_V
1477: WHERE USER_NAME = l_userTAB(userIND)
1478: AND ROLE_NAME = l_roleTAB(roleIND);
1479:
1480: SELECT max(end_date)

Line 1482: FROM WF_USER_ROLE_ASSIGNMENTS_V

1478: AND ROLE_NAME = l_roleTAB(roleIND);
1479:
1480: SELECT max(end_date)
1481: INTO l_endDateTAB(userIND)
1482: FROM WF_USER_ROLE_ASSIGNMENTS_V
1483: WHERE USER_NAME = l_userTAB(userIND)
1484: AND ROLE_NAME = l_roleTAB(roleIND);
1485:
1486: end if;

Line 1637: from WF_USER_ROLE_ASSIGNMENTS

1633: ROLE_START_DATE, ROLE_END_DATE,USER_START_DATE, USER_END_DATE,
1634: ASSIGNING_ROLE_START_DATE, ASSIGNING_ROLE_END_DATE, EFFECTIVE_START_DATE,
1635: EFFECTIVE_END_DATE,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1636: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
1637: from WF_USER_ROLE_ASSIGNMENTS
1638: where (ROLE_NAME = c_roleName or ASSIGNING_ROLE = c_roleName)
1639: and USER_NAME=c_userName;
1640:
1641: cursor c_UserRoleAssignments_u (c_userName in varchar2)

Line 1648: from WF_USER_ROLE_ASSIGNMENTS

1644: ROLE_START_DATE, ROLE_END_DATE,USER_START_DATE, USER_END_DATE,
1645: ASSIGNING_ROLE_START_DATE, ASSIGNING_ROLE_END_DATE, EFFECTIVE_START_DATE,
1646: EFFECTIVE_END_DATE ,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1647: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
1648: from WF_USER_ROLE_ASSIGNMENTS
1649: where USER_NAME=c_userName;
1650:
1651: cursor c_UserRoleAssignments_r (c_roleName in varchar2)
1652: is

Line 1658: from WF_USER_ROLE_ASSIGNMENTS

1654: ROLE_START_DATE, ROLE_END_DATE,USER_START_DATE, USER_END_DATE,
1655: ASSIGNING_ROLE_START_DATE, ASSIGNING_ROLE_END_DATE, EFFECTIVE_START_DATE,
1656: EFFECTIVE_END_DATE,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1657: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
1658: from WF_USER_ROLE_ASSIGNMENTS
1659: where ROLE_NAME = c_roleName
1660: or ASSIGNING_ROLE = c_roleName;
1661:
1662: begin

Line 1792: update WF_USER_ROLE_ASSIGNMENTS

1788: --all of the start/end dates and calculated effective start/end dates
1789: --We can then issue the bulk update.
1790: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
1791:
1792: update WF_USER_ROLE_ASSIGNMENTS
1793: set ROLE_START_DATE = l_roleStartTAB(tabIndex),
1794: ROLE_END_DATE = l_roleEndTAB(tabIndex),
1795: USER_START_DATE = l_userStartTAB(tabIndex),
1796: USER_END_DATE = l_userEndTAB(tabIndex),

Line 1861: -- summary table of WF_USER_ROLE_ASSIGNMENTS

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])
1865: -- returns

Line 1932: --retrieve all WF_USER_ROLE_ASSIGNMENTS records which need to

1928: l_lastUpdDtDestTAB dateTab;
1929: l_lastUpdByDestTAB numTab;
1930: l_lastUpdLogDestTAB numTab;
1931:
1932: --retrieve all WF_USER_ROLE_ASSIGNMENTS records which need to
1933: --get summarised
1934: --A User/Role was updated.
1935:
1936: --<6028394:rwunderl> Sub-select necessary to catch effected user/roles

Line 1944: from WF_USER_ROLE_ASSIGNMENTS

1940: ROLE_END_DATE, USER_START_DATE, USER_END_DATE, EFFECTIVE_START_DATE,
1941: EFFECTIVE_END_DATE, START_DATE, END_DATE, RELATIONSHIP_ID,
1942: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1943: CREATION_DATE, CREATED_BY
1944: from WF_USER_ROLE_ASSIGNMENTS
1945: where USER_NAME=c_userName
1946: and ROLE_NAME in (select ROLE_NAME
1947: from WF_USER_ROLE_ASSIGNMENTS
1948: where ASSIGNING_ROLE = c_roleName

Line 1947: from WF_USER_ROLE_ASSIGNMENTS

1943: CREATION_DATE, CREATED_BY
1944: from WF_USER_ROLE_ASSIGNMENTS
1945: where USER_NAME=c_userName
1946: and ROLE_NAME in (select ROLE_NAME
1947: from WF_USER_ROLE_ASSIGNMENTS
1948: where ASSIGNING_ROLE = c_roleName
1949: and USER_NAME = c_userName)
1950: order by ROLE_NAME, USER_NAME;
1951:

Line 1961: from WF_USER_ROLE_ASSIGNMENTS

1957: ROLE_END_DATE, USER_START_DATE, USER_END_DATE, EFFECTIVE_START_DATE,
1958: EFFECTIVE_END_DATE, START_DATE, END_DATE, RELATIONSHIP_ID,
1959: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1960: CREATION_DATE, CREATED_BY
1961: from WF_USER_ROLE_ASSIGNMENTS
1962: where USER_NAME=c_userName
1963: order by ROLE_NAME, USER_NAME;
1964:
1965: --A Role was updated.

Line 1976: -- from WF_USER_ROLE_ASSIGNMENTS

1972: -- ROLE_END_DATE, USER_START_DATE, USER_END_DATE, EFFECTIVE_START_DATE,
1973: -- EFFECTIVE_END_DATE, START_DATE,END_DATE, RELATIONSHIP_ID,
1974: -- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1975: -- CREATION_DATE, CREATED_BY
1976: -- from WF_USER_ROLE_ASSIGNMENTS
1977: -- where ROLE_NAME=c_roleName or ASSIGNING_ROLE=c_roleName
1978: -- order by ROLE_NAME, USER_NAME;
1979: select ura.ROWID, ura.ROLE_NAME, ura.USER_NAME, ura.ROLE_START_DATE,
1980: ura.ROLE_END_DATE, ura.USER_START_DATE, ura.USER_END_DATE, ura.EFFECTIVE_START_DATE,

Line 1984: from WF_USER_ROLE_ASSIGNMENTS ura,

1980: ura.ROLE_END_DATE, ura.USER_START_DATE, ura.USER_END_DATE, ura.EFFECTIVE_START_DATE,
1981: ura.EFFECTIVE_END_DATE, ura.START_DATE, ura.END_DATE, ura.RELATIONSHIP_ID,
1982: ura.LAST_UPDATE_DATE, ura.LAST_UPDATED_BY, ura.LAST_UPDATE_LOGIN,
1983: ura.CREATION_DATE, ura.CREATED_BY
1984: from WF_USER_ROLE_ASSIGNMENTS ura,
1985: WF_USER_ROLE_ASSIGNMENTS ura2
1986: where ura2.ASSIGNING_ROLE= c_roleName
1987: and ura2.ROLE_NAME= ura.ROLE_NAME
1988: and ura2.USER_NAME = ura.USER_NAME

Line 1985: WF_USER_ROLE_ASSIGNMENTS ura2

1981: ura.EFFECTIVE_END_DATE, ura.START_DATE, ura.END_DATE, ura.RELATIONSHIP_ID,
1982: ura.LAST_UPDATE_DATE, ura.LAST_UPDATED_BY, ura.LAST_UPDATE_LOGIN,
1983: ura.CREATION_DATE, ura.CREATED_BY
1984: from WF_USER_ROLE_ASSIGNMENTS ura,
1985: WF_USER_ROLE_ASSIGNMENTS ura2
1986: where ura2.ASSIGNING_ROLE= c_roleName
1987: and ura2.ROLE_NAME= ura.ROLE_NAME
1988: and ura2.USER_NAME = ura.USER_NAME
1989: order by ura.ROLE_NAME, ura.USER_NAME;

Line 2043: ---retrieve all WF_USER_ROLE_ASSIGNMENTS records which need to

2039:
2040: return 'SUCCESS';
2041: end if;
2042:
2043: ---retrieve all WF_USER_ROLE_ASSIGNMENTS records which need to
2044: --get summarized
2045:
2046: if (l_userName is NOT NULL and l_roleName is NOT NULL) then
2047: open c_userRoleAssignments (l_userName , l_roleName);