DBA Data[Home] [Help]

APPS.IRC_COMMUNICATIONS_SWI SQL Statements

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

Line: 123

PROCEDURE update_communication
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_communication_property_id    in     number
  ,p_object_type                  in     varchar2
  ,p_object_id                    in     number
  ,p_status                       in     varchar2
  ,p_start_date                   in     date
  ,p_end_date                     in     date
  ,p_communication_id             in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;
Line: 144

  l_proc    varchar2(72) := g_package ||'update_communication';
Line: 151

  savepoint update_communication_swi;
Line: 172

  irc_communications_api.update_communication
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_communication_property_id    => p_communication_property_id
    ,p_object_type                  => p_object_type
    ,p_object_id                    => p_object_id
    ,p_status                       => p_status
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_communication_id             => p_communication_id
    ,p_object_version_number        => l_object_version_number
    );
Line: 209

    rollback to update_communication_swi;
Line: 225

    rollback to update_communication_swi;
Line: 237

end update_communication;
Line: 513

PROCEDURE update_comm_properties
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_object_type                  in     varchar2
  ,p_object_id                    in     number
  ,p_default_comm_status          in     varchar2
  ,p_allow_attachment_flag        in     varchar2
  ,p_auto_notification_flag       in     varchar2
  ,p_allow_add_recipients         in     varchar2
  ,p_default_moderator            in     varchar2
  ,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_information_category         in     varchar2  default hr_api.g_varchar2
  ,p_information1                 in     varchar2  default hr_api.g_varchar2
  ,p_information2                 in     varchar2  default hr_api.g_varchar2
  ,p_information3                 in     varchar2  default hr_api.g_varchar2
  ,p_information4                 in     varchar2  default hr_api.g_varchar2
  ,p_information5                 in     varchar2  default hr_api.g_varchar2
  ,p_information6                 in     varchar2  default hr_api.g_varchar2
  ,p_information7                 in     varchar2  default hr_api.g_varchar2
  ,p_information8                 in     varchar2  default hr_api.g_varchar2
  ,p_information9                 in     varchar2  default hr_api.g_varchar2
  ,p_information10                in     varchar2  default hr_api.g_varchar2
  ,p_communication_property_id    in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;
Line: 557

  l_proc    varchar2(72) := g_package ||'update_comm_properties';
Line: 563

  savepoint UPDATE_COMM_PROPERTIES_SWI;
Line: 583

  irc_communications_api.update_comm_properties
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_object_type                  => p_object_type
    ,p_object_id                    => p_object_id
    ,p_default_comm_status          => p_default_comm_status
    ,p_allow_attachment_flag        => p_allow_attachment_flag
    ,p_auto_notification_flag       => p_auto_notification_flag
    ,p_allow_add_recipients         => p_allow_add_recipients
    ,p_default_moderator            => p_default_moderator
    ,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_information_category         => p_information_category
    ,p_information1                 => p_information1
    ,p_information2                 => p_information2
    ,p_information3                 => p_information3
    ,p_information4                 => p_information4
    ,p_information5                 => p_information5
    ,p_information6                 => p_information6
    ,p_information7                 => p_information7
    ,p_information8                 => p_information8
    ,p_information9                 => p_information9
    ,p_information10                => p_information10
    ,p_communication_property_id    => p_communication_property_id
    ,p_object_version_number        => l_object_version_number
    );
Line: 641

    rollback to update_comm_properties_swi;
Line: 655

    rollback to update_comm_properties_swi;
Line: 665

end update_comm_properties;
Line: 669

PROCEDURE delete_comm_properties
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_object_version_number        in     number
  ,p_communication_property_id    in     number
  ,p_effective_date               in     date      default hr_api.g_date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;
Line: 683

  l_proc    varchar2(72) := g_package ||'delete_comm_properties';
Line: 689

  savepoint delete_comm_properties_swi;
Line: 709

  irc_communications_api.delete_comm_properties
    (p_validate                     => l_validate
    ,p_object_version_number        => p_object_version_number
    ,p_communication_property_id    => p_communication_property_id
    ,p_effective_date               => p_effective_date
    );
Line: 737

    rollback to delete_comm_properties_swi;
Line: 751

    rollback to delete_comm_properties_swi;
Line: 761

end delete_comm_properties;
Line: 890

  ,p_deleted_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_communication_message_id     in     number
  ,p_object_version_number        out    nocopy number
  ,p_return_status                out    nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;
Line: 944

  ,p_deleted_flag                 => p_deleted_flag
  ,p_communication_message_id     => l_communication_message_id
  ,p_object_version_number        => p_object_version_number
  );
Line: 1002

procedure update_message
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_deleted_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_communication_message_id     in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                out    nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;
Line: 1018

  l_proc    varchar2(72) := g_package ||'update_message';
Line: 1024

  savepoint UPDATE_MESSAGE;
Line: 1042

  irc_communications_api.update_message
  (p_validate                     => l_validate
  ,p_effective_date               => p_effective_date
  ,p_deleted_flag                 => p_deleted_flag
  ,p_communication_message_id     => p_communication_message_id
  ,p_object_version_number        => l_object_version_number
  );
Line: 1072

    rollback to UPDATE_MESSAGE;
Line: 1086

    rollback to UPDATE_MESSAGE;
Line: 1096

end update_message;
Line: 1315

     update_comm_properties(
      p_validate                     =>       p_validate
     ,p_effective_date               =>       l_effective_date
     ,p_object_type                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectType')
     ,p_object_id                    =>       hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId')
     ,p_default_comm_status          =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'DefaultCommStatus')
     ,p_allow_attachment_flag        =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'AllowAttachmentFlag')
     ,p_auto_notification_flag       =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'AutoNotificationFlag')
     ,p_allow_add_recipients         =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'AllowAddRecipients')
     ,p_default_moderator            =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'DefaultModerator')
     ,p_attribute_category           =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
     ,p_attribute1                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
     ,p_attribute2                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
     ,p_attribute3                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
     ,p_attribute4                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
     ,p_attribute5                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
     ,p_attribute6                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
     ,p_attribute7                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
     ,p_attribute8                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
     ,p_attribute9                   =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
     ,p_attribute10                  =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
     ,p_information_category           =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
     ,p_information1                 =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
     ,p_information2                 =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
     ,p_information3                 =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
     ,p_information4                 =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
     ,p_information5                 =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
     ,p_information6                 =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
     ,p_information7                 =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
     ,p_information8                 =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
     ,p_information9                 =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
     ,p_information10                =>       hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
     ,p_communication_property_id    =>       l_communication_property_id
     ,p_object_version_number        =>       l_object_version_number
     ,p_return_status                =>       l_return_status
     );
Line: 1355

     delete_comm_properties(
      p_validate                     =>       p_validate
     ,p_object_version_number        =>       l_object_version_number
     ,p_communication_property_id    =>       l_communication_property_id
     ,p_effective_date               =>       l_effective_date
     ,p_return_status                =>       l_return_status
     );