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

Line 432: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval098)) p4,

428: decode(l.pval002,cn,vn,l.pval002) p2,
429: decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
430: l.pval003 d3,
431: decode(l.pval004,cn,vn,vn,vh,
432: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval098)) p4,
433: l.pval004 d4,
434: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
435: l.pval005 d5,
436: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,

Line 439: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval098)) p7,

435: l.pval005 d5,
436: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
437: l.pval006 d6,
438: decode(l.pval007,cn,vn,vn,vh,
439: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval098)) p7,
440: l.pval007 d7,
441: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
442: l.pval008 d8,
443: decode(l.pval009,cn,vn,vn,vh,

Line 444: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval098)) p9,

440: l.pval007 d7,
441: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
442: l.pval008 d8,
443: decode(l.pval009,cn,vn,vn,vh,
444: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval098)) p9,
445: l.pval009 d9,
446: decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
447: l.pval010 d10,
448: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,

Line 451: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval098)) p12,

447: l.pval010 d10,
448: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
449: l.pval011 d11,
450: decode(l.pval012,cn,vn,vn,vh,
451: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval098)) p12,
452: l.pval012 d12,
453: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
454: l.pval013 d13,
455: decode(l.pval014,cn,vn,vn,vh,

Line 456: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval098)) p14,

452: l.pval012 d12,
453: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
454: l.pval013 d13,
455: decode(l.pval014,cn,vn,vn,vh,
456: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval098)) p14,
457: l.pval014 d14,
458: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
459: l.pval015 d15,
460: decode(l.pval016,cn,vn,vn,vh,

Line 461: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval098)) p16,

457: l.pval014 d14,
458: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
459: l.pval015 d15,
460: decode(l.pval016,cn,vn,vn,vh,
461: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval098)) p16,
462: l.pval016 d16,
463: decode(l.pval017,cn,vn,vn,vh,
464: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval098)) p17,
465: l.pval017 d17,

Line 464: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval098)) p17,

460: decode(l.pval016,cn,vn,vn,vh,
461: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval098)) p16,
462: l.pval016 d16,
463: decode(l.pval017,cn,vn,vn,vh,
464: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval098)) p17,
465: l.pval017 d17,
466: decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
467: l.pval018 d18,
468: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,

Line 471: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval098)) p20,

467: l.pval018 d18,
468: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
469: l.pval019 d19,
470: decode(l.pval020,cn,vn,vn,vh,
471: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval098)) p20,
472: l.pval020 d20,
473: decode(l.pval021,cn,vn,vn,vh,
474: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval098)) p21,
475: l.pval021 d21,

Line 474: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval098)) p21,

470: decode(l.pval020,cn,vn,vn,vh,
471: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval098)) p20,
472: l.pval020 d20,
473: decode(l.pval021,cn,vn,vn,vh,
474: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval098)) p21,
475: l.pval021 d21,
476: decode(l.pval022,cn,vn,vn,vh,
477: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval098)) p22,
478: l.pval022 d22,

Line 477: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval098)) p22,

473: decode(l.pval021,cn,vn,vn,vh,
474: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval098)) p21,
475: l.pval021 d21,
476: decode(l.pval022,cn,vn,vn,vh,
477: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval098)) p22,
478: l.pval022 d22,
479: decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
480: l.pval023 d23,
481: decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,

Line 544: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval098)) p55,

540: l.pval053 d53,
541: decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
542: l.pval054 d54,
543: decode(l.pval055,cn,vn,vn,'N',
544: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval098)) p55,
545: l.pval055 d55,
546: decode(l.pval056,cn,vn,vn,'N',
547: hr_pump_get.gl(l.pval056,'YES_NO',d(l.pval001),l.pval098)) p56,
548: l.pval056 d56,

Line 547: hr_pump_get.gl(l.pval056,'YES_NO',d(l.pval001),l.pval098)) p56,

543: decode(l.pval055,cn,vn,vn,'N',
544: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval098)) p55,
545: l.pval055 d55,
546: decode(l.pval056,cn,vn,vn,'N',
547: hr_pump_get.gl(l.pval056,'YES_NO',d(l.pval001),l.pval098)) p56,
548: l.pval056 d56,
549: decode(l.pval057,cn,vn,vn,'N',
550: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval098)) p57,
551: l.pval057 d57,

Line 550: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval098)) p57,

546: decode(l.pval056,cn,vn,vn,'N',
547: hr_pump_get.gl(l.pval056,'YES_NO',d(l.pval001),l.pval098)) p56,
548: l.pval056 d56,
549: decode(l.pval057,cn,vn,vn,'N',
550: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval098)) p57,
551: l.pval057 d57,
552: decode(l.pval058,cn,vn,vn,vh,l.pval058) p58,
553: l.pval058 d58,
554: decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,

Line 601: hr_pump_get.gl(l.pval082,'EMPLOYEE_CATG',d(l.pval001),l.pval098)) p82,

