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_LOCATIONS

Line 1172: l_new_city pa_locations.city%TYPE;

1168: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1169: IS
1170: l_new_value pa_lookups.meaning%TYPE;
1171: l_old_value pa_lookups.meaning%TYPE;
1172: l_new_city pa_locations.city%TYPE;
1173: l_new_region pa_locations.region%TYPE;
1174: l_new_country_code pa_locations.country_code%TYPE;
1175: l_old_city pa_locations.city%TYPE;
1176: l_old_region pa_locations.region%TYPE;

Line 1173: l_new_region pa_locations.region%TYPE;

1169: IS
1170: l_new_value pa_lookups.meaning%TYPE;
1171: l_old_value pa_lookups.meaning%TYPE;
1172: l_new_city pa_locations.city%TYPE;
1173: l_new_region pa_locations.region%TYPE;
1174: l_new_country_code pa_locations.country_code%TYPE;
1175: l_old_city pa_locations.city%TYPE;
1176: l_old_region pa_locations.region%TYPE;
1177: l_old_country_code pa_locations.country_code%TYPE;

Line 1174: l_new_country_code pa_locations.country_code%TYPE;

1170: l_new_value pa_lookups.meaning%TYPE;
1171: l_old_value pa_lookups.meaning%TYPE;
1172: l_new_city pa_locations.city%TYPE;
1173: l_new_region pa_locations.region%TYPE;
1174: l_new_country_code pa_locations.country_code%TYPE;
1175: l_old_city pa_locations.city%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;

Line 1175: l_old_city pa_locations.city%TYPE;

1171: l_old_value pa_lookups.meaning%TYPE;
1172: l_new_city pa_locations.city%TYPE;
1173: l_new_region pa_locations.region%TYPE;
1174: l_new_country_code pa_locations.country_code%TYPE;
1175: l_old_city pa_locations.city%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;

Line 1176: l_old_region pa_locations.region%TYPE;

1172: l_new_city pa_locations.city%TYPE;
1173: l_new_region pa_locations.region%TYPE;
1174: l_new_country_code pa_locations.country_code%TYPE;
1175: l_old_city pa_locations.city%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;

Line 1177: l_old_country_code pa_locations.country_code%TYPE;

1173: l_new_region pa_locations.region%TYPE;
1174: l_new_country_code pa_locations.country_code%TYPE;
1175: l_old_city pa_locations.city%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;

Line 1201: FROM pa_locations

1197: WHERE assignment_id = p_assignment_id;
1198:
1199: CURSOR get_locations (new_location_id NUMBER, old_location_id NUMBER) IS
1200: SELECT location_id, city, region, country_code
1201: FROM pa_locations
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

Line 2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM