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_MAINTENANCE dependencies on WF_DIRECTORY

Line 221: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;

217: where WI.ITEM_TYPE = WIAV.ITEM_TYPE
218: and WI.ITEM_KEY = WIAV.ITEM_KEY
219: and WI.END_DATE IS NULL);
220:
221: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
222:
223: cursor cWorklistAccess is
224: select fg.rowid
225: from FND_GRANTS fg

Line 254: WF_DIRECTORY.GetRoleInfo2(l_oldName, l_roleInfoTAB);

250: We then check to be sure the new name is active and ready to receive
251: the records from the old name.
252: */
253:
254: WF_DIRECTORY.GetRoleInfo2(l_oldName, l_roleInfoTAB);
255:
256: if (l_roleInfoTAB(1).display_name is not NULL) then
257: if not (WF_DIRECTORY.ChangeLocalUsername(l_oldname, l_newname, FALSE)) then
258: WF_CORE.Token('ROLE', l_oldname);

Line 257: if not (WF_DIRECTORY.ChangeLocalUsername(l_oldname, l_newname, FALSE)) then

253:
254: WF_DIRECTORY.GetRoleInfo2(l_oldName, l_roleInfoTAB);
255:
256: if (l_roleInfoTAB(1).display_name is not NULL) then
257: if not (WF_DIRECTORY.ChangeLocalUsername(l_oldname, l_newname, FALSE)) then
258: WF_CORE.Token('ROLE', l_oldname);
259: WF_CORE.Token('PROCEDURE', 'PropagateChangedName');
260: WF_CORE.Token('PARAMETER', 'OldName');
261: WF_CORE.Raise('WFMTN_ACTIVEROLE');

Line 266: WF_DIRECTORY.GetRoleInfo2(l_newname, l_roleInfoTAB);

262: return;
263: end if;
264: end if;
265:
266: WF_DIRECTORY.GetRoleInfo2(l_newname, l_roleInfoTAB);
267:
268: if (l_roleInfoTAB(1).display_name is null) then
269: WF_CORE.Token('ROLE', l_newname);
270: WF_CORE.Raise('WFNTF_ROLE');

Line 840: l_roleSrcTAB WF_DIRECTORY.roleTable;

836: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
837: TYPE origTab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
838: TYPE ownerTAGTAB IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
839:
840: l_roleSrcTAB WF_DIRECTORY.roleTable;
841: l_userSrcTAB WF_DIRECTORY.userTable;
842: l_roleDestTAB WF_DIRECTORY.roleTable;
843: l_userDestTAB WF_DIRECTORY.userTable;
844: l_rowIDTAB idTab;

Line 841: l_userSrcTAB WF_DIRECTORY.userTable;

837: TYPE origTab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
838: TYPE ownerTAGTAB IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
839:
840: l_roleSrcTAB WF_DIRECTORY.roleTable;
841: l_userSrcTAB WF_DIRECTORY.userTable;
842: l_roleDestTAB WF_DIRECTORY.roleTable;
843: l_userDestTAB WF_DIRECTORY.userTable;
844: l_rowIDTAB idTab;
845: l_rowIDSrcTAB idTab;

Line 842: l_roleDestTAB WF_DIRECTORY.roleTable;

838: TYPE ownerTAGTAB IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
839:
840: l_roleSrcTAB WF_DIRECTORY.roleTable;
841: l_userSrcTAB WF_DIRECTORY.userTable;
842: l_roleDestTAB WF_DIRECTORY.roleTable;
843: l_userDestTAB WF_DIRECTORY.userTable;
844: l_rowIDTAB idTab;
845: l_rowIDSrcTAB idTab;
846: l_rowIDDestTAB idTab;

Line 843: l_userDestTAB WF_DIRECTORY.userTable;

839:
840: l_roleSrcTAB WF_DIRECTORY.roleTable;
841: l_userSrcTAB WF_DIRECTORY.userTable;
842: l_roleDestTAB WF_DIRECTORY.roleTable;
843: l_userDestTAB WF_DIRECTORY.userTable;
844: l_rowIDTAB idTab;
845: l_rowIDSrcTAB idTab;
846: l_rowIDDestTAB idTab;
847: l_stgIDTAB idTab;

