APPS.WF_WL_LISTS_PKG dependencies on WF_WL_LISTS_TL

Line 78: insert into WF_WL_LISTS_TL (LIST_ID,

74: l_ludate, --LAST_UPDATE_DATE,
75: l_luby, --LAST_UPDATED_BY,
76: 0, --LAST_UPDATE_LOGIN,
77: FND_GLOBAL.SECURITY_GROUP_ID);
78: insert into WF_WL_LISTS_TL (LIST_ID,
79: LIST_NAME,
80: DESCRIPTION,
81: LANGUAGE,
82: SOURCE_LANG,

Line 104: from WF_WL_LISTS_TL TL, WF_WL_LISTS B

100: from FND_LANGUAGES L
101: where L.INSTALLED_FLAG in ('I', 'B')
102: and not exists
103: (select NULL
104: from WF_WL_LISTS_TL TL, WF_WL_LISTS B
105: where B.LIST_ID = TL.LIST_ID and
106: B.LIST_KEY = X_LIST_KEY and
107: TL.LANGUAGE = L.LANGUAGE_CODE);
108:

Line 173: insert into WF_WL_LISTS_TL (LIST_ID,

169: end UPDATE_LIST_BY_KEY;
170:
171: procedure ADD_LANGUAGE is
172: begin
173: insert into WF_WL_LISTS_TL (LIST_ID,
174: LIST_NAME,
175: DESCRIPTION,
176: LANGUAGE,
177: SOURCE_LANG,

Line 195: from WF_WL_LISTS_TL B, FND_LANGUAGES L

191: B.LAST_UPDATE_DATE,
192: B.LAST_UPDATED_BY,
193: B.LAST_UPDATE_LOGIN,
194: B.SECURITY_GROUP_ID
195: from WF_WL_LISTS_TL B, FND_LANGUAGES L
196: where L.INSTALLED_FLAG in ('I', 'B')
197: and B.LANGUAGE=userenv('LANG')
198: and not exists
199: (select NULL

Line 200: from WF_WL_LISTS_TL TL

196: where L.INSTALLED_FLAG in ('I', 'B')
197: and B.LANGUAGE=userenv('LANG')
198: and not exists
199: (select NULL
200: from WF_WL_LISTS_TL TL
201: where B.LIST_ID = TL.LIST_ID and
202: TL.LANGUAGE = L.LANGUAGE_CODE);
203: exception
204: when others then

Line 217: UPDATE WF_WL_LISTS_TL TL

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,
219: TL.DESCRIPTION = X_DESCRIPTION,
220: TL.SOURCE_LANG = userenv('LANG'),
221: TL.LAST_UPDATE_DATE = l_ludate,