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_ABR_SHD dependencies on BEN_ACTY_BASE_RT_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ACTY_BASE_RT_FK4') 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_BASE_RT_F_PK') 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_BASE_RT_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;

Line 225: from ben_acty_base_rt_f

221: abr_attribute29,
222: abr_attribute30,
223: abr_seq_num,
224: object_version_number
225: from ben_acty_base_rt_f
226: where acty_base_rt_id = p_acty_base_rt_id
227: and p_effective_date
228: between effective_start_date and effective_end_date;
229: --

Line 337: from ben_acty_base_rt_f t

333: t.upr_lmt_calc_rl,
334: t.oiplip_id,
335: t.actl_prem_id,
336: t.opt_id
337: from ben_acty_base_rt_f t
338: where t.acty_base_rt_id = p_base_key_value
339: and p_effective_date
340: between t.effective_start_date and t.effective_end_date;
341: --

Line 374: p_base_table_name => 'ben_acty_base_rt_f',

370: -- Call the corresponding datetrack api
371: --
372: dt_api.find_dt_del_modes
373: (p_effective_date => p_effective_date,
374: p_base_table_name => 'ben_acty_base_rt_f',
375: p_base_key_column => 'acty_base_rt_id',
376: p_base_key_value => p_base_key_value,
377: p_parent_table_name1 => 'ff_formulas_f',
378: p_parent_key_column1 => 'formula_id',

Line 411: p_base_table_name => 'ben_acty_base_rt_f',

407: p_delete_next_change => l_delete_next_change);
408: --
409: dt_api.find_dt_del_modes
410: (p_effective_date => p_effective_date,
411: p_base_table_name => 'ben_acty_base_rt_f',
412: p_base_key_column => 'acty_base_rt_id',
413: p_base_key_value => p_base_key_value,
414: p_parent_table_name1 => 'ben_pl_f',
415: p_parent_key_column1 => 'pl_id',

Line 417: p_parent_table_name2 => 'ben_acty_base_rt_f',

413: p_base_key_value => p_base_key_value,
414: p_parent_table_name1 => 'ben_pl_f',
415: p_parent_key_column1 => 'pl_id',
416: p_parent_key_value1 => l_parent_key_value10,
417: p_parent_table_name2 => 'ben_acty_base_rt_f',
418: p_parent_key_column2 => 'acty_base_rt_id',
419: p_parent_key_value2 => l_parent_key_value11,
420: p_parent_table_name3 => 'ff_formulas_f',
421: p_parent_key_column3 => 'formula_id',

Line 505: p_base_table_name => 'ben_acty_base_rt_f',

501: -- Call the corresponding datetrack api
502: --
503: dt_api.find_dt_upd_modes
504: (p_effective_date => p_effective_date,
505: p_base_table_name => 'ben_acty_base_rt_f',
506: p_base_key_column => 'acty_base_rt_id',
507: p_base_key_value => p_base_key_value,
508: p_correction => p_correction,
509: p_update => p_update,

Line 538: (p_base_table_name => 'ben_acty_base_rt_f',

534: -- version number.
535: --
536: l_object_version_number :=
537: dt_api.get_object_version_number
538: (p_base_table_name => 'ben_acty_base_rt_f',
539: p_base_key_column => 'acty_base_rt_id',
540: p_base_key_value => p_base_key_value);
541: --
542: hr_utility.set_location(l_proc, 10);

Line 548: update ben_acty_base_rt_f t

544: --
545: -- Update the specified datetrack row setting the effective
546: -- end date to the specified new effective end date.
547: --
548: update ben_acty_base_rt_f t
549: set t.effective_end_date = p_new_effective_end_date,
550: t.object_version_number = l_object_version_number
551: where t.acty_base_rt_id = p_base_key_value
552: and p_effective_date

Line 727: from ben_acty_base_rt_f

723: abr_attribute29,
724: abr_attribute30,
725: abr_seq_num,
726: object_version_number
727: from ben_acty_base_rt_f
728: where acty_base_rt_id = p_acty_base_rt_id
729: and p_effective_date
730: between effective_start_date and effective_end_date
731: for update nowait;

Line 786: p_base_table_name => 'ben_acty_base_rt_f',

782: --
783: dt_api.validate_dt_mode
784: (p_effective_date => p_effective_date,
785: p_datetrack_mode => p_datetrack_mode,
786: p_base_table_name => 'ben_acty_base_rt_f',
787: p_base_key_column => 'acty_base_rt_id',
788: p_base_key_value => p_acty_base_rt_id,
789: p_parent_table_name1 => 'ff_formulas_f',
790: p_parent_key_column1 => 'formula_id',

Line 834: p_base_table_name => 'ben_acty_base_rt_f',

830: --
831: dt_api.validate_dt_mode
832: (p_effective_date => p_effective_date,
833: p_datetrack_mode => p_datetrack_mode,
834: p_base_table_name => 'ben_acty_base_rt_f',
835: p_base_key_column => 'acty_base_rt_id',
836: p_base_key_value => p_acty_base_rt_id,
837: p_parent_table_name1 => 'ben_cmbn_ptip_f',
838: p_parent_key_column1 => 'cmbn_ptip_id',

Line 846: p_parent_table_name4 => 'ben_acty_base_rt_f',

842: p_parent_key_value2 => g_old_rec.pl_id,
843: p_parent_table_name3 => 'ben_cmbn_ptip_opt_f',
844: p_parent_key_column3 => 'cmbn_ptip_opt_id',
845: p_parent_key_value3 => g_old_rec.cmbn_ptip_opt_id,
846: p_parent_table_name4 => 'ben_acty_base_rt_f',
847: p_parent_key_column4 => 'acty_base_rt_id',
848: p_parent_key_value4 => g_old_rec.parnt_acty_base_rt_id,
849: p_parent_table_name5 => 'ff_formulas_f',
850: p_parent_key_column5 => 'formula_id',

Line 875: p_base_table_name => 'ben_acty_base_rt_f',

871: --
872: dt_api.validate_dt_mode
873: (p_effective_date => p_effective_date,
874: p_datetrack_mode => p_datetrack_mode,
875: p_base_table_name => 'ben_acty_base_rt_f',
876: p_base_key_column => 'acty_base_rt_id',
877: p_base_key_value => p_acty_base_rt_id,
878: p_parent_table_name1 => 'ben_opt_f',
879: p_parent_key_column1 => 'opt_id',

Line 930: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');

926: -- The object is locked therefore we need to supply a meaningful
927: -- error message.
928: --
929: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
930: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');
931: fnd_message.raise_error;
932: When l_object_invalid then
933: --
934: -- The object doesn't exist or is invalid

Line 937: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');

933: --
934: -- The object doesn't exist or is invalid
935: --
936: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
937: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');
938: fnd_message.raise_error;
939: End lck;
940: --
941: -- ----------------------------------------------------------------------------