58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_popl_actn_typ_id ben_popl_actn_typ_f.popl_actn_typ_id%TYPE;
63: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
64: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_POPL_ACTION_TYPE';
66: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
59: --
60: -- Declare cursors and local variables
61: --
62: l_popl_actn_typ_id ben_popl_actn_typ_f.popl_actn_typ_id%TYPE;
63: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
64: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_POPL_ACTION_TYPE';
66: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
67: --
60: -- Declare cursors and local variables
61: --
62: l_popl_actn_typ_id ben_popl_actn_typ_f.popl_actn_typ_id%TYPE;
63: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
64: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_POPL_ACTION_TYPE';
66: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
67: --
68: begin
62: l_popl_actn_typ_id ben_popl_actn_typ_f.popl_actn_typ_id%TYPE;
63: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
64: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_POPL_ACTION_TYPE';
66: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);
352: --
353: -- Declare cursors and local variables
354: --
355: l_proc varchar2(72) := g_package||'update_POPL_ACTION_TYPE';
356: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
357: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
358: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
359: --
360: begin
353: -- Declare cursors and local variables
354: --
355: l_proc varchar2(72) := g_package||'update_POPL_ACTION_TYPE';
356: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
357: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
358: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
359: --
360: begin
361: --
354: --
355: l_proc varchar2(72) := g_package||'update_POPL_ACTION_TYPE';
356: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
357: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
358: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
359: --
360: begin
361: --
362: hr_utility.set_location('Entering:'|| l_proc, 10);
607: --
608: -- Declare cursors and local variables
609: --
610: l_proc varchar2(72) := g_package||'update_POPL_ACTION_TYPE';
611: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
612: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
613: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
614: --
615: begin
608: -- Declare cursors and local variables
609: --
610: l_proc varchar2(72) := g_package||'update_POPL_ACTION_TYPE';
611: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
612: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
613: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
614: --
615: begin
616: --
609: --
610: l_proc varchar2(72) := g_package||'update_POPL_ACTION_TYPE';
611: l_object_version_number ben_popl_actn_typ_f.object_version_number%TYPE;
612: l_effective_start_date ben_popl_actn_typ_f.effective_start_date%TYPE;
613: l_effective_end_date ben_popl_actn_typ_f.effective_end_date%TYPE;
614: --
615: begin
616: --
617: hr_utility.set_location('Entering:'|| l_proc, 10);