APPS.HRDPP_CREATE_MX_PERSON dependencies on HR_PUMP_GET

Line 316: hr_pump_get.gl(l.pval003,'SEX',dn,l.pval072)) p3,

312: select l.rowid myrowid,
313: decode(l.pval001,cn,dn,d(l.pval001)) p1,
314: decode(l.pval002,cn,vn,l.pval002) p2,
315: decode(l.pval003,cn,vn,
316: hr_pump_get.gl(l.pval003,'SEX',dn,l.pval072)) p3,
317: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
318: l.pval004 d4,
319: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
320: l.pval005 d5,

Line 326: hr_pump_get.gl(l.pval008,'HOME_OFFICE',dn,l.pval072)) p8,

322: l.pval006 d6,
323: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
324: l.pval007 d7,
325: decode(l.pval008,cn,vn,vn,vn,
326: hr_pump_get.gl(l.pval008,'HOME_OFFICE',dn,l.pval072)) p8,
327: l.pval008 d8,
328: decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,
329: l.pval009 d9,
330: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,

Line 333: hr_pump_get.gl(l.pval011,'MAR_STATUS',dn,l.pval072)) p11,

329: l.pval009 d9,
330: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
331: l.pval010 d10,
332: decode(l.pval011,cn,vn,vn,vn,
333: hr_pump_get.gl(l.pval011,'MAR_STATUS',dn,l.pval072)) p11,
334: l.pval011 d11,
335: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
336: l.pval012 d12,
337: decode(l.pval013,cn,vn,vn,vn,

Line 338: hr_pump_get.gl(l.pval013,'NATIONALITY',dn,l.pval072)) p13,

334: l.pval011 d11,
335: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
336: l.pval012 d12,
337: decode(l.pval013,cn,vn,vn,vn,
338: hr_pump_get.gl(l.pval013,'NATIONALITY',dn,l.pval072)) p13,
339: l.pval013 d13,
340: decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,
341: l.pval014 d14,
342: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,

Line 345: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',dn,l.pval072)) p16,

341: l.pval014 d14,
342: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
343: l.pval015 d15,
344: decode(l.pval016,cn,vn,vn,vn,
345: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',dn,l.pval072)) p16,
346: l.pval016 d16,
347: decode(l.pval017,cn,vn,vn,vn,
348: hr_pump_get.gl(l.pval017,'TITLE',dn,l.pval072)) p17,
349: l.pval017 d17,

Line 348: hr_pump_get.gl(l.pval017,'TITLE',dn,l.pval072)) p17,

344: decode(l.pval016,cn,vn,vn,vn,
345: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',dn,l.pval072)) p16,
346: l.pval016 d16,
347: decode(l.pval017,cn,vn,vn,vn,
348: hr_pump_get.gl(l.pval017,'TITLE',dn,l.pval072)) p17,
349: l.pval017 d17,
350: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
351: l.pval018 d18,
352: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,

Line 485: hr_pump_get.get_person_type_id

481: c.p72 is null then
482: L_PERSON_TYPE_ID:=nn;
483: else
484: L_PERSON_TYPE_ID :=
485: hr_pump_get.get_person_type_id
486: (P_USER_PERSON_TYPE => c.p71
487: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
488: ,P_LANGUAGE_CODE => c.p72);
489: end if;

Line 495: hr_pump_get.get_vendor_id

491: if c.p73 is null then
492: L_VENDOR_ID:=nn;
493: else
494: L_VENDOR_ID :=
495: hr_pump_get.get_vendor_id
496: (P_VENDOR_NAME => c.p73);
497: end if;
498: --
499: if c.p74 is null then

Line 503: hr_pump_get.get_benefit_group_id

499: if c.p74 is null then
500: L_BENEFIT_GROUP_ID:=nn;
501: else
502: L_BENEFIT_GROUP_ID :=
503: hr_pump_get.get_benefit_group_id
504: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
505: ,P_BENEFIT_GROUP => c.p74);
506: end if;
507: --