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

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

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

Line 97: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

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

Line 104: hr_transaction_api.delete_transaction_step(p_validate => false

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

Line 114: hr_transaction_api.create_transaction_step

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

Line 335: /* l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

331:
332:
333: if l_approval_mode = 'YES_DYNAMIC' and p_from='REVIEW' then
334:
335: /* l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
336: (p_transaction_step_id => l_transaction_step_id
337: ,p_name => 'P_EVENTID')); */
338:
339: hr_approval_wf.create_item_attrib_if_notexist

Line 411: hr_transaction_api.get_transaction_step_info

407:
408:
409: BEGIN
410:
411: hr_transaction_api.get_transaction_step_info
412: (p_item_type => p_item_type
413: ,p_item_key => p_item_key
414: ,p_activity_id => p_activity_id
415: ,p_transaction_step_id => l_trans_step_ids

Line 479: l_eventid := hr_transaction_api.get_varchar2_value

475:
476: begin
477:
478:
479: l_eventid := hr_transaction_api.get_varchar2_value
480: (p_transaction_step_id => p_transaction_step_id
481: ,p_name => 'P_EVENTID');
482:
483: l_activityversionid := hr_transaction_api.get_varchar2_value

Line 483: l_activityversionid := hr_transaction_api.get_varchar2_value

479: l_eventid := hr_transaction_api.get_varchar2_value
480: (p_transaction_step_id => p_transaction_step_id
481: ,p_name => 'P_EVENTID');
482:
483: l_activityversionid := hr_transaction_api.get_varchar2_value
484: (p_transaction_step_id => p_transaction_step_id
485: ,p_name => 'P_ACTIVITYVERSIONID');
486:
487: l_specialInstruction := hr_transaction_api.get_varchar2_value

Line 487: l_specialInstruction := hr_transaction_api.get_varchar2_value

483: l_activityversionid := hr_transaction_api.get_varchar2_value
484: (p_transaction_step_id => p_transaction_step_id
485: ,p_name => 'P_ACTIVITYVERSIONID');
486:
487: l_specialInstruction := hr_transaction_api.get_varchar2_value
488: (p_transaction_step_id => p_transaction_step_id
489: ,p_name => 'P_SPECIALINSTRUCTION');
490:
491: l_keyflexid := hr_transaction_api.get_varchar2_value

Line 491: l_keyflexid := hr_transaction_api.get_varchar2_value

487: l_specialInstruction := hr_transaction_api.get_varchar2_value
488: (p_transaction_step_id => p_transaction_step_id
489: ,p_name => 'P_SPECIALINSTRUCTION');
490:
491: l_keyflexid := hr_transaction_api.get_varchar2_value
492: (p_transaction_step_id => p_transaction_step_id
493: ,p_name => 'P_KEYFLEXID');
494:
495: l_businessgroupid := hr_transaction_api.get_varchar2_value

Line 495: l_businessgroupid := hr_transaction_api.get_varchar2_value

491: l_keyflexid := hr_transaction_api.get_varchar2_value
492: (p_transaction_step_id => p_transaction_step_id
493: ,p_name => 'P_KEYFLEXID');
494:
495: l_businessgroupid := hr_transaction_api.get_varchar2_value
496: (p_transaction_step_id => p_transaction_step_id
497: ,p_name => 'P_BUSINESSGROUPID');
498:
499: l_assignmentid := hr_transaction_api.get_varchar2_value

Line 499: l_assignmentid := hr_transaction_api.get_varchar2_value

495: l_businessgroupid := hr_transaction_api.get_varchar2_value
496: (p_transaction_step_id => p_transaction_step_id
497: ,p_name => 'P_BUSINESSGROUPID');
498:
499: l_assignmentid := hr_transaction_api.get_varchar2_value
500: (p_transaction_step_id => p_transaction_step_id
501: ,p_name => 'P_ASSIGNMENTID');
502:
503: l_organizationid := hr_transaction_api.get_varchar2_value

Line 503: l_organizationid := hr_transaction_api.get_varchar2_value

499: l_assignmentid := hr_transaction_api.get_varchar2_value
500: (p_transaction_step_id => p_transaction_step_id
501: ,p_name => 'P_ASSIGNMENTID');
502:
503: l_organizationid := hr_transaction_api.get_varchar2_value
504: (p_transaction_step_id => p_transaction_step_id
505: ,p_name => 'P_ORGANIZATIONID');
506:
507: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 507: l_tdb_information_category := hr_transaction_api.get_varchar2_value

503: l_organizationid := hr_transaction_api.get_varchar2_value
504: (p_transaction_step_id => p_transaction_step_id
505: ,p_name => 'P_ORGANIZATIONID');
506:
507: l_tdb_information_category := hr_transaction_api.get_varchar2_value
508: (p_transaction_step_id => p_transaction_step_id
509: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
510:
511: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 511: l_tdb_information1 := hr_transaction_api.get_varchar2_value

507: l_tdb_information_category := hr_transaction_api.get_varchar2_value
508: (p_transaction_step_id => p_transaction_step_id
509: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
510:
511: l_tdb_information1 := hr_transaction_api.get_varchar2_value
512: (p_transaction_step_id => p_transaction_step_id
513: ,p_name => 'P_TDB_INFORMATION1');
514:
515: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 515: l_tdb_information2 := hr_transaction_api.get_varchar2_value

511: l_tdb_information1 := hr_transaction_api.get_varchar2_value
512: (p_transaction_step_id => p_transaction_step_id
513: ,p_name => 'P_TDB_INFORMATION1');
514:
515: l_tdb_information2 := hr_transaction_api.get_varchar2_value
516: (p_transaction_step_id => p_transaction_step_id
517: ,p_name => 'P_TDB_INFORMATION2');
518:
519: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 519: l_tdb_information3 := hr_transaction_api.get_varchar2_value

515: l_tdb_information2 := hr_transaction_api.get_varchar2_value
516: (p_transaction_step_id => p_transaction_step_id
517: ,p_name => 'P_TDB_INFORMATION2');
518:
519: l_tdb_information3 := hr_transaction_api.get_varchar2_value
520: (p_transaction_step_id => p_transaction_step_id
521: ,p_name => 'P_TDB_INFORMATION3');
522:
523: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 523: l_tdb_information4 := hr_transaction_api.get_varchar2_value

519: l_tdb_information3 := hr_transaction_api.get_varchar2_value
520: (p_transaction_step_id => p_transaction_step_id
521: ,p_name => 'P_TDB_INFORMATION3');
522:
523: l_tdb_information4 := hr_transaction_api.get_varchar2_value
524: (p_transaction_step_id => p_transaction_step_id
525: ,p_name => 'P_TDB_INFORMATION4');
526:
527: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 527: l_tdb_information5 := hr_transaction_api.get_varchar2_value

523: l_tdb_information4 := hr_transaction_api.get_varchar2_value
524: (p_transaction_step_id => p_transaction_step_id
525: ,p_name => 'P_TDB_INFORMATION4');
526:
527: l_tdb_information5 := hr_transaction_api.get_varchar2_value
528: (p_transaction_step_id => p_transaction_step_id
529: ,p_name => 'P_TDB_INFORMATION5');
530:
531: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 531: l_tdb_information6 := hr_transaction_api.get_varchar2_value

527: l_tdb_information5 := hr_transaction_api.get_varchar2_value
528: (p_transaction_step_id => p_transaction_step_id
529: ,p_name => 'P_TDB_INFORMATION5');
530:
531: l_tdb_information6 := hr_transaction_api.get_varchar2_value
532: (p_transaction_step_id => p_transaction_step_id
533: ,p_name => 'P_TDB_INFORMATION6');
534:
535: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 535: l_tdb_information7 := hr_transaction_api.get_varchar2_value

531: l_tdb_information6 := hr_transaction_api.get_varchar2_value
532: (p_transaction_step_id => p_transaction_step_id
533: ,p_name => 'P_TDB_INFORMATION6');
534:
535: l_tdb_information7 := hr_transaction_api.get_varchar2_value
536: (p_transaction_step_id => p_transaction_step_id
537: ,p_name => 'P_TDB_INFORMATION7');
538:
539: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 539: l_tdb_information8 := hr_transaction_api.get_varchar2_value

535: l_tdb_information7 := hr_transaction_api.get_varchar2_value
536: (p_transaction_step_id => p_transaction_step_id
537: ,p_name => 'P_TDB_INFORMATION7');
538:
539: l_tdb_information8 := hr_transaction_api.get_varchar2_value
540: (p_transaction_step_id => p_transaction_step_id
541: ,p_name => 'P_TDB_INFORMATION8');
542:
543: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 543: l_tdb_information9 := hr_transaction_api.get_varchar2_value

539: l_tdb_information8 := hr_transaction_api.get_varchar2_value
540: (p_transaction_step_id => p_transaction_step_id
541: ,p_name => 'P_TDB_INFORMATION8');
542:
543: l_tdb_information9 := hr_transaction_api.get_varchar2_value
544: (p_transaction_step_id => p_transaction_step_id
545: ,p_name => 'P_TDB_INFORMATION9');
546:
547: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 547: l_tdb_information10 := hr_transaction_api.get_varchar2_value

543: l_tdb_information9 := hr_transaction_api.get_varchar2_value
544: (p_transaction_step_id => p_transaction_step_id
545: ,p_name => 'P_TDB_INFORMATION9');
546:
547: l_tdb_information10 := hr_transaction_api.get_varchar2_value
548: (p_transaction_step_id => p_transaction_step_id
549: ,p_name => 'P_TDB_INFORMATION10');
550:
551: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 551: l_tdb_information11 := hr_transaction_api.get_varchar2_value

547: l_tdb_information10 := hr_transaction_api.get_varchar2_value
548: (p_transaction_step_id => p_transaction_step_id
549: ,p_name => 'P_TDB_INFORMATION10');
550:
551: l_tdb_information11 := hr_transaction_api.get_varchar2_value
552: (p_transaction_step_id => p_transaction_step_id
553: ,p_name => 'P_TDB_INFORMATION11');
554:
555: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 555: l_tdb_information12 := hr_transaction_api.get_varchar2_value

551: l_tdb_information11 := hr_transaction_api.get_varchar2_value
552: (p_transaction_step_id => p_transaction_step_id
553: ,p_name => 'P_TDB_INFORMATION11');
554:
555: l_tdb_information12 := hr_transaction_api.get_varchar2_value
556: (p_transaction_step_id => p_transaction_step_id
557: ,p_name => 'P_TDB_INFORMATION12');
558:
559: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 559: l_tdb_information13 := hr_transaction_api.get_varchar2_value

555: l_tdb_information12 := hr_transaction_api.get_varchar2_value
556: (p_transaction_step_id => p_transaction_step_id
557: ,p_name => 'P_TDB_INFORMATION12');
558:
559: l_tdb_information13 := hr_transaction_api.get_varchar2_value
560: (p_transaction_step_id => p_transaction_step_id
561: ,p_name => 'P_TDB_INFORMATION13');
562:
563: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 563: l_tdb_information14 := hr_transaction_api.get_varchar2_value

559: l_tdb_information13 := hr_transaction_api.get_varchar2_value
560: (p_transaction_step_id => p_transaction_step_id
561: ,p_name => 'P_TDB_INFORMATION13');
562:
563: l_tdb_information14 := hr_transaction_api.get_varchar2_value
564: (p_transaction_step_id => p_transaction_step_id
565: ,p_name => 'P_TDB_INFORMATION14');
566:
567: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 567: l_tdb_information15 := hr_transaction_api.get_varchar2_value

563: l_tdb_information14 := hr_transaction_api.get_varchar2_value
564: (p_transaction_step_id => p_transaction_step_id
565: ,p_name => 'P_TDB_INFORMATION14');
566:
567: l_tdb_information15 := hr_transaction_api.get_varchar2_value
568: (p_transaction_step_id => p_transaction_step_id
569: ,p_name => 'P_TDB_INFORMATION15');
570:
571: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 571: l_tdb_information16 := hr_transaction_api.get_varchar2_value

567: l_tdb_information15 := hr_transaction_api.get_varchar2_value
568: (p_transaction_step_id => p_transaction_step_id
569: ,p_name => 'P_TDB_INFORMATION15');
570:
571: l_tdb_information16 := hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id => p_transaction_step_id
573: ,p_name => 'P_TDB_INFORMATION16');
574:
575: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 575: l_tdb_information17 := hr_transaction_api.get_varchar2_value

571: l_tdb_information16 := hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id => p_transaction_step_id
573: ,p_name => 'P_TDB_INFORMATION16');
574:
575: l_tdb_information17 := hr_transaction_api.get_varchar2_value
576: (p_transaction_step_id => p_transaction_step_id
577: ,p_name => 'P_TDB_INFORMATION17');
578:
579: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 579: l_tdb_information18 := hr_transaction_api.get_varchar2_value

575: l_tdb_information17 := hr_transaction_api.get_varchar2_value
576: (p_transaction_step_id => p_transaction_step_id
577: ,p_name => 'P_TDB_INFORMATION17');
578:
579: l_tdb_information18 := hr_transaction_api.get_varchar2_value
580: (p_transaction_step_id => p_transaction_step_id
581: ,p_name => 'P_TDB_INFORMATION18');
582:
583: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 583: l_tdb_information19 := hr_transaction_api.get_varchar2_value

579: l_tdb_information18 := hr_transaction_api.get_varchar2_value
580: (p_transaction_step_id => p_transaction_step_id
581: ,p_name => 'P_TDB_INFORMATION18');
582:
583: l_tdb_information19 := hr_transaction_api.get_varchar2_value
584: (p_transaction_step_id => p_transaction_step_id
585: ,p_name => 'P_TDB_INFORMATION19');
586:
587: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 587: l_tdb_information20 := hr_transaction_api.get_varchar2_value

583: l_tdb_information19 := hr_transaction_api.get_varchar2_value
584: (p_transaction_step_id => p_transaction_step_id
585: ,p_name => 'P_TDB_INFORMATION19');
586:
587: l_tdb_information20 := hr_transaction_api.get_varchar2_value
588: (p_transaction_step_id => p_transaction_step_id
589: ,p_name => 'P_TDB_INFORMATION20');
590:
591: --

Line 656: /* hr_transaction_api.get_transaction_step_info

652:
653:
654: BEGIN
655:
656: /* hr_transaction_api.get_transaction_step_info
657: (p_item_type => p_item_type
658: ,p_item_key => p_item_key
659: ,p_activity_id => p_activity_id
660: ,p_transaction_step_id => l_trans_step_ids

Line 724: l_eventid := hr_transaction_api.get_varchar2_value

720:
721: begin
722:
723:
724: l_eventid := hr_transaction_api.get_varchar2_value
725: (p_transaction_step_id => p_transaction_step_id
726: ,p_name => 'P_EVENTID');
727:
728:

Line 729: l_specialInstruction := hr_transaction_api.get_varchar2_value

725: (p_transaction_step_id => p_transaction_step_id
726: ,p_name => 'P_EVENTID');
727:
728:
729: l_specialInstruction := hr_transaction_api.get_varchar2_value
730: (p_transaction_step_id => p_transaction_step_id
731: ,p_name => 'P_SPECIALINSTRUCTION');
732:
733: /* l_keyflexid := hr_transaction_api.get_varchar2_value

Line 733: /* l_keyflexid := hr_transaction_api.get_varchar2_value

729: l_specialInstruction := hr_transaction_api.get_varchar2_value
730: (p_transaction_step_id => p_transaction_step_id
731: ,p_name => 'P_SPECIALINSTRUCTION');
732:
733: /* l_keyflexid := hr_transaction_api.get_varchar2_value
734: (p_transaction_step_id => p_transaction_step_id
735: ,p_name => 'P_KEYFLEXID'); */
736:
737: l_ccselectiontext := hr_transaction_api.get_varchar2_value

Line 737: l_ccselectiontext := hr_transaction_api.get_varchar2_value

733: /* l_keyflexid := hr_transaction_api.get_varchar2_value
734: (p_transaction_step_id => p_transaction_step_id
735: ,p_name => 'P_KEYFLEXID'); */
736:
737: l_ccselectiontext := hr_transaction_api.get_varchar2_value
738: (p_transaction_step_id => p_transaction_step_id
739: ,p_name => 'P_CCSELECTIONTEXT');
740:
741: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 741: l_tdb_information_category := hr_transaction_api.get_varchar2_value

737: l_ccselectiontext := hr_transaction_api.get_varchar2_value
738: (p_transaction_step_id => p_transaction_step_id
739: ,p_name => 'P_CCSELECTIONTEXT');
740:
741: l_tdb_information_category := hr_transaction_api.get_varchar2_value
742: (p_transaction_step_id => p_transaction_step_id
743: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
744:
745: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 745: l_tdb_information1 := hr_transaction_api.get_varchar2_value

741: l_tdb_information_category := hr_transaction_api.get_varchar2_value
742: (p_transaction_step_id => p_transaction_step_id
743: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
744:
745: l_tdb_information1 := hr_transaction_api.get_varchar2_value
746: (p_transaction_step_id => p_transaction_step_id
747: ,p_name => 'P_TDB_INFORMATION1');
748:
749: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 749: l_tdb_information2 := hr_transaction_api.get_varchar2_value

745: l_tdb_information1 := hr_transaction_api.get_varchar2_value
746: (p_transaction_step_id => p_transaction_step_id
747: ,p_name => 'P_TDB_INFORMATION1');
748:
749: l_tdb_information2 := hr_transaction_api.get_varchar2_value
750: (p_transaction_step_id => p_transaction_step_id
751: ,p_name => 'P_TDB_INFORMATION2');
752:
753: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 753: l_tdb_information3 := hr_transaction_api.get_varchar2_value

749: l_tdb_information2 := hr_transaction_api.get_varchar2_value
750: (p_transaction_step_id => p_transaction_step_id
751: ,p_name => 'P_TDB_INFORMATION2');
752:
753: l_tdb_information3 := hr_transaction_api.get_varchar2_value
754: (p_transaction_step_id => p_transaction_step_id
755: ,p_name => 'P_TDB_INFORMATION3');
756:
757: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 757: l_tdb_information4 := hr_transaction_api.get_varchar2_value

753: l_tdb_information3 := hr_transaction_api.get_varchar2_value
754: (p_transaction_step_id => p_transaction_step_id
755: ,p_name => 'P_TDB_INFORMATION3');
756:
757: l_tdb_information4 := hr_transaction_api.get_varchar2_value
758: (p_transaction_step_id => p_transaction_step_id
759: ,p_name => 'P_TDB_INFORMATION4');
760:
761: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 761: l_tdb_information5 := hr_transaction_api.get_varchar2_value

757: l_tdb_information4 := hr_transaction_api.get_varchar2_value
758: (p_transaction_step_id => p_transaction_step_id
759: ,p_name => 'P_TDB_INFORMATION4');
760:
761: l_tdb_information5 := hr_transaction_api.get_varchar2_value
762: (p_transaction_step_id => p_transaction_step_id
763: ,p_name => 'P_TDB_INFORMATION5');
764:
765: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 765: l_tdb_information6 := hr_transaction_api.get_varchar2_value

761: l_tdb_information5 := hr_transaction_api.get_varchar2_value
762: (p_transaction_step_id => p_transaction_step_id
763: ,p_name => 'P_TDB_INFORMATION5');
764:
765: l_tdb_information6 := hr_transaction_api.get_varchar2_value
766: (p_transaction_step_id => p_transaction_step_id
767: ,p_name => 'P_TDB_INFORMATION6');
768:
769: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 769: l_tdb_information7 := hr_transaction_api.get_varchar2_value

765: l_tdb_information6 := hr_transaction_api.get_varchar2_value
766: (p_transaction_step_id => p_transaction_step_id
767: ,p_name => 'P_TDB_INFORMATION6');
768:
769: l_tdb_information7 := hr_transaction_api.get_varchar2_value
770: (p_transaction_step_id => p_transaction_step_id
771: ,p_name => 'P_TDB_INFORMATION7');
772:
773: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 773: l_tdb_information8 := hr_transaction_api.get_varchar2_value

769: l_tdb_information7 := hr_transaction_api.get_varchar2_value
770: (p_transaction_step_id => p_transaction_step_id
771: ,p_name => 'P_TDB_INFORMATION7');
772:
773: l_tdb_information8 := hr_transaction_api.get_varchar2_value
774: (p_transaction_step_id => p_transaction_step_id
775: ,p_name => 'P_TDB_INFORMATION8');
776:
777: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 777: l_tdb_information9 := hr_transaction_api.get_varchar2_value

773: l_tdb_information8 := hr_transaction_api.get_varchar2_value
774: (p_transaction_step_id => p_transaction_step_id
775: ,p_name => 'P_TDB_INFORMATION8');
776:
777: l_tdb_information9 := hr_transaction_api.get_varchar2_value
778: (p_transaction_step_id => p_transaction_step_id
779: ,p_name => 'P_TDB_INFORMATION9');
780:
781: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 781: l_tdb_information10 := hr_transaction_api.get_varchar2_value

777: l_tdb_information9 := hr_transaction_api.get_varchar2_value
778: (p_transaction_step_id => p_transaction_step_id
779: ,p_name => 'P_TDB_INFORMATION9');
780:
781: l_tdb_information10 := hr_transaction_api.get_varchar2_value
782: (p_transaction_step_id => p_transaction_step_id
783: ,p_name => 'P_TDB_INFORMATION10');
784:
785: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 785: l_tdb_information11 := hr_transaction_api.get_varchar2_value

781: l_tdb_information10 := hr_transaction_api.get_varchar2_value
782: (p_transaction_step_id => p_transaction_step_id
783: ,p_name => 'P_TDB_INFORMATION10');
784:
785: l_tdb_information11 := hr_transaction_api.get_varchar2_value
786: (p_transaction_step_id => p_transaction_step_id
787: ,p_name => 'P_TDB_INFORMATION11');
788:
789: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 789: l_tdb_information12 := hr_transaction_api.get_varchar2_value

785: l_tdb_information11 := hr_transaction_api.get_varchar2_value
786: (p_transaction_step_id => p_transaction_step_id
787: ,p_name => 'P_TDB_INFORMATION11');
788:
789: l_tdb_information12 := hr_transaction_api.get_varchar2_value
790: (p_transaction_step_id => p_transaction_step_id
791: ,p_name => 'P_TDB_INFORMATION12');
792:
793: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 793: l_tdb_information13 := hr_transaction_api.get_varchar2_value

789: l_tdb_information12 := hr_transaction_api.get_varchar2_value
790: (p_transaction_step_id => p_transaction_step_id
791: ,p_name => 'P_TDB_INFORMATION12');
792:
793: l_tdb_information13 := hr_transaction_api.get_varchar2_value
794: (p_transaction_step_id => p_transaction_step_id
795: ,p_name => 'P_TDB_INFORMATION13');
796:
797: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 797: l_tdb_information14 := hr_transaction_api.get_varchar2_value

793: l_tdb_information13 := hr_transaction_api.get_varchar2_value
794: (p_transaction_step_id => p_transaction_step_id
795: ,p_name => 'P_TDB_INFORMATION13');
796:
797: l_tdb_information14 := hr_transaction_api.get_varchar2_value
798: (p_transaction_step_id => p_transaction_step_id
799: ,p_name => 'P_TDB_INFORMATION14');
800:
801: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 801: l_tdb_information15 := hr_transaction_api.get_varchar2_value

797: l_tdb_information14 := hr_transaction_api.get_varchar2_value
798: (p_transaction_step_id => p_transaction_step_id
799: ,p_name => 'P_TDB_INFORMATION14');
800:
801: l_tdb_information15 := hr_transaction_api.get_varchar2_value
802: (p_transaction_step_id => p_transaction_step_id
803: ,p_name => 'P_TDB_INFORMATION15');
804:
805: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 805: l_tdb_information16 := hr_transaction_api.get_varchar2_value

801: l_tdb_information15 := hr_transaction_api.get_varchar2_value
802: (p_transaction_step_id => p_transaction_step_id
803: ,p_name => 'P_TDB_INFORMATION15');
804:
805: l_tdb_information16 := hr_transaction_api.get_varchar2_value
806: (p_transaction_step_id => p_transaction_step_id
807: ,p_name => 'P_TDB_INFORMATION16');
808:
809: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 809: l_tdb_information17 := hr_transaction_api.get_varchar2_value

805: l_tdb_information16 := hr_transaction_api.get_varchar2_value
806: (p_transaction_step_id => p_transaction_step_id
807: ,p_name => 'P_TDB_INFORMATION16');
808:
809: l_tdb_information17 := hr_transaction_api.get_varchar2_value
810: (p_transaction_step_id => p_transaction_step_id
811: ,p_name => 'P_TDB_INFORMATION17');
812:
813: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 813: l_tdb_information18 := hr_transaction_api.get_varchar2_value

809: l_tdb_information17 := hr_transaction_api.get_varchar2_value
810: (p_transaction_step_id => p_transaction_step_id
811: ,p_name => 'P_TDB_INFORMATION17');
812:
813: l_tdb_information18 := hr_transaction_api.get_varchar2_value
814: (p_transaction_step_id => p_transaction_step_id
815: ,p_name => 'P_TDB_INFORMATION18');
816:
817: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 817: l_tdb_information19 := hr_transaction_api.get_varchar2_value

813: l_tdb_information18 := hr_transaction_api.get_varchar2_value
814: (p_transaction_step_id => p_transaction_step_id
815: ,p_name => 'P_TDB_INFORMATION18');
816:
817: l_tdb_information19 := hr_transaction_api.get_varchar2_value
818: (p_transaction_step_id => p_transaction_step_id
819: ,p_name => 'P_TDB_INFORMATION19');
820:
821: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 821: l_tdb_information20 := hr_transaction_api.get_varchar2_value

817: l_tdb_information19 := hr_transaction_api.get_varchar2_value
818: (p_transaction_step_id => p_transaction_step_id
819: ,p_name => 'P_TDB_INFORMATION19');
820:
821: l_tdb_information20 := hr_transaction_api.get_varchar2_value
822: (p_transaction_step_id => p_transaction_step_id
823: ,p_name => 'P_TDB_INFORMATION20');
824:
825: l_trnorgnames := hr_transaction_api.get_varchar2_value

Line 825: l_trnorgnames := hr_transaction_api.get_varchar2_value

821: l_tdb_information20 := hr_transaction_api.get_varchar2_value
822: (p_transaction_step_id => p_transaction_step_id
823: ,p_name => 'P_TDB_INFORMATION20');
824:
825: l_trnorgnames := hr_transaction_api.get_varchar2_value
826: (p_transaction_step_id => p_transaction_step_id
827: ,p_name => 'P_TRNORGNAMES');
828:
829: --

Line 1035: l_from := hr_transaction_api.get_varchar2_value

1031: BEGIN
1032:
1033: hr_utility.set_location('OTA_ENROLL_REVIEW_SS' ,100);
1034:
1035: l_from := hr_transaction_api.get_varchar2_value
1036: (p_transaction_step_id => p_transaction_step_id
1037: ,p_name => 'P_FROM');
1038:
1039: hr_transaction_api.get_transaction_step_info

Line 1039: hr_transaction_api.get_transaction_step_info

1035: l_from := hr_transaction_api.get_varchar2_value
1036: (p_transaction_step_id => p_transaction_step_id
1037: ,p_name => 'P_FROM');
1038:
1039: hr_transaction_api.get_transaction_step_info
1040: (p_transaction_step_id => p_transaction_step_id
1041: ,p_item_type => l_item_type
1042: ,p_item_key => l_item_key
1043: ,p_activity_id => l_activity_id);

Line 1050: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1046:
1047: -- establish Savepoint
1048: SAVEPOINT validate_enrollment;
1049:
1050: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1051: (p_transaction_step_id => p_transaction_step_id
1052: ,p_name => 'P_EVENTID'));
1053:
1054:

Line 1056: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1052: ,p_name => 'P_EVENTID'));
1053:
1054:
1055: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
1056: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1057: (p_transaction_step_id => p_transaction_step_id
1058: -- ,p_name => 'P_PERSON_ID'));
1059: ,p_name => 'P_DELEGATE_PERSON_ID'));
1060:

