APPS.OTA_FORUM_THREAD_API SQL Statements

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

Line: 149

procedure update_forum_thread(
   p_validate                     in  boolean          default false
  ,p_effective_date               in  date
  ,p_forum_id                       in     number
  ,p_business_group_id              in     number
  ,p_subject                        in     varchar2
  ,p_private_thread_flag            in     varchar2
  ,p_last_post_date                 in     date     default null
  ,p_reply_count                    in     number   default null
  ,p_forum_thread_id                in number
  ,p_object_version_number          in out nocopy number) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update_forum_thread';

Line: 172

  savepoint UPDATE_FORUM_THREAD;

Line: 181

  ota_forum_thread_bk2.update_forum_thread_b
  (p_effective_date               => l_effective_date
    ,p_forum_id                     => p_forum_id
    ,p_business_group_id            => p_business_group_id
    ,p_subject                      => p_subject
    ,p_private_thread_flag          => p_private_thread_flag
    ,p_last_post_date               => p_last_post_date
    ,p_reply_count                  => p_reply_count
    ,p_forum_thread_id              => p_forum_thread_id
    ,p_object_version_number        => l_object_version_number
    );

Line: 195

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

Line: 223

  ota_forum_thread_bk2.update_forum_thread_a
  (p_effective_date               => p_effective_date
    ,p_forum_id                     => p_forum_id
    ,p_business_group_id            => p_business_group_id
    ,p_subject                      => p_subject
    ,p_private_thread_flag          => p_private_thread_flag
    ,p_last_post_date               => p_last_post_date
    ,p_reply_count                  => p_reply_count
    ,p_forum_thread_id              => p_forum_thread_id
    ,p_object_version_number        => l_object_version_number
    );

Line: 237

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

Line: 260

    rollback to UPDATE_FORUM_THREAD;

Line: 272

    rollback to UPDATE_FORUM_THREAD;

Line: 276

end update_forum_thread;

Line: 281

procedure delete_forum_thread
  (p_validate                      in     boolean  default false
  ,p_forum_thread_id               in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  CURSOR csr_child_message is
        SELECT
          forum_message_id,
          object_version_number
        FROM  ota_forum_messages
        where forum_thread_id = p_forum_thread_id;

Line: 297

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

Line: 308

  savepoint DELETE_FORUM_THREAD;

Line: 316

  ota_forum_thread_bk3.delete_forum_thread_b
  (p_forum_thread_id        => p_forum_thread_id
  ,p_object_version_number   => p_object_version_number
    );

Line: 323

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

Line: 361

  ota_forum_thread_bk3.delete_forum_thread_a
  (p_forum_thread_id        => p_forum_thread_id
  ,p_object_version_number   => p_object_version_number
    );

Line: 368

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

Line: 389

    rollback to DELETE_FORUM_THREAD;

Line: 400

    rollback to DELETE_FORUM_THREAD;

Line: 403

end delete_forum_thread;