1 PACKAGE HZ_MATCH_RULE_37 AUTHID CURRENT_USER AS
2 PROCEDURE map_party_rec (
3 p_search_ctx IN BOOLEAN,
4 p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5 x_entered_max_score OUT NUMBER,
6 x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
7 );
8 PROCEDURE map_party_site_rec (
9 p_search_ctx IN BOOLEAN,
10 p_search_list IN HZ_PARTY_SEARCH.party_site_list,
11 x_entered_max_score OUT NUMBER,
12 x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
13 );
14 PROCEDURE map_contact_rec (
15 p_search_ctx IN BOOLEAN,
16 p_search_list IN HZ_PARTY_SEARCH.contact_list,
17 x_entered_max_score OUT NUMBER,
18 x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
19 );
20 PROCEDURE map_contact_point_rec (
21 p_search_ctx IN BOOLEAN,
22 p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
23 x_entered_max_score OUT NUMBER,
24 x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
25 );
26 PROCEDURE get_party_rec (
27 p_party_id IN NUMBER,
28 x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
29 );
30 PROCEDURE get_party_site_rec (
31 p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
32 x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
33 );
34 PROCEDURE get_contact_rec (
35 p_contact_ids IN HZ_PARTY_SEARCH.IDList,
36 x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
37 );
38 PROCEDURE get_contact_point_rec (
39 p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
40 x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
41 );
42 FUNCTION check_prim_cond(
43 p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
44 p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
45 p_contact_list IN HZ_PARTY_SEARCH.contact_list,
46 p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
47 RETURN BOOLEAN;
48 PROCEDURE check_party_site_cond(
49 p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
50 p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
51 x_secondary OUT BOOLEAN,
52 x_primary OUT BOOLEAN
53 );
54 PROCEDURE check_contact_cond(
55 p_contact_list IN HZ_PARTY_SEARCH.contact_list,
56 p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
57 x_secondary OUT BOOLEAN,
58 x_primary OUT BOOLEAN
59 );
60 PROCEDURE check_contact_point_cond(
61 p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
62 x_secondary OUT BOOLEAN,
63 x_primary OUT BOOLEAN
64 );
65 PROCEDURE find_parties (
66 p_rule_id IN NUMBER,
67 p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
68 p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
69 p_contact_list IN HZ_PARTY_SEARCH.contact_list,
70 p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
71 p_restrict_sql IN VARCHAR2,
72 p_match_type IN VARCHAR2,
73 p_search_merged IN VARCHAR2,
74 p_dup_party_id IN NUMBER,
75 p_dup_set_id IN NUMBER,
76 p_dup_batch_id IN NUMBER,
77 p_ins_details IN VARCHAR2,
78 x_search_ctx_id OUT NUMBER,
79 x_num_matches OUT NUMBER
80 );
81 PROCEDURE find_persons (
82 p_rule_id IN NUMBER,
83 p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
84 p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
85 p_contact_list IN HZ_PARTY_SEARCH.contact_list,
86 p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
87 p_restrict_sql IN VARCHAR2,
88 p_match_type IN VARCHAR2,
89 p_search_merged IN VARCHAR2,
90 p_ins_details IN VARCHAR2,
91 x_search_ctx_id OUT NUMBER,
92 x_num_matches OUT NUMBER
93 );
94 PROCEDURE find_party_details (
95 p_rule_id IN NUMBER,
96 p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
97 p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
98 p_contact_list IN HZ_PARTY_SEARCH.contact_list,
99 p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
100 p_restrict_sql IN VARCHAR2,
101 p_match_type IN VARCHAR2,
102 p_search_merged IN VARCHAR2,
103 x_search_ctx_id OUT NUMBER,
104 x_num_matches OUT NUMBER
105 );
106 PROCEDURE find_duplicate_party_sites(
107 p_rule_id IN NUMBER,
108 p_party_site_id IN NUMBER,
109 p_party_id IN NUMBER,
110 p_restrict_sql IN VARCHAR2,
111 p_match_type IN VARCHAR2,
112 x_search_ctx_id OUT NUMBER,
113 x_num_matches OUT NUMBER
114 );
115 PROCEDURE find_duplicate_contacts(
116 p_rule_id IN NUMBER,
117 p_org_contact_id IN NUMBER,
118 p_party_id IN NUMBER,
119 p_restrict_sql IN VARCHAR2,
120 p_match_type IN VARCHAR2,
121 x_search_ctx_id OUT NUMBER,
122 x_num_matches OUT NUMBER
123 );
124 PROCEDURE find_duplicate_contact_points(
125 p_rule_id IN NUMBER,
126 p_contact_point_id IN NUMBER,
127 p_party_id IN NUMBER,
128 p_restrict_sql IN VARCHAR2,
129 p_match_type IN VARCHAR2,
130 x_search_ctx_id OUT NUMBER,
131 x_num_matches OUT NUMBER
132 );
133 PROCEDURE find_duplicate_parties (
134 p_rule_id IN NUMBER,
135 p_party_id IN NUMBER,
136 p_restrict_sql IN VARCHAR2,
137 p_match_type IN VARCHAR2,
138 p_dup_batch_id IN NUMBER,
139 p_search_merged IN VARCHAR2,
140 x_dup_set_id OUT NUMBER,
141 x_search_ctx_id OUT NUMBER,
142 x_num_matches OUT NUMBER
143 );
144 PROCEDURE get_matching_party_sites (
145 p_rule_id IN NUMBER,
146 p_party_id IN NUMBER,
147 p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
148 p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
149 p_restrict_sql IN VARCHAR2,
150 p_match_type IN VARCHAR2,
151 p_dup_party_site_id IN NUMBER,
152 x_search_ctx_id OUT NUMBER,
153 x_num_matches OUT NUMBER
154 );
155 PROCEDURE get_matching_contacts (
156 p_rule_id IN NUMBER,
157 p_party_id IN NUMBER,
158 p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
159 p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
160 p_restrict_sql IN VARCHAR2,
161 p_match_type IN VARCHAR2,
162 p_dup_contact_id IN NUMBER,
163 x_search_ctx_id OUT NUMBER,
164 x_num_matches OUT NUMBER
165 );
166
167 PROCEDURE get_matching_contact_points (
168 p_rule_id IN NUMBER,
169 p_party_id IN NUMBER,
170 p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
171 p_restrict_sql IN VARCHAR2,
172 p_match_type IN VARCHAR2,
173 p_dup_contact_point_id IN NUMBER,
174 x_search_ctx_id OUT NUMBER,
175 x_num_matches OUT NUMBER
176 );
177 PROCEDURE get_score_details (
178 p_rule_id IN NUMBER,
179 p_party_id IN NUMBER,
180 p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
181 p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
182 p_contact_list IN HZ_PARTY_SEARCH.contact_list,
183 p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
184 x_search_ctx_id IN OUT NUMBER
185 );
186 PROCEDURE find_parties_dynamic (
187 p_rule_id IN NUMBER,
188 p_attrib_id1 IN NUMBER,
189 p_attrib_id2 IN NUMBER,
190 p_attrib_id3 IN NUMBER,
191 p_attrib_id4 IN NUMBER,
192 p_attrib_id5 IN NUMBER,
193 p_attrib_id6 IN NUMBER,
194 p_attrib_id7 IN NUMBER,
195 p_attrib_id8 IN NUMBER,
196 p_attrib_id9 IN NUMBER,
197 p_attrib_id10 IN NUMBER,
198 p_attrib_id11 IN NUMBER,
199 p_attrib_id12 IN NUMBER,
200 p_attrib_id13 IN NUMBER,
201 p_attrib_id14 IN NUMBER,
202 p_attrib_id15 IN NUMBER,
203 p_attrib_id16 IN NUMBER,
204 p_attrib_id17 IN NUMBER,
205 p_attrib_id18 IN NUMBER,
206 p_attrib_id19 IN NUMBER,
207 p_attrib_id20 IN NUMBER,
208 p_attrib_val1 IN VARCHAR2,
209 p_attrib_val2 IN VARCHAR2,
210 p_attrib_val3 IN VARCHAR2,
211 p_attrib_val4 IN VARCHAR2,
212 p_attrib_val5 IN VARCHAR2,
213 p_attrib_val6 IN VARCHAR2,
214 p_attrib_val7 IN VARCHAR2,
215 p_attrib_val8 IN VARCHAR2,
216 p_attrib_val9 IN VARCHAR2,
217 p_attrib_val10 IN VARCHAR2,
218 p_attrib_val11 IN VARCHAR2,
219 p_attrib_val12 IN VARCHAR2,
220 p_attrib_val13 IN VARCHAR2,
221 p_attrib_val14 IN VARCHAR2,
222 p_attrib_val15 IN VARCHAR2,
223 p_attrib_val16 IN VARCHAR2,
224 p_attrib_val17 IN VARCHAR2,
225 p_attrib_val18 IN VARCHAR2,
226 p_attrib_val19 IN VARCHAR2,
227 p_attrib_val20 IN VARCHAR2,
228 p_restrict_sql IN VARCHAR2,
229 p_match_type IN VARCHAR2,
230 p_search_merged IN VARCHAR2,
231 x_search_ctx_id OUT NUMBER,
232 x_num_matches OUT NUMBER
233 );
234 PROCEDURE call_api_dynamic (
235 p_rule_id IN NUMBER,
236 p_attrib_id1 IN NUMBER,
237 p_attrib_id2 IN NUMBER,
238 p_attrib_id3 IN NUMBER,
239 p_attrib_id4 IN NUMBER,
240 p_attrib_id5 IN NUMBER,
241 p_attrib_id6 IN NUMBER,
242 p_attrib_id7 IN NUMBER,
243 p_attrib_id8 IN NUMBER,
244 p_attrib_id9 IN NUMBER,
245 p_attrib_id10 IN NUMBER,
246 p_attrib_id11 IN NUMBER,
247 p_attrib_id12 IN NUMBER,
248 p_attrib_id13 IN NUMBER,
249 p_attrib_id14 IN NUMBER,
250 p_attrib_id15 IN NUMBER,
251 p_attrib_id16 IN NUMBER,
252 p_attrib_id17 IN NUMBER,
253 p_attrib_id18 IN NUMBER,
254 p_attrib_id19 IN NUMBER,
255 p_attrib_id20 IN NUMBER,
256 p_attrib_val1 IN VARCHAR2,
257 p_attrib_val2 IN VARCHAR2,
258 p_attrib_val3 IN VARCHAR2,
259 p_attrib_val4 IN VARCHAR2,
260 p_attrib_val5 IN VARCHAR2,
261 p_attrib_val6 IN VARCHAR2,
262 p_attrib_val7 IN VARCHAR2,
263 p_attrib_val8 IN VARCHAR2,
264 p_attrib_val9 IN VARCHAR2,
265 p_attrib_val10 IN VARCHAR2,
266 p_attrib_val11 IN VARCHAR2,
267 p_attrib_val12 IN VARCHAR2,
268 p_attrib_val13 IN VARCHAR2,
269 p_attrib_val14 IN VARCHAR2,
270 p_attrib_val15 IN VARCHAR2,
271 p_attrib_val16 IN VARCHAR2,
272 p_attrib_val17 IN VARCHAR2,
273 p_attrib_val18 IN VARCHAR2,
274 p_attrib_val19 IN VARCHAR2,
275 p_attrib_val20 IN VARCHAR2,
276 p_restrict_sql IN VARCHAR2,
277 p_api_name IN VARCHAR2,
278 p_match_type IN VARCHAR2,
279 p_party_id IN NUMBER,
280 p_search_merged IN VARCHAR2,
281 x_search_ctx_id OUT NUMBER,
282 x_num_matches OUT NUMBER
283 );
284 PROCEDURE get_party_for_search (
285 p_party_id IN NUMBER,
286 x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
287 x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
288 x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
289 x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
290 );
291 PROCEDURE get_search_criteria (
292 p_party_id IN NUMBER,
293 p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
294 p_contact_ids IN HZ_PARTY_SEARCH.IDList,
295 p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
296 x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
297 x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
298 x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
299 x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
300 );
301 FUNCTION check_staged RETURN BOOLEAN;
302
303 -- Fix for Bug 4736139
304 FUNCTION check_staged_var RETURN VARCHAR2;
305
306 g_staged NUMBER := -1;
307 END HZ_MATCH_RULE_37;