APPS.PQP_EXR_API SQL Statements

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

Line: 185

procedure update_exception_report
  (p_validate                      in     boolean  default false
  ,p_exception_report_name          in     varchar2 default hr_api.g_varchar2
  ,p_legislation_code               in     varchar2 default hr_api.g_varchar2
  ,p_business_group_id              in     number   default hr_api.g_number
  ,p_currency_code                  in     varchar2 default hr_api.g_varchar2
  ,p_balance_type_id                in     number   default hr_api.g_number
  ,p_balance_dimension_id           in     number   default hr_api.g_number
  ,p_variance_type                  in     varchar2 default hr_api.g_varchar2
  ,p_variance_value                 in     number   default hr_api.g_number
  ,p_comparison_type                in     varchar2 default hr_api.g_varchar2
  ,p_comparison_value               in     number   default hr_api.g_number
  ,p_exception_report_id            in     number   default hr_api.g_number
  ,p_language_code                  in     varchar2 default hr_api.userenv_lang
  ,p_object_version_number          in out nocopy number
  ,p_output_format_type             in     varchar2 default hr_api.g_varchar2
  ,p_variance_operator              in     varchar2 default hr_api.g_varchar2

  ) is

  --
  -- Declare cursors and local variables
  --

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

Line: 217

  savepoint update_exception_report;

Line: 228

    pqp_exception_report_bk2.update_exception_report_b
      (p_exception_report_name => p_exception_report_name
  ,p_legislation_code          => p_legislation_code
  ,p_business_group_id         => p_business_group_id
  ,p_currency_code             => p_currency_code
  ,p_balance_type_id           => p_balance_type_id
  ,p_balance_dimension_id      => p_balance_dimension_id
  ,p_variance_type             => p_variance_type
  ,p_variance_value            => p_variance_value
  ,p_comparison_type           => p_comparison_type
  ,p_comparison_value          => p_comparison_value
  ,p_exception_report_id       => p_exception_report_id
  ,p_object_version_number     => p_object_version_number
  ,p_output_format_type        => p_output_format_type
  ,p_variance_operator         => p_variance_operator
      );

Line: 247

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

Line: 293

    pqp_exception_report_bk2.update_exception_report_a
      (p_exception_report_name => p_exception_report_name
  ,p_legislation_code          => p_legislation_code
  ,p_business_group_id         => p_business_group_id
  ,p_currency_code             => p_currency_code
  ,p_balance_type_id           => p_balance_type_id
  ,p_balance_dimension_id      => p_balance_dimension_id
  ,p_variance_type             => p_variance_type
  ,p_variance_value            => p_variance_value
  ,p_comparison_type           => p_comparison_type
  ,p_comparison_value          => p_comparison_value
  ,p_exception_report_id       => p_exception_report_id
  ,p_object_version_number     => l_object_version_number
  ,p_output_format_type        => p_output_format_type
  ,p_variance_operator         => p_variance_operator
      );

Line: 312

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

Line: 335

    rollback to update_exception_report;

Line: 347

    rollback to update_exception_report;

Line: 351

end update_exception_report;

Line: 357

procedure delete_exception_report
  (p_validate                      in     boolean  default false
  ,p_exception_report_id           in     number
  ,p_object_version_number         in     number
  ) is

  --
  -- Declare cursors and local variables
  --
  cursor csr_bg_id (c_exception_report_id in number) is
  select per.business_group_id
    from pqp_exception_reports per
   where per.exception_report_id = c_exception_report_id;

Line: 372

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

Line: 379

  savepoint delete_exception_report;

Line: 391

    pqp_exception_report_bk3.delete_exception_report_b
      (p_exception_report_id   => p_exception_report_id
      ,p_business_group_id     => l_business_group_id
      ,p_object_version_number => p_object_version_number
      );

Line: 399

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

Line: 429

    pqp_exception_report_bk3.delete_exception_report_a
      (p_exception_report_id   => p_exception_report_id
      ,p_business_group_id     => l_business_group_id
      ,p_object_version_number => p_object_version_number
      );

Line: 437

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

Line: 459

    rollback to delete_exception_report;

Line: 470

    rollback to delete_exception_report;

Line: 473

end delete_exception_report;