APPS.WF_WL_LISTS_PKG dependencies on FND_LOAD_UTIL

Line 47: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

43: cursor c_newrow is select ROWID from WF_WL_LISTS
44: where LIST_KEY = X_LIST_KEY;
45: X_ROWID VARCHAR2(30);
46: l_user_id number := FIND_USER_ID(X_USER_NAME);
47: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
48: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
49: begin
50: insert into WF_WL_LISTS (LIST_ID,
51: LIST_KEY,

Line 132: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

128: X_OWNER IN VARCHAR2,
129: X_LAST_UPDATE_DATE IN VARCHAR2) is
130: l_list_id number := FIND_LIST_ID(X_LIST_KEY);
131: l_user_id number := FIND_USER_ID(X_USER_NAME);
132: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
133: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
134: begin
135: update WF_WL_LISTS B
136: set B.USER_ID = l_user_id,

Line 214: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

210: X_DESCRIPTION in VARCHAR2,
211: X_OWNER IN VARCHAR2,
212: X_LAST_UPDATE_DATE IN VARCHAR2) is
213: l_list_id number := FIND_LIST_ID(X_LIST_KEY);
214: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
215: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
216: BEGIN
217: UPDATE WF_WL_LISTS_TL TL
218: SET TL.LIST_NAME = X_LIST_NAME,

Line 238: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

234: X_OWNER IN VARCHAR2,
235: X_LAST_UPDATE_DATE IN VARCHAR2) is
236: l_list_id number := FIND_LIST_ID(X_LIST_KEY);
237: l_user_id number := FIND_USER_ID(X_USER_NAME);
238: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
239: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
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);

Line 274: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

270: X_OWNER IN VARCHAR2,
271: X_LAST_UPDATE_DATE IN VARCHAR2) is
272: l_list_id number := FIND_LIST_ID(X_LIST_KEY);
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,