DBA Data[Home] [Help]

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on FND_LOOKUP_VALUES

Line 24: FROM fnd_lookup_values

20: -------------------------------------------------------------------------------
21: FUNCTION get_IANA_charset RETURN VARCHAR2 IS
22: CURSOR csr_get_iana_charset IS
23: SELECT tag
24: FROM fnd_lookup_values
25: WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
26: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
27: INSTR(USERENV('LANGUAGE'), '.') + 1)
28: AND language = 'US';

Line 30: lv_iana_charset fnd_lookup_values.tag%type;

26: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
27: INSTR(USERENV('LANGUAGE'), '.') + 1)
28: AND language = 'US';
29:
30: lv_iana_charset fnd_lookup_values.tag%type;
31: BEGIN
32: OPEN csr_get_iana_charset;
33: FETCH csr_get_iana_charset INTO lv_iana_charset;
34: CLOSE csr_get_iana_charset;