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

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

12: --
13: g_noof_errors NUMBER := 0;
14:
15: PROCEDURE Add_competence_element
16: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
17: --p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
18: p_object_id IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
19: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
20: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

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

13: g_noof_errors NUMBER := 0;
14:
15: PROCEDURE Add_competence_element
16: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
17: --p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
18: p_object_id IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
19: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
20: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

Line 19: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,

15: PROCEDURE Add_competence_element
16: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
17: --p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
18: p_object_id IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
19: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
20: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

16: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
17: --p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
18: p_object_id IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
19: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
20: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := 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_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

17: --p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
18: p_object_id IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
19: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
20: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := 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: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

18: p_object_id IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
19: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
20: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := 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: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895

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

19: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
20: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := 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: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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

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

20: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := 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: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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

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

21: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := 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: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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:

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

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:
30: PROCEDURE Update_competence_element
31: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
32: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
33: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
34: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
35: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

28: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
29:
30: PROCEDURE Update_competence_element
31: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
32: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
33: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
34: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
35: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
36: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

29:
30: PROCEDURE Update_competence_element
31: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
32: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
33: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
34: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
35: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
36: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
37: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

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

30: PROCEDURE Update_competence_element
31: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
32: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
33: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
34: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
35: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
36: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
37: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
38: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

31: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
32: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
33: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
34: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
35: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
36: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
37: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
38: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

32: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
33: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
34: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
35: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
36: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
37: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
38: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

33: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
34: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
35: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
36: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
37: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
38: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_object_version_number IN NUMBER,

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

34: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
35: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
36: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
37: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
38: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_object_version_number IN NUMBER,
42: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

35: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
36: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
37: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
38: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_object_version_number IN NUMBER,
42: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
43: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

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

36: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
37: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
38: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_object_version_number IN NUMBER,
42: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
43: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
44:

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

42: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
43: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
44:
45: PROCEDURE delete_competence_element
46: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
47: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
48: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
49: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
50: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

43: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
44:
45: PROCEDURE delete_competence_element
46: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
47: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
48: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
49: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
50: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

44:
45: PROCEDURE delete_competence_element
46: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
47: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
48: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
49: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
50: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

45: PROCEDURE delete_competence_element
46: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
47: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
48: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
49: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
50: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

46: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
47: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
48: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
49: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
50: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_object_version_number IN NUMBER,

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

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

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

48: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
49: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
50: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_object_version_number IN NUMBER,
55: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
56:

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

49: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
50: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_object_version_number IN NUMBER,
55: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
56:
57: PROCEDURE Check_Element_id

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

54: p_object_version_number IN NUMBER,
55: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
56:
57: PROCEDURE Check_Element_id
58: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
59: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
60: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
61: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
62: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895

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

55: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
56:
57: PROCEDURE Check_Element_id
58: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
59: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
60: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
61: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
62: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895
63: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

56:
57: PROCEDURE Check_Element_id
58: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
59: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
60: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
61: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
62: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895
63: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
64: x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895

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

57: PROCEDURE Check_Element_id
58: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
59: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
60: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
61: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
62: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895
63: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
64: x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
65: