APPS.PA_COMPETENCE_PVT SQL Statements

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

Line: 42

		 SELECT business_group_id
			 FROM   per_competences
			 WHERE competence_id = p_competence_id;

Line: 47

	 	 SELECT rowid
	 		 FROM per_competence_elements
	 		 WHERE competence_element_id = l_element_id;

Line: 87

						SELECT project_id
							INTO l_project_id
							FROM   pa_project_assignments
							WHERE  assignment_id = l_first_assignment_id;

Line: 128

	 -- 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;

Line: 248

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;

Line: 270

     pa_debug.set_err_stack ('pa_competence_pvt.update_competence_element');

Line: 339

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 );

Line: 357

END Update_Competence_element;

Line: 359

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);

Line: 377

     pa_debug.set_err_stack ('pa_competence_pvt.delete_competence_element');

Line: 431

     hr_competence_element_api.delete_competence_element
    (p_competence_element_id  => p_element_id,
     p_object_version_number  => p_object_version_number );

Line: 445

END Delete_Competence_element;

Line: 457

SELECT object_name,
       object_id,
       competence_id,
       effective_date_from
FROM per_competence_elements
WHERE competence_element_id = p_element_id;

Line: 511

SELECT object_version_number
FROM per_competence_elements
WHERE competence_element_id = p_element_id;