144: hr_utility.set_location('Entering:'||l_proc, 5);
145: --
146: -- Call the corresponding datetrack api
147: --
148: dt_api.find_dt_upd_modes
149: (p_effective_date => p_effective_date
150: ,p_base_table_name => 'pqh_documents_f'
151: ,p_base_key_column => 'document_id'
152: ,p_base_key_value => p_base_key_value
178: hr_utility.set_location('Entering:'||l_proc, 5);
179: --
180: -- Call the corresponding datetrack api
181: --
182: dt_api.find_dt_del_modes
183: (p_effective_date => p_effective_date
184: ,p_base_table_name => 'pqh_documents_f'
185: ,p_base_key_column => 'document_id'
186: ,p_base_key_value => p_base_key_value
214: -- Because we are updating a row we must get the next object
215: -- version number.
216: --
217: l_object_version_number :=
218: dt_api.get_object_version_number
219: (p_base_table_name => 'pqh_documents_f'
220: ,p_base_key_column => 'document_id'
221: ,p_base_key_value => p_base_key_value
222: );
342: --
343: -- Validate the datetrack mode mode getting the validation start
344: -- and end dates for the specified datetrack operation.
345: --
346: dt_api.validate_dt_mode
347: (p_effective_date => p_effective_date
348: ,p_datetrack_mode => p_datetrack_mode
349: ,p_base_table_name => 'pqh_documents_f'
350: ,p_base_key_column => 'document_id'