APPS.WF_WL_VIEWS_PKG dependencies on WF_WL_VIEWS_TL

Line 143: insert into WF_WL_VIEWS_TL (VIEW_ID, TITLE,

139: l_ludate, -- X_LAST_UPDATE_DATE,
140: l_luby, -- X_LAST_UPDATED_BY,
141: 0, -- X_LAST_UPDATE_LOGIN,
142: FND_GLOBAL.SECURITY_GROUP_ID);
143: insert into WF_WL_VIEWS_TL (VIEW_ID, TITLE,
144: DESCRIPTION,
145: LANGUAGE,
146: SOURCE_LANG,
147: CREATION_DATE,

Line 167: from WF_WL_VIEWS_TL TL, WF_WL_VIEWS B

163: from FND_LANGUAGES L
164: where L.INSTALLED_FLAG in ('I', 'B')
165: and not exists
166: (select NULL
167: from WF_WL_VIEWS_TL TL, WF_WL_VIEWS B
168: where B.VIEW_ID = TL.VIEW_ID and
169: B.VIEW_KEY = X_VIEW_KEY and
170: TL.LANGUAGE = L.LANGUAGE_CODE);
171:

Line 321: l_view_id WF_WL_VIEWS_TL.VIEW_ID%TYPE;

317: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.ADD_VIEW_ATTR_LANGUAGE unable to add '||userenv('LANG')||' translation due to error '||sqlcode);
318: end ADD_VIEW_ATTR_LANGUAGE;
319:
320: procedure ADD_LANGUAGE is
321: l_view_id WF_WL_VIEWS_TL.VIEW_ID%TYPE;
322: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
323: begin
324: begin
325: insert into WF_WL_VIEWS_TL (VIEW_ID,

Line 325: insert into WF_WL_VIEWS_TL (VIEW_ID,

321: l_view_id WF_WL_VIEWS_TL.VIEW_ID%TYPE;
322: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
323: begin
324: begin
325: insert into WF_WL_VIEWS_TL (VIEW_ID,
326: TITLE,
327: DESCRIPTION,
328: LANGUAGE,
329: SOURCE_LANG,

Line 347: from WF_WL_VIEWS_TL B, FND_LANGUAGES L

343: B.LAST_UPDATE_DATE,
344: B.LAST_UPDATED_BY,
345: B.LAST_UPDATE_LOGIN,
346: B.SECURITY_GROUP_ID
347: from WF_WL_VIEWS_TL B, FND_LANGUAGES L
348: where L.INSTALLED_FLAG in ('I', 'B')
349: and B.LANGUAGE = userenv('LANG')
350: and not exists
351: (select NULL

Line 352: from WF_WL_VIEWS_TL T

348: where L.INSTALLED_FLAG in ('I', 'B')
349: and B.LANGUAGE = userenv('LANG')
350: and not exists
351: (select NULL
352: from WF_WL_VIEWS_TL T
353: where B.VIEW_ID = T.VIEW_ID
354: and T.LANGUAGE = L.LANGUAGE_CODE);
355: exception
356: when others then

Line 376: UPDATE WF_WL_VIEWS_TL TL

372: l_luby := fnd_load_util.OWNER_ID(x_owner);
373: -- Translate char last_update_date to date
374: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
375:
376: UPDATE WF_WL_VIEWS_TL TL
377: SET TL.TITLE = X_TITLE,
378: TL.DESCRIPTION = X_DESCRIPTION,
379: TL.SOURCE_LANG = userenv('LANG'),
380: TL.LAST_UPDATE_DATE = l_ludate,