APPS.IRC_CMP_UPD dependencies on HR_API

Line 110: When hr_api.check_integrity_violated Then

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

Line 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

Line 115: When hr_api.parent_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
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 120: When hr_api.unique_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
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 345: when hr_api.cannot_find_prog_unit then

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');

Line 347: hr_api.cannot_find_prog_unit_error

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;

Line 410: If (p_rec.object_type = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 590: ,p_object_type in varchar2 default hr_api.g_varchar2

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

Line 591: ,p_object_id in number default hr_api.g_number

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

Line 592: ,p_default_comm_status 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

Line 593: ,p_allow_attachment_flag 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

Line 594: ,p_auto_notification_flag 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

Line 595: ,p_allow_add_recipients 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

Line 596: ,p_default_moderator 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

Line 597: ,p_attribute_category 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

Line 598: ,p_attribute1 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

Line 599: ,p_attribute2 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

Line 600: ,p_attribute3 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

Line 601: ,p_attribute4 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

Line 602: ,p_attribute5 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

Line 603: ,p_attribute6 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

Line 604: ,p_attribute7 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

Line 605: ,p_attribute8 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

Line 606: ,p_attribute9 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

Line 607: ,p_attribute10 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

Line 608: ,p_information_category 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

Line 609: ,p_information1 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

Line 610: ,p_information2 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

Line 611: ,p_information3 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

Line 612: ,p_information4 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

Line 613: ,p_information5 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

Line 614: ,p_information6 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

Line 615: ,p_information7 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

Line 616: ,p_information8 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
620: --

Line 617: ,p_information9 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: --
621: l_rec irc_cmp_shd.g_rec_type;

Line 618: ,p_information10 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;
622: l_proc varchar2(72) := g_package||'upd';