276: );
277:
278:
279: PROCEDURE get_assignment_info (
280: p_bus_group_id IN per_assignments_f.business_group_id%TYPE
281: DEFAULT NULL,
282: p_id_type IN VARCHAR2,
283: p_id IN VARCHAR2,
284: p_effective_date IN DATE,
281: DEFAULT NULL,
282: p_id_type IN VARCHAR2,
283: p_id IN VARCHAR2,
284: p_effective_date IN DATE,
285: p_assg_id OUT NOCOPY per_assignments_f.assignment_id%TYPE,
286: p_assg_nr OUT NOCOPY per_assignments_f.assignment_number%TYPE,
287: p_start_date OUT NOCOPY per_periods_of_service.date_start%TYPE,
288: p_final_process_date OUT NOCOPY per_periods_of_service.final_process_date%TYPE
289: );
282: p_id_type IN VARCHAR2,
283: p_id IN VARCHAR2,
284: p_effective_date IN DATE,
285: p_assg_id OUT NOCOPY per_assignments_f.assignment_id%TYPE,
286: p_assg_nr OUT NOCOPY per_assignments_f.assignment_number%TYPE,
287: p_start_date OUT NOCOPY per_periods_of_service.date_start%TYPE,
288: p_final_process_date OUT NOCOPY per_periods_of_service.final_process_date%TYPE
289: );
290: