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.HRDPP_UPDATE_PERSON dependencies on HR_PUMP_GET

Line 546: hr_pump_get.gl(l.pval010,'HOME_OFFICE',d(l.pval001),l.pval138)) p10,

542: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
543: l.pval008 d8,
544: decode(l.pval009,cn,vn,l.pval009) p9,
545: decode(l.pval010,cn,vn,vn,vh,
546: hr_pump_get.gl(l.pval010,'HOME_OFFICE',d(l.pval001),l.pval138)) p10,
547: l.pval010 d10,
548: decode(l.pval011,cn,vn,vn,vh,l.pval011) p11,
549: l.pval011 d11,
550: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,

Line 553: hr_pump_get.gl(l.pval013,'MAR_STATUS',d(l.pval001),l.pval138)) p13,

549: l.pval011 d11,
550: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
551: l.pval012 d12,
552: decode(l.pval013,cn,vn,vn,vh,
553: hr_pump_get.gl(l.pval013,'MAR_STATUS',d(l.pval001),l.pval138)) p13,
554: l.pval013 d13,
555: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
556: l.pval014 d14,
557: decode(l.pval015,cn,vn,vn,vh,

Line 558: hr_pump_get.gl(l.pval015,'NATIONALITY',d(l.pval001),l.pval138)) p15,

554: l.pval013 d13,
555: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
556: l.pval014 d14,
557: decode(l.pval015,cn,vn,vn,vh,
558: hr_pump_get.gl(l.pval015,'NATIONALITY',d(l.pval001),l.pval138)) p15,
559: l.pval015 d15,
560: decode(l.pval016,cn,vn,vn,vh,l.pval016) p16,
561: l.pval016 d16,
562: decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,

Line 565: hr_pump_get.gl(l.pval018,'REGISTERED_DISABLED',d(l.pval001),l.pval138)) p18,

561: l.pval016 d16,
562: decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,
563: l.pval017 d17,
564: decode(l.pval018,cn,vn,vn,vh,
565: hr_pump_get.gl(l.pval018,'REGISTERED_DISABLED',d(l.pval001),l.pval138)) p18,
566: l.pval018 d18,
567: decode(l.pval019,cn,vn,vn,vh,
568: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval138)) p19,
569: l.pval019 d19,

Line 568: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval138)) p19,

564: decode(l.pval018,cn,vn,vn,vh,
565: hr_pump_get.gl(l.pval018,'REGISTERED_DISABLED',d(l.pval001),l.pval138)) p18,
566: l.pval018 d18,
567: decode(l.pval019,cn,vn,vn,vh,
568: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval138)) p19,
569: l.pval019 d19,
570: decode(l.pval020,cn,vn,vn,vh,
571: hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval138)) p20,
572: l.pval020 d20,

Line 571: hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval138)) p20,

567: decode(l.pval019,cn,vn,vn,vh,
568: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval138)) p19,
569: l.pval019 d19,
570: decode(l.pval020,cn,vn,vn,vh,
571: hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval138)) p20,
572: l.pval020 d20,
573: decode(l.pval021,cn,vn,vn,vh,l.pval021) p21,
574: l.pval021 d21,
575: decode(l.pval022,cn,vn,vn,vh,l.pval022) p22,

Line 702: hr_pump_get.gl(l.pval085,'YES_NO',d(l.pval001),l.pval138)) p85,

698: l.pval083 d83,
699: decode(l.pval084,cn,dn,vn,dh,d(l.pval084)) p84,
700: l.pval084 d84,
701: decode(l.pval085,cn,vn,vn,vh,
702: hr_pump_get.gl(l.pval085,'YES_NO',d(l.pval001),l.pval138)) p85,
703: l.pval085 d85,
704: decode(l.pval086,cn,dn,vn,dh,d(l.pval086)) p86,
705: l.pval086 d86,
706: decode(l.pval087,cn,vn,vn,vh,

Line 707: hr_pump_get.gl(l.pval087,'BLOOD_TYPE',d(l.pval001),l.pval138)) p87,

703: l.pval085 d85,
704: decode(l.pval086,cn,dn,vn,dh,d(l.pval086)) p86,
705: l.pval086 d86,
706: decode(l.pval087,cn,vn,vn,vh,
707: hr_pump_get.gl(l.pval087,'BLOOD_TYPE',d(l.pval001),l.pval138)) p87,
708: l.pval087 d87,
709: decode(l.pval088,cn,vn,vn,vh,l.pval088) p88,
710: l.pval088 d88,
711: decode(l.pval089,cn,nn,vn,nh,n(l.pval089)) p89,

Line 728: hr_pump_get.gl(l.pval097,'YES_NO',d(l.pval001),l.pval138)) p97,

724: l.pval095 d95,
725: decode(l.pval096,cn,vn,vn,vh,l.pval096) p96,
726: l.pval096 d96,
727: decode(l.pval097,cn,vn,vn,vh,
728: hr_pump_get.gl(l.pval097,'YES_NO',d(l.pval001),l.pval138)) p97,
729: l.pval097 d97,
730: decode(l.pval098,cn,vn,vn,vh,l.pval098) p98,
731: l.pval098 d98,
732: decode(l.pval099,cn,dn,vn,dh,d(l.pval099)) p99,

Line 737: hr_pump_get.gl(l.pval101,'YES_NO',d(l.pval001),l.pval138)) p101,

733: l.pval099 d99,
734: decode(l.pval100,cn,vn,vn,vh,l.pval100) p100,
735: l.pval100 d100,
736: decode(l.pval101,cn,vn,vn,vh,
737: hr_pump_get.gl(l.pval101,'YES_NO',d(l.pval001),l.pval138)) p101,
738: l.pval101 d101,
739: decode(l.pval102,cn,vn,vn,vh,
740: hr_pump_get.gl(l.pval102,'YES_NO',d(l.pval001),l.pval138)) p102,
741: l.pval102 d102,

Line 740: hr_pump_get.gl(l.pval102,'YES_NO',d(l.pval001),l.pval138)) p102,

736: decode(l.pval101,cn,vn,vn,vh,
737: hr_pump_get.gl(l.pval101,'YES_NO',d(l.pval001),l.pval138)) p101,
738: l.pval101 d101,
739: decode(l.pval102,cn,vn,vn,vh,
740: hr_pump_get.gl(l.pval102,'YES_NO',d(l.pval001),l.pval138)) p102,
741: l.pval102 d102,
742: decode(l.pval103,cn,dn,vn,dh,d(l.pval103)) p103,
743: l.pval103 d103,
744: decode(l.pval104,cn,vn,vn,vh,

Line 745: hr_pump_get.gl(l.pval104,'YES_NO',d(l.pval001),l.pval138)) p104,

741: l.pval102 d102,
742: decode(l.pval103,cn,dn,vn,dh,d(l.pval103)) p103,
743: l.pval103 d103,
744: decode(l.pval104,cn,vn,vn,vh,
745: hr_pump_get.gl(l.pval104,'YES_NO',d(l.pval001),l.pval138)) p104,
746: l.pval104 d104,
747: decode(l.pval105,cn,vn,vn,vh,
748: hr_pump_get.gl(l.pval105,'STUDENT_STATUS',d(l.pval001),l.pval138)) p105,
749: l.pval105 d105,

Line 748: hr_pump_get.gl(l.pval105,'STUDENT_STATUS',d(l.pval001),l.pval138)) p105,

744: decode(l.pval104,cn,vn,vn,vh,
745: hr_pump_get.gl(l.pval104,'YES_NO',d(l.pval001),l.pval138)) p104,
746: l.pval104 d104,
747: decode(l.pval105,cn,vn,vn,vh,
748: hr_pump_get.gl(l.pval105,'STUDENT_STATUS',d(l.pval001),l.pval138)) p105,
749: l.pval105 d105,
750: decode(l.pval106,cn,vn,vn,vh,
751: hr_pump_get.gl(l.pval106,'WORK_SCHEDULE',d(l.pval001),l.pval138)) p106,
752: l.pval106 d106,

Line 751: hr_pump_get.gl(l.pval106,'WORK_SCHEDULE',d(l.pval001),l.pval138)) p106,

747: decode(l.pval105,cn,vn,vn,vh,
748: hr_pump_get.gl(l.pval105,'STUDENT_STATUS',d(l.pval001),l.pval138)) p105,
749: l.pval105 d105,
750: decode(l.pval106,cn,vn,vn,vh,
751: hr_pump_get.gl(l.pval106,'WORK_SCHEDULE',d(l.pval001),l.pval138)) p106,
752: l.pval106 d106,
753: decode(l.pval107,cn,vn,vn,vh,l.pval107) p107,
754: l.pval107 d107,
755: decode(l.pval108,cn,vn,vn,vh,l.pval108) p108,

Line 846: hr_pump_get.get_person_id

842: if c.p136 is null then
843: L_PERSON_ID:=nn;
844: else
845: L_PERSON_ID :=
846: hr_pump_get.get_person_id
847: (P_PERSON_USER_KEY => c.p136);
848: end if;
849: --
850: if c.p136 is null or

Line 855: hr_pump_get.GET_PER_OVN

851: c.p1 is null then
852: L_OBJECT_VERSION_NUMBER:=nn;
853: else
854: L_OBJECT_VERSION_NUMBER :=
855: hr_pump_get.GET_PER_OVN
856: (P_PERSON_USER_KEY => c.p136
857: ,P_EFFECTIVE_DATE => c.p1);
858: end if;
859: --

Line 868: hr_pump_get.get_person_type_id

864: c.d138 is null then
865: L_PERSON_TYPE_ID:=nh;
866: else
867: L_PERSON_TYPE_ID :=
868: hr_pump_get.get_person_type_id
869: (P_USER_PERSON_TYPE => c.p137
870: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
871: ,P_LANGUAGE_CODE => c.p138);
872: end if;

Line 880: hr_pump_get.get_vendor_id

876: elsif c.d139 is null then
877: L_VENDOR_ID:=nh;
878: else
879: L_VENDOR_ID :=
880: hr_pump_get.get_vendor_id
881: (P_VENDOR_NAME => c.p139);
882: end if;
883: --
884: if c.d140=cn then

Line 890: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE

886: elsif c.d140 is null then
887: L_CORRESPONDENCE_LANGUAGE:=vh;
888: else
889: L_CORRESPONDENCE_LANGUAGE :=
890: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
891: (P_CORRESPONDENCE_LANGUAGE => c.p140);
892: end if;
893: --
894: if c.d141=cn then

Line 900: hr_pump_get.get_benefit_group_id

896: elsif c.d141 is null then
897: L_BENEFIT_GROUP_ID:=nh;
898: else
899: L_BENEFIT_GROUP_ID :=
900: hr_pump_get.get_benefit_group_id
901: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
902: ,P_BENEFIT_GROUP => c.p141);
903: end if;
904: --