eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OAM_DSCRAM_ARGS_PKG dependencies on FND_OAM_DSCRAM_ARGS_TL

Line 2667: delete from FND_OAM_DSCRAM_ARGS_TL T

2663: PROCEDURE ADD_LANGUAGE
2664: IS
2665: BEGIN
2666:
2667: delete from FND_OAM_DSCRAM_ARGS_TL T
2668: where not exists
2669: (select NULL
2670: from FND_OAM_DSCRAM_ARGS_B B
2671: where B.ARG_ID = T.ARG_ID

Line 2674: update FND_OAM_DSCRAM_ARGS_TL T set (

2670: from FND_OAM_DSCRAM_ARGS_B B
2671: where B.ARG_ID = T.ARG_ID
2672: );
2673:
2674: update FND_OAM_DSCRAM_ARGS_TL T set (
2675: DISPLAY_NAME,
2676: DESCRIPTION
2677: ) = (select
2678: B.DISPLAY_NAME,

Line 2680: from FND_OAM_DSCRAM_ARGS_TL B

2676: DESCRIPTION
2677: ) = (select
2678: B.DISPLAY_NAME,
2679: B.DESCRIPTION
2680: from FND_OAM_DSCRAM_ARGS_TL B
2681: where B.ARG_ID = T.ARG_ID
2682: and B.LANGUAGE = T.SOURCE_LANG)
2683: where (
2684: T.ARG_ID,

Line 2689: from FND_OAM_DSCRAM_ARGS_TL SUBB, FND_OAM_DSCRAM_ARGS_TL SUBT

2685: T.LANGUAGE
2686: ) in (select
2687: SUBT.ARG_ID,
2688: SUBT.LANGUAGE
2689: from FND_OAM_DSCRAM_ARGS_TL SUBB, FND_OAM_DSCRAM_ARGS_TL SUBT
2690: where SUBB.ARG_ID = SUBT.ARG_ID
2691: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2692: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
2693: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 2698: insert into FND_OAM_DSCRAM_ARGS_TL (

2694: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
2695: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
2696: ));
2697:
2698: insert into FND_OAM_DSCRAM_ARGS_TL (
2699: ARG_ID,
2700: DISPLAY_NAME,
2701: DESCRIPTION,
2702: CREATED_BY,

Line 2720: from FND_OAM_DSCRAM_ARGS_TL B, FND_LANGUAGES L

2716: B.LAST_UPDATE_DATE,
2717: B.LAST_UPDATE_LOGIN,
2718: L.LANGUAGE_CODE,
2719: B.SOURCE_LANG
2720: from FND_OAM_DSCRAM_ARGS_TL B, FND_LANGUAGES L
2721: where L.INSTALLED_FLAG in ('I', 'B')
2722: and B.LANGUAGE = userenv('LANG')
2723: and not exists
2724: (select NULL

Line 2725: from FND_OAM_DSCRAM_ARGS_TL T

2721: where L.INSTALLED_FLAG in ('I', 'B')
2722: and B.LANGUAGE = userenv('LANG')
2723: and not exists
2724: (select NULL
2725: from FND_OAM_DSCRAM_ARGS_TL T
2726: where T.ARG_ID = B.ARG_ID
2727: and T.LANGUAGE = L.LANGUAGE_CODE);
2728:
2729: END ADD_LANGUAGE;