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

Line 483: hr_pump_get.gl(l.pval010,'HOME_OFFICE',d(l.pval001),l.pval117)) p10,

479: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
480: l.pval008 d8,
481: decode(l.pval009,cn,vn,l.pval009) p9,
482: decode(l.pval010,cn,vn,vn,vh,
483: hr_pump_get.gl(l.pval010,'HOME_OFFICE',d(l.pval001),l.pval117)) p10,
484: l.pval010 d10,
485: decode(l.pval011,cn,vn,vn,vh,l.pval011) p11,
486: l.pval011 d11,
487: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,

Line 490: hr_pump_get.gl(l.pval013,'MAR_STATUS',d(l.pval001),l.pval117)) p13,

486: l.pval011 d11,
487: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
488: l.pval012 d12,
489: decode(l.pval013,cn,vn,vn,vh,
490: hr_pump_get.gl(l.pval013,'MAR_STATUS',d(l.pval001),l.pval117)) p13,
491: l.pval013 d13,
492: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
493: l.pval014 d14,
494: decode(l.pval015,cn,vn,vn,vh,

Line 495: hr_pump_get.gl(l.pval015,'NATIONALITY',d(l.pval001),l.pval117)) p15,

491: l.pval013 d13,
492: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
493: l.pval014 d14,
494: decode(l.pval015,cn,vn,vn,vh,
495: hr_pump_get.gl(l.pval015,'NATIONALITY',d(l.pval001),l.pval117)) p15,
496: l.pval015 d15,
497: decode(l.pval016,cn,vn,vn,vh,l.pval016) p16,
498: l.pval016 d16,
499: decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,

Line 502: hr_pump_get.gl(l.pval018,'REGISTERED_DISABLED',d(l.pval001),l.pval117)) p18,

498: l.pval016 d16,
499: decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,
500: l.pval017 d17,
501: decode(l.pval018,cn,vn,vn,vh,
502: hr_pump_get.gl(l.pval018,'REGISTERED_DISABLED',d(l.pval001),l.pval117)) p18,
503: l.pval018 d18,
504: decode(l.pval019,cn,vn,vn,vh,
505: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval117)) p19,
506: l.pval019 d19,

Line 505: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval117)) p19,

501: decode(l.pval018,cn,vn,vn,vh,
502: hr_pump_get.gl(l.pval018,'REGISTERED_DISABLED',d(l.pval001),l.pval117)) p18,
503: l.pval018 d18,
504: decode(l.pval019,cn,vn,vn,vh,
505: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval117)) p19,
506: l.pval019 d19,
507: decode(l.pval020,cn,vn,vn,vh,
508: hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval117)) p20,
509: l.pval020 d20,

Line 508: hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval117)) p20,

504: decode(l.pval019,cn,vn,vn,vh,
505: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval117)) p19,
506: l.pval019 d19,
507: decode(l.pval020,cn,vn,vn,vh,
508: hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval117)) p20,
509: l.pval020 d20,
510: decode(l.pval021,cn,vn,vn,vh,l.pval021) p21,
511: l.pval021 d21,
512: decode(l.pval022,cn,vn,vn,vh,l.pval022) p22,

Line 577: hr_pump_get.gl(l.pval054,'YES_NO',d(l.pval001),l.pval117)) p54,

573: l.pval052 d52,
574: decode(l.pval053,cn,vn,vn,vh,l.pval053) p53,
575: l.pval053 d53,
576: decode(l.pval054,cn,vn,vn,vh,
577: hr_pump_get.gl(l.pval054,'YES_NO',d(l.pval001),l.pval117)) p54,
578: l.pval054 d54,
579: decode(l.pval055,cn,vn,vn,vh,l.pval055) p55,
580: l.pval055 d55,
581: decode(l.pval056,cn,vn,vn,'RO',

Line 582: hr_pump_get.gl(l.pval056,'IN_RESIDENTIAL_STATUS',d(l.pval001),l.pval117)) p56,

578: l.pval054 d54,
579: decode(l.pval055,cn,vn,vn,vh,l.pval055) p55,
580: l.pval055 d55,
581: decode(l.pval056,cn,vn,vn,'RO',
582: hr_pump_get.gl(l.pval056,'IN_RESIDENTIAL_STATUS',d(l.pval001),l.pval117)) p56,
583: l.pval056 d56,
584: decode(l.pval057,cn,vn,vn,vh,l.pval057) p57,
585: l.pval057 d57,
586: decode(l.pval058,cn,vn,vn,vh,l.pval058) p58,

Line 599: hr_pump_get.gl(l.pval064,'YES_NO',d(l.pval001),l.pval117)) p64,

595: l.pval062 d62,
596: decode(l.pval063,cn,dn,vn,dh,d(l.pval063)) p63,
597: l.pval063 d63,
598: decode(l.pval064,cn,vn,vn,vh,
599: hr_pump_get.gl(l.pval064,'YES_NO',d(l.pval001),l.pval117)) p64,
600: l.pval064 d64,
601: decode(l.pval065,cn,dn,vn,dh,d(l.pval065)) p65,
602: l.pval065 d65,
603: decode(l.pval066,cn,vn,vn,vh,

Line 604: hr_pump_get.gl(l.pval066,'BLOOD_TYPE',d(l.pval001),l.pval117)) p66,

600: l.pval064 d64,
601: decode(l.pval065,cn,dn,vn,dh,d(l.pval065)) p65,
602: l.pval065 d65,
603: decode(l.pval066,cn,vn,vn,vh,
604: hr_pump_get.gl(l.pval066,'BLOOD_TYPE',d(l.pval001),l.pval117)) p66,
605: l.pval066 d66,
606: decode(l.pval067,cn,vn,vn,vh,l.pval067) p67,
607: l.pval067 d67,
608: decode(l.pval068,cn,nn,vn,nh,n(l.pval068)) p68,

Line 625: hr_pump_get.gl(l.pval076,'YES_NO',d(l.pval001),l.pval117)) p76,

621: l.pval074 d74,
622: decode(l.pval075,cn,vn,vn,vh,l.pval075) p75,
623: l.pval075 d75,
624: decode(l.pval076,cn,vn,vn,vh,
625: hr_pump_get.gl(l.pval076,'YES_NO',d(l.pval001),l.pval117)) p76,
626: l.pval076 d76,
627: decode(l.pval077,cn,vn,vn,vh,l.pval077) p77,
628: l.pval077 d77,
629: decode(l.pval078,cn,dn,vn,dh,d(l.pval078)) p78,

Line 634: hr_pump_get.gl(l.pval080,'YES_NO',d(l.pval001),l.pval117)) p80,

630: l.pval078 d78,
631: decode(l.pval079,cn,vn,vn,vh,l.pval079) p79,
632: l.pval079 d79,
633: decode(l.pval080,cn,vn,vn,vh,
634: hr_pump_get.gl(l.pval080,'YES_NO',d(l.pval001),l.pval117)) p80,
635: l.pval080 d80,
636: decode(l.pval081,cn,vn,vn,vh,
637: hr_pump_get.gl(l.pval081,'YES_NO',d(l.pval001),l.pval117)) p81,
638: l.pval081 d81,

Line 637: hr_pump_get.gl(l.pval081,'YES_NO',d(l.pval001),l.pval117)) p81,

633: decode(l.pval080,cn,vn,vn,vh,
634: hr_pump_get.gl(l.pval080,'YES_NO',d(l.pval001),l.pval117)) p80,
635: l.pval080 d80,
636: decode(l.pval081,cn,vn,vn,vh,
637: hr_pump_get.gl(l.pval081,'YES_NO',d(l.pval001),l.pval117)) p81,
638: l.pval081 d81,
639: decode(l.pval082,cn,dn,vn,dh,d(l.pval082)) p82,
640: l.pval082 d82,
641: decode(l.pval083,cn,vn,vn,vh,

Line 642: hr_pump_get.gl(l.pval083,'YES_NO',d(l.pval001),l.pval117)) p83,

