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

Line 538: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval132)) p3,

534: select l.rowid myrowid,
535: decode(l.pval001,cn,dn,d(l.pval001)) p1,
536: decode(l.pval002,cn,vn,l.pval002) p2,
537: decode(l.pval003,cn,vn,vn,vn,
538: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval132)) p3,
539: l.pval003 d3,
540: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
541: l.pval004 d4,
542: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,

Line 545: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval132)) p6,

541: l.pval004 d4,
542: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
543: l.pval005 d5,
544: decode(l.pval006,cn,vn,vn,vn,
545: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval132)) p6,
546: l.pval006 d6,
547: decode(l.pval007,cn,vn,vn,vn,
548: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval132)) p7,
549: l.pval007 d7,

Line 548: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval132)) p7,

544: decode(l.pval006,cn,vn,vn,vn,
545: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval132)) p6,
546: l.pval006 d6,
547: decode(l.pval007,cn,vn,vn,vn,
548: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval132)) p7,
549: l.pval007 d7,
550: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
551: l.pval008 d8,
552: decode(l.pval009,cn,vn,vn,vn,

Line 553: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval132)) p9,

549: l.pval007 d7,
550: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
551: l.pval008 d8,
552: decode(l.pval009,cn,vn,vn,vn,
553: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval132)) p9,
554: l.pval009 d9,
555: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
556: l.pval010 d10,
557: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,

Line 560: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval132)) p12,

556: l.pval010 d10,
557: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
558: l.pval011 d11,
559: decode(l.pval012,cn,vn,vn,vn,
560: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval132)) p12,
561: l.pval012 d12,
562: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
563: l.pval013 d13,
564: decode(l.pval014,cn,vn,vn,vn,

Line 565: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval132)) p14,

561: l.pval012 d12,
562: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
563: l.pval013 d13,
564: decode(l.pval014,cn,vn,vn,vn,
565: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval132)) p14,
566: l.pval014 d14,
567: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
568: l.pval015 d15,
569: decode(l.pval016,cn,vn,vn,vn,

Line 570: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval132)) p16,

566: l.pval014 d14,
567: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
568: l.pval015 d15,
569: decode(l.pval016,cn,vn,vn,vn,
570: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval132)) p16,
571: l.pval016 d16,
572: decode(l.pval017,cn,vn,vn,vn,
573: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval132)) p17,
574: l.pval017 d17,

Line 573: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval132)) p17,

569: decode(l.pval016,cn,vn,vn,vn,
570: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval132)) p16,
571: l.pval016 d16,
572: decode(l.pval017,cn,vn,vn,vn,
573: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval132)) p17,
574: l.pval017 d17,
575: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
576: l.pval018 d18,
577: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,

Line 580: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval132)) p20,

576: l.pval018 d18,
577: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
578: l.pval019 d19,
579: decode(l.pval020,cn,vn,vn,vn,
580: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval132)) p20,
581: l.pval020 d20,
582: decode(l.pval021,cn,vn,vn,'N',
583: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval132)) p21,
584: l.pval021 d21,

Line 583: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval132)) p21,

579: decode(l.pval020,cn,vn,vn,vn,
580: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval132)) p20,
581: l.pval020 d20,
582: decode(l.pval021,cn,vn,vn,'N',
583: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval132)) p21,
584: l.pval021 d21,
585: decode(l.pval022,cn,vn,vn,vn,
586: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval132)) p22,
587: l.pval022 d22,

Line 586: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval132)) p22,

582: decode(l.pval021,cn,vn,vn,'N',
583: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval132)) p21,
584: l.pval021 d21,
585: decode(l.pval022,cn,vn,vn,vn,
586: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval132)) p22,
587: l.pval022 d22,
588: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
589: l.pval023 d23,
590: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,

Line 653: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval132)) p55,

649: l.pval053 d53,
650: decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
651: l.pval054 d54,
652: decode(l.pval055,cn,vn,vn,vn,
653: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval132)) p55,
654: l.pval055 d55,
655: decode(l.pval056,cn,vn,vn,vn,
656: hr_pump_get.gl(l.pval056,'HR_MX_EMP_CAT',d(l.pval001),l.pval132)) p56,
657: l.pval056 d56,

Line 656: hr_pump_get.gl(l.pval056,'HR_MX_EMP_CAT',d(l.pval001),l.pval132)) p56,

