APPS.PER_BOOKINGS_SWI SQL Statements

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

Line: 68

  per_bookings_pkg.Insert_Row(X_Rowid                        => p_Rowid
                             ,X_Booking_Id                   => p_Booking_Id
                             ,X_Business_Group_Id            => p_Business_Group_Id
                             ,X_Person_Id                    => p_Person_Id
                             ,X_Event_Id                     => p_Event_Id
                             ,X_Message                      => p_Message
                             ,X_Token                        => p_Token
                             ,X_Comments                     => p_Comments
                             ,X_Attribute_Category           => p_Attribute_Category
                             ,X_Attribute1                   => p_Attribute1
                             ,X_Attribute2                   => p_Attribute2
                             ,X_Attribute3                   => p_Attribute3
                             ,X_Attribute4                   => p_Attribute4
                             ,X_Attribute5                   => p_Attribute5
                             ,X_Attribute6                   => p_Attribute6
                             ,X_Attribute7                   => p_Attribute7
                             ,X_Attribute8                   => p_Attribute8
                             ,X_Attribute9                   => p_Attribute9
                             ,X_Attribute10                  => p_Attribute10
                             ,X_Attribute11                  => p_Attribute11
                             ,X_Attribute12                  => p_Attribute12
                             ,X_Attribute13                  => p_Attribute13
                             ,X_Attribute14                  => p_Attribute14
                             ,X_Attribute15                  => p_Attribute15
                             ,X_Attribute16                  => p_Attribute16
                             ,X_Attribute17                  => p_Attribute17
                             ,X_Attribute18                  => p_Attribute18
                             ,X_Attribute19                  => p_Attribute19
                             ,X_Attribute20                  => p_Attribute20
                             ,X_Primary_Interviewer_Flag     => p_Primary_Interviewer_Flag
                             );

Line: 139

PROCEDURE update_per_bookings
  (p_Rowid                        IN OUT NOCOPY VARCHAR2
  ,p_Booking_Id                   IN OUT NOCOPY NUMBER
  ,p_Business_Group_Id                   NUMBER
  ,p_Person_Id                           NUMBER
  ,p_Event_Id                            NUMBER
  ,p_Message                             VARCHAR2   default hr_api.g_varchar2
  ,p_Token                               VARCHAR2   default hr_api.g_varchar2
  ,p_Comments                            VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute_Category                  VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute1                          VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute2                          VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute3                          VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute4                          VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute5                          VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute6                          VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute7                          VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute8                          VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute9                          VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute10                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute11                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute12                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute13                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute14                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute15                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute16                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute17                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute18                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute19                         VARCHAR2   default hr_api.g_varchar2
  ,p_Attribute20                         VARCHAR2   default hr_api.g_varchar2
  ,p_Primary_Interviewer_Flag            VARCHAR2   default null
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 180

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

Line: 183

         select rowid
           from per_bookings
          where booking_id = p_Booking_Id;

Line: 191

  savepoint update_per_bookings_swi;

Line: 210

  per_bookings_pkg.Update_Row(X_Rowid                        => p_Rowid
                             ,X_Booking_Id                   => p_Booking_Id
                             ,X_Business_Group_Id            => p_Business_Group_Id
                             ,X_Person_Id                    => p_Person_Id
                             ,X_Event_Id                     => p_Event_Id
                             ,X_Message                      => p_Message
                             ,X_Token                        => p_Token
                             ,X_Comments                     => p_Comments
                             ,X_Attribute_Category           => p_Attribute_Category
                             ,X_Attribute1                   => p_Attribute1
                             ,X_Attribute2                   => p_Attribute2
                             ,X_Attribute3                   => p_Attribute3
                             ,X_Attribute4                   => p_Attribute4
                             ,X_Attribute5                   => p_Attribute5
                             ,X_Attribute6                   => p_Attribute6
                             ,X_Attribute7                   => p_Attribute7
                             ,X_Attribute8                   => p_Attribute8
                             ,X_Attribute9                   => p_Attribute9
                             ,X_Attribute10                  => p_Attribute10
                             ,X_Attribute11                  => p_Attribute11
                             ,X_Attribute12                  => p_Attribute12
                             ,X_Attribute13                  => p_Attribute13
                             ,X_Attribute14                  => p_Attribute14
                             ,X_Attribute15                  => p_Attribute15
                             ,X_Attribute16                  => p_Attribute16
                             ,X_Attribute17                  => p_Attribute17
                             ,X_Attribute18                  => p_Attribute18
                             ,X_Attribute19                  => p_Attribute19
                             ,X_Attribute20                  => p_Attribute20
                             ,X_Primary_Interviewer_Flag     => p_Primary_Interviewer_Flag
                             );

Line: 251

    rollback to update_per_bookings_swi;

Line: 265

    rollback to update_per_bookings_swi;

Line: 275

end update_per_bookings;

Line: 277

PROCEDURE delete_per_bookings
  (p_Booking_Id                   IN NUMBER
  ,p_return_status                    out nocopy varchar2
  ) is
  l_Rowid VARCHAR2(30);

Line: 282

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

Line: 284

           select rowid
             from per_bookings
	    where booking_id = p_Booking_Id;

Line: 292

  savepoint delete_per_bookings_swi;

Line: 311

  per_bookings_pkg.Delete_Row(X_Rowid                        => l_Rowid);

Line: 323

    rollback to delete_per_bookings_swi;

Line: 337

    rollback to delete_per_bookings_swi;

Line: 347

end delete_per_bookings;