DBA Data[Home] [Help]

APPS.BEN_PROGRAM_DPNT_CVG_CTFN_API dependencies on BEN_PGM_DPNT_CVG_CTFN_F

Line 62: l_pgm_dpnt_cvg_ctfn_id ben_pgm_dpnt_cvg_ctfn_f.pgm_dpnt_cvg_ctfn_id%TYPE;

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

Line 63: l_effective_start_date ben_pgm_dpnt_cvg_ctfn_f.effective_start_date%TYPE;

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

Line 64: l_effective_end_date ben_pgm_dpnt_cvg_ctfn_f.effective_end_date%TYPE;

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

Line 66: l_object_version_number ben_pgm_dpnt_cvg_ctfn_f.object_version_number%TYPE;

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

Line 349: l_object_version_number ben_pgm_dpnt_cvg_ctfn_f.object_version_number%TYPE;

345: --
346: -- Declare cursors and local variables
347: --
348: l_proc varchar2(72) := g_package||'update_Program_Dpnt_Cvg_Ctfn';
349: l_object_version_number ben_pgm_dpnt_cvg_ctfn_f.object_version_number%TYPE;
350: l_effective_start_date ben_pgm_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
351: l_effective_end_date ben_pgm_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
352: --
353: begin

Line 350: l_effective_start_date ben_pgm_dpnt_cvg_ctfn_f.effective_start_date%TYPE;

346: -- Declare cursors and local variables
347: --
348: l_proc varchar2(72) := g_package||'update_Program_Dpnt_Cvg_Ctfn';
349: l_object_version_number ben_pgm_dpnt_cvg_ctfn_f.object_version_number%TYPE;
350: l_effective_start_date ben_pgm_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
351: l_effective_end_date ben_pgm_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
352: --
353: begin
354: --

Line 351: l_effective_end_date ben_pgm_dpnt_cvg_ctfn_f.effective_end_date%TYPE;

347: --
348: l_proc varchar2(72) := g_package||'update_Program_Dpnt_Cvg_Ctfn';
349: l_object_version_number ben_pgm_dpnt_cvg_ctfn_f.object_version_number%TYPE;
350: l_effective_start_date ben_pgm_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
351: l_effective_end_date ben_pgm_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
352: --
353: begin
354: --
355: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 600: l_object_version_number ben_pgm_dpnt_cvg_ctfn_f.object_version_number%TYPE;

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

Line 601: l_effective_start_date ben_pgm_dpnt_cvg_ctfn_f.effective_start_date%TYPE;

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

Line 602: l_effective_end_date ben_pgm_dpnt_cvg_ctfn_f.effective_end_date%TYPE;

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