348: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',15);
349: select '1'
350: into l_test_func
351: from sys.dual where exists ( select 1
352: from per_events x
353: where x.organization_run_by_id = p_organization_id);
354: if SQL%ROWCOUNT >0 THEN
355: hr_utility.set_message(801,'HR_7334_ORG_EVENTS_EXIST');
356: hr_utility.raise_error;
555: null;
556: end;
557: --
558: begin
559: -- Doing check on PER_EVENTS.
560: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',6);
561: select '1'
562: into l_test_func
563: from sys.dual
561: select '1'
562: into l_test_func
563: from sys.dual
564: where exists ( select 1
565: from PER_EVENTS x
566: where x.ORGANIZATION_RUN_BY_ID = p_organization_id);
567: --
568: if SQL%ROWCOUNT >0 THEN
569: hr_utility.set_message(801,'HR_6721_BG_EVENTS_EXIST');