DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on FND_LOOKUP_VALUES

Line 267: l_iana_charset fnd_lookup_values.tag%type;

263: /*End Bug#10359114 */
264: l_output_location varchar2(100);
265: EOL varchar2(10);
266:
267: l_iana_charset fnd_lookup_values.tag%type;
268: l_xml_version varchar2(100);
269:
270: p_xml_blob BLOB;
271: cursor c_get_params is

Line 415: l_iana_charset fnd_lookup_values.tag%type;

411: l_trailer_xml VARCHAR2(32000);
412: l_pa_id number;
413: l_temp_blob BLOB;
414: EOL varchar2(10);
415: l_iana_charset fnd_lookup_values.tag%type;
416: l_xml_version varchar2(100);
417: l_is_temp_final_xml VARCHAR2(2);
418: lv_negative_bal_flag VARCHAR2(5);
419: l_err_msg hr_lookups.meaning%TYPE;

Line 1574: from fnd_lookup_values

1570:
1571: function get_IANA_charset return VARCHAR2 is
1572: cursor csr_get_iana_charset is
1573: select tag
1574: from fnd_lookup_values
1575: where lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
1576: and lookup_code = SUBSTR(USERENV('LANGUAGE'),
1577: INSTR(USERENV('LANGUAGE'), '.') + 1)
1578: and language = 'US';

Line 1580: lv_iana_charset fnd_lookup_values.tag%type;

1576: and lookup_code = SUBSTR(USERENV('LANGUAGE'),
1577: INSTR(USERENV('LANGUAGE'), '.') + 1)
1578: and language = 'US';
1579:
1580: lv_iana_charset fnd_lookup_values.tag%type;
1581:
1582: begin
1583: open csr_get_iana_charset;
1584: fetch csr_get_iana_charset into lv_iana_charset;