APPS.HZ_FORMAT_PHONE_V2PUB dependencies on HZ_MOBILE_PREFIXES

Line 1367: l_mobile_prefix_check HZ_MOBILE_PREFIXES.MOBILE_PREFIX%TYPE;

1363: l_debug_prefix VARCHAR2(30) := ''; -- translate_raw_phone_number
1364: l_possible_prefix VARCHAR2(30);
1365: l_count_mobile_prefix NUMBER := 0;
1366: l_length_mobile_prefix NUMBER := 0;
1367: l_mobile_prefix_check HZ_MOBILE_PREFIXES.MOBILE_PREFIX%TYPE;
1368: l_mobile_prefix HZ_MOBILE_PREFIXES.MOBILE_PREFIX%TYPE;
1369:
1370: BEGIN
1371:

Line 1368: l_mobile_prefix HZ_MOBILE_PREFIXES.MOBILE_PREFIX%TYPE;

1364: l_possible_prefix VARCHAR2(30);
1365: l_count_mobile_prefix NUMBER := 0;
1366: l_length_mobile_prefix NUMBER := 0;
1367: l_mobile_prefix_check HZ_MOBILE_PREFIXES.MOBILE_PREFIX%TYPE;
1368: l_mobile_prefix HZ_MOBILE_PREFIXES.MOBILE_PREFIX%TYPE;
1369:
1370: BEGIN
1371:
1372: SAVEPOINT check_mobile_phone;

Line 1401: from hz_mobile_prefixes

1397: l_possible_prefix := filter_phone_number (l_possible_prefix);
1398:
1399: select count(mobile_prefix)
1400: into l_count_mobile_prefix
1401: from hz_mobile_prefixes
1402: where phone_country_code = p_phone_country_code;
1403:
1404: select max(length(mobile_prefix))
1405: into l_length_mobile_prefix

Line 1406: from hz_mobile_prefixes

1402: where phone_country_code = p_phone_country_code;
1403:
1404: select max(length(mobile_prefix))
1405: into l_length_mobile_prefix
1406: from hz_mobile_prefixes
1407: where phone_country_code = p_phone_country_code;
1408:
1409: IF l_count_mobile_prefix > 0 then
1410:

Line 1419: from hz_mobile_prefixes

1415: l_mobile_prefix_check := SUBSTR(l_possible_prefix,1,i);
1416:
1417: select mobile_prefix
1418: into l_mobile_prefix
1419: from hz_mobile_prefixes
1420: where mobile_prefix = l_mobile_prefix_check
1421: and phone_country_code = p_phone_country_code ;
1422:
1423: if l_mobile_prefix_check = l_mobile_prefix then