APPS.PQH_PSU_UPD dependencies on HR_API

Line 126: When hr_api.check_integrity_violated Then

122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: --
129: pqh_psu_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: --
129: pqh_psu_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --
134: pqh_psu_shd.constraint_error

Line 131: When hr_api.parent_integrity_violated Then

127: -- A check constraint has been violated
128: --
129: pqh_psu_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --
134: pqh_psu_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: --
134: pqh_psu_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
139: pqh_psu_shd.constraint_error

Line 136: When hr_api.unique_integrity_violated Then

132: -- Parent integrity has been violated
133: --
134: pqh_psu_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
139: pqh_psu_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.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
139: pqh_psu_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: --
143: Raise;
144: End update_dml;

Line 425: when hr_api.cannot_find_prog_unit then

421: );
422: --
423: exception
424: --
425: when hr_api.cannot_find_prog_unit then
426: --
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'PQH_FR_EMP_STAT_SITUATIONS'
429: ,p_hook_type => 'AU');

Line 427: hr_api.cannot_find_prog_unit_error

423: exception
424: --
425: when hr_api.cannot_find_prog_unit then
426: --
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'PQH_FR_EMP_STAT_SITUATIONS'
429: ,p_hook_type => 'AU');
430: --
431: end;

Line 490: If (p_rec.statutory_situation_id = hr_api.g_number) then

486: -- p_rec plsql record structure
487: -- to see if a system default is being used. If a system default
488: -- is being used then we must set to the 'current' argument value.
489: --
490: If (p_rec.statutory_situation_id = hr_api.g_number) then
491: p_rec.statutory_situation_id :=
492: pqh_psu_shd.g_old_rec.statutory_situation_id;
493: End If;
494: If (p_rec.person_id = hr_api.g_number) then

Line 494: If (p_rec.person_id = hr_api.g_number) then

490: If (p_rec.statutory_situation_id = hr_api.g_number) then
491: p_rec.statutory_situation_id :=
492: pqh_psu_shd.g_old_rec.statutory_situation_id;
493: End If;
494: If (p_rec.person_id = hr_api.g_number) then
495: p_rec.person_id :=
496: pqh_psu_shd.g_old_rec.person_id;
497: End If;
498: If (p_rec.provisional_start_date = hr_api.g_date) then

Line 498: If (p_rec.provisional_start_date = hr_api.g_date) then

494: If (p_rec.person_id = hr_api.g_number) then
495: p_rec.person_id :=
496: pqh_psu_shd.g_old_rec.person_id;
497: End If;
498: If (p_rec.provisional_start_date = hr_api.g_date) then
499: p_rec.provisional_start_date :=
500: pqh_psu_shd.g_old_rec.provisional_start_date;
501: End If;
502: If (p_rec.provisional_end_date = hr_api.g_date) then

Line 502: If (p_rec.provisional_end_date = hr_api.g_date) then

498: If (p_rec.provisional_start_date = hr_api.g_date) then
499: p_rec.provisional_start_date :=
500: pqh_psu_shd.g_old_rec.provisional_start_date;
501: End If;
502: If (p_rec.provisional_end_date = hr_api.g_date) then
503: p_rec.provisional_end_date :=
504: pqh_psu_shd.g_old_rec.provisional_end_date;
505: End If;
506: If (p_rec.actual_start_date = hr_api.g_date) then

Line 506: If (p_rec.actual_start_date = hr_api.g_date) then

502: If (p_rec.provisional_end_date = hr_api.g_date) then
503: p_rec.provisional_end_date :=
504: pqh_psu_shd.g_old_rec.provisional_end_date;
505: End If;
506: If (p_rec.actual_start_date = hr_api.g_date) then
507: p_rec.actual_start_date :=
508: pqh_psu_shd.g_old_rec.actual_start_date;
509: End If;
510: If (p_rec.actual_end_date = hr_api.g_date) then

Line 510: If (p_rec.actual_end_date = hr_api.g_date) then

506: If (p_rec.actual_start_date = hr_api.g_date) then
507: p_rec.actual_start_date :=
508: pqh_psu_shd.g_old_rec.actual_start_date;
509: End If;
510: If (p_rec.actual_end_date = hr_api.g_date) then
511: p_rec.actual_end_date :=
512: pqh_psu_shd.g_old_rec.actual_end_date;
513: End If;
514: If (p_rec.approval_flag = hr_api.g_varchar2) then

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

510: If (p_rec.actual_end_date = hr_api.g_date) then
511: p_rec.actual_end_date :=
512: pqh_psu_shd.g_old_rec.actual_end_date;
513: End If;
514: If (p_rec.approval_flag = hr_api.g_varchar2) then
515: p_rec.approval_flag :=
516: pqh_psu_shd.g_old_rec.approval_flag;
517: End If;
518: If (p_rec.comments = hr_api.g_varchar2) then

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

514: If (p_rec.approval_flag = hr_api.g_varchar2) then
515: p_rec.approval_flag :=
516: pqh_psu_shd.g_old_rec.approval_flag;
517: End If;
518: If (p_rec.comments = hr_api.g_varchar2) then
519: p_rec.comments :=
520: pqh_psu_shd.g_old_rec.comments;
521: End If;
522: If (p_rec.contact_person_id = hr_api.g_number) then

Line 522: If (p_rec.contact_person_id = hr_api.g_number) then

518: If (p_rec.comments = hr_api.g_varchar2) then
519: p_rec.comments :=
520: pqh_psu_shd.g_old_rec.comments;
521: End If;
522: If (p_rec.contact_person_id = hr_api.g_number) then
523: p_rec.contact_person_id :=
524: pqh_psu_shd.g_old_rec.contact_person_id;
525: End If;
526: If (p_rec.contact_relationship = hr_api.g_varchar2) then

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

522: If (p_rec.contact_person_id = hr_api.g_number) then
523: p_rec.contact_person_id :=
524: pqh_psu_shd.g_old_rec.contact_person_id;
525: End If;
526: If (p_rec.contact_relationship = hr_api.g_varchar2) then
527: p_rec.contact_relationship :=
528: pqh_psu_shd.g_old_rec.contact_relationship;
529: End If;
530: If (p_rec.external_organization_id = hr_api.g_number) then

Line 530: If (p_rec.external_organization_id = hr_api.g_number) then

526: If (p_rec.contact_relationship = hr_api.g_varchar2) then
527: p_rec.contact_relationship :=
528: pqh_psu_shd.g_old_rec.contact_relationship;
529: End If;
530: If (p_rec.external_organization_id = hr_api.g_number) then
531: p_rec.external_organization_id :=
532: pqh_psu_shd.g_old_rec.external_organization_id;
533: End If;
534: If (p_rec.renewal_flag = hr_api.g_varchar2) then

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

530: If (p_rec.external_organization_id = hr_api.g_number) then
531: p_rec.external_organization_id :=
532: pqh_psu_shd.g_old_rec.external_organization_id;
533: End If;
534: If (p_rec.renewal_flag = hr_api.g_varchar2) then
535: p_rec.renewal_flag :=
536: pqh_psu_shd.g_old_rec.renewal_flag;
537: End If;
538: If (p_rec.renew_stat_situation_id = hr_api.g_number) then

Line 538: If (p_rec.renew_stat_situation_id = hr_api.g_number) then

534: If (p_rec.renewal_flag = hr_api.g_varchar2) then
535: p_rec.renewal_flag :=
536: pqh_psu_shd.g_old_rec.renewal_flag;
537: End If;
538: If (p_rec.renew_stat_situation_id = hr_api.g_number) then
539: p_rec.renew_stat_situation_id :=
540: pqh_psu_shd.g_old_rec.renew_stat_situation_id;
541: End If;
542: If (p_rec.seconded_career_id = hr_api.g_number) then

Line 542: If (p_rec.seconded_career_id = hr_api.g_number) then

538: If (p_rec.renew_stat_situation_id = hr_api.g_number) then
539: p_rec.renew_stat_situation_id :=
540: pqh_psu_shd.g_old_rec.renew_stat_situation_id;
541: End If;
542: If (p_rec.seconded_career_id = hr_api.g_number) then
543: p_rec.seconded_career_id :=
544: pqh_psu_shd.g_old_rec.seconded_career_id;
545: End If;
546: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

542: If (p_rec.seconded_career_id = hr_api.g_number) then
543: p_rec.seconded_career_id :=
544: pqh_psu_shd.g_old_rec.seconded_career_id;
545: End If;
546: If (p_rec.attribute_category = hr_api.g_varchar2) then
547: p_rec.attribute_category :=
548: pqh_psu_shd.g_old_rec.attribute_category;
549: End If;
550: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

546: If (p_rec.attribute_category = hr_api.g_varchar2) then
547: p_rec.attribute_category :=
548: pqh_psu_shd.g_old_rec.attribute_category;
549: End If;
550: If (p_rec.attribute1 = hr_api.g_varchar2) then
551: p_rec.attribute1 :=
552: pqh_psu_shd.g_old_rec.attribute1;
553: End If;
554: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

