1 PACKAGE HZ_EXTRACT_MERGE_EVENT_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHMEVTS.pls 120.3.12010000.2 2009/02/04 08:08:48 vsegu ship $ */
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 FUNCTION get_operating_unit( p_org_id NUMBER)
19 RETURN VARCHAR2;
20
21 /*#
22 *Get Account Merge Details API finds the details of a particular account merge by passing
23 *in the customer merge header ID, which is raised from the merge event. The account merge
24 *object is then extracted, which contains customer merge ID, request ID and the associated
25 *party info, merge-to account ID, account number, account name,and source system management
26 * mappings for all accounts involved in the merge.
27 * @param p_init_msg_list Indicates if the message stack is initialized.Default value: FND_API.G_FALSE.
28 * @param p_customer_merge_header_id Indicates the customer merge header numbers.
29 * @param x_account_merge_obj The PL/SQL table of records structure that has the account merge result information.
30 * @param x_return_status A code indicating whether any errors occurred during processing.
31 * @param x_msg_count Indicates how many messages exist on the message stack upon completion of processing.
32 * @param x_msg_data If exactly one message exists on the message stack upon completion of processing, then this parameter contains that message.
33 * @rep:scope public
34 * @rep:lifecycle active
35 * @rep:category BUSINESS_ENTITY HZ_PARTY
36 * @rep:displayname Get Account Merge Details API
37 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical Implementation Guide
38 */
39
40 PROCEDURE get_account_merge_event_data(
41 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
42 p_customer_merge_header_id IN NUMBER,
43 x_account_merge_obj OUT NOCOPY HZ_ACCT_MERGE_OBJ,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2
47 );
48
49 /*#
50 *Get Account Merge Details API finds the details of a particular account merge by passing
51 *in the customer merge header ID, which is raised from the merge event. The account merge
52 *object is then extracted, which contains customer merge ID, request ID and the associated
53 *party info, merge-to account ID, account number, account name,and source system management
54 * mappings for all accounts and for all entities involved in the merge.
55 * @param p_init_msg_list Indicates if the message stack is initialized.Default value: FND_API.G_FALSE.
56 * @param p_customer_merge_header_id Indicates the customer merge header numbers.
57 * @param p_get_merge_detail_flag Indicates if historical Merge To and Merge From account details and their
58 * associated Source System Mapping details will be retrieved as part of the object
59 * @param x_account_merge_v2_obj The PL/SQL table of records structure that has the account merge result information.
60 * @param x_return_status A code indicating whether any errors occurred during processing.
61 * @param x_msg_count Indicates how many messages exist on the message stack upon completion of processing.
62 * @param x_msg_data If exactly one message exists on the message stack upon completion of processing,
63 * then this parameter contains that message.
64 * @rep:scope public
65 * @rep:lifecycle active
66 * @rep:category BUSINESS_ENTITY HZ_PARTY
67 * @rep:displayname Get Account Merge Details API
68 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical
69 * Implementation Guide
70 */
71
72 PROCEDURE get_account_merge_event_data(
73 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
74 p_customer_merge_header_id IN NUMBER,
75 p_get_merge_detail_flag IN VARCHAR2 := 'N',
76 x_account_merge_v2_obj OUT NOCOPY HZ_ACCOUNT_MERGE_V2_OBJ,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2);
80
81
82 /*#
83 * Get Party Merge Details API finds the details of a particular party merge
84 * by passing in the merge batch ID and the master party ID from the merge event.
85 * The party merge object is then extracted, containing the batch name, merge type,
86 * automerge flag value, master party ID and the party numbers, names, and types and
87 * source system management mappings for all parties involved in the merge.
88 * @param p_init_msg_list Indicates if the message stack is initialized.Default value: FND_API.G_FALSE.
89 * @param p_batch_id Indicates the party merge batch identifier.
90 * @param p_merge_to_party_id Indicates the master party identifier.
91 * @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.
92 * @param x_party_merge_obj The PL/SQL table of records structure that has the party merge result information.
93 * @param x_return_status A code indicating whether any errors occurred during processing.
94 * @param x_msg_count Indicates how many messages exist on the message stack upon completion of processing.
95 * @param x_msg_data If exactly one message exists on the message stack upon completion of processing, then this parameter contains that message.
96 * @rep:scope public
97 * @rep:lifecycle active
98 * @rep:category BUSINESS_ENTITY HZ_PARTY
99 * @rep:displayname Get Party Merge Details API
100 * @rep:doccd 120hztig.pdf Data Quality Management Availability APIs, Oracle Trading Community Architecture Technical Implementation Guide
101 */
102
103 PROCEDURE get_party_merge_event_data(
104
105 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
106 p_batch_id IN NUMBER,
107 p_merge_to_party_id IN NUMBER,
108 p_get_merge_detail_flag IN VARCHAR2 := 'N', --5093366
109 x_party_merge_obj OUT NOCOPY HZ_PARTY_MERGE_OBJ,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2
113 );
114 END HZ_EXTRACT_MERGE_EVENT_PKG;