APPS.HRDPP_CREATE_PERSON dependencies on HR_PUMP_GET

Line 406: hr_pump_get.gl(l.pval003,'SEX',dn,l.pval102)) p3,

402: select l.rowid myrowid,
403: decode(l.pval001,cn,dn,d(l.pval001)) p1,
404: decode(l.pval002,cn,vn,l.pval002) p2,
405: decode(l.pval003,cn,vn,
406: hr_pump_get.gl(l.pval003,'SEX',dn,l.pval102)) p3,
407: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
408: l.pval004 d4,
409: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
410: l.pval005 d5,

Line 416: hr_pump_get.gl(l.pval008,'HOME_OFFICE',dn,l.pval102)) p8,

412: l.pval006 d6,
413: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
414: l.pval007 d7,
415: decode(l.pval008,cn,vn,vn,vn,
416: hr_pump_get.gl(l.pval008,'HOME_OFFICE',dn,l.pval102)) p8,
417: l.pval008 d8,
418: decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,
419: l.pval009 d9,
420: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,

Line 423: hr_pump_get.gl(l.pval011,'MAR_STATUS',dn,l.pval102)) p11,

419: l.pval009 d9,
420: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
421: l.pval010 d10,
422: decode(l.pval011,cn,vn,vn,vn,
423: hr_pump_get.gl(l.pval011,'MAR_STATUS',dn,l.pval102)) p11,
424: l.pval011 d11,
425: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
426: l.pval012 d12,
427: decode(l.pval013,cn,vn,vn,vn,

Line 428: hr_pump_get.gl(l.pval013,'NATIONALITY',dn,l.pval102)) p13,

424: l.pval011 d11,
425: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
426: l.pval012 d12,
427: decode(l.pval013,cn,vn,vn,vn,
428: hr_pump_get.gl(l.pval013,'NATIONALITY',dn,l.pval102)) p13,
429: l.pval013 d13,
430: decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,
431: l.pval014 d14,
432: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,

Line 435: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',dn,l.pval102)) p16,

431: l.pval014 d14,
432: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
433: l.pval015 d15,
434: decode(l.pval016,cn,vn,vn,vn,
435: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',dn,l.pval102)) p16,
436: l.pval016 d16,
437: decode(l.pval017,cn,vn,vn,vn,
438: hr_pump_get.gl(l.pval017,'TITLE',dn,l.pval102)) p17,
439: l.pval017 d17,

Line 438: hr_pump_get.gl(l.pval017,'TITLE',dn,l.pval102)) p17,

434: decode(l.pval016,cn,vn,vn,vn,
435: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',dn,l.pval102)) p16,
436: l.pval016 d16,
437: decode(l.pval017,cn,vn,vn,vn,
438: hr_pump_get.gl(l.pval017,'TITLE',dn,l.pval102)) p17,
439: l.pval017 d17,
440: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
441: l.pval018 d18,
442: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,

Line 635: hr_pump_get.get_person_type_id

631: c.p102 is null then
632: L_PERSON_TYPE_ID:=nn;
633: else
634: L_PERSON_TYPE_ID :=
635: hr_pump_get.get_person_type_id
636: (P_USER_PERSON_TYPE => c.p101
637: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
638: ,P_LANGUAGE_CODE => c.p102);
639: end if;

Line 645: hr_pump_get.get_vendor_id

641: if c.p103 is null then
642: L_VENDOR_ID:=nn;
643: else
644: L_VENDOR_ID :=
645: hr_pump_get.get_vendor_id
646: (P_VENDOR_NAME => c.p103);
647: end if;
648: --
649: if c.p104 is null then

Line 653: hr_pump_get.get_benefit_group_id

649: if c.p104 is null then
650: L_BENEFIT_GROUP_ID:=nn;
651: else
652: L_BENEFIT_GROUP_ID :=
653: hr_pump_get.get_benefit_group_id
654: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
655: ,P_BENEFIT_GROUP => c.p104);
656: end if;
657: --