The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT LIFT_ID
FROM AMS_DM_LIFT
WHERE LIFT_ID = p_LIFT_ID
AND object_version_number = p_object_version
FOR UPDATE NOWAIT;
SELECT AMS_DM_LIFT_s.NEXTVAL
FROM dual;
SELECT 1 FROM dual
WHERE EXISTS (SELECT 1 FROM AMS_DM_LIFT
WHERE LIFT_ID = l_id);
AMS_DM_LIFT_PKG.Insert_Row(
px_lift_id => l_lift_id,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
px_object_version_number => l_object_version_number,
p_model_id => p_Lift_rec.model_id,
p_quantile => p_Lift_rec.quantile,
p_lift => p_Lift_rec.lift,
p_targets => p_Lift_rec.targets,
p_non_targets => p_Lift_rec.non_targets,
p_targets_cumm => p_Lift_rec.targets_cumm,
p_target_density_cumm => p_Lift_rec.target_density_cumm,
p_target_density => p_Lift_rec.target_density,
p_margin => p_Lift_rec.margin,
p_roi => p_Lift_rec.roi,
p_target_confidence => p_Lift_rec.target_confidence,
p_non_target_confidence => p_Lift_rec.non_target_confidence
);
PROCEDURE Update_Lift(
p_api_version 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_lift_rec IN lift_rec_type,
x_object_version_number OUT NOCOPY NUMBER
)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Lift';
SELECT *
FROM AMS_DM_LIFT
WHERE lift_id = p_lift_id;
SAVEPOINT Update_Lift_PVT;
AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
p_validation_mode => JTF_PLSQL_API.G_UPDATE,
p_lift_rec => p_lift_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
AMS_DM_LIFT_PKG.Update_Row(
p_lift_id => p_Lift_rec.lift_id,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
p_object_version_number => p_Lift_rec.object_version_number + 1,
p_model_id => p_Lift_rec.model_id,
p_quantile => p_Lift_rec.quantile,
p_lift => p_Lift_rec.lift,
p_targets => p_Lift_rec.targets,
p_non_targets => p_Lift_rec.non_targets,
p_targets_cumm => p_Lift_rec.targets_cumm,
p_target_density_cumm => p_Lift_rec.target_density_cumm,
p_target_density => p_Lift_rec.target_density,
p_margin => p_Lift_rec.margin,
p_roi => p_Lift_rec.roi,
p_target_confidence => p_Lift_rec.target_confidence,
p_non_target_confidence => p_Lift_rec.non_target_confidence
);
AMS_Utility_PVT.error_message ('AMS_API_NO_UPDATE');
ROLLBACK TO Update_Lift_PVT;
ROLLBACK TO Update_Lift_PVT;
ROLLBACK TO Update_Lift_PVT;
End Update_Lift;
PROCEDURE Delete_Lift(
p_api_version 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_lift_id IN NUMBER,
p_object_version_number IN NUMBER
)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Lift';
SAVEPOINT Delete_Lift_PVT;
AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
AMS_DM_LIFT_PKG.Delete_Row(
p_LIFT_ID => p_LIFT_ID);
AMS_Utility_PVT.error_message ('AMS_API_NO_DELETE');
ROLLBACK TO Delete_Lift_PVT;
ROLLBACK TO Delete_Lift_PVT;
ROLLBACK TO Delete_Lift_PVT;
End Delete_Lift;