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

Line 502: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval125)) 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,vn,vn,
502: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval125)) p3,
503: l.pval003 d3,
504: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
505: l.pval004 d4,
506: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,

Line 509: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval125)) p6,

505: l.pval004 d4,
506: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
507: l.pval005 d5,
508: decode(l.pval006,cn,vn,vn,vn,
509: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval125)) p6,
510: l.pval006 d6,
511: decode(l.pval007,cn,vn,vn,vn,
512: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval125)) p7,
513: l.pval007 d7,

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

508: decode(l.pval006,cn,vn,vn,vn,
509: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval125)) p6,
510: l.pval006 d6,
511: decode(l.pval007,cn,vn,vn,vn,
512: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval125)) p7,
513: l.pval007 d7,
514: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
515: l.pval008 d8,
516: decode(l.pval009,cn,vn,vn,vn,

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

513: l.pval007 d7,
514: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
515: l.pval008 d8,
516: decode(l.pval009,cn,vn,vn,vn,
517: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval125)) p9,
518: l.pval009 d9,
519: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
520: l.pval010 d10,
521: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,

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

520: l.pval010 d10,
521: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
522: l.pval011 d11,
523: decode(l.pval012,cn,vn,vn,vn,
524: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval125)) p12,
525: l.pval012 d12,
526: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
527: l.pval013 d13,
528: decode(l.pval014,cn,vn,vn,vn,

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

525: l.pval012 d12,
526: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
527: l.pval013 d13,
528: decode(l.pval014,cn,vn,vn,vn,
529: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval125)) p14,
530: l.pval014 d14,
531: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
532: l.pval015 d15,
533: decode(l.pval016,cn,vn,vn,vn,

Line 534: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval125)) p16,

530: l.pval014 d14,
531: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
532: l.pval015 d15,
533: decode(l.pval016,cn,vn,vn,vn,
534: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval125)) p16,
535: l.pval016 d16,
536: decode(l.pval017,cn,vn,vn,vn,
537: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval125)) p17,
538: l.pval017 d17,

Line 537: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval125)) p17,

533: decode(l.pval016,cn,vn,vn,vn,
534: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval125)) p16,
535: l.pval016 d16,
536: decode(l.pval017,cn,vn,vn,vn,
537: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval125)) p17,
538: l.pval017 d17,
539: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
540: l.pval018 d18,
541: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,

Line 544: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval125)) p20,

540: l.pval018 d18,
541: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
542: l.pval019 d19,
543: decode(l.pval020,cn,vn,vn,vn,
544: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval125)) p20,
545: l.pval020 d20,
546: decode(l.pval021,cn,vn,vn,'N',
547: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval125)) p21,
548: l.pval021 d21,

Line 547: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval125)) p21,

543: decode(l.pval020,cn,vn,vn,vn,
544: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval125)) p20,
545: l.pval020 d20,
546: decode(l.pval021,cn,vn,vn,'N',
547: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval125)) p21,
548: l.pval021 d21,
549: decode(l.pval022,cn,vn,vn,vn,
550: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval125)) p22,
551: l.pval022 d22,

Line 550: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval125)) p22,

546: decode(l.pval021,cn,vn,vn,'N',
547: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval125)) p21,
548: l.pval021 d21,
549: decode(l.pval022,cn,vn,vn,vn,
550: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval125)) p22,
551: l.pval022 d22,
552: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
553: l.pval023 d23,
554: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,

Line 815: hr_pump_get.get_person_id

811: if c.p123 is null then
812: L_PERSON_ID:=nn;
813: else
814: L_PERSON_ID :=
815: hr_pump_get.get_person_id
816: (P_PERSON_USER_KEY => c.p123);
817: end if;
818: --
819: if c.p124 is null or

Line 825: hr_pump_get.get_organization_id

821: c.p125 is null then
822: L_ORGANIZATION_ID:=nn;
823: else
824: L_ORGANIZATION_ID :=
825: hr_pump_get.get_organization_id
826: (P_ORGANIZATION_NAME => c.p124
827: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
828: ,P_EFFECTIVE_DATE => c.p1
829: ,P_LANGUAGE_CODE => c.p125);

Line 837: hr_pump_get.get_grade_id

833: c.p1 is null then
834: L_GRADE_ID:=nn;
835: else
836: L_GRADE_ID :=
837: hr_pump_get.get_grade_id
838: (P_GRADE_NAME => c.p126
839: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
840: ,P_EFFECTIVE_DATE => c.p1);
841: end if;

Line 848: hr_pump_get.get_position_id

844: c.p1 is null then
845: L_POSITION_ID:=nn;
846: else
847: L_POSITION_ID :=
848: hr_pump_get.get_position_id
849: (P_POSITION_NAME => c.p127
850: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
851: ,P_EFFECTIVE_DATE => c.p1);
852: end if;

Line 859: hr_pump_get.get_job_id

855: c.p1 is null then
856: L_JOB_ID:=nn;
857: else
858: L_JOB_ID :=
859: hr_pump_get.get_job_id
860: (P_JOB_NAME => c.p128
861: ,P_EFFECTIVE_DATE => c.p1
862: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
863: end if;

Line 870: hr_pump_get.get_assignment_status_type_id

866: c.p125 is null then
867: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
868: else
869: L_ASSIGNMENT_STATUS_TYPE_ID :=
870: hr_pump_get.get_assignment_status_type_id
871: (P_USER_STATUS => c.p129
872: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
873: ,P_LANGUAGE_CODE => c.p125);
874: end if;

Line 881: hr_pump_get.get_payroll_id

877: c.p1 is null then
878: L_PAYROLL_ID:=nn;
879: else
880: L_PAYROLL_ID :=
881: hr_pump_get.get_payroll_id
882: (P_PAYROLL_NAME => c.p130
883: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
884: ,P_EFFECTIVE_DATE => c.p1);
885: end if;

Line 892: hr_pump_get.get_location_id

888: c.p125 is null then
889: L_LOCATION_ID:=nn;
890: else
891: L_LOCATION_ID :=
892: hr_pump_get.get_location_id
893: (P_LOCATION_CODE => c.p131
894: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
895: ,P_LANGUAGE_CODE => c.p125);
896: end if;

Line 902: hr_pump_get.get_supervisor_id

898: if c.p132 is null then
899: L_SUPERVISOR_ID:=nn;
900: else
901: L_SUPERVISOR_ID :=
902: hr_pump_get.get_supervisor_id
903: (P_SUPERVISOR_USER_KEY => c.p132);
904: end if;
905: --
906: if c.p133 is null then

Line 910: hr_pump_get.get_special_ceiling_step_id

906: if c.p133 is null then
907: L_SPECIAL_CEILING_STEP_ID:=nn;
908: else
909: L_SPECIAL_CEILING_STEP_ID :=
910: hr_pump_get.get_special_ceiling_step_id
911: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p133);
912: end if;
913: --
914: if c.p134 is null then

Line 918: hr_pump_get.get_pay_basis_id

914: if c.p134 is null then
915: L_PAY_BASIS_ID:=nn;
916: else
917: L_PAY_BASIS_ID :=
918: hr_pump_get.get_pay_basis_id
919: (P_PAY_BASIS_NAME => c.p134
920: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
921: end if;
922: --

Line 927: hr_pump_get.get_default_code_comb_id

923: if c.p135 is null then
924: L_DEFAULT_CODE_COMB_ID:=nn;
925: else
926: L_DEFAULT_CODE_COMB_ID :=
927: hr_pump_get.get_default_code_comb_id
928: (P_DEFAULT_CODE_COMB_USER_KEY => c.p135);
929: end if;
930: --
931: if c.p136 is null then

Line 935: hr_pump_get.get_set_of_books_id

931: if c.p136 is null then
932: L_SET_OF_BOOKS_ID:=nn;
933: else
934: L_SET_OF_BOOKS_ID :=
935: hr_pump_get.get_set_of_books_id
936: (P_SET_OF_BOOKS_NAME => c.p136);
937: end if;
938: --
939: if c.p137 is null then

Line 952: hr_pump_get.get_contract_id

948: if c.p138 is null then
949: L_CONTRACT_ID:=nn;
950: else
951: L_CONTRACT_ID :=
952: hr_pump_get.get_contract_id
953: (P_CONTRACT_USER_KEY => c.p138);
954: end if;
955: --
956: if c.p139 is null or

Line 961: hr_pump_get.get_establishment_id

957: c.p140 is null then
958: L_ESTABLISHMENT_ID:=nn;
959: else
960: L_ESTABLISHMENT_ID :=
961: hr_pump_get.get_establishment_id
962: (P_ESTABLISHMENT_NAME => c.p139
963: ,P_LOCATION => c.p140);
964: end if;
965: --

Line 971: hr_pump_get.get_collective_agreement_id

967: c.p1 is null then
968: L_COLLECTIVE_AGREEMENT_ID:=nn;
969: else
970: L_COLLECTIVE_AGREEMENT_ID :=
971: hr_pump_get.get_collective_agreement_id
972: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
973: ,P_CAGR_NAME => c.p141
974: ,P_EFFECTIVE_DATE => c.p1);
975: end if;