APPS.IEC_G_REGION_MAPPINGS_PKG dependencies on IEC_G_REGION_MAPPINGS

Line 1: package body IEC_G_REGION_MAPPINGS_PKG as

1: package body IEC_G_REGION_MAPPINGS_PKG as
2: /* $Header: IECRGNMB.pls 120.1 2005/07/19 13:07:05 appldev noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 17: from IEC_G_REGION_MAPPINGS

13: X_LAST_UPDATE_LOGIN in NUMBER,
14: X_OBJECT_VERSION_NUMBER in NUMBER
15: ) is
16: cursor C is select ROWID
17: from IEC_G_REGION_MAPPINGS
18: where
19: TERRITORY_CODE = X_TERRITORY_CODE
20: and PHONE_AREA_CODE = X_PHONE_AREA_CODE
21: and REGION_ID = X_REGION_ID;

Line 25: insert into IEC_G_REGION_MAPPINGS

21: and REGION_ID = X_REGION_ID;
22:
23: begin
24:
25: insert into IEC_G_REGION_MAPPINGS
26: (TERRITORY_CODE,
27: PHONE_AREA_CODE,
28: REGION_ID,
29: CREATED_BY,

Line 65: from IEC_G_REGION_MAPPINGS

61: ) is
62: cursor c is select
63: REGION_ID,
64: OBJECT_VERSION_NUMBER
65: from IEC_G_REGION_MAPPINGS
66: where TERRITORY_CODE = X_TERRITORY_CODE
67: and PHONE_AREA_CODE = X_PHONE_AREA_CODE
68: for update of REGION_ID, OBJECT_VERSION_NUMBER nowait;
69: recinfo c%rowtype;

Line 101: update IEC_G_REGION_MAPPINGS

97: X_OBJECT_VERSION_NUMBER in NUMBER
98: ) is
99: begin
100:
101: update IEC_G_REGION_MAPPINGS
102: set REGION_ID = X_REGION_ID,
103: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
104: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
105: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 120: delete from IEC_G_REGION_MAPPINGS

116: X_TERRITORY_CODE in VARCHAR2,
117: X_PHONE_AREA_CODE in VARCHAR2
118: ) is
119: begin
120: delete from IEC_G_REGION_MAPPINGS
121: where TERRITORY_CODE = X_TERRITORY_CODE
122: and PHONE_AREA_CODE = X_PHONE_AREA_CODE;
123:
124: if (sql%notfound) then

Line 158: IEC_G_REGION_MAPPINGS_PKG.TRANSLATE_ROW(

154: X_OWNER in VARCHAR2
155: ) is
156: begin
157: if(X_upload_mode = 'NLS') then
158: IEC_G_REGION_MAPPINGS_PKG.TRANSLATE_ROW(
159: X_TERRITORY_CODE,
160: X_PHONE_AREA_CODE,
161: X_REGION_ID,
162: X_OWNER);

Line 164: IEC_G_REGION_MAPPINGS_PKG.LOAD_ROW(

160: X_PHONE_AREA_CODE,
161: X_REGION_ID,
162: X_OWNER);
163: else
164: IEC_G_REGION_MAPPINGS_PKG.LOAD_ROW(
165: X_TERRITORY_CODE,
166: X_PHONE_AREA_CODE,
167: X_REGION_ID,
168: X_OWNER);

Line 181: update IEC_G_REGION_MAPPINGS

177: ) is
178: begin
179:
180:
181: update IEC_G_REGION_MAPPINGS
182: set REGION_ID = X_REGION_ID,
183: LAST_UPDATE_DATE = SYSDATE,
184: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
185: LAST_UPDATE_LOGIN = 0

Line 193: end IEC_G_REGION_MAPPINGS_PKG;

189: where INSTALLED_FLAG = 'B' );
190:
191: end TRANSLATE_ROW;
192:
193: end IEC_G_REGION_MAPPINGS_PKG;