APPS.HR_ORG_PRE_DELETE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 199: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.

195: null;
196: end;
197: --
198: begin
199: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
200: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
201: ,7);
202: select '1'
203: into l_test_func

Line 206: from PER_ORG_STRUCTURE_ELEMENTS x

202: select '1'
203: into l_test_func
204: from sys.dual
205: where exists ( select 1
206: from PER_ORG_STRUCTURE_ELEMENTS x
207: where x.business_group_id = p_business_group_id);
208: --
209: if SQL%ROWCOUNT >0 THEN
210: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');

Line 245: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.

241: end;
242: --
243: --
244: begin
245: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
246: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',9);
247: select '1'
248: into l_test_func
249: from sys.dual

Line 251: from PER_ORG_STRUCTURE_ELEMENTS x

247: select '1'
248: into l_test_func
249: from sys.dual
250: where exists ( select 1
251: from PER_ORG_STRUCTURE_ELEMENTS x
252: where x.organization_id_child = p_organization_id);
253: --
254: if SQL%ROWCOUNT >0 THEN
255: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');

Line 264: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.

260: null;
261: end;
262: --
263: begin
264: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
265: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',10);
266: select '1'
267: into l_test_func
268: from sys.dual

Line 270: from PER_ORG_STRUCTURE_ELEMENTS x

266: select '1'
267: into l_test_func
268: from sys.dual
269: where exists ( select 1
270: from PER_ORG_STRUCTURE_ELEMENTS x
271: where x.organization_id_parent = p_organization_id);
272: --
273: if SQL%ROWCOUNT >0 THEN
274: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');

Line 578: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.

574: null;
575: end;
576: --
577: begin
578: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
579: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',7);
580: select '1'
581: into l_test_func
582: from sys.dual

Line 584: from PER_ORG_STRUCTURE_ELEMENTS x

580: select '1'
581: into l_test_func
582: from sys.dual
583: where exists ( select 1
584: from PER_ORG_STRUCTURE_ELEMENTS x
585: where x.ORGANIZATION_ID_PARENT = p_organization_id);
586: --
587: if SQL%ROWCOUNT >0 THEN
588: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');

Line 597: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.

593: null;
594: end;
595: --
596: begin
597: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
598: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',8);
599: select '1'
600: into l_test_func
601: from sys.dual

Line 603: from PER_ORG_STRUCTURE_ELEMENTS x

599: select '1'
600: into l_test_func
601: from sys.dual
602: where exists ( select 1
603: from PER_ORG_STRUCTURE_ELEMENTS x
604: where x.ORGANIZATION_ID_CHILD = p_organization_id);
605: --
606: if SQL%ROWCOUNT >0 THEN
607: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');