69: ) is
70: --
71: -- Declare cursors and local variables
72: --
73: l_dpnt_eligy_crit_values_id ben_dpnt_eligy_crit_values_f.dpnt_eligy_crit_values_id%TYPE;
74: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
75: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
76: l_proc varchar2(72) := g_package||'create_eligy_crit_values';
77: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
70: --
71: -- Declare cursors and local variables
72: --
73: l_dpnt_eligy_crit_values_id ben_dpnt_eligy_crit_values_f.dpnt_eligy_crit_values_id%TYPE;
74: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
75: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
76: l_proc varchar2(72) := g_package||'create_eligy_crit_values';
77: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
78: --
71: -- Declare cursors and local variables
72: --
73: l_dpnt_eligy_crit_values_id ben_dpnt_eligy_crit_values_f.dpnt_eligy_crit_values_id%TYPE;
74: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
75: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
76: l_proc varchar2(72) := g_package||'create_eligy_crit_values';
77: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
78: --
79: begin
73: l_dpnt_eligy_crit_values_id ben_dpnt_eligy_crit_values_f.dpnt_eligy_crit_values_id%TYPE;
74: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
75: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
76: l_proc varchar2(72) := g_package||'create_eligy_crit_values';
77: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
78: --
79: begin
80: --
81: hr_utility.set_location('Entering:'|| l_proc, 10);
293: p_base_table => 'ben_dpnt_cvg_eligy_prfl_f',
294: p_base_table_column => 'dpnt_cvg_eligy_prfl_id',
295: p_base_table_column_value => p_dpnt_cvg_eligy_prfl_id,
296: p_base_table_reference_column => 'DPNT_CRIT_FLAG',
297: p_reference_table => 'ben_dpnt_eligy_crit_values_f',
298: p_reference_table_column => 'dpnt_cvg_eligy_prfl_id');
299: --
300: hr_utility.set_location(l_proc, 60);
301: --
413: --
414: -- Declare cursors and local variables
415: --
416: l_proc varchar2(72) := g_package||'update_eligy_crit_values';
417: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
418: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
419: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
420: --
421: begin
414: -- Declare cursors and local variables
415: --
416: l_proc varchar2(72) := g_package||'update_eligy_crit_values';
417: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
418: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
419: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
420: --
421: begin
422: --
415: --
416: l_proc varchar2(72) := g_package||'update_eligy_crit_values';
417: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
418: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
419: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
420: --
421: begin
422: --
423: hr_utility.set_location('Entering:'|| l_proc, 10);
696: --
697: -- Declare cursors and local variables
698: --
699: l_proc varchar2(72) := g_package||'delete_eligy_crit_values';
700: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
701: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
702: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
703: --
704: begin
697: -- Declare cursors and local variables
698: --
699: l_proc varchar2(72) := g_package||'delete_eligy_crit_values';
700: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
701: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
702: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
703: --
704: begin
705: --
698: --
699: l_proc varchar2(72) := g_package||'delete_eligy_crit_values';
700: l_object_version_number ben_dpnt_eligy_crit_values_f.object_version_number%TYPE;
701: l_effective_start_date ben_dpnt_eligy_crit_values_f.effective_start_date%TYPE;
702: l_effective_end_date ben_dpnt_eligy_crit_values_f.effective_end_date%TYPE;
703: --
704: begin
705: --
706: hr_utility.set_location('Entering:'|| l_proc, 10);
777: p_base_table => 'ben_dpnt_cvg_eligy_prfl_f',
778: p_base_table_column => 'dpnt_cvg_eligy_prfl_id',
779: p_base_table_column_value => ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id,
780: p_base_table_reference_column => 'DPNT_CRIT_FLAG',
781: p_reference_table => 'ben_dpnt_eligy_crit_values_f',
782: p_reference_table_column => 'dpnt_cvg_eligy_prfl_id');
783: --
784: hr_utility.set_location(l_proc, 60);
785: --