58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_prtt_rmt_rqst_ctfn_prvdd_id ben_prtt_rmt_rqst_ctfn_prvdd_f.prtt_rmt_rqst_ctfn_prvdd_id%TYPE;
63: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
64: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_reimbmt_ctfn_prvdd';
66: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
59: --
60: -- Declare cursors and local variables
61: --
62: l_prtt_rmt_rqst_ctfn_prvdd_id ben_prtt_rmt_rqst_ctfn_prvdd_f.prtt_rmt_rqst_ctfn_prvdd_id%TYPE;
63: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
64: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_reimbmt_ctfn_prvdd';
66: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
67: --
60: -- Declare cursors and local variables
61: --
62: l_prtt_rmt_rqst_ctfn_prvdd_id ben_prtt_rmt_rqst_ctfn_prvdd_f.prtt_rmt_rqst_ctfn_prvdd_id%TYPE;
63: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
64: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_reimbmt_ctfn_prvdd';
66: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
67: --
68: begin
62: l_prtt_rmt_rqst_ctfn_prvdd_id ben_prtt_rmt_rqst_ctfn_prvdd_f.prtt_rmt_rqst_ctfn_prvdd_id%TYPE;
63: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
64: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_reimbmt_ctfn_prvdd';
66: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);
345: --
346: -- Declare cursors and local variables
347: --
348: l_proc varchar2(72) := g_package||'update_reimbmt_ctfn_prvdd';
349: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
350: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
351: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
352: --
353: begin
346: -- Declare cursors and local variables
347: --
348: l_proc varchar2(72) := g_package||'update_reimbmt_ctfn_prvdd';
349: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
350: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
351: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
352: --
353: begin
354: --
347: --
348: l_proc varchar2(72) := g_package||'update_reimbmt_ctfn_prvdd';
349: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
350: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
351: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
352: --
353: begin
354: --
355: hr_utility.set_location('Entering:'|| l_proc, 10);
592: --
593: -- Declare cursors and local variables
594: --
595: l_proc varchar2(72) := g_package||'update_reimbmt_ctfn_prvdd';
596: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
597: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
598: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
599: --
600: begin
593: -- Declare cursors and local variables
594: --
595: l_proc varchar2(72) := g_package||'update_reimbmt_ctfn_prvdd';
596: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
597: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
598: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
599: --
600: begin
601: --
594: --
595: l_proc varchar2(72) := g_package||'update_reimbmt_ctfn_prvdd';
596: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;
597: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;
598: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;
599: --
600: begin
601: --
602: hr_utility.set_location('Entering:'|| l_proc, 10);