APPS.PER_ASN_UPD dependencies on HR_API

Line 99: When hr_api.check_integrity_violated Then

95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_asn_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then

Line 102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_asn_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_asn_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 103: When hr_api.parent_integrity_violated Then

99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_asn_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_asn_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then

Line 106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_asn_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_asn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 107: When hr_api.unique_integrity_violated Then

103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_asn_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_asn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then

Line 110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_asn_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: Raise;
113: End update_dml;
114: --

Line 277: when hr_api.cannot_find_prog_unit then

273: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
274: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
275:
276: exception
277: when hr_api.cannot_find_prog_unit then
278: hr_api.cannot_find_prog_unit_error
279: ( p_module_name => 'PER_ASSESSMENTS'
280: ,p_hook_type => 'AU'
281: );

Line 278: hr_api.cannot_find_prog_unit_error

274: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
275:
276: exception
277: when hr_api.cannot_find_prog_unit then
278: hr_api.cannot_find_prog_unit_error
279: ( p_module_name => 'PER_ASSESSMENTS'
280: ,p_hook_type => 'AU'
281: );
282: end;

Line 345: If (p_rec.assessment_type_id = hr_api.g_number) then

341: -- p_rec plsql record structure
342: -- to see if a system default is being used. If a system default
343: -- is being used then we must set to the 'current' argument value.
344: --
345: If (p_rec.assessment_type_id = hr_api.g_number) then
346: p_rec.assessment_type_id :=
347: per_asn_shd.g_old_rec.assessment_type_id;
348: End If;
349:

Line 350: If (p_rec.business_group_id = hr_api.g_number) then

346: p_rec.assessment_type_id :=
347: per_asn_shd.g_old_rec.assessment_type_id;
348: End If;
349:
350: If (p_rec.business_group_id = hr_api.g_number) then
351: p_rec.business_group_id :=
352: per_asn_shd.g_old_rec.business_group_id;
353: End If;
354: If (p_rec.person_id = hr_api.g_number) then

Line 354: If (p_rec.person_id = hr_api.g_number) then

350: If (p_rec.business_group_id = hr_api.g_number) then
351: p_rec.business_group_id :=
352: per_asn_shd.g_old_rec.business_group_id;
353: End If;
354: If (p_rec.person_id = hr_api.g_number) then
355: p_rec.person_id :=
356: per_asn_shd.g_old_rec.person_id;
357: End If;
358: If (p_rec.assessment_group_id = hr_api.g_number) then

Line 358: If (p_rec.assessment_group_id = hr_api.g_number) then

354: If (p_rec.person_id = hr_api.g_number) then
355: p_rec.person_id :=
356: per_asn_shd.g_old_rec.person_id;
357: End If;
358: If (p_rec.assessment_group_id = hr_api.g_number) then
359: p_rec.assessment_group_id :=
360: per_asn_shd.g_old_rec.assessment_group_id;
361: End If;
362: If (p_rec.assessment_period_start_date = hr_api.g_date) then

Line 362: If (p_rec.assessment_period_start_date = hr_api.g_date) then

358: If (p_rec.assessment_group_id = hr_api.g_number) then
359: p_rec.assessment_group_id :=
360: per_asn_shd.g_old_rec.assessment_group_id;
361: End If;
362: If (p_rec.assessment_period_start_date = hr_api.g_date) then
363: p_rec.assessment_period_start_date :=
364: per_asn_shd.g_old_rec.assessment_period_start_date;
365: End If;
366: If (p_rec.assessment_period_end_date = hr_api.g_date) then

Line 366: If (p_rec.assessment_period_end_date = hr_api.g_date) then

362: If (p_rec.assessment_period_start_date = hr_api.g_date) then
363: p_rec.assessment_period_start_date :=
364: per_asn_shd.g_old_rec.assessment_period_start_date;
365: End If;
366: If (p_rec.assessment_period_end_date = hr_api.g_date) then
367: p_rec.assessment_period_end_date :=
368: per_asn_shd.g_old_rec.assessment_period_end_date;
369: End If;
370: If (p_rec.assessment_date = hr_api.g_date) then

Line 370: If (p_rec.assessment_date = hr_api.g_date) then

366: If (p_rec.assessment_period_end_date = hr_api.g_date) then
367: p_rec.assessment_period_end_date :=
368: per_asn_shd.g_old_rec.assessment_period_end_date;
369: End If;
370: If (p_rec.assessment_date = hr_api.g_date) then
371: p_rec.assessment_date :=
372: per_asn_shd.g_old_rec.assessment_date;
373: End If;
374: If (p_rec.assessor_person_id = hr_api.g_number) then

Line 374: If (p_rec.assessor_person_id = hr_api.g_number) then

370: If (p_rec.assessment_date = hr_api.g_date) then
371: p_rec.assessment_date :=
372: per_asn_shd.g_old_rec.assessment_date;
373: End If;
374: If (p_rec.assessor_person_id = hr_api.g_number) then
375: p_rec.assessor_person_id :=
376: per_asn_shd.g_old_rec.assessor_person_id;
377: End If;
378: If (p_rec.comments = hr_api.g_varchar2) then

Line 378: If (p_rec.comments = hr_api.g_varchar2) then

374: If (p_rec.assessor_person_id = hr_api.g_number) then
375: p_rec.assessor_person_id :=
376: per_asn_shd.g_old_rec.assessor_person_id;
377: End If;
378: If (p_rec.comments = hr_api.g_varchar2) then
379: p_rec.comments :=
380: per_asn_shd.g_old_rec.comments;
381: End If;
382: If (p_rec.total_score = hr_api.g_number) then

Line 382: If (p_rec.total_score = hr_api.g_number) then

378: If (p_rec.comments = hr_api.g_varchar2) then
379: p_rec.comments :=
380: per_asn_shd.g_old_rec.comments;
381: End If;
382: If (p_rec.total_score = hr_api.g_number) then
383: p_rec.total_score :=
384: per_asn_shd.g_old_rec.total_score;
385: End If;
386: If (p_rec.status = hr_api.g_varchar2) then

Line 386: If (p_rec.status = hr_api.g_varchar2) then

382: If (p_rec.total_score = hr_api.g_number) then
383: p_rec.total_score :=
384: per_asn_shd.g_old_rec.total_score;
385: End If;
386: If (p_rec.status = hr_api.g_varchar2) then
387: p_rec.status :=
388: per_asn_shd.g_old_rec.status;
389: End If;
390: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 390: If (p_rec.attribute_category = hr_api.g_varchar2) then

386: If (p_rec.status = hr_api.g_varchar2) then
387: p_rec.status :=
388: per_asn_shd.g_old_rec.status;
389: End If;
390: If (p_rec.attribute_category = hr_api.g_varchar2) then
391: p_rec.attribute_category :=
392: per_asn_shd.g_old_rec.attribute_category;
393: End If;
394: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 394: If (p_rec.attribute1 = hr_api.g_varchar2) then

390: If (p_rec.attribute_category = hr_api.g_varchar2) then
391: p_rec.attribute_category :=
392: per_asn_shd.g_old_rec.attribute_category;
393: End If;
394: If (p_rec.attribute1 = hr_api.g_varchar2) then
395: p_rec.attribute1 :=
396: per_asn_shd.g_old_rec.attribute1;
397: End If;
398: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 398: If (p_rec.attribute2 = hr_api.g_varchar2) then

394: If (p_rec.attribute1 = hr_api.g_varchar2) then
395: p_rec.attribute1 :=
396: per_asn_shd.g_old_rec.attribute1;
397: End If;
398: If (p_rec.attribute2 = hr_api.g_varchar2) then
399: p_rec.attribute2 :=
400: per_asn_shd.g_old_rec.attribute2;
401: End If;
402: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 402: If (p_rec.attribute3 = hr_api.g_varchar2) then

398: If (p_rec.attribute2 = hr_api.g_varchar2) then
399: p_rec.attribute2 :=
400: per_asn_shd.g_old_rec.attribute2;
401: End If;
402: If (p_rec.attribute3 = hr_api.g_varchar2) then
403: p_rec.attribute3 :=
404: per_asn_shd.g_old_rec.attribute3;
405: End If;
406: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 406: If (p_rec.attribute4 = hr_api.g_varchar2) then

402: If (p_rec.attribute3 = hr_api.g_varchar2) then
403: p_rec.attribute3 :=
404: per_asn_shd.g_old_rec.attribute3;
405: End If;
406: If (p_rec.attribute4 = hr_api.g_varchar2) then
407: p_rec.attribute4 :=
408: per_asn_shd.g_old_rec.attribute4;
409: End If;
410: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 410: If (p_rec.attribute5 = hr_api.g_varchar2) then

