APPS.WF_WL_VIEWS_PKG dependencies on WF_WL_VIEW_ATTRIBUTES

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 405: select ROWID from WF_WL_VIEW_ATTRIBUTES

401: is
402: l_view_id number := FIND_VIEW_ID(X_VIEW_KEY);
403: l_row_id varchar2(50);
404: cursor c_newrow is
405: select ROWID from WF_WL_VIEW_ATTRIBUTES
406: where VIEW_ID = l_view_id and
407: ATTRIBUTE_NAME = X_ATTRIBUTE_NAME;
408: l_luby number;
409: l_ludate date;

Line 415: insert into WF_WL_VIEW_ATTRIBUTES (VIEW_ID ,

411: -- Translate owner to file_last_updated_by
412: l_luby := fnd_load_util.OWNER_ID(x_owner);
413: -- Translate char last_update_date to date
414: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
415: insert into WF_WL_VIEW_ATTRIBUTES (VIEW_ID ,
416: ATTRIBUTE_NAME ,
417: ATTRIBUTE_TYPE ,
418: RENDER ,
419: SEQUENCE ,

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 498: update WF_WL_VIEW_ATTRIBUTES B

494: -- Translate owner to file_last_updated_by
495: l_luby := fnd_load_util.OWNER_ID(x_owner);
496: -- Translate char last_update_date to date
497: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
498: update WF_WL_VIEW_ATTRIBUTES B
499: set B.ATTRIBUTE_TYPE = X_ATTRIBUTE_TYPE ,
500: B.RENDER = X_RENDER ,
501: B.SEQUENCE = X_SEQUENCE ,
502: B.CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,

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,