11: -- ----------------------------------------------------------------------------
12: --
13: procedure create_time_source
14: (p_validate in boolean default false
15: ,p_time_source_id in out nocopy hxc_time_sources.time_source_id%TYPE
16: ,p_object_version_number in out nocopy hxc_time_sources.object_version_number%TYPE
17: ,p_name in varchar2
18: ) is
19: --
12: --
13: procedure create_time_source
14: (p_validate in boolean default false
15: ,p_time_source_id in out nocopy hxc_time_sources.time_source_id%TYPE
16: ,p_object_version_number in out nocopy hxc_time_sources.object_version_number%TYPE
17: ,p_name in varchar2
18: ) is
19: --
20: -- Declare cursors and local variables
19: --
20: -- Declare cursors and local variables
21: --
22: l_proc varchar2(72);
23: l_object_version_number hxc_time_sources.object_version_number%TYPE;
24: l_time_source_id hxc_time_sources.time_source_id%TYPE;
25: --
26: begin
27: g_debug := hr_utility.debug_enabled;
20: -- Declare cursors and local variables
21: --
22: l_proc varchar2(72);
23: l_object_version_number hxc_time_sources.object_version_number%TYPE;
24: l_time_source_id hxc_time_sources.time_source_id%TYPE;
25: --
26: begin
27: g_debug := hr_utility.debug_enabled;
28: --
151: -- ----------------------------------------------------------------------------
152: --
153: procedure update_time_source
154: (p_validate in boolean default false
155: ,p_time_source_id in hxc_time_sources.time_source_id%TYPE
156: ,p_object_version_number in out nocopy hxc_time_sources.object_version_number%TYPE
157: ,p_name in hxc_time_sources.name%TYPE
158: ) is
159: --
152: --
153: procedure update_time_source
154: (p_validate in boolean default false
155: ,p_time_source_id in hxc_time_sources.time_source_id%TYPE
156: ,p_object_version_number in out nocopy hxc_time_sources.object_version_number%TYPE
157: ,p_name in hxc_time_sources.name%TYPE
158: ) is
159: --
160: -- Declare cursors and local variables
153: procedure update_time_source
154: (p_validate in boolean default false
155: ,p_time_source_id in hxc_time_sources.time_source_id%TYPE
156: ,p_object_version_number in out nocopy hxc_time_sources.object_version_number%TYPE
157: ,p_name in hxc_time_sources.name%TYPE
158: ) is
159: --
160: -- Declare cursors and local variables
161: --
159: --
160: -- Declare cursors and local variables
161: --
162: l_proc varchar2(72);
163: l_object_version_number hxc_time_sources.object_version_number%TYPE := p_object_version_number;
164: --
165: begin
166: g_debug := hr_utility.debug_enabled;
167: --
283: -- ----------------------------------------------------------------------------
284: --
285: procedure delete_time_source
286: (p_validate in boolean default false
287: ,p_time_source_id in hxc_time_sources.time_source_id%TYPE
288: ,p_object_version_number in hxc_time_sources.object_version_number%TYPE
289: ) is
290: --
291: -- Declare cursors and local variables
284: --
285: procedure delete_time_source
286: (p_validate in boolean default false
287: ,p_time_source_id in hxc_time_sources.time_source_id%TYPE
288: ,p_object_version_number in hxc_time_sources.object_version_number%TYPE
289: ) is
290: --
291: -- Declare cursors and local variables
292: --