[Home] [Help]
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ELIG_TO_PRTE_RSN_FK1') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
128: peo_attribute28,
129: peo_attribute29,
130: peo_attribute30,
131: object_version_number
132: from ben_elig_to_prte_rsn_f
133: where elig_to_prte_rsn_id = p_elig_to_prte_rsn_id
134: and p_effective_date
135: between effective_start_date and effective_end_date;
136: --
211: t.pl_id,
212: t.pgm_id,
213: t.ptip_id,
214: t.plip_id
215: from ben_elig_to_prte_rsn_f t
216: where t.elig_to_prte_rsn_id = p_base_key_value
217: and p_effective_date
218: between t.effective_start_date and t.effective_end_date;
219: --
238: -- Call the corresponding datetrack api
239: --
240: dt_api.find_dt_del_modes
241: (p_effective_date => p_effective_date,
242: p_base_table_name => 'ben_elig_to_prte_rsn_f',
243: p_base_key_column => 'elig_to_prte_rsn_id',
244: p_base_key_value => p_base_key_value,
245: p_parent_table_name1 => 'ben_oipl_f',
246: p_parent_key_column1 => 'oipl_id',
287: -- Call the corresponding datetrack api
288: --
289: dt_api.find_dt_upd_modes
290: (p_effective_date => p_effective_date,
291: p_base_table_name => 'ben_elig_to_prte_rsn_f',
292: p_base_key_column => 'elig_to_prte_rsn_id',
293: p_base_key_value => p_base_key_value,
294: p_correction => p_correction,
295: p_update => p_update,
320: -- version number.
321: --
322: l_object_version_number :=
323: dt_api.get_object_version_number
324: (p_base_table_name => 'ben_elig_to_prte_rsn_f',
325: p_base_key_column => 'elig_to_prte_rsn_id',
326: p_base_key_value => p_base_key_value);
327: --
328: hr_utility.set_location(l_proc, 10);
330: --
331: -- Update the specified datetrack row setting the effective
332: -- end date to the specified new effective end date.
333: --
334: update ben_elig_to_prte_rsn_f t
335: set t.effective_end_date = p_new_effective_end_date,
336: t.object_version_number = l_object_version_number
337: where t.elig_to_prte_rsn_id = p_base_key_value
338: and p_effective_date
431: peo_attribute28,
432: peo_attribute29,
433: peo_attribute30,
434: object_version_number
435: from ben_elig_to_prte_rsn_f
436: where elig_to_prte_rsn_id = p_elig_to_prte_rsn_id
437: and p_effective_date
438: between effective_start_date and effective_end_date
439: for update nowait;
490: --
491: dt_api.validate_dt_mode
492: (p_effective_date => p_effective_date,
493: p_datetrack_mode => p_datetrack_mode,
494: p_base_table_name => 'ben_elig_to_prte_rsn_f',
495: p_base_key_column => 'elig_to_prte_rsn_id',
496: p_base_key_value => p_elig_to_prte_rsn_id,
497: p_parent_table_name1 => 'ben_oipl_f',
498: p_parent_key_column1 => 'oipl_id',
542: -- The object is locked therefore we need to supply a meaningful
543: -- error message.
544: --
545: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
546: hr_utility.set_message_token('TABLE_NAME', 'ben_elig_to_prte_rsn_f');
547: hr_utility.raise_error;
548: When l_object_invalid then
549: --
550: -- The object doesn't exist or is invalid
549: --
550: -- The object doesn't exist or is invalid
551: --
552: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
553: hr_utility.set_message_token('TABLE_NAME', 'ben_elig_to_prte_rsn_f');
554: hr_utility.raise_error;
555: End lck;
556: --
557: -- ----------------------------------------------------------------------------