eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_PROJECT_SUBTEAMS

Line 1180: l_new_subteam_name pa_project_subteams.name%TYPE;

1176: l_old_region pa_locations.region%TYPE;
1177: l_old_country_code pa_locations.country_code%TYPE;
1178: l_new_work_type pa_work_types_vl.name%TYPE;
1179: l_old_work_type pa_work_types_vl.name%TYPE;
1180: l_new_subteam_name pa_project_subteams.name%TYPE;
1181: l_old_subteam_name pa_project_subteams.name%TYPE;
1182: l_project_subteam_id pa_project_subteam_parties.project_subteam_id%TYPE;
1183: l_his_project_subteam_id pa_assignments_history.project_subteam_id%TYPE;
1184: l_msg_index_out NUMBER;

Line 1181: l_old_subteam_name pa_project_subteams.name%TYPE;

1177: l_old_country_code pa_locations.country_code%TYPE;
1178: l_new_work_type pa_work_types_vl.name%TYPE;
1179: l_old_work_type pa_work_types_vl.name%TYPE;
1180: l_new_subteam_name pa_project_subteams.name%TYPE;
1181: l_old_subteam_name pa_project_subteams.name%TYPE;
1182: l_project_subteam_id pa_project_subteam_parties.project_subteam_id%TYPE;
1183: l_his_project_subteam_id pa_assignments_history.project_subteam_id%TYPE;
1184: l_msg_index_out NUMBER;
1185: l_change_id NUMBER;

Line 1206: FROM pa_project_subteams

1202: WHERE location_id in (new_location_id, old_location_id);
1203:
1204: CURSOR get_project_subteam_names (new_project_subteam_id NUMBER, old_project_subteam_id NUMBER)IS
1205: SELECT project_subteam_id, name
1206: FROM pa_project_subteams
1207: WHERE project_subteam_id in (new_project_subteam_id, old_project_subteam_id);
1208:
1209: CURSOR get_project_subteam_id IS
1210: SELECT project_subteam_id

Line 2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR