FUNCTION: APPS.IEC_GET_TRANSLATED_FND_LOOKUP

Source

1 FUNCTION      iec_get_translated_fnd_lookup
2 				   ( P_LOOKUP_CODE IN VARCHAR2
3 				   , P_LOOKUP_TYPE IN VARCHAR2
4 				   , P_LANGUAGE IN VARCHAR2
5 				   )
6 				RETURN VARCHAR2
7 				IS
8 					l_translated_string VARCHAR2(500);
9 				BEGIN
10 
11 				SELECT MEANING
12 				INTO l_translated_string
13 				FROM  FND_LOOKUP_VALUES
14 				WHERE LOOKUP_CODE	= P_LOOKUP_CODE
15 		  		AND  LOOKUP_TYPE 	= P_LOOKUP_TYPE
16 		  		AND  LANGUAGE		= P_LANGUAGE
17 				AND  ROWNUM 		= 1;
18 
19 				RETURN l_translated_string;
20 
21 				END iec_get_translated_fnd_lookup;