DBA Data[Home] [Help]

APPS.OTA_ANNOUNCEMENT_API dependencies on HR_API

Line 98: when hr_api.cannot_find_prog_unit then

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: );

Line 99: hr_api.cannot_find_prog_unit_error

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;

Line 188: when hr_api.cannot_find_prog_unit then

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: );

Line 189: hr_api.cannot_find_prog_unit_error

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;

Line 199: raise hr_api.validate_enabled;

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: --

Line 210: when hr_api.validate_enabled then

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: --

Line 244: ,p_start_date_active in date default hr_api.g_date

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

Line 245: ,p_end_date_active in date default hr_api.g_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
249: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 246: ,p_owner_id in number default hr_api.g_number

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

Line 247: ,p_attribute_category 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

Line 248: ,p_attribute1 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

Line 249: ,p_attribute2 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

Line 250: ,p_attribute3 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

Line 251: ,p_attribute4 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

Line 252: ,p_attribute5 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

Line 253: ,p_attribute6 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

Line 254: ,p_attribute7 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

Line 255: ,p_attribute8 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

Line 256: ,p_attribute9 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

Line 257: ,p_attribute10 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

Line 258: ,p_attribute11 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

Line 259: ,p_attribute12 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

Line 260: ,p_attribute13 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

Line 261: ,p_attribute14 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

Line 262: ,p_attribute15 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

Line 263: ,p_attribute16 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

Line 264: ,p_attribute17 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

Line 265: ,p_attribute18 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
269: ,p_object_version_number in out nocopy number

Line 266: ,p_attribute19 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
270: ) is

Line 267: ,p_attribute20 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
271: --

Line 326: when hr_api.cannot_find_prog_unit then

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: );

Line 327: hr_api.cannot_find_prog_unit_error

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;

Line 411: when hr_api.cannot_find_prog_unit then

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: );

Line 412: hr_api.cannot_find_prog_unit_error

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;

Line 422: raise hr_api.validate_enabled;

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: --

Line 429: when hr_api.validate_enabled then

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: --

Line 487: when hr_api.cannot_find_prog_unit then

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: );

Line 488: hr_api.cannot_find_prog_unit_error

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;

Line 519: when hr_api.cannot_find_prog_unit then

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: );

Line 520: hr_api.cannot_find_prog_unit_error

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;

Line 530: raise hr_api.validate_enabled;

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: --

Line 538: when hr_api.validate_enabled then

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: --