DBA Data[Home] [Help]

APPS.WF_ROLE_HIERARCHY dependencies on WF_LOCAL_SYNCH

Line 2767: --we only validate the hierarchy if neither is in the WF_LOCAL_SYNCH.Cache

2763: end;
2764:
2765: --If either the superior or the subordinate is a newly created role we
2766: --know that it is impossible to have created a loop in the hierarchy so
2767: --we only validate the hierarchy if neither is in the WF_LOCAL_SYNCH.Cache
2768: if (NOT (WF_LOCAL_SYNCH.CheckCache(p_sub_name)) and
2769: NOT (WF_LOCAL_SYNCH.CheckCache(p_super_name))) then
2770: --Access the hierarchy to make sure a loop was not created.
2771:

Line 2768: if (NOT (WF_LOCAL_SYNCH.CheckCache(p_sub_name)) and

2764:
2765: --If either the superior or the subordinate is a newly created role we
2766: --know that it is impossible to have created a loop in the hierarchy so
2767: --we only validate the hierarchy if neither is in the WF_LOCAL_SYNCH.Cache
2768: if (NOT (WF_LOCAL_SYNCH.CheckCache(p_sub_name)) and
2769: NOT (WF_LOCAL_SYNCH.CheckCache(p_super_name))) then
2770: --Access the hierarchy to make sure a loop was not created.
2771:
2772: GetRelationships(p_name=>p_sub_name,

Line 2769: NOT (WF_LOCAL_SYNCH.CheckCache(p_super_name))) then

2765: --If either the superior or the subordinate is a newly created role we
2766: --know that it is impossible to have created a loop in the hierarchy so
2767: --we only validate the hierarchy if neither is in the WF_LOCAL_SYNCH.Cache
2768: if (NOT (WF_LOCAL_SYNCH.CheckCache(p_sub_name)) and
2769: NOT (WF_LOCAL_SYNCH.CheckCache(p_super_name))) then
2770: --Access the hierarchy to make sure a loop was not created.
2771:
2772: GetRelationships(p_name=>p_sub_name,
2773: p_superiors=>l_superiors,

Line 2777: --WF_LOCAL_SYNCH cache because they are no longer "trusted" to not

2773: p_superiors=>l_superiors,
2774: p_subordinates=>l_subordinates);
2775: else
2776: --We must be sure to delete the super and sub name from the
2777: --WF_LOCAL_SYNCH cache because they are no longer "trusted" to not
2778: --potentially cause a loop in the hierarchy.
2779: WF_LOCAL_SYNCH.DeleteCache(p_sub_name);
2780: WF_LOCAL_SYNCH.DeleteCache(p_super_name);
2781: end if;

Line 2779: WF_LOCAL_SYNCH.DeleteCache(p_sub_name);

2775: else
2776: --We must be sure to delete the super and sub name from the
2777: --WF_LOCAL_SYNCH cache because they are no longer "trusted" to not
2778: --potentially cause a loop in the hierarchy.
2779: WF_LOCAL_SYNCH.DeleteCache(p_sub_name);
2780: WF_LOCAL_SYNCH.DeleteCache(p_super_name);
2781: end if;
2782:
2783: --Raise the oracle.apps.wf.ds.roleHierarchy.relationshipCreated event

Line 2780: WF_LOCAL_SYNCH.DeleteCache(p_super_name);

2776: --We must be sure to delete the super and sub name from the
2777: --WF_LOCAL_SYNCH cache because they are no longer "trusted" to not
2778: --potentially cause a loop in the hierarchy.
2779: WF_LOCAL_SYNCH.DeleteCache(p_sub_name);
2780: WF_LOCAL_SYNCH.DeleteCache(p_super_name);
2781: end if;
2782:
2783: --Raise the oracle.apps.wf.ds.roleHierarchy.relationshipCreated event
2784: RaiseEvent(