97: if icx_sec.validateSession then
98:
99: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
100:
101: fnd_profile.get_specific(name_z => 'ICX_LOV_TYPE',
102: user_id_z => l_user_id,
103: val_z => l_lov_type,
104: defined_z => l_profile_defined);
105:
293: end if;
294:
295: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
296:
297: fnd_profile.get_specific(name_z => 'ICX_LOV_TYPE',
298: user_id_z => l_user_id,
299: val_z => l_lov_type,
300: defined_z => l_profile_defined);
301:
809: l_matchcase_lov varchar2(10);
810:
811: begin
812:
813: l_matchcase_lov := fnd_profile.value('ICX_MATCHCASE_LOV');
814:
815: if l_matchcase_lov is null
816: then
817: l_matchcase_lov := 'Checked';