1 PACKAGE OZF_PARTY_MERGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvprms.pls 120.1 2005/07/18 16:06:54 appldev ship $ */
3
4 PROCEDURE OFFER_BUY_GROUP_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 Trade_Profile_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 Claim_Broker_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 Claim_Contact_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 Claim_History_Broker_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 Claim_History_Contact_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 Budget_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 Budget_Vendor_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
102 PROCEDURE Offer_Denorm_Party_Merge
103 ( p_entity_name IN VARCHAR2
104 ,p_from_id IN NUMBER
105 ,p_to_id IN OUT NOCOPY NUMBER
106 ,p_from_fk_id IN NUMBER
107 ,p_to_fk_id IN NUMBER
108 ,p_parent_entity_name IN VARCHAR2
109 ,p_batch_id IN NUMBER
110 ,p_batch_party_id IN NUMBER
111 ,x_return_status IN OUT NOCOPY VARCHAR2
112 );
113
114 PROCEDURE Claim_Line_Party_Merge
115 ( p_entity_name IN VARCHAR2
116 ,p_from_id IN NUMBER
117 ,p_to_id IN OUT NOCOPY NUMBER
118 ,p_from_fk_id IN NUMBER
119 ,p_to_fk_id IN NUMBER
120 ,p_parent_entity_name IN VARCHAR2
121 ,p_batch_id IN NUMBER
122 ,p_batch_party_id IN NUMBER
123 ,x_return_status IN OUT NOCOPY VARCHAR2
124 ) ;
125
126 PROCEDURE Claim_Line_Hist_Party_Merge
127 ( p_entity_name IN VARCHAR2
128 ,p_from_id IN NUMBER
129 ,p_to_id IN OUT NOCOPY NUMBER
130 ,p_from_fk_id IN NUMBER
131 ,p_to_fk_id IN NUMBER
132 ,p_parent_entity_name IN VARCHAR2
133 ,p_batch_id IN NUMBER
134 ,p_batch_party_id IN NUMBER
135 ,x_return_status IN OUT NOCOPY VARCHAR2
136 ) ;
137
138 PROCEDURE Code_Conversion_Party_Merge
139 ( p_entity_name IN VARCHAR2
140 ,p_from_id IN NUMBER
141 ,p_to_id IN OUT NOCOPY NUMBER
142 ,p_from_fk_id IN NUMBER
143 ,p_to_fk_id IN NUMBER
144 ,p_parent_entity_name IN VARCHAR2
145 ,p_batch_id IN NUMBER
146 ,p_batch_party_id IN NUMBER
147 ,x_return_status IN OUT NOCOPY VARCHAR2
148 ) ;
149
150 PROCEDURE Resale_Batch_Prtn_Merge
151 ( p_entity_name IN VARCHAR2
152 ,p_from_id IN NUMBER
153 ,p_to_id IN OUT NOCOPY NUMBER
154 ,p_from_fk_id IN NUMBER
155 ,p_to_fk_id IN NUMBER
156 ,p_parent_entity_name IN VARCHAR2
157 ,p_batch_id IN NUMBER
158 ,p_batch_party_id IN NUMBER
159 ,x_return_status IN OUT NOCOPY VARCHAR2
160 ) ;
161
162 PROCEDURE Resale_Batch_Prtn_Cnt_Merge
163 ( p_entity_name IN VARCHAR2
164 ,p_from_id IN NUMBER
165 ,p_to_id IN OUT NOCOPY NUMBER
166 ,p_from_fk_id IN NUMBER
167 ,p_to_fk_id IN NUMBER
168 ,p_parent_entity_name IN VARCHAR2
169 ,p_batch_id IN NUMBER
170 ,p_batch_party_id IN NUMBER
171 ,x_return_status IN OUT NOCOPY VARCHAR2
172 ) ;
173
174 PROCEDURE Resale_Int_Ship_Frm_Cnt_Mge
175 ( p_entity_name IN VARCHAR2
176 ,p_from_id IN NUMBER
177 ,p_to_id IN OUT NOCOPY NUMBER
178 ,p_from_fk_id IN NUMBER
179 ,p_to_fk_id IN NUMBER
180 ,p_parent_entity_name IN VARCHAR2
181 ,p_batch_id IN NUMBER
182 ,p_batch_party_id IN NUMBER
183 ,x_return_status IN OUT NOCOPY VARCHAR2
184 ) ;
185
186 PROCEDURE Resale_Int_Sold_Frm_Cnt_Mge
187 ( p_entity_name IN VARCHAR2
188 ,p_from_id IN NUMBER
189 ,p_to_id IN OUT NOCOPY NUMBER
190 ,p_from_fk_id IN NUMBER
191 ,p_to_fk_id IN NUMBER
192 ,p_parent_entity_name IN VARCHAR2
193 ,p_batch_id IN NUMBER
194 ,p_batch_party_id IN NUMBER
195 ,x_return_status IN OUT NOCOPY VARCHAR2
196 ) ;
197
198 PROCEDURE Resale_Int_Bill_To_Merge
199 ( p_entity_name IN VARCHAR2
200 ,p_from_id IN NUMBER
201 ,p_to_id IN OUT NOCOPY NUMBER
202 ,p_from_fk_id IN NUMBER
203 ,p_to_fk_id IN NUMBER
204 ,p_parent_entity_name IN VARCHAR2
205 ,p_batch_id IN NUMBER
206 ,p_batch_party_id IN NUMBER
207 ,x_return_status IN OUT NOCOPY VARCHAR2
208 ) ;
209
210 PROCEDURE Resale_Int_Bill_To_Cnt_Mge
211 ( p_entity_name IN VARCHAR2
212 ,p_from_id IN NUMBER
213 ,p_to_id IN OUT NOCOPY NUMBER
214 ,p_from_fk_id IN NUMBER
215 ,p_to_fk_id IN NUMBER
216 ,p_parent_entity_name IN VARCHAR2
217 ,p_batch_id IN NUMBER
218 ,p_batch_party_id IN NUMBER
219 ,x_return_status IN OUT NOCOPY VARCHAR2
220 ) ;
221
222 PROCEDURE Resale_Int_Ship_To_Merge
223 ( p_entity_name IN VARCHAR2
224 ,p_from_id IN NUMBER
225 ,p_to_id IN OUT NOCOPY NUMBER
226 ,p_from_fk_id IN NUMBER
227 ,p_to_fk_id IN NUMBER
228 ,p_parent_entity_name IN VARCHAR2
229 ,p_batch_id IN NUMBER
230 ,p_batch_party_id IN NUMBER
231 ,x_return_status IN OUT NOCOPY VARCHAR2
232 ) ;
233
234 PROCEDURE Resale_Int_Ship_To_Cnt_Mge
235 ( p_entity_name IN VARCHAR2
236 ,p_from_id IN NUMBER
237 ,p_to_id IN OUT NOCOPY NUMBER
238 ,p_from_fk_id IN NUMBER
239 ,p_to_fk_id IN NUMBER
240 ,p_parent_entity_name IN VARCHAR2
241 ,p_batch_id IN NUMBER
242 ,p_batch_party_id IN NUMBER
243 ,x_return_status IN OUT NOCOPY VARCHAR2
244 ) ;
245
246 PROCEDURE Resale_Int_End_Cust_Merge
247 ( p_entity_name IN VARCHAR2
248 ,p_from_id IN NUMBER
249 ,p_to_id IN OUT NOCOPY NUMBER
250 ,p_from_fk_id IN NUMBER
251 ,p_to_fk_id IN NUMBER
252 ,p_parent_entity_name IN VARCHAR2
253 ,p_batch_id IN NUMBER
254 ,p_batch_party_id IN NUMBER
255 ,x_return_status IN OUT NOCOPY VARCHAR2
256 ) ;
257
258 PROCEDURE Resale_Int_End_Cust_Cnt_Mge
259 ( p_entity_name IN VARCHAR2
260 ,p_from_id IN NUMBER
261 ,p_to_id IN OUT NOCOPY NUMBER
262 ,p_from_fk_id IN NUMBER
263 ,p_to_fk_id IN NUMBER
264 ,p_parent_entity_name IN VARCHAR2
265 ,p_batch_id IN NUMBER
266 ,p_batch_party_id IN NUMBER
267 ,x_return_status IN OUT NOCOPY VARCHAR2
268 ) ;
269
270 PROCEDURE Resale_Head_Bill_To_Merge
271 ( p_entity_name IN VARCHAR2
272 ,p_from_id IN NUMBER
273 ,p_to_id IN OUT NOCOPY NUMBER
274 ,p_from_fk_id IN NUMBER
275 ,p_to_fk_id IN NUMBER
276 ,p_parent_entity_name IN VARCHAR2
277 ,p_batch_id IN NUMBER
278 ,p_batch_party_id IN NUMBER
279 ,x_return_status IN OUT NOCOPY VARCHAR2
280 ) ;
281
282 PROCEDURE Resale_Head_Bill_To_Cnt_Mge
283 ( p_entity_name IN VARCHAR2
284 ,p_from_id IN NUMBER
285 ,p_to_id IN OUT NOCOPY NUMBER
286 ,p_from_fk_id IN NUMBER
287 ,p_to_fk_id IN NUMBER
288 ,p_parent_entity_name IN VARCHAR2
289 ,p_batch_id IN NUMBER
290 ,p_batch_party_id IN NUMBER
291 ,x_return_status IN OUT NOCOPY VARCHAR2
292 ) ;
293
294 PROCEDURE Resale_Head_Ship_To_Merge
295 ( p_entity_name IN VARCHAR2
296 ,p_from_id IN NUMBER
297 ,p_to_id IN OUT NOCOPY NUMBER
298 ,p_from_fk_id IN NUMBER
299 ,p_to_fk_id IN NUMBER
300 ,p_parent_entity_name IN VARCHAR2
301 ,p_batch_id IN NUMBER
302 ,p_batch_party_id IN NUMBER
303 ,x_return_status IN OUT NOCOPY VARCHAR2
304 ) ;
305
306 PROCEDURE Resale_Head_Ship_To_Cnt_Mge
307 ( p_entity_name IN VARCHAR2
308 ,p_from_id IN NUMBER
309 ,p_to_id IN OUT NOCOPY NUMBER
310 ,p_from_fk_id IN NUMBER
311 ,p_to_fk_id IN NUMBER
312 ,p_parent_entity_name IN VARCHAR2
313 ,p_batch_id IN NUMBER
314 ,p_batch_party_id IN NUMBER
315 ,x_return_status IN OUT NOCOPY VARCHAR2
316 ) ;
317
318 PROCEDURE Resale_Line_Ship_Frm_Cnt_Mge
319 ( p_entity_name IN VARCHAR2
320 ,p_from_id IN NUMBER
321 ,p_to_id IN OUT NOCOPY NUMBER
322 ,p_from_fk_id IN NUMBER
323 ,p_to_fk_id IN NUMBER
324 ,p_parent_entity_name IN VARCHAR2
325 ,p_batch_id IN NUMBER
326 ,p_batch_party_id IN NUMBER
330 PROCEDURE Resale_Line_Sold_Frm_Cnt_Mge
327 ,x_return_status IN OUT NOCOPY VARCHAR2
328 ) ;
329
331 ( p_entity_name IN VARCHAR2
332 ,p_from_id IN NUMBER
333 ,p_to_id IN OUT NOCOPY NUMBER
334 ,p_from_fk_id IN NUMBER
335 ,p_to_fk_id IN NUMBER
336 ,p_parent_entity_name IN VARCHAR2
337 ,p_batch_id IN NUMBER
338 ,p_batch_party_id IN NUMBER
339 ,x_return_status IN OUT NOCOPY VARCHAR2
340 ) ;
341
342 PROCEDURE Resale_Line_Bill_To_Merge
343 ( p_entity_name IN VARCHAR2
344 ,p_from_id IN NUMBER
345 ,p_to_id IN OUT NOCOPY NUMBER
346 ,p_from_fk_id IN NUMBER
347 ,p_to_fk_id IN NUMBER
348 ,p_parent_entity_name IN VARCHAR2
349 ,p_batch_id IN NUMBER
350 ,p_batch_party_id IN NUMBER
351 ,x_return_status IN OUT NOCOPY VARCHAR2
352 ) ;
353
354 PROCEDURE Resale_Line_Bill_To_Cnt_Mge
355 ( p_entity_name IN VARCHAR2
356 ,p_from_id IN NUMBER
357 ,p_to_id IN OUT NOCOPY NUMBER
358 ,p_from_fk_id IN NUMBER
359 ,p_to_fk_id IN NUMBER
360 ,p_parent_entity_name IN VARCHAR2
361 ,p_batch_id IN NUMBER
362 ,p_batch_party_id IN NUMBER
363 ,x_return_status IN OUT NOCOPY VARCHAR2
364 ) ;
365
366 PROCEDURE Resale_Line_Ship_To_Merge
367 ( p_entity_name IN VARCHAR2
368 ,p_from_id IN NUMBER
369 ,p_to_id IN OUT NOCOPY NUMBER
370 ,p_from_fk_id IN NUMBER
371 ,p_to_fk_id IN NUMBER
372 ,p_parent_entity_name IN VARCHAR2
373 ,p_batch_id IN NUMBER
374 ,p_batch_party_id IN NUMBER
375 ,x_return_status IN OUT NOCOPY VARCHAR2
376 ) ;
377
378 PROCEDURE Resale_Line_Ship_To_Cnt_Mge
379 ( p_entity_name IN VARCHAR2
380 ,p_from_id IN NUMBER
381 ,p_to_id IN OUT NOCOPY NUMBER
382 ,p_from_fk_id IN NUMBER
383 ,p_to_fk_id IN NUMBER
384 ,p_parent_entity_name IN VARCHAR2
385 ,p_batch_id IN NUMBER
386 ,p_batch_party_id IN NUMBER
387 ,x_return_status IN OUT NOCOPY VARCHAR2
388 ) ;
389
390 PROCEDURE Resale_Line_End_Cust_Merge
391 ( p_entity_name IN VARCHAR2
392 ,p_from_id IN NUMBER
393 ,p_to_id IN OUT NOCOPY NUMBER
394 ,p_from_fk_id IN NUMBER
395 ,p_to_fk_id IN NUMBER
396 ,p_parent_entity_name IN VARCHAR2
397 ,p_batch_id IN NUMBER
398 ,p_batch_party_id IN NUMBER
399 ,x_return_status IN OUT NOCOPY VARCHAR2
400 ) ;
401
402 PROCEDURE Resale_Line_End_Cust_Cnt_Mge
403 ( p_entity_name IN VARCHAR2
404 ,p_from_id IN NUMBER
405 ,p_to_id IN OUT NOCOPY NUMBER
406 ,p_from_fk_id IN NUMBER
407 ,p_to_fk_id IN NUMBER
408 ,p_parent_entity_name IN VARCHAR2
409 ,p_batch_id IN NUMBER
410 ,p_batch_party_id IN NUMBER
411 ,x_return_status IN OUT NOCOPY VARCHAR2
412 ) ;
413
414 PROCEDURE Request_Head_End_Cust_Merge
415 ( p_entity_name IN VARCHAR2
416 ,p_from_id IN NUMBER
417 ,p_to_id IN OUT NOCOPY NUMBER
418 ,p_from_fk_id IN NUMBER
419 ,p_to_fk_id IN NUMBER
420 ,p_parent_entity_name IN VARCHAR2
421 ,p_batch_id IN NUMBER
422 ,p_batch_party_id IN NUMBER
423 ,x_return_status IN OUT NOCOPY VARCHAR2
424 ) ;
425
426 PROCEDURE Request_Head_Reseller_Merge
427 ( p_entity_name IN VARCHAR2
428 ,p_from_id IN NUMBER
429 ,p_to_id IN OUT NOCOPY NUMBER
430 ,p_from_fk_id IN NUMBER
431 ,p_to_fk_id IN NUMBER
432 ,p_parent_entity_name IN VARCHAR2
433 ,p_batch_id IN NUMBER
434 ,p_batch_party_id IN NUMBER
435 ,x_return_status IN OUT NOCOPY VARCHAR2
436 ) ;
437
438 PROCEDURE Acct_Alloc_Parent_Party_Merge
439 ( p_entity_name IN VARCHAR2
440 ,p_from_id IN NUMBER
441 ,p_to_id IN OUT NOCOPY NUMBER
442 ,p_from_fk_id IN NUMBER
443 ,p_to_fk_id IN NUMBER
444 ,p_parent_entity_name IN VARCHAR2
445 ,p_batch_id IN NUMBER
446 ,p_batch_party_id IN NUMBER
447 ,x_return_status IN OUT NOCOPY VARCHAR2
448 );
449
450 PROCEDURE Acct_Alloc_Rollup_Party_Merge
451 ( p_entity_name IN VARCHAR2
452 ,p_from_id IN NUMBER
453 ,p_to_id IN OUT NOCOPY NUMBER
454 ,p_from_fk_id IN NUMBER
455 ,p_to_fk_id IN NUMBER
456 ,p_parent_entity_name IN VARCHAR2
457 ,p_batch_id IN NUMBER
458 ,p_batch_party_id IN NUMBER
459 ,x_return_status IN OUT NOCOPY VARCHAR2
460 ) ;
461
462 PROCEDURE Offer_Autopay_Party_Merge
463 ( p_entity_name IN VARCHAR2
464 ,p_from_id IN NUMBER
465 ,p_to_id IN OUT NOCOPY NUMBER
466 ,p_from_fk_id IN NUMBER
467 ,p_to_fk_id IN NUMBER
468 ,p_parent_entity_name IN VARCHAR2
469 ,p_batch_id IN NUMBER
470 ,p_batch_party_id IN NUMBER
471 ,x_return_status IN OUT NOCOPY VARCHAR2
472 ) ;
473
474 PROCEDURE Request_Head_Partner_Merge
475 ( p_entity_name IN VARCHAR2
479 ,p_to_fk_id IN NUMBER
476 ,p_from_id IN NUMBER
477 ,p_to_id IN OUT NOCOPY NUMBER
478 ,p_from_fk_id IN NUMBER
480 ,p_parent_entity_name IN VARCHAR2
481 ,p_batch_id IN NUMBER
482 ,p_batch_party_id IN NUMBER
483 ,x_return_status IN OUT NOCOPY VARCHAR2
484 ) ;
485
486 END OZF_PARTY_MERGE_PVT;