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_EL_TRAINING_SS dependencies on HR_TRANSACTION_API

Line 92: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type

88: --
89: -- Delete transaction step if exist
90: --
91:
92: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
93: ,p_item_key => p_item_key
94: ,p_activity_id => p_activity_id) ) then
95:
96: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

Line 96: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

92: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
93: ,p_item_key => p_item_key
94: ,p_activity_id => p_activity_id) ) then
95:
96: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type
97: ,p_item_key => p_item_key
98: ,p_activity_id => p_activity_id
99: ,p_transaction_step_id => l_old_transaction_step_id
100: ,p_object_version_number => l_old_object_version_number);

Line 103: hr_transaction_api.delete_transaction_step(p_validate => false

99: ,p_transaction_step_id => l_old_transaction_step_id
100: ,p_object_version_number => l_old_object_version_number);
101:
102:
103: hr_transaction_api.delete_transaction_step(p_validate => false
104: ,p_transaction_step_id => l_old_transaction_step_id
105: ,p_person_id => p_login_person_id
106: ,p_object_version_number => l_old_object_version_number);
107:

Line 115: hr_transaction_api.create_transaction_step

111: -- Create a transaction step
112: --
113:
114:
115: hr_transaction_api.create_transaction_step
116: (p_validate => false
117: ,p_creator_person_id => p_login_person_id
118: ,p_transaction_id => l_transaction_id
119: ,p_api_name => g_package || '.PROCESS_API'

Line 282: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type

278: --
279: -- Delete transaction step if exist
280: --
281:
282: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
283: ,p_item_key => p_item_key
284: ,p_activity_id => p_activity_id) ) then
285:
286: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

Line 286: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

282: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
283: ,p_item_key => p_item_key
284: ,p_activity_id => p_activity_id) ) then
285:
286: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type
287: ,p_item_key => p_item_key
288: ,p_activity_id => p_activity_id
289: ,p_transaction_step_id => l_old_transaction_step_id
290: ,p_object_version_number => l_old_object_version_number);

Line 293: hr_transaction_api.delete_transaction_step(p_validate => false

289: ,p_transaction_step_id => l_old_transaction_step_id
290: ,p_object_version_number => l_old_object_version_number);
291:
292:
293: hr_transaction_api.delete_transaction_step(p_validate => false
294: ,p_transaction_step_id => l_old_transaction_step_id
295: ,p_person_id => p_login_person_id
296: ,p_object_version_number => l_old_object_version_number);
297:

Line 303: hr_transaction_api.create_transaction_step

299:
300: --
301: -- Create a transaction step
302: --
303: hr_transaction_api.create_transaction_step
304: (p_validate => false
305: ,p_creator_person_id => p_login_person_id
306: ,p_transaction_id => l_transaction_id
307: ,p_api_name => g_package || '.PROCESS_API2'

Line 595: hr_transaction_api.get_transaction_step_info

591:
592:
593: BEGIN
594:
595: hr_transaction_api.get_transaction_step_info
596: (p_item_type => p_item_type
597: ,p_item_key => p_item_key
598: ,p_activity_id => p_activity_id
599: ,p_transaction_step_id => l_trans_step_ids

Line 663: l_eventid := hr_transaction_api.get_varchar2_value

659:
660: begin
661:
662:
663: l_eventid := hr_transaction_api.get_varchar2_value
664: (p_transaction_step_id => p_transaction_step_id
665: ,p_name => 'P_EVENTID');
666:
667: l_activityversionid := hr_transaction_api.get_varchar2_value

Line 667: l_activityversionid := hr_transaction_api.get_varchar2_value

663: l_eventid := hr_transaction_api.get_varchar2_value
664: (p_transaction_step_id => p_transaction_step_id
665: ,p_name => 'P_EVENTID');
666:
667: l_activityversionid := hr_transaction_api.get_varchar2_value
668: (p_transaction_step_id => p_transaction_step_id
669: ,p_name => 'P_ACTIVITYVERSIONID');
670:
671: l_specialInstruction := hr_transaction_api.get_varchar2_value

Line 671: l_specialInstruction := hr_transaction_api.get_varchar2_value

667: l_activityversionid := hr_transaction_api.get_varchar2_value
668: (p_transaction_step_id => p_transaction_step_id
669: ,p_name => 'P_ACTIVITYVERSIONID');
670:
671: l_specialInstruction := hr_transaction_api.get_varchar2_value
672: (p_transaction_step_id => p_transaction_step_id
673: ,p_name => 'P_SPECIALINSTRUCTION');
674:
675: l_keyflexid := hr_transaction_api.get_varchar2_value

Line 675: l_keyflexid := hr_transaction_api.get_varchar2_value

671: l_specialInstruction := hr_transaction_api.get_varchar2_value
672: (p_transaction_step_id => p_transaction_step_id
673: ,p_name => 'P_SPECIALINSTRUCTION');
674:
675: l_keyflexid := hr_transaction_api.get_varchar2_value
676: (p_transaction_step_id => p_transaction_step_id
677: ,p_name => 'P_KEYFLEXID');
678:
679: l_businessgroupid := hr_transaction_api.get_varchar2_value

Line 679: l_businessgroupid := hr_transaction_api.get_varchar2_value

675: l_keyflexid := hr_transaction_api.get_varchar2_value
676: (p_transaction_step_id => p_transaction_step_id
677: ,p_name => 'P_KEYFLEXID');
678:
679: l_businessgroupid := hr_transaction_api.get_varchar2_value
680: (p_transaction_step_id => p_transaction_step_id
681: ,p_name => 'P_BUSINESSGROUPID');
682:
683: l_assignmentid := hr_transaction_api.get_varchar2_value

Line 683: l_assignmentid := hr_transaction_api.get_varchar2_value

679: l_businessgroupid := hr_transaction_api.get_varchar2_value
680: (p_transaction_step_id => p_transaction_step_id
681: ,p_name => 'P_BUSINESSGROUPID');
682:
683: l_assignmentid := hr_transaction_api.get_varchar2_value
684: (p_transaction_step_id => p_transaction_step_id
685: ,p_name => 'P_ASSIGNMENTID');
686:
687: l_organizationid := hr_transaction_api.get_varchar2_value

Line 687: l_organizationid := hr_transaction_api.get_varchar2_value

683: l_assignmentid := hr_transaction_api.get_varchar2_value
684: (p_transaction_step_id => p_transaction_step_id
685: ,p_name => 'P_ASSIGNMENTID');
686:
687: l_organizationid := hr_transaction_api.get_varchar2_value
688: (p_transaction_step_id => p_transaction_step_id
689: ,p_name => 'P_ORGANIZATIONID');
690:
691: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 691: l_tdb_information_category := hr_transaction_api.get_varchar2_value

687: l_organizationid := hr_transaction_api.get_varchar2_value
688: (p_transaction_step_id => p_transaction_step_id
689: ,p_name => 'P_ORGANIZATIONID');
690:
691: l_tdb_information_category := hr_transaction_api.get_varchar2_value
692: (p_transaction_step_id => p_transaction_step_id
693: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
694:
695: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 695: l_tdb_information1 := hr_transaction_api.get_varchar2_value

691: l_tdb_information_category := hr_transaction_api.get_varchar2_value
692: (p_transaction_step_id => p_transaction_step_id
693: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
694:
695: l_tdb_information1 := hr_transaction_api.get_varchar2_value
696: (p_transaction_step_id => p_transaction_step_id
697: ,p_name => 'P_TDB_INFORMATION1');
698:
699: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 699: l_tdb_information2 := hr_transaction_api.get_varchar2_value

695: l_tdb_information1 := hr_transaction_api.get_varchar2_value
696: (p_transaction_step_id => p_transaction_step_id
697: ,p_name => 'P_TDB_INFORMATION1');
698:
699: l_tdb_information2 := hr_transaction_api.get_varchar2_value
700: (p_transaction_step_id => p_transaction_step_id
701: ,p_name => 'P_TDB_INFORMATION2');
702:
703: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 703: l_tdb_information3 := hr_transaction_api.get_varchar2_value

699: l_tdb_information2 := hr_transaction_api.get_varchar2_value
700: (p_transaction_step_id => p_transaction_step_id
701: ,p_name => 'P_TDB_INFORMATION2');
702:
703: l_tdb_information3 := hr_transaction_api.get_varchar2_value
704: (p_transaction_step_id => p_transaction_step_id
705: ,p_name => 'P_TDB_INFORMATION3');
706:
707: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 707: l_tdb_information4 := hr_transaction_api.get_varchar2_value

703: l_tdb_information3 := hr_transaction_api.get_varchar2_value
704: (p_transaction_step_id => p_transaction_step_id
705: ,p_name => 'P_TDB_INFORMATION3');
706:
707: l_tdb_information4 := hr_transaction_api.get_varchar2_value
708: (p_transaction_step_id => p_transaction_step_id
709: ,p_name => 'P_TDB_INFORMATION4');
710:
711: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 711: l_tdb_information5 := hr_transaction_api.get_varchar2_value

707: l_tdb_information4 := hr_transaction_api.get_varchar2_value
708: (p_transaction_step_id => p_transaction_step_id
709: ,p_name => 'P_TDB_INFORMATION4');
710:
711: l_tdb_information5 := hr_transaction_api.get_varchar2_value
712: (p_transaction_step_id => p_transaction_step_id
713: ,p_name => 'P_TDB_INFORMATION5');
714:
715: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 715: l_tdb_information6 := hr_transaction_api.get_varchar2_value

711: l_tdb_information5 := hr_transaction_api.get_varchar2_value
712: (p_transaction_step_id => p_transaction_step_id
713: ,p_name => 'P_TDB_INFORMATION5');
714:
715: l_tdb_information6 := hr_transaction_api.get_varchar2_value
716: (p_transaction_step_id => p_transaction_step_id
717: ,p_name => 'P_TDB_INFORMATION6');
718:
719: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 719: l_tdb_information7 := hr_transaction_api.get_varchar2_value

715: l_tdb_information6 := hr_transaction_api.get_varchar2_value
716: (p_transaction_step_id => p_transaction_step_id
717: ,p_name => 'P_TDB_INFORMATION6');
718:
719: l_tdb_information7 := hr_transaction_api.get_varchar2_value
720: (p_transaction_step_id => p_transaction_step_id
721: ,p_name => 'P_TDB_INFORMATION7');
722:
723: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 723: l_tdb_information8 := hr_transaction_api.get_varchar2_value

719: l_tdb_information7 := hr_transaction_api.get_varchar2_value
720: (p_transaction_step_id => p_transaction_step_id
721: ,p_name => 'P_TDB_INFORMATION7');
722:
723: l_tdb_information8 := hr_transaction_api.get_varchar2_value
724: (p_transaction_step_id => p_transaction_step_id
725: ,p_name => 'P_TDB_INFORMATION8');
726:
727: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 727: l_tdb_information9 := hr_transaction_api.get_varchar2_value

723: l_tdb_information8 := hr_transaction_api.get_varchar2_value
724: (p_transaction_step_id => p_transaction_step_id
725: ,p_name => 'P_TDB_INFORMATION8');
726:
727: l_tdb_information9 := hr_transaction_api.get_varchar2_value
728: (p_transaction_step_id => p_transaction_step_id
729: ,p_name => 'P_TDB_INFORMATION9');
730:
731: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 731: l_tdb_information10 := hr_transaction_api.get_varchar2_value

727: l_tdb_information9 := hr_transaction_api.get_varchar2_value
728: (p_transaction_step_id => p_transaction_step_id
729: ,p_name => 'P_TDB_INFORMATION9');
730:
731: l_tdb_information10 := hr_transaction_api.get_varchar2_value
732: (p_transaction_step_id => p_transaction_step_id
733: ,p_name => 'P_TDB_INFORMATION10');
734:
735: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 735: l_tdb_information11 := hr_transaction_api.get_varchar2_value

731: l_tdb_information10 := hr_transaction_api.get_varchar2_value
732: (p_transaction_step_id => p_transaction_step_id
733: ,p_name => 'P_TDB_INFORMATION10');
734:
735: l_tdb_information11 := hr_transaction_api.get_varchar2_value
736: (p_transaction_step_id => p_transaction_step_id
737: ,p_name => 'P_TDB_INFORMATION11');
738:
739: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 739: l_tdb_information12 := hr_transaction_api.get_varchar2_value

735: l_tdb_information11 := hr_transaction_api.get_varchar2_value
736: (p_transaction_step_id => p_transaction_step_id
737: ,p_name => 'P_TDB_INFORMATION11');
738:
739: l_tdb_information12 := hr_transaction_api.get_varchar2_value
740: (p_transaction_step_id => p_transaction_step_id
741: ,p_name => 'P_TDB_INFORMATION12');
742:
743: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 743: l_tdb_information13 := hr_transaction_api.get_varchar2_value

739: l_tdb_information12 := hr_transaction_api.get_varchar2_value
740: (p_transaction_step_id => p_transaction_step_id
741: ,p_name => 'P_TDB_INFORMATION12');
742:
743: l_tdb_information13 := hr_transaction_api.get_varchar2_value
744: (p_transaction_step_id => p_transaction_step_id
745: ,p_name => 'P_TDB_INFORMATION13');
746:
747: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 747: l_tdb_information14 := hr_transaction_api.get_varchar2_value

743: l_tdb_information13 := hr_transaction_api.get_varchar2_value
744: (p_transaction_step_id => p_transaction_step_id
745: ,p_name => 'P_TDB_INFORMATION13');
746:
747: l_tdb_information14 := hr_transaction_api.get_varchar2_value
748: (p_transaction_step_id => p_transaction_step_id
749: ,p_name => 'P_TDB_INFORMATION14');
750:
751: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 751: l_tdb_information15 := hr_transaction_api.get_varchar2_value

747: l_tdb_information14 := hr_transaction_api.get_varchar2_value
748: (p_transaction_step_id => p_transaction_step_id
749: ,p_name => 'P_TDB_INFORMATION14');
750:
751: l_tdb_information15 := hr_transaction_api.get_varchar2_value
752: (p_transaction_step_id => p_transaction_step_id
753: ,p_name => 'P_TDB_INFORMATION15');
754:
755: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 755: l_tdb_information16 := hr_transaction_api.get_varchar2_value

751: l_tdb_information15 := hr_transaction_api.get_varchar2_value
752: (p_transaction_step_id => p_transaction_step_id
753: ,p_name => 'P_TDB_INFORMATION15');
754:
755: l_tdb_information16 := hr_transaction_api.get_varchar2_value
756: (p_transaction_step_id => p_transaction_step_id
757: ,p_name => 'P_TDB_INFORMATION16');
758:
759: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 759: l_tdb_information17 := hr_transaction_api.get_varchar2_value

755: l_tdb_information16 := hr_transaction_api.get_varchar2_value
756: (p_transaction_step_id => p_transaction_step_id
757: ,p_name => 'P_TDB_INFORMATION16');
758:
759: l_tdb_information17 := hr_transaction_api.get_varchar2_value
760: (p_transaction_step_id => p_transaction_step_id
761: ,p_name => 'P_TDB_INFORMATION17');
762:
763: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 763: l_tdb_information18 := hr_transaction_api.get_varchar2_value

759: l_tdb_information17 := hr_transaction_api.get_varchar2_value
760: (p_transaction_step_id => p_transaction_step_id
761: ,p_name => 'P_TDB_INFORMATION17');
762:
763: l_tdb_information18 := hr_transaction_api.get_varchar2_value
764: (p_transaction_step_id => p_transaction_step_id
765: ,p_name => 'P_TDB_INFORMATION18');
766:
767: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 767: l_tdb_information19 := hr_transaction_api.get_varchar2_value

763: l_tdb_information18 := hr_transaction_api.get_varchar2_value
764: (p_transaction_step_id => p_transaction_step_id
765: ,p_name => 'P_TDB_INFORMATION18');
766:
767: l_tdb_information19 := hr_transaction_api.get_varchar2_value
768: (p_transaction_step_id => p_transaction_step_id
769: ,p_name => 'P_TDB_INFORMATION19');
770:
771: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 771: l_tdb_information20 := hr_transaction_api.get_varchar2_value

767: l_tdb_information19 := hr_transaction_api.get_varchar2_value
768: (p_transaction_step_id => p_transaction_step_id
769: ,p_name => 'P_TDB_INFORMATION19');
770:
771: l_tdb_information20 := hr_transaction_api.get_varchar2_value
772: (p_transaction_step_id => p_transaction_step_id
773: ,p_name => 'P_TDB_INFORMATION20');
774:
775: l_oafunc := hr_transaction_api.get_varchar2_value

Line 775: l_oafunc := hr_transaction_api.get_varchar2_value

771: l_tdb_information20 := hr_transaction_api.get_varchar2_value
772: (p_transaction_step_id => p_transaction_step_id
773: ,p_name => 'P_TDB_INFORMATION20');
774:
775: l_oafunc := hr_transaction_api.get_varchar2_value
776: (p_transaction_step_id => p_transaction_step_id
777: ,p_name => 'P_OAFUNC');
778:
779: l_processname := hr_transaction_api.get_varchar2_value

Line 779: l_processname := hr_transaction_api.get_varchar2_value

775: l_oafunc := hr_transaction_api.get_varchar2_value
776: (p_transaction_step_id => p_transaction_step_id
777: ,p_name => 'P_OAFUNC');
778:
779: l_processname := hr_transaction_api.get_varchar2_value
780: (p_transaction_step_id => p_transaction_step_id
781: ,p_name => 'P_PROCESSNAME');
782:
783: l_calledfrom := hr_transaction_api.get_varchar2_value

Line 783: l_calledfrom := hr_transaction_api.get_varchar2_value

779: l_processname := hr_transaction_api.get_varchar2_value
780: (p_transaction_step_id => p_transaction_step_id
781: ,p_name => 'P_PROCESSNAME');
782:
783: l_calledfrom := hr_transaction_api.get_varchar2_value
784: (p_transaction_step_id => p_transaction_step_id
785: ,p_name => 'P_CALLEDFROM');
786:
787: l_frommenu := hr_transaction_api.get_varchar2_value

Line 787: l_frommenu := hr_transaction_api.get_varchar2_value

783: l_calledfrom := hr_transaction_api.get_varchar2_value
784: (p_transaction_step_id => p_transaction_step_id
785: ,p_name => 'P_CALLEDFROM');
786:
787: l_frommenu := hr_transaction_api.get_varchar2_value
788: (p_transaction_step_id => p_transaction_step_id
789: ,p_name => 'P_FROMMENU');
790:
791: --

Line 859: hr_transaction_api.get_transaction_step_info

855:
856:
857: BEGIN
858:
859: hr_transaction_api.get_transaction_step_info
860: (p_item_type => p_item_type
861: ,p_item_key => p_item_key
862: ,p_activity_id => p_activity_id
863: ,p_transaction_step_id => l_trans_step_ids

Line 920: l_eventid := hr_transaction_api.get_varchar2_value

916:
917: begin
918:
919:
920: l_eventid := hr_transaction_api.get_varchar2_value
921: (p_transaction_step_id => p_transaction_step_id
922: ,p_name => 'P_EVENTID');
923:
924:

Line 925: l_specialInstruction := hr_transaction_api.get_varchar2_value

921: (p_transaction_step_id => p_transaction_step_id
922: ,p_name => 'P_EVENTID');
923:
924:
925: l_specialInstruction := hr_transaction_api.get_varchar2_value
926: (p_transaction_step_id => p_transaction_step_id
927: ,p_name => 'P_SPECIALINSTRUCTION');
928:
929: /* l_keyflexid := hr_transaction_api.get_varchar2_value

Line 929: /* l_keyflexid := hr_transaction_api.get_varchar2_value

925: l_specialInstruction := hr_transaction_api.get_varchar2_value
926: (p_transaction_step_id => p_transaction_step_id
927: ,p_name => 'P_SPECIALINSTRUCTION');
928:
929: /* l_keyflexid := hr_transaction_api.get_varchar2_value
930: (p_transaction_step_id => p_transaction_step_id
931: ,p_name => 'P_KEYFLEXID'); */
932:
933: l_ccselectiontext := hr_transaction_api.get_varchar2_value

Line 933: l_ccselectiontext := hr_transaction_api.get_varchar2_value

929: /* l_keyflexid := hr_transaction_api.get_varchar2_value
930: (p_transaction_step_id => p_transaction_step_id
931: ,p_name => 'P_KEYFLEXID'); */
932:
933: l_ccselectiontext := hr_transaction_api.get_varchar2_value
934: (p_transaction_step_id => p_transaction_step_id
935: ,p_name => 'P_CCSELECTIONTEXT');
936:
937: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 937: l_tdb_information_category := hr_transaction_api.get_varchar2_value

933: l_ccselectiontext := hr_transaction_api.get_varchar2_value
934: (p_transaction_step_id => p_transaction_step_id
935: ,p_name => 'P_CCSELECTIONTEXT');
936:
937: l_tdb_information_category := hr_transaction_api.get_varchar2_value
938: (p_transaction_step_id => p_transaction_step_id
939: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
940:
941: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 941: l_tdb_information1 := hr_transaction_api.get_varchar2_value

937: l_tdb_information_category := hr_transaction_api.get_varchar2_value
938: (p_transaction_step_id => p_transaction_step_id
939: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
940:
941: l_tdb_information1 := hr_transaction_api.get_varchar2_value
942: (p_transaction_step_id => p_transaction_step_id
943: ,p_name => 'P_TDB_INFORMATION1');
944:
945: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 945: l_tdb_information2 := hr_transaction_api.get_varchar2_value

941: l_tdb_information1 := hr_transaction_api.get_varchar2_value
942: (p_transaction_step_id => p_transaction_step_id
943: ,p_name => 'P_TDB_INFORMATION1');
944:
945: l_tdb_information2 := hr_transaction_api.get_varchar2_value
946: (p_transaction_step_id => p_transaction_step_id
947: ,p_name => 'P_TDB_INFORMATION2');
948:
949: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 949: l_tdb_information3 := hr_transaction_api.get_varchar2_value

945: l_tdb_information2 := hr_transaction_api.get_varchar2_value
946: (p_transaction_step_id => p_transaction_step_id
947: ,p_name => 'P_TDB_INFORMATION2');
948:
949: l_tdb_information3 := hr_transaction_api.get_varchar2_value
950: (p_transaction_step_id => p_transaction_step_id
951: ,p_name => 'P_TDB_INFORMATION3');
952:
953: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 953: l_tdb_information4 := hr_transaction_api.get_varchar2_value

949: l_tdb_information3 := hr_transaction_api.get_varchar2_value
950: (p_transaction_step_id => p_transaction_step_id
951: ,p_name => 'P_TDB_INFORMATION3');
952:
953: l_tdb_information4 := hr_transaction_api.get_varchar2_value
954: (p_transaction_step_id => p_transaction_step_id
955: ,p_name => 'P_TDB_INFORMATION4');
956:
957: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 957: l_tdb_information5 := hr_transaction_api.get_varchar2_value

953: l_tdb_information4 := hr_transaction_api.get_varchar2_value
954: (p_transaction_step_id => p_transaction_step_id
955: ,p_name => 'P_TDB_INFORMATION4');
956:
957: l_tdb_information5 := hr_transaction_api.get_varchar2_value
958: (p_transaction_step_id => p_transaction_step_id
959: ,p_name => 'P_TDB_INFORMATION5');
960:
961: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 961: l_tdb_information6 := hr_transaction_api.get_varchar2_value

957: l_tdb_information5 := hr_transaction_api.get_varchar2_value
958: (p_transaction_step_id => p_transaction_step_id
959: ,p_name => 'P_TDB_INFORMATION5');
960:
961: l_tdb_information6 := hr_transaction_api.get_varchar2_value
962: (p_transaction_step_id => p_transaction_step_id
963: ,p_name => 'P_TDB_INFORMATION6');
964:
965: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 965: l_tdb_information7 := hr_transaction_api.get_varchar2_value

961: l_tdb_information6 := hr_transaction_api.get_varchar2_value
962: (p_transaction_step_id => p_transaction_step_id
963: ,p_name => 'P_TDB_INFORMATION6');
964:
965: l_tdb_information7 := hr_transaction_api.get_varchar2_value
966: (p_transaction_step_id => p_transaction_step_id
967: ,p_name => 'P_TDB_INFORMATION7');
968:
969: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 969: l_tdb_information8 := hr_transaction_api.get_varchar2_value

965: l_tdb_information7 := hr_transaction_api.get_varchar2_value
966: (p_transaction_step_id => p_transaction_step_id
967: ,p_name => 'P_TDB_INFORMATION7');
968:
969: l_tdb_information8 := hr_transaction_api.get_varchar2_value
970: (p_transaction_step_id => p_transaction_step_id
971: ,p_name => 'P_TDB_INFORMATION8');
972:
973: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 973: l_tdb_information9 := hr_transaction_api.get_varchar2_value

969: l_tdb_information8 := hr_transaction_api.get_varchar2_value
970: (p_transaction_step_id => p_transaction_step_id
971: ,p_name => 'P_TDB_INFORMATION8');
972:
973: l_tdb_information9 := hr_transaction_api.get_varchar2_value
974: (p_transaction_step_id => p_transaction_step_id
975: ,p_name => 'P_TDB_INFORMATION9');
976:
977: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 977: l_tdb_information10 := hr_transaction_api.get_varchar2_value

973: l_tdb_information9 := hr_transaction_api.get_varchar2_value
974: (p_transaction_step_id => p_transaction_step_id
975: ,p_name => 'P_TDB_INFORMATION9');
976:
977: l_tdb_information10 := hr_transaction_api.get_varchar2_value
978: (p_transaction_step_id => p_transaction_step_id
979: ,p_name => 'P_TDB_INFORMATION10');
980:
981: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 981: l_tdb_information11 := hr_transaction_api.get_varchar2_value

977: l_tdb_information10 := hr_transaction_api.get_varchar2_value
978: (p_transaction_step_id => p_transaction_step_id
979: ,p_name => 'P_TDB_INFORMATION10');
980:
981: l_tdb_information11 := hr_transaction_api.get_varchar2_value
982: (p_transaction_step_id => p_transaction_step_id
983: ,p_name => 'P_TDB_INFORMATION11');
984:
985: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 985: l_tdb_information12 := hr_transaction_api.get_varchar2_value

981: l_tdb_information11 := hr_transaction_api.get_varchar2_value
982: (p_transaction_step_id => p_transaction_step_id
983: ,p_name => 'P_TDB_INFORMATION11');
984:
985: l_tdb_information12 := hr_transaction_api.get_varchar2_value
986: (p_transaction_step_id => p_transaction_step_id
987: ,p_name => 'P_TDB_INFORMATION12');
988:
989: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 989: l_tdb_information13 := hr_transaction_api.get_varchar2_value

985: l_tdb_information12 := hr_transaction_api.get_varchar2_value
986: (p_transaction_step_id => p_transaction_step_id
987: ,p_name => 'P_TDB_INFORMATION12');
988:
989: l_tdb_information13 := hr_transaction_api.get_varchar2_value
990: (p_transaction_step_id => p_transaction_step_id
991: ,p_name => 'P_TDB_INFORMATION13');
992:
993: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 993: l_tdb_information14 := hr_transaction_api.get_varchar2_value

989: l_tdb_information13 := hr_transaction_api.get_varchar2_value
990: (p_transaction_step_id => p_transaction_step_id
991: ,p_name => 'P_TDB_INFORMATION13');
992:
993: l_tdb_information14 := hr_transaction_api.get_varchar2_value
994: (p_transaction_step_id => p_transaction_step_id
995: ,p_name => 'P_TDB_INFORMATION14');
996:
997: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 997: l_tdb_information15 := hr_transaction_api.get_varchar2_value

993: l_tdb_information14 := hr_transaction_api.get_varchar2_value
994: (p_transaction_step_id => p_transaction_step_id
995: ,p_name => 'P_TDB_INFORMATION14');
996:
997: l_tdb_information15 := hr_transaction_api.get_varchar2_value
998: (p_transaction_step_id => p_transaction_step_id
999: ,p_name => 'P_TDB_INFORMATION15');
1000:
1001: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 1001: l_tdb_information16 := hr_transaction_api.get_varchar2_value

997: l_tdb_information15 := hr_transaction_api.get_varchar2_value
998: (p_transaction_step_id => p_transaction_step_id
999: ,p_name => 'P_TDB_INFORMATION15');
1000:
1001: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1002: (p_transaction_step_id => p_transaction_step_id
1003: ,p_name => 'P_TDB_INFORMATION16');
1004:
1005: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 1005: l_tdb_information17 := hr_transaction_api.get_varchar2_value

1001: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1002: (p_transaction_step_id => p_transaction_step_id
1003: ,p_name => 'P_TDB_INFORMATION16');
1004:
1005: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1006: (p_transaction_step_id => p_transaction_step_id
1007: ,p_name => 'P_TDB_INFORMATION17');
1008:
1009: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 1009: l_tdb_information18 := hr_transaction_api.get_varchar2_value

1005: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1006: (p_transaction_step_id => p_transaction_step_id
1007: ,p_name => 'P_TDB_INFORMATION17');
1008:
1009: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1010: (p_transaction_step_id => p_transaction_step_id
1011: ,p_name => 'P_TDB_INFORMATION18');
1012:
1013: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 1013: l_tdb_information19 := hr_transaction_api.get_varchar2_value

1009: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1010: (p_transaction_step_id => p_transaction_step_id
1011: ,p_name => 'P_TDB_INFORMATION18');
1012:
1013: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1014: (p_transaction_step_id => p_transaction_step_id
1015: ,p_name => 'P_TDB_INFORMATION19');
1016:
1017: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 1017: l_tdb_information20 := hr_transaction_api.get_varchar2_value

1013: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1014: (p_transaction_step_id => p_transaction_step_id
1015: ,p_name => 'P_TDB_INFORMATION19');
1016:
1017: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1018: (p_transaction_step_id => p_transaction_step_id
1019: ,p_name => 'P_TDB_INFORMATION20');
1020:
1021: l_trnorgnames := hr_transaction_api.get_varchar2_value

Line 1021: l_trnorgnames := hr_transaction_api.get_varchar2_value

1017: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1018: (p_transaction_step_id => p_transaction_step_id
1019: ,p_name => 'P_TDB_INFORMATION20');
1020:
1021: l_trnorgnames := hr_transaction_api.get_varchar2_value
1022: (p_transaction_step_id => p_transaction_step_id
1023: ,p_name => 'P_TRNORGNAMES');
1024:
1025: --

Line 1229: l_from := hr_transaction_api.get_varchar2_value

1225: Employee_id = p_owner_id ;
1226:
1227: BEGIN
1228:
1229: l_from := hr_transaction_api.get_varchar2_value
1230: (p_transaction_step_id => p_transaction_step_id
1231: ,p_name => 'P_FROM');
1232:
1233: hr_transaction_api.get_transaction_step_info

Line 1233: hr_transaction_api.get_transaction_step_info

1229: l_from := hr_transaction_api.get_varchar2_value
1230: (p_transaction_step_id => p_transaction_step_id
1231: ,p_name => 'P_FROM');
1232:
1233: hr_transaction_api.get_transaction_step_info
1234: (p_transaction_step_id => p_transaction_step_id
1235: ,p_item_type => l_item_type
1236: ,p_item_key => l_item_key
1237: ,p_activity_id => l_activity_id);

Line 1244: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1240:
1241: -- establish Savepoint
1242: SAVEPOINT validate_enrollment;
1243:
1244: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1245: (p_transaction_step_id => p_transaction_step_id
1246: ,p_name => 'P_EVENTID'));
1247:
1248: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id

Line 1249: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1245: (p_transaction_step_id => p_transaction_step_id
1246: ,p_name => 'P_EVENTID'));
1247:
1248: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
1249: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1250: (p_transaction_step_id => p_transaction_step_id
1251: -- ,p_name => 'P_PERSON_ID'));
1252: ,p_name => 'P_DELEGATE_PERSON_ID'));
1253:

Line 1255: l_specialInstruction := hr_transaction_api.get_varchar2_value

1251: -- ,p_name => 'P_PERSON_ID'));
1252: ,p_name => 'P_DELEGATE_PERSON_ID'));
1253:
1254:
1255: l_specialInstruction := hr_transaction_api.get_varchar2_value
1256: (p_transaction_step_id => p_transaction_step_id
1257: ,p_name => 'P_SPECIALINSTRUCTION');
1258:
1259: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 1259: l_tdb_information_category := hr_transaction_api.get_varchar2_value

1255: l_specialInstruction := hr_transaction_api.get_varchar2_value
1256: (p_transaction_step_id => p_transaction_step_id
1257: ,p_name => 'P_SPECIALINSTRUCTION');
1258:
1259: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1260: (p_transaction_step_id => p_transaction_step_id
1261: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1262:
1263: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 1263: l_tdb_information1 := hr_transaction_api.get_varchar2_value

1259: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1260: (p_transaction_step_id => p_transaction_step_id
1261: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1262:
1263: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1264: (p_transaction_step_id => p_transaction_step_id
1265: ,p_name => 'P_TDB_INFORMATION1');
1266:
1267: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 1267: l_tdb_information2 := hr_transaction_api.get_varchar2_value

1263: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1264: (p_transaction_step_id => p_transaction_step_id
1265: ,p_name => 'P_TDB_INFORMATION1');
1266:
1267: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1268: (p_transaction_step_id => p_transaction_step_id
1269: ,p_name => 'P_TDB_INFORMATION2');
1270:
1271: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 1271: l_tdb_information3 := hr_transaction_api.get_varchar2_value

1267: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1268: (p_transaction_step_id => p_transaction_step_id
1269: ,p_name => 'P_TDB_INFORMATION2');
1270:
1271: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1272: (p_transaction_step_id => p_transaction_step_id
1273: ,p_name => 'P_TDB_INFORMATION3');
1274:
1275: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 1275: l_tdb_information4 := hr_transaction_api.get_varchar2_value

1271: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1272: (p_transaction_step_id => p_transaction_step_id
1273: ,p_name => 'P_TDB_INFORMATION3');
1274:
1275: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1276: (p_transaction_step_id => p_transaction_step_id
1277: ,p_name => 'P_TDB_INFORMATION4');
1278:
1279: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 1279: l_tdb_information5 := hr_transaction_api.get_varchar2_value

1275: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1276: (p_transaction_step_id => p_transaction_step_id
1277: ,p_name => 'P_TDB_INFORMATION4');
1278:
1279: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1280: (p_transaction_step_id => p_transaction_step_id
1281: ,p_name => 'P_TDB_INFORMATION5');
1282:
1283: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 1283: l_tdb_information6 := hr_transaction_api.get_varchar2_value

1279: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1280: (p_transaction_step_id => p_transaction_step_id
1281: ,p_name => 'P_TDB_INFORMATION5');
1282:
1283: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1284: (p_transaction_step_id => p_transaction_step_id
1285: ,p_name => 'P_TDB_INFORMATION6');
1286:
1287: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 1287: l_tdb_information7 := hr_transaction_api.get_varchar2_value

1283: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1284: (p_transaction_step_id => p_transaction_step_id
1285: ,p_name => 'P_TDB_INFORMATION6');
1286:
1287: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1288: (p_transaction_step_id => p_transaction_step_id
1289: ,p_name => 'P_TDB_INFORMATION7');
1290:
1291: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 1291: l_tdb_information8 := hr_transaction_api.get_varchar2_value

1287: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1288: (p_transaction_step_id => p_transaction_step_id
1289: ,p_name => 'P_TDB_INFORMATION7');
1290:
1291: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1292: (p_transaction_step_id => p_transaction_step_id
1293: ,p_name => 'P_TDB_INFORMATION8');
1294:
1295: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 1295: l_tdb_information9 := hr_transaction_api.get_varchar2_value

1291: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1292: (p_transaction_step_id => p_transaction_step_id
1293: ,p_name => 'P_TDB_INFORMATION8');
1294:
1295: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1296: (p_transaction_step_id => p_transaction_step_id
1297: ,p_name => 'P_TDB_INFORMATION9');
1298:
1299: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 1299: l_tdb_information10 := hr_transaction_api.get_varchar2_value

1295: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1296: (p_transaction_step_id => p_transaction_step_id
1297: ,p_name => 'P_TDB_INFORMATION9');
1298:
1299: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1300: (p_transaction_step_id => p_transaction_step_id
1301: ,p_name => 'P_TDB_INFORMATION10');
1302:
1303: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 1303: l_tdb_information11 := hr_transaction_api.get_varchar2_value

1299: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1300: (p_transaction_step_id => p_transaction_step_id
1301: ,p_name => 'P_TDB_INFORMATION10');
1302:
1303: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1304: (p_transaction_step_id => p_transaction_step_id
1305: ,p_name => 'P_TDB_INFORMATION11');
1306:
1307: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 1307: l_tdb_information12 := hr_transaction_api.get_varchar2_value

1303: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1304: (p_transaction_step_id => p_transaction_step_id
1305: ,p_name => 'P_TDB_INFORMATION11');
1306:
1307: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1308: (p_transaction_step_id => p_transaction_step_id
1309: ,p_name => 'P_TDB_INFORMATION12');
1310:
1311: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 1311: l_tdb_information13 := hr_transaction_api.get_varchar2_value

1307: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1308: (p_transaction_step_id => p_transaction_step_id
1309: ,p_name => 'P_TDB_INFORMATION12');
1310:
1311: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1312: (p_transaction_step_id => p_transaction_step_id
1313: ,p_name => 'P_TDB_INFORMATION13');
1314:
1315: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 1315: l_tdb_information14 := hr_transaction_api.get_varchar2_value

1311: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1312: (p_transaction_step_id => p_transaction_step_id
1313: ,p_name => 'P_TDB_INFORMATION13');
1314:
1315: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1316: (p_transaction_step_id => p_transaction_step_id
1317: ,p_name => 'P_TDB_INFORMATION14');
1318:
1319: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 1319: l_tdb_information15 := hr_transaction_api.get_varchar2_value

1315: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1316: (p_transaction_step_id => p_transaction_step_id
1317: ,p_name => 'P_TDB_INFORMATION14');
1318:
1319: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1320: (p_transaction_step_id => p_transaction_step_id
1321: ,p_name => 'P_TDB_INFORMATION15');
1322:
1323: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 1323: l_tdb_information16 := hr_transaction_api.get_varchar2_value

1319: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1320: (p_transaction_step_id => p_transaction_step_id
1321: ,p_name => 'P_TDB_INFORMATION15');
1322:
1323: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1324: (p_transaction_step_id => p_transaction_step_id
1325: ,p_name => 'P_TDB_INFORMATION16');
1326:
1327: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 1327: l_tdb_information17 := hr_transaction_api.get_varchar2_value

1323: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1324: (p_transaction_step_id => p_transaction_step_id
1325: ,p_name => 'P_TDB_INFORMATION16');
1326:
1327: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1328: (p_transaction_step_id => p_transaction_step_id
1329: ,p_name => 'P_TDB_INFORMATION17');
1330:
1331: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 1331: l_tdb_information18 := hr_transaction_api.get_varchar2_value

1327: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1328: (p_transaction_step_id => p_transaction_step_id
1329: ,p_name => 'P_TDB_INFORMATION17');
1330:
1331: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1332: (p_transaction_step_id => p_transaction_step_id
1333: ,p_name => 'P_TDB_INFORMATION18');
1334:
1335: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 1335: l_tdb_information19 := hr_transaction_api.get_varchar2_value

1331: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1332: (p_transaction_step_id => p_transaction_step_id
1333: ,p_name => 'P_TDB_INFORMATION18');
1334:
1335: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1336: (p_transaction_step_id => p_transaction_step_id
1337: ,p_name => 'P_TDB_INFORMATION19');
1338:
1339: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 1339: l_tdb_information20 := hr_transaction_api.get_varchar2_value

1335: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1336: (p_transaction_step_id => p_transaction_step_id
1337: ,p_name => 'P_TDB_INFORMATION19');
1338:
1339: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1340: (p_transaction_step_id => p_transaction_step_id
1341: ,p_name => 'P_TDB_INFORMATION20');
1342:
1343:

Line 1603: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1599: end if;
1600:
1601: ELSIF l_from = 'APPROVE' then -- update enrollment and create finance line if profile is set to YES
1602:
1603: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1604: (p_transaction_step_id => p_transaction_step_id
1605: ,p_name => 'P_EVENTID'));
1606:
1607:

Line 1609: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1605: ,p_name => 'P_EVENTID'));
1606:
1607:
1608: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
1609: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1610: (p_transaction_step_id => p_transaction_step_id
1611: -- ,p_name => 'P_PERSON_ID'));
1612: ,p_name => 'P_DELEGATE_PERSON_ID'));
1613:

