1 PACKAGE HZ_DUP_MERGE_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARHBCMBS.pls 120.1 2006/09/21 23:16:07 awu noship $ */
3 /*#
4 *Create Merge Request API
5 *Public API that creates a merge request in Oracle Data Librarian. A merge request contains the
6 *details of a party or parties that are considered similar and potential candidates for merge.
7 *
8 * @rep:scope public
9 * @rep:product HZ
10 * @rep:lifecycle active
11 * @rep:category BUSINESS_ENTITY HZ_PARTY
12 * @rep:displayname Create Merge Request API
13 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical Implementation Guide
14 */
15
16
17 -- PROCEDURE create_dup_merge_request
18 --
19 -- DESCRIPTION
20 -- Create merge request for duplicate parties
21 --
22 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
23 --
24 -- ARGUMENTS
25 -- IN:
26 -- p_init_msg_list Standard IN parameter to initialize message stack.
27 -- p_dup_id_objs An object table of duplicate party ids.
28 -- p_note_text note for the merge request
29 --
30 -- OUT:
31 -- x_return_status Return status after the call. The status can
32 -- be fnd_api.g_ret_sts_success (success),
33 -- fnd_api.g_ret_sts_error (error),
34 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
35 -- x_msg_count Number of messages in message stack.
36 -- x_msg_data Message text if x_msg_count is 1.
37 -- x_merge_request_id merge request id
38 --
39 -- NOTES
40 --
41 -- MODIFICATION HISTORY
42 --
43 -- 10-JAN-2006 AWU Created.
44
45 /*#
46 *Creates a merge request in Oracle Data Librarian. A merge request contains the details
47 *of a party or parties that are considered similar and potential candidates for merge. To
48 *successfully call this API, pass a list of duplicate party IDs or source system
49 *management mappings, and optionally some note text.
50 *
51 * @param p_init_msg_list Indicates if the message stack is initialized.Default value: FND_API.G_FALSE.
52 * @param p_dup_id_objs The PL/SQL table of records structure that has the duplicate party ID information.
53 * @param p_note_text Note text for the merge request.
54 * @param x_return_status A code indicating whether any errors occurred during processing.
55 * @param x_msg_count Indicates how many messages exist on the message stack upon completion of processing.
56 * @param x_msg_data If exactly one message exists on the message stack upon completion of processing, then this parameter contains that message.
57 * @param x_merge_request_id Indicates the merge request.
58 * @rep:scope public
59 * @rep:lifecycle active
60 * @rep:category BUSINESS_ENTITY HZ_PARTY
61 * @rep:displayname Create Merge Request API
62 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical Implementation Guide
63 */
64
65 PROCEDURE create_dup_merge_request(
66 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
67 p_dup_id_objs IN HZ_DUP_ID_OBJ_TBL,
68 p_note_text IN VARCHAR2,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 x_merge_request_id OUT NOCOPY NUMBER
73 );
74
75 END HZ_DUP_MERGE_PUB;