597: l.pval080 d80,
598: decode(l.pval081,cn,vn,vn,vh,l.pval081) p81,
599: l.pval081 d81,
600: decode(l.pval082,cn,vn,vn,vh,
601: hr_pump_get.gl(l.pval082,'EMPLOYEE_CATG',d(l.pval001),l.pval098)) p82,
602: l.pval082 d82,
603: decode(l.pval083,cn,vn,vn,vh,l.pval083) p83,
604: l.pval083 d83,
605: decode(l.pval084,cn,vn,vn,vh,l.pval084) p84,

Line 694: hr_pump_get.get_assignment_id

690: if c.p95 is null then
691: L_ASSIGNMENT_ID:=nn;
692: else
693: L_ASSIGNMENT_ID :=
694: hr_pump_get.get_assignment_id
695: (P_ASSIGNMENT_USER_KEY => c.p95);
696: end if;
697: --
698: if c.p95 is null or

Line 703: hr_pump_get.GET_ASG_OVN

699: c.p1 is null then
700: L_OBJECT_VERSION_NUMBER:=nn;
701: else
702: L_OBJECT_VERSION_NUMBER :=
703: hr_pump_get.GET_ASG_OVN
704: (P_ASSIGNMENT_USER_KEY => c.p95
705: ,P_EFFECTIVE_DATE => c.p1);
706: end if;
707: --

Line 714: hr_pump_get.get_supervisor_id

710: elsif c.d96 is null then
711: L_SUPERVISOR_ID:=nh;
712: else
713: L_SUPERVISOR_ID :=
714: hr_pump_get.get_supervisor_id
715: (P_SUPERVISOR_USER_KEY => c.p96);
716: end if;
717: --
718: if c.d97=cn or

Line 726: hr_pump_get.get_assignment_status_type_id

722: c.d98 is null then
723: L_ASSIGNMENT_STATUS_TYPE_ID:=nh;
724: else
725: L_ASSIGNMENT_STATUS_TYPE_ID :=
726: hr_pump_get.get_assignment_status_type_id
727: (P_USER_STATUS => c.p97
728: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
729: ,P_LANGUAGE_CODE => c.p98);
730: end if;

Line 738: hr_pump_get.get_default_code_comb_id

734: elsif c.d99 is null then
735: L_DEFAULT_CODE_COMB_ID:=nh;
736: else
737: L_DEFAULT_CODE_COMB_ID :=
738: hr_pump_get.get_default_code_comb_id
739: (P_DEFAULT_CODE_COMB_USER_KEY => c.p99);
740: end if;
741: --
742: if c.d100=cn then

Line 748: hr_pump_get.get_set_of_books_id

744: elsif c.d100 is null then
745: L_SET_OF_BOOKS_ID:=nh;
746: else
747: L_SET_OF_BOOKS_ID :=
748: hr_pump_get.get_set_of_books_id
749: (P_SET_OF_BOOKS_NAME => c.p100);
750: end if;
751: --
752: if c.d101=cn then

Line 818: hr_pump_get.get_contract_id

814: elsif c.d107 is null then
815: L_CONTRACT_ID:=nh;
816: else
817: L_CONTRACT_ID :=
818: hr_pump_get.get_contract_id
819: (P_CONTRACT_USER_KEY => c.p107);
820: end if;
821: --
822: if c.d108=cn or

Line 831: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

827: c.d98 is null then
828: L_ESTABLISHMENT_ID:=nh;
829: else
830: L_ESTABLISHMENT_ID :=
831: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
832: (P_ESTABLISHMENT_ORG_NAME => c.p108
833: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
834: ,P_EFFECTIVE_DATE => c.p1
835: ,P_LANGUAGE_CODE => c.p98);

Line 845: hr_pump_get.get_collective_agreement_id

841: elsif c.d109 is null then
842: L_COLLECTIVE_AGREEMENT_ID:=nh;
843: else
844: L_COLLECTIVE_AGREEMENT_ID :=
845: hr_pump_get.get_collective_agreement_id
846: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
847: ,P_CAGR_NAME => c.p109
848: ,P_EFFECTIVE_DATE => c.p1);
849: end if;

Line 857: hr_pump_get.GET_CAGR_ID_FLEX_NUM

853: elsif c.d110 is null then
854: L_CAGR_ID_FLEX_NUM:=nh;
855: else
856: L_CAGR_ID_FLEX_NUM :=
857: hr_pump_get.GET_CAGR_ID_FLEX_NUM
858: (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p110);
859: end if;
860: --
861: if c.d111=cn then

Line 867: hr_pump_get.get_supervisor_assignment_id

863: elsif c.d111 is null then
864: L_SUPERVISOR_ASSIGNMENT_ID:=nh;
865: else
866: L_SUPERVISOR_ASSIGNMENT_ID :=
867: hr_pump_get.get_supervisor_assignment_id
868: (P_SVR_ASSIGNMENT_USER_KEY => c.p111);
869: end if;
870: --
871: if c.p112 is null or

Line 876: hr_pump_get.get_soft_coding_keyflex_id

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