APPS.PA_ASSIGNMENTS_PVT dependencies on PA_LOCATIONS

Line 13: ,p_location_city IN pa_locations.city%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_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 14: ,p_location_region IN pa_locations.region%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_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development

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

11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
13: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

Line 45: l_location_city pa_locations.city%TYPE;

41: l_assignment_effort_calc VARCHAR2(1) := 'N';
42: l_raw_revenue NUMBER;
43: l_rec_version_number NUMBER;
44: -- FP.M Development
45: l_location_city pa_locations.city%TYPE;
46: l_location_region pa_locations.region%TYPE;
47: l_location_country_code pa_locations.country_code%TYPE;
48:
49: CURSOR get_subteam_id IS

Line 46: l_location_region pa_locations.region%TYPE;

42: l_raw_revenue NUMBER;
43: l_rec_version_number NUMBER;
44: -- FP.M Development
45: l_location_city pa_locations.city%TYPE;
46: l_location_region pa_locations.region%TYPE;
47: l_location_country_code pa_locations.country_code%TYPE;
48:
49: CURSOR get_subteam_id IS
50: SELECT project_subteam_id,

Line 47: l_location_country_code pa_locations.country_code%TYPE;

43: l_rec_version_number NUMBER;
44: -- FP.M Development
45: l_location_city pa_locations.city%TYPE;
46: l_location_region pa_locations.region%TYPE;
47: l_location_country_code pa_locations.country_code%TYPE;
48:
49: CURSOR get_subteam_id IS
50: SELECT project_subteam_id,
51: primary_subteam_flag

Line 108: FROM pa_projects_all ppa,pa_locations pl

104: ,l_assignment_rec.location_id
105: ,l_location_city
106: ,l_location_region
107: ,l_location_country_code
108: FROM pa_projects_all ppa,pa_locations pl
109: WHERE project_id = l_assignment_rec.project_id
110: AND PPA.LOCATION_ID = PL.LOCATION_ID(+) ;
111:
112: -- Bug 4282413: Job levels are passed in from CrUdTeamRoleVORowImpl.

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

371: PROCEDURE Update_Assignment
372: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
379: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

372: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
379: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
380: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
379: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
380: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
381: )