55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_cmbn_ptip_opt_id ben_cmbn_ptip_opt_f.cmbn_ptip_opt_id%TYPE;
60: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_CMBN_PTIP_OPT';
63: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
56: --
57: -- Declare cursors and local variables
58: --
59: l_cmbn_ptip_opt_id ben_cmbn_ptip_opt_f.cmbn_ptip_opt_id%TYPE;
60: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_CMBN_PTIP_OPT';
63: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
64: --
57: -- Declare cursors and local variables
58: --
59: l_cmbn_ptip_opt_id ben_cmbn_ptip_opt_f.cmbn_ptip_opt_id%TYPE;
60: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_CMBN_PTIP_OPT';
63: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
64: --
65: begin
59: l_cmbn_ptip_opt_id ben_cmbn_ptip_opt_f.cmbn_ptip_opt_id%TYPE;
60: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_CMBN_PTIP_OPT';
63: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
330: --
331: -- Declare cursors and local variables
332: --
333: l_proc varchar2(72) := g_package||'update_CMBN_PTIP_OPT';
334: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
335: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
336: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
337: --
338: begin
331: -- Declare cursors and local variables
332: --
333: l_proc varchar2(72) := g_package||'update_CMBN_PTIP_OPT';
334: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
335: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
336: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
337: --
338: begin
339: --
332: --
333: l_proc varchar2(72) := g_package||'update_CMBN_PTIP_OPT';
334: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
335: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
336: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
337: --
338: begin
339: --
340: hr_utility.set_location('Entering:'|| l_proc, 10);
568: --
569: -- Declare cursors and local variables
570: --
571: l_proc varchar2(72) := g_package||'update_CMBN_PTIP_OPT';
572: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
573: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
574: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
575: --
576: begin
569: -- Declare cursors and local variables
570: --
571: l_proc varchar2(72) := g_package||'update_CMBN_PTIP_OPT';
572: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
573: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
574: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
575: --
576: begin
577: --
570: --
571: l_proc varchar2(72) := g_package||'update_CMBN_PTIP_OPT';
572: l_object_version_number ben_cmbn_ptip_opt_f.object_version_number%TYPE;
573: l_effective_start_date ben_cmbn_ptip_opt_f.effective_start_date%TYPE;
574: l_effective_end_date ben_cmbn_ptip_opt_f.effective_end_date%TYPE;
575: --
576: begin
577: --
578: hr_utility.set_location('Entering:'|| l_proc, 10);