DBA Data[Home] [Help]

APPS.BEN_JOB_RT_API dependencies on BEN_JOB_RT_F

Line 59: l_job_rt_id ben_job_rt_f.job_rt_id%TYPE;

55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_job_rt_id ben_job_rt_f.job_rt_id%TYPE;
60: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_JOB_RT';
63: l_object_version_number ben_job_rt_f.object_version_number%TYPE;

Line 60: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;

56: --
57: -- Declare cursors and local variables
58: --
59: l_job_rt_id ben_job_rt_f.job_rt_id%TYPE;
60: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_JOB_RT';
63: l_object_version_number ben_job_rt_f.object_version_number%TYPE;
64: --

Line 61: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;

57: -- Declare cursors and local variables
58: --
59: l_job_rt_id ben_job_rt_f.job_rt_id%TYPE;
60: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_JOB_RT';
63: l_object_version_number ben_job_rt_f.object_version_number%TYPE;
64: --
65: begin

Line 63: l_object_version_number ben_job_rt_f.object_version_number%TYPE;

59: l_job_rt_id ben_job_rt_f.job_rt_id%TYPE;
60: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_JOB_RT';
63: l_object_version_number ben_job_rt_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 244: p_reference_table => 'BEN_JOB_RT_F',

240: p_base_table => 'BEN_VRBL_RT_PRFL_F',
241: p_base_table_column => 'VRBL_RT_PRFL_ID',
242: p_base_table_column_value => p_vrbl_rt_prfl_id,
243: p_base_table_reference_column => 'RT_JOB_FLAG',
244: p_reference_table => 'BEN_JOB_RT_F',
245: p_reference_table_column => 'VRBL_RT_PRFL_ID');
246: --
247: hr_utility.set_location(l_proc, 60);
248: --

Line 350: l_object_version_number ben_job_rt_f.object_version_number%TYPE;

346: --
347: -- Declare cursors and local variables
348: --
349: l_proc varchar2(72) := g_package||'update_JOB_RT';
350: l_object_version_number ben_job_rt_f.object_version_number%TYPE;
351: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
352: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
353: --
354: begin

Line 351: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;

347: -- Declare cursors and local variables
348: --
349: l_proc varchar2(72) := g_package||'update_JOB_RT';
350: l_object_version_number ben_job_rt_f.object_version_number%TYPE;
351: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
352: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
353: --
354: begin
355: --

Line 352: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;

348: --
349: l_proc varchar2(72) := g_package||'update_JOB_RT';
350: l_object_version_number ben_job_rt_f.object_version_number%TYPE;
351: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
352: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
353: --
354: begin
355: --
356: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 593: l_object_version_number ben_job_rt_f.object_version_number%TYPE;

589: --
590: -- Declare cursors and local variables
591: --
592: l_proc varchar2(72) := g_package||'update_JOB_RT';
593: l_object_version_number ben_job_rt_f.object_version_number%TYPE;
594: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
595: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
596: --
597: begin

Line 594: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;

590: -- Declare cursors and local variables
591: --
592: l_proc varchar2(72) := g_package||'update_JOB_RT';
593: l_object_version_number ben_job_rt_f.object_version_number%TYPE;
594: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
595: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
596: --
597: begin
598: --

Line 595: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;

591: --
592: l_proc varchar2(72) := g_package||'update_JOB_RT';
593: l_object_version_number ben_job_rt_f.object_version_number%TYPE;
594: l_effective_start_date ben_job_rt_f.effective_start_date%TYPE;
595: l_effective_end_date ben_job_rt_f.effective_end_date%TYPE;
596: --
597: begin
598: --
599: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 674: p_reference_table => 'BEN_JOB_RT_F',

670: p_base_table => 'BEN_VRBL_RT_PRFL_F',
671: p_base_table_column => 'VRBL_RT_PRFL_ID',
672: p_base_table_column_value => ben_jrt_shd.g_old_rec.vrbl_rt_prfl_id,
673: p_base_table_reference_column => 'RT_JOB_FLAG',
674: p_reference_table => 'BEN_JOB_RT_F',
675: p_reference_table_column => 'VRBL_RT_PRFL_ID');
676: --
677: hr_utility.set_location(l_proc, 60);
678: --