DBA Data[Home] [Help]

APPS.BEN_CNTNG_PRTN_PRFL_RT_API dependencies on BEN_CNTNG_PRTN_PRFL_RT_F

Line 60: l_cntng_prtn_prfl_rt_id ben_cntng_prtn_prfl_rt_f.cntng_prtn_prfl_rt_id%TYPE;

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

Line 61: l_effective_start_date ben_cntng_prtn_prfl_rt_f.effective_start_date%TYPE;

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

Line 62: l_effective_end_date ben_cntng_prtn_prfl_rt_f.effective_end_date%TYPE;

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

Line 64: l_object_version_number ben_cntng_prtn_prfl_rt_f.object_version_number%TYPE;

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

Line 247: p_reference_table => 'BEN_CNTNG_PRTN_PRFL_RT_F',

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

Line 353: l_object_version_number ben_cntng_prtn_prfl_rt_f.object_version_number%TYPE;

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

Line 354: l_effective_start_date ben_cntng_prtn_prfl_rt_f.effective_start_date%TYPE;

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

Line 355: l_effective_end_date ben_cntng_prtn_prfl_rt_f.effective_end_date%TYPE;

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

Line 598: l_object_version_number ben_cntng_prtn_prfl_rt_f.object_version_number%TYPE;

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

Line 599: l_effective_start_date ben_cntng_prtn_prfl_rt_f.effective_start_date%TYPE;

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

Line 600: l_effective_end_date ben_cntng_prtn_prfl_rt_f.effective_end_date%TYPE;

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

Line 679: p_reference_table => 'BEN_CNTNG_PRTN_PRFL_RT_F',

675: p_base_table => 'BEN_VRBL_RT_PRFL_F',
676: p_base_table_column => 'vrbl_rt_prfl_id',
677: p_base_table_column_value => ben_cpn_shd.g_old_rec.vrbl_rt_prfl_id,
678: p_base_table_reference_column => 'RT_CNTNG_PRTN_PRFL_FLAG',
679: p_reference_table => 'BEN_CNTNG_PRTN_PRFL_RT_F',
680: p_reference_table_column => 'vrbl_rt_prfl_id');
681: --
682: hr_utility.set_location(l_proc, 60);
683: --