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 665: INSERT INTO WF_USER_ROLE_ASSIGNMENTS

661: l_EffEndDate);
662:
663: --
664:
665: INSERT INTO WF_USER_ROLE_ASSIGNMENTS
666: ( USER_NAME,
667: ROLE_NAME,
668: RELATIONSHIP_ID,
669: ASSIGNING_ROLE,

Line 788: INSERT INTO WF_USER_ROLE_ASSIGNMENTS

784: l_EffEndDate);
785:
786: --Creating the assignment record for each user/role assignment.
787: begin
788: INSERT INTO WF_USER_ROLE_ASSIGNMENTS
789: ( USER_NAME,
790: ROLE_NAME,
791: RELATIONSHIP_ID,
792: ASSIGNING_ROLE,

Line 845: UPDATE WF_USER_ROLE_ASSIGNMENTS

841: exception
842: when DUP_VAL_ON_INDEX then
843: if (OverWrite and UpdateWho) then
844: --allow update of creation_date and created_by
845: UPDATE WF_USER_ROLE_ASSIGNMENTS
846: SET END_DATE = l_EndDate,
847: START_DATE = l_StartDate,
848: USER_START_DATE = l_UserStartDate,
849: USER_END_DATE = l_UserEndDate,

Line 866: UPDATE WF_USER_ROLE_ASSIGNMENTS

862: AND USER_NAME = l_UserName
863: AND ROLE_NAME = l_superiors(l_count).SUPER_NAME
864: AND ASSIGNING_ROLE = l_RoleName;
865: elsif UpdateWho then
866: UPDATE WF_USER_ROLE_ASSIGNMENTS
867: SET END_DATE = l_EndDate,
868: START_DATE = l_StartDate,
869: USER_START_DATE = l_UserStartDate,
870: USER_END_DATE = l_UserEndDate,

Line 885: UPDATE WF_USER_ROLE_ASSIGNMENTS

881: AND USER_NAME = l_UserName
882: AND ROLE_NAME = l_superiors(l_count).SUPER_NAME
883: AND ASSIGNING_ROLE = l_RoleName;
884: else
885: UPDATE WF_USER_ROLE_ASSIGNMENTS
886: SET END_DATE = l_EndDate,
887: START_DATE = l_StartDate,
888: USER_START_DATE = l_UserStartDate,
889: USER_END_DATE = l_UserEndDate,

Line 1170: delete from WF_USER_ROLE_ASSIGNMENTS

1166: --parallel branches).
1167: if (l_relIDTAB.COUNT > 0) then
1168: <>
1169: forall hitIND in l_relIDTAB.FIRST..l_relIDTAB.LAST
1170: delete from WF_USER_ROLE_ASSIGNMENTS
1171: where RELATIONSHIP_ID = l_relIDTAB(hitIND)
1172: and ASSIGNING_ROLE = l_assignTAB(subIND)
1173: returning USER_NAME, ROLE_NAME
1174: bulk collect into l_userTAB, l_roleTAB;

Line 1183: from wf_user_role_assignments

1179: l_roleTAB(userIND));
1180:
1181: select min(effective_start_Date),max(effective_end_date)
1182: into l_effStartDate, l_effEndDate
1183: from wf_user_role_assignments
1184: where user_name= l_userTAB(userIND)
1185: and role_name = l_roleTAB(userIND);
1186:
1187:

Line 1249: from WF_USER_ROLE_ASSIGNMENTS

1245: PARTITION_ID, USER_ORIG_SYSTEM, USER_ORIG_SYSTEM_ID
1246: bulk collect into l_userTAB, l_assignTAB, l_startDateTAB, l_endDateTAB,
1247: l_uStartDateTAB, l_uEndDateTAB, l_aStartDateTAB,
1248: l_aEndDateTAB, l_apartIDTAB, l_uorigSysTAB, l_uorigSysIDTAB
1249: from WF_USER_ROLE_ASSIGNMENTS
1250: where ROLE_NAME = l_subName;
1251:
1252: --We will propagate the newly inherited assignments before the
1253: --associated user/role relationships because of the functionality of the

