62: l_object_version_number PER_BF_PAYROLL_RUNS.OBJECT_VERSION_NUMBER%TYPE;
63: --
64: l_proc varchar2(72) := g_package||'create_payroll_run';
65: begin
66: hr_utility.set_location('Entering:'|| l_proc, 10);
67: --
68: -- Issue a savepoint
69: --
70: savepoint create_payroll_run;
67: --
68: -- Issue a savepoint
69: --
70: savepoint create_payroll_run;
71: hr_utility.set_location(l_proc, 20);
72: --
73: -- Truncate the time portion from all IN date parameters
74: --
75:
123: (p_module_name => 'create_payroll_run'
124: ,p_hook_type => 'BP'
125: );
126: end;
127: hr_utility.set_location(l_proc, 30);
128: --
129: -- Validation in addition to Row Handlers
130: --
131: hr_utility.set_location(l_proc, 40);
127: hr_utility.set_location(l_proc, 30);
128: --
129: -- Validation in addition to Row Handlers
130: --
131: hr_utility.set_location(l_proc, 40);
132: --
133: -- Process Logic
134: --
135: per_bpr_ins.ins
175: ,p_payroll_run_id => l_payroll_run_id -- Out
176: ,p_object_version_number => l_object_version_number -- Out
177: );
178: --
179: hr_utility.set_location(l_proc, 50);
180: --
181: -- Call After Process User Hook
182: --
183: begin
229: (p_module_name => 'create_payroll_run'
230: ,p_hook_type => 'AP'
231: );
232: end;
233: hr_utility.set_location(l_proc, 60);
234: --
235: -- When in validation only mode raise the Validate_Enabled exception
236: --
237: if p_validate then
242: --
243: p_payroll_run_id := l_payroll_run_id;
244: p_object_version_number := l_object_version_number;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: exception
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised
257: -- when validation only mode is being used.)
258: --
259: p_payroll_run_id := null;
260: p_object_version_number := null;
261: hr_utility.set_location(' Leaving:'||l_proc, 80);
262: when others then
263: --
264: -- A validation or unexpected error has occured
265: --
266: rollback to create_payroll_run;
267: --set out NOCOPY variables
268: p_payroll_run_id := null;
269: p_object_version_number := null;
270: hr_utility.set_location(' Leaving:'||l_proc, 90);
271: raise;
272: end create_payroll_run;
273: --
274: -- ----------------------------------------------------------------------------
323: --
324: l_object_version_number NUMBER;
325: l_proc varchar2(72) := g_package||'update_payroll_run';
326: begin
327: hr_utility.set_location('Entering:'|| l_proc, 10);
328: --
329: -- Issue a savepoint
330: --
331: savepoint update_payroll_run;
328: --
329: -- Issue a savepoint
330: --
331: savepoint update_payroll_run;
332: hr_utility.set_location(l_proc, 20);
333: --
334: -- Truncate the time portion from all IN date parameters
335: --
336:
384: (p_module_name => 'update_payroll_run'
385: ,p_hook_type => 'BP'
386: );
387: end;
388: hr_utility.set_location(l_proc, 30);
389: --
390: -- Validation in addition to Row Handlers
391: --
392: hr_utility.set_location(l_proc, 40);
388: hr_utility.set_location(l_proc, 30);
389: --
390: -- Validation in addition to Row Handlers
391: --
392: hr_utility.set_location(l_proc, 40);
393: --
394: -- Process Logic
395: --
396: l_object_version_number := p_object_version_number;
436: ,p_bpr_attribute30 => p_bpr_attribute30
437: ,p_object_version_number => l_object_version_number -- Out
438: );
439: --
440: hr_utility.set_location(l_proc, 50);
441: --
442: -- Call After Process User Hook
443: --
444: begin
488: (p_module_name => 'update_payroll_run'
489: ,p_hook_type => 'AP'
490: );
491: end;
492: hr_utility.set_location(l_proc, 60);
493: --
494: -- When in validation only mode raise the Validate_Enabled exception
495: --
496: if p_validate then
500: -- Set all output arguments
501: --
502: p_object_version_number := l_object_version_number;
503: --
504: hr_utility.set_location(' Leaving:'||l_proc, 70);
505: exception
506: when hr_api.validate_enabled then
507: --
508: -- As the Validate_Enabled exception has been raised
514: -- (Any key or derived arguments must be set to null
515: -- when validation only mode is being used.)
516: --
517: p_object_version_number := null;
518: hr_utility.set_location(' Leaving:'||l_proc, 80);
519: when others then
520: --
521: -- A validation or unexpected error has occured
522: --
520: --
521: -- A validation or unexpected error has occured
522: --
523: rollback to update_payroll_run;
524: hr_utility.set_location(' Leaving:'||l_proc, 90);
525: raise;
526: end update_payroll_run;
527: --
528: -- ----------------------------------------------------------------------------
540: -- Declare cursors and local variables
541: --
542: l_proc varchar2(72) := g_package||'delete_payroll_run';
543: begin
544: hr_utility.set_location('Entering:'|| l_proc, 10);
545: --
546: -- Issue a savepoint
547: --
548: savepoint delete_payroll_run;
545: --
546: -- Issue a savepoint
547: --
548: savepoint delete_payroll_run;
549: hr_utility.set_location(l_proc, 20);
550: --
551: -- Truncate the time portion from all IN date parameters
552: --
553:
566: (p_module_name => 'delete_payroll_run'
567: ,p_hook_type => 'BP'
568: );
569: end;
570: hr_utility.set_location(l_proc, 30);
571: --
572: -- Validation in addition to Row Handlers
573: --
574: hr_utility.set_location(l_proc, 40);
570: hr_utility.set_location(l_proc, 30);
571: --
572: -- Validation in addition to Row Handlers
573: --
574: hr_utility.set_location(l_proc, 40);
575: --
576: -- Process Logic
577: --
578: per_bpr_del.del
580: p_payroll_run_id => p_payroll_run_id
581: ,p_object_version_number => p_object_version_number
582: );
583: --
584: hr_utility.set_location(l_proc, 50);
585: --
586: -- Call After Process User Hook
587: --
588: begin
597: (p_module_name => 'delete_payroll_run'
598: ,p_hook_type => 'AP'
599: );
600: end;
601: hr_utility.set_location(l_proc, 60);
602: --
603: -- When in validation only mode raise the Validate_Enabled exception
604: --
605: if p_validate then
607: end if;
608: --
609: -- Set all output arguments
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 70);
612: exception
613: when hr_api.validate_enabled then
614: --
615: -- As the Validate_Enabled exception has been raised
620: -- Only set output warning arguments
621: -- (Any key or derived arguments must be set to null
622: -- when validation only mode is being used.)
623: --
624: hr_utility.set_location(' Leaving:'||l_proc, 80);
625: when others then
626: --
627: -- A validation or unexpected error has occured
628: --
626: --
627: -- A validation or unexpected error has occured
628: --
629: rollback to delete_payroll_run;
630: hr_utility.set_location(' Leaving:'||l_proc, 90);
631: raise;
632: end delete_payroll_run;
633: end PER_BF_PAYROLL_RUNS_API;