1 PACKAGE HZ_EXTRACT_MERGE_EVENT_PKG AS
2 /*$Header: ARHMEVTS.pls 120.3 2006/09/21 23:46:41 awu noship $ */
3 /*#
4 * Get Merge Details API
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:lifecycle active
8 * @rep:category BUSINESS_ENTITY HZ_PARTY
9 * @rep:displayname Get Merge Details API
10 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical Implementation Guide
11 */
12
13 FUNCTION get_object_type(
14 p_table_name IN VARCHAR2,
15 p_table_id IN NUMBER
16 ) RETURN VARCHAR2;
17
18 /*#
19 *Get Account Merge Details API finds the details of a particular account merge by passing
20 *in the customer merge header ID, which is raised from the merge event. The account merge
21 *object is then extracted, which contains customer merge ID, request ID and the associated
22 *party info, merge-to account ID, account number, account name,and source system management
23 * mappings for all accounts involved in the merge.
24 * @param p_init_msg_list Indicates if the message stack is initialized.Default value: FND_API.G_FALSE.
25 * @param p_customer_merge_header_id Indicates the customer merge header numbers.
26 * @param x_account_merge_obj The PL/SQL table of records structure that has the account merge result information.
27 * @param x_return_status A code indicating whether any errors occurred during processing.
28 * @param x_msg_count Indicates how many messages exist on the message stack upon completion of processing.
29 * @param x_msg_data If exactly one message exists on the message stack upon completion of processing, then this parameter contains that message.
30 * @rep:scope public
31 * @rep:lifecycle active
32 * @rep:category BUSINESS_ENTITY HZ_PARTY
33 * @rep:displayname Get Account Merge Details API
34 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical Implementation Guide
35 */
36
37 PROCEDURE get_account_merge_event_data(
38 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
39 p_customer_merge_header_id IN NUMBER,
40 x_account_merge_obj OUT NOCOPY HZ_ACCT_MERGE_OBJ,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2
44 );
45
46 /*#
47 * Get Party Merge Details API finds the details of a particular party merge
48 * by passing in the merge batch ID and the master party ID from the merge event.
49 * The party merge object is then extracted, containing the batch name, merge type,
50 * automerge flag value, master party ID and the party numbers, names, and types and
51 * source system management mappings for all parties involved in the merge.
52 * @param p_init_msg_list Indicates if the message stack is initialized.Default value: FND_API.G_FALSE.
53 * @param p_batch_id Indicates the party merge batch identifier.
54 * @param p_merge_to_party_id Indicates the master party identifier.
55 * @param p_get_merge_detail_flag Indicates if historical Merge To and Merge From party details from the HZ_Merge_Party_History table and their associated Source System Mapping details will be retrieved as part of the object.
56 * @param x_party_merge_obj The PL/SQL table of records structure that has the party merge result information.
57 * @param x_return_status A code indicating whether any errors occurred during processing.
58 * @param x_msg_count Indicates how many messages exist on the message stack upon completion of processing.
59 * @param x_msg_data If exactly one message exists on the message stack upon completion of processing, then this parameter contains that message.
60 * @rep:scope public
61 * @rep:lifecycle active
62 * @rep:category BUSINESS_ENTITY HZ_PARTY
63 * @rep:displayname Get Party Merge Details API
64 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical Implementation Guide
65 */
66
67 PROCEDURE get_party_merge_event_data(
68
69 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
70 p_batch_id IN NUMBER,
71 p_merge_to_party_id IN NUMBER,
72 p_get_merge_detail_flag IN VARCHAR2 := 'N', --5093366
73 x_party_merge_obj OUT NOCOPY HZ_PARTY_MERGE_OBJ,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78 END HZ_EXTRACT_MERGE_EVENT_PKG;