APPS.WMS_PAGE_FIELDS_PKG dependencies on WMS_PAGE_FIELDS_TL

Line 68: insert into WMS_PAGE_FIELDS_TL (

64: X_LAST_UPDATED_BY,
65: X_LAST_UPDATE_LOGIN
66: );
67:
68: insert into WMS_PAGE_FIELDS_TL (
69: PAGE_ID,
70: FIELD_ID,
71: FIELD_USER_NAME,
72: LAST_UPDATE_DATE,

Line 94: from WMS_PAGE_FIELDS_TL T

90: from FND_LANGUAGES L
91: where L.INSTALLED_FLAG in ('I', 'B')
92: and not exists
93: (select NULL
94: from WMS_PAGE_FIELDS_TL T
95: where T.PAGE_ID = X_PAGE_ID
96: and T.FIELD_ID = X_FIELD_ID
97: and T.LANGUAGE = L.LANGUAGE_CODE);
98:

Line 144: from WMS_PAGE_FIELDS_TL

140:
141: cursor c1 is select
142: FIELD_USER_NAME,
143: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
144: from WMS_PAGE_FIELDS_TL
145: where PAGE_ID = X_PAGE_ID
146: and FIELD_ID = X_FIELD_ID
147: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
148: for update of PAGE_ID nowait;

Line 239: update WMS_PAGE_FIELDS_TL set

235: if (sql%notfound) then
236: raise no_data_found;
237: end if;
238:
239: update WMS_PAGE_FIELDS_TL set
240: FIELD_USER_NAME = X_FIELD_USER_NAME,
241: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
242: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
243: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 262: update WMS_PAGE_FIELDS_TL tl set

258: X_LAST_UPDATE_DATE in DATE,
259: X_FIELD_USER_NAME in VARCHAR2) is
260: begin
261:
262: update WMS_PAGE_FIELDS_TL tl set
263: FIELD_USER_NAME = nvl(X_FIELD_USER_NAME,
264: FIELD_USER_NAME),
265: SOURCE_LANG = userenv('LANG'),
266: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 354: delete from WMS_PAGE_FIELDS_TL

350: X_PAGE_ID in NUMBER,
351: X_FIELD_ID in NUMBER
352: ) is
353: begin
354: delete from WMS_PAGE_FIELDS_TL
355: where PAGE_ID = X_PAGE_ID
356: and FIELD_ID = X_FIELD_ID;
357:
358: if (sql%notfound) then

Line 374: delete from WMS_PAGE_FIELDS_TL T

370:
371: procedure ADD_LANGUAGE
372: is
373: begin
374: delete from WMS_PAGE_FIELDS_TL T
375: where not exists
376: (select NULL
377: from WMS_PAGE_FIELDS_B B
378: where B.PAGE_ID = T.PAGE_ID

Line 382: update WMS_PAGE_FIELDS_TL T set (

378: where B.PAGE_ID = T.PAGE_ID
379: and B.FIELD_ID = T.FIELD_ID
380: );
381:
382: update WMS_PAGE_FIELDS_TL T set (
383: FIELD_USER_NAME
384: ) = (select
385: B.FIELD_USER_NAME
386: from WMS_PAGE_FIELDS_TL B

Line 386: from WMS_PAGE_FIELDS_TL B

382: update WMS_PAGE_FIELDS_TL T set (
383: FIELD_USER_NAME
384: ) = (select
385: B.FIELD_USER_NAME
386: from WMS_PAGE_FIELDS_TL B
387: where B.PAGE_ID = T.PAGE_ID
388: and B.FIELD_ID = T.FIELD_ID
389: and B.LANGUAGE = T.SOURCE_LANG)
390: where (

Line 398: from WMS_PAGE_FIELDS_TL SUBB, WMS_PAGE_FIELDS_TL SUBT

394: ) in (select
395: SUBT.PAGE_ID,
396: SUBT.FIELD_ID,
397: SUBT.LANGUAGE
398: from WMS_PAGE_FIELDS_TL SUBB, WMS_PAGE_FIELDS_TL SUBT
399: where SUBB.PAGE_ID = SUBT.PAGE_ID
400: and SUBB.FIELD_ID = SUBT.FIELD_ID
401: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
402: and (SUBB.FIELD_USER_NAME <> SUBT.FIELD_USER_NAME

Line 407: insert into WMS_PAGE_FIELDS_TL (

403: or (SUBB.FIELD_USER_NAME is null and SUBT.FIELD_USER_NAME is not null)
404: or (SUBB.FIELD_USER_NAME is not null and SUBT.FIELD_USER_NAME is null)
405: ));
406:
407: insert into WMS_PAGE_FIELDS_TL (
408: PAGE_ID,
409: FIELD_ID,
410: FIELD_USER_NAME,
411: LAST_UPDATE_DATE,

Line 429: from WMS_PAGE_FIELDS_TL B, FND_LANGUAGES L

425: B.CREATED_BY,
426: B.LAST_UPDATE_LOGIN,
427: L.LANGUAGE_CODE,
428: B.SOURCE_LANG
429: from WMS_PAGE_FIELDS_TL B, FND_LANGUAGES L
430: where L.INSTALLED_FLAG in ('I', 'B')
431: and B.LANGUAGE = userenv('LANG')
432: and not exists
433: (select NULL

Line 434: from WMS_PAGE_FIELDS_TL T

430: where L.INSTALLED_FLAG in ('I', 'B')
431: and B.LANGUAGE = userenv('LANG')
432: and not exists
433: (select NULL
434: from WMS_PAGE_FIELDS_TL T
435: where T.PAGE_ID = B.PAGE_ID
436: and T.FIELD_ID = B.FIELD_ID
437: and T.LANGUAGE = L.LANGUAGE_CODE);
438: end ADD_LANGUAGE;