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

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

100: --
101: -- Delete transaction step if exist
102: --
103:
104: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
105: ,p_item_key => p_item_key
106: ,p_activity_id => p_activity_id) ) then
107:
108: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

Line 108: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

104: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
105: ,p_item_key => p_item_key
106: ,p_activity_id => p_activity_id) ) then
107:
108: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type
109: ,p_item_key => p_item_key
110: ,p_activity_id => p_activity_id
111: ,p_transaction_step_id => l_old_transaction_step_id
112: ,p_object_version_number => l_old_object_version_number);

Line 115: hr_transaction_api.delete_transaction_step(p_validate => false

111: ,p_transaction_step_id => l_old_transaction_step_id
112: ,p_object_version_number => l_old_object_version_number);
113:
114:
115: hr_transaction_api.delete_transaction_step(p_validate => false
116: ,p_transaction_step_id => l_old_transaction_step_id
117: ,p_person_id => p_login_person_id
118: ,p_object_version_number => l_old_object_version_number);
119:

Line 127: hr_transaction_api.create_transaction_step

123: -- Create a transaction step
124: --
125:
126:
127: hr_transaction_api.create_transaction_step
128: (p_validate => false
129: ,p_creator_person_id => p_login_person_id
130: ,p_transaction_id => l_transaction_id
131: ,p_api_name => g_package || '.PROCESS_API'

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

357: --
358: -- Delete transaction step if exist
359: --
360:
361: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
362: ,p_item_key => p_item_key
363: ,p_activity_id => p_activity_id) ) then
364:
365: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

Line 365: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

361: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
362: ,p_item_key => p_item_key
363: ,p_activity_id => p_activity_id) ) then
364:
365: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type
366: ,p_item_key => p_item_key
367: ,p_activity_id => p_activity_id
368: ,p_transaction_step_id => l_old_transaction_step_id
369: ,p_object_version_number => l_old_object_version_number);

Line 372: hr_transaction_api.delete_transaction_step(p_validate => false

368: ,p_transaction_step_id => l_old_transaction_step_id
369: ,p_object_version_number => l_old_object_version_number);
370:
371:
372: hr_transaction_api.delete_transaction_step(p_validate => false
373: ,p_transaction_step_id => l_old_transaction_step_id
374: ,p_person_id => p_login_person_id
375: ,p_object_version_number => l_old_object_version_number);
376:

Line 382: hr_transaction_api.create_transaction_step

