242:
243: begin
244: --
245: -- added for 5354277
246: hr_general.g_data_migrator_mode := 'Y';
247: --
248: --validate parent_hierarchy_key
249: validate_parent_key(
250: X_PARENT_HIERARCHY_KEY => X_PARENT_HIERARCHY_KEY
334:
335: begin
336: --
337: -- added for 5354277
338: hr_general.g_data_migrator_mode := 'Y';
339: --
340: select hierarchy_id into l_hierarchy_id
341: from HR_KI_HIERARCHIES
342: where upper(hierarchy_key) = upper(X_HIERARCHY_KEY);