APPS.BEN_CTY_SHD dependencies on BEN_COMPTNCY_RT_F

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

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

85: ,cty_attribute27
86: ,cty_attribute28
87: ,cty_attribute29
88: ,cty_attribute30
89: from ben_comptncy_rt_f
90: where comptncy_rt_id = p_comptncy_rt_id
91: and p_effective_date
92: between effective_start_date and effective_end_date;
93: --

Line 165: ,p_base_table_name => 'ben_comptncy_rt_f'

161: -- Call the corresponding datetrack api
162: --
163: dt_api.find_dt_upd_modes
164: (p_effective_date => p_effective_date
165: ,p_base_table_name => 'ben_comptncy_rt_f'
166: ,p_base_key_column => 'comptncy_rt_id'
167: ,p_base_key_value => p_base_key_value
168: ,p_correction => p_correction
169: ,p_update => p_update

Line 195: from ben_comptncy_rt_f t

191: l_parent_key_value1 number;
192: --
193: Cursor C_Sel1 Is
194: select t.vrbl_rt_prfl_id
195: from ben_comptncy_rt_f t
196: where t.comptncy_rt_id = p_base_key_value
197: and p_effective_date
198: between t.effective_start_date and t.effective_end_date;
199: --

Line 218: ,p_base_table_name => 'ben_comptncy_rt_f'

214: -- Call the corresponding datetrack api
215: --
216: dt_api.find_dt_del_modes
217: (p_effective_date => p_effective_date
218: ,p_base_table_name => 'ben_comptncy_rt_f'
219: ,p_base_key_column => 'comptncy_rt_id'
220: ,p_base_key_value => p_base_key_value
221: ,p_parent_table_name1 => 'ben_vrbl_rt_prfl_f'
222: ,p_parent_key_column1 => 'vrbl_rt_prfl_id'

Line 256: (p_base_table_name => 'ben_comptncy_rt_f'

252: -- version number.
253: --
254: l_object_version_number :=
255: dt_api.get_object_version_number
256: (p_base_table_name => 'ben_comptncy_rt_f'
257: ,p_base_key_column => 'comptncy_rt_id'
258: ,p_base_key_value => p_base_key_value
259: );
260: --

Line 267: update ben_comptncy_rt_f t

263: --
264: -- Update the specified datetrack row setting the effective
265: -- end date to the specified new effective end date.
266: --
267: update ben_comptncy_rt_f t
268: set t.effective_end_date = p_new_effective_end_date
269: , t.object_version_number = l_object_version_number
270: where t.comptncy_rt_id = p_base_key_value
271: and p_effective_date

Line 343: from ben_comptncy_rt_f

339: ,cty_attribute27
340: ,cty_attribute28
341: ,cty_attribute29
342: ,cty_attribute30
343: from ben_comptncy_rt_f
344: where comptncy_rt_id = p_comptncy_rt_id
345: and p_effective_date
346: between effective_start_date and effective_end_date
347: for update nowait;

Line 406: ,p_base_table_name => 'ben_comptncy_rt_f'

402: --
403: dt_api.validate_dt_mode
404: (p_effective_date => p_effective_date
405: ,p_datetrack_mode => p_datetrack_mode
406: ,p_base_table_name => 'ben_comptncy_rt_f'
407: ,p_base_key_column => 'comptncy_rt_id'
408: ,p_base_key_value => p_comptncy_rt_id
409: ,p_parent_table_name1 => 'ben_vrbl_rt_prfl_f'
410: ,p_parent_key_column1 => 'vrbl_rt_prfl_id'

Line 444: fnd_message.set_token('TABLE_NAME', 'ben_comptncy_rt_f');

440: -- The object is locked therefore we need to supply a meaningful
441: -- error message.
442: --
443: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
444: fnd_message.set_token('TABLE_NAME', 'ben_comptncy_rt_f');
445: fnd_message.raise_error;
446: End lck;
447: --
448: -- ----------------------------------------------------------------------------