APPS.PQH_RATE_ELEMENT_RELATIONS_API SQL Statements

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

Line: 196

procedure update_rate_element_relation
  (p_validate                     in     boolean   default false
  ,p_effective_date               in     date
  ,p_rate_element_relation_id     in     number
  ,p_criteria_rate_element_id     in     number    default hr_api.g_number
  ,p_relation_type_cd             in     varchar2  default hr_api.g_varchar2
  ,p_rel_element_type_id          in     number    default hr_api.g_number
  ,p_rel_input_value_id           in     number    default hr_api.g_number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  )is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 212

  l_proc                varchar2(72) := g_package||'update_rate_element_relation';

Line: 219

  savepoint update_rate_element_relation;

Line: 236

procedure update_rate_element_relation_b
 (
   p_effective_date               in     date
  ,p_rate_element_relation_id     in     number
  ,p_criteria_rate_element_id     in     number
  ,p_relation_type_cd             in     varchar2
  ,p_rel_element_type_id          in     number
  ,p_rel_input_value_id           in     number
  ,p_business_group_id            in     number
  ,p_legislation_code             in     varchar2
  ,p_object_version_number        in     number
  );

Line: 251

  PQH_RATE_ELEMENT_RELATIONS_BK2.update_rate_element_relation_b
  (
   p_effective_date                 => l_effective_date
  ,p_criteria_rate_element_id       => p_criteria_rate_element_id
  ,p_relation_type_cd		    => p_relation_type_cd
  ,p_rel_element_type_id	    => p_rel_element_type_id
  ,p_rel_input_value_id 	    => p_rel_input_value_id
  ,p_business_group_id		    => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_rate_element_relation_id       => p_rate_element_relation_id
  ,p_object_version_number          => l_object_version_number
  );

Line: 266

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

Line: 295

  PQH_RATE_ELEMENT_RELATIONS_BK2.update_rate_element_relation_a
  (
   p_effective_date                 => l_effective_date
  ,p_criteria_rate_element_id       => p_criteria_rate_element_id
  ,p_relation_type_cd		    => p_relation_type_cd
  ,p_rel_element_type_id	    => p_rel_element_type_id
  ,p_rel_input_value_id 	    => p_rel_input_value_id
  ,p_business_group_id		    => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_rate_element_relation_id       => p_rate_element_relation_id
  ,p_object_version_number          => l_object_version_number
  );

Line: 310

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

Line: 332

    rollback to update_rate_element_relation;

Line: 344

    rollback to update_rate_element_relation;

Line: 352

end update_rate_element_relation;

Line: 360

procedure delete_rate_element_relation
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_rate_element_relation_id       in 		number
  ,p_object_version_number         in 		number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_effective_date      date;

Line: 371

  l_proc                varchar2(72) := g_package||'delete_rate_element_relation';

Line: 377

  savepoint delete_rate_element_relation;

Line: 391

    PQH_RATE_ELEMENT_RELATIONS_BK3.delete_rate_element_relation_b
    (	   p_effective_date                => l_effective_date
	  ,p_rate_element_relation_id        => p_rate_element_relation_id
	  ,p_object_version_number     => p_object_version_number
      );

Line: 399

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

Line: 423

    PQH_RATE_ELEMENT_RELATIONS_BK3.delete_rate_element_relation_a
      (p_effective_date                => l_effective_date
	  ,p_rate_element_relation_id   => p_rate_element_relation_id
	  ,p_object_version_number     => p_object_version_number
      );

Line: 431

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

Line: 452

    rollback to delete_rate_element_relation;

Line: 463

    rollback to delete_rate_element_relation;

Line: 470

end delete_rate_element_relation;