The following lines contain the word 'select', 'insert', 'update' or 'delete':
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);
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';
SAVEPOINT UPDATE_Upgrade_Track_Error_PVT;
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);
ROLLBACK TO UPDATE_Upgrade_Track_Error_PVT;
ROLLBACK TO UPDATE_Upgrade_Track_Error_PVT;
ROLLBACK TO UPDATE_Upgrade_Track_Error_PVT;
End Update_Upgrade_Track_Error;
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';
SAVEPOINT DELETE_Upgrade_Track_Error_PVT;
AMS_UPGRADE_TRACK_ERROR_PKG.Delete_Row(
p_OBJECT_CODE => p_OBJECT_CODE,
p_OBJECT_ID => p_OBJECT_ID);
ROLLBACK TO DELETE_Upgrade_Track_Error_PVT;
ROLLBACK TO DELETE_Upgrade_Track_Error_PVT;
ROLLBACK TO DELETE_Upgrade_Track_Error_PVT;
End Delete_Upgrade_Track_Error;