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_ADS_SHD dependencies on BEN_ACTY_RT_DED_SCHED_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ACTY_RT_DED_SCHED_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 41: ElsIf (p_constraint_name = 'BEN_ACTY_RT_DED_SCHED_FK2') 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_ACTY_RT_DED_SCHED_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;

Line 46: ElsIf (p_constraint_name = 'BEN_ACTY_RT_DED_SCHED_F_PK') 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_ACTY_RT_DED_SCHED_F_PK') 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 115: from ben_acty_rt_ded_sched_f

111: ads_attribute28,
112: ads_attribute29,
113: ads_attribute30,
114: object_version_number
115: from ben_acty_rt_ded_sched_f
116: where acty_rt_ded_sched_id = p_acty_rt_ded_sched_id
117: and p_effective_date
118: between effective_start_date and effective_end_date;
119: --

Line 188: from ben_acty_rt_ded_sched_f t

184: l_parent_key_value1 number;
185: --
186: Cursor C_Sel1 Is
187: select t.acty_base_rt_id
188: from ben_acty_rt_ded_sched_f t
189: where t.acty_rt_ded_sched_id = p_base_key_value
190: and p_effective_date
191: between t.effective_start_date and t.effective_end_date;
192: --

Line 210: p_base_table_name => 'ben_acty_rt_ded_sched_f',

206: -- Call the corresponding datetrack api
207: --
208: dt_api.find_dt_del_modes
209: (p_effective_date => p_effective_date,
210: p_base_table_name => 'ben_acty_rt_ded_sched_f',
211: p_base_key_column => 'acty_rt_ded_sched_id',
212: p_base_key_value => p_base_key_value,
213: p_parent_table_name1 => 'ben_acty_base_rt_f',
214: p_parent_key_column1 => 'acty_base_rt_id',

Line 244: p_base_table_name => 'ben_acty_rt_ded_sched_f',

240: -- Call the corresponding datetrack api
241: --
242: dt_api.find_dt_upd_modes
243: (p_effective_date => p_effective_date,
244: p_base_table_name => 'ben_acty_rt_ded_sched_f',
245: p_base_key_column => 'acty_rt_ded_sched_id',
246: p_base_key_value => p_base_key_value,
247: p_correction => p_correction,
248: p_update => p_update,

Line 277: (p_base_table_name => 'ben_acty_rt_ded_sched_f',

273: -- version number.
274: --
275: l_object_version_number :=
276: dt_api.get_object_version_number
277: (p_base_table_name => 'ben_acty_rt_ded_sched_f',
278: p_base_key_column => 'acty_rt_ded_sched_id',
279: p_base_key_value => p_base_key_value);
280: --
281: hr_utility.set_location(l_proc, 10);

Line 287: update ben_acty_rt_ded_sched_f t

283: --
284: -- Update the specified datetrack row setting the effective
285: -- end date to the specified new effective end date.
286: --
287: update ben_acty_rt_ded_sched_f t
288: set t.effective_end_date = p_new_effective_end_date,
289: t.object_version_number = l_object_version_number
290: where t.acty_rt_ded_sched_id = p_base_key_value
291: and p_effective_date

Line 366: from ben_acty_rt_ded_sched_f

362: ads_attribute28,
363: ads_attribute29,
364: ads_attribute30,
365: object_version_number
366: from ben_acty_rt_ded_sched_f
367: where acty_rt_ded_sched_id = p_acty_rt_ded_sched_id
368: and p_effective_date
369: between effective_start_date and effective_end_date
370: for update nowait;

Line 425: p_base_table_name => 'ben_acty_rt_ded_sched_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_acty_rt_ded_sched_f',
426: p_base_key_column => 'acty_rt_ded_sched_id',
427: p_base_key_value => p_acty_rt_ded_sched_id,
428: p_parent_table_name1 => 'ben_acty_base_rt_f',
429: p_parent_key_column1 => 'acty_base_rt_id',

Line 462: fnd_message.set_token('TABLE_NAME', 'ben_acty_rt_ded_sched_f');

458: -- The object is locked therefore we need to supply a meaningful
459: -- error message.
460: --
461: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
462: fnd_message.set_token('TABLE_NAME', 'ben_acty_rt_ded_sched_f');
463: fnd_message.raise_error;
464: When l_object_invalid then
465: --
466: -- The object doesn't exist or is invalid

Line 469: fnd_message.set_token('TABLE_NAME', 'ben_acty_rt_ded_sched_f');

465: --
466: -- The object doesn't exist or is invalid
467: --
468: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
469: fnd_message.set_token('TABLE_NAME', 'ben_acty_rt_ded_sched_f');
470: fnd_message.raise_error;
471: End lck;
472: --
473: -- ----------------------------------------------------------------------------