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 PER_COMPETENCE_ELEMENTS

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

10: -- HISTORY
11: -- 24-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 PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
16: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

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

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

15: p_object_id IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
16: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
19: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
20: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895

Line 24: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895

20: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
24: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895
25: x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
26:
27: l_data VARCHAR2(500);
28: l_msg_data VARCHAR2(500);

Line 48: FROM per_competence_elements

44: WHERE competence_id = p_competence_id;
45:
46: CURSOR l_rowid_csr IS
47: SELECT rowid
48: FROM per_competence_elements
49: WHERE competence_element_id = l_element_id;
50:
51: BEGIN
52: pa_debug.set_err_stack ('pa_competence_pvt.add_competence_element');

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

245: END Add_Competence_Element ;
246:
247:
248: PROCEDURE Update_competence_element
249: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
250: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
251: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
252: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
253: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

246:
247:
248: PROCEDURE Update_competence_element
249: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
250: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
251: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
252: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
253: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
254: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

249: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
250: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
251: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
252: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
253: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
254: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
255: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
256: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

250: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
251: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
252: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
253: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
254: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
255: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
256: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

251: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
252: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
253: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
254: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
255: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
256: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_object_version_number IN NUMBER,

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

356: RAISE;
357: END Update_Competence_element;
358:
359: PROCEDURE delete_competence_element
360: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
361: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
362: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
363: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
364: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

357: END Update_Competence_element;
358:
359: PROCEDURE delete_competence_element
360: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
361: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
362: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
363: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
364: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
365: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

360: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
361: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
362: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
363: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
364: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
365: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: p_object_version_number IN NUMBER,

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

444: RAISE;
445: END Delete_Competence_element;
446:
447: PROCEDURE Check_Element_id
448: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
449: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
450: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
451: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
452: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895

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

445: END Delete_Competence_element;
446:
447: PROCEDURE Check_Element_id
448: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
449: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
450: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
451: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
452: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895
453: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

447: PROCEDURE Check_Element_id
448: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
449: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
450: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
451: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
452: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895
453: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
454: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
455:

Line 452: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895

448: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
449: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
450: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
451: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
452: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895
453: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
454: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
455:
456: CURSOR l_check_element_csr IS

Line 461: FROM per_competence_elements

457: SELECT object_name,
458: object_id,
459: competence_id,
460: effective_date_from
461: FROM per_competence_elements
462: WHERE competence_element_id = p_element_id;
463: l_check_element_rec l_check_element_csr%ROWTYPE;
464: BEGIN
465: pa_debug.set_err_stack ('pa_competence_pvt.check_element_id');

Line 505: (p_element_id IN per_competence_elements.competence_element_id%TYPE,

501: RAISE;
502: END check_error;
503:
504: PROCEDURE Check_Object_version_number
505: (p_element_id IN per_competence_elements.competence_element_id%TYPE,
506: p_object_version_number IN NUMBER,
507: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
508: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
509:

Line 512: FROM per_competence_elements

508: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
509:
510: CURSOR l_get_obj_vers_csr IS
511: SELECT object_version_number
512: FROM per_competence_elements
513: WHERE competence_element_id = p_element_id;
514: l_obj_version_number NUMBER := 0;
515:
516: BEGIN