550: If (p_rec.attribute1 = hr_api.g_varchar2) then
551: p_rec.attribute1 :=
552: pqh_psu_shd.g_old_rec.attribute1;
553: End If;
554: If (p_rec.attribute2 = hr_api.g_varchar2) then
555: p_rec.attribute2 :=
556: pqh_psu_shd.g_old_rec.attribute2;
557: End If;
558: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

554: If (p_rec.attribute2 = hr_api.g_varchar2) then
555: p_rec.attribute2 :=
556: pqh_psu_shd.g_old_rec.attribute2;
557: End If;
558: If (p_rec.attribute3 = hr_api.g_varchar2) then
559: p_rec.attribute3 :=
560: pqh_psu_shd.g_old_rec.attribute3;
561: End If;
562: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

558: If (p_rec.attribute3 = hr_api.g_varchar2) then
559: p_rec.attribute3 :=
560: pqh_psu_shd.g_old_rec.attribute3;
561: End If;
562: If (p_rec.attribute4 = hr_api.g_varchar2) then
563: p_rec.attribute4 :=
564: pqh_psu_shd.g_old_rec.attribute4;
565: End If;
566: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

562: If (p_rec.attribute4 = hr_api.g_varchar2) then
563: p_rec.attribute4 :=
564: pqh_psu_shd.g_old_rec.attribute4;
565: End If;
566: If (p_rec.attribute5 = hr_api.g_varchar2) then
567: p_rec.attribute5 :=
568: pqh_psu_shd.g_old_rec.attribute5;
569: End If;
570: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

566: If (p_rec.attribute5 = hr_api.g_varchar2) then
567: p_rec.attribute5 :=
568: pqh_psu_shd.g_old_rec.attribute5;
569: End If;
570: If (p_rec.attribute6 = hr_api.g_varchar2) then
571: p_rec.attribute6 :=
572: pqh_psu_shd.g_old_rec.attribute6;
573: End If;
574: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

570: If (p_rec.attribute6 = hr_api.g_varchar2) then
571: p_rec.attribute6 :=
572: pqh_psu_shd.g_old_rec.attribute6;
573: End If;
574: If (p_rec.attribute7 = hr_api.g_varchar2) then
575: p_rec.attribute7 :=
576: pqh_psu_shd.g_old_rec.attribute7;
577: End If;
578: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

574: If (p_rec.attribute7 = hr_api.g_varchar2) then
575: p_rec.attribute7 :=
576: pqh_psu_shd.g_old_rec.attribute7;
577: End If;
578: If (p_rec.attribute8 = hr_api.g_varchar2) then
579: p_rec.attribute8 :=
580: pqh_psu_shd.g_old_rec.attribute8;
581: End If;
582: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

578: If (p_rec.attribute8 = hr_api.g_varchar2) then
579: p_rec.attribute8 :=
580: pqh_psu_shd.g_old_rec.attribute8;
581: End If;
582: If (p_rec.attribute9 = hr_api.g_varchar2) then
583: p_rec.attribute9 :=
584: pqh_psu_shd.g_old_rec.attribute9;
585: End If;
586: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

582: If (p_rec.attribute9 = hr_api.g_varchar2) then
583: p_rec.attribute9 :=
584: pqh_psu_shd.g_old_rec.attribute9;
585: End If;
586: If (p_rec.attribute10 = hr_api.g_varchar2) then
587: p_rec.attribute10 :=
588: pqh_psu_shd.g_old_rec.attribute10;
589: End If;
590: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

586: If (p_rec.attribute10 = hr_api.g_varchar2) then
587: p_rec.attribute10 :=
588: pqh_psu_shd.g_old_rec.attribute10;
589: End If;
590: If (p_rec.attribute11 = hr_api.g_varchar2) then
591: p_rec.attribute11 :=
592: pqh_psu_shd.g_old_rec.attribute11;
593: End If;
594: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

590: If (p_rec.attribute11 = hr_api.g_varchar2) then
591: p_rec.attribute11 :=
592: pqh_psu_shd.g_old_rec.attribute11;
593: End If;
594: If (p_rec.attribute12 = hr_api.g_varchar2) then
595: p_rec.attribute12 :=
596: pqh_psu_shd.g_old_rec.attribute12;
597: End If;
598: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

594: If (p_rec.attribute12 = hr_api.g_varchar2) then
595: p_rec.attribute12 :=
596: pqh_psu_shd.g_old_rec.attribute12;
597: End If;
598: If (p_rec.attribute13 = hr_api.g_varchar2) then
599: p_rec.attribute13 :=
600: pqh_psu_shd.g_old_rec.attribute13;
601: End If;
602: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

598: If (p_rec.attribute13 = hr_api.g_varchar2) then
599: p_rec.attribute13 :=
600: pqh_psu_shd.g_old_rec.attribute13;
601: End If;
602: If (p_rec.attribute14 = hr_api.g_varchar2) then
603: p_rec.attribute14 :=
604: pqh_psu_shd.g_old_rec.attribute14;
605: End If;
606: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

602: If (p_rec.attribute14 = hr_api.g_varchar2) then
603: p_rec.attribute14 :=
604: pqh_psu_shd.g_old_rec.attribute14;
605: End If;
606: If (p_rec.attribute15 = hr_api.g_varchar2) then
607: p_rec.attribute15 :=
608: pqh_psu_shd.g_old_rec.attribute15;
609: End If;
610: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

606: If (p_rec.attribute15 = hr_api.g_varchar2) then
607: p_rec.attribute15 :=
608: pqh_psu_shd.g_old_rec.attribute15;
609: End If;
610: If (p_rec.attribute16 = hr_api.g_varchar2) then
611: p_rec.attribute16 :=
612: pqh_psu_shd.g_old_rec.attribute16;
613: End If;
614: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

610: If (p_rec.attribute16 = hr_api.g_varchar2) then
611: p_rec.attribute16 :=
612: pqh_psu_shd.g_old_rec.attribute16;
613: End If;
614: If (p_rec.attribute17 = hr_api.g_varchar2) then
615: p_rec.attribute17 :=
616: pqh_psu_shd.g_old_rec.attribute17;
617: End If;
618: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

614: If (p_rec.attribute17 = hr_api.g_varchar2) then
615: p_rec.attribute17 :=
616: pqh_psu_shd.g_old_rec.attribute17;
617: End If;
618: If (p_rec.attribute18 = hr_api.g_varchar2) then
619: p_rec.attribute18 :=
620: pqh_psu_shd.g_old_rec.attribute18;
621: End If;
622: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

618: If (p_rec.attribute18 = hr_api.g_varchar2) then
619: p_rec.attribute18 :=
620: pqh_psu_shd.g_old_rec.attribute18;
621: End If;
622: If (p_rec.attribute19 = hr_api.g_varchar2) then
623: p_rec.attribute19 :=
624: pqh_psu_shd.g_old_rec.attribute19;
625: End If;
626: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

622: If (p_rec.attribute19 = hr_api.g_varchar2) then
623: p_rec.attribute19 :=
624: pqh_psu_shd.g_old_rec.attribute19;
625: End If;
626: If (p_rec.attribute20 = hr_api.g_varchar2) then
627: p_rec.attribute20 :=
628: pqh_psu_shd.g_old_rec.attribute20;
629: End If;
630: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

626: If (p_rec.attribute20 = hr_api.g_varchar2) then
627: p_rec.attribute20 :=
628: pqh_psu_shd.g_old_rec.attribute20;
629: End If;
630: If (p_rec.attribute21 = hr_api.g_varchar2) then
631: p_rec.attribute21 :=
632: pqh_psu_shd.g_old_rec.attribute21;
633: End If;
634: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

630: If (p_rec.attribute21 = hr_api.g_varchar2) then
631: p_rec.attribute21 :=
632: pqh_psu_shd.g_old_rec.attribute21;
633: End If;
634: If (p_rec.attribute22 = hr_api.g_varchar2) then
635: p_rec.attribute22 :=
636: pqh_psu_shd.g_old_rec.attribute22;
637: End If;
638: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

634: If (p_rec.attribute22 = hr_api.g_varchar2) then
635: p_rec.attribute22 :=
636: pqh_psu_shd.g_old_rec.attribute22;
637: End If;
638: If (p_rec.attribute23 = hr_api.g_varchar2) then
639: p_rec.attribute23 :=
640: pqh_psu_shd.g_old_rec.attribute23;
641: End If;
642: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

638: If (p_rec.attribute23 = hr_api.g_varchar2) then
639: p_rec.attribute23 :=
640: pqh_psu_shd.g_old_rec.attribute23;
641: End If;
642: If (p_rec.attribute24 = hr_api.g_varchar2) then
643: p_rec.attribute24 :=
644: pqh_psu_shd.g_old_rec.attribute24;
645: End If;
646: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

642: If (p_rec.attribute24 = hr_api.g_varchar2) then
643: p_rec.attribute24 :=
644: pqh_psu_shd.g_old_rec.attribute24;
645: End If;
646: If (p_rec.attribute25 = hr_api.g_varchar2) then
647: p_rec.attribute25 :=
648: pqh_psu_shd.g_old_rec.attribute25;
649: End If;
650: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

646: If (p_rec.attribute25 = hr_api.g_varchar2) then
647: p_rec.attribute25 :=
648: pqh_psu_shd.g_old_rec.attribute25;
649: End If;
650: If (p_rec.attribute26 = hr_api.g_varchar2) then
651: p_rec.attribute26 :=
652: pqh_psu_shd.g_old_rec.attribute26;
653: End If;
654: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

650: If (p_rec.attribute26 = hr_api.g_varchar2) then
651: p_rec.attribute26 :=
652: pqh_psu_shd.g_old_rec.attribute26;
653: End If;
654: If (p_rec.attribute27 = hr_api.g_varchar2) then
655: p_rec.attribute27 :=
656: pqh_psu_shd.g_old_rec.attribute27;
657: End If;
658: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

654: If (p_rec.attribute27 = hr_api.g_varchar2) then
655: p_rec.attribute27 :=
656: pqh_psu_shd.g_old_rec.attribute27;
657: End If;
658: If (p_rec.attribute28 = hr_api.g_varchar2) then
659: p_rec.attribute28 :=
660: pqh_psu_shd.g_old_rec.attribute28;
661: End If;
662: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

658: If (p_rec.attribute28 = hr_api.g_varchar2) then
659: p_rec.attribute28 :=
660: pqh_psu_shd.g_old_rec.attribute28;
661: End If;
662: If (p_rec.attribute29 = hr_api.g_varchar2) then
663: p_rec.attribute29 :=
664: pqh_psu_shd.g_old_rec.attribute29;
665: End If;
666: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

662: If (p_rec.attribute29 = hr_api.g_varchar2) then
663: p_rec.attribute29 :=
664: pqh_psu_shd.g_old_rec.attribute29;
665: End If;
666: If (p_rec.attribute30 = hr_api.g_varchar2) then
667: p_rec.attribute30 :=
668: pqh_psu_shd.g_old_rec.attribute30;
669: End If;
670: --

Line 734: ,p_statutory_situation_id in number default hr_api.g_number

