APPS.BEN_JRT_SHD dependencies on BEN_JOB_RT_F

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

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

84: ,jrt_attribute27
85: ,jrt_attribute28
86: ,jrt_attribute29
87: ,jrt_attribute30
88: from ben_job_rt_f
89: where job_rt_id = p_job_rt_id
90: and p_effective_date
91: between effective_start_date and effective_end_date;
92: --

Line 164: ,p_base_table_name => 'ben_job_rt_f'

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

Line 195: from ben_job_rt_f t

191: --
192: Cursor C_Sel1 Is
193: select
194: t.vrbl_rt_prfl_id
195: from ben_job_rt_f t
196: where t.job_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_job_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_job_rt_f'
219: ,p_base_key_column => 'job_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_job_rt_f'

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

Line 267: update ben_job_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_job_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.job_rt_id = p_base_key_value
271: and p_effective_date

Line 342: from ben_job_rt_f

338: ,jrt_attribute27
339: ,jrt_attribute28
340: ,jrt_attribute29
341: ,jrt_attribute30
342: from ben_job_rt_f
343: where job_rt_id = p_job_rt_id
344: and p_effective_date
345: between effective_start_date and effective_end_date
346: for update nowait;

Line 405: ,p_base_table_name => 'ben_job_rt_f'

401: --
402: dt_api.validate_dt_mode
403: (p_effective_date => p_effective_date
404: ,p_datetrack_mode => p_datetrack_mode
405: ,p_base_table_name => 'ben_job_rt_f'
406: ,p_base_key_column => 'job_rt_id'
407: ,p_base_key_value => p_job_rt_id
408: ,p_parent_table_name1 => 'ben_vrbl_rt_prfl_f'
409: ,p_parent_key_column1 => 'vrbl_rt_prfl_id'

Line 443: fnd_message.set_token('TABLE_NAME', 'BEN_JOB_RT_F');

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