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 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 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 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 26: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895

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
29: x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
30:

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 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 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 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 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 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 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 80: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE ) ; --File.Sql.39 bug 4440895

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