Create Step Record with API
Good Afternoon ~
I have a need to automate the creation of a step record for a new employee.
I am using the following code but not sure how I will derive at the step id if this the first one for an assignment? I have done many of these for an update but never for a create. Guidance is much appreciated..
BEGIN
hr_sp_placement_api.create_spp
(
p_effective_date => v_effective_date --TO_DATE('05-FEB-2018', 'DD-MON-YYYY')
,p_business_group_id => 2
,p_assignment_id => l_assignment_id
,p_step_id => v_step_id
,p_reason => 'IA' --'Initial Appointment'