[Home] [Help]
PACKAGE: APPS.HZ_PARTY_BO_PVT
Source
1 PACKAGE HZ_PARTY_BO_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHBPTVS.pls 120.9 2006/07/22 00:17:55 acng noship $ */
3
4 G_CALL_UPDATE_CUST_BO VARCHAR2(1) := NULL;
5
6 -- PROCEDURE save_party_preferences
7 --
8 -- DESCRIPTION
9 -- Create or update party preferences.
10 --
11 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
12 --
13 -- ARGUMENTS
14 -- IN:
15 -- p_party_pref_objs List of party preference objects.
16 -- p_party_id Party Id.
17 -- OUT:
18 -- x_return_status Return status after the call. The status can
19 -- be fnd_api.g_ret_sts_success (success),
20 -- fnd_api.g_ret_sts_error (error),
21 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
22 -- x_msg_count Number of messages in message stack.
23 -- x_msg_data Message text if x_msg_count is 1.
24 --
25 -- NOTES
26 --
27 -- MODIFICATION HISTORY
28 --
29 -- 14-DEC-2004 Arnold Ng Created.
30 --
31
32 PROCEDURE save_party_preferences(
33 p_party_pref_objs IN OUT NOCOPY HZ_PARTY_PREF_OBJ_TBL,
34 p_party_id IN NUMBER,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40 -- PROCEDURE create_relationships
41 --
42 -- DESCRIPTION
43 -- Create relationships.
44 --
45 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
46 --
47 -- ARGUMENTS
48 -- IN:
49 -- p_rel_objs List of relationship objects.
50 -- p_subject_id Subject Id.
51 -- p_subject_type Subject type.
52 -- OUT:
53 -- x_return_status Return status after the call. The status can
54 -- be fnd_api.g_ret_sts_success (success),
55 -- fnd_api.g_ret_sts_error (error),
56 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
57 -- x_msg_count Number of messages in message stack.
58 -- x_msg_data Message text if x_msg_count is 1.
59 --
60 -- NOTES
61 --
62 -- MODIFICATION HISTORY
63 --
64 -- 14-DEC-2004 Arnold Ng Created.
65 --
66
67 PROCEDURE create_relationships(
68 p_rel_objs IN OUT NOCOPY HZ_RELATIONSHIP_OBJ_TBL,
69 p_subject_id IN NUMBER,
70 p_subject_type IN VARCHAR2,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2
74 );
75
76 PROCEDURE create_relationship_obj(
77 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
78 p_rel_obj IN OUT NOCOPY HZ_RELATIONSHIP_OBJ,
79 p_created_by_module IN VARCHAR2,
80 x_relationship_id OUT NOCOPY NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2
84 );
85
86 PROCEDURE update_relationship_obj(
87 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
88 p_rel_obj IN OUT NOCOPY HZ_RELATIONSHIP_OBJ,
89 x_relationship_id OUT NOCOPY NUMBER,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95 PROCEDURE save_relationship_obj(
96 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
97 p_rel_obj IN OUT NOCOPY HZ_RELATIONSHIP_OBJ,
98 p_created_by_module IN VARCHAR2,
99 x_relationship_id OUT NOCOPY NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 -- PROCEDURE save_relationships
106 --
107 -- DESCRIPTION
108 -- Create or update relationships.
109 --
110 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
111 --
112 -- ARGUMENTS
113 -- IN:
114 -- p_rel_objs List of relationship objects.
115 -- p_subject_id Subject Id.
116 -- p_subject_type Subject type.
117 -- OUT:
118 -- x_return_status Return status after the call. The status can
119 -- be fnd_api.g_ret_sts_success (success),
120 -- fnd_api.g_ret_sts_error (error),
121 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
122 -- x_msg_count Number of messages in message stack.
123 -- x_msg_data Message text if x_msg_count is 1.
124 --
125 -- NOTES
126 --
127 -- MODIFICATION HISTORY
128 --
129 -- 14-DEC-2004 Arnold Ng Created.
130 --
131
132 PROCEDURE save_relationships(
133 p_rel_objs IN OUT NOCOPY HZ_RELATIONSHIP_OBJ_TBL,
134 p_subject_id IN NUMBER,
135 p_subject_type IN VARCHAR2,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2
139 );
140
141 -- PROCEDURE get_relationship_obj
142 --
143 -- DESCRIPTION
144 -- Get relationship.
145 --
146 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
147 --
148 -- ARGUMENTS
149 -- IN:
150 -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
151 -- p_relationship_id Relationship Id.
152 -- OUT:
153 -- x_relationship_obj Relationship object.
154 -- x_return_status Return status after the call. The status can
155 -- be fnd_api.g_ret_sts_success (success),
156 -- fnd_api.g_ret_sts_error (error),
157 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
158 -- x_msg_count Number of messages in message stack.
159 -- x_msg_data Message text if x_msg_count is 1.
160 --
161 -- NOTES
162 --
163 -- MODIFICATION HISTORY
164 --
165 -- 14-DEC-2004 Arnold Ng Created.
166 --
167
168 PROCEDURE get_relationship_obj(
169 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170 p_relationship_id IN NUMBER,
171 x_relationship_obj OUT NOCOPY HZ_RELATIONSHIP_OBJ,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2
175 );
176
177 -- PROCEDURE create_classifications
178 --
179 -- DESCRIPTION
180 -- Create classifications.
181 --
182 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
183 --
184 -- ARGUMENTS
185 -- IN:
186 -- p_code_assign_objs List of classification objects.
187 -- p_owner_table_name Owner table name.
188 -- p_owner_table_id Owner table Id.
189 -- OUT:
190 -- x_return_status Return status after the call. The status can
191 -- be fnd_api.g_ret_sts_success (success),
192 -- fnd_api.g_ret_sts_error (error),
193 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
194 -- x_msg_count Number of messages in message stack.
195 -- x_msg_data Message text if x_msg_count is 1.
196 --
197 -- NOTES
198 --
199 -- MODIFICATION HISTORY
200 --
201 -- 14-DEC-2004 Arnold Ng Created.
202 --
203
204 PROCEDURE create_classifications(
205 p_code_assign_objs IN OUT NOCOPY HZ_CODE_ASSIGNMENT_OBJ_TBL,
206 p_owner_table_name IN VARCHAR2,
207 p_owner_table_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_classifications
214 --
215 -- DESCRIPTION
216 -- Create or update classifications.
217 --
218 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
219 --
220 -- ARGUMENTS
221 -- IN:
222 -- p_code_assign_objs List of classification objects.
223 -- p_owner_table_name Owner table name.
224 -- p_owner_table_id Owner table Id.
225 -- OUT:
226 -- x_return_status Return status after the call. The status can
227 -- be fnd_api.g_ret_sts_success (success),
228 -- fnd_api.g_ret_sts_error (error),
229 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
230 -- x_msg_count Number of messages in message stack.
231 -- x_msg_data Message text if x_msg_count is 1.
232 --
233 -- NOTES
234 --
235 -- MODIFICATION HISTORY
236 --
237 -- 14-DEC-2004 Arnold Ng Created.
238 --
239
240 PROCEDURE save_classifications(
241 p_code_assign_objs IN OUT NOCOPY HZ_CODE_ASSIGNMENT_OBJ_TBL,
242 p_owner_table_name IN VARCHAR2,
243 p_owner_table_id IN NUMBER,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2
247 );
248
249 -- PROCEDURE create_certifications
250 --
251 -- DESCRIPTION
252 -- Create certifications.
253 --
254 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
255 --
256 -- ARGUMENTS
257 -- IN:
258 -- p_cert_objs List of certification objects.
259 -- p_party_id Party Id.
260 -- OUT:
261 -- x_return_status Return status after the call. The status can
262 -- be fnd_api.g_ret_sts_success (success),
263 -- fnd_api.g_ret_sts_error (error),
264 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
265 -- x_msg_count Number of messages in message stack.
266 -- x_msg_data Message text if x_msg_count is 1.
267 --
268 -- NOTES
269 --
270 -- MODIFICATION HISTORY
271 --
272 -- 14-DEC-2004 Arnold Ng Created.
273 --
274
275 PROCEDURE create_certifications(
276 p_cert_objs IN OUT NOCOPY hz_certification_obj_tbl,
277 p_party_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 save_certifications
284 --
285 -- DESCRIPTION
286 -- Create or update certifications.
287 --
288 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
289 --
290 -- ARGUMENTS
291 -- IN:
292 -- p_cert_objs List of certification objects.
293 -- p_party_id Party Id.
294 -- OUT:
295 -- x_return_status Return status after the call. The status can
296 -- be fnd_api.g_ret_sts_success (success),
297 -- fnd_api.g_ret_sts_error (error),
298 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
299 -- x_msg_count Number of messages in message stack.
300 -- x_msg_data Message text if x_msg_count is 1.
301 --
302 -- NOTES
303 --
304 -- MODIFICATION HISTORY
305 --
306 -- 14-DEC-2004 Arnold Ng Created.
307 --
308
309 PROCEDURE save_certifications(
310 p_cert_objs IN OUT NOCOPY hz_certification_obj_tbl,
311 p_party_id IN NUMBER,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2
315 );
316
317 -- PROCEDURE create_financial_profiles
318 --
319 -- DESCRIPTION
320 -- Create financial profiles.
321 --
322 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
323 --
324 -- ARGUMENTS
325 -- IN:
326 -- p_fin_prof_objs List of financial profile objects.
327 -- p_party_id Party Id.
328 -- OUT:
329 -- x_return_status Return status after the call. The status can
330 -- be fnd_api.g_ret_sts_success (success),
331 -- fnd_api.g_ret_sts_error (error),
332 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
333 -- x_msg_count Number of messages in message stack.
334 -- x_msg_data Message text if x_msg_count is 1.
335 --
336 -- NOTES
337 --
338 -- MODIFICATION HISTORY
339 --
340 -- 14-DEC-2004 Arnold Ng Created.
341 --
342
343 PROCEDURE create_financial_profiles(
344 p_fin_prof_objs IN OUT NOCOPY hz_financial_prof_obj_tbl,
345 p_party_id IN NUMBER,
346 x_return_status OUT NOCOPY VARCHAR2,
347 x_msg_count OUT NOCOPY NUMBER,
348 x_msg_data OUT NOCOPY VARCHAR2
349 );
350
351 -- PROCEDURE save_financial_profiles
352 --
353 -- DESCRIPTION
354 -- Create or update financial profiles.
355 --
356 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
357 --
358 -- ARGUMENTS
359 -- IN:
360 -- p_fin_prof_objs List of financial profile objects.
361 -- p_party_id Party Id.
362 -- OUT:
363 -- x_return_status Return status after the call. The status can
364 -- be fnd_api.g_ret_sts_success (success),
365 -- fnd_api.g_ret_sts_error (error),
366 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
367 -- x_msg_count Number of messages in message stack.
368 -- x_msg_data Message text if x_msg_count is 1.
369 --
370 -- NOTES
371 --
372 -- MODIFICATION HISTORY
373 --
374 -- 14-DEC-2004 Arnold Ng Created.
375 --
376
377 PROCEDURE save_financial_profiles(
378 p_fin_prof_objs IN OUT NOCOPY hz_financial_prof_obj_tbl,
379 p_party_id IN NUMBER,
380 x_return_status OUT NOCOPY VARCHAR2,
381 x_msg_count OUT NOCOPY NUMBER,
382 x_msg_data OUT NOCOPY VARCHAR2
383 );
384
385
386 -- PROCEDURE create_party_usage_assgmnt
387 --
388 -- DESCRIPTION
389 -- Create Party Usage Assignment.
390 --
391 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
392 --
393 -- ARGUMENTS
394 -- IN:
395 -- p_party_usg_objs List of Party Usage objects.
396 -- p_party_id Party Id.
397 -- OUT:
398 -- x_return_status Return status after the call. The status can
399 -- be fnd_api.g_ret_sts_success (success),
400 -- fnd_api.g_ret_sts_error (error),
401 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
402 -- x_msg_count Number of messages in message stack.
403 -- x_msg_data Message text if x_msg_count is 1.
404 --
405 -- NOTES
406 --
407 -- MODIFICATION HISTORY
408 --
412
409 -- 01-Mar-2006 Hadi Alatasi Created.
410 --
411
413 PROCEDURE create_party_usage_assgmnt(
414 p_party_usg_objs IN OUT NOCOPY HZ_PARTY_USAGE_OBJ_TBL,
415 p_party_id IN NUMBER,
416 x_return_status OUT NOCOPY VARCHAR2,
417 x_msg_count OUT NOCOPY NUMBER,
418 x_msg_data OUT NOCOPY VARCHAR2
419 );
420
421 -- PROCEDURE Save_party_usage_assgmnt
422 --
423 -- DESCRIPTION
424 -- Create or update Party Usage Assignment.
425 --
426 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
427 --
428 -- ARGUMENTS
429 -- IN:
430 -- p_party_usg_objs List of Party Usage objects.
431 -- p_party_id Party Id.
432 -- OUT:
433 -- x_return_status Return status after the call. The status can
434 -- be fnd_api.g_ret_sts_success (success),
435 -- fnd_api.g_ret_sts_error (error),
436 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
437 -- x_msg_count Number of messages in message stack.
438 -- x_msg_data Message text if x_msg_count is 1.
439 --
440 -- NOTES
441 --
442 -- MODIFICATION HISTORY
443 --
444 -- 01-Mar-2006 Hadi Alatasi Created.
445 --
446
447 PROCEDURE save_party_usage_assgmnt(
448 p_party_usg_objs IN OUT NOCOPY HZ_PARTY_USAGE_OBJ_TBL,
449 p_party_id IN NUMBER,
450 x_return_status OUT NOCOPY VARCHAR2,
451 x_msg_count OUT NOCOPY NUMBER,
452 x_msg_data OUT NOCOPY VARCHAR2
453 );
454
455
456 -- PROCEDURE call_bes
457 --
458 -- DESCRIPTION
459 -- Call business event. This procedure will be called from
460 -- Organization, Organization Customer, Person, Person Customer
461 -- BO API.
462 --
463 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
464 --
465 -- ARGUMENTS
466 -- IN:
467 -- p_party_id Party Id.
468 -- p_bo_code Business Object Code.
469 -- p_create_or_update Create or Update Flag.
470 -- p_event_id Business event ID.
471 -- NOTES
472 --
473 -- MODIFICATION HISTORY
474 --
475 -- 04-OCT-2005 Arnold Ng Created.
476 -- 15-DEC-2005 Arnold Ng Add p_event_id.
477 --
478
479 PROCEDURE call_bes(
480 p_party_id IN NUMBER,
481 p_bo_code IN VARCHAR2,
482 p_create_or_update IN VARCHAR2,
483 p_obj_source IN VARCHAR2,
484 p_event_id IN NUMBER
485 );
486
487 -- FUNCTION is_raising_create_event
488 --
489 -- DESCRIPTION
490 -- Return true if raise BES event per object.
491 --
492 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
493 --
494 -- ARGUMENTS
495 -- IN:
496 -- p_obj_complete_flag Flag indicates if object is complete
497 -- NOTES
498 --
499 -- MODIFICATION HISTORY
500 --
501 -- 04-OCT-2005 Arnold Ng Created.
502 --
503
504 FUNCTION is_raising_create_event(
505 p_obj_complete_flag IN BOOLEAN
506 ) RETURN BOOLEAN;
507
508 -- PROCEDURE is_raising_update_event
509 --
510 -- DESCRIPTION
511 -- Return true if BO_VERSION number for party record is same as
512 -- HZ_BUS_OBJ_DEFINITIONS table for a particular business object
513 --
514 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
515 --
516 -- ARGUMENTS
517 -- IN:
518 -- p_party_id Party Id.
519 -- p_bo_code Business object code.
520 -- NOTES
521 --
522 -- MODIFICATION HISTORY
523 --
524 -- 04-OCT-2005 Arnold Ng Created.
525 --
526
527 FUNCTION is_raising_update_event(
528 p_party_id IN NUMBER,
529 p_bo_code IN VARCHAR2
530 ) RETURN BOOLEAN;
531
532 FUNCTION return_all_messages(
533 x_return_status IN VARCHAR2,
534 x_msg_count IN NUMBER,
535 x_msg_data IN VARCHAR2
536 ) RETURN HZ_MESSAGE_OBJ_TBL;
537
538 END HZ_PARTY_BO_PVT;