[Home] [Help]
PACKAGE: APPS.HZ_PARTY_SEARCH
Source
1 package HZ_PARTY_SEARCH AUTHID CURRENT_USER AS
2 /*$Header: ARHDQPSS.pls 120.12 2006/10/05 18:58:50 nsinghai noship $ */
3 /*#
4 * Contains the Data Quality Management search and duplicate identification APIs.
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:displayname DQM Search and Duplicate Identification
8 * @rep:category BUSINESS_ENTITY HZ_PARTY
9 * @rep:category BUSINESS_ENTITY HZ_PERSON
10 * @rep:category BUSINESS_ENTITY HZ_ORGANIZATION
11 * @rep:category BUSINESS_ENTITY HZ_ADDRESS
12 * @rep:category BUSINESS_ENTITY HZ_CONTACT
13 * @rep:category BUSINESS_ENTITY HZ_CONTACT_POINT
14 * @rep:lifecycle active
15 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
16 * Oracle Trading Community Architecture Technical Implementation Guide
17 */
18
19 TYPE party_search_rec_type IS RECORD (
20 ALL_ACCOUNT_NAMES VARCHAR2(4000) -- CUSTOM
21 ,ALL_ACCOUNT_NUMBERS VARCHAR2(4000) -- CUSTOM
22 ,DOMAIN_NAME VARCHAR2(4000) -- CUSTOM
23 ,PARTY_SOURCE_SYSTEM_REF VARCHAR2(4000) -- CUSTOM
24 ,CUSTOM_ATTRIBUTE1 VARCHAR2(4000) -- CUSTOM
25 ,CUSTOM_ATTRIBUTE10 VARCHAR2(4000) -- CUSTOM
26 ,CUSTOM_ATTRIBUTE11 VARCHAR2(4000) -- CUSTOM
27 ,CUSTOM_ATTRIBUTE12 VARCHAR2(4000) -- CUSTOM
28 ,CUSTOM_ATTRIBUTE13 VARCHAR2(4000) -- CUSTOM
29 ,CUSTOM_ATTRIBUTE14 VARCHAR2(4000) -- CUSTOM
30 ,CUSTOM_ATTRIBUTE15 VARCHAR2(4000) -- CUSTOM
31 ,CUSTOM_ATTRIBUTE16 VARCHAR2(4000) -- CUSTOM
32 ,CUSTOM_ATTRIBUTE17 VARCHAR2(4000) -- CUSTOM
33 ,CUSTOM_ATTRIBUTE18 VARCHAR2(4000) -- CUSTOM
34 ,CUSTOM_ATTRIBUTE19 VARCHAR2(4000) -- CUSTOM
35 ,CUSTOM_ATTRIBUTE2 VARCHAR2(4000) -- CUSTOM
36 ,CUSTOM_ATTRIBUTE20 VARCHAR2(4000) -- CUSTOM
37 ,CUSTOM_ATTRIBUTE21 VARCHAR2(4000) -- CUSTOM
38 ,CUSTOM_ATTRIBUTE22 VARCHAR2(4000) -- CUSTOM
39 ,CUSTOM_ATTRIBUTE23 VARCHAR2(4000) -- CUSTOM
40 ,CUSTOM_ATTRIBUTE24 VARCHAR2(4000) -- CUSTOM
41 ,CUSTOM_ATTRIBUTE25 VARCHAR2(4000) -- CUSTOM
42 ,CUSTOM_ATTRIBUTE26 VARCHAR2(4000) -- CUSTOM
43 ,CUSTOM_ATTRIBUTE27 VARCHAR2(4000) -- CUSTOM
44 ,CUSTOM_ATTRIBUTE28 VARCHAR2(4000) -- CUSTOM
45 ,CUSTOM_ATTRIBUTE29 VARCHAR2(4000) -- CUSTOM
46 ,CUSTOM_ATTRIBUTE3 VARCHAR2(4000) -- CUSTOM
47 ,CUSTOM_ATTRIBUTE30 VARCHAR2(4000) -- CUSTOM
48 ,CUSTOM_ATTRIBUTE4 VARCHAR2(4000) -- CUSTOM
49 ,CUSTOM_ATTRIBUTE5 VARCHAR2(4000) -- CUSTOM
50 ,CUSTOM_ATTRIBUTE6 VARCHAR2(4000) -- CUSTOM
51 ,CUSTOM_ATTRIBUTE7 VARCHAR2(4000) -- CUSTOM
52 ,CUSTOM_ATTRIBUTE8 VARCHAR2(4000) -- CUSTOM
53 ,CUSTOM_ATTRIBUTE9 VARCHAR2(4000) -- CUSTOM
54 ,ANALYSIS_FY VARCHAR2(5) -- HZ_ORGANIZATION_PROFILES
55 ,AVG_HIGH_CREDIT NUMBER -- HZ_ORGANIZATION_PROFILES
56 ,BEST_TIME_CONTACT_BEGIN DATE -- HZ_ORGANIZATION_PROFILES
57 ,BEST_TIME_CONTACT_END DATE -- HZ_ORGANIZATION_PROFILES
58 ,BRANCH_FLAG VARCHAR2(1) -- HZ_ORGANIZATION_PROFILES
59 ,BUSINESS_SCOPE VARCHAR2(20) -- HZ_ORGANIZATION_PROFILES
60 ,CEO_NAME VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
61 ,CEO_TITLE VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
62 ,CONG_DIST_CODE VARCHAR2(2) -- HZ_ORGANIZATION_PROFILES
63 ,CONTENT_SOURCE_NUMBER VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
64 ,CONTENT_SOURCE_TYPE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
65 ,CONTROL_YR NUMBER -- HZ_ORGANIZATION_PROFILES
66 ,CORPORATION_CLASS VARCHAR2(60) -- HZ_ORGANIZATION_PROFILES
67 ,CREDIT_SCORE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
68 ,CREDIT_SCORE_AGE NUMBER -- HZ_ORGANIZATION_PROFILES
69 ,CREDIT_SCORE_CLASS NUMBER -- HZ_ORGANIZATION_PROFILES
70 ,CREDIT_SCORE_COMMENTARY VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
71 ,CREDIT_SCORE_COMMENTARY10 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
72 ,CREDIT_SCORE_COMMENTARY2 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
73 ,CREDIT_SCORE_COMMENTARY3 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
74 ,CREDIT_SCORE_COMMENTARY4 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
75 ,CREDIT_SCORE_COMMENTARY5 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
76 ,CREDIT_SCORE_COMMENTARY6 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
77 ,CREDIT_SCORE_COMMENTARY7 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
78 ,CREDIT_SCORE_COMMENTARY8 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
79 ,CREDIT_SCORE_COMMENTARY9 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
80 ,CREDIT_SCORE_DATE DATE -- HZ_ORGANIZATION_PROFILES
81 ,CREDIT_SCORE_INCD_DEFAULT NUMBER -- HZ_ORGANIZATION_PROFILES
82 ,CREDIT_SCORE_NATL_PERCENTILE NUMBER -- HZ_ORGANIZATION_PROFILES
83 ,CURR_FY_POTENTIAL_REVENUE NUMBER -- HZ_ORGANIZATION_PROFILES
84 ,DB_RATING VARCHAR2(5) -- HZ_ORGANIZATION_PROFILES
85 ,DEBARMENTS_COUNT NUMBER -- HZ_ORGANIZATION_PROFILES
86 ,DEBARMENTS_DATE DATE -- HZ_ORGANIZATION_PROFILES
87 ,DEBARMENT_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
88 ,DISADV_8A_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
89 ,DUNS_NUMBER_C VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
90 ,EMPLOYEES_TOTAL NUMBER -- HZ_ORGANIZATION_PROFILES
91 ,EMP_AT_PRIMARY_ADR VARCHAR2(10) -- HZ_ORGANIZATION_PROFILES
92 ,EMP_AT_PRIMARY_ADR_EST_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
93 ,EMP_AT_PRIMARY_ADR_MIN_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
94 ,EMP_AT_PRIMARY_ADR_TEXT VARCHAR2(12) -- HZ_ORGANIZATION_PROFILES
95 ,ENQUIRY_DUNS VARCHAR2(15) -- HZ_ORGANIZATION_PROFILES
96 ,EXPORT_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
97 ,FAILURE_SCORE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
98 ,FAILURE_SCORE_AGE NUMBER -- HZ_ORGANIZATION_PROFILES
99 ,FAILURE_SCORE_CLASS NUMBER -- HZ_ORGANIZATION_PROFILES
100 ,FAILURE_SCORE_COMMENTARY VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
101 ,FAILURE_SCORE_COMMENTARY10 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
102 ,FAILURE_SCORE_COMMENTARY2 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
103 ,FAILURE_SCORE_COMMENTARY3 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
104 ,FAILURE_SCORE_COMMENTARY4 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
105 ,FAILURE_SCORE_COMMENTARY5 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
106 ,FAILURE_SCORE_COMMENTARY6 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
107 ,FAILURE_SCORE_COMMENTARY7 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
108 ,FAILURE_SCORE_COMMENTARY8 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
109 ,FAILURE_SCORE_COMMENTARY9 VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
110 ,FAILURE_SCORE_DATE DATE -- HZ_ORGANIZATION_PROFILES
111 ,FAILURE_SCORE_INCD_DEFAULT NUMBER -- HZ_ORGANIZATION_PROFILES
112 ,FAILURE_SCORE_OVERRIDE_CODE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
113 ,FISCAL_YEAREND_MONTH VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
114 ,GLOBAL_FAILURE_SCORE VARCHAR2(5) -- HZ_ORGANIZATION_PROFILES
115 ,GSA_INDICATOR_FLAG VARCHAR2(1) -- HZ_ORGANIZATION_PROFILES
116 ,HIGH_CREDIT NUMBER -- HZ_ORGANIZATION_PROFILES
117 ,HQ_BRANCH_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
118 ,IMPORT_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
119 ,INCORP_YEAR NUMBER -- HZ_ORGANIZATION_PROFILES
120 ,INTERNAL_FLAG VARCHAR2(1) -- HZ_ORGANIZATION_PROFILES
121 ,JGZZ_FISCAL_CODE VARCHAR2(20) -- HZ_ORGANIZATION_PROFILES
122 ,PARTY_ALL_NAMES VARCHAR2(2000) -- HZ_ORGANIZATION_PROFILES
123 ,KNOWN_AS VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
124 ,KNOWN_AS2 VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
125 ,KNOWN_AS3 VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
126 ,KNOWN_AS4 VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
127 ,KNOWN_AS5 VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
128 ,LABOR_SURPLUS_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
129 ,LEGAL_STATUS VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
130 ,LINE_OF_BUSINESS VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
131 ,LOCAL_ACTIVITY_CODE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
132 ,LOCAL_ACTIVITY_CODE_TYPE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
133 ,LOCAL_BUS_IDENTIFIER VARCHAR2(60) -- HZ_ORGANIZATION_PROFILES
134 ,LOCAL_BUS_IDEN_TYPE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
135 ,MAXIMUM_CREDIT_CURRENCY_CODE VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
136 ,MAXIMUM_CREDIT_RECOMMENDATION NUMBER -- HZ_ORGANIZATION_PROFILES
137 ,MINORITY_OWNED_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
138 ,MINORITY_OWNED_TYPE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
139 ,NEXT_FY_POTENTIAL_REVENUE NUMBER -- HZ_ORGANIZATION_PROFILES
140 ,OOB_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
141 ,ORGANIZATION_NAME VARCHAR2(360) -- HZ_ORGANIZATION_PROFILES
142 ,ORGANIZATION_NAME_PHONETIC VARCHAR2(320) -- HZ_ORGANIZATION_PROFILES
143 ,ORGANIZATION_TYPE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
144 ,PARENT_SUB_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
145 ,PAYDEX_NORM VARCHAR2(3) -- HZ_ORGANIZATION_PROFILES
146 ,PAYDEX_SCORE VARCHAR2(3) -- HZ_ORGANIZATION_PROFILES
147 ,PAYDEX_THREE_MONTHS_AGO VARCHAR2(3) -- HZ_ORGANIZATION_PROFILES
148 ,PREF_FUNCTIONAL_CURRENCY VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
149 ,PRINCIPAL_NAME VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
150 ,PRINCIPAL_TITLE VARCHAR2(240) -- HZ_ORGANIZATION_PROFILES
151 ,PUBLIC_PRIVATE_OWNERSHIP_FLAG VARCHAR2(1) -- HZ_ORGANIZATION_PROFILES
152 ,REGISTRATION_TYPE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
153 ,RENT_OWN_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
154 ,SIC_CODE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
155 ,SIC_CODE_TYPE VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
156 ,SMALL_BUS_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
157 ,TAX_NAME VARCHAR2(60) -- HZ_ORGANIZATION_PROFILES
158 ,TAX_REFERENCE VARCHAR2(50) -- HZ_ORGANIZATION_PROFILES
159 ,TOTAL_EMPLOYEES_TEXT VARCHAR2(60) -- HZ_ORGANIZATION_PROFILES
160 ,TOTAL_EMP_EST_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
161 ,TOTAL_EMP_MIN_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
162 ,TOTAL_EMPLOYEES_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
163 ,TOTAL_PAYMENTS NUMBER -- HZ_ORGANIZATION_PROFILES
164 ,WOMAN_OWNED_IND VARCHAR2(30) -- HZ_ORGANIZATION_PROFILES
165 ,YEAR_ESTABLISHED NUMBER -- HZ_ORGANIZATION_PROFILES
166 ,CATEGORY_CODE VARCHAR2(30) -- HZ_PARTIES
167 ,COMPETITOR_FLAG VARCHAR2(1) -- HZ_PARTIES
168 ,DO_NOT_MAIL_FLAG VARCHAR2(1) -- HZ_PARTIES
169 ,GROUP_TYPE VARCHAR2(30) -- HZ_PARTIES
170 ,LANGUAGE_NAME VARCHAR2(4) -- HZ_PARTIES
171 ,PARTY_NAME VARCHAR2(360) -- HZ_PARTIES
172 ,PARTY_NUMBER VARCHAR2(30) -- HZ_PARTIES
173 ,PARTY_TYPE VARCHAR2(30) -- HZ_PARTIES
174 ,REFERENCE_USE_FLAG VARCHAR2(1) -- HZ_PARTIES
175 ,SALUTATION VARCHAR2(60) -- HZ_PARTIES
176 ,STATUS VARCHAR2(1) -- HZ_PARTIES
177 ,THIRD_PARTY_FLAG VARCHAR2(1) -- HZ_PARTIES
178 ,VALIDATED_FLAG VARCHAR2(1) -- HZ_PARTIES
179 ,DATE_OF_BIRTH DATE -- HZ_PERSON_PROFILES
180 ,DATE_OF_DEATH DATE -- HZ_PERSON_PROFILES
181 ,EFFECTIVE_START_DATE DATE -- HZ_PERSON_PROFILES
182 ,EFFECTIVE_END_DATE DATE -- HZ_PERSON_PROFILES
183 ,DECLARED_ETHNICITY VARCHAR2(60) -- HZ_PERSON_PROFILES
184 ,GENDER VARCHAR2(30) -- HZ_PERSON_PROFILES
185 ,HEAD_OF_HOUSEHOLD_FLAG VARCHAR2(1) -- HZ_PERSON_PROFILES
186 ,HOUSEHOLD_INCOME NUMBER -- HZ_PERSON_PROFILES
187 ,HOUSEHOLD_SIZE NUMBER -- HZ_PERSON_PROFILES
188 ,LAST_KNOWN_GPS VARCHAR2(60) -- HZ_PERSON_PROFILES
189 ,MARITAL_STATUS VARCHAR2(30) -- HZ_PERSON_PROFILES
190 ,MARITAL_STATUS_EFFECTIVE_DATE DATE -- HZ_PERSON_PROFILES
191 ,MIDDLE_NAME_PHONETIC VARCHAR2(60) -- HZ_PERSON_PROFILES
192 ,PERSONAL_INCOME NUMBER -- HZ_PERSON_PROFILES
193 ,PERSON_ACADEMIC_TITLE VARCHAR2(30) -- HZ_PERSON_PROFILES
194 ,PERSON_FIRST_NAME VARCHAR2(150) -- HZ_PERSON_PROFILES
195 ,PERSON_FIRST_NAME_PHONETIC VARCHAR2(60) -- HZ_PERSON_PROFILES
196 ,PERSON_IDENTIFIER VARCHAR2(60) -- HZ_PERSON_PROFILES
197 ,PERSON_IDEN_TYPE VARCHAR2(30) -- HZ_PERSON_PROFILES
198 ,PERSON_INITIALS VARCHAR2(6) -- HZ_PERSON_PROFILES
199 ,PERSON_LAST_NAME VARCHAR2(150) -- HZ_PERSON_PROFILES
200 ,PERSON_LAST_NAME_PHONETIC VARCHAR2(60) -- HZ_PERSON_PROFILES
201 ,PERSON_MIDDLE_NAME VARCHAR2(60) -- HZ_PERSON_PROFILES
202 ,PERSON_NAME VARCHAR2(450) -- HZ_PERSON_PROFILES
203 ,PERSON_NAME_PHONETIC VARCHAR2(320) -- HZ_PERSON_PROFILES
204 ,PERSON_NAME_SUFFIX VARCHAR2(30) -- HZ_PERSON_PROFILES
205 ,PERSON_PREVIOUS_LAST_NAME VARCHAR2(150) -- HZ_PERSON_PROFILES
206 ,PERSON_PRE_NAME_ADJUNCT VARCHAR2(30) -- HZ_PERSON_PROFILES
207 ,PERSON_TITLE VARCHAR2(60) -- HZ_PERSON_PROFILES
208 ,PLACE_OF_BIRTH VARCHAR2(60) -- HZ_PERSON_PROFILES
209 );
210
211
212 TYPE party_site_search_rec_type IS RECORD (
213 ADDRESS VARCHAR2(4000) -- CUSTOM
214 ,ADDR_SOURCE_SYSTEM_REF VARCHAR2(4000) -- CUSTOM
215 ,CUSTOM_ATTRIBUTE1 VARCHAR2(4000) -- CUSTOM
216 ,CUSTOM_ATTRIBUTE10 VARCHAR2(4000) -- CUSTOM
217 ,CUSTOM_ATTRIBUTE11 VARCHAR2(4000) -- CUSTOM
218 ,CUSTOM_ATTRIBUTE12 VARCHAR2(4000) -- CUSTOM
219 ,CUSTOM_ATTRIBUTE13 VARCHAR2(4000) -- CUSTOM
220 ,CUSTOM_ATTRIBUTE14 VARCHAR2(4000) -- CUSTOM
221 ,CUSTOM_ATTRIBUTE15 VARCHAR2(4000) -- CUSTOM
222 ,CUSTOM_ATTRIBUTE16 VARCHAR2(4000) -- CUSTOM
223 ,CUSTOM_ATTRIBUTE17 VARCHAR2(4000) -- CUSTOM
224 ,CUSTOM_ATTRIBUTE18 VARCHAR2(4000) -- CUSTOM
225 ,CUSTOM_ATTRIBUTE19 VARCHAR2(4000) -- CUSTOM
226 ,CUSTOM_ATTRIBUTE2 VARCHAR2(4000) -- CUSTOM
227 ,CUSTOM_ATTRIBUTE20 VARCHAR2(4000) -- CUSTOM
228 ,CUSTOM_ATTRIBUTE21 VARCHAR2(4000) -- CUSTOM
229 ,CUSTOM_ATTRIBUTE22 VARCHAR2(4000) -- CUSTOM
230 ,CUSTOM_ATTRIBUTE23 VARCHAR2(4000) -- CUSTOM
231 ,CUSTOM_ATTRIBUTE24 VARCHAR2(4000) -- CUSTOM
232 ,CUSTOM_ATTRIBUTE25 VARCHAR2(4000) -- CUSTOM
233 ,CUSTOM_ATTRIBUTE26 VARCHAR2(4000) -- CUSTOM
234 ,CUSTOM_ATTRIBUTE27 VARCHAR2(4000) -- CUSTOM
235 ,CUSTOM_ATTRIBUTE28 VARCHAR2(4000) -- CUSTOM
236 ,CUSTOM_ATTRIBUTE29 VARCHAR2(4000) -- CUSTOM
237 ,CUSTOM_ATTRIBUTE3 VARCHAR2(4000) -- CUSTOM
238 ,CUSTOM_ATTRIBUTE30 VARCHAR2(4000) -- CUSTOM
239 ,CUSTOM_ATTRIBUTE4 VARCHAR2(4000) -- CUSTOM
240 ,CUSTOM_ATTRIBUTE5 VARCHAR2(4000) -- CUSTOM
241 ,CUSTOM_ATTRIBUTE6 VARCHAR2(4000) -- CUSTOM
242 ,CUSTOM_ATTRIBUTE7 VARCHAR2(4000) -- CUSTOM
243 ,CUSTOM_ATTRIBUTE8 VARCHAR2(4000) -- CUSTOM
244 ,CUSTOM_ATTRIBUTE9 VARCHAR2(4000) -- CUSTOM
245 ,ADDRESS1 VARCHAR2(240) -- HZ_LOCATIONS
246 ,ADDRESS2 VARCHAR2(240) -- HZ_LOCATIONS
247 ,ADDRESS3 VARCHAR2(240) -- HZ_LOCATIONS
248 ,ADDRESS4 VARCHAR2(240) -- HZ_LOCATIONS
249 ,ADDRESS_EFFECTIVE_DATE DATE -- HZ_LOCATIONS
250 ,ADDRESS_EXPIRATION_DATE DATE -- HZ_LOCATIONS
251 ,ADDRESS_LINES_PHONETIC VARCHAR2(560) -- HZ_LOCATIONS
252 ,CITY VARCHAR2(60) -- HZ_LOCATIONS
253 ,CLLI_CODE VARCHAR2(60) -- HZ_LOCATIONS
254 ,CONTENT_SOURCE_TYPE VARCHAR2(30) -- HZ_LOCATIONS
255 ,COUNTRY VARCHAR2(60) -- HZ_LOCATIONS
259 ,LANGUAGE VARCHAR2(4) -- HZ_LOCATIONS
256 ,COUNTY VARCHAR2(60) -- HZ_LOCATIONS
257 ,FLOOR VARCHAR2(50) -- HZ_LOCATIONS
258 ,HOUSE_NUMBER VARCHAR2(50) -- HZ_LOCATIONS
260 ,POSITION VARCHAR2(50) -- HZ_LOCATIONS
261 ,POSTAL_CODE VARCHAR2(60) -- HZ_LOCATIONS
262 ,POSTAL_PLUS4_CODE VARCHAR2(10) -- HZ_LOCATIONS
263 ,PO_BOX_NUMBER VARCHAR2(50) -- HZ_LOCATIONS
264 ,PROVINCE VARCHAR2(60) -- HZ_LOCATIONS
265 ,SALES_TAX_GEOCODE VARCHAR2(30) -- HZ_LOCATIONS
266 ,SALES_TAX_INSIDE_CITY_LIMITS VARCHAR2(30) -- HZ_LOCATIONS
267 ,STATE VARCHAR2(60) -- HZ_LOCATIONS
268 ,STREET VARCHAR2(50) -- HZ_LOCATIONS
269 ,STREET_NUMBER VARCHAR2(50) -- HZ_LOCATIONS
270 ,STREET_SUFFIX VARCHAR2(50) -- HZ_LOCATIONS
271 ,SUITE VARCHAR2(50) -- HZ_LOCATIONS
272 ,TRAILING_DIRECTORY_CODE VARCHAR2(60) -- HZ_LOCATIONS
273 ,VALIDATED_FLAG VARCHAR2(1) -- HZ_LOCATIONS
274 ,IDENTIFYING_ADDRESS_FLAG VARCHAR2(1) -- HZ_PARTY_SITES
275 ,MAILSTOP VARCHAR2(60) -- HZ_PARTY_SITES
276 ,PARTY_SITE_NAME VARCHAR2(240) -- HZ_PARTY_SITES
277 ,PARTY_SITE_NUMBER VARCHAR2(30) -- HZ_PARTY_SITES
278 ,STATUS VARCHAR2(1) -- HZ_PARTY_SITES
279 );
280
281
282 TYPE contact_search_rec_type IS RECORD (
283 CONTACT_SOURCE_SYSTEM_REF VARCHAR2(4000) -- CUSTOM
284 ,CUSTOM_ATTRIBUTE1 VARCHAR2(4000) -- CUSTOM
285 ,CUSTOM_ATTRIBUTE10 VARCHAR2(4000) -- CUSTOM
286 ,CUSTOM_ATTRIBUTE11 VARCHAR2(4000) -- CUSTOM
287 ,CUSTOM_ATTRIBUTE12 VARCHAR2(4000) -- CUSTOM
288 ,CUSTOM_ATTRIBUTE13 VARCHAR2(4000) -- CUSTOM
289 ,CUSTOM_ATTRIBUTE14 VARCHAR2(4000) -- CUSTOM
290 ,CUSTOM_ATTRIBUTE15 VARCHAR2(4000) -- CUSTOM
291 ,CUSTOM_ATTRIBUTE16 VARCHAR2(4000) -- CUSTOM
292 ,CUSTOM_ATTRIBUTE17 VARCHAR2(4000) -- CUSTOM
293 ,CUSTOM_ATTRIBUTE18 VARCHAR2(4000) -- CUSTOM
294 ,CUSTOM_ATTRIBUTE19 VARCHAR2(4000) -- CUSTOM
295 ,CUSTOM_ATTRIBUTE2 VARCHAR2(4000) -- CUSTOM
296 ,CUSTOM_ATTRIBUTE20 VARCHAR2(4000) -- CUSTOM
297 ,CUSTOM_ATTRIBUTE21 VARCHAR2(4000) -- CUSTOM
298 ,CUSTOM_ATTRIBUTE22 VARCHAR2(4000) -- CUSTOM
299 ,CUSTOM_ATTRIBUTE23 VARCHAR2(4000) -- CUSTOM
300 ,CUSTOM_ATTRIBUTE24 VARCHAR2(4000) -- CUSTOM
301 ,CUSTOM_ATTRIBUTE25 VARCHAR2(4000) -- CUSTOM
302 ,CUSTOM_ATTRIBUTE26 VARCHAR2(4000) -- CUSTOM
303 ,CUSTOM_ATTRIBUTE27 VARCHAR2(4000) -- CUSTOM
304 ,CUSTOM_ATTRIBUTE28 VARCHAR2(4000) -- CUSTOM
305 ,CUSTOM_ATTRIBUTE29 VARCHAR2(4000) -- CUSTOM
306 ,CUSTOM_ATTRIBUTE3 VARCHAR2(4000) -- CUSTOM
307 ,CUSTOM_ATTRIBUTE30 VARCHAR2(4000) -- CUSTOM
308 ,CUSTOM_ATTRIBUTE4 VARCHAR2(4000) -- CUSTOM
309 ,CUSTOM_ATTRIBUTE5 VARCHAR2(4000) -- CUSTOM
313 ,CUSTOM_ATTRIBUTE9 VARCHAR2(4000) -- CUSTOM
310 ,CUSTOM_ATTRIBUTE6 VARCHAR2(4000) -- CUSTOM
311 ,CUSTOM_ATTRIBUTE7 VARCHAR2(4000) -- CUSTOM
312 ,CUSTOM_ATTRIBUTE8 VARCHAR2(4000) -- CUSTOM
314 ,CONTACT_NUMBER VARCHAR2(30) -- HZ_ORG_CONTACTS
315 ,CONTACT_NAME VARCHAR2(4000) -- HZ_ORG_CONTACTS
316 ,DECISION_MAKER_FLAG VARCHAR2(1) -- HZ_ORG_CONTACTS
317 ,JOB_TITLE VARCHAR2(100) -- HZ_ORG_CONTACTS
318 ,JOB_TITLE_CODE VARCHAR2(30) -- HZ_ORG_CONTACTS
319 ,MAIL_STOP VARCHAR2(60) -- HZ_ORG_CONTACTS
320 ,NATIVE_LANGUAGE VARCHAR2(30) -- HZ_ORG_CONTACTS
321 ,OTHER_LANGUAGE_1 VARCHAR2(30) -- HZ_ORG_CONTACTS
322 ,OTHER_LANGUAGE_2 VARCHAR2(30) -- HZ_ORG_CONTACTS
323 ,RANK VARCHAR2(30) -- HZ_ORG_CONTACTS
324 ,REFERENCE_USE_FLAG VARCHAR2(1) -- HZ_ORG_CONTACTS
325 ,TITLE VARCHAR2(30) -- HZ_ORG_CONTACTS
326 ,RELATIONSHIP_TYPE VARCHAR2(30) -- HZ_PARTY_RELATIONSHIPS
327 ,BEST_TIME_CONTACT_BEGIN DATE -- HZ_PERSON_PROFILES
328 ,BEST_TIME_CONTACT_END DATE -- HZ_PERSON_PROFILES
329 ,DATE_OF_BIRTH DATE -- HZ_PERSON_PROFILES
330 ,DATE_OF_DEATH DATE -- HZ_PERSON_PROFILES
331 ,JGZZ_FISCAL_CODE VARCHAR2(20) -- HZ_PERSON_PROFILES
332 ,KNOWN_AS VARCHAR2(240) -- HZ_PERSON_PROFILES
333 ,PERSON_ACADEMIC_TITLE VARCHAR2(30) -- HZ_PERSON_PROFILES
334 ,PERSON_FIRST_NAME VARCHAR2(150) -- HZ_PERSON_PROFILES
335 ,PERSON_FIRST_NAME_PHONETIC VARCHAR2(60) -- HZ_PERSON_PROFILES
336 ,PERSON_IDENTIFIER VARCHAR2(60) -- HZ_PERSON_PROFILES
337 ,PERSON_IDEN_TYPE VARCHAR2(30) -- HZ_PERSON_PROFILES
338 ,PERSON_INITIALS VARCHAR2(6) -- HZ_PERSON_PROFILES
339 ,PERSON_LAST_NAME VARCHAR2(150) -- HZ_PERSON_PROFILES
340 ,PERSON_LAST_NAME_PHONETIC VARCHAR2(60) -- HZ_PERSON_PROFILES
341 ,PERSON_MIDDLE_NAME VARCHAR2(60) -- HZ_PERSON_PROFILES
342 ,PERSON_NAME VARCHAR2(450) -- HZ_PERSON_PROFILES
343 ,PERSON_NAME_PHONETIC VARCHAR2(320) -- HZ_PERSON_PROFILES
344 ,PERSON_NAME_SUFFIX VARCHAR2(30) -- HZ_PERSON_PROFILES
345 ,PERSON_PREVIOUS_LAST_NAME VARCHAR2(150) -- HZ_PERSON_PROFILES
346 ,PERSON_TITLE VARCHAR2(60) -- HZ_PERSON_PROFILES
347 ,PLACE_OF_BIRTH VARCHAR2(60) -- HZ_PERSON_PROFILES
348 ,TAX_NAME VARCHAR2(60) -- HZ_PERSON_PROFILES
349 ,TAX_REFERENCE VARCHAR2(60) -- HZ_PERSON_PROFILES
350 ,CONTENT_SOURCE_TYPE VARCHAR2(30) -- HZ_RELATIONSHIPS
351 ,DIRECTIONAL_FLAG VARCHAR2(1) -- HZ_RELATIONSHIPS
352 );
353
354
355 TYPE contact_point_search_rec_type IS RECORD (
356 CONTACT_POINT_TYPE VARCHAR2(30) -- HZ_CONTACT_POINTS
357 ,CPT_SOURCE_SYSTEM_REF VARCHAR2(4000) -- CUSTOM
358 ,CUSTOM_ATTRIBUTE1 VARCHAR2(4000) -- CUSTOM
359 ,CUSTOM_ATTRIBUTE10 VARCHAR2(4000) -- CUSTOM
360 ,CUSTOM_ATTRIBUTE11 VARCHAR2(4000) -- CUSTOM
361 ,CUSTOM_ATTRIBUTE12 VARCHAR2(4000) -- CUSTOM
362 ,CUSTOM_ATTRIBUTE13 VARCHAR2(4000) -- CUSTOM
363 ,CUSTOM_ATTRIBUTE14 VARCHAR2(4000) -- CUSTOM
364 ,CUSTOM_ATTRIBUTE15 VARCHAR2(4000) -- CUSTOM
365 ,CUSTOM_ATTRIBUTE16 VARCHAR2(4000) -- CUSTOM
366 ,CUSTOM_ATTRIBUTE17 VARCHAR2(4000) -- CUSTOM
367 ,CUSTOM_ATTRIBUTE18 VARCHAR2(4000) -- CUSTOM
368 ,CUSTOM_ATTRIBUTE19 VARCHAR2(4000) -- CUSTOM
369 ,CUSTOM_ATTRIBUTE2 VARCHAR2(4000) -- CUSTOM
370 ,CUSTOM_ATTRIBUTE20 VARCHAR2(4000) -- CUSTOM
371 ,CUSTOM_ATTRIBUTE21 VARCHAR2(4000) -- CUSTOM
372 ,CUSTOM_ATTRIBUTE22 VARCHAR2(4000) -- CUSTOM
373 ,CUSTOM_ATTRIBUTE23 VARCHAR2(4000) -- CUSTOM
374 ,CUSTOM_ATTRIBUTE24 VARCHAR2(4000) -- CUSTOM
375 ,CUSTOM_ATTRIBUTE25 VARCHAR2(4000) -- CUSTOM
376 ,CUSTOM_ATTRIBUTE26 VARCHAR2(4000) -- CUSTOM
377 ,CUSTOM_ATTRIBUTE27 VARCHAR2(4000) -- CUSTOM
378 ,CUSTOM_ATTRIBUTE28 VARCHAR2(4000) -- CUSTOM
379 ,CUSTOM_ATTRIBUTE29 VARCHAR2(4000) -- CUSTOM
380 ,CUSTOM_ATTRIBUTE3 VARCHAR2(4000) -- CUSTOM
381 ,CUSTOM_ATTRIBUTE30 VARCHAR2(4000) -- CUSTOM
382 ,CUSTOM_ATTRIBUTE4 VARCHAR2(4000) -- CUSTOM
383 ,CUSTOM_ATTRIBUTE5 VARCHAR2(4000) -- CUSTOM
384 ,CUSTOM_ATTRIBUTE6 VARCHAR2(4000) -- CUSTOM
385 ,CUSTOM_ATTRIBUTE7 VARCHAR2(4000) -- CUSTOM
386 ,CUSTOM_ATTRIBUTE8 VARCHAR2(4000) -- CUSTOM
387 ,CUSTOM_ATTRIBUTE9 VARCHAR2(4000) -- CUSTOM
388 ,CONTENT_SOURCE_TYPE VARCHAR2(30) -- HZ_CONTACT_POINTS
389 ,EDI_ECE_TP_LOCATION_CODE VARCHAR2(40) -- HZ_CONTACT_POINTS
390 ,EDI_ID_NUMBER VARCHAR2(30) -- HZ_CONTACT_POINTS
391 ,EDI_PAYMENT_FORMAT VARCHAR2(30) -- HZ_CONTACT_POINTS
392 ,EDI_PAYMENT_METHOD VARCHAR2(30) -- HZ_CONTACT_POINTS
393 ,EDI_REMITTANCE_INSTRUCTION VARCHAR2(30) -- HZ_CONTACT_POINTS
394 ,EDI_REMITTANCE_METHOD VARCHAR2(30) -- HZ_CONTACT_POINTS
395 ,EDI_TP_HEADER_ID NUMBER -- HZ_CONTACT_POINTS
396 ,EDI_TRANSACTION_HANDLING VARCHAR2(25) -- HZ_CONTACT_POINTS
397 ,EMAIL_ADDRESS VARCHAR2(2000) -- HZ_CONTACT_POINTS
401 ,PHONE_AREA_CODE VARCHAR2(10) -- HZ_CONTACT_POINTS
398 ,EMAIL_FORMAT VARCHAR2(30) -- HZ_CONTACT_POINTS
399 ,FLEX_FORMAT_PHONE_NUMBER VARCHAR2(4000) -- CUSTOM
400 ,LAST_CONTACT_DT_TIME DATE -- HZ_CONTACT_POINTS
402 ,PHONE_CALLING_CALENDAR VARCHAR2(30) -- HZ_CONTACT_POINTS
403 ,PHONE_COUNTRY_CODE VARCHAR2(10) -- HZ_CONTACT_POINTS
404 ,PHONE_EXTENSION VARCHAR2(20) -- HZ_CONTACT_POINTS
405 ,PHONE_LINE_TYPE VARCHAR2(30) -- HZ_CONTACT_POINTS
406 ,PHONE_NUMBER VARCHAR2(40) -- HZ_CONTACT_POINTS
407 ,PRIMARY_FLAG VARCHAR2(1) -- HZ_CONTACT_POINTS
408 ,RAW_PHONE_NUMBER VARCHAR2(2000) -- HZ_CONTACT_POINTS
409 ,TELEPHONE_TYPE VARCHAR2(30) -- HZ_CONTACT_POINTS
410 ,TELEX_NUMBER VARCHAR2(50) -- HZ_CONTACT_POINTS
411 ,TIME_ZONE NUMBER -- HZ_CONTACT_POINTS
412 ,URL VARCHAR2(2000) -- HZ_CONTACT_POINTS
413 ,WEB_TYPE VARCHAR2(60) -- HZ_CONTACT_POINTS
414 ,STATUS VARCHAR2(1) -- HZ_CONTACT_POINTS
415 ,CONTACT_POINT_PURPOSE VARCHAR2(30) -- HZ_CONTACT_POINTS
416 );
417
418 TYPE party_scores IS RECORD (
419 SCORE1 NUMBER := 0,
420 SCORE2 NUMBER := 0,
421 SCORE3 NUMBER := 0,
422 SCORE4 NUMBER := 0,
423 SCORE5 NUMBER := 0,
424 SCORE6 NUMBER := 0,
425 SCORE7 NUMBER := 0,
426 SCORE8 NUMBER := 0,
427 SCORE9 NUMBER := 0,
428 SCORE10 NUMBER := 0,
429 SCORE11 NUMBER := 0,
430 SCORE12 NUMBER := 0,
431 SCORE13 NUMBER := 0,
432 SCORE14 NUMBER := 0,
433 SCORE15 NUMBER := 0,
434 SCORE16 NUMBER := 0,
435 SCORE17 NUMBER := 0,
436 SCORE18 NUMBER := 0,
437 SCORE19 NUMBER := 0,
438 SCORE20 NUMBER := 0,
439 SCORE21 NUMBER := 0,
440 SCORE22 NUMBER := 0,
441 SCORE23 NUMBER := 0,
442 SCORE24 NUMBER := 0,
443 SCORE25 NUMBER := 0,
444 SCORE26 NUMBER := 0,
445 SCORE27 NUMBER := 0,
446 SCORE28 NUMBER := 0,
447 SCORE29 NUMBER := 0,
448 SCORE30 NUMBER := 0,
449 SCORE31 NUMBER := 0,
450 SCORE32 NUMBER := 0,
451 SCORE33 NUMBER := 0,
452 SCORE34 NUMBER := 0,
453 SCORE35 NUMBER := 0,
454 SCORE36 NUMBER := 0,
455 SCORE37 NUMBER := 0,
456 SCORE38 NUMBER := 0,
457 SCORE39 NUMBER := 0,
458 SCORE40 NUMBER := 0,
459 SCORE41 NUMBER := 0,
460 SCORE42 NUMBER := 0,
461 SCORE43 NUMBER := 0,
462 SCORE44 NUMBER := 0,
463 SCORE45 NUMBER := 0,
464 SCORE46 NUMBER := 0,
465 SCORE47 NUMBER := 0,
466 SCORE48 NUMBER := 0,
467 SCORE49 NUMBER := 0,
468 SCORE50 NUMBER := 0
469 );
470
471 TYPE ScoreList IS TABLE of party_scores
472 INDEX BY BINARY_INTEGER;
473
474 TYPE IDList is TABLE of NUMBER
475 INDEX BY BINARY_INTEGER;
476
477 TYPE TXList is TABLE of VARCHAR2(2000)
478 INDEX BY BINARY_INTEGER;
479
480 TYPE party_site_list IS TABLE OF party_site_search_rec_type
481 INDEX BY BINARY_INTEGER;
482 TYPE contact_list IS TABLE OF contact_search_rec_type
483 INDEX BY BINARY_INTEGER;
484 TYPE contact_point_list IS TABLE OF contact_point_search_rec_type
485 INDEX BY BINARY_INTEGER;
486
487 TYPE cpt_type_array IS TABLE OF NUMBER(15) INDEX BY VARCHAR2(30) ;
488
489 TYPE score_rec IS RECORD (
490 total_score NUMBER,
491 party_score NUMBER,
492 party_site_score NUMBER,
493 contact_score NUMBER,
494 contact_point_score NUMBER,
495 party_id NUMBER,
496 party_site_id NUMBER,
497 org_contact_id NUMBER,
498 contact_point_id NUMBER,
499 cpt_type_match cpt_type_array);
500
501 TYPE score_list IS TABLE OF score_rec index by BINARY_INTEGER;
502
503 TYPE search_rec_type IS RECORD (
504 party_search_rec party_search_rec_type,
505 party_site_search_rec party_site_search_rec_type,
506 contact_search_rec contact_search_rec_type,
507 contact_point_search_rec contact_point_search_rec_type
508 );
509
510 G_MISS_PARTY_SEARCH_REC party_search_rec_type;
511 G_MISS_PARTY_SITE_LIST party_site_list;
512 G_MISS_CONTACT_LIST contact_list;
513 G_MISS_CONTACT_POINT_LIST contact_point_list;
514 G_MISS_ID_LIST IDList;
515
516 /*===========================================================================+
517 | PROCEDURE
518 | find_parties
519 |
520 | DESCRIPTION
521 | Find a set of parties given the search criteria.
522 | Results are stored in the temporary table, HZ_MATCHED_PARTIES_GT
523 |
524 | SCOPE - PUBLIC
525 |
526 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
527 |
528 | ARGUMENTS : IN:
529 | p_init_msg_list
530 | p_rule_id
531 | p_search_cond
532 | p_primary_and_flag
533 |
534 | OUT:
535 | x_return_status
536 | x_msg_count
537 | x_msg_data
538 | IN/ OUT:
539 |
540 | RETURNS : NONE
541 |
542 | NOTES
543 |
544 | MODIFICATION HISTORY
548 /*#
545 | Srinivasa Rangan 27-APR-01 Created
546 |
547 +===========================================================================*/
549 * Finds parties based on the passed search criteria. The API finds parties that match party level
550 * search criteria, and/or have addresses, contacts, and/or contact points that match corresponding
551 * address, contact, or contact point criteria. When the matching is based on address and contact point
552 * search criteria, the API finds parties of type Organization, looking at the organization end of relationships.
553 * The API returns the set of matches to the HZ_MATCHED_PARTIES_GT table, which holds the PARTY_ID and
554 * score of all matches. Use the x_search_ctx_id value that the API returns to filter results from this table.
555 * @rep:scope public
556 * @rep:lifecycle active
557 * @rep:displayname Find Parties
558 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
559 * Oracle Trading Community Architecture Technical Implementation Guide
560 */
561 PROCEDURE find_parties (
562 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
563 p_rule_id IN NUMBER,
564 p_party_search_rec IN party_search_rec_type,
565 p_party_site_list IN party_site_list,
566 p_contact_list IN contact_list,
567 p_contact_point_list IN contact_point_list,
568 p_restrict_sql IN VARCHAR2,
569 p_match_type IN VARCHAR2,
570 p_search_merged IN VARCHAR2,
571 x_search_ctx_id OUT NOCOPY NUMBER,
572 x_num_matches OUT NOCOPY NUMBER,
573 x_return_status OUT NOCOPY VARCHAR2,
574 x_msg_count OUT NOCOPY NUMBER,
575 x_msg_data OUT NOCOPY VARCHAR2
576 );
577
578 -- Old signature. Retained for backward compatibility
579 PROCEDURE find_parties (
580 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
581 x_rule_id IN OUT NOCOPY NUMBER,
582 p_party_search_rec IN party_search_rec_type,
583 p_party_site_list IN party_site_list,
584 p_contact_list IN contact_list,
585 p_contact_point_list IN contact_point_list,
586 p_restrict_sql IN VARCHAR2,
587 p_search_merged IN VARCHAR2,
588 x_search_ctx_id IN OUT NOCOPY NUMBER,
589 x_num_matches IN OUT NOCOPY NUMBER,
590 x_return_status OUT NOCOPY VARCHAR2,
591 x_msg_count OUT NOCOPY NUMBER,
592 x_msg_data OUT NOCOPY VARCHAR2
593 );
594
595 /*#
596 * Finds persons based on the passed search criteria. The API finds persons that match party level
597 * search criteria, and/or have addresses, contacts, and/or contact points that match corresponding
598 * address, contact, or contact point criteria. The API always returns parties of type Person, even if
599 * the matching is based on address or contact point search criteria, by looking at the person end of
600 * relationships. The API returns the set of matches to the HZ_MATCHED_PARTIES_GT table, which holds the
601 * PARTY_ID and score of all matches. Use the x_search_ctx_id value that the API returns to filter results
602 * from this table.
603 * @rep:scope public
604 * @rep:lifecycle active
605 * @rep:displayname Find Persons
606 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
607 * Oracle Trading Community Architecture Technical Implementation Guide
608 */
609 PROCEDURE find_persons (
610 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
611 p_rule_id IN NUMBER,
612 p_party_search_rec IN party_search_rec_type,
613 p_party_site_list IN party_site_list,
614 p_contact_list IN contact_list,
615 p_contact_point_list IN contact_point_list,
616 p_restrict_sql IN VARCHAR2,
617 p_match_type IN VARCHAR2,
618 x_search_ctx_id OUT NOCOPY NUMBER,
619 x_num_matches OUT NOCOPY NUMBER,
620 x_return_status OUT NOCOPY VARCHAR2,
621 x_msg_count OUT NOCOPY NUMBER,
622 x_msg_data OUT NOCOPY VARCHAR2
623 );
624
625
626 /*===========================================================================+
627 | PROCEDURE
628 |
629 | get_matching_party_sites
630 |
631 | DESCRIPTION
632 | Find a set of parties given the search criteria.
633 | Results are stored in the temporary table,
634 | HZ_MATCHED_PARTY_SITES_GT
635 |
636 | SCOPE - PUBLIC
637 |
638 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
639 |
640 | ARGUMENTS : IN:
641 | p_init_msg_list
642 | p_rule_id
643 | p_party_id
644 | p_ps_search_cond
645 |
646 | OUT:
647 | x_return_status
648 | x_msg_count
649 | x_msg_data
650 | IN/ OUT:
651 |
652 | RETURNS : NONE
653 |
654 | NOTES
655 |
656 | MODIFICATION HISTORY
657 | Srinivasa Rangan 27-APR-01 Created
658 |
662 * Finds party sites based on the passed search criteria. The API finds all party sites that
659 +===========================================================================*/
660
661 /*#
663 * match the address search criteria passed into the p_party_site_list parameter, and/or have
664 * contact points, defined for party sites, that match contact point criteria passed into the
665 * p_contact_point_list parameter. The API returns the set of matches to the HZ_MATCHED_PARTY_SITES_GT
666 * table, which holds the PARTY_SITE_ID, PARTY_ID, and score of all matches. Use the x_search_ctx_id value
667 * that the API returns to filter results from this table.
668 * @rep:scope public
669 * @rep:lifecycle active
670 * @rep:displayname Find Party Sites
671 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
672 * Oracle Trading Community Architecture Technical Implementation Guide
673 */
674 PROCEDURE get_matching_party_sites (
675 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
676 p_rule_id IN NUMBER,
677 p_party_id IN NUMBER,
678 p_party_site_list IN PARTY_SITE_LIST,
679 p_contact_point_list IN CONTACT_POINT_LIST,
680 p_restrict_sql IN VARCHAR2,
681 p_match_type IN VARCHAR2,
682 x_search_ctx_id OUT NOCOPY NUMBER,
683 x_num_matches OUT NOCOPY NUMBER,
684 x_return_status OUT NOCOPY VARCHAR2,
685 x_msg_count OUT NOCOPY NUMBER,
686 x_msg_data OUT NOCOPY VARCHAR2
687 );
688
689
690 PROCEDURE get_matching_party_sites (
691 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
692 p_rule_id IN NUMBER,
693 p_party_id IN NUMBER,
694 p_party_site_list IN PARTY_SITE_LIST,
695 p_contact_point_list IN CONTACT_POINT_LIST,
696 x_search_ctx_id OUT NOCOPY NUMBER,
697 x_return_status OUT NOCOPY VARCHAR2,
698 x_msg_count OUT NOCOPY NUMBER,
699 x_msg_data OUT NOCOPY VARCHAR2
700 );
701
702 /*===========================================================================+
703 | PROCEDURE
704 | get_matching_contacts
705 |
706 | DESCRIPTION
707 | Find a set of parties given the search criteria.
708 | Results are stored in the temporary table,
709 | HZ_MATCHED_CONTACTS_GT
710 |
711 | SCOPE - PUBLIC
712 |
713 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
714 |
715 | ARGUMENTS : IN:
716 | p_init_msg_list
717 | p_rule_id
718 | p_party_id
719 | p_contact_search_cond
720 |
721 | OUT:
722 | x_return_status
723 | x_msg_count
724 | x_msg_data
725 | IN/ OUT:
726 |
727 | RETURNS : NONE
728 |
729 | NOTES
730 |
731 | MODIFICATION HISTORY
732 | Srinivasa Rangan 27-APR-01 Created
733 |
734 +===========================================================================*/
735
736 /*#
737 * Finds contacts based on the passed search criteria. The API finds all contacts that match
738 * the contact search criteria passed into the p_contact_list parameter, and/or have contact points,
739 * defined for contacts, that match contact point criteria passed into the p_contact_point_list parameter.
740 * The API returns the set of matches to the HZ_MATCHED_CONTACTS_GT table, which holds the ORG_CONTACT_ID,
741 * PARTY_ID, and score of all matches. Use the x_search_ctx_id value that the API returns to filter results
742 * from this table.
743 * @rep:scope public
744 * @rep:lifecycle active
745 * @rep:displayname Find Contacts
746 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
747 * Oracle Trading Community Architecture Technical Implementation Guide
748 */
749 PROCEDURE get_matching_contacts (
750 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
751 p_rule_id IN NUMBER,
752 p_party_id IN NUMBER,
753 p_contact_list IN CONTACT_LIST,
754 p_contact_point_list IN CONTACT_POINT_LIST,
755 p_restrict_sql IN VARCHAR2,
756 p_match_type IN VARCHAR2,
757 x_search_ctx_id OUT NOCOPY NUMBER,
758 x_num_matches OUT NOCOPY NUMBER,
759 x_return_status OUT NOCOPY VARCHAR2,
760 x_msg_count OUT NOCOPY NUMBER,
761 x_msg_data OUT NOCOPY VARCHAR2
762 );
763
764
765 PROCEDURE get_matching_contacts (
766 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
767 p_rule_id IN NUMBER,
768 p_party_id IN NUMBER,
769 p_contact_list IN CONTACT_LIST,
770 p_contact_point_list IN CONTACT_POINT_LIST,
771 x_search_ctx_id OUT NOCOPY NUMBER,
772 x_return_status OUT NOCOPY VARCHAR2,
773 x_msg_count OUT NOCOPY NUMBER,
774 x_msg_data OUT NOCOPY VARCHAR2
775 );
776
777 /*===========================================================================+
778 | PROCEDURE
779 | get_matching_contact_points
780 |
781 | DESCRIPTION
782 | Find a set of contact points given the search criteria.
783 | Results are stored in the temporary table,
784 | HZ_MATCHED_CONTACT_PTS_GT
785 |
789 |
786 | SCOPE - PUBLIC
787 |
788 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
790 | ARGUMENTS : IN:
791 | p_init_msg_list
792 | p_rule_id
793 | p_party_id
794 | p_cont_pt_search_cond
795 |
796 | OUT:
797 | x_return_status
798 | x_msg_count
799 | x_msg_data
800 | IN/ OUT:
801 |
802 | RETURNS : NONE
803 |
804 | NOTES
805 |
806 | MODIFICATION HISTORY
807 | Srinivasa Rangan 27-APR-01 Created
808 |
809 +===========================================================================*/
810
811 /*#
812 * Finds contact points based on the passed search criteria. The API finds all contact points that
813 * match the contact point search criteria passed into the p_contact_point_list parameter. The API
814 * returns the set of matches to the HZ_MATCHED_CPTS_GT table, which holds the CONTACT_POINT_ID,
815 * PARTY_ID, and score of all matches. Use the x_search_ctx_id value that the API returns to filter results
816 * from this table.
817 * @rep:scope public
818 * @rep:lifecycle active
819 * @rep:displayname Find Contact Points
820 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
821 * Oracle Trading Community Architecture Technical Implementation Guide
822 */
823 PROCEDURE get_matching_contact_points (
824 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
825 p_rule_id IN NUMBER,
826 p_party_id IN NUMBER,
827 p_contact_point_list IN CONTACT_POINT_LIST,
828 p_restrict_sql IN VARCHAR2,
829 p_match_type IN VARCHAR2,
830 x_search_ctx_id OUT NOCOPY NUMBER,
831 x_num_matches OUT NOCOPY NUMBER,
832 x_return_status OUT NOCOPY VARCHAR2,
833 x_msg_count OUT NOCOPY NUMBER,
834 x_msg_data OUT NOCOPY VARCHAR2
835 );
836
837
838 PROCEDURE get_matching_contact_points (
839 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
840 p_rule_id IN NUMBER,
841 p_party_id IN NUMBER,
842 p_contact_point_list IN CONTACT_POINT_LIST,
843 x_search_ctx_id OUT NOCOPY NUMBER,
844 x_return_status OUT NOCOPY VARCHAR2,
845 x_msg_count OUT NOCOPY NUMBER,
846 x_msg_data OUT NOCOPY VARCHAR2
847 );
848
849 /*===========================================================================+
850 | PROCEDURE
851 | get_party_score_details
852 | DESCRIPTION
853 | Find a set of parties given the search criteria.
854 | Results are stored in the temporary table,
855 | HZ_PARTY_SCORE_DTLS_GT
856 |
857 | SCOPE - PUBLIC
858 |
859 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
860 |
861 | ARGUMENTS : IN:
862 | p_init_msg_list
863 | p_rule_id
864 | p_party_id
865 | p_search_cond
866 |
867 | OUT:
868 | x_return_status
869 | x_msg_count
870 | x_msg_data
871 | IN/ OUT:
872 |
873 | RETURNS : NONE
874 |
875 | NOTES
876 |
877 | MODIFICATION HISTORY
878 | Srinivasa Rangan 27-APR-01 Created
879 |
880 +===========================================================================*/
881
882 PROCEDURE get_party_score_details (
883 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
884 p_rule_id IN NUMBER,
885 p_party_id IN NUMBER,
886 p_search_ctx_id IN NUMBER,
887 p_party_search_rec IN party_search_rec_type,
888 p_party_site_list IN party_site_list,
889 p_contact_list IN contact_list,
890 p_contact_point_list IN contact_point_list,
891 x_return_status OUT NOCOPY VARCHAR2,
892 x_msg_count OUT NOCOPY NUMBER,
893 x_msg_data OUT NOCOPY VARCHAR2
894 );
895
896 /*#
897 * Gets details about how a party matches the input search criteria. Though not required, the API is
898 * usually called after calls to the find_parties API, to display how a match is determined. The API
899 * compares the input search criteria against the party passed into the p_party_id paramter, and inserts
900 * all matching attributes into the HZ_PARTY_SCORE_DTLS_GT table. The columns in this table include: ATTRIBUTE,
901 * the matching attribute; ENTERED_VALUE, the attribute value entered for the search criterion; MATCHED_VALUE,
902 * the attribute value for the p_party_id party, and ASSIGNED_SCORE, the score assigned to the match.
903 * The x_search_ctx_id is used as an IN/OUT parameter. If this API is called right after a call to find_parties,
904 * then this API can use the same search_context_id and would retain x_search_context_id as is. If the
905 * search_context_id is not passed in, then this API generates and populates a search_context_id in the
906 * x_search_context_id variable. In either case, use the x_search_context_id value that the API returns to
907 * filter results from the HZ_PARTY_SCORE_DTLS_GT table.
908 * @rep:scope public
909 * @rep:lifecycle active
910 * @rep:displayname Get Score Details
911 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
915 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
912 * Oracle Trading Community Architecture Technical Implementation Guide
913 */
914 PROCEDURE get_score_details (
916 p_rule_id IN NUMBER,
917 p_party_id IN NUMBER,
918 p_party_search_rec IN party_search_rec_type,
919 p_party_site_list IN party_site_list,
920 p_contact_list IN contact_list,
921 p_contact_point_list IN contact_point_list,
922 x_search_ctx_id IN OUT NOCOPY NUMBER,
923 x_return_status OUT NOCOPY VARCHAR2,
924 x_msg_count OUT NOCOPY NUMBER,
925 x_msg_data OUT NOCOPY VARCHAR2
926 );
927
928 /*** New API ****/
929
930 /*#
931 * Finds parties and party details based on search criteria. This API performs the same matching as
932 * the find_parties API, but returns more details regarding which party sites, contacts, and contact
933 * points matched. This API returns the set of matches to the HZ_MATCHED_PARTIES_GT table, which holds
934 * the PARTY_ID and score of all matches. The API also inserts matching party sites into
935 * HZ_MATCHED_PARTY_SITES_GT, matching contacts into HZ_MATCHED_CONTACTS_GT, and matching contact points
936 * into HZ_MATCHED_CPTS_GT. Use the x_search_ctx_id value that this API returns to filter results from all
937 * above tables. Use this API for UIs that provide access to the above details after displaying matched parties.
938 * If only matched parties need to be displayed, then use find_parties for better performance.
939 * @rep:scope public
940 * @rep:lifecycle active
941 * @rep:displayname Find Parties and Details
942 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
943 * Oracle Trading Community Architecture Technical Implementation Guide
944 */
945 PROCEDURE find_party_details (
946 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
947 p_rule_id IN NUMBER,
948 p_party_search_rec IN party_search_rec_type,
949 p_party_site_list IN party_site_list,
950 p_contact_list IN contact_list,
951 p_contact_point_list IN contact_point_list,
952 p_restrict_sql IN VARCHAR2,
953 p_match_type IN VARCHAR2,
954 p_search_merged IN VARCHAR2,
955 x_search_ctx_id OUT NOCOPY NUMBER,
956 x_num_matches OUT NOCOPY NUMBER,
957 x_return_status OUT NOCOPY VARCHAR2,
958 x_msg_count OUT NOCOPY NUMBER,
959 x_msg_data OUT NOCOPY VARCHAR2
960 );
961
962 /*#
963 * Identifies duplicates of a specific party. The API finds duplicates within a subset or across the
964 * entire TCA Registry, depending on what is passed into the p_restrict_sql parameter. The API inserts
965 * duplicates into the HZ_MATCHED_PARTIES_GT table if the p_dup_batch_id parameter is null. If this
966 * parameter is not null, then the API creates a duplicate set with the list of duplicates in the HZ_DUP_SET
967 * and HZ_DUP_SET_PARTIES tables. Use the x_search_ctx_id value that the API returns to filter results from
968 * the HZ_MATCHED_PARTIES_GT table.
969 * @rep:scope public
970 * @rep:lifecycle active
971 * @rep:displayname Identify Duplicate Parties
972 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
973 * Oracle Trading Community Architecture Technical Implementation Guide
974 */
975 PROCEDURE find_duplicate_parties (
976 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
977 p_rule_id IN NUMBER,
978 p_party_id IN NUMBER,
979 p_restrict_sql IN VARCHAR2,
980 p_match_type IN VARCHAR2,
981 p_dup_batch_id IN NUMBER,
982 p_search_merged IN VARCHAR2,
983 x_dup_set_id OUT NOCOPY NUMBER,
984 x_search_ctx_id OUT NOCOPY NUMBER,
985 x_num_matches OUT NOCOPY NUMBER,
986 x_return_status OUT NOCOPY VARCHAR2,
987 x_msg_count OUT NOCOPY NUMBER,
988 x_msg_data OUT NOCOPY VARCHAR2
989 );
990
991 PROCEDURE find_parties_dynamic (
992 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
993 p_rule_id IN NUMBER,
994 p_attrib_id1 IN NUMBER,
995 p_attrib_id2 IN NUMBER,
996 p_attrib_id3 IN NUMBER,
997 p_attrib_id4 IN NUMBER,
998 p_attrib_id5 IN NUMBER,
999 p_attrib_id6 IN NUMBER,
1000 p_attrib_id7 IN NUMBER,
1001 p_attrib_id8 IN NUMBER,
1002 p_attrib_id9 IN NUMBER,
1003 p_attrib_id10 IN NUMBER,
1004 p_attrib_id11 IN NUMBER,
1005 p_attrib_id12 IN NUMBER,
1006 p_attrib_id13 IN NUMBER,
1007 p_attrib_id14 IN NUMBER,
1008 p_attrib_id15 IN NUMBER,
1009 p_attrib_id16 IN NUMBER,
1010 p_attrib_id17 IN NUMBER,
1011 p_attrib_id18 IN NUMBER,
1012 p_attrib_id19 IN NUMBER,
1013 p_attrib_id20 IN NUMBER,
1014 p_attrib_val1 IN VARCHAR2,
1015 p_attrib_val2 IN VARCHAR2,
1016 p_attrib_val3 IN VARCHAR2,
1017 p_attrib_val4 IN VARCHAR2,
1018 p_attrib_val5 IN VARCHAR2,
1019 p_attrib_val6 IN VARCHAR2,
1020 p_attrib_val7 IN VARCHAR2,
1021 p_attrib_val8 IN VARCHAR2,
1022 p_attrib_val9 IN VARCHAR2,
1023 p_attrib_val10 IN VARCHAR2,
1024 p_attrib_val11 IN VARCHAR2,
1028 p_attrib_val15 IN VARCHAR2,
1025 p_attrib_val12 IN VARCHAR2,
1026 p_attrib_val13 IN VARCHAR2,
1027 p_attrib_val14 IN VARCHAR2,
1029 p_attrib_val16 IN VARCHAR2,
1030 p_attrib_val17 IN VARCHAR2,
1031 p_attrib_val18 IN VARCHAR2,
1032 p_attrib_val19 IN VARCHAR2,
1033 p_attrib_val20 IN VARCHAR2,
1034 p_restrict_sql IN VARCHAR2,
1035 p_match_type IN VARCHAR2,
1036 p_search_merged IN VARCHAR2,
1037 x_search_ctx_id OUT NOCOPY NUMBER,
1038 x_num_matches OUT NOCOPY NUMBER,
1039 x_return_status OUT NOCOPY VARCHAR2,
1040 x_msg_count OUT NOCOPY NUMBER,
1041 x_msg_data OUT NOCOPY VARCHAR2
1042 );
1043
1044 /*#
1045 * Calls the appropriate API based on attribute ID values. The API accepts up to 20 attribute ID
1046 * value pairs as search criteria and dispatches a call to the corresponding search API that is
1047 * passed into the p_api_name parameter. Use the x_search_ctx_id value that the API returns to
1048 * filter results from the appropriate table.
1049 * @rep:scope public
1050 * @rep:lifecycle active
1051 * @rep:displayname Call API Dynamic IDs
1052 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
1053 * Oracle Trading Community Architecture Technical Implementation Guide
1054 */
1055 PROCEDURE call_api_dynamic (
1056 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1057 p_rule_id IN NUMBER,
1058 p_attrib_id1 IN NUMBER,
1059 p_attrib_id2 IN NUMBER,
1060 p_attrib_id3 IN NUMBER,
1061 p_attrib_id4 IN NUMBER,
1062 p_attrib_id5 IN NUMBER,
1063 p_attrib_id6 IN NUMBER,
1064 p_attrib_id7 IN NUMBER,
1065 p_attrib_id8 IN NUMBER,
1066 p_attrib_id9 IN NUMBER,
1067 p_attrib_id10 IN NUMBER,
1068 p_attrib_id11 IN NUMBER,
1069 p_attrib_id12 IN NUMBER,
1070 p_attrib_id13 IN NUMBER,
1071 p_attrib_id14 IN NUMBER,
1072 p_attrib_id15 IN NUMBER,
1073 p_attrib_id16 IN NUMBER,
1074 p_attrib_id17 IN NUMBER,
1075 p_attrib_id18 IN NUMBER,
1076 p_attrib_id19 IN NUMBER,
1077 p_attrib_id20 IN NUMBER,
1078 p_attrib_val1 IN VARCHAR2,
1079 p_attrib_val2 IN VARCHAR2,
1080 p_attrib_val3 IN VARCHAR2,
1081 p_attrib_val4 IN VARCHAR2,
1082 p_attrib_val5 IN VARCHAR2,
1083 p_attrib_val6 IN VARCHAR2,
1084 p_attrib_val7 IN VARCHAR2,
1085 p_attrib_val8 IN VARCHAR2,
1086 p_attrib_val9 IN VARCHAR2,
1087 p_attrib_val10 IN VARCHAR2,
1088 p_attrib_val11 IN VARCHAR2,
1089 p_attrib_val12 IN VARCHAR2,
1090 p_attrib_val13 IN VARCHAR2,
1091 p_attrib_val14 IN VARCHAR2,
1092 p_attrib_val15 IN VARCHAR2,
1093 p_attrib_val16 IN VARCHAR2,
1094 p_attrib_val17 IN VARCHAR2,
1095 p_attrib_val18 IN VARCHAR2,
1096 p_attrib_val19 IN VARCHAR2,
1097 p_attrib_val20 IN VARCHAR2,
1098 p_restrict_sql IN VARCHAR2,
1099 p_api_name IN VARCHAR2,
1100 p_match_type IN VARCHAR2,
1101 p_party_id IN NUMBER,
1102 p_search_merged IN VARCHAR2,
1103 x_search_ctx_id OUT NOCOPY NUMBER,
1104 x_num_matches OUT NOCOPY NUMBER,
1105 x_return_status OUT NOCOPY VARCHAR2,
1106 x_msg_count OUT NOCOPY NUMBER,
1107 x_msg_data OUT NOCOPY VARCHAR2
1108 );
1109
1110 /*#
1111 * Identifies duplicates of a specific party site. The API finds duplicates within a subset
1112 * defined by what is passed into the p_restrict_sql parameter, within the party passed into
1113 * the p_party_id parameter, or across the entire TCA Registry. The API inserts duplicates
1114 * into the HZ_MATCHED_PARTY_SITES_GT table. Use the x_search_ctx_id value that the API returns
1115 * to filter results from this table.
1116 * @rep:scope public
1117 * @rep:lifecycle active
1118 * @rep:displayname Identify Duplicate Party Sites
1119 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
1120 * Oracle Trading Community Architecture Technical Implementation Guide
1121 */
1122 PROCEDURE find_duplicate_party_sites (
1123 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1124 p_rule_id IN NUMBER,
1125 p_party_site_id IN NUMBER,
1126 p_party_id IN NUMBER,
1127 p_restrict_sql IN VARCHAR2,
1128 p_match_type IN VARCHAR2,
1129 x_search_ctx_id OUT NOCOPY NUMBER,
1130 x_num_matches OUT NOCOPY NUMBER,
1131 x_return_status OUT NOCOPY VARCHAR2,
1132 x_msg_count OUT NOCOPY NUMBER,
1133 x_msg_data OUT NOCOPY VARCHAR2
1134 );
1135
1136 /*#
1137 * Identifies duplicates of a specific contact. The API finds duplicates within a subset defined
1138 * by what is passed into the p_restrict_sql parameter, within the party passed into the p_party_id
1139 * parameter, or across the entire TCA Registry. The API inserts duplicates into the HZ_MATCHED_CONTACTS_GT
1140 * table. Use the x_search_ctx_id value that the API returns to filter results from this table.
1141 * @rep:scope public
1142 * @rep:lifecycle active
1143 * @rep:displayname Identify Duplicate Contacts
1144 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
1145 * Oracle Trading Community Architecture Technical Implementation Guide
1146 */
1147 PROCEDURE find_duplicate_contacts (
1151 p_party_id IN NUMBER,
1148 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1149 p_rule_id IN NUMBER,
1150 p_org_contact_id IN NUMBER,
1152 p_restrict_sql IN VARCHAR2,
1153 p_match_type IN VARCHAR2,
1154 x_search_ctx_id OUT NOCOPY NUMBER,
1155 x_num_matches OUT NOCOPY NUMBER,
1156 x_return_status OUT NOCOPY VARCHAR2,
1157 x_msg_count OUT NOCOPY NUMBER,
1158 x_msg_data OUT NOCOPY VARCHAR2
1159 );
1160
1161 /*#
1162 * Identifies duplicates of a specific contact point. The API finds duplicates within a subset defined
1163 * by what is passed into the p_restrict_sql parameter, within the party passed into the p_party_id parameter,
1164 * or across the entire TCA Registry. The API inserts duplicates into the HZ_MATCHED_CPTS_GT table. Use the
1165 * x_search_ctx_id value that the API returns to filter results from this table.
1166 * @rep:scope public
1167 * @rep:lifecycle active
1168 * @rep:displayname Identify Duplicate Contact Points
1169 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
1170 * Oracle Trading Community Architecture Technical Implementation Guide
1171 */
1172 PROCEDURE find_duplicate_contact_points (
1173 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1174 p_rule_id IN NUMBER,
1175 p_contact_point_id IN NUMBER,
1176 p_party_id IN NUMBER,
1177 p_restrict_sql IN VARCHAR2,
1178 p_match_type IN VARCHAR2,
1179 x_search_ctx_id OUT NOCOPY NUMBER,
1180 x_num_matches OUT NOCOPY NUMBER,
1181 x_return_status OUT NOCOPY VARCHAR2,
1182 x_msg_count OUT NOCOPY NUMBER,
1183 x_msg_data OUT NOCOPY VARCHAR2
1184 );
1185
1186 /*===========================================================================+
1187 | PROCEDURE
1188 | get_party_for_search
1189 | DESCRIPTION
1190 | Queries the party, party site, contact and contact point
1191 | search criteria into the search record structures
1192 | for the given party.
1193 |
1194 | SCOPE - PUBLIC
1195 |
1196 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
1197 |
1198 | ARGUMENTS : IN:
1199 | p_init_msg_list
1200 | p_rule_id
1201 | p_party_id
1202 |
1203 | OUT:
1204 | x_party_search_rec
1205 | x_party_site_list
1206 | x_contact_list
1207 | x_contact_point_list
1208 | x_return_status
1209 | x_msg_count
1210 | x_msg_data
1211 | IN/ OUT:
1212 |
1213 | RETURNS : NONE
1214 |
1215 | NOTES
1216 |
1217 | MODIFICATION HISTORY
1218 | Srinivasa Rangan 27-APR-01 Created
1219 |
1220 +===========================================================================*/
1221
1222 PROCEDURE get_party_for_search (
1223 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1224 p_rule_id IN NUMBER,
1225 p_party_id IN NUMBER,
1226 x_party_search_rec OUT NOCOPY party_search_rec_type,
1227 x_party_site_list OUT NOCOPY party_site_list,
1228 x_contact_list OUT NOCOPY contact_list,
1229 x_contact_point_list OUT NOCOPY contact_point_list,
1230 x_return_status OUT NOCOPY VARCHAR2,
1231 x_msg_count OUT NOCOPY NUMBER,
1232 x_msg_data OUT NOCOPY VARCHAR2
1233 );
1234
1235
1236 PROCEDURE get_search_criteria (
1237 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1238 p_rule_id IN NUMBER,
1239 p_party_id IN NUMBER,
1240 p_party_site_ids IN IDList,
1241 p_contact_ids IN IDList,
1242 p_contact_pt_ids IN IDList,
1243 x_party_search_rec OUT NOCOPY party_search_rec_type,
1244 x_party_site_list OUT NOCOPY party_site_list,
1245 x_contact_list OUT NOCOPY contact_list,
1246 x_contact_point_list OUT NOCOPY contact_point_list,
1247 x_return_status OUT NOCOPY VARCHAR2,
1248 x_msg_count OUT NOCOPY NUMBER,
1249 x_msg_data OUT NOCOPY VARCHAR2
1250 );
1251
1252 /*#
1253 * Calls the appropriate API based on attribute name values. The API accepts up to 20 attribute name
1254 * value pairs as search criteria and dispatches a call to the corresponding search API that is passed
1255 * into the p_api_name parameter. Use the x_search_ctx_id value that the API returns to filter results
1256 * from the appropriate table.
1257 * @rep:scope public
1258 * @rep:lifecycle active
1259 * @rep:displayname Call API Dynamic Names
1260 * @rep:doccd 120hztig.pdf Data Quality Management Search and Duplicate Identification APIs,
1261 * Oracle Trading Community Architecture Technical Implementation Guide
1262 */
1263 PROCEDURE call_api_dynamic_names (
1264 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1268 p_attrib_name3 IN VARCHAR2,
1265 p_rule_id IN NUMBER,
1266 p_attrib_name1 IN VARCHAR2,
1267 p_attrib_name2 IN VARCHAR2,
1269 p_attrib_name4 IN VARCHAR2,
1270 p_attrib_name5 IN VARCHAR2,
1271 p_attrib_name6 IN VARCHAR2,
1272 p_attrib_name7 IN VARCHAR2,
1273 p_attrib_name8 IN VARCHAR2,
1274 p_attrib_name9 IN VARCHAR2,
1275 p_attrib_name10 IN VARCHAR2,
1276 p_attrib_name11 IN VARCHAR2,
1277 p_attrib_name12 IN VARCHAR2,
1278 p_attrib_name13 IN VARCHAR2,
1279 p_attrib_name14 IN VARCHAR2,
1280 p_attrib_name15 IN VARCHAR2,
1281 p_attrib_name16 IN VARCHAR2,
1282 p_attrib_name17 IN VARCHAR2,
1283 p_attrib_name18 IN VARCHAR2,
1284 p_attrib_name19 IN VARCHAR2,
1285 p_attrib_name20 IN VARCHAR2,
1286 p_attrib_val1 IN VARCHAR2,
1287 p_attrib_val2 IN VARCHAR2,
1288 p_attrib_val3 IN VARCHAR2,
1289 p_attrib_val4 IN VARCHAR2,
1290 p_attrib_val5 IN VARCHAR2,
1291 p_attrib_val6 IN VARCHAR2,
1292 p_attrib_val7 IN VARCHAR2,
1293 p_attrib_val8 IN VARCHAR2,
1294 p_attrib_val9 IN VARCHAR2,
1295 p_attrib_val10 IN VARCHAR2,
1296 p_attrib_val11 IN VARCHAR2,
1297 p_attrib_val12 IN VARCHAR2,
1298 p_attrib_val13 IN VARCHAR2,
1299 p_attrib_val14 IN VARCHAR2,
1300 p_attrib_val15 IN VARCHAR2,
1301 p_attrib_val16 IN VARCHAR2,
1302 p_attrib_val17 IN VARCHAR2,
1303 p_attrib_val18 IN VARCHAR2,
1304 p_attrib_val19 IN VARCHAR2,
1305 p_attrib_val20 IN VARCHAR2,
1306 p_restrict_sql IN VARCHAR2,
1307 p_api_name IN VARCHAR2,
1308 p_match_type IN VARCHAR2,
1309 p_party_id IN NUMBER,
1310 p_search_merged IN VARCHAR2,
1311 x_search_ctx_id OUT NOCOPY NUMBER,
1312 x_num_matches OUT NOCOPY NUMBER,
1313 x_return_status OUT NOCOPY VARCHAR2,
1314 x_msg_count OUT NOCOPY NUMBER,
1315 x_msg_data OUT NOCOPY VARCHAR2
1316 );
1317
1318 END HZ_PARTY_SEARCH;