APPS.AR_BPA_CONTENT_AREAS_PKG dependencies on AR_BPA_CONTENT_AREAS_TL

Line 100: insert into AR_BPA_CONTENT_AREAS_TL (

96: X_LAST_UPDATED_BY,
97: X_LAST_UPDATE_LOGIN
98: );
99:
100: insert into AR_BPA_CONTENT_AREAS_TL (
101: CONTENT_AREA_ID,
102: CONTENT_AREA_NAME,
103: CONTENT_DISPLAY_PROMPT,
104: CREATED_BY,

Line 126: from AR_BPA_CONTENT_AREAS_TL T

122: from FND_LANGUAGES L
123: where L.INSTALLED_FLAG in ('I', 'B')
124: and not exists
125: (select NULL
126: from AR_BPA_CONTENT_AREAS_TL T
127: where T.CONTENT_AREA_ID = X_CONTENT_AREA_ID
128: and T.LANGUAGE = L.LANGUAGE_CODE);
129:
130: open c;

Line 199: from AR_BPA_CONTENT_AREAS_TL

195: cursor c1 is select
196: CONTENT_AREA_NAME,
197: CONTENT_DISPLAY_PROMPT,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from AR_BPA_CONTENT_AREAS_TL
200: where CONTENT_AREA_ID = X_CONTENT_AREA_ID
201: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
202: for update of CONTENT_AREA_ID nowait;
203: begin

Line 339: update AR_BPA_CONTENT_AREAS_TL set

335: if (sql%notfound) then
336: raise no_data_found;
337: end if;
338:
339: update AR_BPA_CONTENT_AREAS_TL set
340: CONTENT_AREA_NAME = X_CONTENT_AREA_NAME,
341: CONTENT_DISPLAY_PROMPT = X_CONTENT_DISPLAY_PROMPT,
342: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
343: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 358: delete from AR_BPA_CONTENT_AREAS_TL

354: procedure DELETE_ROW (
355: X_CONTENT_AREA_ID in NUMBER
356: ) is
357: begin
358: delete from AR_BPA_CONTENT_AREAS_TL
359: where CONTENT_AREA_ID = X_CONTENT_AREA_ID;
360:
361: if (sql%notfound) then
362: raise no_data_found;

Line 376: delete from AR_BPA_CONTENT_AREAS_TL T

372:
373: procedure ADD_LANGUAGE
374: is
375: begin
376: delete from AR_BPA_CONTENT_AREAS_TL T
377: where not exists
378: (select NULL
379: from AR_BPA_CONTENT_AREAS_B B
380: where B.CONTENT_AREA_ID = T.CONTENT_AREA_ID

Line 383: update AR_BPA_CONTENT_AREAS_TL T set (

379: from AR_BPA_CONTENT_AREAS_B B
380: where B.CONTENT_AREA_ID = T.CONTENT_AREA_ID
381: );
382:
383: update AR_BPA_CONTENT_AREAS_TL T set (
384: CONTENT_AREA_NAME,
385: CONTENT_DISPLAY_PROMPT
386: ) = (select
387: B.CONTENT_AREA_NAME,

Line 389: from AR_BPA_CONTENT_AREAS_TL B

385: CONTENT_DISPLAY_PROMPT
386: ) = (select
387: B.CONTENT_AREA_NAME,
388: B.CONTENT_DISPLAY_PROMPT
389: from AR_BPA_CONTENT_AREAS_TL B
390: where B.CONTENT_AREA_ID = T.CONTENT_AREA_ID
391: and B.LANGUAGE = T.SOURCE_LANG)
392: where (
393: T.CONTENT_AREA_ID,

Line 398: from AR_BPA_CONTENT_AREAS_TL SUBB, AR_BPA_CONTENT_AREAS_TL SUBT

394: T.LANGUAGE
395: ) in (select
396: SUBT.CONTENT_AREA_ID,
397: SUBT.LANGUAGE
398: from AR_BPA_CONTENT_AREAS_TL SUBB, AR_BPA_CONTENT_AREAS_TL SUBT
399: where SUBB.CONTENT_AREA_ID = SUBT.CONTENT_AREA_ID
400: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
401: and (SUBB.CONTENT_AREA_NAME <> SUBT.CONTENT_AREA_NAME
402: or (SUBB.CONTENT_AREA_NAME is null and SUBT.CONTENT_AREA_NAME is not null)

Line 409: insert into AR_BPA_CONTENT_AREAS_TL (

405: or (SUBB.CONTENT_DISPLAY_PROMPT is null and SUBT.CONTENT_DISPLAY_PROMPT is not null)
406: or (SUBB.CONTENT_DISPLAY_PROMPT is not null and SUBT.CONTENT_DISPLAY_PROMPT is null)
407: ));
408:
409: insert into AR_BPA_CONTENT_AREAS_TL (
410: CONTENT_AREA_ID,
411: CONTENT_AREA_NAME,
412: CONTENT_DISPLAY_PROMPT,
413: CREATED_BY,

Line 431: from AR_BPA_CONTENT_AREAS_TL B, FND_LANGUAGES L

427: B.LAST_UPDATE_DATE,
428: B.LAST_UPDATE_LOGIN,
429: L.LANGUAGE_CODE,
430: B.SOURCE_LANG
431: from AR_BPA_CONTENT_AREAS_TL B, FND_LANGUAGES L
432: where L.INSTALLED_FLAG in ('I', 'B')
433: and B.LANGUAGE = userenv('LANG')
434: and not exists
435: (select NULL

Line 436: from AR_BPA_CONTENT_AREAS_TL T

432: where L.INSTALLED_FLAG in ('I', 'B')
433: and B.LANGUAGE = userenv('LANG')
434: and not exists
435: (select NULL
436: from AR_BPA_CONTENT_AREAS_TL T
437: where T.CONTENT_AREA_ID = B.CONTENT_AREA_ID
438: and T.LANGUAGE = L.LANGUAGE_CODE);
439: end ADD_LANGUAGE;
440:

Line 448: update AR_BPA_CONTENT_AREAS_TL

444: X_CONTENT_DISPLAY_PROMPT in VARCHAR2,
445: X_OWNER in VARCHAR2) IS
446: begin
447:
448: update AR_BPA_CONTENT_AREAS_TL
449: set CONTENT_AREA_NAME = X_CONTENT_AREA_NAME,
450: CONTENT_DISPLAY_PROMPT = X_CONTENT_DISPLAY_PROMPT,
451: source_lang = userenv('LANG'),
452: last_update_date = sysdate,