1 PACKAGE HZ_DQM_DUP_ID_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARHDUPIS.pls 120.8 2005/06/16 21:11:37 jhuang noship $ */
3
4 /*=======================================================================+
5 | Copyright (c) 1999 Oracle Corporation Redwood Shores, California, USA|
6 | All rights reserved. |
7 +=======================================================================+
8 | NAME
9 | HZ_DQM_DUP_ID_PKG
10 |
11 | DESCRIPTION
12 | VJN created code, for dup identification, using B-tree indices
13 | for all the three flows:
14 | 1. Existing System Duplicate Identification
15 | 2. Interface vs TCA Duplicate Identification
16 | 3. Interface Duplicate Identification
17 | PUBLIC PROCEDURES
18 |
19 | HISTORY
20 | 13-MAY-2003 : VJN Created
21 |
22 *=======================================================================*/
23
24 TYPE EntityCur IS REF CURSOR;
25 TYPE NumberList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
26 TYPE CharList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
27
28 -- this needs to be revisited to make sure, value is populated from a profile
29 l_like_comparison_min_length number := 3;
30
31 ---------------------------------
32 -- TCA DUPLICATE IDENTIFICATION
33 ---------------------------------
34 -- will be called by find_dup_parties_worker ( which is one of the n concurrent workers
35 -- spawned off by find_dup_parties), as part of system duplicate identification
36 PROCEDURE tca_dup_id_worker(
37 p_dup_batch_id IN NUMBER,
38 p_match_rule_id IN NUMBER,
39 p_worker_number IN NUMBER,
40 p_number_of_workers IN NUMBER,
41 p_subset_sql IN VARCHAR2
42 );
43
44 -- will be called when all the tca dup id workers are done
45 PROCEDURE tca_sanitize_report(
46 p_dup_batch_id IN NUMBER,
47 p_match_rule_id IN NUMBER,
48 p_subset_sql IN VARCHAR2,
49 p_within_subset IN VARCHAR2
50 );
51
52 PROCEDURE update_hz_dup_results (
53 p_cur IN EntityCur );
54
55 --------------------------------------------
56 -- INTERFACE vs TCA DUPLICATE IDENTIFICATION
57 --------------------------------------------
58
59 PROCEDURE interface_tca_dup_id(
60 p_batch_id IN number,
61 p_match_rule_id IN number,
62 p_from_osr IN VARCHAR2,
63 p_to_osr IN VARCHAR2,
64 p_batch_mode_flag IN VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70 PROCEDURE interface_tca_sanitize_report(
71 p_batch_id IN NUMBER,
72 p_match_rule_id IN NUMBER,
73 p_request_id IN NUMBER,
74 x_dup_batch_id OUT NOCOPY NUMBER,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2
78 );
79
80 PROCEDURE update_hz_imp_dup_parties (
81 p_batch_id IN number,
82 p_cur IN EntityCur );
83
84 PROCEDURE update_party_dqm_action_flag (
85 p_batch_id IN number,
86 p_cur IN EntityCur );
87
88 PROCEDURE update_detail_dqm_action_flag (
89 p_entity IN VARCHAR2,
90 p_batch_id IN number,
91 p_cur IN EntityCur );
92
93 --------------------------------------------
94 -- INTERFACE DUPLICATE IDENTIFICATION
95 --------------------------------------------
96
97 PROCEDURE interface_dup_id_worker(
98 p_batch_id IN number,
99 p_match_rule_id IN number,
100 p_from_osr IN VARCHAR2,
101 p_to_osr IN VARCHAR2,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2
105 );
106
107 PROCEDURE interface_sanitize_report(
108 p_batch_id IN NUMBER,
109 p_match_rule_id IN NUMBER,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115 PROCEDURE update_hz_int_dup_results (
116 p_batch_id IN number,
117 p_cur IN EntityCur );
118
119
120 --------------------------------------------
121 -- THIS WILL BE USED FOR ALL FLOWS
122 --------------------------------------------
123
124 PROCEDURE compile_match_rule (
125 p_match_rule_id IN NUMBER,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2
129 );
130
131 PROCEDURE final_process_int_tca_dup_id(p_batch_id IN number);
132 END ; -- HZ_DQM_DUP_ID_PKG
133