1 PACKAGE PVX_PARTY_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: pvxvmrgs.pls 120.1 2005/05/31 11:29:30 appldev $ */
3
4 -- Start of Comments
5 -- Package name : PVX_PARTY_MERGE_PKG
6 --
7 -- Purpose : Merges duplicate parties in PV tables. The
8 -- PV tables that need to be considered for
9 -- Party Merge are:
10 -- PV_PARTNER_PROFILES
11 -- PV_ENTY_ATTR_VALUES
12
13 -- History
14 -- MM-DD-YYYY NAME MODIFICATIONS
15 --
16 -- End of Comments
17
18
19
20
21 PROCEDURE MERGE_REFERRALS_B (
22 p_entity_name IN VARCHAR2,
23 p_from_id IN NUMBER,
24 p_to_id OUT NOCOPY NUMBER,
25 p_from_fk_id IN NUMBER,
26 p_to_fk_id IN NUMBER,
27 p_parent_entity_name IN VARCHAR2,
28 p_batch_id IN NUMBER,
29 p_batch_party_id IN NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2);
31
32
33
34 -- *******************************************************
35 -- Start of Comments
36 -- *******************************************************
37 -- API Name: MERGE_PARTNER_PROFILES
38 -- Purpose : Merges parties in PARTNER_PROFILES table
39 -- Type : Private
40 -- Pre-Req : None.
41 -- Parameters:
42 -- IN - All IN parameters are REQUIRED.
43 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
44 -- p_from_id NUMBER - Id of the record that is being merged
45 -- p_from_fk_id NUMBER - Id of the Old Parent
46 -- p_to_fk_id NUMBER - Id of the New Parent
47 -- p_parent_entity_name VARCHAR2 - Parent entity name
48 -- p_batch_id NUMBER - Id of the Batch
49 -- p_batch_party_id NUMBER - Id of the batch and party record
50 -- OUT:
51 -- x_to_id NUMBER - Id of the record under the new parent
52 -- that its merged to
53 -- x_return_status VARCHAR2 - Return the status of the procedure
54 --
55 -- Version : Current version 1.0
56 --
57 -- End of Comments
58 --
59
60 PROCEDURE MERGE_PARTNER_PROFILES1(
61 p_entity_name IN VARCHAR2,
62 p_from_id IN NUMBER,
63 p_to_id OUT NOCOPY NUMBER,
64 p_from_fk_id IN NUMBER,
65 p_to_fk_id IN NUMBER,
66 p_parent_entity_name IN VARCHAR2,
67 p_batch_id IN NUMBER,
68 p_batch_party_id IN NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2);
70
71 PROCEDURE MERGE_PARTNER_PROFILES2(
72 p_entity_name IN VARCHAR2,
73 p_from_id IN NUMBER,
74 p_to_id OUT NOCOPY NUMBER,
75 p_from_fk_id IN NUMBER,
76 p_to_fk_id IN NUMBER,
77 p_parent_entity_name IN VARCHAR2,
78 p_batch_id IN NUMBER,
79 p_batch_party_id IN NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2);
81
82 -- *******************************************************
83 -- Start of Comments
84 -- *******************************************************
85 -- API Name: MERGE_PARTNER_ENTITY_ATTRIBUTES
86 -- Purpose : Merges parties in PV_ENTY_ATTR_VALUES table
87 -- Type : Private
88 -- Pre-Req : None.
89 -- Parameters:
90 -- IN - All IN parameters are REQUIRED.
91 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
92 -- p_from_id NUMBER - Id of the record that is being merged
93 -- p_from_fk_id NUMBER - Id of the Old Parent
94 -- p_to_fk_id NUMBER - Id of the New Parent
95 -- p_parent_entity_name VARCHAR2 - Parent entity name
96 -- p_batch_id NUMBER - Id of the Batch
97 -- p_batch_party_id NUMBER - Id of the batch and party record
98 -- OUT:
99 -- x_to_id NUMBER - Id of the record under the new parent
100 -- that its merged to
101 -- x_return_status VARCHAR2 - Return the status of the procedure
102 --
103 -- Version : Current version 1.0
104 --
105 -- End of Comments
106 --
107
108 PROCEDURE MERGE_PARTNER_ENTITY_ATTRS(
109 p_entity_name IN VARCHAR2,
110 p_from_id IN NUMBER,
111 p_to_id OUT NOCOPY NUMBER,
112 p_from_fk_id IN NUMBER,
113 p_to_fk_id IN NUMBER,
114 p_parent_entity_name IN VARCHAR2,
115 p_batch_id IN NUMBER,
116 p_batch_party_id IN NUMBER,
117 x_return_status OUT NOCOPY VARCHAR2);
118
119
120 -- *******************************************************
121 -- Start of Comments
122 -- *******************************************************
123 -- API Name: MERGE_LEAD_ASSIGNMENTS
124 -- Purpose : Merges parties in PV_LEAD_ASSIGNMENTS table
125 -- Type : Private
126 -- Pre-Req : None.
127 -- Parameters:
128 -- IN - All IN parameters are REQUIRED.
129 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
130 -- p_from_id NUMBER - Id of the record that is being merged
131 -- p_from_fk_id NUMBER - Id of the Old Parent
132 -- p_to_fk_id NUMBER - Id of the New Parent
133 -- p_parent_entity_name VARCHAR2 - Parent entity name
134 -- p_batch_id NUMBER - Id of the Batch
135 -- p_batch_party_id NUMBER - Id of the batch and party record
136 -- OUT:
137 -- x_to_id NUMBER - Id of the record under the new parent
138 -- that its merged to
139 -- x_return_status VARCHAR2 - Return the status of the procedure
140 --
141 -- Version : Current version 1.0
142 --
143 -- End of Comments
144 --
145
146 PROCEDURE MERGE_LEAD_ASSIGNMENTS(
147 p_entity_name IN VARCHAR2,
148 p_from_id IN NUMBER,
149 p_to_id OUT NOCOPY NUMBER,
150 p_from_fk_id IN NUMBER,
151 p_to_fk_id IN NUMBER,
152 p_parent_entity_name IN VARCHAR2,
153 p_batch_id IN NUMBER,
154 p_batch_party_id IN NUMBER,
155 x_return_status OUT NOCOPY VARCHAR2);
156
157
158 -- *******************************************************
159 -- Start of Comments
160 -- *******************************************************
161 -- API Name: MERGE_ASSIGNMENT_LOGS
162 -- Purpose : Merges parties in PV_ASSIGNMENT_LOGS table
163 -- Type : Private
164 -- Pre-Req : None.
165 -- Parameters:
166 -- IN - All IN parameters are REQUIRED.
167 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
168 -- p_from_id NUMBER - Id of the record that is being merged
169 -- p_from_fk_id NUMBER - Id of the Old Parent
170 -- p_to_fk_id NUMBER - Id of the New Parent
171 -- p_parent_entity_name VARCHAR2 - Parent entity name
172 -- p_batch_id NUMBER - Id of the Batch
173 -- p_batch_party_id NUMBER - Id of the batch and party record
174 -- OUT:
175 -- x_to_id NUMBER - Id of the record under the new parent
176 -- that its merged to
177 -- x_return_status VARCHAR2 - Return the status of the procedure
178 --
179 -- Version : Current version 1.0
180 --
181 -- End of Comments
182 --
183
184 PROCEDURE MERGE_ASSIGNMENT_LOGS(
185 p_entity_name IN VARCHAR2,
186 p_from_id IN NUMBER,
187 p_to_id OUT NOCOPY NUMBER,
188 p_from_fk_id IN NUMBER,
189 p_to_fk_id IN NUMBER,
190 p_parent_entity_name IN VARCHAR2,
191 p_batch_id IN NUMBER,
192 p_batch_party_id IN NUMBER,
193 x_return_status OUT NOCOPY VARCHAR2);
194
195
196 -- *******************************************************
197 -- Start of Comments
198 -- *******************************************************
199 -- API Name: MERGE_SEARCH_ATTR_VALUES
200 -- Purpose : Merges parties in PV_SEARCH_ATTR_VALUES table
201 -- Type : Private
202 -- Pre-Req : None.
203 -- Parameters:
204 -- IN - All IN parameters are REQUIRED.
205 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
206 -- p_from_id NUMBER - Id of the record that is being merged
207 -- p_from_fk_id NUMBER - Id of the Old Parent
208 -- p_to_fk_id NUMBER - Id of the New Parent
209 -- p_parent_entity_name VARCHAR2 - Parent entity name
210 -- p_batch_id NUMBER - Id of the Batch
211 -- p_batch_party_id NUMBER - Id of the batch and party record
212 -- OUT:
213 -- x_to_id NUMBER - Id of the record under the new parent
214 -- that its merged to
215 -- x_return_status VARCHAR2 - Return the status of the procedure
216 --
217 -- Version : Current version 1.0
218 --
219 -- End of Comments
220 --
221
222 PROCEDURE MERGE_SEARCH_ATTR_VALUES(
223 p_entity_name IN VARCHAR2,
224 p_from_id IN NUMBER,
225 p_to_id 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 OUT NOCOPY VARCHAR2);
232
233 -- *******************************************************
234 -- Start of Comments
235 -- *******************************************************
236 -- API Name: MERGE_LEAD_PSS_LINES
237 -- Purpose : Merges parties in PV_LEAD_PSS_LINES table
238 -- Type : Private
239 -- Pre-Req : None.
240 -- Parameters:
241 -- IN - All IN parameters are REQUIRED.
242 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
243 -- p_from_id NUMBER - Id of the record that is being merged
244 -- p_from_fk_id NUMBER - Id of the Old Parent
245 -- p_to_fk_id NUMBER - Id of the New Parent
246 -- p_parent_entity_name VARCHAR2 - Parent entity name
247 -- p_batch_id NUMBER - Id of the Batch
248 -- p_batch_party_id NUMBER - Id of the batch and party record
249 -- OUT:
250 -- x_to_id NUMBER - Id of the record under the new parent
251 -- that its merged to
252 -- x_return_status VARCHAR2 - Return the status of the procedure
253 --
254 -- Version : Current version 1.0
255 --
256 -- End of Comments
257 --
258
259 PROCEDURE MERGE_LEAD_PSS_LINES(
260 p_entity_name IN VARCHAR2,
261 p_from_id IN NUMBER,
262 p_to_id OUT NOCOPY NUMBER,
263 p_from_fk_id IN NUMBER,
264 p_to_fk_id IN NUMBER,
265 p_parent_entity_name IN VARCHAR2,
266 p_batch_id IN NUMBER,
267 p_batch_party_id IN NUMBER,
268 x_return_status OUT NOCOPY VARCHAR2);
269
270
271 -- *******************************************************
272 -- Start of Comments
273 -- *******************************************************
274 -- API Name: MERGE_GE_PARTY_NOTIFICATIONS
275 -- Purpose : Merges parties in PV_GE_PARTY_NOTIFICATIONS table
276 -- Type : Private
277 -- Pre-Req : None.
278 -- Parameters:
279 -- IN - All IN parameters are REQUIRED.
280 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
281 -- p_from_id NUMBER - Id of the record that is being merged
282 -- p_from_fk_id NUMBER - Id of the Old Parent
283 -- p_to_fk_id NUMBER - Id of the New Parent
284 -- p_parent_entity_name VARCHAR2 - Parent entity name
285 -- p_batch_id NUMBER - Id of the Batch
286 -- p_batch_party_id NUMBER - Id of the batch and party record
287 -- OUT:
288 -- x_to_id NUMBER - Id of the record under the new parent
289 -- that its merged to
290 -- x_return_status VARCHAR2 - Return the status of the procedure
291 --
292 -- Version : Current version 1.0
293 --
294 -- End of Comments
295 --
296
297 PROCEDURE MERGE_GE_PARTY_NOTIFICATIONS(
298 p_entity_name IN VARCHAR2,
299 p_from_id IN NUMBER,
300 p_to_id OUT NOCOPY NUMBER,
301 p_from_fk_id IN NUMBER,
302 p_to_fk_id IN NUMBER,
303 p_parent_entity_name IN VARCHAR2,
304 p_batch_id IN NUMBER,
305 p_batch_party_id IN NUMBER,
306 x_return_status OUT NOCOPY VARCHAR2);
307
308
309 -- *******************************************************
310 -- Start of Comments
311 -- *******************************************************
315 -- Pre-Req : None.
312 -- API Name: MERGE_PG_ENRL_REQUESTS
313 -- Purpose : Merges parties in PV_PG_ENRL_REQUESTS table
314 -- Type : Private
316 -- Parameters:
317 -- IN - All IN parameters are REQUIRED.
318 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
319 -- p_from_id NUMBER - Id of the record that is being merged
320 -- p_from_fk_id NUMBER - Id of the Old Parent
321 -- p_to_fk_id NUMBER - Id of the New Parent
322 -- p_parent_entity_name VARCHAR2 - Parent entity name
323 -- p_batch_id NUMBER - Id of the Batch
324 -- p_batch_party_id NUMBER - Id of the batch and party record
325 -- OUT:
326 -- x_to_id NUMBER - Id of the record under the new parent
327 -- that its merged to
328 -- x_return_status VARCHAR2 - Return the status of the procedure
329 --
330 -- Version : Current version 1.0
331 --
332 -- End of Comments
333 --
334
335 PROCEDURE MERGE_PG_ENRL_REQUESTS (
336 p_entity_name IN VARCHAR2,
337 p_from_id IN NUMBER,
338 p_to_id OUT NOCOPY NUMBER,
339 p_from_fk_id IN NUMBER,
340 p_to_fk_id IN NUMBER,
341 p_parent_entity_name IN VARCHAR2,
342 p_batch_id IN NUMBER,
343 p_batch_party_id IN NUMBER,
344 x_return_status OUT NOCOPY VARCHAR2);
345
346 -- *******************************************************
347 -- Start of Comments
348 -- *******************************************************
349 -- API Name: MERGE_PG_MEMBERSHIPS
350 -- Purpose : Merges parties in PV_PG_MEMBERSHIPS table
351 -- Type : Private
352 -- Pre-Req : None.
353 -- Parameters:
354 -- IN - All IN parameters are REQUIRED.
355 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
356 -- p_from_id NUMBER - Id of the record that is being merged
357 -- p_from_fk_id NUMBER - Id of the Old Parent
358 -- p_to_fk_id NUMBER - Id of the New Parent
359 -- p_parent_entity_name VARCHAR2 - Parent entity name
360 -- p_batch_id NUMBER - Id of the Batch
361 -- p_batch_party_id NUMBER - Id of the batch and party record
362 -- OUT:
363 -- x_to_id NUMBER - Id of the record under the new parent
364 -- that its merged to
365 -- x_return_status VARCHAR2 - Return the status of the procedure
366 --
367 -- Version : Current version 1.0
368 --
369 -- End of Comments
370 --
371
372 PROCEDURE MERGE_PG_MEMBERSHIPS (
373 p_entity_name IN VARCHAR2,
374 p_from_id IN NUMBER,
375 p_to_id OUT NOCOPY NUMBER,
376 p_from_fk_id IN NUMBER,
377 p_to_fk_id IN NUMBER,
378 p_parent_entity_name IN VARCHAR2,
379 p_batch_id IN NUMBER,
380 p_batch_party_id IN NUMBER,
381 x_return_status OUT NOCOPY VARCHAR2);
382
383 -- *******************************************************
384 -- Start of Comments
385 -- *******************************************************
386 -- API Name: MERGE_PARTNER_ACCESSES
387 -- Purpose : Merges partner_id in PV_PARTNER_ACCESSES table
388 -- Type : Private
389 -- Pre-Req : None.
390 -- Parameters:
391 -- IN - All IN parameters are REQUIRED.
392 -- p_entity_name VARCHAR2 - Name of the entity that is being merged
393 -- p_from_id NUMBER - Id of the record that is being merged
394 -- p_from_fk_id NUMBER - Id of the Old Parent
395 -- p_to_fk_id NUMBER - Id of the New Parent
396 -- p_parent_entity_name VARCHAR2 - Parent entity name
397 -- p_batch_id NUMBER - Id of the Batch
398 -- p_batch_party_id NUMBER - Id of the batch and party record
399 -- OUT:
400 -- x_to_id NUMBER - Id of the record under the new parent
401 -- that its merged to
402 -- x_return_status VARCHAR2 - Return the status of the procedure
403 --
404 -- Version : Current version 1.0
405 --
406 -- End of Comments
407 --
408
409 PROCEDURE MERGE_PARTNER_ACCESSES (
410 p_entity_name IN VARCHAR2
411 ,p_from_id IN NUMBER
412 ,p_to_id IN OUT NOCOPY NUMBER
413 ,p_from_fk_id IN NUMBER
414 ,p_to_fk_id IN NUMBER
415 ,p_parent_entity_name IN VARCHAR2
416 ,p_batch_id IN NUMBER
417 ,p_batch_party_id IN NUMBER
418 ,x_return_status IN OUT NOCOPY VARCHAR2
419 );
420
421 PROCEDURE MERGE_PV_GE_PTNR_RESPS (
422 p_entity_name IN VARCHAR2,
423 p_from_id IN NUMBER,
424 p_to_id OUT NOCOPY NUMBER,
425 p_from_fk_id IN NUMBER,
426 p_to_fk_id IN NUMBER,
427 p_parent_entity_name IN VARCHAR2,
428 p_batch_id IN NUMBER,
429 p_batch_party_id IN NUMBER,
430 x_return_status OUT NOCOPY VARCHAR2
431 );
432
433 PROCEDURE MERGE_CONTRACT_BINDING_CONTACT (
434 p_entity_name IN VARCHAR2,
435 p_from_id IN NUMBER,
436 p_to_id OUT NOCOPY NUMBER,
437 p_from_fk_id IN NUMBER,
438 p_to_fk_id IN NUMBER,
439 p_parent_entity_name IN VARCHAR2,
440 p_batch_id IN NUMBER,
441 p_batch_party_id IN NUMBER,
442 x_return_status OUT NOCOPY VARCHAR2
443 );
444
445
446 END PVX_PARTY_MERGE_PKG;