APPS.EGO_ODI_PUB dependencies on FND_LANGUAGES

Line 782: from fnd_languages where language_code = l_temp;

778:
779: IF l_temp IS NOT NULL THEN
780: select language_code
781: into p_language_code
782: from fnd_languages where language_code = l_temp;
783: ELSE
784: select language_code
785: into p_language_code
786: from fnd_languages where nls_language = upper(p_language_name);

Line 786: from fnd_languages where nls_language = upper(p_language_name);

782: from fnd_languages where language_code = l_temp;
783: ELSE
784: select language_code
785: into p_language_code
786: from fnd_languages where nls_language = upper(p_language_name);
787: END IF;
788:
789: RETURN TRUE;
790:

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

1983: END LOOP;
1984:
1985: ELSE
1986:
1987: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP
1988: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
1989: odi_session_id,
1990: Parameter_Name,
1991: Data_Type,

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

5993: 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, web_service_name)
5994: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,l_lang_code_tab(i),NULL,SYSDATE,G_CURRENT_USER_ID, p_webservice_name);
5995: END LOOP;
5996: ELSE
5997: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP
5998: 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, web_service_name)
5999: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,i.language_code,NULL,SYSDATE,G_CURRENT_USER_ID, p_webservice_name);
6000: END LOOP;
6001: END IF;