DBA Data[Home] [Help]

APPS.WF_WL_LISTS_PKG dependencies on WF_WL_FAVORITE_LISTS

Line 244: insert into WF_WL_FAVORITE_LISTS (LIST_ID,

240: begin
241: if l_list_id is null or l_user_id is null then
242: raise_application_error (-20000, 'WF_WL_LISTS_PKG.INSERT_FAVORITE_BY_KEY: null value(s) when creating favorite list '||X_LIST_KEY||' for user '||X_USER_NAME);
243: end if;
244: insert into WF_WL_FAVORITE_LISTS (LIST_ID,
245: USER_ID,
246: SEQUENCE,
247: CREATION_DATE,
248: CREATED_BY,

Line 277: update WF_WL_FAVORITE_LISTS B

273: l_user_id number := FIND_USER_ID(X_USER_NAME);
274: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
275: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
276: begin
277: update WF_WL_FAVORITE_LISTS B
278: set B.SEQUENCE = X_SEQUENCE,
279: B.LAST_UPDATE_DATE = l_ludate,
280: B.LAST_UPDATED_BY = l_luby,
281: B.LAST_UPDATE_LOGIN = 0