730: Procedure upd
731: (p_effective_date in date
732: ,p_emp_stat_situation_id in number
733: ,p_object_version_number in out nocopy number
734: ,p_statutory_situation_id in number default hr_api.g_number
735: ,p_person_id in number default hr_api.g_number
736: ,p_provisional_start_date in date default hr_api.g_date
737: ,p_provisional_end_date in date default hr_api.g_date
738: ,p_actual_start_date in date default hr_api.g_date

Line 735: ,p_person_id in number default hr_api.g_number

731: (p_effective_date in date
732: ,p_emp_stat_situation_id in number
733: ,p_object_version_number in out nocopy number
734: ,p_statutory_situation_id in number default hr_api.g_number
735: ,p_person_id in number default hr_api.g_number
736: ,p_provisional_start_date in date default hr_api.g_date
737: ,p_provisional_end_date in date default hr_api.g_date
738: ,p_actual_start_date in date default hr_api.g_date
739: ,p_actual_end_date in date default hr_api.g_date

Line 736: ,p_provisional_start_date in date default hr_api.g_date

732: ,p_emp_stat_situation_id in number
733: ,p_object_version_number in out nocopy number
734: ,p_statutory_situation_id in number default hr_api.g_number
735: ,p_person_id in number default hr_api.g_number
736: ,p_provisional_start_date in date default hr_api.g_date
737: ,p_provisional_end_date in date default hr_api.g_date
738: ,p_actual_start_date in date default hr_api.g_date
739: ,p_actual_end_date in date default hr_api.g_date
740: ,p_approval_flag in varchar2 default hr_api.g_varchar2

Line 737: ,p_provisional_end_date in date default hr_api.g_date

733: ,p_object_version_number in out nocopy number
734: ,p_statutory_situation_id in number default hr_api.g_number
735: ,p_person_id in number default hr_api.g_number
736: ,p_provisional_start_date in date default hr_api.g_date
737: ,p_provisional_end_date in date default hr_api.g_date
738: ,p_actual_start_date in date default hr_api.g_date
739: ,p_actual_end_date in date default hr_api.g_date
740: ,p_approval_flag in varchar2 default hr_api.g_varchar2
741: ,p_comments in varchar2 default hr_api.g_varchar2

Line 738: ,p_actual_start_date in date default hr_api.g_date

734: ,p_statutory_situation_id in number default hr_api.g_number
735: ,p_person_id in number default hr_api.g_number
736: ,p_provisional_start_date in date default hr_api.g_date
737: ,p_provisional_end_date in date default hr_api.g_date
738: ,p_actual_start_date in date default hr_api.g_date
739: ,p_actual_end_date in date default hr_api.g_date
740: ,p_approval_flag in varchar2 default hr_api.g_varchar2
741: ,p_comments in varchar2 default hr_api.g_varchar2
742: ,p_contact_person_id in number default hr_api.g_number

Line 739: ,p_actual_end_date in date default hr_api.g_date

735: ,p_person_id in number default hr_api.g_number
736: ,p_provisional_start_date in date default hr_api.g_date
737: ,p_provisional_end_date in date default hr_api.g_date
738: ,p_actual_start_date in date default hr_api.g_date
739: ,p_actual_end_date in date default hr_api.g_date
740: ,p_approval_flag in varchar2 default hr_api.g_varchar2
741: ,p_comments in varchar2 default hr_api.g_varchar2
742: ,p_contact_person_id in number default hr_api.g_number
743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2

Line 740: ,p_approval_flag in varchar2 default hr_api.g_varchar2

736: ,p_provisional_start_date in date default hr_api.g_date
737: ,p_provisional_end_date in date default hr_api.g_date
738: ,p_actual_start_date in date default hr_api.g_date
739: ,p_actual_end_date in date default hr_api.g_date
740: ,p_approval_flag in varchar2 default hr_api.g_varchar2
741: ,p_comments in varchar2 default hr_api.g_varchar2
742: ,p_contact_person_id in number default hr_api.g_number
743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
744: ,p_external_organization_id in number default hr_api.g_number

Line 741: ,p_comments in varchar2 default hr_api.g_varchar2

737: ,p_provisional_end_date in date default hr_api.g_date
738: ,p_actual_start_date in date default hr_api.g_date
739: ,p_actual_end_date in date default hr_api.g_date
740: ,p_approval_flag in varchar2 default hr_api.g_varchar2
741: ,p_comments in varchar2 default hr_api.g_varchar2
742: ,p_contact_person_id in number default hr_api.g_number
743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
744: ,p_external_organization_id in number default hr_api.g_number
745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2

Line 742: ,p_contact_person_id in number default hr_api.g_number

738: ,p_actual_start_date in date default hr_api.g_date
739: ,p_actual_end_date in date default hr_api.g_date
740: ,p_approval_flag in varchar2 default hr_api.g_varchar2
741: ,p_comments in varchar2 default hr_api.g_varchar2
742: ,p_contact_person_id in number default hr_api.g_number
743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
744: ,p_external_organization_id in number default hr_api.g_number
745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
746: ,p_renew_stat_situation_id in number default hr_api.g_number

Line 743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2

739: ,p_actual_end_date in date default hr_api.g_date
740: ,p_approval_flag in varchar2 default hr_api.g_varchar2
741: ,p_comments in varchar2 default hr_api.g_varchar2
742: ,p_contact_person_id in number default hr_api.g_number
743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
744: ,p_external_organization_id in number default hr_api.g_number
745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
746: ,p_renew_stat_situation_id in number default hr_api.g_number
747: ,p_seconded_career_id in number default hr_api.g_number

Line 744: ,p_external_organization_id in number default hr_api.g_number

740: ,p_approval_flag in varchar2 default hr_api.g_varchar2
741: ,p_comments in varchar2 default hr_api.g_varchar2
742: ,p_contact_person_id in number default hr_api.g_number
743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
744: ,p_external_organization_id in number default hr_api.g_number
745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
746: ,p_renew_stat_situation_id in number default hr_api.g_number
747: ,p_seconded_career_id in number default hr_api.g_number
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2

741: ,p_comments in varchar2 default hr_api.g_varchar2
742: ,p_contact_person_id in number default hr_api.g_number
743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
744: ,p_external_organization_id in number default hr_api.g_number
745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
746: ,p_renew_stat_situation_id in number default hr_api.g_number
747: ,p_seconded_career_id in number default hr_api.g_number
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 746: ,p_renew_stat_situation_id in number default hr_api.g_number

742: ,p_contact_person_id in number default hr_api.g_number
743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
744: ,p_external_organization_id in number default hr_api.g_number
745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
746: ,p_renew_stat_situation_id in number default hr_api.g_number
747: ,p_seconded_career_id in number default hr_api.g_number
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 747: ,p_seconded_career_id in number default hr_api.g_number

743: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
744: ,p_external_organization_id in number default hr_api.g_number
745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
746: ,p_renew_stat_situation_id in number default hr_api.g_number
747: ,p_seconded_career_id in number default hr_api.g_number
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 748: ,p_attribute_category in varchar2 default hr_api.g_varchar2

744: ,p_external_organization_id in number default hr_api.g_number
745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
746: ,p_renew_stat_situation_id in number default hr_api.g_number
747: ,p_seconded_career_id in number default hr_api.g_number
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 749: ,p_attribute1 in varchar2 default hr_api.g_varchar2

745: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
746: ,p_renew_stat_situation_id in number default hr_api.g_number
747: ,p_seconded_career_id in number default hr_api.g_number
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 750: ,p_attribute2 in varchar2 default hr_api.g_varchar2

746: ,p_renew_stat_situation_id in number default hr_api.g_number
747: ,p_seconded_career_id in number default hr_api.g_number
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 751: ,p_attribute3 in varchar2 default hr_api.g_varchar2

747: ,p_seconded_career_id in number default hr_api.g_number
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 752: ,p_attribute4 in varchar2 default hr_api.g_varchar2

748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 753: ,p_attribute5 in varchar2 default hr_api.g_varchar2

749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 754: ,p_attribute6 in varchar2 default hr_api.g_varchar2

750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 755: ,p_attribute7 in varchar2 default hr_api.g_varchar2

751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 756: ,p_attribute8 in varchar2 default hr_api.g_varchar2

752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 757: ,p_attribute9 in varchar2 default hr_api.g_varchar2

753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 758: ,p_attribute10 in varchar2 default hr_api.g_varchar2

754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 759: ,p_attribute11 in varchar2 default hr_api.g_varchar2

755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 760: ,p_attribute12 in varchar2 default hr_api.g_varchar2

756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 761: ,p_attribute13 in varchar2 default hr_api.g_varchar2

757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 762: ,p_attribute14 in varchar2 default hr_api.g_varchar2

758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 763: ,p_attribute15 in varchar2 default hr_api.g_varchar2

759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 764: ,p_attribute16 in varchar2 default hr_api.g_varchar2

760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 765: ,p_attribute17 in varchar2 default hr_api.g_varchar2

761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 766: ,p_attribute18 in varchar2 default hr_api.g_varchar2

762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: ,p_attribute21 in varchar2 default hr_api.g_varchar2
770: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 767: ,p_attribute19 in varchar2 default hr_api.g_varchar2

763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: ,p_attribute21 in varchar2 default hr_api.g_varchar2
770: ,p_attribute22 in varchar2 default hr_api.g_varchar2
771: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 768: ,p_attribute20 in varchar2 default hr_api.g_varchar2

764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: ,p_attribute21 in varchar2 default hr_api.g_varchar2
770: ,p_attribute22 in varchar2 default hr_api.g_varchar2
771: ,p_attribute23 in varchar2 default hr_api.g_varchar2
772: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 769: ,p_attribute21 in varchar2 default hr_api.g_varchar2

765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: ,p_attribute21 in varchar2 default hr_api.g_varchar2
770: ,p_attribute22 in varchar2 default hr_api.g_varchar2
771: ,p_attribute23 in varchar2 default hr_api.g_varchar2
772: ,p_attribute24 in varchar2 default hr_api.g_varchar2
773: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 770: ,p_attribute22 in varchar2 default hr_api.g_varchar2

766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: ,p_attribute21 in varchar2 default hr_api.g_varchar2
770: ,p_attribute22 in varchar2 default hr_api.g_varchar2
771: ,p_attribute23 in varchar2 default hr_api.g_varchar2
772: ,p_attribute24 in varchar2 default hr_api.g_varchar2
773: ,p_attribute25 in varchar2 default hr_api.g_varchar2
774: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 771: ,p_attribute23 in varchar2 default hr_api.g_varchar2

767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: ,p_attribute21 in varchar2 default hr_api.g_varchar2
770: ,p_attribute22 in varchar2 default hr_api.g_varchar2
771: ,p_attribute23 in varchar2 default hr_api.g_varchar2
772: ,p_attribute24 in varchar2 default hr_api.g_varchar2
773: ,p_attribute25 in varchar2 default hr_api.g_varchar2
774: ,p_attribute26 in varchar2 default hr_api.g_varchar2
775: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 772: ,p_attribute24 in varchar2 default hr_api.g_varchar2

768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: ,p_attribute21 in varchar2 default hr_api.g_varchar2
770: ,p_attribute22 in varchar2 default hr_api.g_varchar2
771: ,p_attribute23 in varchar2 default hr_api.g_varchar2
772: ,p_attribute24 in varchar2 default hr_api.g_varchar2
773: ,p_attribute25 in varchar2 default hr_api.g_varchar2
774: ,p_attribute26 in varchar2 default hr_api.g_varchar2
775: ,p_attribute27 in varchar2 default hr_api.g_varchar2
776: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 773: ,p_attribute25 in varchar2 default hr_api.g_varchar2

769: ,p_attribute21 in varchar2 default hr_api.g_varchar2
770: ,p_attribute22 in varchar2 default hr_api.g_varchar2
771: ,p_attribute23 in varchar2 default hr_api.g_varchar2
772: ,p_attribute24 in varchar2 default hr_api.g_varchar2
773: ,p_attribute25 in varchar2 default hr_api.g_varchar2
774: ,p_attribute26 in varchar2 default hr_api.g_varchar2
775: ,p_attribute27 in varchar2 default hr_api.g_varchar2
776: ,p_attribute28 in varchar2 default hr_api.g_varchar2
777: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 774: ,p_attribute26 in varchar2 default hr_api.g_varchar2

770: ,p_attribute22 in varchar2 default hr_api.g_varchar2
771: ,p_attribute23 in varchar2 default hr_api.g_varchar2
772: ,p_attribute24 in varchar2 default hr_api.g_varchar2
773: ,p_attribute25 in varchar2 default hr_api.g_varchar2
774: ,p_attribute26 in varchar2 default hr_api.g_varchar2
775: ,p_attribute27 in varchar2 default hr_api.g_varchar2
776: ,p_attribute28 in varchar2 default hr_api.g_varchar2
777: ,p_attribute29 in varchar2 default hr_api.g_varchar2
778: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 775: ,p_attribute27 in varchar2 default hr_api.g_varchar2

771: ,p_attribute23 in varchar2 default hr_api.g_varchar2
772: ,p_attribute24 in varchar2 default hr_api.g_varchar2
773: ,p_attribute25 in varchar2 default hr_api.g_varchar2
774: ,p_attribute26 in varchar2 default hr_api.g_varchar2
775: ,p_attribute27 in varchar2 default hr_api.g_varchar2
776: ,p_attribute28 in varchar2 default hr_api.g_varchar2
777: ,p_attribute29 in varchar2 default hr_api.g_varchar2
778: ,p_attribute30 in varchar2 default hr_api.g_varchar2
779: ) is

Line 776: ,p_attribute28 in varchar2 default hr_api.g_varchar2

772: ,p_attribute24 in varchar2 default hr_api.g_varchar2
773: ,p_attribute25 in varchar2 default hr_api.g_varchar2
774: ,p_attribute26 in varchar2 default hr_api.g_varchar2
775: ,p_attribute27 in varchar2 default hr_api.g_varchar2
776: ,p_attribute28 in varchar2 default hr_api.g_varchar2
777: ,p_attribute29 in varchar2 default hr_api.g_varchar2
778: ,p_attribute30 in varchar2 default hr_api.g_varchar2
779: ) is
780: --

Line 777: ,p_attribute29 in varchar2 default hr_api.g_varchar2

773: ,p_attribute25 in varchar2 default hr_api.g_varchar2
774: ,p_attribute26 in varchar2 default hr_api.g_varchar2
775: ,p_attribute27 in varchar2 default hr_api.g_varchar2
776: ,p_attribute28 in varchar2 default hr_api.g_varchar2
777: ,p_attribute29 in varchar2 default hr_api.g_varchar2
778: ,p_attribute30 in varchar2 default hr_api.g_varchar2
779: ) is
780: --
781: l_rec pqh_psu_shd.g_rec_type;

Line 778: ,p_attribute30 in varchar2 default hr_api.g_varchar2

774: ,p_attribute26 in varchar2 default hr_api.g_varchar2
775: ,p_attribute27 in varchar2 default hr_api.g_varchar2
776: ,p_attribute28 in varchar2 default hr_api.g_varchar2
777: ,p_attribute29 in varchar2 default hr_api.g_varchar2
778: ,p_attribute30 in varchar2 default hr_api.g_varchar2
779: ) is
780: --
781: l_rec pqh_psu_shd.g_rec_type;
782: l_proc varchar2(72) := g_package||'upd';