DBA Data[Home] [Help]

APPS.BEN_ELIGY_PROFILE_RULE_API dependencies on BEN_ELIGY_PRFL_RL_F

Line 61: l_eligy_prfl_rl_id ben_eligy_prfl_rl_f.eligy_prfl_rl_id%TYPE;

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

Line 62: l_effective_start_date ben_eligy_prfl_rl_f.effective_start_date%TYPE;

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

Line 63: l_effective_end_date ben_eligy_prfl_rl_f.effective_end_date%TYPE;

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

Line 65: l_object_version_number ben_eligy_prfl_rl_f.object_version_number%TYPE;

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

Line 251: p_reference_table => 'BEN_ELIGY_PRFL_RL_F',

247: p_base_table => 'BEN_ELIGY_PRFL_F',
248: p_base_table_column => 'ELIGY_PRFL_ID',
249: p_base_table_column_value => p_eligy_prfl_id,
250: p_base_table_reference_column => 'ELIGY_PRFL_RL_FLAG',
251: p_reference_table => 'BEN_ELIGY_PRFL_RL_F',
252: p_reference_table_column => 'ELIGY_PRFL_ID');
253: --
254: hr_utility.set_location(l_proc, 60);
255: --

Line 358: l_object_version_number ben_eligy_prfl_rl_f.object_version_number%TYPE;

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

Line 359: l_effective_start_date ben_eligy_prfl_rl_f.effective_start_date%TYPE;

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

Line 360: l_effective_end_date ben_eligy_prfl_rl_f.effective_end_date%TYPE;

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

Line 605: l_object_version_number ben_eligy_prfl_rl_f.object_version_number%TYPE;

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

Line 606: l_effective_start_date ben_eligy_prfl_rl_f.effective_start_date%TYPE;

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

Line 607: l_effective_end_date ben_eligy_prfl_rl_f.effective_end_date%TYPE;

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

Line 686: p_reference_table => 'BEN_ELIGY_PRFL_RL_F',

682: p_base_table => 'BEN_ELIGY_PRFL_F',
683: p_base_table_column => 'ELIGY_PRFL_ID',
684: p_base_table_column_value => ben_erl_shd.g_old_rec.eligy_prfl_id,
685: p_base_table_reference_column => 'ELIGY_PRFL_RL_FLAG',
686: p_reference_table => 'BEN_ELIGY_PRFL_RL_F',
687: p_reference_table_column => 'ELIGY_PRFL_ID');
688: --
689: hr_utility.set_location(l_proc, 60);
690: --