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

Line 339: hr_pump_get.gl(l.pval003,'YES_NO',d(l.pval056),vn)) p3,

335: select l.rowid myrowid,
336: decode(l.pval001,cn,dn,d(l.pval001)) p1,
337: decode(l.pval002,cn,dn,d(l.pval002)) p2,
338: decode(l.pval003,cn,vn,vn,vh,
339: hr_pump_get.gl(l.pval003,'YES_NO',d(l.pval056),vn)) p3,
340: l.pval003 d3,
341: decode(l.pval004,cn,vn,vn,vh,
342: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval056),vn)) p4,
343: l.pval004 d4,

Line 342: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval056),vn)) p4,

338: decode(l.pval003,cn,vn,vn,vh,
339: hr_pump_get.gl(l.pval003,'YES_NO',d(l.pval056),vn)) p3,
340: l.pval003 d3,
341: decode(l.pval004,cn,vn,vn,vh,
342: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval056),vn)) p4,
343: l.pval004 d4,
344: decode(l.pval005,cn,nn,vn,nh,n(l.pval005)) p5,
345: l.pval005 d5,
346: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,

Line 349: hr_pump_get.gl(l.pval007,'BEN_ENRT_RSLT_MTHD',d(l.pval056),vn)) p7,

345: l.pval005 d5,
346: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
347: l.pval006 d6,
348: decode(l.pval007,cn,vn,vn,vh,
349: hr_pump_get.gl(l.pval007,'BEN_ENRT_RSLT_MTHD',d(l.pval056),vn)) p7,
350: l.pval007 d7,
351: decode(l.pval008,cn,vn,vn,vh,
352: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval056),vn)) p8,
353: l.pval008 d8,

Line 352: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval056),vn)) p8,

348: decode(l.pval007,cn,vn,vn,vh,
349: hr_pump_get.gl(l.pval007,'BEN_ENRT_RSLT_MTHD',d(l.pval056),vn)) p7,
350: l.pval007 d7,
351: decode(l.pval008,cn,vn,vn,vh,
352: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval056),vn)) p8,
353: l.pval008 d8,
354: decode(l.pval009,cn,vn,vn,vh,
355: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval056),vn)) p9,
356: l.pval009 d9,

Line 355: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval056),vn)) p9,

351: decode(l.pval008,cn,vn,vn,vh,
352: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval056),vn)) p8,
353: l.pval008 d8,
354: decode(l.pval009,cn,vn,vn,vh,
355: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval056),vn)) p9,
356: l.pval009 d9,
357: decode(l.pval010,cn,vn,vn,vh,
358: hr_pump_get.gl(l.pval010,'BEN_OVRID_RSN',d(l.pval056),vn)) p10,
359: l.pval010 d10,

Line 358: hr_pump_get.gl(l.pval010,'BEN_OVRID_RSN',d(l.pval056),vn)) p10,

354: decode(l.pval009,cn,vn,vn,vh,
355: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval056),vn)) p9,
356: l.pval009 d9,
357: decode(l.pval010,cn,vn,vn,vh,
358: hr_pump_get.gl(l.pval010,'BEN_OVRID_RSN',d(l.pval056),vn)) p10,
359: l.pval010 d10,
360: decode(l.pval011,cn,dn,vn,dh,d(l.pval011)) p11,
361: l.pval011 d11,
362: decode(l.pval012,cn,dn,vn,dh,d(l.pval012)) p12,

Line 441: hr_pump_get.gl(l.pval051,'BEN_BNFT_TYP',d(l.pval056),vn)) p51,

437: l.pval049 d49,
438: decode(l.pval050,cn,dn,vn,dh,d(l.pval050)) p50,
439: l.pval050 d50,
440: decode(l.pval051,cn,vn,vn,vh,
441: hr_pump_get.gl(l.pval051,'BEN_BNFT_TYP',d(l.pval056),vn)) p51,
442: l.pval051 d51,
443: decode(l.pval052,cn,nn,vn,nh,n(l.pval052)) p52,
444: l.pval052 d52,
445: decode(l.pval053,cn,vn,vn,vh,

Line 446: hr_pump_get.gl(l.pval053,'BEN_PRTT_ENRT_RSLT_STAT',d(l.pval056),vn)) p53,

442: l.pval051 d51,
443: decode(l.pval052,cn,nn,vn,nh,n(l.pval052)) p52,
444: l.pval052 d52,
445: decode(l.pval053,cn,vn,vn,vh,
446: hr_pump_get.gl(l.pval053,'BEN_PRTT_ENRT_RSLT_STAT',d(l.pval056),vn)) p53,
447: l.pval053 d53,
448: decode(l.pval054,cn,vn,vn,vh,
449: hr_pump_get.gl(l.pval054,'BEN_NNMNTRY_UOM',d(l.pval056),vn)) p54,
450: l.pval054 d54,

Line 449: hr_pump_get.gl(l.pval054,'BEN_NNMNTRY_UOM',d(l.pval056),vn)) p54,

445: decode(l.pval053,cn,vn,vn,vh,
446: hr_pump_get.gl(l.pval053,'BEN_PRTT_ENRT_RSLT_STAT',d(l.pval056),vn)) p53,
447: l.pval053 d53,
448: decode(l.pval054,cn,vn,vn,vh,
449: hr_pump_get.gl(l.pval054,'BEN_NNMNTRY_UOM',d(l.pval056),vn)) p54,
450: l.pval054 d54,
451: decode(l.pval055,cn,vn,vn,vh,
452: hr_pump_get.gl(l.pval055,'BEN_COMP_LVL',d(l.pval056),vn)) p55,
453: l.pval055 d55,

Line 452: hr_pump_get.gl(l.pval055,'BEN_COMP_LVL',d(l.pval056),vn)) p55,

448: decode(l.pval054,cn,vn,vn,vh,
449: hr_pump_get.gl(l.pval054,'BEN_NNMNTRY_UOM',d(l.pval056),vn)) p54,
450: l.pval054 d54,
451: decode(l.pval055,cn,vn,vn,vh,
452: hr_pump_get.gl(l.pval055,'BEN_COMP_LVL',d(l.pval056),vn)) p55,
453: l.pval055 d55,
454: decode(l.pval056,cn,dn,d(l.pval056)) p56,
455: decode(l.pval057,cn,vn,l.pval057) p57,
456: decode(l.pval058,cn,vn,vn,null,l.pval058) p58,

Line 533: hr_pump_get.get_prtt_enrt_rslt_id

529: if c.p59 is null then
530: L_PRTT_ENRT_RSLT_ID:=nn;
531: else
532: L_PRTT_ENRT_RSLT_ID :=
533: hr_pump_get.get_prtt_enrt_rslt_id
534: (P_PRTT_ENRT_RSLT_USER_KEY => c.p59);
535: end if;
536: --
537: if c.d60=cn then

Line 543: hr_pump_get.get_oipl_id

539: elsif c.d60 is null then
540: L_OIPL_ID:=nh;
541: else
542: L_OIPL_ID :=
543: hr_pump_get.get_oipl_id
544: (P_OIPL_USER_KEY => c.p60);
545: end if;
546: --
547: if c.d61=cn then

Line 553: hr_pump_get.get_person_id

549: elsif c.d61 is null then
550: L_PERSON_ID:=nh;
551: else
552: L_PERSON_ID :=
553: hr_pump_get.get_person_id
554: (P_PERSON_USER_KEY => c.p61);
555: end if;
556: --
557: if c.d62=cn then

Line 563: hr_pump_get.get_assignment_id

559: elsif c.d62 is null then
560: L_ASSIGNMENT_ID:=nh;
561: else
562: L_ASSIGNMENT_ID :=
563: hr_pump_get.get_assignment_id
564: (P_ASSIGNMENT_USER_KEY => c.p62);
565: end if;
566: --
567: if c.d63=cn or

Line 574: hr_pump_get.get_pgm_id

570: elsif c.d63 is null then
571: L_PGM_ID:=nh;
572: else
573: L_PGM_ID :=
574: hr_pump_get.get_pgm_id
575: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
576: ,P_PROGRAM => c.p63
577: ,P_EFFECTIVE_DATE => c.p56);
578: end if;

Line 587: hr_pump_get.get_pl_id

