335: END IF;
336:
337: select count(*)
338: into l_var
339: from HR_ALL_ORGANIZATION_UNITS
340: where organization_id = p_org;
341:
342: IF to_number(l_var) = 0 THEN
343: ITG_MSG.missing_element_value('ORGID', p_org);
914: END IF;
915:
916: select count(*)
917: into l_var
918: from HR_ALL_ORGANIZATION_UNITS
919: where organization_id = p_org;
920:
921: IF to_number(l_var) = 0 THEN
922: ITG_MSG.missing_element_value('ORGID', p_org);