DBA Data[Home] [Help]

APPS.CSC_ROUTING_UTL dependencies on FND_PROFILE

Line 1051: fnd_profile.get('CSC_CUSTOMER_FROM_EXACT_ANI',n_use_exact_ani);

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

Line 1997: fnd_profile.get('CSC_CUSTOMER_FROM_EXACT_ANI',n_use_exact_ani);

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;

Line 2076: fnd_profile.get('CSC_CUSTOMER_FROM_EXACT_ANI',n_use_exact_ani);

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);