DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on WF_DIRECTORY

Line 82: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;

78: and wia.item_type = wiav.item_type
79: and wia.name = wiav.name
80: and wiav.text_value = l_oldname;
81:
82: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
83:
84: begin
85: l_newname := upper(substrb(NewName,1,320));
86: l_oldname := upper(substrb(OldName,1,320));

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

97: We then check to be sure the new name is active and ready to receive
98: the records from the old name.
99: */
100:
101: WF_DIRECTORY.GetRoleInfo2(l_oldName, l_roleInfoTAB);
102:
103: if (l_roleInfoTAB(1).display_name is not NULL) then
104: if not (WF_DIRECTORY.ChangeLocalUsername(l_oldname, l_newname, FALSE)) then
105: WF_CORE.Token('ROLE', l_oldname);

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

100:
101: WF_DIRECTORY.GetRoleInfo2(l_oldName, l_roleInfoTAB);
102:
103: if (l_roleInfoTAB(1).display_name is not NULL) then
104: if not (WF_DIRECTORY.ChangeLocalUsername(l_oldname, l_newname, FALSE)) then
105: WF_CORE.Token('ROLE', l_oldname);
106: WF_CORE.Token('PROCEDURE', 'PropagateChangedName');
107: WF_CORE.Token('PARAMETER', 'OldName');
108: WF_CORE.Raise('WFMTN_ACTIVEROLE');

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

109: return;
110: end if;
111: end if;
112:
113: WF_DIRECTORY.GetRoleInfo2(l_newname, l_roleInfoTAB);
114:
115: if (l_roleInfoTAB(1).display_name is null) then
116: WF_CORE.Token('ROLE', l_newname);
117: WF_CORE.Raise('WFNTF_ROLE');

Line 295: l_roleSrcTAB WF_DIRECTORY.roleTable;

291: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
292: TYPE origTab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
293: TYPE ownerTAGTAB IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
294:
295: l_roleSrcTAB WF_DIRECTORY.roleTable;
296: l_userSrcTAB WF_DIRECTORY.userTable;
297: l_roleDestTAB WF_DIRECTORY.roleTable;
298: l_userDestTAB WF_DIRECTORY.userTable;
299: l_rowIDTAB idTab;

Line 296: l_userSrcTAB WF_DIRECTORY.userTable;

292: TYPE origTab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
293: TYPE ownerTAGTAB IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
294:
295: l_roleSrcTAB WF_DIRECTORY.roleTable;
296: l_userSrcTAB WF_DIRECTORY.userTable;
297: l_roleDestTAB WF_DIRECTORY.roleTable;
298: l_userDestTAB WF_DIRECTORY.userTable;
299: l_rowIDTAB idTab;
300: l_rowIDSrcTAB idTab;

Line 297: l_roleDestTAB WF_DIRECTORY.roleTable;

293: TYPE ownerTAGTAB IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
294:
295: l_roleSrcTAB WF_DIRECTORY.roleTable;
296: l_userSrcTAB WF_DIRECTORY.userTable;
297: l_roleDestTAB WF_DIRECTORY.roleTable;
298: l_userDestTAB WF_DIRECTORY.userTable;
299: l_rowIDTAB idTab;
300: l_rowIDSrcTAB idTab;
301: l_rowIDDestTAB idTab;

Line 298: l_userDestTAB WF_DIRECTORY.userTable;

294:
295: l_roleSrcTAB WF_DIRECTORY.roleTable;
296: l_userSrcTAB WF_DIRECTORY.userTable;
297: l_roleDestTAB WF_DIRECTORY.roleTable;
298: l_userDestTAB WF_DIRECTORY.userTable;
299: l_rowIDTAB idTab;
300: l_rowIDSrcTAB idTab;
301: l_rowIDDestTAB idTab;
302: l_stgIDTAB idTab;

Line 326: l_assigningRoleSrcTAB WF_DIRECTORY.roleTable;

322: l_userOrigSrcTAB origTab;
323: l_roleOrigSrcTAB origTab;
324: l_userOrigDestTAB origTab;
325: l_roleOrigDestTAB origTab;
326: l_assigningRoleSrcTAB WF_DIRECTORY.roleTable;
327: l_asgStartSrcTAB dateTab;
328: l_asgEndSrcTAB dateTab;
329: l_startSrcTAB dateTab;
330: l_endSrcTAB dateTab;