1 PACKAGE PA_CUSTOMERS_CONTACTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: PARPCCVS.pls 120.2 2005/10/27 04:24:23 msachan noship $ */
3
4
5 -- API name : Create_Project_Customer
6 -- Type : Private
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
10 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
11 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
12 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
13 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
14 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
15 -- p_project_id IN NUMBER Required
16 -- p_customer_id IN NUMBER Required
17 -- p_project_relationship_code IN VARCHAR2 Required
18 -- p_customer_bill_split IN NUMBER Required
19 -- p_bill_to_customer_id IN NUMBER Required /* For Bug 2731449 */
20 -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
21 -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
22 -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
23 -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
24 -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
25 -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
26 -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
27 -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
28 -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29 -- x_return_status OUT VARCHAR2 Required
30 -- x_msg_count OUT NUMBER Required
31 -- x_msg_data OUT VARCHAR2 Optional
32
33 PROCEDURE CREATE_PROJECT_CUSTOMER
34 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
35 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38 ,p_debug_mode IN VARCHAR2 := 'N'
39 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
40 ,p_project_id IN NUMBER
41 ,p_customer_id IN NUMBER
42 ,p_project_relationship_code IN VARCHAR2
43 ,p_customer_bill_split IN NUMBER
44 ,p_bill_to_customer_id IN NUMBER /* For Bug 2731449 */
45 ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
46 ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
47 ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
48 ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
49 ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
50 ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
51 ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
52 ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
53 ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
54 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
56 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57 ,p_project_party_id IN NUMBER DEFAULT NULL
58 --Billing setup related changes for FP_M development. Tracking bug 3279981
59 ,p_Default_Top_Task_Cust_Flag IN VARCHAR2
60 );
61
62
63 -- API name : Update_Project_Customer
64 -- Type : Private
65 -- Pre-reqs : None.
66 -- Parameters :
67 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
68 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
69 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
70 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
71 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
72 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
73 -- p_project_id IN NUMBER Required
74 -- p_customer_id IN NUMBER Required
75 -- p_project_relationship_code IN VARCHAR2 Required
76 -- p_customer_bill_split IN NUMBER Required
77 -- p_bill_to_customer_id IN NUMBER Required /* For Bug 2731449 */
78 -- p_ship_to_customer_id IN NUMBER Required /* For Bug 2731449 */
79 -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
80 -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
81 -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
82 -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
83 -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
84 -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
85 -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
86 -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
87 -- p_bill_another_project_flag IN VARCHAR2 Optional Default = 'N' -- Added By Aditi for tracking bug 4153629
88 -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
89 -- x_return_status OUT VARCHAR2 Required
90 -- x_msg_count OUT NUMBER Required
91 -- x_msg_data OUT VARCHAR2 Optional
92
93 PROCEDURE UPDATE_PROJECT_CUSTOMER
94 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
95 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
98 ,p_debug_mode IN VARCHAR2 := 'N'
99 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
100 ,p_project_id IN NUMBER
101 ,p_customer_id IN NUMBER
102 ,p_project_relationship_code IN VARCHAR2
103 ,p_customer_bill_split IN NUMBER
104 ,p_bill_to_customer_id IN NUMBER /* For Bug 2731449 */
105 ,p_ship_to_customer_id IN NUMBER /* For Bug 2731449 */
106 ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
107 ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
108 ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
109 ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
110 ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
111 ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
112 ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
113 ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
114 ,p_bill_another_project_flag IN VARCHAR2 := 'N' --Added by Aditi for tracking bug 4153629
115 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
116 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
117 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
118 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
119 --Billing setup related changes for FP_M development. Tracking bug 3279981
120 ,p_Default_Top_Task_Cust_Flag IN VARCHAR2
121 );
122
123
124 -- API name : Delete_Project_Customer
125 -- Type : Private
126 -- Pre-reqs : None.
127 -- Parameters :
128 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
129 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
130 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
132 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
133 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
134 -- p_project_id IN NUMBER Required
135 -- p_customer_id IN NUMBER Required
136 -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
137 -- x_return_status OUT VARCHAR2 Required
138 -- x_msg_count OUT NUMBER Required
139 -- x_msg_data OUT VARCHAR2 Optional
140
141 PROCEDURE DELETE_PROJECT_CUSTOMER
142 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
143 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
144 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
145 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
146 ,p_debug_mode IN VARCHAR2 := 'N'
147 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
148 ,p_project_id IN NUMBER
149 ,p_customer_id IN NUMBER
150 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
151 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
153 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
154 );
155
156
157 -- API name : Create_Customer_Contact
158 -- Type : Private
159 -- Pre-reqs : None.
160 -- Parameters :
161 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
162 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
163 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
164 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
165 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
166 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
167 -- p_project_id IN NUMBER Required
168 -- p_customer_id IN NUMBER Required
169 -- p_bill_ship_customer_id IN NUMBER Required
170 -- p_contact_id IN NUMBER Required
171 -- p_project_contact_type_code IN VARCHAR2 Required
172 -- x_return_status OUT VARCHAR2 Required
173 -- x_msg_count OUT NUMBER Required
174 -- x_msg_data OUT VARCHAR2 Optional
175
176 PROCEDURE CREATE_CUSTOMER_CONTACT
177 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
178 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
179 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
181 ,p_debug_mode IN VARCHAR2 := 'N'
182 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
183 ,p_project_id IN NUMBER
184 ,p_customer_id IN NUMBER
185 ,p_bill_ship_customer_id IN NUMBER /* For Bug 2731449 */
186 ,p_contact_id IN NUMBER
187 ,p_project_contact_type_code IN VARCHAR2
188 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
189 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
190 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
191 );
192
193
194 -- API name : Update_Customer_Contact
195 -- Type : Public
196 -- Pre-reqs : None.
197 -- Parameters :
198 -- p_api_version IN NUMBER Required Default = 1.0
199 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
200 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
201 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
202 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
204 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
205 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
206 -- p_project_id IN NUMBER Required
207 -- p_customer_id IN NUMBER Required
208 -- p_bill_ship_customer_id IN NUMBER Required /* For Bug 2731449 */
209 -- p_contact_id IN NUMBER Required
210 -- p_project_contact_type_code IN VARCHAR2 Required
211 -- p_rowid IN VARCHAR2 Required
212 -- p_record_version_number IN NUMBER Required
213 -- x_return_status OUT VARCHAR2 Required
214 -- x_msg_count OUT NUMBER Required
215 -- x_msg_data OUT VARCHAR2 Optional
216
217 PROCEDURE UPDATE_CUSTOMER_CONTACT
218 ( p_api_version IN NUMBER := 1.0
219 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
220 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
221 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
222 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
224 ,p_debug_mode IN VARCHAR2 := 'N'
225 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
226 ,p_project_id IN NUMBER
227 ,p_customer_id IN NUMBER
228 ,p_bill_ship_customer_id IN NUMBER /* For Bug 2731449 */
229 ,p_contact_id IN NUMBER
230 ,p_project_contact_type_code IN VARCHAR2
231 ,p_rowid IN VARCHAR2
232 ,p_record_version_number IN NUMBER
233 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
234 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
235 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
236 );
237
238
239 -- API name : Delete_Customer_Contact
240 -- Type : Private
241 -- Pre-reqs : None.
242 -- Parameters :
243 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
244 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
245 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
246 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
247 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
248 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
249 -- p_project_id IN NUMBER Required
250 -- p_customer_id IN NUMBER Required
251 -- p_contact_id IN NUMBER Required
252 -- p_project_contact_type_code IN VARCHAR2 Required
253 -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
254 -- x_return_status OUT VARCHAR2 Required
255 -- x_msg_count OUT NUMBER Required
256 -- x_msg_data OUT VARCHAR2 Optional
257
258 PROCEDURE DELETE_CUSTOMER_CONTACT
259 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
260 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
261 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
262 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
263 ,p_debug_mode IN VARCHAR2 := 'N'
264 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
265 ,p_project_id IN NUMBER
266 ,p_customer_id IN NUMBER
267 ,p_contact_id IN NUMBER
268 ,p_project_contact_type_code IN VARCHAR2
269 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
270 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
271 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
272 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
273 );
274
275
276 -- API name : Delete_All_Contacts
277 -- Type : Private
278 -- Pre-reqs : None.
282 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
279 -- Parameters :
280 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
281 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
283 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
284 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
285 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
286 -- p_project_id IN NUMBER Required
287 -- p_customer_id IN NUMBER Required
288 -- x_return_status OUT VARCHAR2 Required
289 -- x_msg_count OUT NUMBER Required
290 -- x_msg_data OUT VARCHAR2 Optional
291
292 PROCEDURE DELETE_ALL_CONTACTS
293 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
294 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
295 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
296 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
297 ,p_debug_mode IN VARCHAR2 := 'N'
298 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
299 ,p_project_id IN NUMBER
300 ,p_customer_id IN NUMBER
301 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
302 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
303 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
304 );
305
306 -- API name : Validate_Customer
307 -- Type : Private
308 -- Pre-reqs : None.
309 -- Parameters :
310 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
311 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
312 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
313 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
314 -- p_action IN VARCHAR2 Required
315 -- p_project_id IN NUMBER Required
316 -- p_customer_id IN NUMBER Required
317 -- p_customer_bill_split IN NUMBER Optional Default = FND_API.G_MISS_NUM
318 -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
319 -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
320 -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
321 -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
322 -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
323 -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
324 -- p_allow_user_rate_type_flag IN VARCHAR2 Optional Default = 'N'
325 -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
326 -- x_bill_another_project_flag OUT VARCHAR2 Optional
327
328 PROCEDURE VALIDATE_CUSTOMER
329 ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
330 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
331 ,p_debug_mode IN VARCHAR2 := 'N'
332 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
333 ,p_action IN VARCHAR2
334 ,p_project_id IN NUMBER
335 ,p_customer_id IN NUMBER
336 ,p_customer_bill_split IN NUMBER := FND_API.G_MISS_NUM
337 ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
338 ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
339 ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
340 ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
341 ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
342 ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
343 ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
344 ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
345 ,x_bill_another_project_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
346 );
347
348
349 -- API name : Validate_Contact
350 -- Type : Private
351 -- Pre-reqs : None.
352 -- Parameters :
353 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
354 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
355 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
356 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
357 -- p_action IN VARCHAR2 Required
358 -- p_project_id IN NUMBER Required
359 -- p_customer_id IN NUMBER Required
360 -- p_contact_id IN NUMBER Required
361 -- p_project_contact_type_code IN VARCHAR2 Required
362 -- p_rowid IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363
364 PROCEDURE VALIDATE_CONTACT
365 ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
366 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
367 ,p_debug_mode IN VARCHAR2 := 'N'
368 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
369 ,p_action IN VARCHAR2
370 ,p_project_id IN NUMBER
371 ,p_customer_id IN NUMBER
372 ,p_contact_id IN NUMBER
373 ,p_project_contact_type_code IN VARCHAR2
374 ,p_rowid IN VARCHAR2 := FND_API.G_MISS_CHAR
375 );
376
377 END PA_CUSTOMERS_CONTACTS_PVT;