273:
274: begin
275:
276: select 'Y' into l_exists
277: from fnd_user where user_id = p_Item_Orderability_Import_Rec.created_by
278: and end_date is NULL;
279:
280: Exception
281: when others then
291:
292: IF p_Item_Orderability_Import_Rec.last_updated_by is NULL then
293: begin
294: select 'Y' into l_exists
295: from fnd_user where user_id = p_Item_Orderability_Import_Rec.last_updated_by
296: and end_date is NULL;
297:
298: Exception
299: when others then