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_MX_PERSON dependencies on HR_PUMP_GET

Line 468: hr_pump_get.gl(l.pval010,'HOME_OFFICE',d(l.pval001),l.pval112)) p10,

464: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
465: l.pval008 d8,
466: decode(l.pval009,cn,vn,l.pval009) p9,
467: decode(l.pval010,cn,vn,vn,vh,
468: hr_pump_get.gl(l.pval010,'HOME_OFFICE',d(l.pval001),l.pval112)) p10,
469: l.pval010 d10,
470: decode(l.pval011,cn,vn,vn,vh,l.pval011) p11,
471: l.pval011 d11,
472: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,

Line 475: hr_pump_get.gl(l.pval013,'MAR_STATUS',d(l.pval001),l.pval112)) p13,

471: l.pval011 d11,
472: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
473: l.pval012 d12,
474: decode(l.pval013,cn,vn,vn,vh,
475: hr_pump_get.gl(l.pval013,'MAR_STATUS',d(l.pval001),l.pval112)) p13,
476: l.pval013 d13,
477: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
478: l.pval014 d14,
479: decode(l.pval015,cn,vn,vn,vh,

Line 480: hr_pump_get.gl(l.pval015,'NATIONALITY',d(l.pval001),l.pval112)) p15,

476: l.pval013 d13,
477: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
478: l.pval014 d14,
479: decode(l.pval015,cn,vn,vn,vh,
480: hr_pump_get.gl(l.pval015,'NATIONALITY',d(l.pval001),l.pval112)) p15,
481: l.pval015 d15,
482: decode(l.pval016,cn,vn,vn,vh,l.pval016) p16,
483: l.pval016 d16,
484: decode(l.pval017,cn,vn,vn,vh,

Line 485: hr_pump_get.gl(l.pval017,'REGISTERED_DISABLED',d(l.pval001),l.pval112)) p17,

481: l.pval015 d15,
482: decode(l.pval016,cn,vn,vn,vh,l.pval016) p16,
483: l.pval016 d16,
484: decode(l.pval017,cn,vn,vn,vh,
485: hr_pump_get.gl(l.pval017,'REGISTERED_DISABLED',d(l.pval001),l.pval112)) p17,
486: l.pval017 d17,
487: decode(l.pval018,cn,vn,vn,vh,
488: hr_pump_get.gl(l.pval018,'SEX',d(l.pval001),l.pval112)) p18,
489: l.pval018 d18,

Line 488: hr_pump_get.gl(l.pval018,'SEX',d(l.pval001),l.pval112)) p18,

484: decode(l.pval017,cn,vn,vn,vh,
485: hr_pump_get.gl(l.pval017,'REGISTERED_DISABLED',d(l.pval001),l.pval112)) p17,
486: l.pval017 d17,
487: decode(l.pval018,cn,vn,vn,vh,
488: hr_pump_get.gl(l.pval018,'SEX',d(l.pval001),l.pval112)) p18,
489: l.pval018 d18,
490: decode(l.pval019,cn,vn,vn,vh,
491: hr_pump_get.gl(l.pval019,'TITLE',d(l.pval001),l.pval112)) p19,
492: l.pval019 d19,

Line 491: hr_pump_get.gl(l.pval019,'TITLE',d(l.pval001),l.pval112)) p19,

487: decode(l.pval018,cn,vn,vn,vh,
488: hr_pump_get.gl(l.pval018,'SEX',d(l.pval001),l.pval112)) p18,
489: l.pval018 d18,
490: decode(l.pval019,cn,vn,vn,vh,
491: hr_pump_get.gl(l.pval019,'TITLE',d(l.pval001),l.pval112)) p19,
492: l.pval019 d19,
493: decode(l.pval020,cn,vn,vn,vh,l.pval020) p20,
494: l.pval020 d20,
495: decode(l.pval021,cn,vn,vn,vh,l.pval021) p21,

Line 572: hr_pump_get.gl(l.pval059,'YES_NO',d(l.pval001),l.pval112)) p59,

568: l.pval057 d57,
569: decode(l.pval058,cn,dn,vn,dh,d(l.pval058)) p58,
570: l.pval058 d58,
571: decode(l.pval059,cn,vn,vn,vh,
572: hr_pump_get.gl(l.pval059,'YES_NO',d(l.pval001),l.pval112)) p59,
573: l.pval059 d59,
574: decode(l.pval060,cn,dn,vn,dh,d(l.pval060)) p60,
575: l.pval060 d60,
576: decode(l.pval061,cn,vn,vn,vh,

Line 577: hr_pump_get.gl(l.pval061,'BLOOD_TYPE',d(l.pval001),l.pval112)) p61,

573: l.pval059 d59,
574: decode(l.pval060,cn,dn,vn,dh,d(l.pval060)) p60,
575: l.pval060 d60,
576: decode(l.pval061,cn,vn,vn,vh,
577: hr_pump_get.gl(l.pval061,'BLOOD_TYPE',d(l.pval001),l.pval112)) p61,
578: l.pval061 d61,
579: decode(l.pval062,cn,vn,vn,vh,l.pval062) p62,
580: l.pval062 d62,
581: decode(l.pval063,cn,nn,vn,nh,n(l.pval063)) p63,

Line 598: hr_pump_get.gl(l.pval071,'YES_NO',d(l.pval001),l.pval112)) p71,

594: l.pval069 d69,
595: decode(l.pval070,cn,vn,vn,vh,l.pval070) p70,
596: l.pval070 d70,
597: decode(l.pval071,cn,vn,vn,vh,
598: hr_pump_get.gl(l.pval071,'YES_NO',d(l.pval001),l.pval112)) p71,
599: l.pval071 d71,
600: decode(l.pval072,cn,vn,vn,vh,l.pval072) p72,
601: l.pval072 d72,
602: decode(l.pval073,cn,dn,vn,dh,d(l.pval073)) p73,

Line 607: hr_pump_get.gl(l.pval075,'YES_NO',d(l.pval001),l.pval112)) p75,

603: l.pval073 d73,
604: decode(l.pval074,cn,vn,vn,vh,l.pval074) p74,
605: l.pval074 d74,
606: decode(l.pval075,cn,vn,vn,vh,
607: hr_pump_get.gl(l.pval075,'YES_NO',d(l.pval001),l.pval112)) p75,
608: l.pval075 d75,
609: decode(l.pval076,cn,vn,vn,vh,
610: hr_pump_get.gl(l.pval076,'YES_NO',d(l.pval001),l.pval112)) p76,
611: l.pval076 d76,

Line 610: hr_pump_get.gl(l.pval076,'YES_NO',d(l.pval001),l.pval112)) p76,

606: decode(l.pval075,cn,vn,vn,vh,
607: hr_pump_get.gl(l.pval075,'YES_NO',d(l.pval001),l.pval112)) p75,
608: l.pval075 d75,
609: decode(l.pval076,cn,vn,vn,vh,
610: hr_pump_get.gl(l.pval076,'YES_NO',d(l.pval001),l.pval112)) p76,
611: l.pval076 d76,
612: decode(l.pval077,cn,dn,vn,dh,d(l.pval077)) p77,
613: l.pval077 d77,
614: decode(l.pval078,cn,vn,vn,vh,

Line 615: hr_pump_get.gl(l.pval078,'YES_NO',d(l.pval001),l.pval112)) p78,

611: l.pval076 d76,
612: decode(l.pval077,cn,dn,vn,dh,d(l.pval077)) p77,
613: l.pval077 d77,
614: decode(l.pval078,cn,vn,vn,vh,
615: hr_pump_get.gl(l.pval078,'YES_NO',d(l.pval001),l.pval112)) p78,
616: l.pval078 d78,
617: decode(l.pval079,cn,vn,vn,vh,
618: hr_pump_get.gl(l.pval079,'STUDENT_STATUS',d(l.pval001),l.pval112)) p79,
619: l.pval079 d79,

Line 618: hr_pump_get.gl(l.pval079,'STUDENT_STATUS',d(l.pval001),l.pval112)) p79,

614: decode(l.pval078,cn,vn,vn,vh,
615: hr_pump_get.gl(l.pval078,'YES_NO',d(l.pval001),l.pval112)) p78,
616: l.pval078 d78,
617: decode(l.pval079,cn,vn,vn,vh,
618: hr_pump_get.gl(l.pval079,'STUDENT_STATUS',d(l.pval001),l.pval112)) p79,
619: l.pval079 d79,
620: decode(l.pval080,cn,vn,vn,vh,
621: hr_pump_get.gl(l.pval080,'WORK_SCHEDULE',d(l.pval001),l.pval112)) p80,
622: l.pval080 d80,

Line 621: hr_pump_get.gl(l.pval080,'WORK_SCHEDULE',d(l.pval001),l.pval112)) p80,

617: decode(l.pval079,cn,vn,vn,vh,
618: hr_pump_get.gl(l.pval079,'STUDENT_STATUS',d(l.pval001),l.pval112)) p79,
619: l.pval079 d79,
620: decode(l.pval080,cn,vn,vn,vh,
621: hr_pump_get.gl(l.pval080,'WORK_SCHEDULE',d(l.pval001),l.pval112)) p80,
622: l.pval080 d80,
623: decode(l.pval081,cn,vn,vn,vh,l.pval081) p81,
624: l.pval081 d81,
625: decode(l.pval082,cn,vn,vn,vh,l.pval082) p82,

Line 716: hr_pump_get.get_person_id

712: if c.p110 is null then
713: L_PERSON_ID:=nn;
714: else
715: L_PERSON_ID :=
716: hr_pump_get.get_person_id
717: (P_PERSON_USER_KEY => c.p110);
718: end if;
719: --
720: if c.p110 is null or

Line 725: hr_pump_get.GET_PER_OVN

721: c.p1 is null then
722: L_OBJECT_VERSION_NUMBER:=nn;
723: else
724: L_OBJECT_VERSION_NUMBER :=
725: hr_pump_get.GET_PER_OVN
726: (P_PERSON_USER_KEY => c.p110
727: ,P_EFFECTIVE_DATE => c.p1);
728: end if;
729: --

Line 738: hr_pump_get.get_person_type_id

734: c.d112 is null then
735: L_PERSON_TYPE_ID:=nh;
736: else
737: L_PERSON_TYPE_ID :=
738: hr_pump_get.get_person_type_id
739: (P_USER_PERSON_TYPE => c.p111
740: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
741: ,P_LANGUAGE_CODE => c.p112);
742: end if;

Line 750: hr_pump_get.get_vendor_id

746: elsif c.d113 is null then
747: L_VENDOR_ID:=nh;
748: else
749: L_VENDOR_ID :=
750: hr_pump_get.get_vendor_id
751: (P_VENDOR_NAME => c.p113);
752: end if;
753: --
754: if c.d114=cn then

Line 760: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE

756: elsif c.d114 is null then
757: L_CORRESPONDENCE_LANGUAGE:=vh;
758: else
759: L_CORRESPONDENCE_LANGUAGE :=
760: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
761: (P_CORRESPONDENCE_LANGUAGE => c.p114);
762: end if;
763: --
764: if c.d115=cn then

Line 770: hr_pump_get.get_benefit_group_id

766: elsif c.d115 is null then
767: L_BENEFIT_GROUP_ID:=nh;
768: else
769: L_BENEFIT_GROUP_ID :=
770: hr_pump_get.get_benefit_group_id
771: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
772: ,P_BENEFIT_GROUP => c.p115);
773: end if;
774: --