APPS.CSC_UWQ_FORM_ROUTE dependencies on HZ_PHONE_NUMBER_PKG

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

813: if l_phone_passed_flag = 'Y' then
814: l_complete_phone_num := l_ccode || l_acode || l_phone_number;
815: IF l_complete_phone_num IS NOT NULL THEN
816: l_customer_id := NULL;
817: l_rphone := HZ_PHONE_NUMBER_PKG.transpose(l_complete_phone_num);
818: l_customer_id := CSC_ROUTING_UTL.get_customer_from_reverse_ANI(l_rphone,
819: l_uwq_multi_record_match,
820: l_phone_id);
821: IF l_customer_id IS NOT NULL THEN

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

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