17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_IE_SOCIAL_BENEFITS_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;
61: ,request_id
62: ,program_application_id
63: ,program_id
64: ,program_update_date
65: from pay_ie_social_benefits_f
66: where social_benefit_id = p_social_benefit_id
67: and p_effective_date
68: between effective_start_date and effective_end_date;
69: --
137: -- Call the corresponding datetrack api
138: --
139: dt_api.find_dt_upd_modes
140: (p_effective_date => p_effective_date
141: ,p_base_table_name => 'pay_ie_social_benefits_f'
142: ,p_base_key_column => 'social_benefit_id'
143: ,p_base_key_value => p_base_key_value
144: ,p_correction => p_correction
145: ,p_update => p_update
168: --
169: Cursor C_Sel1 Is
170: select
171: t.assignment_id
172: from pay_ie_social_benefits_f t
173: where t.social_benefit_id = p_base_key_value
174: and p_effective_date
175: between t.effective_start_date and t.effective_end_date;
176: --
191: -- Call the corresponding datetrack api
192: --
193: dt_api.find_dt_del_modes
194: (p_effective_date => p_effective_date
195: ,p_base_table_name => 'pay_ie_social_benefits_f'
196: ,p_base_key_column => 'social_benefit_id'
197: ,p_base_key_value => p_base_key_value
198: ,p_parent_table_name1 => 'per_all_assignments_f'
199: ,p_parent_key_column1 => 'assignment_id'
229: -- version number.
230: --
231: l_object_version_number :=
232: dt_api.get_object_version_number
233: (p_base_table_name => 'pay_ie_social_benefits_f'
234: ,p_base_key_column => 'social_benefit_id'
235: ,p_base_key_value => p_base_key_value
236: );
237: --
240: --
241: -- Update the specified datetrack row setting the effective
242: -- end date to the specified new effective end date.
243: --
244: update pay_ie_social_benefits_f t
245: set t.effective_end_date = p_new_effective_end_date
246: , t.object_version_number = l_object_version_number
247: where t.social_benefit_id = p_base_key_value
248: and p_effective_date
292: ,request_id
293: ,program_application_id
294: ,program_id
295: ,program_update_date
296: from pay_ie_social_benefits_f
297: where social_benefit_id = p_social_benefit_id
298: and p_effective_date
299: between effective_start_date and effective_end_date
300: for update nowait;
355: --
356: dt_api.validate_dt_mode
357: (p_effective_date => p_effective_date
358: ,p_datetrack_mode => p_datetrack_mode
359: ,p_base_table_name => 'pay_ie_social_benefits_f'
360: ,p_base_key_column => 'social_benefit_id'
361: ,p_base_key_value => p_social_benefit_id
362: ,p_parent_table_name1 => 'per_all_assignments_f'
363: ,p_parent_key_column1 => 'assignment_id'
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', 'pay_ie_social_benefits_f');
398: fnd_message.raise_error;
399: End lck;
400: --
401: -- ----------------------------------------------------------------------------