1 PACKAGE HZ_ACCOUNT_MERGE_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARHCMRQS.pls 120.0.12020000.4 2013/01/31 08:02:26 vsegu noship $ */
3 /*#
4 *Create Account Merge Request API
5 *Public API that creates a merge request in Oracle Data Librarian. A merge request contains the
6 *details of a customer or customers 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 Account Merge Request API
13 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical Implementation Guide
14 */
15
16 -- PROCEDURE create_account_merge_request
17 --
18 -- DESCRIPTION
19 -- Create merge request for duplicate accounts
20 --
21 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
22 --
23 -- ARGUMENTS
24 -- IN:
25 -- p_init_msg_list Standard IN parameter to initialize message stack.
26 -- p_submit_request Indicates whether the merge should be submitted or not.
27 -- p_account_merge_request_obj An object of account merge details.
28 --
29 -- OUT:
30 -- x_return_status Return status after the call. The status can
31 -- be fnd_api.g_ret_sts_success (success),
32 -- fnd_api.g_ret_sts_error (error),
33 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
34 -- x_msg_count Number of messages in message stack.
35 -- x_msg_data Message text if x_msg_count is 1.
36 -- x_account_merge_request_id merge request id
37 -- x_customer_merge_header_id Customer merge header id.
38 --
39 -- NOTES
40 --
41 -- MODIFICATION HISTORY
42 --
43 -- 11-DEC-2012 S V Sowjanya o Created.
44
45 /*#
46 *Creates an Account merge request in Oracle Data Librarian. A merge request contains the details
47 *of a customer or customers that are considered similar and potential candidates for merge. To
48 *successfully call this API, pass Account IDs or source system
49 *management mappings, and optionally submit request parameter that indicates to submit the merge.
50 *
51 * @param p_init_msg_list Indicates if the message stack is initialized.Default value: FND_API.G_FALSE.
52 * @param p_submit_request This is a request to submit the merge. Default Value: N.
53 * @param p_account_merge_request_obj The PL/SQL table of records structure that has the duplicate Account ID and Account Site information.
54 * @param x_customer_merge_header_id Indicates Customer Merge Header.
55 * @param x_account_merge_request_id Indicates Customer Merge Request.
56 * @param x_return_status A code indicating whether any errors occurred during processing.
57 * @param x_msg_count Indicates how many messages exist on the message stack upon completion of processing.
58 * @param x_msg_data If exactly one message exists on the message stack upon completion of processing, then this parameter contains that message.
59 * @rep:scope public
60 * @rep:lifecycle active
61 * @rep:category BUSINESS_ENTITY HZ_PARTY
62 * @rep:displayname Create Account Merge Request API
63 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical Implementation Guide
64 */
65
66 PROCEDURE create_account_merge_request(
67 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
68 p_submit_request IN VARCHAR2 := 'N',
69 p_account_merge_request_obj IN HZ_ACCOUNT_MERGE_REQUEST_OBJ,
70 x_customer_merge_header_id OUT NOCOPY NUMBER,
71 x_account_merge_request_id OUT NOCOPY NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2);
75
76 END HZ_ACCOUNT_MERGE_PUB;