57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_popl_org_id ben_popl_org_f.popl_org_id%TYPE;
62: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
63: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_POPL_ORG';
65: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
58: --
59: -- Declare cursors and local variables
60: --
61: l_popl_org_id ben_popl_org_f.popl_org_id%TYPE;
62: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
63: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_POPL_ORG';
65: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
66: --
59: -- Declare cursors and local variables
60: --
61: l_popl_org_id ben_popl_org_f.popl_org_id%TYPE;
62: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
63: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_POPL_ORG';
65: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
66: --
67: begin
61: l_popl_org_id ben_popl_org_f.popl_org_id%TYPE;
62: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
63: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_POPL_ORG';
65: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);
345: --
346: -- Declare cursors and local variables
347: --
348: l_proc varchar2(72) := g_package||'update_POPL_ORG';
349: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
350: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
351: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
352: --
353: begin
346: -- Declare cursors and local variables
347: --
348: l_proc varchar2(72) := g_package||'update_POPL_ORG';
349: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
350: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
351: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
352: --
353: begin
354: --
347: --
348: l_proc varchar2(72) := g_package||'update_POPL_ORG';
349: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
350: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
351: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
352: --
353: begin
354: --
355: hr_utility.set_location('Entering:'|| l_proc, 10);
593: --
594: -- Declare cursors and local variables
595: --
596: l_proc varchar2(72) := g_package||'update_POPL_ORG';
597: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
598: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
599: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
600: --
601: begin
594: -- Declare cursors and local variables
595: --
596: l_proc varchar2(72) := g_package||'update_POPL_ORG';
597: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
598: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
599: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
600: --
601: begin
602: --
595: --
596: l_proc varchar2(72) := g_package||'update_POPL_ORG';
597: l_object_version_number ben_popl_org_f.object_version_number%TYPE;
598: l_effective_start_date ben_popl_org_f.effective_start_date%TYPE;
599: l_effective_end_date ben_popl_org_f.effective_end_date%TYPE;
600: --
601: begin
602: --
603: hr_utility.set_location('Entering:'|| l_proc, 10);