[Home] [Help]
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_PER_INFO_CHG_CS_LER_F_FK1') Then
37: fnd_message.set_name('BEN', 'BEN_91000_INVALID_BUS_GROUP');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
37: fnd_message.set_name('BEN', 'BEN_91000_INVALID_BUS_GROUP');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_PER_INFO_CHG_CS_LER_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
110: psl_attribute28,
111: psl_attribute29,
112: psl_attribute30,
113: object_version_number
114: from ben_per_info_chg_cs_ler_f
115: where per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
116: and p_effective_date
117: between effective_start_date and effective_end_date;
118: --
190: -- Call the corresponding datetrack api
191: --
192: dt_api.find_dt_del_modes
193: (p_effective_date => p_effective_date,
194: p_base_table_name => 'ben_per_info_chg_cs_ler_f',
195: p_base_key_column => 'per_info_chg_cs_ler_id',
196: p_base_key_value => p_base_key_value,
197: p_zap => p_zap,
198: p_delete => p_delete,
221: -- Call the corresponding datetrack api
222: --
223: dt_api.find_dt_upd_modes
224: (p_effective_date => p_effective_date,
225: p_base_table_name => 'ben_per_info_chg_cs_ler_f',
226: p_base_key_column => 'per_info_chg_cs_ler_id',
227: p_base_key_value => p_base_key_value,
228: p_correction => p_correction,
229: p_update => p_update,
254: -- version number.
255: --
256: l_object_version_number :=
257: dt_api.get_object_version_number
258: (p_base_table_name => 'ben_per_info_chg_cs_ler_f',
259: p_base_key_column => 'per_info_chg_cs_ler_id',
260: p_base_key_value => p_base_key_value);
261: --
262: hr_utility.set_location(l_proc, 10);
264: --
265: -- Update the specified datetrack row setting the effective
266: -- end date to the specified new effective end date.
267: --
268: update ben_per_info_chg_cs_ler_f t
269: set t.effective_end_date = p_new_effective_end_date,
270: t.object_version_number = l_object_version_number
271: where t.per_info_chg_cs_ler_id = p_base_key_value
272: and p_effective_date
347: psl_attribute28,
348: psl_attribute29,
349: psl_attribute30,
350: object_version_number
351: from ben_per_info_chg_cs_ler_f
352: where per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
353: and p_effective_date
354: between effective_start_date and effective_end_date
355: for update nowait;
406: --
407: dt_api.validate_dt_mode
408: (p_effective_date => p_effective_date,
409: p_datetrack_mode => p_datetrack_mode,
410: p_base_table_name => 'ben_per_info_chg_cs_ler_f',
411: p_base_key_column => 'per_info_chg_cs_ler_id',
412: p_base_key_value => p_per_info_chg_cs_ler_id,
413: p_child_table_name1 => 'ben_ler_per_info_cs_ler_f',
414: p_child_key_column1 => 'ler_per_info_cs_ler_id',
442: -- The object is locked therefore we need to supply a meaningful
443: -- error message.
444: --
445: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
446: fnd_message.set_token('TABLE_NAME', 'ben_per_info_chg_cs_ler_f');
447: fnd_message.raise_error;
448: When l_object_invalid then
449: --
450: -- The object doesn't exist or is invalid
449: --
450: -- The object doesn't exist or is invalid
451: --
452: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
453: fnd_message.set_token('TABLE_NAME', 'ben_per_info_chg_cs_ler_f');
454: fnd_message.raise_error;
455: End lck;
456: --
457: -- ----------------------------------------------------------------------------