53: ) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_vald_rlshp_for_reimb_id ben_vald_rlshp_for_reimb_f.vald_rlshp_for_reimb_id%TYPE;
58: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
59: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_Vald_Rlshp_For_Reimb';
61: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
54: --
55: -- Declare cursors and local variables
56: --
57: l_vald_rlshp_for_reimb_id ben_vald_rlshp_for_reimb_f.vald_rlshp_for_reimb_id%TYPE;
58: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
59: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_Vald_Rlshp_For_Reimb';
61: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
62: --
55: -- Declare cursors and local variables
56: --
57: l_vald_rlshp_for_reimb_id ben_vald_rlshp_for_reimb_f.vald_rlshp_for_reimb_id%TYPE;
58: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
59: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_Vald_Rlshp_For_Reimb';
61: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
62: --
63: begin
57: l_vald_rlshp_for_reimb_id ben_vald_rlshp_for_reimb_f.vald_rlshp_for_reimb_id%TYPE;
58: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
59: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_Vald_Rlshp_For_Reimb';
61: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
62: --
63: begin
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);
321: --
322: -- Declare cursors and local variables
323: --
324: l_proc varchar2(72) := g_package||'update_Vald_Rlshp_For_Reimb';
325: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
326: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
327: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
328: --
329: begin
322: -- Declare cursors and local variables
323: --
324: l_proc varchar2(72) := g_package||'update_Vald_Rlshp_For_Reimb';
325: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
326: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
327: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
328: --
329: begin
330: --
323: --
324: l_proc varchar2(72) := g_package||'update_Vald_Rlshp_For_Reimb';
325: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
326: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
327: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
328: --
329: begin
330: --
331: hr_utility.set_location('Entering:'|| l_proc, 10);
553: --
554: -- Declare cursors and local variables
555: --
556: l_proc varchar2(72) := g_package||'update_Vald_Rlshp_For_Reimb';
557: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
558: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
559: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
560: --
561: begin
554: -- Declare cursors and local variables
555: --
556: l_proc varchar2(72) := g_package||'update_Vald_Rlshp_For_Reimb';
557: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
558: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
559: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
560: --
561: begin
562: --
555: --
556: l_proc varchar2(72) := g_package||'update_Vald_Rlshp_For_Reimb';
557: l_object_version_number ben_vald_rlshp_for_reimb_f.object_version_number%TYPE;
558: l_effective_start_date ben_vald_rlshp_for_reimb_f.effective_start_date%TYPE;
559: l_effective_end_date ben_vald_rlshp_for_reimb_f.effective_end_date%TYPE;
560: --
561: begin
562: --
563: hr_utility.set_location('Entering:'|| l_proc, 10);