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_EJP_INS dependencies on BEN_ELIG_JOB_PRTE_F

Line 87: from ben_elig_job_prte_f t

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

Line 94: l_created_by ben_elig_job_prte_f.created_by%TYPE;

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

Line 95: l_creation_date ben_elig_job_prte_f.creation_date%TYPE;

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

Line 96: l_last_update_date ben_elig_job_prte_f.last_update_date%TYPE;

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

Line 97: l_last_updated_by ben_elig_job_prte_f.last_updated_by%TYPE;

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

Line 98: l_last_update_login ben_elig_job_prte_f.last_update_login%TYPE;

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

Line 107: (p_base_table_name => 'ben_elig_job_prte_f',

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

Line 149: -- Insert the row into: ben_elig_job_prte_f

145: End If;
146: --
147: ben_ejp_shd.g_api_dml := true; -- Set the api dml status
148: --
149: -- Insert the row into: ben_elig_job_prte_f
150: --
151: insert into ben_elig_job_prte_f
152: ( elig_job_prte_id,
153: effective_start_date,

Line 151: insert into ben_elig_job_prte_f

147: ben_ejp_shd.g_api_dml := true; -- Set the api dml status
148: --
149: -- Insert the row into: ben_elig_job_prte_f
150: --
151: insert into ben_elig_job_prte_f
152: ( elig_job_prte_id,
153: effective_start_date,
154: effective_end_date,
155: ordr_num,

Line 341: select ben_elig_job_prte_f_s.nextval

337: p_validation_start_date in date,
338: p_validation_end_date in date) is
339: --
340: cursor c1 is
341: select ben_elig_job_prte_f_s.nextval
342: from sys.dual;
343: --
344: --
345: Cursor C_Sel2 is

Line 347: from ben_elig_job_prte_f

343: --
344: --
345: Cursor C_Sel2 is
346: Select null
347: from ben_elig_job_prte_f
348: where elig_job_prte_id = ben_ejp_ins.g_elig_job_prte_id_i;
349: --
350: l_proc varchar2(72) := g_package||'pre_insert';
351: l_exists varchar2(1);

Line 368: fnd_message.set_token('TABLE_NAME','ben_elig_job_prte_f');

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

Line 494: (p_module_name => 'ben_elig_job_prte_f'

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

Line 562: p_base_table_name => 'ben_elig_job_prte_f',

558: --
559: dt_api.validate_dt_mode
560: (p_effective_date => p_effective_date,
561: p_datetrack_mode => p_datetrack_mode,
562: p_base_table_name => 'ben_elig_job_prte_f',
563: p_base_key_column => 'elig_job_prte_id',
564: p_base_key_value => p_rec.elig_job_prte_id,
565: p_parent_table_name1 => 'ben_eligy_prfl_f',
566: p_parent_key_column1 => 'eligy_prfl_id',