[Home] [Help]
PACKAGE: APPS.ARH_DQM_SRCH_PKG
Source
1 PACKAGE arh_dqm_srch_pkg AS
2 /*$Header: ARHDSRHS.pls 120.4 2005/06/16 21:11:31 jhuang noship $*/
3
4
5 FUNCTION IsNull
6 -- Return TRUE if the dqm record type argument has all its attributes to NULL
7 ( p_party IN hz_party_search.party_search_rec_type)
8 RETURN BOOLEAN;
9
10 FUNCTION IsNull
11 ( p_party_site IN hz_party_search.party_site_search_rec_type)
12 RETURN BOOLEAN;
13
14 FUNCTION IsNull
15 ( p_contact IN hz_party_search.contact_search_rec_type)
16 RETURN BOOLEAN;
17
18 FUNCTION IsNull
19 ( p_contact_point IN hz_party_search.contact_point_search_rec_type)
20 RETURN BOOLEAN;
21
22 FUNCTION Contact_point_list
23 ( p_contact_point IN hz_party_search.contact_point_search_rec_type,
24 p_default_type IN VARCHAR2 DEFAULT 'PHONE')
25 RETURN hz_party_search.contact_point_list;
26
27 PROCEDURE Exec_Dqm_Api
28 ( p_line_of_business VARCHAR2 DEFAULT NULL,
29 p_local_activity_code VARCHAR2 DEFAULT NULL,
30 p_local_activity_code_type VARCHAR2 DEFAULT NULL,
31 p_local_bus_identifier VARCHAR2 DEFAULT NULL,
32 p_local_bus_iden_type VARCHAR2 DEFAULT NULL,
33 p_max_credit_currency_code VARCHAR2 DEFAULT NULL,
34 p_max_credit_recommendation NUMBER DEFAULT NULL,
35 p_minority_owned_ind VARCHAR2 DEFAULT NULL,
36 p_minority_owned_type VARCHAR2 DEFAULT NULL,
37 p_next_fy_potential_revenue NUMBER DEFAULT NULL,
38 p_oob_ind VARCHAR2 DEFAULT NULL,
39 p_organization_name VARCHAR2 DEFAULT NULL,
40 p_organization_name_phonetic VARCHAR2 DEFAULT NULL,
41 p_organization_type VARCHAR2 DEFAULT NULL,
42 p_parent_sub_ind VARCHAR2 DEFAULT NULL,
43 p_paydex_norm VARCHAR2 DEFAULT NULL,
44 p_paydex_score VARCHAR2 DEFAULT NULL,
45 p_paydex_three_months_ago VARCHAR2 DEFAULT NULL,
46 p_pref_functional_currency VARCHAR2 DEFAULT NULL,
47 p_principal_name VARCHAR2 DEFAULT NULL,
48 p_principal_title VARCHAR2 DEFAULT NULL,
49 p_public_private_ownership_fg VARCHAR2 DEFAULT NULL,
50 p_registration_type VARCHAR2 DEFAULT NULL,
51 p_rent_own_ind VARCHAR2 DEFAULT NULL,
52 p_sic_code VARCHAR2 DEFAULT NULL,
53 p_sic_code_type VARCHAR2 DEFAULT NULL,
54 p_small_bus_ind VARCHAR2 DEFAULT NULL,
55 p_tax_name VARCHAR2 DEFAULT NULL,
56 p_tax_reference VARCHAR2 DEFAULT NULL,
57 p_total_employees_text VARCHAR2 DEFAULT NULL,
58 p_total_emp_est_ind VARCHAR2 DEFAULT NULL,
59 p_total_emp_min_ind VARCHAR2 DEFAULT NULL,
60 p_total_employees_ind VARCHAR2 DEFAULT NULL,
61 p_total_payments NUMBER DEFAULT NULL,
62 p_woman_owned_ind VARCHAR2 DEFAULT NULL,
63 p_year_established NUMBER DEFAULT NULL,
64 p_category_code VARCHAR2 DEFAULT NULL,
65 p_competitor_fg VARCHAR2 DEFAULT NULL,
66 p_do_not_mail_fg VARCHAR2 DEFAULT NULL,
67 p_group_type VARCHAR2 DEFAULT NULL,
68 p_language_name VARCHAR2 DEFAULT NULL,
69 p_party_name VARCHAR2 DEFAULT NULL,
70 p_party_number VARCHAR2 DEFAULT NULL,
71 p_party_type VARCHAR2 DEFAULT NULL,
72 p_reference_use_fg VARCHAR2 DEFAULT NULL,
73 p_salutation VARCHAR2 DEFAULT NULL,
74 p_status VARCHAR2 DEFAULT NULL,
75 p_third_party_fg VARCHAR2 DEFAULT NULL,
76 p_validated_fg VARCHAR2 DEFAULT NULL,
77 p_date_of_birth DATE DEFAULT NULL,
78 p_date_of_death DATE DEFAULT NULL,
79 p_effective_start_date DATE DEFAULT NULL,
80 p_effective_end_date DATE DEFAULT NULL,
81 p_declared_ethnicity VARCHAR2 DEFAULT NULL,
82 p_gender VARCHAR2 DEFAULT NULL,
83 p_head_of_household_fg VARCHAR2 DEFAULT NULL,
84 p_household_income NUMBER DEFAULT NULL,
85 p_household_size NUMBER DEFAULT NULL,
86 p_last_known_gps VARCHAR2 DEFAULT NULL,
87 p_mar_status VARCHAR2 DEFAULT NULL,
88 p_mar_status_effective_date DATE DEFAULT NULL,
89 p_middle_name_phonetic VARCHAR2 DEFAULT NULL,
90 p_personal_income NUMBER DEFAULT NULL,
91 p_person_academic_title VARCHAR2 DEFAULT NULL,
92 p_person_first_name VARCHAR2 DEFAULT NULL,
93 p_person_first_name_phonetic VARCHAR2 DEFAULT NULL,
94 p_person_identifier VARCHAR2 DEFAULT NULL,
95 p_person_iden_type VARCHAR2 DEFAULT NULL,
96 p_person_initials VARCHAR2 DEFAULT NULL,
97 p_person_last_name VARCHAR2 DEFAULT NULL,
98 p_person_last_name_phonetic VARCHAR2 DEFAULT NULL,
99 p_person_middle_name VARCHAR2 DEFAULT NULL,
100 p_person_name VARCHAR2 DEFAULT NULL,
101 p_person_name_phonetic VARCHAR2 DEFAULT NULL,
102 p_person_name_suffix VARCHAR2 DEFAULT NULL,
103 p_person_previous_last_name VARCHAR2 DEFAULT NULL,
104 p_person_pre_name_adjunct VARCHAR2 DEFAULT NULL,
105 p_person_title VARCHAR2 DEFAULT NULL,
106 p_place_of_birth VARCHAR2 DEFAULT NULL,
107 p_all_account_names VARCHAR2 DEFAULT NULL,
108 p_all_account_numbers VARCHAR2 DEFAULT NULL,
109 p_custom_attribute1 VARCHAR2 DEFAULT NULL,
110 p_custom_attribute10 VARCHAR2 DEFAULT NULL,
111 p_custom_attribute11 VARCHAR2 DEFAULT NULL,
112 p_custom_attribute12 VARCHAR2 DEFAULT NULL,
113 p_custom_attribute13 VARCHAR2 DEFAULT NULL,
114 p_custom_attribute14 VARCHAR2 DEFAULT NULL,
115 p_custom_attribute15 VARCHAR2 DEFAULT NULL,
116 p_custom_attribute16 VARCHAR2 DEFAULT NULL,
117 p_custom_attribute17 VARCHAR2 DEFAULT NULL,
118 p_custom_attribute18 VARCHAR2 DEFAULT NULL,
119 p_custom_attribute19 VARCHAR2 DEFAULT NULL,
120 p_custom_attribute2 VARCHAR2 DEFAULT NULL,
121 p_custom_attribute20 VARCHAR2 DEFAULT NULL,
122 p_custom_attribute21 VARCHAR2 DEFAULT NULL,
123 p_custom_attribute22 VARCHAR2 DEFAULT NULL,
124 p_custom_attribute23 VARCHAR2 DEFAULT NULL,
125 p_custom_attribute24 VARCHAR2 DEFAULT NULL,
126 p_custom_attribute25 VARCHAR2 DEFAULT NULL,
127 p_custom_attribute26 VARCHAR2 DEFAULT NULL,
128 p_custom_attribute27 VARCHAR2 DEFAULT NULL,
129 p_custom_attribute28 VARCHAR2 DEFAULT NULL,
130 p_custom_attribute29 VARCHAR2 DEFAULT NULL,
131 p_custom_attribute3 VARCHAR2 DEFAULT NULL,
132 p_custom_attribute30 VARCHAR2 DEFAULT NULL,
133 p_custom_attribute4 VARCHAR2 DEFAULT NULL,
134 p_custom_attribute5 VARCHAR2 DEFAULT NULL,
135 p_custom_attribute6 VARCHAR2 DEFAULT NULL,
136 p_custom_attribute7 VARCHAR2 DEFAULT NULL,
137 p_custom_attribute8 VARCHAR2 DEFAULT NULL,
138 p_custom_attribute9 VARCHAR2 DEFAULT NULL,
139 p_analysis_fy VARCHAR2 DEFAULT NULL,
140 p_avg_high_credit NUMBER DEFAULT NULL,
141 p_best_time_contact_begin DATE DEFAULT NULL,
142 p_best_time_contact_end DATE DEFAULT NULL,
143 p_branch_fg VARCHAR2 DEFAULT NULL,
144 p_business_scope VARCHAR2 DEFAULT NULL,
145 p_ceo_name VARCHAR2 DEFAULT NULL,
146 p_ceo_title VARCHAR2 DEFAULT NULL,
147 p_cong_dist_code VARCHAR2 DEFAULT NULL,
148 p_content_source_number VARCHAR2 DEFAULT NULL,
149 p_content_source_type VARCHAR2 DEFAULT NULL,
150 p_control_yr NUMBER DEFAULT NULL,
151 p_corporation_class VARCHAR2 DEFAULT NULL,
152 p_credit_score VARCHAR2 DEFAULT NULL,
153 p_credit_score_age NUMBER DEFAULT NULL,
154 p_credit_score_class NUMBER DEFAULT NULL,
155 p_credit_score_commentary VARCHAR2 DEFAULT NULL,
156 p_credit_score_commentary10 VARCHAR2 DEFAULT NULL,
157 p_credit_score_commentary2 VARCHAR2 DEFAULT NULL,
158 p_credit_score_commentary3 VARCHAR2 DEFAULT NULL,
159 p_credit_score_commentary4 VARCHAR2 DEFAULT NULL,
160 p_credit_score_commentary5 VARCHAR2 DEFAULT NULL,
161 p_credit_score_commentary6 VARCHAR2 DEFAULT NULL,
162 p_credit_score_commentary7 VARCHAR2 DEFAULT NULL,
163 p_credit_score_commentary8 VARCHAR2 DEFAULT NULL,
164 p_credit_score_commentary9 VARCHAR2 DEFAULT NULL,
165 p_credit_score_date DATE DEFAULT NULL,
166 p_credit_score_incd_default NUMBER DEFAULT NULL,
167 p_credit_score_natl_percentile NUMBER DEFAULT NULL,
168 p_curr_fy_potential_revenue NUMBER DEFAULT NULL,
169 p_db_rating VARCHAR2 DEFAULT NULL,
170 p_debarments_count NUMBER DEFAULT NULL,
171 p_debarments_date DATE DEFAULT NULL,
172 p_debarment_ind VARCHAR2 DEFAULT NULL,
173 p_disadv_8a_ind VARCHAR2 DEFAULT NULL,
174 p_duns_number_c VARCHAR2 DEFAULT NULL,
175 p_employees_total NUMBER DEFAULT NULL,
176 p_emp_at_primary_adr VARCHAR2 DEFAULT NULL,
177 p_emp_at_primary_adr_est_ind VARCHAR2 DEFAULT NULL,
178 p_emp_at_primary_adr_min_ind VARCHAR2 DEFAULT NULL,
179 p_emp_at_primary_adr_text VARCHAR2 DEFAULT NULL,
180 p_enquiry_duns VARCHAR2 DEFAULT NULL,
181 p_export_ind VARCHAR2 DEFAULT NULL,
182 p_failure_score VARCHAR2 DEFAULT NULL,
183 p_failure_score_age NUMBER DEFAULT NULL,
184 p_failure_score_class NUMBER DEFAULT NULL,
185 p_failure_score_commentary VARCHAR2 DEFAULT NULL,
186 p_failure_score_commentary10 VARCHAR2 DEFAULT NULL,
187 p_failure_score_commentary2 VARCHAR2 DEFAULT NULL,
188 p_failure_score_commentary3 VARCHAR2 DEFAULT NULL,
189 p_failure_score_commentary4 VARCHAR2 DEFAULT NULL,
190 p_failure_score_commentary5 VARCHAR2 DEFAULT NULL,
191 p_failure_score_commentary6 VARCHAR2 DEFAULT NULL,
192 p_failure_score_commentary7 VARCHAR2 DEFAULT NULL,
193 p_failure_score_commentary8 VARCHAR2 DEFAULT NULL,
194 p_failure_score_commentary9 VARCHAR2 DEFAULT NULL,
195 p_failure_score_date DATE DEFAULT NULL,
196 p_failure_score_incd_default NUMBER DEFAULT NULL,
197 p_failure_score_override_code VARCHAR2 DEFAULT NULL,
198 p_fiscal_yearend_month VARCHAR2 DEFAULT NULL,
199 p_global_failure_score VARCHAR2 DEFAULT NULL,
200 p_gsa_indicator_fg VARCHAR2 DEFAULT NULL,
201 p_high_credit NUMBER DEFAULT NULL,
202 p_hq_branch_ind VARCHAR2 DEFAULT NULL,
203 p_import_ind VARCHAR2 DEFAULT NULL,
204 p_incorp_year NUMBER DEFAULT NULL,
205 p_internal_fg VARCHAR2 DEFAULT NULL,
206 p_jgzz_fiscal_code VARCHAR2 DEFAULT NULL,
207 p_party_all_names VARCHAR2 DEFAULT NULL,
208 p_known_as VARCHAR2 DEFAULT NULL,
209 p_known_as2 VARCHAR2 DEFAULT NULL,
210 p_known_as3 VARCHAR2 DEFAULT NULL,
211 p_known_as4 VARCHAR2 DEFAULT NULL,
212 p_known_as5 VARCHAR2 DEFAULT NULL,
213 p_labor_surplus_ind VARCHAR2 DEFAULT NULL,
214 p_legal_status VARCHAR2 DEFAULT NULL,
215 --PS
216 s_party_site_number VARCHAR2 DEFAULT NULL,
217 s_custom_attribute16 VARCHAR2 DEFAULT NULL,
218 s_custom_attribute17 VARCHAR2 DEFAULT NULL,
219 s_custom_attribute18 VARCHAR2 DEFAULT NULL,
220 s_custom_attribute19 VARCHAR2 DEFAULT NULL,
221 s_custom_attribute2 VARCHAR2 DEFAULT NULL,
222 s_custom_attribute20 VARCHAR2 DEFAULT NULL,
223 s_custom_attribute21 VARCHAR2 DEFAULT NULL,
224 s_custom_attribute22 VARCHAR2 DEFAULT NULL,
225 s_custom_attribute23 VARCHAR2 DEFAULT NULL,
226 s_custom_attribute24 VARCHAR2 DEFAULT NULL,
227 s_custom_attribute25 VARCHAR2 DEFAULT NULL,
228 s_custom_attribute26 VARCHAR2 DEFAULT NULL,
229 s_custom_attribute27 VARCHAR2 DEFAULT NULL,
230 s_custom_attribute28 VARCHAR2 DEFAULT NULL,
231 s_custom_attribute29 VARCHAR2 DEFAULT NULL,
232 s_custom_attribute3 VARCHAR2 DEFAULT NULL,
233 s_custom_attribute30 VARCHAR2 DEFAULT NULL,
234 s_custom_attribute4 VARCHAR2 DEFAULT NULL,
235 s_custom_attribute5 VARCHAR2 DEFAULT NULL,
236 s_custom_attribute6 VARCHAR2 DEFAULT NULL,
237 s_custom_attribute7 VARCHAR2 DEFAULT NULL,
238 s_custom_attribute8 VARCHAR2 DEFAULT NULL,
239 s_custom_attribute9 VARCHAR2 DEFAULT NULL,
240 s_address1 VARCHAR2 DEFAULT NULL,
241 s_address2 VARCHAR2 DEFAULT NULL,
242 s_address3 VARCHAR2 DEFAULT NULL,
243 s_address4 VARCHAR2 DEFAULT NULL,
244 s_floor VARCHAR2 DEFAULT NULL,
245 s_house_number VARCHAR2 DEFAULT NULL,
246 s_language VARCHAR2 DEFAULT NULL,
247 s_clli_code VARCHAR2 DEFAULT NULL,
248 s_content_source_type VARCHAR2 DEFAULT NULL,
249 s_country VARCHAR2 DEFAULT NULL,
250 s_county VARCHAR2 DEFAULT NULL,
251 s_trailing_directory_code VARCHAR2 DEFAULT NULL,
252 s_validated_fg VARCHAR2 DEFAULT NULL,
253 s_identifying_address_fg VARCHAR2 DEFAULT NULL,
254 s_mailstop VARCHAR2 DEFAULT NULL,
255 s_party_site_name VARCHAR2 DEFAULT NULL,
256 s_address VARCHAR2 DEFAULT NULL,
257 s_custom_attribute1 VARCHAR2 DEFAULT NULL,
258 s_custom_attribute10 VARCHAR2 DEFAULT NULL,
259 s_custom_attribute11 VARCHAR2 DEFAULT NULL,
260 s_custom_attribute12 VARCHAR2 DEFAULT NULL,
261 s_custom_attribute13 VARCHAR2 DEFAULT NULL,
262 s_custom_attribute14 VARCHAR2 DEFAULT NULL,
263 s_custom_attribute15 VARCHAR2 DEFAULT NULL,
264 s_city VARCHAR2 DEFAULT NULL,
265 s_address_effective_date DATE DEFAULT NULL,
266 s_address_expiration_date DATE DEFAULT NULL,
267 s_address_lines_phonetic VARCHAR2 DEFAULT NULL,
268 s_position VARCHAR2 DEFAULT NULL,
269 s_postal_code VARCHAR2 DEFAULT NULL,
270 s_postal_plus4_code VARCHAR2 DEFAULT NULL,
271 s_po_box_number VARCHAR2 DEFAULT NULL,
272 s_province VARCHAR2 DEFAULT NULL,
273 s_sales_tax_geocode VARCHAR2 DEFAULT NULL,
274 s_sales_tax_inside_city_limits VARCHAR2 DEFAULT NULL,
275 s_state VARCHAR2 DEFAULT NULL,
276 s_street VARCHAR2 DEFAULT NULL,
277 s_street_number VARCHAR2 DEFAULT NULL,
278 s_street_suffix VARCHAR2 DEFAULT NULL,
279 s_suite VARCHAR2 DEFAULT NULL,
280 --CT
281 c_directional_fg VARCHAR2 DEFAULT NULL,
282 c_native_language VARCHAR2 DEFAULT NULL,
283 c_other_language_1 VARCHAR2 DEFAULT NULL,
284 c_title VARCHAR2 DEFAULT NULL,
285 c_custom_attribute1 VARCHAR2 DEFAULT NULL,
286 c_custom_attribute10 VARCHAR2 DEFAULT NULL,
287 c_custom_attribute11 VARCHAR2 DEFAULT NULL,
288 c_custom_attribute12 VARCHAR2 DEFAULT NULL,
289 c_custom_attribute13 VARCHAR2 DEFAULT NULL,
290 c_custom_attribute14 VARCHAR2 DEFAULT NULL,
291 c_custom_attribute15 VARCHAR2 DEFAULT NULL,
292 c_custom_attribute16 VARCHAR2 DEFAULT NULL,
293 c_custom_attribute17 VARCHAR2 DEFAULT NULL,
294 c_custom_attribute18 VARCHAR2 DEFAULT NULL,
295 c_custom_attribute19 VARCHAR2 DEFAULT NULL,
296 c_custom_attribute2 VARCHAR2 DEFAULT NULL,
297 c_custom_attribute20 VARCHAR2 DEFAULT NULL,
301 c_custom_attribute24 VARCHAR2 DEFAULT NULL,
298 c_custom_attribute21 VARCHAR2 DEFAULT NULL,
299 c_custom_attribute22 VARCHAR2 DEFAULT NULL,
300 c_custom_attribute23 VARCHAR2 DEFAULT NULL,
302 c_custom_attribute25 VARCHAR2 DEFAULT NULL,
303 c_custom_attribute26 VARCHAR2 DEFAULT NULL,
304 c_custom_attribute27 VARCHAR2 DEFAULT NULL,
305 c_custom_attribute28 VARCHAR2 DEFAULT NULL,
306 c_custom_attribute29 VARCHAR2 DEFAULT NULL,
307 c_custom_attribute3 VARCHAR2 DEFAULT NULL,
308 c_custom_attribute30 VARCHAR2 DEFAULT NULL,
309 c_custom_attribute4 VARCHAR2 DEFAULT NULL,
310 c_custom_attribute5 VARCHAR2 DEFAULT NULL,
311 c_custom_attribute6 VARCHAR2 DEFAULT NULL,
312 c_mail_stop VARCHAR2 DEFAULT NULL,
313 c_best_time_contact_end DATE DEFAULT NULL,
314 c_job_title_code VARCHAR2 DEFAULT NULL,
315 c_relationship_type VARCHAR2 DEFAULT NULL,
316 c_other_language_2 VARCHAR2 DEFAULT NULL,
317 c_rank VARCHAR2 DEFAULT NULL,
318 c_reference_use_fg VARCHAR2 DEFAULT NULL,
319 c_date_of_birth DATE DEFAULT NULL,
320 c_date_of_death DATE DEFAULT NULL,
321 c_jgzz_fiscal_code VARCHAR2 DEFAULT NULL,
322 c_known_as VARCHAR2 DEFAULT NULL,
323 c_person_academic_title VARCHAR2 DEFAULT NULL,
324 c_person_first_name VARCHAR2 DEFAULT NULL,
325 c_person_first_name_phonetic VARCHAR2 DEFAULT NULL,
326 c_person_identifier VARCHAR2 DEFAULT NULL,
327 c_person_iden_type VARCHAR2 DEFAULT NULL,
328 c_person_initials VARCHAR2 DEFAULT NULL,
329 c_person_last_name VARCHAR2 DEFAULT NULL,
330 c_person_last_name_phonetic VARCHAR2 DEFAULT NULL,
331 c_person_middle_name VARCHAR2 DEFAULT NULL,
332 c_person_name VARCHAR2 DEFAULT NULL,
333 c_person_name_phonetic VARCHAR2 DEFAULT NULL,
334 c_person_name_suffix VARCHAR2 DEFAULT NULL,
335 c_person_previous_last_name VARCHAR2 DEFAULT NULL,
336 c_person_title VARCHAR2 DEFAULT NULL,
337 c_place_of_birth VARCHAR2 DEFAULT NULL,
338 c_tax_name VARCHAR2 DEFAULT NULL,
339 c_tax_reference VARCHAR2 DEFAULT NULL,
340 c_content_source_type VARCHAR2 DEFAULT NULL,
341 c_job_title VARCHAR2 DEFAULT NULL,
342 c_custom_attribute7 VARCHAR2 DEFAULT NULL,
343 c_custom_attribute8 VARCHAR2 DEFAULT NULL,
344 c_custom_attribute9 VARCHAR2 DEFAULT NULL,
345 c_contact_number VARCHAR2 DEFAULT NULL,
346 c_contact_name VARCHAR2 DEFAULT NULL,
347 c_decision_maker_fg VARCHAR2 DEFAULT NULL,
348 c_best_time_contact_begin DATE DEFAULT NULL,
349 --CPT
350 t_phone_line_type VARCHAR2 DEFAULT NULL,
351 t_phone_number VARCHAR2 DEFAULT NULL,
352 t_primary_fg VARCHAR2 DEFAULT NULL,
353 t_raw_phone_number VARCHAR2 DEFAULT NULL,
354 t_telephone_type VARCHAR2 DEFAULT NULL,
355 t_telex_number VARCHAR2 DEFAULT NULL,
356 t_time_zone NUMBER DEFAULT NULL,
357 t_url VARCHAR2 DEFAULT NULL,
358 t_web_type VARCHAR2 DEFAULT NULL,
359 t_contact_point_type VARCHAR2 DEFAULT NULL,
360 t_custom_attribute1 VARCHAR2 DEFAULT NULL,
361 t_custom_attribute10 VARCHAR2 DEFAULT NULL,
362 t_edi_tp_header_id NUMBER DEFAULT NULL,
363 t_custom_attribute5 VARCHAR2 DEFAULT NULL,
364 t_custom_attribute6 VARCHAR2 DEFAULT NULL,
365 t_custom_attribute4 VARCHAR2 DEFAULT NULL,
366 t_edi_remittance_instruction VARCHAR2 DEFAULT NULL,
367 t_edi_transaction_handling VARCHAR2 DEFAULT NULL,
368 t_custom_attribute8 VARCHAR2 DEFAULT NULL,
369 t_custom_attribute9 VARCHAR2 DEFAULT NULL,
370 t_content_source_type VARCHAR2 DEFAULT NULL,
371 t_edi_ece_tp_location_code VARCHAR2 DEFAULT NULL,
372 t_edi_id_number VARCHAR2 DEFAULT NULL,
373 t_edi_payment_format VARCHAR2 DEFAULT NULL,
374 t_custom_attribute12 VARCHAR2 DEFAULT NULL,
375 t_custom_attribute13 VARCHAR2 DEFAULT NULL,
376 t_custom_attribute14 VARCHAR2 DEFAULT NULL,
377 t_custom_attribute15 VARCHAR2 DEFAULT NULL,
378 t_custom_attribute16 VARCHAR2 DEFAULT NULL,
379 t_custom_attribute17 VARCHAR2 DEFAULT NULL,
380 t_custom_attribute18 VARCHAR2 DEFAULT NULL,
381 t_custom_attribute19 VARCHAR2 DEFAULT NULL,
382 t_custom_attribute2 VARCHAR2 DEFAULT NULL,
383 t_custom_attribute20 VARCHAR2 DEFAULT NULL,
384 t_custom_attribute21 VARCHAR2 DEFAULT NULL,
385 t_custom_attribute22 VARCHAR2 DEFAULT NULL,
386 t_custom_attribute23 VARCHAR2 DEFAULT NULL,
387 t_custom_attribute24 VARCHAR2 DEFAULT NULL,
388 t_custom_attribute25 VARCHAR2 DEFAULT NULL,
389 t_custom_attribute26 VARCHAR2 DEFAULT NULL,
390 t_custom_attribute27 VARCHAR2 DEFAULT NULL,
391 t_custom_attribute28 VARCHAR2 DEFAULT NULL,
392 t_custom_attribute29 VARCHAR2 DEFAULT NULL,
396 t_email_address VARCHAR2 DEFAULT NULL,
393 t_custom_attribute3 VARCHAR2 DEFAULT NULL,
394 t_custom_attribute30 VARCHAR2 DEFAULT NULL,
395 t_custom_attribute11 VARCHAR2 DEFAULT NULL,
397 t_email_format VARCHAR2 DEFAULT NULL,
398 t_flex_format_phone_number VARCHAR2 DEFAULT NULL,
399 t_last_contact_dt_time DATE DEFAULT NULL,
400 t_phone_area_code VARCHAR2 DEFAULT NULL,
401 t_phone_calling_calendar VARCHAR2 DEFAULT NULL,
402 t_phone_country_code VARCHAR2 DEFAULT NULL,
403 t_phone_extension VARCHAR2 DEFAULT NULL,
404 t_edi_remittance_method VARCHAR2 DEFAULT NULL,
405 t_custom_attribute7 VARCHAR2 DEFAULT NULL,
406 t_edi_payment_method VARCHAR2 DEFAULT NULL,
407 --other parameter
408 p_restrict_sql VARCHAR2 DEFAULT NULL,
409 p_cur_all VARCHAR2 DEFAULT 'ALL',
410 x_status VARCHAR2 DEFAULT 'ALL',
411 x_rule_id IN OUT NOCOPY NUMBER,
412 x_search_ctx_id IN OUT NOCOPY NUMBER,
413 x_num_matches IN OUT NOCOPY NUMBER,
414 x_msg_count IN OUT NOCOPY NUMBER,
415 x_msg_data IN OUT NOCOPY VARCHAR2,
416 x_return_status IN OUT NOCOPY VARCHAR2);
417
418 PROCEDURE Exec_Get_Matching_Sites
419 (
420 --PS
421 s_party_site_number VARCHAR2 DEFAULT NULL,
422 s_custom_attribute16 VARCHAR2 DEFAULT NULL,
423 s_custom_attribute17 VARCHAR2 DEFAULT NULL,
424 s_custom_attribute18 VARCHAR2 DEFAULT NULL,
425 s_custom_attribute19 VARCHAR2 DEFAULT NULL,
426 s_custom_attribute2 VARCHAR2 DEFAULT NULL,
427 s_custom_attribute20 VARCHAR2 DEFAULT NULL,
428 s_custom_attribute21 VARCHAR2 DEFAULT NULL,
429 s_custom_attribute22 VARCHAR2 DEFAULT NULL,
430 s_custom_attribute23 VARCHAR2 DEFAULT NULL,
431 s_custom_attribute24 VARCHAR2 DEFAULT NULL,
432 s_custom_attribute25 VARCHAR2 DEFAULT NULL,
433 s_custom_attribute26 VARCHAR2 DEFAULT NULL,
434 s_custom_attribute27 VARCHAR2 DEFAULT NULL,
435 s_custom_attribute28 VARCHAR2 DEFAULT NULL,
436 s_custom_attribute29 VARCHAR2 DEFAULT NULL,
437 s_custom_attribute3 VARCHAR2 DEFAULT NULL,
438 s_custom_attribute30 VARCHAR2 DEFAULT NULL,
439 s_custom_attribute4 VARCHAR2 DEFAULT NULL,
440 s_custom_attribute5 VARCHAR2 DEFAULT NULL,
441 s_custom_attribute6 VARCHAR2 DEFAULT NULL,
442 s_custom_attribute7 VARCHAR2 DEFAULT NULL,
443 s_custom_attribute8 VARCHAR2 DEFAULT NULL,
444 s_custom_attribute9 VARCHAR2 DEFAULT NULL,
445 s_address1 VARCHAR2 DEFAULT NULL,
446 s_address2 VARCHAR2 DEFAULT NULL,
447 s_address3 VARCHAR2 DEFAULT NULL,
448 s_address4 VARCHAR2 DEFAULT NULL,
449 s_floor VARCHAR2 DEFAULT NULL,
450 s_house_number VARCHAR2 DEFAULT NULL,
451 s_language VARCHAR2 DEFAULT NULL,
452 s_clli_code VARCHAR2 DEFAULT NULL,
453 s_content_source_type VARCHAR2 DEFAULT NULL,
454 s_country VARCHAR2 DEFAULT NULL,
455 s_county VARCHAR2 DEFAULT NULL,
456 s_trailing_directory_code VARCHAR2 DEFAULT NULL,
457 s_validated_fg VARCHAR2 DEFAULT NULL,
458 s_identifying_address_fg VARCHAR2 DEFAULT NULL,
459 s_mailstop VARCHAR2 DEFAULT NULL,
460 s_party_site_name VARCHAR2 DEFAULT NULL,
461 s_address VARCHAR2 DEFAULT NULL,
462 s_custom_attribute1 VARCHAR2 DEFAULT NULL,
463 s_custom_attribute10 VARCHAR2 DEFAULT NULL,
464 s_custom_attribute11 VARCHAR2 DEFAULT NULL,
465 s_custom_attribute12 VARCHAR2 DEFAULT NULL,
466 s_custom_attribute13 VARCHAR2 DEFAULT NULL,
467 s_custom_attribute14 VARCHAR2 DEFAULT NULL,
468 s_custom_attribute15 VARCHAR2 DEFAULT NULL,
469 s_city VARCHAR2 DEFAULT NULL,
470 s_address_effective_date DATE DEFAULT NULL,
471 s_address_expiration_date DATE DEFAULT NULL,
472 s_address_lines_phonetic VARCHAR2 DEFAULT NULL,
473 s_position VARCHAR2 DEFAULT NULL,
474 s_postal_code VARCHAR2 DEFAULT NULL,
475 s_postal_plus4_code VARCHAR2 DEFAULT NULL,
476 s_po_box_number VARCHAR2 DEFAULT NULL,
477 s_province VARCHAR2 DEFAULT NULL,
478 s_sales_tax_geocode VARCHAR2 DEFAULT NULL,
479 s_sales_tax_inside_city_limits VARCHAR2 DEFAULT NULL,
480 s_state VARCHAR2 DEFAULT NULL,
481 s_street VARCHAR2 DEFAULT NULL,
482 s_street_number VARCHAR2 DEFAULT NULL,
483 s_street_suffix VARCHAR2 DEFAULT NULL,
484 s_suite VARCHAR2 DEFAULT NULL,
485 --CT
486 c_directional_fg VARCHAR2 DEFAULT NULL,
487 c_native_language VARCHAR2 DEFAULT NULL,
488 c_other_language_1 VARCHAR2 DEFAULT NULL,
489 c_title VARCHAR2 DEFAULT NULL,
490 c_custom_attribute1 VARCHAR2 DEFAULT NULL,
496 c_custom_attribute15 VARCHAR2 DEFAULT NULL,
491 c_custom_attribute10 VARCHAR2 DEFAULT NULL,
492 c_custom_attribute11 VARCHAR2 DEFAULT NULL,
493 c_custom_attribute12 VARCHAR2 DEFAULT NULL,
494 c_custom_attribute13 VARCHAR2 DEFAULT NULL,
495 c_custom_attribute14 VARCHAR2 DEFAULT NULL,
497 c_custom_attribute16 VARCHAR2 DEFAULT NULL,
498 c_custom_attribute17 VARCHAR2 DEFAULT NULL,
499 c_custom_attribute18 VARCHAR2 DEFAULT NULL,
500 c_custom_attribute19 VARCHAR2 DEFAULT NULL,
501 c_custom_attribute2 VARCHAR2 DEFAULT NULL,
502 c_custom_attribute20 VARCHAR2 DEFAULT NULL,
503 c_custom_attribute21 VARCHAR2 DEFAULT NULL,
504 c_custom_attribute22 VARCHAR2 DEFAULT NULL,
505 c_custom_attribute23 VARCHAR2 DEFAULT NULL,
506 c_custom_attribute24 VARCHAR2 DEFAULT NULL,
507 c_custom_attribute25 VARCHAR2 DEFAULT NULL,
508 c_custom_attribute26 VARCHAR2 DEFAULT NULL,
509 c_custom_attribute27 VARCHAR2 DEFAULT NULL,
510 c_custom_attribute28 VARCHAR2 DEFAULT NULL,
511 c_custom_attribute29 VARCHAR2 DEFAULT NULL,
512 c_custom_attribute3 VARCHAR2 DEFAULT NULL,
513 c_custom_attribute30 VARCHAR2 DEFAULT NULL,
514 c_custom_attribute4 VARCHAR2 DEFAULT NULL,
515 c_custom_attribute5 VARCHAR2 DEFAULT NULL,
516 c_custom_attribute6 VARCHAR2 DEFAULT NULL,
517 c_mail_stop VARCHAR2 DEFAULT NULL,
518 c_best_time_contact_end DATE DEFAULT NULL,
519 c_job_title_code VARCHAR2 DEFAULT NULL,
520 c_relationship_type VARCHAR2 DEFAULT NULL,
521 c_other_language_2 VARCHAR2 DEFAULT NULL,
522 c_rank VARCHAR2 DEFAULT NULL,
523 c_reference_use_fg VARCHAR2 DEFAULT NULL,
524 c_date_of_birth DATE DEFAULT NULL,
525 c_date_of_death DATE DEFAULT NULL,
526 c_jgzz_fiscal_code VARCHAR2 DEFAULT NULL,
527 c_known_as VARCHAR2 DEFAULT NULL,
528 c_person_academic_title VARCHAR2 DEFAULT NULL,
529 c_person_first_name VARCHAR2 DEFAULT NULL,
530 c_person_first_name_phonetic VARCHAR2 DEFAULT NULL,
531 c_person_identifier VARCHAR2 DEFAULT NULL,
532 c_person_iden_type VARCHAR2 DEFAULT NULL,
533 c_person_initials VARCHAR2 DEFAULT NULL,
534 c_person_last_name VARCHAR2 DEFAULT NULL,
535 c_person_last_name_phonetic VARCHAR2 DEFAULT NULL,
536 c_person_middle_name VARCHAR2 DEFAULT NULL,
537 c_person_name VARCHAR2 DEFAULT NULL,
538 c_person_name_phonetic VARCHAR2 DEFAULT NULL,
539 c_person_name_suffix VARCHAR2 DEFAULT NULL,
540 c_person_previous_last_name VARCHAR2 DEFAULT NULL,
541 c_person_title VARCHAR2 DEFAULT NULL,
542 c_place_of_birth VARCHAR2 DEFAULT NULL,
543 c_tax_name VARCHAR2 DEFAULT NULL,
544 c_tax_reference VARCHAR2 DEFAULT NULL,
545 c_content_source_type VARCHAR2 DEFAULT NULL,
546 c_job_title VARCHAR2 DEFAULT NULL,
547 c_custom_attribute7 VARCHAR2 DEFAULT NULL,
548 c_custom_attribute8 VARCHAR2 DEFAULT NULL,
549 c_custom_attribute9 VARCHAR2 DEFAULT NULL,
550 c_contact_number VARCHAR2 DEFAULT NULL,
551 c_contact_name VARCHAR2 DEFAULT NULL,
552 c_decision_maker_fg VARCHAR2 DEFAULT NULL,
553 c_best_time_contact_begin DATE DEFAULT NULL,
554 --CPT
555 t_phone_line_type VARCHAR2 DEFAULT NULL,
556 t_phone_number VARCHAR2 DEFAULT NULL,
557 t_primary_fg VARCHAR2 DEFAULT NULL,
558 t_raw_phone_number VARCHAR2 DEFAULT NULL,
559 t_telephone_type VARCHAR2 DEFAULT NULL,
560 t_telex_number VARCHAR2 DEFAULT NULL,
561 t_time_zone NUMBER DEFAULT NULL,
562 t_url VARCHAR2 DEFAULT NULL,
563 t_web_type VARCHAR2 DEFAULT NULL,
564 t_contact_point_type VARCHAR2 DEFAULT NULL,
565 t_custom_attribute1 VARCHAR2 DEFAULT NULL,
566 t_custom_attribute10 VARCHAR2 DEFAULT NULL,
567 t_edi_tp_header_id NUMBER DEFAULT NULL,
568 t_custom_attribute5 VARCHAR2 DEFAULT NULL,
569 t_custom_attribute6 VARCHAR2 DEFAULT NULL,
570 t_custom_attribute4 VARCHAR2 DEFAULT NULL,
571 t_edi_remittance_instruction VARCHAR2 DEFAULT NULL,
572 t_edi_transaction_handling VARCHAR2 DEFAULT NULL,
573 t_custom_attribute8 VARCHAR2 DEFAULT NULL,
574 t_custom_attribute9 VARCHAR2 DEFAULT NULL,
575 t_content_source_type VARCHAR2 DEFAULT NULL,
576 t_edi_ece_tp_location_code VARCHAR2 DEFAULT NULL,
577 t_edi_id_number VARCHAR2 DEFAULT NULL,
578 t_edi_payment_format VARCHAR2 DEFAULT NULL,
579 t_custom_attribute12 VARCHAR2 DEFAULT NULL,
580 t_custom_attribute13 VARCHAR2 DEFAULT NULL,
581 t_custom_attribute14 VARCHAR2 DEFAULT NULL,
582 t_custom_attribute15 VARCHAR2 DEFAULT NULL,
583 t_custom_attribute16 VARCHAR2 DEFAULT NULL,
584 t_custom_attribute17 VARCHAR2 DEFAULT NULL,
585 t_custom_attribute18 VARCHAR2 DEFAULT NULL,
586 t_custom_attribute19 VARCHAR2 DEFAULT NULL,
587 t_custom_attribute2 VARCHAR2 DEFAULT NULL,
588 t_custom_attribute20 VARCHAR2 DEFAULT NULL,
589 t_custom_attribute21 VARCHAR2 DEFAULT NULL,
590 t_custom_attribute22 VARCHAR2 DEFAULT NULL,
591 t_custom_attribute23 VARCHAR2 DEFAULT NULL,
592 t_custom_attribute24 VARCHAR2 DEFAULT NULL,
596 t_custom_attribute28 VARCHAR2 DEFAULT NULL,
593 t_custom_attribute25 VARCHAR2 DEFAULT NULL,
594 t_custom_attribute26 VARCHAR2 DEFAULT NULL,
595 t_custom_attribute27 VARCHAR2 DEFAULT NULL,
597 t_custom_attribute29 VARCHAR2 DEFAULT NULL,
598 t_custom_attribute3 VARCHAR2 DEFAULT NULL,
599 t_custom_attribute30 VARCHAR2 DEFAULT NULL,
600 t_custom_attribute11 VARCHAR2 DEFAULT NULL,
601 t_email_address VARCHAR2 DEFAULT NULL,
602 t_email_format VARCHAR2 DEFAULT NULL,
603 t_flex_format_phone_number VARCHAR2 DEFAULT NULL,
604 t_last_contact_dt_time DATE DEFAULT NULL,
605 t_phone_area_code VARCHAR2 DEFAULT NULL,
606 t_phone_calling_calendar VARCHAR2 DEFAULT NULL,
607 t_phone_country_code VARCHAR2 DEFAULT NULL,
608 t_phone_extension VARCHAR2 DEFAULT NULL,
609 t_edi_remittance_method VARCHAR2 DEFAULT NULL,
610 t_custom_attribute7 VARCHAR2 DEFAULT NULL,
611 t_edi_payment_method VARCHAR2 DEFAULT NULL,
612 --other parameter
613 p_restrict_sql VARCHAR2 DEFAULT NULL,
614 p_party_id VARCHAR2 DEFAULT NULL,
615 p_cur_all VARCHAR2 DEFAULT 'ALL',
616 x_status VARCHAR2 DEFAULT 'ALL',
617 x_rule_id IN OUT NOCOPY NUMBER,
618 x_search_ctx_id IN OUT NOCOPY NUMBER,
619 x_num_matches IN OUT NOCOPY NUMBER,
620 x_msg_count IN OUT NOCOPY NUMBER,
621 x_msg_data IN OUT NOCOPY VARCHAR2,
622 x_return_status IN OUT NOCOPY VARCHAR2);
623
624 END;