APPS.AMS_UPGRADE_TRACK_ERROR_PVT SQL Statements

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

Line: 54

      AMS_UPGRADE_TRACK_ERROR_PKG.Insert_Row(
          p_object_code  => p_upgrade_track_error_rec.object_code,
          p_object_id  => p_upgrade_track_error_rec.object_id,
          p_creation_date  => SYSDATE,
          p_error_code  => p_upgrade_track_error_rec.error_code,
          p_object_name  => p_upgrade_track_error_rec.object_name,
          p_language  => p_upgrade_track_error_rec.language,
          p_error_message  => p_upgrade_track_error_rec.error_message,
          p_proposed_action  => p_upgrade_track_error_rec.proposed_action);

Line: 120

PROCEDURE Update_Upgrade_Track_Error(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    p_upgrade_track_error_rec    IN    upgrade_track_error_rec_type,
    x_return_status              OUT  NOCOPY VARCHAR2,
    x_msg_count                  OUT  NOCOPY NUMBER,
    x_msg_data                   OUT  NOCOPY VARCHAR2

    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Upgrade_Track_Error';

Line: 141

      SAVEPOINT UPDATE_Upgrade_Track_Error_PVT;

Line: 156

      AMS_UPGRADE_TRACK_ERROR_PKG.Update_Row(
          p_object_code  => p_upgrade_track_error_rec.object_code,
          p_object_id  => p_upgrade_track_error_rec.object_id,
          p_creation_date  => SYSDATE,
          p_error_code  => p_upgrade_track_error_rec.error_code,
          p_object_name  => p_upgrade_track_error_rec.object_name,
          p_language  => p_upgrade_track_error_rec.language,
          p_error_message  => p_upgrade_track_error_rec.error_message,
          p_proposed_action  => p_upgrade_track_error_rec.proposed_action);

Line: 184

     ROLLBACK TO UPDATE_Upgrade_Track_Error_PVT;

Line: 194

     ROLLBACK TO UPDATE_Upgrade_Track_Error_PVT;

Line: 204

     ROLLBACK TO UPDATE_Upgrade_Track_Error_PVT;

Line: 216

End Update_Upgrade_Track_Error;

Line: 219

PROCEDURE Delete_Upgrade_Track_Error(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    x_return_status              OUT  NOCOPY VARCHAR2,
    x_msg_count                  OUT  NOCOPY NUMBER,
    x_msg_data                   OUT  NOCOPY VARCHAR2,
    p_object_code                IN   Number,
    p_object_id                   IN  NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Upgrade_Track_Error';

Line: 238

      SAVEPOINT DELETE_Upgrade_Track_Error_PVT;

Line: 254

      AMS_UPGRADE_TRACK_ERROR_PKG.Delete_Row(
          p_OBJECT_CODE => p_OBJECT_CODE,
	  p_OBJECT_ID  => p_OBJECT_ID);

Line: 276

     ROLLBACK TO DELETE_Upgrade_Track_Error_PVT;

Line: 286

     ROLLBACK TO DELETE_Upgrade_Track_Error_PVT;

Line: 296

     ROLLBACK TO DELETE_Upgrade_Track_Error_PVT;

Line: 308

End Delete_Upgrade_Track_Error;