[Home] [Help]
107: csr_attribute28,
108: csr_attribute29,
109: csr_attribute30,
110: object_version_number
111: from ben_css_rltd_per_per_in_ler_f
112: where css_rltd_per_per_in_ler_id = p_css_rltd_per_per_in_ler_id
113: and p_effective_date
114: between effective_start_date and effective_end_date;
115: --
182: --
183: Cursor C_Sel1 Is
184: select t.ler_id,
185: t.rsltg_ler_id
186: from ben_css_rltd_per_per_in_ler_f t
187: where t.css_rltd_per_per_in_ler_id = p_base_key_value
188: and p_effective_date
189: between t.effective_start_date and t.effective_end_date;
190: --
208: -- the date track api with both values.
209: if l_parent_key_value1 = l_parent_key_value2 then
210: dt_api.find_dt_del_modes
211: (p_effective_date => p_effective_date,
212: p_base_table_name => 'ben_css_rltd_per_per_in_ler_f',
213: p_base_key_column => 'css_rltd_per_per_in_ler_id',
214: p_base_key_value => p_base_key_value,
215: p_parent_table_name1 => 'ben_ler_f',
216: p_parent_key_column1 => 'ler_id',
221: p_delete_next_change => p_delete_next_change);
222: else
223: dt_api.find_dt_del_modes
224: (p_effective_date => p_effective_date,
225: p_base_table_name => 'ben_css_rltd_per_per_in_ler_f',
226: p_base_key_column => 'css_rltd_per_per_in_ler_id',
227: p_base_key_value => p_base_key_value,
228: p_parent_table_name1 => 'ben_ler_f',
229: p_parent_key_column1 => 'ler_id',
259: -- Call the corresponding datetrack api
260: --
261: dt_api.find_dt_upd_modes
262: (p_effective_date => p_effective_date,
263: p_base_table_name => 'ben_css_rltd_per_per_in_ler_f',
264: p_base_key_column => 'css_rltd_per_per_in_ler_id',
265: p_base_key_value => p_base_key_value,
266: p_correction => p_correction,
267: p_update => p_update,
292: -- version number.
293: --
294: l_object_version_number :=
295: dt_api.get_object_version_number
296: (p_base_table_name => 'ben_css_rltd_per_per_in_ler_f',
297: p_base_key_column => 'css_rltd_per_per_in_ler_id',
298: p_base_key_value => p_base_key_value);
299: --
300: hr_utility.set_location(l_proc, 10);
302: --
303: -- Update the specified datetrack row setting the effective
304: -- end date to the specified new effective end date.
305: --
306: update ben_css_rltd_per_per_in_ler_f t
307: set t.effective_end_date = p_new_effective_end_date,
308: t.object_version_number = l_object_version_number
309: where t.css_rltd_per_per_in_ler_id = p_base_key_value
310: and p_effective_date
380: csr_attribute28,
381: csr_attribute29,
382: csr_attribute30,
383: object_version_number
384: from ben_css_rltd_per_per_in_ler_f
385: where css_rltd_per_per_in_ler_id = p_css_rltd_per_per_in_ler_id
386: and p_effective_date
387: between effective_start_date and effective_end_date
388: for update nowait;
442: if g_old_rec.ler_id = g_old_rec.rsltg_ler_id then
443: dt_api.validate_dt_mode
444: (p_effective_date => p_effective_date,
445: p_datetrack_mode => p_datetrack_mode,
446: p_base_table_name => 'ben_css_rltd_per_per_in_ler_f',
447: p_base_key_column => 'css_rltd_per_per_in_ler_id',
448: p_base_key_value => p_css_rltd_per_per_in_ler_id,
449: p_parent_table_name1 => 'ben_ler_f',
450: p_parent_key_column1 => 'ler_id',
455: else
456: dt_api.validate_dt_mode
457: (p_effective_date => p_effective_date,
458: p_datetrack_mode => p_datetrack_mode,
459: p_base_table_name => 'ben_css_rltd_per_per_in_ler_f',
460: p_base_key_column => 'css_rltd_per_per_in_ler_id',
461: p_base_key_value => p_css_rltd_per_per_in_ler_id,
462: p_parent_table_name1 => 'ben_ler_f',
463: p_parent_key_column1 => 'ler_id',
496: -- The object is locked therefore we need to supply a meaningful
497: -- error message.
498: --
499: fnd_message.set_name('PER', 'HR_7165_OBJECT_LOCKED');
500: fnd_message.set_token('TABLE_NAME', 'ben_css_rltd_per_per_in_ler_f');
501: fnd_message.raise_error;
502: When l_object_invalid then
503: --
504: -- The object doesn't exist or is invalid
503: --
504: -- The object doesn't exist or is invalid
505: --
506: fnd_message.set_name('PER', 'HR_7155_OBJECT_INVALID');
507: fnd_message.set_token('TABLE_NAME', 'ben_css_rltd_per_per_in_ler_f');
508: fnd_message.raise_error;
509: End lck;
510: --
511: -- ----------------------------------------------------------------------------