DBA Data[Home] [Help]

APPS.BEN_MATCHING_RATES_API dependencies on BEN_MTCHG_RT_F

Line 70: l_mtchg_rt_id ben_mtchg_rt_f.mtchg_rt_id%TYPE;

66: ) is
67: --
68: -- Declare cursors and local variables
69: --
70: l_mtchg_rt_id ben_mtchg_rt_f.mtchg_rt_id%TYPE;
71: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
72: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_MATCHING_RATES';
74: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;

Line 71: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;

67: --
68: -- Declare cursors and local variables
69: --
70: l_mtchg_rt_id ben_mtchg_rt_f.mtchg_rt_id%TYPE;
71: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
72: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_MATCHING_RATES';
74: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;
75: --

Line 72: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;

68: -- Declare cursors and local variables
69: --
70: l_mtchg_rt_id ben_mtchg_rt_f.mtchg_rt_id%TYPE;
71: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
72: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_MATCHING_RATES';
74: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;
75: --
76: begin

Line 74: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;

70: l_mtchg_rt_id ben_mtchg_rt_f.mtchg_rt_id%TYPE;
71: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
72: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_MATCHING_RATES';
74: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;
75: --
76: begin
77: --
78: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 393: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;

389: --
390: -- Declare cursors and local variables
391: --
392: l_proc varchar2(72) := g_package||'update_MATCHING_RATES';
393: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;
394: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
395: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
396: --
397: begin

Line 394: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;

390: -- Declare cursors and local variables
391: --
392: l_proc varchar2(72) := g_package||'update_MATCHING_RATES';
393: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;
394: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
395: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
396: --
397: begin
398: --

Line 395: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;

391: --
392: l_proc varchar2(72) := g_package||'update_MATCHING_RATES';
393: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;
394: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
395: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
396: --
397: begin
398: --
399: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 668: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;

664: --
665: -- Declare cursors and local variables
666: --
667: l_proc varchar2(72) := g_package||'update_MATCHING_RATES';
668: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;
669: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
670: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
671: --
672: begin

Line 669: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;

665: -- Declare cursors and local variables
666: --
667: l_proc varchar2(72) := g_package||'update_MATCHING_RATES';
668: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;
669: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
670: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
671: --
672: begin
673: --

Line 670: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;

666: --
667: l_proc varchar2(72) := g_package||'update_MATCHING_RATES';
668: l_object_version_number ben_mtchg_rt_f.object_version_number%TYPE;
669: l_effective_start_date ben_mtchg_rt_f.effective_start_date%TYPE;
670: l_effective_end_date ben_mtchg_rt_f.effective_end_date%TYPE;
671: --
672: begin
673: --
674: hr_utility.set_location('Entering:'|| l_proc, 10);