638: l.pval081 d81,
639: decode(l.pval082,cn,dn,vn,dh,d(l.pval082)) p82,
640: l.pval082 d82,
641: decode(l.pval083,cn,vn,vn,vh,
642: hr_pump_get.gl(l.pval083,'YES_NO',d(l.pval001),l.pval117)) p83,
643: l.pval083 d83,
644: decode(l.pval084,cn,vn,vn,vh,
645: hr_pump_get.gl(l.pval084,'STUDENT_STATUS',d(l.pval001),l.pval117)) p84,
646: l.pval084 d84,

Line 645: hr_pump_get.gl(l.pval084,'STUDENT_STATUS',d(l.pval001),l.pval117)) p84,

641: decode(l.pval083,cn,vn,vn,vh,
642: hr_pump_get.gl(l.pval083,'YES_NO',d(l.pval001),l.pval117)) p83,
643: l.pval083 d83,
644: decode(l.pval084,cn,vn,vn,vh,
645: hr_pump_get.gl(l.pval084,'STUDENT_STATUS',d(l.pval001),l.pval117)) p84,
646: l.pval084 d84,
647: decode(l.pval085,cn,vn,vn,vh,
648: hr_pump_get.gl(l.pval085,'WORK_SCHEDULE',d(l.pval001),l.pval117)) p85,
649: l.pval085 d85,

Line 648: hr_pump_get.gl(l.pval085,'WORK_SCHEDULE',d(l.pval001),l.pval117)) p85,

644: decode(l.pval084,cn,vn,vn,vh,
645: hr_pump_get.gl(l.pval084,'STUDENT_STATUS',d(l.pval001),l.pval117)) p84,
646: l.pval084 d84,
647: decode(l.pval085,cn,vn,vn,vh,
648: hr_pump_get.gl(l.pval085,'WORK_SCHEDULE',d(l.pval001),l.pval117)) p85,
649: l.pval085 d85,
650: decode(l.pval086,cn,vn,vn,vh,l.pval086) p86,
651: l.pval086 d86,
652: decode(l.pval087,cn,vn,vn,vh,l.pval087) p87,

Line 743: hr_pump_get.get_person_id

739: if c.p115 is null then
740: L_PERSON_ID:=nn;
741: else
742: L_PERSON_ID :=
743: hr_pump_get.get_person_id
744: (P_PERSON_USER_KEY => c.p115);
745: end if;
746: --
747: if c.p115 is null or

Line 752: hr_pump_get.GET_PER_OVN

748: c.p1 is null then
749: L_OBJECT_VERSION_NUMBER:=nn;
750: else
751: L_OBJECT_VERSION_NUMBER :=
752: hr_pump_get.GET_PER_OVN
753: (P_PERSON_USER_KEY => c.p115
754: ,P_EFFECTIVE_DATE => c.p1);
755: end if;
756: --

Line 765: hr_pump_get.get_person_type_id

761: c.d117 is null then
762: L_PERSON_TYPE_ID:=nh;
763: else
764: L_PERSON_TYPE_ID :=
765: hr_pump_get.get_person_type_id
766: (P_USER_PERSON_TYPE => c.p116
767: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
768: ,P_LANGUAGE_CODE => c.p117);
769: end if;

Line 777: hr_pump_get.get_vendor_id

773: elsif c.d118 is null then
774: L_VENDOR_ID:=nh;
775: else
776: L_VENDOR_ID :=
777: hr_pump_get.get_vendor_id
778: (P_VENDOR_NAME => c.p118);
779: end if;
780: --
781: if c.d119=cn then

Line 787: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE

783: elsif c.d119 is null then
784: L_CORRESPONDENCE_LANGUAGE:=vh;
785: else
786: L_CORRESPONDENCE_LANGUAGE :=
787: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
788: (P_CORRESPONDENCE_LANGUAGE => c.p119);
789: end if;
790: --
791: if c.d120=cn then

Line 797: hr_pump_get.get_benefit_group_id

793: elsif c.d120 is null then
794: L_BENEFIT_GROUP_ID:=nh;
795: else
796: L_BENEFIT_GROUP_ID :=
797: hr_pump_get.get_benefit_group_id
798: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
799: ,P_BENEFIT_GROUP => c.p120);
800: end if;
801: --