APPS.HZ_PHONE_COUNTRY_CODES_PKG dependencies on HZ_PHONE_COUNTRY_CODES

Line 1: PACKAGE BODY HZ_PHONE_COUNTRY_CODES_PKG AS

1: PACKAGE BODY HZ_PHONE_COUNTRY_CODES_PKG AS
2: /*$Header: ARHPHCCB.pls 120.5 2005/10/30 03:54:02 appldev noship $ */
3: PROCEDURE Update_Row(
4: p_TERRITORY_CODE VARCHAR2,
5: p_PHONE_COUNTRY_CODE VARCHAR2,

Line 25: UPDATE HZ_PHONE_COUNTRY_CODES

21: BEGIN
22:
23: l_object_version_number := NVL(p_object_version_number, 1) + 1;
24:
25: UPDATE HZ_PHONE_COUNTRY_CODES
26: SET
27: phone_country_code = decode(p_phone_country_code,FND_API.G_MISS_CHAR,
28: phone_country_code, p_phone_country_code),
29: PHONE_LENGTH =decode(p_PHONE_LENGTH,FND_API.G_MISS_NUM,

Line 72: FROM HZ_PHONE_COUNTRY_CODES

68: IS
69: CURSOR C IS
70:
71: SELECT OBJECT_VERSION_NUMBER
72: FROM HZ_PHONE_COUNTRY_CODES
73: WHERE TERRITORY_CODE = p_TERRITORY_CODE
74: FOR UPDATE OF TERRITORY_CODE NOWAIT;
75: Recinfo C%ROWTYPE;
76: BEGIN