APPS.HZ_TIMEZONE_PUB dependencies on HZ_PHONE_COUNTRY_CODES

Line 313: from hz_phone_country_codes

309: l_api_version CONSTANT NUMBER := 1.0;
310:
311: cursor get_tz_by_pcc_csr is
312: select timezone_id
313: from hz_phone_country_codes
314: where phone_country_code = p_phone_country_code;
315:
316: cursor get_tz_by_pcc_cc_csr is
317: select timezone_id

Line 318: from hz_phone_country_codes

314: where phone_country_code = p_phone_country_code;
315:
316: cursor get_tz_by_pcc_cc_csr is
317: select timezone_id
318: from hz_phone_country_codes
319: where territory_code = p_country_code
320: and phone_country_code = p_phone_country_code;
321:
322: cursor get_country_tz_count_csr is

Line 324: from hz_phone_country_codes

320: and phone_country_code = p_phone_country_code;
321:
322: cursor get_country_tz_count_csr is
323: select count(*)
324: from hz_phone_country_codes
325: where phone_country_code = p_phone_country_code;
326:
327: cursor get_area_code_tzone_csr is
328: select timezone_id

Line 430: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');

426: if x_timezone_id is null
427: then
428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
429: FND_MESSAGE.SET_TOKEN('COLUMN','phone_country_code+country_code');
430: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');
431: FND_MSG_PUB.ADD;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: RAISE FND_API.G_EXC_ERROR;
434: end if; -- x_timezone_id is null

Line 447: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');

443: elsif l_count = 0
444: then
445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
446: FND_MESSAGE.SET_TOKEN('COLUMN','PHONE_COUNTRY_CODE');
447: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');
448: FND_MSG_PUB.ADD;
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: RAISE FND_API.G_EXC_ERROR;
451: end if; -- l_count = 1