60: ,basic_salary_rate
61: ,housing_indemnity_rate
62: ,object_version_number
63: ,currency_code
64: from pqh_fr_global_indices_f
65: where global_index_id = p_global_index_id
66: and p_effective_date
67: between effective_start_date and effective_end_date;
68: --
142: -- Call the corresponding datetrack api
143: --
144: dt_api.find_dt_upd_modes
145: (p_effective_date => p_effective_date
146: ,p_base_table_name => 'pqh_fr_global_indices_f'
147: ,p_base_key_column => 'global_index_id'
148: ,p_base_key_value => p_base_key_value
149: ,p_correction => p_correction
150: ,p_update => p_update
181: -- Call the corresponding datetrack api
182: --
183: dt_api.find_dt_del_modes
184: (p_effective_date => p_effective_date
185: ,p_base_table_name => 'pqh_fr_global_indices_f'
186: ,p_base_key_column => 'global_index_id'
187: ,p_base_key_value => p_base_key_value
188: ,p_zap => p_zap
189: ,p_delete => p_delete
216: -- version number.
217: --
218: l_object_version_number :=
219: dt_api.get_object_version_number
220: (p_base_table_name => 'pqh_fr_global_indices_f'
221: ,p_base_key_column => 'global_index_id'
222: ,p_base_key_value => p_base_key_value
223: );
224: --
227: --
228: -- Update the specified datetrack row setting the effective
229: -- end date to the specified new effective end date.
230: --
231: update pqh_fr_global_indices_f t
232: set t.effective_end_date = p_new_effective_end_date
233: , t.object_version_number = l_object_version_number
234: where t.global_index_id = p_base_key_value
235: and p_effective_date
272: ,basic_salary_rate
273: ,housing_indemnity_rate
274: ,object_version_number
275: ,currency_code
276: from pqh_fr_global_indices_f
277: where global_index_id = p_global_index_id
278: and p_effective_date
279: between effective_start_date and effective_end_date
280: for update nowait;
358: --
359: dt_api.validate_dt_mode
360: (p_effective_date => p_effective_date
361: ,p_datetrack_mode => p_datetrack_mode
362: ,p_base_table_name => 'pqh_fr_global_indices_f'
363: ,p_base_key_column => 'global_index_id'
364: ,p_base_key_value => p_global_index_id
365: ,p_enforce_foreign_locking => true
366: ,p_validation_start_date => l_validation_start_date
393: -- The object is locked therefore we need to supply a meaningful
394: -- error message.
395: --
396: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
397: fnd_message.set_token('TABLE_NAME', 'pqh_fr_global_indices_f');
398: fnd_message.raise_error;
399: End lck;
400: --
401: -- ----------------------------------------------------------------------------