214: --
215: --
216: -- Call the corresponding datetrack api
217: --
218: -- dt_api.find_dt_del_modes
219: -- (p_effective_date => p_effective_date,
220: -- p_base_table_name => 'ben_pl_bnf_f',
221: -- p_base_key_column => 'pl_bnf_id',
222: -- p_base_key_value => p_base_key_value,
237: Close C_Sel1;
238: --
239: -- Call the corresponding datetrack api
240: --
241: dt_api.find_dt_del_modes
242: (p_effective_date => p_effective_date,
243: p_base_table_name => 'ben_pl_bnf_f',
244: p_base_key_column => 'pl_bnf_id',
245: p_base_key_value => p_base_key_value,
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Call the corresponding datetrack api
275: --
276: dt_api.find_dt_upd_modes
277: (p_effective_date => p_effective_date,
278: p_base_table_name => 'ben_pl_bnf_f',
279: p_base_key_column => 'pl_bnf_id',
280: p_base_key_value => p_base_key_value,
306: -- Because we are updating a row we must get the next object
307: -- version number.
308: --
309: l_object_version_number :=
310: dt_api.get_object_version_number
311: (p_base_table_name => 'ben_pl_bnf_f',
312: p_base_key_column => 'pl_bnf_id',
313: p_base_key_value => p_base_key_value);
314: --
464: --
465: -- Validate the datetrack mode mode getting the validation start
466: -- and end dates for the specified datetrack operation.
467: --
468: -- dt_api.validate_dt_mode
469: -- (p_effective_date => p_effective_date,
470: -- p_datetrack_mode => p_datetrack_mode,
471: -- p_base_table_name => 'ben_pl_bnf_f',
472: -- p_base_key_column => 'pl_bnf_id',
478: -- p_validation_end_date => l_validation_end_date);
479: hr_utility.set_location(' p_datetrack_mode '||p_datetrack_mode , 122);
480: hr_utility.set_location(' p_effective_date '||p_effective_date , 122);
481: --
482: dt_api.validate_dt_mode
483: (p_effective_date => p_effective_date,
484: p_datetrack_mode => p_datetrack_mode,
485: p_base_table_name => 'ben_pl_bnf_f',
486: p_base_key_column => 'pl_bnf_id',