APPS.WF_WL_VIEWS_PKG dependencies on WF_WL_VIEW_ATTRIBUTES_TL

Line 284: insert into WF_WL_VIEW_ATTRIBUTES_TL (VIEW_ID,

280: end UPDATE_VIEW_BY_KEY;
281:
282: procedure ADD_VIEW_ATTR_LANGUAGE is
283: begin
284: insert into WF_WL_VIEW_ATTRIBUTES_TL (VIEW_ID,
285: ATTRIBUTE_NAME,
286: PROMPT,
287: DESCRIPTION,
288: LANGUAGE,

Line 306: from WF_WL_VIEW_ATTRIBUTES_TL B, FND_LANGUAGES L

302: B.CREATED_BY,
303: B.LAST_UPDATE_DATE,
304: B.LAST_UPDATED_BY,
305: B.LAST_UPDATE_LOGIN
306: from WF_WL_VIEW_ATTRIBUTES_TL B, FND_LANGUAGES L
307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL

Line 311: from WF_WL_VIEW_ATTRIBUTES_TL TL

307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL
311: from WF_WL_VIEW_ATTRIBUTES_TL TL
312: where TL.VIEW_ID = B.VIEW_ID and
313: TL.ATTRIBUTE_NAME = B.ATTRIBUTE_NAME and
314: TL.LANGUAGE = L.LANGUAGE_CODE);
315: exception

Line 439: insert into WF_WL_VIEW_ATTRIBUTES_TL (VIEW_ID,

435: l_ludate,
436: l_luby,
437: 0, --LAST_UPDATE_LOGIN,
438: FND_GLOBAL.SECURITY_GROUP_ID);
439: insert into WF_WL_VIEW_ATTRIBUTES_TL (VIEW_ID,
440: ATTRIBUTE_NAME,
441: PROMPT,
442: DESCRIPTION,
443: LANGUAGE,

Line 465: from WF_WL_VIEW_ATTRIBUTES_TL TL

461: from FND_LANGUAGES L
462: where L.INSTALLED_FLAG in ('I', 'B')
463: and not exists
464: (select NULL
465: from WF_WL_VIEW_ATTRIBUTES_TL TL
466: where TL.VIEW_ID = l_view_id and
467: TL.ATTRIBUTE_NAME = X_ATTRIBUTE_NAME and
468: TL.LANGUAGE = L.LANGUAGE_CODE);
469:

Line 547: UPDATE WF_WL_VIEW_ATTRIBUTES_TL TL

543: l_luby := fnd_load_util.OWNER_ID(x_owner);
544: -- Translate char last_update_date to date
545: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
546:
547: UPDATE WF_WL_VIEW_ATTRIBUTES_TL TL
548: SET TL.PROMPT = X_PROMPT,
549: TL.DESCRIPTION = X_DESCRIPTION,
550: TL.SOURCE_LANG = userenv('LANG'),
551: TL.LAST_UPDATE_DATE = l_ludate,