583: elsif c.d64 is null then
584: L_PL_ID:=nh;
585: else
586: L_PL_ID :=
587: hr_pump_get.get_pl_id
588: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
589: ,P_PLAN => c.p64
590: ,P_EFFECTIVE_DATE => c.p56);
591: end if;

Line 599: hr_pump_get.get_rplcs_sspndd_rslt_id

595: elsif c.d65 is null then
596: L_RPLCS_SSPNDD_RSLT_ID:=nh;
597: else
598: L_RPLCS_SSPNDD_RSLT_ID :=
599: hr_pump_get.get_rplcs_sspndd_rslt_id
600: (P_RPLCS_SSPNDD_RSLT_USER_KEY => c.p65);
601: end if;
602: --
603: if c.d66=cn then

Line 609: hr_pump_get.get_ptip_id

605: elsif c.d66 is null then
606: L_PTIP_ID:=nh;
607: else
608: L_PTIP_ID :=
609: hr_pump_get.get_ptip_id
610: (P_PTIP_USER_KEY => c.p66);
611: end if;
612: --
613: if c.d67=cn or

Line 620: hr_pump_get.get_pl_typ_id

616: elsif c.d67 is null then
617: L_PL_TYP_ID:=nh;
618: else
619: L_PL_TYP_ID :=
620: hr_pump_get.get_pl_typ_id
621: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
622: ,P_PLAN_TYPE => c.p67
623: ,P_EFFECTIVE_DATE => c.p56);
624: end if;

Line 633: hr_pump_get.get_ler_id

629: elsif c.d68 is null then
630: L_LER_ID:=nh;
631: else
632: L_LER_ID :=
633: hr_pump_get.get_ler_id
634: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
635: ,P_LIFE_EVENT_REASON => c.p68
636: ,P_EFFECTIVE_DATE => c.p56);
637: end if;

Line 646: hr_pump_get.GET_UOM_CODE

642: elsif c.d69 is null then
643: L_UOM:=vh;
644: else
645: L_UOM :=
646: hr_pump_get.GET_UOM_CODE
647: (P_UOM => c.p69
648: ,P_EFFECTIVE_DATE => c.p56);
649: end if;
650: --

Line 652: hr_pump_get.get_request_id;

648: ,P_EFFECTIVE_DATE => c.p56);
649: end if;
650: --
651: L_REQUEST_ID :=
652: hr_pump_get.get_request_id;
653: --
654: L_PROGRAM_APPLICATION_ID :=
655: hr_pump_get.get_program_application_id;
656: --

Line 655: hr_pump_get.get_program_application_id;

651: L_REQUEST_ID :=
652: hr_pump_get.get_request_id;
653: --
654: L_PROGRAM_APPLICATION_ID :=
655: hr_pump_get.get_program_application_id;
656: --
657: L_PROGRAM_ID :=
658: hr_pump_get.get_program_id;
659: --

Line 658: hr_pump_get.get_program_id;

654: L_PROGRAM_APPLICATION_ID :=
655: hr_pump_get.get_program_application_id;
656: --
657: L_PROGRAM_ID :=
658: hr_pump_get.get_program_id;
659: --
660: if c.p59 is null or
661: c.p56 is null then
662: L_OBJECT_VERSION_NUMBER:=nn;

Line 665: hr_pump_get.GET_PRTT_ENRT_RSLT_OVN

661: c.p56 is null then
662: L_OBJECT_VERSION_NUMBER:=nn;
663: else
664: L_OBJECT_VERSION_NUMBER :=
665: hr_pump_get.GET_PRTT_ENRT_RSLT_OVN
666: (P_PRTT_ENRT_RSLT_USER_KEY => c.p59
667: ,P_EFFECTIVE_DATE => c.p56);
668: end if;
669: --

Line 676: hr_pump_get.get_per_in_ler_id

672: elsif c.d70 is null then
673: L_PER_IN_LER_ID:=nh;
674: else
675: L_PER_IN_LER_ID :=
676: hr_pump_get.get_per_in_ler_id
677: (P_PER_IN_LER_USER_KEY => c.p70);
678: end if;
679: --
680: hr_data_pump.api_trc_on;