[Home] [Help]
PACKAGE: APPS.PA_STAFFED_ASSIGNMENT_PVT
Source
1 PACKAGE pa_staffed_assignment_pvt AUTHID CURRENT_USER AS
2 /*$Header: PARDPVTS.pls 120.2 2007/02/06 09:48:28 dthakker ship $*/
3
4 -- 5130421
5 G_AUTO_APPROVE VARCHAR2(1) := 'N' ;
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
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
23 );
24
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
34 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35 );
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
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;