APPS.HR_ORG_PRE_DELETE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 76

		hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
                                       ,1);

Line: 78

		select '1'
		into l_test_func
		from sys.dual
		where exists ( select 1
		from PER_PEOPLE_F x
		where x.business_group_id = p_business_group_id);

Line: 96

		hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
                                       ,2);

Line: 98

		select '1'
		into l_test_func
		from sys.dual
		where exists ( select 1
		from HR_ORGANIZATION_UNITS x
		where x.business_group_id = p_business_group_id
      and   x.organization_id  <> p_business_group_id);

Line: 117

		hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
                                       ,3);

Line: 119

		select '1'
		into l_test_func
		from sys.dual
		where exists ( select 1
		from PER_JOBS x
		where x.business_group_id = p_business_group_id);

Line: 140

		hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
                                       ,4);

Line: 142

		select '1'
		into l_test_func
		from sys.dual
		where exists ( select 1
		from HR_ALL_POSITIONS_F x
		where x.business_group_id = p_business_group_id);

Line: 160

		hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
                                       ,5);

Line: 162

		select '1'
		into l_test_func
		from sys.dual
		where exists ( select 1
		from PER_BUDGET_VALUES x
		where x.business_group_id = p_business_group_id);

Line: 180

		hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
                                       ,6);

Line: 182

		select '1'
		into l_test_func
		from sys.dual
		where exists ( select 1
		from PER_RECRUITMENT_ACTIVITIES x
		where x.business_group_id = p_business_group_id);

Line: 200

		hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
                                       ,7);

Line: 202

		select '1'
		into l_test_func
		from sys.dual
		where exists ( select 1
		from PER_ORG_STRUCTURE_ELEMENTS x
		where x.business_group_id = p_business_group_id);

Line: 226

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',8);

Line: 227

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from HR_ALL_POSITIONS_F x
where x.organization_id = p_organization_id);

Line: 246

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',9);

Line: 247

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_ORG_STRUCTURE_ELEMENTS x
where x.organization_id_child = p_organization_id);

Line: 265

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',10);

Line: 266

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_ORG_STRUCTURE_ELEMENTS x
where x.organization_id_parent = p_organization_id);

Line: 283

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',11);

Line: 284

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from per_assignments_f x
        where x.source_organization_id = p_organization_id);

Line: 300

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',12);

Line: 301

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from per_assignments_f x
        where x.organization_id = p_organization_id);

Line: 316

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',13);

Line: 317

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from per_recruitment_activities x
        where x.run_by_organization_id = p_organization_id);

Line: 332

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',14);

Line: 333

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from per_vacancies x
        where x.organization_id = p_organization_id);

Line: 348

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',15);

Line: 349

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from per_events x
        where x.organization_run_by_id = p_organization_id);

Line: 364

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',16);

Line: 365

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from pay_element_links_f x
        where x.organization_id = p_organization_id);

Line: 380

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',16);

Line: 381

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from pay_payrolls_f x
        where x.organization_id = p_organization_id);

Line: 396

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',17);

Line: 397

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from pay_wc_funds x
        where x.carrier_id = p_organization_id);

Line: 412

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',18);

Line: 413

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from per_budget_elements x
        where x.organization_id = p_organization_id);

Line: 428

hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',20);

Line: 429

  select '1'
  into l_test_func
  from sys.dual   where exists ( select 1
        from per_security_profiles x
        where x.organization_id = p_organization_id);

Line: 455

    p_organization_id : Id of Organization to be updated to business group.
*/
-- Storage Variable.
l_test_func varchar2(60);

Line: 465

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',1);

Line: 466

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PAY_ELEMENT_LINKS_F x
where x.ORGANIZATION_ID = p_organization_id);

Line: 484

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',2);

Line: 485

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PAY_PAYROLLS_F x
where x.ORGANIZATION_ID = p_organization_id);

Line: 503

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',3);

Line: 504

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_ASSIGNMENTS_F x
where x.SOURCE_ORGANIZATION_ID = p_organization_id);

Line: 522

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',4);

Line: 523

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_ASSIGNMENTS_F x
where x.ORGANIZATION_ID = p_organization_id);

Line: 541

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',5);

Line: 542

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_BUDGET_ELEMENTS x
where x.ORGANIZATION_ID = p_organization_id);

Line: 560

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',6);

Line: 561

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_EVENTS x
where x.ORGANIZATION_RUN_BY_ID = p_organization_id);

Line: 579

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',7);

Line: 580

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_ORG_STRUCTURE_ELEMENTS x
where x.ORGANIZATION_ID_PARENT = p_organization_id);

Line: 598

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',8);

Line: 599

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_ORG_STRUCTURE_ELEMENTS x
where x.ORGANIZATION_ID_CHILD = p_organization_id);

Line: 620

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',9);

Line: 621

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from HR_ALL_POSITIONS_F x
where x.ORGANIZATION_ID = p_organization_id);

Line: 639

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',10);

Line: 640

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_RECRUITMENT_ACTIVITIES x
where x.RUN_BY_ORGANIZATION_ID = p_organization_id);

Line: 658

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',11);

Line: 659

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_SECURITY_PROFILES x
where x.ORGANIZATION_ID = p_organization_id);

Line: 677

hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',12);

Line: 678

select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_VACANCIES x
where x.ORGANIZATION_ID = p_organization_id);