APPS.HZ_PHONE_AREA_CODES_PKG dependencies on HZ_PHONE_AREA_CODES

Line 1: PACKAGE BODY HZ_PHONE_AREA_CODES_PKG AS

1: PACKAGE BODY HZ_PHONE_AREA_CODES_PKG AS
2: /*$Header: ARHPHARB.pls 120.5 2005/10/30 03:54:00 appldev noship $ */
3:
4: PROCEDURE Insert_Row(
5: p_rowid IN OUT NOCOPY VARCHAR2,

Line 18: CURSOR C IS SELECT rowid FROM HZ_PHONE_AREA_CODES

14: p_LAST_UPDATED_BY NUMBER,
15: p_OBJECT_VERSION_NUMBER NUMBER,
16: p_TIMEZONE_ID NUMBER DEFAULT NULL) IS
17:
18: CURSOR C IS SELECT rowid FROM HZ_PHONE_AREA_CODES
19: WHERE TERRITORY_CODE = p_TERRITORY_CODE
20: AND AREA_CODE = p_AREA_CODE ;
21:
22:

Line 25: insert into HZ_PHONE_AREA_CODES(

21:
22:
23: begin
24:
25: insert into HZ_PHONE_AREA_CODES(
26: TERRITORY_CODE,
27: AREA_CODE,
28: PHONE_COUNTRY_CODE,
29: DESCRIPTION ,

Line 79: UPDATE HZ_PHONE_AREA_CODES

75: BEGIN
76:
77: l_object_version_number := NVL(p_object_version_number, 1) + 1;
78:
79: UPDATE HZ_PHONE_AREA_CODES
80: SET
81: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
82: TERRITORY_CODE, p_TERRITORY_CODE),
83: AREA_CODE = decode(p_AREA_CODE, FND_API.G_MISS_CHAR,

Line 123: FROM HZ_PHONE_AREA_CODES

119: IS
120: CURSOR C IS
121:
122: SELECT OBJECT_VERSION_NUMBER
123: FROM HZ_PHONE_AREA_CODES
124: WHERE TERRITORY_CODE = p_TERRITORY_CODE
125: AND AREA_CODE = p_AREA_CODE
126: FOR UPDATE OF TERRITORY_CODE , AREA_CODE NOWAIT;
127: Recinfo C%ROWTYPE;

Line 153: DELETE FROM HZ_PHONE_AREA_CODES

149: END Lock_Row;
150:
151: PROCEDURE Delete_Row(p_TERRITORY_CODE VARCHAR2, P_AREA_CODE VARCHAR2 ) IS
152: BEGIN
153: DELETE FROM HZ_PHONE_AREA_CODES
154: WHERE TERRITORY_CODE = p_TERRITORY_CODE
155: AND AREA_CODE = p_AREA_CODE;
156:
157: If (SQL%NOTFOUND) then