[Home] [Help]
PACKAGE: APPS.PA_OPEN_ASSIGNMENT_PVT
Source
1 PACKAGE pa_open_assignment_pvt AS
2 /*$Header: PAROPVTS.pls 120.1 2005/08/19 16:57:38 mwasowic noship $*/
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
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
21 );
22
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
32 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33 );
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
43 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44 );
45
46 END pa_open_assignment_pvt;