DBA Data[Home] [Help]

PACKAGE: APPS.PA_CUSTOMERS_CONTACTS_PVT

Source


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;