APPS.PAY_XML_GEN_PKG dependencies on FND_LOOKUP_VALUES

Line 16: l_charset fnd_lookup_values.tag%TYPE;

12: l_xml_data CLOB;
13: l_final_xml_data CLOB;
14: l_start_pos INTEGER;
15: l_end_pos INTEGER;
16: l_charset fnd_lookup_values.tag%TYPE;
17: l_header varchar2(500);
18: l_len INTEGER;
19:
20: CURSOR c_dbnlscharset IS

Line 22: FROM fnd_lookup_values

18: l_len INTEGER;
19:
20: CURSOR c_dbnlscharset IS
21: SELECT tag charset
22: FROM fnd_lookup_values
23: WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
24: AND lookup_code = SUBSTR(USERENV('LANGUAGE'), INSTR(USERENV('LANGUAGE'), '.') + 1)
25: AND language = 'US';
26:

Line 90: l_charset fnd_lookup_values.tag%TYPE;

86: l_xml_data BLOB;
87: l_final_xml_data BLOB;
88: l_start_pos INTEGER;
89: l_end_pos INTEGER;
90: l_charset fnd_lookup_values.tag%TYPE;
91: l_header varchar2(500);
92: l_len INTEGER;
93:
94: CURSOR c_dbnlscharset IS

Line 96: FROM fnd_lookup_values

92: l_len INTEGER;
93:
94: CURSOR c_dbnlscharset IS
95: SELECT tag charset
96: FROM fnd_lookup_values
97: WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
98: AND lookup_code = SUBSTR(USERENV('LANGUAGE'), INSTR(USERENV('LANGUAGE'), '.') + 1)
99: AND language = 'US';
100: