DBA Data[Home] [Help]

APPS.PA_COMPETENCE_PVT dependencies on PER_COMPETENCES

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