APPS.HR_ASSESSMENTS_API dependencies on HR_API

Line 111: when hr_api.cannot_find_prog_unit then

107: ,p_attribute19 => p_attribute19
108: ,p_attribute20 => p_attribute20
109: ,p_effective_date => p_effective_date );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'create_assessment',
114: p_hook_type => 'BP'
115: );

Line 112: hr_api.cannot_find_prog_unit_error

108: ,p_attribute20 => p_attribute20
109: ,p_effective_date => p_effective_date );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'create_assessment',
114: p_hook_type => 'BP'
115: );
116: end;

Line 213: when hr_api.cannot_find_prog_unit then

209: ,p_attribute19 => p_attribute19
210: ,p_attribute20 => p_attribute20
211: ,p_effective_date => p_effective_date );
212: exception
213: when hr_api.cannot_find_prog_unit then
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'create_assessment',
216: p_hook_type => 'AP'
217: );

Line 214: hr_api.cannot_find_prog_unit_error

210: ,p_attribute20 => p_attribute20
211: ,p_effective_date => p_effective_date );
212: exception
213: when hr_api.cannot_find_prog_unit then
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'create_assessment',
216: p_hook_type => 'AP'
217: );
218: end;

Line 225: raise hr_api.validate_enabled;

221: --
222: -- When in validation only mode raise the Validate_Enabled exception
223: --
224: if p_validate then
225: raise hr_api.validate_enabled;
226: end if;
227: --
228: -- Set all output arguments
229: --

Line 235: when hr_api.validate_enabled then

231: p_object_version_number := l_object_version_number;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 11);
234: exception
235: when hr_api.validate_enabled then
236: --
237: -- As the Validate_Enabled exception has been raised
238: -- we must rollback to the savepoint
239: --

Line 271: p_assessment_type_id in number default hr_api.g_number,

267: --
268: procedure update_assessment
269: (
270: p_assessment_id in number,
271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,

Line 272: p_assessment_group_id in number default hr_api.g_number,

268: procedure update_assessment
269: (
270: p_assessment_id in number,
271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,

Line 273: p_assessment_period_start_date in date default hr_api.g_date,

269: (
270: p_assessment_id in number,
271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,

Line 274: p_assessment_period_end_date in date default hr_api.g_date,

270: p_assessment_id in number,
271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,

Line 275: p_assessment_date in date default hr_api.g_date,

271: p_assessment_type_id in number default hr_api.g_number,
272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --

Line 276: p_comments in varchar2 default hr_api.g_varchar2,

272: p_assessment_group_id in number default hr_api.g_number,
273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 277: p_total_score in number default hr_api.g_number,

273: p_assessment_period_start_date in date default hr_api.g_date,
274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 278: p_status in varchar2 default hr_api.g_varchar2,

274: p_assessment_period_end_date in date default hr_api.g_date,
275: p_assessment_date in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 280: p_attribute_category in varchar2 default hr_api.g_varchar2,

276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 281: p_attribute1 in varchar2 default hr_api.g_varchar2,

277: p_total_score in number default hr_api.g_number,
278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 282: p_attribute2 in varchar2 default hr_api.g_varchar2,

278: p_status in varchar2 default hr_api.g_varchar2,
279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 283: p_attribute3 in varchar2 default hr_api.g_varchar2,

279: --
280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 284: p_attribute4 in varchar2 default hr_api.g_varchar2,

280: p_attribute_category in varchar2 default hr_api.g_varchar2,
281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 285: p_attribute5 in varchar2 default hr_api.g_varchar2,

281: p_attribute1 in varchar2 default hr_api.g_varchar2,
282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 286: p_attribute6 in varchar2 default hr_api.g_varchar2,

282: p_attribute2 in varchar2 default hr_api.g_varchar2,
283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 287: p_attribute7 in varchar2 default hr_api.g_varchar2,

283: p_attribute3 in varchar2 default hr_api.g_varchar2,
284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 288: p_attribute8 in varchar2 default hr_api.g_varchar2,

284: p_attribute4 in varchar2 default hr_api.g_varchar2,
285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 289: p_attribute9 in varchar2 default hr_api.g_varchar2,

285: p_attribute5 in varchar2 default hr_api.g_varchar2,
286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 290: p_attribute10 in varchar2 default hr_api.g_varchar2,

286: p_attribute6 in varchar2 default hr_api.g_varchar2,
287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 291: p_attribute11 in varchar2 default hr_api.g_varchar2,

287: p_attribute7 in varchar2 default hr_api.g_varchar2,
288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 292: p_attribute12 in varchar2 default hr_api.g_varchar2,

288: p_attribute8 in varchar2 default hr_api.g_varchar2,
289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 293: p_attribute13 in varchar2 default hr_api.g_varchar2,

289: p_attribute9 in varchar2 default hr_api.g_varchar2,
290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 294: p_attribute14 in varchar2 default hr_api.g_varchar2,

290: p_attribute10 in varchar2 default hr_api.g_varchar2,
291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 295: p_attribute15 in varchar2 default hr_api.g_varchar2,

291: p_attribute11 in varchar2 default hr_api.g_varchar2,
292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 296: p_attribute16 in varchar2 default hr_api.g_varchar2,

292: p_attribute12 in varchar2 default hr_api.g_varchar2,
293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 297: p_attribute17 in varchar2 default hr_api.g_varchar2,

293: p_attribute13 in varchar2 default hr_api.g_varchar2,
294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,
301: p_object_version_number in out nocopy number,

Line 298: p_attribute18 in varchar2 default hr_api.g_varchar2,

294: p_attribute14 in varchar2 default hr_api.g_varchar2,
295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,
301: p_object_version_number in out nocopy number,
302: p_validate in boolean default false,

Line 299: p_attribute19 in varchar2 default hr_api.g_varchar2,

295: p_attribute15 in varchar2 default hr_api.g_varchar2,
296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,
301: p_object_version_number in out nocopy number,
302: p_validate in boolean default false,
303: p_effective_date in date

Line 300: p_attribute20 in varchar2 default hr_api.g_varchar2,

296: p_attribute16 in varchar2 default hr_api.g_varchar2,
297: p_attribute17 in varchar2 default hr_api.g_varchar2,
298: p_attribute18 in varchar2 default hr_api.g_varchar2,
299: p_attribute19 in varchar2 default hr_api.g_varchar2,
300: p_attribute20 in varchar2 default hr_api.g_varchar2,
301: p_object_version_number in out nocopy number,
302: p_validate in boolean default false,
303: p_effective_date in date
304: ) is

Line 359: when hr_api.cannot_find_prog_unit then

355: p_object_version_number => p_object_version_number,
356: p_effective_date => p_effective_date
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'update_assessment',
362: p_hook_type => 'BP'
363: );

Line 360: hr_api.cannot_find_prog_unit_error

356: p_effective_date => p_effective_date
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'update_assessment',
362: p_hook_type => 'BP'
363: );
364: end;

