APPS.IRC_ILP_UPD dependencies on HR_API

Line 118: When hr_api.check_integrity_violated Then

114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: --
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
121: irc_ilp_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
121: irc_ilp_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
126: irc_ilp_shd.constraint_error

Line 123: When hr_api.parent_integrity_violated Then

119: -- A check constraint has been violated
120: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
121: irc_ilp_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
126: irc_ilp_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
126: irc_ilp_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
131: irc_ilp_shd.constraint_error

Line 128: When hr_api.unique_integrity_violated Then

124: -- Parent integrity has been violated
125: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
126: irc_ilp_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
131: irc_ilp_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
131: irc_ilp_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
135: Raise;
136: End update_dml;

Line 385: when hr_api.cannot_find_prog_unit then

381: );
382: --
383: exception
384: --
385: when hr_api.cannot_find_prog_unit then
386: --
387: hr_api.cannot_find_prog_unit_error
388: (p_module_name => 'IRC_LOCATION_PREFERENCES'
389: ,p_hook_type => 'AU');

Line 387: hr_api.cannot_find_prog_unit_error

383: exception
384: --
385: when hr_api.cannot_find_prog_unit then
386: --
387: hr_api.cannot_find_prog_unit_error
388: (p_module_name => 'IRC_LOCATION_PREFERENCES'
389: ,p_hook_type => 'AU');
390: --
391: end;

Line 450: If (p_rec.object_id = hr_api.g_number) then

446: -- p_rec plsql record structure
447: -- to see if a system default is being used. If a system default
448: -- is being used then we must set to the 'current' argument value.
449: --
450: If (p_rec.object_id = hr_api.g_number) then
451: p_rec.object_id :=
452: irc_ilp_shd.g_old_rec.object_id;
453: End If;
454: If (p_rec.object_type = hr_api.g_varchar2) then

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

450: If (p_rec.object_id = hr_api.g_number) then
451: p_rec.object_id :=
452: irc_ilp_shd.g_old_rec.object_id;
453: End If;
454: If (p_rec.object_type = hr_api.g_varchar2) then
455: p_rec.object_type :=
456: irc_ilp_shd.g_old_rec.object_type;
457: End If;
458: If (p_rec.rec_area_id = hr_api.g_number) then

Line 458: If (p_rec.rec_area_id = hr_api.g_number) then

454: If (p_rec.object_type = hr_api.g_varchar2) then
455: p_rec.object_type :=
456: irc_ilp_shd.g_old_rec.object_type;
457: End If;
458: If (p_rec.rec_area_id = hr_api.g_number) then
459: p_rec.rec_area_id :=
460: irc_ilp_shd.g_old_rec.rec_area_id;
461: End If;
462: If (p_rec.business_group_id = hr_api.g_number) then

Line 462: If (p_rec.business_group_id = hr_api.g_number) then

458: If (p_rec.rec_area_id = hr_api.g_number) then
459: p_rec.rec_area_id :=
460: irc_ilp_shd.g_old_rec.rec_area_id;
461: End If;
462: If (p_rec.business_group_id = hr_api.g_number) then
463: p_rec.business_group_id :=
464: irc_ilp_shd.g_old_rec.business_group_id;
465: End If;
466: If (p_rec.country_code = hr_api.g_varchar2) then

Line 466: If (p_rec.country_code = hr_api.g_varchar2) then

462: If (p_rec.business_group_id = hr_api.g_number) then
463: p_rec.business_group_id :=
464: irc_ilp_shd.g_old_rec.business_group_id;
465: End If;
466: If (p_rec.country_code = hr_api.g_varchar2) then
467: p_rec.country_code :=
468: irc_ilp_shd.g_old_rec.country_code;
469: End If;
470: If (p_rec.location_id = hr_api.g_number) then

Line 470: If (p_rec.location_id = hr_api.g_number) then

466: If (p_rec.country_code = hr_api.g_varchar2) then
467: p_rec.country_code :=
468: irc_ilp_shd.g_old_rec.country_code;
469: End If;
470: If (p_rec.location_id = hr_api.g_number) then
471: p_rec.location_id :=
472: irc_ilp_shd.g_old_rec.location_id;
473: End If;
474: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 474: If (p_rec.attribute_category = hr_api.g_varchar2) then

470: If (p_rec.location_id = hr_api.g_number) then
471: p_rec.location_id :=
472: irc_ilp_shd.g_old_rec.location_id;
473: End If;
474: If (p_rec.attribute_category = hr_api.g_varchar2) then
475: p_rec.attribute_category :=
476: irc_ilp_shd.g_old_rec.attribute_category;
477: End If;
478: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 478: If (p_rec.attribute1 = hr_api.g_varchar2) then

474: If (p_rec.attribute_category = hr_api.g_varchar2) then
475: p_rec.attribute_category :=
476: irc_ilp_shd.g_old_rec.attribute_category;
477: End If;
478: If (p_rec.attribute1 = hr_api.g_varchar2) then
479: p_rec.attribute1 :=
480: irc_ilp_shd.g_old_rec.attribute1;
481: End If;
482: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 482: If (p_rec.attribute2 = hr_api.g_varchar2) then

478: If (p_rec.attribute1 = hr_api.g_varchar2) then
479: p_rec.attribute1 :=
480: irc_ilp_shd.g_old_rec.attribute1;
481: End If;
482: If (p_rec.attribute2 = hr_api.g_varchar2) then
483: p_rec.attribute2 :=
484: irc_ilp_shd.g_old_rec.attribute2;
485: End If;
486: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 486: If (p_rec.attribute3 = hr_api.g_varchar2) then

482: If (p_rec.attribute2 = hr_api.g_varchar2) then
483: p_rec.attribute2 :=
484: irc_ilp_shd.g_old_rec.attribute2;
485: End If;
486: If (p_rec.attribute3 = hr_api.g_varchar2) then
487: p_rec.attribute3 :=
488: irc_ilp_shd.g_old_rec.attribute3;
489: End If;
490: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 490: If (p_rec.attribute4 = hr_api.g_varchar2) then

486: If (p_rec.attribute3 = hr_api.g_varchar2) then
487: p_rec.attribute3 :=
488: irc_ilp_shd.g_old_rec.attribute3;
489: End If;
490: If (p_rec.attribute4 = hr_api.g_varchar2) then
491: p_rec.attribute4 :=
492: irc_ilp_shd.g_old_rec.attribute4;
493: End If;
494: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 494: If (p_rec.attribute5 = hr_api.g_varchar2) then

490: If (p_rec.attribute4 = hr_api.g_varchar2) then
491: p_rec.attribute4 :=
492: irc_ilp_shd.g_old_rec.attribute4;
493: End If;
494: If (p_rec.attribute5 = hr_api.g_varchar2) then
495: p_rec.attribute5 :=
496: irc_ilp_shd.g_old_rec.attribute5;
497: End If;
498: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 498: If (p_rec.attribute6 = hr_api.g_varchar2) then

494: If (p_rec.attribute5 = hr_api.g_varchar2) then
495: p_rec.attribute5 :=
496: irc_ilp_shd.g_old_rec.attribute5;
497: End If;
498: If (p_rec.attribute6 = hr_api.g_varchar2) then
499: p_rec.attribute6 :=
500: irc_ilp_shd.g_old_rec.attribute6;
501: End If;
502: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 502: If (p_rec.attribute7 = hr_api.g_varchar2) then

498: If (p_rec.attribute6 = hr_api.g_varchar2) then
499: p_rec.attribute6 :=
500: irc_ilp_shd.g_old_rec.attribute6;
501: End If;
502: If (p_rec.attribute7 = hr_api.g_varchar2) then
503: p_rec.attribute7 :=
504: irc_ilp_shd.g_old_rec.attribute7;
505: End If;
506: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 506: If (p_rec.attribute8 = hr_api.g_varchar2) then

502: If (p_rec.attribute7 = hr_api.g_varchar2) then
503: p_rec.attribute7 :=
504: irc_ilp_shd.g_old_rec.attribute7;
505: End If;
506: If (p_rec.attribute8 = hr_api.g_varchar2) then
507: p_rec.attribute8 :=
508: irc_ilp_shd.g_old_rec.attribute8;
509: End If;
510: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 510: If (p_rec.attribute9 = hr_api.g_varchar2) then

506: If (p_rec.attribute8 = hr_api.g_varchar2) then
507: p_rec.attribute8 :=
508: irc_ilp_shd.g_old_rec.attribute8;
509: End If;
510: If (p_rec.attribute9 = hr_api.g_varchar2) then
511: p_rec.attribute9 :=
512: irc_ilp_shd.g_old_rec.attribute9;
513: End If;
514: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 514: If (p_rec.attribute10 = hr_api.g_varchar2) then

510: If (p_rec.attribute9 = hr_api.g_varchar2) then
511: p_rec.attribute9 :=
512: irc_ilp_shd.g_old_rec.attribute9;
513: End If;
514: If (p_rec.attribute10 = hr_api.g_varchar2) then
515: p_rec.attribute10 :=
516: irc_ilp_shd.g_old_rec.attribute10;
517: End If;
518: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 518: If (p_rec.attribute11 = hr_api.g_varchar2) then

514: If (p_rec.attribute10 = hr_api.g_varchar2) then
515: p_rec.attribute10 :=
516: irc_ilp_shd.g_old_rec.attribute10;
517: End If;
518: If (p_rec.attribute11 = hr_api.g_varchar2) then
519: p_rec.attribute11 :=
520: irc_ilp_shd.g_old_rec.attribute11;
521: End If;
522: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 522: If (p_rec.attribute12 = hr_api.g_varchar2) then

518: If (p_rec.attribute11 = hr_api.g_varchar2) then
519: p_rec.attribute11 :=
520: irc_ilp_shd.g_old_rec.attribute11;
521: End If;
522: If (p_rec.attribute12 = hr_api.g_varchar2) then
523: p_rec.attribute12 :=
524: irc_ilp_shd.g_old_rec.attribute12;
525: End If;
526: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 526: If (p_rec.attribute13 = hr_api.g_varchar2) then

522: If (p_rec.attribute12 = hr_api.g_varchar2) then
523: p_rec.attribute12 :=
524: irc_ilp_shd.g_old_rec.attribute12;
525: End If;
526: If (p_rec.attribute13 = hr_api.g_varchar2) then
527: p_rec.attribute13 :=
528: irc_ilp_shd.g_old_rec.attribute13;
529: End If;
530: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 530: If (p_rec.attribute14 = hr_api.g_varchar2) then

526: If (p_rec.attribute13 = hr_api.g_varchar2) then
527: p_rec.attribute13 :=
528: irc_ilp_shd.g_old_rec.attribute13;
529: End If;
530: If (p_rec.attribute14 = hr_api.g_varchar2) then
531: p_rec.attribute14 :=
532: irc_ilp_shd.g_old_rec.attribute14;
533: End If;
534: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 534: If (p_rec.attribute15 = hr_api.g_varchar2) then

530: If (p_rec.attribute14 = hr_api.g_varchar2) then
531: p_rec.attribute14 :=
532: irc_ilp_shd.g_old_rec.attribute14;
533: End If;
534: If (p_rec.attribute15 = hr_api.g_varchar2) then
535: p_rec.attribute15 :=
536: irc_ilp_shd.g_old_rec.attribute15;
537: End If;
538: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 538: If (p_rec.attribute16 = hr_api.g_varchar2) then

534: If (p_rec.attribute15 = hr_api.g_varchar2) then
535: p_rec.attribute15 :=
536: irc_ilp_shd.g_old_rec.attribute15;
537: End If;
538: If (p_rec.attribute16 = hr_api.g_varchar2) then
539: p_rec.attribute16 :=
540: irc_ilp_shd.g_old_rec.attribute16;
541: End If;
542: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 542: If (p_rec.attribute17 = hr_api.g_varchar2) then

538: If (p_rec.attribute16 = hr_api.g_varchar2) then
539: p_rec.attribute16 :=
540: irc_ilp_shd.g_old_rec.attribute16;
541: End If;
542: If (p_rec.attribute17 = hr_api.g_varchar2) then
543: p_rec.attribute17 :=
544: irc_ilp_shd.g_old_rec.attribute17;
545: End If;
546: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 546: If (p_rec.attribute18 = hr_api.g_varchar2) then

