138: ,ee_age_threshold -- added for ABP TAR fixes
139: ,er_age_threshold -- added for ABP TAR fixes
140: ,ee_age_contribution -- added for ABP TAR fixes
141: ,er_age_contribution -- added for ABP TAR fixes
142: from pqp_pension_types_f
143: where pension_type_id = p_pension_type_id
144: and p_effective_date
145: between effective_start_date and effective_end_date;
146: --
213: -- Call the corresponding datetrack api
214: --
215: dt_api.find_dt_upd_modes
216: (p_effective_date => p_effective_date
217: ,p_base_table_name => 'pqp_pension_types_f'
218: ,p_base_key_column => 'pension_type_id'
219: ,p_base_key_value => p_base_key_value
220: ,p_correction => p_correction
221: ,p_update => p_update
247: -- Call the corresponding datetrack api
248: --
249: dt_api.find_dt_del_modes
250: (p_effective_date => p_effective_date
251: ,p_base_table_name => 'pqp_pension_types_f'
252: ,p_base_key_column => 'pension_type_id'
253: ,p_base_key_value => p_base_key_value
254: ,p_zap => p_zap
255: ,p_delete => p_delete
282: -- version number.
283: --
284: l_object_version_number :=
285: dt_api.get_object_version_number
286: (p_base_table_name => 'pqp_pension_types_f'
287: ,p_base_key_column => 'pension_type_id'
288: ,p_base_key_value => p_base_key_value
289: );
290: --
293: --
294: -- Update the specified datetrack row setting the effective
295: -- end date to the specified new effective end date.
296: --
297: update pqp_pension_types_f t
298: set t.effective_end_date = p_new_effective_end_date
299: , t.object_version_number = l_object_version_number
300: where t.pension_type_id = p_base_key_value
301: and p_effective_date
422: ,ee_age_threshold -- added for ABP TAR fixes
423: ,er_age_threshold -- added for ABP TAR fixes
424: ,ee_age_contribution -- added for ABP TAR fixes
425: ,er_age_contribution -- added for ABP TAR fixes
426: from pqp_pension_types_f
427: where pension_type_id = p_pension_type_id
428: and p_effective_date
429: between effective_start_date and effective_end_date
430: for update nowait;
485: --
486: dt_api.validate_dt_mode
487: (p_effective_date => p_effective_date
488: ,p_datetrack_mode => p_datetrack_mode
489: ,p_base_table_name => 'pqp_pension_types_f'
490: ,p_base_key_column => 'pension_type_id'
491: ,p_base_key_value => p_pension_type_id
492: ,p_enforce_foreign_locking => true
493: ,p_validation_start_date => l_validation_start_date
520: -- The object is locked therefore we need to supply a meaningful
521: -- error message.
522: --
523: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
524: fnd_message.set_token('TABLE_NAME', 'pqp_pension_types_f');
525: fnd_message.raise_error;
526: End lck;
527: --
528: -- ----------------------------------------------------------------------------