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

Line 417: hr_pump_get.gl(l.pval010,'HOME_OFFICE',d(l.pval001),l.pval096)) p10,

413: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
414: l.pval008 d8,
415: decode(l.pval009,cn,vn,l.pval009) p9,
416: decode(l.pval010,cn,vn,vn,vh,
417: hr_pump_get.gl(l.pval010,'HOME_OFFICE',d(l.pval001),l.pval096)) p10,
418: l.pval010 d10,
419: decode(l.pval011,cn,vn,vn,vh,l.pval011) p11,
420: l.pval011 d11,
421: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,

Line 424: hr_pump_get.gl(l.pval013,'MAR_STATUS',d(l.pval001),l.pval096)) p13,

420: l.pval011 d11,
421: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
422: l.pval012 d12,
423: decode(l.pval013,cn,vn,vn,vh,
424: hr_pump_get.gl(l.pval013,'MAR_STATUS',d(l.pval001),l.pval096)) p13,
425: l.pval013 d13,
426: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
427: l.pval014 d14,
428: decode(l.pval015,cn,vn,vn,vh,

Line 429: hr_pump_get.gl(l.pval015,'NATIONALITY',d(l.pval001),l.pval096)) p15,

425: l.pval013 d13,
426: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
427: l.pval014 d14,
428: decode(l.pval015,cn,vn,vn,vh,
429: hr_pump_get.gl(l.pval015,'NATIONALITY',d(l.pval001),l.pval096)) p15,
430: l.pval015 d15,
431: decode(l.pval016,cn,vn,vn,vh,l.pval016) p16,
432: l.pval016 d16,
433: decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,

Line 436: hr_pump_get.gl(l.pval018,'YES_NO',d(l.pval001),l.pval096)) p18,

432: l.pval016 d16,
433: decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,
434: l.pval017 d17,
435: decode(l.pval018,cn,vn,vn,vh,
436: hr_pump_get.gl(l.pval018,'YES_NO',d(l.pval001),l.pval096)) p18,
437: l.pval018 d18,
438: decode(l.pval019,cn,vn,vn,vh,
439: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval096)) p19,
440: l.pval019 d19,

Line 439: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval096)) p19,

435: decode(l.pval018,cn,vn,vn,vh,
436: hr_pump_get.gl(l.pval018,'YES_NO',d(l.pval001),l.pval096)) p18,
437: l.pval018 d18,
438: decode(l.pval019,cn,vn,vn,vh,
439: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval096)) p19,
440: l.pval019 d19,
441: decode(l.pval020,cn,vn,vn,vh,
442: hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval096)) p20,
443: l.pval020 d20,

Line 442: hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval096)) p20,

438: decode(l.pval019,cn,vn,vn,vh,
439: hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval096)) p19,
440: l.pval019 d19,
441: decode(l.pval020,cn,vn,vn,vh,
442: hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval096)) p20,
443: l.pval020 d20,
444: decode(l.pval021,cn,vn,vn,vh,l.pval021) p21,
445: l.pval021 d21,
446: decode(l.pval022,cn,vn,vn,vh,l.pval022) p22,

Line 513: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval096)) p55,

509: l.pval053 d53,
510: decode(l.pval054,cn,dn,vn,dh,d(l.pval054)) p54,
511: l.pval054 d54,
512: decode(l.pval055,cn,vn,vn,vh,
513: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval096)) p55,
514: l.pval055 d55,
515: decode(l.pval056,cn,dn,vn,dh,d(l.pval056)) p56,
516: l.pval056 d56,
517: decode(l.pval057,cn,vn,vn,vh,

Line 518: hr_pump_get.gl(l.pval057,'BLOOD_TYPE',d(l.pval001),l.pval096)) p57,

514: l.pval055 d55,
515: decode(l.pval056,cn,dn,vn,dh,d(l.pval056)) p56,
516: l.pval056 d56,
517: decode(l.pval057,cn,vn,vn,vh,
518: hr_pump_get.gl(l.pval057,'BLOOD_TYPE',d(l.pval001),l.pval096)) p57,
519: l.pval057 d57,
520: decode(l.pval058,cn,vn,vn,vh,l.pval058) p58,
521: l.pval058 d58,
522: decode(l.pval059,cn,nn,vn,nh,n(l.pval059)) p59,

Line 539: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval096)) p67,

535: l.pval065 d65,
536: decode(l.pval066,cn,vn,vn,vh,l.pval066) p66,
537: l.pval066 d66,
538: decode(l.pval067,cn,vn,vn,vh,
539: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval096)) p67,
540: l.pval067 d67,
541: decode(l.pval068,cn,vn,vn,vh,l.pval068) p68,
542: l.pval068 d68,
543: decode(l.pval069,cn,dn,vn,dh,d(l.pval069)) p69,

Line 548: hr_pump_get.gl(l.pval071,'YES_NO',d(l.pval001),l.pval096)) p71,

544: l.pval069 d69,
545: decode(l.pval070,cn,vn,vn,vh,l.pval070) p70,
546: l.pval070 d70,
547: decode(l.pval071,cn,vn,vn,vh,
548: hr_pump_get.gl(l.pval071,'YES_NO',d(l.pval001),l.pval096)) p71,
549: l.pval071 d71,
550: decode(l.pval072,cn,vn,vn,vh,
551: hr_pump_get.gl(l.pval072,'YES_NO',d(l.pval001),l.pval096)) p72,
552: l.pval072 d72,

