APPS.CSC_ROUTING_UTL dependencies on HZ_PHONE_NUMBER_PKG

Line 1974: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_complete_phone_num);

1970: IF l_phone_passed_flag = 'Y' THEN
1971: l_complete_phone_num := l_country_code || l_area_code || l_phone_num;
1972: IF l_complete_phone_num IS NOT NULL THEN
1973: l_customer_id := NULL;
1974: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_complete_phone_num);
1975: l_customer_id := CSC_ROUTING_UTL.get_customer_from_reverse_ANI(l_rphone,
1976: l_uwq_multi_record_match,
1977: l_phone_id);
1978: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','CompletePhone');

Line 2054: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_ani);

2050: IF l_ani IS NOT NULL THEN
2051: --Note: standard REVERSE function cannot be used in PL-SQL as it is a reserved word in PL-SQL
2052: --to replace this function REVERSE_NUMBER function was created
2053: l_customer_id := NULL;
2054: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_ani);
2055: l_customer_id := CSC_ROUTING_UTL.get_customer_from_reverse_ANI(l_rphone,
2056: l_uwq_multi_record_match,
2057: l_phone_id);
2058: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','ANI');