APPS.OTA_CHAT_MESSAGE_API SQL Statements

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

Line: 155

procedure update_chat_message (
   p_validate                     in  boolean          default false
  ,p_effective_date               in  date
  ,p_chat_id                      in  number
  ,p_person_id                    in  number
  ,p_contact_id                   in  number
  ,p_target_person_id             in  number
  ,p_target_contact_id            in  number
  ,p_message_text                 in  varchar2
  ,p_business_group_id            in  number
  ,p_chat_message_id              in  number
  ,p_object_version_number        in out nocopy number) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' update_chat_message';

Line: 180

  savepoint UPDATE_CHAT_MESSAGE;

Line: 189

  ota_chat_message_bk2.update_chat_message_b
  ( p_effective_date            => l_effective_date
  ,p_chat_id                   => p_chat_id
  ,p_business_group_id         => p_business_group_id
  ,p_message_text              => p_message_text
  ,p_person_id                 => p_person_id
  ,p_contact_id                => p_contact_id
  ,p_target_person_id          => p_target_person_id
  ,p_target_contact_id         => p_target_contact_id
  ,p_chat_message_id           => p_chat_message_id
  ,p_object_version_number     => l_object_version_number
  );

Line: 204

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

Line: 235

  ota_chat_message_bk2.update_chat_message_a
  ( p_effective_date           => l_effective_date
  ,p_chat_id                   => p_chat_id
  ,p_business_group_id         => p_business_group_id
  ,p_message_text              => p_message_text
  ,p_person_id                 => p_person_id
  ,p_contact_id                => p_contact_id
  ,p_target_person_id          => p_target_person_id
  ,p_target_contact_id         => p_target_contact_id
  ,p_chat_message_id           => p_chat_message_id
  ,p_object_version_number     => l_object_version_number
  );

Line: 250

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

Line: 271

    rollback to UPDATE_CHAT_MESSAGE;

Line: 283

    rollback to UPDATE_CHAT_MESSAGE;

Line: 287

end update_chat_message;

Line: 293

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

Line: 310

  savepoint DELETE_CHAT_MESSAGE;

Line: 318

  ota_chat_message_bk3.delete_chat_message_b
  (p_chat_message_id        => p_chat_message_id
  ,p_object_version_number   => p_object_version_number
    );

Line: 325

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

Line: 345

  ota_chat_message_bk3.delete_chat_message_a
  (p_chat_message_id        => p_chat_message_id
  ,p_object_version_number   => p_object_version_number
    );

Line: 352

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

Line: 373

    rollback to DELETE_CHAT_MESSAGE;

Line: 384

    rollback to DELETE_CHAT_MESSAGE;

Line: 387

end delete_chat_message;