APPS.HR_ORG_PRE_DELETE dependencies on PER_RECRUITMENT_ACTIVITIES

Line 179: -- Do Any rows Exist in PER_RECRUITMENT_ACTIVITIES.

175: null;
176: end;
177: --
178: begin
179: -- Do Any rows Exist in PER_RECRUITMENT_ACTIVITIES.
180: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
181: ,6);
182: select '1'
183: into l_test_func

Line 186: from PER_RECRUITMENT_ACTIVITIES x

182: select '1'
183: into l_test_func
184: from sys.dual
185: where exists ( select 1
186: from PER_RECRUITMENT_ACTIVITIES x
187: where x.business_group_id = p_business_group_id);
188: --
189: if SQL%ROWCOUNT >0 THEN
190: hr_utility.set_message(801,'HR_6568_ORG_RECRUIT_ACTS_EXIST');

Line 320: from per_recruitment_activities x

316: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',13);
317: select '1'
318: into l_test_func
319: from sys.dual where exists ( select 1
320: from per_recruitment_activities x
321: where x.run_by_organization_id = p_organization_id);
322: if SQL%ROWCOUNT >0 THEN
323: hr_utility.set_message(801,'HR_7336_ORG_REC_ACT_EXIST');
324: hr_utility.raise_error;

Line 638: -- Doing check on PER_RECRUITMENT_ACTIVITIES.

634: null;
635: end;
636: --
637: begin
638: -- Doing check on PER_RECRUITMENT_ACTIVITIES.
639: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',10);
640: select '1'
641: into l_test_func
642: from sys.dual

Line 644: from PER_RECRUITMENT_ACTIVITIES x

640: select '1'
641: into l_test_func
642: from sys.dual
643: where exists ( select 1
644: from PER_RECRUITMENT_ACTIVITIES x
645: where x.RUN_BY_ORGANIZATION_ID = p_organization_id);
646: --
647: if SQL%ROWCOUNT >0 THEN
648: hr_utility.set_message(801,'HR_6723_BG_REC_ACT_EXIST');