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

Line 413: hr_pump_get.gl(l.pval004,'YES_NO',dn,l.pval106)) p4,

409: decode(l.pval001,cn,dn,d(l.pval001)) p1,
410: decode(l.pval002,cn,vn,l.pval002) p2,
411: decode(l.pval003,cn,vn,l.pval003) p3,
412: decode(l.pval004,cn,vn,vn,vn,
413: hr_pump_get.gl(l.pval004,'YES_NO',dn,l.pval106)) p4,
414: l.pval004 d4,
415: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
416: l.pval005 d5,
417: decode(l.pval006,cn,vn,vn,vn,

Line 418: hr_pump_get.gl(l.pval006,'BLOOD_TYPE',dn,l.pval106)) p6,

414: l.pval004 d4,
415: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
416: l.pval005 d5,
417: decode(l.pval006,cn,vn,vn,vn,
418: hr_pump_get.gl(l.pval006,'BLOOD_TYPE',dn,l.pval106)) p6,
419: l.pval006 d6,
420: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
421: l.pval007 d7,
422: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,

Line 431: hr_pump_get.gl(l.pval012,'YES_NO',dn,l.pval106)) p12,

427: l.pval010 d10,
428: decode(l.pval011,cn,dn,vn,dn,d(l.pval011)) p11,
429: l.pval011 d11,
430: decode(l.pval012,cn,vn,vn,'N',
431: hr_pump_get.gl(l.pval012,'YES_NO',dn,l.pval106)) p12,
432: l.pval012 d12,
433: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
434: l.pval013 d13,
435: decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,

Line 452: hr_pump_get.gl(l.pval022,'MAR_STATUS',dn,l.pval106)) p22,

448: l.pval020 d20,
449: decode(l.pval021,cn,vn,vn,vn,l.pval021) p21,
450: l.pval021 d21,
451: decode(l.pval022,cn,vn,vn,vn,
452: hr_pump_get.gl(l.pval022,'MAR_STATUS',dn,l.pval106)) p22,
453: l.pval022 d22,
454: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
455: l.pval023 d23,
456: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,

Line 459: hr_pump_get.gl(l.pval025,'NATIONALITY',dn,l.pval106)) p25,

455: l.pval023 d23,
456: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
457: l.pval024 d24,
458: decode(l.pval025,cn,vn,vn,vn,
459: hr_pump_get.gl(l.pval025,'NATIONALITY',dn,l.pval106)) p25,
460: l.pval025 d25,
461: decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
462: l.pval026 d26,
463: decode(l.pval027,cn,vn,vn,vn,

Line 464: hr_pump_get.gl(l.pval027,'YES_NO',dn,l.pval106)) p27,

460: l.pval025 d25,
461: decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
462: l.pval026 d26,
463: decode(l.pval027,cn,vn,vn,vn,
464: hr_pump_get.gl(l.pval027,'YES_NO',dn,l.pval106)) p27,
465: l.pval027 d27,
466: decode(l.pval028,cn,nn,vn,nn,n(l.pval028)) p28,
467: l.pval028 d28,
468: decode(l.pval029,cn,vn,vn,vn,l.pval029) p29,

Line 479: hr_pump_get.gl(l.pval034,'REGISTERED_DISABLED',dn,l.pval106)) p34,

475: l.pval032 d32,
476: decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
477: l.pval033 d33,
478: decode(l.pval034,cn,vn,vn,vn,
479: hr_pump_get.gl(l.pval034,'REGISTERED_DISABLED',dn,l.pval106)) p34,
480: l.pval034 d34,
481: decode(l.pval035,cn,vn,vn,vn,
482: hr_pump_get.gl(l.pval035,'YES_NO',dn,l.pval106)) p35,
483: l.pval035 d35,

Line 482: hr_pump_get.gl(l.pval035,'YES_NO',dn,l.pval106)) p35,

478: decode(l.pval034,cn,vn,vn,vn,
479: hr_pump_get.gl(l.pval034,'REGISTERED_DISABLED',dn,l.pval106)) p34,
480: l.pval034 d34,
481: decode(l.pval035,cn,vn,vn,vn,
482: hr_pump_get.gl(l.pval035,'YES_NO',dn,l.pval106)) p35,
483: l.pval035 d35,
484: decode(l.pval036,cn,dn,vn,dn,d(l.pval036)) p36,
485: l.pval036 d36,
486: decode(l.pval037,cn,vn,vn,vn,

Line 487: hr_pump_get.gl(l.pval037,'YES_NO',dn,l.pval106)) p37,

483: l.pval035 d35,
484: decode(l.pval036,cn,dn,vn,dn,d(l.pval036)) p36,
485: l.pval036 d36,
486: decode(l.pval037,cn,vn,vn,vn,
487: hr_pump_get.gl(l.pval037,'YES_NO',dn,l.pval106)) p37,
488: l.pval037 d37,
489: decode(l.pval038,cn,vn,vn,vn,
490: hr_pump_get.gl(l.pval038,'SEX',dn,l.pval106)) p38,
491: l.pval038 d38,

Line 490: hr_pump_get.gl(l.pval038,'SEX',dn,l.pval106)) p38,

486: decode(l.pval037,cn,vn,vn,vn,
487: hr_pump_get.gl(l.pval037,'YES_NO',dn,l.pval106)) p37,
488: l.pval037 d37,
489: decode(l.pval038,cn,vn,vn,vn,
490: hr_pump_get.gl(l.pval038,'SEX',dn,l.pval106)) p38,
491: l.pval038 d38,
492: decode(l.pval039,cn,vn,vn,vn,
493: hr_pump_get.gl(l.pval039,'STUDENT_STATUS',dn,l.pval106)) p39,
494: l.pval039 d39,

Line 493: hr_pump_get.gl(l.pval039,'STUDENT_STATUS',dn,l.pval106)) p39,

489: decode(l.pval038,cn,vn,vn,vn,
490: hr_pump_get.gl(l.pval038,'SEX',dn,l.pval106)) p38,
491: l.pval038 d38,
492: decode(l.pval039,cn,vn,vn,vn,
493: hr_pump_get.gl(l.pval039,'STUDENT_STATUS',dn,l.pval106)) p39,
494: l.pval039 d39,
495: decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
496: l.pval040 d40,
497: decode(l.pval041,cn,vn,vn,vn,

Line 498: hr_pump_get.gl(l.pval041,'TITLE',dn,l.pval106)) p41,

494: l.pval039 d39,
495: decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
496: l.pval040 d40,
497: decode(l.pval041,cn,vn,vn,vn,
498: hr_pump_get.gl(l.pval041,'TITLE',dn,l.pval106)) p41,
499: l.pval041 d41,
500: decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
501: l.pval042 d42,
502: decode(l.pval043,cn,vn,vn,vn,

Line 503: hr_pump_get.gl(l.pval043,'TOBACCO_USER',dn,l.pval106)) p43,

499: l.pval041 d41,
500: decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
501: l.pval042 d42,
502: decode(l.pval043,cn,vn,vn,vn,
503: hr_pump_get.gl(l.pval043,'TOBACCO_USER',dn,l.pval106)) p43,
504: l.pval043 d43,
505: decode(l.pval044,cn,vn,vn,vn,
506: hr_pump_get.gl(l.pval044,'WORK_SCHEDULE',dn,l.pval106)) p44,
507: l.pval044 d44,

Line 506: hr_pump_get.gl(l.pval044,'WORK_SCHEDULE',dn,l.pval106)) p44,

502: decode(l.pval043,cn,vn,vn,vn,
503: hr_pump_get.gl(l.pval043,'TOBACCO_USER',dn,l.pval106)) p43,
504: l.pval043 d43,
505: decode(l.pval044,cn,vn,vn,vn,
506: hr_pump_get.gl(l.pval044,'WORK_SCHEDULE',dn,l.pval106)) p44,
507: l.pval044 d44,
508: decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
509: l.pval045 d45,
510: decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,

Line 519: hr_pump_get.gl(l.pval050,'YES_NO',dn,l.pval106)) p50,

515: l.pval048 d48,
516: decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
517: l.pval049 d49,
518: decode(l.pval050,cn,vn,vn,'N',
519: hr_pump_get.gl(l.pval050,'YES_NO',dn,l.pval106)) p50,
520: l.pval050 d50,
521: decode(l.pval051,cn,dn,vn,dn,d(l.pval051)) p51,
522: l.pval051 d51,
523: decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,

Line 588: hr_pump_get.gl(l.pval084,'YES_NO',dn,l.pval106)) p84,

584: l.pval082 d82,
585: decode(l.pval083,cn,vn,vn,vn,l.pval083) p83,
586: l.pval083 d83,
587: decode(l.pval084,cn,vn,vn,vn,
588: hr_pump_get.gl(l.pval084,'YES_NO',dn,l.pval106)) p84,
589: l.pval084 d84,
590: decode(l.pval085,cn,vn,vn,'N',
591: hr_pump_get.gl(l.pval085,'YES_NO',dn,l.pval106)) p85,
592: l.pval085 d85,

Line 591: hr_pump_get.gl(l.pval085,'YES_NO',dn,l.pval106)) p85,

587: decode(l.pval084,cn,vn,vn,vn,
588: hr_pump_get.gl(l.pval084,'YES_NO',dn,l.pval106)) p84,
589: l.pval084 d84,
590: decode(l.pval085,cn,vn,vn,'N',
591: hr_pump_get.gl(l.pval085,'YES_NO',dn,l.pval106)) p85,
592: l.pval085 d85,
593: decode(l.pval086,cn,vn,vn,'RO',
594: hr_pump_get.gl(l.pval086,'IN_RESIDENTIAL_STATUS',dn,l.pval106)) p86,
595: l.pval086 d86,

Line 594: hr_pump_get.gl(l.pval086,'IN_RESIDENTIAL_STATUS',dn,l.pval106)) p86,

590: decode(l.pval085,cn,vn,vn,'N',
591: hr_pump_get.gl(l.pval085,'YES_NO',dn,l.pval106)) p85,
592: l.pval085 d85,
593: decode(l.pval086,cn,vn,vn,'RO',
594: hr_pump_get.gl(l.pval086,'IN_RESIDENTIAL_STATUS',dn,l.pval106)) p86,
595: l.pval086 d86,
596: decode(l.pval087,cn,vn,vn,vn,l.pval087) p87,
597: l.pval087 d87,
598: decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,

Line 660: hr_pump_get.get_person_type_id

656: c.p106 is null then
657: L_PERSON_TYPE_ID:=nn;
658: else
659: L_PERSON_TYPE_ID :=
660: hr_pump_get.get_person_type_id
661: (P_USER_PERSON_TYPE => c.p105
662: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
663: ,P_LANGUAGE_CODE => c.p106);
664: end if;

Line 670: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE

666: if c.p107 is null then
667: L_CORRESPONDENCE_LANGUAGE:=vn;
668: else
669: L_CORRESPONDENCE_LANGUAGE :=
670: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
671: (P_CORRESPONDENCE_LANGUAGE => c.p107);
672: end if;
673: --
674: if c.p108 is null then

Line 678: hr_pump_get.get_vendor_id

674: if c.p108 is null then
675: L_VENDOR_ID:=nn;
676: else
677: L_VENDOR_ID :=
678: hr_pump_get.get_vendor_id
679: (P_VENDOR_NAME => c.p108);
680: end if;
681: --
682: if c.p109 is null then

Line 686: hr_pump_get.get_benefit_group_id

682: if c.p109 is null then
683: L_BENEFIT_GROUP_ID:=nn;
684: else
685: L_BENEFIT_GROUP_ID :=
686: hr_pump_get.get_benefit_group_id
687: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
688: ,P_BENEFIT_GROUP => c.p109);
689: end if;
690: --