378:
379: --
380: -- Create a transaction step
381: --
382: hr_transaction_api.create_transaction_step
383: (p_validate => false
384: ,p_creator_person_id => p_login_person_id
385: ,p_transaction_id => l_transaction_id
386: ,p_api_name => g_package || '.PROCESS_API2'

Line 680: hr_transaction_api.get_transaction_step_info

676:
677:
678: BEGIN
679:
680: hr_transaction_api.get_transaction_step_info
681: (p_item_type => p_item_type
682: ,p_item_key => p_item_key
683: ,p_activity_id => p_activity_id
684: ,p_transaction_step_id => l_trans_step_ids

Line 737: l_keyword := hr_transaction_api.get_varchar2_value

733: l_frommenu varchar2(100);
734: begin
735:
736:
737: l_keyword := hr_transaction_api.get_varchar2_value
738: (p_transaction_step_id => p_transaction_step_id
739: ,p_name => 'P_KEYWORD');
740:
741: l_category := hr_transaction_api.get_varchar2_value

Line 741: l_category := hr_transaction_api.get_varchar2_value

737: l_keyword := hr_transaction_api.get_varchar2_value
738: (p_transaction_step_id => p_transaction_step_id
739: ,p_name => 'P_KEYWORD');
740:
741: l_category := hr_transaction_api.get_varchar2_value
742: (p_transaction_step_id => p_transaction_step_id
743: ,p_name => 'P_CATEGORY');
744:
745: l_dmethod := hr_transaction_api.get_varchar2_value

Line 745: l_dmethod := hr_transaction_api.get_varchar2_value

741: l_category := hr_transaction_api.get_varchar2_value
742: (p_transaction_step_id => p_transaction_step_id
743: ,p_name => 'P_CATEGORY');
744:
745: l_dmethod := hr_transaction_api.get_varchar2_value
746: (p_transaction_step_id => p_transaction_step_id
747: ,p_name => 'P_DMETHOD');
748:
749: l_language := hr_transaction_api.get_varchar2_value

Line 749: l_language := hr_transaction_api.get_varchar2_value

745: l_dmethod := hr_transaction_api.get_varchar2_value
746: (p_transaction_step_id => p_transaction_step_id
747: ,p_name => 'P_DMETHOD');
748:
749: l_language := hr_transaction_api.get_varchar2_value
750: (p_transaction_step_id => p_transaction_step_id
751: ,p_name => 'P_LANGUAGE');
752:
753: l_trndates := hr_transaction_api.get_varchar2_value

Line 753: l_trndates := hr_transaction_api.get_varchar2_value

749: l_language := hr_transaction_api.get_varchar2_value
750: (p_transaction_step_id => p_transaction_step_id
751: ,p_name => 'P_LANGUAGE');
752:
753: l_trndates := hr_transaction_api.get_varchar2_value
754: (p_transaction_step_id => p_transaction_step_id
755: ,p_name => 'P_TRNDATES');
756:
757:

Line 758: l_trnorgids := hr_transaction_api.get_varchar2_value

754: (p_transaction_step_id => p_transaction_step_id
755: ,p_name => 'P_TRNDATES');
756:
757:
758: l_trnorgids := hr_transaction_api.get_varchar2_value
759: (p_transaction_step_id => p_transaction_step_id
760: ,p_name => 'P_TRNORGIDS');
761:
762: l_trnorgnames := hr_transaction_api.get_varchar2_value

Line 762: l_trnorgnames := hr_transaction_api.get_varchar2_value

758: l_trnorgids := hr_transaction_api.get_varchar2_value
759: (p_transaction_step_id => p_transaction_step_id
760: ,p_name => 'P_TRNORGIDS');
761:
762: l_trnorgnames := hr_transaction_api.get_varchar2_value
763: (p_transaction_step_id => p_transaction_step_id
764: ,p_name => 'P_TRNORGNAMES');
765:
766: l_trncompids := hr_transaction_api.get_varchar2_value

Line 766: l_trncompids := hr_transaction_api.get_varchar2_value

762: l_trnorgnames := hr_transaction_api.get_varchar2_value
763: (p_transaction_step_id => p_transaction_step_id
764: ,p_name => 'P_TRNORGNAMES');
765:
766: l_trncompids := hr_transaction_api.get_varchar2_value
767: (p_transaction_step_id => p_transaction_step_id
768: ,p_name => 'P_TRNCOMPIDS');
769:
770: l_trncompnames := hr_transaction_api.get_varchar2_value

Line 770: l_trncompnames := hr_transaction_api.get_varchar2_value

766: l_trncompids := hr_transaction_api.get_varchar2_value
767: (p_transaction_step_id => p_transaction_step_id
768: ,p_name => 'P_TRNCOMPIDS');
769:
770: l_trncompnames := hr_transaction_api.get_varchar2_value
771: (p_transaction_step_id => p_transaction_step_id
772: ,p_name => 'P_TRNCOMPNAMES');
773:
774: --Bug 2509979

Line 775: l_trncompminlvl := hr_transaction_api.get_varchar2_value

771: (p_transaction_step_id => p_transaction_step_id
772: ,p_name => 'P_TRNCOMPNAMES');
773:
774: --Bug 2509979
775: l_trncompminlvl := hr_transaction_api.get_varchar2_value
776: (p_transaction_step_id => p_transaction_step_id
777: ,p_name => 'P_TRNCOMPMINLVL');
778:
779: l_trncompmaxlvl := hr_transaction_api.get_varchar2_value

Line 779: l_trncompmaxlvl := hr_transaction_api.get_varchar2_value

775: l_trncompminlvl := hr_transaction_api.get_varchar2_value
776: (p_transaction_step_id => p_transaction_step_id
777: ,p_name => 'P_TRNCOMPMINLVL');
778:
779: l_trncompmaxlvl := hr_transaction_api.get_varchar2_value
780: (p_transaction_step_id => p_transaction_step_id
781: ,p_name => 'P_TRNCOMPMAXLVL');
782: --Bug 2509979
783:

Line 784: l_criteria := hr_transaction_api.get_varchar2_value

780: (p_transaction_step_id => p_transaction_step_id
781: ,p_name => 'P_TRNCOMPMAXLVL');
782: --Bug 2509979
783:
784: l_criteria := hr_transaction_api.get_varchar2_value
785: (p_transaction_step_id => p_transaction_step_id
786: ,p_name => 'P_CRITERIA');
787:
788: l_oafunc := hr_transaction_api.get_varchar2_value

Line 788: l_oafunc := hr_transaction_api.get_varchar2_value

784: l_criteria := hr_transaction_api.get_varchar2_value
785: (p_transaction_step_id => p_transaction_step_id
786: ,p_name => 'P_CRITERIA');
787:
788: l_oafunc := hr_transaction_api.get_varchar2_value
789: (p_transaction_step_id => p_transaction_step_id
790: ,p_name => 'P_OAFUNC');
791:
792: l_processname := hr_transaction_api.get_varchar2_value

Line 792: l_processname := hr_transaction_api.get_varchar2_value

788: l_oafunc := hr_transaction_api.get_varchar2_value
789: (p_transaction_step_id => p_transaction_step_id
790: ,p_name => 'P_OAFUNC');
791:
792: l_processname := hr_transaction_api.get_varchar2_value
793: (p_transaction_step_id => p_transaction_step_id
794: ,p_name => 'P_PROCESSNAME');
795:
796: l_calledfrom := hr_transaction_api.get_varchar2_value

Line 796: l_calledfrom := hr_transaction_api.get_varchar2_value

792: l_processname := hr_transaction_api.get_varchar2_value
793: (p_transaction_step_id => p_transaction_step_id
794: ,p_name => 'P_PROCESSNAME');
795:
796: l_calledfrom := hr_transaction_api.get_varchar2_value
797: (p_transaction_step_id => p_transaction_step_id
798: ,p_name => 'P_CALLEDFROM');
799:
800: l_frommenu := hr_transaction_api.get_varchar2_value

Line 800: l_frommenu := hr_transaction_api.get_varchar2_value

796: l_calledfrom := hr_transaction_api.get_varchar2_value
797: (p_transaction_step_id => p_transaction_step_id
798: ,p_name => 'P_CALLEDFROM');
799:
800: l_frommenu := hr_transaction_api.get_varchar2_value
801: (p_transaction_step_id => p_transaction_step_id
802: ,p_name => 'P_FROMMENU');
803: --
804: -- Now string all the retreived items into p_adv_search_data

Line 849: hr_transaction_api.get_transaction_step_info

845:
846:
847: BEGIN
848:
849: hr_transaction_api.get_transaction_step_info
850: (p_item_type => p_item_type
851: ,p_item_key => p_item_key
852: ,p_activity_id => p_activity_id
853: ,p_transaction_step_id => l_trans_step_ids

Line 917: l_eventid := hr_transaction_api.get_varchar2_value

913:
914: begin
915:
916:
917: l_eventid := hr_transaction_api.get_varchar2_value
918: (p_transaction_step_id => p_transaction_step_id
919: ,p_name => 'P_EVENTID');
920:
921: l_activityversionid := hr_transaction_api.get_varchar2_value

Line 921: l_activityversionid := hr_transaction_api.get_varchar2_value

917: l_eventid := hr_transaction_api.get_varchar2_value
918: (p_transaction_step_id => p_transaction_step_id
919: ,p_name => 'P_EVENTID');
920:
921: l_activityversionid := hr_transaction_api.get_varchar2_value
922: (p_transaction_step_id => p_transaction_step_id
923: ,p_name => 'P_ACTIVITYVERSIONID');
924:
925: l_specialInstruction := hr_transaction_api.get_varchar2_value

Line 925: l_specialInstruction := hr_transaction_api.get_varchar2_value

921: l_activityversionid := hr_transaction_api.get_varchar2_value
922: (p_transaction_step_id => p_transaction_step_id
923: ,p_name => 'P_ACTIVITYVERSIONID');
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_businessgroupid := hr_transaction_api.get_varchar2_value

Line 933: l_businessgroupid := 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_businessgroupid := hr_transaction_api.get_varchar2_value
934: (p_transaction_step_id => p_transaction_step_id
935: ,p_name => 'P_BUSINESSGROUPID');
936:
937: l_assignmentid := hr_transaction_api.get_varchar2_value

Line 937: l_assignmentid := hr_transaction_api.get_varchar2_value

933: l_businessgroupid := hr_transaction_api.get_varchar2_value
934: (p_transaction_step_id => p_transaction_step_id
935: ,p_name => 'P_BUSINESSGROUPID');
936:
937: l_assignmentid := hr_transaction_api.get_varchar2_value
938: (p_transaction_step_id => p_transaction_step_id
939: ,p_name => 'P_ASSIGNMENTID');
940:
941: l_organizationid := hr_transaction_api.get_varchar2_value

Line 941: l_organizationid := hr_transaction_api.get_varchar2_value

937: l_assignmentid := hr_transaction_api.get_varchar2_value
938: (p_transaction_step_id => p_transaction_step_id
939: ,p_name => 'P_ASSIGNMENTID');
940:
941: l_organizationid := hr_transaction_api.get_varchar2_value
942: (p_transaction_step_id => p_transaction_step_id
943: ,p_name => 'P_ORGANIZATIONID');
944:
945: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 945: l_tdb_information_category := hr_transaction_api.get_varchar2_value

941: l_organizationid := hr_transaction_api.get_varchar2_value
942: (p_transaction_step_id => p_transaction_step_id
943: ,p_name => 'P_ORGANIZATIONID');
944:
945: l_tdb_information_category := hr_transaction_api.get_varchar2_value
946: (p_transaction_step_id => p_transaction_step_id
947: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
948:
949: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 949: l_tdb_information1 := hr_transaction_api.get_varchar2_value

945: l_tdb_information_category := hr_transaction_api.get_varchar2_value
946: (p_transaction_step_id => p_transaction_step_id
947: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
948:
949: l_tdb_information1 := hr_transaction_api.get_varchar2_value
950: (p_transaction_step_id => p_transaction_step_id
951: ,p_name => 'P_TDB_INFORMATION1');
952:
953: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 953: l_tdb_information2 := hr_transaction_api.get_varchar2_value

949: l_tdb_information1 := hr_transaction_api.get_varchar2_value
950: (p_transaction_step_id => p_transaction_step_id
951: ,p_name => 'P_TDB_INFORMATION1');
952:
953: l_tdb_information2 := hr_transaction_api.get_varchar2_value
954: (p_transaction_step_id => p_transaction_step_id
955: ,p_name => 'P_TDB_INFORMATION2');
956:
957: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 957: l_tdb_information3 := hr_transaction_api.get_varchar2_value

953: l_tdb_information2 := hr_transaction_api.get_varchar2_value
954: (p_transaction_step_id => p_transaction_step_id
955: ,p_name => 'P_TDB_INFORMATION2');
956:
957: l_tdb_information3 := hr_transaction_api.get_varchar2_value
958: (p_transaction_step_id => p_transaction_step_id
959: ,p_name => 'P_TDB_INFORMATION3');
960:
961: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 961: l_tdb_information4 := hr_transaction_api.get_varchar2_value

957: l_tdb_information3 := hr_transaction_api.get_varchar2_value
958: (p_transaction_step_id => p_transaction_step_id
959: ,p_name => 'P_TDB_INFORMATION3');
960:
961: l_tdb_information4 := hr_transaction_api.get_varchar2_value
962: (p_transaction_step_id => p_transaction_step_id
963: ,p_name => 'P_TDB_INFORMATION4');
964:
965: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 965: l_tdb_information5 := hr_transaction_api.get_varchar2_value

961: l_tdb_information4 := hr_transaction_api.get_varchar2_value
962: (p_transaction_step_id => p_transaction_step_id
963: ,p_name => 'P_TDB_INFORMATION4');
964:
965: l_tdb_information5 := hr_transaction_api.get_varchar2_value
966: (p_transaction_step_id => p_transaction_step_id
967: ,p_name => 'P_TDB_INFORMATION5');
968:
969: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 969: l_tdb_information6 := hr_transaction_api.get_varchar2_value

965: l_tdb_information5 := hr_transaction_api.get_varchar2_value
966: (p_transaction_step_id => p_transaction_step_id
967: ,p_name => 'P_TDB_INFORMATION5');
968:
969: l_tdb_information6 := hr_transaction_api.get_varchar2_value
970: (p_transaction_step_id => p_transaction_step_id
971: ,p_name => 'P_TDB_INFORMATION6');
972:
973: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 973: l_tdb_information7 := hr_transaction_api.get_varchar2_value

969: l_tdb_information6 := hr_transaction_api.get_varchar2_value
970: (p_transaction_step_id => p_transaction_step_id
971: ,p_name => 'P_TDB_INFORMATION6');
972:
973: l_tdb_information7 := hr_transaction_api.get_varchar2_value
974: (p_transaction_step_id => p_transaction_step_id
975: ,p_name => 'P_TDB_INFORMATION7');
976:
977: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 977: l_tdb_information8 := hr_transaction_api.get_varchar2_value

973: l_tdb_information7 := hr_transaction_api.get_varchar2_value
974: (p_transaction_step_id => p_transaction_step_id
975: ,p_name => 'P_TDB_INFORMATION7');
976:
977: l_tdb_information8 := hr_transaction_api.get_varchar2_value
978: (p_transaction_step_id => p_transaction_step_id
979: ,p_name => 'P_TDB_INFORMATION8');
980:
981: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 981: l_tdb_information9 := hr_transaction_api.get_varchar2_value

977: l_tdb_information8 := hr_transaction_api.get_varchar2_value
978: (p_transaction_step_id => p_transaction_step_id
979: ,p_name => 'P_TDB_INFORMATION8');
980:
981: l_tdb_information9 := hr_transaction_api.get_varchar2_value
982: (p_transaction_step_id => p_transaction_step_id
983: ,p_name => 'P_TDB_INFORMATION9');
984:
985: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 985: l_tdb_information10 := hr_transaction_api.get_varchar2_value

981: l_tdb_information9 := hr_transaction_api.get_varchar2_value
982: (p_transaction_step_id => p_transaction_step_id
983: ,p_name => 'P_TDB_INFORMATION9');
984:
985: l_tdb_information10 := hr_transaction_api.get_varchar2_value
986: (p_transaction_step_id => p_transaction_step_id
987: ,p_name => 'P_TDB_INFORMATION10');
988:
989: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 989: l_tdb_information11 := hr_transaction_api.get_varchar2_value

985: l_tdb_information10 := hr_transaction_api.get_varchar2_value
986: (p_transaction_step_id => p_transaction_step_id
987: ,p_name => 'P_TDB_INFORMATION10');
988:
989: l_tdb_information11 := hr_transaction_api.get_varchar2_value
990: (p_transaction_step_id => p_transaction_step_id
991: ,p_name => 'P_TDB_INFORMATION11');
992:
993: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 993: l_tdb_information12 := hr_transaction_api.get_varchar2_value

989: l_tdb_information11 := hr_transaction_api.get_varchar2_value
990: (p_transaction_step_id => p_transaction_step_id
991: ,p_name => 'P_TDB_INFORMATION11');
992:
993: l_tdb_information12 := hr_transaction_api.get_varchar2_value
994: (p_transaction_step_id => p_transaction_step_id
995: ,p_name => 'P_TDB_INFORMATION12');
996:
997: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 997: l_tdb_information13 := hr_transaction_api.get_varchar2_value

993: l_tdb_information12 := hr_transaction_api.get_varchar2_value
994: (p_transaction_step_id => p_transaction_step_id
995: ,p_name => 'P_TDB_INFORMATION12');
996:
997: l_tdb_information13 := hr_transaction_api.get_varchar2_value
998: (p_transaction_step_id => p_transaction_step_id
999: ,p_name => 'P_TDB_INFORMATION13');
1000:
1001: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 1001: l_tdb_information14 := hr_transaction_api.get_varchar2_value

997: l_tdb_information13 := hr_transaction_api.get_varchar2_value
998: (p_transaction_step_id => p_transaction_step_id
999: ,p_name => 'P_TDB_INFORMATION13');
1000:
1001: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1002: (p_transaction_step_id => p_transaction_step_id
1003: ,p_name => 'P_TDB_INFORMATION14');
1004:
1005: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 1005: l_tdb_information15 := hr_transaction_api.get_varchar2_value

1001: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1002: (p_transaction_step_id => p_transaction_step_id
1003: ,p_name => 'P_TDB_INFORMATION14');
1004:
1005: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1006: (p_transaction_step_id => p_transaction_step_id
1007: ,p_name => 'P_TDB_INFORMATION15');
1008:
1009: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 1009: l_tdb_information16 := hr_transaction_api.get_varchar2_value

1005: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1006: (p_transaction_step_id => p_transaction_step_id
1007: ,p_name => 'P_TDB_INFORMATION15');
1008:
1009: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1010: (p_transaction_step_id => p_transaction_step_id
1011: ,p_name => 'P_TDB_INFORMATION16');
1012:
1013: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 1013: l_tdb_information17 := hr_transaction_api.get_varchar2_value

1009: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1010: (p_transaction_step_id => p_transaction_step_id
1011: ,p_name => 'P_TDB_INFORMATION16');
1012:
1013: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1014: (p_transaction_step_id => p_transaction_step_id
1015: ,p_name => 'P_TDB_INFORMATION17');
1016:
1017: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 1017: l_tdb_information18 := hr_transaction_api.get_varchar2_value

1013: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1014: (p_transaction_step_id => p_transaction_step_id
1015: ,p_name => 'P_TDB_INFORMATION17');
1016:
1017: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1018: (p_transaction_step_id => p_transaction_step_id
1019: ,p_name => 'P_TDB_INFORMATION18');
1020:
1021: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 1021: l_tdb_information19 := hr_transaction_api.get_varchar2_value

1017: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1018: (p_transaction_step_id => p_transaction_step_id
1019: ,p_name => 'P_TDB_INFORMATION18');
1020:
1021: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1022: (p_transaction_step_id => p_transaction_step_id
1023: ,p_name => 'P_TDB_INFORMATION19');
1024:
1025: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 1025: l_tdb_information20 := hr_transaction_api.get_varchar2_value

1021: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1022: (p_transaction_step_id => p_transaction_step_id
1023: ,p_name => 'P_TDB_INFORMATION19');
1024:
1025: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1026: (p_transaction_step_id => p_transaction_step_id
1027: ,p_name => 'P_TDB_INFORMATION20');
1028:
1029: l_oafunc := hr_transaction_api.get_varchar2_value

Line 1029: l_oafunc := hr_transaction_api.get_varchar2_value

1025: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1026: (p_transaction_step_id => p_transaction_step_id
1027: ,p_name => 'P_TDB_INFORMATION20');
1028:
1029: l_oafunc := hr_transaction_api.get_varchar2_value
1030: (p_transaction_step_id => p_transaction_step_id
1031: ,p_name => 'P_OAFUNC');
1032:
1033: l_processname := hr_transaction_api.get_varchar2_value

Line 1033: l_processname := hr_transaction_api.get_varchar2_value

1029: l_oafunc := hr_transaction_api.get_varchar2_value
1030: (p_transaction_step_id => p_transaction_step_id
1031: ,p_name => 'P_OAFUNC');
1032:
1033: l_processname := hr_transaction_api.get_varchar2_value
1034: (p_transaction_step_id => p_transaction_step_id
1035: ,p_name => 'P_PROCESSNAME');
1036:
1037: l_calledfrom := hr_transaction_api.get_varchar2_value

Line 1037: l_calledfrom := hr_transaction_api.get_varchar2_value

1033: l_processname := hr_transaction_api.get_varchar2_value
1034: (p_transaction_step_id => p_transaction_step_id
1035: ,p_name => 'P_PROCESSNAME');
1036:
1037: l_calledfrom := hr_transaction_api.get_varchar2_value
1038: (p_transaction_step_id => p_transaction_step_id
1039: ,p_name => 'P_CALLEDFROM');
1040:
1041: l_frommenu := hr_transaction_api.get_varchar2_value

Line 1041: l_frommenu := hr_transaction_api.get_varchar2_value

1037: l_calledfrom := hr_transaction_api.get_varchar2_value
1038: (p_transaction_step_id => p_transaction_step_id
1039: ,p_name => 'P_CALLEDFROM');
1040:
1041: l_frommenu := hr_transaction_api.get_varchar2_value
1042: (p_transaction_step_id => p_transaction_step_id
1043: ,p_name => 'P_FROMMENU');
1044:
1045: --

Line 1113: hr_transaction_api.get_transaction_step_info

1109:
1110:
1111: BEGIN
1112:
1113: hr_transaction_api.get_transaction_step_info
1114: (p_item_type => p_item_type
1115: ,p_item_key => p_item_key
1116: ,p_activity_id => p_activity_id
1117: ,p_transaction_step_id => l_trans_step_ids

Line 1174: l_eventid := hr_transaction_api.get_varchar2_value

1170:
1171: begin
1172:
1173:
1174: l_eventid := hr_transaction_api.get_varchar2_value
1175: (p_transaction_step_id => p_transaction_step_id
1176: ,p_name => 'P_EVENTID');
1177:
1178:

Line 1179: l_specialInstruction := hr_transaction_api.get_varchar2_value

1175: (p_transaction_step_id => p_transaction_step_id
1176: ,p_name => 'P_EVENTID');
1177:
1178:
1179: l_specialInstruction := hr_transaction_api.get_varchar2_value
1180: (p_transaction_step_id => p_transaction_step_id
1181: ,p_name => 'P_SPECIALINSTRUCTION');
1182:
1183: /* l_keyflexid := hr_transaction_api.get_varchar2_value

Line 1183: /* l_keyflexid := hr_transaction_api.get_varchar2_value

1179: l_specialInstruction := hr_transaction_api.get_varchar2_value
1180: (p_transaction_step_id => p_transaction_step_id
1181: ,p_name => 'P_SPECIALINSTRUCTION');
1182:
1183: /* l_keyflexid := hr_transaction_api.get_varchar2_value
1184: (p_transaction_step_id => p_transaction_step_id
1185: ,p_name => 'P_KEYFLEXID'); */
1186:
1187: l_ccselectiontext := hr_transaction_api.get_varchar2_value

Line 1187: l_ccselectiontext := hr_transaction_api.get_varchar2_value

1183: /* l_keyflexid := hr_transaction_api.get_varchar2_value
1184: (p_transaction_step_id => p_transaction_step_id
1185: ,p_name => 'P_KEYFLEXID'); */
1186:
1187: l_ccselectiontext := hr_transaction_api.get_varchar2_value
1188: (p_transaction_step_id => p_transaction_step_id
1189: ,p_name => 'P_CCSELECTIONTEXT');
1190:
1191: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 1191: l_tdb_information_category := hr_transaction_api.get_varchar2_value

1187: l_ccselectiontext := hr_transaction_api.get_varchar2_value
1188: (p_transaction_step_id => p_transaction_step_id
1189: ,p_name => 'P_CCSELECTIONTEXT');
1190:
1191: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1192: (p_transaction_step_id => p_transaction_step_id
1193: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1194:
1195: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 1195: l_tdb_information1 := hr_transaction_api.get_varchar2_value

1191: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1192: (p_transaction_step_id => p_transaction_step_id
1193: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1194:
1195: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1196: (p_transaction_step_id => p_transaction_step_id
1197: ,p_name => 'P_TDB_INFORMATION1');
1198:
1199: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 1199: l_tdb_information2 := hr_transaction_api.get_varchar2_value

1195: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1196: (p_transaction_step_id => p_transaction_step_id
1197: ,p_name => 'P_TDB_INFORMATION1');
1198:
1199: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1200: (p_transaction_step_id => p_transaction_step_id
1201: ,p_name => 'P_TDB_INFORMATION2');
1202:
1203: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 1203: l_tdb_information3 := hr_transaction_api.get_varchar2_value

1199: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1200: (p_transaction_step_id => p_transaction_step_id
1201: ,p_name => 'P_TDB_INFORMATION2');
1202:
1203: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1204: (p_transaction_step_id => p_transaction_step_id
1205: ,p_name => 'P_TDB_INFORMATION3');
1206:
1207: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 1207: l_tdb_information4 := hr_transaction_api.get_varchar2_value

1203: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1204: (p_transaction_step_id => p_transaction_step_id
1205: ,p_name => 'P_TDB_INFORMATION3');
1206:
1207: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1208: (p_transaction_step_id => p_transaction_step_id
1209: ,p_name => 'P_TDB_INFORMATION4');
1210:
1211: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 1211: l_tdb_information5 := hr_transaction_api.get_varchar2_value

1207: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1208: (p_transaction_step_id => p_transaction_step_id
1209: ,p_name => 'P_TDB_INFORMATION4');
1210:
1211: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1212: (p_transaction_step_id => p_transaction_step_id
1213: ,p_name => 'P_TDB_INFORMATION5');
1214:
1215: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 1215: l_tdb_information6 := hr_transaction_api.get_varchar2_value

1211: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1212: (p_transaction_step_id => p_transaction_step_id
1213: ,p_name => 'P_TDB_INFORMATION5');
1214:
1215: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1216: (p_transaction_step_id => p_transaction_step_id
1217: ,p_name => 'P_TDB_INFORMATION6');
1218:
1219: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 1219: l_tdb_information7 := hr_transaction_api.get_varchar2_value

1215: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1216: (p_transaction_step_id => p_transaction_step_id
1217: ,p_name => 'P_TDB_INFORMATION6');
1218:
1219: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1220: (p_transaction_step_id => p_transaction_step_id
1221: ,p_name => 'P_TDB_INFORMATION7');
1222:
1223: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 1223: l_tdb_information8 := hr_transaction_api.get_varchar2_value

1219: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1220: (p_transaction_step_id => p_transaction_step_id
1221: ,p_name => 'P_TDB_INFORMATION7');
1222:
1223: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1224: (p_transaction_step_id => p_transaction_step_id
1225: ,p_name => 'P_TDB_INFORMATION8');
1226:
1227: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 1227: l_tdb_information9 := hr_transaction_api.get_varchar2_value

1223: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1224: (p_transaction_step_id => p_transaction_step_id
1225: ,p_name => 'P_TDB_INFORMATION8');
1226:
1227: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1228: (p_transaction_step_id => p_transaction_step_id
1229: ,p_name => 'P_TDB_INFORMATION9');
1230:
1231: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 1231: l_tdb_information10 := hr_transaction_api.get_varchar2_value

1227: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1228: (p_transaction_step_id => p_transaction_step_id
1229: ,p_name => 'P_TDB_INFORMATION9');
1230:
1231: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1232: (p_transaction_step_id => p_transaction_step_id
1233: ,p_name => 'P_TDB_INFORMATION10');
1234:
1235: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 1235: l_tdb_information11 := hr_transaction_api.get_varchar2_value

1231: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1232: (p_transaction_step_id => p_transaction_step_id
1233: ,p_name => 'P_TDB_INFORMATION10');
1234:
1235: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1236: (p_transaction_step_id => p_transaction_step_id
1237: ,p_name => 'P_TDB_INFORMATION11');
1238:
1239: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 1239: l_tdb_information12 := hr_transaction_api.get_varchar2_value

1235: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1236: (p_transaction_step_id => p_transaction_step_id
1237: ,p_name => 'P_TDB_INFORMATION11');
1238:
1239: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1240: (p_transaction_step_id => p_transaction_step_id
1241: ,p_name => 'P_TDB_INFORMATION12');
1242:
1243: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 1243: l_tdb_information13 := hr_transaction_api.get_varchar2_value

1239: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1240: (p_transaction_step_id => p_transaction_step_id
1241: ,p_name => 'P_TDB_INFORMATION12');
1242:
1243: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1244: (p_transaction_step_id => p_transaction_step_id
1245: ,p_name => 'P_TDB_INFORMATION13');
1246:
1247: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 1247: l_tdb_information14 := hr_transaction_api.get_varchar2_value

1243: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1244: (p_transaction_step_id => p_transaction_step_id
1245: ,p_name => 'P_TDB_INFORMATION13');
1246:
1247: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1248: (p_transaction_step_id => p_transaction_step_id
1249: ,p_name => 'P_TDB_INFORMATION14');
1250:
1251: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 1251: l_tdb_information15 := hr_transaction_api.get_varchar2_value

1247: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1248: (p_transaction_step_id => p_transaction_step_id
1249: ,p_name => 'P_TDB_INFORMATION14');
1250:
1251: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1252: (p_transaction_step_id => p_transaction_step_id
1253: ,p_name => 'P_TDB_INFORMATION15');
1254:
1255: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 1255: l_tdb_information16 := hr_transaction_api.get_varchar2_value

1251: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1252: (p_transaction_step_id => p_transaction_step_id
1253: ,p_name => 'P_TDB_INFORMATION15');
1254:
1255: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1256: (p_transaction_step_id => p_transaction_step_id
1257: ,p_name => 'P_TDB_INFORMATION16');
1258:
1259: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 1259: l_tdb_information17 := hr_transaction_api.get_varchar2_value

1255: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1256: (p_transaction_step_id => p_transaction_step_id
1257: ,p_name => 'P_TDB_INFORMATION16');
1258:
1259: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1260: (p_transaction_step_id => p_transaction_step_id
1261: ,p_name => 'P_TDB_INFORMATION17');
1262:
1263: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 1263: l_tdb_information18 := hr_transaction_api.get_varchar2_value

1259: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1260: (p_transaction_step_id => p_transaction_step_id
1261: ,p_name => 'P_TDB_INFORMATION17');
1262:
1263: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1264: (p_transaction_step_id => p_transaction_step_id
1265: ,p_name => 'P_TDB_INFORMATION18');
1266:
1267: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 1267: l_tdb_information19 := hr_transaction_api.get_varchar2_value

1263: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1264: (p_transaction_step_id => p_transaction_step_id
1265: ,p_name => 'P_TDB_INFORMATION18');
1266:
1267: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1268: (p_transaction_step_id => p_transaction_step_id
1269: ,p_name => 'P_TDB_INFORMATION19');
1270:
1271: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 1271: l_tdb_information20 := hr_transaction_api.get_varchar2_value

1267: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1268: (p_transaction_step_id => p_transaction_step_id
1269: ,p_name => 'P_TDB_INFORMATION19');
1270:
1271: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1272: (p_transaction_step_id => p_transaction_step_id
1273: ,p_name => 'P_TDB_INFORMATION20');
1274:
1275: l_trnorgnames := hr_transaction_api.get_varchar2_value

Line 1275: l_trnorgnames := hr_transaction_api.get_varchar2_value

1271: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1272: (p_transaction_step_id => p_transaction_step_id
1273: ,p_name => 'P_TDB_INFORMATION20');
1274:
1275: l_trnorgnames := hr_transaction_api.get_varchar2_value
1276: (p_transaction_step_id => p_transaction_step_id
1277: ,p_name => 'P_TRNORGNAMES');
1278:
1279: --

Line 1483: l_from := hr_transaction_api.get_varchar2_value

1479: Employee_id = p_owner_id ;
1480:
1481: BEGIN
1482:
1483: l_from := hr_transaction_api.get_varchar2_value
1484: (p_transaction_step_id => p_transaction_step_id
1485: ,p_name => 'P_FROM');
1486:
1487: hr_transaction_api.get_transaction_step_info

Line 1487: hr_transaction_api.get_transaction_step_info

1483: l_from := hr_transaction_api.get_varchar2_value
1484: (p_transaction_step_id => p_transaction_step_id
1485: ,p_name => 'P_FROM');
1486:
1487: hr_transaction_api.get_transaction_step_info
1488: (p_transaction_step_id => p_transaction_step_id
1489: ,p_item_type => l_item_type
1490: ,p_item_key => l_item_key
1491: ,p_activity_id => l_activity_id);

Line 1498: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1494:
1495: -- establish Savepoint
1496: SAVEPOINT validate_enrollment;
1497:
1498: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1499: (p_transaction_step_id => p_transaction_step_id
1500: ,p_name => 'P_EVENTID'));
1501:
1502:

Line 1504: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1500: ,p_name => 'P_EVENTID'));
1501:
1502:
1503: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
1504: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1505: (p_transaction_step_id => p_transaction_step_id
1506: -- ,p_name => 'P_PERSON_ID'));
1507: ,p_name => 'P_DELEGATE_PERSON_ID'));
1508:

Line 1510: l_specialInstruction := hr_transaction_api.get_varchar2_value

1506: -- ,p_name => 'P_PERSON_ID'));
1507: ,p_name => 'P_DELEGATE_PERSON_ID'));
1508:
1509:
1510: l_specialInstruction := hr_transaction_api.get_varchar2_value
1511: (p_transaction_step_id => p_transaction_step_id
1512: ,p_name => 'P_SPECIALINSTRUCTION');
1513:
1514: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 1514: l_tdb_information_category := hr_transaction_api.get_varchar2_value

1510: l_specialInstruction := hr_transaction_api.get_varchar2_value
1511: (p_transaction_step_id => p_transaction_step_id
1512: ,p_name => 'P_SPECIALINSTRUCTION');
1513:
1514: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1515: (p_transaction_step_id => p_transaction_step_id
1516: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1517:
1518: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 1518: l_tdb_information1 := hr_transaction_api.get_varchar2_value

1514: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1515: (p_transaction_step_id => p_transaction_step_id
1516: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1517:
1518: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1519: (p_transaction_step_id => p_transaction_step_id
1520: ,p_name => 'P_TDB_INFORMATION1');
1521:
1522: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 1522: l_tdb_information2 := hr_transaction_api.get_varchar2_value

1518: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1519: (p_transaction_step_id => p_transaction_step_id
1520: ,p_name => 'P_TDB_INFORMATION1');
1521:
1522: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1523: (p_transaction_step_id => p_transaction_step_id
1524: ,p_name => 'P_TDB_INFORMATION2');
1525:
1526: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 1526: l_tdb_information3 := hr_transaction_api.get_varchar2_value

1522: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1523: (p_transaction_step_id => p_transaction_step_id
1524: ,p_name => 'P_TDB_INFORMATION2');
1525:
1526: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1527: (p_transaction_step_id => p_transaction_step_id
1528: ,p_name => 'P_TDB_INFORMATION3');
1529:
1530: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 1530: l_tdb_information4 := hr_transaction_api.get_varchar2_value

1526: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1527: (p_transaction_step_id => p_transaction_step_id
1528: ,p_name => 'P_TDB_INFORMATION3');
1529:
1530: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1531: (p_transaction_step_id => p_transaction_step_id
1532: ,p_name => 'P_TDB_INFORMATION4');
1533:
1534: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 1534: l_tdb_information5 := hr_transaction_api.get_varchar2_value

1530: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1531: (p_transaction_step_id => p_transaction_step_id
1532: ,p_name => 'P_TDB_INFORMATION4');
1533:
1534: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1535: (p_transaction_step_id => p_transaction_step_id
1536: ,p_name => 'P_TDB_INFORMATION5');
1537:
1538: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 1538: l_tdb_information6 := hr_transaction_api.get_varchar2_value

1534: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1535: (p_transaction_step_id => p_transaction_step_id
1536: ,p_name => 'P_TDB_INFORMATION5');
1537:
1538: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1539: (p_transaction_step_id => p_transaction_step_id
1540: ,p_name => 'P_TDB_INFORMATION6');
1541:
1542: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 1542: l_tdb_information7 := hr_transaction_api.get_varchar2_value

1538: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1539: (p_transaction_step_id => p_transaction_step_id
1540: ,p_name => 'P_TDB_INFORMATION6');
1541:
1542: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1543: (p_transaction_step_id => p_transaction_step_id
1544: ,p_name => 'P_TDB_INFORMATION7');
1545:
1546: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 1546: l_tdb_information8 := hr_transaction_api.get_varchar2_value

1542: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1543: (p_transaction_step_id => p_transaction_step_id
1544: ,p_name => 'P_TDB_INFORMATION7');
1545:
1546: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1547: (p_transaction_step_id => p_transaction_step_id
1548: ,p_name => 'P_TDB_INFORMATION8');
1549:
1550: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 1550: l_tdb_information9 := hr_transaction_api.get_varchar2_value

1546: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1547: (p_transaction_step_id => p_transaction_step_id
1548: ,p_name => 'P_TDB_INFORMATION8');
1549:
1550: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1551: (p_transaction_step_id => p_transaction_step_id
1552: ,p_name => 'P_TDB_INFORMATION9');
1553:
1554: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 1554: l_tdb_information10 := hr_transaction_api.get_varchar2_value

1550: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1551: (p_transaction_step_id => p_transaction_step_id
1552: ,p_name => 'P_TDB_INFORMATION9');
1553:
1554: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1555: (p_transaction_step_id => p_transaction_step_id
1556: ,p_name => 'P_TDB_INFORMATION10');
1557:
1558: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 1558: l_tdb_information11 := hr_transaction_api.get_varchar2_value

1554: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1555: (p_transaction_step_id => p_transaction_step_id
1556: ,p_name => 'P_TDB_INFORMATION10');
1557:
1558: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1559: (p_transaction_step_id => p_transaction_step_id
1560: ,p_name => 'P_TDB_INFORMATION11');
1561:
1562: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 1562: l_tdb_information12 := hr_transaction_api.get_varchar2_value

1558: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1559: (p_transaction_step_id => p_transaction_step_id
1560: ,p_name => 'P_TDB_INFORMATION11');
1561:
1562: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1563: (p_transaction_step_id => p_transaction_step_id
1564: ,p_name => 'P_TDB_INFORMATION12');
1565:
1566: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 1566: l_tdb_information13 := hr_transaction_api.get_varchar2_value

1562: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1563: (p_transaction_step_id => p_transaction_step_id
1564: ,p_name => 'P_TDB_INFORMATION12');
1565:
1566: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1567: (p_transaction_step_id => p_transaction_step_id
1568: ,p_name => 'P_TDB_INFORMATION13');
1569:
1570: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 1570: l_tdb_information14 := hr_transaction_api.get_varchar2_value

1566: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1567: (p_transaction_step_id => p_transaction_step_id
1568: ,p_name => 'P_TDB_INFORMATION13');
1569:
1570: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1571: (p_transaction_step_id => p_transaction_step_id
1572: ,p_name => 'P_TDB_INFORMATION14');
1573:
1574: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 1574: l_tdb_information15 := hr_transaction_api.get_varchar2_value

1570: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1571: (p_transaction_step_id => p_transaction_step_id
1572: ,p_name => 'P_TDB_INFORMATION14');
1573:
1574: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1575: (p_transaction_step_id => p_transaction_step_id
1576: ,p_name => 'P_TDB_INFORMATION15');
1577:
1578: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 1578: l_tdb_information16 := hr_transaction_api.get_varchar2_value

1574: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1575: (p_transaction_step_id => p_transaction_step_id
1576: ,p_name => 'P_TDB_INFORMATION15');
1577:
1578: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1579: (p_transaction_step_id => p_transaction_step_id
1580: ,p_name => 'P_TDB_INFORMATION16');
1581:
1582: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 1582: l_tdb_information17 := hr_transaction_api.get_varchar2_value

1578: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1579: (p_transaction_step_id => p_transaction_step_id
1580: ,p_name => 'P_TDB_INFORMATION16');
1581:
1582: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1583: (p_transaction_step_id => p_transaction_step_id
1584: ,p_name => 'P_TDB_INFORMATION17');
1585:
1586: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 1586: l_tdb_information18 := hr_transaction_api.get_varchar2_value

1582: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1583: (p_transaction_step_id => p_transaction_step_id
1584: ,p_name => 'P_TDB_INFORMATION17');
1585:
1586: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1587: (p_transaction_step_id => p_transaction_step_id
1588: ,p_name => 'P_TDB_INFORMATION18');
1589:
1590: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 1590: l_tdb_information19 := hr_transaction_api.get_varchar2_value

1586: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1587: (p_transaction_step_id => p_transaction_step_id
1588: ,p_name => 'P_TDB_INFORMATION18');
1589:
1590: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1591: (p_transaction_step_id => p_transaction_step_id
1592: ,p_name => 'P_TDB_INFORMATION19');
1593:
1594: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 1594: l_tdb_information20 := hr_transaction_api.get_varchar2_value

1590: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1591: (p_transaction_step_id => p_transaction_step_id
1592: ,p_name => 'P_TDB_INFORMATION19');
1593:
1594: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1595: (p_transaction_step_id => p_transaction_step_id
1596: ,p_name => 'P_TDB_INFORMATION20');
1597:
1598:

Line 1859: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1855: end if;
1856:
1857: ELSIF l_from = 'APPROVE' then -- update enrollment and create finance line if profile is set to YES
1858:
1859: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1860: (p_transaction_step_id => p_transaction_step_id
1861: ,p_name => 'P_EVENTID'));
1862:
1863:

Line 1865: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1861: ,p_name => 'P_EVENTID'));
1862:
1863:
1864: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
1865: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1866: (p_transaction_step_id => p_transaction_step_id
1867: -- ,p_name => 'P_PERSON_ID'));
1868: ,p_name => 'P_DELEGATE_PERSON_ID'));
1869:

Line 1970: l_cost_allocation_keyflex_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1966: IF l_auto_create_finance = 'Y' and
1967: l_price_basis <> 'N' and
1968: l_event_currency_code is not null THEN
1969:
1970: l_cost_allocation_keyflex_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1971: (p_transaction_step_id => p_transaction_step_id
1972: ,p_name => 'P_KEYFLEXID'));
1973:
1974:

Line 1975: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value

1971: (p_transaction_step_id => p_transaction_step_id
1972: ,p_name => 'P_KEYFLEXID'));
1973:
1974:
1975: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value
1976: (p_transaction_step_id => p_transaction_step_id
1977: ,p_name => 'P_BUSINESSGROUPID'));
1978:
1979: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

Line 1979: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1975: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value
1976: (p_transaction_step_id => p_transaction_step_id
1977: ,p_name => 'P_BUSINESSGROUPID'));
1978:
1979: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1980: (p_transaction_step_id => p_transaction_step_id
1981: ,p_name => 'P_ASSIGNMENTID'));
1982:
1983: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

Line 1983: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1979: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1980: (p_transaction_step_id => p_transaction_step_id
1981: ,p_name => 'P_ASSIGNMENTID'));
1982:
1983: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1984: (p_transaction_step_id => p_transaction_step_id
1985: ,p_name => 'P_ORGANIZATIONID'));
1986:
1987: -- --------------------------------------------

