1 PACKAGE AMS_PARTY_MERGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvprms.pls 115.20 2004/01/07 07:03:00 mayjain ship $ */
3
4 PROCEDURE REG_PARTY_MERGE
5 ( p_entity_name IN VARCHAR2
6 ,p_from_id IN NUMBER
7 ,p_to_id IN OUT NOCOPY NUMBER
8 ,p_from_fk_id IN NUMBER
9 ,p_to_fk_id IN NUMBER
10 ,p_parent_entity_name IN VARCHAR2
11 ,p_batch_id IN NUMBER
12 ,p_batch_party_id IN NUMBER
13 ,x_return_status IN OUT NOCOPY VARCHAR2
14 );
15
16
17 PROCEDURE OFFER_PARTY_MERGE
18 ( p_entity_name IN VARCHAR2
19 ,p_from_id IN NUMBER
20 ,p_to_id IN OUT NOCOPY NUMBER
21 ,p_from_fk_id IN NUMBER
22 ,p_to_fk_id IN NUMBER
23 ,p_parent_entity_name IN VARCHAR2
24 ,p_batch_id IN NUMBER
25 ,p_batch_party_id IN NUMBER
26 ,x_return_status IN OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE ATN_PARTY_MERGE
30 ( p_entity_name IN VARCHAR2
31 ,p_from_id IN NUMBER
32 ,p_to_id IN OUT NOCOPY NUMBER
33 ,p_from_fk_id IN NUMBER
34 ,p_to_fk_id IN NUMBER
35 ,p_parent_entity_name IN VARCHAR2
36 ,p_batch_id IN NUMBER
37 ,p_batch_party_id IN NUMBER
38 ,x_return_status IN OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE CHANNEL_PARTY_MERGE
42 ( p_entity_name IN VARCHAR2
43 ,p_from_id IN NUMBER
44 ,p_to_id IN OUT NOCOPY NUMBER
45 ,p_from_fk_id IN NUMBER
46 ,p_to_fk_id IN NUMBER
47 ,p_parent_entity_name IN VARCHAR2
48 ,p_batch_id IN NUMBER
49 ,p_batch_party_id IN NUMBER
50 ,x_return_status IN OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE Party_src_Party_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 PROCEDURE Segment_Party_Merge
66 ( p_entity_name IN VARCHAR2
67 ,p_from_id IN NUMBER
68 ,p_to_id IN OUT NOCOPY NUMBER
69 ,p_from_fk_id IN NUMBER
70 ,p_to_fk_id IN NUMBER
71 ,p_parent_entity_name IN VARCHAR2
72 ,p_batch_id IN NUMBER
73 ,p_batch_party_id IN NUMBER
74 ,x_return_status IN OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE Post_Cust_Party_Merge
78 ( p_entity_name IN VARCHAR2
79 ,p_from_id IN NUMBER
80 ,p_to_id IN OUT NOCOPY NUMBER
81 ,p_from_fk_id IN NUMBER
82 ,p_to_fk_id IN NUMBER
83 ,p_parent_entity_name IN VARCHAR2
84 ,p_batch_id IN NUMBER
85 ,p_batch_party_id IN NUMBER
86 ,x_return_status IN OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE Post_Affl_Party_Merge
90 ( p_entity_name IN VARCHAR2
91 ,p_from_id IN NUMBER
92 ,p_to_id IN OUT NOCOPY NUMBER
93 ,p_from_fk_id IN NUMBER
94 ,p_to_fk_id IN NUMBER
95 ,p_parent_entity_name IN VARCHAR2
96 ,p_batch_id IN NUMBER
97 ,p_batch_party_id IN NUMBER
98 ,x_return_status IN OUT NOCOPY VARCHAR2
99 );
100
101 PROCEDURE Campaign_Partner_Merge
102 ( p_entity_name IN VARCHAR2
103 ,p_from_id IN NUMBER
104 ,p_to_id IN OUT NOCOPY NUMBER
105 ,p_from_fk_id IN NUMBER
106 ,p_to_fk_id IN NUMBER
107 ,p_parent_entity_name IN VARCHAR2
108 ,p_batch_id IN NUMBER
109 ,p_batch_party_id IN NUMBER
110 ,x_return_status IN OUT NOCOPY VARCHAR2
111 );
112
113 PROCEDURE Campaign_VAD_Merge
114 ( p_entity_name IN VARCHAR2
115 ,p_from_id IN NUMBER
116 ,p_to_id IN OUT NOCOPY NUMBER
117 ,p_from_fk_id IN NUMBER
118 ,p_to_fk_id IN NUMBER
119 ,p_parent_entity_name IN VARCHAR2
120 ,p_batch_id IN NUMBER
121 ,p_batch_party_id IN NUMBER
122 ,x_return_status IN OUT NOCOPY VARCHAR2
123 );
124
125 PROCEDURE Campaign_Contact_Merge
126 ( p_entity_name IN VARCHAR2
127 ,p_from_id IN NUMBER
128 ,p_to_id IN OUT NOCOPY NUMBER
129 ,p_from_fk_id IN NUMBER
130 ,p_to_fk_id IN NUMBER
131 ,p_parent_entity_name IN VARCHAR2
132 ,p_batch_id IN NUMBER
133 ,p_batch_party_id IN NUMBER
134 ,x_return_status IN OUT NOCOPY VARCHAR2
135 );
136
137 PROCEDURE Trade_Profile_Party_Merge
138 ( p_entity_name IN VARCHAR2
139 ,p_from_id IN NUMBER
140 ,p_to_id IN OUT NOCOPY NUMBER
141 ,p_from_fk_id IN NUMBER
142 ,p_to_fk_id IN NUMBER
143 ,p_parent_entity_name IN VARCHAR2
144 ,p_batch_id IN NUMBER
145 ,p_batch_party_id IN NUMBER
146 ,x_return_status IN OUT NOCOPY VARCHAR2
147 );
148
149 PROCEDURE Claim_Broker_Merge
150 ( p_entity_name IN VARCHAR2
151 ,p_from_id IN NUMBER
152 ,p_to_id IN OUT NOCOPY NUMBER
153 ,p_from_fk_id IN NUMBER
154 ,p_to_fk_id IN NUMBER
155 ,p_parent_entity_name IN VARCHAR2
156 ,p_batch_id IN NUMBER
157 ,p_batch_party_id IN NUMBER
158 ,x_return_status IN OUT NOCOPY VARCHAR2
159 );
160
161 PROCEDURE Claim_Contact_Merge
162 ( p_entity_name IN VARCHAR2
163 ,p_from_id IN NUMBER
164 ,p_to_id IN OUT NOCOPY NUMBER
165 ,p_from_fk_id IN NUMBER
166 ,p_to_fk_id IN NUMBER
167 ,p_parent_entity_name IN VARCHAR2
168 ,p_batch_id IN NUMBER
169 ,p_batch_party_id IN NUMBER
170 ,x_return_status IN OUT NOCOPY VARCHAR2
171 );
172
173 PROCEDURE Claim_History_Broker_Merge
174 ( p_entity_name IN VARCHAR2
175 ,p_from_id IN NUMBER
176 ,p_to_id IN OUT NOCOPY NUMBER
177 ,p_from_fk_id IN NUMBER
178 ,p_to_fk_id IN NUMBER
179 ,p_parent_entity_name IN VARCHAR2
180 ,p_batch_id IN NUMBER
181 ,p_batch_party_id IN NUMBER
182 ,x_return_status IN OUT NOCOPY VARCHAR2
183 );
184
185 PROCEDURE Claim_History_Contact_Merge
186 ( p_entity_name IN VARCHAR2
187 ,p_from_id IN NUMBER
188 ,p_to_id IN OUT NOCOPY NUMBER
189 ,p_from_fk_id IN NUMBER
190 ,p_to_fk_id IN NUMBER
191 ,p_parent_entity_name IN VARCHAR2
192 ,p_batch_id IN NUMBER
193 ,p_batch_party_id IN NUMBER
194 ,x_return_status IN OUT NOCOPY VARCHAR2
195 );
196
197 PROCEDURE Budget_Party_Merge
198 ( p_entity_name IN VARCHAR2
199 ,p_from_id IN NUMBER
200 ,p_to_id IN OUT NOCOPY NUMBER
201 ,p_from_fk_id IN NUMBER
202 ,p_to_fk_id IN NUMBER
203 ,p_parent_entity_name IN VARCHAR2
204 ,p_batch_id IN NUMBER
205 ,p_batch_party_id IN NUMBER
206 ,x_return_status IN OUT NOCOPY VARCHAR2
207 );
208
209 PROCEDURE Budget_Vendor_Merge
210 ( p_entity_name IN VARCHAR2
211 ,p_from_id IN NUMBER
212 ,p_to_id IN OUT NOCOPY NUMBER
213 ,p_from_fk_id IN NUMBER
214 ,p_to_fk_id IN NUMBER
215 ,p_parent_entity_name IN VARCHAR2
216 ,p_batch_id IN NUMBER
217 ,p_batch_party_id IN NUMBER
218 ,x_return_status IN OUT NOCOPY VARCHAR2
219 );
220
221 PROCEDURE Product_Comp_Party_Merge
222 ( p_entity_name IN VARCHAR2
223 ,p_from_id IN NUMBER
224 ,p_to_id IN OUT NOCOPY NUMBER
225 ,p_from_fk_id IN NUMBER
226 ,p_to_fk_id IN NUMBER
227 ,p_parent_entity_name IN VARCHAR2
228 ,p_batch_id IN NUMBER
229 ,p_batch_party_id IN NUMBER
230 ,x_return_status IN OUT NOCOPY VARCHAR2
231 );
232
233 PROCEDURE placement_site_party_merge
234 ( p_entity_name IN VARCHAR2
235 ,p_from_id IN NUMBER
236 ,p_to_id IN OUT NOCOPY NUMBER
237 ,p_from_fk_id IN NUMBER
238 ,p_to_fk_id IN NUMBER
239 ,p_parent_entity_name IN VARCHAR2
240 ,p_batch_id IN NUMBER
241 ,p_batch_party_id IN NUMBER
242 ,x_return_status IN OUT NOCOPY VARCHAR2
243 );
244
245 PROCEDURE Src_lines_Party_Merge
246 ( p_entity_name IN VARCHAR2
247 ,p_from_id IN NUMBER
248 ,p_to_id IN OUT NOCOPY NUMBER
249 ,p_from_fk_id IN NUMBER
250 ,p_to_fk_id IN NUMBER
251 ,p_parent_entity_name IN VARCHAR2
252 ,p_batch_id IN NUMBER
253 ,p_batch_party_id IN NUMBER
254 ,x_return_status IN OUT NOCOPY VARCHAR2
255 ) ;
256
257 PROCEDURE List_entries_Party_Merge
258 ( p_entity_name IN VARCHAR2
259 ,p_from_id IN NUMBER
260 ,p_to_id IN OUT NOCOPY NUMBER
261 ,p_from_fk_id IN NUMBER
262 ,p_to_fk_id IN NUMBER
263 ,p_parent_entity_name IN VARCHAR2
264 ,p_batch_id IN NUMBER
265 ,p_batch_party_id IN NUMBER
266 ,x_return_status IN OUT NOCOPY VARCHAR2
267 ) ;
268
269 PROCEDURE Listentries_Parent_Party_Merge
270 ( p_entity_name IN VARCHAR2
271 ,p_from_id IN NUMBER
272 ,p_to_id IN OUT NOCOPY NUMBER
273 ,p_from_fk_id IN NUMBER
274 ,p_to_fk_id IN NUMBER
275 ,p_parent_entity_name IN VARCHAR2
276 ,p_batch_id IN NUMBER
277 ,p_batch_party_id IN NUMBER
278 ,x_return_status IN OUT NOCOPY VARCHAR2
279 ) ;
280
281 PROCEDURE Venues_Party_Merge
282 ( p_entity_name IN VARCHAR2
283 ,p_from_id IN NUMBER
284 ,p_to_id IN OUT NOCOPY NUMBER
285 ,p_from_fk_id IN NUMBER
286 ,p_to_fk_id IN NUMBER
287 ,p_parent_entity_name IN VARCHAR2
288 ,p_batch_id IN NUMBER
289 ,p_batch_party_id IN NUMBER
290 ,x_return_status IN OUT NOCOPY VARCHAR2
291 ) ;
292
293 PROCEDURE Offer_Denorm_Party_Merge
294 ( p_entity_name IN VARCHAR2
295 ,p_from_id IN NUMBER
296 ,p_to_id IN OUT NOCOPY NUMBER
297 ,p_from_fk_id IN NUMBER
298 ,p_to_fk_id IN NUMBER
299 ,p_parent_entity_name IN VARCHAR2
303 );
300 ,p_batch_id IN NUMBER
301 ,p_batch_party_id IN NUMBER
302 ,x_return_status IN OUT NOCOPY VARCHAR2
304
305 PROCEDURE Resources_Party_Merge
306 ( p_entity_name IN VARCHAR2
307 ,p_from_id IN NUMBER
308 ,p_to_id IN OUT NOCOPY NUMBER
309 ,p_from_fk_id IN NUMBER
310 ,p_to_fk_id IN NUMBER
311 ,p_parent_entity_name IN VARCHAR2
312 ,p_batch_id IN NUMBER
313 ,p_batch_party_id IN NUMBER
314 ,x_return_status IN OUT NOCOPY VARCHAR2
315 ) ;
316
317 PROCEDURE Agendas_Party_Merge
318 ( p_entity_name IN VARCHAR2
319 ,p_from_id IN NUMBER
320 ,p_to_id IN OUT NOCOPY NUMBER
321 ,p_from_fk_id IN NUMBER
322 ,p_to_fk_id IN NUMBER
323 ,p_parent_entity_name IN VARCHAR2
324 ,p_batch_id IN NUMBER
325 ,p_batch_party_id IN NUMBER
326 ,x_return_status IN OUT NOCOPY VARCHAR2
327 ) ;
328
329 PROCEDURE TCOP_CHANNEL_PARTY_MERGE
330 ( p_entity_name IN VARCHAR2
331 ,p_from_id IN NUMBER
332 ,p_to_id IN OUT NOCOPY NUMBER
333 ,p_from_fk_id IN NUMBER
334 ,p_to_fk_id IN NUMBER
335 ,p_parent_entity_name IN VARCHAR2
336 ,p_batch_id IN NUMBER
337 ,p_batch_party_id IN NUMBER
338 ,x_return_status IN OUT NOCOPY VARCHAR2
339 );
340
341 PROCEDURE TCOP_CONTACT_PARTY_MERGE
342 ( p_entity_name IN VARCHAR2
343 ,p_from_id IN NUMBER
344 ,p_to_id IN OUT NOCOPY NUMBER
345 ,p_from_fk_id IN NUMBER
346 ,p_to_fk_id IN NUMBER
347 ,p_parent_entity_name IN VARCHAR2
348 ,p_batch_id IN NUMBER
349 ,p_batch_party_id IN NUMBER
350 ,x_return_status IN OUT NOCOPY VARCHAR2
351 );
352
353 PROCEDURE TCOP_CONTACT_SUMM_PARTY_MERGE
354 ( p_entity_name IN VARCHAR2
355 ,p_from_id IN NUMBER
356 ,p_to_id IN OUT NOCOPY NUMBER
357 ,p_from_fk_id IN NUMBER
358 ,p_to_fk_id IN NUMBER
359 ,p_parent_entity_name IN VARCHAR2
360 ,p_batch_id IN NUMBER
361 ,p_batch_party_id IN NUMBER
362 ,x_return_status IN OUT NOCOPY VARCHAR2
363 );
364
365 PROCEDURE TCOP_PRVW_CONTACT_PARTY_MERGE
366 ( p_entity_name IN VARCHAR2
367 ,p_from_id IN NUMBER
368 ,p_to_id IN OUT NOCOPY NUMBER
369 ,p_from_fk_id IN NUMBER
370 ,p_to_fk_id IN NUMBER
371 ,p_parent_entity_name IN VARCHAR2
372 ,p_batch_id IN NUMBER
373 ,p_batch_party_id IN NUMBER
374 ,x_return_status IN OUT NOCOPY VARCHAR2
375 );
376
377 PROCEDURE TCOP_PRVW_FTG_DTL_PARTY_MERGE
378 ( p_entity_name IN VARCHAR2
379 ,p_from_id IN NUMBER
380 ,p_to_id IN OUT NOCOPY NUMBER
381 ,p_from_fk_id IN NUMBER
382 ,p_to_fk_id IN NUMBER
386 ,x_return_status IN OUT NOCOPY VARCHAR2
383 ,p_parent_entity_name IN VARCHAR2
384 ,p_batch_id IN NUMBER
385 ,p_batch_party_id IN NUMBER
387 );
388
389
390 END AMS_PARTY_MERGE_PVT;