DBA Data[Home] [Help]

APPS.BEN_REIMBMT_CTFN_PRVDD_API dependencies on BEN_PRTT_RMT_RQST_CTFN_PRVDD_F

Line 62: l_prtt_rmt_rqst_ctfn_prvdd_id ben_prtt_rmt_rqst_ctfn_prvdd_f.prtt_rmt_rqst_ctfn_prvdd_id%TYPE;

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;

Line 63: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%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: --

Line 64: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;

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

Line 66: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;

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);

Line 349: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;

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

Line 350: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;

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: --

Line 351: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;

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);

Line 596: l_object_version_number ben_prtt_rmt_rqst_ctfn_prvdd_f.object_version_number%TYPE;

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

Line 597: l_effective_start_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_start_date%TYPE;

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: --

Line 598: l_effective_end_date ben_prtt_rmt_rqst_ctfn_prvdd_f.effective_end_date%TYPE;

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);