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

Line 502: hr_pump_get.gl(l.pval003,'SEX',dn,l.pval137)) p3,

498: select l.rowid myrowid,
499: decode(l.pval001,cn,dn,d(l.pval001)) p1,
500: decode(l.pval002,cn,vn,l.pval002) p2,
501: decode(l.pval003,cn,vn,
502: hr_pump_get.gl(l.pval003,'SEX',dn,l.pval137)) p3,
503: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
504: l.pval004 d4,
505: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
506: l.pval005 d5,

Line 513: hr_pump_get.gl(l.pval009,'HOME_OFFICE',dn,l.pval137)) p9,

509: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
510: l.pval007 d7,
511: decode(l.pval008,cn,vn,l.pval008) p8,
512: decode(l.pval009,cn,vn,vn,vn,
513: hr_pump_get.gl(l.pval009,'HOME_OFFICE',dn,l.pval137)) p9,
514: l.pval009 d9,
515: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
516: l.pval010 d10,
517: decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,

Line 520: hr_pump_get.gl(l.pval012,'MAR_STATUS',dn,l.pval137)) p12,

516: l.pval010 d10,
517: decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
518: l.pval011 d11,
519: decode(l.pval012,cn,vn,vn,vn,
520: hr_pump_get.gl(l.pval012,'MAR_STATUS',dn,l.pval137)) p12,
521: l.pval012 d12,
522: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
523: l.pval013 d13,
524: decode(l.pval014,cn,vn,vn,vn,

Line 525: hr_pump_get.gl(l.pval014,'NATIONALITY',dn,l.pval137)) p14,

521: l.pval012 d12,
522: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
523: l.pval013 d13,
524: decode(l.pval014,cn,vn,vn,vn,
525: hr_pump_get.gl(l.pval014,'NATIONALITY',dn,l.pval137)) p14,
526: l.pval014 d14,
527: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
528: l.pval015 d15,
529: decode(l.pval016,cn,vn,vn,vn,l.pval016) p16,

Line 532: hr_pump_get.gl(l.pval017,'REGISTERED_DISABLED',dn,l.pval137)) p17,

528: l.pval015 d15,
529: decode(l.pval016,cn,vn,vn,vn,l.pval016) p16,
530: l.pval016 d16,
531: decode(l.pval017,cn,vn,vn,vn,
532: hr_pump_get.gl(l.pval017,'REGISTERED_DISABLED',dn,l.pval137)) p17,
533: l.pval017 d17,
534: decode(l.pval018,cn,vn,vn,vn,
535: hr_pump_get.gl(l.pval018,'TITLE',dn,l.pval137)) p18,
536: l.pval018 d18,

Line 535: hr_pump_get.gl(l.pval018,'TITLE',dn,l.pval137)) p18,

531: decode(l.pval017,cn,vn,vn,vn,
532: hr_pump_get.gl(l.pval017,'REGISTERED_DISABLED',dn,l.pval137)) p17,
533: l.pval017 d17,
534: decode(l.pval018,cn,vn,vn,vn,
535: hr_pump_get.gl(l.pval018,'TITLE',dn,l.pval137)) p18,
536: l.pval018 d18,
537: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
538: l.pval019 d19,
539: decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,

Line 666: hr_pump_get.gl(l.pval083,'YES_NO',dn,l.pval137)) p83,

662: l.pval081 d81,
663: decode(l.pval082,cn,dn,vn,dn,d(l.pval082)) p82,
664: l.pval082 d82,
665: decode(l.pval083,cn,vn,vn,vn,
666: hr_pump_get.gl(l.pval083,'YES_NO',dn,l.pval137)) p83,
667: l.pval083 d83,
668: decode(l.pval084,cn,dn,vn,dn,d(l.pval084)) p84,
669: l.pval084 d84,
670: decode(l.pval085,cn,vn,vn,vn,

Line 671: hr_pump_get.gl(l.pval085,'BLOOD_TYPE',dn,l.pval137)) p85,

667: l.pval083 d83,
668: decode(l.pval084,cn,dn,vn,dn,d(l.pval084)) p84,
669: l.pval084 d84,
670: decode(l.pval085,cn,vn,vn,vn,
671: hr_pump_get.gl(l.pval085,'BLOOD_TYPE',dn,l.pval137)) p85,
672: l.pval085 d85,
673: decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
674: l.pval086 d86,
675: decode(l.pval087,cn,nn,vn,nn,n(l.pval087)) p87,

Line 690: hr_pump_get.gl(l.pval094,'YES_NO',dn,l.pval137)) p94,

686: l.pval092 d92,
687: decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
688: l.pval093 d93,
689: decode(l.pval094,cn,vn,vn,vn,
690: hr_pump_get.gl(l.pval094,'YES_NO',dn,l.pval137)) p94,
691: l.pval094 d94,
692: decode(l.pval095,cn,vn,vn,vn,l.pval095) p95,
693: l.pval095 d95,
694: decode(l.pval096,cn,vn,vn,vn,l.pval096) p96,

Line 699: hr_pump_get.gl(l.pval098,'YES_NO',dn,l.pval137)) p98,

695: l.pval096 d96,
696: decode(l.pval097,cn,dn,vn,dn,d(l.pval097)) p97,
697: l.pval097 d97,
698: decode(l.pval098,cn,vn,vn,vn,
699: hr_pump_get.gl(l.pval098,'YES_NO',dn,l.pval137)) p98,
700: l.pval098 d98,
701: decode(l.pval099,cn,dn,vn,dn,d(l.pval099)) p99,
702: l.pval099 d99,
703: decode(l.pval100,cn,vn,vn,vn,

Line 704: hr_pump_get.gl(l.pval100,'YES_NO',dn,l.pval137)) p100,

