DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on FND_LANGUAGES

Line 2732: l_lang_installed_flag FND_LANGUAGES.INSTALLED_FLAG%TYPE;

2728: ) IS
2729:
2730: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attribute_Group';
2731:
2732: l_lang_installed_flag FND_LANGUAGES.INSTALLED_FLAG%TYPE;
2733:
2734: --we don't use l_api_version yet, but eventually we might:
2735: --if we change required parameters, version goes from n.x to (n+1).x
2736: --if we change optional parameters, version goes from x.n to x.(n+1)

Line 4453: FROM FND_LANGUAGES L

4449: ,NVL(p_last_update_date, SYSDATE)
4450: ,NVL(p_last_updated_by, G_CURRENT_USER_ID)
4451: ,NVL(p_last_update_date, SYSDATE)
4452: ,G_CURRENT_LOGIN_ID
4453: FROM FND_LANGUAGES L
4454: WHERE L.INSTALLED_FLAG in ('I', 'B');
4455:
4456: ELSIF p_transaction_type = 'UPDATE' THEN
4457: SELECT data_level_id

Line 5580: FROM FND_LANGUAGES L

5576: ,p_display_name --FORM_LEFT_PROMPT
5577: ,p_display_name --FORM_ABOVE_PROMPT
5578: ,p_description --DESCRIPTION
5579: ,USERENV('LANG') --SOURCE_LANG
5580: FROM FND_LANGUAGES L
5581: WHERE L.INSTALLED_FLAG in ('I', 'B');
5582: END IF ;-- l_fnd_exists = 'Y' --Bug 4703510 END
5583:
5584:

Line 8388: FROM FND_LANGUAGES L

8384: SOURCE_LANG
8385: ) SELECT
8386: L_FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,
8387: P_DESCRIPTION,P_DISPLAY_NAME,L.LANGUAGE_CODE,USERENV('LANG')
8388: FROM FND_LANGUAGES L
8389: WHERE L.INSTALLED_FLAG IN ('I', 'B' ) ;
8390:
8391: x_is_versioned :='true';
8392: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8535: FROM FND_LANGUAGES L

8531: ,l_Sysdate --CREATION_DATE
8532: ,g_current_user_id --LAST_UPDATED_BY
8533: ,l_Sysdate --LAST_UPDATE_DATE
8534: ,g_current_login_id --LAST_UPDATE_LOGIN
8535: FROM FND_LANGUAGES L
8536: WHERE L.INSTALLED_FLAG in ('I', 'B');
8537: ***/
8538:
8539:

Line 10326: FROM FND_LANGUAGES L

10322: ,g_current_user_id
10323: ,l_Sysdate
10324: ,g_current_user_id
10325: ,g_current_login_id
10326: FROM FND_LANGUAGES L
10327: WHERE L.INSTALLED_FLAG in ('I', 'B');
10328:
10329: -- Standard check of p_commit
10330: IF FND_API.To_Boolean(p_commit) THEN

Line 11197: FROM FND_LANGUAGES L

11193: ,g_current_user_id
11194: ,l_Sysdate
11195: ,g_current_user_id
11196: ,g_current_login_id
11197: FROM FND_LANGUAGES L
11198: WHERE L.INSTALLED_FLAG in ('I', 'B');
11199:
11200: -- Standard check of p_commit
11201: IF FND_API.To_Boolean(p_commit) THEN

Line 11586: FROM FND_LANGUAGES L

11582: ,l_Sysdate
11583: ,g_current_user_id
11584: ,g_current_login_id
11585:
11586: FROM FND_LANGUAGES L
11587: WHERE L.INSTALLED_FLAG in ('I', 'B');
11588:
11589: -- Standard check of p_commit
11590: IF FND_API.To_Boolean(p_commit) THEN

Line 12878: FROM FND_LANGUAGES L

12874: ,g_current_user_id
12875: ,l_Sysdate
12876: ,g_current_user_id
12877: ,g_current_login_id
12878: FROM FND_LANGUAGES L
12879: WHERE L.INSTALLED_FLAG in ('I', 'B');
12880:
12881: -- Standard check of p_commit
12882: IF FND_API.To_Boolean(p_commit) THEN

