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