Line 1714: l_cost_allocation_keyflex_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1710: IF l_auto_create_finance = 'Y' and
1711: l_price_basis <> 'N' and
1712: l_event_currency_code is not null THEN
1713:
1714: l_cost_allocation_keyflex_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1715: (p_transaction_step_id => p_transaction_step_id
1716: ,p_name => 'P_KEYFLEXID'));
1717:
1718:

Line 1719: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value

1715: (p_transaction_step_id => p_transaction_step_id
1716: ,p_name => 'P_KEYFLEXID'));
1717:
1718:
1719: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value
1720: (p_transaction_step_id => p_transaction_step_id
1721: ,p_name => 'P_BUSINESSGROUPID'));
1722:
1723: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

Line 1723: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1719: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value
1720: (p_transaction_step_id => p_transaction_step_id
1721: ,p_name => 'P_BUSINESSGROUPID'));
1722:
1723: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1724: (p_transaction_step_id => p_transaction_step_id
1725: ,p_name => 'P_ASSIGNMENTID'));
1726:
1727: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

Line 1727: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1723: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1724: (p_transaction_step_id => p_transaction_step_id
1725: ,p_name => 'P_ASSIGNMENTID'));
1726:
1727: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1728: (p_transaction_step_id => p_transaction_step_id
1729: ,p_name => 'P_ORGANIZATIONID'));
1730:
1731: -- --------------------------------------------