[Home] [Help]
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_CLPSE_LF_EVT_F_PK') 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;
123: clp_attribute28,
124: clp_attribute29,
125: clp_attribute30,
126: object_version_number
127: from ben_clpse_lf_evt_f
128: where clpse_lf_evt_id = p_clpse_lf_evt_id
129: and p_effective_date
130: between effective_start_date and effective_end_date;
131: --
225: t.ler8_id,
226: t.ler9_id,
227: t.ler10_id,
228: t.eval_ler_id
229: from ben_clpse_lf_evt_f t
230: where t.clpse_lf_evt_id = p_base_key_value
231: and p_effective_date
232: between t.effective_start_date and t.effective_end_date;
233: --
257: -- Call the corresponding datetrack api
258: --
259: dt_api.find_dt_del_modes
260: (p_effective_date => p_effective_date,
261: p_base_table_name => 'ben_clpse_lf_evt_f',
262: p_base_key_column => 'clpse_lf_evt_id',
263: p_base_key_value => p_base_key_value,
264: p_parent_table_name1 => 'ben_ler_f',
265: p_parent_key_column1 => 'ler_id',
297: p_delete_next_change => l_delete_next_change);
298: --
299: dt_api.find_dt_del_modes
300: (p_effective_date => p_effective_date,
301: p_base_table_name => 'ben_clpse_lf_evt_f',
302: p_base_key_column => 'clpse_lf_evt_id',
303: p_base_key_value => p_base_key_value,
304: p_parent_table_name2 => 'ben_ler_f',
305: p_parent_key_column2 => 'ler_id',
372: -- Call the corresponding datetrack api
373: --
374: dt_api.find_dt_upd_modes
375: (p_effective_date => p_effective_date,
376: p_base_table_name => 'ben_clpse_lf_evt_f',
377: p_base_key_column => 'clpse_lf_evt_id',
378: p_base_key_value => p_base_key_value,
379: p_correction => p_correction,
380: p_update => p_update,
405: -- version number.
406: --
407: l_object_version_number :=
408: dt_api.get_object_version_number
409: (p_base_table_name => 'ben_clpse_lf_evt_f',
410: p_base_key_column => 'clpse_lf_evt_id',
411: p_base_key_value => p_base_key_value);
412: --
413: hr_utility.set_location(l_proc, 10);
415: --
416: -- Update the specified datetrack row setting the effective
417: -- end date to the specified new effective end date.
418: --
419: update ben_clpse_lf_evt_f t
420: set t.effective_end_date = p_new_effective_end_date,
421: t.object_version_number = l_object_version_number
422: where t.clpse_lf_evt_id = p_base_key_value
423: and p_effective_date
518: clp_attribute28,
519: clp_attribute29,
520: clp_attribute30,
521: object_version_number
522: from ben_clpse_lf_evt_f
523: where clpse_lf_evt_id = p_clpse_lf_evt_id
524: and p_effective_date
525: between effective_start_date and effective_end_date
526: for update nowait;
577: --
578: dt_api.validate_dt_mode
579: (p_effective_date => p_effective_date,
580: p_datetrack_mode => p_datetrack_mode,
581: p_base_table_name => 'ben_clpse_lf_evt_f',
582: p_base_key_column => 'clpse_lf_evt_id',
583: p_base_key_value => p_clpse_lf_evt_id,
584: p_parent_table_name1 => 'ben_ler_f',
585: p_parent_key_column1 => 'ler_id',
617: --
618: dt_api.validate_dt_mode
619: (p_effective_date => p_effective_date,
620: p_datetrack_mode => p_datetrack_mode,
621: p_base_table_name => 'ben_clpse_lf_evt_f',
622: p_base_key_column => 'clpse_lf_evt_id',
623: p_base_key_value => p_clpse_lf_evt_id,
624: p_parent_table_name1 => 'ben_ler_f',
625: p_parent_key_column1 => 'eval_ler_id',
673: -- The object is locked therefore we need to supply a meaningful
674: -- error message.
675: --
676: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
677: hr_utility.set_message_token('TABLE_NAME', 'ben_clpse_lf_evt_f');
678: hr_utility.raise_error;
679: When l_object_invalid then
680: --
681: -- The object doesn't exist or is invalid
680: --
681: -- The object doesn't exist or is invalid
682: --
683: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
684: hr_utility.set_message_token('TABLE_NAME', 'ben_clpse_lf_evt_f');
685: hr_utility.raise_error;
686: End lck;
687: --
688: -- ----------------------------------------------------------------------------