DBA Data[Home] [Help]

APPS.PER_MAINTAIN_TASKFLOW dependencies on HR_NAV_UNIT_GLOBAL_USAGES

Line 68: FROM hr_nav_unit_global_usages

64: -- Cursor to bring back all of the global usages for a unit.
65: --
66: CURSOR csr_global_usages IS
67: SELECT global_usage_id
68: FROM hr_nav_unit_global_usages
69: WHERE nav_unit_id = l_nav_unit_id;
70: BEGIN
71: --
72: -- Find the nav_unit_id for the form name/block name combination.

Line 97: DELETE FROM hr_nav_unit_global_usages

93: FOR global_usage_record IN csr_global_usages LOOP
94: l_global_usage_id := global_usage_record.global_usage_id;
95: DELETE FROM hr_navigation_context_rules
96: WHERE global_usage_id = l_global_usage_id;
97: DELETE FROM hr_nav_unit_global_usages
98: WHERE global_usage_id = l_global_usage_id;
99: END LOOP;
100: --
101: -- Delete all of the incompatibility rules associated with a