DBA Data[Home] [Help]

APPS.BEN_ELIG_AGE_CVG_API dependencies on BEN_ELIG_AGE_CVG_F

Line 62: l_elig_age_cvg_id ben_elig_age_cvg_f.elig_age_cvg_id%TYPE;

58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_elig_age_cvg_id ben_elig_age_cvg_f.elig_age_cvg_id%TYPE;
63: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ELIG_AGE_CVG';
66: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;

Line 63: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;

59: --
60: -- Declare cursors and local variables
61: --
62: l_elig_age_cvg_id ben_elig_age_cvg_f.elig_age_cvg_id%TYPE;
63: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ELIG_AGE_CVG';
66: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;
67: --

Line 64: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;

60: -- Declare cursors and local variables
61: --
62: l_elig_age_cvg_id ben_elig_age_cvg_f.elig_age_cvg_id%TYPE;
63: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ELIG_AGE_CVG';
66: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;
67: --
68: begin

Line 66: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;

62: l_elig_age_cvg_id ben_elig_age_cvg_f.elig_age_cvg_id%TYPE;
63: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ELIG_AGE_CVG';
66: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 255: p_reference_table => 'BEN_ELIG_AGE_CVG_F',

251: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
252: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
253: p_base_table_column_value => p_dpnt_cvg_eligy_prfl_id,
254: p_base_table_reference_column => 'DPNT_AGE_FLAG',
255: p_reference_table => 'BEN_ELIG_AGE_CVG_F',
256: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
257: --
258:
259: hr_utility.set_location(l_proc, 60);

Line 359: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;

355: --
356: -- Declare cursors and local variables
357: --
358: l_proc varchar2(72) := g_package||'update_ELIG_AGE_CVG';
359: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;
360: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
361: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
362: --
363: begin

Line 360: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;

356: -- Declare cursors and local variables
357: --
358: l_proc varchar2(72) := g_package||'update_ELIG_AGE_CVG';
359: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;
360: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
361: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
362: --
363: begin
364: --

Line 361: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;

357: --
358: l_proc varchar2(72) := g_package||'update_ELIG_AGE_CVG';
359: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;
360: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
361: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
362: --
363: begin
364: --
365: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 613: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;

609: --
610: -- Declare cursors and local variables
611: --
612: l_proc varchar2(72) := g_package||'update_ELIG_AGE_CVG';
613: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;
614: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
615: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
616: --
617: begin

Line 614: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;

610: -- Declare cursors and local variables
611: --
612: l_proc varchar2(72) := g_package||'update_ELIG_AGE_CVG';
613: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;
614: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
615: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
616: --
617: begin
618: --

Line 615: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;

611: --
612: l_proc varchar2(72) := g_package||'update_ELIG_AGE_CVG';
613: l_object_version_number ben_elig_age_cvg_f.object_version_number%TYPE;
614: l_effective_start_date ben_elig_age_cvg_f.effective_start_date%TYPE;
615: l_effective_end_date ben_elig_age_cvg_f.effective_end_date%TYPE;
616: --
617: begin
618: --
619: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 694: p_reference_table => 'BEN_ELIG_AGE_CVG_F',

690: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
691: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
692: p_base_table_column_value => ben_eac_shd.g_old_rec.dpnt_cvg_eligy_prfl_id,
693: p_base_table_reference_column => 'DPNT_AGE_FLAG',
694: p_reference_table => 'BEN_ELIG_AGE_CVG_F',
695: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
696: --
697: hr_utility.set_location(l_proc, 60);
698: --