Line 871: l_assigningRoleSrcTAB WF_DIRECTORY.roleTable;

867: l_userOrigSrcTAB origTab;
868: l_roleOrigSrcTAB origTab;
869: l_userOrigDestTAB origTab;
870: l_roleOrigDestTAB origTab;
871: l_assigningRoleSrcTAB WF_DIRECTORY.roleTable;
872: l_asgStartSrcTAB dateTab;
873: l_asgEndSrcTAB dateTab;
874: l_startSrcTAB dateTab;
875: l_endSrcTAB dateTab;

Line 1986: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;

1982: */
1983: function GetUsernameChangeCounts(p_name VARCHAR2) RETURN wfcount_tab pipelined is
1984: --l_wfcount_tab wfcount_tab;
1985: l_wfcount_tab wfcount_type;
1986: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
1987: l_partitionID WF_DIRECTORY_PARTITIONS.PARTITION_ID%TYPE;
1988: l_partitionName WF_DIRECTORY_PARTITIONS.ORIG_SYSTEM%TYPE;
1989: l_pvalue varchar2(10) := FND_PROFILE.value('WF_MAINT_COMPLETED_ITEMS');
1990: begin

Line 1987: l_partitionID WF_DIRECTORY_PARTITIONS.PARTITION_ID%TYPE;

1983: function GetUsernameChangeCounts(p_name VARCHAR2) RETURN wfcount_tab pipelined is
1984: --l_wfcount_tab wfcount_tab;
1985: l_wfcount_tab wfcount_type;
1986: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
1987: l_partitionID WF_DIRECTORY_PARTITIONS.PARTITION_ID%TYPE;
1988: l_partitionName WF_DIRECTORY_PARTITIONS.ORIG_SYSTEM%TYPE;
1989: l_pvalue varchar2(10) := FND_PROFILE.value('WF_MAINT_COMPLETED_ITEMS');
1990: begin
1991: -- First etermine if the username actually exists

Line 1988: l_partitionName WF_DIRECTORY_PARTITIONS.ORIG_SYSTEM%TYPE;

1984: --l_wfcount_tab wfcount_tab;
1985: l_wfcount_tab wfcount_type;
1986: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
1987: l_partitionID WF_DIRECTORY_PARTITIONS.PARTITION_ID%TYPE;
1988: l_partitionName WF_DIRECTORY_PARTITIONS.ORIG_SYSTEM%TYPE;
1989: l_pvalue varchar2(10) := FND_PROFILE.value('WF_MAINT_COMPLETED_ITEMS');
1990: begin
1991: -- First etermine if the username actually exists
1992: WF_DIRECTORY.GetRoleInfo2(p_name, l_roleInfoTAB);

Line 1992: WF_DIRECTORY.GetRoleInfo2(p_name, l_roleInfoTAB);

1988: l_partitionName WF_DIRECTORY_PARTITIONS.ORIG_SYSTEM%TYPE;
1989: l_pvalue varchar2(10) := FND_PROFILE.value('WF_MAINT_COMPLETED_ITEMS');
1990: begin
1991: -- First etermine if the username actually exists
1992: WF_DIRECTORY.GetRoleInfo2(p_name, l_roleInfoTAB);
1993: if l_roleInfoTAB(1).DISPLAY_NAME is null then
1994: l_wfcount_tab := null;
1995: else
1996: l_wfcount_tab.USER_NAME:=p_name;

Line 2219: WF_DIRECTORY.assignPartition(l_roleInfoTAB(1).ORIG_SYSTEM, l_partitionID, l_partitionName);

2215: l_wfcount_tab.TABLE_NAME := 'WF_ITEM_ATTRIBUTE_VALUES';
2216: pipe ROW (l_wfcount_tab);
2217:
2218: -- Now check what happens with the WFDS tables:
2219: WF_DIRECTORY.assignPartition(l_roleInfoTAB(1).ORIG_SYSTEM, l_partitionID, l_partitionName);
2220: -- Determine rows to change in WF_LOCAL_ROLES. Can be any role
2221: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2222: from WF_LOCAL_ROLES
2223: WHERE NAME = p_name