APPS.XDP_ADAPTER_TYPE_ATTRS_PKG dependencies on XDP_ADAPTER_TYPE_ATTRS_TL

Line 47: insert into XDP_ADAPTER_TYPE_ATTRS_TL (

43: X_LAST_UPDATED_BY,
44: X_LAST_UPDATE_LOGIN
45: );
46:
47: insert into XDP_ADAPTER_TYPE_ATTRS_TL (
48: OBJECT_VERSION_NUMBER,
49: CREATION_DATE,
50: LAST_UPDATED_BY,
51: LAST_UPDATE_DATE,

Line 75: from XDP_ADAPTER_TYPE_ATTRS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from XDP_ADAPTER_TYPE_ATTRS_TL T
76: where T.ADAPTER_TYPE_ATTRS_ID = X_ADAPTER_TYPE_ATTRS_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 112: from XDP_ADAPTER_TYPE_ATTRS_TL

108: cursor c1 is select
109: DISPLAY_NAME,
110: DESCRIPTION,
111: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
112: from XDP_ADAPTER_TYPE_ATTRS_TL
113: where ADAPTER_TYPE_ATTRS_ID = X_ADAPTER_TYPE_ATTRS_ID
114: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
115: for update of ADAPTER_TYPE_ATTRS_ID nowait;
116: begin

Line 180: update XDP_ADAPTER_TYPE_ATTRS_TL set

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: update XDP_ADAPTER_TYPE_ATTRS_TL set
181: DISPLAY_NAME = X_DISPLAY_NAME,
182: DESCRIPTION = X_DESCRIPTION,
183: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
184: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 199: delete from XDP_ADAPTER_TYPE_ATTRS_TL

195: procedure DELETE_ROW (
196: X_ADAPTER_TYPE_ATTRS_ID in NUMBER
197: ) is
198: begin
199: delete from XDP_ADAPTER_TYPE_ATTRS_TL
200: where ADAPTER_TYPE_ATTRS_ID = X_ADAPTER_TYPE_ATTRS_ID;
201:
202: if (sql%notfound) then
203: raise no_data_found;

Line 217: delete from XDP_ADAPTER_TYPE_ATTRS_TL T

213:
214: procedure ADD_LANGUAGE
215: is
216: begin
217: delete from XDP_ADAPTER_TYPE_ATTRS_TL T
218: where not exists
219: (select NULL
220: from XDP_ADAPTER_TYPE_ATTRS_B B
221: where B.ADAPTER_TYPE_ATTRS_ID = T.ADAPTER_TYPE_ATTRS_ID

Line 224: update XDP_ADAPTER_TYPE_ATTRS_TL T set (

220: from XDP_ADAPTER_TYPE_ATTRS_B B
221: where B.ADAPTER_TYPE_ATTRS_ID = T.ADAPTER_TYPE_ATTRS_ID
222: );
223:
224: update XDP_ADAPTER_TYPE_ATTRS_TL T set (
225: DISPLAY_NAME,
226: DESCRIPTION
227: ) = (select
228: B.DISPLAY_NAME,

Line 230: from XDP_ADAPTER_TYPE_ATTRS_TL B

226: DESCRIPTION
227: ) = (select
228: B.DISPLAY_NAME,
229: B.DESCRIPTION
230: from XDP_ADAPTER_TYPE_ATTRS_TL B
231: where B.ADAPTER_TYPE_ATTRS_ID = T.ADAPTER_TYPE_ATTRS_ID
232: and B.LANGUAGE = T.SOURCE_LANG)
233: where (
234: T.ADAPTER_TYPE_ATTRS_ID,

Line 239: from XDP_ADAPTER_TYPE_ATTRS_TL SUBB, XDP_ADAPTER_TYPE_ATTRS_TL SUBT

235: T.LANGUAGE
236: ) in (select
237: SUBT.ADAPTER_TYPE_ATTRS_ID,
238: SUBT.LANGUAGE
239: from XDP_ADAPTER_TYPE_ATTRS_TL SUBB, XDP_ADAPTER_TYPE_ATTRS_TL SUBT
240: where SUBB.ADAPTER_TYPE_ATTRS_ID = SUBT.ADAPTER_TYPE_ATTRS_ID
241: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
242: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
243: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 246: insert into XDP_ADAPTER_TYPE_ATTRS_TL (

242: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
243: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
244: ));
245:
246: insert into XDP_ADAPTER_TYPE_ATTRS_TL (
247: OBJECT_VERSION_NUMBER,
248: CREATION_DATE,
249: LAST_UPDATED_BY,
250: LAST_UPDATE_DATE,

Line 270: from XDP_ADAPTER_TYPE_ATTRS_TL B, FND_LANGUAGES L

266: B.ADAPTER_TYPE_ATTRS_ID,
267: B.DISPLAY_NAME,
268: L.LANGUAGE_CODE,
269: B.SOURCE_LANG
270: from XDP_ADAPTER_TYPE_ATTRS_TL B, FND_LANGUAGES L
271: where L.INSTALLED_FLAG in ('I', 'B')
272: and B.LANGUAGE = userenv('LANG')
273: and not exists
274: (select NULL

Line 275: from XDP_ADAPTER_TYPE_ATTRS_TL T

271: where L.INSTALLED_FLAG in ('I', 'B')
272: and B.LANGUAGE = userenv('LANG')
273: and not exists
274: (select NULL
275: from XDP_ADAPTER_TYPE_ATTRS_TL T
276: where T.ADAPTER_TYPE_ATTRS_ID = B.ADAPTER_TYPE_ATTRS_ID
277: and T.LANGUAGE = L.LANGUAGE_CODE);
278: end ADD_LANGUAGE;
279:

Line 343: UPDATE XDP_ADAPTER_TYPE_ATTRS_TL

339:
340: BEGIN
341: -- only update rows that have not been altered by user
342:
343: UPDATE XDP_ADAPTER_TYPE_ATTRS_TL
344: SET display_name = X_DISPLAY_NAME,
345: description = X_DESCRIPTION,
346: source_lang = userenv('LANG'),
347: last_update_date = sysdate,