APPS.PA_COMP_PROFILE_PVT dependencies on PER_COMPETENCES

Line 48: p_competence_id IN per_competences.competence_id%TYPE,

44: p_effective_date_from IN DATE);
45:
46: PROCEDURE Add_Competence_Element
47: ( p_person_id IN per_competence_elements.person_id%TYPE,
48: p_competence_id IN per_competences.competence_id%TYPE,
49: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
50: p_effective_date_from IN DATE,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 69: FROM per_competences

65: l_role_id NUMBER := 0;
66: l_object_version_number NUMBER := 0;
67: CURSOR l_bg_csr IS
68: SELECT business_group_id
69: FROM per_competences
70: WHERE competence_id = p_competence_id;
71:
72: BEGIN
73: IF l_enable_log = 'Y' THEN

Line 174: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

170: END Add_Competence_Element ;
171:
172: PROCEDURE Update_competence_element
173: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
174: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
175: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
176: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
177: p_effective_date_from IN DATE,
178: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 332: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

328:
329: PROCEDURE Check_Element_id
330: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
331: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
332: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
333: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
334: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , -- 4537865 Added the nocopy hint
335: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 Added the nocopy hint
336: x_error_message_code OUT NOCOPY VARCHAR2) IS -- 4537865 Added the nocopy hint

Line 464: FROM per_competences

460: IF p_competence_id is not null THEN
461: BEGIN
462: SELECT name,competence_alias
463: INTO l_competence_name,l_competence_alias
464: FROM per_competences
465: WHERE competence_id = p_competence_id;
466: EXCEPTION
467: WHEN OTHERS THEN
468: l_competence_name := null;

Line 550: FROM per_competences

546: IF p_competence_id is not null THEN
547: BEGIN
548: SELECT name,competence_alias,business_group_id
549: INTO l_competence_name,l_competence_alias,l_bg_id
550: FROM per_competences
551: WHERE competence_id = p_competence_id;
552: EXCEPTION
553: WHEN OTHERS THEN
554: l_competence_name := null;

Line 1041: FROM per_competences

1037: BEGIN
1038: BEGIN
1039: SELECT business_group_id
1040: INTO l_comp_bg_id
1041: FROM per_competences
1042: WHERE competence_id = p_competence_id;
1043: EXCEPTION
1044: WHEN NO_DATA_FOUND THEN
1045: x_return_status := FND_API.G_RET_STS_ERROR;