APPS.CSC_UWQ_FORM_ROUTE dependencies on HZ_PHONE_NUMBER_PKG

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

807: if l_phone_passed_flag = 'Y' then
808: l_complete_phone_num := l_ccode || l_acode || l_phone_number;
809: IF l_complete_phone_num IS NOT NULL THEN
810: l_customer_id := NULL;
811: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_complete_phone_num);
812: l_customer_id := CSC_ROUTING_UTL.get_customer_from_reverse_ANI(l_rphone,
813: l_uwq_multi_record_match,
814: l_phone_id);
815: IF l_customer_id IS NOT NULL THEN

Line 842: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_value);

838:
839: --Note: standard REVERSE function cannot be used in PL-SQL as it is a reserved word in PL-SQL
840: --to replace this function REVERSE_NUMBER function was created
841: l_customer_id := NULL;
842: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_value);
843: l_customer_id := CSC_ROUTING_UTL.get_customer_from_reverse_ANI(l_rphone,
844: l_uwq_multi_record_match,
845: l_phone_id);
846: p_action_param := p_action_param||'uwq_party_id="'||l_customer_id ||'" uwq_multi_record_match='