[Home] [Help]
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_ELEMENT_CLASS_USAGES_F_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLASS_USAGES_F') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
50: p_legislation_code varchar2) is
51:
52: Cursor csr_chk_unique_constrnt is
53: select null
54: from pay_element_class_usages_f
55: where classification_id = p_classification_id
56: and run_type_id = p_run_type_id
57: and nvl(business_group_id, -1)= nvl(p_business_group_id, -1)
58: and nvl(legislation_code, '-1')= nvl(p_legislation_code, '-1')
94: ,classification_id
95: ,business_group_id
96: ,legislation_code
97: ,object_version_number
98: from pay_element_class_usages_f
99: where element_class_usage_id = p_element_class_usage_id
100: and p_effective_date
101: between effective_start_date and effective_end_date;
102: --
170: -- Call the corresponding datetrack api
171: --
172: dt_api.find_dt_upd_modes
173: (p_effective_date => p_effective_date
174: ,p_base_table_name => 'pay_element_class_usages_f'
175: ,p_base_key_column => 'element_class_usage_id'
176: ,p_base_key_value => p_base_key_value
177: ,p_correction => p_correction
178: ,p_update => p_update
204: -- Call the corresponding datetrack api
205: --
206: dt_api.find_dt_del_modes
207: (p_effective_date => p_effective_date
208: ,p_base_table_name => 'pay_element_class_usages_f'
209: ,p_base_key_column => 'element_class_usage_id'
210: ,p_base_key_value => p_base_key_value
211: ,p_zap => p_zap
212: ,p_delete => p_delete
239: -- version number.
240: --
241: l_object_version_number :=
242: dt_api.get_object_version_number
243: (p_base_table_name => 'pay_element_class_usages_f'
244: ,p_base_key_column => 'element_class_usage_id'
245: ,p_base_key_value => p_base_key_value
246: );
247: --
250: --
251: -- Update the specified datetrack row setting the effective
252: -- end date to the specified new effective end date.
253: --
254: update pay_element_class_usages_f t
255: set t.effective_end_date = p_new_effective_end_date
256: , t.object_version_number = l_object_version_number
257: where t.element_class_usage_id = p_base_key_value
258: and p_effective_date
293: ,classification_id
294: ,business_group_id
295: ,legislation_code
296: ,object_version_number
297: from pay_element_class_usages_f
298: where element_class_usage_id = p_element_class_usage_id
299: and p_effective_date
300: between effective_start_date and effective_end_date
301: for update nowait;
356: --
357: dt_api.validate_dt_mode
358: (p_effective_date => p_effective_date
359: ,p_datetrack_mode => p_datetrack_mode
360: ,p_base_table_name => 'pay_element_class_usages_f'
361: ,p_base_key_column => 'element_class_usage_id'
362: ,p_base_key_value => p_element_class_usage_id
363: ,p_enforce_foreign_locking => true
364: ,p_validation_start_date => l_validation_start_date
391: -- The object is locked therefore we need to supply a meaningful
392: -- error message.
393: --
394: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
395: fnd_message.set_token('TABLE_NAME', 'pay_element_class_usages_f');
396: fnd_message.raise_error;
397: End lck;
398: --
399: -- ----------------------------------------------------------------------------