eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_COMP_PROFILE_PVT dependencies on PER_COMPETENCE_ELEMENTS

Line 47: ( p_person_id IN per_competence_elements.person_id%TYPE,

43: p_rating_level_id IN NUMBER,
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,

Line 49: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 173: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,

169: RAISE;
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,

Line 175: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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,
179: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 176: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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,
179: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 330: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,

326:
327: END delete_competence_element;
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

Line 331: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,

327: END delete_competence_element;
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

Line 333: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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
337:

Line 334: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , -- 4537865 Added the nocopy hint

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
337:
338: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 345: FROM per_competence_elements

341: SELECT object_name,
342: object_id,
343: competence_id,
344: effective_date_from
345: FROM per_competence_elements
346: WHERE competence_element_id = p_element_id;
347: l_check_element_rec l_check_element_csr%ROWTYPE;
348: BEGIN
349: IF l_enable_log = 'Y' THEN

Line 404: (p_element_id IN per_competence_elements.competence_element_id%TYPE,

400: RAISE;
401: END check_error;
402:
403: PROCEDURE Check_Object_version_number
404: (p_element_id IN per_competence_elements.competence_element_id%TYPE,
405: p_object_version_number IN NUMBER,
406: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 Added the nocopy hint
407: x_error_message_code OUT NOCOPY VARCHAR2) IS -- 4537865 Added the nocopy hint
408:

Line 413: FROM per_competence_elements

409: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
410:
411: CURSOR l_get_obj_vers_csr IS
412: SELECT object_version_number
413: FROM per_competence_elements
414: WHERE competence_element_id = p_element_id;
415: l_obj_version_number NUMBER := 0;
416:
417: BEGIN

Line 564: FROM per_competence_elements

560: IF p_competence_element_id is not null THEN
561: BEGIN
562: SELECT proficiency_level_id,effective_date_from
563: INTO l_old_rating_level_id,l_old_effective_date_from
564: FROM per_competence_elements
565: WHERE competence_element_id = p_competence_element_id;
566: EXCEPTION
567: WHEN OTHERS THEN
568: l_old_rating_level_id := null;

Line 1143: FROM per_competence_elements

1139: IS
1140: l_dummy VARCHAR2(1);
1141: BEGIN
1142: SELECT 'x' INTO l_dummy
1143: FROM per_competence_elements
1144: WHERE person_id = p_person_id
1145: AND competence_id = p_competence_id ;
1146:
1147: RETURN 'Y';