eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PDP_SHD dependencies on BEN_ELIG_CVRD_DPNT_F

Line 41: elsif (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_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;
41: elsif (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_FK1') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;

Line 46: elsif (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_FK2') Then

42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: elsif (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_FK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;

Line 51: elsif (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_FK3') Then

47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: elsif (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_FK3') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;

Line 128: from ben_elig_cvrd_dpnt_f

124: object_version_number,
125: ovrdn_flag,
126: per_in_ler_id,
127: ovrdn_thru_dt
128: from ben_elig_cvrd_dpnt_f
129: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
130: and p_effective_date
131: between effective_start_date and effective_end_date;
132: --

Line 201: from ben_elig_cvrd_dpnt_f t

197: l_parent_key_value1 number;
198: --
199: Cursor C_Sel1 Is
200: select t.prtt_enrt_rslt_id
201: from ben_elig_cvrd_dpnt_f t
202: where t.elig_cvrd_dpnt_id = p_base_key_value
203: and p_effective_date
204: between t.effective_start_date and t.effective_end_date;
205: --

Line 223: p_base_table_name => 'ben_elig_cvrd_dpnt_f',

219: -- Call the corresponding datetrack api
220: --
221: dt_api.find_dt_del_modes
222: (p_effective_date => p_effective_date,
223: p_base_table_name => 'ben_elig_cvrd_dpnt_f',
224: p_base_key_column => 'elig_cvrd_dpnt_id',
225: p_base_key_value => p_base_key_value,
226: p_parent_table_name1 => 'ben_prtt_enrt_rslt_f',
227: p_parent_key_column1 => 'prtt_enrt_rslt_id',

Line 257: p_base_table_name => 'ben_elig_cvrd_dpnt_f',

253: -- Call the corresponding datetrack api
254: --
255: dt_api.find_dt_upd_modes
256: (p_effective_date => p_effective_date,
257: p_base_table_name => 'ben_elig_cvrd_dpnt_f',
258: p_base_key_column => 'elig_cvrd_dpnt_id',
259: p_base_key_value => p_base_key_value,
260: p_correction => p_correction,
261: p_update => p_update,

Line 290: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',

286: -- version number.
287: --
288: l_object_version_number :=
289: dt_api.get_object_version_number
290: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',
291: p_base_key_column => 'elig_cvrd_dpnt_id',
292: p_base_key_value => p_base_key_value);
293: --
294: hr_utility.set_location(l_proc, 10);

Line 300: update ben_elig_cvrd_dpnt_f t

296: --
297: -- Update the specified datetrack row setting the effective
298: -- end date to the specified new effective end date.
299: --
300: update ben_elig_cvrd_dpnt_f t
301: set t.effective_end_date = p_new_effective_end_date,
302: t.object_version_number = l_object_version_number
303: where t.elig_cvrd_dpnt_id = p_base_key_value
304: and p_effective_date

Line 387: from ben_elig_cvrd_dpnt_f

383: object_version_number,
384: ovrdn_flag,
385: per_in_ler_id,
386: ovrdn_thru_dt
387: from ben_elig_cvrd_dpnt_f
388: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
389: and p_effective_date
390: between effective_start_date and effective_end_date
391: for update nowait;

Line 446: p_base_table_name => 'ben_elig_cvrd_dpnt_f',

442: --
443: dt_api.validate_dt_mode
444: (p_effective_date => p_effective_date,
445: p_datetrack_mode => p_datetrack_mode,
446: p_base_table_name => 'ben_elig_cvrd_dpnt_f',
447: p_base_key_column => 'elig_cvrd_dpnt_id',
448: p_base_key_value => p_elig_cvrd_dpnt_id,
449: p_child_table_name1 => 'ben_cvrd_dpnt_ctfn_prvdd_f',
450: p_child_key_column1 => 'cvrd_dpnt_ctfn_prvdd_id',

Line 482: fnd_message.set_token('TABLE_NAME', 'ben_elig_cvrd_dpnt_f');

478: -- The object is locked therefore we need to supply a meaningful
479: -- error message.
480: --
481: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
482: fnd_message.set_token('TABLE_NAME', 'ben_elig_cvrd_dpnt_f');
483: fnd_message.raise_error;
484: When l_object_invalid then
485: --
486: -- The object doesn't exist or is invalid

Line 489: fnd_message.set_token('TABLE_NAME', 'ben_elig_cvrd_dpnt_f');

485: --
486: -- The object doesn't exist or is invalid
487: --
488: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
489: fnd_message.set_token('TABLE_NAME', 'ben_elig_cvrd_dpnt_f');
490: fnd_message.raise_error;
491: End lck;
492: --
493: -- ----------------------------------------------------------------------------