APPS.XDP_ADAPTER_TYPES_PKG dependencies on XDP_ADAPTER_TYPES_TL

Line 60: insert into XDP_ADAPTER_TYPES_TL (

56: X_LAST_UPDATED_BY,
57: X_LAST_UPDATE_LOGIN
58: );
59:
60: insert into XDP_ADAPTER_TYPES_TL (
61: LAST_UPDATE_DATE,
62: LAST_UPDATE_LOGIN,
63: OBJECT_VERSION_NUMBER,
64: ADAPTER_TYPE,

Line 86: from XDP_ADAPTER_TYPES_TL T

82: from FND_LANGUAGES L
83: where L.INSTALLED_FLAG in ('I', 'B')
84: and not exists
85: (select NULL
86: from XDP_ADAPTER_TYPES_TL T
87: where T.ADAPTER_TYPE = X_ADAPTER_TYPE
88: and T.LANGUAGE = L.LANGUAGE_CODE);
89:
90: open c;

Line 131: from XDP_ADAPTER_TYPES_TL

127:
128: cursor c1 is select
129: DISPLAY_NAME,
130: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
131: from XDP_ADAPTER_TYPES_TL
132: where ADAPTER_TYPE = X_ADAPTER_TYPE
133: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
134: for update of ADAPTER_TYPE nowait;
135: begin

Line 216: update XDP_ADAPTER_TYPES_TL set

212: if (sql%notfound) then
213: raise no_data_found;
214: end if;
215:
216: update XDP_ADAPTER_TYPES_TL set
217: DISPLAY_NAME = X_DISPLAY_NAME,
218: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
219: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
220: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 234: delete from XDP_ADAPTER_TYPES_TL

230: procedure DELETE_ROW (
231: X_ADAPTER_TYPE in VARCHAR2
232: ) is
233: begin
234: delete from XDP_ADAPTER_TYPES_TL
235: where ADAPTER_TYPE = X_ADAPTER_TYPE;
236:
237: if (sql%notfound) then
238: raise no_data_found;

Line 252: delete from XDP_ADAPTER_TYPES_TL T

248:
249: procedure ADD_LANGUAGE
250: is
251: begin
252: delete from XDP_ADAPTER_TYPES_TL T
253: where not exists
254: (select NULL
255: from XDP_ADAPTER_TYPES_B B
256: where B.ADAPTER_TYPE = T.ADAPTER_TYPE

Line 259: update XDP_ADAPTER_TYPES_TL T set (

255: from XDP_ADAPTER_TYPES_B B
256: where B.ADAPTER_TYPE = T.ADAPTER_TYPE
257: );
258:
259: update XDP_ADAPTER_TYPES_TL T set (
260: DISPLAY_NAME
261: ) = (select
262: B.DISPLAY_NAME
263: from XDP_ADAPTER_TYPES_TL B

Line 263: from XDP_ADAPTER_TYPES_TL B

259: update XDP_ADAPTER_TYPES_TL T set (
260: DISPLAY_NAME
261: ) = (select
262: B.DISPLAY_NAME
263: from XDP_ADAPTER_TYPES_TL B
264: where B.ADAPTER_TYPE = T.ADAPTER_TYPE
265: and B.LANGUAGE = T.SOURCE_LANG)
266: where (
267: T.ADAPTER_TYPE,

Line 272: from XDP_ADAPTER_TYPES_TL SUBB, XDP_ADAPTER_TYPES_TL SUBT

268: T.LANGUAGE
269: ) in (select
270: SUBT.ADAPTER_TYPE,
271: SUBT.LANGUAGE
272: from XDP_ADAPTER_TYPES_TL SUBB, XDP_ADAPTER_TYPES_TL SUBT
273: where SUBB.ADAPTER_TYPE = SUBT.ADAPTER_TYPE
274: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
275: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
276: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)

Line 280: insert into XDP_ADAPTER_TYPES_TL (

276: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)
277: or (SUBB.DISPLAY_NAME is not null and SUBT.DISPLAY_NAME is null)
278: ));
279:
280: insert into XDP_ADAPTER_TYPES_TL (
281: LAST_UPDATE_DATE,
282: LAST_UPDATE_LOGIN,
283: OBJECT_VERSION_NUMBER,
284: ADAPTER_TYPE,

Line 302: from XDP_ADAPTER_TYPES_TL B, FND_LANGUAGES L

298: B.CREATION_DATE,
299: B.LAST_UPDATED_BY,
300: L.LANGUAGE_CODE,
301: B.SOURCE_LANG
302: from XDP_ADAPTER_TYPES_TL B, FND_LANGUAGES L
303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL

Line 307: from XDP_ADAPTER_TYPES_TL T

303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL
307: from XDP_ADAPTER_TYPES_TL T
308: where T.ADAPTER_TYPE = B.ADAPTER_TYPE
309: and T.LANGUAGE = L.LANGUAGE_CODE);
310: end ADD_LANGUAGE;
311:

Line 385: UPDATE XDP_ADAPTER_TYPES_TL

381:
382: BEGIN
383: -- only update rows that have not been altered by user
384:
385: UPDATE XDP_ADAPTER_TYPES_TL
386: SET display_name = X_DISPLAY_NAME,
387: source_lang = userenv('LANG'),
388: last_update_date = sysdate,
389: --last_updated_by = decode(X_OWNER, 'SEED', 1, 0), /*dputhiye 14-JUL-2005. DECODE replaced with FND API.*/