APPS.WMS_ZONES_PKG dependencies on WMS_ZONES_TL

Line 94: insert into WMS_ZONES_TL (

90: X_LAST_UPDATED_BY,
91: X_LAST_UPDATE_LOGIN
92: );
93:
94: insert into WMS_ZONES_TL (
95: ZONE_ID,
96: ZONE_NAME,
97: DESCRIPTION,
98: LAST_UPDATE_DATE,

Line 120: from WMS_ZONES_TL T

116: from FND_LANGUAGES L
117: where L.INSTALLED_FLAG in ('I', 'B')
118: and not exists
119: (select NULL
120: from WMS_ZONES_TL T
121: where T.ZONE_ID = X_ZONE_ID
122: and T.LANGUAGE = L.LANGUAGE_CODE);
123:
124: open c;

Line 187: from WMS_ZONES_TL

183: cursor c1 is select
184: ZONE_NAME,
185: DESCRIPTION,
186: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
187: from WMS_ZONES_TL
188: where ZONE_ID = X_ZONE_ID
189: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
190: for update of ZONE_ID nowait;
191: begin

Line 319: update WMS_ZONES_TL set

315: if (sql%notfound) then
316: raise no_data_found;
317: end if;
318:
319: update WMS_ZONES_TL set
320: ZONE_NAME = X_ZONE_NAME,
321: DESCRIPTION = X_DESCRIPTION,
322: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
323: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 338: delete from WMS_ZONES_TL

334: procedure DELETE_ROW (
335: X_ZONE_ID in NUMBER
336: ) is
337: begin
338: delete from WMS_ZONES_TL
339: where ZONE_ID = X_ZONE_ID;
340:
341: if (sql%notfound) then
342: raise no_data_found;

Line 356: delete from WMS_ZONES_TL T

352:
353: procedure ADD_LANGUAGE
354: is
355: begin
356: delete from WMS_ZONES_TL T
357: where not exists
358: (select NULL
359: from WMS_ZONES_B B
360: where B.ZONE_ID = T.ZONE_ID

Line 363: update WMS_ZONES_TL T set (

359: from WMS_ZONES_B B
360: where B.ZONE_ID = T.ZONE_ID
361: );
362:
363: update WMS_ZONES_TL T set (
364: ZONE_NAME,
365: DESCRIPTION
366: ) = (select
367: B.ZONE_NAME,

Line 369: from WMS_ZONES_TL B

365: DESCRIPTION
366: ) = (select
367: B.ZONE_NAME,
368: B.DESCRIPTION
369: from WMS_ZONES_TL B
370: where B.ZONE_ID = T.ZONE_ID
371: and B.LANGUAGE = T.SOURCE_LANG)
372: where (
373: T.ZONE_ID,

Line 378: from WMS_ZONES_TL SUBB, WMS_ZONES_TL SUBT

374: T.LANGUAGE
375: ) in (select
376: SUBT.ZONE_ID,
377: SUBT.LANGUAGE
378: from WMS_ZONES_TL SUBB, WMS_ZONES_TL SUBT
379: where SUBB.ZONE_ID = SUBT.ZONE_ID
380: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
381: and (SUBB.ZONE_NAME <> SUBT.ZONE_NAME
382: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 387: insert into WMS_ZONES_TL (

383: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
384: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
385: ));
386:
387: insert into WMS_ZONES_TL (
388: ZONE_ID,
389: ZONE_NAME,
390: DESCRIPTION,
391: LAST_UPDATE_DATE,

Line 409: from WMS_ZONES_TL B, FND_LANGUAGES L

405: B.CREATED_BY,
406: B.LAST_UPDATE_LOGIN,
407: L.LANGUAGE_CODE,
408: B.SOURCE_LANG
409: from WMS_ZONES_TL B, FND_LANGUAGES L
410: where L.INSTALLED_FLAG in ('I', 'B')
411: and B.LANGUAGE = userenv('LANG')
412: and not exists
413: (select NULL

Line 414: from WMS_ZONES_TL T

410: where L.INSTALLED_FLAG in ('I', 'B')
411: and B.LANGUAGE = userenv('LANG')
412: and not exists
413: (select NULL
414: from WMS_ZONES_TL T
415: where T.ZONE_ID = B.ZONE_ID
416: and T.LANGUAGE = L.LANGUAGE_CODE);
417: end ADD_LANGUAGE;
418: