APPS.OTA_PVT_FRM_THREAD_USERS_API SQL Statements

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

Line: 149

   procedure update_pvt_frm_thread_user(
   p_validate                     in  boolean          default false
  ,p_effective_date               in  date
  ,p_forum_thread_id              in  number
  ,p_forum_id                     in number
  ,p_person_id                    in number
  ,p_contact_id                   in number
  ,p_business_group_id            in number
  ,p_author_person_id             in number default null
  ,p_author_contact_id            in number default null
  ,p_object_version_number        in out nocopy number
  )
is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' update_pvt_frm_thread_user ';

Line: 174

  savepoint update_pvt_frm_thread_user;

Line: 185

    OTA_PVT_FRM_THREAD_USERS_bk2.update_pvt_frm_thread_user_b
    (  p_effective_date             => p_effective_date
    ,p_forum_thread_id            => p_forum_thread_id
    ,p_forum_id                   => p_forum_id
    ,p_person_id                  => p_person_id
    ,p_contact_id                 => p_contact_id
    ,p_business_group_id          => p_business_group_id
    ,p_author_person_id           => p_author_person_id
    ,p_author_contact_id          => p_author_contact_id
    ,p_object_version_number      => p_object_version_number
      );

Line: 199

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

Line: 225

  OTA_PVT_FRM_THREAD_USERS_bk2.update_pvt_frm_thread_user_a
   ( p_effective_date             => p_effective_date
    ,p_forum_thread_id            => p_forum_thread_id
    ,p_forum_id                   => p_forum_id
    ,p_person_id                  => p_person_id
    ,p_contact_id                 => p_contact_id
    ,p_business_group_id          => p_business_group_id
    ,p_author_person_id           => p_author_person_id
    ,p_author_contact_id          => p_author_contact_id
    ,p_object_version_number      => p_object_version_number
    );

Line: 240

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

Line: 264

    rollback to update_pvt_frm_thread_user;

Line: 276

    rollback to update_pvt_frm_thread_user;

Line: 280

end update_pvt_frm_thread_user ;

Line: 286

procedure delete_pvt_frm_thread_user
(  p_validate                      in     boolean  default false
  ,p_forum_thread_id               in     number
  ,p_forum_id                      in     number
  ,p_person_id                     in     number
  ,p_contact_id                    in     number
  ,p_object_version_number         in     number

  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' delete_pvt_frm_thread_user ';

Line: 305

  savepoint delete_pvt_frm_thread_user ;

Line: 309

      OTA_PVT_FRM_THREAD_USERS_bk3.delete_pvt_frm_thread_user_b
      (  p_forum_thread_id =>p_forum_thread_id
     ,p_forum_id =>p_forum_id
     ,p_person_id =>p_person_id
     ,p_contact_id =>p_contact_id
     ,p_object_version_number =>p_object_version_number
        );

Line: 319

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

Line: 341

    OTA_PVT_FRM_THREAD_USERS_bk3.delete_pvt_frm_thread_user_a
     ( p_forum_thread_id =>p_forum_thread_id
     ,p_forum_id =>p_forum_id
     ,p_person_id =>p_person_id
     ,p_contact_id =>p_contact_id
     ,p_object_version_number =>p_object_version_number
      );

Line: 352

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

Line: 375

    rollback to delete_pvt_frm_thread_user ;

Line: 386

    rollback to delete_pvt_frm_thread_user ;

Line: 389

end delete_pvt_frm_thread_user;