61: ) is
62: --
63: -- Declare cursors and local variables
64: --
65: l_dsgn_rqmt_id ben_dsgn_rqmt_f.dsgn_rqmt_id%TYPE;
66: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_design_rqmt';
69: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
62: --
63: -- Declare cursors and local variables
64: --
65: l_dsgn_rqmt_id ben_dsgn_rqmt_f.dsgn_rqmt_id%TYPE;
66: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_design_rqmt';
69: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
70: --
63: -- Declare cursors and local variables
64: --
65: l_dsgn_rqmt_id ben_dsgn_rqmt_f.dsgn_rqmt_id%TYPE;
66: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_design_rqmt';
69: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
70: --
71: begin
65: l_dsgn_rqmt_id ben_dsgn_rqmt_f.dsgn_rqmt_id%TYPE;
66: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_design_rqmt';
69: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
70: --
71: begin
72: --
73: hr_utility.set_location('Entering:'|| l_proc, 10);
366: --
367: -- Declare cursors and local variables
368: --
369: l_proc varchar2(72) := g_package||'update_design_rqmt';
370: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
371: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
372: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
373: --
374: begin
367: -- Declare cursors and local variables
368: --
369: l_proc varchar2(72) := g_package||'update_design_rqmt';
370: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
371: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
372: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
373: --
374: begin
375: --
368: --
369: l_proc varchar2(72) := g_package||'update_design_rqmt';
370: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
371: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
372: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
373: --
374: begin
375: --
376: hr_utility.set_location('Entering:'|| l_proc, 10);
632: --
633: -- Declare cursors and local variables
634: --
635: l_proc varchar2(72) := g_package||'update_design_rqmt';
636: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
637: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
638: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
639: --
640: begin
633: -- Declare cursors and local variables
634: --
635: l_proc varchar2(72) := g_package||'update_design_rqmt';
636: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
637: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
638: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
639: --
640: begin
641: --
634: --
635: l_proc varchar2(72) := g_package||'update_design_rqmt';
636: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
637: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
638: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
639: --
640: begin
641: --
642: hr_utility.set_location('Entering:'|| l_proc, 10);