[Home] [Help]
PACKAGE: APPS.CSC_ACCOUNT_MERGE_PKG
Source
1 PACKAGE CSC_ACCOUNT_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: cscvmacs.pls 115.1 2003/05/12 11:40:07 bhroy noship $ */
3 -- Start of Comments
4 -- Package name : CSC_ACCOUNT_MERGE_PKG
5 -- Purpose : Merges duplicate customer accounts in Customer Care
6 -- tables.
7 --
8 -- History
9 -- MM-DD-YYYY NAME MODIFICATIONS
10 -- 10-06-2000 dejoseph Created.
11 -- 12-02-2003 bhroy All parameter names changed to match with the prcedures generated by Perl script, i.e p_request_id -> req_id, p_set_number -> set_num, p_process_mode -> process_mode
12 --
13 -- End of Comments
14
15 -- Global variable declarations
16 G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSC_ACCOUNT_MERGE_PKG';
17 G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvmacs.pls';
18
19 -- *******************************************************
20 -- Start of Comments
21 -- *******************************************************
22 -- API Name: csc_merge_all_accounts
23 -- Purpose : Calls all the individually defined account merge procedures
24 -- of Customer Care. This proc. is not being used, but can be
25 -- used in future as a single call out from the main TCA proc.
26 -- to merge all accounts in Customer Care tables.
27 -- Type : Private
28 -- Pre-Req : None.
29 -- Parameters:
30 -- IN
31 -- req_id IN NUMBER Required
32 -- set_num IN NUMBER Required
33 -- process_mode IN VARCHAR2 Optional Default = 'LOCK'
34 -- OUT:
35 --
36 -- Version : Current version 1.0
37 --
38 -- End of Comments
39 --
40 PROCEDURE CSC_MERGE_ALL_ACCOUNTS (
41 req_id IN NUMBER,
42 set_num IN NUMBER,
43 process_mode IN VARCHAR2 := 'LOCK' );
44
45 -- *******************************************************
46 -- Start of Comments
47 -- *******************************************************
48 -- API Name: csc_customers_merge
49 -- Purpose : Merges duplicate customer accounts in CSC_CUSTOMERS table.
50 -- Type : Private
51 -- Pre-Req : None.
52 -- Parameters:
53 -- IN
54 -- req_id IN NUMBER Required
55 -- set_num IN NUMBER Required
56 -- process_mode IN VARCHAR2 Optional Default = 'LOCK'
57 -- OUT:
58 --
59 -- Version : Current version 1.0
60 --
61 -- End of Comments
62 --
63 PROCEDURE CSC_CUSTOMERS_MERGE (
64 req_id IN NUMBER,
65 set_num IN NUMBER,
66 process_mode IN VARCHAR2 := 'LOCK' );
67
68 -- *******************************************************
69 -- Start of Comments
70 -- *******************************************************
71 -- API Name: csc_customers_audit_hist_merge
72 -- Purpose : Merges duplicate customer accounts in
73 -- CSC_CUSTOMERS_AUDIT_HIST table.
74 -- Type : Private
75 -- Pre-Req : None.
76 -- Parameters:
77 -- IN
78 -- req_id IN NUMBER Required
79 -- set_num IN NUMBER Required
80 -- process_mode IN VARCHAR2 Optional Default = 'LOCK'
81 -- OUT:
82 --
83 -- Version : Current version 1.0
84 --
85 -- End of Comments
86 --
87 PROCEDURE CSC_CUSTOMERS_AUDIT_HIST_MERGE (
88 req_id IN NUMBER,
89 set_num IN NUMBER,
90 process_mode IN VARCHAR2 := 'LOCK' );
91
92 -- *******************************************************
93 -- Start of Comments
94 -- *******************************************************
95 -- API Name: csc_customized_plans_merge
96 -- Purpose : Merges duplicate customer accounts in
97 -- CSC_CUSTOMIZED_PLANS table.
98 -- Type : Private
99 -- Pre-Req : None.
100 -- Parameters:
101 -- IN
102 -- req_id IN NUMBER Required
103 -- set_num IN NUMBER Required
104 -- process_mode IN VARCHAR2 Optional Default = 'LOCK'
105 -- OUT:
106 --
107 -- Version : Current version 1.0
108 --
109 -- End of Comments
110 --
111 PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (
112 req_id IN NUMBER,
113 set_num IN NUMBER,
114 process_mode IN VARCHAR2 := 'LOCK' );
115
116 -- *******************************************************
117 -- Start of Comments
118 -- *******************************************************
119 -- API Name: csc_cust_plans_merge
120 -- Purpose : Merges duplicate customer accounts in
121 -- CSC_CUST_PLANS table.
122 -- Type : Private
123 -- Pre-Req : None.
124 -- Parameters:
125 -- IN
126 -- req_id IN NUMBER Required
127 -- set_num IN NUMBER Required
128 -- process_mode IN VARCHAR2 Optional Default = 'LOCK'
129 -- OUT:
130 --
131 -- Version : Current version 1.0
132 --
133 -- End of Comments
134 --
135 PROCEDURE CSC_CUST_PLANS_MERGE (
136 req_id IN NUMBER,
137 set_num IN NUMBER,
138 process_mode IN VARCHAR2 := 'LOCK' );
139
140 -- *******************************************************
141 -- Start of Comments
142 -- *******************************************************
143 -- API Name: csc_cust_plans_audit_merge
144 -- Purpose : Merges duplicate customer accounts in
145 -- CSC_CUST_PLANS_AUDIT table.
146 -- Type : Private
147 -- Pre-Req : None.
148 -- Parameters:
149 -- IN
150 -- req_id IN NUMBER Required
151 -- set_num IN NUMBER Required
152 -- process_mode IN VARCHAR2 Optional Default = 'LOCK'
153 -- OUT:
154 --
155 -- Version : Current version 1.0
156 --
157 -- End of Comments
158 --
159 PROCEDURE CSC_CUST_PLANS_AUDIT_MERGE (
160 req_id IN NUMBER,
161 set_num IN NUMBER,
162 process_mode IN VARCHAR2 := 'LOCK' );
163
164 END CSC_ACCOUNT_MERGE_PKG;