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