182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: -- Call the corresponding datetrack api
185: --
186: dt_api.find_dt_upd_modes
187: (p_effective_date => p_effective_date
188: ,p_base_table_name => 'per_spinal_point_steps_f'
189: ,p_base_key_column => 'step_id'
190: ,p_base_key_value => p_base_key_value
236: Close C_Sel1;
237: --
238: -- Call the corresponding datetrack api
239: --
240: dt_api.find_dt_del_modes
241: (p_effective_date => p_effective_date
242: ,p_base_table_name => 'per_spinal_point_steps_f'
243: ,p_base_key_column => 'step_id'
244: ,p_base_key_value => p_base_key_value
275: -- Because we are updating a row we must get the next object
276: -- version number.
277: --
278: l_object_version_number :=
279: dt_api.get_object_version_number
280: (p_base_table_name => 'per_spinal_point_steps_f'
281: ,p_base_key_column => 'step_id'
282: ,p_base_key_value => p_base_key_value
283: );
435: --
436: -- Validate the datetrack mode mode getting the validation start
437: -- and end dates for the specified datetrack operation.
438: --
439: dt_api.validate_dt_mode
440: (p_effective_date => p_effective_date
441: ,p_datetrack_mode => p_datetrack_mode
442: ,p_base_table_name => 'per_spinal_point_steps_f'
443: ,p_base_key_column => 'step_id'