APPS.PAY_ISB_SHD dependencies on PAY_IE_SOCIAL_BENEFITS_F

Line 21: If (p_constraint_name = 'PAY_IE_SOCIAL_BENEFITS_F_PK') Then

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;

Line 65: from pay_ie_social_benefits_f

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: --

Line 141: ,p_base_table_name => 'pay_ie_social_benefits_f'

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

Line 172: from pay_ie_social_benefits_f t

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: --

Line 195: ,p_base_table_name => 'pay_ie_social_benefits_f'

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'

Line 233: (p_base_table_name => 'pay_ie_social_benefits_f'

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: --

Line 244: update pay_ie_social_benefits_f t

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

Line 296: from pay_ie_social_benefits_f

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;

Line 359: ,p_base_table_name => 'pay_ie_social_benefits_f'

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'

Line 397: fnd_message.set_token('TABLE_NAME', 'pay_ie_social_benefits_f');

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: -- ----------------------------------------------------------------------------