1047: IF p_rANI IS NULL THEN
1048: RETURN to_number(NULL);
1049: END IF;
1050:
1051: fnd_profile.get('CSC_CUSTOMER_FROM_EXACT_ANI',n_use_exact_ani);
1052: IF NVL(n_use_exact_ani,'Y') = 'Y' THEN
1053: l_rANI := p_rANI||'%';
1054: OPEN transpose_phone_cur;
1055: LOOP
1993: ELSE
1994: IF l_uwq_multi_record_match is not null THEN
1995: l_match := 'M';
1996: l_uwq_multi_record_match := 'MULTIPLE_PHONE_NUMBERS';
1997: fnd_profile.get('CSC_CUSTOMER_FROM_EXACT_ANI',n_use_exact_ani);
1998: IF NVL(n_use_exact_ani,'Y') = 'N' THEN
1999: l_stripped_rANI := SUBSTR(l_rphone,1, LENGTH(l_rphone)-1);
2000: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_stripped_reverse_ani',l_stripped_rANI);
2001: END IF;
2072: ELSE
2073: IF l_uwq_multi_record_match is not null THEN
2074: l_match := 'M';
2075: l_uwq_multi_record_match := 'MULTIPLE_PHONE_NUMBERS';
2076: fnd_profile.get('CSC_CUSTOMER_FROM_EXACT_ANI',n_use_exact_ani);
2077:
2078: IF NVL(n_use_exact_ani,'Y') = 'N' THEN
2079: l_stripped_rANI := SUBSTR(l_rphone,1, LENGTH(l_rphone)-1);
2080: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_stripped_reverse_ani',l_stripped_rANI);