DBA Data[Home] [Help]

APPS.BEN_DPNT_CVD_ANTHR_PL_CVG_API dependencies on BEN_DPNT_CVRD_ANTHR_PL_CVG_F

Line 60: l_dpnt_cvrd_anthr_pl_cvg_id ben_dpnt_cvrd_anthr_pl_cvg_f.dpnt_cvrd_anthr_pl_cvg_id%TYPE;

56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_dpnt_cvrd_anthr_pl_cvg_id ben_dpnt_cvrd_anthr_pl_cvg_f.dpnt_cvrd_anthr_pl_cvg_id%TYPE;
61: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;
62: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_DPNT_CVRD_ANTHR_PL_CVG';
64: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;

Line 61: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;

57: --
58: -- Declare cursors and local variables
59: --
60: l_dpnt_cvrd_anthr_pl_cvg_id ben_dpnt_cvrd_anthr_pl_cvg_f.dpnt_cvrd_anthr_pl_cvg_id%TYPE;
61: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;
62: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_DPNT_CVRD_ANTHR_PL_CVG';
64: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;
65: --

Line 62: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;

58: -- Declare cursors and local variables
59: --
60: l_dpnt_cvrd_anthr_pl_cvg_id ben_dpnt_cvrd_anthr_pl_cvg_f.dpnt_cvrd_anthr_pl_cvg_id%TYPE;
61: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;
62: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_DPNT_CVRD_ANTHR_PL_CVG';
64: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;
65: --
66: begin

Line 64: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;

60: l_dpnt_cvrd_anthr_pl_cvg_id ben_dpnt_cvrd_anthr_pl_cvg_f.dpnt_cvrd_anthr_pl_cvg_id%TYPE;
61: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;
62: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_DPNT_CVRD_ANTHR_PL_CVG';
64: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 249: p_reference_table => 'BEN_DPNT_CVRD_ANTHR_PL_CVG_F',

245: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
246: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
247: p_base_table_column_value => p_dpnt_cvg_eligy_prfl_id,
248: p_base_table_reference_column => 'DPNT_CVRD_IN_ANTHR_PL_FLAG',
249: p_reference_table => 'BEN_DPNT_CVRD_ANTHR_PL_CVG_F',
250: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
251: --
252:
253: -- When in validation only mode raise the Validate_Enabled exception

Line 356: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;

352: --
353: -- Declare cursors and local variables
354: --
355: l_proc varchar2(72) := g_package||'update_DPNT_CVD_ANTHR_PL_CVG';
356: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;
357: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;
358: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;
359: --
360: begin

Line 357: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;

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

Line 358: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;

354: --
355: l_proc varchar2(72) := g_package||'update_DPNT_CVD_ANTHR_PL_CVG';
356: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;
357: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;
358: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;
359: --
360: begin
361: --
362: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 605: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;

601: --
602: -- Declare cursors and local variables
603: --
604: l_proc varchar2(72) := g_package||'update_DPNT_CVD_ANTHR_PL_CVG';
605: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;
606: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;
607: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;
608: --
609: begin

Line 606: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;

602: -- Declare cursors and local variables
603: --
604: l_proc varchar2(72) := g_package||'update_DPNT_CVD_ANTHR_PL_CVG';
605: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;
606: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;
607: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;
608: --
609: begin
610: --

Line 607: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;

603: --
604: l_proc varchar2(72) := g_package||'update_DPNT_CVD_ANTHR_PL_CVG';
605: l_object_version_number ben_dpnt_cvrd_anthr_pl_cvg_f.object_version_number%TYPE;
606: l_effective_start_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_start_date%TYPE;
607: l_effective_end_date ben_dpnt_cvrd_anthr_pl_cvg_f.effective_end_date%TYPE;
608: --
609: begin
610: --
611: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 688: p_reference_table => 'BEN_DPNT_CVRD_ANTHR_PL_CVG_F',

684: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
685: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
686: p_base_table_column_value => ben_dpc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id,
687: p_base_table_reference_column => 'DPNT_CVRD_IN_ANTHR_PL_FLAG',
688: p_reference_table => 'BEN_DPNT_CVRD_ANTHR_PL_CVG_F',
689: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
690: --
691: -- When in validation only mode raise the Validate_Enabled exception
692: --