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

Line 431: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),l.pval112)) p4,

427: decode(l.pval001,cn,dn,d(l.pval001)) p1,
428: decode(l.pval002,cn,vn,l.pval002) p2,
429: decode(l.pval003,cn,vn,l.pval003) p3,
430: decode(l.pval004,cn,vn,vn,vn,
431: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),l.pval112)) p4,
432: l.pval004 d4,
433: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
434: l.pval005 d5,
435: decode(l.pval006,cn,vn,vn,vn,l.pval006) p6,

Line 448: hr_pump_get.gl(l.pval012,'YES_NO',d(l.pval001),l.pval112)) p12,

444: l.pval010 d10,
445: decode(l.pval011,cn,dn,vn,dn,d(l.pval011)) p11,
446: l.pval011 d11,
447: decode(l.pval012,cn,vn,vn,'N',
448: hr_pump_get.gl(l.pval012,'YES_NO',d(l.pval001),l.pval112)) p12,
449: l.pval012 d12,
450: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
451: l.pval013 d13,
452: decode(l.pval014,cn,vn,l.pval014) p14,

Line 468: hr_pump_get.gl(l.pval022,'MAR_STATUS',d(l.pval001),l.pval112)) p22,

464: l.pval020 d20,
465: decode(l.pval021,cn,vn,vn,vn,l.pval021) p21,
466: l.pval021 d21,
467: decode(l.pval022,cn,vn,vn,vn,
468: hr_pump_get.gl(l.pval022,'MAR_STATUS',d(l.pval001),l.pval112)) p22,
469: l.pval022 d22,
470: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
471: l.pval023 d23,
472: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,

Line 475: hr_pump_get.gl(l.pval025,'NATIONALITY',d(l.pval001),l.pval112)) p25,

471: l.pval023 d23,
472: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
473: l.pval024 d24,
474: decode(l.pval025,cn,vn,vn,vn,
475: hr_pump_get.gl(l.pval025,'NATIONALITY',d(l.pval001),l.pval112)) p25,
476: l.pval025 d25,
477: decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
478: l.pval026 d26,
479: decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,

Line 494: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval001),l.pval112)) p34,

490: l.pval032 d32,
491: decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
492: l.pval033 d33,
493: decode(l.pval034,cn,vn,vn,vn,
494: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval001),l.pval112)) p34,
495: l.pval034 d34,
496: decode(l.pval035,cn,vn,vn,vn,
497: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval001),l.pval112)) p35,
498: l.pval035 d35,

Line 497: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval001),l.pval112)) p35,

493: decode(l.pval034,cn,vn,vn,vn,
494: hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval001),l.pval112)) p34,
495: l.pval034 d34,
496: decode(l.pval035,cn,vn,vn,vn,
497: hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval001),l.pval112)) p35,
498: l.pval035 d35,
499: decode(l.pval036,cn,dn,vn,dn,d(l.pval036)) p36,
500: l.pval036 d36,
501: decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,

Line 504: hr_pump_get.gl(l.pval038,'SEX',d(l.pval001),l.pval112)) p38,

500: l.pval036 d36,
501: decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
502: l.pval037 d37,
503: decode(l.pval038,cn,vn,vn,vn,
504: hr_pump_get.gl(l.pval038,'SEX',d(l.pval001),l.pval112)) p38,
505: l.pval038 d38,
506: decode(l.pval039,cn,vn,vn,vn,l.pval039) p39,
507: l.pval039 d39,
508: decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,

Line 511: hr_pump_get.gl(l.pval041,'TITLE',d(l.pval001),l.pval112)) p41,

507: l.pval039 d39,
508: decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
509: l.pval040 d40,
510: decode(l.pval041,cn,vn,vn,vn,
511: hr_pump_get.gl(l.pval041,'TITLE',d(l.pval001),l.pval112)) p41,
512: l.pval041 d41,
513: decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
514: l.pval042 d42,
515: decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,

Line 518: hr_pump_get.gl(l.pval044,'WORK_SCHEDULE',d(l.pval001),l.pval112)) p44,

514: l.pval042 d42,
515: decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
516: l.pval043 d43,
517: decode(l.pval044,cn,vn,vn,vn,
518: hr_pump_get.gl(l.pval044,'WORK_SCHEDULE',d(l.pval001),l.pval112)) p44,
519: l.pval044 d44,
520: decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
521: l.pval045 d45,
522: decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,

Line 531: hr_pump_get.gl(l.pval050,'YES_NO',d(l.pval001),l.pval112)) p50,

527: l.pval048 d48,
528: decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
529: l.pval049 d49,
530: decode(l.pval050,cn,vn,vn,'N',
531: hr_pump_get.gl(l.pval050,'YES_NO',d(l.pval001),l.pval112)) p50,
532: l.pval050 d50,
533: decode(l.pval051,cn,dn,vn,dn,d(l.pval051)) p51,
534: l.pval051 d51,
535: decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,

Line 598: hr_pump_get.gl(l.pval083,'RU_OKATO',d(l.pval001),l.pval112)) p83,

594: l.pval081 d81,
595: decode(l.pval082,cn,vn,vn,vn,l.pval082) p82,
596: l.pval082 d82,
597: decode(l.pval083,cn,vn,vn,vn,
598: hr_pump_get.gl(l.pval083,'RU_OKATO',d(l.pval001),l.pval112)) p83,
599: l.pval083 d83,
600: decode(l.pval084,cn,vn,vn,vn,l.pval084) p84,
601: l.pval084 d84,
602: decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,

Line 605: hr_pump_get.gl(l.pval086,'RU_CITIZENSHIP',d(l.pval001),l.pval112)) p86,

601: l.pval084 d84,
602: decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
603: l.pval085 d85,
604: decode(l.pval086,cn,vn,
605: hr_pump_get.gl(l.pval086,'RU_CITIZENSHIP',d(l.pval001),l.pval112)) p86,
606: decode(l.pval087,cn,vn,vn,vn,
607: hr_pump_get.gl(l.pval087,'RU_MILITARY_DOC_TYPE',d(l.pval001),l.pval112)) p87,
608: l.pval087 d87,
609: decode(l.pval088,cn,vn,vn,vn,

Line 607: hr_pump_get.gl(l.pval087,'RU_MILITARY_DOC_TYPE',d(l.pval001),l.pval112)) p87,

603: l.pval085 d85,
604: decode(l.pval086,cn,vn,
605: hr_pump_get.gl(l.pval086,'RU_CITIZENSHIP',d(l.pval001),l.pval112)) p86,
606: decode(l.pval087,cn,vn,vn,vn,
607: hr_pump_get.gl(l.pval087,'RU_MILITARY_DOC_TYPE',d(l.pval001),l.pval112)) p87,
608: l.pval087 d87,
609: decode(l.pval088,cn,vn,vn,vn,
610: hr_pump_get.gl(l.pval088,'RU_RESERVE_CATEGORY',d(l.pval001),l.pval112)) p88,
611: l.pval088 d88,

Line 610: hr_pump_get.gl(l.pval088,'RU_RESERVE_CATEGORY',d(l.pval001),l.pval112)) p88,

606: decode(l.pval087,cn,vn,vn,vn,
607: hr_pump_get.gl(l.pval087,'RU_MILITARY_DOC_TYPE',d(l.pval001),l.pval112)) p87,
608: l.pval087 d87,
609: decode(l.pval088,cn,vn,vn,vn,
610: hr_pump_get.gl(l.pval088,'RU_RESERVE_CATEGORY',d(l.pval001),l.pval112)) p88,
611: l.pval088 d88,
612: decode(l.pval089,cn,vn,vn,vn,
613: hr_pump_get.gl(l.pval089,'RU_MILITARY_RANK',d(l.pval001),l.pval112)) p89,
614: l.pval089 d89,

Line 613: hr_pump_get.gl(l.pval089,'RU_MILITARY_RANK',d(l.pval001),l.pval112)) p89,

