[Home] [Help]
1: PACKAGE BODY CSC_ROUTING_UTL AS
2: /* $Header: cscotmrb.pls 120.20 2006/11/02 18:59:49 hbchung ship $ */
3:
4: ------------------------------------------------------------------------------
5: -- Procedure: decode_ani
1338: l_media_type := cct_collection_util_pub.get(p_media_data, 'occtMediaType', x_exist_flag);
1339: l_callID := cct_collection_util_pub.get(p_media_data, 'occtCallID', x_exist_flag);
1340: l_sender_name := cct_collection_util_pub.get(p_media_data, 'oiemSenderName', x_exist_flag);
1341: if x_exist_flag = 'Y' and l_sender_name is not null then
1342: l_email_cust_id := csc_routing_utl.Get_Customer_from_Email(l_sender_name);
1343: end if;
1344: l_cust_prod_id := cct_collection_util_pub.get(p_media_data, 'CustomerProductID', x_exist_flag);
1345: l_inv_item_id := cct_collection_util_pub.get(p_media_data, 'InventoryItemID', x_exist_flag);
1346: l_emp_id := cct_collection_util_pub.get(p_media_data, 'employeeID', x_exist_flag);
1911:
1912: --Customer Num LookUp
1913: If l_customer_num is not null THEN
1914: l_customer_id := null;
1915: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum(p_party_number => l_customer_num);
1916: IF l_customer_id IS NOT NULL THEN
1917: l_match := '1';
1918: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
1919:
1935:
1936: --AccountCode lookup
1937: IF l_account_code IS NOT NULL THEN
1938: l_customer_id := null;
1939: CSC_ROUTING_UTL.Get_Cust_Acct_From_Account_Num( p_cust_acct_number => l_account_code,
1940: x_party_id => l_customer_id,
1941: x_cust_account_id => l_cust_account_id,
1942: x_last_update_date => l_acct_last_update_date);
1943: IF l_customer_id IS NOT NULL 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');
1979:
2026:
2027: --Contact Num lookup
2028: IF l_contact_num IS NOT NULL THEN
2029: l_customer_id := null;
2030: l_customer_id := CSC_ROUTING_UTL.Get_Customer_From_CustomerNum( p_party_number => l_contact_num);
2031: IF l_customer_id IS NOT NULL THEN
2032: l_match := '1';
2033: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'WhichIVR','PartyID');
2034: l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'CustomerID',l_customer_id);
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');
2059:
2106: -- l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'DONE_IT','DONE');
2107:
2108: END CSC_Customer_Lookup;
2109:
2110: END CSC_Routing_UTL;
2111: