65: ) is
66: --
67: -- Declare cursors and local variables
68: --
69: l_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
70: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
71: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_PLAN_TYPE';
73: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
66: --
67: -- Declare cursors and local variables
68: --
69: l_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
70: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
71: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_PLAN_TYPE';
73: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
74: --
67: -- Declare cursors and local variables
68: --
69: l_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
70: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
71: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_PLAN_TYPE';
73: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
74: --
75: begin
69: l_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
70: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
71: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_PLAN_TYPE';
73: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
74: --
75: begin
76: --
77: hr_utility.set_location('Entering:'|| l_proc, 10);
386: --
387: -- Declare cursors and local variables
388: --
389: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
390: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
391: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
392: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
393: l_old_opt_dsply_fmt_cd ben_pl_typ_f.opt_dsply_fmt_cd%TYPE;
394: l_ordr_num number;
387: -- Declare cursors and local variables
388: --
389: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
390: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
391: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
392: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
393: l_old_opt_dsply_fmt_cd ben_pl_typ_f.opt_dsply_fmt_cd%TYPE;
394: l_ordr_num number;
395: --
388: --
389: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
390: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
391: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
392: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
393: l_old_opt_dsply_fmt_cd ben_pl_typ_f.opt_dsply_fmt_cd%TYPE;
394: l_ordr_num number;
395: --
396: cursor c_old_pl_typ is
389: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
390: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
391: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
392: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
393: l_old_opt_dsply_fmt_cd ben_pl_typ_f.opt_dsply_fmt_cd%TYPE;
394: l_ordr_num number;
395: --
396: cursor c_old_pl_typ is
397: select plt.opt_dsply_fmt_cd
394: l_ordr_num number;
395: --
396: cursor c_old_pl_typ is
397: select plt.opt_dsply_fmt_cd
398: from ben_pl_typ_f plt
399: where plt.pl_typ_id = p_pl_typ_id
400: and p_effective_date between plt.effective_start_date and plt.effective_end_date;
401: --
402: begin
754: --
755: -- Declare cursors and local variables
756: --
757: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
758: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
759: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
760: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
761: --
762: begin
755: -- Declare cursors and local variables
756: --
757: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
758: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
759: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
760: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
761: --
762: begin
763: --
756: --
757: l_proc varchar2(72) := g_package||'update_PLAN_TYPE';
758: l_object_version_number ben_pl_typ_f.object_version_number%TYPE;
759: l_effective_start_date ben_pl_typ_f.effective_start_date%TYPE;
760: l_effective_end_date ben_pl_typ_f.effective_end_date%TYPE;
761: --
762: begin
763: --
764: hr_utility.set_location('Entering:'|| l_proc, 10);