APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_LOCATIONS

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

8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

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

9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

1251:
1252:
1253: PROCEDURE Update_Staffed_Assignment
1254: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1255: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1256: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1257: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1258: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1259: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

1252:
1253: PROCEDURE Update_Staffed_Assignment
1254: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1255: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1256: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1257: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1258: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1259: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1260: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1253: PROCEDURE Update_Staffed_Assignment
1254: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1255: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1256: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1257: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1258: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1259: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1260: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1261: ) IS