53: ) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_cmbn_plip_id ben_cmbn_plip_f.cmbn_plip_id%TYPE;
58: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_CMBN_PLIP';
61: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
54: --
55: -- Declare cursors and local variables
56: --
57: l_cmbn_plip_id ben_cmbn_plip_f.cmbn_plip_id%TYPE;
58: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_CMBN_PLIP';
61: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
62: --
55: -- Declare cursors and local variables
56: --
57: l_cmbn_plip_id ben_cmbn_plip_f.cmbn_plip_id%TYPE;
58: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_CMBN_PLIP';
61: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
62: --
63: begin
57: l_cmbn_plip_id ben_cmbn_plip_f.cmbn_plip_id%TYPE;
58: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_CMBN_PLIP';
61: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
62: --
63: begin
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);
325: --
326: -- Declare cursors and local variables
327: --
328: l_proc varchar2(72) := g_package||'update_CMBN_PLIP';
329: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
330: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
331: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
332: --
333: begin
326: -- Declare cursors and local variables
327: --
328: l_proc varchar2(72) := g_package||'update_CMBN_PLIP';
329: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
330: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
331: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
332: --
333: begin
334: --
327: --
328: l_proc varchar2(72) := g_package||'update_CMBN_PLIP';
329: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
330: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
331: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
332: --
333: begin
334: --
335: hr_utility.set_location('Entering:'|| l_proc, 10);
561: --
562: -- Declare cursors and local variables
563: --
564: l_proc varchar2(72) := g_package||'update_CMBN_PLIP';
565: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
566: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
567: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
568: --
569: begin
562: -- Declare cursors and local variables
563: --
564: l_proc varchar2(72) := g_package||'update_CMBN_PLIP';
565: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
566: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
567: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
568: --
569: begin
570: --
563: --
564: l_proc varchar2(72) := g_package||'update_CMBN_PLIP';
565: l_object_version_number ben_cmbn_plip_f.object_version_number%TYPE;
566: l_effective_start_date ben_cmbn_plip_f.effective_start_date%TYPE;
567: l_effective_end_date ben_cmbn_plip_f.effective_end_date%TYPE;
568: --
569: begin
570: --
571: hr_utility.set_location('Entering:'|| l_proc, 10);