107: --
108: -- When in validation only mode raise the Validate_Enabled exception
109: --
110: if p_validate then
111: raise hr_api.validate_enabled;
112: end if;
113: --
114: -- Set all output arguments
115: --
118:
119:
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
121: exception
122: when hr_api.validate_enabled then
123: --
124: -- As the Validate_Enabled exception has been raised
125: -- we must rollback to the savepoint
126: --
154: ,p_effective_date in date
155: ,p_name in varchar2
156: ,p_description in varchar2
157: ,p_business_group_id in number
158: ,p_start_date_active in date default hr_api.g_date
159: ,p_end_date_active in date default hr_api.g_date
160: ,p_start_time_active in varchar2 default hr_api.g_varchar2
161: ,p_end_time_active in varchar2 default hr_api.g_varchar2
162: ,p_timezone_code in varchar2 default hr_api.g_varchar2
155: ,p_name in varchar2
156: ,p_description in varchar2
157: ,p_business_group_id in number
158: ,p_start_date_active in date default hr_api.g_date
159: ,p_end_date_active in date default hr_api.g_date
160: ,p_start_time_active in varchar2 default hr_api.g_varchar2
161: ,p_end_time_active in varchar2 default hr_api.g_varchar2
162: ,p_timezone_code in varchar2 default hr_api.g_varchar2
163: ,p_public_flag in varchar2 default hr_api.g_varchar2
156: ,p_description in varchar2
157: ,p_business_group_id in number
158: ,p_start_date_active in date default hr_api.g_date
159: ,p_end_date_active in date default hr_api.g_date
160: ,p_start_time_active in varchar2 default hr_api.g_varchar2
161: ,p_end_time_active in varchar2 default hr_api.g_varchar2
162: ,p_timezone_code in varchar2 default hr_api.g_varchar2
163: ,p_public_flag in varchar2 default hr_api.g_varchar2
164: ,p_chat_id in number
157: ,p_business_group_id in number
158: ,p_start_date_active in date default hr_api.g_date
159: ,p_end_date_active in date default hr_api.g_date
160: ,p_start_time_active in varchar2 default hr_api.g_varchar2
161: ,p_end_time_active in varchar2 default hr_api.g_varchar2
162: ,p_timezone_code in varchar2 default hr_api.g_varchar2
163: ,p_public_flag in varchar2 default hr_api.g_varchar2
164: ,p_chat_id in number
165: ,p_object_version_number in out nocopy number) is
158: ,p_start_date_active in date default hr_api.g_date
159: ,p_end_date_active in date default hr_api.g_date
160: ,p_start_time_active in varchar2 default hr_api.g_varchar2
161: ,p_end_time_active in varchar2 default hr_api.g_varchar2
162: ,p_timezone_code in varchar2 default hr_api.g_varchar2
163: ,p_public_flag in varchar2 default hr_api.g_varchar2
164: ,p_chat_id in number
165: ,p_object_version_number in out nocopy number) is
166: --
159: ,p_end_date_active in date default hr_api.g_date
160: ,p_start_time_active in varchar2 default hr_api.g_varchar2
161: ,p_end_time_active in varchar2 default hr_api.g_varchar2
162: ,p_timezone_code in varchar2 default hr_api.g_varchar2
163: ,p_public_flag in varchar2 default hr_api.g_varchar2
164: ,p_chat_id in number
165: ,p_object_version_number in out nocopy number) is
166: --
167: -- Declare cursors and local variables
243: --
244: -- When in validation only mode raise the Validate_Enabled exception
245: --
246: if p_validate then
247: raise hr_api.validate_enabled;
248: end if;
249: --
250: -- Set all output arguments
251: --
250: -- Set all output arguments
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 70);
253: exception
254: when hr_api.validate_enabled then
255: --
256: -- As the Validate_Enabled exception has been raised
257: -- we must rollback to the savepoint
258: --
339: --
340: -- When in validation only mode raise the Validate_Enabled exception
341: --
342: if p_validate then
343: raise hr_api.validate_enabled;
344: end if;
345: --
346: -- Set all output arguments
347: --
347: --
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 170);
350: exception
351: when hr_api.validate_enabled then
352: --
353: -- As the Validate_Enabled exception has been raised
354: -- we must rollback to the savepoint
355: --