700: l.pval098 d98,
701: decode(l.pval099,cn,dn,vn,dn,d(l.pval099)) p99,
702: l.pval099 d99,
703: decode(l.pval100,cn,vn,vn,vn,
704: hr_pump_get.gl(l.pval100,'YES_NO',dn,l.pval137)) p100,
705: l.pval100 d100,
706: decode(l.pval101,cn,vn,vn,vn,
707: hr_pump_get.gl(l.pval101,'STUDENT_STATUS',dn,l.pval137)) p101,
708: l.pval101 d101,

Line 707: hr_pump_get.gl(l.pval101,'STUDENT_STATUS',dn,l.pval137)) p101,

703: decode(l.pval100,cn,vn,vn,vn,
704: hr_pump_get.gl(l.pval100,'YES_NO',dn,l.pval137)) p100,
705: l.pval100 d100,
706: decode(l.pval101,cn,vn,vn,vn,
707: hr_pump_get.gl(l.pval101,'STUDENT_STATUS',dn,l.pval137)) p101,
708: l.pval101 d101,
709: decode(l.pval102,cn,vn,vn,vn,
710: hr_pump_get.gl(l.pval102,'WORK_SCHEDULE',dn,l.pval137)) p102,
711: l.pval102 d102,

Line 710: hr_pump_get.gl(l.pval102,'WORK_SCHEDULE',dn,l.pval137)) p102,

706: decode(l.pval101,cn,vn,vn,vn,
707: hr_pump_get.gl(l.pval101,'STUDENT_STATUS',dn,l.pval137)) p101,
708: l.pval101 d101,
709: decode(l.pval102,cn,vn,vn,vn,
710: hr_pump_get.gl(l.pval102,'WORK_SCHEDULE',dn,l.pval137)) p102,
711: l.pval102 d102,
712: decode(l.pval103,cn,vn,vn,vn,l.pval103) p103,
713: l.pval103 d103,
714: decode(l.pval104,cn,dn,vn,dn,d(l.pval104)) p104,

Line 719: hr_pump_get.gl(l.pval106,'YES_NO',dn,l.pval137)) p106,

715: l.pval104 d104,
716: decode(l.pval105,cn,vn,vn,vn,l.pval105) p105,
717: l.pval105 d105,
718: decode(l.pval106,cn,vn,vn,'N',
719: hr_pump_get.gl(l.pval106,'YES_NO',dn,l.pval137)) p106,
720: l.pval106 d106,
721: decode(l.pval107,cn,vn,vn,vn,l.pval107) p107,
722: l.pval107 d107,
723: decode(l.pval108,cn,vn,vn,vn,l.pval108) p108,

Line 734: hr_pump_get.gl(l.pval113,'TOBACCO_USER',dn,l.pval137)) p113,

730: l.pval111 d111,
731: decode(l.pval112,cn,dn,vn,dn,d(l.pval112)) p112,
732: l.pval112 d112,
733: decode(l.pval113,cn,vn,vn,vn,
734: hr_pump_get.gl(l.pval113,'TOBACCO_USER',dn,l.pval137)) p113,
735: l.pval113 d113,
736: decode(l.pval114,cn,dn,vn,dn,d(l.pval114)) p114,
737: l.pval114 d114,
738: decode(l.pval115,cn,vn,vn,'N',

Line 739: hr_pump_get.gl(l.pval115,'YES_NO',dn,l.pval137)) p115,

735: l.pval113 d113,
736: decode(l.pval114,cn,dn,vn,dn,d(l.pval114)) p114,
737: l.pval114 d114,
738: decode(l.pval115,cn,vn,vn,'N',
739: hr_pump_get.gl(l.pval115,'YES_NO',dn,l.pval137)) p115,
740: l.pval115 d115,
741: decode(l.pval116,cn,dn,vn,dn,d(l.pval116)) p116,
742: l.pval116 d116,
743: decode(l.pval117,cn,dn,vn,dn,d(l.pval117)) p117,

Line 810: hr_pump_get.get_person_type_id

806: c.p137 is null then
807: L_PERSON_TYPE_ID:=nn;
808: else
809: L_PERSON_TYPE_ID :=
810: hr_pump_get.get_person_type_id
811: (P_USER_PERSON_TYPE => c.p136
812: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
813: ,P_LANGUAGE_CODE => c.p137);
814: end if;

Line 820: hr_pump_get.get_vendor_id

816: if c.p138 is null then
817: L_VENDOR_ID:=nn;
818: else
819: L_VENDOR_ID :=
820: hr_pump_get.get_vendor_id
821: (P_VENDOR_NAME => c.p138);
822: end if;
823: --
824: if c.p139 is null then

Line 828: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE

824: if c.p139 is null then
825: L_CORRESPONDENCE_LANGUAGE:=vn;
826: else
827: L_CORRESPONDENCE_LANGUAGE :=
828: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
829: (P_CORRESPONDENCE_LANGUAGE => c.p139);
830: end if;
831: --
832: if c.p140 is null then

Line 836: hr_pump_get.get_benefit_group_id

832: if c.p140 is null then
833: L_BENEFIT_GROUP_ID:=nn;
834: else
835: L_BENEFIT_GROUP_ID :=
836: hr_pump_get.get_benefit_group_id
837: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
838: ,P_BENEFIT_GROUP => c.p140);
839: end if;
840: --