74: ,p_object_version_number => l_object_version_number
75: );
76: --
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: --
84: p_grossup_balances_id := l_object_version_number;
85: --
86: exception
87: --
88: when HR_Api.Validate_Enabled then
89: --
90: -- A validation or unexpected error has occured
91: --
92: ROLLBACK TO create_grossup_bal;
121: (
122: p_validate in boolean default false
123: ,p_grossup_balances_id in number
124: ,p_object_version_number in out nocopy number
125: ,p_start_date in date default hr_api.g_date
126: ,p_end_date in date default hr_api.g_date
127: ,p_source_id in number default hr_api.g_number
128: ,p_source_type in varchar2 default hr_api.g_varchar2
129: ,p_balance_type_id in number default hr_api.g_number
122: p_validate in boolean default false
123: ,p_grossup_balances_id in number
124: ,p_object_version_number in out nocopy number
125: ,p_start_date in date default hr_api.g_date
126: ,p_end_date in date default hr_api.g_date
127: ,p_source_id in number default hr_api.g_number
128: ,p_source_type in varchar2 default hr_api.g_varchar2
129: ,p_balance_type_id in number default hr_api.g_number
130: ) is
123: ,p_grossup_balances_id in number
124: ,p_object_version_number in out nocopy number
125: ,p_start_date in date default hr_api.g_date
126: ,p_end_date in date default hr_api.g_date
127: ,p_source_id in number default hr_api.g_number
128: ,p_source_type in varchar2 default hr_api.g_varchar2
129: ,p_balance_type_id in number default hr_api.g_number
130: ) is
131: --
124: ,p_object_version_number in out nocopy number
125: ,p_start_date in date default hr_api.g_date
126: ,p_end_date in date default hr_api.g_date
127: ,p_source_id in number default hr_api.g_number
128: ,p_source_type in varchar2 default hr_api.g_varchar2
129: ,p_balance_type_id in number default hr_api.g_number
130: ) is
131: --
132: -- Declare cursors and local variables
125: ,p_start_date in date default hr_api.g_date
126: ,p_end_date in date default hr_api.g_date
127: ,p_source_id in number default hr_api.g_number
128: ,p_source_type in varchar2 default hr_api.g_varchar2
129: ,p_balance_type_id in number default hr_api.g_number
130: ) is
131: --
132: -- Declare cursors and local variables
133: --
161: --
162: -- If we are validating then raise the Validate_Enabled exception
163: --
164: If p_validate then
165: Raise HR_Api.Validate_Enabled;
166: End If;
167: --
168: p_object_version_number := l_object_version_number;
169: --
168: p_object_version_number := l_object_version_number;
169: --
170: exception
171: --
172: when HR_Api.Validate_Enabled then
173: --
174: -- A validation or unexpected error has occured
175: --
176: ROLLBACK TO update_grossup_bal;
235: --
236: -- If we are validating then raise the Validate_Enabled exception
237: --
238: If p_validate then
239: Raise HR_Api.Validate_Enabled;
240: End If;
241: --
242: exception
243: when HR_Api.Validate_Enabled then
239: Raise HR_Api.Validate_Enabled;
240: End If;
241: --
242: exception
243: when HR_Api.Validate_Enabled then
244: --
245: -- A validation or unexpected error has occured
246: --
247: ROLLBACK TO delete_grossup_bal;