APPS.HRDPP_UPDATE_PLAN_BENEFICIARY dependencies on HR_PUMP_GET

Line 275: hr_pump_get.gl(l.pval003,'BEN_PRMRY_CNTNGNT',d(l.pval041),l.pval048)) p3,

271: select l.rowid myrowid,
272: decode(l.pval001,cn,dn,d(l.pval001)) p1,
273: decode(l.pval002,cn,dn,d(l.pval002)) p2,
274: decode(l.pval003,cn,vn,vn,vh,
275: hr_pump_get.gl(l.pval003,'BEN_PRMRY_CNTNGNT',d(l.pval041),l.pval048)) p3,
276: l.pval003 d3,
277: decode(l.pval004,cn,nn,vn,nh,n(l.pval004)) p4,
278: l.pval004 d4,
279: decode(l.pval005,cn,nn,vn,nh,n(l.pval005)) p5,

Line 417: hr_pump_get.get_pl_bnf_id

413: if c.p44 is null then
414: L_PL_BNF_ID:=nn;
415: else
416: L_PL_BNF_ID :=
417: hr_pump_get.get_pl_bnf_id
418: (P_PL_BNF_USER_KEY => c.p44);
419: end if;
420: --
421: if c.d45=cn then

Line 427: hr_pump_get.get_prtt_enrt_rslt_id

423: elsif c.d45 is null then
424: L_PRTT_ENRT_RSLT_ID:=nh;
425: else
426: L_PRTT_ENRT_RSLT_ID :=
427: hr_pump_get.get_prtt_enrt_rslt_id
428: (P_PRTT_ENRT_RSLT_USER_KEY => c.p45);
429: end if;
430: --
431: if c.d46=cn then

Line 437: hr_pump_get.get_bnf_person_id

433: elsif c.d46 is null then
434: L_BNF_PERSON_ID:=nh;
435: else
436: L_BNF_PERSON_ID :=
437: hr_pump_get.get_bnf_person_id
438: (P_BNF_PERSON_USER_KEY => c.p46);
439: end if;
440: --
441: if c.d47=cn or

Line 450: hr_pump_get.get_organization_id

446: c.d48 is null then
447: L_ORGANIZATION_ID:=nh;
448: else
449: L_ORGANIZATION_ID :=
450: hr_pump_get.get_organization_id
451: (P_ORGANIZATION_NAME => c.p47
452: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
453: ,P_EFFECTIVE_DATE => c.p41
454: ,P_LANGUAGE_CODE => c.p48);

Line 463: hr_pump_get.get_ttee_person_id

459: elsif c.d49 is null then
460: L_TTEE_PERSON_ID:=nh;
461: else
462: L_TTEE_PERSON_ID :=
463: hr_pump_get.get_ttee_person_id
464: (P_TTEE_PERSON_USER_KEY => c.p49);
465: end if;
466: --
467: if c.d50=cn or

Line 474: hr_pump_get.GET_AMT_DSGD_UOM_CODE

470: elsif c.d50 is null then
471: L_AMT_DSGD_UOM:=vh;
472: else
473: L_AMT_DSGD_UOM :=
474: hr_pump_get.GET_AMT_DSGD_UOM_CODE
475: (P_AMT_DSGD_UOM => c.p50
476: ,P_EFFECTIVE_DATE => c.p41);
477: end if;
478: --

Line 480: hr_pump_get.get_request_id;

476: ,P_EFFECTIVE_DATE => c.p41);
477: end if;
478: --
479: L_REQUEST_ID :=
480: hr_pump_get.get_request_id;
481: --
482: L_PROGRAM_APPLICATION_ID :=
483: hr_pump_get.get_program_application_id;
484: --

Line 483: hr_pump_get.get_program_application_id;

479: L_REQUEST_ID :=
480: hr_pump_get.get_request_id;
481: --
482: L_PROGRAM_APPLICATION_ID :=
483: hr_pump_get.get_program_application_id;
484: --
485: L_PROGRAM_ID :=
486: hr_pump_get.get_program_id;
487: --

Line 486: hr_pump_get.get_program_id;

482: L_PROGRAM_APPLICATION_ID :=
483: hr_pump_get.get_program_application_id;
484: --
485: L_PROGRAM_ID :=
486: hr_pump_get.get_program_id;
487: --
488: if c.p44 is null or
489: c.p41 is null then
490: L_OBJECT_VERSION_NUMBER:=nn;

Line 493: hr_pump_get.GET_PL_BNF_OVN

489: c.p41 is null then
490: L_OBJECT_VERSION_NUMBER:=nn;
491: else
492: L_OBJECT_VERSION_NUMBER :=
493: hr_pump_get.GET_PL_BNF_OVN
494: (P_PL_BNF_USER_KEY => c.p44
495: ,P_EFFECTIVE_DATE => c.p41);
496: end if;
497: --

Line 504: hr_pump_get.get_per_in_ler_id

500: elsif c.d51 is null then
501: L_PER_IN_LER_ID:=nh;
502: else
503: L_PER_IN_LER_ID :=
504: hr_pump_get.get_per_in_ler_id
505: (P_PER_IN_LER_USER_KEY => c.p51);
506: end if;
507: --
508: hr_data_pump.api_trc_on;