94: ,p_attribute19 => p_attribute19
95: ,p_attribute20 => p_attribute20
96: ,p_object_version_number => p_object_version_number);
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'CREATE_ANNOUNCEMENT'
101: ,p_hook_type => 'BP'
102: );
95: ,p_attribute20 => p_attribute20
96: ,p_object_version_number => p_object_version_number);
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'CREATE_ANNOUNCEMENT'
101: ,p_hook_type => 'BP'
102: );
103: end;
184: ,p_attribute20 => p_attribute20
185: ,p_announcement_id => l_announcement_id
186: ,p_object_version_number => l_object_version_number);
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'CREATE_ANNOUNCEMENT'
191: ,p_hook_type => 'AP'
192: );
185: ,p_announcement_id => l_announcement_id
186: ,p_object_version_number => l_object_version_number);
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'CREATE_ANNOUNCEMENT'
191: ,p_hook_type => 'AP'
192: );
193: end;
195: --
196: -- When in validation only mode raise the Validate_Enabled exception
197: --
198: if p_validate then
199: raise hr_api.validate_enabled;
200: end if;
201: --
202: -- Set all output arguments
203: --
206:
207:
208: hr_utility.set_location(' Leaving:'||l_proc, 70);
209: exception
210: when hr_api.validate_enabled then
211: --
212: -- As the Validate_Enabled exception has been raised
213: -- we must rollback to the savepoint
214: --
240: ,p_effective_date in date
241: ,p_announcement_title in varchar2
242: ,p_announcement_body in varchar2
243: ,p_business_group_id in number
244: ,p_start_date_active in date default hr_api.g_date
245: ,p_end_date_active in date default hr_api.g_date
246: ,p_owner_id in number default hr_api.g_number
247: ,p_attribute_category in varchar2 default hr_api.g_varchar2
248: ,p_attribute1 in varchar2 default hr_api.g_varchar2
241: ,p_announcement_title in varchar2
242: ,p_announcement_body in varchar2
243: ,p_business_group_id in number
244: ,p_start_date_active in date default hr_api.g_date
245: ,p_end_date_active in date default hr_api.g_date
246: ,p_owner_id in number default hr_api.g_number
247: ,p_attribute_category in varchar2 default hr_api.g_varchar2
248: ,p_attribute1 in varchar2 default hr_api.g_varchar2
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2
242: ,p_announcement_body in varchar2
243: ,p_business_group_id in number
244: ,p_start_date_active in date default hr_api.g_date
245: ,p_end_date_active in date default hr_api.g_date
246: ,p_owner_id in number default hr_api.g_number
247: ,p_attribute_category in varchar2 default hr_api.g_varchar2
248: ,p_attribute1 in varchar2 default hr_api.g_varchar2
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2
250: ,p_attribute3 in varchar2 default hr_api.g_varchar2
243: ,p_business_group_id in number
244: ,p_start_date_active in date default hr_api.g_date
245: ,p_end_date_active in date default hr_api.g_date
246: ,p_owner_id in number default hr_api.g_number
247: ,p_attribute_category in varchar2 default hr_api.g_varchar2
248: ,p_attribute1 in varchar2 default hr_api.g_varchar2
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2
250: ,p_attribute3 in varchar2 default hr_api.g_varchar2
251: ,p_attribute4 in varchar2 default hr_api.g_varchar2
244: ,p_start_date_active in date default hr_api.g_date
245: ,p_end_date_active in date default hr_api.g_date
246: ,p_owner_id in number default hr_api.g_number
247: ,p_attribute_category in varchar2 default hr_api.g_varchar2
248: ,p_attribute1 in varchar2 default hr_api.g_varchar2
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2
250: ,p_attribute3 in varchar2 default hr_api.g_varchar2
251: ,p_attribute4 in varchar2 default hr_api.g_varchar2
252: ,p_attribute5 in varchar2 default hr_api.g_varchar2
245: ,p_end_date_active in date default hr_api.g_date
246: ,p_owner_id in number default hr_api.g_number
247: ,p_attribute_category in varchar2 default hr_api.g_varchar2
248: ,p_attribute1 in varchar2 default hr_api.g_varchar2
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2
250: ,p_attribute3 in varchar2 default hr_api.g_varchar2
251: ,p_attribute4 in varchar2 default hr_api.g_varchar2
252: ,p_attribute5 in varchar2 default hr_api.g_varchar2
253: ,p_attribute6 in varchar2 default hr_api.g_varchar2
246: ,p_owner_id in number default hr_api.g_number
247: ,p_attribute_category in varchar2 default hr_api.g_varchar2
248: ,p_attribute1 in varchar2 default hr_api.g_varchar2
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2
250: ,p_attribute3 in varchar2 default hr_api.g_varchar2
251: ,p_attribute4 in varchar2 default hr_api.g_varchar2
252: ,p_attribute5 in varchar2 default hr_api.g_varchar2
253: ,p_attribute6 in varchar2 default hr_api.g_varchar2
254: ,p_attribute7 in varchar2 default hr_api.g_varchar2
247: ,p_attribute_category in varchar2 default hr_api.g_varchar2
248: ,p_attribute1 in varchar2 default hr_api.g_varchar2
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2
250: ,p_attribute3 in varchar2 default hr_api.g_varchar2
251: ,p_attribute4 in varchar2 default hr_api.g_varchar2
252: ,p_attribute5 in varchar2 default hr_api.g_varchar2
253: ,p_attribute6 in varchar2 default hr_api.g_varchar2
254: ,p_attribute7 in varchar2 default hr_api.g_varchar2
255: ,p_attribute8 in varchar2 default hr_api.g_varchar2
248: ,p_attribute1 in varchar2 default hr_api.g_varchar2
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2
250: ,p_attribute3 in varchar2 default hr_api.g_varchar2
251: ,p_attribute4 in varchar2 default hr_api.g_varchar2
252: ,p_attribute5 in varchar2 default hr_api.g_varchar2
253: ,p_attribute6 in varchar2 default hr_api.g_varchar2
254: ,p_attribute7 in varchar2 default hr_api.g_varchar2
255: ,p_attribute8 in varchar2 default hr_api.g_varchar2
256: ,p_attribute9 in varchar2 default hr_api.g_varchar2
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2
250: ,p_attribute3 in varchar2 default hr_api.g_varchar2
251: ,p_attribute4 in varchar2 default hr_api.g_varchar2
252: ,p_attribute5 in varchar2 default hr_api.g_varchar2
253: ,p_attribute6 in varchar2 default hr_api.g_varchar2
254: ,p_attribute7 in varchar2 default hr_api.g_varchar2
255: ,p_attribute8 in varchar2 default hr_api.g_varchar2
256: ,p_attribute9 in varchar2 default hr_api.g_varchar2
257: ,p_attribute10 in varchar2 default hr_api.g_varchar2
250: ,p_attribute3 in varchar2 default hr_api.g_varchar2
251: ,p_attribute4 in varchar2 default hr_api.g_varchar2
252: ,p_attribute5 in varchar2 default hr_api.g_varchar2
253: ,p_attribute6 in varchar2 default hr_api.g_varchar2
254: ,p_attribute7 in varchar2 default hr_api.g_varchar2
255: ,p_attribute8 in varchar2 default hr_api.g_varchar2
256: ,p_attribute9 in varchar2 default hr_api.g_varchar2
257: ,p_attribute10 in varchar2 default hr_api.g_varchar2
258: ,p_attribute11 in varchar2 default hr_api.g_varchar2
251: ,p_attribute4 in varchar2 default hr_api.g_varchar2
252: ,p_attribute5 in varchar2 default hr_api.g_varchar2
253: ,p_attribute6 in varchar2 default hr_api.g_varchar2
254: ,p_attribute7 in varchar2 default hr_api.g_varchar2
255: ,p_attribute8 in varchar2 default hr_api.g_varchar2
256: ,p_attribute9 in varchar2 default hr_api.g_varchar2
257: ,p_attribute10 in varchar2 default hr_api.g_varchar2
258: ,p_attribute11 in varchar2 default hr_api.g_varchar2
259: ,p_attribute12 in varchar2 default hr_api.g_varchar2
252: ,p_attribute5 in varchar2 default hr_api.g_varchar2
253: ,p_attribute6 in varchar2 default hr_api.g_varchar2
254: ,p_attribute7 in varchar2 default hr_api.g_varchar2
255: ,p_attribute8 in varchar2 default hr_api.g_varchar2
256: ,p_attribute9 in varchar2 default hr_api.g_varchar2
257: ,p_attribute10 in varchar2 default hr_api.g_varchar2
258: ,p_attribute11 in varchar2 default hr_api.g_varchar2
259: ,p_attribute12 in varchar2 default hr_api.g_varchar2
260: ,p_attribute13 in varchar2 default hr_api.g_varchar2
253: ,p_attribute6 in varchar2 default hr_api.g_varchar2
254: ,p_attribute7 in varchar2 default hr_api.g_varchar2
255: ,p_attribute8 in varchar2 default hr_api.g_varchar2
256: ,p_attribute9 in varchar2 default hr_api.g_varchar2
257: ,p_attribute10 in varchar2 default hr_api.g_varchar2
258: ,p_attribute11 in varchar2 default hr_api.g_varchar2
259: ,p_attribute12 in varchar2 default hr_api.g_varchar2
260: ,p_attribute13 in varchar2 default hr_api.g_varchar2
261: ,p_attribute14 in varchar2 default hr_api.g_varchar2
254: ,p_attribute7 in varchar2 default hr_api.g_varchar2
255: ,p_attribute8 in varchar2 default hr_api.g_varchar2
256: ,p_attribute9 in varchar2 default hr_api.g_varchar2
257: ,p_attribute10 in varchar2 default hr_api.g_varchar2
258: ,p_attribute11 in varchar2 default hr_api.g_varchar2
259: ,p_attribute12 in varchar2 default hr_api.g_varchar2
260: ,p_attribute13 in varchar2 default hr_api.g_varchar2
261: ,p_attribute14 in varchar2 default hr_api.g_varchar2
262: ,p_attribute15 in varchar2 default hr_api.g_varchar2
255: ,p_attribute8 in varchar2 default hr_api.g_varchar2
256: ,p_attribute9 in varchar2 default hr_api.g_varchar2
257: ,p_attribute10 in varchar2 default hr_api.g_varchar2
258: ,p_attribute11 in varchar2 default hr_api.g_varchar2
259: ,p_attribute12 in varchar2 default hr_api.g_varchar2
260: ,p_attribute13 in varchar2 default hr_api.g_varchar2
261: ,p_attribute14 in varchar2 default hr_api.g_varchar2
262: ,p_attribute15 in varchar2 default hr_api.g_varchar2
263: ,p_attribute16 in varchar2 default hr_api.g_varchar2
256: ,p_attribute9 in varchar2 default hr_api.g_varchar2
257: ,p_attribute10 in varchar2 default hr_api.g_varchar2
258: ,p_attribute11 in varchar2 default hr_api.g_varchar2
259: ,p_attribute12 in varchar2 default hr_api.g_varchar2
260: ,p_attribute13 in varchar2 default hr_api.g_varchar2
261: ,p_attribute14 in varchar2 default hr_api.g_varchar2
262: ,p_attribute15 in varchar2 default hr_api.g_varchar2
263: ,p_attribute16 in varchar2 default hr_api.g_varchar2
264: ,p_attribute17 in varchar2 default hr_api.g_varchar2
257: ,p_attribute10 in varchar2 default hr_api.g_varchar2
258: ,p_attribute11 in varchar2 default hr_api.g_varchar2
259: ,p_attribute12 in varchar2 default hr_api.g_varchar2
260: ,p_attribute13 in varchar2 default hr_api.g_varchar2
261: ,p_attribute14 in varchar2 default hr_api.g_varchar2
262: ,p_attribute15 in varchar2 default hr_api.g_varchar2
263: ,p_attribute16 in varchar2 default hr_api.g_varchar2
264: ,p_attribute17 in varchar2 default hr_api.g_varchar2
265: ,p_attribute18 in varchar2 default hr_api.g_varchar2
258: ,p_attribute11 in varchar2 default hr_api.g_varchar2
259: ,p_attribute12 in varchar2 default hr_api.g_varchar2
260: ,p_attribute13 in varchar2 default hr_api.g_varchar2
261: ,p_attribute14 in varchar2 default hr_api.g_varchar2
262: ,p_attribute15 in varchar2 default hr_api.g_varchar2
263: ,p_attribute16 in varchar2 default hr_api.g_varchar2
264: ,p_attribute17 in varchar2 default hr_api.g_varchar2
265: ,p_attribute18 in varchar2 default hr_api.g_varchar2
266: ,p_attribute19 in varchar2 default hr_api.g_varchar2
259: ,p_attribute12 in varchar2 default hr_api.g_varchar2
260: ,p_attribute13 in varchar2 default hr_api.g_varchar2
261: ,p_attribute14 in varchar2 default hr_api.g_varchar2
262: ,p_attribute15 in varchar2 default hr_api.g_varchar2
263: ,p_attribute16 in varchar2 default hr_api.g_varchar2
264: ,p_attribute17 in varchar2 default hr_api.g_varchar2
265: ,p_attribute18 in varchar2 default hr_api.g_varchar2
266: ,p_attribute19 in varchar2 default hr_api.g_varchar2
267: ,p_attribute20 in varchar2 default hr_api.g_varchar2
260: ,p_attribute13 in varchar2 default hr_api.g_varchar2
261: ,p_attribute14 in varchar2 default hr_api.g_varchar2
262: ,p_attribute15 in varchar2 default hr_api.g_varchar2
263: ,p_attribute16 in varchar2 default hr_api.g_varchar2
264: ,p_attribute17 in varchar2 default hr_api.g_varchar2
265: ,p_attribute18 in varchar2 default hr_api.g_varchar2
266: ,p_attribute19 in varchar2 default hr_api.g_varchar2
267: ,p_attribute20 in varchar2 default hr_api.g_varchar2
268: ,p_announcement_id in number
261: ,p_attribute14 in varchar2 default hr_api.g_varchar2
262: ,p_attribute15 in varchar2 default hr_api.g_varchar2
263: ,p_attribute16 in varchar2 default hr_api.g_varchar2
264: ,p_attribute17 in varchar2 default hr_api.g_varchar2
265: ,p_attribute18 in varchar2 default hr_api.g_varchar2
266: ,p_attribute19 in varchar2 default hr_api.g_varchar2
267: ,p_attribute20 in varchar2 default hr_api.g_varchar2
268: ,p_announcement_id in number
269: ,p_object_version_number in out nocopy number
262: ,p_attribute15 in varchar2 default hr_api.g_varchar2
263: ,p_attribute16 in varchar2 default hr_api.g_varchar2
264: ,p_attribute17 in varchar2 default hr_api.g_varchar2
265: ,p_attribute18 in varchar2 default hr_api.g_varchar2
266: ,p_attribute19 in varchar2 default hr_api.g_varchar2
267: ,p_attribute20 in varchar2 default hr_api.g_varchar2
268: ,p_announcement_id in number
269: ,p_object_version_number in out nocopy number
270: ) is
263: ,p_attribute16 in varchar2 default hr_api.g_varchar2
264: ,p_attribute17 in varchar2 default hr_api.g_varchar2
265: ,p_attribute18 in varchar2 default hr_api.g_varchar2
266: ,p_attribute19 in varchar2 default hr_api.g_varchar2
267: ,p_attribute20 in varchar2 default hr_api.g_varchar2
268: ,p_announcement_id in number
269: ,p_object_version_number in out nocopy number
270: ) is
271: --
322: ,p_announcement_id => p_announcement_id
323: ,p_object_version_number => p_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'UPDATE_ANNOUNCEMENT'
329: ,p_hook_type => 'BP'
330: );
323: ,p_object_version_number => p_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'UPDATE_ANNOUNCEMENT'
329: ,p_hook_type => 'BP'
330: );
331: end;
407: ,p_announcement_id => p_announcement_id
408: ,p_object_version_number => p_object_version_number
409: );
410: exception
411: when hr_api.cannot_find_prog_unit then
412: hr_api.cannot_find_prog_unit_error
413: (p_module_name => 'UPDATE_ANNOUNCEMENT'
414: ,p_hook_type => 'AP'
415: );
408: ,p_object_version_number => p_object_version_number
409: );
410: exception
411: when hr_api.cannot_find_prog_unit then
412: hr_api.cannot_find_prog_unit_error
413: (p_module_name => 'UPDATE_ANNOUNCEMENT'
414: ,p_hook_type => 'AP'
415: );
416: end;
418: --
419: -- When in validation only mode raise the Validate_Enabled exception
420: --
421: if p_validate then
422: raise hr_api.validate_enabled;
423: end if;
424: --
425: -- Set all output arguments
426: --
425: -- Set all output arguments
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 70);
428: exception
429: when hr_api.validate_enabled then
430: --
431: -- As the Validate_Enabled exception has been raised
432: -- we must rollback to the savepoint
433: --
483: (p_announcement_id => p_announcement_id
484: ,p_object_version_number => p_object_version_number
485: );
486: exception
487: when hr_api.cannot_find_prog_unit then
488: hr_api.cannot_find_prog_unit_error
489: (p_module_name => 'DELETE_ANNOUNCEMENT'
490: ,p_hook_type => 'BP'
491: );
484: ,p_object_version_number => p_object_version_number
485: );
486: exception
487: when hr_api.cannot_find_prog_unit then
488: hr_api.cannot_find_prog_unit_error
489: (p_module_name => 'DELETE_ANNOUNCEMENT'
490: ,p_hook_type => 'BP'
491: );
492: end;
515: (p_announcement_id => p_announcement_id
516: ,p_object_version_number => p_object_version_number
517: );
518: exception
519: when hr_api.cannot_find_prog_unit then
520: hr_api.cannot_find_prog_unit_error
521: (p_module_name => 'DELETE_ANNOUNCEMENT'
522: ,p_hook_type => 'AP'
523: );
516: ,p_object_version_number => p_object_version_number
517: );
518: exception
519: when hr_api.cannot_find_prog_unit then
520: hr_api.cannot_find_prog_unit_error
521: (p_module_name => 'DELETE_ANNOUNCEMENT'
522: ,p_hook_type => 'AP'
523: );
524: end;
526: --
527: -- When in validation only mode raise the Validate_Enabled exception
528: --
529: if p_validate then
530: raise hr_api.validate_enabled;
531: end if;
532: --
533: -- Set all output arguments
534: --
534: --
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 170);
537: exception
538: when hr_api.validate_enabled then
539: --
540: -- As the Validate_Enabled exception has been raised
541: -- we must rollback to the savepoint
542: --