APPS.OTA_CONFERENCE_SERVER_API SQL Statements

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

Line: 254

procedure update_conference_server
  (p_effective_date               in  date
  ,p_conference_server_id         in  number
  ,p_name                         in  varchar2
  ,p_description                  in  varchar2
  ,p_url                          in  varchar2
  ,p_type                         in  varchar2
  ,p_owc_site_id                  in  varchar2         default hr_api.g_varchar2
  ,p_owc_auth_token               in  varchar2         default hr_api.g_varchar2
  ,p_end_date_active              in  date             default hr_api.g_date
  ,p_business_group_id            in  number
  ,p_object_version_number        in out nocopy number
  ,p_attribute_category           in  varchar2         default hr_api.g_varchar2
  ,p_attribute1                   in  varchar2         default hr_api.g_varchar2
  ,p_attribute2                   in  varchar2         default hr_api.g_varchar2
  ,p_attribute3                   in  varchar2         default hr_api.g_varchar2
  ,p_attribute4                   in  varchar2         default hr_api.g_varchar2
  ,p_attribute5                   in  varchar2         default hr_api.g_varchar2
  ,p_attribute6                   in  varchar2         default hr_api.g_varchar2
  ,p_attribute7                   in  varchar2         default hr_api.g_varchar2
  ,p_attribute8                   in  varchar2         default hr_api.g_varchar2
  ,p_attribute9                   in  varchar2         default hr_api.g_varchar2
  ,p_attribute10                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute11                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute12                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute13                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute14                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute15                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute16                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute17                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute18                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute19                  in  varchar2         default hr_api.g_varchar2
  ,p_attribute20                  in  varchar2         default hr_api.g_varchar2
  ,p_validate                     in  boolean          default false
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Conference Server';

Line: 300

  savepoint UPDATE_CONFERENCE_SERVER;

Line: 310

  ota_conference_server_bk2.update_conference_server_b
  (p_effective_date                 => l_effective_date
  ,p_conference_server_id           => p_conference_server_id
  ,p_name                           => p_name
  ,p_description                    => p_description
  ,p_url                            => p_url
  ,p_type                           => p_type
  ,p_owc_site_id                    => p_owc_site_id
  ,p_owc_auth_token                 => p_owc_auth_token
  ,p_end_date_active                => p_end_date_active
  ,p_business_group_id              => p_business_group_id
  ,p_object_version_number          => l_object_version_number
  ,p_attribute_category             => p_attribute_category
  ,p_attribute1                     => p_attribute1
  ,p_attribute2                     => p_attribute2
  ,p_attribute3                     => p_attribute3
  ,p_attribute4                     => p_attribute4
  ,p_attribute5                     => p_attribute5
  ,p_attribute6                     => p_attribute6
  ,p_attribute7                     => p_attribute7
  ,p_attribute8                     => p_attribute8
  ,p_attribute9                     => p_attribute9
  ,p_attribute10                    => p_attribute10
  ,p_attribute11                    => p_attribute11
  ,p_attribute12                    => p_attribute12
  ,p_attribute13                    => p_attribute13
  ,p_attribute14                    => p_attribute14
  ,p_attribute15                    => p_attribute15
  ,p_attribute16                    => p_attribute16
  ,p_attribute17                    => p_attribute17
  ,p_attribute18                    => p_attribute18
  ,p_attribute19                    => p_attribute19
  ,p_attribute20                    => p_attribute20
  );

Line: 347

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

Line: 407

  ota_conference_server_bk2.update_conference_server_a
  (p_effective_date                 => l_effective_date
  ,p_conference_server_id           => p_conference_server_id
  ,p_name                           => p_name
  ,p_description                    => p_description
  ,p_url                            => p_url
  ,p_type                           => p_type
  ,p_owc_site_id                    => p_owc_site_id
  ,p_owc_auth_token                 => p_owc_auth_token
  ,p_end_date_active                => p_end_date_active
  ,p_business_group_id              => p_business_group_id
  ,p_object_version_number          => l_object_version_number
  ,p_attribute_category             => p_attribute_category
  ,p_attribute1                     => p_attribute1
  ,p_attribute2                     => p_attribute2
  ,p_attribute3                     => p_attribute3
  ,p_attribute4                     => p_attribute4
  ,p_attribute5                     => p_attribute5
  ,p_attribute6                     => p_attribute6
  ,p_attribute7                     => p_attribute7
  ,p_attribute8                     => p_attribute8
  ,p_attribute9                     => p_attribute9
  ,p_attribute10                    => p_attribute10
  ,p_attribute11                    => p_attribute11
  ,p_attribute12                    => p_attribute12
  ,p_attribute13                    => p_attribute13
  ,p_attribute14                    => p_attribute14
  ,p_attribute15                    => p_attribute15
  ,p_attribute16                    => p_attribute16
  ,p_attribute17                    => p_attribute17
  ,p_attribute18                    => p_attribute18
  ,p_attribute19                    => p_attribute19
  ,p_attribute20                    => p_attribute20
  );

Line: 444

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

Line: 465

    rollback to UPDATE_CONFERENCE_SERVER;

Line: 477

    rollback to UPDATE_CONFERENCE_SERVER;

Line: 481

end update_conference_server;

Line: 487

procedure delete_conference_server
  (p_validate                      in     boolean  default false
  ,p_conference_server_id          in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Conference Server';

Line: 504

  savepoint DELETE_CONFERENCE_SERVER;

Line: 513

    ota_conference_server_bk3.delete_conference_server_b
    (p_conference_server_id        => p_conference_server_id
    ,p_object_version_number       => p_object_version_number
    );

Line: 520

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

Line: 546

  ota_conference_server_bk3.delete_conference_server_a
  (p_conference_server_id        => p_conference_server_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 553

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

Line: 575

    rollback to DELETE_CONFERENCE_SERVER;

Line: 586

    rollback to DELETE_CONFERENCE_SERVER;

Line: 589

end delete_conference_server;