DBA Data[Home] [Help]

APPS.HR_ORG_PRE_DELETE dependencies on PER_EVENTS

Line 352: from per_events x

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;

Line 559: -- Doing check on PER_EVENTS.

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

Line 565: from PER_EVENTS x

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');