APPS.WMS_TASK_RELEASE_PKG dependencies on WMS_TASK_RELEASE_TL

Line 114: insert into WMS_TASK_RELEASE_TL (

110: X_LAST_UPDATED_BY,
111: X_LAST_UPDATE_LOGIN
112: );
113:
114: insert into WMS_TASK_RELEASE_TL (
115: CRITERIA_ID,
116: LAST_UPDATED_BY,
117: LAST_UPDATE_DATE,
118: CREATED_BY,

Line 140: from WMS_TASK_RELEASE_TL T

136: from FND_LANGUAGES L
137: where L.INSTALLED_FLAG in ('I', 'B')
138: and not exists
139: (select NULL
140: from WMS_TASK_RELEASE_TL T
141: where T.CRITERIA_ID = X_CRITERIA_ID
142: and T.LANGUAGE = L.LANGUAGE_CODE);
143:
144: open c;

Line 222: from WMS_TASK_RELEASE_TL

218: cursor c1 is select
219: CRITERIA_NAME,
220: CRITERIA_DESCRIPTION,
221: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
222: from WMS_TASK_RELEASE_TL
223: where CRITERIA_ID = X_CRITERIA_ID
224: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
225: for update of CRITERIA_ID nowait;
226: begin

Line 380: update WMS_TASK_RELEASE_TL set

376: if (sql%notfound) then
377: raise no_data_found;
378: end if;
379:
380: update WMS_TASK_RELEASE_TL set
381: CRITERIA_NAME = X_CRITERIA_NAME,
382: CRITERIA_DESCRIPTION = X_CRITERIA_DESCRIPTION,
383: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
384: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 399: delete from WMS_TASK_RELEASE_TL

395: procedure DELETE_ROW (
396: X_CRITERIA_ID in NUMBER
397: ) is
398: begin
399: delete from WMS_TASK_RELEASE_TL
400: where CRITERIA_ID = X_CRITERIA_ID;
401:
402: if (sql%notfound) then
403: raise no_data_found;

Line 417: delete from WMS_TASK_RELEASE_TL T

413:
414: procedure ADD_LANGUAGE
415: is
416: begin
417: delete from WMS_TASK_RELEASE_TL T
418: where not exists
419: (select NULL
420: from WMS_TASK_RELEASE_B B
421: where B.CRITERIA_ID = T.CRITERIA_ID

Line 424: update WMS_TASK_RELEASE_TL T set (

420: from WMS_TASK_RELEASE_B B
421: where B.CRITERIA_ID = T.CRITERIA_ID
422: );
423:
424: update WMS_TASK_RELEASE_TL T set (
425: CRITERIA_NAME,
426: CRITERIA_DESCRIPTION
427: ) = (select
428: B.CRITERIA_NAME,

Line 430: from WMS_TASK_RELEASE_TL B

426: CRITERIA_DESCRIPTION
427: ) = (select
428: B.CRITERIA_NAME,
429: B.CRITERIA_DESCRIPTION
430: from WMS_TASK_RELEASE_TL B
431: where B.CRITERIA_ID = T.CRITERIA_ID
432: and B.LANGUAGE = T.SOURCE_LANG)
433: where (
434: T.CRITERIA_ID,

Line 439: from WMS_TASK_RELEASE_TL SUBB, WMS_TASK_RELEASE_TL SUBT

435: T.LANGUAGE
436: ) in (select
437: SUBT.CRITERIA_ID,
438: SUBT.LANGUAGE
439: from WMS_TASK_RELEASE_TL SUBB, WMS_TASK_RELEASE_TL SUBT
440: where SUBB.CRITERIA_ID = SUBT.CRITERIA_ID
441: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
442: and (SUBB.CRITERIA_NAME <> SUBT.CRITERIA_NAME
443: or SUBB.CRITERIA_DESCRIPTION <> SUBT.CRITERIA_DESCRIPTION

Line 448: insert into WMS_TASK_RELEASE_TL (

444: or (SUBB.CRITERIA_DESCRIPTION is null and SUBT.CRITERIA_DESCRIPTION is not null)
445: or (SUBB.CRITERIA_DESCRIPTION is not null and SUBT.CRITERIA_DESCRIPTION is null)
446: ));
447:
448: insert into WMS_TASK_RELEASE_TL (
449: CRITERIA_ID,
450: LAST_UPDATED_BY,
451: LAST_UPDATE_DATE,
452: CREATED_BY,

Line 470: from WMS_TASK_RELEASE_TL B, FND_LANGUAGES L

466: B.CRITERIA_NAME,
467: B.CRITERIA_DESCRIPTION,
468: L.LANGUAGE_CODE,
469: B.SOURCE_LANG
470: from WMS_TASK_RELEASE_TL B, FND_LANGUAGES L
471: where L.INSTALLED_FLAG in ('I', 'B')
472: and B.LANGUAGE = userenv('LANG')
473: and not exists
474: (select NULL

Line 475: from WMS_TASK_RELEASE_TL T

471: where L.INSTALLED_FLAG in ('I', 'B')
472: and B.LANGUAGE = userenv('LANG')
473: and not exists
474: (select NULL
475: from WMS_TASK_RELEASE_TL T
476: where T.CRITERIA_ID = B.CRITERIA_ID
477: and T.LANGUAGE = L.LANGUAGE_CODE);
478: end ADD_LANGUAGE;
479: