[Home] [Help]
PACKAGE: APPS.HZ_CUST_ACCT_BO_PVT
Source
1 PACKAGE HZ_CUST_ACCT_BO_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHBCAVS.pls 120.3 2008/02/06 09:48:02 vsegu ship $ */
3
4 -- PROCEDURE assign_cust_profile_rec
5 --
6 -- DESCRIPTION
7 -- Assign attribute value from customer profile object to plsql record.
8 --
9 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
10 --
11 -- ARGUMENTS
12 -- IN:
13 -- p_cust_profile_obj Customer profile object.
14 -- p_cust_acct_id Customer account Id.
15 -- p_site_use_id Customer account site use Id.
16 -- IN/OUT:
17 -- px_cust_profile_rec Customer profile plsql record.
18 --
19 -- NOTES
20 --
21 -- MODIFICATION HISTORY
22 --
23 -- 14-DEC-2004 Arnold Ng Created.
24
25 PROCEDURE assign_cust_profile_rec(
26 p_cust_profile_obj IN HZ_CUSTOMER_PROFILE_BO,
27 p_cust_acct_id IN NUMBER,
28 p_site_use_id IN NUMBER,
29 px_cust_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
30 );
31
32 -- PROCEDURE create_cust_profile
33 --
34 -- DESCRIPTION
35 -- Create customer profile.
36 --
37 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
38 --
39 -- ARGUMENTS
40 -- IN:
41 -- p_cp_obj Customer profile object.
42 -- p_ca_id Customer account Id.
43 -- p_casu_id Customer account site use Id.
44 -- OUT:
45 -- x_cp_id Customer profile Id.
46 -- x_return_status Return status after the call. The status can
47 -- be fnd_api.g_ret_sts_success (success),
48 -- fnd_api.g_ret_sts_error (error),
49 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
50 -- x_msg_count Number of messages in message stack.
51 -- x_msg_data Message text if x_msg_count is 1.
52 --
53 -- NOTES
54 --
55 -- MODIFICATION HISTORY
56 --
57 -- 14-DEC-2004 Arnold Ng Created.
58
59 PROCEDURE create_cust_profile(
60 p_cp_obj IN OUT NOCOPY HZ_CUSTOMER_PROFILE_BO,
61 p_ca_id IN NUMBER,
62 p_casu_id IN NUMBER,
63 x_cp_id OUT NOCOPY NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2
67 );
68
69 -- PROCEDURE update_cust_profile
70 --
71 -- DESCRIPTION
72 -- Update customer profile.
73 --
74 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
75 --
76 -- ARGUMENTS
77 -- IN:
78 -- p_cp_obj Customer profile object.
79 -- p_ca_id Customer account Id.
80 -- p_casu_id Customer account site use Id.
81 -- OUT:
82 -- x_cp_id Customer profile Id.
83 -- x_return_status Return status after the call. The status can
84 -- be fnd_api.g_ret_sts_success (success),
85 -- fnd_api.g_ret_sts_error (error),
86 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
87 -- x_msg_count Number of messages in message stack.
88 -- x_msg_data Message text if x_msg_count is 1.
89 --
90 -- NOTES
91 --
92 -- MODIFICATION HISTORY
93 --
94 -- 14-DEC-2004 Arnold Ng Created.
95
96 PROCEDURE update_cust_profile(
97 p_cp_obj IN OUT NOCOPY HZ_CUSTOMER_PROFILE_BO,
98 p_ca_id IN NUMBER,
99 p_casu_id IN NUMBER,
100 x_cp_id OUT NOCOPY NUMBER,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 -- PROCEDURE create_cust_profile_amts
107 --
108 -- DESCRIPTION
109 -- Create customer profile amounts.
110 --
111 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
112 --
113 -- ARGUMENTS
114 -- IN:
115 -- p_cpa_objs List of customer profile amount objects.
116 -- p_cp_id Customer profile Id.
117 -- p_ca_id Customer account Id.
118 -- p_casu_id Customer account site use Id.
119 -- OUT:
120 -- x_return_status Return status after the call. The status can
121 -- be fnd_api.g_ret_sts_success (success),
122 -- fnd_api.g_ret_sts_error (error),
123 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
124 -- x_msg_count Number of messages in message stack.
125 -- x_msg_data Message text if x_msg_count is 1.
126 --
127 -- NOTES
128 --
129 -- MODIFICATION HISTORY
130 --
131 -- 14-DEC-2004 Arnold Ng Created.
132
133 PROCEDURE create_cust_profile_amts(
134 p_cpa_objs IN OUT NOCOPY HZ_CUST_PROFILE_AMT_OBJ_TBL,
135 p_cp_id IN NUMBER,
136 p_ca_id IN NUMBER,
137 p_casu_id IN NUMBER,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2
141 );
142
143 -- PROCEDURE save_cust_profile_amts
144 --
145 -- DESCRIPTION
146 -- Create or update customer profile amounts.
147 --
148 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
149 --
150 -- ARGUMENTS
151 -- IN:
152 -- p_cpa_objs List of customer profile amount objects.
153 -- p_cp_id Customer profile Id.
154 -- p_ca_id Customer account Id.
155 -- p_casu_id Customer account site use Id.
156 -- OUT:
157 -- x_return_status Return status after the call. The status can
158 -- be fnd_api.g_ret_sts_success (success),
159 -- fnd_api.g_ret_sts_error (error),
160 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
161 -- x_msg_count Number of messages in message stack.
162 -- x_msg_data Message text if x_msg_count is 1.
163 --
164 -- NOTES
165 --
166 -- MODIFICATION HISTORY
167 --
168 -- 14-DEC-2004 Arnold Ng Created.
169
170 PROCEDURE save_cust_profile_amts(
171 p_cpa_objs IN OUT NOCOPY HZ_CUST_PROFILE_AMT_OBJ_TBL,
172 p_cp_id IN NUMBER,
173 p_ca_id IN NUMBER,
174 p_casu_id IN NUMBER,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2
178 );
179
180 -- PROCEDURE create_cust_acct_relates
181 --
182 -- DESCRIPTION
183 -- Create customer account relationships.
184 --
185 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
186 --
187 -- ARGUMENTS
188 -- IN:
189 -- p_car_objs List of customer account relationship objects.
190 -- p_ca_id Customer account Id.
191 -- OUT:
192 -- x_return_status Return status after the call. The status can
193 -- be fnd_api.g_ret_sts_success (success),
194 -- fnd_api.g_ret_sts_error (error),
195 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
196 -- x_msg_count Number of messages in message stack.
197 -- x_msg_data Message text if x_msg_count is 1.
198 --
199 -- NOTES
200 --
201 -- MODIFICATION HISTORY
202 --
203 -- 14-DEC-2004 Arnold Ng Created.
204
205 PROCEDURE create_cust_acct_relates(
206 p_car_objs IN OUT NOCOPY HZ_CUST_ACCT_RELATE_OBJ_TBL,
207 p_ca_id IN NUMBER,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2
211 );
212
213 -- PROCEDURE save_cust_acct_relates
214 --
215 -- DESCRIPTION
216 -- Create or update customer account relationships.
217 --
218 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
219 --
220 -- ARGUMENTS
221 -- IN:
222 -- p_car_objs List of customer account relationship objects.
223 -- p_ca_id Customer account Id.
224 -- OUT:
225 -- x_return_status Return status after the call. The status can
226 -- be fnd_api.g_ret_sts_success (success),
227 -- fnd_api.g_ret_sts_error (error),
228 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
229 -- x_msg_count Number of messages in message stack.
230 -- x_msg_data Message text if x_msg_count is 1.
231 --
232 -- NOTES
233 --
234 -- MODIFICATION HISTORY
235 --
236 -- 14-DEC-2004 Arnold Ng Created.
237
238 PROCEDURE save_cust_acct_relates(
239 p_car_objs IN OUT NOCOPY HZ_CUST_ACCT_RELATE_OBJ_TBL,
240 p_ca_id IN NUMBER,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2
244 );
245
246 -- PROCEDURE save_bank_acct_uses
247 --
248 -- DESCRIPTION
249 -- Create or update bank account assignments.
250 --
251 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
252 --
253 -- ARGUMENTS
254 -- IN:
255 -- p_bank_acct_use_objs List of bank account assignment objects.
256 -- p_party_id Party Id.
257 -- p_ca_id Customer account Id.
258 -- p_casu_id Customer account site use Id.
259 -- OUT:
260 -- x_return_status Return status after the call. The status can
261 -- be fnd_api.g_ret_sts_success (success),
262 -- fnd_api.g_ret_sts_error (error),
263 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
264 -- x_msg_count Number of messages in message stack.
265 -- x_msg_data Message text if x_msg_count is 1.
266 --
267 -- NOTES
268 --
269 -- MODIFICATION HISTORY
270 --
271 -- 14-DEC-2004 Arnold Ng Created.
272
273 PROCEDURE save_bank_acct_uses(
274 p_bank_acct_use_objs IN OUT NOCOPY HZ_BANK_ACCT_USE_OBJ_TBL,
275 p_party_id IN NUMBER,
276 p_ca_id IN NUMBER,
277 p_casu_id IN NUMBER,
278 x_return_status OUT NOCOPY VARCHAR2,
279 x_msg_count OUT NOCOPY NUMBER,
280 x_msg_data OUT NOCOPY VARCHAR2
281 );
282
283 -- PROCEDURE create_payment_method
284 --
285 -- DESCRIPTION
286 -- Create payment method.
287 --
288 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
289 --
290 -- ARGUMENTS
291 -- IN:
292 -- p_payment_method_obj Payment method object.
293 -- p_ca_id Customer account Id.
294 -- p_casu_id Customer account site use Id.
295 -- OUT:
296 -- x_return_status Return status after the call. The status can
297 -- be fnd_api.g_ret_sts_success (success),
298 -- fnd_api.g_ret_sts_error (error),
299 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
300 -- x_msg_count Number of messages in message stack.
301 -- x_msg_data Message text if x_msg_count is 1.
302 --
303 -- NOTES
304 --
305 -- MODIFICATION HISTORY
306 --
307 -- 14-DEC-2004 Arnold Ng Created.
308
309 PROCEDURE create_payment_method(
310 p_payment_method_obj IN OUT NOCOPY HZ_PAYMENT_METHOD_OBJ,
311 p_ca_id IN NUMBER,
312 p_casu_id IN NUMBER,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2
316 );
317
318 -- PROCEDURE save_payment_method
319 --
320 -- DESCRIPTION
321 -- Create or update payment method.
322 --
323 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
324 --
325 -- ARGUMENTS
326 -- IN:
327 -- p_payment_method_obj Payment method object.
328 -- p_ca_id Customer account Id.
329 -- p_casu_id Customer account site use Id.
330 -- OUT:
331 -- x_return_status Return status after the call. The status can
332 -- be fnd_api.g_ret_sts_success (success),
333 -- fnd_api.g_ret_sts_error (error),
334 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
335 -- x_msg_count Number of messages in message stack.
336 -- x_msg_data Message text if x_msg_count is 1.
337 --
338 -- NOTES
339 --
340 -- MODIFICATION HISTORY
341 --
342 -- 14-DEC-2004 Arnold Ng Created.
343
344 PROCEDURE save_payment_method(
345 p_payment_method_obj IN OUT NOCOPY HZ_PAYMENT_METHOD_OBJ,
346 p_ca_id IN NUMBER,
347 p_casu_id IN NUMBER,
348 x_return_status OUT NOCOPY VARCHAR2,
349 x_msg_count OUT NOCOPY NUMBER,
350 x_msg_data OUT NOCOPY VARCHAR2
351 );
352
353 -- PROCEDURE save_cust_accts
354 --
355 -- DESCRIPTION
356 -- Create or update customer accounts.
357 --
358 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
359 --
360 -- ARGUMENTS
361 -- IN:
362 -- p_ca_objs List of customer account objects.
363 -- p_create_update_flag Create or update flag.
364 -- p_parent_id Parent Id.
365 -- p_parent_os Parent original system.
366 -- p_parent_osr Parent original system reference.
367 -- p_parent_obj_type Parent object type.
368 -- OUT:
369 -- x_return_status Return status after the call. The status can
370 -- be fnd_api.g_ret_sts_success (success),
371 -- fnd_api.g_ret_sts_error (error),
372 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
373 -- x_msg_count Number of messages in message stack.
374 -- x_msg_data Message text if x_msg_count is 1.
375 --
376 -- NOTES
377 --
378 -- MODIFICATION HISTORY
379 --
380 -- 14-DEC-2004 Arnold Ng Created.
381
382 PROCEDURE save_cust_accts(
383 p_ca_objs IN OUT NOCOPY HZ_CUST_ACCT_BO_TBL,
384 p_create_update_flag IN VARCHAR2,
385 p_obj_source IN VARCHAR2 := null,
386 x_return_status OUT NOCOPY VARCHAR2,
387 x_msg_count OUT NOCOPY NUMBER,
391 p_parent_osr IN VARCHAR2,
388 x_msg_data OUT NOCOPY VARCHAR2,
389 p_parent_id IN NUMBER,
390 p_parent_os IN VARCHAR2,
392 p_parent_obj_type IN VARCHAR2
393 );
394
395 PROCEDURE save_cust_accts(
396 p_ca_v2_objs IN OUT NOCOPY HZ_CUST_ACCT_V2_BO_TBL,
397 p_create_update_flag IN VARCHAR2,
398 p_obj_source IN VARCHAR2 := null,
399 x_return_status OUT NOCOPY VARCHAR2,
400 x_msg_count OUT NOCOPY NUMBER,
401 x_msg_data OUT NOCOPY VARCHAR2,
402 p_parent_id IN NUMBER,
403 p_parent_os IN VARCHAR2,
404 p_parent_osr IN VARCHAR2,
405 p_parent_obj_type IN VARCHAR2
406 );
407
408 -- PROCEDURE create_payment_methods
409 --
410 -- DESCRIPTION
411 -- Create payment methods.
412 --
413 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
414 --
415 -- ARGUMENTS
416 -- IN:
417 -- p_payment_method_objs Payment method object.
418 -- p_ca_id Customer account Id.
419 -- p_casu_id Customer account site use Id.
420 -- OUT:
421 -- x_return_status Return status after the call. The status can
422 -- be fnd_api.g_ret_sts_success (success),
423 -- fnd_api.g_ret_sts_error (error),
424 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
425 -- x_msg_count Number of messages in message stack.
426 -- x_msg_data Message text if x_msg_count is 1.
427 --
428 -- NOTES
429 --
430 -- MODIFICATION HISTORY
431 --
432 -- 1-FEB-2008 vsegu Created.
433
434 PROCEDURE create_payment_methods(
435 p_payment_method_objs IN OUT NOCOPY HZ_PAYMENT_METHOD_OBJ_TBL,
436 p_ca_id IN NUMBER,
437 p_casu_id IN NUMBER,
438 x_return_status OUT NOCOPY VARCHAR2,
439 x_msg_count OUT NOCOPY NUMBER,
440 x_msg_data OUT NOCOPY VARCHAR2
441 );
442
443 -- PROCEDURE save_payment_methods
444 --
445 -- DESCRIPTION
446 -- Create or update payment methods.
447 --
448 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
449 --
450 -- ARGUMENTS
451 -- IN:
452 -- p_payment_method_objs Payment method object.
453 -- p_ca_id Customer account Id.
454 -- p_casu_id Customer account site use Id.
455 -- OUT:
456 -- x_return_status Return status after the call. The status can
457 -- be fnd_api.g_ret_sts_success (success),
458 -- fnd_api.g_ret_sts_error (error),
459 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
460 -- x_msg_count Number of messages in message stack.
461 -- x_msg_data Message text if x_msg_count is 1.
462 --
463 -- NOTES
464 --
465 -- MODIFICATION HISTORY
466 --
467 -- 1-FEB-2008 vsegu Created.
468
469 PROCEDURE save_payment_methods(
470 p_payment_method_objs IN OUT NOCOPY HZ_PAYMENT_METHOD_OBJ_TBL,
471 p_ca_id IN NUMBER,
472 p_casu_id IN NUMBER,
473 x_return_status OUT NOCOPY VARCHAR2,
474 x_msg_count OUT NOCOPY NUMBER,
475 x_msg_data OUT NOCOPY VARCHAR2
476 );
477
478 END HZ_CUST_ACCT_BO_PVT;