DBA Data[Home] [Help]

APPS.BEN_BNFT_POOL_RLOVR_RQMT_API dependencies on BEN_BNFT_POOL_RLOVR_RQMT_F

Line 76: l_bnft_pool_rlovr_rqmt_id ben_bnft_pool_rlovr_rqmt_f.bnft_pool_rlovr_rqmt_id%TYPE;

72: ) is
73: --
74: -- Declare cursors and local variables
75: --
76: l_bnft_pool_rlovr_rqmt_id ben_bnft_pool_rlovr_rqmt_f.bnft_pool_rlovr_rqmt_id%TYPE;
77: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
78: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Bnft_Pool_Rlovr_Rqmt';
80: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;

Line 77: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;

73: --
74: -- Declare cursors and local variables
75: --
76: l_bnft_pool_rlovr_rqmt_id ben_bnft_pool_rlovr_rqmt_f.bnft_pool_rlovr_rqmt_id%TYPE;
77: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
78: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Bnft_Pool_Rlovr_Rqmt';
80: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
81: --

Line 78: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;

74: -- Declare cursors and local variables
75: --
76: l_bnft_pool_rlovr_rqmt_id ben_bnft_pool_rlovr_rqmt_f.bnft_pool_rlovr_rqmt_id%TYPE;
77: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
78: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Bnft_Pool_Rlovr_Rqmt';
80: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
81: --
82: begin

Line 80: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;

76: l_bnft_pool_rlovr_rqmt_id ben_bnft_pool_rlovr_rqmt_f.bnft_pool_rlovr_rqmt_id%TYPE;
77: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
78: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Bnft_Pool_Rlovr_Rqmt';
80: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
81: --
82: begin
83: --
84: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 419: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;

415: --
416: -- Declare cursors and local variables
417: --
418: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
419: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
420: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
421: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
422: --
423: begin

Line 420: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;

416: -- Declare cursors and local variables
417: --
418: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
419: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
420: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
421: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
422: --
423: begin
424: --

Line 421: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;

417: --
418: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
419: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
420: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
421: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
422: --
423: begin
424: --
425: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 708: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;

704: --
705: -- Declare cursors and local variables
706: --
707: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
708: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
709: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
710: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
711: --
712: begin

Line 709: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;

705: -- Declare cursors and local variables
706: --
707: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
708: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
709: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
710: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
711: --
712: begin
713: --

Line 710: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;

706: --
707: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
708: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
709: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
710: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
711: --
712: begin
713: --
714: hr_utility.set_location('Entering:'|| l_proc, 10);