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

Line 414: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval097)) p4,

410: decode(l.pval002,cn,vn,l.pval002) p2,
411: decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
412: l.pval003 d3,
413: decode(l.pval004,cn,vn,vn,vh,
414: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval097)) p4,
415: l.pval004 d4,
416: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
417: l.pval005 d5,
418: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,

Line 421: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval097)) p7,

417: l.pval005 d5,
418: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
419: l.pval006 d6,
420: decode(l.pval007,cn,vn,vn,vh,
421: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval097)) p7,
422: l.pval007 d7,
423: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
424: l.pval008 d8,
425: decode(l.pval009,cn,vn,vn,vh,

Line 426: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval097)) p9,

422: l.pval007 d7,
423: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
424: l.pval008 d8,
425: decode(l.pval009,cn,vn,vn,vh,
426: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval097)) p9,
427: l.pval009 d9,
428: decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
429: l.pval010 d10,
430: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,

Line 433: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval097)) p12,

429: l.pval010 d10,
430: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
431: l.pval011 d11,
432: decode(l.pval012,cn,vn,vn,vh,
433: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval097)) p12,
434: l.pval012 d12,
435: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
436: l.pval013 d13,
437: decode(l.pval014,cn,vn,vn,vh,

Line 438: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval097)) p14,

434: l.pval012 d12,
435: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
436: l.pval013 d13,
437: decode(l.pval014,cn,vn,vn,vh,
438: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval097)) p14,
439: l.pval014 d14,
440: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
441: l.pval015 d15,
442: decode(l.pval016,cn,vn,vn,vh,

Line 443: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval097)) p16,

439: l.pval014 d14,
440: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
441: l.pval015 d15,
442: decode(l.pval016,cn,vn,vn,vh,
443: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval097)) p16,
444: l.pval016 d16,
445: decode(l.pval017,cn,vn,vn,vh,
446: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval097)) p17,
447: l.pval017 d17,

Line 446: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval097)) p17,

442: decode(l.pval016,cn,vn,vn,vh,
443: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval097)) p16,
444: l.pval016 d16,
445: decode(l.pval017,cn,vn,vn,vh,
446: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval097)) p17,
447: l.pval017 d17,
448: decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
449: l.pval018 d18,
450: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,

Line 453: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval097)) p20,

449: l.pval018 d18,
450: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
451: l.pval019 d19,
452: decode(l.pval020,cn,vn,vn,vh,
453: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval097)) p20,
454: l.pval020 d20,
455: decode(l.pval021,cn,vn,vn,vh,
456: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval097)) p21,
457: l.pval021 d21,

Line 456: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval097)) p21,

452: decode(l.pval020,cn,vn,vn,vh,
453: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval097)) p20,
454: l.pval020 d20,
455: decode(l.pval021,cn,vn,vn,vh,
456: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval097)) p21,
457: l.pval021 d21,
458: decode(l.pval022,cn,vn,vn,vh,
459: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval097)) p22,
460: l.pval022 d22,

Line 459: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval097)) p22,

455: decode(l.pval021,cn,vn,vn,vh,
456: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval097)) p21,
457: l.pval021 d21,
458: decode(l.pval022,cn,vn,vn,vh,
459: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval097)) p22,
460: l.pval022 d22,
461: decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
462: l.pval023 d23,
463: decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,

Line 526: hr_pump_get.gl(l.pval055,'CN_TAX_AREA',d(l.pval001),l.pval097)) p55,

522: l.pval053 d53,
523: decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
524: l.pval054 d54,
525: decode(l.pval055,cn,vn,vn,vh,
526: hr_pump_get.gl(l.pval055,'CN_TAX_AREA',d(l.pval001),l.pval097)) p55,
527: l.pval055 d55,
528: decode(l.pval056,cn,vn,vn,vh,
529: hr_pump_get.gl(l.pval056,'CN_SIC_AREA',d(l.pval001),l.pval097)) p56,
530: l.pval056 d56,

Line 529: hr_pump_get.gl(l.pval056,'CN_SIC_AREA',d(l.pval001),l.pval097)) p56,

525: decode(l.pval055,cn,vn,vn,vh,
526: hr_pump_get.gl(l.pval055,'CN_TAX_AREA',d(l.pval001),l.pval097)) p55,
527: l.pval055 d55,
528: decode(l.pval056,cn,vn,vn,vh,
529: hr_pump_get.gl(l.pval056,'CN_SIC_AREA',d(l.pval001),l.pval097)) p56,
530: l.pval056 d56,
531: decode(l.pval057,cn,vn,vn,vh,
532: hr_pump_get.gl(l.pval057,'CN_PAYOUT_LOCATION',d(l.pval001),l.pval097)) p57,
533: l.pval057 d57,

Line 532: hr_pump_get.gl(l.pval057,'CN_PAYOUT_LOCATION',d(l.pval001),l.pval097)) p57,

528: decode(l.pval056,cn,vn,vn,vh,
529: hr_pump_get.gl(l.pval056,'CN_SIC_AREA',d(l.pval001),l.pval097)) p56,
530: l.pval056 d56,
531: decode(l.pval057,cn,vn,vn,vh,
532: hr_pump_get.gl(l.pval057,'CN_PAYOUT_LOCATION',d(l.pval001),l.pval097)) p57,
533: l.pval057 d57,
534: decode(l.pval058,cn,vn,vn,vh,
535: hr_pump_get.gl(l.pval058,'CN_SPL_TAX_EXMP_CATEGORY',d(l.pval001),l.pval097)) p58,
536: l.pval058 d58,

Line 535: hr_pump_get.gl(l.pval058,'CN_SPL_TAX_EXMP_CATEGORY',d(l.pval001),l.pval097)) p58,

531: decode(l.pval057,cn,vn,vn,vh,
532: hr_pump_get.gl(l.pval057,'CN_PAYOUT_LOCATION',d(l.pval001),l.pval097)) p57,
533: l.pval057 d57,
534: decode(l.pval058,cn,vn,vn,vh,
535: hr_pump_get.gl(l.pval058,'CN_SPL_TAX_EXMP_CATEGORY',d(l.pval001),l.pval097)) p58,
536: l.pval058 d58,
537: decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
538: l.pval059 d59,
539: decode(l.pval060,cn,vn,vn,vh,l.pval060) p60,

Line 657: hr_pump_get.get_assignment_id

653: if c.p94 is null then
654: L_ASSIGNMENT_ID:=nn;
655: else
656: L_ASSIGNMENT_ID :=
657: hr_pump_get.get_assignment_id
658: (P_ASSIGNMENT_USER_KEY => c.p94);
659: end if;
660: --
661: if c.p94 is null or

Line 666: hr_pump_get.GET_ASG_OVN

662: c.p1 is null then
663: L_OBJECT_VERSION_NUMBER:=nn;
664: else
665: L_OBJECT_VERSION_NUMBER :=
666: hr_pump_get.GET_ASG_OVN
667: (P_ASSIGNMENT_USER_KEY => c.p94
668: ,P_EFFECTIVE_DATE => c.p1);
669: end if;
670: --

Line 677: hr_pump_get.get_supervisor_id

673: elsif c.d95 is null then
674: L_SUPERVISOR_ID:=nh;
675: else
676: L_SUPERVISOR_ID :=
677: hr_pump_get.get_supervisor_id
678: (P_SUPERVISOR_USER_KEY => c.p95);
679: end if;
680: --
681: if c.d96=cn or

Line 689: hr_pump_get.get_assignment_status_type_id

685: c.d97 is null then
686: L_ASSIGNMENT_STATUS_TYPE_ID:=nh;
687: else
688: L_ASSIGNMENT_STATUS_TYPE_ID :=
689: hr_pump_get.get_assignment_status_type_id
690: (P_USER_STATUS => c.p96
691: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
692: ,P_LANGUAGE_CODE => c.p97);
693: end if;

Line 701: hr_pump_get.get_default_code_comb_id

697: elsif c.d98 is null then
698: L_DEFAULT_CODE_COMB_ID:=nh;
699: else
700: L_DEFAULT_CODE_COMB_ID :=
701: hr_pump_get.get_default_code_comb_id
702: (P_DEFAULT_CODE_COMB_USER_KEY => c.p98);
703: end if;
704: --
705: if c.d99=cn then

Line 711: hr_pump_get.get_set_of_books_id

707: elsif c.d99 is null then
708: L_SET_OF_BOOKS_ID:=nh;
709: else
710: L_SET_OF_BOOKS_ID :=
711: hr_pump_get.get_set_of_books_id
712: (P_SET_OF_BOOKS_NAME => c.p99);
713: end if;
714: --
715: if c.d100=cn then

Line 732: hr_pump_get.get_contract_id

728: elsif c.d101 is null then
729: L_CONTRACT_ID:=nh;
730: else
731: L_CONTRACT_ID :=
732: hr_pump_get.get_contract_id
733: (P_CONTRACT_USER_KEY => c.p101);
734: end if;
735: --
736: if c.d102=cn or

Line 745: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

741: c.d97 is null then
742: L_ESTABLISHMENT_ID:=nh;
743: else
744: L_ESTABLISHMENT_ID :=
745: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
746: (P_ESTABLISHMENT_ORG_NAME => c.p102
747: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
748: ,P_EFFECTIVE_DATE => c.p1
749: ,P_LANGUAGE_CODE => c.p97);

Line 759: hr_pump_get.get_collective_agreement_id

755: elsif c.d103 is null then
756: L_COLLECTIVE_AGREEMENT_ID:=nh;
757: else
758: L_COLLECTIVE_AGREEMENT_ID :=
759: hr_pump_get.get_collective_agreement_id
760: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
761: ,P_CAGR_NAME => c.p103
762: ,P_EFFECTIVE_DATE => c.p1);
763: end if;

Line 771: hr_pump_get.GET_CAGR_ID_FLEX_NUM

767: elsif c.d104 is null then
768: L_CAGR_ID_FLEX_NUM:=nh;
769: else
770: L_CAGR_ID_FLEX_NUM :=
771: hr_pump_get.GET_CAGR_ID_FLEX_NUM
772: (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p104);
773: end if;
774: --
775: if c.p105 is null or

Line 780: hr_pump_get.get_soft_coding_keyflex_id

776: c.p1 is null then
777: L_SOFT_CODING_KEYFLEX_ID:=nn;
778: else
779: L_SOFT_CODING_KEYFLEX_ID :=
780: hr_pump_get.get_soft_coding_keyflex_id
781: (P_CON_SEG_USER_NAME => c.p105
782: ,P_EFFECTIVE_DATE => c.p1);
783: end if;
784: --