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 268: PA_HR_COMPETENCE_UTILS.get_competencies(p_object_name => 'OPEN_ASSIGNMENT',

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

Line 1916: l_competency_tbl PA_HR_COMPETENCE_UTILS.competency_tbl_typ;

1912: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1913: l_msg_count NUMBER;
1914: l_msg_count_sum NUMBER;
1915: l_msg_data VARCHAR2(2000);
1916: l_competency_tbl PA_HR_COMPETENCE_UTILS.competency_tbl_typ;
1917: l_no_of_competencies NUMBER;
1918: l_error_message_code fnd_new_messages.message_name%TYPE;
1919: l_check_id_flag VARCHAR2(1);
1920: l_action_set_id NUMBER;

Line 2016: PA_HR_COMPETENCE_UTILS.Get_Competencies

2012: --dbms_output.put_line('Getting Competency Table');
2013: --Delete the Competencies associated with the assignment
2014: --Get the Competencies table first
2015:
2016: PA_HR_COMPETENCE_UTILS.Get_Competencies
2017: ( p_object_name => 'OPEN_ASSIGNMENT'
2018: ,p_object_id => p_assignment_id
2019: ,x_competency_tbl => l_competency_tbl
2020: ,x_no_of_competencies => l_no_of_competencies