106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: --
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: per_pst_shd.g_api_dml := false; -- Unset the api dml status
113: per_pst_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: per_pst_shd.g_api_dml := false; -- Unset the api dml status
113: per_pst_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: per_pst_shd.g_api_dml := false; -- Unset the api dml status
118: per_pst_shd.constraint_error
111: -- A check constraint has been violated
112: per_pst_shd.g_api_dml := false; -- Unset the api dml status
113: per_pst_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: per_pst_shd.g_api_dml := false; -- Unset the api dml status
118: per_pst_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: per_pst_shd.g_api_dml := false; -- Unset the api dml status
118: per_pst_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_pst_shd.g_api_dml := false; -- Unset the api dml status
123: per_pst_shd.constraint_error
116: -- Parent integrity has been violated
117: per_pst_shd.g_api_dml := false; -- Unset the api dml status
118: per_pst_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_pst_shd.g_api_dml := false; -- Unset the api dml status
123: per_pst_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: per_pst_shd.g_api_dml := false; -- Unset the api dml status
123: per_pst_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: per_pst_shd.g_api_dml := false; -- Unset the api dml status
127: Raise;
128: End update_dml;
341: );
342: --
343: exception
344: --
345: when hr_api.cannot_find_prog_unit then
346: --
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'PER_POSITION_STRUCTURES'
349: ,p_hook_type => 'AU');
343: exception
344: --
345: when hr_api.cannot_find_prog_unit then
346: --
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'PER_POSITION_STRUCTURES'
349: ,p_hook_type => 'AU');
350: --
351: end;
406: -- p_rec plsql record structure
407: -- to see if a system default is being used. If a system default
408: -- is being used then we must set to the 'current' argument value.
409: --
410: If (p_rec.business_group_id = hr_api.g_number) then
411: p_rec.business_group_id :=
412: per_pst_shd.g_old_rec.business_group_id;
413: End If;
414: If (p_rec.name = hr_api.g_varchar2) then
410: If (p_rec.business_group_id = hr_api.g_number) then
411: p_rec.business_group_id :=
412: per_pst_shd.g_old_rec.business_group_id;
413: End If;
414: If (p_rec.name = hr_api.g_varchar2) then
415: p_rec.name :=
416: per_pst_shd.g_old_rec.name;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then
414: If (p_rec.name = hr_api.g_varchar2) then
415: p_rec.name :=
416: per_pst_shd.g_old_rec.name;
417: End If;
418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_pst_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.primary_position_flag = hr_api.g_varchar2) then
418: If (p_rec.comments = hr_api.g_varchar2) then
419: p_rec.comments :=
420: per_pst_shd.g_old_rec.comments;
421: End If;
422: If (p_rec.primary_position_flag = hr_api.g_varchar2) then
423: p_rec.primary_position_flag :=
424: per_pst_shd.g_old_rec.primary_position_flag;
425: End If;
426: If (p_rec.request_id = hr_api.g_number) then
422: If (p_rec.primary_position_flag = hr_api.g_varchar2) then
423: p_rec.primary_position_flag :=
424: per_pst_shd.g_old_rec.primary_position_flag;
425: End If;
426: If (p_rec.request_id = hr_api.g_number) then
427: p_rec.request_id :=
428: per_pst_shd.g_old_rec.request_id;
429: End If;
430: If (p_rec.program_application_id = hr_api.g_number) then
426: If (p_rec.request_id = hr_api.g_number) then
427: p_rec.request_id :=
428: per_pst_shd.g_old_rec.request_id;
429: End If;
430: If (p_rec.program_application_id = hr_api.g_number) then
431: p_rec.program_application_id :=
432: per_pst_shd.g_old_rec.program_application_id;
433: End If;
434: If (p_rec.program_id = hr_api.g_number) then
430: If (p_rec.program_application_id = hr_api.g_number) then
431: p_rec.program_application_id :=
432: per_pst_shd.g_old_rec.program_application_id;
433: End If;
434: If (p_rec.program_id = hr_api.g_number) then
435: p_rec.program_id :=
436: per_pst_shd.g_old_rec.program_id;
437: End If;
438: If (p_rec.program_update_date = hr_api.g_date) then
434: If (p_rec.program_id = hr_api.g_number) then
435: p_rec.program_id :=
436: per_pst_shd.g_old_rec.program_id;
437: End If;
438: If (p_rec.program_update_date = hr_api.g_date) then
439: p_rec.program_update_date :=
440: per_pst_shd.g_old_rec.program_update_date;
441: End If;
442: If (p_rec.attribute_category = hr_api.g_varchar2) then
438: If (p_rec.program_update_date = hr_api.g_date) then
439: p_rec.program_update_date :=
440: per_pst_shd.g_old_rec.program_update_date;
441: End If;
442: If (p_rec.attribute_category = hr_api.g_varchar2) then
443: p_rec.attribute_category :=
444: per_pst_shd.g_old_rec.attribute_category;
445: End If;
446: If (p_rec.attribute1 = hr_api.g_varchar2) then
442: If (p_rec.attribute_category = hr_api.g_varchar2) then
443: p_rec.attribute_category :=
444: per_pst_shd.g_old_rec.attribute_category;
445: End If;
446: If (p_rec.attribute1 = hr_api.g_varchar2) then
447: p_rec.attribute1 :=
448: per_pst_shd.g_old_rec.attribute1;
449: End If;
450: If (p_rec.attribute2 = hr_api.g_varchar2) then
446: If (p_rec.attribute1 = hr_api.g_varchar2) then
447: p_rec.attribute1 :=
448: per_pst_shd.g_old_rec.attribute1;
449: End If;
450: If (p_rec.attribute2 = hr_api.g_varchar2) then
451: p_rec.attribute2 :=
452: per_pst_shd.g_old_rec.attribute2;
453: End If;
454: If (p_rec.attribute3 = hr_api.g_varchar2) then
450: If (p_rec.attribute2 = hr_api.g_varchar2) then
451: p_rec.attribute2 :=
452: per_pst_shd.g_old_rec.attribute2;
453: End If;
454: If (p_rec.attribute3 = hr_api.g_varchar2) then
455: p_rec.attribute3 :=
456: per_pst_shd.g_old_rec.attribute3;
457: End If;
458: If (p_rec.attribute4 = hr_api.g_varchar2) then
454: If (p_rec.attribute3 = hr_api.g_varchar2) then
455: p_rec.attribute3 :=
456: per_pst_shd.g_old_rec.attribute3;
457: End If;
458: If (p_rec.attribute4 = hr_api.g_varchar2) then
459: p_rec.attribute4 :=
460: per_pst_shd.g_old_rec.attribute4;
461: End If;
462: If (p_rec.attribute5 = hr_api.g_varchar2) then
458: If (p_rec.attribute4 = hr_api.g_varchar2) then
459: p_rec.attribute4 :=
460: per_pst_shd.g_old_rec.attribute4;
461: End If;
462: If (p_rec.attribute5 = hr_api.g_varchar2) then
463: p_rec.attribute5 :=
464: per_pst_shd.g_old_rec.attribute5;
465: End If;
466: If (p_rec.attribute6 = hr_api.g_varchar2) then
462: If (p_rec.attribute5 = hr_api.g_varchar2) then
463: p_rec.attribute5 :=
464: per_pst_shd.g_old_rec.attribute5;
465: End If;
466: If (p_rec.attribute6 = hr_api.g_varchar2) then
467: p_rec.attribute6 :=
468: per_pst_shd.g_old_rec.attribute6;
469: End If;
470: If (p_rec.attribute7 = hr_api.g_varchar2) then
466: If (p_rec.attribute6 = hr_api.g_varchar2) then
467: p_rec.attribute6 :=
468: per_pst_shd.g_old_rec.attribute6;
469: End If;
470: If (p_rec.attribute7 = hr_api.g_varchar2) then
471: p_rec.attribute7 :=
472: per_pst_shd.g_old_rec.attribute7;
473: End If;
474: If (p_rec.attribute8 = hr_api.g_varchar2) then
470: If (p_rec.attribute7 = hr_api.g_varchar2) then
471: p_rec.attribute7 :=
472: per_pst_shd.g_old_rec.attribute7;
473: End If;
474: If (p_rec.attribute8 = hr_api.g_varchar2) then
475: p_rec.attribute8 :=
476: per_pst_shd.g_old_rec.attribute8;
477: End If;
478: If (p_rec.attribute9 = hr_api.g_varchar2) then
474: If (p_rec.attribute8 = hr_api.g_varchar2) then
475: p_rec.attribute8 :=
476: per_pst_shd.g_old_rec.attribute8;
477: End If;
478: If (p_rec.attribute9 = hr_api.g_varchar2) then
479: p_rec.attribute9 :=
480: per_pst_shd.g_old_rec.attribute9;
481: End If;
482: If (p_rec.attribute10 = hr_api.g_varchar2) then
478: If (p_rec.attribute9 = hr_api.g_varchar2) then
479: p_rec.attribute9 :=
480: per_pst_shd.g_old_rec.attribute9;
481: End If;
482: If (p_rec.attribute10 = hr_api.g_varchar2) then
483: p_rec.attribute10 :=
484: per_pst_shd.g_old_rec.attribute10;
485: End If;
486: If (p_rec.attribute11 = hr_api.g_varchar2) then
482: If (p_rec.attribute10 = hr_api.g_varchar2) then
483: p_rec.attribute10 :=
484: per_pst_shd.g_old_rec.attribute10;
485: End If;
486: If (p_rec.attribute11 = hr_api.g_varchar2) then
487: p_rec.attribute11 :=
488: per_pst_shd.g_old_rec.attribute11;
489: End If;
490: If (p_rec.attribute12 = hr_api.g_varchar2) then
486: If (p_rec.attribute11 = hr_api.g_varchar2) then
487: p_rec.attribute11 :=
488: per_pst_shd.g_old_rec.attribute11;
489: End If;
490: If (p_rec.attribute12 = hr_api.g_varchar2) then
491: p_rec.attribute12 :=
492: per_pst_shd.g_old_rec.attribute12;
493: End If;
494: If (p_rec.attribute13 = hr_api.g_varchar2) then
490: If (p_rec.attribute12 = hr_api.g_varchar2) then
491: p_rec.attribute12 :=
492: per_pst_shd.g_old_rec.attribute12;
493: End If;
494: If (p_rec.attribute13 = hr_api.g_varchar2) then
495: p_rec.attribute13 :=
496: per_pst_shd.g_old_rec.attribute13;
497: End If;
498: If (p_rec.attribute14 = hr_api.g_varchar2) then
494: If (p_rec.attribute13 = hr_api.g_varchar2) then
495: p_rec.attribute13 :=
496: per_pst_shd.g_old_rec.attribute13;
497: End If;
498: If (p_rec.attribute14 = hr_api.g_varchar2) then
499: p_rec.attribute14 :=
500: per_pst_shd.g_old_rec.attribute14;
501: End If;
502: If (p_rec.attribute15 = hr_api.g_varchar2) then
498: If (p_rec.attribute14 = hr_api.g_varchar2) then
499: p_rec.attribute14 :=
500: per_pst_shd.g_old_rec.attribute14;
501: End If;
502: If (p_rec.attribute15 = hr_api.g_varchar2) then
503: p_rec.attribute15 :=
504: per_pst_shd.g_old_rec.attribute15;
505: End If;
506: If (p_rec.attribute16 = hr_api.g_varchar2) then
502: If (p_rec.attribute15 = hr_api.g_varchar2) then
503: p_rec.attribute15 :=
504: per_pst_shd.g_old_rec.attribute15;
505: End If;
506: If (p_rec.attribute16 = hr_api.g_varchar2) then
507: p_rec.attribute16 :=
508: per_pst_shd.g_old_rec.attribute16;
509: End If;
510: If (p_rec.attribute17 = hr_api.g_varchar2) then
506: If (p_rec.attribute16 = hr_api.g_varchar2) then
507: p_rec.attribute16 :=
508: per_pst_shd.g_old_rec.attribute16;
509: End If;
510: If (p_rec.attribute17 = hr_api.g_varchar2) then
511: p_rec.attribute17 :=
512: per_pst_shd.g_old_rec.attribute17;
513: End If;
514: If (p_rec.attribute18 = hr_api.g_varchar2) then
510: If (p_rec.attribute17 = hr_api.g_varchar2) then
511: p_rec.attribute17 :=
512: per_pst_shd.g_old_rec.attribute17;
513: End If;
514: If (p_rec.attribute18 = hr_api.g_varchar2) then
515: p_rec.attribute18 :=
516: per_pst_shd.g_old_rec.attribute18;
517: End If;
518: If (p_rec.attribute19 = hr_api.g_varchar2) then
514: If (p_rec.attribute18 = hr_api.g_varchar2) then
515: p_rec.attribute18 :=
516: per_pst_shd.g_old_rec.attribute18;
517: End If;
518: If (p_rec.attribute19 = hr_api.g_varchar2) then
519: p_rec.attribute19 :=
520: per_pst_shd.g_old_rec.attribute19;
521: End If;
522: If (p_rec.attribute20 = hr_api.g_varchar2) then
518: If (p_rec.attribute19 = hr_api.g_varchar2) then
519: p_rec.attribute19 :=
520: per_pst_shd.g_old_rec.attribute19;
521: End If;
522: If (p_rec.attribute20 = hr_api.g_varchar2) then
523: p_rec.attribute20 :=
524: per_pst_shd.g_old_rec.attribute20;
525: End If;
526: --
580: Procedure upd
581: (p_effective_date in date
582: ,p_position_structure_id in number
583: ,p_object_version_number in out nocopy number
584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
581: (p_effective_date in date
582: ,p_position_structure_id in number
583: ,p_object_version_number in out nocopy number
584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
582: ,p_position_structure_id in number
583: ,p_object_version_number in out nocopy number
584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
583: ,p_object_version_number in out nocopy number
584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
584: ,p_business_group_id in number default hr_api.g_number
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
585: ,p_name in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
586: ,p_comments in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
587: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
588: ,p_request_id in number default hr_api.g_number
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
589: ,p_program_application_id in number default hr_api.g_number
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
590: ,p_program_id in number default hr_api.g_number
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
591: ,p_program_update_date in date default hr_api.g_date
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
592: ,p_attribute_category in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
593: ,p_attribute1 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
594: ,p_attribute2 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
595: ,p_attribute3 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
596: ,p_attribute4 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
597: ,p_attribute5 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
598: ,p_attribute6 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
599: ,p_attribute7 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
600: ,p_attribute8 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
601: ,p_attribute9 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
602: ,p_attribute10 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
603: ,p_attribute11 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
604: ,p_attribute12 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
605: ,p_attribute13 in varchar2 default hr_api.g_varchar2
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
613: ) is
606: ,p_attribute14 in varchar2 default hr_api.g_varchar2
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
613: ) is
614: --
607: ,p_attribute15 in varchar2 default hr_api.g_varchar2
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
613: ) is
614: --
615: l_rec per_pst_shd.g_rec_type;
608: ,p_attribute16 in varchar2 default hr_api.g_varchar2
609: ,p_attribute17 in varchar2 default hr_api.g_varchar2
610: ,p_attribute18 in varchar2 default hr_api.g_varchar2
611: ,p_attribute19 in varchar2 default hr_api.g_varchar2
612: ,p_attribute20 in varchar2 default hr_api.g_varchar2
613: ) is
614: --
615: l_rec per_pst_shd.g_rec_type;
616: l_proc varchar2(72) := g_package||'upd';