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: --
113: irc_cmp_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: --
113: irc_cmp_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: --
118: irc_cmp_shd.constraint_error
111: -- A check constraint has been violated
112: --
113: irc_cmp_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: --
118: irc_cmp_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: --
118: irc_cmp_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: --
123: irc_cmp_shd.constraint_error
116: -- Parent integrity has been violated
117: --
118: irc_cmp_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: --
123: irc_cmp_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: --
123: irc_cmp_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
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 => 'IRC_COMM_PROPERTIES'
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 => 'IRC_COMM_PROPERTIES'
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.object_type = hr_api.g_varchar2) then
411: p_rec.object_type :=
412: irc_cmp_shd.g_old_rec.object_type;
413: End If;
414: If (p_rec.object_id = hr_api.g_number) then
410: If (p_rec.object_type = hr_api.g_varchar2) then
411: p_rec.object_type :=
412: irc_cmp_shd.g_old_rec.object_type;
413: End If;
414: If (p_rec.object_id = hr_api.g_number) then
415: p_rec.object_id :=
416: irc_cmp_shd.g_old_rec.object_id;
417: End If;
418: If (p_rec.default_comm_status = hr_api.g_varchar2) then
414: If (p_rec.object_id = hr_api.g_number) then
415: p_rec.object_id :=
416: irc_cmp_shd.g_old_rec.object_id;
417: End If;
418: If (p_rec.default_comm_status = hr_api.g_varchar2) then
419: p_rec.default_comm_status :=
420: irc_cmp_shd.g_old_rec.default_comm_status;
421: End If;
422: If (p_rec.allow_attachment_flag = hr_api.g_varchar2) then
418: If (p_rec.default_comm_status = hr_api.g_varchar2) then
419: p_rec.default_comm_status :=
420: irc_cmp_shd.g_old_rec.default_comm_status;
421: End If;
422: If (p_rec.allow_attachment_flag = hr_api.g_varchar2) then
423: p_rec.allow_attachment_flag :=
424: irc_cmp_shd.g_old_rec.allow_attachment_flag;
425: End If;
426: If (p_rec.auto_notification_flag = hr_api.g_varchar2) then
422: If (p_rec.allow_attachment_flag = hr_api.g_varchar2) then
423: p_rec.allow_attachment_flag :=
424: irc_cmp_shd.g_old_rec.allow_attachment_flag;
425: End If;
426: If (p_rec.auto_notification_flag = hr_api.g_varchar2) then
427: p_rec.auto_notification_flag :=
428: irc_cmp_shd.g_old_rec.auto_notification_flag;
429: End If;
430: If (p_rec.allow_add_recipients = hr_api.g_varchar2) then
426: If (p_rec.auto_notification_flag = hr_api.g_varchar2) then
427: p_rec.auto_notification_flag :=
428: irc_cmp_shd.g_old_rec.auto_notification_flag;
429: End If;
430: If (p_rec.allow_add_recipients = hr_api.g_varchar2) then
431: p_rec.allow_add_recipients :=
432: irc_cmp_shd.g_old_rec.allow_add_recipients;
433: End If;
434: If (p_rec.default_moderator = hr_api.g_varchar2) then
430: If (p_rec.allow_add_recipients = hr_api.g_varchar2) then
431: p_rec.allow_add_recipients :=
432: irc_cmp_shd.g_old_rec.allow_add_recipients;
433: End If;
434: If (p_rec.default_moderator = hr_api.g_varchar2) then
435: p_rec.default_moderator :=
436: irc_cmp_shd.g_old_rec.default_moderator;
437: End If;
438: If (p_rec.attribute_category = hr_api.g_varchar2) then
434: If (p_rec.default_moderator = hr_api.g_varchar2) then
435: p_rec.default_moderator :=
436: irc_cmp_shd.g_old_rec.default_moderator;
437: End If;
438: If (p_rec.attribute_category = hr_api.g_varchar2) then
439: p_rec.attribute_category :=
440: irc_cmp_shd.g_old_rec.attribute_category;
441: End If;
442: If (p_rec.attribute1 = hr_api.g_varchar2) then
438: If (p_rec.attribute_category = hr_api.g_varchar2) then
439: p_rec.attribute_category :=
440: irc_cmp_shd.g_old_rec.attribute_category;
441: End If;
442: If (p_rec.attribute1 = hr_api.g_varchar2) then
443: p_rec.attribute1 :=
444: irc_cmp_shd.g_old_rec.attribute1;
445: End If;
446: If (p_rec.attribute2 = hr_api.g_varchar2) then
442: If (p_rec.attribute1 = hr_api.g_varchar2) then
443: p_rec.attribute1 :=
444: irc_cmp_shd.g_old_rec.attribute1;
445: End If;
446: If (p_rec.attribute2 = hr_api.g_varchar2) then
447: p_rec.attribute2 :=
448: irc_cmp_shd.g_old_rec.attribute2;
449: End If;
450: If (p_rec.attribute3 = hr_api.g_varchar2) then
446: If (p_rec.attribute2 = hr_api.g_varchar2) then
447: p_rec.attribute2 :=
448: irc_cmp_shd.g_old_rec.attribute2;
449: End If;
450: If (p_rec.attribute3 = hr_api.g_varchar2) then
451: p_rec.attribute3 :=
452: irc_cmp_shd.g_old_rec.attribute3;
453: End If;
454: If (p_rec.attribute4 = hr_api.g_varchar2) then
450: If (p_rec.attribute3 = hr_api.g_varchar2) then
451: p_rec.attribute3 :=
452: irc_cmp_shd.g_old_rec.attribute3;
453: End If;
454: If (p_rec.attribute4 = hr_api.g_varchar2) then
455: p_rec.attribute4 :=
456: irc_cmp_shd.g_old_rec.attribute4;
457: End If;
458: If (p_rec.attribute5 = hr_api.g_varchar2) then
454: If (p_rec.attribute4 = hr_api.g_varchar2) then
455: p_rec.attribute4 :=
456: irc_cmp_shd.g_old_rec.attribute4;
457: End If;
458: If (p_rec.attribute5 = hr_api.g_varchar2) then
459: p_rec.attribute5 :=
460: irc_cmp_shd.g_old_rec.attribute5;
461: End If;
462: If (p_rec.attribute6 = hr_api.g_varchar2) then
458: If (p_rec.attribute5 = hr_api.g_varchar2) then
459: p_rec.attribute5 :=
460: irc_cmp_shd.g_old_rec.attribute5;
461: End If;
462: If (p_rec.attribute6 = hr_api.g_varchar2) then
463: p_rec.attribute6 :=
464: irc_cmp_shd.g_old_rec.attribute6;
465: End If;
466: If (p_rec.attribute7 = hr_api.g_varchar2) then
462: If (p_rec.attribute6 = hr_api.g_varchar2) then
463: p_rec.attribute6 :=
464: irc_cmp_shd.g_old_rec.attribute6;
465: End If;
466: If (p_rec.attribute7 = hr_api.g_varchar2) then
467: p_rec.attribute7 :=
468: irc_cmp_shd.g_old_rec.attribute7;
469: End If;
470: If (p_rec.attribute8 = hr_api.g_varchar2) then
466: If (p_rec.attribute7 = hr_api.g_varchar2) then
467: p_rec.attribute7 :=
468: irc_cmp_shd.g_old_rec.attribute7;
469: End If;
470: If (p_rec.attribute8 = hr_api.g_varchar2) then
471: p_rec.attribute8 :=
472: irc_cmp_shd.g_old_rec.attribute8;
473: End If;
474: If (p_rec.attribute9 = hr_api.g_varchar2) then
470: If (p_rec.attribute8 = hr_api.g_varchar2) then
471: p_rec.attribute8 :=
472: irc_cmp_shd.g_old_rec.attribute8;
473: End If;
474: If (p_rec.attribute9 = hr_api.g_varchar2) then
475: p_rec.attribute9 :=
476: irc_cmp_shd.g_old_rec.attribute9;
477: End If;
478: If (p_rec.attribute10 = hr_api.g_varchar2) then
474: If (p_rec.attribute9 = hr_api.g_varchar2) then
475: p_rec.attribute9 :=
476: irc_cmp_shd.g_old_rec.attribute9;
477: End If;
478: If (p_rec.attribute10 = hr_api.g_varchar2) then
479: p_rec.attribute10 :=
480: irc_cmp_shd.g_old_rec.attribute10;
481: End If;
482: If (p_rec.information_category = hr_api.g_varchar2) then
478: If (p_rec.attribute10 = hr_api.g_varchar2) then
479: p_rec.attribute10 :=
480: irc_cmp_shd.g_old_rec.attribute10;
481: End If;
482: If (p_rec.information_category = hr_api.g_varchar2) then
483: p_rec.information_category :=
484: irc_cmp_shd.g_old_rec.information_category;
485: End If;
486: If (p_rec.information1 = hr_api.g_varchar2) then
482: If (p_rec.information_category = hr_api.g_varchar2) then
483: p_rec.information_category :=
484: irc_cmp_shd.g_old_rec.information_category;
485: End If;
486: If (p_rec.information1 = hr_api.g_varchar2) then
487: p_rec.information1 :=
488: irc_cmp_shd.g_old_rec.information1;
489: End If;
490: If (p_rec.information2 = hr_api.g_varchar2) then
486: If (p_rec.information1 = hr_api.g_varchar2) then
487: p_rec.information1 :=
488: irc_cmp_shd.g_old_rec.information1;
489: End If;
490: If (p_rec.information2 = hr_api.g_varchar2) then
491: p_rec.information2 :=
492: irc_cmp_shd.g_old_rec.information2;
493: End If;
494: If (p_rec.information3 = hr_api.g_varchar2) then
490: If (p_rec.information2 = hr_api.g_varchar2) then
491: p_rec.information2 :=
492: irc_cmp_shd.g_old_rec.information2;
493: End If;
494: If (p_rec.information3 = hr_api.g_varchar2) then
495: p_rec.information3 :=
496: irc_cmp_shd.g_old_rec.information3;
497: End If;
498: If (p_rec.information4 = hr_api.g_varchar2) then
494: If (p_rec.information3 = hr_api.g_varchar2) then
495: p_rec.information3 :=
496: irc_cmp_shd.g_old_rec.information3;
497: End If;
498: If (p_rec.information4 = hr_api.g_varchar2) then
499: p_rec.information4 :=
500: irc_cmp_shd.g_old_rec.information4;
501: End If;
502: If (p_rec.information5 = hr_api.g_varchar2) then
498: If (p_rec.information4 = hr_api.g_varchar2) then
499: p_rec.information4 :=
500: irc_cmp_shd.g_old_rec.information4;
501: End If;
502: If (p_rec.information5 = hr_api.g_varchar2) then
503: p_rec.information5 :=
504: irc_cmp_shd.g_old_rec.information5;
505: End If;
506: If (p_rec.information6 = hr_api.g_varchar2) then
502: If (p_rec.information5 = hr_api.g_varchar2) then
503: p_rec.information5 :=
504: irc_cmp_shd.g_old_rec.information5;
505: End If;
506: If (p_rec.information6 = hr_api.g_varchar2) then
507: p_rec.information6 :=
508: irc_cmp_shd.g_old_rec.information6;
509: End If;
510: If (p_rec.information7 = hr_api.g_varchar2) then
506: If (p_rec.information6 = hr_api.g_varchar2) then
507: p_rec.information6 :=
508: irc_cmp_shd.g_old_rec.information6;
509: End If;
510: If (p_rec.information7 = hr_api.g_varchar2) then
511: p_rec.information7 :=
512: irc_cmp_shd.g_old_rec.information7;
513: End If;
514: If (p_rec.information8 = hr_api.g_varchar2) then
510: If (p_rec.information7 = hr_api.g_varchar2) then
511: p_rec.information7 :=
512: irc_cmp_shd.g_old_rec.information7;
513: End If;
514: If (p_rec.information8 = hr_api.g_varchar2) then
515: p_rec.information8 :=
516: irc_cmp_shd.g_old_rec.information8;
517: End If;
518: If (p_rec.information9 = hr_api.g_varchar2) then
514: If (p_rec.information8 = hr_api.g_varchar2) then
515: p_rec.information8 :=
516: irc_cmp_shd.g_old_rec.information8;
517: End If;
518: If (p_rec.information9 = hr_api.g_varchar2) then
519: p_rec.information9 :=
520: irc_cmp_shd.g_old_rec.information9;
521: End If;
522: If (p_rec.information10 = hr_api.g_varchar2) then
518: If (p_rec.information9 = hr_api.g_varchar2) then
519: p_rec.information9 :=
520: irc_cmp_shd.g_old_rec.information9;
521: End If;
522: If (p_rec.information10 = hr_api.g_varchar2) then
523: p_rec.information10 :=
524: irc_cmp_shd.g_old_rec.information10;
525: End If;
526: --
586: Procedure upd
587: (p_effective_date in date
588: ,p_communication_property_id in number
589: ,p_object_version_number in out nocopy number
590: ,p_object_type in varchar2 default hr_api.g_varchar2
591: ,p_object_id in number default hr_api.g_number
592: ,p_default_comm_status in varchar2 default hr_api.g_varchar2
593: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
594: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
587: (p_effective_date in date
588: ,p_communication_property_id in number
589: ,p_object_version_number in out nocopy number
590: ,p_object_type in varchar2 default hr_api.g_varchar2
591: ,p_object_id in number default hr_api.g_number
592: ,p_default_comm_status in varchar2 default hr_api.g_varchar2
593: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
594: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
595: ,p_allow_add_recipients in varchar2 default hr_api.g_varchar2
588: ,p_communication_property_id in number
589: ,p_object_version_number in out nocopy number
590: ,p_object_type in varchar2 default hr_api.g_varchar2
591: ,p_object_id in number default hr_api.g_number
592: ,p_default_comm_status in varchar2 default hr_api.g_varchar2
593: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
594: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
595: ,p_allow_add_recipients in varchar2 default hr_api.g_varchar2
596: ,p_default_moderator in varchar2 default hr_api.g_varchar2
589: ,p_object_version_number in out nocopy number
590: ,p_object_type in varchar2 default hr_api.g_varchar2
591: ,p_object_id in number default hr_api.g_number
592: ,p_default_comm_status in varchar2 default hr_api.g_varchar2
593: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
594: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
595: ,p_allow_add_recipients in varchar2 default hr_api.g_varchar2
596: ,p_default_moderator in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
590: ,p_object_type in varchar2 default hr_api.g_varchar2
591: ,p_object_id in number default hr_api.g_number
592: ,p_default_comm_status in varchar2 default hr_api.g_varchar2
593: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
594: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
595: ,p_allow_add_recipients in varchar2 default hr_api.g_varchar2
596: ,p_default_moderator in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
591: ,p_object_id in number default hr_api.g_number
592: ,p_default_comm_status in varchar2 default hr_api.g_varchar2
593: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
594: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
595: ,p_allow_add_recipients in varchar2 default hr_api.g_varchar2
596: ,p_default_moderator in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
592: ,p_default_comm_status in varchar2 default hr_api.g_varchar2
593: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
594: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
595: ,p_allow_add_recipients in varchar2 default hr_api.g_varchar2
596: ,p_default_moderator in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
593: ,p_allow_attachment_flag in varchar2 default hr_api.g_varchar2
594: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
595: ,p_allow_add_recipients in varchar2 default hr_api.g_varchar2
596: ,p_default_moderator in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
594: ,p_auto_notification_flag in varchar2 default hr_api.g_varchar2
595: ,p_allow_add_recipients in varchar2 default hr_api.g_varchar2
596: ,p_default_moderator in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
595: ,p_allow_add_recipients in varchar2 default hr_api.g_varchar2
596: ,p_default_moderator in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
596: ,p_default_moderator in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_information_category in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_information_category in varchar2 default hr_api.g_varchar2
609: ,p_information1 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_information_category in varchar2 default hr_api.g_varchar2
609: ,p_information1 in varchar2 default hr_api.g_varchar2
610: ,p_information2 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_information_category in varchar2 default hr_api.g_varchar2
609: ,p_information1 in varchar2 default hr_api.g_varchar2
610: ,p_information2 in varchar2 default hr_api.g_varchar2
611: ,p_information3 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_information_category in varchar2 default hr_api.g_varchar2
609: ,p_information1 in varchar2 default hr_api.g_varchar2
610: ,p_information2 in varchar2 default hr_api.g_varchar2
611: ,p_information3 in varchar2 default hr_api.g_varchar2
612: ,p_information4 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_information_category in varchar2 default hr_api.g_varchar2
609: ,p_information1 in varchar2 default hr_api.g_varchar2
610: ,p_information2 in varchar2 default hr_api.g_varchar2
611: ,p_information3 in varchar2 default hr_api.g_varchar2
612: ,p_information4 in varchar2 default hr_api.g_varchar2
613: ,p_information5 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_information_category in varchar2 default hr_api.g_varchar2
609: ,p_information1 in varchar2 default hr_api.g_varchar2
610: ,p_information2 in varchar2 default hr_api.g_varchar2
611: ,p_information3 in varchar2 default hr_api.g_varchar2
612: ,p_information4 in varchar2 default hr_api.g_varchar2
613: ,p_information5 in varchar2 default hr_api.g_varchar2
614: ,p_information6 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_information_category in varchar2 default hr_api.g_varchar2
609: ,p_information1 in varchar2 default hr_api.g_varchar2
610: ,p_information2 in varchar2 default hr_api.g_varchar2
611: ,p_information3 in varchar2 default hr_api.g_varchar2
612: ,p_information4 in varchar2 default hr_api.g_varchar2
613: ,p_information5 in varchar2 default hr_api.g_varchar2
614: ,p_information6 in varchar2 default hr_api.g_varchar2
615: ,p_information7 in varchar2 default hr_api.g_varchar2
608: ,p_information_category in varchar2 default hr_api.g_varchar2
609: ,p_information1 in varchar2 default hr_api.g_varchar2
610: ,p_information2 in varchar2 default hr_api.g_varchar2
611: ,p_information3 in varchar2 default hr_api.g_varchar2
612: ,p_information4 in varchar2 default hr_api.g_varchar2
613: ,p_information5 in varchar2 default hr_api.g_varchar2
614: ,p_information6 in varchar2 default hr_api.g_varchar2
615: ,p_information7 in varchar2 default hr_api.g_varchar2
616: ,p_information8 in varchar2 default hr_api.g_varchar2
609: ,p_information1 in varchar2 default hr_api.g_varchar2
610: ,p_information2 in varchar2 default hr_api.g_varchar2
611: ,p_information3 in varchar2 default hr_api.g_varchar2
612: ,p_information4 in varchar2 default hr_api.g_varchar2
613: ,p_information5 in varchar2 default hr_api.g_varchar2
614: ,p_information6 in varchar2 default hr_api.g_varchar2
615: ,p_information7 in varchar2 default hr_api.g_varchar2
616: ,p_information8 in varchar2 default hr_api.g_varchar2
617: ,p_information9 in varchar2 default hr_api.g_varchar2
610: ,p_information2 in varchar2 default hr_api.g_varchar2
611: ,p_information3 in varchar2 default hr_api.g_varchar2
612: ,p_information4 in varchar2 default hr_api.g_varchar2
613: ,p_information5 in varchar2 default hr_api.g_varchar2
614: ,p_information6 in varchar2 default hr_api.g_varchar2
615: ,p_information7 in varchar2 default hr_api.g_varchar2
616: ,p_information8 in varchar2 default hr_api.g_varchar2
617: ,p_information9 in varchar2 default hr_api.g_varchar2
618: ,p_information10 in varchar2 default hr_api.g_varchar2
611: ,p_information3 in varchar2 default hr_api.g_varchar2
612: ,p_information4 in varchar2 default hr_api.g_varchar2
613: ,p_information5 in varchar2 default hr_api.g_varchar2
614: ,p_information6 in varchar2 default hr_api.g_varchar2
615: ,p_information7 in varchar2 default hr_api.g_varchar2
616: ,p_information8 in varchar2 default hr_api.g_varchar2
617: ,p_information9 in varchar2 default hr_api.g_varchar2
618: ,p_information10 in varchar2 default hr_api.g_varchar2
619: ) is
612: ,p_information4 in varchar2 default hr_api.g_varchar2
613: ,p_information5 in varchar2 default hr_api.g_varchar2
614: ,p_information6 in varchar2 default hr_api.g_varchar2
615: ,p_information7 in varchar2 default hr_api.g_varchar2
616: ,p_information8 in varchar2 default hr_api.g_varchar2
617: ,p_information9 in varchar2 default hr_api.g_varchar2
618: ,p_information10 in varchar2 default hr_api.g_varchar2
619: ) is
620: --
613: ,p_information5 in varchar2 default hr_api.g_varchar2
614: ,p_information6 in varchar2 default hr_api.g_varchar2
615: ,p_information7 in varchar2 default hr_api.g_varchar2
616: ,p_information8 in varchar2 default hr_api.g_varchar2
617: ,p_information9 in varchar2 default hr_api.g_varchar2
618: ,p_information10 in varchar2 default hr_api.g_varchar2
619: ) is
620: --
621: l_rec irc_cmp_shd.g_rec_type;
614: ,p_information6 in varchar2 default hr_api.g_varchar2
615: ,p_information7 in varchar2 default hr_api.g_varchar2
616: ,p_information8 in varchar2 default hr_api.g_varchar2
617: ,p_information9 in varchar2 default hr_api.g_varchar2
618: ,p_information10 in varchar2 default hr_api.g_varchar2
619: ) is
620: --
621: l_rec irc_cmp_shd.g_rec_type;
622: l_proc varchar2(72) := g_package||'upd';