609: decode(l.pval088,cn,vn,vn,vn,
610: hr_pump_get.gl(l.pval088,'RU_RESERVE_CATEGORY',d(l.pval001),l.pval112)) p88,
611: l.pval088 d88,
612: decode(l.pval089,cn,vn,vn,vn,
613: hr_pump_get.gl(l.pval089,'RU_MILITARY_RANK',d(l.pval001),l.pval112)) p89,
614: l.pval089 d89,
615: decode(l.pval090,cn,vn,vn,vn,
616: hr_pump_get.gl(l.pval090,'RU_MILITARY_PROFILE',d(l.pval001),l.pval112)) p90,
617: l.pval090 d90,

Line 616: hr_pump_get.gl(l.pval090,'RU_MILITARY_PROFILE',d(l.pval001),l.pval112)) p90,

612: decode(l.pval089,cn,vn,vn,vn,
613: hr_pump_get.gl(l.pval089,'RU_MILITARY_RANK',d(l.pval001),l.pval112)) p89,
614: l.pval089 d89,
615: decode(l.pval090,cn,vn,vn,vn,
616: hr_pump_get.gl(l.pval090,'RU_MILITARY_PROFILE',d(l.pval001),l.pval112)) p90,
617: l.pval090 d90,
618: decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
619: l.pval091 d91,
620: decode(l.pval092,cn,vn,vn,vn,

Line 621: hr_pump_get.gl(l.pval092,'RU_MILITARY_SERVICE_READINESS_CATEGORY',d(l.pval001),l.pval112)) p92,

617: l.pval090 d90,
618: decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
619: l.pval091 d91,
620: decode(l.pval092,cn,vn,vn,vn,
621: hr_pump_get.gl(l.pval092,'RU_MILITARY_SERVICE_READINESS_CATEGORY',d(l.pval001),l.pval112)) p92,
622: l.pval092 d92,
623: decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
624: l.pval093 d93,
625: decode(l.pval094,cn,vn,vn,vn,

Line 626: hr_pump_get.gl(l.pval094,'RU_QUITTING_MARK',d(l.pval001),l.pval112)) p94,

622: l.pval092 d92,
623: decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
624: l.pval093 d93,
625: decode(l.pval094,cn,vn,vn,vn,
626: hr_pump_get.gl(l.pval094,'RU_QUITTING_MARK',d(l.pval001),l.pval112)) p94,
627: l.pval094 d94,
628: decode(l.pval095,cn,vn,vn,vn,l.pval095) p95,
629: l.pval095 d95,
630: decode(l.pval096,cn,vn,vn,vn,l.pval096) p96,

Line 688: hr_pump_get.get_person_type_id

684: c.p112 is null then
685: L_PERSON_TYPE_ID:=nn;
686: else
687: L_PERSON_TYPE_ID :=
688: hr_pump_get.get_person_type_id
689: (P_USER_PERSON_TYPE => c.p111
690: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
691: ,P_LANGUAGE_CODE => c.p112);
692: end if;

Line 698: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE

694: if c.p113 is null then
695: L_CORRESPONDENCE_LANGUAGE:=vn;
696: else
697: L_CORRESPONDENCE_LANGUAGE :=
698: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
699: (P_CORRESPONDENCE_LANGUAGE => c.p113);
700: end if;
701: --
702: if c.p114 is null then

Line 706: hr_pump_get.get_vendor_id

702: if c.p114 is null then
703: L_VENDOR_ID:=nn;
704: else
705: L_VENDOR_ID :=
706: hr_pump_get.get_vendor_id
707: (P_VENDOR_NAME => c.p114);
708: end if;
709: --
710: if c.p115 is null then

Line 714: hr_pump_get.get_benefit_group_id

710: if c.p115 is null then
711: L_BENEFIT_GROUP_ID:=nn;
712: else
713: L_BENEFIT_GROUP_ID :=
714: hr_pump_get.get_benefit_group_id
715: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
716: ,P_BENEFIT_GROUP => c.p115);
717: end if;
718: --