55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_prem_cstg_by_sgmt_id ben_prem_cstg_by_sgmt_f.prem_cstg_by_sgmt_id%TYPE;
60: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PREM_CSTG_BY_SGMT';
63: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
56: --
57: -- Declare cursors and local variables
58: --
59: l_prem_cstg_by_sgmt_id ben_prem_cstg_by_sgmt_f.prem_cstg_by_sgmt_id%TYPE;
60: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PREM_CSTG_BY_SGMT';
63: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
64: --
57: -- Declare cursors and local variables
58: --
59: l_prem_cstg_by_sgmt_id ben_prem_cstg_by_sgmt_f.prem_cstg_by_sgmt_id%TYPE;
60: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PREM_CSTG_BY_SGMT';
63: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
64: --
65: begin
59: l_prem_cstg_by_sgmt_id ben_prem_cstg_by_sgmt_f.prem_cstg_by_sgmt_id%TYPE;
60: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PREM_CSTG_BY_SGMT';
63: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
336: --
337: -- Declare cursors and local variables
338: --
339: l_proc varchar2(72) := g_package||'update_PREM_CSTG_BY_SGMT';
340: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
341: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
342: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
343: --
344: begin
337: -- Declare cursors and local variables
338: --
339: l_proc varchar2(72) := g_package||'update_PREM_CSTG_BY_SGMT';
340: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
341: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
342: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
343: --
344: begin
345: --
338: --
339: l_proc varchar2(72) := g_package||'update_PREM_CSTG_BY_SGMT';
340: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
341: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
342: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
343: --
344: begin
345: --
346: hr_utility.set_location('Entering:'|| l_proc, 10);
578: --
579: -- Declare cursors and local variables
580: --
581: l_proc varchar2(72) := g_package||'update_PREM_CSTG_BY_SGMT';
582: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
583: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
584: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
585: --
586: begin
579: -- Declare cursors and local variables
580: --
581: l_proc varchar2(72) := g_package||'update_PREM_CSTG_BY_SGMT';
582: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
583: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
584: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
585: --
586: begin
587: --
580: --
581: l_proc varchar2(72) := g_package||'update_PREM_CSTG_BY_SGMT';
582: l_object_version_number ben_prem_cstg_by_sgmt_f.object_version_number%TYPE;
583: l_effective_start_date ben_prem_cstg_by_sgmt_f.effective_start_date%TYPE;
584: l_effective_end_date ben_prem_cstg_by_sgmt_f.effective_end_date%TYPE;
585: --
586: begin
587: --
588: hr_utility.set_location('Entering:'|| l_proc, 10);