APPS.JTF_LOC_AREAS_PKG dependencies on JTF_LOC_AREAS_TL

Line 70: insert into JTF_LOC_AREAS_TL (

66: X_LAST_UPDATED_BY,
67: X_LAST_UPDATE_LOGIN
68: );
69:
70: insert into JTF_LOC_AREAS_TL (
71: LOCATION_AREA_ID,
72: LAST_UPDATE_DATE,
73: LAST_UPDATED_BY,
74: CREATION_DATE,

Line 96: from JTF_LOC_AREAS_TL T

92: from FND_LANGUAGES L
93: where L.INSTALLED_FLAG in ('I', 'B')
94: and not exists
95: (select NULL
96: from JTF_LOC_AREAS_TL T
97: where T.LOCATION_AREA_ID = X_LOCATION_AREA_ID
98: and T.LANGUAGE = L.LANGUAGE_CODE);
99:
100: open c;

Line 153: update JTF_LOC_AREAS_TL set

149: if (sql%notfound) then
150: raise no_data_found;
151: end if;
152:
153: update JTF_LOC_AREAS_TL set
154: LOCATION_AREA_NAME = X_LOCATION_AREA_NAME,
155: LOCATION_AREA_DESCRIPTION = X_LOCATION_AREA_DESCRIPTION,
156: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
157: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 263: delete from JTF_LOC_AREAS_TL

259: procedure DELETE_ROW (
260: X_LOCATION_AREA_ID in NUMBER
261: ) is
262: begin
263: delete from JTF_LOC_AREAS_TL
264: where LOCATION_AREA_ID = X_LOCATION_AREA_ID;
265:
266: if (sql%notfound) then
267: raise no_data_found;

Line 281: delete from JTF_LOC_AREAS_TL T

277:
278: procedure ADD_LANGUAGE
279: is
280: begin
281: delete from JTF_LOC_AREAS_TL T
282: where not exists
283: (select NULL
284: from JTF_LOC_AREAS_B B
285: where B.LOCATION_AREA_ID = T.LOCATION_AREA_ID

Line 288: update JTF_LOC_AREAS_TL T set (

284: from JTF_LOC_AREAS_B B
285: where B.LOCATION_AREA_ID = T.LOCATION_AREA_ID
286: );
287:
288: update JTF_LOC_AREAS_TL T set (
289: LOCATION_AREA_NAME,
290: LOCATION_AREA_DESCRIPTION
291: ) = (select
292: B.LOCATION_AREA_NAME,

Line 294: from JTF_LOC_AREAS_TL B

290: LOCATION_AREA_DESCRIPTION
291: ) = (select
292: B.LOCATION_AREA_NAME,
293: B.LOCATION_AREA_DESCRIPTION
294: from JTF_LOC_AREAS_TL B
295: where B.LOCATION_AREA_ID = T.LOCATION_AREA_ID
296: and B.LANGUAGE = T.SOURCE_LANG)
297: where (
298: T.LOCATION_AREA_ID,

Line 303: from JTF_LOC_AREAS_TL SUBB, JTF_LOC_AREAS_TL SUBT

299: T.LANGUAGE
300: ) in (select
301: SUBT.LOCATION_AREA_ID,
302: SUBT.LANGUAGE
303: from JTF_LOC_AREAS_TL SUBB, JTF_LOC_AREAS_TL SUBT
304: where SUBB.LOCATION_AREA_ID = SUBT.LOCATION_AREA_ID
305: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
306: and (SUBB.LOCATION_AREA_NAME <> SUBT.LOCATION_AREA_NAME
307: or SUBB.LOCATION_AREA_DESCRIPTION <> SUBT.LOCATION_AREA_DESCRIPTION

Line 312: insert into JTF_LOC_AREAS_TL (

308: or (SUBB.LOCATION_AREA_DESCRIPTION is null and SUBT.LOCATION_AREA_DESCRIPTION is not null)
309: or (SUBB.LOCATION_AREA_DESCRIPTION is not null and SUBT.LOCATION_AREA_DESCRIPTION is null)
310: ));
311:
312: insert into JTF_LOC_AREAS_TL (
313: LOCATION_AREA_ID,
314: LAST_UPDATE_DATE,
315: LAST_UPDATED_BY,
316: CREATION_DATE,

Line 334: from JTF_LOC_AREAS_TL B, FND_LANGUAGES L

330: B.LOCATION_AREA_NAME,
331: B.LOCATION_AREA_DESCRIPTION,
332: L.LANGUAGE_CODE,
333: B.SOURCE_LANG
334: from JTF_LOC_AREAS_TL B, FND_LANGUAGES L
335: where L.INSTALLED_FLAG in ('I', 'B')
336: and B.LANGUAGE = userenv('LANG')
337: and not exists
338: (select NULL

Line 339: from JTF_LOC_AREAS_TL T

335: where L.INSTALLED_FLAG in ('I', 'B')
336: and B.LANGUAGE = userenv('LANG')
337: and not exists
338: (select NULL
339: from JTF_LOC_AREAS_TL T
340: where T.LOCATION_AREA_ID = B.LOCATION_AREA_ID
341: and T.LANGUAGE = L.LANGUAGE_CODE);
342: end ADD_LANGUAGE;
343:

Line 351: update JTF_LOC_AREAS_TL set

347: , X_LOCATION_AREA_DESCRIPTION in VARCHAR2
348: , X_OWNER IN VARCHAR2
349: ) is
350: begin
351: update JTF_LOC_AREAS_TL set
352: location_area_name = nvl(x_location_area_name, location_area_name),
353: location_area_description = nvl(x_location_area_description, location_area_description),
354: source_lang = userenv('LANG'),
355: last_update_date = sysdate,