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

Line 459: hr_pump_get.gl(l.pval002,'CONTACT',d(l.pval001),l.pval124)) p2,

455: cursor cr is
456: select l.rowid myrowid,
457: decode(l.pval001,cn,dn,d(l.pval001)) p1,
458: decode(l.pval002,cn,vn,
459: hr_pump_get.gl(l.pval002,'CONTACT',d(l.pval001),l.pval124)) p2,
460: decode(l.pval003,cn,vn,vn,vn,l.pval003) p3,
461: l.pval003 d3,
462: decode(l.pval004,cn,vn,vn,'N',
463: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),l.pval124)) p4,

Line 463: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),l.pval124)) p4,

459: hr_pump_get.gl(l.pval002,'CONTACT',d(l.pval001),l.pval124)) p2,
460: decode(l.pval003,cn,vn,vn,vn,l.pval003) p3,
461: l.pval003 d3,
462: decode(l.pval004,cn,vn,vn,'N',
463: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),l.pval124)) p4,
464: l.pval004 d4,
465: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
466: l.pval005 d5,
467: decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,

Line 470: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval001),l.pval124)) p7,

466: l.pval005 d5,
467: decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
468: l.pval006 d6,
469: decode(l.pval007,cn,vn,vn,'N',
470: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval001),l.pval124)) p7,
471: l.pval007 d7,
472: decode(l.pval008,cn,vn,vn,'N',
473: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval001),l.pval124)) p8,
474: l.pval008 d8,

Line 473: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval001),l.pval124)) p8,

469: decode(l.pval007,cn,vn,vn,'N',
470: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval001),l.pval124)) p7,
471: l.pval007 d7,
472: decode(l.pval008,cn,vn,vn,'N',
473: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval001),l.pval124)) p8,
474: l.pval008 d8,
475: decode(l.pval009,cn,nn,vn,nn,n(l.pval009)) p9,
476: l.pval009 d9,
477: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,

Line 520: hr_pump_get.gl(l.pval031,'YES_NO',d(l.pval001),l.pval124)) p31,

516: l.pval029 d29,
517: decode(l.pval030,cn,vn,vn,vn,l.pval030) p30,
518: l.pval030 d30,
519: decode(l.pval031,cn,vn,vn,'N',
520: hr_pump_get.gl(l.pval031,'YES_NO',d(l.pval001),l.pval124)) p31,
521: l.pval031 d31,
522: decode(l.pval032,cn,vn,vn,'N',
523: hr_pump_get.gl(l.pval032,'YES_NO',d(l.pval001),l.pval124)) p32,
524: l.pval032 d32,

Line 523: hr_pump_get.gl(l.pval032,'YES_NO',d(l.pval001),l.pval124)) p32,

519: decode(l.pval031,cn,vn,vn,'N',
520: hr_pump_get.gl(l.pval031,'YES_NO',d(l.pval001),l.pval124)) p31,
521: l.pval031 d31,
522: decode(l.pval032,cn,vn,vn,'N',
523: hr_pump_get.gl(l.pval032,'YES_NO',d(l.pval001),l.pval124)) p32,
524: l.pval032 d32,
525: decode(l.pval033,cn,vn,vn,'N',
526: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval001),l.pval124)) p33,
527: l.pval033 d33,

Line 526: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval001),l.pval124)) p33,

522: decode(l.pval032,cn,vn,vn,'N',
523: hr_pump_get.gl(l.pval032,'YES_NO',d(l.pval001),l.pval124)) p32,
524: l.pval032 d32,
525: decode(l.pval033,cn,vn,vn,'N',
526: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval001),l.pval124)) p33,
527: l.pval033 d33,
528: decode(l.pval034,cn,vn,vn,'N',
529: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval001),l.pval124)) p34,
530: l.pval034 d34,

Line 529: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval001),l.pval124)) p34,

525: decode(l.pval033,cn,vn,vn,'N',
526: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval001),l.pval124)) p33,
527: l.pval033 d33,
528: decode(l.pval034,cn,vn,vn,'N',
529: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval001),l.pval124)) p34,
530: l.pval034 d34,
531: decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
532: l.pval035 d35,
533: decode(l.pval036,cn,vn,vn,vn,

Line 534: hr_pump_get.gl(l.pval036,'SEX',d(l.pval001),l.pval124)) p36,

530: l.pval034 d34,
531: decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
532: l.pval035 d35,
533: decode(l.pval036,cn,vn,vn,vn,
534: hr_pump_get.gl(l.pval036,'SEX',d(l.pval001),l.pval124)) p36,
535: l.pval036 d36,
536: decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
537: l.pval037 d37,
538: decode(l.pval038,cn,dn,vn,dn,d(l.pval038)) p38,

Line 547: hr_pump_get.gl(l.pval042,'MAR_STATUS',d(l.pval001),l.pval124)) p42,

