APPS.CSC_UWQ_FORM_ROUTE dependencies on CSC_ROUTING_UTL

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

243: p_action_param := p_action_param||'uwq_media_type="'||l_value||'"';
244: ELSIF l_name = 'occtCallID' THEN
245: p_action_param := p_action_param||'uwq_call_id="'||l_value||'"';
246: ELSIF l_name = 'oiemSenderName' and l_value is not null THEN
247: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_value);
248: ELSIF l_name = 'CustomerProductID' THEN
249: p_action_param := p_action_param||'uwq_cust_prod_id="'||l_value||'"';
250: ELSIF l_name = 'InventoryItemID' THEN
251: p_action_param := p_action_param||'uwq_inventory_id="'||l_value||'"';

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

778:
779: l_value := get_media_value('CustomerNum');
780: IF l_value IS NOT NULL THEN
781: l_customer_id := null;
782: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum(p_party_number => l_value);
783: IF l_customer_id IS NOT NULL THEN
784: p_action_param := p_action_param||'uwq_party_id="'||l_customer_id ||'"';
785: RETURN;
786: END IF;

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

790: --so that it does not have to be re-queried on the client side
791: l_value := get_media_value('AccountCode');
792: IF l_value IS NOT NULL THEN
793: l_customer_id := null;
794: CSC_ROUTING_UTL.Get_Cust_Acct_From_Account_Num( p_cust_acct_number => l_value,
795: x_party_id => l_customer_id,
796: x_cust_account_id => l_cust_account_id,
797: x_last_update_date => l_acct_last_update_date);
798: IF l_customer_id IS NOT NULL THEN

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

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

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

824:
825: l_value := get_media_value('ContactNum');
826: IF l_value IS NOT NULL THEN
827: l_customer_id := null;
828: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum( p_party_number => l_value);
829: IF l_customer_id IS NOT NULL THEN
830: p_action_param := p_action_param||'uwq_party_id="'||l_customer_id ||'"';
831: RETURN;
832: END IF;

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

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