APPS.HR_CAL_ENTRY_VALUE_API SQL Statements

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

Line: 157

procedure update_entry_value
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_cal_entry_value_id            in     number
  ,p_object_version_number         in out nocopy number
  ,p_override_name                 in     varchar2     default hr_api.g_varchar2
  ,p_override_type                 in     varchar2     default hr_api.g_varchar2
  ,p_parent_entry_value_id         in     number       default hr_api.g_number
  ,p_usage_flag                    in     varchar2     default hr_api.g_varchar2
  ) IS

  --
  -- Declare cursors and local variables
  --
  l_proc                   varchar2(80) := g_package||'update_entry_value';

Line: 181

  savepoint update_cal_entry_value;

Line: 194

    HR_CAL_ENTRY_VALUE_BK2.update_entry_value_b
       (p_effective_date                => l_effective_date
       ,p_cal_entry_value_id            => p_cal_entry_value_id
       ,p_object_version_number         => l_object_version_number
       ,p_override_name                 => p_override_name
       ,p_override_type                 => p_override_type
       ,p_parent_entry_value_id         => p_parent_entry_value_id
       ,p_usage_flag                    => p_usage_flag
       );

Line: 206

        (p_module_name => 'update_entry_value_b'
        ,p_hook_type   => 'BP'
        );

Line: 228

      HR_CAL_ENTRY_VALUE_BK2.update_entry_value_a
       (p_effective_date                => l_effective_date
       ,p_cal_entry_value_id            => p_cal_entry_value_id
       ,p_object_version_number         => l_object_version_number
       ,p_override_name                 => p_override_name
       ,p_override_type                 => p_override_type
       ,p_parent_entry_value_id         => p_parent_entry_value_id
       ,p_usage_flag                    => p_usage_flag
      );

Line: 241

        (p_module_name => 'update_entry_value_a'
        ,p_hook_type   => 'AP'
        );

Line: 263

    rollback to update_cal_entry_value;

Line: 274

    rollback to update_cal_entry_value;

Line: 277

end update_entry_value;

Line: 284

procedure delete_entry_value
  (p_validate                      in     boolean  default false
  ,p_cal_entry_value_id            in     number
  ,p_object_version_number         in     number
  ) IS
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_entry_value';

Line: 299

  savepoint delete_cal_entry_value;

Line: 304

    HR_CAL_ENTRY_VALUE_BK3.delete_entry_value_b
     (p_cal_entry_value_id       => p_cal_entry_value_id,
      p_object_version_number   => p_object_version_number
     );

Line: 311

          (p_module_name => 'delete_entry_value_b',
           p_hook_type   => 'BP'
          );

Line: 331

    HR_CAL_ENTRY_VALUE_BK3.delete_entry_value_a
     (p_cal_entry_value_id       => p_cal_entry_value_id
     ,p_object_version_number   => p_object_version_number
     );

Line: 338

           (p_module_name  => 'delete_entry_value_a',
            p_hook_type   => 'AP'
           );

Line: 356

    ROLLBACK TO delete_cal_entry_value;

Line: 363

  ROLLBACK TO delete_cal_entry_value;

Line: 367

end delete_entry_value;

Line: 379

   SELECT flex_value_set_id,validation_type
   FROM   fnd_flex_value_sets
   WHERE  flex_value_set_name  = (SELECT pgt.child_value_set
                                  FROM per_gen_hier_node_types pgt
                                  WHERE pgt.child_node_type = p_node_type);

Line: 389

   SELECT value_set_id
   FROM   per_calendar_entries pce
   WHERE  pce.CALENDAR_ENTRY_ID = p_calendar_entry_id;

Line: 394

    SELECT description
    FROM fnd_flex_values_vl
    WHERE flex_value = p_entity_id
    AND flex_value_set_id = l_value_set_id;

Line: 449

    l_str := 'select '||substr(l_v_r.table_info.id_column_name,1,instr(l_v_r.table_info.id_column_name||' ',' '))||','
                        ||substr(l_v_r.table_info.value_column_name,1,instr(l_v_r.table_info.value_column_name||' ',' '))
                      ||' from '
                      ||l_v_r.table_info.table_name||' '||l_whr;

Line: 500

    l_id_column := SUBSTR(l_sql_statement,(INSTR(UPPER(l_sql_statement),'SELECT') +7)
                                          ,INSTR(UPPER(l_sql_statement),',') -
                                       (INSTR(UPPER(l_sql_statement),'SELECT')+ 7));

Line: 608

  select PARENT_HIERARCHY_NODE_ID from per_gen_hierarchy_nodes
  where HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
  connect by HIERARCHY_NODE_ID = prior PARENT_HIERARCHY_NODE_ID
         AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
  start with HIERARCHY_NODE_ID = P_HIERARCHY_NODE_ID;

Line: 643

  select ORG_STRUCTURE_ELEMENT_ID from PER_ORG_STRUCTURE_ELEMENTS
  where ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
  connect by ORGANIZATION_ID_CHILD = prior ORGANIZATION_ID_PARENT
  	     AND ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
  start with ORG_STRUCTURE_ELEMENT_ID = P_ORG_STRUCTURE_ELEMENT_ID;

Line: 704

  l_str := 'select '||substr(l_v_r.table_info.id_column_name,1,instr(l_v_r.table_info.id_column_name||' ',' '))||','
                    ||substr(l_v_r.table_info.value_column_name,1,instr(l_v_r.table_info.value_column_name||' ',' '))
                    ||' from '
                    ||l_v_r.table_info.table_name||' '||l_whr;