DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_LOOKUPS

Line 1170: l_new_value pa_lookups.meaning%TYPE;

1166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1167: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
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;

Line 1171: l_old_value pa_lookups.meaning%TYPE;

1167: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
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;

Line 1189: l_changed_item pa_lookups.meaning%TYPE;

1185: l_change_id NUMBER;
1186: l_return_status VARCHAR2(1);
1187: l_msg_count NUMBER;
1188: l_msg_data VARCHAR2(2000);
1189: l_changed_item pa_lookups.meaning%TYPE;
1190: l_asmt_history_rec pa_assignments_pub.assignment_rec_type;
1191: l_saved_asmt_rec pa_assignments_pub.assignment_rec_type;
1192: l_updated_asmt_rec pa_assignments_pub.assignment_rec_type;
1193:

Line 2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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
2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR