1 PACKAGE IBY_HZ_UNIFICATION_PKG AS
2 /* $Header: ibyhzufs.pls 120.1 2006/08/24 23:18:57 jleybovi noship $ */
3
4 --
5 -- External payer unification during merge of parties.
6 --
7 PROCEDURE external_payer_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 -- External payee unification during merge of parties.
21 --
22 PROCEDURE external_payee_merge
23 (p_entity_name IN VARCHAR2,
24 p_from_id IN NUMBER,
25 p_to_id IN OUT NOCOPY NUMBER,
26 p_from_fk_id IN NUMBER,
27 p_to_fk_id IN NUMBER,
28 p_parent_entity_name IN VARCHAR2,
29 p_batch_id IN NUMBER,
30 p_batch_party_id IN NUMBER,
31 x_return_status IN OUT NOCOPY VARCHAR2
32 );
33
34 --
35 -- Updates credit credit card owners during party merge;
36 -- updates billing address during party site use merge.
37 --
38 PROCEDURE credit_card_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 payee/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 -- Merge of exteral bank account owners
67 --
68 PROCEDURE bank_acct_owner_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 -- External party payment methods
82 --
83 PROCEDURE party_pmt_methods_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 PROCEDURE fc_tx_extensions_merge
96 (p_entity_name IN VARCHAR2,
97 p_from_id IN NUMBER,
98 p_to_id IN OUT NOCOPY NUMBER,
99 p_from_fk_id IN NUMBER,
100 p_to_fk_id IN NUMBER,
101 p_parent_entity_name IN VARCHAR2,
102 p_batch_id IN NUMBER,
103 p_batch_party_id IN NUMBER,
104 x_return_status IN OUT NOCOPY VARCHAR2
105 );
106
107 PROCEDURE txn_summ_all_merge
108 (p_entity_name IN VARCHAR2,
109 p_from_id IN NUMBER,
110 p_to_id IN OUT NOCOPY NUMBER,
111 p_from_fk_id IN NUMBER,
112 p_to_fk_id IN NUMBER,
113 p_parent_entity_name IN VARCHAR2,
114 p_batch_id IN NUMBER,
115 p_batch_party_id IN NUMBER,
116 x_return_status IN OUT NOCOPY VARCHAR2
117 );
118
119 PROCEDURE doc_payable_merge
120 (p_entity_name IN VARCHAR2,
121 p_from_id IN NUMBER,
122 p_to_id IN OUT NOCOPY NUMBER,
123 p_from_fk_id IN NUMBER,
124 p_to_fk_id IN NUMBER,
125 p_parent_entity_name IN VARCHAR2,
126 p_batch_id IN NUMBER,
127 p_batch_party_id IN NUMBER,
128 x_return_status IN OUT NOCOPY VARCHAR2
129 );
130
131 PROCEDURE payments_all_merge
132 (p_entity_name IN VARCHAR2,
133 p_from_id IN NUMBER,
134 p_to_id IN OUT NOCOPY NUMBER,
135 p_from_fk_id IN NUMBER,
136 p_to_fk_id IN NUMBER,
137 p_parent_entity_name IN VARCHAR2,
138 p_batch_id IN NUMBER,
139 p_batch_party_id IN NUMBER,
140 x_return_status IN OUT NOCOPY VARCHAR2
141 );
142
143 END IBY_HZ_UNIFICATION_PKG;