DBA Data[Home] [Help]

APPS.BEN_WV_PRTN_RSN_CTFN_PL_API dependencies on BEN_WV_PRTN_RSN_CTFN_PL_F

Line 61: l_wv_prtn_rsn_ctfn_pl_id ben_wv_prtn_rsn_ctfn_pl_f.wv_prtn_rsn_ctfn_pl_id%TYPE;

57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_wv_prtn_rsn_ctfn_pl_id ben_wv_prtn_rsn_ctfn_pl_f.wv_prtn_rsn_ctfn_pl_id%TYPE;
62: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;
63: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_WV_PRTN_RSN_CTFN_PL';
65: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;

Line 62: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;

58: --
59: -- Declare cursors and local variables
60: --
61: l_wv_prtn_rsn_ctfn_pl_id ben_wv_prtn_rsn_ctfn_pl_f.wv_prtn_rsn_ctfn_pl_id%TYPE;
62: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;
63: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_WV_PRTN_RSN_CTFN_PL';
65: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;
66: --

Line 63: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;

59: -- Declare cursors and local variables
60: --
61: l_wv_prtn_rsn_ctfn_pl_id ben_wv_prtn_rsn_ctfn_pl_f.wv_prtn_rsn_ctfn_pl_id%TYPE;
62: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;
63: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_WV_PRTN_RSN_CTFN_PL';
65: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;
66: --
67: begin

Line 65: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;

61: l_wv_prtn_rsn_ctfn_pl_id ben_wv_prtn_rsn_ctfn_pl_f.wv_prtn_rsn_ctfn_pl_id%TYPE;
62: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;
63: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_WV_PRTN_RSN_CTFN_PL';
65: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 348: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;

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

Line 349: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;

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

Line 350: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;

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

Line 596: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;

592: --
593: -- Declare cursors and local variables
594: --
595: l_proc varchar2(72) := g_package||'update_WV_PRTN_RSN_CTFN_PL';
596: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;
597: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;
598: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;
599: --
600: begin

Line 597: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;

593: -- Declare cursors and local variables
594: --
595: l_proc varchar2(72) := g_package||'update_WV_PRTN_RSN_CTFN_PL';
596: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;
597: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;
598: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;
599: --
600: begin
601: --

Line 598: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;

594: --
595: l_proc varchar2(72) := g_package||'update_WV_PRTN_RSN_CTFN_PL';
596: l_object_version_number ben_wv_prtn_rsn_ctfn_pl_f.object_version_number%TYPE;
597: l_effective_start_date ben_wv_prtn_rsn_ctfn_pl_f.effective_start_date%TYPE;
598: l_effective_end_date ben_wv_prtn_rsn_ctfn_pl_f.effective_end_date%TYPE;
599: --
600: begin
601: --
602: hr_utility.set_location('Entering:'|| l_proc, 10);