APPS.FND_OAM_DSCRAM_RUNS_PKG dependencies on FND_OAM_DSCRAM_RUNS_TL

Line 374: delete from FND_OAM_DSCRAM_RUNS_TL T

370: PROCEDURE ADD_LANGUAGE
371: IS
372: BEGIN
373:
374: delete from FND_OAM_DSCRAM_RUNS_TL T
375: where not exists
376: (select NULL
377: from FND_OAM_DSCRAM_RUNS_B B
378: where B.RUN_ID = T.RUN_ID

Line 381: update FND_OAM_DSCRAM_RUNS_TL T set (

377: from FND_OAM_DSCRAM_RUNS_B B
378: where B.RUN_ID = T.RUN_ID
379: );
380:
381: update FND_OAM_DSCRAM_RUNS_TL T set (
382: DISPLAY_NAME,
383: DESCRIPTION
384: ) = (select
385: B.DISPLAY_NAME,

Line 387: from FND_OAM_DSCRAM_RUNS_TL B

383: DESCRIPTION
384: ) = (select
385: B.DISPLAY_NAME,
386: B.DESCRIPTION
387: from FND_OAM_DSCRAM_RUNS_TL B
388: where B.RUN_ID = T.RUN_ID
389: and B.LANGUAGE = T.SOURCE_LANG)
390: where (
391: T.RUN_ID,

Line 396: from FND_OAM_DSCRAM_RUNS_TL SUBB, FND_OAM_DSCRAM_RUNS_TL SUBT

392: T.LANGUAGE
393: ) in (select
394: SUBT.RUN_ID,
395: SUBT.LANGUAGE
396: from FND_OAM_DSCRAM_RUNS_TL SUBB, FND_OAM_DSCRAM_RUNS_TL SUBT
397: where SUBB.RUN_ID = SUBT.RUN_ID
398: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
399: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
400: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 405: insert into FND_OAM_DSCRAM_RUNS_TL (

401: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
402: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
403: ));
404:
405: insert into FND_OAM_DSCRAM_RUNS_TL (
406: RUN_ID,
407: DISPLAY_NAME,
408: DESCRIPTION,
409: CREATED_BY,

Line 427: from FND_OAM_DSCRAM_RUNS_TL B, FND_LANGUAGES L

423: B.LAST_UPDATE_DATE,
424: B.LAST_UPDATE_LOGIN,
425: L.LANGUAGE_CODE,
426: B.SOURCE_LANG
427: from FND_OAM_DSCRAM_RUNS_TL B, FND_LANGUAGES L
428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL

Line 432: from FND_OAM_DSCRAM_RUNS_TL T

428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL
432: from FND_OAM_DSCRAM_RUNS_TL T
433: where T.RUN_ID = B.RUN_ID
434: and T.LANGUAGE = L.LANGUAGE_CODE);
435:
436: END ADD_LANGUAGE;