113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: per_chk_shd.g_api_dml := false; -- Unset the api dml status
120: per_chk_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: per_chk_shd.g_api_dml := false; -- Unset the api dml status
120: per_chk_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error
118: -- A check constraint has been violated
119: per_chk_shd.g_api_dml := false; -- Unset the api dml status
120: per_chk_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_chk_shd.g_api_dml := false; -- Unset the api dml status
130: per_chk_shd.constraint_error
123: -- Parent integrity has been violated
124: per_chk_shd.g_api_dml := false; -- Unset the api dml status
125: per_chk_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_chk_shd.g_api_dml := false; -- Unset the api dml status
130: per_chk_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_chk_shd.g_api_dml := false; -- Unset the api dml status
130: per_chk_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: per_chk_shd.g_api_dml := false; -- Unset the api dml status
134: Raise;
135: End update_dml;
304: );
305: --
306: exception
307: --
308: when hr_api.cannot_find_prog_unit then
309: --
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'per_checklist_items'
312: ,p_hook_type => 'AU');
306: exception
307: --
308: when hr_api.cannot_find_prog_unit then
309: --
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'per_checklist_items'
312: ,p_hook_type => 'AU');
313: --
314: end;
374: -- p_rec plsql record structure
375: -- to see if a system default is being used. If a system default
376: -- is being used then we must set to the 'current' argument value.
377: --
378: If (p_rec.person_id = hr_api.g_number) then
379: p_rec.person_id :=
380: per_chk_shd.g_old_rec.person_id;
381: End If;
382: If (p_rec.item_code = hr_api.g_varchar2) then
378: If (p_rec.person_id = hr_api.g_number) then
379: p_rec.person_id :=
380: per_chk_shd.g_old_rec.person_id;
381: End If;
382: If (p_rec.item_code = hr_api.g_varchar2) then
383: p_rec.item_code :=
384: per_chk_shd.g_old_rec.item_code;
385: End If;
386: If (p_rec.date_due = hr_api.g_date) then
382: If (p_rec.item_code = hr_api.g_varchar2) then
383: p_rec.item_code :=
384: per_chk_shd.g_old_rec.item_code;
385: End If;
386: If (p_rec.date_due = hr_api.g_date) then
387: p_rec.date_due :=
388: per_chk_shd.g_old_rec.date_due;
389: End If;
390: If (p_rec.date_done = hr_api.g_date) then
386: If (p_rec.date_due = hr_api.g_date) then
387: p_rec.date_due :=
388: per_chk_shd.g_old_rec.date_due;
389: End If;
390: If (p_rec.date_done = hr_api.g_date) then
391: p_rec.date_done :=
392: per_chk_shd.g_old_rec.date_done;
393: End If;
394: If (p_rec.status = hr_api.g_varchar2) then
390: If (p_rec.date_done = hr_api.g_date) then
391: p_rec.date_done :=
392: per_chk_shd.g_old_rec.date_done;
393: End If;
394: If (p_rec.status = hr_api.g_varchar2) then
395: p_rec.status :=
396: per_chk_shd.g_old_rec.status;
397: End If;
398: If (p_rec.notes = hr_api.g_varchar2) then
394: If (p_rec.status = hr_api.g_varchar2) then
395: p_rec.status :=
396: per_chk_shd.g_old_rec.status;
397: End If;
398: If (p_rec.notes = hr_api.g_varchar2) then
399: p_rec.notes :=
400: per_chk_shd.g_old_rec.notes;
401: End If;
402: If (p_rec.attribute_category = hr_api.g_varchar2) then
398: If (p_rec.notes = hr_api.g_varchar2) then
399: p_rec.notes :=
400: per_chk_shd.g_old_rec.notes;
401: End If;
402: If (p_rec.attribute_category = hr_api.g_varchar2) then
403: p_rec.attribute_category :=
404: per_chk_shd.g_old_rec.attribute_category;
405: End If;
406: If (p_rec.attribute1 = hr_api.g_varchar2) then
402: If (p_rec.attribute_category = hr_api.g_varchar2) then
403: p_rec.attribute_category :=
404: per_chk_shd.g_old_rec.attribute_category;
405: End If;
406: If (p_rec.attribute1 = hr_api.g_varchar2) then
407: p_rec.attribute1 :=
408: per_chk_shd.g_old_rec.attribute1;
409: End If;
410: If (p_rec.attribute2 = hr_api.g_varchar2) then
406: If (p_rec.attribute1 = hr_api.g_varchar2) then
407: p_rec.attribute1 :=
408: per_chk_shd.g_old_rec.attribute1;
409: End If;
410: If (p_rec.attribute2 = hr_api.g_varchar2) then
411: p_rec.attribute2 :=
412: per_chk_shd.g_old_rec.attribute2;
413: End If;
414: If (p_rec.attribute3 = hr_api.g_varchar2) then
410: If (p_rec.attribute2 = hr_api.g_varchar2) then
411: p_rec.attribute2 :=
412: per_chk_shd.g_old_rec.attribute2;
413: End If;
414: If (p_rec.attribute3 = hr_api.g_varchar2) then
415: p_rec.attribute3 :=
416: per_chk_shd.g_old_rec.attribute3;
417: End If;
418: If (p_rec.attribute4 = hr_api.g_varchar2) then
414: If (p_rec.attribute3 = hr_api.g_varchar2) then
415: p_rec.attribute3 :=
416: per_chk_shd.g_old_rec.attribute3;
417: End If;
418: If (p_rec.attribute4 = hr_api.g_varchar2) then
419: p_rec.attribute4 :=
420: per_chk_shd.g_old_rec.attribute4;
421: End If;
422: If (p_rec.attribute5 = hr_api.g_varchar2) then
418: If (p_rec.attribute4 = hr_api.g_varchar2) then
419: p_rec.attribute4 :=
420: per_chk_shd.g_old_rec.attribute4;
421: End If;
422: If (p_rec.attribute5 = hr_api.g_varchar2) then
423: p_rec.attribute5 :=
424: per_chk_shd.g_old_rec.attribute5;
425: End If;
426: If (p_rec.attribute6 = hr_api.g_varchar2) then
422: If (p_rec.attribute5 = hr_api.g_varchar2) then
423: p_rec.attribute5 :=
424: per_chk_shd.g_old_rec.attribute5;
425: End If;
426: If (p_rec.attribute6 = hr_api.g_varchar2) then
427: p_rec.attribute6 :=
428: per_chk_shd.g_old_rec.attribute6;
429: End If;
430: If (p_rec.attribute7 = hr_api.g_varchar2) then
426: If (p_rec.attribute6 = hr_api.g_varchar2) then
427: p_rec.attribute6 :=
428: per_chk_shd.g_old_rec.attribute6;
429: End If;
430: If (p_rec.attribute7 = hr_api.g_varchar2) then
431: p_rec.attribute7 :=
432: per_chk_shd.g_old_rec.attribute7;
433: End If;
434: If (p_rec.attribute8 = hr_api.g_varchar2) then
430: If (p_rec.attribute7 = hr_api.g_varchar2) then
431: p_rec.attribute7 :=
432: per_chk_shd.g_old_rec.attribute7;
433: End If;
434: If (p_rec.attribute8 = hr_api.g_varchar2) then
435: p_rec.attribute8 :=
436: per_chk_shd.g_old_rec.attribute8;
437: End If;
438: If (p_rec.attribute9 = hr_api.g_varchar2) then
434: If (p_rec.attribute8 = hr_api.g_varchar2) then
435: p_rec.attribute8 :=
436: per_chk_shd.g_old_rec.attribute8;
437: End If;
438: If (p_rec.attribute9 = hr_api.g_varchar2) then
439: p_rec.attribute9 :=
440: per_chk_shd.g_old_rec.attribute9;
441: End If;
442: If (p_rec.attribute10 = hr_api.g_varchar2) then
438: If (p_rec.attribute9 = hr_api.g_varchar2) then
439: p_rec.attribute9 :=
440: per_chk_shd.g_old_rec.attribute9;
441: End If;
442: If (p_rec.attribute10 = hr_api.g_varchar2) then
443: p_rec.attribute10 :=
444: per_chk_shd.g_old_rec.attribute10;
445: End If;
446: If (p_rec.attribute11 = hr_api.g_varchar2) then
442: If (p_rec.attribute10 = hr_api.g_varchar2) then
443: p_rec.attribute10 :=
444: per_chk_shd.g_old_rec.attribute10;
445: End If;
446: If (p_rec.attribute11 = hr_api.g_varchar2) then
447: p_rec.attribute11 :=
448: per_chk_shd.g_old_rec.attribute11;
449: End If;
450: If (p_rec.attribute12 = hr_api.g_varchar2) then
446: If (p_rec.attribute11 = hr_api.g_varchar2) then
447: p_rec.attribute11 :=
448: per_chk_shd.g_old_rec.attribute11;
449: End If;
450: If (p_rec.attribute12 = hr_api.g_varchar2) then
451: p_rec.attribute12 :=
452: per_chk_shd.g_old_rec.attribute12;
453: End If;
454: If (p_rec.attribute13 = hr_api.g_varchar2) then
450: If (p_rec.attribute12 = hr_api.g_varchar2) then
451: p_rec.attribute12 :=
452: per_chk_shd.g_old_rec.attribute12;
453: End If;
454: If (p_rec.attribute13 = hr_api.g_varchar2) then
455: p_rec.attribute13 :=
456: per_chk_shd.g_old_rec.attribute13;
457: End If;
458: If (p_rec.attribute14 = hr_api.g_varchar2) then
454: If (p_rec.attribute13 = hr_api.g_varchar2) then
455: p_rec.attribute13 :=
456: per_chk_shd.g_old_rec.attribute13;
457: End If;
458: If (p_rec.attribute14 = hr_api.g_varchar2) then
459: p_rec.attribute14 :=
460: per_chk_shd.g_old_rec.attribute14;
461: End If;
462: If (p_rec.attribute15 = hr_api.g_varchar2) then
458: If (p_rec.attribute14 = hr_api.g_varchar2) then
459: p_rec.attribute14 :=
460: per_chk_shd.g_old_rec.attribute14;
461: End If;
462: If (p_rec.attribute15 = hr_api.g_varchar2) then
463: p_rec.attribute15 :=
464: per_chk_shd.g_old_rec.attribute15;
465: End If;
466: If (p_rec.attribute16 = hr_api.g_varchar2) then
462: If (p_rec.attribute15 = hr_api.g_varchar2) then
463: p_rec.attribute15 :=
464: per_chk_shd.g_old_rec.attribute15;
465: End If;
466: If (p_rec.attribute16 = hr_api.g_varchar2) then
467: p_rec.attribute16 :=
468: per_chk_shd.g_old_rec.attribute16;
469: End If;
470: If (p_rec.attribute17 = hr_api.g_varchar2) then
466: If (p_rec.attribute16 = hr_api.g_varchar2) then
467: p_rec.attribute16 :=
468: per_chk_shd.g_old_rec.attribute16;
469: End If;
470: If (p_rec.attribute17 = hr_api.g_varchar2) then
471: p_rec.attribute17 :=
472: per_chk_shd.g_old_rec.attribute17;
473: End If;
474: If (p_rec.attribute18 = hr_api.g_varchar2) then
470: If (p_rec.attribute17 = hr_api.g_varchar2) then
471: p_rec.attribute17 :=
472: per_chk_shd.g_old_rec.attribute17;
473: End If;
474: If (p_rec.attribute18 = hr_api.g_varchar2) then
475: p_rec.attribute18 :=
476: per_chk_shd.g_old_rec.attribute18;
477: End If;
478: If (p_rec.attribute19 = hr_api.g_varchar2) then
474: If (p_rec.attribute18 = hr_api.g_varchar2) then
475: p_rec.attribute18 :=
476: per_chk_shd.g_old_rec.attribute18;
477: End If;
478: If (p_rec.attribute19 = hr_api.g_varchar2) then
479: p_rec.attribute19 :=
480: per_chk_shd.g_old_rec.attribute19;
481: End If;
482: If (p_rec.attribute20 = hr_api.g_varchar2) then
478: If (p_rec.attribute19 = hr_api.g_varchar2) then
479: p_rec.attribute19 :=
480: per_chk_shd.g_old_rec.attribute19;
481: End If;
482: If (p_rec.attribute20 = hr_api.g_varchar2) then
483: p_rec.attribute20 :=
484: per_chk_shd.g_old_rec.attribute20;
485: End If;
486: If (p_rec.attribute21 = hr_api.g_varchar2) then
482: If (p_rec.attribute20 = hr_api.g_varchar2) then
483: p_rec.attribute20 :=
484: per_chk_shd.g_old_rec.attribute20;
485: End If;
486: If (p_rec.attribute21 = hr_api.g_varchar2) then
487: p_rec.attribute21 :=
488: per_chk_shd.g_old_rec.attribute21;
489: End If;
490: If (p_rec.attribute22 = hr_api.g_varchar2) then
486: If (p_rec.attribute21 = hr_api.g_varchar2) then
487: p_rec.attribute21 :=
488: per_chk_shd.g_old_rec.attribute21;
489: End If;
490: If (p_rec.attribute22 = hr_api.g_varchar2) then
491: p_rec.attribute22 :=
492: per_chk_shd.g_old_rec.attribute22;
493: End If;
494: If (p_rec.attribute23 = hr_api.g_varchar2) then
490: If (p_rec.attribute22 = hr_api.g_varchar2) then
491: p_rec.attribute22 :=
492: per_chk_shd.g_old_rec.attribute22;
493: End If;
494: If (p_rec.attribute23 = hr_api.g_varchar2) then
495: p_rec.attribute23 :=
496: per_chk_shd.g_old_rec.attribute23;
497: End If;
498: If (p_rec.attribute24 = hr_api.g_varchar2) then
494: If (p_rec.attribute23 = hr_api.g_varchar2) then
495: p_rec.attribute23 :=
496: per_chk_shd.g_old_rec.attribute23;
497: End If;
498: If (p_rec.attribute24 = hr_api.g_varchar2) then
499: p_rec.attribute24 :=
500: per_chk_shd.g_old_rec.attribute24;
501: End If;
502: If (p_rec.attribute25 = hr_api.g_varchar2) then
498: If (p_rec.attribute24 = hr_api.g_varchar2) then
499: p_rec.attribute24 :=
500: per_chk_shd.g_old_rec.attribute24;
501: End If;
502: If (p_rec.attribute25 = hr_api.g_varchar2) then
503: p_rec.attribute25 :=
504: per_chk_shd.g_old_rec.attribute25;
505: End If;
506: If (p_rec.attribute26 = hr_api.g_varchar2) then
502: If (p_rec.attribute25 = hr_api.g_varchar2) then
503: p_rec.attribute25 :=
504: per_chk_shd.g_old_rec.attribute25;
505: End If;
506: If (p_rec.attribute26 = hr_api.g_varchar2) then
507: p_rec.attribute26 :=
508: per_chk_shd.g_old_rec.attribute26;
509: End If;
510: If (p_rec.attribute27 = hr_api.g_varchar2) then
506: If (p_rec.attribute26 = hr_api.g_varchar2) then
507: p_rec.attribute26 :=
508: per_chk_shd.g_old_rec.attribute26;
509: End If;
510: If (p_rec.attribute27 = hr_api.g_varchar2) then
511: p_rec.attribute27 :=
512: per_chk_shd.g_old_rec.attribute27;
513: End If;
514: If (p_rec.attribute28 = hr_api.g_varchar2) then
510: If (p_rec.attribute27 = hr_api.g_varchar2) then
511: p_rec.attribute27 :=
512: per_chk_shd.g_old_rec.attribute27;
513: End If;
514: If (p_rec.attribute28 = hr_api.g_varchar2) then
515: p_rec.attribute28 :=
516: per_chk_shd.g_old_rec.attribute28;
517: End If;
518: If (p_rec.attribute29 = hr_api.g_varchar2) then
514: If (p_rec.attribute28 = hr_api.g_varchar2) then
515: p_rec.attribute28 :=
516: per_chk_shd.g_old_rec.attribute28;
517: End If;
518: If (p_rec.attribute29 = hr_api.g_varchar2) then
519: p_rec.attribute29 :=
520: per_chk_shd.g_old_rec.attribute29;
521: End If;
522: If (p_rec.attribute30 = hr_api.g_varchar2) then
518: If (p_rec.attribute29 = hr_api.g_varchar2) then
519: p_rec.attribute29 :=
520: per_chk_shd.g_old_rec.attribute29;
521: End If;
522: If (p_rec.attribute30 = hr_api.g_varchar2) then
523: p_rec.attribute30 :=
524: per_chk_shd.g_old_rec.attribute30;
525: End If;
526: --
580: Procedure upd
581: (
582: p_effective_date in date,
583: p_checklist_item_id in number,
584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
581: (
582: p_effective_date in date,
583: p_checklist_item_id in number,
584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
582: p_effective_date in date,
583: p_checklist_item_id in number,
584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
583: p_checklist_item_id in number,
584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
584: p_person_id in number default hr_api.g_number,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
585: p_item_code in varchar2 default hr_api.g_varchar2,
586: p_date_due in date default hr_api.g_date,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
587: p_date_done in date default hr_api.g_date,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
588: p_status in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
589: p_notes in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
590: p_object_version_number in out nocopy number,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
591: p_attribute_category in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
592: p_attribute1 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
593: p_attribute2 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
594: p_attribute3 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
595: p_attribute4 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
596: p_attribute5 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
597: p_attribute6 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
598: p_attribute7 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
599: p_attribute8 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
600: p_attribute9 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
601: p_attribute10 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
602: p_attribute11 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
603: p_attribute12 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
604: p_attribute13 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
605: p_attribute14 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
606: p_attribute15 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
607: p_attribute16 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
608: p_attribute17 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
609: p_attribute18 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
610: p_attribute19 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
611: p_attribute20 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
612: p_attribute21 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
613: p_attribute22 in varchar2 default hr_api.g_varchar2,
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
614: p_attribute23 in varchar2 default hr_api.g_varchar2,
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
622: ) is
615: p_attribute24 in varchar2 default hr_api.g_varchar2,
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
622: ) is
623: --
616: p_attribute25 in varchar2 default hr_api.g_varchar2,
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
622: ) is
623: --
624: l_rec per_chk_shd.g_rec_type;
617: p_attribute26 in varchar2 default hr_api.g_varchar2,
618: p_attribute27 in varchar2 default hr_api.g_varchar2,
619: p_attribute28 in varchar2 default hr_api.g_varchar2,
620: p_attribute29 in varchar2 default hr_api.g_varchar2,
621: p_attribute30 in varchar2 default hr_api.g_varchar2
622: ) is
623: --
624: l_rec per_chk_shd.g_rec_type;
625: l_proc varchar2(72) := g_package||'upd';