98:
99: hr_utility.set_location(' Leaving:'||l_proc, 10);
100:
101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: per_prt_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: per_prt_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_prt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: per_prt_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_prt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_prt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_prt_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_prt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_prt_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_prt_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: Raise;
116: End update_dml;
117:
256: p_attribute19_o => per_prt_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
258: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: ( p_module_name => 'PER_PERFORMANCE_RATINGS'
263: ,p_hook_type => 'AU'
264: );
257: p_attribute20_o => per_prt_shd.g_old_rec.attribute20 ,
258: p_appr_line_score_o => per_prt_shd.g_old_rec.appr_line_score);
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: ( p_module_name => 'PER_PERFORMANCE_RATINGS'
263: ,p_hook_type => 'AU'
264: );
265: end;
323: -- p_rec plsql record structure
324: -- to see if a system default is being used. If a system default
325: -- is being used then we must set to the 'current' argument value.
326:
327: If (p_rec.objective_id = hr_api.g_number) then
328: p_rec.objective_id :=
329: per_prt_shd.g_old_rec.objective_id;
330: End If;
331: If (p_rec.appraisal_id = hr_api.g_number) then
327: If (p_rec.objective_id = hr_api.g_number) then
328: p_rec.objective_id :=
329: per_prt_shd.g_old_rec.objective_id;
330: End If;
331: If (p_rec.appraisal_id = hr_api.g_number) then
332: p_rec.appraisal_id :=
333: per_prt_shd.g_old_rec.appraisal_id;
334: End If;
335: If (p_rec.performance_level_id = hr_api.g_number) then
331: If (p_rec.appraisal_id = hr_api.g_number) then
332: p_rec.appraisal_id :=
333: per_prt_shd.g_old_rec.appraisal_id;
334: End If;
335: If (p_rec.performance_level_id = hr_api.g_number) then
336: p_rec.performance_level_id :=
337: per_prt_shd.g_old_rec.performance_level_id;
338: End If;
339: If (p_rec.comments = hr_api.g_varchar2) then
335: If (p_rec.performance_level_id = hr_api.g_number) then
336: p_rec.performance_level_id :=
337: per_prt_shd.g_old_rec.performance_level_id;
338: End If;
339: If (p_rec.comments = hr_api.g_varchar2) then
340: p_rec.comments :=
341: per_prt_shd.g_old_rec.comments;
342: End If;
343: If (p_rec.attribute_category = hr_api.g_varchar2) then
339: If (p_rec.comments = hr_api.g_varchar2) then
340: p_rec.comments :=
341: per_prt_shd.g_old_rec.comments;
342: End If;
343: If (p_rec.attribute_category = hr_api.g_varchar2) then
344: p_rec.attribute_category :=
345: per_prt_shd.g_old_rec.attribute_category;
346: End If;
347: If (p_rec.attribute1 = hr_api.g_varchar2) then
343: If (p_rec.attribute_category = hr_api.g_varchar2) then
344: p_rec.attribute_category :=
345: per_prt_shd.g_old_rec.attribute_category;
346: End If;
347: If (p_rec.attribute1 = hr_api.g_varchar2) then
348: p_rec.attribute1 :=
349: per_prt_shd.g_old_rec.attribute1;
350: End If;
351: If (p_rec.attribute2 = hr_api.g_varchar2) then
347: If (p_rec.attribute1 = hr_api.g_varchar2) then
348: p_rec.attribute1 :=
349: per_prt_shd.g_old_rec.attribute1;
350: End If;
351: If (p_rec.attribute2 = hr_api.g_varchar2) then
352: p_rec.attribute2 :=
353: per_prt_shd.g_old_rec.attribute2;
354: End If;
355: If (p_rec.attribute3 = hr_api.g_varchar2) then
351: If (p_rec.attribute2 = hr_api.g_varchar2) then
352: p_rec.attribute2 :=
353: per_prt_shd.g_old_rec.attribute2;
354: End If;
355: If (p_rec.attribute3 = hr_api.g_varchar2) then
356: p_rec.attribute3 :=
357: per_prt_shd.g_old_rec.attribute3;
358: End If;
359: If (p_rec.attribute4 = hr_api.g_varchar2) then
355: If (p_rec.attribute3 = hr_api.g_varchar2) then
356: p_rec.attribute3 :=
357: per_prt_shd.g_old_rec.attribute3;
358: End If;
359: If (p_rec.attribute4 = hr_api.g_varchar2) then
360: p_rec.attribute4 :=
361: per_prt_shd.g_old_rec.attribute4;
362: End If;
363: If (p_rec.attribute5 = hr_api.g_varchar2) then
359: If (p_rec.attribute4 = hr_api.g_varchar2) then
360: p_rec.attribute4 :=
361: per_prt_shd.g_old_rec.attribute4;
362: End If;
363: If (p_rec.attribute5 = hr_api.g_varchar2) then
364: p_rec.attribute5 :=
365: per_prt_shd.g_old_rec.attribute5;
366: End If;
367: If (p_rec.attribute6 = hr_api.g_varchar2) then
363: If (p_rec.attribute5 = hr_api.g_varchar2) then
364: p_rec.attribute5 :=
365: per_prt_shd.g_old_rec.attribute5;
366: End If;
367: If (p_rec.attribute6 = hr_api.g_varchar2) then
368: p_rec.attribute6 :=
369: per_prt_shd.g_old_rec.attribute6;
370: End If;
371: If (p_rec.attribute7 = hr_api.g_varchar2) then
367: If (p_rec.attribute6 = hr_api.g_varchar2) then
368: p_rec.attribute6 :=
369: per_prt_shd.g_old_rec.attribute6;
370: End If;
371: If (p_rec.attribute7 = hr_api.g_varchar2) then
372: p_rec.attribute7 :=
373: per_prt_shd.g_old_rec.attribute7;
374: End If;
375: If (p_rec.attribute8 = hr_api.g_varchar2) then
371: If (p_rec.attribute7 = hr_api.g_varchar2) then
372: p_rec.attribute7 :=
373: per_prt_shd.g_old_rec.attribute7;
374: End If;
375: If (p_rec.attribute8 = hr_api.g_varchar2) then
376: p_rec.attribute8 :=
377: per_prt_shd.g_old_rec.attribute8;
378: End If;
379: If (p_rec.attribute9 = hr_api.g_varchar2) then
375: If (p_rec.attribute8 = hr_api.g_varchar2) then
376: p_rec.attribute8 :=
377: per_prt_shd.g_old_rec.attribute8;
378: End If;
379: If (p_rec.attribute9 = hr_api.g_varchar2) then
380: p_rec.attribute9 :=
381: per_prt_shd.g_old_rec.attribute9;
382: End If;
383: If (p_rec.attribute10 = hr_api.g_varchar2) then
379: If (p_rec.attribute9 = hr_api.g_varchar2) then
380: p_rec.attribute9 :=
381: per_prt_shd.g_old_rec.attribute9;
382: End If;
383: If (p_rec.attribute10 = hr_api.g_varchar2) then
384: p_rec.attribute10 :=
385: per_prt_shd.g_old_rec.attribute10;
386: End If;
387: If (p_rec.attribute11 = hr_api.g_varchar2) then
383: If (p_rec.attribute10 = hr_api.g_varchar2) then
384: p_rec.attribute10 :=
385: per_prt_shd.g_old_rec.attribute10;
386: End If;
387: If (p_rec.attribute11 = hr_api.g_varchar2) then
388: p_rec.attribute11 :=
389: per_prt_shd.g_old_rec.attribute11;
390: End If;
391: If (p_rec.attribute12 = hr_api.g_varchar2) then
387: If (p_rec.attribute11 = hr_api.g_varchar2) then
388: p_rec.attribute11 :=
389: per_prt_shd.g_old_rec.attribute11;
390: End If;
391: If (p_rec.attribute12 = hr_api.g_varchar2) then
392: p_rec.attribute12 :=
393: per_prt_shd.g_old_rec.attribute12;
394: End If;
395: If (p_rec.attribute13 = hr_api.g_varchar2) then
391: If (p_rec.attribute12 = hr_api.g_varchar2) then
392: p_rec.attribute12 :=
393: per_prt_shd.g_old_rec.attribute12;
394: End If;
395: If (p_rec.attribute13 = hr_api.g_varchar2) then
396: p_rec.attribute13 :=
397: per_prt_shd.g_old_rec.attribute13;
398: End If;
399: If (p_rec.attribute14 = hr_api.g_varchar2) then
395: If (p_rec.attribute13 = hr_api.g_varchar2) then
396: p_rec.attribute13 :=
397: per_prt_shd.g_old_rec.attribute13;
398: End If;
399: If (p_rec.attribute14 = hr_api.g_varchar2) then
400: p_rec.attribute14 :=
401: per_prt_shd.g_old_rec.attribute14;
402: End If;
403: If (p_rec.attribute15 = hr_api.g_varchar2) then
399: If (p_rec.attribute14 = hr_api.g_varchar2) then
400: p_rec.attribute14 :=
401: per_prt_shd.g_old_rec.attribute14;
402: End If;
403: If (p_rec.attribute15 = hr_api.g_varchar2) then
404: p_rec.attribute15 :=
405: per_prt_shd.g_old_rec.attribute15;
406: End If;
407: If (p_rec.attribute16 = hr_api.g_varchar2) then
403: If (p_rec.attribute15 = hr_api.g_varchar2) then
404: p_rec.attribute15 :=
405: per_prt_shd.g_old_rec.attribute15;
406: End If;
407: If (p_rec.attribute16 = hr_api.g_varchar2) then
408: p_rec.attribute16 :=
409: per_prt_shd.g_old_rec.attribute16;
410: End If;
411: If (p_rec.attribute17 = hr_api.g_varchar2) then
407: If (p_rec.attribute16 = hr_api.g_varchar2) then
408: p_rec.attribute16 :=
409: per_prt_shd.g_old_rec.attribute16;
410: End If;
411: If (p_rec.attribute17 = hr_api.g_varchar2) then
412: p_rec.attribute17 :=
413: per_prt_shd.g_old_rec.attribute17;
414: End If;
415: If (p_rec.attribute18 = hr_api.g_varchar2) then
411: If (p_rec.attribute17 = hr_api.g_varchar2) then
412: p_rec.attribute17 :=
413: per_prt_shd.g_old_rec.attribute17;
414: End If;
415: If (p_rec.attribute18 = hr_api.g_varchar2) then
416: p_rec.attribute18 :=
417: per_prt_shd.g_old_rec.attribute18;
418: End If;
419: If (p_rec.attribute19 = hr_api.g_varchar2) then
415: If (p_rec.attribute18 = hr_api.g_varchar2) then
416: p_rec.attribute18 :=
417: per_prt_shd.g_old_rec.attribute18;
418: End If;
419: If (p_rec.attribute19 = hr_api.g_varchar2) then
420: p_rec.attribute19 :=
421: per_prt_shd.g_old_rec.attribute19;
422: End If;
423: If (p_rec.attribute20 = hr_api.g_varchar2) then
419: If (p_rec.attribute19 = hr_api.g_varchar2) then
420: p_rec.attribute19 :=
421: per_prt_shd.g_old_rec.attribute19;
422: End If;
423: If (p_rec.attribute20 = hr_api.g_varchar2) then
424: p_rec.attribute20 :=
425: per_prt_shd.g_old_rec.attribute20;
426: End If;
427: If (p_rec.person_id = hr_api.g_number) then
423: If (p_rec.attribute20 = hr_api.g_varchar2) then
424: p_rec.attribute20 :=
425: per_prt_shd.g_old_rec.attribute20;
426: End If;
427: If (p_rec.person_id = hr_api.g_number) then
428: p_rec.person_id :=
429: per_prt_shd.g_old_rec.person_id;
430: End If;
431: If (p_rec.appr_line_score = hr_api.g_number) then
427: If (p_rec.person_id = hr_api.g_number) then
428: p_rec.person_id :=
429: per_prt_shd.g_old_rec.person_id;
430: End If;
431: If (p_rec.appr_line_score = hr_api.g_number) then
432: p_rec.appr_line_score :=
433: per_prt_shd.g_old_rec.appr_line_score;
434: End If;
435:
504:
505: -- If we are validating then raise the Validate_Enabled exception
506:
507: If p_validate then
508: Raise HR_Api.Validate_Enabled;
509: End If;
510:
511: hr_utility.set_location(' Leaving:'||l_proc, 10);
512: Exception
509: End If;
510:
511: hr_utility.set_location(' Leaving:'||l_proc, 10);
512: Exception
513: When HR_Api.Validate_Enabled Then
514:
515: -- As the Validate_Enabled exception has been raised
516: -- we must rollback to the savepoint
517:
525: (
526: p_performance_rating_id in number,
527: p_person_id in number,
528: p_object_version_number in out nocopy number,
529: p_performance_level_id in number default hr_api.g_number,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_attribute_category in varchar2 default hr_api.g_varchar2,
532: p_attribute1 in varchar2 default hr_api.g_varchar2,
533: p_attribute2 in varchar2 default hr_api.g_varchar2,
526: p_performance_rating_id in number,
527: p_person_id in number,
528: p_object_version_number in out nocopy number,
529: p_performance_level_id in number default hr_api.g_number,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_attribute_category in varchar2 default hr_api.g_varchar2,
532: p_attribute1 in varchar2 default hr_api.g_varchar2,
533: p_attribute2 in varchar2 default hr_api.g_varchar2,
534: p_attribute3 in varchar2 default hr_api.g_varchar2,
527: p_person_id in number,
528: p_object_version_number in out nocopy number,
529: p_performance_level_id in number default hr_api.g_number,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_attribute_category in varchar2 default hr_api.g_varchar2,
532: p_attribute1 in varchar2 default hr_api.g_varchar2,
533: p_attribute2 in varchar2 default hr_api.g_varchar2,
534: p_attribute3 in varchar2 default hr_api.g_varchar2,
535: p_attribute4 in varchar2 default hr_api.g_varchar2,
528: p_object_version_number in out nocopy number,
529: p_performance_level_id in number default hr_api.g_number,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_attribute_category in varchar2 default hr_api.g_varchar2,
532: p_attribute1 in varchar2 default hr_api.g_varchar2,
533: p_attribute2 in varchar2 default hr_api.g_varchar2,
534: p_attribute3 in varchar2 default hr_api.g_varchar2,
535: p_attribute4 in varchar2 default hr_api.g_varchar2,
536: p_attribute5 in varchar2 default hr_api.g_varchar2,
529: p_performance_level_id in number default hr_api.g_number,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_attribute_category in varchar2 default hr_api.g_varchar2,
532: p_attribute1 in varchar2 default hr_api.g_varchar2,
533: p_attribute2 in varchar2 default hr_api.g_varchar2,
534: p_attribute3 in varchar2 default hr_api.g_varchar2,
535: p_attribute4 in varchar2 default hr_api.g_varchar2,
536: p_attribute5 in varchar2 default hr_api.g_varchar2,
537: p_attribute6 in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_attribute_category in varchar2 default hr_api.g_varchar2,
532: p_attribute1 in varchar2 default hr_api.g_varchar2,
533: p_attribute2 in varchar2 default hr_api.g_varchar2,
534: p_attribute3 in varchar2 default hr_api.g_varchar2,
535: p_attribute4 in varchar2 default hr_api.g_varchar2,
536: p_attribute5 in varchar2 default hr_api.g_varchar2,
537: p_attribute6 in varchar2 default hr_api.g_varchar2,
538: p_attribute7 in varchar2 default hr_api.g_varchar2,
531: p_attribute_category in varchar2 default hr_api.g_varchar2,
532: p_attribute1 in varchar2 default hr_api.g_varchar2,
533: p_attribute2 in varchar2 default hr_api.g_varchar2,
534: p_attribute3 in varchar2 default hr_api.g_varchar2,
535: p_attribute4 in varchar2 default hr_api.g_varchar2,
536: p_attribute5 in varchar2 default hr_api.g_varchar2,
537: p_attribute6 in varchar2 default hr_api.g_varchar2,
538: p_attribute7 in varchar2 default hr_api.g_varchar2,
539: p_attribute8 in varchar2 default hr_api.g_varchar2,
532: p_attribute1 in varchar2 default hr_api.g_varchar2,
533: p_attribute2 in varchar2 default hr_api.g_varchar2,
534: p_attribute3 in varchar2 default hr_api.g_varchar2,
535: p_attribute4 in varchar2 default hr_api.g_varchar2,
536: p_attribute5 in varchar2 default hr_api.g_varchar2,
537: p_attribute6 in varchar2 default hr_api.g_varchar2,
538: p_attribute7 in varchar2 default hr_api.g_varchar2,
539: p_attribute8 in varchar2 default hr_api.g_varchar2,
540: p_attribute9 in varchar2 default hr_api.g_varchar2,
533: p_attribute2 in varchar2 default hr_api.g_varchar2,
534: p_attribute3 in varchar2 default hr_api.g_varchar2,
535: p_attribute4 in varchar2 default hr_api.g_varchar2,
536: p_attribute5 in varchar2 default hr_api.g_varchar2,
537: p_attribute6 in varchar2 default hr_api.g_varchar2,
538: p_attribute7 in varchar2 default hr_api.g_varchar2,
539: p_attribute8 in varchar2 default hr_api.g_varchar2,
540: p_attribute9 in varchar2 default hr_api.g_varchar2,
541: p_attribute10 in varchar2 default hr_api.g_varchar2,
534: p_attribute3 in varchar2 default hr_api.g_varchar2,
535: p_attribute4 in varchar2 default hr_api.g_varchar2,
536: p_attribute5 in varchar2 default hr_api.g_varchar2,
537: p_attribute6 in varchar2 default hr_api.g_varchar2,
538: p_attribute7 in varchar2 default hr_api.g_varchar2,
539: p_attribute8 in varchar2 default hr_api.g_varchar2,
540: p_attribute9 in varchar2 default hr_api.g_varchar2,
541: p_attribute10 in varchar2 default hr_api.g_varchar2,
542: p_attribute11 in varchar2 default hr_api.g_varchar2,
535: p_attribute4 in varchar2 default hr_api.g_varchar2,
536: p_attribute5 in varchar2 default hr_api.g_varchar2,
537: p_attribute6 in varchar2 default hr_api.g_varchar2,
538: p_attribute7 in varchar2 default hr_api.g_varchar2,
539: p_attribute8 in varchar2 default hr_api.g_varchar2,
540: p_attribute9 in varchar2 default hr_api.g_varchar2,
541: p_attribute10 in varchar2 default hr_api.g_varchar2,
542: p_attribute11 in varchar2 default hr_api.g_varchar2,
543: p_attribute12 in varchar2 default hr_api.g_varchar2,
536: p_attribute5 in varchar2 default hr_api.g_varchar2,
537: p_attribute6 in varchar2 default hr_api.g_varchar2,
538: p_attribute7 in varchar2 default hr_api.g_varchar2,
539: p_attribute8 in varchar2 default hr_api.g_varchar2,
540: p_attribute9 in varchar2 default hr_api.g_varchar2,
541: p_attribute10 in varchar2 default hr_api.g_varchar2,
542: p_attribute11 in varchar2 default hr_api.g_varchar2,
543: p_attribute12 in varchar2 default hr_api.g_varchar2,
544: p_attribute13 in varchar2 default hr_api.g_varchar2,
537: p_attribute6 in varchar2 default hr_api.g_varchar2,
538: p_attribute7 in varchar2 default hr_api.g_varchar2,
539: p_attribute8 in varchar2 default hr_api.g_varchar2,
540: p_attribute9 in varchar2 default hr_api.g_varchar2,
541: p_attribute10 in varchar2 default hr_api.g_varchar2,
542: p_attribute11 in varchar2 default hr_api.g_varchar2,
543: p_attribute12 in varchar2 default hr_api.g_varchar2,
544: p_attribute13 in varchar2 default hr_api.g_varchar2,
545: p_attribute14 in varchar2 default hr_api.g_varchar2,
538: p_attribute7 in varchar2 default hr_api.g_varchar2,
539: p_attribute8 in varchar2 default hr_api.g_varchar2,
540: p_attribute9 in varchar2 default hr_api.g_varchar2,
541: p_attribute10 in varchar2 default hr_api.g_varchar2,
542: p_attribute11 in varchar2 default hr_api.g_varchar2,
543: p_attribute12 in varchar2 default hr_api.g_varchar2,
544: p_attribute13 in varchar2 default hr_api.g_varchar2,
545: p_attribute14 in varchar2 default hr_api.g_varchar2,
546: p_attribute15 in varchar2 default hr_api.g_varchar2,
539: p_attribute8 in varchar2 default hr_api.g_varchar2,
540: p_attribute9 in varchar2 default hr_api.g_varchar2,
541: p_attribute10 in varchar2 default hr_api.g_varchar2,
542: p_attribute11 in varchar2 default hr_api.g_varchar2,
543: p_attribute12 in varchar2 default hr_api.g_varchar2,
544: p_attribute13 in varchar2 default hr_api.g_varchar2,
545: p_attribute14 in varchar2 default hr_api.g_varchar2,
546: p_attribute15 in varchar2 default hr_api.g_varchar2,
547: p_attribute16 in varchar2 default hr_api.g_varchar2,
540: p_attribute9 in varchar2 default hr_api.g_varchar2,
541: p_attribute10 in varchar2 default hr_api.g_varchar2,
542: p_attribute11 in varchar2 default hr_api.g_varchar2,
543: p_attribute12 in varchar2 default hr_api.g_varchar2,
544: p_attribute13 in varchar2 default hr_api.g_varchar2,
545: p_attribute14 in varchar2 default hr_api.g_varchar2,
546: p_attribute15 in varchar2 default hr_api.g_varchar2,
547: p_attribute16 in varchar2 default hr_api.g_varchar2,
548: p_attribute17 in varchar2 default hr_api.g_varchar2,
541: p_attribute10 in varchar2 default hr_api.g_varchar2,
542: p_attribute11 in varchar2 default hr_api.g_varchar2,
543: p_attribute12 in varchar2 default hr_api.g_varchar2,
544: p_attribute13 in varchar2 default hr_api.g_varchar2,
545: p_attribute14 in varchar2 default hr_api.g_varchar2,
546: p_attribute15 in varchar2 default hr_api.g_varchar2,
547: p_attribute16 in varchar2 default hr_api.g_varchar2,
548: p_attribute17 in varchar2 default hr_api.g_varchar2,
549: p_attribute18 in varchar2 default hr_api.g_varchar2,
542: p_attribute11 in varchar2 default hr_api.g_varchar2,
543: p_attribute12 in varchar2 default hr_api.g_varchar2,
544: p_attribute13 in varchar2 default hr_api.g_varchar2,
545: p_attribute14 in varchar2 default hr_api.g_varchar2,
546: p_attribute15 in varchar2 default hr_api.g_varchar2,
547: p_attribute16 in varchar2 default hr_api.g_varchar2,
548: p_attribute17 in varchar2 default hr_api.g_varchar2,
549: p_attribute18 in varchar2 default hr_api.g_varchar2,
550: p_attribute19 in varchar2 default hr_api.g_varchar2,
543: p_attribute12 in varchar2 default hr_api.g_varchar2,
544: p_attribute13 in varchar2 default hr_api.g_varchar2,
545: p_attribute14 in varchar2 default hr_api.g_varchar2,
546: p_attribute15 in varchar2 default hr_api.g_varchar2,
547: p_attribute16 in varchar2 default hr_api.g_varchar2,
548: p_attribute17 in varchar2 default hr_api.g_varchar2,
549: p_attribute18 in varchar2 default hr_api.g_varchar2,
550: p_attribute19 in varchar2 default hr_api.g_varchar2,
551: p_attribute20 in varchar2 default hr_api.g_varchar2,
544: p_attribute13 in varchar2 default hr_api.g_varchar2,
545: p_attribute14 in varchar2 default hr_api.g_varchar2,
546: p_attribute15 in varchar2 default hr_api.g_varchar2,
547: p_attribute16 in varchar2 default hr_api.g_varchar2,
548: p_attribute17 in varchar2 default hr_api.g_varchar2,
549: p_attribute18 in varchar2 default hr_api.g_varchar2,
550: p_attribute19 in varchar2 default hr_api.g_varchar2,
551: p_attribute20 in varchar2 default hr_api.g_varchar2,
552: p_validate in boolean default false,
545: p_attribute14 in varchar2 default hr_api.g_varchar2,
546: p_attribute15 in varchar2 default hr_api.g_varchar2,
547: p_attribute16 in varchar2 default hr_api.g_varchar2,
548: p_attribute17 in varchar2 default hr_api.g_varchar2,
549: p_attribute18 in varchar2 default hr_api.g_varchar2,
550: p_attribute19 in varchar2 default hr_api.g_varchar2,
551: p_attribute20 in varchar2 default hr_api.g_varchar2,
552: p_validate in boolean default false,
553: p_effective_date in date,
546: p_attribute15 in varchar2 default hr_api.g_varchar2,
547: p_attribute16 in varchar2 default hr_api.g_varchar2,
548: p_attribute17 in varchar2 default hr_api.g_varchar2,
549: p_attribute18 in varchar2 default hr_api.g_varchar2,
550: p_attribute19 in varchar2 default hr_api.g_varchar2,
551: p_attribute20 in varchar2 default hr_api.g_varchar2,
552: p_validate in boolean default false,
553: p_effective_date in date,
554: p_appr_line_score in number default hr_api.g_number
547: p_attribute16 in varchar2 default hr_api.g_varchar2,
548: p_attribute17 in varchar2 default hr_api.g_varchar2,
549: p_attribute18 in varchar2 default hr_api.g_varchar2,
550: p_attribute19 in varchar2 default hr_api.g_varchar2,
551: p_attribute20 in varchar2 default hr_api.g_varchar2,
552: p_validate in boolean default false,
553: p_effective_date in date,
554: p_appr_line_score in number default hr_api.g_number
555: ) is
550: p_attribute19 in varchar2 default hr_api.g_varchar2,
551: p_attribute20 in varchar2 default hr_api.g_varchar2,
552: p_validate in boolean default false,
553: p_effective_date in date,
554: p_appr_line_score in number default hr_api.g_number
555: ) is
556:
557: l_rec per_prt_shd.g_rec_type;
558: l_proc varchar2(72) := g_package||'upd';
567: per_prt_shd.convert_args
568: (
569: p_performance_rating_id,
570: p_person_id,
571: hr_api.g_number,
572: p_object_version_number,
573: hr_api.g_number,
574: p_performance_level_id,
575: p_comments,
569: p_performance_rating_id,
570: p_person_id,
571: hr_api.g_number,
572: p_object_version_number,
573: hr_api.g_number,
574: p_performance_level_id,
575: p_comments,
576: p_attribute_category,
577: p_attribute1,