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

Line 495: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval125)) p4,

491: decode(l.pval002,cn,vn,l.pval002) p2,
492: decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
493: l.pval003 d3,
494: decode(l.pval004,cn,vn,vn,vh,
495: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval125)) p4,
496: l.pval004 d4,
497: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
498: l.pval005 d5,
499: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,

Line 502: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval125)) p7,

498: l.pval005 d5,
499: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
500: l.pval006 d6,
501: decode(l.pval007,cn,vn,vn,vh,
502: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval125)) p7,
503: l.pval007 d7,
504: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
505: l.pval008 d8,
506: decode(l.pval009,cn,vn,vn,vh,

Line 507: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval125)) p9,

503: l.pval007 d7,
504: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
505: l.pval008 d8,
506: decode(l.pval009,cn,vn,vn,vh,
507: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval125)) p9,
508: l.pval009 d9,
509: decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
510: l.pval010 d10,
511: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,

Line 514: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval125)) p12,

510: l.pval010 d10,
511: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
512: l.pval011 d11,
513: decode(l.pval012,cn,vn,vn,vh,
514: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval125)) p12,
515: l.pval012 d12,
516: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
517: l.pval013 d13,
518: decode(l.pval014,cn,vn,vn,vh,

Line 519: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval125)) p14,

515: l.pval012 d12,
516: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
517: l.pval013 d13,
518: decode(l.pval014,cn,vn,vn,vh,
519: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval125)) p14,
520: l.pval014 d14,
521: decode(l.pval015,cn,vn,vn,vh,l.pval015) p15,
522: l.pval015 d15,
523: decode(l.pval016,cn,nn,vn,nh,n(l.pval016)) p16,

Line 526: hr_pump_get.gl(l.pval017,'FREQUENCY',d(l.pval001),l.pval125)) p17,

522: l.pval015 d15,
523: decode(l.pval016,cn,nn,vn,nh,n(l.pval016)) p16,
524: l.pval016 d16,
525: decode(l.pval017,cn,vn,vn,vh,
526: hr_pump_get.gl(l.pval017,'FREQUENCY',d(l.pval001),l.pval125)) p17,
527: l.pval017 d17,
528: decode(l.pval018,cn,vn,vn,vh,
529: hr_pump_get.gl(l.pval018,'REC_TYPE',d(l.pval001),l.pval125)) p18,
530: l.pval018 d18,

Line 529: hr_pump_get.gl(l.pval018,'REC_TYPE',d(l.pval001),l.pval125)) p18,

525: decode(l.pval017,cn,vn,vn,vh,
526: hr_pump_get.gl(l.pval017,'FREQUENCY',d(l.pval001),l.pval125)) p17,
527: l.pval017 d17,
528: decode(l.pval018,cn,vn,vn,vh,
529: hr_pump_get.gl(l.pval018,'REC_TYPE',d(l.pval001),l.pval125)) p18,
530: l.pval018 d18,
531: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
532: l.pval019 d19,
533: decode(l.pval020,cn,vn,vn,vh,l.pval020) p20,

Line 536: hr_pump_get.gl(l.pval021,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval125)) p21,

532: l.pval019 d19,
533: decode(l.pval020,cn,vn,vn,vh,l.pval020) p20,
534: l.pval020 d20,
535: decode(l.pval021,cn,vn,vn,vh,
536: hr_pump_get.gl(l.pval021,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval125)) p21,
537: l.pval021 d21,
538: decode(l.pval022,cn,vn,vn,vh,
539: hr_pump_get.gl(l.pval022,'YES_NO',d(l.pval001),l.pval125)) p22,
540: l.pval022 d22,

Line 539: hr_pump_get.gl(l.pval022,'YES_NO',d(l.pval001),l.pval125)) p22,

535: decode(l.pval021,cn,vn,vn,vh,
536: hr_pump_get.gl(l.pval021,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval125)) p21,
537: l.pval021 d21,
538: decode(l.pval022,cn,vn,vn,vh,
539: hr_pump_get.gl(l.pval022,'YES_NO',d(l.pval001),l.pval125)) p22,
540: l.pval022 d22,
541: decode(l.pval023,cn,vn,vn,vh,
542: hr_pump_get.gl(l.pval023,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval125)) p23,
543: l.pval023 d23,

Line 542: hr_pump_get.gl(l.pval023,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval125)) p23,

538: decode(l.pval022,cn,vn,vn,vh,
539: hr_pump_get.gl(l.pval022,'YES_NO',d(l.pval001),l.pval125)) p22,
540: l.pval022 d22,
541: decode(l.pval023,cn,vn,vn,vh,
542: hr_pump_get.gl(l.pval023,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval125)) p23,
543: l.pval023 d23,
544: decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,
545: l.pval024 d24,
546: decode(l.pval025,cn,vn,vn,vh,l.pval025) p25,

