APPS.WMS_ZONES_PKG dependencies on WMS_ZONES_TL

Line 97: insert into WMS_ZONES_TL (

93: X_LAST_UPDATED_BY,
94: X_LAST_UPDATE_LOGIN
95: );
96:
97: insert into WMS_ZONES_TL (
98: ZONE_ID,
99: ZONE_NAME,
100: DESCRIPTION,
101: LAST_UPDATE_DATE,

Line 123: from WMS_ZONES_TL T

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

Line 194: from WMS_ZONES_TL

190: cursor c1 is select
191: ZONE_NAME,
192: DESCRIPTION,
193: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
194: from WMS_ZONES_TL
195: where ZONE_ID = X_ZONE_ID
196: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
197: for update of ZONE_ID nowait;
198: begin

Line 332: update WMS_ZONES_TL set

328: if (sql%notfound) then
329: raise no_data_found;
330: end if;
331:
332: update WMS_ZONES_TL set
333: ZONE_NAME = X_ZONE_NAME,
334: DESCRIPTION = X_DESCRIPTION,
335: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
336: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 351: delete from WMS_ZONES_TL

347: procedure DELETE_ROW (
348: X_ZONE_ID in NUMBER
349: ) is
350: begin
351: delete from WMS_ZONES_TL
352: where ZONE_ID = X_ZONE_ID;
353:
354: if (sql%notfound) then
355: raise no_data_found;

Line 369: delete from WMS_ZONES_TL T

365:
366: procedure ADD_LANGUAGE
367: is
368: begin
369: delete from WMS_ZONES_TL T
370: where not exists
371: (select NULL
372: from WMS_ZONES_B B
373: where B.ZONE_ID = T.ZONE_ID

Line 376: update WMS_ZONES_TL T set (

372: from WMS_ZONES_B B
373: where B.ZONE_ID = T.ZONE_ID
374: );
375:
376: update WMS_ZONES_TL T set (
377: ZONE_NAME,
378: DESCRIPTION
379: ) = (select
380: B.ZONE_NAME,

Line 382: from WMS_ZONES_TL B

378: DESCRIPTION
379: ) = (select
380: B.ZONE_NAME,
381: B.DESCRIPTION
382: from WMS_ZONES_TL B
383: where B.ZONE_ID = T.ZONE_ID
384: and B.LANGUAGE = T.SOURCE_LANG)
385: where (
386: T.ZONE_ID,

Line 391: from WMS_ZONES_TL SUBB, WMS_ZONES_TL SUBT

387: T.LANGUAGE
388: ) in (select
389: SUBT.ZONE_ID,
390: SUBT.LANGUAGE
391: from WMS_ZONES_TL SUBB, WMS_ZONES_TL SUBT
392: where SUBB.ZONE_ID = SUBT.ZONE_ID
393: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
394: and (SUBB.ZONE_NAME <> SUBT.ZONE_NAME
395: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 400: insert into WMS_ZONES_TL (

396: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
397: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
398: ));
399:
400: insert into WMS_ZONES_TL (
401: ZONE_ID,
402: ZONE_NAME,
403: DESCRIPTION,
404: LAST_UPDATE_DATE,

Line 422: from WMS_ZONES_TL B, FND_LANGUAGES L

418: B.CREATED_BY,
419: B.LAST_UPDATE_LOGIN,
420: L.LANGUAGE_CODE,
421: B.SOURCE_LANG
422: from WMS_ZONES_TL B, FND_LANGUAGES L
423: where L.INSTALLED_FLAG in ('I', 'B')
424: and B.LANGUAGE = userenv('LANG')
425: and not exists
426: (select NULL

Line 427: from WMS_ZONES_TL T

423: where L.INSTALLED_FLAG in ('I', 'B')
424: and B.LANGUAGE = userenv('LANG')
425: and not exists
426: (select NULL
427: from WMS_ZONES_TL T
428: where T.ZONE_ID = B.ZONE_ID
429: and T.LANGUAGE = L.LANGUAGE_CODE);
430: end ADD_LANGUAGE;
431: