APPS.PA_TEAM_TEMPLATES_PVT dependencies on PA_PROJECT_SUBTEAMS

Line 377: l_project_subteam_id pa_project_subteams.project_subteam_id%TYPE;

373: l_index NUMBER;
374: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
375: l_project_location_id pa_projects_all.location_id%TYPE;
376: l_number_of_days NUMBER;
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;

Line 378: l_subteam_name pa_project_subteams.name%TYPE;

374: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
375: l_project_location_id pa_projects_all.location_id%TYPE;
376: l_number_of_days NUMBER;
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;

Line 439: FROM pa_project_subteams

435: AND template_flag = 'Y';
436:
437: CURSOR get_team_template_subteams(p_team_template_id NUMBER) IS
438: SELECT name
439: FROM pa_project_subteams
440: WHERE object_type = 'PA_TEAM_TEMPLATES'
441: AND object_id = p_team_template_id;
442:
443: CURSOR get_team_start_date(p_team_template_id NUMBER) IS

Line 552: PA_PROJECT_SUBTEAMS_PUB.Create_Subteam(p_subteam_name => l_subteam_name,

548: --if the project subteam id returned is null then that subteam does not exist on that
549: --project, so call create subteam API
550: IF l_project_subteam_id IS NULL THEN
551:
552: PA_PROJECT_SUBTEAMS_PUB.Create_Subteam(p_subteam_name => l_subteam_name,
553: p_object_type => 'PA_PROJECTS',
554: p_object_id => p_project_id,
555: p_validate_only => FND_API.G_FALSE,
556: p_init_msg_list => FND_API.G_FALSE,

Line 991: PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam_By_Obj

987: ,x_log_level => 5);
988: END IF;
989: --don't pass subteam id and this API will delete all subteams belonging to the
990: --team template.
991: PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam_By_Obj
992: (p_init_msg_list => FND_API.G_FALSE,
993: p_validate_only => FND_API.G_FALSE,
994: p_object_type => 'PA_TEAM_TEMPLATES',
995: p_object_id => p_team_template_id,