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);
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;
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: --
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
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);
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: --
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
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,
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,
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
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';
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: --
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: --
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',