APPS.IEC_HZ_PHONE_AREA_CODES_PKG dependencies on HZ_PHONE_AREA_CODES

Line 1: package body IEC_HZ_PHONE_AREA_CODES_PKG as

1: package body IEC_HZ_PHONE_AREA_CODES_PKG as
2: /* $Header: IECHZACB.pls 120.1 2005/07/20 06:26:09 appldev noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 18: from HZ_PHONE_AREA_CODES

14: X_LAST_UPDATE_LOGIN in NUMBER,
15: X_OBJECT_VERSION_NUMBER in NUMBER
16: ) is
17: cursor C is select ROWID
18: from HZ_PHONE_AREA_CODES
19: where
20: TERRITORY_CODE = X_TERRITORY_CODE
21: and AREA_CODE = X_AREA_CODE;
22:

Line 25: insert into HZ_PHONE_AREA_CODES

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

Line 69: from HZ_PHONE_AREA_CODES

65: cursor c is select
66: PHONE_COUNTRY_CODE,
67: DESCRIPTION,
68: OBJECT_VERSION_NUMBER
69: from HZ_PHONE_AREA_CODES
70: where TERRITORY_CODE = X_TERRITORY_CODE
71: and AREA_CODE = X_AREA_CODE
72: for update of PHONE_COUNTRY_CODE, DESCRIPTION, OBJECT_VERSION_NUMBER nowait;
73: recinfo c%rowtype;

Line 107: update HZ_PHONE_AREA_CODES

103: X_OBJECT_VERSION_NUMBER in NUMBER
104: ) is
105: begin
106:
107: update HZ_PHONE_AREA_CODES
108: set PHONE_COUNTRY_CODE = X_PHONE_COUNTRY_CODE,
109: DESCRIPTION = X_DESCRIPTION,
110: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
111: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 127: delete from HZ_PHONE_AREA_CODES

123: X_TERRITORY_CODE in VARCHAR2,
124: X_AREA_CODE in VARCHAR2
125: ) is
126: begin
127: delete from HZ_PHONE_AREA_CODES
128: where TERRITORY_CODE = X_TERRITORY_CODE
129: and AREA_CODE = X_AREA_CODE;
130:
131: if (sql%notfound) then

Line 168: IEC_HZ_PHONE_AREA_CODES_PKG.TRANSLATE_ROW(

164: ) is
165: begin
166:
167: if (X_upload_mode = 'NLS') then
168: IEC_HZ_PHONE_AREA_CODES_PKG.TRANSLATE_ROW(
169: X_TERRITORY_CODE,
170: X_PHONE_COUNTRY_CODE,
171: X_AREA_CODE,
172: X_DESCRIPTION,

Line 175: IEC_HZ_PHONE_AREA_CODES_PKG.LOAD_ROW(

171: X_AREA_CODE,
172: X_DESCRIPTION,
173: X_OWNER);
174: else
175: IEC_HZ_PHONE_AREA_CODES_PKG.LOAD_ROW(
176: X_TERRITORY_CODE,
177: X_PHONE_COUNTRY_CODE,
178: X_AREA_CODE,
179: X_DESCRIPTION,

Line 193: update HZ_PHONE_AREA_CODES

189: X_OWNER in VARCHAR2
190: ) is
191: begin
192:
193: update HZ_PHONE_AREA_CODES
194: set PHONE_COUNTRY_CODE = X_PHONE_COUNTRY_CODE,
195: DESCRIPTION = X_DESCRIPTION,
196: LAST_UPDATE_DATE = SYSDATE,
197: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),

Line 207: end IEC_HZ_PHONE_AREA_CODES_PKG;

203:
204: end TRANSLATE_ROW;
205:
206:
207: end IEC_HZ_PHONE_AREA_CODES_PKG;