DBA Data[Home] [Help]

APPS.BEN_ELIG_ENRLD_ANTHR_PLIP_API dependencies on BEN_ELIG_ENRLD_ANTHR_PLIP_F

Line 60: l_elig_enrld_anthr_plip_id ben_elig_enrld_anthr_plip_f.elig_enrld_anthr_plip_id%TYPE;

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

Line 61: l_effective_start_date ben_elig_enrld_anthr_plip_f.effective_start_date%TYPE;

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

Line 62: l_effective_end_date ben_elig_enrld_anthr_plip_f.effective_end_date%TYPE;

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

Line 64: l_object_version_number ben_elig_enrld_anthr_plip_f.object_version_number%TYPE;

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

Line 247: p_reference_table => 'BEN_ELIG_ENRLD_ANTHR_PLIP_F',

243: p_base_table => 'BEN_ELIGY_PRFL_F',
244: p_base_table_column => 'ELIGY_PRFL_ID',
245: p_base_table_column_value => p_eligy_prfl_id,
246: p_base_table_reference_column => 'ELIG_ENRLD_PLIP_FLAG',
247: p_reference_table => 'BEN_ELIG_ENRLD_ANTHR_PLIP_F',
248: p_reference_table_column => 'ELIGY_PRFL_ID');
249: --
250: hr_utility.set_location(l_proc, 60);
251: --

Line 355: l_object_version_number ben_elig_enrld_anthr_plip_f.object_version_number%TYPE;

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

Line 356: l_effective_start_date ben_elig_enrld_anthr_plip_f.effective_start_date%TYPE;

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

Line 357: l_effective_end_date ben_elig_enrld_anthr_plip_f.effective_end_date%TYPE;

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

Line 602: l_object_version_number ben_elig_enrld_anthr_plip_f.object_version_number%TYPE;

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

Line 603: l_effective_start_date ben_elig_enrld_anthr_plip_f.effective_start_date%TYPE;

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

Line 604: l_effective_end_date ben_elig_enrld_anthr_plip_f.effective_end_date%TYPE;

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

Line 683: p_reference_table => 'BEN_ELIG_ENRLD_ANTHR_PLIP_F',

679: p_base_table => 'BEN_ELIGY_PRFL_F',
680: p_base_table_column => 'ELIGY_PRFL_ID',
681: p_base_table_column_value => ben_eai_shd.g_old_rec.eligy_prfl_id,
682: p_base_table_reference_column => 'ELIG_ENRLD_PLIP_FLAG',
683: p_reference_table => 'BEN_ELIG_ENRLD_ANTHR_PLIP_F',
684: p_reference_table_column => 'ELIGY_PRFL_ID');
685: --
686: hr_utility.set_location(l_proc, 60);
687: --