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_EGR_INS dependencies on BEN_ELIG_GRD_PRTE_F

Line 88: from ben_elig_grd_prte_f t

84: --
85: Cursor C_Sel1 Is
86: select t.created_by,
87: t.creation_date
88: from ben_elig_grd_prte_f t
89: where t.elig_grd_prte_id = p_rec.elig_grd_prte_id
90: and t.effective_start_date =
91: ben_egr_shd.g_old_rec.effective_start_date
92: and t.effective_end_date = (p_validation_start_date - 1);

Line 95: l_created_by ben_elig_grd_prte_f.created_by%TYPE;

91: ben_egr_shd.g_old_rec.effective_start_date
92: and t.effective_end_date = (p_validation_start_date - 1);
93: --
94: l_proc varchar2(72) := g_package||'dt_insert_dml';
95: l_created_by ben_elig_grd_prte_f.created_by%TYPE;
96: l_creation_date ben_elig_grd_prte_f.creation_date%TYPE;
97: l_last_update_date ben_elig_grd_prte_f.last_update_date%TYPE;
98: l_last_updated_by ben_elig_grd_prte_f.last_updated_by%TYPE;
99: l_last_update_login ben_elig_grd_prte_f.last_update_login%TYPE;

Line 96: l_creation_date ben_elig_grd_prte_f.creation_date%TYPE;

92: and t.effective_end_date = (p_validation_start_date - 1);
93: --
94: l_proc varchar2(72) := g_package||'dt_insert_dml';
95: l_created_by ben_elig_grd_prte_f.created_by%TYPE;
96: l_creation_date ben_elig_grd_prte_f.creation_date%TYPE;
97: l_last_update_date ben_elig_grd_prte_f.last_update_date%TYPE;
98: l_last_updated_by ben_elig_grd_prte_f.last_updated_by%TYPE;
99: l_last_update_login ben_elig_grd_prte_f.last_update_login%TYPE;
100: --

Line 97: l_last_update_date ben_elig_grd_prte_f.last_update_date%TYPE;

93: --
94: l_proc varchar2(72) := g_package||'dt_insert_dml';
95: l_created_by ben_elig_grd_prte_f.created_by%TYPE;
96: l_creation_date ben_elig_grd_prte_f.creation_date%TYPE;
97: l_last_update_date ben_elig_grd_prte_f.last_update_date%TYPE;
98: l_last_updated_by ben_elig_grd_prte_f.last_updated_by%TYPE;
99: l_last_update_login ben_elig_grd_prte_f.last_update_login%TYPE;
100: --
101: Begin

Line 98: l_last_updated_by ben_elig_grd_prte_f.last_updated_by%TYPE;

94: l_proc varchar2(72) := g_package||'dt_insert_dml';
95: l_created_by ben_elig_grd_prte_f.created_by%TYPE;
96: l_creation_date ben_elig_grd_prte_f.creation_date%TYPE;
97: l_last_update_date ben_elig_grd_prte_f.last_update_date%TYPE;
98: l_last_updated_by ben_elig_grd_prte_f.last_updated_by%TYPE;
99: l_last_update_login ben_elig_grd_prte_f.last_update_login%TYPE;
100: --
101: Begin
102: hr_utility.set_location('Entering:'||l_proc, 5);

Line 99: l_last_update_login ben_elig_grd_prte_f.last_update_login%TYPE;

95: l_created_by ben_elig_grd_prte_f.created_by%TYPE;
96: l_creation_date ben_elig_grd_prte_f.creation_date%TYPE;
97: l_last_update_date ben_elig_grd_prte_f.last_update_date%TYPE;
98: l_last_updated_by ben_elig_grd_prte_f.last_updated_by%TYPE;
99: l_last_update_login ben_elig_grd_prte_f.last_update_login%TYPE;
100: --
101: Begin
102: hr_utility.set_location('Entering:'||l_proc, 5);
103: --

Line 108: (p_base_table_name => 'ben_elig_grd_prte_f',

104: -- Get the object version number for the insert
105: --
106: p_rec.object_version_number :=
107: dt_api.get_object_version_number
108: (p_base_table_name => 'ben_elig_grd_prte_f',
109: p_base_key_column => 'elig_grd_prte_id',
110: p_base_key_value => p_rec.elig_grd_prte_id);
111: --
112: -- Set the effective start and end dates to the corresponding

Line 150: -- Insert the row into: ben_elig_grd_prte_f

146: End If;
147: --
148: ben_egr_shd.g_api_dml := true; -- Set the api dml status
149: --
150: -- Insert the row into: ben_elig_grd_prte_f
151: --
152: insert into ben_elig_grd_prte_f
153: ( elig_grd_prte_id,
154: effective_start_date,

Line 152: insert into ben_elig_grd_prte_f

148: ben_egr_shd.g_api_dml := true; -- Set the api dml status
149: --
150: -- Insert the row into: ben_elig_grd_prte_f
151: --
152: insert into ben_elig_grd_prte_f
153: ( elig_grd_prte_id,
154: effective_start_date,
155: effective_end_date,
156: business_group_id,

Line 343: select ben_elig_grd_prte_f_s.nextval

339: p_validation_end_date in date) is
340: --
341: --
342: cursor c1 is
343: select ben_elig_grd_prte_f_s.nextval
344: from sys.dual;
345: --
346: --
347: Cursor C_Sel2 is

Line 349: from ben_elig_grd_prte_f

345: --
346: --
347: Cursor C_Sel2 is
348: Select null
349: from ben_elig_grd_prte_f
350: where elig_grd_prte_id =
351: ben_egr_ins.g_elig_grd_prte_id_i;
352: --
353: l_proc varchar2(72) := g_package||'pre_insert';

Line 371: fnd_message.set_token('TABLE_NAME','ben_elig_grd_prte_f');

367: --
368: -- The primary key values are already in use.
369: --
370: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
371: fnd_message.set_token('TABLE_NAME','ben_elig_grd_prte_f');
372: fnd_message.raise_error;
373: End If;
374: Close C_Sel2;
375: --

Line 496: (p_module_name => 'ben_elig_grd_prte_f'

492: --
493: when hr_api.cannot_find_prog_unit then
494: --
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'ben_elig_grd_prte_f'
497: ,p_hook_type => 'AI');
498: --
499: end;
500: --

Line 564: p_base_table_name => 'ben_elig_grd_prte_f',

560: --
561: dt_api.validate_dt_mode
562: (p_effective_date => p_effective_date,
563: p_datetrack_mode => p_datetrack_mode,
564: p_base_table_name => 'ben_elig_grd_prte_f',
565: p_base_key_column => 'elig_grd_prte_id',
566: p_base_key_value => p_rec.elig_grd_prte_id,
567: p_parent_table_name1 => 'ben_eligy_prfl_f',
568: p_parent_key_column1 => 'eligy_prfl_id',