313:
314: l_city VARCHAR2(80);
315: /*l_region varchar2(240);
316: UTF8 changes made for commented code and changed from varchar2 to
317: hr_locations_all.region_1%type*/
318: l_region HR_LOCATIONS_ALL.REGION_1%TYPE;
319: l_country_code VARCHAR2(2);
320: x_error_message_code VARCHAR2(240);
321: l_country_name VARCHAR2(2000);
314: l_city VARCHAR2(80);
315: /*l_region varchar2(240);
316: UTF8 changes made for commented code and changed from varchar2 to
317: hr_locations_all.region_1%type*/
318: l_region HR_LOCATIONS_ALL.REGION_1%TYPE;
319: l_country_code VARCHAR2(2);
320: x_error_message_code VARCHAR2(240);
321: l_country_name VARCHAR2(2000);
322:
1027:
1028: --Bug#1947235 Updated by MAansari
1029: -- The following local variables are added
1030: -- l_city VARCHAR2(80);
1031: -- l_region hr_locations_all.region_1%type;
1032: -- l_country_code VARCHAR2(2);
1033: -- x_error_msg_code VARCHAR2(240);
1034: -- l_country_name VARCHAR2(2000);
1035: