APPS.BEN_VEP_SHD dependencies on BEN_VRBL_RT_ELIG_PRFL_F

Line 32: If (p_constraint_name = 'BEN_VRBL_RT_ELIG_PRFL_F_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'BEN_VRBL_RT_ELIG_PRFL_F_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 98: from BEN_VRBL_RT_ELIG_PRFL_f

94: ,vep_attribute28
95: ,vep_attribute29
96: ,vep_attribute30
97: ,object_version_number
98: from BEN_VRBL_RT_ELIG_PRFL_f
99: where vrbl_rt_elig_prfl_id = p_vrbl_rt_elig_prfl_id
100: and p_effective_date
101: between effective_start_date and effective_end_date;
102: --

Line 173: ,p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_f'

169: -- Call the corresponding datetrack api
170: --
171: dt_api.find_dt_upd_modes
172: (p_effective_date => p_effective_date
173: ,p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_f'
174: ,p_base_key_column => 'VRBL_RT_ELIG_PRFL_ID'
175: ,p_base_key_value => p_base_key_value
176: ,p_correction => p_correction
177: ,p_update => p_update

Line 207: from BEN_VRBL_RT_ELIG_PRFL_f t

203: Cursor C_Sel1 Is
204: select
205: t.vrbl_rt_prfl_id
206: ,t.eligy_prfl_id
207: from BEN_VRBL_RT_ELIG_PRFL_f t
208: where t.vrbl_rt_elig_prfl_id = p_base_key_value
209: and p_effective_date
210: between t.effective_start_date and t.effective_end_date;
211: --

Line 231: ,p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_f'

227: -- Call the corresponding datetrack api
228: --
229: dt_api.find_dt_del_modes
230: (p_effective_date => p_effective_date
231: ,p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_f'
232: ,p_base_key_column => 'VRBL_RT_ELIG_PRFL_ID'
233: ,p_base_key_value => p_base_key_value
234: ,p_parent_table_name1 => 'BEN_VRBL_RT_PRFL_F'
235: ,p_parent_key_column1 => 'VRBL_RT_PRFL_ID'

Line 272: (p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_f'

268: -- version number.
269: --
270: l_object_version_number :=
271: dt_api.get_object_version_number
272: (p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_f'
273: ,p_base_key_column => 'VRBL_RT_ELIG_PRFL_ID'
274: ,p_base_key_value => p_base_key_value
275: );
276: --

Line 283: update BEN_VRBL_RT_ELIG_PRFL_f t

279: --
280: -- Update the specified datetrack row setting the effective
281: -- end date to the specified new effective end date.
282: --
283: update BEN_VRBL_RT_ELIG_PRFL_f t
284: set t.effective_end_date = p_new_effective_end_date
285: , t.object_version_number = l_object_version_number
286: where t.vrbl_rt_elig_prfl_id = p_base_key_value
287: and p_effective_date

Line 362: from BEN_VRBL_RT_ELIG_PRFL_f

358: ,vep_attribute28
359: ,vep_attribute29
360: ,vep_attribute30
361: ,object_version_number
362: from BEN_VRBL_RT_ELIG_PRFL_f
363: where vrbl_rt_elig_prfl_id = p_vrbl_rt_elig_prfl_id
364: and p_effective_date
365: between effective_start_date and effective_end_date
366: for update nowait;

Line 425: ,p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_f'

421: --
422: dt_api.validate_dt_mode
423: (p_effective_date => p_effective_date
424: ,p_datetrack_mode => p_datetrack_mode
425: ,p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_f'
426: ,p_base_key_column => 'VRBL_RT_ELIG_PRFL_ID'
427: ,p_base_key_value => p_vrbl_rt_elig_prfl_id
428: ,p_parent_table_name1 => 'BEN_VRBL_RT_PRFL_F'
429: ,p_parent_key_column1 => 'VRBL_RT_PRFL_ID'

Line 466: fnd_message.set_token('TABLE_NAME', 'BEN_VRBL_RT_ELIG_PRFL_f');

462: -- The object is locked therefore we need to supply a meaningful
463: -- error message.
464: --
465: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
466: fnd_message.set_token('TABLE_NAME', 'BEN_VRBL_RT_ELIG_PRFL_f');
467: fnd_message.raise_error;
468: End lck;
469: --
470: -- ----------------------------------------------------------------------------