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

Line 367: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval086)) p4,

363: decode(l.pval002,cn,vn,l.pval002) p2,
364: decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
365: l.pval003 d3,
366: decode(l.pval004,cn,vn,vn,vh,
367: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval086)) p4,
368: l.pval004 d4,
369: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
370: l.pval005 d5,
371: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,

Line 374: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval086)) p7,

370: l.pval005 d5,
371: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
372: l.pval006 d6,
373: decode(l.pval007,cn,vn,vn,vh,
374: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval086)) p7,
375: l.pval007 d7,
376: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
377: l.pval008 d8,
378: decode(l.pval009,cn,vn,vn,vh,

Line 379: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval086)) p9,

375: l.pval007 d7,
376: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
377: l.pval008 d8,
378: decode(l.pval009,cn,vn,vn,vh,
379: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval086)) p9,
380: l.pval009 d9,
381: decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
382: l.pval010 d10,
383: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,

Line 386: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval086)) p12,

382: l.pval010 d10,
383: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
384: l.pval011 d11,
385: decode(l.pval012,cn,vn,vn,vh,
386: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval086)) p12,
387: l.pval012 d12,
388: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
389: l.pval013 d13,
390: decode(l.pval014,cn,vn,vn,vh,

Line 391: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval086)) p14,

387: l.pval012 d12,
388: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
389: l.pval013 d13,
390: decode(l.pval014,cn,vn,vn,vh,
391: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval086)) p14,
392: l.pval014 d14,
393: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
394: l.pval015 d15,
395: decode(l.pval016,cn,vn,vn,vh,

Line 396: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval086)) p16,

392: l.pval014 d14,
393: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
394: l.pval015 d15,
395: decode(l.pval016,cn,vn,vn,vh,
396: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval086)) p16,
397: l.pval016 d16,
398: decode(l.pval017,cn,vn,vn,vh,
399: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval086)) p17,
400: l.pval017 d17,

Line 399: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval086)) p17,

395: decode(l.pval016,cn,vn,vn,vh,
396: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval086)) p16,
397: l.pval016 d16,
398: decode(l.pval017,cn,vn,vn,vh,
399: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval086)) p17,
400: l.pval017 d17,
401: decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
402: l.pval018 d18,
403: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,

Line 406: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval086)) p20,

402: l.pval018 d18,
403: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
404: l.pval019 d19,
405: decode(l.pval020,cn,vn,vn,vh,
406: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval086)) p20,
407: l.pval020 d20,
408: decode(l.pval021,cn,vn,vn,vh,
409: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval086)) p21,
410: l.pval021 d21,

Line 409: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval086)) p21,

405: decode(l.pval020,cn,vn,vn,vh,
406: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval086)) p20,
407: l.pval020 d20,
408: decode(l.pval021,cn,vn,vn,vh,
409: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval086)) p21,
410: l.pval021 d21,
411: decode(l.pval022,cn,vn,vn,vh,
412: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval086)) p22,
413: l.pval022 d22,

Line 412: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval086)) p22,

408: decode(l.pval021,cn,vn,vn,vh,
409: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval086)) p21,
410: l.pval021 d21,
411: decode(l.pval022,cn,vn,vn,vh,
412: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval086)) p22,
413: l.pval022 d22,
414: decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
415: l.pval023 d23,
416: decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,

Line 479: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval086)) p55,

475: l.pval053 d53,
476: decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
477: l.pval054 d54,
478: decode(l.pval055,cn,vn,vn,vh,
479: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval086)) p55,
480: l.pval055 d55,
481: decode(l.pval056,cn,vn,vn,vh,
482: hr_pump_get.gl(l.pval056,'US_SHIFTS',d(l.pval001),l.pval086)) p56,
483: l.pval056 d56,

Line 482: hr_pump_get.gl(l.pval056,'US_SHIFTS',d(l.pval001),l.pval086)) p56,

478: decode(l.pval055,cn,vn,vn,vh,
479: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval086)) p55,
480: l.pval055 d55,
481: decode(l.pval056,cn,vn,vn,vh,
482: hr_pump_get.gl(l.pval056,'US_SHIFTS',d(l.pval001),l.pval086)) p56,
483: l.pval056 d56,
484: decode(l.pval057,cn,vn,vn,vh,l.pval057) p57,
485: l.pval057 d57,
486: decode(l.pval058,cn,vn,vn,vh,

Line 487: hr_pump_get.gl(l.pval058,'YES_NO',d(l.pval001),l.pval086)) p58,

483: l.pval056 d56,
484: decode(l.pval057,cn,vn,vn,vh,l.pval057) p57,
485: l.pval057 d57,
486: decode(l.pval058,cn,vn,vn,vh,
487: hr_pump_get.gl(l.pval058,'YES_NO',d(l.pval001),l.pval086)) p58,
488: l.pval058 d58,
489: decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
490: l.pval059 d59,
491: decode(l.pval060,cn,nn,vn,nh,n(l.pval060)) p60,

Line 583: hr_pump_get.get_assignment_id

579: if c.p78 is null then
580: L_ASSIGNMENT_ID:=nn;
581: else
582: L_ASSIGNMENT_ID :=
583: hr_pump_get.get_assignment_id
584: (P_ASSIGNMENT_USER_KEY => c.p78);
585: end if;
586: --
587: if c.p78 is null or

Line 592: hr_pump_get.GET_ASG_OVN

588: c.p1 is null then
589: L_OBJECT_VERSION_NUMBER:=nn;
590: else
591: L_OBJECT_VERSION_NUMBER :=
592: hr_pump_get.GET_ASG_OVN
593: (P_ASSIGNMENT_USER_KEY => c.p78
594: ,P_EFFECTIVE_DATE => c.p1);
595: end if;
596: --

Line 603: hr_pump_get.get_supervisor_id

599: elsif c.d79 is null then
600: L_SUPERVISOR_ID:=nh;
601: else
602: L_SUPERVISOR_ID :=
603: hr_pump_get.get_supervisor_id
604: (P_SUPERVISOR_USER_KEY => c.p79);
605: end if;
606: --
607: if c.d80=cn then

Line 613: hr_pump_get.get_default_code_comb_id

609: elsif c.d80 is null then
610: L_DEFAULT_CODE_COMB_ID:=nh;
611: else
612: L_DEFAULT_CODE_COMB_ID :=
613: hr_pump_get.get_default_code_comb_id
614: (P_DEFAULT_CODE_COMB_USER_KEY => c.p80);
615: end if;
616: --
617: if c.d81=cn then

Line 623: hr_pump_get.get_set_of_books_id

619: elsif c.d81 is null then
620: L_SET_OF_BOOKS_ID:=nh;
621: else
622: L_SET_OF_BOOKS_ID :=
623: hr_pump_get.get_set_of_books_id
624: (P_SET_OF_BOOKS_NAME => c.p81);
625: end if;
626: --
627: if c.d82=cn or

Line 634: hr_pump_get.GET_TAX_UNIT_ID

630: elsif c.d82 is null then
631: L_TAX_UNIT:=vh;
632: else
633: L_TAX_UNIT :=
634: hr_pump_get.GET_TAX_UNIT_ID
635: (P_TAX_UNIT_NAME => c.p82
636: ,P_EFFECTIVE_DATE => c.p1);
637: end if;
638: --

Line 645: hr_pump_get.GET_TIMECARD_APPROVER_ID

641: elsif c.d83 is null then
642: L_TIMECARD_APPROVER:=vh;
643: else
644: L_TIMECARD_APPROVER :=
645: hr_pump_get.GET_TIMECARD_APPROVER_ID
646: (P_TIMECARD_APPROVER_USER_KEY => c.p83);
647: end if;
648: --
649: if c.d84=cn or

Line 660: hr_pump_get.GET_WORK_SCHEDULE

656: c.d86 is null then
657: L_WORK_SCHEDULE:=vh;
658: else
659: L_WORK_SCHEDULE :=
660: hr_pump_get.GET_WORK_SCHEDULE
661: (P_WORK_SCHEDULE => c.p84
662: ,P_ORGANIZATION_NAME => c.p85
663: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
664: ,P_EFFECTIVE_DATE => c.p1

Line 675: hr_pump_get.GET_EEO_1_ESTABLISHMENT_ID

671: elsif c.d87 is null then
672: L_EEO_1_ESTABLISHMENT:=vh;
673: else
674: L_EEO_1_ESTABLISHMENT :=
675: hr_pump_get.GET_EEO_1_ESTABLISHMENT_ID
676: (P_EEO_1_ESTABLISHMENT => c.p87
677: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
678: ,P_EFFECTIVE_DATE => c.p1);
679: end if;

Line 687: hr_pump_get.get_contract_id

683: elsif c.d88 is null then
684: L_CONTRACT_ID:=nh;
685: else
686: L_CONTRACT_ID :=
687: hr_pump_get.get_contract_id
688: (P_CONTRACT_USER_KEY => c.p88);
689: end if;
690: --
691: if c.d89=cn or

Line 699: hr_pump_get.get_establishment_id

695: c.d90 is null then
696: L_ESTABLISHMENT_ID:=nh;
697: else
698: L_ESTABLISHMENT_ID :=
699: hr_pump_get.get_establishment_id
700: (P_ESTABLISHMENT_NAME => c.p89
701: ,P_LOCATION => c.p90);
702: end if;
703: --

Line 711: hr_pump_get.get_collective_agreement_id

707: elsif c.d91 is null then
708: L_COLLECTIVE_AGREEMENT_ID:=nh;
709: else
710: L_COLLECTIVE_AGREEMENT_ID :=
711: hr_pump_get.get_collective_agreement_id
712: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
713: ,P_CAGR_NAME => c.p91
714: ,P_EFFECTIVE_DATE => c.p1);
715: end if;

Line 723: hr_pump_get.get_supervisor_assignment_id

719: elsif c.d92 is null then
720: L_SUPERVISOR_ASSIGNMENT_ID:=nh;
721: else
722: L_SUPERVISOR_ASSIGNMENT_ID :=
723: hr_pump_get.get_supervisor_assignment_id
724: (P_SVR_ASSIGNMENT_USER_KEY => c.p92);
725: end if;
726: --
727: hr_data_pump.api_trc_on;