34: --
35: -- Declare cursors and local variables
36: --
37: l_proc varchar2(70) := g_package||'create_calendar_entry';
38: l_calendar_entry_id per_calendar_entries.calendar_entry_id%TYPE;
39: l_object_version_number per_calendar_entries.object_version_number%TYPE;
40: l_leg_code per_calendar_entries.legislation_code%TYPE;
41: l_effective_date date;
42: --
35: -- Declare cursors and local variables
36: --
37: l_proc varchar2(70) := g_package||'create_calendar_entry';
38: l_calendar_entry_id per_calendar_entries.calendar_entry_id%TYPE;
39: l_object_version_number per_calendar_entries.object_version_number%TYPE;
40: l_leg_code per_calendar_entries.legislation_code%TYPE;
41: l_effective_date date;
42: --
43: begin
36: --
37: l_proc varchar2(70) := g_package||'create_calendar_entry';
38: l_calendar_entry_id per_calendar_entries.calendar_entry_id%TYPE;
39: l_object_version_number per_calendar_entries.object_version_number%TYPE;
40: l_leg_code per_calendar_entries.legislation_code%TYPE;
41: l_effective_date date;
42: --
43: begin
44: hr_utility.set_location('Entering:'|| l_proc, 10);
201: --
202: -- Declare cursors and local variables
203: --
204: l_proc varchar2(80) := g_package||'update_calendar_entry';
205: l_calendar_entry_id per_calendar_entries.calendar_entry_id%TYPE;
206: l_object_version_number per_calendar_entries.object_version_number%TYPE;
207: l_effective_date date;
208: --
209: begin
202: -- Declare cursors and local variables
203: --
204: l_proc varchar2(80) := g_package||'update_calendar_entry';
205: l_calendar_entry_id per_calendar_entries.calendar_entry_id%TYPE;
206: l_object_version_number per_calendar_entries.object_version_number%TYPE;
207: l_effective_date date;
208: --
209: begin
210: hr_utility.set_location('Entering:'|| l_proc, 10);