DBA Data[Home] [Help]

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on FND_LOOKUP_VALUES

Line 20: FROM fnd_lookup_values

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

Line 26: lv_iana_charset fnd_lookup_values.tag%type;

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