46: --
47: -- Declare cursors and local variables
48: --
49: l_proc varchar2(72) := g_package||'create_premium';
50: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;
51: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE;
52: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
53: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
54: begin
47: -- Declare cursors and local variables
48: --
49: l_proc varchar2(72) := g_package||'create_premium';
50: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;
51: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE;
52: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
53: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
54: begin
55: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: l_proc varchar2(72) := g_package||'create_premium';
50: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;
51: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE;
52: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
53: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
54: begin
55: hr_utility.set_location('Entering:'|| l_proc, 10);
56: --
49: l_proc varchar2(72) := g_package||'create_premium';
50: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;
51: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE;
52: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
53: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
54: begin
55: hr_utility.set_location('Entering:'|| l_proc, 10);
56: --
57: -- Issue a savepoint
261: --
262: -- Declare cursors and local variables
263: --
264: l_proc varchar2(72) := g_package||'update_premium';
265: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;
266: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE := p_object_version_number;
267: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
268: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
269: l_organization_link_id_o number;
262: -- Declare cursors and local variables
263: --
264: l_proc varchar2(72) := g_package||'update_premium';
265: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;
266: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE := p_object_version_number;
267: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
268: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
269: l_organization_link_id_o number;
270: l_temp_ovn number := p_object_version_number;
263: --
264: l_proc varchar2(72) := g_package||'update_premium';
265: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;
266: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE := p_object_version_number;
267: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
268: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
269: l_organization_link_id_o number;
270: l_temp_ovn number := p_object_version_number;
271: begin
264: l_proc varchar2(72) := g_package||'update_premium';
265: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;
266: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE := p_object_version_number;
267: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
268: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
269: l_organization_link_id_o number;
270: l_temp_ovn number := p_object_version_number;
271: begin
272: hr_utility.set_location('Entering:'|| l_proc, 10);
454: --
455: -- Declare cursors and local variables
456: --
457: l_proc varchar2(72) := g_package||'delete_premium';
458: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE := p_object_version_number;
459: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
460: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
461: l_organization_link_id_o number;
462: l_temp_ovn number := p_object_version_number;
455: -- Declare cursors and local variables
456: --
457: l_proc varchar2(72) := g_package||'delete_premium';
458: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE := p_object_version_number;
459: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
460: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
461: l_organization_link_id_o number;
462: l_temp_ovn number := p_object_version_number;
463: begin
456: --
457: l_proc varchar2(72) := g_package||'delete_premium';
458: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE := p_object_version_number;
459: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;
460: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;
461: l_organization_link_id_o number;
462: l_temp_ovn number := p_object_version_number;
463: begin
464: hr_utility.set_location('Entering:'|| l_proc, 10);