542: If (p_rec.attribute17 = hr_api.g_varchar2) then
543: p_rec.attribute17 :=
544: irc_ilp_shd.g_old_rec.attribute17;
545: End If;
546: If (p_rec.attribute18 = hr_api.g_varchar2) then
547: p_rec.attribute18 :=
548: irc_ilp_shd.g_old_rec.attribute18;
549: End If;
550: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 550: If (p_rec.attribute19 = hr_api.g_varchar2) then

546: If (p_rec.attribute18 = hr_api.g_varchar2) then
547: p_rec.attribute18 :=
548: irc_ilp_shd.g_old_rec.attribute18;
549: End If;
550: If (p_rec.attribute19 = hr_api.g_varchar2) then
551: p_rec.attribute19 :=
552: irc_ilp_shd.g_old_rec.attribute19;
553: End If;
554: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 554: If (p_rec.attribute20 = hr_api.g_varchar2) then

550: If (p_rec.attribute19 = hr_api.g_varchar2) then
551: p_rec.attribute19 :=
552: irc_ilp_shd.g_old_rec.attribute19;
553: End If;
554: If (p_rec.attribute20 = hr_api.g_varchar2) then
555: p_rec.attribute20 :=
556: irc_ilp_shd.g_old_rec.attribute20;
557: End If;
558: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 558: If (p_rec.attribute21 = hr_api.g_varchar2) then

554: If (p_rec.attribute20 = hr_api.g_varchar2) then
555: p_rec.attribute20 :=
556: irc_ilp_shd.g_old_rec.attribute20;
557: End If;
558: If (p_rec.attribute21 = hr_api.g_varchar2) then
559: p_rec.attribute21 :=
560: irc_ilp_shd.g_old_rec.attribute21;
561: End If;
562: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 562: If (p_rec.attribute22 = hr_api.g_varchar2) then

558: If (p_rec.attribute21 = hr_api.g_varchar2) then
559: p_rec.attribute21 :=
560: irc_ilp_shd.g_old_rec.attribute21;
561: End If;
562: If (p_rec.attribute22 = hr_api.g_varchar2) then
563: p_rec.attribute22 :=
564: irc_ilp_shd.g_old_rec.attribute22;
565: End If;
566: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 566: If (p_rec.attribute23 = hr_api.g_varchar2) then

562: If (p_rec.attribute22 = hr_api.g_varchar2) then
563: p_rec.attribute22 :=
564: irc_ilp_shd.g_old_rec.attribute22;
565: End If;
566: If (p_rec.attribute23 = hr_api.g_varchar2) then
567: p_rec.attribute23 :=
568: irc_ilp_shd.g_old_rec.attribute23;
569: End If;
570: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 570: If (p_rec.attribute24 = hr_api.g_varchar2) then

566: If (p_rec.attribute23 = hr_api.g_varchar2) then
567: p_rec.attribute23 :=
568: irc_ilp_shd.g_old_rec.attribute23;
569: End If;
570: If (p_rec.attribute24 = hr_api.g_varchar2) then
571: p_rec.attribute24 :=
572: irc_ilp_shd.g_old_rec.attribute24;
573: End If;
574: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 574: If (p_rec.attribute25 = hr_api.g_varchar2) then

570: If (p_rec.attribute24 = hr_api.g_varchar2) then
571: p_rec.attribute24 :=
572: irc_ilp_shd.g_old_rec.attribute24;
573: End If;
574: If (p_rec.attribute25 = hr_api.g_varchar2) then
575: p_rec.attribute25 :=
576: irc_ilp_shd.g_old_rec.attribute25;
577: End If;
578: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 578: If (p_rec.attribute26 = hr_api.g_varchar2) then

574: If (p_rec.attribute25 = hr_api.g_varchar2) then
575: p_rec.attribute25 :=
576: irc_ilp_shd.g_old_rec.attribute25;
577: End If;
578: If (p_rec.attribute26 = hr_api.g_varchar2) then
579: p_rec.attribute26 :=
580: irc_ilp_shd.g_old_rec.attribute26;
581: End If;
582: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 582: If (p_rec.attribute27 = hr_api.g_varchar2) then

