[Home] [Help]
PACKAGE: APPS.OKL_PARTY_MERGE_PUB
Source
1 PACKAGE OKL_PARTY_MERGE_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPPMGS.pls 120.6 2008/03/14 12:36:53 pagarg ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PARTY_MERGE_PUB';
7 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
8 G_API_TYPE CONSTANT VARCHAR2(30) := '_PUB';
9 ---------------------------------------------------------------------------
10
11 PROCEDURE OKL_INSURANCE_PARTY_MERGE(
12 p_entity_name IN VARCHAR2,
13 p_from_id IN NUMBER,
14 x_to_id OUT NOCOPY NUMBER,
15 p_from_fk_id IN NUMBER,
16 p_to_fk_id IN NUMBER,
17 p_parent_entity_name IN VARCHAR2,
18 p_batch_id IN NUMBER,
19 p_batch_party_id IN NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2);
21
22 PROCEDURE OKL_INSURANCE_PARTY_SITE_MERGE(
23 p_entity_name IN VARCHAR2,
24 p_from_id IN NUMBER,
25 x_to_id 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 OUT NOCOPY VARCHAR2);
32
33 PROCEDURE OKL_INSURANCE_AGENT_MERGE(
34 p_entity_name IN VARCHAR2,
35 p_from_id IN NUMBER,
36 x_to_id OUT NOCOPY NUMBER,
37 p_from_fk_id IN NUMBER,
38 p_to_fk_id IN NUMBER,
39 p_parent_entity_name IN VARCHAR2,
40 p_batch_id IN NUMBER,
41 p_batch_party_id IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2);
43
44 PROCEDURE OKL_INSURANCE_AGENT_SITE_MERGE(
45 p_entity_name IN VARCHAR2,
46 p_from_id IN NUMBER,
47 x_to_id OUT NOCOPY NUMBER,
48 p_from_fk_id IN NUMBER,
49 p_to_fk_id IN NUMBER,
50 p_parent_entity_name IN VARCHAR2,
51 p_batch_id IN NUMBER,
52 p_batch_party_id IN NUMBER,
53 x_return_status OUT NOCOPY VARCHAR2);
54
55 --------------------------------------------------
56 -----------API SPEC ------------------------------
57 --------------------------------------------------
58 -- Procedure to merge parties
59 PROCEDURE OKL_OPEN_INT_PARTY_MERGE(
60 p_entity_name IN VARCHAR2,
61 p_from_id IN NUMBER,
62 x_to_id OUT NOCOPY NUMBER,
63 p_from_fk_id IN NUMBER,
64 p_to_fk_id IN NUMBER,
65 p_parent_entity_name IN VARCHAR2,
66 p_batch_id IN NUMBER,
67 p_batch_party_id IN NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2);
69
70 -- Start BAKUCHIB Bug#2892149
71 -- Procedure to merge Relocate Assets for PAC_ID
72 PROCEDURE party_merge_pac_id (
73 p_entity_name IN VARCHAR2,
74 p_from_id IN NUMBER,
75 x_to_id OUT NOCOPY NUMBER,
76 p_from_fk_id IN NUMBER,
77 p_to_fk_id IN NUMBER,
78 p_parent_entity_name IN VARCHAR2,
79 p_batch_id IN NUMBER,
80 p_batch_party_id IN NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2);
82
83 -- Procedure to merge Relocate Assets for IST_ID
84 PROCEDURE party_merge_ist_id (
85 p_entity_name IN VARCHAR2,
86 p_from_id IN NUMBER,
87 x_to_id OUT NOCOPY NUMBER,
88 p_from_fk_id IN NUMBER,
89 p_to_fk_id IN NUMBER,
90 p_parent_entity_name IN VARCHAR2,
91 p_batch_id IN NUMBER,
92 p_batch_party_id IN NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2);
94 -- End BAKUCHIB Bug#2892149
95
96 --Start of merge code pgomes
97 PROCEDURE OKL_XSI_PARTY_MERGE(
98 p_entity_name IN VARCHAR2,
99 p_from_id IN NUMBER,
100 x_to_id OUT NOCOPY NUMBER,
101 p_from_fk_id IN NUMBER,
102 p_to_fk_id IN NUMBER,
103 p_parent_entity_name IN VARCHAR2,
104 p_batch_id IN NUMBER,
105 p_batch_party_id IN NUMBER,
106 x_return_status OUT NOCOPY VARCHAR2);
107
108 PROCEDURE okl_tai_party_merge(
109 p_entity_name IN VARCHAR2,
110 p_from_id IN NUMBER,
111 x_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 PROCEDURE okl_cnr_party_merge(
120 p_entity_name IN VARCHAR2,
121 p_from_id IN NUMBER,
122 x_to_id 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 OUT NOCOPY VARCHAR2);
129 --End of merge code pgomes
130
131 --procedure for install at site merge routine for party merge
132 -- for entity :OKL_TXL_ITM_INSTS
133 Procedure OKL_INSTALL_SITE_MERGE
134 (p_entity_name IN VARCHAR2,
135 p_from_id IN NUMBER,
136 x_to_id OUT NOCOPY NUMBER,
137 p_from_fk_id IN NUMBER,
138 p_to_fk_id IN NUMBER,
139 p_parent_entity_name IN VARCHAR2,
140 p_batch_id IN NUMBER,
141 p_batch_party_id IN NUMBER,
142 x_return_status OUT NOCOPY VARCHAR2);
143
144 ------------------------------------------------------------------------------
145 -- Start of comments
146 -- Procedure Name : ITI_OBJECT_ID1_NEW
147 -- Description : Updating the table: OKL_TXL_ITM_INSTS for column: OBJECT_ID1_NEW
148 -- Business Rules : performing PARTY MERGE for table: OKL_TXL_ITM_INSTS and col: OBJECT_ID1_NEW
149 -- Parameters :
150 -- Version : 1.0
151 -- End of comments
152 ------------------------------------------------------------------------------
153 PROCEDURE ITI_OBJECT_ID1_NEW(
154 p_entity_name IN VARCHAR2,
155 p_from_id IN NUMBER,
156 x_to_id OUT NOCOPY NUMBER,
157 p_from_fk_id IN NUMBER,
158 p_to_fk_id IN NUMBER,
159 p_parent_entity_name IN VARCHAR2,
160 p_batch_id IN NUMBER,
161 p_batch_party_id IN NUMBER,
162 x_return_status OUT NOCOPY VARCHAR2);
163
164 -- Procedure to merge customer id for party merge
165 PROCEDURE OKL_RCA_PARTY_MERGE(
166 p_entity_name IN VARCHAR2,
167 p_from_id IN NUMBER,
168 x_to_id OUT NOCOPY NUMBER,
169 p_from_fk_id IN NUMBER,
170 p_to_fk_id IN NUMBER,
171 p_parent_entity_name IN VARCHAR2,
172 p_batch_id IN NUMBER,
173 p_batch_party_id IN NUMBER,
174 x_return_status OUT NOCOPY VARCHAR2);
175
176 ------------------------------------------------------------------------------
177 -- Start of comments
178 -- Procedure Name : ASS_INSTALL_SITE_ID
179 -- Description : Updating the table: OKL_ASSETS_B for column: INSTALL_SITE_ID
180 -- Business Rules : performing PARTY MERGE for table: OKL_ASSETS_B and col: INSTALL_SITE_ID
181 -- Parameters :
182 -- Version : 1.0
183 -- End of comments
184 ------------------------------------------------------------------------------
185 PROCEDURE ASS_INSTALL_SITE_ID (
186 p_entity_name IN VARCHAR2,
187 p_from_id IN NUMBER,
188 x_to_id 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 OUT NOCOPY VARCHAR2);
195
196 ------------------------------------------------------------------------------
197 -- Start of comments
198 -- Procedure Name : LAP_PARTY_MERGE
199 -- Description : Updating the table: OKL_LEASE_APPS_ALL_B for column:
200 -- PROSPECT_ID and PROSPECT_ADDRESS_ID
201 -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_APPS_ALL_B
202 -- and col: PROSPECT_ID and PROSPECT_ADDRESS_ID
203 -- Parameters :
204 -- Version : 1.0
205 -- End of comments
206 ------------------------------------------------------------------------------
207 PROCEDURE LAP_PARTY_MERGE (
208 p_entity_name IN VARCHAR2,
209 p_from_id IN NUMBER,
210 x_to_id OUT NOCOPY NUMBER,
211 p_from_fk_id IN NUMBER,
212 p_to_fk_id IN NUMBER,
213 p_parent_entity_name IN VARCHAR2,
214 p_batch_id IN NUMBER,
215 p_batch_party_id IN NUMBER,
216 x_return_status OUT NOCOPY VARCHAR2);
217
218 ------------------------------------------------------------------------------
219 -- Start of comments
220 -- Procedure Name : LOP_PARTY_MERGE
221 -- Description : Updating the table: OKL_LEASE_OPPS_ALL_B for column:
222 -- PROSPECT_ID, PROSPECT_ADDRESS_ID and INSTALL_SITE_ID
223 -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_OPPS_ALL_B
224 -- and col: PROSPECT_ID, PROSPECT_ADDRESS_ID and INSTALL_SITE_ID
225 -- Parameters :
226 -- Version : 1.0
227 -- End of comments
228 ------------------------------------------------------------------------------
229 PROCEDURE LOP_PARTY_MERGE (
230 p_entity_name IN VARCHAR2,
231 p_from_id IN NUMBER,
232 x_to_id OUT NOCOPY NUMBER,
233 p_from_fk_id IN NUMBER,
234 p_to_fk_id IN NUMBER,
235 p_parent_entity_name IN VARCHAR2,
236 p_batch_id IN NUMBER,
237 p_batch_party_id IN NUMBER,
238 x_return_status OUT NOCOPY VARCHAR2);
239
240 ------------------------------------------------------------------------------
241 -- Start of comments
242 -- Procedure Name : LOP_USAGE_LOCATION
243 -- Description : Updating the table: OKL_LEASE_OPPS_ALL_B for column:
244 -- USAGE_LOCATION_ID
245 -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_OPPS_ALL_B
246 -- and col: USAGE_LOCATION_ID
247 -- Parameters :
248 -- Version : 1.0
249 -- End of comments
250 ------------------------------------------------------------------------------
251 PROCEDURE LOP_USAGE_LOCATION (
252 p_entity_name IN VARCHAR2,
253 p_from_id IN NUMBER,
254 x_to_id OUT NOCOPY NUMBER,
255 p_from_fk_id IN NUMBER,
256 p_to_fk_id IN NUMBER,
257 p_parent_entity_name IN VARCHAR2,
258 p_batch_id IN NUMBER,
259 p_batch_party_id IN NUMBER,
260 x_return_status OUT NOCOPY VARCHAR2);
261
262 ------------------------------------------------------------------------------
263 -- Start of comments
264 -- Procedure Name : TXS_BILL_TO_PARTY_MERGE
265 -- Description : Updating the table: OKL_TAX_SOURCES for column:
266 -- BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
267 -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES
268 -- and col: BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
269 -- Parameters :
270 -- Version : 1.0
271 -- End of comments
272 ------------------------------------------------------------------------------
273 PROCEDURE TXS_BILL_TO_PARTY_MERGE (
274 p_entity_name IN VARCHAR2,
275 p_from_id IN NUMBER,
276 x_to_id OUT NOCOPY NUMBER,
277 p_from_fk_id IN NUMBER,
278 p_to_fk_id IN NUMBER,
279 p_parent_entity_name IN VARCHAR2,
280 p_batch_id IN NUMBER,
281 p_batch_party_id IN NUMBER,
282 x_return_status OUT NOCOPY VARCHAR2);
283
284 ------------------------------------------------------------------------------
285 -- Start of comments
286 -- Procedure Name : TXS_SHIP_TO_PARTY_MERGE
287 -- Description : Updating the table: OKL_TAX_SOURCES for column:
288 -- SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
289 -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES
290 -- and col: SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
291 -- Parameters :
292 -- Version : 1.0
293 -- End of comments
294 ------------------------------------------------------------------------------
295 PROCEDURE TXS_SHIP_TO_PARTY_MERGE (
296 p_entity_name IN VARCHAR2,
297 p_from_id IN NUMBER,
298 x_to_id OUT NOCOPY NUMBER,
299 p_from_fk_id IN NUMBER,
300 p_to_fk_id IN NUMBER,
301 p_parent_entity_name IN VARCHAR2,
302 p_batch_id IN NUMBER,
303 p_batch_party_id IN NUMBER,
304 x_return_status OUT NOCOPY VARCHAR2);
305
306 ------------------------------------------------------------------------------
307 -- Start of comments
308 -- Procedure Name : TXST_BILL_TO_PARTY_MERGE
309 -- Description : Updating the table: OKL_TAX_SOURCES_T for column:
310 -- BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
311 -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES_T
312 -- and col: BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
313 -- Parameters :
314 -- Version : 1.0
315 -- End of comments
316 ------------------------------------------------------------------------------
317 PROCEDURE TXST_BILL_TO_PARTY_MERGE (
318 p_entity_name IN VARCHAR2,
319 p_from_id IN NUMBER,
320 x_to_id 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 OUT NOCOPY VARCHAR2);
327
328 ------------------------------------------------------------------------------
329 -- Start of comments
330 -- Procedure Name : TXST_SHIP_TO_PARTY_MERGE
331 -- Description : Updating the table: OKL_TAX_SOURCES_T for column:
332 -- SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
333 -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES_T
334 -- and col: SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
335 -- Parameters :
336 -- Version : 1.0
337 -- End of comments
338 ------------------------------------------------------------------------------
339 PROCEDURE TXST_SHIP_TO_PARTY_MERGE (
340 p_entity_name IN VARCHAR2,
341 p_from_id IN NUMBER,
342 x_to_id OUT NOCOPY NUMBER,
346 p_batch_id IN NUMBER,
343 p_from_fk_id IN NUMBER,
344 p_to_fk_id IN NUMBER,
345 p_parent_entity_name IN VARCHAR2,
347 p_batch_party_id IN NUMBER,
348 x_return_status OUT NOCOPY VARCHAR2);
349
350 ------------------------------------------------------------------------------
351 -- Start of comments
352 -- Procedure Name : TCN_PARTY_REL_ID2_NEW
353 -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID2_NEW
354 -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID2_NEW
355 -- Parameters :
356 -- Version : 1.0
357 -- End of comments
358 ------------------------------------------------------------------------------
359 PROCEDURE TCN_PARTY_REL_ID2_NEW (
360 p_entity_name IN VARCHAR2,
361 p_from_id IN NUMBER,
362 x_to_id OUT NOCOPY NUMBER,
363 p_from_fk_id IN NUMBER,
364 p_to_fk_id IN NUMBER,
365 p_parent_entity_name IN VARCHAR2,
366 p_batch_id IN NUMBER,
367 p_batch_party_id IN NUMBER,
368 x_return_status OUT NOCOPY VARCHAR2);
369
370 ------------------------------------------------------------------------------
371 -- Start of comments
372 -- Procedure Name : QPY_PARTY_OBJECT1_ID1
373 -- Description : Updating the table: OKL_QUOTE_PARTIES for column: PARTY_OBJECT1_ID1
374 -- Business Rules : performing PARTY MERGE for table: OKL_QUOTE_PARTIES and col: PARTY_OBJECT1_ID1
375 -- Parameters :
376 -- Version : 1.0
377 -- End of comments
378 ------------------------------------------------------------------------------
379 PROCEDURE QPY_PARTY_OBJECT1_ID1 (
380 p_entity_name IN VARCHAR2,
381 p_from_id IN NUMBER,
382 x_to_id OUT NOCOPY NUMBER,
383 p_from_fk_id IN NUMBER,
384 p_to_fk_id IN NUMBER,
385 p_parent_entity_name IN VARCHAR2,
386 p_batch_id IN NUMBER,
387 p_batch_party_id IN NUMBER,
388 x_return_status OUT NOCOPY VARCHAR2);
389
390 ------------------------------------------------------------------------------
391 -- Start of comments
392 -- Procedure Name : QPY_CONTACT_OBJECT1_ID1
393 -- Description : Updating the table: OKL_QUOTE_PARTIES for column: CONTACT_OBJECT1_ID1
394 -- Business Rules : performing PARTY MERGE for table: OKL_QUOTE_PARTIES and col: CONTACT_OBJECT1_ID1
395 -- Parameters :
396 -- Version : 1.0
397 -- End of comments
398 ------------------------------------------------------------------------------
399 PROCEDURE QPY_CONTACT_OBJECT1_ID1 (
400 p_entity_name IN VARCHAR2,
401 p_from_id IN NUMBER,
402 x_to_id OUT NOCOPY NUMBER,
403 p_from_fk_id IN NUMBER,
404 p_to_fk_id IN NUMBER,
405 p_parent_entity_name IN VARCHAR2,
406 p_batch_id IN NUMBER,
407 p_batch_party_id IN NUMBER,
408 x_return_status OUT NOCOPY VARCHAR2);
409
410 ------------------------------------------------------------------------------
411 -- Start of comments
412 -- Procedure Name : TIN_PARTY_OBJECT_ID1
413 -- Description : Updating the table: OKL_TERMNT_INTF_PTY for column: PARTY_OBJECT_ID1
414 -- Business Rules : performing PARTY MERGE for table: OKL_TERMNT_INTF_PTY and col: PARTY_OBJECT_ID1
415 -- Parameters :
416 -- Version : 1.0
417 -- End of comments
418 ------------------------------------------------------------------------------
419 PROCEDURE TIN_PARTY_OBJECT_ID1 (
420 p_entity_name IN VARCHAR2,
421 p_from_id IN NUMBER,
422 x_to_id OUT NOCOPY NUMBER,
423 p_from_fk_id IN NUMBER,
424 p_to_fk_id IN NUMBER,
425 p_parent_entity_name IN VARCHAR2,
426 p_batch_id IN NUMBER,
427 p_batch_party_id IN NUMBER,
428 x_return_status OUT NOCOPY VARCHAR2);
429
430 ------------------------------------------------------------------------------
431 -- Start of comments
432 -- Procedure Name : CPL_PARTY_MERGE
433 -- Description : Updating the table: OKC_K_PARTY_ROLES_B for column: OBJECT1_ID1
434 -- Business Rules : performing PARTY MERGE for table: OKC_K_PARTY_ROLES_B and col: OBJECT1_ID1
435 -- for the records created for Lease Management
436 -- Parameters :
437 -- Version : 1.0
438 -- End of comments
439 ------------------------------------------------------------------------------
440 PROCEDURE CPL_PARTY_MERGE (
441 p_entity_name IN VARCHAR2,
442 p_from_id IN NUMBER,
443 x_to_id OUT NOCOPY NUMBER,
444 p_from_fk_id IN NUMBER,
445 p_to_fk_id IN NUMBER,
446 p_parent_entity_name IN VARCHAR2,
447 p_batch_id IN NUMBER,
448 p_batch_party_id IN NUMBER,
449 x_return_status OUT NOCOPY VARCHAR2);
450
451 ------------------------------------------------------------------------------
452 -- Start of comments
453 -- Procedure Name : CPL_PARTY_SITE_MERGE
454 -- Description : Updating the table: OKC_K_PARTY_ROLES_B for column: OBJECT1_ID1
455 -- Business Rules : performing PARTY MERGE for table: OKC_K_PARTY_ROLES_B and col: OBJECT1_ID1
459 -- End of comments
456 -- for the records created by Lease Management for Party Site
457 -- Parameters :
458 -- Version : 1.0
460 ------------------------------------------------------------------------------
461 PROCEDURE CPL_PARTY_SITE_MERGE (
462 p_entity_name IN VARCHAR2,
463 p_from_id IN NUMBER,
464 x_to_id OUT NOCOPY NUMBER,
465 p_from_fk_id IN NUMBER,
466 p_to_fk_id IN NUMBER,
467 p_parent_entity_name IN VARCHAR2,
468 p_batch_id IN NUMBER,
469 p_batch_party_id IN NUMBER,
470 x_return_status OUT NOCOPY VARCHAR2);
471
472 /*-------------------------------------------------------------
473 | PROCEDURE
474 | LOP_ACCOUNT_MERGE
475 | DESCRIPTION :
476 | Account merge procedure for the table, OKL_LEASE_OPPORTUNITIES_B
477 |
478 | NOTES:
479 |--------------------------------------------------------------*/
480 PROCEDURE LOP_ACCOUNT_MERGE (
481 req_id NUMBER,
482 set_num NUMBER,
483 process_mode VARCHAR2);
484
485 /*-------------------------------------------------------------
486 | PROCEDURE
487 | LAP_ACCOUNT_MERGE
488 | DESCRIPTION :
489 | Account merge procedure for the table, OKL_LEASE_APPLICATIONS_B
490 |
491 | NOTES:
492 |--------------------------------------------------------------*/
493 PROCEDURE LAP_ACCOUNT_MERGE (
494 req_id NUMBER,
495 set_num NUMBER,
496 process_mode VARCHAR2);
497
498 /*-------------------------------------------------------------
499 | PROCEDURE
500 | XSI_ACCOUNT_MERGE
501 | DESCRIPTION :
502 | Account merge procedure for the table, OKL_EXT_SELL_INVS_B
503 |
504 | NOTES:
505 |--------------------------------------------------------------*/
506 PROCEDURE XSI_ACCOUNT_MERGE (
507 req_id NUMBER,
508 set_num NUMBER,
509 process_mode VARCHAR2);
510
511 /*-------------------------------------------------------------
512 | PROCEDURE
513 | TXST_ACCOUNT_MERGE
514 | DESCRIPTION :
515 | Account merge procedure for the table, OKL_TAX_SOURCES_T
516 |
517 | NOTES:
518 |--------------------------------------------------------------*/
519 PROCEDURE TXST_ACCOUNT_MERGE (
520 req_id NUMBER,
521 set_num NUMBER,
522 process_mode VARCHAR2);
523
524 /*-------------------------------------------------------------
525 | PROCEDURE
526 | TXS_ACCOUNT_MERGE
527 | DESCRIPTION :
528 | Account merge procedure for the table, OKL_TAX_SOURCES
529 |
530 | NOTES:
531 |--------------------------------------------------------------*/
532 PROCEDURE TXS_ACCOUNT_MERGE (
533 req_id NUMBER,
534 set_num NUMBER,
535 process_mode VARCHAR2);
536
537 /*-------------------------------------------------------------
538 | PROCEDURE
539 | TAI_ACCOUNT_MERGE
540 | DESCRIPTION :
541 | Account merge procedure for the table, OKL_TRX_AR_INVOICES_B
542 |
543 | NOTES:
544 |--------------------------------------------------------------*/
545 PROCEDURE TAI_ACCOUNT_MERGE (
546 req_id NUMBER,
547 set_num NUMBER,
548 process_mode VARCHAR2);
549
550 /*-------------------------------------------------------------
551 | PROCEDURE
552 | RCA_ACCOUNT_MERGE
553 | DESCRIPTION :
554 | Account merge procedure for the table, OKL_TXL_RCPT_APPS_B
555 |
556 | NOTES:
557 |--------------------------------------------------------------*/
561 process_mode VARCHAR2);
558 PROCEDURE RCA_ACCOUNT_MERGE (
559 req_id NUMBER,
560 set_num NUMBER,
562
563 /*-------------------------------------------------------------
564 | PROCEDURE
565 | CNR_ACCOUNT_MERGE
566 | DESCRIPTION :
567 | Account merge procedure for the table, OKL_CNSLD_AR_HDRS_B
568 |
569 | NOTES:
570 |--------------------------------------------------------------*/
571 PROCEDURE CNR_ACCOUNT_MERGE (
572 req_id NUMBER,
573 set_num NUMBER,
574 process_mode VARCHAR2);
575
576 /*-------------------------------------------------------------
577 | PROCEDURE
578 | CLG_ACCOUNT_MERGE
579 | DESCRIPTION :
580 | Account merge procedure for the table, OKL_CNTR_LVLNG_GRPS_B
581 |
582 | NOTES:
583 |--------------------------------------------------------------*/
584 PROCEDURE CLG_ACCOUNT_MERGE (
585 req_id NUMBER,
586 set_num NUMBER,
587 process_mode VARCHAR2);
588
589 /*-------------------------------------------------------------
590 | PROCEDURE
591 | ASE_ACCOUNT_MERGE
592 | DESCRIPTION :
593 | Account merge procedure for the table, OKL_ACCT_SOURCES
594 |--------------------------------------------------------------*/
595 PROCEDURE ASE_ACCOUNT_MERGE (
596 req_id NUMBER,
597 set_num NUMBER,
598 process_mode VARCHAR2) ;
599
600 /*-------------------------------------------------------------
601 | PROCEDURE
602 | SID_ACCOUNT_MERGE
603 | DESCRIPTION :
604 | Account merge procedure for the table, OKL_SUPP_INVOICE_DTLS
605 |--------------------------------------------------------------*/
606 PROCEDURE SID_ACCOUNT_MERGE (
607 req_id NUMBER,
608 set_num NUMBER,
609 process_mode VARCHAR2) ;
610
611 /*-------------------------------------------------------------
612 | PROCEDURE
613 | SIDH_ACCOUNT_MERGE
614 | DESCRIPTION :
615 | Account merge procedure for the table, OKL_SUPP_INVOICE_DTLS_H
616 |--------------------------------------------------------------*/
617 PROCEDURE SIDH_ACCOUNT_MERGE (
618 req_id NUMBER,
619 set_num NUMBER,
620 process_mode VARCHAR2);
621
622 ----------------------------------------------------------------------------------------------------------
623 -- Start of comments
624
625 -- Procedure Name : TCN_PARTY_REL_ID1_NEW
626 -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID1_NEW
627 -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID1_NEW
628 -- Parameters :
629 -- Version : 1.0
630 -- End of comments
631 -----------------------------------------------------------------------------------------------------------
632 PROCEDURE TCN_PARTY_REL_ID1_NEW (
633 p_entity_name IN VARCHAR2,
634 p_from_id IN NUMBER,
635 x_to_id OUT NOCOPY NUMBER,
636 p_from_fk_id IN NUMBER,
637 p_to_fk_id IN NUMBER,
638 p_parent_entity_name IN VARCHAR2,
639 p_batch_id IN NUMBER,
640 p_batch_party_id IN NUMBER,
641 x_return_status OUT NOCOPY VARCHAR2
642 );
643
644 ----------------------------------------------------------------------------------------------------------
645 -- Start of comments
646 -- Procedure Name : TCN_PARTY_REL_ID1_OLD
647 -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID1_OLD
648 -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID1_OLD
649 -- Parameters :
650 -- Version : 1.0
651 -- End of comments
652 -----------------------------------------------------------------------------------------------------------
653 PROCEDURE TCN_PARTY_REL_ID1_OLD (
654
655 p_entity_name IN VARCHAR2,
656 p_from_id IN NUMBER,
657 x_to_id OUT NOCOPY NUMBER,
658 p_from_fk_id IN NUMBER,
659 p_to_fk_id IN NUMBER,
660 p_parent_entity_name IN VARCHAR2,
661 p_batch_id IN NUMBER,
662 p_batch_party_id IN NUMBER,
663 x_return_status OUT NOCOPY VARCHAR2
664 );
665
666 ----------------------------------------------------------------------------------------------------------
667 -- Start of comments
668
669 -- Procedure Name : TCN_PARTY_REL_ID2_OLD
670 -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID2_OLD
671 -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID2_OLD
672 -- Parameters :
673 -- Version : 1.0
674 -- End of comments
675 -----------------------------------------------------------------------------------------------------------
676 PROCEDURE TCN_PARTY_REL_ID2_OLD (
677 p_entity_name IN VARCHAR2,
678 p_from_id IN NUMBER,
679 x_to_id OUT NOCOPY NUMBER,
680 p_from_fk_id IN NUMBER,
681 p_to_fk_id IN NUMBER,
682 p_parent_entity_name IN VARCHAR2,
683 p_batch_id IN NUMBER,
684 p_batch_party_id IN NUMBER,
685 x_return_status OUT NOCOPY VARCHAR2
686 );
687
688 ------------------------------------------------------------------------------
689 -- Start of comments
690 -- Procedure Name : RUL_PARTY_SITE_MERGE
691 -- Description : Updating the table: OKC_RULES_B for column: OBJECT1_ID1
692 -- Business Rules : performing PARTY MERGE for table: OKC_RULES_B and col: OBJECT1_ID1
693 -- for the records created by Lease Management for Party Site
694 -- Parameters :
695 -- Version : 1.0
696 -- End of comments
697 ------------------------------------------------------------------------------
698 PROCEDURE RUL_PARTY_SITE_MERGE (
699 p_entity_name IN VARCHAR2,
700 p_from_id IN NUMBER,
701 x_to_id OUT NOCOPY NUMBER,
702 p_from_fk_id IN NUMBER,
703 p_to_fk_id IN NUMBER,
704 p_parent_entity_name IN VARCHAR2,
705 p_batch_id IN NUMBER,
706 p_batch_party_id IN NUMBER,
707 x_return_status OUT NOCOPY VARCHAR2);
708
709 /*-------------------------------------------------------------------------
710 | PROCEDURE
711 | RUL_ACCOUNT_MERGE
712 | DESCRIPTION :
713 | Account merge procedure for the table, OKC_RULES_B for OKL
714 | specific usage of rules architecture. OKL uses rules
715 | architecture for storing vendor billing information where
716 | billing party is stored in rules tables for the vendor account
717 | This API will be called prior to the OKC hook of account merge.
718 *-------------------------------------------------------------------------*/
719 PROCEDURE RUL_ACCOUNT_MERGE(
720 req_id NUMBER,
721 set_num NUMBER,
722 process_mode VARCHAR2);
723
724 END OKL_PARTY_MERGE_PUB;