DBA Data[Home] [Help]

APPS.PER_MAINTAIN_TASKFLOW dependencies on HR_NAVIGATION_UNITS

Line 76: FROM hr_navigation_units

72: -- Find the nav_unit_id for the form name/block name combination.
73: --
74: SELECT nav_unit_id
75: INTO l_nav_unit_id
76: FROM hr_navigation_units
77: WHERE form_name = p_form_name
78: AND nvl(block_name,hr_api.g_varchar2) = nvl(p_block_name,hr_api.g_varchar2);
79: --
80: -- For each navigation node associated with a navigation unit call

Line 111: DELETE FROM hr_navigation_units_tl

107: --
108: -- Delete the navigation unit record.
109: --
110:
111: DELETE FROM hr_navigation_units_tl
112: WHERE nav_unit_id = l_nav_unit_id;
113:
114: DELETE FROM hr_navigation_units
115: WHERE nav_unit_id = l_nav_unit_id;

Line 114: DELETE FROM hr_navigation_units

110:
111: DELETE FROM hr_navigation_units_tl
112: WHERE nav_unit_id = l_nav_unit_id;
113:
114: DELETE FROM hr_navigation_units
115: WHERE nav_unit_id = l_nav_unit_id;
116:
117: END delete_navigation_unit;
118: