1 PACKAGE JTF_TASK_CUST_MERGE_PKG AUTHID CURRENT_USER as
2 /* $Header: jtftkmgs.pls 115.8 2003/02/19 23:20:25 cjang ship $ */
3 --/**==================================================================*
4 --| Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
5 --| All rights reserved. |
6 --+====================================================================+
7 -- Start of comments
8 -- API name : JTF_TASK_CUST_MERGE_PKG
9 -- Type : Public.
10 -- Function : This is a customer merge package. It performs the merge operation
11 -- for Tasks and Escalations modules. It should be called from
12 -- the Main customer merege procedures.
13 -- Pre-reqs : None.
14 -- Parameters :
15 -- name direction type required?
16 -- ---- --------- ---- ---------
17 -- request_id IN NUMBER required
18 -- set_number IN NUMBER required
19 -- process_mode IN VARCHAR2 required
20 --
21 -- Version : 1.0
22 -------------------------------------------------------------------------------------------
23 -- History
24 -------------------------------------------------------------------------------------------
25 -- 01-FEB-01 tivanov Created.
26 -- 13-AUG-02 chanik jang Added get_new_address_id() for the bug 2465855
27 -- 12-FEB-03 Chanik Jang 1) Customer Account Merge allows to merge account
28 -- only in the same party
29 -- 2) If you want to merge between different parties,
30 -- submit party merge first.
31 -- 3) The lock mode is not implemented
32 -- 4) For performance, the codes generated the perl script
33 -- is used. Refer http://www-apps.us.oracle.com/~csng/AMInstructions.html
34 ---------------------------------------------------------------------------------
35 --
36 -- End of comments
37 -------------------------------------------------------------------------------------------
38 --
39 -- Procedure Task_Account_Merge performs merging of the following foreign keys:
40 -- jtf_tasks_b.cust_account_id
41 -- jtf_tasks_audits_b.new_cust_account_id
42 -- jtf_tasks_audits_b.old_cust_account_id
43 -- jtf_perz_query_param.parameter_value for account id and account number
44 --
45 -- Following rules are applied:
46 -- 1. Customer account merge allows to merge the accounts within the same party.
47 -- 2. If a user wants to merge between different parties, he/she must run party merge first.
48 -- 3. This JTF Task Account merge will update only customer account id and account number only
49 -------------------------------------------------------------------------------------------
50
51 PROCEDURE Task_Account_Merge(
52 p_request_id IN NUMBER,
53 p_set_number IN NUMBER,
54 p_process_mode IN VARCHAR2);
55
56 END JTF_TASK_CUST_MERGE_PKG;