DBA Data[Home] [Help]

APPS.PA_OPEN_ASSIGNMENT_PVT dependencies on FND_API

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

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

Line 8: ,p_location_region IN pa_locations.region%TYPE := 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

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

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

Line 10: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM

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
14: ,p_number_of_requirements IN NUMBER := 1

Line 11: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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
14: ,p_number_of_requirements IN NUMBER := 1
15: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 12: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development

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
14: ,p_number_of_requirements IN NUMBER := 1
15: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
16: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 13: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

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
14: ,p_number_of_requirements IN NUMBER := 1
15: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
16: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
17: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

Line 15: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
14: ,p_number_of_requirements IN NUMBER := 1
15: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
16: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
17: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
18: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
19: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895

Line 16: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
14: ,p_number_of_requirements IN NUMBER := 1
15: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
16: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
17: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
18: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
19: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
20: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

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

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

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

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

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: );

Line 30: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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: );
34:

Line 31: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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: );
34:
35:

Line 38: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM

34:
35:
36: PROCEDURE Delete_Open_Assignment
37: ( p_assignment_row_id IN ROWID
38: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
39: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
40: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
41: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
42: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 39: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

35:
36: PROCEDURE Delete_Open_Assignment
37: ( p_assignment_row_id IN ROWID
38: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
39: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
40: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
41: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
42: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
43: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 40: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM

36: PROCEDURE Delete_Open_Assignment
37: ( p_assignment_row_id IN ROWID
38: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
39: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
40: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
41: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
42: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
43: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44: );

Line 41: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

37: ( p_assignment_row_id IN ROWID
38: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
39: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
40: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
41: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
42: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
43: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44: );
45:

Line 42: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

38: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
39: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
40: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
41: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
42: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
43: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44: );
45:
46: END pa_open_assignment_pvt;