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

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

142: --
143: -- Delete transaction step if exist
144: --
145:
146: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
147: ,p_item_key => p_item_key
148: ,p_activity_id => p_activity_id) ) then
149:
150: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

Line 150: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

146: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
147: ,p_item_key => p_item_key
148: ,p_activity_id => p_activity_id) ) then
149:
150: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type
151: ,p_item_key => p_item_key
152: ,p_activity_id => p_activity_id
153: ,p_transaction_step_id => l_old_transaction_step_id
154: ,p_object_version_number => l_old_object_version_number);

Line 157: hr_transaction_api.delete_transaction_step(p_validate => false

153: ,p_transaction_step_id => l_old_transaction_step_id
154: ,p_object_version_number => l_old_object_version_number);
155:
156:
157: hr_transaction_api.delete_transaction_step(p_validate => false
158: ,p_transaction_step_id => l_old_transaction_step_id
159: ,p_person_id => p_login_person_id
160: ,p_object_version_number => l_old_object_version_number);
161:

Line 167: hr_transaction_api.create_transaction_step

163:
164: --
165: -- Create a transaction step
166: --
167: hr_transaction_api.create_transaction_step
168: (p_validate => false
169: ,p_creator_person_id => p_login_person_id
170: ,p_transaction_id => l_transaction_id
171: ,p_api_name => g_package || '.PROCESS_API2'

Line 453: hr_transaction_api.get_transaction_step_info

449:
450:
451: BEGIN
452:
453: hr_transaction_api.get_transaction_step_info
454: (p_item_type => p_item_type
455: ,p_item_key => p_item_key
456: ,p_activity_id => p_activity_id
457: ,p_transaction_step_id => l_trans_step_ids

Line 519: l_eventid := hr_transaction_api.get_varchar2_value

515: l_booking_justification ota_bkng_justifications_tl.justification_text%TYPE;
516: begin
517:
518:
519: l_eventid := hr_transaction_api.get_varchar2_value
520: (p_transaction_step_id => p_transaction_step_id
521: ,p_name => 'P_EVENTID');
522:
523: l_activityversionid := hr_transaction_api.get_varchar2_value

Line 523: l_activityversionid := hr_transaction_api.get_varchar2_value

519: l_eventid := hr_transaction_api.get_varchar2_value
520: (p_transaction_step_id => p_transaction_step_id
521: ,p_name => 'P_EVENTID');
522:
523: l_activityversionid := hr_transaction_api.get_varchar2_value
524: (p_transaction_step_id => p_transaction_step_id
525: ,p_name => 'P_ACTIVITYVERSIONID');
526:
527: l_specialInstruction := hr_transaction_api.get_varchar2_value

Line 527: l_specialInstruction := hr_transaction_api.get_varchar2_value

523: l_activityversionid := hr_transaction_api.get_varchar2_value
524: (p_transaction_step_id => p_transaction_step_id
525: ,p_name => 'P_ACTIVITYVERSIONID');
526:
527: l_specialInstruction := hr_transaction_api.get_varchar2_value
528: (p_transaction_step_id => p_transaction_step_id
529: ,p_name => 'P_SPECIALINSTRUCTION');
530:
531: l_keyflexid := hr_transaction_api.get_varchar2_value

Line 531: l_keyflexid := hr_transaction_api.get_varchar2_value

527: l_specialInstruction := hr_transaction_api.get_varchar2_value
528: (p_transaction_step_id => p_transaction_step_id
529: ,p_name => 'P_SPECIALINSTRUCTION');
530:
531: l_keyflexid := hr_transaction_api.get_varchar2_value
532: (p_transaction_step_id => p_transaction_step_id
533: ,p_name => 'P_KEYFLEXID');
534:
535: l_businessgroupid := hr_transaction_api.get_varchar2_value

Line 535: l_businessgroupid := hr_transaction_api.get_varchar2_value

531: l_keyflexid := hr_transaction_api.get_varchar2_value
532: (p_transaction_step_id => p_transaction_step_id
533: ,p_name => 'P_KEYFLEXID');
534:
535: l_businessgroupid := hr_transaction_api.get_varchar2_value
536: (p_transaction_step_id => p_transaction_step_id
537: ,p_name => 'P_BUSINESSGROUPID');
538:
539: l_assignmentid := hr_transaction_api.get_varchar2_value

Line 539: l_assignmentid := hr_transaction_api.get_varchar2_value

535: l_businessgroupid := hr_transaction_api.get_varchar2_value
536: (p_transaction_step_id => p_transaction_step_id
537: ,p_name => 'P_BUSINESSGROUPID');
538:
539: l_assignmentid := hr_transaction_api.get_varchar2_value
540: (p_transaction_step_id => p_transaction_step_id
541: ,p_name => 'P_ASSIGNMENTID');
542:
543: l_organizationid := hr_transaction_api.get_varchar2_value

Line 543: l_organizationid := hr_transaction_api.get_varchar2_value

539: l_assignmentid := hr_transaction_api.get_varchar2_value
540: (p_transaction_step_id => p_transaction_step_id
541: ,p_name => 'P_ASSIGNMENTID');
542:
543: l_organizationid := hr_transaction_api.get_varchar2_value
544: (p_transaction_step_id => p_transaction_step_id
545: ,p_name => 'P_ORGANIZATIONID');
546:
547: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 547: l_tdb_information_category := hr_transaction_api.get_varchar2_value

543: l_organizationid := hr_transaction_api.get_varchar2_value
544: (p_transaction_step_id => p_transaction_step_id
545: ,p_name => 'P_ORGANIZATIONID');
546:
547: l_tdb_information_category := hr_transaction_api.get_varchar2_value
548: (p_transaction_step_id => p_transaction_step_id
549: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
550:
551: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 551: l_tdb_information1 := hr_transaction_api.get_varchar2_value

547: l_tdb_information_category := hr_transaction_api.get_varchar2_value
548: (p_transaction_step_id => p_transaction_step_id
549: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
550:
551: l_tdb_information1 := hr_transaction_api.get_varchar2_value
552: (p_transaction_step_id => p_transaction_step_id
553: ,p_name => 'P_TDB_INFORMATION1');
554:
555: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 555: l_tdb_information2 := hr_transaction_api.get_varchar2_value

551: l_tdb_information1 := hr_transaction_api.get_varchar2_value
552: (p_transaction_step_id => p_transaction_step_id
553: ,p_name => 'P_TDB_INFORMATION1');
554:
555: l_tdb_information2 := hr_transaction_api.get_varchar2_value
556: (p_transaction_step_id => p_transaction_step_id
557: ,p_name => 'P_TDB_INFORMATION2');
558:
559: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 559: l_tdb_information3 := hr_transaction_api.get_varchar2_value

555: l_tdb_information2 := hr_transaction_api.get_varchar2_value
556: (p_transaction_step_id => p_transaction_step_id
557: ,p_name => 'P_TDB_INFORMATION2');
558:
559: l_tdb_information3 := hr_transaction_api.get_varchar2_value
560: (p_transaction_step_id => p_transaction_step_id
561: ,p_name => 'P_TDB_INFORMATION3');
562:
563: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 563: l_tdb_information4 := hr_transaction_api.get_varchar2_value

559: l_tdb_information3 := hr_transaction_api.get_varchar2_value
560: (p_transaction_step_id => p_transaction_step_id
561: ,p_name => 'P_TDB_INFORMATION3');
562:
563: l_tdb_information4 := hr_transaction_api.get_varchar2_value
564: (p_transaction_step_id => p_transaction_step_id
565: ,p_name => 'P_TDB_INFORMATION4');
566:
567: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 567: l_tdb_information5 := hr_transaction_api.get_varchar2_value

563: l_tdb_information4 := hr_transaction_api.get_varchar2_value
564: (p_transaction_step_id => p_transaction_step_id
565: ,p_name => 'P_TDB_INFORMATION4');
566:
567: l_tdb_information5 := hr_transaction_api.get_varchar2_value
568: (p_transaction_step_id => p_transaction_step_id
569: ,p_name => 'P_TDB_INFORMATION5');
570:
571: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 571: l_tdb_information6 := hr_transaction_api.get_varchar2_value

567: l_tdb_information5 := hr_transaction_api.get_varchar2_value
568: (p_transaction_step_id => p_transaction_step_id
569: ,p_name => 'P_TDB_INFORMATION5');
570:
571: l_tdb_information6 := hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id => p_transaction_step_id
573: ,p_name => 'P_TDB_INFORMATION6');
574:
575: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 575: l_tdb_information7 := hr_transaction_api.get_varchar2_value

571: l_tdb_information6 := hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id => p_transaction_step_id
573: ,p_name => 'P_TDB_INFORMATION6');
574:
575: l_tdb_information7 := hr_transaction_api.get_varchar2_value
576: (p_transaction_step_id => p_transaction_step_id
577: ,p_name => 'P_TDB_INFORMATION7');
578:
579: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 579: l_tdb_information8 := hr_transaction_api.get_varchar2_value

575: l_tdb_information7 := hr_transaction_api.get_varchar2_value
576: (p_transaction_step_id => p_transaction_step_id
577: ,p_name => 'P_TDB_INFORMATION7');
578:
579: l_tdb_information8 := hr_transaction_api.get_varchar2_value
580: (p_transaction_step_id => p_transaction_step_id
581: ,p_name => 'P_TDB_INFORMATION8');
582:
583: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 583: l_tdb_information9 := hr_transaction_api.get_varchar2_value

579: l_tdb_information8 := hr_transaction_api.get_varchar2_value
580: (p_transaction_step_id => p_transaction_step_id
581: ,p_name => 'P_TDB_INFORMATION8');
582:
583: l_tdb_information9 := hr_transaction_api.get_varchar2_value
584: (p_transaction_step_id => p_transaction_step_id
585: ,p_name => 'P_TDB_INFORMATION9');
586:
587: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 587: l_tdb_information10 := hr_transaction_api.get_varchar2_value

583: l_tdb_information9 := hr_transaction_api.get_varchar2_value
584: (p_transaction_step_id => p_transaction_step_id
585: ,p_name => 'P_TDB_INFORMATION9');
586:
587: l_tdb_information10 := hr_transaction_api.get_varchar2_value
588: (p_transaction_step_id => p_transaction_step_id
589: ,p_name => 'P_TDB_INFORMATION10');
590:
591: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 591: l_tdb_information11 := hr_transaction_api.get_varchar2_value

587: l_tdb_information10 := hr_transaction_api.get_varchar2_value
588: (p_transaction_step_id => p_transaction_step_id
589: ,p_name => 'P_TDB_INFORMATION10');
590:
591: l_tdb_information11 := hr_transaction_api.get_varchar2_value
592: (p_transaction_step_id => p_transaction_step_id
593: ,p_name => 'P_TDB_INFORMATION11');
594:
595: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 595: l_tdb_information12 := hr_transaction_api.get_varchar2_value

591: l_tdb_information11 := hr_transaction_api.get_varchar2_value
592: (p_transaction_step_id => p_transaction_step_id
593: ,p_name => 'P_TDB_INFORMATION11');
594:
595: l_tdb_information12 := hr_transaction_api.get_varchar2_value
596: (p_transaction_step_id => p_transaction_step_id
597: ,p_name => 'P_TDB_INFORMATION12');
598:
599: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 599: l_tdb_information13 := hr_transaction_api.get_varchar2_value

595: l_tdb_information12 := hr_transaction_api.get_varchar2_value
596: (p_transaction_step_id => p_transaction_step_id
597: ,p_name => 'P_TDB_INFORMATION12');
598:
599: l_tdb_information13 := hr_transaction_api.get_varchar2_value
600: (p_transaction_step_id => p_transaction_step_id
601: ,p_name => 'P_TDB_INFORMATION13');
602:
603: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 603: l_tdb_information14 := hr_transaction_api.get_varchar2_value

599: l_tdb_information13 := hr_transaction_api.get_varchar2_value
600: (p_transaction_step_id => p_transaction_step_id
601: ,p_name => 'P_TDB_INFORMATION13');
602:
603: l_tdb_information14 := hr_transaction_api.get_varchar2_value
604: (p_transaction_step_id => p_transaction_step_id
605: ,p_name => 'P_TDB_INFORMATION14');
606:
607: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 607: l_tdb_information15 := hr_transaction_api.get_varchar2_value

603: l_tdb_information14 := hr_transaction_api.get_varchar2_value
604: (p_transaction_step_id => p_transaction_step_id
605: ,p_name => 'P_TDB_INFORMATION14');
606:
607: l_tdb_information15 := hr_transaction_api.get_varchar2_value
608: (p_transaction_step_id => p_transaction_step_id
609: ,p_name => 'P_TDB_INFORMATION15');
610:
611: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 611: l_tdb_information16 := hr_transaction_api.get_varchar2_value

607: l_tdb_information15 := hr_transaction_api.get_varchar2_value
608: (p_transaction_step_id => p_transaction_step_id
609: ,p_name => 'P_TDB_INFORMATION15');
610:
611: l_tdb_information16 := hr_transaction_api.get_varchar2_value
612: (p_transaction_step_id => p_transaction_step_id
613: ,p_name => 'P_TDB_INFORMATION16');
614:
615: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 615: l_tdb_information17 := hr_transaction_api.get_varchar2_value

611: l_tdb_information16 := hr_transaction_api.get_varchar2_value
612: (p_transaction_step_id => p_transaction_step_id
613: ,p_name => 'P_TDB_INFORMATION16');
614:
615: l_tdb_information17 := hr_transaction_api.get_varchar2_value
616: (p_transaction_step_id => p_transaction_step_id
617: ,p_name => 'P_TDB_INFORMATION17');
618:
619: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 619: l_tdb_information18 := hr_transaction_api.get_varchar2_value

615: l_tdb_information17 := hr_transaction_api.get_varchar2_value
616: (p_transaction_step_id => p_transaction_step_id
617: ,p_name => 'P_TDB_INFORMATION17');
618:
619: l_tdb_information18 := hr_transaction_api.get_varchar2_value
620: (p_transaction_step_id => p_transaction_step_id
621: ,p_name => 'P_TDB_INFORMATION18');
622:
623: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 623: l_tdb_information19 := hr_transaction_api.get_varchar2_value

619: l_tdb_information18 := hr_transaction_api.get_varchar2_value
620: (p_transaction_step_id => p_transaction_step_id
621: ,p_name => 'P_TDB_INFORMATION18');
622:
623: l_tdb_information19 := hr_transaction_api.get_varchar2_value
624: (p_transaction_step_id => p_transaction_step_id
625: ,p_name => 'P_TDB_INFORMATION19');
626:
627: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 627: l_tdb_information20 := hr_transaction_api.get_varchar2_value

623: l_tdb_information19 := hr_transaction_api.get_varchar2_value
624: (p_transaction_step_id => p_transaction_step_id
625: ,p_name => 'P_TDB_INFORMATION19');
626:
627: l_tdb_information20 := hr_transaction_api.get_varchar2_value
628: (p_transaction_step_id => p_transaction_step_id
629: ,p_name => 'P_TDB_INFORMATION20');
630:
631: l_offering_id := hr_transaction_api.get_varchar2_value

Line 631: l_offering_id := hr_transaction_api.get_varchar2_value

627: l_tdb_information20 := hr_transaction_api.get_varchar2_value
628: (p_transaction_step_id => p_transaction_step_id
629: ,p_name => 'P_TDB_INFORMATION20');
630:
631: l_offering_id := hr_transaction_api.get_varchar2_value
632: (p_transaction_step_id => p_transaction_step_id
633: ,p_name => 'P_OFFERING_ID');
634:
635: l_booking_justification_id := hr_transaction_api.get_varchar2_value

Line 635: l_booking_justification_id := hr_transaction_api.get_varchar2_value

631: l_offering_id := hr_transaction_api.get_varchar2_value
632: (p_transaction_step_id => p_transaction_step_id
633: ,p_name => 'P_OFFERING_ID');
634:
635: l_booking_justification_id := hr_transaction_api.get_varchar2_value
636: (p_transaction_step_id => p_transaction_step_id
637: ,p_name => 'P_BKNG_JUSTIFICATION_ID');
638:
639: IF l_booking_justification_id IS NOT NULL THEN

Line 712: /* hr_transaction_api.get_transaction_step_info

708:
709:
710: BEGIN
711:
712: /* hr_transaction_api.get_transaction_step_info
713: (p_item_type => p_item_type
714: ,p_item_key => p_item_key
715: ,p_activity_id => p_activity_id
716: ,p_transaction_step_id => l_trans_step_ids

Line 783: l_eventid := hr_transaction_api.get_varchar2_value

779:
780: begin
781:
782:
783: l_eventid := hr_transaction_api.get_varchar2_value
784: (p_transaction_step_id => p_transaction_step_id
785: ,p_name => 'P_EVENTID');
786:
787:

Line 788: l_specialInstruction := hr_transaction_api.get_varchar2_value

784: (p_transaction_step_id => p_transaction_step_id
785: ,p_name => 'P_EVENTID');
786:
787:
788: l_specialInstruction := hr_transaction_api.get_varchar2_value
789: (p_transaction_step_id => p_transaction_step_id
790: ,p_name => 'P_SPECIALINSTRUCTION');
791:
792: /* l_keyflexid := hr_transaction_api.get_varchar2_value

Line 792: /* l_keyflexid := hr_transaction_api.get_varchar2_value

788: l_specialInstruction := hr_transaction_api.get_varchar2_value
789: (p_transaction_step_id => p_transaction_step_id
790: ,p_name => 'P_SPECIALINSTRUCTION');
791:
792: /* l_keyflexid := hr_transaction_api.get_varchar2_value
793: (p_transaction_step_id => p_transaction_step_id
794: ,p_name => 'P_KEYFLEXID'); */
795:
796: l_ccselectiontext := hr_transaction_api.get_varchar2_value

Line 796: l_ccselectiontext := hr_transaction_api.get_varchar2_value

792: /* l_keyflexid := hr_transaction_api.get_varchar2_value
793: (p_transaction_step_id => p_transaction_step_id
794: ,p_name => 'P_KEYFLEXID'); */
795:
796: l_ccselectiontext := hr_transaction_api.get_varchar2_value
797: (p_transaction_step_id => p_transaction_step_id
798: ,p_name => 'P_CCSELECTIONTEXT');
799:
800: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 800: l_tdb_information_category := hr_transaction_api.get_varchar2_value

796: l_ccselectiontext := hr_transaction_api.get_varchar2_value
797: (p_transaction_step_id => p_transaction_step_id
798: ,p_name => 'P_CCSELECTIONTEXT');
799:
800: l_tdb_information_category := hr_transaction_api.get_varchar2_value
801: (p_transaction_step_id => p_transaction_step_id
802: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
803:
804: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 804: l_tdb_information1 := hr_transaction_api.get_varchar2_value

800: l_tdb_information_category := hr_transaction_api.get_varchar2_value
801: (p_transaction_step_id => p_transaction_step_id
802: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
803:
804: l_tdb_information1 := hr_transaction_api.get_varchar2_value
805: (p_transaction_step_id => p_transaction_step_id
806: ,p_name => 'P_TDB_INFORMATION1');
807:
808: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 808: l_tdb_information2 := hr_transaction_api.get_varchar2_value

804: l_tdb_information1 := hr_transaction_api.get_varchar2_value
805: (p_transaction_step_id => p_transaction_step_id
806: ,p_name => 'P_TDB_INFORMATION1');
807:
808: l_tdb_information2 := hr_transaction_api.get_varchar2_value
809: (p_transaction_step_id => p_transaction_step_id
810: ,p_name => 'P_TDB_INFORMATION2');
811:
812: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 812: l_tdb_information3 := hr_transaction_api.get_varchar2_value

808: l_tdb_information2 := hr_transaction_api.get_varchar2_value
809: (p_transaction_step_id => p_transaction_step_id
810: ,p_name => 'P_TDB_INFORMATION2');
811:
812: l_tdb_information3 := hr_transaction_api.get_varchar2_value
813: (p_transaction_step_id => p_transaction_step_id
814: ,p_name => 'P_TDB_INFORMATION3');
815:
816: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 816: l_tdb_information4 := hr_transaction_api.get_varchar2_value

812: l_tdb_information3 := hr_transaction_api.get_varchar2_value
813: (p_transaction_step_id => p_transaction_step_id
814: ,p_name => 'P_TDB_INFORMATION3');
815:
816: l_tdb_information4 := hr_transaction_api.get_varchar2_value
817: (p_transaction_step_id => p_transaction_step_id
818: ,p_name => 'P_TDB_INFORMATION4');
819:
820: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 820: l_tdb_information5 := hr_transaction_api.get_varchar2_value

816: l_tdb_information4 := hr_transaction_api.get_varchar2_value
817: (p_transaction_step_id => p_transaction_step_id
818: ,p_name => 'P_TDB_INFORMATION4');
819:
820: l_tdb_information5 := hr_transaction_api.get_varchar2_value
821: (p_transaction_step_id => p_transaction_step_id
822: ,p_name => 'P_TDB_INFORMATION5');
823:
824: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 824: l_tdb_information6 := hr_transaction_api.get_varchar2_value

820: l_tdb_information5 := hr_transaction_api.get_varchar2_value
821: (p_transaction_step_id => p_transaction_step_id
822: ,p_name => 'P_TDB_INFORMATION5');
823:
824: l_tdb_information6 := hr_transaction_api.get_varchar2_value
825: (p_transaction_step_id => p_transaction_step_id
826: ,p_name => 'P_TDB_INFORMATION6');
827:
828: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 828: l_tdb_information7 := hr_transaction_api.get_varchar2_value

824: l_tdb_information6 := hr_transaction_api.get_varchar2_value
825: (p_transaction_step_id => p_transaction_step_id
826: ,p_name => 'P_TDB_INFORMATION6');
827:
828: l_tdb_information7 := hr_transaction_api.get_varchar2_value
829: (p_transaction_step_id => p_transaction_step_id
830: ,p_name => 'P_TDB_INFORMATION7');
831:
832: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 832: l_tdb_information8 := hr_transaction_api.get_varchar2_value

828: l_tdb_information7 := hr_transaction_api.get_varchar2_value
829: (p_transaction_step_id => p_transaction_step_id
830: ,p_name => 'P_TDB_INFORMATION7');
831:
832: l_tdb_information8 := hr_transaction_api.get_varchar2_value
833: (p_transaction_step_id => p_transaction_step_id
834: ,p_name => 'P_TDB_INFORMATION8');
835:
836: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 836: l_tdb_information9 := hr_transaction_api.get_varchar2_value

832: l_tdb_information8 := hr_transaction_api.get_varchar2_value
833: (p_transaction_step_id => p_transaction_step_id
834: ,p_name => 'P_TDB_INFORMATION8');
835:
836: l_tdb_information9 := hr_transaction_api.get_varchar2_value
837: (p_transaction_step_id => p_transaction_step_id
838: ,p_name => 'P_TDB_INFORMATION9');
839:
840: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 840: l_tdb_information10 := hr_transaction_api.get_varchar2_value

836: l_tdb_information9 := hr_transaction_api.get_varchar2_value
837: (p_transaction_step_id => p_transaction_step_id
838: ,p_name => 'P_TDB_INFORMATION9');
839:
840: l_tdb_information10 := hr_transaction_api.get_varchar2_value
841: (p_transaction_step_id => p_transaction_step_id
842: ,p_name => 'P_TDB_INFORMATION10');
843:
844: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 844: l_tdb_information11 := hr_transaction_api.get_varchar2_value

840: l_tdb_information10 := hr_transaction_api.get_varchar2_value
841: (p_transaction_step_id => p_transaction_step_id
842: ,p_name => 'P_TDB_INFORMATION10');
843:
844: l_tdb_information11 := hr_transaction_api.get_varchar2_value
845: (p_transaction_step_id => p_transaction_step_id
846: ,p_name => 'P_TDB_INFORMATION11');
847:
848: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 848: l_tdb_information12 := hr_transaction_api.get_varchar2_value

844: l_tdb_information11 := hr_transaction_api.get_varchar2_value
845: (p_transaction_step_id => p_transaction_step_id
846: ,p_name => 'P_TDB_INFORMATION11');
847:
848: l_tdb_information12 := hr_transaction_api.get_varchar2_value
849: (p_transaction_step_id => p_transaction_step_id
850: ,p_name => 'P_TDB_INFORMATION12');
851:
852: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 852: l_tdb_information13 := hr_transaction_api.get_varchar2_value

848: l_tdb_information12 := hr_transaction_api.get_varchar2_value
849: (p_transaction_step_id => p_transaction_step_id
850: ,p_name => 'P_TDB_INFORMATION12');
851:
852: l_tdb_information13 := hr_transaction_api.get_varchar2_value
853: (p_transaction_step_id => p_transaction_step_id
854: ,p_name => 'P_TDB_INFORMATION13');
855:
856: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 856: l_tdb_information14 := hr_transaction_api.get_varchar2_value

852: l_tdb_information13 := hr_transaction_api.get_varchar2_value
853: (p_transaction_step_id => p_transaction_step_id
854: ,p_name => 'P_TDB_INFORMATION13');
855:
856: l_tdb_information14 := hr_transaction_api.get_varchar2_value
857: (p_transaction_step_id => p_transaction_step_id
858: ,p_name => 'P_TDB_INFORMATION14');
859:
860: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 860: l_tdb_information15 := hr_transaction_api.get_varchar2_value

856: l_tdb_information14 := hr_transaction_api.get_varchar2_value
857: (p_transaction_step_id => p_transaction_step_id
858: ,p_name => 'P_TDB_INFORMATION14');
859:
860: l_tdb_information15 := hr_transaction_api.get_varchar2_value
861: (p_transaction_step_id => p_transaction_step_id
862: ,p_name => 'P_TDB_INFORMATION15');
863:
864: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 864: l_tdb_information16 := hr_transaction_api.get_varchar2_value

860: l_tdb_information15 := hr_transaction_api.get_varchar2_value
861: (p_transaction_step_id => p_transaction_step_id
862: ,p_name => 'P_TDB_INFORMATION15');
863:
864: l_tdb_information16 := hr_transaction_api.get_varchar2_value
865: (p_transaction_step_id => p_transaction_step_id
866: ,p_name => 'P_TDB_INFORMATION16');
867:
868: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 868: l_tdb_information17 := hr_transaction_api.get_varchar2_value

864: l_tdb_information16 := hr_transaction_api.get_varchar2_value
865: (p_transaction_step_id => p_transaction_step_id
866: ,p_name => 'P_TDB_INFORMATION16');
867:
868: l_tdb_information17 := hr_transaction_api.get_varchar2_value
869: (p_transaction_step_id => p_transaction_step_id
870: ,p_name => 'P_TDB_INFORMATION17');
871:
872: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 872: l_tdb_information18 := hr_transaction_api.get_varchar2_value

868: l_tdb_information17 := hr_transaction_api.get_varchar2_value
869: (p_transaction_step_id => p_transaction_step_id
870: ,p_name => 'P_TDB_INFORMATION17');
871:
872: l_tdb_information18 := hr_transaction_api.get_varchar2_value
873: (p_transaction_step_id => p_transaction_step_id
874: ,p_name => 'P_TDB_INFORMATION18');
875:
876: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 876: l_tdb_information19 := hr_transaction_api.get_varchar2_value

872: l_tdb_information18 := hr_transaction_api.get_varchar2_value
873: (p_transaction_step_id => p_transaction_step_id
874: ,p_name => 'P_TDB_INFORMATION18');
875:
876: l_tdb_information19 := hr_transaction_api.get_varchar2_value
877: (p_transaction_step_id => p_transaction_step_id
878: ,p_name => 'P_TDB_INFORMATION19');
879:
880: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 880: l_tdb_information20 := hr_transaction_api.get_varchar2_value

876: l_tdb_information19 := hr_transaction_api.get_varchar2_value
877: (p_transaction_step_id => p_transaction_step_id
878: ,p_name => 'P_TDB_INFORMATION19');
879:
880: l_tdb_information20 := hr_transaction_api.get_varchar2_value
881: (p_transaction_step_id => p_transaction_step_id
882: ,p_name => 'P_TDB_INFORMATION20');
883:
884: l_trnorgnames := hr_transaction_api.get_varchar2_value

Line 884: l_trnorgnames := hr_transaction_api.get_varchar2_value

880: l_tdb_information20 := hr_transaction_api.get_varchar2_value
881: (p_transaction_step_id => p_transaction_step_id
882: ,p_name => 'P_TDB_INFORMATION20');
883:
884: l_trnorgnames := hr_transaction_api.get_varchar2_value
885: (p_transaction_step_id => p_transaction_step_id
886: ,p_name => 'P_TRNORGNAMES');
887:
888: l_offering_id := hr_transaction_api.get_varchar2_value

Line 888: l_offering_id := hr_transaction_api.get_varchar2_value

884: l_trnorgnames := hr_transaction_api.get_varchar2_value
885: (p_transaction_step_id => p_transaction_step_id
886: ,p_name => 'P_TRNORGNAMES');
887:
888: l_offering_id := hr_transaction_api.get_varchar2_value
889: (p_transaction_step_id => p_transaction_step_id
890: ,p_name => 'P_OFFERING_ID');
891:
892: l_booking_justification_id := hr_transaction_api.get_varchar2_value

Line 892: l_booking_justification_id := hr_transaction_api.get_varchar2_value

888: l_offering_id := hr_transaction_api.get_varchar2_value
889: (p_transaction_step_id => p_transaction_step_id
890: ,p_name => 'P_OFFERING_ID');
891:
892: l_booking_justification_id := hr_transaction_api.get_varchar2_value
893: (p_transaction_step_id => p_transaction_step_id
894: ,p_name => 'P_BKNG_JUSTIFICATION_ID');
895:
896: IF l_booking_justification_id IS NOT NULL THEN

Line 1139: l_from := hr_transaction_api.get_varchar2_value

1135: where booking_justification_id = p_booking_justification_id;
1136:
1137: BEGIN
1138:
1139: l_from := hr_transaction_api.get_varchar2_value
1140: (p_transaction_step_id => p_transaction_step_id
1141: ,p_name => 'P_FROM');
1142:
1143: hr_transaction_api.get_transaction_step_info

Line 1143: hr_transaction_api.get_transaction_step_info

1139: l_from := hr_transaction_api.get_varchar2_value
1140: (p_transaction_step_id => p_transaction_step_id
1141: ,p_name => 'P_FROM');
1142:
1143: hr_transaction_api.get_transaction_step_info
1144: (p_transaction_step_id => p_transaction_step_id
1145: ,p_item_type => l_item_type
1146: ,p_item_key => l_item_key
1147: ,p_activity_id => l_activity_id);

Line 1154: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1150:
1151: -- establish Savepoint
1152: SAVEPOINT validate_enrollment;
1153:
1154: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1155: (p_transaction_step_id => p_transaction_step_id
1156: ,p_name => 'P_EVENTID'));
1157:
1158:

Line 1160: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1156: ,p_name => 'P_EVENTID'));
1157:
1158:
1159: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
1160: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1161: (p_transaction_step_id => p_transaction_step_id
1162: -- ,p_name => 'P_PERSON_ID'));
1163: ,p_name => 'P_DELEGATE_PERSON_ID'));
1164:

Line 1166: l_specialInstruction := hr_transaction_api.get_varchar2_value

1162: -- ,p_name => 'P_PERSON_ID'));
1163: ,p_name => 'P_DELEGATE_PERSON_ID'));
1164:
1165:
1166: l_specialInstruction := hr_transaction_api.get_varchar2_value
1167: (p_transaction_step_id => p_transaction_step_id
1168: ,p_name => 'P_SPECIALINSTRUCTION');
1169:
1170: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 1170: l_tdb_information_category := hr_transaction_api.get_varchar2_value

1166: l_specialInstruction := hr_transaction_api.get_varchar2_value
1167: (p_transaction_step_id => p_transaction_step_id
1168: ,p_name => 'P_SPECIALINSTRUCTION');
1169:
1170: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1171: (p_transaction_step_id => p_transaction_step_id
1172: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1173:
1174: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 1174: l_tdb_information1 := hr_transaction_api.get_varchar2_value

1170: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1171: (p_transaction_step_id => p_transaction_step_id
1172: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1173:
1174: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1175: (p_transaction_step_id => p_transaction_step_id
1176: ,p_name => 'P_TDB_INFORMATION1');
1177:
1178: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 1178: l_tdb_information2 := hr_transaction_api.get_varchar2_value

1174: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1175: (p_transaction_step_id => p_transaction_step_id
1176: ,p_name => 'P_TDB_INFORMATION1');
1177:
1178: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1179: (p_transaction_step_id => p_transaction_step_id
1180: ,p_name => 'P_TDB_INFORMATION2');
1181:
1182: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 1182: l_tdb_information3 := hr_transaction_api.get_varchar2_value

1178: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1179: (p_transaction_step_id => p_transaction_step_id
1180: ,p_name => 'P_TDB_INFORMATION2');
1181:
1182: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1183: (p_transaction_step_id => p_transaction_step_id
1184: ,p_name => 'P_TDB_INFORMATION3');
1185:
1186: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 1186: l_tdb_information4 := hr_transaction_api.get_varchar2_value

1182: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1183: (p_transaction_step_id => p_transaction_step_id
1184: ,p_name => 'P_TDB_INFORMATION3');
1185:
1186: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1187: (p_transaction_step_id => p_transaction_step_id
1188: ,p_name => 'P_TDB_INFORMATION4');
1189:
1190: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 1190: l_tdb_information5 := hr_transaction_api.get_varchar2_value

1186: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1187: (p_transaction_step_id => p_transaction_step_id
1188: ,p_name => 'P_TDB_INFORMATION4');
1189:
1190: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1191: (p_transaction_step_id => p_transaction_step_id
1192: ,p_name => 'P_TDB_INFORMATION5');
1193:
1194: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 1194: l_tdb_information6 := hr_transaction_api.get_varchar2_value

1190: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1191: (p_transaction_step_id => p_transaction_step_id
1192: ,p_name => 'P_TDB_INFORMATION5');
1193:
1194: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1195: (p_transaction_step_id => p_transaction_step_id
1196: ,p_name => 'P_TDB_INFORMATION6');
1197:
1198: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 1198: l_tdb_information7 := hr_transaction_api.get_varchar2_value

1194: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1195: (p_transaction_step_id => p_transaction_step_id
1196: ,p_name => 'P_TDB_INFORMATION6');
1197:
1198: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1199: (p_transaction_step_id => p_transaction_step_id
1200: ,p_name => 'P_TDB_INFORMATION7');
1201:
1202: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 1202: l_tdb_information8 := hr_transaction_api.get_varchar2_value

1198: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1199: (p_transaction_step_id => p_transaction_step_id
1200: ,p_name => 'P_TDB_INFORMATION7');
1201:
1202: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1203: (p_transaction_step_id => p_transaction_step_id
1204: ,p_name => 'P_TDB_INFORMATION8');
1205:
1206: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 1206: l_tdb_information9 := hr_transaction_api.get_varchar2_value

1202: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1203: (p_transaction_step_id => p_transaction_step_id
1204: ,p_name => 'P_TDB_INFORMATION8');
1205:
1206: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1207: (p_transaction_step_id => p_transaction_step_id
1208: ,p_name => 'P_TDB_INFORMATION9');
1209:
1210: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 1210: l_tdb_information10 := hr_transaction_api.get_varchar2_value

1206: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1207: (p_transaction_step_id => p_transaction_step_id
1208: ,p_name => 'P_TDB_INFORMATION9');
1209:
1210: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1211: (p_transaction_step_id => p_transaction_step_id
1212: ,p_name => 'P_TDB_INFORMATION10');
1213:
1214: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 1214: l_tdb_information11 := hr_transaction_api.get_varchar2_value

1210: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1211: (p_transaction_step_id => p_transaction_step_id
1212: ,p_name => 'P_TDB_INFORMATION10');
1213:
1214: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1215: (p_transaction_step_id => p_transaction_step_id
1216: ,p_name => 'P_TDB_INFORMATION11');
1217:
1218: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 1218: l_tdb_information12 := hr_transaction_api.get_varchar2_value

1214: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1215: (p_transaction_step_id => p_transaction_step_id
1216: ,p_name => 'P_TDB_INFORMATION11');
1217:
1218: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1219: (p_transaction_step_id => p_transaction_step_id
1220: ,p_name => 'P_TDB_INFORMATION12');
1221:
1222: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 1222: l_tdb_information13 := hr_transaction_api.get_varchar2_value

1218: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1219: (p_transaction_step_id => p_transaction_step_id
1220: ,p_name => 'P_TDB_INFORMATION12');
1221:
1222: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1223: (p_transaction_step_id => p_transaction_step_id
1224: ,p_name => 'P_TDB_INFORMATION13');
1225:
1226: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 1226: l_tdb_information14 := hr_transaction_api.get_varchar2_value

1222: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1223: (p_transaction_step_id => p_transaction_step_id
1224: ,p_name => 'P_TDB_INFORMATION13');
1225:
1226: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1227: (p_transaction_step_id => p_transaction_step_id
1228: ,p_name => 'P_TDB_INFORMATION14');
1229:
1230: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 1230: l_tdb_information15 := hr_transaction_api.get_varchar2_value

1226: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1227: (p_transaction_step_id => p_transaction_step_id
1228: ,p_name => 'P_TDB_INFORMATION14');
1229:
1230: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1231: (p_transaction_step_id => p_transaction_step_id
1232: ,p_name => 'P_TDB_INFORMATION15');
1233:
1234: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 1234: l_tdb_information16 := hr_transaction_api.get_varchar2_value

1230: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1231: (p_transaction_step_id => p_transaction_step_id
1232: ,p_name => 'P_TDB_INFORMATION15');
1233:
1234: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1235: (p_transaction_step_id => p_transaction_step_id
1236: ,p_name => 'P_TDB_INFORMATION16');
1237:
1238: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 1238: l_tdb_information17 := hr_transaction_api.get_varchar2_value

1234: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1235: (p_transaction_step_id => p_transaction_step_id
1236: ,p_name => 'P_TDB_INFORMATION16');
1237:
1238: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1239: (p_transaction_step_id => p_transaction_step_id
1240: ,p_name => 'P_TDB_INFORMATION17');
1241:
1242: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 1242: l_tdb_information18 := hr_transaction_api.get_varchar2_value

1238: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1239: (p_transaction_step_id => p_transaction_step_id
1240: ,p_name => 'P_TDB_INFORMATION17');
1241:
1242: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1243: (p_transaction_step_id => p_transaction_step_id
1244: ,p_name => 'P_TDB_INFORMATION18');
1245:
1246: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 1246: l_tdb_information19 := hr_transaction_api.get_varchar2_value

1242: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1243: (p_transaction_step_id => p_transaction_step_id
1244: ,p_name => 'P_TDB_INFORMATION18');
1245:
1246: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1247: (p_transaction_step_id => p_transaction_step_id
1248: ,p_name => 'P_TDB_INFORMATION19');
1249:
1250: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 1250: l_tdb_information20 := hr_transaction_api.get_varchar2_value

1246: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1247: (p_transaction_step_id => p_transaction_step_id
1248: ,p_name => 'P_TDB_INFORMATION19');
1249:
1250: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1251: (p_transaction_step_id => p_transaction_step_id
1252: ,p_name => 'P_TDB_INFORMATION20');
1253:
1254: l_booking_justification_id := hr_transaction_api.get_varchar2_value

Line 1254: l_booking_justification_id := hr_transaction_api.get_varchar2_value

1250: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1251: (p_transaction_step_id => p_transaction_step_id
1252: ,p_name => 'P_TDB_INFORMATION20');
1253:
1254: l_booking_justification_id := hr_transaction_api.get_varchar2_value
1255: (p_transaction_step_id => p_transaction_step_id
1256: ,p_name => 'P_BKNG_JUSTIFICATION_ID');
1257:
1258: IF l_booking_justification_id IS NOT NULL THEN

Line 1550: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1546: end if;
1547:
1548: ELSIF l_from = 'APPROVE' then -- update enrollment and create finance line if profile is set to YES
1549:
1550: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1551: (p_transaction_step_id => p_transaction_step_id
1552: ,p_name => 'P_EVENTID'));
1553:
1554:

Line 1555: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1551: (p_transaction_step_id => p_transaction_step_id
1552: ,p_name => 'P_EVENTID'));
1553:
1554:
1555: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1556: (p_transaction_step_id => p_transaction_step_id
1557: ,p_name => 'P_DELEGATE_PERSON_ID'));
1558:
1559:

