1 PACKAGE HZ_CONTACT_POINT_BO_PUB AS
2 /*$Header: ARHBCPBS.pls 120.9 2006/09/22 00:33:57 acng noship $ */
3 /*#
4 * Contact Point Business Object API
5 * Public API that allows users to manage Phone, Email, Web, SMS, Telex, EDI and EFT business objects in the
6 * Trading Community Architecture. Several operations are supported, including the creation and update of the
7 * business object.
8 *
9 * @rep:scope public
10 * @rep:product HZ
11 * @rep:lifecycle active
12 * @rep:category BUSINESS_ENTITY HZ_CONTACT_POINT
13 * @rep:displayname Contact Point Business Object API
14 * @rep:doccd 120hztig.pdf Phone Business Object API, Oracle Trading Community Architecture Technical Implementation Guide
15 */
16
17 -- PROCEDURE create_phone_bo
18 --
19 -- DESCRIPTION
20 -- Create a logical phone contact point.
21 --
22 -- ARGUMENTS
23 -- IN:
24 -- p_init_msg_list Initialize message stack if it is set to
25 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
26 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
27 -- the completeness of business object.
28 -- p_phone_obj Phone business object.
29 -- p_created_by_module Created by module.
30 -- IN/OUT:
31 -- px_parent_id Parent record ID.
32 -- px_parent_os Parent orig system.
33 -- px_parent_osr Parent orig system reference.
34 -- px_parent_obj_type Parent object type.
35 -- OUT:
36 -- x_return_status Return status after the call. The status can
37 -- be fnd_api.g_ret_sts_success (success),
38 -- fnd_api.g_ret_sts_error (error),
39 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
40 -- x_msg_count Number of messages in message stack.
41 -- x_msg_data Message text if x_msg_count is 1.
42 -- x_phone_id Contact point ID.
43 -- x_phone_os Contact point orig system.
44 -- x_phone_osr Contact point orig system reference.
45 --
46 -- NOTES
47 --
48 -- MODIFICATION HISTORY
49 --
50 -- 14-DEC-2004 Arnold Ng Created.
51
52 PROCEDURE create_phone_bo(
53 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
54 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
55 p_phone_obj IN HZ_PHONE_CP_BO,
56 p_created_by_module IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 x_phone_id OUT NOCOPY NUMBER,
61 x_phone_os OUT NOCOPY VARCHAR2,
62 x_phone_osr OUT NOCOPY VARCHAR2,
63 px_parent_id IN OUT NOCOPY NUMBER,
67 );
64 px_parent_os IN OUT NOCOPY VARCHAR2,
65 px_parent_osr IN OUT NOCOPY VARCHAR2,
66 px_parent_obj_type IN OUT NOCOPY VARCHAR2
68
69 /*#
70 * Create Phone Business Object (create_phone_cp_bo)
71 * Creates a Phone business object. You pass object data to the procedure, packaged within an object type defined
72 * specifically for the API. The object type is HZ_PHONE_CP_BO for the Phone business object. In addition to the
73 * object's business object attributes, the object type also includes lower-level embedded child entities or objects
74 * that can be simultaneously created.
75 *
76 * @param p_return_obj_flag Indicates if the created object is to be returned to the caller as an output parameter. Default value: false
77 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness. Default value: true
78 * @param p_phone_obj The Phone business object to be created in its entirety
79 * @param p_created_by_module The module creating this business object. Must be a valid created_by_module value
80 * @param p_obj_source The source of this business object
81 * @param x_return_status Return status after the call
82 * @param x_return_obj The Phone business object that was created, returned as an output parameter
83 * @param x_messages Messages returned from the creation of the business object
84 * @param x_phone_id TCA identifier for the Phone business object
85 * @param x_phone_os Phone original system name
86 * @param x_phone_osr Phone original system reference
87 * @param px_parent_id TCA identifier for parent object. Either this parameter or both the px_parent_os and px_parent_osr parameters must be given
88 * @param px_parent_os Parent object original system name
89 * @param px_parent_osr Parent object original system reference
90 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
91 * @rep:scope public
92 * @rep:lifecycle active
93 * @rep:displayname Create Phone Business Object
94 * @rep:doccd 120hztig.pdf Create Phone Business Object, Oracle Trading Community Architecture Technical Implementation Guide
95 */
96 PROCEDURE create_phone_bo(
97 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
98 p_phone_obj IN HZ_PHONE_CP_BO,
99 p_created_by_module IN VARCHAR2,
100 p_obj_source IN VARCHAR2 := null,
101 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
104 x_return_obj OUT NOCOPY HZ_PHONE_CP_BO,
105 x_phone_id OUT NOCOPY NUMBER,
106 x_phone_os OUT NOCOPY VARCHAR2,
107 x_phone_osr OUT NOCOPY VARCHAR2,
108 px_parent_id IN OUT NOCOPY NUMBER,
109 px_parent_os IN OUT NOCOPY VARCHAR2,
110 px_parent_osr IN OUT NOCOPY VARCHAR2,
111 px_parent_obj_type IN OUT NOCOPY VARCHAR2
112 );
113
114 -- PROCEDURE create_telex_bo
115 --
116 -- DESCRIPTION
117 -- Create a logical telex contact point.
118 --
119 -- ARGUMENTS
120 -- IN:
121 -- p_init_msg_list Initialize message stack if it is set to
122 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
123 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
124 -- the completeness of business object.
125 -- p_telex_obj Telex business object.
126 -- p_created_by_module Created by module.
127 -- IN/OUT:
128 -- px_parent_id Parent record ID.
129 -- px_parent_os Parent orig system.
130 -- px_parent_osr Parent orig system reference.
131 -- px_parent_obj_type Parent object type.
132 -- OUT:
133 -- x_return_status Return status after the call. The status can
134 -- be fnd_api.g_ret_sts_success (success),
135 -- fnd_api.g_ret_sts_error (error),
136 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
137 -- x_msg_count Number of messages in message stack.
138 -- x_msg_data Message text if x_msg_count is 1.
139 -- x_telex_id Contact point ID.
140 -- x_telex_os Contact point orig system.
141 -- x_telex_osr Contact point orig system reference.
142 --
143 -- NOTES
144 --
145 -- MODIFICATION HISTORY
146 --
147 -- 14-DEC-2004 Arnold Ng Created.
148
149 PROCEDURE create_telex_bo(
150 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
152 p_telex_obj IN HZ_TELEX_CP_BO,
153 p_created_by_module IN VARCHAR2,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 x_telex_id OUT NOCOPY NUMBER,
158 x_telex_os OUT NOCOPY VARCHAR2,
159 x_telex_osr OUT NOCOPY VARCHAR2,
160 px_parent_id IN OUT NOCOPY NUMBER,
161 px_parent_os IN OUT NOCOPY VARCHAR2,
162 px_parent_osr IN OUT NOCOPY VARCHAR2,
163 px_parent_obj_type IN OUT NOCOPY VARCHAR2
164 );
165
166 /*#
167 * Create Telex Business Object (create_telex_bo)
168 * Creates a Telex business object. You pass object data to the procedure, packaged within an object type defined
169 * specifically for the API. The object type is HZ_TELEX_CP_BO for the Telex business object. In addition to the
173 * @param p_return_obj_flag Indicates if the created object is to be returned to the caller as an output parameter. Default value: false
170 * object's business object attributes, the object type also includes lower-level embedded child entities or objects
171 * that can be simultaneously created.
172 *
174 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness. Default value: true
175 * @param p_telex_obj The Telex business object to be created in its entirety
176 * @param p_created_by_module The module creating this business object. Must be a valid created_by_module value
177 * @param p_obj_source The source of this business object
178 * @param x_return_status Return status after the call
179 * @param x_return_obj The Telex business object that was created, returned as an output parameter
180 * @param x_messages Messages returned from the creation of the business object
181 * @param x_telex_id TCA identifier for the Telex business object
182 * @param x_telex_os Telex original system name
183 * @param x_telex_osr Telex original system reference
184 * @param px_parent_id TCA identifier for parent object. Either this parameter or both the px_parent_os and px_parent_osr parameters must be given
190 * @rep:displayname Create Telex Business Object
185 * @param px_parent_os Parent object original system name
186 * @param px_parent_osr Parent object original system reference
187 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
188 * @rep:scope public
189 * @rep:lifecycle active
191 * @rep:doccd 120hztig.pdf Create Telex Business Object, Oracle Trading Community Architecture Technical Implementation Guide
192 */
193 PROCEDURE create_telex_bo(
194 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
195 p_telex_obj IN HZ_TELEX_CP_BO,
196 p_created_by_module IN VARCHAR2,
197 p_obj_source IN VARCHAR2 := null,
198 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
201 x_return_obj OUT NOCOPY HZ_TELEX_CP_BO,
202 x_telex_id OUT NOCOPY NUMBER,
203 x_telex_os OUT NOCOPY VARCHAR2,
204 x_telex_osr OUT NOCOPY VARCHAR2,
205 px_parent_id IN OUT NOCOPY NUMBER,
206 px_parent_os IN OUT NOCOPY VARCHAR2,
207 px_parent_osr IN OUT NOCOPY VARCHAR2,
208 px_parent_obj_type IN OUT NOCOPY VARCHAR2
209 );
210
211 -- PROCEDURE create_email_bo
212 --
213 -- DESCRIPTION
214 -- Create a logical email contact point.
215 --
216 -- ARGUMENTS
217 -- IN:
218 -- p_init_msg_list Initialize message stack if it is set to
219 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
220 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
221 -- the completeness of business object.
222 -- p_email_obj Email business object.
223 -- p_created_by_module Created by module.
224 -- IN/OUT:
225 -- px_parent_id Parent record ID.
226 -- px_parent_os Parent orig system.
227 -- px_parent_osr Parent orig system reference.
228 -- px_parent_obj_type Parent object type.
229 -- OUT:
230 -- x_return_status Return status after the call. The status can
231 -- be fnd_api.g_ret_sts_success (success),
232 -- fnd_api.g_ret_sts_error (error),
233 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
234 -- x_msg_count Number of messages in message stack.
235 -- x_msg_data Message text if x_msg_count is 1.
236 -- x_email_id Contact point ID.
237 -- x_email_os Contact point orig system.
238 -- x_email_osr Contact point orig system reference.
239 --
240 -- NOTES
241 --
242 -- MODIFICATION HISTORY
243 --
244 -- 14-DEC-2004 Arnold Ng Created.
245
246 PROCEDURE create_email_bo(
247 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
248 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
249 p_email_obj IN HZ_EMAIL_CP_BO,
250 p_created_by_module IN VARCHAR2,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254 x_email_id OUT NOCOPY NUMBER,
255 x_email_os OUT NOCOPY VARCHAR2,
256 x_email_osr OUT NOCOPY VARCHAR2,
257 px_parent_id IN OUT NOCOPY NUMBER,
258 px_parent_os IN OUT NOCOPY VARCHAR2,
259 px_parent_osr IN OUT NOCOPY VARCHAR2,
260 px_parent_obj_type IN OUT NOCOPY VARCHAR2
261 );
262
263 /*#
264 * Create Email Business Object (create_email_bo)
265 * Creates a Email business object. You pass object data to the procedure, packaged within an object type defined
266 * specifically for the API. The object type is HZ_EMIAL_CP_BO for the Email business object. In addition to the
267 * object's business object attributes, the object type also includes lower-level embedded child entities or objects
268 * that can be simultaneously created.
269 *
270 * @param p_return_obj_flag Indicates if the created object is to be returned to the caller as an output parameter. Default value: false
271 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness. Default value: true
272 * @param p_email_obj The Email business object to be created in its entirety
273 * @param p_created_by_module The module creating this business object. Must be a valid created_by_module value
274 * @param p_obj_source The source of this business object
275 * @param x_return_status Return status after the call
276 * @param x_return_obj The Email business object that was created, returned as an output parameter
277 * @param x_messages Messages returned from the creation of the business object
278 * @param x_email_id TCA identifier for the Email business object
279 * @param x_email_os Email original system name
280 * @param x_email_osr Email original system reference
281 * @param px_parent_id TCA identifier for parent object. Either this parameter or both the px_parent_os and px_parent_osr parameters must be given
282 * @param px_parent_os Parent object original system name
283 * @param px_parent_osr Parent object original system reference
284 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
285 * @rep:scope public
286 * @rep:lifecycle active
287 * @rep:displayname Create Email Business Object
288 * @rep:doccd 120hztig.pdf Create Email Business Object, Oracle Trading Community Architecture Technical Implementation Guide
289 */
290 PROCEDURE create_email_bo(
291 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
292 p_email_obj IN HZ_EMAIL_CP_BO,
293 p_created_by_module IN VARCHAR2,
294 p_obj_source IN VARCHAR2 := null,
298 x_return_obj OUT NOCOPY HZ_EMAIL_CP_BO,
295 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
299 x_email_id OUT NOCOPY NUMBER,
300 x_email_os OUT NOCOPY VARCHAR2,
301 x_email_osr OUT NOCOPY VARCHAR2,
302 px_parent_id IN OUT NOCOPY NUMBER,
303 px_parent_os IN OUT NOCOPY VARCHAR2,
304 px_parent_osr IN OUT NOCOPY VARCHAR2,
305 px_parent_obj_type IN OUT NOCOPY VARCHAR2
306 );
307
308 -- PROCEDURE create_web_bo
309 --
310 -- DESCRIPTION
311 -- Create a logical web contact point.
312 --
313 -- ARGUMENTS
314 -- IN:
315 -- p_init_msg_list Initialize message stack if it is set to
316 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
317 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
318 -- the completeness of business object.
319 -- p_web_obj Web business object.
320 -- p_created_by_module Created by module.
321 -- IN/OUT:
322 -- px_parent_id Parent record ID.
323 -- px_parent_os Parent orig system.
324 -- px_parent_osr Parent orig system reference.
325 -- px_parent_obj_type Parent object type.
326 -- OUT:
327 -- x_return_status Return status after the call. The status can
328 -- be fnd_api.g_ret_sts_success (success),
329 -- fnd_api.g_ret_sts_error (error),
330 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
331 -- x_msg_count Number of messages in message stack.
332 -- x_msg_data Message text if x_msg_count is 1.
333 -- x_web_id Contact point ID.
334 -- x_web_os Contact point orig system.
335 -- x_web_osr Contact point orig system reference.
336 --
337 -- NOTES
338 --
339 -- MODIFICATION HISTORY
340 --
341 -- 14-DEC-2004 Arnold Ng Created.
342
343 PROCEDURE create_web_bo(
344 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
345 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
346 p_web_obj IN HZ_WEB_CP_BO,
347 p_created_by_module IN VARCHAR2,
348 x_return_status OUT NOCOPY VARCHAR2,
349 x_msg_count OUT NOCOPY NUMBER,
350 x_msg_data OUT NOCOPY VARCHAR2,
354 px_parent_id IN OUT NOCOPY NUMBER,
351 x_web_id OUT NOCOPY NUMBER,
352 x_web_os OUT NOCOPY VARCHAR2,
353 x_web_osr OUT NOCOPY VARCHAR2,
355 px_parent_os IN OUT NOCOPY VARCHAR2,
356 px_parent_osr IN OUT NOCOPY VARCHAR2,
357 px_parent_obj_type IN OUT NOCOPY VARCHAR2
358 );
359
360 /*#
361 * Create Web Business Object (create_web_bo)
362 * Creates a Web business object. You pass object data to the procedure, packaged within an object type defined
363 * specifically for the API. The object type is HZ_WEB_CP_BO for the Web business object. In addition to the object's
364 * business object attributes, the object type also includes lower-level embedded child entities or objects that can
365 * be simultaneously created.
366 *
367 * @param p_return_obj_flag Indicates if the created object is to be returned to the caller as an output parameter. Default value: false
368 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness. Default value: true
369 * @param p_web_obj The Web business object to be created in its entirety
370 * @param p_created_by_module The module creating this business object. Must be a valid created_by_module value
371 * @param p_obj_source The source of this business object
372 * @param x_return_status Return status after the call
373 * @param x_return_obj The Web business object that was created, returned as an output parameter
374 * @param x_messages Messages returned from the creation of the business object
375 * @param x_web_id TCA identifier for the Web business object
376 * @param x_web_os Web original system name
377 * @param x_web_osr Web original system reference
378 * @param px_parent_id TCA identifier for parent object. Either this parameter or both the px_parent_os and px_parent_osr parameters must be given
379 * @param px_parent_os Parent object original system name
380 * @param px_parent_osr Parent object original system reference
381 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
382 * @rep:scope public
383 * @rep:lifecycle active
384 * @rep:displayname Create Web Business Object
385 * @rep:doccd 120hztig.pdf Create Web Business Object, Oracle Trading Community Architecture Technical Implementation Guide
386 */
387 PROCEDURE create_web_bo(
388 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
389 p_web_obj IN HZ_WEB_CP_BO,
390 p_created_by_module IN VARCHAR2,
391 p_obj_source IN VARCHAR2 := null,
392 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
393 x_return_status OUT NOCOPY VARCHAR2,
394 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
395 x_return_obj OUT NOCOPY HZ_WEB_CP_BO,
396 x_web_id OUT NOCOPY NUMBER,
397 x_web_os OUT NOCOPY VARCHAR2,
398 x_web_osr OUT NOCOPY VARCHAR2,
399 px_parent_id IN OUT NOCOPY NUMBER,
400 px_parent_os IN OUT NOCOPY VARCHAR2,
401 px_parent_osr IN OUT NOCOPY VARCHAR2,
402 px_parent_obj_type IN OUT NOCOPY VARCHAR2
403 );
404
405 -- PROCEDURE create_edi_bo
406 --
407 -- DESCRIPTION
408 -- Create a logical edi contact point.
409 --
410 -- ARGUMENTS
411 -- IN:
412 -- p_init_msg_list Initialize message stack if it is set to
413 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
414 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
415 -- the completeness of business object.
416 -- p_edi_obj EDI business object.
417 -- p_created_by_module Created by module.
418 -- IN/OUT:
419 -- px_parent_id Parent record ID.
420 -- px_parent_os Parent orig system.
421 -- px_parent_osr Parent orig system reference.
422 -- px_parent_obj_type Parent object type.
423 -- OUT:
424 -- x_return_status Return status after the call. The status can
425 -- be fnd_api.g_ret_sts_success (success),
426 -- fnd_api.g_ret_sts_error (error),
427 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
428 -- x_msg_count Number of messages in message stack.
429 -- x_msg_data Message text if x_msg_count is 1.
430 -- x_edi_id Contact point ID.
431 -- x_edi_os Contact point orig system.
432 -- x_edi_osr Contact point orig system reference.
433 --
434 -- NOTES
435 --
436 -- MODIFICATION HISTORY
437 --
438 -- 14-DEC-2004 Arnold Ng Created.
439
440 PROCEDURE create_edi_bo(
441 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
442 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
443 p_edi_obj IN HZ_EDI_CP_BO,
444 p_created_by_module IN VARCHAR2,
445 x_return_status OUT NOCOPY VARCHAR2,
446 x_msg_count OUT NOCOPY NUMBER,
447 x_msg_data OUT NOCOPY VARCHAR2,
448 x_edi_id OUT NOCOPY NUMBER,
449 x_edi_os OUT NOCOPY VARCHAR2,
450 x_edi_osr OUT NOCOPY VARCHAR2,
451 px_parent_id IN OUT NOCOPY NUMBER,
452 px_parent_os IN OUT NOCOPY VARCHAR2,
453 px_parent_osr IN OUT NOCOPY VARCHAR2,
454 px_parent_obj_type IN OUT NOCOPY VARCHAR2
455 );
456
457 /*#
458 * Create EDI Business Object (create_edi_bo)
462 * be simultaneously created.
459 * Creates a EDI business object. You pass object data to the procedure, packaged within an object type defined
460 * specifically for the API. The object type is HZ_EDI_CP_BO for the EDI business object. In addition to the object's
461 * business object attributes, the object type also includes lower-level embedded child entities or objects that can
463 *
464 * @param p_return_obj_flag Indicates if the created object is to be returned to the caller as an output parameter. Default value: false
468 * @param p_obj_source The source of this business object
465 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness. Default value: true
466 * @param p_edi_obj The EDI business object to be created in its entirety
467 * @param p_created_by_module The module creating this business object. Must be a valid created_by_module value
469 * @param x_return_status Return status after the call
470 * @param x_return_obj The EDI business object that was created, returned as an output parameter
471 * @param x_messages Messages returned from the creation of the business object
472 * @param x_edi_id TCA identifier for the EDI business object
473 * @param x_edi_os EDI original system name
474 * @param x_edi_osr EDI original system reference
475 * @param px_parent_id TCA identifier for parent object. Either this parameter or both the px_parent_os and px_parent_osr parameters must be given
476 * @param px_parent_os Parent object original system name
477 * @param px_parent_osr Parent object original system reference
478 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
479 * @rep:scope public
480 * @rep:lifecycle active
481 * @rep:displayname Create EDI Business Object
482 * @rep:doccd 120hztig.pdf Create EDI Business Object, Oracle Trading Community Architecture Technical Implementation Guide
483 */
484 PROCEDURE create_edi_bo(
485 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
486 p_edi_obj IN HZ_EDI_CP_BO,
487 p_created_by_module IN VARCHAR2,
488 p_obj_source IN VARCHAR2 := null,
489 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
490 x_return_status OUT NOCOPY VARCHAR2,
491 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
492 x_return_obj OUT NOCOPY HZ_EDI_CP_BO,
493 x_edi_id OUT NOCOPY NUMBER,
494 x_edi_os OUT NOCOPY VARCHAR2,
495 x_edi_osr OUT NOCOPY VARCHAR2,
496 px_parent_id IN OUT NOCOPY NUMBER,
497 px_parent_os IN OUT NOCOPY VARCHAR2,
498 px_parent_osr IN OUT NOCOPY VARCHAR2,
499 px_parent_obj_type IN OUT NOCOPY VARCHAR2
500 );
501
502 -- PROCEDURE create_eft_bo
503 --
504 -- DESCRIPTION
505 -- Create a logical eft contact point.
506 --
507 -- ARGUMENTS
508 -- IN:
509 -- p_init_msg_list Initialize message stack if it is set to
510 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
511 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
512 -- the completeness of business object.
513 -- p_eft_obj EFT business object.
514 -- p_created_by_module Created by module.
515 -- IN/OUT:
516 -- px_parent_id Parent record ID.
517 -- px_parent_os Parent orig system.
518 -- px_parent_osr Parent orig system reference.
519 -- px_parent_obj_type Parent object type.
520 -- OUT:
521 -- x_return_status Return status after the call. The status can
522 -- be fnd_api.g_ret_sts_success (success),
523 -- fnd_api.g_ret_sts_error (error),
524 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
528 -- x_eft_os Contact point orig system.
525 -- x_msg_count Number of messages in message stack.
526 -- x_msg_data Message text if x_msg_count is 1.
527 -- x_eft_id Contact point ID.
529 -- x_eft_osr Contact point orig system reference.
530 --
531 -- NOTES
532 --
533 -- MODIFICATION HISTORY
534 --
535 -- 14-DEC-2004 Arnold Ng Created.
536
537 PROCEDURE create_eft_bo(
538 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
539 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
540 p_eft_obj IN HZ_EFT_CP_BO,
541 p_created_by_module IN VARCHAR2,
542 x_return_status OUT NOCOPY VARCHAR2,
543 x_msg_count OUT NOCOPY NUMBER,
544 x_msg_data OUT NOCOPY VARCHAR2,
545 x_eft_id OUT NOCOPY NUMBER,
546 x_eft_os OUT NOCOPY VARCHAR2,
547 x_eft_osr OUT NOCOPY VARCHAR2,
548 px_parent_id IN OUT NOCOPY NUMBER,
549 px_parent_os IN OUT NOCOPY VARCHAR2,
550 px_parent_osr IN OUT NOCOPY VARCHAR2,
551 px_parent_obj_type IN OUT NOCOPY VARCHAR2
552 );
553
554 /*#
555 * Create EFT Business Object (create_eft_bo)
556 * Creates a EFT business object. You pass object data to the procedure, packaged within an object type defined
557 * specifically for the API. The object type is HZ_EFT_CP_BO for the EFT business object. In addition to the object's
558 * business object attributes, the object type also includes lower-level embedded child entities or objects that can
559 * be simultaneously created.
560 *
561 * @param p_return_obj_flag Indicates if the created object is to be returned to the caller as an output parameter. Default value: false
562 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness. Default value: true
563 * @param p_eft_obj The EFT business object to be created in its entirety
564 * @param p_created_by_module The module creating this business object. Must be a valid created_by_module value
565 * @param p_obj_source The source of this business object
566 * @param x_return_status Return status after the call
567 * @param x_return_obj The EFT business object that was created, returned as an output parameter
568 * @param x_messages Messages returned from the creation of the business object
569 * @param x_eft_id TCA identifier for the EFT business object
570 * @param x_eft_os EFT original system name
571 * @param x_eft_osr EFT original system reference
572 * @param px_parent_id TCA identifier for parent object. Either this parameter or both the px_parent_os and px_parent_osr parameters must be given
573 * @param px_parent_os Parent object original system name
574 * @param px_parent_osr Parent object original system reference
575 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
576 * @rep:scope public
577 * @rep:lifecycle active
578 * @rep:displayname Create EFT Business Object
579 * @rep:doccd 120hztig.pdf Create EFT Business Object, Oracle Trading Community Architecture Technical Implementation Guide
580 */
581 PROCEDURE create_eft_bo(
582 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
583 p_eft_obj IN HZ_EFT_CP_BO,
584 p_created_by_module IN VARCHAR2,
585 p_obj_source IN VARCHAR2 := null,
586 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
587 x_return_status OUT NOCOPY VARCHAR2,
588 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
589 x_return_obj OUT NOCOPY HZ_EFT_CP_BO,
590 x_eft_id OUT NOCOPY NUMBER,
591 x_eft_os OUT NOCOPY VARCHAR2,
592 x_eft_osr OUT NOCOPY VARCHAR2,
593 px_parent_id IN OUT NOCOPY NUMBER,
594 px_parent_os IN OUT NOCOPY VARCHAR2,
595 px_parent_osr IN OUT NOCOPY VARCHAR2,
596 px_parent_obj_type IN OUT NOCOPY VARCHAR2
597 );
598
599 -- PROCEDURE create_sms_bo
600 --
601 -- DESCRIPTION
602 -- Create a logical sms contact point.
603 --
604 -- ARGUMENTS
605 -- IN:
606 -- p_init_msg_list Initialize message stack if it is set to
607 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
608 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
609 -- the completeness of business object.
610 -- p_sms_obj SMS business object.
611 -- p_created_by_module Created by module.
612 -- IN/OUT:
613 -- px_parent_id Parent record ID.
614 -- px_parent_os Parent orig system.
615 -- px_parent_osr Parent orig system reference.
616 -- px_parent_obj_type Parent object type.
617 -- OUT:
618 -- x_return_status Return status after the call. The status can
619 -- be fnd_api.g_ret_sts_success (success),
620 -- fnd_api.g_ret_sts_error (error),
621 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
622 -- x_msg_count Number of messages in message stack.
623 -- x_msg_data Message text if x_msg_count is 1.
624 -- x_sms_id Contact point ID.
625 -- x_sms_os Contact point orig system.
626 -- x_sms_osr Contact point orig system reference.
627 --
628 -- NOTES
629 --
630 -- MODIFICATION HISTORY
631 --
632 -- 14-DEC-2004 Arnold Ng Created.
633
637 p_sms_obj IN HZ_SMS_CP_BO,
634 PROCEDURE create_sms_bo(
635 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
636 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
638 p_created_by_module IN VARCHAR2,
639 x_return_status OUT NOCOPY VARCHAR2,
640 x_msg_count OUT NOCOPY NUMBER,
641 x_msg_data OUT NOCOPY VARCHAR2,
642 x_sms_id OUT NOCOPY NUMBER,
643 x_sms_os OUT NOCOPY VARCHAR2,
644 x_sms_osr OUT NOCOPY VARCHAR2,
645 px_parent_id IN OUT NOCOPY NUMBER,
646 px_parent_os IN OUT NOCOPY VARCHAR2,
647 px_parent_osr IN OUT NOCOPY VARCHAR2,
648 px_parent_obj_type IN OUT NOCOPY VARCHAR2
649 );
650
651 /*#
652 * Create SMS Business Object (create_sms_bo)
653 * Creates a SMS business object. You pass object data to the procedure, packaged within an object type defined
654 * specifically for the API. The object type is HZ_SMS_CP_BO for the SMS business object. In addition to the object's
655 * business object attributes, the object type also includes lower-level embedded child entities or objects that can
656 * be simultaneously created.
657 *
658 * @param p_return_obj_flag Indicates if the created object is to be returned to the caller as an output parameter. Default value: false
659 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness. Default value: true
660 * @param p_sms_obj The SMS business object to be created in its entirety
661 * @param p_created_by_module The module creating this business object. Must be a valid created_by_module value
662 * @param p_obj_source The source of this business object
668 * @param x_sms_osr SMS original system reference
663 * @param x_return_status Return status after the call
664 * @param x_return_obj The SMS business object that was created, returned as an output parameter
665 * @param x_messages Messages returned from the creation of the business object
666 * @param x_sms_id TCA identifier for the SMS business object
667 * @param x_sms_os SMS original system name
669 * @param px_parent_id TCA identifier for parent object. Either this parameter or both the px_parent_os and px_parent_osr parameters must be given
670 * @param px_parent_os Parent object original system name
671 * @param px_parent_osr Parent object original system reference
672 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
673 * @rep:scope public
674 * @rep:lifecycle active
675 * @rep:displayname Create SMS Business Object
676 * @rep:doccd 120hztig.pdf Create SMS Business Object, Oracle Trading Community Architecture Technical Implementation Guide
677 */
678 PROCEDURE create_sms_bo(
679 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
680 p_sms_obj IN HZ_SMS_CP_BO,
681 p_created_by_module IN VARCHAR2,
682 p_obj_source IN VARCHAR2 := null,
683 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
684 x_return_status OUT NOCOPY VARCHAR2,
685 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
686 x_return_obj OUT NOCOPY HZ_SMS_CP_BO,
687 x_sms_id OUT NOCOPY NUMBER,
688 x_sms_os OUT NOCOPY VARCHAR2,
689 x_sms_osr OUT NOCOPY VARCHAR2,
690 px_parent_id IN OUT NOCOPY NUMBER,
691 px_parent_os IN OUT NOCOPY VARCHAR2,
692 px_parent_osr IN OUT NOCOPY VARCHAR2,
693 px_parent_obj_type IN OUT NOCOPY VARCHAR2
694 );
695
696 -- PROCEDURE update_phone_bo
697 --
698 -- DESCRIPTION
699 -- Update a logical phone contact point.
700 --
701 -- ARGUMENTS
705 -- p_phone_obj Phone business object.
702 -- IN:
703 -- p_init_msg_list Initialize message stack if it is set to
704 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
706 -- p_created_by_module Created by module.
707 -- OUT:
711 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
708 -- x_return_status Return status after the call. The status can
709 -- be fnd_api.g_ret_sts_success (success),
710 -- fnd_api.g_ret_sts_error (error),
712 -- x_msg_count Number of messages in message stack.
713 -- x_msg_data Message text if x_msg_count is 1.
714 -- x_phone_id Contact point ID.
715 -- x_phone_os Contact point orig system.
716 -- x_phone_osr Contact point orig system reference.
717 --
718 -- NOTES
719 --
720 -- MODIFICATION HISTORY
721 --
722 -- 14-DEC-2004 Arnold Ng Created.
723
724 PROCEDURE update_phone_bo(
725 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
726 p_phone_obj IN HZ_PHONE_CP_BO,
727 p_created_by_module IN VARCHAR2,
728 x_return_status OUT NOCOPY VARCHAR2,
729 x_msg_count OUT NOCOPY NUMBER,
730 x_msg_data OUT NOCOPY VARCHAR2,
731 x_phone_id OUT NOCOPY NUMBER,
732 x_phone_os OUT NOCOPY VARCHAR2,
733 x_phone_osr OUT NOCOPY VARCHAR2
734 );
735
736 /*#
737 * Update Phone Business Object (update_phone_cp_bo)
738 * Updates a Phone business object. You pass any modified object data to the procedure, packaged within an object type
739 * defined specifically for the API. The object type is HZ_PHONE_CP_BO for the Phone business object. In addition to
740 * the object's business object attributes, the object type also includes embedded child business entities or objects
741 * that can be simultaneously created or updated.
742 *
746 * @param p_obj_source The source of this business object
743 * @param p_return_obj_flag Indicates if the updated object is to be returned to the caller as an output parameter. Default value: false
744 * @param p_phone_obj The Phone business object to be updated
745 * @param p_created_by_module The module updating this business object
747 * @param x_return_status Return status after the call
748 * @param x_return_obj The Phone business object that was updated, returned as an output parameter
749 * @param x_messages Messages returned from the update of the business object
750 * @param x_phone_id TCA identifier for the Phone business object
751 * @param x_phone_os Phone original system name
752 * @param x_phone_osr Phone original system reference
753 * @rep:scope public
754 * @rep:lifecycle active
755 * @rep:displayname Update Phone Business Object
756 * @rep:doccd 120hztig.pdf Update Phone Business Object, Oracle Trading Community Architecture Technical Implementation Guide
757 */
758 PROCEDURE update_phone_bo(
759 p_phone_obj IN HZ_PHONE_CP_BO,
760 p_created_by_module IN VARCHAR2,
761 p_obj_source IN VARCHAR2 := null,
765 x_return_obj OUT NOCOPY HZ_PHONE_CP_BO,
762 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
763 x_return_status OUT NOCOPY VARCHAR2,
764 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
766 x_phone_id OUT NOCOPY NUMBER,
767 x_phone_os OUT NOCOPY VARCHAR2,
768 x_phone_osr OUT NOCOPY VARCHAR2
769 );
770
771 -- PROCEDURE update_telex_bo
772 --
773 -- DESCRIPTION
774 -- Update a logical telex contact point.
775 --
776 -- ARGUMENTS
777 -- IN:
778 -- p_init_msg_list Initialize message stack if it is set to
779 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
780 -- p_telex_obj Telex business object.
781 -- p_created_by_module Created by module.
782 -- OUT:
783 -- x_return_status Return status after the call. The status can
784 -- be fnd_api.g_ret_sts_success (success),
785 -- fnd_api.g_ret_sts_error (error),
786 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
787 -- x_msg_count Number of messages in message stack.
788 -- x_msg_data Message text if x_msg_count is 1.
789 -- x_telex_id Contact point ID.
790 -- x_telex_os Contact point orig system.
791 -- x_telex_osr Contact point orig system reference.
792 --
793 -- NOTES
794 --
795 -- MODIFICATION HISTORY
796 --
797 -- 14-DEC-2004 Arnold Ng Created.
798
799 PROCEDURE update_telex_bo(
800 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
801 p_telex_obj IN HZ_TELEX_CP_BO,
802 p_created_by_module IN VARCHAR2,
803 x_return_status OUT NOCOPY VARCHAR2,
804 x_msg_count OUT NOCOPY NUMBER,
805 x_msg_data OUT NOCOPY VARCHAR2,
806 x_telex_id OUT NOCOPY NUMBER,
807 x_telex_os OUT NOCOPY VARCHAR2,
808 x_telex_osr OUT NOCOPY VARCHAR2
809 );
810
811 /*#
812 * Update Telex Business Object (update_telex_bo)
813 * Updates a Telex business object. You pass any modified object data to the procedure, packaged within an object type
814 * defined specifically for the API. The object type is HZ_TELEX_CP_BO for the Telex business object. In addition to
815 * the object's business object attributes, the object type also includes embedded child business entities or objects
819 * @param p_telex_obj The Telex business object to be updated
816 * that can be simultaneously created or updated.
817 *
818 * @param p_return_obj_flag Indicates if the updated object is to be returned to the caller as an output parameter. Default value: false
820 * @param p_created_by_module The module updating this business object
821 * @param p_obj_source The source of this business object
822 * @param x_return_status Return status after the call
823 * @param x_return_obj The Telex business object that was updated, returned as an output parameter
824 * @param x_messages Messages returned from the update of the business object
825 * @param x_telex_id TCA identifier for the Telex business object
826 * @param x_telex_os Telex original system name
827 * @param x_telex_osr Telex original system reference
828 * @rep:scope public
829 * @rep:lifecycle active
830 * @rep:displayname Update Telex Business Object
834 p_telex_obj IN HZ_TELEX_CP_BO,
831 * @rep:doccd 120hztig.pdf Update Telex Business Object, Oracle Trading Community Architecture Technical Implementation Guide
832 */
833 PROCEDURE update_telex_bo(
835 p_created_by_module IN VARCHAR2,
836 p_obj_source IN VARCHAR2 := null,
837 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
838 x_return_status OUT NOCOPY VARCHAR2,
839 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
840 x_return_obj OUT NOCOPY HZ_TELEX_CP_BO,
841 x_telex_id OUT NOCOPY NUMBER,
842 x_telex_os OUT NOCOPY VARCHAR2,
843 x_telex_osr OUT NOCOPY VARCHAR2
844 );
845
846 -- PROCEDURE update_email_bo
847 --
848 -- DESCRIPTION
849 -- Update a logical email contact point.
850 --
851 -- ARGUMENTS
852 -- IN:
853 -- p_init_msg_list Initialize message stack if it is set to
854 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
855 -- p_email_obj Email business object.
856 -- p_created_by_module Created by module.
857 -- OUT:
858 -- x_return_status Return status after the call. The status can
859 -- be fnd_api.g_ret_sts_success (success),
860 -- fnd_api.g_ret_sts_error (error),
864 -- x_email_id Contact point ID.
861 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
862 -- x_msg_count Number of messages in message stack.
863 -- x_msg_data Message text if x_msg_count is 1.
865 -- x_email_os Contact point orig system.
866 -- x_email_osr Contact point orig system reference.
867 --
868 -- NOTES
869 --
870 -- MODIFICATION HISTORY
871 --
872 -- 14-DEC-2004 Arnold Ng Created.
873
874 PROCEDURE update_email_bo(
875 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
876 p_email_obj IN HZ_EMAIL_CP_BO,
877 p_created_by_module IN VARCHAR2,
878 x_return_status OUT NOCOPY VARCHAR2,
879 x_msg_count OUT NOCOPY NUMBER,
880 x_msg_data OUT NOCOPY VARCHAR2,
881 x_email_id OUT NOCOPY NUMBER,
882 x_email_os OUT NOCOPY VARCHAR2,
883 x_email_osr OUT NOCOPY VARCHAR2
884 );
885
886 /*#
887 * Update Email Business Object (update_email_bo)
888 * Updates a Email business object. You pass any modified object data to the procedure, packaged within an object type
889 * defined specifically for the API. The object type is HZ_EMIAL_CP_BO for the Email business object. In addition to the
890 * object's business object attributes, the object type also includes embedded child business entities or objects that
891 * can be simultaneously created or updated.
892 *
893 * @param p_return_obj_flag Indicates if the updated object is to be returned to the caller as an output parameter. Default value: false
894 * @param p_email_obj The Email business object to be updated
895 * @param p_created_by_module The module updating this business object
896 * @param p_obj_source The source of this business object
897 * @param x_return_status Return status after the call
898 * @param x_return_obj The Email business object that was updated, returned as an output parameter
899 * @param x_messages Messages returned from the update of the business object
900 * @param x_email_id TCA identifier for the Email business object
901 * @param x_email_os Email original system name
902 * @param x_email_osr Email original system reference
903 * @rep:scope public
904 * @rep:lifecycle active
905 * @rep:displayname Update Email Business Object
906 * @rep:doccd 120hztig.pdf Update Email Business Object, Oracle Trading Community Architecture Technical Implementation Guide
907 */
911 p_obj_source IN VARCHAR2 := null,
908 PROCEDURE update_email_bo(
909 p_email_obj IN HZ_EMAIL_CP_BO,
910 p_created_by_module IN VARCHAR2,
912 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
913 x_return_status OUT NOCOPY VARCHAR2,
914 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
915 x_return_obj OUT NOCOPY HZ_EMAIL_CP_BO,
916 x_email_id OUT NOCOPY NUMBER,
917 x_email_os OUT NOCOPY VARCHAR2,
918 x_email_osr OUT NOCOPY VARCHAR2
919 );
920
921 -- PROCEDURE update_web_bo
922 --
923 -- DESCRIPTION
924 -- Update a logical web contact point.
925 --
926 -- ARGUMENTS
927 -- IN:
928 -- p_init_msg_list Initialize message stack if it is set to
929 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
930 -- p_web_obj Web business object.
931 -- p_created_by_module Created by module.
932 -- IN/OUT:
933 -- px_parent_id Parent record ID.
934 -- px_parent_os Parent orig system.
935 -- px_parent_osr Parent orig system reference.
936 -- px_parent_obj_type Parent object type.
937 -- OUT:
938 -- x_return_status Return status after the call. The status can
939 -- be fnd_api.g_ret_sts_success (success),
940 -- fnd_api.g_ret_sts_error (error),
941 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
942 -- x_msg_count Number of messages in message stack.
943 -- x_msg_data Message text if x_msg_count is 1.
944 -- x_web_id Contact point ID.
945 -- x_web_os Contact point orig system.
946 -- x_web_osr Contact point orig system reference.
947 --
948 -- NOTES
949 --
950 -- MODIFICATION HISTORY
951 --
952 -- 14-DEC-2004 Arnold Ng Created.
953
954 PROCEDURE update_web_bo(
955 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
956 p_web_obj IN HZ_WEB_CP_BO,
957 p_created_by_module IN VARCHAR2,
958 x_return_status OUT NOCOPY VARCHAR2,
959 x_msg_count OUT NOCOPY NUMBER,
960 x_msg_data OUT NOCOPY VARCHAR2,
961 x_web_id OUT NOCOPY NUMBER,
962 x_web_os OUT NOCOPY VARCHAR2,
963 x_web_osr OUT NOCOPY VARCHAR2
964 );
965
966 /*#
967 * Update Web Business Object (update_web_bo)
968 * Updates a Web business object. You pass any modified object data to the procedure, packaged within an object type
969 * defined specifically for the API. The object type is HZ_WEB_CP_BO for the Web business object. In addition to the
973 * @param p_return_obj_flag Indicates if the updated object is to be returned to the caller as an output parameter. Default value: false
970 * object's business object attributes, the object type also includes embedded child business entities or objects that
971 * can be simultaneously created or updated.
972 *
974 * @param p_web_obj The Web business object to be updated
975 * @param p_created_by_module The module updating this business object
976 * @param p_obj_source The source of this business object
977 * @param x_return_status Return status after the call
978 * @param x_return_obj The Web business object that was updated, returned as an output parameter
979 * @param x_messages Messages returned from the update of the business object
980 * @param x_web_id TCA identifier for the Web business object
981 * @param x_web_os Web original system name
982 * @param x_web_osr Web original system reference
983 * @rep:scope public
984 * @rep:lifecycle active
985 * @rep:displayname Update Web Business Object
986 * @rep:doccd 120hztig.pdf Update Web Business Object, Oracle Trading Community Architecture Technical Implementation Guide
987 */
988 PROCEDURE update_web_bo(
989 p_web_obj IN HZ_WEB_CP_BO,
990 p_created_by_module IN VARCHAR2,
991 p_obj_source IN VARCHAR2 := null,
992 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
993 x_return_status OUT NOCOPY VARCHAR2,
994 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
995 x_return_obj OUT NOCOPY HZ_WEB_CP_BO,
996 x_web_id OUT NOCOPY NUMBER,
997 x_web_os OUT NOCOPY VARCHAR2,
998 x_web_osr OUT NOCOPY VARCHAR2
999 );
1000
1001 -- PROCEDURE update_edi_bo
1002 --
1003 -- DESCRIPTION
1004 -- Update a logical edi contact point.
1005 --
1006 -- ARGUMENTS
1007 -- IN:
1008 -- p_init_msg_list Initialize message stack if it is set to
1009 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1010 -- p_edi_obj EDI business object.
1011 -- p_created_by_module Created by module.
1012 -- IN/OUT:
1013 -- px_parent_id Parent record ID.
1014 -- px_parent_os Parent orig system.
1015 -- px_parent_osr Parent orig system reference.
1016 -- px_parent_obj_type Parent object type.
1017 -- OUT:
1018 -- x_return_status Return status after the call. The status can
1019 -- be fnd_api.g_ret_sts_success (success),
1020 -- fnd_api.g_ret_sts_error (error),
1021 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1022 -- x_msg_count Number of messages in message stack.
1023 -- x_msg_data Message text if x_msg_count is 1.
1024 -- x_edi_id Contact point ID.
1025 -- x_edi_os Contact point orig system.
1026 -- x_edi_osr Contact point orig system reference.
1027 --
1028 -- NOTES
1029 --
1030 -- MODIFICATION HISTORY
1031 --
1032 -- 14-DEC-2004 Arnold Ng Created.
1033
1034 PROCEDURE update_edi_bo(
1035 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1036 p_edi_obj IN HZ_EDI_CP_BO,
1037 p_created_by_module IN VARCHAR2,
1038 x_return_status OUT NOCOPY VARCHAR2,
1039 x_msg_count OUT NOCOPY NUMBER,
1040 x_msg_data OUT NOCOPY VARCHAR2,
1041 x_edi_id OUT NOCOPY NUMBER,
1042 x_edi_os OUT NOCOPY VARCHAR2,
1043 x_edi_osr OUT NOCOPY VARCHAR2
1044 );
1045
1046 /*#
1047 * Update EDI Business Object (update_edi_bo)
1048 * Updates a EDI business object. You pass any modified object data to the procedure, packaged within an object type
1052 *
1049 * defined specifically for the API. The object type is HZ_EDI_CP_BO for the EDI business object. In addition to the
1050 * object's business object attributes, the object type also includes embedded child business entities or objects that
1051 * can be simultaneously created or updated.
1053 * @param p_return_obj_flag Indicates if the updated object is to be returned to the caller as an output parameter. Default value: false
1054 * @param p_edi_obj The EDI business object to be updated
1055 * @param p_created_by_module The module updating this business object
1056 * @param p_obj_source The source of this business object
1057 * @param x_return_status Return status after the call
1058 * @param x_return_obj The EDI business object that was updated, returned as an output parameter
1059 * @param x_messages Messages returned from the update of the business object
1060 * @param x_edi_id TCA identifier for the EDI business object
1061 * @param x_edi_os EDI original system name
1062 * @param x_edi_osr EDI original system reference
1063 * @rep:scope public
1064 * @rep:lifecycle active
1065 * @rep:displayname Update EDI Business Object
1066 * @rep:doccd 120hztig.pdf Update EDI Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1067 */
1068 PROCEDURE update_edi_bo(
1069 p_edi_obj IN HZ_EDI_CP_BO,
1070 p_created_by_module IN VARCHAR2,
1071 p_obj_source IN VARCHAR2 := null,
1072 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1073 x_return_status OUT NOCOPY VARCHAR2,
1074 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1075 x_return_obj OUT NOCOPY HZ_EDI_CP_BO,
1076 x_edi_id OUT NOCOPY NUMBER,
1077 x_edi_os OUT NOCOPY VARCHAR2,
1078 x_edi_osr OUT NOCOPY VARCHAR2
1079 );
1080
1081 -- PROCEDURE update_eft_bo
1082 --
1083 -- DESCRIPTION
1084 -- Update a logical eft contact point.
1085 --
1086 -- ARGUMENTS
1087 -- IN:
1088 -- p_init_msg_list Initialize message stack if it is set to
1089 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1090 -- p_eft_obj EFT business object.
1094 -- px_parent_os Parent orig system.
1091 -- p_created_by_module Created by module.
1092 -- IN/OUT:
1093 -- px_parent_id Parent record ID.
1095 -- px_parent_osr Parent orig system reference.
1096 -- px_parent_obj_type Parent object type.
1097 -- OUT:
1098 -- x_return_status Return status after the call. The status can
1099 -- be fnd_api.g_ret_sts_success (success),
1100 -- fnd_api.g_ret_sts_error (error),
1101 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1102 -- x_msg_count Number of messages in message stack.
1103 -- x_msg_data Message text if x_msg_count is 1.
1104 -- x_eft_id Contact point ID.
1105 -- x_eft_os Contact point orig system.
1106 -- x_eft_osr Contact point orig system reference.
1107 --
1108 -- NOTES
1109 --
1110 -- MODIFICATION HISTORY
1111 --
1112 -- 14-DEC-2004 Arnold Ng Created.
1113
1114 PROCEDURE update_eft_bo(
1115 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1116 p_eft_obj IN HZ_EFT_CP_BO,
1117 p_created_by_module IN VARCHAR2,
1118 x_return_status OUT NOCOPY VARCHAR2,
1119 x_msg_count OUT NOCOPY NUMBER,
1120 x_msg_data OUT NOCOPY VARCHAR2,
1121 x_eft_id OUT NOCOPY NUMBER,
1122 x_eft_os OUT NOCOPY VARCHAR2,
1123 x_eft_osr OUT NOCOPY VARCHAR2
1124 );
1125
1126 /*#
1127 * Update EFT Business Object (update_eft_bo)
1128 * Updates a EFT business object. You pass any modified object data to the procedure, packaged within an object type
1129 * defined specifically for the API. The object type is HZ_EFT_CP_BO for the EFT business object. In addition to the
1130 * object's business object attributes, the object type also includes embedded child business entities or objects that
1131 * can be simultaneously created or updated.
1132 *
1133 * @param p_return_obj_flag Indicates if the updated object is to be returned to the caller as an output parameter. Default value: false
1134 * @param p_eft_obj The EFT business object to be updated
1135 * @param p_created_by_module The module updating this business object
1136 * @param p_obj_source The source of this business object
1137 * @param x_return_status Return status after the call
1138 * @param x_return_obj The EFT business object that was updated, returned as an output parameter
1139 * @param x_messages Messages returned from the update of the business object
1140 * @param x_eft_id TCA identifier for the EFT business object
1141 * @param x_eft_os EFT original system name
1142 * @param x_eft_osr EFT original system reference
1143 * @rep:scope public
1144 * @rep:lifecycle active
1145 * @rep:displayname Update EFT Business Object
1146 * @rep:doccd 120hztig.pdf Update EFT Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1147 */
1148 PROCEDURE update_eft_bo(
1152 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1149 p_eft_obj IN HZ_EFT_CP_BO,
1150 p_created_by_module IN VARCHAR2,
1151 p_obj_source IN VARCHAR2 := null,
1153 x_return_status OUT NOCOPY VARCHAR2,
1154 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1155 x_return_obj OUT NOCOPY HZ_EFT_CP_BO,
1156 x_eft_id OUT NOCOPY NUMBER,
1157 x_eft_os OUT NOCOPY VARCHAR2,
1158 x_eft_osr OUT NOCOPY VARCHAR2
1159 );
1160
1161 -- PROCEDURE update_sms_bo
1162 --
1163 -- DESCRIPTION
1164 -- Update a logical sms contact point.
1165 --
1166 -- ARGUMENTS
1167 -- IN:
1168 -- p_init_msg_list Initialize message stack if it is set to
1169 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1170 -- p_sms_obj SMS business object.
1171 -- p_created_by_module Created by module.
1172 -- IN/OUT:
1173 -- px_parent_id Parent record ID.
1174 -- px_parent_os Parent orig system.
1175 -- px_parent_osr Parent orig system reference.
1176 -- px_parent_obj_type Parent object type.
1177 -- OUT:
1178 -- x_return_status Return status after the call. The status can
1179 -- be fnd_api.g_ret_sts_success (success),
1180 -- fnd_api.g_ret_sts_error (error),
1181 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1182 -- x_msg_count Number of messages in message stack.
1183 -- x_msg_data Message text if x_msg_count is 1.
1184 -- x_sms_id Contact point ID.
1185 -- x_sms_os Contact point orig system.
1186 -- x_sms_osr Contact point orig system reference.
1187 --
1188 -- NOTES
1189 --
1190 -- MODIFICATION HISTORY
1191 --
1192 -- 14-DEC-2004 Arnold Ng Created.
1193
1194 PROCEDURE update_sms_bo(
1195 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1196 p_sms_obj IN HZ_SMS_CP_BO,
1197 p_created_by_module IN VARCHAR2,
1198 x_return_status OUT NOCOPY VARCHAR2,
1199 x_msg_count OUT NOCOPY NUMBER,
1200 x_msg_data OUT NOCOPY VARCHAR2,
1201 x_sms_id OUT NOCOPY NUMBER,
1202 x_sms_os OUT NOCOPY VARCHAR2,
1203 x_sms_osr OUT NOCOPY VARCHAR2
1204 );
1205
1206 /*#
1207 * Update SMS Business Object (update_sms_bo)
1208 * Updates a SMS business object. You pass any modified object data to the procedure, packaged within an object type
1209 * defined specifically for the API. The object type is HZ_SMS_CP_BO for the SMS business object. In addition to the
1210 * object's business object attributes, the object type also includes embedded child business entities or objects that
1211 * can be simultaneously created or updated.
1212 *
1213 * @param p_return_obj_flag Indicates if the updated object is to be returned to the caller as an output parameter. Default value: false
1214 * @param p_sms_obj The SMS business object to be updated
1215 * @param p_created_by_module The module updating this business object
1216 * @param p_obj_source The source of this business object
1217 * @param x_return_status Return status after the call
1218 * @param x_return_obj The SMS business object that was updated, returned as an output parameter
1219 * @param x_messages Messages returned from the update of the business object
1220 * @param x_sms_id TCA identifier for the SMS business object
1221 * @param x_sms_os SMS original system name
1222 * @param x_sms_osr SMS original system reference
1223 * @rep:scope public
1224 * @rep:lifecycle active
1225 * @rep:displayname Update SMS Business Object
1226 * @rep:doccd 120hztig.pdf Update SMS Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1227 */
1228 PROCEDURE update_sms_bo(
1229 p_sms_obj IN HZ_SMS_CP_BO,
1230 p_created_by_module IN VARCHAR2,
1231 p_obj_source IN VARCHAR2 := null,
1232 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1236 x_sms_id OUT NOCOPY NUMBER,
1233 x_return_status OUT NOCOPY VARCHAR2,
1234 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1235 x_return_obj OUT NOCOPY HZ_SMS_CP_BO,
1237 x_sms_os OUT NOCOPY VARCHAR2,
1238 x_sms_osr OUT NOCOPY VARCHAR2
1239 );
1240
1244 -- Create or update a logical phone contact point.
1241 -- PROCEDURE save_phone_bo
1242 --
1243 -- DESCRIPTION
1245 --
1246 -- ARGUMENTS
1247 -- IN:
1248 -- p_init_msg_list Initialize message stack if it is set to
1249 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1250 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
1251 -- the completeness of business object.
1252 -- p_phone_obj Phone business object.
1253 -- p_created_by_module Created by module.
1254 -- IN/OUT:
1255 -- px_parent_id Parent record ID.
1256 -- px_parent_os Parent orig system.
1257 -- px_parent_osr Parent orig system reference.
1258 -- px_parent_obj_type Parent object type.
1259 -- OUT:
1263 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1260 -- x_return_status Return status after the call. The status can
1261 -- be fnd_api.g_ret_sts_success (success),
1262 -- fnd_api.g_ret_sts_error (error),
1264 -- x_msg_count Number of messages in message stack.
1265 -- x_msg_data Message text if x_msg_count is 1.
1266 -- x_phone_id Contact point ID.
1267 -- x_phone_os Contact point orig system.
1268 -- x_phone_osr Contact point orig system reference.
1269 --
1270 -- NOTES
1271 --
1272 -- MODIFICATION HISTORY
1273 --
1274 -- 14-DEC-2004 Arnold Ng Created.
1275
1276 PROCEDURE save_phone_bo(
1277 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1278 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1279 p_phone_obj IN HZ_PHONE_CP_BO,
1280 p_created_by_module IN VARCHAR2,
1281 x_return_status OUT NOCOPY VARCHAR2,
1282 x_msg_count OUT NOCOPY NUMBER,
1283 x_msg_data OUT NOCOPY VARCHAR2,
1284 x_phone_id OUT NOCOPY NUMBER,
1285 x_phone_os OUT NOCOPY VARCHAR2,
1286 x_phone_osr OUT NOCOPY VARCHAR2,
1287 px_parent_id IN OUT NOCOPY NUMBER,
1288 px_parent_os IN OUT NOCOPY VARCHAR2,
1289 px_parent_osr IN OUT NOCOPY VARCHAR2,
1290 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1291 );
1292
1293 /*#
1294 * Save Phone Business Object (save_phone_cp_bo)
1295 * Saves a Phone business object. You pass new or modified object data to the procedure, packaged within an object type
1296 * defined specifically for the API. The API then determines if the object exists in TCA, based upon the provided
1297 * identification information, and creates or updates the object. The object type is HZ_PHONE_CP_BO for the Phone
1298 * business object. For either case, the object type that you provide will be processed as if the respective API procedure
1299 * is being called (create_phone_cp_bo or update_phone_cp_bo). Please see those procedures for more details. In addition to
1300 * the object's business object attributes, the object type also includes embedded child business entities or objects that
1301 * can be simultaneously created or updated.
1302 *
1303 * @param p_return_obj_flag Indicates if the saved object is to be returned to the caller as an output parameter. Default value: false
1304 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness if it is being created
1305 * @param p_phone_obj The Phone business object to be saved
1306 * @param p_created_by_module The module saving this business object
1307 * @param p_obj_source The source of this business object
1308 * @param x_return_status Return status after the call
1309 * @param x_return_obj The Phone business object that was saved, returned as an output parameter
1310 * @param x_messages Messages returned from the save of the business object
1311 * @param x_phone_id TCA identifier for the Phone business object
1312 * @param x_phone_os Phone original system name
1313 * @param x_phone_osr Phone original system reference
1314 * @param px_parent_id TCA identifier for parent object. Either this parameter, or both the px_parent_os and px_parent_osr parameters, must be given
1315 * @param px_parent_os Parent object original system name
1316 * @param px_parent_osr Parent object original system reference
1317 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
1318 * @rep:scope public
1319 * @rep:lifecycle active
1320 * @rep:displayname Save Phone Business Object
1321 * @rep:doccd 120hztig.pdf Save Phone Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1322 */
1323 PROCEDURE save_phone_bo(
1327 p_obj_source IN VARCHAR2 := null,
1324 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1325 p_phone_obj IN HZ_PHONE_CP_BO,
1326 p_created_by_module IN VARCHAR2,
1328 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1329 x_return_status OUT NOCOPY VARCHAR2,
1330 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1331 x_return_obj OUT NOCOPY HZ_PHONE_CP_BO,
1332 x_phone_id OUT NOCOPY NUMBER,
1333 x_phone_os OUT NOCOPY VARCHAR2,
1334 x_phone_osr OUT NOCOPY VARCHAR2,
1335 px_parent_id IN OUT NOCOPY NUMBER,
1336 px_parent_os IN OUT NOCOPY VARCHAR2,
1337 px_parent_osr IN OUT NOCOPY VARCHAR2,
1338 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1339 );
1340
1341 -- DESCRIPTION
1342 -- PROCEDURE save_telex_bo
1343 --
1344 -- DESCRIPTION
1345 -- Create or update a logical telex contact point.
1346 --
1347 -- ARGUMENTS
1348 -- IN:
1349 -- p_init_msg_list Initialize message stack if it is set to
1350 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1351 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
1352 -- the completeness of business object.
1353 -- p_telex_obj Telex business object.
1357 -- px_parent_os Parent orig system.
1354 -- p_created_by_module Created by module.
1355 -- IN/OUT:
1356 -- px_parent_id Parent record ID.
1358 -- px_parent_osr Parent orig system reference.
1359 -- px_parent_obj_type Parent object type.
1360 -- OUT:
1361 -- x_return_status Return status after the call. The status can
1362 -- be fnd_api.g_ret_sts_success (success),
1363 -- fnd_api.g_ret_sts_error (error),
1364 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1365 -- x_msg_count Number of messages in message stack.
1366 -- x_msg_data Message text if x_msg_count is 1.
1367 -- x_telex_id Contact point ID.
1368 -- x_telex_os Contact point orig system.
1369 -- x_telex_osr Contact point orig system reference.
1370 --
1371 -- NOTES
1372 --
1373 -- MODIFICATION HISTORY
1374 --
1375 -- 14-DEC-2004 Arnold Ng Created.
1376
1377 PROCEDURE save_telex_bo(
1381 p_created_by_module IN VARCHAR2,
1378 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1379 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1380 p_telex_obj IN HZ_TELEX_CP_BO,
1382 x_return_status OUT NOCOPY VARCHAR2,
1383 x_msg_count OUT NOCOPY NUMBER,
1384 x_msg_data OUT NOCOPY VARCHAR2,
1385 x_telex_id OUT NOCOPY NUMBER,
1386 x_telex_os OUT NOCOPY VARCHAR2,
1387 x_telex_osr OUT NOCOPY VARCHAR2,
1388 px_parent_id IN OUT NOCOPY NUMBER,
1389 px_parent_os IN OUT NOCOPY VARCHAR2,
1390 px_parent_osr IN OUT NOCOPY VARCHAR2,
1391 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1392 );
1393
1394 /*#
1395 * Save Telex Business Object (save_telex_bo)
1396 * Saves a Telex business object. You pass new or modified object data to the procedure, packaged within an object type
1397 * defined specifically for the API. The API then determines if the object exists in TCA, based upon the provided
1398 * identification information, and creates or updates the object. The object type is HZ_TELEX_CP_BO for the Telex
1399 * business object. For either case, the object type that you provide will be processed as if the respective API procedure
1400 * is being called (create_telex_bo or update_telex_bo). Please see those procedures for more details. In addition to
1401 * the object's business object attributes, the object type also includes embedded child business entities or objects
1402 * that can be simultaneously created or updated.
1403 *
1404 * @param p_return_obj_flag Indicates if the saved object is to be returned to the caller as an output parameter. Default value: false
1405 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness if it is being created
1406 * @param p_telex_obj The Telex business object to be saved
1407 * @param p_created_by_module The module saving this business object
1408 * @param p_obj_source The source of this business object
1409 * @param x_return_status Return status after the call
1410 * @param x_return_obj The Telex business object that was saved, returned as an output parameter
1411 * @param x_messages Messages returned from the save of the business object
1412 * @param x_telex_id TCA identifier for the Telex business object
1413 * @param x_telex_os Telex original system name
1414 * @param x_telex_osr Telex original system reference
1415 * @param px_parent_id TCA identifier for parent object. Either this parameter, or both the px_parent_os and px_parent_osr parameters, must be given
1416 * @param px_parent_os Parent object original system name
1417 * @param px_parent_osr Parent object original system reference
1418 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
1419 * @rep:scope public
1420 * @rep:lifecycle active
1421 * @rep:displayname Save Telex Business Object
1422 * @rep:doccd 120hztig.pdf Save Telex Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1423 */
1424 PROCEDURE save_telex_bo(
1425 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1426 p_telex_obj IN HZ_TELEX_CP_BO,
1427 p_created_by_module IN VARCHAR2,
1428 p_obj_source IN VARCHAR2 := null,
1429 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1430 x_return_status OUT NOCOPY VARCHAR2,
1431 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1432 x_return_obj OUT NOCOPY HZ_TELEX_CP_BO,
1433 x_telex_id OUT NOCOPY NUMBER,
1434 x_telex_os OUT NOCOPY VARCHAR2,
1435 x_telex_osr OUT NOCOPY VARCHAR2,
1436 px_parent_id IN OUT NOCOPY NUMBER,
1440 );
1437 px_parent_os IN OUT NOCOPY VARCHAR2,
1438 px_parent_osr IN OUT NOCOPY VARCHAR2,
1439 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1441
1442 -- PROCEDURE save_email_bo
1443 --
1444 -- DESCRIPTION
1448 -- IN:
1445 -- Create or update a logical email contact point.
1446 --
1447 -- ARGUMENTS
1449 -- p_init_msg_list Initialize message stack if it is set to
1450 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1451 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
1452 -- the completeness of business object.
1453 -- p_email_obj Email business object.
1454 -- p_created_by_module Created by module.
1455 -- IN/OUT:
1456 -- px_parent_id Parent record ID.
1457 -- px_parent_os Parent orig system.
1458 -- px_parent_osr Parent orig system reference.
1459 -- px_parent_obj_type Parent object type.
1460 -- OUT:
1461 -- x_return_status Return status after the call. The status can
1462 -- be fnd_api.g_ret_sts_success (success),
1463 -- fnd_api.g_ret_sts_error (error),
1464 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1465 -- x_msg_count Number of messages in message stack.
1466 -- x_msg_data Message text if x_msg_count is 1.
1467 -- x_email_id Contact point ID.
1468 -- x_email_os Contact point orig system.
1469 -- x_email_osr Contact point orig system reference.
1470 --
1471 -- NOTES
1472 --
1473 -- MODIFICATION HISTORY
1474 --
1475 -- 14-DEC-2004 Arnold Ng Created.
1476
1477 PROCEDURE save_email_bo(
1478 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1482 x_return_status OUT NOCOPY VARCHAR2,
1479 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1480 p_email_obj IN HZ_EMAIL_CP_BO,
1481 p_created_by_module IN VARCHAR2,
1483 x_msg_count OUT NOCOPY NUMBER,
1484 x_msg_data OUT NOCOPY VARCHAR2,
1485 x_email_id OUT NOCOPY NUMBER,
1486 x_email_os OUT NOCOPY VARCHAR2,
1487 x_email_osr OUT NOCOPY VARCHAR2,
1488 px_parent_id IN OUT NOCOPY NUMBER,
1489 px_parent_os IN OUT NOCOPY VARCHAR2,
1490 px_parent_osr IN OUT NOCOPY VARCHAR2,
1491 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1492 );
1493
1494 /*#
1495 * Save Email Business Object (save_email_bo)
1496 * Saves a Email business object. You pass new or modified object data to the procedure, packaged within an object type
1497 * defined specifically for the API. The API then determines if the object exists in TCA, based upon the provided
1498 * identification information, and creates or updates the object. The object type is HZ_EMIAL_CP_BO for the Email
1499 * business object. For either case, the object type that you provide will be processed as if the respective API procedure
1500 * is being called (create_email_bo or update_email_bo). Please see those procedures for more details. In addition to
1501 * the object's business object attributes, the object type also includes embedded child business entities or objects
1502 * that can be simultaneously created or updated.
1503 *
1504 * @param p_return_obj_flag Indicates if the saved object is to be returned to the caller as an output parameter. Default value: false
1505 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness if it is being created
1506 * @param p_email_obj The Email business object to be saved
1507 * @param p_created_by_module The module saving this business object
1508 * @param p_obj_source The source of this business object
1509 * @param x_return_status Return status after the call
1510 * @param x_return_obj The Email business object that was saved, returned as an output parameter
1511 * @param x_messages Messages returned from the save of the business object
1512 * @param x_email_id TCA identifier for the Email business object
1513 * @param x_email_os Email original system name
1514 * @param x_email_osr Email original system reference
1515 * @param px_parent_id TCA identifier for parent object. Either this parameter, or both the px_parent_os and px_parent_osr parameters, must be given
1516 * @param px_parent_os Parent object original system name
1517 * @param px_parent_osr Parent object original system reference
1518 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
1519 * @rep:scope public
1520 * @rep:lifecycle active
1521 * @rep:displayname Save Email Business Object
1522 * @rep:doccd 120hztig.pdf Save Email Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1523 */
1524 PROCEDURE save_email_bo(
1525 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1526 p_email_obj IN HZ_EMAIL_CP_BO,
1527 p_created_by_module IN VARCHAR2,
1528 p_obj_source IN VARCHAR2 := null,
1529 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1530 x_return_status OUT NOCOPY VARCHAR2,
1531 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1532 x_return_obj OUT NOCOPY HZ_EMAIL_CP_BO,
1533 x_email_id OUT NOCOPY NUMBER,
1534 x_email_os OUT NOCOPY VARCHAR2,
1535 x_email_osr OUT NOCOPY VARCHAR2,
1536 px_parent_id IN OUT NOCOPY NUMBER,
1537 px_parent_os IN OUT NOCOPY VARCHAR2,
1538 px_parent_osr IN OUT NOCOPY VARCHAR2,
1539 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1540 );
1541
1542 -- PROCEDURE save_web_bo
1543 --
1544 -- DESCRIPTION
1545 -- Create or update a logical web contact point.
1546 --
1547 -- ARGUMENTS
1548 -- IN:
1549 -- p_init_msg_list Initialize message stack if it is set to
1553 -- p_web_obj Web business object.
1550 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1551 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
1552 -- the completeness of business object.
1554 -- p_created_by_module Created by module.
1555 -- IN/OUT:
1556 -- px_parent_id Parent record ID.
1557 -- px_parent_os Parent orig system.
1558 -- px_parent_osr Parent orig system reference.
1559 -- px_parent_obj_type Parent object type.
1560 -- OUT:
1561 -- x_return_status Return status after the call. The status can
1562 -- be fnd_api.g_ret_sts_success (success),
1563 -- fnd_api.g_ret_sts_error (error),
1564 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1565 -- x_msg_count Number of messages in message stack.
1566 -- x_msg_data Message text if x_msg_count is 1.
1567 -- x_web_id Contact point ID.
1568 -- x_web_os Contact point orig system.
1569 -- x_web_osr Contact point orig system reference.
1570 --
1571 -- NOTES
1572 --
1573 -- MODIFICATION HISTORY
1574 --
1575 -- 14-DEC-2004 Arnold Ng Created.
1576
1577 PROCEDURE save_web_bo(
1578 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1579 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1580 p_web_obj IN HZ_WEB_CP_BO,
1581 p_created_by_module IN VARCHAR2,
1582 x_return_status OUT NOCOPY VARCHAR2,
1583 x_msg_count OUT NOCOPY NUMBER,
1584 x_msg_data OUT NOCOPY VARCHAR2,
1585 x_web_id OUT NOCOPY NUMBER,
1586 x_web_os OUT NOCOPY VARCHAR2,
1587 x_web_osr OUT NOCOPY VARCHAR2,
1588 px_parent_id IN OUT NOCOPY NUMBER,
1589 px_parent_os IN OUT NOCOPY VARCHAR2,
1590 px_parent_osr IN OUT NOCOPY VARCHAR2,
1591 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1592 );
1593
1594 /*#
1595 * Save Web Business Object (save_web_bo)
1599 * object. For either case, the object type that you provide will be processed as if the respective API procedure is
1596 * Saves a Web business object. You pass new or modified object data to the procedure, packaged within an object type
1597 * defined specifically for the API. The API then determines if the object exists in TCA, based upon the provided
1598 * identification information, and creates or updates the object. The object type is HZ_WEB_CP_BO for the Web business
1600 * being called (create_web_bo or update_web_bo). Please see those procedures for more details. In addition to the
1601 * object's business object attributes, the object type also includes embedded child business entities or objects that
1602 * can be simultaneously created or updated.
1603 *
1604 * @param p_return_obj_flag Indicates if the saved object is to be returned to the caller as an output parameter. Default value: false
1605 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness if it is being created
1606 * @param p_web_obj The Web business object to be saved
1607 * @param p_created_by_module The module saving this business object
1608 * @param p_obj_source The source of this business object
1612 * @param x_web_id TCA identifier for the Web business object
1609 * @param x_return_status Return status after the call
1610 * @param x_return_obj The Web business object that was saved, returned as an output parameter
1611 * @param x_messages Messages returned from the save of the business object
1613 * @param x_web_os Web original system name
1614 * @param x_web_osr Web original system reference
1615 * @param px_parent_id TCA identifier for parent object. Either this parameter, or both the px_parent_os and px_parent_osr parameters, must be given
1616 * @param px_parent_os Parent object original system name
1617 * @param px_parent_osr Parent object original system reference
1618 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
1619 * @rep:scope public
1620 * @rep:lifecycle active
1621 * @rep:displayname Save Web Business Object
1622 * @rep:doccd 120hztig.pdf Save Web Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1623 */
1624 PROCEDURE save_web_bo(
1625 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1626 p_web_obj IN HZ_WEB_CP_BO,
1627 p_created_by_module IN VARCHAR2,
1628 p_obj_source IN VARCHAR2 := null,
1629 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1630 x_return_status OUT NOCOPY VARCHAR2,
1631 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1632 x_return_obj OUT NOCOPY HZ_WEB_CP_BO,
1633 x_web_id OUT NOCOPY NUMBER,
1634 x_web_os OUT NOCOPY VARCHAR2,
1635 x_web_osr OUT NOCOPY VARCHAR2,
1636 px_parent_id IN OUT NOCOPY NUMBER,
1637 px_parent_os IN OUT NOCOPY VARCHAR2,
1638 px_parent_osr IN OUT NOCOPY VARCHAR2,
1639 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1640 );
1641
1642 -- PROCEDURE save_edi_bo
1643 --
1644 -- DESCRIPTION
1645 -- Create or update a logical edi contact point.
1646 --
1647 -- ARGUMENTS
1648 -- IN:
1649 -- p_init_msg_list Initialize message stack if it is set to
1650 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1651 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
1652 -- the completeness of business object.
1653 -- p_edi_obj EDI business object.
1657 -- px_parent_os Parent orig system.
1654 -- p_created_by_module Created by module.
1655 -- IN/OUT:
1656 -- px_parent_id Parent record ID.
1658 -- px_parent_osr Parent orig system reference.
1659 -- px_parent_obj_type Parent object type.
1660 -- OUT:
1661 -- x_return_status Return status after the call. The status can
1662 -- be fnd_api.g_ret_sts_success (success),
1663 -- fnd_api.g_ret_sts_error (error),
1664 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1665 -- x_msg_count Number of messages in message stack.
1666 -- x_msg_data Message text if x_msg_count is 1.
1670 --
1667 -- x_edi_id Contact point ID.
1668 -- x_edi_os Contact point orig system.
1669 -- x_edi_osr Contact point orig system reference.
1671 -- NOTES
1672 --
1673 -- MODIFICATION HISTORY
1674 --
1675 -- 14-DEC-2004 Arnold Ng Created.
1676
1677 PROCEDURE save_edi_bo(
1678 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1679 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1680 p_edi_obj IN HZ_EDI_CP_BO,
1681 p_created_by_module IN VARCHAR2,
1682 x_return_status OUT NOCOPY VARCHAR2,
1683 x_msg_count OUT NOCOPY NUMBER,
1684 x_msg_data OUT NOCOPY VARCHAR2,
1685 x_edi_id OUT NOCOPY NUMBER,
1686 x_edi_os OUT NOCOPY VARCHAR2,
1687 x_edi_osr OUT NOCOPY VARCHAR2,
1688 px_parent_id IN OUT NOCOPY NUMBER,
1689 px_parent_os IN OUT NOCOPY VARCHAR2,
1690 px_parent_osr IN OUT NOCOPY VARCHAR2,
1691 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1692 );
1693
1694 /*#
1695 * Save EDI Business Object (save_edi_bo)
1696 * Saves a EDI business object. You pass new or modified object data to the procedure, packaged within an object type
1697 * defined specifically for the API. The API then determines if the object exists in TCA, based upon the provided
1698 * identification information, and creates or updates the object. The object type is HZ_EDI_CP_BO for the EDI business
1699 * object. For either case, the object type that you provide will be processed as if the respective API procedure is
1700 * being called (create_edi_bo or update_edi_bo). Please see those procedures for more details. In addition to the
1701 * object's business object attributes, the object type also includes embedded child business entities or objects that
1702 * can be simultaneously created or updated.
1703 *
1704 * @param p_return_obj_flag Indicates if the saved object is to be returned to the caller as an output parameter. Default value: false
1705 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness if it is being created
1706 * @param p_edi_obj The EDI business object to be saved
1707 * @param p_created_by_module The module saving this business object
1708 * @param p_obj_source The source of this business object
1709 * @param x_return_status Return status after the call
1710 * @param x_return_obj The EDI business object that was saved, returned as an output parameter
1711 * @param x_messages Messages returned from the save of the business object
1712 * @param x_edi_id TCA identifier for the EDI business object
1713 * @param x_edi_os EDI original system name
1714 * @param x_edi_osr EDI original system reference
1715 * @param px_parent_id TCA identifier for parent object. Either this parameter, or both the px_parent_os and px_parent_osr parameters, must be given
1716 * @param px_parent_os Parent object original system name
1717 * @param px_parent_osr Parent object original system reference
1718 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
1719 * @rep:scope public
1720 * @rep:lifecycle active
1721 * @rep:displayname Save EDI Business Object
1722 * @rep:doccd 120hztig.pdf Save EDI Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1723 */
1724 PROCEDURE save_edi_bo(
1725 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1726 p_edi_obj IN HZ_EDI_CP_BO,
1727 p_created_by_module IN VARCHAR2,
1728 p_obj_source IN VARCHAR2 := null,
1729 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1730 x_return_status OUT NOCOPY VARCHAR2,
1731 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1732 x_return_obj OUT NOCOPY HZ_EDI_CP_BO,
1733 x_edi_id OUT NOCOPY NUMBER,
1734 x_edi_os OUT NOCOPY VARCHAR2,
1735 x_edi_osr OUT NOCOPY VARCHAR2,
1736 px_parent_id IN OUT NOCOPY NUMBER,
1737 px_parent_os IN OUT NOCOPY VARCHAR2,
1738 px_parent_osr IN OUT NOCOPY VARCHAR2,
1739 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1740 );
1741
1742 -- PROCEDURE save_eft_bo
1743 --
1744 -- DESCRIPTION
1745 -- Create or update a logical eft contact point.
1746 --
1747 -- ARGUMENTS
1748 -- IN:
1749 -- p_init_msg_list Initialize message stack if it is set to
1750 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1751 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
1752 -- the completeness of business object.
1753 -- p_eft_obj EFT business object.
1754 -- p_created_by_module Created by module.
1755 -- IN/OUT:
1756 -- px_parent_id Parent record ID.
1757 -- px_parent_os Parent orig system.
1758 -- px_parent_osr Parent orig system reference.
1759 -- px_parent_obj_type Parent object type.
1760 -- OUT:
1761 -- x_return_status Return status after the call. The status can
1762 -- be fnd_api.g_ret_sts_success (success),
1763 -- fnd_api.g_ret_sts_error (error),
1764 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1765 -- x_msg_count Number of messages in message stack.
1769 -- x_eft_osr Contact point orig system reference.
1766 -- x_msg_data Message text if x_msg_count is 1.
1767 -- x_eft_id Contact point ID.
1768 -- x_eft_os Contact point orig system.
1770 --
1771 -- NOTES
1772 --
1773 -- MODIFICATION HISTORY
1774 --
1775 -- 14-DEC-2004 Arnold Ng Created.
1776
1777 PROCEDURE save_eft_bo(
1778 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1779 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1780 p_eft_obj IN HZ_EFT_CP_BO,
1781 p_created_by_module IN VARCHAR2,
1782 x_return_status OUT NOCOPY VARCHAR2,
1783 x_msg_count OUT NOCOPY NUMBER,
1784 x_msg_data OUT NOCOPY VARCHAR2,
1785 x_eft_id OUT NOCOPY NUMBER,
1786 x_eft_os OUT NOCOPY VARCHAR2,
1787 x_eft_osr OUT NOCOPY VARCHAR2,
1788 px_parent_id IN OUT NOCOPY NUMBER,
1789 px_parent_os IN OUT NOCOPY VARCHAR2,
1790 px_parent_osr IN OUT NOCOPY VARCHAR2,
1791 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1792 );
1793
1794 /*#
1795 * Save EFT Business Object (save_eft_bo)
1796 * Saves a EFT business object. You pass new or modified object data to the procedure, packaged within an object type
1797 * defined specifically for the API. The API then determines if the object exists in TCA, based upon the provided
1798 * identification information, and creates or updates the object. The object type is HZ_EFT_CP_BO for the EFT business
1799 * object. For either case, the object type that you provide will be processed as if the respective API procedure is
1800 * being called (create_eft_bo or update_eft_bo). Please see those procedures for more details. In addition to the
1801 * object's business object attributes, the object type also includes embedded child business entities or objects that
1805 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness if it is being created
1802 * can be simultaneously created or updated.
1803 *
1804 * @param p_return_obj_flag Indicates if the saved object is to be returned to the caller as an output parameter. Default value: false
1806 * @param p_eft_obj The EFT business object to be saved
1807 * @param p_created_by_module The module saving this business object
1808 * @param p_obj_source The source of this business object
1809 * @param x_return_status Return status after the call
1810 * @param x_return_obj The EFT business object that was saved, returned as an output parameter
1811 * @param x_messages Messages returned from the save of the business object
1812 * @param x_eft_id TCA identifier for the EFT business object
1813 * @param x_eft_os EFT original system name
1814 * @param x_eft_osr EFT original system reference
1818 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
1815 * @param px_parent_id TCA identifier for parent object. Either this parameter, or both the px_parent_os and px_parent_osr parameters, must be given
1816 * @param px_parent_os Parent object original system name
1817 * @param px_parent_osr Parent object original system reference
1819 * @rep:scope public
1820 * @rep:lifecycle active
1821 * @rep:displayname Save EFT Business Object
1822 * @rep:doccd 120hztig.pdf Save EFT Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1823 */
1824 PROCEDURE save_eft_bo(
1825 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1826 p_eft_obj IN HZ_EFT_CP_BO,
1827 p_created_by_module IN VARCHAR2,
1828 p_obj_source IN VARCHAR2 := null,
1829 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1830 x_return_status OUT NOCOPY VARCHAR2,
1831 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1832 x_return_obj OUT NOCOPY HZ_EFT_CP_BO,
1833 x_eft_id OUT NOCOPY NUMBER,
1834 x_eft_os OUT NOCOPY VARCHAR2,
1835 x_eft_osr OUT NOCOPY VARCHAR2,
1836 px_parent_id IN OUT NOCOPY NUMBER,
1837 px_parent_os IN OUT NOCOPY VARCHAR2,
1838 px_parent_osr IN OUT NOCOPY VARCHAR2,
1839 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1840 );
1841
1842 -- PROCEDURE save_sms_bo
1843 --
1844 -- DESCRIPTION
1845 -- Create or update a logical sms contact point.
1846 --
1847 -- ARGUMENTS
1848 -- IN:
1849 -- p_init_msg_list Initialize message stack if it is set to
1850 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1851 -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
1852 -- the completeness of business object.
1853 -- p_sms_obj SMS business object.
1854 -- p_created_by_module Created by module.
1855 -- IN/OUT:
1856 -- px_parent_id Parent record ID.
1857 -- px_parent_os Parent orig system.
1858 -- px_parent_osr Parent orig system reference.
1859 -- px_parent_obj_type Parent object type.
1860 -- OUT:
1861 -- x_return_status Return status after the call. The status can
1862 -- be fnd_api.g_ret_sts_success (success),
1863 -- fnd_api.g_ret_sts_error (error),
1864 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1865 -- x_msg_count Number of messages in message stack.
1866 -- x_msg_data Message text if x_msg_count is 1.
1867 -- x_sms_id Contact point ID.
1868 -- x_sms_os Contact point orig system.
1869 -- x_sms_osr Contact point orig system reference.
1870 --
1871 -- NOTES
1872 --
1873 -- MODIFICATION HISTORY
1874 --
1875 -- 14-DEC-2004 Arnold Ng Created.
1876
1877 PROCEDURE save_sms_bo(
1878 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1879 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1880 p_sms_obj IN HZ_SMS_CP_BO,
1881 p_created_by_module IN VARCHAR2,
1882 x_return_status OUT NOCOPY VARCHAR2,
1883 x_msg_count OUT NOCOPY NUMBER,
1884 x_msg_data OUT NOCOPY VARCHAR2,
1885 x_sms_id OUT NOCOPY NUMBER,
1886 x_sms_os OUT NOCOPY VARCHAR2,
1887 x_sms_osr OUT NOCOPY VARCHAR2,
1888 px_parent_id IN OUT NOCOPY NUMBER,
1889 px_parent_os IN OUT NOCOPY VARCHAR2,
1890 px_parent_osr IN OUT NOCOPY VARCHAR2,
1891 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1892 );
1893
1894 /*#
1895 * Save SMS Business Object (save_sms_bo)
1896 * Saves a SMS business object. You pass new or modified object data to the procedure, packaged within an object type
1897 * defined specifically for the API. The API then determines if the object exists in TCA, based upon the provided
1898 * identification information, and creates or updates the object. The object type is HZ_SMS_CP_BO for the SMS business
1899 * object. For either case, the object type that you provide will be processed as if the respective API procedure is
1900 * being called (create_sms_bo or update_sms_bo). Please see those procedures for more details. In addition to the
1901 * object's business object attributes, the object type also includes embedded child business entities or objects that
1902 * can be simultaneously created or updated.
1903 *
1904 * @param p_return_obj_flag Indicates if the saved object is to be returned to the caller as an output parameter. Default value: false
1905 * @param p_validate_bo_flag Indicates if the passed business object is to be validated for completeness if it is being created
1906 * @param p_sms_obj The SMS business object to be saved
1907 * @param p_created_by_module The module saving this business object
1908 * @param p_obj_source The source of this business object
1909 * @param x_return_status Return status after the call
1910 * @param x_return_obj The SMS business object that was saved, returned as an output parameter
1911 * @param x_messages Messages returned from the save of the business object
1912 * @param x_sms_id TCA identifier for the SMS business object
1913 * @param x_sms_os SMS original system name
1914 * @param x_sms_osr SMS original system reference
1915 * @param px_parent_id TCA identifier for parent object. Either this parameter, or both the px_parent_os and px_parent_osr parameters, must be given
1916 * @param px_parent_os Parent object original system name
1917 * @param px_parent_osr Parent object original system reference
1921 * @rep:displayname Save SMS Business Object
1918 * @param px_parent_obj_type Parent object type. Validated against HZ_BUSINESS_OBJECTS lookup type
1919 * @rep:scope public
1920 * @rep:lifecycle active
1922 * @rep:doccd 120hztig.pdf Save SMS Business Object, Oracle Trading Community Architecture Technical Implementation Guide
1923 */
1924 PROCEDURE save_sms_bo(
1925 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1926 p_sms_obj IN HZ_SMS_CP_BO,
1927 p_created_by_module IN VARCHAR2,
1928 p_obj_source IN VARCHAR2 := null,
1929 p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1930 x_return_status OUT NOCOPY VARCHAR2,
1931 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1932 x_return_obj OUT NOCOPY HZ_SMS_CP_BO,
1933 x_sms_id OUT NOCOPY NUMBER,
1934 x_sms_os OUT NOCOPY VARCHAR2,
1935 x_sms_osr OUT NOCOPY VARCHAR2,
1936 px_parent_id IN OUT NOCOPY NUMBER,
1937 px_parent_os IN OUT NOCOPY VARCHAR2,
1938 px_parent_osr IN OUT NOCOPY VARCHAR2,
1939 px_parent_obj_type IN OUT NOCOPY VARCHAR2
1940 );
1941
1942 /*
1943 The Get Contact Point API Procedures are retrieval services that return a full Contact Point business object of the type specified.
1944 The user identifies a particular Contact Point business object using the TCA identifier and/or the objects Source System information.
1945 Upon proper validation of the object, the full Contact Point business object is returned. The object consists of all data included
1949 To retrieve the appropriate embedded entities within the Contact Point business objects, the Get procedure returns all records for the
1946 within the Contact Point business object, at all embedded levels. This includes the set of all data stored in the TCA tables for each
1947 embedded entity.
1948
1950 particular object from these TCA entity tables.
1951
1952 Embedded BO Mandatory Multiple Logical API Procedure Comments
1953
1954 Contact Point Y N HZ_CONTACT_POINTS
1955 Contact Preference N Y HZ_CONTACT_PREFERENCES
1956
1957 */
1958
1959
1960 --------------------------------------
1961 --
1962 -- PROCEDURE get_phone_bo
1963 --
1964 -- DESCRIPTION
1965 -- Get a logical phone.
1966 --
1967 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1968 --
1969 -- ARGUMENTS
1970 -- IN:
1971 -- p_init_msg_list Initialize message stack if it is set to
1972 -- p_phone_id phone ID.If this id passed in, return only one phone obj.
1973 -- p_phone_os phone orig system.
1974 -- p_phone_osr phone orig system reference.
1975 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1976 -- OUT:
1977 -- x_phone_obj Logical phone record.
1978 -- x_return_status Return status after the call. The status can
1979 -- be fnd_api.g_ret_sts_success (success),
1980 -- fnd_api.g_ret_sts_error (error),
1981 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1982 -- x_msg_count Number of messages in message stack.
1983 -- x_msg_data Message text if x_msg_count is 1.
1984 --
1985 -- NOTES
1986 --
1987 -- MODIFICATION HISTORY
1988 --
1989 --
1990 -- 30-May-2005 AWU Created.
1991 --
1992
1993
1994 PROCEDURE get_phone_bo (
1995 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1996 p_phone_id IN NUMBER,
1997 p_phone_os IN VARCHAR2,
1998 p_phone_osr IN VARCHAR2,
1999 x_phone_obj OUT NOCOPY HZ_PHONE_CP_BO,
2000 x_return_status OUT NOCOPY VARCHAR2,
2001 x_msg_count OUT NOCOPY NUMBER,
2002 x_msg_data OUT NOCOPY VARCHAR2
2003 );
2004
2005 /*#
2006 * Get Phone Business Object (get_phone_cp_bo)
2007 * Extracts a particular Phone business object from TCA. You pass the object's identification information to the procedure, and the procedure returns the identified business object as it exists in TCA.
2008 *
2009 * @param p_phone_id TCA identifier for the Phone business object
2010 * @param p_phone_os Phone original system name
2011 * @param p_phone_osr Phone original system reference
2012 * @param x_phone_obj The retrieved Phone business object
2013 * @param x_return_status Return status after the call
2014 * @param x_messages Messages returned from the retrieval of the business object
2015 * @rep:scope public
2016 * @rep:lifecycle active
2017 * @rep:displayname Get Phone Business Object
2018 * @rep:doccd 120hztig.pdf Get Phone Business Object, Oracle Trading Community Architecture Technical Implementation Guide
2019 */
2020 PROCEDURE get_phone_bo (
2024 x_phone_obj OUT NOCOPY HZ_PHONE_CP_BO,
2021 p_phone_id IN NUMBER,
2022 p_phone_os IN VARCHAR2,
2023 p_phone_osr IN VARCHAR2,
2025 x_return_status OUT NOCOPY VARCHAR2,
2026 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
2027 );
2028
2029 --------------------------------------
2030 --
2031 -- PROCEDURE get_telex_bo
2032 --
2033 -- DESCRIPTION
2034 -- Get a logical telex.
2035 --
2036 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2037 --
2038 -- ARGUMENTS
2039 -- IN:
2040 -- p_init_msg_list Initialize message stack if it is set to
2041 -- p_telex_id telex ID.If this id passed in, return only one telex obj.
2042 -- p_telex_os telex orig system.
2043 -- p_telex_osr telex orig system reference.
2044 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2045 -- OUT:
2046 -- x_telex_obj Logical telex record.
2047 -- x_return_status Return status after the call. The status can
2048 -- be fnd_api.g_ret_sts_success (success),
2049 -- fnd_api.g_ret_sts_error (error),
2050 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2051 -- x_msg_count Number of messages in message stack.
2052 -- x_msg_data Message text if x_msg_count is 1.
2053 --
2054 -- NOTES
2055 --
2056 -- MODIFICATION HISTORY
2057 --
2058 --
2059 -- 30-May-2005 AWU Created.
2060 --
2061
2062
2063 PROCEDURE get_telex_bo (
2064 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2065 p_telex_id IN NUMBER,
2066 p_telex_os IN VARCHAR2,
2067 p_telex_osr IN VARCHAR2,
2068 x_telex_obj OUT NOCOPY HZ_TELEX_CP_BO,
2069 x_return_status OUT NOCOPY VARCHAR2,
2070 x_msg_count OUT NOCOPY NUMBER,
2071 x_msg_data OUT NOCOPY VARCHAR2
2072 );
2073
2074 /*#
2075 * Get Telex Business Object (get_telex_bo)
2076 * Extracts a particular Telex business object from TCA. You pass the object's identification information to the procedure, and the procedure returns the identified business object as it exists in TCA.
2077 *
2078 * @param p_telex_id TCA identifier for the Telex business object
2079 * @param p_telex_os Telex original system name
2083 * @param x_messages Messages returned from the retrieval of the business object
2080 * @param p_telex_osr Telex original system reference
2081 * @param x_telex_obj The retrieved Telex business object
2082 * @param x_return_status Return status after the call
2084 * @rep:scope public
2085 * @rep:lifecycle active
2086 * @rep:displayname Get Telex Business Object
2087 * @rep:doccd 120hztig.pdf Get Telex Business Object, Oracle Trading Community Architecture Technical Implementation Guide
2088 */
2089 PROCEDURE get_telex_bo (
2090 p_telex_id IN NUMBER,
2091 p_telex_os IN VARCHAR2,
2092 p_telex_osr IN VARCHAR2,
2093 x_telex_obj OUT NOCOPY HZ_TELEX_CP_BO,
2094 x_return_status OUT NOCOPY VARCHAR2,
2095 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
2096 );
2097
2098 --------------------------------------
2099 --
2100 -- PROCEDURE get_email_bo
2101 --
2102 -- DESCRIPTION
2103 -- Get a logical email.
2104 --
2105 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2106 --
2107 -- ARGUMENTS
2108 -- IN:
2109 -- p_init_msg_list Initialize message stack if it is set to
2110 -- p_email_id email ID.If this id passed in, return only one email obj.
2111 -- p_email_os email orig system.
2112 -- p_email_osr email orig system reference.
2113 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2114 -- OUT:
2115 -- x_email_obj Logical email record.
2116 -- x_return_status Return status after the call. The status can
2117 -- be fnd_api.g_ret_sts_success (success),
2118 -- fnd_api.g_ret_sts_error (error),
2119 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2120 -- x_msg_count Number of messages in message stack.
2121 -- x_msg_data Message text if x_msg_count is 1.
2122 --
2123 -- NOTES
2124 --
2125 -- MODIFICATION HISTORY
2126 --
2127 --
2128 -- 30-May-2005 AWU Created.
2129 --
2130
2131
2132 PROCEDURE get_email_bo (
2133 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2134 p_email_id IN NUMBER,
2135 p_email_os IN VARCHAR2,
2136 p_email_osr IN VARCHAR2,
2137 x_email_obj OUT NOCOPY HZ_EMAIL_CP_BO,
2138 x_return_status OUT NOCOPY VARCHAR2,
2139 x_msg_count OUT NOCOPY NUMBER,
2140 x_msg_data OUT NOCOPY VARCHAR2
2141 );
2142
2143 /*#
2144 * Get Email Business Object (get_email_bo)
2145 * Extracts a particular Email business object from TCA. You pass the object's identification information to the procedure, and the procedure returns the identified business object as it exists in TCA.
2146 *
2147 * @param p_email_id TCA identifier for the Email business object
2148 * @param p_email_os Email original system name
2149 * @param p_email_osr Email original system reference
2150 * @param x_email_obj The retrieved Email business object
2151 * @param x_return_status Return status after the call
2152 * @param x_messages Messages returned from the retrieval of the business object
2153 * @rep:scope public
2154 * @rep:lifecycle active
2155 * @rep:displayname Get Email Business Object
2156 * @rep:doccd 120hztig.pdf Get Email Business Object, Oracle Trading Community Architecture Technical Implementation Guide
2157 */
2158 PROCEDURE get_email_bo (
2159 p_email_id IN NUMBER,
2160 p_email_os IN VARCHAR2,
2161 p_email_osr IN VARCHAR2,
2165 );
2162 x_email_obj OUT NOCOPY HZ_EMAIL_CP_BO,
2163 x_return_status OUT NOCOPY VARCHAR2,
2164 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
2166
2167 --------------------------------------
2168 --
2169 -- PROCEDURE get_web_bo
2170 --
2171 -- DESCRIPTION
2172 -- Get a logical web.
2173 --
2174 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2175 --
2176 -- ARGUMENTS
2177 -- IN:
2178 -- p_init_msg_list Initialize message stack if it is set to
2179 -- p_web_id web ID.If this id passed in, return only one web obj.
2180 -- p_web_os web orig system.
2181 -- p_web_osr web orig system reference.
2182 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2183 -- OUT:
2184 -- x_web_obj Logical web record.
2185 -- x_return_status Return status after the call. The status can
2186 -- be fnd_api.g_ret_sts_success (success),
2187 -- fnd_api.g_ret_sts_error (error),
2188 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2189 -- x_msg_count Number of messages in message stack.
2190 -- x_msg_data Message text if x_msg_count is 1.
2191 --
2192 -- NOTES
2193 --
2194 -- MODIFICATION HISTORY
2195 --
2196 --
2197 -- 30-May-2005 AWU Created.
2198 --
2199
2200
2201 PROCEDURE get_web_bo (
2202 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2203 p_web_id IN NUMBER,
2204 p_web_os IN VARCHAR2,
2205 p_web_osr IN VARCHAR2,
2206 x_web_obj OUT NOCOPY HZ_WEB_CP_BO,
2207 x_return_status OUT NOCOPY VARCHAR2,
2208 x_msg_count OUT NOCOPY NUMBER,
2209 x_msg_data OUT NOCOPY VARCHAR2
2210 );
2211
2212 /*#
2213 * Get Web Business Object (get_web_bo)
2214 * Extracts a particular Web business object from TCA. You pass the object's identification information to the procedure, and the procedure returns the identified business object as it exists in TCA.
2215 *
2216 * @param p_web_id TCA identifier for the Web business object
2217 * @param p_web_os Web original system name
2218 * @param p_web_osr Web original system reference
2219 * @param x_web_obj The retrieved Web business object
2220 * @param x_return_status Return status after the call
2224 * @rep:displayname Get Web Business Object
2221 * @param x_messages Messages returned from the retrieval of the business object
2222 * @rep:scope public
2223 * @rep:lifecycle active
2225 * @rep:doccd 120hztig.pdf Get Web Business Object, Oracle Trading Community Architecture Technical Implementation Guide
2226 */
2227 PROCEDURE get_web_bo (
2228 p_web_id IN NUMBER,
2229 p_web_os IN VARCHAR2,
2230 p_web_osr IN VARCHAR2,
2231 x_web_obj OUT NOCOPY HZ_WEB_CP_BO,
2235
2232 x_return_status OUT NOCOPY VARCHAR2,
2233 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
2234 );
2236 --------------------------------------
2237 --
2238 -- PROCEDURE get_edi_bo
2239 --
2240 -- DESCRIPTION
2241 -- Get a logical edi.
2242 --
2243 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2244 --
2245 -- ARGUMENTS
2246 -- IN:
2247 -- p_init_msg_list Initialize message stack if it is set to
2248 -- p_edi_id edi ID.If this id passed in, return only one edi obj.
2249 -- p_edi_os edi orig system.
2250 -- p_edi_osr edi orig system reference.
2251 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2252 -- OUT:
2253 -- x_edi_obj Logical edi record.
2254 -- x_return_status Return status after the call. The status can
2255 -- be fnd_api.g_ret_sts_success (success),
2256 -- fnd_api.g_ret_sts_error (error),
2257 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2258 -- x_msg_count Number of messages in message stack.
2259 -- x_msg_data Message text if x_msg_count is 1.
2260 --
2261 -- NOTES
2262 --
2263 -- MODIFICATION HISTORY
2264 --
2265 --
2266 -- 30-May-2005 AWU Created.
2267 --
2268
2269
2270 PROCEDURE get_edi_bo (
2271 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2272 p_edi_id IN NUMBER,
2273 p_edi_os IN VARCHAR2,
2274 p_edi_osr IN VARCHAR2,
2275 x_edi_obj OUT NOCOPY HZ_EDI_CP_BO,
2276 x_return_status OUT NOCOPY VARCHAR2,
2277 x_msg_count OUT NOCOPY NUMBER,
2278 x_msg_data OUT NOCOPY VARCHAR2
2279 );
2280
2281 /*#
2282 * Get EDI Business Object (get_edi_bo)
2283 * Extracts a particular EDI business object from TCA. You pass the object's identification information to the procedure, and the procedure returns the identified business object as it exists in TCA.
2284 *
2285 * @param p_edi_id TCA identifier for the EDI business object
2286 * @param p_edi_os EDI original system name
2287 * @param p_edi_osr EDI original system reference
2288 * @param x_edi_obj The retrieved EDI business object
2289 * @param x_return_status Return status after the call
2290 * @param x_messages Messages returned from the retrieval of the business object
2291 * @rep:scope public
2292 * @rep:lifecycle active
2293 * @rep:displayname Get EDI Business Object
2294 * @rep:doccd 120hztig.pdf Get EDI Business Object, Oracle Trading Community Architecture Technical Implementation Guide
2295 */
2296 PROCEDURE get_edi_bo (
2297 p_edi_id IN NUMBER,
2298 p_edi_os IN VARCHAR2,
2299 p_edi_osr IN VARCHAR2,
2300 x_edi_obj OUT NOCOPY HZ_EDI_CP_BO,
2301 x_return_status OUT NOCOPY VARCHAR2,
2302 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
2303 );
2304
2305 --------------------------------------
2306 --
2307 -- PROCEDURE get_eft_bo
2308 --
2309 -- DESCRIPTION
2310 -- Get a logical eft.
2311 --
2312 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2313 --
2314 -- ARGUMENTS
2315 -- IN:
2316 -- p_init_msg_list Initialize message stack if it is set to
2320 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2317 -- p_eft_id eft ID.If this id passed in, return only one eft obj.
2318 -- p_eft_os eft orig system.
2319 -- p_eft_osr eft orig system reference.
2321 -- OUT:
2322 -- x_eft_obj Logical eft record.
2323 -- x_return_status Return status after the call. The status can
2324 -- be fnd_api.g_ret_sts_success (success),
2325 -- fnd_api.g_ret_sts_error (error),
2326 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2327 -- x_msg_count Number of messages in message stack.
2328 -- x_msg_data Message text if x_msg_count is 1.
2329 --
2330 -- NOTES
2331 --
2332 -- MODIFICATION HISTORY
2333 --
2334 --
2335 -- 30-May-2005 AWU Created.
2336 --
2337
2338
2339 PROCEDURE get_eft_bo (
2340 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2341 p_eft_id IN NUMBER,
2342 p_eft_os IN VARCHAR2,
2343 p_eft_osr IN VARCHAR2,
2344 x_eft_obj OUT NOCOPY HZ_EFT_CP_BO,
2345 x_return_status OUT NOCOPY VARCHAR2,
2346 x_msg_count OUT NOCOPY NUMBER,
2347 x_msg_data OUT NOCOPY VARCHAR2
2348 );
2349
2350 /*#
2351 * Get EFT Business Object (get_eft_bo)
2352 * Extracts a particular EFT business object from TCA. You pass the object's identification information to the procedure, and the procedure returns the identified business object as it exists in TCA.
2353 *
2354 * @param p_eft_id TCA identifier for the EFT business object
2355 * @param p_eft_os EFT original system name
2356 * @param p_eft_osr EFT original system reference
2357 * @param x_eft_obj The retrieved EFT business object
2358 * @param x_return_status Return status after the call
2359 * @param x_messages Messages returned from the retrieval of the business object
2360 * @rep:scope public
2361 * @rep:lifecycle active
2362 * @rep:displayname Get EFT Business Object
2363 * @rep:doccd 120hztig.pdf Get EFT Business Object, Oracle Trading Community Architecture Technical Implementation Guide
2364 */
2365 PROCEDURE get_eft_bo (
2366 p_eft_id IN NUMBER,
2367 p_eft_os IN VARCHAR2,
2368 p_eft_osr IN VARCHAR2,
2369 x_eft_obj OUT NOCOPY HZ_EFT_CP_BO,
2370 x_return_status OUT NOCOPY VARCHAR2,
2371 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
2372 );
2373
2374 --------------------------------------
2375 --
2376 -- PROCEDURE get_sms_bo
2377 --
2378 -- DESCRIPTION
2379 -- Get a logical sms.
2380 --
2384 -- IN:
2381 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2382 --
2383 -- ARGUMENTS
2385 -- p_init_msg_list Initialize message stack if it is set to
2386 -- p_sms_id sms ID.If this id passed in, return only one sms obj.
2387 -- p_sms_os sms orig system.
2388 -- p_sms_osr sms orig system reference.
2389 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2390 -- OUT:
2391 -- x_sms_objs Logical sms records.
2392 -- x_return_status Return status after the call. The status can
2393 -- be fnd_api.g_ret_sts_success (success),
2394 -- fnd_api.g_ret_sts_error (error),
2395 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2396 -- x_msg_count Number of messages in message stack.
2397 -- x_msg_data Message text if x_msg_count is 1.
2398 --
2399 -- NOTES
2400 --
2401 -- MODIFICATION HISTORY
2402 --
2403 --
2404 -- 30-May-2005 AWU Created.
2405 --
2406
2407
2408 PROCEDURE get_sms_bo (
2409 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2410 p_sms_id IN NUMBER,
2411 p_sms_os IN VARCHAR2,
2412 p_sms_osr IN VARCHAR2,
2413 x_sms_obj OUT NOCOPY HZ_SMS_CP_BO,
2414 x_return_status OUT NOCOPY VARCHAR2,
2415 x_msg_count OUT NOCOPY NUMBER,
2416 x_msg_data OUT NOCOPY VARCHAR2
2417 );
2418
2419 /*#
2420 * Get SMS Business Object (get_sms_bo)
2421 * Extracts a particular SMS business object from TCA. You pass the object's identification information to the procedure, and the procedure returns the identified business object as it exists in TCA.
2422 *
2423 * @param p_sms_id TCA identifier for the SMS business object
2424 * @param p_sms_os SMS original system name
2425 * @param p_sms_osr SMS original system reference
2426 * @param x_sms_obj The retrieved SMS business object
2427 * @param x_return_status Return status after the call
2428 * @param x_messages Messages returned from the retrieval of the business object
2429 * @rep:scope public
2430 * @rep:lifecycle active
2431 * @rep:displayname Get SMS Business Object
2432 * @rep:doccd 120hztig.pdf Get SMS Business Object, Oracle Trading Community Architecture Technical Implementation Guide
2433 */
2434 PROCEDURE get_sms_bo (
2435 p_sms_id IN NUMBER,
2436 p_sms_os IN VARCHAR2,
2437 p_sms_osr IN VARCHAR2,
2438 x_sms_obj OUT NOCOPY HZ_SMS_CP_BO,
2439 x_return_status OUT NOCOPY VARCHAR2,
2440 x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
2441 );
2442
2443 PROCEDURE do_create_contact_point(
2444 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2445 p_validate_bo_flag IN VARCHAR2 := FND_API.G_TRUE,
2446 p_cp_id IN NUMBER,
2447 p_cp_os IN VARCHAR2,
2448 p_cp_osr IN VARCHAR2,
2449 p_phone_obj IN HZ_PHONE_CP_BO,
2450 p_email_obj IN HZ_EMAIL_CP_BO,
2451 p_telex_obj IN HZ_TELEX_CP_BO,
2452 p_web_obj IN HZ_WEB_CP_BO,
2453 p_edi_obj IN HZ_EDI_CP_BO,
2454 p_eft_obj IN HZ_EFT_CP_BO,
2455 p_sms_obj IN HZ_SMS_CP_BO,
2456 p_cp_pref_objs IN OUT NOCOPY HZ_CONTACT_PREF_OBJ_TBL,
2457 p_cp_type IN VARCHAR2,
2458 p_created_by_module IN VARCHAR2,
2459 p_obj_source IN VARCHAR2 := null,
2460 x_return_status OUT NOCOPY VARCHAR2,
2461 x_msg_count OUT NOCOPY NUMBER,
2462 x_msg_data OUT NOCOPY VARCHAR2,
2463 x_cp_id OUT NOCOPY NUMBER,
2464 x_cp_os OUT NOCOPY VARCHAR2,
2468 px_parent_osr IN OUT NOCOPY VARCHAR2,
2465 x_cp_osr OUT NOCOPY VARCHAR2,
2466 px_parent_id IN OUT NOCOPY NUMBER,
2467 px_parent_os IN OUT NOCOPY VARCHAR2,
2469 px_parent_obj_type IN OUT NOCOPY VARCHAR2
2470 );
2471
2472 PROCEDURE do_update_contact_point (
2473 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
2474 p_cp_id IN NUMBER,
2475 p_cp_os IN VARCHAR2,
2476 p_cp_osr IN VARCHAR2,
2477 p_phone_obj IN HZ_PHONE_CP_BO,
2478 p_email_obj IN HZ_EMAIL_CP_BO,
2479 p_telex_obj IN HZ_TELEX_CP_BO,
2480 p_web_obj IN HZ_WEB_CP_BO,
2481 p_edi_obj IN HZ_EDI_CP_BO,
2482 p_eft_obj IN HZ_EFT_CP_BO,
2483 p_sms_obj IN HZ_SMS_CP_BO,
2484 p_cp_pref_objs IN OUT NOCOPY HZ_CONTACT_PREF_OBJ_TBL,
2485 p_cp_type IN VARCHAR2,
2486 p_created_by_module IN VARCHAR2,
2487 p_obj_source IN VARCHAR2 := null,
2488 x_return_status OUT NOCOPY VARCHAR2,
2489 x_msg_count OUT NOCOPY NUMBER,
2490 x_msg_data OUT NOCOPY VARCHAR2,
2491 x_cp_id OUT NOCOPY NUMBER,
2492 x_cp_os OUT NOCOPY VARCHAR2,
2493 x_cp_osr OUT NOCOPY VARCHAR2,
2494 p_parent_os IN VARCHAR2
2495 );
2496
2497 PROCEDURE do_save_contact_point (
2498 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
2499 p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
2500 p_cp_id IN NUMBER,
2501 p_cp_os IN VARCHAR2,
2502 p_cp_osr IN VARCHAR2,
2503 p_phone_obj IN HZ_PHONE_CP_BO,
2504 p_email_obj IN HZ_EMAIL_CP_BO,
2505 p_telex_obj IN HZ_TELEX_CP_BO,
2506 p_web_obj IN HZ_WEB_CP_BO,
2507 p_edi_obj IN HZ_EDI_CP_BO,
2508 p_eft_obj IN HZ_EFT_CP_BO,
2509 p_sms_obj IN HZ_SMS_CP_BO,
2510 p_cp_pref_objs IN OUT NOCOPY HZ_CONTACT_PREF_OBJ_TBL,
2511 p_cp_type IN VARCHAR2,
2512 p_created_by_module IN VARCHAR2,
2513 p_obj_source IN VARCHAR2 := null,
2514 x_return_status OUT NOCOPY VARCHAR2,
2515 x_msg_count OUT NOCOPY NUMBER,
2516 x_msg_data OUT NOCOPY VARCHAR2,
2517 x_cp_id OUT NOCOPY NUMBER,
2518 x_cp_os OUT NOCOPY VARCHAR2,
2519 x_cp_osr OUT NOCOPY VARCHAR2,
2520 px_parent_id IN OUT NOCOPY NUMBER,
2521 px_parent_os IN OUT NOCOPY VARCHAR2,
2522 px_parent_osr IN OUT NOCOPY VARCHAR2,
2523 px_parent_obj_type IN OUT NOCOPY VARCHAR2
2524 );
2525
2526 END HZ_CONTACT_POINT_BO_PUB;