Line 789: hr_pump_get.get_assignment_id

785: if c.p122 is null then
786: L_ASSIGNMENT_ID:=nn;
787: else
788: L_ASSIGNMENT_ID :=
789: hr_pump_get.get_assignment_id
790: (P_ASSIGNMENT_USER_KEY => c.p122);
791: end if;
792: --
793: if c.p122 is null or

Line 798: hr_pump_get.GET_ASG_OVN

794: c.p1 is null then
795: L_OBJECT_VERSION_NUMBER:=nn;
796: else
797: L_OBJECT_VERSION_NUMBER :=
798: hr_pump_get.GET_ASG_OVN
799: (P_ASSIGNMENT_USER_KEY => c.p122
800: ,P_EFFECTIVE_DATE => c.p1);
801: end if;
802: --

Line 809: hr_pump_get.get_supervisor_id

805: elsif c.d123 is null then
806: L_SUPERVISOR_ID:=nh;
807: else
808: L_SUPERVISOR_ID :=
809: hr_pump_get.get_supervisor_id
810: (P_SUPERVISOR_USER_KEY => c.p123);
811: end if;
812: --
813: if c.d124=cn or

Line 821: hr_pump_get.get_assignment_status_type_id

817: c.d125 is null then
818: L_ASSIGNMENT_STATUS_TYPE_ID:=nh;
819: else
820: L_ASSIGNMENT_STATUS_TYPE_ID :=
821: hr_pump_get.get_assignment_status_type_id
822: (P_USER_STATUS => c.p124
823: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
824: ,P_LANGUAGE_CODE => c.p125);
825: end if;

Line 833: hr_pump_get.get_default_code_comb_id

829: elsif c.d126 is null then
830: L_DEFAULT_CODE_COMB_ID:=nh;
831: else
832: L_DEFAULT_CODE_COMB_ID :=
833: hr_pump_get.get_default_code_comb_id
834: (P_DEFAULT_CODE_COMB_USER_KEY => c.p126);
835: end if;
836: --
837: if c.d127=cn then

Line 843: hr_pump_get.get_set_of_books_id

839: elsif c.d127 is null then
840: L_SET_OF_BOOKS_ID:=nh;
841: else
842: L_SET_OF_BOOKS_ID :=
843: hr_pump_get.get_set_of_books_id
844: (P_SET_OF_BOOKS_NAME => c.p127);
845: end if;
846: --
847: if c.d128=cn then

Line 853: hr_pump_get.get_contract_id

849: elsif c.d128 is null then
850: L_CONTRACT_ID:=nh;
851: else
852: L_CONTRACT_ID :=
853: hr_pump_get.get_contract_id
854: (P_CONTRACT_USER_KEY => c.p128);
855: end if;
856: --
857: if c.d129=cn or

Line 866: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

862: c.d125 is null then
863: L_ESTABLISHMENT_ID:=nh;
864: else
865: L_ESTABLISHMENT_ID :=
866: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
867: (P_ESTABLISHMENT_ORG_NAME => c.p129
868: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
869: ,P_EFFECTIVE_DATE => c.p1
870: ,P_LANGUAGE_CODE => c.p125);

Line 880: hr_pump_get.get_collective_agreement_id

876: elsif c.d130 is null then
877: L_COLLECTIVE_AGREEMENT_ID:=nh;
878: else
879: L_COLLECTIVE_AGREEMENT_ID :=
880: hr_pump_get.get_collective_agreement_id
881: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
882: ,P_CAGR_NAME => c.p130
883: ,P_EFFECTIVE_DATE => c.p1);
884: end if;

Line 892: hr_pump_get.GET_CAGR_ID_FLEX_NUM

888: elsif c.d131 is null then
889: L_CAGR_ID_FLEX_NUM:=nh;
890: else
891: L_CAGR_ID_FLEX_NUM :=
892: hr_pump_get.GET_CAGR_ID_FLEX_NUM
893: (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p131);
894: end if;
895: --
896: if c.d132=cn then

Line 902: hr_pump_get.get_supervisor_assignment_id

898: elsif c.d132 is null then
899: L_SUPERVISOR_ASSIGNMENT_ID:=nh;
900: else
901: L_SUPERVISOR_ASSIGNMENT_ID :=
902: hr_pump_get.get_supervisor_assignment_id
903: (P_SVR_ASSIGNMENT_USER_KEY => c.p132);
904: end if;
905: --
906: if c.p133 is null or

Line 911: hr_pump_get.get_soft_coding_keyflex_id

907: c.p1 is null then
908: L_SOFT_CODING_KEYFLEX_ID:=nn;
909: else
910: L_SOFT_CODING_KEYFLEX_ID :=
911: hr_pump_get.get_soft_coding_keyflex_id
912: (P_CON_SEG_USER_NAME => c.p133
913: ,P_EFFECTIVE_DATE => c.p1);
914: end if;
915: --