APPS.PA_ASSIGNMENTS_PUB dependencies on PA_TEAM_TEMPLATES

Line 922: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

918: l_admin_flag pa_project_types_all.administrative_flag%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:

Line 956: FROM pa_team_templates

952: AND system_linkage_function in ('ST', 'OT');
953:
954: CURSOR check_team_template_wf IS
955: SELECT workflow_in_progress_flag
956: FROM pa_team_templates
957: WHERE team_template_id = l_assignment_rec.assignment_template_id;
958:
959: CURSOR get_resource_source_id IS
960: SELECT person_id

Line 1344: FROM pa_team_templates

1340: FROM pa_projects_all
1341: WHERE project_id = l_assignment_rec.project_id;
1342: ELSIF l_assignment_rec.assignment_template_id IS NOT NULL AND l_assignment_rec.assignment_template_id <> FND_API.G_MISS_NUM THEN
1343: SELECT role_list_id INTO l_role_list_id
1344: FROM pa_team_templates
1345: WHERE team_template_id = l_assignment_rec.assignment_template_id;
1346: END IF;
1347: ELSE
1348: l_role_list_id := p_role_list_id;

Line 1480: l_object_type := 'PA_TEAM_TEMPLATES';

1476: l_object_id := l_assignment_rec.project_id;
1477:
1478: ELSIF l_assignment_rec.assignment_template_id IS NOT NULL AND l_assignment_rec.assignment_template_id <> FND_API.G_MISS_NUM THEN
1479:
1480: l_object_type := 'PA_TEAM_TEMPLATES';
1481:
1482: l_object_id := l_assignment_rec.assignment_template_id;
1483:
1484: END IF;

Line 3480: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

3476: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
3477: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
3478: l_object_type pa_project_subteams.object_type%TYPE;
3479: l_object_id pa_project_subteams.object_id%TYPE;
3480: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
3481: l_project_status_name pa_project_statuses.project_status_name%TYPE;
3482: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
3483: l_record_version_check VARCHAR2(1) := 'Y';
3484: l_pending_wf_check VARCHAR2(1) := 'Y';

Line 3528: FROM pa_team_templates

3524: WHERE assignment_id = l_assignment_rec.assignment_id;
3525:
3526: CURSOR check_team_template_wf IS
3527: SELECT workflow_in_progress_flag
3528: FROM pa_team_templates
3529: WHERE team_template_id = l_assignment_rec.assignment_template_id;
3530:
3531: CURSOR check_project_assignment_wf IS
3532: SELECT mass_wf_in_progress_flag

Line 4340: l_object_type := 'PA_TEAM_TEMPLATES';

4336: l_object_id := l_assignment_rec.project_id;
4337:
4338: ELSIF l_assignment_rec.assignment_template_id IS NOT NULL AND l_assignment_rec.assignment_template_id <> FND_API.G_MISS_NUM THEN
4339:
4340: l_object_type := 'PA_TEAM_TEMPLATES';
4341:
4342: l_object_id := l_assignment_rec.assignment_template_id;
4343:
4344: END IF;

Line 4911: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

4907: l_project_party_id NUMBER;
4908: l_msg_index_out NUMBER;
4909: l_assignment_row_id ROWID;
4910: l_assignment_id NUMBER;
4911: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
4912: l_project_id pa_project_assignments.project_id%TYPE;
4913: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
4914: l_return_status VARCHAR2(1);
4915:

Line 4930: pa_team_templates tt

4926:
4927: CURSOR check_team_template_wf IS
4928: SELECT tt.workflow_in_progress_flag
4929: FROM pa_project_assignments asgn,
4930: pa_team_templates tt
4931: WHERE asgn.assignment_id = p_assignment_id
4932: AND asgn.template_flag = 'Y'
4933: AND tt.team_template_id = asgn.assignment_template_id;
4934: