[Home] [Help]
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_VRBL_RT_PRFL_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;
197: rt_dpnt_othr_ptip_flag,
198: rt_qua_in_gr_flag,
199: rt_perf_rtng_flag,
200: rt_elig_prfl_flag
201: from ben_vrbl_rt_prfl_f
202: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
203: and p_effective_date
204: between effective_start_date and effective_end_date;
205: --
274: Cursor C_Sel1 Is
275: select t.oipl_id,
276: t.pl_typ_opt_typ_id,
277: t.pl_id
278: from ben_vrbl_rt_prfl_f t
279: where t.vrbl_rt_prfl_id = p_base_key_value
280: and p_effective_date
281: between t.effective_start_date and t.effective_end_date;
282: --
298: -- Call the corresponding datetrack api
299: --
300: dt_api.find_dt_del_modes
301: (p_effective_date => p_effective_date,
302: p_base_table_name => 'ben_vrbl_rt_prfl_f',
303: p_base_key_column => 'vrbl_rt_prfl_id',
304: p_base_key_value => p_base_key_value,
305: p_parent_table_name1 => 'ben_oipl_f',
306: p_parent_key_column1 => 'oipl_id',
335: -- Call the corresponding datetrack api
336: --
337: dt_api.find_dt_upd_modes
338: (p_effective_date => p_effective_date,
339: p_base_table_name => 'ben_vrbl_rt_prfl_f',
340: p_base_key_column => 'vrbl_rt_prfl_id',
341: p_base_key_value => p_base_key_value,
342: p_correction => p_correction,
343: p_update => p_update,
368: -- version number.
369: --
370: l_object_version_number :=
371: dt_api.get_object_version_number
372: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
373: p_base_key_column => 'vrbl_rt_prfl_id',
374: p_base_key_value => p_base_key_value);
375: --
376: hr_utility.set_location(l_proc, 10);
378: --
379: -- Update the specified datetrack row setting the effective
380: -- end date to the specified new effective end date.
381: --
382: update ben_vrbl_rt_prfl_f t
383: set t.effective_end_date = p_new_effective_end_date,
384: t.object_version_number = l_object_version_number
385: where t.vrbl_rt_prfl_id = p_base_key_value
386: and p_effective_date
552: rt_dpnt_othr_ptip_flag,
553: rt_qua_in_gr_flag,
554: rt_perf_rtng_flag,
555: rt_elig_prfl_flag
556: from ben_vrbl_rt_prfl_f
557: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
558: and p_effective_date
559: between effective_start_date and effective_end_date
560: for update nowait;
610: --
611: dt_api.validate_dt_mode
612: (p_effective_date => p_effective_date,
613: p_datetrack_mode => p_datetrack_mode,
614: p_base_table_name => 'ben_vrbl_rt_prfl_f',
615: p_base_key_column => 'vrbl_rt_prfl_id',
616: p_base_key_value => p_vrbl_rt_prfl_id,
617: p_parent_table_name1 => 'ben_oipl_f',
618: p_parent_key_column1 => 'oipl_id',
648:
649: dt_api.validate_dt_mode
650: (p_effective_date => p_effective_date,
651: p_datetrack_mode => p_datetrack_mode,
652: p_base_table_name => 'ben_vrbl_rt_prfl_f',
653: p_base_key_column => 'vrbl_rt_prfl_id',
654: p_base_key_value => p_vrbl_rt_prfl_id,
655: p_parent_table_name1 => 'ben_oipl_f',
656: p_parent_key_column1 => 'oipl_id',
685: --
686: dt_api.validate_dt_mode
687: (p_effective_date => p_effective_date,
688: p_datetrack_mode => p_datetrack_mode,
689: p_base_table_name => 'ben_vrbl_rt_prfl_f',
690: p_base_key_column => 'vrbl_rt_prfl_id',
691: p_base_key_value => p_vrbl_rt_prfl_id,
692: p_parent_table_name1 => 'ben_oipl_f',
693: p_parent_key_column1 => 'oipl_id',
724:
725: dt_api.validate_dt_mode
726: (p_effective_date => p_effective_date,
727: p_datetrack_mode => p_datetrack_mode,
728: p_base_table_name => 'ben_vrbl_rt_prfl_f',
729: p_base_key_column => 'vrbl_rt_prfl_id',
730: p_base_key_value => p_vrbl_rt_prfl_id,
731: p_parent_table_name1 => 'ben_oipl_f',
732: p_parent_key_column1 => 'oipl_id',
761:
762: dt_api.validate_dt_mode
763: (p_effective_date => p_effective_date,
764: p_datetrack_mode => p_datetrack_mode,
765: p_base_table_name => 'ben_vrbl_rt_prfl_f',
766: p_base_key_column => 'vrbl_rt_prfl_id',
767: p_base_key_value => p_vrbl_rt_prfl_id,
768: p_parent_table_name1 => 'ben_oipl_f',
769: p_parent_key_column1 => 'oipl_id',
799:
800: dt_api.validate_dt_mode
801: (p_effective_date => p_effective_date,
802: p_datetrack_mode => p_datetrack_mode,
803: p_base_table_name => 'ben_vrbl_rt_prfl_f',
804: p_base_key_column => 'vrbl_rt_prfl_id',
805: p_base_key_value => p_vrbl_rt_prfl_id,
806: p_parent_table_name1 => 'ben_oipl_f',
807: p_parent_key_column1 => 'oipl_id',
894: -- The object is locked therefore we need to supply a meaningful
895: -- error message.
896: --
897: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
898: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');
899: hr_utility.raise_error;
900: When l_object_invalid then
901: --
902: -- The object doesn't exist or is invalid
901: --
902: -- The object doesn't exist or is invalid
903: --
904: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
905: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');
906: hr_utility.raise_error;
907: End lck;
908: --
909: -- ----------------------------------------------------------------------------