DBA Data[Home] [Help]

APPS.BEN_ELIG_PCT_FL_TM_PRTE_API dependencies on BEN_ELIG_PCT_FL_TM_PRTE_F

Line 61: l_elig_pct_fl_tm_prte_id ben_elig_pct_fl_tm_prte_f.elig_pct_fl_tm_prte_id%TYPE;

57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_pct_fl_tm_prte_id ben_elig_pct_fl_tm_prte_f.elig_pct_fl_tm_prte_id%TYPE;
62: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PCT_FL_TM_PRTE';
65: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;

Line 62: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;

58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_pct_fl_tm_prte_id ben_elig_pct_fl_tm_prte_f.elig_pct_fl_tm_prte_id%TYPE;
62: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PCT_FL_TM_PRTE';
65: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
66: --

Line 63: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;

59: -- Declare cursors and local variables
60: --
61: l_elig_pct_fl_tm_prte_id ben_elig_pct_fl_tm_prte_f.elig_pct_fl_tm_prte_id%TYPE;
62: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PCT_FL_TM_PRTE';
65: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
66: --
67: begin

Line 65: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;

61: l_elig_pct_fl_tm_prte_id ben_elig_pct_fl_tm_prte_f.elig_pct_fl_tm_prte_id%TYPE;
62: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PCT_FL_TM_PRTE';
65: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 253: p_reference_table => 'BEN_ELIG_PCT_FL_TM_PRTE_F',

249: p_base_table => 'BEN_ELIGY_PRFL_F',
250: p_base_table_column => 'ELIGY_PRFL_ID',
251: p_base_table_column_value => p_eligy_prfl_id,
252: p_base_table_reference_column => 'ELIG_PCT_FL_TM_FLAG',
253: p_reference_table => 'BEN_ELIG_PCT_FL_TM_PRTE_F',
254: p_reference_table_column => 'ELIGY_PRFL_ID');
255: --
256: ben_derivable_factor.derivable_factor_handler
257: (p_event => 'CREATE',

Line 353: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;

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

Line 354: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;

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

Line 355: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;

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

Line 592: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;

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

Line 593: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;

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

Line 594: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;

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

Line 675: p_reference_table => 'BEN_ELIG_PCT_FL_TM_PRTE_F',

671: p_base_table => 'BEN_ELIGY_PRFL_F',
672: p_base_table_column => 'ELIGY_PRFL_ID',
673: p_base_table_column_value => ben_epf_shd.g_old_rec.eligy_prfl_id,
674: p_base_table_reference_column => 'ELIG_PCT_FL_TM_FLAG',
675: p_reference_table => 'BEN_ELIG_PCT_FL_TM_PRTE_F',
676: p_reference_table_column => 'ELIGY_PRFL_ID');
677: --
678: ben_derivable_factor.derivable_factor_handler
679: (p_event => 'DELETE',