DBA Data[Home] [Help]

APPS.BEN_DPNT_CVRD_OTHR_PGM_RT_API dependencies on BEN_DPNT_CVRD_OTHR_PGM_RT_F

Line 61: l_dpnt_cvrd_othr_pgm_rt_id ben_dpnt_cvrd_othr_pgm_rt_f.dpnt_cvrd_othr_pgm_rt_id%TYPE;

57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_dpnt_cvrd_othr_pgm_rt_id ben_dpnt_cvrd_othr_pgm_rt_f.dpnt_cvrd_othr_pgm_rt_id%TYPE;
62: l_effective_start_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_start_date%TYPE;
63: l_effective_end_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_DPNT_CVRD_OTHR_PGM_RT';
65: l_object_version_number ben_dpnt_cvrd_othr_pgm_rt_f.object_version_number%TYPE;

Line 62: l_effective_start_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_start_date%TYPE;

58: --
59: -- Declare cursors and local variables
60: --
61: l_dpnt_cvrd_othr_pgm_rt_id ben_dpnt_cvrd_othr_pgm_rt_f.dpnt_cvrd_othr_pgm_rt_id%TYPE;
62: l_effective_start_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_start_date%TYPE;
63: l_effective_end_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_DPNT_CVRD_OTHR_PGM_RT';
65: l_object_version_number ben_dpnt_cvrd_othr_pgm_rt_f.object_version_number%TYPE;
66: --

Line 63: l_effective_end_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_end_date%TYPE;

59: -- Declare cursors and local variables
60: --
61: l_dpnt_cvrd_othr_pgm_rt_id ben_dpnt_cvrd_othr_pgm_rt_f.dpnt_cvrd_othr_pgm_rt_id%TYPE;
62: l_effective_start_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_start_date%TYPE;
63: l_effective_end_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_DPNT_CVRD_OTHR_PGM_RT';
65: l_object_version_number ben_dpnt_cvrd_othr_pgm_rt_f.object_version_number%TYPE;
66: --
67: begin

Line 65: l_object_version_number ben_dpnt_cvrd_othr_pgm_rt_f.object_version_number%TYPE;

61: l_dpnt_cvrd_othr_pgm_rt_id ben_dpnt_cvrd_othr_pgm_rt_f.dpnt_cvrd_othr_pgm_rt_id%TYPE;
62: l_effective_start_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_start_date%TYPE;
63: l_effective_end_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_DPNT_CVRD_OTHR_PGM_RT';
65: l_object_version_number ben_dpnt_cvrd_othr_pgm_rt_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 251: p_reference_table => 'BEN_DPNT_CVRD_OTHR_PGM_RT_F',

247: p_base_table => 'BEN_VRBL_RT_PRFL_F',
248: p_base_table_column => 'VRBL_RT_PRFL_ID',
249: p_base_table_column_value => p_vrbl_rt_prfl_id,
250: p_base_table_reference_column => 'RT_DPNT_CVRD_PGM_FLAG',
251: p_reference_table => 'BEN_DPNT_CVRD_OTHR_PGM_RT_F',
252: p_reference_table_column => 'VRBL_RT_PRFL_ID');
253: --
254: hr_utility.set_location(l_proc, 60);
255: --

Line 360: l_object_version_number ben_dpnt_cvrd_othr_pgm_rt_f.object_version_number%TYPE;

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

Line 361: l_effective_start_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_start_date%TYPE;

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

Line 362: l_effective_end_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_end_date%TYPE;

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

Line 614: l_object_version_number ben_dpnt_cvrd_othr_pgm_rt_f.object_version_number%TYPE;

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

Line 615: l_effective_start_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_start_date%TYPE;

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

Line 616: l_effective_end_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_end_date%TYPE;

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

Line 695: p_reference_table => 'BEN_DPNT_CVRD_OTHR_PGM_RT_F',

691: p_base_table => 'BEN_VRBL_RT_PRFL_F',
692: p_base_table_column => 'VRBL_RT_PRFL_ID',
693: p_base_table_column_value => ben_dop_shd.g_old_rec.vrbl_rt_prfl_id,
694: p_base_table_reference_column => 'RT_DPNT_CVRD_PGM_FLAG',
695: p_reference_table => 'BEN_DPNT_CVRD_OTHR_PGM_RT_F',
696: p_reference_table_column => 'VRBL_RT_PRFL_ID');
697: --
698: hr_utility.set_location(l_proc, 60);
699: --