178:
179: PROCEDURE Defrag_Contig_Assign(p_location_id IN pn_locations_all.location_id%TYPE);
180:
181: PROCEDURE delete_other_assignments_emp (
182: x_person_id IN pn_space_assign_emp.person_id%TYPE,
183: x_emp_assign_start_date IN pn_space_assign_emp.emp_assign_start_date%TYPE,
184: x_emp_space_assign_id IN pn_space_assign_emp.emp_space_assign_id%TYPE,
185: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
186: );
179: PROCEDURE Defrag_Contig_Assign(p_location_id IN pn_locations_all.location_id%TYPE);
180:
181: PROCEDURE delete_other_assignments_emp (
182: x_person_id IN pn_space_assign_emp.person_id%TYPE,
183: x_emp_assign_start_date IN pn_space_assign_emp.emp_assign_start_date%TYPE,
184: x_emp_space_assign_id IN pn_space_assign_emp.emp_space_assign_id%TYPE,
185: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
186: );
187:
180:
181: PROCEDURE delete_other_assignments_emp (
182: x_person_id IN pn_space_assign_emp.person_id%TYPE,
183: x_emp_assign_start_date IN pn_space_assign_emp.emp_assign_start_date%TYPE,
184: x_emp_space_assign_id IN pn_space_assign_emp.emp_space_assign_id%TYPE,
185: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
186: );
187:
188: PROCEDURE delete_other_assignments_cust (