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_PUB dependencies on FND_API

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

4: PROCEDURE Add_competence_element
5: (
6: p_person_id IN per_competence_elements.person_id%TYPE,
7: p_competence_id IN per_competences.competence_id%TYPE,
8: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
9: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
10: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
12: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,

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

5: (
6: p_person_id IN per_competence_elements.person_id%TYPE,
7: p_competence_id IN per_competences.competence_id%TYPE,
8: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
9: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
10: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
12: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

6: p_person_id IN per_competence_elements.person_id%TYPE,
7: p_competence_id IN per_competences.competence_id%TYPE,
8: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
9: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
10: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
12: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

7: p_competence_id IN per_competences.competence_id%TYPE,
8: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
9: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
10: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
12: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 12: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,

8: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
9: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
10: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
12: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 13: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

9: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
10: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
12: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 14: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

10: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
12: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 15: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
12: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
15: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
16: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
19:

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

18: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
19:
20: PROCEDURE Update_competence_element
21: (
22: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
23: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

19:
20: PROCEDURE Update_competence_element
21: (
22: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
23: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

20: PROCEDURE Update_competence_element
21: (
22: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
23: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

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

21: (
22: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
23: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,

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

22: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
23: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

23: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,

25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_object_version_number IN NUMBER,

Line 30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_object_version_number IN NUMBER,
34: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 31: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_object_version_number IN NUMBER,
34: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
35: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 32: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_object_version_number IN NUMBER,
34: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
35: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

41: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
42: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
43:
44: PROCEDURE delete_competence_element
45: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,

42: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
43:
44: PROCEDURE delete_competence_element
45: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

43:
44: PROCEDURE delete_competence_element
45: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_object_version_number IN NUMBER,

Line 48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: PROCEDURE delete_competence_element
45: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_object_version_number IN NUMBER,
52: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

45: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_object_version_number IN NUMBER,
52: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
53: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 50: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_object_version_number IN NUMBER,
52: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
53: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
54: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895