APPS.HZ_FUZZY_PUB dependencies on FND_PROFILE

Line 349: if NVL(fnd_profile.value('HZ_CLEANSE_FUZZY_KEY'),'Y') = 'Y' then

345: -- Cleanse converts double letters to single letter, removes
346: -- vowels inside a word.
347: -- For example : UNIVERSAL - UNVRSL, LITTLE - LTL etc.
348: -- Bug 2059524,added NVL function in the following line.
349: if NVL(fnd_profile.value('HZ_CLEANSE_FUZZY_KEY'),'Y') = 'Y' then
350: l_current_word := cleanse(l_current_word);
351: end if;
352:
353: -- Step 8.

Line 764: l_word_count := to_number( (NVL(FND_PROFILE.Value('HZ_KEY_WORD_COUNT'), '4')) );

760:
761: -- Org or Group key is generated for HZ_CUSTOMER_KEY_WORD_COUNT words in the party name
762: -- We need to parse the party name to figure out how much information to pass to
763: -- the replace word function
764: l_word_count := to_number( (NVL(FND_PROFILE.Value('HZ_KEY_WORD_COUNT'), '4')) );
765: l_word_length := instrb(l_party_name, ' ', 1, l_word_count);
766: IF l_word_length = 0
767: THEN
768: l_word_length := lengthb(l_party_name);

Line 784: -- l_address_index := to_number(NVL(FND_PROFILE.Value('HZ_ADDRESS_KEY_INDEX'), '1') );

780: -- The address key is either address1.postal_code or address2.postal_code
781: -- or address3.postal_code or address4.postal_code
782: -- depending upon profile HZ_ADDRESS_KEY_INDEX
783: --
784: -- l_address_index := to_number(NVL(FND_PROFILE.Value('HZ_ADDRESS_KEY_INDEX'), '1') );
785:
786: -- The above code is remarked now as we want to generate keys using address1
787: -- only for the time being. Later when fuzzy search would be related to the
788: -- above profile option setting, the address column will be selected based

Line 816: l_word_length := to_number(NVL(FND_PROFILE.Value('HZ_ADDRESS_KEY_LENGTH'), '15'));

812: l_key := Replace_Word(l_address_word, 'ADDRESS');
813:
814: -- Truncate to be the length of the Address Key Length Profile
815: --
816: l_word_length := to_number(NVL(FND_PROFILE.Value('HZ_ADDRESS_KEY_LENGTH'), '15'));
817: l_key := substrb(l_key, 1, l_word_length);
818:
819: -- Get the amount of the postal code to use for generating the key
820: --

Line 821: l_word_length := to_number(NVL(FND_PROFILE.Value('HZ_POSTAL_CODE_KEY_LENGTH'), lengthb(l_postal_code) ));

817: l_key := substrb(l_key, 1, l_word_length);
818:
819: -- Get the amount of the postal code to use for generating the key
820: --
821: l_word_length := to_number(NVL(FND_PROFILE.Value('HZ_POSTAL_CODE_KEY_LENGTH'), lengthb(l_postal_code) ));
822: l_postal_word := substrb(l_postal_code, 1, l_word_length);
823:
824: -- if FND_API.G_MISS_CHAR has been passed for postal code, that should be treated as NULL
825: if l_postal_word = FND_API.G_MISS_CHAR then