[Home] [Help]
129: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
130: l_return_status VARCHAR2(1);
131: /*Added for the bug 3464074*/
132: l_person_name PER_PEOPLE_F.full_name%TYPE;
133: l_error_message_code fnd_new_messages.message_name%TYPE;
134:
135: BEGIN
136:
137: -- Initialize the Error Stack
562: l_msg_index_out NUMBER;
563: l_menu_id NUMBER;
564: l_assignment_status_name PA_PROJECT_STATUSES.project_status_name%TYPE;
565: l_job_id NUMBER;
566: l_error_message_code fnd_new_messages.message_name%TYPE;
567: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
568: l_location_country_code pa_locations.country_code%TYPE;
569: l_resource_id pa_resources.resource_id%TYPE;
570: l_msg_count NUMBER;
904: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
905: l_location_country_code fnd_territories.territory_code%TYPE;
906: l_calendar_id jtf_calendars_b.calendar_id%TYPE;
907: l_return_status VARCHAR2(1);
908: l_error_message_code fnd_new_messages.message_name%TYPE;
909: l_unfilled_assignment_id pa_project_assignments.assignment_id%TYPE;
910: l_resource_type_id NUMBER;
911: l_msg_index_out NUMBER;
912: l_msg_count NUMBER;
2041: l_source_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
2042: l_new_open_assignment_tbl PA_ASSIGNMENTS_PUB.Assignment_Tbl_Type;
2043: l_resource_source_id NUMBER;
2044: l_return_status VARCHAR2(1);
2045: l_error_message_code fnd_new_messages.message_name%TYPE;
2046: l_msg_count NUMBER;
2047: l_msg_data VARCHAR2(2000);
2048: l_new_open_asgn_id NUMBER;
2049: l_new_open_asgn_number NUMBER;
3469: l_tp_amount_type_desc VARCHAR2(80);
3470: l_msg_count NUMBER;
3471: l_msg_data VARCHAR2(2000);
3472: l_resource_type_id NUMBER;
3473: l_error_message_code fnd_new_messages.message_name%TYPE;
3474: l_msg_index_out NUMBER;
3475: l_valid_flag VARCHAR2(1);
3476: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
3477: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;