Line 1062: l_specialInstruction := hr_transaction_api.get_varchar2_value

1058: -- ,p_name => 'P_PERSON_ID'));
1059: ,p_name => 'P_DELEGATE_PERSON_ID'));
1060:
1061:
1062: l_specialInstruction := hr_transaction_api.get_varchar2_value
1063: (p_transaction_step_id => p_transaction_step_id
1064: ,p_name => 'P_SPECIALINSTRUCTION');
1065:
1066: l_tdb_information_category := hr_transaction_api.get_varchar2_value

Line 1066: l_tdb_information_category := hr_transaction_api.get_varchar2_value

1062: l_specialInstruction := hr_transaction_api.get_varchar2_value
1063: (p_transaction_step_id => p_transaction_step_id
1064: ,p_name => 'P_SPECIALINSTRUCTION');
1065:
1066: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1067: (p_transaction_step_id => p_transaction_step_id
1068: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1069:
1070: l_tdb_information1 := hr_transaction_api.get_varchar2_value

Line 1070: l_tdb_information1 := hr_transaction_api.get_varchar2_value

1066: l_tdb_information_category := hr_transaction_api.get_varchar2_value
1067: (p_transaction_step_id => p_transaction_step_id
1068: ,p_name => 'P_TDB_INFORMATION_CATEGORY');
1069:
1070: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1071: (p_transaction_step_id => p_transaction_step_id
1072: ,p_name => 'P_TDB_INFORMATION1');
1073:
1074: l_tdb_information2 := hr_transaction_api.get_varchar2_value

Line 1074: l_tdb_information2 := hr_transaction_api.get_varchar2_value

1070: l_tdb_information1 := hr_transaction_api.get_varchar2_value
1071: (p_transaction_step_id => p_transaction_step_id
1072: ,p_name => 'P_TDB_INFORMATION1');
1073:
1074: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1075: (p_transaction_step_id => p_transaction_step_id
1076: ,p_name => 'P_TDB_INFORMATION2');
1077:
1078: l_tdb_information3 := hr_transaction_api.get_varchar2_value

Line 1078: l_tdb_information3 := hr_transaction_api.get_varchar2_value

1074: l_tdb_information2 := hr_transaction_api.get_varchar2_value
1075: (p_transaction_step_id => p_transaction_step_id
1076: ,p_name => 'P_TDB_INFORMATION2');
1077:
1078: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1079: (p_transaction_step_id => p_transaction_step_id
1080: ,p_name => 'P_TDB_INFORMATION3');
1081:
1082: l_tdb_information4 := hr_transaction_api.get_varchar2_value

Line 1082: l_tdb_information4 := hr_transaction_api.get_varchar2_value

1078: l_tdb_information3 := hr_transaction_api.get_varchar2_value
1079: (p_transaction_step_id => p_transaction_step_id
1080: ,p_name => 'P_TDB_INFORMATION3');
1081:
1082: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1083: (p_transaction_step_id => p_transaction_step_id
1084: ,p_name => 'P_TDB_INFORMATION4');
1085:
1086: l_tdb_information5 := hr_transaction_api.get_varchar2_value

Line 1086: l_tdb_information5 := hr_transaction_api.get_varchar2_value

1082: l_tdb_information4 := hr_transaction_api.get_varchar2_value
1083: (p_transaction_step_id => p_transaction_step_id
1084: ,p_name => 'P_TDB_INFORMATION4');
1085:
1086: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1087: (p_transaction_step_id => p_transaction_step_id
1088: ,p_name => 'P_TDB_INFORMATION5');
1089:
1090: l_tdb_information6 := hr_transaction_api.get_varchar2_value

Line 1090: l_tdb_information6 := hr_transaction_api.get_varchar2_value

1086: l_tdb_information5 := hr_transaction_api.get_varchar2_value
1087: (p_transaction_step_id => p_transaction_step_id
1088: ,p_name => 'P_TDB_INFORMATION5');
1089:
1090: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1091: (p_transaction_step_id => p_transaction_step_id
1092: ,p_name => 'P_TDB_INFORMATION6');
1093:
1094: l_tdb_information7 := hr_transaction_api.get_varchar2_value

Line 1094: l_tdb_information7 := hr_transaction_api.get_varchar2_value

1090: l_tdb_information6 := hr_transaction_api.get_varchar2_value
1091: (p_transaction_step_id => p_transaction_step_id
1092: ,p_name => 'P_TDB_INFORMATION6');
1093:
1094: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1095: (p_transaction_step_id => p_transaction_step_id
1096: ,p_name => 'P_TDB_INFORMATION7');
1097:
1098: l_tdb_information8 := hr_transaction_api.get_varchar2_value

Line 1098: l_tdb_information8 := hr_transaction_api.get_varchar2_value

1094: l_tdb_information7 := hr_transaction_api.get_varchar2_value
1095: (p_transaction_step_id => p_transaction_step_id
1096: ,p_name => 'P_TDB_INFORMATION7');
1097:
1098: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1099: (p_transaction_step_id => p_transaction_step_id
1100: ,p_name => 'P_TDB_INFORMATION8');
1101:
1102: l_tdb_information9 := hr_transaction_api.get_varchar2_value

Line 1102: l_tdb_information9 := hr_transaction_api.get_varchar2_value

1098: l_tdb_information8 := hr_transaction_api.get_varchar2_value
1099: (p_transaction_step_id => p_transaction_step_id
1100: ,p_name => 'P_TDB_INFORMATION8');
1101:
1102: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1103: (p_transaction_step_id => p_transaction_step_id
1104: ,p_name => 'P_TDB_INFORMATION9');
1105:
1106: l_tdb_information10 := hr_transaction_api.get_varchar2_value

Line 1106: l_tdb_information10 := hr_transaction_api.get_varchar2_value

1102: l_tdb_information9 := hr_transaction_api.get_varchar2_value
1103: (p_transaction_step_id => p_transaction_step_id
1104: ,p_name => 'P_TDB_INFORMATION9');
1105:
1106: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1107: (p_transaction_step_id => p_transaction_step_id
1108: ,p_name => 'P_TDB_INFORMATION10');
1109:
1110: l_tdb_information11 := hr_transaction_api.get_varchar2_value

Line 1110: l_tdb_information11 := hr_transaction_api.get_varchar2_value

1106: l_tdb_information10 := hr_transaction_api.get_varchar2_value
1107: (p_transaction_step_id => p_transaction_step_id
1108: ,p_name => 'P_TDB_INFORMATION10');
1109:
1110: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1111: (p_transaction_step_id => p_transaction_step_id
1112: ,p_name => 'P_TDB_INFORMATION11');
1113:
1114: l_tdb_information12 := hr_transaction_api.get_varchar2_value

Line 1114: l_tdb_information12 := hr_transaction_api.get_varchar2_value

1110: l_tdb_information11 := hr_transaction_api.get_varchar2_value
1111: (p_transaction_step_id => p_transaction_step_id
1112: ,p_name => 'P_TDB_INFORMATION11');
1113:
1114: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1115: (p_transaction_step_id => p_transaction_step_id
1116: ,p_name => 'P_TDB_INFORMATION12');
1117:
1118: l_tdb_information13 := hr_transaction_api.get_varchar2_value

Line 1118: l_tdb_information13 := hr_transaction_api.get_varchar2_value

1114: l_tdb_information12 := hr_transaction_api.get_varchar2_value
1115: (p_transaction_step_id => p_transaction_step_id
1116: ,p_name => 'P_TDB_INFORMATION12');
1117:
1118: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1119: (p_transaction_step_id => p_transaction_step_id
1120: ,p_name => 'P_TDB_INFORMATION13');
1121:
1122: l_tdb_information14 := hr_transaction_api.get_varchar2_value

Line 1122: l_tdb_information14 := hr_transaction_api.get_varchar2_value

1118: l_tdb_information13 := hr_transaction_api.get_varchar2_value
1119: (p_transaction_step_id => p_transaction_step_id
1120: ,p_name => 'P_TDB_INFORMATION13');
1121:
1122: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1123: (p_transaction_step_id => p_transaction_step_id
1124: ,p_name => 'P_TDB_INFORMATION14');
1125:
1126: l_tdb_information15 := hr_transaction_api.get_varchar2_value

Line 1126: l_tdb_information15 := hr_transaction_api.get_varchar2_value

1122: l_tdb_information14 := hr_transaction_api.get_varchar2_value
1123: (p_transaction_step_id => p_transaction_step_id
1124: ,p_name => 'P_TDB_INFORMATION14');
1125:
1126: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1127: (p_transaction_step_id => p_transaction_step_id
1128: ,p_name => 'P_TDB_INFORMATION15');
1129:
1130: l_tdb_information16 := hr_transaction_api.get_varchar2_value

Line 1130: l_tdb_information16 := hr_transaction_api.get_varchar2_value

1126: l_tdb_information15 := hr_transaction_api.get_varchar2_value
1127: (p_transaction_step_id => p_transaction_step_id
1128: ,p_name => 'P_TDB_INFORMATION15');
1129:
1130: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1131: (p_transaction_step_id => p_transaction_step_id
1132: ,p_name => 'P_TDB_INFORMATION16');
1133:
1134: l_tdb_information17 := hr_transaction_api.get_varchar2_value

Line 1134: l_tdb_information17 := hr_transaction_api.get_varchar2_value

1130: l_tdb_information16 := hr_transaction_api.get_varchar2_value
1131: (p_transaction_step_id => p_transaction_step_id
1132: ,p_name => 'P_TDB_INFORMATION16');
1133:
1134: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1135: (p_transaction_step_id => p_transaction_step_id
1136: ,p_name => 'P_TDB_INFORMATION17');
1137:
1138: l_tdb_information18 := hr_transaction_api.get_varchar2_value

Line 1138: l_tdb_information18 := hr_transaction_api.get_varchar2_value

1134: l_tdb_information17 := hr_transaction_api.get_varchar2_value
1135: (p_transaction_step_id => p_transaction_step_id
1136: ,p_name => 'P_TDB_INFORMATION17');
1137:
1138: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1139: (p_transaction_step_id => p_transaction_step_id
1140: ,p_name => 'P_TDB_INFORMATION18');
1141:
1142: l_tdb_information19 := hr_transaction_api.get_varchar2_value

Line 1142: l_tdb_information19 := hr_transaction_api.get_varchar2_value

1138: l_tdb_information18 := hr_transaction_api.get_varchar2_value
1139: (p_transaction_step_id => p_transaction_step_id
1140: ,p_name => 'P_TDB_INFORMATION18');
1141:
1142: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1143: (p_transaction_step_id => p_transaction_step_id
1144: ,p_name => 'P_TDB_INFORMATION19');
1145:
1146: l_tdb_information20 := hr_transaction_api.get_varchar2_value

Line 1146: l_tdb_information20 := hr_transaction_api.get_varchar2_value

1142: l_tdb_information19 := hr_transaction_api.get_varchar2_value
1143: (p_transaction_step_id => p_transaction_step_id
1144: ,p_name => 'P_TDB_INFORMATION19');
1145:
1146: l_tdb_information20 := hr_transaction_api.get_varchar2_value
1147: (p_transaction_step_id => p_transaction_step_id
1148: ,p_name => 'P_TDB_INFORMATION20');
1149:
1150:

Line 1410: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1406: end if;
1407:
1408: ELSIF l_from = 'APPROVE' then -- update enrollment and create finance line if profile is set to YES
1409:
1410: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1411: (p_transaction_step_id => p_transaction_step_id
1412: ,p_name => 'P_EVENTID'));
1413:
1414:

Line 1416: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1412: ,p_name => 'P_EVENTID'));
1413:
1414:
1415: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
1416: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1417: (p_transaction_step_id => p_transaction_step_id
1418: -- ,p_name => 'P_PERSON_ID'));
1419: ,p_name => 'P_DELEGATE_PERSON_ID'));
1420:

Line 1521: l_cost_allocation_keyflex_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1517: IF l_auto_create_finance = 'Y' and
1518: l_price_basis <> 'N' and
1519: l_event_currency_code is not null THEN
1520:
1521: l_cost_allocation_keyflex_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1522: (p_transaction_step_id => p_transaction_step_id
1523: ,p_name => 'P_KEYFLEXID'));
1524:
1525:

Line 1526: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value

1522: (p_transaction_step_id => p_transaction_step_id
1523: ,p_name => 'P_KEYFLEXID'));
1524:
1525:
1526: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value
1527: (p_transaction_step_id => p_transaction_step_id
1528: ,p_name => 'P_BUSINESSGROUPID'));
1529:
1530: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

Line 1530: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1526: l_business_group_id_from := TO_NUMBER(hr_transaction_api.get_varchar2_value
1527: (p_transaction_step_id => p_transaction_step_id
1528: ,p_name => 'P_BUSINESSGROUPID'));
1529:
1530: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1531: (p_transaction_step_id => p_transaction_step_id
1532: ,p_name => 'P_ASSIGNMENTID'));
1533:
1534: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

Line 1534: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value

1530: l_assignment_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1531: (p_transaction_step_id => p_transaction_step_id
1532: ,p_name => 'P_ASSIGNMENTID'));
1533:
1534: l_organization_id := TO_NUMBER(hr_transaction_api.get_varchar2_value
1535: (p_transaction_step_id => p_transaction_step_id
1536: ,p_name => 'P_ORGANIZATIONID'));
1537:
1538: -- --------------------------------------------

Line 1820: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1816:
1817: if ( funmode = 'RUN' ) then
1818:
1819: /* Bug#2258423 hdshah read event id from workflow instead of transaction table
1820: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1821: (p_transaction_step_id => l_transaction_step_id
1822: ,p_name => 'P_EVENTID'));
1823: */
1824:

Line 1831: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value

1827: ,aname => 'OTA_EVENT_ID');
1828:
1829: /* Bug#2258423 hdshah read delegate person id from workflow instead of transaction table
1830: -- hdshah Bug#2213380 read delegate_person_id from p_delegate_person_id instead of p_person_id
1831: l_delegate_id := TO_NUMBER(hr_transaction_api.get_number_Value
1832: (p_transaction_step_id => l_transaction_step_id
1833: -- ,p_name => 'P_PERSON_ID'));
1834: ,p_name => 'P_DELEGATE_PERSON_ID'));
1835: */

Line 1896: /* hr_transaction_api.get_transaction_step_info

1892: ,itemkey => p_item_key
1893: ,aname => 'OTA_TRANSACTION_STEP_ID');
1894:
1895: -- Code added for Bug#2782175
1896: /* hr_transaction_api.get_transaction_step_info
1897: (p_transaction_step_id => l_transaction_step_id
1898: ,p_item_type => l_dummy_item_type
1899: ,p_item_key => l_dummy_item_key
1900: ,p_activity_id => l_activity_id);

Line 1910: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value

1906:
1907:
1908: if l_approval_mode = 'YES_DYNAMIC' then
1909:
1910: l_eventid := TO_NUMBER(hr_transaction_api.get_varchar2_value
1911: (p_transaction_step_id => l_transaction_step_id
1912: ,p_name => 'P_EVENTID'));
1913:
1914: hr_approval_wf.create_item_attrib_if_notexist