Line 2294: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

2290:
2291: if ( funmode = 'RUN' ) then
2292:
2293: /* Bug#2258423 hdshah read event id from workflow instead of transaction table
2294: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
2295: (p_transaction_step_id => l_transaction_step_id
2296: ,p_name => 'P_EVENTID'));
2297: */
2298:

Line 2305: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

2301: ,aname => 'OTA_EVENT_ID');
2302:
2303: /* Bug#2258423 hdshah read delegate person id from workflow instead of transaction table
2304: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
2305: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
2306: (p_transaction_step_id => l_transaction_step_id
2307: -- ,p_name => 'P_PERSON_ID'));
2308: ,p_name => 'P_DELEGATE_PERSON_ID'));
2309: */

Line 2375: hr_transaction_api.get_transaction_step_info

2371: ,itemkey => p_item_key
2372: ,aname => 'OTA_TRANSACTION_STEP_ID');
2373:
2374: -- Code added for Bug#2782175
2375: hr_transaction_api.get_transaction_step_info
2376: (p_transaction_step_id => l_transaction_step_id
2377: ,p_item_type => l_dummy_item_type
2378: ,p_item_key => l_dummy_item_key
2379: ,p_activity_id => l_activity_id);

Line 2389: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

2385: aname => 'HR_APPROVAL_REQ_FLAG');
2386:
2387: if l_approval_mode = 'YES_DYNAMIC' then
2388:
2389: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
2390: (p_transaction_step_id => l_transaction_step_id
2391: ,p_name => 'P_EVENTID'));
2392:
2393: hr_approval_wf.create_item_attrib_if_notexist