APPS.PAY_SID_SHD dependencies on PAY_IE_PRSI_DETAILS_F

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

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

64: ,program_application_id
65: ,program_id
66: ,program_update_date
67: ,community_flag
68: from pay_ie_prsi_details_f
69: where prsi_details_id = p_prsi_details_id
70: and p_effective_date
71: between effective_start_date and effective_end_date;
72: --

Line 144: ,p_base_table_name => 'pay_ie_prsi_details_f'

140: -- Call the corresponding datetrack api
141: --
142: dt_api.find_dt_upd_modes
143: (p_effective_date => p_effective_date
144: ,p_base_table_name => 'pay_ie_prsi_details_f'
145: ,p_base_key_column => 'prsi_details_id'
146: ,p_base_key_value => p_base_key_value
147: ,p_correction => p_correction
148: ,p_update => p_update

Line 175: from pay_ie_prsi_details_f t

171: --
172: Cursor C_Sel1 Is
173: select
174: t.assignment_id
175: from pay_ie_prsi_details_f t
176: where t.prsi_details_id = p_base_key_value
177: and p_effective_date
178: between t.effective_start_date and t.effective_end_date;
179: --

Line 198: ,p_base_table_name => 'pay_ie_prsi_details_f'

194: -- Call the corresponding datetrack api
195: --
196: dt_api.find_dt_del_modes
197: (p_effective_date => p_effective_date
198: ,p_base_table_name => 'pay_ie_prsi_details_f'
199: ,p_base_key_column => 'prsi_details_id'
200: ,p_base_key_value => p_base_key_value
201: ,p_parent_table_name1 => 'per_all_assignments_f'
202: ,p_parent_key_column1 => 'assignment_id'

Line 236: (p_base_table_name => 'pay_ie_prsi_details_f'

232: -- version number.
233: --
234: l_object_version_number :=
235: dt_api.get_object_version_number
236: (p_base_table_name => 'pay_ie_prsi_details_f'
237: ,p_base_key_column => 'prsi_details_id'
238: ,p_base_key_value => p_base_key_value
239: );
240: --

Line 247: update pay_ie_prsi_details_f t

243: --
244: -- Update the specified datetrack row setting the effective
245: -- end date to the specified new effective end date.
246: --
247: update pay_ie_prsi_details_f t
248: set t.effective_end_date = p_new_effective_end_date
249: , t.object_version_number = l_object_version_number
250: where t.prsi_details_id = p_base_key_value
251: and p_effective_date

Line 302: from pay_ie_prsi_details_f

298: ,program_application_id
299: ,program_id
300: ,program_update_date
301: ,community_flag
302: from pay_ie_prsi_details_f
303: where prsi_details_id = p_prsi_details_id
304: and p_effective_date
305: between effective_start_date and effective_end_date
306: for update nowait;

Line 365: ,p_base_table_name => 'pay_ie_prsi_details_f'

361: --
362: dt_api.validate_dt_mode
363: (p_effective_date => p_effective_date
364: ,p_datetrack_mode => p_datetrack_mode
365: ,p_base_table_name => 'pay_ie_prsi_details_f'
366: ,p_base_key_column => 'prsi_details_id'
367: ,p_base_key_value => p_prsi_details_id
368: ,p_parent_table_name1 => 'per_all_assignments_f'
369: ,p_parent_key_column1 => 'assignment_id'

Line 403: fnd_message.set_token('TABLE_NAME', 'pay_ie_prsi_details_f');

399: -- The object is locked therefore we need to supply a meaningful
400: -- error message.
401: --
402: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
403: fnd_message.set_token('TABLE_NAME', 'pay_ie_prsi_details_f');
404: fnd_message.raise_error;
405: End lck;
406: --
407: -- ----------------------------------------------------------------------------