Line 1284: insert into WF_USER_ROLE_ASSIGNMENTS (USER_NAME,

1280: l_aEndDateTAB(userIND),
1281: l_effStartDate,
1282: l_effEndDate);
1283:
1284: insert into WF_USER_ROLE_ASSIGNMENTS (USER_NAME,
1285: ROLE_NAME,
1286: RELATIONSHIP_ID,
1287: ASSIGNING_ROLE,
1288: START_DATE,

Line 1337: update WF_USER_ROLE_ASSIGNMENTS

1333: exception
1334: when DUP_VAL_ON_INDEX then
1335: --This can happen if there is a parallel branch.
1336: --We will just update the timestamp.
1337: update WF_USER_ROLE_ASSIGNMENTS
1338: set START_DATE = trunc(l_startDateTAB(userIND)),
1339: END_DATE = trunc(l_endDateTAB(userIND)),
1340: USER_START_DATE = trunc(l_uStartDateTAB(userIND)),
1341: USER_END_DATE = trunc(l_uEndDateTAB(userIND)),

Line 1391: from wf_user_role_Assignments

1387:
1388: select min(effective_start_date),
1389: max(effective_end_date)
1390: into l_effStartDate, l_effEndDate
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,

Line 1448: FROM WF_USER_ROLE_ASSIGNMENTS_V

1444: --timestamp
1445: if (l_assignmentType = 'I') then
1446: SELECT min(start_date)
1447: INTO l_startDateTAB(userIND)
1448: FROM WF_USER_ROLE_ASSIGNMENTS_V
1449: WHERE USER_NAME = l_userTAB(userIND)
1450: AND ROLE_NAME = l_roleTAB(roleIND);
1451:
1452: SELECT max(end_date)

Line 1454: FROM WF_USER_ROLE_ASSIGNMENTS_V

1450: AND ROLE_NAME = l_roleTAB(roleIND);
1451:
1452: SELECT max(end_date)
1453: INTO l_endDateTAB(userIND)
1454: FROM WF_USER_ROLE_ASSIGNMENTS_V
1455: WHERE USER_NAME = l_userTAB(userIND)
1456: AND ROLE_NAME = l_roleTAB(roleIND);
1457:
1458: end if;

Line 1609: from WF_USER_ROLE_ASSIGNMENTS

1605: ROLE_START_DATE, ROLE_END_DATE,USER_START_DATE, USER_END_DATE,
1606: ASSIGNING_ROLE_START_DATE, ASSIGNING_ROLE_END_DATE, EFFECTIVE_START_DATE,
1607: EFFECTIVE_END_DATE,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1608: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
1609: from WF_USER_ROLE_ASSIGNMENTS
1610: where (ROLE_NAME = c_roleName or ASSIGNING_ROLE = c_roleName)
1611: and USER_NAME=c_userName;
1612:
1613: cursor c_UserRoleAssignments_u (c_userName in varchar2)

Line 1620: from WF_USER_ROLE_ASSIGNMENTS

1616: ROLE_START_DATE, ROLE_END_DATE,USER_START_DATE, USER_END_DATE,
1617: ASSIGNING_ROLE_START_DATE, ASSIGNING_ROLE_END_DATE, EFFECTIVE_START_DATE,
1618: EFFECTIVE_END_DATE ,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1619: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
1620: from WF_USER_ROLE_ASSIGNMENTS
1621: where USER_NAME=c_userName;
1622:
1623: cursor c_UserRoleAssignments_r (c_roleName in varchar2)
1624: is

Line 1630: from WF_USER_ROLE_ASSIGNMENTS

1626: ROLE_START_DATE, ROLE_END_DATE,USER_START_DATE, USER_END_DATE,
1627: ASSIGNING_ROLE_START_DATE, ASSIGNING_ROLE_END_DATE, EFFECTIVE_START_DATE,
1628: EFFECTIVE_END_DATE,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1629: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
1630: from WF_USER_ROLE_ASSIGNMENTS
1631: where ROLE_NAME = c_roleName
1632: or ASSIGNING_ROLE = c_roleName;
1633:
1634: begin

Line 1764: update WF_USER_ROLE_ASSIGNMENTS

1760: --all of the start/end dates and calculated effective start/end dates
1761: --We can then issue the bulk update.
1762: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
1763:
1764: update WF_USER_ROLE_ASSIGNMENTS
1765: set ROLE_START_DATE = l_roleStartTAB(tabIndex),
1766: ROLE_END_DATE = l_roleEndTAB(tabIndex),
1767: USER_START_DATE = l_userStartTAB(tabIndex),
1768: USER_END_DATE = l_userEndTAB(tabIndex),

Line 1833: -- summary table of WF_USER_ROLE_ASSIGNMENTS

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

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

1900: l_lastUpdDtDestTAB dateTab;
1901: l_lastUpdByDestTAB numTab;
1902: l_lastUpdLogDestTAB numTab;
1903:
1904: --retrieve all WF_USER_ROLE_ASSIGNMENTS records which need to
1905: --get summarised
1906: --A User/Role was updated.
1907:
1908: --<6028394:rwunderl> Sub-select necessary to catch effected user/roles

Line 1916: from WF_USER_ROLE_ASSIGNMENTS

1912: ROLE_END_DATE, USER_START_DATE, USER_END_DATE, EFFECTIVE_START_DATE,
1913: EFFECTIVE_END_DATE, START_DATE, END_DATE, RELATIONSHIP_ID,
1914: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1915: CREATION_DATE, CREATED_BY
1916: from WF_USER_ROLE_ASSIGNMENTS
1917: where USER_NAME=c_userName
1918: and ROLE_NAME in (select ROLE_NAME
1919: from WF_USER_ROLE_ASSIGNMENTS
1920: where ASSIGNING_ROLE = c_roleName

Line 1919: from WF_USER_ROLE_ASSIGNMENTS

1915: CREATION_DATE, CREATED_BY
1916: from WF_USER_ROLE_ASSIGNMENTS
1917: where USER_NAME=c_userName
1918: and ROLE_NAME in (select ROLE_NAME
1919: from WF_USER_ROLE_ASSIGNMENTS
1920: where ASSIGNING_ROLE = c_roleName
1921: and USER_NAME = c_userName)
1922: order by ROLE_NAME, USER_NAME;
1923:

Line 1933: from WF_USER_ROLE_ASSIGNMENTS

1929: ROLE_END_DATE, USER_START_DATE, USER_END_DATE, EFFECTIVE_START_DATE,
1930: EFFECTIVE_END_DATE, START_DATE, END_DATE, RELATIONSHIP_ID,
1931: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1932: CREATION_DATE, CREATED_BY
1933: from WF_USER_ROLE_ASSIGNMENTS
1934: where USER_NAME=c_userName
1935: order by ROLE_NAME, USER_NAME;
1936:
1937: --A Role was updated.

Line 1948: -- from WF_USER_ROLE_ASSIGNMENTS

1944: -- ROLE_END_DATE, USER_START_DATE, USER_END_DATE, EFFECTIVE_START_DATE,
1945: -- EFFECTIVE_END_DATE, START_DATE,END_DATE, RELATIONSHIP_ID,
1946: -- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1947: -- CREATION_DATE, CREATED_BY
1948: -- from WF_USER_ROLE_ASSIGNMENTS
1949: -- where ROLE_NAME=c_roleName or ASSIGNING_ROLE=c_roleName
1950: -- order by ROLE_NAME, USER_NAME;
1951: select ura.ROWID, ura.ROLE_NAME, ura.USER_NAME, ura.ROLE_START_DATE,
1952: ura.ROLE_END_DATE, ura.USER_START_DATE, ura.USER_END_DATE, ura.EFFECTIVE_START_DATE,

Line 1956: from WF_USER_ROLE_ASSIGNMENTS ura,

1952: ura.ROLE_END_DATE, ura.USER_START_DATE, ura.USER_END_DATE, ura.EFFECTIVE_START_DATE,
1953: ura.EFFECTIVE_END_DATE, ura.START_DATE, ura.END_DATE, ura.RELATIONSHIP_ID,
1954: ura.LAST_UPDATE_DATE, ura.LAST_UPDATED_BY, ura.LAST_UPDATE_LOGIN,
1955: ura.CREATION_DATE, ura.CREATED_BY
1956: from WF_USER_ROLE_ASSIGNMENTS ura,
1957: WF_USER_ROLE_ASSIGNMENTS ura2
1958: where ura2.ASSIGNING_ROLE= c_roleName
1959: and ura2.ROLE_NAME= ura.ROLE_NAME
1960: and ura2.USER_NAME = ura.USER_NAME

Line 1957: WF_USER_ROLE_ASSIGNMENTS ura2

1953: ura.EFFECTIVE_END_DATE, ura.START_DATE, ura.END_DATE, ura.RELATIONSHIP_ID,
1954: ura.LAST_UPDATE_DATE, ura.LAST_UPDATED_BY, ura.LAST_UPDATE_LOGIN,
1955: ura.CREATION_DATE, ura.CREATED_BY
1956: from WF_USER_ROLE_ASSIGNMENTS ura,
1957: WF_USER_ROLE_ASSIGNMENTS ura2
1958: where ura2.ASSIGNING_ROLE= c_roleName
1959: and ura2.ROLE_NAME= ura.ROLE_NAME
1960: and ura2.USER_NAME = ura.USER_NAME
1961: order by ura.ROLE_NAME, ura.USER_NAME;

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

2011:
2012: return 'SUCCESS';
2013: end if;
2014:
2015: ---retrieve all WF_USER_ROLE_ASSIGNMENTS records which need to
2016: --get summarized
2017:
2018: if (l_userName is NOT NULL and l_roleName is NOT NULL) then
2019: open c_userRoleAssignments (l_userName , l_roleName);