[Home] [Help]
18:
19: /* Bug 3435702.This check is done before calling this procedure and as such is redundant.
20: |
21: | IF p_duns_number_c IS NOT NULL AND
22: | p_duns_number_c <> FND_API.G_MISS_CHAR
23: | THEN
24: */
25: FOR i IN 1..LENGTHB(p_duns_number_c) LOOP
26: l_char := SUBSTRB(p_duns_number_c, i, 1);
175: x_maximum_credit_currency_code IN VARCHAR2,
176: x_displayed_duns_party_id IN NUMBER,
177: x_failure_score_natnl_perc IN NUMBER,
178: x_duns_number_c IN VARCHAR2,
179: x_bank_or_branch_number IN VARCHAR2 := fnd_api.g_miss_char,
180: x_bank_code IN VARCHAR2 := fnd_api.g_miss_char,
181: x_branch_code IN VARCHAR2 := fnd_api.g_miss_char,
182: x_object_version_number IN NUMBER,
183: x_created_by_module IN VARCHAR2,
176: x_displayed_duns_party_id IN NUMBER,
177: x_failure_score_natnl_perc IN NUMBER,
178: x_duns_number_c IN VARCHAR2,
179: x_bank_or_branch_number IN VARCHAR2 := fnd_api.g_miss_char,
180: x_bank_code IN VARCHAR2 := fnd_api.g_miss_char,
181: x_branch_code IN VARCHAR2 := fnd_api.g_miss_char,
182: x_object_version_number IN NUMBER,
183: x_created_by_module IN VARCHAR2,
184: x_application_id IN NUMBER,
177: x_failure_score_natnl_perc IN NUMBER,
178: x_duns_number_c IN VARCHAR2,
179: x_bank_or_branch_number IN VARCHAR2 := fnd_api.g_miss_char,
180: x_bank_code IN VARCHAR2 := fnd_api.g_miss_char,
181: x_branch_code IN VARCHAR2 := fnd_api.g_miss_char,
182: x_object_version_number IN NUMBER,
183: x_created_by_module IN VARCHAR2,
184: x_application_id IN NUMBER,
185: x_do_not_confuse_with IN VARCHAR2 := NULL,
193: l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;
194: BEGIN
195:
196: IF x_duns_number_c IS NOT NULL AND
197: x_duns_number_c <> FND_API.G_MISS_CHAR
198: THEN
199: l_duns_number := do_copy_duns_number(x_duns_number_c);
200: END IF;
201:
199: l_duns_number := do_copy_duns_number(x_duns_number_c);
200: END IF;
201:
202: IF x_duns_number_c IS NOT NULL AND
203: x_duns_number_c <> FND_API.G_MISS_CHAR AND
204: LENGTHB(x_duns_number_c)<9
205: THEN
206: l_duns_number_c:=lpad(x_duns_number_c,9,'0');
207: END IF;
370: home_country
371: )
372: VALUES (
373: DECODE(x_organization_profile_id,
374: fnd_api.g_miss_num, hz_organization_profiles_s.NEXTVAL,
375: NULL, hz_organization_profiles_s.NEXTVAL,
376: x_organization_profile_id),
377: DECODE(x_party_id, fnd_api.g_miss_num, NULL, x_party_id),
378: DECODE(x_organization_name,
373: DECODE(x_organization_profile_id,
374: fnd_api.g_miss_num, hz_organization_profiles_s.NEXTVAL,
375: NULL, hz_organization_profiles_s.NEXTVAL,
376: x_organization_profile_id),
377: DECODE(x_party_id, fnd_api.g_miss_num, NULL, x_party_id),
378: DECODE(x_organization_name,
379: fnd_api.g_miss_char, NULL,
380: x_organization_name),
381: DECODE(x_attribute_category,
375: NULL, hz_organization_profiles_s.NEXTVAL,
376: x_organization_profile_id),
377: DECODE(x_party_id, fnd_api.g_miss_num, NULL, x_party_id),
378: DECODE(x_organization_name,
379: fnd_api.g_miss_char, NULL,
380: x_organization_name),
381: DECODE(x_attribute_category,
382: fnd_api.g_miss_char, NULL,
383: x_attribute_category),
378: DECODE(x_organization_name,
379: fnd_api.g_miss_char, NULL,
380: x_organization_name),
381: DECODE(x_attribute_category,
382: fnd_api.g_miss_char, NULL,
383: x_attribute_category),
384: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
385: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
386: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
380: x_organization_name),
381: DECODE(x_attribute_category,
382: fnd_api.g_miss_char, NULL,
383: x_attribute_category),
384: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
385: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
386: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
387: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
388: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
381: DECODE(x_attribute_category,
382: fnd_api.g_miss_char, NULL,
383: x_attribute_category),
384: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
385: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
386: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
387: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
388: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
389: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
382: fnd_api.g_miss_char, NULL,
383: x_attribute_category),
384: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
385: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
386: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
387: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
388: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
389: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
390: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
383: x_attribute_category),
384: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
385: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
386: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
387: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
388: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
389: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
390: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
391: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
384: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
385: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
386: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
387: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
388: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
389: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
390: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
391: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
392: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
385: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
386: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
387: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
388: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
389: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
390: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
391: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
392: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
393: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
386: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
387: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
388: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
389: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
390: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
391: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
392: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
393: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
394: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
387: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
388: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
389: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
390: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
391: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
392: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
393: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
394: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
395: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
388: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
389: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
390: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
391: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
392: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
393: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
394: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
395: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
396: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
389: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
390: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
391: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
392: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
393: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
394: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
395: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
396: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
397: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
390: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
391: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
392: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
393: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
394: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
395: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
396: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
397: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
398: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
391: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
392: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
393: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
394: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
395: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
396: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
397: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
398: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
399: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
392: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
393: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
394: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
395: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
396: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
397: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
398: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
399: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
400: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
393: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
394: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
395: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
396: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
397: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
398: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
399: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
400: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
401: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
394: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
395: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
396: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
397: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
398: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
399: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
400: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
401: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
402: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
395: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
396: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
397: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
398: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
399: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
400: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
401: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
402: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
403: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
396: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
397: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
398: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
399: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
400: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
401: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
402: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
403: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
404: DECODE(x_enquiry_duns, fnd_api.g_miss_char, NULL, x_enquiry_duns),
397: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
398: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
399: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
400: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
401: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
402: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
403: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
404: DECODE(x_enquiry_duns, fnd_api.g_miss_char, NULL, x_enquiry_duns),
405: DECODE(x_ceo_name, fnd_api.g_miss_char, NULL, x_ceo_name),
398: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
399: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
400: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
401: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
402: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
403: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
404: DECODE(x_enquiry_duns, fnd_api.g_miss_char, NULL, x_enquiry_duns),
405: DECODE(x_ceo_name, fnd_api.g_miss_char, NULL, x_ceo_name),
406: DECODE(x_ceo_title, fnd_api.g_miss_char, NULL, x_ceo_title),
399: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
400: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
401: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
402: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
403: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
404: DECODE(x_enquiry_duns, fnd_api.g_miss_char, NULL, x_enquiry_duns),
405: DECODE(x_ceo_name, fnd_api.g_miss_char, NULL, x_ceo_name),
406: DECODE(x_ceo_title, fnd_api.g_miss_char, NULL, x_ceo_title),
407: DECODE(x_principal_name,
400: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
401: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
402: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
403: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
404: DECODE(x_enquiry_duns, fnd_api.g_miss_char, NULL, x_enquiry_duns),
405: DECODE(x_ceo_name, fnd_api.g_miss_char, NULL, x_ceo_name),
406: DECODE(x_ceo_title, fnd_api.g_miss_char, NULL, x_ceo_title),
407: DECODE(x_principal_name,
408: fnd_api.g_miss_char, NULL,
401: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
402: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
403: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
404: DECODE(x_enquiry_duns, fnd_api.g_miss_char, NULL, x_enquiry_duns),
405: DECODE(x_ceo_name, fnd_api.g_miss_char, NULL, x_ceo_name),
406: DECODE(x_ceo_title, fnd_api.g_miss_char, NULL, x_ceo_title),
407: DECODE(x_principal_name,
408: fnd_api.g_miss_char, NULL,
409: x_principal_name),
402: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
403: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
404: DECODE(x_enquiry_duns, fnd_api.g_miss_char, NULL, x_enquiry_duns),
405: DECODE(x_ceo_name, fnd_api.g_miss_char, NULL, x_ceo_name),
406: DECODE(x_ceo_title, fnd_api.g_miss_char, NULL, x_ceo_title),
407: DECODE(x_principal_name,
408: fnd_api.g_miss_char, NULL,
409: x_principal_name),
410: DECODE(x_principal_title,
404: DECODE(x_enquiry_duns, fnd_api.g_miss_char, NULL, x_enquiry_duns),
405: DECODE(x_ceo_name, fnd_api.g_miss_char, NULL, x_ceo_name),
406: DECODE(x_ceo_title, fnd_api.g_miss_char, NULL, x_ceo_title),
407: DECODE(x_principal_name,
408: fnd_api.g_miss_char, NULL,
409: x_principal_name),
410: DECODE(x_principal_title,
411: fnd_api.g_miss_char, NULL,
412: x_principal_title),
407: DECODE(x_principal_name,
408: fnd_api.g_miss_char, NULL,
409: x_principal_name),
410: DECODE(x_principal_title,
411: fnd_api.g_miss_char, NULL,
412: x_principal_title),
413: DECODE(x_legal_status, fnd_api.g_miss_char, NULL, x_legal_status),
414: DECODE(x_control_yr, fnd_api.g_miss_num, NULL, x_control_yr),
415: DECODE(x_employees_total,
409: x_principal_name),
410: DECODE(x_principal_title,
411: fnd_api.g_miss_char, NULL,
412: x_principal_title),
413: DECODE(x_legal_status, fnd_api.g_miss_char, NULL, x_legal_status),
414: DECODE(x_control_yr, fnd_api.g_miss_num, NULL, x_control_yr),
415: DECODE(x_employees_total,
416: fnd_api.g_miss_num, NULL,
417: x_employees_total),
410: DECODE(x_principal_title,
411: fnd_api.g_miss_char, NULL,
412: x_principal_title),
413: DECODE(x_legal_status, fnd_api.g_miss_char, NULL, x_legal_status),
414: DECODE(x_control_yr, fnd_api.g_miss_num, NULL, x_control_yr),
415: DECODE(x_employees_total,
416: fnd_api.g_miss_num, NULL,
417: x_employees_total),
418: DECODE(x_hq_branch_ind, fnd_api.g_miss_char, NULL, x_hq_branch_ind),
412: x_principal_title),
413: DECODE(x_legal_status, fnd_api.g_miss_char, NULL, x_legal_status),
414: DECODE(x_control_yr, fnd_api.g_miss_num, NULL, x_control_yr),
415: DECODE(x_employees_total,
416: fnd_api.g_miss_num, NULL,
417: x_employees_total),
418: DECODE(x_hq_branch_ind, fnd_api.g_miss_char, NULL, x_hq_branch_ind),
419: DECODE(x_branch_flag, fnd_api.g_miss_char, NULL, x_branch_flag),
420: DECODE(x_oob_ind, fnd_api.g_miss_char, NULL, x_oob_ind),
414: DECODE(x_control_yr, fnd_api.g_miss_num, NULL, x_control_yr),
415: DECODE(x_employees_total,
416: fnd_api.g_miss_num, NULL,
417: x_employees_total),
418: DECODE(x_hq_branch_ind, fnd_api.g_miss_char, NULL, x_hq_branch_ind),
419: DECODE(x_branch_flag, fnd_api.g_miss_char, NULL, x_branch_flag),
420: DECODE(x_oob_ind, fnd_api.g_miss_char, NULL, x_oob_ind),
421: DECODE(x_line_of_business,
422: fnd_api.g_miss_char, NULL,
415: DECODE(x_employees_total,
416: fnd_api.g_miss_num, NULL,
417: x_employees_total),
418: DECODE(x_hq_branch_ind, fnd_api.g_miss_char, NULL, x_hq_branch_ind),
419: DECODE(x_branch_flag, fnd_api.g_miss_char, NULL, x_branch_flag),
420: DECODE(x_oob_ind, fnd_api.g_miss_char, NULL, x_oob_ind),
421: DECODE(x_line_of_business,
422: fnd_api.g_miss_char, NULL,
423: x_line_of_business),
416: fnd_api.g_miss_num, NULL,
417: x_employees_total),
418: DECODE(x_hq_branch_ind, fnd_api.g_miss_char, NULL, x_hq_branch_ind),
419: DECODE(x_branch_flag, fnd_api.g_miss_char, NULL, x_branch_flag),
420: DECODE(x_oob_ind, fnd_api.g_miss_char, NULL, x_oob_ind),
421: DECODE(x_line_of_business,
422: fnd_api.g_miss_char, NULL,
423: x_line_of_business),
424: DECODE(x_cong_dist_code,
418: DECODE(x_hq_branch_ind, fnd_api.g_miss_char, NULL, x_hq_branch_ind),
419: DECODE(x_branch_flag, fnd_api.g_miss_char, NULL, x_branch_flag),
420: DECODE(x_oob_ind, fnd_api.g_miss_char, NULL, x_oob_ind),
421: DECODE(x_line_of_business,
422: fnd_api.g_miss_char, NULL,
423: x_line_of_business),
424: DECODE(x_cong_dist_code,
425: fnd_api.g_miss_char, NULL,
426: x_cong_dist_code),
421: DECODE(x_line_of_business,
422: fnd_api.g_miss_char, NULL,
423: x_line_of_business),
424: DECODE(x_cong_dist_code,
425: fnd_api.g_miss_char, NULL,
426: x_cong_dist_code),
427: DECODE(x_sic_code, fnd_api.g_miss_char, NULL, x_sic_code),
428: DECODE(x_import_ind, fnd_api.g_miss_char, NULL, x_import_ind),
429: DECODE(x_export_ind, fnd_api.g_miss_char, NULL, x_export_ind),
423: x_line_of_business),
424: DECODE(x_cong_dist_code,
425: fnd_api.g_miss_char, NULL,
426: x_cong_dist_code),
427: DECODE(x_sic_code, fnd_api.g_miss_char, NULL, x_sic_code),
428: DECODE(x_import_ind, fnd_api.g_miss_char, NULL, x_import_ind),
429: DECODE(x_export_ind, fnd_api.g_miss_char, NULL, x_export_ind),
430: DECODE(x_labor_surplus_ind,
431: fnd_api.g_miss_char, NULL,
424: DECODE(x_cong_dist_code,
425: fnd_api.g_miss_char, NULL,
426: x_cong_dist_code),
427: DECODE(x_sic_code, fnd_api.g_miss_char, NULL, x_sic_code),
428: DECODE(x_import_ind, fnd_api.g_miss_char, NULL, x_import_ind),
429: DECODE(x_export_ind, fnd_api.g_miss_char, NULL, x_export_ind),
430: DECODE(x_labor_surplus_ind,
431: fnd_api.g_miss_char, NULL,
432: x_labor_surplus_ind),
425: fnd_api.g_miss_char, NULL,
426: x_cong_dist_code),
427: DECODE(x_sic_code, fnd_api.g_miss_char, NULL, x_sic_code),
428: DECODE(x_import_ind, fnd_api.g_miss_char, NULL, x_import_ind),
429: DECODE(x_export_ind, fnd_api.g_miss_char, NULL, x_export_ind),
430: DECODE(x_labor_surplus_ind,
431: fnd_api.g_miss_char, NULL,
432: x_labor_surplus_ind),
433: DECODE(x_debarment_ind, fnd_api.g_miss_char, NULL, x_debarment_ind),
427: DECODE(x_sic_code, fnd_api.g_miss_char, NULL, x_sic_code),
428: DECODE(x_import_ind, fnd_api.g_miss_char, NULL, x_import_ind),
429: DECODE(x_export_ind, fnd_api.g_miss_char, NULL, x_export_ind),
430: DECODE(x_labor_surplus_ind,
431: fnd_api.g_miss_char, NULL,
432: x_labor_surplus_ind),
433: DECODE(x_debarment_ind, fnd_api.g_miss_char, NULL, x_debarment_ind),
434: DECODE(x_minority_owned_ind,
435: fnd_api.g_miss_char, NULL,
429: DECODE(x_export_ind, fnd_api.g_miss_char, NULL, x_export_ind),
430: DECODE(x_labor_surplus_ind,
431: fnd_api.g_miss_char, NULL,
432: x_labor_surplus_ind),
433: DECODE(x_debarment_ind, fnd_api.g_miss_char, NULL, x_debarment_ind),
434: DECODE(x_minority_owned_ind,
435: fnd_api.g_miss_char, NULL,
436: x_minority_owned_ind),
437: DECODE(x_minority_owned_type,
431: fnd_api.g_miss_char, NULL,
432: x_labor_surplus_ind),
433: DECODE(x_debarment_ind, fnd_api.g_miss_char, NULL, x_debarment_ind),
434: DECODE(x_minority_owned_ind,
435: fnd_api.g_miss_char, NULL,
436: x_minority_owned_ind),
437: DECODE(x_minority_owned_type,
438: fnd_api.g_miss_char, NULL,
439: x_minority_owned_type),
434: DECODE(x_minority_owned_ind,
435: fnd_api.g_miss_char, NULL,
436: x_minority_owned_ind),
437: DECODE(x_minority_owned_type,
438: fnd_api.g_miss_char, NULL,
439: x_minority_owned_type),
440: DECODE(x_woman_owned_ind,
441: fnd_api.g_miss_char, NULL,
442: x_woman_owned_ind),
437: DECODE(x_minority_owned_type,
438: fnd_api.g_miss_char, NULL,
439: x_minority_owned_type),
440: DECODE(x_woman_owned_ind,
441: fnd_api.g_miss_char, NULL,
442: x_woman_owned_ind),
443: DECODE(x_disadv_8a_ind, fnd_api.g_miss_char, NULL, x_disadv_8a_ind),
444: DECODE(x_small_bus_ind, fnd_api.g_miss_char, NULL, x_small_bus_ind),
445: DECODE(x_rent_own_ind, fnd_api.g_miss_char, NULL, x_rent_own_ind),
439: x_minority_owned_type),
440: DECODE(x_woman_owned_ind,
441: fnd_api.g_miss_char, NULL,
442: x_woman_owned_ind),
443: DECODE(x_disadv_8a_ind, fnd_api.g_miss_char, NULL, x_disadv_8a_ind),
444: DECODE(x_small_bus_ind, fnd_api.g_miss_char, NULL, x_small_bus_ind),
445: DECODE(x_rent_own_ind, fnd_api.g_miss_char, NULL, x_rent_own_ind),
446: DECODE(x_debarments_count,
447: fnd_api.g_miss_num, NULL,
440: DECODE(x_woman_owned_ind,
441: fnd_api.g_miss_char, NULL,
442: x_woman_owned_ind),
443: DECODE(x_disadv_8a_ind, fnd_api.g_miss_char, NULL, x_disadv_8a_ind),
444: DECODE(x_small_bus_ind, fnd_api.g_miss_char, NULL, x_small_bus_ind),
445: DECODE(x_rent_own_ind, fnd_api.g_miss_char, NULL, x_rent_own_ind),
446: DECODE(x_debarments_count,
447: fnd_api.g_miss_num, NULL,
448: x_debarments_count),
441: fnd_api.g_miss_char, NULL,
442: x_woman_owned_ind),
443: DECODE(x_disadv_8a_ind, fnd_api.g_miss_char, NULL, x_disadv_8a_ind),
444: DECODE(x_small_bus_ind, fnd_api.g_miss_char, NULL, x_small_bus_ind),
445: DECODE(x_rent_own_ind, fnd_api.g_miss_char, NULL, x_rent_own_ind),
446: DECODE(x_debarments_count,
447: fnd_api.g_miss_num, NULL,
448: x_debarments_count),
449: DECODE(x_debarments_date,
443: DECODE(x_disadv_8a_ind, fnd_api.g_miss_char, NULL, x_disadv_8a_ind),
444: DECODE(x_small_bus_ind, fnd_api.g_miss_char, NULL, x_small_bus_ind),
445: DECODE(x_rent_own_ind, fnd_api.g_miss_char, NULL, x_rent_own_ind),
446: DECODE(x_debarments_count,
447: fnd_api.g_miss_num, NULL,
448: x_debarments_count),
449: DECODE(x_debarments_date,
450: fnd_api.g_miss_date, to_date(NULL),
451: x_debarments_date),
446: DECODE(x_debarments_count,
447: fnd_api.g_miss_num, NULL,
448: x_debarments_count),
449: DECODE(x_debarments_date,
450: fnd_api.g_miss_date, to_date(NULL),
451: x_debarments_date),
452: DECODE(x_failure_score, fnd_api.g_miss_char, NULL, x_failure_score),
453: DECODE(x_failure_score_override_code,
454: fnd_api.g_miss_char, NULL,
448: x_debarments_count),
449: DECODE(x_debarments_date,
450: fnd_api.g_miss_date, to_date(NULL),
451: x_debarments_date),
452: DECODE(x_failure_score, fnd_api.g_miss_char, NULL, x_failure_score),
453: DECODE(x_failure_score_override_code,
454: fnd_api.g_miss_char, NULL,
455: x_failure_score_override_code),
456: DECODE(x_failure_score_commentary,
450: fnd_api.g_miss_date, to_date(NULL),
451: x_debarments_date),
452: DECODE(x_failure_score, fnd_api.g_miss_char, NULL, x_failure_score),
453: DECODE(x_failure_score_override_code,
454: fnd_api.g_miss_char, NULL,
455: x_failure_score_override_code),
456: DECODE(x_failure_score_commentary,
457: fnd_api.g_miss_char, NULL,
458: x_failure_score_commentary),
453: DECODE(x_failure_score_override_code,
454: fnd_api.g_miss_char, NULL,
455: x_failure_score_override_code),
456: DECODE(x_failure_score_commentary,
457: fnd_api.g_miss_char, NULL,
458: x_failure_score_commentary),
459: DECODE(x_global_failure_score,
460: fnd_api.g_miss_char, NULL,
461: x_global_failure_score),
456: DECODE(x_failure_score_commentary,
457: fnd_api.g_miss_char, NULL,
458: x_failure_score_commentary),
459: DECODE(x_global_failure_score,
460: fnd_api.g_miss_char, NULL,
461: x_global_failure_score),
462: DECODE(x_db_rating, fnd_api.g_miss_char, NULL, x_db_rating),
463: DECODE(x_credit_score, fnd_api.g_miss_char, NULL, x_credit_score),
464: DECODE(x_credit_score_commentary,
458: x_failure_score_commentary),
459: DECODE(x_global_failure_score,
460: fnd_api.g_miss_char, NULL,
461: x_global_failure_score),
462: DECODE(x_db_rating, fnd_api.g_miss_char, NULL, x_db_rating),
463: DECODE(x_credit_score, fnd_api.g_miss_char, NULL, x_credit_score),
464: DECODE(x_credit_score_commentary,
465: fnd_api.g_miss_char, NULL,
466: x_credit_score_commentary),
459: DECODE(x_global_failure_score,
460: fnd_api.g_miss_char, NULL,
461: x_global_failure_score),
462: DECODE(x_db_rating, fnd_api.g_miss_char, NULL, x_db_rating),
463: DECODE(x_credit_score, fnd_api.g_miss_char, NULL, x_credit_score),
464: DECODE(x_credit_score_commentary,
465: fnd_api.g_miss_char, NULL,
466: x_credit_score_commentary),
467: DECODE(x_paydex_score,
461: x_global_failure_score),
462: DECODE(x_db_rating, fnd_api.g_miss_char, NULL, x_db_rating),
463: DECODE(x_credit_score, fnd_api.g_miss_char, NULL, x_credit_score),
464: DECODE(x_credit_score_commentary,
465: fnd_api.g_miss_char, NULL,
466: x_credit_score_commentary),
467: DECODE(x_paydex_score,
468: fnd_api.g_miss_char, NULL,
469: x_paydex_score),
464: DECODE(x_credit_score_commentary,
465: fnd_api.g_miss_char, NULL,
466: x_credit_score_commentary),
467: DECODE(x_paydex_score,
468: fnd_api.g_miss_char, NULL,
469: x_paydex_score),
470: DECODE(x_paydex_three_months_ago,
471: fnd_api.g_miss_char, NULL,
472: x_paydex_three_months_ago),
467: DECODE(x_paydex_score,
468: fnd_api.g_miss_char, NULL,
469: x_paydex_score),
470: DECODE(x_paydex_three_months_ago,
471: fnd_api.g_miss_char, NULL,
472: x_paydex_three_months_ago),
473: DECODE(x_paydex_norm, fnd_api.g_miss_char, NULL, x_paydex_norm),
474: DECODE(x_best_time_contact_begin,
475: fnd_api.g_miss_date, TO_DATE(NULL),
469: x_paydex_score),
470: DECODE(x_paydex_three_months_ago,
471: fnd_api.g_miss_char, NULL,
472: x_paydex_three_months_ago),
473: DECODE(x_paydex_norm, fnd_api.g_miss_char, NULL, x_paydex_norm),
474: DECODE(x_best_time_contact_begin,
475: fnd_api.g_miss_date, TO_DATE(NULL),
476: x_best_time_contact_begin),
477: DECODE(x_best_time_contact_end,
471: fnd_api.g_miss_char, NULL,
472: x_paydex_three_months_ago),
473: DECODE(x_paydex_norm, fnd_api.g_miss_char, NULL, x_paydex_norm),
474: DECODE(x_best_time_contact_begin,
475: fnd_api.g_miss_date, TO_DATE(NULL),
476: x_best_time_contact_begin),
477: DECODE(x_best_time_contact_end,
478: fnd_api.g_miss_date, TO_DATE(NULL),
479: x_best_time_contact_end),
474: DECODE(x_best_time_contact_begin,
475: fnd_api.g_miss_date, TO_DATE(NULL),
476: x_best_time_contact_begin),
477: DECODE(x_best_time_contact_end,
478: fnd_api.g_miss_date, TO_DATE(NULL),
479: x_best_time_contact_end),
480: DECODE(x_organization_name_phonetic,
481: fnd_api.g_miss_char, NULL,
482: x_organization_name_phonetic),
477: DECODE(x_best_time_contact_end,
478: fnd_api.g_miss_date, TO_DATE(NULL),
479: x_best_time_contact_end),
480: DECODE(x_organization_name_phonetic,
481: fnd_api.g_miss_char, NULL,
482: x_organization_name_phonetic),
483: DECODE(x_tax_reference, fnd_api.g_miss_char, NULL, x_tax_reference),
484: DECODE(x_gsa_indicator_flag,
485: fnd_api.g_miss_char, NULL,
479: x_best_time_contact_end),
480: DECODE(x_organization_name_phonetic,
481: fnd_api.g_miss_char, NULL,
482: x_organization_name_phonetic),
483: DECODE(x_tax_reference, fnd_api.g_miss_char, NULL, x_tax_reference),
484: DECODE(x_gsa_indicator_flag,
485: fnd_api.g_miss_char, NULL,
486: x_gsa_indicator_flag),
487: DECODE(x_jgzz_fiscal_code,
481: fnd_api.g_miss_char, NULL,
482: x_organization_name_phonetic),
483: DECODE(x_tax_reference, fnd_api.g_miss_char, NULL, x_tax_reference),
484: DECODE(x_gsa_indicator_flag,
485: fnd_api.g_miss_char, NULL,
486: x_gsa_indicator_flag),
487: DECODE(x_jgzz_fiscal_code,
488: fnd_api.g_miss_char, NULL,
489: x_jgzz_fiscal_code),
484: DECODE(x_gsa_indicator_flag,
485: fnd_api.g_miss_char, NULL,
486: x_gsa_indicator_flag),
487: DECODE(x_jgzz_fiscal_code,
488: fnd_api.g_miss_char, NULL,
489: x_jgzz_fiscal_code),
490: DECODE(x_analysis_fy, fnd_api.g_miss_char, NULL, x_analysis_fy),
491: DECODE(x_fiscal_yearend_month,
492: fnd_api.g_miss_char, NULL,
486: x_gsa_indicator_flag),
487: DECODE(x_jgzz_fiscal_code,
488: fnd_api.g_miss_char, NULL,
489: x_jgzz_fiscal_code),
490: DECODE(x_analysis_fy, fnd_api.g_miss_char, NULL, x_analysis_fy),
491: DECODE(x_fiscal_yearend_month,
492: fnd_api.g_miss_char, NULL,
493: x_fiscal_yearend_month),
494: DECODE(x_curr_fy_potential_revenue,
488: fnd_api.g_miss_char, NULL,
489: x_jgzz_fiscal_code),
490: DECODE(x_analysis_fy, fnd_api.g_miss_char, NULL, x_analysis_fy),
491: DECODE(x_fiscal_yearend_month,
492: fnd_api.g_miss_char, NULL,
493: x_fiscal_yearend_month),
494: DECODE(x_curr_fy_potential_revenue,
495: fnd_api.g_miss_num, NULL,
496: x_curr_fy_potential_revenue),
491: DECODE(x_fiscal_yearend_month,
492: fnd_api.g_miss_char, NULL,
493: x_fiscal_yearend_month),
494: DECODE(x_curr_fy_potential_revenue,
495: fnd_api.g_miss_num, NULL,
496: x_curr_fy_potential_revenue),
497: DECODE(x_next_fy_potential_revenue,
498: fnd_api.g_miss_num, NULL,
499: x_next_fy_potential_revenue),
494: DECODE(x_curr_fy_potential_revenue,
495: fnd_api.g_miss_num, NULL,
496: x_curr_fy_potential_revenue),
497: DECODE(x_next_fy_potential_revenue,
498: fnd_api.g_miss_num, NULL,
499: x_next_fy_potential_revenue),
500: DECODE(x_year_established,
501: fnd_api.g_miss_num, NULL,
502: x_year_established),
497: DECODE(x_next_fy_potential_revenue,
498: fnd_api.g_miss_num, NULL,
499: x_next_fy_potential_revenue),
500: DECODE(x_year_established,
501: fnd_api.g_miss_num, NULL,
502: x_year_established),
503: DECODE(x_mission_statement,
504: fnd_api.g_miss_char, NULL,
505: x_mission_statement),
500: DECODE(x_year_established,
501: fnd_api.g_miss_num, NULL,
502: x_year_established),
503: DECODE(x_mission_statement,
504: fnd_api.g_miss_char, NULL,
505: x_mission_statement),
506: DECODE(x_organization_type,
507: fnd_api.g_miss_char, NULL,
508: x_organization_type),
503: DECODE(x_mission_statement,
504: fnd_api.g_miss_char, NULL,
505: x_mission_statement),
506: DECODE(x_organization_type,
507: fnd_api.g_miss_char, NULL,
508: x_organization_type),
509: DECODE(x_business_scope,
510: fnd_api.g_miss_char, NULL,
511: x_business_scope),
506: DECODE(x_organization_type,
507: fnd_api.g_miss_char, NULL,
508: x_organization_type),
509: DECODE(x_business_scope,
510: fnd_api.g_miss_char, NULL,
511: x_business_scope),
512: DECODE(x_corporation_class,
513: fnd_api.g_miss_char, NULL,
514: x_corporation_class),
509: DECODE(x_business_scope,
510: fnd_api.g_miss_char, NULL,
511: x_business_scope),
512: DECODE(x_corporation_class,
513: fnd_api.g_miss_char, NULL,
514: x_corporation_class),
515: DECODE(x_known_as, fnd_api.g_miss_char, NULL, x_known_as),
516: DECODE(x_local_bus_iden_type,
517: fnd_api.g_miss_char, NULL,
511: x_business_scope),
512: DECODE(x_corporation_class,
513: fnd_api.g_miss_char, NULL,
514: x_corporation_class),
515: DECODE(x_known_as, fnd_api.g_miss_char, NULL, x_known_as),
516: DECODE(x_local_bus_iden_type,
517: fnd_api.g_miss_char, NULL,
518: x_local_bus_iden_type),
519: DECODE(x_local_bus_identifier,
513: fnd_api.g_miss_char, NULL,
514: x_corporation_class),
515: DECODE(x_known_as, fnd_api.g_miss_char, NULL, x_known_as),
516: DECODE(x_local_bus_iden_type,
517: fnd_api.g_miss_char, NULL,
518: x_local_bus_iden_type),
519: DECODE(x_local_bus_identifier,
520: fnd_api.g_miss_char, NULL,
521: x_local_bus_identifier),
516: DECODE(x_local_bus_iden_type,
517: fnd_api.g_miss_char, NULL,
518: x_local_bus_iden_type),
519: DECODE(x_local_bus_identifier,
520: fnd_api.g_miss_char, NULL,
521: x_local_bus_identifier),
522: DECODE(x_pref_functional_currency,
523: fnd_api.g_miss_char, NULL,
524: x_pref_functional_currency),
519: DECODE(x_local_bus_identifier,
520: fnd_api.g_miss_char, NULL,
521: x_local_bus_identifier),
522: DECODE(x_pref_functional_currency,
523: fnd_api.g_miss_char, NULL,
524: x_pref_functional_currency),
525: DECODE(x_registration_type,
526: fnd_api.g_miss_char, NULL,
527: x_registration_type),
522: DECODE(x_pref_functional_currency,
523: fnd_api.g_miss_char, NULL,
524: x_pref_functional_currency),
525: DECODE(x_registration_type,
526: fnd_api.g_miss_char, NULL,
527: x_registration_type),
528: DECODE(x_total_employees_text,
529: fnd_api.g_miss_char, NULL,
530: x_total_employees_text),
525: DECODE(x_registration_type,
526: fnd_api.g_miss_char, NULL,
527: x_registration_type),
528: DECODE(x_total_employees_text,
529: fnd_api.g_miss_char, NULL,
530: x_total_employees_text),
531: DECODE(x_total_employees_ind,
532: fnd_api.g_miss_char, NULL,
533: x_total_employees_ind),
528: DECODE(x_total_employees_text,
529: fnd_api.g_miss_char, NULL,
530: x_total_employees_text),
531: DECODE(x_total_employees_ind,
532: fnd_api.g_miss_char, NULL,
533: x_total_employees_ind),
534: DECODE(x_total_emp_est_ind,
535: fnd_api.g_miss_char, NULL,
536: x_total_emp_est_ind),
531: DECODE(x_total_employees_ind,
532: fnd_api.g_miss_char, NULL,
533: x_total_employees_ind),
534: DECODE(x_total_emp_est_ind,
535: fnd_api.g_miss_char, NULL,
536: x_total_emp_est_ind),
537: DECODE(x_total_emp_min_ind,
538: fnd_api.g_miss_char, NULL,
539: x_total_emp_min_ind),
534: DECODE(x_total_emp_est_ind,
535: fnd_api.g_miss_char, NULL,
536: x_total_emp_est_ind),
537: DECODE(x_total_emp_min_ind,
538: fnd_api.g_miss_char, NULL,
539: x_total_emp_min_ind),
540: DECODE(x_parent_sub_ind,
541: fnd_api.g_miss_char, NULL,
542: x_parent_sub_ind),
537: DECODE(x_total_emp_min_ind,
538: fnd_api.g_miss_char, NULL,
539: x_total_emp_min_ind),
540: DECODE(x_parent_sub_ind,
541: fnd_api.g_miss_char, NULL,
542: x_parent_sub_ind),
543: DECODE(x_incorp_year, fnd_api.g_miss_num, NULL, x_incorp_year),
544: hz_utility_v2pub.last_update_date,
545: hz_utility_v2pub.last_updated_by,
539: x_total_emp_min_ind),
540: DECODE(x_parent_sub_ind,
541: fnd_api.g_miss_char, NULL,
542: x_parent_sub_ind),
543: DECODE(x_incorp_year, fnd_api.g_miss_num, NULL, x_incorp_year),
544: hz_utility_v2pub.last_update_date,
545: hz_utility_v2pub.last_updated_by,
546: hz_utility_v2pub.creation_date,
547: hz_utility_v2pub.created_by,
550: hz_utility_v2pub.program_application_id,
551: hz_utility_v2pub.program_id,
552: hz_utility_v2pub.program_update_date,
553: DECODE(x_content_source_type,
554: fnd_api.g_miss_char, g_miss_content_source_type,
555: NULL, g_miss_content_source_type,
556: x_content_source_type),
557: DECODE(x_content_source_number,
558: fnd_api.g_miss_char, NULL,
554: fnd_api.g_miss_char, g_miss_content_source_type,
555: NULL, g_miss_content_source_type,
556: x_content_source_type),
557: DECODE(x_content_source_number,
558: fnd_api.g_miss_char, NULL,
559: x_content_source_number),
560: DECODE(x_effective_start_date,
561: fnd_api.g_miss_date, TRUNC(hz_utility_v2pub.creation_date),
562: NULL, TRUNC(hz_utility_v2pub.creation_date),
557: DECODE(x_content_source_number,
558: fnd_api.g_miss_char, NULL,
559: x_content_source_number),
560: DECODE(x_effective_start_date,
561: fnd_api.g_miss_date, TRUNC(hz_utility_v2pub.creation_date),
562: NULL, TRUNC(hz_utility_v2pub.creation_date),
563: x_effective_start_date),
564: DECODE(x_effective_end_date,
565: fnd_api.g_miss_date, TO_DATE(NULL),
561: fnd_api.g_miss_date, TRUNC(hz_utility_v2pub.creation_date),
562: NULL, TRUNC(hz_utility_v2pub.creation_date),
563: x_effective_start_date),
564: DECODE(x_effective_end_date,
565: fnd_api.g_miss_date, TO_DATE(NULL),
566: x_effective_end_date),
567: DECODE(x_sic_code_type, fnd_api.g_miss_char, NULL, x_sic_code_type),
568: DECODE(x_public_private_ownership,
569: fnd_api.g_miss_char, NULL,
563: x_effective_start_date),
564: DECODE(x_effective_end_date,
565: fnd_api.g_miss_date, TO_DATE(NULL),
566: x_effective_end_date),
567: DECODE(x_sic_code_type, fnd_api.g_miss_char, NULL, x_sic_code_type),
568: DECODE(x_public_private_ownership,
569: fnd_api.g_miss_char, NULL,
570: x_public_private_ownership),
571: DECODE(x_local_activity_code_type,
565: fnd_api.g_miss_date, TO_DATE(NULL),
566: x_effective_end_date),
567: DECODE(x_sic_code_type, fnd_api.g_miss_char, NULL, x_sic_code_type),
568: DECODE(x_public_private_ownership,
569: fnd_api.g_miss_char, NULL,
570: x_public_private_ownership),
571: DECODE(x_local_activity_code_type,
572: fnd_api.g_miss_char, NULL,
573: x_local_activity_code_type),
568: DECODE(x_public_private_ownership,
569: fnd_api.g_miss_char, NULL,
570: x_public_private_ownership),
571: DECODE(x_local_activity_code_type,
572: fnd_api.g_miss_char, NULL,
573: x_local_activity_code_type),
574: DECODE(x_local_activity_code,
575: fnd_api.g_miss_char, NULL,
576: x_local_activity_code),
571: DECODE(x_local_activity_code_type,
572: fnd_api.g_miss_char, NULL,
573: x_local_activity_code_type),
574: DECODE(x_local_activity_code,
575: fnd_api.g_miss_char, NULL,
576: x_local_activity_code),
577: DECODE(x_emp_at_primary_adr,
578: fnd_api.g_miss_char, NULL,
579: x_emp_at_primary_adr),
574: DECODE(x_local_activity_code,
575: fnd_api.g_miss_char, NULL,
576: x_local_activity_code),
577: DECODE(x_emp_at_primary_adr,
578: fnd_api.g_miss_char, NULL,
579: x_emp_at_primary_adr),
580: DECODE(x_emp_at_primary_adr_text,
581: fnd_api.g_miss_char, NULL,
582: x_emp_at_primary_adr_text),
577: DECODE(x_emp_at_primary_adr,
578: fnd_api.g_miss_char, NULL,
579: x_emp_at_primary_adr),
580: DECODE(x_emp_at_primary_adr_text,
581: fnd_api.g_miss_char, NULL,
582: x_emp_at_primary_adr_text),
583: DECODE(x_emp_at_primary_adr_est_ind,
584: fnd_api.g_miss_char, NULL,
585: x_emp_at_primary_adr_est_ind),
580: DECODE(x_emp_at_primary_adr_text,
581: fnd_api.g_miss_char, NULL,
582: x_emp_at_primary_adr_text),
583: DECODE(x_emp_at_primary_adr_est_ind,
584: fnd_api.g_miss_char, NULL,
585: x_emp_at_primary_adr_est_ind),
586: DECODE(x_emp_at_primary_adr_min_ind,
587: fnd_api.g_miss_char, NULL,
588: x_emp_at_primary_adr_min_ind),
583: DECODE(x_emp_at_primary_adr_est_ind,
584: fnd_api.g_miss_char, NULL,
585: x_emp_at_primary_adr_est_ind),
586: DECODE(x_emp_at_primary_adr_min_ind,
587: fnd_api.g_miss_char, NULL,
588: x_emp_at_primary_adr_min_ind),
589: DECODE(x_internal_flag,
590: fnd_api.g_miss_char, 'N',
591: NULL, 'N',
586: DECODE(x_emp_at_primary_adr_min_ind,
587: fnd_api.g_miss_char, NULL,
588: x_emp_at_primary_adr_min_ind),
589: DECODE(x_internal_flag,
590: fnd_api.g_miss_char, 'N',
591: NULL, 'N',
592: x_internal_flag),
593: DECODE(x_high_credit,
594: fnd_api.g_miss_num, NULL,
590: fnd_api.g_miss_char, 'N',
591: NULL, 'N',
592: x_internal_flag),
593: DECODE(x_high_credit,
594: fnd_api.g_miss_num, NULL,
595: x_high_credit),
596: DECODE(x_avg_high_credit,
597: fnd_api.g_miss_num, NULL,
598: x_avg_high_credit),
593: DECODE(x_high_credit,
594: fnd_api.g_miss_num, NULL,
595: x_high_credit),
596: DECODE(x_avg_high_credit,
597: fnd_api.g_miss_num, NULL,
598: x_avg_high_credit),
599: DECODE(x_total_payments,
600: fnd_api.g_miss_num, NULL, x_total_payments),
601: DECODE(x_known_as2, fnd_api.g_miss_char, NULL, x_known_as2),
596: DECODE(x_avg_high_credit,
597: fnd_api.g_miss_num, NULL,
598: x_avg_high_credit),
599: DECODE(x_total_payments,
600: fnd_api.g_miss_num, NULL, x_total_payments),
601: DECODE(x_known_as2, fnd_api.g_miss_char, NULL, x_known_as2),
602: DECODE(x_known_as3, fnd_api.g_miss_char, NULL, x_known_as3),
603: DECODE(x_known_as4, fnd_api.g_miss_char, NULL, x_known_as4),
604: DECODE(x_known_as5, fnd_api.g_miss_char, NULL, x_known_as5),
597: fnd_api.g_miss_num, NULL,
598: x_avg_high_credit),
599: DECODE(x_total_payments,
600: fnd_api.g_miss_num, NULL, x_total_payments),
601: DECODE(x_known_as2, fnd_api.g_miss_char, NULL, x_known_as2),
602: DECODE(x_known_as3, fnd_api.g_miss_char, NULL, x_known_as3),
603: DECODE(x_known_as4, fnd_api.g_miss_char, NULL, x_known_as4),
604: DECODE(x_known_as5, fnd_api.g_miss_char, NULL, x_known_as5),
605: DECODE(x_credit_score_class,
598: x_avg_high_credit),
599: DECODE(x_total_payments,
600: fnd_api.g_miss_num, NULL, x_total_payments),
601: DECODE(x_known_as2, fnd_api.g_miss_char, NULL, x_known_as2),
602: DECODE(x_known_as3, fnd_api.g_miss_char, NULL, x_known_as3),
603: DECODE(x_known_as4, fnd_api.g_miss_char, NULL, x_known_as4),
604: DECODE(x_known_as5, fnd_api.g_miss_char, NULL, x_known_as5),
605: DECODE(x_credit_score_class,
606: fnd_api.g_miss_num, NULL,
599: DECODE(x_total_payments,
600: fnd_api.g_miss_num, NULL, x_total_payments),
601: DECODE(x_known_as2, fnd_api.g_miss_char, NULL, x_known_as2),
602: DECODE(x_known_as3, fnd_api.g_miss_char, NULL, x_known_as3),
603: DECODE(x_known_as4, fnd_api.g_miss_char, NULL, x_known_as4),
604: DECODE(x_known_as5, fnd_api.g_miss_char, NULL, x_known_as5),
605: DECODE(x_credit_score_class,
606: fnd_api.g_miss_num, NULL,
607: x_credit_score_class),
600: fnd_api.g_miss_num, NULL, x_total_payments),
601: DECODE(x_known_as2, fnd_api.g_miss_char, NULL, x_known_as2),
602: DECODE(x_known_as3, fnd_api.g_miss_char, NULL, x_known_as3),
603: DECODE(x_known_as4, fnd_api.g_miss_char, NULL, x_known_as4),
604: DECODE(x_known_as5, fnd_api.g_miss_char, NULL, x_known_as5),
605: DECODE(x_credit_score_class,
606: fnd_api.g_miss_num, NULL,
607: x_credit_score_class),
608: DECODE(x_credit_score_natl_percentile,
602: DECODE(x_known_as3, fnd_api.g_miss_char, NULL, x_known_as3),
603: DECODE(x_known_as4, fnd_api.g_miss_char, NULL, x_known_as4),
604: DECODE(x_known_as5, fnd_api.g_miss_char, NULL, x_known_as5),
605: DECODE(x_credit_score_class,
606: fnd_api.g_miss_num, NULL,
607: x_credit_score_class),
608: DECODE(x_credit_score_natl_percentile,
609: fnd_api.g_miss_num, NULL,
610: x_credit_score_natl_percentile),
605: DECODE(x_credit_score_class,
606: fnd_api.g_miss_num, NULL,
607: x_credit_score_class),
608: DECODE(x_credit_score_natl_percentile,
609: fnd_api.g_miss_num, NULL,
610: x_credit_score_natl_percentile),
611: DECODE(x_credit_score_incd_default,
612: fnd_api.g_miss_num, NULL,
613: x_credit_score_incd_default),
608: DECODE(x_credit_score_natl_percentile,
609: fnd_api.g_miss_num, NULL,
610: x_credit_score_natl_percentile),
611: DECODE(x_credit_score_incd_default,
612: fnd_api.g_miss_num, NULL,
613: x_credit_score_incd_default),
614: DECODE(x_credit_score_age,
615: fnd_api.g_miss_num, NULL,
616: x_credit_score_age),
611: DECODE(x_credit_score_incd_default,
612: fnd_api.g_miss_num, NULL,
613: x_credit_score_incd_default),
614: DECODE(x_credit_score_age,
615: fnd_api.g_miss_num, NULL,
616: x_credit_score_age),
617: DECODE(x_credit_score_date,
618: fnd_api.g_miss_date, TO_DATE(NULL), x_credit_score_date),
619: DECODE(x_failure_score_class,
614: DECODE(x_credit_score_age,
615: fnd_api.g_miss_num, NULL,
616: x_credit_score_age),
617: DECODE(x_credit_score_date,
618: fnd_api.g_miss_date, TO_DATE(NULL), x_credit_score_date),
619: DECODE(x_failure_score_class,
620: fnd_api.g_miss_num, NULL,
621: x_failure_score_class),
622: DECODE(x_failure_score_incd_default,
616: x_credit_score_age),
617: DECODE(x_credit_score_date,
618: fnd_api.g_miss_date, TO_DATE(NULL), x_credit_score_date),
619: DECODE(x_failure_score_class,
620: fnd_api.g_miss_num, NULL,
621: x_failure_score_class),
622: DECODE(x_failure_score_incd_default,
623: fnd_api.g_miss_num, NULL,
624: x_failure_score_incd_default),
619: DECODE(x_failure_score_class,
620: fnd_api.g_miss_num, NULL,
621: x_failure_score_class),
622: DECODE(x_failure_score_incd_default,
623: fnd_api.g_miss_num, NULL,
624: x_failure_score_incd_default),
625: DECODE(x_failure_score_age,
626: fnd_api.g_miss_num, NULL,
627: x_failure_score_age),
622: DECODE(x_failure_score_incd_default,
623: fnd_api.g_miss_num, NULL,
624: x_failure_score_incd_default),
625: DECODE(x_failure_score_age,
626: fnd_api.g_miss_num, NULL,
627: x_failure_score_age),
628: DECODE(x_failure_score_date,
629: fnd_api.g_miss_date, TO_DATE(NULL), x_failure_score_date),
630: DECODE(x_failure_score_commentary2,
625: DECODE(x_failure_score_age,
626: fnd_api.g_miss_num, NULL,
627: x_failure_score_age),
628: DECODE(x_failure_score_date,
629: fnd_api.g_miss_date, TO_DATE(NULL), x_failure_score_date),
630: DECODE(x_failure_score_commentary2,
631: fnd_api.g_miss_char, NULL,
632: x_failure_score_commentary2),
633: DECODE(x_failure_score_commentary3,
627: x_failure_score_age),
628: DECODE(x_failure_score_date,
629: fnd_api.g_miss_date, TO_DATE(NULL), x_failure_score_date),
630: DECODE(x_failure_score_commentary2,
631: fnd_api.g_miss_char, NULL,
632: x_failure_score_commentary2),
633: DECODE(x_failure_score_commentary3,
634: fnd_api.g_miss_char, NULL,
635: x_failure_score_commentary3),
630: DECODE(x_failure_score_commentary2,
631: fnd_api.g_miss_char, NULL,
632: x_failure_score_commentary2),
633: DECODE(x_failure_score_commentary3,
634: fnd_api.g_miss_char, NULL,
635: x_failure_score_commentary3),
636: DECODE(x_failure_score_commentary4,
637: fnd_api.g_miss_char, NULL,
638: x_failure_score_commentary4),
633: DECODE(x_failure_score_commentary3,
634: fnd_api.g_miss_char, NULL,
635: x_failure_score_commentary3),
636: DECODE(x_failure_score_commentary4,
637: fnd_api.g_miss_char, NULL,
638: x_failure_score_commentary4),
639: DECODE(x_failure_score_commentary5,
640: fnd_api.g_miss_char, NULL,
641: x_failure_score_commentary5),
636: DECODE(x_failure_score_commentary4,
637: fnd_api.g_miss_char, NULL,
638: x_failure_score_commentary4),
639: DECODE(x_failure_score_commentary5,
640: fnd_api.g_miss_char, NULL,
641: x_failure_score_commentary5),
642: DECODE(x_failure_score_commentary6,
643: fnd_api.g_miss_char, NULL,
644: x_failure_score_commentary6),
639: DECODE(x_failure_score_commentary5,
640: fnd_api.g_miss_char, NULL,
641: x_failure_score_commentary5),
642: DECODE(x_failure_score_commentary6,
643: fnd_api.g_miss_char, NULL,
644: x_failure_score_commentary6),
645: DECODE(x_failure_score_commentary7,
646: fnd_api.g_miss_char, NULL,
647: x_failure_score_commentary7),
642: DECODE(x_failure_score_commentary6,
643: fnd_api.g_miss_char, NULL,
644: x_failure_score_commentary6),
645: DECODE(x_failure_score_commentary7,
646: fnd_api.g_miss_char, NULL,
647: x_failure_score_commentary7),
648: DECODE(x_failure_score_commentary8,
649: fnd_api.g_miss_char, NULL,
650: x_failure_score_commentary8),
645: DECODE(x_failure_score_commentary7,
646: fnd_api.g_miss_char, NULL,
647: x_failure_score_commentary7),
648: DECODE(x_failure_score_commentary8,
649: fnd_api.g_miss_char, NULL,
650: x_failure_score_commentary8),
651: DECODE(x_failure_score_commentary9,
652: fnd_api.g_miss_char, NULL,
653: x_failure_score_commentary9),
648: DECODE(x_failure_score_commentary8,
649: fnd_api.g_miss_char, NULL,
650: x_failure_score_commentary8),
651: DECODE(x_failure_score_commentary9,
652: fnd_api.g_miss_char, NULL,
653: x_failure_score_commentary9),
654: DECODE(x_failure_score_commentary10,
655: fnd_api.g_miss_char, NULL,
656: x_failure_score_commentary10),
651: DECODE(x_failure_score_commentary9,
652: fnd_api.g_miss_char, NULL,
653: x_failure_score_commentary9),
654: DECODE(x_failure_score_commentary10,
655: fnd_api.g_miss_char, NULL,
656: x_failure_score_commentary10),
657: DECODE(x_credit_score_commentary2,
658: fnd_api.g_miss_char, NULL,
659: x_credit_score_commentary2),
654: DECODE(x_failure_score_commentary10,
655: fnd_api.g_miss_char, NULL,
656: x_failure_score_commentary10),
657: DECODE(x_credit_score_commentary2,
658: fnd_api.g_miss_char, NULL,
659: x_credit_score_commentary2),
660: DECODE(x_credit_score_commentary3,
661: fnd_api.g_miss_char, NULL,
662: x_credit_score_commentary3),
657: DECODE(x_credit_score_commentary2,
658: fnd_api.g_miss_char, NULL,
659: x_credit_score_commentary2),
660: DECODE(x_credit_score_commentary3,
661: fnd_api.g_miss_char, NULL,
662: x_credit_score_commentary3),
663: DECODE(x_credit_score_commentary4,
664: fnd_api.g_miss_char, NULL,
665: x_credit_score_commentary4),
660: DECODE(x_credit_score_commentary3,
661: fnd_api.g_miss_char, NULL,
662: x_credit_score_commentary3),
663: DECODE(x_credit_score_commentary4,
664: fnd_api.g_miss_char, NULL,
665: x_credit_score_commentary4),
666: DECODE(x_credit_score_commentary5,
667: fnd_api.g_miss_char, NULL,
668: x_credit_score_commentary5),
663: DECODE(x_credit_score_commentary4,
664: fnd_api.g_miss_char, NULL,
665: x_credit_score_commentary4),
666: DECODE(x_credit_score_commentary5,
667: fnd_api.g_miss_char, NULL,
668: x_credit_score_commentary5),
669: DECODE(x_credit_score_commentary6,
670: fnd_api.g_miss_char, NULL,
671: x_credit_score_commentary6),
666: DECODE(x_credit_score_commentary5,
667: fnd_api.g_miss_char, NULL,
668: x_credit_score_commentary5),
669: DECODE(x_credit_score_commentary6,
670: fnd_api.g_miss_char, NULL,
671: x_credit_score_commentary6),
672: DECODE(x_credit_score_commentary7,
673: fnd_api.g_miss_char, NULL,
674: x_credit_score_commentary7),
669: DECODE(x_credit_score_commentary6,
670: fnd_api.g_miss_char, NULL,
671: x_credit_score_commentary6),
672: DECODE(x_credit_score_commentary7,
673: fnd_api.g_miss_char, NULL,
674: x_credit_score_commentary7),
675: DECODE(x_credit_score_commentary8,
676: fnd_api.g_miss_char, NULL,
677: x_credit_score_commentary8),
672: DECODE(x_credit_score_commentary7,
673: fnd_api.g_miss_char, NULL,
674: x_credit_score_commentary7),
675: DECODE(x_credit_score_commentary8,
676: fnd_api.g_miss_char, NULL,
677: x_credit_score_commentary8),
678: DECODE(x_credit_score_commentary9,
679: fnd_api.g_miss_char, NULL,
680: x_credit_score_commentary9),
675: DECODE(x_credit_score_commentary8,
676: fnd_api.g_miss_char, NULL,
677: x_credit_score_commentary8),
678: DECODE(x_credit_score_commentary9,
679: fnd_api.g_miss_char, NULL,
680: x_credit_score_commentary9),
681: DECODE(x_credit_score_commentary10,
682: fnd_api.g_miss_char, NULL,
683: x_credit_score_commentary10),
678: DECODE(x_credit_score_commentary9,
679: fnd_api.g_miss_char, NULL,
680: x_credit_score_commentary9),
681: DECODE(x_credit_score_commentary10,
682: fnd_api.g_miss_char, NULL,
683: x_credit_score_commentary10),
684: DECODE(x_maximum_credit_recomm,
685: fnd_api.g_miss_num, NULL,
686: x_maximum_credit_recomm),
681: DECODE(x_credit_score_commentary10,
682: fnd_api.g_miss_char, NULL,
683: x_credit_score_commentary10),
684: DECODE(x_maximum_credit_recomm,
685: fnd_api.g_miss_num, NULL,
686: x_maximum_credit_recomm),
687: DECODE(x_maximum_credit_currency_code,
688: fnd_api.g_miss_char, NULL,
689: x_maximum_credit_currency_code),
684: DECODE(x_maximum_credit_recomm,
685: fnd_api.g_miss_num, NULL,
686: x_maximum_credit_recomm),
687: DECODE(x_maximum_credit_currency_code,
688: fnd_api.g_miss_char, NULL,
689: x_maximum_credit_currency_code),
690: DECODE(x_displayed_duns_party_id,
691: fnd_api.g_miss_num, NULL,
692: x_displayed_duns_party_id),
687: DECODE(x_maximum_credit_currency_code,
688: fnd_api.g_miss_char, NULL,
689: x_maximum_credit_currency_code),
690: DECODE(x_displayed_duns_party_id,
691: fnd_api.g_miss_num, NULL,
692: x_displayed_duns_party_id),
693: DECODE(x_failure_score_natnl_perc,
694: fnd_api.g_miss_num, NULL,
695: x_failure_score_natnl_perc),
690: DECODE(x_displayed_duns_party_id,
691: fnd_api.g_miss_num, NULL,
692: x_displayed_duns_party_id),
693: DECODE(x_failure_score_natnl_perc,
694: fnd_api.g_miss_num, NULL,
695: x_failure_score_natnl_perc),
696: DECODE(x_duns_number_c, fnd_api.g_miss_char, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
697: /* Bug 3435702.This is not necessary because if x_duns_number_c is null or
698: fnd_api.g_miss_char , then l_duns_number will be NULL.
692: x_displayed_duns_party_id),
693: DECODE(x_failure_score_natnl_perc,
694: fnd_api.g_miss_num, NULL,
695: x_failure_score_natnl_perc),
696: DECODE(x_duns_number_c, fnd_api.g_miss_char, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
697: /* Bug 3435702.This is not necessary because if x_duns_number_c is null or
698: fnd_api.g_miss_char , then l_duns_number will be NULL.
699: DECODE(x_duns_number_c, fnd_api.g_miss_char,
700: NULL, NULL, NULL, l_duns_number),*/
694: fnd_api.g_miss_num, NULL,
695: x_failure_score_natnl_perc),
696: DECODE(x_duns_number_c, fnd_api.g_miss_char, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
697: /* Bug 3435702.This is not necessary because if x_duns_number_c is null or
698: fnd_api.g_miss_char , then l_duns_number will be NULL.
699: DECODE(x_duns_number_c, fnd_api.g_miss_char,
700: NULL, NULL, NULL, l_duns_number),*/
701: l_duns_number,
702: DECODE(x_bank_or_branch_number,
695: x_failure_score_natnl_perc),
696: DECODE(x_duns_number_c, fnd_api.g_miss_char, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
697: /* Bug 3435702.This is not necessary because if x_duns_number_c is null or
698: fnd_api.g_miss_char , then l_duns_number will be NULL.
699: DECODE(x_duns_number_c, fnd_api.g_miss_char,
700: NULL, NULL, NULL, l_duns_number),*/
701: l_duns_number,
702: DECODE(x_bank_or_branch_number,
703: fnd_api.g_miss_char, NULL,
699: DECODE(x_duns_number_c, fnd_api.g_miss_char,
700: NULL, NULL, NULL, l_duns_number),*/
701: l_duns_number,
702: DECODE(x_bank_or_branch_number,
703: fnd_api.g_miss_char, NULL,
704: x_bank_or_branch_number),
705: DECODE(x_bank_code, fnd_api.g_miss_char, NULL, x_bank_code),
706: DECODE(x_branch_code, fnd_api.g_miss_char, NULL, x_branch_code),
707: DECODE(x_object_version_number,
701: l_duns_number,
702: DECODE(x_bank_or_branch_number,
703: fnd_api.g_miss_char, NULL,
704: x_bank_or_branch_number),
705: DECODE(x_bank_code, fnd_api.g_miss_char, NULL, x_bank_code),
706: DECODE(x_branch_code, fnd_api.g_miss_char, NULL, x_branch_code),
707: DECODE(x_object_version_number,
708: fnd_api.g_miss_num, NULL,
709: x_object_version_number),
702: DECODE(x_bank_or_branch_number,
703: fnd_api.g_miss_char, NULL,
704: x_bank_or_branch_number),
705: DECODE(x_bank_code, fnd_api.g_miss_char, NULL, x_bank_code),
706: DECODE(x_branch_code, fnd_api.g_miss_char, NULL, x_branch_code),
707: DECODE(x_object_version_number,
708: fnd_api.g_miss_num, NULL,
709: x_object_version_number),
710: DECODE(x_created_by_module,
704: x_bank_or_branch_number),
705: DECODE(x_bank_code, fnd_api.g_miss_char, NULL, x_bank_code),
706: DECODE(x_branch_code, fnd_api.g_miss_char, NULL, x_branch_code),
707: DECODE(x_object_version_number,
708: fnd_api.g_miss_num, NULL,
709: x_object_version_number),
710: DECODE(x_created_by_module,
711: fnd_api.g_miss_char, NULL,
712: x_created_by_module),
707: DECODE(x_object_version_number,
708: fnd_api.g_miss_num, NULL,
709: x_object_version_number),
710: DECODE(x_created_by_module,
711: fnd_api.g_miss_char, NULL,
712: x_created_by_module),
713: DECODE(x_application_id, fnd_api.g_miss_num, NULL, x_application_id ),
714: DECODE(x_do_not_confuse_with, fnd_api.g_miss_char, NULL, x_do_not_confuse_with),
715: DECODE(x_actual_content_source,
709: x_object_version_number),
710: DECODE(x_created_by_module,
711: fnd_api.g_miss_char, NULL,
712: x_created_by_module),
713: DECODE(x_application_id, fnd_api.g_miss_num, NULL, x_application_id ),
714: DECODE(x_do_not_confuse_with, fnd_api.g_miss_char, NULL, x_do_not_confuse_with),
715: DECODE(x_actual_content_source,
716: fnd_api.g_miss_char, g_sst_source_type,
717: NULL, g_sst_source_type,
710: DECODE(x_created_by_module,
711: fnd_api.g_miss_char, NULL,
712: x_created_by_module),
713: DECODE(x_application_id, fnd_api.g_miss_num, NULL, x_application_id ),
714: DECODE(x_do_not_confuse_with, fnd_api.g_miss_char, NULL, x_do_not_confuse_with),
715: DECODE(x_actual_content_source,
716: fnd_api.g_miss_char, g_sst_source_type,
717: NULL, g_sst_source_type,
718: x_actual_content_source),
712: x_created_by_module),
713: DECODE(x_application_id, fnd_api.g_miss_num, NULL, x_application_id ),
714: DECODE(x_do_not_confuse_with, fnd_api.g_miss_char, NULL, x_do_not_confuse_with),
715: DECODE(x_actual_content_source,
716: fnd_api.g_miss_char, g_sst_source_type,
717: NULL, g_sst_source_type,
718: x_actual_content_source),
719: DECODE(x_version_number,fnd_api.g_miss_num, NULL,x_version_number),
720: DECODE(x_home_country, fnd_api.g_miss_char, NULL, x_home_country)
715: DECODE(x_actual_content_source,
716: fnd_api.g_miss_char, g_sst_source_type,
717: NULL, g_sst_source_type,
718: x_actual_content_source),
719: DECODE(x_version_number,fnd_api.g_miss_num, NULL,x_version_number),
720: DECODE(x_home_country, fnd_api.g_miss_char, NULL, x_home_country)
721: ) RETURNING
722: ROWID, organization_profile_id
723: INTO
716: fnd_api.g_miss_char, g_sst_source_type,
717: NULL, g_sst_source_type,
718: x_actual_content_source),
719: DECODE(x_version_number,fnd_api.g_miss_num, NULL,x_version_number),
720: DECODE(x_home_country, fnd_api.g_miss_char, NULL, x_home_country)
721: ) RETURNING
722: ROWID, organization_profile_id
723: INTO
724: x_rowid, x_organization_profile_id;
929: l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;
930: BEGIN
931:
932: IF x_duns_number_c IS NOT NULL AND
933: x_duns_number_c <> FND_API.G_MISS_CHAR
934: THEN
935: l_duns_number := do_copy_duns_number(x_duns_number_c);
936: END IF;
937:
935: l_duns_number := do_copy_duns_number(x_duns_number_c);
936: END IF;
937:
938: IF x_duns_number_c IS NOT NULL AND
939: x_duns_number_c <> FND_API.G_MISS_CHAR AND
940: LENGTHB(x_duns_number_c)<9
941: THEN
942: l_duns_number_c:=lpad(x_duns_number_c,9,'0');
943: END IF;
946: UPDATE hz_organization_profiles hop
947: SET hop.organization_profile_id =
948: DECODE(x_organization_profile_id,
949: NULL, hop.organization_profile_id,
950: fnd_api.g_miss_num, NULL, x_organization_profile_id),
951: hop.party_id =
952: DECODE(x_party_id,
953: NULL, hop.party_id,
954: fnd_api.g_miss_num, NULL,
950: fnd_api.g_miss_num, NULL, x_organization_profile_id),
951: hop.party_id =
952: DECODE(x_party_id,
953: NULL, hop.party_id,
954: fnd_api.g_miss_num, NULL,
955: x_party_id),
956: hop.organization_name =
957: DECODE(x_organization_name,
958: NULL, hop.organization_name,
955: x_party_id),
956: hop.organization_name =
957: DECODE(x_organization_name,
958: NULL, hop.organization_name,
959: fnd_api.g_miss_char, NULL,
960: x_organization_name),
961: hop.attribute_category =
962: DECODE(x_attribute_category,
963: NULL, hop.attribute_category,
960: x_organization_name),
961: hop.attribute_category =
962: DECODE(x_attribute_category,
963: NULL, hop.attribute_category,
964: fnd_api.g_miss_char, NULL,
965: x_attribute_category),
966: hop.attribute1 =
967: DECODE(x_attribute1,
968: NULL, hop.attribute1,
965: x_attribute_category),
966: hop.attribute1 =
967: DECODE(x_attribute1,
968: NULL, hop.attribute1,
969: fnd_api.g_miss_char, NULL,
970: x_attribute1),
971: hop.attribute2 =
972: DECODE(x_attribute2,
973: NULL, hop.attribute2,
970: x_attribute1),
971: hop.attribute2 =
972: DECODE(x_attribute2,
973: NULL, hop.attribute2,
974: fnd_api.g_miss_char, NULL,
975: x_attribute2),
976: hop.attribute3 =
977: DECODE(x_attribute3,
978: NULL, hop.attribute3,
975: x_attribute2),
976: hop.attribute3 =
977: DECODE(x_attribute3,
978: NULL, hop.attribute3,
979: fnd_api.g_miss_char, NULL,
980: x_attribute3),
981: hop.attribute4 =
982: DECODE(x_attribute4,
983: NULL, hop.attribute4,
980: x_attribute3),
981: hop.attribute4 =
982: DECODE(x_attribute4,
983: NULL, hop.attribute4,
984: fnd_api.g_miss_char, NULL,
985: x_attribute4),
986: hop.attribute5 =
987: DECODE(x_attribute5,
988: NULL, hop.attribute5,
985: x_attribute4),
986: hop.attribute5 =
987: DECODE(x_attribute5,
988: NULL, hop.attribute5,
989: fnd_api.g_miss_char, NULL,
990: x_attribute5),
991: hop.attribute6 =
992: DECODE(x_attribute6,
993: NULL, hop.attribute6,
990: x_attribute5),
991: hop.attribute6 =
992: DECODE(x_attribute6,
993: NULL, hop.attribute6,
994: fnd_api.g_miss_char, NULL,
995: x_attribute6),
996: hop.attribute7 =
997: DECODE(x_attribute7,
998: NULL, hop.attribute7,
995: x_attribute6),
996: hop.attribute7 =
997: DECODE(x_attribute7,
998: NULL, hop.attribute7,
999: fnd_api.g_miss_char, NULL,
1000: x_attribute7),
1001: hop.attribute8 =
1002: DECODE(x_attribute8,
1003: NULL, hop.attribute8,
1000: x_attribute7),
1001: hop.attribute8 =
1002: DECODE(x_attribute8,
1003: NULL, hop.attribute8,
1004: fnd_api.g_miss_char, NULL,
1005: x_attribute8),
1006: hop.attribute9 =
1007: DECODE(x_attribute9,
1008: NULL, hop.attribute9,
1005: x_attribute8),
1006: hop.attribute9 =
1007: DECODE(x_attribute9,
1008: NULL, hop.attribute9,
1009: fnd_api.g_miss_char, NULL,
1010: x_attribute9),
1011: hop.attribute10 =
1012: DECODE(x_attribute10,
1013: NULL, hop.attribute10,
1010: x_attribute9),
1011: hop.attribute10 =
1012: DECODE(x_attribute10,
1013: NULL, hop.attribute10,
1014: fnd_api.g_miss_char, NULL,
1015: x_attribute10),
1016: hop.attribute11 =
1017: DECODE(x_attribute11,
1018: NULL, hop.attribute11,
1015: x_attribute10),
1016: hop.attribute11 =
1017: DECODE(x_attribute11,
1018: NULL, hop.attribute11,
1019: fnd_api.g_miss_char, NULL,
1020: x_attribute11),
1021: hop.attribute12 =
1022: DECODE(x_attribute12,
1023: NULL, hop.attribute12,
1020: x_attribute11),
1021: hop.attribute12 =
1022: DECODE(x_attribute12,
1023: NULL, hop.attribute12,
1024: fnd_api.g_miss_char, NULL,
1025: x_attribute12),
1026: hop.attribute13 =
1027: DECODE(x_attribute13,
1028: NULL, hop.attribute13,
1025: x_attribute12),
1026: hop.attribute13 =
1027: DECODE(x_attribute13,
1028: NULL, hop.attribute13,
1029: fnd_api.g_miss_char, NULL,
1030: x_attribute13),
1031: hop.attribute14 =
1032: DECODE(x_attribute14,
1033: NULL, hop.attribute14,
1030: x_attribute13),
1031: hop.attribute14 =
1032: DECODE(x_attribute14,
1033: NULL, hop.attribute14,
1034: fnd_api.g_miss_char, NULL,
1035: x_attribute14),
1036: hop.attribute15 =
1037: DECODE(x_attribute15,
1038: NULL, hop.attribute15,
1035: x_attribute14),
1036: hop.attribute15 =
1037: DECODE(x_attribute15,
1038: NULL, hop.attribute15,
1039: fnd_api.g_miss_char, NULL,
1040: x_attribute15),
1041: hop.attribute16 =
1042: DECODE(x_attribute16,
1043: NULL, hop.attribute16,
1040: x_attribute15),
1041: hop.attribute16 =
1042: DECODE(x_attribute16,
1043: NULL, hop.attribute16,
1044: fnd_api.g_miss_char, NULL,
1045: x_attribute16),
1046: hop.attribute17 =
1047: DECODE(x_attribute17,
1048: NULL, hop.attribute17,
1045: x_attribute16),
1046: hop.attribute17 =
1047: DECODE(x_attribute17,
1048: NULL, hop.attribute17,
1049: fnd_api.g_miss_char, NULL,
1050: x_attribute17),
1051: hop.attribute18 =
1052: DECODE(x_attribute18,
1053: NULL, hop.attribute18,
1050: x_attribute17),
1051: hop.attribute18 =
1052: DECODE(x_attribute18,
1053: NULL, hop.attribute18,
1054: fnd_api.g_miss_char, NULL,
1055: x_attribute18),
1056: hop.attribute19 =
1057: DECODE(x_attribute19,
1058: NULL, hop.attribute19,
1055: x_attribute18),
1056: hop.attribute19 =
1057: DECODE(x_attribute19,
1058: NULL, hop.attribute19,
1059: fnd_api.g_miss_char, NULL,
1060: x_attribute19),
1061: hop.attribute20 =
1062: DECODE(x_attribute20,
1063: NULL, hop.attribute20,
1060: x_attribute19),
1061: hop.attribute20 =
1062: DECODE(x_attribute20,
1063: NULL, hop.attribute20,
1064: fnd_api.g_miss_char, NULL,
1065: x_attribute20),
1066: hop.enquiry_duns =
1067: DECODE(x_enquiry_duns,
1068: NULL, hop.enquiry_duns,
1065: x_attribute20),
1066: hop.enquiry_duns =
1067: DECODE(x_enquiry_duns,
1068: NULL, hop.enquiry_duns,
1069: fnd_api.g_miss_char, NULL,
1070: x_enquiry_duns),
1071: hop.ceo_name =
1072: DECODE(x_ceo_name,
1073: NULL, hop.ceo_name,
1070: x_enquiry_duns),
1071: hop.ceo_name =
1072: DECODE(x_ceo_name,
1073: NULL, hop.ceo_name,
1074: fnd_api.g_miss_char, NULL,
1075: x_ceo_name),
1076: hop.ceo_title =
1077: DECODE(x_ceo_title,
1078: NULL, hop.ceo_title,
1075: x_ceo_name),
1076: hop.ceo_title =
1077: DECODE(x_ceo_title,
1078: NULL, hop.ceo_title,
1079: fnd_api.g_miss_char, NULL,
1080: x_ceo_title),
1081: hop.principal_name =
1082: DECODE(x_principal_name,
1083: NULL, hop.principal_name,
1080: x_ceo_title),
1081: hop.principal_name =
1082: DECODE(x_principal_name,
1083: NULL, hop.principal_name,
1084: fnd_api.g_miss_char, NULL,
1085: x_principal_name),
1086: hop.principal_title =
1087: DECODE(x_principal_title,
1088: NULL, hop.principal_title,
1085: x_principal_name),
1086: hop.principal_title =
1087: DECODE(x_principal_title,
1088: NULL, hop.principal_title,
1089: fnd_api.g_miss_char, NULL,
1090: x_principal_title),
1091: hop.legal_status =
1092: DECODE(x_legal_status,
1093: NULL, hop.legal_status,
1090: x_principal_title),
1091: hop.legal_status =
1092: DECODE(x_legal_status,
1093: NULL, hop.legal_status,
1094: fnd_api.g_miss_char, NULL,
1095: x_legal_status),
1096: hop.control_yr =
1097: DECODE(x_control_yr,
1098: NULL, hop.control_yr,
1095: x_legal_status),
1096: hop.control_yr =
1097: DECODE(x_control_yr,
1098: NULL, hop.control_yr,
1099: fnd_api.g_miss_num, NULL,
1100: x_control_yr),
1101: hop.employees_total =
1102: DECODE(x_employees_total,
1103: NULL, hop.employees_total,
1100: x_control_yr),
1101: hop.employees_total =
1102: DECODE(x_employees_total,
1103: NULL, hop.employees_total,
1104: fnd_api.g_miss_num, NULL,
1105: x_employees_total),
1106: hop.hq_branch_ind =
1107: DECODE(x_hq_branch_ind,
1108: NULL, hop.hq_branch_ind,
1105: x_employees_total),
1106: hop.hq_branch_ind =
1107: DECODE(x_hq_branch_ind,
1108: NULL, hop.hq_branch_ind,
1109: fnd_api.g_miss_char, NULL,
1110: x_hq_branch_ind),
1111: hop.branch_flag =
1112: DECODE(x_branch_flag,
1113: NULL, hop.branch_flag,
1110: x_hq_branch_ind),
1111: hop.branch_flag =
1112: DECODE(x_branch_flag,
1113: NULL, hop.branch_flag,
1114: fnd_api.g_miss_char, NULL,
1115: x_branch_flag),
1116: hop.oob_ind =
1117: DECODE(x_oob_ind,
1118: NULL, hop.oob_ind,
1115: x_branch_flag),
1116: hop.oob_ind =
1117: DECODE(x_oob_ind,
1118: NULL, hop.oob_ind,
1119: fnd_api.g_miss_char, NULL,
1120: x_oob_ind),
1121: hop.line_of_business =
1122: DECODE(x_line_of_business,
1123: NULL, hop.line_of_business,
1120: x_oob_ind),
1121: hop.line_of_business =
1122: DECODE(x_line_of_business,
1123: NULL, hop.line_of_business,
1124: fnd_api.g_miss_char, NULL,
1125: x_line_of_business),
1126: hop.cong_dist_code =
1127: DECODE(x_cong_dist_code,
1128: NULL, hop.cong_dist_code,
1125: x_line_of_business),
1126: hop.cong_dist_code =
1127: DECODE(x_cong_dist_code,
1128: NULL, hop.cong_dist_code,
1129: fnd_api.g_miss_char, NULL,
1130: x_cong_dist_code),
1131: hop.sic_code =
1132: DECODE(x_sic_code,
1133: NULL, hop.sic_code,
1130: x_cong_dist_code),
1131: hop.sic_code =
1132: DECODE(x_sic_code,
1133: NULL, hop.sic_code,
1134: fnd_api.g_miss_char, NULL,
1135: x_sic_code),
1136: hop.import_ind =
1137: DECODE(x_import_ind,
1138: NULL, hop.import_ind,
1135: x_sic_code),
1136: hop.import_ind =
1137: DECODE(x_import_ind,
1138: NULL, hop.import_ind,
1139: fnd_api.g_miss_char, NULL,
1140: x_import_ind),
1141: hop.export_ind =
1142: DECODE(x_export_ind,
1143: NULL, hop.export_ind,
1140: x_import_ind),
1141: hop.export_ind =
1142: DECODE(x_export_ind,
1143: NULL, hop.export_ind,
1144: fnd_api.g_miss_char, NULL,
1145: x_export_ind),
1146: hop.labor_surplus_ind =
1147: DECODE(x_labor_surplus_ind,
1148: NULL, hop.labor_surplus_ind,
1145: x_export_ind),
1146: hop.labor_surplus_ind =
1147: DECODE(x_labor_surplus_ind,
1148: NULL, hop.labor_surplus_ind,
1149: fnd_api.g_miss_char, NULL,
1150: x_labor_surplus_ind),
1151: hop.debarment_ind =
1152: DECODE(x_debarment_ind,
1153: NULL, hop.debarment_ind,
1150: x_labor_surplus_ind),
1151: hop.debarment_ind =
1152: DECODE(x_debarment_ind,
1153: NULL, hop.debarment_ind,
1154: fnd_api.g_miss_char, NULL,
1155: x_debarment_ind),
1156: hop.minority_owned_ind =
1157: DECODE(x_minority_owned_ind,
1158: NULL, hop.minority_owned_ind,
1155: x_debarment_ind),
1156: hop.minority_owned_ind =
1157: DECODE(x_minority_owned_ind,
1158: NULL, hop.minority_owned_ind,
1159: fnd_api.g_miss_char, NULL,
1160: x_minority_owned_ind),
1161: hop.minority_owned_type =
1162: DECODE(x_minority_owned_type,
1163: NULL, hop.minority_owned_type,
1160: x_minority_owned_ind),
1161: hop.minority_owned_type =
1162: DECODE(x_minority_owned_type,
1163: NULL, hop.minority_owned_type,
1164: fnd_api.g_miss_char, NULL,
1165: x_minority_owned_type),
1166: hop.woman_owned_ind =
1167: DECODE(x_woman_owned_ind,
1168: NULL, hop.woman_owned_ind,
1165: x_minority_owned_type),
1166: hop.woman_owned_ind =
1167: DECODE(x_woman_owned_ind,
1168: NULL, hop.woman_owned_ind,
1169: fnd_api.g_miss_char, NULL,
1170: x_woman_owned_ind),
1171: hop.disadv_8a_ind =
1172: DECODE(x_disadv_8a_ind,
1173: NULL, hop.disadv_8a_ind,
1170: x_woman_owned_ind),
1171: hop.disadv_8a_ind =
1172: DECODE(x_disadv_8a_ind,
1173: NULL, hop.disadv_8a_ind,
1174: fnd_api.g_miss_char, NULL,
1175: x_disadv_8a_ind),
1176: hop.small_bus_ind =
1177: DECODE(x_small_bus_ind,
1178: NULL, hop.small_bus_ind,
1175: x_disadv_8a_ind),
1176: hop.small_bus_ind =
1177: DECODE(x_small_bus_ind,
1178: NULL, hop.small_bus_ind,
1179: fnd_api.g_miss_char, NULL,
1180: x_small_bus_ind),
1181: hop.rent_own_ind =
1182: DECODE(x_rent_own_ind,
1183: NULL, hop.rent_own_ind,
1180: x_small_bus_ind),
1181: hop.rent_own_ind =
1182: DECODE(x_rent_own_ind,
1183: NULL, hop.rent_own_ind,
1184: fnd_api.g_miss_char, NULL,
1185: x_rent_own_ind),
1186: hop.debarments_count =
1187: DECODE(x_debarments_count,
1188: NULL, hop.debarments_count,
1185: x_rent_own_ind),
1186: hop.debarments_count =
1187: DECODE(x_debarments_count,
1188: NULL, hop.debarments_count,
1189: fnd_api.g_miss_num, NULL,
1190: x_debarments_count),
1191: hop.debarments_date =
1192: DECODE(x_debarments_date,
1193: NULL, hop.debarments_date,
1190: x_debarments_count),
1191: hop.debarments_date =
1192: DECODE(x_debarments_date,
1193: NULL, hop.debarments_date,
1194: fnd_api.g_miss_date, NULL,
1195: x_debarments_date),
1196: hop.failure_score =
1197: DECODE(x_failure_score,
1198: NULL, hop.failure_score,
1195: x_debarments_date),
1196: hop.failure_score =
1197: DECODE(x_failure_score,
1198: NULL, hop.failure_score,
1199: fnd_api.g_miss_char, NULL,
1200: x_failure_score),
1201: hop.failure_score_override_code =
1202: DECODE(x_failure_score_override_code,
1203: NULL, hop.failure_score_override_code,
1200: x_failure_score),
1201: hop.failure_score_override_code =
1202: DECODE(x_failure_score_override_code,
1203: NULL, hop.failure_score_override_code,
1204: fnd_api.g_miss_char, NULL,
1205: x_failure_score_override_code),
1206: hop.failure_score_commentary =
1207: DECODE(x_failure_score_commentary,
1208: NULL, hop.failure_score_commentary,
1205: x_failure_score_override_code),
1206: hop.failure_score_commentary =
1207: DECODE(x_failure_score_commentary,
1208: NULL, hop.failure_score_commentary,
1209: fnd_api.g_miss_char, NULL,
1210: x_failure_score_commentary),
1211: hop.global_failure_score =
1212: DECODE(x_global_failure_score,
1213: NULL, hop.global_failure_score,
1210: x_failure_score_commentary),
1211: hop.global_failure_score =
1212: DECODE(x_global_failure_score,
1213: NULL, hop.global_failure_score,
1214: fnd_api.g_miss_char, NULL,
1215: x_global_failure_score),
1216: hop.db_rating =
1217: DECODE(x_db_rating,
1218: NULL, hop.db_rating,
1215: x_global_failure_score),
1216: hop.db_rating =
1217: DECODE(x_db_rating,
1218: NULL, hop.db_rating,
1219: fnd_api.g_miss_char, NULL,
1220: x_db_rating),
1221: hop.credit_score =
1222: DECODE(x_credit_score,
1223: NULL, hop.credit_score,
1220: x_db_rating),
1221: hop.credit_score =
1222: DECODE(x_credit_score,
1223: NULL, hop.credit_score,
1224: fnd_api.g_miss_char, NULL,
1225: x_credit_score),
1226: hop.credit_score_commentary =
1227: DECODE(x_credit_score_commentary,
1228: NULL, hop.credit_score_commentary,
1225: x_credit_score),
1226: hop.credit_score_commentary =
1227: DECODE(x_credit_score_commentary,
1228: NULL, hop.credit_score_commentary,
1229: fnd_api.g_miss_char, NULL,
1230: x_credit_score_commentary),
1231: hop.paydex_score =
1232: DECODE(x_paydex_score,
1233: NULL, hop.paydex_score,
1230: x_credit_score_commentary),
1231: hop.paydex_score =
1232: DECODE(x_paydex_score,
1233: NULL, hop.paydex_score,
1234: fnd_api.g_miss_char, NULL,
1235: x_paydex_score),
1236: hop.paydex_three_months_ago =
1237: DECODE(x_paydex_three_months_ago,
1238: NULL, hop.paydex_three_months_ago,
1235: x_paydex_score),
1236: hop.paydex_three_months_ago =
1237: DECODE(x_paydex_three_months_ago,
1238: NULL, hop.paydex_three_months_ago,
1239: fnd_api.g_miss_char, NULL,
1240: x_paydex_three_months_ago),
1241: hop.paydex_norm =
1242: DECODE(x_paydex_norm,
1243: NULL, hop.paydex_norm,
1240: x_paydex_three_months_ago),
1241: hop.paydex_norm =
1242: DECODE(x_paydex_norm,
1243: NULL, hop.paydex_norm,
1244: fnd_api.g_miss_char, NULL,
1245: x_paydex_norm),
1246: hop.best_time_contact_begin =
1247: DECODE(x_best_time_contact_begin,
1248: NULL, hop.best_time_contact_begin,
1245: x_paydex_norm),
1246: hop.best_time_contact_begin =
1247: DECODE(x_best_time_contact_begin,
1248: NULL, hop.best_time_contact_begin,
1249: fnd_api.g_miss_date, NULL,
1250: x_best_time_contact_begin),
1251: hop.best_time_contact_end =
1252: DECODE(x_best_time_contact_end,
1253: NULL, hop.best_time_contact_end,
1250: x_best_time_contact_begin),
1251: hop.best_time_contact_end =
1252: DECODE(x_best_time_contact_end,
1253: NULL, hop.best_time_contact_end,
1254: fnd_api.g_miss_date, NULL,
1255: x_best_time_contact_end),
1256: hop.organization_name_phonetic =
1257: DECODE(x_organization_name_phonetic,
1258: NULL, hop.organization_name_phonetic,
1255: x_best_time_contact_end),
1256: hop.organization_name_phonetic =
1257: DECODE(x_organization_name_phonetic,
1258: NULL, hop.organization_name_phonetic,
1259: fnd_api.g_miss_char, NULL,
1260: x_organization_name_phonetic),
1261: hop.tax_reference =
1262: DECODE(x_tax_reference,
1263: NULL, hop.tax_reference,
1260: x_organization_name_phonetic),
1261: hop.tax_reference =
1262: DECODE(x_tax_reference,
1263: NULL, hop.tax_reference,
1264: fnd_api.g_miss_char, NULL,
1265: x_tax_reference),
1266: hop.gsa_indicator_flag =
1267: DECODE(x_gsa_indicator_flag,
1268: NULL, hop.gsa_indicator_flag,
1265: x_tax_reference),
1266: hop.gsa_indicator_flag =
1267: DECODE(x_gsa_indicator_flag,
1268: NULL, hop.gsa_indicator_flag,
1269: fnd_api.g_miss_char, NULL,
1270: x_gsa_indicator_flag),
1271: hop.jgzz_fiscal_code =
1272: DECODE(x_jgzz_fiscal_code,
1273: NULL, hop.jgzz_fiscal_code,
1270: x_gsa_indicator_flag),
1271: hop.jgzz_fiscal_code =
1272: DECODE(x_jgzz_fiscal_code,
1273: NULL, hop.jgzz_fiscal_code,
1274: fnd_api.g_miss_char, NULL,
1275: x_jgzz_fiscal_code),
1276: hop.analysis_fy =
1277: DECODE(x_analysis_fy,
1278: NULL, hop.analysis_fy,
1275: x_jgzz_fiscal_code),
1276: hop.analysis_fy =
1277: DECODE(x_analysis_fy,
1278: NULL, hop.analysis_fy,
1279: fnd_api.g_miss_char, NULL,
1280: x_analysis_fy),
1281: hop.fiscal_yearend_month =
1282: DECODE(x_fiscal_yearend_month,
1283: NULL, hop.fiscal_yearend_month,
1280: x_analysis_fy),
1281: hop.fiscal_yearend_month =
1282: DECODE(x_fiscal_yearend_month,
1283: NULL, hop.fiscal_yearend_month,
1284: fnd_api.g_miss_char, NULL,
1285: x_fiscal_yearend_month),
1286: hop.curr_fy_potential_revenue =
1287: DECODE(x_curr_fy_potential_revenue,
1288: NULL, hop.curr_fy_potential_revenue,
1285: x_fiscal_yearend_month),
1286: hop.curr_fy_potential_revenue =
1287: DECODE(x_curr_fy_potential_revenue,
1288: NULL, hop.curr_fy_potential_revenue,
1289: fnd_api.g_miss_num, NULL,
1290: x_curr_fy_potential_revenue),
1291: hop.next_fy_potential_revenue =
1292: DECODE(x_next_fy_potential_revenue,
1293: NULL, hop.next_fy_potential_revenue,
1290: x_curr_fy_potential_revenue),
1291: hop.next_fy_potential_revenue =
1292: DECODE(x_next_fy_potential_revenue,
1293: NULL, hop.next_fy_potential_revenue,
1294: fnd_api.g_miss_num, NULL,
1295: x_next_fy_potential_revenue),
1296: hop.year_established =
1297: DECODE(x_year_established,
1298: NULL, hop.year_established,
1295: x_next_fy_potential_revenue),
1296: hop.year_established =
1297: DECODE(x_year_established,
1298: NULL, hop.year_established,
1299: fnd_api.g_miss_num, NULL,
1300: x_year_established),
1301: hop.mission_statement =
1302: DECODE(x_mission_statement,
1303: NULL, hop.mission_statement,
1300: x_year_established),
1301: hop.mission_statement =
1302: DECODE(x_mission_statement,
1303: NULL, hop.mission_statement,
1304: fnd_api.g_miss_char, NULL,
1305: x_mission_statement),
1306: hop.organization_type =
1307: DECODE(x_organization_type,
1308: NULL, hop.organization_type,
1305: x_mission_statement),
1306: hop.organization_type =
1307: DECODE(x_organization_type,
1308: NULL, hop.organization_type,
1309: fnd_api.g_miss_char, NULL,
1310: x_organization_type),
1311: hop.business_scope =
1312: DECODE(x_business_scope,
1313: NULL, hop.business_scope,
1310: x_organization_type),
1311: hop.business_scope =
1312: DECODE(x_business_scope,
1313: NULL, hop.business_scope,
1314: fnd_api.g_miss_char, NULL,
1315: x_business_scope),
1316: hop.corporation_class =
1317: DECODE(x_corporation_class,
1318: NULL, hop.corporation_class,
1315: x_business_scope),
1316: hop.corporation_class =
1317: DECODE(x_corporation_class,
1318: NULL, hop.corporation_class,
1319: fnd_api.g_miss_char, NULL,
1320: x_corporation_class),
1321: hop.known_as =
1322: DECODE(x_known_as,
1323: NULL, hop.known_as,
1320: x_corporation_class),
1321: hop.known_as =
1322: DECODE(x_known_as,
1323: NULL, hop.known_as,
1324: fnd_api.g_miss_char, NULL,
1325: x_known_as),
1326: hop.local_bus_iden_type =
1327: DECODE(x_local_bus_iden_type,
1328: NULL, hop.local_bus_iden_type,
1325: x_known_as),
1326: hop.local_bus_iden_type =
1327: DECODE(x_local_bus_iden_type,
1328: NULL, hop.local_bus_iden_type,
1329: fnd_api.g_miss_char, NULL,
1330: x_local_bus_iden_type),
1331: hop.local_bus_identifier =
1332: DECODE(x_local_bus_identifier,
1333: NULL, hop.local_bus_identifier,
1330: x_local_bus_iden_type),
1331: hop.local_bus_identifier =
1332: DECODE(x_local_bus_identifier,
1333: NULL, hop.local_bus_identifier,
1334: fnd_api.g_miss_char, NULL,
1335: x_local_bus_identifier),
1336: hop.pref_functional_currency =
1337: DECODE(x_pref_functional_currency,
1338: NULL, hop.pref_functional_currency,
1335: x_local_bus_identifier),
1336: hop.pref_functional_currency =
1337: DECODE(x_pref_functional_currency,
1338: NULL, hop.pref_functional_currency,
1339: fnd_api.g_miss_char, NULL,
1340: x_pref_functional_currency),
1341: hop.registration_type =
1342: DECODE(x_registration_type,
1343: NULL, hop.registration_type,
1340: x_pref_functional_currency),
1341: hop.registration_type =
1342: DECODE(x_registration_type,
1343: NULL, hop.registration_type,
1344: fnd_api.g_miss_char, NULL,
1345: x_registration_type),
1346: hop.total_employees_text =
1347: DECODE(x_total_employees_text,
1348: NULL, hop.total_employees_text,
1345: x_registration_type),
1346: hop.total_employees_text =
1347: DECODE(x_total_employees_text,
1348: NULL, hop.total_employees_text,
1349: fnd_api.g_miss_char, NULL,
1350: x_total_employees_text),
1351: hop.total_employees_ind =
1352: DECODE(x_total_employees_ind,
1353: NULL, hop.total_employees_ind,
1350: x_total_employees_text),
1351: hop.total_employees_ind =
1352: DECODE(x_total_employees_ind,
1353: NULL, hop.total_employees_ind,
1354: fnd_api.g_miss_char, NULL,
1355: x_total_employees_ind),
1356: hop.total_emp_est_ind =
1357: DECODE(x_total_emp_est_ind,
1358: NULL, hop.total_emp_est_ind,
1355: x_total_employees_ind),
1356: hop.total_emp_est_ind =
1357: DECODE(x_total_emp_est_ind,
1358: NULL, hop.total_emp_est_ind,
1359: fnd_api.g_miss_char, NULL,
1360: x_total_emp_est_ind),
1361: hop.total_emp_min_ind =
1362: DECODE(x_total_emp_min_ind,
1363: NULL, hop.total_emp_min_ind,
1360: x_total_emp_est_ind),
1361: hop.total_emp_min_ind =
1362: DECODE(x_total_emp_min_ind,
1363: NULL, hop.total_emp_min_ind,
1364: fnd_api.g_miss_char, NULL,
1365: x_total_emp_min_ind),
1366: hop.parent_sub_ind =
1367: DECODE(x_parent_sub_ind,
1368: NULL, hop.parent_sub_ind,
1365: x_total_emp_min_ind),
1366: hop.parent_sub_ind =
1367: DECODE(x_parent_sub_ind,
1368: NULL, hop.parent_sub_ind,
1369: fnd_api.g_miss_char, NULL,
1370: x_parent_sub_ind),
1371: hop.incorp_year =
1372: DECODE(x_incorp_year,
1373: NULL, hop.incorp_year,
1370: x_parent_sub_ind),
1371: hop.incorp_year =
1372: DECODE(x_incorp_year,
1373: NULL, hop.incorp_year,
1374: fnd_api.g_miss_num, NULL,
1375: x_incorp_year),
1376: hop.last_update_date = hz_utility_v2pub.last_update_date,
1377: hop.last_updated_by = hz_utility_v2pub.last_updated_by,
1378: hop.creation_date = creation_date,
1385: hop.program_update_date = hz_utility_v2pub.program_update_date,
1386: hop.content_source_type =
1387: DECODE(x_content_source_type,
1388: NULL, hop.content_source_type,
1389: fnd_api.g_miss_char, NULL,
1390: x_content_source_type),
1391: hop.content_source_number =
1392: DECODE(x_content_source_number,
1393: NULL, hop.content_source_number,
1390: x_content_source_type),
1391: hop.content_source_number =
1392: DECODE(x_content_source_number,
1393: NULL, hop.content_source_number,
1394: fnd_api.g_miss_char, NULL,
1395: x_content_source_number),
1396: hop.effective_start_date =
1397: DECODE(x_effective_start_date,
1398: NULL, hop.effective_start_date,
1395: x_content_source_number),
1396: hop.effective_start_date =
1397: DECODE(x_effective_start_date,
1398: NULL, hop.effective_start_date,
1399: fnd_api.g_miss_date, NULL,
1400: x_effective_start_date),
1401: hop.effective_end_date =
1402: DECODE(x_effective_end_date,
1403: NULL, hop.effective_end_date,
1400: x_effective_start_date),
1401: hop.effective_end_date =
1402: DECODE(x_effective_end_date,
1403: NULL, hop.effective_end_date,
1404: fnd_api.g_miss_date, NULL,
1405: x_effective_end_date),
1406: hop.sic_code_type =
1407: DECODE(x_sic_code_type,
1408: NULL, hop.sic_code_type,
1405: x_effective_end_date),
1406: hop.sic_code_type =
1407: DECODE(x_sic_code_type,
1408: NULL, hop.sic_code_type,
1409: fnd_api.g_miss_char, NULL,
1410: x_sic_code_type),
1411: hop.public_private_ownership_flag =
1412: DECODE(x_public_private_ownership,
1413: NULL, hop.public_private_ownership_flag,
1410: x_sic_code_type),
1411: hop.public_private_ownership_flag =
1412: DECODE(x_public_private_ownership,
1413: NULL, hop.public_private_ownership_flag,
1414: fnd_api.g_miss_char, NULL,
1415: x_public_private_ownership),
1416: hop.local_activity_code_type =
1417: DECODE(x_local_activity_code_type,
1418: NULL, hop.local_activity_code_type,
1415: x_public_private_ownership),
1416: hop.local_activity_code_type =
1417: DECODE(x_local_activity_code_type,
1418: NULL, hop.local_activity_code_type,
1419: fnd_api.g_miss_char, NULL,
1420: x_local_activity_code_type),
1421: hop.local_activity_code =
1422: DECODE(x_local_activity_code,
1423: NULL, hop.local_activity_code,
1420: x_local_activity_code_type),
1421: hop.local_activity_code =
1422: DECODE(x_local_activity_code,
1423: NULL, hop.local_activity_code,
1424: fnd_api.g_miss_char, NULL,
1425: x_local_activity_code),
1426: hop.emp_at_primary_adr =
1427: DECODE(x_emp_at_primary_adr,
1428: NULL, hop.emp_at_primary_adr,
1425: x_local_activity_code),
1426: hop.emp_at_primary_adr =
1427: DECODE(x_emp_at_primary_adr,
1428: NULL, hop.emp_at_primary_adr,
1429: fnd_api.g_miss_char, NULL,
1430: x_emp_at_primary_adr),
1431: hop.emp_at_primary_adr_text =
1432: DECODE(x_emp_at_primary_adr_text,
1433: NULL, hop.emp_at_primary_adr_text,
1430: x_emp_at_primary_adr),
1431: hop.emp_at_primary_adr_text =
1432: DECODE(x_emp_at_primary_adr_text,
1433: NULL, hop.emp_at_primary_adr_text,
1434: fnd_api.g_miss_char, NULL,
1435: x_emp_at_primary_adr_text),
1436: hop.emp_at_primary_adr_est_ind =
1437: DECODE(x_emp_at_primary_adr_est_ind,
1438: NULL, hop.emp_at_primary_adr_est_ind,
1435: x_emp_at_primary_adr_text),
1436: hop.emp_at_primary_adr_est_ind =
1437: DECODE(x_emp_at_primary_adr_est_ind,
1438: NULL, hop.emp_at_primary_adr_est_ind,
1439: fnd_api.g_miss_char, NULL,
1440: x_emp_at_primary_adr_est_ind),
1441: hop.emp_at_primary_adr_min_ind =
1442: DECODE(x_emp_at_primary_adr_min_ind,
1443: NULL, hop.emp_at_primary_adr_min_ind,
1440: x_emp_at_primary_adr_est_ind),
1441: hop.emp_at_primary_adr_min_ind =
1442: DECODE(x_emp_at_primary_adr_min_ind,
1443: NULL, hop.emp_at_primary_adr_min_ind,
1444: fnd_api.g_miss_char, NULL,
1445: x_emp_at_primary_adr_min_ind),
1446: hop.internal_flag =
1447: DECODE(x_internal_flag,
1448: NULL, hop.internal_flag,
1445: x_emp_at_primary_adr_min_ind),
1446: hop.internal_flag =
1447: DECODE(x_internal_flag,
1448: NULL, hop.internal_flag,
1449: fnd_api.g_miss_char, 'N',
1450: x_internal_flag),
1451: hop.high_credit =
1452: DECODE(x_high_credit,
1453: NULL, hop.high_credit,
1450: x_internal_flag),
1451: hop.high_credit =
1452: DECODE(x_high_credit,
1453: NULL, hop.high_credit,
1454: fnd_api.g_miss_num, NULL,
1455: x_high_credit),
1456: hop.avg_high_credit =
1457: DECODE(x_avg_high_credit,
1458: NULL, hop.avg_high_credit,
1455: x_high_credit),
1456: hop.avg_high_credit =
1457: DECODE(x_avg_high_credit,
1458: NULL, hop.avg_high_credit,
1459: fnd_api.g_miss_num, NULL,
1460: x_avg_high_credit),
1461: hop.total_payments =
1462: DECODE(x_total_payments,
1463: NULL, hop.total_payments,
1460: x_avg_high_credit),
1461: hop.total_payments =
1462: DECODE(x_total_payments,
1463: NULL, hop.total_payments,
1464: fnd_api.g_miss_num, NULL,
1465: x_total_payments),
1466: hop.known_as2 =
1467: DECODE(x_known_as2,
1468: NULL, hop.known_as2,
1465: x_total_payments),
1466: hop.known_as2 =
1467: DECODE(x_known_as2,
1468: NULL, hop.known_as2,
1469: fnd_api.g_miss_char, NULL,
1470: x_known_as2),
1471: hop.known_as3 =
1472: DECODE(x_known_as3,
1473: NULL, hop.known_as3,
1470: x_known_as2),
1471: hop.known_as3 =
1472: DECODE(x_known_as3,
1473: NULL, hop.known_as3,
1474: fnd_api.g_miss_char, NULL,
1475: x_known_as3),
1476: hop.known_as4 =
1477: DECODE(x_known_as4,
1478: NULL, hop.known_as4,
1475: x_known_as3),
1476: hop.known_as4 =
1477: DECODE(x_known_as4,
1478: NULL, hop.known_as4,
1479: fnd_api.g_miss_char, NULL,
1480: x_known_as4),
1481: hop.known_as5 =
1482: DECODE(x_known_as5,
1483: NULL, hop.known_as5,
1480: x_known_as4),
1481: hop.known_as5 =
1482: DECODE(x_known_as5,
1483: NULL, hop.known_as5,
1484: fnd_api.g_miss_char, NULL,
1485: x_known_as5),
1486: hop.credit_score_class =
1487: DECODE(x_credit_score_class,
1488: NULL, hop.credit_score_class,
1485: x_known_as5),
1486: hop.credit_score_class =
1487: DECODE(x_credit_score_class,
1488: NULL, hop.credit_score_class,
1489: fnd_api.g_miss_num, NULL,
1490: x_credit_score_class),
1491: hop.credit_score_natl_percentile =
1492: DECODE(x_credit_score_natl_percentile,
1493: NULL, hop.credit_score_natl_percentile,
1490: x_credit_score_class),
1491: hop.credit_score_natl_percentile =
1492: DECODE(x_credit_score_natl_percentile,
1493: NULL, hop.credit_score_natl_percentile,
1494: fnd_api.g_miss_num, NULL,
1495: x_credit_score_natl_percentile),
1496: hop.credit_score_incd_default =
1497: DECODE(x_credit_score_incd_default,
1498: NULL, hop.credit_score_incd_default,
1495: x_credit_score_natl_percentile),
1496: hop.credit_score_incd_default =
1497: DECODE(x_credit_score_incd_default,
1498: NULL, hop.credit_score_incd_default,
1499: fnd_api.g_miss_num, NULL,
1500: x_credit_score_incd_default),
1501: hop.credit_score_age =
1502: DECODE(x_credit_score_age,
1503: NULL, hop.credit_score_age,
1500: x_credit_score_incd_default),
1501: hop.credit_score_age =
1502: DECODE(x_credit_score_age,
1503: NULL, hop.credit_score_age,
1504: fnd_api.g_miss_num, NULL,
1505: x_credit_score_age),
1506: hop.credit_score_date =
1507: DECODE(x_credit_score_date,
1508: NULL, hop.credit_score_date,
1505: x_credit_score_age),
1506: hop.credit_score_date =
1507: DECODE(x_credit_score_date,
1508: NULL, hop.credit_score_date,
1509: fnd_api.g_miss_date, NULL,
1510: x_credit_score_date),
1511: hop.failure_score_class =
1512: DECODE(x_failure_score_class,
1513: NULL, hop.failure_score_class,
1510: x_credit_score_date),
1511: hop.failure_score_class =
1512: DECODE(x_failure_score_class,
1513: NULL, hop.failure_score_class,
1514: fnd_api.g_miss_num, NULL,
1515: x_failure_score_class),
1516: hop.failure_score_incd_default =
1517: DECODE(x_failure_score_incd_default,
1518: NULL, hop.failure_score_incd_default,
1515: x_failure_score_class),
1516: hop.failure_score_incd_default =
1517: DECODE(x_failure_score_incd_default,
1518: NULL, hop.failure_score_incd_default,
1519: fnd_api.g_miss_num, NULL,
1520: x_failure_score_incd_default),
1521: hop.failure_score_age =
1522: DECODE(x_failure_score_age,
1523: NULL, hop.failure_score_age,
1520: x_failure_score_incd_default),
1521: hop.failure_score_age =
1522: DECODE(x_failure_score_age,
1523: NULL, hop.failure_score_age,
1524: fnd_api.g_miss_num, NULL,
1525: x_failure_score_age),
1526: hop.failure_score_date =
1527: DECODE(x_failure_score_date,
1528: NULL, hop.failure_score_date,
1525: x_failure_score_age),
1526: hop.failure_score_date =
1527: DECODE(x_failure_score_date,
1528: NULL, hop.failure_score_date,
1529: fnd_api.g_miss_date, NULL,
1530: x_failure_score_date),
1531: hop.failure_score_commentary2 =
1532: DECODE(x_failure_score_commentary2,
1533: NULL, hop.failure_score_commentary2,
1530: x_failure_score_date),
1531: hop.failure_score_commentary2 =
1532: DECODE(x_failure_score_commentary2,
1533: NULL, hop.failure_score_commentary2,
1534: fnd_api.g_miss_char, NULL,
1535: x_failure_score_commentary2),
1536: hop.failure_score_commentary3 =
1537: DECODE(x_failure_score_commentary3,
1538: NULL, hop.failure_score_commentary3,
1535: x_failure_score_commentary2),
1536: hop.failure_score_commentary3 =
1537: DECODE(x_failure_score_commentary3,
1538: NULL, hop.failure_score_commentary3,
1539: fnd_api.g_miss_char, NULL,
1540: x_failure_score_commentary3),
1541: hop.failure_score_commentary4 =
1542: DECODE(x_failure_score_commentary4,
1543: NULL, hop.failure_score_commentary4,
1540: x_failure_score_commentary3),
1541: hop.failure_score_commentary4 =
1542: DECODE(x_failure_score_commentary4,
1543: NULL, hop.failure_score_commentary4,
1544: fnd_api.g_miss_char, NULL,
1545: x_failure_score_commentary4),
1546: hop.failure_score_commentary5 =
1547: DECODE(x_failure_score_commentary5,
1548: NULL, hop.failure_score_commentary5,
1545: x_failure_score_commentary4),
1546: hop.failure_score_commentary5 =
1547: DECODE(x_failure_score_commentary5,
1548: NULL, hop.failure_score_commentary5,
1549: fnd_api.g_miss_char, NULL,
1550: x_failure_score_commentary5),
1551: hop.failure_score_commentary6 =
1552: DECODE(x_failure_score_commentary6,
1553: NULL, hop.failure_score_commentary6,
1550: x_failure_score_commentary5),
1551: hop.failure_score_commentary6 =
1552: DECODE(x_failure_score_commentary6,
1553: NULL, hop.failure_score_commentary6,
1554: fnd_api.g_miss_char, NULL,
1555: x_failure_score_commentary6),
1556: hop.failure_score_commentary7 =
1557: DECODE(x_failure_score_commentary7,
1558: NULL, hop.failure_score_commentary7,
1555: x_failure_score_commentary6),
1556: hop.failure_score_commentary7 =
1557: DECODE(x_failure_score_commentary7,
1558: NULL, hop.failure_score_commentary7,
1559: fnd_api.g_miss_char, NULL,
1560: x_failure_score_commentary7),
1561: hop.failure_score_commentary8 =
1562: DECODE(x_failure_score_commentary8,
1563: NULL, hop.failure_score_commentary8,
1560: x_failure_score_commentary7),
1561: hop.failure_score_commentary8 =
1562: DECODE(x_failure_score_commentary8,
1563: NULL, hop.failure_score_commentary8,
1564: fnd_api.g_miss_char, NULL,
1565: x_failure_score_commentary8),
1566: hop.failure_score_commentary9 =
1567: DECODE(x_failure_score_commentary9,
1568: NULL, hop.failure_score_commentary9,
1565: x_failure_score_commentary8),
1566: hop.failure_score_commentary9 =
1567: DECODE(x_failure_score_commentary9,
1568: NULL, hop.failure_score_commentary9,
1569: fnd_api.g_miss_char, NULL,
1570: x_failure_score_commentary9),
1571: hop.failure_score_commentary10 =
1572: DECODE(x_failure_score_commentary10,
1573: NULL, hop.failure_score_commentary10,
1570: x_failure_score_commentary9),
1571: hop.failure_score_commentary10 =
1572: DECODE(x_failure_score_commentary10,
1573: NULL, hop.failure_score_commentary10,
1574: fnd_api.g_miss_char, NULL,
1575: x_failure_score_commentary10),
1576: hop.credit_score_commentary2 =
1577: DECODE(x_credit_score_commentary2,
1578: NULL, hop.credit_score_commentary2,
1575: x_failure_score_commentary10),
1576: hop.credit_score_commentary2 =
1577: DECODE(x_credit_score_commentary2,
1578: NULL, hop.credit_score_commentary2,
1579: fnd_api.g_miss_char, NULL,
1580: x_credit_score_commentary2),
1581: hop.credit_score_commentary3 =
1582: DECODE(x_credit_score_commentary3,
1583: NULL, hop.credit_score_commentary3,
1580: x_credit_score_commentary2),
1581: hop.credit_score_commentary3 =
1582: DECODE(x_credit_score_commentary3,
1583: NULL, hop.credit_score_commentary3,
1584: fnd_api.g_miss_char, NULL,
1585: x_credit_score_commentary3),
1586: hop.credit_score_commentary4 =
1587: DECODE(x_credit_score_commentary4,
1588: NULL, hop.credit_score_commentary4,
1585: x_credit_score_commentary3),
1586: hop.credit_score_commentary4 =
1587: DECODE(x_credit_score_commentary4,
1588: NULL, hop.credit_score_commentary4,
1589: fnd_api.g_miss_char, NULL,
1590: x_credit_score_commentary4),
1591: hop.credit_score_commentary5 =
1592: DECODE(x_credit_score_commentary5,
1593: NULL, hop.credit_score_commentary5,
1590: x_credit_score_commentary4),
1591: hop.credit_score_commentary5 =
1592: DECODE(x_credit_score_commentary5,
1593: NULL, hop.credit_score_commentary5,
1594: fnd_api.g_miss_char, NULL,
1595: x_credit_score_commentary5),
1596: hop.credit_score_commentary6 =
1597: DECODE(x_credit_score_commentary6,
1598: NULL, hop.credit_score_commentary6,
1595: x_credit_score_commentary5),
1596: hop.credit_score_commentary6 =
1597: DECODE(x_credit_score_commentary6,
1598: NULL, hop.credit_score_commentary6,
1599: fnd_api.g_miss_char, NULL,
1600: x_credit_score_commentary6),
1601: hop.credit_score_commentary7 =
1602: DECODE(x_credit_score_commentary7,
1603: NULL, hop.credit_score_commentary7,
1600: x_credit_score_commentary6),
1601: hop.credit_score_commentary7 =
1602: DECODE(x_credit_score_commentary7,
1603: NULL, hop.credit_score_commentary7,
1604: fnd_api.g_miss_char, NULL,
1605: x_credit_score_commentary7),
1606: hop.credit_score_commentary8 =
1607: DECODE(x_credit_score_commentary8,
1608: NULL, hop.credit_score_commentary8,
1605: x_credit_score_commentary7),
1606: hop.credit_score_commentary8 =
1607: DECODE(x_credit_score_commentary8,
1608: NULL, hop.credit_score_commentary8,
1609: fnd_api.g_miss_char, NULL,
1610: x_credit_score_commentary8),
1611: hop.credit_score_commentary9 =
1612: DECODE(x_credit_score_commentary9,
1613: NULL, hop.credit_score_commentary9,
1610: x_credit_score_commentary8),
1611: hop.credit_score_commentary9 =
1612: DECODE(x_credit_score_commentary9,
1613: NULL, hop.credit_score_commentary9,
1614: fnd_api.g_miss_char, NULL,
1615: x_credit_score_commentary9),
1616: hop.credit_score_commentary10 =
1617: DECODE(x_credit_score_commentary10,
1618: NULL, hop.credit_score_commentary10,
1615: x_credit_score_commentary9),
1616: hop.credit_score_commentary10 =
1617: DECODE(x_credit_score_commentary10,
1618: NULL, hop.credit_score_commentary10,
1619: fnd_api.g_miss_char, NULL,
1620: x_credit_score_commentary10),
1621: hop.maximum_credit_recommendation =
1622: DECODE(x_maximum_credit_recomm,
1623: NULL, hop.maximum_credit_recommendation,
1620: x_credit_score_commentary10),
1621: hop.maximum_credit_recommendation =
1622: DECODE(x_maximum_credit_recomm,
1623: NULL, hop.maximum_credit_recommendation,
1624: fnd_api.g_miss_num, NULL,
1625: x_maximum_credit_recomm),
1626: hop.maximum_credit_currency_code =
1627: DECODE(x_maximum_credit_currency_code,
1628: NULL, hop.maximum_credit_currency_code,
1625: x_maximum_credit_recomm),
1626: hop.maximum_credit_currency_code =
1627: DECODE(x_maximum_credit_currency_code,
1628: NULL, hop.maximum_credit_currency_code,
1629: fnd_api.g_miss_char, NULL,
1630: x_maximum_credit_currency_code),
1631: hop.displayed_duns_party_id =
1632: DECODE(x_displayed_duns_party_id,
1633: NULL, hop.displayed_duns_party_id,
1630: x_maximum_credit_currency_code),
1631: hop.displayed_duns_party_id =
1632: DECODE(x_displayed_duns_party_id,
1633: NULL, hop.displayed_duns_party_id,
1634: fnd_api.g_miss_num, NULL,
1635: x_displayed_duns_party_id),
1636: hop.failure_score_natnl_percentile =
1637: DECODE(x_failure_score_natnl_perc,
1638: NULL, hop.failure_score_natnl_percentile,
1635: x_displayed_duns_party_id),
1636: hop.failure_score_natnl_percentile =
1637: DECODE(x_failure_score_natnl_perc,
1638: NULL, hop.failure_score_natnl_percentile,
1639: fnd_api.g_miss_num, NULL,
1640: x_failure_score_natnl_perc),
1641: hop.duns_number_c =
1642: DECODE(x_duns_number_c,
1643: NULL, hop.duns_number_c,
1640: x_failure_score_natnl_perc),
1641: hop.duns_number_c =
1642: DECODE(x_duns_number_c,
1643: NULL, hop.duns_number_c,
1644: fnd_api.g_miss_char, NULL,
1645: /*Bug 3435702*/ UPPER(l_duns_number_c)),
1646: hop.duns_number =
1647: DECODE(x_duns_number_c,
1648: NULL, hop.duns_number,
1645: /*Bug 3435702*/ UPPER(l_duns_number_c)),
1646: hop.duns_number =
1647: DECODE(x_duns_number_c,
1648: NULL, hop.duns_number,
1649: /*Bug 3435702.This is redundant because if x_duns_number_c = fnd_api.g_miss_char,
1650: then l_duns_number = NULL.
1651: fnd_api.g_miss_char, NULL,
1652: */
1653: l_duns_number ),
1647: DECODE(x_duns_number_c,
1648: NULL, hop.duns_number,
1649: /*Bug 3435702.This is redundant because if x_duns_number_c = fnd_api.g_miss_char,
1650: then l_duns_number = NULL.
1651: fnd_api.g_miss_char, NULL,
1652: */
1653: l_duns_number ),
1654: hop.object_version_number =
1655: DECODE(x_object_version_number,
1653: l_duns_number ),
1654: hop.object_version_number =
1655: DECODE(x_object_version_number,
1656: NULL, hop.object_version_number,
1657: fnd_api.g_miss_num, NULL,
1658: x_object_version_number),
1659: hop.created_by_module =
1660: DECODE(x_created_by_module,
1661: NULL, hop.created_by_module,
1658: x_object_version_number),
1659: hop.created_by_module =
1660: DECODE(x_created_by_module,
1661: NULL, hop.created_by_module,
1662: fnd_api.g_miss_char, NULL,
1663: x_created_by_module),
1664: hop.application_id =
1665: DECODE(x_application_id,
1666: NULL, hop.application_id,
1663: x_created_by_module),
1664: hop.application_id =
1665: DECODE(x_application_id,
1666: NULL, hop.application_id,
1667: fnd_api.g_miss_num, NULL,
1668: x_application_id),
1669: hop.bank_or_branch_number =
1670: DECODE(x_bank_or_branch_number,
1671: NULL, hop.bank_or_branch_number,
1668: x_application_id),
1669: hop.bank_or_branch_number =
1670: DECODE(x_bank_or_branch_number,
1671: NULL, hop.bank_or_branch_number,
1672: fnd_api.g_miss_char, NULL,
1673: x_bank_or_branch_number),
1674: hop.bank_code =
1675: DECODE(x_bank_code,
1676: NULL, hop.bank_code,
1673: x_bank_or_branch_number),
1674: hop.bank_code =
1675: DECODE(x_bank_code,
1676: NULL, hop.bank_code,
1677: fnd_api.g_miss_char, NULL,
1678: x_bank_code),
1679: hop.branch_code =
1680: DECODE(x_branch_code,
1681: NULL, hop.branch_code,
1678: x_bank_code),
1679: hop.branch_code =
1680: DECODE(x_branch_code,
1681: NULL, hop.branch_code,
1682: fnd_api.g_miss_char, NULL,
1683: x_branch_code),
1684: hop.do_not_confuse_with =
1685: DECODE(x_do_not_confuse_with,
1686: NULL, hop.do_not_confuse_with,
1683: x_branch_code),
1684: hop.do_not_confuse_with =
1685: DECODE(x_do_not_confuse_with,
1686: NULL, hop.do_not_confuse_with,
1687: fnd_api.g_miss_char, NULL,
1688: x_do_not_confuse_with),
1689: hop.actual_content_source =
1690: DECODE(x_actual_content_source,
1691: NULL, hop.actual_content_source,
1688: x_do_not_confuse_with),
1689: hop.actual_content_source =
1690: DECODE(x_actual_content_source,
1691: NULL, hop.actual_content_source,
1692: fnd_api.g_miss_char, NULL,
1693: x_actual_content_source),
1694: hop.version_number =
1695: DECODE(x_version_number,
1696: NULL, hop.version_number,
1693: x_actual_content_source),
1694: hop.version_number =
1695: DECODE(x_version_number,
1696: NULL, hop.version_number,
1697: fnd_api.g_miss_num, NULL,
1698: x_version_number),
1699: hop.home_country =
1700: DECODE(x_home_country,
1701: NULL, hop.home_country,
1698: x_version_number),
1699: hop.home_country =
1700: DECODE(x_home_country,
1701: NULL, hop.home_country,
1702: fnd_api.g_miss_char, NULL,
1703: x_home_country)
1704: WHERE hop.ROWID = x_rowid;
1705:
1706: IF (SQL%NOTFOUND) THEN
2518: x_actual_content_source OUT NOCOPY VARCHAR2,
2519: x_home_country OUT NOCOPY VARCHAR2
2520: ) IS
2521: CURSOR c_orgprof IS
2522: SELECT NVL(hop.organization_profile_id, fnd_api.g_miss_num),
2523: NVL(hop.party_id, fnd_api.g_miss_num),
2524: NVL(hop.organization_name, fnd_api.g_miss_char),
2525: NVL(hop.attribute_category, fnd_api.g_miss_char),
2526: NVL(hop.attribute1, fnd_api.g_miss_char),
2519: x_home_country OUT NOCOPY VARCHAR2
2520: ) IS
2521: CURSOR c_orgprof IS
2522: SELECT NVL(hop.organization_profile_id, fnd_api.g_miss_num),
2523: NVL(hop.party_id, fnd_api.g_miss_num),
2524: NVL(hop.organization_name, fnd_api.g_miss_char),
2525: NVL(hop.attribute_category, fnd_api.g_miss_char),
2526: NVL(hop.attribute1, fnd_api.g_miss_char),
2527: NVL(hop.attribute2, fnd_api.g_miss_char),
2520: ) IS
2521: CURSOR c_orgprof IS
2522: SELECT NVL(hop.organization_profile_id, fnd_api.g_miss_num),
2523: NVL(hop.party_id, fnd_api.g_miss_num),
2524: NVL(hop.organization_name, fnd_api.g_miss_char),
2525: NVL(hop.attribute_category, fnd_api.g_miss_char),
2526: NVL(hop.attribute1, fnd_api.g_miss_char),
2527: NVL(hop.attribute2, fnd_api.g_miss_char),
2528: NVL(hop.attribute3, fnd_api.g_miss_char),
2521: CURSOR c_orgprof IS
2522: SELECT NVL(hop.organization_profile_id, fnd_api.g_miss_num),
2523: NVL(hop.party_id, fnd_api.g_miss_num),
2524: NVL(hop.organization_name, fnd_api.g_miss_char),
2525: NVL(hop.attribute_category, fnd_api.g_miss_char),
2526: NVL(hop.attribute1, fnd_api.g_miss_char),
2527: NVL(hop.attribute2, fnd_api.g_miss_char),
2528: NVL(hop.attribute3, fnd_api.g_miss_char),
2529: NVL(hop.attribute4, fnd_api.g_miss_char),
2522: SELECT NVL(hop.organization_profile_id, fnd_api.g_miss_num),
2523: NVL(hop.party_id, fnd_api.g_miss_num),
2524: NVL(hop.organization_name, fnd_api.g_miss_char),
2525: NVL(hop.attribute_category, fnd_api.g_miss_char),
2526: NVL(hop.attribute1, fnd_api.g_miss_char),
2527: NVL(hop.attribute2, fnd_api.g_miss_char),
2528: NVL(hop.attribute3, fnd_api.g_miss_char),
2529: NVL(hop.attribute4, fnd_api.g_miss_char),
2530: NVL(hop.attribute5, fnd_api.g_miss_char),
2523: NVL(hop.party_id, fnd_api.g_miss_num),
2524: NVL(hop.organization_name, fnd_api.g_miss_char),
2525: NVL(hop.attribute_category, fnd_api.g_miss_char),
2526: NVL(hop.attribute1, fnd_api.g_miss_char),
2527: NVL(hop.attribute2, fnd_api.g_miss_char),
2528: NVL(hop.attribute3, fnd_api.g_miss_char),
2529: NVL(hop.attribute4, fnd_api.g_miss_char),
2530: NVL(hop.attribute5, fnd_api.g_miss_char),
2531: NVL(hop.attribute6, fnd_api.g_miss_char),
2524: NVL(hop.organization_name, fnd_api.g_miss_char),
2525: NVL(hop.attribute_category, fnd_api.g_miss_char),
2526: NVL(hop.attribute1, fnd_api.g_miss_char),
2527: NVL(hop.attribute2, fnd_api.g_miss_char),
2528: NVL(hop.attribute3, fnd_api.g_miss_char),
2529: NVL(hop.attribute4, fnd_api.g_miss_char),
2530: NVL(hop.attribute5, fnd_api.g_miss_char),
2531: NVL(hop.attribute6, fnd_api.g_miss_char),
2532: NVL(hop.attribute7, fnd_api.g_miss_char),
2525: NVL(hop.attribute_category, fnd_api.g_miss_char),
2526: NVL(hop.attribute1, fnd_api.g_miss_char),
2527: NVL(hop.attribute2, fnd_api.g_miss_char),
2528: NVL(hop.attribute3, fnd_api.g_miss_char),
2529: NVL(hop.attribute4, fnd_api.g_miss_char),
2530: NVL(hop.attribute5, fnd_api.g_miss_char),
2531: NVL(hop.attribute6, fnd_api.g_miss_char),
2532: NVL(hop.attribute7, fnd_api.g_miss_char),
2533: NVL(hop.attribute8, fnd_api.g_miss_char),
2526: NVL(hop.attribute1, fnd_api.g_miss_char),
2527: NVL(hop.attribute2, fnd_api.g_miss_char),
2528: NVL(hop.attribute3, fnd_api.g_miss_char),
2529: NVL(hop.attribute4, fnd_api.g_miss_char),
2530: NVL(hop.attribute5, fnd_api.g_miss_char),
2531: NVL(hop.attribute6, fnd_api.g_miss_char),
2532: NVL(hop.attribute7, fnd_api.g_miss_char),
2533: NVL(hop.attribute8, fnd_api.g_miss_char),
2534: NVL(hop.attribute9, fnd_api.g_miss_char),
2527: NVL(hop.attribute2, fnd_api.g_miss_char),
2528: NVL(hop.attribute3, fnd_api.g_miss_char),
2529: NVL(hop.attribute4, fnd_api.g_miss_char),
2530: NVL(hop.attribute5, fnd_api.g_miss_char),
2531: NVL(hop.attribute6, fnd_api.g_miss_char),
2532: NVL(hop.attribute7, fnd_api.g_miss_char),
2533: NVL(hop.attribute8, fnd_api.g_miss_char),
2534: NVL(hop.attribute9, fnd_api.g_miss_char),
2535: NVL(hop.attribute10, fnd_api.g_miss_char),
2528: NVL(hop.attribute3, fnd_api.g_miss_char),
2529: NVL(hop.attribute4, fnd_api.g_miss_char),
2530: NVL(hop.attribute5, fnd_api.g_miss_char),
2531: NVL(hop.attribute6, fnd_api.g_miss_char),
2532: NVL(hop.attribute7, fnd_api.g_miss_char),
2533: NVL(hop.attribute8, fnd_api.g_miss_char),
2534: NVL(hop.attribute9, fnd_api.g_miss_char),
2535: NVL(hop.attribute10, fnd_api.g_miss_char),
2536: NVL(hop.attribute11, fnd_api.g_miss_char),
2529: NVL(hop.attribute4, fnd_api.g_miss_char),
2530: NVL(hop.attribute5, fnd_api.g_miss_char),
2531: NVL(hop.attribute6, fnd_api.g_miss_char),
2532: NVL(hop.attribute7, fnd_api.g_miss_char),
2533: NVL(hop.attribute8, fnd_api.g_miss_char),
2534: NVL(hop.attribute9, fnd_api.g_miss_char),
2535: NVL(hop.attribute10, fnd_api.g_miss_char),
2536: NVL(hop.attribute11, fnd_api.g_miss_char),
2537: NVL(hop.attribute12, fnd_api.g_miss_char),
2530: NVL(hop.attribute5, fnd_api.g_miss_char),
2531: NVL(hop.attribute6, fnd_api.g_miss_char),
2532: NVL(hop.attribute7, fnd_api.g_miss_char),
2533: NVL(hop.attribute8, fnd_api.g_miss_char),
2534: NVL(hop.attribute9, fnd_api.g_miss_char),
2535: NVL(hop.attribute10, fnd_api.g_miss_char),
2536: NVL(hop.attribute11, fnd_api.g_miss_char),
2537: NVL(hop.attribute12, fnd_api.g_miss_char),
2538: NVL(hop.attribute13, fnd_api.g_miss_char),
2531: NVL(hop.attribute6, fnd_api.g_miss_char),
2532: NVL(hop.attribute7, fnd_api.g_miss_char),
2533: NVL(hop.attribute8, fnd_api.g_miss_char),
2534: NVL(hop.attribute9, fnd_api.g_miss_char),
2535: NVL(hop.attribute10, fnd_api.g_miss_char),
2536: NVL(hop.attribute11, fnd_api.g_miss_char),
2537: NVL(hop.attribute12, fnd_api.g_miss_char),
2538: NVL(hop.attribute13, fnd_api.g_miss_char),
2539: NVL(hop.attribute14, fnd_api.g_miss_char),
2532: NVL(hop.attribute7, fnd_api.g_miss_char),
2533: NVL(hop.attribute8, fnd_api.g_miss_char),
2534: NVL(hop.attribute9, fnd_api.g_miss_char),
2535: NVL(hop.attribute10, fnd_api.g_miss_char),
2536: NVL(hop.attribute11, fnd_api.g_miss_char),
2537: NVL(hop.attribute12, fnd_api.g_miss_char),
2538: NVL(hop.attribute13, fnd_api.g_miss_char),
2539: NVL(hop.attribute14, fnd_api.g_miss_char),
2540: NVL(hop.attribute15, fnd_api.g_miss_char),
2533: NVL(hop.attribute8, fnd_api.g_miss_char),
2534: NVL(hop.attribute9, fnd_api.g_miss_char),
2535: NVL(hop.attribute10, fnd_api.g_miss_char),
2536: NVL(hop.attribute11, fnd_api.g_miss_char),
2537: NVL(hop.attribute12, fnd_api.g_miss_char),
2538: NVL(hop.attribute13, fnd_api.g_miss_char),
2539: NVL(hop.attribute14, fnd_api.g_miss_char),
2540: NVL(hop.attribute15, fnd_api.g_miss_char),
2541: NVL(hop.attribute16, fnd_api.g_miss_char),
2534: NVL(hop.attribute9, fnd_api.g_miss_char),
2535: NVL(hop.attribute10, fnd_api.g_miss_char),
2536: NVL(hop.attribute11, fnd_api.g_miss_char),
2537: NVL(hop.attribute12, fnd_api.g_miss_char),
2538: NVL(hop.attribute13, fnd_api.g_miss_char),
2539: NVL(hop.attribute14, fnd_api.g_miss_char),
2540: NVL(hop.attribute15, fnd_api.g_miss_char),
2541: NVL(hop.attribute16, fnd_api.g_miss_char),
2542: NVL(hop.attribute17, fnd_api.g_miss_char),
2535: NVL(hop.attribute10, fnd_api.g_miss_char),
2536: NVL(hop.attribute11, fnd_api.g_miss_char),
2537: NVL(hop.attribute12, fnd_api.g_miss_char),
2538: NVL(hop.attribute13, fnd_api.g_miss_char),
2539: NVL(hop.attribute14, fnd_api.g_miss_char),
2540: NVL(hop.attribute15, fnd_api.g_miss_char),
2541: NVL(hop.attribute16, fnd_api.g_miss_char),
2542: NVL(hop.attribute17, fnd_api.g_miss_char),
2543: NVL(hop.attribute18, fnd_api.g_miss_char),
2536: NVL(hop.attribute11, fnd_api.g_miss_char),
2537: NVL(hop.attribute12, fnd_api.g_miss_char),
2538: NVL(hop.attribute13, fnd_api.g_miss_char),
2539: NVL(hop.attribute14, fnd_api.g_miss_char),
2540: NVL(hop.attribute15, fnd_api.g_miss_char),
2541: NVL(hop.attribute16, fnd_api.g_miss_char),
2542: NVL(hop.attribute17, fnd_api.g_miss_char),
2543: NVL(hop.attribute18, fnd_api.g_miss_char),
2544: NVL(hop.attribute19, fnd_api.g_miss_char),
2537: NVL(hop.attribute12, fnd_api.g_miss_char),
2538: NVL(hop.attribute13, fnd_api.g_miss_char),
2539: NVL(hop.attribute14, fnd_api.g_miss_char),
2540: NVL(hop.attribute15, fnd_api.g_miss_char),
2541: NVL(hop.attribute16, fnd_api.g_miss_char),
2542: NVL(hop.attribute17, fnd_api.g_miss_char),
2543: NVL(hop.attribute18, fnd_api.g_miss_char),
2544: NVL(hop.attribute19, fnd_api.g_miss_char),
2545: NVL(hop.attribute20, fnd_api.g_miss_char),
2538: NVL(hop.attribute13, fnd_api.g_miss_char),
2539: NVL(hop.attribute14, fnd_api.g_miss_char),
2540: NVL(hop.attribute15, fnd_api.g_miss_char),
2541: NVL(hop.attribute16, fnd_api.g_miss_char),
2542: NVL(hop.attribute17, fnd_api.g_miss_char),
2543: NVL(hop.attribute18, fnd_api.g_miss_char),
2544: NVL(hop.attribute19, fnd_api.g_miss_char),
2545: NVL(hop.attribute20, fnd_api.g_miss_char),
2546: NVL(hop.enquiry_duns, fnd_api.g_miss_char),
2539: NVL(hop.attribute14, fnd_api.g_miss_char),
2540: NVL(hop.attribute15, fnd_api.g_miss_char),
2541: NVL(hop.attribute16, fnd_api.g_miss_char),
2542: NVL(hop.attribute17, fnd_api.g_miss_char),
2543: NVL(hop.attribute18, fnd_api.g_miss_char),
2544: NVL(hop.attribute19, fnd_api.g_miss_char),
2545: NVL(hop.attribute20, fnd_api.g_miss_char),
2546: NVL(hop.enquiry_duns, fnd_api.g_miss_char),
2547: NVL(hop.ceo_name, fnd_api.g_miss_char),
2540: NVL(hop.attribute15, fnd_api.g_miss_char),
2541: NVL(hop.attribute16, fnd_api.g_miss_char),
2542: NVL(hop.attribute17, fnd_api.g_miss_char),
2543: NVL(hop.attribute18, fnd_api.g_miss_char),
2544: NVL(hop.attribute19, fnd_api.g_miss_char),
2545: NVL(hop.attribute20, fnd_api.g_miss_char),
2546: NVL(hop.enquiry_duns, fnd_api.g_miss_char),
2547: NVL(hop.ceo_name, fnd_api.g_miss_char),
2548: NVL(hop.ceo_title, fnd_api.g_miss_char),
2541: NVL(hop.attribute16, fnd_api.g_miss_char),
2542: NVL(hop.attribute17, fnd_api.g_miss_char),
2543: NVL(hop.attribute18, fnd_api.g_miss_char),
2544: NVL(hop.attribute19, fnd_api.g_miss_char),
2545: NVL(hop.attribute20, fnd_api.g_miss_char),
2546: NVL(hop.enquiry_duns, fnd_api.g_miss_char),
2547: NVL(hop.ceo_name, fnd_api.g_miss_char),
2548: NVL(hop.ceo_title, fnd_api.g_miss_char),
2549: NVL(hop.principal_name, fnd_api.g_miss_char),
2542: NVL(hop.attribute17, fnd_api.g_miss_char),
2543: NVL(hop.attribute18, fnd_api.g_miss_char),
2544: NVL(hop.attribute19, fnd_api.g_miss_char),
2545: NVL(hop.attribute20, fnd_api.g_miss_char),
2546: NVL(hop.enquiry_duns, fnd_api.g_miss_char),
2547: NVL(hop.ceo_name, fnd_api.g_miss_char),
2548: NVL(hop.ceo_title, fnd_api.g_miss_char),
2549: NVL(hop.principal_name, fnd_api.g_miss_char),
2550: NVL(hop.principal_title, fnd_api.g_miss_char),
2543: NVL(hop.attribute18, fnd_api.g_miss_char),
2544: NVL(hop.attribute19, fnd_api.g_miss_char),
2545: NVL(hop.attribute20, fnd_api.g_miss_char),
2546: NVL(hop.enquiry_duns, fnd_api.g_miss_char),
2547: NVL(hop.ceo_name, fnd_api.g_miss_char),
2548: NVL(hop.ceo_title, fnd_api.g_miss_char),
2549: NVL(hop.principal_name, fnd_api.g_miss_char),
2550: NVL(hop.principal_title, fnd_api.g_miss_char),
2551: NVL(hop.legal_status, fnd_api.g_miss_char),
2544: NVL(hop.attribute19, fnd_api.g_miss_char),
2545: NVL(hop.attribute20, fnd_api.g_miss_char),
2546: NVL(hop.enquiry_duns, fnd_api.g_miss_char),
2547: NVL(hop.ceo_name, fnd_api.g_miss_char),
2548: NVL(hop.ceo_title, fnd_api.g_miss_char),
2549: NVL(hop.principal_name, fnd_api.g_miss_char),
2550: NVL(hop.principal_title, fnd_api.g_miss_char),
2551: NVL(hop.legal_status, fnd_api.g_miss_char),
2552: NVL(hop.control_yr, fnd_api.g_miss_num),
2545: NVL(hop.attribute20, fnd_api.g_miss_char),
2546: NVL(hop.enquiry_duns, fnd_api.g_miss_char),
2547: NVL(hop.ceo_name, fnd_api.g_miss_char),
2548: NVL(hop.ceo_title, fnd_api.g_miss_char),
2549: NVL(hop.principal_name, fnd_api.g_miss_char),
2550: NVL(hop.principal_title, fnd_api.g_miss_char),
2551: NVL(hop.legal_status, fnd_api.g_miss_char),
2552: NVL(hop.control_yr, fnd_api.g_miss_num),
2553: NVL(hop.employees_total, fnd_api.g_miss_num),
2546: NVL(hop.enquiry_duns, fnd_api.g_miss_char),
2547: NVL(hop.ceo_name, fnd_api.g_miss_char),
2548: NVL(hop.ceo_title, fnd_api.g_miss_char),
2549: NVL(hop.principal_name, fnd_api.g_miss_char),
2550: NVL(hop.principal_title, fnd_api.g_miss_char),
2551: NVL(hop.legal_status, fnd_api.g_miss_char),
2552: NVL(hop.control_yr, fnd_api.g_miss_num),
2553: NVL(hop.employees_total, fnd_api.g_miss_num),
2554: NVL(hop.hq_branch_ind, fnd_api.g_miss_char),
2547: NVL(hop.ceo_name, fnd_api.g_miss_char),
2548: NVL(hop.ceo_title, fnd_api.g_miss_char),
2549: NVL(hop.principal_name, fnd_api.g_miss_char),
2550: NVL(hop.principal_title, fnd_api.g_miss_char),
2551: NVL(hop.legal_status, fnd_api.g_miss_char),
2552: NVL(hop.control_yr, fnd_api.g_miss_num),
2553: NVL(hop.employees_total, fnd_api.g_miss_num),
2554: NVL(hop.hq_branch_ind, fnd_api.g_miss_char),
2555: NVL(hop.branch_flag, fnd_api.g_miss_char),
2548: NVL(hop.ceo_title, fnd_api.g_miss_char),
2549: NVL(hop.principal_name, fnd_api.g_miss_char),
2550: NVL(hop.principal_title, fnd_api.g_miss_char),
2551: NVL(hop.legal_status, fnd_api.g_miss_char),
2552: NVL(hop.control_yr, fnd_api.g_miss_num),
2553: NVL(hop.employees_total, fnd_api.g_miss_num),
2554: NVL(hop.hq_branch_ind, fnd_api.g_miss_char),
2555: NVL(hop.branch_flag, fnd_api.g_miss_char),
2556: NVL(hop.oob_ind, fnd_api.g_miss_char),
2549: NVL(hop.principal_name, fnd_api.g_miss_char),
2550: NVL(hop.principal_title, fnd_api.g_miss_char),
2551: NVL(hop.legal_status, fnd_api.g_miss_char),
2552: NVL(hop.control_yr, fnd_api.g_miss_num),
2553: NVL(hop.employees_total, fnd_api.g_miss_num),
2554: NVL(hop.hq_branch_ind, fnd_api.g_miss_char),
2555: NVL(hop.branch_flag, fnd_api.g_miss_char),
2556: NVL(hop.oob_ind, fnd_api.g_miss_char),
2557: NVL(hop.line_of_business, fnd_api.g_miss_char),
2550: NVL(hop.principal_title, fnd_api.g_miss_char),
2551: NVL(hop.legal_status, fnd_api.g_miss_char),
2552: NVL(hop.control_yr, fnd_api.g_miss_num),
2553: NVL(hop.employees_total, fnd_api.g_miss_num),
2554: NVL(hop.hq_branch_ind, fnd_api.g_miss_char),
2555: NVL(hop.branch_flag, fnd_api.g_miss_char),
2556: NVL(hop.oob_ind, fnd_api.g_miss_char),
2557: NVL(hop.line_of_business, fnd_api.g_miss_char),
2558: NVL(hop.cong_dist_code, fnd_api.g_miss_char),
2551: NVL(hop.legal_status, fnd_api.g_miss_char),
2552: NVL(hop.control_yr, fnd_api.g_miss_num),
2553: NVL(hop.employees_total, fnd_api.g_miss_num),
2554: NVL(hop.hq_branch_ind, fnd_api.g_miss_char),
2555: NVL(hop.branch_flag, fnd_api.g_miss_char),
2556: NVL(hop.oob_ind, fnd_api.g_miss_char),
2557: NVL(hop.line_of_business, fnd_api.g_miss_char),
2558: NVL(hop.cong_dist_code, fnd_api.g_miss_char),
2559: NVL(hop.sic_code, fnd_api.g_miss_char),
2552: NVL(hop.control_yr, fnd_api.g_miss_num),
2553: NVL(hop.employees_total, fnd_api.g_miss_num),
2554: NVL(hop.hq_branch_ind, fnd_api.g_miss_char),
2555: NVL(hop.branch_flag, fnd_api.g_miss_char),
2556: NVL(hop.oob_ind, fnd_api.g_miss_char),
2557: NVL(hop.line_of_business, fnd_api.g_miss_char),
2558: NVL(hop.cong_dist_code, fnd_api.g_miss_char),
2559: NVL(hop.sic_code, fnd_api.g_miss_char),
2560: NVL(hop.import_ind, fnd_api.g_miss_char),
2553: NVL(hop.employees_total, fnd_api.g_miss_num),
2554: NVL(hop.hq_branch_ind, fnd_api.g_miss_char),
2555: NVL(hop.branch_flag, fnd_api.g_miss_char),
2556: NVL(hop.oob_ind, fnd_api.g_miss_char),
2557: NVL(hop.line_of_business, fnd_api.g_miss_char),
2558: NVL(hop.cong_dist_code, fnd_api.g_miss_char),
2559: NVL(hop.sic_code, fnd_api.g_miss_char),
2560: NVL(hop.import_ind, fnd_api.g_miss_char),
2561: NVL(hop.export_ind, fnd_api.g_miss_char),
2554: NVL(hop.hq_branch_ind, fnd_api.g_miss_char),
2555: NVL(hop.branch_flag, fnd_api.g_miss_char),
2556: NVL(hop.oob_ind, fnd_api.g_miss_char),
2557: NVL(hop.line_of_business, fnd_api.g_miss_char),
2558: NVL(hop.cong_dist_code, fnd_api.g_miss_char),
2559: NVL(hop.sic_code, fnd_api.g_miss_char),
2560: NVL(hop.import_ind, fnd_api.g_miss_char),
2561: NVL(hop.export_ind, fnd_api.g_miss_char),
2562: NVL(hop.labor_surplus_ind, fnd_api.g_miss_char),
2555: NVL(hop.branch_flag, fnd_api.g_miss_char),
2556: NVL(hop.oob_ind, fnd_api.g_miss_char),
2557: NVL(hop.line_of_business, fnd_api.g_miss_char),
2558: NVL(hop.cong_dist_code, fnd_api.g_miss_char),
2559: NVL(hop.sic_code, fnd_api.g_miss_char),
2560: NVL(hop.import_ind, fnd_api.g_miss_char),
2561: NVL(hop.export_ind, fnd_api.g_miss_char),
2562: NVL(hop.labor_surplus_ind, fnd_api.g_miss_char),
2563: NVL(hop.debarment_ind, fnd_api.g_miss_char),
2556: NVL(hop.oob_ind, fnd_api.g_miss_char),
2557: NVL(hop.line_of_business, fnd_api.g_miss_char),
2558: NVL(hop.cong_dist_code, fnd_api.g_miss_char),
2559: NVL(hop.sic_code, fnd_api.g_miss_char),
2560: NVL(hop.import_ind, fnd_api.g_miss_char),
2561: NVL(hop.export_ind, fnd_api.g_miss_char),
2562: NVL(hop.labor_surplus_ind, fnd_api.g_miss_char),
2563: NVL(hop.debarment_ind, fnd_api.g_miss_char),
2564: NVL(hop.minority_owned_ind, fnd_api.g_miss_char),
2557: NVL(hop.line_of_business, fnd_api.g_miss_char),
2558: NVL(hop.cong_dist_code, fnd_api.g_miss_char),
2559: NVL(hop.sic_code, fnd_api.g_miss_char),
2560: NVL(hop.import_ind, fnd_api.g_miss_char),
2561: NVL(hop.export_ind, fnd_api.g_miss_char),
2562: NVL(hop.labor_surplus_ind, fnd_api.g_miss_char),
2563: NVL(hop.debarment_ind, fnd_api.g_miss_char),
2564: NVL(hop.minority_owned_ind, fnd_api.g_miss_char),
2565: NVL(hop.minority_owned_type, fnd_api.g_miss_char),
2558: NVL(hop.cong_dist_code, fnd_api.g_miss_char),
2559: NVL(hop.sic_code, fnd_api.g_miss_char),
2560: NVL(hop.import_ind, fnd_api.g_miss_char),
2561: NVL(hop.export_ind, fnd_api.g_miss_char),
2562: NVL(hop.labor_surplus_ind, fnd_api.g_miss_char),
2563: NVL(hop.debarment_ind, fnd_api.g_miss_char),
2564: NVL(hop.minority_owned_ind, fnd_api.g_miss_char),
2565: NVL(hop.minority_owned_type, fnd_api.g_miss_char),
2566: NVL(hop.woman_owned_ind, fnd_api.g_miss_char),
2559: NVL(hop.sic_code, fnd_api.g_miss_char),
2560: NVL(hop.import_ind, fnd_api.g_miss_char),
2561: NVL(hop.export_ind, fnd_api.g_miss_char),
2562: NVL(hop.labor_surplus_ind, fnd_api.g_miss_char),
2563: NVL(hop.debarment_ind, fnd_api.g_miss_char),
2564: NVL(hop.minority_owned_ind, fnd_api.g_miss_char),
2565: NVL(hop.minority_owned_type, fnd_api.g_miss_char),
2566: NVL(hop.woman_owned_ind, fnd_api.g_miss_char),
2567: NVL(hop.disadv_8a_ind, fnd_api.g_miss_char),
2560: NVL(hop.import_ind, fnd_api.g_miss_char),
2561: NVL(hop.export_ind, fnd_api.g_miss_char),
2562: NVL(hop.labor_surplus_ind, fnd_api.g_miss_char),
2563: NVL(hop.debarment_ind, fnd_api.g_miss_char),
2564: NVL(hop.minority_owned_ind, fnd_api.g_miss_char),
2565: NVL(hop.minority_owned_type, fnd_api.g_miss_char),
2566: NVL(hop.woman_owned_ind, fnd_api.g_miss_char),
2567: NVL(hop.disadv_8a_ind, fnd_api.g_miss_char),
2568: NVL(hop.small_bus_ind, fnd_api.g_miss_char),
2561: NVL(hop.export_ind, fnd_api.g_miss_char),
2562: NVL(hop.labor_surplus_ind, fnd_api.g_miss_char),
2563: NVL(hop.debarment_ind, fnd_api.g_miss_char),
2564: NVL(hop.minority_owned_ind, fnd_api.g_miss_char),
2565: NVL(hop.minority_owned_type, fnd_api.g_miss_char),
2566: NVL(hop.woman_owned_ind, fnd_api.g_miss_char),
2567: NVL(hop.disadv_8a_ind, fnd_api.g_miss_char),
2568: NVL(hop.small_bus_ind, fnd_api.g_miss_char),
2569: NVL(hop.rent_own_ind, fnd_api.g_miss_char),
2562: NVL(hop.labor_surplus_ind, fnd_api.g_miss_char),
2563: NVL(hop.debarment_ind, fnd_api.g_miss_char),
2564: NVL(hop.minority_owned_ind, fnd_api.g_miss_char),
2565: NVL(hop.minority_owned_type, fnd_api.g_miss_char),
2566: NVL(hop.woman_owned_ind, fnd_api.g_miss_char),
2567: NVL(hop.disadv_8a_ind, fnd_api.g_miss_char),
2568: NVL(hop.small_bus_ind, fnd_api.g_miss_char),
2569: NVL(hop.rent_own_ind, fnd_api.g_miss_char),
2570: NVL(hop.debarments_count, fnd_api.g_miss_num),
2563: NVL(hop.debarment_ind, fnd_api.g_miss_char),
2564: NVL(hop.minority_owned_ind, fnd_api.g_miss_char),
2565: NVL(hop.minority_owned_type, fnd_api.g_miss_char),
2566: NVL(hop.woman_owned_ind, fnd_api.g_miss_char),
2567: NVL(hop.disadv_8a_ind, fnd_api.g_miss_char),
2568: NVL(hop.small_bus_ind, fnd_api.g_miss_char),
2569: NVL(hop.rent_own_ind, fnd_api.g_miss_char),
2570: NVL(hop.debarments_count, fnd_api.g_miss_num),
2571: NVL(hop.debarments_date, fnd_api.g_miss_date),
2564: NVL(hop.minority_owned_ind, fnd_api.g_miss_char),
2565: NVL(hop.minority_owned_type, fnd_api.g_miss_char),
2566: NVL(hop.woman_owned_ind, fnd_api.g_miss_char),
2567: NVL(hop.disadv_8a_ind, fnd_api.g_miss_char),
2568: NVL(hop.small_bus_ind, fnd_api.g_miss_char),
2569: NVL(hop.rent_own_ind, fnd_api.g_miss_char),
2570: NVL(hop.debarments_count, fnd_api.g_miss_num),
2571: NVL(hop.debarments_date, fnd_api.g_miss_date),
2572: NVL(hop.failure_score, fnd_api.g_miss_char),
2565: NVL(hop.minority_owned_type, fnd_api.g_miss_char),
2566: NVL(hop.woman_owned_ind, fnd_api.g_miss_char),
2567: NVL(hop.disadv_8a_ind, fnd_api.g_miss_char),
2568: NVL(hop.small_bus_ind, fnd_api.g_miss_char),
2569: NVL(hop.rent_own_ind, fnd_api.g_miss_char),
2570: NVL(hop.debarments_count, fnd_api.g_miss_num),
2571: NVL(hop.debarments_date, fnd_api.g_miss_date),
2572: NVL(hop.failure_score, fnd_api.g_miss_char),
2573: NVL(hop.failure_score_override_code, fnd_api.g_miss_char),
2566: NVL(hop.woman_owned_ind, fnd_api.g_miss_char),
2567: NVL(hop.disadv_8a_ind, fnd_api.g_miss_char),
2568: NVL(hop.small_bus_ind, fnd_api.g_miss_char),
2569: NVL(hop.rent_own_ind, fnd_api.g_miss_char),
2570: NVL(hop.debarments_count, fnd_api.g_miss_num),
2571: NVL(hop.debarments_date, fnd_api.g_miss_date),
2572: NVL(hop.failure_score, fnd_api.g_miss_char),
2573: NVL(hop.failure_score_override_code, fnd_api.g_miss_char),
2574: NVL(hop.failure_score_commentary, fnd_api.g_miss_char),
2567: NVL(hop.disadv_8a_ind, fnd_api.g_miss_char),
2568: NVL(hop.small_bus_ind, fnd_api.g_miss_char),
2569: NVL(hop.rent_own_ind, fnd_api.g_miss_char),
2570: NVL(hop.debarments_count, fnd_api.g_miss_num),
2571: NVL(hop.debarments_date, fnd_api.g_miss_date),
2572: NVL(hop.failure_score, fnd_api.g_miss_char),
2573: NVL(hop.failure_score_override_code, fnd_api.g_miss_char),
2574: NVL(hop.failure_score_commentary, fnd_api.g_miss_char),
2575: NVL(hop.global_failure_score, fnd_api.g_miss_char),
2568: NVL(hop.small_bus_ind, fnd_api.g_miss_char),
2569: NVL(hop.rent_own_ind, fnd_api.g_miss_char),
2570: NVL(hop.debarments_count, fnd_api.g_miss_num),
2571: NVL(hop.debarments_date, fnd_api.g_miss_date),
2572: NVL(hop.failure_score, fnd_api.g_miss_char),
2573: NVL(hop.failure_score_override_code, fnd_api.g_miss_char),
2574: NVL(hop.failure_score_commentary, fnd_api.g_miss_char),
2575: NVL(hop.global_failure_score, fnd_api.g_miss_char),
2576: NVL(hop.db_rating, fnd_api.g_miss_char),
2569: NVL(hop.rent_own_ind, fnd_api.g_miss_char),
2570: NVL(hop.debarments_count, fnd_api.g_miss_num),
2571: NVL(hop.debarments_date, fnd_api.g_miss_date),
2572: NVL(hop.failure_score, fnd_api.g_miss_char),
2573: NVL(hop.failure_score_override_code, fnd_api.g_miss_char),
2574: NVL(hop.failure_score_commentary, fnd_api.g_miss_char),
2575: NVL(hop.global_failure_score, fnd_api.g_miss_char),
2576: NVL(hop.db_rating, fnd_api.g_miss_char),
2577: NVL(hop.credit_score, fnd_api.g_miss_char),
2570: NVL(hop.debarments_count, fnd_api.g_miss_num),
2571: NVL(hop.debarments_date, fnd_api.g_miss_date),
2572: NVL(hop.failure_score, fnd_api.g_miss_char),
2573: NVL(hop.failure_score_override_code, fnd_api.g_miss_char),
2574: NVL(hop.failure_score_commentary, fnd_api.g_miss_char),
2575: NVL(hop.global_failure_score, fnd_api.g_miss_char),
2576: NVL(hop.db_rating, fnd_api.g_miss_char),
2577: NVL(hop.credit_score, fnd_api.g_miss_char),
2578: NVL(hop.credit_score_commentary, fnd_api.g_miss_char),
2571: NVL(hop.debarments_date, fnd_api.g_miss_date),
2572: NVL(hop.failure_score, fnd_api.g_miss_char),
2573: NVL(hop.failure_score_override_code, fnd_api.g_miss_char),
2574: NVL(hop.failure_score_commentary, fnd_api.g_miss_char),
2575: NVL(hop.global_failure_score, fnd_api.g_miss_char),
2576: NVL(hop.db_rating, fnd_api.g_miss_char),
2577: NVL(hop.credit_score, fnd_api.g_miss_char),
2578: NVL(hop.credit_score_commentary, fnd_api.g_miss_char),
2579: NVL(hop.paydex_score, fnd_api.g_miss_char),
2572: NVL(hop.failure_score, fnd_api.g_miss_char),
2573: NVL(hop.failure_score_override_code, fnd_api.g_miss_char),
2574: NVL(hop.failure_score_commentary, fnd_api.g_miss_char),
2575: NVL(hop.global_failure_score, fnd_api.g_miss_char),
2576: NVL(hop.db_rating, fnd_api.g_miss_char),
2577: NVL(hop.credit_score, fnd_api.g_miss_char),
2578: NVL(hop.credit_score_commentary, fnd_api.g_miss_char),
2579: NVL(hop.paydex_score, fnd_api.g_miss_char),
2580: NVL(hop.paydex_three_months_ago, fnd_api.g_miss_char),
2573: NVL(hop.failure_score_override_code, fnd_api.g_miss_char),
2574: NVL(hop.failure_score_commentary, fnd_api.g_miss_char),
2575: NVL(hop.global_failure_score, fnd_api.g_miss_char),
2576: NVL(hop.db_rating, fnd_api.g_miss_char),
2577: NVL(hop.credit_score, fnd_api.g_miss_char),
2578: NVL(hop.credit_score_commentary, fnd_api.g_miss_char),
2579: NVL(hop.paydex_score, fnd_api.g_miss_char),
2580: NVL(hop.paydex_three_months_ago, fnd_api.g_miss_char),
2581: NVL(hop.paydex_norm, fnd_api.g_miss_char),
2574: NVL(hop.failure_score_commentary, fnd_api.g_miss_char),
2575: NVL(hop.global_failure_score, fnd_api.g_miss_char),
2576: NVL(hop.db_rating, fnd_api.g_miss_char),
2577: NVL(hop.credit_score, fnd_api.g_miss_char),
2578: NVL(hop.credit_score_commentary, fnd_api.g_miss_char),
2579: NVL(hop.paydex_score, fnd_api.g_miss_char),
2580: NVL(hop.paydex_three_months_ago, fnd_api.g_miss_char),
2581: NVL(hop.paydex_norm, fnd_api.g_miss_char),
2582: NVL(hop.best_time_contact_begin, fnd_api.g_miss_date),
2575: NVL(hop.global_failure_score, fnd_api.g_miss_char),
2576: NVL(hop.db_rating, fnd_api.g_miss_char),
2577: NVL(hop.credit_score, fnd_api.g_miss_char),
2578: NVL(hop.credit_score_commentary, fnd_api.g_miss_char),
2579: NVL(hop.paydex_score, fnd_api.g_miss_char),
2580: NVL(hop.paydex_three_months_ago, fnd_api.g_miss_char),
2581: NVL(hop.paydex_norm, fnd_api.g_miss_char),
2582: NVL(hop.best_time_contact_begin, fnd_api.g_miss_date),
2583: NVL(hop.best_time_contact_end, fnd_api.g_miss_date),
2576: NVL(hop.db_rating, fnd_api.g_miss_char),
2577: NVL(hop.credit_score, fnd_api.g_miss_char),
2578: NVL(hop.credit_score_commentary, fnd_api.g_miss_char),
2579: NVL(hop.paydex_score, fnd_api.g_miss_char),
2580: NVL(hop.paydex_three_months_ago, fnd_api.g_miss_char),
2581: NVL(hop.paydex_norm, fnd_api.g_miss_char),
2582: NVL(hop.best_time_contact_begin, fnd_api.g_miss_date),
2583: NVL(hop.best_time_contact_end, fnd_api.g_miss_date),
2584: NVL(hop.organization_name_phonetic, fnd_api.g_miss_char),
2577: NVL(hop.credit_score, fnd_api.g_miss_char),
2578: NVL(hop.credit_score_commentary, fnd_api.g_miss_char),
2579: NVL(hop.paydex_score, fnd_api.g_miss_char),
2580: NVL(hop.paydex_three_months_ago, fnd_api.g_miss_char),
2581: NVL(hop.paydex_norm, fnd_api.g_miss_char),
2582: NVL(hop.best_time_contact_begin, fnd_api.g_miss_date),
2583: NVL(hop.best_time_contact_end, fnd_api.g_miss_date),
2584: NVL(hop.organization_name_phonetic, fnd_api.g_miss_char),
2585: NVL(hop.tax_reference, fnd_api.g_miss_char),
2578: NVL(hop.credit_score_commentary, fnd_api.g_miss_char),
2579: NVL(hop.paydex_score, fnd_api.g_miss_char),
2580: NVL(hop.paydex_three_months_ago, fnd_api.g_miss_char),
2581: NVL(hop.paydex_norm, fnd_api.g_miss_char),
2582: NVL(hop.best_time_contact_begin, fnd_api.g_miss_date),
2583: NVL(hop.best_time_contact_end, fnd_api.g_miss_date),
2584: NVL(hop.organization_name_phonetic, fnd_api.g_miss_char),
2585: NVL(hop.tax_reference, fnd_api.g_miss_char),
2586: NVL(hop.gsa_indicator_flag, fnd_api.g_miss_char),
2579: NVL(hop.paydex_score, fnd_api.g_miss_char),
2580: NVL(hop.paydex_three_months_ago, fnd_api.g_miss_char),
2581: NVL(hop.paydex_norm, fnd_api.g_miss_char),
2582: NVL(hop.best_time_contact_begin, fnd_api.g_miss_date),
2583: NVL(hop.best_time_contact_end, fnd_api.g_miss_date),
2584: NVL(hop.organization_name_phonetic, fnd_api.g_miss_char),
2585: NVL(hop.tax_reference, fnd_api.g_miss_char),
2586: NVL(hop.gsa_indicator_flag, fnd_api.g_miss_char),
2587: NVL(hop.jgzz_fiscal_code, fnd_api.g_miss_char),
2580: NVL(hop.paydex_three_months_ago, fnd_api.g_miss_char),
2581: NVL(hop.paydex_norm, fnd_api.g_miss_char),
2582: NVL(hop.best_time_contact_begin, fnd_api.g_miss_date),
2583: NVL(hop.best_time_contact_end, fnd_api.g_miss_date),
2584: NVL(hop.organization_name_phonetic, fnd_api.g_miss_char),
2585: NVL(hop.tax_reference, fnd_api.g_miss_char),
2586: NVL(hop.gsa_indicator_flag, fnd_api.g_miss_char),
2587: NVL(hop.jgzz_fiscal_code, fnd_api.g_miss_char),
2588: NVL(hop.analysis_fy, fnd_api.g_miss_char),
2581: NVL(hop.paydex_norm, fnd_api.g_miss_char),
2582: NVL(hop.best_time_contact_begin, fnd_api.g_miss_date),
2583: NVL(hop.best_time_contact_end, fnd_api.g_miss_date),
2584: NVL(hop.organization_name_phonetic, fnd_api.g_miss_char),
2585: NVL(hop.tax_reference, fnd_api.g_miss_char),
2586: NVL(hop.gsa_indicator_flag, fnd_api.g_miss_char),
2587: NVL(hop.jgzz_fiscal_code, fnd_api.g_miss_char),
2588: NVL(hop.analysis_fy, fnd_api.g_miss_char),
2589: NVL(hop.fiscal_yearend_month, fnd_api.g_miss_char),
2582: NVL(hop.best_time_contact_begin, fnd_api.g_miss_date),
2583: NVL(hop.best_time_contact_end, fnd_api.g_miss_date),
2584: NVL(hop.organization_name_phonetic, fnd_api.g_miss_char),
2585: NVL(hop.tax_reference, fnd_api.g_miss_char),
2586: NVL(hop.gsa_indicator_flag, fnd_api.g_miss_char),
2587: NVL(hop.jgzz_fiscal_code, fnd_api.g_miss_char),
2588: NVL(hop.analysis_fy, fnd_api.g_miss_char),
2589: NVL(hop.fiscal_yearend_month, fnd_api.g_miss_char),
2590: NVL(hop.curr_fy_potential_revenue, fnd_api.g_miss_num),
2583: NVL(hop.best_time_contact_end, fnd_api.g_miss_date),
2584: NVL(hop.organization_name_phonetic, fnd_api.g_miss_char),
2585: NVL(hop.tax_reference, fnd_api.g_miss_char),
2586: NVL(hop.gsa_indicator_flag, fnd_api.g_miss_char),
2587: NVL(hop.jgzz_fiscal_code, fnd_api.g_miss_char),
2588: NVL(hop.analysis_fy, fnd_api.g_miss_char),
2589: NVL(hop.fiscal_yearend_month, fnd_api.g_miss_char),
2590: NVL(hop.curr_fy_potential_revenue, fnd_api.g_miss_num),
2591: NVL(hop.next_fy_potential_revenue, fnd_api.g_miss_num),
2584: NVL(hop.organization_name_phonetic, fnd_api.g_miss_char),
2585: NVL(hop.tax_reference, fnd_api.g_miss_char),
2586: NVL(hop.gsa_indicator_flag, fnd_api.g_miss_char),
2587: NVL(hop.jgzz_fiscal_code, fnd_api.g_miss_char),
2588: NVL(hop.analysis_fy, fnd_api.g_miss_char),
2589: NVL(hop.fiscal_yearend_month, fnd_api.g_miss_char),
2590: NVL(hop.curr_fy_potential_revenue, fnd_api.g_miss_num),
2591: NVL(hop.next_fy_potential_revenue, fnd_api.g_miss_num),
2592: NVL(hop.year_established, fnd_api.g_miss_num),
2585: NVL(hop.tax_reference, fnd_api.g_miss_char),
2586: NVL(hop.gsa_indicator_flag, fnd_api.g_miss_char),
2587: NVL(hop.jgzz_fiscal_code, fnd_api.g_miss_char),
2588: NVL(hop.analysis_fy, fnd_api.g_miss_char),
2589: NVL(hop.fiscal_yearend_month, fnd_api.g_miss_char),
2590: NVL(hop.curr_fy_potential_revenue, fnd_api.g_miss_num),
2591: NVL(hop.next_fy_potential_revenue, fnd_api.g_miss_num),
2592: NVL(hop.year_established, fnd_api.g_miss_num),
2593: NVL(hop.mission_statement, fnd_api.g_miss_char),
2586: NVL(hop.gsa_indicator_flag, fnd_api.g_miss_char),
2587: NVL(hop.jgzz_fiscal_code, fnd_api.g_miss_char),
2588: NVL(hop.analysis_fy, fnd_api.g_miss_char),
2589: NVL(hop.fiscal_yearend_month, fnd_api.g_miss_char),
2590: NVL(hop.curr_fy_potential_revenue, fnd_api.g_miss_num),
2591: NVL(hop.next_fy_potential_revenue, fnd_api.g_miss_num),
2592: NVL(hop.year_established, fnd_api.g_miss_num),
2593: NVL(hop.mission_statement, fnd_api.g_miss_char),
2594: NVL(hop.organization_type, fnd_api.g_miss_char),
2587: NVL(hop.jgzz_fiscal_code, fnd_api.g_miss_char),
2588: NVL(hop.analysis_fy, fnd_api.g_miss_char),
2589: NVL(hop.fiscal_yearend_month, fnd_api.g_miss_char),
2590: NVL(hop.curr_fy_potential_revenue, fnd_api.g_miss_num),
2591: NVL(hop.next_fy_potential_revenue, fnd_api.g_miss_num),
2592: NVL(hop.year_established, fnd_api.g_miss_num),
2593: NVL(hop.mission_statement, fnd_api.g_miss_char),
2594: NVL(hop.organization_type, fnd_api.g_miss_char),
2595: NVL(hop.business_scope, fnd_api.g_miss_char),
2588: NVL(hop.analysis_fy, fnd_api.g_miss_char),
2589: NVL(hop.fiscal_yearend_month, fnd_api.g_miss_char),
2590: NVL(hop.curr_fy_potential_revenue, fnd_api.g_miss_num),
2591: NVL(hop.next_fy_potential_revenue, fnd_api.g_miss_num),
2592: NVL(hop.year_established, fnd_api.g_miss_num),
2593: NVL(hop.mission_statement, fnd_api.g_miss_char),
2594: NVL(hop.organization_type, fnd_api.g_miss_char),
2595: NVL(hop.business_scope, fnd_api.g_miss_char),
2596: NVL(hop.corporation_class, fnd_api.g_miss_char),
2589: NVL(hop.fiscal_yearend_month, fnd_api.g_miss_char),
2590: NVL(hop.curr_fy_potential_revenue, fnd_api.g_miss_num),
2591: NVL(hop.next_fy_potential_revenue, fnd_api.g_miss_num),
2592: NVL(hop.year_established, fnd_api.g_miss_num),
2593: NVL(hop.mission_statement, fnd_api.g_miss_char),
2594: NVL(hop.organization_type, fnd_api.g_miss_char),
2595: NVL(hop.business_scope, fnd_api.g_miss_char),
2596: NVL(hop.corporation_class, fnd_api.g_miss_char),
2597: NVL(hop.known_as, fnd_api.g_miss_char),
2590: NVL(hop.curr_fy_potential_revenue, fnd_api.g_miss_num),
2591: NVL(hop.next_fy_potential_revenue, fnd_api.g_miss_num),
2592: NVL(hop.year_established, fnd_api.g_miss_num),
2593: NVL(hop.mission_statement, fnd_api.g_miss_char),
2594: NVL(hop.organization_type, fnd_api.g_miss_char),
2595: NVL(hop.business_scope, fnd_api.g_miss_char),
2596: NVL(hop.corporation_class, fnd_api.g_miss_char),
2597: NVL(hop.known_as, fnd_api.g_miss_char),
2598: NVL(hop.local_bus_iden_type, fnd_api.g_miss_char),
2591: NVL(hop.next_fy_potential_revenue, fnd_api.g_miss_num),
2592: NVL(hop.year_established, fnd_api.g_miss_num),
2593: NVL(hop.mission_statement, fnd_api.g_miss_char),
2594: NVL(hop.organization_type, fnd_api.g_miss_char),
2595: NVL(hop.business_scope, fnd_api.g_miss_char),
2596: NVL(hop.corporation_class, fnd_api.g_miss_char),
2597: NVL(hop.known_as, fnd_api.g_miss_char),
2598: NVL(hop.local_bus_iden_type, fnd_api.g_miss_char),
2599: NVL(hop.local_bus_identifier, fnd_api.g_miss_char),
2592: NVL(hop.year_established, fnd_api.g_miss_num),
2593: NVL(hop.mission_statement, fnd_api.g_miss_char),
2594: NVL(hop.organization_type, fnd_api.g_miss_char),
2595: NVL(hop.business_scope, fnd_api.g_miss_char),
2596: NVL(hop.corporation_class, fnd_api.g_miss_char),
2597: NVL(hop.known_as, fnd_api.g_miss_char),
2598: NVL(hop.local_bus_iden_type, fnd_api.g_miss_char),
2599: NVL(hop.local_bus_identifier, fnd_api.g_miss_char),
2600: NVL(hop.pref_functional_currency, fnd_api.g_miss_char),
2593: NVL(hop.mission_statement, fnd_api.g_miss_char),
2594: NVL(hop.organization_type, fnd_api.g_miss_char),
2595: NVL(hop.business_scope, fnd_api.g_miss_char),
2596: NVL(hop.corporation_class, fnd_api.g_miss_char),
2597: NVL(hop.known_as, fnd_api.g_miss_char),
2598: NVL(hop.local_bus_iden_type, fnd_api.g_miss_char),
2599: NVL(hop.local_bus_identifier, fnd_api.g_miss_char),
2600: NVL(hop.pref_functional_currency, fnd_api.g_miss_char),
2601: NVL(hop.registration_type, fnd_api.g_miss_char),
2594: NVL(hop.organization_type, fnd_api.g_miss_char),
2595: NVL(hop.business_scope, fnd_api.g_miss_char),
2596: NVL(hop.corporation_class, fnd_api.g_miss_char),
2597: NVL(hop.known_as, fnd_api.g_miss_char),
2598: NVL(hop.local_bus_iden_type, fnd_api.g_miss_char),
2599: NVL(hop.local_bus_identifier, fnd_api.g_miss_char),
2600: NVL(hop.pref_functional_currency, fnd_api.g_miss_char),
2601: NVL(hop.registration_type, fnd_api.g_miss_char),
2602: NVL(hop.total_employees_text, fnd_api.g_miss_char),
2595: NVL(hop.business_scope, fnd_api.g_miss_char),
2596: NVL(hop.corporation_class, fnd_api.g_miss_char),
2597: NVL(hop.known_as, fnd_api.g_miss_char),
2598: NVL(hop.local_bus_iden_type, fnd_api.g_miss_char),
2599: NVL(hop.local_bus_identifier, fnd_api.g_miss_char),
2600: NVL(hop.pref_functional_currency, fnd_api.g_miss_char),
2601: NVL(hop.registration_type, fnd_api.g_miss_char),
2602: NVL(hop.total_employees_text, fnd_api.g_miss_char),
2603: NVL(hop.total_employees_ind, fnd_api.g_miss_char),
2596: NVL(hop.corporation_class, fnd_api.g_miss_char),
2597: NVL(hop.known_as, fnd_api.g_miss_char),
2598: NVL(hop.local_bus_iden_type, fnd_api.g_miss_char),
2599: NVL(hop.local_bus_identifier, fnd_api.g_miss_char),
2600: NVL(hop.pref_functional_currency, fnd_api.g_miss_char),
2601: NVL(hop.registration_type, fnd_api.g_miss_char),
2602: NVL(hop.total_employees_text, fnd_api.g_miss_char),
2603: NVL(hop.total_employees_ind, fnd_api.g_miss_char),
2604: NVL(hop.total_emp_est_ind, fnd_api.g_miss_char),
2597: NVL(hop.known_as, fnd_api.g_miss_char),
2598: NVL(hop.local_bus_iden_type, fnd_api.g_miss_char),
2599: NVL(hop.local_bus_identifier, fnd_api.g_miss_char),
2600: NVL(hop.pref_functional_currency, fnd_api.g_miss_char),
2601: NVL(hop.registration_type, fnd_api.g_miss_char),
2602: NVL(hop.total_employees_text, fnd_api.g_miss_char),
2603: NVL(hop.total_employees_ind, fnd_api.g_miss_char),
2604: NVL(hop.total_emp_est_ind, fnd_api.g_miss_char),
2605: NVL(hop.total_emp_min_ind, fnd_api.g_miss_char),
2598: NVL(hop.local_bus_iden_type, fnd_api.g_miss_char),
2599: NVL(hop.local_bus_identifier, fnd_api.g_miss_char),
2600: NVL(hop.pref_functional_currency, fnd_api.g_miss_char),
2601: NVL(hop.registration_type, fnd_api.g_miss_char),
2602: NVL(hop.total_employees_text, fnd_api.g_miss_char),
2603: NVL(hop.total_employees_ind, fnd_api.g_miss_char),
2604: NVL(hop.total_emp_est_ind, fnd_api.g_miss_char),
2605: NVL(hop.total_emp_min_ind, fnd_api.g_miss_char),
2606: NVL(hop.parent_sub_ind, fnd_api.g_miss_char),
2599: NVL(hop.local_bus_identifier, fnd_api.g_miss_char),
2600: NVL(hop.pref_functional_currency, fnd_api.g_miss_char),
2601: NVL(hop.registration_type, fnd_api.g_miss_char),
2602: NVL(hop.total_employees_text, fnd_api.g_miss_char),
2603: NVL(hop.total_employees_ind, fnd_api.g_miss_char),
2604: NVL(hop.total_emp_est_ind, fnd_api.g_miss_char),
2605: NVL(hop.total_emp_min_ind, fnd_api.g_miss_char),
2606: NVL(hop.parent_sub_ind, fnd_api.g_miss_char),
2607: NVL(hop.incorp_year, fnd_api.g_miss_num),
2600: NVL(hop.pref_functional_currency, fnd_api.g_miss_char),
2601: NVL(hop.registration_type, fnd_api.g_miss_char),
2602: NVL(hop.total_employees_text, fnd_api.g_miss_char),
2603: NVL(hop.total_employees_ind, fnd_api.g_miss_char),
2604: NVL(hop.total_emp_est_ind, fnd_api.g_miss_char),
2605: NVL(hop.total_emp_min_ind, fnd_api.g_miss_char),
2606: NVL(hop.parent_sub_ind, fnd_api.g_miss_char),
2607: NVL(hop.incorp_year, fnd_api.g_miss_num),
2608: NVL(hop.content_source_type, fnd_api.g_miss_char),
2601: NVL(hop.registration_type, fnd_api.g_miss_char),
2602: NVL(hop.total_employees_text, fnd_api.g_miss_char),
2603: NVL(hop.total_employees_ind, fnd_api.g_miss_char),
2604: NVL(hop.total_emp_est_ind, fnd_api.g_miss_char),
2605: NVL(hop.total_emp_min_ind, fnd_api.g_miss_char),
2606: NVL(hop.parent_sub_ind, fnd_api.g_miss_char),
2607: NVL(hop.incorp_year, fnd_api.g_miss_num),
2608: NVL(hop.content_source_type, fnd_api.g_miss_char),
2609: NVL(hop.content_source_number, fnd_api.g_miss_char),
2602: NVL(hop.total_employees_text, fnd_api.g_miss_char),
2603: NVL(hop.total_employees_ind, fnd_api.g_miss_char),
2604: NVL(hop.total_emp_est_ind, fnd_api.g_miss_char),
2605: NVL(hop.total_emp_min_ind, fnd_api.g_miss_char),
2606: NVL(hop.parent_sub_ind, fnd_api.g_miss_char),
2607: NVL(hop.incorp_year, fnd_api.g_miss_num),
2608: NVL(hop.content_source_type, fnd_api.g_miss_char),
2609: NVL(hop.content_source_number, fnd_api.g_miss_char),
2610: NVL(hop.effective_start_date, fnd_api.g_miss_date),
2603: NVL(hop.total_employees_ind, fnd_api.g_miss_char),
2604: NVL(hop.total_emp_est_ind, fnd_api.g_miss_char),
2605: NVL(hop.total_emp_min_ind, fnd_api.g_miss_char),
2606: NVL(hop.parent_sub_ind, fnd_api.g_miss_char),
2607: NVL(hop.incorp_year, fnd_api.g_miss_num),
2608: NVL(hop.content_source_type, fnd_api.g_miss_char),
2609: NVL(hop.content_source_number, fnd_api.g_miss_char),
2610: NVL(hop.effective_start_date, fnd_api.g_miss_date),
2611: NVL(hop.effective_end_date, fnd_api.g_miss_date),
2604: NVL(hop.total_emp_est_ind, fnd_api.g_miss_char),
2605: NVL(hop.total_emp_min_ind, fnd_api.g_miss_char),
2606: NVL(hop.parent_sub_ind, fnd_api.g_miss_char),
2607: NVL(hop.incorp_year, fnd_api.g_miss_num),
2608: NVL(hop.content_source_type, fnd_api.g_miss_char),
2609: NVL(hop.content_source_number, fnd_api.g_miss_char),
2610: NVL(hop.effective_start_date, fnd_api.g_miss_date),
2611: NVL(hop.effective_end_date, fnd_api.g_miss_date),
2612: NVL(hop.sic_code_type, fnd_api.g_miss_char),
2605: NVL(hop.total_emp_min_ind, fnd_api.g_miss_char),
2606: NVL(hop.parent_sub_ind, fnd_api.g_miss_char),
2607: NVL(hop.incorp_year, fnd_api.g_miss_num),
2608: NVL(hop.content_source_type, fnd_api.g_miss_char),
2609: NVL(hop.content_source_number, fnd_api.g_miss_char),
2610: NVL(hop.effective_start_date, fnd_api.g_miss_date),
2611: NVL(hop.effective_end_date, fnd_api.g_miss_date),
2612: NVL(hop.sic_code_type, fnd_api.g_miss_char),
2613: NVL(hop.public_private_ownership_flag, fnd_api.g_miss_char),
2606: NVL(hop.parent_sub_ind, fnd_api.g_miss_char),
2607: NVL(hop.incorp_year, fnd_api.g_miss_num),
2608: NVL(hop.content_source_type, fnd_api.g_miss_char),
2609: NVL(hop.content_source_number, fnd_api.g_miss_char),
2610: NVL(hop.effective_start_date, fnd_api.g_miss_date),
2611: NVL(hop.effective_end_date, fnd_api.g_miss_date),
2612: NVL(hop.sic_code_type, fnd_api.g_miss_char),
2613: NVL(hop.public_private_ownership_flag, fnd_api.g_miss_char),
2614: NVL(hop.local_activity_code_type, fnd_api.g_miss_char),
2607: NVL(hop.incorp_year, fnd_api.g_miss_num),
2608: NVL(hop.content_source_type, fnd_api.g_miss_char),
2609: NVL(hop.content_source_number, fnd_api.g_miss_char),
2610: NVL(hop.effective_start_date, fnd_api.g_miss_date),
2611: NVL(hop.effective_end_date, fnd_api.g_miss_date),
2612: NVL(hop.sic_code_type, fnd_api.g_miss_char),
2613: NVL(hop.public_private_ownership_flag, fnd_api.g_miss_char),
2614: NVL(hop.local_activity_code_type, fnd_api.g_miss_char),
2615: NVL(hop.local_activity_code, fnd_api.g_miss_char),
2608: NVL(hop.content_source_type, fnd_api.g_miss_char),
2609: NVL(hop.content_source_number, fnd_api.g_miss_char),
2610: NVL(hop.effective_start_date, fnd_api.g_miss_date),
2611: NVL(hop.effective_end_date, fnd_api.g_miss_date),
2612: NVL(hop.sic_code_type, fnd_api.g_miss_char),
2613: NVL(hop.public_private_ownership_flag, fnd_api.g_miss_char),
2614: NVL(hop.local_activity_code_type, fnd_api.g_miss_char),
2615: NVL(hop.local_activity_code, fnd_api.g_miss_char),
2616: NVL(hop.emp_at_primary_adr, fnd_api.g_miss_char),
2609: NVL(hop.content_source_number, fnd_api.g_miss_char),
2610: NVL(hop.effective_start_date, fnd_api.g_miss_date),
2611: NVL(hop.effective_end_date, fnd_api.g_miss_date),
2612: NVL(hop.sic_code_type, fnd_api.g_miss_char),
2613: NVL(hop.public_private_ownership_flag, fnd_api.g_miss_char),
2614: NVL(hop.local_activity_code_type, fnd_api.g_miss_char),
2615: NVL(hop.local_activity_code, fnd_api.g_miss_char),
2616: NVL(hop.emp_at_primary_adr, fnd_api.g_miss_char),
2617: NVL(hop.emp_at_primary_adr_text, fnd_api.g_miss_char),
2610: NVL(hop.effective_start_date, fnd_api.g_miss_date),
2611: NVL(hop.effective_end_date, fnd_api.g_miss_date),
2612: NVL(hop.sic_code_type, fnd_api.g_miss_char),
2613: NVL(hop.public_private_ownership_flag, fnd_api.g_miss_char),
2614: NVL(hop.local_activity_code_type, fnd_api.g_miss_char),
2615: NVL(hop.local_activity_code, fnd_api.g_miss_char),
2616: NVL(hop.emp_at_primary_adr, fnd_api.g_miss_char),
2617: NVL(hop.emp_at_primary_adr_text, fnd_api.g_miss_char),
2618: NVL(hop.emp_at_primary_adr_est_ind, fnd_api.g_miss_char),
2611: NVL(hop.effective_end_date, fnd_api.g_miss_date),
2612: NVL(hop.sic_code_type, fnd_api.g_miss_char),
2613: NVL(hop.public_private_ownership_flag, fnd_api.g_miss_char),
2614: NVL(hop.local_activity_code_type, fnd_api.g_miss_char),
2615: NVL(hop.local_activity_code, fnd_api.g_miss_char),
2616: NVL(hop.emp_at_primary_adr, fnd_api.g_miss_char),
2617: NVL(hop.emp_at_primary_adr_text, fnd_api.g_miss_char),
2618: NVL(hop.emp_at_primary_adr_est_ind, fnd_api.g_miss_char),
2619: NVL(hop.emp_at_primary_adr_min_ind, fnd_api.g_miss_char),
2612: NVL(hop.sic_code_type, fnd_api.g_miss_char),
2613: NVL(hop.public_private_ownership_flag, fnd_api.g_miss_char),
2614: NVL(hop.local_activity_code_type, fnd_api.g_miss_char),
2615: NVL(hop.local_activity_code, fnd_api.g_miss_char),
2616: NVL(hop.emp_at_primary_adr, fnd_api.g_miss_char),
2617: NVL(hop.emp_at_primary_adr_text, fnd_api.g_miss_char),
2618: NVL(hop.emp_at_primary_adr_est_ind, fnd_api.g_miss_char),
2619: NVL(hop.emp_at_primary_adr_min_ind, fnd_api.g_miss_char),
2620: NVL(hop.internal_flag, fnd_api.g_miss_char),
2613: NVL(hop.public_private_ownership_flag, fnd_api.g_miss_char),
2614: NVL(hop.local_activity_code_type, fnd_api.g_miss_char),
2615: NVL(hop.local_activity_code, fnd_api.g_miss_char),
2616: NVL(hop.emp_at_primary_adr, fnd_api.g_miss_char),
2617: NVL(hop.emp_at_primary_adr_text, fnd_api.g_miss_char),
2618: NVL(hop.emp_at_primary_adr_est_ind, fnd_api.g_miss_char),
2619: NVL(hop.emp_at_primary_adr_min_ind, fnd_api.g_miss_char),
2620: NVL(hop.internal_flag, fnd_api.g_miss_char),
2621: NVL(hop.high_credit, fnd_api.g_miss_num),
2614: NVL(hop.local_activity_code_type, fnd_api.g_miss_char),
2615: NVL(hop.local_activity_code, fnd_api.g_miss_char),
2616: NVL(hop.emp_at_primary_adr, fnd_api.g_miss_char),
2617: NVL(hop.emp_at_primary_adr_text, fnd_api.g_miss_char),
2618: NVL(hop.emp_at_primary_adr_est_ind, fnd_api.g_miss_char),
2619: NVL(hop.emp_at_primary_adr_min_ind, fnd_api.g_miss_char),
2620: NVL(hop.internal_flag, fnd_api.g_miss_char),
2621: NVL(hop.high_credit, fnd_api.g_miss_num),
2622: NVL(hop.avg_high_credit, fnd_api.g_miss_num),
2615: NVL(hop.local_activity_code, fnd_api.g_miss_char),
2616: NVL(hop.emp_at_primary_adr, fnd_api.g_miss_char),
2617: NVL(hop.emp_at_primary_adr_text, fnd_api.g_miss_char),
2618: NVL(hop.emp_at_primary_adr_est_ind, fnd_api.g_miss_char),
2619: NVL(hop.emp_at_primary_adr_min_ind, fnd_api.g_miss_char),
2620: NVL(hop.internal_flag, fnd_api.g_miss_char),
2621: NVL(hop.high_credit, fnd_api.g_miss_num),
2622: NVL(hop.avg_high_credit, fnd_api.g_miss_num),
2623: NVL(hop.total_payments, fnd_api.g_miss_num),
2616: NVL(hop.emp_at_primary_adr, fnd_api.g_miss_char),
2617: NVL(hop.emp_at_primary_adr_text, fnd_api.g_miss_char),
2618: NVL(hop.emp_at_primary_adr_est_ind, fnd_api.g_miss_char),
2619: NVL(hop.emp_at_primary_adr_min_ind, fnd_api.g_miss_char),
2620: NVL(hop.internal_flag, fnd_api.g_miss_char),
2621: NVL(hop.high_credit, fnd_api.g_miss_num),
2622: NVL(hop.avg_high_credit, fnd_api.g_miss_num),
2623: NVL(hop.total_payments, fnd_api.g_miss_num),
2624: NVL(hop.known_as2, fnd_api.g_miss_char),
2617: NVL(hop.emp_at_primary_adr_text, fnd_api.g_miss_char),
2618: NVL(hop.emp_at_primary_adr_est_ind, fnd_api.g_miss_char),
2619: NVL(hop.emp_at_primary_adr_min_ind, fnd_api.g_miss_char),
2620: NVL(hop.internal_flag, fnd_api.g_miss_char),
2621: NVL(hop.high_credit, fnd_api.g_miss_num),
2622: NVL(hop.avg_high_credit, fnd_api.g_miss_num),
2623: NVL(hop.total_payments, fnd_api.g_miss_num),
2624: NVL(hop.known_as2, fnd_api.g_miss_char),
2625: NVL(hop.known_as3, fnd_api.g_miss_char),
2618: NVL(hop.emp_at_primary_adr_est_ind, fnd_api.g_miss_char),
2619: NVL(hop.emp_at_primary_adr_min_ind, fnd_api.g_miss_char),
2620: NVL(hop.internal_flag, fnd_api.g_miss_char),
2621: NVL(hop.high_credit, fnd_api.g_miss_num),
2622: NVL(hop.avg_high_credit, fnd_api.g_miss_num),
2623: NVL(hop.total_payments, fnd_api.g_miss_num),
2624: NVL(hop.known_as2, fnd_api.g_miss_char),
2625: NVL(hop.known_as3, fnd_api.g_miss_char),
2626: NVL(hop.known_as4, fnd_api.g_miss_char),
2619: NVL(hop.emp_at_primary_adr_min_ind, fnd_api.g_miss_char),
2620: NVL(hop.internal_flag, fnd_api.g_miss_char),
2621: NVL(hop.high_credit, fnd_api.g_miss_num),
2622: NVL(hop.avg_high_credit, fnd_api.g_miss_num),
2623: NVL(hop.total_payments, fnd_api.g_miss_num),
2624: NVL(hop.known_as2, fnd_api.g_miss_char),
2625: NVL(hop.known_as3, fnd_api.g_miss_char),
2626: NVL(hop.known_as4, fnd_api.g_miss_char),
2627: NVL(hop.known_as5, fnd_api.g_miss_char),
2620: NVL(hop.internal_flag, fnd_api.g_miss_char),
2621: NVL(hop.high_credit, fnd_api.g_miss_num),
2622: NVL(hop.avg_high_credit, fnd_api.g_miss_num),
2623: NVL(hop.total_payments, fnd_api.g_miss_num),
2624: NVL(hop.known_as2, fnd_api.g_miss_char),
2625: NVL(hop.known_as3, fnd_api.g_miss_char),
2626: NVL(hop.known_as4, fnd_api.g_miss_char),
2627: NVL(hop.known_as5, fnd_api.g_miss_char),
2628: NVL(hop.credit_score_class, fnd_api.g_miss_num),
2621: NVL(hop.high_credit, fnd_api.g_miss_num),
2622: NVL(hop.avg_high_credit, fnd_api.g_miss_num),
2623: NVL(hop.total_payments, fnd_api.g_miss_num),
2624: NVL(hop.known_as2, fnd_api.g_miss_char),
2625: NVL(hop.known_as3, fnd_api.g_miss_char),
2626: NVL(hop.known_as4, fnd_api.g_miss_char),
2627: NVL(hop.known_as5, fnd_api.g_miss_char),
2628: NVL(hop.credit_score_class, fnd_api.g_miss_num),
2629: NVL(hop.credit_score_natl_percentile, fnd_api.g_miss_num),
2622: NVL(hop.avg_high_credit, fnd_api.g_miss_num),
2623: NVL(hop.total_payments, fnd_api.g_miss_num),
2624: NVL(hop.known_as2, fnd_api.g_miss_char),
2625: NVL(hop.known_as3, fnd_api.g_miss_char),
2626: NVL(hop.known_as4, fnd_api.g_miss_char),
2627: NVL(hop.known_as5, fnd_api.g_miss_char),
2628: NVL(hop.credit_score_class, fnd_api.g_miss_num),
2629: NVL(hop.credit_score_natl_percentile, fnd_api.g_miss_num),
2630: NVL(hop.credit_score_incd_default, fnd_api.g_miss_num),
2623: NVL(hop.total_payments, fnd_api.g_miss_num),
2624: NVL(hop.known_as2, fnd_api.g_miss_char),
2625: NVL(hop.known_as3, fnd_api.g_miss_char),
2626: NVL(hop.known_as4, fnd_api.g_miss_char),
2627: NVL(hop.known_as5, fnd_api.g_miss_char),
2628: NVL(hop.credit_score_class, fnd_api.g_miss_num),
2629: NVL(hop.credit_score_natl_percentile, fnd_api.g_miss_num),
2630: NVL(hop.credit_score_incd_default, fnd_api.g_miss_num),
2631: NVL(hop.credit_score_age, fnd_api.g_miss_num),
2624: NVL(hop.known_as2, fnd_api.g_miss_char),
2625: NVL(hop.known_as3, fnd_api.g_miss_char),
2626: NVL(hop.known_as4, fnd_api.g_miss_char),
2627: NVL(hop.known_as5, fnd_api.g_miss_char),
2628: NVL(hop.credit_score_class, fnd_api.g_miss_num),
2629: NVL(hop.credit_score_natl_percentile, fnd_api.g_miss_num),
2630: NVL(hop.credit_score_incd_default, fnd_api.g_miss_num),
2631: NVL(hop.credit_score_age, fnd_api.g_miss_num),
2632: NVL(hop.credit_score_date, fnd_api.g_miss_date),
2625: NVL(hop.known_as3, fnd_api.g_miss_char),
2626: NVL(hop.known_as4, fnd_api.g_miss_char),
2627: NVL(hop.known_as5, fnd_api.g_miss_char),
2628: NVL(hop.credit_score_class, fnd_api.g_miss_num),
2629: NVL(hop.credit_score_natl_percentile, fnd_api.g_miss_num),
2630: NVL(hop.credit_score_incd_default, fnd_api.g_miss_num),
2631: NVL(hop.credit_score_age, fnd_api.g_miss_num),
2632: NVL(hop.credit_score_date, fnd_api.g_miss_date),
2633: NVL(hop.failure_score_class, fnd_api.g_miss_num),
2626: NVL(hop.known_as4, fnd_api.g_miss_char),
2627: NVL(hop.known_as5, fnd_api.g_miss_char),
2628: NVL(hop.credit_score_class, fnd_api.g_miss_num),
2629: NVL(hop.credit_score_natl_percentile, fnd_api.g_miss_num),
2630: NVL(hop.credit_score_incd_default, fnd_api.g_miss_num),
2631: NVL(hop.credit_score_age, fnd_api.g_miss_num),
2632: NVL(hop.credit_score_date, fnd_api.g_miss_date),
2633: NVL(hop.failure_score_class, fnd_api.g_miss_num),
2634: NVL(hop.failure_score_incd_default, fnd_api.g_miss_num),
2627: NVL(hop.known_as5, fnd_api.g_miss_char),
2628: NVL(hop.credit_score_class, fnd_api.g_miss_num),
2629: NVL(hop.credit_score_natl_percentile, fnd_api.g_miss_num),
2630: NVL(hop.credit_score_incd_default, fnd_api.g_miss_num),
2631: NVL(hop.credit_score_age, fnd_api.g_miss_num),
2632: NVL(hop.credit_score_date, fnd_api.g_miss_date),
2633: NVL(hop.failure_score_class, fnd_api.g_miss_num),
2634: NVL(hop.failure_score_incd_default, fnd_api.g_miss_num),
2635: NVL(hop.failure_score_age, fnd_api.g_miss_num),
2628: NVL(hop.credit_score_class, fnd_api.g_miss_num),
2629: NVL(hop.credit_score_natl_percentile, fnd_api.g_miss_num),
2630: NVL(hop.credit_score_incd_default, fnd_api.g_miss_num),
2631: NVL(hop.credit_score_age, fnd_api.g_miss_num),
2632: NVL(hop.credit_score_date, fnd_api.g_miss_date),
2633: NVL(hop.failure_score_class, fnd_api.g_miss_num),
2634: NVL(hop.failure_score_incd_default, fnd_api.g_miss_num),
2635: NVL(hop.failure_score_age, fnd_api.g_miss_num),
2636: NVL(hop.failure_score_date, fnd_api.g_miss_date),
2629: NVL(hop.credit_score_natl_percentile, fnd_api.g_miss_num),
2630: NVL(hop.credit_score_incd_default, fnd_api.g_miss_num),
2631: NVL(hop.credit_score_age, fnd_api.g_miss_num),
2632: NVL(hop.credit_score_date, fnd_api.g_miss_date),
2633: NVL(hop.failure_score_class, fnd_api.g_miss_num),
2634: NVL(hop.failure_score_incd_default, fnd_api.g_miss_num),
2635: NVL(hop.failure_score_age, fnd_api.g_miss_num),
2636: NVL(hop.failure_score_date, fnd_api.g_miss_date),
2637: NVL(hop.failure_score_commentary2, fnd_api.g_miss_char),
2630: NVL(hop.credit_score_incd_default, fnd_api.g_miss_num),
2631: NVL(hop.credit_score_age, fnd_api.g_miss_num),
2632: NVL(hop.credit_score_date, fnd_api.g_miss_date),
2633: NVL(hop.failure_score_class, fnd_api.g_miss_num),
2634: NVL(hop.failure_score_incd_default, fnd_api.g_miss_num),
2635: NVL(hop.failure_score_age, fnd_api.g_miss_num),
2636: NVL(hop.failure_score_date, fnd_api.g_miss_date),
2637: NVL(hop.failure_score_commentary2, fnd_api.g_miss_char),
2638: NVL(hop.failure_score_commentary3, fnd_api.g_miss_char),
2631: NVL(hop.credit_score_age, fnd_api.g_miss_num),
2632: NVL(hop.credit_score_date, fnd_api.g_miss_date),
2633: NVL(hop.failure_score_class, fnd_api.g_miss_num),
2634: NVL(hop.failure_score_incd_default, fnd_api.g_miss_num),
2635: NVL(hop.failure_score_age, fnd_api.g_miss_num),
2636: NVL(hop.failure_score_date, fnd_api.g_miss_date),
2637: NVL(hop.failure_score_commentary2, fnd_api.g_miss_char),
2638: NVL(hop.failure_score_commentary3, fnd_api.g_miss_char),
2639: NVL(hop.failure_score_commentary4, fnd_api.g_miss_char),
2632: NVL(hop.credit_score_date, fnd_api.g_miss_date),
2633: NVL(hop.failure_score_class, fnd_api.g_miss_num),
2634: NVL(hop.failure_score_incd_default, fnd_api.g_miss_num),
2635: NVL(hop.failure_score_age, fnd_api.g_miss_num),
2636: NVL(hop.failure_score_date, fnd_api.g_miss_date),
2637: NVL(hop.failure_score_commentary2, fnd_api.g_miss_char),
2638: NVL(hop.failure_score_commentary3, fnd_api.g_miss_char),
2639: NVL(hop.failure_score_commentary4, fnd_api.g_miss_char),
2640: NVL(hop.failure_score_commentary5, fnd_api.g_miss_char),
2633: NVL(hop.failure_score_class, fnd_api.g_miss_num),
2634: NVL(hop.failure_score_incd_default, fnd_api.g_miss_num),
2635: NVL(hop.failure_score_age, fnd_api.g_miss_num),
2636: NVL(hop.failure_score_date, fnd_api.g_miss_date),
2637: NVL(hop.failure_score_commentary2, fnd_api.g_miss_char),
2638: NVL(hop.failure_score_commentary3, fnd_api.g_miss_char),
2639: NVL(hop.failure_score_commentary4, fnd_api.g_miss_char),
2640: NVL(hop.failure_score_commentary5, fnd_api.g_miss_char),
2641: NVL(hop.failure_score_commentary6, fnd_api.g_miss_char),
2634: NVL(hop.failure_score_incd_default, fnd_api.g_miss_num),
2635: NVL(hop.failure_score_age, fnd_api.g_miss_num),
2636: NVL(hop.failure_score_date, fnd_api.g_miss_date),
2637: NVL(hop.failure_score_commentary2, fnd_api.g_miss_char),
2638: NVL(hop.failure_score_commentary3, fnd_api.g_miss_char),
2639: NVL(hop.failure_score_commentary4, fnd_api.g_miss_char),
2640: NVL(hop.failure_score_commentary5, fnd_api.g_miss_char),
2641: NVL(hop.failure_score_commentary6, fnd_api.g_miss_char),
2642: NVL(hop.failure_score_commentary7, fnd_api.g_miss_char),
2635: NVL(hop.failure_score_age, fnd_api.g_miss_num),
2636: NVL(hop.failure_score_date, fnd_api.g_miss_date),
2637: NVL(hop.failure_score_commentary2, fnd_api.g_miss_char),
2638: NVL(hop.failure_score_commentary3, fnd_api.g_miss_char),
2639: NVL(hop.failure_score_commentary4, fnd_api.g_miss_char),
2640: NVL(hop.failure_score_commentary5, fnd_api.g_miss_char),
2641: NVL(hop.failure_score_commentary6, fnd_api.g_miss_char),
2642: NVL(hop.failure_score_commentary7, fnd_api.g_miss_char),
2643: NVL(hop.failure_score_commentary8, fnd_api.g_miss_char),
2636: NVL(hop.failure_score_date, fnd_api.g_miss_date),
2637: NVL(hop.failure_score_commentary2, fnd_api.g_miss_char),
2638: NVL(hop.failure_score_commentary3, fnd_api.g_miss_char),
2639: NVL(hop.failure_score_commentary4, fnd_api.g_miss_char),
2640: NVL(hop.failure_score_commentary5, fnd_api.g_miss_char),
2641: NVL(hop.failure_score_commentary6, fnd_api.g_miss_char),
2642: NVL(hop.failure_score_commentary7, fnd_api.g_miss_char),
2643: NVL(hop.failure_score_commentary8, fnd_api.g_miss_char),
2644: NVL(hop.failure_score_commentary9, fnd_api.g_miss_char),
2637: NVL(hop.failure_score_commentary2, fnd_api.g_miss_char),
2638: NVL(hop.failure_score_commentary3, fnd_api.g_miss_char),
2639: NVL(hop.failure_score_commentary4, fnd_api.g_miss_char),
2640: NVL(hop.failure_score_commentary5, fnd_api.g_miss_char),
2641: NVL(hop.failure_score_commentary6, fnd_api.g_miss_char),
2642: NVL(hop.failure_score_commentary7, fnd_api.g_miss_char),
2643: NVL(hop.failure_score_commentary8, fnd_api.g_miss_char),
2644: NVL(hop.failure_score_commentary9, fnd_api.g_miss_char),
2645: NVL(hop.failure_score_commentary10, fnd_api.g_miss_char),
2638: NVL(hop.failure_score_commentary3, fnd_api.g_miss_char),
2639: NVL(hop.failure_score_commentary4, fnd_api.g_miss_char),
2640: NVL(hop.failure_score_commentary5, fnd_api.g_miss_char),
2641: NVL(hop.failure_score_commentary6, fnd_api.g_miss_char),
2642: NVL(hop.failure_score_commentary7, fnd_api.g_miss_char),
2643: NVL(hop.failure_score_commentary8, fnd_api.g_miss_char),
2644: NVL(hop.failure_score_commentary9, fnd_api.g_miss_char),
2645: NVL(hop.failure_score_commentary10, fnd_api.g_miss_char),
2646: NVL(hop.credit_score_commentary2, fnd_api.g_miss_char),
2639: NVL(hop.failure_score_commentary4, fnd_api.g_miss_char),
2640: NVL(hop.failure_score_commentary5, fnd_api.g_miss_char),
2641: NVL(hop.failure_score_commentary6, fnd_api.g_miss_char),
2642: NVL(hop.failure_score_commentary7, fnd_api.g_miss_char),
2643: NVL(hop.failure_score_commentary8, fnd_api.g_miss_char),
2644: NVL(hop.failure_score_commentary9, fnd_api.g_miss_char),
2645: NVL(hop.failure_score_commentary10, fnd_api.g_miss_char),
2646: NVL(hop.credit_score_commentary2, fnd_api.g_miss_char),
2647: NVL(hop.credit_score_commentary3, fnd_api.g_miss_char),
2640: NVL(hop.failure_score_commentary5, fnd_api.g_miss_char),
2641: NVL(hop.failure_score_commentary6, fnd_api.g_miss_char),
2642: NVL(hop.failure_score_commentary7, fnd_api.g_miss_char),
2643: NVL(hop.failure_score_commentary8, fnd_api.g_miss_char),
2644: NVL(hop.failure_score_commentary9, fnd_api.g_miss_char),
2645: NVL(hop.failure_score_commentary10, fnd_api.g_miss_char),
2646: NVL(hop.credit_score_commentary2, fnd_api.g_miss_char),
2647: NVL(hop.credit_score_commentary3, fnd_api.g_miss_char),
2648: NVL(hop.credit_score_commentary4, fnd_api.g_miss_char),
2641: NVL(hop.failure_score_commentary6, fnd_api.g_miss_char),
2642: NVL(hop.failure_score_commentary7, fnd_api.g_miss_char),
2643: NVL(hop.failure_score_commentary8, fnd_api.g_miss_char),
2644: NVL(hop.failure_score_commentary9, fnd_api.g_miss_char),
2645: NVL(hop.failure_score_commentary10, fnd_api.g_miss_char),
2646: NVL(hop.credit_score_commentary2, fnd_api.g_miss_char),
2647: NVL(hop.credit_score_commentary3, fnd_api.g_miss_char),
2648: NVL(hop.credit_score_commentary4, fnd_api.g_miss_char),
2649: NVL(hop.credit_score_commentary5, fnd_api.g_miss_char),
2642: NVL(hop.failure_score_commentary7, fnd_api.g_miss_char),
2643: NVL(hop.failure_score_commentary8, fnd_api.g_miss_char),
2644: NVL(hop.failure_score_commentary9, fnd_api.g_miss_char),
2645: NVL(hop.failure_score_commentary10, fnd_api.g_miss_char),
2646: NVL(hop.credit_score_commentary2, fnd_api.g_miss_char),
2647: NVL(hop.credit_score_commentary3, fnd_api.g_miss_char),
2648: NVL(hop.credit_score_commentary4, fnd_api.g_miss_char),
2649: NVL(hop.credit_score_commentary5, fnd_api.g_miss_char),
2650: NVL(hop.credit_score_commentary6, fnd_api.g_miss_char),
2643: NVL(hop.failure_score_commentary8, fnd_api.g_miss_char),
2644: NVL(hop.failure_score_commentary9, fnd_api.g_miss_char),
2645: NVL(hop.failure_score_commentary10, fnd_api.g_miss_char),
2646: NVL(hop.credit_score_commentary2, fnd_api.g_miss_char),
2647: NVL(hop.credit_score_commentary3, fnd_api.g_miss_char),
2648: NVL(hop.credit_score_commentary4, fnd_api.g_miss_char),
2649: NVL(hop.credit_score_commentary5, fnd_api.g_miss_char),
2650: NVL(hop.credit_score_commentary6, fnd_api.g_miss_char),
2651: NVL(hop.credit_score_commentary7, fnd_api.g_miss_char),
2644: NVL(hop.failure_score_commentary9, fnd_api.g_miss_char),
2645: NVL(hop.failure_score_commentary10, fnd_api.g_miss_char),
2646: NVL(hop.credit_score_commentary2, fnd_api.g_miss_char),
2647: NVL(hop.credit_score_commentary3, fnd_api.g_miss_char),
2648: NVL(hop.credit_score_commentary4, fnd_api.g_miss_char),
2649: NVL(hop.credit_score_commentary5, fnd_api.g_miss_char),
2650: NVL(hop.credit_score_commentary6, fnd_api.g_miss_char),
2651: NVL(hop.credit_score_commentary7, fnd_api.g_miss_char),
2652: NVL(hop.credit_score_commentary8, fnd_api.g_miss_char),
2645: NVL(hop.failure_score_commentary10, fnd_api.g_miss_char),
2646: NVL(hop.credit_score_commentary2, fnd_api.g_miss_char),
2647: NVL(hop.credit_score_commentary3, fnd_api.g_miss_char),
2648: NVL(hop.credit_score_commentary4, fnd_api.g_miss_char),
2649: NVL(hop.credit_score_commentary5, fnd_api.g_miss_char),
2650: NVL(hop.credit_score_commentary6, fnd_api.g_miss_char),
2651: NVL(hop.credit_score_commentary7, fnd_api.g_miss_char),
2652: NVL(hop.credit_score_commentary8, fnd_api.g_miss_char),
2653: NVL(hop.credit_score_commentary9, fnd_api.g_miss_char),
2646: NVL(hop.credit_score_commentary2, fnd_api.g_miss_char),
2647: NVL(hop.credit_score_commentary3, fnd_api.g_miss_char),
2648: NVL(hop.credit_score_commentary4, fnd_api.g_miss_char),
2649: NVL(hop.credit_score_commentary5, fnd_api.g_miss_char),
2650: NVL(hop.credit_score_commentary6, fnd_api.g_miss_char),
2651: NVL(hop.credit_score_commentary7, fnd_api.g_miss_char),
2652: NVL(hop.credit_score_commentary8, fnd_api.g_miss_char),
2653: NVL(hop.credit_score_commentary9, fnd_api.g_miss_char),
2654: NVL(hop.credit_score_commentary10, fnd_api.g_miss_char),
2647: NVL(hop.credit_score_commentary3, fnd_api.g_miss_char),
2648: NVL(hop.credit_score_commentary4, fnd_api.g_miss_char),
2649: NVL(hop.credit_score_commentary5, fnd_api.g_miss_char),
2650: NVL(hop.credit_score_commentary6, fnd_api.g_miss_char),
2651: NVL(hop.credit_score_commentary7, fnd_api.g_miss_char),
2652: NVL(hop.credit_score_commentary8, fnd_api.g_miss_char),
2653: NVL(hop.credit_score_commentary9, fnd_api.g_miss_char),
2654: NVL(hop.credit_score_commentary10, fnd_api.g_miss_char),
2655: NVL(hop.maximum_credit_recommendation, fnd_api.g_miss_num),
2648: NVL(hop.credit_score_commentary4, fnd_api.g_miss_char),
2649: NVL(hop.credit_score_commentary5, fnd_api.g_miss_char),
2650: NVL(hop.credit_score_commentary6, fnd_api.g_miss_char),
2651: NVL(hop.credit_score_commentary7, fnd_api.g_miss_char),
2652: NVL(hop.credit_score_commentary8, fnd_api.g_miss_char),
2653: NVL(hop.credit_score_commentary9, fnd_api.g_miss_char),
2654: NVL(hop.credit_score_commentary10, fnd_api.g_miss_char),
2655: NVL(hop.maximum_credit_recommendation, fnd_api.g_miss_num),
2656: NVL(hop.maximum_credit_currency_code, fnd_api.g_miss_char),
2649: NVL(hop.credit_score_commentary5, fnd_api.g_miss_char),
2650: NVL(hop.credit_score_commentary6, fnd_api.g_miss_char),
2651: NVL(hop.credit_score_commentary7, fnd_api.g_miss_char),
2652: NVL(hop.credit_score_commentary8, fnd_api.g_miss_char),
2653: NVL(hop.credit_score_commentary9, fnd_api.g_miss_char),
2654: NVL(hop.credit_score_commentary10, fnd_api.g_miss_char),
2655: NVL(hop.maximum_credit_recommendation, fnd_api.g_miss_num),
2656: NVL(hop.maximum_credit_currency_code, fnd_api.g_miss_char),
2657: NVL(hop.displayed_duns_party_id, fnd_api.g_miss_num),
2650: NVL(hop.credit_score_commentary6, fnd_api.g_miss_char),
2651: NVL(hop.credit_score_commentary7, fnd_api.g_miss_char),
2652: NVL(hop.credit_score_commentary8, fnd_api.g_miss_char),
2653: NVL(hop.credit_score_commentary9, fnd_api.g_miss_char),
2654: NVL(hop.credit_score_commentary10, fnd_api.g_miss_char),
2655: NVL(hop.maximum_credit_recommendation, fnd_api.g_miss_num),
2656: NVL(hop.maximum_credit_currency_code, fnd_api.g_miss_char),
2657: NVL(hop.displayed_duns_party_id, fnd_api.g_miss_num),
2658: NVL(hop.failure_score_natnl_percentile, fnd_api.g_miss_num),
2651: NVL(hop.credit_score_commentary7, fnd_api.g_miss_char),
2652: NVL(hop.credit_score_commentary8, fnd_api.g_miss_char),
2653: NVL(hop.credit_score_commentary9, fnd_api.g_miss_char),
2654: NVL(hop.credit_score_commentary10, fnd_api.g_miss_char),
2655: NVL(hop.maximum_credit_recommendation, fnd_api.g_miss_num),
2656: NVL(hop.maximum_credit_currency_code, fnd_api.g_miss_char),
2657: NVL(hop.displayed_duns_party_id, fnd_api.g_miss_num),
2658: NVL(hop.failure_score_natnl_percentile, fnd_api.g_miss_num),
2659: NVL(hop.duns_number_c, fnd_api.g_miss_char),
2652: NVL(hop.credit_score_commentary8, fnd_api.g_miss_char),
2653: NVL(hop.credit_score_commentary9, fnd_api.g_miss_char),
2654: NVL(hop.credit_score_commentary10, fnd_api.g_miss_char),
2655: NVL(hop.maximum_credit_recommendation, fnd_api.g_miss_num),
2656: NVL(hop.maximum_credit_currency_code, fnd_api.g_miss_char),
2657: NVL(hop.displayed_duns_party_id, fnd_api.g_miss_num),
2658: NVL(hop.failure_score_natnl_percentile, fnd_api.g_miss_num),
2659: NVL(hop.duns_number_c, fnd_api.g_miss_char),
2660: NVL(hop.bank_or_branch_number, fnd_api.g_miss_char),
2653: NVL(hop.credit_score_commentary9, fnd_api.g_miss_char),
2654: NVL(hop.credit_score_commentary10, fnd_api.g_miss_char),
2655: NVL(hop.maximum_credit_recommendation, fnd_api.g_miss_num),
2656: NVL(hop.maximum_credit_currency_code, fnd_api.g_miss_char),
2657: NVL(hop.displayed_duns_party_id, fnd_api.g_miss_num),
2658: NVL(hop.failure_score_natnl_percentile, fnd_api.g_miss_num),
2659: NVL(hop.duns_number_c, fnd_api.g_miss_char),
2660: NVL(hop.bank_or_branch_number, fnd_api.g_miss_char),
2661: NVL(hop.bank_code, fnd_api.g_miss_char),
2654: NVL(hop.credit_score_commentary10, fnd_api.g_miss_char),
2655: NVL(hop.maximum_credit_recommendation, fnd_api.g_miss_num),
2656: NVL(hop.maximum_credit_currency_code, fnd_api.g_miss_char),
2657: NVL(hop.displayed_duns_party_id, fnd_api.g_miss_num),
2658: NVL(hop.failure_score_natnl_percentile, fnd_api.g_miss_num),
2659: NVL(hop.duns_number_c, fnd_api.g_miss_char),
2660: NVL(hop.bank_or_branch_number, fnd_api.g_miss_char),
2661: NVL(hop.bank_code, fnd_api.g_miss_char),
2662: NVL(hop.branch_code, fnd_api.g_miss_char),
2655: NVL(hop.maximum_credit_recommendation, fnd_api.g_miss_num),
2656: NVL(hop.maximum_credit_currency_code, fnd_api.g_miss_char),
2657: NVL(hop.displayed_duns_party_id, fnd_api.g_miss_num),
2658: NVL(hop.failure_score_natnl_percentile, fnd_api.g_miss_num),
2659: NVL(hop.duns_number_c, fnd_api.g_miss_char),
2660: NVL(hop.bank_or_branch_number, fnd_api.g_miss_char),
2661: NVL(hop.bank_code, fnd_api.g_miss_char),
2662: NVL(hop.branch_code, fnd_api.g_miss_char),
2663: NVL(hop.created_by_module, fnd_api.g_miss_char),
2656: NVL(hop.maximum_credit_currency_code, fnd_api.g_miss_char),
2657: NVL(hop.displayed_duns_party_id, fnd_api.g_miss_num),
2658: NVL(hop.failure_score_natnl_percentile, fnd_api.g_miss_num),
2659: NVL(hop.duns_number_c, fnd_api.g_miss_char),
2660: NVL(hop.bank_or_branch_number, fnd_api.g_miss_char),
2661: NVL(hop.bank_code, fnd_api.g_miss_char),
2662: NVL(hop.branch_code, fnd_api.g_miss_char),
2663: NVL(hop.created_by_module, fnd_api.g_miss_char),
2664: NVL(hop.application_id, fnd_api.g_miss_num),
2657: NVL(hop.displayed_duns_party_id, fnd_api.g_miss_num),
2658: NVL(hop.failure_score_natnl_percentile, fnd_api.g_miss_num),
2659: NVL(hop.duns_number_c, fnd_api.g_miss_char),
2660: NVL(hop.bank_or_branch_number, fnd_api.g_miss_char),
2661: NVL(hop.bank_code, fnd_api.g_miss_char),
2662: NVL(hop.branch_code, fnd_api.g_miss_char),
2663: NVL(hop.created_by_module, fnd_api.g_miss_char),
2664: NVL(hop.application_id, fnd_api.g_miss_num),
2665: NVL(hop.do_not_confuse_with, fnd_api.g_miss_char),
2658: NVL(hop.failure_score_natnl_percentile, fnd_api.g_miss_num),
2659: NVL(hop.duns_number_c, fnd_api.g_miss_char),
2660: NVL(hop.bank_or_branch_number, fnd_api.g_miss_char),
2661: NVL(hop.bank_code, fnd_api.g_miss_char),
2662: NVL(hop.branch_code, fnd_api.g_miss_char),
2663: NVL(hop.created_by_module, fnd_api.g_miss_char),
2664: NVL(hop.application_id, fnd_api.g_miss_num),
2665: NVL(hop.do_not_confuse_with, fnd_api.g_miss_char),
2666: NVL(hop.actual_content_source, fnd_api.g_miss_char),
2659: NVL(hop.duns_number_c, fnd_api.g_miss_char),
2660: NVL(hop.bank_or_branch_number, fnd_api.g_miss_char),
2661: NVL(hop.bank_code, fnd_api.g_miss_char),
2662: NVL(hop.branch_code, fnd_api.g_miss_char),
2663: NVL(hop.created_by_module, fnd_api.g_miss_char),
2664: NVL(hop.application_id, fnd_api.g_miss_num),
2665: NVL(hop.do_not_confuse_with, fnd_api.g_miss_char),
2666: NVL(hop.actual_content_source, fnd_api.g_miss_char),
2667: NVL(hop.home_country, fnd_api.g_miss_char)
2660: NVL(hop.bank_or_branch_number, fnd_api.g_miss_char),
2661: NVL(hop.bank_code, fnd_api.g_miss_char),
2662: NVL(hop.branch_code, fnd_api.g_miss_char),
2663: NVL(hop.created_by_module, fnd_api.g_miss_char),
2664: NVL(hop.application_id, fnd_api.g_miss_num),
2665: NVL(hop.do_not_confuse_with, fnd_api.g_miss_char),
2666: NVL(hop.actual_content_source, fnd_api.g_miss_char),
2667: NVL(hop.home_country, fnd_api.g_miss_char)
2668: FROM hz_organization_profiles hop
2661: NVL(hop.bank_code, fnd_api.g_miss_char),
2662: NVL(hop.branch_code, fnd_api.g_miss_char),
2663: NVL(hop.created_by_module, fnd_api.g_miss_char),
2664: NVL(hop.application_id, fnd_api.g_miss_num),
2665: NVL(hop.do_not_confuse_with, fnd_api.g_miss_char),
2666: NVL(hop.actual_content_source, fnd_api.g_miss_char),
2667: NVL(hop.home_country, fnd_api.g_miss_char)
2668: FROM hz_organization_profiles hop
2669: WHERE hop.organization_profile_id = x_organization_profile_id;
2662: NVL(hop.branch_code, fnd_api.g_miss_char),
2663: NVL(hop.created_by_module, fnd_api.g_miss_char),
2664: NVL(hop.application_id, fnd_api.g_miss_num),
2665: NVL(hop.do_not_confuse_with, fnd_api.g_miss_char),
2666: NVL(hop.actual_content_source, fnd_api.g_miss_char),
2667: NVL(hop.home_country, fnd_api.g_miss_char)
2668: FROM hz_organization_profiles hop
2669: WHERE hop.organization_profile_id = x_organization_profile_id;
2670: BEGIN
2663: NVL(hop.created_by_module, fnd_api.g_miss_char),
2664: NVL(hop.application_id, fnd_api.g_miss_num),
2665: NVL(hop.do_not_confuse_with, fnd_api.g_miss_char),
2666: NVL(hop.actual_content_source, fnd_api.g_miss_char),
2667: NVL(hop.home_country, fnd_api.g_miss_char)
2668: FROM hz_organization_profiles hop
2669: WHERE hop.organization_profile_id = x_organization_profile_id;
2670: BEGIN
2671: OPEN c_orgprof;
2821: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2822: fnd_message.set_token('RECORD', 'organization_rec');
2823: fnd_message.set_token('VALUE', TO_CHAR(x_organization_profile_id));
2824: fnd_msg_pub.add;
2825: RAISE fnd_api.g_exc_error;
2826: END IF;
2827: CLOSE c_orgprof;
2828: END select_row;
2829: