[Home] [Help]
30: l_date_start date;
31: l_date_end date;
32: l_proc varchar2(72) := g_package||'create_duration_summary';
33: begin
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35: --
36: -- Issue a savepoint
37: --
38: savepoint create_duration_summary;
126: --
127: p_gap_duration_summary_id := l_gap_duration_summary_id;
128: p_object_version_number := l_object_version_number;
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: exception
132: when hr_api.validate_enabled then
133: --
134: -- As the Validate_Enabled exception has been raised
141: -- when validation only mode is being used.)
142: --
143: p_gap_duration_summary_id := null;
144: p_object_version_number := null;
145: hr_utility.set_location(' Leaving:'||l_proc, 80);
146: when others then
147: --
148: -- A validation or unexpected error has occured
149: --
153: -- OUT parameters, including warnings, to null
154: --
155: p_gap_duration_summary_id := null;
156: p_object_version_number := null;
157: hr_utility.set_location(' Leaving:'||l_proc, 90);
158: raise;
159: end create_duration_summary;
160: --
161: --
183: l_date_start date;
184: l_date_end date;
185: l_proc varchar2(72) := g_package||'update_duration_summary';
186: begin
187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: --
189: -- Issue a savepoint
190: --
191: savepoint update_duration_summary;
279: -- Set all IN OUT and OUT parameters with out values
280: --
281: p_object_version_number := l_object_version_number;
282: --
283: hr_utility.set_location(' Leaving:'||l_proc, 70);
284: exception
285: when hr_api.validate_enabled then
286: --
287: -- As the Validate_Enabled exception has been raised
293: -- (Any key or derived arguments must be set to null
294: -- when validation only mode is being used.)
295: --
296: p_object_version_number := null;
297: hr_utility.set_location(' Leaving:'||l_proc, 80);
298: when others then
299: --
300: -- A validation or unexpected error has occured
301: --
304: -- Reset IN OUT parameters and set all
305: -- OUT parameters, including warnings, to null
306: --
307: p_object_version_number := null;
308: hr_utility.set_location(' Leaving:'||l_proc, 90);
309: raise;
310: end update_duration_summary;
311: --
312: --
324: --
325: l_object_version_number number;
326: l_proc varchar2(72) := g_package||'delete_duration_summary';
327: begin
328: hr_utility.set_location('Entering:'|| l_proc, 10);
329: --
330: -- Issue a savepoint
331: --
332: savepoint delete_duration_summary;
389: -- Set all IN OUT and OUT parameters with out values
390: --
391: -- p_object_version_number := l_object_version_number;
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 70);
394: exception
395: when hr_api.validate_enabled then
396: --
397: -- As the Validate_Enabled exception has been raised
403: -- (Any key or derived arguments must be set to null
404: -- when validation only mode is being used.)
405: --
406: -- p_object_version_number := null;
407: hr_utility.set_location(' Leaving:'||l_proc, 80);
408: when others then
409: --
410: -- A validation or unexpected error has occured
411: --
414: -- Reset IN OUT parameters and set all
415: -- OUT parameters, including warnings, to null
416: --
417: -- p_object_version_number := null;
418: hr_utility.set_location(' Leaving:'||l_proc, 90);
419: raise;
420: end delete_duration_summary;
421: --
422: end pqp_gds_api;