[Home] [Help]
PACKAGE: APPS.OZF_ACCOUNT_MERGE_PKG
Source
1 PACKAGE OZF_ACCOUNT_MERGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: ozfvcmrs.pls 115.7 2004/05/07 05:22:28 samaresh ship $ */
3
4 --------------------------------------------------------------------------------
5 -- *******************************************************
6 -- Start of Comments
7 -- *******************************************************
8 -- API Name: merge_acct_alloc
9 -- Purpose : Merges duplicate customer accounts in
10 -- ozf_account_allocations table.
11 -- Type : Private
12 -- Pre-Req : None.
13 -- Parameters:
14 -- IN
15 -- p_request_id IN NUMBER Required
16 -- p_set_number IN NUMBER Required
17 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
18 -- OUT:
19 --
20 -- Version : Current version 1.0
21 --
22 -- End of Comments
23 --
24 --------------------------------------------------------------------------------
25 PROCEDURE merge_acct_alloc (
26 req_id NUMBER,
27 set_num NUMBER,
28 process_mode VARCHAR2
29 );
30
31
32 --------------------------------------------------------------------------------
33 -- *******************************************************
34 -- Start of Comments
35 -- *******************************************************
36 -- API Name: merge_claim_lines
37 -- Purpose : Merges duplicate customer accounts in
38 -- ozf_claim_lines_all table.
39 -- Type : Private
40 -- Pre-Req : None.
41 -- Parameters:
42 -- IN
43 -- p_request_id IN NUMBER Required
44 -- p_set_number IN NUMBER Required
45 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
46 -- OUT:
47 --
48 -- Version : Current version 1.0
49 --
50 -- End of Comments
51 --
52 --------------------------------------------------------------------------------
53 PROCEDURE merge_claim_lines (
54 req_id NUMBER,
55 set_num NUMBER,
56 process_mode VARCHAR2
57 );
58
59
60 --------------------------------------------------------------------------------
61 -- *******************************************************
62 -- Start of Comments
63 -- *******************************************************
64 -- API Name: merge_claim_lines_hist
65 -- Purpose : Merges duplicate customer accounts in
66 -- ozf_claim_lines_hist_all table.
67 -- Type : Private
68 -- Pre-Req : None.
69 -- Parameters:
70 -- IN
71 -- p_request_id IN NUMBER Required
72 -- p_set_number IN NUMBER Required
73 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
74 -- OUT:
75 --
76 -- Version : Current version 1.0
77 --
78 -- End of Comments
79 --
80 --------------------------------------------------------------------------------
81 PROCEDURE merge_claim_lines_hist (
82 req_id NUMBER,
83 set_num NUMBER,
84 process_mode VARCHAR2
85 );
86
87
88 --------------------------------------------------------------------------------
89 -- *******************************************************
90 -- Start of Comments
91 -- *******************************************************
92 -- API Name: merge_claims
93 -- Purpose : Merges duplicate customer accounts in
94 -- ozf_claims_all table.
95 -- Type : Private
96 -- Pre-Req : None.
97 -- Parameters:
98 -- IN
99 -- p_request_id IN NUMBER Required
100 -- p_set_number IN NUMBER Required
101 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
102 -- OUT:
103 --
104 -- Version : Current version 1.0
105 --
106 -- End of Comments
107 --
108 --------------------------------------------------------------------------------
109 PROCEDURE merge_claims (
110 req_id NUMBER,
111 set_num NUMBER,
112 process_mode VARCHAR2
113 );
114
115
116 --------------------------------------------------------------------------------
117 -- *******************************************************
118 -- Start of Comments
119 -- *******************************************************
120 -- API Name: merge_claims_history
121 -- Purpose : Merges duplicate customer accounts in
122 -- ozf_claims_history_all table.
123 -- Type : Private
124 -- Pre-Req : None.
125 -- Parameters:
126 -- IN
127 -- p_request_id IN NUMBER Required
128 -- p_set_number IN NUMBER Required
129 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
130 -- OUT:
131 --
132 -- Version : Current version 1.0
133 --
134 -- End of Comments
135 --
136 --------------------------------------------------------------------------------
137 PROCEDURE merge_claims_history (
138 req_id NUMBER,
139 set_num NUMBER,
140 process_mode VARCHAR2
141 );
142
143
144 --------------------------------------------------------------------------------
145 -- *******************************************************
146 -- Start of Comments
147 -- *******************************************************
148 -- API Name: merge_code_conversions
149 -- Purpose : Merges duplicate customer accounts in
150 -- ozf_code_conversions_all table.
151 -- Type : Private
152 -- Pre-Req : None.
153 -- Parameters:
154 -- IN
155 -- p_request_id IN NUMBER Required
156 -- p_set_number IN NUMBER Required
157 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
158 -- OUT:
159 --
160 -- Version : Current version 1.0
161 --
162 -- End of Comments
163 --
164 --------------------------------------------------------------------------------
165 PROCEDURE merge_code_conversions (
166 req_id NUMBER,
167 set_num NUMBER,
168 process_mode VARCHAR2
169 );
170
171
172 --------------------------------------------------------------------------------
173 -- *******************************************************
174 -- Start of Comments
175 -- *******************************************************
176 -- API Name: merge_cust_daily_facts
177 -- Purpose : Merges duplicate customer accounts in
178 -- ozf_cust_daily_facts table.
179 -- Type : Private
180 -- Pre-Req : None.
181 -- Parameters:
182 -- IN
183 -- p_request_id IN NUMBER Required
184 -- p_set_number IN NUMBER Required
185 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
186 -- OUT:
187 --
188 -- Version : Current version 1.0
189 --
190 -- End of Comments
191 --
192 --------------------------------------------------------------------------------
193 PROCEDURE merge_cust_daily_facts (
194 req_id NUMBER,
195 set_num NUMBER,
196 process_mode VARCHAR2
197 );
198
199
200 --------------------------------------------------------------------------------
201 -- *******************************************************
202 -- Start of Comments
203 -- *******************************************************
204 -- API Name: merge_fund_utilization
205 -- Purpose : Merges duplicate customer accounts in
206 -- ozf_funds_utilized_all_b table.
207 -- Type : Private
208 -- Pre-Req : None.
209 -- Parameters:
210 -- IN
211 -- p_request_id IN NUMBER Required
212 -- p_set_number IN NUMBER Required
213 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
214 -- OUT:
215 --
216 -- Version : Current version 1.0
217 --
218 -- End of Comments
219 --
220 --------------------------------------------------------------------------------
221 PROCEDURE merge_fund_utilization (
222 req_id NUMBER,
223 set_num NUMBER,
224 process_mode VARCHAR2
225 );
226
227
228 --------------------------------------------------------------------------------
229 -- *******************************************************
230 -- Start of Comments
231 -- *******************************************************
232 -- API Name: merge_offer_denorm
233 -- Purpose : Merges duplicate customer accounts in
234 -- ozf_activity_customers table.
235 -- Type : Private
236 -- Pre-Req : None.
237 -- Parameters:
238 -- IN
239 -- p_request_id IN NUMBER Required
240 -- p_set_number IN NUMBER Required
241 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
242 -- OUT:
243 --
244 -- Version : Current version 1.0
245 --
246 -- End of Comments
247 --
248 --------------------------------------------------------------------------------
249 PROCEDURE merge_offer_denorm (
250 req_id NUMBER,
251 set_num NUMBER,
252 process_mode VARCHAR2
253 );
254
255
256 --------------------------------------------------------------------------------
257 -- *******************************************************
258 -- Start of Comments
259 -- *******************************************************
260 -- API Name: merge_offer_header
261 -- Purpose : Merges duplicate customer accounts in
262 -- ozf_offers table.
263 -- Type : Private
264 -- Pre-Req : None.
265 -- Parameters:
266 -- IN
267 -- p_request_id IN NUMBER Required
268 -- p_set_number IN NUMBER Required
269 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
270 -- OUT:
271 --
272 -- Version : Current version 1.0
273 --
274 -- End of Comments
275 --
276 --------------------------------------------------------------------------------
277 PROCEDURE merge_offer_header (
278 req_id NUMBER,
279 set_num NUMBER,
280 process_mode VARCHAR2
281 );
282
283
284 --------------------------------------------------------------------------------
285 -- *******************************************************
286 -- Start of Comments
287 -- *******************************************************
288 -- API Name: merge_request_header
289 -- Purpose : Merges duplicate customer accounts in
290 -- ozf_request_headers_all_b table.
291 -- Type : Private
292 -- Pre-Req : None.
293 -- Parameters:
294 -- IN
295 -- p_request_id IN NUMBER Required
296 -- p_set_number IN NUMBER Required
297 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
298 -- OUT:
299 --
300 -- Version : Current version 1.0
301 --
302 -- End of Comments
303 --
304 --------------------------------------------------------------------------------
305 PROCEDURE merge_request_header (
309 );
306 req_id NUMBER,
307 set_num NUMBER,
308 process_mode VARCHAR2
310
311
312 --------------------------------------------------------------------------------
313 -- *******************************************************
314 -- Start of Comments
315 -- *******************************************************
316 -- API Name: merge_retail_price_points
317 -- Purpose : Merges duplicate customer accounts in
318 -- ozf_retail_price_points table.
319 -- Type : Private
320 -- Pre-Req : None.
321 -- Parameters:
322 -- IN
323 -- p_request_id IN NUMBER Required
324 -- p_set_number IN NUMBER Required
325 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
326 -- OUT:
327 --
328 -- Version : Current version 1.0
329 --
330 -- End of Comments
331 --
332 --------------------------------------------------------------------------------
333 PROCEDURE merge_retail_price_points (
334 req_id NUMBER,
335 set_num NUMBER,
336 process_mode VARCHAR2
337 );
338
339
340 --------------------------------------------------------------------------------
341 -- *******************************************************
342 -- Start of Comments
343 -- *******************************************************
344 -- API Name: merge_trade_profiles
345 -- Purpose : Merges duplicate customer accounts in
346 -- ozf_cust_trd_prfls_all table.
347 -- Type : Private
348 -- Pre-Req : None.
349 -- Parameters:
350 -- IN
351 -- p_request_id IN NUMBER Required
352 -- p_set_number IN NUMBER Required
353 -- p_process_mode IN VARCHAR2 Optional Default = 'LOCK'
354 -- OUT:
355 --
356 -- Version : Current version 1.0
357 --
358 -- End of Comments
359 --
360 --------------------------------------------------------------------------------
361 PROCEDURE merge_trade_profiles (
362 req_id NUMBER,
363 set_num NUMBER,
364 process_mode VARCHAR2
365 );
366
367
368 END OZF_ACCOUNT_MERGE_PKG;