406: If (p_rec.attribute4 = hr_api.g_varchar2) then
407: p_rec.attribute4 :=
408: per_asn_shd.g_old_rec.attribute4;
409: End If;
410: If (p_rec.attribute5 = hr_api.g_varchar2) then
411: p_rec.attribute5 :=
412: per_asn_shd.g_old_rec.attribute5;
413: End If;
414: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 414: If (p_rec.attribute6 = hr_api.g_varchar2) then

410: If (p_rec.attribute5 = hr_api.g_varchar2) then
411: p_rec.attribute5 :=
412: per_asn_shd.g_old_rec.attribute5;
413: End If;
414: If (p_rec.attribute6 = hr_api.g_varchar2) then
415: p_rec.attribute6 :=
416: per_asn_shd.g_old_rec.attribute6;
417: End If;
418: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 418: If (p_rec.attribute7 = hr_api.g_varchar2) then

414: If (p_rec.attribute6 = hr_api.g_varchar2) then
415: p_rec.attribute6 :=
416: per_asn_shd.g_old_rec.attribute6;
417: End If;
418: If (p_rec.attribute7 = hr_api.g_varchar2) then
419: p_rec.attribute7 :=
420: per_asn_shd.g_old_rec.attribute7;
421: End If;
422: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 422: If (p_rec.attribute8 = hr_api.g_varchar2) then

418: If (p_rec.attribute7 = hr_api.g_varchar2) then
419: p_rec.attribute7 :=
420: per_asn_shd.g_old_rec.attribute7;
421: End If;
422: If (p_rec.attribute8 = hr_api.g_varchar2) then
423: p_rec.attribute8 :=
424: per_asn_shd.g_old_rec.attribute8;
425: End If;
426: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 426: If (p_rec.attribute9 = hr_api.g_varchar2) then

422: If (p_rec.attribute8 = hr_api.g_varchar2) then
423: p_rec.attribute8 :=
424: per_asn_shd.g_old_rec.attribute8;
425: End If;
426: If (p_rec.attribute9 = hr_api.g_varchar2) then
427: p_rec.attribute9 :=
428: per_asn_shd.g_old_rec.attribute9;
429: End If;
430: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 430: If (p_rec.attribute10 = hr_api.g_varchar2) then

426: If (p_rec.attribute9 = hr_api.g_varchar2) then
427: p_rec.attribute9 :=
428: per_asn_shd.g_old_rec.attribute9;
429: End If;
430: If (p_rec.attribute10 = hr_api.g_varchar2) then
431: p_rec.attribute10 :=
432: per_asn_shd.g_old_rec.attribute10;
433: End If;
434: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 434: If (p_rec.attribute11 = hr_api.g_varchar2) then

430: If (p_rec.attribute10 = hr_api.g_varchar2) then
431: p_rec.attribute10 :=
432: per_asn_shd.g_old_rec.attribute10;
433: End If;
434: If (p_rec.attribute11 = hr_api.g_varchar2) then
435: p_rec.attribute11 :=
436: per_asn_shd.g_old_rec.attribute11;
437: End If;
438: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 438: If (p_rec.attribute12 = hr_api.g_varchar2) then

434: If (p_rec.attribute11 = hr_api.g_varchar2) then
435: p_rec.attribute11 :=
436: per_asn_shd.g_old_rec.attribute11;
437: End If;
438: If (p_rec.attribute12 = hr_api.g_varchar2) then
439: p_rec.attribute12 :=
440: per_asn_shd.g_old_rec.attribute12;
441: End If;
442: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 442: If (p_rec.attribute13 = hr_api.g_varchar2) then

438: If (p_rec.attribute12 = hr_api.g_varchar2) then
439: p_rec.attribute12 :=
440: per_asn_shd.g_old_rec.attribute12;
441: End If;
442: If (p_rec.attribute13 = hr_api.g_varchar2) then
443: p_rec.attribute13 :=
444: per_asn_shd.g_old_rec.attribute13;
445: End If;
446: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 446: If (p_rec.attribute14 = hr_api.g_varchar2) then

442: If (p_rec.attribute13 = hr_api.g_varchar2) then
443: p_rec.attribute13 :=
444: per_asn_shd.g_old_rec.attribute13;
445: End If;
446: If (p_rec.attribute14 = hr_api.g_varchar2) then
447: p_rec.attribute14 :=
448: per_asn_shd.g_old_rec.attribute14;
449: End If;
450: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 450: If (p_rec.attribute15 = hr_api.g_varchar2) then

