eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on FND_API

Line 10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

6:
7: PROCEDURE Create_Staffed_Assignment
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

Line 11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM

7: PROCEDURE Create_Staffed_Assignment
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

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 15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development

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
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

Line 16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := 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
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895

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

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
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
21: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

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

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
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
21: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

25:
26:
27: PROCEDURE Update_Staffed_Assignment
28: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
29: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
30: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
31: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

26:
27: PROCEDURE Update_Staffed_Assignment
28: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
29: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
30: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
31: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

27: PROCEDURE Update_Staffed_Assignment
28: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
29: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
30: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
31: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: );

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

28: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
29: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
30: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
31: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: );
36:

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

29: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
30: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
31: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: );
36:
37:

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

36:
37:
38: PROCEDURE Delete_Staffed_Assignment
39: ( p_assignment_row_id IN ROWID
40: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
41: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
42: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
43: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

37:
38: PROCEDURE Delete_Staffed_Assignment
39: ( p_assignment_row_id IN ROWID
40: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
41: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
42: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
43: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 42: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM

38: PROCEDURE Delete_Staffed_Assignment
39: ( p_assignment_row_id IN ROWID
40: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
41: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
42: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
43: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 43: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR

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

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

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

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

41: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
42: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
43: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
47: );
48:
49: END pa_staffed_assignment_pvt;