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

Line 458: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval111)) p4,

454: decode(l.pval002,cn,vn,l.pval002) p2,
455: decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
456: l.pval003 d3,
457: decode(l.pval004,cn,vn,vn,vh,
458: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval111)) p4,
459: l.pval004 d4,
460: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
461: l.pval005 d5,
462: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,

Line 465: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval111)) p7,

461: l.pval005 d5,
462: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
463: l.pval006 d6,
464: decode(l.pval007,cn,vn,vn,vh,
465: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval111)) p7,
466: l.pval007 d7,
467: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
468: l.pval008 d8,
469: decode(l.pval009,cn,vn,vn,vh,

Line 470: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval111)) p9,

466: l.pval007 d7,
467: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
468: l.pval008 d8,
469: decode(l.pval009,cn,vn,vn,vh,
470: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval111)) p9,
471: l.pval009 d9,
472: decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
473: l.pval010 d10,
474: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,

Line 477: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval111)) p12,

473: l.pval010 d10,
474: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
475: l.pval011 d11,
476: decode(l.pval012,cn,vn,vn,vh,
477: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval111)) p12,
478: l.pval012 d12,
479: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
480: l.pval013 d13,
481: decode(l.pval014,cn,vn,vn,vh,

Line 482: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval111)) p14,

478: l.pval012 d12,
479: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
480: l.pval013 d13,
481: decode(l.pval014,cn,vn,vn,vh,
482: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval111)) p14,
483: l.pval014 d14,
484: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
485: l.pval015 d15,
486: decode(l.pval016,cn,vn,vn,vh,

Line 487: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval111)) p16,

483: l.pval014 d14,
484: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
485: l.pval015 d15,
486: decode(l.pval016,cn,vn,vn,vh,
487: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval111)) p16,
488: l.pval016 d16,
489: decode(l.pval017,cn,vn,vn,vh,
490: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval111)) p17,
491: l.pval017 d17,

Line 490: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval111)) p17,

486: decode(l.pval016,cn,vn,vn,vh,
487: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval111)) p16,
488: l.pval016 d16,
489: decode(l.pval017,cn,vn,vn,vh,
490: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval111)) p17,
491: l.pval017 d17,
492: decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
493: l.pval018 d18,
494: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,

Line 497: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval111)) p20,

493: l.pval018 d18,
494: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
495: l.pval019 d19,
496: decode(l.pval020,cn,vn,vn,vh,
497: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval111)) p20,
498: l.pval020 d20,
499: decode(l.pval021,cn,vn,vn,vh,
500: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval111)) p21,
501: l.pval021 d21,

Line 500: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval111)) p21,

496: decode(l.pval020,cn,vn,vn,vh,
497: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval111)) p20,
498: l.pval020 d20,
499: decode(l.pval021,cn,vn,vn,vh,
500: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval111)) p21,
501: l.pval021 d21,
502: decode(l.pval022,cn,vn,vn,vh,
503: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval111)) p22,
504: l.pval022 d22,

Line 503: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval111)) p22,

499: decode(l.pval021,cn,vn,vn,vh,
500: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval111)) p21,
501: l.pval021 d21,
502: decode(l.pval022,cn,vn,vn,vh,
503: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval111)) p22,
504: l.pval022 d22,
505: decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
506: l.pval023 d23,
507: decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,

Line 570: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval111)) p55,

566: l.pval053 d53,
567: decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
568: l.pval054 d54,
569: decode(l.pval055,cn,vn,vn,vh,
570: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval111)) p55,
571: l.pval055 d55,
572: decode(l.pval056,cn,vn,vn,vh,l.pval056) p56,
573: l.pval056 d56,
574: decode(l.pval057,cn,dn,vn,dh,d(l.pval057)) p57,

Line 579: hr_pump_get.gl(l.pval059,'RU_LIMITED_CONTRACT_REASON',d(l.pval001),l.pval111)) p59,

575: l.pval057 d57,
576: decode(l.pval058,cn,dn,vn,dh,d(l.pval058)) p58,
577: l.pval058 d58,
578: decode(l.pval059,cn,vn,vn,vh,
579: hr_pump_get.gl(l.pval059,'RU_LIMITED_CONTRACT_REASON',d(l.pval001),l.pval111)) p59,
580: l.pval059 d59,
581: decode(l.pval060,cn,vn,vn,vh,
582: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval001),l.pval111)) p60,
583: l.pval060 d60,

Line 582: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval001),l.pval111)) p60,

