APPS.BEN_ELP_SHD dependencies on BEN_ELIGY_PRFL_F

Line 36: If (p_constraint_name = 'BEN_ELIGY_PRFL_FK1') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ELIGY_PRFL_FK1') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;

Line 183: from ben_eligy_prfl_f

179: elig_qua_in_gr_flag,
180: elig_perf_rtng_flag,
181: elig_crit_values_flag, /* RBC */
182: object_version_number
183: from ben_eligy_prfl_f
184: where eligy_prfl_id = p_eligy_prfl_id
185: and p_effective_date
186: between effective_start_date and effective_end_date;
187: --

Line 263: p_base_table_name => 'ben_eligy_prfl_f',

259: -- Call the corresponding datetrack api
260: --
261: dt_api.find_dt_del_modes
262: (p_effective_date => p_effective_date,
263: p_base_table_name => 'ben_eligy_prfl_f',
264: p_base_key_column => 'eligy_prfl_id',
265: p_base_key_value => p_base_key_value,
266: p_zap => p_zap,
267: p_delete => p_delete,

Line 294: p_base_table_name => 'ben_eligy_prfl_f',

290: -- Call the corresponding datetrack api
291: --
292: dt_api.find_dt_upd_modes
293: (p_effective_date => p_effective_date,
294: p_base_table_name => 'ben_eligy_prfl_f',
295: p_base_key_column => 'eligy_prfl_id',
296: p_base_key_value => p_base_key_value,
297: p_correction => p_correction,
298: p_update => p_update,

Line 327: (p_base_table_name => 'ben_eligy_prfl_f',

323: -- version number.
324: --
325: l_object_version_number :=
326: dt_api.get_object_version_number
327: (p_base_table_name => 'ben_eligy_prfl_f',
328: p_base_key_column => 'eligy_prfl_id',
329: p_base_key_value => p_base_key_value);
330: --
331: hr_utility.set_location(l_proc, 10);

Line 337: update ben_eligy_prfl_f t

333: --
334: -- Update the specified datetrack row setting the effective
335: -- end date to the specified new effective end date.
336: --
337: update ben_eligy_prfl_f t
338: set t.effective_end_date = p_new_effective_end_date,
339: t.object_version_number = l_object_version_number
340: where t.eligy_prfl_id = p_base_key_value
341: and p_effective_date

Line 481: from ben_eligy_prfl_f

477: elig_qua_in_gr_flag,
478: elig_perf_rtng_flag,
479: elig_crit_values_flag, /* RBC */
480: object_version_number
481: from ben_eligy_prfl_f
482: where eligy_prfl_id = p_eligy_prfl_id
483: and p_effective_date
484: between effective_start_date and effective_end_date
485: for update nowait;

Line 540: p_base_table_name => 'ben_eligy_prfl_f',

536: --
537: dt_api.validate_dt_mode
538: (p_effective_date => p_effective_date,
539: p_datetrack_mode => p_datetrack_mode,
540: p_base_table_name => 'ben_eligy_prfl_f',
541: p_base_key_column => 'eligy_prfl_id',
542: p_base_key_value => p_eligy_prfl_id,
543: p_child_table_name1 => 'ben_cntng_prtn_elig_prfl_f',
544: p_child_key_column1 => 'cntng_prtn_elig_prfl_id',

Line 576: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');

572: -- The object is locked therefore we need to supply a meaningful
573: -- error message.
574: --
575: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
576: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');
577: fnd_message.raise_error;
578: When l_object_invalid then
579: --
580: -- The object doesn't exist or is invalid

Line 583: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');

579: --
580: -- The object doesn't exist or is invalid
581: --
582: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
583: fnd_message.set_token('TABLE_NAME', 'ben_eligy_prfl_f');
584: fnd_message.raise_error;
585: End lck;
586: --
587: -- ----------------------------------------------------------------------------