APPS.PQH_RATE_FACTOR_ON_ELMNTS_API SQL Statements

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

Line: 207

procedure update_rate_factor_on_elmnt
  (p_validate                     in     boolean   default false
  ,p_effective_date               in     date
  ,p_rate_factor_on_elmnt_id      in     number
  ,p_criteria_rate_element_id     in     number    default hr_api.g_number
  ,p_criteria_rate_factor_id      in     number    default hr_api.g_number
  ,p_rate_factor_val_record_tbl   in     varchar2  default hr_api.g_varchar2
  ,p_rate_factor_val_record_col   in     varchar2  default hr_api.g_varchar2
  ,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: 223

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

Line: 230

  savepoint update_rate_factor_on_elmnt;

Line: 246

procedure update_rate_factor_on_elmnt_b
  (
   p_effective_date               in     date
  ,p_rate_factor_on_elmnt_id      in     number
  ,p_criteria_rate_element_id     in     number
  ,p_criteria_rate_factor_id      in     number
  ,p_rate_factor_val_record_tbl   in     varchar2
  ,p_rate_factor_val_record_col   in     varchar2
  ,p_business_group_id            in     number
  ,p_legislation_code             in     varchar2
  ,p_object_version_number        in     number
  );

Line: 261

  PQH_RATE_FACTOR_ON_ELMNTS_BK2.update_rate_factor_on_elmnt_b
  ( p_effective_date                 => l_effective_date
  ,p_criteria_rate_element_id       => p_criteria_rate_element_id
  ,p_criteria_rate_factor_id        => p_criteria_rate_factor_id
  ,p_rate_factor_val_record_tbl     => p_rate_factor_val_record_tbl
  ,p_rate_factor_val_record_col     => p_rate_factor_val_record_col
  ,p_business_group_id              => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_rate_factor_on_elmnt_id        => p_rate_factor_on_elmnt_id
  ,p_object_version_number          => l_object_version_number
  );

Line: 275

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

Line: 304

  PQH_RATE_FACTOR_ON_ELMNTS_BK2.update_rate_factor_on_elmnt_a
  ( p_effective_date                 => l_effective_date
  ,p_criteria_rate_element_id       => p_criteria_rate_element_id
  ,p_criteria_rate_factor_id        => p_criteria_rate_factor_id
  ,p_rate_factor_val_record_tbl     => p_rate_factor_val_record_tbl
  ,p_rate_factor_val_record_col     => p_rate_factor_val_record_col
  ,p_business_group_id              => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_rate_factor_on_elmnt_id        => p_rate_factor_on_elmnt_id
  ,p_object_version_number          => l_object_version_number
  );

Line: 318

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

Line: 340

    rollback to update_rate_factor_on_elmnt;

Line: 352

    rollback to update_rate_factor_on_elmnt;

Line: 360

end update_rate_factor_on_elmnt;

Line: 368

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

  l_effective_date      date;

Line: 379

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

Line: 385

  savepoint delete_rate_factor_on_elmnt;

Line: 399

    PQH_RATE_FACTOR_ON_ELMNTS_BK3.delete_rate_factor_on_elmnt_b
    (	   p_effective_date                => l_effective_date
	  ,p_rate_factor_on_elmnt_id        => p_rate_factor_on_elmnt_id
	  ,p_object_version_number     => p_object_version_number
      );

Line: 407

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

Line: 431

    PQH_RATE_FACTOR_ON_ELMNTS_BK3.delete_rate_factor_on_elmnt_a
      (p_effective_date                => l_effective_date
	  ,p_rate_factor_on_elmnt_id   => p_rate_factor_on_elmnt_id
	  ,p_object_version_number     => p_object_version_number
      );

Line: 439

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

Line: 460

    rollback to delete_rate_factor_on_elmnt;

Line: 471

    rollback to delete_rate_factor_on_elmnt;

Line: 478

end delete_rate_factor_on_elmnt;