578: decode(l.pval059,cn,vn,vn,vh,
579: hr_pump_get.gl(l.pval059,'RU_LIMITED_CONTRACT_REASON',d(l.pval001),l.pval111)) p59,
580: l.pval059 d59,
581: decode(l.pval060,cn,vn,vn,vh,
582: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval001),l.pval111)) p60,
583: l.pval060 d60,
584: decode(l.pval061,cn,vn,vn,vh,
585: hr_pump_get.gl(l.pval061,'RU_TERRITORY_CONDITIONS',d(l.pval001),l.pval111)) p61,
586: l.pval061 d61,

Line 585: hr_pump_get.gl(l.pval061,'RU_TERRITORY_CONDITIONS',d(l.pval001),l.pval111)) p61,

581: decode(l.pval060,cn,vn,vn,vh,
582: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval001),l.pval111)) p60,
583: l.pval060 d60,
584: decode(l.pval061,cn,vn,vn,vh,
585: hr_pump_get.gl(l.pval061,'RU_TERRITORY_CONDITIONS',d(l.pval001),l.pval111)) p61,
586: l.pval061 d61,
587: decode(l.pval062,cn,vn,vn,vh,
588: hr_pump_get.gl(l.pval062,'RU_SPECIAL_WORK_CONDITIONS',d(l.pval001),l.pval111)) p62,
589: l.pval062 d62,

Line 588: hr_pump_get.gl(l.pval062,'RU_SPECIAL_WORK_CONDITIONS',d(l.pval001),l.pval111)) p62,

584: decode(l.pval061,cn,vn,vn,vh,
585: hr_pump_get.gl(l.pval061,'RU_TERRITORY_CONDITIONS',d(l.pval001),l.pval111)) p61,
586: l.pval061 d61,
587: decode(l.pval062,cn,vn,vn,vh,
588: hr_pump_get.gl(l.pval062,'RU_SPECIAL_WORK_CONDITIONS',d(l.pval001),l.pval111)) p62,
589: l.pval062 d62,
590: decode(l.pval063,cn,vn,vn,vh,
591: hr_pump_get.gl(l.pval063,'RU_CALC_RECORD_SERVICE',d(l.pval001),l.pval111)) p63,
592: l.pval063 d63,

Line 591: hr_pump_get.gl(l.pval063,'RU_CALC_RECORD_SERVICE',d(l.pval001),l.pval111)) p63,

587: decode(l.pval062,cn,vn,vn,vh,
588: hr_pump_get.gl(l.pval062,'RU_SPECIAL_WORK_CONDITIONS',d(l.pval001),l.pval111)) p62,
589: l.pval062 d62,
590: decode(l.pval063,cn,vn,vn,vh,
591: hr_pump_get.gl(l.pval063,'RU_CALC_RECORD_SERVICE',d(l.pval001),l.pval111)) p63,
592: l.pval063 d63,
593: decode(l.pval064,cn,vn,vn,vh,l.pval064) p64,
594: l.pval064 d64,
595: decode(l.pval065,cn,vn,vn,vh,

Line 596: hr_pump_get.gl(l.pval065,'RU_LONG_SERVICE',d(l.pval001),l.pval111)) p65,

592: l.pval063 d63,
593: decode(l.pval064,cn,vn,vn,vh,l.pval064) p64,
594: l.pval064 d64,
595: decode(l.pval065,cn,vn,vn,vh,
596: hr_pump_get.gl(l.pval065,'RU_LONG_SERVICE',d(l.pval001),l.pval111)) p65,
597: l.pval065 d65,
598: decode(l.pval066,cn,vn,vn,vh,l.pval066) p66,
599: l.pval066 d66,
600: decode(l.pval067,cn,vn,vn,vh,

Line 601: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval111)) p67,

597: l.pval065 d65,
598: decode(l.pval066,cn,vn,vn,vh,l.pval066) p66,
599: l.pval066 d66,
600: decode(l.pval067,cn,vn,vn,vh,
601: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval111)) p67,
602: l.pval067 d67,
603: decode(l.pval068,cn,vn,vn,vh,
604: hr_pump_get.gl(l.pval068,'YES_NO',d(l.pval001),l.pval111)) p68,
605: l.pval068 d68,

Line 604: hr_pump_get.gl(l.pval068,'YES_NO',d(l.pval001),l.pval111)) p68,

600: decode(l.pval067,cn,vn,vn,vh,
601: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval111)) p67,
602: l.pval067 d67,
603: decode(l.pval068,cn,vn,vn,vh,
604: hr_pump_get.gl(l.pval068,'YES_NO',d(l.pval001),l.pval111)) p68,
605: l.pval068 d68,
606: decode(l.pval069,cn,vn,vn,vh,l.pval069) p69,
607: l.pval069 d69,
608: decode(l.pval070,cn,vn,vn,vh,l.pval070) p70,

Line 736: hr_pump_get.get_assignment_id

732: if c.p108 is null then
733: L_ASSIGNMENT_ID:=nn;
734: else
735: L_ASSIGNMENT_ID :=
736: hr_pump_get.get_assignment_id
737: (P_ASSIGNMENT_USER_KEY => c.p108);
738: end if;
739: --
740: if c.p108 is null or

Line 745: hr_pump_get.GET_ASG_OVN

741: c.p1 is null then
742: L_OBJECT_VERSION_NUMBER:=nn;
743: else
744: L_OBJECT_VERSION_NUMBER :=
745: hr_pump_get.GET_ASG_OVN
746: (P_ASSIGNMENT_USER_KEY => c.p108
747: ,P_EFFECTIVE_DATE => c.p1);
748: end if;
749: --

Line 756: hr_pump_get.get_supervisor_id

752: elsif c.d109 is null then
753: L_SUPERVISOR_ID:=nh;
754: else
755: L_SUPERVISOR_ID :=
756: hr_pump_get.get_supervisor_id
757: (P_SUPERVISOR_USER_KEY => c.p109);
758: end if;
759: --
760: if c.d110=cn or

Line 768: hr_pump_get.get_assignment_status_type_id

764: c.d111 is null then
765: L_ASSIGNMENT_STATUS_TYPE_ID:=nh;
766: else
767: L_ASSIGNMENT_STATUS_TYPE_ID :=
768: hr_pump_get.get_assignment_status_type_id
769: (P_USER_STATUS => c.p110
770: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
771: ,P_LANGUAGE_CODE => c.p111);
772: end if;

Line 780: hr_pump_get.get_default_code_comb_id

776: elsif c.d112 is null then
777: L_DEFAULT_CODE_COMB_ID:=nh;
778: else
779: L_DEFAULT_CODE_COMB_ID :=
780: hr_pump_get.get_default_code_comb_id
781: (P_DEFAULT_CODE_COMB_USER_KEY => c.p112);
782: end if;
783: --
784: if c.d113=cn then

Line 790: hr_pump_get.get_set_of_books_id

786: elsif c.d113 is null then
787: L_SET_OF_BOOKS_ID:=nh;
788: else
789: L_SET_OF_BOOKS_ID :=
790: hr_pump_get.get_set_of_books_id
791: (P_SET_OF_BOOKS_NAME => c.p113);
792: end if;
793: --
794: if c.d114=cn or

Line 816: hr_pump_get.get_contract_id

812: elsif c.d115 is null then
813: L_CONTRACT_ID:=nh;
814: else
815: L_CONTRACT_ID :=
816: hr_pump_get.get_contract_id
817: (P_CONTRACT_USER_KEY => c.p115);
818: end if;
819: --
820: if c.d116=cn or

Line 829: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

825: c.d111 is null then
826: L_ESTABLISHMENT_ID:=nh;
827: else
828: L_ESTABLISHMENT_ID :=
829: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
830: (P_ESTABLISHMENT_ORG_NAME => c.p116
831: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
832: ,P_EFFECTIVE_DATE => c.p1
833: ,P_LANGUAGE_CODE => c.p111);

Line 843: hr_pump_get.get_collective_agreement_id

839: elsif c.d117 is null then
840: L_COLLECTIVE_AGREEMENT_ID:=nh;
841: else
842: L_COLLECTIVE_AGREEMENT_ID :=
843: hr_pump_get.get_collective_agreement_id
844: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
845: ,P_CAGR_NAME => c.p117
846: ,P_EFFECTIVE_DATE => c.p1);
847: end if;

Line 855: hr_pump_get.GET_CAGR_ID_FLEX_NUM

851: elsif c.d118 is null then
852: L_CAGR_ID_FLEX_NUM:=nh;
853: else
854: L_CAGR_ID_FLEX_NUM :=
855: hr_pump_get.GET_CAGR_ID_FLEX_NUM
856: (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p118);
857: end if;
858: --
859: if c.d119=cn then

Line 865: hr_pump_get.get_supervisor_assignment_id

861: elsif c.d119 is null then
862: L_SUPERVISOR_ASSIGNMENT_ID:=nh;
863: else
864: L_SUPERVISOR_ASSIGNMENT_ID :=
865: hr_pump_get.get_supervisor_assignment_id
866: (P_SVR_ASSIGNMENT_USER_KEY => c.p119);
867: end if;
868: --
869: if c.p120 is null or

Line 874: hr_pump_get.get_soft_coding_keyflex_id

870: c.p1 is null then
871: L_SOFT_CODING_KEYFLEX_ID:=nn;
872: else
873: L_SOFT_CODING_KEYFLEX_ID :=
874: hr_pump_get.get_soft_coding_keyflex_id
875: (P_CON_SEG_USER_NAME => c.p120
876: ,P_EFFECTIVE_DATE => c.p1);
877: end if;
878: --