DBA Data[Home] [Help]

APPS.BEN_CVG_AMT_CALC_API dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 82: l_cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%TYPE;

78: ,p_effective_date in date) is
79: --
80: -- Declare cursors and local variables
81: --
82: l_cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%TYPE;
83: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
84: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Cvg_Amt_Calc';
86: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;

Line 83: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;

79: --
80: -- Declare cursors and local variables
81: --
82: l_cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%TYPE;
83: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
84: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Cvg_Amt_Calc';
86: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
87: --

Line 84: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;

80: -- Declare cursors and local variables
81: --
82: l_cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%TYPE;
83: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
84: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Cvg_Amt_Calc';
86: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
87: --
88: begin

Line 86: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;

82: l_cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%TYPE;
83: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
84: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Cvg_Amt_Calc';
86: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
87: --
88: begin
89: --
90: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 454: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;

450: --
451: -- Declare cursors and local variables
452: --
453: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
454: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
455: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
456: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
457: --
458: begin

Line 455: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;

451: -- Declare cursors and local variables
452: --
453: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
454: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
455: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
456: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
457: --
458: begin
459: --

Line 456: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;

452: --
453: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
454: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
455: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
456: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
457: --
458: begin
459: --
460: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 766: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;

762: --
763: -- Declare cursors and local variables
764: --
765: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
766: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
767: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
768: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
769: --
770: begin

Line 767: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;

763: -- Declare cursors and local variables
764: --
765: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
766: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
767: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
768: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
769: --
770: begin
771: --

Line 768: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;

764: --
765: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
766: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
767: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
768: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
769: --
770: begin
771: --
772: hr_utility.set_location('Entering:'|| l_proc, 10);