[Home] [Help]
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: -- Call the corresponding datetrack api
209: --
210: dt_api.find_dt_upd_modes
211: (p_effective_date => p_effective_date
212: ,p_base_table_name => 'per_spinal_point_placements_f'
213: ,p_base_key_column => 'placement_id'
214: ,p_base_key_value => p_base_key_value
276: Close C_Sel1;
277: --
278: -- Call the corresponding datetrack api
279: --
280: dt_api.find_dt_del_modes
281: (p_effective_date => p_effective_date
282: ,p_base_table_name => 'per_spinal_point_placements_f'
283: ,p_base_key_column => 'placement_id'
284: ,p_base_key_value => p_base_key_value
318: -- Because we are updating a row we must get the next object
319: -- version number.
320: --
321: l_object_version_number :=
322: dt_api.get_object_version_number
323: (p_base_table_name => 'per_spinal_point_placements_f'
324: ,p_base_key_column => 'placement_id'
325: ,p_base_key_value => p_base_key_value
326: );
506: else
507: l_enforce_foreign_locking := true;
508: end if;
509:
510: dt_api.validate_dt_mode
511: (p_effective_date => p_effective_date
512: ,p_datetrack_mode => p_datetrack_mode
513: ,p_base_table_name => 'per_spinal_point_placements_f'
514: ,p_base_key_column => 'placement_id'
525: );
526: --
527: -- Always perform locking for transaction data parent tables
528: --
529: dt_api.validate_dt_mode
530: (p_effective_date => p_effective_date
531: ,p_datetrack_mode => p_datetrack_mode
532: ,p_base_table_name => 'per_spinal_point_placements_f'
533: ,p_base_key_column => 'placement_id'
558: End If;
559: --
560: -- Set the validation start and end date OUT arguments
561: -- taking the most restrictive replies from the two calls
562: -- to dt_api.validate_dt_mode. i.e. The latest VSD and the
563: -- earliest VED.
564: --
565: -- bug 3158554 starts here.
566: --