APPS.PAY_IPD_SHD dependencies on PAY_IE_PAYE_DETAILS_F

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_IE_PAYE_DETAILS_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 106: from pay_ie_paye_details_f

102: ,usc_rate_5
103: ,usc_tax_basis
104: ,usc_info_source
105: --13359423
106: from pay_ie_paye_details_f
107: where paye_details_id = p_paye_details_id
108: and p_effective_date
109: between effective_start_date and effective_end_date;
110: --

Line 182: ,p_base_table_name => 'pay_ie_paye_details_f'

178: -- Call the corresponding datetrack api
179: --
180: dt_api.find_dt_upd_modes
181: (p_effective_date => p_effective_date
182: ,p_base_table_name => 'pay_ie_paye_details_f'
183: ,p_base_key_column => 'paye_details_id'
184: ,p_base_key_value => p_base_key_value
185: ,p_correction => p_correction
186: ,p_update => p_update

Line 213: from pay_ie_paye_details_f t

209: --
210: Cursor C_Sel1 Is
211: select
212: t.assignment_id
213: from pay_ie_paye_details_f t
214: where t.paye_details_id = p_base_key_value
215: and p_effective_date
216: between t.effective_start_date and t.effective_end_date;
217: --

Line 236: ,p_base_table_name => 'pay_ie_paye_details_f'

232: -- Call the corresponding datetrack api
233: --
234: dt_api.find_dt_del_modes
235: (p_effective_date => p_effective_date
236: ,p_base_table_name => 'pay_ie_paye_details_f'
237: ,p_base_key_column => 'paye_details_id'
238: ,p_base_key_value => p_base_key_value
239: ,p_parent_table_name1 => 'per_all_assignments_f'
240: ,p_parent_key_column1 => 'assignment_id'

Line 274: (p_base_table_name => 'pay_ie_paye_details_f'

270: -- version number.
271: --
272: l_object_version_number :=
273: dt_api.get_object_version_number
274: (p_base_table_name => 'pay_ie_paye_details_f'
275: ,p_base_key_column => 'paye_details_id'
276: ,p_base_key_value => p_base_key_value
277: );
278: --

Line 285: update pay_ie_paye_details_f t

281: --
282: -- Update the specified datetrack row setting the effective
283: -- end date to the specified new effective end date.
284: --
285: update pay_ie_paye_details_f t
286: set t.effective_end_date = p_new_effective_end_date
287: , t.object_version_number = l_object_version_number
288: where t.paye_details_id = p_base_key_value
289: and p_effective_date

Line 378: from pay_ie_paye_details_f

374: ,usc_rate_5
375: ,usc_tax_basis
376: ,usc_info_source
377: --13359423
378: from pay_ie_paye_details_f
379: where paye_details_id = p_paye_details_id
380: and p_effective_date
381: between effective_start_date and effective_end_date
382: for update nowait;

Line 441: ,p_base_table_name => 'pay_ie_paye_details_f'

437: --
438: dt_api.validate_dt_mode
439: (p_effective_date => p_effective_date
440: ,p_datetrack_mode => p_datetrack_mode
441: ,p_base_table_name => 'pay_ie_paye_details_f'
442: ,p_base_key_column => 'paye_details_id'
443: ,p_base_key_value => p_paye_details_id
444: ,p_parent_table_name1 => 'per_all_assignments_f'
445: ,p_parent_key_column1 => 'assignment_id'

Line 479: fnd_message.set_token('TABLE_NAME', 'pay_ie_paye_details_f');

475: -- The object is locked therefore we need to supply a meaningful
476: -- error message.
477: --
478: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
479: fnd_message.set_token('TABLE_NAME', 'pay_ie_paye_details_f');
480: fnd_message.raise_error;
481: End lck;
482: --
483: -- ----------------------------------------------------------------------------