DBA Data[Home] [Help]

APPS.BEN_ELIG_PSTL_CD_CVG_API dependencies on BEN_ELIG_PSTL_CD_R_RNG_CVG_F

Line 59: l_elig_pstl_cd_r_rng_cvg_id ben_elig_pstl_cd_r_rng_cvg_f.elig_pstl_cd_r_rng_cvg_id%TYPE;

55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_elig_pstl_cd_r_rng_cvg_id ben_elig_pstl_cd_r_rng_cvg_f.elig_pstl_cd_r_rng_cvg_id%TYPE;
60: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
61: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_ELIG_PSTL_CD_CVG';
63: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;

Line 60: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;

56: --
57: -- Declare cursors and local variables
58: --
59: l_elig_pstl_cd_r_rng_cvg_id ben_elig_pstl_cd_r_rng_cvg_f.elig_pstl_cd_r_rng_cvg_id%TYPE;
60: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
61: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_ELIG_PSTL_CD_CVG';
63: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;
64: --

Line 61: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;

57: -- Declare cursors and local variables
58: --
59: l_elig_pstl_cd_r_rng_cvg_id ben_elig_pstl_cd_r_rng_cvg_f.elig_pstl_cd_r_rng_cvg_id%TYPE;
60: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
61: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_ELIG_PSTL_CD_CVG';
63: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;
64: --
65: begin

Line 63: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;

59: l_elig_pstl_cd_r_rng_cvg_id ben_elig_pstl_cd_r_rng_cvg_f.elig_pstl_cd_r_rng_cvg_id%TYPE;
60: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
61: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_ELIG_PSTL_CD_CVG';
63: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 245: p_reference_table => 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F',

241: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
242: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
243: p_base_table_column_value => p_dpnt_cvg_eligy_prfl_id,
244: p_base_table_reference_column => 'DPNT_PSTL_FLAG',
245: p_reference_table => 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F',
246: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
247: --
248:
249: -- When in validation only mode raise the Validate_Enabled exception

Line 350: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;

346: --
347: -- Declare cursors and local variables
348: --
349: l_proc varchar2(72) := g_package||'update_ELIG_PSTL_CD_CVG';
350: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;
351: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
352: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
353: --
354: begin

Line 351: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;

347: -- Declare cursors and local variables
348: --
349: l_proc varchar2(72) := g_package||'update_ELIG_PSTL_CD_CVG';
350: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;
351: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
352: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
353: --
354: begin
355: --

Line 352: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;

348: --
349: l_proc varchar2(72) := g_package||'update_ELIG_PSTL_CD_CVG';
350: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;
351: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
352: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
353: --
354: begin
355: --
356: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 598: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;

594: --
595: -- Declare cursors and local variables
596: --
597: l_proc varchar2(72) := g_package||'update_ELIG_PSTL_CD_CVG';
598: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;
599: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
600: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
601: --
602: begin

Line 599: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;

595: -- Declare cursors and local variables
596: --
597: l_proc varchar2(72) := g_package||'update_ELIG_PSTL_CD_CVG';
598: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;
599: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
600: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
601: --
602: begin
603: --

Line 600: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;

596: --
597: l_proc varchar2(72) := g_package||'update_ELIG_PSTL_CD_CVG';
598: l_object_version_number ben_elig_pstl_cd_r_rng_cvg_f.object_version_number%TYPE;
599: l_effective_start_date ben_elig_pstl_cd_r_rng_cvg_f.effective_start_date%TYPE;
600: l_effective_end_date ben_elig_pstl_cd_r_rng_cvg_f.effective_end_date%TYPE;
601: --
602: begin
603: --
604: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 681: p_reference_table => 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F',

677: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
678: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
679: p_base_table_column_value => ben_epl_shd.g_old_rec.dpnt_cvg_eligy_prfl_id,
680: p_base_table_reference_column => 'DPNT_PSTL_FLAG',
681: p_reference_table => 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F',
682: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
683: --
684: -- When in validation only mode raise the Validate_Enabled exception
685: --