APPS.WMS_TASK_FILTER_PKG dependencies on WMS_TASK_FILTER_TL

Line 86: insert into WMS_TASK_FILTER_TL (

82: X_LAST_UPDATED_BY,
83: X_LAST_UPDATE_LOGIN
84: );
85:
86: insert into WMS_TASK_FILTER_TL (
87: TASK_FILTER_ID,
88: USER_TASK_FILTER_NAME,
89: LAST_UPDATE_DATE,
90: LAST_UPDATED_BY,

Line 112: from WMS_TASK_FILTER_TL T

108: from FND_LANGUAGES L
109: where L.INSTALLED_FLAG in ('I', 'B')
110: and not exists
111: (select NULL
112: from WMS_TASK_FILTER_TL T
113: where T.TASK_FILTER_ID = X_TASK_FILTER_ID
114: and T.LANGUAGE = L.LANGUAGE_CODE);
115:
116: open c;

Line 175: from WMS_TASK_FILTER_TL

171: cursor c1 is select
172: USER_TASK_FILTER_NAME,
173: TASK_FILTER_DESCRIPTION,
174: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
175: from WMS_TASK_FILTER_TL
176: where TASK_FILTER_ID = X_TASK_FILTER_ID
177: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
178: for update of TASK_FILTER_ID nowait;
179: begin

Line 297: update WMS_TASK_FILTER_TL set

293: if (sql%notfound) then
294: raise no_data_found;
295: end if;
296:
297: update WMS_TASK_FILTER_TL set
298: USER_TASK_FILTER_NAME = X_USER_TASK_FILTER_NAME,
299: TASK_FILTER_DESCRIPTION = X_TASK_FILTER_DESCRIPTION,
300: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
301: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 316: delete from WMS_TASK_FILTER_TL

312: procedure DELETE_ROW (
313: X_TASK_FILTER_ID in NUMBER
314: ) is
315: begin
316: delete from WMS_TASK_FILTER_TL
317: where TASK_FILTER_ID = X_TASK_FILTER_ID;
318:
319: if (sql%notfound) then
320: raise no_data_found;

Line 334: delete from WMS_TASK_FILTER_TL T

330:
331: procedure ADD_LANGUAGE
332: is
333: begin
334: delete from WMS_TASK_FILTER_TL T
335: where not exists
336: (select NULL
337: from WMS_TASK_FILTER_B B
338: where B.TASK_FILTER_ID = T.TASK_FILTER_ID

Line 341: update WMS_TASK_FILTER_TL T set (

337: from WMS_TASK_FILTER_B B
338: where B.TASK_FILTER_ID = T.TASK_FILTER_ID
339: );
340:
341: update WMS_TASK_FILTER_TL T set (
342: USER_TASK_FILTER_NAME,
343: TASK_FILTER_DESCRIPTION
344: ) = (select
345: B.USER_TASK_FILTER_NAME,

Line 347: from WMS_TASK_FILTER_TL B

343: TASK_FILTER_DESCRIPTION
344: ) = (select
345: B.USER_TASK_FILTER_NAME,
346: B.TASK_FILTER_DESCRIPTION
347: from WMS_TASK_FILTER_TL B
348: where B.TASK_FILTER_ID = T.TASK_FILTER_ID
349: and B.LANGUAGE = T.SOURCE_LANG)
350: where (
351: T.TASK_FILTER_ID,

Line 356: from WMS_TASK_FILTER_TL SUBB, WMS_TASK_FILTER_TL SUBT

352: T.LANGUAGE
353: ) in (select
354: SUBT.TASK_FILTER_ID,
355: SUBT.LANGUAGE
356: from WMS_TASK_FILTER_TL SUBB, WMS_TASK_FILTER_TL SUBT
357: where SUBB.TASK_FILTER_ID = SUBT.TASK_FILTER_ID
358: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
359: and (SUBB.USER_TASK_FILTER_NAME <> SUBT.USER_TASK_FILTER_NAME
360: or SUBB.TASK_FILTER_DESCRIPTION <> SUBT.TASK_FILTER_DESCRIPTION

Line 365: insert into WMS_TASK_FILTER_TL (

361: or (SUBB.TASK_FILTER_DESCRIPTION is null and SUBT.TASK_FILTER_DESCRIPTION is not null)
362: or (SUBB.TASK_FILTER_DESCRIPTION is not null and SUBT.TASK_FILTER_DESCRIPTION is null)
363: ));
364:
365: insert into WMS_TASK_FILTER_TL (
366: TASK_FILTER_ID,
367: USER_TASK_FILTER_NAME,
368: LAST_UPDATE_DATE,
369: LAST_UPDATED_BY,

Line 387: from WMS_TASK_FILTER_TL B, FND_LANGUAGES L

383: B.LAST_UPDATE_LOGIN,
384: B.TASK_FILTER_DESCRIPTION,
385: L.LANGUAGE_CODE,
386: B.SOURCE_LANG
387: from WMS_TASK_FILTER_TL B, FND_LANGUAGES L
388: where L.INSTALLED_FLAG in ('I', 'B')
389: and B.LANGUAGE = userenv('LANG')
390: and not exists
391: (select NULL

Line 392: from WMS_TASK_FILTER_TL T

388: where L.INSTALLED_FLAG in ('I', 'B')
389: and B.LANGUAGE = userenv('LANG')
390: and not exists
391: (select NULL
392: from WMS_TASK_FILTER_TL T
393: where T.TASK_FILTER_ID = B.TASK_FILTER_ID
394: and T.LANGUAGE = L.LANGUAGE_CODE);
395: end ADD_LANGUAGE;
396:

Line 423: L_TASK_FILTER_DESCRIPTION WMS_TASK_FILTER_TL.TASK_FILTER_DESCRIPTION%TYPE;

419: X_LAST_UPDATE_DATE in VARCHAR2,
420: x_custom_mode in varchar2) is
421:
422: l_TASK_FILTER_ID number;
423: L_TASK_FILTER_DESCRIPTION WMS_TASK_FILTER_TL.TASK_FILTER_DESCRIPTION%TYPE;
424: row_id varchar2(64);
425: f_luby number; -- entity owner in file
426: f_ludate date; -- entity update date in file
427: db_luby number; -- entity owner in db

Line 560: update WMS_TASK_FILTER_TL set

556: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
557: db_ludate, x_custom_mode)) then
558:
559: -- Update translations for this language
560: update WMS_TASK_FILTER_TL set
561: USER_TASK_FILTER_NAME = X_USER_TASK_FILTER_NAME,
562: TASK_FILTER_DESCRIPTION = nvl(X_TASK_FILTER_DESCRIPTION, TASK_FILTER_DESCRIPTION),
563: LAST_UPDATE_DATE = f_ludate,
564: LAST_UPDATED_BY = f_luby,