[Home] [Help]
PACKAGE: APPS.PA_CUSTOMERS_CONTACTS_UTILS
Source
1 PACKAGE PA_CUSTOMERS_CONTACTS_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PARPCCUS.pls 120.2 2007/02/06 09:54:54 dthakker ship $ */
3
4
5 -- API name : Check_Customer_Name_Or_Id
6 -- Type : Utility
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
10 -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
11 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
12 -- x_customer_id OUT NUMBER Required
13 -- x_return_status OUT VARCHAR2 Required
14 -- x_error_msg_code OUT VARCHAR2 Required
15
16 PROCEDURE CHECK_CUSTOMER_NAME_OR_ID
17 ( p_customer_id IN NUMBER := FND_API.G_MISS_NUM
18 ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
19 ,p_check_id_flag IN VARCHAR2 := 'A'
20 ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
21 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23 );
24
25
26 -- API name : Check_Customer_Number_Or_Id
27 -- Type : Utility
28 -- Pre-reqs : None.
29 -- Parameters :
30 -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
31 -- p_customer_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
33 -- x_customer_id OUT NUMBER Required
34 -- x_return_status OUT VARCHAR2 Required
35 -- x_error_msg_code OUT VARCHAR2 Required
36
37 PROCEDURE CHECK_CUSTOMER_NUMBER_OR_ID
38 ( p_customer_id IN NUMBER := FND_API.G_MISS_NUM
39 ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
40 ,p_check_id_flag IN VARCHAR2 := 'A'
41 ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
42 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44 );
45
46
47 -- API name : Check_Bill_Site_Name_Or_Id
48 -- Type : Utility
49 -- Pre-reqs : None.
50 -- Parameters :
51 -- p_customer_id IN NUMBER Required
52 -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
53 -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
54 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
55 -- x_bill_to_address_id OUT NUMBER Optional
56 -- x_return_status OUT VARCHAR2 Required
57 -- x_error_msg_code OUT VARCHAR2 Required
58
59 PROCEDURE CHECK_BILL_SITE_NAME_OR_ID
60 ( p_customer_id IN NUMBER
61 ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
62 ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
63 ,p_check_id_flag IN VARCHAR2 := 'A'
64 ,x_bill_to_address_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67 );
68
69
70 -- API name : Check_Work_Site_Name_Or_Id
71 -- Type : Utility
72 -- Pre-reqs : None.
73 -- Parameters :
74 -- p_customer_id IN NUMBER Required
75 -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
76 -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
77 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
78 -- x_ship_to_address_id OUT NUMBER Optional
79 -- x_return_status OUT VARCHAR2 Required
80 -- x_error_msg_code OUT VARCHAR2 Required
81
82 PROCEDURE CHECK_WORK_SITE_NAME_OR_ID
83 ( p_customer_id IN NUMBER
84 ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
85 ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
86 ,p_check_id_flag IN VARCHAR2 := 'A'
87 ,x_ship_to_address_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
88 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
89 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90 );
91
92 /*
93 -- API name : Check_Receiver_Proj_Name_Or_Id
94 -- Type : Utility
95 -- Pre-reqs : None.
96 -- Parameters :
97 -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
98 -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
99 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
100 -- x_receiver_task_id OUT NUMBER Optional
101 -- x_return_status OUT VARCHAR2 Required
102 -- x_error_msg_code OUT VARCHAR2 Required
103
104 PROCEDURE CHECK_RECEIVER_PROJ_NAME_OR_ID
105 ( p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
106 ,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
107 ,p_check_id_flag IN VARCHAR2 := 'A'
108 ,x_receiver_task_id OUT NUMBER
109 ,x_return_status OUT VARCHAR2
110 ,x_error_msg_code OUT VARCHAR2
111 );
112 */
113
114 -- API name : Check_Contact_Name_Or_Id
115 -- Type : Utility
116 -- Pre-reqs : None.
117 -- Parameters :
118 -- p_customer_id IN NUMBER Required
119 -- p_project_contact_type_code IN VARCHAR2 Required
120 -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
121 -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
122 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
123 -- x_contact_id OUT NUMBER Required
124 -- x_return_status OUT VARCHAR2 Required
125 -- x_error_msg_code OUT VARCHAR2 Required
126
127 PROCEDURE CHECK_CONTACT_NAME_OR_ID
128 ( p_customer_id IN NUMBER
129 ,p_project_contact_type_code IN VARCHAR2
130 ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
131 ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
132 ,p_check_id_flag IN VARCHAR2 := 'A'
133 ,p_address_id IN NUMBER := NULL -- Added for Bug 2964227
134 ,x_contact_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
135 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137 );
138
139
140 -- API name : Check_Contact_Typ_Name_Or_Code
141 -- Type : Utility
142 -- Pre-reqs : None.
143 -- Parameters :
144 -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
145 -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
146 -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
147 -- x_project_contact_type_code OUT VARCHAR2 Required
148 -- x_return_status OUT VARCHAR2 Required
149 -- x_error_msg_code OUT VARCHAR2 Required
150
151 PROCEDURE CHECK_CONTACT_TYP_NAME_OR_CODE
152 ( p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
153 ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
154 ,p_check_id_flag IN VARCHAR2 := 'A'
155 ,x_project_contact_type_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
157 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
158 );
159
160
161 -- API name : Check_Duplicate_Customer
162 -- Type : Utility
163 -- Pre-reqs : None.
164 -- Parameters :
165 -- p_project_id IN NUMBER Required
166 -- p_customer_id IN NUMBER Required
167 -- x_return_status OUT VARCHAR2 Required
168 -- x_error_msg_code OUT VARCHAR2 Required
169
170 PROCEDURE CHECK_DUPLICATE_CUSTOMER
171 ( p_project_id IN NUMBER
172 ,p_customer_id IN NUMBER
173 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175 );
176
177
178 -- API name : Check_Duplicate_Contact
179 -- Type : Utility
180 -- Pre-reqs : None.
181 -- Parameters :
182 -- p_project_id IN NUMBER Required
183 -- p_customer_id IN NUMBER Required
184 -- p_contact_id IN NUMBER Required
185 -- p_project_contact_type_code IN VARCHAR2 Required
186 -- x_return_status OUT VARCHAR2 Required
187 -- x_error_msg_code OUT VARCHAR2 Required
188
189 PROCEDURE CHECK_DUPLICATE_CONTACT
190 ( p_project_id IN NUMBER
191 ,p_customer_id IN NUMBER
192 ,p_contact_id IN NUMBER
193 ,p_project_contact_type_code IN VARCHAR2
194 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
195 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
196 );
197
198
199 -- API name : Check_Contribution_Percentage
200 -- Type : Utility
201 -- Pre-reqs : None.
202 -- Parameters :
203 -- p_customer_bill_split IN NUMBER Required
204 -- x_return_status OUT VARCHAR2 Required
205 -- x_error_msg_code OUT VARCHAR2 Required
206
207 PROCEDURE CHECK_CONTRIBUTION_PERCENTAGE
208 ( p_customer_bill_split IN NUMBER
209 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
210 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
211 );
212
213
214 -- API name : Check_Contribution_Total
215 -- Type : Utility
216 -- Pre-reqs : None.
217 -- Parameters :
218 -- p_customer_bill_split IN NUMBER Required
219 -- p_customer_id IN NUMBER Required
220 -- x_return_status OUT VARCHAR2 Required
221 -- x_error_msg_code OUT VARCHAR2 Required
222
223 PROCEDURE CHECK_CONTRIBUTION_TOTAL
224 ( p_customer_bill_split IN NUMBER
225 ,p_project_id IN NUMBER
226 ,p_customer_id IN NUMBER
227 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
228 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
229 );
230
231
232 -- API name : Check_Bill_Work_Sites_Required
233 -- Type : Utility
234 -- Pre-reqs : None.
235 -- Parameters :
236 -- p_customer_bill_split IN NUMBER Required
237 -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
238 -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
239 -- x_return_status OUT VARCHAR2 Required
240 -- x_error_msg_code OUT VARCHAR2 Required
241
242 PROCEDURE CHECK_BILL_WORK_SITES_REQUIRED
243 ( p_customer_bill_split IN NUMBER
244 ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
245 ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
246 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
248 );
249
250
251 -- API name : Check_Cc_Prvdr_Flag_Contrib
252 -- Type : Utility
253 -- Pre-reqs : None.
254 -- Parameters :
255 -- p_project_id IN NUMBER Required
256 -- p_customer_id IN NUMBER Required
257 -- p_customer_bill_split IN NUMBER Required
258 -- x_return_status OUT VARCHAR2 Required
259 -- x_error_msg_code OUT VARCHAR2 Required
260
261 PROCEDURE CHECK_CC_PRVDR_FLAG_CONTRIB
262 ( p_project_id IN NUMBER
263 ,p_customer_id IN NUMBER
264 ,p_customer_bill_split IN NUMBER
265 ,p_action IN VARCHAR2
266 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
267 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
268 );
269
270
271 -- API name : Check_Receiver_Proj_Enterable
272 -- Type : Utility
273 -- Pre-reqs : None.
274 -- Parameters :
275 -- p_project_id IN NUMBER Required
276 -- p_customer_id IN NUMBER Required
277 -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
278 -- x_bill_another_project_flag OUT VARCHAR2 Required
279 -- x_return_status OUT VARCHAR2 Required
280 -- x_error_msg_code OUT VARCHAR2 Required
281
282 PROCEDURE CHECK_RECEIVER_PROJ_ENTERABLE
283 ( p_project_id IN NUMBER
284 ,p_customer_id IN NUMBER
285 ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
286 ,x_bill_another_project_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
287 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
288 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
289 );
290
291
292 -- API name : Check_Invoice_Currency_Info
293 -- Type : Utility
294 -- Pre-reqs : None.
295 -- Parameters :
296 -- p_project_id IN NUMBER Required
297 -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
298 -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
302 -- x_return_status OUT VARCHAR2 Required
299 -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
300 -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
301 -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
303 -- x_error_msg_code OUT VARCHAR2 Required
304
305 PROCEDURE CHECK_INVOICE_CURRENCY_INFO
306 ( p_project_id IN NUMBER
307 ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
308 ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
309 ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
310 ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
311 ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
312 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
313 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
314 );
315
316
317 -- API name : Check_Update_Contrib_Allowed
318 -- Type : Utility
319 -- Pre-reqs : None.
320 -- Parameters :
321 -- p_project_id IN NUMBER Required
322 -- p_customer_id IN NUMBER Required
323 -- p_customer_bill_split IN NUMBER Required
324 -- x_return_status OUT VARCHAR2 Required
325 -- x_error_msg_code OUT VARCHAR2 Required
326
327 PROCEDURE CHECK_UPDATE_CONTRIB_ALLOWED
328 ( p_project_id IN NUMBER
329 ,p_customer_id IN NUMBER
330 ,p_customer_bill_split IN NUMBER
331 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
332 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
333 );
334
335
336 -- API name : Check_Delete_Customer_Allowed
337 -- Type : Utility
338 -- Pre-reqs : None.
339 -- Parameters :
340 -- p_project_id IN NUMBER Required
341 -- p_customer_id IN NUMBER Required
342 -- x_return_status OUT VARCHAR2 Required
343 -- x_error_msg_code OUT VARCHAR2 Required
344
345 PROCEDURE CHECK_DELETE_CUSTOMER_ALLOWED
346 ( p_project_id IN NUMBER
347 ,p_customer_id IN NUMBER
348 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
349 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
350 );
351
352
353 -- API name : Get_Org_Id
354 -- Type : Utility
355 -- Pre-reqs : None.
356 -- Parameters : None.
357 -- Return Type : Number
358 FUNCTION GET_ORG_ID
359 RETURN NUMBER;
360
361
362 -- API name : Check_Customer_Name_And_Number
363 -- Type : Utility
364 -- Pre-reqs : None.
365 -- Parameters :
366 -- p_customer_name IN VARCHAR2 Required
367 -- p_customer_number IN VARCHAR2 Required
368 -- x_customer_id OUT NUMBER Required
369 -- x_return_status OUT VARCHAR2 Required
370 -- x_error_msg_code OUT VARCHAR2 Required
371
372 PROCEDURE CHECK_CUSTOMER_NAME_AND_NUMBER
373 ( p_customer_name IN VARCHAR2
374 ,p_customer_number IN VARCHAR2
375 ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
376 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
377 ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
378 );
379
380 -- API name : Get_Contribution_Total
381 -- Type : Utility
382 -- Pre-reqs : None.
383 -- Parameters : Project_Id
384 -- Return Type : Number
385 FUNCTION GET_CONTRIBUTION_TOTAL (p_project_id IN NUMBER)
386 RETURN NUMBER;
387
388
389 --sunkalya federal changes Bug#5511353
390 -- Procedure : Get_Highest_Contr_Fed_Cust
391 -- Type : PRIVATE
392 -- Purpose : Gets the highest contribution federal customer. If contribution is same,
393 -- then sorts on name and if names are also same, then sorts on
394 -- customer id. This API is included as a part of
395 -- federal changes.
396 -- Note :
397 -- Assumptions :
398 -- Parameters Type Required Description and Purpose
399 -- --------------------------- ------ -------- --------------------------------------------------------
400 -- p_project_id NUMBER Y Project ID for which highest contribution customer is
401 -- to be returned
402 -- x_highst_contr_cust_id NUMBER N Customer ID of the highest contribution customer
403
404 PROCEDURE Get_Highest_Contr_Fed_Cust(
405 p_api_version IN NUMBER := 1.0
406 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
407 , p_commit IN VARCHAR2 := FND_API.G_FALSE
408 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
409 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
410 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
411 , p_debug_mode IN VARCHAR2 := 'N'
412 , p_project_id IN NUMBER
413 , x_highst_contr_cust_id OUT NOCOPY NUMBER
414 , x_return_status OUT NOCOPY VARCHAR2
415 , x_msg_count OUT NOCOPY NUMBER
416 , x_msg_data OUT NOCOPY VARCHAR2
417 );
418
419 END PA_CUSTOMERS_CONTACTS_UTILS;