446: If (p_rec.attribute14 = hr_api.g_varchar2) then
447: p_rec.attribute14 :=
448: per_asn_shd.g_old_rec.attribute14;
449: End If;
450: If (p_rec.attribute15 = hr_api.g_varchar2) then
451: p_rec.attribute15 :=
452: per_asn_shd.g_old_rec.attribute15;
453: End If;
454: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 454: If (p_rec.attribute16 = hr_api.g_varchar2) then

450: If (p_rec.attribute15 = hr_api.g_varchar2) then
451: p_rec.attribute15 :=
452: per_asn_shd.g_old_rec.attribute15;
453: End If;
454: If (p_rec.attribute16 = hr_api.g_varchar2) then
455: p_rec.attribute16 :=
456: per_asn_shd.g_old_rec.attribute16;
457: End If;
458: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 458: If (p_rec.attribute17 = hr_api.g_varchar2) then

454: If (p_rec.attribute16 = hr_api.g_varchar2) then
455: p_rec.attribute16 :=
456: per_asn_shd.g_old_rec.attribute16;
457: End If;
458: If (p_rec.attribute17 = hr_api.g_varchar2) then
459: p_rec.attribute17 :=
460: per_asn_shd.g_old_rec.attribute17;
461: End If;
462: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 462: If (p_rec.attribute18 = hr_api.g_varchar2) then

458: If (p_rec.attribute17 = hr_api.g_varchar2) then
459: p_rec.attribute17 :=
460: per_asn_shd.g_old_rec.attribute17;
461: End If;
462: If (p_rec.attribute18 = hr_api.g_varchar2) then
463: p_rec.attribute18 :=
464: per_asn_shd.g_old_rec.attribute18;
465: End If;
466: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 466: If (p_rec.attribute19 = hr_api.g_varchar2) then

462: If (p_rec.attribute18 = hr_api.g_varchar2) then
463: p_rec.attribute18 :=
464: per_asn_shd.g_old_rec.attribute18;
465: End If;
466: If (p_rec.attribute19 = hr_api.g_varchar2) then
467: p_rec.attribute19 :=
468: per_asn_shd.g_old_rec.attribute19;
469: End If;
470: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 470: If (p_rec.attribute20 = hr_api.g_varchar2) then

466: If (p_rec.attribute19 = hr_api.g_varchar2) then
467: p_rec.attribute19 :=
468: per_asn_shd.g_old_rec.attribute19;
469: End If;
470: If (p_rec.attribute20 = hr_api.g_varchar2) then
471: p_rec.attribute20 :=
472: per_asn_shd.g_old_rec.attribute20;
473: End If;
474:

Line 543: Raise HR_Api.Validate_Enabled;

539: --
540: -- If we are validating then raise the Validate_Enabled exception
541: --
542: If p_validate then
543: Raise HR_Api.Validate_Enabled;
544: End If;
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: Exception

Line 548: When HR_Api.Validate_Enabled Then

544: End If;
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: Exception
548: When HR_Api.Validate_Enabled Then
549: --
550: -- As the Validate_Enabled exception has been raised
551: -- we must rollback to the savepoint
552: --

Line 562: p_assessment_type_id in number default hr_api.g_number,

558: -- ----------------------------------------------------------------------------
559: Procedure upd
560: (
561: p_assessment_id in number,
562: p_assessment_type_id in number default hr_api.g_number,
563: p_assessment_group_id in number default hr_api.g_number,
564: p_assessment_period_start_date in date default hr_api.g_date,
565: p_assessment_period_end_date in date default hr_api.g_date,
566: p_assessment_date in date default hr_api.g_date,

Line 563: p_assessment_group_id in number default hr_api.g_number,

559: Procedure upd
560: (
561: p_assessment_id in number,
562: p_assessment_type_id in number default hr_api.g_number,
563: p_assessment_group_id in number default hr_api.g_number,
564: p_assessment_period_start_date in date default hr_api.g_date,
565: p_assessment_period_end_date in date default hr_api.g_date,
566: p_assessment_date in date default hr_api.g_date,
567: p_comments in varchar2 default hr_api.g_varchar2,

Line 564: p_assessment_period_start_date in date default hr_api.g_date,

560: (
561: p_assessment_id in number,
562: p_assessment_type_id in number default hr_api.g_number,
563: p_assessment_group_id in number default hr_api.g_number,
564: p_assessment_period_start_date in date default hr_api.g_date,
565: p_assessment_period_end_date in date default hr_api.g_date,
566: p_assessment_date in date default hr_api.g_date,
567: p_comments in varchar2 default hr_api.g_varchar2,
568: p_total_score in number default hr_api.g_number,

Line 565: p_assessment_period_end_date in date default hr_api.g_date,

561: p_assessment_id in number,
562: p_assessment_type_id in number default hr_api.g_number,
563: p_assessment_group_id in number default hr_api.g_number,
564: p_assessment_period_start_date in date default hr_api.g_date,
565: p_assessment_period_end_date in date default hr_api.g_date,
566: p_assessment_date in date default hr_api.g_date,
567: p_comments in varchar2 default hr_api.g_varchar2,
568: p_total_score in number default hr_api.g_number,
569: p_status in varchar2 default hr_api.g_varchar2,

Line 566: p_assessment_date in date default hr_api.g_date,

562: p_assessment_type_id in number default hr_api.g_number,
563: p_assessment_group_id in number default hr_api.g_number,
564: p_assessment_period_start_date in date default hr_api.g_date,
565: p_assessment_period_end_date in date default hr_api.g_date,
566: p_assessment_date in date default hr_api.g_date,
567: p_comments in varchar2 default hr_api.g_varchar2,
568: p_total_score in number default hr_api.g_number,
569: p_status in varchar2 default hr_api.g_varchar2,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 567: p_comments in varchar2 default hr_api.g_varchar2,

563: p_assessment_group_id in number default hr_api.g_number,
564: p_assessment_period_start_date in date default hr_api.g_date,
565: p_assessment_period_end_date in date default hr_api.g_date,
566: p_assessment_date in date default hr_api.g_date,
567: p_comments in varchar2 default hr_api.g_varchar2,
568: p_total_score in number default hr_api.g_number,
569: p_status in varchar2 default hr_api.g_varchar2,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 568: p_total_score in number default hr_api.g_number,

564: p_assessment_period_start_date in date default hr_api.g_date,
565: p_assessment_period_end_date in date default hr_api.g_date,
566: p_assessment_date in date default hr_api.g_date,
567: p_comments in varchar2 default hr_api.g_varchar2,
568: p_total_score in number default hr_api.g_number,
569: p_status in varchar2 default hr_api.g_varchar2,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 569: p_status in varchar2 default hr_api.g_varchar2,

565: p_assessment_period_end_date in date default hr_api.g_date,
566: p_assessment_date in date default hr_api.g_date,
567: p_comments in varchar2 default hr_api.g_varchar2,
568: p_total_score in number default hr_api.g_number,
569: p_status in varchar2 default hr_api.g_varchar2,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 570: p_attribute_category in varchar2 default hr_api.g_varchar2,

566: p_assessment_date in date default hr_api.g_date,
567: p_comments in varchar2 default hr_api.g_varchar2,
568: p_total_score in number default hr_api.g_number,
569: p_status in varchar2 default hr_api.g_varchar2,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 571: p_attribute1 in varchar2 default hr_api.g_varchar2,

567: p_comments in varchar2 default hr_api.g_varchar2,
568: p_total_score in number default hr_api.g_number,
569: p_status in varchar2 default hr_api.g_varchar2,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 572: p_attribute2 in varchar2 default hr_api.g_varchar2,

568: p_total_score in number default hr_api.g_number,
569: p_status in varchar2 default hr_api.g_varchar2,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 573: p_attribute3 in varchar2 default hr_api.g_varchar2,

569: p_status in varchar2 default hr_api.g_varchar2,
570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 574: p_attribute4 in varchar2 default hr_api.g_varchar2,

570: p_attribute_category in varchar2 default hr_api.g_varchar2,
571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 575: p_attribute5 in varchar2 default hr_api.g_varchar2,

571: p_attribute1 in varchar2 default hr_api.g_varchar2,
572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 576: p_attribute6 in varchar2 default hr_api.g_varchar2,

572: p_attribute2 in varchar2 default hr_api.g_varchar2,
573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 577: p_attribute7 in varchar2 default hr_api.g_varchar2,

573: p_attribute3 in varchar2 default hr_api.g_varchar2,
574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 578: p_attribute8 in varchar2 default hr_api.g_varchar2,

574: p_attribute4 in varchar2 default hr_api.g_varchar2,
575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 579: p_attribute9 in varchar2 default hr_api.g_varchar2,

575: p_attribute5 in varchar2 default hr_api.g_varchar2,
576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 580: p_attribute10 in varchar2 default hr_api.g_varchar2,

576: p_attribute6 in varchar2 default hr_api.g_varchar2,
577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 581: p_attribute11 in varchar2 default hr_api.g_varchar2,

577: p_attribute7 in varchar2 default hr_api.g_varchar2,
578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 582: p_attribute12 in varchar2 default hr_api.g_varchar2,

578: p_attribute8 in varchar2 default hr_api.g_varchar2,
579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 583: p_attribute13 in varchar2 default hr_api.g_varchar2,

579: p_attribute9 in varchar2 default hr_api.g_varchar2,
580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 584: p_attribute14 in varchar2 default hr_api.g_varchar2,

580: p_attribute10 in varchar2 default hr_api.g_varchar2,
581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 585: p_attribute15 in varchar2 default hr_api.g_varchar2,

581: p_attribute11 in varchar2 default hr_api.g_varchar2,
582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 586: p_attribute16 in varchar2 default hr_api.g_varchar2,

582: p_attribute12 in varchar2 default hr_api.g_varchar2,
583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 587: p_attribute17 in varchar2 default hr_api.g_varchar2,

583: p_attribute13 in varchar2 default hr_api.g_varchar2,
584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_object_version_number in out nocopy number,

Line 588: p_attribute18 in varchar2 default hr_api.g_varchar2,

584: p_attribute14 in varchar2 default hr_api.g_varchar2,
585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_object_version_number in out nocopy number,
592: p_validate in boolean default false,

Line 589: p_attribute19 in varchar2 default hr_api.g_varchar2,

585: p_attribute15 in varchar2 default hr_api.g_varchar2,
586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_object_version_number in out nocopy number,
592: p_validate in boolean default false,
593: p_effective_date in date

Line 590: p_attribute20 in varchar2 default hr_api.g_varchar2,

586: p_attribute16 in varchar2 default hr_api.g_varchar2,
587: p_attribute17 in varchar2 default hr_api.g_varchar2,
588: p_attribute18 in varchar2 default hr_api.g_varchar2,
589: p_attribute19 in varchar2 default hr_api.g_varchar2,
590: p_attribute20 in varchar2 default hr_api.g_varchar2,
591: p_object_version_number in out nocopy number,
592: p_validate in boolean default false,
593: p_effective_date in date
594: ) is

Line 610: hr_api.g_number,

606: per_asn_shd.convert_args
607: (
608: p_assessment_id,
609: p_assessment_type_id,
610: hr_api.g_number,
611: hr_api.g_number,
612: p_assessment_group_id,
613: p_assessment_period_start_date,
614: p_assessment_period_end_date,

Line 611: hr_api.g_number,

607: (
608: p_assessment_id,
609: p_assessment_type_id,
610: hr_api.g_number,
611: hr_api.g_number,
612: p_assessment_group_id,
613: p_assessment_period_start_date,
614: p_assessment_period_end_date,
615: p_assessment_date,

Line 616: hr_api.g_number,

612: p_assessment_group_id,
613: p_assessment_period_start_date,
614: p_assessment_period_end_date,
615: p_assessment_date,
616: hr_api.g_number,
617: hr_api.g_number,
618: hr_api.g_date,
619: hr_api.g_number,
620: p_comments,

Line 617: hr_api.g_number,

613: p_assessment_period_start_date,
614: p_assessment_period_end_date,
615: p_assessment_date,
616: hr_api.g_number,
617: hr_api.g_number,
618: hr_api.g_date,
619: hr_api.g_number,
620: p_comments,
621: p_total_score,

Line 618: hr_api.g_date,

614: p_assessment_period_end_date,
615: p_assessment_date,
616: hr_api.g_number,
617: hr_api.g_number,
618: hr_api.g_date,
619: hr_api.g_number,
620: p_comments,
621: p_total_score,
622: p_status,

Line 619: hr_api.g_number,

615: p_assessment_date,
616: hr_api.g_number,
617: hr_api.g_number,
618: hr_api.g_date,
619: hr_api.g_number,
620: p_comments,
621: p_total_score,
622: p_status,
623: p_attribute_category,