APPS.CSC_UWQ_FORM_ROUTE dependencies on CSC_ROUTING_UTL

Line 252: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_value);

248: p_action_param := p_action_param||'uwq_media_type="'||l_value||'"';
249: ELSIF l_name = 'occtCallID' THEN
250: p_action_param := p_action_param||'uwq_call_id="'||l_value||'"';
251: ELSIF l_name = 'oiemSenderName' and l_value is not null THEN
252: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_value);
253: ELSIF l_name = 'CustomerProductID' THEN
254: p_action_param := p_action_param||'uwq_cust_prod_id="'||l_value||'"';
255: ELSIF l_name = 'InventoryItemID' THEN
256: p_action_param := p_action_param||'uwq_inventory_id="'||l_value||'"';

Line 788: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum(p_party_number => l_value);

784:
785: l_value := get_media_value('CustomerNum');
786: IF l_value IS NOT NULL THEN
787: l_customer_id := null;
788: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum(p_party_number => l_value);
789: IF l_customer_id IS NOT NULL THEN
790: p_action_param := p_action_param||'uwq_party_id="'||l_customer_id ||'"';
791: RETURN;
792: END IF;

Line 800: CSC_ROUTING_UTL.Get_Cust_Acct_From_Account_Num( p_cust_acct_number => l_value,

796: --so that it does not have to be re-queried on the client side
797: l_value := get_media_value('AccountCode');
798: IF l_value IS NOT NULL THEN
799: l_customer_id := null;
800: CSC_ROUTING_UTL.Get_Cust_Acct_From_Account_Num( p_cust_acct_number => l_value,
801: x_party_id => l_customer_id,
802: x_cust_account_id => l_cust_account_id,
803: x_last_update_date => l_acct_last_update_date);
804: IF l_customer_id IS NOT NULL THEN

Line 818: l_customer_id := CSC_ROUTING_UTL.get_customer_from_reverse_ANI(l_rphone,

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
822: p_action_param := p_action_param||'uwq_party_id="'||l_customer_id ||'" uwq_multi_record_match='

Line 834: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum( p_party_number => l_value);

830:
831: l_value := get_media_value('ContactNum');
832: IF l_value IS NOT NULL THEN
833: l_customer_id := null;
834: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum( p_party_number => l_value);
835: IF l_customer_id IS NOT NULL THEN
836: p_action_param := p_action_param||'uwq_party_id="'||l_customer_id ||'"';
837: RETURN;
838: END IF;

Line 849: l_customer_id := CSC_ROUTING_UTL.get_customer_from_reverse_ANI(l_rphone,

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='
853: ||NVL(l_uwq_multi_record_match,'""')||' uwq_reverse_ani="'||l_rphone||'"';