[Home] [Help]
377: l_project_subteam_id pa_project_subteams.project_subteam_id%TYPE;
378: l_subteam_name pa_project_subteams.name%TYPE;
379: l_subteam_row_id ROWID;
380: l_team_start_date pa_team_templates.team_start_date%TYPE;
381: l_template_requirement_rec PA_ASSIGNMENTS_PUB.assignment_rec_type;
382: l_person_name PER_PEOPLE_F.full_name%TYPE;
383: l_err_msg_code VARCHAR2(80);
384:
385: CURSOR get_project_location_and_cal IS
572:
573: OPEN get_template_req_attributes(p_team_template_id);
574:
575: LOOP
576: --not using PA_ASSIGNMENTS_PUB.Copy_Team_Role because API expects the
577: --assignment id to be copied to be passed in. But it would be an extra db hit to
578: --get the assignment ids in this API and then pass them to copy_team_role. So
579: --I'll just get everything here and call create assignment.
580: FETCH get_template_req_attributes INTO l_template_requirement_rec.assignment_name
665: --call API to create the requirement
666: --using mode 'COPY' because the requirement is being copied from the
667: --template requirement - and then the source assignment id will only be
668: --used to get the subteams to copy, and will not be inserted to the db (no link kept).
669: PA_ASSIGNMENTS_PUB.Create_Assignment(p_assignment_rec => l_template_requirement_rec
670: ,p_asgn_creation_mode => 'COPY'
671: ,p_validate_only => FND_API.G_FALSE
672: ,x_new_assignment_id => l_new_assignment_id
673: ,x_assignment_number => l_assignment_number
1005: ,x_log_level => 5);
1006: END IF;
1007: FOR l_template_requirements IN get_template_req_details LOOP
1008:
1009: PA_ASSIGNMENTS_PUB.Delete_Assignment(
1010: p_assignment_id => l_template_requirements.assignment_id,
1011: p_record_version_number => l_template_requirements.record_version_number,
1012: p_assignment_type => l_template_requirements.assignment_type,
1013: p_calling_module => 'TEMPLATE_REQUIREMENT',