APPS.PQP_SHP_UPD dependencies on HR_API

Line 136: When hr_api.check_integrity_violated Then

132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 10);
134: --
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
139: pqp_shp_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
139: pqp_shp_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
144: pqp_shp_shd.constraint_error

Line 141: When hr_api.parent_integrity_violated Then

137: -- A check constraint has been violated
138: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
139: pqp_shp_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
144: pqp_shp_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
144: pqp_shp_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
149: pqp_shp_shd.constraint_error

Line 146: When hr_api.unique_integrity_violated Then

142: -- Parent integrity has been violated
143: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
144: pqp_shp_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
149: pqp_shp_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
149: pqp_shp_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
153: Raise;
154: End update_dml;

Line 474: when hr_api.cannot_find_prog_unit then

470: );
471: --
472: exception
473: --
474: when hr_api.cannot_find_prog_unit then
475: --
476: hr_api.cannot_find_prog_unit_error
477: (p_module_name => 'PQP_SERVICE_HISTORY_PERIODS'
478: ,p_hook_type => 'AU');

Line 476: hr_api.cannot_find_prog_unit_error

472: exception
473: --
474: when hr_api.cannot_find_prog_unit then
475: --
476: hr_api.cannot_find_prog_unit_error
477: (p_module_name => 'PQP_SERVICE_HISTORY_PERIODS'
478: ,p_hook_type => 'AU');
479: --
480: end;

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

535: -- p_rec plsql record structure
536: -- to see if a system default is being used. If a system default
537: -- is being used then we must set to the 'current' argument value.
538: --
539: If (p_rec.business_group_id = hr_api.g_number) then
540: p_rec.business_group_id :=
541: pqp_shp_shd.g_old_rec.business_group_id;
542: End If;
543: If (p_rec.assignment_id = hr_api.g_number) then

Line 543: If (p_rec.assignment_id = hr_api.g_number) then

539: If (p_rec.business_group_id = hr_api.g_number) then
540: p_rec.business_group_id :=
541: pqp_shp_shd.g_old_rec.business_group_id;
542: End If;
543: If (p_rec.assignment_id = hr_api.g_number) then
544: p_rec.assignment_id :=
545: pqp_shp_shd.g_old_rec.assignment_id;
546: End If;
547: If (p_rec.start_date = hr_api.g_date) then

Line 547: If (p_rec.start_date = hr_api.g_date) then

543: If (p_rec.assignment_id = hr_api.g_number) then
544: p_rec.assignment_id :=
545: pqp_shp_shd.g_old_rec.assignment_id;
546: End If;
547: If (p_rec.start_date = hr_api.g_date) then
548: p_rec.start_date :=
549: pqp_shp_shd.g_old_rec.start_date;
550: End If;
551: If (p_rec.end_date = hr_api.g_date) then

Line 551: If (p_rec.end_date = hr_api.g_date) then

547: If (p_rec.start_date = hr_api.g_date) then
548: p_rec.start_date :=
549: pqp_shp_shd.g_old_rec.start_date;
550: End If;
551: If (p_rec.end_date = hr_api.g_date) then
552: p_rec.end_date :=
553: pqp_shp_shd.g_old_rec.end_date;
554: End If;
555: If (p_rec.employer_name = hr_api.g_varchar2) then

Line 555: If (p_rec.employer_name = hr_api.g_varchar2) then

551: If (p_rec.end_date = hr_api.g_date) then
552: p_rec.end_date :=
553: pqp_shp_shd.g_old_rec.end_date;
554: End If;
555: If (p_rec.employer_name = hr_api.g_varchar2) then
556: p_rec.employer_name :=
557: pqp_shp_shd.g_old_rec.employer_name;
558: End If;
559: If (p_rec.employer_address = hr_api.g_varchar2) then

Line 559: If (p_rec.employer_address = hr_api.g_varchar2) then

555: If (p_rec.employer_name = hr_api.g_varchar2) then
556: p_rec.employer_name :=
557: pqp_shp_shd.g_old_rec.employer_name;
558: End If;
559: If (p_rec.employer_address = hr_api.g_varchar2) then
560: p_rec.employer_address :=
561: pqp_shp_shd.g_old_rec.employer_address;
562: End If;
563: If (p_rec.employer_type = hr_api.g_varchar2) then

Line 563: If (p_rec.employer_type = hr_api.g_varchar2) then

559: If (p_rec.employer_address = hr_api.g_varchar2) then
560: p_rec.employer_address :=
561: pqp_shp_shd.g_old_rec.employer_address;
562: End If;
563: If (p_rec.employer_type = hr_api.g_varchar2) then
564: p_rec.employer_type :=
565: pqp_shp_shd.g_old_rec.employer_type;
566: End If;
567: If (p_rec.employer_subtype = hr_api.g_varchar2) then

Line 567: If (p_rec.employer_subtype = hr_api.g_varchar2) then

563: If (p_rec.employer_type = hr_api.g_varchar2) then
564: p_rec.employer_type :=
565: pqp_shp_shd.g_old_rec.employer_type;
566: End If;
567: If (p_rec.employer_subtype = hr_api.g_varchar2) then
568: p_rec.employer_subtype :=
569: pqp_shp_shd.g_old_rec.employer_subtype;
570: End If;
571: If (p_rec.period_years = hr_api.g_number) then

Line 571: If (p_rec.period_years = hr_api.g_number) then

567: If (p_rec.employer_subtype = hr_api.g_varchar2) then
568: p_rec.employer_subtype :=
569: pqp_shp_shd.g_old_rec.employer_subtype;
570: End If;
571: If (p_rec.period_years = hr_api.g_number) then
572: p_rec.period_years :=
573: pqp_shp_shd.g_old_rec.period_years;
574: End If;
575: If (p_rec.period_days = hr_api.g_number) then

Line 575: If (p_rec.period_days = hr_api.g_number) then

571: If (p_rec.period_years = hr_api.g_number) then
572: p_rec.period_years :=
573: pqp_shp_shd.g_old_rec.period_years;
574: End If;
575: If (p_rec.period_days = hr_api.g_number) then
576: p_rec.period_days :=
577: pqp_shp_shd.g_old_rec.period_days;
578: End If;
579: If (p_rec.description = hr_api.g_varchar2) then

Line 579: If (p_rec.description = hr_api.g_varchar2) then

575: If (p_rec.period_days = hr_api.g_number) then
576: p_rec.period_days :=
577: pqp_shp_shd.g_old_rec.period_days;
578: End If;
579: If (p_rec.description = hr_api.g_varchar2) then
580: p_rec.description :=
581: pqp_shp_shd.g_old_rec.description;
582: End If;
583: If (p_rec.continuous_service = hr_api.g_varchar2) then

Line 583: If (p_rec.continuous_service = hr_api.g_varchar2) then

579: If (p_rec.description = hr_api.g_varchar2) then
580: p_rec.description :=
581: pqp_shp_shd.g_old_rec.description;
582: End If;
583: If (p_rec.continuous_service = hr_api.g_varchar2) then
584: p_rec.continuous_service :=
585: pqp_shp_shd.g_old_rec.continuous_service;
586: End If;
587: If (p_rec.all_assignments = hr_api.g_varchar2) then

Line 587: If (p_rec.all_assignments = hr_api.g_varchar2) then

583: If (p_rec.continuous_service = hr_api.g_varchar2) then
584: p_rec.continuous_service :=
585: pqp_shp_shd.g_old_rec.continuous_service;
586: End If;
587: If (p_rec.all_assignments = hr_api.g_varchar2) then
588: p_rec.all_assignments :=
589: pqp_shp_shd.g_old_rec.all_assignments;
590: End If;
591: If (p_rec.shp_attribute_category = hr_api.g_varchar2) then

Line 591: If (p_rec.shp_attribute_category = hr_api.g_varchar2) then

587: If (p_rec.all_assignments = hr_api.g_varchar2) then
588: p_rec.all_assignments :=
589: pqp_shp_shd.g_old_rec.all_assignments;
590: End If;
591: If (p_rec.shp_attribute_category = hr_api.g_varchar2) then
592: p_rec.shp_attribute_category :=
593: pqp_shp_shd.g_old_rec.shp_attribute_category;
594: End If;
595: If (p_rec.shp_attribute1 = hr_api.g_varchar2) then

Line 595: If (p_rec.shp_attribute1 = hr_api.g_varchar2) then

591: If (p_rec.shp_attribute_category = hr_api.g_varchar2) then
592: p_rec.shp_attribute_category :=
593: pqp_shp_shd.g_old_rec.shp_attribute_category;
594: End If;
595: If (p_rec.shp_attribute1 = hr_api.g_varchar2) then
596: p_rec.shp_attribute1 :=
597: pqp_shp_shd.g_old_rec.shp_attribute1;
598: End If;
599: If (p_rec.shp_attribute2 = hr_api.g_varchar2) then

Line 599: If (p_rec.shp_attribute2 = hr_api.g_varchar2) then

595: If (p_rec.shp_attribute1 = hr_api.g_varchar2) then
596: p_rec.shp_attribute1 :=
597: pqp_shp_shd.g_old_rec.shp_attribute1;
598: End If;
599: If (p_rec.shp_attribute2 = hr_api.g_varchar2) then
600: p_rec.shp_attribute2 :=
601: pqp_shp_shd.g_old_rec.shp_attribute2;
602: End If;
603: If (p_rec.shp_attribute3 = hr_api.g_varchar2) then

Line 603: If (p_rec.shp_attribute3 = hr_api.g_varchar2) then

599: If (p_rec.shp_attribute2 = hr_api.g_varchar2) then
600: p_rec.shp_attribute2 :=
601: pqp_shp_shd.g_old_rec.shp_attribute2;
602: End If;
603: If (p_rec.shp_attribute3 = hr_api.g_varchar2) then
604: p_rec.shp_attribute3 :=
605: pqp_shp_shd.g_old_rec.shp_attribute3;
606: End If;
607: If (p_rec.shp_attribute4 = hr_api.g_varchar2) then

Line 607: If (p_rec.shp_attribute4 = hr_api.g_varchar2) then

603: If (p_rec.shp_attribute3 = hr_api.g_varchar2) then
604: p_rec.shp_attribute3 :=
605: pqp_shp_shd.g_old_rec.shp_attribute3;
606: End If;
607: If (p_rec.shp_attribute4 = hr_api.g_varchar2) then
608: p_rec.shp_attribute4 :=
609: pqp_shp_shd.g_old_rec.shp_attribute4;
610: End If;
611: If (p_rec.shp_attribute5 = hr_api.g_varchar2) then

Line 611: If (p_rec.shp_attribute5 = hr_api.g_varchar2) then

607: If (p_rec.shp_attribute4 = hr_api.g_varchar2) then
608: p_rec.shp_attribute4 :=
609: pqp_shp_shd.g_old_rec.shp_attribute4;
610: End If;
611: If (p_rec.shp_attribute5 = hr_api.g_varchar2) then
612: p_rec.shp_attribute5 :=
613: pqp_shp_shd.g_old_rec.shp_attribute5;
614: End If;
615: If (p_rec.shp_attribute6 = hr_api.g_varchar2) then

Line 615: If (p_rec.shp_attribute6 = hr_api.g_varchar2) then

611: If (p_rec.shp_attribute5 = hr_api.g_varchar2) then
612: p_rec.shp_attribute5 :=
613: pqp_shp_shd.g_old_rec.shp_attribute5;
614: End If;
615: If (p_rec.shp_attribute6 = hr_api.g_varchar2) then
616: p_rec.shp_attribute6 :=
617: pqp_shp_shd.g_old_rec.shp_attribute6;
618: End If;
619: If (p_rec.shp_attribute7 = hr_api.g_varchar2) then

Line 619: If (p_rec.shp_attribute7 = hr_api.g_varchar2) then

615: If (p_rec.shp_attribute6 = hr_api.g_varchar2) then
616: p_rec.shp_attribute6 :=
617: pqp_shp_shd.g_old_rec.shp_attribute6;
618: End If;
619: If (p_rec.shp_attribute7 = hr_api.g_varchar2) then
620: p_rec.shp_attribute7 :=
621: pqp_shp_shd.g_old_rec.shp_attribute7;
622: End If;
623: If (p_rec.shp_attribute8 = hr_api.g_varchar2) then

Line 623: If (p_rec.shp_attribute8 = hr_api.g_varchar2) then

619: If (p_rec.shp_attribute7 = hr_api.g_varchar2) then
620: p_rec.shp_attribute7 :=
621: pqp_shp_shd.g_old_rec.shp_attribute7;
622: End If;
623: If (p_rec.shp_attribute8 = hr_api.g_varchar2) then
624: p_rec.shp_attribute8 :=
625: pqp_shp_shd.g_old_rec.shp_attribute8;
626: End If;
627: If (p_rec.shp_attribute9 = hr_api.g_varchar2) then

Line 627: If (p_rec.shp_attribute9 = hr_api.g_varchar2) then

623: If (p_rec.shp_attribute8 = hr_api.g_varchar2) then
624: p_rec.shp_attribute8 :=
625: pqp_shp_shd.g_old_rec.shp_attribute8;
626: End If;
627: If (p_rec.shp_attribute9 = hr_api.g_varchar2) then
628: p_rec.shp_attribute9 :=
629: pqp_shp_shd.g_old_rec.shp_attribute9;
630: End If;
631: If (p_rec.shp_attribute10 = hr_api.g_varchar2) then

Line 631: If (p_rec.shp_attribute10 = hr_api.g_varchar2) then

627: If (p_rec.shp_attribute9 = hr_api.g_varchar2) then
628: p_rec.shp_attribute9 :=
629: pqp_shp_shd.g_old_rec.shp_attribute9;
630: End If;
631: If (p_rec.shp_attribute10 = hr_api.g_varchar2) then
632: p_rec.shp_attribute10 :=
633: pqp_shp_shd.g_old_rec.shp_attribute10;
634: End If;
635: If (p_rec.shp_attribute11 = hr_api.g_varchar2) then

Line 635: If (p_rec.shp_attribute11 = hr_api.g_varchar2) then

631: If (p_rec.shp_attribute10 = hr_api.g_varchar2) then
632: p_rec.shp_attribute10 :=
633: pqp_shp_shd.g_old_rec.shp_attribute10;
634: End If;
635: If (p_rec.shp_attribute11 = hr_api.g_varchar2) then
636: p_rec.shp_attribute11 :=
637: pqp_shp_shd.g_old_rec.shp_attribute11;
638: End If;
639: If (p_rec.shp_attribute12 = hr_api.g_varchar2) then

Line 639: If (p_rec.shp_attribute12 = hr_api.g_varchar2) then

635: If (p_rec.shp_attribute11 = hr_api.g_varchar2) then
636: p_rec.shp_attribute11 :=
637: pqp_shp_shd.g_old_rec.shp_attribute11;
638: End If;
639: If (p_rec.shp_attribute12 = hr_api.g_varchar2) then
640: p_rec.shp_attribute12 :=
641: pqp_shp_shd.g_old_rec.shp_attribute12;
642: End If;
643: If (p_rec.shp_attribute13 = hr_api.g_varchar2) then

Line 643: If (p_rec.shp_attribute13 = hr_api.g_varchar2) then

639: If (p_rec.shp_attribute12 = hr_api.g_varchar2) then
640: p_rec.shp_attribute12 :=
641: pqp_shp_shd.g_old_rec.shp_attribute12;
642: End If;
643: If (p_rec.shp_attribute13 = hr_api.g_varchar2) then
644: p_rec.shp_attribute13 :=
645: pqp_shp_shd.g_old_rec.shp_attribute13;
646: End If;
647: If (p_rec.shp_attribute14 = hr_api.g_varchar2) then

Line 647: If (p_rec.shp_attribute14 = hr_api.g_varchar2) then

643: If (p_rec.shp_attribute13 = hr_api.g_varchar2) then
644: p_rec.shp_attribute13 :=
645: pqp_shp_shd.g_old_rec.shp_attribute13;
646: End If;
647: If (p_rec.shp_attribute14 = hr_api.g_varchar2) then
648: p_rec.shp_attribute14 :=
649: pqp_shp_shd.g_old_rec.shp_attribute14;
650: End If;
651: If (p_rec.shp_attribute15 = hr_api.g_varchar2) then

Line 651: If (p_rec.shp_attribute15 = hr_api.g_varchar2) then

647: If (p_rec.shp_attribute14 = hr_api.g_varchar2) then
648: p_rec.shp_attribute14 :=
649: pqp_shp_shd.g_old_rec.shp_attribute14;
650: End If;
651: If (p_rec.shp_attribute15 = hr_api.g_varchar2) then
652: p_rec.shp_attribute15 :=
653: pqp_shp_shd.g_old_rec.shp_attribute15;
654: End If;
655: If (p_rec.shp_attribute16 = hr_api.g_varchar2) then

Line 655: If (p_rec.shp_attribute16 = hr_api.g_varchar2) then

651: If (p_rec.shp_attribute15 = hr_api.g_varchar2) then
652: p_rec.shp_attribute15 :=
653: pqp_shp_shd.g_old_rec.shp_attribute15;
654: End If;
655: If (p_rec.shp_attribute16 = hr_api.g_varchar2) then
656: p_rec.shp_attribute16 :=
657: pqp_shp_shd.g_old_rec.shp_attribute16;
658: End If;
659: If (p_rec.shp_attribute17 = hr_api.g_varchar2) then

Line 659: If (p_rec.shp_attribute17 = hr_api.g_varchar2) then

655: If (p_rec.shp_attribute16 = hr_api.g_varchar2) then
656: p_rec.shp_attribute16 :=
657: pqp_shp_shd.g_old_rec.shp_attribute16;
658: End If;
659: If (p_rec.shp_attribute17 = hr_api.g_varchar2) then
660: p_rec.shp_attribute17 :=
661: pqp_shp_shd.g_old_rec.shp_attribute17;
662: End If;
663: If (p_rec.shp_attribute18 = hr_api.g_varchar2) then

Line 663: If (p_rec.shp_attribute18 = hr_api.g_varchar2) then

659: If (p_rec.shp_attribute17 = hr_api.g_varchar2) then
660: p_rec.shp_attribute17 :=
661: pqp_shp_shd.g_old_rec.shp_attribute17;
662: End If;
663: If (p_rec.shp_attribute18 = hr_api.g_varchar2) then
664: p_rec.shp_attribute18 :=
665: pqp_shp_shd.g_old_rec.shp_attribute18;
666: End If;
667: If (p_rec.shp_attribute19 = hr_api.g_varchar2) then

Line 667: If (p_rec.shp_attribute19 = hr_api.g_varchar2) then

663: If (p_rec.shp_attribute18 = hr_api.g_varchar2) then
664: p_rec.shp_attribute18 :=
665: pqp_shp_shd.g_old_rec.shp_attribute18;
666: End If;
667: If (p_rec.shp_attribute19 = hr_api.g_varchar2) then
668: p_rec.shp_attribute19 :=
669: pqp_shp_shd.g_old_rec.shp_attribute19;
670: End If;
671: If (p_rec.shp_attribute20 = hr_api.g_varchar2) then

Line 671: If (p_rec.shp_attribute20 = hr_api.g_varchar2) then

667: If (p_rec.shp_attribute19 = hr_api.g_varchar2) then
668: p_rec.shp_attribute19 :=
669: pqp_shp_shd.g_old_rec.shp_attribute19;
670: End If;
671: If (p_rec.shp_attribute20 = hr_api.g_varchar2) then
672: p_rec.shp_attribute20 :=
673: pqp_shp_shd.g_old_rec.shp_attribute20;
674: End If;
675: If (p_rec.shp_information_category = hr_api.g_varchar2) then

Line 675: If (p_rec.shp_information_category = hr_api.g_varchar2) then

671: If (p_rec.shp_attribute20 = hr_api.g_varchar2) then
672: p_rec.shp_attribute20 :=
673: pqp_shp_shd.g_old_rec.shp_attribute20;
674: End If;
675: If (p_rec.shp_information_category = hr_api.g_varchar2) then
676: p_rec.shp_information_category :=
677: pqp_shp_shd.g_old_rec.shp_information_category;
678: End If;
679: If (p_rec.shp_information1 = hr_api.g_varchar2) then

Line 679: If (p_rec.shp_information1 = hr_api.g_varchar2) then

