APPS.WMS_DEVICES_PKG dependencies on WMS_DEVICES_TL

Line 128: insert into WMS_DEVICES_TL(

124: x_locator_id,
125: x_multi_sign_on,
126: x_message_template_id);
127:
128: insert into WMS_DEVICES_TL(
129: DEVICE_ID,
130: NAME,
131: DESCRIPTION,
132: CREATION_DATE,

Line 154: from WMS_DEVICES_TL T

150: from FND_LANGUAGES L
151: where L.INSTALLED_FLAG in ('I', 'B')
152: and not exists
153: (select NULL
154: from WMS_DEVICES_TL T
155: where T.DEVICE_ID = X_DEVICE_ID
156: and T.LANGUAGE = L.LANGUAGE_CODE);
157:
158: open c;

Line 247: from WMS_DEVICES_TL

243: cursor c1 is select
244: NAME,
245: DESCRIPTION,
246: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
247: from WMS_DEVICES_TL
248: where DEVICE_ID = X_DEVICE_ID
249: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
250: for update of DEVICE_ID nowait;
251: begin

Line 428: update WMS_DEVICES_TL set

424: if (sql%notfound) then
425: raise no_data_found;
426: end if;
427:
428: update WMS_DEVICES_TL set
429: NAME = X_NAME,
430: DESCRIPTION = X_DESCRIPTION,
431: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
432: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 447: delete from WMS_DEVICES_TL

443: procedure DELETE_ROW (
444: X_DEVICE_ID in NUMBER
445: ) is
446: begin
447: delete from WMS_DEVICES_TL
448: where DEVICE_ID = X_DEVICE_ID;
449:
450: if (sql%notfound) then
451: raise no_data_found;

Line 465: delete from WMS_DEVICES_TL T

461:
462: procedure ADD_LANGUAGE
463: is
464: begin
465: delete from WMS_DEVICES_TL T
466: where not exists
467: (select NULL
468: from WMS_DEVICES_B B
469: where B.DEVICE_ID = T.DEVICE_ID

Line 472: update WMS_DEVICES_TL T set (

468: from WMS_DEVICES_B B
469: where B.DEVICE_ID = T.DEVICE_ID
470: );
471:
472: update WMS_DEVICES_TL T set (
473: NAME,
474: DESCRIPTION
475: ) = (select
476: B.NAME,

Line 478: from WMS_DEVICES_TL B

474: DESCRIPTION
475: ) = (select
476: B.NAME,
477: B.DESCRIPTION
478: from WMS_DEVICES_TL B
479: where B.DEVICE_ID = T.DEVICE_ID
480: and B.LANGUAGE = T.SOURCE_LANG)
481: where (
482: T.DEVICE_ID,

Line 487: from WMS_DEVICES_TL SUBB, WMS_DEVICES_TL SUBT

483: T.LANGUAGE
484: ) in (select
485: SUBT.DEVICE_ID,
486: SUBT.LANGUAGE
487: from WMS_DEVICES_TL SUBB, WMS_DEVICES_TL SUBT
488: where SUBB.DEVICE_ID = SUBT.DEVICE_ID
489: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
490: and (SUBB.NAME <> SUBT.NAME
491: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 494: insert into WMS_DEVICES_TL (

490: and (SUBB.NAME <> SUBT.NAME
491: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
492: ));
493:
494: insert into WMS_DEVICES_TL (
495: DEVICE_ID,
496: NAME,
497: DESCRIPTION,
498: CREATION_DATE,

Line 516: from WMS_DEVICES_TL B, FND_LANGUAGES L

512: B.LAST_UPDATED_BY,
513: B.LAST_UPDATE_LOGIN,
514: L.LANGUAGE_CODE,
515: B.SOURCE_LANG
516: from WMS_DEVICES_TL B, FND_LANGUAGES L
517: where L.INSTALLED_FLAG in ('I', 'B')
518: and B.LANGUAGE = userenv('LANG')
519: and not exists
520: (select NULL

Line 521: from WMS_DEVICES_TL T

517: where L.INSTALLED_FLAG in ('I', 'B')
518: and B.LANGUAGE = userenv('LANG')
519: and not exists
520: (select NULL
521: from WMS_DEVICES_TL T
522: where T.DEVICE_ID = B.DEVICE_ID
523: and T.LANGUAGE = L.LANGUAGE_CODE);
524: end ADD_LANGUAGE;
525: