APPS.PQH_RATE_MATRIX_RATES_API SQL Statements

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

Line: 184

procedure update_rate_matrix_rate
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_mode                in  varchar2
  ,p_RATE_MATRIX_RATE_ID           in number
  ,p_EFFECTIVE_START_DATE          out nocopy date
  ,p_EFFECTIVE_END_DATE            out nocopy date
  ,p_RATE_MATRIX_NODE_ID           in number
  ,p_CRITERIA_RATE_DEFN_ID         in number
  ,p_MIN_RATE_VALUE                in NUMBER default hr_api.g_number
  ,p_MAX_RATE_VALUE                in NUMBER default hr_api.g_number
  ,p_MID_RATE_VALUE                in NUMBER default hr_api.g_number
  ,p_RATE_VALUE                    in 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: 209

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

Line: 215

  savepoint update_rate_matrix_rate;

Line: 231

PQH_RATE_MATRIX_RATES_BK2.update_rate_matrix_rate_b
  (p_effective_date                => p_effective_date
  ,p_rate_matrix_rate_id           => p_rate_matrix_rate_id
  ,p_RATE_MATRIX_NODE_ID           => p_rate_matrix_node_id
  ,p_CRITERIA_RATE_DEFN_ID         => p_CRITERIA_RATE_DEFN_ID
  ,p_MIN_RATE_VALUE                => p_MIN_RATE_VALUE
  ,p_MAX_RATE_VALUE                => p_MAX_RATE_VALUE
  ,p_MID_RATE_VALUE                => p_MID_RATE_VALUE
  ,p_RATE_VALUE                    => p_rate_value
  ,p_BUSINESS_GROUP_ID             => p_business_group_id
  ,p_LEGISLATION_CODE              => p_legislation_code
  ,p_object_version_number         => p_object_version_number
  );

Line: 248

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

Line: 284

PQH_RATE_MATRIX_RATES_BK2.update_rate_matrix_rate_a
  (p_effective_date                => p_effective_date
  ,p_rate_matrix_rate_id           => p_rate_matrix_rate_id
  ,p_EFFECTIVE_START_DATE          => l_effective_start_date
  ,p_EFFECTIVE_END_DATE            => l_effective_end_date
  ,p_RATE_MATRIX_NODE_ID           => p_rate_matrix_node_id
  ,p_CRITERIA_RATE_DEFN_ID         => p_CRITERIA_RATE_DEFN_ID
  ,p_MIN_RATE_VALUE                => p_MIN_RATE_VALUE
  ,p_MAX_RATE_VALUE                => p_MAX_RATE_VALUE
  ,p_MID_RATE_VALUE                => p_MID_RATE_VALUE
  ,p_RATE_VALUE                    => p_rate_value
  ,p_BUSINESS_GROUP_ID             => p_business_group_id
  ,p_LEGISLATION_CODE              => p_legislation_code
  ,p_object_version_number         => l_object_version_number
  );

Line: 302

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

Line: 326

    rollback to update_rate_matrix_rate;

Line: 340

    rollback to update_rate_matrix_rate;

Line: 351

end update_rate_matrix_rate;

Line: 357

procedure delete_rate_matrix_rate
  (p_validate                      in     boolean  default false
  ,p_rate_matrix_rate_ID	   in     number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2)
is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 373

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

Line: 379

  savepoint delete_rate_matrix_rate;

Line: 395

 PQH_RATE_MATRIX_RATES_BK3.delete_rate_matrix_rate_b
  (p_effective_date                => l_effective_date
  ,p_rate_matrix_rate_ID      => p_rate_matrix_rate_ID
  ,p_object_version_number         => p_object_version_number
  );

Line: 403

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

Line: 432

 PQH_RATE_MATRIX_RATES_BK3.delete_rate_matrix_rate_a
  (p_effective_date                => l_effective_date
  ,p_rate_matrix_rate_ID      => p_rate_matrix_rate_ID
  ,p_object_version_number         => p_object_version_number
  );

Line: 441

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

Line: 462

    rollback to delete_rate_matrix_rate;

Line: 475

    rollback to delete_rate_matrix_rate;

Line: 485

end delete_rate_matrix_rate;