543: l.pval040 d40,
544: decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
545: l.pval041 d41,
546: decode(l.pval042,cn,vn,vn,vn,
547: hr_pump_get.gl(l.pval042,'MAR_STATUS',d(l.pval001),l.pval124)) p42,
548: l.pval042 d42,
549: decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
550: l.pval043 d43,
551: decode(l.pval044,cn,vn,vn,vn,

Line 552: hr_pump_get.gl(l.pval044,'NATIONALITY',d(l.pval001),l.pval124)) p44,

548: l.pval042 d42,
549: decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
550: l.pval043 d43,
551: decode(l.pval044,cn,vn,vn,vn,
552: hr_pump_get.gl(l.pval044,'NATIONALITY',d(l.pval001),l.pval124)) p44,
553: l.pval044 d44,
554: decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
555: l.pval045 d45,
556: decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,

Line 559: hr_pump_get.gl(l.pval047,'REGISTERED_DISABLED',d(l.pval001),l.pval124)) p47,

555: l.pval045 d45,
556: decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
557: l.pval046 d46,
558: decode(l.pval047,cn,vn,vn,vn,
559: hr_pump_get.gl(l.pval047,'REGISTERED_DISABLED',d(l.pval001),l.pval124)) p47,
560: l.pval047 d47,
561: decode(l.pval048,cn,vn,vn,vn,
562: hr_pump_get.gl(l.pval048,'TITLE',d(l.pval001),l.pval124)) p48,
563: l.pval048 d48,

Line 562: hr_pump_get.gl(l.pval048,'TITLE',d(l.pval001),l.pval124)) p48,

558: decode(l.pval047,cn,vn,vn,vn,
559: hr_pump_get.gl(l.pval047,'REGISTERED_DISABLED',d(l.pval001),l.pval124)) p47,
560: l.pval047 d47,
561: decode(l.pval048,cn,vn,vn,vn,
562: hr_pump_get.gl(l.pval048,'TITLE',d(l.pval001),l.pval124)) p48,
563: l.pval048 d48,
564: decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
565: l.pval049 d49,
566: decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,

Line 639: hr_pump_get.gl(l.pval086,'YES_NO',d(l.pval001),l.pval124)) p86,

635: l.pval084 d84,
636: decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
637: l.pval085 d85,
638: decode(l.pval086,cn,vn,vn,'N',
639: hr_pump_get.gl(l.pval086,'YES_NO',d(l.pval001),l.pval124)) p86,
640: l.pval086 d86,
641: decode(l.pval087,cn,vn,vn,vn,
642: hr_pump_get.gl(l.pval087,'CONTACT_TYPE',d(l.pval001),l.pval124)) p87,
643: l.pval087 d87,

Line 642: hr_pump_get.gl(l.pval087,'CONTACT_TYPE',d(l.pval001),l.pval124)) p87,

638: decode(l.pval086,cn,vn,vn,'N',
639: hr_pump_get.gl(l.pval086,'YES_NO',d(l.pval001),l.pval124)) p86,
640: l.pval086 d86,
641: decode(l.pval087,cn,vn,vn,vn,
642: hr_pump_get.gl(l.pval087,'CONTACT_TYPE',d(l.pval001),l.pval124)) p87,
643: l.pval087 d87,
644: decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,
645: l.pval088 d88,
646: decode(l.pval089,cn,vn,vn,vn,l.pval089) p89,

Line 737: hr_pump_get.get_person_id

733: if c.p119 is null then
734: L_PERSON_ID:=nn;
735: else
736: L_PERSON_ID :=
737: hr_pump_get.get_person_id
738: (P_PERSON_USER_KEY => c.p119);
739: end if;
740: --
741: if c.p120 is null then

Line 745: hr_pump_get.get_contact_person_id

741: if c.p120 is null then
742: L_CONTACT_PERSON_ID:=nn;
743: else
744: L_CONTACT_PERSON_ID :=
745: hr_pump_get.get_contact_person_id
746: (P_CONTACT_PERSON_USER_KEY => c.p120);
747: end if;
748: --
749: if c.p1 is null or

Line 754: hr_pump_get.get_start_life_reason_id

750: c.p121 is null then
751: L_START_LIFE_REASON_ID:=nn;
752: else
753: L_START_LIFE_REASON_ID :=
754: hr_pump_get.get_start_life_reason_id
755: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
756: ,P_EFFECTIVE_DATE => c.p1
757: ,P_START_LIFE_REASON => c.p121);
758: end if;

Line 765: hr_pump_get.get_end_life_reason_id

761: c.p122 is null then
762: L_END_LIFE_REASON_ID:=nn;
763: else
764: L_END_LIFE_REASON_ID :=
765: hr_pump_get.get_end_life_reason_id
766: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
767: ,P_EFFECTIVE_DATE => c.p1
768: ,P_END_LIFE_REASON => c.p122);
769: end if;

Line 776: hr_pump_get.get_person_type_id

772: c.p124 is null then
773: L_PERSON_TYPE_ID:=nn;
774: else
775: L_PERSON_TYPE_ID :=
776: hr_pump_get.get_person_type_id
777: (P_USER_PERSON_TYPE => c.p123
778: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
779: ,P_LANGUAGE_CODE => c.p124);
780: end if;