APPS.PER_MAINTAIN_TASKFLOW SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

PROCEDURE delete_taskflow (
  p_taskflow_name IN VARCHAR2
) IS
l_workflow_id NUMBER;

Line: 16

  SELECT nav_node_usage_id
  FROM   hr_navigation_node_usages
  WHERE  workflow_id = l_workflow_id;

Line: 23

   SELECT workflow_id
   INTO   l_workflow_id
   FROM   hr_workflows
   WHERE  workflow_name = p_taskflow_name;

Line: 33

      DELETE FROM hr_navigation_paths
      WHERE       from_nav_node_usage_id = l_nav_node_usage_id
      OR          to_nav_node_usage_id = l_nav_node_usage_id;

Line: 36

      DELETE FROM hr_navigation_node_usages
      WHERE       nav_node_usage_id = l_nav_node_usage_id;

Line: 42

   DELETE FROM hr_workflows
   WHERE       workflow_id = l_workflow_id;

Line: 44

END delete_taskflow;

Line: 49

PROCEDURE delete_navigation_unit (
  p_form_name IN VARCHAR2,
  p_block_name IN VARCHAR2
) IS
l_nav_unit_id NUMBER;

Line: 60

  SELECT nav_node_id, name
  FROM   hr_navigation_nodes
  WHERE  nav_unit_id = l_nav_unit_id;

Line: 67

  SELECT global_usage_id
  FROM   hr_nav_unit_global_usages
  WHERE  nav_unit_id = l_nav_unit_id;

Line: 74

   SELECT nav_unit_id
   INTO   l_nav_unit_id
   FROM   hr_navigation_units
   WHERE  form_name = p_form_name
   AND    nvl(block_name,hr_api.g_varchar2) = nvl(p_block_name,hr_api.g_varchar2);

Line: 86

      delete_navigation_node(l_node_name);

Line: 95

      DELETE FROM hr_navigation_context_rules
      WHERE       global_usage_id = l_global_usage_id;

Line: 97

      DELETE FROM hr_nav_unit_global_usages
      WHERE       global_usage_id = l_global_usage_id;

Line: 104

   DELETE FROM hr_incompatibility_rules
   WHERE       from_nav_unit_id = l_nav_unit_id
   OR          to_nav_unit_id = l_nav_unit_id;

Line: 111

   DELETE FROM hr_navigation_units_tl
   WHERE       nav_unit_id = l_nav_unit_id;

Line: 114

   DELETE FROM hr_navigation_units
   WHERE       nav_unit_id = l_nav_unit_id;

Line: 117

END delete_navigation_unit;

Line: 122

PROCEDURE delete_navigation_node (
  p_nav_node_name IN VARCHAR2
) IS
l_nav_node_id NUMBER;

Line: 134

  SELECT nnu.nav_node_usage_id, hnp.nav_path_id
  FROM   hr_navigation_node_usages nnu,
         hr_navigation_paths hnp
  WHERE  nav_node_id = l_nav_node_id
  AND    (nnu.nav_node_usage_id = hnp.from_nav_node_usage_id
          OR nnu.nav_node_usage_id = hnp.to_nav_node_usage_id);

Line: 144

   SELECT nav_node_id
   INTO   l_nav_node_id
   FROM   hr_navigation_nodes
   WHERE  name = p_nav_node_name;

Line: 156

      DELETE FROM hr_navigation_paths_tl
      WHERE       nav_path_id           = l_nav_path_id;

Line: 159

      DELETE FROM hr_navigation_paths
      WHERE       from_nav_node_usage_id = l_nav_node_usage_id
      OR          to_nav_node_usage_id = l_nav_node_usage_id
      OR          nav_path_id           = l_nav_path_id;

Line: 164

      DELETE FROM hr_navigation_node_usages
      WHERE       nav_node_usage_id = l_nav_node_usage_id;

Line: 170

   DELETE FROM hr_navigation_nodes
   WHERE       nav_node_id = l_nav_node_id;

Line: 172

END delete_navigation_node;