[Home] [Help]
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_LER_CHG_DPNT_CVG_FK2') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
115: ldc_attribute30,
116: susp_if_ctfn_not_prvd_flag,
117: ctfn_determine_cd,
118: object_version_number
119: from ben_ler_chg_dpnt_cvg_f
120: where ler_chg_dpnt_cvg_id = p_ler_chg_dpnt_cvg_id
121: and p_effective_date
122: between effective_start_date and effective_end_date;
123: --
200: t.ptip_id,
201: t.ler_id,
202: t.pl_id,
203: t.pgm_id
204: from ben_ler_chg_dpnt_cvg_f t
205: where t.ler_chg_dpnt_cvg_id = p_base_key_value
206: and p_effective_date
207: between t.effective_start_date and t.effective_end_date;
208: --
228: -- Call the corresponding datetrack api
229: --
230: dt_api.find_dt_del_modes
231: (p_effective_date => p_effective_date,
232: p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
233: p_base_key_column => 'ler_chg_dpnt_cvg_id',
234: p_base_key_value => p_base_key_value,
235: p_parent_table_name1 => 'ff_formulas_f',
236: p_parent_key_column1 => 'formula_id',
280: -- Call the corresponding datetrack api
281: --
282: dt_api.find_dt_upd_modes
283: (p_effective_date => p_effective_date,
284: p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
285: p_base_key_column => 'ler_chg_dpnt_cvg_id',
286: p_base_key_value => p_base_key_value,
287: p_correction => p_correction,
288: p_update => p_update,
313: -- version number.
314: --
315: l_object_version_number :=
316: dt_api.get_object_version_number
317: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
318: p_base_key_column => 'ler_chg_dpnt_cvg_id',
319: p_base_key_value => p_base_key_value);
320: --
321: hr_utility.set_location(l_proc, 10);
323: --
324: -- Update the specified datetrack row setting the effective
325: -- end date to the specified new effective end date.
326: --
327: update ben_ler_chg_dpnt_cvg_f t
328: set t.effective_end_date = p_new_effective_end_date,
329: t.object_version_number = l_object_version_number
330: where t.ler_chg_dpnt_cvg_id = p_base_key_value
331: and p_effective_date
411: ldc_attribute30,
412: susp_if_ctfn_not_prvd_flag,
413: ctfn_determine_cd,
414: object_version_number
415: from ben_ler_chg_dpnt_cvg_f
416: where ler_chg_dpnt_cvg_id = p_ler_chg_dpnt_cvg_id
417: and p_effective_date
418: between effective_start_date and effective_end_date
419: for update nowait;
470: --
471: dt_api.validate_dt_mode
472: (p_effective_date => p_effective_date,
473: p_datetrack_mode => p_datetrack_mode,
474: p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
475: p_base_key_column => 'ler_chg_dpnt_cvg_id',
476: p_base_key_value => p_ler_chg_dpnt_cvg_id,
477: p_parent_table_name1 => 'ff_formulas_f',
478: p_parent_key_column1 => 'formula_id',
527: -- The object is locked therefore we need to supply a meaningful
528: -- error message.
529: --
530: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
531: fnd_message.set_token('TABLE_NAME', 'ben_ler_chg_dpnt_cvg_f');
532: fnd_message.raise_error;
533: When l_object_invalid then
534: --
535: -- The object doesn't exist or is invalid
534: --
535: -- The object doesn't exist or is invalid
536: --
537: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
538: fnd_message.set_token('TABLE_NAME', 'ben_ler_chg_dpnt_cvg_f');
539: fnd_message.raise_error;
540: End lck;
541: --
542: -- ----------------------------------------------------------------------------