APPS.WMS_ELS_GROUPED_TASKS_PKG dependencies on WMS_ELS_GROUPED_TASKS_TL

Line 130: insert into WMS_ELS_GROUPED_TASKS_TL (

126: X_LAST_UPDATED_BY,
127: X_LAST_UPDATE_LOGIN
128: );
129:
130: insert into WMS_ELS_GROUPED_TASKS_TL (
131: ELS_GROUP_ID,
132: DESCRIPTION,
133: LAST_UPDATED_BY,
134: LAST_UPDATE_LOGIN,

Line 154: from WMS_ELS_GROUPED_TASKS_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_ELS_GROUPED_TASKS_TL T
155: where T.ELS_GROUP_ID = X_ELS_GROUP_ID
156: and T.LANGUAGE = L.LANGUAGE_CODE);
157:
158: open c;

Line 248: from WMS_ELS_GROUPED_TASKS_TL

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

Line 430: update WMS_ELS_GROUPED_TASKS_TL set

426: if (sql%notfound) then
427: raise no_data_found;
428: end if;
429:
430: update WMS_ELS_GROUPED_TASKS_TL set
431: DESCRIPTION = X_DESCRIPTION,
432: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
433: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
434: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 450: delete from WMS_ELS_GROUPED_TASKS_TL

446: procedure DELETE_ROW (
447: X_ELS_GROUP_ID in NUMBER
448: ) is
449: begin
450: delete from WMS_ELS_GROUPED_TASKS_TL
451: where ELS_GROUP_ID = X_ELS_GROUP_ID;
452:
453: if (sql%notfound) then
454: raise no_data_found;

Line 471: delete from WMS_ELS_GROUPED_TASKS_TL T

467:
468: procedure ADD_LANGUAGE
469: is
470: begin
471: delete from WMS_ELS_GROUPED_TASKS_TL T
472: where not exists
473: (select NULL
474: from WMS_ELS_GROUPED_TASKS_B B
475: where B.ELS_GROUP_ID = T.ELS_GROUP_ID

Line 478: update WMS_ELS_GROUPED_TASKS_TL T set (

474: from WMS_ELS_GROUPED_TASKS_B B
475: where B.ELS_GROUP_ID = T.ELS_GROUP_ID
476: );
477:
478: update WMS_ELS_GROUPED_TASKS_TL T set (
479: DESCRIPTION
480: ) = (select
481: B.DESCRIPTION
482: from WMS_ELS_GROUPED_TASKS_TL B

Line 482: from WMS_ELS_GROUPED_TASKS_TL B

478: update WMS_ELS_GROUPED_TASKS_TL T set (
479: DESCRIPTION
480: ) = (select
481: B.DESCRIPTION
482: from WMS_ELS_GROUPED_TASKS_TL B
483: where B.ELS_GROUP_ID = T.ELS_GROUP_ID
484: and B.LANGUAGE = T.SOURCE_LANG)
485: where (
486: T.ELS_GROUP_ID,

Line 491: from WMS_ELS_GROUPED_TASKS_TL SUBB, WMS_ELS_GROUPED_TASKS_TL SUBT

487: T.LANGUAGE
488: ) in (select
489: SUBT.ELS_GROUP_ID,
490: SUBT.LANGUAGE
491: from WMS_ELS_GROUPED_TASKS_TL SUBB, WMS_ELS_GROUPED_TASKS_TL SUBT
492: where SUBB.ELS_GROUP_ID = SUBT.ELS_GROUP_ID
493: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
494: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
495: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 499: insert into WMS_ELS_GROUPED_TASKS_TL (

495: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
496: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
497: ));
498:
499: insert into WMS_ELS_GROUPED_TASKS_TL (
500: ELS_GROUP_ID,
501: DESCRIPTION,
502: LAST_UPDATED_BY,
503: LAST_UPDATE_LOGIN,

Line 519: from WMS_ELS_GROUPED_TASKS_TL B, FND_LANGUAGES L

515: B.CREATION_DATE,
516: B.LAST_UPDATE_DATE,
517: L.LANGUAGE_CODE,
518: B.SOURCE_LANG
519: from WMS_ELS_GROUPED_TASKS_TL B, FND_LANGUAGES L
520: where L.INSTALLED_FLAG in ('I', 'B')
521: and B.LANGUAGE = userenv('LANG')
522: and not exists
523: (select NULL

Line 524: from WMS_ELS_GROUPED_TASKS_TL T

520: where L.INSTALLED_FLAG in ('I', 'B')
521: and B.LANGUAGE = userenv('LANG')
522: and not exists
523: (select NULL
524: from WMS_ELS_GROUPED_TASKS_TL T
525: where T.ELS_GROUP_ID = B.ELS_GROUP_ID
526: and T.LANGUAGE = L.LANGUAGE_CODE);
527: end ADD_LANGUAGE;
528: