eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_ADD_TRAINING_SS dependencies on HR_TRANSACTION_API

Line 133: IF ( hr_transaction_api.transaction_step_exist

129: --
130:
131: -- Delete transaction step if exist
132: --
133: IF ( hr_transaction_api.transaction_step_exist
134: (p_item_type => p_item_type
135: ,p_item_key => p_item_key
136: ,p_activity_id => p_activity_id) ) THEN
137:

Line 138: hr_transaction_api.get_transaction_step_info

134: (p_item_type => p_item_type
135: ,p_item_key => p_item_key
136: ,p_activity_id => p_activity_id) ) THEN
137:
138: hr_transaction_api.get_transaction_step_info
139: (p_item_type => p_item_type
140: ,p_item_key => p_item_key
141: ,p_activity_id => p_activity_id
142: ,p_transaction_step_id => l_old_transaction_step_id

Line 145: hr_transaction_api.delete_transaction_step

141: ,p_activity_id => p_activity_id
142: ,p_transaction_step_id => l_old_transaction_step_id
143: ,p_object_version_number => l_old_object_version_number);
144:
145: hr_transaction_api.delete_transaction_step
146: (p_validate => FALSE
147: ,p_transaction_step_id => l_old_transaction_step_id
148: ,p_person_id => p_login_person_id
149: ,p_object_version_number => l_old_object_version_number);

Line 202: hr_transaction_api.create_transaction_step

198:
199: --
200: -- Create a transaction step
201: --
202: hr_transaction_api.create_transaction_step
203: (p_validate => FALSE
204: ,p_creator_person_id => p_login_person_id
205: ,p_transaction_id => l_transaction_id
206: ,p_api_name => g_package || '.PROCESS_API'

Line 552: hr_transaction_api.get_transaction_step_info

548: l_trans_step_rows NUMBER ;
549: l_add_trg_data VARCHAR2(4000);
550:
551: BEGIN
552: hr_transaction_api.get_transaction_step_info
553: (p_item_type => p_item_type
554: ,p_item_key => p_item_key
555: ,p_activity_id => p_activity_id
556: ,p_transaction_step_id => l_trans_step_ids

Line 638: l_historyid := hr_transaction_api.get_varchar2_value

634:
635: l_temp varchar2(150);
636: BEGIN
637:
638: l_historyid := hr_transaction_api.get_varchar2_value
639: (p_transaction_step_id => p_transaction_step_id
640: ,p_name => 'P_HISTORYID');
641:
642: l_title := hr_transaction_api.get_varchar2_value

Line 642: l_title := hr_transaction_api.get_varchar2_value

638: l_historyid := hr_transaction_api.get_varchar2_value
639: (p_transaction_step_id => p_transaction_step_id
640: ,p_name => 'P_HISTORYID');
641:
642: l_title := hr_transaction_api.get_varchar2_value
643: (p_transaction_step_id => p_transaction_step_id
644: ,p_name => 'P_TITLE');
645:
646: l_supplier := hr_transaction_api.get_varchar2_value

Line 646: l_supplier := hr_transaction_api.get_varchar2_value

642: l_title := hr_transaction_api.get_varchar2_value
643: (p_transaction_step_id => p_transaction_step_id
644: ,p_name => 'P_TITLE');
645:
646: l_supplier := hr_transaction_api.get_varchar2_value
647: (p_transaction_step_id => p_transaction_step_id
648: ,p_name => 'P_SUPPLIER');
649:
650: l_eq_ota_activity := hr_transaction_api.get_varchar2_value

Line 650: l_eq_ota_activity := hr_transaction_api.get_varchar2_value

646: l_supplier := hr_transaction_api.get_varchar2_value
647: (p_transaction_step_id => p_transaction_step_id
648: ,p_name => 'P_SUPPLIER');
649:
650: l_eq_ota_activity := hr_transaction_api.get_varchar2_value
651: (p_transaction_step_id => p_transaction_step_id
652: ,p_name => 'P_EQ_OTA_ACTIVITY');
653:
654: l_location := hr_transaction_api.get_varchar2_value

Line 654: l_location := hr_transaction_api.get_varchar2_value

650: l_eq_ota_activity := hr_transaction_api.get_varchar2_value
651: (p_transaction_step_id => p_transaction_step_id
652: ,p_name => 'P_EQ_OTA_ACTIVITY');
653:
654: l_location := hr_transaction_api.get_varchar2_value
655: (p_transaction_step_id => p_transaction_step_id
656: ,p_name => 'P_LOCATION');
657:
658: l_trntype := hr_transaction_api.get_varchar2_value

Line 658: l_trntype := hr_transaction_api.get_varchar2_value

654: l_location := hr_transaction_api.get_varchar2_value
655: (p_transaction_step_id => p_transaction_step_id
656: ,p_name => 'P_LOCATION');
657:
658: l_trntype := hr_transaction_api.get_varchar2_value
659: (p_transaction_step_id => p_transaction_step_id
660: ,p_name => 'P_TRNTYPE');
661:
662: l_duration := hr_transaction_api.get_varchar2_value

Line 662: l_duration := hr_transaction_api.get_varchar2_value

658: l_trntype := hr_transaction_api.get_varchar2_value
659: (p_transaction_step_id => p_transaction_step_id
660: ,p_name => 'P_TRNTYPE');
661:
662: l_duration := hr_transaction_api.get_varchar2_value
663: (p_transaction_step_id => p_transaction_step_id
664: ,p_name => 'P_DURATION');
665:
666: l_duration_unit := hr_transaction_api.get_varchar2_value

Line 666: l_duration_unit := hr_transaction_api.get_varchar2_value

662: l_duration := hr_transaction_api.get_varchar2_value
663: (p_transaction_step_id => p_transaction_step_id
664: ,p_name => 'P_DURATION');
665:
666: l_duration_unit := hr_transaction_api.get_varchar2_value
667: (p_transaction_step_id => p_transaction_step_id
668: ,p_name => 'P_DURATION_UNIT');
669:
670: l_status := hr_transaction_api.get_varchar2_value

Line 670: l_status := hr_transaction_api.get_varchar2_value

666: l_duration_unit := hr_transaction_api.get_varchar2_value
667: (p_transaction_step_id => p_transaction_step_id
668: ,p_name => 'P_DURATION_UNIT');
669:
670: l_status := hr_transaction_api.get_varchar2_value
671: (p_transaction_step_id => p_transaction_step_id
672: ,p_name => 'P_STATUS');
673:
674: l_completion_date := hr_transaction_api.get_date_value

Line 674: l_completion_date := hr_transaction_api.get_date_value

670: l_status := hr_transaction_api.get_varchar2_value
671: (p_transaction_step_id => p_transaction_step_id
672: ,p_name => 'P_STATUS');
673:
674: l_completion_date := hr_transaction_api.get_date_value
675: (p_transaction_step_id => p_transaction_step_id
676: ,p_name => 'P_COMPLETION_DATE');
677:
678: l_award := hr_transaction_api.get_varchar2_value

Line 678: l_award := hr_transaction_api.get_varchar2_value

674: l_completion_date := hr_transaction_api.get_date_value
675: (p_transaction_step_id => p_transaction_step_id
676: ,p_name => 'P_COMPLETION_DATE');
677:
678: l_award := hr_transaction_api.get_varchar2_value
679: (p_transaction_step_id => p_transaction_step_id
680: ,p_name => 'P_AWARD');
681:
682: l_score := hr_transaction_api.get_varchar2_value

Line 682: l_score := hr_transaction_api.get_varchar2_value

678: l_award := hr_transaction_api.get_varchar2_value
679: (p_transaction_step_id => p_transaction_step_id
680: ,p_name => 'P_AWARD');
681:
682: l_score := hr_transaction_api.get_varchar2_value
683: (p_transaction_step_id => p_transaction_step_id
684: ,p_name => 'P_SCORE');
685:
686: l_internal_contact_person := hr_transaction_api.get_varchar2_value

Line 686: l_internal_contact_person := hr_transaction_api.get_varchar2_value

682: l_score := hr_transaction_api.get_varchar2_value
683: (p_transaction_step_id => p_transaction_step_id
684: ,p_name => 'P_SCORE');
685:
686: l_internal_contact_person := hr_transaction_api.get_varchar2_value
687: (p_transaction_step_id => p_transaction_step_id
688: ,p_name => 'P_INTERNAL_CONTACT_PERSON');
689:
690: l_nth_information_category := hr_transaction_api.get_varchar2_value

Line 690: l_nth_information_category := hr_transaction_api.get_varchar2_value

686: l_internal_contact_person := hr_transaction_api.get_varchar2_value
687: (p_transaction_step_id => p_transaction_step_id
688: ,p_name => 'P_INTERNAL_CONTACT_PERSON');
689:
690: l_nth_information_category := hr_transaction_api.get_varchar2_value
691: (p_transaction_step_id => p_transaction_step_id
692: ,p_name => 'P_NTH_INFORMATION_CATEGORY');
693:
694: l_nth_information1 := hr_transaction_api.get_varchar2_value

Line 694: l_nth_information1 := hr_transaction_api.get_varchar2_value

690: l_nth_information_category := hr_transaction_api.get_varchar2_value
691: (p_transaction_step_id => p_transaction_step_id
692: ,p_name => 'P_NTH_INFORMATION_CATEGORY');
693:
694: l_nth_information1 := hr_transaction_api.get_varchar2_value
695: (p_transaction_step_id => p_transaction_step_id
696: ,p_name => 'P_NTH_INFORMATION1');
697:
698: l_nth_information2 := hr_transaction_api.get_varchar2_value

Line 698: l_nth_information2 := hr_transaction_api.get_varchar2_value

694: l_nth_information1 := hr_transaction_api.get_varchar2_value
695: (p_transaction_step_id => p_transaction_step_id
696: ,p_name => 'P_NTH_INFORMATION1');
697:
698: l_nth_information2 := hr_transaction_api.get_varchar2_value
699: (p_transaction_step_id => p_transaction_step_id
700: ,p_name => 'P_NTH_INFORMATION2');
701:
702: l_nth_information3 := hr_transaction_api.get_varchar2_value

Line 702: l_nth_information3 := hr_transaction_api.get_varchar2_value

698: l_nth_information2 := hr_transaction_api.get_varchar2_value
699: (p_transaction_step_id => p_transaction_step_id
700: ,p_name => 'P_NTH_INFORMATION2');
701:
702: l_nth_information3 := hr_transaction_api.get_varchar2_value
703: (p_transaction_step_id => p_transaction_step_id
704: ,p_name => 'P_NTH_INFORMATION3');
705:
706: l_nth_information4 := hr_transaction_api.get_varchar2_value

Line 706: l_nth_information4 := hr_transaction_api.get_varchar2_value

702: l_nth_information3 := hr_transaction_api.get_varchar2_value
703: (p_transaction_step_id => p_transaction_step_id
704: ,p_name => 'P_NTH_INFORMATION3');
705:
706: l_nth_information4 := hr_transaction_api.get_varchar2_value
707: (p_transaction_step_id => p_transaction_step_id
708: ,p_name => 'P_NTH_INFORMATION4');
709:
710: l_nth_information5 := hr_transaction_api.get_varchar2_value

Line 710: l_nth_information5 := hr_transaction_api.get_varchar2_value

706: l_nth_information4 := hr_transaction_api.get_varchar2_value
707: (p_transaction_step_id => p_transaction_step_id
708: ,p_name => 'P_NTH_INFORMATION4');
709:
710: l_nth_information5 := hr_transaction_api.get_varchar2_value
711: (p_transaction_step_id => p_transaction_step_id
712: ,p_name => 'P_NTH_INFORMATION5');
713:
714: l_nth_information6 := hr_transaction_api.get_varchar2_value

Line 714: l_nth_information6 := hr_transaction_api.get_varchar2_value

710: l_nth_information5 := hr_transaction_api.get_varchar2_value
711: (p_transaction_step_id => p_transaction_step_id
712: ,p_name => 'P_NTH_INFORMATION5');
713:
714: l_nth_information6 := hr_transaction_api.get_varchar2_value
715: (p_transaction_step_id => p_transaction_step_id
716: ,p_name => 'P_NTH_INFORMATION6');
717:
718: l_nth_information7 := hr_transaction_api.get_varchar2_value

Line 718: l_nth_information7 := hr_transaction_api.get_varchar2_value

714: l_nth_information6 := hr_transaction_api.get_varchar2_value
715: (p_transaction_step_id => p_transaction_step_id
716: ,p_name => 'P_NTH_INFORMATION6');
717:
718: l_nth_information7 := hr_transaction_api.get_varchar2_value
719: (p_transaction_step_id => p_transaction_step_id
720: ,p_name => 'P_NTH_INFORMATION7');
721:
722: l_nth_information8 := hr_transaction_api.get_varchar2_value

Line 722: l_nth_information8 := hr_transaction_api.get_varchar2_value

718: l_nth_information7 := hr_transaction_api.get_varchar2_value
719: (p_transaction_step_id => p_transaction_step_id
720: ,p_name => 'P_NTH_INFORMATION7');
721:
722: l_nth_information8 := hr_transaction_api.get_varchar2_value
723: (p_transaction_step_id => p_transaction_step_id
724: ,p_name => 'P_NTH_INFORMATION8');
725:
726: l_nth_information9 := hr_transaction_api.get_varchar2_value

Line 726: l_nth_information9 := hr_transaction_api.get_varchar2_value

722: l_nth_information8 := hr_transaction_api.get_varchar2_value
723: (p_transaction_step_id => p_transaction_step_id
724: ,p_name => 'P_NTH_INFORMATION8');
725:
726: l_nth_information9 := hr_transaction_api.get_varchar2_value
727: (p_transaction_step_id => p_transaction_step_id
728: ,p_name => 'P_NTH_INFORMATION9');
729:
730: l_nth_information10 := hr_transaction_api.get_varchar2_value

Line 730: l_nth_information10 := hr_transaction_api.get_varchar2_value

726: l_nth_information9 := hr_transaction_api.get_varchar2_value
727: (p_transaction_step_id => p_transaction_step_id
728: ,p_name => 'P_NTH_INFORMATION9');
729:
730: l_nth_information10 := hr_transaction_api.get_varchar2_value
731: (p_transaction_step_id => p_transaction_step_id
732: ,p_name => 'P_NTH_INFORMATION10');
733:
734: l_nth_information11 := hr_transaction_api.get_varchar2_value

Line 734: l_nth_information11 := hr_transaction_api.get_varchar2_value

730: l_nth_information10 := hr_transaction_api.get_varchar2_value
731: (p_transaction_step_id => p_transaction_step_id
732: ,p_name => 'P_NTH_INFORMATION10');
733:
734: l_nth_information11 := hr_transaction_api.get_varchar2_value
735: (p_transaction_step_id => p_transaction_step_id
736: ,p_name => 'P_NTH_INFORMATION11');
737:
738: l_nth_information12 := hr_transaction_api.get_varchar2_value

Line 738: l_nth_information12 := hr_transaction_api.get_varchar2_value

734: l_nth_information11 := hr_transaction_api.get_varchar2_value
735: (p_transaction_step_id => p_transaction_step_id
736: ,p_name => 'P_NTH_INFORMATION11');
737:
738: l_nth_information12 := hr_transaction_api.get_varchar2_value
739: (p_transaction_step_id => p_transaction_step_id
740: ,p_name => 'P_NTH_INFORMATION12');
741:
742: l_nth_information13 := hr_transaction_api.get_varchar2_value

Line 742: l_nth_information13 := hr_transaction_api.get_varchar2_value

738: l_nth_information12 := hr_transaction_api.get_varchar2_value
739: (p_transaction_step_id => p_transaction_step_id
740: ,p_name => 'P_NTH_INFORMATION12');
741:
742: l_nth_information13 := hr_transaction_api.get_varchar2_value
743: (p_transaction_step_id => p_transaction_step_id
744: ,p_name => 'P_NTH_INFORMATION13');
745:
746: l_nth_information14 := hr_transaction_api.get_varchar2_value

Line 746: l_nth_information14 := hr_transaction_api.get_varchar2_value

742: l_nth_information13 := hr_transaction_api.get_varchar2_value
743: (p_transaction_step_id => p_transaction_step_id
744: ,p_name => 'P_NTH_INFORMATION13');
745:
746: l_nth_information14 := hr_transaction_api.get_varchar2_value
747: (p_transaction_step_id => p_transaction_step_id
748: ,p_name => 'P_NTH_INFORMATION14');
749:
750: l_nth_information15 := hr_transaction_api.get_varchar2_value

Line 750: l_nth_information15 := hr_transaction_api.get_varchar2_value

746: l_nth_information14 := hr_transaction_api.get_varchar2_value
747: (p_transaction_step_id => p_transaction_step_id
748: ,p_name => 'P_NTH_INFORMATION14');
749:
750: l_nth_information15 := hr_transaction_api.get_varchar2_value
751: (p_transaction_step_id => p_transaction_step_id
752: ,p_name => 'P_NTH_INFORMATION15');
753:
754: l_nth_information16 := hr_transaction_api.get_varchar2_value

Line 754: l_nth_information16 := hr_transaction_api.get_varchar2_value

750: l_nth_information15 := hr_transaction_api.get_varchar2_value
751: (p_transaction_step_id => p_transaction_step_id
752: ,p_name => 'P_NTH_INFORMATION15');
753:
754: l_nth_information16 := hr_transaction_api.get_varchar2_value
755: (p_transaction_step_id => p_transaction_step_id
756: ,p_name => 'P_NTH_INFORMATION16');
757:
758: l_nth_information17 := hr_transaction_api.get_varchar2_value

Line 758: l_nth_information17 := hr_transaction_api.get_varchar2_value

754: l_nth_information16 := hr_transaction_api.get_varchar2_value
755: (p_transaction_step_id => p_transaction_step_id
756: ,p_name => 'P_NTH_INFORMATION16');
757:
758: l_nth_information17 := hr_transaction_api.get_varchar2_value
759: (p_transaction_step_id => p_transaction_step_id
760: ,p_name => 'P_NTH_INFORMATION17');
761:
762: l_nth_information18 := hr_transaction_api.get_varchar2_value

Line 762: l_nth_information18 := hr_transaction_api.get_varchar2_value

758: l_nth_information17 := hr_transaction_api.get_varchar2_value
759: (p_transaction_step_id => p_transaction_step_id
760: ,p_name => 'P_NTH_INFORMATION17');
761:
762: l_nth_information18 := hr_transaction_api.get_varchar2_value
763: (p_transaction_step_id => p_transaction_step_id
764: ,p_name => 'P_NTH_INFORMATION18');
765:
766: l_nth_information19 := hr_transaction_api.get_varchar2_value

Line 766: l_nth_information19 := hr_transaction_api.get_varchar2_value

762: l_nth_information18 := hr_transaction_api.get_varchar2_value
763: (p_transaction_step_id => p_transaction_step_id
764: ,p_name => 'P_NTH_INFORMATION18');
765:
766: l_nth_information19 := hr_transaction_api.get_varchar2_value
767: (p_transaction_step_id => p_transaction_step_id
768: ,p_name => 'P_NTH_INFORMATION19');
769:
770: l_nth_information20 := hr_transaction_api.get_varchar2_value

Line 770: l_nth_information20 := hr_transaction_api.get_varchar2_value

766: l_nth_information19 := hr_transaction_api.get_varchar2_value
767: (p_transaction_step_id => p_transaction_step_id
768: ,p_name => 'P_NTH_INFORMATION19');
769:
770: l_nth_information20 := hr_transaction_api.get_varchar2_value
771: (p_transaction_step_id => p_transaction_step_id
772: ,p_name => 'P_NTH_INFORMATION20');
773:
774: l_contact_name := hr_transaction_api.get_varchar2_value

Line 774: l_contact_name := hr_transaction_api.get_varchar2_value

770: l_nth_information20 := hr_transaction_api.get_varchar2_value
771: (p_transaction_step_id => p_transaction_step_id
772: ,p_name => 'P_NTH_INFORMATION20');
773:
774: l_contact_name := hr_transaction_api.get_varchar2_value
775: (p_transaction_step_id => p_transaction_step_id
776: ,p_name => 'P_CONTACT_NAME');
777:
778: l_activity_name := hr_transaction_api.get_varchar2_value

Line 778: l_activity_name := hr_transaction_api.get_varchar2_value

774: l_contact_name := hr_transaction_api.get_varchar2_value
775: (p_transaction_step_id => p_transaction_step_id
776: ,p_name => 'P_CONTACT_NAME');
777:
778: l_activity_name := hr_transaction_api.get_varchar2_value
779: (p_transaction_step_id => p_transaction_step_id
780: ,p_name => 'P_ACTIVITY_NAME');
781:
782: l_obj_ver_no := hr_transaction_api.get_varchar2_value

Line 782: l_obj_ver_no := hr_transaction_api.get_varchar2_value

778: l_activity_name := hr_transaction_api.get_varchar2_value
779: (p_transaction_step_id => p_transaction_step_id
780: ,p_name => 'P_ACTIVITY_NAME');
781:
782: l_obj_ver_no := hr_transaction_api.get_varchar2_value
783: (p_transaction_step_id => p_transaction_step_id
784: ,p_name => 'P_OBJ_VER_NO');
785:
786: l_business_grp_id := hr_transaction_api.get_varchar2_value

Line 786: l_business_grp_id := hr_transaction_api.get_varchar2_value

782: l_obj_ver_no := hr_transaction_api.get_varchar2_value
783: (p_transaction_step_id => p_transaction_step_id
784: ,p_name => 'P_OBJ_VER_NO');
785:
786: l_business_grp_id := hr_transaction_api.get_varchar2_value
787: (p_transaction_step_id => p_transaction_step_id
788: ,p_name => 'P_BUSINESS_GRP_ID');
789:
790: l_person_id := hr_transaction_api.get_number_value

Line 790: l_person_id := hr_transaction_api.get_number_value

786: l_business_grp_id := hr_transaction_api.get_varchar2_value
787: (p_transaction_step_id => p_transaction_step_id
788: ,p_name => 'P_BUSINESS_GRP_ID');
789:
790: l_person_id := hr_transaction_api.get_number_value
791: (p_transaction_step_id => p_transaction_step_id
792: ,p_name => 'P_DELEGATE_PERSON_ID');
793:
794: l_from := hr_transaction_api.get_varchar2_value

Line 794: l_from := hr_transaction_api.get_varchar2_value

790: l_person_id := hr_transaction_api.get_number_value
791: (p_transaction_step_id => p_transaction_step_id
792: ,p_name => 'P_DELEGATE_PERSON_ID');
793:
794: l_from := hr_transaction_api.get_varchar2_value
795: (p_transaction_step_id => p_transaction_step_id
796: ,p_name => 'P_FROM');
797:
798: l_transaction_mode := hr_transaction_api.get_varchar2_value

Line 798: l_transaction_mode := hr_transaction_api.get_varchar2_value

794: l_from := hr_transaction_api.get_varchar2_value
795: (p_transaction_step_id => p_transaction_step_id
796: ,p_name => 'P_FROM');
797:
798: l_transaction_mode := hr_transaction_api.get_varchar2_value
799: (p_transaction_step_id => p_transaction_step_id
800: ,p_name => 'P_TRANSACTION_MODE');
801:
802: l_oafunc := hr_transaction_api.get_varchar2_value

Line 802: l_oafunc := hr_transaction_api.get_varchar2_value

798: l_transaction_mode := hr_transaction_api.get_varchar2_value
799: (p_transaction_step_id => p_transaction_step_id
800: ,p_name => 'P_TRANSACTION_MODE');
801:
802: l_oafunc := hr_transaction_api.get_varchar2_value
803: (p_transaction_step_id => p_transaction_step_id
804: ,p_name => 'P_OAFUNC');
805:
806: l_processname := hr_transaction_api.get_varchar2_value

Line 806: l_processname := hr_transaction_api.get_varchar2_value

802: l_oafunc := hr_transaction_api.get_varchar2_value
803: (p_transaction_step_id => p_transaction_step_id
804: ,p_name => 'P_OAFUNC');
805:
806: l_processname := hr_transaction_api.get_varchar2_value
807: (p_transaction_step_id => p_transaction_step_id
808: ,p_name => 'P_PROCESSNAME');
809:
810: l_calledfrom := hr_transaction_api.get_varchar2_value

Line 810: l_calledfrom := hr_transaction_api.get_varchar2_value

806: l_processname := hr_transaction_api.get_varchar2_value
807: (p_transaction_step_id => p_transaction_step_id
808: ,p_name => 'P_PROCESSNAME');
809:
810: l_calledfrom := hr_transaction_api.get_varchar2_value
811: (p_transaction_step_id => p_transaction_step_id
812: ,p_name => 'P_CALLEDFROM');
813:
814: l_frommenu := hr_transaction_api.get_varchar2_value

Line 814: l_frommenu := hr_transaction_api.get_varchar2_value

810: l_calledfrom := hr_transaction_api.get_varchar2_value
811: (p_transaction_step_id => p_transaction_step_id
812: ,p_name => 'P_CALLEDFROM');
813:
814: l_frommenu := hr_transaction_api.get_varchar2_value
815: (p_transaction_step_id => p_transaction_step_id
816: ,p_name => 'P_FROMMENU');
817:
818: l_status_Meaning := hr_transaction_api.get_varchar2_value

Line 818: l_status_Meaning := hr_transaction_api.get_varchar2_value

814: l_frommenu := hr_transaction_api.get_varchar2_value
815: (p_transaction_step_id => p_transaction_step_id
816: ,p_name => 'P_FROMMENU');
817:
818: l_status_Meaning := hr_transaction_api.get_varchar2_value
819: (p_transaction_step_id => p_transaction_step_id
820: ,p_name => 'P_STATUS_MEANING');
821:
822: l_Type_Meaning := hr_transaction_api.get_varchar2_value

Line 822: l_Type_Meaning := hr_transaction_api.get_varchar2_value

818: l_status_Meaning := hr_transaction_api.get_varchar2_value
819: (p_transaction_step_id => p_transaction_step_id
820: ,p_name => 'P_STATUS_MEANING');
821:
822: l_Type_Meaning := hr_transaction_api.get_varchar2_value
823: (p_transaction_step_id => p_transaction_step_id
824: ,p_name => 'P_TYPE_MEANING');
825:
826: l_str_completion_date := to_char(l_completion_date, fnd_profile.value('ICX_DATE_FORMAT_MASK'));

Line 933: hr_transaction_api.get_varchar2_value

929: FOR c in cur_get_pending_trn_step_id --Bug 3590613
930: LOOP
931:
932: l_temp_historyid :=
933: hr_transaction_api.get_varchar2_value
934: (p_transaction_step_id => c.transaction_step_id
935: ,p_name => 'P_HISTORYID');
936:
937: IF l_temp_historyid is not null then

Line 976: l_transaction_mode := hr_transaction_api.get_varchar2_value

972:
973:
974:
975: BEGIN
976: l_transaction_mode := hr_transaction_api.get_varchar2_value
977: (p_transaction_step_id => p_transaction_step_id
978: ,p_name => 'P_TRANSACTION_MODE');
979: l_from := hr_transaction_api.get_varchar2_value
980: (p_transaction_step_id => p_transaction_step_id

Line 979: l_from := hr_transaction_api.get_varchar2_value

975: BEGIN
976: l_transaction_mode := hr_transaction_api.get_varchar2_value
977: (p_transaction_step_id => p_transaction_step_id
978: ,p_name => 'P_TRANSACTION_MODE');
979: l_from := hr_transaction_api.get_varchar2_value
980: (p_transaction_step_id => p_transaction_step_id
981: ,p_name => 'P_FROM');
982:
983: hr_transaction_api.get_transaction_step_info

Line 983: hr_transaction_api.get_transaction_step_info

979: l_from := hr_transaction_api.get_varchar2_value
980: (p_transaction_step_id => p_transaction_step_id
981: ,p_name => 'P_FROM');
982:
983: hr_transaction_api.get_transaction_step_info
984: (p_transaction_step_id => p_transaction_step_id
985: ,p_item_type => l_item_type
986: ,p_item_key => l_item_key
987: ,p_activity_id => l_activity_id);

Line 1084: hr_transaction_api.get_transaction_step_info

1080: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1081: BEGIN
1082:
1083:
1084: hr_transaction_api.get_transaction_step_info
1085: (p_transaction_step_id => p_transaction_step_id
1086: ,p_item_type => l_item_type
1087: ,p_item_key => l_item_key
1088: ,p_activity_id => l_activity_id);

Line 1091: l_historyid := hr_transaction_api.get_varchar2_value

1087: ,p_item_key => l_item_key
1088: ,p_activity_id => l_activity_id);
1089:
1090: SAVEPOINT create_tt;
1091: l_historyid := hr_transaction_api.get_varchar2_value
1092: (p_transaction_step_id => p_transaction_step_id
1093: ,p_name => 'P_HISTORYID');
1094: l_title := hr_transaction_api.get_varchar2_value
1095: (p_transaction_step_id => p_transaction_step_id

Line 1094: l_title := hr_transaction_api.get_varchar2_value

1090: SAVEPOINT create_tt;
1091: l_historyid := hr_transaction_api.get_varchar2_value
1092: (p_transaction_step_id => p_transaction_step_id
1093: ,p_name => 'P_HISTORYID');
1094: l_title := hr_transaction_api.get_varchar2_value
1095: (p_transaction_step_id => p_transaction_step_id
1096: ,p_name => 'P_TITLE');
1097: l_supplier := hr_transaction_api.get_varchar2_value
1098: (p_transaction_step_id => p_transaction_step_id

Line 1097: l_supplier := hr_transaction_api.get_varchar2_value

1093: ,p_name => 'P_HISTORYID');
1094: l_title := hr_transaction_api.get_varchar2_value
1095: (p_transaction_step_id => p_transaction_step_id
1096: ,p_name => 'P_TITLE');
1097: l_supplier := hr_transaction_api.get_varchar2_value
1098: (p_transaction_step_id => p_transaction_step_id
1099: ,p_name => 'P_SUPPLIER');
1100: l_eq_ota_activity := hr_transaction_api.get_varchar2_value
1101: (p_transaction_step_id => p_transaction_step_id

Line 1100: l_eq_ota_activity := hr_transaction_api.get_varchar2_value

1096: ,p_name => 'P_TITLE');
1097: l_supplier := hr_transaction_api.get_varchar2_value
1098: (p_transaction_step_id => p_transaction_step_id
1099: ,p_name => 'P_SUPPLIER');
1100: l_eq_ota_activity := hr_transaction_api.get_varchar2_value
1101: (p_transaction_step_id => p_transaction_step_id
1102: ,p_name => 'P_EQ_OTA_ACTIVITY');
1103: l_location := hr_transaction_api.get_varchar2_value
1104: (p_transaction_step_id => p_transaction_step_id

Line 1103: l_location := hr_transaction_api.get_varchar2_value

1099: ,p_name => 'P_SUPPLIER');
1100: l_eq_ota_activity := hr_transaction_api.get_varchar2_value
1101: (p_transaction_step_id => p_transaction_step_id
1102: ,p_name => 'P_EQ_OTA_ACTIVITY');
1103: l_location := hr_transaction_api.get_varchar2_value
1104: (p_transaction_step_id => p_transaction_step_id
1105: ,p_name => 'P_LOCATION');
1106: l_trntype := hr_transaction_api.get_varchar2_value
1107: (p_transaction_step_id => p_transaction_step_id

Line 1106: l_trntype := hr_transaction_api.get_varchar2_value

1102: ,p_name => 'P_EQ_OTA_ACTIVITY');
1103: l_location := hr_transaction_api.get_varchar2_value
1104: (p_transaction_step_id => p_transaction_step_id
1105: ,p_name => 'P_LOCATION');
1106: l_trntype := hr_transaction_api.get_varchar2_value
1107: (p_transaction_step_id => p_transaction_step_id
1108: ,p_name => 'P_TRNTYPE');
1109: l_duration := hr_transaction_api.get_varchar2_value
1110: (p_transaction_step_id => p_transaction_step_id

Line 1109: l_duration := hr_transaction_api.get_varchar2_value

1105: ,p_name => 'P_LOCATION');
1106: l_trntype := hr_transaction_api.get_varchar2_value
1107: (p_transaction_step_id => p_transaction_step_id
1108: ,p_name => 'P_TRNTYPE');
1109: l_duration := hr_transaction_api.get_varchar2_value
1110: (p_transaction_step_id => p_transaction_step_id
1111: ,p_name => 'P_DURATION');
1112: l_duration_unit := hr_transaction_api.get_varchar2_value
1113: (p_transaction_step_id => p_transaction_step_id

Line 1112: l_duration_unit := hr_transaction_api.get_varchar2_value

1108: ,p_name => 'P_TRNTYPE');
1109: l_duration := hr_transaction_api.get_varchar2_value
1110: (p_transaction_step_id => p_transaction_step_id
1111: ,p_name => 'P_DURATION');
1112: l_duration_unit := hr_transaction_api.get_varchar2_value
1113: (p_transaction_step_id => p_transaction_step_id
1114: ,p_name => 'P_DURATION_UNIT');
1115: l_status := hr_transaction_api.get_varchar2_value
1116: (p_transaction_step_id => p_transaction_step_id

Line 1115: l_status := hr_transaction_api.get_varchar2_value

1111: ,p_name => 'P_DURATION');
1112: l_duration_unit := hr_transaction_api.get_varchar2_value
1113: (p_transaction_step_id => p_transaction_step_id
1114: ,p_name => 'P_DURATION_UNIT');
1115: l_status := hr_transaction_api.get_varchar2_value
1116: (p_transaction_step_id => p_transaction_step_id
1117: ,p_name => 'P_STATUS');
1118: l_completion_date := hr_transaction_api.get_date_value
1119: (p_transaction_step_id => p_transaction_step_id

Line 1118: l_completion_date := hr_transaction_api.get_date_value

1114: ,p_name => 'P_DURATION_UNIT');
1115: l_status := hr_transaction_api.get_varchar2_value
1116: (p_transaction_step_id => p_transaction_step_id
1117: ,p_name => 'P_STATUS');
1118: l_completion_date := hr_transaction_api.get_date_value
1119: (p_transaction_step_id => p_transaction_step_id
1120: ,p_name => 'P_COMPLETION_DATE');
1121: l_award := hr_transaction_api.get_varchar2_value
1122: (p_transaction_step_id => p_transaction_step_id

Line 1121: l_award := hr_transaction_api.get_varchar2_value

1117: ,p_name => 'P_STATUS');
1118: l_completion_date := hr_transaction_api.get_date_value
1119: (p_transaction_step_id => p_transaction_step_id
1120: ,p_name => 'P_COMPLETION_DATE');
1121: l_award := hr_transaction_api.get_varchar2_value
1122: (p_transaction_step_id => p_transaction_step_id
1123: ,p_name => 'P_AWARD');
1124: l_score := hr_transaction_api.get_varchar2_value
1125: (p_transaction_step_id => p_transaction_step_id

Line 1124: l_score := hr_transaction_api.get_varchar2_value

1120: ,p_name => 'P_COMPLETION_DATE');
1121: l_award := hr_transaction_api.get_varchar2_value
1122: (p_transaction_step_id => p_transaction_step_id
1123: ,p_name => 'P_AWARD');
1124: l_score := hr_transaction_api.get_varchar2_value
1125: (p_transaction_step_id => p_transaction_step_id
1126: ,p_name => 'P_SCORE');
1127: l_internal_contact_person := hr_transaction_api.get_varchar2_value
1128: (p_transaction_step_id => p_transaction_step_id

Line 1127: l_internal_contact_person := hr_transaction_api.get_varchar2_value

1123: ,p_name => 'P_AWARD');
1124: l_score := hr_transaction_api.get_varchar2_value
1125: (p_transaction_step_id => p_transaction_step_id
1126: ,p_name => 'P_SCORE');
1127: l_internal_contact_person := hr_transaction_api.get_varchar2_value
1128: (p_transaction_step_id => p_transaction_step_id
1129: ,p_name => 'P_INTERNAL_CONTACT_PERSON');
1130: l_nth_information_category := hr_transaction_api.get_varchar2_value
1131: (p_transaction_step_id => p_transaction_step_id

Line 1130: l_nth_information_category := hr_transaction_api.get_varchar2_value

1126: ,p_name => 'P_SCORE');
1127: l_internal_contact_person := hr_transaction_api.get_varchar2_value
1128: (p_transaction_step_id => p_transaction_step_id
1129: ,p_name => 'P_INTERNAL_CONTACT_PERSON');
1130: l_nth_information_category := hr_transaction_api.get_varchar2_value
1131: (p_transaction_step_id => p_transaction_step_id
1132: ,p_name => 'P_NTH_INFORMATION_CATEGORY');
1133: l_nth_information1 := hr_transaction_api.get_varchar2_value
1134: (p_transaction_step_id => p_transaction_step_id

Line 1133: l_nth_information1 := hr_transaction_api.get_varchar2_value

1129: ,p_name => 'P_INTERNAL_CONTACT_PERSON');
1130: l_nth_information_category := hr_transaction_api.get_varchar2_value
1131: (p_transaction_step_id => p_transaction_step_id
1132: ,p_name => 'P_NTH_INFORMATION_CATEGORY');
1133: l_nth_information1 := hr_transaction_api.get_varchar2_value
1134: (p_transaction_step_id => p_transaction_step_id
1135: ,p_name => 'P_NTH_INFORMATION1');
1136: l_nth_information2 := hr_transaction_api.get_varchar2_value
1137: (p_transaction_step_id => p_transaction_step_id

Line 1136: l_nth_information2 := hr_transaction_api.get_varchar2_value

1132: ,p_name => 'P_NTH_INFORMATION_CATEGORY');
1133: l_nth_information1 := hr_transaction_api.get_varchar2_value
1134: (p_transaction_step_id => p_transaction_step_id
1135: ,p_name => 'P_NTH_INFORMATION1');
1136: l_nth_information2 := hr_transaction_api.get_varchar2_value
1137: (p_transaction_step_id => p_transaction_step_id
1138: ,p_name => 'P_NTH_INFORMATION2');
1139: l_nth_information3 := hr_transaction_api.get_varchar2_value
1140: (p_transaction_step_id => p_transaction_step_id

Line 1139: l_nth_information3 := hr_transaction_api.get_varchar2_value

1135: ,p_name => 'P_NTH_INFORMATION1');
1136: l_nth_information2 := hr_transaction_api.get_varchar2_value
1137: (p_transaction_step_id => p_transaction_step_id
1138: ,p_name => 'P_NTH_INFORMATION2');
1139: l_nth_information3 := hr_transaction_api.get_varchar2_value
1140: (p_transaction_step_id => p_transaction_step_id
1141: ,p_name => 'P_NTH_INFORMATION3');
1142: l_nth_information4 := hr_transaction_api.get_varchar2_value
1143: (p_transaction_step_id => p_transaction_step_id

Line 1142: l_nth_information4 := hr_transaction_api.get_varchar2_value

1138: ,p_name => 'P_NTH_INFORMATION2');
1139: l_nth_information3 := hr_transaction_api.get_varchar2_value
1140: (p_transaction_step_id => p_transaction_step_id
1141: ,p_name => 'P_NTH_INFORMATION3');
1142: l_nth_information4 := hr_transaction_api.get_varchar2_value
1143: (p_transaction_step_id => p_transaction_step_id
1144: ,p_name => 'P_NTH_INFORMATION4');
1145: l_nth_information5 := hr_transaction_api.get_varchar2_value
1146: (p_transaction_step_id => p_transaction_step_id

Line 1145: l_nth_information5 := hr_transaction_api.get_varchar2_value

1141: ,p_name => 'P_NTH_INFORMATION3');
1142: l_nth_information4 := hr_transaction_api.get_varchar2_value
1143: (p_transaction_step_id => p_transaction_step_id
1144: ,p_name => 'P_NTH_INFORMATION4');
1145: l_nth_information5 := hr_transaction_api.get_varchar2_value
1146: (p_transaction_step_id => p_transaction_step_id
1147: ,p_name => 'P_NTH_INFORMATION5');
1148: l_nth_information6 := hr_transaction_api.get_varchar2_value
1149: (p_transaction_step_id => p_transaction_step_id

Line 1148: l_nth_information6 := hr_transaction_api.get_varchar2_value

1144: ,p_name => 'P_NTH_INFORMATION4');
1145: l_nth_information5 := hr_transaction_api.get_varchar2_value
1146: (p_transaction_step_id => p_transaction_step_id
1147: ,p_name => 'P_NTH_INFORMATION5');
1148: l_nth_information6 := hr_transaction_api.get_varchar2_value
1149: (p_transaction_step_id => p_transaction_step_id
1150: ,p_name => 'P_NTH_INFORMATION6');
1151: l_nth_information7 := hr_transaction_api.get_varchar2_value
1152: (p_transaction_step_id => p_transaction_step_id

Line 1151: l_nth_information7 := hr_transaction_api.get_varchar2_value

1147: ,p_name => 'P_NTH_INFORMATION5');
1148: l_nth_information6 := hr_transaction_api.get_varchar2_value
1149: (p_transaction_step_id => p_transaction_step_id
1150: ,p_name => 'P_NTH_INFORMATION6');
1151: l_nth_information7 := hr_transaction_api.get_varchar2_value
1152: (p_transaction_step_id => p_transaction_step_id
1153: ,p_name => 'P_NTH_INFORMATION7');
1154: l_nth_information8 := hr_transaction_api.get_varchar2_value
1155: (p_transaction_step_id => p_transaction_step_id

Line 1154: l_nth_information8 := hr_transaction_api.get_varchar2_value

1150: ,p_name => 'P_NTH_INFORMATION6');
1151: l_nth_information7 := hr_transaction_api.get_varchar2_value
1152: (p_transaction_step_id => p_transaction_step_id
1153: ,p_name => 'P_NTH_INFORMATION7');
1154: l_nth_information8 := hr_transaction_api.get_varchar2_value
1155: (p_transaction_step_id => p_transaction_step_id
1156: ,p_name => 'P_NTH_INFORMATION8');
1157: l_nth_information9 := hr_transaction_api.get_varchar2_value
1158: (p_transaction_step_id => p_transaction_step_id

Line 1157: l_nth_information9 := hr_transaction_api.get_varchar2_value

1153: ,p_name => 'P_NTH_INFORMATION7');
1154: l_nth_information8 := hr_transaction_api.get_varchar2_value
1155: (p_transaction_step_id => p_transaction_step_id
1156: ,p_name => 'P_NTH_INFORMATION8');
1157: l_nth_information9 := hr_transaction_api.get_varchar2_value
1158: (p_transaction_step_id => p_transaction_step_id
1159: ,p_name => 'P_NTH_INFORMATION9');
1160: l_nth_information10 := hr_transaction_api.get_varchar2_value
1161: (p_transaction_step_id => p_transaction_step_id

Line 1160: l_nth_information10 := hr_transaction_api.get_varchar2_value

1156: ,p_name => 'P_NTH_INFORMATION8');
1157: l_nth_information9 := hr_transaction_api.get_varchar2_value
1158: (p_transaction_step_id => p_transaction_step_id
1159: ,p_name => 'P_NTH_INFORMATION9');
1160: l_nth_information10 := hr_transaction_api.get_varchar2_value
1161: (p_transaction_step_id => p_transaction_step_id
1162: ,p_name => 'P_NTH_INFORMATION10');
1163: l_nth_information11 := hr_transaction_api.get_varchar2_value
1164: (p_transaction_step_id => p_transaction_step_id

Line 1163: l_nth_information11 := hr_transaction_api.get_varchar2_value

1159: ,p_name => 'P_NTH_INFORMATION9');
1160: l_nth_information10 := hr_transaction_api.get_varchar2_value
1161: (p_transaction_step_id => p_transaction_step_id
1162: ,p_name => 'P_NTH_INFORMATION10');
1163: l_nth_information11 := hr_transaction_api.get_varchar2_value
1164: (p_transaction_step_id => p_transaction_step_id
1165: ,p_name => 'P_NTH_INFORMATION11');
1166: l_nth_information12 := hr_transaction_api.get_varchar2_value
1167: (p_transaction_step_id => p_transaction_step_id

Line 1166: l_nth_information12 := hr_transaction_api.get_varchar2_value

1162: ,p_name => 'P_NTH_INFORMATION10');
1163: l_nth_information11 := hr_transaction_api.get_varchar2_value
1164: (p_transaction_step_id => p_transaction_step_id
1165: ,p_name => 'P_NTH_INFORMATION11');
1166: l_nth_information12 := hr_transaction_api.get_varchar2_value
1167: (p_transaction_step_id => p_transaction_step_id
1168: ,p_name => 'P_NTH_INFORMATION12');
1169: l_nth_information13 := hr_transaction_api.get_varchar2_value
1170: (p_transaction_step_id => p_transaction_step_id

Line 1169: l_nth_information13 := hr_transaction_api.get_varchar2_value

1165: ,p_name => 'P_NTH_INFORMATION11');
1166: l_nth_information12 := hr_transaction_api.get_varchar2_value
1167: (p_transaction_step_id => p_transaction_step_id
1168: ,p_name => 'P_NTH_INFORMATION12');
1169: l_nth_information13 := hr_transaction_api.get_varchar2_value
1170: (p_transaction_step_id => p_transaction_step_id
1171: ,p_name => 'P_NTH_INFORMATION13');
1172: l_nth_information14 := hr_transaction_api.get_varchar2_value
1173: (p_transaction_step_id => p_transaction_step_id

Line 1172: l_nth_information14 := hr_transaction_api.get_varchar2_value

1168: ,p_name => 'P_NTH_INFORMATION12');
1169: l_nth_information13 := hr_transaction_api.get_varchar2_value
1170: (p_transaction_step_id => p_transaction_step_id
1171: ,p_name => 'P_NTH_INFORMATION13');
1172: l_nth_information14 := hr_transaction_api.get_varchar2_value
1173: (p_transaction_step_id => p_transaction_step_id
1174: ,p_name => 'P_NTH_INFORMATION14');
1175: l_nth_information15 := hr_transaction_api.get_varchar2_value
1176: (p_transaction_step_id => p_transaction_step_id

Line 1175: l_nth_information15 := hr_transaction_api.get_varchar2_value

1171: ,p_name => 'P_NTH_INFORMATION13');
1172: l_nth_information14 := hr_transaction_api.get_varchar2_value
1173: (p_transaction_step_id => p_transaction_step_id
1174: ,p_name => 'P_NTH_INFORMATION14');
1175: l_nth_information15 := hr_transaction_api.get_varchar2_value
1176: (p_transaction_step_id => p_transaction_step_id
1177: ,p_name => 'P_NTH_INFORMATION15');
1178: l_nth_information16 := hr_transaction_api.get_varchar2_value
1179: (p_transaction_step_id => p_transaction_step_id

Line 1178: l_nth_information16 := hr_transaction_api.get_varchar2_value

1174: ,p_name => 'P_NTH_INFORMATION14');
1175: l_nth_information15 := hr_transaction_api.get_varchar2_value
1176: (p_transaction_step_id => p_transaction_step_id
1177: ,p_name => 'P_NTH_INFORMATION15');
1178: l_nth_information16 := hr_transaction_api.get_varchar2_value
1179: (p_transaction_step_id => p_transaction_step_id
1180: ,p_name => 'P_NTH_INFORMATION16');
1181: l_nth_information17 := hr_transaction_api.get_varchar2_value
1182: (p_transaction_step_id => p_transaction_step_id

Line 1181: l_nth_information17 := hr_transaction_api.get_varchar2_value

1177: ,p_name => 'P_NTH_INFORMATION15');
1178: l_nth_information16 := hr_transaction_api.get_varchar2_value
1179: (p_transaction_step_id => p_transaction_step_id
1180: ,p_name => 'P_NTH_INFORMATION16');
1181: l_nth_information17 := hr_transaction_api.get_varchar2_value
1182: (p_transaction_step_id => p_transaction_step_id
1183: ,p_name => 'P_NTH_INFORMATION17');
1184: l_nth_information18 := hr_transaction_api.get_varchar2_value
1185: (p_transaction_step_id => p_transaction_step_id

Line 1184: l_nth_information18 := hr_transaction_api.get_varchar2_value

1180: ,p_name => 'P_NTH_INFORMATION16');
1181: l_nth_information17 := hr_transaction_api.get_varchar2_value
1182: (p_transaction_step_id => p_transaction_step_id
1183: ,p_name => 'P_NTH_INFORMATION17');
1184: l_nth_information18 := hr_transaction_api.get_varchar2_value
1185: (p_transaction_step_id => p_transaction_step_id
1186: ,p_name => 'P_NTH_INFORMATION18');
1187: l_nth_information19 := hr_transaction_api.get_varchar2_value
1188: (p_transaction_step_id => p_transaction_step_id

Line 1187: l_nth_information19 := hr_transaction_api.get_varchar2_value

1183: ,p_name => 'P_NTH_INFORMATION17');
1184: l_nth_information18 := hr_transaction_api.get_varchar2_value
1185: (p_transaction_step_id => p_transaction_step_id
1186: ,p_name => 'P_NTH_INFORMATION18');
1187: l_nth_information19 := hr_transaction_api.get_varchar2_value
1188: (p_transaction_step_id => p_transaction_step_id
1189: ,p_name => 'P_NTH_INFORMATION19');
1190: l_nth_information20 := hr_transaction_api.get_varchar2_value
1191: (p_transaction_step_id => p_transaction_step_id

Line 1190: l_nth_information20 := hr_transaction_api.get_varchar2_value

1186: ,p_name => 'P_NTH_INFORMATION18');
1187: l_nth_information19 := hr_transaction_api.get_varchar2_value
1188: (p_transaction_step_id => p_transaction_step_id
1189: ,p_name => 'P_NTH_INFORMATION19');
1190: l_nth_information20 := hr_transaction_api.get_varchar2_value
1191: (p_transaction_step_id => p_transaction_step_id
1192: ,p_name => 'P_NTH_INFORMATION20');
1193: l_contact_name := hr_transaction_api.get_varchar2_value
1194: (p_transaction_step_id => p_transaction_step_id

Line 1193: l_contact_name := hr_transaction_api.get_varchar2_value

1189: ,p_name => 'P_NTH_INFORMATION19');
1190: l_nth_information20 := hr_transaction_api.get_varchar2_value
1191: (p_transaction_step_id => p_transaction_step_id
1192: ,p_name => 'P_NTH_INFORMATION20');
1193: l_contact_name := hr_transaction_api.get_varchar2_value
1194: (p_transaction_step_id => p_transaction_step_id
1195: ,p_name => 'P_CONTACT_NAME');
1196: l_activity_name := hr_transaction_api.get_varchar2_value
1197: (p_transaction_step_id => p_transaction_step_id

Line 1196: l_activity_name := hr_transaction_api.get_varchar2_value

1192: ,p_name => 'P_NTH_INFORMATION20');
1193: l_contact_name := hr_transaction_api.get_varchar2_value
1194: (p_transaction_step_id => p_transaction_step_id
1195: ,p_name => 'P_CONTACT_NAME');
1196: l_activity_name := hr_transaction_api.get_varchar2_value
1197: (p_transaction_step_id => p_transaction_step_id
1198: ,p_name => 'P_ACTIVITY_NAME');
1199: l_obj_ver_no := hr_transaction_api.get_varchar2_value
1200: (p_transaction_step_id => p_transaction_step_id

Line 1199: l_obj_ver_no := hr_transaction_api.get_varchar2_value

1195: ,p_name => 'P_CONTACT_NAME');
1196: l_activity_name := hr_transaction_api.get_varchar2_value
1197: (p_transaction_step_id => p_transaction_step_id
1198: ,p_name => 'P_ACTIVITY_NAME');
1199: l_obj_ver_no := hr_transaction_api.get_varchar2_value
1200: (p_transaction_step_id => p_transaction_step_id
1201: ,p_name => 'P_OBJ_VER_NO');
1202: l_business_grp_id := hr_transaction_api.get_varchar2_value
1203: (p_transaction_step_id => p_transaction_step_id

Line 1202: l_business_grp_id := hr_transaction_api.get_varchar2_value

1198: ,p_name => 'P_ACTIVITY_NAME');
1199: l_obj_ver_no := hr_transaction_api.get_varchar2_value
1200: (p_transaction_step_id => p_transaction_step_id
1201: ,p_name => 'P_OBJ_VER_NO');
1202: l_business_grp_id := hr_transaction_api.get_varchar2_value
1203: (p_transaction_step_id => p_transaction_step_id
1204: ,p_name => 'P_BUSINESS_GRP_ID');
1205: l_person_id := hr_transaction_api.get_number_value
1206: (p_transaction_step_id => p_transaction_step_id

Line 1205: l_person_id := hr_transaction_api.get_number_value

1201: ,p_name => 'P_OBJ_VER_NO');
1202: l_business_grp_id := hr_transaction_api.get_varchar2_value
1203: (p_transaction_step_id => p_transaction_step_id
1204: ,p_name => 'P_BUSINESS_GRP_ID');
1205: l_person_id := hr_transaction_api.get_number_value
1206: (p_transaction_step_id => p_transaction_step_id
1207: ,p_name => 'P_DELEGATE_PERSON_ID');
1208:
1209: l_org_id := hr_transaction_api.get_varchar2_value

Line 1209: l_org_id := hr_transaction_api.get_varchar2_value

1205: l_person_id := hr_transaction_api.get_number_value
1206: (p_transaction_step_id => p_transaction_step_id
1207: ,p_name => 'P_DELEGATE_PERSON_ID');
1208:
1209: l_org_id := hr_transaction_api.get_varchar2_value
1210: (p_transaction_step_id => p_transaction_step_id
1211: ,p_name => 'P_ORG_ID');
1212:
1213: create_add_training

Line 1332: hr_transaction_api.get_transaction_step_info

1328:
1329: BEGIN
1330:
1331:
1332: hr_transaction_api.get_transaction_step_info
1333: (p_transaction_step_id => p_transaction_step_id
1334: ,p_item_type => l_item_type
1335: ,p_item_key => l_item_key
1336: ,p_activity_id => l_activity_id);

Line 1339: l_historyid := hr_transaction_api.get_varchar2_value

1335: ,p_item_key => l_item_key
1336: ,p_activity_id => l_activity_id);
1337:
1338: SAVEPOINT update_tt;
1339: l_historyid := hr_transaction_api.get_varchar2_value
1340: (p_transaction_step_id => p_transaction_step_id
1341: ,p_name => 'P_HISTORYID');
1342: l_title := hr_transaction_api.get_varchar2_value
1343: (p_transaction_step_id => p_transaction_step_id

Line 1342: l_title := hr_transaction_api.get_varchar2_value

1338: SAVEPOINT update_tt;
1339: l_historyid := hr_transaction_api.get_varchar2_value
1340: (p_transaction_step_id => p_transaction_step_id
1341: ,p_name => 'P_HISTORYID');
1342: l_title := hr_transaction_api.get_varchar2_value
1343: (p_transaction_step_id => p_transaction_step_id
1344: ,p_name => 'P_TITLE');
1345: l_supplier := hr_transaction_api.get_varchar2_value
1346: (p_transaction_step_id => p_transaction_step_id

Line 1345: l_supplier := hr_transaction_api.get_varchar2_value

1341: ,p_name => 'P_HISTORYID');
1342: l_title := hr_transaction_api.get_varchar2_value
1343: (p_transaction_step_id => p_transaction_step_id
1344: ,p_name => 'P_TITLE');
1345: l_supplier := hr_transaction_api.get_varchar2_value
1346: (p_transaction_step_id => p_transaction_step_id
1347: ,p_name => 'P_SUPPLIER');
1348: l_eq_ota_activity := hr_transaction_api.get_varchar2_value
1349: (p_transaction_step_id => p_transaction_step_id

Line 1348: l_eq_ota_activity := hr_transaction_api.get_varchar2_value

1344: ,p_name => 'P_TITLE');
1345: l_supplier := hr_transaction_api.get_varchar2_value
1346: (p_transaction_step_id => p_transaction_step_id
1347: ,p_name => 'P_SUPPLIER');
1348: l_eq_ota_activity := hr_transaction_api.get_varchar2_value
1349: (p_transaction_step_id => p_transaction_step_id
1350: ,p_name => 'P_EQ_OTA_ACTIVITY');
1351: l_location := hr_transaction_api.get_varchar2_value
1352: (p_transaction_step_id => p_transaction_step_id

Line 1351: l_location := hr_transaction_api.get_varchar2_value

1347: ,p_name => 'P_SUPPLIER');
1348: l_eq_ota_activity := hr_transaction_api.get_varchar2_value
1349: (p_transaction_step_id => p_transaction_step_id
1350: ,p_name => 'P_EQ_OTA_ACTIVITY');
1351: l_location := hr_transaction_api.get_varchar2_value
1352: (p_transaction_step_id => p_transaction_step_id
1353: ,p_name => 'P_LOCATION');
1354: l_trntype := hr_transaction_api.get_varchar2_value
1355: (p_transaction_step_id => p_transaction_step_id

Line 1354: l_trntype := hr_transaction_api.get_varchar2_value

1350: ,p_name => 'P_EQ_OTA_ACTIVITY');
1351: l_location := hr_transaction_api.get_varchar2_value
1352: (p_transaction_step_id => p_transaction_step_id
1353: ,p_name => 'P_LOCATION');
1354: l_trntype := hr_transaction_api.get_varchar2_value
1355: (p_transaction_step_id => p_transaction_step_id
1356: ,p_name => 'P_TRNTYPE');
1357: l_duration := hr_transaction_api.get_varchar2_value
1358: (p_transaction_step_id => p_transaction_step_id

Line 1357: l_duration := hr_transaction_api.get_varchar2_value

1353: ,p_name => 'P_LOCATION');
1354: l_trntype := hr_transaction_api.get_varchar2_value
1355: (p_transaction_step_id => p_transaction_step_id
1356: ,p_name => 'P_TRNTYPE');
1357: l_duration := hr_transaction_api.get_varchar2_value
1358: (p_transaction_step_id => p_transaction_step_id
1359: ,p_name => 'P_DURATION');
1360: l_duration_unit := hr_transaction_api.get_varchar2_value
1361: (p_transaction_step_id => p_transaction_step_id

Line 1360: l_duration_unit := hr_transaction_api.get_varchar2_value

1356: ,p_name => 'P_TRNTYPE');
1357: l_duration := hr_transaction_api.get_varchar2_value
1358: (p_transaction_step_id => p_transaction_step_id
1359: ,p_name => 'P_DURATION');
1360: l_duration_unit := hr_transaction_api.get_varchar2_value
1361: (p_transaction_step_id => p_transaction_step_id
1362: ,p_name => 'P_DURATION_UNIT');
1363: l_status := hr_transaction_api.get_varchar2_value
1364: (p_transaction_step_id => p_transaction_step_id

Line 1363: l_status := hr_transaction_api.get_varchar2_value

1359: ,p_name => 'P_DURATION');
1360: l_duration_unit := hr_transaction_api.get_varchar2_value
1361: (p_transaction_step_id => p_transaction_step_id
1362: ,p_name => 'P_DURATION_UNIT');
1363: l_status := hr_transaction_api.get_varchar2_value
1364: (p_transaction_step_id => p_transaction_step_id
1365: ,p_name => 'P_STATUS');
1366: l_completion_date := hr_transaction_api.get_Date_value
1367: (p_transaction_step_id => p_transaction_step_id

Line 1366: l_completion_date := hr_transaction_api.get_Date_value

1362: ,p_name => 'P_DURATION_UNIT');
1363: l_status := hr_transaction_api.get_varchar2_value
1364: (p_transaction_step_id => p_transaction_step_id
1365: ,p_name => 'P_STATUS');
1366: l_completion_date := hr_transaction_api.get_Date_value
1367: (p_transaction_step_id => p_transaction_step_id
1368: ,p_name => 'P_COMPLETION_DATE');
1369: l_award := hr_transaction_api.get_varchar2_value
1370: (p_transaction_step_id => p_transaction_step_id

Line 1369: l_award := hr_transaction_api.get_varchar2_value

1365: ,p_name => 'P_STATUS');
1366: l_completion_date := hr_transaction_api.get_Date_value
1367: (p_transaction_step_id => p_transaction_step_id
1368: ,p_name => 'P_COMPLETION_DATE');
1369: l_award := hr_transaction_api.get_varchar2_value
1370: (p_transaction_step_id => p_transaction_step_id
1371: ,p_name => 'P_AWARD');
1372: l_score := hr_transaction_api.get_varchar2_value
1373: (p_transaction_step_id => p_transaction_step_id

Line 1372: l_score := hr_transaction_api.get_varchar2_value

1368: ,p_name => 'P_COMPLETION_DATE');
1369: l_award := hr_transaction_api.get_varchar2_value
1370: (p_transaction_step_id => p_transaction_step_id
1371: ,p_name => 'P_AWARD');
1372: l_score := hr_transaction_api.get_varchar2_value
1373: (p_transaction_step_id => p_transaction_step_id
1374: ,p_name => 'P_SCORE');
1375: l_internal_contact_person := hr_transaction_api.get_varchar2_value
1376: (p_transaction_step_id => p_transaction_step_id

Line 1375: l_internal_contact_person := hr_transaction_api.get_varchar2_value

1371: ,p_name => 'P_AWARD');
1372: l_score := hr_transaction_api.get_varchar2_value
1373: (p_transaction_step_id => p_transaction_step_id
1374: ,p_name => 'P_SCORE');
1375: l_internal_contact_person := hr_transaction_api.get_varchar2_value
1376: (p_transaction_step_id => p_transaction_step_id
1377: ,p_name => 'P_INTERNAL_CONTACT_PERSON');
1378: l_nth_information_category := hr_transaction_api.get_varchar2_value
1379: (p_transaction_step_id => p_transaction_step_id

Line 1378: l_nth_information_category := hr_transaction_api.get_varchar2_value

1374: ,p_name => 'P_SCORE');
1375: l_internal_contact_person := hr_transaction_api.get_varchar2_value
1376: (p_transaction_step_id => p_transaction_step_id
1377: ,p_name => 'P_INTERNAL_CONTACT_PERSON');
1378: l_nth_information_category := hr_transaction_api.get_varchar2_value
1379: (p_transaction_step_id => p_transaction_step_id
1380: ,p_name => 'P_NTH_INFORMATION_CATEGORY');
1381: l_nth_information1 := hr_transaction_api.get_varchar2_value
1382: (p_transaction_step_id => p_transaction_step_id

Line 1381: l_nth_information1 := hr_transaction_api.get_varchar2_value

1377: ,p_name => 'P_INTERNAL_CONTACT_PERSON');
1378: l_nth_information_category := hr_transaction_api.get_varchar2_value
1379: (p_transaction_step_id => p_transaction_step_id
1380: ,p_name => 'P_NTH_INFORMATION_CATEGORY');
1381: l_nth_information1 := hr_transaction_api.get_varchar2_value
1382: (p_transaction_step_id => p_transaction_step_id
1383: ,p_name => 'P_NTH_INFORMATION1');
1384: l_nth_information2 := hr_transaction_api.get_varchar2_value
1385: (p_transaction_step_id => p_transaction_step_id

Line 1384: l_nth_information2 := hr_transaction_api.get_varchar2_value

1380: ,p_name => 'P_NTH_INFORMATION_CATEGORY');
1381: l_nth_information1 := hr_transaction_api.get_varchar2_value
1382: (p_transaction_step_id => p_transaction_step_id
1383: ,p_name => 'P_NTH_INFORMATION1');
1384: l_nth_information2 := hr_transaction_api.get_varchar2_value
1385: (p_transaction_step_id => p_transaction_step_id
1386: ,p_name => 'P_NTH_INFORMATION2');
1387: l_nth_information3 := hr_transaction_api.get_varchar2_value
1388: (p_transaction_step_id => p_transaction_step_id

Line 1387: l_nth_information3 := hr_transaction_api.get_varchar2_value

1383: ,p_name => 'P_NTH_INFORMATION1');
1384: l_nth_information2 := hr_transaction_api.get_varchar2_value
1385: (p_transaction_step_id => p_transaction_step_id
1386: ,p_name => 'P_NTH_INFORMATION2');
1387: l_nth_information3 := hr_transaction_api.get_varchar2_value
1388: (p_transaction_step_id => p_transaction_step_id
1389: ,p_name => 'P_NTH_INFORMATION3');
1390: l_nth_information4 := hr_transaction_api.get_varchar2_value
1391: (p_transaction_step_id => p_transaction_step_id

Line 1390: l_nth_information4 := hr_transaction_api.get_varchar2_value

1386: ,p_name => 'P_NTH_INFORMATION2');
1387: l_nth_information3 := hr_transaction_api.get_varchar2_value
1388: (p_transaction_step_id => p_transaction_step_id
1389: ,p_name => 'P_NTH_INFORMATION3');
1390: l_nth_information4 := hr_transaction_api.get_varchar2_value
1391: (p_transaction_step_id => p_transaction_step_id
1392: ,p_name => 'P_NTH_INFORMATION4');
1393: l_nth_information5 := hr_transaction_api.get_varchar2_value
1394: (p_transaction_step_id => p_transaction_step_id

Line 1393: l_nth_information5 := hr_transaction_api.get_varchar2_value

1389: ,p_name => 'P_NTH_INFORMATION3');
1390: l_nth_information4 := hr_transaction_api.get_varchar2_value
1391: (p_transaction_step_id => p_transaction_step_id
1392: ,p_name => 'P_NTH_INFORMATION4');
1393: l_nth_information5 := hr_transaction_api.get_varchar2_value
1394: (p_transaction_step_id => p_transaction_step_id
1395: ,p_name => 'P_NTH_INFORMATION5');
1396: l_nth_information6 := hr_transaction_api.get_varchar2_value
1397: (p_transaction_step_id => p_transaction_step_id

Line 1396: l_nth_information6 := hr_transaction_api.get_varchar2_value

1392: ,p_name => 'P_NTH_INFORMATION4');
1393: l_nth_information5 := hr_transaction_api.get_varchar2_value
1394: (p_transaction_step_id => p_transaction_step_id
1395: ,p_name => 'P_NTH_INFORMATION5');
1396: l_nth_information6 := hr_transaction_api.get_varchar2_value
1397: (p_transaction_step_id => p_transaction_step_id
1398: ,p_name => 'P_NTH_INFORMATION6');
1399: l_nth_information7 := hr_transaction_api.get_varchar2_value
1400: (p_transaction_step_id => p_transaction_step_id

Line 1399: l_nth_information7 := hr_transaction_api.get_varchar2_value

1395: ,p_name => 'P_NTH_INFORMATION5');
1396: l_nth_information6 := hr_transaction_api.get_varchar2_value
1397: (p_transaction_step_id => p_transaction_step_id
1398: ,p_name => 'P_NTH_INFORMATION6');
1399: l_nth_information7 := hr_transaction_api.get_varchar2_value
1400: (p_transaction_step_id => p_transaction_step_id
1401: ,p_name => 'P_NTH_INFORMATION7');
1402: l_nth_information8 := hr_transaction_api.get_varchar2_value
1403: (p_transaction_step_id => p_transaction_step_id

Line 1402: l_nth_information8 := hr_transaction_api.get_varchar2_value

1398: ,p_name => 'P_NTH_INFORMATION6');
1399: l_nth_information7 := hr_transaction_api.get_varchar2_value
1400: (p_transaction_step_id => p_transaction_step_id
1401: ,p_name => 'P_NTH_INFORMATION7');
1402: l_nth_information8 := hr_transaction_api.get_varchar2_value
1403: (p_transaction_step_id => p_transaction_step_id
1404: ,p_name => 'P_NTH_INFORMATION8');
1405: l_nth_information9 := hr_transaction_api.get_varchar2_value
1406: (p_transaction_step_id => p_transaction_step_id

Line 1405: l_nth_information9 := hr_transaction_api.get_varchar2_value

1401: ,p_name => 'P_NTH_INFORMATION7');
1402: l_nth_information8 := hr_transaction_api.get_varchar2_value
1403: (p_transaction_step_id => p_transaction_step_id
1404: ,p_name => 'P_NTH_INFORMATION8');
1405: l_nth_information9 := hr_transaction_api.get_varchar2_value
1406: (p_transaction_step_id => p_transaction_step_id
1407: ,p_name => 'P_NTH_INFORMATION9');
1408: l_nth_information10 := hr_transaction_api.get_varchar2_value
1409: (p_transaction_step_id => p_transaction_step_id

Line 1408: l_nth_information10 := hr_transaction_api.get_varchar2_value

1404: ,p_name => 'P_NTH_INFORMATION8');
1405: l_nth_information9 := hr_transaction_api.get_varchar2_value
1406: (p_transaction_step_id => p_transaction_step_id
1407: ,p_name => 'P_NTH_INFORMATION9');
1408: l_nth_information10 := hr_transaction_api.get_varchar2_value
1409: (p_transaction_step_id => p_transaction_step_id
1410: ,p_name => 'P_NTH_INFORMATION10');
1411: l_nth_information11 := hr_transaction_api.get_varchar2_value
1412: (p_transaction_step_id => p_transaction_step_id

Line 1411: l_nth_information11 := hr_transaction_api.get_varchar2_value

1407: ,p_name => 'P_NTH_INFORMATION9');
1408: l_nth_information10 := hr_transaction_api.get_varchar2_value
1409: (p_transaction_step_id => p_transaction_step_id
1410: ,p_name => 'P_NTH_INFORMATION10');
1411: l_nth_information11 := hr_transaction_api.get_varchar2_value
1412: (p_transaction_step_id => p_transaction_step_id
1413: ,p_name => 'P_NTH_INFORMATION11');
1414: l_nth_information12 := hr_transaction_api.get_varchar2_value
1415: (p_transaction_step_id => p_transaction_step_id

Line 1414: l_nth_information12 := hr_transaction_api.get_varchar2_value

1410: ,p_name => 'P_NTH_INFORMATION10');
1411: l_nth_information11 := hr_transaction_api.get_varchar2_value
1412: (p_transaction_step_id => p_transaction_step_id
1413: ,p_name => 'P_NTH_INFORMATION11');
1414: l_nth_information12 := hr_transaction_api.get_varchar2_value
1415: (p_transaction_step_id => p_transaction_step_id
1416: ,p_name => 'P_NTH_INFORMATION12');
1417: l_nth_information13 := hr_transaction_api.get_varchar2_value
1418: (p_transaction_step_id => p_transaction_step_id

Line 1417: l_nth_information13 := hr_transaction_api.get_varchar2_value

1413: ,p_name => 'P_NTH_INFORMATION11');
1414: l_nth_information12 := hr_transaction_api.get_varchar2_value
1415: (p_transaction_step_id => p_transaction_step_id
1416: ,p_name => 'P_NTH_INFORMATION12');
1417: l_nth_information13 := hr_transaction_api.get_varchar2_value
1418: (p_transaction_step_id => p_transaction_step_id
1419: ,p_name => 'P_NTH_INFORMATION13');
1420: l_nth_information14 := hr_transaction_api.get_varchar2_value
1421: (p_transaction_step_id => p_transaction_step_id

Line 1420: l_nth_information14 := hr_transaction_api.get_varchar2_value

1416: ,p_name => 'P_NTH_INFORMATION12');
1417: l_nth_information13 := hr_transaction_api.get_varchar2_value
1418: (p_transaction_step_id => p_transaction_step_id
1419: ,p_name => 'P_NTH_INFORMATION13');
1420: l_nth_information14 := hr_transaction_api.get_varchar2_value
1421: (p_transaction_step_id => p_transaction_step_id
1422: ,p_name => 'P_NTH_INFORMATION14');
1423: l_nth_information15 := hr_transaction_api.get_varchar2_value
1424: (p_transaction_step_id => p_transaction_step_id

Line 1423: l_nth_information15 := hr_transaction_api.get_varchar2_value

1419: ,p_name => 'P_NTH_INFORMATION13');
1420: l_nth_information14 := hr_transaction_api.get_varchar2_value
1421: (p_transaction_step_id => p_transaction_step_id
1422: ,p_name => 'P_NTH_INFORMATION14');
1423: l_nth_information15 := hr_transaction_api.get_varchar2_value
1424: (p_transaction_step_id => p_transaction_step_id
1425: ,p_name => 'P_NTH_INFORMATION15');
1426: l_nth_information16 := hr_transaction_api.get_varchar2_value
1427: (p_transaction_step_id => p_transaction_step_id

Line 1426: l_nth_information16 := hr_transaction_api.get_varchar2_value

1422: ,p_name => 'P_NTH_INFORMATION14');
1423: l_nth_information15 := hr_transaction_api.get_varchar2_value
1424: (p_transaction_step_id => p_transaction_step_id
1425: ,p_name => 'P_NTH_INFORMATION15');
1426: l_nth_information16 := hr_transaction_api.get_varchar2_value
1427: (p_transaction_step_id => p_transaction_step_id
1428: ,p_name => 'P_NTH_INFORMATION16');
1429: l_nth_information17 := hr_transaction_api.get_varchar2_value
1430: (p_transaction_step_id => p_transaction_step_id

Line 1429: l_nth_information17 := hr_transaction_api.get_varchar2_value

1425: ,p_name => 'P_NTH_INFORMATION15');
1426: l_nth_information16 := hr_transaction_api.get_varchar2_value
1427: (p_transaction_step_id => p_transaction_step_id
1428: ,p_name => 'P_NTH_INFORMATION16');
1429: l_nth_information17 := hr_transaction_api.get_varchar2_value
1430: (p_transaction_step_id => p_transaction_step_id
1431: ,p_name => 'P_NTH_INFORMATION17');
1432: l_nth_information18 := hr_transaction_api.get_varchar2_value
1433: (p_transaction_step_id => p_transaction_step_id

Line 1432: l_nth_information18 := hr_transaction_api.get_varchar2_value

1428: ,p_name => 'P_NTH_INFORMATION16');
1429: l_nth_information17 := hr_transaction_api.get_varchar2_value
1430: (p_transaction_step_id => p_transaction_step_id
1431: ,p_name => 'P_NTH_INFORMATION17');
1432: l_nth_information18 := hr_transaction_api.get_varchar2_value
1433: (p_transaction_step_id => p_transaction_step_id
1434: ,p_name => 'P_NTH_INFORMATION18');
1435: l_nth_information19 := hr_transaction_api.get_varchar2_value
1436: (p_transaction_step_id => p_transaction_step_id

Line 1435: l_nth_information19 := hr_transaction_api.get_varchar2_value

1431: ,p_name => 'P_NTH_INFORMATION17');
1432: l_nth_information18 := hr_transaction_api.get_varchar2_value
1433: (p_transaction_step_id => p_transaction_step_id
1434: ,p_name => 'P_NTH_INFORMATION18');
1435: l_nth_information19 := hr_transaction_api.get_varchar2_value
1436: (p_transaction_step_id => p_transaction_step_id
1437: ,p_name => 'P_NTH_INFORMATION19');
1438: l_nth_information20 := hr_transaction_api.get_varchar2_value
1439: (p_transaction_step_id => p_transaction_step_id

Line 1438: l_nth_information20 := hr_transaction_api.get_varchar2_value

1434: ,p_name => 'P_NTH_INFORMATION18');
1435: l_nth_information19 := hr_transaction_api.get_varchar2_value
1436: (p_transaction_step_id => p_transaction_step_id
1437: ,p_name => 'P_NTH_INFORMATION19');
1438: l_nth_information20 := hr_transaction_api.get_varchar2_value
1439: (p_transaction_step_id => p_transaction_step_id
1440: ,p_name => 'P_NTH_INFORMATION20');
1441: l_contact_name := hr_transaction_api.get_varchar2_value
1442: (p_transaction_step_id => p_transaction_step_id

Line 1441: l_contact_name := hr_transaction_api.get_varchar2_value

1437: ,p_name => 'P_NTH_INFORMATION19');
1438: l_nth_information20 := hr_transaction_api.get_varchar2_value
1439: (p_transaction_step_id => p_transaction_step_id
1440: ,p_name => 'P_NTH_INFORMATION20');
1441: l_contact_name := hr_transaction_api.get_varchar2_value
1442: (p_transaction_step_id => p_transaction_step_id
1443: ,p_name => 'P_CONTACT_NAME');
1444: l_activity_name := hr_transaction_api.get_varchar2_value
1445: (p_transaction_step_id => p_transaction_step_id

Line 1444: l_activity_name := hr_transaction_api.get_varchar2_value

1440: ,p_name => 'P_NTH_INFORMATION20');
1441: l_contact_name := hr_transaction_api.get_varchar2_value
1442: (p_transaction_step_id => p_transaction_step_id
1443: ,p_name => 'P_CONTACT_NAME');
1444: l_activity_name := hr_transaction_api.get_varchar2_value
1445: (p_transaction_step_id => p_transaction_step_id
1446: ,p_name => 'P_ACTIVITY_NAME');
1447: l_old_obj_ver_no := hr_transaction_api.get_varchar2_value
1448: (p_transaction_step_id => p_transaction_step_id

Line 1447: l_old_obj_ver_no := hr_transaction_api.get_varchar2_value

1443: ,p_name => 'P_CONTACT_NAME');
1444: l_activity_name := hr_transaction_api.get_varchar2_value
1445: (p_transaction_step_id => p_transaction_step_id
1446: ,p_name => 'P_ACTIVITY_NAME');
1447: l_old_obj_ver_no := hr_transaction_api.get_varchar2_value
1448: (p_transaction_step_id => p_transaction_step_id
1449: ,p_name => 'P_OBJ_VER_NO');
1450: l_business_grp_id := hr_transaction_api.get_varchar2_value
1451: (p_transaction_step_id => p_transaction_step_id

Line 1450: l_business_grp_id := hr_transaction_api.get_varchar2_value

1446: ,p_name => 'P_ACTIVITY_NAME');
1447: l_old_obj_ver_no := hr_transaction_api.get_varchar2_value
1448: (p_transaction_step_id => p_transaction_step_id
1449: ,p_name => 'P_OBJ_VER_NO');
1450: l_business_grp_id := hr_transaction_api.get_varchar2_value
1451: (p_transaction_step_id => p_transaction_step_id
1452: ,p_name => 'P_BUSINESS_GRP_ID');
1453: l_person_id := hr_transaction_api.get_number_value
1454: (p_transaction_step_id => p_transaction_step_id

Line 1453: l_person_id := hr_transaction_api.get_number_value

1449: ,p_name => 'P_OBJ_VER_NO');
1450: l_business_grp_id := hr_transaction_api.get_varchar2_value
1451: (p_transaction_step_id => p_transaction_step_id
1452: ,p_name => 'P_BUSINESS_GRP_ID');
1453: l_person_id := hr_transaction_api.get_number_value
1454: (p_transaction_step_id => p_transaction_step_id
1455: ,p_name => 'P_DELEGATE_PERSON_ID');
1456:
1457: l_org_id := hr_transaction_api.get_varchar2_value

Line 1457: l_org_id := hr_transaction_api.get_varchar2_value

1453: l_person_id := hr_transaction_api.get_number_value
1454: (p_transaction_step_id => p_transaction_step_id
1455: ,p_name => 'P_DELEGATE_PERSON_ID');
1456:
1457: l_org_id := hr_transaction_api.get_varchar2_value
1458: (p_transaction_step_id => p_transaction_step_id
1459: ,p_name => 'P_ORG_ID');
1460:
1461:

Line 2668: hr_transaction_api.get_varchar2_value

2664: FOR c in cur_get_pending_trn_step_id --bug 3590613
2665: LOOP
2666:
2667: l_temp_historyid :=
2668: hr_transaction_api.get_varchar2_value
2669: (p_transaction_step_id => c.transaction_step_id
2670: ,p_name => 'P_HISTORYID');
2671:
2672: if (l_temp_historyid is not null and l_temp_historyid = p_nota_history_id) then