[Home] [Help]
117: --deleting the transactions that are in status 'W' to avoid inadvertent SFL
118:
119: for t_rec in cur_trans(p_selected_person_id)
120: loop
121: hr_transaction_api.rollback_transaction(
122: p_transaction_id => t_rec.transaction_id);
123: end loop;
124:
125:
176: --
177: -- Delete transaction step if exist
178: --
179:
180: IF (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
181: ,p_item_key => p_item_key
182: ,p_activity_id => p_act_id) ) THEN
183:
184: hr_transaction_api.get_transaction_step_info(
180: IF (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
181: ,p_item_key => p_item_key
182: ,p_activity_id => p_act_id) ) THEN
183:
184: hr_transaction_api.get_transaction_step_info(
185: p_item_type => p_item_type
186: ,p_item_key => p_item_key
187: ,p_activity_id => p_act_id
188: ,p_transaction_step_id => l_old_transaction_step_id
188: ,p_transaction_step_id => l_old_transaction_step_id
189: ,p_object_version_number => l_old_object_version_number);
190:
191:
192: hr_transaction_api.delete_transaction_step(
193: p_validate => false
194: ,p_transaction_step_id => l_old_transaction_step_id
195: ,p_person_id => p_login_person_id
196: ,p_object_version_number => l_old_object_version_number);
199:
200: --
201: -- Create a transaction step
202: --
203: hr_transaction_api.create_transaction_step
204: (p_validate => false
205: ,p_creator_person_id => p_login_person_id
206: ,p_transaction_id => l_transaction_id
207: ,p_api_name => g_package || '.PROCESS_API'
411:
412: IF p_transaction_step_id IS NOT NULL AND
413: p_login_person_id IS NOT NULL THEN
414:
415: hr_transaction_api.set_number_value
416: (p_transaction_step_id => p_transaction_step_id
417: ,p_person_id => p_login_person_id
418: ,p_name => 'P_PERSON_ID'
419: ,p_value => p_person_id);
417: ,p_person_id => p_login_person_id
418: ,p_name => 'P_PERSON_ID'
419: ,p_value => p_person_id);
420:
421: hr_transaction_api.set_number_value
422: (p_transaction_step_id => p_transaction_step_id
423: ,p_person_id => p_login_person_id
424: ,p_name => 'P_DOCUMENT_TYPE_ID'
425: ,p_value => p_document_type_id);
423: ,p_person_id => p_login_person_id
424: ,p_name => 'P_DOCUMENT_TYPE_ID'
425: ,p_value => p_document_type_id);
426:
427: hr_transaction_api.set_number_value
428: (p_transaction_step_id => p_transaction_step_id
429: ,p_person_id => p_login_person_id
430: ,p_name => 'P_DOCUMENT_EXTRA_INFO_ID'
431: ,p_value => p_document_extra_info_id);
431: ,p_value => p_document_extra_info_id);
432:
433: if p_action_mode = 'DOR_INSERT' then
434:
435: hr_transaction_api.set_date_value
436: (p_transaction_step_id => p_transaction_step_id
437: ,p_person_id => p_login_person_id
438: ,p_name => 'P_DATE_FROM'
439: ,p_value => p_date_from);
437: ,p_person_id => p_login_person_id
438: ,p_name => 'P_DATE_FROM'
439: ,p_value => p_date_from);
440:
441: hr_transaction_api.set_date_value
442: (p_transaction_step_id => p_transaction_step_id
443: ,p_person_id => p_login_person_id
444: ,p_name => 'P_DATE_TO'
445: ,p_value => p_date_to);
443: ,p_person_id => p_login_person_id
444: ,p_name => 'P_DATE_TO'
445: ,p_value => p_date_to);
446:
447: hr_transaction_api.set_varchar2_value
448: (p_transaction_step_id => p_transaction_step_id
449: ,p_person_id => p_login_person_id
450: ,p_name => 'P_DOCUMENT_NUMBER'
451: ,p_value => p_document_number);
449: ,p_person_id => p_login_person_id
450: ,p_name => 'P_DOCUMENT_NUMBER'
451: ,p_value => p_document_number);
452:
453: hr_transaction_api.set_varchar2_value
454: (p_transaction_step_id => p_transaction_step_id
455: ,p_person_id => p_login_person_id
456: ,p_name => 'P_ISSUED_BY'
457: ,p_value => p_issued_by);
455: ,p_person_id => p_login_person_id
456: ,p_name => 'P_ISSUED_BY'
457: ,p_value => p_issued_by);
458:
459: hr_transaction_api.set_varchar2_value
460: (p_transaction_step_id => p_transaction_step_id
461: ,p_person_id => p_login_person_id
462: ,p_name => 'P_ISSUED_AT'
463: ,p_value => p_issued_at);
461: ,p_person_id => p_login_person_id
462: ,p_name => 'P_ISSUED_AT'
463: ,p_value => p_issued_at);
464:
465: hr_transaction_api.set_date_value
466: (p_transaction_step_id => p_transaction_step_id
467: ,p_person_id => p_login_person_id
468: ,p_name => 'P_ISSUED_DATE'
469: ,p_value => p_issued_date);
467: ,p_person_id => p_login_person_id
468: ,p_name => 'P_ISSUED_DATE'
469: ,p_value => p_issued_date);
470:
471: hr_transaction_api.set_varchar2_value
472: (p_transaction_step_id => p_transaction_step_id
473: ,p_person_id => p_login_person_id
474: ,p_name => 'P_ISSUING_AUTHORITY'
475: ,p_value => p_issuing_authority);
473: ,p_person_id => p_login_person_id
474: ,p_name => 'P_ISSUING_AUTHORITY'
475: ,p_value => p_issuing_authority);
476:
477: hr_transaction_api.set_number_value
478: (p_transaction_step_id => p_transaction_step_id
479: ,p_person_id => p_login_person_id
480: ,p_name => 'P_VERIFIED_BY'
481: ,p_value => p_verified_by);
479: ,p_person_id => p_login_person_id
480: ,p_name => 'P_VERIFIED_BY'
481: ,p_value => p_verified_by);
482:
483: hr_transaction_api.set_date_value
484: (p_transaction_step_id => p_transaction_step_id
485: ,p_person_id => p_login_person_id
486: ,p_name => 'P_VERIFIED_DATE'
487: ,p_value => p_verified_date);
485: ,p_person_id => p_login_person_id
486: ,p_name => 'P_VERIFIED_DATE'
487: ,p_value => p_verified_date);
488:
489: hr_transaction_api.set_varchar2_value
490: (p_transaction_step_id => p_transaction_step_id
491: ,p_person_id => p_login_person_id
492: ,p_name => 'P_RELATED_OBJECT_NAME'
493: ,p_value => p_related_object_name);
491: ,p_person_id => p_login_person_id
492: ,p_name => 'P_RELATED_OBJECT_NAME'
493: ,p_value => p_related_object_name);
494:
495: hr_transaction_api.set_varchar2_value
496: (p_transaction_step_id => p_transaction_step_id
497: ,p_person_id => p_login_person_id
498: ,p_name => 'P_RELATED_OBJECT_ID_COL'
499: ,p_value => p_related_object_id_col);
497: ,p_person_id => p_login_person_id
498: ,p_name => 'P_RELATED_OBJECT_ID_COL'
499: ,p_value => p_related_object_id_col);
500:
501: hr_transaction_api.set_number_value
502: (p_transaction_step_id => p_transaction_step_id
503: ,p_person_id => p_login_person_id
504: ,p_name => 'P_RELATED_OBJECT_ID'
505: ,p_value => p_related_object_id);
503: ,p_person_id => p_login_person_id
504: ,p_name => 'P_RELATED_OBJECT_ID'
505: ,p_value => p_related_object_id);
506:
507: hr_transaction_api.set_varchar2_value
508: (p_transaction_step_id => p_transaction_step_id
509: ,p_person_id => p_login_person_id
510: ,p_name => 'P_DEI_ATTRIBUTE_CATEGORY'
511: ,p_value => p_dei_attribute_category);
509: ,p_person_id => p_login_person_id
510: ,p_name => 'P_DEI_ATTRIBUTE_CATEGORY'
511: ,p_value => p_dei_attribute_category);
512:
513: hr_transaction_api.set_varchar2_value
514: (p_transaction_step_id => p_transaction_step_id
515: ,p_person_id => p_login_person_id
516: ,p_name => 'P_DEI_ATTRIBUTE1'
517: ,p_value => p_dei_attribute1);
515: ,p_person_id => p_login_person_id
516: ,p_name => 'P_DEI_ATTRIBUTE1'
517: ,p_value => p_dei_attribute1);
518:
519: hr_transaction_api.set_varchar2_value
520: (p_transaction_step_id => p_transaction_step_id
521: ,p_person_id => p_login_person_id
522: ,p_name => 'P_DEI_ATTRIBUTE2'
523: ,p_value => p_dei_attribute2);
521: ,p_person_id => p_login_person_id
522: ,p_name => 'P_DEI_ATTRIBUTE2'
523: ,p_value => p_dei_attribute2);
524:
525: hr_transaction_api.set_varchar2_value
526: (p_transaction_step_id => p_transaction_step_id
527: ,p_person_id => p_login_person_id
528: ,p_name => 'P_DEI_ATTRIBUTE3'
529: ,p_value => p_dei_attribute3);
527: ,p_person_id => p_login_person_id
528: ,p_name => 'P_DEI_ATTRIBUTE3'
529: ,p_value => p_dei_attribute3);
530:
531: hr_transaction_api.set_varchar2_value
532: (p_transaction_step_id => p_transaction_step_id
533: ,p_person_id => p_login_person_id
534: ,p_name => 'P_DEI_ATTRIBUTE4'
535: ,p_value => p_dei_attribute4);
533: ,p_person_id => p_login_person_id
534: ,p_name => 'P_DEI_ATTRIBUTE4'
535: ,p_value => p_dei_attribute4);
536:
537: hr_transaction_api.set_varchar2_value
538: (p_transaction_step_id => p_transaction_step_id
539: ,p_person_id => p_login_person_id
540: ,p_name => 'P_DEI_ATTRIBUTE5'
541: ,p_value => p_dei_attribute5);
539: ,p_person_id => p_login_person_id
540: ,p_name => 'P_DEI_ATTRIBUTE5'
541: ,p_value => p_dei_attribute5);
542:
543: hr_transaction_api.set_varchar2_value
544: (p_transaction_step_id => p_transaction_step_id
545: ,p_person_id => p_login_person_id
546: ,p_name => 'P_DEI_ATTRIBUTE6'
547: ,p_value => p_dei_attribute6);
545: ,p_person_id => p_login_person_id
546: ,p_name => 'P_DEI_ATTRIBUTE6'
547: ,p_value => p_dei_attribute6);
548:
549: hr_transaction_api.set_varchar2_value
550: (p_transaction_step_id => p_transaction_step_id
551: ,p_person_id => p_login_person_id
552: ,p_name => 'P_DEI_ATTRIBUTE7'
553: ,p_value => p_dei_attribute7);
551: ,p_person_id => p_login_person_id
552: ,p_name => 'P_DEI_ATTRIBUTE7'
553: ,p_value => p_dei_attribute7);
554:
555: hr_transaction_api.set_varchar2_value
556: (p_transaction_step_id => p_transaction_step_id
557: ,p_person_id => p_login_person_id
558: ,p_name => 'P_DEI_ATTRIBUTE8'
559: ,p_value => p_dei_attribute8);
557: ,p_person_id => p_login_person_id
558: ,p_name => 'P_DEI_ATTRIBUTE8'
559: ,p_value => p_dei_attribute8);
560:
561: hr_transaction_api.set_varchar2_value
562: (p_transaction_step_id => p_transaction_step_id
563: ,p_person_id => p_login_person_id
564: ,p_name => 'P_DEI_ATTRIBUTE9'
565: ,p_value => p_dei_attribute9);
563: ,p_person_id => p_login_person_id
564: ,p_name => 'P_DEI_ATTRIBUTE9'
565: ,p_value => p_dei_attribute9);
566:
567: hr_transaction_api.set_varchar2_value
568: (p_transaction_step_id => p_transaction_step_id
569: ,p_person_id => p_login_person_id
570: ,p_name => 'P_DEI_ATTRIBUTE10'
571: ,p_value => p_dei_attribute10);
569: ,p_person_id => p_login_person_id
570: ,p_name => 'P_DEI_ATTRIBUTE10'
571: ,p_value => p_dei_attribute10);
572:
573: hr_transaction_api.set_varchar2_value
574: (p_transaction_step_id => p_transaction_step_id
575: ,p_person_id => p_login_person_id
576: ,p_name => 'P_DEI_ATTRIBUTE11'
577: ,p_value => p_dei_attribute11);
575: ,p_person_id => p_login_person_id
576: ,p_name => 'P_DEI_ATTRIBUTE11'
577: ,p_value => p_dei_attribute11);
578:
579: hr_transaction_api.set_varchar2_value
580: (p_transaction_step_id => p_transaction_step_id
581: ,p_person_id => p_login_person_id
582: ,p_name => 'P_DEI_ATTRIBUTE12'
583: ,p_value => p_dei_attribute12);
581: ,p_person_id => p_login_person_id
582: ,p_name => 'P_DEI_ATTRIBUTE12'
583: ,p_value => p_dei_attribute12);
584:
585: hr_transaction_api.set_varchar2_value
586: (p_transaction_step_id => p_transaction_step_id
587: ,p_person_id => p_login_person_id
588: ,p_name => 'P_DEI_ATTRIBUTE13'
589: ,p_value => p_dei_attribute13);
587: ,p_person_id => p_login_person_id
588: ,p_name => 'P_DEI_ATTRIBUTE13'
589: ,p_value => p_dei_attribute13);
590:
591: hr_transaction_api.set_varchar2_value
592: (p_transaction_step_id => p_transaction_step_id
593: ,p_person_id => p_login_person_id
594: ,p_name => 'P_DEI_ATTRIBUTE14'
595: ,p_value => p_dei_attribute14);
593: ,p_person_id => p_login_person_id
594: ,p_name => 'P_DEI_ATTRIBUTE14'
595: ,p_value => p_dei_attribute14);
596:
597: hr_transaction_api.set_varchar2_value
598: (p_transaction_step_id => p_transaction_step_id
599: ,p_person_id => p_login_person_id
600: ,p_name => 'P_DEI_ATTRIBUTE15'
601: ,p_value => p_dei_attribute15);
599: ,p_person_id => p_login_person_id
600: ,p_name => 'P_DEI_ATTRIBUTE15'
601: ,p_value => p_dei_attribute15);
602:
603: hr_transaction_api.set_varchar2_value
604: (p_transaction_step_id => p_transaction_step_id
605: ,p_person_id => p_login_person_id
606: ,p_name => 'P_DEI_ATTRIBUTE16'
607: ,p_value => p_dei_attribute16);
605: ,p_person_id => p_login_person_id
606: ,p_name => 'P_DEI_ATTRIBUTE16'
607: ,p_value => p_dei_attribute16);
608:
609: hr_transaction_api.set_varchar2_value
610: (p_transaction_step_id => p_transaction_step_id
611: ,p_person_id => p_login_person_id
612: ,p_name => 'P_DEI_ATTRIBUTE17'
613: ,p_value => p_dei_attribute17);
611: ,p_person_id => p_login_person_id
612: ,p_name => 'P_DEI_ATTRIBUTE17'
613: ,p_value => p_dei_attribute17);
614:
615: hr_transaction_api.set_varchar2_value
616: (p_transaction_step_id => p_transaction_step_id
617: ,p_person_id => p_login_person_id
618: ,p_name => 'P_DEI_ATTRIBUTE18'
619: ,p_value => p_dei_attribute18);
617: ,p_person_id => p_login_person_id
618: ,p_name => 'P_DEI_ATTRIBUTE18'
619: ,p_value => p_dei_attribute18);
620:
621: hr_transaction_api.set_varchar2_value
622: (p_transaction_step_id => p_transaction_step_id
623: ,p_person_id => p_login_person_id
624: ,p_name => 'P_DEI_ATTRIBUTE19'
625: ,p_value => p_dei_attribute19);
623: ,p_person_id => p_login_person_id
624: ,p_name => 'P_DEI_ATTRIBUTE19'
625: ,p_value => p_dei_attribute19);
626:
627: hr_transaction_api.set_varchar2_value
628: (p_transaction_step_id => p_transaction_step_id
629: ,p_person_id => p_login_person_id
630: ,p_name => 'P_DEI_ATTRIBUTE20'
631: ,p_value => p_dei_attribute20);
629: ,p_person_id => p_login_person_id
630: ,p_name => 'P_DEI_ATTRIBUTE20'
631: ,p_value => p_dei_attribute20);
632:
633: hr_transaction_api.set_varchar2_value
634: (p_transaction_step_id => p_transaction_step_id
635: ,p_person_id => p_login_person_id
636: ,p_name => 'P_DEI_ATTRIBUTE21'
637: ,p_value => p_dei_attribute21);
635: ,p_person_id => p_login_person_id
636: ,p_name => 'P_DEI_ATTRIBUTE21'
637: ,p_value => p_dei_attribute21);
638:
639: hr_transaction_api.set_varchar2_value
640: (p_transaction_step_id => p_transaction_step_id
641: ,p_person_id => p_login_person_id
642: ,p_name => 'P_DEI_ATTRIBUTE22'
643: ,p_value => p_dei_attribute22);
641: ,p_person_id => p_login_person_id
642: ,p_name => 'P_DEI_ATTRIBUTE22'
643: ,p_value => p_dei_attribute22);
644:
645: hr_transaction_api.set_varchar2_value
646: (p_transaction_step_id => p_transaction_step_id
647: ,p_person_id => p_login_person_id
648: ,p_name => 'P_DEI_ATTRIBUTE23'
649: ,p_value => p_dei_attribute23);
647: ,p_person_id => p_login_person_id
648: ,p_name => 'P_DEI_ATTRIBUTE23'
649: ,p_value => p_dei_attribute23);
650:
651: hr_transaction_api.set_varchar2_value
652: (p_transaction_step_id => p_transaction_step_id
653: ,p_person_id => p_login_person_id
654: ,p_name => 'P_DEI_ATTRIBUTE24'
655: ,p_value => p_dei_attribute24);
653: ,p_person_id => p_login_person_id
654: ,p_name => 'P_DEI_ATTRIBUTE24'
655: ,p_value => p_dei_attribute24);
656:
657: hr_transaction_api.set_varchar2_value
658: (p_transaction_step_id => p_transaction_step_id
659: ,p_person_id => p_login_person_id
660: ,p_name => 'P_DEI_ATTRIBUTE25'
661: ,p_value => p_dei_attribute25);
659: ,p_person_id => p_login_person_id
660: ,p_name => 'P_DEI_ATTRIBUTE25'
661: ,p_value => p_dei_attribute25);
662:
663: hr_transaction_api.set_varchar2_value
664: (p_transaction_step_id => p_transaction_step_id
665: ,p_person_id => p_login_person_id
666: ,p_name => 'P_DEI_ATTRIBUTE26'
667: ,p_value => p_dei_attribute26);
665: ,p_person_id => p_login_person_id
666: ,p_name => 'P_DEI_ATTRIBUTE26'
667: ,p_value => p_dei_attribute26);
668:
669: hr_transaction_api.set_varchar2_value
670: (p_transaction_step_id => p_transaction_step_id
671: ,p_person_id => p_login_person_id
672: ,p_name => 'P_DEI_ATTRIBUTE27'
673: ,p_value => p_dei_attribute27);
671: ,p_person_id => p_login_person_id
672: ,p_name => 'P_DEI_ATTRIBUTE27'
673: ,p_value => p_dei_attribute27);
674:
675: hr_transaction_api.set_varchar2_value
676: (p_transaction_step_id => p_transaction_step_id
677: ,p_person_id => p_login_person_id
678: ,p_name => 'P_DEI_ATTRIBUTE28'
679: ,p_value => p_dei_attribute28);
677: ,p_person_id => p_login_person_id
678: ,p_name => 'P_DEI_ATTRIBUTE28'
679: ,p_value => p_dei_attribute28);
680:
681: hr_transaction_api.set_varchar2_value
682: (p_transaction_step_id => p_transaction_step_id
683: ,p_person_id => p_login_person_id
684: ,p_name => 'P_DEI_ATTRIBUTE29'
685: ,p_value => p_dei_attribute29);
683: ,p_person_id => p_login_person_id
684: ,p_name => 'P_DEI_ATTRIBUTE29'
685: ,p_value => p_dei_attribute29);
686:
687: hr_transaction_api.set_varchar2_value
688: (p_transaction_step_id => p_transaction_step_id
689: ,p_person_id => p_login_person_id
690: ,p_name => 'P_DEI_ATTRIBUTE30'
691: ,p_value => p_dei_attribute30);
689: ,p_person_id => p_login_person_id
690: ,p_name => 'P_DEI_ATTRIBUTE30'
691: ,p_value => p_dei_attribute30);
692:
693: hr_transaction_api.set_varchar2_value
694: (p_transaction_step_id => p_transaction_step_id
695: ,p_person_id => p_login_person_id
696: ,p_name => 'P_DEI_INFORMATION_CATEGORY'
697: ,p_value => p_dei_information_category);
695: ,p_person_id => p_login_person_id
696: ,p_name => 'P_DEI_INFORMATION_CATEGORY'
697: ,p_value => p_dei_information_category);
698:
699: hr_transaction_api.set_varchar2_value
700: (p_transaction_step_id => p_transaction_step_id
701: ,p_person_id => p_login_person_id
702: ,p_name => 'P_DEI_INFORMATION1'
703: ,p_value => p_dei_information1);
701: ,p_person_id => p_login_person_id
702: ,p_name => 'P_DEI_INFORMATION1'
703: ,p_value => p_dei_information1);
704:
705: hr_transaction_api.set_varchar2_value
706: (p_transaction_step_id => p_transaction_step_id
707: ,p_person_id => p_login_person_id
708: ,p_name => 'P_DEI_INFORMATION2'
709: ,p_value => p_dei_information2);
707: ,p_person_id => p_login_person_id
708: ,p_name => 'P_DEI_INFORMATION2'
709: ,p_value => p_dei_information2);
710:
711: hr_transaction_api.set_varchar2_value
712: (p_transaction_step_id => p_transaction_step_id
713: ,p_person_id => p_login_person_id
714: ,p_name => 'P_DEI_INFORMATION3'
715: ,p_value => p_dei_information3);
713: ,p_person_id => p_login_person_id
714: ,p_name => 'P_DEI_INFORMATION3'
715: ,p_value => p_dei_information3);
716:
717: hr_transaction_api.set_varchar2_value
718: (p_transaction_step_id => p_transaction_step_id
719: ,p_person_id => p_login_person_id
720: ,p_name => 'P_DEI_INFORMATION4'
721: ,p_value => p_dei_information4);
719: ,p_person_id => p_login_person_id
720: ,p_name => 'P_DEI_INFORMATION4'
721: ,p_value => p_dei_information4);
722:
723: hr_transaction_api.set_varchar2_value
724: (p_transaction_step_id => p_transaction_step_id
725: ,p_person_id => p_login_person_id
726: ,p_name => 'P_DEI_INFORMATION5'
727: ,p_value => p_dei_information5);
725: ,p_person_id => p_login_person_id
726: ,p_name => 'P_DEI_INFORMATION5'
727: ,p_value => p_dei_information5);
728:
729: hr_transaction_api.set_varchar2_value
730: (p_transaction_step_id => p_transaction_step_id
731: ,p_person_id => p_login_person_id
732: ,p_name => 'P_DEI_INFORMATION6'
733: ,p_value => p_dei_information6);
731: ,p_person_id => p_login_person_id
732: ,p_name => 'P_DEI_INFORMATION6'
733: ,p_value => p_dei_information6);
734:
735: hr_transaction_api.set_varchar2_value
736: (p_transaction_step_id => p_transaction_step_id
737: ,p_person_id => p_login_person_id
738: ,p_name => 'P_DEI_INFORMATION7'
739: ,p_value => p_dei_information7);
737: ,p_person_id => p_login_person_id
738: ,p_name => 'P_DEI_INFORMATION7'
739: ,p_value => p_dei_information7);
740:
741: hr_transaction_api.set_varchar2_value
742: (p_transaction_step_id => p_transaction_step_id
743: ,p_person_id => p_login_person_id
744: ,p_name => 'P_DEI_INFORMATION8'
745: ,p_value => p_dei_information8);
743: ,p_person_id => p_login_person_id
744: ,p_name => 'P_DEI_INFORMATION8'
745: ,p_value => p_dei_information8);
746:
747: hr_transaction_api.set_varchar2_value
748: (p_transaction_step_id => p_transaction_step_id
749: ,p_person_id => p_login_person_id
750: ,p_name => 'P_DEI_INFORMATION9'
751: ,p_value => p_dei_information9);
749: ,p_person_id => p_login_person_id
750: ,p_name => 'P_DEI_INFORMATION9'
751: ,p_value => p_dei_information9);
752:
753: hr_transaction_api.set_varchar2_value
754: (p_transaction_step_id => p_transaction_step_id
755: ,p_person_id => p_login_person_id
756: ,p_name => 'P_DEI_INFORMATION10'
757: ,p_value => p_dei_information10);
755: ,p_person_id => p_login_person_id
756: ,p_name => 'P_DEI_INFORMATION10'
757: ,p_value => p_dei_information10);
758:
759: hr_transaction_api.set_varchar2_value
760: (p_transaction_step_id => p_transaction_step_id
761: ,p_person_id => p_login_person_id
762: ,p_name => 'P_DEI_INFORMATION11'
763: ,p_value => p_dei_information11);
761: ,p_person_id => p_login_person_id
762: ,p_name => 'P_DEI_INFORMATION11'
763: ,p_value => p_dei_information11);
764:
765: hr_transaction_api.set_varchar2_value
766: (p_transaction_step_id => p_transaction_step_id
767: ,p_person_id => p_login_person_id
768: ,p_name => 'P_DEI_INFORMATION12'
769: ,p_value => p_dei_information12);
767: ,p_person_id => p_login_person_id
768: ,p_name => 'P_DEI_INFORMATION12'
769: ,p_value => p_dei_information12);
770:
771: hr_transaction_api.set_varchar2_value
772: (p_transaction_step_id => p_transaction_step_id
773: ,p_person_id => p_login_person_id
774: ,p_name => 'P_DEI_INFORMATION13'
775: ,p_value => p_dei_information13);
773: ,p_person_id => p_login_person_id
774: ,p_name => 'P_DEI_INFORMATION13'
775: ,p_value => p_dei_information13);
776:
777: hr_transaction_api.set_varchar2_value
778: (p_transaction_step_id => p_transaction_step_id
779: ,p_person_id => p_login_person_id
780: ,p_name => 'P_DEI_INFORMATION14'
781: ,p_value => p_dei_information14);
779: ,p_person_id => p_login_person_id
780: ,p_name => 'P_DEI_INFORMATION14'
781: ,p_value => p_dei_information14);
782:
783: hr_transaction_api.set_varchar2_value
784: (p_transaction_step_id => p_transaction_step_id
785: ,p_person_id => p_login_person_id
786: ,p_name => 'P_DEI_INFORMATION15'
787: ,p_value => p_dei_information15);
785: ,p_person_id => p_login_person_id
786: ,p_name => 'P_DEI_INFORMATION15'
787: ,p_value => p_dei_information15);
788:
789: hr_transaction_api.set_varchar2_value
790: (p_transaction_step_id => p_transaction_step_id
791: ,p_person_id => p_login_person_id
792: ,p_name => 'P_DEI_INFORMATION16'
793: ,p_value => p_dei_information16);
791: ,p_person_id => p_login_person_id
792: ,p_name => 'P_DEI_INFORMATION16'
793: ,p_value => p_dei_information16);
794:
795: hr_transaction_api.set_varchar2_value
796: (p_transaction_step_id => p_transaction_step_id
797: ,p_person_id => p_login_person_id
798: ,p_name => 'P_DEI_INFORMATION17'
799: ,p_value => p_dei_information17);
797: ,p_person_id => p_login_person_id
798: ,p_name => 'P_DEI_INFORMATION17'
799: ,p_value => p_dei_information17);
800:
801: hr_transaction_api.set_varchar2_value
802: (p_transaction_step_id => p_transaction_step_id
803: ,p_person_id => p_login_person_id
804: ,p_name => 'P_DEI_INFORMATION18'
805: ,p_value => p_dei_information18);
803: ,p_person_id => p_login_person_id
804: ,p_name => 'P_DEI_INFORMATION18'
805: ,p_value => p_dei_information18);
806:
807: hr_transaction_api.set_varchar2_value
808: (p_transaction_step_id => p_transaction_step_id
809: ,p_person_id => p_login_person_id
810: ,p_name => 'P_DEI_INFORMATION19'
811: ,p_value => p_dei_information19);
809: ,p_person_id => p_login_person_id
810: ,p_name => 'P_DEI_INFORMATION19'
811: ,p_value => p_dei_information19);
812:
813: hr_transaction_api.set_varchar2_value
814: (p_transaction_step_id => p_transaction_step_id
815: ,p_person_id => p_login_person_id
816: ,p_name => 'P_DEI_INFORMATION20'
817: ,p_value => p_dei_information20);
815: ,p_person_id => p_login_person_id
816: ,p_name => 'P_DEI_INFORMATION20'
817: ,p_value => p_dei_information20);
818:
819: hr_transaction_api.set_varchar2_value
820: (p_transaction_step_id => p_transaction_step_id
821: ,p_person_id => p_login_person_id
822: ,p_name => 'P_DEI_INFORMATION21'
823: ,p_value => p_dei_information21);
821: ,p_person_id => p_login_person_id
822: ,p_name => 'P_DEI_INFORMATION21'
823: ,p_value => p_dei_information21);
824:
825: hr_transaction_api.set_varchar2_value
826: (p_transaction_step_id => p_transaction_step_id
827: ,p_person_id => p_login_person_id
828: ,p_name => 'P_DEI_INFORMATION22'
829: ,p_value => p_dei_information22);
827: ,p_person_id => p_login_person_id
828: ,p_name => 'P_DEI_INFORMATION22'
829: ,p_value => p_dei_information22);
830:
831: hr_transaction_api.set_varchar2_value
832: (p_transaction_step_id => p_transaction_step_id
833: ,p_person_id => p_login_person_id
834: ,p_name => 'P_DEI_INFORMATION23'
835: ,p_value => p_dei_information23);
833: ,p_person_id => p_login_person_id
834: ,p_name => 'P_DEI_INFORMATION23'
835: ,p_value => p_dei_information23);
836:
837: hr_transaction_api.set_varchar2_value
838: (p_transaction_step_id => p_transaction_step_id
839: ,p_person_id => p_login_person_id
840: ,p_name => 'P_DEI_INFORMATION24'
841: ,p_value => p_dei_information24);
839: ,p_person_id => p_login_person_id
840: ,p_name => 'P_DEI_INFORMATION24'
841: ,p_value => p_dei_information24);
842:
843: hr_transaction_api.set_varchar2_value
844: (p_transaction_step_id => p_transaction_step_id
845: ,p_person_id => p_login_person_id
846: ,p_name => 'P_DEI_INFORMATION25'
847: ,p_value => p_dei_information25);
845: ,p_person_id => p_login_person_id
846: ,p_name => 'P_DEI_INFORMATION25'
847: ,p_value => p_dei_information25);
848:
849: hr_transaction_api.set_varchar2_value
850: (p_transaction_step_id => p_transaction_step_id
851: ,p_person_id => p_login_person_id
852: ,p_name => 'P_DEI_INFORMATION26'
853: ,p_value => p_dei_information26);
851: ,p_person_id => p_login_person_id
852: ,p_name => 'P_DEI_INFORMATION26'
853: ,p_value => p_dei_information26);
854:
855: hr_transaction_api.set_varchar2_value
856: (p_transaction_step_id => p_transaction_step_id
857: ,p_person_id => p_login_person_id
858: ,p_name => 'P_DEI_INFORMATION27'
859: ,p_value => p_dei_information27);
857: ,p_person_id => p_login_person_id
858: ,p_name => 'P_DEI_INFORMATION27'
859: ,p_value => p_dei_information27);
860:
861: hr_transaction_api.set_varchar2_value
862: (p_transaction_step_id => p_transaction_step_id
863: ,p_person_id => p_login_person_id
864: ,p_name => 'P_DEI_INFORMATION28'
865: ,p_value => p_dei_information28);
863: ,p_person_id => p_login_person_id
864: ,p_name => 'P_DEI_INFORMATION28'
865: ,p_value => p_dei_information28);
866:
867: hr_transaction_api.set_varchar2_value
868: (p_transaction_step_id => p_transaction_step_id
869: ,p_person_id => p_login_person_id
870: ,p_name => 'P_DEI_INFORMATION29'
871: ,p_value => p_dei_information29);
869: ,p_person_id => p_login_person_id
870: ,p_name => 'P_DEI_INFORMATION29'
871: ,p_value => p_dei_information29);
872:
873: hr_transaction_api.set_varchar2_value
874: (p_transaction_step_id => p_transaction_step_id
875: ,p_person_id => p_login_person_id
876: ,p_name => 'P_DEI_INFORMATION30'
877: ,p_value => p_dei_information30);
876: ,p_name => 'P_DEI_INFORMATION30'
877: ,p_value => p_dei_information30);
878:
879:
880: hr_transaction_api.set_number_value
881: (p_transaction_step_id => p_transaction_step_id
882: ,p_person_id => p_login_person_id
883: ,p_name => 'P_REQUEST_ID'
884: ,p_value => p_request_id);
882: ,p_person_id => p_login_person_id
883: ,p_name => 'P_REQUEST_ID'
884: ,p_value => p_request_id);
885:
886: hr_transaction_api.set_number_value
887: (p_transaction_step_id => p_transaction_step_id
888: ,p_person_id => p_login_person_id
889: ,p_name => 'P_PROGRAM_APPLICATION_ID'
890: ,p_value => p_program_application_id);
888: ,p_person_id => p_login_person_id
889: ,p_name => 'P_PROGRAM_APPLICATION_ID'
890: ,p_value => p_program_application_id);
891:
892: hr_transaction_api.set_number_value
893: (p_transaction_step_id => p_transaction_step_id
894: ,p_person_id => p_login_person_id
895: ,p_name => 'P_PROGRAM_ID'
896: ,p_value => p_program_id);
894: ,p_person_id => p_login_person_id
895: ,p_name => 'P_PROGRAM_ID'
896: ,p_value => p_program_id);
897:
898: hr_transaction_api.set_date_value
899: (p_transaction_step_id => p_transaction_step_id
900: ,p_person_id => p_login_person_id
901: ,p_name => 'P_PROGRAM_UPDATE_DATE'
902: ,p_value => p_program_update_date);
900: ,p_person_id => p_login_person_id
901: ,p_name => 'P_PROGRAM_UPDATE_DATE'
902: ,p_value => p_program_update_date);
903:
904: hr_transaction_api.set_number_value
905: (p_transaction_step_id => p_transaction_step_id
906: ,p_person_id => p_login_person_id
907: ,p_name => 'P_OBJECT_VERSION_NUMBER'
908: ,p_value => p_object_version_number);
918: AND document_type_id = p_document_type_id;
919:
920:
921: if p_org_rec.date_from = p_date_from then
922: hr_transaction_api.set_date_value
923: (p_transaction_step_id => p_transaction_step_id
924: ,p_person_id => p_login_person_id
925: ,p_name => 'P_DATE_FROM'
926: ,p_value => p_date_from);
924: ,p_person_id => p_login_person_id
925: ,p_name => 'P_DATE_FROM'
926: ,p_value => p_date_from);
927: else
928: hr_transaction_api.set_date_value
929: (p_transaction_step_id => p_transaction_step_id
930: ,p_person_id => p_login_person_id
931: ,p_name => 'P_DATE_FROM'
932: ,p_value => p_date_from
933: ,p_original_value => p_org_rec.date_from);
934: end if;
935:
936: if p_org_rec.date_to = p_date_to then
937: hr_transaction_api.set_date_value
938: (p_transaction_step_id => p_transaction_step_id
939: ,p_person_id => p_login_person_id
940: ,p_name => 'P_DATE_TO'
941: ,p_value => p_date_to);
939: ,p_person_id => p_login_person_id
940: ,p_name => 'P_DATE_TO'
941: ,p_value => p_date_to);
942: else
943: hr_transaction_api.set_date_value
944: (p_transaction_step_id => p_transaction_step_id
945: ,p_person_id => p_login_person_id
946: ,p_name => 'P_DATE_TO'
947: ,p_value => p_date_to
948: ,p_original_value => p_org_rec.date_to);
949: end if;
950:
951: if p_org_rec.document_number = p_document_number then
952: hr_transaction_api.set_varchar2_value
953: (p_transaction_step_id => p_transaction_step_id
954: ,p_person_id => p_login_person_id
955: ,p_name => 'P_DOCUMENT_NUMBER'
956: ,p_value => p_document_number);
954: ,p_person_id => p_login_person_id
955: ,p_name => 'P_DOCUMENT_NUMBER'
956: ,p_value => p_document_number);
957: else
958: hr_transaction_api.set_varchar2_value
959: (p_transaction_step_id => p_transaction_step_id
960: ,p_person_id => p_login_person_id
961: ,p_name => 'P_DOCUMENT_NUMBER'
962: ,p_value => p_document_number
963: ,p_original_value => p_org_rec.document_number);
964: end if;
965:
966: if p_org_rec.issued_by = p_issued_by then
967: hr_transaction_api.set_varchar2_value
968: (p_transaction_step_id => p_transaction_step_id
969: ,p_person_id => p_login_person_id
970: ,p_name => 'P_ISSUED_BY'
971: ,p_value => p_issued_by);
969: ,p_person_id => p_login_person_id
970: ,p_name => 'P_ISSUED_BY'
971: ,p_value => p_issued_by);
972: else
973: hr_transaction_api.set_varchar2_value
974: (p_transaction_step_id => p_transaction_step_id
975: ,p_person_id => p_login_person_id
976: ,p_name => 'P_ISSUED_BY'
977: ,p_value => p_issued_by
978: ,p_original_value => p_org_rec.issued_by);
979: end if;
980:
981: if p_org_rec.issued_at = p_issued_at then
982: hr_transaction_api.set_varchar2_value
983: (p_transaction_step_id => p_transaction_step_id
984: ,p_person_id => p_login_person_id
985: ,p_name => 'P_ISSUED_AT'
986: ,p_value => p_issued_at);
984: ,p_person_id => p_login_person_id
985: ,p_name => 'P_ISSUED_AT'
986: ,p_value => p_issued_at);
987: else
988: hr_transaction_api.set_varchar2_value
989: (p_transaction_step_id => p_transaction_step_id
990: ,p_person_id => p_login_person_id
991: ,p_name => 'P_ISSUED_AT'
992: ,p_value => p_issued_at
993: ,p_original_value => p_org_rec.issued_at);
994: end if;
995:
996: if p_org_rec.issued_date = p_issued_date then
997: hr_transaction_api.set_date_value
998: (p_transaction_step_id => p_transaction_step_id
999: ,p_person_id => p_login_person_id
1000: ,p_name => 'P_ISSUED_DATE'
1001: ,p_value => p_issued_date);
999: ,p_person_id => p_login_person_id
1000: ,p_name => 'P_ISSUED_DATE'
1001: ,p_value => p_issued_date);
1002: else
1003: hr_transaction_api.set_date_value
1004: (p_transaction_step_id => p_transaction_step_id
1005: ,p_person_id => p_login_person_id
1006: ,p_name => 'P_ISSUED_DATE'
1007: ,p_value => p_issued_date
1008: ,p_original_value => p_org_rec.issued_date);
1009: end if;
1010:
1011: if p_org_rec.issuing_authority = p_issuing_authority then
1012: hr_transaction_api.set_varchar2_value
1013: (p_transaction_step_id => p_transaction_step_id
1014: ,p_person_id => p_login_person_id
1015: ,p_name => 'P_ISSUING_AUTHORITY'
1016: ,p_value => p_issuing_authority);
1014: ,p_person_id => p_login_person_id
1015: ,p_name => 'P_ISSUING_AUTHORITY'
1016: ,p_value => p_issuing_authority);
1017: else
1018: hr_transaction_api.set_varchar2_value
1019: (p_transaction_step_id => p_transaction_step_id
1020: ,p_person_id => p_login_person_id
1021: ,p_name => 'P_ISSUING_AUTHORITY'
1022: ,p_value => p_issuing_authority
1023: ,p_original_value => p_org_rec.issuing_authority);
1024: end if;
1025:
1026: if p_org_rec.verified_by = p_verified_by then
1027: hr_transaction_api.set_number_value
1028: (p_transaction_step_id => p_transaction_step_id
1029: ,p_person_id => p_login_person_id
1030: ,p_name => 'P_VERIFIED_BY'
1031: ,p_value => p_verified_by);
1029: ,p_person_id => p_login_person_id
1030: ,p_name => 'P_VERIFIED_BY'
1031: ,p_value => p_verified_by);
1032: else
1033: hr_transaction_api.set_number_value
1034: (p_transaction_step_id => p_transaction_step_id
1035: ,p_person_id => p_login_person_id
1036: ,p_name => 'P_VERIFIED_BY'
1037: ,p_value => p_verified_by
1038: ,p_original_value => p_org_rec.verified_by);
1039: end if;
1040:
1041: if p_org_rec.verified_date = p_verified_date then
1042: hr_transaction_api.set_date_value
1043: (p_transaction_step_id => p_transaction_step_id
1044: ,p_person_id => p_login_person_id
1045: ,p_name => 'P_VERIFIED_DATE'
1046: ,p_value => p_verified_date);
1044: ,p_person_id => p_login_person_id
1045: ,p_name => 'P_VERIFIED_DATE'
1046: ,p_value => p_verified_date);
1047: else
1048: hr_transaction_api.set_date_value
1049: (p_transaction_step_id => p_transaction_step_id
1050: ,p_person_id => p_login_person_id
1051: ,p_name => 'P_VERIFIED_DATE'
1052: ,p_value => p_verified_date
1053: ,p_original_value => p_org_rec.verified_date);
1054: end if;
1055:
1056: if p_org_rec.related_object_name = p_related_object_name then
1057: hr_transaction_api.set_varchar2_value
1058: (p_transaction_step_id => p_transaction_step_id
1059: ,p_person_id => p_login_person_id
1060: ,p_name => 'P_RELATED_OBJECT_NAME'
1061: ,p_value => p_related_object_name);
1059: ,p_person_id => p_login_person_id
1060: ,p_name => 'P_RELATED_OBJECT_NAME'
1061: ,p_value => p_related_object_name);
1062: else
1063: hr_transaction_api.set_varchar2_value
1064: (p_transaction_step_id => p_transaction_step_id
1065: ,p_person_id => p_login_person_id
1066: ,p_name => 'P_RELATED_OBJECT_NAME'
1067: ,p_value => p_related_object_name
1068: ,p_original_value => p_org_rec.related_object_name);
1069: end if;
1070:
1071: if p_org_rec.related_object_id_col = p_related_object_id_col then
1072: hr_transaction_api.set_varchar2_value
1073: (p_transaction_step_id => p_transaction_step_id
1074: ,p_person_id => p_login_person_id
1075: ,p_name => 'P_RELATED_OBJECT_ID_COL'
1076: ,p_value => p_related_object_id_col);
1074: ,p_person_id => p_login_person_id
1075: ,p_name => 'P_RELATED_OBJECT_ID_COL'
1076: ,p_value => p_related_object_id_col);
1077: else
1078: hr_transaction_api.set_varchar2_value
1079: (p_transaction_step_id => p_transaction_step_id
1080: ,p_person_id => p_login_person_id
1081: ,p_name => 'P_RELATED_OBJECT_ID_COL'
1082: ,p_value => p_related_object_id_col
1083: ,p_original_value => p_org_rec.related_object_id_col);
1084: end if;
1085:
1086: if p_org_rec.related_object_id = p_related_object_id then
1087: hr_transaction_api.set_number_value
1088: (p_transaction_step_id => p_transaction_step_id
1089: ,p_person_id => p_login_person_id
1090: ,p_name => 'P_RELATED_OBJECT_ID'
1091: ,p_value => p_related_object_id);
1089: ,p_person_id => p_login_person_id
1090: ,p_name => 'P_RELATED_OBJECT_ID'
1091: ,p_value => p_related_object_id);
1092: else
1093: hr_transaction_api.set_number_value
1094: (p_transaction_step_id => p_transaction_step_id
1095: ,p_person_id => p_login_person_id
1096: ,p_name => 'P_RELATED_OBJECT_ID'
1097: ,p_value => p_related_object_id
1098: ,p_original_value => p_org_rec.related_object_id);
1099: end if;
1100:
1101: if p_org_rec.dei_attribute_category = p_dei_attribute_category then
1102: hr_transaction_api.set_varchar2_value
1103: (p_transaction_step_id => p_transaction_step_id
1104: ,p_person_id => p_login_person_id
1105: ,p_name => 'P_DEI_ATTRIBUTE_CATEGORY'
1106: ,p_value => p_dei_attribute_category);
1104: ,p_person_id => p_login_person_id
1105: ,p_name => 'P_DEI_ATTRIBUTE_CATEGORY'
1106: ,p_value => p_dei_attribute_category);
1107: else
1108: hr_transaction_api.set_varchar2_value
1109: (p_transaction_step_id => p_transaction_step_id
1110: ,p_person_id => p_login_person_id
1111: ,p_name => 'P_DEI_ATTRIBUTE_CATEGORY'
1112: ,p_value => p_dei_attribute_category
1113: ,p_original_value => p_org_rec.dei_attribute_category);
1114: end if;
1115:
1116: if p_org_rec.dei_attribute1 = p_dei_attribute1 then
1117: hr_transaction_api.set_varchar2_value
1118: (p_transaction_step_id => p_transaction_step_id
1119: ,p_person_id => p_login_person_id
1120: ,p_name => 'P_DEI_ATTRIBUTE1'
1121: ,p_value => p_dei_attribute1);
1119: ,p_person_id => p_login_person_id
1120: ,p_name => 'P_DEI_ATTRIBUTE1'
1121: ,p_value => p_dei_attribute1);
1122: else
1123: hr_transaction_api.set_varchar2_value
1124: (p_transaction_step_id => p_transaction_step_id
1125: ,p_person_id => p_login_person_id
1126: ,p_name => 'P_DEI_ATTRIBUTE1'
1127: ,p_value => p_dei_attribute1
1128: ,p_original_value => p_org_rec.dei_attribute1);
1129: end if;
1130:
1131: if p_org_rec.dei_attribute2 = p_dei_attribute2 then
1132: hr_transaction_api.set_varchar2_value
1133: (p_transaction_step_id => p_transaction_step_id
1134: ,p_person_id => p_login_person_id
1135: ,p_name => 'P_DEI_ATTRIBUTE2'
1136: ,p_value => p_dei_attribute2);
1134: ,p_person_id => p_login_person_id
1135: ,p_name => 'P_DEI_ATTRIBUTE2'
1136: ,p_value => p_dei_attribute2);
1137: else
1138: hr_transaction_api.set_varchar2_value
1139: (p_transaction_step_id => p_transaction_step_id
1140: ,p_person_id => p_login_person_id
1141: ,p_name => 'P_DEI_ATTRIBUTE2'
1142: ,p_value => p_dei_attribute2
1143: ,p_original_value => p_org_rec.dei_attribute2);
1144: end if;
1145:
1146: if p_org_rec.dei_attribute3 = p_dei_attribute3 then
1147: hr_transaction_api.set_varchar2_value
1148: (p_transaction_step_id => p_transaction_step_id
1149: ,p_person_id => p_login_person_id
1150: ,p_name => 'P_DEI_ATTRIBUTE3'
1151: ,p_value => p_dei_attribute3);
1149: ,p_person_id => p_login_person_id
1150: ,p_name => 'P_DEI_ATTRIBUTE3'
1151: ,p_value => p_dei_attribute3);
1152: else
1153: hr_transaction_api.set_varchar2_value
1154: (p_transaction_step_id => p_transaction_step_id
1155: ,p_person_id => p_login_person_id
1156: ,p_name => 'P_DEI_ATTRIBUTE3'
1157: ,p_value => p_dei_attribute3
1158: ,p_original_value => p_org_rec.dei_attribute3);
1159: end if;
1160:
1161: if p_org_rec.dei_attribute4 = p_dei_attribute4 then
1162: hr_transaction_api.set_varchar2_value
1163: (p_transaction_step_id => p_transaction_step_id
1164: ,p_person_id => p_login_person_id
1165: ,p_name => 'P_DEI_ATTRIBUTE4'
1166: ,p_value => p_dei_attribute4);
1164: ,p_person_id => p_login_person_id
1165: ,p_name => 'P_DEI_ATTRIBUTE4'
1166: ,p_value => p_dei_attribute4);
1167: else
1168: hr_transaction_api.set_varchar2_value
1169: (p_transaction_step_id => p_transaction_step_id
1170: ,p_person_id => p_login_person_id
1171: ,p_name => 'P_DEI_ATTRIBUTE4'
1172: ,p_value => p_dei_attribute4
1173: ,p_original_value => p_org_rec.dei_attribute4);
1174: end if;
1175:
1176: if p_org_rec.dei_attribute5 = p_dei_attribute5 then
1177: hr_transaction_api.set_varchar2_value
1178: (p_transaction_step_id => p_transaction_step_id
1179: ,p_person_id => p_login_person_id
1180: ,p_name => 'P_DEI_ATTRIBUTE5'
1181: ,p_value => p_dei_attribute5);
1179: ,p_person_id => p_login_person_id
1180: ,p_name => 'P_DEI_ATTRIBUTE5'
1181: ,p_value => p_dei_attribute5);
1182: else
1183: hr_transaction_api.set_varchar2_value
1184: (p_transaction_step_id => p_transaction_step_id
1185: ,p_person_id => p_login_person_id
1186: ,p_name => 'P_DEI_ATTRIBUTE5'
1187: ,p_value => p_dei_attribute5
1188: ,p_original_value => p_org_rec.dei_attribute5);
1189: end if;
1190:
1191: if p_org_rec.dei_attribute6 = p_dei_attribute6 then
1192: hr_transaction_api.set_varchar2_value
1193: (p_transaction_step_id => p_transaction_step_id
1194: ,p_person_id => p_login_person_id
1195: ,p_name => 'P_DEI_ATTRIBUTE6'
1196: ,p_value => p_dei_attribute6);
1194: ,p_person_id => p_login_person_id
1195: ,p_name => 'P_DEI_ATTRIBUTE6'
1196: ,p_value => p_dei_attribute6);
1197: else
1198: hr_transaction_api.set_varchar2_value
1199: (p_transaction_step_id => p_transaction_step_id
1200: ,p_person_id => p_login_person_id
1201: ,p_name => 'P_DEI_ATTRIBUTE6'
1202: ,p_value => p_dei_attribute6
1203: ,p_original_value => p_org_rec.dei_attribute6);
1204: end if;
1205:
1206: if p_org_rec.dei_attribute7 = p_dei_attribute7 then
1207: hr_transaction_api.set_varchar2_value
1208: (p_transaction_step_id => p_transaction_step_id
1209: ,p_person_id => p_login_person_id
1210: ,p_name => 'P_DEI_ATTRIBUTE7'
1211: ,p_value => p_dei_attribute7);
1209: ,p_person_id => p_login_person_id
1210: ,p_name => 'P_DEI_ATTRIBUTE7'
1211: ,p_value => p_dei_attribute7);
1212: else
1213: hr_transaction_api.set_varchar2_value
1214: (p_transaction_step_id => p_transaction_step_id
1215: ,p_person_id => p_login_person_id
1216: ,p_name => 'P_DEI_ATTRIBUTE7'
1217: ,p_value => p_dei_attribute7
1218: ,p_original_value => p_org_rec.dei_attribute7);
1219: end if;
1220:
1221: if p_org_rec.dei_attribute8 = p_dei_attribute8 then
1222: hr_transaction_api.set_varchar2_value
1223: (p_transaction_step_id => p_transaction_step_id
1224: ,p_person_id => p_login_person_id
1225: ,p_name => 'P_DEI_ATTRIBUTE8'
1226: ,p_value => p_dei_attribute8);
1224: ,p_person_id => p_login_person_id
1225: ,p_name => 'P_DEI_ATTRIBUTE8'
1226: ,p_value => p_dei_attribute8);
1227: else
1228: hr_transaction_api.set_varchar2_value
1229: (p_transaction_step_id => p_transaction_step_id
1230: ,p_person_id => p_login_person_id
1231: ,p_name => 'P_DEI_ATTRIBUTE8'
1232: ,p_value => p_dei_attribute8
1233: ,p_original_value => p_org_rec.dei_attribute8);
1234: end if;
1235:
1236: if p_org_rec.dei_attribute9 = p_dei_attribute9 then
1237: hr_transaction_api.set_varchar2_value
1238: (p_transaction_step_id => p_transaction_step_id
1239: ,p_person_id => p_login_person_id
1240: ,p_name => 'P_DEI_ATTRIBUTE9'
1241: ,p_value => p_dei_attribute9);
1239: ,p_person_id => p_login_person_id
1240: ,p_name => 'P_DEI_ATTRIBUTE9'
1241: ,p_value => p_dei_attribute9);
1242: else
1243: hr_transaction_api.set_varchar2_value
1244: (p_transaction_step_id => p_transaction_step_id
1245: ,p_person_id => p_login_person_id
1246: ,p_name => 'P_DEI_ATTRIBUTE9'
1247: ,p_value => p_dei_attribute9
1248: ,p_original_value => p_org_rec.dei_attribute9);
1249: end if;
1250:
1251: if p_org_rec.dei_attribute10 = p_dei_attribute10 then
1252: hr_transaction_api.set_varchar2_value
1253: (p_transaction_step_id => p_transaction_step_id
1254: ,p_person_id => p_login_person_id
1255: ,p_name => 'P_DEI_ATTRIBUTE10'
1256: ,p_value => p_dei_attribute10);
1254: ,p_person_id => p_login_person_id
1255: ,p_name => 'P_DEI_ATTRIBUTE10'
1256: ,p_value => p_dei_attribute10);
1257: else
1258: hr_transaction_api.set_varchar2_value
1259: (p_transaction_step_id => p_transaction_step_id
1260: ,p_person_id => p_login_person_id
1261: ,p_name => 'P_DEI_ATTRIBUTE10'
1262: ,p_value => p_dei_attribute10
1263: ,p_original_value => p_org_rec.dei_attribute10);
1264: end if;
1265:
1266: if p_org_rec.dei_attribute11 = p_dei_attribute11 then
1267: hr_transaction_api.set_varchar2_value
1268: (p_transaction_step_id => p_transaction_step_id
1269: ,p_person_id => p_login_person_id
1270: ,p_name => 'P_DEI_ATTRIBUTE11'
1271: ,p_value => p_dei_attribute11);
1269: ,p_person_id => p_login_person_id
1270: ,p_name => 'P_DEI_ATTRIBUTE11'
1271: ,p_value => p_dei_attribute11);
1272: else
1273: hr_transaction_api.set_varchar2_value
1274: (p_transaction_step_id => p_transaction_step_id
1275: ,p_person_id => p_login_person_id
1276: ,p_name => 'P_DEI_ATTRIBUTE11'
1277: ,p_value => p_dei_attribute11
1278: ,p_original_value => p_org_rec.dei_attribute11);
1279: end if;
1280:
1281: if p_org_rec.dei_attribute12 = p_dei_attribute12 then
1282: hr_transaction_api.set_varchar2_value
1283: (p_transaction_step_id => p_transaction_step_id
1284: ,p_person_id => p_login_person_id
1285: ,p_name => 'P_DEI_ATTRIBUTE12'
1286: ,p_value => p_dei_attribute12);
1284: ,p_person_id => p_login_person_id
1285: ,p_name => 'P_DEI_ATTRIBUTE12'
1286: ,p_value => p_dei_attribute12);
1287: else
1288: hr_transaction_api.set_varchar2_value
1289: (p_transaction_step_id => p_transaction_step_id
1290: ,p_person_id => p_login_person_id
1291: ,p_name => 'P_DEI_ATTRIBUTE12'
1292: ,p_value => p_dei_attribute12
1293: ,p_original_value => p_org_rec.dei_attribute12);
1294: end if;
1295:
1296: if p_org_rec.dei_attribute13 = p_dei_attribute13 then
1297: hr_transaction_api.set_varchar2_value
1298: (p_transaction_step_id => p_transaction_step_id
1299: ,p_person_id => p_login_person_id
1300: ,p_name => 'P_DEI_ATTRIBUTE13'
1301: ,p_value => p_dei_attribute13);
1299: ,p_person_id => p_login_person_id
1300: ,p_name => 'P_DEI_ATTRIBUTE13'
1301: ,p_value => p_dei_attribute13);
1302: else
1303: hr_transaction_api.set_varchar2_value
1304: (p_transaction_step_id => p_transaction_step_id
1305: ,p_person_id => p_login_person_id
1306: ,p_name => 'P_DEI_ATTRIBUTE13'
1307: ,p_value => p_dei_attribute13
1308: ,p_original_value => p_org_rec.dei_attribute13);
1309: end if;
1310:
1311: if p_org_rec.dei_attribute14 = p_dei_attribute14 then
1312: hr_transaction_api.set_varchar2_value
1313: (p_transaction_step_id => p_transaction_step_id
1314: ,p_person_id => p_login_person_id
1315: ,p_name => 'P_DEI_ATTRIBUTE14'
1316: ,p_value => p_dei_attribute14);
1314: ,p_person_id => p_login_person_id
1315: ,p_name => 'P_DEI_ATTRIBUTE14'
1316: ,p_value => p_dei_attribute14);
1317: else
1318: hr_transaction_api.set_varchar2_value
1319: (p_transaction_step_id => p_transaction_step_id
1320: ,p_person_id => p_login_person_id
1321: ,p_name => 'P_DEI_ATTRIBUTE14'
1322: ,p_value => p_dei_attribute14
1323: ,p_original_value => p_org_rec.dei_attribute14);
1324: end if;
1325:
1326: if p_org_rec.dei_attribute15 = p_dei_attribute15 then
1327: hr_transaction_api.set_varchar2_value
1328: (p_transaction_step_id => p_transaction_step_id
1329: ,p_person_id => p_login_person_id
1330: ,p_name => 'P_DEI_ATTRIBUTE15'
1331: ,p_value => p_dei_attribute15);
1329: ,p_person_id => p_login_person_id
1330: ,p_name => 'P_DEI_ATTRIBUTE15'
1331: ,p_value => p_dei_attribute15);
1332: else
1333: hr_transaction_api.set_varchar2_value
1334: (p_transaction_step_id => p_transaction_step_id
1335: ,p_person_id => p_login_person_id
1336: ,p_name => 'P_DEI_ATTRIBUTE15'
1337: ,p_value => p_dei_attribute15
1338: ,p_original_value => p_org_rec.dei_attribute15);
1339: end if;
1340:
1341: if p_org_rec.dei_attribute16 = p_dei_attribute16 then
1342: hr_transaction_api.set_varchar2_value
1343: (p_transaction_step_id => p_transaction_step_id
1344: ,p_person_id => p_login_person_id
1345: ,p_name => 'P_DEI_ATTRIBUTE16'
1346: ,p_value => p_dei_attribute16);
1344: ,p_person_id => p_login_person_id
1345: ,p_name => 'P_DEI_ATTRIBUTE16'
1346: ,p_value => p_dei_attribute16);
1347: else
1348: hr_transaction_api.set_varchar2_value
1349: (p_transaction_step_id => p_transaction_step_id
1350: ,p_person_id => p_login_person_id
1351: ,p_name => 'P_DEI_ATTRIBUTE16'
1352: ,p_value => p_dei_attribute16
1353: ,p_original_value => p_org_rec.dei_attribute16);
1354: end if;
1355:
1356: if p_org_rec.dei_attribute17 = p_dei_attribute17 then
1357: hr_transaction_api.set_varchar2_value
1358: (p_transaction_step_id => p_transaction_step_id
1359: ,p_person_id => p_login_person_id
1360: ,p_name => 'P_DEI_ATTRIBUTE17'
1361: ,p_value => p_dei_attribute17);
1359: ,p_person_id => p_login_person_id
1360: ,p_name => 'P_DEI_ATTRIBUTE17'
1361: ,p_value => p_dei_attribute17);
1362: else
1363: hr_transaction_api.set_varchar2_value
1364: (p_transaction_step_id => p_transaction_step_id
1365: ,p_person_id => p_login_person_id
1366: ,p_name => 'P_DEI_ATTRIBUTE17'
1367: ,p_value => p_dei_attribute17
1368: ,p_original_value => p_org_rec.dei_attribute17);
1369: end if;
1370:
1371: if p_org_rec.dei_attribute18 = p_dei_attribute18 then
1372: hr_transaction_api.set_varchar2_value
1373: (p_transaction_step_id => p_transaction_step_id
1374: ,p_person_id => p_login_person_id
1375: ,p_name => 'P_DEI_ATTRIBUTE18'
1376: ,p_value => p_dei_attribute18);
1374: ,p_person_id => p_login_person_id
1375: ,p_name => 'P_DEI_ATTRIBUTE18'
1376: ,p_value => p_dei_attribute18);
1377: else
1378: hr_transaction_api.set_varchar2_value
1379: (p_transaction_step_id => p_transaction_step_id
1380: ,p_person_id => p_login_person_id
1381: ,p_name => 'P_DEI_ATTRIBUTE18'
1382: ,p_value => p_dei_attribute18
1383: ,p_original_value => p_org_rec.dei_attribute18);
1384: end if;
1385:
1386: if p_org_rec.dei_attribute19 = p_dei_attribute19 then
1387: hr_transaction_api.set_varchar2_value
1388: (p_transaction_step_id => p_transaction_step_id
1389: ,p_person_id => p_login_person_id
1390: ,p_name => 'P_DEI_ATTRIBUTE19'
1391: ,p_value => p_dei_attribute19);
1389: ,p_person_id => p_login_person_id
1390: ,p_name => 'P_DEI_ATTRIBUTE19'
1391: ,p_value => p_dei_attribute19);
1392: else
1393: hr_transaction_api.set_varchar2_value
1394: (p_transaction_step_id => p_transaction_step_id
1395: ,p_person_id => p_login_person_id
1396: ,p_name => 'P_DEI_ATTRIBUTE19'
1397: ,p_value => p_dei_attribute19
1398: ,p_original_value => p_org_rec.dei_attribute19);
1399: end if;
1400:
1401: if p_org_rec.dei_attribute20 = p_dei_attribute20 then
1402: hr_transaction_api.set_varchar2_value
1403: (p_transaction_step_id => p_transaction_step_id
1404: ,p_person_id => p_login_person_id
1405: ,p_name => 'P_DEI_ATTRIBUTE20'
1406: ,p_value => p_dei_attribute20);
1404: ,p_person_id => p_login_person_id
1405: ,p_name => 'P_DEI_ATTRIBUTE20'
1406: ,p_value => p_dei_attribute20);
1407: else
1408: hr_transaction_api.set_varchar2_value
1409: (p_transaction_step_id => p_transaction_step_id
1410: ,p_person_id => p_login_person_id
1411: ,p_name => 'P_DEI_ATTRIBUTE20'
1412: ,p_value => p_dei_attribute20
1413: ,p_original_value => p_org_rec.dei_attribute20);
1414: end if;
1415:
1416: if p_org_rec.dei_attribute21 = p_dei_attribute21 then
1417: hr_transaction_api.set_varchar2_value
1418: (p_transaction_step_id => p_transaction_step_id
1419: ,p_person_id => p_login_person_id
1420: ,p_name => 'P_DEI_ATTRIBUTE21'
1421: ,p_value => p_dei_attribute21);
1419: ,p_person_id => p_login_person_id
1420: ,p_name => 'P_DEI_ATTRIBUTE21'
1421: ,p_value => p_dei_attribute21);
1422: else
1423: hr_transaction_api.set_varchar2_value
1424: (p_transaction_step_id => p_transaction_step_id
1425: ,p_person_id => p_login_person_id
1426: ,p_name => 'P_DEI_ATTRIBUTE21'
1427: ,p_value => p_dei_attribute21
1428: ,p_original_value => p_org_rec.dei_attribute21);
1429: end if;
1430:
1431: if p_org_rec.dei_attribute22 = p_dei_attribute22 then
1432: hr_transaction_api.set_varchar2_value
1433: (p_transaction_step_id => p_transaction_step_id
1434: ,p_person_id => p_login_person_id
1435: ,p_name => 'P_DEI_ATTRIBUTE22'
1436: ,p_value => p_dei_attribute22);
1434: ,p_person_id => p_login_person_id
1435: ,p_name => 'P_DEI_ATTRIBUTE22'
1436: ,p_value => p_dei_attribute22);
1437: else
1438: hr_transaction_api.set_varchar2_value
1439: (p_transaction_step_id => p_transaction_step_id
1440: ,p_person_id => p_login_person_id
1441: ,p_name => 'P_DEI_ATTRIBUTE22'
1442: ,p_value => p_dei_attribute22
1443: ,p_original_value => p_org_rec.dei_attribute22);
1444: end if;
1445:
1446: if p_org_rec.dei_attribute23 = p_dei_attribute23 then
1447: hr_transaction_api.set_varchar2_value
1448: (p_transaction_step_id => p_transaction_step_id
1449: ,p_person_id => p_login_person_id
1450: ,p_name => 'P_DEI_ATTRIBUTE23'
1451: ,p_value => p_dei_attribute23);
1449: ,p_person_id => p_login_person_id
1450: ,p_name => 'P_DEI_ATTRIBUTE23'
1451: ,p_value => p_dei_attribute23);
1452: else
1453: hr_transaction_api.set_varchar2_value
1454: (p_transaction_step_id => p_transaction_step_id
1455: ,p_person_id => p_login_person_id
1456: ,p_name => 'P_DEI_ATTRIBUTE23'
1457: ,p_value => p_dei_attribute23
1458: ,p_original_value => p_org_rec.dei_attribute23);
1459: end if;
1460:
1461: if p_org_rec.dei_attribute24 = p_dei_attribute24 then
1462: hr_transaction_api.set_varchar2_value
1463: (p_transaction_step_id => p_transaction_step_id
1464: ,p_person_id => p_login_person_id
1465: ,p_name => 'P_DEI_ATTRIBUTE24'
1466: ,p_value => p_dei_attribute24);
1464: ,p_person_id => p_login_person_id
1465: ,p_name => 'P_DEI_ATTRIBUTE24'
1466: ,p_value => p_dei_attribute24);
1467: else
1468: hr_transaction_api.set_varchar2_value
1469: (p_transaction_step_id => p_transaction_step_id
1470: ,p_person_id => p_login_person_id
1471: ,p_name => 'P_DEI_ATTRIBUTE24'
1472: ,p_value => p_dei_attribute24
1473: ,p_original_value => p_org_rec.dei_attribute24);
1474: end if;
1475:
1476: if p_org_rec.dei_attribute25 = p_dei_attribute25 then
1477: hr_transaction_api.set_varchar2_value
1478: (p_transaction_step_id => p_transaction_step_id
1479: ,p_person_id => p_login_person_id
1480: ,p_name => 'P_DEI_ATTRIBUTE25'
1481: ,p_value => p_dei_attribute25);
1479: ,p_person_id => p_login_person_id
1480: ,p_name => 'P_DEI_ATTRIBUTE25'
1481: ,p_value => p_dei_attribute25);
1482: else
1483: hr_transaction_api.set_varchar2_value
1484: (p_transaction_step_id => p_transaction_step_id
1485: ,p_person_id => p_login_person_id
1486: ,p_name => 'P_DEI_ATTRIBUTE25'
1487: ,p_value => p_dei_attribute25
1488: ,p_original_value => p_org_rec.dei_attribute25);
1489: end if;
1490:
1491: if p_org_rec.dei_attribute26 = p_dei_attribute26 then
1492: hr_transaction_api.set_varchar2_value
1493: (p_transaction_step_id => p_transaction_step_id
1494: ,p_person_id => p_login_person_id
1495: ,p_name => 'P_DEI_ATTRIBUTE26'
1496: ,p_value => p_dei_attribute26);
1494: ,p_person_id => p_login_person_id
1495: ,p_name => 'P_DEI_ATTRIBUTE26'
1496: ,p_value => p_dei_attribute26);
1497: else
1498: hr_transaction_api.set_varchar2_value
1499: (p_transaction_step_id => p_transaction_step_id
1500: ,p_person_id => p_login_person_id
1501: ,p_name => 'P_DEI_ATTRIBUTE26'
1502: ,p_value => p_dei_attribute26
1503: ,p_original_value => p_org_rec.dei_attribute26);
1504: end if;
1505:
1506: if p_org_rec.dei_attribute27 = p_dei_attribute27 then
1507: hr_transaction_api.set_varchar2_value
1508: (p_transaction_step_id => p_transaction_step_id
1509: ,p_person_id => p_login_person_id
1510: ,p_name => 'P_DEI_ATTRIBUTE27'
1511: ,p_value => p_dei_attribute27);
1509: ,p_person_id => p_login_person_id
1510: ,p_name => 'P_DEI_ATTRIBUTE27'
1511: ,p_value => p_dei_attribute27);
1512: else
1513: hr_transaction_api.set_varchar2_value
1514: (p_transaction_step_id => p_transaction_step_id
1515: ,p_person_id => p_login_person_id
1516: ,p_name => 'P_DEI_ATTRIBUTE27'
1517: ,p_value => p_dei_attribute27
1518: ,p_original_value => p_org_rec.dei_attribute27);
1519: end if;
1520:
1521: if p_org_rec.dei_attribute28 = p_dei_attribute28 then
1522: hr_transaction_api.set_varchar2_value
1523: (p_transaction_step_id => p_transaction_step_id
1524: ,p_person_id => p_login_person_id
1525: ,p_name => 'P_DEI_ATTRIBUTE28'
1526: ,p_value => p_dei_attribute28);
1524: ,p_person_id => p_login_person_id
1525: ,p_name => 'P_DEI_ATTRIBUTE28'
1526: ,p_value => p_dei_attribute28);
1527: else
1528: hr_transaction_api.set_varchar2_value
1529: (p_transaction_step_id => p_transaction_step_id
1530: ,p_person_id => p_login_person_id
1531: ,p_name => 'P_DEI_ATTRIBUTE28'
1532: ,p_value => p_dei_attribute28
1533: ,p_original_value => p_org_rec.dei_attribute28);
1534: end if;
1535:
1536: if p_org_rec.dei_attribute29 = p_dei_attribute29 then
1537: hr_transaction_api.set_varchar2_value
1538: (p_transaction_step_id => p_transaction_step_id
1539: ,p_person_id => p_login_person_id
1540: ,p_name => 'P_DEI_ATTRIBUTE29'
1541: ,p_value => p_dei_attribute29);
1539: ,p_person_id => p_login_person_id
1540: ,p_name => 'P_DEI_ATTRIBUTE29'
1541: ,p_value => p_dei_attribute29);
1542: else
1543: hr_transaction_api.set_varchar2_value
1544: (p_transaction_step_id => p_transaction_step_id
1545: ,p_person_id => p_login_person_id
1546: ,p_name => 'P_DEI_ATTRIBUTE29'
1547: ,p_value => p_dei_attribute29
1548: ,p_original_value => p_org_rec.dei_attribute29);
1549: end if;
1550:
1551: if p_org_rec.dei_attribute30 = p_dei_attribute30 then
1552: hr_transaction_api.set_varchar2_value
1553: (p_transaction_step_id => p_transaction_step_id
1554: ,p_person_id => p_login_person_id
1555: ,p_name => 'P_DEI_ATTRIBUTE30'
1556: ,p_value => p_dei_attribute30);
1554: ,p_person_id => p_login_person_id
1555: ,p_name => 'P_DEI_ATTRIBUTE30'
1556: ,p_value => p_dei_attribute30);
1557: else
1558: hr_transaction_api.set_varchar2_value
1559: (p_transaction_step_id => p_transaction_step_id
1560: ,p_person_id => p_login_person_id
1561: ,p_name => 'P_DEI_ATTRIBUTE30'
1562: ,p_value => p_dei_attribute30
1563: ,p_original_value => p_org_rec.dei_attribute30);
1564: end if;
1565:
1566: if p_org_rec.dei_information_category = p_dei_information_category then
1567: hr_transaction_api.set_varchar2_value
1568: (p_transaction_step_id => p_transaction_step_id
1569: ,p_person_id => p_login_person_id
1570: ,p_name => 'P_DEI_INFORMATION_CATEGORY'
1571: ,p_value => p_dei_information_category);
1569: ,p_person_id => p_login_person_id
1570: ,p_name => 'P_DEI_INFORMATION_CATEGORY'
1571: ,p_value => p_dei_information_category);
1572: else
1573: hr_transaction_api.set_varchar2_value
1574: (p_transaction_step_id => p_transaction_step_id
1575: ,p_person_id => p_login_person_id
1576: ,p_name => 'P_DEI_INFORMATION_CATEGORY'
1577: ,p_value => p_dei_information_category
1578: ,p_original_value => p_org_rec.dei_information_category);
1579: end if;
1580:
1581: if p_org_rec.dei_information1 = p_dei_information1 then
1582: hr_transaction_api.set_varchar2_value
1583: (p_transaction_step_id => p_transaction_step_id
1584: ,p_person_id => p_login_person_id
1585: ,p_name => 'P_DEI_INFORMATION1'
1586: ,p_value => p_dei_information1);
1584: ,p_person_id => p_login_person_id
1585: ,p_name => 'P_DEI_INFORMATION1'
1586: ,p_value => p_dei_information1);
1587: else
1588: hr_transaction_api.set_varchar2_value
1589: (p_transaction_step_id => p_transaction_step_id
1590: ,p_person_id => p_login_person_id
1591: ,p_name => 'P_DEI_INFORMATION1'
1592: ,p_value => p_dei_information1
1593: ,p_original_value => p_org_rec.dei_information1);
1594: end if;
1595:
1596: if p_org_rec.dei_information2 = p_dei_information2 then
1597: hr_transaction_api.set_varchar2_value
1598: (p_transaction_step_id => p_transaction_step_id
1599: ,p_person_id => p_login_person_id
1600: ,p_name => 'P_DEI_INFORMATION2'
1601: ,p_value => p_dei_information2);
1599: ,p_person_id => p_login_person_id
1600: ,p_name => 'P_DEI_INFORMATION2'
1601: ,p_value => p_dei_information2);
1602: else
1603: hr_transaction_api.set_varchar2_value
1604: (p_transaction_step_id => p_transaction_step_id
1605: ,p_person_id => p_login_person_id
1606: ,p_name => 'P_DEI_INFORMATION2'
1607: ,p_value => p_dei_information2
1608: ,p_original_value => p_org_rec.dei_information2);
1609: end if;
1610:
1611: if p_org_rec.dei_information3 = p_dei_information3 then
1612: hr_transaction_api.set_varchar2_value
1613: (p_transaction_step_id => p_transaction_step_id
1614: ,p_person_id => p_login_person_id
1615: ,p_name => 'P_DEI_INFORMATION3'
1616: ,p_value => p_dei_information3);
1614: ,p_person_id => p_login_person_id
1615: ,p_name => 'P_DEI_INFORMATION3'
1616: ,p_value => p_dei_information3);
1617: else
1618: hr_transaction_api.set_varchar2_value
1619: (p_transaction_step_id => p_transaction_step_id
1620: ,p_person_id => p_login_person_id
1621: ,p_name => 'P_DEI_INFORMATION3'
1622: ,p_value => p_dei_information3
1623: ,p_original_value => p_org_rec.dei_information3);
1624: end if;
1625:
1626: if p_org_rec.dei_information4 = p_dei_information4 then
1627: hr_transaction_api.set_varchar2_value
1628: (p_transaction_step_id => p_transaction_step_id
1629: ,p_person_id => p_login_person_id
1630: ,p_name => 'P_DEI_INFORMATION4'
1631: ,p_value => p_dei_information4);
1629: ,p_person_id => p_login_person_id
1630: ,p_name => 'P_DEI_INFORMATION4'
1631: ,p_value => p_dei_information4);
1632: else
1633: hr_transaction_api.set_varchar2_value
1634: (p_transaction_step_id => p_transaction_step_id
1635: ,p_person_id => p_login_person_id
1636: ,p_name => 'P_DEI_INFORMATION4'
1637: ,p_value => p_dei_information4
1638: ,p_original_value => p_org_rec.dei_information4);
1639: end if;
1640:
1641: if p_org_rec.dei_information5 = p_dei_information5 then
1642: hr_transaction_api.set_varchar2_value
1643: (p_transaction_step_id => p_transaction_step_id
1644: ,p_person_id => p_login_person_id
1645: ,p_name => 'P_DEI_INFORMATION5'
1646: ,p_value => p_dei_information5);
1644: ,p_person_id => p_login_person_id
1645: ,p_name => 'P_DEI_INFORMATION5'
1646: ,p_value => p_dei_information5);
1647: else
1648: hr_transaction_api.set_varchar2_value
1649: (p_transaction_step_id => p_transaction_step_id
1650: ,p_person_id => p_login_person_id
1651: ,p_name => 'P_DEI_INFORMATION5'
1652: ,p_value => p_dei_information5
1653: ,p_original_value => p_org_rec.dei_information5);
1654: end if;
1655:
1656: if p_org_rec.dei_information6 = p_dei_information6 then
1657: hr_transaction_api.set_varchar2_value
1658: (p_transaction_step_id => p_transaction_step_id
1659: ,p_person_id => p_login_person_id
1660: ,p_name => 'P_DEI_INFORMATION6'
1661: ,p_value => p_dei_information6);
1659: ,p_person_id => p_login_person_id
1660: ,p_name => 'P_DEI_INFORMATION6'
1661: ,p_value => p_dei_information6);
1662: else
1663: hr_transaction_api.set_varchar2_value
1664: (p_transaction_step_id => p_transaction_step_id
1665: ,p_person_id => p_login_person_id
1666: ,p_name => 'P_DEI_INFORMATION6'
1667: ,p_value => p_dei_information6
1668: ,p_original_value => p_org_rec.dei_information6);
1669: end if;
1670:
1671: if p_org_rec.dei_information7 = p_dei_information7 then
1672: hr_transaction_api.set_varchar2_value
1673: (p_transaction_step_id => p_transaction_step_id
1674: ,p_person_id => p_login_person_id
1675: ,p_name => 'P_DEI_INFORMATION7'
1676: ,p_value => p_dei_information7);
1674: ,p_person_id => p_login_person_id
1675: ,p_name => 'P_DEI_INFORMATION7'
1676: ,p_value => p_dei_information7);
1677: else
1678: hr_transaction_api.set_varchar2_value
1679: (p_transaction_step_id => p_transaction_step_id
1680: ,p_person_id => p_login_person_id
1681: ,p_name => 'P_DEI_INFORMATION7'
1682: ,p_value => p_dei_information7
1683: ,p_original_value => p_org_rec.dei_information7);
1684: end if;
1685:
1686: if p_org_rec.dei_information8 = p_dei_information8 then
1687: hr_transaction_api.set_varchar2_value
1688: (p_transaction_step_id => p_transaction_step_id
1689: ,p_person_id => p_login_person_id
1690: ,p_name => 'P_DEI_INFORMATION8'
1691: ,p_value => p_dei_information8);
1689: ,p_person_id => p_login_person_id
1690: ,p_name => 'P_DEI_INFORMATION8'
1691: ,p_value => p_dei_information8);
1692: else
1693: hr_transaction_api.set_varchar2_value
1694: (p_transaction_step_id => p_transaction_step_id
1695: ,p_person_id => p_login_person_id
1696: ,p_name => 'P_DEI_INFORMATION8'
1697: ,p_value => p_dei_information8
1698: ,p_original_value => p_org_rec.dei_information8);
1699: end if;
1700:
1701: if p_org_rec.dei_information9 = p_dei_information9 then
1702: hr_transaction_api.set_varchar2_value
1703: (p_transaction_step_id => p_transaction_step_id
1704: ,p_person_id => p_login_person_id
1705: ,p_name => 'P_DEI_INFORMATION9'
1706: ,p_value => p_dei_information9);
1704: ,p_person_id => p_login_person_id
1705: ,p_name => 'P_DEI_INFORMATION9'
1706: ,p_value => p_dei_information9);
1707: else
1708: hr_transaction_api.set_varchar2_value
1709: (p_transaction_step_id => p_transaction_step_id
1710: ,p_person_id => p_login_person_id
1711: ,p_name => 'P_DEI_INFORMATION9'
1712: ,p_value => p_dei_information9
1713: ,p_original_value => p_org_rec.dei_information9);
1714: end if;
1715:
1716: if p_org_rec.dei_information10 = p_dei_information10 then
1717: hr_transaction_api.set_varchar2_value
1718: (p_transaction_step_id => p_transaction_step_id
1719: ,p_person_id => p_login_person_id
1720: ,p_name => 'P_DEI_INFORMATION10'
1721: ,p_value => p_dei_information10);
1719: ,p_person_id => p_login_person_id
1720: ,p_name => 'P_DEI_INFORMATION10'
1721: ,p_value => p_dei_information10);
1722: else
1723: hr_transaction_api.set_varchar2_value
1724: (p_transaction_step_id => p_transaction_step_id
1725: ,p_person_id => p_login_person_id
1726: ,p_name => 'P_DEI_INFORMATION10'
1727: ,p_value => p_dei_information10
1727: ,p_value => p_dei_information10
1728: ,p_original_value => p_org_rec.dei_information10);
1729: end if;
1730: if p_org_rec.dei_information11 = p_dei_information11 then
1731: hr_transaction_api.set_varchar2_value
1732: (p_transaction_step_id => p_transaction_step_id
1733: ,p_person_id => p_login_person_id
1734: ,p_name => 'P_DEI_INFORMATION11'
1735: ,p_value => p_dei_information11);
1733: ,p_person_id => p_login_person_id
1734: ,p_name => 'P_DEI_INFORMATION11'
1735: ,p_value => p_dei_information11);
1736: else
1737: hr_transaction_api.set_varchar2_value
1738: (p_transaction_step_id => p_transaction_step_id
1739: ,p_person_id => p_login_person_id
1740: ,p_name => 'P_DEI_INFORMATION11'
1741: ,p_value => p_dei_information11
1742: ,p_original_value => p_org_rec.dei_information11);
1743: end if;
1744:
1745: if p_org_rec.dei_information12 = p_dei_information12 then
1746: hr_transaction_api.set_varchar2_value
1747: (p_transaction_step_id => p_transaction_step_id
1748: ,p_person_id => p_login_person_id
1749: ,p_name => 'P_DEI_INFORMATION12'
1750: ,p_value => p_dei_information12);
1748: ,p_person_id => p_login_person_id
1749: ,p_name => 'P_DEI_INFORMATION12'
1750: ,p_value => p_dei_information12);
1751: else
1752: hr_transaction_api.set_varchar2_value
1753: (p_transaction_step_id => p_transaction_step_id
1754: ,p_person_id => p_login_person_id
1755: ,p_name => 'P_DEI_INFORMATION12'
1756: ,p_value => p_dei_information12
1757: ,p_original_value => p_org_rec.dei_information12);
1758: end if;
1759:
1760: if p_org_rec.dei_information13 = p_dei_information13 then
1761: hr_transaction_api.set_varchar2_value
1762: (p_transaction_step_id => p_transaction_step_id
1763: ,p_person_id => p_login_person_id
1764: ,p_name => 'P_DEI_INFORMATION13'
1765: ,p_value => p_dei_information13);
1763: ,p_person_id => p_login_person_id
1764: ,p_name => 'P_DEI_INFORMATION13'
1765: ,p_value => p_dei_information13);
1766: else
1767: hr_transaction_api.set_varchar2_value
1768: (p_transaction_step_id => p_transaction_step_id
1769: ,p_person_id => p_login_person_id
1770: ,p_name => 'P_DEI_INFORMATION13'
1771: ,p_value => p_dei_information13
1772: ,p_original_value => p_org_rec.dei_information13);
1773: end if;
1774:
1775: if p_org_rec.dei_information14 = p_dei_information14 then
1776: hr_transaction_api.set_varchar2_value
1777: (p_transaction_step_id => p_transaction_step_id
1778: ,p_person_id => p_login_person_id
1779: ,p_name => 'P_DEI_INFORMATION14'
1780: ,p_value => p_dei_information14);
1778: ,p_person_id => p_login_person_id
1779: ,p_name => 'P_DEI_INFORMATION14'
1780: ,p_value => p_dei_information14);
1781: else
1782: hr_transaction_api.set_varchar2_value
1783: (p_transaction_step_id => p_transaction_step_id
1784: ,p_person_id => p_login_person_id
1785: ,p_name => 'P_DEI_INFORMATION14'
1786: ,p_value => p_dei_information14
1787: ,p_original_value => p_org_rec.dei_information14);
1788: end if;
1789:
1790: if p_org_rec.dei_information15 = p_dei_information15 then
1791: hr_transaction_api.set_varchar2_value
1792: (p_transaction_step_id => p_transaction_step_id
1793: ,p_person_id => p_login_person_id
1794: ,p_name => 'P_DEI_INFORMATION15'
1795: ,p_value => p_dei_information15);
1793: ,p_person_id => p_login_person_id
1794: ,p_name => 'P_DEI_INFORMATION15'
1795: ,p_value => p_dei_information15);
1796: else
1797: hr_transaction_api.set_varchar2_value
1798: (p_transaction_step_id => p_transaction_step_id
1799: ,p_person_id => p_login_person_id
1800: ,p_name => 'P_DEI_INFORMATION15'
1801: ,p_value => p_dei_information15
1802: ,p_original_value => p_org_rec.dei_information15);
1803: end if;
1804:
1805: if p_org_rec.dei_information16 = p_dei_information16 then
1806: hr_transaction_api.set_varchar2_value
1807: (p_transaction_step_id => p_transaction_step_id
1808: ,p_person_id => p_login_person_id
1809: ,p_name => 'P_DEI_INFORMATION16'
1810: ,p_value => p_dei_information16);
1808: ,p_person_id => p_login_person_id
1809: ,p_name => 'P_DEI_INFORMATION16'
1810: ,p_value => p_dei_information16);
1811: else
1812: hr_transaction_api.set_varchar2_value
1813: (p_transaction_step_id => p_transaction_step_id
1814: ,p_person_id => p_login_person_id
1815: ,p_name => 'P_DEI_INFORMATION16'
1816: ,p_value => p_dei_information16
1817: ,p_original_value => p_org_rec.dei_information16);
1818: end if;
1819:
1820: if p_org_rec.dei_information17 = p_dei_information17 then
1821: hr_transaction_api.set_varchar2_value
1822: (p_transaction_step_id => p_transaction_step_id
1823: ,p_person_id => p_login_person_id
1824: ,p_name => 'P_DEI_INFORMATION17'
1825: ,p_value => p_dei_information17);
1823: ,p_person_id => p_login_person_id
1824: ,p_name => 'P_DEI_INFORMATION17'
1825: ,p_value => p_dei_information17);
1826: else
1827: hr_transaction_api.set_varchar2_value
1828: (p_transaction_step_id => p_transaction_step_id
1829: ,p_person_id => p_login_person_id
1830: ,p_name => 'P_DEI_INFORMATION17'
1831: ,p_value => p_dei_information17
1832: ,p_original_value => p_org_rec.dei_information17);
1833: end if;
1834:
1835: if p_org_rec.dei_information18 = p_dei_information18 then
1836: hr_transaction_api.set_varchar2_value
1837: (p_transaction_step_id => p_transaction_step_id
1838: ,p_person_id => p_login_person_id
1839: ,p_name => 'P_DEI_INFORMATION18'
1840: ,p_value => p_dei_information18);
1838: ,p_person_id => p_login_person_id
1839: ,p_name => 'P_DEI_INFORMATION18'
1840: ,p_value => p_dei_information18);
1841: else
1842: hr_transaction_api.set_varchar2_value
1843: (p_transaction_step_id => p_transaction_step_id
1844: ,p_person_id => p_login_person_id
1845: ,p_name => 'P_DEI_INFORMATION18'
1846: ,p_value => p_dei_information18
1847: ,p_original_value => p_org_rec.dei_information18);
1848: end if;
1849:
1850: if p_org_rec.dei_information19 = p_dei_information19 then
1851: hr_transaction_api.set_varchar2_value
1852: (p_transaction_step_id => p_transaction_step_id
1853: ,p_person_id => p_login_person_id
1854: ,p_name => 'P_DEI_INFORMATION19'
1855: ,p_value => p_dei_information19);
1853: ,p_person_id => p_login_person_id
1854: ,p_name => 'P_DEI_INFORMATION19'
1855: ,p_value => p_dei_information19);
1856: else
1857: hr_transaction_api.set_varchar2_value
1858: (p_transaction_step_id => p_transaction_step_id
1859: ,p_person_id => p_login_person_id
1860: ,p_name => 'P_DEI_INFORMATION19'
1861: ,p_value => p_dei_information19
1862: ,p_original_value => p_org_rec.dei_information19);
1863: end if;
1864:
1865: if p_org_rec.dei_information20 = p_dei_information20 then
1866: hr_transaction_api.set_varchar2_value
1867: (p_transaction_step_id => p_transaction_step_id
1868: ,p_person_id => p_login_person_id
1869: ,p_name => 'P_DEI_INFORMATION20'
1870: ,p_value => p_dei_information20);
1868: ,p_person_id => p_login_person_id
1869: ,p_name => 'P_DEI_INFORMATION20'
1870: ,p_value => p_dei_information20);
1871: else
1872: hr_transaction_api.set_varchar2_value
1873: (p_transaction_step_id => p_transaction_step_id
1874: ,p_person_id => p_login_person_id
1875: ,p_name => 'P_DEI_INFORMATION20'
1876: ,p_value => p_dei_information20
1877: ,p_original_value => p_org_rec.dei_information20);
1878: end if;
1879:
1880: if p_org_rec.dei_information21 = p_dei_information21 then
1881: hr_transaction_api.set_varchar2_value
1882: (p_transaction_step_id => p_transaction_step_id
1883: ,p_person_id => p_login_person_id
1884: ,p_name => 'P_DEI_INFORMATION21'
1885: ,p_value => p_dei_information21);
1883: ,p_person_id => p_login_person_id
1884: ,p_name => 'P_DEI_INFORMATION21'
1885: ,p_value => p_dei_information21);
1886: else
1887: hr_transaction_api.set_varchar2_value
1888: (p_transaction_step_id => p_transaction_step_id
1889: ,p_person_id => p_login_person_id
1890: ,p_name => 'P_DEI_INFORMATION21'
1891: ,p_value => p_dei_information21
1892: ,p_original_value => p_org_rec.dei_information21);
1893: end if;
1894:
1895: if p_org_rec.dei_information22 = p_dei_information22 then
1896: hr_transaction_api.set_varchar2_value
1897: (p_transaction_step_id => p_transaction_step_id
1898: ,p_person_id => p_login_person_id
1899: ,p_name => 'P_DEI_INFORMATION22'
1900: ,p_value => p_dei_information22);
1898: ,p_person_id => p_login_person_id
1899: ,p_name => 'P_DEI_INFORMATION22'
1900: ,p_value => p_dei_information22);
1901: else
1902: hr_transaction_api.set_varchar2_value
1903: (p_transaction_step_id => p_transaction_step_id
1904: ,p_person_id => p_login_person_id
1905: ,p_name => 'P_DEI_INFORMATION22'
1906: ,p_value => p_dei_information22
1907: ,p_original_value => p_org_rec.dei_information22);
1908: end if;
1909:
1910: if p_org_rec.dei_information23 = p_dei_information23 then
1911: hr_transaction_api.set_varchar2_value
1912: (p_transaction_step_id => p_transaction_step_id
1913: ,p_person_id => p_login_person_id
1914: ,p_name => 'P_DEI_INFORMATION23'
1915: ,p_value => p_dei_information23);
1913: ,p_person_id => p_login_person_id
1914: ,p_name => 'P_DEI_INFORMATION23'
1915: ,p_value => p_dei_information23);
1916: else
1917: hr_transaction_api.set_varchar2_value
1918: (p_transaction_step_id => p_transaction_step_id
1919: ,p_person_id => p_login_person_id
1920: ,p_name => 'P_DEI_INFORMATION23'
1921: ,p_value => p_dei_information23
1922: ,p_original_value => p_org_rec.dei_information23);
1923: end if;
1924:
1925: if p_org_rec.dei_information24 = p_dei_information24 then
1926: hr_transaction_api.set_varchar2_value
1927: (p_transaction_step_id => p_transaction_step_id
1928: ,p_person_id => p_login_person_id
1929: ,p_name => 'P_DEI_INFORMATION24'
1930: ,p_value => p_dei_information24);
1928: ,p_person_id => p_login_person_id
1929: ,p_name => 'P_DEI_INFORMATION24'
1930: ,p_value => p_dei_information24);
1931: else
1932: hr_transaction_api.set_varchar2_value
1933: (p_transaction_step_id => p_transaction_step_id
1934: ,p_person_id => p_login_person_id
1935: ,p_name => 'P_DEI_INFORMATION24'
1936: ,p_value => p_dei_information24
1937: ,p_original_value => p_org_rec.dei_information24);
1938: end if;
1939:
1940: if p_org_rec.dei_information25 = p_dei_information25 then
1941: hr_transaction_api.set_varchar2_value
1942: (p_transaction_step_id => p_transaction_step_id
1943: ,p_person_id => p_login_person_id
1944: ,p_name => 'P_DEI_INFORMATION25'
1945: ,p_value => p_dei_information25);
1943: ,p_person_id => p_login_person_id
1944: ,p_name => 'P_DEI_INFORMATION25'
1945: ,p_value => p_dei_information25);
1946: else
1947: hr_transaction_api.set_varchar2_value
1948: (p_transaction_step_id => p_transaction_step_id
1949: ,p_person_id => p_login_person_id
1950: ,p_name => 'P_DEI_INFORMATION25'
1951: ,p_value => p_dei_information25
1952: ,p_original_value => p_org_rec.dei_information25);
1953: end if;
1954:
1955: if p_org_rec.dei_information26 = p_dei_information26 then
1956: hr_transaction_api.set_varchar2_value
1957: (p_transaction_step_id => p_transaction_step_id
1958: ,p_person_id => p_login_person_id
1959: ,p_name => 'P_DEI_INFORMATION26'
1960: ,p_value => p_dei_information26);
1958: ,p_person_id => p_login_person_id
1959: ,p_name => 'P_DEI_INFORMATION26'
1960: ,p_value => p_dei_information26);
1961: else
1962: hr_transaction_api.set_varchar2_value
1963: (p_transaction_step_id => p_transaction_step_id
1964: ,p_person_id => p_login_person_id
1965: ,p_name => 'P_DEI_INFORMATION26'
1966: ,p_value => p_dei_information26
1967: ,p_original_value => p_org_rec.dei_information26);
1968: end if;
1969:
1970: if p_org_rec.dei_information27 = p_dei_information27 then
1971: hr_transaction_api.set_varchar2_value
1972: (p_transaction_step_id => p_transaction_step_id
1973: ,p_person_id => p_login_person_id
1974: ,p_name => 'P_DEI_INFORMATION27'
1975: ,p_value => p_dei_information27);
1973: ,p_person_id => p_login_person_id
1974: ,p_name => 'P_DEI_INFORMATION27'
1975: ,p_value => p_dei_information27);
1976: else
1977: hr_transaction_api.set_varchar2_value
1978: (p_transaction_step_id => p_transaction_step_id
1979: ,p_person_id => p_login_person_id
1980: ,p_name => 'P_DEI_INFORMATION27'
1981: ,p_value => p_dei_information27
1982: ,p_original_value => p_org_rec.dei_information27);
1983: end if;
1984:
1985: if p_org_rec.dei_information28 = p_dei_information28 then
1986: hr_transaction_api.set_varchar2_value
1987: (p_transaction_step_id => p_transaction_step_id
1988: ,p_person_id => p_login_person_id
1989: ,p_name => 'P_DEI_INFORMATION28'
1990: ,p_value => p_dei_information28);
1988: ,p_person_id => p_login_person_id
1989: ,p_name => 'P_DEI_INFORMATION28'
1990: ,p_value => p_dei_information28);
1991: else
1992: hr_transaction_api.set_varchar2_value
1993: (p_transaction_step_id => p_transaction_step_id
1994: ,p_person_id => p_login_person_id
1995: ,p_name => 'P_DEI_INFORMATION28'
1996: ,p_value => p_dei_information28
1997: ,p_original_value => p_org_rec.dei_information28);
1998: end if;
1999:
2000: if p_org_rec.dei_information29 = p_dei_information29 then
2001: hr_transaction_api.set_varchar2_value
2002: (p_transaction_step_id => p_transaction_step_id
2003: ,p_person_id => p_login_person_id
2004: ,p_name => 'P_DEI_INFORMATION29'
2005: ,p_value => p_dei_information29);
2003: ,p_person_id => p_login_person_id
2004: ,p_name => 'P_DEI_INFORMATION29'
2005: ,p_value => p_dei_information29);
2006: else
2007: hr_transaction_api.set_varchar2_value
2008: (p_transaction_step_id => p_transaction_step_id
2009: ,p_person_id => p_login_person_id
2010: ,p_name => 'P_DEI_INFORMATION29'
2011: ,p_value => p_dei_information29
2012: ,p_original_value => p_org_rec.dei_information29);
2013: end if;
2014:
2015: if p_org_rec.dei_information30 = p_dei_information30 then
2016: hr_transaction_api.set_varchar2_value
2017: (p_transaction_step_id => p_transaction_step_id
2018: ,p_person_id => p_login_person_id
2019: ,p_name => 'P_DEI_INFORMATION30'
2020: ,p_value => p_dei_information30);
2018: ,p_person_id => p_login_person_id
2019: ,p_name => 'P_DEI_INFORMATION30'
2020: ,p_value => p_dei_information30);
2021: else
2022: hr_transaction_api.set_varchar2_value
2023: (p_transaction_step_id => p_transaction_step_id
2024: ,p_person_id => p_login_person_id
2025: ,p_name => 'P_DEI_INFORMATION30'
2026: ,p_value => p_dei_information30
2027: ,p_original_value => p_org_rec.dei_information30);
2028: end if;
2029:
2030: if p_org_rec.request_id = p_request_id then
2031: hr_transaction_api.set_number_value
2032: (p_transaction_step_id => p_transaction_step_id
2033: ,p_person_id => p_login_person_id
2034: ,p_name => 'P_REQUEST_ID'
2035: ,p_value => p_request_id);
2033: ,p_person_id => p_login_person_id
2034: ,p_name => 'P_REQUEST_ID'
2035: ,p_value => p_request_id);
2036: else
2037: hr_transaction_api.set_number_value
2038: (p_transaction_step_id => p_transaction_step_id
2039: ,p_person_id => p_login_person_id
2040: ,p_name => 'P_REQUEST_ID'
2041: ,p_value => p_request_id
2042: ,p_original_value => p_org_rec.request_id);
2043: end if;
2044:
2045: if p_org_rec.program_application_id = p_program_application_id then
2046: hr_transaction_api.set_number_value
2047: (p_transaction_step_id => p_transaction_step_id
2048: ,p_person_id => p_login_person_id
2049: ,p_name => 'P_PROGRAM_APPLICATION_ID'
2050: ,p_value => p_program_application_id
2049: ,p_name => 'P_PROGRAM_APPLICATION_ID'
2050: ,p_value => p_program_application_id
2051: ,p_original_value => p_org_rec.program_application_id);
2052: else
2053: hr_transaction_api.set_number_value
2054: (p_transaction_step_id => p_transaction_step_id
2055: ,p_person_id => p_login_person_id
2056: ,p_name => 'P_PROGRAM_APPLICATION_ID'
2057: ,p_value => p_program_application_id);
2057: ,p_value => p_program_application_id);
2058: end if;
2059:
2060: if p_org_rec.program_id = p_program_id then
2061: hr_transaction_api.set_number_value
2062: (p_transaction_step_id => p_transaction_step_id
2063: ,p_person_id => p_login_person_id
2064: ,p_name => 'P_PROGRAM_ID'
2065: ,p_value => p_program_id
2064: ,p_name => 'P_PROGRAM_ID'
2065: ,p_value => p_program_id
2066: ,p_original_value => p_org_rec.program_id);
2067: else
2068: hr_transaction_api.set_number_value
2069: (p_transaction_step_id => p_transaction_step_id
2070: ,p_person_id => p_login_person_id
2071: ,p_name => 'P_PROGRAM_ID'
2072: ,p_value => p_program_id);
2072: ,p_value => p_program_id);
2073: end if;
2074:
2075: if p_org_rec.program_update_date = p_program_update_date then
2076: hr_transaction_api.set_date_value
2077: (p_transaction_step_id => p_transaction_step_id
2078: ,p_person_id => p_login_person_id
2079: ,p_name => 'P_PROGRAM_UPDATE_DATE'
2080: ,p_value => p_program_update_date);
2078: ,p_person_id => p_login_person_id
2079: ,p_name => 'P_PROGRAM_UPDATE_DATE'
2080: ,p_value => p_program_update_date);
2081: else
2082: hr_transaction_api.set_date_value
2083: (p_transaction_step_id => p_transaction_step_id
2084: ,p_person_id => p_login_person_id
2085: ,p_name => 'P_PROGRAM_UPDATE_DATE'
2086: ,p_value => p_program_update_date
2087: ,p_original_value => p_org_rec.program_update_date);
2088: end if;
2089:
2090: if p_org_rec.object_version_number = p_object_version_number then
2091: hr_transaction_api.set_number_value
2092: (p_transaction_step_id => p_transaction_step_id
2093: ,p_person_id => p_login_person_id
2094: ,p_name => 'P_OBJECT_VERSION_NUMBER'
2095: ,p_value => p_object_version_number);
2093: ,p_person_id => p_login_person_id
2094: ,p_name => 'P_OBJECT_VERSION_NUMBER'
2095: ,p_value => p_object_version_number);
2096: else
2097: hr_transaction_api.set_number_value
2098: (p_transaction_step_id => p_transaction_step_id
2099: ,p_person_id => p_login_person_id
2100: ,p_name => 'P_OBJECT_VERSION_NUMBER'
2101: ,p_value => p_object_version_number
2180: p_transaction_step_id => p_transaction_step_id
2181: ,p_dor_rec => p_dor_rec);
2182:
2183: p_item_type :=
2184: hr_transaction_api.get_varchar2_value
2185: (p_transaction_step_id => p_transaction_step_id
2186: ,p_name => 'P_ITEM_TYPE');
2187:
2188: p_item_key :=
2185: (p_transaction_step_id => p_transaction_step_id
2186: ,p_name => 'P_ITEM_TYPE');
2187:
2188: p_item_key :=
2189: hr_transaction_api.get_varchar2_value
2190: (p_transaction_step_id => p_transaction_step_id
2191: ,p_name => 'P_ITEM_KEY');
2192:
2193: if p_dor_rec.verified_by is null then
2883:
2884: hr_utility.set_location(' Entering:' || l_proc,60);
2885:
2886: p_dor_rec.person_id :=
2887: hr_transaction_api.get_number_value
2888: (p_transaction_step_id => p_transaction_step_id
2889: ,p_name => 'P_PERSON_ID');
2890:
2891: p_dor_rec.document_type_id :=
2888: (p_transaction_step_id => p_transaction_step_id
2889: ,p_name => 'P_PERSON_ID');
2890:
2891: p_dor_rec.document_type_id :=
2892: hr_transaction_api.get_number_value
2893: (p_transaction_step_id => p_transaction_step_id
2894: ,p_name => 'P_DOCUMENT_TYPE_ID');
2895:
2896: p_dor_rec.date_from :=
2893: (p_transaction_step_id => p_transaction_step_id
2894: ,p_name => 'P_DOCUMENT_TYPE_ID');
2895:
2896: p_dor_rec.date_from :=
2897: hr_transaction_api.get_date_value
2898: (p_transaction_step_id => p_transaction_step_id
2899: ,p_name => 'P_DATE_FROM');
2900:
2901: p_dor_rec.date_to :=
2898: (p_transaction_step_id => p_transaction_step_id
2899: ,p_name => 'P_DATE_FROM');
2900:
2901: p_dor_rec.date_to :=
2902: hr_transaction_api.get_date_value
2903: (p_transaction_step_id => p_transaction_step_id
2904: ,p_name => 'P_DATE_TO');
2905:
2906: p_dor_rec.document_number :=
2903: (p_transaction_step_id => p_transaction_step_id
2904: ,p_name => 'P_DATE_TO');
2905:
2906: p_dor_rec.document_number :=
2907: hr_transaction_api.get_varchar2_value
2908: (p_transaction_step_id => p_transaction_step_id
2909: ,p_name => 'P_DOCUMENT_NUMBER');
2910:
2911: p_dor_rec.issued_by :=
2908: (p_transaction_step_id => p_transaction_step_id
2909: ,p_name => 'P_DOCUMENT_NUMBER');
2910:
2911: p_dor_rec.issued_by :=
2912: hr_transaction_api.get_varchar2_value
2913: (p_transaction_step_id => p_transaction_step_id
2914: ,p_name => 'P_ISSUED_BY');
2915:
2916: p_dor_rec.issued_at :=
2913: (p_transaction_step_id => p_transaction_step_id
2914: ,p_name => 'P_ISSUED_BY');
2915:
2916: p_dor_rec.issued_at :=
2917: hr_transaction_api.get_varchar2_value
2918: (p_transaction_step_id => p_transaction_step_id
2919: ,p_name => 'P_ISSUED_AT');
2920:
2921: p_dor_rec.issued_date :=
2918: (p_transaction_step_id => p_transaction_step_id
2919: ,p_name => 'P_ISSUED_AT');
2920:
2921: p_dor_rec.issued_date :=
2922: hr_transaction_api.get_date_value
2923: (p_transaction_step_id => p_transaction_step_id
2924: ,p_name => 'P_ISSUED_DATE');
2925:
2926: p_dor_rec.issuing_authority :=
2923: (p_transaction_step_id => p_transaction_step_id
2924: ,p_name => 'P_ISSUED_DATE');
2925:
2926: p_dor_rec.issuing_authority :=
2927: hr_transaction_api.get_varchar2_value
2928: (p_transaction_step_id => p_transaction_step_id
2929: ,p_name => 'P_ISSUING_AUTHORITY');
2930:
2931: p_dor_rec.verified_by :=
2928: (p_transaction_step_id => p_transaction_step_id
2929: ,p_name => 'P_ISSUING_AUTHORITY');
2930:
2931: p_dor_rec.verified_by :=
2932: hr_transaction_api.get_number_value
2933: (p_transaction_step_id => p_transaction_step_id
2934: ,p_name => 'P_VERIFIED_BY');
2935:
2936: p_dor_rec.verified_date :=
2933: (p_transaction_step_id => p_transaction_step_id
2934: ,p_name => 'P_VERIFIED_BY');
2935:
2936: p_dor_rec.verified_date :=
2937: hr_transaction_api.get_date_value
2938: (p_transaction_step_id => p_transaction_step_id
2939: ,p_name => 'P_VERIFIED_DATE');
2940:
2941: p_dor_rec.related_object_name :=
2938: (p_transaction_step_id => p_transaction_step_id
2939: ,p_name => 'P_VERIFIED_DATE');
2940:
2941: p_dor_rec.related_object_name :=
2942: hr_transaction_api.get_varchar2_value
2943: (p_transaction_step_id => p_transaction_step_id
2944: ,p_name => 'P_RELATED_OBJECT_NAME');
2945:
2946: p_dor_rec.related_object_id_col :=
2943: (p_transaction_step_id => p_transaction_step_id
2944: ,p_name => 'P_RELATED_OBJECT_NAME');
2945:
2946: p_dor_rec.related_object_id_col :=
2947: hr_transaction_api.get_varchar2_value
2948: (p_transaction_step_id => p_transaction_step_id
2949: ,p_name => 'P_RELATED_OBJECT_ID_COL');
2950:
2951: p_dor_rec.related_object_id :=
2948: (p_transaction_step_id => p_transaction_step_id
2949: ,p_name => 'P_RELATED_OBJECT_ID_COL');
2950:
2951: p_dor_rec.related_object_id :=
2952: hr_transaction_api.get_number_value
2953: (p_transaction_step_id => p_transaction_step_id
2954: ,p_name => 'P_RELATED_OBJECT_ID');
2955:
2956: p_dor_rec.dei_attribute_category :=
2953: (p_transaction_step_id => p_transaction_step_id
2954: ,p_name => 'P_RELATED_OBJECT_ID');
2955:
2956: p_dor_rec.dei_attribute_category :=
2957: hr_transaction_api.get_varchar2_value
2958: (p_transaction_step_id => p_transaction_step_id
2959: ,p_name => 'P_DEI_ATTRIBUTE_CATEGORY');
2960:
2961: p_dor_rec.dei_attribute1 :=
2958: (p_transaction_step_id => p_transaction_step_id
2959: ,p_name => 'P_DEI_ATTRIBUTE_CATEGORY');
2960:
2961: p_dor_rec.dei_attribute1 :=
2962: hr_transaction_api.get_varchar2_value
2963: (p_transaction_step_id => p_transaction_step_id
2964: ,p_name => 'P_DEI_ATTRIBUTE1');
2965:
2966: p_dor_rec.dei_attribute2 :=
2963: (p_transaction_step_id => p_transaction_step_id
2964: ,p_name => 'P_DEI_ATTRIBUTE1');
2965:
2966: p_dor_rec.dei_attribute2 :=
2967: hr_transaction_api.get_varchar2_value
2968: (p_transaction_step_id => p_transaction_step_id
2969: ,p_name => 'P_DEI_ATTRIBUTE2');
2970:
2971: p_dor_rec.dei_attribute3 :=
2968: (p_transaction_step_id => p_transaction_step_id
2969: ,p_name => 'P_DEI_ATTRIBUTE2');
2970:
2971: p_dor_rec.dei_attribute3 :=
2972: hr_transaction_api.get_varchar2_value
2973: (p_transaction_step_id => p_transaction_step_id
2974: ,p_name => 'P_DEI_ATTRIBUTE3');
2975:
2976: p_dor_rec.dei_attribute4 :=
2973: (p_transaction_step_id => p_transaction_step_id
2974: ,p_name => 'P_DEI_ATTRIBUTE3');
2975:
2976: p_dor_rec.dei_attribute4 :=
2977: hr_transaction_api.get_varchar2_value
2978: (p_transaction_step_id => p_transaction_step_id
2979: ,p_name => 'P_DEI_ATTRIBUTE4');
2980:
2981: p_dor_rec.dei_attribute4 :=
2978: (p_transaction_step_id => p_transaction_step_id
2979: ,p_name => 'P_DEI_ATTRIBUTE4');
2980:
2981: p_dor_rec.dei_attribute4 :=
2982: hr_transaction_api.get_varchar2_value
2983: (p_transaction_step_id => p_transaction_step_id
2984: ,p_name => 'P_DEI_ATTRIBUTE5');
2985:
2986: p_dor_rec.dei_attribute6 :=
2983: (p_transaction_step_id => p_transaction_step_id
2984: ,p_name => 'P_DEI_ATTRIBUTE5');
2985:
2986: p_dor_rec.dei_attribute6 :=
2987: hr_transaction_api.get_varchar2_value
2988: (p_transaction_step_id => p_transaction_step_id
2989: ,p_name => 'P_DEI_ATTRIBUTE6');
2990:
2991: p_dor_rec.dei_attribute7 :=
2988: (p_transaction_step_id => p_transaction_step_id
2989: ,p_name => 'P_DEI_ATTRIBUTE6');
2990:
2991: p_dor_rec.dei_attribute7 :=
2992: hr_transaction_api.get_varchar2_value
2993: (p_transaction_step_id => p_transaction_step_id
2994: ,p_name => 'P_DEI_ATTRIBUTE7');
2995:
2996: p_dor_rec.dei_attribute8 :=
2993: (p_transaction_step_id => p_transaction_step_id
2994: ,p_name => 'P_DEI_ATTRIBUTE7');
2995:
2996: p_dor_rec.dei_attribute8 :=
2997: hr_transaction_api.get_varchar2_value
2998: (p_transaction_step_id => p_transaction_step_id
2999: ,p_name => 'P_DEI_ATTRIBUTE8');
3000:
3001: p_dor_rec.dei_attribute9 :=
2998: (p_transaction_step_id => p_transaction_step_id
2999: ,p_name => 'P_DEI_ATTRIBUTE8');
3000:
3001: p_dor_rec.dei_attribute9 :=
3002: hr_transaction_api.get_varchar2_value
3003: (p_transaction_step_id => p_transaction_step_id
3004: ,p_name => 'P_DEI_ATTRIBUTE9');
3005:
3006: p_dor_rec.dei_attribute10 :=
3003: (p_transaction_step_id => p_transaction_step_id
3004: ,p_name => 'P_DEI_ATTRIBUTE9');
3005:
3006: p_dor_rec.dei_attribute10 :=
3007: hr_transaction_api.get_varchar2_value
3008: (p_transaction_step_id => p_transaction_step_id
3009: ,p_name => 'P_DEI_ATTRIBUTE10');
3010:
3011: p_dor_rec.dei_attribute11 :=
3008: (p_transaction_step_id => p_transaction_step_id
3009: ,p_name => 'P_DEI_ATTRIBUTE10');
3010:
3011: p_dor_rec.dei_attribute11 :=
3012: hr_transaction_api.get_varchar2_value
3013: (p_transaction_step_id => p_transaction_step_id
3014: ,p_name => 'P_DEI_ATTRIBUTE11');
3015:
3016: p_dor_rec.dei_attribute12 :=
3013: (p_transaction_step_id => p_transaction_step_id
3014: ,p_name => 'P_DEI_ATTRIBUTE11');
3015:
3016: p_dor_rec.dei_attribute12 :=
3017: hr_transaction_api.get_varchar2_value
3018: (p_transaction_step_id => p_transaction_step_id
3019: ,p_name => 'P_DEI_ATTRIBUTE12');
3020:
3021: p_dor_rec.dei_attribute13 :=
3018: (p_transaction_step_id => p_transaction_step_id
3019: ,p_name => 'P_DEI_ATTRIBUTE12');
3020:
3021: p_dor_rec.dei_attribute13 :=
3022: hr_transaction_api.get_varchar2_value
3023: (p_transaction_step_id => p_transaction_step_id
3024: ,p_name => 'P_DEI_ATTRIBUTE13');
3025:
3026: p_dor_rec.dei_attribute14 :=
3023: (p_transaction_step_id => p_transaction_step_id
3024: ,p_name => 'P_DEI_ATTRIBUTE13');
3025:
3026: p_dor_rec.dei_attribute14 :=
3027: hr_transaction_api.get_varchar2_value
3028: (p_transaction_step_id => p_transaction_step_id
3029: ,p_name => 'P_DEI_ATTRIBUTE14');
3030:
3031: p_dor_rec.dei_attribute15 :=
3028: (p_transaction_step_id => p_transaction_step_id
3029: ,p_name => 'P_DEI_ATTRIBUTE14');
3030:
3031: p_dor_rec.dei_attribute15 :=
3032: hr_transaction_api.get_varchar2_value
3033: (p_transaction_step_id => p_transaction_step_id
3034: ,p_name => 'P_DEI_ATTRIBUTE15');
3035:
3036: p_dor_rec.dei_attribute16 :=
3033: (p_transaction_step_id => p_transaction_step_id
3034: ,p_name => 'P_DEI_ATTRIBUTE15');
3035:
3036: p_dor_rec.dei_attribute16 :=
3037: hr_transaction_api.get_varchar2_value
3038: (p_transaction_step_id => p_transaction_step_id
3039: ,p_name => 'P_DEI_ATTRIBUTE16');
3040:
3041: p_dor_rec.dei_attribute17 :=
3038: (p_transaction_step_id => p_transaction_step_id
3039: ,p_name => 'P_DEI_ATTRIBUTE16');
3040:
3041: p_dor_rec.dei_attribute17 :=
3042: hr_transaction_api.get_varchar2_value
3043: (p_transaction_step_id => p_transaction_step_id
3044: ,p_name => 'P_DEI_ATTRIBUTE17');
3045:
3046: p_dor_rec.dei_attribute18 :=
3043: (p_transaction_step_id => p_transaction_step_id
3044: ,p_name => 'P_DEI_ATTRIBUTE17');
3045:
3046: p_dor_rec.dei_attribute18 :=
3047: hr_transaction_api.get_varchar2_value
3048: (p_transaction_step_id => p_transaction_step_id
3049: ,p_name => 'P_DEI_ATTRIBUTE18');
3050:
3051: p_dor_rec.dei_attribute19 :=
3048: (p_transaction_step_id => p_transaction_step_id
3049: ,p_name => 'P_DEI_ATTRIBUTE18');
3050:
3051: p_dor_rec.dei_attribute19 :=
3052: hr_transaction_api.get_varchar2_value
3053: (p_transaction_step_id => p_transaction_step_id
3054: ,p_name => 'P_DEI_ATTRIBUTE19');
3055:
3056: p_dor_rec.dei_attribute20 :=
3053: (p_transaction_step_id => p_transaction_step_id
3054: ,p_name => 'P_DEI_ATTRIBUTE19');
3055:
3056: p_dor_rec.dei_attribute20 :=
3057: hr_transaction_api.get_varchar2_value
3058: (p_transaction_step_id => p_transaction_step_id
3059: ,p_name => 'P_DEI_ATTRIBUTE20');
3060:
3061: p_dor_rec.dei_attribute21 :=
3058: (p_transaction_step_id => p_transaction_step_id
3059: ,p_name => 'P_DEI_ATTRIBUTE20');
3060:
3061: p_dor_rec.dei_attribute21 :=
3062: hr_transaction_api.get_varchar2_value
3063: (p_transaction_step_id => p_transaction_step_id
3064: ,p_name => 'P_DEI_ATTRIBUTE21');
3065:
3066: p_dor_rec.dei_attribute22 :=
3063: (p_transaction_step_id => p_transaction_step_id
3064: ,p_name => 'P_DEI_ATTRIBUTE21');
3065:
3066: p_dor_rec.dei_attribute22 :=
3067: hr_transaction_api.get_varchar2_value
3068: (p_transaction_step_id => p_transaction_step_id
3069: ,p_name => 'P_DEI_ATTRIBUTE22');
3070:
3071: p_dor_rec.dei_attribute23 :=
3068: (p_transaction_step_id => p_transaction_step_id
3069: ,p_name => 'P_DEI_ATTRIBUTE22');
3070:
3071: p_dor_rec.dei_attribute23 :=
3072: hr_transaction_api.get_varchar2_value
3073: (p_transaction_step_id => p_transaction_step_id
3074: ,p_name => 'P_DEI_ATTRIBUTE23');
3075:
3076: p_dor_rec.dei_attribute24 :=
3073: (p_transaction_step_id => p_transaction_step_id
3074: ,p_name => 'P_DEI_ATTRIBUTE23');
3075:
3076: p_dor_rec.dei_attribute24 :=
3077: hr_transaction_api.get_varchar2_value
3078: (p_transaction_step_id => p_transaction_step_id
3079: ,p_name => 'P_DEI_ATTRIBUTE24');
3080:
3081: p_dor_rec.dei_attribute25 :=
3078: (p_transaction_step_id => p_transaction_step_id
3079: ,p_name => 'P_DEI_ATTRIBUTE24');
3080:
3081: p_dor_rec.dei_attribute25 :=
3082: hr_transaction_api.get_varchar2_value
3083: (p_transaction_step_id => p_transaction_step_id
3084: ,p_name => 'P_DEI_ATTRIBUTE25');
3085:
3086: p_dor_rec.dei_attribute26 :=
3083: (p_transaction_step_id => p_transaction_step_id
3084: ,p_name => 'P_DEI_ATTRIBUTE25');
3085:
3086: p_dor_rec.dei_attribute26 :=
3087: hr_transaction_api.get_varchar2_value
3088: (p_transaction_step_id => p_transaction_step_id
3089: ,p_name => 'P_DEI_ATTRIBUTE26');
3090:
3091: p_dor_rec.dei_attribute27 :=
3088: (p_transaction_step_id => p_transaction_step_id
3089: ,p_name => 'P_DEI_ATTRIBUTE26');
3090:
3091: p_dor_rec.dei_attribute27 :=
3092: hr_transaction_api.get_varchar2_value
3093: (p_transaction_step_id => p_transaction_step_id
3094: ,p_name => 'P_DEI_ATTRIBUTE27');
3095:
3096: p_dor_rec.dei_attribute28 :=
3093: (p_transaction_step_id => p_transaction_step_id
3094: ,p_name => 'P_DEI_ATTRIBUTE27');
3095:
3096: p_dor_rec.dei_attribute28 :=
3097: hr_transaction_api.get_varchar2_value
3098: (p_transaction_step_id => p_transaction_step_id
3099: ,p_name => 'P_DEI_ATTRIBUTE28');
3100:
3101: p_dor_rec.dei_attribute29 :=
3098: (p_transaction_step_id => p_transaction_step_id
3099: ,p_name => 'P_DEI_ATTRIBUTE28');
3100:
3101: p_dor_rec.dei_attribute29 :=
3102: hr_transaction_api.get_varchar2_value
3103: (p_transaction_step_id => p_transaction_step_id
3104: ,p_name => 'P_DEI_ATTRIBUTE29');
3105:
3106: p_dor_rec.dei_attribute30 :=
3103: (p_transaction_step_id => p_transaction_step_id
3104: ,p_name => 'P_DEI_ATTRIBUTE29');
3105:
3106: p_dor_rec.dei_attribute30 :=
3107: hr_transaction_api.get_varchar2_value
3108: (p_transaction_step_id => p_transaction_step_id
3109: ,p_name => 'P_DEI_ATTRIBUTE30');
3110:
3111: p_dor_rec.dei_information_category :=
3108: (p_transaction_step_id => p_transaction_step_id
3109: ,p_name => 'P_DEI_ATTRIBUTE30');
3110:
3111: p_dor_rec.dei_information_category :=
3112: hr_transaction_api.get_varchar2_value
3113: (p_transaction_step_id => p_transaction_step_id
3114: ,p_name => 'P_DEI_INFORMATION_CATEGORY');
3115:
3116: p_dor_rec.dei_information1 :=
3113: (p_transaction_step_id => p_transaction_step_id
3114: ,p_name => 'P_DEI_INFORMATION_CATEGORY');
3115:
3116: p_dor_rec.dei_information1 :=
3117: hr_transaction_api.get_varchar2_value
3118: (p_transaction_step_id => p_transaction_step_id
3119: ,p_name => 'P_DEI_INFORMATION1');
3120:
3121: p_dor_rec.dei_information2 :=
3118: (p_transaction_step_id => p_transaction_step_id
3119: ,p_name => 'P_DEI_INFORMATION1');
3120:
3121: p_dor_rec.dei_information2 :=
3122: hr_transaction_api.get_varchar2_value
3123: (p_transaction_step_id => p_transaction_step_id
3124: ,p_name => 'P_DEI_INFORMATION2');
3125:
3126: p_dor_rec.dei_information3 :=
3123: (p_transaction_step_id => p_transaction_step_id
3124: ,p_name => 'P_DEI_INFORMATION2');
3125:
3126: p_dor_rec.dei_information3 :=
3127: hr_transaction_api.get_varchar2_value
3128: (p_transaction_step_id => p_transaction_step_id
3129: ,p_name => 'P_DEI_INFORMATION3');
3130:
3131: p_dor_rec.dei_information4 :=
3128: (p_transaction_step_id => p_transaction_step_id
3129: ,p_name => 'P_DEI_INFORMATION3');
3130:
3131: p_dor_rec.dei_information4 :=
3132: hr_transaction_api.get_varchar2_value
3133: (p_transaction_step_id => p_transaction_step_id
3134: ,p_name => 'P_DEI_INFORMATION4');
3135:
3136: p_dor_rec.dei_information5 :=
3133: (p_transaction_step_id => p_transaction_step_id
3134: ,p_name => 'P_DEI_INFORMATION4');
3135:
3136: p_dor_rec.dei_information5 :=
3137: hr_transaction_api.get_varchar2_value
3138: (p_transaction_step_id => p_transaction_step_id
3139: ,p_name => 'P_DEI_INFORMATION5');
3140:
3141: p_dor_rec.dei_information6 :=
3138: (p_transaction_step_id => p_transaction_step_id
3139: ,p_name => 'P_DEI_INFORMATION5');
3140:
3141: p_dor_rec.dei_information6 :=
3142: hr_transaction_api.get_varchar2_value
3143: (p_transaction_step_id => p_transaction_step_id
3144: ,p_name => 'P_DEI_INFORMATION6');
3145:
3146: p_dor_rec.dei_information7 :=
3143: (p_transaction_step_id => p_transaction_step_id
3144: ,p_name => 'P_DEI_INFORMATION6');
3145:
3146: p_dor_rec.dei_information7 :=
3147: hr_transaction_api.get_varchar2_value
3148: (p_transaction_step_id => p_transaction_step_id
3149: ,p_name => 'P_DEI_INFORMATION7');
3150:
3151: p_dor_rec.dei_information8 :=
3148: (p_transaction_step_id => p_transaction_step_id
3149: ,p_name => 'P_DEI_INFORMATION7');
3150:
3151: p_dor_rec.dei_information8 :=
3152: hr_transaction_api.get_varchar2_value
3153: (p_transaction_step_id => p_transaction_step_id
3154: ,p_name => 'P_DEI_INFORMATION8');
3155:
3156: p_dor_rec.dei_information9 :=
3153: (p_transaction_step_id => p_transaction_step_id
3154: ,p_name => 'P_DEI_INFORMATION8');
3155:
3156: p_dor_rec.dei_information9 :=
3157: hr_transaction_api.get_varchar2_value
3158: (p_transaction_step_id => p_transaction_step_id
3159: ,p_name => 'P_DEI_INFORMATION9');
3160:
3161: p_dor_rec.dei_information10 :=
3158: (p_transaction_step_id => p_transaction_step_id
3159: ,p_name => 'P_DEI_INFORMATION9');
3160:
3161: p_dor_rec.dei_information10 :=
3162: hr_transaction_api.get_varchar2_value
3163: (p_transaction_step_id => p_transaction_step_id
3164: ,p_name => 'P_DEI_INFORMATION10');
3165:
3166: p_dor_rec.dei_information11 :=
3163: (p_transaction_step_id => p_transaction_step_id
3164: ,p_name => 'P_DEI_INFORMATION10');
3165:
3166: p_dor_rec.dei_information11 :=
3167: hr_transaction_api.get_varchar2_value
3168: (p_transaction_step_id => p_transaction_step_id
3169: ,p_name => 'P_DEI_INFORMATION11');
3170:
3171: p_dor_rec.dei_information12 :=
3168: (p_transaction_step_id => p_transaction_step_id
3169: ,p_name => 'P_DEI_INFORMATION11');
3170:
3171: p_dor_rec.dei_information12 :=
3172: hr_transaction_api.get_varchar2_value
3173: (p_transaction_step_id => p_transaction_step_id
3174: ,p_name => 'P_DEI_INFORMATION12');
3175:
3176: p_dor_rec.dei_information13 :=
3173: (p_transaction_step_id => p_transaction_step_id
3174: ,p_name => 'P_DEI_INFORMATION12');
3175:
3176: p_dor_rec.dei_information13 :=
3177: hr_transaction_api.get_varchar2_value
3178: (p_transaction_step_id => p_transaction_step_id
3179: ,p_name => 'P_DEI_INFORMATION13');
3180:
3181: p_dor_rec.dei_information14 :=
3178: (p_transaction_step_id => p_transaction_step_id
3179: ,p_name => 'P_DEI_INFORMATION13');
3180:
3181: p_dor_rec.dei_information14 :=
3182: hr_transaction_api.get_varchar2_value
3183: (p_transaction_step_id => p_transaction_step_id
3184: ,p_name => 'P_DEI_INFORMATION14');
3185:
3186: p_dor_rec.dei_information15 :=
3183: (p_transaction_step_id => p_transaction_step_id
3184: ,p_name => 'P_DEI_INFORMATION14');
3185:
3186: p_dor_rec.dei_information15 :=
3187: hr_transaction_api.get_varchar2_value
3188: (p_transaction_step_id => p_transaction_step_id
3189: ,p_name => 'P_DEI_INFORMATION15');
3190:
3191: p_dor_rec.dei_information16 :=
3188: (p_transaction_step_id => p_transaction_step_id
3189: ,p_name => 'P_DEI_INFORMATION15');
3190:
3191: p_dor_rec.dei_information16 :=
3192: hr_transaction_api.get_varchar2_value
3193: (p_transaction_step_id => p_transaction_step_id
3194: ,p_name => 'P_DEI_INFORMATION16');
3195:
3196: p_dor_rec.dei_information17 :=
3193: (p_transaction_step_id => p_transaction_step_id
3194: ,p_name => 'P_DEI_INFORMATION16');
3195:
3196: p_dor_rec.dei_information17 :=
3197: hr_transaction_api.get_varchar2_value
3198: (p_transaction_step_id => p_transaction_step_id
3199: ,p_name => 'P_DEI_INFORMATION17');
3200:
3201: p_dor_rec.dei_information18 :=
3198: (p_transaction_step_id => p_transaction_step_id
3199: ,p_name => 'P_DEI_INFORMATION17');
3200:
3201: p_dor_rec.dei_information18 :=
3202: hr_transaction_api.get_varchar2_value
3203: (p_transaction_step_id => p_transaction_step_id
3204: ,p_name => 'P_DEI_INFORMATION18');
3205:
3206: p_dor_rec.dei_information19 :=
3203: (p_transaction_step_id => p_transaction_step_id
3204: ,p_name => 'P_DEI_INFORMATION18');
3205:
3206: p_dor_rec.dei_information19 :=
3207: hr_transaction_api.get_varchar2_value
3208: (p_transaction_step_id => p_transaction_step_id
3209: ,p_name => 'P_DEI_INFORMATION19');
3210:
3211: p_dor_rec.dei_information20 :=
3208: (p_transaction_step_id => p_transaction_step_id
3209: ,p_name => 'P_DEI_INFORMATION19');
3210:
3211: p_dor_rec.dei_information20 :=
3212: hr_transaction_api.get_varchar2_value
3213: (p_transaction_step_id => p_transaction_step_id
3214: ,p_name => 'P_DEI_INFORMATION20');
3215:
3216: p_dor_rec.dei_information21 :=
3213: (p_transaction_step_id => p_transaction_step_id
3214: ,p_name => 'P_DEI_INFORMATION20');
3215:
3216: p_dor_rec.dei_information21 :=
3217: hr_transaction_api.get_varchar2_value
3218: (p_transaction_step_id => p_transaction_step_id
3219: ,p_name => 'P_DEI_INFORMATION21');
3220:
3221: p_dor_rec.dei_information22 :=
3218: (p_transaction_step_id => p_transaction_step_id
3219: ,p_name => 'P_DEI_INFORMATION21');
3220:
3221: p_dor_rec.dei_information22 :=
3222: hr_transaction_api.get_varchar2_value
3223: (p_transaction_step_id => p_transaction_step_id
3224: ,p_name => 'P_DEI_INFORMATION22');
3225:
3226: p_dor_rec.dei_information23 :=
3223: (p_transaction_step_id => p_transaction_step_id
3224: ,p_name => 'P_DEI_INFORMATION22');
3225:
3226: p_dor_rec.dei_information23 :=
3227: hr_transaction_api.get_varchar2_value
3228: (p_transaction_step_id => p_transaction_step_id
3229: ,p_name => 'P_DEI_INFORMATION23');
3230:
3231: p_dor_rec.dei_information24 :=
3228: (p_transaction_step_id => p_transaction_step_id
3229: ,p_name => 'P_DEI_INFORMATION23');
3230:
3231: p_dor_rec.dei_information24 :=
3232: hr_transaction_api.get_varchar2_value
3233: (p_transaction_step_id => p_transaction_step_id
3234: ,p_name => 'P_DEI_INFORMATION24');
3235:
3236: p_dor_rec.dei_information25 :=
3233: (p_transaction_step_id => p_transaction_step_id
3234: ,p_name => 'P_DEI_INFORMATION24');
3235:
3236: p_dor_rec.dei_information25 :=
3237: hr_transaction_api.get_varchar2_value
3238: (p_transaction_step_id => p_transaction_step_id
3239: ,p_name => 'P_DEI_INFORMATION25');
3240:
3241: p_dor_rec.dei_information26 :=
3238: (p_transaction_step_id => p_transaction_step_id
3239: ,p_name => 'P_DEI_INFORMATION25');
3240:
3241: p_dor_rec.dei_information26 :=
3242: hr_transaction_api.get_varchar2_value
3243: (p_transaction_step_id => p_transaction_step_id
3244: ,p_name => 'P_DEI_INFORMATION26');
3245:
3246: p_dor_rec.dei_information27 :=
3243: (p_transaction_step_id => p_transaction_step_id
3244: ,p_name => 'P_DEI_INFORMATION26');
3245:
3246: p_dor_rec.dei_information27 :=
3247: hr_transaction_api.get_varchar2_value
3248: (p_transaction_step_id => p_transaction_step_id
3249: ,p_name => 'P_DEI_INFORMATION27');
3250:
3251: p_dor_rec.dei_information28 :=
3248: (p_transaction_step_id => p_transaction_step_id
3249: ,p_name => 'P_DEI_INFORMATION27');
3250:
3251: p_dor_rec.dei_information28 :=
3252: hr_transaction_api.get_varchar2_value
3253: (p_transaction_step_id => p_transaction_step_id
3254: ,p_name => 'P_DEI_INFORMATION28');
3255:
3256: p_dor_rec.dei_information29 :=
3253: (p_transaction_step_id => p_transaction_step_id
3254: ,p_name => 'P_DEI_INFORMATION28');
3255:
3256: p_dor_rec.dei_information29 :=
3257: hr_transaction_api.get_varchar2_value
3258: (p_transaction_step_id => p_transaction_step_id
3259: ,p_name => 'P_DEI_INFORMATION29');
3260:
3261: p_dor_rec.dei_information30 :=
3258: (p_transaction_step_id => p_transaction_step_id
3259: ,p_name => 'P_DEI_INFORMATION29');
3260:
3261: p_dor_rec.dei_information30 :=
3262: hr_transaction_api.get_varchar2_value
3263: (p_transaction_step_id => p_transaction_step_id
3264: ,p_name => 'P_DEI_INFORMATION30');
3265:
3266: p_dor_rec.request_id :=
3263: (p_transaction_step_id => p_transaction_step_id
3264: ,p_name => 'P_DEI_INFORMATION30');
3265:
3266: p_dor_rec.request_id :=
3267: hr_transaction_api.get_number_value
3268: (p_transaction_step_id => p_transaction_step_id
3269: ,p_name => 'P_REQUEST_ID');
3270:
3271: p_dor_rec.program_application_id :=
3268: (p_transaction_step_id => p_transaction_step_id
3269: ,p_name => 'P_REQUEST_ID');
3270:
3271: p_dor_rec.program_application_id :=
3272: hr_transaction_api.get_number_value
3273: (p_transaction_step_id => p_transaction_step_id
3274: ,p_name => 'P_PROGRAM_APPLICATION_ID');
3275:
3276: p_dor_rec.program_id :=
3273: (p_transaction_step_id => p_transaction_step_id
3274: ,p_name => 'P_PROGRAM_APPLICATION_ID');
3275:
3276: p_dor_rec.program_id :=
3277: hr_transaction_api.get_number_value
3278: (p_transaction_step_id => p_transaction_step_id
3279: ,p_name => 'P_PROGRAM_ID');
3280:
3281: p_dor_rec.program_update_date :=
3278: (p_transaction_step_id => p_transaction_step_id
3279: ,p_name => 'P_PROGRAM_ID');
3280:
3281: p_dor_rec.program_update_date :=
3282: hr_transaction_api.get_date_value
3283: (p_transaction_step_id => p_transaction_step_id
3284: ,p_name => 'P_PROGRAM_UPDATE_DATE');
3285:
3286: p_dor_rec.document_extra_info_id :=
3283: (p_transaction_step_id => p_transaction_step_id
3284: ,p_name => 'P_PROGRAM_UPDATE_DATE');
3285:
3286: p_dor_rec.document_extra_info_id :=
3287: hr_transaction_api.get_number_value
3288: (p_transaction_step_id => p_transaction_step_id
3289: ,p_name => 'P_DOCUMENT_EXTRA_INFO_ID');
3290:
3291: p_dor_rec.object_version_number :=
3288: (p_transaction_step_id => p_transaction_step_id
3289: ,p_name => 'P_DOCUMENT_EXTRA_INFO_ID');
3290:
3291: p_dor_rec.object_version_number :=
3292: hr_transaction_api.get_number_value
3293: (p_transaction_step_id => p_transaction_step_id
3294: ,p_name => 'P_OBJECT_VERSION_NUMBER');
3295:
3296: EXCEPTION
3911:
3912: wf_engine.abortprocess(itemtype => p_item_type
3913: ,itemkey => p_item_key);
3914:
3915: hr_transaction_api.rollback_transaction
3916: (p_transaction_id => p_transaction_id);
3917:
3918: hr_utility.set_location('Leaving:'|| g_package||'.'||l_proc, 2);
3919:
3975: FROM hr_api_transactions trx,hr_api_transaction_steps trs,hr_api_transaction_values trv
3976: WHERE trx.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'
3977: and trx.transaction_id = trs.transaction_id
3978: and trs.transaction_step_id = trv.TRANSACTION_STEP_ID
3979: and hr_transaction_api.get_number_value(trs.TRANSACTION_STEP_ID, 'P_DOCUMENT_EXTRA_INFO_ID')
3980: =p_document_extra_info_id
3981: and trx.selected_person_id in (select person_id from hr_document_extra_info
3982: where DOCUMENT_EXTRA_INFO_ID = p_document_extra_info_id) ;*/
3983:
3986: FROM hr_api_transactions trx,hr_api_transaction_steps trs,hr_api_transaction_values trv
3987: WHERE trx.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'
3988: and trx.transaction_id = trs.transaction_id
3989: and trs.transaction_step_id = trv.TRANSACTION_STEP_ID
3990: and hr_transaction_api.get_number_value(trs.TRANSACTION_STEP_ID, 'P_DOCUMENT_EXTRA_INFO_ID')
3991: =p_document_extra_info_id
3992: and trx.selected_person_id in (select person_id from hr_document_extra_info
3993: where DOCUMENT_EXTRA_INFO_ID = p_document_extra_info_id) ;
3994: