DBA Data[Home] [Help]

APPS.CSC_ROUTING_UTL dependencies on STANDARD

Line 964: -- This function can be used instead of the standard REVERSE

960: ------------------------------------------------------------------------------
961: -- Function : reverse_number
962: -- Usage : Used to get reverse number for the number passed to function
963: -- Description : This function is built to reverse the number passed to it.
964: -- This function can be used instead of the standard REVERSE
965: -- function because the REVERSE fucntion cannot be used in PL/
966: -- Parameters :
967: -- p_phone_number IN VARCHAR2(1996) Required
968: --

Line 2051: --Note: standard REVERSE function cannot be used in PL-SQL as it is a reserved word in PL-SQL

2047:
2048:
2049: --ANI lookup
2050: IF l_ani IS NOT NULL THEN
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,