1 PACKAGE IBY_PARTY_MERGE AUTHID CURRENT_USER AS
2 /* $Header: ibyptymergs.pls 120.0.12010000.1 2009/09/01 11:14:28 sgogula noship $ */
3
4 --
5 -- Merge of exteral bank account owners
6 --
7 PROCEDURE acct_owner_merge
8 (p_entity_name IN VARCHAR2,
9 p_from_id IN NUMBER,
10 p_to_id IN OUT NOCOPY NUMBER,
11 p_from_fk_id IN NUMBER,
12 p_to_fk_id IN NUMBER,
13 p_parent_entity_name IN VARCHAR2,
14 p_batch_id IN NUMBER,
15 p_batch_party_id IN NUMBER,
16 x_return_status IN OUT NOCOPY VARCHAR2
17 );
18
19 --
20 -- Updates credit credit card owners during party merge;
21 -- updates billing address during party site use merge.
22 --
23 PROCEDURE credit_card_merge
24 (p_entity_name IN VARCHAR2,
25 p_from_id IN NUMBER,
26 p_to_id IN OUT NOCOPY NUMBER,
27 p_from_fk_id IN NUMBER,
28 p_to_fk_id IN NUMBER,
29 p_parent_entity_name IN VARCHAR2,
30 p_batch_id IN NUMBER,
31 p_batch_party_id IN NUMBER,
32 x_return_status IN OUT NOCOPY VARCHAR2
33 );
34
35 --
36 -- External payer unification during merge of parties.
37 --
38 PROCEDURE external_payer_merge
39 (p_entity_name IN VARCHAR2,
40 p_from_id IN NUMBER,
41 p_to_id IN OUT NOCOPY NUMBER,
42 p_from_fk_id IN NUMBER,
43 p_to_fk_id IN NUMBER,
44 p_parent_entity_name IN VARCHAR2,
45 p_batch_id IN NUMBER,
46 p_batch_party_id IN NUMBER,
47 x_return_status IN OUT NOCOPY VARCHAR2
48 );
49
50 --
51 -- Payment instrument use merge as the result of payer merge.
52 --
53 PROCEDURE pmt_instrument_use_merge
54 (p_entity_name IN VARCHAR2,
55 p_from_id IN NUMBER,
56 p_to_id IN OUT NOCOPY NUMBER,
57 p_from_fk_id IN NUMBER,
58 p_to_fk_id IN NUMBER,
59 p_parent_entity_name IN VARCHAR2,
60 p_batch_id IN NUMBER,
61 p_batch_party_id IN NUMBER,
62 x_return_status IN OUT NOCOPY VARCHAR2
63 );
64
65 --
66 -- External party payment methods
67 --
68 PROCEDURE party_pmt_methods_merge
69 (p_entity_name IN VARCHAR2,
70 p_from_id IN NUMBER,
71 p_to_id IN OUT NOCOPY NUMBER,
72 p_from_fk_id IN NUMBER,
73 p_to_fk_id IN NUMBER,
74 p_parent_entity_name IN VARCHAR2,
75 p_batch_id IN NUMBER,
76 p_batch_party_id IN NUMBER,
77 x_return_status IN OUT NOCOPY VARCHAR2
78 );
79
80 --
81 -- Transaction Extensions merge
82 --
83 PROCEDURE fc_tx_extensions_merge
84 (p_entity_name IN VARCHAR2,
85 p_from_id IN NUMBER,
86 p_to_id IN OUT NOCOPY NUMBER,
87 p_from_fk_id IN NUMBER,
88 p_to_fk_id IN NUMBER,
89 p_parent_entity_name IN VARCHAR2,
90 p_batch_id IN NUMBER,
91 p_batch_party_id IN NUMBER,
92 x_return_status IN OUT NOCOPY VARCHAR2
93 );
94
95 --
96 -- Transaction Summaries merge
97 --
98 PROCEDURE txn_summ_all_merge
99 (p_entity_name IN VARCHAR2,
100 p_from_id IN NUMBER,
101 p_to_id IN OUT NOCOPY NUMBER,
102 p_from_fk_id IN NUMBER,
103 p_to_fk_id IN NUMBER,
104 p_parent_entity_name IN VARCHAR2,
105 p_batch_id IN NUMBER,
106 p_batch_party_id IN NUMBER,
107 x_return_status IN OUT NOCOPY VARCHAR2
108 );
109
110
111 END IBY_PARTY_MERGE;