APPS.PER_DIS_SHD dependencies on PER_DISABILITIES_F

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_DISABILITIES_F_FK2') 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 26: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') 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;
26: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then

27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;

Line 138: from per_disabilities_f

134: ,dis_information28
135: ,dis_information29
136: ,dis_information30
137: ,object_version_number
138: from per_disabilities_f
139: where disability_id = p_disability_id
140: and p_effective_date
141: between effective_start_date and effective_end_date;
142: --

Line 213: ,p_base_table_name => 'per_disabilities_f'

209: -- Call the corresponding datetrack api
210: --
211: dt_api.find_dt_upd_modes
212: (p_effective_date => p_effective_date
213: ,p_base_table_name => 'per_disabilities_f'
214: ,p_base_key_column => 'disability_id'
215: ,p_base_key_value => p_base_key_value
216: ,p_correction => p_correction
217: ,p_update => p_update

Line 244: from per_disabilities_f t

240: --
241: Cursor C_Sel1 Is
242: select
243: t.person_id
244: from per_disabilities_f t
245: where t.disability_id = p_base_key_value
246: and p_effective_date
247: between t.effective_start_date and t.effective_end_date;
248: --

Line 267: ,p_base_table_name => 'per_disabilities_f'

263: -- Call the corresponding datetrack api
264: --
265: dt_api.find_dt_del_modes
266: (p_effective_date => p_effective_date
267: ,p_base_table_name => 'per_disabilities_f'
268: ,p_base_key_column => 'disability_id'
269: ,p_base_key_value => p_base_key_value
270: ,p_parent_table_name1 => 'per_all_people_f'
271: ,p_parent_key_column1 => 'person_id'

Line 305: (p_base_table_name => 'per_disabilities_f'

301: -- version number.
302: --
303: l_object_version_number :=
304: dt_api.get_object_version_number
305: (p_base_table_name => 'per_disabilities_f'
306: ,p_base_key_column => 'disability_id'
307: ,p_base_key_value => p_base_key_value
308: );
309: --

Line 316: update per_disabilities_f t

312: --
313: -- Update the specified datetrack row setting the effective
314: -- end date to the specified new effective end date.
315: --
316: update per_disabilities_f t
317: set t.effective_end_date = p_new_effective_end_date
318: , t.object_version_number = l_object_version_number
319: where t.disability_id = p_base_key_value
320: and p_effective_date

Line 431: from per_disabilities_f

427: ,dis_information28
428: ,dis_information29
429: ,dis_information30
430: ,object_version_number
431: from per_disabilities_f
432: where disability_id = p_disability_id
433: and p_effective_date
434: between effective_start_date and effective_end_date
435: for update nowait;

Line 494: ,p_base_table_name => 'per_disabilities_f'

490: --
491: dt_api.validate_dt_mode
492: (p_effective_date => p_effective_date
493: ,p_datetrack_mode => p_datetrack_mode
494: ,p_base_table_name => 'per_disabilities_f'
495: ,p_base_key_column => 'disability_id'
496: ,p_base_key_value => p_disability_id
497: ,p_parent_table_name1 => 'per_all_people_f'
498: ,p_parent_key_column1 => 'person_id'

Line 532: fnd_message.set_token('TABLE_NAME', 'per_disabilities_f');

528: -- The object is locked therefore we need to supply a meaningful
529: -- error message.
530: --
531: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
532: fnd_message.set_token('TABLE_NAME', 'per_disabilities_f');
533: fnd_message.raise_error;
534: End lck;
535: --
536: -- ----------------------------------------------------------------------------