85: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
86: ' l_transaction_id: '||l_transaction_id);
87:
88:
89: hr_transaction_api.get_transaction_step_info
90: (p_Item_Type => p_item_type
91: ,p_Item_Key => p_item_key
92: ,p_activity_id => p_activity_id
93: ,p_transaction_step_id => l_transaction_step_id
109: hr_utility.trace('l_transaction_step_id < 1:'||l_proc);
110:
111: --There is no transaction step for this transaction.
112: --Create a step within this new transaction
113: hr_transaction_api.create_transaction_step
114: (p_validate => false
115: ,p_creator_person_id => p_login_person_id
116: ,p_transaction_id => l_transaction_id
117: ,p_api_name => g_package || '.PROCESS_API'
562: ' p_item_type: '||p_item_type||
563: ' p_item_key: '||p_item_key||
564: ' p_activity_id: '||p_activity_id);
565:
566: hr_transaction_api.get_transaction_step_info
567: (p_item_type => p_item_type
568: ,p_item_key => p_item_key
569: ,p_activity_id => p_activity_id
570: ,p_transaction_step_id => l_trans_step_id
658: 'hr_process_eit_ss.get_eit_data_from_tt' ||
659: ' p_transaction_step_id: '||p_transaction_step_id);
660:
661:
662: p_person_id := hr_transaction_api.get_number_value
663: (p_transaction_step_id => p_transaction_step_id
664: ,p_name => 'P_PERSON_ID');
665:
666: p_login_person_id := hr_transaction_api.get_number_value
662: p_person_id := hr_transaction_api.get_number_value
663: (p_transaction_step_id => p_transaction_step_id
664: ,p_name => 'P_PERSON_ID');
665:
666: p_login_person_id := hr_transaction_api.get_number_value
667: (p_transaction_step_id => p_transaction_step_id
668: ,p_name => 'P_LOGIN_PERSON_ID');
669:
670: p_eit_type := hr_transaction_api.get_varchar2_value
666: p_login_person_id := hr_transaction_api.get_number_value
667: (p_transaction_step_id => p_transaction_step_id
668: ,p_name => 'P_LOGIN_PERSON_ID');
669:
670: p_eit_type := hr_transaction_api.get_varchar2_value
671: (p_transaction_step_id => p_transaction_step_id
672: ,p_name => 'P_EIT_TYPE');
673:
674: p_eit_type_id := hr_transaction_api.get_number_value
670: p_eit_type := hr_transaction_api.get_varchar2_value
671: (p_transaction_step_id => p_transaction_step_id
672: ,p_name => 'P_EIT_TYPE');
673:
674: p_eit_type_id := hr_transaction_api.get_number_value
675: (p_transaction_step_id => p_transaction_step_id
676: ,p_name => 'P_EIT_TYPE_ID');
677:
678: -- start registration
699:
700: -- end registration
701: --
702:
703: p_eit_number := hr_transaction_api.get_number_value
704: (p_transaction_step_id => p_transaction_step_id
705: ,p_name => 'P_EIT_NUMBER');
706:
707: p_active_view := hr_transaction_api.get_varchar2_value
703: p_eit_number := hr_transaction_api.get_number_value
704: (p_transaction_step_id => p_transaction_step_id
705: ,p_name => 'P_EIT_NUMBER');
706:
707: p_active_view := hr_transaction_api.get_varchar2_value
708: (p_transaction_step_id => p_transaction_step_id
709: ,p_name => 'P_ACTIVE_VIEW');
710:
711: p_active_row_id := hr_transaction_api.get_number_value
707: p_active_view := hr_transaction_api.get_varchar2_value
708: (p_transaction_step_id => p_transaction_step_id
709: ,p_name => 'P_ACTIVE_VIEW');
710:
711: p_active_row_id := hr_transaction_api.get_number_value
712: (p_transaction_step_id => p_transaction_step_id
713: ,p_name => 'P_ACTIVE_ROW_ID');
714:
715: if(hr_utility.debug_enabled) then
741: --
742: l_eit_table(i) := HR_EIT_STRUCTURE_TYPE
743: (
744: -- action
745: hr_transaction_api.get_varchar2_value
746: (p_transaction_step_id => p_transaction_step_id
747: ,p_name => 'P_ACTION_'||i)
748:
749: -- extra info id
746: (p_transaction_step_id => p_transaction_step_id
747: ,p_name => 'P_ACTION_'||i)
748:
749: -- extra info id
750: ,hr_transaction_api.get_number_value
751: (p_transaction_step_id => p_transaction_step_id
752: ,p_name => 'P_EXTRA_INFO_ID_'||i)
753:
754: --object_version_number
751: (p_transaction_step_id => p_transaction_step_id
752: ,p_name => 'P_EXTRA_INFO_ID_'||i)
753:
754: --object_version_number
755: ,hr_transaction_api.get_number_value
756: (p_transaction_step_id => p_transaction_step_id
757: ,p_name => 'P_OBJECT_VERSION_NUMBER_'||i)
758:
759: --information_type
756: (p_transaction_step_id => p_transaction_step_id
757: ,p_name => 'P_OBJECT_VERSION_NUMBER_'||i)
758:
759: --information_type
760: ,hr_transaction_api.get_varchar2_value
761: (p_transaction_step_id => p_transaction_step_id
762: ,p_name => 'P_INFORMATION_TYPE_'||i)
763:
764: --attribute_category
761: (p_transaction_step_id => p_transaction_step_id
762: ,p_name => 'P_INFORMATION_TYPE_'||i)
763:
764: --attribute_category
765: ,hr_transaction_api.get_varchar2_value
766: (p_transaction_step_id => p_transaction_step_id
767: ,p_name => 'P_ATTRIBUTE_CATEGORY_'||i)
768:
769: --attribute1
766: (p_transaction_step_id => p_transaction_step_id
767: ,p_name => 'P_ATTRIBUTE_CATEGORY_'||i)
768:
769: --attribute1
770: ,hr_transaction_api.get_varchar2_value
771: (p_transaction_step_id => p_transaction_step_id
772: ,p_name => 'P_ATTRIBUTE1_'||i)
773:
774: --attribute2
771: (p_transaction_step_id => p_transaction_step_id
772: ,p_name => 'P_ATTRIBUTE1_'||i)
773:
774: --attribute2
775: ,hr_transaction_api.get_varchar2_value
776: (p_transaction_step_id => p_transaction_step_id
777: ,p_name => 'P_ATTRIBUTE2_'||i)
778:
779: --attribute3
776: (p_transaction_step_id => p_transaction_step_id
777: ,p_name => 'P_ATTRIBUTE2_'||i)
778:
779: --attribute3
780: ,hr_transaction_api.get_varchar2_value
781: (p_transaction_step_id => p_transaction_step_id
782: ,p_name => 'P_ATTRIBUTE3_'||i)
783:
784: --attribute4
781: (p_transaction_step_id => p_transaction_step_id
782: ,p_name => 'P_ATTRIBUTE3_'||i)
783:
784: --attribute4
785: ,hr_transaction_api.get_varchar2_value
786: (p_transaction_step_id => p_transaction_step_id
787: ,p_name => 'P_ATTRIBUTE4_'||i)
788:
789: --attribute5
786: (p_transaction_step_id => p_transaction_step_id
787: ,p_name => 'P_ATTRIBUTE4_'||i)
788:
789: --attribute5
790: ,hr_transaction_api.get_varchar2_value
791: (p_transaction_step_id => p_transaction_step_id
792: ,p_name => 'P_ATTRIBUTE5_'||i)
793:
794: --attribute6
791: (p_transaction_step_id => p_transaction_step_id
792: ,p_name => 'P_ATTRIBUTE5_'||i)
793:
794: --attribute6
795: ,hr_transaction_api.get_varchar2_value
796: (p_transaction_step_id => p_transaction_step_id
797: ,p_name => 'P_ATTRIBUTE6_'||i)
798:
799: --attribute7
796: (p_transaction_step_id => p_transaction_step_id
797: ,p_name => 'P_ATTRIBUTE6_'||i)
798:
799: --attribute7
800: ,hr_transaction_api.get_varchar2_value
801: (p_transaction_step_id => p_transaction_step_id
802: ,p_name => 'P_ATTRIBUTE7_'||i)
803:
804: --attribute8
801: (p_transaction_step_id => p_transaction_step_id
802: ,p_name => 'P_ATTRIBUTE7_'||i)
803:
804: --attribute8
805: ,hr_transaction_api.get_varchar2_value
806: (p_transaction_step_id => p_transaction_step_id
807: ,p_name => 'P_ATTRIBUTE8_'||i)
808:
809: --attribute9
806: (p_transaction_step_id => p_transaction_step_id
807: ,p_name => 'P_ATTRIBUTE8_'||i)
808:
809: --attribute9
810: ,hr_transaction_api.get_varchar2_value
811: (p_transaction_step_id => p_transaction_step_id
812: ,p_name => 'P_ATTRIBUTE9_'||i)
813:
814: --attribute10
811: (p_transaction_step_id => p_transaction_step_id
812: ,p_name => 'P_ATTRIBUTE9_'||i)
813:
814: --attribute10
815: ,hr_transaction_api.get_varchar2_value
816: (p_transaction_step_id => p_transaction_step_id
817: ,p_name => 'P_ATTRIBUTE10_'||i)
818:
819: --attribute11
816: (p_transaction_step_id => p_transaction_step_id
817: ,p_name => 'P_ATTRIBUTE10_'||i)
818:
819: --attribute11
820: ,hr_transaction_api.get_varchar2_value
821: (p_transaction_step_id => p_transaction_step_id
822: ,p_name => 'P_ATTRIBUTE11_'||i)
823:
824: --attribute12
821: (p_transaction_step_id => p_transaction_step_id
822: ,p_name => 'P_ATTRIBUTE11_'||i)
823:
824: --attribute12
825: ,hr_transaction_api.get_varchar2_value
826: (p_transaction_step_id => p_transaction_step_id
827: ,p_name => 'P_ATTRIBUTE12_'||i)
828:
829: --attribute13
826: (p_transaction_step_id => p_transaction_step_id
827: ,p_name => 'P_ATTRIBUTE12_'||i)
828:
829: --attribute13
830: ,hr_transaction_api.get_varchar2_value
831: (p_transaction_step_id => p_transaction_step_id
832: ,p_name => 'P_ATTRIBUTE13_'||i)
833:
834: --attribute14
831: (p_transaction_step_id => p_transaction_step_id
832: ,p_name => 'P_ATTRIBUTE13_'||i)
833:
834: --attribute14
835: ,hr_transaction_api.get_varchar2_value
836: (p_transaction_step_id => p_transaction_step_id
837: ,p_name => 'P_ATTRIBUTE14_'||i)
838:
839: --attribute15
836: (p_transaction_step_id => p_transaction_step_id
837: ,p_name => 'P_ATTRIBUTE14_'||i)
838:
839: --attribute15
840: ,hr_transaction_api.get_varchar2_value
841: (p_transaction_step_id => p_transaction_step_id
842: ,p_name => 'P_ATTRIBUTE15_'||i)
843:
844: --attribute16
841: (p_transaction_step_id => p_transaction_step_id
842: ,p_name => 'P_ATTRIBUTE15_'||i)
843:
844: --attribute16
845: ,hr_transaction_api.get_varchar2_value
846: (p_transaction_step_id => p_transaction_step_id
847: ,p_name => 'P_ATTRIBUTE16_'||i)
848:
849: --attribute17
846: (p_transaction_step_id => p_transaction_step_id
847: ,p_name => 'P_ATTRIBUTE16_'||i)
848:
849: --attribute17
850: ,hr_transaction_api.get_varchar2_value
851: (p_transaction_step_id => p_transaction_step_id
852: ,p_name => 'P_ATTRIBUTE17_'||i)
853:
854: --attribute18
851: (p_transaction_step_id => p_transaction_step_id
852: ,p_name => 'P_ATTRIBUTE17_'||i)
853:
854: --attribute18
855: ,hr_transaction_api.get_varchar2_value
856: (p_transaction_step_id => p_transaction_step_id
857: ,p_name => 'P_ATTRIBUTE18_'||i)
858:
859: --attribute19
856: (p_transaction_step_id => p_transaction_step_id
857: ,p_name => 'P_ATTRIBUTE18_'||i)
858:
859: --attribute19
860: ,hr_transaction_api.get_varchar2_value
861: (p_transaction_step_id => p_transaction_step_id
862: ,p_name => 'P_ATTRIBUTE19_'||i)
863:
864: --attribute20
861: (p_transaction_step_id => p_transaction_step_id
862: ,p_name => 'P_ATTRIBUTE19_'||i)
863:
864: --attribute20
865: ,hr_transaction_api.get_varchar2_value
866: (p_transaction_step_id => p_transaction_step_id
867: ,p_name => 'P_ATTRIBUTE20_'||i)
868:
869: --information_category
866: (p_transaction_step_id => p_transaction_step_id
867: ,p_name => 'P_ATTRIBUTE20_'||i)
868:
869: --information_category
870: ,hr_transaction_api.get_varchar2_value
871: (p_transaction_step_id => p_transaction_step_id
872: ,p_name => 'P_INFORMATION_CATEGORY_'||i)
873:
874: --information1
871: (p_transaction_step_id => p_transaction_step_id
872: ,p_name => 'P_INFORMATION_CATEGORY_'||i)
873:
874: --information1
875: ,hr_transaction_api.get_varchar2_value
876: (p_transaction_step_id => p_transaction_step_id
877: ,p_name => 'P_INFORMATION1_'||i)
878:
879: --information2
876: (p_transaction_step_id => p_transaction_step_id
877: ,p_name => 'P_INFORMATION1_'||i)
878:
879: --information2
880: ,hr_transaction_api.get_varchar2_value
881: (p_transaction_step_id => p_transaction_step_id
882: ,p_name => 'P_INFORMATION2_'||i)
883:
884: --information3
881: (p_transaction_step_id => p_transaction_step_id
882: ,p_name => 'P_INFORMATION2_'||i)
883:
884: --information3
885: ,hr_transaction_api.get_varchar2_value
886: (p_transaction_step_id => p_transaction_step_id
887: ,p_name => 'P_INFORMATION3_'||i)
888:
889: --information4
886: (p_transaction_step_id => p_transaction_step_id
887: ,p_name => 'P_INFORMATION3_'||i)
888:
889: --information4
890: ,hr_transaction_api.get_varchar2_value
891: (p_transaction_step_id => p_transaction_step_id
892: ,p_name => 'P_INFORMATION4_'||i)
893:
894: --information5
891: (p_transaction_step_id => p_transaction_step_id
892: ,p_name => 'P_INFORMATION4_'||i)
893:
894: --information5
895: ,hr_transaction_api.get_varchar2_value
896: (p_transaction_step_id => p_transaction_step_id
897: ,p_name => 'P_INFORMATION5_'||i)
898:
899: --information6
896: (p_transaction_step_id => p_transaction_step_id
897: ,p_name => 'P_INFORMATION5_'||i)
898:
899: --information6
900: ,hr_transaction_api.get_varchar2_value
901: (p_transaction_step_id => p_transaction_step_id
902: ,p_name => 'P_INFORMATION6_'||i)
903:
904: --information7
901: (p_transaction_step_id => p_transaction_step_id
902: ,p_name => 'P_INFORMATION6_'||i)
903:
904: --information7
905: ,hr_transaction_api.get_varchar2_value
906: (p_transaction_step_id => p_transaction_step_id
907: ,p_name => 'P_INFORMATION7_'||i)
908:
909: --information8
906: (p_transaction_step_id => p_transaction_step_id
907: ,p_name => 'P_INFORMATION7_'||i)
908:
909: --information8
910: ,hr_transaction_api.get_varchar2_value
911: (p_transaction_step_id => p_transaction_step_id
912: ,p_name => 'P_INFORMATION8_'||i)
913:
914: --information9
911: (p_transaction_step_id => p_transaction_step_id
912: ,p_name => 'P_INFORMATION8_'||i)
913:
914: --information9
915: ,hr_transaction_api.get_varchar2_value
916: (p_transaction_step_id => p_transaction_step_id
917: ,p_name => 'P_INFORMATION9_'||i)
918:
919: --information10
916: (p_transaction_step_id => p_transaction_step_id
917: ,p_name => 'P_INFORMATION9_'||i)
918:
919: --information10
920: ,hr_transaction_api.get_varchar2_value
921: (p_transaction_step_id => p_transaction_step_id
922: ,p_name => 'P_INFORMATION10_'||i)
923:
924: --information11
921: (p_transaction_step_id => p_transaction_step_id
922: ,p_name => 'P_INFORMATION10_'||i)
923:
924: --information11
925: ,hr_transaction_api.get_varchar2_value
926: (p_transaction_step_id => p_transaction_step_id
927: ,p_name => 'P_INFORMATION11_'||i)
928:
929: --information12
926: (p_transaction_step_id => p_transaction_step_id
927: ,p_name => 'P_INFORMATION11_'||i)
928:
929: --information12
930: ,hr_transaction_api.get_varchar2_value
931: (p_transaction_step_id => p_transaction_step_id
932: ,p_name => 'P_INFORMATION12_'||i)
933:
934: --information13
931: (p_transaction_step_id => p_transaction_step_id
932: ,p_name => 'P_INFORMATION12_'||i)
933:
934: --information13
935: ,hr_transaction_api.get_varchar2_value
936: (p_transaction_step_id => p_transaction_step_id
937: ,p_name => 'P_INFORMATION13_'||i)
938:
939: --information14
936: (p_transaction_step_id => p_transaction_step_id
937: ,p_name => 'P_INFORMATION13_'||i)
938:
939: --information14
940: ,hr_transaction_api.get_varchar2_value
941: (p_transaction_step_id => p_transaction_step_id
942: ,p_name => 'P_INFORMATION14_'||i)
943:
944: --information15
941: (p_transaction_step_id => p_transaction_step_id
942: ,p_name => 'P_INFORMATION14_'||i)
943:
944: --information15
945: ,hr_transaction_api.get_varchar2_value
946: (p_transaction_step_id => p_transaction_step_id
947: ,p_name => 'P_INFORMATION15_'||i)
948:
949: --information16
946: (p_transaction_step_id => p_transaction_step_id
947: ,p_name => 'P_INFORMATION15_'||i)
948:
949: --information16
950: ,hr_transaction_api.get_varchar2_value
951: (p_transaction_step_id => p_transaction_step_id
952: ,p_name => 'P_INFORMATION16_'||i)
953:
954: --information17
951: (p_transaction_step_id => p_transaction_step_id
952: ,p_name => 'P_INFORMATION16_'||i)
953:
954: --information17
955: ,hr_transaction_api.get_varchar2_value
956: (p_transaction_step_id => p_transaction_step_id
957: ,p_name => 'P_INFORMATION17_'||i)
958:
959: --information18
956: (p_transaction_step_id => p_transaction_step_id
957: ,p_name => 'P_INFORMATION17_'||i)
958:
959: --information18
960: ,hr_transaction_api.get_varchar2_value
961: (p_transaction_step_id => p_transaction_step_id
962: ,p_name => 'P_INFORMATION18_'||i)
963:
964: --information19
961: (p_transaction_step_id => p_transaction_step_id
962: ,p_name => 'P_INFORMATION18_'||i)
963:
964: --information19
965: ,hr_transaction_api.get_varchar2_value
966: (p_transaction_step_id => p_transaction_step_id
967: ,p_name => 'P_INFORMATION19_'||i)
968:
969: --information20
966: (p_transaction_step_id => p_transaction_step_id
967: ,p_name => 'P_INFORMATION19_'||i)
968:
969: --information20
970: ,hr_transaction_api.get_varchar2_value
971: (p_transaction_step_id => p_transaction_step_id
972: ,p_name => 'P_INFORMATION20_'||i)
973:
974: --information21
971: (p_transaction_step_id => p_transaction_step_id
972: ,p_name => 'P_INFORMATION20_'||i)
973:
974: --information21
975: ,hr_transaction_api.get_varchar2_value
976: (p_transaction_step_id => p_transaction_step_id
977: ,p_name => 'P_INFORMATION21_'||i)
978:
979: --information22
976: (p_transaction_step_id => p_transaction_step_id
977: ,p_name => 'P_INFORMATION21_'||i)
978:
979: --information22
980: ,hr_transaction_api.get_varchar2_value
981: (p_transaction_step_id => p_transaction_step_id
982: ,p_name => 'P_INFORMATION22_'||i)
983:
984: --information23
981: (p_transaction_step_id => p_transaction_step_id
982: ,p_name => 'P_INFORMATION22_'||i)
983:
984: --information23
985: ,hr_transaction_api.get_varchar2_value
986: (p_transaction_step_id => p_transaction_step_id
987: ,p_name => 'P_INFORMATION23_'||i)
988:
989: --information24
986: (p_transaction_step_id => p_transaction_step_id
987: ,p_name => 'P_INFORMATION23_'||i)
988:
989: --information24
990: ,hr_transaction_api.get_varchar2_value
991: (p_transaction_step_id => p_transaction_step_id
992: ,p_name => 'P_INFORMATION24_'||i)
993:
994: --information25
991: (p_transaction_step_id => p_transaction_step_id
992: ,p_name => 'P_INFORMATION24_'||i)
993:
994: --information25
995: ,hr_transaction_api.get_varchar2_value
996: (p_transaction_step_id => p_transaction_step_id
997: ,p_name => 'P_INFORMATION25_'||i)
998:
999: --information26
996: (p_transaction_step_id => p_transaction_step_id
997: ,p_name => 'P_INFORMATION25_'||i)
998:
999: --information26
1000: ,hr_transaction_api.get_varchar2_value
1001: (p_transaction_step_id => p_transaction_step_id
1002: ,p_name => 'P_INFORMATION26_'||i)
1003:
1004: --information27
1001: (p_transaction_step_id => p_transaction_step_id
1002: ,p_name => 'P_INFORMATION26_'||i)
1003:
1004: --information27
1005: ,hr_transaction_api.get_varchar2_value
1006: (p_transaction_step_id => p_transaction_step_id
1007: ,p_name => 'P_INFORMATION27_'||i)
1008:
1009: --information28
1006: (p_transaction_step_id => p_transaction_step_id
1007: ,p_name => 'P_INFORMATION27_'||i)
1008:
1009: --information28
1010: ,hr_transaction_api.get_varchar2_value
1011: (p_transaction_step_id => p_transaction_step_id
1012: ,p_name => 'P_INFORMATION28_'||i)
1013:
1014: --information29
1011: (p_transaction_step_id => p_transaction_step_id
1012: ,p_name => 'P_INFORMATION28_'||i)
1013:
1014: --information29
1015: ,hr_transaction_api.get_varchar2_value
1016: (p_transaction_step_id => p_transaction_step_id
1017: ,p_name => 'P_INFORMATION29_'||i)
1018:
1019: --information30
1016: (p_transaction_step_id => p_transaction_step_id
1017: ,p_name => 'P_INFORMATION29_'||i)
1018:
1019: --information30
1020: ,hr_transaction_api.get_varchar2_value
1021: (p_transaction_step_id => p_transaction_step_id
1022: ,p_name => 'P_INFORMATION30_'||i));
1023:
1024: END LOOP;