652: decode(l.pval055,cn,vn,vn,vn,
653: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval132)) p55,
654: l.pval055 d55,
655: decode(l.pval056,cn,vn,vn,vn,
656: hr_pump_get.gl(l.pval056,'HR_MX_EMP_CAT',d(l.pval001),l.pval132)) p56,
657: l.pval056 d56,
658: decode(l.pval057,cn,vn,vn,vn,
659: hr_pump_get.gl(l.pval057,'HR_MX_SS_SALARY_TYPE',d(l.pval001),l.pval132)) p57,
660: l.pval057 d57,

Line 659: hr_pump_get.gl(l.pval057,'HR_MX_SS_SALARY_TYPE',d(l.pval001),l.pval132)) p57,

655: decode(l.pval056,cn,vn,vn,vn,
656: hr_pump_get.gl(l.pval056,'HR_MX_EMP_CAT',d(l.pval001),l.pval132)) p56,
657: l.pval056 d56,
658: decode(l.pval057,cn,vn,vn,vn,
659: hr_pump_get.gl(l.pval057,'HR_MX_SS_SALARY_TYPE',d(l.pval001),l.pval132)) p57,
660: l.pval057 d57,
661: decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
662: l.pval058 d58,
663: decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,

Line 880: hr_pump_get.get_person_id

876: if c.p130 is null then
877: L_PERSON_ID:=nn;
878: else
879: L_PERSON_ID :=
880: hr_pump_get.get_person_id
881: (P_PERSON_USER_KEY => c.p130);
882: end if;
883: --
884: if c.p131 is null or

Line 890: hr_pump_get.get_organization_id

886: c.p132 is null then
887: L_ORGANIZATION_ID:=nn;
888: else
889: L_ORGANIZATION_ID :=
890: hr_pump_get.get_organization_id
891: (P_ORGANIZATION_NAME => c.p131
892: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
893: ,P_EFFECTIVE_DATE => c.p1
894: ,P_LANGUAGE_CODE => c.p132);

Line 902: hr_pump_get.get_grade_id

898: c.p1 is null then
899: L_GRADE_ID:=nn;
900: else
901: L_GRADE_ID :=
902: hr_pump_get.get_grade_id
903: (P_GRADE_NAME => c.p133
904: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
905: ,P_EFFECTIVE_DATE => c.p1);
906: end if;

Line 913: hr_pump_get.get_position_id

909: c.p1 is null then
910: L_POSITION_ID:=nn;
911: else
912: L_POSITION_ID :=
913: hr_pump_get.get_position_id
914: (P_POSITION_NAME => c.p134
915: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
916: ,P_EFFECTIVE_DATE => c.p1);
917: end if;

Line 924: hr_pump_get.get_job_id

920: c.p1 is null then
921: L_JOB_ID:=nn;
922: else
923: L_JOB_ID :=
924: hr_pump_get.get_job_id
925: (P_JOB_NAME => c.p135
926: ,P_EFFECTIVE_DATE => c.p1
927: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
928: end if;

Line 935: hr_pump_get.get_assignment_status_type_id

931: c.p132 is null then
932: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
933: else
934: L_ASSIGNMENT_STATUS_TYPE_ID :=
935: hr_pump_get.get_assignment_status_type_id
936: (P_USER_STATUS => c.p136
937: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
938: ,P_LANGUAGE_CODE => c.p132);
939: end if;

Line 946: hr_pump_get.get_payroll_id

942: c.p1 is null then
943: L_PAYROLL_ID:=nn;
944: else
945: L_PAYROLL_ID :=
946: hr_pump_get.get_payroll_id
947: (P_PAYROLL_NAME => c.p137
948: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
949: ,P_EFFECTIVE_DATE => c.p1);
950: end if;

Line 957: hr_pump_get.get_location_id

953: c.p132 is null then
954: L_LOCATION_ID:=nn;
955: else
956: L_LOCATION_ID :=
957: hr_pump_get.get_location_id
958: (P_LOCATION_CODE => c.p138
959: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
960: ,P_LANGUAGE_CODE => c.p132);
961: end if;

Line 967: hr_pump_get.get_supervisor_id

963: if c.p139 is null then
964: L_SUPERVISOR_ID:=nn;
965: else
966: L_SUPERVISOR_ID :=
967: hr_pump_get.get_supervisor_id
968: (P_SUPERVISOR_USER_KEY => c.p139);
969: end if;
970: --
971: if c.p140 is null then

Line 975: hr_pump_get.get_special_ceiling_step_id

971: if c.p140 is null then
972: L_SPECIAL_CEILING_STEP_ID:=nn;
973: else
974: L_SPECIAL_CEILING_STEP_ID :=
975: hr_pump_get.get_special_ceiling_step_id
976: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p140);
977: end if;
978: --
979: if c.p141 is null then

Line 983: hr_pump_get.get_pay_basis_id

979: if c.p141 is null then
980: L_PAY_BASIS_ID:=nn;
981: else
982: L_PAY_BASIS_ID :=
983: hr_pump_get.get_pay_basis_id
984: (P_PAY_BASIS_NAME => c.p141
985: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
986: end if;
987: --

Line 992: hr_pump_get.get_default_code_comb_id

988: if c.p142 is null then
989: L_DEFAULT_CODE_COMB_ID:=nn;
990: else
991: L_DEFAULT_CODE_COMB_ID :=
992: hr_pump_get.get_default_code_comb_id
993: (P_DEFAULT_CODE_COMB_USER_KEY => c.p142);
994: end if;
995: --
996: if c.p143 is null then

Line 1000: hr_pump_get.get_set_of_books_id

996: if c.p143 is null then
997: L_SET_OF_BOOKS_ID:=nn;
998: else
999: L_SET_OF_BOOKS_ID :=
1000: hr_pump_get.get_set_of_books_id
1001: (P_SET_OF_BOOKS_NAME => c.p143);
1002: end if;
1003: --
1004: if c.p144 is null then

Line 1017: hr_pump_get.GET_TIMECARD_APPROVER_ID

1013: if c.p145 is null then
1014: L_TIMECARD_APPROVER:=vn;
1015: else
1016: L_TIMECARD_APPROVER :=
1017: hr_pump_get.GET_TIMECARD_APPROVER_ID
1018: (P_TIMECARD_APPROVER_USER_KEY => c.p145);
1019: end if;
1020: --
1021: if c.p146 is null then

Line 1033: hr_pump_get.get_contract_id

1029: if c.p147 is null then
1030: L_CONTRACT_ID:=nn;
1031: else
1032: L_CONTRACT_ID :=
1033: hr_pump_get.get_contract_id
1034: (P_CONTRACT_USER_KEY => c.p147);
1035: end if;
1036: --
1037: if c.p148 is null or

Line 1043: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

1039: c.p132 is null then
1040: L_ESTABLISHMENT_ID:=nn;
1041: else
1042: L_ESTABLISHMENT_ID :=
1043: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
1044: (P_ESTABLISHMENT_ORG_NAME => c.p148
1045: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1046: ,P_EFFECTIVE_DATE => c.p1
1047: ,P_LANGUAGE_CODE => c.p132);

Line 1055: hr_pump_get.get_collective_agreement_id

1051: c.p1 is null then
1052: L_COLLECTIVE_AGREEMENT_ID:=nn;
1053: else
1054: L_COLLECTIVE_AGREEMENT_ID :=
1055: hr_pump_get.get_collective_agreement_id
1056: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1057: ,P_CAGR_NAME => c.p149
1058: ,P_EFFECTIVE_DATE => c.p1);
1059: end if;

Line 1065: hr_pump_get.GET_CAGR_ID_FLEX_NUM

1061: if c.p150 is null then
1062: L_CAGR_ID_FLEX_NUM:=nn;
1063: else
1064: L_CAGR_ID_FLEX_NUM :=
1065: hr_pump_get.GET_CAGR_ID_FLEX_NUM
1066: (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p150);
1067: end if;
1068: --
1069: if c.p151 is null or

Line 1074: hr_pump_get.GET_GRADE_LADDER_PGM_ID

1070: c.p1 is null then
1071: L_GRADE_LADDER_PGM_ID:=nn;
1072: else
1073: L_GRADE_LADDER_PGM_ID :=
1074: hr_pump_get.GET_GRADE_LADDER_PGM_ID
1075: (P_GRADE_LADDER_NAME => c.p151
1076: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1077: ,P_EFFECTIVE_DATE => c.p1);
1078: end if;

Line 1084: hr_pump_get.GET_SUPERVISOR_ASSIGNMENT_ID

1080: if c.p152 is null then
1081: L_SUPERVISOR_ASSIGNMENT_ID:=nn;
1082: else
1083: L_SUPERVISOR_ASSIGNMENT_ID :=
1084: hr_pump_get.GET_SUPERVISOR_ASSIGNMENT_ID
1085: (P_SVR_ASSIGNMENT_USER_KEY => c.p152);
1086: end if;
1087: --
1088: hr_data_pump.api_trc_on;