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.

[Home] [Help]

APPS.PA_COMPETENCE_PUB dependencies on FND_API

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

10: -- HISTORY
11: -- 11-JUL-2000 R. Krishnamurthy Created
12: --
13: PROCEDURE Add_competence_element
14: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
15: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
16: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
18: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

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

11: -- 11-JUL-2000 R. Krishnamurthy Created
12: --
13: PROCEDURE Add_competence_element
14: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
15: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
16: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
18: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

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

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

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

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

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

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

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

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

16: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
18: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
21: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

17: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
18: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
21: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895

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

18: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
21: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
26: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895

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

19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
21: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
26: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895
27: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

20: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
21: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
26: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895
27: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

28: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29: x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
30:
31: PROCEDURE Update_competence_element
32: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
33: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

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

29: x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
30:
31: PROCEDURE Update_competence_element
32: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
33: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,

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

30:
31: PROCEDURE Update_competence_element
32: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
33: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

31: PROCEDURE Update_competence_element
32: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
33: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

32: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
33: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,

33: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
41: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

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

34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
41: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
41: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
41: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
41: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_object_version_number IN NUMBER,

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

38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
41: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_object_version_number IN NUMBER,
46: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
41: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_object_version_number IN NUMBER,
46: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
47: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
41: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_object_version_number IN NUMBER,
46: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
47: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

48: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
49: x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
50:
51: PROCEDURE delete_competence_element
52: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
53: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
54: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),

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

49: x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
50:
51: PROCEDURE delete_competence_element
52: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
53: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
54: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,

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

50:
51: PROCEDURE delete_competence_element
52: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
53: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
54: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

51: PROCEDURE delete_competence_element
52: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
53: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
54: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,

53: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
54: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

54: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_object_version_number IN NUMBER,

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

55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_object_version_number IN NUMBER,
63: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_object_version_number IN NUMBER,
63: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
64: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_object_version_number IN NUMBER,
63: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
64: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
65: x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895

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

66:
67: PROCEDURE standard_pub_checks
68: (
69: p_element_id IN NUMBER := null,
70: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
71: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

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

67: PROCEDURE standard_pub_checks
68: (
69: p_element_id IN NUMBER := null,
70: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
71: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

68: (
69: p_element_id IN NUMBER := null,
70: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
71: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

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

69: p_element_id IN NUMBER := null,
70: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
71: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
77: p_operation IN VARCHAR2,

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

70: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
71: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
77: p_operation IN VARCHAR2,
78: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

71: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
77: p_operation IN VARCHAR2,
78: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895

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

72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
77: p_operation IN VARCHAR2,
78: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895
80: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE ) ; --File.Sql.39 bug 4440895

Line 83: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR

79: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895
80: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE ) ; --File.Sql.39 bug 4440895
81:
82: PROCEDURE Mass_Exec_Process_Competences
83: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
84: ,p_project_id IN pa_project_assignments.project_id%TYPE
85: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
86: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
87: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type

Line 92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

88: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
89: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
90: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
91: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
95: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
96: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

89: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
90: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
91: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
95: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
96: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 94: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

90: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
91: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
95: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
96: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
98: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 95: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

91: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
95: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
96: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
98: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
99: );

Line 109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

105: p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type,
106: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
107: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
108: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */
113: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 110: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

106: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
107: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
108: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */
113: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
114: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 111: p_commit IN VARCHAR2 := FND_API.G_FALSE,

107: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
108: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */
113: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
114: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
115: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895