47: ssp_periods_of_incapacity
48: 70.10 07-JUL-93 SZWILLIA Moved delete of PER_VACANCIES which
49: was in conflict with assignments.
50: Now in delete_per_misc. Also, moved
51: PER_REQUISITIONS.
52: 70.10 07-JUL-93 mwcallag Delete all database items for a given
53: business group, procedure
54: 'delete_database_items' added. Element
55: type and input value database item
746: WHERE business_group_id = c_business_group_id);
747: --
748: cursor csr_get_req
749: (c_business_group_id
750: PER_REQUISITIONS.business_group_id%TYPE)
751: is
752: SELECT null
753: FROM sys.dual
754: WHERE exists(select null
751: is
752: SELECT null
753: FROM sys.dual
754: WHERE exists(select null
755: FROM PER_REQUISITIONS
756: WHERE business_group_id = c_business_group_id);
757: --
758: cursor csr_get_bud
759: (c_business_group_id
1063: DELETE FROM per_vacancies vac
1064: WHERE vac.business_group_id = p_business_group_id;
1065: hr_utility.set_location(l_proc,310);
1066: --
1067: DELETE FROM per_requisitions pr
1068: WHERE pr.business_group_id = p_business_group_id;
1069: hr_utility.set_location(l_proc,320);
1070: --
1071: end if;