DBA Data[Home] [Help]

APPS.BEN_VRBL_MATCHING_RATE_API dependencies on BEN_VRBL_MTCHG_RT_F

Line 69: l_vrbl_mtchg_rt_id ben_vrbl_mtchg_rt_f.vrbl_mtchg_rt_id%TYPE;

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

Line 70: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;

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

Line 71: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;

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

Line 73: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;

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

Line 384: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;

380: --
381: -- Declare cursors and local variables
382: --
383: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
384: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
385: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
386: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
387: --
388: begin

Line 385: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;

381: -- Declare cursors and local variables
382: --
383: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
384: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
385: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
386: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
387: --
388: begin
389: --

Line 386: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;

382: --
383: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
384: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
385: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
386: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
387: --
388: begin
389: --
390: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 656: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;

652: --
653: -- Declare cursors and local variables
654: --
655: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
656: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
657: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
658: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
659: --
660: begin

Line 657: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;

653: -- Declare cursors and local variables
654: --
655: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
656: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
657: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
658: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
659: --
660: begin
661: --

Line 658: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;

654: --
655: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
656: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
657: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
658: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
659: --
660: begin
661: --
662: hr_utility.set_location('Entering:'|| l_proc, 10);