DBA Data[Home] [Help]

APPS.BEN_SCHEDD_HRS_RATE_API dependencies on BEN_SCHEDD_HRS_RT_F

Line 66: l_schedd_hrs_rt_id ben_schedd_hrs_rt_f.schedd_hrs_rt_id%TYPE;

62: ) is
63: --
64: -- Declare cursors and local variables
65: --
66: l_schedd_hrs_rt_id ben_schedd_hrs_rt_f.schedd_hrs_rt_id%TYPE;
67: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;
68: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_SCHEDD_HRS_RATE';
70: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;

Line 67: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;

63: --
64: -- Declare cursors and local variables
65: --
66: l_schedd_hrs_rt_id ben_schedd_hrs_rt_f.schedd_hrs_rt_id%TYPE;
67: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;
68: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_SCHEDD_HRS_RATE';
70: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;
71: --

Line 68: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;

64: -- Declare cursors and local variables
65: --
66: l_schedd_hrs_rt_id ben_schedd_hrs_rt_f.schedd_hrs_rt_id%TYPE;
67: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;
68: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_SCHEDD_HRS_RATE';
70: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;
71: --
72: begin

Line 70: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;

66: l_schedd_hrs_rt_id ben_schedd_hrs_rt_f.schedd_hrs_rt_id%TYPE;
67: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;
68: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_SCHEDD_HRS_RATE';
70: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;
71: --
72: begin
73: --
74: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 271: p_reference_table => 'BEN_SCHEDD_HRS_RT_F',

267: p_base_table => 'BEN_VRBL_RT_PRFL_F',
268: p_base_table_column => 'VRBL_RT_PRFL_ID',
269: p_base_table_column_value => p_vrbl_rt_prfl_id,
270: p_base_table_reference_column => 'RT_SCHEDD_HRS_FLAG',
271: p_reference_table => 'BEN_SCHEDD_HRS_RT_F',
272: p_reference_table_column => 'VRBL_RT_PRFL_ID');
273: --
274: hr_utility.set_location(l_proc, 60);
275: --

Line 382: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;

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

Line 383: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;

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

Line 384: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;

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

Line 643: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;

639: --
640: -- Declare cursors and local variables
641: --
642: l_proc varchar2(72) := g_package||'update_SCHEDD_HRS_RATE';
643: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;
644: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;
645: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;
646: --
647: begin

Line 644: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;

640: -- Declare cursors and local variables
641: --
642: l_proc varchar2(72) := g_package||'update_SCHEDD_HRS_RATE';
643: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;
644: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;
645: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;
646: --
647: begin
648: --

Line 645: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;

641: --
642: l_proc varchar2(72) := g_package||'update_SCHEDD_HRS_RATE';
643: l_object_version_number ben_schedd_hrs_rt_f.object_version_number%TYPE;
644: l_effective_start_date ben_schedd_hrs_rt_f.effective_start_date%TYPE;
645: l_effective_end_date ben_schedd_hrs_rt_f.effective_end_date%TYPE;
646: --
647: begin
648: --
649: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 724: p_reference_table => 'BEN_SCHEDD_HRS_RT_F',

720: p_base_table => 'BEN_VRBL_RT_PRFL_F',
721: p_base_table_column => 'VRBL_RT_PRFL_ID',
722: p_base_table_column_value => ben_shr_shd.g_old_rec.vrbl_rt_prfl_id,
723: p_base_table_reference_column => 'RT_SCHEDD_HRS_FLAG',
724: p_reference_table => 'BEN_SCHEDD_HRS_RT_F',
725: p_reference_table_column => 'VRBL_RT_PRFL_ID');
726: --
727: hr_utility.set_location(l_proc, 60);
728: --