APPS.OTA_FORUM_API SQL Statements

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

Line: 172

procedure update_forum
  (p_validate                     in  boolean          default false
  ,p_effective_date               in  date
  ,p_name                         in  varchar2
  ,p_description                  in  varchar2
  ,p_business_group_id            in  number
  ,p_start_date_active            in  date             default hr_api.g_date
  ,p_end_date_active              in  date             default hr_api.g_date
  ,p_message_type_flag            in  varchar2         default hr_api.g_varchar2
  ,p_allow_html_flag              in  varchar2         default hr_api.g_varchar2
  ,p_allow_attachment_flag        in  varchar2         default hr_api.g_varchar2
  ,p_auto_notification_flag       in  varchar2         default hr_api.g_varchar2
  ,p_public_flag                  in  varchar2         default hr_api.g_varchar2
  ,p_forum_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';

Line: 199

  savepoint UPDATE_FORUM;

Line: 208

  ota_forum_bk2.update_forum_b
  (p_effective_date               => p_effective_date
     ,p_name                          => p_name
   ,p_description                   => p_description
   ,p_business_group_id             => p_business_group_id
   ,p_message_type_flag	 	    => p_message_type_flag
   ,p_allow_html_flag	  	    => p_allow_html_flag
   ,p_allow_attachment_flag         => p_allow_attachment_flag
   ,p_auto_notification_flag        => p_auto_notification_flag
   ,p_public_flag                   => p_public_flag
   ,p_start_date_active             => p_start_date_active
   ,p_end_date_active               => p_end_date_active
   ,p_forum_id                      => p_forum_id
   ,p_object_version_number         => p_object_version_number
   );

Line: 227

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

Line: 262

  ota_forum_bk2.update_forum_a
  (p_effective_date               => p_effective_date
   ,p_name                          => p_name
   ,p_description                   => p_description
   ,p_business_group_id             => p_business_group_id
   ,p_message_type_flag	 	    => p_message_type_flag
   ,p_allow_html_flag	  	    => p_allow_html_flag
   ,p_allow_attachment_flag         => p_allow_attachment_flag
   ,p_auto_notification_flag        => p_auto_notification_flag
   ,p_public_flag                   => p_public_flag
   ,p_start_date_active             => p_start_date_active
   ,p_end_date_active               => p_end_date_active
   ,p_forum_id                      => p_forum_id
   ,p_object_version_number         => p_object_version_number
   );

Line: 281

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

Line: 302

    rollback to UPDATE_FORUM;

Line: 314

    rollback to UPDATE_FORUM;

Line: 318

end update_forum;

Line: 324

procedure delete_forum
  (p_validate                      in     boolean  default false
  ,p_forum_id               in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete_forum';

Line: 341

  savepoint DELETE_FORUM;

Line: 349

  ota_forum_bk3.delete_forum_b
  (p_forum_id        => p_forum_id
  ,p_object_version_number   => p_object_version_number
    );

Line: 356

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

Line: 381

  ota_forum_bk3.delete_forum_a
  (p_forum_id        => p_forum_id
  ,p_object_version_number   => p_object_version_number
    );

Line: 388

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

Line: 409

    rollback to DELETE_FORUM;

Line: 420

    rollback to DELETE_FORUM;

Line: 423

end delete_forum;