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_ELP_INS dependencies on BEN_ELIGY_PRFL_F

Line 104: from ben_eligy_prfl_f t

100: --
101: Cursor C_Sel1 Is
102: select t.created_by,
103: t.creation_date
104: from ben_eligy_prfl_f t
105: where t.eligy_prfl_id = p_rec.eligy_prfl_id
106: and t.effective_start_date =
107: ben_elp_shd.g_old_rec.effective_start_date
108: and t.effective_end_date = (p_validation_start_date - 1);

Line 111: l_created_by ben_eligy_prfl_f.created_by%TYPE;

107: ben_elp_shd.g_old_rec.effective_start_date
108: and t.effective_end_date = (p_validation_start_date - 1);
109: --
110: l_proc varchar2(72) := g_package||'dt_insert_dml';
111: l_created_by ben_eligy_prfl_f.created_by%TYPE;
112: l_creation_date ben_eligy_prfl_f.creation_date%TYPE;
113: l_last_update_date ben_eligy_prfl_f.last_update_date%TYPE;
114: l_last_updated_by ben_eligy_prfl_f.last_updated_by%TYPE;
115: l_last_update_login ben_eligy_prfl_f.last_update_login%TYPE;

Line 112: l_creation_date ben_eligy_prfl_f.creation_date%TYPE;

108: and t.effective_end_date = (p_validation_start_date - 1);
109: --
110: l_proc varchar2(72) := g_package||'dt_insert_dml';
111: l_created_by ben_eligy_prfl_f.created_by%TYPE;
112: l_creation_date ben_eligy_prfl_f.creation_date%TYPE;
113: l_last_update_date ben_eligy_prfl_f.last_update_date%TYPE;
114: l_last_updated_by ben_eligy_prfl_f.last_updated_by%TYPE;
115: l_last_update_login ben_eligy_prfl_f.last_update_login%TYPE;
116: --

Line 113: l_last_update_date ben_eligy_prfl_f.last_update_date%TYPE;

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

Line 114: l_last_updated_by ben_eligy_prfl_f.last_updated_by%TYPE;

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

Line 115: l_last_update_login ben_eligy_prfl_f.last_update_login%TYPE;

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

Line 124: (p_base_table_name => 'ben_eligy_prfl_f',

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

Line 166: -- Insert the row into: ben_eligy_prfl_f

162: End If;
163: --
164: ben_elp_shd.g_api_dml := true; -- Set the api dml status
165: --
166: -- Insert the row into: ben_eligy_prfl_f
167: --
168: insert into ben_eligy_prfl_f
169: ( eligy_prfl_id,
170: effective_start_date,

Line 168: insert into ben_eligy_prfl_f

164: ben_elp_shd.g_api_dml := true; -- Set the api dml status
165: --
166: -- Insert the row into: ben_eligy_prfl_f
167: --
168: insert into ben_eligy_prfl_f
169: ( eligy_prfl_id,
170: effective_start_date,
171: effective_end_date,
172: name,

Line 486: select ben_eligy_prfl_f_s.nextval

482: l_proc varchar2(72) := g_package||'pre_insert';
483: l_exists varchar2(1);
484: --
485: cursor c1 is
486: select ben_eligy_prfl_f_s.nextval
487: from sys.dual;
488: --
489: --
490: Cursor C_Sel2 is

Line 492: from ben_eligy_prfl_f

488: --
489: --
490: Cursor C_Sel2 is
491: Select null
492: from ben_eligy_prfl_f
493: where eligy_prfl_id =
494: ben_elp_ins.g_eligy_prfl_id_i;
495: Begin
496: hr_utility.set_location('Entering:'||l_proc, 5);

Line 512: fnd_message.set_token('TABLE_NAME','ben_eligy_prfl_f');

508: --
509: -- The primary key values are already in use.
510: --
511: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
512: fnd_message.set_token('TABLE_NAME','ben_eligy_prfl_f');
513: fnd_message.raise_error;
514: End if;
515: Close C_Sel2;
516: p_rec.eligy_prfl_id:=ben_elp_ins.g_eligy_prfl_id_i;

Line 691: (p_module_name => 'ben_eligy_prfl_f'

687: --
688: when hr_api.cannot_find_prog_unit then
689: --
690: hr_api.cannot_find_prog_unit_error
691: (p_module_name => 'ben_eligy_prfl_f'
692: ,p_hook_type => 'AI');
693: --
694: end;
695: --

Line 759: p_base_table_name => 'ben_eligy_prfl_f',

755: --
756: dt_api.validate_dt_mode
757: (p_effective_date => p_effective_date,
758: p_datetrack_mode => p_datetrack_mode,
759: p_base_table_name => 'ben_eligy_prfl_f',
760: p_base_key_column => 'eligy_prfl_id',
761: p_base_key_value => p_rec.eligy_prfl_id,
762: p_enforce_foreign_locking => true,
763: p_validation_start_date => l_validation_start_date,