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_PEN_SHD dependencies on BEN_PRTT_ENRT_RSLT_F

Line 133: from ben_prtt_enrt_rslt_f

129: ,bnft_ordr_num
130: ,prtt_enrt_rslt_stat_cd
131: ,bnft_nnmntry_uom
132: ,comp_lvl_cd
133: from ben_prtt_enrt_rslt_f
134: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
135: and p_effective_date between
136: effective_start_date and effective_end_date;
137: l_proc varchar2(72) := g_package||'api_updating';

Line 212: from ben_prtt_enrt_rslt_f t

208: ,t.pl_typ_id
209: ,t.prtt_enrt_rslt_id
210: ,t.ptip_id
211: ,t.ler_id
212: from ben_prtt_enrt_rslt_f t
213: where t.prtt_enrt_rslt_id = p_base_key_value
214: and p_effective_date between
215: t.effective_start_date and t.effective_end_date;
216: --

Line 240: ,p_base_table_name => 'ben_prtt_enrt_rslt_f'

236: -- Call the corresponding datetrack api
237: --
238: dt_api.find_dt_del_modes
239: (p_effective_date => p_effective_date
240: ,p_base_table_name => 'ben_prtt_enrt_rslt_f'
241: ,p_base_key_column => 'prtt_enrt_rslt_id'
242: ,p_base_key_value => p_base_key_value
243: ,p_parent_table_name1 => 'ben_pgm_f'
244: ,p_parent_key_column1 => 'pgm_id'

Line 255: ,p_parent_table_name5 => 'ben_prtt_enrt_rslt_f'

251: ,p_parent_key_value3 => l_parent_key_value3
252: ,p_parent_table_name4 => 'ben_pl_typ_f'
253: ,p_parent_key_column4 => 'pl_typ_id'
254: ,p_parent_key_value4 => l_parent_key_value4
255: ,p_parent_table_name5 => 'ben_prtt_enrt_rslt_f'
256: ,p_parent_key_column5 => 'prtt_enrt_rslt_id'
257: ,p_parent_key_value5 => l_parent_key_value5
258: ,p_parent_table_name6 => 'ben_ptip_f'
259: ,p_parent_key_column6 => 'ptip_id'

Line 292: ,p_base_table_name => 'ben_prtt_enrt_rslt_f'

288: -- Call the corresponding datetrack api
289: --
290: dt_api.find_dt_upd_modes
291: (p_effective_date => p_effective_date
292: ,p_base_table_name => 'ben_prtt_enrt_rslt_f'
293: ,p_base_key_column => 'prtt_enrt_rslt_id'
294: ,p_base_key_value => p_base_key_value
295: ,p_correction => p_correction
296: ,p_update => p_update

Line 324: (p_base_table_name => 'ben_prtt_enrt_rslt_f'

320: -- version number.
321: --
322: l_object_version_number :=
323: dt_api.get_object_version_number
324: (p_base_table_name => 'ben_prtt_enrt_rslt_f'
325: ,p_base_key_column => 'prtt_enrt_rslt_id'
326: ,p_base_key_value => p_base_key_value
327: );
328: hr_utility.set_location(l_proc, 10);

Line 334: update ben_prtt_enrt_rslt_f t

330: --
331: -- Update the specified datetrack row setting the effective
332: -- end date to the specified new effective end date.
333: --
334: update ben_prtt_enrt_rslt_f t
335: set t.effective_end_date = p_new_effective_end_date
336: ,t.object_version_number = l_object_version_number
337: where t.prtt_enrt_rslt_id = p_base_key_value
338: and p_effective_date between

Line 374: (p_base_table_name => 'ben_prtt_enrt_rslt_f'

370: -- version number.
371: --
372: l_object_version_number :=
373: dt_api.get_object_version_number
374: (p_base_table_name => 'ben_prtt_enrt_rslt_f'
375: ,p_base_key_column => 'prtt_enrt_rslt_id'
376: ,p_base_key_value => p_base_key_value
377: );
378: hr_utility.set_location(l_proc, 10);

Line 384: update ben_prtt_enrt_rslt_f t

380: --
381: -- Update the specified datetrack row setting the effective
382: -- end date to the specified new effective end date.
383: --
384: update ben_prtt_enrt_rslt_f t
385: set t.effective_end_date = p_new_effective_end_date
386: ,t.object_version_number = l_object_version_number
387: ,t.prtt_enrt_rslt_stat_cd = p_prtt_enrt_rslt_stat_cd
388: where t.prtt_enrt_rslt_id = p_base_key_value

Line 496: from ben_prtt_enrt_rslt_f

492: ,bnft_ordr_num
493: ,prtt_enrt_rslt_stat_cd
494: ,bnft_nnmntry_uom
495: ,comp_lvl_cd
496: from ben_prtt_enrt_rslt_f
497: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
498: and p_effective_date between
499: effective_start_date and effective_end_date
500: for update nowait;

Line 559: ,p_base_table_name => 'ben_prtt_enrt_rslt_f'

555:
556: dt_api.validate_dt_mode
557: (p_effective_date => p_effective_date
558: ,p_datetrack_mode => p_datetrack_mode
559: ,p_base_table_name => 'ben_prtt_enrt_rslt_f'
560: ,p_base_key_column => 'prtt_enrt_rslt_id'
561: ,p_base_key_value => p_prtt_enrt_rslt_id
562: ,p_parent_table_name1 => 'ben_pgm_f'
563: ,p_parent_key_column1 => 'pgm_id'

Line 626: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');

622: -- The object is locked therefore we need to supply a meaningful
623: -- error message.
624: --
625: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
626: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');
627: fnd_message.raise_error;
628: When l_object_invalid then
629: --
630: -- The object doesn't exist or is invalid

Line 633: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');

629: --
630: -- The object doesn't exist or is invalid
631: --
632: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
633: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');
634: fnd_message.raise_error;
635: End lck;
636: --
637: -- ----------------------------------------------------------------------------