DBA Data[Home] [Help]

APPS.BEN_BENEFIT_PRVDR_POOL_API dependencies on BEN_BNFT_PRVDR_POOL_F

Line 88: l_bnft_prvdr_pool_id ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE;

84: ) is
85: --
86: -- Declare cursors and local variables
87: --
88: l_bnft_prvdr_pool_id ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE;
89: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
90: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
91: l_proc varchar2(72) := g_package||'create_Benefit_Prvdr_Pool';
92: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;

Line 89: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;

85: --
86: -- Declare cursors and local variables
87: --
88: l_bnft_prvdr_pool_id ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE;
89: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
90: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
91: l_proc varchar2(72) := g_package||'create_Benefit_Prvdr_Pool';
92: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
93: --

Line 90: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;

86: -- Declare cursors and local variables
87: --
88: l_bnft_prvdr_pool_id ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE;
89: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
90: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
91: l_proc varchar2(72) := g_package||'create_Benefit_Prvdr_Pool';
92: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
93: --
94: begin

Line 92: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;

88: l_bnft_prvdr_pool_id ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE;
89: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
90: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
91: l_proc varchar2(72) := g_package||'create_Benefit_Prvdr_Pool';
92: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
93: --
94: begin
95: --
96: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 479: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;

475: --
476: -- Declare cursors and local variables
477: --
478: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
479: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
480: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
481: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
482: --
483: begin

Line 480: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;

476: -- Declare cursors and local variables
477: --
478: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
479: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
480: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
481: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
482: --
483: begin
484: --

Line 481: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;

477: --
478: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
479: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
480: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
481: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
482: --
483: begin
484: --
485: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 805: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;

801: --
802: -- Declare cursors and local variables
803: --
804: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
805: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
806: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
807: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
808: --
809: begin

Line 806: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;

802: -- Declare cursors and local variables
803: --
804: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
805: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
806: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
807: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
808: --
809: begin
810: --

Line 807: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;

803: --
804: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
805: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
806: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
807: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
808: --
809: begin
810: --
811: hr_utility.set_location('Entering:'|| l_proc, 10);