675: If (p_rec.shp_information_category = hr_api.g_varchar2) then
676: p_rec.shp_information_category :=
677: pqp_shp_shd.g_old_rec.shp_information_category;
678: End If;
679: If (p_rec.shp_information1 = hr_api.g_varchar2) then
680: p_rec.shp_information1 :=
681: pqp_shp_shd.g_old_rec.shp_information1;
682: End If;
683: If (p_rec.shp_information2 = hr_api.g_varchar2) then

Line 683: If (p_rec.shp_information2 = hr_api.g_varchar2) then

679: If (p_rec.shp_information1 = hr_api.g_varchar2) then
680: p_rec.shp_information1 :=
681: pqp_shp_shd.g_old_rec.shp_information1;
682: End If;
683: If (p_rec.shp_information2 = hr_api.g_varchar2) then
684: p_rec.shp_information2 :=
685: pqp_shp_shd.g_old_rec.shp_information2;
686: End If;
687: If (p_rec.shp_information3 = hr_api.g_varchar2) then

Line 687: If (p_rec.shp_information3 = hr_api.g_varchar2) then

683: If (p_rec.shp_information2 = hr_api.g_varchar2) then
684: p_rec.shp_information2 :=
685: pqp_shp_shd.g_old_rec.shp_information2;
686: End If;
687: If (p_rec.shp_information3 = hr_api.g_varchar2) then
688: p_rec.shp_information3 :=
689: pqp_shp_shd.g_old_rec.shp_information3;
690: End If;
691: If (p_rec.shp_information4 = hr_api.g_varchar2) then

Line 691: If (p_rec.shp_information4 = hr_api.g_varchar2) then

687: If (p_rec.shp_information3 = hr_api.g_varchar2) then
688: p_rec.shp_information3 :=
689: pqp_shp_shd.g_old_rec.shp_information3;
690: End If;
691: If (p_rec.shp_information4 = hr_api.g_varchar2) then
692: p_rec.shp_information4 :=
693: pqp_shp_shd.g_old_rec.shp_information4;
694: End If;
695: If (p_rec.shp_information5 = hr_api.g_varchar2) then

Line 695: If (p_rec.shp_information5 = hr_api.g_varchar2) then

691: If (p_rec.shp_information4 = hr_api.g_varchar2) then
692: p_rec.shp_information4 :=
693: pqp_shp_shd.g_old_rec.shp_information4;
694: End If;
695: If (p_rec.shp_information5 = hr_api.g_varchar2) then
696: p_rec.shp_information5 :=
697: pqp_shp_shd.g_old_rec.shp_information5;
698: End If;
699: If (p_rec.shp_information6 = hr_api.g_varchar2) then

Line 699: If (p_rec.shp_information6 = hr_api.g_varchar2) then

695: If (p_rec.shp_information5 = hr_api.g_varchar2) then
696: p_rec.shp_information5 :=
697: pqp_shp_shd.g_old_rec.shp_information5;
698: End If;
699: If (p_rec.shp_information6 = hr_api.g_varchar2) then
700: p_rec.shp_information6 :=
701: pqp_shp_shd.g_old_rec.shp_information6;
702: End If;
703: If (p_rec.shp_information7 = hr_api.g_varchar2) then

Line 703: If (p_rec.shp_information7 = hr_api.g_varchar2) then

699: If (p_rec.shp_information6 = hr_api.g_varchar2) then
700: p_rec.shp_information6 :=
701: pqp_shp_shd.g_old_rec.shp_information6;
702: End If;
703: If (p_rec.shp_information7 = hr_api.g_varchar2) then
704: p_rec.shp_information7 :=
705: pqp_shp_shd.g_old_rec.shp_information7;
706: End If;
707: If (p_rec.shp_information8 = hr_api.g_varchar2) then

Line 707: If (p_rec.shp_information8 = hr_api.g_varchar2) then

703: If (p_rec.shp_information7 = hr_api.g_varchar2) then
704: p_rec.shp_information7 :=
705: pqp_shp_shd.g_old_rec.shp_information7;
706: End If;
707: If (p_rec.shp_information8 = hr_api.g_varchar2) then
708: p_rec.shp_information8 :=
709: pqp_shp_shd.g_old_rec.shp_information8;
710: End If;
711: If (p_rec.shp_information9 = hr_api.g_varchar2) then

Line 711: If (p_rec.shp_information9 = hr_api.g_varchar2) then

707: If (p_rec.shp_information8 = hr_api.g_varchar2) then
708: p_rec.shp_information8 :=
709: pqp_shp_shd.g_old_rec.shp_information8;
710: End If;
711: If (p_rec.shp_information9 = hr_api.g_varchar2) then
712: p_rec.shp_information9 :=
713: pqp_shp_shd.g_old_rec.shp_information9;
714: End If;
715: If (p_rec.shp_information10 = hr_api.g_varchar2) then

Line 715: If (p_rec.shp_information10 = hr_api.g_varchar2) then

711: If (p_rec.shp_information9 = hr_api.g_varchar2) then
712: p_rec.shp_information9 :=
713: pqp_shp_shd.g_old_rec.shp_information9;
714: End If;
715: If (p_rec.shp_information10 = hr_api.g_varchar2) then
716: p_rec.shp_information10 :=
717: pqp_shp_shd.g_old_rec.shp_information10;
718: End If;
719: If (p_rec.shp_information11 = hr_api.g_varchar2) then

Line 719: If (p_rec.shp_information11 = hr_api.g_varchar2) then

715: If (p_rec.shp_information10 = hr_api.g_varchar2) then
716: p_rec.shp_information10 :=
717: pqp_shp_shd.g_old_rec.shp_information10;
718: End If;
719: If (p_rec.shp_information11 = hr_api.g_varchar2) then
720: p_rec.shp_information11 :=
721: pqp_shp_shd.g_old_rec.shp_information11;
722: End If;
723: If (p_rec.shp_information12 = hr_api.g_varchar2) then

Line 723: If (p_rec.shp_information12 = hr_api.g_varchar2) then

719: If (p_rec.shp_information11 = hr_api.g_varchar2) then
720: p_rec.shp_information11 :=
721: pqp_shp_shd.g_old_rec.shp_information11;
722: End If;
723: If (p_rec.shp_information12 = hr_api.g_varchar2) then
724: p_rec.shp_information12 :=
725: pqp_shp_shd.g_old_rec.shp_information12;
726: End If;
727: If (p_rec.shp_information13 = hr_api.g_varchar2) then

Line 727: If (p_rec.shp_information13 = hr_api.g_varchar2) then

723: If (p_rec.shp_information12 = hr_api.g_varchar2) then
724: p_rec.shp_information12 :=
725: pqp_shp_shd.g_old_rec.shp_information12;
726: End If;
727: If (p_rec.shp_information13 = hr_api.g_varchar2) then
728: p_rec.shp_information13 :=
729: pqp_shp_shd.g_old_rec.shp_information13;
730: End If;
731: If (p_rec.shp_information14 = hr_api.g_varchar2) then

Line 731: If (p_rec.shp_information14 = hr_api.g_varchar2) then

727: If (p_rec.shp_information13 = hr_api.g_varchar2) then
728: p_rec.shp_information13 :=
729: pqp_shp_shd.g_old_rec.shp_information13;
730: End If;
731: If (p_rec.shp_information14 = hr_api.g_varchar2) then
732: p_rec.shp_information14 :=
733: pqp_shp_shd.g_old_rec.shp_information14;
734: End If;
735: If (p_rec.shp_information15 = hr_api.g_varchar2) then

Line 735: If (p_rec.shp_information15 = hr_api.g_varchar2) then

731: If (p_rec.shp_information14 = hr_api.g_varchar2) then
732: p_rec.shp_information14 :=
733: pqp_shp_shd.g_old_rec.shp_information14;
734: End If;
735: If (p_rec.shp_information15 = hr_api.g_varchar2) then
736: p_rec.shp_information15 :=
737: pqp_shp_shd.g_old_rec.shp_information15;
738: End If;
739: If (p_rec.shp_information16 = hr_api.g_varchar2) then

Line 739: If (p_rec.shp_information16 = hr_api.g_varchar2) then

735: If (p_rec.shp_information15 = hr_api.g_varchar2) then
736: p_rec.shp_information15 :=
737: pqp_shp_shd.g_old_rec.shp_information15;
738: End If;
739: If (p_rec.shp_information16 = hr_api.g_varchar2) then
740: p_rec.shp_information16 :=
741: pqp_shp_shd.g_old_rec.shp_information16;
742: End If;
743: If (p_rec.shp_information17 = hr_api.g_varchar2) then

Line 743: If (p_rec.shp_information17 = hr_api.g_varchar2) then

739: If (p_rec.shp_information16 = hr_api.g_varchar2) then
740: p_rec.shp_information16 :=
741: pqp_shp_shd.g_old_rec.shp_information16;
742: End If;
743: If (p_rec.shp_information17 = hr_api.g_varchar2) then
744: p_rec.shp_information17 :=
745: pqp_shp_shd.g_old_rec.shp_information17;
746: End If;
747: If (p_rec.shp_information18 = hr_api.g_varchar2) then

Line 747: If (p_rec.shp_information18 = hr_api.g_varchar2) then

743: If (p_rec.shp_information17 = hr_api.g_varchar2) then
744: p_rec.shp_information17 :=
745: pqp_shp_shd.g_old_rec.shp_information17;
746: End If;
747: If (p_rec.shp_information18 = hr_api.g_varchar2) then
748: p_rec.shp_information18 :=
749: pqp_shp_shd.g_old_rec.shp_information18;
750: End If;
751: If (p_rec.shp_information19 = hr_api.g_varchar2) then

Line 751: If (p_rec.shp_information19 = hr_api.g_varchar2) then

747: If (p_rec.shp_information18 = hr_api.g_varchar2) then
748: p_rec.shp_information18 :=
749: pqp_shp_shd.g_old_rec.shp_information18;
750: End If;
751: If (p_rec.shp_information19 = hr_api.g_varchar2) then
752: p_rec.shp_information19 :=
753: pqp_shp_shd.g_old_rec.shp_information19;
754: End If;
755: If (p_rec.shp_information20 = hr_api.g_varchar2) then

Line 755: If (p_rec.shp_information20 = hr_api.g_varchar2) then

751: If (p_rec.shp_information19 = hr_api.g_varchar2) then
752: p_rec.shp_information19 :=
753: pqp_shp_shd.g_old_rec.shp_information19;
754: End If;
755: If (p_rec.shp_information20 = hr_api.g_varchar2) then
756: p_rec.shp_information20 :=
757: pqp_shp_shd.g_old_rec.shp_information20;
758: End If;
759: --

Line 816: ,p_business_group_id in number default hr_api.g_number

812: -- ----------------------------------------------------------------------------
813: Procedure upd
814: (p_service_history_period_id in number
815: ,p_object_version_number in out nocopy number
816: ,p_business_group_id in number default hr_api.g_number
817: ,p_assignment_id in number default hr_api.g_number
818: ,p_start_date in date default hr_api.g_date
819: ,p_end_date in date default hr_api.g_date
820: ,p_employer_name in varchar2 default hr_api.g_varchar2

Line 817: ,p_assignment_id in number default hr_api.g_number

813: Procedure upd
814: (p_service_history_period_id in number
815: ,p_object_version_number in out nocopy number
816: ,p_business_group_id in number default hr_api.g_number
817: ,p_assignment_id in number default hr_api.g_number
818: ,p_start_date in date default hr_api.g_date
819: ,p_end_date in date default hr_api.g_date
820: ,p_employer_name in varchar2 default hr_api.g_varchar2
821: ,p_employer_address in varchar2 default hr_api.g_varchar2

Line 818: ,p_start_date in date default hr_api.g_date

814: (p_service_history_period_id in number
815: ,p_object_version_number in out nocopy number
816: ,p_business_group_id in number default hr_api.g_number
817: ,p_assignment_id in number default hr_api.g_number
818: ,p_start_date in date default hr_api.g_date
819: ,p_end_date in date default hr_api.g_date
820: ,p_employer_name in varchar2 default hr_api.g_varchar2
821: ,p_employer_address in varchar2 default hr_api.g_varchar2
822: ,p_employer_type in varchar2 default hr_api.g_varchar2

Line 819: ,p_end_date in date default hr_api.g_date

815: ,p_object_version_number in out nocopy number
816: ,p_business_group_id in number default hr_api.g_number
817: ,p_assignment_id in number default hr_api.g_number
818: ,p_start_date in date default hr_api.g_date
819: ,p_end_date in date default hr_api.g_date
820: ,p_employer_name in varchar2 default hr_api.g_varchar2
821: ,p_employer_address in varchar2 default hr_api.g_varchar2
822: ,p_employer_type in varchar2 default hr_api.g_varchar2
823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2

Line 820: ,p_employer_name in varchar2 default hr_api.g_varchar2

816: ,p_business_group_id in number default hr_api.g_number
817: ,p_assignment_id in number default hr_api.g_number
818: ,p_start_date in date default hr_api.g_date
819: ,p_end_date in date default hr_api.g_date
820: ,p_employer_name in varchar2 default hr_api.g_varchar2
821: ,p_employer_address in varchar2 default hr_api.g_varchar2
822: ,p_employer_type in varchar2 default hr_api.g_varchar2
823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
824: ,p_period_years in number default hr_api.g_number

Line 821: ,p_employer_address in varchar2 default hr_api.g_varchar2

817: ,p_assignment_id in number default hr_api.g_number
818: ,p_start_date in date default hr_api.g_date
819: ,p_end_date in date default hr_api.g_date
820: ,p_employer_name in varchar2 default hr_api.g_varchar2
821: ,p_employer_address in varchar2 default hr_api.g_varchar2
822: ,p_employer_type in varchar2 default hr_api.g_varchar2
823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
824: ,p_period_years in number default hr_api.g_number
825: ,p_period_days in number default hr_api.g_number

Line 822: ,p_employer_type in varchar2 default hr_api.g_varchar2

818: ,p_start_date in date default hr_api.g_date
819: ,p_end_date in date default hr_api.g_date
820: ,p_employer_name in varchar2 default hr_api.g_varchar2
821: ,p_employer_address in varchar2 default hr_api.g_varchar2
822: ,p_employer_type in varchar2 default hr_api.g_varchar2
823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
824: ,p_period_years in number default hr_api.g_number
825: ,p_period_days in number default hr_api.g_number
826: ,p_description in varchar2 default hr_api.g_varchar2

Line 823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2

819: ,p_end_date in date default hr_api.g_date
820: ,p_employer_name in varchar2 default hr_api.g_varchar2
821: ,p_employer_address in varchar2 default hr_api.g_varchar2
822: ,p_employer_type in varchar2 default hr_api.g_varchar2
823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
824: ,p_period_years in number default hr_api.g_number
825: ,p_period_days in number default hr_api.g_number
826: ,p_description in varchar2 default hr_api.g_varchar2
827: ,p_continuous_service in varchar2 default hr_api.g_varchar2

Line 824: ,p_period_years in number default hr_api.g_number

820: ,p_employer_name in varchar2 default hr_api.g_varchar2
821: ,p_employer_address in varchar2 default hr_api.g_varchar2
822: ,p_employer_type in varchar2 default hr_api.g_varchar2
823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
824: ,p_period_years in number default hr_api.g_number
825: ,p_period_days in number default hr_api.g_number
826: ,p_description in varchar2 default hr_api.g_varchar2
827: ,p_continuous_service in varchar2 default hr_api.g_varchar2
828: ,p_all_assignments in varchar2 default hr_api.g_varchar2

Line 825: ,p_period_days in number default hr_api.g_number

821: ,p_employer_address in varchar2 default hr_api.g_varchar2
822: ,p_employer_type in varchar2 default hr_api.g_varchar2
823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
824: ,p_period_years in number default hr_api.g_number
825: ,p_period_days in number default hr_api.g_number
826: ,p_description in varchar2 default hr_api.g_varchar2
827: ,p_continuous_service in varchar2 default hr_api.g_varchar2
828: ,p_all_assignments in varchar2 default hr_api.g_varchar2
829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2

Line 826: ,p_description in varchar2 default hr_api.g_varchar2

822: ,p_employer_type in varchar2 default hr_api.g_varchar2
823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
824: ,p_period_years in number default hr_api.g_number
825: ,p_period_days in number default hr_api.g_number
826: ,p_description in varchar2 default hr_api.g_varchar2
827: ,p_continuous_service in varchar2 default hr_api.g_varchar2
828: ,p_all_assignments in varchar2 default hr_api.g_varchar2
829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2

Line 827: ,p_continuous_service in varchar2 default hr_api.g_varchar2

823: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
824: ,p_period_years in number default hr_api.g_number
825: ,p_period_days in number default hr_api.g_number
826: ,p_description in varchar2 default hr_api.g_varchar2
827: ,p_continuous_service in varchar2 default hr_api.g_varchar2
828: ,p_all_assignments in varchar2 default hr_api.g_varchar2
829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2

Line 828: ,p_all_assignments in varchar2 default hr_api.g_varchar2

824: ,p_period_years in number default hr_api.g_number
825: ,p_period_days in number default hr_api.g_number
826: ,p_description in varchar2 default hr_api.g_varchar2
827: ,p_continuous_service in varchar2 default hr_api.g_varchar2
828: ,p_all_assignments in varchar2 default hr_api.g_varchar2
829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2

Line 829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2

825: ,p_period_days in number default hr_api.g_number
826: ,p_description in varchar2 default hr_api.g_varchar2
827: ,p_continuous_service in varchar2 default hr_api.g_varchar2
828: ,p_all_assignments in varchar2 default hr_api.g_varchar2
829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2

Line 830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2

826: ,p_description in varchar2 default hr_api.g_varchar2
827: ,p_continuous_service in varchar2 default hr_api.g_varchar2
828: ,p_all_assignments in varchar2 default hr_api.g_varchar2
829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2

Line 831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2

827: ,p_continuous_service in varchar2 default hr_api.g_varchar2
828: ,p_all_assignments in varchar2 default hr_api.g_varchar2
829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2

Line 832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2

828: ,p_all_assignments in varchar2 default hr_api.g_varchar2
829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2

Line 833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2

829: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2

Line 834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2

830: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2

Line 835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2

831: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2

Line 836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2

832: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2

Line 837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2

833: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2

Line 838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2

834: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2

Line 839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2

835: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2

Line 840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2

836: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2

Line 841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2

837: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2

Line 842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2

838: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2

Line 843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2

839: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2

Line 844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2

840: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2

Line 845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2

841: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2

Line 846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2

842: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2

Line 847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2

843: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2

Line 848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2

844: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2

Line 849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2

845: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2

Line 850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2

846: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2

Line 851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2

847: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2

Line 852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2

848: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2

Line 853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2

849: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2

Line 854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2

850: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2

Line 855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2

851: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2

Line 856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2

852: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2

Line 857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2

853: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2

Line 858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2

854: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2

Line 859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2

855: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2

Line 860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2

856: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2

Line 861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2

857: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2

Line 862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2

858: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2

Line 863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2

859: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
867: ,p_shp_information17 in varchar2 default hr_api.g_varchar2

Line 864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2

860: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
867: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
868: ,p_shp_information18 in varchar2 default hr_api.g_varchar2

Line 865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2

861: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
867: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
868: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
869: ,p_shp_information19 in varchar2 default hr_api.g_varchar2

Line 866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2

862: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
867: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
868: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
869: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
870: ,p_shp_information20 in varchar2 default hr_api.g_varchar2

Line 867: ,p_shp_information17 in varchar2 default hr_api.g_varchar2

863: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
867: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
868: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
869: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
870: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
871: ) is

Line 868: ,p_shp_information18 in varchar2 default hr_api.g_varchar2

864: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
867: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
868: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
869: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
870: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
871: ) is
872: --

Line 869: ,p_shp_information19 in varchar2 default hr_api.g_varchar2

865: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
867: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
868: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
869: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
870: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
871: ) is
872: --
873: l_rec pqp_shp_shd.g_rec_type;

Line 870: ,p_shp_information20 in varchar2 default hr_api.g_varchar2

866: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
867: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
868: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
869: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
870: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
871: ) is
872: --
873: l_rec pqp_shp_shd.g_rec_type;
874: l_proc varchar2(72) := g_package||'upd';