APPS.PAY_PSD_SHD dependencies on PAY_PL_SII_DETAILS_F

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

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

70: ,program_id
71: ,program_login_id
72: ,program_application_id
73: ,request_id
74: from pay_pl_sii_details_f
75: where sii_details_id = p_sii_details_id
76: and p_effective_date
77: between effective_start_date and effective_end_date;
78: --

Line 158: ,p_base_table_name => 'pay_pl_sii_details_f'

154: -- Call the corresponding datetrack api
155: --
156: dt_api.find_dt_upd_modes_and_dates
157: (p_effective_date => p_effective_date
158: ,p_base_table_name => 'pay_pl_sii_details_f'
159: ,p_base_key_column => 'sii_details_id'
160: ,p_base_key_value => p_base_key_value
161: ,p_correction => p_correction
162: ,p_update => p_update

Line 200: ,p_base_table_name => 'pay_pl_sii_details_f'

196: -- Call the corresponding datetrack api
197: --
198: dt_api.find_dt_del_modes
199: (p_effective_date => p_effective_date
200: ,p_base_table_name => 'pay_pl_sii_details_f'
201: ,p_base_key_column => 'sii_details_id'
202: ,p_base_key_value => p_base_key_value
203: ,p_zap => p_zap
204: ,p_delete => p_delete

Line 235: (p_base_table_name => 'pay_pl_sii_details_f'

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

Line 246: update pay_pl_sii_details_f t

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

Line 307: from pay_pl_sii_details_f

303: ,program_id
304: ,program_login_id
305: ,program_application_id
306: ,request_id
307: from pay_pl_sii_details_f
308: where sii_details_id = p_sii_details_id
309: and p_effective_date
310: between effective_start_date and effective_end_date
311: for update nowait;

Line 379: ,p_base_table_name => 'pay_pl_sii_details_f'

375:
376: dt_api.validate_dt_mode
377: (p_effective_date => p_effective_date
378: ,p_datetrack_mode => p_datetrack_mode
379: ,p_base_table_name => 'pay_pl_sii_details_f'
380: ,p_base_key_column => 'sii_details_id'
381: ,p_base_key_value => p_sii_details_id
382: ,p_parent_table_name1 => 'per_all_assignments_f'
383: ,p_parent_key_column1 => 'assignment_id'

Line 398: ,p_base_table_name => 'pay_pl_sii_details_f'

394:
395: dt_api.validate_dt_mode
396: (p_effective_date => p_effective_date
397: ,p_datetrack_mode => p_datetrack_mode
398: ,p_base_table_name => 'pay_pl_sii_details_f'
399: ,p_base_key_column => 'sii_details_id'
400: ,p_base_key_value => p_sii_details_id
401: ,p_parent_table_name1 => 'per_people_f'
402: ,p_parent_key_column1 => 'person_id'

Line 440: fnd_message.set_token('TABLE_NAME', 'pay_pl_sii_details_f');

436: -- The object is locked therefore we need to supply a meaningful
437: -- error message.
438: --
439: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
440: fnd_message.set_token('TABLE_NAME', 'pay_pl_sii_details_f');
441: fnd_message.raise_error;
442: End lck;
443: --
444: -- ----------------------------------------------------------------------------