APPS.PA_ASSIGNMENTS_PUB dependencies on PA_TEAM_TEMPLATES

Line 957: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

953: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
954: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
955: l_object_type pa_project_subteams.object_type%TYPE;
956: l_object_id pa_project_subteams.object_id%TYPE;
957: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
958: l_role_list_id pa_role_lists.role_list_id%TYPE;
959: l_project_id pa_project_assignments.project_id%TYPE;
960: l_adv_action_set_id NUMBER;
961:

Line 991: FROM pa_team_templates

987: AND system_linkage_function in ('ST', 'OT');
988:
989: CURSOR check_team_template_wf IS
990: SELECT workflow_in_progress_flag
991: FROM pa_team_templates
992: WHERE team_template_id = l_assignment_rec.assignment_template_id;
993:
994: CURSOR get_resource_source_id IS
995: SELECT person_id

Line 1379: FROM pa_team_templates

1375: FROM pa_projects_all
1376: WHERE project_id = l_assignment_rec.project_id;
1377: ELSIF l_assignment_rec.assignment_template_id IS NOT NULL AND l_assignment_rec.assignment_template_id <> FND_API.G_MISS_NUM THEN
1378: SELECT role_list_id INTO l_role_list_id
1379: FROM pa_team_templates
1380: WHERE team_template_id = l_assignment_rec.assignment_template_id;
1381: END IF;
1382: ELSE
1383: l_role_list_id := p_role_list_id;

Line 1515: l_object_type := 'PA_TEAM_TEMPLATES';

1511: l_object_id := l_assignment_rec.project_id;
1512:
1513: ELSIF l_assignment_rec.assignment_template_id IS NOT NULL AND l_assignment_rec.assignment_template_id <> FND_API.G_MISS_NUM THEN
1514:
1515: l_object_type := 'PA_TEAM_TEMPLATES';
1516:
1517: l_object_id := l_assignment_rec.assignment_template_id;
1518:
1519: END IF;

Line 4408: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

4404: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
4405: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
4406: l_object_type pa_project_subteams.object_type%TYPE;
4407: l_object_id pa_project_subteams.object_id%TYPE;
4408: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
4409: l_project_status_name pa_project_statuses.project_status_name%TYPE;
4410: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
4411: l_record_version_check VARCHAR2(1) := 'Y';
4412: l_pending_wf_check VARCHAR2(1) := 'Y';

Line 4456: FROM pa_team_templates

4452: WHERE assignment_id = l_assignment_rec.assignment_id;
4453:
4454: CURSOR check_team_template_wf IS
4455: SELECT workflow_in_progress_flag
4456: FROM pa_team_templates
4457: WHERE team_template_id = l_assignment_rec.assignment_template_id;
4458:
4459: CURSOR check_project_assignment_wf IS
4460: SELECT mass_wf_in_progress_flag

Line 5305: l_object_type := 'PA_TEAM_TEMPLATES';

5301: ELSIF l_assignment_rec.assignment_template_id IS NOT NULL AND l_assignment_rec.assignment_template_id <> FND_API.G_MISS_NUM
5302:
5303: THEN
5304:
5305: l_object_type := 'PA_TEAM_TEMPLATES';
5306:
5307: l_object_id := l_assignment_rec.assignment_template_id;
5308:
5309: END IF;

Line 5887: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

5883: l_project_party_id NUMBER;
5884: l_msg_index_out NUMBER;
5885: l_assignment_row_id ROWID;
5886: l_assignment_id NUMBER;
5887: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
5888: l_project_id pa_project_assignments.project_id%TYPE;
5889: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
5890: l_return_status VARCHAR2(1);
5891:

Line 5906: pa_team_templates tt

5902:
5903: CURSOR check_team_template_wf IS
5904: SELECT tt.workflow_in_progress_flag
5905: FROM pa_project_assignments asgn,
5906: pa_team_templates tt
5907: WHERE asgn.assignment_id = p_assignment_id
5908: AND asgn.template_flag = 'Y'
5909: AND tt.team_template_id = asgn.assignment_template_id;
5910: