3: --
4: PROCEDURE Create_Open_Assignment
5: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
6: ,p_asgn_creation_mode IN VARCHAR2
7: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
8: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
9: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
11: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
4: PROCEDURE Create_Open_Assignment
5: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
6: ,p_asgn_creation_mode IN VARCHAR2
7: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
8: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
9: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
11: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
12: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
5: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
6: ,p_asgn_creation_mode IN VARCHAR2
7: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
8: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
9: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
11: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
12: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
13: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
23:
24:
25: PROCEDURE Update_Open_Assignment
26: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
27: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
28: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
29: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
30: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
31: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
24:
25: PROCEDURE Update_Open_Assignment
26: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
27: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
28: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
29: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
30: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
31: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
32: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: PROCEDURE Update_Open_Assignment
26: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
27: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
28: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
29: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
30: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
31: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
32: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33: );