Line 13783: FROM FND_LANGUAGES L

13779: ,l_Sysdate
13780: ,g_current_user_id
13781: ,g_current_login_id
13782:
13783: FROM FND_LANGUAGES L
13784: WHERE L.INSTALLED_FLAG in ('I', 'B');
13785:
13786: -- Standard check of p_commit
13787: IF FND_API.To_Boolean(p_commit) THEN

Line 14288: from EGO_ACTIONS_TL B, FND_LANGUAGES L

14284: B.LAST_UPDATE_DATE,
14285: B.LAST_UPDATE_LOGIN,
14286: L.LANGUAGE_CODE,
14287: B.SOURCE_LANG
14288: from EGO_ACTIONS_TL B, FND_LANGUAGES L
14289: where L.INSTALLED_FLAG in ('I', 'B')
14290: and B.LANGUAGE = userenv('LANG')
14291: and not exists
14292: (select NULL

Line 14358: from EGO_ACTION_GROUPS_TL B, FND_LANGUAGES L

14354: B.LAST_UPDATE_DATE,
14355: B.LAST_UPDATE_LOGIN,
14356: L.LANGUAGE_CODE,
14357: B.SOURCE_LANG
14358: from EGO_ACTION_GROUPS_TL B, FND_LANGUAGES L
14359: where L.INSTALLED_FLAG in ('I', 'B')
14360: and B.LANGUAGE = userenv('LANG')
14361: and not exists
14362: (select NULL

Line 14427: from EGO_FUNCTIONS_TL B, FND_LANGUAGES L

14423: B.DISPLAY_NAME,
14424: B.DESCRIPTION,
14425: L.LANGUAGE_CODE,
14426: B.SOURCE_LANG
14427: from EGO_FUNCTIONS_TL B, FND_LANGUAGES L
14428: where L.INSTALLED_FLAG in ('I', 'B')
14429: and B.LANGUAGE = userenv('LANG')
14430: and not exists
14431: (select NULL

Line 14496: from EGO_FUNC_PARAMS_TL B, FND_LANGUAGES L

14492: B.LAST_UPDATE_DATE,
14493: B.LAST_UPDATE_LOGIN,
14494: L.LANGUAGE_CODE,
14495: B.SOURCE_LANG
14496: from EGO_FUNC_PARAMS_TL B, FND_LANGUAGES L
14497: where L.INSTALLED_FLAG in ('I', 'B')
14498: and B.LANGUAGE = userenv('LANG')
14499: and not exists
14500: (select NULL

Line 14565: from EGO_PAGES_TL B, FND_LANGUAGES L

14561: B.LAST_UPDATE_DATE,
14562: B.LAST_UPDATE_LOGIN,
14563: L.LANGUAGE_CODE,
14564: B.SOURCE_LANG
14565: from EGO_PAGES_TL B, FND_LANGUAGES L
14566: where L.INSTALLED_FLAG in ('I', 'B')
14567: and B.LANGUAGE = userenv('LANG')
14568: and not exists
14569: (select NULL

Line 14630: from EGO_DATA_LEVEL_TL B, FND_LANGUAGES L

14626: B.LAST_UPDATE_DATE,
14627: B.LAST_UPDATE_LOGIN,
14628: L.LANGUAGE_CODE,
14629: B.SOURCE_LANG
14630: from EGO_DATA_LEVEL_TL B, FND_LANGUAGES L
14631: where L.INSTALLED_FLAG in ('I', 'B')
14632: and B.LANGUAGE = userenv('LANG')
14633: and not exists
14634: (select NULL

Line 14708: FROM EGO_FLEX_VALUE_VERSION_TL B, FND_LANGUAGES L

14704: B.DESCRIPTION,
14705: B.FLEX_VALUE_MEANING,
14706: L.LANGUAGE_CODE,
14707: B.SOURCE_LANG
14708: FROM EGO_FLEX_VALUE_VERSION_TL B, FND_LANGUAGES L
14709: where L.INSTALLED_FLAG in ('I', 'B')
14710: and B.LANGUAGE = userenv('LANG')
14711: and not exists
14712: (select NULL