APPS.XNP_GEO_AREAS_PKG dependencies on XNP_GEO_AREAS_TL

Line 43: insert into XNP_GEO_AREAS_TL (

39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN
41: );
42:
43: insert into XNP_GEO_AREAS_TL (
44: GEO_AREA_ID,
45: DISPLAY_NAME,
46: DESCRIPTION,
47: CREATED_BY,

Line 69: from XNP_GEO_AREAS_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from XNP_GEO_AREAS_TL T
70: where T.GEO_AREA_ID = X_GEO_AREA_ID
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: open c;

Line 104: from XNP_GEO_AREAS_TL

100: cursor c1 is select
101: DISPLAY_NAME,
102: DESCRIPTION,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from XNP_GEO_AREAS_TL
105: where GEO_AREA_ID = X_GEO_AREA_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of GEO_AREA_ID nowait;
108: begin

Line 168: update XNP_GEO_AREAS_TL set

164: if (sql%notfound) then
165: raise no_data_found;
166: end if;
167:
168: update XNP_GEO_AREAS_TL set
169: DISPLAY_NAME = X_DISPLAY_NAME,
170: DESCRIPTION = X_DESCRIPTION,
171: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
172: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 187: delete from XNP_GEO_AREAS_TL

183: procedure DELETE_ROW (
184: X_GEO_AREA_ID in NUMBER
185: ) is
186: begin
187: delete from XNP_GEO_AREAS_TL
188: where GEO_AREA_ID = X_GEO_AREA_ID;
189:
190: if (sql%notfound) then
191: raise no_data_found;

Line 205: delete from XNP_GEO_AREAS_TL T

201:
202: procedure ADD_LANGUAGE
203: is
204: begin
205: delete from XNP_GEO_AREAS_TL T
206: where not exists
207: (select NULL
208: from XNP_GEO_AREAS_B B
209: where B.GEO_AREA_ID = T.GEO_AREA_ID

Line 212: update XNP_GEO_AREAS_TL T set (

208: from XNP_GEO_AREAS_B B
209: where B.GEO_AREA_ID = T.GEO_AREA_ID
210: );
211:
212: update XNP_GEO_AREAS_TL T set (
213: DISPLAY_NAME,
214: DESCRIPTION
215: ) = (select
216: B.DISPLAY_NAME,

Line 218: from XNP_GEO_AREAS_TL B

214: DESCRIPTION
215: ) = (select
216: B.DISPLAY_NAME,
217: B.DESCRIPTION
218: from XNP_GEO_AREAS_TL B
219: where B.GEO_AREA_ID = T.GEO_AREA_ID
220: and B.LANGUAGE = T.SOURCE_LANG)
221: where (
222: T.GEO_AREA_ID,

Line 227: from XNP_GEO_AREAS_TL SUBB, XNP_GEO_AREAS_TL SUBT

223: T.LANGUAGE
224: ) in (select
225: SUBT.GEO_AREA_ID,
226: SUBT.LANGUAGE
227: from XNP_GEO_AREAS_TL SUBB, XNP_GEO_AREAS_TL SUBT
228: where SUBB.GEO_AREA_ID = SUBT.GEO_AREA_ID
229: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
230: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
231: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 236: insert into XNP_GEO_AREAS_TL (

232: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
233: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
234: ));
235:
236: insert into XNP_GEO_AREAS_TL (
237: GEO_AREA_ID,
238: DISPLAY_NAME,
239: DESCRIPTION,
240: CREATED_BY,

Line 258: from XNP_GEO_AREAS_TL B, FND_LANGUAGES L

254: B.LAST_UPDATE_DATE,
255: B.LAST_UPDATE_LOGIN,
256: L.LANGUAGE_CODE,
257: B.SOURCE_LANG
258: from XNP_GEO_AREAS_TL B, FND_LANGUAGES L
259: where L.INSTALLED_FLAG in ('I', 'B')
260: and B.LANGUAGE = userenv('LANG')
261: and not exists
262: (select NULL

Line 263: from XNP_GEO_AREAS_TL T

259: where L.INSTALLED_FLAG in ('I', 'B')
260: and B.LANGUAGE = userenv('LANG')
261: and not exists
262: (select NULL
263: from XNP_GEO_AREAS_TL T
264: where T.GEO_AREA_ID = B.GEO_AREA_ID
265: and T.LANGUAGE = L.LANGUAGE_CODE);
266: end ADD_LANGUAGE;
267: procedure LOAD_ROW (

Line 358: UPDATE XNP_GEO_AREAS_TL

354: -- l_geo_area_id := 0;
355: -- END IF;
356:
357: -- Only update rows which have not been altered by user
358: UPDATE XNP_GEO_AREAS_TL
359: SET description = X_DESCRIPTION,
360: display_name = X_DISPLAY_NAME,
361: source_lang = userenv('LANG'),
362: last_update_date = sysdate,