48: l_grossup_balances_id pay_grossup_bal_exclusions.grossup_balances_id%TYPE;
49: --
50: begin
51: --
52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: --
54: If p_validate then
55: --
56: -- Issue the savepoint.
58: savepoint create_grossup_bal;
59: --
60: End If;
61: --
62: hr_utility.set_location(l_proc, 20);
63: --
64: -- Process Logic
65: --
66: pay_gbe_ins.ins
77: If p_validate then
78: Raise HR_Api.Validate_Enabled;
79: End If;
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: p_object_version_number := l_object_version_number;
84: p_grossup_balances_id := l_object_version_number;
85: --
134: l_proc varchar2(72) := g_package||'update_grossup_bal.';
135: l_object_version_number pay_grossup_bal_exclusions.object_version_number%TYPE;
136: --
137: begin
138: hr_utility.set_location('Entering:'|| l_proc, 10);
139: --
140: If p_validate then
141: --
142: -- Issue the savepoint.
155: ,p_source_id => p_source_id
156: ,p_source_type => p_source_type
157: ,p_balance_type_id => p_balance_type_id
158: );
159: hr_utility.set_location('Entering:'|| l_proc, 20);
160: --
161: --
162: -- If we are validating then raise the Validate_Enabled exception
163: --
213: l_proc varchar2(72) := g_package||'update_grossup_bal.';
214: --
215: begin
216: --
217: hr_utility.set_location('Entering:'|| l_proc, 10);
218: --
219: If p_validate then
220: --
221: -- Issue the savepoint.
228: (
229: p_grossup_balances_id => p_grossup_balances_id
230: ,p_object_version_number => p_object_version_number
231: );
232: hr_utility.set_location(' Leaving:'||l_proc, 70);
233: --
234: --
235: --
236: -- If we are validating then raise the Validate_Enabled exception
284: l_proc varchar2(72) := g_package||'update_grossup_bal.';
285: --
286: begin
287: --
288: hr_utility.set_location('Entering:'|| l_proc, 10);
289: --
290: pay_gbe_shd.lck
291: (
292: p_grossup_balances_id => p_grossup_balances_id
292: p_grossup_balances_id => p_grossup_balances_id
293: ,p_object_version_number => p_object_version_number
294: );
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 70);
297: --
298: end lck_grossup_bal;
299: --
300: end pay_grossup_bal_excl_api;