Line 454: when hr_api.cannot_find_prog_unit then

450: p_object_version_number => l_object_version_number,
451: p_effective_date => p_effective_date
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'update_assessment',
457: p_hook_type => 'AP'
458: );

Line 455: hr_api.cannot_find_prog_unit_error

451: p_effective_date => p_effective_date
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'update_assessment',
457: p_hook_type => 'AP'
458: );
459: end;

Line 466: raise hr_api.validate_enabled;

462: --
463: -- When in validation only mode raise the Validate_Enabled exception
464: --
465: if p_validate then
466: raise hr_api.validate_enabled;
467: end if;
468: --
469: -- Set all output arguments. l_object_version_number now has the new
470: -- object version number as the update was successful

Line 476: when hr_api.validate_enabled then

472: p_object_version_number := l_object_version_number;
473: --
474: hr_utility.set_location(' Leaving:'||l_proc, 11);
475: exception
476: when hr_api.validate_enabled then
477: --
478: -- As the Validate_Enabled exception has been raised
479: -- we must rollback to the savepoint
480: --

Line 538: when hr_api.cannot_find_prog_unit then

534: p_assessment_id => p_assessment_id
535: ,p_object_version_number => p_object_version_number
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'delete_assessment',
541: p_hook_type => 'BP'
542: );

Line 539: hr_api.cannot_find_prog_unit_error

535: ,p_object_version_number => p_object_version_number
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'delete_assessment',
541: p_hook_type => 'BP'
542: );
543: end;

Line 572: when hr_api.cannot_find_prog_unit then

568: p_assessment_id => p_assessment_id
569: ,p_object_version_number => p_object_version_number
570: );
571: exception
572: when hr_api.cannot_find_prog_unit then
573: hr_api.cannot_find_prog_unit_error
574: (p_module_name => 'delete_assessment',
575: p_hook_type => 'AP'
576: );

Line 573: hr_api.cannot_find_prog_unit_error

569: ,p_object_version_number => p_object_version_number
570: );
571: exception
572: when hr_api.cannot_find_prog_unit then
573: hr_api.cannot_find_prog_unit_error
574: (p_module_name => 'delete_assessment',
575: p_hook_type => 'AP'
576: );
577: end;

Line 584: raise hr_api.validate_enabled;

580: --
581: -- When in validation only mode raise the Validate_Enabled exception
582: --
583: if p_validate then
584: raise hr_api.validate_enabled;
585: end if;
586: --
587: hr_utility.set_location(' Leaving:'||l_proc, 11);
588: exception

Line 589: when hr_api.validate_enabled then

585: end if;
586: --
587: hr_utility.set_location(' Leaving:'||l_proc, 11);
588: exception
589: when hr_api.validate_enabled then
590: --
591: -- As the Validate_Enabled exception has been raised
592: -- we must rollback to the savepoint
593: --