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_COMPETENCE_PUB dependencies on PER_COMPETENCES

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

13:
14: PROCEDURE Add_competence_element
15: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

14: PROCEDURE Add_competence_element
15: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

Line 19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

15: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

181:
182: PROCEDURE Update_competence_element
183: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

Line 186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

182: PROCEDURE Update_competence_element
183: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

Line 187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

183: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

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

338:
339: PROCEDURE delete_competence_element
340: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
341: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

Line 343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

339: PROCEDURE delete_competence_element
340: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
341: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 344: p_competence_name IN per_competences.name%TYPE := chr(0),

340: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
341: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

471: (
472: p_element_id IN NUMBER := null,
473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

472: p_element_id IN NUMBER := null,
473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
480: p_operation IN VARCHAR2,

Line 477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
480: p_operation IN VARCHAR2,
481: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 482: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895

478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
480: p_operation IN VARCHAR2,
481: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
482: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895
483: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE ) IS --File.Sql.39 bug 4440895
484:
485: l_return_status VARCHAR2(30);
486: l_error_message_code VARCHAR2(30);

Line 544: FROM per_competences

540: l_in_competence_alias is not null THEN
541: BEGIN
542: SELECT 'Y'
543: INTO l_exists
544: FROM per_competences
545: WHERE name = l_in_competence_name
546: AND competence_alias = l_in_competence_alias;
547: EXCEPTION
548: WHEN NO_DATA_FOUND THEN

Line 567: per_competences comp

563: INTO l_old_competence_id,
564: l_old_comp_name,
565: l_old_comp_alias
566: FROM per_competence_elements comp_ele,
567: per_competences comp
568: WHERE COMPETENCE_ELEMENT_ID = p_element_id
569: AND comp.competence_id = comp_ele.competence_id;
570:
571: IF (nvl(l_in_competence_name,l_old_comp_name) <> l_old_comp_name) OR