APPS.HR_LIP_SHD dependencies on HR_DE_LIABILITY_PREMIUMS_F

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_DE_LIABILITY_PREMIUMS_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','10');
25: fnd_message.raise_error;

Line 78: from hr_de_liability_premiums_f

74: ,attribute18
75: ,attribute19
76: ,attribute20
77: ,object_version_number
78: from hr_de_liability_premiums_f
79: where liability_premiums_id = p_liability_premiums_id
80: and p_effective_date
81: between effective_start_date and effective_end_date;
82: --

Line 154: ,p_base_table_name => 'hr_de_liability_premiums_f'

150: -- Call the corresponding datetrack api
151: --
152: dt_api.find_dt_upd_modes
153: (p_effective_date => p_effective_date
154: ,p_base_table_name => 'hr_de_liability_premiums_f'
155: ,p_base_key_column => 'liability_premiums_id'
156: ,p_base_key_value => p_base_key_value
157: ,p_correction => p_correction
158: ,p_update => p_update

Line 188: ,p_base_table_name => 'hr_de_liability_premiums_f'

184: -- Call the corresponding datetrack api
185: --
186: dt_api.find_dt_del_modes
187: (p_effective_date => p_effective_date
188: ,p_base_table_name => 'hr_de_liability_premiums_f'
189: ,p_base_key_column => 'liability_premiums_id'
190: ,p_base_key_value => p_base_key_value
191: ,p_zap => p_zap
192: ,p_delete => p_delete

Line 223: (p_base_table_name => 'hr_de_liability_premiums_f'

219: -- version number.
220: --
221: l_object_version_number :=
222: dt_api.get_object_version_number
223: (p_base_table_name => 'hr_de_liability_premiums_f'
224: ,p_base_key_column => 'liability_premiums_id'
225: ,p_base_key_value => p_base_key_value
226: );
227: --

Line 234: update hr_de_liability_premiums_f t

230: --
231: -- Update the specified datetrack row setting the effective
232: -- end date to the specified new effective end date.
233: --
234: update hr_de_liability_premiums_f t
235: set t.effective_end_date = p_new_effective_end_date
236: , t.object_version_number = l_object_version_number
237: where t.liability_premiums_id = p_base_key_value
238: and p_effective_date

Line 299: from hr_de_liability_premiums_f

295: ,attribute18
296: ,attribute19
297: ,attribute20
298: ,object_version_number
299: from hr_de_liability_premiums_f
300: where liability_premiums_id = p_liability_premiums_id
301: and p_effective_date
302: between effective_start_date and effective_end_date
303: for update nowait;

Line 362: ,p_base_table_name => 'hr_de_liability_premiums_f'

358: --
359: dt_api.validate_dt_mode
360: (p_effective_date => p_effective_date
361: ,p_datetrack_mode => p_datetrack_mode
362: ,p_base_table_name => 'hr_de_liability_premiums_f'
363: ,p_base_key_column => 'liability_premiums_id'
364: ,p_base_key_value => p_liability_premiums_id
365: ,p_enforce_foreign_locking => true
366: ,p_validation_start_date => l_validation_start_date

Line 397: fnd_message.set_token('TABLE_NAME', 'hr_de_liability_premiums_f');

393: -- The object is locked therefore we need to supply a meaningful
394: -- error message.
395: --
396: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
397: fnd_message.set_token('TABLE_NAME', 'hr_de_liability_premiums_f');
398: fnd_message.raise_error;
399: End lck;
400: --
401: -- ----------------------------------------------------------------------------