1 PACKAGE HZ_organization_profiles_pkg AS
2 /*$Header: ARHORGTS.pls 120.4 2005/07/26 18:55:31 jhuang ship $ */
3
4 PROCEDURE insert_row (
5 x_rowid OUT NOCOPY ROWID,
6 x_organization_profile_id IN OUT NOCOPY NUMBER,
7 x_party_id IN NUMBER,
8 x_organization_name IN VARCHAR2,
9 x_attribute_category IN VARCHAR2,
10 x_attribute1 IN VARCHAR2,
11 x_attribute2 IN VARCHAR2,
12 x_attribute3 IN VARCHAR2,
13 x_attribute4 IN VARCHAR2,
14 x_attribute5 IN VARCHAR2,
15 x_attribute6 IN VARCHAR2,
16 x_attribute7 IN VARCHAR2,
17 x_attribute8 IN VARCHAR2,
18 x_attribute9 IN VARCHAR2,
19 x_attribute10 IN VARCHAR2,
20 x_attribute11 IN VARCHAR2,
21 x_attribute12 IN VARCHAR2,
22 x_attribute13 IN VARCHAR2,
23 x_attribute14 IN VARCHAR2,
24 x_attribute15 IN VARCHAR2,
25 x_attribute16 IN VARCHAR2,
26 x_attribute17 IN VARCHAR2,
27 x_attribute18 IN VARCHAR2,
28 x_attribute19 IN VARCHAR2,
29 x_attribute20 IN VARCHAR2,
30 x_enquiry_duns IN VARCHAR2,
31 x_ceo_name IN VARCHAR2,
32 x_ceo_title IN VARCHAR2,
33 x_principal_name IN VARCHAR2,
34 x_principal_title IN VARCHAR2,
35 x_legal_status IN VARCHAR2,
36 x_control_yr IN NUMBER,
37 x_employees_total IN NUMBER,
38 x_hq_branch_ind IN VARCHAR2,
39 x_branch_flag IN VARCHAR2,
40 x_oob_ind IN VARCHAR2,
41 x_line_of_business IN VARCHAR2,
42 x_cong_dist_code IN VARCHAR2,
43 x_sic_code IN VARCHAR2,
44 x_import_ind IN VARCHAR2,
45 x_export_ind IN VARCHAR2,
46 x_labor_surplus_ind IN VARCHAR2,
47 x_debarment_ind IN VARCHAR2,
48 x_minority_owned_ind IN VARCHAR2,
49 x_minority_owned_type IN VARCHAR2,
50 x_woman_owned_ind IN VARCHAR2,
51 x_disadv_8a_ind IN VARCHAR2,
52 x_small_bus_ind IN VARCHAR2,
53 x_rent_own_ind IN VARCHAR2,
54 x_debarments_count IN NUMBER,
55 x_debarments_date IN DATE,
56 x_failure_score IN VARCHAR2,
57 x_failure_score_override_code IN VARCHAR2,
58 x_failure_score_commentary IN VARCHAR2,
59 x_global_failure_score IN VARCHAR2,
60 x_db_rating IN VARCHAR2,
61 x_credit_score IN VARCHAR2,
62 x_credit_score_commentary IN VARCHAR2,
63 x_paydex_score IN VARCHAR2,
64 x_paydex_three_months_ago IN VARCHAR2,
65 x_paydex_norm IN VARCHAR2,
66 x_best_time_contact_begin IN DATE,
67 x_best_time_contact_end IN DATE,
68 x_organization_name_phonetic IN VARCHAR2,
69 x_tax_reference IN VARCHAR2,
70 x_gsa_indicator_flag IN VARCHAR2,
71 x_jgzz_fiscal_code IN VARCHAR2,
72 x_analysis_fy IN VARCHAR2,
73 x_fiscal_yearend_month IN VARCHAR2,
74 x_curr_fy_potential_revenue IN NUMBER,
75 x_next_fy_potential_revenue IN NUMBER,
76 x_year_established IN NUMBER,
77 x_mission_statement IN VARCHAR2,
78 x_organization_type IN VARCHAR2,
79 x_business_scope IN VARCHAR2,
80 x_corporation_class IN VARCHAR2,
81 x_known_as IN VARCHAR2,
82 x_local_bus_iden_type IN VARCHAR2,
83 x_local_bus_identifier IN VARCHAR2,
84 x_pref_functional_currency IN VARCHAR2,
85 x_registration_type IN VARCHAR2,
86 x_total_employees_text IN VARCHAR2,
87 x_total_employees_ind IN VARCHAR2,
88 x_total_emp_est_ind IN VARCHAR2,
89 x_total_emp_min_ind IN VARCHAR2,
90 x_parent_sub_ind IN VARCHAR2,
91 x_incorp_year IN NUMBER,
92 x_content_source_type IN VARCHAR2,
93 x_content_source_number IN VARCHAR2,
94 x_effective_start_date IN DATE,
95 x_effective_end_date IN DATE,
96 x_sic_code_type IN VARCHAR2,
97 x_public_private_ownership IN VARCHAR2,
98 x_local_activity_code_type IN VARCHAR2,
99 x_local_activity_code IN VARCHAR2,
100 x_emp_at_primary_adr IN VARCHAR2,
101 x_emp_at_primary_adr_text IN VARCHAR2,
102 x_emp_at_primary_adr_est_ind IN VARCHAR2,
103 x_emp_at_primary_adr_min_ind IN VARCHAR2,
104 x_internal_flag IN VARCHAR2,
105 x_high_credit IN NUMBER,
106 x_avg_high_credit IN NUMBER,
107 x_total_payments IN NUMBER,
108 x_known_as2 IN VARCHAR2,
109 x_known_as3 IN VARCHAR2,
110 x_known_as4 IN VARCHAR2,
111 x_known_as5 IN VARCHAR2,
112 x_credit_score_class IN NUMBER,
113 x_credit_score_natl_percentile IN NUMBER,
114 x_credit_score_incd_default IN NUMBER,
115 x_credit_score_age IN NUMBER,
116 x_credit_score_date IN DATE,
117 x_failure_score_class IN NUMBER,
118 x_failure_score_incd_default IN NUMBER,
119 x_failure_score_age IN NUMBER,
120 x_failure_score_date IN DATE,
121 x_failure_score_commentary2 IN VARCHAR2,
122 x_failure_score_commentary3 IN VARCHAR2,
123 x_failure_score_commentary4 IN VARCHAR2,
124 x_failure_score_commentary5 IN VARCHAR2,
125 x_failure_score_commentary6 IN VARCHAR2,
126 x_failure_score_commentary7 IN VARCHAR2,
127 x_failure_score_commentary8 IN VARCHAR2,
128 x_failure_score_commentary9 IN VARCHAR2,
129 x_failure_score_commentary10 IN VARCHAR2,
130 x_credit_score_commentary2 IN VARCHAR2,
131 x_credit_score_commentary3 IN VARCHAR2,
132 x_credit_score_commentary4 IN VARCHAR2,
133 x_credit_score_commentary5 IN VARCHAR2,
134 x_credit_score_commentary6 IN VARCHAR2,
135 x_credit_score_commentary7 IN VARCHAR2,
136 x_credit_score_commentary8 IN VARCHAR2,
137 x_credit_score_commentary9 IN VARCHAR2,
138 x_credit_score_commentary10 IN VARCHAR2,
139 x_maximum_credit_recomm IN NUMBER,
140 x_maximum_credit_currency_code IN VARCHAR2,
141 x_displayed_duns_party_id IN NUMBER,
142 x_failure_score_natnl_perc IN NUMBER,
143 x_duns_number_c IN VARCHAR2,
144 x_bank_or_branch_number IN VARCHAR2 := fnd_api.g_miss_char,
145 x_bank_code IN VARCHAR2 := fnd_api.g_miss_char,
146 x_branch_code IN VARCHAR2 := fnd_api.g_miss_char,
147 x_object_version_number IN NUMBER,
148 x_created_by_module IN VARCHAR2,
149 x_application_id IN NUMBER,
150 x_do_not_confuse_with IN VARCHAR2 := NULL,
151 x_actual_content_source IN VARCHAR2,
152 x_version_number IN NUMBER DEFAULT 1,
153 x_home_country IN VARCHAR2 DEFAULT NULL
154 );
155
156 PROCEDURE update_row (
157 x_rowid IN OUT NOCOPY VARCHAR2,
158 x_organization_profile_id IN NUMBER,
159 x_party_id IN NUMBER,
160 x_organization_name IN VARCHAR2,
161 x_attribute_category IN VARCHAR2,
162 x_attribute1 IN VARCHAR2,
163 x_attribute2 IN VARCHAR2,
164 x_attribute3 IN VARCHAR2,
165 x_attribute4 IN VARCHAR2,
166 x_attribute5 IN VARCHAR2,
167 x_attribute6 IN VARCHAR2,
168 x_attribute7 IN VARCHAR2,
169 x_attribute8 IN VARCHAR2,
170 x_attribute9 IN VARCHAR2,
171 x_attribute10 IN VARCHAR2,
172 x_attribute11 IN VARCHAR2,
173 x_attribute12 IN VARCHAR2,
174 x_attribute13 IN VARCHAR2,
175 x_attribute14 IN VARCHAR2,
176 x_attribute15 IN VARCHAR2,
177 x_attribute16 IN VARCHAR2,
178 x_attribute17 IN VARCHAR2,
179 x_attribute18 IN VARCHAR2,
180 x_attribute19 IN VARCHAR2,
181 x_attribute20 IN VARCHAR2,
182 x_enquiry_duns IN VARCHAR2,
183 x_ceo_name IN VARCHAR2,
184 x_ceo_title IN VARCHAR2,
185 x_principal_name IN VARCHAR2,
186 x_principal_title IN VARCHAR2,
187 x_legal_status IN VARCHAR2,
188 x_control_yr IN NUMBER,
189 x_employees_total IN NUMBER,
190 x_hq_branch_ind IN VARCHAR2,
191 x_branch_flag IN VARCHAR2,
192 x_oob_ind IN VARCHAR2,
193 x_line_of_business IN VARCHAR2,
194 x_cong_dist_code IN VARCHAR2,
195 x_sic_code IN VARCHAR2,
196 x_import_ind IN VARCHAR2,
197 x_export_ind IN VARCHAR2,
198 x_labor_surplus_ind IN VARCHAR2,
199 x_debarment_ind IN VARCHAR2,
200 x_minority_owned_ind IN VARCHAR2,
201 x_minority_owned_type IN VARCHAR2,
202 x_woman_owned_ind IN VARCHAR2,
203 x_disadv_8a_ind IN VARCHAR2,
204 x_small_bus_ind IN VARCHAR2,
205 x_rent_own_ind IN VARCHAR2,
206 x_debarments_count IN NUMBER,
207 x_debarments_date IN DATE,
208 x_failure_score IN VARCHAR2,
209 x_failure_score_override_code IN VARCHAR2,
210 x_failure_score_commentary IN VARCHAR2,
211 x_global_failure_score IN VARCHAR2,
212 x_db_rating IN VARCHAR2,
213 x_credit_score IN VARCHAR2,
214 x_credit_score_commentary IN VARCHAR2,
215 x_paydex_score IN VARCHAR2,
216 x_paydex_three_months_ago IN VARCHAR2,
217 x_paydex_norm IN VARCHAR2,
218 x_best_time_contact_begin IN DATE,
219 x_best_time_contact_end IN DATE,
220 x_organization_name_phonetic IN VARCHAR2,
221 x_tax_reference IN VARCHAR2,
222 x_gsa_indicator_flag IN VARCHAR2,
223 x_jgzz_fiscal_code IN VARCHAR2,
224 x_analysis_fy IN VARCHAR2,
225 x_fiscal_yearend_month IN VARCHAR2,
226 x_curr_fy_potential_revenue IN NUMBER,
227 x_next_fy_potential_revenue IN NUMBER,
228 x_year_established IN NUMBER,
229 x_mission_statement IN VARCHAR2,
230 x_organization_type IN VARCHAR2,
231 x_business_scope IN VARCHAR2,
232 x_corporation_class IN VARCHAR2,
233 x_known_as IN VARCHAR2,
234 x_local_bus_iden_type IN VARCHAR2,
235 x_local_bus_identifier IN VARCHAR2,
236 x_pref_functional_currency IN VARCHAR2,
237 x_registration_type IN VARCHAR2,
238 x_total_employees_text IN VARCHAR2,
239 x_total_employees_ind IN VARCHAR2,
240 x_total_emp_est_ind IN VARCHAR2,
241 x_total_emp_min_ind IN VARCHAR2,
242 x_parent_sub_ind IN VARCHAR2,
243 x_incorp_year IN NUMBER,
244 x_content_source_type IN VARCHAR2,
245 x_content_source_number IN VARCHAR2,
246 x_effective_start_date IN DATE,
247 x_effective_end_date IN DATE,
248 x_sic_code_type IN VARCHAR2,
249 x_public_private_ownership IN VARCHAR2,
250 x_local_activity_code_type IN VARCHAR2,
251 x_local_activity_code IN VARCHAR2,
252 x_emp_at_primary_adr IN VARCHAR2,
253 x_emp_at_primary_adr_text IN VARCHAR2,
254 x_emp_at_primary_adr_est_ind IN VARCHAR2,
255 x_emp_at_primary_adr_min_ind IN VARCHAR2,
256 x_internal_flag IN VARCHAR2,
257 x_high_credit IN NUMBER,
258 x_avg_high_credit IN NUMBER,
259 x_total_payments IN NUMBER,
260 x_known_as2 IN VARCHAR2,
261 x_known_as3 IN VARCHAR2,
262 x_known_as4 IN VARCHAR2,
263 x_known_as5 IN VARCHAR2,
264 x_credit_score_class IN NUMBER,
265 x_credit_score_natl_percentile IN NUMBER,
266 x_credit_score_incd_default IN NUMBER,
267 x_credit_score_age IN NUMBER,
268 x_credit_score_date IN DATE,
269 x_failure_score_class IN NUMBER,
270 x_failure_score_incd_default IN NUMBER,
271 x_failure_score_age IN NUMBER,
272 x_failure_score_date IN DATE,
273 x_failure_score_commentary2 IN VARCHAR2,
274 x_failure_score_commentary3 IN VARCHAR2,
275 x_failure_score_commentary4 IN VARCHAR2,
276 x_failure_score_commentary5 IN VARCHAR2,
277 x_failure_score_commentary6 IN VARCHAR2,
278 x_failure_score_commentary7 IN VARCHAR2,
279 x_failure_score_commentary8 IN VARCHAR2,
280 x_failure_score_commentary9 IN VARCHAR2,
281 x_failure_score_commentary10 IN VARCHAR2,
282 x_credit_score_commentary2 IN VARCHAR2,
283 x_credit_score_commentary3 IN VARCHAR2,
284 x_credit_score_commentary4 IN VARCHAR2,
285 x_credit_score_commentary5 IN VARCHAR2,
286 x_credit_score_commentary6 IN VARCHAR2,
287 x_credit_score_commentary7 IN VARCHAR2,
288 x_credit_score_commentary8 IN VARCHAR2,
289 x_credit_score_commentary9 IN VARCHAR2,
290 x_credit_score_commentary10 IN VARCHAR2,
291 x_maximum_credit_recomm IN NUMBER,
292 x_maximum_credit_currency_code IN VARCHAR2,
296 x_bank_or_branch_number IN VARCHAR2 := NULL,
293 x_displayed_duns_party_id IN NUMBER,
294 x_failure_score_natnl_perc IN NUMBER,
295 x_duns_number_c IN VARCHAR2,
297 x_bank_code IN VARCHAR2 := NULL,
298 x_branch_code IN VARCHAR2 := NULL,
299 x_object_version_number IN NUMBER,
300 x_created_by_module IN VARCHAR2,
301 x_application_id IN NUMBER,
302 x_do_not_confuse_with IN VARCHAR2 := NULL,
303 x_actual_content_source IN VARCHAR2 DEFAULT NULL,
304 x_version_number IN NUMBER DEFAULT NULL,
305 x_home_country IN VARCHAR2 DEFAULT NULL
306 );
307
308 PROCEDURE lock_row (
309 x_rowid IN OUT NOCOPY VARCHAR2,
310 x_organization_profile_id IN NUMBER,
311 x_party_id IN NUMBER,
312 x_organization_name IN VARCHAR2,
313 x_attribute_category IN VARCHAR2,
314 x_attribute1 IN VARCHAR2,
315 x_attribute2 IN VARCHAR2,
316 x_attribute3 IN VARCHAR2,
317 x_attribute4 IN VARCHAR2,
318 x_attribute5 IN VARCHAR2,
319 x_attribute6 IN VARCHAR2,
320 x_attribute7 IN VARCHAR2,
321 x_attribute8 IN VARCHAR2,
322 x_attribute9 IN VARCHAR2,
323 x_attribute10 IN VARCHAR2,
324 x_attribute11 IN VARCHAR2,
325 x_attribute12 IN VARCHAR2,
326 x_attribute13 IN VARCHAR2,
327 x_attribute14 IN VARCHAR2,
328 x_attribute15 IN VARCHAR2,
329 x_attribute16 IN VARCHAR2,
330 x_attribute17 IN VARCHAR2,
331 x_attribute18 IN VARCHAR2,
332 x_attribute19 IN VARCHAR2,
333 x_attribute20 IN VARCHAR2,
334 x_enquiry_duns IN VARCHAR2,
335 x_ceo_name IN VARCHAR2,
336 x_ceo_title IN VARCHAR2,
337 x_principal_name IN VARCHAR2,
338 x_principal_title IN VARCHAR2,
339 x_legal_status IN VARCHAR2,
340 x_control_yr IN NUMBER,
341 x_employees_total IN NUMBER,
342 x_hq_branch_ind IN VARCHAR2,
343 x_branch_flag IN VARCHAR2,
344 x_oob_ind IN VARCHAR2,
345 x_line_of_business IN VARCHAR2,
346 x_cong_dist_code IN VARCHAR2,
347 x_sic_code IN VARCHAR2,
348 x_import_ind IN VARCHAR2,
349 x_export_ind IN VARCHAR2,
350 x_labor_surplus_ind IN VARCHAR2,
351 x_debarment_ind IN VARCHAR2,
352 x_minority_owned_ind IN VARCHAR2,
353 x_minority_owned_type IN VARCHAR2,
354 x_woman_owned_ind IN VARCHAR2,
355 x_disadv_8a_ind IN VARCHAR2,
356 x_small_bus_ind IN VARCHAR2,
357 x_rent_own_ind IN VARCHAR2,
358 x_debarments_count IN NUMBER,
359 x_debarments_date IN DATE,
360 x_failure_score IN VARCHAR2,
361 x_failure_score_override_code IN VARCHAR2,
362 x_failure_score_commentary IN VARCHAR2,
363 x_global_failure_score IN VARCHAR2,
364 x_db_rating IN VARCHAR2,
365 x_credit_score IN VARCHAR2,
366 x_credit_score_commentary IN VARCHAR2,
367 x_paydex_score IN VARCHAR2,
368 x_paydex_three_months_ago IN VARCHAR2,
369 x_paydex_norm IN VARCHAR2,
370 x_best_time_contact_begin IN DATE,
371 x_best_time_contact_end IN DATE,
372 x_organization_name_phonetic IN VARCHAR2,
373 x_tax_reference IN VARCHAR2,
374 x_gsa_indicator_flag IN VARCHAR2,
375 x_jgzz_fiscal_code IN VARCHAR2,
376 x_analysis_fy IN VARCHAR2,
377 x_fiscal_yearend_month IN VARCHAR2,
378 x_curr_fy_potential_revenue IN NUMBER,
379 x_next_fy_potential_revenue IN NUMBER,
380 x_year_established IN NUMBER,
381 x_mission_statement IN VARCHAR2,
382 x_organization_type IN VARCHAR2,
383 x_business_scope IN VARCHAR2,
384 x_corporation_class IN VARCHAR2,
385 x_known_as IN VARCHAR2,
386 x_local_bus_iden_type IN VARCHAR2,
387 x_local_bus_identifier IN VARCHAR2,
388 x_pref_functional_currency IN VARCHAR2,
389 x_registration_type IN VARCHAR2,
393 x_total_emp_min_ind IN VARCHAR2,
390 x_total_employees_text IN VARCHAR2,
391 x_total_employees_ind IN VARCHAR2,
392 x_total_emp_est_ind IN VARCHAR2,
394 x_parent_sub_ind IN VARCHAR2,
395 x_incorp_year IN NUMBER,
396 x_last_update_date IN DATE,
397 x_last_updated_by IN NUMBER,
398 x_creation_date IN DATE,
399 x_created_by IN NUMBER,
400 x_last_update_login IN NUMBER,
401 x_request_id IN NUMBER,
402 x_program_application_id IN NUMBER,
403 x_program_id IN NUMBER,
404 x_program_update_date IN DATE,
405 x_content_source_type IN VARCHAR2,
406 x_content_source_number IN VARCHAR2,
407 x_effective_start_date IN DATE,
408 x_effective_end_date IN DATE,
409 x_sic_code_type IN VARCHAR2,
410 x_public_private_ownership IN VARCHAR2,
411 x_local_activity_code_type IN VARCHAR2,
412 x_local_activity_code IN VARCHAR2,
413 x_emp_at_primary_adr IN VARCHAR2,
414 x_emp_at_primary_adr_text IN VARCHAR2,
415 x_emp_at_primary_adr_est_ind IN VARCHAR2,
416 x_emp_at_primary_adr_min_ind IN VARCHAR2,
417 x_internal_flag IN VARCHAR2,
418 x_high_credit IN NUMBER,
419 x_avg_high_credit IN NUMBER,
420 x_total_payments IN NUMBER,
421 x_known_as2 IN VARCHAR2,
422 x_known_as3 IN VARCHAR2,
423 x_known_as4 IN VARCHAR2,
424 x_known_as5 IN VARCHAR2,
425 x_credit_score_class IN NUMBER,
426 x_credit_score_natl_percentile IN NUMBER,
427 x_credit_score_incd_default IN NUMBER,
428 x_credit_score_age IN NUMBER,
429 x_credit_score_date IN DATE,
430 x_failure_score_class IN NUMBER,
431 x_failure_score_incd_default IN NUMBER,
432 x_failure_score_age IN NUMBER,
433 x_failure_score_date IN DATE,
434 x_failure_score_commentary2 IN VARCHAR2,
435 x_failure_score_commentary3 IN VARCHAR2,
436 x_failure_score_commentary4 IN VARCHAR2,
437 x_failure_score_commentary5 IN VARCHAR2,
438 x_failure_score_commentary6 IN VARCHAR2,
439 x_failure_score_commentary7 IN VARCHAR2,
440 x_failure_score_commentary8 IN VARCHAR2,
441 x_failure_score_commentary9 IN VARCHAR2,
442 x_failure_score_commentary10 IN VARCHAR2,
443 x_credit_score_commentary2 IN VARCHAR2,
444 x_credit_score_commentary3 IN VARCHAR2,
445 x_credit_score_commentary4 IN VARCHAR2,
446 x_credit_score_commentary5 IN VARCHAR2,
447 x_credit_score_commentary6 IN VARCHAR2,
448 x_credit_score_commentary7 IN VARCHAR2,
449 x_credit_score_commentary8 IN VARCHAR2,
450 x_credit_score_commentary9 IN VARCHAR2,
451 x_credit_score_commentary10 IN VARCHAR2,
452 x_maximum_credit_recomm IN NUMBER,
453 x_maximum_credit_currency_code IN VARCHAR2,
454 x_displayed_duns_party_id IN NUMBER,
455 x_failure_score_natnl_perc IN NUMBER,
456 x_duns_number_c IN VARCHAR2,
457 x_bank_or_branch_number IN VARCHAR2,
458 x_bank_code IN VARCHAR2,
459 x_branch_code IN VARCHAR2,
460 x_object_version_number IN NUMBER,
461 x_created_by_module IN VARCHAR2,
462 x_application_id IN NUMBER,
463 x_do_not_confuse_with IN VARCHAR2,
464 x_actual_content_source IN VARCHAR2 DEFAULT NULL
465 );
466
467 PROCEDURE select_row (
468 x_organization_profile_id IN OUT NOCOPY NUMBER,
469 x_party_id OUT NOCOPY NUMBER,
470 x_organization_name OUT NOCOPY VARCHAR2,
471 x_attribute_category OUT NOCOPY VARCHAR2,
472 x_attribute1 OUT NOCOPY VARCHAR2,
473 x_attribute2 OUT NOCOPY VARCHAR2,
474 x_attribute3 OUT NOCOPY VARCHAR2,
475 x_attribute4 OUT NOCOPY VARCHAR2,
476 x_attribute5 OUT NOCOPY VARCHAR2,
477 x_attribute6 OUT NOCOPY VARCHAR2,
478 x_attribute7 OUT NOCOPY VARCHAR2,
479 x_attribute8 OUT NOCOPY VARCHAR2,
480 x_attribute9 OUT NOCOPY VARCHAR2,
481 x_attribute10 OUT NOCOPY VARCHAR2,
482 x_attribute11 OUT NOCOPY VARCHAR2,
483 x_attribute12 OUT NOCOPY VARCHAR2,
484 x_attribute13 OUT NOCOPY VARCHAR2,
488 x_attribute17 OUT NOCOPY VARCHAR2,
485 x_attribute14 OUT NOCOPY VARCHAR2,
486 x_attribute15 OUT NOCOPY VARCHAR2,
487 x_attribute16 OUT NOCOPY VARCHAR2,
489 x_attribute18 OUT NOCOPY VARCHAR2,
490 x_attribute19 OUT NOCOPY VARCHAR2,
491 x_attribute20 OUT NOCOPY VARCHAR2,
492 x_enquiry_duns OUT NOCOPY VARCHAR2,
493 x_ceo_name OUT NOCOPY VARCHAR2,
494 x_ceo_title OUT NOCOPY VARCHAR2,
495 x_principal_name OUT NOCOPY VARCHAR2,
496 x_principal_title OUT NOCOPY VARCHAR2,
497 x_legal_status OUT NOCOPY VARCHAR2,
498 x_control_yr OUT NOCOPY NUMBER,
499 x_employees_total OUT NOCOPY NUMBER,
500 x_hq_branch_ind OUT NOCOPY VARCHAR2,
501 x_branch_flag OUT NOCOPY VARCHAR2,
502 x_oob_ind OUT NOCOPY VARCHAR2,
503 x_line_of_business OUT NOCOPY VARCHAR2,
504 x_cong_dist_code OUT NOCOPY VARCHAR2,
505 x_sic_code OUT NOCOPY VARCHAR2,
506 x_import_ind OUT NOCOPY VARCHAR2,
507 x_export_ind OUT NOCOPY VARCHAR2,
508 x_labor_surplus_ind OUT NOCOPY VARCHAR2,
509 x_debarment_ind OUT NOCOPY VARCHAR2,
510 x_minority_owned_ind OUT NOCOPY VARCHAR2,
511 x_minority_owned_type OUT NOCOPY VARCHAR2,
512 x_woman_owned_ind OUT NOCOPY VARCHAR2,
513 x_disadv_8a_ind OUT NOCOPY VARCHAR2,
514 x_small_bus_ind OUT NOCOPY VARCHAR2,
515 x_rent_own_ind OUT NOCOPY VARCHAR2,
516 x_debarments_count OUT NOCOPY NUMBER,
517 x_debarments_date OUT NOCOPY DATE,
518 x_failure_score OUT NOCOPY VARCHAR2,
519 x_failure_score_override_code OUT NOCOPY VARCHAR2,
520 x_failure_score_commentary OUT NOCOPY VARCHAR2,
521 x_global_failure_score OUT NOCOPY VARCHAR2,
522 x_db_rating OUT NOCOPY VARCHAR2,
523 x_credit_score OUT NOCOPY VARCHAR2,
524 x_credit_score_commentary OUT NOCOPY VARCHAR2,
525 x_paydex_score OUT NOCOPY VARCHAR2,
526 x_paydex_three_months_ago OUT NOCOPY VARCHAR2,
527 x_paydex_norm OUT NOCOPY VARCHAR2,
528 x_best_time_contact_begin OUT NOCOPY DATE,
529 x_best_time_contact_end OUT NOCOPY DATE,
530 x_organization_name_phonetic OUT NOCOPY VARCHAR2,
531 x_tax_reference OUT NOCOPY VARCHAR2,
532 x_gsa_indicator_flag OUT NOCOPY VARCHAR2,
533 x_jgzz_fiscal_code OUT NOCOPY VARCHAR2,
534 x_analysis_fy OUT NOCOPY VARCHAR2,
535 x_fiscal_yearend_month OUT NOCOPY VARCHAR2,
536 x_curr_fy_potential_revenue OUT NOCOPY NUMBER,
537 x_next_fy_potential_revenue OUT NOCOPY NUMBER,
538 x_year_established OUT NOCOPY NUMBER,
539 x_mission_statement OUT NOCOPY VARCHAR2,
540 x_organization_type OUT NOCOPY VARCHAR2,
541 x_business_scope OUT NOCOPY VARCHAR2,
542 x_corporation_class OUT NOCOPY VARCHAR2,
543 x_known_as OUT NOCOPY VARCHAR2,
544 x_local_bus_iden_type OUT NOCOPY VARCHAR2,
545 x_local_bus_identifier OUT NOCOPY VARCHAR2,
546 x_pref_functional_currency OUT NOCOPY VARCHAR2,
547 x_registration_type OUT NOCOPY VARCHAR2,
548 x_total_employees_text OUT NOCOPY VARCHAR2,
549 x_total_employees_ind OUT NOCOPY VARCHAR2,
550 x_total_emp_est_ind OUT NOCOPY VARCHAR2,
551 x_total_emp_min_ind OUT NOCOPY VARCHAR2,
552 x_parent_sub_ind OUT NOCOPY VARCHAR2,
553 x_incorp_year OUT NOCOPY NUMBER,
554 x_content_source_type OUT NOCOPY VARCHAR2,
555 x_content_source_number OUT NOCOPY VARCHAR2,
556 x_effective_start_date OUT NOCOPY DATE,
557 x_effective_end_date OUT NOCOPY DATE,
558 x_sic_code_type OUT NOCOPY VARCHAR2,
559 x_public_private_ownership OUT NOCOPY VARCHAR2,
560 x_local_activity_code_type OUT NOCOPY VARCHAR2,
561 x_local_activity_code OUT NOCOPY VARCHAR2,
562 x_emp_at_primary_adr OUT NOCOPY VARCHAR2,
563 x_emp_at_primary_adr_text OUT NOCOPY VARCHAR2,
567 x_high_credit OUT NOCOPY NUMBER,
564 x_emp_at_primary_adr_est_ind OUT NOCOPY VARCHAR2,
565 x_emp_at_primary_adr_min_ind OUT NOCOPY VARCHAR2,
566 x_internal_flag OUT NOCOPY VARCHAR2,
568 x_avg_high_credit OUT NOCOPY NUMBER,
569 x_total_payments OUT NOCOPY NUMBER,
570 x_known_as2 OUT NOCOPY VARCHAR2,
571 x_known_as3 OUT NOCOPY VARCHAR2,
572 x_known_as4 OUT NOCOPY VARCHAR2,
573 x_known_as5 OUT NOCOPY VARCHAR2,
574 x_credit_score_class OUT NOCOPY NUMBER,
575 x_credit_score_natl_percentile OUT NOCOPY NUMBER,
576 x_credit_score_incd_default OUT NOCOPY NUMBER,
577 x_credit_score_age OUT NOCOPY NUMBER,
578 x_credit_score_date OUT NOCOPY DATE,
579 x_failure_score_class OUT NOCOPY NUMBER,
580 x_failure_score_incd_default OUT NOCOPY NUMBER,
581 x_failure_score_age OUT NOCOPY NUMBER,
582 x_failure_score_date OUT NOCOPY DATE,
583 x_failure_score_commentary2 OUT NOCOPY VARCHAR2,
584 x_failure_score_commentary3 OUT NOCOPY VARCHAR2,
585 x_failure_score_commentary4 OUT NOCOPY VARCHAR2,
586 x_failure_score_commentary5 OUT NOCOPY VARCHAR2,
587 x_failure_score_commentary6 OUT NOCOPY VARCHAR2,
588 x_failure_score_commentary7 OUT NOCOPY VARCHAR2,
589 x_failure_score_commentary8 OUT NOCOPY VARCHAR2,
590 x_failure_score_commentary9 OUT NOCOPY VARCHAR2,
591 x_failure_score_commentary10 OUT NOCOPY VARCHAR2,
592 x_credit_score_commentary2 OUT NOCOPY VARCHAR2,
593 x_credit_score_commentary3 OUT NOCOPY VARCHAR2,
594 x_credit_score_commentary4 OUT NOCOPY VARCHAR2,
595 x_credit_score_commentary5 OUT NOCOPY VARCHAR2,
596 x_credit_score_commentary6 OUT NOCOPY VARCHAR2,
597 x_credit_score_commentary7 OUT NOCOPY VARCHAR2,
598 x_credit_score_commentary8 OUT NOCOPY VARCHAR2,
599 x_credit_score_commentary9 OUT NOCOPY VARCHAR2,
600 x_credit_score_commentary10 OUT NOCOPY VARCHAR2,
601 x_maximum_credit_recomm OUT NOCOPY NUMBER,
602 x_maximum_credit_currency_code OUT NOCOPY VARCHAR2,
603 x_displayed_duns_party_id OUT NOCOPY NUMBER,
604 x_failure_score_natnl_perc OUT NOCOPY NUMBER,
605 x_duns_number_c OUT NOCOPY VARCHAR2,
606 x_bank_or_branch_number OUT NOCOPY VARCHAR2,
607 x_bank_code OUT NOCOPY VARCHAR2,
608 x_branch_code OUT NOCOPY VARCHAR2,
609 x_created_by_module OUT NOCOPY VARCHAR2,
610 x_application_id OUT NOCOPY NUMBER,
611 x_do_not_confuse_with OUT NOCOPY VARCHAR2,
612 x_actual_content_source OUT NOCOPY VARCHAR2,
613 x_home_country OUT NOCOPY VARCHAR2
614 );
615
616 PROCEDURE Delete_Row (
617 x_organization_profile_id IN NUMBER
618 );
619
620 END HZ_ORGANIZATION_PROFILES_PKG;
[Home] [Help]