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 2449: WF_ROLE_HIERARCHY.Calculate_Effective_Dates

2445: l_rpartID, l_partitionName);
2446: end if;
2447:
2448: -- Determine the effective dates for the user/role
2449: WF_ROLE_HIERARCHY.Calculate_Effective_Dates
2450: ( CreateUserRole.start_date,
2451: CreateUserRole.end_date,
2452: l_userStartDate,
2453: l_userExpDate,

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

2591: to_char(l_rOrigSysId)||'|'||
2592: to_char(SYSDATE, 'J:SSSSS');
2593: event.Parameter_List := l_params;
2594: sub_id:= hextoraw('1');
2595: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);
2596: if (result='SUCCESS') then
2597: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2598: end if;
2599: else

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

2593: event.Parameter_List := l_params;
2594: sub_id:= hextoraw('1');
2595: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);
2596: if (result='SUCCESS') then
2597: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2598: end if;
2599: else
2600: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.created',
2601: p_event_key=> l_uOrigSys||':'||

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

2987: to_char(SYSDATE, 'J:SSSSS');
2988:
2989: event.Parameter_List := l_params;
2990: sub_id :=hextoraw('1');
2991: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);
2992: if (result='SUCCESS') then
2993: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2994: end if;
2995: else

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

2989: event.Parameter_List := l_params;
2990: sub_id :=hextoraw('1');
2991: result:= WF_ROLE_HIERARCHY.Cascade_RF(sub_id,event);
2992: if (result='SUCCESS') then
2993: result:= WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF(sub_id,event);
2994: end if;
2995: else
2996: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.wf.ds.userRole.updated',
2997: p_event_key=> l_uOrigSys||':'||

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

5001: p_userorigSystemID=>p_origSystemID);
5002: else
5003: -- a role has been removed so call deleteUserRoles to remove all user/role
5004: -- associations for the role.
5005: -- also call wf_role_hierarchy.removeRelaionship to delete all hierarchical
5006: -- relationships in which the role participates.
5007: begin
5008: select relationship_id bulk collect into l_relIDTab
5009: from wf_role_hierarchies where sub_name=p_name

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

5009: from wf_role_hierarchies where sub_name=p_name
5010: or super_name = p_name;
5011: if (l_relIDTAB.count>0) then
5012: for i in l_relIDTAB.first..l_RelIDTAB.last loop
5013: WF_ROLE_HIERARCHY.RemoveRelationship(l_relIDTab(i),TRUE);
5014: end loop;
5015: end if;
5016: exception
5017: when no_data_found then