APPS.WMS_ELS_INDIVIDUAL_TASKS_PKG dependencies on WMS_ELS_INDIVIDUAL_TASKS_TL

Line 172: insert into WMS_ELS_INDIVIDUAL_TASKS_TL (

168: X_LAST_UPDATED_BY,
169: X_LAST_UPDATE_LOGIN
170: );
171:
172: insert into WMS_ELS_INDIVIDUAL_TASKS_TL (
173: ELS_DATA_ID,
174: DESCRIPTION,
175: LAST_UPDATED_BY,
176: LAST_UPDATE_LOGIN,

Line 196: from WMS_ELS_INDIVIDUAL_TASKS_TL T

192: from FND_LANGUAGES L
193: where L.INSTALLED_FLAG in ('I', 'B')
194: and not exists
195: (select NULL
196: from WMS_ELS_INDIVIDUAL_TASKS_TL T
197: where T.ELS_DATA_ID = X_ELS_DATA_ID
198: and T.LANGUAGE = L.LANGUAGE_CODE);
199:
200: open c;

Line 318: from WMS_ELS_INDIVIDUAL_TASKS_TL

314:
315: cursor c1 is select
316: DESCRIPTION,
317: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
318: from WMS_ELS_INDIVIDUAL_TASKS_TL
319: where ELS_DATA_ID = X_ELS_DATA_ID
320: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
321: for update of ELS_DATA_ID nowait;
322: begin

Line 554: update WMS_ELS_INDIVIDUAL_TASKS_TL set

550: if (sql%notfound) then
551: raise no_data_found;
552: end if;
553:
554: update WMS_ELS_INDIVIDUAL_TASKS_TL set
555: DESCRIPTION = X_DESCRIPTION,
556: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
557: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
558: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 575: delete from WMS_ELS_INDIVIDUAL_TASKS_TL

571: procedure DELETE_ROW (
572: X_ELS_DATA_ID in NUMBER
573: ) is
574: begin
575: delete from WMS_ELS_INDIVIDUAL_TASKS_TL
576: where ELS_DATA_ID = X_ELS_DATA_ID;
577:
578: if (sql%notfound) then
579: raise no_data_found;

Line 596: delete from WMS_ELS_INDIVIDUAL_TASKS_TL T

592:
593: procedure ADD_LANGUAGE
594: is
595: begin
596: delete from WMS_ELS_INDIVIDUAL_TASKS_TL T
597: where not exists
598: (select NULL
599: from WMS_ELS_INDIVIDUAL_TASKS_B B
600: where B.ELS_DATA_ID = T.ELS_DATA_ID

Line 603: update WMS_ELS_INDIVIDUAL_TASKS_TL T set (

599: from WMS_ELS_INDIVIDUAL_TASKS_B B
600: where B.ELS_DATA_ID = T.ELS_DATA_ID
601: );
602:
603: update WMS_ELS_INDIVIDUAL_TASKS_TL T set (
604: DESCRIPTION
605: ) = (select
606: B.DESCRIPTION
607: from WMS_ELS_INDIVIDUAL_TASKS_TL B

Line 607: from WMS_ELS_INDIVIDUAL_TASKS_TL B

603: update WMS_ELS_INDIVIDUAL_TASKS_TL T set (
604: DESCRIPTION
605: ) = (select
606: B.DESCRIPTION
607: from WMS_ELS_INDIVIDUAL_TASKS_TL B
608: where B.ELS_DATA_ID = T.ELS_DATA_ID
609: and B.LANGUAGE = T.SOURCE_LANG)
610: where (
611: T.ELS_DATA_ID,

Line 616: from WMS_ELS_INDIVIDUAL_TASKS_TL SUBB, WMS_ELS_INDIVIDUAL_TASKS_TL SUBT

612: T.LANGUAGE
613: ) in (select
614: SUBT.ELS_DATA_ID,
615: SUBT.LANGUAGE
616: from WMS_ELS_INDIVIDUAL_TASKS_TL SUBB, WMS_ELS_INDIVIDUAL_TASKS_TL SUBT
617: where SUBB.ELS_DATA_ID = SUBT.ELS_DATA_ID
618: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
619: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
620: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 624: insert into WMS_ELS_INDIVIDUAL_TASKS_TL (

620: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
621: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
622: ));
623:
624: insert into WMS_ELS_INDIVIDUAL_TASKS_TL (
625: ELS_DATA_ID,
626: DESCRIPTION,
627: LAST_UPDATED_BY,
628: LAST_UPDATE_LOGIN,

Line 644: from WMS_ELS_INDIVIDUAL_TASKS_TL B, FND_LANGUAGES L

640: B.CREATION_DATE,
641: B.LAST_UPDATE_DATE,
642: L.LANGUAGE_CODE,
643: B.SOURCE_LANG
644: from WMS_ELS_INDIVIDUAL_TASKS_TL B, FND_LANGUAGES L
645: where L.INSTALLED_FLAG in ('I', 'B')
646: and B.LANGUAGE = userenv('LANG')
647: and not exists
648: (select NULL

Line 649: from WMS_ELS_INDIVIDUAL_TASKS_TL T

645: where L.INSTALLED_FLAG in ('I', 'B')
646: and B.LANGUAGE = userenv('LANG')
647: and not exists
648: (select NULL
649: from WMS_ELS_INDIVIDUAL_TASKS_TL T
650: where T.ELS_DATA_ID = B.ELS_DATA_ID
651: and T.LANGUAGE = L.LANGUAGE_CODE);
652: end ADD_LANGUAGE;
653: