DBA Data[Home] [Help]

APPS.BEN_ELIG_DPNT_CVRD_O_PTIP_API dependencies on BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F

Line 61: l_elig_dpnt_cvrd_othr_ptip_id ben_elig_dpnt_cvrd_othr_ptip_f.elig_dpnt_cvrd_othr_ptip_id%TYPE;

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

Line 62: l_effective_start_date ben_elig_dpnt_cvrd_othr_ptip_f.effective_start_date%TYPE;

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

Line 63: l_effective_end_date ben_elig_dpnt_cvrd_othr_ptip_f.effective_end_date%TYPE;

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

Line 65: l_object_version_number ben_elig_dpnt_cvrd_othr_ptip_f.object_version_number%TYPE;

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

Line 251: p_reference_table => 'BEN_ELIG_DPNT_CVRD_OTHR_PTIP_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 => 'ELIG_DPNT_CVRD_PTIP_FLAG',
251: p_reference_table => 'BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F',
252: p_reference_table_column => 'ELIGY_PRFL_ID');
253: --
254: hr_utility.set_location(l_proc, 60);
255: --

Line 353: l_object_version_number ben_elig_dpnt_cvrd_othr_ptip_f.object_version_number%TYPE;

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

Line 354: l_effective_start_date ben_elig_dpnt_cvrd_othr_ptip_f.effective_start_date%TYPE;

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

Line 355: l_effective_end_date ben_elig_dpnt_cvrd_othr_ptip_f.effective_end_date%TYPE;

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

Line 601: l_object_version_number ben_elig_dpnt_cvrd_othr_ptip_f.object_version_number%TYPE;

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

Line 602: l_effective_start_date ben_elig_dpnt_cvrd_othr_ptip_f.effective_start_date%TYPE;

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

Line 603: l_effective_end_date ben_elig_dpnt_cvrd_othr_ptip_f.effective_end_date%TYPE;

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

Line 682: p_reference_table => 'BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F',

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