[Home] [Help]
Skip to content
PACKAGE: APPS.PA_PROJECT_PARTIES_PVT
Source
1 package PA_PROJECT_PARTIES_PVT AUTHID CURRENT_USER as
2 /* $Header: PARPPUTS.pls 120.1 2005/08/19 16:58:45 mwasowic noship $ */
3
4 -- l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
5 l_delete_proj_party VARCHAR2(1) := 'Y';
6
7 PROCEDURE CREATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_debug_mode IN VARCHAR2 default 'N',
11 p_object_id IN NUMBER := FND_API.G_MISS_NUM,
12 p_OBJECT_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
13 p_RESOURCE_TYPE_ID IN NUMBER := 101,
14 p_project_role_id IN NUMBER,
15 p_resource_source_id IN NUMBER,
16 p_start_date_active IN DATE,
17 p_scheduled_flag IN VARCHAR2 := 'N',
18 p_calling_module IN VARCHAR2,
19 p_project_id IN NUMBER := FND_API.G_MISS_NUM,
20 p_project_end_date IN DATE,
21 p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/
22 p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
23 x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
24 x_resource_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25 x_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
26 x_wf_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
27 x_wf_item_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28 x_wf_process OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
30 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
31 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
32
33 PROCEDURE UPDATE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
35 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36 p_debug_mode IN VARCHAR2 default 'N',
37 p_object_id IN NUMBER := FND_API.G_MISS_NUM,
38 p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
39 p_project_role_id IN NUMBER,
40 p_resource_type_id IN NUMBER := 101,
41 p_resource_source_id IN NUMBER,
42 p_resource_id IN NUMBER,
43 p_start_date_active IN DATE,
44 p_scheduled_flag IN VARCHAR2 := 'N',
45 p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
46 p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
47 p_project_id IN NUMBER := FND_API.G_MISS_NUM,
48 p_project_end_date IN DATE,
49 p_project_party_id IN NUMBER,
50 p_assignment_id IN NUMBER,
51 p_assign_record_version_number IN NUMBER,
52 p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/
53 p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
54 x_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55 x_wf_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
56 x_wf_item_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
57 x_wf_process OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
59 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
60 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
61
62 PROCEDURE DELETE_PROJECT_PARTY( p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
64 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65 p_debug_mode IN VARCHAR2 default 'N',
66 p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
67 p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
68 p_project_id IN NUMBER := FND_API.G_MISS_NUM,
69 p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
70 p_scheduled_flag IN VARCHAR2 := 'N',
71 p_assignment_id IN NUMBER := 0,
72 p_assign_record_version_number IN NUMBER := 0,
73 p_mgr_validation_type IN VARCHAR2 := FND_API.G_MISS_CHAR,/*Added for bug 2111806*/
74 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
75 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
76 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
77
78 end;
79