1 PACKAGE HZ_MERGE_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHMPKGS.pls 120.6 2005/07/29 16:46:28 vsegu noship $ */
3 PROCEDURE party_merge(
4 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
5 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
6 x_to_id IN OUT NOCOPY NUMBER,
7 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
8 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
9 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
10 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
11 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
12 x_return_status OUT NOCOPY VARCHAR2
13 );
14 PROCEDURE party_reln_object_merge(
15 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
16 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
17 x_to_id IN OUT NOCOPY NUMBER,
18 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
19 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
20 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
21 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
22 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
23 x_return_status OUT NOCOPY VARCHAR2
24 );
25 PROCEDURE party_reln_subject_merge(
26 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
27 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
28 x_to_id IN OUT NOCOPY NUMBER,
29 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
31 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
32 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
33 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
34 x_return_status OUT NOCOPY VARCHAR2
35 );
36 PROCEDURE party_relationship_merge(
37 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
38 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
39 x_to_id IN OUT NOCOPY NUMBER,
40 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
42 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
43 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
44 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
45 x_return_status OUT NOCOPY VARCHAR2
46 );
47 PROCEDURE org_profile_merge(
48 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
49 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
50 x_to_id IN OUT NOCOPY NUMBER,
51 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
52 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
53 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
54 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
55 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
56 x_return_status OUT NOCOPY VARCHAR2
57 );
58 PROCEDURE per_profile_merge(
59 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
60 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
61 x_to_id IN OUT NOCOPY NUMBER,
62 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
63 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
64 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
65 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
66 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
67 x_return_status OUT NOCOPY VARCHAR2
68 );
69 PROCEDURE org_contact_merge(
70 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
71 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
72 x_to_id IN OUT NOCOPY NUMBER,
73 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
75 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
76 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
77 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
78 x_return_status OUT NOCOPY VARCHAR2
79 );
80 PROCEDURE cust_account_merge(
81 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
82 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
83 x_to_id IN OUT NOCOPY NUMBER,
84 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
86 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
87 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
88 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
89 x_return_status OUT NOCOPY VARCHAR2
90 );
91 PROCEDURE cust_account_role_merge(
92 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94 x_to_id IN OUT NOCOPY NUMBER,
95 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100 x_return_status OUT NOCOPY VARCHAR2
101 );
102 PROCEDURE cust_account_site_merge(
103 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
104 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
105 x_to_id IN OUT NOCOPY NUMBER,
106 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
107 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
108 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
109 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
110 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
111 x_return_status OUT NOCOPY VARCHAR2
112 );
113 PROCEDURE contact_point_merge(
114 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
115 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
116 x_to_id IN OUT NOCOPY NUMBER,
117 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
118 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
119 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
120 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
121 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
122 x_return_status OUT NOCOPY VARCHAR2
123 );
124 PROCEDURE financial_profile_merge(
125 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
126 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
127 x_to_id IN OUT NOCOPY NUMBER,
128 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
129 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
130 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
131 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
132 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
133 x_return_status OUT NOCOPY VARCHAR2
134 );
135 PROCEDURE references_merge(
136 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
137 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
138 x_to_id IN OUT NOCOPY NUMBER,
139 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
140 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
141 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
142 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
143 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
144 x_return_status OUT NOCOPY VARCHAR2
145 );
146 PROCEDURE certification_merge(
147 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
148 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
149 x_to_id IN OUT NOCOPY NUMBER,
150 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
151 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
152 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
153 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
154 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
155 x_return_status OUT NOCOPY VARCHAR2
156 );
157 PROCEDURE credit_ratings_merge(
158 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
159 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
160 x_to_id IN OUT NOCOPY NUMBER,
161 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
163 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
164 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
165 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
166 x_return_status OUT NOCOPY VARCHAR2
167 );
168 PROCEDURE party_site_merge(
169 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
170 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
171 x_to_id IN OUT NOCOPY NUMBER,
172 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
173 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
174 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
175 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
176 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
177 x_return_status OUT NOCOPY VARCHAR2
178 );
179 PROCEDURE org_contact_merge2(
180 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
181 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
182 x_to_id IN OUT NOCOPY NUMBER,
183 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
184 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
186 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
187 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
188 x_return_status OUT NOCOPY VARCHAR2
189 );
190 PROCEDURE contact_point_merge2(
191 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
192 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
193 x_to_id IN OUT NOCOPY NUMBER,
194 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
196 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
197 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
198 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
199 x_return_status OUT NOCOPY VARCHAR2
200 );
201 PROCEDURE party_site_use_merge(
202 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
203 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
204 x_to_id IN OUT NOCOPY NUMBER,
205 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
206 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
207 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
208 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
209 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
210 x_return_status OUT NOCOPY VARCHAR2
211 );
212 PROCEDURE contact_preference_merge(
213 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
214 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
215 x_to_id IN OUT NOCOPY NUMBER,
216 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
217 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
218 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
219 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
220 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
221 x_return_status OUT NOCOPY VARCHAR2
222 );
223 PROCEDURE contact_preference_merge2(
224 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
225 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
226 x_to_id IN OUT NOCOPY NUMBER,
227 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
228 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
229 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
230 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
231 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
232 x_return_status OUT NOCOPY VARCHAR2
233 );
234 PROCEDURE contact_preference_merge3(
235 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
236 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
237 x_to_id IN OUT NOCOPY NUMBER,
238 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
239 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
240 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
241 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
242 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
243 x_return_status OUT NOCOPY VARCHAR2
244 );
245 PROCEDURE security_issued_merge(
246 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
247 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
248 x_to_id IN OUT NOCOPY NUMBER,
249 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
250 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
251 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
252 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
253 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
254 x_return_status OUT NOCOPY VARCHAR2
255 );
256 PROCEDURE financial_reports_merge(
257 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
258 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
259 x_to_id IN OUT NOCOPY NUMBER,
260 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
261 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
262 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
263 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
264 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
265 x_return_status OUT NOCOPY VARCHAR2
266 );
267 PROCEDURE org_indicators_merge(
268 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
269 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
270 x_to_id IN OUT NOCOPY NUMBER,
271 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
272 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
273 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
274 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
275 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
276 x_return_status OUT NOCOPY VARCHAR2
277 );
278 PROCEDURE org_ind_reference_merge(
279 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
280 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
281 x_to_id IN OUT NOCOPY NUMBER,
282 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
283 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
284 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
285 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
286 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
287 x_return_status OUT NOCOPY VARCHAR2
288 );
289 PROCEDURE per_interest_merge(
290 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
291 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
292 x_to_id IN OUT NOCOPY NUMBER,
293 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
294 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
295 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
296 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
297 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
298 x_return_status OUT NOCOPY VARCHAR2
299 );
300 PROCEDURE citizenship_merge(
301 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
302 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
303 x_to_id IN OUT NOCOPY NUMBER,
304 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
305 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
306 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
307 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
308 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
309 x_return_status OUT NOCOPY VARCHAR2
310 );
311 PROCEDURE education_merge(
312 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
313 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
314 x_to_id IN OUT NOCOPY NUMBER,
315 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
316 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
317 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
318 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
319 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
323 PROCEDURE education_school_merge(
320 x_return_status OUT NOCOPY VARCHAR2
321 );
322
324 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
325 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
326 x_to_id IN OUT NOCOPY NUMBER,
327 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
328 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
329 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
330 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
331 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
332 x_return_status OUT NOCOPY VARCHAR2
333 );
334
335 PROCEDURE emp_history_merge(
336 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
337 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
338 x_to_id IN OUT NOCOPY NUMBER,
339 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
340 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
341 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
342 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
343 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
344 x_return_status OUT NOCOPY VARCHAR2
345 );
346
347 PROCEDURE emp_history_employed_merge(
348 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
349 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
350 x_to_id IN OUT NOCOPY NUMBER,
351 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
352 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
353 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
354 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
355 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
356 x_return_status OUT NOCOPY VARCHAR2
357 );
358
359 PROCEDURE per_languages_merge(
360 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
361 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
362 x_to_id IN OUT NOCOPY NUMBER,
363 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
364 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
365 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
366 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
367 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
368 x_return_status OUT NOCOPY VARCHAR2
369 );
370 PROCEDURE code_assignment_merge(
371 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
372 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
373 x_to_id IN OUT NOCOPY NUMBER,
374 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
375 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
376 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
377 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
378 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
379 x_return_status OUT NOCOPY VARCHAR2
380 );
381 PROCEDURE code_assignment_merge2(
382 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
383 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
384 x_to_id IN OUT NOCOPY NUMBER,
385 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
386 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
387 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
388 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
389 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
390 x_return_status OUT NOCOPY VARCHAR2
391 );
392 PROCEDURE org_contact_role_merge(
393 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
394 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
395 x_to_id IN OUT NOCOPY NUMBER,
396 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
397 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
398 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
399 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
400 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
401 x_return_status OUT NOCOPY VARCHAR2
402 );
403 PROCEDURE financial_number_merge(
404 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
405 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
406 x_to_id IN OUT NOCOPY NUMBER,
407 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
408 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
409 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
410 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
411 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
412 x_return_status OUT NOCOPY VARCHAR2
413 );
414 PROCEDURE work_class_merge(
415 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
416 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
417 x_to_id IN OUT NOCOPY NUMBER,
418 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
419 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
420 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
421 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
422 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
423 x_return_status OUT NOCOPY VARCHAR2
424 );
425 PROCEDURE displayed_duns_merge(
426 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
427 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
428 x_to_id IN OUT NOCOPY NUMBER,
432 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
429 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
430 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
431 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
433 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
434 x_return_status OUT NOCOPY VARCHAR2
435 );
436 PROCEDURE cust_account_selling_merge(
437 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
438 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
439 x_to_id IN OUT NOCOPY NUMBER,
440 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
441 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
442 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
443 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
444 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
445 x_return_status OUT NOCOPY VARCHAR2
446 );
447
448 PROCEDURE check_params(
449 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
450 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
451 p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
452 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
453 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
454 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
455 p_proc_name IN VARCHAR2,
456 p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
457 p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
458 p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
459 p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
460 x_return_status IN OUT NOCOPY VARCHAR2
461 );
462
463 PROCEDURE party_usage_merge(
464 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
465 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
466 x_to_id IN OUT NOCOPY NUMBER,
467 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
468 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
469 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
470 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
471 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
472 x_return_status OUT NOCOPY VARCHAR2
473 );
474
475
476 m_same_duns VARCHAR2(1) := 'N';
477 m_to_is_branch VARCHAR2(1) := 'N';
478 m_to_has_no_dnb VARCHAR2(1) := 'N';
479 END HZ_MERGE_PKG;