1 PACKAGE IBY_SUPP_BANK_MERGE_PUB AUTHID CURRENT_USER AS
2 /* $Header: ibybnkmergs.pls 120.0.12010000.1 2010/04/21 11:48:25 appldev noship $ */
3
4 TYPE Id_Tab_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5
6 --
7 -- Updates credit credit card owners during party merge;
8 -- updates billing address during party site use merge.
9 --
10 PROCEDURE BANK_ACCOUNTS_MERGE (
11 P_from_vendor_id IN NUMBER,
12 P_to_vendor_id IN NUMBER,
13 P_from_party_id IN NUMBER,
14 P_to_party_id IN NUMBER,
15 P_from_vendor_site_id IN NUMBER,
16 P_to_vendor_site_id IN NUMBER,
17 P_from_party_site_id IN NUMBER,
18 P_to_partysite_id IN NUMBER,
19 P_from_org_id IN NUMBER,
20 P_to_org_id IN NUMBER,
21 P_from_org_type IN VARCHAR2,
22 P_to_org_type IN VARCHAR2,
23 p_keep_site_flag IN VARCHAR2,
24 p_last_site_flag IN VARCHAR2,
25 X_return_status IN OUT NOCOPY VARCHAR2,
26 X_msg_count IN OUT NOCOPY NUMBER,
27 X_msg_data IN OUT NOCOPY VARCHAR2
28 );
29
30
31 END IBY_SUPP_BANK_MERGE_PUB;