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