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_DIRECTORY dependencies on WF_ROLE_HIERARCHY

Line 2307: WF_ROLE_HIERARCHY.Calculate_Effective_Dates

2303: l_rpartID, l_partitionName);
2304: end if;
2305:
2306: -- Determine the effective dates for the user/role
2307: WF_ROLE_HIERARCHY.Calculate_Effective_Dates
2308: ( CreateUserRole.start_date,
2309: CreateUserRole.end_date,
2310: l_userStartDate,
2311: l_userExpDate,

Line 2453: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);

2449: to_char(l_rOrigSysId)||'|'||
2450: to_char(SYSDATE, 'J:SSSSS');
2451: event.Parameter_List := l_params;
2452: sub_id:= hextoraw('1');
2453: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);
2454: if (result='SUCCESS') then
2455: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2456: end if;
2457: else

Line 2455: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);

2451: event.Parameter_List := l_params;
2452: sub_id:= hextoraw('1');
2453: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);
2454: if (result='SUCCESS') then
2455: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2456: end if;
2457: else
2458: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.created',
2459: p_event_key=> l_uOrigSys||':'||

Line 2843: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);

2839: to_char(SYSDATE, 'J:SSSSS');
2840:
2841: event.Parameter_List := l_params;
2842: sub_id :=hextoraw('1');
2843: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);
2844: if (result='SUCCESS') then
2845: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2846: end if;
2847: else

Line 2845: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);

2841: event.Parameter_List := l_params;
2842: sub_id :=hextoraw('1');
2843: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);
2844: if (result='SUCCESS') then
2845: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2846: end if;
2847: else
2848: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.updated',
2849: p_event_key=> l_uOrigSys||':'||

Line 4868: -- also call wf_role_hierarchy.removeRelaionship to delete all hierarchical

4864: p_userorigSystemID=>p_origSystemID);
4865: else
4866: -- a role has been removed so call deleteUserRoles to remove all user/role
4867: -- associations for the role.
4868: -- also call wf_role_hierarchy.removeRelaionship to delete all hierarchical
4869: -- relationships in which the role participates.
4870: begin
4871: select relationship_id bulk collect into l_relIDTab
4872: from wf_role_hierarchies where sub_name=p_name

Line 4876: WF_ROLE_HIERARCHY.RemoveRelationship(l_relIDTab(i),TRUE);

4872: from wf_role_hierarchies where sub_name=p_name
4873: or super_name = p_name;
4874: if (l_relIDTAB.count>0) then
4875: for i in l_relIDTAB.first..l_RelIDTAB.last loop
4876: WF_ROLE_HIERARCHY.RemoveRelationship(l_relIDTab(i),TRUE);
4877: end loop;
4878: end if;
4879: exception
4880: when no_data_found then