DBA Data[Home] [Help]

APPS.BEN_DPNT_CVG_ELIG_PRFL_API dependencies on BEN_DPNT_CVG_ELIGY_PRFL_F

Line 69: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;

65: ) is
66: --
67: -- Declare cursors and local variables
68: --
69: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
70: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
71: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
73: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;

Line 70: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;

66: --
67: -- Declare cursors and local variables
68: --
69: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
70: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
71: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
73: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
74: --

Line 71: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;

67: -- Declare cursors and local variables
68: --
69: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
70: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
71: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
73: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
74: --
75: begin

Line 73: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;

69: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
70: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
71: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
73: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
74: --
75: begin
76: --
77: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 389: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;

385: --
386: -- Declare cursors and local variables
387: --
388: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
389: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
390: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
391: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
392: --
393: begin

Line 390: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;

386: -- Declare cursors and local variables
387: --
388: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
389: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
390: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
391: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
392: --
393: begin
394: --

Line 391: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;

387: --
388: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
389: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
390: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
391: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
392: --
393: begin
394: --
395: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 661: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;

657: --
658: -- Declare cursors and local variables
659: --
660: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
661: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
662: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
663: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
664: --
665: begin

Line 662: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;

658: -- Declare cursors and local variables
659: --
660: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
661: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
662: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
663: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
664: --
665: begin
666: --

Line 663: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;

659: --
660: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
661: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
662: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
663: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
664: --
665: begin
666: --
667: hr_utility.set_location('Entering:'|| l_proc, 10);