eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_VRBL_RT_ELIG_PRFL_API dependencies on BEN_VRBL_RT_ELIG_PRFL_F

Line 60: ben_vrbl_rt_elig_prfl_f vep

56: -- Cursor to find the uniqueness of the vrbl_rt_elig_prfl
57: --
58: cursor c_uniq_vrbl_rt_elig_prfl is
59: select null from
60: ben_vrbl_rt_elig_prfl_f vep
61: where
62: vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
63: and vep.eligy_prfl_id = p_eligy_prfl_id
64: and p_effective_date between vep.effective_start_date and

Line 69: ben_vrbl_rt_elig_prfl_f vep

65: vep.effective_end_date ;
66: --
67: cursor c_future_vrbl_rt_elig_prfl is
68: select vrbl_rt_elig_prfl_id, vep.effective_end_date from
69: ben_vrbl_rt_elig_prfl_f vep
70: where
71: vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
72: and vep.eligy_prfl_id = p_eligy_prfl_id
73: and vep.effective_start_date > p_effective_date ;

Line 77: l_vrbl_rt_elig_prfl_id ben_vrbl_rt_elig_prfl_f.vrbl_rt_elig_prfl_id%TYPE;

73: and vep.effective_start_date > p_effective_date ;
74:
75: -- Declare cursors and local variables
76: --
77: l_vrbl_rt_elig_prfl_id ben_vrbl_rt_elig_prfl_f.vrbl_rt_elig_prfl_id%TYPE;
78: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
79: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_vrbl_rt_elig_prfl';
81: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;

Line 78: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;

74:
75: -- Declare cursors and local variables
76: --
77: l_vrbl_rt_elig_prfl_id ben_vrbl_rt_elig_prfl_f.vrbl_rt_elig_prfl_id%TYPE;
78: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
79: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_vrbl_rt_elig_prfl';
81: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
82: l_dummy varchar2(1) := null ;

Line 79: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;

75: -- Declare cursors and local variables
76: --
77: l_vrbl_rt_elig_prfl_id ben_vrbl_rt_elig_prfl_f.vrbl_rt_elig_prfl_id%TYPE;
78: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
79: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_vrbl_rt_elig_prfl';
81: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
82: l_dummy varchar2(1) := null ;
83: l_future_vrbl_rt_elig_prfl_id ben_vrbl_rt_elig_prfl_f.vrbl_rt_elig_prfl_id%TYPE;

Line 81: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;

77: l_vrbl_rt_elig_prfl_id ben_vrbl_rt_elig_prfl_f.vrbl_rt_elig_prfl_id%TYPE;
78: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
79: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_vrbl_rt_elig_prfl';
81: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
82: l_dummy varchar2(1) := null ;
83: l_future_vrbl_rt_elig_prfl_id ben_vrbl_rt_elig_prfl_f.vrbl_rt_elig_prfl_id%TYPE;
84: l_future_record_end_date date;
85: --

Line 83: l_future_vrbl_rt_elig_prfl_id ben_vrbl_rt_elig_prfl_f.vrbl_rt_elig_prfl_id%TYPE;

79: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_vrbl_rt_elig_prfl';
81: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
82: l_dummy varchar2(1) := null ;
83: l_future_vrbl_rt_elig_prfl_id ben_vrbl_rt_elig_prfl_f.vrbl_rt_elig_prfl_id%TYPE;
84: l_future_record_end_date date;
85: --
86: begin
87: --

Line 124: update ben_vrbl_rt_elig_prfl_f

120: --
121: if c_future_vrbl_rt_elig_prfl%found then
122: --
123: hr_utility.set_location('Future record exists. we need to extend the record ', 20 ) ;
124: update ben_vrbl_rt_elig_prfl_f
125: set effective_start_date = p_effective_date
126: where vrbl_rt_elig_prfl_id = l_future_vrbl_rt_elig_prfl_id ;
127: hr_utility.set_location('exiting from '||l_proc,25);
128: close c_future_vrbl_rt_elig_prfl ;

Line 304: p_reference_table => 'BEN_VRBL_RT_ELIG_PRFL_F',

300: p_base_table => 'BEN_VRBL_RT_PRFL_F',
301: p_base_table_column => 'VRBL_RT_PRFL_ID',
302: p_base_table_column_value => p_vrbl_rt_prfl_id,
303: p_base_table_reference_column => 'RT_ELIG_PRFL_FLAG',
304: p_reference_table => 'BEN_VRBL_RT_ELIG_PRFL_F',
305: p_reference_table_column => 'VRBL_RT_PRFL_ID');
306:
307: -- When in validation only mode raise the Validate_Enabled exception
308: --

Line 408: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;

404: --
405: -- Declare cursors and local variables
406: --
407: l_proc varchar2(72) := g_package||'update_vrbl_rt_elig_prfl';
408: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
409: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
410: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
411: --
412: begin

Line 409: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;

405: -- Declare cursors and local variables
406: --
407: l_proc varchar2(72) := g_package||'update_vrbl_rt_elig_prfl';
408: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
409: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
410: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
411: --
412: begin
413: --

Line 410: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;

406: --
407: l_proc varchar2(72) := g_package||'update_vrbl_rt_elig_prfl';
408: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
409: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
410: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
411: --
412: begin
413: --
414: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 652: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;

648: --
649: -- Declare cursors and local variables
650: --
651: l_proc varchar2(72) := g_package||'update_vrbl_rt_elig_prfl';
652: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
653: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
654: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
655: --
656: begin

Line 653: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;

649: -- Declare cursors and local variables
650: --
651: l_proc varchar2(72) := g_package||'update_vrbl_rt_elig_prfl';
652: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
653: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
654: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
655: --
656: begin
657: --

Line 654: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;

650: --
651: l_proc varchar2(72) := g_package||'update_vrbl_rt_elig_prfl';
652: l_object_version_number ben_vrbl_rt_elig_prfl_f.object_version_number%TYPE;
653: l_effective_start_date ben_vrbl_rt_elig_prfl_f.effective_start_date%TYPE;
654: l_effective_end_date ben_vrbl_rt_elig_prfl_f.effective_end_date%TYPE;
655: --
656: begin
657: --
658: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 735: p_reference_table => 'BEN_VRBL_RT_ELIG_PRFL_F',

731: p_base_table => 'BEN_VRBL_RT_PRFL_F',
732: p_base_table_column => 'VRBL_RT_PRFL_ID',
733: p_base_table_column_value => p_vrbl_rt_prfl_id,
734: p_base_table_reference_column => 'RT_ELIG_PRFL_FLAG',
735: p_reference_table => 'BEN_VRBL_RT_ELIG_PRFL_F',
736: p_reference_table_column => 'VRBL_RT_PRFL_ID');
737:
738: -- When in validation only mode raise the Validate_Enabled exception
739: --