DBA Data[Home] [Help]

APPS.BEN_QUA_IN_GR_RT_API dependencies on BEN_QUA_IN_GR_RT_F

Line 59: l_qua_in_gr_rt_id ben_qua_in_gr_rt_f.qua_in_gr_rt_id%TYPE;

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

Line 60: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;

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

Line 61: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;

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

Line 63: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;

59: l_qua_in_gr_rt_id ben_qua_in_gr_rt_f.qua_in_gr_rt_id%TYPE;
60: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_QUA_IN_GR_RT';
63: l_object_version_number ben_qua_in_gr_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_QUA_IN_GR_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_QUA_IN_GR_FLAG',
244: p_reference_table => 'BEN_QUA_IN_GR_RT_F',
245: p_reference_table_column => 'VRBL_RT_PRFL_ID');
246: --
247: hr_utility.set_location(l_proc, 60);
248: --

Line 351: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;

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

Line 352: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;

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

Line 353: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;

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

Line 597: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;

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

Line 598: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;

594: -- Declare cursors and local variables
595: --
596: l_proc varchar2(72) := g_package||'update_QUA_IN_GR_RT';
597: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
598: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
599: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
600: --
601: begin
602: --

Line 599: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;

595: --
596: l_proc varchar2(72) := g_package||'update_QUA_IN_GR_RT';
597: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
598: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
599: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
600: --
601: begin
602: --
603: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 678: p_reference_table => 'BEN_QUA_IN_GR_RT_F',

674: p_base_table => 'BEN_VRBL_RT_PRFL_F',
675: p_base_table_column => 'VRBL_RT_PRFL_ID',
676: p_base_table_column_value => ben_qig_shd.g_old_rec.vrbl_rt_prfl_id,
677: p_base_table_reference_column => 'RT_QUA_IN_GR_FLAG',
678: p_reference_table => 'BEN_QUA_IN_GR_RT_F',
679: p_reference_table_column => 'VRBL_RT_PRFL_ID');
680: --
681: hr_utility.set_location(l_proc, 60);
682: --