APPS.HZ_TIMEZONE_UTILS_PVT dependencies on HZ_PHONE_COUNTRY_CODES

Line 8: from hz_phone_country_codes

4: procedure duplicate_country_code(p_territory_code in varchar2, x_return_status out nocopy varchar2) is
5:
6: cursor territory_code_exist_csr is
7: select 'Y'
8: from hz_phone_country_codes
9: where territory_code = p_territory_code;
10:
11: l_exist varchar2(1);
12:

Line 282: FROM HZ_PHONE_COUNTRY_CODES

278:
279: BEGIN
280: SELECT OBJECT_VERSION_NUMBER
281: INTO l_object_version_number
282: FROM HZ_PHONE_COUNTRY_CODES
283: WHERE TERRITORY_CODE = p_territory_code
284: FOR UPDATE OF TERRITORY_CODE NOWAIT;
285:
286: IF NOT ((p_object_version_number is null and l_object_version_number is

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

287: null)
288: OR (p_object_version_number = l_object_version_number))
289: THEN
290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
291: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');
292: FND_MSG_PUB.ADD;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;

Line 312: update hz_phone_country_codes

308: RAISE FND_API.G_EXC_ERROR;
309: END IF;
310:
311:
312: update hz_phone_country_codes
313: set timezone_id = p_timezone_id,
314: object_version_number = nvl(l_object_version_number, 1) + 1,
315: -- Bug 3032780
316: --CREATED_BY =hz_utility_v2pub.created_by,