APPS.AR_BPA_DATASRC_VIEWS_PKG dependencies on AR_BPA_DATA_SOURCES_TL

Line 73: insert into AR_BPA_DATA_SOURCES_TL (

69: X_LAST_UPDATED_BY,
70: X_LAST_UPDATE_LOGIN
71: );
72:
73: insert into AR_BPA_DATA_SOURCES_TL (
74: DATA_SOURCE_ID,
75: DATASRC_VIEW_NAME,
76: DATASRC_VIEW_DESC,
77: CREATED_BY,

Line 99: from AR_BPA_DATA_SOURCES_TL T

95: from FND_LANGUAGES L
96: where L.INSTALLED_FLAG in ('I', 'B')
97: and not exists
98: (select NULL
99: from AR_BPA_DATA_SOURCES_TL T
100: where T.DATA_SOURCE_ID = X_DATA_SOURCE_ID
101: and T.LANGUAGE = L.LANGUAGE_CODE);
102:
103: open c;

Line 154: from AR_BPA_DATA_SOURCES_TL

150: cursor c1 is select
151: DATASRC_VIEW_NAME,
152: DATASRC_VIEW_DESC,
153: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
154: from AR_BPA_DATA_SOURCES_TL
155: where DATA_SOURCE_ID = X_DATA_SOURCE_ID
156: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
157: for update of DATA_SOURCE_ID nowait;
158: begin

Line 258: update AR_BPA_DATA_SOURCES_TL set

254: if (sql%notfound) then
255: raise no_data_found;
256: end if;
257:
258: update AR_BPA_DATA_SOURCES_TL set
259: DATASRC_VIEW_NAME = X_DATASRC_VIEW_NAME,
260: DATASRC_VIEW_DESC = X_DATASRC_VIEW_DESC,
261: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
262: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 285: delete from AR_BPA_DATA_SOURCES_TL

281:
282: delete from AR_BPA_ITEMS_B
283: where DATA_SOURCE_ID = X_DATA_SOURCE_ID;
284:
285: delete from AR_BPA_DATA_SOURCES_TL
286: where DATA_SOURCE_ID = X_DATA_SOURCE_ID;
287:
288: if (sql%notfound) then
289: raise no_data_found;

Line 303: delete from AR_BPA_DATA_SOURCES_TL T

299:
300: procedure ADD_LANGUAGE
301: is
302: begin
303: delete from AR_BPA_DATA_SOURCES_TL T
304: where not exists
305: (select NULL
306: from AR_BPA_DATA_SOURCES_B B
307: where B.DATA_SOURCE_ID = T.DATA_SOURCE_ID

Line 310: update AR_BPA_DATA_SOURCES_TL T set (

306: from AR_BPA_DATA_SOURCES_B B
307: where B.DATA_SOURCE_ID = T.DATA_SOURCE_ID
308: );
309:
310: update AR_BPA_DATA_SOURCES_TL T set (
311: DATASRC_VIEW_NAME,
312: DATASRC_VIEW_DESC
313: ) = (select
314: B.DATASRC_VIEW_NAME,

Line 316: from AR_BPA_DATA_SOURCES_TL B

312: DATASRC_VIEW_DESC
313: ) = (select
314: B.DATASRC_VIEW_NAME,
315: B.DATASRC_VIEW_DESC
316: from AR_BPA_DATA_SOURCES_TL B
317: where B.DATA_SOURCE_ID = T.DATA_SOURCE_ID
318: and B.LANGUAGE = T.SOURCE_LANG)
319: where (
320: T.DATA_SOURCE_ID,

Line 325: from AR_BPA_DATA_SOURCES_TL SUBB, AR_BPA_DATA_SOURCES_TL SUBT

321: T.LANGUAGE
322: ) in (select
323: SUBT.DATA_SOURCE_ID,
324: SUBT.LANGUAGE
325: from AR_BPA_DATA_SOURCES_TL SUBB, AR_BPA_DATA_SOURCES_TL SUBT
326: where SUBB.DATA_SOURCE_ID = SUBT.DATA_SOURCE_ID
327: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
328: and (SUBB.DATASRC_VIEW_NAME <> SUBT.DATASRC_VIEW_NAME
329: or SUBB.DATASRC_VIEW_DESC <> SUBT.DATASRC_VIEW_DESC

Line 334: insert into AR_BPA_DATA_SOURCES_TL (

330: or (SUBB.DATASRC_VIEW_DESC is null and SUBT.DATASRC_VIEW_DESC is not null)
331: or (SUBB.DATASRC_VIEW_DESC is not null and SUBT.DATASRC_VIEW_DESC is null)
332: ));
333:
334: insert into AR_BPA_DATA_SOURCES_TL (
335: DATA_SOURCE_ID,
336: DATASRC_VIEW_NAME,
337: DATASRC_VIEW_DESC,
338: CREATED_BY,

Line 356: from AR_BPA_DATA_SOURCES_TL B, FND_LANGUAGES L

352: B.LAST_UPDATE_DATE,
353: B.LAST_UPDATE_LOGIN,
354: L.LANGUAGE_CODE,
355: B.SOURCE_LANG
356: from AR_BPA_DATA_SOURCES_TL B, FND_LANGUAGES L
357: where L.INSTALLED_FLAG in ('I', 'B')
358: and B.LANGUAGE = userenv('LANG')
359: and not exists
360: (select NULL

Line 361: from AR_BPA_DATA_SOURCES_TL T

357: where L.INSTALLED_FLAG in ('I', 'B')
358: and B.LANGUAGE = userenv('LANG')
359: and not exists
360: (select NULL
361: from AR_BPA_DATA_SOURCES_TL T
362: where T.DATA_SOURCE_ID = B.DATA_SOURCE_ID
363: and T.LANGUAGE = L.LANGUAGE_CODE);
364: end ADD_LANGUAGE;
365:

Line 373: update AR_BPA_DATA_SOURCES_TL

369: X_DATASRC_VIEW_DESC in VARCHAR2,
370: X_OWNER in VARCHAR2) IS
371: begin
372:
373: update AR_BPA_DATA_SOURCES_TL
374: set DATASRC_VIEW_NAME = X_DATASRC_VIEW_NAME,
375: DATASRC_VIEW_DESC = X_DATASRC_VIEW_DESC,
376: source_lang = userenv('LANG'),
377: last_update_date = sysdate,