APPS.PA_OPEN_ASSIGNMENT_PVT dependencies on PA_HR_COMPETENCE_UTILS

Line 36: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;

32: l_source_calendar_type pa_project_assignments.calendar_type%TYPE;
33: l_source_status_code pa_project_assignments.status_code%TYPE;
34: l_menu_id NUMBER;
35: l_return_status VARCHAR2(1);
36: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
37: l_job_id NUMBER;
38: l_error_message_code fnd_new_messages.message_name%TYPE;
39: l_schedulable_flag VARCHAR2(1);
40: l_location_row_id ROWID;

Line 265: PA_HR_COMPETENCE_UTILS.get_competencies(p_object_name => 'OPEN_ASSIGNMENT',

261: IF l_source_assignment_id IS NOT NULL
262: AND l_source_assignment_id <> FND_API.G_MISS_NUM
263: AND l_assignment_rec.source_assignment_type = 'OPEN_ASSIGNMENT' THEN
264:
265: PA_HR_COMPETENCE_UTILS.get_competencies(p_object_name => 'OPEN_ASSIGNMENT',
266: p_object_id => l_source_assignment_id,
267: x_competency_tbl => l_competencies_tbl,
268: x_no_of_competencies => l_no_of_competencies,
269: x_error_message_code => l_error_message_code,

Line 1910: l_competency_tbl PA_HR_COMPETENCE_UTILS.competency_tbl_typ;

1906: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1907: l_msg_count NUMBER;
1908: l_msg_count_sum NUMBER;
1909: l_msg_data VARCHAR2(2000);
1910: l_competency_tbl PA_HR_COMPETENCE_UTILS.competency_tbl_typ;
1911: l_no_of_competencies NUMBER;
1912: l_error_message_code fnd_new_messages.message_name%TYPE;
1913: l_check_id_flag VARCHAR2(1);
1914: l_action_set_id NUMBER;

Line 2010: PA_HR_COMPETENCE_UTILS.Get_Competencies

2006: --dbms_output.put_line('Getting Competency Table');
2007: --Delete the Competencies associated with the assignment
2008: --Get the Competencies table first
2009:
2010: PA_HR_COMPETENCE_UTILS.Get_Competencies
2011: ( p_object_name => 'OPEN_ASSIGNMENT'
2012: ,p_object_id => p_assignment_id
2013: ,x_competency_tbl => l_competency_tbl
2014: ,x_no_of_competencies => l_no_of_competencies