77: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
78: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
79: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
80: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
81: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
82: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM
83: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
84: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
85: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
128:
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: l_work_type_exixts varchar2(1) := 'N'; --bug#8368384
135:
136: -- start of cursor or work type validation bug 8368384
471: IS
472:
473: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
474: l_return_status VARCHAR2(1);
475: l_person_name PER_PEOPLE_F.full_name%TYPE;
476: l_err_msg_code VARCHAR2(80);
477:
478: BEGIN
479:
605: l_msg_count NUMBER;
606: l_msg_data VARCHAR2(4000);
607: l_work_type_id NUMBER;
608: l_check_id_flag VARCHAR2(1);
609: l_person_name PER_PEOPLE_F.full_name%TYPE; -- Bug 3466411
610: l_err_msg_code VARCHAR2(80); -- Bug 3466411
611: -- Bug: 4537865
612: l_new_project_role_id pa_project_assignments.project_role_id%TYPE;
613: -- Bug: 4537865
907: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
908: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
909: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
910: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
911: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
912: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
913: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
914: ,p_number_of_requirements IN NUMBER := 1
915: ,p_api_version IN NUMBER := 1.0
3260: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
3261: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
3262: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
3263: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
3264: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
3265: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM
3266: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
3267: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
3268: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
4371: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
4372: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
4373: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
4374: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
4375: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
4376: ,p_api_version IN NUMBER := 1
4377: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4379: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6763: l_assignment_number pa_project_assignments.assignment_number%TYPE;
6764: l_assignment_row_id ROWID;
6765: l_new_assignment_tabl system.pa_num_tbl_type;
6766: l_return_status VARCHAR2(1);
6767: l_staffing_owner_name PER_PEOPLE_F.full_name%TYPE := null;
6768: l_err_msg_code VARCHAR2(80);
6769: l_staffing_owner_person_id pa_project_assignments.staffing_owner_person_id%TYPE := null;
6770:
6771: BEGIN
6961: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
6962: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
6963: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
6964: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
6965: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
6966: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
6967: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
6968: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
6969: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
7205: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
7206: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
7207: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
7208: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
7209: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
7210: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
7211: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
7212: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
7213: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
7611: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
7612: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
7613: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
7614: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
7615: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
7616: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
7617: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
7618: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
7619: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR