APPS.PAY_PPD_SHD dependencies on PAY_PL_PAYE_DETAILS_F

Line 23: If (p_constraint_name = 'PAY_PL_PAYE_DETAILS_F_PK') Then

19: l_proc varchar2(72) := g_package||'constraint_error';
20: --
21: Begin
22: --
23: If (p_constraint_name = 'PAY_PL_PAYE_DETAILS_F_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;

Line 66: from pay_pl_paye_details_f

62: ,program_id
63: ,program_login_id
64: ,program_application_id
65: ,request_id
66: from pay_pl_paye_details_f
67: where paye_details_id = p_paye_details_id
68: and p_effective_date
69: between effective_start_date and effective_end_date;
70: --

Line 150: ,p_base_table_name => 'pay_pl_paye_details_f'

146: -- Call the corresponding datetrack api
147: --
148: dt_api.find_dt_upd_modes_and_dates
149: (p_effective_date => p_effective_date
150: ,p_base_table_name => 'pay_pl_paye_details_f'
151: ,p_base_key_column => 'paye_details_id'
152: ,p_base_key_value => p_base_key_value
153: ,p_correction => p_correction
154: ,p_update => p_update

Line 192: ,p_base_table_name => 'pay_pl_paye_details_f'

188: -- Call the corresponding datetrack api
189: --
190: dt_api.find_dt_del_modes
191: (p_effective_date => p_effective_date
192: ,p_base_table_name => 'pay_pl_paye_details_f'
193: ,p_base_key_column => 'paye_details_id'
194: ,p_base_key_value => p_base_key_value
195: ,p_zap => p_zap
196: ,p_delete => p_delete

Line 227: (p_base_table_name => 'pay_pl_paye_details_f'

223: -- version number.
224: --
225: l_object_version_number :=
226: dt_api.get_object_version_number
227: (p_base_table_name => 'pay_pl_paye_details_f'
228: ,p_base_key_column => 'paye_details_id'
229: ,p_base_key_value => p_base_key_value
230: );
231: --

Line 238: update pay_pl_paye_details_f t

234: --
235: -- Update the specified datetrack row setting the effective
236: -- end date to the specified new effective end date.
237: --
238: update pay_pl_paye_details_f t
239: set t.effective_end_date = p_new_effective_end_date
240: , t.object_version_number = l_object_version_number
241: where t.paye_details_id = p_base_key_value
242: and p_effective_date

Line 289: from pay_pl_paye_details_f

285: ,program_id
286: ,program_login_id
287: ,program_application_id
288: ,request_id
289: from pay_pl_paye_details_f
290: where paye_details_id = p_paye_details_id
291: and p_effective_date
292: between effective_start_date and effective_end_date
293: for update nowait;

Line 356: ,p_base_table_name => 'pay_pl_paye_details_f'

352: */
353: dt_api.validate_dt_mode
354: (p_effective_date => p_effective_date
355: ,p_datetrack_mode => p_datetrack_mode
356: ,p_base_table_name => 'pay_pl_paye_details_f'
357: ,p_base_key_column => 'paye_details_id'
358: ,p_base_key_value => p_paye_details_id
359: ,p_parent_table_name1 => 'per_all_assignments_f'
360: ,p_parent_key_column1 => 'assignment_id'

Line 372: ,p_base_table_name => 'pay_pl_paye_details_f'

368:
369: dt_api.validate_dt_mode
370: (p_effective_date => p_effective_date
371: ,p_datetrack_mode => p_datetrack_mode
372: ,p_base_table_name => 'pay_pl_paye_details_f'
373: ,p_base_key_column => 'paye_details_id'
374: ,p_base_key_value => p_paye_details_id
375: ,p_parent_table_name1 => 'per_people_f'
376: ,p_parent_key_column1 => 'person_id'

Line 388: ,p_base_table_name => 'pay_pl_paye_details_f'

384: --
385: /*dt_api.validate_dt_mode
386: (p_effective_date => p_effective_date
387: ,p_datetrack_mode => p_datetrack_mode
388: ,p_base_table_name => 'pay_pl_paye_details_f'
389: ,p_base_key_column => 'paye_details_id'
390: ,p_base_key_value => p_paye_details_id
391: ,p_enforce_foreign_locking => true
392: ,p_validation_start_date => l_validation_start_date

Line 423: fnd_message.set_token('TABLE_NAME', 'pay_pl_paye_details_f');

419: -- The object is locked therefore we need to supply a meaningful
420: -- error message.
421: --
422: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
423: fnd_message.set_token('TABLE_NAME', 'pay_pl_paye_details_f');
424: fnd_message.raise_error;
425: End lck;
426: --
427: -- ----------------------------------------------------------------------------