DBA Data[Home] [Help]

APPS.EGO_ITEM_WS_PVT dependencies on FND_LANGUAGES

Line 2448: FROM FND_LANGUAGES WHERE NLS_LANGUAGE = l_lang_name_tab(i);

2444: l_lang_count := l_lang_count + 1;
2445: ELSE
2446: BEGIN
2447: SELECT language_code INTO l_lang_code_tab(i)
2448: FROM FND_LANGUAGES WHERE NLS_LANGUAGE = l_lang_name_tab(i);
2449:
2450: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
2451: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,l_lang_code_tab(i),NULL,SYSDATE,G_CURRENT_USER_ID);
2452: EXCEPTION

Line 2476: FROM FND_LANGUAGES WHERE language_code = l_lang_code_tab(i);

2472: END IF;
2473: ELSE
2474: BEGIN
2475: SELECT language_code INTO l_lang_code_tab(i)
2476: FROM FND_LANGUAGES WHERE language_code = l_lang_code_tab(i);
2477:
2478: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
2479: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,l_lang_code_tab(i),NULL,SYSDATE,G_CURRENT_USER_ID);
2480: EXCEPTION

Line 2503: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP

2499: END IF;
2500: END LOOP;
2501:
2502: IF (l_lang_count = l_lang_code_tab.Count) THEN
2503: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP
2504: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
2505: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,i.language_code,NULL,SYSDATE,G_CURRENT_USER_ID);
2506: END LOOP;
2507: END IF;

Line 2510: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP

2506: END LOOP;
2507: END IF;
2508: -- Bug 12749057 : Start : When user doens't provide any labguage details.
2509: ELSE
2510: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP
2511: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
2512: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,i.language_code,NULL,SYSDATE,G_CURRENT_USER_ID);
2513: END LOOP;
2514: -- Bug 12749057 : End