DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PVT dependencies on PA_PROJECT_ASSIGNMENTS

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

3: --
4: PROCEDURE Create_Assignment
5: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
6: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
7: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
8: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
9: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
10: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
11: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 20: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_number_of_requirements IN NUMBER := 1
18: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
19: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
20: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
21: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
22: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
23: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
24: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 21: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895

17: ,p_number_of_requirements IN NUMBER := 1
18: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
19: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
20: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
21: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
22: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
23: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
24: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: );

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

40:
41:
42: PROCEDURE Delete_Assignment
43: ( p_assignment_row_id IN ROWID := NULL
44: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
45: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
47: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
48: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 45: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR

41:
42: PROCEDURE Delete_Assignment
43: ( p_assignment_row_id IN ROWID := NULL
44: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
45: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
47: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
48: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
49: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 47: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM

43: ( p_assignment_row_id IN ROWID := NULL
44: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
45: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
47: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
48: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
49: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
50: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
51: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 63: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

59: );
60:
61: /* Added procedure Update_Transfer_Price for bug 3051110*/
62: PROCEDURE Update_Transfer_Price
63: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
64: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
65: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
66: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
67: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 64: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE

60:
61: /* Added procedure Update_Transfer_Price for bug 3051110*/
62: PROCEDURE Update_Transfer_Price
63: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
64: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
65: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
66: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
67: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
68: );

Line 65: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE

61: /* Added procedure Update_Transfer_Price for bug 3051110*/
62: PROCEDURE Update_Transfer_Price
63: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
64: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE
65: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE
66: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
67: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
68: );
69:

Line 72: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

68: );
69:
70: /* Added procedure Calc_Init_Transfer_Price for bug 3051110*/
71: PROCEDURE Calc_Init_Transfer_Price
72: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
73: ,p_start_date IN pa_project_assignments.start_date%TYPE
74: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
75: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 73: ,p_start_date IN pa_project_assignments.start_date%TYPE

69:
70: /* Added procedure Calc_Init_Transfer_Price for bug 3051110*/
71: PROCEDURE Calc_Init_Transfer_Price
72: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
73: ,p_start_date IN pa_project_assignments.start_date%TYPE
74: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
75: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77: ,x_msg_count OUT NOCOPY Number --File.Sql.39 bug 4440895