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.BEN_CREATE_PTNL_LER_SS dependencies on HR_TRANSACTION_API

Line 322: hr_transaction_api.create_transaction_step

318: -- otherwise just update the current step
319: if( l_transaction_step_id is null) then
320: -- Create a transaction step
321: --
322: hr_transaction_api.create_transaction_step
323: (p_validate => false
324: ,p_creator_person_id => nvl(p_login_person_id, p_person_id) -- PB : Modification
325: ,p_transaction_id => l_transaction_id
326: ,p_api_name => g_package || '.PROCESS_API'

Line 685: p_csd_by_ptnl_ler_for_per_id:= hr_transaction_api.get_number_value

681: begin
682: hr_utility.set_location('Entering:'|| l_proc, 5);
683:
684: --
685: p_csd_by_ptnl_ler_for_per_id:= hr_transaction_api.get_number_value
686: (p_transaction_step_id => p_transaction_step_id
687: ,p_name => 'P_CSD_BY_PTNL_LER_FOR_PER_ID');
688: --
689: p_lf_evt_ocrd_dt := hr_transaction_api.get_date_value

Line 689: p_lf_evt_ocrd_dt := hr_transaction_api.get_date_value

685: p_csd_by_ptnl_ler_for_per_id:= hr_transaction_api.get_number_value
686: (p_transaction_step_id => p_transaction_step_id
687: ,p_name => 'P_CSD_BY_PTNL_LER_FOR_PER_ID');
688: --
689: p_lf_evt_ocrd_dt := hr_transaction_api.get_date_value
690: (p_transaction_step_id => p_transaction_step_id
691: ,p_name => 'P_LF_EVT_OCRD_DT');
692: --
693: p_ptnl_ler_for_per_stat_cd := hr_transaction_api.get_varchar2_value

Line 693: p_ptnl_ler_for_per_stat_cd := hr_transaction_api.get_varchar2_value

689: p_lf_evt_ocrd_dt := hr_transaction_api.get_date_value
690: (p_transaction_step_id => p_transaction_step_id
691: ,p_name => 'P_LF_EVT_OCRD_DT');
692: --
693: p_ptnl_ler_for_per_stat_cd := hr_transaction_api.get_varchar2_value
694: (p_transaction_step_id => p_transaction_step_id
695: ,p_name => 'P_PTNL_LER_FOR_PER_STAT_CD');
696: --
697: p_ptnl_ler_for_per_src_cd := hr_transaction_api.get_varchar2_value

Line 697: p_ptnl_ler_for_per_src_cd := hr_transaction_api.get_varchar2_value

693: p_ptnl_ler_for_per_stat_cd := hr_transaction_api.get_varchar2_value
694: (p_transaction_step_id => p_transaction_step_id
695: ,p_name => 'P_PTNL_LER_FOR_PER_STAT_CD');
696: --
697: p_ptnl_ler_for_per_src_cd := hr_transaction_api.get_varchar2_value
698: (p_transaction_step_id => p_transaction_step_id
699: ,p_name => 'P_PTNL_LER_FOR_PER_SRC_CD');
700: --
701: p_mnl_dt := hr_transaction_api.get_date_value

Line 701: p_mnl_dt := hr_transaction_api.get_date_value

697: p_ptnl_ler_for_per_src_cd := hr_transaction_api.get_varchar2_value
698: (p_transaction_step_id => p_transaction_step_id
699: ,p_name => 'P_PTNL_LER_FOR_PER_SRC_CD');
700: --
701: p_mnl_dt := hr_transaction_api.get_date_value
702: (p_transaction_step_id => p_transaction_step_id
703: ,p_name => 'P_MNL_DT');
704: --
705: p_enrt_perd_id := hr_transaction_api.get_number_value

Line 705: p_enrt_perd_id := hr_transaction_api.get_number_value

701: p_mnl_dt := hr_transaction_api.get_date_value
702: (p_transaction_step_id => p_transaction_step_id
703: ,p_name => 'P_MNL_DT');
704: --
705: p_enrt_perd_id := hr_transaction_api.get_number_value
706: (p_transaction_step_id => p_transaction_step_id
707: ,p_name => 'P_ENRT_PERD_ID');
708:
709: --

Line 710: p_ler_id := hr_transaction_api.get_number_value

706: (p_transaction_step_id => p_transaction_step_id
707: ,p_name => 'P_ENRT_PERD_ID');
708:
709: --
710: p_ler_id := hr_transaction_api.get_number_value
711: (p_transaction_step_id => p_transaction_step_id
712: ,p_name => 'P_LER_ID');
713: --
714: p_person_id :=

Line 715: hr_transaction_api.get_number_value

711: (p_transaction_step_id => p_transaction_step_id
712: ,p_name => 'P_LER_ID');
713: --
714: p_person_id :=
715: hr_transaction_api.get_number_value
716: (p_transaction_step_id => p_transaction_step_id
717: ,p_name => 'P_PERSON_ID');
718: --
719: p_business_group_id :=

Line 720: hr_transaction_api.get_number_value

716: (p_transaction_step_id => p_transaction_step_id
717: ,p_name => 'P_PERSON_ID');
718: --
719: p_business_group_id :=
720: hr_transaction_api.get_number_value
721: (p_transaction_step_id => p_transaction_step_id
722: ,p_name => 'P_BUSINESS_GROUP_ID');
723: --
724: p_dtctd_dt :=

Line 725: hr_transaction_api.get_date_value

721: (p_transaction_step_id => p_transaction_step_id
722: ,p_name => 'P_BUSINESS_GROUP_ID');
723: --
724: p_dtctd_dt :=
725: hr_transaction_api.get_date_value
726: (p_transaction_step_id => p_transaction_step_id
727: ,p_name => 'P_DTCTD_DT');
728:
729:

Line 731: hr_transaction_api.get_date_value

727: ,p_name => 'P_DTCTD_DT');
728:
729:
730: p_procd_dt :=
731: hr_transaction_api.get_date_value
732: (p_transaction_step_id => p_transaction_step_id
733: ,p_name => 'P_PROCD_DT');
734: --
735: p_unprocd_dt :=

Line 736: hr_transaction_api.get_date_value

732: (p_transaction_step_id => p_transaction_step_id
733: ,p_name => 'P_PROCD_DT');
734: --
735: p_unprocd_dt :=
736: hr_transaction_api.get_date_value
737: (p_transaction_step_id => p_transaction_step_id
738: ,p_name => 'P_UNPROCD_DT');
739: --
740: p_voidd_dt :=

Line 741: hr_transaction_api.get_date_value

737: (p_transaction_step_id => p_transaction_step_id
738: ,p_name => 'P_UNPROCD_DT');
739: --
740: p_voidd_dt :=
741: hr_transaction_api.get_date_value
742: (p_transaction_step_id => p_transaction_step_id
743: ,p_name => 'P_VOIDD_DT');
744: --
745: p_mnlo_dt :=

Line 746: hr_transaction_api.get_date_value

742: (p_transaction_step_id => p_transaction_step_id
743: ,p_name => 'P_VOIDD_DT');
744: --
745: p_mnlo_dt :=
746: hr_transaction_api.get_date_value
747: (p_transaction_step_id => p_transaction_step_id
748: ,p_name => 'P_MNLO_DT');
749: --
750: p_ntfn_dt :=

Line 751: hr_transaction_api.get_date_value

747: (p_transaction_step_id => p_transaction_step_id
748: ,p_name => 'P_MNLO_DT');
749: --
750: p_ntfn_dt :=
751: hr_transaction_api.get_date_value
752: (p_transaction_step_id => p_transaction_step_id
753: ,p_name => 'P_NTFN_DT');
754: --
755: p_request_id :=

Line 756: hr_transaction_api.get_number_value

752: (p_transaction_step_id => p_transaction_step_id
753: ,p_name => 'P_NTFN_DT');
754: --
755: p_request_id :=
756: hr_transaction_api.get_number_value
757: (p_transaction_step_id => p_transaction_step_id
758: ,p_name => 'P_REQUEST_ID');
759: --
760: p_program_application_id :=

Line 761: hr_transaction_api.get_number_value

757: (p_transaction_step_id => p_transaction_step_id
758: ,p_name => 'P_REQUEST_ID');
759: --
760: p_program_application_id :=
761: hr_transaction_api.get_number_value
762: (p_transaction_step_id => p_transaction_step_id
763: ,p_name => 'P_PROGRAM_APPLICATION_ID');
764: --
765: p_program_id :=

Line 766: hr_transaction_api.get_number_value

762: (p_transaction_step_id => p_transaction_step_id
763: ,p_name => 'P_PROGRAM_APPLICATION_ID');
764: --
765: p_program_id :=
766: hr_transaction_api.get_number_value
767: (p_transaction_step_id => p_transaction_step_id
768: ,p_name => 'P_PROGRAM_ID');
769: --
770: p_program_update_date :=

Line 771: hr_transaction_api.get_date_value

767: (p_transaction_step_id => p_transaction_step_id
768: ,p_name => 'P_PROGRAM_ID');
769: --
770: p_program_update_date :=
771: hr_transaction_api.get_date_value
772: (p_transaction_step_id => p_transaction_step_id
773: ,p_name => 'P_PROGRAM_UPDATE_DATE');
774: --
775: p_effective_date :=

Line 776: hr_transaction_api.get_date_value

772: (p_transaction_step_id => p_transaction_step_id
773: ,p_name => 'P_PROGRAM_UPDATE_DATE');
774: --
775: p_effective_date :=
776: hr_transaction_api.get_date_value
777: (p_transaction_step_id => p_transaction_step_id
778: ,p_name => 'P_EFFECTIVE_DATE');
779:
780: --

Line 783: hr_transaction_api.get_varchar2_value

779:
780: --
781: /*
782: p_flow_mode :=
783: hr_transaction_api.get_varchar2_value
784: (p_transaction_step_id => p_transaction_step_id
785: ,p_name => 'P_FLOW_MODE');
786:
787: --

Line 789: hr_transaction_api.get_varchar2_value

785: ,p_name => 'P_FLOW_MODE');
786:
787: --
788: p_subflow_mode :=
789: hr_transaction_api.get_varchar2_value
790: (p_transaction_step_id => p_transaction_step_id
791: ,p_name => 'P_SUBFLOW_MODE');
792:
793: */

Line 796: hr_transaction_api.get_varchar2_value

792:
793: */
794: --
795: p_life_event_name :=
796: hr_transaction_api.get_varchar2_value
797: (p_transaction_step_id => p_transaction_step_id
798: ,p_name => 'P_LIFE_EVENT_NAME');
799:
800: hr_utility.set_location('Leaving:'|| l_proc, 10);

Line 851: hr_transaction_api.get_number_value

847: end if;
848: --
849: if l_ptnl_ler.person_id is null then
850: l_ptnl_ler.person_id :=
851: hr_transaction_api.get_number_value
852: (p_transaction_step_id => p_transaction_step_id
853: ,p_name => 'P_PERSON_ID');
854: end if;
855:

Line 860: l_ptnl_ler.csd_by_ptnl_ler_for_per_id:= hr_transaction_api.get_number_value

856: if l_ptnl_ler.person_id is null then
857: null;
858: else
859: --
860: l_ptnl_ler.csd_by_ptnl_ler_for_per_id:= hr_transaction_api.get_number_value
861: (p_transaction_step_id => p_transaction_step_id
862: ,p_name => 'P_CSD_BY_PTNL_LER_FOR_PER_ID');
863: --
864: l_ptnl_ler.lf_evt_ocrd_dt := hr_transaction_api.get_date_value

Line 864: l_ptnl_ler.lf_evt_ocrd_dt := hr_transaction_api.get_date_value

860: l_ptnl_ler.csd_by_ptnl_ler_for_per_id:= hr_transaction_api.get_number_value
861: (p_transaction_step_id => p_transaction_step_id
862: ,p_name => 'P_CSD_BY_PTNL_LER_FOR_PER_ID');
863: --
864: l_ptnl_ler.lf_evt_ocrd_dt := hr_transaction_api.get_date_value
865: (p_transaction_step_id => p_transaction_step_id
866: ,p_name => 'P_LF_EVT_OCRD_DT');
867: --
868: l_ptnl_ler.ptnl_ler_for_per_stat_cd := hr_transaction_api.get_varchar2_value

Line 868: l_ptnl_ler.ptnl_ler_for_per_stat_cd := hr_transaction_api.get_varchar2_value

864: l_ptnl_ler.lf_evt_ocrd_dt := hr_transaction_api.get_date_value
865: (p_transaction_step_id => p_transaction_step_id
866: ,p_name => 'P_LF_EVT_OCRD_DT');
867: --
868: l_ptnl_ler.ptnl_ler_for_per_stat_cd := hr_transaction_api.get_varchar2_value
869: (p_transaction_step_id => p_transaction_step_id
870: ,p_name => 'P_PTNL_LER_FOR_PER_STAT_CD');
871: --
872: l_ptnl_ler.ptnl_ler_for_per_src_cd := hr_transaction_api.get_varchar2_value

Line 872: l_ptnl_ler.ptnl_ler_for_per_src_cd := hr_transaction_api.get_varchar2_value

868: l_ptnl_ler.ptnl_ler_for_per_stat_cd := hr_transaction_api.get_varchar2_value
869: (p_transaction_step_id => p_transaction_step_id
870: ,p_name => 'P_PTNL_LER_FOR_PER_STAT_CD');
871: --
872: l_ptnl_ler.ptnl_ler_for_per_src_cd := hr_transaction_api.get_varchar2_value
873: (p_transaction_step_id => p_transaction_step_id
874: ,p_name => 'P_PTNL_LER_FOR_PER_SRC_CD');
875: --
876: l_ptnl_ler.mnl_dt := hr_transaction_api.get_date_value

Line 876: l_ptnl_ler.mnl_dt := hr_transaction_api.get_date_value

872: l_ptnl_ler.ptnl_ler_for_per_src_cd := hr_transaction_api.get_varchar2_value
873: (p_transaction_step_id => p_transaction_step_id
874: ,p_name => 'P_PTNL_LER_FOR_PER_SRC_CD');
875: --
876: l_ptnl_ler.mnl_dt := hr_transaction_api.get_date_value
877: (p_transaction_step_id => p_transaction_step_id
878: ,p_name => 'P_MNL_DT');
879: --
880: l_ptnl_ler.enrt_perd_id := hr_transaction_api.get_number_value

Line 880: l_ptnl_ler.enrt_perd_id := hr_transaction_api.get_number_value

876: l_ptnl_ler.mnl_dt := hr_transaction_api.get_date_value
877: (p_transaction_step_id => p_transaction_step_id
878: ,p_name => 'P_MNL_DT');
879: --
880: l_ptnl_ler.enrt_perd_id := hr_transaction_api.get_number_value
881: (p_transaction_step_id => p_transaction_step_id
882: ,p_name => 'P_ENRT_PERD_ID');
883:
884: --

Line 885: l_ptnl_ler.ler_id := hr_transaction_api.get_number_value

881: (p_transaction_step_id => p_transaction_step_id
882: ,p_name => 'P_ENRT_PERD_ID');
883:
884: --
885: l_ptnl_ler.ler_id := hr_transaction_api.get_number_value
886: (p_transaction_step_id => p_transaction_step_id
887: ,p_name => 'P_LER_ID');
888: --
889: l_ptnl_ler.business_group_id :=

Line 890: hr_transaction_api.get_number_value

886: (p_transaction_step_id => p_transaction_step_id
887: ,p_name => 'P_LER_ID');
888: --
889: l_ptnl_ler.business_group_id :=
890: hr_transaction_api.get_number_value
891: (p_transaction_step_id => p_transaction_step_id
892: ,p_name => 'P_BUSINESS_GROUP_ID');
893: --
894: l_ptnl_ler.dtctd_dt :=

Line 895: hr_transaction_api.get_date_value

891: (p_transaction_step_id => p_transaction_step_id
892: ,p_name => 'P_BUSINESS_GROUP_ID');
893: --
894: l_ptnl_ler.dtctd_dt :=
895: hr_transaction_api.get_date_value
896: (p_transaction_step_id => p_transaction_step_id
897: ,p_name => 'P_DTCTD_DT');
898:
899:

Line 901: hr_transaction_api.get_date_value

897: ,p_name => 'P_DTCTD_DT');
898:
899:
900: l_ptnl_ler.procd_dt :=
901: hr_transaction_api.get_date_value
902: (p_transaction_step_id => p_transaction_step_id
903: ,p_name => 'P_PROCD_DT');
904: --
905: l_ptnl_ler.unprocd_dt :=

Line 906: hr_transaction_api.get_date_value

902: (p_transaction_step_id => p_transaction_step_id
903: ,p_name => 'P_PROCD_DT');
904: --
905: l_ptnl_ler.unprocd_dt :=
906: hr_transaction_api.get_date_value
907: (p_transaction_step_id => p_transaction_step_id
908: ,p_name => 'P_UNPROCD_DT');
909: --
910: l_ptnl_ler.voidd_dt :=

Line 911: hr_transaction_api.get_date_value

907: (p_transaction_step_id => p_transaction_step_id
908: ,p_name => 'P_UNPROCD_DT');
909: --
910: l_ptnl_ler.voidd_dt :=
911: hr_transaction_api.get_date_value
912: (p_transaction_step_id => p_transaction_step_id
913: ,p_name => 'P_VOIDD_DT');
914: --
915: l_ptnl_ler.mnlo_dt :=

Line 916: hr_transaction_api.get_date_value

912: (p_transaction_step_id => p_transaction_step_id
913: ,p_name => 'P_VOIDD_DT');
914: --
915: l_ptnl_ler.mnlo_dt :=
916: hr_transaction_api.get_date_value
917: (p_transaction_step_id => p_transaction_step_id
918: ,p_name => 'P_MNLO_DT');
919: --
920: l_ptnl_ler.ntfn_dt :=

Line 921: hr_transaction_api.get_date_value

917: (p_transaction_step_id => p_transaction_step_id
918: ,p_name => 'P_MNLO_DT');
919: --
920: l_ptnl_ler.ntfn_dt :=
921: hr_transaction_api.get_date_value
922: (p_transaction_step_id => p_transaction_step_id
923: ,p_name => 'P_NTFN_DT');
924: --
925: l_ptnl_ler.request_id :=

Line 926: hr_transaction_api.get_number_value

922: (p_transaction_step_id => p_transaction_step_id
923: ,p_name => 'P_NTFN_DT');
924: --
925: l_ptnl_ler.request_id :=
926: hr_transaction_api.get_number_value
927: (p_transaction_step_id => p_transaction_step_id
928: ,p_name => 'P_REQUEST_ID');
929: --
930: l_ptnl_ler.program_application_id :=

Line 931: hr_transaction_api.get_number_value

927: (p_transaction_step_id => p_transaction_step_id
928: ,p_name => 'P_REQUEST_ID');
929: --
930: l_ptnl_ler.program_application_id :=
931: hr_transaction_api.get_number_value
932: (p_transaction_step_id => p_transaction_step_id
933: ,p_name => 'P_PROGRAM_APPLICATION_ID');
934: --
935: l_ptnl_ler.program_id :=

Line 936: hr_transaction_api.get_number_value

932: (p_transaction_step_id => p_transaction_step_id
933: ,p_name => 'P_PROGRAM_APPLICATION_ID');
934: --
935: l_ptnl_ler.program_id :=
936: hr_transaction_api.get_number_value
937: (p_transaction_step_id => p_transaction_step_id
938: ,p_name => 'P_PROGRAM_ID');
939: --
940: l_ptnl_ler.program_update_date :=

Line 941: hr_transaction_api.get_date_value

937: (p_transaction_step_id => p_transaction_step_id
938: ,p_name => 'P_PROGRAM_ID');
939: --
940: l_ptnl_ler.program_update_date :=
941: hr_transaction_api.get_date_value
942: (p_transaction_step_id => p_transaction_step_id
943: ,p_name => 'P_PROGRAM_UPDATE_DATE');
944: --
945: l_effective_date :=

Line 946: hr_transaction_api.get_date_value

942: (p_transaction_step_id => p_transaction_step_id
943: ,p_name => 'P_PROGRAM_UPDATE_DATE');
944: --
945: l_effective_date :=
946: hr_transaction_api.get_date_value
947: (p_transaction_step_id => p_transaction_step_id
948: ,p_name => 'P_EFFECTIVE_DATE');
949:
950: --

Line 954: hr_transaction_api.get_varchar2_value

950: --
951: -- These two can be removed if not used in the future.
952: /*
953: l_ptnl_ler.p_flow_mode :=
954: hr_transaction_api.get_varchar2_value
955: (p_transaction_step_id => p_transaction_step_id
956: ,p_name => 'P_FLOW_MODE');
957: --
958: l_ptnl_ler.p_life_event_name :=

Line 959: hr_transaction_api.get_varchar2_value

955: (p_transaction_step_id => p_transaction_step_id
956: ,p_name => 'P_FLOW_MODE');
957: --
958: l_ptnl_ler.p_life_event_name :=
959: hr_transaction_api.get_varchar2_value
960: (p_transaction_step_id => p_transaction_step_id
961: ,p_name => 'P_LIFE_EVENT_NAME');
962: */
963:

Line 1034: hr_transaction_api.get_varchar2_value

1030:
1031: -- check if the step exists for the particular subflow
1032: loop
1033: l_subflow_mode :=
1034: hr_transaction_api.get_varchar2_value
1035: (p_transaction_step_id => p_transaction_step_id
1036: ,p_name => 'P_SUBFLOW_MODE');
1037: exit when l_subflow_mode = p_subflow_mode ;
1038: fetch transaction_step into p_transaction_step_id,p_object_version_number;