APPS.PQP_ERG_API SQL Statements

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

Line: 152

procedure update_exception_group
  (p_validate                     in     boolean   default false
  ,p_exception_group_id           in     number    default hr_api.g_number
  ,p_exception_group_name         in     varchar2  default hr_api.g_varchar2
  ,p_exception_report_id          in     number    default hr_api.g_number
  ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_consolidation_set_id         in     number    default hr_api.g_number
  ,p_payroll_id                   in     number    default hr_api.g_number
  ,p_object_version_number        in out nocopy number
  ,p_output_format                in     varchar2  default hr_api.g_varchar2
  ) is

  --
  -- Declare cursors and local variables
  --

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

Line: 178

  savepoint update_exception_group;

Line: 186

    pqp_exception_group_bk2.update_exception_group_b
      (p_exception_group_name    => p_exception_group_name
      ,p_exception_report_id     => p_exception_report_id
      ,p_legislation_code        => p_legislation_code
      ,p_business_group_id       => p_business_group_id
      ,p_consolidation_set_id    => p_consolidation_set_id
      ,p_payroll_id              => p_payroll_id
      ,p_exception_group_id      => p_exception_group_id
      ,p_object_version_number   => p_object_version_number
      );

Line: 199

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

Line: 234

    pqp_exception_group_bk2.update_exception_group_a
      (p_exception_group_name    => p_exception_group_name
      ,p_exception_report_id     => p_exception_report_id
      ,p_legislation_code        => p_legislation_code
      ,p_business_group_id       => p_business_group_id
      ,p_consolidation_set_id    => p_consolidation_set_id
      ,p_payroll_id              => p_payroll_id
      ,p_exception_group_id      => p_exception_group_id
      ,p_object_version_number   => l_object_version_number
      );

Line: 247

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

Line: 270

    rollback to update_exception_group;

Line: 282

    rollback to update_exception_group;

Line: 286

end update_exception_group;

Line: 292

procedure delete_exception_group
  (p_validate                      in     boolean  default false
  ,p_exception_group_id            in     number
  ,p_object_version_number         in     number
  ) is

  --
  -- Declare cursors and local variables
  --

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

Line: 309

  savepoint delete_exception_group;

Line: 316

    pqp_exception_group_bk3.delete_exception_group_b
      (p_exception_group_id => p_exception_group_id
      ,p_object_version_number => p_object_version_number
      );

Line: 323

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

Line: 350

    pqp_exception_group_bk3.delete_exception_group_a
      (p_exception_group_id => p_exception_group_id
      ,p_object_version_number => p_object_version_number
      );

Line: 357

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

Line: 379

    rollback to delete_exception_group;

Line: 390

    rollback to delete_exception_group;

Line: 393

end delete_exception_group;

Line: 399

procedure delete_exception_group
  (p_validate                      in     boolean  default false
  ,p_exception_group_name          in     varchar2
  ,p_business_group_id		   in	  number
  ) is

  --
  -- Declare cursors and local variables
  --
  Cursor c_GrpDets Is
  Select * from pqp_exception_report_groups
  Where exception_group_name = p_exception_group_name
    and business_group_id    = p_business_group_id;

Line: 418

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

Line: 428

    pqp_erg_api.delete_exception_group
      		(p_validate			=> p_validate
      		,p_exception_group_id		=> r_GrpDets.exception_group_id
      		,p_object_version_number	=> r_GrpDets.object_version_number
      		);

Line: 448

end delete_exception_group;