963: l_subject varchar2(400);
964: l_description varchar2(500);
965: l_data varchar2(32000);
966: l_ignore_time_zone boolean := false;
967: l_time_zone_code fnd_timezones_vl.timezone_code%type;
968: l_loc_description varchar2(240);
969: l_proc varchar2(20) := 'attatchICDoc';
970: l_itemType varchar2(50);
971: cursor getTimezoneCode(c_timezoneNameIn in varchar2) is
969: l_proc varchar2(20) := 'attatchICDoc';
970: l_itemType varchar2(50);
971: cursor getTimezoneCode(c_timezoneNameIn in varchar2) is
972: select timezone_code
973: from fnd_timezones_vl
974: where name = c_timezoneNameIn
975: and rownum < 2;
976: begin
977: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);