The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT business_group_id
FROM per_competences
WHERE competence_id = p_competence_id;
SELECT rowid
FROM per_competence_elements
WHERE competence_element_id = l_element_id;
SELECT project_id
INTO l_project_id
FROM pa_project_assignments
WHERE assignment_id = l_first_assignment_id;
-- If there are errors, do not proceed to insert the data
IF g_noof_errors > 0 THEN
x_return_status := FND_API.G_RET_STS_ERROR;
PROCEDURE Update_competence_element
(p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_object_version_number IN NUMBER,
x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
l_effective_date_from DATE;
pa_debug.set_err_stack ('pa_competence_pvt.update_competence_element');
hr_competence_element_api.update_competence_element
(
p_competence_element_id => p_element_id,
p_object_version_number => l_object_version_number,
p_proficiency_level_id => p_rating_level_id,
p_mandatory => l_mandatory_flag,
p_effective_date => l_effective_date_from );
END Update_Competence_element;
PROCEDURE delete_competence_element
(p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_object_version_number IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
l_return_status VARCHAR2(30);
pa_debug.set_err_stack ('pa_competence_pvt.delete_competence_element');
hr_competence_element_api.delete_competence_element
(p_competence_element_id => p_element_id,
p_object_version_number => p_object_version_number );
END Delete_Competence_element;
SELECT object_name,
object_id,
competence_id,
effective_date_from
FROM per_competence_elements
WHERE competence_element_id = p_element_id;
SELECT object_version_number
FROM per_competence_elements
WHERE competence_element_id = p_element_id;