54: ) is
55: --
56: -- Declare cursors and local variables
57: --
58: l_wv_prtn_rsn_pl_id ben_wv_prtn_rsn_pl_f.wv_prtn_rsn_pl_id%TYPE;
59: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_WV_PRTN_REASON_PL';
62: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
55: --
56: -- Declare cursors and local variables
57: --
58: l_wv_prtn_rsn_pl_id ben_wv_prtn_rsn_pl_f.wv_prtn_rsn_pl_id%TYPE;
59: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_WV_PRTN_REASON_PL';
62: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
63: --
56: -- Declare cursors and local variables
57: --
58: l_wv_prtn_rsn_pl_id ben_wv_prtn_rsn_pl_f.wv_prtn_rsn_pl_id%TYPE;
59: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_WV_PRTN_REASON_PL';
62: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
63: --
64: begin
58: l_wv_prtn_rsn_pl_id ben_wv_prtn_rsn_pl_f.wv_prtn_rsn_pl_id%TYPE;
59: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_WV_PRTN_REASON_PL';
62: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
63: --
64: begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);
325: --
326: -- Declare cursors and local variables
327: --
328: l_proc varchar2(72) := g_package||'update_WV_PRTN_REASON_PL';
329: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
330: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
331: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
332: --
333: begin
326: -- Declare cursors and local variables
327: --
328: l_proc varchar2(72) := g_package||'update_WV_PRTN_REASON_PL';
329: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
330: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
331: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
332: --
333: begin
334: --
327: --
328: l_proc varchar2(72) := g_package||'update_WV_PRTN_REASON_PL';
329: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
330: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
331: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
332: --
333: begin
334: --
335: hr_utility.set_location('Entering:'|| l_proc, 10);
564: --
565: -- Declare cursors and local variables
566: --
567: l_proc varchar2(72) := g_package||'update_WV_PRTN_REASON_PL';
568: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
569: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
570: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
571: --
572: begin
565: -- Declare cursors and local variables
566: --
567: l_proc varchar2(72) := g_package||'update_WV_PRTN_REASON_PL';
568: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
569: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
570: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
571: --
572: begin
573: --
566: --
567: l_proc varchar2(72) := g_package||'update_WV_PRTN_REASON_PL';
568: l_object_version_number ben_wv_prtn_rsn_pl_f.object_version_number%TYPE;
569: l_effective_start_date ben_wv_prtn_rsn_pl_f.effective_start_date%TYPE;
570: l_effective_end_date ben_wv_prtn_rsn_pl_f.effective_end_date%TYPE;
571: --
572: begin
573: --
574: hr_utility.set_location('Entering:'|| l_proc, 10);