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

Line 69: from ben_acty_base_rt_f t

65: --
66: Cursor C_Sel1 Is
67: select t.created_by,
68: t.creation_date
69: from ben_acty_base_rt_f t
70: where t.acty_base_rt_id = p_rec.acty_base_rt_id
71: and t.effective_start_date =
72: ben_abr_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);

Line 112: l_created_by ben_acty_base_rt_f.created_by%TYPE;

108: --End of Code for Bug 6881417
109:
110: --
111: l_proc varchar2(72) := g_package||'dt_insert_dml';
112: l_created_by ben_acty_base_rt_f.created_by%TYPE;
113: l_creation_date ben_acty_base_rt_f.creation_date%TYPE;
114: l_last_update_date ben_acty_base_rt_f.last_update_date%TYPE;
115: l_last_updated_by ben_acty_base_rt_f.last_updated_by%TYPE;
116: l_last_update_login ben_acty_base_rt_f.last_update_login%TYPE;

Line 113: l_creation_date ben_acty_base_rt_f.creation_date%TYPE;

109:
110: --
111: l_proc varchar2(72) := g_package||'dt_insert_dml';
112: l_created_by ben_acty_base_rt_f.created_by%TYPE;
113: l_creation_date ben_acty_base_rt_f.creation_date%TYPE;
114: l_last_update_date ben_acty_base_rt_f.last_update_date%TYPE;
115: l_last_updated_by ben_acty_base_rt_f.last_updated_by%TYPE;
116: l_last_update_login ben_acty_base_rt_f.last_update_login%TYPE;
117: --

Line 114: l_last_update_date ben_acty_base_rt_f.last_update_date%TYPE;

110: --
111: l_proc varchar2(72) := g_package||'dt_insert_dml';
112: l_created_by ben_acty_base_rt_f.created_by%TYPE;
113: l_creation_date ben_acty_base_rt_f.creation_date%TYPE;
114: l_last_update_date ben_acty_base_rt_f.last_update_date%TYPE;
115: l_last_updated_by ben_acty_base_rt_f.last_updated_by%TYPE;
116: l_last_update_login ben_acty_base_rt_f.last_update_login%TYPE;
117: --
118: Begin

Line 115: l_last_updated_by ben_acty_base_rt_f.last_updated_by%TYPE;

111: l_proc varchar2(72) := g_package||'dt_insert_dml';
112: l_created_by ben_acty_base_rt_f.created_by%TYPE;
113: l_creation_date ben_acty_base_rt_f.creation_date%TYPE;
114: l_last_update_date ben_acty_base_rt_f.last_update_date%TYPE;
115: l_last_updated_by ben_acty_base_rt_f.last_updated_by%TYPE;
116: l_last_update_login ben_acty_base_rt_f.last_update_login%TYPE;
117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);

Line 116: l_last_update_login ben_acty_base_rt_f.last_update_login%TYPE;

112: l_created_by ben_acty_base_rt_f.created_by%TYPE;
113: l_creation_date ben_acty_base_rt_f.creation_date%TYPE;
114: l_last_update_date ben_acty_base_rt_f.last_update_date%TYPE;
115: l_last_updated_by ben_acty_base_rt_f.last_updated_by%TYPE;
116: l_last_update_login ben_acty_base_rt_f.last_update_login%TYPE;
117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --

Line 125: (p_base_table_name => 'ben_acty_base_rt_f',

121: -- Get the object version number for the insert
122: --
123: p_rec.object_version_number :=
124: dt_api.get_object_version_number
125: (p_base_table_name => 'ben_acty_base_rt_f',
126: p_base_key_column => 'acty_base_rt_id',
127: p_base_key_value => p_rec.acty_base_rt_id);
128: --
129: -- Set the effective start and end dates to the corresponding

Line 167: -- Insert the row into: ben_acty_base_rt_f

163: End If;
164: --
165: ben_abr_shd.g_api_dml := true; -- Set the api dml status
166: --
167: -- Insert the row into: ben_acty_base_rt_f
168: --
169: hr_utility.set_location('total rate befr insert '||p_rec.TTL_COMP_LVL_FCTR_ID, 99);
170:
171: --Added for Bug 6881417

Line 214: insert into ben_acty_base_rt_f

210: if(ben_abr_bus.g_ssben_call and l_opt_typ_cd='ICM') then
211:
212: fnd_file.put_line(fnd_file.log, 'Element and Input Value not copied for Rate Defintion '||p_rec.name);
213: ben_abr_bus.g_ssben_var := ben_abr_bus.g_ssben_var || p_rec.name ||' ,';
214: insert into ben_acty_base_rt_f
215: ( acty_base_rt_id,
216: effective_start_date,
217: effective_end_date,
218: ordr_num,

Line 501: insert into ben_acty_base_rt_f

497: l_last_updated_by,
498: l_last_update_login
499: );
500: else
501: insert into ben_acty_base_rt_f
502: ( acty_base_rt_id,
503: effective_start_date,
504: effective_end_date,
505: ordr_num,

Line 883: select BEN_ACTY_BASE_RT_F_S.nextval

879: --
880: l_proc varchar2(72) := g_package||'pre_insert';
881: --
882: cursor c1 is
883: select BEN_ACTY_BASE_RT_F_S.nextval
884: from sys.dual;
885: --
886: cursor c_oipl is
887: select opt_id, pl_id

Line 1191: (p_module_name => 'ben_acty_base_rt_f'

1187: --
1188: when hr_api.cannot_find_prog_unit then
1189: --
1190: hr_api.cannot_find_prog_unit_error
1191: (p_module_name => 'ben_acty_base_rt_f'
1192: ,p_hook_type => 'AI');
1193: --
1194: end;
1195: --

Line 1262: p_base_table_name => 'ben_acty_base_rt_f',

1258: --
1259: dt_api.validate_dt_mode
1260: (p_effective_date => p_effective_date,
1261: p_datetrack_mode => p_datetrack_mode,
1262: p_base_table_name => 'ben_acty_base_rt_f',
1263: p_base_key_column => 'acty_base_rt_id',
1264: p_base_key_value => p_rec.acty_base_rt_id,
1265: p_parent_table_name1 => 'ff_formulas_f',
1266: p_parent_key_column1 => 'formula_id',

Line 1299: p_base_table_name => 'ben_acty_base_rt_f',

1295: --
1296: dt_api.validate_dt_mode
1297: (p_effective_date => p_effective_date,
1298: p_datetrack_mode => p_datetrack_mode,
1299: p_base_table_name => 'ben_acty_base_rt_f',
1300: p_base_key_column => 'acty_base_rt_id',
1301: p_base_key_value => p_rec.acty_base_rt_id,
1302: p_parent_table_name1 => 'ben_plip_f',
1303: p_parent_key_column1 => 'plip_id',

Line 1308: p_parent_table_name3 => 'ben_acty_base_rt_f',

1304: p_parent_key_value1 => p_rec.plip_id,
1305: p_parent_table_name2 => 'ben_pl_f',
1306: p_parent_key_column2 => 'pl_id',
1307: p_parent_key_value2 => p_rec.pl_id,
1308: p_parent_table_name3 => 'ben_acty_base_rt_f',
1309: p_parent_key_column3 => 'acty_base_rt_id',
1310: p_parent_key_value3 => p_rec.parnt_acty_base_rt_id,
1311: p_parent_table_name4 => 'ben_oiplip_f',
1312: p_parent_key_column4 => 'oiplip_id',