DBA Data[Home] [Help]

APPS.BEN_CBR_QUALD_BNF_RT_API dependencies on BEN_CBR_QUALD_BNF_RT_F

Line 60: l_cbr_quald_bnf_rt_id ben_cbr_quald_bnf_rt_f.cbr_quald_bnf_rt_id%TYPE;

56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_cbr_quald_bnf_rt_id ben_cbr_quald_bnf_rt_f.cbr_quald_bnf_rt_id%TYPE;
61: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;
62: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_cbr_quald_bnf_rt';
64: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;

Line 61: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;

57: --
58: -- Declare cursors and local variables
59: --
60: l_cbr_quald_bnf_rt_id ben_cbr_quald_bnf_rt_f.cbr_quald_bnf_rt_id%TYPE;
61: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;
62: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_cbr_quald_bnf_rt';
64: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;
65: --

Line 62: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;

58: -- Declare cursors and local variables
59: --
60: l_cbr_quald_bnf_rt_id ben_cbr_quald_bnf_rt_f.cbr_quald_bnf_rt_id%TYPE;
61: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;
62: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_cbr_quald_bnf_rt';
64: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;
65: --
66: begin

Line 64: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;

60: l_cbr_quald_bnf_rt_id ben_cbr_quald_bnf_rt_f.cbr_quald_bnf_rt_id%TYPE;
61: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;
62: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_cbr_quald_bnf_rt';
64: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 248: p_reference_table => 'BEN_CBR_QUALD_BNF_RT_F',

244: p_base_table => 'BEN_VRBL_RT_PRFL_F',
245: p_base_table_column => 'vrbl_rt_prfl_id',
246: p_base_table_column_value => p_vrbl_rt_prfl_id,
247: p_base_table_reference_column => 'RT_CBR_QUALD_BNF_FLAG',
248: p_reference_table => 'BEN_CBR_QUALD_BNF_RT_F',
249: p_reference_table_column => 'vrbl_rt_prfl_id');
250: --
251:
252: hr_utility.set_location(l_proc, 60);

Line 356: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;

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

Line 357: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;

353: -- Declare cursors and local variables
354: --
355: l_proc varchar2(72) := g_package||'update_cbr_quald_bnf_rt';
356: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;
357: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;
358: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;
359: --
360: begin
361: --

Line 358: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;

354: --
355: l_proc varchar2(72) := g_package||'update_cbr_quald_bnf_rt';
356: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;
357: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;
358: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;
359: --
360: begin
361: --
362: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 603: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;

599: --
600: -- Declare cursors and local variables
601: --
602: l_proc varchar2(72) := g_package||'update_cbr_quald_bnf_rt';
603: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;
604: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;
605: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;
606: --
607: begin

Line 604: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;

600: -- Declare cursors and local variables
601: --
602: l_proc varchar2(72) := g_package||'update_cbr_quald_bnf_rt';
603: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;
604: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;
605: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;
606: --
607: begin
608: --

Line 605: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;

601: --
602: l_proc varchar2(72) := g_package||'update_cbr_quald_bnf_rt';
603: l_object_version_number ben_cbr_quald_bnf_rt_f.object_version_number%TYPE;
604: l_effective_start_date ben_cbr_quald_bnf_rt_f.effective_start_date%TYPE;
605: l_effective_end_date ben_cbr_quald_bnf_rt_f.effective_end_date%TYPE;
606: --
607: begin
608: --
609: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 684: p_reference_table => 'BEN_CBR_QUALD_BNF_RT_F',

680: p_base_table => 'BEN_VRBL_RT_PRFL_F',
681: p_base_table_column => 'VRBL_RT_PRFL_ID',
682: p_base_table_column_value => ben_cqr_shd.g_old_rec.vrbl_rt_prfl_id,
683: p_base_table_reference_column => 'RT_CBR_QUALD_BNF_FLAG',
684: p_reference_table => 'BEN_CBR_QUALD_BNF_RT_F',
685: p_reference_table_column => 'VRBL_RT_PRFL_ID');
686: --
687: hr_utility.set_location(l_proc, 60);
688: --