DBA Data[Home] [Help]

APPS.PA_COMP_PROFILE_PUB dependencies on PER_RATING_LEVELS

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

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

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

29: p_competence_id IN per_competences.competence_id%TYPE,
30: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
31: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
32: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
33: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
34: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

201: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
202: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
203: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
204: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
205: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
206: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
207: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

446: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
447: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
448: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
449: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
450: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
451: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
452: p_operation IN VARCHAR2,
453: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
454: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895