DBA Data[Home] [Help]

APPS.BEN_HRS_WKD_IN_PERIOD_RT_API dependencies on BEN_HRS_WKD_IN_PERD_RT_F

Line 59: l_hrs_wkd_in_perd_rt_id ben_hrs_wkd_in_perd_rt_f.hrs_wkd_in_perd_rt_id%TYPE;

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

Line 60: l_effective_start_date ben_hrs_wkd_in_perd_rt_f.effective_start_date%TYPE;

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

Line 61: l_effective_end_date ben_hrs_wkd_in_perd_rt_f.effective_end_date%TYPE;

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

Line 63: l_object_version_number ben_hrs_wkd_in_perd_rt_f.object_version_number%TYPE;

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

Line 243: p_reference_table => 'BEN_HRS_WKD_IN_PERD_RT_F',

239: p_base_table => 'BEN_VRBL_RT_PRFL_F',
240: p_base_table_column => 'VRBL_RT_PRFL_ID',
241: p_base_table_column_value => p_vrbl_rt_prfl_id,
242: p_base_table_reference_column => 'RT_HRS_WKD_FLAG',
243: p_reference_table => 'BEN_HRS_WKD_IN_PERD_RT_F',
244: p_reference_table_column => 'VRBL_RT_PRFL_ID');
245: --
246:
247: ben_derivable_rate.derivable_rate_handler

Line 353: l_object_version_number ben_hrs_wkd_in_perd_rt_f.object_version_number%TYPE;

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

Line 354: l_effective_start_date ben_hrs_wkd_in_perd_rt_f.effective_start_date%TYPE;

350: -- Declare cursors and local variables
351: --
352: l_proc varchar2(72) := g_package||'update_HRS_WKD_IN_PERIOD_RT';
353: l_object_version_number ben_hrs_wkd_in_perd_rt_f.object_version_number%TYPE;
354: l_effective_start_date ben_hrs_wkd_in_perd_rt_f.effective_start_date%TYPE;
355: l_effective_end_date ben_hrs_wkd_in_perd_rt_f.effective_end_date%TYPE;
356: --
357: begin
358: --

Line 355: l_effective_end_date ben_hrs_wkd_in_perd_rt_f.effective_end_date%TYPE;

351: --
352: l_proc varchar2(72) := g_package||'update_HRS_WKD_IN_PERIOD_RT';
353: l_object_version_number ben_hrs_wkd_in_perd_rt_f.object_version_number%TYPE;
354: l_effective_start_date ben_hrs_wkd_in_perd_rt_f.effective_start_date%TYPE;
355: l_effective_end_date ben_hrs_wkd_in_perd_rt_f.effective_end_date%TYPE;
356: --
357: begin
358: --
359: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 594: l_object_version_number ben_hrs_wkd_in_perd_rt_f.object_version_number%TYPE;

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

Line 595: l_effective_start_date ben_hrs_wkd_in_perd_rt_f.effective_start_date%TYPE;

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

Line 596: l_effective_end_date ben_hrs_wkd_in_perd_rt_f.effective_end_date%TYPE;

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

Line 675: p_reference_table => 'BEN_HRS_WKD_IN_PERD_RT_F',

671: p_base_table => 'BEN_VRBL_RT_PRFL_F',
672: p_base_table_column => 'VRBL_RT_PRFL_ID',
673: p_base_table_column_value => ben_hwr_shd.g_old_rec.vrbl_rt_prfl_id,
674: p_base_table_reference_column => 'RT_HRS_WKD_FLAG',
675: p_reference_table => 'BEN_HRS_WKD_IN_PERD_RT_F',
676: p_reference_table_column => 'VRBL_RT_PRFL_ID');
677: --
678: ben_derivable_rate.derivable_rate_handler
679: (p_event =>'DELETE',