Line 1669: l_cost_allocation_keyflex_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1665: IF l_auto_create_finance = 'Y' and
1666: l_price_basis <> 'N' and
1667: l_event_currency_code is not null THEN
1668:
1669: l_cost_allocation_keyflex_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1670: (p_transaction_step_id => p_transaction_step_id
1671: ,p_name => 'P_KEYFLEXID'));
1672:
1673:

Line 1674: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value

1670: (p_transaction_step_id => p_transaction_step_id
1671: ,p_name => 'P_KEYFLEXID'));
1672:
1673:
1674: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value
1675: (p_transaction_step_id => p_transaction_step_id
1676: ,p_name => 'P_BUSINESSGROUPID'));
1677:
1678: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

Line 1678: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1674: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value
1675: (p_transaction_step_id => p_transaction_step_id
1676: ,p_name => 'P_BUSINESSGROUPID'));
1677:
1678: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1679: (p_transaction_step_id => p_transaction_step_id
1680: ,p_name => 'P_ASSIGNMENTID'));
1681:
1682: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

Line 1682: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1678: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1679: (p_transaction_step_id => p_transaction_step_id
1680: ,p_name => 'P_ASSIGNMENTID'));
1681:
1682: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1683: (p_transaction_step_id => p_transaction_step_id
1684: ,p_name => 'P_ORGANIZATIONID'));
1685:
1686: fnd_message.set_name('OTA', 'OTA_443505_COST_CENTER_CHARGED');

Line 1958: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1954:
1955: if ( funmode = 'RUN' ) then
1956:
1957: /* Bug#2258423 hdshah read event id from workflow instead of transaction table
1958: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1959: (p_transaction_step_id => l_transaction_step_id
1960: ,p_name => 'P_EVENTID'));
1961: */
1962:

Line 1969: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1965: ,aname => 'OTA_EVENT_ID');
1966:
1967: /* Bug#2258423 hdshah read delegate person id from workflow instead of transaction table
1968: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
1969: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1970: (p_transaction_step_id => l_transaction_step_id
1971: -- ,p_name => 'P_PERSON_ID'));
1972: ,p_name => 'P_DELEGATE_PERSON_ID'));
1973: */

Line 2496: hr_transaction_api.get_varchar2_value

2492:
2493: FOR c in cur_get_pending_trn_step_id
2494: LOOP
2495: l_temp_event_id :=
2496: hr_transaction_api.get_varchar2_value
2497: (p_transaction_step_id => c.transaction_step_id
2498: ,p_name => 'P_EVENTID');
2499:
2500: If (l_temp_event_id is not null and l_temp_event_id = p_event_id) Then