DBA Data[Home] [Help]

APPS.HR_DE_LIABILITY_PREMIUMS_API dependencies on HR_DE_LIABILITY_PREMIUMS_F

Line 50: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;

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

Line 51: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE;

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);

Line 52: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;

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: --

Line 53: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;

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

Line 265: l_liability_premiums_id hr_de_liability_premiums_f.liability_premiums_id%TYPE;

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;

Line 266: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE := p_object_version_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;

Line 267: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;

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

Line 268: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;

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);

Line 458: l_object_version_number hr_de_liability_premiums_f.object_version_number%TYPE := p_object_version_number;

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;

Line 459: l_effective_start_date hr_de_liability_premiums_f.effective_start_date%TYPE;

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

Line 460: l_effective_end_date hr_de_liability_premiums_f.effective_end_date%TYPE;

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);