33: ) is
34: --
35: -- Declare cursors and local variables
36: --
37: l_pl_extract_identifier_id ben_pl_extract_identifier_f.pl_extract_identifier_id%TYPE;
38: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
39: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
40: l_proc varchar2(72) := g_package||'create_pl_extract_id';
41: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
34: --
35: -- Declare cursors and local variables
36: --
37: l_pl_extract_identifier_id ben_pl_extract_identifier_f.pl_extract_identifier_id%TYPE;
38: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
39: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
40: l_proc varchar2(72) := g_package||'create_pl_extract_id';
41: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
42: --
35: -- Declare cursors and local variables
36: --
37: l_pl_extract_identifier_id ben_pl_extract_identifier_f.pl_extract_identifier_id%TYPE;
38: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
39: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
40: l_proc varchar2(72) := g_package||'create_pl_extract_id';
41: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
42: --
43: begin
37: l_pl_extract_identifier_id ben_pl_extract_identifier_f.pl_extract_identifier_id%TYPE;
38: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
39: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
40: l_proc varchar2(72) := g_package||'create_pl_extract_id';
41: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
42: --
43: begin
44: --
45: hr_utility.set_location('Entering:'|| l_proc, 10);
221: --
222: -- Declare cursors and local variables
223: --
224: l_proc varchar2(72) := g_package||'update_pl_extract_id';
225: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
226: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
227: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
228: --
229: begin
222: -- Declare cursors and local variables
223: --
224: l_proc varchar2(72) := g_package||'update_pl_extract_id';
225: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
226: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
227: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
228: --
229: begin
230: --
223: --
224: l_proc varchar2(72) := g_package||'update_pl_extract_id';
225: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
226: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
227: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
228: --
229: begin
230: --
231: hr_utility.set_location('Entering:'|| l_proc, 10);
394: --
395: -- Declare cursors and local variables
396: --
397: l_proc varchar2(72) := g_package||'delete_pl_extract_id';
398: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
399: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
400: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
401: --
402: begin
395: -- Declare cursors and local variables
396: --
397: l_proc varchar2(72) := g_package||'delete_pl_extract_id';
398: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
399: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
400: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
401: --
402: begin
403: --
396: --
397: l_proc varchar2(72) := g_package||'delete_pl_extract_id';
398: l_object_version_number ben_pl_extract_identifier_f.object_version_number%TYPE;
399: l_effective_start_date ben_pl_extract_identifier_f.effective_start_date%TYPE;
400: l_effective_end_date ben_pl_extract_identifier_f.effective_end_date%TYPE;
401: --
402: begin
403: --
404: hr_utility.set_location('Entering:'|| l_proc, 10);