578: If (p_rec.attribute26 = hr_api.g_varchar2) then
579: p_rec.attribute26 :=
580: irc_ilp_shd.g_old_rec.attribute26;
581: End If;
582: If (p_rec.attribute27 = hr_api.g_varchar2) then
583: p_rec.attribute27 :=
584: irc_ilp_shd.g_old_rec.attribute27;
585: End If;
586: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 586: If (p_rec.attribute28 = hr_api.g_varchar2) then

582: If (p_rec.attribute27 = hr_api.g_varchar2) then
583: p_rec.attribute27 :=
584: irc_ilp_shd.g_old_rec.attribute27;
585: End If;
586: If (p_rec.attribute28 = hr_api.g_varchar2) then
587: p_rec.attribute28 :=
588: irc_ilp_shd.g_old_rec.attribute28;
589: End If;
590: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 590: If (p_rec.attribute29 = hr_api.g_varchar2) then

586: If (p_rec.attribute28 = hr_api.g_varchar2) then
587: p_rec.attribute28 :=
588: irc_ilp_shd.g_old_rec.attribute28;
589: End If;
590: If (p_rec.attribute29 = hr_api.g_varchar2) then
591: p_rec.attribute29 :=
592: irc_ilp_shd.g_old_rec.attribute29;
593: End If;
594: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 594: If (p_rec.attribute30 = hr_api.g_varchar2) then

590: If (p_rec.attribute29 = hr_api.g_varchar2) then
591: p_rec.attribute29 :=
592: irc_ilp_shd.g_old_rec.attribute29;
593: End If;
594: If (p_rec.attribute30 = hr_api.g_varchar2) then
595: p_rec.attribute30 :=
596: irc_ilp_shd.g_old_rec.attribute30;
597: End If;
598: --

Line 662: ,p_object_id in number default hr_api.g_number

658: Procedure upd
659: (p_effective_date in date
660: ,p_location_pref_id in number
661: ,p_object_version_number in out nocopy number
662: ,p_object_id in number default hr_api.g_number
663: ,p_object_type in varchar2 default hr_api.g_varchar2
664: ,p_rec_area_id in number default hr_api.g_number
665: ,p_business_group_id in number default hr_api.g_number
666: ,p_country_code in varchar2 default hr_api.g_varchar2

Line 663: ,p_object_type in varchar2 default hr_api.g_varchar2

659: (p_effective_date in date
660: ,p_location_pref_id in number
661: ,p_object_version_number in out nocopy number
662: ,p_object_id in number default hr_api.g_number
663: ,p_object_type in varchar2 default hr_api.g_varchar2
664: ,p_rec_area_id in number default hr_api.g_number
665: ,p_business_group_id in number default hr_api.g_number
666: ,p_country_code in varchar2 default hr_api.g_varchar2
667: ,p_location_id in number default hr_api.g_number

Line 664: ,p_rec_area_id in number default hr_api.g_number

660: ,p_location_pref_id in number
661: ,p_object_version_number in out nocopy number
662: ,p_object_id in number default hr_api.g_number
663: ,p_object_type in varchar2 default hr_api.g_varchar2
664: ,p_rec_area_id in number default hr_api.g_number
665: ,p_business_group_id in number default hr_api.g_number
666: ,p_country_code in varchar2 default hr_api.g_varchar2
667: ,p_location_id in number default hr_api.g_number
668: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 665: ,p_business_group_id in number default hr_api.g_number

661: ,p_object_version_number in out nocopy number
662: ,p_object_id in number default hr_api.g_number
663: ,p_object_type in varchar2 default hr_api.g_varchar2
664: ,p_rec_area_id in number default hr_api.g_number
665: ,p_business_group_id in number default hr_api.g_number
666: ,p_country_code in varchar2 default hr_api.g_varchar2
667: ,p_location_id in number default hr_api.g_number
668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
669: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 666: ,p_country_code in varchar2 default hr_api.g_varchar2

662: ,p_object_id in number default hr_api.g_number
663: ,p_object_type in varchar2 default hr_api.g_varchar2
664: ,p_rec_area_id in number default hr_api.g_number
665: ,p_business_group_id in number default hr_api.g_number
666: ,p_country_code in varchar2 default hr_api.g_varchar2
667: ,p_location_id in number default hr_api.g_number
668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
670: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 667: ,p_location_id in number default hr_api.g_number

663: ,p_object_type in varchar2 default hr_api.g_varchar2
664: ,p_rec_area_id in number default hr_api.g_number
665: ,p_business_group_id in number default hr_api.g_number
666: ,p_country_code in varchar2 default hr_api.g_varchar2
667: ,p_location_id in number default hr_api.g_number
668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
671: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 668: ,p_attribute_category in varchar2 default hr_api.g_varchar2

664: ,p_rec_area_id in number default hr_api.g_number
665: ,p_business_group_id in number default hr_api.g_number
666: ,p_country_code in varchar2 default hr_api.g_varchar2
667: ,p_location_id in number default hr_api.g_number
668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
672: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 669: ,p_attribute1 in varchar2 default hr_api.g_varchar2

665: ,p_business_group_id in number default hr_api.g_number
666: ,p_country_code in varchar2 default hr_api.g_varchar2
667: ,p_location_id in number default hr_api.g_number
668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
673: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 670: ,p_attribute2 in varchar2 default hr_api.g_varchar2

666: ,p_country_code in varchar2 default hr_api.g_varchar2
667: ,p_location_id in number default hr_api.g_number
668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
674: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 671: ,p_attribute3 in varchar2 default hr_api.g_varchar2

667: ,p_location_id in number default hr_api.g_number
668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
675: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 672: ,p_attribute4 in varchar2 default hr_api.g_varchar2

668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
676: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 673: ,p_attribute5 in varchar2 default hr_api.g_varchar2

669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
677: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 674: ,p_attribute6 in varchar2 default hr_api.g_varchar2

670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
678: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 675: ,p_attribute7 in varchar2 default hr_api.g_varchar2

671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
679: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 676: ,p_attribute8 in varchar2 default hr_api.g_varchar2

672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
680: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 677: ,p_attribute9 in varchar2 default hr_api.g_varchar2

673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
681: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 678: ,p_attribute10 in varchar2 default hr_api.g_varchar2

674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
682: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 679: ,p_attribute11 in varchar2 default hr_api.g_varchar2

675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
683: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 680: ,p_attribute12 in varchar2 default hr_api.g_varchar2

676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
684: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 681: ,p_attribute13 in varchar2 default hr_api.g_varchar2

677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
685: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 682: ,p_attribute14 in varchar2 default hr_api.g_varchar2

678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
686: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 683: ,p_attribute15 in varchar2 default hr_api.g_varchar2

679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
687: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 684: ,p_attribute16 in varchar2 default hr_api.g_varchar2

680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
688: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 685: ,p_attribute17 in varchar2 default hr_api.g_varchar2

681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
689: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 686: ,p_attribute18 in varchar2 default hr_api.g_varchar2

682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
690: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 687: ,p_attribute19 in varchar2 default hr_api.g_varchar2

683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
691: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 688: ,p_attribute20 in varchar2 default hr_api.g_varchar2

684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
692: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 689: ,p_attribute21 in varchar2 default hr_api.g_varchar2

685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
693: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 690: ,p_attribute22 in varchar2 default hr_api.g_varchar2

686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
694: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 691: ,p_attribute23 in varchar2 default hr_api.g_varchar2

687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
695: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 692: ,p_attribute24 in varchar2 default hr_api.g_varchar2

688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
696: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 693: ,p_attribute25 in varchar2 default hr_api.g_varchar2

689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
697: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 694: ,p_attribute26 in varchar2 default hr_api.g_varchar2

690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
698: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 695: ,p_attribute27 in varchar2 default hr_api.g_varchar2

691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
699: ) is

Line 696: ,p_attribute28 in varchar2 default hr_api.g_varchar2

692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
699: ) is
700: --

Line 697: ,p_attribute29 in varchar2 default hr_api.g_varchar2

693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
699: ) is
700: --
701: l_rec irc_ilp_shd.g_rec_type;

Line 698: ,p_attribute30 in varchar2 default hr_api.g_varchar2

694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
699: ) is
700: --
701: l_rec irc_ilp_shd.g_rec_type;
702: l_proc varchar2(72) := g_package||'upd';