1 package PA_PROJECT_PARTIES_PUB as
2 /* $Header: PARPPPMS.pls 120.3 2006/03/15 01:07:55 sunkalya noship $ */
3
4 -- Standard who
5 -- last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6 -- created_by NUMBER(15) := FND_GLOBAL.USER_ID;
7 -- last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8
9
10 PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
11 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
12 p_commit IN VARCHAR2 := FND_API.G_FALSE,
13 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
14 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15 p_debug_mode IN VARCHAR2 default 'N',
16 p_object_id IN NUMBER := FND_API.G_MISS_NUM,
17 p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
18 p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
19 p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
20 p_resource_type_id IN NUMBER := 101, --EMPLOYEE
21 p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
22 p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23 p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
24 p_scheduled_flag IN VARCHAR2 := 'N',
25 p_calling_module IN VARCHAR2,
26 p_project_id IN NUMBER := FND_API.G_MISS_NUM,
27 p_project_end_date IN DATE := FND_API.G_MISS_DATE,
28 p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
29 p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
30 x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
31 x_resource_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
32 x_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33 x_wf_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34 x_wf_item_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
35 x_wf_process OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
37 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
39
40 PROCEDURE UPDATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
41 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
44 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45 p_debug_mode IN VARCHAR2 default 'N',
46 p_object_id IN NUMBER := FND_API.G_MISS_NUM,
47 p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 p_project_role_id IN NUMBER,
49 p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_resource_type_id IN NUMBER := 101, --EMPLOYEE
51 p_resource_source_id IN NUMBER,
52 p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
54 p_start_date_active IN DATE,
55 p_scheduled_flag IN VARCHAR2 := 'N',
56 p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
57 p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
58 p_project_id IN NUMBER := FND_API.G_MISS_NUM,
59 p_project_end_date IN DATE := FND_API.G_MISS_DATE,
60 p_project_party_id IN NUMBER,
61 p_assignment_id IN NUMBER := 0,
62 p_assign_record_version_number IN NUMBER := 0,
63 p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
64 p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
65 x_assignment_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
66 x_wf_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
67 x_wf_item_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68 x_wf_process OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
69 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
70 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
71 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
72
73 PROCEDURE DELETE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 p_debug_mode IN VARCHAR2 default 'N',
79 p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
80 p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
81 p_project_id IN NUMBER := FND_API.G_MISS_NUM,
82 p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
83 p_scheduled_flag IN VARCHAR2 default 'N',
84 p_assignment_id IN NUMBER := 0,
85 p_assign_record_version_number IN NUMBER := 0,
86 p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
87 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
89 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
90
91 -- API name : get_key_member_start_date
92 -- Type : Public
93 -- Pre-reqs : None.
94 -- Parameters :
95 -- p_project_id IN NUMBER REQUIRED
96 --
97 -- History
98 --
99 -- 28-MAY-2002 anlee Created
100 --
101 --
102 -- Purpose
103 -- This API is used to calculate the key member start date
104 -- based on the project start date.
105 -- It is called in CREATE_PROJECT_PARTY, and is used to
106 -- default key member start dates when a project is created.
107 -- The implemented functionality is as follows:
108 --
109 -- IF project_start date <= sysdate
110 -- return project start date
111 --
112 -- IF project start date > sysdate
113 -- return sysdate
114 --
115 -- This function may be modified if the logic for defaulting
116 -- key member start date at project creation time needs to
117 -- be changed.
118 FUNCTION GET_KEY_MEMBER_START_DATE (p_project_id IN NUMBER)
119 return DATE;
120
121 /*=============================================================================
122 This api is used as a wrapper API to CREATE_PROJECT_PARTY
123 ==============================================================================*/
124
125 PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
126 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
127 p_commit IN VARCHAR2 := FND_API.G_FALSE,
128 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
129 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130 p_debug_mode IN VARCHAR2 default 'N',
131 p_object_id IN NUMBER := FND_API.G_MISS_NUM,
132 p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
134 p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_resource_type_id IN NUMBER := 101, --EMPLOYEE
136 p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
137 p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
139 p_scheduled_flag IN VARCHAR2 := 'N',
140 p_calling_module IN VARCHAR2,
141 p_project_id IN NUMBER := FND_API.G_MISS_NUM,
142 p_project_end_date IN DATE := FND_API.G_MISS_DATE,
143 p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
144 p_end_date_active IN OUT NOCOPY DATE,
145 x_project_party_id OUT NOCOPY NUMBER,
146 x_resource_id OUT NOCOPY NUMBER,
147 x_assignment_id OUT NOCOPY NUMBER,
148 x_wf_type OUT NOCOPY VARCHAR2,
149 x_wf_item_type OUT NOCOPY VARCHAR2,
150 x_wf_process OUT NOCOPY VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2);
154 end;
155