[Home] [Help]
15: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
17: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
19: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
20: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
21: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
22: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
23: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
868: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
869: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
870: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
871: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
872: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
873: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
874: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
875: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
876: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
896: l_resource_source_id NUMBER;
897: -- Bug: 4537865
898: l_new_resource_source_id NUMBER;
899: l_new_project_role_id pa_project_assignments.project_role_id%TYPE;
900: l_new_role_list_id pa_role_lists.role_list_id%TYPE;
901: l_new_calendar_id pa_project_assignments.calendar_id %TYPE;
902: l_new_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
903: -- Bug: 4537865
904: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
919: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
920: l_object_type pa_project_subteams.object_type%TYPE;
921: l_object_id pa_project_subteams.object_id%TYPE;
922: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
923: l_role_list_id pa_role_lists.role_list_id%TYPE;
924: l_project_id pa_project_assignments.project_id%TYPE;
925: l_adv_action_set_id NUMBER;
926:
927: l_temp_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
5409: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
5410: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
5411: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
5412: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
5413: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
5414: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
5415: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
5416: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
5417: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
5705: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
5706: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
5707: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
5708: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
5709: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
5710: ,p_resource_id_tbl IN system.pa_num_tbl_type
5711: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
5712: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
5713: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE