Line 78: AND nvl(block_name,hr_api.g_varchar2) = nvl(p_block_name,hr_api.g_varchar2);
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
81: -- the delete_navigation_nodes procedure to delete the navigation
82: -- node data. This includes node usages and navigation paths.