Line 551: hr_pump_get.gl(l.pval072,'YES_NO',d(l.pval001),l.pval096)) p72,

547: decode(l.pval071,cn,vn,vn,vh,
548: hr_pump_get.gl(l.pval071,'YES_NO',d(l.pval001),l.pval096)) p71,
549: l.pval071 d71,
550: decode(l.pval072,cn,vn,vn,vh,
551: hr_pump_get.gl(l.pval072,'YES_NO',d(l.pval001),l.pval096)) p72,
552: l.pval072 d72,
553: decode(l.pval073,cn,dn,vn,dh,d(l.pval073)) p73,
554: l.pval073 d73,
555: decode(l.pval074,cn,vn,vn,vh,

Line 556: hr_pump_get.gl(l.pval074,'YES_NO',d(l.pval001),l.pval096)) p74,

552: l.pval072 d72,
553: decode(l.pval073,cn,dn,vn,dh,d(l.pval073)) p73,
554: l.pval073 d73,
555: decode(l.pval074,cn,vn,vn,vh,
556: hr_pump_get.gl(l.pval074,'YES_NO',d(l.pval001),l.pval096)) p74,
557: l.pval074 d74,
558: decode(l.pval075,cn,vn,vn,vh,
559: hr_pump_get.gl(l.pval075,'STUDENT_STATUS',d(l.pval001),l.pval096)) p75,
560: l.pval075 d75,

Line 559: hr_pump_get.gl(l.pval075,'STUDENT_STATUS',d(l.pval001),l.pval096)) p75,

555: decode(l.pval074,cn,vn,vn,vh,
556: hr_pump_get.gl(l.pval074,'YES_NO',d(l.pval001),l.pval096)) p74,
557: l.pval074 d74,
558: decode(l.pval075,cn,vn,vn,vh,
559: hr_pump_get.gl(l.pval075,'STUDENT_STATUS',d(l.pval001),l.pval096)) p75,
560: l.pval075 d75,
561: decode(l.pval076,cn,vn,vn,vh,
562: hr_pump_get.gl(l.pval076,'WORK_SCHEDULE',d(l.pval001),l.pval096)) p76,
563: l.pval076 d76,

Line 562: hr_pump_get.gl(l.pval076,'WORK_SCHEDULE',d(l.pval001),l.pval096)) p76,

558: decode(l.pval075,cn,vn,vn,vh,
559: hr_pump_get.gl(l.pval075,'STUDENT_STATUS',d(l.pval001),l.pval096)) p75,
560: l.pval075 d75,
561: decode(l.pval076,cn,vn,vn,vh,
562: hr_pump_get.gl(l.pval076,'WORK_SCHEDULE',d(l.pval001),l.pval096)) p76,
563: l.pval076 d76,
564: decode(l.pval077,cn,vn,vn,vh,l.pval077) p77,
565: l.pval077 d77,
566: decode(l.pval078,cn,vn,vn,vh,l.pval078) p78,

Line 633: hr_pump_get.get_person_id

629: if c.p94 is null then
630: L_PERSON_ID:=nn;
631: else
632: L_PERSON_ID :=
633: hr_pump_get.get_person_id
634: (P_PERSON_USER_KEY => c.p94);
635: end if;
636: --
637: if c.p94 is null or

Line 642: hr_pump_get.GET_PER_OVN

638: c.p1 is null then
639: L_OBJECT_VERSION_NUMBER:=nn;
640: else
641: L_OBJECT_VERSION_NUMBER :=
642: hr_pump_get.GET_PER_OVN
643: (P_PERSON_USER_KEY => c.p94
644: ,P_EFFECTIVE_DATE => c.p1);
645: end if;
646: --

Line 655: hr_pump_get.get_person_type_id

651: c.d96 is null then
652: L_PERSON_TYPE_ID:=nh;
653: else
654: L_PERSON_TYPE_ID :=
655: hr_pump_get.get_person_type_id
656: (P_USER_PERSON_TYPE => c.p95
657: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
658: ,P_LANGUAGE_CODE => c.p96);
659: end if;

Line 667: hr_pump_get.get_vendor_id

663: elsif c.d97 is null then
664: L_VENDOR_ID:=nh;
665: else
666: L_VENDOR_ID :=
667: hr_pump_get.get_vendor_id
668: (P_VENDOR_NAME => c.p97);
669: end if;
670: --
671: if c.d98=cn then

Line 677: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE

673: elsif c.d98 is null then
674: L_CORRESPONDENCE_LANGUAGE:=vh;
675: else
676: L_CORRESPONDENCE_LANGUAGE :=
677: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
678: (P_CORRESPONDENCE_LANGUAGE => c.p98);
679: end if;
680: --
681: if c.d99=cn then

Line 687: hr_pump_get.get_benefit_group_id

683: elsif c.d99 is null then
684: L_BENEFIT_GROUP_ID:=nh;
685: else
686: L_BENEFIT_GROUP_ID :=
687: hr_pump_get.get_benefit_group_id
688: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
689: ,P_BENEFIT_GROUP => c.p99);
690: end if;
691: --