119: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
120: hr_utility.set_location(' Leaving:'||l_proc, 10);
121: --
122: Exception
123: When hr_api.check_integrity_violated Then
124: -- A check constraint has been violated
125: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
126: --
127: irc_rse_shd.constraint_error
124: -- A check constraint has been violated
125: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
126: --
127: irc_rse_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
132: --
125: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
126: --
127: irc_rse_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
132: --
133: irc_rse_shd.constraint_error
130: -- Parent integrity has been violated
131: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
132: --
133: irc_rse_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
138: --
131: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
132: --
133: irc_rse_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
138: --
139: irc_rse_shd.constraint_error
136: -- Unique integrity has been violated
137: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
138: --
139: irc_rse_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
143: --
144: Raise;
414: );
415: --
416: exception
417: --
418: when hr_api.cannot_find_prog_unit then
419: --
420: hr_api.cannot_find_prog_unit_error
421: (p_module_name => 'IRC_ALL_RECRUITING_SITES'
422: ,p_hook_type => 'AU');
416: exception
417: --
418: when hr_api.cannot_find_prog_unit then
419: --
420: hr_api.cannot_find_prog_unit_error
421: (p_module_name => 'IRC_ALL_RECRUITING_SITES'
422: ,p_hook_type => 'AU');
423: --
424: end;
481: -- p_rec plsql record structure
482: -- to see if a system default is being used. If a system default
483: -- is being used then we must set to the 'current' argument value.
484: --
485: If (p_rec.date_from = hr_api.g_date) then
486: p_rec.date_from :=
487: irc_rse_shd.g_old_rec.date_from;
488: End If;
489: If (p_rec.date_to = hr_api.g_date) then
485: If (p_rec.date_from = hr_api.g_date) then
486: p_rec.date_from :=
487: irc_rse_shd.g_old_rec.date_from;
488: End If;
489: If (p_rec.date_to = hr_api.g_date) then
490: p_rec.date_to :=
491: irc_rse_shd.g_old_rec.date_to;
492: End If;
493: If (p_rec.posting_username = hr_api.g_varchar2) then
489: If (p_rec.date_to = hr_api.g_date) then
490: p_rec.date_to :=
491: irc_rse_shd.g_old_rec.date_to;
492: End If;
493: If (p_rec.posting_username = hr_api.g_varchar2) then
494: p_rec.posting_username :=
495: irc_rse_shd.g_old_rec.posting_username;
496: End If;
497: If (p_rec.posting_password = hr_api.g_varchar2) then
493: If (p_rec.posting_username = hr_api.g_varchar2) then
494: p_rec.posting_username :=
495: irc_rse_shd.g_old_rec.posting_username;
496: End If;
497: If (p_rec.posting_password = hr_api.g_varchar2) then
498: p_rec.posting_password :=
499: irc_rse_shd.g_old_rec.posting_password;
500: End If;
501: If (p_rec.internal = hr_api.g_varchar2) then
497: If (p_rec.posting_password = hr_api.g_varchar2) then
498: p_rec.posting_password :=
499: irc_rse_shd.g_old_rec.posting_password;
500: End If;
501: If (p_rec.internal = hr_api.g_varchar2) then
502: p_rec.internal :=
503: irc_rse_shd.g_old_rec.internal;
504: End If;
505: If (p_rec.external = hr_api.g_varchar2) then
501: If (p_rec.internal = hr_api.g_varchar2) then
502: p_rec.internal :=
503: irc_rse_shd.g_old_rec.internal;
504: End If;
505: If (p_rec.external = hr_api.g_varchar2) then
506: p_rec.external :=
507: irc_rse_shd.g_old_rec.external;
508: End If;
509: If (p_rec.third_party = hr_api.g_varchar2) then
505: If (p_rec.external = hr_api.g_varchar2) then
506: p_rec.external :=
507: irc_rse_shd.g_old_rec.external;
508: End If;
509: If (p_rec.third_party = hr_api.g_varchar2) then
510: p_rec.third_party :=
511: irc_rse_shd.g_old_rec.third_party;
512: End If;
513: If (p_rec.posting_cost = hr_api.g_number) then
509: If (p_rec.third_party = hr_api.g_varchar2) then
510: p_rec.third_party :=
511: irc_rse_shd.g_old_rec.third_party;
512: End If;
513: If (p_rec.posting_cost = hr_api.g_number) then
514: p_rec.posting_cost :=
515: irc_rse_shd.g_old_rec.posting_cost;
516: End If;
517: If (p_rec.posting_cost_period = hr_api.g_varchar2) then
513: If (p_rec.posting_cost = hr_api.g_number) then
514: p_rec.posting_cost :=
515: irc_rse_shd.g_old_rec.posting_cost;
516: End If;
517: If (p_rec.posting_cost_period = hr_api.g_varchar2) then
518: p_rec.posting_cost_period :=
519: irc_rse_shd.g_old_rec.posting_cost_period;
520: End If;
521: If (p_rec.posting_cost_currency = hr_api.g_varchar2) then
517: If (p_rec.posting_cost_period = hr_api.g_varchar2) then
518: p_rec.posting_cost_period :=
519: irc_rse_shd.g_old_rec.posting_cost_period;
520: End If;
521: If (p_rec.posting_cost_currency = hr_api.g_varchar2) then
522: p_rec.posting_cost_currency :=
523: irc_rse_shd.g_old_rec.posting_cost_currency;
524: End If;
525: If (p_rec.stylesheet = hr_api.g_varchar2) then
521: If (p_rec.posting_cost_currency = hr_api.g_varchar2) then
522: p_rec.posting_cost_currency :=
523: irc_rse_shd.g_old_rec.posting_cost_currency;
524: End If;
525: If (p_rec.stylesheet = hr_api.g_varchar2) then
526: p_rec.stylesheet :=
527: irc_rse_shd.g_old_rec.stylesheet;
528: End If;
529: If (p_rec.attribute_category = hr_api.g_varchar2) then
525: If (p_rec.stylesheet = hr_api.g_varchar2) then
526: p_rec.stylesheet :=
527: irc_rse_shd.g_old_rec.stylesheet;
528: End If;
529: If (p_rec.attribute_category = hr_api.g_varchar2) then
530: p_rec.attribute_category :=
531: irc_rse_shd.g_old_rec.attribute_category;
532: End If;
533: If (p_rec.attribute1 = hr_api.g_varchar2) then
529: If (p_rec.attribute_category = hr_api.g_varchar2) then
530: p_rec.attribute_category :=
531: irc_rse_shd.g_old_rec.attribute_category;
532: End If;
533: If (p_rec.attribute1 = hr_api.g_varchar2) then
534: p_rec.attribute1 :=
535: irc_rse_shd.g_old_rec.attribute1;
536: End If;
537: If (p_rec.attribute2 = hr_api.g_varchar2) then
533: If (p_rec.attribute1 = hr_api.g_varchar2) then
534: p_rec.attribute1 :=
535: irc_rse_shd.g_old_rec.attribute1;
536: End If;
537: If (p_rec.attribute2 = hr_api.g_varchar2) then
538: p_rec.attribute2 :=
539: irc_rse_shd.g_old_rec.attribute2;
540: End If;
541: If (p_rec.attribute3 = hr_api.g_varchar2) then
537: If (p_rec.attribute2 = hr_api.g_varchar2) then
538: p_rec.attribute2 :=
539: irc_rse_shd.g_old_rec.attribute2;
540: End If;
541: If (p_rec.attribute3 = hr_api.g_varchar2) then
542: p_rec.attribute3 :=
543: irc_rse_shd.g_old_rec.attribute3;
544: End If;
545: If (p_rec.attribute4 = hr_api.g_varchar2) then
541: If (p_rec.attribute3 = hr_api.g_varchar2) then
542: p_rec.attribute3 :=
543: irc_rse_shd.g_old_rec.attribute3;
544: End If;
545: If (p_rec.attribute4 = hr_api.g_varchar2) then
546: p_rec.attribute4 :=
547: irc_rse_shd.g_old_rec.attribute4;
548: End If;
549: If (p_rec.attribute5 = hr_api.g_varchar2) then
545: If (p_rec.attribute4 = hr_api.g_varchar2) then
546: p_rec.attribute4 :=
547: irc_rse_shd.g_old_rec.attribute4;
548: End If;
549: If (p_rec.attribute5 = hr_api.g_varchar2) then
550: p_rec.attribute5 :=
551: irc_rse_shd.g_old_rec.attribute5;
552: End If;
553: If (p_rec.attribute6 = hr_api.g_varchar2) then
549: If (p_rec.attribute5 = hr_api.g_varchar2) then
550: p_rec.attribute5 :=
551: irc_rse_shd.g_old_rec.attribute5;
552: End If;
553: If (p_rec.attribute6 = hr_api.g_varchar2) then
554: p_rec.attribute6 :=
555: irc_rse_shd.g_old_rec.attribute6;
556: End If;
557: If (p_rec.attribute7 = hr_api.g_varchar2) then
553: If (p_rec.attribute6 = hr_api.g_varchar2) then
554: p_rec.attribute6 :=
555: irc_rse_shd.g_old_rec.attribute6;
556: End If;
557: If (p_rec.attribute7 = hr_api.g_varchar2) then
558: p_rec.attribute7 :=
559: irc_rse_shd.g_old_rec.attribute7;
560: End If;
561: If (p_rec.attribute8 = hr_api.g_varchar2) then
557: If (p_rec.attribute7 = hr_api.g_varchar2) then
558: p_rec.attribute7 :=
559: irc_rse_shd.g_old_rec.attribute7;
560: End If;
561: If (p_rec.attribute8 = hr_api.g_varchar2) then
562: p_rec.attribute8 :=
563: irc_rse_shd.g_old_rec.attribute8;
564: End If;
565: If (p_rec.attribute9 = hr_api.g_varchar2) then
561: If (p_rec.attribute8 = hr_api.g_varchar2) then
562: p_rec.attribute8 :=
563: irc_rse_shd.g_old_rec.attribute8;
564: End If;
565: If (p_rec.attribute9 = hr_api.g_varchar2) then
566: p_rec.attribute9 :=
567: irc_rse_shd.g_old_rec.attribute9;
568: End If;
569: If (p_rec.attribute10 = hr_api.g_varchar2) then
565: If (p_rec.attribute9 = hr_api.g_varchar2) then
566: p_rec.attribute9 :=
567: irc_rse_shd.g_old_rec.attribute9;
568: End If;
569: If (p_rec.attribute10 = hr_api.g_varchar2) then
570: p_rec.attribute10 :=
571: irc_rse_shd.g_old_rec.attribute10;
572: End If;
573: If (p_rec.attribute11 = hr_api.g_varchar2) then
569: If (p_rec.attribute10 = hr_api.g_varchar2) then
570: p_rec.attribute10 :=
571: irc_rse_shd.g_old_rec.attribute10;
572: End If;
573: If (p_rec.attribute11 = hr_api.g_varchar2) then
574: p_rec.attribute11 :=
575: irc_rse_shd.g_old_rec.attribute11;
576: End If;
577: If (p_rec.attribute12 = hr_api.g_varchar2) then
573: If (p_rec.attribute11 = hr_api.g_varchar2) then
574: p_rec.attribute11 :=
575: irc_rse_shd.g_old_rec.attribute11;
576: End If;
577: If (p_rec.attribute12 = hr_api.g_varchar2) then
578: p_rec.attribute12 :=
579: irc_rse_shd.g_old_rec.attribute12;
580: End If;
581: If (p_rec.attribute13 = hr_api.g_varchar2) then
577: If (p_rec.attribute12 = hr_api.g_varchar2) then
578: p_rec.attribute12 :=
579: irc_rse_shd.g_old_rec.attribute12;
580: End If;
581: If (p_rec.attribute13 = hr_api.g_varchar2) then
582: p_rec.attribute13 :=
583: irc_rse_shd.g_old_rec.attribute13;
584: End If;
585: If (p_rec.attribute14 = hr_api.g_varchar2) then
581: If (p_rec.attribute13 = hr_api.g_varchar2) then
582: p_rec.attribute13 :=
583: irc_rse_shd.g_old_rec.attribute13;
584: End If;
585: If (p_rec.attribute14 = hr_api.g_varchar2) then
586: p_rec.attribute14 :=
587: irc_rse_shd.g_old_rec.attribute14;
588: End If;
589: If (p_rec.attribute15 = hr_api.g_varchar2) then
585: If (p_rec.attribute14 = hr_api.g_varchar2) then
586: p_rec.attribute14 :=
587: irc_rse_shd.g_old_rec.attribute14;
588: End If;
589: If (p_rec.attribute15 = hr_api.g_varchar2) then
590: p_rec.attribute15 :=
591: irc_rse_shd.g_old_rec.attribute15;
592: End If;
593: If (p_rec.attribute16 = hr_api.g_varchar2) then
589: If (p_rec.attribute15 = hr_api.g_varchar2) then
590: p_rec.attribute15 :=
591: irc_rse_shd.g_old_rec.attribute15;
592: End If;
593: If (p_rec.attribute16 = hr_api.g_varchar2) then
594: p_rec.attribute16 :=
595: irc_rse_shd.g_old_rec.attribute16;
596: End If;
597: If (p_rec.attribute17 = hr_api.g_varchar2) then
593: If (p_rec.attribute16 = hr_api.g_varchar2) then
594: p_rec.attribute16 :=
595: irc_rse_shd.g_old_rec.attribute16;
596: End If;
597: If (p_rec.attribute17 = hr_api.g_varchar2) then
598: p_rec.attribute17 :=
599: irc_rse_shd.g_old_rec.attribute17;
600: End If;
601: If (p_rec.attribute18 = hr_api.g_varchar2) then
597: If (p_rec.attribute17 = hr_api.g_varchar2) then
598: p_rec.attribute17 :=
599: irc_rse_shd.g_old_rec.attribute17;
600: End If;
601: If (p_rec.attribute18 = hr_api.g_varchar2) then
602: p_rec.attribute18 :=
603: irc_rse_shd.g_old_rec.attribute18;
604: End If;
605: If (p_rec.attribute19 = hr_api.g_varchar2) then
601: If (p_rec.attribute18 = hr_api.g_varchar2) then
602: p_rec.attribute18 :=
603: irc_rse_shd.g_old_rec.attribute18;
604: End If;
605: If (p_rec.attribute19 = hr_api.g_varchar2) then
606: p_rec.attribute19 :=
607: irc_rse_shd.g_old_rec.attribute19;
608: End If;
609: If (p_rec.attribute20 = hr_api.g_varchar2) then
605: If (p_rec.attribute19 = hr_api.g_varchar2) then
606: p_rec.attribute19 :=
607: irc_rse_shd.g_old_rec.attribute19;
608: End If;
609: If (p_rec.attribute20 = hr_api.g_varchar2) then
610: p_rec.attribute20 :=
611: irc_rse_shd.g_old_rec.attribute20;
612: End If;
613: If (p_rec.attribute21 = hr_api.g_varchar2) then
609: If (p_rec.attribute20 = hr_api.g_varchar2) then
610: p_rec.attribute20 :=
611: irc_rse_shd.g_old_rec.attribute20;
612: End If;
613: If (p_rec.attribute21 = hr_api.g_varchar2) then
614: p_rec.attribute21 :=
615: irc_rse_shd.g_old_rec.attribute21;
616: End If;
617: If (p_rec.attribute22 = hr_api.g_varchar2) then
613: If (p_rec.attribute21 = hr_api.g_varchar2) then
614: p_rec.attribute21 :=
615: irc_rse_shd.g_old_rec.attribute21;
616: End If;
617: If (p_rec.attribute22 = hr_api.g_varchar2) then
618: p_rec.attribute22 :=
619: irc_rse_shd.g_old_rec.attribute22;
620: End If;
621: If (p_rec.attribute23 = hr_api.g_varchar2) then
617: If (p_rec.attribute22 = hr_api.g_varchar2) then
618: p_rec.attribute22 :=
619: irc_rse_shd.g_old_rec.attribute22;
620: End If;
621: If (p_rec.attribute23 = hr_api.g_varchar2) then
622: p_rec.attribute23 :=
623: irc_rse_shd.g_old_rec.attribute23;
624: End If;
625: If (p_rec.attribute24 = hr_api.g_varchar2) then
621: If (p_rec.attribute23 = hr_api.g_varchar2) then
622: p_rec.attribute23 :=
623: irc_rse_shd.g_old_rec.attribute23;
624: End If;
625: If (p_rec.attribute24 = hr_api.g_varchar2) then
626: p_rec.attribute24 :=
627: irc_rse_shd.g_old_rec.attribute24;
628: End If;
629: If (p_rec.attribute25 = hr_api.g_varchar2) then
625: If (p_rec.attribute24 = hr_api.g_varchar2) then
626: p_rec.attribute24 :=
627: irc_rse_shd.g_old_rec.attribute24;
628: End If;
629: If (p_rec.attribute25 = hr_api.g_varchar2) then
630: p_rec.attribute25 :=
631: irc_rse_shd.g_old_rec.attribute25;
632: End If;
633: If (p_rec.attribute26 = hr_api.g_varchar2) then
629: If (p_rec.attribute25 = hr_api.g_varchar2) then
630: p_rec.attribute25 :=
631: irc_rse_shd.g_old_rec.attribute25;
632: End If;
633: If (p_rec.attribute26 = hr_api.g_varchar2) then
634: p_rec.attribute26 :=
635: irc_rse_shd.g_old_rec.attribute26;
636: End If;
637: If (p_rec.attribute27 = hr_api.g_varchar2) then
633: If (p_rec.attribute26 = hr_api.g_varchar2) then
634: p_rec.attribute26 :=
635: irc_rse_shd.g_old_rec.attribute26;
636: End If;
637: If (p_rec.attribute27 = hr_api.g_varchar2) then
638: p_rec.attribute27 :=
639: irc_rse_shd.g_old_rec.attribute27;
640: End If;
641: If (p_rec.attribute28 = hr_api.g_varchar2) then
637: If (p_rec.attribute27 = hr_api.g_varchar2) then
638: p_rec.attribute27 :=
639: irc_rse_shd.g_old_rec.attribute27;
640: End If;
641: If (p_rec.attribute28 = hr_api.g_varchar2) then
642: p_rec.attribute28 :=
643: irc_rse_shd.g_old_rec.attribute28;
644: End If;
645: If (p_rec.attribute29 = hr_api.g_varchar2) then
641: If (p_rec.attribute28 = hr_api.g_varchar2) then
642: p_rec.attribute28 :=
643: irc_rse_shd.g_old_rec.attribute28;
644: End If;
645: If (p_rec.attribute29 = hr_api.g_varchar2) then
646: p_rec.attribute29 :=
647: irc_rse_shd.g_old_rec.attribute29;
648: End If;
649: If (p_rec.attribute30 = hr_api.g_varchar2) then
645: If (p_rec.attribute29 = hr_api.g_varchar2) then
646: p_rec.attribute29 :=
647: irc_rse_shd.g_old_rec.attribute29;
648: End If;
649: If (p_rec.attribute30 = hr_api.g_varchar2) then
650: p_rec.attribute30 :=
651: irc_rse_shd.g_old_rec.attribute30;
652: End If;
653: If (p_rec.internal_name = hr_api.g_varchar2) then
649: If (p_rec.attribute30 = hr_api.g_varchar2) then
650: p_rec.attribute30 :=
651: irc_rse_shd.g_old_rec.attribute30;
652: End If;
653: If (p_rec.internal_name = hr_api.g_varchar2) then
654: p_rec.internal_name :=
655: irc_rse_shd.g_old_rec.internal_name;
656: End If;
657: --
718: Procedure upd
719: (p_effective_date in date
720: ,p_recruiting_site_id in number
721: ,p_object_version_number in out nocopy number
722: ,p_date_from in date default hr_api.g_date
723: ,p_date_to in date default hr_api.g_date
724: ,p_posting_username in varchar2 default hr_api.g_varchar2
725: ,p_posting_password in varchar2 default hr_api.g_varchar2
726: ,p_internal in varchar2 default hr_api.g_varchar2
719: (p_effective_date in date
720: ,p_recruiting_site_id in number
721: ,p_object_version_number in out nocopy number
722: ,p_date_from in date default hr_api.g_date
723: ,p_date_to in date default hr_api.g_date
724: ,p_posting_username in varchar2 default hr_api.g_varchar2
725: ,p_posting_password in varchar2 default hr_api.g_varchar2
726: ,p_internal in varchar2 default hr_api.g_varchar2
727: ,p_external in varchar2 default hr_api.g_varchar2
720: ,p_recruiting_site_id in number
721: ,p_object_version_number in out nocopy number
722: ,p_date_from in date default hr_api.g_date
723: ,p_date_to in date default hr_api.g_date
724: ,p_posting_username in varchar2 default hr_api.g_varchar2
725: ,p_posting_password in varchar2 default hr_api.g_varchar2
726: ,p_internal in varchar2 default hr_api.g_varchar2
727: ,p_external in varchar2 default hr_api.g_varchar2
728: ,p_third_party in varchar2 default hr_api.g_varchar2
721: ,p_object_version_number in out nocopy number
722: ,p_date_from in date default hr_api.g_date
723: ,p_date_to in date default hr_api.g_date
724: ,p_posting_username in varchar2 default hr_api.g_varchar2
725: ,p_posting_password in varchar2 default hr_api.g_varchar2
726: ,p_internal in varchar2 default hr_api.g_varchar2
727: ,p_external in varchar2 default hr_api.g_varchar2
728: ,p_third_party in varchar2 default hr_api.g_varchar2
729: ,p_posting_cost in number default hr_api.g_number
722: ,p_date_from in date default hr_api.g_date
723: ,p_date_to in date default hr_api.g_date
724: ,p_posting_username in varchar2 default hr_api.g_varchar2
725: ,p_posting_password in varchar2 default hr_api.g_varchar2
726: ,p_internal in varchar2 default hr_api.g_varchar2
727: ,p_external in varchar2 default hr_api.g_varchar2
728: ,p_third_party in varchar2 default hr_api.g_varchar2
729: ,p_posting_cost in number default hr_api.g_number
730: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
723: ,p_date_to in date default hr_api.g_date
724: ,p_posting_username in varchar2 default hr_api.g_varchar2
725: ,p_posting_password in varchar2 default hr_api.g_varchar2
726: ,p_internal in varchar2 default hr_api.g_varchar2
727: ,p_external in varchar2 default hr_api.g_varchar2
728: ,p_third_party in varchar2 default hr_api.g_varchar2
729: ,p_posting_cost in number default hr_api.g_number
730: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
731: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
724: ,p_posting_username in varchar2 default hr_api.g_varchar2
725: ,p_posting_password in varchar2 default hr_api.g_varchar2
726: ,p_internal in varchar2 default hr_api.g_varchar2
727: ,p_external in varchar2 default hr_api.g_varchar2
728: ,p_third_party in varchar2 default hr_api.g_varchar2
729: ,p_posting_cost in number default hr_api.g_number
730: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
731: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
732: ,p_stylesheet in varchar2 default hr_api.g_varchar2
725: ,p_posting_password in varchar2 default hr_api.g_varchar2
726: ,p_internal in varchar2 default hr_api.g_varchar2
727: ,p_external in varchar2 default hr_api.g_varchar2
728: ,p_third_party in varchar2 default hr_api.g_varchar2
729: ,p_posting_cost in number default hr_api.g_number
730: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
731: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
732: ,p_stylesheet in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
726: ,p_internal in varchar2 default hr_api.g_varchar2
727: ,p_external in varchar2 default hr_api.g_varchar2
728: ,p_third_party in varchar2 default hr_api.g_varchar2
729: ,p_posting_cost in number default hr_api.g_number
730: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
731: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
732: ,p_stylesheet in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
727: ,p_external in varchar2 default hr_api.g_varchar2
728: ,p_third_party in varchar2 default hr_api.g_varchar2
729: ,p_posting_cost in number default hr_api.g_number
730: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
731: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
732: ,p_stylesheet in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
728: ,p_third_party in varchar2 default hr_api.g_varchar2
729: ,p_posting_cost in number default hr_api.g_number
730: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
731: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
732: ,p_stylesheet in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
729: ,p_posting_cost in number default hr_api.g_number
730: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
731: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
732: ,p_stylesheet in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
730: ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
731: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
732: ,p_stylesheet in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
731: ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
732: ,p_stylesheet in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
732: ,p_stylesheet in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_attribute21 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_attribute21 in varchar2 default hr_api.g_varchar2
755: ,p_attribute22 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_attribute21 in varchar2 default hr_api.g_varchar2
755: ,p_attribute22 in varchar2 default hr_api.g_varchar2
756: ,p_attribute23 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_attribute21 in varchar2 default hr_api.g_varchar2
755: ,p_attribute22 in varchar2 default hr_api.g_varchar2
756: ,p_attribute23 in varchar2 default hr_api.g_varchar2
757: ,p_attribute24 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_attribute21 in varchar2 default hr_api.g_varchar2
755: ,p_attribute22 in varchar2 default hr_api.g_varchar2
756: ,p_attribute23 in varchar2 default hr_api.g_varchar2
757: ,p_attribute24 in varchar2 default hr_api.g_varchar2
758: ,p_attribute25 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_attribute21 in varchar2 default hr_api.g_varchar2
755: ,p_attribute22 in varchar2 default hr_api.g_varchar2
756: ,p_attribute23 in varchar2 default hr_api.g_varchar2
757: ,p_attribute24 in varchar2 default hr_api.g_varchar2
758: ,p_attribute25 in varchar2 default hr_api.g_varchar2
759: ,p_attribute26 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_attribute21 in varchar2 default hr_api.g_varchar2
755: ,p_attribute22 in varchar2 default hr_api.g_varchar2
756: ,p_attribute23 in varchar2 default hr_api.g_varchar2
757: ,p_attribute24 in varchar2 default hr_api.g_varchar2
758: ,p_attribute25 in varchar2 default hr_api.g_varchar2
759: ,p_attribute26 in varchar2 default hr_api.g_varchar2
760: ,p_attribute27 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_attribute21 in varchar2 default hr_api.g_varchar2
755: ,p_attribute22 in varchar2 default hr_api.g_varchar2
756: ,p_attribute23 in varchar2 default hr_api.g_varchar2
757: ,p_attribute24 in varchar2 default hr_api.g_varchar2
758: ,p_attribute25 in varchar2 default hr_api.g_varchar2
759: ,p_attribute26 in varchar2 default hr_api.g_varchar2
760: ,p_attribute27 in varchar2 default hr_api.g_varchar2
761: ,p_attribute28 in varchar2 default hr_api.g_varchar2
754: ,p_attribute21 in varchar2 default hr_api.g_varchar2
755: ,p_attribute22 in varchar2 default hr_api.g_varchar2
756: ,p_attribute23 in varchar2 default hr_api.g_varchar2
757: ,p_attribute24 in varchar2 default hr_api.g_varchar2
758: ,p_attribute25 in varchar2 default hr_api.g_varchar2
759: ,p_attribute26 in varchar2 default hr_api.g_varchar2
760: ,p_attribute27 in varchar2 default hr_api.g_varchar2
761: ,p_attribute28 in varchar2 default hr_api.g_varchar2
762: ,p_attribute29 in varchar2 default hr_api.g_varchar2
755: ,p_attribute22 in varchar2 default hr_api.g_varchar2
756: ,p_attribute23 in varchar2 default hr_api.g_varchar2
757: ,p_attribute24 in varchar2 default hr_api.g_varchar2
758: ,p_attribute25 in varchar2 default hr_api.g_varchar2
759: ,p_attribute26 in varchar2 default hr_api.g_varchar2
760: ,p_attribute27 in varchar2 default hr_api.g_varchar2
761: ,p_attribute28 in varchar2 default hr_api.g_varchar2
762: ,p_attribute29 in varchar2 default hr_api.g_varchar2
763: ,p_attribute30 in varchar2 default hr_api.g_varchar2
756: ,p_attribute23 in varchar2 default hr_api.g_varchar2
757: ,p_attribute24 in varchar2 default hr_api.g_varchar2
758: ,p_attribute25 in varchar2 default hr_api.g_varchar2
759: ,p_attribute26 in varchar2 default hr_api.g_varchar2
760: ,p_attribute27 in varchar2 default hr_api.g_varchar2
761: ,p_attribute28 in varchar2 default hr_api.g_varchar2
762: ,p_attribute29 in varchar2 default hr_api.g_varchar2
763: ,p_attribute30 in varchar2 default hr_api.g_varchar2
764: ,p_internal_name in varchar2 default hr_api.g_varchar2
757: ,p_attribute24 in varchar2 default hr_api.g_varchar2
758: ,p_attribute25 in varchar2 default hr_api.g_varchar2
759: ,p_attribute26 in varchar2 default hr_api.g_varchar2
760: ,p_attribute27 in varchar2 default hr_api.g_varchar2
761: ,p_attribute28 in varchar2 default hr_api.g_varchar2
762: ,p_attribute29 in varchar2 default hr_api.g_varchar2
763: ,p_attribute30 in varchar2 default hr_api.g_varchar2
764: ,p_internal_name in varchar2 default hr_api.g_varchar2
765: ) is
758: ,p_attribute25 in varchar2 default hr_api.g_varchar2
759: ,p_attribute26 in varchar2 default hr_api.g_varchar2
760: ,p_attribute27 in varchar2 default hr_api.g_varchar2
761: ,p_attribute28 in varchar2 default hr_api.g_varchar2
762: ,p_attribute29 in varchar2 default hr_api.g_varchar2
763: ,p_attribute30 in varchar2 default hr_api.g_varchar2
764: ,p_internal_name in varchar2 default hr_api.g_varchar2
765: ) is
766: --
759: ,p_attribute26 in varchar2 default hr_api.g_varchar2
760: ,p_attribute27 in varchar2 default hr_api.g_varchar2
761: ,p_attribute28 in varchar2 default hr_api.g_varchar2
762: ,p_attribute29 in varchar2 default hr_api.g_varchar2
763: ,p_attribute30 in varchar2 default hr_api.g_varchar2
764: ,p_internal_name in varchar2 default hr_api.g_varchar2
765: ) is
766: --
767: l_rec irc_rse_shd.g_rec_type;
760: ,p_attribute27 in varchar2 default hr_api.g_varchar2
761: ,p_attribute28 in varchar2 default hr_api.g_varchar2
762: ,p_attribute29 in varchar2 default hr_api.g_varchar2
763: ,p_attribute30 in varchar2 default hr_api.g_varchar2
764: ,p_internal_name in varchar2 default hr_api.g_varchar2
765: ) is
766: --
767: l_rec irc_rse_shd.g_rec_type;
768: l_proc varchar2(72) := g_package||'upd';