APPS.AR_BPA_DATASRC_APPS_PKG dependencies on AR_BPA_DATASRC_APPS_TL

Line 46: insert into AR_BPA_DATASRC_APPS_TL (

42: X_LAST_UPDATED_BY,
43: X_LAST_UPDATE_LOGIN
44: );
45:
46: insert into AR_BPA_DATASRC_APPS_TL (
47: APPLICATION_ID,
48: DATASRC_APP_NAME,
49: DATASRC_APP_DESC,
50: CREATED_BY,

Line 72: from AR_BPA_DATASRC_APPS_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from AR_BPA_DATASRC_APPS_TL T
73: where T.APPLICATION_ID = X_APPLICATION_ID
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: open c;

Line 109: from AR_BPA_DATASRC_APPS_TL

105: cursor c1 is select
106: DATASRC_APP_NAME,
107: DATASRC_APP_DESC,
108: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
109: from AR_BPA_DATASRC_APPS_TL
110: where APPLICATION_ID = X_APPLICATION_ID
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
112: for update of APPLICATION_ID nowait;
113: begin

Line 180: update AR_BPA_DATASRC_APPS_TL set

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: update AR_BPA_DATASRC_APPS_TL set
181: DATASRC_APP_NAME = X_DATASRC_APP_NAME,
182: DATASRC_APP_DESC = X_DATASRC_APP_DESC,
183: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
184: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 207: delete from AR_BPA_DATASRC_APPS_TL

203:
204: delete from AR_BPA_ITEMS_B
205: where SEEDED_APPLICATION_ID = X_APPLICATION_ID;
206:
207: delete from AR_BPA_DATASRC_APPS_TL
208: where APPLICATION_ID = X_APPLICATION_ID;
209:
210: if (sql%notfound) then
211: raise no_data_found;

Line 225: delete from AR_BPA_DATASRC_APPS_TL T

221:
222: procedure ADD_LANGUAGE
223: is
224: begin
225: delete from AR_BPA_DATASRC_APPS_TL T
226: where not exists
227: (select NULL
228: from AR_BPA_DATASRC_APPS_B B
229: where B.APPLICATION_ID = T.APPLICATION_ID

Line 232: update AR_BPA_DATASRC_APPS_TL T set (

228: from AR_BPA_DATASRC_APPS_B B
229: where B.APPLICATION_ID = T.APPLICATION_ID
230: );
231:
232: update AR_BPA_DATASRC_APPS_TL T set (
233: DATASRC_APP_NAME,
234: DATASRC_APP_DESC
235: ) = (select
236: B.DATASRC_APP_NAME,

Line 238: from AR_BPA_DATASRC_APPS_TL B

234: DATASRC_APP_DESC
235: ) = (select
236: B.DATASRC_APP_NAME,
237: B.DATASRC_APP_DESC
238: from AR_BPA_DATASRC_APPS_TL B
239: where B.APPLICATION_ID = T.APPLICATION_ID
240: and B.LANGUAGE = T.SOURCE_LANG)
241: where (
242: T.APPLICATION_ID,

Line 247: from AR_BPA_DATASRC_APPS_TL SUBB, AR_BPA_DATASRC_APPS_TL SUBT

243: T.LANGUAGE
244: ) in (select
245: SUBT.APPLICATION_ID,
246: SUBT.LANGUAGE
247: from AR_BPA_DATASRC_APPS_TL SUBB, AR_BPA_DATASRC_APPS_TL SUBT
248: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
249: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
250: and (SUBB.DATASRC_APP_NAME <> SUBT.DATASRC_APP_NAME
251: or SUBB.DATASRC_APP_DESC <> SUBT.DATASRC_APP_DESC

Line 256: insert into AR_BPA_DATASRC_APPS_TL (

252: or (SUBB.DATASRC_APP_DESC is null and SUBT.DATASRC_APP_DESC is not null)
253: or (SUBB.DATASRC_APP_DESC is not null and SUBT.DATASRC_APP_DESC is null)
254: ));
255:
256: insert into AR_BPA_DATASRC_APPS_TL (
257: APPLICATION_ID,
258: DATASRC_APP_NAME,
259: DATASRC_APP_DESC,
260: CREATED_BY,

Line 278: from AR_BPA_DATASRC_APPS_TL B, FND_LANGUAGES L

274: B.LAST_UPDATE_DATE,
275: B.LAST_UPDATE_LOGIN,
276: L.LANGUAGE_CODE,
277: B.SOURCE_LANG
278: from AR_BPA_DATASRC_APPS_TL B, FND_LANGUAGES L
279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL

Line 283: from AR_BPA_DATASRC_APPS_TL T

279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL
283: from AR_BPA_DATASRC_APPS_TL T
284: where T.APPLICATION_ID = B.APPLICATION_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286: end ADD_LANGUAGE;
287:

Line 295: update AR_BPA_DATASRC_APPS_TL

291: X_DATASRC_APP_DESC in VARCHAR2,
292: X_OWNER in VARCHAR2) IS
293: begin
294:
295: update AR_BPA_DATASRC_APPS_TL
296: set DATASRC_APP_NAME = X_DATASRC_APP_NAME,
297: DATASRC_APP_DESC = X_DATASRC_APP_DESC,
298: source_lang = userenv('LANG'),
299: last_update_date = sysdate,