[Home] [Help]
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.
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,
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.
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,
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.
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,