DBA Data[Home] [Help]

APPS.BEN_PTIP_DPNT_CVG_CTFN_API dependencies on BEN_PTIP_DPNT_CVG_CTFN_F

Line 62: l_ptip_dpnt_cvg_ctfn_id ben_ptip_dpnt_cvg_ctfn_f.ptip_dpnt_cvg_ctfn_id%TYPE;

58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_ptip_dpnt_cvg_ctfn_id ben_ptip_dpnt_cvg_ctfn_f.ptip_dpnt_cvg_ctfn_id%TYPE;
63: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_Ptip_Dpnt_Cvg_Ctfn';
66: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;

Line 63: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;

59: --
60: -- Declare cursors and local variables
61: --
62: l_ptip_dpnt_cvg_ctfn_id ben_ptip_dpnt_cvg_ctfn_f.ptip_dpnt_cvg_ctfn_id%TYPE;
63: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_Ptip_Dpnt_Cvg_Ctfn';
66: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;
67: --

Line 64: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;

60: -- Declare cursors and local variables
61: --
62: l_ptip_dpnt_cvg_ctfn_id ben_ptip_dpnt_cvg_ctfn_f.ptip_dpnt_cvg_ctfn_id%TYPE;
63: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_Ptip_Dpnt_Cvg_Ctfn';
66: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;
67: --
68: begin

Line 66: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;

62: l_ptip_dpnt_cvg_ctfn_id ben_ptip_dpnt_cvg_ctfn_f.ptip_dpnt_cvg_ctfn_id%TYPE;
63: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_Ptip_Dpnt_Cvg_Ctfn';
66: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 355: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;

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

Line 356: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;

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

Line 357: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;

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

Line 612: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;

608: --
609: -- Declare cursors and local variables
610: --
611: l_proc varchar2(72) := g_package||'update_Ptip_Dpnt_Cvg_Ctfn';
612: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;
613: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
614: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
615: --
616: begin

Line 613: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;

609: -- Declare cursors and local variables
610: --
611: l_proc varchar2(72) := g_package||'update_Ptip_Dpnt_Cvg_Ctfn';
612: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;
613: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
614: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
615: --
616: begin
617: --

Line 614: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;

610: --
611: l_proc varchar2(72) := g_package||'update_Ptip_Dpnt_Cvg_Ctfn';
612: l_object_version_number ben_ptip_dpnt_cvg_ctfn_f.object_version_number%TYPE;
613: l_effective_start_date ben_ptip_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
614: l_effective_end_date ben_ptip_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
615: --
616: begin
617: --
618: hr_utility.set_location('Entering:'|| l_proc, 10);