1: Package Body PER_BF_PAYROLL_RUNS_API as
2: /* $Header: pebprapi.pkb 115.8 2002/12/02 13:06:45 apholt noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pebprapi.pkb 115.8 2002/12/02 13:06:45 apholt noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PER_BF_PAYROLL_RUNS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------<
10: -- ----------------------------------------------------------------------------
57: --
58: --
59: -- Declare cursors and local variables
60: --
61: l_payroll_run_id PER_BF_PAYROLL_RUNS.PAYROLL_RUN_ID%TYPE;
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
58: --
59: -- Declare cursors and local variables
60: --
61: l_payroll_run_id PER_BF_PAYROLL_RUNS.PAYROLL_RUN_ID%TYPE;
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);
76: --
77: -- Call Before Process User Hook
78: --
79: begin
80: PER_BF_PAYROLL_RUNS_BK1.create_payroll_run_b
81: (p_effective_date => p_effective_date
82: ,p_business_group_id => p_business_group_id
83: ,p_payroll_id => p_payroll_id
84: ,p_payroll_identifier => p_payroll_identifier
180: --
181: -- Call After Process User Hook
182: --
183: begin
184: PER_BF_PAYROLL_RUNS_BK1.create_payroll_run_a
185: (p_effective_date => p_effective_date
186: ,p_business_group_id => p_business_group_id
187: ,p_payroll_id => p_payroll_id
188: ,p_payroll_identifier => p_payroll_identifier
337: --
338: -- Call Before Process User Hook
339: --
340: begin
341: PER_BF_PAYROLL_RUNS_BK2.update_payroll_run_b
342: (p_effective_date => p_effective_date
343: ,p_payroll_identifier => p_payroll_identifier
344: ,p_period_start_date => p_period_start_date
345: ,p_period_end_date => p_period_end_date
441: --
442: -- Call After Process User Hook
443: --
444: begin
445: PER_BF_PAYROLL_RUNS_BK2.update_payroll_run_a
446: (p_effective_date => p_effective_date
447: ,p_payroll_identifier => p_payroll_identifier
448: ,p_period_start_date => p_period_start_date
449: ,p_period_end_date => p_period_end_date
554: --
555: -- Call Before Process User Hook
556: --
557: begin
558: PER_BF_PAYROLL_RUNS_BK3.delete_payroll_run_b
559: (
560: p_payroll_run_id => p_payroll_run_id
561: ,p_object_version_number => p_object_version_number
562: );
585: --
586: -- Call After Process User Hook
587: --
588: begin
589: PER_BF_PAYROLL_RUNS_BK3.delete_payroll_run_a
590: (
591: p_payroll_run_id => p_payroll_run_id
592: ,p_object_version_number => p_object_version_number
593: );
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;