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