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

Line 400: hr_pump_get.gl(l.pval008,'HOME_OFFICE',d(l.pval001),l.pval099)) p8,

396: l.pval006 d6,
397: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
398: l.pval007 d7,
399: decode(l.pval008,cn,vn,vn,vn,
400: hr_pump_get.gl(l.pval008,'HOME_OFFICE',d(l.pval001),l.pval099)) p8,
401: l.pval008 d8,
402: decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,
403: l.pval009 d9,
404: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,

Line 407: hr_pump_get.gl(l.pval011,'MAR_STATUS',d(l.pval001),l.pval099)) p11,

403: l.pval009 d9,
404: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
405: l.pval010 d10,
406: decode(l.pval011,cn,vn,vn,vn,
407: hr_pump_get.gl(l.pval011,'MAR_STATUS',d(l.pval001),l.pval099)) p11,
408: l.pval011 d11,
409: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
410: l.pval012 d12,
411: decode(l.pval013,cn,vn,vn,vn,

Line 412: hr_pump_get.gl(l.pval013,'NATIONALITY',d(l.pval001),l.pval099)) p13,

408: l.pval011 d11,
409: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
410: l.pval012 d12,
411: decode(l.pval013,cn,vn,vn,vn,
412: hr_pump_get.gl(l.pval013,'NATIONALITY',d(l.pval001),l.pval099)) p13,
413: l.pval013 d13,
414: decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,
415: l.pval014 d14,
416: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,

Line 419: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',d(l.pval001),l.pval099)) p16,

415: l.pval014 d14,
416: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
417: l.pval015 d15,
418: decode(l.pval016,cn,vn,vn,vn,
419: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',d(l.pval001),l.pval099)) p16,
420: l.pval016 d16,
421: decode(l.pval017,cn,vn,vn,vn,
422: hr_pump_get.gl(l.pval017,'SEX',d(l.pval001),l.pval099)) p17,
423: l.pval017 d17,

Line 422: hr_pump_get.gl(l.pval017,'SEX',d(l.pval001),l.pval099)) p17,

418: decode(l.pval016,cn,vn,vn,vn,
419: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',d(l.pval001),l.pval099)) p16,
420: l.pval016 d16,
421: decode(l.pval017,cn,vn,vn,vn,
422: hr_pump_get.gl(l.pval017,'SEX',d(l.pval001),l.pval099)) p17,
423: l.pval017 d17,
424: decode(l.pval018,cn,vn,vn,vn,
425: hr_pump_get.gl(l.pval018,'TITLE',d(l.pval001),l.pval099)) p18,
426: l.pval018 d18,

Line 425: hr_pump_get.gl(l.pval018,'TITLE',d(l.pval001),l.pval099)) p18,

421: decode(l.pval017,cn,vn,vn,vn,
422: hr_pump_get.gl(l.pval017,'SEX',d(l.pval001),l.pval099)) p17,
423: l.pval017 d17,
424: decode(l.pval018,cn,vn,vn,vn,
425: hr_pump_get.gl(l.pval018,'TITLE',d(l.pval001),l.pval099)) p18,
426: l.pval018 d18,
427: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
428: l.pval019 d19,
429: decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,

Line 504: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval099)) p57,

500: l.pval055 d55,
501: decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
502: l.pval056 d56,
503: decode(l.pval057,cn,vn,vn,vn,
504: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval099)) p57,
505: l.pval057 d57,
506: decode(l.pval058,cn,dn,vn,dn,d(l.pval058)) p58,
507: l.pval058 d58,
508: decode(l.pval059,cn,nn,vn,nn,n(l.pval059)) p59,

Line 525: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval099)) p67,

521: l.pval065 d65,
522: decode(l.pval066,cn,dn,vn,dn,d(l.pval066)) p66,
523: l.pval066 d66,
524: decode(l.pval067,cn,vn,vn,vn,
525: hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval099)) p67,
526: l.pval067 d67,
527: decode(l.pval068,cn,dn,vn,dn,d(l.pval068)) p68,
528: l.pval068 d68,
529: decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,

Line 532: hr_pump_get.gl(l.pval070,'WORK_SCHEDULE',d(l.pval001),l.pval099)) p70,

528: l.pval068 d68,
529: decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
530: l.pval069 d69,
531: decode(l.pval070,cn,vn,vn,vn,
532: hr_pump_get.gl(l.pval070,'WORK_SCHEDULE',d(l.pval001),l.pval099)) p70,
533: l.pval070 d70,
534: decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
535: l.pval071 d71,
536: decode(l.pval072,cn,dn,vn,dn,d(l.pval072)) p72,

Line 617: hr_pump_get.get_person_type_id

613: c.p99 is null then
614: L_PERSON_TYPE_ID:=nn;
615: else
616: L_PERSON_TYPE_ID :=
617: hr_pump_get.get_person_type_id
618: (P_USER_PERSON_TYPE => c.p98
619: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
620: ,P_LANGUAGE_CODE => c.p99);
621: end if;

Line 627: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE

623: if c.p100 is null then
624: L_CORRESPONDENCE_LANGUAGE:=vn;
625: else
626: L_CORRESPONDENCE_LANGUAGE :=
627: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
628: (P_CORRESPONDENCE_LANGUAGE => c.p100);
629: end if;
630: --
631: if c.p101 is null then

Line 635: hr_pump_get.get_benefit_group_id

631: if c.p101 is null then
632: L_BENEFIT_GROUP_ID:=nn;
633: else
634: L_BENEFIT_GROUP_ID :=
635: hr_pump_get.get_benefit_group_id
636: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
637: ,P_BENEFIT_GROUP => c.p101);
638: end if;
639: --

Line 644: hr_pump_get.get_vacancy_id

640: if c.p102 is null then
641: L_VACANCY_ID:=nn;
642: else
643: L_VACANCY_ID :=
644: hr_pump_get.get_vacancy_id
645: (P_VACANCY_USER_KEY => c.p102);
646: end if;
647: --
648: hr_data_pump.api_trc_on;