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_COMPETENCE_ELEMENTS

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

11: -- 11-JUL-2000 R. Krishnamurthy Created
12: --
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,

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

12: --
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,

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

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

Line 22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

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,
24: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895

Line 27: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895

23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
27: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895
28: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
30: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
31:

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

179: END Add_Competence_Element;
180:
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,

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

180:
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,

Line 189: p_element_id IN per_competence_elements.competence_element_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,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 190: p_rating_level_id IN per_competence_elements.rating_level_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,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 192: p_mandatory_flag IN per_competence_elements.mandatory%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,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_object_version_number IN NUMBER,

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

336:
337: END update_competence_element ;
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),

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

337: END update_competence_element ;
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,

Line 346: p_element_id IN per_competence_elements.competence_element_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,
349: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_object_version_number IN NUMBER,

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

469:
470: PROCEDURE standard_pub_checks
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,

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

470: PROCEDURE standard_pub_checks
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,

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

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
482: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895

Line 483: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE ) IS --File.Sql.39 bug 4440895

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);
487: l_in_competence_id NUMBER := 0;

Line 566: FROM per_competence_elements comp_ele,

562: comp.competence_alias
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:

Line 892: FROM per_competence_elements

888: SELECT object_version_number,
889: competence_element_id
890: INTO l_object_version_number,
891: l_competence_element_id
892: FROM per_competence_elements
893: WHERE object_id = p_assignment_tbl(I)
894: AND object_name = 'OPEN_ASSIGNMENT'
895: AND competence_id = p_competence_id_tbl(J);
896: l_mode := 'UPDATE';