[Home] [Help]
152: hr_utility.set_location('Entering:'||l_proc, 5);
153: --
154: -- Call the corresponding datetrack api
155: --
156: dt_api.find_dt_upd_modes_and_dates
157: (p_effective_date => p_effective_date
158: ,p_base_table_name => 'pay_pl_sii_details_f'
159: ,p_base_key_column => 'sii_details_id'
160: ,p_base_key_value => p_base_key_value
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: --
196: -- Call the corresponding datetrack api
197: --
198: dt_api.find_dt_del_modes
199: (p_effective_date => p_effective_date
200: ,p_base_table_name => 'pay_pl_sii_details_f'
201: ,p_base_key_column => 'sii_details_id'
202: ,p_base_key_value => p_base_key_value
230: -- Because we are updating a row we must get the next object
231: -- version number.
232: --
233: l_object_version_number :=
234: dt_api.get_object_version_number
235: (p_base_table_name => 'pay_pl_sii_details_f'
236: ,p_base_key_column => 'sii_details_id'
237: ,p_base_key_value => p_base_key_value
238: );
372: -- b) If the Contract category is 'Normal' and the Assignment is terminated. This is cos for Normal Terminated assignments
373: -- the SII record is stored at the Assignment level.
374: -- c) if the Contract category is "LUMP" or "F_LUMP"
375:
376: dt_api.validate_dt_mode
377: (p_effective_date => p_effective_date
378: ,p_datetrack_mode => p_datetrack_mode
379: ,p_base_table_name => 'pay_pl_sii_details_f'
380: ,p_base_key_column => 'sii_details_id'
391:
392: -- Here we are locking the corresponding Person record if the Contract category is
393: -- "NORMAL" since the SII record for Normal Contracts are stored at the Person level
394:
395: dt_api.validate_dt_mode
396: (p_effective_date => p_effective_date
397: ,p_datetrack_mode => p_datetrack_mode
398: ,p_base_table_name => 'pay_pl_sii_details_f'
399: ,p_base_key_column => 'sii_details_id'